{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["summary","Sheet1","dataTable","dataExternalFacebook","information"],"not_rendered":{"charts":5,"images":1,"macros":1,"external_links":0,"defined_names":5,"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":"summary","index":0,"n_rows":3,"n_cols":11,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,"Operational Dashboard"]
[]
[null,null,null,null,null,null,null,null,null,"Date:",{"$f":"reportDate","v":"2019-03-26"}]

{"sheet":"Sheet1","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"dataTable","index":2,"n_rows":91,"n_cols":34,"rows_kept":91,"cut":false,"hidden":false,"merged":[]}
["Date","Visits","=IF(dataExtract!B2=0,NA(),dataExtract!B2)",null,"Week","Date","Orders","4 Weeks Prior Orders",null,null,null,"Date","Orders",null,null,"Day","Organic Reach","Paid Reach","Total Reach",null,"Day","Visits",null,"Visits Expected","Visits Upper Bound",null,null,null,"Orders",{"$f":"+Sheet1!V2","v":0},{"$f":"+Sheet1!W2","v":0},{"$f":"+Sheet1!X2","v":0},{"$f":"+Sheet1!Y2","v":0},{"$f":"+Sheet1!Z2","v":0}]
[{"$f":"Sheet1!A2","v":"00:00:00"},{"$f":"Sheet1!B2","v":0},"=IF(dataExtract!B2=0,NA(),IF(A2>=todayDate,NA(),dataExtract!B2))",null,1,{"$f":"F3-7","v":"2019-02-24"},{"$f":"VLOOKUP(F2,Sheet1!E:F,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(reportWeekStart-(8-E2)*7,Sheet1!$E:$F,2,FALSE)","v":{"$error":"#N/A"}},null,null,null,{"$f":"+Sheet1!H2","v":"00:00:00"},{"$f":"+Sheet1!J2","v":0},null,null,{"$f":"Sheet1!A2","v":"00:00:00"},{"$f":"VLOOKUP(P2,dataExternalFacebook!A:M,13,FALSE)","v":{"$error":"#N/A"}},{"$f":"S2-Q2","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(P2,dataExternalFacebook!A:M,10,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"+Sheet1!N2","v":"00:00:00"},{"$f":"+Sheet1!O2","v":0},{"$f":"+Sheet1!P2","v":0},{"$f":"+Sheet1!Q2","v":0},{"$f":"+Sheet1!R2","v":0},null,null,null,{"$f":"Sheet1!U3","v":"00:00:00"},{"$f":"+Sheet1!V3","v":0},{"$f":"+Sheet1!W3","v":0},{"$f":"+Sheet1!X3","v":0},{"$f":"+Sheet1!Y3","v":0},{"$f":"+Sheet1!Z3","v":0}]
[{"$f":"Sheet1!A3","v":"00:00:00"},{"$f":"Sheet1!B3","v":0},null,null,2,{"$f":"F4-7","v":"2019-03-03"},{"$f":"VLOOKUP(F3,Sheet1!E:F,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(reportWeekStart-(8-E3)*7,Sheet1!$E:$F,2,FALSE)","v":{"$error":"#N/A"}},null,null,null,{"$f":"+Sheet1!H3","v":"00:00:00"},{"$f":"+Sheet1!J3","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Sheet1!U4","v":"00:00:00"},{"$f":"+Sheet1!V4","v":0},{"$f":"+Sheet1!W4","v":0},{"$f":"+Sheet1!X4","v":0},{"$f":"+Sheet1!Y4","v":0},{"$f":"+Sheet1!Z4","v":0}]
[{"$f":"Sheet1!A4","v":"00:00:00"},{"$f":"Sheet1!B4","v":0},null,null,3,{"$f":"F5-7","v":"2019-03-10"},{"$f":"VLOOKUP(F4,Sheet1!E:F,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(reportWeekStart-(8-E4)*7,Sheet1!$E:$F,2,FALSE)","v":{"$error":"#N/A"}},null,null,null,{"$f":"+Sheet1!H4","v":"00:00:00"},{"$f":"+Sheet1!J4","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Sheet1!U5","v":"00:00:00"},{"$f":"+Sheet1!V5","v":0},{"$f":"+Sheet1!W5","v":0},{"$f":"+Sheet1!X5","v":0},{"$f":"+Sheet1!Y5","v":0},{"$f":"+Sheet1!Z5","v":0}]
[{"$f":"Sheet1!A5","v":"00:00:00"},{"$f":"Sheet1!B5","v":0},null,null,4,{"$f":"reportWeekStart","v":"2019-03-17"},{"$f":"VLOOKUP(F5,Sheet1!E:F,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(reportWeekStart-(8-E5)*7,Sheet1!$E:$F,2,FALSE)","v":{"$error":"#N/A"}},null,null,null,{"$f":"+Sheet1!H5","v":"00:00:00"},{"$f":"+Sheet1!J5","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Sheet1!U6","v":"00:00:00"},{"$f":"+Sheet1!V6","v":0},{"$f":"+Sheet1!W6","v":0},{"$f":"+Sheet1!X6","v":0},{"$f":"+Sheet1!Y6","v":0},{"$f":"+Sheet1!Z6","v":0}]
[{"$f":"Sheet1!A6","v":"00:00:00"},{"$f":"Sheet1!B6","v":0},null,null,null,null,null,null,null,null,null,{"$f":"+Sheet1!H6","v":"00:00:00"},{"$f":"+Sheet1!J6","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Sheet1!U7","v":"00:00:00"},{"$f":"+Sheet1!V7","v":0},{"$f":"+Sheet1!W7","v":0},{"$f":"+Sheet1!X7","v":0},{"$f":"+Sheet1!Y7","v":0},{"$f":"+Sheet1!Z7","v":0}]
[{"$f":"Sheet1!A7","v":"00:00:00"},{"$f":"Sheet1!B7","v":0},null,null,null,null,null,null,null,null,null,{"$f":"+Sheet1!H7","v":"00:00:00"},{"$f":"+Sheet1!J7","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Sheet1!U8","v":"00:00:00"},{"$f":"+Sheet1!V8","v":0},{"$f":"+Sheet1!W8","v":0},{"$f":"+Sheet1!X8","v":0},{"$f":"+Sheet1!Y8","v":0},{"$f":"+Sheet1!Z8","v":0}]
[{"$f":"Sheet1!A8","v":"00:00:00"},{"$f":"Sheet1!B8","v":0},null,null,null,null,null,null,null,null,null,{"$f":"+Sheet1!H8","v":"00:00:00"},{"$f":"+Sheet1!J8","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Sheet1!U9","v":"00:00:00"},{"$f":"+Sheet1!V9","v":0},{"$f":"+Sheet1!W9","v":0},{"$f":"+Sheet1!X9","v":0},{"$f":"+Sheet1!Y9","v":0},{"$f":"+Sheet1!Z9","v":0}]
[{"$f":"Sheet1!A9","v":"00:00:00"},{"$f":"Sheet1!B9","v":0},null,null,null,null,null,null,null,null,null,{"$f":"+Sheet1!H9","v":"00:00:00"},{"$f":"+Sheet1!J9","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Sheet1!U10","v":"00:00:00"},{"$f":"+Sheet1!V10","v":0},{"$f":"+Sheet1!W10","v":0},{"$f":"+Sheet1!X10","v":0},{"$f":"+Sheet1!Y10","v":0},{"$f":"+Sheet1!Z10","v":0}]
[{"$f":"Sheet1!A10","v":"00:00:00"},{"$f":"Sheet1!B10","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Sheet1!U11","v":"00:00:00"},{"$f":"+Sheet1!V11","v":0},{"$f":"+Sheet1!W11","v":0},{"$f":"+Sheet1!X11","v":0},{"$f":"+Sheet1!Y11","v":0},{"$f":"+Sheet1!Z11","v":0}]
[{"$f":"Sheet1!A11","v":"00:00:00"},{"$f":"Sheet1!B11","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Sheet1!U12","v":"00:00:00"},{"$f":"+Sheet1!V12","v":0},{"$f":"+Sheet1!W12","v":0},{"$f":"+Sheet1!X12","v":0},{"$f":"+Sheet1!Y12","v":0},{"$f":"+Sheet1!Z12","v":0}]
[{"$f":"Sheet1!A12","v":"00:00:00"},{"$f":"Sheet1!B12","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Sheet1!U13","v":"00:00:00"},{"$f":"+Sheet1!V13","v":0},{"$f":"+Sheet1!W13","v":0},{"$f":"+Sheet1!X13","v":0},{"$f":"+Sheet1!Y13","v":0},{"$f":"+Sheet1!Z13","v":0}]
[{"$f":"Sheet1!A13","v":"00:00:00"},{"$f":"Sheet1!B13","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Sheet1!U14","v":"00:00:00"},{"$f":"+Sheet1!V14","v":0},{"$f":"+Sheet1!W14","v":0},{"$f":"+Sheet1!X14","v":0},{"$f":"+Sheet1!Y14","v":0},{"$f":"+Sheet1!Z14","v":0}]
[{"$f":"Sheet1!A14","v":"00:00:00"},{"$f":"Sheet1!B14","v":0}]
[{"$f":"Sheet1!A15","v":"00:00:00"},{"$f":"Sheet1!B15","v":0}]
[{"$f":"Sheet1!A16","v":"00:00:00"},{"$f":"Sheet1!B16","v":0}]
[{"$f":"Sheet1!A17","v":"00:00:00"},{"$f":"Sheet1!B17","v":0}]
[{"$f":"Sheet1!A18","v":"00:00:00"},{"$f":"Sheet1!B18","v":0}]
[{"$f":"Sheet1!A19","v":"00:00:00"},{"$f":"Sheet1!B19","v":0}]
[{"$f":"Sheet1!A20","v":"00:00:00"},{"$f":"Sheet1!B20","v":0}]
[{"$f":"Sheet1!A21","v":"00:00:00"},{"$f":"Sheet1!B21","v":0}]
[{"$f":"Sheet1!A22","v":"00:00:00"},{"$f":"Sheet1!B22","v":0}]
[{"$f":"Sheet1!A23","v":"00:00:00"},{"$f":"Sheet1!B23","v":0}]
[{"$f":"Sheet1!A24","v":"00:00:00"},{"$f":"Sheet1!B24","v":0}]
[{"$f":"Sheet1!A25","v":"00:00:00"},{"$f":"Sheet1!B25","v":0}]
[{"$f":"Sheet1!A26","v":"00:00:00"},{"$f":"Sheet1!B26","v":0}]
[{"$f":"Sheet1!A27","v":"00:00:00"},{"$f":"Sheet1!B27","v":0}]
[{"$f":"Sheet1!A28","v":"00:00:00"},{"$f":"Sheet1!B28","v":0}]
[{"$f":"Sheet1!A29","v":"00:00:00"},{"$f":"Sheet1!B29","v":0}]
[{"$f":"Sheet1!A30","v":"00:00:00"},{"$f":"Sheet1!B30","v":0}]
[{"$f":"Sheet1!A31","v":"00:00:00"},{"$f":"Sheet1!B31","v":0}]
[{"$f":"Sheet1!A32","v":"00:00:00"},{"$f":"Sheet1!B32","v":0}]
[{"$f":"Sheet1!A33","v":"00:00:00"},{"$f":"Sheet1!B33","v":0}]
[{"$f":"Sheet1!A34","v":"00:00:00"},{"$f":"Sheet1!B34","v":0}]
[{"$f":"Sheet1!A35","v":"00:00:00"},{"$f":"Sheet1!B35","v":0}]
[{"$f":"Sheet1!A36","v":"00:00:00"},{"$f":"Sheet1!B36","v":0}]
[{"$f":"Sheet1!A37","v":"00:00:00"},{"$f":"Sheet1!B37","v":0}]
[{"$f":"Sheet1!A38","v":"00:00:00"},{"$f":"Sheet1!B38","v":0}]
[{"$f":"Sheet1!A39","v":"00:00:00"},{"$f":"Sheet1!B39","v":0}]
[{"$f":"Sheet1!A40","v":"00:00:00"},{"$f":"Sheet1!B40","v":0}]
[{"$f":"Sheet1!A41","v":"00:00:00"},{"$f":"Sheet1!B41","v":0}]
[{"$f":"Sheet1!A42","v":"00:00:00"},{"$f":"Sheet1!B42","v":0}]
[{"$f":"Sheet1!A43","v":"00:00:00"},{"$f":"Sheet1!B43","v":0}]
[{"$f":"Sheet1!A44","v":"00:00:00"},{"$f":"Sheet1!B44","v":0}]
[{"$f":"Sheet1!A45","v":"00:00:00"},{"$f":"Sheet1!B45","v":0}]
[{"$f":"Sheet1!A46","v":"00:00:00"},{"$f":"Sheet1!B46","v":0}]
[{"$f":"Sheet1!A47","v":"00:00:00"},{"$f":"Sheet1!B47","v":0}]
[{"$f":"Sheet1!A48","v":"00:00:00"},{"$f":"Sheet1!B48","v":0}]
[{"$f":"Sheet1!A49","v":"00:00:00"},{"$f":"Sheet1!B49","v":0}]
[{"$f":"Sheet1!A50","v":"00:00:00"},{"$f":"Sheet1!B50","v":0}]
[{"$f":"Sheet1!A51","v":"00:00:00"},{"$f":"Sheet1!B51","v":0}]
[{"$f":"Sheet1!A52","v":"00:00:00"},{"$f":"Sheet1!B52","v":0}]
[{"$f":"Sheet1!A53","v":"00:00:00"},{"$f":"Sheet1!B53","v":0}]
[{"$f":"Sheet1!A54","v":"00:00:00"},{"$f":"Sheet1!B54","v":0}]
[{"$f":"Sheet1!A55","v":"00:00:00"},{"$f":"Sheet1!B55","v":0}]
[{"$f":"Sheet1!A56","v":"00:00:00"},{"$f":"Sheet1!B56","v":0}]
[{"$f":"Sheet1!A57","v":"00:00:00"},{"$f":"Sheet1!B57","v":0}]
[{"$f":"Sheet1!A58","v":"00:00:00"},{"$f":"Sheet1!B58","v":0}]
[{"$f":"Sheet1!A59","v":"00:00:00"},{"$f":"Sheet1!B59","v":0}]
[{"$f":"Sheet1!A60","v":"00:00:00"},{"$f":"Sheet1!B60","v":0}]
[{"$f":"Sheet1!A61","v":"00:00:00"},{"$f":"Sheet1!B61","v":0}]
[{"$f":"Sheet1!A62","v":"00:00:00"},{"$f":"Sheet1!B62","v":0}]
[{"$f":"Sheet1!A63","v":"00:00:00"},{"$f":"Sheet1!B63","v":0}]
[{"$f":"Sheet1!A64","v":"00:00:00"},{"$f":"Sheet1!B64","v":0}]
[{"$f":"Sheet1!A65","v":"00:00:00"},{"$f":"Sheet1!B65","v":0}]
[{"$f":"Sheet1!A66","v":"00:00:00"},{"$f":"Sheet1!B66","v":0}]
[{"$f":"Sheet1!A67","v":"00:00:00"},{"$f":"Sheet1!B67","v":0}]
[{"$f":"Sheet1!A68","v":"00:00:00"},{"$f":"Sheet1!B68","v":0}]
[{"$f":"Sheet1!A69","v":"00:00:00"},{"$f":"Sheet1!B69","v":0}]
[{"$f":"Sheet1!A70","v":"00:00:00"},{"$f":"Sheet1!B70","v":0}]
[{"$f":"Sheet1!A71","v":"00:00:00"},{"$f":"Sheet1!B71","v":0}]
[{"$f":"Sheet1!A72","v":"00:00:00"},{"$f":"Sheet1!B72","v":0}]
[{"$f":"Sheet1!A73","v":"00:00:00"},{"$f":"Sheet1!B73","v":0}]
[{"$f":"Sheet1!A74","v":"00:00:00"},{"$f":"Sheet1!B74","v":0}]
[{"$f":"Sheet1!A75","v":"00:00:00"},{"$f":"Sheet1!B75","v":0}]
[{"$f":"Sheet1!A76","v":"00:00:00"},{"$f":"Sheet1!B76","v":0}]
[{"$f":"Sheet1!A77","v":"00:00:00"},{"$f":"Sheet1!B77","v":0}]
[{"$f":"Sheet1!A78","v":"00:00:00"},{"$f":"Sheet1!B78","v":0}]
[{"$f":"Sheet1!A79","v":"00:00:00"},{"$f":"Sheet1!B79","v":0}]
[{"$f":"Sheet1!A80","v":"00:00:00"},{"$f":"Sheet1!B80","v":0}]
[{"$f":"Sheet1!A81","v":"00:00:00"},{"$f":"Sheet1!B81","v":0}]
[{"$f":"Sheet1!A82","v":"00:00:00"},{"$f":"Sheet1!B82","v":0}]
[{"$f":"Sheet1!A83","v":"00:00:00"},{"$f":"Sheet1!B83","v":0}]
[{"$f":"Sheet1!A84","v":"00:00:00"},{"$f":"Sheet1!B84","v":0}]
[{"$f":"Sheet1!A85","v":"00:00:00"},{"$f":"Sheet1!B85","v":0}]
[{"$f":"Sheet1!A86","v":"00:00:00"},{"$f":"Sheet1!B86","v":0}]
[{"$f":"Sheet1!A87","v":"00:00:00"},{"$f":"Sheet1!B87","v":0}]
[{"$f":"Sheet1!A88","v":"00:00:00"},{"$f":"Sheet1!B88","v":0}]
[{"$f":"Sheet1!A89","v":"00:00:00"},{"$f":"Sheet1!B89","v":0}]
[{"$f":"Sheet1!A90","v":"00:00:00"},{"$f":"Sheet1!B90","v":0}]
[{"$f":"Sheet1!A91","v":"00:00:00"},{"$f":"Sheet1!B91","v":0}]

{"sheet":"dataExternalFacebook","index":3,"n_rows":366,"n_cols":13,"rows_kept":366,"cut":false,"hidden":false,"merged":[]}
["Date","Lifetime Total Likes","Daily New Likes","Daily Unlikes","Daily Page Engaged Users","Weekly Page Engaged Users","28 Days Page Engaged Users","Daily Total Reach","Weekly Total Reach","28 Days Total Reach","Daily Organic Reach","Weekly Organic Reach","28 Days Organic Reach"]
["2018-11-01",35535,"","",248,10664,13516,1488,65224,97637.6,1488,65224,76756]
["2018-11-02",35650,1,"",248,10664,13516,1240,65720,97795.08,1240,65720,76880]
["2018-11-03",35650,"","",124,10664,13516,372,65596,97795.08,372,65596,76880]
["2018-11-04",35650,"","",56,10664,13392,248,65596,98110.040000000008,248,65596,76880]
["2018-11-05",35650,"","",56,3472,13392,124,34596,98110.040000000008,124,34596,76880]
["2018-11-06",35650,"","",56,1736,13392,124,11780,97795.08,124,11780,76756]
["2018-11-07",35650,"","",56,620,13268,124,3720,97637.6,124,3720,76756]
["2018-11-08",35650,"","",56,372,13268,124,2356,97637.6,124,2356,76756]
["2018-11-09",35765,1,"",6572,6696,16244,30380,31372,103464.36,30380,31372,81344]
["2018-11-10",35765,"","",4092,9424,18228,22692,43152,107873.8,22692,43152,84692]
["2018-11-11",35765,"","",496,9920,18476,4216,44888,108661.2,4092,44888,85436]
["2018-11-12",35765,"","",620,10416,18600,2232,45632,108976.16,2232,45632,85560]
["2018-11-13",35765,"","",null,10416,17980,1612,46128,100787.2,1612,46128,79236]
["2018-11-14",35765,"","",null,10416,17980,372,46004,99842.32,248,46004,78368]
["2018-11-15",35765,"","",null,10416,17236,372,46004,98425,372,46004,77376]
["2018-11-16",35880,1,"",2976,7812,18476,17856,34596,99369.88,17856,34596,78244]
["2018-11-17",35995,1,"",6324,9424,21948,36208,41292,104094.28,36208,41292,81964]
["2018-11-18",35995,1,1,4712,11532,22816,26660,49724,107401.36,26660,49724,84568]
["2018-11-19",35995,"","",744,11656,23064,4588,51460,108031.28,4588,51460,85064]
["2018-11-20",35995,"","",620,12028,23560,3720,53940,111653.32,3720,53940,87916]
["2018-11-21",35995,"","",744,12152,23684,3224,54560,111653.32,3100,54560,87916]
["2018-11-22",35995,"","",null,12152,23312,2356,54932,111968.28,2356,54932,88164]
["2018-11-23",35995,"","",124,10664,23188,124,53940,111968.28,124,53940,88164]
["2018-11-24",35995,"","",null,6448,23188,992,35216,111968.28,992,35216,88164]
["2018-11-25",35995,"","",3720,5704,24428,28148,36952,114960.40000000001,28148,36952,90520]
["2018-11-26",35995,"","",3596,7564,22568,25792,47864,110708.44,25792,47864,87172]
["2018-11-27",35995,"","",1116,7936,22320,12028,49104,100472.24,12028,49104,79112]
["2018-11-28",35995,"","",620,7936,22320,4960,51212,96377.76,4960,51212,75888]
["2018-11-29",35995,"","",2232,8928,22444,21824,54436,98425,21824,54436,77500]
["2018-11-30",35995,"","",744,9176,22568,12896,57040,98739.96,12896,57040,77748]
["2018-12-01",35995,"","",248,9424,22568,2604,57164,98739.96,2604,57164,77748]
["2018-12-02",35995,"","",124,7068,22568,2976,48484,98425,2976,48484,77500]
["2018-12-03",35995,"","",null,4464,22568,1612,39060,98267.520000000004,1488,39060,77376]
["2018-12-04",35995,"","",null,3596,22568,496,35092,98267.520000000004,496,35092,77376]
["2018-12-05",35995,"","",124,3224,22568,2356,33232,98267.520000000004,2356,33232,77376]
["2018-12-06",35995,"","",1240,2480,23064,18972,32736,105669.08,18972,32736,83204]
["2018-12-07",35995,"","",5456,7068,22196,38688,53196,115432.84,38688,53196,90892]
["2018-12-08",36110,1,"",2232,8556,21328,18972,59024,114960.40000000001,18972,59024,90520]
["2018-12-09",36110,"","",496,8680,21204,4836,60760,115905.28,4836,60760,91264]
["2018-12-10",36110,"","",124,8804,21204,3472,61380,115905.28,3472,61380,91264]
["2018-12-11",36110,"","",248,8928,21204,868,61752,115905.28,868,61752,91264]
["2018-12-12",36110,"","",null,8928,21204,248,61380,115905.28,124,61256,91264]
["2018-12-13",36110,"","",248,8060,21328,1116,50468,115905.28,1116,50344,91264]
["2018-12-14",36110,"","",496,3596,20832,16492,33108,116220.24,16492,33108,91512]
["2018-12-15",36110,"","",1736,3100,18352,13640,28520,113543.08,13640,28520,89404]
["2018-12-16",36110,"","",1860,4340,17732,12028,29884,111338.36,12028,29884,87668]
["2018-12-17",36110,"","",248,4340,17484,2604,29388,110865.92,2604,29388,87296]
["2018-12-18",36110,"","",1364,4836,17112,16864,38440,108661.2,16864,38440,85560]
["2018-12-19",36110,"","",620,5332,17236,8556,42408,110078.52,8556,42408,86676]
["2018-12-20",36110,"","",124,5332,17236,1736,42408,109448.6,1736,42408,86180]
["2018-12-21",36110,"","",868,5332,17360,15872,40176,109448.6,15872,40176,86180]
["2018-12-22",36110,"","",null,4092,17360,2604,34472,109448.6,2604,34472,86180]
["2018-12-23",36110,"","",null,2604,15996,620,26908,107243.88,620,26908,84444]
["2018-12-24",36110,"","",null,2356,14508,248,25916,102362,248,25916,80600]
["2018-12-25",36110,"","",null,1612,14012,496,22444,100472.24,496,22444,79112]
["2018-12-26",36225,1,"",3968,4712,15872,16864,25048,99842.32,16864,25048,78616]
["2018-12-27",36340,1,"",2852,7316,17360,8804,29264,98110.040000000008,8804,29264,77252]
["2018-12-28",36340,"","",1612,7688,17360,14260,28892,97007.680000000008,14260,28892,76384]
["2018-12-29",36340,"","",744,8308,17484,7068,30132,97165.16,7068,30132,76508]
["2018-12-30",36455,1,"",248,8432,17608,3224,31000,97795.08,3224,31000,77004]
["2018-12-31",36455,"","",124,8432,17608,744,31124,97795.08,744,31124,77004]
["2019-01-01",36455,"","",null,8432,17608,1736,31248,98267.520000000004,1736,31248,77376]
["2019-01-02",36455,"","",496,5332,17856,4712,27280,98110.040000000008,4588,27156,77004]
["2019-01-03",36455,"","",744,3348,17112,12028,25172,90551,12028,25048,71052]
["2019-01-04",36455,"","",1364,3100,14136,10292,26784,81417.16,10292,26660,63984]
["2019-01-05",36455,"","",620,2728,13144,21824,34720,86299.040000000008,21824,34596,67828]
["2019-01-06",36455,"","",248,2728,13020,5332,35712,86141.56,5332,35588,67704]
["2019-01-07",36455,"","",124,2604,12896,3100,36456,85984.08,3100,36332,67456]
["2019-01-08",36455,"","",1116,3348,13516,3596,37448,87558.88,3596,37324,68820]
["2019-01-09",36570,1,"",1488,4216,14384,1116,37324,87716.36,1116,37324,68944]
["2019-01-10",36570,"","",372,4216,14260,2976,35960,88188.800000000003,2976,35960,69316]
["2019-01-11",36570,"","",2604,5456,15252,17608,37324,84724.24,17608,37324,66588]
["2019-01-12",36570,"","",3596,7564,15996,14260,35712,83936.84,14260,35712,65844]
["2019-01-13",36570,"","",3968,10168,16492,20212,40052,84094.32,20212,40052,66092]
["2019-01-14",36570,"","",992,11036,16864,4092,40424,84251.8,4092,40424,66216]
["2019-01-15",36570,"","",2852,11408,17484,13144,39680,83936.84,13144,39680,65844]
["2019-01-16",36570,"","",744,10912,17360,4960,40176,82519.520000000004,4960,40176,64728]
["2019-01-17",36570,"","",3720,11780,18104,19468,43028,86614,19468,43028,67952]
["2019-01-18",36570,"","",868,10912,18600,10292,43772,88976.2,10292,43772,69936]
["2019-01-19",36570,"","",496,9672,18600,3348,42904,88976.2,3348,42904,69936]
["2019-01-20",36570,"","",124,7688,18724,1488,37820,88818.72,1488,37820,69812]
["2019-01-21",36570,"","",2232,8432,19344,22940,46004,92440.76,22940,46004,72540]
["2019-01-22",36570,"","",1612,8804,20956,8184,50592,96220.28,8184,50592,75764]
["2019-01-23",36570,"","",124,8308,19220,1488,51212,95905.32,1364,51212,75516]
["2019-01-24",36570,"","",1860,6944,17980,16740,41292,95117.92,16740,41044,74896]
["2019-01-25",36570,"","",248,6448,17856,3348,35588,94960.44,3348,35464,74772]
["2019-01-26",36570,"","",248,6200,17980,744,34720,94015.56,744,34596,74028]
["2019-01-27",36570,"","",null,6076,17980,248,34348,93700.6,248,34224,73780]
["2019-01-28",36570,"","",124,4092,18104,248,26040,94015.56,248,25916,74028]
["2019-01-29",36570,"","",null,2604,18104,{"$error":"#VALUE!"},21328,93700.6,{"$error":"#VALUE!"},21204,73780]
["2019-01-30",36570,"","",null,2480,17980,372,20584,93700.6,372,20584,73780]
["2019-01-31",36685,1,"",124,744,17980,744,5208,93700.6,744,5208,73780]
["2019-02-01",36800,1,"",124,620,17856,248,2480,90236.040000000008,124,2356,71052]
["2019-02-02",36800,"","",null,372,17608,248,2108,80472.28,248,1984,63364]
["2019-02-03",36800,"","",null,372,17608,124,1860,77480.160000000003,57000,1736,61008]
["2019-02-04",36800,"","",null,248,17608,248,1736,76377.8,124,1612,60140]
["2019-02-05",36915,1,"",7688,7936,21948,90024,90272,165511.48000000001,89404,89776,129704]
["2019-02-06",36915,"","",2852,10416,23560,55304,139996,221101.92,50592,135780,170128]
["2019-02-07",36800,"","",868,11160,24180,17360,153760,235117.64,11408,144584,177072]
["2019-02-08",36800,"","",620,11532,23560,11160,162564,243621.56,5704,149668,180792]
["2019-02-09",36800,"","",744,12152,22816,11532,168392,247716.04,5456,152644,181040]
["2019-02-10",36800,"","",744,12772,21452,8060,172608,251495.56,2480,153760,181288]
["2019-02-11",36800,"","",5456,16120,23932,28768,182528,260156.96,22816,158968,182776]
["2019-02-12",36915,1,"",1116,11284,23808,17360,126356,268818.36,8184,94488,183272]
["2019-02-13",37030,1,"",1116,9672,23932,11904,84568,275432.52,3720,50964,184140]
["2019-02-14",37145,1,"",496,9424,22816,7440,74772,271338.03999999998,2108,42284,177568]
["2019-02-15",37260,1,"",496,9300,22444,9672,73780,274645.12,620,37324,172856]
["2019-02-16",37260,"","",124,9052,22196,248,66216,273857.72000000003,248,33604,171864]
["2019-02-17",37375,1,"",124,8804,22196,1240,62248,275747.48,1240,32612,173104]
["2019-02-18",37375,"","",124,3472,20832,744,43772,272440.40000000002,620,15252,170376]
["2019-02-19",37375,"","",null,2356,19592,248,30132,268818.36,248,8308,167524]
["2019-02-20",{"$f":"B112*1.03","v":38496.25},null,null,496,9300,22444,9672,73780,274645.12,620,37324,172856]
["2019-02-21",{"$f":"B113*1.03","v":39651.137500000004},null,null,124,9052,22196,248,66216,273857.72000000003,248,33604,171864]
["2019-02-22",40840.671625000003,null,null,124,8804,22196,1240,62248,275747.48,1240,32612,173104]
["2019-02-23",42065.891773750001,null,null,124,3472,20832,744,43772,272440.40000000002,620,15252,170376]
["2019-02-24",43327.868526962506,null,null,null,2356,19592,248,30132,268818.36,248,8308,167524]
["2019-02-25",44627.704582771381,null,null,496,9300,22444,9672,73780,274645.12,620,37324,172856]
["2019-02-26",45966.53572025452,null,null,124,9052,22196,248,66216,273857.72000000003,248,33604,171864]
["2019-02-27",47345.531791862159,null,null,124,8804,22196,1240,62248,275747.48,1240,32612,173104]
["2019-02-28",48765.897745618022,null,null,124,3472,20832,744,43772,272440.40000000002,620,15252,170376]
["2019-03-01",50228.874677986561,null,null,null,2356,19592,248,30132,268818.36,248,8308,167524]
["2019-03-02",51735.740918326163,null,null,7688,7936,21948,90024,90272,165511.48000000001,89404,89776,129704]
["2019-03-03",53287.813145875945,null,null,2852,10416,23560,55304,139996,221101.92,50592,135780,170128]
["2019-03-04",54886.447540252222,null,null,868,11160,24180,17360,153760,235117.64,11408,144584,177072]
["2019-03-05",56533.04096645979,null,null,620,11532,23560,11160,162564,243621.56,5704,149668,180792]
["2019-03-06",58229.032195453583,null,null,744,12152,22816,11532,168392,247716.04,5456,152644,181040]
["2019-03-07",59975.90316131719,null,null,744,12772,21452,8060,172608,251495.56,2480,153760,181288]
["2019-03-08",61775.180256156709,null,null,496,9300,22444,9672,73780,274645.12,620,37324,172856]
["2019-03-09",63628.43566384141,null,null,124,9052,22196,248,66216,273857.72000000003,248,33604,171864]
["2019-03-10",65537.28873375665,null,null,124,8804,22196,1240,62248,275747.48,1240,32612,173104]
["2019-03-11",67503.407395769347,null,null,124,3472,20832,744,43772,272440.40000000002,620,15252,170376]
["2019-03-12",69528.509617642427,null,null,496,9300,22444,9672,73780,274645.12,620,37324,172856]
["2019-03-13",71614.364906171701,null,null,124,9052,22196,248,66216,273857.72000000003,248,33604,171864]
["2019-03-14",73762.79585335686,null,null,124,8804,22196,1240,62248,275747.48,1240,32612,173104]
["2019-03-15",75975.679728957562,null,null,124,3472,20832,744,43772,272440.40000000002,620,15252,170376]
["2019-03-16",78254.950120826295,null,null,496,5332,17856,4712,27280,98110.040000000008,4588,27156,77004]
["2019-03-17",80602.598624451086,null,null,744,3348,17112,12028,25172,90551,12028,25048,71052]
["2019-03-18",83020.676583184628,null,null,1364,3100,14136,10292,26784,81417.16,10292,26660,63984]
["2019-03-19",85511.296880680165,null,null,620,2728,13144,21824,34720,86299.040000000008,21824,34596,67828]
["2019-03-20",88076.635787100575,null,null,248,2728,13020,5332,35712,86141.56,5332,35588,67704]
["2019-03-21",90718.934860713591,null,null,7688,7936,21948,90024,90272,165511.48000000001,89404,89776,129704]
["2019-03-22",93440.502906534995,null,null,2852,10416,23560,55304,139996,221101.92,50592,135780,170128]
["2019-03-23",96243.717993731043,null,null,868,11160,24180,17360,153760,235117.64,11408,144584,177072]
["2019-03-24",99131.029533542984,null,null,620,11532,23560,11160,162564,243621.56,5704,149668,180792]
["2019-03-25",102104.96041954927,null,null,744,12152,22816,11532,168392,247716.04,5456,152644,181040]
["2019-03-26",105168.10923213576,null,null,744,12772,21452,8060,172608,251495.56,2480,153760,181288]
["2019-03-27",108323.15250909983,null,null,5456,16120,23932,28768,182528,260156.96,22816,158968,182776]
["2019-03-28",111572.84708437283,null,null,1116,11284,23808,17360,126356,268818.36,8184,94488,183272]
["2019-03-29",114920.03249690402,null,null,1116,9672,23932,11904,84568,275432.52,3720,50964,184140]
["2019-03-30",118367.63347181115,null,null,1116,9672,23932,11904,84568,275432.52,3720,50964,184140]
["2019-03-31",121918.66247596548]
["2019-04-01"]
["2019-04-02"]
["2019-04-03"]
["2019-04-04"]
["2019-04-05"]
["2019-04-06"]
["2019-04-07"]
["2019-04-08"]
["2019-04-09"]
["2019-04-10"]
["2019-04-11"]
["2019-04-12"]
["2019-04-13"]
["2019-04-14"]
["2019-04-15"]
["2019-04-16"]
["2019-04-17"]
["2019-04-18"]
["2019-04-19"]
["2019-04-20"]
["2019-04-21"]
["2019-04-22"]
["2019-04-23"]
["2019-04-24"]
["2019-04-25"]
["2019-04-26"]
["2019-04-27"]
["2019-04-28"]
["2019-04-29"]
["2019-04-30"]
["2019-05-01"]
["2019-05-02"]
["2019-05-03"]
["2019-05-04"]
["2019-05-05"]
["2019-05-06"]
["2019-05-07"]
["2019-05-08"]
["2019-05-09"]
["2019-05-10"]
["2019-05-11"]
["2019-05-12"]
["2019-05-13"]
["2019-05-14"]
["2019-05-15"]
["2019-05-16"]
["2019-05-17"]
["2019-05-18"]
["2019-05-19"]
["2019-05-20"]
["2019-05-21"]
["2019-05-22"]
["2019-05-23"]
["2019-05-24"]
["2019-05-25"]
["2019-05-26"]
["2019-05-27"]
["2019-05-28"]
["2019-05-29"]
["2019-05-30"]
["2019-05-31"]
["2019-06-01"]
["2019-06-02"]
["2019-06-03"]
["2019-06-04"]
["2019-06-05"]
["2019-06-06"]
["2019-06-07"]
["2019-06-08"]
["2019-06-09"]
["2019-06-10"]
["2019-06-11"]
["2019-06-12"]
["2019-06-13"]
["2019-06-14"]
["2019-06-15"]
["2019-06-16"]
["2019-06-17"]
["2019-06-18"]
["2019-06-19"]
["2019-06-20"]
["2019-06-21"]
["2019-06-22"]
["2019-06-23"]
["2019-06-24"]
["2019-06-25"]
["2019-06-26"]
["2019-06-27"]
["2019-06-28"]
["2019-06-29"]
["2019-06-30"]
["2019-07-01"]
["2019-07-02"]
["2019-07-03"]
["2019-07-04"]
["2019-07-05"]
["2019-07-06"]
["2019-07-07"]
["2019-07-08"]
["2019-07-09"]
["2019-07-10"]
["2019-07-11"]
["2019-07-12"]
["2019-07-13"]
["2019-07-14"]
["2019-07-15"]
["2019-07-16"]
["2019-07-17"]
["2019-07-18"]
["2019-07-19"]
["2019-07-20"]
["2019-07-21"]
["2019-07-22"]
["2019-07-23"]
["2019-07-24"]
["2019-07-25"]
["2019-07-26"]
["2019-07-27"]
["2019-07-28"]
["2019-07-29"]
["2019-07-30"]
["2019-07-31"]
["2019-08-01"]
["2019-08-02"]
["2019-08-03"]
["2019-08-04"]
["2019-08-05"]
["2019-08-06"]
["2019-08-07"]
["2019-08-08"]
["2019-08-09"]
["2019-08-10"]
["2019-08-11"]
["2019-08-12"]
["2019-08-13"]
["2019-08-14"]
["2019-08-15"]
["2019-08-16"]
["2019-08-17"]
["2019-08-18"]
["2019-08-19"]
["2019-08-20"]
["2019-08-21"]
["2019-08-22"]
["2019-08-23"]
["2019-08-24"]
["2019-08-25"]
["2019-08-26"]
["2019-08-27"]
["2019-08-28"]
["2019-08-29"]
["2019-08-30"]
["2019-08-31"]
["2019-09-01"]
["2019-09-02"]
["2019-09-03"]
["2019-09-04"]
["2019-09-05"]
["2019-09-06"]
["2019-09-07"]
["2019-09-08"]
["2019-09-09"]
["2019-09-10"]
["2019-09-11"]
["2019-09-12"]
["2019-09-13"]
["2019-09-14"]
["2019-09-15"]
["2019-09-16"]
["2019-09-17"]
["2019-09-18"]
["2019-09-19"]
["2019-09-20"]
["2019-09-21"]
["2019-09-22"]
["2019-09-23"]
["2019-09-24"]
["2019-09-25"]
["2019-09-26"]
["2019-09-27"]
["2019-09-28"]
["2019-09-29"]
["2019-09-30"]
["2019-10-01"]
["2019-10-02"]
["2019-10-03"]
["2019-10-04"]
["2019-10-05"]
["2019-10-06"]
["2019-10-07"]
["2019-10-08"]
["2019-10-09"]
["2019-10-10"]
["2019-10-11"]
["2019-10-12"]
["2019-10-13"]
["2019-10-14"]
["2019-10-15"]
["2019-10-16"]
["2019-10-17"]
["2019-10-18"]
["2019-10-19"]
["2019-10-20"]
["2019-10-21"]
["2019-10-22"]
["2019-10-23"]
["2019-10-24"]
["2019-10-25"]
["2019-10-26"]
["2019-10-27"]
["2019-10-28"]
["2019-10-29"]
["2019-10-30"]
["2019-10-31"]

{"sheet":"information","index":4,"n_rows":24,"n_cols":3,"rows_kept":24,"cut":false,"hidden":false,"merged":[]}
["Adobe Lab Exercise"]
[]
["Author","Kristi Barrow"]
[]
["Date",{"$f":"TODAY()","v":"2019-03-26"}]
[]
["Report Date",{"$f":"TODAY()","v":"2019-03-26"}]
[]
["Report Week Start Date",{"$f":"+reportWeekEnd-6","v":"2019-03-17"}]
[]
["Report Week End Date",{"$f":"INT((B7-1)/7)*7+0","v":"2019-03-23"}]
[]
["Product",{"$f":"VLOOKUP(B24,B17:C20,2,FALSE)","v":"Basic High Waist Jean"}]
[]
["Chart Title",{"$f":"B13&\" - Orders for last 8 weeks\"","v":"Basic High Waist Jean - Orders for last 8 weeks"}]
[]
["Products",1,"Basic High Waist Jean"]
[null,2,"Bling Belt High Waist Jean"]
[null,3,"Dark Slimmer Jean"]
[null,4,"Baby Blue Low Waist Jean"]
[]
[]
[]
["Product Selection",1]