{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Monatsmeldung","Sätze"],"not_rendered":{"charts":0,"images":0,"macros":1,"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":"Monatsmeldung","index":0,"n_rows":16,"n_cols":48,"rows_kept":16,"cut":false,"hidden":false,"merged":[[16,0,21,4],[16,10,18,32],[16,5,18,9],[7,1,9,1],[10,1,12,1],[13,1,15,1],[21,10,21,32],[21,5,21,9],[19,5,20,9],[19,10,20,32],[21,33,21,38],[16,39,18,44],[19,39,19,44],[20,39,20,44],[21,39,21,44],[16,33,18,38],[19,33,19,38],[20,33,20,38],[0,0,2,6],[0,7,2,20],[0,21,2,44],[13,0,15,0],[13,2,15,2],[13,3,15,3],[13,36,13,38],[13,39,15,44],[14,36,14,38],[15,36,15,38],[7,39,9,44],[10,0,12,0],[10,2,12,2],[10,3,12,3],[10,36,10,38],[10,39,12,44],[11,36,11,38],[12,36,12,38],[7,0,9,0],[7,2,9,2],[7,3,9,3],[4,36,4,38],[5,36,5,38],[6,36,6,38],[7,36,7,38],[8,36,8,38],[9,36,9,38],[3,36,3,38],[4,1,6,1],[4,0,6,0],[4,2,6,2],[4,3,6,3],[3,39,3,44],[4,39,6,44]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"11.02.2025 - 30.02.2025"]
[]
[]
["PersNr.","Michaela Feld","Name","Vorname",null,1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,"V-Geld",null,null,"Summe"]
[12345678,null,"Mustermann","Max","F",null,null,null,null,null,null,null,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":"COUNTIF(F5:AJ5,\"u\")*Sätze!$I$15+COUNTIF(F5:AJ5,\"x\")*Sätze!$I$16+COUNTIF(F5:AJ5,\"p\")*Sätze!$I$17","v":0},null,null,{"$f":"SUM(AK5:AM7)","v":0},null,null,null,null,null,{"$f":"IF(AND(AK5<>0,E5=\"F\"),AK5/2.3,0)","v":0}]
[null,null,null,null,"M",null,null,null,null,null,null,null,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":"COUNTIF(F6:AJ6,\"u\")*Sätze!$K$15+COUNTIF(F6:AJ6,\"x\")*Sätze!$K$16+COUNTIF(F6:AJ6,\"p\")*Sätze!$K$17","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(AK6>0,E6=\"M\"),AK6/4.4,0)","v":0}]
[null,null,null,null,"A",null,null,null,null,null,null,null,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":"COUNTIF(F7:AJ7,\"u\")*Sätze!$K$15+COUNTIF(F7:AJ7,\"x\")*Sätze!$K$16+COUNTIF(F7:AJ7,\"p\")*Sätze!$K$17","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(AK7>0,E7=\"A\"),AK7/4.4,0)","v":0}]
[null,null,null,null,"F",null,null,null,null,null,null,null,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":"COUNTIF(F8:AJ8,\"u\")*Sätze!$I$15+COUNTIF(F8:AJ8,\"x\")*Sätze!$I$16+COUNTIF(F8:AJ8,\"p\")*Sätze!$I$17","v":0},null,null,{"$f":"SUM(AK8:AM10)","v":0},null,null,null,null,null,{"$f":"IF(AND(AK8<>0,E8=\"F\"),AK8/2.3,0)","v":0}]
[null,null,null,null,"M",null,null,null,null,null,null,null,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":"COUNTIF(F9:AJ9,\"u\")*Sätze!$K$15+COUNTIF(F9:AJ9,\"x\")*Sätze!$K$16+COUNTIF(F9:AJ9,\"p\")*Sätze!$K$17","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(AK9>0,E9=\"M\"),AK9/4.4,0)","v":0}]
[null,null,null,null,"A",null,null,null,null,null,null,null,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":"COUNTIF(F10:AJ10,\"u\")*Sätze!$K$15+COUNTIF(F10:AJ10,\"x\")*Sätze!$K$16+COUNTIF(F10:AJ10,\"p\")*Sätze!$K$17","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(AK10>0,E10=\"A\"),AK10/4.4,0)","v":0}]
[null,null,null,null,"F",null,null,null,null,null,null,null,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":"COUNTIF(F11:AJ11,\"u\")*Sätze!$I$15+COUNTIF(F11:AJ11,\"x\")*Sätze!$I$16+COUNTIF(F11:AJ11,\"p\")*Sätze!$I$17","v":0},null,null,{"$f":"SUM(AK11:AM13)","v":0},null,null,null,null,null,{"$f":"IF(AND(AK11<>0,E11=\"F\"),AK11/2.3,0)","v":0}]
[null,null,null,null,"M",null,null,null,null,null,null,null,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":"COUNTIF(F12:AJ12,\"u\")*Sätze!$K$15+COUNTIF(F12:AJ12,\"x\")*Sätze!$K$16+COUNTIF(F12:AJ12,\"p\")*Sätze!$K$17","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(AK12>0,E12=\"M\"),AK12/4.4,0)","v":0}]
[null,null,null,null,"A",null,null,null,null,null,null,null,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":"COUNTIF(F13:AJ13,\"u\")*Sätze!$K$15+COUNTIF(F13:AJ13,\"x\")*Sätze!$K$16+COUNTIF(F13:AJ13,\"p\")*Sätze!$K$17","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(AK13>0,E13=\"A\"),AK13/4.4,0)","v":0}]
[null,null,null,null,"F",null,null,null,null,null,null,null,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":"COUNTIF(F14:AJ14,\"u\")*Sätze!$I$15+COUNTIF(F14:AJ14,\"x\")*Sätze!$I$16+COUNTIF(F14:AJ14,\"p\")*Sätze!$I$17","v":0},null,null,{"$f":"SUM(AK14:AM16)","v":0},null,null,null,null,null,{"$f":"IF(AND(AK14<>0,E14=\"F\"),AK14/2.3,0)","v":0}]
[null,null,null,null,"M",null,null,null,null,null,null,null,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":"COUNTIF(F15:AJ15,\"u\")*Sätze!$K$15+COUNTIF(F15:AJ15,\"x\")*Sätze!$K$16+COUNTIF(F15:AJ15,\"p\")*Sätze!$K$17","v":0},null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(AK15>0,E15=\"M\"),AK15/4.4,0)","v":0}]
[null,null,null,null,"A",null,null,null,null,null,null,null,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":"COUNTIF(F16:AJ16,\"u\")*Sätze!$K$15+COUNTIF(F16:AJ16,\"x\")*Sätze!$K$16+COUNTIF(F16:AJ16,\"p\")*Sätze!$K$17","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND(AK16>0,E16=\"A\"),AK16/4.4,0)","v":0}]

{"sheet":"Sätze","index":1,"n_rows":17,"n_cols":14,"rows_kept":17,"cut":false,"hidden":false,"merged":[[13,6,13,12]]}
["S"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,"Verpflegungsgeld",null,null,null,null,null,null,"Gesamt"]
[null,null,null,null,null,null,"Wertansatz","F",2.17,"M",4.13,"A",4.13,{"$f":"I15+K15+M15","v":10.43}]
[null,null,null,null,null,null,"Sachbezugswertes","F",2.2999999999999998,"M",4.4000000000000004,"A",4.4000000000000004,{"$f":"I16+K16+M16","v":11.100000000000001}]
[null,null,null,null,null,null,"V-Geld mit Personal und Sachkosten","F",null,"M",null,"A",null,{"$f":"I17+K17+M17","v":0}]