{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":1,"comments":1,"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":"Sheet1","index":0,"n_rows":208,"n_cols":23,"rows_kept":208,"cut":false,"hidden":false,"merged":[[38,11,38,12],[49,11,49,12],[39,11,39,12],[41,11,41,12],[38,21,38,22],[39,21,39,22],[41,21,41,22],[19,11,19,12],[29,21,29,22],[30,21,30,22],[19,21,19,22],[22,21,22,22],[37,21,37,22],[22,11,22,12],[35,21,35,22],[23,21,23,22],[27,21,27,22],[28,21,28,22],[21,21,21,22],[31,21,31,22],[32,21,32,22],[33,21,33,22],[34,21,34,22],[36,21,36,22],[2,11,2,12],[5,11,5,12],[6,11,6,12],[7,11,7,12],[8,11,8,12],[15,11,15,12],[16,11,16,12],[21,11,21,12],[37,11,37,12],[32,11,32,12],[34,11,34,12],[17,11,17,12],[18,11,18,12],[23,11,23,12],[25,11,25,12],[26,11,26,12],[29,11,29,12],[30,11,30,12],[31,11,31,12],[35,11,35,12],[36,11,36,12],[33,11,33,12],[27,11,27,12],[28,11,28,12],[26,21,26,22],[2,21,2,22],[5,21,5,22],[6,21,6,22],[7,21,7,22],[8,21,8,22],[25,21,25,22],[15,21,15,22],[16,21,16,22],[17,21,17,22],[18,21,18,22],[171,6,171,8],[59,11,59,12],[42,11,42,12],[62,11,62,12],[42,21,42,22],[43,21,43,22],[45,21,45,22],[47,21,47,22],[45,11,45,12],[50,11,50,12],[47,11,47,12],[58,11,58,12],[50,21,50,22],[51,21,51,22],[49,21,49,22],[51,11,51,12],[56,11,56,12],[43,11,43,12],[174,6,174,8],[81,21,81,22],[85,21,85,22],[56,21,56,22],[58,21,58,22],[59,21,59,22],[62,21,62,22],[172,18,172,19],[114,0,114,3],[64,11,64,12],[75,11,75,12],[81,11,81,12],[64,21,64,22],[75,21,75,22],[91,0,91,5],[89,21,89,22],[85,11,85,12],[89,11,89,12],[171,13,171,15],[172,13,172,15],[103,20,103,21],[104,20,104,21],[105,20,105,21],[105,11,105,12],[172,16,172,17],[174,13,174,15],[168,15,168,16],[175,13,175,15],[178,13,178,15],[186,0,186,1],[179,13,179,15],[180,13,180,15],[181,13,181,15],[176,0,176,1],[176,2,176,3],[178,16,178,17],[175,16,175,17],[173,16,173,17],[174,16,174,17],[177,4,177,5],[173,4,173,5],[173,13,173,15],[176,16,176,17],[176,13,176,15],[175,6,175,8],[176,6,176,8],[177,6,177,8],[173,6,173,8],[176,4,176,5],[177,13,177,15],[179,5,179,6],[186,2,186,3],[186,4,186,5],[186,7,186,8],[175,2,175,3],[177,2,177,3],[181,18,181,19],[181,16,181,17],[179,16,179,17],[179,18,179,19],[180,16,180,17],[180,18,180,19],[175,4,175,5],[177,16,177,17],[183,13,183,15],[184,13,184,15],[185,13,185,15],[188,2,188,3],[187,0,187,1],[191,0,191,1],[191,2,191,3],[191,4,191,5],[191,6,191,8],[188,4,188,5],[187,4,187,5],[190,0,190,1],[190,2,190,3],[190,4,190,5],[188,0,188,1],[187,2,187,3],[187,6,187,8],[172,20,172,22],[171,18,171,19],[173,20,173,22],[170,21,170,22],[132,20,132,21],[188,6,188,8],[189,0,189,1],[189,2,189,3],[189,4,189,5],[168,2,168,3],[171,4,171,5],[171,2,171,3],[173,0,173,1],[177,0,177,1],[175,0,175,1],[174,0,174,1],[174,2,174,3],[177,20,177,22],[179,2,179,4],[170,9,170,10],[186,16,186,17],[178,18,178,19],[178,20,178,22],[174,4,174,5],[173,2,173,3],[181,20,181,22],[179,20,179,22],[180,20,180,22],[175,20,175,22],[201,16,201,17],[195,20,195,22],[195,18,195,19],[196,18,196,19],[196,20,196,22],[197,18,197,19],[197,20,197,22],[198,18,198,19],[194,18,194,19],[194,16,194,17],[195,16,195,17],[196,16,196,17],[197,16,197,17],[198,16,198,17],[182,13,182,15],[198,20,198,22],[199,18,199,19],[190,6,190,8],[189,6,189,8],[199,20,199,22],[200,18,200,19],[200,20,200,22],[182,16,182,17],[182,18,182,19],[182,20,182,22],[199,16,199,17],[200,16,200,17],[173,18,173,19],[174,20,174,22],[175,18,175,19],[176,18,176,19],[177,18,177,19],[176,20,176,22],[174,18,174,19],[183,16,183,17],[183,18,183,19],[183,20,183,22],[184,16,184,17],[184,18,184,19],[184,20,184,22],[185,16,185,17],[185,18,185,19],[185,20,185,22]]}
[null,null,null,null,"2022 Brush Country GCD Effective Tax Rate and Tax Rollover Worksheet",null,null,null,null,null,null,null,null,"2022 Brush Country GCD Effective Tax Rate and Tax Rollover Worksheet"]
[null,null,null,null,null,null,null,"Brooks","Jim Hogg","Jim wells","Hidalgo","total",null,null,null,null,null,null,null,null,null,"total"]
[1,"2021 total Taxable value",null,null,null,null,null,433439633,446018450,1393120800,2807296,{"$f":"SUM($H$3:$K$3)","v":2275386179},null,1,"2021 total Taxable value",null,null,null,null,null,null,{"$f":"SUM($H$3:$K$3)","v":2275386179}]
[null,null,null,null,null,null,null," ",null," "]
[2,"2021 Tax Ceilings School Districts",null,null,null,null,null," ",null,null,null,null,null,2,"2021 Tax Ceilings School Districts"]
[null,null,"2021 taxable value over 65 homestead w/tax ceiling",null,null,null,null,0,0,0,0,{"$f":"SUM($H$6:$K$6)","v":0},null,null,null,"2021 taxable value over 65 homestead w/tax ceiling",null,null,null,null,null,{"$f":"SUM($H$6:$K$6)","v":0}]
[null,null,"2021 over 65 tax ceiling or actual tax(if available)",null,null,null,null,0,0,0,0,{"$f":"SUM($H$7:$K$7)","v":0},null,null,null,"2021 over 65 tax ceiling or actual tax(if available)",null,null,null,null,null,{"$f":"SUM($H$7:$K$7)","v":0}]
[null,null,null,null,null,null,null,null,null,null,"total",{"$f":"$L$6+$L$7","v":0},null,null,null,null,null,null,null,null,null,{"$f":"$L$6+$L$7","v":0}]
[3,"Preliminary 2021 Adjusted tax rate  subtract line 2 form 1",null,null,null,null,null,null,null,null,null,{"$f":"$L$3-$L$8","v":2275386179},null,3,"Preliminary 2021 Adjusted tax rate  subtract line 2 form 1",null,null,null,null,null,null,{"$f":"V3-V8","v":2275386179}]
[null,null,null,null,null,null,null,"                --","                --","                --","                --","                --",null,null,null,null,null,null,null,null,"                --","                --"]
[4,"2021 adopted tax M & O Tax Rate",null,null,null,null,null,"                --","                --","                --","                --",1.6E-2," /$100",4,"2021 adopted tax M & O Tax Rate",null,null,null,null,null,"                --",1.6E-2," /$100"]
[null,"2021 IRS Tax Rate",null,null,null,null,null,"                --","                --","                --","                --",null,null,null,"2021 IRS Tax Rate",null,null,null,null,null,"                --"]
[null,"Total Rate",null,null,null,null,null,0,null,null,null,1.6E-2," /$100",null,"Total Rate",null,null,null,null,null,null,1.6E-2," /$100"]
[]
[5,"2021 value lost due to court appeals",null,null,null,null,null,"                --","                --","                --","                --","                --",null,5,"2021 value lost due to court appeals",null,null,null,null,null,"                --","                --"]
[null,"A.  original 2021 ARB Value",null,null,null,null,null,null,null,null,null,0,null,null,"A.  original 2021 ARB Value",null,null,null,null,null,null,0]
[null,"B.  2021 value loss resulting from final court decisions",null,null,null,null,null,null,null,null,null,0,null,null,"B.  2021 value loss resulting from final court decisions",null,null,null,null,null,null,0]
[null,"C.  2021 Value loss subtract B from A",null,null,null,null,null,0,{"$f":"I16-I17","v":0},{"$f":"J16-J17","v":0},{"$f":"K16-K17","v":0},{"$f":"$L$16-$L$17","v":0},null,null,"C.  2021 Value loss subtract B from A",null,null,null,null,null,null,{"$f":"$L$16-$L$17","v":0}]
[6,"2021 taxable value adjusted for court  reduction add 3 & 5c",null,null,null,null,null,null,null,null,null,{"$f":"$L$9+$L$18","v":2275386179},null,6,"2021 taxable value adjusted for court  reduction add 3 & 5c",null,null,null,null,null,null,{"$f":"$V$9+$V$18","v":2275386179}]
[7,"2021 tax value lost through de-annex after Jan 1, 2021",null,null,null,null,null,null,null,null,null,{"$f":"SUM($H$20:$K$20)","v":0},null,7,"2021 tax value lost through de-annex after Jan 1, 2021",null,null,null,null,null,null,{"$f":"SUM($H$20:$K$20)","v":0}]
[8,"2021 tax value lost due to property exempt qualify in 2022",null,null,null,null,null,"                --","                --","                --","                --","                --",null,8,"2021 tax value lost due to property exempt qualify in 2021",null,null,null,null,null,"                --","                --",0]
[null,"A.  absolute exemptions use 2021 market value",null,null,null,null,null,735010,36490,359059,0,{"$f":"SUM($H$22:$K$22)","v":1130559},null,null,"A.  absolute exemptions use 2021 market value",null,null,null,null,null,null,{"$f":"SUM($H$22:$K$22)","v":1130559}]
[null,"B.  partial exemptions 2022 exemp or 2022% times 2021 value",null,null,null,null,null,155017,362960,4276601,0,{"$f":"SUM($H$23:$K$23)","v":4794578},null,null,"B.  partial exemptions 2022 exemp or 2022% times 2021 value",null,null,null,null,null,null,{"$f":"SUM($H$23:$K$23)","v":4794578}]
[null,"C.  value loss A + B",null,null,null,null,null,{"$f":"H22+H23","v":890027},{"$f":"I22+I23","v":399450},{"$f":"J22+J23","v":4635660},{"$f":"K22+K23","v":0},{"$f":"SUM($H$24:$K$24)","v":5925137},null,null,"C.  value loss A + B",null,null,null,null,null,null,{"$f":"SUM($H$24:$K$24)","v":5925137}]
[9,"2021 tax value lost due to first qualified for ag or special app",null,null,null,null,null,"                --","                --","                --","                --","                --",null,9,"2021 tax value lost due to first qualified for ag or special app",null,null,null,null,null,"                --","                --"]
[null,"a.  2021 Market value",null,null,null,null,null,7677684,0,2579848,0,{"$f":"SUM($H$26:$K$26)","v":10257532},null,null,"a.  2021 Market value",null,null,null,null,null,null,{"$f":"L26","v":10257532}]
[null,"b.  2022 productivity or special appraised value",null,null,null,null,null,652977,0,244837,0,{"$f":"SUM($H$27:$K$27)","v":897814},null,null,"b.  2022 productivity or special appraisaed value",null,null,null,null,null,null,{"$f":"L27","v":897814}]
[null,"c.  Value lost subtract B from A",null,null,null,null,null,{"$f":"H26-H27","v":7024707},{"$f":"I26-I27","v":0},2609292,{"$f":"K26-K27","v":0},{"$f":"$L$26-$L$27","v":9359718},null,null,"c.  Value lost subtract B from A",null,null,null,null,null,null,{"$f":"$V$26-$V$27","v":9359718}]
[10,"Total adjustments for lost value add lines 7, 8C & 9C",null,null,null,null,null,{"$f":"H20+H24+H28","v":7914734},{"$f":"I20+I24+I28","v":399450},{"$f":"J20+J24+J28","v":7244952},{"$f":"K20+K24+K28","v":0},{"$f":"$L$20+$L$24+$L$28","v":15284855},null,10,"Total adjustments for lost value add lines 7, 8C & 9C",null,null,null,null,null,null,{"$f":"$V$24+$V$28","v":15284855}]
[11,"2021 adjusted taxable value  subtract line 10 from line 6",null,null,null,null,null,"                --","                --","                --","                --",{"$f":"$L$19-$L$29","v":2260101324},null,11,"2021 adjusted taxable value  subtract line 10 from line 6",null,null,null,null,null,"                --",{"$f":"$V$19-$V$29","v":2260101324}]
[12,"Adjusted 2021 taxes multiply line 4 by line 11 and divide by $100",null,null,null,null,null,0,0,0,0,{"$f":"ROUNDDOWN($L$11*$L$30/100,0)","v":361616},null,12,"Adjusted 2021 taxes multiply line 4 by line 11 and divide by $100",null,null,null,null,null,"                --",{"$f":"ROUNDDOWN($V$11*$V$30/100,0)","v":361616}]
[13,"enter refunded taxes for buget year for taxes preceding 2021",null,null,null,null,null,0,0,23,0,{"$f":"SUM(H32:K32)","v":23},null,13,"enter refunded taxes for buget year for taxes preceding 2021",null,null,null,null,null,null,{"$f":"L32","v":23}]
[14,"Taxes in increment financing(TIF) for tax year 2021",null,null,null,null,null,0,0,0,0,{"$f":"SUM($H$33:$K$33)","v":0},null,14,"Taxes in increment financing(TIF) for tax year 2021",null,null,null,null,null,null,{"$f":"SUM($H$33:$K$33)","v":0}]
[15,"adjusted 2021 taxes with refund & TIF Adj add line 12&13-14",null,null,null,null,null,{"$f":"H31+H32+H33","v":0},{"$f":"I31+I32+I33","v":0},{"$f":"J31+J32+J33","v":23},{"$f":"K31+K32+K33","v":0},{"$f":"$L$31+$L$32-$L$33","v":361639},null,15,"adjusted 2021 taxes with refund & TIF Adj add line 12&13-14",null,null,null,null,null,"                --",{"$f":"V31+V32+V33","v":361639}]
[16,"Total 2022 taxable value on the 2022 certified roll today",null,null,null,null,null,"  --","  --","  --","  --","                --",null,16,"Total 2022 taxable value on the 2022 certified roll today",null,null,null,null,null,"                --","                --"]
[null,"A.  Certified Values",null,null,null,null,null,447314861,427739791,1474769538,2633723,{"$f":"SUM($H$36:$K$36)","v":2352457913},null,null,"A.  Certified Values",null,null,null,null,null,null,{"$f":"SUM($H$36:$K$36)","v":2352457913}]
[null,"B.  Counties: Railroad Rolling Stock",null,null,null,null,null,0,0,0,0,{"$f":"SUM($H$37:$K$37)","v":0},null,null,"B.  Counties: Railroad Rolling Stock",null,null,null,null,null,null,{"$f":"SUM($H$37:$K$37)","v":0}]
[null,"C.  Pollution Control Exemption",null,null,null,null,null,0,0,0,0,{"$f":"SUM($H$38:$K$38)","v":0},null,null,"C.  Pollution Control Exemption",null,null,null,null,null,null,{"$f":"SUM($H$38:$K$38)","v":0}]
[null,"D.  Tax Increment financing",null,null,null,null,null,0,0,0,0,{"$f":"SUM($H$39:$K$39)","v":0},null,null,"D.  Tax Increment financing",null,null,null,null,null,null,{"$f":"SUM($H$39:$K$39)","v":0}]
[null,"E.  Total 2022 value add A, thru D",null,null,null,null,null,{"$f":"SUM(H36:H39)","v":447314861},{"$f":"SUM(I36:I39)","v":427739791},{"$f":"SUM(J36:J39)","v":1474769538},{"$f":"SUM(K36:K39)","v":2633723},{"$f":"SUM($L$36:$L$39)","v":2352457913},null,null,"E.  Total 2022 value add A, thru D",null,null,null,null,null,null,{"$f":"SUM(V36:W39)","v":2352457913}]
[17,"Total Value of Properties under protest",null,null,null,null,null,"                --","                --","                --","                --","                --",null,17,"Total Value of Properties under protest",null,null,null,null,null,"                --","                --"]
[null,"A.  2022 taxable value of properties under protest",null,null,null,null,null,0,38580180,4670020,0,{"$f":"SUM($H$42:$K$42)","v":43250200},null,null,"A.  2022 taxable value of properties under protest",null,null,null,null,null,null,{"$f":"SUM($H$42:$K$42)","v":43250200}]
[null,"B.  2022 value of properties not under protest or included on app. Roll",null,null,null,null,null,0,0,0,0,{"$f":"SUM($H$43:$K$43)","v":0},null,null,"B.  2022 value of properties not under protest or included on app. Roll",null,null,null,null,null,null,{"$f":"SUM($H$43:$K$43)","v":0}]
[" ","C.  Total Value under protest or not certified add A & B",null,null,null,null,null,{"$f":"SUM(H42:H43)","v":0},{"$f":"SUM(I42:I43)","v":38580180},{"$f":"SUM(J42:J43)","v":4670020},{"$f":"SUM(K42:K43)","v":0},{"$f":"$L$42+$L$43","v":43250200},null," ","C.  Total Value under protest or not certified add A & B",null,null,null,null,null,null,{"$f":"V42+V43","v":43250200}]
[18,"2022 Tax ceilings",null,null,null,null,null,"                --","                --","                --","                --","                --",null,18,"2022 Tax ceilings",null,null,null,null,null,"                --","                --"]
[null,"      2022 taxable value over 65 homestead w/tax ceiling",null,null,null,null,null,0,0,0,0,{"$f":"SUM($H$46:$K$46)","v":0},null,null,"      2022 taxable value over 65 homestead w/tax ceiling",null,null,null,null,null,null,{"$f":"SUM($H$46:$K$46)","v":0}]
[null,"      2022 over 65 tax ceiling or actual tax(if available)",null,null,null,null,null,null,null,null,null,null,null,null,"      2022 over 65 tax ceiling or actual tax(if available)"]
[19,"2022 total taxable value add lines 16E &17C minus line 18",null,null,null,null,null,"                --","                --","                --","                --",{"$f":"$L$40+$L$44-$L$46","v":2395708113},null,19,"2022 total taxable value add lines 16E &17C minus line 18",null,null,null,null,null,"                --",{"$f":"V40+V44-V46","v":2395708113}]
[20,"Total 2022 taxable value of properties in territory annexed after jan 1,2021",null,null,null,null,null,0,0,0,0,{"$f":"SUM($H$49:$K$49)","v":0},null,20,"Total 2022 taxable value of properties in territory annexed after jan 1,2021",null,null,null,null,null,null,{"$f":"SUM($H$49:$K$49)","v":0}]
[21,"total 2022 tax value of new improve & new personal  prop in new Improv",null,null,null,null,null,7294368,3135610,15902915,0,{"$f":"SUM($H$50:$K$50)","v":26332893},null,21,"total 2022 tax value of new improve & new personal  prop in new Improv",null,null,null,null,null,null,{"$f":"SUM($H$50:$K$50)","v":26332893}]
[22,"total asjustments to the 2022 taxable value add lines20 & 21",null,null,null,null,null,{"$f":"H49+H50","v":7294368},{"$f":"I49+I50","v":3135610},{"$f":"J49+J50","v":15902915},{"$f":"K49+K50","v":0},{"$f":"$L$49+$L$50","v":26332893},null,22,"total asjustments to the 2022 taxable value add lines20 & 21",null,null,null,null,null,null,{"$f":"$L$49+$L$50","v":26332893}]
[23,"2022 adjusted taxable value subtract line 22 from line 19",null,null,null,null,null,"                --","                --","                --","                --",{"$f":"$L$48-$L$51","v":2369375220},null,23,"2022 adjusted taxable value subtract line 22 from line 19",null,null,null,null,null,"                --",{"$f":"$L$48-$L$51","v":2369375220}]
[24,"2022 effective tax rate divide line 15 by line 23 times 100",null,null,null,null,null,null,null,null,null,{"$f":"ROUNDDOWN($L$34/$L$52*100,6)","v":1.5263000000000001E-2}," /$100",24,"2022 effective tax rate divide line 15 by line 23 times 100",null,null,null,null,null,null,{"$f":"ROUNDDOWN($L$34/$L$52*100,6)","v":1.5263000000000001E-2}," /$100"]
[null,"Brooks County figure for line 21 comes from new value market column (page 26&27) of brooks countycertified tax values "]
[]
[26," 2021 maintenance and operations (M&O) tax rate.",null,null,null,null,null,null,null,null,null,{"$f":"L11","v":1.6E-2}," /$100",26," 2021 maintenance and operations (M&O) tax rate.",null,null,null,null,null,null,1.6E-2," /$100"]
[27," 2021 adjusted taxable value. Enter the amount from Line 11.",null,null,null,null,null,null,null,null,null,{"$f":"$L$30","v":2260101324},null,27," 2021 adjusted taxable value. Enter the amount from Line 11.",null,null,null,null,null,null,{"$f":"V30","v":2260101324}]
[28," 2021 M&O taxes.",null,null,null,null,null,null,null,null,null,null,null,28," 2021 M&O taxes."]
[null,"A. Multiply Line 26 by Line 27 and divide by $100.",null,null,null,null,null,null,null,null,null,{"$f":"ROUNDDOWN($L$56*$L$57/100,0)","v":361616},null,null,"A. Multiply Line 26 by Line 27 and divide by $100.",null,null,null,null,null,null,{"$f":"ROUNDDOWN(V57*V56/100,0)","v":361616}]
[null,"B. Cities, counties and hospital districts with additional sales tax: Amount of additional",null,null,null,null,null,null,null,null,null,{"$f":"SUM($H$60:$K$60)","v":0},null,null,"B. Cities, counties and hospital districts with additional sales tax: Amount of additional",null,null,null,null,null,null,{"$f":"SUM($H$60:$K$60)","v":0}]
[null," sales tax collected and spent on M&O expenses in 2021. Enter amount from full year's sales ",null,null,null,null,null,null,null,null,null,null,null,null," sales tax collected and spent on M&O expenses in 2021. Enter amount from full year's sales "]
[null,"tax revenue spent for M&O in 2021 fiscal year, if any. Other units enter 0. Counties exclude",null,null,null,null,null,null,null,null,null,null,null,null,"tax revenue spent for M&O in 2021 fiscal year, if any. Other units enter 0. Counties exclude"]
[null,"C. Counties: Enter the amount for the state criminal justice mandate. If second or later year,",null,null,null,null,null,null,null,null,null,{"$f":"SUM($H$63:$K$63)","v":0},null,null,"C. Counties: Enter the amount for the state criminal justice mandate. If second or later year,",null,null,null,null,null,null,{"$f":"SUM($H$63:$K$63)","v":0}]
[null," the amount is for increased cost above last year's amount. Other units enter \"0.\"",null,null,null,null,null,null,null,null,null,null,null,null," the amount is for increased cost above last year's amount. Other units enter \"0.\""]
[null,"D. Transferring function: If discontinuing all of a department, function or activity   ",null,null,null,null,null,null,null,null,null,{"$f":"SUM($H$65:$K$65)","v":0},null,null,"D. Transferring function: If discontinuing all of a department, function or activity   ",null,null,null,null,null,null,{"$f":"SUM($H$65:$K$65)","v":0}]
[null,"and transferring it to another unit by written contract, enter the amount spent by the unit",null,null,null,null,null,null,null,null,null,null,null,null,"and transferring it to another unit by written contract, enter the amount spent by the unit"]
[null,"discontinuing the function in the 12 months preceding the month of this calculation. If the",null,null,null,null,null,null,null,null,null,null,null,null,"discontinuing the function in the 12 months preceding the month of this calculation. If the"]
[null,"unit did not operate this function for this 12-month period, use the amount spent in the last ",null,null,null,null,null,null,null,null,null,null,null,null,"unit did not operate this function for this 12-month period, use the amount spent in the last "]
[null,"full fiscal year in which the unit operated the function. The unit discontinuing the function",null,null,null,null,null,null,null,null,null,null,null,null,"full fiscal year in which the unit operated the function. The unit discontinuing the function"]
[null," will subtract this amount in H below. The unit receiving the function will add this amount in",null,null,null,null,null,null,null,null,null,null,null,null," will subtract this amount in H below. The unit receiving the function will add this amount in"]
[null," H below. Other units enter 0.",null,null,null,null,null,null,null,null,null,null,null,null," H below. Other units enter 0."]
[]
[null,"Enter a negative value if discontinuing a function, or enter a positive value if receiving ",null,null,null,null,null,null,null,null,null,null,null,null,"Enter a negative value if discontinuing a function, or enter a positive value if receiving "]
[null,"the function.",null,null,null,null,null,null,null,null,null,null,null,null,"the function."]
[]
[null,"E. Taxes refunded for years preceding tax year 2021: Enter the amount of M&O taxes  ",null,null,null,null,null,null,null,null,null,{"$f":"L32","v":23},null,null,"E. Taxes refunded for years preceding tax year 2021: Enter the amount of M&O taxes  ",null,null,null,null,null,null,{"$f":"L76","v":23}]
[null,"refunded during the last budget year for tax years preceding tax year 2021. Types of refunds ",null,null,null,null,null,null,null,null,null,null,null,null,"refunded during the last budget year for tax years preceding tax year 2021. Types of refunds "]
[null,"include court decisions, Section 25.25(b) and (c) corrections and Section 31.11 payment ",null,null,null,null,null,null,null,null,null,null,null,null,"include court decisions, Section 25.25(b) and (c) corrections and Section 31.11 payment "]
[null,"errors. Do not include refunds for tax year 2021. This line applies only to tax years",null,null,null,null,null,null,null,null,null,null,null,null,"errors. Do not include refunds for tax year 2021. This line applies only to tax years"]
[null,"preceding tax year 2021",null,null,null,null,null,null,null,null,null,null,null,null,"preceding tax year 2021"]
[]
[null,"F. Enhanced indigent health care expenditures: Enter the increased amount for the  ",null,null,null,null,null,null,null,null,null,{"$f":"SUM($H$82:$K$82)","v":0},null,null,"F. Enhanced indigent health care expenditures: Enter the increased amount for the  ",null,null,null,null,null,null,{"$f":"SUM($H$82:$K$82)","v":0}]
[null,"current year's enhanced indigent health care expenditures above the preceding tax year's",null,null,null,null,null,null,null,null,null,null,null,null,"current year's enhanced indigent health care expenditures above the preceding tax year's"]
[null,"enhanced indigent health care expenditures, less any state assistance.",null,null,null,null,null,null,null,null,null,null,null,null,"enhanced indigent health care expenditures, less any state assistance."]
[]
[null,"G. Taxes in TIF: Enter the amount of taxes paid into the tax increment fund for a  .",null,null,null,null,null,null,null,null,null,{"$f":"SUM($H$86:$K$86)","v":0},null,null,"G. Taxes in TIF: Enter the amount of taxes paid into the tax increment fund for a  .",null,null,null,null,null,null,{"$f":"SUM($H$86:$K$86)","v":0}]
[null,"reinvestment zone as agreed by the taxing unit. If the unit has no 2022 captured appraised",null,null,null,null,null,null,null,null,null,null,null,null,"reinvestment zone as agreed by the taxing unit. If the unit has no 2022 captured appraised"]
[null,"value in Line 16D, enter 0",null,null,null,null,null,null,null,null,null,null,null,null,"value in Line 16D, enter 0"]
[]
[null,"H. Adjusted M&O Taxes. Add A, B, C, E and F. For unit with D, subtract if discontinuing ",null,null,null,null,null,null,null,null,null,{"$f":"$L$59+$L$60+$L$63+$L$76+$L$82","v":361639},null,null,"H. Adjusted M&O Taxes. Add A, B, C, E and F. For unit with D, subtract if discontinuing ",null,null,null,null,null,null,{"$f":"V59+V60+V63+V76+V82","v":361639}]
[null,"function and add if receiving function. Subtract G.",null,null,null,null,null,null,null,null,null,null,null,null,"function and add if receiving function. Subtract G."]
["2022 Property Tax Rates in Brush Country Groundwater Conservation District",null,null,null,null,null,null,null,null,null,null,null,null,"2022 Property Tax Rates in Brush Country Groundwater Conservation District"]
[]
["This notice concerns the 2022 property tax rates for Brush Country Groundwater Conservation ",null,null,null,null,null,null,null,null,null,null,null,null,"This notice concerns the 2022 property tax rates for Brush Country Groundwater Conservation "]
["District. It presents information about three tax rates.  Last year's tax rate is the actual tax rate",null,null,null,null,null,null,null,null,null,null,null,null,"District. It presents information about three tax rates.  Last year's tax rate is the actual tax rate"]
["the taxing unit used to determine property taxes last year. This year's tax rate would",null,null,null,null,null,null,null,null,null,null,null,null,"the taxing unit used to determine property taxes last year. This year's tax rate would"]
["impose tile same total taxes as last year if you compare properties taxed in both years. This ",null,null,null,null,null,null,null,null,null,null,null,null,"impose the same total taxes as last year if you compare properties taxed in both years. This "]
["year's rollback tax rate is the highest tax rate the taxing unit can set before taxpayers start ",null,null,null,null,null,null,null,null,null,null,null,null,"year's rollback tax rate is the highest tax rate the taxing unit can set before taxpayers start "]
["rollback procedures. In each case these rates are found by dividing the total amount of taxes by ",null,null,null,null,null,null,null,null,null,null,null,null,"rollback procedures. In each case these rates are found by dividing the total amount of taxes by "]
["the tax base (the total value of taxable property) with adjustments as required by state law. The ",null,null,null,null,null,null,null,null,null,null,null,null,"the tax base (the total value of taxable property) with adjustments as required by state law. The "]
["rates are given per $100 or property value.",null,null,null,null,null,null,null,null,null,null,null,null,"rates are given per $100 or property value."]
[]
["Last year's tax rate:",null,null,null,null,null,null,null,null,null,null,null,null,null,"Last year's tax rate:"]
["Last year's operating taxes ",null,null,null,null,{"$f":"ROUND($F$107*$L$56/100,0)","v":364084},null,null,null,null,null,null,null,1,"Last year's operating taxes ",null,null,null,null,null,{"$f":"V56*V107/100","v":364084}]
["Last year's debt taxes ",null,null,null,null,{"$f":"$F$106-$F$104","v":0},null,null,null,null,null,null,null,2,"Last year's debt taxes ",null,null,null,null,null,{"$f":"$F$106-$F$104","v":0}]
["Last years total taxes",null,null,null,null,{"$f":"ROUNDDOWN($L$19*$L$11/100+$L$32,0)","v":364084},null,null,null,null,null,null,null,3,"Last years total taxes",null,null,null,null,null,{"$f":"ROUNDDOWN(V11*V19/100+V32,0)","v":364084}]
["Last year's tax base ",null,null,null,null,{"$f":"ROUND($F$106/$L$11*100,0)","v":2275525000},null,null,null,null,null,null,null,4,"Last year's tax base ",null,null,null,null,null,null,{"$f":"ROUND($F$106/$L$11*100,0)","v":2275525000}]
["Last yeas total tax rate ",null,null,null,null,{"$f":"$L$11","v":1.6E-2},"/$100",null,null,null,null,null,null,5,"Last year's total tax rate ",null,null,null,null,null,2.4500000000000001E-2,1.6E-2,"/$100"]
[]
["This year's effective tax rate:",null,null,null,null,null,null,null,null,null,null,null,null," ","This year's effective tax rate:"]
["last year adjusted tax values",null,null,null,null,{"$f":"$L$30","v":2260101324},null,null,null,null,null,null,null,6,"last year adjusted tax values",null,null,null,null,null,null,{"$f":"F111","v":2260101324}]
["Last year's adjusted taxes",null,null,null,null,{"$f":"$L$34","v":361639},null,null,null,null,null,null,null,7,"Last year's adjusted taxes",null,null,null,null,null,null,{"$f":"V34","v":361639}]
["(after subtracting taxes on lost property)",null,null,null,null,null,null,null,null,null,null,null,null,null,"(after subtracting taxes on lost property)"]
[": This year's adjusted tax base ",null,null,null,null,{"$f":"$L$52","v":2369375220},null,null,null,null,null,null,null,8,": This year's adjusted tax base ",null,null,null,null,null,null,{"$f":"V52","v":2369375220}]
["(after subtracting value of new property",null,null,null,null,null,null,null,null,null,null,null,null,null,"(after subtracting value of new property"]
[" =This year's effective tax rate",null,null,null,null,{"$f":"ROUNDDOWN($F$112/$F$114*100,6)","v":1.5263000000000001E-2},"/$100",null,null,null,null,null,null,9," =This year's effective tax rate",null,null,null,null,null,null,{"$f":"ROUNDDOWN($V$112/$V$114*100,6)","v":1.5263000000000001E-2},"/$100"]
["(Maximum rate unless unit publishes notices and holds hearings) ",null,null,null,null,null,null,null,null,null,null,null,null,null,"(Maximum rate unless unit publishes notices and holds hearings) "]
[]
["This year's rollback tax rate:",null,null,null,null,null,null,null,null,null,null,null,null,null,"This year's rollback tax rate:"]
["Last years adjusted operating taxes",null,null,null,null,{"$f":"$F$112","v":361639},null,null,null,null,null,null,null,10,"Last years adjusted operating taxes",null,null,null,null,null,null,{"$f":"V112","v":361639}]
["(after subtracting taxes on lost property and adjusting for any ",null,null,null,null,null,null,null,null,null,null,null,null,null,"(after subtracting taxes on lost property and adjusting for any "]
["transferred function, tax increment financing, state criminal justice ",null,null,null,null,null,null,null,null,null,null,null,null,null,"transferred function, tax increment financing, state criminal justice "]
["mandate, and/or enhanced indigent healthcare expenditures)",null,null,null,null,null,null,null,null,null,null,null,null,null,"mandate, and/or enhanced indigent healthcare expenditures)"]
[" -  This year's adjusted tax base",null,null,null,null,{"$f":"$F$114","v":2369375220},null,null,null,null,null,null,null,11," -  This year's adjusted tax base",null,null,null,null,null,null,{"$f":"V114","v":2369375220},"/$100"]
[" -This year's effective operating rate",null,null,null,null,{"$f":"$F$116","v":1.5263000000000001E-2},"/$100",null,null,null,null,null,null,12," -This year's effective operating rate",null,null,null,null,null,null,{"$f":"V116","v":1.5263000000000001E-2},"/$100"]
[" x 1.08 - this year's maximum operating rate",null,null,null,null,{"$f":"ROUNDDOWN($F$125*1.08,6)","v":1.6483999999999999E-2},"/$100",null,null,null,null,null,null,13," x 1.08 - this year's maximum operating rate",null,null,null,null,null,null,{"$f":"ROUNDDOWN(V125*1.08,6)","v":1.6483999999999999E-2},"/$100"]
[" - This year's debt rate",null,null,null,null,0,"/$100",null,null,null,null,null,null,null," - This year's debt rate",null,null,null,null,null,null,0,"/$100"]
[" = This year's total rollback rate",null,null,null,null,{"$f":"$F$126","v":1.6483999999999999E-2},"/$100",null,null,null,null,null,null,14," = This year's total rollback rate",null,null,null,null,null,null,{"$f":"V126","v":1.6483999999999999E-2},"/$100"]
[]
["Statement of Increase/Decrease",null,null,null,null,null,null,null,null,null,null,null,null,"Statement of Increase/Decrease"]
["If Brush Country Groundwater Conservation District adopts a 2022 tax rate equal to the ",null,null,null,null,null,null,null,null,null,null,null,null,"If Brush Country Groundwater Conservation District adopts a 2022 tax rate equal to the "]
["effective tax rate of $0.025399 per $100 value, taxes would increase compared to 2021 taxes ",null,null,null,null,null,null,null,null,null,null,null,null,"effective tax rate of ",null,{"$f":"V125","v":1.5263000000000001E-2},"per $100 value, taxes would increase compared to 2021 taxes "]
["by ",{"$f":"ROUNDDOWN(($L$48*$F$116/100)-($F$107*$F$108/100),0)","v":1572},null,null,null,null,null,null,null,"2022 levy","2021 levy",null,null,"by ",{"$f":"ROUNDDOWN((V48*V116/100)-(V107*V108/100),0)","v":1572}]
[null,null,null,null,null,null,null,null,null,{"$f":"V48*V116/100","v":365656.92928718997},{"$f":"V107*U108/100","v":557503.625},{"$f":"J134-K134","v":-191846.69571281003}]
["Schedule A - Unencumbered Fund Balance",null,null,null,null,null,null,null,null,null,null,null,null,"Schedule A - Unencumbered Fund Balance"]
["The following estimated balances will be left in the unit's property tax accounts at the end of ",null,null,null,null,null,null,null,null,null,null,null,null,"The following estimated balances will be left in the unit's property tax accounts at the end of "]
["the fiscal year. These balances are not encumbered by a corresponding debt obligation",null,null,null,null,null,null,null,null,null,null,null,null,"the fiscal year. These balances are not encumbered by a corresponding debt obligation"]
["Type of Property Tax Fund Balance",null,null,null,"Balance",null,null,null,null,null,null,null,null,"Type of Property Tax Fund Balance",null,null,null,"Balance"]
["Ceneral Fund ",null,null,null,574254,null,null,null,null,null,null,null,null,"General Fund ",null,null,null,574254]
[]
["Schedule B - 2022 Debt Service",null,null,null,null,null,null,null,null,null,null,null,null,"Schedule B - 2022 Debt Service"]
["The unit plans to pay the following amounts for long-term debts that are secured by properly ",null,null,null,null,null,null,null,null,null,null,null,null,"The unit plans to pay the following amounts for long-term debts that are secured by properly "]
["taxes. These amounts will be paid from property tax revenues (or additional sales tax revenues, ",null,null,null,null,null,null,null,null,null,null,null,null,"taxes. These amounts will be paid from property tax revenues (or additional sales tax revenues, "]
["if applicable).",null,null,null,null,null,null,null,null,null,null,null,null,"if applicable)."]
[]
[null,null,"Pricipal or Contract",null,"interest to be","Other Amounts",null,null,null,null,null,null,null,null,null,"Principal or Contract",null,"interest to be","Other Amounts"]
["Description of Debt",null,"Payment to be Paid",null,"Paid from","to be Paid",null,"Total Payment",null,null,null,null,null,"Description of Debt",null,"Payment to be Paid",null,"Paid from","to be Paid",null,"Total Payment"]
[null,null,"from Property Taxes",null,"Property Taxes",null,null,null,null,null,null,null,null,null,null,"from Property Taxes",null,"Property Taxes"]
[null,null,0,null,0,0,null,0,null,null,null,null,null,null,"None",0,null,0,0,null,0,0]
[]
["Total required for 2022 debt service ",null,null,null,null,null,null,0,null,null,null,null,null,"Total required for 2022 debt service ",null,null,null,null,null,null,0]
[" - Amount (if any) paid from Schedule A ",null,null,null,null,null,null,0,null,null,null,null,null," - Amount (if any) paid from Schedule A ",null,null,null,null,null,null,0]
[" - Amount Of any) paid front other resources ",null,null,null,null,null,null,0,null,null,null,null,null," - Amount Of any) paid front other resources ",null,null,null,null,null,null,0]
[" - Excess collections last year ",null,null,null,null,null,null,0,null,null,null,null,null," - Excess collections last year ",null,null,null,null,null,null,0]
[" = Total to be paid from taxes in 2021 ",null,null,null,null,null,null,0,null,null,null,null,null," = Total to be paid from taxes in 2021 ",null,null,null,null,null,null,0]
[" - Amount added in anticipation that the unit will",null,null,null,null,null,null,0,null,null,null,null,null," - Amount added in anticipation that the unit will",null,null,null,null,null,null,0]
["collect only 100.00% of its taxes in 2022",null,null,null,null,null,null," ",null,null,null,null,null,"collect only 100.00% of its taxes in 2022",null,null,null,null,null,null," "]
[" = Total debt levy ",null,null,null,null,null,null,0,null,null,null,null,null," = Total debt levy ",null,null,null,null,null,null,0]
["Name of person preparing this notice:  Felix Saenz",null,null,null,null,null,null,null,null,null,null,null,null,"Name of person preparing this notice:  Felix Saenz"]
["Title: General Manager",null,null,null,null,null,null,null,null,null,null,null,null,"Title: General Manager","BCGCD Consultant"]
["Date Prepared:  ",null,null,null,null,null,null,null,null,null,null,null,null,"Date Prepared:  8/27/2022"]
[]
[]
[null,null,"2022 GOVERNING BODY SUMMARY #1B8",null,null,null,null,null,null,null,null,null,null,null,null,"2022 GOVERNING BODY SUMMARY #1B8"]
[null,null,"Comparison of This Year's Tax Levy with Last Years Tax Levy",null,null,null,null,null,null,null,null,null,null,null,null,"Comparison of This Year's Tax Levy with Last Years Tax Levy"]
[null,null,null,"(Does Not Include Frozen Levy)",null,null,null,null,null,null,null,null,null,null,null,null,"Does Not Include Frozen Levy"]
[null,null,"Brush Country Groundwater Conservation District",null,null,null,null,null,null,null,null,null,null,null,null,"Brush Country Groundwater Conservation District"]
[]
[null,"Date:",null,null,null,null,null,null,null,null,null,null,null,null,"Date:"]
[]
[null,null,null,null,null,"                  Last Year's Tax Levy**",null,null,{"$f":"U104","v":364084},null,null,null,null,null,"Last Year Tax Base 1,994,040,816",{"$f":"V$107","v":2275525000},null,"                                         Last Year's Tax Levy**",null,null,null,{"$f":"U104","v":364084}]
["Description of ",null,"Tax per $100",null,"This Years Tax Levy",null,"Tax Levy Increase",null,null,null,null,null,null,"Description of ",null,null,null,null,"This Years ",null,null,"Tax Levy Increase"]
["     Tax rate",null,null,null," ",null,null," ",null,null,null,null,null,"     Tax rate",null,null,"Tax per $100",null,"Tax Levy",null,"or decrease"]
["Last Year Tax Rate",null,1.6E-2,null,{"$f":"$L$48*$F$108/100","v":383313.29807999998},null,{"$f":"ROUND(($L$48*$F$108/100)-($F$106-$F$108),0)","v":19229},{"$f":"ROUNDDOWN(($L$48*$F$116/100)-($F$106-$F$108),0)","v":1572},{"$f":"ROUNDDOWN(($L$48*$F$116/100)-($F$106-$F$108),0)","v":1572},null,null,null,null,"Last Year Tax Rate",null,null,1.6E-2,null,{"$f":"V48*F108/100","v":383313.29807999998},null,{"$f":"ROUND(($L$48*$F$108/100)-($F$106),0)","v":19229},{"$f":"ROUNDDOWN(($L$48*$F$116/100)-($F$106-$F$108),0)","v":1572},1572]
["2022 Effective tax rate",null,{"$f":"$F$125","v":1.5263000000000001E-2},null,{"$f":"ROUND($L$48*$C$175/100,0)","v":365657},null,{"$f":"ROUNDDOWN(($L$48*$F$116/100)-$F$106,0)","v":1572},{"$f":"ROUNDDOWN(($L$48*$F$116/100)-($F$106-$F$108),0)","v":1572},{"$f":"ROUNDDOWN(($L$48*$F$116/100)-($F$106-$F$108),0)","v":1572},null,null,null,null,"2022 Effective tax rate(No New Revenue)",null,null,{"$f":"ROUNDDOWN(V112/V114*100,6)","v":1.5263000000000001E-2},null,{"$f":"ROUND($V$48*Q175/100,0)","v":365657},null,{"$f":"ROUNDDOWN(($L$48*$F$116/100)-$F$106,0)","v":1572},1572,1572]
["Notice & Hearing",null,{"$f":"C175","v":1.5263000000000001E-2},null,{"$f":"E175","v":365657},null,{"$f":"G175","v":1572},null,null,null,null,null,null,"Notice & Hearing",null,null,{"$f":"Q175","v":1.5263000000000001E-2},null,{"$f":"S175","v":365657},null,{"$f":"ROUNDDOWN(($L$48*$F$116/100)-$F$106,0)","v":1572},1572,1572]
["Rollback Tax Rate",null,{"$f":"ROUNDDOWN(C176*1.08,6)","v":1.6483999999999999E-2},null,{"$f":"ROUND(L48*C177/100,0)","v":394909},null,{"$f":"ROUND(($L$48*$F$126/100)-($F$106),0)","v":30825},{"$f":"ROUNDDOWN(($L$48*$F$116/100)-($F$106-$F$108),0)","v":1572},{"$f":"ROUNDDOWN(($L$48*$F$116/100)-($F$106-$F$108),0)","v":1572},null,null,null,null,"Rollback Tax Rate(Voter Election Rate)",null,null,{"$f":"ROUNDDOWN(Q176*1.08,6)","v":1.6483999999999999E-2},null,{"$f":"ROUND($V$48*Q177/100,0)","v":394909},null,{"$f":"ROUND(($V$48*V126/100)-($U$106),0)","v":30825},1572,1572]
["Proposed Tax Rate",null,{"$f":"C175","v":1.5263000000000001E-2},null,{"$f":"E175","v":365657},null,{"$f":"E178-I171","v":1573},{"$f":"ROUNDDOWN(($L$48*$F$116/100)-($F$106-$F$108),0)","v":1572},{"$f":"ROUNDDOWN(($L$48*$F$116/100)-($F$106-$F$108),0)","v":1572}]
[]
[null,null,"2022 certified tax value =",null,null,{"$f":"L48","v":2395708113}]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2022 certified tax value =",null,{"$f":"V48","v":2395708113}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"*These figures are provided as estimates of possible outcomes resulting from varying the tax rate."]
[null,null,null,null,null,null,null,null,null,null,null,null,null," Please be aware that these are only estimates and should not be used alone in making budgetary decisions"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"**Last year's tax levy is calculated using Texas Property Tax Code's definition of \"last year's levy\"."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"****Tax levy increase is the difference between this year's tax levy and last year's tax levy."]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Notice and Hearing Limit is the highest tax rate that may be adopted without notices and a public "]
[null,null,null,null,null,null,null,null,null,null,null,null,null," hearing.  It is the lower of the rollback tax rate "]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"___________"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pg 12"]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}