{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Introductie","Invoerblad","Journaalposten","Grootboek","Debiteuren","Eindbalans"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":2,"comments":3,"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":"Introductie","index":0,"n_rows":8,"n_cols":1,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["www.administratieexcellent.nl"]
["Welkom bij de test versie van de software van administratie excel-lent."]
["Deze versie is uitsluitend bedoeld als probeer versie, gebruik deze versie van de software niet voor het uitvoeren van de administratie."]
[]
["In deze versie is alleen de functie actief voor het inboeken van verkopen."]
["De overige functionaliteiten zijn eruit gehaald."]
[]
["Om deze software te gebruiken, dienen macro's te worden ingeschakeld."]

{"sheet":"Invoerblad","index":1,"n_rows":24,"n_cols":5,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["Verkoop factuur",null,null,0,5]
["Factuurdatum:",null,null,0.06,6]
["Boekingsnummer:","V1",null,0.19,7]
["Verkoopprijs (Incl.):",null,null,0.21,8]
["BTW percentage:",0.21,null,null,9]
["Betaling via bank of contant:","Bank",null,"Bank",10]
["Klantnaam:",null,null,"Contant",11]
["Beschrijving",null,null,"Op rekening",12]
[]
[]
[]
[]
[]
[]
[]
["Laatste verkoop factuur:"]
["Factuurdatum:",{"$f":"IF(INDIRECT(\"journaalposten!$A\"&3)=0,\"\",INDIRECT(\"journaalposten!$A\"&3))","v":""}]
["Boekingsnummer:",{"$f":"IF(INDIRECT(\"journaalposten!$G\" & 3)=0,\"\",INDIRECT(\"journaalposten!$G\" & 3))","v":""}]
["Verkoopprijs:",{"$f":"IF(INDIRECT(\"journaalposten!$H\" & 3)=0,\"\",INDIRECT(\"journaalposten!$H\" & 3))","v":""}]
["BTW bedrag:",{"$f":"IF(INDIRECT(\"journaalposten!$I\" & 5)=0,\"\",INDIRECT(\"journaalposten!$I\" & 5))","v":""}]
["Percentage:",{"$f":"IF(ISERROR(B20/(B19-B20))=TRUE,\"\",B20/(B19-B20))","v":""}]
["Naam klant:",{"$f":"IF(INDIRECT(\"journaalposten!$D\"&3)=0,\"\",INDIRECT(\"journaalposten!$D\"&3))","v":""}]
["Betaling bank of contant:",{"$f":"IF(INDIRECT(\"journaalposten!$C\"&3)=0,\"\",INDIRECT(\"journaalposten!$C\"&3))","v":""}]
["Beschrijving:",{"$f":"IF(INDIRECT(\"journaalposten!$E\"&3)=0,\"\",INDIRECT(\"journaalposten!$E\"&3))","v":""}]

{"sheet":"Journaalposten","index":2,"n_rows":2,"n_cols":9,"rows_kept":2,"cut":false,"hidden":false,"merged":[[0,0,0,8]]}
["Verkoop"]
["datum",null,"omschrijving","klant naam",null,null,"nr","debet","credit"]

{"sheet":"Grootboek","index":3,"n_rows":1,"n_cols":64,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["debet","Saldo:",{"$f":"SUM(F:F)","v":0},null,"180 Omzetbelasting (BTW)",null,null,null,null,"Saldo:",{"$f":"SUM(L:L)","v":0},"credit",null,"debet","Saldo:",{"$f":"SUM(S:S)","v":0},null,null,"100 Kas",null,null,null,"Saldo:",{"$f":"SUM(Y:Y)","v":0},"credit",null,"debet","Saldo:",{"$f":"SUM(AF:AF)","v":0},null,null,"101 Bank",null,null,null,"Saldo:",{"$f":"SUM(AL:AL)","v":0},"credit",null,"debet","Saldo:",{"$f":"SUM(AS:AS)","v":0},null,null,"840 omzet",null,null,null,"Saldo:",{"$f":"SUM(AY:AY)","v":0},"credit",null,"debet","Saldo:",{"$f":"SUM(BF:BF)","v":0},null,null,"120 Debiteuren",null,null,null,"Saldo:",{"$f":"SUM(BL:BL)","v":0},"credit"]

{"sheet":"Debiteuren","index":4,"n_rows":6,"n_cols":13,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
["Debiteurenoverzicht",null,null,null,null,null,null,null,null,"Ja","In de complete versie vindt u hier de optie om debiteuren te boeken"]
["Verkoop",null,null,null,null,null,null,null,null,"Nee"]
[null,null,null,null,null,"Totaal debiteuren:",{"$f":"SUM(F:F)","v":0},null,"Debiteuren boeken"]
["Klantnaam","Boekingsnummer","Datum","Factuurbedrag","Betaald","Openstaandbedrag","Hoe betaald",null,"Bedrag","Boeken?","Datum",null,"Beschrijving"]
[null,null,null,null,null,{"$f":"D5-E5","v":0},null,null,null,"Nee"]
[null,null,null,null,null,{"$f":"D6-E6","v":0},null,null,null,"Nee"]

{"sheet":"Eindbalans","index":5,"n_rows":25,"n_cols":11,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,0,0,7],[1,0,1,7]]}
["Eindbalans voor winst"]
["2016-12-31"]
["debet",null,null,null,"credit"]
["Kas",null,null,{"$f":"J18","v":0},"Omzetbelasting",null,null,{"$f":"K21","v":0}]
["Bank",null,null,{"$f":"J19","v":0},"Winst",null,null,{"$f":"K24","v":0}]
["Debiteuren",null,null,{"$f":"J20","v":0}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"  "]
["Totaal",null,null,{"$f":"SUM(D4:D8)","v":0},"Totaal",null,null,{"$f":"SUM(H4:H7)","v":0}]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null," "]
["Grootboekrekening",null,null,"proefbalans",null,"saldibalans",null,"winst en verliesrekening",null,"eindbalans "]
["nr","naam",null,"Debet","Credit","Debet","Credit","Debet","Credit","Debet","Credit"]
[100,"kas ",null,{"$f":"Grootboek!P1","v":0},{"$f":"Grootboek!X1","v":0},{"$f":"D18-E18","v":0},null,null,null,{"$f":"F18","v":0}]
[101,"Bank",null,{"$f":"Grootboek!AC1","v":0},{"$f":"Grootboek!AK1","v":0},{"$f":"D19-E19","v":0},null,null,null,{"$f":"F19","v":0}]
[120,"Debiteuren",null,{"$f":"Grootboek!BC1","v":0},{"$f":"Grootboek!BK1","v":0},{"$f":"D20-E20","v":0},null,null,null,{"$f":"F20","v":0}]
[180,"Omzetbelasting",null,{"$f":"Grootboek!C1","v":0},{"$f":"Grootboek!K1","v":0},null,{"$f":"E21-D21","v":0},null,null,null,{"$f":"G21","v":0}]
[840,"omzet",null,{"$f":"Grootboek!AP1","v":0},{"$f":"Grootboek!AX1","v":0},{"$f":"IF(D22>=E22,D22-E22,0)","v":0},{"$f":"IF(D22<E22,E22-D22,0)","v":0},{"$f":"F22","v":0},0]
["Subtotaal:",null,null,null,null,null,null,{"$f":"SUM(H18:H22)","v":0},{"$f":"SUM(I18:I22)","v":0},{"$f":"SUM(J18:J22)","v":0},{"$f":"SUM(K18:K22)","v":0}]
["Winst/Verlies",null,null,null,null,null,null,{"$f":"IF(H23<I23,I23-H23,0)","v":0},{"$f":"IF(H23>=I23,H23-I23,0)","v":0},null,{"$f":"IF(H24=0,-I24,H24)","v":0}]
["Saldo credit/debet:",null,null,{"$f":"SUM(D18:D24)","v":0},{"$f":"SUM(E18:E24)","v":0},{"$f":"SUM(F18:F24)","v":0},{"$f":"SUM(G18:G24)","v":0},{"$f":"SUM(H23:H24)","v":0},{"$f":"SUM(I23:I24)","v":0},{"$f":"SUM(J23:J24)","v":0},{"$f":"SUM(K23:K24)","v":0}]