{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Horiz","Vert","New Region","Insert Cut Cells","Policies","Compatibility Report"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":17,"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":"Horiz","index":0,"n_rows":21,"n_cols":6,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,0,5,2]]}
[]
[]
[]
[]
[]
[null,null,null,null,null,"Monthly Claims 2008"]
[]
["Month","Northern Region","Southern Region","Eastern Region","Western Region","TOTAL"]
["January",123456,111112,137872,173622,{"$f":"SUM(B9:E9)","v":546062}]
["February",243568,121731,270277,227893,863469]
["March",153623,188999,136934,123282,602838]
["April",207894,125778,133132,255687,722491]
["May",103283,35333,233824,122344,494784]
["June",235688,155445,244443,118542,754118]
["July",102345,65500,122024,219234,509103]
["August",98543,119771,113824,229853,561991]
["September",199235,15160,158045,107434,{"$f":"SUM(B17:E17)","v":479874}]
["October",209854,147565,278157,99234,{"$f":"SUM(B18:E18)","v":734810}]
["November",87435,14222,188212,143455,{"$f":"SUM(B19:E19)","v":433324}]
["December",79235,10420,242483,263567,{"$f":"SUM(B20:E20)","v":595705}]
["TOTAL",{"$f":"SUM(B9:B20)","v":1844159},{"$f":"SUM(C9:C20)","v":1111036},{"$f":"SUM(D9:D20)","v":2259227},{"$f":"SUM(E9:E20)","v":2084147},{"$f":"SUM(F9:F16)","v":5054856}]

{"sheet":"Vert","index":1,"n_rows":13,"n_cols":14,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,0,5,2]]}
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Monthly Claims 2008"]
[]
["Region","January","February","March","April","May","June","July","August","September","October","November","December","TOTAL"]
["Northern Region",123456,243568,153623,207894,103283,235688,102345,98543,199235,209854,87435,79235,{"$f":"SUM(B9:M9)","v":1844159}]
["Southern Region",111112,121731,188999,125778,35333,155445,65500,119771,15160,147565,14222,10420,{"$f":"SUM(B10:M10)","v":1111036}]
["Eastern Region",137872,270277,136934,133132,233824,244443,122024,113824,158045,278157,188212,242483,{"$f":"SUM(B11:M11)","v":2259227}]
["Western Region",173622,227893,123282,255687,122344,118542,219234,229853,107434,99234,143455,263567,{"$f":"SUM(B12:M12)","v":2084147}]
["TOTAL",{"$f":"SUM(B9:B12)","v":546062},863469,602838,722491,494784,754118,509103,561991,479874,734810,433324,595705,{"$f":"SUM(B13:M13)","v":7298569}]

{"sheet":"New Region","index":2,"n_rows":21,"n_cols":7,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,0,5,2]]}
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Monthly Claims 2008"]
[]
["Month","Northern Region","Southern Region","Central Region","Eastern Region","Western Region","TOTAL"]
["January",123456,111112,116253.71674745576,137872,173622,{"$f":"SUM(B9:F9)","v":662315.71674745576}]
["February",243568,121731,234873.37155052324,270277,227893,1098342.3715505232]
["March",153623,188999,151563.72768873948,136934,123282,754401.72768873954]
["April",207894,125778,201667.36111047218,133132,255687,924158.36111047212]
["May",103283,35333,99349.195947190718,233824,122344,594133.19594719075]
["June",235688,155445,229685.12736010554,244443,118542,983803.12736010551]
["July",102345,65500,96019.53359665157,122024,219234,605122.53359665163]
["August",98543,119771,94024.182715027317,113824,229853,656015.18271502736]
["September",199235,15160,197817.17428330553,158045,107434,677691.17428330553]
["October",209854,147565,203274.36634370068,278157,99234,938084.36634370068]
["November",87435,14222,86739.59148433838,188212,143455,520063.59148433839]
["December",79235,10420,77514.697687277003,242483,263567,673219.69768727699]
["TOTAL",{"$f":"SUM(B9:B20)","v":1844159},{"$f":"SUM(C9:C20)","v":1111036},{"$f":"SUM(D9:D20)","v":1788782.0465147875},{"$f":"SUM(E9:E20)","v":2259227},{"$f":"SUM(F9:F20)","v":2084147},{"$f":"SUM(G9:G16)","v":6278292.2167161657}]

{"sheet":"Insert Cut Cells","index":3,"n_rows":21,"n_cols":7,"rows_kept":21,"cut":false,"hidden":false,"merged":[[0,0,5,2]]}
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Monthly Claims 2008"]
[]
["Month","Northern Region","Southern Region","Central Region","Eastern Region","Western Region","TOTAL"]
["September",199235,15160,197817.17428330553,158045,107434,{"$f":"SUM(B9:F9)","v":677691.17428330553}]
["October",209854,147565,203274.36634370068,278157,99234,{"$f":"SUM(B10:F10)","v":938084.36634370068}]
["November",87435,14222,86739.59148433838,188212,143455,{"$f":"SUM(B11:F11)","v":520063.59148433839}]
["December",79235,10420,77514.697687277003,242483,263567,{"$f":"SUM(B12:F12)","v":673219.69768727699}]
["January",123456,111112,116253.71674745576,137872,173622,{"$f":"SUM(B13:F13)","v":662315.71674745576}]
["February",243568,121731,234873.37155052324,270277,227893,1098342.3715505232]
["March",153623,188999,151563.72768873948,136934,123282,754401.72768873954]
["April",207894,125778,201667.36111047218,133132,255687,924158.36111047212]
["May",103283,35333,99349.195947190718,233824,122344,594133.19594719075]
["June",235688,155445,229685.12736010554,244443,118542,983803.12736010551]
["July",102345,65500,96019.53359665157,122024,219234,605122.53359665163]
["August",98543,119771,94024.182715027317,113824,229853,656015.18271502736]
["TOTAL",{"$f":"SUM(B13:B20)","v":1268400},923669,1223436.2167161659,1392330,1470457,6278292.2167161657]

{"sheet":"Policies","index":4,"n_rows":32,"n_cols":14,"rows_kept":32,"cut":false,"hidden":false,"merged":[[0,0,5,2]]}
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"Group Policy Summary"]
[]
["Month","Claims Totals","Column2","Column3","Column4","Column5","Column6","Column7","Column8","Column9","Column10","Column11","Column12","Year Total"]
["Policy Number","2008-01-01","2008-02-01","2008-03-01","2008-04-01","2008-05-01","2008-06-01","2008-07-01","2008-08-01","2008-09-01","2008-10-01","2008-11-01","2008-12-01"]
["023048",348.6213621379768,6854.2293720701555,710.49491599291241,5454.4017813926284,5333.7268720055072,5305.4417810849682,11452.563850471581,2943.4072963882986,10166.889644482662,5272.0302792280509,4288.2041136848084,8266.4323135053091,{"$f":"SUM(B10:M10)","v":66396.443582444859}]
["004578",6520.5827506443147,7737.0258928185931,4465.1251864029437,5163.287478313785,10340.156334684776,3314.1947541770305,9895.5125876168222,6597.9547998033513,2217.9206837125271,8227.8665557306467,10461.275645676627,7706.9480051623968,{"$f":"SUM(B11:M11)","v":82647.850674743808}]
["024589",5350.1905149030899,6509.8786782456009,1372.3308650457423,11875.257429235486,6297.0443367040843,9776.2625858082411,8218.6870377387313,6724.2294470815805,7861.2316032014087,2134.4068560356882,2808.5649414940335,6795.1222279033855,{"$f":"SUM(B12:M12)","v":75723.206523397064}]
["047789",434.23205415282087,8176.8356498538515,3086.7490296750461,10596.05225362597,10433.014675650405,1745.9613776269234,2490.5214890151133,6575.3754324272841,2675.9536833565689,644.95605986475516,3737.2957467605693,4905.3607505511209,{"$f":"SUM(B13:M13)","v":55502.308202560424}]
["014235",7966.762977553788,1578.034370752013,7509.3869705210727,3268.2693024519344,3281.6511954482821,11255.222312578549,3017.1636489295456,6173.0279520683916,1621.3490786781131,828.13351274884621,353.06052141826848,1071.2126638148188,{"$f":"SUM(B14:M14)","v":47923.274506963629}]
["023487",5048.4031403362542,5456.0730573488709,9402.3280382603043,2272.4955694566988,1027.8194492371777,10958.642773321923,3729.5086095959532,2497.886656855344,4838.6887913330729,7466.451497110439,1328.9849366258745,5904.8944177136837,59932.176937195589]
["123889",10111.908181085342,8479.0782541435619,8611.3657589233062,11581.950200786934,2111.7537434794431,2542.3465266114222,9404.0696657765384,7032.0194063788085,6141.4218612748018,12187.931394828443,3163.0604251397335,7005.2671123241244,88372.172530752461]
["044512",2652.1419502237868,1344.9249628086302,1966.8915585581649,11870.828414737209,12179.692949119286,8668.2851155100125,2716.9512388363978,8241.9484272634218,619.33596906490686,11367.384001449896,5852.1100544288229,10206.67636047097,77687.171002471499]
["011347",977.36800039209106,9274.9636657261563,10616.992911581388,6226.2164558095774,5495.6443208580868,2991.7069622710915,3062.9082793889352,11011.043693732174,12213.947958674351,11771.733955798767,1883.0117146996631,2856.8818803924341,78382.419799324722]
["228911",12205.779149097061,5615.8550972440808,10806.741849117429,5655.531997258885,5433.5768945113459,10677.51281093234,8032.1479815037392,1784.1581632252569,7271.1528502477222,9120.9740978754926,4375.4470502170416,929.31199656627564,81908.189937796677]
["023158",6426.9500923933974,1700.6892105592665,2292.5687175565795,646.20693816549897,3677.1715383648361,6985.5100960558248,6138.4851792546333,8036.7772747502941,10213.447137640753,5748.1705848299734,1707.145430172877,3974.101542825942,57547.223742569877]
["011099",9715.0839085774787,12287.897954418198,9679.6421561197585,9874.4470671466825,9578.4782625629814,3943.8484460453878,8879.4204267524619,2316.8429509217299,4488.4528173112894,12053.950629176437,8252.9609567863026,10013.38841327541,101084.41398909414]
["112899",3826.4385928040547,3882.2517436230323,8843.2059368025475,4659.337152824337,11389.009702814687,8373.1231580322892,5006.366850111026,2.6667553849188517,4109.0364502880439,1650.8100938825983,6229.763835998423,3299.4651555158707,61271.475428081823]
["112345",1031.1241363651,6378.9750566460125,11992.863135490683,872.68546899086391,5822.8227742740519,6511.2979604661932,2966.1015534853323,10837.188594448284,8393.017891603,2872.5452480706545,5550.7131168983678,642.35287387438302,63871.68781061293]
["001234",2861.4061353151942,7258.4867455223366,8177.1595898703172,6268.1639313887526,10076.801983937046,9361.1160607342481,4914.6642860536731,576.78514812125979,860.77151389216567,12265.869749959593,3205.6461681621681,5509.8493356511808,71336.720648607923]
["002234",6704.1572452434757,8252.1373511717738,1924.7576729917116,5458.9382666004212,506.54809773280283,2382.6996488563427,9327.0832331423753,3993.2645062757738,394.54794937354973,1134.242612631768,6815.530471592393,3343.5933238914758,50237.500379503857]
["023456",2338.8657531823419,10909.393818779245,1510.5260459604988,11140.129193057865,8427.6368362834728,9550.2009549813829,10167.410687155454,10389.1903687171,3422.4429856407914,11331.393793212163,10397.274951646388,8751.1319341795697,98335.597322796268]
["123456",1585.5573925571421,7322.9841186916719,12010.861485907946,4804.4849169351364,4865.2010349737166,8598.1962918743229,5694.6143127207351,6565.9970453434144,9330.8141326731911,3599.4287984066209,8864.0609664216317,11956.583041842778,85198.783538348303]
["234567",2570.8857529107768,5752.8111517367533,10247.153021658254,3458.6575207228643,8989.3428342514053,7849.8069980576156,1038.3597388417277,3369.8269796071058,734.59853638548441,7621.0576568426495,1281.0796666627796,4537.2381101571136,57450.817967834526]
["012345",9719.3116680119856,4428.7233607087455,5665.9573355883358,9060.8246280430994,6207.5038262748458,6893.9096602588943,7715.6052176010789,3957.6738751927792,8863.960083283524,10965.809742492749,46.312836297362765,682.19709139969279,74207.789325153091]
["002897",11476.466451383039,3135.8508478278768,11370.00833257868,6935.6660702211639,10420.307457046072,398.36746447029094,1610.7003777275788,7352.241477550655,3067.3828399852086,5575.7033097342082,11516.036714658057,9060.4064717831243,81919.137814965958]
["188197",2100.7911970567729,5984.178109567817,11022.045880528527,9161.4244856646892,6598.7055279045744,9590.8213658265267,1715.4655973150864,11616.46304646311,7747.4111292119123,7698.5318051877475,9109.6905638716726,4664.8595986912105,87010.388307289642]
["Total",{"$f":"SUM(B10:B31)","v":111973.02840632727},138321.27847026422,153285.15639513213,146305.25652283049,148493.61064811889,147674.47510558183,127194.31184903451,128595.96929800035,117253.77559131503,151539.38223509819,111227.23082931386,122083.27462149225,1603946.749972509]

{"sheet":"Compatibility Report","index":5,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
[null,"Compatibility Report for Humongous.xls"]
[null,"Run on 6/13/2006 14:45"]
[]
[null,"Because some of the features in this workbook are not supported by versions of Excel earlier than Excel 2007, the features will be lost or degraded if saved in this format."]
[]
[null,"Minor loss of fidelity",null,null,"# of occurrences"]
[]
[null,"This workbook contains a table with table style applied. Table style formatting will not be displayed in previous versions of Excel.",null,"Help",1]
[null,null,null,null,"'Policies'!A8:N31"]