{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Daten","Tabelle1","Pivot"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":2},"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":"Daten","index":0,"n_rows":35,"n_cols":6,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[]
[]
["Name","Anzahl","Gesamtpreis","Leistungsname","Rechnungs-empfänger","Rechnungs-datum"]
["Müller",1.35,123.81,"Leistung 1","B","2025-07-31"]
["Müller",497,248.5,"Leistung 2","B","2025-07-31"]
["Müller",19.59,496.21,"Leistung 3","A","2025-07-31"]
["Müller",1.34,57.9,"Leistung 4","B","2025-07-31"]
["Müller",1.34,29.48,"Leistung 4","A","2025-07-31"]
["Müller",45.81,1160.3699999999999,"Leistung 3","A","2025-08-31"]
["Müller",45.81,3040.87,"Leistung 3","B","2025-08-31"]
["Müller",1224.9000000000001,612.45000000000005,"Leistung 2","B","2025-08-31"]
["Müller",12.27,466.26,"Leistung 5","A","2025-08-31"]
["Müller",12.27,659.02,"Leistung 5","B","2025-08-31"]
["Müller",0.67,18.62,"Leistung 6","B","2025-08-31"]
["Müller",0.67,10.27,"Leistung 6","A","2025-08-31"]
["Müller",9,4.5,"Leistung 7","A","2025-08-31"]
["Müller",15.42,390.59,"Leistung 3","A","2025-09-08"]
["Müller",387,193.5,"Leistung 2","B","2025-09-30"]
["Müller",0.28000000000000003,4.29,"Leistung 6","A","2025-09-08"]
["Müller",0.28000000000000003,7.78,"Leistung 6","B","2025-09-30"]
["Müller",2.44,92.72,"Leistung 5","A","2025-09-08"]
["Müller",2.44,131.05000000000001,"Leistung 5","B","2025-09-30"]
["Maier",1.22,111.89,"Leistung 1","B","2025-10-31"]
["Maier",71.2,35.6,"Leistung 2","B","2025-10-31"]
["Maier",5.68,416.8,"Leistung 3","B","2025-10-31"]
["Maier",5.68,104.11,"Leistung 3","A","2025-10-31"]
["Maier",1.17,21.45,"Leistung 8","A","2025-10-31"]
["Maier",1.17,85.85,"Leistung 8","B","2025-10-31"]
["Maier",8.67,158.91999999999999,"Leistung 3","A","2025-11-30"]
["Maier",8.67,636.20000000000005,"Leistung 3","B","2025-11-30"]
["Maier",113.3,56.65,"Leistung 2","B","2025-11-30"]
["Maier",3.52,64.52,"Leistung 8","A","2025-11-30"]
["Schmid",1.98,181.59,"Leistung 1","B","2025-08-31"]
["Schmid",4.51,74.28,"Leistung 3","A","2025-08-25"]
["Schmid",51.8,25.9,"Leistung 2","B","2025-08-31"]

{"sheet":"Tabelle1","index":1,"n_rows":34,"n_cols":9,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,null,"Werte","Rechnungs-empfänger"]
[null,null,null,"Gesamtpreis",null,"Hinweis",null,"Gesamt: Gesamtpreis","Gesamt: Hinweis"]
["Name","Leistungsname","Rechnungs-datum","A","B","A","B"]
["Maier","Leistung 1","2025-10-31",null,111.89,null,"OK",111.89,"OK"]
[null,"Leistung 2","2025-10-31",null,35.6,null,"OK",35.6,"OK"]
[null,null,"2025-11-30",null,56.65,null,"OK",56.65,"OK"]
[null,"Leistung 3","2025-10-31",104.11,416.8,"nur A zahlt","OK",520.91,"OK"]
[null,null,"2025-11-30",158.91999999999999,636.20000000000005,"nur A zahlt","OK",795.12,"OK"]
[null,"Leistung 8","2025-10-31",21.45,85.85,"nur A zahlt","OK",107.3,"OK"]
[null,null,"2025-11-30",64.52,null,"nur A zahlt",null,64.52,"nur A zahlt"]
["Maier Ergebnis",null,null,349,1342.99,"OK","OK",1691.99,"OK"]
["Müller","Leistung 1","2025-07-31",null,123.81,null,"OK",123.81,"OK"]
[null,"Leistung 2","2025-07-31",null,248.5,null,"OK",248.5,"OK"]
[null,null,"2025-08-31",null,612.45000000000005,null,"OK",612.45000000000005,"OK"]
[null,null,"2025-09-30",null,193.5,null,"OK",193.5,"OK"]
[null,"Leistung 3","2025-07-31",496.21,null,"nur A zahlt",null,496.21,"nur A zahlt"]
[null,null,"2025-08-31",1160.3699999999999,3040.87,"nur A zahlt","OK",4201.24,"OK"]
[null,null,"2025-09-08",390.59,null,"nur A zahlt",null,390.59,"nur A zahlt"]
[null,"Leistung 4","2025-07-31",29.48,57.9,"nur A zahlt","OK",87.38,"OK"]
[null,"Leistung 5","2025-08-31",466.26,659.02,"nur A zahlt","OK",1125.28,"OK"]
[null,null,"2025-09-08",92.72,null,"nur A zahlt",null,92.72,"nur A zahlt"]
[null,null,"2025-09-30",null,131.05000000000001,null,"OK",131.05000000000001,"OK"]
[null,"Leistung 6","2025-08-31",10.27,18.62,"nur A zahlt","OK",28.89,"OK"]
[null,null,"2025-09-08",4.29,null,"nur A zahlt",null,4.29,"nur A zahlt"]
[null,null,"2025-09-30",null,7.78,null,"OK",7.78,"OK"]
[null,"Leistung 7","2025-08-31",4.5,null,"nur A zahlt",null,4.5,"nur A zahlt"]
["Müller Ergebnis",null,null,2654.69,5093.5,"OK","OK",7748.19,"OK"]
["Schmid","Leistung 1","2025-08-31",null,181.59,null,"OK",181.59,"OK"]
[null,"Leistung 2","2025-08-31",null,25.9,null,"OK",25.9,"OK"]
[null,"Leistung 3","2025-08-25",74.28,null,"nur A zahlt",null,74.28,"nur A zahlt"]
["Schmid Ergebnis",null,null,74.28,207.49,"nur A zahlt","OK",281.77,"OK"]
["Gesamtergebnis",null,null,3077.97,6643.98,"OK","OK",9721.9500000000007,"OK"]

{"sheet":"Pivot","index":2,"n_rows":33,"n_cols":15,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
["in einem berechnentem Feld wird gesucht die Zeilen, wo A Kosten hat aber B keine"]
[]
["Summe von Gesamtpreis",null,null,"Rechnungs-empfänger"]
["Name","Leistungsname","Rechnungs-datum","A","B","Gesamtergebnis"]
["Maier","Leistung 1","2025-10-31",null,111.89,111.89,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D5>0.01,E5=0),\"nur A zahlt\",\"ok\")","v":"ok"}]
[null,"Leistung 2","2025-10-31",null,35.6,35.6,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D6>0.01,E6=0),\"nur A zahlt\",\"ok\")","v":"ok"}]
[null,null,"2025-11-30",null,56.65,56.65,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D7>0.01,E7=0),\"nur A zahlt\",\"ok\")","v":"ok"}]
[null,"Leistung 3","2025-10-31",104.11,416.8,520.91,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D8>0.01,E8=0),\"nur A zahlt\",\"ok\")","v":"ok"}]
[null,null,"2025-11-30",158.91999999999999,636.20000000000005,795.12,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D9>0.01,E9=0),\"nur A zahlt\",\"ok\")","v":"ok"}]
[null,"Leistung 8","2025-10-31",21.45,85.85,107.3,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D10>0.01,E10=0),\"nur A zahlt\",\"ok\")","v":"ok"}]
[null,null,"2025-11-30",64.52,null,64.52,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D11>0.01,E11=0),\"nur A zahlt\",\"ok\")","v":"nur A zahlt"}]
["Maier Ergebnis",null,null,348.99999999999994,1342.99,1691.99,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D12>0.01,E12=0),\"nur A zahlt\",\"ok\")","v":"ok"}]
["Müller","Leistung 1","2025-07-31",null,123.81,123.81,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D13>0.01,E13=0),\"nur A zahlt\",\"ok\")","v":"ok"}]
[null,"Leistung 2","2025-07-31",null,248.5,248.5,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D14>0.01,E14=0),\"nur A zahlt\",\"ok\")","v":"ok"}]
[null,null,"2025-08-31",null,612.45000000000005,612.45000000000005,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D15>0.01,E15=0),\"nur A zahlt\",\"ok\")","v":"ok"}]
[null,null,"2025-09-30",null,193.5,193.5,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D16>0.01,E16=0),\"nur A zahlt\",\"ok\")","v":"ok"}]
[null,"Leistung 3","2025-07-31",496.21,null,496.21,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D17>0.01,E17=0),\"nur A zahlt\",\"ok\")","v":"nur A zahlt"}]
[null,null,"2025-08-31",1160.3699999999999,3040.87,4201.24,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D18>0.01,E18=0),\"nur A zahlt\",\"ok\")","v":"ok"}]
[null,null,"2025-09-08",390.59,null,390.59,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D19>0.01,E19=0),\"nur A zahlt\",\"ok\")","v":"nur A zahlt"}]
[null,"Leistung 4","2025-07-31",29.48,57.9,87.38,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D20>0.01,E20=0),\"nur A zahlt\",\"ok\")","v":"ok"}]
[null,"Leistung 5","2025-08-31",466.26,659.02,1125.28,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D21>0.01,E21=0),\"nur A zahlt\",\"ok\")","v":"ok"}]
[null,null,"2025-09-08",92.72,null,92.72,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D22>0.01,E22=0),\"nur A zahlt\",\"ok\")","v":"nur A zahlt"}]
[null,null,"2025-09-30",null,131.05000000000001,131.05000000000001,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D23>0.01,E23=0),\"nur A zahlt\",\"ok\")","v":"ok"}]
[null,"Leistung 6","2025-08-31",10.27,18.62,28.89,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D24>0.01,E24=0),\"nur A zahlt\",\"ok\")","v":"ok"}]
[null,null,"2025-09-08",4.29,null,4.29,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D25>0.01,E25=0),\"nur A zahlt\",\"ok\")","v":"nur A zahlt"}]
[null,null,"2025-09-30",null,7.78,7.78,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D26>0.01,E26=0),\"nur A zahlt\",\"ok\")","v":"ok"}]
[null,"Leistung 7","2025-08-31",4.5,null,4.5,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D27>0.01,E27=0),\"nur A zahlt\",\"ok\")","v":"nur A zahlt"}]
["Müller Ergebnis",null,null,2654.6899999999996,5093.4999999999991,7748.1900000000005,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D28>0.01,E28=0),\"nur A zahlt\",\"ok\")","v":"ok"}]
["Schmid","Leistung 1","2025-08-31",null,181.59,181.59,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D29>0.01,E29=0),\"nur A zahlt\",\"ok\")","v":"ok"}]
[null,"Leistung 2","2025-08-31",null,25.9,25.9,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D30>0.01,E30=0),\"nur A zahlt\",\"ok\")","v":"ok"}]
[null,"Leistung 3","2025-08-25",74.28,null,74.28,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D31>0.01,E31=0),\"nur A zahlt\",\"ok\")","v":"nur A zahlt"}]
["Schmid Ergebnis",null,null,74.28,207.49,281.77,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D32>0.01,E32=0),\"nur A zahlt\",\"ok\")","v":"ok"}]
["Gesamtergebnis",null,null,3077.97,6643.9799999999987,9721.9500000000007,null,null,null,null,null,null,null,null,{"$f":"IF(AND(D33>0.01,E33=0),\"nur A zahlt\",\"ok\")","v":"ok"}]