{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["Daten","Copyright","Optionen"],"not_rendered":{"charts":0,"images":6,"macros":1,"external_links":1,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":4,"rows_kept":35,"cut":false,"hidden":false,"merged":[[34,1,34,2],[13,1,13,2],[32,1,32,2],[15,1,15,2],[6,1,7,4],[33,1,33,2],[33,3,33,4],[34,3,34,4]]}
[]
[null,"Excel-Inside Solutions"]
[null,"xls-GeldSplitter   [Eingabe]"]
[]
[]
[]
[null,"Ermittlung der optimalen Aufteilung des eingegebenen Geldbetrages in die geringste Anzahl an Scheinen und Münzen."]
[]
[]
[]
[]
[]
[]
[null,"Betrag:",null,1898.67]
[]
[null,"Scheine/Münzen",null,"Anzahl"]
[null,500,"Schein",{"$f":"ROUNDDOWN(D14/$B$17,0)","v":3}]
[null,200,"Schein",{"$f":"ROUNDDOWN(($D14-SUMPRODUCT(($D17:D17)*($B$17:B$17)))/B$18,0)","v":1}]
[null,100,"Schein",{"$f":"ROUNDDOWN(($D$14-SUMPRODUCT(($D$17:$D18)*($B$17:$B18)))/$B19,0)","v":1}]
[null,50,"Schein",{"$f":"ROUNDDOWN(($D$14-SUMPRODUCT(($D$17:$D19)*($B$17:$B19)))/$B20,0)","v":1}]
[null,20,"Schein",{"$f":"ROUNDDOWN(($D$14-SUMPRODUCT(($D$17:$D20)*($B$17:$B20)))/$B21,0)","v":2}]
[null,10,"Schein",{"$f":"ROUNDDOWN(($D$14-SUMPRODUCT(($D$17:$D21)*($B$17:$B21)))/$B22,0)","v":0}]
[null,5,"Schein",{"$f":"ROUNDDOWN(($D$14-SUMPRODUCT(($D$17:$D22)*($B$17:$B22)))/$B23,0)","v":1}]
[null,2,"Münze",{"$f":"ROUNDDOWN(($D$14-SUMPRODUCT(($D$17:$D23)*($B$17:$B23)))/$B24,0)","v":1}]
[null,1,"Münze",{"$f":"ROUNDDOWN(($D$14-SUMPRODUCT(($D$17:$D24)*($B$17:$B24)))/$B25,0)","v":1}]
[null,0.5,"Münze",{"$f":"ROUNDDOWN(($D$14-SUMPRODUCT(($D$17:$D25)*($B$17:$B25)))/$B26,0)","v":1}]
[null,0.2,"Münze",{"$f":"ROUNDDOWN(($D$14-SUMPRODUCT(($D$17:$D26)*($B$17:$B26)))/$B27,0)","v":0}]
[null,0.1,"Münze",{"$f":"ROUNDDOWN(($D$14-SUMPRODUCT(($D$17:$D27)*($B$17:$B27)))/$B28,0)","v":1}]
[null,0.05,"Münze",{"$f":"ROUNDDOWN(($D$14-SUMPRODUCT(($D$17:$D28)*($B$17:$B28)))/$B29,0)","v":1}]
[null,0.02,"Münze",{"$f":"ROUNDDOWN(($D$14-SUMPRODUCT(($D$17:$D29)*($B$17:$B29)))/$B30,0)","v":1}]
[null,0.01,"Münze",{"$f":"ROUND(($D$14-SUMPRODUCT(($D$17:$D30)*($B$17:$B30)))/$B31,0)","v":0}]
[]
[null,"Kontrollsumme:",null,{"$f":"SUMPRODUCT((D$17:D$31)*(B17:B31))","v":1898.6699999999998}]
[null,"Scheine:",null,{"$f":"\"Anzahl: \" & SUM(D17:D23) & \"    Summe: \" &SUMPRODUCT((D$17:D$23)*(B17:B23)) & \" €\"","v":"Anzahl: 9    Summe: 1895 €"}]
[null,"Münzen:",null,{"$f":"\"Anzahl: \" & SUM(D24:D31) & \"    Summe: \" &SUMPRODUCT((D$24:D$31)*(B24:B31))& \" €\"","v":"Anzahl: 6    Summe: 3,67 €"}]

{"sheet":"Copyright","index":1,"n_rows":18,"n_cols":4,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Excel-Inside Solutions"]
[null,"xls-GeldSplitter   [Copyright]"]
[]
[]
[]
[null,"Version",":","1.00 · 130617"]
[]
[null,"Contact",":","Alois Eckl"]
[null,null,null,"Grabbestraße 25"]
[null,null,null,"90427 Nürnberg"]
[null,null,null,"Germany"]
[]
[null,"Mail",":","alois.eckl@excel-inside.de"]
[null,"Web",":","www.excel-inside.de"]
[]
[]
[null,"Copyright",":","© 2013 by Excel-Inside Solutions - All rights reserved"]

{"sheet":"Optionen","index":2,"n_rows":6,"n_cols":4,"rows_kept":6,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Excel-Inside Solutions"]
[null,"xls-GeldSplitter   [Optionen]"]
[]
[]
[null,"Speicherkennzeichen:",null,"ja"]