{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Split up amount","Auxiliary"],"not_rendered":{"charts":0,"images":27,"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":"Split up amount","index":0,"n_rows":19,"n_cols":5,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Split an amount in the smallest number of notes and coins"]
[null,"Currently featured:",null,"€",547.57000000000005]
[null,"$"]
[null,"€",null,"Amount","Number"]
[null,null,null,{"$f":"OFFSET(Auxiliary!$A$1,ROW()-4,2*(MATCH($D$2,$B$3:$B$4,0)-1))","v":500},{"$f":"IF(ISNUMBER(D5),IF(E2>=D5,INT(E2/D5),0),\"\")","v":1}]
[null,null,null,{"$f":"OFFSET(Auxiliary!$A$1,ROW()-4,2*(MATCH($D$2,$B$3:$B$4,0)-1))","v":200},{"$f":"IF(ISNUMBER(D6),IF(ROUND(E$2-SUMPRODUCT(D$5:D5,INT(E$5:E5)),2)>=D6,INT(ROUND((E$2-SUMPRODUCT(D$5:D5,E$5:E5)),2)/D6),0),\"\")","v":0}]
[null,"Wim Gielis (Wigi)",null,{"$f":"OFFSET(Auxiliary!$A$1,ROW()-4,2*(MATCH($D$2,$B$3:$B$4,0)-1))","v":100},{"$f":"IF(ISNUMBER(D7),IF(ROUND(E$2-SUMPRODUCT(D$5:D6,INT(E$5:E6)),2)>=D7,INT(ROUND((E$2-SUMPRODUCT(D$5:D6,E$5:E6)),2)/D7),0),\"\")","v":0}]
[null,"Version 1.2 (fixed a bug)",null,{"$f":"OFFSET(Auxiliary!$A$1,ROW()-4,2*(MATCH($D$2,$B$3:$B$4,0)-1))","v":50},{"$f":"IF(ISNUMBER(D8),IF(ROUND(E$2-SUMPRODUCT(D$5:D7,INT(E$5:E7)),2)>=D8,INT(ROUND((E$2-SUMPRODUCT(D$5:D7,E$5:E7)),2)/D8),0),\"\")","v":0}]
[null,"2007-04-25",null,{"$f":"OFFSET(Auxiliary!$A$1,ROW()-4,2*(MATCH($D$2,$B$3:$B$4,0)-1))","v":20},{"$f":"IF(ISNUMBER(D9),IF(ROUND(E$2-SUMPRODUCT(D$5:D8,INT(E$5:E8)),2)>=D9,INT(ROUND((E$2-SUMPRODUCT(D$5:D8,E$5:E8)),2)/D9),0),\"\")","v":2}]
[null,null,null,{"$f":"OFFSET(Auxiliary!$A$1,ROW()-4,2*(MATCH($D$2,$B$3:$B$4,0)-1))","v":10},{"$f":"IF(ISNUMBER(D10),IF(ROUND(E$2-SUMPRODUCT(D$5:D9,INT(E$5:E9)),2)>=D10,INT(ROUND((E$2-SUMPRODUCT(D$5:D9,E$5:E9)),2)/D10),0),\"\")","v":0}]
[null,null,null,{"$f":"OFFSET(Auxiliary!$A$1,ROW()-4,2*(MATCH($D$2,$B$3:$B$4,0)-1))","v":5},{"$f":"IF(ISNUMBER(D11),IF(ROUND(E$2-SUMPRODUCT(D$5:D10,INT(E$5:E10)),2)>=D11,INT(ROUND((E$2-SUMPRODUCT(D$5:D10,E$5:E10)),2)/D11),0),\"\")","v":1}]
[null,null,null,{"$f":"OFFSET(Auxiliary!$A$1,ROW()-4,2*(MATCH($D$2,$B$3:$B$4,0)-1))","v":2},{"$f":"IF(ISNUMBER(D12),IF(ROUND(E$2-SUMPRODUCT(D$5:D11,INT(E$5:E11)),2)>=D12,INT(ROUND((E$2-SUMPRODUCT(D$5:D11,E$5:E11)),2)/D12),0),\"\")","v":1}]
[null,null,null,{"$f":"OFFSET(Auxiliary!$A$1,ROW()-4,2*(MATCH($D$2,$B$3:$B$4,0)-1))","v":1},{"$f":"IF(ISNUMBER(D13),IF(ROUND(E$2-SUMPRODUCT(D$5:D12,INT(E$5:E12)),2)>=D13,INT(ROUND((E$2-SUMPRODUCT(D$5:D12,E$5:E12)),2)/D13),0),\"\")","v":0}]
[null,null,null,{"$f":"OFFSET(Auxiliary!$A$1,ROW()-4,2*(MATCH($D$2,$B$3:$B$4,0)-1))","v":0.5},{"$f":"IF(ISNUMBER(D14),IF(ROUND(E$2-SUMPRODUCT(D$5:D13,INT(E$5:E13)),2)>=D14,INT(ROUND((E$2-SUMPRODUCT(D$5:D13,E$5:E13)),2)/D14),0),\"\")","v":1}]
[null,null,null,{"$f":"OFFSET(Auxiliary!$A$1,ROW()-4,2*(MATCH($D$2,$B$3:$B$4,0)-1))","v":0.2},{"$f":"IF(ISNUMBER(D15),IF(ROUND(E$2-SUMPRODUCT(D$5:D14,INT(E$5:E14)),2)>=D15,INT(ROUND((E$2-SUMPRODUCT(D$5:D14,E$5:E14)),2)/D15),0),\"\")","v":0}]
[null,null,null,{"$f":"OFFSET(Auxiliary!$A$1,ROW()-4,2*(MATCH($D$2,$B$3:$B$4,0)-1))","v":0.1},{"$f":"IF(ISNUMBER(D16),IF(ROUND(E$2-SUMPRODUCT(D$5:D15,INT(E$5:E15)),2)>=D16,INT(ROUND((E$2-SUMPRODUCT(D$5:D15,E$5:E15)),2)/D16),0),\"\")","v":0}]
[null,null,null,{"$f":"OFFSET(Auxiliary!$A$1,ROW()-4,2*(MATCH($D$2,$B$3:$B$4,0)-1))","v":0.05},{"$f":"IF(ISNUMBER(D17),IF(ROUND(E$2-SUMPRODUCT(D$5:D16,INT(E$5:E16)),2)>=D17,INT(ROUND((E$2-SUMPRODUCT(D$5:D16,E$5:E16)),2)/D17),0),\"\")","v":1}]
[null,null,null,{"$f":"OFFSET(Auxiliary!$A$1,ROW()-4,2*(MATCH($D$2,$B$3:$B$4,0)-1))","v":0.02},{"$f":"IF(ISNUMBER(D18),IF(ROUND(E$2-SUMPRODUCT(D$5:D17,INT(E$5:E17)),2)>=D18,INT(ROUND((E$2-SUMPRODUCT(D$5:D17,E$5:E17)),2)/D18),0),\"\")","v":1}]
[null,null,null,{"$f":"OFFSET(Auxiliary!$A$1,ROW()-4,2*(MATCH($D$2,$B$3:$B$4,0)-1))","v":0.01},{"$f":"IF(ISNUMBER(D19),IF(ROUND(E$2-SUMPRODUCT(D$5:D18,INT(E$5:E18)),2)>=D19,INT(ROUND((E$2-SUMPRODUCT(D$5:D18,E$5:E18)),2)/D19),0),\"\")","v":0}]

{"sheet":"Auxiliary","index":1,"n_rows":16,"n_cols":3,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Dollar",null,"Euro"]
[100,null,500]
[50,null,200]
[20,null,100]
[10,null,50]
[5,null,20]
[2,null,10]
[1,null,5]
[0.5,null,2]
[0.25,null,1]
[0.1,null,0.5]
[0.05,null,0.2]
[0.01,null,0.1]
["",null,0.05]
["",null,0.02]
["",null,0.01]