{"text_format":"3","workbook":"xlsx","n_sheets":7,"sheets":["Criteria","MotorAggCalc","Detail","By Cluster","By Department","By Policy","Risk Analysis"],"not_rendered":{"images":1,"defined_names":1,"pivot_tables":6},"read":"whole","date_system":"1900"}

{"sheet":"Criteria","index":0,"n_rows":26,"n_cols":1,"rows_kept":26}
{"$rows_empty":16}
["City Of Johannesburg Cluster Claims Report\n"]
[{"$f":"TODAY()","v":"2023-12-14"}]
["OCTOBER 2017"]
[]
["Non Motor Aggregate"]
["Motor Aggregate"]
["Detail"]
["By Cluster"]
["By Department"]
["By Policy"]

{"sheet":"MotorAggCalc","index":1,"n_rows":18,"n_cols":12,"rows_kept":18}
[]
[]
["InsuredYear","PolicyTypeDescription","Aggregate Amount","Balance of Aggregate","Aggregate Paid","Aggregate Estimate","Aggregate Credit","Aggregate Total","Aggregare Usage","Insurer Total","Excess Total","Gross"]
["2018","Motor - Metrobus",10642466,8174777,{"v":2476037,"d":"2,476,037"},0,8348,2476037,0.2319,1183637,2136464,5796136]
[null,"Motor - Fleet",68863014,258012,{"v":71175962,"d":"71,175,962"},{"v":25932,"d":"25,932"},2596892,71201894,0.9963,27404020,4219472,102825332]
[null,"Motor - Red Fleet",25041096,24266823,{"v":774273,"d":"774,273"},0,0,774273,0.0309,497645,47850,1319768]
["2019","Motor - Metrobus",6363388,5173727,{"v":1189661,"d":"1,189,661"},0,0,1189661,0.187,635007,667155,2491823]
[null,"Motor - Fleet",72243169,22081853,{"v":51480761,"d":"51,480,761"},{"v":454247,"d":"454,247"},1773692,51935008,0.6943,3368291,206615,55509905]
[null,"Motor - Red Fleet",14972678,13887560,{"v":1085118,"d":"1,085,118"},0,0,1085118,0.0725,235750,36274,1357142]
["2020","Motor - Metrobus",8500000,7082524,{"v":1417476,"d":"1,417,476"},0,0,1417476,0.1668,266849,723149,2407475]
[null,"Motor - Fleet",82000000,22242672,{"v":60607892,"d":"60,607,892"},{"v":666999,"d":"666,999"},1517563,61274891,0.7287,3824088,364693,65463660]
[null,"Motor - Red Fleet",20000000,18905812,{"v":1094188,"d":"1,094,188"},0,0,1094188,0.0547,16098,20000,1130286]
["2021","Motor - Metrobus",8500000,3223018,{"v":4010917,"d":"4,010,917"},{"v":1424109,"d":"1,424,109"},158044,5435026,0.6208,466939,1672185,7574151]
[null,"Motor - Fleet",82000000,32926268,{"v":44694235,"d":"44,694,235"},{"v":4933103,"d":"4,933,103"},553606,49627338,0.5985,2421852,405071,52454235]
[null,"Motor - Red Fleet",20000000,18526659,{"v":1424863,"d":"1,424,863"},{"v":64082,"d":"64,082"},15604,1488945,0.0737,215915,156216,1861073]
["2022","Motor - Metrobus",8500000,2553561,{"v":440491,"d":"440,491"},{"v":5505948,"d":"5,505,948"},0,5946439,0.6996,772983,418700,7138122]
[null,"Motor - Fleet",120000000,92470463,{"v":3483321,"d":"3,483,321"},{"v":24450208,"d":"24,450,208"},403992,27933529,0.2294,2685905,171033,30790460]
[null,"Motor - Red Fleet",20000000,19580263,{"v":4903,"d":"4,903"},{"v":414834,"d":"414,834"},0,419737,0.021,18089,77847,515672]

{"sheet":"Detail","index":2,"n_rows":11,"n_cols":22,"rows_kept":11}
["CITY OF JOHANNESBURG CLUSTER CLAIMS REPORT"]
["Insured Year","(All)","Select from drop down list to change the year or select multiple years"]
["Ageing","(All)","Select from drop down list to change the Ageing category"]
[]
["Cluster","Business Unit","Operational_Area","Policy Type Description","Sum of Counts"," Own Damage Excess Estimate"," Third Party Excess Estimate"," Own Damage Exess Paid"," Third Party Excess Paid"," AGG Own Damage Estimate"," AGG Own Damage Fees"," AGG Own Damage Paid"," AGG Third Party Estimate"," AGG Third Party Fees"," AGG Third Party Paid"," INS Own Damage Estimate"," INS Own Damage Fees"," INS Own Damage Paid"," INS Third Party Estimate"," INS Third Party Fees"," INS Third Party Paid"," Gross"]
["ECONOMIC GROWTH",{"$nulls":3},7960,0,0,{"v":2515189,"d":"2,515,189"},0,{"v":10666011.45,"d":"10,666,011"},{"v":1426048.1000000003,"d":"1,426,048"},{"v":67966376.72999988,"d":"67,966,377"},{"v":90079.5,"d":"90,080"},{"v":304617.42999999993,"d":"304,617"},0,{"v":170012.36,"d":"170,012"},{"v":78861.77,"d":"78,862"},{"v":5311977.7299999995,"d":"5,311,978"},{"v":205000,"d":"205,000"},{"v":1527022.4000000004,"d":"1,527,022"},{"v":9827128.159999996,"d":"9,827,128"},{"v":112519927.68000038,"d":"112,519,928"}]
["GOVERNANCE",{"$nulls":3},508,0,0,{"v":5000,"d":"5,000"},0,{"v":905015.4,"d":"905,015"},{"v":263511.33999999997,"d":"263,511"},{"v":9014374.34,"d":"9,014,374"},0,{"v":121189.9,"d":"121,190"},0,0,{"v":5827.5,"d":"5,828"},{"v":289733.67000000004,"d":"289,734"},{"v":15480,"d":"15,480"},{"v":72166.18000000002,"d":"72,166"},{"v":578046.0199999999,"d":"578,046"},{"v":11844485.589999998,"d":"11,844,486"}]
["HUMAN & SOCIAL DEVELOPMENT",{"$nulls":3},10915,0,0,{"v":53503,"d":"53,503"},0,{"v":12589841.570000002,"d":"12,589,842"},{"v":3742258.9899999937,"d":"3,742,259"},{"v":173666398.06999984,"d":"173,666,398"},{"v":4277.35,"d":"4,277"},{"v":1063426.8999999997,"d":"1,063,427"},{"v":33082.77,"d":"33,083"},{"v":284769.74,"d":"284,770"},{"v":298878.5100000001,"d":"298,879"},{"v":16717242.599999994,"d":"16,717,243"},{"v":199293.1,"d":"199,293"},{"v":2487324.3100000005,"d":"2,487,324"},{"v":9646286.260000002,"d":"9,646,286"},{"v":232876054.5,"d":"232,876,055"}]
["TBA",{"$nulls":3},395,0,0,0,0,{"v":60000,"d":"60,000"},0,0,0,0,0,0,{"v":32740.09,"d":"32,740"},0,0,{"v":22957.26,"d":"22,957"},{"v":188756.87,"d":"188,757"},{"v":304454.22000000003,"d":"304,454"}]
["SUSTAINABLE SERVICES",{"$nulls":3},11355,0,0,{"v":49920,"d":"49,920"},0,{"v":14093035.670000004,"d":"14,093,036"},{"v":4211370.149999997,"d":"4,211,370"},{"v":169711399.0999999,"d":"169,711,399"},0,{"v":515749.58999999985,"d":"515,750"},{"v":28243.18,"d":"28,243"},{"v":221488.62,"d":"221,489"},{"v":765224.56,"d":"765,225"},{"v":16739693.889999999,"d":"16,739,694"},{"v":269519.82,"d":"269,520"},{"v":1978026.720000001,"d":"1,978,027"},{"v":14004969.060000006,"d":"14,004,969"},{"v":235378056.29999983,"d":"235,378,056"}]
["Grand Total",{"$nulls":3},31133,0,0,{"v":2623612,"d":"2,623,612"},0,{"v":38313904.09,"d":"38,313,904"},{"v":9643188.57999999,"d":"9,643,189"},{"v":420358548.23999965,"d":"420,358,548"},{"v":94356.85,"d":"94,357"},{"v":2004983.8199999994,"d":"2,004,984"},{"v":61325.95,"d":"61,326"},{"v":676270.72,"d":"676,271"},{"v":1181532.4300000002,"d":"1,181,532"},{"v":39058647.88999999,"d":"39,058,648"},{"v":689292.9199999999,"d":"689,293"},{"v":6087496.870000001,"d":"6,087,497"},{"v":34245186.370000005,"d":"34,245,186"},{"v":592922978.2900002,"d":"592,922,978"}]

{"sheet":"By Cluster","index":3,"n_rows":11,"n_cols":22,"rows_kept":11}
["CITY OF JOHANNESBURG CLUSTER CLAIMS REPORT"]
[]
["Insured Year","(All)","Select from drop down list to change the year or select multiple years"]
[]
["Cluster","Business Unit","Operational_Area","Policy Type Description","Sum of Counts"," Own Damage Excess Estimate"," Third Party Excess Estimate"," Own Damage Exess Paid"," Third Party Excess Paid"," AGG Own Damage Estimate"," AGG Own Damage Fees"," AGG Own Damage Paid"," AGG Third Party Estimate"," AGG Third Party Fees"," AGG Third Party Paid"," INS Own Damage Estimate"," INS Own Damage Fees"," INS Own Damage Paid"," INS Third Party Estimate"," INS Third Party Fees"," INS Third Party Paid"," Gross"]
["ECONOMIC GROWTH",{"$nulls":3},7960,0,0,{"v":2515189,"d":"2,515,189"},0,{"v":10666011.45,"d":"10,666,011"},{"v":1426048.1000000003,"d":"1,426,048"},{"v":67966376.72999988,"d":"67,966,377"},{"v":90079.5,"d":"90,080"},{"v":304617.42999999993,"d":"304,617"},0,{"v":170012.36,"d":"170,012"},{"v":78861.77,"d":"78,862"},{"v":5311977.7299999995,"d":"5,311,978"},{"v":205000,"d":"205,000"},{"v":1527022.4000000004,"d":"1,527,022"},{"v":9827128.159999996,"d":"9,827,128"},{"v":112519927.68000038,"d":"112,519,928"}]
["GOVERNANCE",{"$nulls":3},508,0,0,{"v":5000,"d":"5,000"},0,{"v":905015.4,"d":"905,015"},{"v":263511.33999999997,"d":"263,511"},{"v":9014374.34,"d":"9,014,374"},0,{"v":121189.9,"d":"121,190"},0,0,{"v":5827.5,"d":"5,828"},{"v":289733.67000000004,"d":"289,734"},{"v":15480,"d":"15,480"},{"v":72166.18000000002,"d":"72,166"},{"v":578046.0199999999,"d":"578,046"},{"v":11844485.589999998,"d":"11,844,486"}]
["HUMAN & SOCIAL DEVELOPMENT",{"$nulls":3},10915,0,0,{"v":53503,"d":"53,503"},0,{"v":12589841.570000002,"d":"12,589,842"},{"v":3742258.9899999937,"d":"3,742,259"},{"v":173666398.06999984,"d":"173,666,398"},{"v":4277.35,"d":"4,277"},{"v":1063426.8999999997,"d":"1,063,427"},{"v":33082.77,"d":"33,083"},{"v":284769.74,"d":"284,770"},{"v":298878.5100000001,"d":"298,879"},{"v":16717242.599999994,"d":"16,717,243"},{"v":199293.1,"d":"199,293"},{"v":2487324.3100000005,"d":"2,487,324"},{"v":9646286.260000002,"d":"9,646,286"},{"v":232876054.5,"d":"232,876,055"}]
["TBA",{"$nulls":3},395,0,0,0,0,{"v":60000,"d":"60,000"},0,0,0,0,0,0,{"v":32740.09,"d":"32,740"},0,0,{"v":22957.26,"d":"22,957"},{"v":188756.87,"d":"188,757"},{"v":304454.22000000003,"d":"304,454"}]
["SUSTAINABLE SERVICES",{"$nulls":3},11355,0,0,{"v":49920,"d":"49,920"},0,{"v":14093035.670000004,"d":"14,093,036"},{"v":4211370.149999997,"d":"4,211,370"},{"v":169711399.0999999,"d":"169,711,399"},0,{"v":515749.58999999985,"d":"515,750"},{"v":28243.18,"d":"28,243"},{"v":221488.62,"d":"221,489"},{"v":765224.56,"d":"765,225"},{"v":16739693.889999999,"d":"16,739,694"},{"v":269519.82,"d":"269,520"},{"v":1978026.720000001,"d":"1,978,027"},{"v":14004969.060000006,"d":"14,004,969"},{"v":235378056.29999983,"d":"235,378,056"}]
["Grand Total",{"$nulls":3},31133,0,0,{"v":2623612,"d":"2,623,612"},0,{"v":38313904.09,"d":"38,313,904"},{"v":9643188.57999999,"d":"9,643,189"},{"v":420358548.23999965,"d":"420,358,548"},{"v":94356.85,"d":"94,357"},{"v":2004983.8199999994,"d":"2,004,984"},{"v":61325.95,"d":"61,326"},{"v":676270.72,"d":"676,271"},{"v":1181532.4300000002,"d":"1,181,532"},{"v":39058647.88999999,"d":"39,058,648"},{"v":689292.9199999999,"d":"689,293"},{"v":6087496.870000001,"d":"6,087,497"},{"v":34245186.370000005,"d":"34,245,186"},{"v":592922978.2900002,"d":"592,922,978"}]

{"sheet":"By Department","index":4,"n_rows":31,"n_cols":21,"rows_kept":31}
["CITY OF JOHANNESBURG CLUSTER CLAIMS REPORT"]
[]
["Insured Year","(All)","Select from drop down list to change the year or select multiple years"]
[]
["Business Unit","Operational_Area","Policy Type Description","Sum of Counts"," Own Damage Excess Estimate"," Third Party Excess Estimate"," Own Damage Exess Paid"," Third Party Excess Paid"," AGG Own Damage Estimate"," AGG Own Damage Fees"," AGG Own Damage Paid"," AGG Third Party Estimate"," AGG Third Party Fees"," AGG Third Party Paid"," INS Own Damage Estimate"," INS Own Damage Fees"," INS Own Damage Paid"," INS Third Party Estimate"," INS Third Party Fees"," INS Third Party Paid"," Gross"]
["PUBLIC SAFETY",null,null,7940,0,0,{"v":48386,"d":"48,386"},0,{"v":7929412.870000001,"d":"7,929,413"},{"v":2885410.5099999947,"d":"2,885,411"},{"v":147121242.22999996,"d":"147,121,242"},{"v":4277.35,"d":"4,277"},{"v":915486.05,"d":"915,486"},{"v":33082.77,"d":"33,083"},{"v":44222.24,"d":"44,222"},{"v":220242.91000000003,"d":"220,243"},{"v":14991253.079999994,"d":"14,991,253"},{"v":60573.11,"d":"60,573"},{"v":1926563.0000000005,"d":"1,926,563"},{"v":7122656.539999999,"d":"7,122,657"},{"v":192783479,"d":"192,783,479"}]
["TO BE ADVISED",null,null,395,0,0,0,0,{"v":60000,"d":"60,000"},0,0,0,0,0,0,{"v":32740.09,"d":"32,740"},0,0,{"v":22957.26,"d":"22,957"},{"v":188756.87,"d":"188,757"},{"v":304454.22000000003,"d":"304,454"}]
["CORE ADMINISTRATION DEPARTMENTS & REGION",null,null,262,0,0,0,0,{"v":880015.4,"d":"880,015"},{"v":212258.24,"d":"212,258"},{"v":6048380.500000001,"d":"6,048,381"},0,{"v":103879.95,"d":"103,880"},0,0,{"v":3080,"d":"3,080"},{"v":217897.51,"d":"217,898"},{"v":15480,"d":"15,480"},{"v":57483.12,"d":"57,483"},{"v":377106.14999999997,"d":"377,106"},{"v":8040276.36,"d":"8,040,276"}]
["CITY PARKS & ZOO",null,null,2581,0,0,117,0,{"v":3775972.540000001,"d":"3,775,973"},{"v":707765.8200000002,"d":"707,766"},{"v":21792752.71999999,"d":"21,792,753"},0,{"v":89508.21,"d":"89,508"},0,{"v":6500,"d":"6,500"},{"v":73935.59999999999,"d":"73,936"},{"v":1623795.26,"d":"1,623,795"},{"v":111759.99,"d":"111,760"},{"v":476348.4599999999,"d":"476,348"},{"v":2222810.99,"d":"2,222,811"},{"v":33054983.609999977,"d":"33,054,984"}]
["PIKITUP",null,null,3358,0,0,{"v":28442,"d":"28,442"},0,{"v":1439407.97,"d":"1,439,408"},{"v":1463114.479999999,"d":"1,463,114"},{"v":59649909.83999997,"d":"59,649,910"},0,{"v":129946.01,"d":"129,946"},{"v":28243.18,"d":"28,243"},{"v":11735,"d":"11,735"},{"v":296190.18,"d":"296,190"},{"v":4703648.53,"d":"4,703,649"},{"v":54273.06,"d":"54,273"},{"v":995901.75,"d":"995,902"},{"v":9025355.62,"d":"9,025,356"},{"v":81688038.27000004,"d":"81,688,038"}]
["METROBUS",null,null,5330,0,0,{"v":2488781,"d":"2,488,781"},0,{"v":6984490.340000001,"d":"6,984,490"},{"v":252058.71999999997,"d":"252,059"},{"v":16597004.51999996,"d":"16,597,005"},{"v":90079.5,"d":"90,080"},{"v":159655.38,"d":"159,655"},0,{"v":163500,"d":"163,500"},{"v":46935.68,"d":"46,936"},{"v":3140358.94,"d":"3,140,359"},{"v":160000,"d":"160,000"},{"v":1009785.34,"d":"1,009,785"},{"v":7258559.91,"d":"7,258,560"},{"v":46893262.27999985,"d":"46,893,262"}]
["GROUP CORPORATE & SHARED SERVICES",null,null,91,0,0,{"v":5000,"d":"5,000"},0,{"v":25000,"d":"25,000"},{"v":22623.500000000004,"d":"22,624"},{"v":1615345.3999999994,"d":"1,615,345"},0,{"v":1179.2,"d":"1,179"},0,0,800,{"v":12375,"d":"12,375"},0,{"v":8808.71,"d":"8,809"},{"v":82890.46,"d":"82,890"},{"v":1899421.17,"d":"1,899,421"}]
["COMMUNITY DEVELOPMENT",null,null,166,0,0,0,0,{"v":25000,"d":"25,000"},{"v":63451.45,"d":"63,451"},{"v":1969605.0399999993,"d":"1,969,605"},0,{"v":47107.06,"d":"47,107"},0,0,{"v":2300,"d":"2,300"},0,{"v":11960,"d":"11,960"},{"v":49788.69,"d":"49,789"},{"v":39777.69,"d":"39,778"},{"v":2404570.2399999984,"d":"2,404,570"}]
["JOBURG WATER",null,null,5218,0,0,{"v":8198,"d":"8,198"},0,{"v":8740568.720000003,"d":"8,740,569"},{"v":1916449.2000000004,"d":"1,916,449"},{"v":75419564.6099999,"d":"75,419,565"},0,{"v":281424.87,"d":"281,425"},0,{"v":53457.619999999995,"d":"53,458"},{"v":346139.92999999993,"d":"346,140"},{"v":9374698.18,"d":"9,374,698"},{"v":95000,"d":"95,000"},{"v":646476.67,"d":"646,477"},{"v":2625481.17,"d":"2,625,481"},{"v":105939340.70000012,"d":"105,939,341"}]
["CITY POWER",null,null,2713,0,0,{"v":8280,"d":"8,280"},0,{"v":3797170.95,"d":"3,797,171"},{"v":802451.4700000002,"d":"802,451"},{"v":33691882.83,"d":"33,691,883"},0,{"v":91961.06999999999,"d":"91,961"},0,{"v":156296,"d":"156,296"},{"v":122094.45,"d":"122,094"},{"v":2590703.1799999992,"d":"2,590,703"},{"v":120246.76,"d":"120,247"},{"v":324093.04999999993,"d":"324,093"},{"v":2099885.7600000002,"d":"2,099,886"},{"v":46243540.849999994,"d":"46,243,541"}]
["JOHANNESBURG ROAD AGENCY",null,null,2145,0,0,{"v":11408,"d":"11,408"},0,{"v":3023663.9399999995,"d":"3,023,664"},{"v":946057.7100000003,"d":"946,058"},{"v":43483833.02999999,"d":"43,483,833"},0,{"v":94468.29000000001,"d":"94,468"},0,0,{"v":27555.34,"d":"27,555"},{"v":2029911.1700000002,"d":"2,029,911"},{"v":45000,"d":"45,000"},{"v":485249.63999999996,"d":"485,250"},{"v":2270583.6799999997,"d":"2,270,584"},{"v":55858054.479999974,"d":"55,858,054"}]
["GROUP FINANCE",null,null,61,0,0,0,0,0,{"v":11829.2,"d":"11,829"},{"v":458440.88,"d":"458,441"},0,{"v":5031.0599999999995,"d":"5,031"},0,0,{"v":1947.5,"d":"1,948"},{"v":51117.299999999996,"d":"51,117"},0,{"v":1168.5,"d":"1,169"},{"v":7193.4,"d":"7,193"},{"v":660239.5599999999,"d":"660,240"}]
["JOHANNESBURG SOCIAL HOUSING CO",null,null,5,0,0,0,0,{"v":90888.03,"d":"90,888"},{"v":11960,"d":"11,960"},{"v":119655,"d":"119,655"},0,0,0,0,0,0,0,0,0,{"v":222503.03,"d":"222,503"}]
["JOBURG PROPERTY COMPANY",null,null,384,0,0,{"v":15000,"d":"15,000"},0,{"v":593910.54,"d":"593,911"},{"v":152505.45,"d":"152,505"},{"v":6426511.209999998,"d":"6,426,511"},0,{"v":26837.14,"d":"26,837"},0,{"v":6512.36,"d":"6,512"},{"v":4370.75,"d":"4,371"},{"v":141187.24,"d":"141,187"},0,{"v":28181.89,"d":"28,182"},{"v":277379.57,"d":"277,380"},{"v":7983762.8599999985,"d":"7,983,763"}]
["TRANSPORTATION DEPT",null,null,27,0,0,0,0,0,{"v":10322,"d":"10,322"},{"v":267134.38,"d":"267,134"},0,0,0,0,0,0,0,0,0,{"v":332740.03,"d":"332,740"}]
["JOBURG MARKET",null,null,54,0,0,0,0,{"v":63946.63,"d":"63,947"},{"v":62302.72,"d":"62,303"},{"v":1036128.48,"d":"1,036,128"},0,{"v":23656.62,"d":"23,657"},0,0,0,0,0,{"v":3805.53,"d":"3,806"},{"v":20605,"d":"20,605"},{"v":1249344.9799999997,"d":"1,249,345"}]
["HOUSING",null,null,49,0,0,{"v":5000,"d":"5,000"},0,{"v":25000,"d":"25,000"},{"v":14032,"d":"14,032"},{"v":696713.82,"d":"696,714"},0,{"v":4055.95,"d":"4,056"},0,0,800,{"v":70644,"d":"70,644"},0,{"v":11555.25,"d":"11,555"},{"v":254246.51,"d":"254,247"},{"v":1129177.54,"d":"1,129,178"}]
["HEALTH DEPARTMENT",null,null,186,0,0,{"v":5000,"d":"5,000"},0,{"v":809456.16,"d":"809,456"},{"v":58717.759999999995,"d":"58,718"},{"v":2007025.8399999996,"d":"2,007,026"},0,{"v":10726.08,"d":"10,726"},0,{"v":234047.5,"d":"234,048"},{"v":1600,"d":"1,600"},{"v":31060.75,"d":"31,061"},0,{"v":25464.88,"d":"25,465"},{"v":201539.33000000002,"d":"201,539"},{"v":3561071.83,"d":"3,561,072"}]
["ECONOMIC DEVELOPMENT",null,null,8,0,0,0,0,0,{"v":1824,"d":"1,824"},{"v":90148.68,"d":"90,149"},0,0,0,0,0,{"v":520.38,"d":"520"},0,0,0,{"v":92493.06,"d":"92,493"}]
["OFFICE OF THE CITY MANAGER",null,null,94,0,0,0,0,0,{"v":16800.4,"d":"16,800"},{"v":892207.5600000003,"d":"892,208"},0,{"v":11099.69,"d":"11,100"},0,0,0,{"v":8343.86,"d":"8,344"},0,{"v":4705.85,"d":"4,706"},{"v":110856.01,"d":"110,856"},{"v":1244548.5,"d":"1,244,549"}]
["DEVELOPMENT PLANNING",null,null,11,0,0,0,0,0,{"v":977.5,"d":"978"},{"v":55411.43,"d":"55,411"},0,0,0,0,0,0,0,0,0,{"v":100064.99,"d":"100,065"}]
["JOBURG DEVELOPMENT AGENCY",null,null,1,0,0,0,0,0,0,{"v":10205,"d":"10,205"},0,0,0,0,0,0,0,0,0,{"v":10205,"d":"10,205"}]
["JOBURG THEATRES",null,null,15,0,0,0,0,{"v":25000,"d":"25,000"},{"v":21084.25,"d":"21,084"},{"v":545717.12,"d":"545,717"},0,0,0,0,0,0,{"v":15000,"d":"15,000"},{"v":8062.17,"d":"8,062"},{"v":59501.71,"d":"59,502"},{"v":674365.25,"d":"674,365"}]
["SOCIAL DEVELOPMENT",null,null,27,0,0,0,0,{"v":25000,"d":"25,000"},{"v":5829.2,"d":"5,829"},{"v":230055.12,"d":"230,055"},0,{"v":599.5,"d":"600"},0,0,800,{"v":71133.51,"d":"71,134"},0,{"v":1097.11,"d":"1,097"},0,{"v":397584.56999999995,"d":"397,585"}]
["ENVIRONMENT & INFRAS SERV DEPT",null,null,12,0,0,0,0,0,{"v":3363,"d":"3,363"},{"v":133673,"d":"133,673"},0,{"v":8361.69,"d":"8,362"},0,0,0,0,0,0,0,{"v":155455.90999999997,"d":"155,456"}]
["Grand Total",null,null,31133,0,0,{"v":2623612,"d":"2,623,612"},0,{"v":38313904.09,"d":"38,313,904"},{"v":9643188.579999993,"d":"9,643,189"},{"v":420358548.2399997,"d":"420,358,548"},{"v":94356.85,"d":"94,357"},{"v":2004983.82,"d":"2,004,984"},{"v":61325.95,"d":"61,326"},{"v":676270.72,"d":"676,271"},{"v":1181532.4300000002,"d":"1,181,532"},{"v":39058647.89,"d":"39,058,648"},{"v":689292.92,"d":"689,293"},{"v":6087496.87,"d":"6,087,497"},{"v":34245186.37,"d":"34,245,186"},{"v":592922978.29,"d":"592,922,978"}]

{"sheet":"By Policy","index":5,"n_rows":10,"n_cols":22,"rows_kept":10}
["CITY OF JOHANNESBURG CLUSTER CLAIMS REPORT"]
[]
["Insured Year","(All)","Select from drop down list to change the year or select multiple years"]
[]
["Policy Type Description","Cluster","Business Unit","Operational_Area","Sum of Counts"," Own Damage Excess Estimate"," Third Party Excess Estimate"," Own Damage Exess Paid"," Third Party Excess Paid"," AGG Own Damage Estimate"," AGG Own Damage Fees"," AGG Own Damage Paid"," AGG Third Party Estimate"," AGG Third Party Fees"," AGG Third Party Paid"," INS Own Damage Estimate"," INS Own Damage Fees"," INS Own Damage Paid"," INS Third Party Estimate"," INS Third Party Fees"," INS Third Party Paid"," Gross"]
["Motor - Fleet",{"$nulls":3},25498,0,0,{"v":134831,"d":"134,831"},0,{"v":30719879.94999999,"d":"30,719,880"},{"v":9214560.390000049,"d":"9,214,560"},{"v":399475287.73000044,"d":"399,475,288"},0,{"v":1751041.4700000004,"d":"1,751,041"},{"v":61325.95,"d":"61,326"},{"v":463662.05,"d":"463,662"},{"v":1102216.5500000005,"d":"1,102,217"},{"v":33463840.73,"d":"33,463,841"},{"v":533570.27,"d":"533,570"},{"v":5017833.630000007,"d":"5,017,834"},{"v":26026078.31000002,"d":"26,026,078"},{"v":536931194.2199994,"d":"536,931,194"}]
["Motor - Red Fleet",{"$nulls":3},177,0,0,0,0,{"v":408474.27,"d":"408,474"},{"v":170106.97,"d":"170,107"},{"v":4214551.989999999,"d":"4,214,552"},{"v":4277.35,"d":"4,277"},{"v":94286.96999999999,"d":"94,287"},0,0,{"v":2000,"d":"2,000"},0,{"v":-4277.35,"d":"(4,277)"},{"v":59877.9,"d":"59,878"},{"v":960548.1499999999,"d":"960,548"},{"v":6258031.760000001,"d":"6,258,032"}]
["Motor - Metrobus",{"$nulls":3},5320,0,0,{"v":2488781,"d":"2,488,781"},0,{"v":6959490.340000001,"d":"6,959,490"},{"v":252058.71999999997,"d":"252,059"},{"v":16597004.51999996,"d":"16,597,005"},{"v":90079.5,"d":"90,080"},{"v":159655.38,"d":"159,655"},0,{"v":163500,"d":"163,500"},{"v":46935.68,"d":"46,936"},{"v":2734374.06,"d":"2,734,374"},{"v":160000,"d":"160,000"},{"v":1009785.34,"d":"1,009,785"},{"v":7258559.91,"d":"7,258,560"},{"v":46462277.39999986,"d":"46,462,277"}]
["Motor - Fleet (Sasria)",{"$nulls":3},138,0,0,0,0,{"v":226059.53,"d":"226,060"},{"v":6462.5,"d":"6,463"},{"v":71704,"d":"71,704"},0,0,0,{"v":49108.67,"d":"49,109"},{"v":30380.2,"d":"30,380"},{"v":2860433.099999999,"d":"2,860,433"},0,0,0,{"v":3271474.9099999988,"d":"3,271,475"}]
["Grand Total",{"$nulls":3},31133,0,0,{"v":2623612,"d":"2,623,612"},0,{"v":38313904.089999996,"d":"38,313,904"},{"v":9643188.58000005,"d":"9,643,189"},{"v":420358548.2400004,"d":"420,358,548"},{"v":94356.85,"d":"94,357"},{"v":2004983.8200000003,"d":"2,004,984"},{"v":61325.95,"d":"61,326"},{"v":676270.7200000001,"d":"676,271"},{"v":1181532.4300000004,"d":"1,181,532"},{"v":39058647.89,"d":"39,058,648"},{"v":689292.92,"d":"689,293"},{"v":6087496.870000008,"d":"6,087,497"},{"v":34245186.37000002,"d":"34,245,186"},{"v":592922978.2899992,"d":"592,922,978"}]

{"sheet":"Risk Analysis","index":6,"n_rows":40,"n_cols":22,"rows_kept":40}
["CITY OF JOHANNESBURG CLUSTER CLAIMS REPORT"]
["Insured Year","(All)","Select from drop down list to change the year or select multiple years"]
["Policy Type Description","(All)","Select from drop down list to change the Policy Type"]
[]
["Risk_Description","Cluster","Business Unit","Operational_Area","Sum of Counts"," Own Damage Excess Estimate"," Third Party Excess Estimate"," Own Damage Exess Paid"," Third Party Excess Paid"," AGG Own Damage Estimate"," AGG Own Damage Fees"," AGG Own Damage Paid"," AGG Third Party Estimate"," AGG Third Party Fees"," AGG Third Party Paid"," INS Own Damage Estimate"," INS Own Damage Fees"," INS Own Damage Paid"," INS Third Party Estimate"," INS Third Party Fees"," INS Third Party Paid"," Gross"]
["",{"$nulls":3},1138,0,0,0,0,{"v":6576950.919999998,"d":"6,576,951"},{"v":47868.25,"d":"47,868"},{"v":787297.96,"d":"787,298"},{"v":4277.35,"d":"4,277"},{"v":3951.0899999999997,"d":"3,951"},0,{"v":25000,"d":"25,000"},{"v":32740.09,"d":"32,740"},0,{"v":310752.65,"d":"310,753"},{"v":122412.11000000002,"d":"122,412"},{"v":968703.1499999998,"d":"968,703"},{"v":9056801.17,"d":"9,056,801"}]
["VEHICLE",{"$nulls":3},6624,0,0,0,0,{"v":12773203.67,"d":"12,773,204"},{"v":3493680.899999995,"d":"3,493,681"},{"v":155568852.81999993,"d":"155,568,853"},{"v":90079.5,"d":"90,080"},{"v":2000770.4799999995,"d":"2,000,770"},{"v":61325.95,"d":"61,326"},{"v":5750,"d":"5,750"},{"v":600041.11,"d":"600,041"},{"v":17140964.159999993,"d":"17,140,964"},{"v":378540.26999999996,"d":"378,540"},{"v":5950805.410000008,"d":"5,950,805"},{"v":33111402.510000017,"d":"33,111,403"},{"v":241279199.46999958,"d":"241,279,199"}]
["VEHICLE / CHAIN COLLISION",{"$nulls":3},2,0,0,{"v":10000,"d":"10,000"},0,0,0,{"v":128120,"d":"128,120"},0,0,0,0,0,0,0,0,0,{"v":138120,"d":"138,120"}]
["VEHICLE / COLLISION",{"$nulls":3},14165,0,0,{"v":53125,"d":"53,125"},0,{"v":12967315.239999998,"d":"12,967,315"},{"v":4940824.629999993,"d":"4,940,825"},{"v":189056213.2099999,"d":"189,056,213"},0,80,0,{"v":431286.12,"d":"431,286"},{"v":425771.26,"d":"425,771"},{"v":14080705.399999999,"d":"14,080,705"},0,{"v":5404.1900000000005,"d":"5,404"},{"v":84823.16,"d":"84,823"},{"v":241886899.07000002,"d":"241,886,899"}]
["VEHICLE / COLLISION / INSURED REVERSING",{"$nulls":3},172,0,0,{"v":50459,"d":"50,459"},0,0,{"v":22431,"d":"22,431"},{"v":1115181,"d":"1,115,181"},0,0,0,0,0,0,0,0,700,{"v":1188771,"d":"1,188,771"}]
["VEHICLE / COLLISION / NO OTHER VEHICLE",{"$nulls":3},1028,0,0,{"v":132955,"d":"132,955"},0,0,{"v":312990.14,"d":"312,990"},{"v":18438479.240000002,"d":"18,438,479"},0,0,0,0,{"v":9703,"d":"9,703"},{"v":1404076.0900000003,"d":"1,404,076"},0,0,0,{"v":20450842.22,"d":"20,450,842"}]
["VEHICLE / COLLISION / NO TP / OVERTURNED",{"$nulls":3},3,0,0,0,0,0,{"v":1710,"d":"1,710"},{"v":269086,"d":"269,086"},0,0,0,0,0,0,0,0,0,{"v":270796,"d":"270,796"}]
["VEHICLE / COLLISION WITH ANIMAL",{"$nulls":3},16,0,0,0,0,0,{"v":6669,"d":"6,669"},{"v":203809,"d":"203,809"},0,0,0,0,0,0,0,0,0,{"v":210478,"d":"210,478"}]
["VEHICLE / COLLISION WITH PEDESTRIAN",{"$nulls":3},66,0,0,{"v":1582,"d":"1,582"},0,0,{"v":15620,"d":"15,620"},{"v":889963,"d":"889,963"},0,0,0,0,0,0,0,0,0,{"v":907165,"d":"907,165"}]
["VEHICLE / DAMAGED (NO COLLISION)",{"$nulls":3},543,0,0,0,0,{"v":25000,"d":"25,000"},{"v":329945.89,"d":"329,946"},{"v":17215791.27000001,"d":"17,215,791"},0,0,0,0,{"v":23872.52,"d":"23,873"},{"v":2030633.95,"d":"2,030,634"},0,0,0,{"v":20005844.720000017,"d":"20,005,845"}]
["VEHICLE / DAMAGED / STONED",{"$nulls":3},157,0,0,0,0,{"v":58836.39,"d":"58,836"},{"v":52109.4,"d":"52,109"},{"v":1730521.66,"d":"1,730,522"},0,0,0,0,{"v":1092.5,"d":"1,093"},{"v":3944.87,"d":"3,945"},0,0,0,{"v":1924111.64,"d":"1,924,112"}]
["VEHICLE / DAMAGED WHILST PARKED",{"$nulls":3},291,0,0,{"v":20071,"d":"20,071"},0,0,{"v":35238.5,"d":"35,239"},{"v":2347952.4400000004,"d":"2,347,952"},0,{"v":84.5,"d":"85"},0,0,{"v":35367,"d":"35,367"},{"v":72414,"d":"72,414"},0,{"v":5658.03,"d":"5,658"},{"v":19420.42,"d":"19,420"},{"v":2539135.8900000006,"d":"2,539,136"}]
["VEHICLE / FIRE",{"$nulls":3},17,0,0,0,0,{"v":590000,"d":"590,000"},{"v":61426.57,"d":"61,427"},{"v":526735.7,"d":"526,736"},0,0,0,{"v":160000,"d":"160,000"},{"v":2300,"d":"2,300"},{"v":2875.2,"d":"2,875"},0,0,0,{"v":1388337.47,"d":"1,388,337"}]
["VEHICLE / GLASS / HEADLIGHTS",{"$nulls":3},3768.5,0,0,{"v":2301,"d":"2,301"},0,{"v":4726132.34,"d":"4,726,132"},{"v":34548,"d":"34,548"},{"v":14549887.469999988,"d":"14,549,887"},0,{"v":97.75,"d":"98"},0,{"v":5125.929999999999,"d":"5,126"},{"v":442.75,"d":"443"},{"v":100403.13999999998,"d":"100,403"},0,{"v":3217.13,"d":"3,217"},{"v":60137.130000000005,"d":"60,137"},{"v":26238125.46999998,"d":"26,238,125"}]
["VEHICLE / HAIL DAMAGE",{"$nulls":3},15,0,0,0,0,0,{"v":8901,"d":"8,901"},{"v":441989,"d":"441,989"},0,0,0,0,0,0,0,0,0,{"v":450890,"d":"450,890"}]
["VEHICLE / INJURY (NO DAMAGE)",{"$nulls":3},6,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["VEHICLE / INJURY TO PASS (NO DAMAGE)",{"$nulls":3},22,0,0,{"v":10734,"d":"10,734"},0,0,0,0,0,0,0,0,0,0,0,0,0,{"v":10734,"d":"10,734"}]
["VEHICLE / INSURED HIT THIRD PARTY",{"$nulls":3},345,0,0,{"v":222366,"d":"222,366"},0,0,{"v":59575,"d":"59,575"},{"v":3366698,"d":"3,366,698"},0,0,0,0,0,0,0,0,0,{"v":3648639,"d":"3,648,639"}]
["VEHICLE / LOSS OF KEYS",{"$nulls":3},52,0,0,0,0,0,{"v":2832,"d":"2,832"},{"v":130247,"d":"130,247"},0,0,0,0,0,0,0,0,0,{"v":133079,"d":"133,079"}]
["VEHICLE / STOLEN AND RECOVERED",{"$nulls":3},3,0,0,0,0,0,855,{"v":155261.9,"d":"155,262"},0,0,0,0,0,0,0,0,0,{"v":156116.9,"d":"156,117"}]
["VEHICLE / STONED / SASRIA",{"$nulls":3},138,0,0,0,0,{"v":226059.53,"d":"226,060"},{"v":6462.5,"d":"6,463"},{"v":71704,"d":"71,704"},0,0,0,{"v":49108.67,"d":"49,109"},{"v":30380.2,"d":"30,380"},{"v":2860433.099999999,"d":"2,860,433"},0,0,0,{"v":3271474.9099999988,"d":"3,271,475"}]
["VEHICLE / STORM DAMAGE",{"$nulls":3},2,0,0,0,0,0,0,{"v":1648.58,"d":"1,649"},0,0,0,0,0,0,0,0,0,{"v":1648.58,"d":"1,649"}]
["VEHICLE / THEFT",{"$nulls":3},31,0,0,{"v":10000,"d":"10,000"},0,{"v":345406,"d":"345,406"},{"v":9299,"d":"9,299"},{"v":409609.18999999994,"d":"409,609"},0,0,0,0,{"v":3850,"d":"3,850"},{"v":565602.44,"d":"565,602"},0,0,0,{"v":1348766.63,"d":"1,348,767"}]
["VEHICLE / THEFT / ATTEMPT",{"$nulls":3},5,0,0,0,0,0,0,{"v":28122,"d":"28,122"},0,0,0,0,0,0,0,0,0,{"v":28122,"d":"28,122"}]
["VEHICLE / THEFT / BURNT",{"$nulls":3},5,0,0,0,0,0,{"v":1938,"d":"1,938"},{"v":160000,"d":"160,000"},0,0,0,0,0,0,0,0,0,{"v":161938,"d":"161,938"}]
["VEHICLE / THEFT OF ACCESSORIES",{"$nulls":3},204,0,0,{"v":13950,"d":"13,950"},0,{"v":25000,"d":"25,000"},{"v":10358.8,"d":"10,359"},{"v":476516.9,"d":"476,517"},0,0,0,0,0,{"v":1086,"d":"1,086"},0,0,0,{"v":553568.86,"d":"553,569"}]
["VEHICLE / THEFT OF COMPONENTS",{"$nulls":3},188,0,0,{"v":3591,"d":"3,591"},0,0,0,{"v":510773.25,"d":"510,773"},0,0,0,0,0,0,0,0,0,{"v":514364.25,"d":"514,364"}]
["VEHICLE / THEFT OF VEHICLE",{"$nulls":3},10,0,0,0,0,0,{"v":15879,"d":"15,879"},{"v":1690824.22,"d":"1,690,824"},0,0,0,0,{"v":7621,"d":"7,621"},{"v":781050.54,"d":"781,051"},0,0,0,{"v":2524885.1100000003,"d":"2,524,885"}]
["VEHICLE / TP HIT INSURED",{"$nulls":3},494,0,0,{"v":346603,"d":"346,603"},0,0,{"v":70782,"d":"70,782"},{"v":3814172,"d":"3,814,172"},0,0,0,0,0,0,0,0,0,{"v":4231557,"d":"4,231,557"}]
["VEHICLE / WINDSCREEN / GLASS",{"$nulls":3},1293.5,0,0,{"v":1678393,"d":"1,678,393"},0,0,{"v":7300,"d":"7,300"},{"v":3205823.4299999992,"d":"3,205,823"},0,0,0,0,{"v":8351,"d":"8,351"},{"v":14459,"d":"14,459"},0,0,0,{"v":5173872.929999999,"d":"5,173,873"}]
["VEHICLE / VEHICLE DAMAGED / NO COLLISION",{"$nulls":3},319,0,0,{"v":67482,"d":"67,482"},0,0,{"v":90524,"d":"90,524"},{"v":2759819,"d":"2,759,819"},0,0,0,0,0,0,0,0,0,{"v":2917825,"d":"2,917,825"}]
["VEHICLE / TP'S LOAD DAMAGED VEHICLE",{"$nulls":3},7,0,0,0,0,0,{"v":2565,"d":"2,565"},{"v":127893,"d":"127,893"},0,0,0,0,0,0,0,0,0,{"v":130458,"d":"130,458"}]
["VEHICLE / INJURY TO NON PASS (NO DAMAGE)",{"$nulls":3},2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
["VEHICLE / HIJACK AND RECOVERED",{"$nulls":3},1,0,0,0,0,0,855,{"v":179556,"d":"179,556"},0,0,0,0,0,0,0,0,0,{"v":180411,"d":"180,411"}]
["Grand Total",{"$nulls":3},31133,0,0,{"v":2623612,"d":"2,623,612"},0,{"v":38313904.089999996,"d":"38,313,904"},{"v":9643188.57999999,"d":"9,643,189"},{"v":420358548.23999983,"d":"420,358,548"},{"v":94356.85,"d":"94,357"},{"v":2004983.8199999996,"d":"2,004,984"},{"v":61325.95,"d":"61,326"},{"v":676270.7200000001,"d":"676,271"},{"v":1181532.43,"d":"1,181,532"},{"v":39058647.88999999,"d":"39,058,648"},{"v":689292.9199999999,"d":"689,293"},{"v":6087496.8700000085,"d":"6,087,497"},{"v":34245186.37000002,"d":"34,245,186"},{"v":592922978.2899996,"d":"592,922,978"}]