{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Rens recto","Rens verso"],"not_rendered":{"charts":0,"images":2,"macros":1,"external_links":0,"defined_names":2,"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":"Rens recto","index":0,"n_rows":58,"n_cols":38,"rows_kept":58,"cut":false,"hidden":false,"merged":[[50,35,50,36],[46,35,46,36],[49,26,49,28],[49,30,49,31],[49,32,49,33],[49,35,49,36],[46,32,46,33],[44,35,44,36],[45,30,45,31],[45,32,45,33],[45,35,45,36],[38,36,38,37],[43,30,43,31],[43,35,43,36],[43,32,43,33],[44,30,44,31],[36,36,36,37],[37,26,37,33],[37,36,37,37],[34,26,34,33],[34,36,34,37],[35,26,35,33],[35,36,35,37],[27,36,27,37],[28,36,28,37],[33,26,33,33],[33,36,33,37],[29,36,29,37],[26,36,26,37],[21,26,21,27],[21,30,21,31],[21,32,21,33],[21,36,21,37],[20,26,20,27],[20,30,20,31],[20,32,20,33],[20,36,20,37],[18,30,18,31],[18,32,18,33],[18,36,18,37],[17,26,17,27],[17,30,17,31],[17,32,17,33],[17,36,17,37],[22,30,22,31],[22,32,22,33],[22,36,22,37],[3,28,3,34],[14,26,14,27],[14,30,14,31],[14,32,14,33],[52,30,52,31],[52,32,52,33],[51,26,51,28],[51,35,51,36],[52,26,52,28],[52,35,52,36],[16,26,16,27],[16,30,16,31],[16,32,16,33],[16,36,16,37],[14,36,14,37],[15,26,15,27],[15,30,15,31],[15,32,15,33],[15,36,15,37],[19,26,19,27],[19,30,19,31],[19,32,19,33],[19,36,19,37],[18,26,18,27],[51,32,51,33],[44,32,44,33],[46,30,46,31],[46,10,46,11],[49,10,49,11],[50,10,50,11],[51,10,51,11],[49,1,49,3],[50,1,50,3],[51,1,51,3],[50,26,50,28],[50,30,50,31],[50,32,50,33],[38,11,38,12],[33,1,33,8],[34,1,34,8],[35,1,35,8],[36,1,36,8],[34,11,34,12],[52,10,52,11],[37,1,37,8],[51,30,51,31],[52,1,52,3],[52,5,52,6],[52,7,52,8],[36,26,36,33],[43,10,43,11],[44,10,44,11],[45,10,45,11],[51,5,51,6],[51,7,51,8],[45,5,45,6],[45,7,45,8],[46,5,46,6],[46,7,46,8],[49,5,49,6],[49,7,49,8],[50,5,50,6],[50,7,50,8],[43,5,43,6],[43,7,43,8],[44,5,44,6],[44,7,44,8],[35,11,35,12],[36,11,36,12],[37,11,37,12],[26,11,26,12],[27,11,27,12],[28,11,28,12],[33,11,33,12],[29,11,29,12],[20,7,20,8],[21,11,21,12],[22,7,22,8],[22,11,22,12],[21,7,21,8],[20,5,20,6],[17,7,17,8],[18,7,18,8],[19,7,19,8],[20,1,20,2],[21,1,21,2],[21,5,21,6],[22,5,22,6],[14,11,14,12],[15,11,15,12],[16,11,16,12],[17,11,17,12],[18,11,18,12],[19,11,19,12],[20,11,20,12],[17,1,17,2],[18,1,18,2],[19,1,19,2],[18,5,18,6],[15,7,15,8],[19,5,19,6],[17,5,17,6],[3,3,3,9],[14,1,14,2],[15,1,15,2],[16,1,16,2],[16,5,16,6],[16,7,16,8],[14,5,14,6],[14,7,14,8],[15,5,15,6]]}
[]
[null,null,"KANTON WALLIS",null,null,null,null,null,"STEUERPERIODE 2015",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C2","v":"KANTON WALLIS"},null,null,null,null,null,{"$f":"I2","v":"STEUERPERIODE 2015"}]
[]
[null,null,"Firma :",null,null,null,null,null,null,null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C4","v":"Firma :"},{"$f":"D4","v":0},null,null,null,null,null,null,null," "]
[]
[null,"A  -  ERGÄNZENDE AUSKÜNFTE BETREFFEND",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B6","v":"A  -  ERGÄNZENDE AUSKÜNFTE BETREFFEND"}]
[null,"DIE BUCHHALTUNG 2015",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B7","v":"DIE BUCHHALTUNG 2015"}]
[null,"(auszufüllen, sofern nicht detailliert und beiliegend in der Buchhaltung ersichtlich)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B8","v":"(auszufüllen, sofern nicht detailliert und beiliegend in der Buchhaltung ersichtlich)"}]
[]
["1.","Detail der Abschreibungen",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1.",{"$f":"B10","v":"Detail der Abschreibungen"}]
[null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null," ",null,"Buchwert","Zugänge","Buchwert",null,"Buchwert",null," "," ","Buchwert",null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,{"$f":"D12","v":"Buchwert"},"Zugänge","Buchwert",null,{"$f":"H12","v":"Buchwert"},null," "," ",{"$f":"L12","v":"Buchwert"}]
[null,"Vorgenommene Abschreibungen auf",null,"zu Beginn des","Aufwertungen","der Verkäufe",null,"vor",null,"%","Abschreibungen","am Ende des",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B13","v":"Vorgenommene Abschreibungen auf"},null,"zu Beginn des","Aufwertungen","der Verkäufe",null,{"$f":"H13","v":"vor"},null,"%",{"$f":"K13","v":"Abschreibungen"},{"$f":"L13","v":"am Ende des"}]
[null,null,null,"Geschäftsjahres",null,"Abgänge",null,"Abschreibungen",null,null,null,"Geschäftsjahres",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D14","v":"Geschäftsjahres"},null,{"$f":"H14","v":"Abschreibungen"},null,{"$f":"H14","v":"Abschreibungen"},null,null,null,{"$f":"L14","v":"Geschäftsjahres"}]
[null,null,null,null,null,null,null,{"$f":"IF((D15+E15-F15)>=0,D15+E15-F15,\" \")","v":0},null,null,null,{"$f":"H15-K15","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B15","v":0},null,{"$f":"D15","v":0},0,0,null,{"$f":"IF((AC15+AD15-AE15)>=0,AC15+AD15-AE15,\" \")","v":0},null,{"$f":"J15","v":0},{"$f":"K15","v":0},{"$f":"AG15-AJ15","v":0}]
[null,null,null,null,null,null,null,{"$f":"IF((D16+E16-F16)>=0,D16+E16-F16,\" \")","v":0},null,null,null,{"$f":"H16-K16","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B16","v":0},null,0,0,0,null,{"$f":"IF((AC16+AD16-AE16)>=0,AC16+AD16-AE16,\" \")","v":0},null,{"$f":"J16","v":0},{"$f":"K16","v":0},{"$f":"AG16-AJ16","v":0}]
[null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B17","v":0},null,{"$f":"D17","v":0},{"$f":"E17","v":0},{"$f":"F17","v":0},null,0,null,0,0,0]
[null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,0,0,null,0,null,0,0,0]
[null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,0,0,null,0,null,0,0,0]
[null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,0,0,null,0,null,0,0,0]
[null,null,null,null,null,null,null,0,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,0,0,null,0,null,0,0,0]
[null,null,null,null,null,null,null,{"$f":"IF((D22+E22-F22)>=0,D22+E22-F22,\" \")","v":0},null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,0,0,0,null,0,null,0,0,0]
[null,null,null,{"$f":"SUM(D15:D22)","v":0},{"$f":"SUM(E15:E22)","v":0},{"$f":"SUM(F15:G22)","v":0},null,{"$f":"SUM(H15:I22)","v":0},null," ",{"$f":"SUM(K15:K22)","v":0},{"$f":"SUM(L15:M22)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AC15:AC22)","v":0},{"$f":"SUM(AD15:AD22)","v":0},{"$f":"SUM(AE15:AF22)","v":0},null,{"$f":"SUM(AG15:AH22)","v":0},null," ",{"$f":"SUM(AJ15:AJ22)","v":0},{"$f":"SUM(AK15:AL22)","v":0}]
[]
[]
["2.","Bewertung des Warenlagers",null,null,null,null,null,null,null,null,"Am Ende des Geschäftsjahres",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2.",{"$f":"B26","v":"Bewertung des Warenlagers"},null,null,null,null,null,null,null,null,{"$f":"K26","v":"Am Ende des Geschäftsjahres"}]
[null,"Anschaffungskosten oder Marktwert",null,null,null,null,null,null,null,null,"Fr.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B27","v":"Anschaffungskosten oder Marktwert"},null,null,null,null,null,null,null,null,"Fr.",{"$f":"L27","v":0},{"$f":"M27","v":0}]
[null,"./. Buchwert",null,null,null,null,null,null,null,null,"Fr.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B28","v":"./. Buchwert"},null,null,null,null,null,null,null,null," ",{"$f":"L28","v":0},{"$f":"M28","v":0}]
[null,null,null,null,null,null,"Unterbewertung in Franken",null,null,null,"Fr.",{"$f":"L27-L28","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"G29","v":"Unterbewertung in Franken"},null,null,null,"Fr.",{"$f":"AK27-AK28","v":0}]
[null,null,null,null,null,null,"Unterbewertung in %",null,null,null,null,{"$f":"(IF(L27>0,L29*100/L27,0))/100","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"G30","v":"Unterbewertung in %"},null,null,null,null,{"$f":"(IF(AK27>0,AK29*100/AK27,0))/100","v":0}]
[]
[]
["3.","Detail der transitorischen Passiven",null,null,null,null,null,null,null,null,"Am Ende des Geschäftsjahres",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3.",{"$f":"B33","v":"Detail der transitorischen Passiven"},null,null,null,null,null,null,null,null,{"$f":"K33","v":"Am Ende des Geschäftsjahres"}]
[null,null,null,null,null,null,null,null,null,null,"Fr.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B34","v":0},0,0,0,0,0,{"$f":"H34","v":0},0,null,"Fr.",{"$f":"L34","v":0},0]
[null,null,null,null,null,null,null,null,null,null,"Fr.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,null,"Fr.",0,0]
[null,null,null,null,null,null,null,null,null,null,"Fr.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,null,"Fr.",0,0]
[null,null,null,null,null,null,null,null,null,null,"Fr.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,null,"Fr.",0,0]
[null,null,null,null,null,null,null,null,null,null,"Fr.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,null,"Fr.",0,0]
[null,null,null," ",null,null,"Total",null,null,null,"Fr.",{"$f":"SUM(L34:M38)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,"Total",null,null,null,"Fr.",{"$f":"SUM(AK34:AL38)","v":0}]
[]
[]
["4.","Detail und Veränderungen der Rückstellungen",null,null,null,null,null,null,null,null,"Veränderung",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4.",{"$f":"B42","v":"Detail und Veränderungen der Rückstellungen"},null,null,null,{"$f":"F42","v":0},null,null,null,null,{"$f":"K42","v":"Veränderung"}]
[null,"Rückstellung für Debitorenverluste",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rückstellung für Debitorenverluste"]
[null,"Debitoren",null,null,null,null,null,null,null,null,{"$f":"F44-H44","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Debitoren",null,null,null,{"$f":"F44","v":0},null,0,0,null,{"$f":"AE44-AG44","v":0}]
[null,"./. Dubiose Debitoren",null,"(zu bezeichnen)",null,null,null,null,null,null,{"$f":"F45-H45","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"./. Dubiose Debitoren",null,{"$f":"D45","v":"(zu bezeichnen)"},null,0,0,0,null,null,{"$f":"AE45-AG45","v":0}]
[null,"Saldo vor Berechnung der Rückstellungen",null,null,null,{"$f":"F44-F45","v":0},null,{"$f":"H44-H45","v":0},null,null,{"$f":"F46-H46","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Saldo vor Berechnung der Rückstellungen",null,null,null,{"$f":"AE44-AE45","v":0},null,{"$f":"AG44-AG45","v":0},null,null,{"$f":"AE46-AG46","v":0}]
[null,"Rückstellung für Debitorenverluste (5% CH, 10% Ausland)",null,null,null,null,null,null,null,null,{"$f":"F47-H47","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rückstellung für Debitorenverluste (5% CH, 10% Ausland)",null,null,null,{"$f":"F47","v":0},null,{"$f":"H47","v":0},{"$f":"I47","v":0},null,{"$f":"AE47-AG47","v":0}]
[]
[null,"Andere Rückstellungen",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B49","v":"Andere Rückstellungen"}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"F50-H50","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B50","v":0},0,0,null,{"$f":"F50","v":0},0,{"$f":"H50","v":0},0,null,{"$f":"AE50-AG50","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"F51-H51","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,null,0,0,0,0,null,{"$f":"AE51-AG51","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"F52-H52","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,null,0,0,0,0,null,{"$f":"AE52-AG52","v":0}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"F53-H53","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,0,0,null,0,0,0,0,null,{"$f":"AE53-AG53","v":0}]
[]
[]
["5.","Interkantonale und interkommunale Aufteilungen",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5.",{"$f":"B56","v":"Interkantonale und interkommunale Aufteilungen"}]
[null,"Bitte die nötigen Angaben zur Vornahme der Aufteilungen beilegen.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B57","v":"Bitte die nötigen Angaben zur Vornahme der Aufteilungen beilegen."}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Formular A1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"M58","v":"Formular A1"}]

{"sheet":"Rens verso","index":1,"n_rows":57,"n_cols":43,"rows_kept":57,"cut":false,"hidden":false,"merged":[[42,33,42,34],[42,36,42,37],[42,39,42,40],[42,42,42,43],[34,35,34,37],[34,41,34,43],[45,33,45,34],[45,36,45,37],[45,39,45,40],[45,42,45,43],[44,36,44,37],[44,39,44,40],[44,42,44,43],[43,33,43,34],[43,36,43,37],[43,39,43,40],[43,42,43,43],[44,33,44,34],[55,34,55,37],[46,42,46,43],[47,29,47,31],[47,33,47,34],[47,36,47,37],[47,39,47,40],[47,42,47,43],[46,29,46,31],[46,33,46,34],[46,36,46,37],[48,36,48,37],[48,39,48,40],[48,42,48,43],[46,39,46,40],[35,36,35,37],[35,42,35,43],[32,35,32,37],[32,41,32,43],[33,35,33,37],[33,41,33,43],[25,36,25,37],[25,42,25,43],[31,35,31,37],[31,41,31,43],[23,35,23,37],[23,41,23,43],[24,35,24,37],[24,41,24,43],[15,42,15,43],[21,35,21,37],[21,41,21,43],[22,35,22,37],[22,41,22,43],[13,29,13,31],[13,41,13,43],[14,29,14,31],[14,41,14,43],[11,29,11,31],[11,41,11,43],[12,29,12,31],[12,41,12,43],[5,2,5,11],[5,30,5,39],[8,35,8,37],[8,39,8,40],[11,1,11,3],[11,13,11,15],[8,7,8,9],[8,11,8,12],[8,41,8,43],[55,6,55,9],[32,13,32,15],[33,13,33,15],[31,13,31,15],[34,7,34,9],[34,13,34,15],[46,14,46,15],[47,8,47,9],[47,11,47,12],[47,14,47,15],[42,14,42,15],[43,14,43,15],[44,14,44,15],[45,14,45,15],[46,11,46,12],[42,8,42,9],[43,8,43,9],[44,8,44,9],[45,8,45,9],[42,11,42,12],[43,11,43,12],[44,11,44,12],[45,11,45,12],[35,14,35,15],[32,1,32,3],[33,1,33,3],[34,1,34,3],[46,1,46,3],[47,1,47,3],[42,5,42,6],[43,5,43,6],[44,5,44,6],[45,5,45,6],[46,5,46,6],[47,5,47,6],[42,1,42,3],[43,1,43,3],[44,1,44,3],[45,1,45,3],[40,5,40,6],[12,1,12,3],[13,1,13,3],[14,1,14,3],[21,7,21,9],[21,1,21,3],[22,1,22,3],[23,1,23,3],[24,1,24,3],[31,1,31,3],[21,13,21,15],[24,13,24,15],[15,14,15,15],[12,13,12,15],[13,13,13,15],[14,13,14,15],[22,13,22,15],[23,13,23,15],[48,8,48,9],[48,11,48,12],[48,14,48,15],[25,8,25,9],[25,14,25,15],[31,7,31,9],[32,7,32,9],[33,7,33,9],[22,7,22,9],[23,7,23,9],[24,7,24,9],[35,8,35,9],[46,8,46,9],[21,29,21,30],[22,29,22,30],[23,29,23,30],[24,29,24,30],[31,29,31,30],[32,29,32,30],[33,29,33,30],[45,29,45,30],[34,29,34,30],[42,29,42,30],[43,29,43,30],[44,29,44,30]]}
[]
[null,"B  -  AUSKÜNFTE BETREFFEND DIE AKTIONÄRE ODER",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B2","v":"B  -  AUSKÜNFTE BETREFFEND DIE AKTIONÄRE ODER"}]
[null,"DIESEN NAHESTEHENDE PERSONEN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B3","v":"DIESEN NAHESTEHENDE PERSONEN"}]
[null,null,null,null,null,null,null,null,null,null,null,"STEUERPERIODE 2015",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"L4","v":"STEUERPERIODE 2015"}]
[]
[null,"Firma    :",{"$f":"IF('Rens recto'!D4=\"\",\"\",'Rens recto'!D4)","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B6","v":"Firma    :"},{"$f":"C6","v":""}]
[]
[]
["1.","Löhne und andere Entschädigungen",null,null,null,null,"von",null,null,null,"bis",null,null,"Betrag",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1.",{"$f":"B9","v":"Löhne und andere Entschädigungen"},null,null,null,null,{"$f":"G9","v":"von"},{"$f":"IF(H9=\"\",\"\",H9)","v":""},null,null,{"$f":"K9","v":"bis"},{"$f":"IF(L9=\"\",\"\",L9)","v":""},null,{"$f":"N9","v":"Betrag"}]
[null,"von der Gesellschaft",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B10","v":"von der Gesellschaft"}]
[null,"Name und Vorname, Ort",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nom et prénom, domicile privé"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B12=\"\",\"\",B12)","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N12=\"\",\"\",N12)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B13=\"\",\"\",B13)","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N13=\"\",\"\",N13)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B14=\"\",\"\",B14)","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N14=\"\",\"\",N14)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B15=\"\",\"\",B15)","v":""},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N15=\"\",\"\",N15)","v":""}]
[null,null,null," ",null,null,null,null,null,"Total",null,null,null,"Fr.",{"$f":"IF(SUM(N12:P15)>0,SUM(N12:P15),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,null,null,"Total",null,null,null,"Fr.",{"$f":"IF(O16=\"\",\"\",O16)","v":""}]
[]
[]
[]
["2.","Forderungen gegenüber der Gesellschaft",null,null,null,null,null,"Betrag der Forderung",null,null,null,"Zins-",null,"Verbuchte Zinse",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2.",{"$f":"B20","v":"Forderungen gegenüber der Gesellschaft"},null,null,null,null,null,{"$f":"H20","v":"Betrag der Forderung"},null,null,null,{"$f":"L20","v":"Zins-"},null,{"$f":"N20","v":"Verbuchte Zinse"}]
[null,"Name und Vorname, Ort",null,null,null,null,null,"Ende Geschäftsjahr",null,null,null,"satz",null,"im Geschäftsjahr",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B21","v":"Name und Vorname, Ort"},null,null,null,null,null,{"$f":"H21","v":"Ende Geschäftsjahr"},null,null,null,{"$f":"L21","v":"satz"},null,{"$f":"N21","v":"im Geschäftsjahr"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"%",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B22=\"\",\"\",B22)","v":""},null,null,null,null,null,{"$f":"IF(H22=\"\",\"\",H22)","v":""},null,null,null,{"$f":"IF(L22=\"\",\"\",L22)","v":""},"%",{"$f":"IF(N22=\"\",\"\",N22)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,"%",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B23=\"\",\"\",B23)","v":""},null,null,null,null,null,{"$f":"IF(H23=\"\",\"\",H23)","v":""},null,null,null,{"$f":"IF(L23=\"\",\"\",L23)","v":""},"%",{"$f":"IF(N23=\"\",\"\",N23)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,"%",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B24=\"\",\"\",B24)","v":""},null,null,null,null,null,{"$f":"IF(H24=\"\",\"\",H24)","v":""},null,null,null,{"$f":"IF(L24=\"\",\"\",L24)","v":""},"%",{"$f":"IF(N24=\"\",\"\",N24)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,"%",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B25=\"\",\"\",B25)","v":""},null,null,null,null,null,{"$f":"IF(H25=\"\",\"\",H25)","v":""},null,null,null,{"$f":"IF(L25=\"\",\"\",L25)","v":""},"%",{"$f":"IF(N25=\"\",\"\",N25)","v":""}]
[null,null,null,"Totaux",null,null,null,"Fr.",{"$f":"IF(SUM(H22:J25)>0,SUM(H22:J25),\"\")","v":""},null,null,null,null,"Fr.",{"$f":"IF(SUM(N22:P25)>0,SUM(N22:P25),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Totaux",null,null,null,{"$f":"IF(H26=\"\",\"\",H26)","v":"Fr."},{"$f":"IF(I26=\"\",\"\",I26)","v":""},null,null,null,null,{"$f":"IF(N26=\"\",\"\",N26)","v":"Fr."},{"$f":"IF(O26=\"\",\"\",O26)","v":""}]
[]
[]
[]
["3.","Schulden gegenüber der Gesellschaft",null,null,null,null,null,"Schuldbetrag",null,null,null,"Zins-",null,"Verbuchte Zinse",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3.",{"$f":"B30","v":"Schulden gegenüber der Gesellschaft"},null,null,null,null,null,{"$f":"H30","v":"Schuldbetrag"},null,null,null,{"$f":"L30","v":"Zins-"},null,{"$f":"N30","v":"Verbuchte Zinse"}]
[null,"Name und Vorname, Ort",null,null,null,null,null,"Ende Geschäftsjahr",null,null,null,"satz",null,"im Geschäftsjahr",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B31","v":"Name und Vorname, Ort"},null,null,null,null,null,{"$f":"H31","v":"Ende Geschäftsjahr"},null,null,null,{"$f":"L31","v":"satz"},null,{"$f":"N31","v":"im Geschäftsjahr"}]
[null,null,null,null,null,null,null,null,null,null,null,null,"%",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B32=\"\",\"\",B32)","v":""},null,null,null,null,null,{"$f":"IF(H32=\"\",\"\",H32)","v":""},null,null,null,{"$f":"IF(L32=\"\",\"\",L32)","v":""},"%",{"$f":"IF(N32=\"\",\"\",N32)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,"%",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B33=\"\",\"\",B33)","v":""},null,null,null,null,null,{"$f":"IF(H33=\"\",\"\",H33)","v":""},null,null,null,{"$f":"IF(L33=\"\",\"\",L33)","v":""},"%",{"$f":"IF(N33=\"\",\"\",N33)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,"%",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B34=\"\",\"\",B34)","v":""},null,null,null,null,null,{"$f":"IF(H34=\"\",\"\",H34)","v":""},null,null,null,{"$f":"IF(L34=\"\",\"\",L34)","v":""},"%",{"$f":"IF(N34=\"\",\"\",N34)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,"%",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B35=\"\",\"\",B35)","v":""},null,null,null,null,null,{"$f":"IF(H35=\"\",\"\",H35)","v":""},null,null,null,{"$f":"IF(L35=\"\",\"\",L35)","v":""},"%",{"$f":"IF(N35=\"\",\"\",N35)","v":""}]
[null,null,null,"Totaux",null,null,null,"Fr.",{"$f":"IF(SUM(H32:J35)>0,SUM(H32:J35),\"\")","v":""},null,null,null,null,"Fr.",{"$f":"IF(SUM(N32:P35)>0,SUM(N32:P35),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Totaux",null,null,null,{"$f":"IF(H36=\"\",\"\",H36)","v":"Fr."},{"$f":"IF(I36=\"\",\"\",I36)","v":""},null,null,null,null,{"$f":"IF(N36=\"\",\"\",N36)","v":"Fr."},{"$f":"IF(O36=\"\",\"\",O36)","v":""}]
[]
[]
[]
["4.","Repräsentationsspesen und andere Spesen",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4.",{"$f":"B40","v":"Repräsentationsspesen und andere Spesen"}]
[null,"bezahlt durch die Gesellschaft",null,null,null,"Bezeichnung",null,null,"Effektive Spesen",null,null,"Pauschalspesen",null,null,"Total Spesen",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B41","v":"bezahlt durch die Gesellschaft"},null,null,null,{"$f":"F41","v":"Bezeichnung"},null,null,{"$f":"I41","v":"Effektive Spesen"},null,null,{"$f":"L41","v":"Pauschalspesen"},null,null,{"$f":"O41","v":"Total Spesen"}]
[null,"Name und Vorname, Ort",null,null,null,"der anderen Spesen",null,null,"im Geschäftsjahr",null,null,"im Geschäftsjahr",null,null,"im Geschäftsjahr",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B42","v":"Name und Vorname, Ort"},null,null,null,{"$f":"F42","v":"der anderen Spesen"},null,null,{"$f":"I42","v":"im Geschäftsjahr"},null,null,{"$f":"L42","v":"im Geschäftsjahr"},null,null,{"$f":"O42","v":"im Geschäftsjahr"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF((I43+L43)>0,(I43+L43),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(B43=\"\",\"\",B43)","v":""},null,null,null,{"$f":"IF(F43=\"\",\"\",F43)","v":""},null,null,{"$f":"IF(I43=\"\",\"\",I43)","v":""},null,null,{"$f":"IF(L43=\"\",\"\",L43)","v":""},null,null,{"$f":"IF(O43=\"\",\"\",O43)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,null,"",null,null,{"$f":"IF(L44=\"\",\"\",L44)","v":""},null,null,{"$f":"IF(O44=\"\",\"\",O44)","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,null,"",null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,null,"",null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,null,"",null,null,"",null,null,""]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,null,null,"",null,null,"",null,null,"",null,null,""]
[null,null,null,"Total",null,null,null,null,{"$f":"IF(SUM(I43:J48)>0,SUM(I43:J48),\"\")","v":""},null,null,{"$f":"IF(SUM(L43:M48)>0,SUM(L43:M48),\"\")","v":""},null,null,{"$f":"IF(SUM(O43:P48)>0,SUM(O43:P48),\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"D49","v":"Total"},null,null,null,null,"",null,null,"",null,null,""]
[]
[]
[]
[]
[" ","Die Richtigkeit und Vollständigkeit bezeugt :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",{"$f":"B54","v":"Die Richtigkeit und Vollständigkeit bezeugt :"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(G56=\"\",\"\",G56)","v":""}]
[null,null,null,null,null,null,"Ort und Datum",null,null,null,null,"Rechtsgültige Firmenunterschrift",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"G57","v":"Ort und Datum"},null,null,null,null,{"$f":"L57","v":"Rechtsgültige Firmenunterschrift"}]