{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["DataInfo(Input)","Estimator(Output)","FormulaFactors","BandInfo","HistoricalFunding"],"not_rendered":{"charts":1,"images":0,"macros":1,"external_links":0,"defined_names":6,"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":"DataInfo(Input)","index":0,"n_rows":28,"n_cols":18,"rows_kept":28,"cut":false,"hidden":false,"merged":[[0,0,0,17],[26,0,27,0],[26,1,27,1],[1,0,1,5],[7,3,7,17],[11,3,11,17],[27,3,27,13]]}
["K-12 Operational Funding for BCTEA formula funded FN schools (This estimate does not include Language & Culture and Special Education funding) - prepared on 04/July/2022"]
["ENTER DATA IN PINK COLOURED CELLS TO FORECAST/ESTIMATE FUNDING"]
[]
[null,null,"Band #","Sch. Dist. #"]
["First Nation Name",null,{"$f":"IFERROR(VLOOKUP(B5,BandInfo!$B$3:$C$103,2,0),\"\")","v":""},{"$f":"IFERROR(VLOOKUP(C5,BandInfo!C:H,2,0),\"\")","v":""}]
["School District Name",{"$f":"IFERROR(VLOOKUP(B5,BandInfo!B3:E103,4,\"false\"),\"\")","v":""}]
[]
[null,"Estimates for September of,",null,"Projected/Anticipated FTEs (Enrolments)"]
["FTE and Headcount",2023,null,"K4","K5",1,2,3,4,5,6,7,8,9,10,11,12,"SS"]
["Elementary (grades K-7) FTE",{"$f":"SUM(D10:L10)","v":0}]
["Secondary (grades 8-12) FTE",{"$f":"SUM(M10:R10)","v":0}]
["Total School Aged FTE",{"$f":"B10+B11","v":0},null,"Projected/Anticipated Headcounts (Enrolments)"]
["Grades 11-12 FTE",{"$f":"IF(OR(C5=FormulaFactors!C85,C5=FormulaFactors!C86,C5=FormulaFactors!C87),0,SUM(P10:Q10))","v":0},null,"K4","K5",1,2,3,4,5,6,7,8,9,10,11,12,"SS"]
["Total School Aged Headcount",{"$f":"IF(OR(C5=FormulaFactors!C85,C5=FormulaFactors!C86,C5=FormulaFactors!C87),0,SUM(D14:R14))","v":0}]
["Adults FTE"]
["Adults Headcount"]
[]
[]
["SA FTE (PREVIOUS YEAR) - Actual",{"$f":"+B9-1","v":2022}]
["Total School Age FTEs"]
[]
["SA FTE (3 YEARS PREVIOUS) - Actual",{"$f":"+B9-3","v":2020}]
["Total School Age FTEs"]
[]
[]
["Number of Schools within community:",{"$f":"IFERROR(VLOOKUP(C5,BandInfo!C:H,5,\"false\"),\"\")","v":""}]
["School(s) eligible for the Small Remote School 1 a) funding:",{"$f":"IFERROR(VLOOKUP(C5,BandInfo!C:H,4,\"false\"),\"\")","v":""}]
[null,null,null,"If you have any questions or need assistance with this tool, please reach out to FNESC/Senior Funding Analyst (dileepak@fnesc.ca)."]

{"sheet":"Estimator(Output)","index":1,"n_rows":69,"n_cols":15,"rows_kept":69,"cut":false,"hidden":false,"merged":[[0,1,0,4],[5,1,5,2],[56,8,56,18]]}
[null,"FUNDING ESTIMATION",null,null,null,"SEPTEMBER:",{"$f":"+'DataInfo(Input)'!B9","v":2023}]
[]
[null,"First Nation:",{"$f":"+'DataInfo(Input)'!B5","v":0},{"$f":"+'DataInfo(Input)'!C5","v":""}]
[null,null,{"$f":"+'DataInfo(Input)'!B6","v":""}]
[]
["Rows as Indicated in BCTEA manual","FUNDING SOURCE/CATEGORY",null,"Factor","Amount","Funding","Total Funding"]
["Row 1","Basic Allocation",null,{"$f":"+'DataInfo(Input)'!B12","v":0},{"$f":"+FormulaFactors!C7","v":7885},{"$f":"+D7*E7","v":0},{"$f":"+F7","v":0}]
["Row 2","Adult Education",null,{"$f":"+'DataInfo(Input)'!B15","v":0},{"$f":"+FormulaFactors!C22","v":7885},{"$f":"+D8*E8","v":0},{"$f":"+F8","v":0}]
["Rows 3-5","Enrolment Decline"]
[null,{"$f":"+G1","v":2023},"FTE ",{"$f":"+'DataInfo(Input)'!B10+'DataInfo(Input)'!B11","v":0}]
[null,null,"FTE One year decline",{"$f":"IF('DataInfo(Input)'!B21+'DataInfo(Input)'!B20-'DataInfo(Input)'!B12>0,'DataInfo(Input)'!B21+'DataInfo(Input)'!B20-'DataInfo(Input)'!B12,0)","v":0},{"$f":"+E7","v":7885},{"$f":"IF(D$15<=FormulaFactors!C$9,0,IF(D$15<=FormulaFactors!C$10,('Estimator(Output)'!D$15-FormulaFactors!C$9)*'Estimator(Output)'!D$13*FormulaFactors!C$11*E$11,(D$15-FormulaFactors!C$10)*FormulaFactors!C$12*'Estimator(Output)'!E$11*'Estimator(Output)'!D$13+(FormulaFactors!C$10-FormulaFactors!C$9)*FormulaFactors!C$11*'Estimator(Output)'!E$11*'Estimator(Output)'!D$13))","v":0}]
[null,null,"FTE Decline previous year to 2 years prior",{"$f":"IF('DataInfo(Input)'!B24+'DataInfo(Input)'!B23-('DataInfo(Input)'!B21+'DataInfo(Input)'!B20)>0,'DataInfo(Input)'!B24+'DataInfo(Input)'!B23-('DataInfo(Input)'!B21+'DataInfo(Input)'!B20),0)","v":0},{"$f":"+E7","v":7885},{"$f":"IF(D$16>FormulaFactors!C$14,('Estimator(Output)'!D$16-FormulaFactors!C$14)*'Estimator(Output)'!D$14*'Estimator(Output)'!E$12*FormulaFactors!C$15,0)","v":0},{"$f":"+F12+F11","v":0}]
[null,null,"1 year FTE",{"$f":"+'DataInfo(Input)'!B21+'DataInfo(Input)'!B20","v":0}]
[null,null,"3 year FTE",{"$f":"+'DataInfo(Input)'!B24+'DataInfo(Input)'!B23","v":0}]
[null,null,"1 year decline %",{"$f":"IF(D11=0,0,+D11/D13)","v":0}]
[null,null,"Cumulative Decline%",{"$f":"IF(D12=0,0,D12/D14)","v":0}]
[]
[null,"Unique Student Needs"]
["Row 6",null,"ELL:",{"$f":"+'DataInfo(Input)'!B14*FormulaFactors!C17","v":0},{"$f":"+FormulaFactors!C18","v":1585},{"$f":"+E19*D19","v":0}]
["Row 7",null,"Aboriginal Education:",{"$f":"+'DataInfo(Input)'!B14","v":0},{"$f":"+FormulaFactors!C20","v":1565},{"$f":"+E20*D20","v":0}]
["Row 24",null,"Equity of Opportunity Suppl.:",{"$f":"+'DataInfo(Input)'!B12+'DataInfo(Input)'!B15","v":0},{"$f":"+FormulaFactors!C24","v":139.79},{"$f":"+E21*D21","v":0},{"$f":"+F19+F20+F21","v":0}]
[]
["Row 16","Salary Differential"]
[null,null,"Elementary, Secondary, Adult FTE",{"$f":"+'DataInfo(Input)'!B10+'DataInfo(Input)'!B11+'DataInfo(Input)'!B15","v":0},{"$f":"+FormulaFactors!C26","v":180.33},{"$f":"E24*D24","v":0},{"$f":"+F24","v":0}]
[]
["Rows 8-11","Small Community Supplement"]
[null,null,"Elementary (small remote 1a)",{"$f":"+'DataInfo(Input)'!B10","v":0},{"$f":"IF(AND('DataInfo(Input)'!B27=\"yes\",'DataInfo(Input)'!B10<=FormulaFactors!C35,'DataInfo(Input)'!B10>0),FormulaFactors!C37,IF(AND('DataInfo(Input)'!B27=\"yes\",'DataInfo(Input)'!B10>FormulaFactors!C36),0,IF(AND('DataInfo(Input)'!B27=\"yes\",'DataInfo(Input)'!B10>FormulaFactors!C35,'DataInfo(Input)'!B10<=FormulaFactors!C36),FormulaFactors!C38,0)))","v":0},{"$f":"E27","v":0}]
[null,null,"Elementary ",{"$f":"+D27","v":0},{"$f":"MAX(0,IF(AND('DataInfo(Input)'!B10<=FormulaFactors!C28,'DataInfo(Input)'!B10>0),FormulaFactors!C31,IF(AND('DataInfo(Input)'!B10>FormulaFactors!C28,'DataInfo(Input)'!B10<=FormulaFactors!C29),FormulaFactors!C32,IF('DataInfo(Input)'!B10>0,FormulaFactors!C32-FormulaFactors!C33*('DataInfo(Input)'!B10-FormulaFactors!C29),0))))","v":0},{"$f":"IF(F27>0,0,E28)","v":0}]
[null,null,"Secondary",{"$f":"+'DataInfo(Input)'!B11","v":0},{"$f":"MAX(0,IF('DataInfo(Input)'!B11<=FormulaFactors!C40,FormulaFactors!C42*'DataInfo(Input)'!B11,(FormulaFactors!C43-FormulaFactors!C44*('DataInfo(Input)'!B11-FormulaFactors!C40))))","v":0},{"$f":"E29","v":0}]
[null,null,"Grades 11-12",{"$f":"+'DataInfo(Input)'!B13","v":0},{"$f":"MAX(0,IF('DataInfo(Input)'!B13<=FormulaFactors!C46,FormulaFactors!C48*'DataInfo(Input)'!B13,(FormulaFactors!C49-FormulaFactors!C50*('DataInfo(Input)'!B13-FormulaFactors!C46))))","v":0},{"$f":"E30","v":0},{"$f":"SUM(F27:F30)","v":0}]
[]
["Rows 12-14","Low Enrolment "]
[null,null,"School Amount",{"$f":"+'DataInfo(Input)'!B26","v":""},{"$f":"+FormulaFactors!C53","v":53240},{"$f":"IF(D24=0,0,+D33*E33)","v":0}]
[null,null,"Enrolment (FTE) Amount",{"$f":"+'DataInfo(Input)'!B12+'DataInfo(Input)'!B15","v":0},{"$f":"+FormulaFactors!C52","v":2130},{"$f":"IF(D24=0,0,D34*E34)","v":0},{"$f":"+F33+F34","v":0}]
[]
[null,"Rural and Climate "]
["Row 15",null,"Rural Factor",{"$f":"VLOOKUP('DataInfo(Input)'!C5,BandInfo!C:K,8,\"false\")","v":{"$error":"#N/A"}},{"$f":"+F7","v":0},{"$f":"+D37*E37*FormulaFactors!C55","v":{"$error":"#N/A"}}]
["Row 17",null,"Climate Factor",{"$f":"VLOOKUP('DataInfo(Input)'!C5,BandInfo!C:K,7,\"false\")","v":{"$error":"#N/A"}},{"$f":"+F7","v":0},{"$f":"+E38*D38*FormulaFactors!C57","v":{"$error":"#N/A"}},{"$f":"+F37+F38","v":{"$error":"#N/A"}}]
[]
["Row 18","Curriculum and Learning"]
[null,null,"Curri & Learn Sppt (former: Education Plan)",{"$f":"+'DataInfo(Input)'!B12+'DataInfo(Input)'!B15","v":0},{"$f":"+FormulaFactors!C61","v":9},{"$f":"+D41*E41","v":0},{"$f":"+F41","v":0}]
[]
["Row 19","Student Location Factor"]
[null,null,"Enrolment (FTE) Amount",{"$f":"+'DataInfo(Input)'!B12","v":0},{"$f":"VLOOKUP('DataInfo(Input)'!C5,BandInfo!C:K,9,\"false\")","v":{"$error":"#N/A"}},{"$f":"+E44*D44","v":{"$error":"#N/A"}},{"$f":"+F44","v":{"$error":"#N/A"}}]
[]
["Row 20","Non Formula Amount"]
[null,null,"Non OGM Amount",{"$f":"+FormulaFactors!C63","v":0.2079},{"$f":"SUM(G7:G45)","v":{"$error":"#N/A"}},{"$f":"+E47*D47","v":{"$error":"#N/A"}},{"$f":"+F47","v":{"$error":"#N/A"}}]
[null,"Other Support "]
["Row 23",null,"Technology/Connection Amount",null,{"$f":"IF(SUM(G7:G8)=0,0,VLOOKUP('DataInfo(Input)'!C5,BandInfo!C:H,6,\"false\"))","v":0},{"$f":"+E49","v":0}]
["Row 25",null,"Education Minor Capital (O&M)",{"$f":"+'DataInfo(Input)'!B12+'DataInfo(Input)'!B15","v":0},{"$f":"+FormulaFactors!C67","v":120},{"$f":"+D50*E50","v":0}]
["Row 22",null,"BCeSIS (MYEdBC) amount",{"$f":"+'DataInfo(Input)'!B14+'DataInfo(Input)'!B16","v":0},{"$f":"+FormulaFactors!C65","v":20},{"$f":"+D51*E51","v":0}]
["Row 27",null,"Transportation Component",{"$f":"SUM('DataInfo(Input)'!D14:H14)*FormulaFactors!C69+SUM('DataInfo(Input)'!I14:R14)*FormulaFactors!C70+'DataInfo(Input)'!B16*FormulaFactors!C71","v":0},{"$f":"IF(D52<=FormulaFactors!C73,FormulaFactors!C72,IF('Estimator(Output)'!D52<=FormulaFactors!C75,FormulaFactors!C74,IF('Estimator(Output)'!D52<=FormulaFactors!C77,FormulaFactors!C76,FormulaFactors!C78)))","v":993.5},{"$f":"+D52*E52","v":0}]
["Row 26",null,"Language & Culture",{"$f":"FormulaFactors!C80","v":1195},{"$f":"'DataInfo(Input)'!B14","v":0},{"$f":"E53*D53","v":0},{"$f":"SUM(F49:F53)","v":0}]
[]
["Row 28","Funding Protection"]
[null,null,"Funding Protection",null,null,null,{"$f":"IFERROR(IF(O65=0,0,O69),0)","v":0}]
[null,null,null,null,null,null,null,null,{"$f":"\"This is an estimate only, based on existing information (for planning purposes). This will not be 100% precise.\"","v":"This is an estimate only, based on existing information (for planning purposes). This will not be 100% precise."}]
[null,"Total Funding ",null,null,null,null,{"$f":"IF('DataInfo(Input)'!B26=0,\"No Schools in this community; Therefore no funding.\",SUM(G7:G53)+G56)","v":{"$error":"#N/A"}},null,{"$f":"'DataInfo(Input)'!D18","v":0}]
[]
[]
[]
[]
[]
[]
[null,{"$f":"\"Funding by Category\"&\": \"&C3","v":"Funding by Category: 0"},null,null,null,null,null,null,null,null,"Total before Protection",null,null,null,{"$f":"SUM(G7:G53)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,"Last Year Total Funding",null,null,null,{"$f":"VLOOKUP(D3,HistoricalFunding!$C:$G,2,0)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,"Drop from last year (if any)",null,null,null,{"$f":"IF(O65>=O66,0,(O65-O66))","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,"Negative 1.5% of Last Year Funding",null,null,null,{"$f":"O66*-0.015","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,"Protection",null,null,null,{"$f":"IF(O67<O68,-(O67-O68),0)","v":{"$error":"#N/A"}}]

{"sheet":"FormulaFactors","index":2,"n_rows":80,"n_cols":3,"rows_kept":80,"cut":false,"hidden":true,"merged":[[4,1,4,2],[0,1,0,2],[1,1,1,2]]}
[null,"Funding Formula Factors:"]
[null,"These factors are referenced from the calculation spreadsheets"]
[]
[null,null,"2021/22"]
[]
[]
[null,"Basic Allocation Rate:",7885]
[]
[null,"Enrolment decline minimum:",0.01]
[null,"Enrolment decline threshold:",0.04]
[null,"Enrolment decline low factor:",0.5]
[null,"Enrolment decline high factor:",0.75]
[]
[null,"Cumulative enrolment decline minimum:",7.0000000000000007E-2]
[null,"Cumulative enrolment decline factor:",0.5]
[]
[null,"ESL Incidence Rate:",0.22600000000000001]
[null,"ESL Allocation Rate:",1585]
[]
[null,"Aboriginal Allocation Rate:",1565]
[]
[null,"Adult Education Rate:",7885]
[]
[null,"EOO (fomer Vulnerable Students)",139.79]
[]
[null,"Salary Differential Rate:",180.33]
[]
[null,"Elementary Small Community micro threshold:",7]
[null,"Elementary Small Community low threshold:",110]
[null,"Elementary Small Community high threshold:",250]
[null,"Elementary Small Community 8 and under:",105500]
[null,"Elementary Small Community maximum:",221417]
[null,"Elementary Small Community reduction rate:",1581.55]
[]
[null,"Elementary Small Community Funding -1a - FTE low threshold:",15]
[null,"Elementary Small Community Funding -1a - FTE high threshold:",75]
[null,"Elementary Small Community Funding -1a - FTE low rate:",224900]
[null,"Elementary Small Community Funding -1a - FTE high rate:",252800]
[]
[null,"Secondary Small Community low threshold:",100]
[null,"Secondary Small Community high threshold:",635]
[null,"Secondary Small Community incremental rate:",6371.85]
[null,"Secondary Small Community maximum:",637185]
[null,"Secondary Small Community reduction rate:",1191]
[]
[null,"Grade 11 & 12 Small Community low threshold: ",15]
[null,"Grade 11 & 12 Small Community high threshold: ",215]
[null,"Grade 11 & 12 Small Community incremental rate: ",17194]
[null,"Grade 11 & 12 Small Community maximum: ",257910]
[null,"Grade 11 & 12 Small Community reduction rate: ",1289.55]
[]
[null,"Low Enrolment FTE rate:",2130]
[null,"Low Enrolment School rate:",53240]
[]
[null,"Rural factor:",0.2]
[]
[null,"Climate Factor:",0.05]
[]
[null,"Student Location factor","See tab\"BandInfo\""]
[]
[null,"Curricu & Learning (fmr Edu Plan)",9]
[]
[null,"Non-OGM factor:",0.2079]
[]
[null,"BCeSIS rate:",20]
[]
[null,"Education Minor Capital / Fit-up rate:",120]
[]
[null,"K4 - 3 Transportation Weighting:",1]
[null,"Gr. 4 - 12 Transportation Weighting:",0.8]
[null,"Adult Transportation Weighting:",0.5]
[null,"Transportation small rate:",993.5]
[null,"Transportation low threshhold:",23]
[null,"Transportation low rate:",864.6]
[null,"Transportation mid threshold:",35]
[null,"Transportation mid rate:",713.8]
[null,"Transportation high threshold:",47]
[null,"Transportation high rate:",547.29999999999995]
[]
[null,"Language & Culture Rate per SA Enrolment",1195]

{"sheet":"BandInfo","index":3,"n_rows":72,"n_cols":11,"rows_kept":72,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Band Name in Alphabetical order","Recipient Number","District #","District Name","1a eligible flag","Number of schools","Connectivity Funding","SD Climate Index","SD Rural Index","Student Location Factor"]
[null,"?AQAM",602,5,"SOUTH EAST KOOTENAY","No",1,21480,0.18909999999999999,0.14499999999999999,403.81]
[null,"ADAMS LAKE INDIAN BAND",684,73,"KAMLOOPS/THOMPSON","No",1,18000,0.17219999999999999,3.5499999999999997E-2,260.58]
[null,"BLUEBERRY RIVER FIRST NATIONS",547,60,"PEACE RIVER NORTH","No",1,15600,0,0,363.8]
[null,"CAMPBELL RIVER INDIAN BAND",622,72,"CAMPBELL RIVER","No",1,14188,3.27E-2,6.6799999999999998E-2,340.02]
[null,"COLDWATER INDIAN BAND",693,58,"NICOLA-SIMILKAMEEN","No",1,30000,0.1464,5.1799999999999999E-2,368.54]
[null,"COWICHAN",642,79,"COWICHAN VALLEY","No",3,21263,4.1500000000000002E-2,6.1400000000000003E-2,234.48]
[null,"DOUGLAS INDIAN BAND",561,78,"FRASER-CASCADE","Yes",1,10366,6.0900000000000003E-2,4.1300000000000003E-2,646.65]
[null,"DZAWADA'ENUXW FIRST NATION",636,85,"VANCOUVER ISLAND NORTH","Yes",1,12960,6.1800000000000001E-2,0.1321,564.70000000000005]
[null,"ESK'ETEMC",711,27,"CARIBOO-CHILCOTIN","No",1,14400,0.2261,8.7599999999999997E-2,862.28]
[null,"FORT NELSON FIRST NATION",543,81,"FORT NELSON","No",1,70604,0.38419999999999999,0.26300000000000001,229.05]
[null,"GITSEGUKLA INDIAN BAND",535,82,"COAST MOUNTAINS","No",1,19200,0.14729999999999999,0.2029,662.53]
[null,"GITWANGAK INDIAN BAND",536,82,"COAST MOUNTAINS","No",2,25200,0.14729999999999999,0.2029,662.53]
[null,"GITXAALA NATION",672,52,"PRINCE RUPERT","No",1,18000,8.3299999999999999E-2,0.2319,346.72]
[null,"GWA'SALA-NAKWAXDA'XW INDIAN BAND",724,85,"VANCOUVER ISLAND NORTH","No",1,12460,6.1800000000000001E-2,0.1321,564.70000000000005]
[null,"ISKUT INDIAN BAND",683,87,"STIKINE","No",1,79020,0.3498,0.35389999999999999,1657.77]
[null,"KITASOO XAI'XAIS NATION",540,49,"CENTRAL COAST","Yes",1,27600,7.0300000000000001E-2,0.21479999999999999,2447.5300000000002]
[null,"KITSELAS INDIAN BAND",680,82,"COAST MOUNTAINS","No",1,19200,0,0,662.53]
[null,"KITSUMKALUM INDIAN BAND",681,82,"COAST MOUNTAINS","No",1,19700,0.14729999999999999,0.2029,662.53]
[null,"KWADACHA INDIAN BAND",610,87,"STIKINE","Yes",2,25220,0.3498,0.35389999999999999,1657.77]
[null,"KWAKIUTL INDIAN BAND",626,85,"VANCOUVER ISLAND NORTH","No",1,9600,6.1800000000000001E-2,0.1321,564.70000000000005]
[null,"LIL'WAT NATION",557,48,"HOWE SOUND","No",1,17700,0.1065,0,353.91]
[null,"LOWER KOOTENAY INDIAN BAND",606,8,"KOOTENAY LAKE","No",1,16800,0.1196,0.111,492.21]
[null,"LOWER NICOLA INDIAN BAND",695,58,"NICOLA-SIMILKAMEEN","No",1,18000,0.1464,5.1799999999999999E-2,368.54]
[null,"LOWER SIMILKAMEEN BAND",598,53,"OKANAGAN-SIMILKAMEEN","No",1,16800,8.5599999999999996E-2,7.5899999999999995E-2,501.17]
[null,"LYTTON INDIAN BAND",705,74,"GOLD TRAIL","No",1,11850,0.1245,7.2700000000000001E-2,1623.94]
[null,"MUSQUEAM INDIAN BAND",550,39,"VANCOUVER","No",1,11188,4.0000000000000001E-3,0,6.33]
[null,"NAMGIS FIRST NATION",631,85,"VANCOUVER ISLAND NORTH","No",1,30432,6.1800000000000001E-2,0.1321,564.70000000000005]
[null,"NANOOSE FIRST NATION",649,68,"NANAIMO-LADYSMITH","No",1,12600,0.03,3.1699999999999999E-2,108.02]
[null,"NESKONLITH INDIAN BAND",690,73,"KAMLOOPS/THOMPSON","No",1,18720,0.17219999999999999,3.5499999999999997E-2,260.58]
[null,"NUXALK NATION BAND",539,49,"CENTRAL COAST","No",3,30000,7.0300000000000001E-2,0.21479999999999999,2447.5300000000002]
[null,"OKANAGAN INDIAN BAND",616,23,"CENTRAL OKANAGAN","No",1,12216,9.7900000000000001E-2,3.95E-2,131.22999999999999]
[null,"OLD MASSETT VILLAGE COUNCIL BAND",669,50,"HAIDA GWAII/QUEEN CHARLOTTE","No",1,23400,8.0500000000000002E-2,0.49469999999999997,1681.39]
[null,"OSOYOOS INDIAN BAND",596,53,"OKANAGAN-SIMILKAMEEN","No",1,14400,8.5599999999999996E-2,7.5899999999999995E-2,501.17]
[null,"PACHEEDAHT FIRST NATION",658,62,"SOOKE","No",1,8188,2.6270000000000002E-2,4.9700000000000001E-2,136.99]
[null,"PENELAKUT TRIBE",650,79,"COWICHAN VALLEY","No",1,12900,4.1500000000000002E-2,6.1400000000000003E-2,234.48]
[null,"PENTICTON INDIAN BAND",597,67,"OKANAGAN-SKAHA","No",2,31440,7.6999999999999999E-2,5.0799999999999998E-2,162.53]
[null,"PROPHET RIVER FIRST NATION",544,81,"FORT NELSON","Yes",1,52788,0.38419999999999999,0.26300000000000001,229.05]
[null,"QUATSINO INDIAN BAND",633,85,"VANCOUVER ISLAND NORTH","No",1,21600,6.1800000000000001E-2,0.1321,564.70000000000005]
[null,"SAULTEAU FIRST NATIONS",542,59,"PEACE RIVER SOUTH","No",2,25200,0.31219999999999998,0.16880000000000001,732.04]
[null,"SEABIRD ISLAND INDIAN BAND",581,78,"FRASER-CASCADE","No",3,37351,6.0900000000000003E-2,4.1300000000000003E-2,646.65]
[null,"SKATIN NATIONS",562,78,"FRASER-CASCADE","No",1,14400,6.0900000000000003E-2,4.1300000000000003E-2,646.65]
[null,"SKWAH INDIAN BAND",573,33,"CHILLIWACK","No",1,12208,3.0200000000000001E-2,1.4200000000000001E-2,152.27000000000001]
[null,"SNUNEYMUXW FIRST NATION",648,68,"NANAIMO-LADYSMITH","No",1,16993,0.03,3.1699999999999999E-2,108.02]
[null,"SONGHEES NATION",656,61,"GREATER VICTORIA","No",1,11739,1.2800000000000001E-2,3.4200000000000001E-2,6.17]
[null,"SPLATSIN",600,83,"NORTH OKANAGAN-SHUSWAP","No",1,15600,0.13919999999999999,0.13919999999999999,611.92999999999995]
[null,"SQUAMISH INDIAN BAND",555,44,"NORTH VANCOUVER","No",2,27125,9.9500000000000005E-2,0,15.44]
[null,"SQUIALA FIRST NATION",574,36,"SURREY","No",1,16200,2.12E-2,0,6.25]
[null,"STS'AILES BAND",559,78,"FRASER-CASCADE","No",1,15708,6.0900000000000003E-2,4.1300000000000003E-2,646.65]
[null,"STSWECEM'C XGAT'TEM FIRST NATION",723,74,"GOLD TRAIL","Yes",1,18000,0.1245,7.2700000000000001E-2,1623.94]
[null,"STZ'UMINUS FIRST NATION",641,68,"NANAIMO-LADYSMITH","No",3,34020,0.03,3.1699999999999999E-2,108.02]
[null,"SUMAS FIRST NATION",578,34,"ABBOTSFORD","No",1,10800,2.1499999999999998E-2,0,78.12]
[null,"TAKLA NATION",608,91,"NECHAKO LAKES","Yes",1,15600,0.2621,0.1197,978.48]
[null,"T'IT'Q'ET",593,74,"GOLD TRAIL","No",1,16200,0.1245,7.2700000000000001E-2,1623.94]
[null,"TK'EMLÚPS TE SECWÉPEMC",688,73,"KAMLOOPS/THOMPSON","No",2,19200,0.17219999999999999,3.5499999999999997E-2,260.58]
[null,"TL'AZT'EN NATION",617,91,"NECHAKO LAKES","Yes",2,27600,0.26212000000000002,0.1197,1005.99]
[null,"TL'ETINQOX GOVERNMENT",712,27,"CARIBOO-CHILCOTIN","No",1,15600,0.2261,8.7599999999999997E-2,862.28]
[null,"TSAL'ALH",595,74,"GOLD TRAIL","Yes",1,14820,0.1245,7.2700000000000001E-2,1623.94]
[null,"TSARTLIP INDIAN BAND",653,63,"SAANICH","No",3,29511,1.37E-2,4.3700000000000003E-2,212.31]
[null,"TSAY KEH DENE BAND",609,91,"NECHAKO LAKES","Yes",1,14400,0.2621,0.1197,978.48]
[null,"TŜIDELDEL FIRST NATION",710,27,"CARIBOO-CHILCOTIN","Yes",1,15600,0.2261,8.7599999999999997E-2,862.28]
[null,"TS'KW'AYLAXW FIRST NATION",594,74,"GOLD TRAIL","Yes",1,16200,0.1245,7.2700000000000001E-2,1623.94]
[null,"TSLEIL-WAUTUTH NATION",549,44,"NORTH VANCOUVER","No",1,11188,9.9500000000000005E-2,0,15.44]
[null,"T'SOU-KE FIRST NATION",657,62,"SOOKE","No",1,14535,2.63E-2,4.9700000000000001E-2,135.5]
[null,"ULKATCHO INDIAN BAND",722,27,"CARIBOO-CHILCOTIN","No",1,14400,0.2261,8.7599999999999997E-2,862.28]
[null,"UPPER NICOLA INDIAN BAND",697,58,"NICOLA-SIMILKAMEEN","Yes",1,21600,0.1464,5.1799999999999999E-2,368.54]
[null,"WILLIAMS LAKE FIRST NATION",719,27,"CARIBOO-CHILCOTIN","No",1,16200,0.2261,8.7599999999999997E-2,862.28]
[null,"WITSET FIRST NATION",530,82,"COAST MOUNTAINS","No",2,13200,0.14729999999999999,0.2029,662.53]
[null,"XAXLI'P INDIAN BAND",592,74,"GOLD TRAIL","No",1,16200,0.1245,7.2700000000000001E-2,1623.94]
[null,"YEKOOCHE FIRST NATION",728,91,"NECHAKO LAKES","Yes",2,34800,0.26212000000000002,0.1197,1005.99]
[null,"YUNESIT'IN GOVERNMENT",717,27,"CARIBOO-CHILCOTIN","No",1,15600,0.2261,8.7599999999999997E-2,862.28]

{"sheet":"HistoricalFunding","index":4,"n_rows":72,"n_cols":5,"rows_kept":72,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,"Band Number","BCTEA 2020/21 Allocation","BCTEA 2021/22 Allocation"]
[null,null,530,2228384.3427555077,2501895.5645772638]
[null,null,535,1108227,1109797.1962674826]
[null,null,536,885463.28451288329,913544.01779468765]
[null,null,539,5418963,6284483.0340542626]
[null,null,540,1548567.3911934656,1759719.4657531742]
[null,null,542,724769.24298330012,989966.820840745]
[null,null,543,1294609.90693492,1359927.8251440974]
[null,null,544,553854,548310.54407730489]
[null,null,547,417771.80349045002,411505.22643809323]
[null,null,549,1148486.514054554,1395095.1531803189]
[null,null,550,382351.39,376616.11915000004]
[null,null,555,1196946.6873120512,1264809.2556472374]
[null,null,557,4946857.9153540004,5660884.4683170374]
[null,null,559,2715159.0824692445,2674431.6962322057]
[null,null,561,537051.07860295195,720907.81859074242]
[null,null,562,1122640.520200788,1330466.5616781525]
[null,null,573,500655.65718828398,512621.89617969998]
[null,null,574,669450.82039158593,827616.56715272006]
[null,null,578,216346.11019939999,288796.08434181247]
[null,null,581,4031171.6,4286056.7406413695]
[null,null,592,223633,240200.6193859975]
[null,null,593,232831.5370882253,229339.06403190191]
[null,null,594,0,378114.03626724746]
[null,null,595,1149972.9538739598,1132723.3595658503]
[null,null,596,1128991.6943935,1428721.6297805801]
[null,null,597,2496331.3245764198,2675877.7393864249]
[null,null,598,554287.22622804996,706501.66755179991]
[null,null,600,903069.66910528007,909980.41473960003]
[null,null,602,780702.00204083789,844734.80814232747]
[null,null,606,563365.16464387998,652715.86570127006]
[null,null,608,1159196.511778696,1269863.5591975525]
[null,null,609,1603368.615325232,1896210.0882291975]
[null,null,610,3051230.1438470981,3005461.6916893916]
[null,null,616,1054494.737024032,1165025.9791196401]
[null,null,617,1145716.4830153841,1156790.4508853841]
[null,null,622,234103.336741062,248044.141139585]
[null,null,626,742941,770033.50470912992]
[null,null,631,1183103.7533088541,1165357.1970092212]
[null,null,633,1145359,1248320.70996825]
[null,null,636,518762.12478139903,538494.80244540004]
[null,null,641,4118597.9929986,4234032.28127228]
[null,null,642,3391073.29,3340207.1906500002]
[null,null,648,956354.48531197396,1038879.5094865399]
[null,null,649,289007.72528892598,483169.03598287993]
[null,null,650,2776847.399710427,3141527.812192935]
[null,null,653,6050473.1879351139,6407382.190348275]
[null,null,656,0,331188.83561377]
[null,null,657,200610.49903964598,223694.12025783252]
[null,null,658,285173.86506735551,285436.21743164602]
[null,null,669,1060175.8829793003,1437327.4262263626]
[null,null,672,2020434.3787750001,2072045.82748674]
[null,null,680,358759.465877045,353378.07388888934]
[null,null,681,1159154.003575,1141766.6935213751]
[null,null,683,1446829.5969749999,1425127.1530203749]
[null,null,684,1063711.0240334719,1253530.505278785]
[null,null,688,1294074.9766799868,1346182.2850861449]
[null,null,690,855970.55110438995,928206.5150851151]
[null,null,693,634482.34592678607,628998.34769657988]
[null,null,695,1175307.7982170028,1157678.1812437477]
[null,null,697,981194.3309081099,1035927.5427516]
[null,null,705,2260363.917918134,2416430.7275062641]
[null,null,710,966884.69356677611,1037858.2283113499]
[null,null,711,1389928.541265816,1417259.7875808]
[null,null,712,1419647.4375085202,1661029.2041733998]
[null,null,717,765091.49547370698,948607.38271134987]
[null,null,719,630360.30159066408,638835.87104832497]
[null,null,722,459240.66152028,488461.18391894992]
[null,null,723,748422.73955342791,933627.34400193254]
[null,null,724,1692336,1833032.7545973603]
[null,null,728,898378.60179541586,911357.36528541613]