{"text_format":"3","workbook":"xlsx","n_sheets":5,"sheets":["Regular","Crisp","Peanut","Pretzel","Comparision"],"not_rendered":{"charts":30,"images":4,"defined_names":96},"read":"whole","date_system":"1900"}

{"sheet":"Regular","index":0,"n_rows":29,"n_cols":9,"rows_kept":29,"merged":[[1,2,2,7],[6,2,6,7],[8,0,21,0]]}
[]
[null,null,"Color Data for Regular M&M's"]
[]
[]
[]
[]
[null,null,"Colors"]
[null,null,"Red","Orange","Yellow","Green","Blue","Brown","Total M&M's in the Package"]
["Package","Package 1",{"$nulls":6},{"$f":"C9+D9+E9+F9+G9+H9","v":0}]
[null,"Package 2",{"$nulls":6},{"$f":"C10+D10+E10+F10+G10+H10","v":0}]
[null,"Package 3",{"$nulls":6},{"$f":"C11+D11+E11+F11+G11+H11","v":0}]
[null,"Package 4",{"$nulls":6},0]
[null,"Package 5",{"$nulls":6},0]
[null,"Package 6",{"$nulls":6},0]
[null,"Package 7",{"$nulls":6},0]
[null,"Package 8",{"$nulls":6},0]
[null,"Package 9",{"$nulls":6},0]
[null,"Package 10",{"$nulls":6},0]
[null,"Package 11",{"$nulls":6},0]
[null,"Package 12",{"$nulls":6},0]
[null,"Total M&M's by Color",{"$f":"(C9+C10+C11+C12+C13+C14+C16+C15+C17+C18+C19+C20)","v":0},0,0,0,0,{"$f":"(H9+H10+H11+H12+H13+H14+H16+H15+H17+H18+H19+H20)","v":0},{"$f":"SUM(I9:I20)","v":0}]
[]
[null,null,"Red","Orange","Yellow","Green","Blue","Brown"]
[null,"Maximum",{"$f":"MAX(C9:C20)","v":0},0,0,0,0,0]
[null,"Minimum",{"$f":"MIN(C9:C20)","v":0},0,0,0,0,0]
[null,"Mean",{"$f":"((C9+C10+C11+C12+C13+C15+C14+C16+C17+C18+C19+C20)/13)","v":{"v":0,"d":"0.00"}},{"$f":"((D9+D10+D11+D12+D13+D15+D14+D16+D17+D18+D19+D20)/13)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"Median",{"$f":"MEDIAN(C9:C20)","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,"Mode",{"$f":"MODE(C9:C20)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"Range",{"$f":"C24-C25","v":0},{"$f":"D24-D25","v":0},0,0,0,0]

{"sheet":"Crisp","index":1,"n_rows":29,"n_cols":9,"rows_kept":29,"merged":[[1,2,2,7],[6,2,6,7],[8,0,21,0]]}
[]
[null,null,"Color Data for Crisp M&M's"]
[]
[]
[]
[]
[null,null,"Colors"]
[null,null,"Red","Orange","Yellow","Green","Blue","Brown","Total M&M's in the Package"]
["Package","Package 1",{"$nulls":6},{"$f":"C9+D9+E9+F9+G9+H9","v":0}]
[null,"Package 2",{"$nulls":6},{"$f":"C10+D10+E10+F10+G10+H10","v":0}]
[null,"Package 3",{"$nulls":6},{"$f":"C11+D11+E11+F11+G11+H11","v":0}]
[null,"Package 4",{"$nulls":6},0]
[null,"Package 5",{"$nulls":6},0]
[null,"Package 6",{"$nulls":6},0]
[null,"Package 7",{"$nulls":6},0]
[null,"Package 8",{"$nulls":6},0]
[null,"Package 9",{"$nulls":6},0]
[null,"Package 10",{"$nulls":6},0]
[null,"Package 11",{"$nulls":6},0]
[null,"Package 12",{"$nulls":6},0]
[null,"Total M&M's by Color",{"$f":"(C9+C10+C11+C12+C13+C14+C16+C15+C17+C18+C19+C20)","v":0},0,0,0,0,{"$f":"(H9+H10+H11+H12+H13+H14+H16+H15+H17+H18+H19+H20)","v":0},{"$f":"SUM(I9:I20)","v":0}]
[]
[null,null,"Red","Orange","Yellow","Green","Blue","Brown"]
[null,"Maximum",{"$f":"MAX(C9:C20)","v":0},0,0,0,0,0]
[null,"Minimum",{"$f":"MIN(C9:C20)","v":0},0,0,0,0,0]
[null,"Mean",{"$f":"((C9+C10+C11+C12+C13+C15+C14+C16+C17+C18+C19+C20)/13)","v":{"v":0,"d":"0.00"}},{"$f":"((D9+D10+D11+D12+D13+D15+D14+D16+D17+D18+D19+D20)/13)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"Median",{"$f":"MEDIAN(C9:C20)","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,"Mode",{"$f":"MODE(C9:C20)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"Range",{"$f":"C24-C25","v":0},{"$f":"D24-D25","v":0},0,0,0,0]

{"sheet":"Peanut","index":2,"n_rows":29,"n_cols":9,"rows_kept":29,"merged":[[1,2,2,7],[6,2,6,7],[8,0,21,0]]}
[]
[null,null,"Color Data for Peanut M&M's"]
[]
[]
[]
[]
[null,null,"Colors"]
[null,null,"Red","Orange","Yellow","Green","Blue","Brown","Total M&M's in the Package"]
["Package","Package 1",{"$nulls":6},{"$f":"C9+D9+E9+F9+G9+H9","v":0}]
[null,"Package 2",{"$nulls":6},{"$f":"C10+D10+E10+F10+G10+H10","v":0}]
[null,"Package 3",{"$nulls":6},{"$f":"C11+D11+E11+F11+G11+H11","v":0}]
[null,"Package 4",{"$nulls":6},0]
[null,"Package 5",{"$nulls":6},0]
[null,"Package 6",{"$nulls":6},0]
[null,"Package 7",{"$nulls":6},0]
[null,"Package 8",{"$nulls":6},0]
[null,"Package 9",{"$nulls":6},0]
[null,"Package 10",{"$nulls":6},0]
[null,"Package 11",{"$nulls":6},0]
[null,"Package 12",{"$nulls":6},0]
[null,"Total M&M's by Color",{"$f":"(C9+C10+C11+C12+C13+C14+C16+C15+C17+C18+C19+C20)","v":0},0,0,0,0,{"$f":"(H9+H10+H11+H12+H13+H14+H16+H15+H17+H18+H19+H20)","v":0},{"$f":"SUM(I9:I20)","v":0}]
[]
[null,null,"Red","Orange","Yellow","Green","Blue","Brown"]
[null,"Maximum",{"$f":"MAX(C9:C20)","v":0},0,0,0,0,0]
[null,"Minimum",{"$f":"MIN(C9:C20)","v":0},0,0,0,0,0]
[null,"Mean",{"$f":"((C9+C10+C11+C12+C13+C15+C14+C16+C17+C18+C19+C20)/13)","v":{"v":0,"d":"0.00"}},{"$f":"((D9+D10+D11+D12+D13+D15+D14+D16+D17+D18+D19+D20)/13)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"Median",{"$f":"MEDIAN(C9:C20)","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,"Mode",{"$f":"MODE(C9:C20)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"Range",{"$f":"C24-C25","v":0},{"$f":"D24-D25","v":0},0,0,0,0]

{"sheet":"Pretzel","index":3,"n_rows":29,"n_cols":9,"rows_kept":29,"merged":[[1,2,2,7],[6,2,6,7],[8,0,21,0]]}
[]
[null,null,"Color Data for Pretzel M&M's"]
[]
[]
[]
[]
[null,null,"Colors"]
[null,null,"Red","Orange","Yellow","Green","Blue","Brown","Total M&M's in the Package"]
["Package","Package 1",{"$nulls":6},{"$f":"C9+D9+E9+F9+G9+H9","v":0}]
[null,"Package 2",{"$nulls":6},{"$f":"C10+D10+E10+F10+G10+H10","v":0}]
[null,"Package 3",{"$nulls":6},{"$f":"C11+D11+E11+F11+G11+H11","v":0}]
[null,"Package 4",{"$nulls":6},0]
[null,"Package 5",{"$nulls":6},0]
[null,"Package 6",{"$nulls":6},0]
[null,"Package 7",{"$nulls":6},0]
[null,"Package 8",{"$nulls":6},0]
[null,"Package 9",{"$nulls":6},0]
[null,"Package 10",{"$nulls":6},0]
[null,"Package 11",{"$nulls":6},0]
[null,"Package 12",{"$nulls":6},0]
[null,"Total M&M's by Color",{"$f":"(C9+C10+C11+C12+C13+C14+C16+C15+C17+C18+C19+C20)","v":0},0,0,0,0,{"$f":"(H9+H10+H11+H12+H13+H14+H16+H15+H17+H18+H19+H20)","v":0},{"$f":"SUM(I9:I20)","v":0}]
[]
[null,null,"Red","Orange","Yellow","Green","Blue","Brown"]
[null,"Maximum",{"$f":"MAX(C9:C20)","v":0},0,0,0,0,0]
[null,"Minimum",{"$f":"MIN(C9:C20)","v":0},0,0,0,0,0]
[null,"Mean",{"$f":"((C9+C10+C11+C12+C13+C15+C14+C16+C17+C18+C19+C20)/13)","v":{"v":0,"d":"0.00"}},{"$f":"((D9+D10+D11+D12+D13+D15+D14+D16+D17+D18+D19+D20)/13)","v":{"v":0,"d":"0.00"}},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
[null,"Median",{"$f":"MEDIAN(C9:C20)","v":{"$error":"#NUM!"}},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"},{"$error":"#NUM!"}]
[null,"Mode",{"$f":"MODE(C9:C20)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,"Range",{"$f":"C24-C25","v":0},{"$f":"D24-D25","v":0},0,0,0,0]

{"sheet":"Comparision","index":4,"n_rows":10,"n_cols":9,"rows_kept":10,"merged":[[1,2,2,7],[3,2,3,7],[5,0,10,0]]}
[]
[null,null,"Comparision of Averages Across Flavors"]
[]
[null,null,"Colors"]
[null,null,"Red","Orange","Yellow","Green","Blue","Brown","Total"]
["Package","Regular",{"$f":"Regular!C26","v":{"v":0,"d":"0.0"}},{"$f":"Regular!D26","v":{"v":0,"d":"0.0"}},{"$f":"Regular!E26","v":{"v":0,"d":"0.0"}},{"$f":"Regular!F26","v":{"v":0,"d":"0.0"}},{"$f":"Regular!G26","v":{"v":0,"d":"0.0"}},{"$f":"Regular!H26","v":{"v":0,"d":"0.0"}},{"$f":"SUM(C6:H6)","v":{"v":0,"d":"0.0"}}]
[null,"Crisp",{"$f":"Crisp!C26","v":{"v":0,"d":"0.0"}},{"$f":"Crisp!D26","v":{"v":0,"d":"0.0"}},{"$f":"Crisp!E26","v":{"v":0,"d":"0.0"}},{"$f":"Crisp!F26","v":{"v":0,"d":"0.0"}},{"$f":"Crisp!G26","v":{"v":0,"d":"0.0"}},{"$f":"Crisp!H26","v":{"v":0,"d":"0.0"}},{"$f":"SUM(C7:H7)","v":{"v":0,"d":"0.0"}}]
[null,"Peanut",{"$f":"Peanut!C26","v":{"v":0,"d":"0.0"}},{"$f":"Peanut!D26","v":{"v":0,"d":"0.0"}},{"$f":"Peanut!E26","v":{"v":0,"d":"0.0"}},{"$f":"Peanut!F26","v":{"v":0,"d":"0.0"}},{"$f":"Peanut!G26","v":{"v":0,"d":"0.0"}},{"$f":"Peanut!H26","v":{"v":0,"d":"0.0"}},{"$f":"SUM(C8:H8)","v":{"v":0,"d":"0.0"}}]
[null,"Pretzel",{"$f":"Pretzel!C26","v":{"v":0,"d":"0.0"}},{"$f":"Pretzel!D26","v":{"v":0,"d":"0.0"}},{"$f":"Pretzel!E26","v":{"v":0,"d":"0.0"}},{"$f":"Pretzel!F26","v":{"v":0,"d":"0.0"}},{"$f":"Pretzel!G26","v":{"v":0,"d":"0.0"}},{"$f":"Pretzel!H26","v":{"v":0,"d":"0.0"}},{"$f":"SUM(C9:H9)","v":{"v":0,"d":"0.0"}}]
[null,"Mean",{"$f":"AVERAGE(C6:C9)","v":{"v":0,"d":"0.0"}},{"$f":"AVERAGE(D6:D9)","v":{"v":0,"d":"0.0"}},{"$f":"((E6+E9+E7+E8)/4)","v":{"v":0,"d":"0.0"}},{"$f":"(SUM(F6:F9)/4)","v":{"v":0,"d":"0.0"}},{"$f":"(SUM(G6:G9)/4)","v":{"v":0,"d":"0.0"}},{"$f":"AVERAGE(H6:H9)","v":{"v":0,"d":"0.0"}},{"$f":"SUM(C10:H10)","v":{"v":0,"d":"0.0"}}]