{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Regular orders"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":2,"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":"Regular orders","index":0,"n_rows":19,"n_cols":28,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Grand Rapids Copy Shop Order Form",null,null,null,null,null,null,null,null,null,null,"Database"]
["Date and Time",{"$f":"NOW()","v":"2011-06-21T11:06:37.080"},null,null,null,null,null,null,null,null,null,"Date and Time","Invoice Number",null,"Customer Name","Address","How Many Pages?","How Many Copies?","Base Rate","Base Invoice",null,"What Color Paper?","Color Sur Charge ","What Size Paper?","Size Sur Charge","Total Sur Charge",null,"Total Invoice"]
["Invoice Number",1008,null,null,null,null,null,null,null,null,null,"2011-06-21T10:13:54.520",1003,null,"George","500 Tea Olive Lane",500,200,0.03,3000,null,"Red",3.0000000000000001E-3,"11 by 17 inch",1.2E-2,1500,null,4500]
[null,null,null,null,null,null,null,null,null,null,null,"2011-06-21T10:16:40.030",1004,null,"Tim","1200 oddly Lane",34,135,0.03,137.69999999999999,null,"Green",3.0000000000000001E-3,"8.5 by 11 inch",0,13.770000000000001,null,151.47]
["Customer Name","Ted",null,null,null,null,null,null,null,null,null,"2011-06-21T10:19:45.830",1005,null,"Sue","123 Forsyth Street",300,98,0.03,882,null,"Silver",7.0000000000000001E-3,"11 by 17 inch",1.2E-2,558.6,null,1440.6]
["Address",null,null,null,null,null,null,null,null,null,null,"2011-06-21T10:25:14.030",1006,null,"Nancy","400 Smith Street",89,150,0.03,400.5,null,"Green",3.0000000000000001E-3,"4 by 6 inch",-8.0000000000000002E-3,-66.75,null,333.75]
["How Many Pages?",5,null,{"$f":"B7*B8","v":300},"<1,000","<5000",">5000","Sur Charge",null,null,null,"2011-06-21T10:31:42.320",1007,null,"Ginger","12 Parrot Way",56,300,0.03,504,null,"Red",3.0000000000000001E-3,"8.5 by 11 inch",0,50.400000000000006,null,554.4]
["How Many Copies?",60,null,"Blue",3.0000000000000001E-3,2E-3,1.6000000000000001E-3,{"$f":"IF($D$7<1000,E8,IF($D$7>5000,G8,F8))","v":3.0000000000000001E-3}]
["Base Rate",0.03,null,"Green",3.0000000000000001E-3,2E-3,1.6000000000000001E-3,{"$f":"IF($D$7<1000,E9,IF($D$7>5000,G9,F9))","v":3.0000000000000001E-3}]
["Base Invoice",{"$f":"B9*B8*B7","v":9},null,"Red",3.0000000000000001E-3,2E-3,1.6000000000000001E-3,3.0000000000000001E-3]
[null,null,null,"Silver",7.0000000000000001E-3,6.0000000000000001E-3,5.0000000000000001E-3,7.0000000000000001E-3]
["What Color Paper?","Silver",null,"White",0,0,0,0]
["Color Sur Charge ",{"$f":"VLOOKUP(B12,D8:H12,5,FALSE)","v":7.0000000000000001E-3}]
["What Size Paper?","8.5 by 11 inch",null,{"$f":"IF(B12=\"Silver\",\"N/A\",\"11 by 17 inch\")","v":"N/A"},1.2E-2]
["Size Sur Charge",{"$f":"VLOOKUP(B14,D14:E16,2,)","v":0},null,"4 by 6 inch",-8.0000000000000002E-3]
["Total Sur Charge",{"$f":"(B15+B13)*B7*B8","v":2.1},null,"8.5 by 11 inch",0]
[]
["Total Invoice",{"$f":"B10+B16","v":11.1}]
["Regular orders"]