{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Dandenong & Springvale"],"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":"Dandenong & Springvale","index":0,"n_rows":18,"n_cols":8,"rows_kept":18,"cut":false,"hidden":false,"merged":[[9,0,9,1],[9,2,9,3],[9,6,9,7],[10,0,10,1],[10,2,10,3],[10,6,10,7],[11,0,11,1],[11,2,11,3],[11,6,11,7],[12,0,12,1],[12,2,12,3],[12,6,12,7],[8,0,8,1],[8,2,8,3],[8,6,8,7],[5,2,5,3],[5,6,5,7],[6,0,6,1],[6,2,6,3],[6,6,6,7],[5,0,5,1],[7,0,7,1],[7,2,7,3],[7,6,7,7],[1,0,1,1],[0,0,0,7],[1,2,1,3],[2,0,2,1],[2,2,2,3],[2,6,2,7],[1,6,1,7],[3,0,3,1],[3,2,3,3],[3,6,3,7],[4,0,4,1],[4,2,4,3],[4,6,4,7]]}
["Dandenong & Springvale Change Calculator"]
["Denomination",null,"Change Float",null,"Maximum float limit","Bundles/Rolls","Change Required"]
[100,null,null,null,null,null,"N/A"]
[50,null,null,null,null,null,"N/A"]
[20,null,null,null,200,1,{"$f":"IF(ISBLANK(C5),0,IF(C5=0,200,IF(C5>200,\"Change Not Required\",IF(AND(C5>=1,C5<=200),0,200))))","v":0}]
[10,null,null,null,100,1,{"$f":"IF(ISBLANK(C6),0,IF(C6=0,100,IF(C6>100,\"Change Not Required\",IF(AND(C6>=1,C6<=100),0,100))))","v":0}]
[5,null,null,null,100,2,{"$f":"IF(ISBLANK(C7), 0, IF(C7=0, 100, IF(C7>100, \"Change Not Required\", IF(AND(C7>=5, C7<=50), 50, 0))))","v":0}]
[2,null,null,null,50,1,{"$f":"IF(ISBLANK(C8), 0, IF(C8=0, 50, IF(C8>50, \"Change Not Required\", IF(AND(C8>0, C8<=50), 0, 0))))","v":0}]
[1,null,null,null,20,1,{"$f":"IF(ISBLANK(C9), 0, IF(C9=0, 20, IF(C9>20, \"Change Not Required\", IF(AND(C9>0, C9<=20), 0, 0))))","v":0}]
[0.5,null,null,null,10,1,{"$f":"IF(ISBLANK(C10), 0, IF(C10=0, 10, IF(C10>10, \"Change Not Required\", IF(AND(C10>0, C10<=10), 0, 0))))","v":0}]
[0.2,null,null,null,4,1,{"$f":"IF(ISBLANK(C11), 0, IF(C11=0, 4, IF(C11>4, \"Change Not Required\", IF(AND(C11>0, C11<=4), 0, 0))))","v":0}]
[0.1,null,null,null,4,1,{"$f":"IF(ISBLANK(C12), 0, IF(C12=0, 4, IF(C12>4, \"Change Not Required\", IF(AND(C12>0, C12<=4), 0, 0))))","v":0}]
[0.05,null,null,null,2,1,{"$f":"IF(ISBLANK(C13),0,IF(C13=0,2,IF(C13>2,\"Change Not Required\",IF(AND(C13>0,C13<=2),0,))))","v":0}]
[null,null,"$Total",{"$f":"SUM(C3:D13)","v":0},{"$f":"SUM(E5:E13)","v":490},null,"$Total",{"$f":"SUM(G3:H13)","v":0}]
[]
["Step 1","Clear by deleting the amount in the Current float column","Clear by deleting the amount in the Current Float (yellow column) if there are entries"]
["Step 2","Enter the money left in the float in the yellow column, If more than $578, contact Support","Enter the money left in the float in the yellow column, if you don't have the demoniation enter zero, If total is more than $490, contact Support"]
["Last Step","Complete and submit a Change Request Form for the money required in the green column","Complete and submit a Change Request Form for the money required in the green column"]