{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Protection Occupations"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":"Protection Occupations","index":0,"n_rows":459,"n_cols":17,"rows_kept":459,"cut":false,"hidden":false,"merged":[[3,12,3,15],[4,12,4,15],[455,0,455,3],[457,0,457,3],[3,7,3,10],[4,7,4,10]]}
[]
["Measurement Date: 6/30/2015"]
["Membership Goup: Protection Occupations"]
[null,null,null,null,null,null,null,"DEFERRED OUTFLOWS OF RESOURCES",null,null,null,null,"DEFERRED INFLOWS OF RESOURCES"]
[null,null,null,null,null,null,null,"(Excluding Employer Specific Amounts)*",null,null,null,null,"(Excluding Employer Specific Amounts) *"]
["Employer ID #","Employer Name","2020 Actual Employer Contributions","Employer Allocation Percentage **","Net Pension Liability (NPL)/ (Asset)","Change in NPL due to 1% Decrease in the Actuarial Assumed Investment Return (6.00 %)","Change in NPL due to 1% Increase in the Actuarial Assumed Investment Return (8.00%)","Differences Between Expected and Actual Experience","Changes of Assumptions","Difference Between Projected and Actual Investment Earnings on Pension Plan Investments","Total Deferred Outflows of Resources",null,"Differences Between Expected and Actual Experience","Changes of Assumptions","Difference Between Projected and Actual Investment Earnings on Pension Plan Investments","Total Deferred Inflows of Resources","Total Proportionate Share of Allocable Plan Pension Expense"]
["EMPLOYER ID #","EMPLOYER_NAME",37896147.920000009,1,32683892,266951890,-163470502,4580038,14086252,54886375,{"$f":"SUM(H7:J7)","v":73552665},null,553254,684252,31262684,{"$f":"SUM(M7:O7)","v":32500190},48893325]
["00216","STATE - DEPT OF HUMAN SERVICES/CCUSO",511250.4,{"$f":"+C8/$C$7","v":1.349082764504894E-2},{"$f":"ROUND(D8*$E$7,0)","v":440933},{"$f":"ROUND(D8*$F$7,0)","v":3601402},{"$f":"ROUND(D8*$G$7,0)+1","v":-2205351},{"$f":"ROUND(D8*$H$7,0)-1","v":61788},{"$f":"ROUND(D8*$I$7,0)","v":190035},{"$f":"ROUND(D8*$J$7,0)","v":740463},{"$f":"ROUND(SUM(H8:J8),0)","v":992286},null,{"$f":"ROUND(D8*$M$7,0)","v":7464},{"$f":"ROUND(D8*$N$7,0)","v":9231},{"$f":"ROUND(D8*$O$7,0)","v":421759},{"$f":"ROUND(SUM(M8:O8),0)","v":438454},{"$f":"ROUND(D8*$Q$7,0)-1","v":659610}]
["00221","MAR-MAC UNIFIED POLICE DISTRICT",14269.67,{"$f":"+C9/$C$7","v":3.7654671472477189E-4},{"$f":"ROUND(D9*$E$7,0)","v":12307},{"$f":"ROUND(D9*$F$7,0)","v":100520},{"$f":"ROUND(D9*$G$7,0)","v":-61554},{"$f":"ROUND(D9*$H$7,0)","v":1725},{"$f":"ROUND(D9*$I$7,0)","v":5304},{"$f":"ROUND(D9*$J$7,0)","v":20667},{"$f":"ROUND(SUM(H9:J9),0)","v":27696},null,{"$f":"ROUND(D9*$M$7,0)","v":208},{"$f":"ROUND(D9*$N$7,0)","v":258},{"$f":"ROUND(D9*$O$7,0)","v":11772},{"$f":"ROUND(SUM(M9:O9),0)","v":12238},{"$f":"ROUND(D9*$Q$7,0)","v":18411}]
["00313","POLK COUNTY RANGERS",1698235.71,4.4812884770901527E-2,{"$f":"ROUND(D10*$E$7,0)+1","v":1464660},11962884,{"$f":"ROUND(D10*$G$7,0)+1","v":-7325584},{"$f":"ROUND(D10*$H$7,0)-1","v":205244},{"$f":"ROUND(D10*$I$7,0)+1","v":631247},2459617,3296108,null,{"$f":"ROUND(D10*$M$7,0)+1","v":24794},{"$f":"ROUND(D10*$N$7,0)+1","v":30664},{"$f":"ROUND(D10*$O$7,0)-1","v":1400970},1456428,{"$f":"ROUND(D10*$Q$7,0)-1","v":2191050}]
["00331","BATTLE CREEK COMMUNITY AMBULANCE",3693.06,9.7452121197018988E-5,3185,26015,-15931,446,1373,5349,7168,null,54,67,3047,3168,4765]
["00348","STATE - PUB DEF - PROTECTION OCCUPATIONS",137804.56,3.6363738153785412E-3,118851,970737,-594440,16655,51223,199587,267465,null,2012,2488,113683,118183,177794]
["00410","DELAWARE TOWNSHIP FIRE DEPT - POLK CO",2810.35,7.4159252437285694E-5,2424,19797,-12123,340,1045,4070,5455,null,41,51,2318,2410,3626]
["01201","ADAIR COUNTY",45107.01,1.1902795528247977E-3,38903,317747,-194576,5452,16767,65330,87549,null,659,814,37211,38684,58197]
["01204","ADAIR COUNTY HEALTH SYSTEM",27632.44,7.2916223723669675E-4,23832,194651,-119197,3340,10271,40021,53632,null,403,499,22796,23698,35651]
["01301","CITY OF FONTANELLE",2447.59,6.4586775552146925E-5,2111,17242,-10558,296,910,3545,4751,null,36,44,2019,2099,3158]
["01302","CITY OF GREENFIELD",13831.93,3.6499567262613736E-4,11929,97436,-59666,1672,5141,20033,26846,null,202,250,11411,11863,17846]
["01306","CITY OF ADAIR",7451.4,1.966268449165373E-4,6427,52490,-32143,901,2770,10792,14463,null,109,135,6147,6391,9614]
["02201","ADAMS COUNTY",32269.9,8.5153509713237349E-4,27831,227319,-139201,3900,11995,46738,62633,null,471,583,26621,27675,41634]
["03201","ALLAMAKEE COUNTY",51593.96,1.3614565815215972E-3,44498,363443,-222558,6236,19178,74725,100139,null,753,932,42563,44248,66566]
["03304","CITY OF LANSING",12872.15,3.3966908792876585E-4,11102,90675,-55526,1556,4785,18643,24984,null,188,232,10619,11039,16608]
["03306","CITY OF POSTVILLE",20561.62,5.4257810169535553E-4,17734,144842,-88696,2485,7643,29780,39908,null,300,371,16962,17633,26528]
["03312","VETERAN'S MEMORIAL HOSPITAL",48660.71,1.2840542554014812E-3,41968,342781,-209905,5881,18088,70477,94446,null,710,879,40143,41732,62782]
["03313","WAUKON POLICE DEPARTMENT",28669.040000000001,7.5651594089513451E-4,24726,201953,-123668,3465,10656,41522,55643,null,419,518,23651,24588,36989]
["04201","APPANOOSE COUNTY",26244.16,6.9252843469479457E-4,22635,184872,-113208,3172,9755,38010,50937,null,383,474,21650,22507,33860]
["04301","CITY OF CENTERVILLE",38741.85,1.0223163072348486E-3,33413,272909,-167119,4682,14401,56111,75194,null,566,700,31960,33226,49984]
["05201","AUDUBON COUNTY",17920.98,4.7289714083425486E-4,15456,126241,-77305,2166,6661,25956,34783,null,262,324,14784,15370,23122]
["05302","CITY OF AUDUBON",21766.46,5.7437130670773447E-4,18773,153330,-93893,2631,8091,31525,42247,null,318,393,17956,18667,28083]
["06201","BENTON COUNTY",110221.64,2.9085183072612405E-3,95062,776434,-475457,13321,40970,159638,213929,null,1609,1990,90928,94527,142207]
["06301","CITY OF VINTON",55824.81,1.4730998548413937E-3,48147,393247,-240808,6747,20750,80853,108350,null,815,1008,46053,47876,72025]
["06302","CITY OF BELLE PLAINE",24511.13,6.467974014600056E-4,21140,172664,-105732,2962,9111,35500,47573,null,358,443,20221,21022,31624]
["06315","CITY OF URBANA",9004.08,2.3759881925223384E-4,7766,63427,-38840,1088,3347,13041,17476,null,131,163,7428,7722,11617]
["07001","UNIVERSITY OF NORTHERN IOWA",66593.399999999994,1.7572603986183717E-3,57434,469104,-287260,8048,24753,96450,129251,null,972,1202,54937,57111,85918]
["07201","BLACK HAWK COUNTY",151534.23000000001,3.9986710607076382E-3,130692,1067453,-653665,18314,56326,219473,294113,null,2212,2736,125009,129957,195508]
["07302","CITY OF CEDAR FALLS",243.17,6.416747172122605E-6,210,1713,-1049,29,90,352,471,null,4,4,201,209,314]
["07304","CITY OF GILBERTVILLE",4420.1000000000004,1.1663718458485474E-4,3812,31137,-19067,534,1643,6402,8579,null,65,80,3646,3791,5703]
["07306","CITY OF DUNKERTON",1481.55,3.9095002561410723E-5,1278,10436,-6391,179,551,2146,2876,null,22,27,1222,1271,1911]
["07311","CITY OF LA PORTE CITY",20347.02,5.3691525700588923E-4,17548,143331,-87770,2459,7563,29469,39491,null,297,367,16785,17449,26252]
["07319","CITY OF EVANSDALE",7698.26,2.031409634628637E-4,6639,54229,-33208,930,2861,11150,14941,null,112,139,6351,6602,9932]
["07334","HUDSON POLICE DEPARTMENT",28315.87,7.4719652403130033E-4,24421,199466,-122145,3422,10525,41011,54958,null,413,511,23359,24283,36533]
["08201","BOONE COUNTY",51325.56,1.354374067473821E-3,44266,361553,-221400,6203,19078,74337,99618,null,749,927,42341,44017,66220]
["08204","BOONE COUNTY HOSPITAL",72614.399999999994,1.9161419823801441E-3,62627,511518,-313233,8776,26991,105170,140937,null,1060,1311,59904,62275,93687]
["08301","CITY OF BOONE",11657.13,3.0760725403037209E-4,10054,82116,-50285,1409,4333,16883,22625,null,170,210,9617,9997,15040]
["08302","CITY OF OGDEN",12563.11,3.3151416936943383E-4,10835,88498,-54193,1518,4670,18196,24384,null,183,227,10364,10774,16209]
["08303","CITY OF MADRID",21121.53,5.5735295430522989E-4,18216,148786,-91111,2553,7851,30591,40995,null,308,381,17424,18113,27251]
["09201","BREMER COUNTY",68140.210000000006,1.7980774759441564E-3,58768,480000,-293933,8235,25328,98690,132253,null,995,1230,56213,58438,87914]
["09302","CITY OF SUMNER",14593.96,3.8510404885500022E-4,12587,102804,-62953,1764,5425,21137,28326,null,213,264,12039,12516,18829]
["09303","CITY OF WAVERLY",1580.43,4.1704238735196487E-5,1363,11133,-6817,191,587,2289,3067,null,23,29,1304,1356,2039]
["09304","CITY OF TRIPOLI",4997.53,1.3187435331289994E-4,4310,35204,-21558,604,1858,7238,9700,null,73,90,4123,4286,6448]
["09305","CITY OF JANESVILLE",9419.27,2.4855481406406752E-4,8124,66352,-40631,1138,3501,13642,18281,null,138,170,7770,8078,12153]
["09307","CITY OF READLYN",6069.33,1.6015691127268532E-4,5235,42754,-26181,734,2256,8790,11780,null,89,110,5007,5206,7831]
["09318","WAVERLY HEALTH CENTER",91627.45,2.4178565640346479E-3,79025,645451,-395248,11074,34059,132707,177840,null,1338,1654,75589,78581,118217]
["09319","DENVER POLICE DEPARTMENT",19918.39,5.2560460873354105E-4,17179,140311,-85921,2407,7404,28849,38660,null,291,360,16432,17083,25699]
[10201,"BUCHANAN COUNTY",55839.49,1.4734872293057058E-3,48159,393350,-240872,6749,20756,80874,108379,null,815,1008,46065,47888,72044]
[10205,"BUCHANAN COUNTY HEALTH CENTER",5389.49,1.422173570616567E-4,4648,37965,-23248,651,2003,7806,10460,null,79,97,4446,4622,6953]
[10301,"CITY OF FAIRBANK",6783.4,1.7899972351596198E-4,5850,47784,-29261,820,2521,9825,13166,null,99,122,5596,5817,8752]
[10302,"CITY OF INDEPENDENCE",88324.62,2.3307017955085069E-3,76176,622185,-381001,10675,32831,127924,171430,null,1289,1595,72864,75748,113956]
[10303,"CITY OF JESUP",18284.96,4.8250181096506537E-4,15770,128805,-78875,2210,6797,26483,35490,null,267,330,15084,15681,23591]
[10306,"CITY OF LAMONT",154.59,4.0793064331061951E-6,133,1089,-667,19,57,224,300,null,2,3,128,133,199]
[11201,"BUENA VISTA COUNTY",52423.22,1.3833390166902216E-3,45213,369285,-226135,6336,19486,75926,101748,null,765,947,43247,44959,67636]
[11204,"BUENA VISTA REGIONAL MEDICAL CENTER",87201.83,2.3010737182070822E-3,75208,614276,-376158,10539,32414,126298,169251,null,1273,1575,71938,74786,112507]
[11301,"CITY OF SIOUX RAPIDS",4650.3599999999997,1.2271326388679557E-4,4011,32759,-20060,562,1729,6735,9026,null,68,84,3836,3988,6000]
[11302,"CITY OF NEWELL",4683.96,1.2359989753808198E-4,4040,32995,-20205,566,1741,6784,9091,null,68,85,3864,4017,6043]
[11303,"CITY OF MARATHON",6.94,1.8313206964070765E-7,6,49,-30,1,3,10,14,null,0,0,6,6,9]
[11307,"CITY OF STORM LAKE",7366.79,1.943941641654854E-4,6354,51894,-31778,890,2738,10670,14298,null,108,133,6077,6318,9505]
[12201,"BUTLER COUNTY",31902.75,8.4184677733862906E-4,27515,224733,-137617,3856,11858,46206,61920,null,466,576,26318,27360,41161]
[12302,"CITY OF PARKERSBURG",11564.8,3.0517085864277462E-4,9974,81466,-49886,1398,4299,16750,22447,null,169,209,9540,9918,14921]
[12305,"CITY OF CLARKSVILLE",8859.1200000000008,2.3377362835668388E-4,7641,62406,-38215,1071,3293,12831,17195,null,129,160,7308,7597,11430]
[12310,"CITY OF APLINGTON",9966.4599999999991,2.6299401250595489E-4,8596,70207,-42992,1205,3705,14435,19345,null,146,180,8222,8548,12859]
[12321,"CITY OF BRISTOW",104.07,2.7461894074219658E-6,90,733,-449,13,39,151,203,null,2,2,86,90,134]
[13201,"CALHOUN COUNTY",56064.72,1.4794305774390166E-3,48354,394937,-241843,6776,20840,81201,108817,null,819,1012,46251,48082,72334]
[13301,"CITY OF ROCKWELL CITY",21360.83,5.6366758028001697E-4,18423,150472,-92143,2582,7940,30938,41460,null,312,386,17622,18320,27560]
[13303,"CITY OF LAKE CITY",18716.41,{"$f":"+C73/$C$7","v":4.9388687313314653E-4},{"$f":"ROUND(D73*$E$7,0)","v":16142},{"$f":"ROUND(D73*$F$7,0)","v":131844},{"$f":"ROUND(D73*$G$7,0)","v":-80736},{"$f":"ROUND(D73*$H$7,0)","v":2262},{"$f":"ROUND(D73*$I$7,0)","v":6957},{"$f":"ROUND(D73*$J$7,0)","v":27108},{"$f":"ROUND(SUM(H73:J73),0)","v":36327},null,{"$f":"ROUND(D73*$M$7,0)","v":273},{"$f":"ROUND(D73*$N$7,0)","v":338},{"$f":"ROUND(D73*$O$7,0)","v":15440},{"$f":"ROUND(SUM(M73:O73),0)","v":16051},{"$f":"ROUND(D73*$Q$7,0)","v":24148}]
[13307,"CITY OF POMEROY",3840.4,1.0134011530953512E-4,3312,27053,-16566,464,1428,5562,7454,null,56,69,3168,3293,4955]
[13309,"CITY OF FARNHAMVILLE",646.69000000000005,1.7064795117571937E-5,558,4555,-2790,78,240,937,1255,null,9,12,533,554,834]
[13323,"MANSON POLICE DEPT",19251.259999999998,5.0800044481143648E-4,16603,135612,-83043,2327,7156,27882,37365,null,281,348,15881,16510,24838]
[14201,"CARROLL COUNTY",127196.26,3.3564429891005123E-3,109702,896009,-548679,15373,47280,184223,246876,null,1857,2297,104931,109085,164108]
[14302,"CITY OF CARROLL",2398.67,6.3295879176523951E-5,2069,16897,-10347,290,892,3474,4656,null,35,43,1979,2057,3095]
[14308,"CITY OF MANNING",20469.73,5.4015331698652484E-4,17654,144195,-88299,2474,7609,29647,39730,null,299,370,16887,17556,26410]
[14309,"CITY OF COON RAPIDS",12113.31,3.1964488912096257E-4,10447,85330,-52253,1464,4503,17544,23511,null,177,219,9993,10389,15629]
[14312,"CITY OF ARCADIA",39.64,1.046016605267673E-6,34,279,-171,5,15,57,77,null,1,1,33,35,51]
[15201,"CASS COUNTY",25123.55,6.6295788302907785E-4,21668,176978,-108374,3036,9339,36387,48762,null,367,454,20726,21547,32414]
[15302,"CITY OF ATLANTIC",90451.98,2.3868383718299562E-3,78011,637171,-390178,10932,33622,131005,175559,null,1321,1633,74619,77573,116700]
[15305,"CITY OF ANITA",59.46,1.5690249079015096E-6,51,419,-256,7,22,86,115,null,1,1,49,51,77]
[16201,"CEDAR COUNTY",81086.45,2.139701643849821E-3,69934,571197,-349778,9800,30140,117440,157380,null,1184,1464,66893,69541,104617]
[16302,"CITY OF STANWOOD",205.15,5.4134789750419557E-6,177,1445,-885,25,76,297,398,null,3,4,169,176,265]
[16303,"CITY OF TIPTON",50058.93,1.320950353731889E-3,43174,352630,-215936,6050,18607,72502,97159,null,731,904,41296,42931,64586]
[16304,"CITY OF WEST BRANCH",28497.58,7.5199147048294495E-4,24578,200746,-122928,3444,10593,41274,55311,null,416,515,23509,24440,36767]
[16305,"CITY OF DURANT",22509.02,5.9396591040116451E-4,19413,158560,-97096,2720,8367,32601,43688,null,329,406,18569,19304,29041]
[16306,"CITY OF MECHANICSVILLE",1784.64,4.7092913078327454E-5,1539,12572,-7698,216,663,2585,3464,null,26,32,1472,1530,2303]
[16307,"CITY OF CLARENCE",8922.67,2.3545057980130447E-4,7695,62854,-38489,1078,3317,12923,17318,null,130,161,7361,7652,11512]
[17201,"CERRO GORDO COUNTY",144974.98000000001,3.8255861863861962E-3,125035,1021247,-625370,17521,53888,209973,281382,null,2117,2618,119598,124333,187046]
[17303,"CITY OF CLEAR LAKE",150719.4,3.9771694030267535E-3,129989,1061713,-650150,18216,56023,218292,292531,null,2200,2721,124337,129258,194457]
[17308,"CITY OF ROCKWELL",4984.54,1.3153157441021511E-4,4299,35113,-21502,602,1853,7219,9674,null,73,90,4112,4275,6431]
[18201,"CHEROKEE COUNTY",22241.99,5.8691954778500332E-4,19183,156679,-95944,2688,8267,32214,43169,null,325,402,18349,19076,28696]
[18302,"CITY OF CHEROKEE",56712.09,1.4965133163328645E-3,48912,399497,-244636,6854,21080,82138,110072,null,828,1024,46785,48637,73170]
[18306,"CITY OF MARCUS",4888.3999999999996,1.2899464109965926E-4,4216,34435,-21087,591,1817,7080,9488,null,71,88,4033,4192,6307]
[18309,"CITY OF AURELIA",5218.4799999999996,1.3770476120729682E-4,4501,36761,-22511,631,1940,7558,10129,null,76,94,4305,4475,6733]
[19201,"CHICKASAW COUNTY",45843.29,1.2097084404667372E-3,39538,322934,-197752,5541,17040,66397,88978,null,669,828,37819,39316,59147]
[19303,"CITY OF NASHUA",4590.29,1.211281423560582E-4,3959,32335,-19801,555,1706,6648,8909,null,67,83,3787,3937,5922]
[19304,"CITY OF NEW HAMPTON",32022.17,8.4499802110757621E-4,27618,225574,-138132,3870,11903,46379,62152,null,467,578,26417,27462,41315]
[20201,"CLARKE COUNTY",53706.21,1.4171944365790302E-3,46319,378323,-231669,6491,19963,77785,104239,null,784,970,44305,46059,69291]
[20204,"CLARKE COUNTY HOSPITAL",47473.47,1.2527254775397761E-3,40944,334417,-204784,5738,17646,68758,92142,null,693,857,39164,40714,61250]
[20301,"CITY OF OSCEOLA",65807.289999999994,1.7365166016060868E-3,56756,463566,-283869,7953,24461,95311,127725,null,961,1188,54288,56437,84904]
[21201,"CLAY COUNTY",61245.26,1.6161341814817359E-3,52822,431430,-264190,7402,22765,88704,118871,null,894,1106,50525,52525,79018]
[21302,"SPENCER HOSPITAL",48101.05,1.2692859997681788E-3,41485,338838,-207491,5813,17879,69667,93359,null,702,869,39681,41252,62060]
[21303,"CITY OF SPENCER",2329.83,6.1479335707638309E-5,2009,16412,-10050,282,866,3374,4522,null,34,42,1922,1998,3006]
[22201,"CLAYTON COUNTY",73056.83,1.927816783759271E-3,63009,514634,-315141,8829,27156,105811,141796,null,1067,1319,60269,62655,94257]
[22302,"CITY OF GUTTENBERG",21102.43,5.5684894529512373E-4,18200,148652,-91028,2550,7844,30563,40957,null,308,381,17409,18098,27226]
[22303,"CITY OF STRAWBERRY POINT",16159.15,4.2640613589836325E-4,13937,113830,-69705,1953,6006,23404,31363,null,236,292,13331,13859,20848]
[22306,"CITY OF ELKADER",14985.69,3.9544098338531073E-4,12925,105564,-64643,1811,5570,21704,29085,null,219,271,12363,12853,19334]
[22308,"CITY OF MONONA",10959.48,2.8919773120834907E-4,9452,77202,-47275,1325,4074,15873,21272,null,160,198,9041,9399,14140]
[22311,"CITY OF GARNAVILLO",2351.5,6.2051161636905486E-5,2028,16565,-10144,284,874,3406,4564,null,34,42,1940,2016,3034]
[22324,"GUTTENBERG MUNIC HOSP",14636.86,3.8623609003476776E-4,12624,103106,-63138,1769,5441,21199,28409,null,214,264,12075,12553,18884]
[23201,"CLINTON COUNTY",92308.65,2.4358320057982288E-3,79612,650250,-398187,11156,34312,133694,179162,null,1348,1667,76151,79166,119096]
[24201,"CRAWFORD COUNTY",28022.75,7.3946170094007786E-4,24168,197401,-120880,3387,10416,40586,54389,null,409,506,23118,24033,36155]
[24204,"CRAWFORD COUNTY MEMORIAL HOSPITAL",61532.68,1.6237185935071151E-3,53069,433455,-265430,7437,22872,89120,119429,null,898,1111,50762,52771,79389]
[24301,"CITY OF DENISON",81309.460000000006,2.1455864108311721E-3,70126,572768,-350740,9827,30223,117763,157813,null,1187,1468,67077,69732,104905]
[24303,"CITY OF MANILLA",2666.16,7.0354380229577679E-5,2299,18781,-11501,322,991,3861,5174,null,39,48,2199,2286,3440]
[24305,"CITY OF CHARTER OAK",245.37,6.4748005659568352E-6,212,1728,-1058,30,91,355,476,null,4,4,202,210,317]
[25201,"DALLAS COUNTY",227046.1,5.9912712099209038E-3,195818,1599381,-979396,27440,84395,328839,440674,null,3315,4100,187303,194718,292933]
[25301,"CITY OF WOODWARD",6433.92,1.6977767802633166E-4,5549,45322,-27754,778,2392,9318,12488,null,94,116,5308,5518,8301]
[25303,"CITY OF MINBURN",162.33000000000001,4.2835488277775321E-6,140,1144,-700,20,60,235,315,null,2,3,134,139,209]
[25305,"CITY OF VAN METER",11295.22,2.9805720686557833E-4,9742,79567,-48724,1365,4199,16359,21923,null,165,204,9318,9687,14573]
[25306,"CITY OF DALLAS CENTER",81.260000000000005,2.1442812649861532E-6,70,572,-351,10,30,118,158,null,1,1,67,69,105]
[25308,"CITY OF PERRY",71820.850000000006,1.8952018593450747E-3,61943,505928,-309810,8680,26696,104021,139397,null,1049,1297,59249,61595,92663]
[25312,"CITY OF ADEL",53673.72,1.4163370935037238E-3,46291,378094,-231529,6487,19951,77738,104176,null,784,969,44278,46031,69249]
[25314,"CITY OF GRANGER",12182.73,3.2147673757549543E-4,10507,85819,-52552,1472,4528,17645,23645,null,178,220,10050,10448,15718]
[25315,"CITY OF WAUKEE",342598.88,9.0404671399118789E-3,295478,2413370,-1477850,{"$f":"ROUND(D129*$H$7,0)-1","v":41405},127346,496198,664949,null,5002,6186,282629,293817,442018]
[25318,"CITY OF DE SOTO",7214.96,1.9038768835373488E-4,6223,50824,-31123,872,2682,10450,14004,null,105,130,5952,6187,9309]
[26201,"DAVIS COUNTY",38423.26,1.0139093841704636E-3,33139,270665,-165744,4644,14282,55650,74576,null,561,694,31698,32953,49573]
[26203,"DAVIS COUNTY HOSPITAL",41693.15,1.1001949350634684E-3,35959,293699,-179849,5039,15498,60386,80923,null,609,753,34395,35757,53792]
[26301,"CITY OF BLOOMFIELD",31449.25,8.2987986183689119E-4,27124,221538,-135661,3801,11690,45549,61040,null,459,568,25944,26971,40576]
[27201,"DECATUR COUNTY",56311.55,1.4859439043481543E-3,48566,396676,-242908,6806,20931,81558,109295,null,822,1017,46455,48294,72653]
[27204,"DECATUR COUNTY HOSPITAL",51995.46,1.3720513258963442E-3,44844,366272,-224290,6284,19327,75307,100918,null,759,939,42894,44592,67084]
[27301,"CITY OF LAMONI",18775.07,4.9543478771601741E-4,16193,132257,-80989,2269,6979,27193,36441,null,274,339,15489,16102,24223]
[27302,"CITY OF LEON",15918.78,{"$f":"+C137/$C$7","v":4.2006327486384786E-4},{"$f":"ROUND(D137*$E$7,0)","v":13729},{"$f":"ROUND(D137*$F$7,0)","v":112137},{"$f":"ROUND(D137*$G$7,0)","v":-68668},{"$f":"ROUND(D137*$H$7,0)","v":1924},{"$f":"ROUND(D137*$I$7,0)","v":5917},{"$f":"ROUND(D137*$J$7,0)","v":23056},{"$f":"ROUND(SUM(H137:J137),0)","v":30897},null,{"$f":"ROUND(D137*$M$7,0)","v":232},{"$f":"ROUND(D137*$N$7,0)","v":287},{"$f":"ROUND(D137*$O$7,0)","v":13132},{"$f":"ROUND(SUM(M137:O137),0)","v":13651},{"$f":"ROUND(D137*$Q$7,0)","v":20538}]
[28201,"DELAWARE COUNTY",24822.15,6.5500456807378847E-4,21408,174855,-107074,3000,9227,35951,48178,null,362,448,20477,21287,32025]
[28204,"REGIONAL MEDICAL CENTER",65785.929999999993,1.735952955927769E-3,56738,463416,-283777,7951,24453,95280,127684,null,960,1188,54271,56419,84877]
[28301,"CITY OF EDGEWOOD",2379.5300000000002,6.279081465016616E-5,2052,16762,-10264,288,884,3446,4618,null,35,43,1963,2041,3070]
[28304,"CITY OF MANCHESTER",62801.91,1.6572109158053969E-3,54164,442396,-270905,7590,23344,90958,121892,null,917,1134,51809,53860,81027]
[28312,"CITY OF GREELEY",222.98,5.883975344162102E-6,192,1571,-962,27,83,323,433,null,3,4,184,191,288]
[29201,"DES MOINES COUNTY",129571.36,3.4191169053258215E-3,111750,912740,-558925,15660,48163,187663,251486,null,1892,2340,106891,111123,167172]
[29305,"CITY OF WEST BURLINGTON",61452.95,1.62161468573875E-3,53001,432893,-265086,7427,22842,89005,119274,null,897,1110,50696,52703,79286]
[30201,"DICKINSON COUNTY",67132.88,1.7714961463027768E-3,57899,472904,-289587,8114,24954,97231,130299,null,980,1212,55382,57574,86614]
[30204,"LAKES REGIONAL HEALTHCARE",67131.520000000004,1.7714602587502247E-3,57898,472895,-289581,8113,24953,97229,130295,null,980,1212,55381,57573,86613]
[30301,"CITY OF SPIRIT LAKE",67240.990000000005,1.7743489428516035E-3,57993,473666,-290054,8127,24994,97388,130509,null,982,1214,55471,57667,86754]
[30302,"CITY OF ARNOLDS PARK",36675.18,9.6778121294603583E-4,31631,258351,-158204,4432,13632,53118,71182,null,535,662,30255,31452,47318]
[30305,"CITY OF LAKE PARK",13464.85,3.5530919998583323E-4,11613,94850,-58083,1627,5005,19502,26134,null,197,243,11108,11548,17372]
[30306,"CITY OF OKOBOJI",24382.15,6.4339388930694235E-4,21029,171755,-105176,2947,9063,35314,47324,null,356,440,20114,20910,31458]
[30307,"CITY OF MILFORD",36500.639999999999,9.6317546778247826E-4,31480,257122,-157451,4411,13568,52865,70844,null,533,659,30111,31303,47093]
[31201,"DUBUQUE COUNTY",46967.7,1.2393792661763493E-3,40508,330855,-202602,5676,17458,68025,91159,null,686,848,38746,40280,60597]
[31301,"CITY OF CASCADE",10088.219999999999,2.6620700397561668E-4,8701,71064,-43517,1219,3750,14611,19580,null,147,182,8322,8651,13016]
[31303,"CITY OF FARLEY",6414.29,1.6925968342589259E-4,5532,45184,-27669,775,2384,9290,12449,null,94,116,5292,5502,8276]
[31306,"CITY OF DYERSVILLE",37066.68,9.7811207825789989E-4,31969,261109,-159892,4480,13778,53685,71943,null,541,669,30578,31788,47823]
[31307,"CITY OF EPWORTH",6414.92,1.6927630780685422E-4,5533,45189,-27672,775,2384,9291,12450,null,94,116,5292,5502,8276]
[31308,"CITY OF NEW VIENNA",661.65,1.7459558195644699E-5,571,4661,-2854,80,246,958,1284,null,10,12,546,568,854]
[31311,"CITY OF PEOSTA",15747.31,4.1553854057259539E-4,13581,110929,-67928,1903,5853,22807,30563,null,230,284,12991,13505,20317]
[31319,"CITY OF ASBURY",30457.51,8.0370991965454598E-4,26268,214552,-131383,3681,11321,44113,59115,null,445,550,25126,26121,39296]
[32201,"EMMET COUNTY",38144.76,1.0065603522691757E-3,32898,268703,-164543,4610,14179,55246,74035,null,557,689,31468,32714,49214]
[32301,"CITY OF ARMSTRONG",6514.44,1.7190243224066447E-4,5618,45890,-28101,787,2421,9435,12643,null,95,118,5374,5587,8405]
[32303,"CITY OF ESTHERVILLE",1578.2,4.1645393704173604E-5,1361,11117,-6808,191,587,2286,3064,null,23,28,1302,1353,2036]
[33201,"FAYETTE COUNTY",71404.759999999995,1.8842221154175814E-3,61584,502997,-308015,8630,26542,103418,138590,null,1042,1289,58906,61237,92126]
[33302,"CITY OF WEST UNION",22356.66,5.8994544899908111E-4,19282,157487,-96439,2702,8310,32380,43392,null,326,404,18443,19173,28844]
[33305,"CITY OF FAYETTE",17696.3,4.6696830604940268E-4,15262,124658,-76336,2139,6578,25630,34347,null,258,320,14599,15177,22832]
[34201,"FLOYD COUNTY",24291.68,6.4100657542504112E-4,20951,171118,-104786,2936,9029,35183,47148,null,355,439,20040,20834,31341]
[34302,"CITY OF CHARLES CITY",1031.26,2.7212792238858239E-5,889,7265,-4448,125,383,1494,2002,null,15,19,851,885,1331]
[34305,"CITY OF NORA SPRINGS",9114.0400000000009,2.4050043342769385E-4,7860,64202,-39315,1102,3388,13200,17690,null,133,165,7519,7817,11759]
[35201,"FRANKLIN COUNTY",23224.77,6.1285305432700547E-4,20030,163602,-100183,2807,8633,33637,45077,null,339,419,19159,19917,29964]
[35205,"FRANKLIN GEN HOSP",29095.81,7.677775076617865E-4,25094,204960,-125509,3516,10815,42141,56472,null,425,525,24003,24953,37539]
[35301,"CITY OF HAMPTON",40149,1.059448049568411E-3,34627,282822,-173189,4852,14924,58149,77925,null,586,725,33121,34432,51800]
[35309,"CITY OF SHEFFIELD",9629.7199999999993,2.5410814894243734E-4,8305,67835,-41539,1164,3579,13947,18690,null,141,174,7944,8259,12424]
[35311,"CITY OF HANSELL",188.31,4.9691066331472129E-6,162,1327,-812,23,70,273,366,null,3,3,155,161,243]
[36201,"FREMONT COUNTY",64569.73,1.7038599842999554E-3,55689,454849,-278531,7804,24001,93519,125324,null,943,1166,53267,55376,83307]
[36306,"CITY OF TABOR",4892.3999999999996,1.2910019272481239E-4,4219,34464,-21104,591,1819,7086,9496,null,71,88,4036,4195,6312]
[37201,"GREENE COUNTY",82788.240000000005,2.1846083188921642E-3,71402,583185,-357119,10006,30773,119905,160684,null,1209,1495,68297,71001,106813]
[37303,"CITY OF JEFFERSON",43558.3,1.1494123384770659E-3,37567,306838,-187895,5264,16191,63087,84542,null,636,786,35934,37356,56199]
[38201,"GRUNDY COUNTY",29999.1,7.9161343953293266E-4,25873,211323,-129405,3626,11151,43449,58226,null,438,542,24748,25728,38705]
[38303,"CITY OF GRUNDY CENTER",44202.68,1.1664161775311118E-3,38123,311377,-190675,5342,16430,64020,85792,null,645,798,36465,37908,57030]
[38307,"CITY OF BEAMAN",12.48,3.2932107047781436E-7,11,88,-54,2,5,18,25,null,0,0,10,10,16]
[39201,"GUTHRIE COUNTY",31669.47,8.3569100655969772E-4,27314,223089,-136611,3827,11772,45868,61467,null,462,572,26126,27160,40860]
[39301,"CITY OF PANORA",45429.46,1.1987883332074557E-3,39181,320019,-195967,5490,16886,65797,88173,null,663,820,37477,38960,58613]
[39303,"CITY OF STUART",37305.01,9.8440110796358727E-4,32174,262788,-160921,4509,13867,54030,72406,null,545,674,30775,31994,48131]
[40201,"HAMILTON COUNTY",107363.23,2.8330908520477396E-3,92596,756299,-463127,12976,39908,155498,208382,null,1567,1939,88570,92076,138519]
[40202,"HAMILTON HOSPITAL",47148.07,1.2441388528335675E-3,40663,332125,-203380,5698,17525,68286,91509,null,688,851,38895,40434,60830]
[40302,"CITY OF WEBSTER CITY",2803.01,7.3965565205129675E-5,2417,19745,-12091,339,1042,4060,5441,null,41,51,2312,2404,3616]
[40303,"CITY OF STRATFORD",442.98,1.1689314727585112E-5,382,3120,-1911,54,165,642,861,null,6,8,365,379,572]
[40304,"CITY OF JEWELL",10948.19,2.8889981174635434E-4,9442,77122,-47227,1323,4070,15857,21250,null,160,198,9032,9390,14125]
[40307,"CITY OF BLAIRSBURG",153.36000000000001,4.0468493083716032E-6,132,1080,-662,19,57,222,298,null,2,3,127,132,198]
[40308,"CITY OF WILLIAMS",127.34,3.3602359867503911E-6,110,897,-549,15,47,184,246,null,2,2,105,109,164]
[41201,"HANCOCK COUNTY",40640,1.0724045115559596E-3,35050,286280,-175307,4912,15106,58860,78878,null,593,734,33526,34853,52433]
[41302,"CITY OF BRITT",21673.57,5.7192013409261555E-4,18693,152675,-93492,2619,8056,31391,42066,null,316,391,17880,18587,27963]
[41303,"CITY OF GARNER",31496.12,8.3111666300462322E-4,27164,221868,-135863,3807,11707,45617,61131,null,460,569,25983,27012,40636]
[41305,"CITY OF KANAWHA",4967.92,1.310930074077038E-4,4285,34996,-21430,600,1847,7195,9642,null,73,90,4098,4261,6410]
[42201,"HARDIN COUNTY",85715.12,2.2618425540492236E-3,73926,603803,-369745,10359,31861,124144,166364,null,1251,1548,70711,73510,110589]
[42302,"CITY OF ACKLEY",19134.05,5.0490751831538646E-4,16502,134786,-82537,2312,7112,27713,37137,null,279,345,15785,16409,24687]
[42303,"CITY OF ELDORA",50193.22,1.324493985667343E-3,43290,353576,-216516,6066,18657,72697,97420,null,733,906,41407,43046,64759]
[42304,"CITY OF IOWA FALLS",92154,2.4317511160907453E-3,79479,649161,-397520,11138,34254,133470,178862,null,1345,1664,76023,79032,118896]
[42315,"CITY OF HUBBARD",202.93,5.3548978230819602E-6,175,1430,-875,25,75,294,394,null,3,4,167,174,262]
[43201,"HARRISON COUNTY",51060.5,1.347379689033048E-3,44038,359686,-220257,6171,18980,73953,99104,null,745,922,42123,43790,65878]
[43301,"CITY OF MISSOURI VALLEY",31919.91,{"$f":"+C201/$C$7","v":8.4229959381053614E-4},{"$f":"ROUND(D201*$E$7,0)","v":27530},{"$f":"ROUND(D201*$F$7,0)","v":224853},{"$f":"ROUND(D201*$G$7,0)","v":-137691},{"$f":"ROUND(D201*$H$7,0)","v":3858},{"$f":"ROUND(D201*$I$7,0)","v":11865},{"$f":"ROUND(D201*$J$7,0)","v":46231},{"$f":"ROUND(SUM(H201:J201),0)","v":61954},null,{"$f":"ROUND(D201*$M$7,0)","v":466},{"$f":"ROUND(D201*$N$7,0)","v":576},{"$f":"ROUND(D201*$O$7,0)","v":26333},{"$f":"ROUND(SUM(M201:O201),0)","v":27375},{"$f":"ROUND(D201*$Q$7,0)","v":41183}]
[43303,"CITY OF WOODBINE",15677.9,4.1370695599712539E-4,13522,110440,-67629,1895,5828,22707,30430,null,229,283,12934,13446,20228]
[43305,"CITY OF DUNLAP",10093.01,2.6633340204673759E-4,8705,71098,-43538,1220,3752,14618,19590,null,147,182,8326,8655,13022]
[43306,"CITY OF LOGAN",14588.21,3.8495231839384258E-4,12582,102764,-62928,1763,5423,21129,28315,null,213,263,12035,12511,18822]
[44201,"HENRY COUNTY",75044.59,1.980269608362875E-3,64723,528637,-323716,9070,27895,108690,145655,null,1096,1355,61909,64360,96822]
[44204,"HENRY COUNTY HEALTH CENTER",87509.9,2.3092030404973144E-3,75474,616446,-377487,10576,32528,126744,169848,null,1278,1580,72192,75050,112905]
[44301,"CITY OF MOUNT PLEASANT",86966.61,2.2948667548899513E-3,75005,612619,-375143,10511,32326,125957,168794,null,1270,1570,71744,74584,112204]
[44302,"CITY OF WINFIELD",3753.48,9.9046478494957253E-5,3237,26441,-16191,454,1395,5436,7285,null,55,68,3096,3219,4843]
[44303,"CITY OF NEW LONDON",20566.490000000002,5.4270661079897954E-4,17738,144877,-88717,2486,7645,29787,39918,null,300,371,16966,17637,26535]
[44306,"CITY OF WAYLAND",5367.33,1.4163260105830826E-4,4629,37809,-23153,649,1995,7774,10418,null,78,97,4428,4603,6925]
[45201,"HOWARD COUNTY",40455.74,1.0675422759432798E-3,34891,284982,-174512,4889,15038,58594,78521,null,591,730,33374,34695,52196]
[45205,"REGIONAL HEALTH SERVICES OF HOWARD CO",31583.91,8.3343325729767184E-4,27240,222487,-136242,3817,11740,45744,61301,null,461,570,26055,27086,40749]
[45302,"CITY OF CRESCO",39372.74,1.0389641734330655E-3,33957,277353,-169840,4758,14635,57025,76418,null,575,711,32481,33767,50798]
[46201,"HUMBOLDT COUNTY",19822.43,5.2307242524611704E-4,17096,139635,-85507,2396,7368,28710,38474,null,289,358,16353,17000,25575]
[46205,"HUMBOLDT COUNTY MEMORIAL HOSPITAL",10051.81,2.6524622030766015E-4,8669,70808,-43360,1215,3736,14558,19509,null,147,181,8292,8620,12969]
[46301,"CITY OF RENWICK",396.36,1.04591105364252E-5,342,2792,-1710,48,147,574,769,null,6,7,327,340,511]
[46302,"CITY OF HUMBOLDT",37722.19,9.9540961470893463E-4,32534,265726,-162720,4559,14022,54634,73215,null,551,681,31119,32351,48669]
[47201,"IDA COUNTY",28910.66,7.6289178681251024E-4,24934,203655,-124710,3494,10746,41872,56112,null,422,522,23850,24794,37300]
[48201,"IOWA COUNTY",122250.2,3.2259268213242704E-3,105436,861167,-527344,14775,45441,177059,237275,null,1785,2207,100851,104843,157726]
[48303,"CITY OF WILLIAMSBURG",42034.09,1.1091916278333966E-3,36253,296101,-181320,5080,15624,60880,81584,null,614,759,34676,36049,54232]
[48305,"CITY OF MARENGO",22283.41,5.8801253486346413E-4,19219,156971,-96123,2693,8283,32274,43250,null,325,402,18383,19110,28750]
[49201,"JACKSON COUNTY",57136.22,1.5077052190269156E-3,49278,402485,-246465,6905,21238,82752,110895,null,834,1032,47135,49001,73717]
[49202,"JACKSON COUNTY REGIONAL HEALTH CENTER",60810.35,1.6046578171578971E-3,52446,428366,-262314,7349,22604,88074,118027,null,888,1098,50166,52152,78457]
[49301,"CITY OF MAQUOKETA",2279.79,6.0158884876972459E-5,1966,16060,-9834,276,847,3302,4425,null,33,41,1881,1955,2941]
[49303,"CITY OF PRESTON",9689.66,2.5568984004535725E-4,8357,68257,-41798,1171,3602,14034,18807,null,141,175,7994,8310,12502]
[49304,"CITY OF BELLEVUE",27691.64,7.307244012889633E-4,23883,195068,-119452,3347,10293,40107,53747,null,404,500,22844,23748,35728]
[49311,"CITY OF ANDREW",332.96,8.7861172777478415E-6,287,2345,-1436,40,124,482,646,null,5,6,275,286,430]
[49321,"SABULA POLICE DEPT",4605.6400000000003,1.215331967175834E-4,3972,32444,-19867,557,1712,6671,8940,null,67,83,3799,3949,5942]
[49325,"ANDREW POLICE DEPT.",166.48,4.3930586388739208E-6,144,1173,-718,20,62,241,323,null,2,3,137,142,215]
[50201,"JASPER COUNTY",117672.07,3.105119555908678E-3,101487,828918,-507595,14222,43739,170429,228390,null,1718,2125,97074,100917,151820]
[50301,"CITY OF COLFAX",30323.3,8.0016839875159508E-4,26153,213606,-130804,3665,11271,43918,58854,null,443,548,25015,26006,39123]
[50303,"CITY OF NEWTON",151.18,3.9893236726631391E-6,130,1065,-652,18,56,219,293,null,2,3,125,130,195]
[50307,"CITY OF MONROE",19051.09,5.027183776097103E-4,16431,134202,-82180,2302,7081,27592,36975,null,278,344,15716,16338,24580]
[50310,"CITY OF PRAIRIE CITY",20752.98,5.4762769144268194E-4,17899,146190,-89521,2508,7714,30057,40279,null,303,375,17120,17798,26775]
[50312,"CITY OF BAXTER",8555.6200000000008,2.2576489879818894E-4,7379,60268,-36906,1034,3180,12391,16605,null,125,154,7058,7337,11038]
[51002,"8TH JUDICIAL DIST DEPT CORR SERVICES",20324.03,5.3630859904032146E-4,17529,143169,-87671,2456,7555,29436,39447,null,297,367,16766,17430,26222]
[51201,"JEFFERSON COUNTY",79049.59,2.085953173047462E-3,68177,556849,-340992,9554,29383,114490,153427,null,1154,1427,65212,67793,101989]
[51301,"CITY OF FAIRFIELD",11502.63,3.035303225088318E-4,9921,81028,-49618,1390,4276,16660,22326,null,168,208,9489,9865,14841]
[52003,"UNIVERSITY OF IOWA",93287.02,2.4616491416734995E-3,80456,657142,-402407,11274,34675,135111,181060,null,1362,1684,76958,80004,120358]
[52201,"JOHNSON COUNTY",345546.26,9.1182423271478491E-3,298020,2434132,-1490564,{"$f":"ROUND(D240*$H$7,0)-1","v":41761},128442,500467,670670,null,5045,6239,285061,296345,445821]
[52303,"CITY OF CORALVILLE",308962.21999999997,8.1528661079809262E-3,266467,2176423,-1332753,37340,114843,447481,599664,null,4511,5579,254880,264970,398621]
[52310,"CITY OF HILLS",237.84,6.2760996316060385E-6,205,1675,-1026,29,88,344,461,null,3,4,196,203,307]
[52315,"CITY OF NORTH LIBERTY",196881.56,5.1952921551716366E-3,169802,1386893,-849277,23795,73182,285151,382128,null,2874,3555,162419,168848,254015]
[52319,"UNIVERSITY HEIGHTS POLICE DEPT",34452.870000000003,9.0913910492251414E-4,29714,242696,-148617,4164,12806,49899,66869,null,503,622,28422,29547,44451]
[53201,"JONES COUNTY",33716.51,8.8970810624807155E-4,29079,237509,-145441,4075,12533,48833,65441,null,492,609,27815,28916,43501]
[53304,"CITY OF ANAMOSA",45740.12,1.2069860001749748E-3,39449,322207,-197307,5528,17002,66247,88777,null,668,826,37734,39228,59014]
[53305,"CITY OF MONTICELLO",76900.42,2.0292410764898654E-3,66323,541710,-331721,9294,28584,111378,149256,null,1123,1389,63440,65952,99216]
[54201,"KEOKUK COUNTY",39832.68,1.0511010270513E-3,34354,280593,-171824,4814,14806,57691,77311,null,582,719,32860,34161,51392]
[54205,"KEOKUK COUNTY HEALTH CENTER",66648.460000000006,1.758713316738605E-3,57482,469492,-287498,8055,24774,96529,129358,null,973,1203,54982,57158,85989]
[54301,"CITY OF SIGOURNEY",14418.56,3.804756100920348E-4,12435,101569,-62197,1743,5359,20883,27985,null,210,260,11895,12365,18603]
[54304,"CITY OF KEOTA",5495.22,1.4500735039351724E-4,4739,38710,-23704,664,2043,7959,10666,null,80,99,4533,4712,7090]
[55201,"KOSSUTH COUNTY",54937.760000000002,1.4496924625683693E-3,47382,386998,-236982,6640,20421,79568,106629,null,802,992,45321,47115,70880]
[55301,"CITY OF ALGONA",94707.67,2.4991371207419536E-3,81682,667149,-408535,11446,35203,137169,183818,null,1383,1710,78130,81223,122191]
[55306,"CITY OF BANCROFT",7850.91,2.071690773577706E-4,6771,55304,-33866,949,2918,11371,15238,null,115,142,6477,6734,10129]
[55309,"CITY OF BURT",247.18,6.5225626763386333E-6,213,1741,-1066,30,92,358,480,null,4,4,204,212,319]
[55314,"CITY OF TITONKA",1.98,5.2248054450807084E-8,2,14,-9,0,1,3,4,null,0,0,2,2,3]
[56201,"LEE COUNTY",98725.87,2.605169005789546E-3,85147,695455,-425868,11932,36697,142988,191617,null,1441,1783,81445,84669,127375]
[56304,"CITY OF WEST POINT",6775.17,1.7878255104720941E-4,5843,47726,-29226,819,2518,9813,13150,null,99,122,5589,5810,8741]
[56310,"CITY OF MONTROSE",4250.4799999999996,1.1216126792023558E-4,3666,29942,-18335,514,1580,6156,8250,null,62,77,3506,3645,5484]
[57004,"6TH JUDICIAL DIST DEPT CORR SERVICES",96631.27,2.5498968972781015E-3,83341,680700,-416833,11679,35918,139955,187552,null,1411,1745,79717,82873,124673]
[57202,"LINN COUNTY",100126.04,2.6421165605372159E-3,86355,705318,-431908,12101,37218,145016,194335,null,1462,1808,82600,85870,129182]
[57301,"CITY OF CEDAR RAPIDS",96947.48,2.5582410171255203E-3,83613,682927,-418197,11717,36036,140413,188166,null,1415,1750,79977,83142,125081]
[57304,"CITY OF LISBON",17424.02,4.5978340692522812E-4,15028,122740,-75161,2106,6477,25236,33819,null,254,315,14374,14943,22480]
[57305,"CITY OF MOUNT VERNON",43024.43,1.1353246269469382E-3,37107,303077,-185592,5200,15992,62314,83506,null,628,777,35493,36898,55510]
[57308,"CITY OF MARION",145.18,{"$f":"+C265/$C$7","v":3.8309962349334201E-6},{"$f":"ROUND(D265*$E$7,0)","v":125},{"$f":"ROUND(D265*$F$7,0)","v":1023},{"$f":"ROUND(D265*$G$7,0)","v":-626},{"$f":"ROUND(D265*$H$7,0)","v":18},{"$f":"ROUND(D265*$I$7,0)","v":54},{"$f":"ROUND(D265*$J$7,0)","v":210},{"$f":"ROUND(SUM(H265:J265),0)","v":282},null,{"$f":"ROUND(D265*$M$7,0)","v":2},{"$f":"ROUND(D265*$N$7,0)","v":3},{"$f":"ROUND(D265*$O$7,0)","v":120},{"$f":"ROUND(SUM(M265:O265),0)","v":125},{"$f":"ROUND(D265*$Q$7,0)","v":187}]
[57317,"CITY OF ROBINS",9855.76,2.600728712798416E-4,8500,69427,-42514,1191,3663,14274,19128,null,144,178,8131,8453,12716]
[57319,"CITY OF HIAWATHA",155982.19,4.1160434123616845E-3,134528,1098786,-672852,18852,57980,225915,302747,null,2277,2816,128679,133772,201247]
[57323,"CITY OF FAIRFAX",351.15,9.2661132931317703E-6,303,2474,-1515,42,131,509,682,null,5,6,290,301,453]
[58201,"LOUISA COUNTY",53623.94,1.415023503528693E-3,46248,377743,-231315,6481,19932,77666,104079,null,783,968,44237,45988,69185]
[58301,"CITY OF WAPELLO",31740.080000000002,8.3755425662271354E-4,27375,223587,-136915,3836,11798,45970,61604,null,463,573,26184,27220,40951]
[58316,"COLUMBUS JUNCTION POLICE DEPT",19546.27,5.1578514104554389E-4,16858,137690,-84316,2362,7265,28310,37937,null,285,353,16125,16763,25218]
[59201,"LUCAS COUNTY",28256.799999999999,7.4563779040685125E-4,24370,199049,-121890,3415,10503,40925,54843,null,413,510,23311,24234,36457]
[59204,"LUCAS COUNTY HEALTH CENTER",67983.87,1.7939519906750453E-3,58633,478899,-293258,8216,25270,98464,131950,null,993,1228,56084,58305,87712]
[59301,"CITY OF RUSSELL",320.68,8.4620737885276846E-6,277,2259,-1383,39,119,464,622,null,5,6,265,276,414]
[59311,"CHARITON POLICE DEPT",32220.45,8.5023021516641767E-4,27789,226971,-138988,3894,11977,46666,62537,null,470,582,26580,27632,41571]
[60201,"LYON COUNTY",76468.22,2.0178362233920681E-3,65951,538665,-329857,9242,28424,110752,148418,null,1116,1381,63083,65580,98659]
[61201,"MADISON COUNTY",95134.77,2.5104073955176808E-3,82050,670158,-410378,11498,35362,137787,184647,null,1389,1718,78482,81589,122742]
[61301,"CITY OF WINTERSET",53975.24,1.4242935750077678E-3,46551,380218,-232830,6523,20063,78174,104760,null,788,975,44527,46290,69638]
[61303,"CITY OF EARLHAM",9771.86,2.5785892594225443E-4,8428,68836,-42152,1181,3632,14153,18966,null,143,176,8061,8380,12608]
[62201,"MAHASKA COUNTY",67390.55,1.7782955181160794E-3,58122,474719,-290699,8145,25050,97604,130799,null,984,1217,55594,57795,86947]
[62204,"MAHASKA HEALTH PARTNERSHIP",67165.37,1.7723534893780829E-3,57927,473133,-289728,8117,24966,97278,130361,null,981,1213,55409,57603,86656]
[62301,"CITY OF NEW SHARON",6559.02,1.730788051029963E-4,5657,46204,-28293,793,2438,9500,12731,null,96,118,5411,5625,8462]
[62302,"CITY OF OSKALOOSA",694.06,1.8314790238448061E-5,599,4889,-2994,84,258,1005,1347,null,10,13,573,596,895]
[63201,"MARION COUNTY",88909.81,2.3461437343893494E-3,76681,626308,-383525,10745,33048,128771,172564,null,1298,1605,73347,76250,114711]
[63301,"CITY OF KNOXVILLE",45550.38,1.2019791588358353E-3,39285,320871,-196488,5505,16931,65972,88408,null,665,822,37577,39064,58769]
[63306,"CITY OF PLEASANTVILLE",15852.47,4.1831349279787154E-4,13672,111670,-68382,1916,5892,22960,30768,null,231,286,13078,13595,20453]
[63321,"CITY OF MELCHER-DALLAS",10211.07,2.6944875826313266E-4,8807,71930,-44047,1234,3796,14789,19819,null,149,184,8424,8757,13174]
[64201,"MARSHALL COUNTY",161195.17000000001,4.2536030400843966E-3,139024,1135507,-695339,19482,59917,233465,312864,null,2353,2911,132979,138243,207973]
[64302,"CITY OF STATE CENTER",9854.69,2.6004463622011318E-4,8499,69419,-42510,1191,3663,14273,19127,null,144,178,8130,8452,12714]
[64306,"CITY OF MELBOURNE",2674.62,7.057762191677658E-5,2307,18841,-11537,323,994,3874,5191,null,39,48,2206,2293,3451]
[65201,"MILLS COUNTY",47551.01,1.2547715957933697E-3,41011,334964,-205118,5747,17675,68870,92292,null,694,859,39228,40781,61350]
[65301,"CITY OF GLENWOOD",56758.85,1.4977472148309048E-3,48952,399826,-244837,6860,21098,82206,110164,null,829,1025,46824,48678,73230]
[66201,"MITCHELL COUNTY",34905.51,9.2108332682484405E-4,30105,245885,-150570,4219,12975,50555,67749,null,510,630,28796,29936,45035]
[66203,"MITCHELL COUNTY REGIONAL HEALTH CENTER",41759.980000000003,1.1019584388407145E-3,36016,294170,-180138,5047,15522,60483,81052,null,610,754,34450,35814,53878]
[66301,"CITY OF OSAGE",34363.519999999997,9.0678134549565558E-4,29637,242067,-148232,4153,12773,49770,66696,null,502,620,28348,29470,44336]
[66307,"CITY OF SAINT ANSGAR",5694.64,1.502696266655273E-4,4911,40115,-24565,688,2117,8248,11053,null,83,103,4698,4884,7347]
[67201,"MONONA COUNTY",45535.15,1.2015772710230648E-3,39272,320763,-196422,5503,16926,65950,88379,null,665,822,37565,39052,58749]
[67301,"CITY OF ONAWA",25478.55,6.7232558976141959E-4,21974,179479,-109905,3079,9471,36902,49452,null,372,460,21019,21851,32872]
[67302,"CITY OF MAPLETON",11871.81,3.1327220975234138E-4,10239,83629,-51211,1435,4413,17194,23042,null,173,214,9794,10181,15317]
[67304,"CITY OF WHITING",1851.64,4.8860902799642644E-5,1597,13044,-7987,224,688,2682,3594,null,27,33,1528,1588,2389]
[67312,"CITY OF BLENCOE",34.130000000000003,9.006192416192151E-7,29,240,-147,4,13,49,66,null,0,1,28,29,44]
[68201,"MONROE COUNTY",43497.89,1.1478182450581902E-3,37515,306412,-187634,5257,16168,63000,84425,null,635,785,35884,37304,56121]
[68204,"MONROE COUNTY HOSPITAL",60954.25,1.6084550368727817E-3,52571,429380,-262935,7367,22657,88282,118306,null,890,1101,50285,52276,78643]
[68301,"CITY OF ALBIA",29567.18,7.8021597504889602E-4,25500,208280,-127542,3573,10990,42823,57386,null,432,534,24392,25358,38147]
[69201,"MONTGOMERY COUNTY",58254,1.5372010929178362E-3,50242,410359,-251287,7040,21653,84371,113064,null,850,1052,48057,49959,75159]
[69301,"CITY OF RED OAK",109621.57,2.8926837163348283E-3,94544,772207,-472868,13249,40747,158769,212765,null,1600,1979,90433,94012,141433]
[70201,"MUSCATINE COUNTY",252302.65,6.6577386844863234E-3,217601,1777296,-1088344,30493,93783,365419,489695,null,3683,4556,208139,216378,325519]
[70302,"CITY OF WILTON",26844.86,7.0837965000216817E-4,23153,189103,-115799,3244,9978,38880,52102,null,392,485,22146,23023,34635]
[70303,"CITY OF WEST LIBERTY",42227.39,1.1142924101189223E-3,36419,297462,-182154,5104,15696,61159,81959,null,616,762,34836,36214,54481]
[70304,"CITY OF MUSCATINE",2356.86,6.2192600814610699E-5,2033,16602,-10167,285,876,3414,4575,null,34,43,1944,2021,3041]
[70307,"CITY OF NICHOLS",1700.23,4.4865509908533195E-5,1466,11977,-7334,205,632,2463,3300,null,25,31,1403,1459,2194]
[70316,"CITY OF ATALISSA",1061.1500000000001,2.800152675781512E-5,915,7475,-4577,128,394,1537,2059,null,15,19,875,909,1369]
[70317,"CITY OF CONESVILLE",1957.19,5.1646146308371268E-5,1688,13787,-8443,237,728,2835,3800,null,29,35,1615,1679,2525]
[71201,"O'BRIEN COUNTY",73476.039999999994,1.9388788579543833E-3,63370,517587,-316950,8880,27312,106418,142610,null,1073,1327,60615,63015,94798]
[71301,"CITY OF PRIMGHAR",3679.29,9.7088759727429285E-5,3173,25918,-15871,445,1368,5329,7142,null,54,66,3035,3155,4747]
[71302,"CITY OF SHELDON",52012.77,1.3725081005541945E-3,44859,366394,-224365,6286,19333,75332,100951,null,759,939,42908,44606,67106]
[71303,"CITY OF HARTLEY",206.82,5.4575467785433944E-6,178,1457,-892,25,77,300,402,null,3,4,171,178,267]
[71306,"CITY OF PAULLINA",8359.02,2.2057703642191183E-4,7209,58883,-36058,1010,3107,12107,16224,null,122,151,6896,7169,10785]
[71323,"HARTLEY POLICE DEPARTMENT",13462.92,3.5525827132669679E-4,11611,94837,-58074,1627,5004,19499,26130,null,197,243,11106,11546,17370]
[71325,"SANBORN POLICE DEPARTMENT",13842.98,3.6528725899062295E-4,11939,97514,-59714,1673,5146,20049,26868,null,202,250,11420,11872,17860]
[71326,"SUTHERLAND POLICE DEPARTMENT",3841.88,1.0137916941084178E-4,3313,27063,-16573,464,1428,5564,7456,null,56,69,3169,3294,4957]
[72201,"OSCEOLA COUNTY",43827.33,1.1565114769058035E-3,37799,308733,-189056,5297,16291,63477,85065,null,640,791,36156,37587,56546]
[73201,"PAGE COUNTY",26213.5,6.9171938148799563E-4,22608,184656,-113076,3168,9744,37966,50878,null,383,473,21625,22481,33820]
[73301,"CITY OF SHENANDOAH",47528.03,1.2541652017068648E-3,40991,334802,-205019,5744,17666,68837,92247,null,694,858,39209,40761,61320]
[73302,"CITY OF CLARINDA",54389.83,1.4352337370758285E-3,46909,383138,-234618,6573,20217,78775,105565,null,794,982,44869,46645,70173]
[73303,"CLARINDA REGIONAL HEALTH CENTER",84190.47,2.2216102327267881E-3,72611,593063,-363168,10175,31294,121936,163405,null,1229,1520,69453,72202,108622]
[73309,"CITY OF ESSEX",357.75,9.4402734746344609E-6,309,2520,-1543,43,133,518,694,null,5,6,295,306,462]
[74201,"PALO ALTO COUNTY",17956.88,4.7384446667000441E-4,15487,126494,-77460,2170,6675,26008,34853,null,262,324,14814,15400,23168]
[74205,"PALO ALTO COUNTY HEALTH SYSTEM",31388.33,{"$f":"+C329/$C$7","v":8.2827231058580882E-4},{"$f":"ROUND(D329*$E$7,0)","v":27071},{"$f":"ROUND(D329*$F$7,0)","v":221109},{"$f":"ROUND(D329*$G$7,0)","v":-135398},{"$f":"ROUND(D329*$H$7,0)","v":3794},{"$f":"ROUND(D329*$I$7,0)","v":11667},{"$f":"ROUND(D329*$J$7,0)","v":45461},{"$f":"ROUND(SUM(H329:J329),0)","v":60922},null,{"$f":"ROUND(D329*$M$7,0)","v":458},{"$f":"ROUND(D329*$N$7,0)","v":567},{"$f":"ROUND(D329*$O$7,0)","v":25894},{"$f":"ROUND(SUM(M329:O329),0)","v":26919},{"$f":"ROUND(D329*$Q$7,0)","v":40497}]
[74301,"CITY OF EMMETSBURG",30286.66,7.9920154586519227E-4,26121,213348,-130646,3660,11258,43865,58783,null,442,547,24985,25974,39076]
[74303,"CITY OF WEST BEND",5161.3999999999996,1.3619853951636144E-4,4451,36358,-22264,624,1919,7475,10018,null,75,93,4258,4426,6659]
[75201,"PLYMOUTH COUNTY",81948.740000000005,2.1624556715631477E-3,70677,577272,-353498,9904,30461,118689,159054,null,1196,1480,67604,70280,105730]
[75301,"CITY OF AKRON",17900.07,4.7234536971376681E-4,15438,126093,-77215,2163,6654,25925,34742,null,261,323,14767,15351,23095]
[75302,"CITY OF REMSEN",10971.71,2.8952045530225481E-4,9463,77288,-47328,1326,4078,15891,21295,null,160,198,9051,9409,14156]
[75304,"CITY OF KINGSLEY",6802.82,1.7951217665608052E-4,5867,47921,-29345,822,2529,9853,13204,null,99,123,5612,5834,8777]
[75305,"CITY OF LE MARS",62930.84,1.6606131085631455E-3,54275,443304,-271461,7606,23392,91145,122143,null,919,1136,51915,53970,81193]
[75306,"CITY OF MERRILL",7505.18,1.9804598651672136E-4,6473,52869,-32375,907,2790,10870,14567,null,110,136,6191,6437,9683]
[75324,"HINTON POLICE DEPARTMENT",4541.9799999999996,1.1985334260327108E-4,3917,31995,-19592,549,1688,6578,8815,null,66,82,3747,3895,5860]
[76201,"POCAHONTAS COUNTY",60651.48,1.6004655704858772E-3,52309,427247,-261629,7330,22545,87844,117719,null,885,1095,50035,52015,78252]
[76301,"CITY OF FONDA",5404.1,1.4260288437252858E-4,4661,38068,-23311,653,2009,7827,10489,null,79,98,4458,4635,6972]
[76302,"CITY OF POCAHONTAS",20171.759999999998,5.3229051254980407E-4,17397,142096,-87014,2438,7498,29215,39151,null,294,364,16641,17299,26025]
[76303,"CITY OF ROLFE",245.56,6.4798142681516094E-6,212,1730,-1059,30,91,356,477,null,4,4,203,211,317]
[76304,"CITY OF GILMORE CITY",910.42,2.4024077642981707E-5,785,6413,-3927,110,338,1319,1767,null,13,16,751,780,1175]
[76305,"CITY OF LAURENS",15784.92,4.1653098972809784E-4,13614,111194,-68091,1908,5867,22862,30637,null,230,285,13022,13537,20366]
[76315,"POCAHONTAS COMMUNITY HOSPITAL",33304.1,8.7882546981571917E-4,28723,234604,-143662,4025,12379,48236,64640,null,486,601,27474,28561,42969]
[77043,"STATE - DEPT OF COMMERCE/INSURANCE",37922.92,1.0007064591381822E-3,32707,267140,-163586,4583,14096,54925,73604,null,554,685,31285,32524,48928]
[77110,"5TH JUDICIAL DIST DEPT CORR SERVICES",84458.1,2.228672428086722E-3,72842,594948,-364322,10207,31394,122324,163925,null,1233,1525,69674,72432,108967]
[77112,"STATE - AIRPORT FIREFIGHTERS",227508.03,6.0034605754726517E-3,196216,1602635,-981389,27496,84566,329508,441570,null,3321,4108,187684,195113,293529]
[77113,"STATE - CONSERVATION PEACE OFFICERS",968443.99,2.5555209253574174E-2,{"$f":"ROUND(D349*$E$7,0)+1","v":835245},6822011,{"$f":"ROUND(D349*$G$7,0)+1","v":-4177522},{"$f":"ROUND(D349*$H$7,0)-1","v":117043},{"$f":"ROUND(D349*$I$7,0)+1","v":359978},1402633,1879654,null,14139,17486,798924,830549,{"$f":"ROUND(D349*$Q$7,0)-1","v":1249478}]
[77114,"STATE - CORRECTIONS - PROTECTION OCCUPATIONS",13514086.84,0.35660845710568456,{"$f":"ROUND(D350*$E$7,0)+1","v":11655353},{"$f":"ROUND(D350*$F$7,0)+1","v":95197303},{"$f":"ROUND(D350*$G$7,0)+1","v":-58294963},{"$f":"ROUND(D350*$H$7,0)-1","v":1633279},{"$f":"ROUND(D350*$I$7,0)+1","v":5023278},19572946,26229503,null,{"$f":"ROUND(D350*$M$7,0)+1","v":197296},{"$f":"ROUND(D350*$N$7,0)+1","v":244011},{"$f":"ROUND(D350*$O$7,0)-1","v":11148537},11589844,{"$f":"ROUND(D350*$Q$7,0)-1","v":17435772}]
[77301,"CITY OF WEST DES MOINES",336241.49,8.8727089283537897E-3,289995,2368586,-1450426,{"$f":"ROUND(D351*$H$7,0)-1","v":40636},124983,486991,652610,null,4909,6071,277385,288365,433816]
[77303,"CITY OF MITCHELLVILLE",20519.28,5.4146083774310938E-4,17697,144544,-88513,2480,7627,29719,39826,null,300,370,16928,17598,26474]
[77305,"CITY OF URBANDALE",10296.549999999999,2.7170439649265538E-4,8880,72532,-44416,1244,3827,14913,19984,null,150,186,8494,8830,13285]
[77308,"CITY OF GRIMES",117068.47,3.0891918156730684E-3,100967,824666,-504992,14149,43515,169555,227219,null,1709,2114,96576,100399,151041]
[77309,"CITY OF ANKENY",84973,2.2422595610345607E-3,73286,598575,-366543,10270,31585,123069,164924,null,1241,1534,70099,72874,109632]
[77310,"CITY OF BONDURANT",39777.89,1.0496552336657649E-3,34307,280207,-171588,4807,14786,57612,77205,null,581,718,32815,34114,51321]
[77314,"CITY OF WINDSOR HEIGHTS",139075.32999999999,3.6699067750525067E-3,119947,979689,-599922,16808,51695,201428,269931,null,2030,2511,114731,119272,179434]
[77320,"CITY OF CLIVE",170563.31,4.5008086404999433E-3,147104,1201499,-735749,20614,63400,247033,331047,null,2490,3080,140707,146277,220059]
[77321,"CITY OF PLEASANT HILL",197519.68,5.212130805932318E-3,170353,1391388,-852030,23872,73419,286075,383366,null,2884,3566,162945,169395,254838]
[77322,"CITY OF POLK CITY",75500.53,1.9923009103559562E-3,65116,531848,-325682,9125,28064,109350,146539,null,1102,1363,62285,64750,97410]
[77334,"ALTOONA POLICE DEPT",390243.23,1.0297701782878197E-2,336569,2748991,{"$f":"ROUND(D361*$G$7,0)+1","v":-1683369},{"$f":"ROUND(D361*$H$7,0)-1","v":47163},145056,565204,757423,null,5697,7046,321934,334677,503489]
[77338,"JOHNSTON POLICE DEPARTMENT",424783.57,1.1209149037963748E-2,366359,2992304,{"$f":"ROUND(D362*$G$7,0)+1","v":-1832364},{"$f":"ROUND(D362*$H$7,0)-1","v":51337},157895,615230,824462,null,6202,7670,350428,364300,548053]
[77402,"SAYLOR TOWNSHIP TRUSTEES - POLK COUNTY",18472.38,4.8744743236161603E-4,15932,130125,-79683,2233,6866,26754,35853,null,270,334,15239,15843,23833]
[78003,"4TH JUDICIAL DIST DEPT CORR SERVICES",42003.31,1.1083794080778433E-3,36226,295884,-181187,5076,15613,60835,81524,null,613,758,34651,36022,54192]
[78201,"POTTAWATTAMIE COUNTY",686879.73,1.8125317946563468E-2,592406,4838588,{"$f":"ROUND(D365*$G$7,0)+1","v":-2962954},{"$f":"ROUND(D365*$H$7,0)-1","v":83014},255318,994833,1333165,null,10028,12402,566646,589076,{"$f":"ROUND(D365*$Q$7,0)-1","v":886206}]
[78307,"CITY OF OAKLAND",1026.23,2.7080061070228157E-5,885,7229,-4427,124,381,1486,1991,null,15,19,847,881,1324]
[78311,"CITY OF AVOCA",16289.39,4.2984289681334965E-4,14049,114747,-70267,1969,6055,23593,31617,null,238,294,13438,13970,21016]
[78313,"CITY OF CARTER LAKE",61582.44,1.6250316557240203E-3,53112,433805,-265645,7443,22891,89192,119526,null,899,1112,50803,52814,79453]
[79201,"POWESHIEK COUNTY",59008.2,1.5571028518404618E-3,50892,415672,-254540,7132,21934,85464,114530,null,861,1065,48679,50605,76132]
[79301,"CITY OF GRINNELL",706.45,1.8641736397359933E-5,609,4976,-3047,85,263,1023,1371,null,10,13,583,606,911]
[79304,"CITY OF MONTEZUMA",1208.32,3.1885034926262224E-5,1042,8512,-5212,146,449,1750,2345,null,18,22,997,1037,1559]
[80201,"RINGGOLD COUNTY",28711.61,7.5763927406582684E-4,24763,202253,-123852,3470,10672,41584,55726,null,419,518,23686,24623,37044]
[80203,"RINGGOLD COUNTY HOSPITAL",33513.29,8.8434555593216589E-4,28904,236078,-144564,4050,12457,48539,65046,null,489,605,27647,28741,43239]
[81201,"SAC COUNTY",67209.7,1.7735232652638427E-3,57966,473445,-289919,8123,24982,97342,130447,null,981,1214,55445,57640,86713]
[81305,"CITY OF LAKE VIEW",19746.830000000002,5.2107749953072267E-4,17031,139103,-85181,2387,7340,28600,38327,null,288,357,16290,16935,25477]
[81320,"SAC CITY POLICE DEPT",23775.42,6.2738355492465031E-4,20505,167481,-102559,2873,8837,34435,46145,null,347,429,19614,20390,30675]
[82201,"SCOTT COUNTY",580195.36,1.5310140788578595E-2,500395,4087071,{"$f":"ROUND(D377*$G$7,0)+1","v":-2502755},{"$f":"ROUND(D377*$H$7,0)-1","v":70120},215663,840318,1126101,null,8470,10476,478636,497582,{"$f":"ROUND(D377*$Q$7,0)-1","v":748563}]
[82303,"CITY OF ELDRIDGE",53762.31,1.418674798121803E-3,46368,378718,-231911,6498,19984,77866,104348,null,785,971,44352,46108,69364]
[82304,"CITY OF WALCOTT",17862.64,4.7135767038139628E-4,15406,125830,-77053,2159,6640,25871,34670,null,261,323,14736,15320,23046]
[82305,"CITY OF BUFFALO",16254.83,4.2893093077202651E-4,14019,114504,-70118,1965,6042,23542,31549,null,237,293,13410,13940,20972]
[82309,"CITY OF PRINCETON",7869.74,2.0766596163317904E-4,6787,55437,-33947,951,2925,11398,15274,null,115,142,6492,6749,10153]
[82311,"CITY OF LE CLAIRE",45322.11,1.1959555914674081E-3,39088,319263,-195503,5478,16847,65642,87967,null,662,818,37389,38869,58474]
[82316,"CITY OF BLUE GRASS",15390.61,4.0612597439956366E-4,13274,108416,-66390,1860,5721,22291,29872,null,225,278,12697,13200,19857]
[82324,"CITY OF MCCAUSLAND",363.45,9.5906845404776941E-6,313,2560,-1568,44,135,526,705,null,5,7,300,312,469]
[83201,"SHELBY COUNTY",39384.44,1.0392729119366388E-3,33967,277436,-169890,4760,14639,57042,76441,null,575,711,32490,33776,50814]
[83301,"CITY OF HARLAN",56710.51,1.4964716234409292E-3,48911,399486,-244629,6854,21080,82136,110070,null,828,1024,46784,48636,73167]
[84201,"SIOUX COUNTY",100393.7,2.6491795475343388E-3,86585,707203,-433063,12133,37317,145404,194854,null,1466,1813,82820,86099,129527]
[84301,"CITY OF HAWARDEN",27785.59,7.3320354508474783E-4,23964,195730,-119857,3358,10328,40243,53929,null,406,502,22922,23830,35849]
[84303,"CITY OF ROCK VALLEY",38541.919999999998,1.0170405731306316E-3,33241,271501,-166256,4658,14326,55822,74806,null,563,696,31795,33054,49726]
[84304,"CITY OF SIOUX CENTER",58007.17,1.5306877660086985E-3,50029,408620,-250222,7011,21562,84014,112587,null,847,1047,47853,49747,74840]
[84307,"CITY OF ORANGE CITY",45837.52,1.2095561822474538E-3,39533,322893,-197727,5540,17038,66388,88966,null,669,828,37814,39311,59139]
[84320,"ORANGE CITY AREA HEALTH SYSTEM",28049.82,7.4017602156330176E-4,24192,197591,-120997,3390,10426,40626,54442,null,410,506,23140,24056,36190]
[85001,"IOWA STATE UNIV OF SCIENCE & TECH",103581.62,{"$f":"+C393/$C$7","v":2.7333020817488928E-3},{"$f":"ROUND(D393*$E$7,0)","v":89335},{"$f":"ROUND(D393*$F$7,0)","v":729660},{"$f":"ROUND(D393*$G$7,0)","v":-446814},{"$f":"ROUND(D393*$H$7,0)","v":12519},{"$f":"ROUND(D393*$I$7,0)","v":38502},{"$f":"ROUND(D393*$J$7,0)","v":150021},{"$f":"ROUND(SUM(H393:J393),0)","v":201042},null,{"$f":"ROUND(D393*$M$7,0)","v":1512},{"$f":"ROUND(D393*$N$7,0)","v":1870},{"$f":"ROUND(D393*$O$7,0)","v":85450},{"$f":"ROUND(SUM(M393:O393),0)","v":88832},{"$f":"ROUND(D393*$Q$7,0)","v":133640}]
[85101,"DEPT OF TRANS PROTECTION OCCUPATION",766182.02,2.021793934352998E-2,660801,5397217,{"$f":"ROUND(D394*$G$7,0)+1","v":-3305036},{"$f":"ROUND(D394*$H$7,0)-1","v":92598},284795,1109689,1487082,null,11186,13834,632067,657087,{"$f":"ROUND(D394*$Q$7,0)-1","v":988521}]
[85201,"STORY COUNTY",231832.72,6.1175800899185414E-3,199946,1633100,-1000044,28019,86174,335772,449965,null,3385,4186,191252,198823,299109]
[85204,"STORY CO MEDICAL CENTER",47936.5,1.2649438697884413E-3,41343,337679,-206781,5793,17818,69428,93039,null,700,866,39546,41112,61847]
[85301,"CITY OF HUXLEY",40758.11,1.075521187167669E-3,35152,287112,-175816,4926,15150,59031,79107,null,595,736,33624,34955,52586]
[85305,"CITY OF STORY CITY",34950.379999999997,9.222673521799993E-4,30143,246201,-150764,4224,12991,50620,67835,null,510,631,28833,29974,45093]
[85318,"CITY OF NEVADA",72006.33,1.900096288203426E-3,62103,507234,-310610,8703,26765,104289,139757,null,1051,1300,59402,61753,92902]
[85322,"CITY OF ROLAND",1465.4,3.8668837874854903E-5,1264,10323,-6321,177,545,2122,2844,null,21,26,1209,1256,1891]
[85327,"MARY GREELEY MEDICAL CENTER",165562.4,4.3688450960637885E-3,142791,1166271,-714177,20009,61541,239790,321340,null,2417,2989,136582,141988,213607]
[86201,"TAMA COUNTY",34261.599999999999,9.0409189008675342E-4,29549,241349,-147792,4141,12735,49622,66498,null,500,619,28264,29383,44204]
[86301,"CITY OF TAMA",42031.43,1.1091214360026698E-3,36250,296082,-181309,5080,15623,60876,81579,null,614,759,34674,36047,54229]
[86302,"CITY OF GLADBROOK",3864.51,1.019763277301457E-4,3333,27223,-16670,467,1436,5597,7500,null,56,70,3188,3314,4986]
[86303,"CITY OF TRAER",15076.61,3.9784017182504172E-4,13003,106204,-65035,1822,5604,21836,29262,null,220,272,12438,12930,19452]
[86306,"CITY OF DYSART",26947.4,7.1108546591296909E-4,23241,189826,-116241,3257,10017,39029,52303,null,393,487,22230,23110,34767]
[86308,"CITY OF TOLEDO",34366.800000000003,9.0686789782828134E-4,29640,242090,-148246,4153,12774,49775,66702,null,502,621,28351,29474,44340]
[87201,"TAYLOR COUNTY",32465.85,8.5670580736956316E-4,28000,228699,-140046,3924,12068,47021,63013,null,474,586,26783,27843,41887]
[87306,"CITY OF CLEARFIELD",13.87,3.6600026021853239E-7,12,98,-60,2,5,20,27,null,0,0,11,11,18]
[87310,"CITY OF LENOX",167.97,4.432376619243467E-6,145,1183,-725,20,62,243,325,null,2,3,139,144,217]
[88201,"UNION COUNTY",22674.48,5.9833205337562426E-4,19556,159726,-97810,2740,8428,32840,44008,null,331,409,18705,19445,29254]
[88204,"GREATER REGIONAL MEDICAL CENTER",91858.45,2.4239521703872421E-3,79224,647079,-396245,11102,34144,133042,178288,null,1341,1659,75779,78779,118515]
[88301,"CITY OF CRESTON",2485.17,6.5578433070460733E-5,2143,17506,-10720,300,924,3599,4823,null,36,45,2050,2131,3206]
[88306,"CITY OF AFTON",4176.21,1.1020143812020457E-4,3602,29418,-18015,505,1552,6049,8106,null,61,75,3445,3581,5388]
[89201,"VAN BUREN COUNTY",28752.29,7.5871273409363433E-4,24798,202540,-124027,3475,10687,41643,55805,null,420,519,23719,24658,37096]
[89204,"VAN BUREN COUNTY HOSPITAL",46009.05,1.2140824998130837E-3,39681,324102,-198467,5561,17102,66637,89300,null,672,831,37955,39458,59361]
[89301,"CITY OF FARMINGTON",118.92,3.1380498158030192E-6,103,838,-513,14,44,172,230,null,2,2,98,102,153]
[90201,"WAPELLO COUNTY",87097.82,2.2983291120740375E-3,75118,613543,-375709,10526,32375,126147,169048,null,1272,1573,71852,74697,112373]
[91201,"WARREN COUNTY",16230.57,4.2829076016547268E-4,13998,114333,-70013,1962,6033,23507,31502,null,237,293,13390,13920,20941]
[91301,"CITY OF INDIANOLA",120297.87,3.1744089202404603E-3,103752,847414,-518922,14539,44716,174232,233487,null,1756,2172,99241,103169,155207]
[91303,"CITY OF CARLISLE",73133.31,1.9298349308321989E-3,63075,515173,-315471,8839,27184,105922,141945,null,1068,1320,60332,62720,94356]
[91307,"CITY OF NORWALK",213487.58,5.6334902547530465E-3,184124,1503871,-920909,25802,79355,309202,414359,null,3117,3855,176118,183090,275440]
[92201,"WASHINGTON COUNTY",95383.9,2.5169814146112812E-3,82265,671913,-411452,11528,35455,138148,185131,null,1393,1722,78688,81803,123064]
[92301,"CITY OF WASHINGTON",99243.39,2.6188252750518602E-3,85593,699100,-428101,11994,36889,143738,192621,null,1449,1792,81872,85113,128043]
[93201,"WAYNE COUNTY",43043,1.1358146503667116E-3,37123,303208,-185672,5202,15999,62341,83542,null,628,777,35509,36914,55534]
[93204,"WAYNE COUNTY HOSPITAL",53181.1,1.4033378831079882E-3,45867,374624,-229404,6427,19768,77024,103219,null,776,960,43872,45608,68614]
[93302,"CITY OF SEYMOUR",4097.1899999999996,1.0811626576530417E-4,3534,28862,-17674,495,1523,5934,7952,null,60,74,3380,3514,5286]
[94201,"WEBSTER COUNTY",94843.34,2.5027171679880855E-3,81799,668105,-409120,11463,35254,137365,184082,null,1385,1712,78242,81339,122366]
[94301,"CITY OF FORT DODGE",39383.86,1.0392576069509914E-3,33967,277432,-169888,4760,14639,57041,76440,null,575,711,32490,33776,50813]
[94305,"CITY OF GOWRIE",4536.96,1.1972087531370388E-4,3913,31960,-19571,548,1686,6571,8805,null,66,82,3743,3891,5854]
[94307,"CITY OF DAYTON",3892.68,1.0271967505028672E-4,3357,27421,-16792,470,1447,5638,7555,null,57,70,3211,3338,5022]
[95201,"WINNEBAGO COUNTY",29139.24,7.6892353443188679E-4,25131,205266,-125696,3522,10831,42203,56556,null,425,526,24039,24990,37595]
[95301,"CITY OF FOREST CITY",73022.789999999994,1.9269185394292173E-3,62979,514395,-314994,8825,27143,105762,141730,null,1066,1318,60241,62625,94213]
[95311,"CITY OF LAKE MILLS",28658.6,7.5624045115348473E-4,24717,201880,-123623,3464,10653,41507,55624,null,418,517,23642,24577,36975]
[95317,"BUFFALO CENTER POLICE DEPT",1420.95,3.7495895440340568E-5,1226,10010,-6129,172,528,2058,2758,null,21,26,1172,1219,1833]
[96201,"WINNESHIEK COUNTY",59831.48,1.5788274873294824E-3,51602,421471,-258092,7231,22240,86656,116127,null,873,1080,49358,51311,77194]
[96205,"WINNESHIEK MEDICAL CENTER",87452.18,2.3076799305463544E-3,75424,616040,-377238,10569,32507,126660,169736,null,1277,1579,72144,75000,112830]
[96308,"CITY OF CALMAR",6020.3,1.5886311222737065E-4,5192,42409,-25969,728,2238,8719,11685,null,88,109,4966,5163,7767]
[97201,"WOODBURY COUNTY",472539.59,1.2469330418425279E-2,407546,3328711,{"$f":"ROUND(D439*$G$7,0)+1","v":-2038367},{"$f":"ROUND(D439*$H$7,0)-1","v":57109},175646,684396,917151,null,6899,8532,389825,405256,609667]
[97301,"CITY OF SIOUX CITY",140267.28,3.7013598399528299E-3,120975,988085,-605063,16952,52138,203154,272244,null,2048,2533,115714,120295,180972]
[97306,"CITY OF SERGEANT BLUFF",52765.1,1.3923605140920608E-3,45508,371693,-227610,6377,19613,76422,102412,null,770,953,43529,45252,68077]
[97308,"CITY OF MOVILLE",8436.17,2.2261286339205313E-4,7276,59427,-36391,1020,3136,12218,16374,null,123,152,6959,7234,10884]
[98201,"WORTH COUNTY",51465.84,1.3580757629679419E-3,44387,362541,-222005,6220,19130,74540,99890,null,751,929,42457,44137,66401]
[98302,"CITY OF MANLY",9843.68,2.5975410537187914E-4,8490,69342,-42462,1190,3659,14257,19106,null,144,178,8121,8443,12700]
[99201,"WRIGHT COUNTY",64619.98,1.7051859765909417E-3,55732,455203,-278748,7810,24020,93591,125421,null,943,1167,53309,55419,83372]
[99301,"CITY OF CLARION",41186.86,1.0868350019887717E-3,35522,290133,-177665,4978,15309,59652,79939,null,601,744,33977,35322,53139]
[99302,"CITY OF EAGLE GROVE",44138.59,1.1647249766170954E-3,38068,310926,-190398,5334,16407,63928,85669,null,644,797,36412,37853,56947]
[99304,"CITY OF BELMOND",24272.880000000001,6.4051048278682132E-4,20934,170985,-104705,2934,9022,35155,47111,null,354,438,20024,20816,31317]
[99311,"IOWA SPECIALTY HOSPITAL-CLARION",20827.63,5.4959754864710255E-4,17963,146716,-89843,2517,7742,30165,40424,null,304,376,17182,17862,26872]
[99312,"IOWA SPECIALTY HOSPITAL-BELMOND",35228.99,9.2961928675097877E-4,30384,248164,-151965,4258,13095,51023,68376,null,514,636,29062,30212,45452]
[]
[null,"     Total for all entities",{"$f":"SUM(C8:C450)","v":37896147.920000009},{"$f":"SUM(D8:D450)","v":0.99999999999999989},{"$f":"SUM(E8:E450)","v":32683892},{"$f":"SUM(F8:F450)","v":266951890},{"$f":"SUM(G8:G450)","v":-163470502},{"$f":"SUM(H8:H450)","v":4580038},{"$f":"SUM(I8:I450)","v":14086252},{"$f":"SUM(J8:J451)","v":54886375},{"$f":"SUM(K8:K450)","v":73552665},null,{"$f":"SUM(M8:M450)","v":553254},{"$f":"SUM(N8:N450)","v":684252},{"$f":"SUM(O8:O450)","v":31262684},{"$f":"SUM(P8:P450)","v":32500190},{"$f":"SUM(Q8:Q450)","v":48893325}]
[]
[null,null,{"$f":"+C452-C7","v":0},{"$f":"+D452-D7","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"+C452-C7","v":0},{"$f":"+D452-D7","v":0},{"$f":"+E452-E7","v":0},{"$f":"+F452-F7","v":0},{"$f":"+G452-G7","v":0},{"$f":"+H452-H7","v":0},{"$f":"+I452-I7","v":0},{"$f":"+J452-J7","v":0},{"$f":"+K452-K7","v":0},{"$f":"+L452-L7","v":0},{"$f":"+M452-M7","v":0},{"$f":"+N452-N7","v":0},{"$f":"+O452-O7","v":0},{"$f":"+P452-P7","v":0},{"$f":"+Q452-Q7","v":0}]
["* - Employer specific amounts excluded from this Schedule are the changes in proportion and differences between employer contributions and the proportionate share of contributions, as well as the related amortization as defined in paragraphs 54-55 of GASB Statement No. 68, Accounting and Financial Reporting for Pensions."]
["      "]
["** - The proportions in this spreadsheet are for this membership group only, not the proportions to use to compute the change in entity proportion for the Pension note which is included in the Notes to Financial Statements.  The Employer Calculation of Total Net Pension Liability/(Asset) and Proportion workbook, which  is available on the IPERS website, details how to calculate an employer's proportion and net pension liability/(asset) to comply with GASB Statement No. 68. "]
["    "]