{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Instructions","Fact Sheet","Summary (Linked)","Calculations","2021 Output"],"not_rendered":{"charts":3,"images":2,"macros":1,"external_links":0,"defined_names":0,"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":"Instructions","index":0,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":false,"merged":[[2,2,2,7],[15,2,15,7],[3,2,3,7],[12,2,12,7],[11,2,11,7],[9,2,9,7],[14,2,14,7],[10,2,10,7],[7,2,7,7]]}
[]
[]
[null,null,"Estimated Spending-Cliff Impact Report"]
[null,null,"Please enter the two-letter abbreviation for your state below to view the estimated losses in funding, patients and staff that health centers in your state will experience as a result of a reduction in base and discretionary funding through the federal 330 grant."]
[]
[null,null,"Please enter your state or territory's (2-letter abbreviation). To see the impact on the United States and territories as a whole, enter US.","US"]
[]
[null,null,"Go to the Fact Sheet tab below to view the impact of spending reductions on health centers in the state you entered. \nUse the slider bars to estimate the funding reduction, and see the impact on funding, patients and staff. Please note that you must click “enable content” at the top of the spreadsheet in order for the calculator to work."]
[]
[null,null,"Creating a PDF or printing the Fact Sheet"]
[null,null,"1. Go to the Fact Sheet tab (located at the bottom of this workbook)."]
[null,null,"2. Make sure everything looks correct and properly formatted (email research@nachc.org if you have any questions.)"]
[null,null,"3. Go to File > Save As > PDF (current sheet, not workbook) OR File > Print > PDF. If prompted, choose print page 1."]
[null,null,"Notes on the Methodology"]
[null,null,"This tool first calculates what a reduction in federal 330 funding would amount to for your state. It then divides this funding loss by your health center's current federal 330 funding per patient, and then multiples this amount by the percentage of your health center's total revenue that comes from federal 330 funding in order to account for how \"reliant\" your health center currently is on its 330 federal funding. This figure is used to estimate the number of patients and FTEs that would be lost as a result."]
[null,null,"This tool provides an estimate of the immediate impact of cuts to health center funding. Calculations used for these estimates do not account for impacts that would likely result from the subsequent loss of other revenue sources and decrease in health center services, such as enabling services that faciliate patients' access to care. It also does not account for snowball effects, such as the loss of patients resulting from staff reductions or diminished hours of operation.\n"]

{"sheet":"Fact Sheet","index":1,"n_rows":15,"n_cols":8,"rows_kept":15,"cut":false,"hidden":false,"merged":[[9,4,9,7]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,33]
[null,null,null,null,null,null,null,100]

{"sheet":"Summary (Linked)","index":2,"n_rows":68,"n_cols":27,"rows_kept":68,"cut":false,"hidden":true,"merged":[]}
["Full State Name","State","BPHC Funding","330 Funding","Total Revenue","Grant/Revenue","BPHC/Patient","BPHC/FTE","Base funding","Discretionary Funding","Total Patients","Patients Immediately Losing Access (Base + Discretionary)","Percent of Current Patients Lost (Projected)","Patients Remaining","Current FTEs","Lost FTEs",null,null,null,null,null,null,null,null,null,null,"BPHC Funding"]
["Alaska","AK",90661610,72253082,259645704,{"$f":"D2/E2","v":0.27827566906325552},{"$f":"D2/K2","v":628.35870141842122},{"$f":"C2/O2","v":34528.022576492724},{"$f":"D2*Calculations!$B$68","v":49829711.724137932},{"$f":"D2-I2","v":22423370.275862068},114987,{"$f":"Calculations!Q2","v":25032.225155333948},{"$f":"L2/K2","v":0.21769613221785025},{"$f":"1-M2","v":0.78230386778214978},2625.74,{"$f":"Calculations!Y2","v":571.61344220969818},null,null,"Following entries are matched to state selection for the purposes of feeding the Fact Sheet from the table. ",null,null,null,null,null,null,null,90661610]
["Alabama","AL",119973997,89208291,122281875,{"$f":"D3/E3","v":0.72952995691307476},{"$f":"D3/K3","v":285.55333941518222},{"$f":"C3/O3","v":50617.241015601932},{"$f":"D3*Calculations!$B$68","v":61522959.31034483},{"$f":"D3-I3","v":27685331.68965517},312405,{"$f":"Calculations!Q3","v":131774.997755002},{"$f":"L3/K3","v":0.42180822251565114},0.5781917774843488,2370.2199999999998,{"$f":"Calculations!Y3","v":999.7782851710466},null,"State as entered from Fact Sheet",{"$f":"Instructions!D6","v":"US"},null,null,null,null,null,null,null,119973997]
["Arkansas","AR",76087640,57870173,75755912,{"$f":"D4/E4","v":0.76390306013344544},202.4225326001791,33622.911483581316,{"$f":"D4*Calculations!$B$68","v":39910464.137931034},17959708.862068966,285888,{"$f":"Calculations!Q4","v":123811.06592043015},0.43307542086561923,0.56692457913438077,2262.9699999999998,{"$f":"Calculations!Y4","v":980.0366851562701},null,"State",{"$f":"INDEX(A2:A61,MATCH(S3,B2:B61,0))","v":"United States"},null,"Selection repeat that feeds Fact Sheet text boxes.",null,null,null,null,null,76087640]
["American Samoa","AS",4088614,3878178,11816754,0.3281931738614513,348.8511289016821,38033.618604651165,{"$f":"D5*Calculations!$B$68","v":2674605.5172413797},1203572.4827586203,11117,{"$f":"Calculations!Q5","v":2746.9825817658848},0.24709747069945892,0.75290252930054113,107.5,{"$f":"Calculations!Y5","v":26.562978100191831},null,null,null,null,null,null,null,null,null,null,4088614]
["Arizona","AZ",145580240,88262748,180298374,0.48953712694047924,110.32512524624261,18477.229054817297,{"$f":"D6*Calculations!$B$68","v":60870860.689655177},27391887.310344823,800024,{"$f":"Calculations!Q6","v":262928.29051388905},0.32865050362725251,0.67134949637274755,7878.9,{"$f":"Calculations!Y6","v":2589.4044530287597},null,"State Numbers for use in sliders",null,null,null,null,null,null,null,null,145580240]
["California","CA",1135286122,704413536,2184356804,0.32248098603217024,134.44076293857736,22271.953866496122,{"$f":"D7*Calculations!$B$68","v":485802438.62068969},218611097.37931031,5239583,{"$f":"Calculations!Q7","v":1277648.5333879078},0.24384546124909326,0.75615453875090677,50973.8,{"$f":"Calculations!Y7","v":12429.72977261903},null,"Concatenate",{"$f":"CONCATENATE(R8,S4,R9)","v":"in United States' s Federal 330 funding will be lost and"},null,null,null,null,null,null,null,1135286122]
["Colorado","CO",146194880,110662993,262914050,0.42090939225195456,174.30591861743517,24218.805185855192,{"$f":"D8*Calculations!$B$68","v":76319305.517241389},34343687.482758611,634878,{"$f":"Calculations!Q8","v":188066.96232095291},0.296225357188236,0.70377464281176394,6036.42,{"$f":"Calculations!Y8","v":1788.1406706382115},null,"in ",null,null,null,null,null,null,null,null,146194880]
["Connecticut","CT",88985726,63058705,153218251,0.41156131589049399,154.04142299480657,19587.048902839255,{"$f":"D9*Calculations!$B$68","v":43488762.068965517},19569942.931034483,409362,{"$f":"Calculations!Q9","v":119355.46936498403},0.29156460385913696,0.70843539614086304,4543.09,{"$f":"Calculations!Y9","v":1324.6042361464067},null,"' s Federal 330 funding will be lost and",null,null,null,null,null,null,null,null,88985726]
["District of Columbia","DC",37367206,27070650,84338957,0.32097444600838493,141.74079911198143,16607.868549358438,{"$f":"D10*Calculations!$B$68","v":18669413.793103449},8401236.206896551,190987,{"$f":"Calculations!Q10","v":46406.610442042038},0.24298308493270243,0.75701691506729762,2249.9699999999998,{"$f":"Calculations!Y10","v":546.70465160603237},null,"Federal Funding lost (Full cliff)",{"$f":"S12","v":3573330453.7931037},null,null,null,null,null,null,null,37367206]
["Delaware","DE",14874584,13620157,18606332,0.73201730464661174,292.32823231456047,37492.019962695973,{"$f":"D11*Calculations!$B$68","v":9393211.7241379321},4226945.2758620679,46592,{"$f":"Calculations!Q11","v":19691.575925134133},{"$f":"L11/K11","v":0.42263856295360003},0.57736143704639997,396.74,{"$f":"Calculations!Y11","v":167.67762346621132},null,null,null,null,null,null,null,null,null,null,14874584]
["Florida","FL",392616463,249107404,511688802,0.48683380020499256,148.57137983580697,32904.855902721029,{"$f":"D12*Calculations!$B$68","v":171798209.65517244},77309194.344827563,1676685,{"$f":"Calculations!Q12","v":548996.75416591123},0.32742987154170955,0.67257012845829045,11931.87,{"$f":"Calculations!Y12","v":3906.8506613523782},null,"Base Funding",{"$f":"INDEX(I2:I61,MATCH(S3,B2:B61,0))","v":3573330453.7931037},null,"Selects Base funding from col K",null,null,null,null,null,392616463]
["Federated States of Micronesia","FM",5783400,3269239,3300181,0.99062415061476927,153.57191845170988,43943.469341235461,{"$f":"D13*Calculations!$B$68","v":2254647.5862068967},1014591.4137931033,21288,{"$f":"Calculations!Q13","v":10593.866708476546},0.49764499757969494,0.50235500242030506,131.61000000000001,{"$f":"Calculations!Y13","v":65.495058131463679},null,"Discretionary Funding",{"$f":"INDEX(J2:J61,MATCH(S3,B2:B61,0))","v":1607998704.2068963},null,null,null,null,null,null,null,5783400]
["Georgia","GA",184086708,129186876,176604743,0.73150286796091313,195.09800593206518,46487.246776466309,{"$f":"D14*Calculations!$B$68","v":89094397.241379321},40092478.758620679,662164,{"$f":"Calculations!Q14","v":279742.45611899527},0.42246702647530715,0.57753297352469279,3959.94,{"$f":"Calculations!Y14","v":1672.9440768206273},null,"Total BPHC Funding",{"$f":"INDEX(C2:C61,MATCH(S3,B2:B61,0))","v":7424904883},null,null,null,null,null,null,null,184086708]
["Guam","GU",2993481,1998168,3342745,0.59776261725019408,249.39690464303544,37935.382080851603,{"$f":"D15*Calculations!$B$68","v":1378046.8965517243},620121.10344827571,8012,{"$f":"Calculations!Q15","v":2997.4878856854625},0.37412479851291347,0.62587520148708653,78.91,{"$f":"Calculations!Y15","v":29.522187850653996},null,"Total 330 Funding",{"$f":"INDEX(D2:D61,MATCH(S3,B2:B61,0))","v":5181329158},null,null,null,null,null,null,null,2993481]
["Hawaii","HI",46604628,35199210,84343785,0.41733021585407865,228.14556272847477,22484.767841290672,{"$f":"D16*Calculations!$B$68","v":24275317.241379313},10923892.758620687,154284,{"$f":"Calculations!Q16","v":45428.633569369747},0.29444811885464306,0.70555188114535694,2072.7199999999998,{"$f":"Calculations!Y16","v":610.30850491239562},null,"Total Revenue",{"$f":"INDEX(E2:E61,MATCH(S3,B2:B61,0))","v":11261447705},null,null,null,null,null,null,null,46604628]
["Iowa","IA",59133085,47580524,77746636,0.6119946334398314,188.12033559222857,28239.160748993556,{"$f":"D17*Calculations!$B$68","v":32814154.482758623},14766369.517241377,252926,{"$f":"Calculations!Q17","v":96023.492539238898},0.3796505402340562,0.6203494597659438,2094.0100000000002,{"$f":"Calculations!Y17","v":794.99202775551612},null,"Patients Served",{"$f":"INDEX(K2:K61,MATCH(S3,B2:B61,0))","v":30193278},null,null,null,null,null,null,null,59133085]
["Idaho","ID",72793166,48184553,116542298,0.41345120035302546,237.74295300357716,32588.020987223226,{"$f":"D18*Calculations!$B$68","v":33230726.206896555},14953826.793103445,202675,{"$f":"Calculations!Q18","v":59284.835592923468},0.29251183220882432,0.70748816779117574,2233.7399999999998,{"$f":"Calculations!Y18","v":653.39538007813917},null,"Patients Lost",{"$f":"INDEX(L2:L61,MATCH(S3,B2:B61,0))","v":9886701.9129537623},null,null,null,null,null,null,null,72793166]
["Illinois","IL",301829538,221180620,426403724,0.51871174558503619,152.73470171309876,29618.455653696205,{"$f":"D19*Calculations!$B$68","v":152538358.62068966},68642261.37931034,1448136,{"$f":"Calculations!Q19","v":494606.79723338096},0.34154720083844403,0.65845279916155597,10190.59,{"$f":"Calculations!Y19","v":3480.5674893922392},null,"Base funding Patients Lost",{"$f":"S18*S27","v":6818415.1123819053},null,null,null,null,null,null,null,301829538]
["Indiana","IN",116637632,76183067,133954732,0.56872247708278045,135.75029757662153,25748.90160955978,{"$f":"D20*Calculations!$B$68","v":52540046.206896558},23643020.793103442,561200,{"$f":"Calculations!Q20","v":203456.67178326158},0.36253861686254735,0.63746138313745271,4529.8100000000004,{"$f":"Calculations!Y20","v":1642.231052050136},null,"FTEs",{"$f":"INDEX(O2:O61,MATCH(S3,B2:B61,0))","v":271781.14000000007},null,null,null,null,null,null,null,116637632]
["Kansas","KS",71981196,49781171,102868002,0.48393251576909213,172.58761267507973,31421.996778403958,{"$f":"D21*Calculations!$B$68","v":34331842.068965517},15449328.931034483,288440,{"$f":"Calculations!Q21","v":94064.584046190677},0.32611490793992054,0.6738850920600794,2290.79,{"$f":"Calculations!Y21","v":747.06076995969045},null,"FTEs Lost",{"$f":"INDEX(P2:P61,MATCH(S3,B2:B61,0))","v":85641.711069206547},null,null,null,null,null,null,null,71981196]
["Kentucky","KY",121782080,86681443,120742240,0.71790487736520381,145.98143937862926,27765.775583953669,{"$f":"D22*Calculations!$B$68","v":59780305.517241381},26901137.482758619,593784,{"$f":"Calculations!Q22","v":248139.71676663365},0.41789559295406015,0.5821044070459398,4386.05,{"$f":"Calculations!Y22","v":1832.9109654761555},null,null,null,null,null,null,null,null,null,null,121782080]
["Louisiana","LA",147587503,106853304,162536291,0.65741197453558231,232.07890221494381,37058.729752192703,{"$f":"D23*Calculations!$B$68","v":73691933.793103456},33161370.206896544,460418,{"$f":"Calculations!Q23","v":182624.66492468648},0.39664970727618487,0.60335029272381513,3982.53,{"$f":"Calculations!Y23","v":1579.6693587186246},null,"330/Revenue matched to state",{"$f":"INDEX(F2:F61,MATCH(S3,B2:B61,0))","v":0.46009441181345878},null,null,null,null,null,null,null,147587503]
["Massachusetts","MA",189206346,141673183,652271058,0.21719986079774828,179.68432353866291,18806.311035216913,{"$f":"D24*Calculations!$B$68","v":97705643.448275864},43967539.551724136,788456,{"$f":"Calculations!Q24","v":140693.84902238744},0.17844223269578446,0.82155776730421559,10060.790000000001,{"$f":"Calculations!Y24","v":1795.2698302834219},null,"330/Patient matched to state",{"$f":"INDEX(G2:G61,MATCH(S3,B2:B61,0))","v":171.60538706661794},null,null,null,null,null,null,null,189206346]
["Maryland","MD",88268225,66733525,148150558,0.45044396660321723,196.92550689483204,28262.834921488768,{"$f":"D25*Calculations!$B$68","v":46023120.689655177},20710404.310344823,338877,{"$f":"Calculations!Q25","v":105240.25993784286},0.31055592423753414,0.6894440757624658,3123.12,{"$f":"Calculations!Y25","v":969.90341810472762},null,"330/FTE matched to state",{"$f":"INDEX(H2:H61,MATCH(S3,B2:B61,0))","v":27319.426517233675},null,null,null,null,null,null,null,88268225]
["Maine","ME",63051771,46011792,79236524,0.58068917813709242,234.99022997604735,30185.498441696469,{"$f":"D26*Calculations!$B$68","v":31732270.344827589},14279521.655172411,195803,{"$f":"Calculations!Q26","v":71931.082163020867},0.3673645560232523,0.63263544397674765,2088.81,{"$f":"Calculations!Y26","v":767.35475826692948},null,null,null,null,null,null,null,null,null,null,63051771]
["Marshall Islands","MH",1384758,631552,2284156,0.27649249876103033,80.926704254228596,20054.42433019551,{"$f":"D27*Calculations!$B$68","v":435553.10344827588},195998.89655172412,7804,{"$f":"Calculations!Q27","v":1690.3722210866108},0.21660330869895064,0.78339669130104939,69.05,{"$f":"Calculations!Y27","v":14.956458465662541},null,"Base funding as a % of 330",{"$f":"4/5.8","v":0.68965517241379315},null,null,null,null,null,null,null,1384758]
["Michigan","MI",181477785,137477828,247099645,0.55636594702513631,209.39557624294414,29261.596024450533,{"$f":"D28*Calculations!$B$68","v":94812295.172413796},42665532.827586204,656546,{"$f":"Calculations!Q28","v":234700.48143482395},0.35747758943748642,0.64252241056251358,6201.91,{"$f":"Calculations!Y28","v":2217.0438367082411},null,null,null,null,null,null,null,null,null,null,181477785]
["Minnesota","MN",64800453,47792604,101608470,0.47036043353472401,302.40253601867846,36056.138681623182,{"$f":"D29*Calculations!$B$68","v":32960416.55172414},14832187.44827586,158043,{"$f":"Calculations!Q29","v":50557.10987708161},0.31989464814690693,0.68010535185309307,1797.21,{"$f":"Calculations!Y29","v":574.91786059610251},null,null,null,null,null,null,null,null,null,null,64800453]
["Missouri","MO",179329000,123291369,190607652,0.64683326039817124,199.95194492422215,31991.101739513593,{"$f":"D30*Calculations!$B$68","v":85028530.344827592},38262838.655172408,616605,{"$f":"Calculations!Q30","v":242186.40230243022},0.39277398383475681,0.60722601616524319,5605.59,{"$f":"Calculations!Y30","v":2201.7299160442744},null,null,null,"PERCENT",null,null,null,null,null,null,179329000]
["Northern Mariana Islands","MP",2612522,2309217,2318817,0.99585995790094695,944.46503067484662,101615.01361338001,{"$f":"D31*Calculations!$B$68","v":1592563.4482758623},716653.55172413774,2445,{"$f":"Calculations!Q31","v":1219.9641500040839},0.4989628425374576,0.5010371574625424,25.71,{"$f":"Calculations!Y31","v":12.828334681638037},null,"Base Scroll Bar Value",{"$f":"'Fact Sheet'!H14","v":33},{"$f":"S31/100","v":0.33},null,null,null,null,null,null,2612522]
["Mississippi","MS",112575641,81502126,107277533,0.7597315460265105,261.99058144319292,51271.190832950007,{"$f":"D32*Calculations!$B$68","v":56208362.758620694},25293763.241379306,311088,{"$f":"Calculations!Q32","v":134306.48994385567},0.43173150344550631,0.56826849655449374,2195.69,{"$f":"Calculations!Y32","v":947.94854480026368},null,"Discretionary Scroll",{"$f":"'Fact Sheet'!H15","v":100},{"$f":"S32/100","v":1},null,null,null,null,null,null,112575641]
["Montana","MT",57334131,45615708,74505378,0.61224718569980274,385.66845625100399,42184.745276355294,{"$f":"D33*Calculations!$B$68","v":31459108.965517245},14156599.034482755,118277,{"$f":"Calculations!Q33","v":44915.42055418979},0.37974771556760645,0.62025228443239355,1359.12,{"$f":"Calculations!Y33","v":516.12271518224543},null,null,null,null,null,null,null,null,null,null,57334131]
["North Carolina","NC",194681722,146078891,255164708,0.57248861782249294,202.44646519801321,{"$f":"C34/O34","v":38108.102891750692},{"$f":"D34*Calculations!$B$68","v":100744062.75862069},45334828.241379306,721568,{"$f":"Calculations!Q34","v":262697.90591995965},0.36406534923937822,{"$f":"1-M34","v":0.63593465076062183},5108.67,{"$f":"Calculations!Y34","v":1859.8897276987341},null,"FUNDING BPIE CHART LINKED",null,null,null,null,null,null,null,null,194681722]
["North Dakota","ND",16195302,12475819,16372563,0.76199547987691363,346.26197613100192,46114.185649202736,{"$f":"D35*Calculations!$B$68","v":8604013.1034482773},3871805.8965517227,36030,{"$f":"Calculations!Q35","v":15581.593399934873},0.43246165417526705,0.56753834582473295,351.2,{"$f":"Calculations!Y35","v":151.88053294635381},null,"Discretionary funding",{"$f":"S13","v":1607998704.2068963},null,null,null,null,null,null,null,16195302]
["Nebraska","NE",33808415,22449826,51387482,0.43687343933294881,197.74704037770417,29702.621614260737,{"$f":"D36*Calculations!$B$68","v":15482638.620689657},6967187.3793103434,113528,{"$f":"Calculations!Q36","v":34517.561855424086},0.30404448114495181,0.69595551885504814,1138.23,{"$f":"Calculations!Y36","v":346.07254977361856},null,"Remaining Base Funding",{"$f":"S12-S37","v":2394131404.0413795},null,"Base loss relative to scroll value above.",null,null,null,null,null,33808415]
["New Hampshire","NH",32171286,24431406,43756612,0.55834775324926889,273.33392255798083,30558.12270253327,{"$f":"D37*Calculations!$B$68","v":16849245.517241381},7582160.4827586189,89383,{"$f":"Calculations!Q37","v":32025.455887249867},0.35829470802333629,0.64170529197666371,1052.79,{"$f":"Calculations!Y37","v":377.20908565988816},null,"Funding Loss",{"$f":"S12*T31","v":1179199049.7517242},null,"Discretionary loss relative to scroll value above.",null,null,null,null,null,32171286]
["New Jersey","NJ",134056042,88747962,176457222,0.50294321192475766,155.93289899532982,39897.75029092349,{"$f":"D38*Calculations!$B$68","v":61205491.034482762},27542470.965517238,569142,{"$f":"Calculations!Q38","v":190457.03340627009},0.33463886588280267,0.66536113411719733,3359.99,{"$f":"Calculations!Y38","v":1124.383242977558},null,"Total Check",{"$f":"S12+S13","v":5181329158},{"$f":"SUM(S35:S37)","v":5181329158},null,null,null,null,null,null,134056042]
["New Mexico","NM",98694854,76826217,152637318,0.50332525496811997,243.13017266478474,29234.517486826011,{"$f":"D39*Calculations!$B$68","v":52983597.931034483},23842619.068965517,315988,{"$f":"Calculations!Q39","v":105795.29622166765},0.33480795543396474,0.66519204456603531,3375.97,{"$f":"Calculations!Y39","v":1130.3016133064016},null,null,null,null,null,null,null,null,null,null,98694854]
["Nevada","NV",37027890,26611641,52405486,0.50780258005812595,237.72067533163607,33200.830292216233,{"$f":"D40*Calculations!$B$68","v":18352855.862068966},8258785.137931034,111945,{"$f":"Calculations!Q40","v":37701.195485695142},0.33678320144441592,0.66321679855558413,1115.27,{"$f":"Calculations!Y40","v":375.60420107491376},null,"PATIENTS -BARE CHART LINKED",null,null,null,null,null,null,null,null,37027890]
["New York","NY",404610742,273389168,836909567,0.32666512462032832,122.76284278638688,20496.385467708918,{"$f":"D41*Calculations!$B$68","v":188544253.79310346},84844914.206896544,2226970,{"$f":"Calculations!Q41","v":548347.44584389718},0.24623027963730862,0.75376972036269141,19740.59,{"$f":"Calculations!Y41","v":4860.7309959054583},null,"Total Patients Lost + Remaining below",null,null,null,null,null,null,null,null,404610742]
["Ohio","OH",236888423,165354161,274154523,0.60314219583384365,194.52721253695452,33008.861271007772,{"$f":"D42*Calculations!$B$68","v":114037352.41379312},51316808.586206883,850031,{"$f":"Calculations!Q42","v":319802.92527960835},0.3762250144754819,0.62377498552451804,7176.51,{"$f":"Calculations!Y42","v":2699.9825786334409},null,null,null,null,null,null,null,null,null,null,236888423]
["Oklahoma","OK",94022266,66058319,92662042,0.71289513563709295,212.19738456695342,38433.222148644119,{"$f":"D43*Calculations!$B$68","v":45557461.379310347},20500857.620689653,311306,{"$f":"Calculations!Q43","v":129563.40903618536},0.41619309951040251,0.58380690048959749,2446.38,{"$f":"Calculations!Y43","v":1018.1664747802583},null,"Patients Remaining",{"$f":"S17-S44","v":27943201.012913972},null,null,null,null,null,null,null,94022266]
["Oregon","OR",130321162,99496629,232537180,0.4278740672781875,264.25674674315763,22737.547325849599,{"$f":"D44*Calculations!$B$68","v":68618364.827586219},30878264.172413781,376515,{"$f":"Calculations!Q44","v":112825.77934084719},0.29965812607956438,0.70034187392043568,5731.54,{"$f":"Calculations!Y44","v":1717.5025359500667},null,"Patients Lost ",{"$f":"(S18*S27)*T31","v":2250076.9870860288},null,null,null,null,null,null,null,130321162]
["Pennsylvania","PA",196386466,141039594,233130108,0.60498232171710742,171.21733398401935,30623.134222463399,{"$f":"D45*Calculations!$B$68","v":97268685.517241389},43770908.482758611,823746,{"$f":"Calculations!Q45","v":310502.96370368329},0.37694017780199635,0.62305982219800371,6413.01,{"$f":"Calculations!Y45","v":2417.3211296459813},null,"Total Check",{"$f":"S17","v":30193278},{"$f":"SUM(S44:S44)","v":2250076.9870860288},null,null,null,null,null,null,196386466]
["Puerto Rico","PR",129865437,95470007,121743939,0.78418694009892354,231.03973195811423,28569.544767565927,{"$f":"D46*Calculations!$B$68","v":65841384.137931041},29628622.862068959,413219,{"$f":"Calculations!Q46","v":181618.26875762848},0.43952061439001711,0.56047938560998289,4545.59,{"$f":"Calculations!Y46","v":1997.880509565118},null,null,null,null,null,null,null,null,null,null,129865437]
["Palau","PW",1871002,704526,704526,1,48.33465971459934,15594.282380396733,{"$f":"D47*Calculations!$B$68","v":485880.00000000006},218645.99999999994,14576,{"$f":"Calculations!Q47","v":7287.9999999999991},0.49999999999999994,0.5,119.98,{"$f":"Calculations!Y47","v":59.99},null,"FTE BAR CHART LINKED (Discretionary first for barchart order)",null,null,null,null,null,null,null,null,1871002]
["Rhode Island","RI",39684147,31558829,66397176,0.47530378400430767,166.54087157512561,19659.437327230033,{"$f":"D48*Calculations!$B$68","v":21764709.655172415},9794119.3448275849,189496,{"$f":"Calculations!Q48","v":61050.589600749838},0.32217350023615188,0.67782649976384812,2018.58,{"$f":"Calculations!Y48","v":650.33298410669158},null,"FTEs Remaining",{"$f":"S20-S49","v":252290.26782562892},null,null,null,null,null,null,null,39684147]
["South Carolina","SC",125978603,94599292,173305225,0.5458536636734409,216.55810141679504,28842.90607292084,{"$f":"D49*Calculations!$B$68","v":65240891.034482762},29358400.965517238,436831,{"$f":"Calculations!Q49","v":154248.62479512431},0.35310823818621917,0.64689176181378083,4367.75,{"$f":"Calculations!Y49","v":1542.2885073378586},null,"FTEs Lost",{"$f":"S21*S27*T31","v":19490.872174371147},null,null,null,null,null,null,null,125978603]
["South Dakota","SD",24877040,20866363,28439997,0.73369779188092044,207.22960115997299,32109.349992255666,{"$f":"D50*Calculations!$B$68","v":14390595.172413794},6475767.8275862057,100692,{"$f":"Calculations!Q50","v":42612.673561706848},0.42319820404507658,0.57680179595492342,774.76,{"$f":"Calculations!Y50","v":327.87704056596351},null,null,{"$f":"SUM(S48:S49)","v":271781.14000000007},null,null,null,null,null,null,null,24877040]
["Tennessee","TN",128687566,91350958,139447159,0.65509371904808755,208.97988232279789,39101.688189359185,{"$f":"D51*Calculations!$B$68","v":63000660.689655177},28350297.310344823,437128,{"$f":"Calculations!Q51","v":173017.27625717153},0.39580460701938913,0.60419539298061087,3291.1,{"$f":"Calculations!Y51","v":1302.6325421615115},null,"Total Check",{"$f":"S20","v":271781.14000000007},null,null,null,null,null,null,null,128687566]
["Texas","TX",407615395,284671241,562394227,0.50617738826824765,163.99019819068334,28465.418197486393,{"$f":"D52*Calculations!$B$68","v":196324993.79310346},88346247.206896544,1735904,{"$f":"Calculations!Q52","v":583381.05448168737},0.3360675788993443,0.66393242110065565,14319.67,{"$f":"Calculations!Y52","v":4812.3768275375733},null,null,null,null,null,null,null,null,null,null,407615395]
["Utah","UT",58226122,42064266,80935750,0.51972417627562606,257.19514521553043,40361.371670987515,{"$f":"D53*Calculations!$B$68","v":29009838.620689657},13054427.379310343,163550,{"$f":"Calculations!Q53","v":55931.787068222824},0.34198585795305914,0.65801414204694086,1442.62,{"$f":"Calculations!Y53","v":493.35563840024213},null,"FTEs Lost ",{"$f":"S26*S32*T36","v":0},null,null,null,null,null,null,null,58226122]
["Virginia","VA",128118038,93409211,138814624,0.67290612695100482,247.2929152536091,35811.969744403948,{"$f":"D54*Calculations!$B$68","v":64420145.517241381},28989065.482758619,377727,{"$f":"Calculations!Q54","v":151936.08805658127},0.40223782799900792,0.59776217200099202,3577.52,{"$f":"Calculations!Y54","v":1439.0138744230107},null,"FTEs Remaining",null,null,null,null,null,null,null,null,128118038]
["Virgin Islands","VI",5759509,3271826,9724618,0.33644776586597025,205.38769617074701,25104.650858687124,{"$f":"D55*Calculations!$B$68","v":2256431.7241379311},1015394.2758620689,15930,{"$f":"Calculations!Q55","v":4010.3422274585259},0.25174778577894075,0.74825221422105925,229.42,{"$f":"Calculations!Y55","v":57.755977013404589},null,null,null,null,null,null,null,null,null,null,5759509]
["Vermont","VT",39313153,25404664,55297688,0.45941638645000854,137.55896080830834,24359.855624748274,{"$f":"D56*Calculations!$B$68","v":17520457.931034483},7884206.068965517,184682,{"$f":"Calculations!Q56","v":58136.89490546695},0.31479459235587093,0.68520540764412907,1613.85,{"$f":"Calculations!Y56","v":508.03125287352213},null,null,null,null,null,null,null,null,null,null,39313153]
["Washington","WA",198895019,138602346,325897930,0.42529372923602182,115.93836633394201,16986.826894006037,{"$f":"D57*Calculations!$B$68","v":95587824.827586219},43014521.172413781,1195483,{"$f":"Calculations!Q57","v":356720.45198767114},0.29839023389514624,0.7016097661048537,11708.78,{"$f":"Calculations!Y57","v":3493.7856028268111},null,null,null,null,null,null,null,null,null,null,198895019]
["Wisconsin","WI",82528579,49105300,112134778,0.4379132047686401,179.72411117536399,31248.633677012374,{"$f":"D58*Calculations!$B$68","v":33865724.137931034},15239575.862068966,273226,{"$f":"Calculations!Q58","v":83210.358517688146},0.30454773161298027,0.69545226838701968,2641.03,{"$f":"Calculations!Y58","v":804.31969562182928},null,null,null,null,null,null,null,null,null,null,82528579]
["West Virginia","WV",108622260,80104446,130865789,0.61211143578555893,158.88600710484505,27441.574813493637,{"$f":"D59*Calculations!$B$68","v":55244445.517241381},24860000.482758619,504163,{"$f":"Calculations!Q59","v":191428.41552363063},0.3796954864272678,0.6203045135727322,3958.31,{"$f":"Calculations!Y59","v":1502.9524408799184},null,null,null,null,null,null,null,null,null,null,108622260]
["Wyoming","WY",13028312,8643254,19102485,0.45246751927825096,248.79833045480714,{"$f":"C60/O60","v":42422.298199342251},{"$f":"D60*Calculations!$B$68","v":5960864.8275862075},2682389.1724137925,34740,{"$f":"Calculations!Q59","v":191428.41552363063},{"$f":"L60/K60","v":5.5103170847331784},{"$f":"1-M60","v":-4.5103170847331784},307.11,{"$f":"Calculations!Y60","v":95.669815676562081},null,null,null,null,null,null,null,null,null,null,13028312]
["United States","US",{"$f":"SUM(C1:C60)","v":7424904883},{"$f":"SUM(D1:D60)","v":5181329158},{"$f":"SUM(E1:E60)","v":11261447705},0.46009441181345878,{"$f":"D61/K61","v":171.60538706661794},27319.426517233675,{"$f":"D61*Calculations!$B$68","v":3573330453.7931037},1607998704.2068963,{"$f":"SUM(K1:K60)","v":30193278},{"$f":"SUM(L2:L60)","v":9886701.9129537623},0.32744711961893513,0.67255288038106487,{"$f":"SUM(O1:O60)","v":271781.14000000007},{"$f":"Calculations!Y61","v":85641.711069206547},null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AA1:AA60)","v":7424904883}]
[]
[null,"Total",{"$f":"SUM(C2:C60)","v":7424904883},null,{"$f":"SUM(E2:E60)","v":11261447705},null,null,null,{"$f":"SUM(I2:I60)","v":3573330453.7931037},{"$f":"SUM(J2:J60)","v":1607998704.2068961},30193278,{"$f":"SUM(L2:L60)","v":9886701.9129537623},null,null,{"$f":"SUM(O2:O60)","v":271781.14000000007},{"$f":"SUM(P2:P60)","v":85625.583381116085},null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AA2:AA60)","v":7424904883}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L2:L60)","v":9886701.9129537623}]
[null,null,null,null,null,null,null,null,"Total Check",{"$f":"SUM(I63:J63)","v":5181329158},null,{"$f":"L64-L63","v":0}]
[null,null,null,{"$f":"1.74/5.64","v":0.30851063829787234},null,null,null,null,null,"From PPT: 4.0+1.7=5.7B",null,4240217.6972055007]
[null,null,null,{"$f":"1-D66","v":0.6914893617021276}]
[null,null,null,{"$f":"D67*D61","v":3582833992.2340422}]

{"sheet":"Calculations","index":3,"n_rows":68,"n_cols":40,"rows_kept":68,"cut":false,"hidden":true,"merged":[]}
["Full State Name","State","BPHC Funding","330 Funding","Total Third Party Revenue (SB Patient Revenue Line 14","All other Revenue Line 11 MINUS COVID","Total Revenue E+F","Total Funding (Grant + Revenue)","Grant/Revenue","Grant/TOTAL","Base Funding","Discretionary Funding","DEDICATED EXPENDITURES ON PATIENTS","Total Patients","Expenditure per patient","Percent of budget to patients","Patients Immediately Losing Access (Base AND Discretionary)","%  losing access","Grant Dollars per Patient","Total Revenue per Patient","Total Payroll Expenditure","Total Staff","Payroll per FTE","Payroll as a Percent of Total Revenue","Lost Staff",null,null,null,null,null,"330/Expense per patient",null,null,"lost ftes","patients per fte","revenue -cost per patient"," =lost revenue","divided by cost per fte","times operaiting cost","divided by cost per patient"]
["Alaska","AK",90661610,72253082,203966933,259645704,{"$f":"E2+F2","v":463612637},{"$f":"F2+D2","v":331898786},{"$f":"D2/G2","v":0.15584795631875756},{"$f":"D2/H2","v":0.21769613221785028},{"$f":"D2*$B$68","v":49829711.724137932},{"$f":"D2-(D2*$B$68)","v":22423370.275862068},204035120,114987,{"$f":"M2/N2","v":1774.4190212806666},{"$f":"M2/H2","v":0.61475102834512929},{"$f":"(D2/O2)*P2","v":25032.225155333948},{"$f":"Q2/N2","v":0.21769613221785025},{"$f":"D2/N2","v":628.35870141842122},{"$f":"G2/N2","v":4031.870011392592},163042391,2625.74,{"$f":"U2/V2","v":62093.882486460963},{"$f":"U2/H2","v":0.49124129968947822},{"$f":"(D2/W2)*X2","v":571.61344220969818},null,null,"grant funding/cost per pat/funding ratio",null,null,{"$f":"D2/O2","v":40719.289600408003},{"$f":"(D2/O2)*P2","v":25032.225155333948}]
["Alabama","AL",119973997,89208291,144072531,122281875,296352631,{"$f":"F3+D3","v":211490166},{"$f":"D3/G3","v":0.30102074916284444},{"$f":"D3/H3","v":0.42180822251565114},{"$f":"D3*$B$68","v":61522959.31034483},{"$f":"D3-(D3*$B$68)","v":27685331.68965517},179879413,312405,{"$f":"M3/N3","v":575.78916150509758},{"$f":"M3/H3","v":0.85053322526589725},131774.997755002,0.42180822251565114,285.55333941518222,948.61679870680689,146616081,2370.2199999999998,{"$f":"U3/V3","v":61857.583262313208},{"$f":"U3/H3","v":0.69325247491649333},999.7782851710466]
["Arkansas","AR",76087640,57870173,181978298,75755912,275018934,133626085,0.21042250494651396,0.43307542086561918,39910464.137931034,17959708.862068966,173830701,285888,608.03776653794489,{"$f":"M4/H4","v":1.3008740097414364},123811.06592043015,0.43307542086561923,202.4225326001791,961.98138431833445,145062893,2262.9699999999998,64102.879401848018,1.0855881394714213,980.0366851562701]
["American Samoa","AS",4088614,3878178,7242057,11816754,19269247,15694932,0.20126256101237375,0.24709747069945892,2674605.5172413797,1203572.4827586203,4470186,11117,402.10362507870826,0.28481716263568391,2746.9825817658848,0.24709747069945892,348.8511289016821,1733.3135738058829,2859296,107.5,26598.102325581396,0.18217957236132021,26.562978100191831]
["Arizona","AZ",145580240,88262748,732224162,180298374,969577255,268561122,9.1032197326039788E-2,0.32865050362725251,60870860.689655177,27391887.310344823,519688120,800024,649.5906622801316,1.9350832172945718,262928.29051388905,0.32865050362725251,110.32512524624261,1211.9352106936792,444308318,7878.9,56392.176319029306,1.6544029705088885,2589.4044530287597]
["California","CA",1135286122,704413536,5726129837,2184356804,8329737476,2888770340,8.4566114842104773E-2,0.24384546124909329,485802438.62068969,218611097.37931031,4259252119,5239583,812.89906448662043,1.4744170071339073,1277648.5333879078,0.24384546124909326,134.44076293857736,1589.77107071307,3526056894,50973.8,69173.906869803701,1.2206082446830993,12429.72977261903]
["Colorado","CO",146194880,110662993,466704315,262914050,765150252,373577043,0.14462910089977987,0.296225357188236,76319305.517241389,34343687.482758611,409734599,634878,645.37533037843491,1.0967874142094969,188066.96232095291,0.296225357188236,174.30591861743517,1205.1925755814502,356183067,6036.42,59005.680022264853,0.95343938733408728,{"$f":"(D8/W8)*X8","v":1788.1406706382115}]
["Connecticut","CT",88985726,63058705,432691841,153218251,611435065,216276956,0.10313230072926878,0.29156460385913696,43488762.068965517,19569942.931034483,266795724,409362,651.7354419804476,1.2335836833213059,119355.46936498403,0.29156460385913696,154.04142299480657,1493.6292694485564,251701547,4543.09,55403.161064385691,1.1637927204782741,1324.6042361464067]
["District of Columbia","DC",37367206,27070650,281051364,84338957,375137674,111409607,7.2161907150919746E-2,0.24298308493270243,18669413.793103449,8401236.206896551,161584462,190987,846.0495321671109,1.4503638092898039,46406.610442042038,0.24298308493270243,141.74079911198143,1964.2052809877111,133367744,2249.9699999999998,59275.343226798585,{"$f":"U10/H10","v":1.1970937479386314},546.70465160603237]
["Delaware","DE",14874584,13620157,26957257,18606332,46818016,32226489,0.29091700511187829,0.42263856295360008,9393211.7241379321,4226945.2758620679,17371151,46592,372.83548677884613,0.53903330890312007,19691.575925134133,0.42263856295360003,292.32823231456047,1004.8509615384615,22958304,396.74,57867.379139990924,0.71240475498277211,167.67762346621132]
["Florida","FL",392616463,249107404,1009700019,511688802,1660472003,760796206,0.15002204406333491,0.32742987154170955,171798209.65517244,77309194.344827563,722823685,1676685,431.10285175808218,0.9500884458932225,548996.75416591123,0.32742987154170955,148.57137983580697,990.33032620915674,609263067,11931.87,51061.825765785245,0.80082295652247248,3906.8506613523782]
["Federated States of Micronesia","FM",5783400,3269239,129515,3300181,5943857,6569420,0.55001979354483121,0.49764499757969499,2254647.5862068967,1014591.4137931033,3823010,21288,179.58521232619316,0.58194026261070231,10593.866708476546,0.49764499757969494,153.57191845170988,279.21162157083802,2399753,131.61000000000001,18233.819618570014,0.36529145647560973,65.495058131463679]
["Georgia","GA",184086708,129186876,343973249,176604743,574203343,305791619,0.22498454175666477,0.42246702647530704,89094397.241379321,40092478.758620679,295437009,662164,446.16893851070125,0.96613834599567627,279742.45611899527,0.42246702647530715,195.09800593206518,867.16182546921914,240497023,3959.94,60732.491653913945,0.786473559303141,1672.9440768206273]
["Guam","GU",2993481,1998168,2610419,3342745,6948477,5340913,0.2875692040140595,0.37412479851291341,1378046.8965517243,620121.10344827571,5115627,8012,638.49563155267094,0.9578188223623938,2997.4878856854625,0.37412479851291347,249.39690464303544,867.258736894658,4252897,78.91,53895.539221898369,0.79628651505838044,29.522187850653996]
["Hawaii","HI",46604628,35199210,173948430,84343785,268928685,119542995,0.13088678137849075,0.29444811885464306,24275317.241379313,10923892.758620687,129434518,154284,838.93675300095924,1.0827444803436621,45428.633569369747,0.29444811885464306,228.14556272847477,1743.0756591739907,105904374,2072.7199999999998,51094.394804894058,0.8859103287482466,610.30850491239562]
["Iowa","IA",59133085,47580524,175109088,77746636,263382737,125327160,0.18065164232840364,0.3796505402340562,32814154.482758623,14766369.517241377,122945926,252926,486.09445450447959,0.98099985669506917,96023.492539238898,0.3796505402340562,188.12033559222857,1041.3430687236582,102199800,2094.0100000000002,48805.784117554351,0.8154641021148169,794.99202775551612]
["Idaho","ID",72793166,48184553,211822502,116542298,352941903,164726851,0.13652261913485517,0.29251183220882432,33230726.206896555,14953826.793103445,152138350,202675,750.65178241026274,0.92357954441805001,59284.835592923468,0.29251183220882432,237.74295300357716,1741.4180485999752,121555704,2233.7399999999998,54418.018211609233,0.7379228295938226,653.39538007813917]
["Illinois","IL",301829538,221180620,947540224,426403724,1454492866,647584344,0.15206717418165736,0.34154720083844398,152538358.62068966,68642261.37931034,802226921,1448136,553.97208618527543,1.2387991285348308,494606.79723338096,0.34154720083844403,152.73470171309876,1004.3896885375407,674307190,10190.59,66169.592732118545,{"$f":"U19/H19","v":1.0412654293569519},3480.5674893922392]
["Indiana","IN",116637632,76183067,383440979,133954732,557556276,210137799,0.13663744859361962,0.3625386168625474,52540046.206896558,23643020.793103442,323804634,561200,576.98616179615112,1.5409157017010537,203456.67178326158,0.36253861686254735,135.75029757662153,993.50726300784038,271389119,4529.8100000000004,59911.810649894804,1.291481686262451,1642.231052050136]
["Kansas","KS",71981196,49781171,177284938,102868002,301818144,152649173,0.16493763542592058,0.32611490793992054,34331842.068965517,15449328.931034483,131599618,288440,456.24607544029953,0.86210501775859605,94064.584046190677,0.32611490793992054,172.58761267507973,1046.3810289834973,106810171,2290.79,46625.911148555737,0.69971011896671065,747.06076995969045]
["Kentucky","KY",121782080,86681443,436565564,120742240,591672168,207423683,0.14650248513971001,0.41789559295406015,59780305.517241381,26901137.482758619,317799563,593784,535.21072140711101,1.5321276645155317,248139.71676663365,0.41789559295406015,145.98143937862926,996.4434339759913,278735437,4386.05,63550.446757332902,1.3437975498680157,1832.9109654761555]
["Louisiana","LA",147587503,106853304,334991463,162536291,537436395,269389595,0.19882037203676911,0.39664970727618487,73691933.793103456,33161370.206896544,217462824,460418,472.31607799868817,0.80724284841068195,182624.66492468648,0.39664970727618487,232.07890221494381,1167.2792875169955,196849191,3982.53,49428.175305647412,0.73072306671681209,1579.6693587186246]
["Massachusetts","MA",189206346,141673183,756638957,652271058,1455380379,793944241,9.734443657770378E-2,0.17844223269578449,97705643.448275864,43967539.551724136,567771381,788456,720.10534639853086,0.71512752619109932,140693.84902238744,0.17844223269578446,179.68432353866291,1845.861251610743,531004370,10060.790000000001,52779.58987316105,0.66881821490534621,1795.2698302834219]
["Maryland","MD",88268225,66733525,339703492,148150558,509356435,214884083,0.1310153762953834,0.31055592423753414,46023120.689655177,20710404.310344823,214331433,338877,632.47559734062804,0.99742814827285275,105240.25993784286,0.31055592423753414,196.92550689483204,1503.0717192373634,202340050,3123.12,64787.792335869264,0.94162418721353136,969.90341810472762]
["Maine","ME",63051771,46011792,166678390,79236524,262907215,125248316,0.17501152260123404,0.36736455602325224,31732270.344827589,14279521.655172411,139633680,195803,713.13350663677272,1.1148547498235426,71931.082163020867,0.3673645560232523,234.99022997604735,1342.7129053181004,119330207,2088.81,57128.320431250329,0.9527489934475446,767.35475826692948]
["Marshall Islands","MH",1384758,631552,30836,2284156,3068198,2915708,0.20583808476506404,0.21660330869895064,435553.10344827588,195998.89655172412,1118455,7804,143.31817016914403,0.38359636836061772,1690.3722210866108,0.21660330869895064,80.926704254228596,393.15709892362889,1118455,69.05,16197.755249818973,0.38359636836061772,14.956458465662541]
["Michigan","MI",181477785,137477828,495951664,247099645,786589807,384577473,0.17477702708140991,0.35747758943748636,94812295.172413796,42665532.827586204,341907755,656546,520.76740243638676,0.88904779661912225,234700.48143482395,0.35747758943748642,209.39557624294414,1198.0726514212256,314811868,6201.91,50760.47024223183,0.81859154553236146,2217.0438367082411]
["Minnesota","MN",64800453,47792604,123608133,101608470,242224452,149401074,0.19730709928492274,0.31989464814690688,32960416.55172414,14832187.44827586,99458417,158043,629.31238333871158,0.665714203634172,50557.10987708161,0.31989464814690693,302.40253601867846,1532.6490385527989,81003570,1797.21,45071.844692606872,0.54218867261958237,574.91786059610251]
["Missouri","MO",179329000,123291369,473641890,190607652,718109223,313899021,0.17168888109378871,0.39277398383475687,85028530.344827592,38262838.655172408,250505690,616605,406.26606985022829,0.79804546443615698,242186.40230243022,0.39277398383475681,199.95194492422215,1164.6179044931521,206862586,5605.59,36902.910487566871,0.65900997505818915,2201.7299160442744]
["Northern Mariana Islands","MP",2612522,2309217,238899,2318817,2861021,4628034,0.80713039156301192,0.4989628425374576,1592563.4482758623,716653.55172413774,2372599,2445,970.38813905930465,0.51265807468138735,1219.9641500040839,0.4989628425374576,944.46503067484662,1170.1517382413087,1728447,25.71,67228.588098016335,0.37347327180396689,12.828334681638037]
["Mississippi","MS",112575641,81502126,137827837,107277533,274641252,188779659,0.29675850006684357,0.43173150344550626,56208362.758620694,25293763.241379306,146404869,311088,470.62203942292854,0.77553307266012173,134306.48994385567,0.43173150344550631,261.99058144319292,882.84103533405334,121616224,2195.69,55388.613146664604,0.64422313634966355,947.94854480026368]
["Montana","MT",57334131,45615708,119664687,74505378,205876389,120121086,0.22156842861664919,0.3797477155676065,31459108.965517245,14156599.034482755,75688924,118277,639.92935228319959,0.63010522565538574,44915.42055418979,0.37974771556760645,385.66845625100399,1740.6291079415271,68301121,1359.12,50253.929748660899,0.5686022602226557,516.12271518224543]
["North Carolina","NC",194681722,146078891,387803200,255164708,691051451,401243599,0.21138641817279102,0.36406534923937817,100744062.75862069,45334828.241379306,291409433,721568,403.85581539092641,0.72626562448912735,{"$f":"(D34/O34)*P34","v":262697.90591995965},{"$f":"Q34/N34","v":0.36406534923937822},{"$f":"D34/N34","v":202.44646519801321},{"$f":"G34/N34","v":957.70800672978851},261718943,5108.67,51230.348211961231,{"$f":"U34/H34","v":0.65226945340005282},1859.8897276987341]
["North Dakota","ND",16195302,12475819,29456991,16372563,49236408,28848382,0.25338605123265695,0.43246165417526711,8604013.1034482773,3871805.8965517227,20560648,36030,570.65356647238411,0.71271407873065462,15581.593399934873,0.43246165417526705,346.26197613100192,1366.5392173189009,18090496,351.2,51510.523917995444,0.62708875665886565,151.88053294635381]
["Nebraska","NE",33808415,22449826,66328851,51387482,128141840,73837308,0.17519512752431213,0.30404448114495181,15482638.620689657,6967187.3793103434,60975099,113528,537.09304312592485,0.8258033865481661,34517.561855424086,0.30404448114495181,197.74704037770417,1128.724543724896,49466758,1138.23,43459.369371743844,0.66994259866570438,346.07254977361856]
["New Hampshire","NH",32171286,24431406,69888880,43756612,121385372,68188018,0.20127141843747037,0.35829470802333629,16849245.517241381,7582160.4827586189,69033347,89383,772.33195350346261,1.0123970313963371,32025.455887249867,0.35829470802333629,273.33392255798083,1358.0364498842061,61582372,1052.79,58494.449985277221,0.9031260008173283,377.20908565988816]
["New Jersey","NJ",134056042,88747962,266226948,176457222,487016853,265205184,0.1822277020873444,0.33463886588280267,61205491.034482762,27542470.965517238,173098866,569142,304.14003183739737,0.65269789748906271,190457.03340627009,0.33463886588280267,155.93289899532982,855.70359066805827,233765438,3359.99,69573.254087065739,0.88145123890187604,1124.383242977558]
["New Mexico","NM",98694854,76826217,199562062,152637318,373917471,229463535,0.2054630311724589,0.33480795543396469,52983597.931034483,23842619.068965517,158972250,315988,503.09584541185109,0.69279962064560718,105795.29622166765,0.33480795543396474,243.13017266478474,1183.328072585035,132252536,3375.97,39174.677500096273,0.57635534988162718,1130.3016133064016]
["Nevada","NV",37027890,26611641,90391682,52405486,153106287,79017127,0.17381154961977491,0.33678320144441598,18352855.862068966,8258785.137931034,61141839,111945,546.17748894546435,0.77377957566085642,37701.195485695142,0.33678320144441592,237.72067533163607,1367.6920541337263,48043641,1115.27,43078.035811955851,0.60801553820097765,375.60420107491376]
["New York","NY",404610742,273389168,2201173576,836909567,3193028047,1110298735,8.5620659754887515E-2,0.24623027963730859,188544253.79310346,84844914.206896544,1569344077,2226970,704.69924471366926,1.4134430919620926,548347.44584389718,0.24623027963730862,122.76284278638688,1433.7993089264785,1456692983,19740.59,73791.765241059155,1.311982925928489,4860.7309959054583]
["Ohio","OH",236888423,165354161,565774304,274154523,910436796,439508684,0.18162069209689544,0.3762250144754819,114037352.41379312,{"$f":"D42-(D42*$B$68)","v":51316808.586206883},374426241,850031,440.48539523852662,0.85192000665907208,319802.92527960835,0.3762250144754819,194.52721253695452,1071.0630506416824,336159933,7176.51,46841.700631644067,0.76485390445664092,2699.9825786334409]
["Oklahoma","OK",94022266,66058319,203966913,92662042,323524123,158720361,0.20418359653508744,0.41619309951040245,45557461.379310347,20500857.620689653,166513219,311306,534.88599320282935,1.0490980360106414,129563.40903618536,0.41619309951040251,212.19738456695342,1039.2479521756727,143045708,2446.38,58472.399218437036,0.90124359029148127,1018.1664747802583]
["Oregon","OR",130321162,99496629,630373599,232537180,893116238,332033809,0.11140389656648478,0.29965812607956438,68618364.827586219,30878264.172413781,370570738,376515,984.21241650399054,1.1160632681233977,112825.77934084719,0.29965812607956438,264.25674674315763,2372.0601782133513,307782475,5731.54,53699.786619303013,0.92696125110560657,1717.5025359500667]
["Pennsylvania","PA",196386466,141039594,616649640,233130108,922225151,374169702,0.15293401383281077,0.3769401778019964,97268685.517241389,43770908.482758611,356349564,823746,432.59641200078664,0.95237418234360405,310502.96370368329,0.37694017780199635,171.21733398401935,1119.5503844631719,364746010,6413.01,56875.945928666879,0.9748143905034834,2417.3211296459813]
["Puerto Rico","PR",129865437,95470007,327126770,121743939,480750148,217213946,0.19858549684731455,0.43952061439001711,65841384.137931041,29628622.862068959,242021112,413219,585.69695972353645,1.1142061384953617,181618.26875762848,0.43952061439001711,231.03973195811423,1163.4270156986972,190851017,4545.59,41985.972558017769,0.8786315083102445,1997.880509565118]
["Palau","PW",1871002,704526,907597,704526,2778599,1409052,0.25355439917742717,0.5,485880.00000000006,218645.99999999994,2236136,14576,153.41218441273327,1.5869790469052951,7287.9999999999991,0.49999999999999994,48.33465971459934,190.62836169045005,1707269,119.98,14229.613268878145,1.2116437150651644,59.99]
["Rhode Island","RI",39684147,31558829,208230807,66397176,282618507,97956005,0.11166582590431702,0.32217350023615193,21764709.655172415,9794119.3448275849,147572179,189496,778.76144615189764,1.5065148787968639,61050.589600749838,0.32217350023615188,166.54087157512561,1491.4220194621523,129457244,2018.58,64132.828027623378,1.3215855832421912,650.33298410669158]
["South Carolina","SC",125978603,94599292,436966512,173305225,637692393,267904517,0.14834627641543782,0.35310823818621917,65240891.034482762,29358400.965517238,295919453,436831,677.42319798732228,1.1045705996812289,154248.62479512431,0.35310823818621917,216.55810141679504,1459.8148780649724,242652872,4367.75,55555.577127811805,0.9057438624672387,1542.2885073378586]
["South Dakota","SD",24877040,20866363,56892065,28439997,89342739,49306360,0.2335541000147757,0.42319820404507652,14390595.172413794,6475767.8275862057,58214301,100692,578.14226552258367,1.1806651515139224,42612.673561706848,0.42319820404507658,207.22960115997299,887.28736145870573,51813938,774.76,66877.404615622901,1.0508570902415024,327.87704056596351]
["Tennessee","TN",128687566,91350958,200606692,139447159,377332422,230798117,0.24209676315596332,0.39580460701938913,63000660.689655177,28350297.310344823,217760014,437128,498.16075382954193,0.94350862489922305,173017.27625717153,0.39580460701938913,208.97988232279789,863.20808092824075,172597475,3291.1,52443.704232627388,0.74782878319583512,1302.6325421615115]
["Texas","TX",407615395,284671241,1221037844,562394227,1905687621,847065468,0.14937980278773086,0.3360675788993443,196324993.79310346,88346247.206896544,976266251,1735904,562.39645222316437,1.1525275057016018,583381.05448168737,0.3360675788993443,163.99019819068334,1097.8070336838903,792536541,14319.67,55346.005948461105,0.93562607725144564,4812.3768275375733]
["Utah","UT",58226122,42064266,99474011,80935750,196570567,123000016,0.2139906632105304,0.34198585795305914,29009838.620689657,13054427.379310343,81841601,163550,500.40722103332314,0.66537878336536149,55931.787068222824,0.34198585795305914,257.19514521553043,1201.8989116478142,68114631,1442.62,47215.920339382516,0.55377741576879147,493.35563840024213]
["Virginia","VA",128118038,93409211,236687386,138814624,408682403,232223835,0.22856186200901829,0.40223782799900792,64420145.517241381,28989065.482758619,210836275,377727,558.17104681423359,0.90790109895480797,151936.08805658127,0.40223782799900792,247.2929152536091,1081.9517879314956,177193334,3577.52,49529.65573917127,0.76302819648120956,1439.0138744230107]
["Virgin Islands","VI",5759509,3271826,10947803,9724618,22993304,12996444,0.14229473067463466,0.25174778577894075,2256431.7241379311,1015394.2758620689,19537270,15930,1226.4450721908349,1.5032781274631737,4010.3422274585259,0.25174778577894075,205.38769617074701,1443.3963590709354,10334046,229.42,45044.22456629762,0.79514411788332251,57.755977013404589]
["Vermont","VT",39313153,25404664,149829941,55297688,218969339,80702352,0.11601927519176555,0.31479459235587087,17520457.931034483,7884206.068965517,110951086,184682,600.76827194853854,1.3748184935180081,58136.89490546695,0.31479459235587093,137.55896080830834,1185.6560953422641,103811710,1613.85,64325.501130836201,1.2863529677548926,508.03125287352213]
["Washington","WA",198895019,138602346,1461676401,325897930,1847832145,464500276,7.5008082511737018E-2,0.2983902338951463,95587824.827586219,43014521.172413781,730693105,1195483,611.21162325185719,1.5730735647614555,356720.45198767114,0.29839023389514624,115.93836633394201,1545.6783116112902,607329128,11708.78,51869.548151045623,1.3074892726220899,3493.7856028268111]
["Wisconsin","WI",82528579,49105300,204659795,112134778,350217852,161240078,0.14021358340122536,0.30454773161298027,33865724.137931034,15239575.862068966,98222024,273226,359.49003389135731,0.60916631409716882,83210.358517688146,0.30454773161298027,179.72411117536399,1281.7881607167692,87760547,2641.03,33229.666834530464,0.54428494508666758,804.31969562182928]
["West Virginia","WV",108622260,80104446,362983419,130865789,521899868,210970235,0.15348623540943299,0.3796954864272678,55244445.517241381,24860000.482758619,277233275,504163,549.8881810049528,1.3140871507300544,191428.41552363063,0.3796954864272678,158.88600710484505,1035.1808204886117,239369940,3958.31,60472.762365757102,1.1346147479050777,1502.9524408799184]
["Wyoming","WY",13028312,8643254,25595110,19102485,49082653,27745739,0.17609590092858265,0.31151644582254595,5960864.8275862075,2682389.1724137925,28687301,34740,825.77147380541157,1.0339353729233884,10822.081327875247,0.31151644582254595,248.79833045480714,1412.8570236039147,23961688,307.11,78023.14480153691,0.86361686023212425,95.669815676562081]
["United States","US",{"$f":"SUM(C1:C60)","v":7424904883},{"$f":"SUM(D1:D60)","v":5181329158},{"$f":"SUM(E1:E60)","v":25345338569},11261447705,38827557009,16442776863,0.13344463461347822,0.31511278181115338,3573330453.7931037,1607998704.2068963,{"$f":"SUM(M2:M60)","v":18430833187},{"$f":"SUM(N2:N60)","v":30193278},610.42836047811704,1.1209075778722986,9514287.822577497,0.31511278181115338,171.60538706661794,1285.9669297583389,{"$f":"SUM(U2:U60)","v":15867275832},{"$f":"SUM(V2:V60)","v":271781.14000000007},58382.549399859003,0.96499976641445473,85641.711069206547]
[]
[null,"Total",{"$f":"SUM(C2:C60)","v":7424904883},null,{"$f":"SUM(E2:E60)","v":25345338569},{"$f":"SUM(F2:F60)","v":11261447705},{"$f":"SUM(G2:G60)","v":38827557009},{"$f":"SUM(H2:H60)","v":16442776863},null,null,{"$f":"SUM(K2:K60)","v":3573330453.7931037},{"$f":"SUM(L2:L61)","v":3215997408.4137926},null,30193278,null,null,{"$f":"SUM(Q2:Q60)","v":9706095.5787580069},null,{"$f":"SUM(S2:S61)","v":13295.14350531878},{"$f":"SUM(T2:T61)","v":75538.352537547311},null,null,null,null,{"$f":"SUM(Y2:Y60)","v":85625.583381116085}]
[null,"Total check",null,null,null,null,null,null,null,null,null,{"$f":"SUM(K63:L63)","v":6789327862.2068958},null,null,null,null,null,null,{"$f":"C63/N63","v":245.91251347402559}]
[null,null,null,null,null,null,null,null,null,null,null,{"$f":"C63-K63","v":3851574429.2068963}]
[null,null,"5.7 B",{"$f":"1.74/5.64","v":0.30851063829787234}]
[null,null,null,{"$f":"1-D66","v":0.6914893617021276},null,null,null,null,null,null,null,{"$f":"C63-K63-L63","v":635577020.79310369}]
["CHCF as a % of 330",{"$f":"4/5.8","v":0.68965517241379315},null,{"$f":"D67*D61","v":3582833992.2340422}]

{"sheet":"2021 Output","index":4,"n_rows":62,"n_cols":10,"rows_kept":62,"cut":false,"hidden":true,"merged":[]}
["HealthCenterState","Total Patients","Total FTE","Patient Revenue","Other Revenue","Total Revenue","BHPC Funding","Medical Cost","Medical FTE Cost","CHC ONLY T9EL1BCA"]
["AK",114987,2625.74,203966933,277760642,481727575,90661610,204035120,163042391,70559486]
["AL",312405,2370.2199999999998,144072531,152280100,296352631,119973997,179879413,146616081,75580003]
["AR",285888,2262.9699999999998,181978298,93040636,275018934,76087640,173830701,145062893,56866636]
["AS",11117,107.5,7242057,12027190,19269247,4088614,4470186,2859296,3878178]
["AZ",800024,7878.9,732224162,237353093,969577255,145580240,519688120,444308318,75078974]
["CA",5239583,50973.8,5726129837,2603607639,8329737476,1135286122,4259252119,3526056894,475573026]
["CO",634878,6036.42,466704315,298445937,765150252,146194880,409734599,356183067,90199159]
["CT",409362,4543.09,432691841,178743224,611435065,88985726,266795724,251701547,52731763]
["DC",190987,2249.9699999999998,281051364,94086310,375137674,37367206,161584462,133367744,21290659]
["DE",46592,396.74,26957257,19860759,46818016,14874584,17371151,22958304,12843802]
["FL",1676685,11931.87,1009700019,650771984,1660472003,392616463,722823685,609263067,186775341]
["FM",21288,131.61000000000001,129515,5814342,5943857,5783400,3823010,2399753,3269239]
["GA",662164,3959.94,343973249,230230094,574203343,184086708,295437009,240497023,111335115]
["GU",8012,78.91,2610419,4338058,6948477,2993481,5115627,4252897,1998168]
["HI",154284,2072.7199999999998,173948430,94980255,268928685,46604628,129434518,105904374,32641051]
["IA",252926,2094.0100000000002,175109088,88273649,263382737,59133085,122945926,102199800,43739944]
["ID",202675,2233.7399999999998,211822502,141119401,352941903,72793166,152138350,121555704,35842856]
["IL",1448136,10190.59,947540224,506952642,1454492866,301829538,802226921,674307190,198315976]
["IN",561200,4529.8100000000004,383440979,174115297,557556276,116637632,323804634,271389119,70074013]
["KS",288440,2290.79,177284938,124533206,301818144,71981196,131599618,106810171,44627169]
["KY",593784,4386.05,436565564,155106604,591672168,121782080,317799563,278735437,70738522]
["LA",460418,3982.53,334991463,202444932,537436395,147587503,217462824,196849191,97819814]
["MA",788456,10060.790000000001,756638957,698741422,1455380379,189206346,567771381,531004370,124208902]
["MD",338877,3123.12,339703492,169652943,509356435,88268225,214331433,202340050,59070005]
["ME",195803,2088.81,166678390,96228825,262907215,63051771,139633680,119330207,42109475]
["MH",7804,69.05,30836,3037362,3068198,1384758,1118455,1118455,631552]
["MI",656546,6201.91,495951664,290638143,786589807,181477785,341907755,314811868,111026269]
["MN",158043,1797.21,123608133,118616319,242224452,64800453,99458417,81003570,39056000]
["MO",616605,5605.59,473641890,244467333,718109223,179329000,250505690,206862586,113832067]
["MP",2445,25.71,238899,2622122,2861021,2612522,2372599,1728447,2309217]
["MS",311088,2195.69,137827837,136813415,274641252,112575641,146404869,121616224,79128480]
["MT",118277,1359.12,119664687,86211702,205876389,57334131,75688924,68301121,39750250]
["NC",721568,5108.67,387803200,303248251,691051451,194681722,291409433,261718943,107604162]
["ND",36030,351.2,29456991,19779417,49236408,16195302,20560648,18090496,11851338]
["NE",113528,1138.23,66328851,61812989,128141840,33808415,60975099,49466758,19253672]
["NH",89383,1052.79,69888880,51496492,121385372,32171286,69033347,61582372,19340603]
["NJ",569142,3359.99,266226948,220789905,487016853,134056042,173098866,233765438,67835343]
["NM",315988,3375.97,199562062,174355409,373917471,98694854,158972250,132252536,63729993]
["NV",111945,1115.27,90391682,62714605,153106287,37027890,61141839,48043641,24386149]
["NY",2226970,19740.59,2201173576,991854471,3193028047,404610742,1569344077,1456692983,214139544]
["OH",850031,7176.51,565774304,344662492,910436796,236888423,374426241,336159933,140665413]
["OK",311306,2446.38,203966913,119557210,323524123,94022266,166513219,143045708,64447054]
["OR",376515,5731.54,630373599,262742639,893116238,130321162,370570738,307782475,72698228]
["PA",823746,6413.01,616649640,305575511,922225151,196386466,356349564,364746010,120048410]
["PR",413219,4545.59,327126770,153623378,480750148,129865437,242021112,190851017,72829502]
["PW",14576,119.98,907597,1871002,2778599,1871002,2236136,1707269,704526]
["RI",189496,2018.58,208230807,74387700,282618507,39684147,147572179,129457244,30306344]
["SC",436831,4367.75,436966512,203444470,637692393,125978603,295919453,242652872,86734348]
["SD",100692,774.76,56892065,32450674,89342739,24877040,58214301,51813938,19782410]
["TN",437128,3291.1,200606692,176725730,377332422,128687566,217760014,172597475,79195583]
["TX",1735904,14319.67,1221037844,684649777,1905687621,407615395,976266251,792536541,250379188]
["UT",163550,1442.62,99474011,97096556,196570567,58226122,81841601,68114631,36031932]
["VA",377727,3577.52,236687386,171995017,408682403,128118038,210836275,177193334,85924756]
["VI",15930,229.42,10947803,12045501,22993304,5759509,19537270,10334046,3271826]
["VT",184682,1613.85,149829941,69139398,218969339,39313153,110951086,103811710,24020750]
["WA",1195483,11708.78,1461676401,386155744,1847832145,198895019,730693105,607329128,82566377]
["WI",273226,2641.03,204659795,145558057,350217852,82528579,98222024,87760547,43890777]
["WV",504163,3958.31,362983419,158916449,521899868,108622260,277233275,239369940,78365831]
["WY",34740,307.11,25595110,23487543,49082653,13028312,28687301,23961688,7034389]
[]
[null,{"$f":"SUM(B2:B61)","v":30193278},null,null,null,null,{"$f":"SUM(G2:G61)","v":7424904883},null,null,{"$f":"SUM(J2:J61)","v":4269939559}]