{"text_format":"1","workbook":"xlsx","n_sheets":10,"sheets":["Start","Parameter","Lohnblatt","MonatsAbrechnung","Hauptbuch","Listen","Lohnausweis","Lohnsummenliste","MA_Stamm","Lohnart"],"not_rendered":{"charts":0,"images":13,"macros":1,"external_links":0,"defined_names":67,"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":21,"n_cols":7,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,null,"hitLohn für Excel",null,null,"Menü"]
[]
[]
[]
[]
[]
[null,null,null,null,null,1,"zuletzt verwendet:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,"© Copyright: hit Treuhand GmbH, Uster, 2018"]
[null,null,null," lizenziert für: hit Treuhand GmbH"]

{"sheet":"Parameter","index":1,"n_rows":26,"n_cols":7,"rows_kept":26,"cut":false,"hidden":true,"merged":[]}
["Januar",1,"MA",100,null,null,40]
["Februar",2,"MA-Wahl-Zeile",3]
["März",3,"letzte MA-Nr",100]
["April",4,"Sortierung",2,"Name"]
["Mai",5,"Einfügemodus",false]
["Juni",6,"MA Index im Array",0,"(beginnend mit 0)"]
["Juli",7,"Kst-Nr",10]
["August",8,"Mappe geöffnet",false]
["September",9,"Anz. geöffn.Mappen",0]
["Oktober",10,"ActivateEvents",true]
["November",11,"Anz_MA",1]
["Dezember",12]
["Spezial",13]
[]
[]
["Geöffnete Mappen (max 5)",null,"Zuletz verwendete Dateien"]
["Mandant","Ref"]
["Stauber Metallbau AG 2006.hle",null,"C:\\...\\testLohn2.hle","C:\\Users\\Peter Hegelbach\\Desktop\\hitLohn3.7\\testLohn2.hle"]
["Stauber Metallbau AG 2006.hle",null,"C:\\...\\testlohn.hle","C:\\Users\\Peter Hegelbach\\Desktop\\hitLohn3.7\\testlohn.hle"]
["Orlando Duo 2005.hle",null,"C:\\...\\test_lo.hle","C:\\Users\\Peter Hegelbach\\Desktop\\hitLohn3.7\\test_lo.hle"]
["Ammann+Schmid AG 2006.hle",null,"C:\\...\\test_neu.hle","C:\\Users\\Peter Hegelbach\\Desktop\\hitLohn3.7\\test_neu.hle"]
["Ammann+Schmid AG 2006.hle",null,"C:\\...\\testlohn1.hle","C:\\Users\\Peter Hegelbach\\Desktop\\hitLohn3.7\\testlohn1.hle"]
[null,null,"C:\\...\\hit Treuhand GmbH 2015.hle","C:\\Users\\Peter Hegelbach\\Desktop\\hitLohn3.7\\hit Treuhand GmbH 2015.hle"]
[null,null,"C:\\...\\FinOps 2015.hle","C:\\Users\\Peter Hegelbach\\Desktop\\hitLohn3.7\\FinOps 2015.hle"]
[null,null,"C:\\...\\testLohn2.hle","C:\\Users\\PH\\Desktop\\hitLohn3.7\\testLohn2.hle"]
[null,null,"C:\\...\\hit Treuhand GmbH 2015.hle","C:\\Users\\PH\\Desktop\\hitLohn3.7\\hit Treuhand GmbH 2015.hle"]

{"sheet":"Lohnblatt","index":2,"n_rows":126,"n_cols":17,"rows_kept":126,"cut":false,"hidden":true,"merged":[[4,0,5,1]]}
[{"$f":"INDIRECT(ADDRESS(5,2,,,$K$3&\"Parameter\"))","v":{"$error":"#REF!"}},null,null,null,{"$f":"INDIRECT(ADDRESS($P$3,91,,,$K$3&\"Stammdaten\"))","v":{"$error":"#REF!"}},{"$f":"IF(INDIRECT(ADDRESS($P$3,90,,,$K$3&\"Stammdaten\")),INDIRECT(ADDRESS($P$3,92,,,$K$3&\"Stammdaten\")), \"------------\")","v":{"$error":"#REF!"}},{"$f":"INDIRECT(ADDRESS($P$3,55,,,$K$3&\"Stammdaten\"))","v":{"$error":"#REF!"}},{"$f":"IF(INDIRECT(ADDRESS($P$3,71,,,$K$3&\"Stammdaten\")),INDIRECT(ADDRESS(42,4,,,$K$3&\"Parameter\")),0)","v":{"$error":"#REF!"}},{"$f":"IF(INDIRECT(ADDRESS($P$3,72,,,$K$3&\"Stammdaten\")),VALUE(INDIRECT(ADDRESS(42,6,,,$K$3&\"Parameter\")))/100,0)","v":{"$error":"#REF!"}},{"$f":"IF(INDIRECT(ADDRESS(47,7,,,$K$3&\"Parameter\"))<>\"\",INDIRECT(ADDRESS(47,7,,,$K$3&\"Parameter\"))/100,0)","v":{"$error":"#REF!"}},{"$f":"IF(INDIRECT(ADDRESS(48,7,,,$K$3&\"Parameter\"))<>\"\",VALUE(INDIRECT(ADDRESS(48,7,,,$K$3&\"Parameter\"))),0)","v":{"$error":"#REF!"}},{"$f":"IF(INDIRECT(ADDRESS($P$3,93,,,$K$3&\"Stammdaten\")),INDIRECT(ADDRESS($P$3,95,,,$K$3&\"Stammdaten\")), \"------------\")","v":{"$error":"#REF!"}},{"$f":"INDIRECT(ADDRESS($P$3,94,,,$K$3&\"Stammdaten\"))","v":{"$error":"#REF!"}},null,null,{"$f":"INDIRECT(ADDRESS(8,2,,,$K$3&\"Parameter\"))","v":{"$error":"#REF!"}}]
["Lohnblatt für:",null,{"$f":"INDIRECT(ADDRESS($P$3,2,,,$K$3&\"Stammdaten\"))&\" \"&INDIRECT(ADDRESS($P$3,3,,,$K$3&\"Stammdaten\"))","v":{"$error":"#REF!"}},null,null,null,{"$f":"INDIRECT(ADDRESS($P$3,67,,,$K$3&\"Stammdaten\"))","v":{"$error":"#REF!"}},{"$f":"INDIRECT(ADDRESS($P$3,68,,,$K$3&\"Stammdaten\"))","v":{"$error":"#REF!"}},{"$f":"INDIRECT(ADDRESS($P$3,69,,,$K$3&\"Stammdaten\"))","v":{"$error":"#REF!"}},"Mandant",null,{"$f":"IF(KTGpfl=\"B\",34,33)","v":{"$error":"#REF!"}},{"$f":"IF(INDIRECT(ADDRESS($P$3,14,,,$K$3&\"Stammdaten\"))=\"w\",6,5)","v":{"$error":"#REF!"}},null,"Mitarbeiter",100]
[null,null,{"$f":"IF(INDIRECT(ADDRESS($P$3,85,,,$K$3&\"Stammdaten\"))<>\"\", INDIRECT(ADDRESS($P$3,85,,,$K$3&\"Stammdaten\")),INDIRECT(ADDRESS($P$3,12,,,$K$3&\"Stammdaten\")))","v":{"$error":"#REF!"}},null,{"$f":"INDIRECT(ADDRESS(24,4,,,$K$3&\"Parameter\"))/100","v":{"$error":"#REF!"}},{"$f":"INDIRECT(ADDRESS($P$3,22,,,$K$3&\"Stammdaten\"))/100","v":{"$error":"#REF!"}},{"$f":"INDIRECT(ADDRESS(28,4,,,$K$3&\"Parameter\"))/100","v":{"$error":"#REF!"}},{"$f":"INDIRECT(ADDRESS(29,4,,,$K$3&\"Parameter\"))/100","v":{"$error":"#REF!"}},{"$f":"INDIRECT(ADDRESS($P$3,55,,,$K$3&\"Stammdaten\"))","v":{"$error":"#REF!"}},{"$f":"INDIRECT(ADDRESS($P$3,70,,,$K$3&\"Stammdaten\"))/100","v":{"$error":"#REF!"}},{"$f":"\"[\"&K2&\"]\"","v":"[]"},{"$f":"INDIRECT(ADDRESS($P$3,27,,,$K$3&\"Stammdaten\"))","v":{"$error":"#REF!"}},{"$f":"INDIRECT(ADDRESS(31,sex,,,$K$3&\"Parameter\"))/100*INDIRECT(ADDRESS($P$3,29,,,$K$3&\"Stammdaten\"))/100","v":{"$error":"#REF!"}},{"$f":"INDIRECT(ADDRESS(44,sex,,,$K$3&\"Parameter\"))/100*INDIRECT(ADDRESS($P$3,53,,,$K$3&\"Stammdaten\"))/100","v":{"$error":"#REF!"}},{"$f":"INDIRECT(ADDRESS(L2,sex,,,$K$3&\"Parameter\"))/100*INDIRECT(ADDRESS($P$3,54,,,$K$3&\"Stammdaten\"))/100","v":{"$error":"#REF!"}},{"$f":"P2-97","v":3},{"$f":"INDIRECT(ADDRESS(45,sex,,,$K$3&\"Parameter\"))/100*INDIRECT(ADDRESS($P$3,53,,,$K$3&\"Stammdaten\"))/100","v":{"$error":"#REF!"}}]
[null,null,{"$f":"INDIRECT(ADDRESS($P$3,24,,,$K$3&\"Stammdaten\"))","v":{"$error":"#REF!"}},{"$f":"INDIRECT(ADDRESS($P$3,38,,,$K$3&\"Stammdaten\"))","v":{"$error":"#REF!"}},{"$f":"INDIRECT(ADDRESS($P$3,39,,,$K$3&\"Stammdaten\"))","v":{"$error":"#REF!"}},{"$f":"INDIRECT(ADDRESS($P$3,25,,,$K$3&\"Stammdaten\"))","v":{"$error":"#REF!"}},{"$f":"INDIRECT(ADDRESS(28,3,,,$K$3&\"Parameter\"))","v":{"$error":"#REF!"}},{"$f":"INDIRECT(ADDRESS(29,3,,,$K$3&\"Parameter\"))","v":{"$error":"#REF!"}},{"$f":"ALV2pla-ALV1pla","v":{"$error":"#REF!"}},{"$f":"INDIRECT(ADDRESS($P$3,40,,,$K$3&\"Stammdaten\"))","v":{"$error":"#REF!"}},{"$f":"INDIRECT(ADDRESS($P$3,41,,,$K$3&\"Stammdaten\"))","v":{"$error":"#REF!"}},{"$f":"INDIRECT(ADDRESS($P$3,26,,,$K$3&\"Stammdaten\"))","v":{"$error":"#REF!"}},{"$f":"INDIRECT(ADDRESS(30,3,,,$K$3&\"Parameter\"))","v":{"$error":"#REF!"}},{"$f":"INDIRECT(ADDRESS($P$3,42,,,$K$3&\"Stammdaten\"))","v":{"$error":"#REF!"}},{"$f":"INDIRECT(ADDRESS($P$3,23,,,$K$3&\"Stammdaten\"))","v":{"$error":"#REF!"}},{"$f":"IF(O4=\"A\",INDIRECT(ADDRESS(33,3,,,$K$3&\"Parameter\")),IF(O4=\"B\",INDIRECT(ADDRESS(34,3,,,$K$3&\"Parameter\")),0))","v":{"$error":"#REF!"}},{"$f":"INDIRECT(ADDRESS(44,3,,,$K$3&\"Parameter\"))-UVGpla","v":{"$error":"#REF!"}}]
[{"$f":"INDIRECT(ADDRESS(3,3,,,$K$3&\"Parameter\"))","v":{"$error":"#REF!"}},null,1,2,3,4,5,6,7,8,9,10,11,12,12]
[null,null,"Januar","Februar","März","April","Mai","Juni","Juli","August","September","Oktober","November","Dezember","Spezial","Jahrestotal"]
["Monate",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C7:O7)","v":0}]
["Monatsansatz",null,5000]
["Monatslohn",null,{"$f":"IF(ISBLANK(C7),C8,ROUND(C8*C7/5,2)*5)-IF(C43=\"x\",C47,0)","v":5000},{"$f":"IF(ISBLANK(D7),D8,ROUND(D8*D7/5,2)*5)-IF(D43=\"x\",D47,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C9:O9)","v":5000}]
["Text"]
[{"$f":"INDIRECT(ADDRESS(39,4,,,$K$3&\"Parameter\"))","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C11:O11)","v":0}]
[{"$f":"INDIRECT(ADDRESS(39,5,,,$K$3&\"Parameter\"))","v":{"$error":"#REF!"}}]
[{"$f":"INDIRECT(ADDRESS(39,3,,,$K$3&\"Parameter\"))","v":{"$error":"#REF!"}},null,{"$f":"IF(ISBLANK(C11),0,ROUND(C12*C11/5,2)*5)","v":0},{"$f":"IF(ISBLANK(D11),0,ROUND(D12*D11/5,2)*5)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C13:O13)","v":0}]
["Text"]
[{"$f":"INDIRECT(ADDRESS(40,4,,,$K$3&\"Parameter\"))","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C15:O15)","v":0}]
[{"$f":"INDIRECT(ADDRESS(40,5,,,$K$3&\"Parameter\"))","v":{"$error":"#REF!"}}]
[{"$f":"INDIRECT(ADDRESS(40,3,,,$K$3&\"Parameter\"))","v":{"$error":"#REF!"}},null,{"$f":"IF(ISBLANK(C15),C16,ROUND(C16*C15/5,2)*5)","v":0},{"$f":"IF(ISBLANK(D15),D16,ROUND(D16*D15/5,2)*5)","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C17:O17)","v":0}]
[{"$f":"INDIRECT(ADDRESS(41,4,,,$K$3&\"Parameter\"))","v":{"$error":"#REF!"}}]
[{"$f":"INDIRECT(ADDRESS(41,5,,,$K$3&\"Parameter\"))","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C19:O19)","v":0}]
[{"$f":"INDIRECT(ADDRESS(41,3,,,$K$3&\"Parameter\"))","v":{"$error":"#REF!"}},null,{"$f":"ROUND(C19*C18/5,2)*5","v":0},{"$f":"ROUND(D19*D18/5,2)*5","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["Ferien-Entschädigung",null,{"$f":"IF(Ans_FE=0,0,ROUND(Ans_FE*(IF($G$2,C9,0)+IF($H$2,C13,0)+IF($I$2,C17,0))/5,2)*5)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM(C21:O21)","v":{"$error":"#REF!"}}]
["Feiertage-Entschädig.",null,{"$f":"IF(Ans_FTE=0,0,ROUND(Ans_FTE*(IF($G$2,C9,0)+IF($H$2,C13,0)+IF($I$2,C17,0))/5,2)*5)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["VR-Honorar",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C23:O23)","v":0}]
["Bonus",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Gratifikation",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C25:O25)","v":0}]
["13. Monatslohn",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Freier Lohn","Betrag",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Text"]
["Uebrige Löhne",null,{"$f":"SUM(C21:C27)","v":{"$error":"#REF!"}},{"$f":"SUM(D21:D27)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUM(F21:F27)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM(N21:N27)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
["Total Lohn",null,{"$f":"C9+C13+C17+C20+C29","v":{"$error":"#REF!"}},{"$f":"D9+D13+D17+D20+D29","v":{"$error":"#REF!"}},{"$f":"E9+E13+E17+E20+E29","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["Kinderzulagen",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C31:O31)","v":0}]
["Wegvergütungen",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Trinkgelder",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"INDIRECT(ADDRESS(50,7,,,$K$3&\"Parameter\"))","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Dienstalt.gesch.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Heirats-+Geb.zul.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Kaufpeis GW"]
["Privatanteil GW",null,{"$f":"IF(C37<>\"\",MAX(ROUNDDOWN(C37*$J$1,0),$K$1),0)","v":0},{"$f":"IF(D37<>\"\",MAX(ROUNDDOWN(D37*$J$1,0),$K$1),0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0]
["Freie Z.","Betrag",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Text",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Total Zulagen",null,{"$f":"SUM(C31:C36)+C38+C39","v":0},{"$f":"SUM(D31:D36)+D38+D39","v":0},0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(C41:O41)","v":0}]
["Taggeld","Text"]
[null,"ausweis."]
["x","Soz.l.korr."]
[null,"AHV-pfl."]
[null,"UVG-pfl."]
["Taggeld","Betrag",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C47:O47)","v":0}]
["Brutto",null,{"$f":"+C30+C41+IF(C43=\"x\",C47,0)","v":{"$error":"#REF!"}},{"$f":"+D30+D41+IF(D43=\"x\",D47,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM(C48:O48)","v":{"$error":"#REF!"}}]
["AHV-pfl.","normal",{"$f":"C48-C31-C36-IF(C45=\"x\",0,C47)","v":{"$error":"#REF!"}},{"$f":"D48-D31-D36-IF(D45=\"x\",0,D47)","v":{"$error":"#REF!"}},{"$f":"E48-E31-E36-IF(E45=\"x\",0,E47)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM(C49:O49)","v":{"$error":"#REF!"}}]
["Rentner-Freibetrag",null,{"$f":"IF(Rentenmo=1,IF(C49<>0,MIN(INDIRECT(ADDRESS(25,3,,,$K$3&\"Parameter\")),C49),0),0)","v":{"$error":"#REF!"}},{"$f":"IF(OR(Rentenmo>D5,D49=0),0,MIN((D5-Rentenmo+1)*INDIRECT(ADDRESS(25,3,,,$K$3&\"Parameter\")),SUM(INDIRECT(ADDRESS(49,COLUMN())):INDIRECT(ADDRESS(49,Rentenmo+2))))-IF(D5>Rentenmo,SUM(INDIRECT(ADDRESS(50,Rentenmo+2)):INDIRECT(ADDRESS(50,COLUMN()-1)),0)))","v":{"$error":"#REF!"}},{"$f":"IF(OR(Rentenmo>E5,E49=0),0,MIN((E5-Rentenmo+1)*INDIRECT(ADDRESS(25,3,,,$K$3&\"Parameter\")),SUM(INDIRECT(ADDRESS(49,COLUMN())):INDIRECT(ADDRESS(49,Rentenmo+2))))-IF(E5>Rentenmo,SUM(INDIRECT(ADDRESS(50,Rentenmo+2)):INDIRECT(ADDRESS(50,COLUMN()-1)),0)))","v":{"$error":"#REF!"}},{"$f":"IF(OR(Rentenmo>F5,F49=0),0,MIN((F5-Rentenmo+1)*INDIRECT(ADDRESS(25,3,,,$K$3&\"Parameter\")),SUM(INDIRECT(ADDRESS(49,COLUMN())):INDIRECT(ADDRESS(49,Rentenmo+2))))-IF(F5>Rentenmo,SUM(INDIRECT(ADDRESS(50,Rentenmo+2)):INDIRECT(ADDRESS(50,COLUMN()-1)),0)))","v":{"$error":"#REF!"}},{"$f":"IF(OR(Rentenmo>G5,G49=0),0,MIN((G5-Rentenmo+1)*INDIRECT(ADDRESS(25,3,,,$K$3&\"Parameter\")),SUM(INDIRECT(ADDRESS(49,COLUMN())):INDIRECT(ADDRESS(49,Rentenmo+2))))-IF(G5>Rentenmo,SUM(INDIRECT(ADDRESS(50,Rentenmo+2)):INDIRECT(ADDRESS(50,COLUMN()-1)),0)))","v":{"$error":"#REF!"}},{"$f":"IF(OR(Rentenmo>H5,H49=0),0,MIN((H5-Rentenmo+1)*INDIRECT(ADDRESS(25,3,,,$K$3&\"Parameter\")),SUM(INDIRECT(ADDRESS(49,COLUMN())):INDIRECT(ADDRESS(49,Rentenmo+2))))-IF(H5>Rentenmo,SUM(INDIRECT(ADDRESS(50,Rentenmo+2)):INDIRECT(ADDRESS(50,COLUMN()-1)),0)))","v":{"$error":"#REF!"}},{"$f":"IF(OR(Rentenmo>I5,I49=0),0,MIN((I5-Rentenmo+1)*INDIRECT(ADDRESS(25,3,,,$K$3&\"Parameter\")),SUM(INDIRECT(ADDRESS(49,COLUMN())):INDIRECT(ADDRESS(49,Rentenmo+2))))-IF(I5>Rentenmo,SUM(INDIRECT(ADDRESS(50,Rentenmo+2)):INDIRECT(ADDRESS(50,COLUMN()-1)),0)))","v":{"$error":"#REF!"}},{"$f":"IF(OR(Rentenmo>J5,J49=0),0,MIN((J5-Rentenmo+1)*INDIRECT(ADDRESS(25,3,,,$K$3&\"Parameter\")),SUM(INDIRECT(ADDRESS(49,COLUMN())):INDIRECT(ADDRESS(49,Rentenmo+2))))-IF(J5>Rentenmo,SUM(INDIRECT(ADDRESS(50,Rentenmo+2)):INDIRECT(ADDRESS(50,COLUMN()-1)),0)))","v":{"$error":"#REF!"}},{"$f":"IF(OR(Rentenmo>K5,K49=0),0,MIN((K5-Rentenmo+1)*INDIRECT(ADDRESS(25,3,,,$K$3&\"Parameter\")),SUM(INDIRECT(ADDRESS(49,COLUMN())):INDIRECT(ADDRESS(49,Rentenmo+2))))-IF(K5>Rentenmo,SUM(INDIRECT(ADDRESS(50,Rentenmo+2)):INDIRECT(ADDRESS(50,COLUMN()-1)),0)))","v":{"$error":"#REF!"}},{"$f":"IF(OR(Rentenmo>L5,L49=0),0,MIN((L5-Rentenmo+1)*INDIRECT(ADDRESS(25,3,,,$K$3&\"Parameter\")),SUM(INDIRECT(ADDRESS(49,COLUMN())):INDIRECT(ADDRESS(49,Rentenmo+2))))-IF(L5>Rentenmo,SUM(INDIRECT(ADDRESS(50,Rentenmo+2)):INDIRECT(ADDRESS(50,COLUMN()-1)),0)))","v":{"$error":"#REF!"}},{"$f":"IF(OR(Rentenmo>M5,M49=0),0,MIN((M5-Rentenmo+1)*INDIRECT(ADDRESS(25,3,,,$K$3&\"Parameter\")),SUM(INDIRECT(ADDRESS(49,COLUMN())):INDIRECT(ADDRESS(49,Rentenmo+2))))-IF(M5>Rentenmo,SUM(INDIRECT(ADDRESS(50,Rentenmo+2)):INDIRECT(ADDRESS(50,COLUMN()-1)),0)))","v":{"$error":"#REF!"}},{"$f":"IF(OR(Rentenmo>N5,N49=0),0,MIN((N5-Rentenmo+1)*INDIRECT(ADDRESS(25,3,,,$K$3&\"Parameter\")),SUM(INDIRECT(ADDRESS(49,COLUMN())):INDIRECT(ADDRESS(49,Rentenmo+2))))-IF(N5>Rentenmo,SUM(INDIRECT(ADDRESS(50,Rentenmo+2)):INDIRECT(ADDRESS(50,COLUMN()-1)),0)))","v":{"$error":"#REF!"}},{"$f":"IF(OR(Rentenmo>O5,O49=0),0,MIN((O5-Rentenmo+1)*INDIRECT(ADDRESS(25,3,,,$K$3&\"Parameter\")),SUM(INDIRECT(ADDRESS(49,COLUMN())):INDIRECT(ADDRESS(49,Rentenmo+2))))-IF(O5>Rentenmo,SUM(INDIRECT(ADDRESS(50,Rentenmo+2)):INDIRECT(ADDRESS(50,COLUMN()-1)),0)))","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["AHV-Basis",null,{"$f":"IF(AHVpfl,IF(AHVbeginn,C49-C50,0),0)","v":{"$error":"#REF!"}},{"$f":"IF(AHVpfl,IF(AHVbeginn,D49-D50,0),0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["ALV1-Basis",null,{"$f":"IF(AND(ALVpfl,C5<Rentenmo),MIN(ALV1pla*1,C51),0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(ALVpfl,D5<Rentenmo,D51<>0),MIN((MIN(AustrittMonat,D5)-EintrittMonat+1)*ALV1pla-C53,+D51+C55),0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(ALVpfl,E5<Rentenmo,E51<>0),MIN((MIN(AustrittMonat,E5)-EintrittMonat+1)*ALV1pla-D53,+E51+D55),0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["ALV1-Kum",null,{"$f":"C52","v":{"$error":"#REF!"}},{"$f":"C53+D52","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"L53+M52","v":{"$error":"#REF!"}},{"$f":"M53+N52","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
["ALV2-Basis",null,{"$f":"IF(AND(ALVpfl,C5<Rentenmo),MIN(ALV21pla,C51-C52),0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(ALVpfl,D5<Rentenmo,D51<>0),MIN((MIN(AustrittMonat,D5)-EintrittMonat+1)*ALV21pla-C55,+D51-D52+C56),0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["ALV2-Kum",null,{"$f":"C54","v":{"$error":"#REF!"}},{"$f":"C55+D54","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"M55+N54","v":{"$error":"#REF!"}},{"$f":"N55+O54","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["ALV-frei (kum)",null,{"$f":"MAX(0,C51-C52-C54)","v":{"$error":"#REF!"}},{"$f":"C56+D51-D52-D54","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["UVG-pfl.","normal",{"$f":"C48-C31-C36-IF(C46=\"x\",0,C47)","v":{"$error":"#REF!"}},{"$f":"D48-D31-D36-IF(D46=\"x\",0,D47)","v":{"$error":"#REF!"}},{"$f":"E48-E31-E36-IF(E46=\"x\",0,E47)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["UVG-Basis",null,{"$f":"IF(AND(UVGpfl,C57<>0),MIN((MIN(AustrittMonat,C5)-EintrittMonat+1)*UVGpla,+C57),0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(UVGpfl,D57<>0),MIN((MIN(AustrittMonat,D5)-EintrittMonat+1)*UVGpla-C59,+D57+C60),0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["UVG-Kum",null,{"$f":"C58","v":{"$error":"#REF!"}},{"$f":"C59+D58","v":{"$error":"#REF!"}},{"$f":"D59+E58","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"L59+M58","v":{"$error":"#REF!"}},{"$f":"M59+N58","v":{"$error":"#REF!"}},{"$f":"N59+O58","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["UVG-frei (kum)",null,{"$f":"C57-C58","v":{"$error":"#REF!"}},{"$f":"D57+C60-D58","v":{"$error":"#REF!"}},{"$f":"E57+D60-E58","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["KrV-pfl.","normal",{"$f":"C48-C31-C36-IF(C45=\"x\",0,C47)-IF($B$62,C23,0)","v":{"$error":"#REF!"}},{"$f":"D48-D31-D36-IF(D45=\"x\",0,D47)-IF($B$62,D23,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["KrV-Basis",{"$f":"INDIRECT(ADDRESS(34,9,,,$K$3&\"Parameter\"))=1","v":{"$error":"#REF!"}},{"$f":"IF(AND(KTGpfl,C61<>0),MIN((MIN(AustrittMonat,C5)-EintrittMonat+1)*KTGpla,+C61),0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(KTGpfl,D61<>0),MIN((MIN(AustrittMonat,D5)-EintrittMonat+1)*KTGpla-C63,+D61+C64),0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["KrV-Kum",null,{"$f":"C62","v":{"$error":"#REF!"}},{"$f":"C63+D62","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["KrV-frei (kum)",null,{"$f":"C61-C62","v":{"$error":"#REF!"}},{"$f":"D61+C64-D62","v":{"$error":"#REF!"}},{"$f":"E61+D64-E62","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["AHV-Beitrag",null,{"$f":"ROUND(C51*AHVsatz/5,2)*5","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM(C65:O65)","v":{"$error":"#REF!"}}]
["ALV1-Beitrag",null,{"$f":"ROUND(C52*ALV1satz/5,2)*5","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["ALV2-Beitrag",null,{"$f":"ROUND(C54*ALV2satz/5,2)*5","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["NBUV-Beitrag",null,{"$f":"IF(NBUVpfl,ROUND(C58*NBUVsatz/5,2)*5,0)","v":{"$error":"#REF!"}},{"$f":"IF(NBUVpfl,ROUND(D58*NBUVsatz/5,2)*5,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["UVGZ-Beitrag",null,{"$f":"ROUND((C122*UVGZsatz+C124*UVGZ_satz2)/5,2)*5","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"ROUND((O122*UVGZsatz+O124*UVGZ_satz2)/5,2)*5","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["KTG-Beitrag",null,{"$f":"ROUND(C62*KTGsatz/5,2)*5","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"ROUND(O62*KTGsatz/5,2)*5","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["BVG gesamt",null,400,null,null,null,null,null,null,null,null,null,null,null,null,400]
["BVG-Beitrag (AN)",null,{"$f":"ROUND(C71*IF(MID(BVG_Monat,C5,1)=\"x\",BVG_2Satz,BVGproz)/100/5,2)*5","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"ROUND(O71*BVGproz/100/5,2)*5","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["Quellensteuer",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"INDIRECT(ADDRESS(42,3,,,$K$3&\"Parameter\"))","v":{"$error":"#REF!"}},null,{"$f":"IF(C48<>0,IF(MID(GAV2Monat,C5,1)=\"x\",VALUE($M$1),VALUE($H$1)),0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},null,{"$error":"#REF!"}]
[{"$f":"INDIRECT(ADDRESS(42,5,,,$K$3&\"Parameter\"))","v":{"$error":"#REF!"}},null,{"$f":"IF(C48<>0,ROUND($I$1*C51/5,2)*5,0)","v":{"$error":"#REF!"}},{"$f":"IF(D48<>0,ROUND($I$1*D51/5,2)*5,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM(C75:O75)","v":{"$error":"#REF!"}}]
["Freier Abzug",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Text",null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
["Ausgl.Naturallohn",null,{"$f":"IF(C48<>0,IF(INDIRECT(ADDRESS($P$3,76,,,$K$3&\"Stammdaten\")),C33+C34,-ROUND((SUM(C65:C70)+C75+C73)*((C33+C34)/C48)/5,2)*5+C33+C34),0)","v":{"$error":"#REF!"}},{"$f":"IF(D48<>0,IF(INDIRECT(ADDRESS($P$3,76,,,$K$3&\"Stammdaten\")),D34,-ROUND((SUM(D65:D70)+D75+D73)*((D33+D34)/D48)/5,2)*5+D33+D34),0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM(C78:O78)","v":{"$error":"#REF!"}}]
["Ausgl.Privatanteil",null,{"$f":"IF(C48<>0,IF(INDIRECT(ADDRESS($P$3,77,,,$K$3&\"Stammdaten\")),C38,-ROUND((SUM(C65:C70)+C75+C73)*(C38/C48)/5,2)*5+C38),0)","v":{"$error":"#REF!"}},{"$f":"IF(D48<>0,IF(INDIRECT(ADDRESS($P$3,77,,,$K$3&\"Stammdaten\")),D38,-ROUND((SUM(D65:D70)+D75+D73)*(D38/D48)/5,2)*5+D38),0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM(C79:O79)","v":{"$error":"#REF!"}}]
["Total Abzüge",null,{"$f":"SUM(C65:C76)-C71+C78+C79","v":{"$error":"#REF!"}},{"$f":"SUM(D65:D76)-D71+D78+D79","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM(C80:O80)","v":{"$error":"#REF!"}}]
["Nettolohn",null,{"$f":"ROUND(C48-C80,2)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"ROUND(O48-O80,2)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["Pau.spes.","Repräsent.",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Pau.spes.","Auto",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Pau.spes.","Reise",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Pau.spes.","Andere",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Text"]
["eS1/RVÜ","Betrag",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Text"]
[null,"ü.Lohnabr."]
["eS2/Übr","Betrag",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Text"]
[null,"ü.Lohnabr."]
[{"$f":"INDIRECT(ADDRESS(64,3,,,$K$3&\"Parameter\"))","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C93:O93)","v":0}]
["Auszahlung",null,{"$f":"SUM(C81:C85)+IF(C89=\"x\",C87,0)+IF(C92=\"x\",C90,0)+C93","v":{"$error":"#REF!"}},{"$f":"SUM(D81:D85)+IF(D89=\"x\",D87,0)+IF(D92=\"x\",D90,0)+D93","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"SUM(C94:O94)","v":{"$error":"#REF!"}}]
["Umlenkung","Betrag",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Text",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"INDIRECT(ADDRESS(62,3,,,$K$3&\"Parameter\"))","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Bank/Post 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
["Bank/Post 1",null,{"$f":"ROUND(C94-C95-C97-C98,2)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"ROUND(O94-O95-O97-O98,2)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["Ferien","Anspruch +/-",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"  Text"]
[null,"Anspr. Saldo",{"$f":"INDIRECT(ADDRESS($P$3,32,,,$K$3&\"Stammdaten\"))+C100+IF(INDIRECT(ADDRESS($P$3,74,,,$K$3&\"Stammdaten\"))=TRUE,MAX(0,INDIRECT(ADDRESS($P$3,30,,,$K$3&\"Stammdaten\"))),0)","v":{"$error":"#REF!"}},{"$f":"C102+D100","v":{"$error":"#REF!"}},{"$f":"D102+E100","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"O102","v":{"$error":"#REF!"}}]
[null,"Bezug +/-",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C103:O103)","v":0}]
[null,"  Text",null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"Bezug Saldo",{"$f":"C103","v":0},{"$f":"C105+D103","v":0},{"$f":"D105+E103","v":0},0,0,0,0,0,0,0,0,0,0,{"$f":"O105","v":0}]
["Ferien","Saldo",{"$f":"C102+C105","v":{"$error":"#REF!"}},{"$f":"D102+D105","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"O106","v":{"$error":"#REF!"}}]
[{"$f":"IF(A108=TRUE,\"geleist.\",\"Zeit\")","v":{"$error":"#REF!"}},"+/-",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C107:O107)","v":0}]
[{"$f":"INDIRECT(ADDRESS($P$3,84,,,$K$3&\"Stammdaten\"))","v":{"$error":"#REF!"}},{"$f":"IF(A108=TRUE,\"Sollzeit\",\"komp.\")","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(C108:O108)","v":0}]
[null,"  Text"]
[{"$f":"IF(A108=TRUE,\"K JAZ\",\"Zeit\")","v":{"$error":"#REF!"}},"Saldo",{"$f":"INDIRECT(ADDRESS($P$3,35,,,$K$3&\"Stammdaten\"))+C107+C108","v":{"$error":"#REF!"}},{"$f":"C110+D107+D108","v":{"$error":"#REF!"}},{"$f":"D110+E107+E108","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"L110+M107+M108","v":{"$error":"#REF!"}},{"$f":"M110+N107+N108","v":{"$error":"#REF!"}},{"$f":"N110+O107+O108","v":{"$error":"#REF!"}},{"$f":"O110","v":{"$error":"#REF!"}}]
["Bemerkung"]
["AHV-Beitrag (AG)",{"$f":"INDIRECT(ADDRESS(24,5,,,$K$3&\"Parameter\"))/100","v":{"$error":"#REF!"}},{"$f":"ROUND(C51*$B$112/5,2)*5","v":{"$error":"#REF!"}},{"$f":"ROUND(D51*$B$112/5,2)*5","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"ROUND(O51*$B$112/5,2)*5","v":{"$error":"#REF!"}},{"$f":"SUM(C112:O112)","v":{"$error":"#REF!"}}]
["ALV1-Beitrag (AG)",{"$f":"INDIRECT(ADDRESS(28,5,,,$K$3&\"Parameter\"))/100","v":{"$error":"#REF!"}},{"$f":"ROUND(C52*$B$113/5,2)*5","v":{"$error":"#REF!"}},{"$f":"ROUND(D52*$B$113/5,2)*5","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"ROUND(O52*$B$113/5,2)*5","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["ALV2-Beitrag (AG)",{"$f":"INDIRECT(ADDRESS(29,5,,,$K$3&\"Parameter\"))/100","v":{"$error":"#REF!"}},{"$f":"ROUND(C54*$B$114/5,2)*5","v":{"$error":"#REF!"}},{"$f":"ROUND(D54*$B$114/5,2)*5","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"ROUND(O54*$B$114/5,2)*5","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["BU-Beitrag (AG)",{"$f":"INDIRECT(ADDRESS(30,sex,,,$K$3&\"Parameter\"))/100","v":{"$error":"#REF!"}},{"$f":"ROUND(C58*$B$115/5,2)*5","v":{"$error":"#REF!"}},{"$f":"ROUND(D58*$B$115/5,2)*5","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"ROUND(O58*$B$115/5,2)*5","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["NBUV-Beitrag (AG)",{"$f":"INDIRECT(ADDRESS(31,sex,,,$K$3&\"Parameter\"))/100","v":{"$error":"#REF!"}},{"$f":"IF(NBUVpfl,ROUND(C58*$B$116/5,2)*5-C68,0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["UVGZ-Beitrag (AG)",{"$f":"INDIRECT(ADDRESS(44,sex,,,$K$3&\"Parameter\"))/100","v":{"$error":"#REF!"}},{"$f":"ROUND((C122*$B$117+C124*$B$126)/5,2)*5-C69","v":{"$error":"#REF!"}},{"$f":"ROUND((D122*$B$117+D124*$B$126)/5,2)*5-D69","v":{"$error":"#REF!"}},{"$f":"ROUND((E122*$B$117+E124*$B$126)/5,2)*5-E69","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["KTG-Beitrag (AG)",{"$f":"IF(O4=\"A\",INDIRECT(ADDRESS(33,sex,,,$K$3&\"Parameter\"))/100,IF(O4=\"B\",INDIRECT(ADDRESS(34,sex,,,$K$3&\"Parameter\"))/100,0))","v":{"$error":"#REF!"}},{"$f":"ROUND(C62*$B$118/5,2)*5-C70","v":{"$error":"#REF!"}},{"$f":"ROUND(D62*$B$118/5,2)*5-D70","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["BVG-Beitrag (AG)",null,{"$f":"C71-C72","v":{"$error":"#REF!"}},{"$f":"D71-D72","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"O71-O72","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["FAK",{"$f":"INDIRECT(ADDRESS(27,5,,,$K$3&\"Parameter\"))/100","v":{"$error":"#REF!"}},{"$f":"ROUND(C51*$B$120/5,2)*5","v":{"$error":"#REF!"}},{"$f":"ROUND(D51*$B$120/5,2)*5","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$f":"ROUND(O51*$B$120/5,2)*5","v":{"$error":"#REF!"}},{"$f":"SUM(C120:O120)","v":{"$error":"#REF!"}}]
["Verw.ko.",{"$f":"INDIRECT(ADDRESS(14,3,,,$K$3&\"Parameter\"))/100","v":{"$error":"#REF!"}},{"$f":"ROUND((C65+C112)*$B$121/5,2)*5","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["UVGZ-UVG-Basis",null,{"$f":"IF(AND(UVGZpfl,C57<>0),MIN((MIN(AustrittMonat,C5)-EintrittMonat+1)*UVGpla,+C57),0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(UVGZpfl,D57<>0),MIN((MIN(AustrittMonat,D5)-EintrittMonat+1)*UVGpla-C123,+D57+C125),0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(UVGZpfl,E57<>0),MIN((MIN(AustrittMonat,E5)-EintrittMonat+1)*UVGpla-D123,+E57+D125),0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["UVGZ-UVG-kum",null,{"$f":"C122","v":{"$error":"#REF!"}},{"$f":"C123+D122","v":{"$error":"#REF!"}},{"$f":"D123+E122","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["UVGZ-UEL-Basis",null,{"$f":"IF(AND(UVGZpfl,C57<>0),MIN((MIN(AustrittMonat,C5)-EintrittMonat+1)*UVGZpla,+C57-C122),0)","v":{"$error":"#REF!"}},{"$f":"IF(AND(UVGZpfl,D57<>0),MIN((MIN(AustrittMonat,D5)-EintrittMonat+1)*UVGZpla-C125,+D57-D122+C126),0)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["UVGZ-UEL-kum",null,{"$f":"C124","v":{"$error":"#REF!"}},{"$f":"C125+D124","v":{"$error":"#REF!"}},{"$f":"D125+E124","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
["UVGZ-frei",{"$f":"INDIRECT(ADDRESS(45,sex,,,$K$3&\"Parameter\"))/100","v":{"$error":"#REF!"}},{"$f":"MAX(0,C57-C122-C124)","v":{"$error":"#REF!"}},{"$f":"MAX(0,D57-D122-D124)","v":{"$error":"#REF!"}},{"$f":"MAX(0,E57-E122-E124)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]

{"sheet":"MonatsAbrechnung","index":3,"n_rows":87,"n_cols":10,"rows_kept":87,"cut":false,"hidden":true,"merged":[[72,6,85,8]]}
[]
[null,{"$f":"IF($A$10,INDIRECT(ADDRESS(5,2,,,$I$4&\"Parameter\")),\"\")","v":{"$error":"#REF!"}},null,null,null,null,{"$f":"IF(A10,IF(ISBLANK(F2),J2,F2) & \", \" &IF(ISBLANK(F3),J5,F3),\"\")","v":{"$error":"#REF!"}},null,null,{"$f":"INDIRECT(ADDRESS(8,2,,,$I$4&\"Parameter\"))","v":{"$error":"#REF!"}}]
[null,{"$f":"IF($A$10,IF($B$6,INDIRECT(ADDRESS(7,2,,,$I$4&\"Parameter\")),INDIRECT(ADDRESS(6,2,,,$I$4&\"Parameter\"))),\"\")","v":{"$error":"#REF!"}},null,null,null,"24. Januar 2019",{"$f":"DATE(INDIRECT(ADDRESS(3,3,,,$I$4&\"Parameter\")),MIN(A9,12),INDIRECT(ADDRESS(3,7,,,$I$4&\"Parameter\")))","v":{"$error":"#REF!"}},{"$f":"WEEKDAY(G3,2)","v":{"$error":"#REF!"}},{"$f":"INDIRECT(ADDRESS(A9,1,,,\"Parameter\"))","v":"September"},{"$f":"INDIRECT(ADDRESS(43,3,,,$I$4&\"Parameter\"))","v":{"$error":"#REF!"}}]
[null,{"$f":"IF($A$10,IF($B$6,INDIRECT(ADDRESS(8,3,,,$I$4&\"Parameter\"))&\" \"&INDIRECT(ADDRESS(8,2,,,$I$4&\"Parameter\")),INDIRECT(ADDRESS(7,2,,,$I$4&\"Parameter\"))),\"\")","v":{"$error":"#REF!"}},null,null,null,true,{"$f":"IF(H4=\"b\",G3-MAX(H3-5,0),IF(H4=\"f\",G3+IF(H3=6,2,IF(H3=7,1,0)),G3))","v":{"$error":"#REF!"}},{"$f":"INDIRECT(ADDRESS(5,7,,,$I$4&\"Parameter\"))","v":{"$error":"#REF!"}},{"$f":"Lohnblatt!K3","v":"[]"},{"$f":"INDIRECT(ADDRESS(3,3,,,$I$4&\"Parameter\"))","v":{"$error":"#REF!"}}]
[null,{"$f":"IF($A$10,IF($B$6,\"\",INDIRECT(ADDRESS(8,3,,,$I$4&\"Parameter\"))&\" \"&INDIRECT(ADDRESS(8,2,,,$I$4&\"Parameter\"))),\"\")","v":{"$error":"#REF!"}},null,null,null,{"$f":"INDIRECT(ADDRESS(50,3,,,$I$4&\"Parameter\"))","v":{"$error":"#REF!"}},{"$f":"INDIRECT(ADDRESS(49,3,,,$I$4&\"Parameter\"))","v":{"$error":"#REF!"}},{"$f":"INDIRECT(ADDRESS(49,6,,,$I$4&\"Parameter\"))","v":{"$error":"#REF!"}},{"$f":"IF(INDIRECT(ADDRESS(63,3,,,$I$4&\"Parameter\")),IF(INDIRECT(ADDRESS($J$9,85,,,$I$4&\"Stammdaten\"))<>\"\",INDIRECT(ADDRESS($J$9,85,,,$I$4&\"Stammdaten\")),INDIRECT(ADDRESS($J$9,12,,,$I$4&\"Stammdaten\"))),\"\")","v":{"$error":"#REF!"}},{"$f":"IF(G5,TEXT(G4,\"T. MMMM JJJJ\"),TEXT(TODAY(), \"T. MMMM JJJJ\"))","v":{"$error":"#REF!"}}]
[null,{"$f":"IF(OR(ISBLANK(INDIRECT(ADDRESS(6,2,,,$I$4&\"Parameter\"))),INDIRECT(ADDRESS(6,2,,,$I$4&\"Parameter\"))=\"\"),TRUE,FALSE)","v":{"$error":"#REF!"}},null,null,null,{"$f":"INDIRECT(ADDRESS(51,3,,,$I$4&\"Parameter\"))","v":{"$error":"#REF!"}},{"$f":"J2","v":{"$error":"#REF!"}},null,{"$f":"A8+99","v":106}]
[1,{"$f":"IF(F5,INDIRECT(ADDRESS($J$9,101,,,$I$4&\"Stammdaten\")),\"\")","v":{"$error":"#REF!"}},null,null,null,null,{"$f":"IF(F5,\"\",INDIRECT(ADDRESS($J$9,101,,,$I$4&\"Stammdaten\")))","v":{"$error":"#REF!"}}]
[7,{"$f":"IF($F$5,INDIRECT(ADDRESS($J$9,4,,,$I$4&\"Stammdaten\")),\"\")","v":{"$error":"#REF!"}},null,null,null,null,{"$f":"IF(F5,\"\",INDIRECT(ADDRESS($J$9,4,,,$I$4&\"Stammdaten\")))","v":{"$error":"#REF!"}}]
[9,{"$f":"IF(AdresseLinks,IF(NameZuerst=TRUE,INDIRECT(ADDRESS($J$9,2,,,$I$4&\"Stammdaten\"))&\" \"&INDIRECT(ADDRESS($J$9,3,,,$I$4&\"Stammdaten\")),INDIRECT(ADDRESS($J$9,3,,,$I$4&\"Stammdaten\"))&\" \"&INDIRECT(ADDRESS($J$9,2,,,$I$4&\"Stammdaten\"))),\"\")","v":{"$error":"#REF!"}},null,null,{"$f":"INDIRECT(ADDRESS($J$9,3,,,$I$4&\"Stammdaten\"))","v":{"$error":"#REF!"}},null,{"$f":"IF(AdresseLinks,\"\",IF(NameZuerst=TRUE,INDIRECT(ADDRESS($J$9,2,,,$I$4&\"Stammdaten\"))&\" \"&INDIRECT(ADDRESS($J$9,3,,,$I$4&\"Stammdaten\")),INDIRECT(ADDRESS($J$9,3,,,$I$4&\"Stammdaten\"))&\" \"&INDIRECT(ADDRESS($J$9,2,,,$I$4&\"Stammdaten\"))))","v":{"$error":"#REF!"}},null,null,{"$f":"I6-97","v":9}]
[{"$f":"INDIRECT(ADDRESS(46,3,,,$I$4&\"Parameter\"))","v":{"$error":"#REF!"}},{"$f":"IF(F5,IF(J10=\"\",J11,J10),\"\")","v":{"$error":"#REF!"}},{"$f":"J10","v":{"$error":"#REF!"}},null,null,null,{"$f":"IF(F5,\"\",IF(J10=\"\",J11,J10))","v":{"$error":"#REF!"}},null,null,{"$f":"TRIM((INDIRECT(ADDRESS($J$9,97,,,$I$4&\"Stammdaten\"))))","v":{"$error":"#REF!"}}]
[{"$f":"AND(INDIRECT(ADDRESS(47,3,,,$I$4&\"Parameter\")),INDIRECT(ADDRESS($J$9,82,,,$I$4&\"Stammdaten\")))","v":{"$error":"#REF!"}},{"$f":"IF(F5,IF(J10=\"\",J12,J11),\"\")","v":{"$error":"#REF!"}},{"$f":"IF(INDIRECT(ADDRESS($J$9,14,,,$I$4&\"Stammdaten\"))=\"w\",6,5)","v":{"$error":"#REF!"}},null,null,null,{"$f":"IF(F5,\"\",IF(J10=\"\",J12,J11))","v":{"$error":"#REF!"}},null,null,{"$f":"TRIM(INDIRECT(ADDRESS($J$9,6,,,$I$4&\"Stammdaten\")))","v":{"$error":"#REF!"}}]
[null,{"$f":"IF(F5,IF(J10=\"\", J13,J12),\"\")","v":{"$error":"#REF!"}},null,null,null,null,{"$f":"IF(F5,\"\",IF(J10=\"\", J13,J12))","v":{"$error":"#REF!"}},null,null,{"$f":"IF(ISBLANK(INDIRECT(ADDRESS($J$9,98,,,$I$4&\"Stammdaten\"))),\"\",INDIRECT(ADDRESS($J$9,98,,,$I$4&\"Stammdaten\"))&\" \")&INDIRECT(ADDRESS($J$9,7,,,$I$4&\"Stammdaten\"))","v":{"$error":"#REF!"}}]
[null,{"$f":"IF(F5,IF(J10=\"\", \"\",J13),\"\")","v":{"$error":"#REF!"}},null,null,null,null,{"$f":"IF(F5,\"\",IF(J10=\"\", \"\",J13))","v":{"$error":"#REF!"}},null,null,{"$f":"IF(F9,\"\",INDIRECT(ADDRESS($J$9,99,,,$I$4&\"Stammdaten\")))","v":{"$error":"#REF!"}}]
[{"$f":"AND(INDIRECT(ADDRESS(48,3,,,$I$4&\"Parameter\")),INDIRECT(ADDRESS($J$9,83,,,$I$4&\"Stammdaten\")))","v":{"$error":"#REF!"}},null,{"$f":"AND(A11,A9<>13)","v":{"$error":"#REF!"}},{"$f":"AND(A14,A9<>13)","v":{"$error":"#REF!"}},{"$f":"INDIRECT(ADDRESS(43,4,,,$I$4&\"Parameter\"))","v":{"$error":"#REF!"}},null,{"$f":"IF(A10<>TRUE,INDIRECT(ADDRESS(8,2,,,$I$4&\"Parameter\"))&\", \"&IF(G5,TEXT(G4,\"T. MMMM JJJJ\"),TEXT(TODAY(), \"T. MMMM JJJJ\")),\"\")","v":{"$error":"#REF!"}}]
[null,{"$f":"\"Lohnabrechnung \"&IF(I3<>\"Spezial\",I3&\" \"&J4,J3&IF(OR(E14=TRUE,ISNUMBER(E14)),\" \"&J4,\"\"))","v":{"$error":"#REF!"}}]
[]
[null,"Bruttolohn"]
[null,"Monatslohn",{"$f":"IF(INDIRECT(ADDRESS($J$9,2,,,$I$4&$I$3))<>1,INDIRECT(ADDRESS($J$9,2,,,$I$4&$I$3)),\"\")","v":{"$error":"#REF!"}},{"$f":"IF(AND(C18<>\"\",C18<>0),\"Mte. à\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(AND(C18<>\"\",C18<>0),INDIRECT(ADDRESS($J$9,3,,,$I$4&$I$3)),\"\")","v":{"$error":"#REF!"}},null,{"$f":"INDIRECT(ADDRESS($J$9,4,,,$I$4&$I$3))","v":{"$error":"#REF!"}}]
[null,{"$f":"IF(ISBLANK(INDIRECT(ADDRESS($J$9,5,,,$I$4&$I$3))),Lohnblatt!A13,INDIRECT(ADDRESS($J$9,5,,,$I$4&$I$3)))","v":{"$error":"#REF!"}},null,null,{"$f":"IF(INDIRECT(ADDRESS($J$9,6,,,$I$4&$I$3))<>\"\",TEXT(INDIRECT(ADDRESS($J$9,6,,,$I$4&$I$3)),\"#0.00\")&\" \"&Lohnblatt!A11&\"  à  \"&TEXT(INDIRECT(ADDRESS($J$9,7,,,$I$4&$I$3)),\"#'##0.00\"),\"\")","v":{"$error":"#REF!"}},null,{"$f":"INDIRECT(ADDRESS($J$9,8,,,$I$4&$I$3))","v":{"$error":"#REF!"}}]
[null,{"$f":"IF(ISBLANK(INDIRECT(ADDRESS($J$9,9,,,$I$4&$I$3))),Lohnblatt!A17,INDIRECT(ADDRESS($J$9,9,,,$I$4&$I$3)))","v":{"$error":"#REF!"}},null,null,{"$f":"IF(INDIRECT(ADDRESS($J$9,10,,,$I$4&$I$3))<>\"\",TEXT(INDIRECT(ADDRESS($J$9,10,,,$I$4&$I$3)),\"#0.00\")&\" \"&Lohnblatt!A15&\"  à  \"&TEXT(INDIRECT(ADDRESS($J$9,11,,,$I$4&$I$3)),\"#'##0.00\"),\"\")","v":{"$error":"#REF!"}},null,{"$f":"INDIRECT(ADDRESS($J$9,12,,,$I$4&$I$3))","v":{"$error":"#REF!"}}]
[null,{"$f":"Lohnblatt!A20","v":{"$error":"#REF!"}},{"$f":"INDIRECT(ADDRESS($J$9,13,,,$I$4&$I$3))","v":{"$error":"#REF!"}},"von",{"$f":"INDIRECT(ADDRESS($J$9,14,,,$I$4&$I$3))","v":{"$error":"#REF!"}},null,{"$f":"INDIRECT(ADDRESS($J$9,15,,,$I$4&$I$3))","v":{"$error":"#REF!"}}]
[null,"Ferien-Entschädigung",null,null,{"$f":"INDIRECT(ADDRESS($J$9,22,,,$I$4&\"Stammdaten\"))/100","v":{"$error":"#REF!"}},null,{"$f":"INDIRECT(ADDRESS($J$9,16,,,$I$4&$I$3))","v":{"$error":"#REF!"}}]
[null,"Feiertage-Entschädigung",null,null,{"$f":"INDIRECT(ADDRESS($J$9,70,,,$I$4&\"Stammdaten\"))/100","v":{"$error":"#REF!"}},null,{"$f":"INDIRECT(ADDRESS($J$9,17,,,$I$4&$I$3))","v":{"$error":"#REF!"}}]
[null,"VR-Honorar",null,null,null,null,{"$f":"INDIRECT(ADDRESS($J$9,18,,,$I$4&$I$3))","v":{"$error":"#REF!"}}]
[null,"Bonus",null,null,null,null,{"$f":"INDIRECT(ADDRESS($J$9,19,,,$I$4&$I$3))","v":{"$error":"#REF!"}}]
[null,"Gratifikation",null,null,null,null,{"$f":"INDIRECT(ADDRESS($J$9,20,,,$I$4&$I$3))","v":{"$error":"#REF!"}}]
[null,"13. Monatslohn",null,null,null,null,{"$f":"INDIRECT(ADDRESS($J$9,21,,,$I$4&$I$3))","v":{"$error":"#REF!"}}]
[null,{"$f":"INDIRECT(ADDRESS($J$9,23,,,$I$4&$I$3))","v":{"$error":"#REF!"}},null,null,null,null,{"$f":"INDIRECT(ADDRESS($J$9,22,,,$I$4&$I$3))","v":{"$error":"#REF!"}}]
[null,"Kinderzulagen",null,null,null,null,{"$f":"INDIRECT(ADDRESS($J$9,26,,,$I$4&$I$3))","v":{"$error":"#REF!"}}]
[null,"Wegvergütungen",null,null,null,null,{"$f":"INDIRECT(ADDRESS($J$9,27,,,$I$4&$I$3))","v":{"$error":"#REF!"}}]
[null,"Trinkgelder",null,null,null,null,{"$f":"INDIRECT(ADDRESS($J$9,28,,,$I$4&$I$3))","v":{"$error":"#REF!"}}]
[null,{"$f":"INDIRECT(ADDRESS(50,7,,,$I$4&\"Parameter\"))","v":{"$error":"#REF!"}},null,null,null,null,{"$f":"INDIRECT(ADDRESS($J$9,29,,,$I$4&$I$3))","v":{"$error":"#REF!"}}]
[null,"Dienstalt.geschenk",null,null,null,null,{"$f":"INDIRECT(ADDRESS($J$9,30,,,$I$4&$I$3))","v":{"$error":"#REF!"}}]
[null,"Heirats- + Geburtszulage",null,null,null,null,{"$f":"INDIRECT(ADDRESS($J$9,31,,,$I$4&$I$3))","v":{"$error":"#REF!"}}]
[null,"Privatant. Geschäftsw.",{"$f":"INDIRECT(ADDRESS(47,7,,,$I$4&\"Parameter\"))/100","v":{"$error":"#REF!"}},"von",{"$f":"INDIRECT(ADDRESS($J$9,32,,,$I$4&$I$3))","v":{"$error":"#REF!"}},null,{"$f":"INDIRECT(ADDRESS($J$9,33,,,$I$4&$I$3))","v":{"$error":"#REF!"}}]
[null,{"$f":"INDIRECT(ADDRESS($J$9,35,,,$I$4&$I$3))","v":{"$error":"#REF!"}},null,null,null,null,{"$f":"INDIRECT(ADDRESS($J$9,34,,,$I$4&$I$3))","v":{"$error":"#REF!"}}]
[null,{"$f":"INDIRECT(ADDRESS($J$9,37,,,$I$4&$I$3))","v":{"$error":"#REF!"}},null,null,null,null,{"$f":"INDIRECT(ADDRESS($J$9,42,,,$I$4&$I$3))","v":{"$error":"#REF!"}}]
[null,"Total",null,null,null,null,{"$f":"INDIRECT(ADDRESS($J$9,43,,,$I$4&$I$3))","v":{"$error":"#REF!"}},null,{"$f":"G38","v":{"$error":"#REF!"}}]
[]
[null,"Abzüge"]
[null,"AHV-Beitrag",{"$f":"INDIRECT(ADDRESS(24,4,,,$I$4&\"Parameter\"))/100","v":{"$error":"#REF!"}},"von",{"$f":"INDIRECT(ADDRESS($J$9,46,,,$I$4&$I$3))","v":{"$error":"#REF!"}},null,{"$f":"INDIRECT(ADDRESS($J$9,60,,,$I$4&$I$3))","v":{"$error":"#REF!"}}]
[null,"ALV1-Beitrag",{"$f":"INDIRECT(ADDRESS(28,4,,,$I$4&\"Parameter\"))/100","v":{"$error":"#REF!"}},"von",{"$f":"INDIRECT(ADDRESS($J$9,47,,,$I$4&$I$3))","v":{"$error":"#REF!"}},null,{"$f":"INDIRECT(ADDRESS($J$9,61,,,$I$4&$I$3))","v":{"$error":"#REF!"}}]
[null,"ALV2-Beitrag",{"$f":"INDIRECT(ADDRESS(29,4,,,$I$4&\"Parameter\"))/100","v":{"$error":"#REF!"}},"von",{"$f":"INDIRECT(ADDRESS($J$9,49,,,$I$4&$I$3))","v":{"$error":"#REF!"}},null,{"$f":"INDIRECT(ADDRESS($J$9,62,,,$I$4&$I$3))","v":{"$error":"#REF!"}}]
[null,"NBUV-Beitrag",{"$f":"INDIRECT(ADDRESS(31,C11,,,$I$4&\"Parameter\"))/100*INDIRECT(ADDRESS($J$9,29,,,$I$4&\"Stammdaten\"))/100","v":{"$error":"#REF!"}},"von",{"$f":"INDIRECT(ADDRESS($J$9,53,,,$I$4&$I$3))","v":{"$error":"#REF!"}},null,{"$f":"INDIRECT(ADDRESS($J$9,63,,,$I$4&$I$3))","v":{"$error":"#REF!"}}]
[null,"UVGZ-Beitrag",null,null,null,null,{"$f":"INDIRECT(ADDRESS($J$9,64,,,$I$4&$I$3))","v":{"$error":"#REF!"}}]
[null,"KTG-Beitrag",{"$f":"INDIRECT(ADDRESS(IF(INDIRECT(ADDRESS($J$9,23,,,$I$4&\"Stammdaten\"))=\"B\",34,33),C11,,,$I$4&\"Parameter\"))*INDIRECT(ADDRESS($J$9,54,,,$I$4&\"Stammdaten\"))/100/100","v":{"$error":"#REF!"}},"von",{"$f":"INDIRECT(ADDRESS($J$9,57,,,$I$4&$I$3))","v":{"$error":"#REF!"}},null,{"$f":"INDIRECT(ADDRESS($J$9,65,,,$I$4&$I$3))","v":{"$error":"#REF!"}}]
[null,"BVG-Beitrag",null,null,null,null,{"$f":"INDIRECT(ADDRESS($J$9,67,,,$I$4&$I$3))","v":{"$error":"#REF!"}}]
[null,"Quellensteuer",null,null,null,null,{"$f":"INDIRECT(ADDRESS($J$9,68,,,$I$4&$I$3))","v":{"$error":"#REF!"}}]
[null,{"$f":"INDIRECT(ADDRESS(42,3,,,$I$4&\"Parameter\"))","v":{"$error":"#REF!"}},null,null,null,null,{"$f":"INDIRECT(ADDRESS($J$9,69,,,$I$4&$I$3))","v":{"$error":"#REF!"}}]
[null,{"$f":"INDIRECT(ADDRESS(42,5,,,$I$4&\"Parameter\"))","v":{"$error":"#REF!"}},{"$f":"INDIRECT(ADDRESS(42,6,,,$I$4&\"Parameter\"))/100","v":{"$error":"#REF!"}},"von",{"$f":"E41","v":{"$error":"#REF!"}},null,{"$f":"INDIRECT(ADDRESS($J$9,70,,,$I$4&$I$3))","v":{"$error":"#REF!"}}]
[null,{"$f":"INDIRECT(ADDRESS($J$9,72,,,$I$4&$I$3))","v":{"$error":"#REF!"}},null,null,null,null,{"$f":"INDIRECT(ADDRESS($J$9,71,,,$I$4&$I$3))","v":{"$error":"#REF!"}}]
[null,"Korrektur Naturalleistungen",null,null,null,null,{"$f":"INDIRECT(ADDRESS($J$9,73,,,$I$4&$I$3))","v":{"$error":"#REF!"}}]
[null,"Korrektur Privatanteil Geschäftswagen",null,null,null,null,{"$f":"INDIRECT(ADDRESS($J$9,74,,,$I$4&$I$3))","v":{"$error":"#REF!"}}]
[null,"Total Abzüge",null,null,null,null,{"$f":"INDIRECT(ADDRESS($J$9,75,,,$I$4&$I$3))","v":{"$error":"#REF!"}},null,{"$f":"G54","v":{"$error":"#REF!"}}]
[]
[null,"Nettolohn",null,null,null,null,null,null,{"$f":"INDIRECT(ADDRESS($J$9,76,,,$I$4&$I$3))","v":{"$error":"#REF!"}}]
[]
[null,"Repräs.spesen",null,null,null,null,{"$f":"INDIRECT(ADDRESS($J$9,77,,,$I$4&$I$3))","v":{"$error":"#REF!"}}]
[null,"Autospesen",null,null,null,null,{"$f":"INDIRECT(ADDRESS($J$9,78,,,$I$4&$I$3))","v":{"$error":"#REF!"}}]
[null,"Reisespesen",null,null,null,null,{"$f":"INDIRECT(ADDRESS($J$9,79,,,$I$4&$I$3))","v":{"$error":"#REF!"}}]
[null,{"$f":"INDIRECT(ADDRESS($J$9,81,,,$I$4&$I$3))","v":{"$error":"#REF!"}},null,null,null,null,{"$f":"INDIRECT(ADDRESS($J$9,80,,,$I$4&$I$3))","v":{"$error":"#REF!"}}]
[null,{"$f":"INDIRECT(ADDRESS($J$9,83,,,$I$4&$I$3))","v":{"$error":"#REF!"}},null,null,null,null,{"$f":"IF(INDIRECT(ADDRESS($J$9,84,,,$I$4&$I$3))=\"x\",INDIRECT(ADDRESS($J$9,82,,,$I$4&$I$3)),0)","v":{"$error":"#REF!"}}]
[null,{"$f":"INDIRECT(ADDRESS($J$9,86,,,$I$4&$I$3))","v":{"$error":"#REF!"}},null,null,null,null,{"$f":"IF(INDIRECT(ADDRESS($J$9,87,,,$I$4&$I$3))=\"x\",INDIRECT(ADDRESS($J$9,85,,,$I$4&$I$3)),0)","v":{"$error":"#REF!"}}]
[null,{"$f":"INDIRECT(ADDRESS(64,3,,,$I$4&\"Parameter\"))","v":{"$error":"#REF!"}},null,null,null,null,{"$f":"INDIRECT(ADDRESS($J$9,88,,,$I$4&$I$3))","v":{"$error":"#REF!"}}]
[null,"Auszahlung",null,null,null,null,null,null,{"$f":"INDIRECT(ADDRESS($J$9,89,,,$I$4&$I$3))","v":{"$error":"#REF!"}}]
[null,{"$f":"IF(F6,INDIRECT(ADDRESS($J$9,91,,,$I$4&$I$3)),\"\")","v":{"$error":"#REF!"}},null,null,null,null,{"$f":"IF(F6,INDIRECT(ADDRESS($J$9,90,,,$I$4&$I$3)),\"\")","v":{"$error":"#REF!"}}]
[null,{"$f":"Lohnblatt!A97","v":{"$error":"#REF!"}},null,null,null,null,{"$f":"IF(F6,INDIRECT(ADDRESS($J$9,92,,,$I$4&$I$3)),\"\")","v":{"$error":"#REF!"}}]
[null,{"$f":"IF(F6,\"Überweisung an:\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(F6,INDIRECT(ADDRESS($J$9,18,,,$I$4&\"Stammdaten\"))&IF(B69<>\"\",\", \"&B69,\"\"),\"\")","v":{"$error":"#REF!"}},null,null,null,{"$f":"IF(F6,INDIRECT(ADDRESS($J$9,94,,,$I$4&$I$3)),\"\")","v":{"$error":"#REF!"}}]
[null,{"$f":"IF(F6,INDIRECT(ADDRESS($J$9,19,,,$I$4&\"Stammdaten\")),\"\")","v":{"$error":"#REF!"}},{"$f":"IF(F6,IF(INDIRECT(ADDRESS($J$9,86,,,$I$4&\"Stammdaten\"))<>\"\",INDIRECT(ADDRESS($J$9,86,,,$I$4&\"Stammdaten\")),INDIRECT(ADDRESS($J$9,20,,,$I$4&\"Stammdaten\"))&IF(I69<>\"\",\"   (\"&I69&\")\",\"\")),\"\")","v":{"$error":"#REF!"}},null,null,null,null,{"$f":"IF(F6,INDIRECT(ADDRESS($J$9,21,,,$I$4&\"Stammdaten\")),\"\")","v":{"$error":"#REF!"}},{"$f":"IF(INDIRECT(ADDRESS($J$9,87,,,$I$4&\"Stammdaten\"))<>\"\",INDIRECT(ADDRESS($J$9,87,,,$I$4&\"Stammdaten\")),INDIRECT(ADDRESS($J$9,58,,,$I$4&\"Stammdaten\")))","v":{"$error":"#REF!"}}]
[null,{"$f":"IF(F6,INDIRECT(ADDRESS($J$9,60,,,$I$4&\"Stammdaten\")),\"\")","v":{"$error":"#REF!"}},{"$f":"IF(F6,INDIRECT(ADDRESS($J$9,59,,,$I$4&\"Stammdaten\"))&IF(B70<>\"\",\", \"&B70,\"\"),\"\")","v":{"$error":"#REF!"}},null,null,null,{"$f":"IF(F6,INDIRECT(ADDRESS($J$9,93,,,$I$4&$I$3)),\"\")","v":{"$error":"#REF!"}}]
[null,{"$f":"IF(AND(F6,INDIRECT(ADDRESS($J$9,62,,,$I$4&\"Stammdaten\"))<>\"\"),INDIRECT(ADDRESS($J$9,62,,,$I$4&\"Stammdaten\"))&\", \"&INDIRECT(ADDRESS($J$9,21,,,$I$4&\"Stammdaten\")),\"\")","v":{"$error":"#REF!"}},{"$f":"IF(F6,IF(INDIRECT(ADDRESS($J$9,61,,,$I$4&\"Stammdaten\"))<>\"\",INDIRECT(ADDRESS($J$9,61,,,$I$4&\"Stammdaten\")),INDIRECT(ADDRESS($J$9,88,,,$I$4&\"Stammdaten\"))&IF(B71<>\"\",\", zugunsten: \"&B71,\"\")),\"\")","v":{"$error":"#REF!"}}]
[null,{"$f":"IF($C$14,\"Ferienguthaben   \"&C73&\"   in \"&INDIRECT(ADDRESS(47,4,,,$I$4&\"Parameter\")),\"\")","v":{"$error":"#REF!"}},null,null,{"$f":"INDIRECT(ADDRESS($J$9,74,,,$I$4&\"Stammdaten\"))","v":{"$error":"#REF!"}},null,null,null,{"$f":"B71","v":{"$error":"#REF!"}}]
[null,{"$f":"IF($C$14,\"Ferienanspruch\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF(AND(A9=1,E72=FALSE),\"Dezember\",INDIRECT(ADDRESS(6,$A$9+IF(E72=TRUE,1,0)+1,,,\"Lohnblatt\")))","v":{"$error":"#REF!"}},null,null,null,{"$f":"INDIRECT(ADDRESS($J$9,106,,,$I$4&$I$3))","v":{"$error":"#REF!"}},{"$f":"INDIRECT(ADDRESS($J$9,72,,,$I$4&$I$3))","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[null,{"$f":"IF($C$14,\"Saldo vom Vormonat\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF($C$14,C76-C75,\"\")","v":{"$error":"#REF!"}},null,null,null,{"$f":"INDIRECT(ADDRESS($J$9,72,,,$I$4&$I$3))","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"IF($C$14,IF(INDIRECT(ADDRESS($J$9,96,,,$I$4&$I$3))<>\"\",INDIRECT(ADDRESS($J$9,96,,,$I$4&$I$3)),\"Veränderung\"),\"\")","v":{"$error":"#REF!"}},{"$f":"IF($C$14,VALUE(INDIRECT(ADDRESS($J$9,95,,,$I$4&$I$3))),\"\")","v":{"$error":"#REF!"}},null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"IF($C$14,\"Neuer Saldo\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF($C$14,VALUE(INDIRECT(ADDRESS($J$9,97,,,$I$4&$I$3))),\"\")","v":{"$error":"#REF!"}},{"$f":"C76","v":{"$error":"#REF!"}}]
[null,{"$f":"IF($C$14,\"Bezogene Ferientage\",\"\")","v":{"$error":"#REF!"}}]
[null,{"$f":"IF($C$14,\"Saldo vom Vormonat\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF($C$14,C80-C79,\"\")","v":{"$error":"#REF!"}},null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"IF($C$14,IF(INDIRECT(ADDRESS($J$9,99,,,$I$4&$I$3))<>\"\",INDIRECT(ADDRESS($J$9,99,,,$I$4&$I$3)),\"Veränderung\"),\"\")","v":{"$error":"#REF!"}},{"$f":"IF($C$14,-VALUE(INDIRECT(ADDRESS($J$9,98,,,$I$4&$I$3))),\"\")","v":{"$error":"#REF!"}},null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"IF($C$14,\"Neuer Saldo\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF($C$14,-VALUE(INDIRECT(ADDRESS($J$9,100,,,$I$4&$I$3))),\"\")","v":{"$error":"#REF!"}},{"$f":"IF($C$14,-C80,\"\")","v":{"$error":"#REF!"}},null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"IF($C$14,\"Ferien Guthaben Saldo\",\"\")","v":{"$error":"#REF!"}},null,{"$f":"IF($C$14,D76+D80,\"\")","v":{"$error":"#REF!"}}]
[null,null,null,{"$f":"INDIRECT(ADDRESS($J$9,84,,,$I$4&\"Stammdaten\"))","v":{"$error":"#REF!"}},false,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"IF($D$14,IF(D82=TRUE,\"Kontrolle Jahresarbeitszeit   \",\"Ueberzeitguthaben   \"&C73 & \"   in Std.\"),\"\")","v":{"$error":"#REF!"}},null,null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"IF($D$14,\"Saldo vom Vormonat\",\"\")","v":{"$error":"#REF!"}},{"$f":"IF($D$14,D87-C86-C85,\"\")","v":{"$error":"#REF!"}},null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"IF($D$14,IF(D82=TRUE,\"geleistete Arbeitszeit\",\"Veränderung\"),\"\")","v":{"$error":"#REF!"}},{"$f":"IF($D$14,VALUE(INDIRECT(ADDRESS($J$9,102,,,$I$4&$I$3))),\"\")","v":{"$error":"#REF!"}},null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"IF($D$14,IF(D82=TRUE,\"Sollzeit im \",\"Kompensation im \")&D73,\"\")","v":{"$error":"#REF!"}},{"$f":"IF($D$14,VALUE(INDIRECT(ADDRESS($J$9,103,,,$I$4&$I$3))),\"\")","v":{"$error":"#REF!"}},null,null,null,{"$error":"#REF!"},{"$error":"#REF!"},{"$error":"#REF!"}]
[null,{"$f":"IF($D$14,\"Saldo\",\"\")","v":{"$error":"#REF!"}},null,{"$f":"IF($D$14,VALUE(INDIRECT(ADDRESS($J$9,105,,,$I$4&$I$3))),\"\")","v":{"$error":"#REF!"}}]

{"sheet":"Hauptbuch","index":4,"n_rows":5,"n_cols":8,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,null,1]
[null,{"$f":"INDIRECT(ADDRESS(5,2,,,$H$4&\"Parameter\"))","v":{"$error":"#REF!"}}]
[null,{"$f":"IF($H$3,INDIRECT(ADDRESS(7,2,,,$H$4&\"Parameter\")),INDIRECT(ADDRESS(6,2,,,$H$4&\"Parameter\")))","v":{"$error":"#REF!"}},null,null,null,null,null,{"$f":"IF(OR(ISBLANK(INDIRECT(ADDRESS(6,2,,,$H$4&\"Parameter\"))),INDIRECT(ADDRESS(6,2,,,$H$4&\"Parameter\"))=\"\"),TRUE,FALSE)","v":{"$error":"#REF!"}}]
[null,{"$f":"IF($H$3,INDIRECT(ADDRESS(8,3,,,$H$4&\"Parameter\"))&\" \"&INDIRECT(ADDRESS(8,2,,,$H$4&\"Parameter\")),INDIRECT(ADDRESS(7,2,,,$H$4&\"Parameter\")))","v":{"$error":"#REF!"}},null,null,null,null,null,{"$f":"Lohnblatt!K3","v":"[]"}]
[null,{"$f":"IF($H$3,\"\",INDIRECT(ADDRESS(8,2,,,$H$4&\"Parameter\")))","v":{"$error":"#REF!"}},null,null,null,null,"Kostenstelle 11 - Stundenlöhner"]

{"sheet":"Listen","index":5,"n_rows":5,"n_cols":8,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,null,7]
[null,{"$f":"INDIRECT(ADDRESS(5,2,,,$H$3&\"Parameter\"))","v":{"$error":"#REF!"}},null,null,null,null,-1,{"$f":"IF(OR(ISBLANK(INDIRECT(ADDRESS(6,2,,,$H$3&\"Parameter\"))),INDIRECT(ADDRESS(6,2,,,$H$3&\"Parameter\"))=\"\"),TRUE,FALSE)","v":{"$error":"#REF!"}}]
[null,{"$f":"IF($H$2,INDIRECT(ADDRESS(7,2,,,$H$3&\"Parameter\")),INDIRECT(ADDRESS(6,2,,,$H$3&\"Parameter\")))","v":{"$error":"#REF!"}},null,null,null,null,null,{"$f":"Lohnblatt!K3","v":"[]"}]
[null,{"$f":"IF($H$2,INDIRECT(ADDRESS(8,3,,,$H$3&\"Parameter\"))&\" \"&INDIRECT(ADDRESS(8,2,,,$H$3&\"Parameter\")),INDIRECT(ADDRESS(7,2,,,$H$3&\"Parameter\")))","v":{"$error":"#REF!"}}]
[null,{"$f":"IF($H$2,\"\",INDIRECT(ADDRESS(8,2,,,$H$3&\"Parameter\")))","v":{"$error":"#REF!"}}]

{"sheet":"Lohnausweis","index":6,"n_rows":190,"n_cols":19,"rows_kept":190,"cut":false,"hidden":true,"merged":[[78,15,78,18],[66,6,67,10],[1,3,2,17],[11,12,11,18],[124,2,124,15],[126,2,126,15],[128,2,128,15],[138,2,138,15],[95,2,95,8],[16,12,16,18],[30,7,31,10],[30,6,31,6],[26,2,28,5],[23,2,24,3],[23,11,24,12],[30,12,30,16],[16,2,16,10],[66,11,66,16],[83,15,83,18],[70,8,72,9],[70,2,72,7],[74,2,76,3],[70,10,70,18],[72,10,72,18],[76,4,76,18],[74,4,74,18],[13,12,13,18],[15,12,15,18],[13,2,13,10],[14,2,14,10],[15,2,15,10],[14,12,14,18],[23,4,24,10],[66,5,67,5],[58,3,60,4],[60,6,61,10],[60,5,61,5],[3,3,4,18],[8,2,8,3],[8,14,9,18],[12,12,12,18],[6,2,6,5],[6,7,6,11],[8,6,8,7],[12,2,12,10],[6,14,7,19],[8,9,8,10],[33,0,45,0],[33,2,33,16],[56,1,57,1],[35,1,36,1],[41,1,42,1],[56,2,57,16],[60,11,60,16],[35,11,35,16],[35,2,36,10],[97,2,97,8],[99,2,99,8],[101,2,101,8],[103,2,103,8],[177,2,177,15],[186,2,186,18],[175,2,175,15],[171,2,171,15],[173,2,173,15],[147,2,147,15],[145,2,145,15],[108,2,108,15],[110,2,110,15],[112,2,112,15],[140,2,140,15],[130,2,130,15],[132,2,132,15],[134,2,134,15],[136,2,136,15],[114,2,114,15],[116,2,116,15],[118,2,118,15],[120,2,120,15],[122,2,122,15],[184,2,184,18],[169,2,169,15],[167,2,167,15],[165,2,165,15],[163,2,163,15],[161,2,161,15],[159,2,159,15],[157,2,157,15],[155,2,155,15],[23,1,24,1],[22,18,23,18],[181,2,181,15],[182,2,182,18],[153,2,153,15],[151,2,151,15],[149,2,149,15],[80,15,80,18],[81,15,81,18],[78,9,82,14],[62,2,64,2],[58,2,60,2],[41,2,42,9],[41,10,41,16],[89,2,89,5],[91,2,91,3],[91,6,91,7],[91,9,91,10],[82,15,82,18],[79,2,79,7],[79,15,79,18],[62,3,64,4],[47,2,49,5],[47,6,49,7]]}
[null,null,null,null,null,null,-1,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,"Autokosten","Lohnausweis – Certificat de salaire – Certificato di salario"]
[null,"A","x",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,106]
[null,null,"LZ Auto","Rentenbescheinigung – Attestation de rentes – Attestazione delle rendite"]
[null,"B"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,400]
[null,"C",{"$f":"IF(ISBLANK(H7),INDIRECT(ADDRESS($Q$11,12,,,$S$11&\"Stammdaten\")),\"\")","v":""},null,null,null,null,{"$f":"INDIRECT(ADDRESS($Q$11,85,,,$S$11&\"Stammdaten\"))","v":{"$error":"#REF!"}},null,null,null,null,"F  ",{"$f":"IF(INDIRECT(ADDRESS($Q$11,47,,,$S$11&\"Stammdaten\")),\"x\",\"\")","v":{"$error":"#REF!"}},"Unentgeltliche Beförderung zwischen Wohn- und Arbeitsort\nTransport gratuit entre le domicile et le lieu de travail\nTransporto gratuito dal domicilio al luogo di lavoro"]
[null,null,"AHV-Nr. – No AVS – N. AVS",null,null,null,null,"Neue AHV-Nr. – Nouveau No AVS – Nuovo N. AVS"]
[null,"D",{"$f":"INDIRECT(ADDRESS(3,3,,,$S$11&\"Parameter\"))","v":{"$error":"#REF!"}},null,{"$f":"IF(OR(G9>DATE(C9,1,1),J9<DATE(C9,12,31)),FALSE,TRUE)","v":{"$error":"#REF!"}},"E  ",{"$f":"IF(DATE(C9,1,1)>DATEVALUE(P11),DATE(C9,1,1),DATEVALUE(P11))","v":{"$error":"#REF!"}},null,null,{"$f":"IF(OR(O11=0,O11=\"\"),DATE(C9,12,31),IF(DATEVALUE(O11)>DATE(C9,12,31),DATE(C9,12,31),DATEVALUE(O11)))","v":{"$error":"#REF!"}},null,null,"G  ",{"$f":"IF(INDIRECT(ADDRESS($Q$11,48,,,$S$11&\"Stammdaten\")),\"x\",\"\")","v":{"$error":"#REF!"}},"Kantineverpflegung / Lunch-Checks\nRepas à la cantine /  chèques-repas\nPasti alla mensa / buoni pasto"]
[null,null,"Jahr – Année – Anno",null,null,null,"von – du – dal",null,null,"bis – au – al"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDIRECT(ADDRESS(49,6,,,$S$11&\"Parameter\"))","v":{"$error":"#REF!"}},{"$f":"INDIRECT(ADDRESS($Q$11,16,,,$S$11&\"Stammdaten\"))","v":{"$error":"#REF!"}},{"$f":"INDIRECT(ADDRESS($Q$11,15,,,$S$11&\"Stammdaten\"))","v":{"$error":"#REF!"}},{"$f":"S3-97","v":9},{"$f":"$S11&\"Gesamtjahr\"","v":"[]Gesamtjahr"},{"$f":"Lohnblatt!K3","v":"[]"}]
[null,"H",null,null,null,null,null,null,null,null,null,null,{"$f":"INDIRECT(ADDRESS($Q$11,101,,,$S$11&\"Stammdaten\"))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDIRECT(ADDRESS($Q$11,4,,,$S$11&\"Stammdaten\"))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(NameZuerst=TRUE,INDIRECT(ADDRESS($Q$11,2,,,$S$11&\"Stammdaten\"))&\" \"&INDIRECT(ADDRESS($Q$11,3,,,$S$11&\"Stammdaten\")),INDIRECT(ADDRESS($Q$11,3,,,$S$11&\"Stammdaten\"))&\" \"&INDIRECT(ADDRESS($Q$11,2,,,$S$11&\"Stammdaten\")))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(INDIRECT(ADDRESS($Q$11,97,,,$S$11&\"Stammdaten\"))<>\"\",INDIRECT(ADDRESS($Q$11,97,,,$S$11&\"Stammdaten\")),INDIRECT(ADDRESS($Q$11,6,,,$S$11&\"Stammdaten\")))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(INDIRECT(ADDRESS($Q$11,97,,,$S$11&\"Stammdaten\"))<>\"\",INDIRECT(ADDRESS($Q$11,6,,,$S$11&\"Stammdaten\")),INDIRECT(ADDRESS($Q$11,98,,,$S$11&\"Stammdaten\"))&\" \"&INDIRECT(ADDRESS($Q$11,7,,,$S$11&\"Stammdaten\")))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(INDIRECT(ADDRESS($Q$11,97,,,$S$11&\"Stammdaten\"))=\"\",\"\",INDIRECT(ADDRESS($Q$11,98,,,$S$11&\"Stammdaten\"))&\" \"&INDIRECT(ADDRESS($Q$11,7,,,$S$11&\"Stammdaten\")))","v":{"$error":"#REF!"}}]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Nur ganze Frankenbeträge\nQue des montants entiers\nUnicamente importi interi"]
[null,"1.\n\n","Lohn\nSalaire\nSalario",null,"soweit nicht unter Ziffer 2–7 aufzuführen\nqui ne concerne pas les chriffres 2 à 7 ci-dessous\nse non da indicare sotto cifre da 2 a 7 più sotto",null,null,null,null,null,null,"/ Rente\n/ Rente\n/ Rendita"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDIRECT(ADDRESS($Q$11,43,,,Bezug_Jahr))-S27-S29-S34-S31-S36-S38-S40-S42","v":{"$error":"#REF!"}}]
[]
[null,"2.","Gehaltsnebenleistungen\nPrestation salarialesaccessoires\nPrestazioni accessorie al salario",null,null,null,"2.1.","Verpflegung, Unterkunft – Pension, logement – Vitto, alloggio",null,null,null,null,null,null,null,null,null,"+",{"$f":"INDIRECT(ADDRESS($Q$11,29,,,Bezug_Jahr))","v":{"$error":"#REF!"}}]
[]
[null,null,null,null,null,null,"2.2.","Privatanteil Geschäftswagen – Part privée de service – Quota privata autobile di servizio",null,null,null,null,null,null,null,null,null,"+",{"$f":"INDIRECT(ADDRESS($Q$11,33,,,Bezug_Jahr))","v":{"$error":"#REF!"}}]
[]
[null,null,null,null,null,null,"2.3.","Andere – Autres – Altre\nArt – Genre – Genere",null,null,null,null,null,null,null,null,null,"+"]
[]
[null,"3.","Unregelmässige Leistungen – Prestations non périodiques – Prestazioni aperiodiche",null,null,null,null,null,null,null,null,null,null,"Art – Genre – Genere",null,null,null,null,{"$f":"O11","v":{"$error":"#REF!"}}]
["Bitte die Wegleitung beachten\nObserver s.v.p. la directive\nOsservare p.f. l'instruzioni",null,{"$f":"IF(S34<>0,IF(Anzahl_unregLeist>1,\"siehe Beiblatt\",IF(Q109<>0,C109,\"\")&IF(Q111<>0,C111,\"\")&IF(Q113<>0,C113,\"\")&IF(R115<>0,C115,\"\")),\"\")","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"+",{"$f":"IF(ganzesJahr,0,S143)","v":{"$error":"#REF!"}}]
[]
[null,"4.\n  ","Kapitalleistungen – Prestations en capital – Prestazioni in capitale\nArt – Genre – Genera",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"+"]
[]
[null,"5.","Beteiligungsrechte gemäss Beiblatt – Droits de participation selon annexe – Diritti di partecipazione secondo allegato",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"+"]
[]
[null,"6.","Verwaltungsratsentschädigungen – Indemnités des membres de l'administration – Indennità dei membri di consigli d'amministrazione",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDIRECT(ADDRESS($Q$11,18,,,Bezug_Jahr))","v":{"$error":"#REF!"}}]
[]
[null,"7.","Andere Leistungen – Autres prestations – Altre prestazioni\nArt – Genre – Genere",null,null,null,null,null,null,null,{"$f":"IF(S42<>0,IF(Anzahl_andereLeist>1,\"siehe Beiblatt\",IF(S146<>0,C146,\"\")&IF(S148<>0,C148,\"\")&IF(S150<>0,C150,\"\")&IF(S152<>0,C152,\"\")),\"\")","v":{"$error":"#REF!"}},null,null,null,null,null,null,"+",{"$f":"S180","v":{"$error":"#REF!"}}]
[]
[null,"8.","Bruttolohn total / Rente – Salaire brut total / Rente – Salario lordo totale / Rendita",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"=",{"$f":"S25+S27+S29+S31+S34+S36+S38+S40+S42","v":{"$error":"#REF!"}}]
[]
[null,"9.","Beiträge AHV/IV/EO/ALV/NBUV – Cotisations AVS/AI/APG/AC/AANP – Contributi AVS/AI/PG/AD/AINP",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"–",{"$f":"INDIRECT(ADDRESS($Q$11,60,,,Bezug_Jahr))+INDIRECT(ADDRESS($Q$11,61,,,Bezug_Jahr))+INDIRECT(ADDRESS($Q$11,62,,,Bezug_Jahr))+INDIRECT(ADDRESS($Q$11,63,,,Bezug_Jahr))","v":{"$error":"#REF!"}}]
[]
[null,"10.","Berufliche Vorsorge\nPrévoyance professionelle\nPrevidenza professionale",null,null,null,"2. Säule\n2e pilier\n2° pilastro",null,"10.1","Ordentliche Beiträge – Cotisations ordinaires – Contributi ordinari",null,null,null,null,null,null,null,null,{"$f":"INDIRECT(ADDRESS($Q$11,67,,,Bezug_Jahr))","v":{"$error":"#REF!"}}]
[]
[null,null,null,null,null,null,null,null,"10.2","Beiträge für den Einkauf – Cotisations pour le rachat – Contributi per il riscatto",null,null,null,null,null,null,null,"–"]
[]
[null,"11.","Nettolohn / Rente – Salaire net / Rente – Salario netto / Rendita",null,null,null,null,null,null,null,null,null,null,null,null,"è",null,"=",{"$f":"S44-S46-S48-S50","v":{"$error":"#REF!"}}]
[null,null,"In die Steuererklärung übertragen  – A reporter sr la déclaration d'impôt – Da riportare nella dichiarazione d'imposta"]
[]
[null,"12.","Quellensteuerabzug – Retenue de l'impôt à la source – Ritenuta d'imposta alla fonte",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDIRECT(ADDRESS($Q$11,68,,,Bezug_Jahr))","v":{"$error":"#REF!"}}]
[]
[null,"13.","Spesenvergütungen – Allocations pour frais – Indennità per spese\nNicht im Bruttolohn (gemäss Ziffer 8) enthalten – Non comprises dans le salaire brut (au chiffre 8) – Non comprese nel salario lordo (sotto cifra 8)"]
[]
[null,null,"13.1\n\n","Effektive Spesen\nFrais effectifs\nSpese effective",null,"13.1.1","Reise, Verpflegung, Übernachtung – Voyage, repas, nuitées – Viaggio, vitto, alloggio",null,null,null,null,null,null,null,null,null,{"$f":"IF(INDIRECT(ADDRESS($Q$11,75,,,$S$11&\"Stammdaten\"))<>TRUE,\"\",\"x\")","v":{"$error":"#REF!"}},null,{"$f":"IF(Q59<>\"x\",+INDIRECT(ADDRESS($Q$11,82,,,Bezug_Jahr)),0)","v":{"$error":"#REF!"}}]
[]
[null,null,null,null,null,"13.1.2\n","Übrige – Autres – Alte\nArt – Genre – Genere",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(Q59<>\"x\",+INDIRECT(ADDRESS($Q$11,85,,,Bezug_Jahr)),0)","v":{"$error":"#REF!"}}]
[]
[null,null,"13.2\n\n","Pauschalspesen\nFrais forfaitaires\nSpese forfettarie",null,"13.2.1","Repräsentation – Représentation – Rappresentanza",null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDIRECT(ADDRESS($Q$11,77,,,Bezug_Jahr))+INDIRECT(ADDRESS($Q$11,79,,,Bezug_Jahr))","v":{"$error":"#REF!"}}]
[]
[null,null,null,null,null,"13.2.2","Auto – Voiture – Automobile",null,null,null,null,null,null,null,null,null,null,null,{"$f":"+INDIRECT(ADDRESS($Q$11,78,,,Bezug_Jahr))","v":{"$error":"#REF!"}}]
[]
[null,null,null,null,null,"13.2.3\n","Übrige – Autres – Alte\nArt – Genre – Genere",null,null,null,null,null,null,null,null,null,null,null,{"$f":"+INDIRECT(ADDRESS($Q$11,80,,,Bezug_Jahr))","v":{"$error":"#REF!"}}]
[]
[null,null,"13.3","Beiträge an die Weiterbildung – Contributions au perfectionnement – Contributi per il perfezionamento",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDIRECT(ADDRESS($Q$11,88,,,Bezug_Jahr))","v":{"$error":"#REF!"}}]
[]
[null,"14.","Weitere Gehaltsnebenleistungen\nAutres prestations salairiales accessoires\nAltre prestazioni accessorie al salario",null,null,null,null,null,"Art\nGenre\nGenere"]
[]
[]
[null,null,null,null,"Test"]
[null,"15.","Bemerkungen\nObservations\nOsservazioni",null,{"$f":"INDIRECT(ADDRESS(12,6,,,$S$11&\"Parameter\"))","v":{"$error":"#REF!"}}]
[]
[null,null,null,null,{"$f":"INDIRECT(ADDRESS($Q$11,52,,,$S$11&\"Stammdaten\"))","v":{"$error":"#REF!"}}]
[]
[null,"I","Ort und Datum – Lieu et date – Luogo e data",null,null,null,null,null,null,"Die Richtigkeit und Vollständigkeit bestätigt\ninkl. genauer Anschrift und Telefonummer des Arbeitgebers\nCertifié exact et complet\ny.c. adresse et numéro de télephone exacts de l'employeur\nCertificato esatto e completo\ncompresi indirizzo e numero di telefono esatti del datore di lavoro",null,null,null,null,null,{"$f":"INDIRECT(ADDRESS(5,2,,,$S$11&\"Parameter\"))","v":{"$error":"#REF!"}}]
[null,null,{"$f":"IF(ISBLANK(C81),INDIRECT(ADDRESS(8,2,,,$S$11&\"Parameter\")),C81)&\", \"&IF(ISBLANK(C82),TEXT(TODAY(), \"T. MMM. JJJJ\"),C82)","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDIRECT(ADDRESS(7,2,,,$S$11&\"Parameter\"))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDIRECT(ADDRESS(8,3,,,$S$11&\"Parameter\"))& \" \"&INDIRECT(ADDRESS(8,2,,,$S$11&\"Parameter\"))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N84,INDIRECT(ADDRESS(8,6,,,$S$11&\"Parameter\")),INDIRECT(ADDRESS(7,6,,,$S$11&\"Parameter\")))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(N84,INDIRECT(ADDRESS(9,6,,,$S$11&\"Parameter\")),INDIRECT(ADDRESS(9,2,,,$S$11&\"Parameter\")))","v":{"$error":"#REF!"}}]
[null,"605.040.18   Form. 11   (25.8.2006)   [nachgebildet durch: hit Treuhand GmbH, Uster]",null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDIRECT(ADDRESS($Q$11,51,,,$S$11&\"Stammdaten\"))","v":{"$error":"#REF!"}},null,{"$f":"IF(N84,INDIRECT(ADDRESS(10,6,,,$S$11&\"Parameter\")),\"\")","v":{"$error":"#REF!"}}]
[]
[]
[null,"Lohnausweis – Certificat de salaire – Certificato di salario"]
[null,"Beiblatt  – Supplément  – Supplemento  (1 / 1)"]
[]
[null,"C",{"$f":"INDIRECT(ADDRESS($Q$11,85,,,$S$11&\"Stammdaten\"))","v":{"$error":"#REF!"}}]
[null,null,"Neue AHV-Nr. – Nouveau No AVS – Nuovo N. AVS"]
[null,"D",{"$f":"INDIRECT(ADDRESS(3,3,,,$S$11&\"Parameter\"))","v":{"$error":"#REF!"}},null,null,"E  ",{"$f":"IF(DATE(C92,1,1)>DATEVALUE(P94),DATE(C92,1,1),DATEVALUE(P94))","v":{"$error":"#REF!"}},null,null,{"$f":"IF(OR(O94=0,O94=\"\"),DATE(C92,12,31),IF(DATEVALUE(O94)>DATE(C92,12,31),DATE(C92,12,31),DATEVALUE(O94)))","v":{"$error":"#REF!"}}]
[null,null,"Jahr – Année – Anno",null,null,null,"von – du – dal",null,null,"bis – au – al"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDIRECT(ADDRESS($Q$11,16,,,$S$11&\"Stammdaten\"))","v":{"$error":"#REF!"}},{"$f":"INDIRECT(ADDRESS($Q$11,15,,,$S$11&\"Stammdaten\"))","v":{"$error":"#REF!"}},{"$f":"S95-97","v":19},{"$f":"$S94&\"Gesamtjahr\"","v":"0Gesamtjahr"},{"$f":"Lohnblatt!K87","v":0}]
[null,"H",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,116]
[null,null,{"$f":"INDIRECT(ADDRESS($Q$11,4,,,$S$11&\"Stammdaten\"))","v":{"$error":"#REF!"}}]
[]
[null,null,{"$f":"INDIRECT(ADDRESS($Q$11,2,,,$S$11&\"Stammdaten\"))&\" \"&INDIRECT(ADDRESS($Q$11,3,,,$S$11&\"Stammdaten\"))","v":{"$error":"#REF!"}}]
[]
[null,null,{"$f":"IF(INDIRECT(ADDRESS($Q$11,97,,,$S$11&\"Stammdaten\"))<>\"\",INDIRECT(ADDRESS($Q$11,97,,,$S$11&\"Stammdaten\")),INDIRECT(ADDRESS($Q$11,6,,,$S$11&\"Stammdaten\")))","v":{"$error":"#REF!"}}]
[]
[null,null,{"$f":"IF(INDIRECT(ADDRESS($Q$11,97,,,$S$11&\"Stammdaten\"))<>\"\",INDIRECT(ADDRESS($Q$11,6,,,$S$11&\"Stammdaten\")),INDIRECT(ADDRESS($Q$11,98,,,$S$11&\"Stammdaten\"))&\" \"&INDIRECT(ADDRESS($Q$11,7,,,$S$11&\"Stammdaten\")))","v":{"$error":"#REF!"}}]
[]
[null,null,{"$f":"IF(INDIRECT(ADDRESS($Q$11,97,,,$S$11&\"Stammdaten\"))=\"\",\"\",INDIRECT(ADDRESS($Q$11,98,,,$S$11&\"Stammdaten\"))&\" \"&INDIRECT(ADDRESS($Q$11,7,,,$S$11&\"Stammdaten\")))","v":{"$error":"#REF!"}}]
[]
[null,"Detailangaben – Indication de détaile – Dati del particolare"]
[]
[null,"3.","Unregelmässige Leistungen – Prestations non périodiques – Prestazioni aperiodiche",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+IF(S109<>0,1,0)+IF(S111<>0,1,0)+IF(S113<>0,1,0)+IF(S115<>0,1,0)+IF(S117<>0,1,0)","v":{"$error":"#REF!"}},null,"CHF"]
[null,null,{"$f":"IF(S109<>0,\"Bonus\",\"\")","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDIRECT(ADDRESS($Q$11,19,,,Bezug_Jahr))","v":{"$error":"#REF!"}},"+",{"$f":"IF(ganzesJahr,0,Q109)","v":{"$error":"#REF!"}}]
[]
[null,null,{"$f":"IF(S111<>0,\"Gratifikation\",\"\")","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDIRECT(ADDRESS($Q$11,20,,,Bezug_Jahr))","v":{"$error":"#REF!"}},"+",{"$f":"IF(ganzesJahr,0,Q111)","v":{"$error":"#REF!"}}]
[]
[null,null,{"$f":"IF(S113<>0,\"Dienstaltersgeschenk\",\"\")","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDIRECT(ADDRESS($Q$11,30,,,Bezug_Jahr))","v":{"$error":"#REF!"}},"+",{"$f":"IF(ganzesJahr,0,Q113)","v":{"$error":"#REF!"}}]
[]
[null,null,null,null,null,null,null,null,null,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":"INDIRECT(ADDRESS($Q$11,30,,,Bezug_Jahr))","v":{"$error":"#REF!"}},"+"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDIRECT(ADDRESS($Q$11,30,,,Bezug_Jahr))","v":{"$error":"#REF!"}},"+"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDIRECT(ADDRESS($Q$11,30,,,Bezug_Jahr))","v":{"$error":"#REF!"}},"+"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDIRECT(ADDRESS($Q$11,30,,,Bezug_Jahr))","v":{"$error":"#REF!"}},"+"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDIRECT(ADDRESS($Q$11,30,,,Bezug_Jahr))","v":{"$error":"#REF!"}},"+"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDIRECT(ADDRESS($Q$11,30,,,Bezug_Jahr))","v":{"$error":"#REF!"}},"+"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDIRECT(ADDRESS($Q$11,30,,,Bezug_Jahr))","v":{"$error":"#REF!"}},"+"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDIRECT(ADDRESS($Q$11,30,,,Bezug_Jahr))","v":{"$error":"#REF!"}},"+"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDIRECT(ADDRESS($Q$11,30,,,Bezug_Jahr))","v":{"$error":"#REF!"}},"+"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDIRECT(ADDRESS($Q$11,30,,,Bezug_Jahr))","v":{"$error":"#REF!"}},"+"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDIRECT(ADDRESS($Q$11,30,,,Bezug_Jahr))","v":{"$error":"#REF!"}},"+"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDIRECT(ADDRESS($Q$11,30,,,Bezug_Jahr))","v":{"$error":"#REF!"}},"+"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"INDIRECT(ADDRESS($Q$11,30,,,Bezug_Jahr))","v":{"$error":"#REF!"}},"+"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"=",{"$f":"SUM(S109:S142)","v":{"$error":"#REF!"}}]
[]
[null,"7.","Andere Leistungen – Autres prestations – Altre prestazioni",null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"+IF(S146<>0,1,0)+IF(S148<>0,1,0)+IF(S150<>0,1,0)+IF(ISBLANK(S152),0,1)+IF(ISBLANK(S154),0,1)","v":{"$error":"#REF!"}},null,"CHF"]
[null,null,{"$f":"IF(S146<>0,\"Trinkgelder\",\"\")","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"+",{"$f":"INDIRECT(ADDRESS($Q$11,28,,,Bezug_Jahr))","v":{"$error":"#REF!"}}]
[]
[null,null,{"$f":"IF(S148<>0,\"Heirats- und Geburtszulagen\",\"\")","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"+",{"$f":"INDIRECT(ADDRESS($Q$11,31,,,Bezug_Jahr))","v":{"$error":"#REF!"}}]
[]
[null,null,{"$f":"IF(S150<>0,\"Taggelder\",\"\")","v":{"$error":"#REF!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"+",{"$f":"+INDIRECT(ADDRESS($Q$11,42,,,Bezug_Jahr))","v":{"$error":"#REF!"}}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"+"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"+"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"+"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"+"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"+"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"+"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"+"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"+"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"+"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"+"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"+"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"+"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"+"]
[]
[null,null,null,null,null,null,null,null,null,null,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":"SUM(S146:S178)","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q145","v":{"$error":"#REF!"}}]
[null,"15.","Bemerkungen – \nObservations – \nOsservazioni"]
[null,null,{"$f":"INDIRECT(ADDRESS($Q$11,43,,,$S$11&\"Stammdaten\"))","v":{"$error":"#REF!"}}]
[]
[null,null,{"$f":"INDIRECT(ADDRESS($Q$11,44,,,$S$11&\"Stammdaten\"))","v":{"$error":"#REF!"}}]
[]
[null,null,{"$f":"INDIRECT(ADDRESS($Q$11,45,,,$S$11&\"Stammdaten\"))","v":{"$error":"#REF!"}}]
[]
[]
[null,"Beiblatt zu 605.040.18   Form. 11   (25.8.2006)   [nachgebildet durch: hit Treuhand GmbH, Uster]"]

{"sheet":"Lohnsummenliste","index":7,"n_rows":10,"n_cols":12,"rows_kept":10,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,null,null,null,4,null,1,0]
["Quellensteuer-Abrechnung 2017",null,null,null,null,null,null,null,null,2,2]
[]
[]
[]
[]
[]
[]
["Soz.vers.-Nr.","Name und Vorname","Geburts-","Geschl.","Name und Vorname","steueranspruchsberechtigt:",null,"Mutationen","Bruttolohn","T","K","Quellen-"]
[null,"der Arbeitnehmenden","datum",null,"der Arbeitnehmenden","Wohngemeinde","Kt.","Ein-/Austritt","in Abr.periode",null,null,"steuer"]

{"sheet":"MA_Stamm","index":8,"n_rows":58,"n_cols":15,"rows_kept":58,"cut":false,"hidden":true,"merged":[[8,8,8,10],[8,13,9,18],[57,2,57,3],[48,7,49,10],[50,7,51,10],[52,7,53,10],[54,7,55,10]]}
[]
[null,{"$f":"INDIRECT(ADDRESS(5,2,,,$I$4&\"Parameter\"))","v":{"$error":"#REF!"}}]
[null,{"$f":"IF($I$3,INDIRECT(ADDRESS(7,2,,,$I$4&\"Parameter\")),INDIRECT(ADDRESS(6,2,,,$I$4&\"Parameter\")))","v":{"$error":"#REF!"}},null,null,null,null,null,null,{"$f":"IF(OR(ISBLANK(INDIRECT(ADDRESS(6,2,,,$I$4&\"Parameter\"))),INDIRECT(ADDRESS(6,2,,,$I$4&\"Parameter\"))=\"\"),TRUE,FALSE)","v":{"$error":"#REF!"}}]
[null,{"$f":"IF($I$3,INDIRECT(ADDRESS(8,3,,,$I$4&\"Parameter\"))&\" \"&INDIRECT(ADDRESS(8,2,,,$I$4&\"Parameter\")),INDIRECT(ADDRESS(7,2,,,$I$4&\"Parameter\")))","v":{"$error":"#REF!"}},null,null,null,null,null,null,{"$f":"Lohnblatt!K3","v":"[]"}]
[null,{"$f":"IF($I$3,\"\",INDIRECT(ADDRESS(8,2,,,$I$4&\"Parameter\")))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,{"$f":"Lohnblatt!K3","v":"[]"}]
[null,"Personal-Stammdaten ",null,null,null,null,null,{"$f":"K7-97","v":9},"Pers.-Nummer",null,106]
[]
[]
[null,"Personalien"]
[null,"Anrede/Titel",{"$f":"INDIRECT(ADDRESS($H$7,4,,,$I$6&\"Stammdaten\"))","v":{"$error":"#REF!"}},null,{"$f":"INDIRECT(ADDRESS($H$7,5,,,$I$6&\"Stammdaten\"))","v":{"$error":"#REF!"}},null,"neue Sozialvers.nr.",null,{"$f":"INDIRECT(ADDRESS($H$7,85,,,$I$6&\"Stammdaten\"))","v":{"$error":"#REF!"}}]
[null,"Name",{"$f":"INDIRECT(ADDRESS($H$7,2,,,$I$6&\"Stammdaten\"))","v":{"$error":"#REF!"}},null,null,null,"AHV-Nr. (alt)",null,{"$f":"INDIRECT(ADDRESS($H$7,12,,,$I$6&\"Stammdaten\"))","v":{"$error":"#REF!"}},null,null,null,null,null,{"$f":"INDIRECT(ADDRESS($H$7,15,,,$I$6&\"Stammdaten\"))","v":{"$error":"#REF!"}}]
[null,"Vorname",{"$f":"INDIRECT(ADDRESS($H$7,3,,,$I$6&\"Stammdaten\"))","v":{"$error":"#REF!"}},null,null,null,"Beruf",null,{"$f":"INDIRECT(ADDRESS($H$7,9,,,$I$6&\"Stammdaten\"))","v":{"$error":"#REF!"}}]
[null,"Adresse",{"$f":"INDIRECT(ADDRESS($H$7,6,,,$I$6&\"Stammdaten\"))","v":{"$error":"#REF!"}},null,null,null,"Geburtstag",null,{"$f":"INDIRECT(ADDRESS($H$7,13,,,$I$6&\"Stammdaten\"))","v":{"$error":"#REF!"}}]
[null,"Ort",{"$f":"INDIRECT(ADDRESS($H$7,98,,,$I$6&\"Stammdaten\"))&\" \" &INDIRECT(ADDRESS($H$7,7,,,$I$6&\"Stammdaten\"))","v":{"$error":"#REF!"}},null,null,null,"Geschlecht",null,{"$f":"INDIRECT(ADDRESS($H$7,14,,,$I$6&\"Stammdaten\"))","v":{"$error":"#REF!"}}]
[null,"E-Mail",{"$f":"INDIRECT(ADDRESS($H$7,96,,,$I$6&\"Stammdaten\"))","v":{"$error":"#REF!"}},null,null,null,"Bürgerort",null,{"$f":"INDIRECT(ADDRESS($H$7,64,,,$I$6&\"Stammdaten\"))","v":{"$error":"#REF!"}}]
[null,"Telefon-Nr.",{"$f":"INDIRECT(ADDRESS($H$7,8,,,$I$6&\"Stammdaten\"))","v":{"$error":"#REF!"}},null,null,null,"Ausländerstatuts",null,{"$f":"INDIRECT(ADDRESS($H$7,65,,,$I$6&\"Stammdaten\"))","v":{"$error":"#REF!"}}]
[]
[null,"Anstellung"]
[null,"Eintritt",{"$f":"INDIRECT(ADDRESS($H$7,15,,,$I$6&\"Stammdaten\"))","v":{"$error":"#REF!"}},null,null,null,"Arbeitsort",{"$f":"INDIRECT(ADDRESS($H$7,10,,,$I$6&\"Stammdaten\"))","v":{"$error":"#REF!"}}]
[null,"Austritt",{"$f":"INDIRECT(ADDRESS($H$7,16,,,$I$6&\"Stammdaten\"))","v":{"$error":"#REF!"}},null,null,null,"Abteilung",{"$f":"INDIRECT(ADDRESS($H$7,11,,,$I$6&\"Stammdaten\"))","v":{"$error":"#REF!"}}]
[null,"Pensum",{"$f":"INDIRECT(ADDRESS($H$7,17,,,$I$6&\"Stammdaten\"))","v":{"$error":"#REF!"}},null,null,null,"Kostenstelle",{"$f":"INDIRECT(ADDRESS($H$7,57,,,$I$6&\"Stammdaten\"))","v":{"$error":"#REF!"}}]
[]
[null,"Bankverbindung 1",null,null,null,null,"Bankverbindung 2"]
[null,"Bank",{"$f":"INDIRECT(ADDRESS($H$7,18,,,$I$6&\"Stammdaten\"))","v":{"$error":"#REF!"}},null,null,null,"Bank",{"$f":"INDIRECT(ADDRESS($H$7,59,,,$I$6&\"Stammdaten\"))","v":{"$error":"#REF!"}}]
[null,"Bankort",{"$f":"INDIRECT(ADDRESS($H$7,19,,,$I$6&\"Stammdaten\"))","v":{"$error":"#REF!"}},null,null,null,"Bankort",{"$f":"INDIRECT(ADDRESS($H$7,60,,,$I$6&\"Stammdaten\"))","v":{"$error":"#REF!"}}]
[null,"Konto-Nr.",{"$f":"INDIRECT(ADDRESS($H$7,20,,,$I$6&\"Stammdaten\"))","v":{"$error":"#REF!"}},null,null,null,"Konto-Nr.",{"$f":"INDIRECT(ADDRESS($H$7,61,,,$I$6&\"Stammdaten\"))","v":{"$error":"#REF!"}}]
[null,"Clearing/PC",{"$f":"INDIRECT(ADDRESS($H$7,58,,,$I$6&\"Stammdaten\"))","v":{"$error":"#REF!"}},null,null,null,"Clearing/PC",{"$f":"INDIRECT(ADDRESS($H$7,62,,,$I$6&\"Stammdaten\"))","v":{"$error":"#REF!"}}]
[null,"IBAN",{"$f":"INDIRECT(ADDRESS($H$7,86,,,$I$6&\"Stammdaten\"))","v":{"$error":"#REF!"}},null,null,null,"IBAN",{"$f":"INDIRECT(ADDRESS($H$7,88,,,$I$6&\"Stammdaten\"))","v":{"$error":"#REF!"}}]
[null,"Kontoinhaber",{"$f":"INDIRECT(ADDRESS($H$7,21,,,$I$6&\"Stammdaten\"))","v":{"$error":"#REF!"}},null,null,null,"Kontoinhaber",{"$f":"INDIRECT(ADDRESS($H$7,63,,,$I$6&\"Stammdaten\"))","v":{"$error":"#REF!"}}]
[]
[null,"Lohn"]
[null,"Ferienentschädigung",null,null,{"$f":"INDIRECT(ADDRESS($H$7,22,,,$I$6&\"Stammdaten\"))","v":{"$error":"#REF!"}},null,"Basis für Ferien/Feiertage-",null,null,"Monatslohn",{"$f":"IF(INDIRECT(ADDRESS($H$7,67,,,$I$6&\"Stammdaten\")),\"ý\",\"¨\")","v":{"$error":"#REF!"}}]
[null,"Feiertage-Entschädigung",null,null,{"$f":"INDIRECT(ADDRESS($H$7,70,,,$I$6&\"Stammdaten\"))","v":{"$error":"#REF!"}},null,"Entschädigung",null,null,"Stundenlohn",{"$f":"IF(INDIRECT(ADDRESS($H$7,68,,,$I$6&\"Stammdaten\")),\"ý\",\"¨\")","v":{"$error":"#REF!"}}]
[null,"Durchlaufskonto",null,null,{"$f":"INDIRECT(ADDRESS($H$7,66,,,$I$6&\"Stammdaten\"))","v":{"$error":"#REF!"}},null,null,null,null,"Tageslohn",{"$f":"IF(INDIRECT(ADDRESS($H$7,69,,,$I$6&\"Stammdaten\")),\"ý\",\"¨\")","v":{"$error":"#REF!"}}]
[]
[null,"Sozialvers."]
[null,"KTG-Gruppe",{"$f":"\" \" & INDIRECT(ADDRESS($H$7,23,,,$I$6&\"Stammdaten\"))","v":{"$error":"#REF!"}},null,null,null,"KTG-Abzug in %",null,{"$f":"INDIRECT(ADDRESS($H$7,54,,,$I$6&\"Stammdaten\"))","v":{"$error":"#REF!"}},"BVG-Abz. In %",{"$f":"INDIRECT(ADDRESS($H$7,55,,,$I$6&\"Stammdaten\"))","v":{"$error":"#REF!"}}]
[null,"AHV-Pfl.",{"$f":"IF(INDIRECT(ADDRESS($H$7,24,,,$I$6&\"Stammdaten\")),\"ý\",\"¨\")","v":{"$error":"#REF!"}},"ALV-Pfl.",{"$f":"IF(INDIRECT(ADDRESS($H$7,25,,,$I$6&\"Stammdaten\")),\"ý\",\"¨\")","v":{"$error":"#REF!"}},null,"NBUV-Abzug in %",null,{"$f":"INDIRECT(ADDRESS($H$7,29,,,$I$6&\"Stammdaten\"))","v":{"$error":"#REF!"}},"UVG-Z in %",{"$f":"INDIRECT(ADDRESS($H$7,54,,,$I$6&\"Stammdaten\"))","v":{"$error":"#REF!"}}]
[null,"UVG-Pfl.",{"$f":"IF(INDIRECT(ADDRESS($H$7,26,,,$I$6&\"Stammdaten\")),\"ý\",\"¨\")","v":{"$error":"#REF!"}},"NBUV-Pfl.",{"$f":"IF(INDIRECT(ADDRESS($H$7,27,,,$I$6&\"Stammdaten\")),\"ý\",\"¨\")","v":{"$error":"#REF!"}},null,"GAV-Fix",null,{"$f":"IF(INDIRECT(ADDRESS($H$7,71,,,$I$6&\"Stammdaten\")),\"ý\",\"¨\")","v":{"$error":"#REF!"}},"GAV prop.",{"$f":"IF(INDIRECT(ADDRESS($H$7,72,,,$I$6&\"Stammdaten\")),\"ý\",\"¨\")","v":{"$error":"#REF!"}}]
[null,"FAK-Pfl.",{"$f":"IF(INDIRECT(ADDRESS($H$7,28,,,$I$6&\"Stammdaten\")),\"ý\",\"¨\")","v":{"$error":"#REF!"}},"UVG-Zusatz",{"$f":"IF(INDIRECT(ADDRESS($H$7,42,,,$I$6&\"Stammdaten\")),\"ý\",\"¨\")","v":{"$error":"#REF!"}},null,"AG übernimmt Soziallasten",null,null,"auf Naturallohn",{"$f":"IF(INDIRECT(ADDRESS($H$7,76,,,$I$6&\"Stammdaten\")),\"ý\",\"¨\")","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,null,null,"Privatanteil GW",{"$f":"IF(INDIRECT(ADDRESS($H$7,77,,,$I$6&\"Stammdaten\")),\"ý\",\"¨\")","v":{"$error":"#REF!"}}]
[]
[null,"Ferien/Ueberzeit",null,null,null,null,"Lohnausweis"]
[null,"Einträge Monatsspalte betreffen",null,null,{"$f":"IF(INDIRECT(ADDRESS($H$7,74,,,$I$6&\"Stammdaten\")),\"gleichen Mt.\",\"Vormonat\")","v":{"$error":"#REF!"}},null,"F: Unentgeltliche Beförderung",null,null,null,{"$f":"IF(INDIRECT(ADDRESS($H$7,47,,,$I$6&\"Stammdaten\")),\"ý\",\"¨\")","v":{"$error":"#REF!"}}]
[null,"Ferienanspruch dieses Jahr",null,null,{"$f":"INDIRECT(ADDRESS($H$7,30,,,$I$6&\"Stammdaten\"))","v":{"$error":"#REF!"}},null,"G: Kantineverpflegung/Lunch-Checks",null,null,null,{"$f":"IF(INDIRECT(ADDRESS($H$7,48,,,$I$6&\"Stammdaten\")),\"ý\",\"¨\")","v":{"$error":"#REF!"}}]
[null,"Ferienanspruch Vorjahr",null,null,{"$f":"INDIRECT(ADDRESS($H$7,31,,,$I$6&\"Stammdaten\"))","v":{"$error":"#REF!"}},null,"Beteiligungsrechte",null,null,null,{"$f":"IF(INDIRECT(ADDRESS($H$7,50,,,$I$6&\"Stammdaten\")),\"ý\",\"¨\")","v":{"$error":"#REF!"}}]
[null,"Saldovortrag",null,null,{"$f":"INDIRECT(ADDRESS($H$7,32,,,$I$6&\"Stammdaten\"))","v":{"$error":"#REF!"}},null,"Effektive Spesen nicht ausweis. (N-LA)",null,null,null,{"$f":"IF(INDIRECT(ADDRESS($H$7,75,,,$I$6&\"Stammdaten\")),\"ý\",\"¨\")","v":{"$error":"#REF!"}}]
[null,"Ueberzeit Saldovortrag",null,null,{"$f":"INDIRECT(ADDRESS($H$7,35,,,$I$6&\"Stammdaten\"))","v":{"$error":"#REF!"}},null,"Bemerkung 1:",{"$f":"INDIRECT(ADDRESS($H$7,52,,,$I$6&\"Stammdaten\"))","v":{"$error":"#REF!"}}]
[]
[null,"Quellensteuer",null,null,null,null,"Bemerkung 2:",{"$f":"INDIRECT(ADDRESS($H$7,52,,,$I$6&\"Stammdaten\"))","v":{"$error":"#REF!"}}]
[null,"Steuergemeinde",{"$f":"INDIRECT(ADDRESS($H$7,78,,,$I$6&\"Stammdaten\"))","v":{"$error":"#REF!"}}]
[null,null,null,"Kt.",{"$f":"INDIRECT(ADDRESS($H$7,79,,,$I$6&\"Stammdaten\"))","v":{"$error":"#REF!"}},null,"Bemerkung 3:",{"$f":"INDIRECT(ADDRESS($H$7,52,,,$I$6&\"Stammdaten\"))","v":{"$error":"#REF!"}}]
[null,"Tarif",{"$f":"INDIRECT(ADDRESS($H$7,80,,,$I$6&\"Stammdaten\"))","v":{"$error":"#REF!"}},"Kinder",{"$f":"INDIRECT(ADDRESS($H$7,81,,,$I$6&\"Stammdaten\"))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,"Bemerkung 4:",{"$f":"INDIRECT(ADDRESS($H$7,52,,,$I$6&\"Stammdaten\"))","v":{"$error":"#REF!"}}]
[]
[]
[null,"gedruckt am: ",{"$f":"TODAY()","v":"2019-02-08"}]

{"sheet":"Lohnart","index":9,"n_rows":15,"n_cols":20,"rows_kept":15,"cut":false,"hidden":true,"merged":[[3,1,3,9]]}
[null,null,null,null,null,9,-1,-1,"[hit Treuhand GmbH 2014.hle]"]
[null,{"$f":"INDIRECT(ADDRESS(5,2,,,$H$3&\"Parameter\"))","v":{"$error":"#REF!"}},null,null,null,null,0,null,null,null,null,null,66,null,null,null,null,null,{"$f":"INDIRECT(ADDRESS(8,3,,,$H$3&\"Parameter\"))&\" \"&INDIRECT(ADDRESS(8,2,,,$H$3&\"Parameter\"))","v":{"$error":"#REF!"}}]
[null,null,null,null,null,null,null,{"$f":"Lohnblatt!K3","v":"[]"}]
[null,"BVG Arbeitnehmer-Beitrag 2014"]
[]
[null,null,null,null,null,"Januar","Februar","März","April","Mai","Juni","Juli","August","September","Oktober","November","Dezember","Spezial","Jahr"]
[]
[null,null,null,null,"Total",{"$f":"SUM(F10:F15)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,"MA #","Zeile","Name, Vorname"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(F10:R10)","v":0},{"$f":"COUNTIF(F10:S10,\"<>0\")","v":13}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,13]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,13]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,13]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,13]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0,13]