{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Einfach","Korrekt"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Einfach","index":0,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["Name","Betrag","Löschung","Neuer Betrag"]
["Summe",{"$f":"SUM(B3:B12)","v":94020},{"$f":"SUM(C3:C12)","v":40000},{"$f":"SUM(D3:D12)","v":94020.01999999999}]
["Lehmann",49000,null,{"$f":"ROUND(C3*$B$2/$C$2,2)","v":0}]
["Schulze",6000,6000,{"$f":"ROUND(C4*$B$2/$C$2,2)","v":14103}]
["Schultze",5750,5750,13515.38]
["Schmidt",5500,5500,12927.75]
["Schmitt",5270,5250,12340.13]
["Müller",5000,null,0]
["Maier",4750,4750,11164.88]
["Mayer",4500,4500,10577.25]
["Meier",4250,4250,9989.6299999999992]
["Meyer",4000,4000,9402]

{"sheet":"Korrekt","index":1,"n_rows":13,"n_cols":4,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[null,null,"Runden auf Nachkommastellen:",-1]
["Name","Betrag","Löschung","Neuer Betrag"]
["Summe",{"$f":"SUM(B4:B13)","v":94020},{"$f":"SUM(C4:C13)","v":40000},{"$f":"SUM(D4:D13)","v":94020}]
["Lehmann",49000,null,{"$f":"RoundToSum(C4:C13*$B$3/$C$3,D1)","v":0}]
["Schulze",6000,6000,14100]
["Schultze",5750,5750,13520]
["Schmidt",5500,5500,12930]
["Schmitt",5270,5250,12340]
["Müller",5000,null,0]
["Maier",4750,4750,11160]
["Mayer",4500,4500,10580]
["Meier",4250,4250,9990]
["Meyer",4000,4000,9400]