{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Répartition D"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":1,"defined_names":2,"comments":1,"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":"Répartition D","index":0,"n_rows":124,"n_cols":75,"rows_kept":124,"cut":false,"hidden":false,"merged":[[28,26,28,31],[23,26,23,31],[24,26,24,31],[25,26,25,31],[26,26,26,31],[8,59,8,74],[17,49,17,55],[17,43,17,44],[8,17,8,32],[5,12,5,14],[91,2,93,14],[24,1,24,3],[25,1,25,3],[23,1,23,3],[23,8,23,13],[24,8,24,13],[25,8,25,13],[27,1,27,3],[39,1,39,3],[40,60,40,62],[17,68,17,74],[6,19,6,30],[6,43,6,55],[25,49,25,54],[26,42,26,44],[26,49,26,54],[25,42,25,44],[39,60,39,62],[27,26,27,31],[28,18,28,20],[27,18,27,20],[6,61,6,72],[11,2,11,4],[11,8,11,14],[13,2,13,3],[17,8,17,14],[17,2,17,3],[21,1,21,14],[25,18,25,20],[26,18,26,20],[8,0,8,14],[21,18,21,32],[24,18,24,20],[17,19,17,20],[17,21,17,22],[13,19,13,20],[17,26,17,32],[5,71,5,74],[8,42,8,55],[5,43,5,44],[23,18,23,20],[10,19,10,22],[11,19,11,22],[21,42,21,55],[13,61,13,62],[17,61,17,62],[13,43,13,44],[102,1,102,3],[101,1,101,3],[26,8,26,13],[46,1,46,3],[26,1,26,3],[100,1,100,3],[28,8,28,13],[28,1,28,3],[27,8,27,13],[40,1,40,3],[5,53,5,55],[5,30,5,32],[27,49,27,54],[28,42,28,44],[28,49,28,54],[11,43,11,45],[23,42,23,44],[23,49,23,54],[24,42,24,44],[24,49,24,54],[27,42,27,44],[91,19,93,32],[46,60,46,62],[39,42,39,44],[40,18,40,20],[46,18,46,20],[40,42,40,44],[91,43,93,55],[46,42,46,44],[39,18,39,20]]}
[null,null,"Kantonale Steuerverwaltung",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C1","v":"Kantonale Steuerverwaltung"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C1","v":"Kantonale Steuerverwaltung"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AR1","v":"Kantonale Steuerverwaltung"}]
[null,null,"Sektion juristische Personen",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sektion juristische Personen",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C2","v":"Sektion juristische Personen"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AR2","v":"Sektion juristische Personen"}]
[null,null,"Av. de la Gare 35",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Av. de la Gare 35",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C3","v":"Av. de la Gare 35"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AR3","v":"Av. de la Gare 35"}]
[null,null,"1950 Sion",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1950 Sion",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":"1950 Sion"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AR4","v":"1950 Sion"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"C7","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"T7","v":0}]
[]
["Interkantonale und interkommunale Steuerausscheidung",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A9","v":"Interkantonale und interkommunale Steuerausscheidung"},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":"A9","v":"Interkantonale und interkommunale Steuerausscheidung"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AQ9","v":"Interkantonale und interkommunale Steuerausscheidung"}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2009-12-31",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,{"$f":"AV11","v":"00:00:00"}]
[null,"Verantwortlicher","remy.corthay@admin.vs.ch",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2009-12-31",{"$f":"G12","v":"00:00:00"},null,{"$f":"I12","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B12","v":"Verantwortlicher"},"remy.corthay@admin.vs.ch",{"$f":"D13","v":0},null,null,{"$f":"G12","v":"00:00:00"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AS12","v":"00:00:00"},null,null,"2009-12-31",{"$f":"AV12","v":"00:00:00"}]
[null,"Direktwahl","027 606 24 74",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,"Direktwahl","027 606 24 74"]
[null,"Datum",{"$f":"TODAY()","v":"2015-01-29"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B14","v":"Datum"},{"$f":"C14","v":"2015-01-29"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Datum","2015-01-29",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AQ14","v":"Datum"},{"$f":"AR14","v":"2015-01-29"}]
[]
[]
[]
[null,"Referenznummer",null,null,null,null,"Firmenbezeichnung",null,null,null,null,null,null,null,null,null,null,null,{"$f":"B18","v":"Referenznummer"},{"$f":"C18","v":0},null,null,null,null,null,null,{"$f":"I18","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B18","v":"Referenznummer"},{"$f":"T18","v":0},null,null,null,{"$f":"G18","v":"Firmenbezeichnung"},null,{"$f":"AA18","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"AQ18","v":"Referenznummer"},{"$f":"AR18","v":0},null,null,null,null,{"$f":"AV18","v":"Firmenbezeichnung"},null,{"$f":"AX18","v":0}]
[]
[null,"Geschäftsjahr",2015,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B20","v":"Geschäftsjahr"},{"$f":"C20","v":2015},{"$f":"D20","v":"00:00:00"},null,null,"2009-12-31",{"$f":"G20","v":"00:00:00"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B20","v":"Geschäftsjahr"},{"$f":"T20","v":2015},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"S20","v":"Geschäftsjahr"},{"$f":"T20","v":2015},{"$f":"AT20","v":"00:00:00"},null,null,"2009-12-31",{"$f":"AW20","v":"00:00:00"}]
[]
[null,"Faktoren für die Ermittlung des steuerbaren Gewinnes und des steuerbaren Kapitals",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,{"$f":"B22","v":"Faktoren für die Ermittlung des steuerbaren Gewinnes und des steuerbaren Kapitals"}]
[]
[null,"Gewinn der Jahresrechnung",null,null,null,null,null,127000,"Einbezahltes Kapital",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":"B24","v":"Gewinn der Jahresrechnung"},null,null,{"$f":"E24","v":0},null,null,127000,{"$f":"I24","v":"Einbezahltes Kapital"},null,null,null,null,null,{"$f":"O24","v":0}]
[null,"Verdeckte Gewinnausschüttungen",null,null,null,null,null,0,"Gesetzliche Reserven",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,"Verdeckte Gewinnausschüttungen",null,null,{"$f":"E25","v":0},null,null,0,"Gesetzliche Reserven",null,null,null,null,null,{"$f":"O25","v":0}]
[null,"Privatanteile",null,null,null,null,null,6000,"Andere Reserven",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,"Privatanteile",null,null,{"$f":"E26","v":0},null,null,6000,"Andere Reserven",null,null,null,null,null,{"$f":"O26","v":0}]
[null,null,null,null,null,null,null,18000,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,0,null,null,{"$f":"E27","v":0},null,null,18000,0,null,null,null,null,null,{"$f":"O27","v":0}]
[null,"Vorjahresverluste",null,null,null,null,null,10000,"Gewinn-/Verlustvortrag",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,"Vorjahresverluste",null,null,{"$f":"E28","v":0},null,null,10000,"Gewinn-/Verlustvortrag",null,null,null,null,null,{"$f":"O28","v":0}]
[null,"Steuerbarer Reingewinn",null,null,{"$f":"IF(E24=0,0,SUM(E24:E28))","v":0},null,null,{"$f":"IF(H24=0,0,SUM(H24:H28))","v":161000},"Steuerbares Kapital",null,null,null,null,null,{"$f":"IF(O24=0,0,SUM(O24:O28))","v":0},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,"Steuerbarer Reingewinn",null,null,{"$f":"IF(AT24=0,0,SUM(AT24:AT28))","v":0},null,null,{"$f":"IF(AW24=0,0,SUM(AW24:AW28))","v":161000},"Steuerbares Kapital",null,null,null,null,null,{"$f":"IF(BD24=0,0,SUM(BD24:BD28))","v":0}]
[]
[]
[]
[null,"Kanton",null,null,"Total",null,"Wallis",null,null,null,null,null,null,null,null,null,null,null,{"$f":"B33","v":"Kanton"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B33","v":"Kanton"},null,null,"Total",null,{"$f":"G33","v":"Wallis"},null,{"$f":"I33","v":0},null,{"$f":"K33","v":0},0,0,0,0,null,null,null,null,{"$f":"AQ33","v":"Kanton"},null,null,null,{"$f":"W33","v":0},null,{"$f":"Y33","v":0},0,0,0,0,0,0,null,{"$f":"AG33","v":0}]
[null,"Gemeinde",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B34","v":"Gemeinde"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B34","v":"Gemeinde"},null,null,null,null,{"$f":"G34","v":0},null,{"$f":"I34","v":0},null,0,0,0,0,0,null,null,null,null,{"$f":"AQ34","v":"Gemeinde"},null,null,null,{"$f":"W34","v":0},null,0,0,0,0,0,0,0,null,{"$f":"AG34","v":0}]
[]
["I","Kapitalausscheidung",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B36","v":"Kapitalausscheidung"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"I",{"$f":"B36","v":"Kapitalausscheidung"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"I",{"$f":"AQ36","v":"Kapitalausscheidung"}]
[]
[null,"Immobilien",null,null,{"$f":"SUM(G38:AG38)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B38","v":"Immobilien"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B38","v":"Immobilien"},null,null,{"$f":"E38","v":0},null,{"$f":"G38","v":0},null,{"$f":"I38","v":0},null,{"$f":"K38","v":0},0,0,0,0,null,null,null,null,{"$f":"AQ38","v":"Immobilien"},null,null,null,{"$f":"W38","v":0},null,{"$f":"Y38","v":0},0,0,0,0,0,0,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"AG38","v":0}]
[null,"Maschinen, Mobilien, Fahrzeuge",null,null,{"$f":"SUM(G39:AG39)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B39","v":"Maschinen, Mobilien, Fahrzeuge"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B39","v":"Maschinen, Mobilien, Fahrzeuge"},null,null,{"$f":"E39","v":0},null,{"$f":"G39","v":0},null,{"$f":"I39","v":0},null,0,0,0,0,0,null,null,null,null,{"$f":"AQ39","v":"Maschinen, Mobilien, Fahrzeuge"},null,null,null,{"$f":"W39","v":0},null,0,0,0,0,0,0,0,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"AG39","v":0}]
[null,"Warenvorräte",null,null,{"$f":"SUM(G40:AG40)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B40","v":"Warenvorräte"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B40","v":"Warenvorräte"},null,null,{"$f":"E40","v":0},null,{"$f":"G40","v":0},null,{"$f":"I40","v":0},null,0,0,0,0,0,null,null,null,null,{"$f":"AQ40","v":"Warenvorräte"},null,null,null,{"$f":"W40","v":0},null,0,0,0,0,0,0,0,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"AG40","v":0}]
[null,null,null,null,{"$f":"SUM(G41:AG41)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B41","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B41","v":0},null,null,{"$f":"E41","v":0},null,{"$f":"G41","v":0},null,{"$f":"I41","v":0},null,0,0,0,0,0,null,null,null,null,{"$f":"AQ41","v":0},null,null,null,{"$f":"W41","v":0},null,0,0,0,0,0,0,0,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"AG41","v":0}]
[null,"Total Lokalisierte Aktiven",null,null,{"$f":"IF(SUM(E38:E41)=0,\"\",SUM(E38:E41))","v":""},null,{"$f":"IF(SUM(G38:G41)=0,\"\",SUM(G38:G41))","v":""},null,{"$f":"IF(SUM(I38:I41)=0,\"\",SUM(I38:I41))","v":""},null,{"$f":"IF(SUM(K38:K41)=0,\"\",SUM(K38:K41))","v":""},null,{"$f":"IF(SUM(M38:M41)=0,\"\",SUM(M38:M41))","v":""},null,{"$f":"IF(SUM(O38:O41)=0,\"\",SUM(O38:O41))","v":""},null,null,null,{"$f":"B42","v":"Total Lokalisierte Aktiven"},null,null,null,{"$f":"IF(SUM(W38:W41)=0,\"\",SUM(W38:W41))","v":""},null,{"$f":"IF(SUM(Y38:Y41)=0,\"\",SUM(Y38:Y41))","v":""},null,{"$f":"IF(SUM(AA38:AA41)=0,\"\",SUM(AA38:AA41))","v":""},null,{"$f":"IF(SUM(AC38:AC41)=0,\"\",SUM(AC38:AC41))","v":""},null,{"$f":"IF(SUM(AE38:AE41)=0,\"\",SUM(AE38:AE41))","v":""},null,{"$f":"IF(SUM(AG38:AG41)=0,\"\",SUM(AG38:AG41))","v":""},null,null,null,null,null,null,null,null,null,{"$f":"B42","v":"Total Lokalisierte Aktiven"},null,null,{"$f":"E42","v":""},null,{"$f":"IF(SUM(AV38:AV41)=0,\"\",SUM(AV38:AV41))","v":""},null,{"$f":"IF(SUM(AX38:AX41)=0,\"\",SUM(AX38:AX41))","v":""},null,{"$f":"IF(SUM(AZ38:AZ41)=0,\"\",SUM(AZ38:AZ41))","v":""},null,{"$f":"IF(SUM(BB38:BB41)=0,\"\",SUM(BB38:BB41))","v":""},null,{"$f":"IF(SUM(BD38:BD41)=0,\"\",SUM(BD38:BD41))","v":""},null,null,null,null,{"$f":"AQ42","v":"Total Lokalisierte Aktiven"},null,null,null,{"$f":"IF(SUM(BM38:BM41)=0,\"\",SUM(BM38:BM41))","v":""},null,{"$f":"IF(SUM(BO38:BO41)=0,\"\",SUM(BO38:BO41))","v":""},null,{"$f":"IF(SUM(BQ38:BQ41)=0,\"\",SUM(BQ38:BQ41))","v":""},null,{"$f":"IF(SUM(BS38:BS41)=0,\"\",SUM(BS38:BS41))","v":""},null,{"$f":"IF(SUM(BU38:BU41)=0,\"\",SUM(BU38:BU41))","v":""},null,{"$f":"IF(SUM(BW38:BW41)=0,\"\",SUM(BW38:BW41))","v":""}]
[]
[null,"Flüssige Mittel",null,null,{"$f":"SUM(G44:AG44)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B44","v":"Flüssige Mittel"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B44","v":"Flüssige Mittel"},null,null,{"$f":"E44","v":0},null,{"$f":"G44","v":0},null,{"$f":"I44","v":0},null,{"$f":"K44","v":0},0,0,0,0,null,null,null,null,{"$f":"AQ44","v":"Flüssige Mittel"},null,null,null,{"$f":"W44","v":0},null,{"$f":"Y44","v":0},0,0,0,0,0,0,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"AG44","v":0}]
[null,"Forderungen",null,null,{"$f":"SUM(G45:AG45)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B45","v":"Forderungen"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B45","v":"Forderungen"},null,null,{"$f":"E45","v":0},null,{"$f":"G45","v":0},null,{"$f":"I45","v":0},null,0,0,0,0,0,null,null,null,null,{"$f":"AQ45","v":"Forderungen"},null,null,null,{"$f":"W45","v":0},null,0,0,0,0,0,0,0,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"AG45","v":0}]
[null,"Uebrige",null,null,{"$f":"SUM(G46:AG46)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B46","v":"Uebrige"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B46","v":"Uebrige"},null,null,{"$f":"E46","v":0},null,{"$f":"G46","v":0},null,{"$f":"I46","v":0},null,0,0,0,0,0,null,null,null,null,{"$f":"AQ46","v":"Uebrige"},null,null,null,{"$f":"W46","v":0},null,0,0,0,0,0,0,0,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"AG46","v":0}]
[null,null,null,null,{"$f":"SUM(G47:AG47)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B47","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B47","v":0},null,null,{"$f":"E47","v":0},null,{"$f":"G47","v":0},null,{"$f":"I47","v":0},null,0,0,0,0,0,null,null,null,null,{"$f":"AQ47","v":0},null,null,null,{"$f":"W47","v":0},null,0,0,0,0,0,0,0,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"AG47","v":0}]
[null,"Total mobile Aktiven",null,null,{"$f":"IF(SUM(E44:E47)=0,\"\",SUM(E44:E47))","v":""},null,{"$f":"IF(SUM(G44:G47)=0,\"\",SUM(G44:G47))","v":""},null,{"$f":"IF(SUM(I44:I47)=0,\"\",SUM(I44:I47))","v":""},null,{"$f":"IF(SUM(K44:K47)=0,\"\",SUM(K44:K47))","v":""},null,{"$f":"IF(SUM(M44:M47)=0,\"\",SUM(M44:M47))","v":""},null,{"$f":"IF(SUM(O44:O47)=0,\"\",SUM(O44:O47))","v":""},null,null,null,{"$f":"B48","v":"Total mobile Aktiven"},null,null,null,{"$f":"IF(SUM(W44:W47)=0,\"\",SUM(W44:W47))","v":""},null,{"$f":"IF(SUM(Y44:Y47)=0,\"\",SUM(Y44:Y47))","v":""},null,{"$f":"IF(SUM(AA44:AA47)=0,\"\",SUM(AA44:AA47))","v":""},null,{"$f":"IF(SUM(AC44:AC47)=0,\"\",SUM(AC44:AC47))","v":""},null,{"$f":"IF(SUM(AE44:AE47)=0,\"\",SUM(AE44:AE47))","v":""},null,{"$f":"IF(SUM(AG44:AG47)=0,\"\",SUM(AG44:AG47))","v":""},null,null,null,null,null,null,null,null,null,{"$f":"B48","v":"Total mobile Aktiven"},null,null,{"$f":"E48","v":""},null,{"$f":"IF(SUM(AV44:AV47)=0,\"\",SUM(AV44:AV47))","v":""},null,{"$f":"IF(SUM(AX44:AX47)=0,\"\",SUM(AX44:AX47))","v":""},null,{"$f":"IF(SUM(AZ44:AZ47)=0,\"\",SUM(AZ44:AZ47))","v":""},null,{"$f":"IF(SUM(BB44:BB47)=0,\"\",SUM(BB44:BB47))","v":""},null,{"$f":"IF(SUM(BD44:BD47)=0,\"\",SUM(BD44:BD47))","v":""},null,null,null,null,{"$f":"AQ48","v":"Total mobile Aktiven"},null,null,null,{"$f":"IF(SUM(BM44:BM47)=0,\"\",SUM(BM44:BM47))","v":""},null,{"$f":"IF(SUM(BO44:BO47)=0,\"\",SUM(BO44:BO47))","v":""},null,{"$f":"IF(SUM(BQ44:BQ47)=0,\"\",SUM(BQ44:BQ47))","v":""},null,{"$f":"IF(SUM(BS44:BS47)=0,\"\",SUM(BS44:BS47))","v":""},null,{"$f":"IF(SUM(BU44:BU47)=0,\"\",SUM(BU44:BU47))","v":""},null,{"$f":"IF(SUM(BW44:BW47)=0,\"\",SUM(BW44:BW47))","v":""}]
[]
[null,"Total Aktiven",null,null,{"$f":"IF(SUM(E38:E41)+SUM(E44:E47)=0,\"\",IF(AND(SUM(E38:E41)=0,SUM(E44:E47)>0),SUM(E44:E47),IF(AND(SUM(E44:E47)=0,SUM(E38:E41)>0),SUM(E38:E41),+E42+E48)))","v":""},null,{"$f":"IF(SUM(G38:G41)+SUM(G44:G47)=0,\"\",IF(AND(SUM(G38:G41)=0,SUM(G44:G47)>0),SUM(G44:G47),IF(AND(SUM(G44:G47)=0,SUM(G38:G41)>0),SUM(G38:G41),+G42+G48)))","v":""},null,{"$f":"IF(SUM(I38:I41)+SUM(I44:I47)=0,\"\",IF(AND(SUM(I38:I41)=0,SUM(I44:I47)>0),SUM(I44:I47),IF(AND(SUM(I44:I47)=0,SUM(I38:I41)>0),SUM(I38:I41),+I42+I48)))","v":""},null,{"$f":"IF(SUM(K38:K41)+SUM(K44:K47)=0,\"\",IF(AND(SUM(K38:K41)=0,SUM(K44:K47)>0),SUM(K44:K47),IF(AND(SUM(K44:K47)=0,SUM(K38:K41)>0),SUM(K38:K41),+K42+K48)))","v":""},null,{"$f":"IF(SUM(M38:M41)+SUM(M44:M47)=0,\"\",IF(AND(SUM(M38:M41)=0,SUM(M44:M47)>0),SUM(M44:M47),IF(AND(SUM(M44:M47)=0,SUM(M38:M41)>0),SUM(M38:M41),+M42+M48)))","v":""},null,{"$f":"IF(SUM(O38:O41)+SUM(O44:O47)=0,\"\",IF(AND(SUM(O38:O41)=0,SUM(O44:O47)>0),SUM(O44:O47),IF(AND(SUM(O44:O47)=0,SUM(O38:O41)>0),SUM(O38:O41),+O42+O48)))","v":""},null,null,null,{"$f":"B50","v":"Total Aktiven"},null,null,null,{"$f":"IF(SUM(W38:W41)+SUM(W44:W47)=0,\"\",IF(AND(SUM(W38:W41)=0,SUM(W44:W47)>0),SUM(W44:W47),IF(AND(SUM(W44:W47)=0,SUM(W38:W41)>0),SUM(W38:W41),+W42+W48)))","v":""},null,{"$f":"IF(SUM(Y38:Y41)+SUM(Y44:Y47)=0,\"\",IF(AND(SUM(Y38:Y41)=0,SUM(Y44:Y47)>0),SUM(Y44:Y47),IF(AND(SUM(Y44:Y47)=0,SUM(Y38:Y41)>0),SUM(Y38:Y41),+Y42+Y48)))","v":""},null,{"$f":"IF(SUM(AA38:AA41)+SUM(AA44:AA47)=0,\"\",IF(AND(SUM(AA38:AA41)=0,SUM(AA44:AA47)>0),SUM(AA44:AA47),IF(AND(SUM(AA44:AA47)=0,SUM(AA38:AA41)>0),SUM(AA38:AA41),+AA42+AA48)))","v":""},null,{"$f":"IF(SUM(AC38:AC41)+SUM(AC44:AC47)=0,\"\",IF(AND(SUM(AC38:AC41)=0,SUM(AC44:AC47)>0),SUM(AC44:AC47),IF(AND(SUM(AC44:AC47)=0,SUM(AC38:AC41)>0),SUM(AC38:AC41),+AC42+AC48)))","v":""},null,{"$f":"IF(SUM(AE38:AE41)+SUM(AE44:AE47)=0,\"\",IF(AND(SUM(AE38:AE41)=0,SUM(AE44:AE47)>0),SUM(AE44:AE47),IF(AND(SUM(AE44:AE47)=0,SUM(AE38:AE41)>0),SUM(AE38:AE41),+AE42+AE48)))","v":""},null,{"$f":"IF(SUM(AG38:AG41)+SUM(AG44:AG47)=0,\"\",IF(AND(SUM(AG38:AG41)=0,SUM(AG44:AG47)>0),SUM(AG44:AG47),IF(AND(SUM(AG44:AG47)=0,SUM(AG38:AG41)>0),SUM(AG38:AG41),+AG42+AG48)))","v":""},null,null,null,null,null,null,null,null,null,{"$f":"B50","v":"Total Aktiven"},null,null,{"$f":"E50","v":""},null,{"$f":"IF(SUM(AV38:AV41)+SUM(AV44:AV47)=0,\"\",IF(AND(SUM(AV38:AV41)=0,SUM(AV44:AV47)>0),SUM(AV44:AV47),IF(AND(SUM(AV44:AV47)=0,SUM(AV38:AV41)>0),SUM(AV38:AV41),+AV42+AV48)))","v":""},null,{"$f":"IF(SUM(AX38:AX41)+SUM(AX44:AX47)=0,\"\",IF(AND(SUM(AX38:AX41)=0,SUM(AX44:AX47)>0),SUM(AX44:AX47),IF(AND(SUM(AX44:AX47)=0,SUM(AX38:AX41)>0),SUM(AX38:AX41),+AX42+AX48)))","v":""},null,{"$f":"IF(SUM(AZ38:AZ41)+SUM(AZ44:AZ47)=0,\"\",IF(AND(SUM(AZ38:AZ41)=0,SUM(AZ44:AZ47)>0),SUM(AZ44:AZ47),IF(AND(SUM(AZ44:AZ47)=0,SUM(AZ38:AZ41)>0),SUM(AZ38:AZ41),+AZ42+AZ48)))","v":""},null,{"$f":"IF(SUM(BB38:BB41)+SUM(BB44:BB47)=0,\"\",IF(AND(SUM(BB38:BB41)=0,SUM(BB44:BB47)>0),SUM(BB44:BB47),IF(AND(SUM(BB44:BB47)=0,SUM(BB38:BB41)>0),SUM(BB38:BB41),+BB42+BB48)))","v":""},null,{"$f":"IF(SUM(BD38:BD41)+SUM(BD44:BD47)=0,\"\",IF(AND(SUM(BD38:BD41)=0,SUM(BD44:BD47)>0),SUM(BD44:BD47),IF(AND(SUM(BD44:BD47)=0,SUM(BD38:BD41)>0),SUM(BD38:BD41),+BD42+BD48)))","v":""},null,null,null,null,{"$f":"AQ50","v":"Total Aktiven"},null,null,null,{"$f":"IF(SUM(BM38:BM41)+SUM(BM44:BM47)=0,\"\",IF(AND(SUM(BM38:BM41)=0,SUM(BM44:BM47)>0),SUM(BM44:BM47),IF(AND(SUM(BM44:BM47)=0,SUM(BM38:BM41)>0),SUM(BM38:BM41),+BM42+BM48)))","v":""},null,{"$f":"IF(SUM(BO38:BO41)+SUM(BO44:BO47)=0,\"\",IF(AND(SUM(BO38:BO41)=0,SUM(BO44:BO47)>0),SUM(BO44:BO47),IF(AND(SUM(BO44:BO47)=0,SUM(BO38:BO41)>0),SUM(BO38:BO41),+BO42+BO48)))","v":""},null,{"$f":"IF(SUM(BQ38:BQ41)+SUM(BQ44:BQ47)=0,\"\",IF(AND(SUM(BQ38:BQ41)=0,SUM(BQ44:BQ47)>0),SUM(BQ44:BQ47),IF(AND(SUM(BQ44:BQ47)=0,SUM(BQ38:BQ41)>0),SUM(BQ38:BQ41),+BQ42+BQ48)))","v":""},null,{"$f":"IF(SUM(BS38:BS41)+SUM(BS44:BS47)=0,\"\",IF(AND(SUM(BS38:BS41)=0,SUM(BS44:BS47)>0),SUM(BS44:BS47),IF(AND(SUM(BS44:BS47)=0,SUM(BS38:BS41)>0),SUM(BS38:BS41),+BS42+BS48)))","v":""},null,{"$f":"IF(SUM(BU38:BU41)+SUM(BU44:BU47)=0,\"\",IF(AND(SUM(BU38:BU41)=0,SUM(BU44:BU47)>0),SUM(BU44:BU47),IF(AND(SUM(BU44:BU47)=0,SUM(BU38:BU41)>0),SUM(BU38:BU41),+BU42+BU48)))","v":""},null,{"$f":"IF(SUM(BW38:BW41)+SUM(BW44:BW47)=0,\"\",IF(AND(SUM(BW38:BW41)=0,SUM(BW44:BW47)>0),SUM(BW44:BW47),IF(AND(SUM(BW44:BW47)=0,SUM(BW38:BW41)>0),SUM(BW38:BW41),+BW42+BW48)))","v":""}]
[null,"In %",null,null,{"$f":"IF(E50=\"\",\"\",+E50/$E50)","v":""},null,{"$f":"IF(G50=\"\",\"\",+G50/$E50)","v":""},null,{"$f":"IF(I50=\"\",\"\",+I50/$E50)","v":""},null,{"$f":"IF(K50=\"\",\"\",+K50/$E50)","v":""},null,{"$f":"IF(M50=\"\",\"\",+M50/$E50)","v":""},null,{"$f":"IF(O50=\"\",\"\",+O50/$E50)","v":""},null,null,null,{"$f":"B51","v":"In %"},null,null,null,{"$f":"IF(W50=\"\",\"\",+W50/$E50)","v":""},null,{"$f":"IF(Y50=\"\",\"\",+Y50/$E50)","v":""},null,{"$f":"IF(AA50=\"\",\"\",+AA50/$E50)","v":""},null,{"$f":"IF(AC50=\"\",\"\",+AC50/$E50)","v":""},null,{"$f":"IF(AE50=\"\",\"\",+AE50/$E50)","v":""},null,{"$f":"IF(AG50=\"\",\"\",+AG50/$E50)","v":""},null,null,null,null,null,null,null,null,null,"In %",null,null,{"$f":"E51","v":""},null,{"$f":"G51","v":""},null,{"$f":"I51","v":""},0,"",0,"",0,"",null,null,null,null,{"$f":"AQ51","v":"In %"},null,null,null,{"$f":"W51","v":""},null,{"$f":"Y51","v":""},0,"",0,"",0,"",0,""]
[null,"Steuerbares Kapital",null,null,{"$f":"IF(O29=\"\",\"\",O29)","v":0},null,{"$f":"IF(G50=\"\", \"\",+G50*$E52/$E50)","v":""},null,{"$f":"IF(I50=\"\", \"\",+I50*$E52/$E50)","v":""},null,{"$f":"IF(K50=\"\", \"\",+K50*$E52/$E50)","v":""},null,{"$f":"IF(M50=\"\", \"\",+M50*$E52/$E50)","v":""},null,{"$f":"IF(O50=\"\", \"\",+O50*$E52/$E50)","v":""},null,null,null,{"$f":"B52","v":"Steuerbares Kapital"},null,null,null,{"$f":"IF(W50=\"\", \"\",+W50*$E52/$E50)","v":""},null,{"$f":"IF(Y50=\"\", \"\",+Y50*$E52/$E50)","v":""},null,{"$f":"IF(AA50=\"\", \"\",+AA50*$E52/$E50)","v":""},null,{"$f":"IF(AC50=\"\", \"\",+AC50*$E52/$E50)","v":""},null,{"$f":"IF(AE50=\"\", \"\",+AE50*$E52/$E50)","v":""},null,{"$f":"IF(AG50=\"\", \"\",+AG50*$E52/$E50)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"B52","v":"Steuerbares Kapital"},null,null,{"$f":"E52","v":0},null,{"$f":"IF(AV50=\"\", \"\",+AV50*$E52/$E50)","v":""},null,{"$f":"IF(AX50=\"\", \"\",+AX50*$E52/$E50)","v":""},null,{"$f":"IF(AZ50=\"\", \"\",+AZ50*$E52/$E50)","v":""},null,{"$f":"IF(BB50=\"\", \"\",+BB50*$E52/$E50)","v":""},null,{"$f":"IF(BD50=\"\", \"\",+BD50*$E52/$E50)","v":""},null,null,null,null,{"$f":"S52","v":"Steuerbares Kapital"},null,null,null,{"$f":"IF(BM50=\"\", \"\",+BM50*$E52/$E50)","v":""},null,{"$f":"IF(BO50=\"\", \"\",+BO50*$E52/$E50)","v":""},null,{"$f":"IF(BQ50=\"\", \"\",+BQ50*$E52/$E50)","v":""},null,{"$f":"IF(BS50=\"\", \"\",+BS50*$E52/$E50)","v":""},null,{"$f":"IF(BU50=\"\", \"\",+BU50*$E52/$E50)","v":""},null,{"$f":"IF(BW50=\"\", \"\",+BW50*$E52/$E50)","v":""}]
[null,"In %",null,null,{"$f":"IF(E52=0,\"\",E52/$E52)","v":""},null,{"$f":"IF(G52=\"\",\"\",+G52/$E52)","v":""},null,{"$f":"IF(I52=\"\",\"\",+I52/$E52)","v":""},null,{"$f":"IF(K52=\"\",\"\",+K52/$E52)","v":""},null,{"$f":"IF(M52=\"\",\"\",+M52/$E52)","v":""},null,{"$f":"IF(O52=\"\",\"\",+O52/$E52)","v":""},null,null,null,{"$f":"B53","v":"In %"},null,null,null,{"$f":"IF(W52=\"\",\"\",+W52/$E52)","v":""},null,{"$f":"IF(Y52=\"\",\"\",+Y52/$E52)","v":""},null,{"$f":"IF(AA52=\"\",\"\",+AA52/$E52)","v":""},null,{"$f":"IF(AC52=\"\",\"\",+AC52/$E52)","v":""},null,{"$f":"IF(AE52=\"\",\"\",+AE52/$E52)","v":""},null,{"$f":"IF(AG52=\"\",\"\",+AG52/$E52)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"B53","v":"In %"},null,null,{"$f":"E53","v":""},null,{"$f":"G53","v":""},null,{"$f":"I53","v":""},null,{"$f":"K53","v":""},null,{"$f":"M53","v":""},null,{"$f":"O53","v":""},null,null,null,null,{"$f":"AQ53","v":"In %"},null,null,null,{"$f":"W53","v":""},null,{"$f":"Y53","v":""},null,{"$f":"AA53","v":""},null,{"$f":"AC53","v":""},null,{"$f":"AE53","v":""},null,{"$f":"AG53","v":""}]
[]
[]
["II","Gewinnausscheidung",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B56","v":"Gewinnausscheidung"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"II",{"$f":"B56","v":"Gewinnausscheidung"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"II",{"$f":"AQ56","v":"Gewinnausscheidung"}]
[]
[null,"Erwerbsfaktoren",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B58","v":"Erwerbsfaktoren"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B58","v":"Erwerbsfaktoren"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AQ58","v":"Erwerbsfaktoren"}]
[null,"Aktiven",null,null,{"$f":"SUM(G59:AG59)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"Aktiven",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Aktiven",null,null,{"$f":"E59","v":0},null,{"$f":"G59","v":0},null,{"$f":"I59","v":0},null,{"$f":"K59","v":0},0,0,0,0,null,null,null,null,"Aktiven",null,null,null,{"$f":"W59","v":0},null,{"$f":"Y59","v":0},0,0,0,0,0,0,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"AG59","v":0}]
[null,"Gehälter/Löhne kapitalisiert (10x)",null,null,{"$f":"SUM(G60:AG60)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"Gehälter/Löhne kapitalisiert (10x)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Gehälter/Löhne kapitalisiert (10x)",null,null,{"$f":"E60","v":0},null,{"$f":"G60","v":0},null,{"$f":"I60","v":0},null,0,0,0,0,0,null,null,null,null,"Gehälter/Löhne kapitalisiert (10x)",null,null,null,{"$f":"W60","v":0},null,0,0,0,0,0,0,0,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"AG60","v":0}]
[null,"Mietzinse kapitalisiert (6%)",null,null,{"$f":"SUM(G61:AG61)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"Mietzinse kapitalisiert (6%)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mietzinse kapitalisiert (6%)",null,null,{"$f":"E61","v":0},null,{"$f":"G61","v":0},null,{"$f":"I61","v":0},null,0,0,0,0,0,null,null,null,null,"Mietzinse kapitalisiert (6%)",null,null,null,{"$f":"W61","v":0},null,0,0,0,0,0,0,0,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"AG61","v":0}]
[null,"Massgebende Erwerbsfaktoren",null,null,{"$f":"IF(SUM(E59:E61)=0,\"\",SUM(E59:E61))","v":""},null,{"$f":"IF(SUM(G59:G61)=0,\"\",SUM(G59:G61))","v":""},null,{"$f":"IF(SUM(I59:I61)=0,\"\",SUM(I59:I61))","v":""},null,{"$f":"IF(SUM(K59:K61)=0,\"\",SUM(K59:K61))","v":""},null,{"$f":"IF(SUM(M59:M61)=0,\"\",SUM(M59:M61))","v":""},null,{"$f":"IF(SUM(O59:O61)=0,\"\",SUM(O59:O61))","v":""},null,null,null,"Massgebende Erwerbsfaktoren",null,null,null,{"$f":"IF(SUM(W59:W61)=0,\"\",SUM(W59:W61))","v":""},null,{"$f":"IF(SUM(Y59:Y61)=0,\"\",SUM(Y59:Y61))","v":""},null,{"$f":"IF(SUM(AA59:AA61)=0,\"\",SUM(AA59:AA61))","v":""},null,{"$f":"IF(SUM(AC59:AC61)=0,\"\",SUM(AC59:AC61))","v":""},null,{"$f":"IF(SUM(AE59:AE61)=0,\"\",SUM(AE59:AE61))","v":""},null,{"$f":"IF(SUM(AG59:AG61)=0,\"\",SUM(AG59:AG61))","v":""},null,null,null,null,null,null,null,null,null,"Massgebende Erwerbsfaktoren",null,null,{"$f":"E62","v":""},null,{"$f":"IF(SUM(AV59:AV61)=0,\"\",SUM(AV59:AV61))","v":""},null,{"$f":"IF(SUM(AX59:AX61)=0,\"\",SUM(AX59:AX61))","v":""},null,{"$f":"IF(SUM(AZ59:AZ61)=0,\"\",SUM(AZ59:AZ61))","v":""},null,{"$f":"IF(SUM(BB59:BB61)=0,\"\",SUM(BB59:BB61))","v":""},null,{"$f":"IF(SUM(BD59:BD61)=0,\"\",SUM(BD59:BD61))","v":""},null,null,null,null,"Massgebende Erwerbsfaktoren",null,null,null,{"$f":"IF(SUM(BM59:BM61)=0,\"\",SUM(BM59:BM61))","v":""},null,{"$f":"IF(SUM(BO59:BO61)=0,\"\",SUM(BO59:BO61))","v":""},null,{"$f":"IF(SUM(BQ59:BQ61)=0,\"\",SUM(BQ59:BQ61))","v":""},null,{"$f":"IF(SUM(BS59:BS61)=0,\"\",SUM(BS59:BS61))","v":""},null,{"$f":"IF(SUM(BU59:BU61)=0,\"\",SUM(BU59:BU61))","v":""},null,{"$f":"IF(SUM(BW59:BW61)=0,\"\",SUM(BW59:BW61))","v":""}]
[null,{"$f":"B53","v":"In %"},null,null,{"$f":"IF(E62=\"\",\"\",+E62/$E62)","v":""},null,{"$f":"IF(G62=\"\",\"\",+G62/$E62)","v":""},null,{"$f":"IF(I62=\"\",\"\",+I62/$E62)","v":""},null,{"$f":"IF(K62=\"\",\"\",+K62/$E62)","v":""},null,{"$f":"IF(M62=\"\",\"\",+M62/$E62)","v":""},null,{"$f":"IF(O62=\"\",\"\",+O62/$E62)","v":""},null,null,null,"In %",null,null,null,{"$f":"IF(W62=\"\",\"\",+W62/$E62)","v":""},null,{"$f":"IF(Y62=\"\",\"\",+Y62/$E62)","v":""},null,{"$f":"IF(AA62=\"\",\"\",+AA62/$E62)","v":""},null,{"$f":"IF(AC62=\"\",\"\",+AC62/$E62)","v":""},null,{"$f":"IF(AE62=\"\",\"\",+AE62/$E62)","v":""},null,{"$f":"IF(AG62=\"\",\"\",+AG62/$E62)","v":""},null,null,null,null,null,null,null,null,null,"In %",null,null,{"$f":"IF(AT62=\"\",\"\",+AT62/$E62)","v":""},null,{"$f":"IF(AV62=\"\",\"\",+AV62/$E62)","v":""},null,{"$f":"IF(AX62=\"\",\"\",+AX62/$E62)","v":""},null,{"$f":"IF(AZ62=\"\",\"\",+AZ62/$E62)","v":""},null,{"$f":"IF(BB62=\"\",\"\",+BB62/$E62)","v":""},null,{"$f":"IF(BD62=\"\",\"\",+BD62/$E62)","v":""},null,null,null,null,"In %",null,null,null,{"$f":"IF(BM62=\"\",\"\",+BM62/$E62)","v":""},null,{"$f":"IF(BO62=\"\",\"\",+BO62/$E62)","v":""},null,{"$f":"IF(BQ62=\"\",\"\",+BQ62/$E62)","v":""},null,{"$f":"IF(BS62=\"\",\"\",+BS62/$E62)","v":""},null,{"$f":"IF(BU62=\"\",\"\",+BU62/$E62)","v":""},null,{"$f":"IF(BW62=\"\",\"\",+BW62/$E62)","v":""}]
[]
[]
[null,"Umsatz",null,null,{"$f":"IF(SUM(G66:AG66)=0,\"\",(SUM(G66:AG66)))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B66","v":"Umsatz"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B66","v":"Umsatz"},null,null,{"$f":"E66","v":""},null,{"$f":"G66","v":0},null,{"$f":"I66","v":0},null,{"$f":"K66","v":0},0,0,0,0,null,null,null,null,{"$f":"AQ66","v":"Umsatz"},null,null,null,{"$f":"W66","v":0},null,{"$f":"Y66","v":0},0,0,0,0,0,0,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"AG66","v":0}]
[null,{"$f":"B63","v":"In %"},null,null,{"$f":"IF(E66=\"\",\"\",+E66/$E66)","v":""},null,{"$f":"IF(G66=\"\",\"\",+G66/$E66)","v":""},null,{"$f":"IF(I66=\"\",\"\",+I66/$E66)","v":""},null,{"$f":"IF(K66=\"\",\"\",+K66/$E66)","v":""},null,{"$f":"IF(M66=\"\",\"\",+M66/$E66)","v":""},null,{"$f":"IF(O66=\"\",\"\",+O66/$E66)","v":""},null,null,null,{"$f":"B67","v":"In %"},null,null,null,{"$f":"IF(W66=\"\",\"\",+W66/$E66)","v":""},null,{"$f":"IF(Y66=\"\",\"\",+Y66/$E66)","v":""},null,{"$f":"IF(AA66=\"\",\"\",+AA66/$E66)","v":""},null,{"$f":"IF(AC66=\"\",\"\",+AC66/$E66)","v":""},null,{"$f":"IF(AE66=\"\",\"\",+AE66/$E66)","v":""},null,{"$f":"IF(AG66=\"\",\"\",+AG66/$E66)","v":""},null,null,null,null,null,null,null,null,null,{"$f":"B67","v":"In %"},null,null,{"$f":"E67","v":""},null,{"$f":"G67","v":""},null,{"$f":"I67","v":""},{"$f":"J67","v":0},"",0,"",0,"",null,null,null,null,{"$f":"AQ67","v":"In %"},null,null,null,{"$f":"W67","v":""},null,"",0,"",0,"",0,"",{"$f":"AF67","v":0},{"$f":"AG67","v":""}]
[]
[null,"Immobilienertrag",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B69","v":"Immobilienertrag"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B69","v":"Immobilienertrag"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AQ69","v":"Immobilienertrag"}]
[null,"Bruttoeinnahmen Immobilien",null,null,{"$f":"SUM(G70:AG70)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"Bruttoeinnahmen Immobilien",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bruttoeinnahmen Immobilien",null,null,{"$f":"E70","v":0},null,{"$f":"G70","v":0},null,{"$f":"I70","v":0},null,{"$f":"K70","v":0},0,0,0,0,null,null,null,null,"Bruttoeinnahmen Immobilien",null,null,null,{"$f":"W70","v":0},null,{"$f":"Y70","v":0},0,0,0,0,0,0,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"AG70","v":0}]
[null,"- Unterhaltskosten",null,null,{"$f":"SUM(G71:AG71)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"- Unterhaltskosten",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"- Unterhaltskosten",null,null,0,null,{"$f":"G71","v":0},null,{"$f":"I71","v":0},null,0,0,0,0,0,null,null,null,null,"- Unterhaltskosten",null,null,null,{"$f":"W71","v":0},null,0,0,0,0,0,0,0,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"AG71","v":0}]
[null,"- Allgemeine Verwaltungskosten",null,null,{"$f":"SUM(G72:AG72)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"- Allgemeine Verwaltungskosten",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"- Allgemeine Verwaltungskosten",null,null,0,null,{"$f":"G72","v":0},null,{"$f":"I72","v":0},null,0,0,0,0,0,null,null,null,null,"- Allgemeine Verwaltungskosten",null,null,null,{"$f":"W72","v":0},null,0,0,0,0,0,0,0,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"AG72","v":0}]
[null,"- Abschreibungen",null,null,{"$f":"SUM(G73:AG73)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"- Abschreibungen",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"- Abschreibungen",null,null,0,null,{"$f":"G73","v":0},null,{"$f":"I73","v":0},null,0,0,0,0,0,null,null,null,null,"- Abschreibungen",null,null,null,{"$f":"W73","v":0},null,0,0,0,0,0,0,0,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"AG73","v":0}]
[null,"- Schuldzinsen (verteilt nach Aktiven)",null,null,{"$f":"SUM(G74:AG74)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"- Schuldzinsen (verteilt nach Aktiven)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"- Schuldzinsen (verteilt nach Aktiven)",null,null,0,null,{"$f":"G74","v":0},null,{"$f":"I74","v":0},null,0,0,0,0,0,null,null,null,null,"- Schuldzinsen (verteilt nach Aktiven)",null,null,null,{"$f":"W74","v":0},null,0,0,0,0,0,0,0,{"$f":"#REF!","v":{"$error":"#REF!"}},{"$f":"AG74","v":0}]
[null,"Netto Immobilienertrag",null,null,{"$f":"IF(SUM(E70:E74)=0,\"\",SUM(E70:E74))","v":""},null,{"$f":"IF(SUM(G70:G74)=0,\"\",SUM(G70:G74))","v":""},null,{"$f":"IF(SUM(I70:I74)=0,\"\",SUM(I70:I74))","v":""},null,{"$f":"IF(SUM(K70:K74)=0,\"\",SUM(K70:K74))","v":""},null,{"$f":"IF(SUM(M70:M74)=0,\"\",SUM(M70:M74))","v":""},null,{"$f":"IF(SUM(O70:O74)=0,\"\",SUM(O70:O74))","v":""},null,null,null,"Netto Immobilienertrag",null,null,null,{"$f":"IF(SUM(W70:W74)=0,\"\",SUM(W70:W74))","v":""},null,{"$f":"IF(SUM(Y70:Y74)=0,\"\",SUM(Y70:Y74))","v":""},null,{"$f":"IF(SUM(AA70:AA74)=0,\"\",SUM(AA70:AA74))","v":""},null,{"$f":"IF(SUM(AC70:AC74)=0,\"\",SUM(AC70:AC74))","v":""},null,{"$f":"IF(SUM(AE70:AE74)=0,\"\",SUM(AE70:AE74))","v":""},null,{"$f":"IF(SUM(AG70:AG74)=0,\"\",SUM(AG70:AG74))","v":""},null,null,null,null,null,null,null,null,null,"Netto Immobilienertrag",null,null,"",null,{"$f":"IF(SUM(AV70:AV74)=0,\"\",SUM(AV70:AV74))","v":""},null,{"$f":"IF(SUM(AX70:AX74)=0,\"\",SUM(AX70:AX74))","v":""},null,{"$f":"IF(SUM(AZ70:AZ74)=0,\"\",SUM(AZ70:AZ74))","v":""},null,{"$f":"IF(SUM(BB70:BB74)=0,\"\",SUM(BB70:BB74))","v":""},null,{"$f":"IF(SUM(BD70:BD74)=0,\"\",SUM(BD70:BD74))","v":""},null,null,null,null,"Netto Immobilienertrag",null,null,null,{"$f":"IF(SUM(BM70:BM74)=0,\"\",SUM(BM70:BM74))","v":""},null,{"$f":"IF(SUM(BO70:BO74)=0,\"\",SUM(BO70:BO74))","v":""},null,{"$f":"IF(SUM(BQ70:BQ74)=0,\"\",SUM(BQ70:BQ74))","v":""},null,{"$f":"IF(SUM(BS70:BS74)=0,\"\",SUM(BS70:BS74))","v":""},null,{"$f":"IF(SUM(BU70:BU74)=0,\"\",SUM(BU70:BU74))","v":""},null,{"$f":"IF(SUM(BW70:BW74)=0,\"\",SUM(BW70:BW74))","v":""}]
[]
[null,"Aufteilung des steuerbaren Gewinnes",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B77","v":"Aufteilung des steuerbaren Gewinnes"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B77","v":"Aufteilung des steuerbaren Gewinnes"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"AQ77","v":"Aufteilung des steuerbaren Gewinnes"}]
[null,"Steuerbarer Reingewinn",null,null,{"$f":"E29","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"Bénéfice imposable",null,null,null,{"$f":"E78","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Steuerbarer Reingewinn",null,null,{"$f":"E78","v":0}]
[null,"- Nettogewinn aus Liegenschaften",null,null,{"$f":"IF(E75<0,\"\",IF(E75=\"\",\"\",-E75))","v":""},null,null,null,null,null,null,null,null,null,null,null,null,null,"- Rendement net des immeubles",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"- Nettogewinn aus Liegenschaften",null,null,""]
[null,"zu verteilender Gewinn",null,null,{"$f":"IF(E78=\"\",\"\",SUM(E78:E79))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"Bénéfice à répartir",null,null,null,{"$f":"IF(W78=\"\",\"\",SUM(W78:W79))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"zu verteilender Gewinn",null,null,0]
[null,"Vorausanteil in %",null,null,{"$f":"IF(D81=\"\",\"\",+E80*-D81)","v":""},null,{"$f":"IF(E81=\"\",\"\",-E81)","v":""},null," ",null," ",null," ",null," ",null,null,null,{"$f":"B81","v":"Vorausanteil in %"},null,{"$f":"D81","v":0},null,null,null," ",null," ",null," ",null," ",null," ",null,null,null,null,null,null,null,null,null,"Vorausanteil in %",null,{"$f":"D81","v":0},"",null,{"$f":"G81","v":""},null,{"$f":"I81","v":" "},null,{"$f":"K81","v":" "},null,{"$f":"M81","v":" "},null,{"$f":"O81","v":" "},null,null,null,null,{"$f":"AQ81","v":"Vorausanteil in %"},null,{"$f":"AS81","v":0},null,{"$f":"W81","v":0},null,{"$f":"Y81","v":" "},null,{"$f":"AA81","v":" "},null,{"$f":"AC81","v":" "},null,{"$f":"AE81","v":" "},null,{"$f":"AG81","v":" "}]
[null,"Quoten",null,null,{"$f":"IF(E80=\"\",\"\",SUM(E80:E81))","v":0},null,{"$f":"IF(AND(G63=\"\",G67=\"\"),\"\",IF(G63=\"\",$E82*G67,$E82*G63))","v":""},null,{"$f":"IF(AND(I63=\"\",I67=\"\"),\"\",IF(I63=\"\",$E82*I67,$E82*I63))","v":""},null,{"$f":"IF(AND(K63=\"\",K67=\"\"),\"\",IF(K63=\"\",$E82*K67,$E82*K63))","v":""},null,{"$f":"IF(AND(M63=\"\",M67=\"\"),\"\",IF(M63=\"\",$E82*M67,$E82*M63))","v":""},null,{"$f":"IF(AND(O63=\"\",O67=\"\"),\"\",IF(O63=\"\",$E82*O67,$E82*O63))","v":""},null,null,null,"Quoten",null,null,null,{"$f":"IF(AND(W63=\"\",W67=\"\"),\"\",IF(W63=\"\",$E82*W67,$E82*W63))","v":""},null,{"$f":"IF(AND(Y63=\"\",Y67=\"\"),\"\",IF(Y63=\"\",$E82*Y67,$E82*Y63))","v":""},null,{"$f":"IF(AND(AA63=\"\",AA67=\"\"),\"\",IF(AA63=\"\",$E82*AA67,$E82*AA63))","v":""},null,{"$f":"IF(AND(AC63=\"\",AC67=\"\"),\"\",IF(AC63=\"\",$E82*AC67,$E82*AC63))","v":""},null,{"$f":"IF(AND(AE63=\"\",AE67=\"\"),\"\",IF(AE63=\"\",$E82*AE67,$E82*AE63))","v":""},null,{"$f":"IF(AND(AG63=\"\",AG67=\"\"),\"\",IF(AG63=\"\",$E82*AG67,$E82*AG63))","v":""},null,null,null,null,null,null,null,null,null,"Quoten",null,null,0,null,"",null,"",null,"",null,"",null,"",null,null,null,null,"Quoten",null,null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,"Netto Immobilienertrag",null,null,{"$f":"SUM(G83:AG83)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"Netto Immobilienertrag",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Netto Immobilienertrag",null,null,0,null,0,null,0,null,0,null,0,null,0,null,null,null,null,"Netto Immobilienertrag",null,null,null,0,null,0,null,0,null,0,null,0,null,0]
[null,"Umlage",null,null,{"$f":"SUM(G84:AG84)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"Umlage",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Umlage",null,null,0,null,0,null,0,{"$f":"IF(#REF!=\"INTERCOMMUNALE\",IF(SUM(BT81:BT84)<0,BT85,IF($AA85<0,$AA85*BT87/#REF!,\"\")),IF(SUM(AY81:AY83)>0,\"\",IF(AND(#REF!=\"INTERCANTONALE\",OR(#REF!<>\"\",#REF!<>\"\")),BT84,-SUM(AY81:AY83))))","v":{"$error":"#REF!"}},0,{"$f":"IF(#REF!=\"INTERCOMMUNALE\",IF(SUM(#REF!)<0,#REF!,IF($AA85<0,$AA85*#REF!/#REF!,\"\")),IF(SUM(BA81:BA83)>0,\"\",IF(AND(#REF!=\"INTERCANTONALE\",OR(#REF!<>\"\",#REF!<>\"\")),#REF!,-SUM(BA81:BA83))))","v":{"$error":"#REF!"}},0,null,0,null,null,null,null,"Umlage",null,null,null,0,null,0,{"$f":"IF(#REF!=\"INTERCOMMUNALE\",IF(SUM(CH81:CH84)<0,CH85,IF($AA85<0,$AA85*CH87/#REF!,\"\")),IF(SUM(BP81:BP83)>0,\"\",IF(AND(#REF!=\"INTERCANTONALE\",OR(#REF!<>\"\",#REF!<>\"\")),CH84,-SUM(BP81:BP83))))","v":{"$error":"#REF!"}},0,{"$f":"IF(#REF!=\"INTERCOMMUNALE\",IF(SUM(CJ81:CJ84)<0,CJ85,IF($AA85<0,$AA85*CJ87/#REF!,\"\")),IF(SUM(BR81:BR83)>0,\"\",IF(AND(#REF!=\"INTERCANTONALE\",OR(#REF!<>\"\",#REF!<>\"\")),CJ84,-SUM(BR81:BR83))))","v":{"$error":"#REF!"}},0,null,0,null,0]
[null,"Steuerbarer Reingewinn",null,null,{"$f":"SUM(G85:AG85)","v":0},null,{"$f":"IF(AND(SUM(G81:G84)=0,SUM(G81:G83)=0),\"\",SUM((G81:G84)))","v":""},null,{"$f":"IF(AND(SUM(I81:I84)=0,SUM(I81:I83)=0),\"\",SUM((I81:I84)))","v":""},null,{"$f":"IF(AND(SUM(K81:K84)=0,SUM(K81:K83)=0),\"\",SUM((K81:K84)))","v":""},null,{"$f":"IF(AND(SUM(M81:M84)=0,SUM(M81:M83)=0),\"\",SUM((M81:M84)))","v":""},null,{"$f":"IF(AND(SUM(O81:O84)=0,SUM(O81:O83)=0),\"\",SUM((O81:O84)))","v":""},null,null,null,"Steuerbarer Reingewinn",null,null,null,{"$f":"IF(AND(SUM(W81:W84)=0,SUM(W81:W83)=0),\"\",SUM((W81:W84)))","v":""},null,{"$f":"IF(AND(SUM(Y81:Y84)=0,SUM(Y81:Y83)=0),\"\",SUM((Y81:Y84)))","v":""},null,{"$f":"IF(AND(SUM(AA81:AA84)=0,SUM(AA81:AA83)=0),\"\",SUM((AA81:AA84)))","v":""},null,{"$f":"IF(AND(SUM(AC81:AC84)=0,SUM(AC81:AC83)=0),\"\",SUM((AC81:AC84)))","v":""},null,{"$f":"IF(AND(SUM(AE81:AE84)=0,SUM(AE81:AE83)=0),\"\",SUM((AE81:AE84)))","v":""},null,{"$f":"IF(AND(SUM(AG81:AG84)=0,SUM(AG81:AG83)=0),\"\",SUM((AG81:AG84)))","v":""},null,null,null,null,null,null,null,null,null,"Steuerbarer Reingewinn",null,null,0,null,"",null,"",null,"",null,"",null,"",null,null,null,null,"Steuerbarer Reingewinn",null,null,null,"",null,"",null,"",null,"",null,"",null,""]
[null,{"$f":"B67","v":"In %"},null,null,{"$f":"IF(OR(E85=\"\",E85=0),\"\",+E85/$E85)","v":""},null,{"$f":"IF(G85=\"\",\"\",+G85/$E85)","v":""},null,{"$f":"IF(I85=\"\",\"\",+I85/$E85)","v":""},null,{"$f":"IF(K85=\"\",\"\",+K85/$E85)","v":""},null,{"$f":"IF(M85=\"\",\"\",+M85/$E85)","v":""},null,{"$f":"IF(O85=\"\",\"\",+O85/$E85)","v":""},null,null,null,"In %",null,null,null,{"$f":"IF(W85=\"\",\"\",+W85/$E85)","v":""},null,{"$f":"IF(Y85=\"\",\"\",+Y85/$E85)","v":""},null,{"$f":"IF(AA85=\"\",\"\",+AA85/$E85)","v":""},null,{"$f":"IF(AC85=\"\",\"\",+AC85/$E85)","v":""},null,{"$f":"IF(AE85=\"\",\"\",+AE85/$E85)","v":""},null,{"$f":"IF(AG85=\"\",\"\",+AG85/$E85)","v":""},null,null,null,null,null,null,null,null,null,"In %",null,null,"",null,"",null,"",null,"",null,"",null,"",null,null,null,null,"In %",null,null,null,"",null,"",null,"",null,"",null,"",null,""]
[]
[]
[null,"Vorausanteil",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,{"$f":"B89","v":"Vorausanteil"},{"$f":"C89","v":0},"%"]
[]
[]
[null,"Bemerkungen :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Bemerkungen :",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B92","v":"Bemerkungen :"},{"$f":"C92","v":0}]
[]
[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,"Seite 2"]
[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,{"$f":"AG95","v":0}]
[]
[]
[]
[null,{"$f":"TODAY()","v":"2015-01-29"},null,null,null,null,"Unterschrift",null,null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2015-01-29"},null,null,null,null,null,{"$f":"G99","v":"Unterschrift"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2015-01-29"},null,null,null,null,{"$f":"Y99","v":"Unterschrift"},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"TODAY()","v":"2015-01-29"},null,null,null,null,null,{"$f":"AV99","v":"Unterschrift"}]
[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,"Seite 2",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,{"$f":"AG100","v":"Seite 2"}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"INTERCOMMUNALE",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,"INTERCOMMUNALE"]
[null,"INTERCANTONALE",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,"INTERCANTONALE"]