{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheriffs and Deputies"],"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":"Sheriffs and Deputies","index":0,"n_rows":114,"n_cols":17,"rows_kept":114,"cut":false,"hidden":false,"merged":[[3,12,3,15],[4,12,4,15],[110,0,110,3],[112,0,112,3],[3,7,3,10],[4,7,4,10]]}
[]
["Measurement Date: 6/30/2015"]
["Membership Goup: Sheriffs and Deputies"]
[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","2021 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"]
[null,null,11745747.02,1,-140969430,-39131940,-226195336,9423262,1540868,17136989,{"$f":"+H7+I7+J7","v":28101119},null,942036,6614869,138537163,{"$f":"+M7+N7+O7","v":146094068},-23836136]
["01201","ADAIR COUNTY",40097.81,{"$f":"+C8/$C$108","v":3.4138152244998711E-3},{"$f":"ROUND(D8*$E$7,0)","v":-481244},{"$f":"ROUND(D8*$F$7,0)","v":-133589},{"$f":"ROUND(D8*$G$7,0)","v":-772189},{"$f":"ROUND(D8*$H$7,0)","v":32169},{"$f":"ROUND(D8*$I$7,0)","v":5260},{"$f":"ROUND(D8*$J$7,0)","v":58503},{"$f":"ROUND(SUM(H8:J8),0)","v":95932},null,{"$f":"ROUND(D8*$M$7,0)","v":3216},{"$f":"ROUND(D8*$N$7,0)","v":22582},{"$f":"ROUND(D8*$O$7,0)","v":472940},{"$f":"ROUND(SUM(M8:O8),0)","v":498738},{"$f":"ROUND(D8*$Q$7,0)","v":-81372}]
["02201","ADAMS COUNTY",42734.03,{"$f":"+C9/$C$108","v":3.638255610923246E-3},{"$f":"ROUND(D9*$E$7,0)","v":-512883},{"$f":"ROUND(D9*$F$7,0)","v":-142372},{"$f":"ROUND(D9*$G$7,0)","v":-822956},{"$f":"ROUND(D9*$H$7,0)","v":34284},{"$f":"ROUND(D9*$I$7,0)","v":5606},{"$f":"ROUND(D9*$J$7,0)","v":62349},{"$f":"ROUND(SUM(H9:J9),0)","v":102239},null,{"$f":"ROUND(D9*$M$7,0)","v":3427},{"$f":"ROUND(D9*$N$7,0)","v":24067},{"$f":"ROUND(D9*$O$7,0)","v":504034},{"$f":"ROUND(SUM(M9:O9),0)","v":531528},{"$f":"ROUND(D9*$Q$7,0)","v":-86722}]
["03201","ALLAMAKEE COUNTY",68498.66,5.8317840392240966E-3,-822103,-228209,-1319122,54954,8986,99939,163879,null,5494,38576,807919,851989,-139007]
["04208","APPANOOSE COUNTY SHERIFF'S DEPT",55658.52,4.738610486436306E-3,-667999,-185431,-1071852,44653,7302,81206,133161,null,4464,31345,656474,692283,-112950]
["05201","AUDUBON COUNTY",35349.660000000003,3.0095710336523153E-3,-424258,-117770,-680751,{"$f":"ROUND(D12*$H$7,0)","v":28360},4637,51575,84572,null,2835,19908,416937,439680,-71737]
["06201","BENTON COUNTY",95179.89,8.1033492240155519E-3,-1142325,-317100,-1832940,76360,12486,138867,227713,null,7634,53603,1122615,1183852,-193153]
["07201","BLACK HAWK COUNTY",512163.55,4.360417001387111E-2,-6146855,-1706316,-9863060,{"$f":"ROUND(D14*$H$7,0)+1","v":410895},67188,747244,1225327,null,{"$f":"ROUND(D14*$M$7,0)+1","v":41078},{"$f":"ROUND(D14*$N$7,0)-1","v":288435},6040798,6370311,-1039355]
["08201","BOONE COUNTY",89634.67,7.6312447260591509E-3,-1075772,-298625,-1726152,71911,11759,130777,214447,null,7189,50480,1057211,1114880,-181899]
["09201","BREMER COUNTY",97722.05,8.319781605512562E-3,-1172835,-325569,-1881896,78399,12820,142576,233795,null,7838,55034,1152599,1215471,-198311]
[10201,"BUCHANAN COUNTY",73953.19,6.296167444614348E-3,-887567,-246381,-1424164,59330,9702,107897,176929,null,5931,41648,872253,919832,-150076]
[11201,"BUENA VISTA COUNTY",95626.19,8.1413459558743323E-3,-1147681,-318587,-1841534,76718,12545,139518,228781,null,7669,53854,1127879,1189402,-194058]
[12201,"BUTLER COUNTY",73652.160000000003,6.2705385936364221E-3,-883954,-245378,-1418367,59089,9662,107458,176209,null,5907,41479,868703,916089,-149465]
[13201,"CALHOUN COUNTY",47127.21,4.0122786502854542E-3,-565609,-157008,-907559,37809,6182,68758,112749,null,3780,26541,555850,586171,-95637]
[14201,"CARROLL COUNTY",63283.67,5.3877943984528276E-3,-759514,-210835,-1218694,50771,8302,92331,151404,null,5075,35640,746410,787125,-128424]
[15201,"CASS COUNTY",56105.599999999999,4.7766736253102094E-3,-673365,-186921,-1080461,45012,7360,81858,134230,null,4500,31597,661747,697844,-113857]
[16201,"CEDAR COUNTY",95071.43,8.0941152434253587E-3,-1141023,-316738,-1830851,76273,12472,138709,227454,null,7625,53542,1121336,1182503,-192932]
[17201,"CERRO GORDO COUNTY",131234.23000000001,1.1172914738972473E-2,-1575039,-437218,-2527261,105285,17216,191470,313971,null,10525,73907,1547864,1632296,-266319]
[18201,"CHEROKEE COUNTY",43481.97,3.7019331274512667E-3,-521859,-144864,-837360,34884,5704,63440,104028,null,3487,24488,512855,540830,-88240]
[19201,"CHICKASAW COUNTY",62045.17,5.2823519776437336E-3,-744650,-206709,-1194843,49777,8139,90524,148440,null,4976,34942,731802,771720,-125911]
[20201,"CLARKE COUNTY",44809.01,3.814913595848925E-3,-537786,-149285,-862916,35949,5878,65376,107203,null,3594,25235,528507,557336,-90933]
[21201,"CLAY COUNTY",77177.67,6.570690639649073E-3,-926267,-257124,-1486260,61917,10125,112602,184644,null,6190,43464,910285,959939,-156620]
[22201,"CLAYTON COUNTY",88301.81,7.5177687591640287E-3,-1059776,-294185,-1700484,70842,11584,128832,211258,null,7082,49729,1041490,1098301,-179195]
[23201,"CLINTON COUNTY",171987.39,1.4642524626756349E-2,-2064148,-572990,-3312071,137980,22562,250929,411471,null,13794,96858,2028534,2139186,-349021]
[24201,"CRAWFORD COUNTY",67449.759999999995,5.7424836313220706E-3,-809515,-224715,-1298923,54113,8848,98409,161370,null,5410,37986,795547,838943,-136879]
[25201,"DALLAS COUNTY",223082.11,1.8992585964958061E-2,-2677374,-743217,-4296034,178972,29265,325476,533713,null,17892,125633,2631179,2774704,-452710]
[26201,"DAVIS COUNTY",34600.839999999997,2.9458185963892819E-3,-415270,-115276,-666330,{"$f":"ROUND(D33*$H$7,0)","v":27759},4539,50482,82780,null,2775,19486,408105,430366,-70217]
[27201,"DECATUR COUNTY",32729.98,2.7865388164983649E-3,-392817,-109043,-630302,{"$f":"ROUND(D34*$H$7,0)","v":26258},4294,47753,78305,null,2625,18433,386039,407097,-66420]
[28201,"DELAWARE COUNTY",95560.66,8.1357669152319258E-3,-1146894,-318368,-1840273,76665,12536,139423,228624,null,7664,53817,1127106,1188587,-193925]
[29201,"DES MOINES COUNTY",138698.29,1.1808383899621907E-2,-1664621,-462085,-2671001,111273,18195,202360,331828,null,11124,78111,1635900,1725135,-281466]
[30201,"DICKINSON COUNTY",65112.800000000003,5.5435214030346101E-3,-781467,-216929,-1253919,52238,8542,94999,155779,null,5222,36670,767984,809876,-132136]
[31201,"DUBUQUE COUNTY",580125.31000000006,4.9390243891018176E-2,-6962515,-1932736,-11171843,{"$f":"ROUND(D38*$H$7,0)+1","v":465418},76104,846400,1387922,null,{"$f":"ROUND(D38*$M$7,0)+1","v":46528},{"$f":"ROUND(D38*$N$7,0)-1","v":326709},6842384,7215621,-1177273]
[32201,"EMMET COUNTY",50087.4,4.2643009350289921E-3,-601136,-166870,-964565,40184,6571,73077,119832,null,4017,28208,590764,622989,-101644]
[33201,"FAYETTE COUNTY",80774.36,6.8769027514777844E-3,-969433,-269107,-1555523,64803,10596,117849,193248,null,6478,45490,952707,1004675,-163919]
[34201,"FLOYD COUNTY",78709.58,6.701113165980651E-3,-944652,-262228,-1515761,63146,10326,114837,188309,null,6313,44327,928353,978993,-159729]
[35201,"FRANKLIN COUNTY",38941.31,3.3153540539986866E-3,-467364,-129736,-749918,{"$f":"ROUND(D42*$H$7,0)","v":31241},5109,56815,93165,null,3123,21931,459300,484354,-79025]
[36201,"FREMONT COUNTY",49416.36,4.2071704690946083E-3,-593082,-164635,-951642,39645,6483,72098,118226,null,3963,27830,582849,614642,-100283]
[37201,"GREENE COUNTY",51401.2,4.3761541869135195E-3,-616904,-171247,-989866,41238,6743,74994,122975,null,4122,28948,606260,639330,-104311]
[38201,"GRUNDY COUNTY",75557.8,6.4327794453042791E-3,-906825,-251727,-1455065,60618,9912,110238,180768,null,6060,42552,891179,939791,-153333]
[39201,"GUTHRIE COUNTY",56849,4.8399646189553292E-3,-682287,-189397,-1094777,45608,7458,82942,136008,null,4559,32016,670515,707090,-115366]
[40201,"HAMILTON COUNTY",67135.520000000004,5.7157301179469808E-3,-805743,-223668,-1292871,53861,8807,97950,160618,null,5384,37809,791841,835034,-136241]
[41201,"HANCOCK COUNTY",54815.87,4.6668696258026507E-3,-657886,-182624,-1055624,43977,7191,79976,131144,null,4396,30871,646535,681802,-111240]
[42201,"HARDIN COUNTY",68069.27,5.795226977398326E-3,-816950,-226778,-1310853,54610,8930,99313,162853,null,5459,38335,802854,846648,-138136]
[43201,"HARRISON COUNTY",63453.78,5.4022770873537844E-3,-761556,-211402,-1221970,50907,8324,92579,151810,null,5089,35735,748416,789240,-128769]
[44201,"HENRY COUNTY",75062.039999999994,6.3905718275890453E-3,-900875,-250075,-1445518,60220,9847,109515,179582,null,6020,42273,885332,933625,-152327]
[45201,"HOWARD COUNTY",55600.36,4.733658906949623E-3,-667301,-185237,-1070732,44607,7294,81121,133022,null,4459,31313,655788,691560,-112832]
[46201,"HUMBOLDT COUNTY",58865.34,5.0116301585388639E-3,-706487,-196115,-1133607,47226,7722,85884,140832,null,4721,33151,694297,732169,-119458]
[47201,"IDA COUNTY",55363.44,4.713488201791698E-3,-664458,-184448,-1066169,44416,7263,80775,132454,null,4440,31179,652993,688612,-112351]
[48201,"IOWA COUNTY",75076.33,6.3917884381609977E-3,-901047,-250123,-1445793,60231,9849,109536,179616,null,6021,42281,885500,933802,-152356]
[49201,"JACKSON COUNTY",69310.649999999994,5.9009145933401844E-3,-831849,-230914,-1334759,55606,9093,101124,165823,null,5559,39034,817496,862089,-140655]
[50201,"JASPER COUNTY",118054.36,1.0050817525610217E-2,-1416858,-393308,-2273448,94711,15487,172241,282439,null,9468,66485,1392412,1468365,-239573]
[51201,"JEFFERSON COUNTY",68701.23,5.8490302816005986E-3,-824534,-228884,-1323023,55117,9013,100235,164365,null,5510,38691,810308,854509,-139418]
[52201,"JOHNSON COUNTY",538351.18999999994,4.5833712328668889E-2,-6461152,-1793562,-10367372,{"$f":"ROUND(D59*$H$7,0)+1","v":431904},70624,785452,1287980,null,{"$f":"ROUND(D59*$M$7,0)+1","v":43178},{"$f":"ROUND(D59*$N$7,0)-1","v":303183},6349672,6696033,-1092499]
[53201,"JONES COUNTY",73683.69,6.273222969517012E-3,-884333,-245483,-1418974,59114,9666,107504,176284,null,5910,41497,869075,916482,-149529]
[54201,"KEOKUK COUNTY",38763.839999999997,3.3002447553139953E-3,-465234,-129145,-746500,{"$f":"ROUND(D61*$H$7,0)","v":31099},5085,56556,92740,null,3109,21831,457207,482147,-78665]
[55201,"KOSSUTH COUNTY",61057.34,5.1982508984771232E-3,-732794,-203418,-1175820,48984,8010,89082,146076,null,4897,34386,720151,759434,-123906]
[56201,"LEE COUNTY",106335.25,9.053085326879446E-3,-1276208,-354265,-2047766,85310,13950,155143,254403,null,8528,59885,1254189,1322602,-215791]
[57210,"LINN COUNTY SHERIFF'S DEPARTMENT",1095945.1399999999,9.3305699342399059E-2,-13153251,{"$f":"ROUND(D64*$F$7,0)-1","v":-3651234},{"$f":"ROUND(D64*$G$7,0)+1","v":-21105313},{"$f":"ROUND(D64*$H$7,0)+1","v":879245},143772,{"$f":"ROUND(D64*$J$7,0)+1","v":1598980},2621997,null,{"$f":"ROUND(D64*$M$7,0)+1","v":87898},{"$f":"ROUND(D64*$N$7,0)-1","v":617204},12926307,13631409,-2224047]
[58201,"LOUISA COUNTY",63414.35,5.3989201276020667E-3,-761083,-211270,-1221211,50875,8319,92521,151715,null,5086,35713,747951,788750,-128689]
[59201,"LUCAS COUNTY",27647.26,2.3538102730225495E-3,-331815,-92109,-532421,{"$f":"ROUND(D66*$H$7,0)","v":22181},3627,40337,66145,null,2217,15570,326090,343877,-56106]
[60201,"LYON COUNTY",75420.39,6.4210807428065984E-3,-905176,-251269,-1452419,60508,9894,110038,180440,null,6049,42475,889558,938082,-153054]
[61201,"MADISON COUNTY",48400.34,4.1206693722916563E-3,-580888,-161250,-932076,38830,6349,70616,115795,null,3882,27258,570866,602006,-98221]
[62201,"MAHASKA COUNTY",58794.34,5.0055854174186013E-3,-705635,-195878,-1132240,47169,7713,85781,140663,null,4715,33111,693460,731286,-119314]
[63201,"MARION COUNTY",114362.24000000001,9.73648077089268E-3,-1372546,-381007,-2202347,91749,15003,166854,273606,null,9172,64406,1348864,1422442,-232080]
[64201,"MARSHALL COUNTY",126669.37,1.0784275345307069E-2,-1520253,-422010,-2439353,101623,16617,184810,303050,null,10159,71337,1494023,1575519,-257055]
[65201,"MILLS COUNTY",69954.539999999994,5.9557335843250592E-3,-839576,-233059,-1347159,56122,9177,102063,167362,null,5611,39396,825090,870097,-141962]
[66207,"MITCHELL COUNTY SHERIFF'S DEPT",50761.85,{"$f":"+C73/$C$108","v":4.3217217188115456E-3},{"$f":"ROUND(D73*$E$7,0)","v":-609231},{"$f":"ROUND(D73*$F$7,0)","v":-169117},{"$f":"ROUND(D73*$G$7,0)","v":-977553},{"$f":"ROUND(D73*$H$7,0)","v":40725},{"$f":"ROUND(D73*$I$7,0)","v":6659},{"$f":"ROUND(D73*$J$7,0)","v":74061},{"$f":"ROUND(SUM(H73:J73),0)","v":121445},null,{"$f":"ROUND(D73*$M$7,0)","v":4071},{"$f":"ROUND(D73*$N$7,0)","v":28588},{"$f":"ROUND(D73*$O$7,0)","v":598719},{"$f":"ROUND(SUM(M73:O73),0)","v":631378},{"$f":"ROUND(D73*$Q$7,0)","v":-103013}]
[67201,"MONONA COUNTY",46098.41,3.9246895000808555E-3,-553261,-153581,-887746,36983,6047,67257,110287,null,3697,25961,543715,573373,-93549]
[68201,"MONROE COUNTY",32507.57,2.7676034520961439E-3,-390147,-108302,-626019,{"$f":"ROUND(D75*$H$7,0)","v":26080},{"$f":"ROUND(D75*$I$7,0)","v":4265},47428,77773,null,2607,18307,383416,404330,-65969]
[69201,"MONTGOMERY COUNTY",52194.23,4.4436705397389014E-3,-626422,-173889,-1005138,41874,6847,76151,124872,null,4186,29394,615614,649194,-105920]
[70201,"MUSCATINE COUNTY",158457.57999999999,1.3490634502019094E-2,-1901767,-527915,-3051519,127126,20787,231189,379102,null,12709,89239,1868954,1970902,-321565]
[71201,"O'BRIEN COUNTY",65097.01,5.5421770866643438E-3,-781278,-216876,-1253615,52225,8540,94976,155741,null,5221,36661,767797,809679,-132104]
[72201,"OSCEOLA COUNTY",53977.01,4.595451435152738E-3,-647818,-179829,-1039470,43304,7081,78752,129137,null,4329,30398,636641,671368,-109538]
[73201,"PAGE COUNTY",53187.22,4.5282109268517173E-3,-638339,-177198,-1024260,42671,6977,77600,127248,null,4266,29954,627325,661545,-107935]
[74201,"PALO ALTO COUNTY",50597.4,4.3077209064562331E-3,-607257,-168569,-974386,40593,6638,73821,121052,null,4058,28495,596779,629332,-102679]
[75201,"PLYMOUTH COUNTY",87007.86,7.4076054806772084E-3,-1044246,-289874,-1675566,69804,11414,126944,208162,null,6978,49000,1026229,1082207,-176569]
[76201,"POCAHONTAS COUNTY",49019.44,4.1733778121163722E-3,-588319,-163312,-943999,39327,6431,71519,117277,null,3931,27606,578168,609705,-99477]
[77209,"POLK COUNTY ADMINISTRATION OFFICE BLDG",1264251.1000000001,0.10763479733109388,{"$f":"ROUND(D84*$E$7,0)-1","v":-15173217},{"$f":"ROUND(D84*$F$7,0)-1","v":-4211959},{"$f":"ROUND(D84*$G$7,0)+1","v":-24346488},{"$f":"ROUND(D84*$H$7,0)+1","v":1014272},{"$f":"ROUND(D84*$I$7,0)-1","v":165850},{"$f":"ROUND(D84*$J$7,0)+1","v":1844537},3024659,null,{"$f":"ROUND(D84*$M$7,0)+1","v":101397},{"$f":"ROUND(D84*$N$7,0)-1","v":711989},{"$f":"ROUND(D84*$O$7,0)+1","v":14911420},15724806,{"$f":"ROUND(D84*$Q$7,0)-1","v":-2565599}]
[78201,"POTTAWATTAMIE COUNTY",387726.05,3.3009909828621523E-2,-4653388,-1291742,-7466688,{"$f":"ROUND(D85*$H$7,0)+1","v":311062},50864,565690,927616,null,{"$f":"ROUND(D85*$M$7,0)+1","v":31098},218356,4573099,4822553,-786829]
[79201,"POWESHIEK COUNTY",83342.64,7.0955589166094594E-3,-1000257,-277663,-1604982,66863,10933,121597,199393,null,6684,46936,982999,1036619,-169131]
[80201,"RINGGOLD COUNTY",31522.94,2.6837748119659397E-3,-378330,-105021,-607057,{"$f":"ROUND(D87*$H$7,0)","v":25290},4135,45992,75417,null,2528,17753,371803,392084,-63971]
[81201,"SAC COUNTY",57634.29,4.9068220098614041E-3,-691712,-192013,-1109900,46238,7561,84088,137887,null,4622,32458,679777,716857,-116960]
[82201,"SCOTT COUNTY",361811.42,3.080361082048913E-2,-4342367,-1205405,-6967633,{"$f":"ROUND(D89*$H$7,0)+1","v":290271},47464,527881,865616,null,29018,203762,4267445,4500225,-734239]
[83201,"SHELBY COUNTY",59447.26,5.0611731973093351E-3,-713471,-198054,-1144814,47693,7799,86733,142225,null,4768,33479,701161,739408,-120639]
[84201,"SIOUX COUNTY",102459.41,8.7231071659842358E-3,-1229691,-341352,-1973126,82200,13441,149488,245129,null,8217,57702,1208475,1274394,-207925]
[85201,"STORY COUNTY",231863.71,1.9740226790615822E-2,-2782769,-772473,-4465147,186017,30417,338288,554722,null,18596,130579,2734755,2883930,-470531]
[86201,"TAMA COUNTY",79973.429999999993,6.8087138147812738E-3,-959821,-266438,-1540099,64160,10491,116681,191332,null,6414,45039,943260,994713,-162293]
[87201,"TAYLOR COUNTY",48341.82,4.1156871434133773E-3,-580186,-161055,-930949,38783,6342,70530,115655,null,3877,27225,570176,601278,-98102]
[88201,"UNION COUNTY",35544.730000000003,3.0261787470372403E-3,-426599,-118420,-684508,28516,4663,51860,85039,null,2851,20018,419238,442107,-72132]
[89201,"VAN BUREN COUNTY",36737.919999999998,3.1277636013652193E-3,-440919,-122395,-707486,29474,4819,53600,87893,null,2946,20690,433311,456947,-74554]
[90201,"WAPELLO COUNTY",75801.17,6.4534992853949608E-3,-909746,-252538,-1459751,60813,9944,110594,181351,null,6079,42689,894049,942817,-153826]
[91201,"WARREN COUNTY",146718.72,1.2491220843610505E-2,-1760880,-488806,-2825456,117708,19247,214062,351017,null,11767,82628,1730498,1824893,-297742]
[92201,"WASHINGTON COUNTY",116935.64,9.9555728384826039E-3,-1403431,-389581,-2251904,93814,15340,170609,279763,null,9379,65855,1379217,1454451,-237302]
[93201,"WAYNE COUNTY",42221.760000000002,3.5946423780545546E-3,-506735,-140665,-813091,33873,5539,61601,101013,null,3386,23778,497992,525156,-85682]
[94201,"WEBSTER COUNTY",107901.49,9.18643061324847E-3,-1295006,-359483,-2077928,86566,14155,157428,258149,null,8654,60767,1272662,1342083,-218969]
[95201,"WINNEBAGO COUNTY",47426.01,4.0377176453098851E-3,-569195,-158004,-913313,38048,6222,69194,113464,null,3804,26709,559374,589887,-96244]
[96201,"WINNESHIEK COUNTY",82263.3,7.0036669323736206E-3,-987303,-274067,-1584197,65997,10792,120022,196811,null,6598,46328,970268,1023194,-166940]
[97201,"WOODBURY COUNTY",305843.53999999998,2.603866229020825E-2,-3670655,-1018943,-5889824,{"$f":"ROUND(D104*$H$7,0)+1","v":245370},40122,446224,731716,null,24529,172242,3607322,3804093,-620661]
[98201,"WORTH COUNTY",71191.94,6.0610823542153894E-3,-854427,-237182,-1370989,57115,9339,103869,170323,null,5710,40093,839685,885488,-144473]
[99201,"WRIGHT COUNTY",61581.38,5.2428661961765963E-3,-739084,-205164,-1185912,49405,8079,89847,147331,null,4939,34681,726332,765952,-124970]
[null,null,null,null,null,null,null,null,null,{"$f":"ROUND(D107*$J$7,0)","v":0}]
[null,"     Total for all entities",{"$f":"SUM(C8:C106)","v":11745747.020000001},0.99999999999999978,-140969430,-39131940,-226195336,9423262,1540868,{"$f":"SUM(J8:J107)","v":17136989},{"$f":"SUM(K8:K106)","v":28101119},null,{"$f":"SUM(M8:M106)","v":942036},{"$f":"SUM(N8:N106)","v":6614869},{"$f":"SUM(O8:O106)","v":138537163},{"$f":"SUM(P8:P106)","v":146094068},{"$f":"SUM(Q8:Q106)","v":-23836136}]
[null,null,{"$f":"+C7-C108","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,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. "]
["    "]