{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Target","Kroger ","Walmart","Comparison "],"not_rendered":{"charts":11,"images":0,"macros":0,"external_links":0,"defined_names":3,"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":"Target","index":0,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,0,1,4]]}
[]
["Target"]
[null,"Full Price ","Bulk Price ","Sale Price ","Average Price "]
["Twix ",6.99,{"$f":"SUM(B4)+2","v":8.99},{"$f":"-3.99+B4","v":3},{"$f":"AVERAGE(B4:D4)","v":6.3266666666666671}]
["Skittles ",{"$f":"SUM(B4)","v":6.99},{"$f":"SUM(C4)+2","v":10.99},{"$f":"-3.99+B5","v":3},{"$f":"AVERAGE(B5:D5)","v":6.9933333333333332}]
["Butterfingers",7.87,{"$f":"SUM(B6)+2","v":9.870000000000001},{"$f":"-3.99+B6","v":3.88},{"$f":"AVERAGE(B6:D6)","v":7.206666666666667}]
["Snickers ",8.75,{"$f":"SUM(B7)+2","v":10.75},{"$f":"-3.99+B7","v":4.76},{"$f":"AVERAGE(B7:D7)","v":8.086666666666666}]
["Milkyway ",6.89,{"$f":"SUM(B8)+2","v":8.89},{"$f":"-3.99+B8","v":2.8999999999999995},{"$f":"AVERAGE(B8:D8)","v":6.2266666666666666}]

{"sheet":"Kroger ","index":1,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,0,1,4]]}
[]
["Kroger"]
[null,"Full Price ","Bulk Price ","Sale Price ","Average Price "]
["Twix ",5.99,{"$f":"SUM(B4)+2","v":7.99},{"$f":"-3.99+B4","v":2},{"$f":"AVERAGE(B4:D4)","v":5.3266666666666671}]
["Skittles ",7.95,{"$f":"SUM(C4)+2","v":9.99},{"$f":"-3.99+B5","v":3.96},{"$f":"AVERAGE(B5:D5)","v":7.3000000000000007}]
["Butterfingers",9.8699999999999992,{"$f":"SUM(B6)+2","v":11.87},{"$f":"-3.99+B6","v":5.879999999999999},{"$f":"AVERAGE(B6:D6)","v":9.2066666666666652}]
["Snickers ",10.75,{"$f":"SUM(B7)+2","v":12.75},{"$f":"-3.99+B7","v":6.76},{"$f":"AVERAGE(B7:D7)","v":10.086666666666666}]
["Milkyway ",7.89,{"$f":"SUM(B8)+2","v":9.89},{"$f":"-3.99+B8","v":3.8999999999999995},{"$f":"AVERAGE(B8:D8)","v":7.2266666666666666}]

{"sheet":"Walmart","index":2,"n_rows":8,"n_cols":5,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,0,1,4]]}
[]
["Walmart"]
[null,"Full Price ","Bulk Price ","Sale Price ","Average Price "]
["Twix ",5.99,{"$f":"SUM(B4)+2","v":7.99},{"$f":"-3.99+B4","v":2},{"$f":"AVERAGE(B4:D4)","v":5.3266666666666671}]
["Skittles ",7.95,{"$f":"SUM(C4)+2","v":9.99},{"$f":"-3.99+B5","v":3.96},{"$f":"AVERAGE(B5:D5)","v":7.3000000000000007}]
["Butterfingers",9.8699999999999992,{"$f":"SUM(B6)+2","v":11.87},{"$f":"-3.99+B6","v":5.879999999999999},{"$f":"AVERAGE(B6:D6)","v":9.2066666666666652}]
["Snickers ",10.75,{"$f":"SUM(B7)+2","v":12.75},{"$f":"-3.99+B7","v":6.76},{"$f":"AVERAGE(B7:D7)","v":10.086666666666666}]
["Milkyway ",7.89,{"$f":"SUM(B8)+2","v":9.89},{"$f":"-3.99+B8","v":3.8999999999999995},{"$f":"AVERAGE(B8:D8)","v":7.2266666666666666}]

{"sheet":"Comparison ","index":3,"n_rows":9,"n_cols":5,"rows_kept":9,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["Comparing Candy Prices "]
[null,"Regular Price ","Regular Price","Regular Price ","Average of All "]
["Twix",5.99,5.99,6.99,{"$f":"AVERAGE(B3:D3)","v":6.3233333333333333}]
["Skittles",7.95,7.95,6.99,7.63]
["Butterfingers",9.8699999999999992,9.8699999999999992,7.87,9.2033333333333331]
["Snickers",10.75,10.75,8.75,10.083333333333334]
["Milkyway",7.89,7.89,6.89,7.5566666666666658]
["Average Prie ",{"$f":"AVERAGE(B3:B7)","v":8.49},{"$f":"AVERAGE(C3:C7)","v":8.49},{"$f":"AVERAGE(D3:D7)","v":7.4980000000000002},8.1593333333333344]
[null,"Walmart ","Kroger ","Target"]