{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["All Sales Final"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":4},"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":"All Sales Final","index":0,"n_rows":27,"n_cols":22,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[]
["Beginning Date","2021-07-03",null,"Totals",null,null,{"$f":"SUM(G4:G200)","v":17115},{"$f":"SUM(H4:H200)","v":171150},{"$f":"SUM(I4:I200)","v":74107.950000000012},{"$f":"SUM(J4:J200)","v":97042.049999999988},null,"Date","Total Profit",null,"Salesperson","Total Profit",null,"Row Labels","Total Profit",null,"Row Labels","Total Profit"]
["Ending Date","2021-07-09",null,"Date","Salesman","State","Amount Sold","Dollars Earned","Cost","Profit",null,"2021-07-06",21829.5,null,"Andy",6520.5,null,"MD",4819.5,null,"2021-07-06",21829.5]
[null,null,null,"2021-07-01","Jim","PA",1000,10000,{"$f":"G4*4.33","v":4330},{"$f":"H4-I4","v":5670},null,"2021-07-07",16159.5,null,"Dwight",36798.300000000003,null,"NJ",11113.2,null,"Andy",5103]
[null,null,null,"2021-07-01","Andy","PA",250,2500,{"$f":"G5*4.33","v":1082.5},{"$f":"H5-I5","v":1417.5},null,"2021-07-08",5471.55,null,"Jim",19618.2,null,"NY",24381,null,"Jim",5953.5]
[null,null,null,"2021-07-01","Dwight","NY",1200,12000,5196,6804,null,"2021-07-09",4592.7,null,"Phyllis",13466.25,null,"PA",56728.35,null,"Phyllis",1701]
[null,null,null,"2021-07-01","Jim","NY",200,2000,866,1134,null,"Grand Total",48053.25,null,"Stanley",20638.800000000003,null,"Grand Total",97042.049999999988,null,"Stanley",9072]
[null,null,null,"2021-07-02","Phyllis","PA",1700,17000,7361,9639,null,null,null,null,"Grand Total",97042.05,null,null,null,null,"2021-07-07",16159.5]
[null,null,null,"2021-07-02","Stanley","MD",500,5000,2165,2835,null,null,null,null,null,null,null,null,null,null,"Dwight",8221.5]
[null,null,null,"2021-07-02","Dwight","NY",1230,12300,5325.9,6974.1,null,null,null,null,null,null,null,null,null,null,"Jim",2551.5]
[null,null,null,"2021-07-02","Dwight","PA",2560,25600,11084.8,14515.2,null,null,null,null,null,null,null,null,null,null,"Phyllis",1417.5]
[null,null,null,"2021-07-06","Andy","PA",900,9000,3897,5103,null,null,null,null,null,null,null,null,null,null,"Stanley",3969]
[null,null,null,"2021-07-06","Jim","PA",750,7500,3247.5,4252.5,null,null,null,null,null,null,null,null,null,null,"2021-07-08",5471.55]
[null,null,null,"2021-07-06","Jim","NY",300,3000,1299,1701,null,null,null,null,null,null,null,null,null,null,"Phyllis",708.75]
[null,null,null,"2021-07-06","Stanley","NJ",1200,12000,5196,6804,null,null,null,null,null,null,null,null,null,null,"Stanley",4762.8]
[null,null,null,"2021-07-06","Stanley","PA",400,4000,1732,2268,null,null,null,null,null,null,null,null,null,null,"2021-07-09",4592.7]
[null,null,null,"2021-07-06","Phyllis","MD",300,3000,1299,1701,null,null,null,null,null,null,null,null,null,null,"Dwight",283.5]
[null,null,null,"2021-07-07","Jim","NY",450,4500,1948.5,2551.5,null,null,null,null,null,null,null,null,null,null,"Jim",4309.2]
[null,null,null,"2021-07-07","Dwight","PA",800,8000,3464,4536,null,null,null,null,null,null,null,null,null,null,"Grand Total",48053.25]
[null,null,null,"2021-07-07","Dwight","PA",650,6500,2814.5,3685.5]
[null,null,null,"2021-07-07","Stanley","PA",700,7000,3031,3969]
[null,null,null,"2021-07-07","Phyllis","NY",250,2500,1082.5,1417.5]
[null,null,null,"2021-07-08","Phyllis","PA",125,1250,541.25,708.75]
[null,null,null,"2021-07-08","Stanley","PA",170,1700,736.1,963.9]
[null,null,null,"2021-07-08","Stanley","NY",670,6700,2901.1,3798.9]
[null,null,null,"2021-07-09","Jim","NJ",760,7600,3290.8,4309.2]
[null,null,null,"2021-07-09","Dwight","MD",50,500,216.5,283.5]