{"text_format":"3","workbook":"xlsx","n_sheets":3,"sheets":["ADRS_COJ","General Info","Declaration Summary "],"not_rendered":{"images":3,"external_links":3,"defined_names":5},"read":"whole","date_system":"1900"}

{"sheet":"ADRS_COJ","index":0,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"General Info","index":1,"n_rows":26,"n_cols":10,"rows_kept":26,"merged":[[2,0,2,11],[4,2,4,11],[6,2,6,11],[8,2,8,11],[11,2,11,11],[14,2,14,11],[25,2,25,5],[26,2,26,5],[27,2,27,5],[28,2,28,5],[29,2,29,5],[30,2,30,5],[31,2,31,5],[32,2,32,5],[33,2,33,5],[34,2,34,5],[35,2,35,5],[36,2,36,5],[37,2,37,5],[38,2,38,5],[39,2,39,5],[40,2,40,5],[41,2,41,5],[42,2,42,5],[43,2,43,5],[44,2,44,5],[45,2,45,5],[46,2,46,5],[47,2,47,5],[48,2,48,5],[49,2,49,5],[50,2,50,5]]}
[]
[]
["GENERAL INFORMATION"]
[]
["Business Unit",":"]
[]
["VAT Registration Number",":"]
[]
["Company Registration Number",":"]
[]
[]
["Business Description",":"]
[]
[]
["MCC Business Description",":"]
[]
[]
[]
["Physical Address",":"]
[]
[]
[]
["Postal Address",":"]
[]
[]
["Additional Premises",":","Premises Name & Address",{"$nulls":3},"Rented YES/NO","Owned YES/NO","Rent Amount Paid","Rent Amount Recieved"]

{"sheet":"Declaration Summary ","index":2,"n_rows":18,"n_cols":8,"rows_kept":18,"merged":[[0,0,0,2]]}
["CoJ Summary of Declared Values 2023",null,null,"ANNEXURE A",{"$nulls":3},"HOLLARD NOTES"]
[null,"Operation/Entity","Declared (Yes/No)",null,"Declared Values - after depreciation","Total difference in Values","Comments","Values used for 2022/2023 Renewal"]
[1,"Joburg Roads Agency","Yes",{"v":472903464.93000287,"d":"472,903,464.93"},{"v":472903464.93000287,"d":"472,903,464.93"},null,null,{"$f":"E3","v":{"v":472903464.93000287,"d":"472,903,465"}}]
[2,"Joburg Fresh Market","Yes",{"v":328646170.8948454,"d":"328,646,170.89"},{"v":328646170.8948454,"d":"328,646,170.89"},null,null,{"$f":"E4","v":{"v":328646170.8948454,"d":"328,646,171"}}]
[3,"Joburg City Theatres","Yes",{"v":15071407.561542436,"d":"15,071,407.56"},{"v":15071407.561542436,"d":"15,071,407.56"},null,null,{"$f":"E5","v":{"v":15071407.561542436,"d":"15,071,408"}}]
[4,"City Power","Yes",{"v":53731018769.65641,"d":"53,731,018,769.66"},{"v":53731018769.65641,"d":"53,731,018,769.66"},null,null,{"v":53503322129.49641,"d":"53,503,322,129"}]
[5,"Economic Development","Partial",{"$nulls":4},{"v":55000000,"d":"55,000,000"}]
[6,"Joshco","No",{"v":3274538,"d":"3,274,538.00"},{"v":3274538,"d":"3,274,538.00"},null,"Awaiting asset register. Used 2020 values ",{"v":3962065621,"d":"3,962,065,621"}]
[7,"Joburg City Parks and Zoo","Yes",{"v":165606129.42569506,"d":"165,606,129.43"},{"v":165606129.42569506,"d":"165,606,129.43"},null,null,{"v":132586737.699409,"d":"132,586,738"}]
[8,"JDA","Yes",{"v":9690895.3,"d":"9,690,895.30"},{"v":9690895.3,"d":"9,690,895.30"},null,null,{"$f":"E10","v":{"v":9690895.3,"d":"9,690,895"}}]
[9,"Metrobus","No",{"v":65000000,"d":"65,000,000.00"},{"v":65000000,"d":"65,000,000.00"},null,"Awaiting asset register. Used 2020 values",{"$f":"E11","v":{"v":65000000,"d":"65,000,000"}}]
[10,"Metropolitan Trading Co","No",{"v":918055108,"d":"918,055,108.00"},{"v":918055108,"d":"918,055,108.00"},null,"Awaiting asset register. Used 2020 values",{"$f":"E12","v":{"v":918055108,"d":"918,055,108"}}]
[11,"Pikitup","Yes",{"v":1488739857.450048,"d":"1,488,739,857.45"},{"v":1488739857.450048,"d":"1,488,739,857.45"},null,null,{"v":642231730.9699999,"d":"642,231,731"}]
[12,"Joburg Property Co","Yes",{"v":229513870,"d":"229,513,870.00"},{"v":229513870,"d":"229,513,870.00"},null,"Incomplete. Excludes buildings - 16 013 117.70 - Used 2020 values ",{"v":1158852143,"d":"1,158,852,143"}]
[13,"Joburg Water","Yes",{"$f":"13247186769.3709+24006225323","v":{"v":37253412092.370895,"d":"37,253,412,092.37"}},{"$f":"13247186769.3709+ 24006225323","v":{"v":37253412092.370895,"d":"37,253,412,092.37"}},null,null,{"v":37253412092,"d":"37,253,412,092"}]
[null,"Total",null,{"$f":"SUM(D3:D15)","v":{"v":94680932303.58945,"d":"R94,680,932,304"}},{"$f":"SUM(E3:E15)","v":{"v":94680932303.58945,"d":"94,680,932,303.59"}},{"$f":"E16-D16","v":{"v":0,"d":"R0"}},"Total",{"$f":"SUM(H3:H15)","v":{"v":98516837500.8522,"d":"98,516,837,501"}}]
[null,"Group Asset Register ",null,null,{"v":45559555221.08884,"d":"45,559,555,221.09"},null,null,{"$f":"E17","v":{"v":45559555221.08884,"d":"45,559,555,221"}}]
[null,"Grand Total",null,null,{"$f":"SUM(E16:E17)","v":{"v":140240487524.67828,"d":"140,240,487,524.68"}},null,"Grand Total",{"$f":"SUM(H16:H17)","v":{"v":144076392721.94104,"d":"144,076,392,722"}}]