{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["CALCULATOR-GENERIC","ARMSTRONG COUNTY COMPARISON","Data","CLARION COUNTY COMPARISON"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"CALCULATOR-GENERIC","index":0,"n_rows":50,"n_cols":9,"rows_kept":50,"cut":false,"hidden":false,"merged":[[49,0,49,8],[19,1,19,8],[0,0,0,8],[1,0,1,8],[47,0,47,8],[20,1,20,8],[4,0,4,7],[8,0,9,7],[13,1,13,5]]}
["REDBANK VALLEY SCHOOL DISTRICT"]
["GENERIC REFERENDUM CALCULATOR"]
[]
[]
["Sheet is Protected - You can only enter in the shaded boxes"]
[]
["STEP 1:","SELECT YOUR COUNTY",null,null,null,null,null,"ARMSTRONG"]
[]
[{"$f":"IF(H12>25000,\"CAUTION - THE ASSESSED VALUE YOU HAVE ENTERED IS HIGHER THAN THE AVERAGE ASSESSED VALUE IN THE DISTRICT- PLEASE CONFIRM YOU ARE USING YOUR CORRECT ASSESSED VALUE\",\"  \")","v":"  "}]
[]
[]
["STEP 2:","ENTER YOUR ASSESSED VALUE (FROM PROPERTY RECORDS)"]
[]
[null,"YOU CAN ESTIMATE YOUR ASSESSED VALUE BELOW BY USING YOUR JULY 1, 2019 TAX BILL!"]
[null,null,null,"CLARION",null,"ARMSTRONG"]
[null,"ENTER THE TOTAL TAX BILL (BEFORE HOMESTEAD/FARMSTEAD EXCLUSION)"]
[]
[null,"CALCULATED ASSESSED VALUE (ENTER THIS NUMBER ABOVE)",null,{"$f":"(D16*1000)/Data!B3","v":0},null,{"$f":"(F16*1000)/Data!B2","v":0}]
[]
[null,"(You may need to contact your tax collector or the assessment office, this DOES NOT MEAN FMV or your property's actual value.  It is based on the assessment standard used by the county your property is located in)"]
[null,"The Average Assessed Value by County are  Clarion(1975 Values) - $14,398 & Armstrong (1996 Values) $22,803"]
[]
["STEP 3:","RESULTS"]
[null,null,null,"Current Tax Bill",null,"Referendum Tax Bill",null,"Annual Amount of Increase"]
[null,null,"Millage Rate",{"$f":"LOOKUP(H7,Data!A2:A3,Data!B2:B3)","v":24.722899999999999},null,{"$f":"LOOKUP(H7,Data!A2:A3,Data!C2:C3)","v":35.4056}]
[]
[null,null,"Assessed Value (From Above)",{"$f":"H12","v":0},null,{"$f":"H12","v":0}]
[]
[null,null,"(Millage Rate/1000)",{"$f":"D25/1000","v":2.4722899999999999E-2},null,{"$f":"F25/1000","v":3.5405600000000002E-2}]
[]
[null,null,"Tax @ Face Amount",{"$f":"D27*D29","v":0},null,{"$f":"F27*F29","v":0},null,{"$f":"F31-D31","v":0}]
[]
["STEP 4:","COMPARISON WITH OTHER COUNTY SCHOOLS"]
[null,null,"CURRENT TAX RATES","CALCULATED TAX BILL BASED CURRENT RATES","Rank","REFERENDUM TAX Rates",null,"CALCULATED TAX BILL BASED PROPOSED RATES","Rank"]
["CLARION"]
[null,{"$f":"IF($H$7=Data!$A$3,'CLARION COUNTY COMPARISON'!A3,\"-\")","v":"-"},{"$f":"LOOKUP(B36,'CLARION COUNTY COMPARISON'!A3:A8,'CLARION COUNTY COMPARISON'!B3:B8)","v":{"$error":"#N/A"}},{"$f":"($H$12/1000)*C36","v":{"$error":"#N/A"}},{"$f":"RANK(D36,$D$36:$D$42)","v":{"$error":"#N/A"}},{"$f":"LOOKUP(B36,'CLARION COUNTY COMPARISON'!A3:A9,'CLARION COUNTY COMPARISON'!F3:F9)","v":{"$error":"#N/A"}},null,{"$f":"($H$12/1000)*F36","v":{"$error":"#N/A"}},{"$f":"RANK(H36,$H$36:$H$42)","v":{"$error":"#N/A"}}]
[null,{"$f":"IF($H$7=Data!$A$3,'CLARION COUNTY COMPARISON'!A4,\"-\")","v":"-"},{"$f":"LOOKUP(B37,'CLARION COUNTY COMPARISON'!A4:A9,'CLARION COUNTY COMPARISON'!B4:B9)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$f":"RANK(D37,$D$36:$D$42)","v":{"$error":"#N/A"}},{"$f":"LOOKUP('CALCULATOR-GENERIC'!B37,'CLARION COUNTY COMPARISON'!A4:A9,'CLARION COUNTY COMPARISON'!F4:F9)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},{"$f":"RANK(H37,$H$36:$H$42)","v":{"$error":"#N/A"}}]
[null,{"$f":"IF($H$7=Data!$A$3,'CLARION COUNTY COMPARISON'!A5,\"-\")","v":"-"},{"$f":"LOOKUP(B38,'CLARION COUNTY COMPARISON'!A5:A10,'CLARION COUNTY COMPARISON'!B5:B10)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"LOOKUP('CALCULATOR-GENERIC'!B38,'CLARION COUNTY COMPARISON'!A5:A10,'CLARION COUNTY COMPARISON'!F5:F10)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,{"$f":"IF($H$7=Data!$A$3,'CLARION COUNTY COMPARISON'!A6,\"-\")","v":"-"},{"$f":"LOOKUP(B39,'CLARION COUNTY COMPARISON'!A6:A11,'CLARION COUNTY COMPARISON'!B6:B11)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"LOOKUP('CALCULATOR-GENERIC'!B39,'CLARION COUNTY COMPARISON'!A6:A11,'CLARION COUNTY COMPARISON'!F6:F11)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,{"$f":"IF($H$7=Data!$A$3,'CLARION COUNTY COMPARISON'!A7,\"-\")","v":"-"},{"$f":"LOOKUP(B40,'CLARION COUNTY COMPARISON'!A7:A12,'CLARION COUNTY COMPARISON'!B7:B12)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"LOOKUP('CALCULATOR-GENERIC'!B40,'CLARION COUNTY COMPARISON'!A7:A12,'CLARION COUNTY COMPARISON'!F7:F12)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,{"$f":"IF($H$7=Data!$A$3,'CLARION COUNTY COMPARISON'!A8,\"-\")","v":"-"},{"$f":"LOOKUP(B41,'CLARION COUNTY COMPARISON'!A7:A13,'CLARION COUNTY COMPARISON'!B7:B13)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"LOOKUP('CALCULATOR-GENERIC'!B41,'CLARION COUNTY COMPARISON'!A8:A13,'CLARION COUNTY COMPARISON'!F8:F13)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[null,{"$f":"IF($H$7=Data!$A$3,'CLARION COUNTY COMPARISON'!A9,\"-\")","v":"-"},{"$f":"LOOKUP(B42,'CLARION COUNTY COMPARISON'!A8:A14,'CLARION COUNTY COMPARISON'!B8:B14)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$f":"LOOKUP('CALCULATOR-GENERIC'!B42,'CLARION COUNTY COMPARISON'!A9:A14,'CLARION COUNTY COMPARISON'!F9:F14)","v":{"$error":"#N/A"}},null,{"$error":"#N/A"},{"$error":"#N/A"}]
[]
["ARMSTRONG"]
[null,{"$f":"IF($H$7=Data!$A$2,'ARMSTRONG COUNTY COMPARISON'!A3,\"-\")","v":"Armstrong School District"},{"$f":"LOOKUP(B45,'ARMSTRONG COUNTY COMPARISON'!A3:A4,'ARMSTRONG COUNTY COMPARISON'!B3:B4)","v":58.95},{"$f":"($H$12/1000)*C45","v":0},{"$f":"RANK(D45,$D$45:$D$46)","v":1},{"$f":"LOOKUP(B45,'ARMSTRONG COUNTY COMPARISON'!A3:A4,'ARMSTRONG COUNTY COMPARISON'!F3:F4)","v":58.95},null,{"$f":"($H$12/1000)*F45","v":0},{"$f":"RANK(H45,$H$45:$H$46)","v":1}]
[null,{"$f":"IF($H$7=Data!$A$2,'ARMSTRONG COUNTY COMPARISON'!A4,\"-\")","v":"Redbank Valley School District"},{"$f":"LOOKUP(B46,'ARMSTRONG COUNTY COMPARISON'!A4:A5,'ARMSTRONG COUNTY COMPARISON'!B4:B5)","v":24.722899999999999},{"$f":"($H$12/1000)*C46","v":0},{"$f":"RANK(D46,$D$45:$D$46)","v":1},{"$f":"LOOKUP(B46,'ARMSTRONG COUNTY COMPARISON'!A4:A5,'ARMSTRONG COUNTY COMPARISON'!F4:F5)","v":35.4056},null,{"$f":"($H$12/1000)*F46","v":0},{"$f":"RANK(H46,$H$45:$H$46)","v":1}]
[]
["***Above numbers assume no tax increases for any of the other districts***"]
[]
["This calculator is being provided for informational purposes only - This is not an official record"]

{"sheet":"ARMSTRONG COUNTY COMPARISON","index":1,"n_rows":4,"n_cols":8,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["ARMSTRONG COUNTY"]
["School District","Current Millage","Average Assessed Value","Current Face Value of RE Tax Bill","Current Rank","Proposed Millage","Proposed Face Value of RE Tax Bill","Proposed Rank"]
["Armstrong School District",58.95,null,null,null,58.95]
["Redbank Valley School District",24.722899999999999,null,null,null,35.4056]

{"sheet":"Data","index":2,"n_rows":3,"n_cols":3,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
["COUNTY","CURRENT MILLAGE","PROPOSED MILLAGE"]
["ARMSTRONG",24.722899999999999,35.4056]
["CLARION",33.749699999999997,52.313200000000002]

{"sheet":"CLARION COUNTY COMPARISON","index":3,"n_rows":9,"n_cols":8,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
["CLARION COUNTY"]
["School District","Current Millage","Average Assessed Value","Current Face Value of RE Tax Bill","Current Rank","Proposed Millage","Proposed Face Value of RE Tax Bill","Proposed Rank"]
["Allegheny-Clarion Valley School District",58.16,16084,{"$f":"(C3/1000)*B3","v":935.44543999999996},{"$f":"RANK(D3,$D$3:$D$9)","v":3},58.16,{"$f":"(C3/1000)*F3","v":935.44543999999996},{"$f":"RANK(G3,$G$3:$G$9)","v":3}]
["Clarion Area School District",65.73,16084,1057.2013200000001,{"$f":"RANK(D4,$D$3:$D$9)","v":1},65.73,1057.2013200000001,{"$f":"RANK(G4,$G$3:$G$9)","v":1}]
["Clarion-Limeston District",60.55,16084,973.88619999999992,2,60.55,973.88619999999992,2]
["Keystone School District",51.578000000000003,16084,829.58055200000001,4,51.578000000000003,829.58055200000001,5]
["North Clarion School District",44.228200000000001,16084,711.36636880000003,6,44.228200000000001,711.36636880000003,7]
["Redbank Valley School District",33.749699999999997,16084,542.8301747999999,7,52.313200000000002,841.40550880000001,4]
["Union School District",50.508000000000003,16084,812.37067200000001,5,50.508000000000003,812.37067200000001,6]