{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Einfach","Korrekt","Simple","Correct"],"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":8,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,5,0,7],[1,6,1,7]]}
["Name","Betrag","Löschung","Neuer Betrag",null,"Tabellenblattformeln"]
["Summe",{"$f":"SUM(B3:B12)","v":94020},{"$f":"SUM(C3:C12)","v":40000},{"$f":"SUM(D3:D12)","v":94020.01999999999},null,"Bereich","Formel"]
["Lehmann",49000,null,{"$f":"ROUND(C3:C12*$B$2/$C$2,2)","v":0},null,"B2:D2","B2",{"$f":"sbGetCell(INDIRECT(G3),6)","v":"=SUMME(B3:B12)"}]
["Schulze",6000,6000,14103,null,"D3","D3",{"$f":"sbGetCell(INDIRECT(G4),6)","v":"=RUNDEN(C3:C12*$B$2/$C$2;2)"}]
["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":8,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,5,0,7],[1,6,1,7]]}
[null,null,"Runden auf Nachkommastellen:",-1,null,"Tabellenblattformeln"]
["Name","Betrag","Löschung","Neuer Betrag",null,"Bereich","Formel"]
["Summe",{"$f":"SUM(B4:B13)","v":94020},{"$f":"SUM(C4:C13)","v":40000},{"$f":"SUM(D4:D13)","v":94020},null,"B3:D3","D3",{"$f":"sbGetCell(INDIRECT(G3),6)","v":"=SUMME(D4:D13)"}]
["Lehmann",49000,null,{"$f":"RoundToSum(C4:C13*$B$3/$C$3,D1)","v":0},null,"D4","D4",{"$f":"sbGetCell(INDIRECT(G4),6)","v":"=RoundToSum(C4:C13*$B$3/$C$3;D1)"}]
["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]

{"sheet":"Simple","index":2,"n_rows":12,"n_cols":8,"rows_kept":12,"cut":false,"hidden":false,"merged":[[0,5,0,7],[1,6,1,7]]}
["Name","Amount","Deletion","New Amount",null,"Worksheet Formulas"]
["Sum",{"$f":"SUM(B3:B12)","v":94020},{"$f":"SUM(C3:C12)","v":40000},{"$f":"SUM(D3:D12)","v":94020.01999999999},null,"Range","Formula"]
["Lehmann",49000,null,{"$f":"ROUND(C3:C12*$B$2/$C$2,2)","v":0},null,"B2:D2","B2",{"$f":"sbGetCell(INDIRECT(G3),41)","v":"=SUM(B3:B12)"}]
["Schulze",6000,6000,14103,null,"D3","D3",{"$f":"sbGetCell(INDIRECT(G4),41)","v":"=ROUND(C3:C12*$B$2/$C$2,2)"}]
["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":"Correct","index":3,"n_rows":13,"n_cols":8,"rows_kept":13,"cut":false,"hidden":false,"merged":[[0,5,0,7],[1,6,1,7]]}
[null,null,"Round to [digits]:",-1,null,"Worksheet Formulas"]
["Name","Amount","Deletion","New Amount",null,"Range","Formula"]
["Sum",{"$f":"SUM(B4:B13)","v":94020},{"$f":"SUM(C4:C13)","v":40000},{"$f":"SUM(D4:D13)","v":94020},null,"B3:D3","D3",{"$f":"sbGetCell(INDIRECT(G3),41)","v":"=SUM(D4:D13)"}]
["Lehmann",49000,null,{"$f":"RoundToSum(C4:C13*$B$3/$C$3,D1)","v":0},null,"D4","D4",{"$f":"sbGetCell(INDIRECT(G4),41)","v":"=RoundToSum(C4:C13*$B$3/$C$3,D1)"}]
["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]