{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Hans Muster"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":1,"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":"Hans Muster","index":0,"n_rows":45,"n_cols":4,"rows_kept":45,"cut":false,"hidden":false,"merged":[]}
["Muster AG"]
["Seestrasse 100"]
["9999 Irgendwo"]
[]
[]
[]
[null,null,null,"Herr"]
[null,null,null,"Hans Muster"]
[null,null,null,"Seestrasse 55"]
[null,null,null,"9999 Irgendwo"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["LOHNABRECHNUNG"]
[]
[null,"Faktor","Einheit"]
["Bruttolohn",1,14000,{"$f":"B23*C23","v":14000}]
["Ferienentschädigung",0,null,{"$f":"+D23*B24","v":0}]
["Total Bruttolohn",null,null,{"$f":"+D24+D23","v":14000}]
[]
["Abzüge:","%"]
["AHV",5.3,{"$f":"+D25","v":14000},{"$f":"+C28*B28%","v":742}]
["ALV",1.1000000000000001,{"$f":"IF(D23>12350,12350,D23)","v":12350},{"$f":"+C29*B29%","v":135.85000000000002}]
["ALV 2",0.5,{"$f":"(IF(D23>12350,D23-12350,))","v":1650},{"$f":"+C30*B30%","v":8.25}]
["NBU",1.1000000000000001,{"$f":"IF(D25>12350,12350,D25)","v":12350},{"$f":"+C31*B31%","v":135.85000000000002}]
["KTG",0.38350000000000001,{"$f":"+D25","v":14000},{"$f":"+C32*B32%","v":53.69}]
["BVG","Fix",null,606.15]
["Total Abzüge",null,null,{"$f":"SUM(D28:D33)","v":1681.79}]
[]
["Nettolohn",null,null,{"$f":"+D25-D34","v":12318.21}]
[]
["Zulagen/Abzüge:"]
["Kinderzulage",null,null,500]
["Spesen",null,null,400]
["Total Zulagen/Abzüge",null,null,{"$f":"SUM(D39:D40)","v":900}]
[]
[]
[]
["Auszahlung",null,null,{"$f":"+D25-D34+D41","v":13218.21}]