{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Start","Opzoek"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":8,"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":"Start","index":0,"n_rows":31,"n_cols":8,"rows_kept":31,"cut":false,"hidden":false,"merged":[[2,1,2,5],[5,1,11,5],[13,1,14,1]]}
[]
[]
[null,"Omzetten iv3 naar JSON                  versie.2023_1"]
[]
[]
[null,"Met dit hulpmiddel is het mogelijk om de iv3-levering van Gemeenten, Provincies en Gemeenschappelijke Regelingen om te zetten van Excel naar het JSON format.\nDeze versie is van Augustus 2023, bestanden voor het jaar 2023 en 2024 kunnen nu ook worden verwerkt.\nOp de CBS site zal telkens een nieuwe versie van dit hulpmiddel worden geplaatst indien er belangrijke wijzigingen zijn.\nEr kan geen enkele garantie worden gegeven voor de juiste werking van deze tool. Er kunnen ook geen rechten aan worden ontleend.\n\nTheo Grivel, Centraal Bureau voor de Statistiek, 22 augustus 2023"]
[]
[]
[]
[]
[]
[]
[]
[null,"kies een bestand met behulp van deze knop:"]
[]
[null,null,null,null,"bedragen keer 1000? ",null,null,"Ja"]
[null,"volledig pad en naam bronbestand"]
[]
[null,"Volledig pad en naam Exportbestand"]
[]
[null,"Extra informatie"]
[null,"details openbaar ja of nee",null,null,"Kies ja of nee"]
[null,"Welk pakket gebruikt u voor uw financiële administratie",null,null,"bijvoorbeeld Sap of Coda of Key2Financiën "]
[null,"export software (BI-software of gewoon het pakket)",null,null,"bijvoorbeeld Cognos of Coda o.i.d."]
[]
[]
[]
[]
[]
[]
[null,"voortgang… zie de balk"]

{"sheet":"Opzoek","index":1,"n_rows":51,"n_cols":34,"rows_kept":51,"cut":false,"hidden":true,"merged":[[21,13,21,22],[21,24,21,33],[0,4,0,5],[0,2,0,3],[0,6,0,7]]}
["vertalingen",2024,"Kengetallen Vertaling omschrijvingen --> codes",null,"verslagperiode Vertaling omschrijvingen --> codes",null,"beleidsindicatoren Vertaling omschrijvingen --> codes",null,null,null,null,null,null,"Keuzelijst voor start-blad"]
[null,null,"omschr","code","omschr","code","omschr","code",null,null,null,null,null,"Ja"]
[null,null,"Netto schuldquote","fk.1",{"$f":" \"Rekening \"& TEXT($B$1-3,\"@\")","v":"Rekening 2021"},{"$f":"LEFT(E3,3) & \"_\"& RIGHT(E3,4)","v":"Rek_2021"},"Formatie (Fte per 1.000 inwoners)","bi.1",null,null,null,null,null,"Nee"]
[null,null,"Netto schuldquote gecorrigeerd voor alle verstrekte leningen","fk.2",{"$f":" \"Begroting \"& TEXT($B$1-2,\"@\")","v":"Begroting 2022"},{"$f":"LEFT(E4,3) & \"_\"& RIGHT(E4,4)","v":"Beg_2022"},"Bezetting (Fte per 1.000 inwoners)","bi.2"]
[null,null,"Solvabiliteitsratio","fk.3",{"$f":" \"Rekening \"& TEXT($B$1-2,\"@\")","v":"Rekening 2022"},"Rek_2022","Apparaatskosten (kosten per inwoner)","bi.3"]
[null,null,"Structurele exploitatieruimte","fk.4",{"$f":" \"Begroting \"& TEXT($B$1-1,\"@\")","v":"Begroting 2023"},"Beg_2023","Externe inhuur (kosten inhuur externen als % van totale loonsom + totale kosten inhuur externen)","bi.4"]
[null,null,"Grondexploitatie","fk.5",{"$f":" \"Rekening \"& TEXT($B$1-1,\"@\")","v":"Rekening 2023"},"Rek_2023","Overhead (% van totale lasten)","bi.5"]
[null,null,"Belastingcapaciteit","fk.6",{"$f":" \"Begroting \"& TEXT($B$1,\"@\")","v":"Begroting 2024"},"Beg_2024"]
[null,null,null,null,{"$f":" \"Rekening \"& TEXT($B$1,\"@\")","v":"Rekening 2024"},"Rek_2024"]
[null,null,null,null,{"$f":" \"Meerjarenraming \"& TEXT($B$1,\"@\")","v":"Meerjarenraming 2024"},{"$f":"\"MJR_\" & RIGHT(E10,4)","v":"MJR_2024"}]
[null,null,null,null,{"$f":" \"Meerjarenraming \"& TEXT($B$1 + 1,\"@\")","v":"Meerjarenraming 2025"},{"$f":"\"MJR_\" & RIGHT(E11,4)","v":"MJR_2025"}]
[null,null,null,null,{"$f":" \"Meerjarenraming \"& TEXT($B$1 + 2,\"@\")","v":"Meerjarenraming 2026"},"MJR_2026"]
[null,null,null,null,{"$f":" \"Meerjarenraming \"& TEXT($B$1 + 3,\"@\")","v":"Meerjarenraming 2027"},"MJR_2027"]
[]
[]
["kolomnummer:"]
[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28]
["array_nummer:"]
[null,null,0,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31]
[]
[]
["Jaren",null,2022,null,null,null,null,null,null,null,null,null,null,2023,null,null,null,null,null,null,null,null,null,null,2024]
[]
[null,null,"TabNaam","Rijnr kop codes","Rijnr kop omschr","kol kop codes","kol kop omschr","regelVA","regelTM","kolomVA","kolomTM",null,null,"TabNaam","Rijnr kop codes","Rijnr kop omschr","kol kop codes","kol kop omschr","regelVA","regelTM","kolomVA","kolomTM",null,null,"TabNaam","Rijnr kop codes","Rijnr kop omschr","kol kop codes","kol kop omschr","regelVA","regelTM","kolomVA","kolomTM"]
["Provincie","lasten","5.Verdelingsmatrix lasten",1,2,1,2,5,77,3,37,null,null,"5.Verdelingsmatrix lasten",1,2,1,2,5,77,3,37,null,null,"5.Verdelingsmatrix lasten",1,2,1,2,5,77,3,37]
[null,"baten","6.Verdelingsmatrix baten",1,2,1,2,5,77,3,39,null,null,"6.Verdelingsmatrix baten",1,2,1,2,5,77,3,39,null,null,"6.Verdelingsmatrix baten",1,2,1,2,5,77,3,39]
[null,"balans_lasten","5.Verdelingsmatrix lasten",1,2,1,2,85,155,3,37,null,null,"5.Verdelingsmatrix lasten",1,2,1,2,85,155,3,37,null,null,"5.Verdelingsmatrix lasten",1,2,1,2,85,155,3,37]
[null,"balans_baten","6.Verdelingsmatrix baten",1,2,1,2,85,155,3,39,null,null,"6.Verdelingsmatrix baten",1,2,1,2,85,155,3,39,null,null,"6.Verdelingsmatrix baten",1,2,1,2,85,155,3,39]
[null,"balans_standen","7.Balansstanden",3,3,4,2,7,84,6,8,null,null,"7.Balansstanden",3,3,4,2,7,84,6,8,null,null,"7.Balansstanden",3,3,4,2,7,84,6,8]
[null,"Kengetallen","11.Financiële kengetallen",0,0,0,0,0,0,0,0,null,null,"11.Financiële kengetallen",0,0,0,0,0,0,0,0,null,null,"11.Financiële kengetallen",0,0,0,0,0,0,0,0]
[null,"Beleidsindicatoren","12.Beleidsindicatoren",0,0,0,0,0,0,0,0,null,null,"12.Beleidsindicatoren",0,0,0,0,0,0,0,0,null,null,"12.Beleidsindicatoren",0,0,0,0,0,0,0,0]
[]
[]
[null,null,"TabNaam","Rijnr kop codes","Rijnr kop omschr","kol kop codes","kol kop omschr","regelVA","regelTM","kolomVA","kolomTM",null,null,"TabNaam","Rijnr kop codes","Rijnr kop omschr","kol kop codes","kol kop omschr","regelVA","regelTM","kolomVA","kolomTM",null,null,"TabNaam","Rijnr kop codes","Rijnr kop omschr","kol kop codes","kol kop omschr","regelVA","regelTM","kolomVA","kolomTM"]
["GR","lasten","5.Verdelingsmatrix lasten",1,2,1,2,5,81,3,37,null,null,"5.Verdelingsmatrix lasten",1,2,1,2,5,99,3,37,null,null,"5.Verdelingsmatrix lasten",1,2,1,2,5,99,3,37]
[null,"baten","6.Verdelingsmatrix baten",1,2,1,2,5,81,3,39,null,null,"6.Verdelingsmatrix baten",1,2,1,2,5,99,3,39,null,null,"6.Verdelingsmatrix baten",1,2,1,2,5,99,3,39]
[null,"balans_lasten","5.Verdelingsmatrix lasten",1,2,1,2,89,159,3,37,null,null,"5.Verdelingsmatrix lasten",1,2,1,2,107,177,3,37,null,null,"5.Verdelingsmatrix lasten",1,2,1,2,107,177,3,37]
[null,"balans_baten","6.Verdelingsmatrix baten",1,2,1,2,89,159,3,39,null,null,"6.Verdelingsmatrix baten",1,2,1,2,107,177,3,39,null,null,"6.Verdelingsmatrix baten",1,2,1,2,107,177,3,39]
[null,"balans_standen","7.Balansstanden",3,3,4,2,7,84,6,8,null,null,"7.Balansstanden",3,3,4,2,7,84,6,8,null,null,"7.Balansstanden",3,3,4,2,7,84,6,8]
[null,"Kengetallen","11.Financiële kengetallen",0,0,0,0,0,0,0,0,null,null,"11.Financiële kengetallen",0,0,0,0,0,0,0,0,null,null,"11.Financiële kengetallen",0,0,0,0,0,0,0,0]
[null,"Beleidsindicatoren","12.Beleidsindicatoren",0,0,0,0,0,0,0,0,null,null,"12.Beleidsindicatoren",0,0,0,0,0,0,0,0,null,null,"12.Beleidsindicatoren",0,0,0,0,0,0,0,0]
[]
[]
[null,null,"TabNaam","Rijnr kop codes","Rijnr kop omschr","kol kop codes","kol kop omschr","regelVA","regelTM","kolomVA","kolomTM",null,null,"TabNaam","Rijnr kop codes","Rijnr kop omschr","kol kop codes","kol kop omschr","regelVA","regelTM","kolomVA","kolomTM",null,null,"TabNaam","Rijnr kop codes","Rijnr kop omschr","kol kop codes","kol kop omschr","regelVA","regelTM","kolomVA","kolomTM"]
["Gemeente","lasten","5.Verdelingsmatrix lasten",1,2,1,2,5,81,3,37,null,null,"5.Verdelingsmatrix lasten",1,2,1,2,5,99,3,37,null,null,"5.Verdelingsmatrix lasten",1,2,1,2,5,99,3,37]
[null,"baten","6.Verdelingsmatrix baten",1,2,1,2,5,81,3,39,null,null,"6.Verdelingsmatrix baten",1,2,1,2,5,99,3,39,null,null,"6.Verdelingsmatrix baten",1,2,1,2,5,99,3,39]
[null,"balans_lasten","5.Verdelingsmatrix lasten",1,2,1,2,89,159,3,37,null,null,"5.Verdelingsmatrix lasten",1,2,1,2,107,177,3,37,null,null,"5.Verdelingsmatrix lasten",1,2,1,2,107,177,3,37]
[null,"balans_baten","6.Verdelingsmatrix baten",1,2,1,2,89,159,3,39,null,null,"6.Verdelingsmatrix baten",1,2,1,2,107,177,3,39,null,null,"6.Verdelingsmatrix baten",1,2,1,2,107,177,3,39]
[null,"balans_standen","7.Balansstanden",3,3,4,2,7,84,6,8,null,null,"7.Balansstanden",3,3,4,2,7,84,6,8,null,null,"7.Balansstanden",3,3,4,2,7,84,6,8]
[null,"Kengetallen","11.Financiële kengetallen",0,14,0,1,15,20,2,8,null,null,"11.Financiële kengetallen",0,14,0,1,15,20,2,9,null,null,"11.Financiële kengetallen",0,14,0,1,15,20,2,9]
[null,"Beleidsindicatoren","12.Beleidsindicatoren",0,15,0,1,16,20,2,8,null,null,"12.Beleidsindicatoren",0,15,0,1,16,20,2,9,null,null,"12.Beleidsindicatoren",0,15,0,1,16,20,2,9]