{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["Pricing Calculator","Chart"],"not_rendered":{"charts":2,"defined_names":16},"unopened":[{"sheet":"Chart","index":1,"reason":"not_a_worksheet"}],"read":"whole","date_system":"1900"}

{"sheet":"Pricing Calculator","index":0,"n_rows":30,"n_cols":5,"rows_kept":30,"merged":[[1,1,1,4],[3,1,3,3],[4,1,4,3],[5,1,5,3],[6,1,6,3],[7,2,7,4],[8,2,8,4],[29,1,29,2]]}
[]
[null,"Product Pricing Calculator"]
[]
[null,"Model Key"]
[null,"Numbers in white cells are entered by user."]
[null,"Numbers in gray cells are calculated for you. These generally should not be altered."]
[]
[null,"Product number","A-123435"]
[null,"Product description","Super Widget: White widget with green racing stripes has two reversible spigots. Refillable with item #R-234. 1-year warranty."]
[{"$nulls":3},"Base price","Discounted price"]
[null,"Base unit cost",null,{"v":15.42,"d":"$15.42"}]
[null,"Initial markup",null,{"v":0.23,"d":"23%"}]
[null,"Base unit price",null,{"$f":"ROUND(D11*(1+D12),2)","v":{"v":18.97,"d":"$18.97"}}]
[]
[null,"Quantity in this order",null,144,{"$f":"D15","v":144}]
[]
[null,"Per unit discount",null,null,{"v":0.1,"d":"10%"}]
[]
[null,"Total savings per base unit",null,null,{"$f":"D13*E17","v":{"v":1.897,"d":"$1.90"}}]
[]
[null,"Total line item price",null,null,{"$f":"D13-E19","v":{"v":17.073,"d":"$17.07"}}]
[]
[null,"Lump sum total",null,{"$f":"D13*D15","v":{"v":2731.68,"d":"$2,731.68"}},{"$f":"E21*D15","v":{"v":2458.512,"d":"$2,458.51"}}]
[]
[null,"Sales tax",null,{"v":0.075,"d":"7.50%"},{"$f":"D25","v":{"v":0.075,"d":"7.50%"}}]
[]
[null,"Shipping and handling",null,{"v":12.31,"d":"$12.31"},{"$f":"D27","v":{"v":12.31,"d":"$12.31"}}]
[]
[null,null,"Total",{"$f":"(D23*(1+D25))+D27","v":{"v":2948.8659999999995,"d":"$2,948.87"}},{"$f":"(E23*(1+E25))+E27","v":{"v":2655.2104,"d":"$2,655.21"}}]
[null,"Total savings",null,null,{"$f":"D29-E29","v":{"v":293.6555999999996,"d":"$293.66"}}]