{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Simulation","Demand Profile","Working","Simulation Data"],"not_rendered":{"charts":1,"images":1,"macros":1,"external_links":0,"defined_names":13,"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":"Simulation","index":0,"n_rows":42,"n_cols":20,"rows_kept":42,"cut":false,"hidden":false,"merged":[[25,18,25,19],[22,15,22,16],[9,15,10,15],[11,15,14,15],[15,15,16,15],[22,18,22,19],[23,18,23,19],[23,15,23,16],[41,0,41,21],[33,18,33,19],[31,18,31,19],[34,18,34,19],[31,15,31,16]]}
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Select-->","Store 1",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Store 1","Store 2","Total"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Orders","Orders Placed",{"$f":"COUNTIF(Working!$J$16:$J$380,\"Yes\")","v":41},{"$f":"COUNTIF(Working!U16:U380,\"Yes\")","v":58},{"$f":"R10+S10","v":99}]
[null,null,null,null,null,null,"DAY",{"$f":"Selected_Day","v":1},null,null,null,null,null,null,null,null,"Units Ordered",{"$f":"SUM(Working!K16:K380)","v":21756},{"$f":"SUM(Working!V16:V380)","v":30695},{"$f":"R11+S11","v":52451}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inventory","Average Inventory (units)",{"$f":"R13+R14","v":621.13972602739727},{"$f":"S13+S14","v":693.62191780821922},{"$f":"R12+S12","v":1314.7616438356165}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Average Stock",{"$f":"AVERAGE(Working!$G$16:$G$380)","v":263.50684931506851},{"$f":"AVERAGE(Working!R16:R380)","v":273.14246575342463},536.64931506849314]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Stock in-Transit",{"$f":"AVERAGE(Working!H16:H380)","v":357.63287671232877},{"$f":"AVERAGE(Working!S16:S380)","v":420.47945205479454},778.11232876712324]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inventory Carrying Cost ($)",{"$f":"R12*InvCarryingCost*ItemCost","v":776.42465753424653},{"$f":"S12*InvCarryingCost*ItemCost","v":867.02739726027403},1643.4520547945206]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Transportation","Transportation Cost",{"$f":"R10*TCost_Store1","v":20500},{"$f":"S10*TCost_Store2","v":58000},78500]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vehicle Utilization",{"$f":"R11/(R10*VehicleCapacity)","v":0.53063414634146344},{"$f":"S11/(S10*VehicleCapacity)","v":0.52922413793103451},{"$f":"T11/(T10*VehicleCapacity)","v":0.52980808080808084}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"All the results above are dynamic"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"All cells in green can be modified"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"MOQ Policy",null,null,"Vehicle Capacity"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,500,null,null,1000]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Transportation Cost (per trip)",null,null,"Lead Time (days)"]
[null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,"Store 1","Store 2",null,"Store 1","Store 2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,500,1000,null,7,6]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Inventory Carrying Cost"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Initial Stock",null,null,0.25]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Store 1","Store 2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,500,800,null,"Item Cost"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,5]
[null,null,null,null,null,"Simulate Day"]
[null,"Previous Day",null,null,null,null,null,null,null,null,null,null,null,"Next Day"]
[]
[]
[]
[]
["© Copyright Supply Chain Detective. This work is licensed under Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License. \nThis means that you are free to copy, modify and distribute the derivatives of this work under the same license for non-commercial use only with attribution to the original author. \nIf you wish to use this work for commercial purposes, including training, contact the author for appropriate permissions."]

{"sheet":"Demand Profile","index":1,"n_rows":369,"n_cols":6,"rows_kept":369,"cut":false,"hidden":false,"merged":[[2,1,2,3]]}
[]
[]
[null,"Demand Profile"]
[null,null,"Store 1","Store 2",null,"Enter demand (or projected demand) in units by day"]
[null,"Day 1",100,105]
[null,"Day 2",14,46]
[null,"Day 3",83,11]
[null,"Day 4",100,81]
[null,"Day 5",56,31]
[null,"Day 6",81,113]
[null,"Day 7",44,51]
[null,"Day 8",29,126]
[null,"Day 9",100,97]
[null,"Day 10",90,64]
[null,"Day 11",10,94]
[null,"Day 12",2,58]
[null,"Day 13",87,59]
[null,"Day 14",24,30]
[null,"Day 15",31,57]
[null,"Day 16",45,139]
[null,"Day 17",86,128]
[null,"Day 18",20,87]
[null,"Day 19",1,92]
[null,"Day 20",79,135]
[null,"Day 21",84,50]
[null,"Day 22",99,61]
[null,"Day 23",13,87]
[null,"Day 24",16,40]
[null,"Day 25",37,61]
[null,"Day 26",24,83]
[null,"Day 27",97,131]
[null,"Day 28",65,81]
[null,"Day 29",17,55]
[null,"Day 30",2,22]
[null,"Day 31",39,89]
[null,"Day 32",79,22]
[null,"Day 33",70,92]
[null,"Day 34",22,91]
[null,"Day 35",6,114]
[null,"Day 36",72,59]
[null,"Day 37",82,81]
[null,"Day 38",98,29]
[null,"Day 39",63,44]
[null,"Day 40",92,100]
[null,"Day 41",13,59]
[null,"Day 42",19,128]
[null,"Day 43",7,116]
[null,"Day 44",27,60]
[null,"Day 45",53,16]
[null,"Day 46",7,65]
[null,"Day 47",18,85]
[null,"Day 48",3,91]
[null,"Day 49",48,32]
[null,"Day 50",14,66]
[null,"Day 51",96,75]
[null,"Day 52",80,84]
[null,"Day 53",95,132]
[null,"Day 54",26,117]
[null,"Day 55",9,136]
[null,"Day 56",75,42]
[null,"Day 57",65,37]
[null,"Day 58",42,32]
[null,"Day 59",62,107]
[null,"Day 60",64,63]
[null,"Day 61",40,65]
[null,"Day 62",55,53]
[null,"Day 63",52,62]
[null,"Day 64",84,81]
[null,"Day 65",4,44]
[null,"Day 66",60,116]
[null,"Day 67",88,29]
[null,"Day 68",24,139]
[null,"Day 69",30,58]
[null,"Day 70",95,129]
[null,"Day 71",65,85]
[null,"Day 72",33,56]
[null,"Day 73",81,139]
[null,"Day 74",8,70]
[null,"Day 75",5,59]
[null,"Day 76",90,130]
[null,"Day 77",26,76]
[null,"Day 78",55,108]
[null,"Day 79",48,71]
[null,"Day 80",18,65]
[null,"Day 81",83,72]
[null,"Day 82",69,110]
[null,"Day 83",17,133]
[null,"Day 84",43,50]
[null,"Day 85",69,82]
[null,"Day 86",14,36]
[null,"Day 87",95,80]
[null,"Day 88",38,10]
[null,"Day 89",58,67]
[null,"Day 90",77,40]
[null,"Day 91",45,44]
[null,"Day 92",46,63]
[null,"Day 93",76,108]
[null,"Day 94",46,72]
[null,"Day 95",58,108]
[null,"Day 96",59,138]
[null,"Day 97",73,139]
[null,"Day 98",14,112]
[null,"Day 99",5,113]
[null,"Day 100",65,125]
[null,"Day 101",92,136]
[null,"Day 102",9,128]
[null,"Day 103",84,50]
[null,"Day 104",84,123]
[null,"Day 105",52,14]
[null,"Day 106",100,62]
[null,"Day 107",38,115]
[null,"Day 108",15,120]
[null,"Day 109",57,21]
[null,"Day 110",80,103]
[null,"Day 111",24,137]
[null,"Day 112",42,122]
[null,"Day 113",71,33]
[null,"Day 114",82,17]
[null,"Day 115",59,104]
[null,"Day 116",93,130]
[null,"Day 117",94,71]
[null,"Day 118",82,120]
[null,"Day 119",93,70]
[null,"Day 120",96,86]
[null,"Day 121",1,94]
[null,"Day 122",2,91]
[null,"Day 123",18,31]
[null,"Day 124",72,133]
[null,"Day 125",24,121]
[null,"Day 126",49,121]
[null,"Day 127",32,120]
[null,"Day 128",7,27]
[null,"Day 129",35,19]
[null,"Day 130",54,117]
[null,"Day 131",74,107]
[null,"Day 132",40,139]
[null,"Day 133",99,67]
[null,"Day 134",86,130]
[null,"Day 135",26,104]
[null,"Day 136",79,78]
[null,"Day 137",62,115]
[null,"Day 138",92,72]
[null,"Day 139",38,81]
[null,"Day 140",46,86]
[null,"Day 141",64,82]
[null,"Day 142",65,128]
[null,"Day 143",77,123]
[null,"Day 144",99,70]
[null,"Day 145",38,105]
[null,"Day 146",51,126]
[null,"Day 147",50,64]
[null,"Day 148",17,44]
[null,"Day 149",64,82]
[null,"Day 150",15,38]
[null,"Day 151",31,80]
[null,"Day 152",63,97]
[null,"Day 153",22,92]
[null,"Day 154",50,70]
[null,"Day 155",32,94]
[null,"Day 156",49,107]
[null,"Day 157",81,16]
[null,"Day 158",5,118]
[null,"Day 159",87,38]
[null,"Day 160",41,43]
[null,"Day 161",78,42]
[null,"Day 162",44,23]
[null,"Day 163",81,100]
[null,"Day 164",99,90]
[null,"Day 165",28,140]
[null,"Day 166",68,84]
[null,"Day 167",75,34]
[null,"Day 168",15,34]
[null,"Day 169",24,53]
[null,"Day 170",95,44]
[null,"Day 171",95,104]
[null,"Day 172",20,84]
[null,"Day 173",66,106]
[null,"Day 174",87,100]
[null,"Day 175",100,90]
[null,"Day 176",35,23]
[null,"Day 177",19,60]
[null,"Day 178",42,78]
[null,"Day 179",96,74]
[null,"Day 180",73,107]
[null,"Day 181",49,14]
[null,"Day 182",63,30]
[null,"Day 183",89,24]
[null,"Day 184",94,45]
[null,"Day 185",98,87]
[null,"Day 186",69,90]
[null,"Day 187",17,53]
[null,"Day 188",89,77]
[null,"Day 189",40,106]
[null,"Day 190",29,73]
[null,"Day 191",74,25]
[null,"Day 192",42,111]
[null,"Day 193",66,23]
[null,"Day 194",35,21]
[null,"Day 195",48,53]
[null,"Day 196",10,119]
[null,"Day 197",8,92]
[null,"Day 198",32,129]
[null,"Day 199",44,18]
[null,"Day 200",60,111]
[null,"Day 201",45,126]
[null,"Day 202",51,35]
[null,"Day 203",14,12]
[null,"Day 204",31,13]
[null,"Day 205",88,59]
[null,"Day 206",54,110]
[null,"Day 207",26,18]
[null,"Day 208",72,21]
[null,"Day 209",21,25]
[null,"Day 210",88,88]
[null,"Day 211",61,104]
[null,"Day 212",95,102]
[null,"Day 213",86,66]
[null,"Day 214",92,62]
[null,"Day 215",81,17]
[null,"Day 216",22,116]
[null,"Day 217",9,71]
[null,"Day 218",35,134]
[null,"Day 219",66,134]
[null,"Day 220",74,139]
[null,"Day 221",55,124]
[null,"Day 222",35,89]
[null,"Day 223",89,136]
[null,"Day 224",50,26]
[null,"Day 225",74,82]
[null,"Day 226",47,97]
[null,"Day 227",20,18]
[null,"Day 228",95,34]
[null,"Day 229",70,44]
[null,"Day 230",81,14]
[null,"Day 231",23,78]
[null,"Day 232",66,89]
[null,"Day 233",77,122]
[null,"Day 234",58,57]
[null,"Day 235",33,30]
[null,"Day 236",95,133]
[null,"Day 237",27,123]
[null,"Day 238",48,44]
[null,"Day 239",4,76]
[null,"Day 240",9,105]
[null,"Day 241",6,118]
[null,"Day 242",13,113]
[null,"Day 243",56,86]
[null,"Day 244",92,56]
[null,"Day 245",4,80]
[null,"Day 246",40,114]
[null,"Day 247",27,76]
[null,"Day 248",50,74]
[null,"Day 249",13,12]
[null,"Day 250",19,30]
[null,"Day 251",2,39]
[null,"Day 252",20,92]
[null,"Day 253",66,108]
[null,"Day 254",99,116]
[null,"Day 255",7,138]
[null,"Day 256",49,59]
[null,"Day 257",46,42]
[null,"Day 258",16,124]
[null,"Day 259",17,39]
[null,"Day 260",84,112]
[null,"Day 261",7,106]
[null,"Day 262",39,107]
[null,"Day 263",55,104]
[null,"Day 264",13,16]
[null,"Day 265",36,20]
[null,"Day 266",87,62]
[null,"Day 267",98,72]
[null,"Day 268",66,36]
[null,"Day 269",98,94]
[null,"Day 270",67,132]
[null,"Day 271",20,31]
[null,"Day 272",94,28]
[null,"Day 273",35,94]
[null,"Day 274",21,59]
[null,"Day 275",81,107]
[null,"Day 276",66,75]
[null,"Day 277",91,78]
[null,"Day 278",76,83]
[null,"Day 279",34,81]
[null,"Day 280",98,29]
[null,"Day 281",14,117]
[null,"Day 282",54,55]
[null,"Day 283",97,16]
[null,"Day 284",5,125]
[null,"Day 285",56,29]
[null,"Day 286",46,77]
[null,"Day 287",80,14]
[null,"Day 288",94,58]
[null,"Day 289",85,48]
[null,"Day 290",55,129]
[null,"Day 291",75,71]
[null,"Day 292",77,138]
[null,"Day 293",21,95]
[null,"Day 294",20,32]
[null,"Day 295",70,13]
[null,"Day 296",9,138]
[null,"Day 297",36,120]
[null,"Day 298",6,34]
[null,"Day 299",49,40]
[null,"Day 300",7,84]
[null,"Day 301",92,98]
[null,"Day 302",5,128]
[null,"Day 303",5,42]
[null,"Day 304",9,13]
[null,"Day 305",96,108]
[null,"Day 306",2,44]
[null,"Day 307",26,26]
[null,"Day 308",42,56]
[null,"Day 309",84,131]
[null,"Day 310",67,127]
[null,"Day 311",82,55]
[null,"Day 312",61,78]
[null,"Day 313",89,18]
[null,"Day 314",98,125]
[null,"Day 315",85,45]
[null,"Day 316",2,11]
[null,"Day 317",27,52]
[null,"Day 318",30,29]
[null,"Day 319",8,87]
[null,"Day 320",93,72]
[null,"Day 321",62,47]
[null,"Day 322",90,33]
[null,"Day 323",26,111]
[null,"Day 324",20,124]
[null,"Day 325",5,46]
[null,"Day 326",18,98]
[null,"Day 327",76,107]
[null,"Day 328",77,108]
[null,"Day 329",100,12]
[null,"Day 330",161,89]
[null,"Day 331",109,235]
[null,"Day 332",142,188]
[null,"Day 333",101,141]
[null,"Day 334",91,200]
[null,"Day 335",133,134]
[null,"Day 336",88,192]
[null,"Day 337",195,101]
[null,"Day 338",171,121]
[null,"Day 339",65,122]
[null,"Day 340",102,176]
[null,"Day 341",150,162]
[null,"Day 342",96,190]
[null,"Day 343",76,238]
[null,"Day 344",63,124]
[null,"Day 345",164,212]
[null,"Day 346",162,203]
[null,"Day 347",128,120]
[null,"Day 348",92,154]
[null,"Day 349",137,174]
[null,"Day 350",103,139]
[null,"Day 351",118,179]
[null,"Day 352",101,103]
[null,"Day 353",133,237]
[null,"Day 354",89,146]
[null,"Day 355",135,172]
[null,"Day 356",184,114]
[null,"Day 357",183,103]
[null,"Day 358",154,116]
[null,"Day 359",73,107]
[null,"Day 360",65,89]
[null,"Day 361",76,212]
[null,"Day 362",145,198]
[null,"Day 363",131,178]
[null,"Day 364",133,235]
[null,"Day 365",183,82]

{"sheet":"Working","index":2,"n_rows":380,"n_cols":22,"rows_kept":380,"cut":false,"hidden":false,"merged":[[13,1,13,10],[13,12,13,21]]}
[]
[null,31]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Store 1",null,null,null,null,null,null,null,null,null,null,"Store 2"]
[null,"S.N. ","Day","Demand","Opening Stock","Stock Received","Closing Stock","Stock In-Transit","Demand during lead time","Order Placed?","Order Quantity",null,"S.N. ","Day","Demand","Opening Stock","Stock Received","Closing Stock","Stock In-Transit","Demand during lead time","Order Placed?","Order Quantity"]
[null,1,"Day 1",{"$f":"'Demand Profile'!C5","v":100},{"$f":"InitialStock_Store1","v":500},{"$f":"IF(B16<=LT_Store1,0,OFFSET(K16,-1*LT_Store1,0,1,1))","v":0},{"$f":"E16+F16-D16","v":400},{"$f":"SUM(OFFSET(K16,-1,0,-1*(LT_Store1-1),1))","v":0},{"$f":"SUM(OFFSET(D17,0,0,LT_Store1,1))","v":407},{"$f":"IF(I16<G16+H16,\"\",\"Yes\")","v":"Yes"},{"$f":"IF(J16=\"Yes\",MAX(I16-G16,MOQ),0)","v":500},null,1,"Day 1",{"$f":"'Demand Profile'!D5","v":105},{"$f":"InitialStock_Store2","v":800},{"$f":"IF(M16<=LT_Store2,0,OFFSET(V16,-1*LT_Store2,0,1,1))","v":0},{"$f":"P16+Q16-O16","v":695},{"$f":"SUM(OFFSET(V16,-1,0,-1*(LT_Store2-1),1))","v":0},{"$f":"SUM(OFFSET(O17,0,0,LT_Store2,1))","v":333},{"$f":"IF(T16<R16+S16,\"\",\"Yes\")","v":""},{"$f":"IF(U16=\"Yes\",MAX(T16-R16,MOQ),0)","v":0}]
[null,2,"Day 2",{"$f":"'Demand Profile'!C6","v":14},{"$f":"G16","v":400},0,{"$f":"E17+F17-D17","v":386},500,493,{"$f":"IF(I17<G17+H17,\"\",\"Yes\")","v":""},0,null,2,"Day 2",{"$f":"'Demand Profile'!D6","v":46},{"$f":"R16","v":695},0,{"$f":"P17+Q17-O17","v":649},0,413,{"$f":"IF(T17<R17+S17,\"\",\"Yes\")","v":""},0]
[null,3,"Day 3",{"$f":"'Demand Profile'!C7","v":83},{"$f":"G17","v":386},0,303,500,500,"",0,null,3,"Day 3",{"$f":"'Demand Profile'!D7","v":11},{"$f":"R17","v":649},0,638,0,499,"",0]
[null,4,"Day 4",{"$f":"'Demand Profile'!C8","v":100},303,0,203,500,410,"",0,null,4,"Day 4",{"$f":"'Demand Profile'!D8","v":81},638,0,557,0,482,"",0]
[null,5,"Day 5",{"$f":"'Demand Profile'!C9","v":56},203,0,147,500,356,"",0,null,5,"Day 5",{"$f":"'Demand Profile'!D9","v":31},557,0,{"$f":"P20+Q20-O20","v":526},0,545,{"$f":"IF(T20<R20+S20,\"\",\"Yes\")","v":"Yes"},500]
[null,6,"Day 6",{"$f":"'Demand Profile'!C10","v":81},147,0,66,500,362,"",0,null,6,"Day 6",{"$f":"'Demand Profile'!D10","v":113},526,0,413,500,490,"",0]
[null,7,"Day 7",{"$f":"'Demand Profile'!C11","v":44},66,0,22,500,342,"",0,null,7,"Day 7",{"$f":"'Demand Profile'!D11","v":51},413,0,362,500,498,"",0]
[null,8,"Day 8",{"$f":"'Demand Profile'!C12","v":29},22,500,493,0,344,"",0,null,8,"Day 8",{"$f":"'Demand Profile'!D12","v":126},362,0,236,500,402,"",0]
[null,9,"Day 9",{"$f":"'Demand Profile'!C13","v":100},493,0,393,0,289,"",0,null,9,"Day 9",{"$f":"'Demand Profile'!D13","v":97},236,0,139,500,362,"",0]
[null,10,"Day 10",{"$f":"'Demand Profile'!C14","v":90},393,0,303,0,285,"",0,null,10,"Day 10",{"$f":"'Demand Profile'!D14","v":64},139,0,75,500,437,"",0]
[null,11,"Day 11",{"$f":"'Demand Profile'!C15","v":10},303,0,293,0,295,"Yes",500,null,11,"Day 11",{"$f":"'Demand Profile'!D15","v":94},75,500,481,0,471,"",0]
[null,12,"Day 12",{"$f":"'Demand Profile'!C16","v":2},293,0,291,500,294,"",0,null,12,"Day 12",{"$f":"'Demand Profile'!D16","v":58},481,0,423,0,500,"Yes",500]
[null,13,"Day 13",{"$f":"'Demand Profile'!C17","v":87},291,0,204,500,286,"",0,null,13,"Day 13",{"$f":"'Demand Profile'!D17","v":59},423,0,364,500,533,"",0]
[null,14,"Day 14",{"$f":"'Demand Profile'!C18","v":24},204,0,180,500,346,"",0,null,14,"Day 14",{"$f":"'Demand Profile'!D18","v":30},364,0,334,500,638,"",0]
[null,15,"Day 15",{"$f":"'Demand Profile'!C19","v":31},180,0,149,500,414,"",0,null,15,"Day 15",{"$f":"'Demand Profile'!D19","v":57},334,0,277,500,631,"",0]
[null,16,"Day 16",{"$f":"'Demand Profile'!C20","v":45},149,0,104,500,382,"",0,null,16,"Day 16",{"$f":"'Demand Profile'!D20","v":139},277,0,138,500,553,"",0]
[null,17,"Day 17",{"$f":"'Demand Profile'!C21","v":86},104,0,18,500,312,"",0,null,17,"Day 17",{"$f":"'Demand Profile'!D21","v":128},138,0,10,500,512,"Yes",502]
[null,18,"Day 18",{"$f":"'Demand Profile'!C22","v":20},18,500,498,0,329,"",0,null,18,"Day 18",{"$f":"'Demand Profile'!D22","v":87},10,500,423,502,465,"",0]
[null,19,"Day 19",{"$f":"'Demand Profile'!C23","v":1},498,0,497,0,352,"",0,null,19,"Day 19",{"$f":"'Demand Profile'!D23","v":92},423,0,331,502,434,"",0]
[null,20,"Day 20",{"$f":"'Demand Profile'!C24","v":79},497,0,418,0,370,"",0,null,20,"Day 20",{"$f":"'Demand Profile'!D24","v":135},331,0,196,502,382,"",0]
[null,21,"Day 21",{"$f":"'Demand Profile'!C25","v":84},418,0,334,0,351,"Yes",500,null,21,"Day 21",{"$f":"'Demand Profile'!D25","v":50},196,0,146,502,463,"",0]
[null,22,"Day 22",{"$f":"'Demand Profile'!C26","v":99},334,0,235,500,269,"",0,null,22,"Day 22",{"$f":"'Demand Profile'!D26","v":61},146,0,85,502,483,"",0]
[null,23,"Day 23",{"$f":"'Demand Profile'!C27","v":13},235,0,222,500,258,"",0,null,23,"Day 23",{"$f":"'Demand Profile'!D27","v":87},85,502,500,0,451,"",0]
[null,24,"Day 24",{"$f":"'Demand Profile'!C28","v":16},222,0,206,500,281,"",0,null,24,"Day 24",{"$f":"'Demand Profile'!D28","v":40},500,0,460,0,433,"",0]
[null,25,"Day 25",{"$f":"'Demand Profile'!C29","v":37},206,0,169,500,323,"",0,null,25,"Day 25",{"$f":"'Demand Profile'!D29","v":61},460,0,399,0,461,"Yes",500]
[null,26,"Day 26",{"$f":"'Demand Profile'!C30","v":24},169,0,145,500,369,"",0,null,26,"Day 26",{"$f":"'Demand Profile'!D30","v":83},399,0,316,500,400,"",0]
[null,27,"Day 27",{"$f":"'Demand Profile'!C31","v":97},145,0,48,500,294,"",0,null,27,"Day 27",{"$f":"'Demand Profile'!D31","v":131},316,0,185,500,361,"",0]
[null,28,"Day 28",{"$f":"'Demand Profile'!C32","v":65},48,500,483,0,235,"",0,null,28,"Day 28",{"$f":"'Demand Profile'!D32","v":81},185,0,104,500,371,"",0]
[null,29,"Day 29",{"$f":"'Demand Profile'!C33","v":17},483,0,466,0,290,"",0,null,29,"Day 29",{"$f":"'Demand Profile'!D33","v":55},104,0,49,500,430,"",0]
[null,30,"Day 30",{"$f":"'Demand Profile'!C34","v":2},466,0,464,0,370,"",0,null,30,"Day 30",{"$f":"'Demand Profile'!D34","v":22},49,0,27,500,467,"",0]
[null,31,"Day 31",{"$f":"'Demand Profile'!C35","v":39},464,0,425,0,429,"Yes",500,null,31,"Day 31",{"$f":"'Demand Profile'!D35","v":89},27,500,438,0,459,"Yes",500]
[null,32,"Day 32",{"$f":"'Demand Profile'!C36","v":79},425,0,346,500,413,"",0,null,32,"Day 32",{"$f":"'Demand Profile'!D36","v":22},438,0,416,500,466,"",0]
[null,33,"Day 33",{"$f":"'Demand Profile'!C37","v":70},346,0,276,500,435,"",0,null,33,"Day 33",{"$f":"'Demand Profile'!D37","v":92},416,0,324,500,418,"",0]
[null,34,"Day 34",{"$f":"'Demand Profile'!C38","v":22},276,0,254,500,426,"",0,null,34,"Day 34",{"$f":"'Demand Profile'!D38","v":91},324,0,233,500,427,"",0]
[null,35,"Day 35",{"$f":"'Demand Profile'!C39","v":6},254,0,248,500,439,"",0,null,35,"Day 35",{"$f":"'Demand Profile'!D39","v":114},233,0,119,500,372,"",0]
[null,36,"Day 36",{"$f":"'Demand Profile'!C40","v":72},248,0,176,500,374,"",0,null,36,"Day 36",{"$f":"'Demand Profile'!D40","v":59},119,0,60,500,441,"",0]
[null,37,"Day 37",{"$f":"'Demand Profile'!C41","v":82},176,0,94,500,319,"",0,null,37,"Day 37",{"$f":"'Demand Profile'!D41","v":81},60,500,479,0,476,"",0]
[null,38,"Day 38",{"$f":"'Demand Profile'!C42","v":98},94,500,496,0,274,"",0,null,38,"Day 38",{"$f":"'Demand Profile'!D42","v":29},479,0,450,0,507,"Yes",500]
[null,39,"Day 39",{"$f":"'Demand Profile'!C43","v":63},496,0,433,0,218,"",0,null,39,"Day 39",{"$f":"'Demand Profile'!D43","v":44},450,0,406,500,479,"",0]
[null,40,"Day 40",{"$f":"'Demand Profile'!C44","v":92},433,0,341,0,144,"",0,null,40,"Day 40",{"$f":"'Demand Profile'!D44","v":100},406,0,306,500,444,"",0]
[null,41,"Day 41",{"$f":"'Demand Profile'!C45","v":13},341,0,328,0,134,"",0,null,41,"Day 41",{"$f":"'Demand Profile'!D45","v":59},306,0,247,500,470,"",0]
[null,42,"Day 42",{"$f":"'Demand Profile'!C46","v":19},328,0,309,0,163,"",0,null,42,"Day 42",{"$f":"'Demand Profile'!D46","v":128},247,0,119,500,433,"",0]
[null,43,"Day 43",{"$f":"'Demand Profile'!C47","v":7},309,0,302,0,170,"",0,null,43,"Day 43",{"$f":"'Demand Profile'!D47","v":116},119,0,3,500,349,"",0]
[null,44,"Day 44",{"$f":"'Demand Profile'!C48","v":27},302,0,275,0,239,"",0,null,44,"Day 44",{"$f":"'Demand Profile'!D48","v":60},3,500,443,0,355,"",0]
[null,45,"Day 45",{"$f":"'Demand Profile'!C49","v":53},275,0,222,0,266,"Yes",500,null,45,"Day 45",{"$f":"'Demand Profile'!D49","v":16},443,0,427,0,414,"",0]
[null,46,"Day 46",{"$f":"'Demand Profile'!C50","v":7},222,0,215,500,354,"",0,null,46,"Day 46",{"$f":"'Demand Profile'!D50","v":65},427,0,362,0,433,"Yes",500]
[null,47,"Day 47",{"$f":"'Demand Profile'!C51","v":18},215,0,197,500,362,"",0,null,47,"Day 47",{"$f":"'Demand Profile'!D51","v":85},362,0,277,500,480,"",0]
[null,48,"Day 48",{"$f":"'Demand Profile'!C52","v":3},197,0,194,500,368,"",0,null,48,"Day 48",{"$f":"'Demand Profile'!D52","v":91},277,0,186,500,506,"",0]
[null,49,"Day 49",{"$f":"'Demand Profile'!C53","v":48},194,0,146,500,395,"",0,null,49,"Day 49",{"$f":"'Demand Profile'!D53","v":32},186,0,154,500,610,"",0]
[null,50,"Day 50",{"$f":"'Demand Profile'!C54","v":14},146,0,132,500,446,"",0,null,50,"Day 50",{"$f":"'Demand Profile'!D54","v":66},154,0,88,500,586,"",0]
[null,51,"Day 51",{"$f":"'Demand Profile'!C55","v":96},132,0,36,500,392,"",0,null,51,"Day 51",{"$f":"'Demand Profile'!D55","v":75},88,0,13,500,548,"Yes",535]
[null,52,"Day 52",{"$f":"'Demand Profile'!C56","v":80},36,500,456,0,374,"",0,null,52,"Day 52",{"$f":"'Demand Profile'!D56","v":84},13,500,429,535,496,"",0]
[null,53,"Day 53",{"$f":"'Demand Profile'!C57","v":95},456,0,361,0,343,"",0,null,53,"Day 53",{"$f":"'Demand Profile'!D57","v":132},429,0,297,535,471,"",0]
[null,54,"Day 54",{"$f":"'Demand Profile'!C58","v":26},361,0,335,0,357,"Yes",500,null,54,"Day 54",{"$f":"'Demand Profile'!D58","v":117},297,0,180,535,417,"",0]
[null,55,"Day 55",{"$f":"'Demand Profile'!C59","v":9},335,0,326,500,403,"",0,null,55,"Day 55",{"$f":"'Demand Profile'!D59","v":136},180,0,44,535,346,"",0]
[null,56,"Day 56",{"$f":"'Demand Profile'!C60","v":75},326,0,251,500,380,"",0,null,56,"Day 56",{"$f":"'Demand Profile'!D60","v":42},44,0,2,535,357,"",0]
[null,57,"Day 57",{"$f":"'Demand Profile'!C61","v":65},251,0,186,500,399,"",0,null,57,"Day 57",{"$f":"'Demand Profile'!D61","v":37},2,535,500,0,382,"",0]
[null,58,"Day 58",{"$f":"'Demand Profile'!C62","v":42},186,0,144,500,361,"",0,null,58,"Day 58",{"$f":"'Demand Profile'!D62","v":32},500,0,468,0,431,"",0]
[null,59,"Day 59",{"$f":"'Demand Profile'!C63","v":62},144,0,82,500,359,"",0,null,59,"Day 59",{"$f":"'Demand Profile'!D63","v":107},468,0,361,0,368,"Yes",500]
[null,60,"Day 60",{"$f":"'Demand Profile'!C64","v":64},82,0,18,500,383,"",0,null,60,"Day 60",{"$f":"'Demand Profile'!D64","v":63},361,0,298,500,421,"",0]
[null,61,"Day 61",{"$f":"'Demand Profile'!C65","v":40},18,500,478,0,367,"",0,null,61,"Day 61",{"$f":"'Demand Profile'!D65","v":65},298,0,233,500,385,"",0]
[null,62,"Day 62",{"$f":"'Demand Profile'!C66","v":55},478,0,423,0,342,"",0,null,62,"Day 62",{"$f":"'Demand Profile'!D66","v":53},233,0,180,500,471,"",0]
[null,63,"Day 63",{"$f":"'Demand Profile'!C67","v":52},423,0,371,0,385,"Yes",500,null,63,"Day 63",{"$f":"'Demand Profile'!D67","v":62},180,0,118,500,467,"",0]
[null,64,"Day 64",{"$f":"'Demand Profile'!C68","v":84},371,0,287,500,366,"",0,null,64,"Day 64",{"$f":"'Demand Profile'!D68","v":81},118,0,37,500,515,"",0]
[null,65,"Day 65",{"$f":"'Demand Profile'!C69","v":4},287,{"$f":"IF(B80<=LT_Store1,0,OFFSET(K80,-1*LT_Store1,0,1,1))","v":0},283,{"$f":"SUM(OFFSET(K80,-1,0,-1*(LT_Store1-1),1))","v":500},{"$f":"SUM(OFFSET(D81,0,0,LT_Store1,1))","v":395},"",{"$f":"IF(J80=\"Yes\",MAX(I80-G80,MOQ),0)","v":0},null,65,"Day 65",{"$f":"'Demand Profile'!D69","v":44},37,{"$f":"IF(M80<=LT_Store2,0,OFFSET(V80,-1*LT_Store2,0,1,1))","v":500},493,{"$f":"SUM(OFFSET(V80,-1,0,-1*(LT_Store2-1),1))","v":0},{"$f":"SUM(OFFSET(O81,0,0,LT_Store2,1))","v":556},"Yes",{"$f":"IF(U80=\"Yes\",MAX(T80-R80,MOQ),0)","v":500}]
[null,66,"Day 66",{"$f":"'Demand Profile'!C70","v":60},283,0,{"$f":"E81+F81-D81","v":223},500,416,{"$f":"IF(I81<G81+H81,\"\",\"Yes\")","v":""},0,null,66,"Day 66",{"$f":"'Demand Profile'!D70","v":116},493,0,377,500,496,"",0]
[null,67,"Day 67",{"$f":"'Demand Profile'!C71","v":88},{"$f":"G81","v":223},0,135,500,336,"",0,null,67,"Day 67",{"$f":"'Demand Profile'!D71","v":29},{"$f":"R81","v":377},0,348,500,606,"",0]
[null,68,"Day 68",{"$f":"'Demand Profile'!C72","v":24},135,0,111,500,317,"",0,null,68,"Day 68",{"$f":"'Demand Profile'!D72","v":139},348,0,209,500,537,"",0]
[null,69,"Day 69",{"$f":"'Demand Profile'!C73","v":30},111,0,81,500,377,"",0,null,69,"Day 69",{"$f":"'Demand Profile'!D73","v":58},209,0,{"$f":"P84+Q84-O84","v":151},500,538,{"$f":"IF(T84<R84+S84,\"\",\"Yes\")","v":""},0]
[null,70,"Day 70",{"$f":"'Demand Profile'!C74","v":95},81,500,486,0,308,"",0,null,70,"Day 70",{"$f":"'Demand Profile'!D74","v":129},151,0,22,500,539,"Yes",517]
[null,71,"Day 71",{"$f":"'Demand Profile'!C75","v":65},486,0,421,0,298,"",0,null,71,"Day 71",{"$f":"'Demand Profile'!D75","v":85},22,500,437,517,530,"",0]
[null,72,"Day 72",{"$f":"'Demand Profile'!C76","v":33},421,0,388,0,313,"",0,null,72,"Day 72",{"$f":"'Demand Profile'!D76","v":56},437,0,381,517,582,"",0]
[null,73,"Day 73",{"$f":"'Demand Profile'!C77","v":81},388,0,307,0,250,"",0,null,73,"Day 73",{"$f":"'Demand Profile'!D77","v":139},381,0,242,517,514,"",0]
[null,74,"Day 74",{"$f":"'Demand Profile'!C78","v":8},307,0,299,0,325,"Yes",500,null,74,"Day 74",{"$f":"'Demand Profile'!D78","v":70},242,0,172,517,509,"",0]
[null,75,"Day 75",{"$f":"'Demand Profile'!C79","v":5},299,0,294,500,389,"",0,null,75,"Day 75",{"$f":"'Demand Profile'!D79","v":59},172,0,113,517,522,"",0]
[null,76,"Day 76",{"$f":"'Demand Profile'!C80","v":90},294,0,204,500,316,"",0,null,76,"Day 76",{"$f":"'Demand Profile'!D80","v":130},113,517,500,0,502,"Yes",500]
[null,77,"Day 77",{"$f":"'Demand Profile'!C81","v":26},204,0,178,500,333,"",0,null,77,"Day 77",{"$f":"'Demand Profile'!D81","v":76},500,0,424,500,559,"",0]
[null,78,"Day 78",{"$f":"'Demand Profile'!C82","v":55},178,0,123,500,347,"",0,null,78,"Day 78",{"$f":"'Demand Profile'!D82","v":108},424,0,316,500,501,"",0]
[null,79,"Day 79",{"$f":"'Demand Profile'!C83","v":48},123,0,75,500,313,"",0,null,79,"Day 79",{"$f":"'Demand Profile'!D83","v":71},316,0,245,500,512,"",0]
[null,80,"Day 80",{"$f":"'Demand Profile'!C84","v":18},75,0,57,500,390,"",0,null,80,"Day 80",{"$f":"'Demand Profile'!D84","v":65},245,0,180,500,483,"",0]
[null,81,"Day 81",{"$f":"'Demand Profile'!C85","v":83},57,500,474,0,345,"",0,null,81,"Day 81",{"$f":"'Demand Profile'!D85","v":72},180,0,108,500,491,"",0]
[null,82,"Day 82",{"$f":"'Demand Profile'!C86","v":69},474,0,405,0,334,"",0,null,82,"Day 82",{"$f":"'Demand Profile'!D86","v":110},108,500,498,0,391,"",0]
[null,83,"Day 83",{"$f":"'Demand Profile'!C87","v":17},405,0,388,0,394,"Yes",500,null,83,"Day 83",{"$f":"'Demand Profile'!D87","v":133},498,0,365,0,325,"",0]
[null,84,"Day 84",{"$f":"'Demand Profile'!C88","v":43},388,0,345,500,396,"",0,null,84,"Day 84",{"$f":"'Demand Profile'!D88","v":50},365,0,315,0,315,"Yes",500]
[null,85,"Day 85",{"$f":"'Demand Profile'!C89","v":69},345,0,276,500,373,"",0,null,85,"Day 85",{"$f":"'Demand Profile'!D89","v":82},315,0,233,500,277,"",0]
[null,86,"Day 86",{"$f":"'Demand Profile'!C90","v":14},276,0,262,500,435,"",0,null,86,"Day 86",{"$f":"'Demand Profile'!D90","v":36},233,0,197,500,304,"",0]
[null,87,"Day 87",{"$f":"'Demand Profile'!C91","v":95},262,0,167,500,386,"",0,null,87,"Day 87",{"$f":"'Demand Profile'!D91","v":80},197,0,117,500,332,"",0]
[null,88,"Day 88",{"$f":"'Demand Profile'!C92","v":38},167,0,129,500,406,"",0,null,88,"Day 88",{"$f":"'Demand Profile'!D92","v":10},117,0,107,500,394,"",0]
[null,89,"Day 89",{"$f":"'Demand Profile'!C93","v":58},129,0,71,500,407,"",0,null,89,"Day 89",{"$f":"'Demand Profile'!D93","v":67},107,0,40,500,435,"",0]
[null,90,"Day 90",{"$f":"'Demand Profile'!C94","v":77},71,500,494,0,403,"",0,null,90,"Day 90",{"$f":"'Demand Profile'!D94","v":40},40,500,500,0,533,"Yes",500]
[null,91,"Day 91",{"$f":"'Demand Profile'!C95","v":45},494,0,449,0,372,"",0,null,91,"Day 91",{"$f":"'Demand Profile'!D95","v":44},500,0,456,500,628,"",0]
[null,92,"Day 92",{"$f":"'Demand Profile'!C96","v":46},449,0,403,0,331,"",0,null,92,"Day 92",{"$f":"'Demand Profile'!D96","v":63},456,0,393,500,677,"",0]
[null,93,"Day 93",{"$f":"'Demand Profile'!C97","v":76},403,0,327,0,320,"",0,null,93,"Day 93",{"$f":"'Demand Profile'!D97","v":108},393,0,285,500,682,"",0]
[null,94,"Day 94",{"$f":"'Demand Profile'!C98","v":46},327,0,281,0,366,"Yes",500,null,94,"Day 94",{"$f":"'Demand Profile'!D98","v":72},285,0,213,500,735,"Yes",522]
[null,95,"Day 95",{"$f":"'Demand Profile'!C99","v":58},281,0,223,500,317,"",0,null,95,"Day 95",{"$f":"'Demand Profile'!D99","v":108},213,0,105,1022,763,"",0]
[null,96,"Day 96",{"$f":"'Demand Profile'!C100","v":59},223,0,164,500,342,"",0,null,96,"Day 96",{"$f":"'Demand Profile'!D100","v":138},105,500,467,522,753,"",0]
[null,97,"Day 97",{"$f":"'Demand Profile'!C101","v":73},164,0,91,500,353,"",0,null,97,"Day 97",{"$f":"'Demand Profile'!D101","v":139},467,0,328,522,664,"",0]
[null,98,"Day 98",{"$f":"'Demand Profile'!C102","v":14},91,0,77,500,391,"",0,null,98,"Day 98",{"$f":"'Demand Profile'!D102","v":112},328,0,216,522,675,"",0]
[null,99,"Day 99",{"$f":"'Demand Profile'!C103","v":5},77,0,72,500,486,"",0,null,99,"Day 99",{"$f":"'Demand Profile'!D103","v":113},216,0,103,522,576,"",0]
[null,100,"Day 100",{"$f":"'Demand Profile'!C104","v":65},72,0,7,500,459,"",0,null,100,"Day 100",{"$f":"'Demand Profile'!D104","v":125},103,522,500,0,513,"Yes",500]
[null,101,"Day 101",{"$f":"'Demand Profile'!C105","v":92},7,500,415,0,382,"",0,null,101,"Day 101",{"$f":"'Demand Profile'!D105","v":136},500,0,364,500,492,"",0]
[null,102,"Day 102",{"$f":"'Demand Profile'!C106","v":9},415,0,406,0,430,"Yes",500,null,102,"Day 102",{"$f":"'Demand Profile'!D106","v":128},364,0,236,500,484,"",0]
[null,103,"Day 103",{"$f":"'Demand Profile'!C107","v":84},406,0,322,500,426,"",0,null,103,"Day 103",{"$f":"'Demand Profile'!D107","v":50},236,0,186,500,455,"",0]
[null,104,"Day 104",{"$f":"'Demand Profile'!C108","v":84},322,0,238,500,366,"",0,null,104,"Day 104",{"$f":"'Demand Profile'!D108","v":123},186,0,63,500,435,"",0]
[null,105,"Day 105",{"$f":"'Demand Profile'!C109","v":52},238,0,186,500,356,"",0,null,105,"Day 105",{"$f":"'Demand Profile'!D109","v":14},63,0,49,500,558,"Yes",509]
[null,106,"Day 106",{"$f":"'Demand Profile'!C110","v":100},186,0,86,500,327,"",0,null,106,"Day 106",{"$f":"'Demand Profile'!D110","v":62},49,500,487,509,618,"",0]
[null,107,"Day 107",{"$f":"'Demand Profile'!C111","v":38},86,0,48,500,371,"",0,null,107,"Day 107",{"$f":"'Demand Profile'!D111","v":115},487,0,372,509,536,"",0]
[null,108,"Day 108",{"$f":"'Demand Profile'!C112","v":15},48,0,33,500,415,"",0,null,108,"Day 108",{"$f":"'Demand Profile'!D112","v":120},372,0,252,509,433,"",0]
[null,109,"Day 109",{"$f":"'Demand Profile'!C113","v":57},33,500,476,0,451,"",0,null,109,"Day 109",{"$f":"'Demand Profile'!D113","v":21},252,0,231,509,516,"",0]
[null,110,"Day 110",{"$f":"'Demand Profile'!C114","v":80},476,0,396,0,465,"Yes",500,null,110,"Day 110",{"$f":"'Demand Profile'!D114","v":103},231,0,128,509,543,"",0]
[null,111,"Day 111",{"$f":"'Demand Profile'!C115","v":24},396,0,372,500,523,"",0,null,111,"Day 111",{"$f":"'Demand Profile'!D115","v":137},128,509,500,0,477,"",0]
[null,112,"Day 112",{"$f":"'Demand Profile'!C116","v":42},372,0,330,500,574,"",0,null,112,"Day 112",{"$f":"'Demand Profile'!D116","v":122},500,0,378,0,475,"Yes",500]
[null,113,"Day 113",{"$f":"'Demand Profile'!C117","v":71},330,0,259,500,599,"",0,null,113,"Day 113",{"$f":"'Demand Profile'!D117","v":33},378,0,345,500,512,"",0]
[null,114,"Day 114",{"$f":"'Demand Profile'!C118","v":82},259,0,177,500,518,"",0,null,114,"Day 114",{"$f":"'Demand Profile'!D118","v":17},345,0,328,500,581,"",0]
[null,115,"Day 115",{"$f":"'Demand Profile'!C119","v":59},177,0,118,500,461,"",0,null,115,"Day 115",{"$f":"'Demand Profile'!D119","v":104},328,0,224,500,571,"",0]
[null,116,"Day 116",{"$f":"'Demand Profile'!C120","v":93},118,0,25,500,386,"",0,null,116,"Day 116",{"$f":"'Demand Profile'!D120","v":130},224,0,94,500,532,"",0]
[null,117,"Day 117",{"$f":"'Demand Profile'!C121","v":94},25,500,431,0,364,"",0,null,117,"Day 117",{"$f":"'Demand Profile'!D121","v":71},94,0,23,500,492,"",0]
[null,118,"Day 118",{"$f":"'Demand Profile'!C122","v":82},431,0,349,0,306,"",0,null,118,"Day 118",{"$f":"'Demand Profile'!D122","v":120},23,500,403,0,505,"Yes",500]
[null,119,"Day 119",{"$f":"'Demand Profile'!C123","v":93},349,0,256,0,262,"Yes",500,null,119,"Day 119",{"$f":"'Demand Profile'!D123","v":70},403,0,333,500,556,"",0]
[null,120,"Day 120",{"$f":"'Demand Profile'!C124","v":96},256,0,160,500,198,"",0,null,120,"Day 120",{"$f":"'Demand Profile'!D124","v":86},333,0,247,500,591,"",0]
[null,121,"Day 121",{"$f":"'Demand Profile'!C125","v":1},160,0,159,500,204,"",0,null,121,"Day 121",{"$f":"'Demand Profile'!D125","v":94},247,0,153,500,617,"",0]
[null,122,"Day 122",{"$f":"'Demand Profile'!C126","v":2},159,0,157,500,237,"",0,null,122,"Day 122",{"$f":"'Demand Profile'!D126","v":91},153,0,62,500,553,"",0]
[null,123,"Day 123",{"$f":"'Demand Profile'!C127","v":18},157,0,139,500,273,"",0,null,123,"Day 123",{"$f":"'Demand Profile'!D127","v":31},62,0,31,500,541,"Yes",510]
[null,124,"Day 124",{"$f":"'Demand Profile'!C128","v":72},139,0,67,500,275,"",0,null,124,"Day 124",{"$f":"'Demand Profile'!D128","v":133},31,500,398,510,525,"",0]
[null,125,"Day 125",{"$f":"'Demand Profile'!C129","v":24},67,0,43,500,291,"",0,null,125,"Day 125",{"$f":"'Demand Profile'!D129","v":121},398,0,277,510,511,"",0]
[null,126,"Day 126",{"$f":"'Demand Profile'!C130","v":49},43,500,494,0,341,"",0,null,126,"Day 126",{"$f":"'Demand Profile'!D130","v":121},277,0,156,510,529,"",0]
[null,127,"Day 127",{"$f":"'Demand Profile'!C131","v":32},494,0,462,0,395,"",0,null,127,"Day 127",{"$f":"'Demand Profile'!D131","v":120},156,0,36,510,476,"",0]
[null,128,"Day 128",{"$f":"'Demand Profile'!C132","v":7},462,0,455,0,414,"",0,null,128,"Day 128",{"$f":"'Demand Profile'!D132","v":27},36,0,9,510,579,"Yes",570]
[null,129,"Day 129",{"$f":"'Demand Profile'!C133","v":35},455,{"$f":"IF(B144<=LT_Store1,0,OFFSET(K144,-1*LT_Store1,0,1,1))","v":0},420,{"$f":"SUM(OFFSET(K144,-1,0,-1*(LT_Store1-1),1))","v":0},{"$f":"SUM(OFFSET(D145,0,0,LT_Store1,1))","v":458},"Yes",{"$f":"IF(J144=\"Yes\",MAX(I144-G144,MOQ),0)","v":500},null,129,"Day 129",{"$f":"'Demand Profile'!D133","v":19},9,{"$f":"IF(M144<=LT_Store2,0,OFFSET(V144,-1*LT_Store2,0,1,1))","v":510},500,{"$f":"SUM(OFFSET(V144,-1,0,-1*(LT_Store2-1),1))","v":570},{"$f":"SUM(OFFSET(O145,0,0,LT_Store2,1))","v":664},"",{"$f":"IF(U144=\"Yes\",MAX(T144-R144,MOQ),0)","v":0}]
[null,130,"Day 130",{"$f":"'Demand Profile'!C134","v":54},420,0,{"$f":"E145+F145-D145","v":366},500,466,{"$f":"IF(I145<G145+H145,\"\",\"Yes\")","v":""},0,null,130,"Day 130",{"$f":"'Demand Profile'!D134","v":117},500,0,383,570,625,"",0]
[null,131,"Day 131",{"$f":"'Demand Profile'!C135","v":74},{"$f":"G145","v":366},0,292,500,484,"",0,null,131,"Day 131",{"$f":"'Demand Profile'!D135","v":107},{"$f":"R145","v":383},0,276,570,633,"",0]
[null,132,"Day 132",{"$f":"'Demand Profile'!C136","v":40},292,0,252,500,482,"",0,null,132,"Day 132",{"$f":"'Demand Profile'!D136","v":139},276,0,137,570,566,"",0]
[null,133,"Day 133",{"$f":"'Demand Profile'!C137","v":99},252,0,153,500,429,"",0,null,133,"Day 133",{"$f":"'Demand Profile'!D137","v":67},137,0,{"$f":"P148+Q148-O148","v":70},570,580,{"$f":"IF(T148<R148+S148,\"\",\"Yes\")","v":""},0]
[null,134,"Day 134",{"$f":"'Demand Profile'!C138","v":86},153,0,67,500,407,"",0,null,134,"Day 134",{"$f":"'Demand Profile'!D138","v":130},70,570,510,0,536,"Yes",500]
[null,135,"Day 135",{"$f":"'Demand Profile'!C139","v":26},67,0,41,500,446,"",0,null,135,"Day 135",{"$f":"'Demand Profile'!D139","v":104},510,0,406,500,514,"",0]
[null,136,"Day 136",{"$f":"'Demand Profile'!C140","v":79},41,500,462,0,444,"",0,null,136,"Day 136",{"$f":"'Demand Profile'!D140","v":78},406,0,328,500,564,"",0]
[null,137,"Day 137",{"$f":"'Demand Profile'!C141","v":62},462,0,400,0,481,"Yes",500,null,137,"Day 137",{"$f":"'Demand Profile'!D141","v":115},328,0,213,500,572,"",0]
[null,138,"Day 138",{"$f":"'Demand Profile'!C142","v":92},400,0,308,500,427,"",0,null,138,"Day 138",{"$f":"'Demand Profile'!D142","v":72},213,0,141,500,570,"",0]
[null,139,"Day 139",{"$f":"'Demand Profile'!C143","v":38},308,0,270,500,440,"",0,null,139,"Day 139",{"$f":"'Demand Profile'!D143","v":81},141,0,60,500,594,"Yes",534]
[null,140,"Day 140",{"$f":"'Demand Profile'!C144","v":46},270,0,224,500,444,"",0,null,140,"Day 140",{"$f":"'Demand Profile'!D144","v":86},60,500,474,534,634,"",0]
[null,141,"Day 141",{"$f":"'Demand Profile'!C145","v":64},224,0,160,500,397,"",0,null,141,"Day 141",{"$f":"'Demand Profile'!D145","v":82},474,0,392,534,616,"",0]
[null,142,"Day 142",{"$f":"'Demand Profile'!C146","v":65},160,0,95,500,396,"",0,null,142,"Day 142",{"$f":"'Demand Profile'!D146","v":128},392,0,264,534,532,"",0]
[null,143,"Day 143",{"$f":"'Demand Profile'!C147","v":77},95,0,18,500,334,"",0,null,143,"Day 143",{"$f":"'Demand Profile'!D147","v":123},264,0,141,534,491,"",0]
[null,144,"Day 144",{"$f":"'Demand Profile'!C148","v":99},18,500,419,0,266,"",0,null,144,"Day 144",{"$f":"'Demand Profile'!D148","v":70},141,0,71,534,459,"",0]
[null,145,"Day 145",{"$f":"'Demand Profile'!C149","v":38},419,0,381,0,291,"",0,null,145,"Day 145",{"$f":"'Demand Profile'!D149","v":105},71,534,500,0,434,"",0]
[null,146,"Day 146",{"$f":"'Demand Profile'!C150","v":51},381,0,330,0,262,"",0,null,146,"Day 146",{"$f":"'Demand Profile'!D150","v":126},500,0,374,0,405,"Yes",500]
[null,147,"Day 147",{"$f":"'Demand Profile'!C151","v":50},330,0,280,0,262,"",0,null,147,"Day 147",{"$f":"'Demand Profile'!D151","v":64},374,0,310,500,433,"",0]
[null,148,"Day 148",{"$f":"'Demand Profile'!C152","v":17},280,0,263,0,277,"Yes",500,null,148,"Day 148",{"$f":"'Demand Profile'!D152","v":44},310,0,266,500,459,"",0]
[null,149,"Day 149",{"$f":"'Demand Profile'!C153","v":64},263,0,199,500,262,"",0,null,149,"Day 149",{"$f":"'Demand Profile'!D153","v":82},266,0,184,500,471,"",0]
[null,150,"Day 150",{"$f":"'Demand Profile'!C154","v":15},199,0,184,500,328,"",0,null,150,"Day 150",{"$f":"'Demand Profile'!D154","v":38},184,0,146,500,540,"",0]
[null,151,"Day 151",{"$f":"'Demand Profile'!C155","v":31},184,0,153,500,302,"",0,null,151,"Day 151",{"$f":"'Demand Profile'!D155","v":80},146,0,66,500,476,"",0]
[null,152,"Day 152",{"$f":"'Demand Profile'!C156","v":63},153,0,90,500,326,"",0,null,152,"Day 152",{"$f":"'Demand Profile'!D156","v":97},66,500,469,0,497,"Yes",500]
[null,153,"Day 153",{"$f":"'Demand Profile'!C157","v":22},90,0,68,500,345,"",0,null,153,"Day 153",{"$f":"'Demand Profile'!D157","v":92},469,0,377,500,443,"",0]
[null,154,"Day 154",{"$f":"'Demand Profile'!C158","v":50},68,0,18,500,373,"",0,null,154,"Day 154",{"$f":"'Demand Profile'!D158","v":70},377,0,307,500,416,"",0]
[null,155,"Day 155",{"$f":"'Demand Profile'!C159","v":32},18,500,486,0,385,"",0,null,155,"Day 155",{"$f":"'Demand Profile'!D159","v":94},307,0,213,500,364,"",0]
[null,156,"Day 156",{"$f":"'Demand Profile'!C160","v":49},486,0,437,0,417,"",0,null,156,"Day 156",{"$f":"'Demand Profile'!D160","v":107},213,0,106,500,280,"",0]
[null,157,"Day 157",{"$f":"'Demand Profile'!C161","v":81},437,0,356,0,435,"Yes",500,null,157,"Day 157",{"$f":"'Demand Profile'!D161","v":16},106,0,90,500,364,"",0]
[null,158,"Day 158",{"$f":"'Demand Profile'!C162","v":5},356,0,351,500,458,"",0,null,158,"Day 158",{"$f":"'Demand Profile'!D162","v":118},90,500,472,0,336,"",0]
[null,159,"Day 159",{"$f":"'Demand Profile'!C163","v":87},351,0,264,500,439,"",0,null,159,"Day 159",{"$f":"'Demand Profile'!D163","v":38},472,0,434,0,438,"Yes",500]
[null,160,"Day 160",{"$f":"'Demand Profile'!C164","v":41},264,0,223,500,473,"",0,null,160,"Day 160",{"$f":"'Demand Profile'!D164","v":43},434,0,391,500,479,"",0]
[null,161,"Day 161",{"$f":"'Demand Profile'!C165","v":78},223,0,145,500,410,"",0,null,161,"Day 161",{"$f":"'Demand Profile'!D165","v":42},391,0,349,500,471,"",0]
[null,162,"Day 162",{"$f":"'Demand Profile'!C166","v":44},145,0,101,500,390,"",0,null,162,"Day 162",{"$f":"'Demand Profile'!D166","v":23},349,0,326,500,482,"",0]
[null,163,"Day 163",{"$f":"'Demand Profile'!C167","v":81},101,0,20,500,404,"",0,null,163,"Day 163",{"$f":"'Demand Profile'!D167","v":100},326,0,226,500,435,"",0]
[null,164,"Day 164",{"$f":"'Demand Profile'!C168","v":99},20,500,421,0,400,"",0,null,164,"Day 164",{"$f":"'Demand Profile'!D168","v":90},226,0,136,500,389,"",0]
[null,165,"Day 165",{"$f":"'Demand Profile'!C169","v":28},421,0,393,0,392,"",0,null,165,"Day 165",{"$f":"'Demand Profile'!D169","v":140},136,500,496,0,353,"",0]
[null,166,"Day 166",{"$f":"'Demand Profile'!C170","v":68},393,0,325,0,390,"Yes",500,null,166,"Day 166",{"$f":"'Demand Profile'!D170","v":84},496,0,412,0,353,"",0]
[null,167,"Day 167",{"$f":"'Demand Profile'!C171","v":75},325,0,250,500,402,"",0,null,167,"Day 167",{"$f":"'Demand Profile'!D171","v":34},412,0,378,0,425,"Yes",500]
[null,168,"Day 168",{"$f":"'Demand Profile'!C172","v":15},250,0,235,500,487,"",0,null,168,"Day 168",{"$f":"'Demand Profile'!D172","v":34},378,0,344,500,491,"",0]
[null,169,"Day 169",{"$f":"'Demand Profile'!C173","v":24},235,0,211,500,498,"",0,null,169,"Day 169",{"$f":"'Demand Profile'!D173","v":53},344,0,291,500,528,"",0]
[null,170,"Day 170",{"$f":"'Demand Profile'!C174","v":95},211,0,116,500,422,"",0,null,170,"Day 170",{"$f":"'Demand Profile'!D174","v":44},291,0,247,500,507,"",0]
[null,171,"Day 171",{"$f":"'Demand Profile'!C175","v":95},116,0,21,500,369,"",0,null,171,"Day 171",{"$f":"'Demand Profile'!D175","v":104},247,0,143,500,463,"",0]
[null,172,"Day 172",{"$f":"'Demand Profile'!C176","v":20},21,0,1,500,445,"",0,null,172,"Day 172",{"$f":"'Demand Profile'!D176","v":84},143,0,59,500,457,"",0]
[null,173,"Day 173",{"$f":"'Demand Profile'!C177","v":66},1,500,435,0,452,"Yes",500,null,173,"Day 173",{"$f":"'Demand Profile'!D177","v":106},59,500,453,0,425,"",0]
[null,174,"Day 174",{"$f":"'Demand Profile'!C178","v":87},435,0,348,500,414,"",0,null,174,"Day 174",{"$f":"'Demand Profile'!D178","v":100},453,0,353,0,432,"Yes",500]
[null,175,"Day 175",{"$f":"'Demand Profile'!C179","v":100},348,0,248,500,377,"",0,null,175,"Day 175",{"$f":"'Demand Profile'!D179","v":90},353,0,263,500,356,"",0]
[null,176,"Day 176",{"$f":"'Demand Profile'!C180","v":35},248,0,213,500,431,"",0,null,176,"Day 176",{"$f":"'Demand Profile'!D180","v":23},263,0,240,500,363,"",0]
[null,177,"Day 177",{"$f":"'Demand Profile'!C181","v":19},213,0,194,500,506,"",0,null,177,"Day 177",{"$f":"'Demand Profile'!D181","v":60},240,0,180,500,327,"",0]
[null,178,"Day 178",{"$f":"'Demand Profile'!C182","v":42},194,0,152,500,562,"",0,null,178,"Day 178",{"$f":"'Demand Profile'!D182","v":78},180,0,102,500,294,"",0]
[null,179,"Day 179",{"$f":"'Demand Profile'!C183","v":96},152,0,56,500,535,"",0,null,179,"Day 179",{"$f":"'Demand Profile'!D183","v":74},102,0,28,500,307,"",0]
[null,180,"Day 180",{"$f":"'Demand Profile'!C184","v":73},56,500,483,0,479,"",0,null,180,"Day 180",{"$f":"'Demand Profile'!D184","v":107},28,500,421,0,290,"",0]
[null,181,"Day 181",{"$f":"'Demand Profile'!C185","v":49},483,0,434,0,519,"Yes",500,null,181,"Day 181",{"$f":"'Demand Profile'!D185","v":14},421,0,407,0,329,"",0]
[null,182,"Day 182",{"$f":"'Demand Profile'!C186","v":63},434,0,371,500,496,"",0,null,182,"Day 182",{"$f":"'Demand Profile'!D186","v":30},407,0,377,0,376,"",0]
[null,183,"Day 183",{"$f":"'Demand Profile'!C187","v":89},371,0,282,500,436,"",0,null,183,"Day 183",{"$f":"'Demand Profile'!D187","v":24},377,0,353,0,458,"Yes",500]
[null,184,"Day 184",{"$f":"'Demand Profile'!C188","v":94},282,0,188,500,416,"",0,null,184,"Day 184",{"$f":"'Demand Profile'!D188","v":45},353,0,308,500,486,"",0]
[null,185,"Day 185",{"$f":"'Demand Profile'!C189","v":98},188,0,90,500,360,"",0,null,185,"Day 185",{"$f":"'Demand Profile'!D189","v":87},308,0,221,500,424,"",0]
[null,186,"Day 186",{"$f":"'Demand Profile'!C190","v":69},90,0,21,500,357,"",0,null,186,"Day 186",{"$f":"'Demand Profile'!D190","v":90},221,0,131,500,445,"",0]
[null,187,"Day 187",{"$f":"'Demand Profile'!C191","v":17},21,0,4,500,375,"",0,null,187,"Day 187",{"$f":"'Demand Profile'!D191","v":53},131,0,78,500,415,"",0]
[null,188,"Day 188",{"$f":"'Demand Profile'!C192","v":89},4,500,415,0,334,"",0,null,188,"Day 188",{"$f":"'Demand Profile'!D192","v":77},78,0,1,500,359,"",0]
[null,189,"Day 189",{"$f":"'Demand Profile'!C193","v":40},415,0,375,0,304,"",0,null,189,"Day 189",{"$f":"'Demand Profile'!D193","v":106},1,500,395,0,306,"",0]
[null,190,"Day 190",{"$f":"'Demand Profile'!C194","v":29},375,0,346,0,283,"",0,null,190,"Day 190",{"$f":"'Demand Profile'!D194","v":73},395,0,322,0,352,"Yes",500]
[null,191,"Day 191",{"$f":"'Demand Profile'!C195","v":74},346,0,272,0,241,"",0,null,191,"Day 191",{"$f":"'Demand Profile'!D195","v":25},322,0,297,500,419,"",0]
[null,192,"Day 192",{"$f":"'Demand Profile'!C196","v":42},272,0,230,0,243,"Yes",500,null,192,"Day 192",{"$f":"'Demand Profile'!D196","v":111},297,0,186,500,437,"",0]
[null,193,"Day 193",{"$f":"'Demand Profile'!C197","v":66},230,{"$f":"IF(B208<=LT_Store1,0,OFFSET(K208,-1*LT_Store1,0,1,1))","v":0},164,{"$f":"SUM(OFFSET(K208,-1,0,-1*(LT_Store1-1),1))","v":500},{"$f":"SUM(OFFSET(D209,0,0,LT_Store1,1))","v":237},"",{"$f":"IF(J208=\"Yes\",MAX(I208-G208,MOQ),0)","v":0},null,193,"Day 193",{"$f":"'Demand Profile'!D197","v":23},186,{"$f":"IF(M208<=LT_Store2,0,OFFSET(V208,-1*LT_Store2,0,1,1))","v":0},163,{"$f":"SUM(OFFSET(V208,-1,0,-1*(LT_Store2-1),1))","v":500},{"$f":"SUM(OFFSET(O209,0,0,LT_Store2,1))","v":432},"",{"$f":"IF(U208=\"Yes\",MAX(T208-R208,MOQ),0)","v":0}]
[null,194,"Day 194",{"$f":"'Demand Profile'!C198","v":35},164,0,{"$f":"E209+F209-D209","v":129},500,247,{"$f":"IF(I209<G209+H209,\"\",\"Yes\")","v":""},0,null,194,"Day 194",{"$f":"'Demand Profile'!D198","v":21},163,0,142,500,522,"",0]
[null,195,"Day 195",{"$f":"'Demand Profile'!C199","v":48},{"$f":"G209","v":129},0,81,500,250,"",0,null,195,"Day 195",{"$f":"'Demand Profile'!D199","v":53},{"$f":"R209","v":142},0,89,500,595,"Yes",506]
[null,196,"Day 196",{"$f":"'Demand Profile'!C200","v":10},81,0,71,500,254,"",0,null,196,"Day 196",{"$f":"'Demand Profile'!D200","v":119},89,500,470,506,511,"",0]
[null,197,"Day 197",{"$f":"'Demand Profile'!C201","v":8},71,0,63,500,277,"",0,null,197,"Day 197",{"$f":"'Demand Profile'!D201","v":92},470,0,{"$f":"P212+Q212-O212","v":378},506,431,{"$f":"IF(T212<R212+S212,\"\",\"Yes\")","v":""},0]
[null,198,"Day 198",{"$f":"'Demand Profile'!C202","v":32},63,0,31,500,333,"",0,null,198,"Day 198",{"$f":"'Demand Profile'!D202","v":129},378,0,249,506,315,"",0]
[null,199,"Day 199",{"$f":"'Demand Profile'!C203","v":44},31,500,487,0,343,"",0,null,199,"Day 199",{"$f":"'Demand Profile'!D203","v":18},249,0,231,506,356,"",0]
[null,200,"Day 200",{"$f":"'Demand Profile'!C204","v":60},487,0,427,0,309,"",0,null,200,"Day 200",{"$f":"'Demand Profile'!D204","v":111},231,0,120,506,355,"",0]
[null,201,"Day 201",{"$f":"'Demand Profile'!C205","v":45},427,0,382,0,336,"",0,null,201,"Day 201",{"$f":"'Demand Profile'!D205","v":126},120,506,500,0,247,"",0]
[null,202,"Day 202",{"$f":"'Demand Profile'!C206","v":51},382,0,331,0,306,"",0,null,202,"Day 202",{"$f":"'Demand Profile'!D206","v":35},500,0,465,0,233,"",0]
[null,203,"Day 203",{"$f":"'Demand Profile'!C207","v":14},331,0,317,0,380,"Yes",500,null,203,"Day 203",{"$f":"'Demand Profile'!D207","v":12},465,0,453,0,246,"",0]
[null,204,"Day 204",{"$f":"'Demand Profile'!C208","v":31},317,0,286,500,410,"",0,null,204,"Day 204",{"$f":"'Demand Profile'!D208","v":13},453,0,440,0,321,"",0]
[null,205,"Day 205",{"$f":"'Demand Profile'!C209","v":88},286,0,198,500,417,"",0,null,205,"Day 205",{"$f":"'Demand Profile'!D209","v":59},440,0,381,0,366,"",0]
[null,206,"Day 206",{"$f":"'Demand Profile'!C210","v":54},198,0,144,500,449,"",0,null,206,"Day 206",{"$f":"'Demand Profile'!D210","v":110},381,0,271,0,358,"Yes",500]
[null,207,"Day 207",{"$f":"'Demand Profile'!C211","v":26},144,0,118,500,515,"",0,null,207,"Day 207",{"$f":"'Demand Profile'!D211","v":18},271,0,253,500,406,"",0]
[null,208,"Day 208",{"$f":"'Demand Profile'!C212","v":72},118,0,46,500,524,"",0,null,208,"Day 208",{"$f":"'Demand Profile'!D212","v":21},253,0,232,500,447,"",0]
[null,209,"Day 209",{"$f":"'Demand Profile'!C213","v":21},46,0,25,500,525,"Yes",500,null,209,"Day 209",{"$f":"'Demand Profile'!D213","v":25},232,0,207,500,439,"",0]
[null,210,"Day 210",{"$f":"'Demand Profile'!C214","v":88},25,500,437,500,446,"",0,null,210,"Day 210",{"$f":"'Demand Profile'!D214","v":88},207,0,119,500,467,"",0]
[null,211,"Day 211",{"$f":"'Demand Profile'!C215","v":61},437,0,376,500,420,"",0,null,211,"Day 211",{"$f":"'Demand Profile'!D215","v":104},119,0,15,500,434,"",0]
[null,212,"Day 212",{"$f":"'Demand Profile'!C216","v":95},376,0,281,500,391,"",0,null,212,"Day 212",{"$f":"'Demand Profile'!D216","v":102},15,500,413,0,466,"Yes",500]
[null,213,"Day 213",{"$f":"'Demand Profile'!C217","v":86},281,0,195,500,379,"",0,null,213,"Day 213",{"$f":"'Demand Profile'!D217","v":66},413,0,347,500,534,"",0]
[null,214,"Day 214",{"$f":"'Demand Profile'!C218","v":92},195,0,103,500,342,"",0,null,214,"Day 214",{"$f":"'Demand Profile'!D218","v":62},347,0,285,500,611,"",0]
[null,215,"Day 215",{"$f":"'Demand Profile'!C219","v":81},103,0,22,500,296,"",0,null,215,"Day 215",{"$f":"'Demand Profile'!D219","v":17},285,0,268,500,718,"",0]
[null,216,"Day 216",{"$f":"'Demand Profile'!C220","v":22},22,500,500,0,363,"",0,null,216,"Day 216",{"$f":"'Demand Profile'!D220","v":116},268,0,152,500,691,"Yes",539]
[null,217,"Day 217",{"$f":"'Demand Profile'!C221","v":9},500,0,491,0,404,"",0,null,217,"Day 217",{"$f":"'Demand Profile'!D221","v":71},152,0,81,1039,756,"",0]
[null,218,"Day 218",{"$f":"'Demand Profile'!C222","v":35},491,0,456,0,443,"",0,null,218,"Day 218",{"$f":"'Demand Profile'!D222","v":134},81,500,447,539,648,"",0]
[null,219,"Day 219",{"$f":"'Demand Profile'!C223","v":66},456,0,390,0,424,"Yes",500,null,219,"Day 219",{"$f":"'Demand Profile'!D223","v":134},447,0,313,539,596,"",0]
[null,220,"Day 220",{"$f":"'Demand Profile'!C224","v":74},390,0,316,500,370,"",0,null,220,"Day 220",{"$f":"'Demand Profile'!D224","v":139},313,0,174,539,554,"",0]
[null,221,"Day 221",{"$f":"'Demand Profile'!C225","v":55},316,0,261,500,410,"",0,null,221,"Day 221",{"$f":"'Demand Profile'!D225","v":124},174,0,50,539,448,"",0]
[null,222,"Day 222",{"$f":"'Demand Profile'!C226","v":35},261,0,226,500,445,"",0,null,222,"Day 222",{"$f":"'Demand Profile'!D226","v":89},50,539,500,0,393,"",0]
[null,223,"Day 223",{"$f":"'Demand Profile'!C227","v":89},226,0,137,500,437,"",0,null,223,"Day 223",{"$f":"'Demand Profile'!D227","v":136},500,0,364,0,301,"",0]
[null,224,"Day 224",{"$f":"'Demand Profile'!C228","v":50},137,0,87,500,410,"",0,null,224,"Day 224",{"$f":"'Demand Profile'!D228","v":26},364,0,338,0,289,"",0]
[null,225,"Day 225",{"$f":"'Demand Profile'!C229","v":74},87,0,13,500,402,"",0,null,225,"Day 225",{"$f":"'Demand Profile'!D229","v":82},338,0,256,0,285,"Yes",500]
[null,226,"Day 226",{"$f":"'Demand Profile'!C230","v":47},13,500,466,0,432,"",0,null,226,"Day 226",{"$f":"'Demand Profile'!D230","v":97},256,0,159,500,277,"",0]
[null,227,"Day 227",{"$f":"'Demand Profile'!C231","v":20},466,0,446,0,470,"Yes",500,null,227,"Day 227",{"$f":"'Demand Profile'!D231","v":18},159,0,141,500,381,"",0]
[null,228,"Day 228",{"$f":"'Demand Profile'!C232","v":95},446,0,351,500,408,"",0,null,228,"Day 228",{"$f":"'Demand Profile'!D232","v":34},141,0,107,500,404,"",0]
[null,229,"Day 229",{"$f":"'Demand Profile'!C233","v":70},351,0,281,500,433,"",0,null,229,"Day 229",{"$f":"'Demand Profile'!D233","v":44},107,0,63,500,390,"",0]
[null,230,"Day 230",{"$f":"'Demand Profile'!C234","v":81},281,0,200,500,379,"",0,null,230,"Day 230",{"$f":"'Demand Profile'!D234","v":14},63,0,49,500,509,"",0]
[null,231,"Day 231",{"$f":"'Demand Profile'!C235","v":23},200,0,177,500,404,"",0,null,231,"Day 231",{"$f":"'Demand Profile'!D235","v":78},49,500,471,0,554,"Yes",500]
[null,232,"Day 232",{"$f":"'Demand Profile'!C236","v":66},177,0,111,500,342,"",0,null,232,"Day 232",{"$f":"'Demand Profile'!D236","v":89},471,0,382,500,509,"",0]
[null,233,"Day 233",{"$f":"'Demand Profile'!C237","v":77},111,0,34,500,274,"",0,null,233,"Day 233",{"$f":"'Demand Profile'!D237","v":122},382,0,260,500,463,"",0]
[null,234,"Day 234",{"$f":"'Demand Profile'!C238","v":58},34,500,476,0,222,"",0,null,234,"Day 234",{"$f":"'Demand Profile'!D238","v":57},260,0,203,500,511,"",0]
[null,235,"Day 235",{"$f":"'Demand Profile'!C239","v":33},476,0,443,0,202,"",0,null,235,"Day 235",{"$f":"'Demand Profile'!D239","v":30},203,0,173,500,599,"",0]
[null,236,"Day 236",{"$f":"'Demand Profile'!C240","v":95},443,0,348,0,163,"",0,null,236,"Day 236",{"$f":"'Demand Profile'!D240","v":133},173,0,40,500,579,"Yes",539]
[null,237,"Day 237",{"$f":"'Demand Profile'!C241","v":27},348,0,321,0,228,"",0,null,237,"Day 237",{"$f":"'Demand Profile'!D241","v":123},40,500,417,539,542,"",0]
[null,238,"Day 238",{"$f":"'Demand Profile'!C242","v":48},321,0,273,0,184,"",0,null,238,"Day 238",{"$f":"'Demand Profile'!D242","v":44},417,0,373,539,554,"",0]
[null,239,"Day 239",{"$f":"'Demand Profile'!C243","v":4},273,0,269,0,220,"",0,null,239,"Day 239",{"$f":"'Demand Profile'!D243","v":76},373,0,297,539,558,"",0]
[null,240,"Day 240",{"$f":"'Demand Profile'!C244","v":9},269,0,260,0,238,"",0,null,240,"Day 240",{"$f":"'Demand Profile'!D244","v":105},297,0,192,539,567,"",0]
[null,241,"Day 241",{"$f":"'Demand Profile'!C245","v":6},260,0,254,0,282,"Yes",500,null,241,"Day 241",{"$f":"'Demand Profile'!D245","v":118},192,0,74,539,525,"",0]
[null,242,"Day 242",{"$f":"'Demand Profile'!C246","v":13},254,0,241,500,282,"",0,null,242,"Day 242",{"$f":"'Demand Profile'!D246","v":113},74,539,500,0,486,"",0]
[null,243,"Day 243",{"$f":"'Demand Profile'!C247","v":56},241,0,185,500,245,"",0,null,243,"Day 243",{"$f":"'Demand Profile'!D247","v":86},500,0,414,0,412,"",0]
[null,244,"Day 244",{"$f":"'Demand Profile'!C248","v":92},185,0,93,500,155,"",0,null,244,"Day 244",{"$f":"'Demand Profile'!D248","v":56},414,0,358,0,386,"Yes",500]
[null,245,"Day 245",{"$f":"'Demand Profile'!C249","v":4},93,0,89,500,171,"",0,null,245,"Day 245",{"$f":"'Demand Profile'!D249","v":80},358,0,278,500,345,"",0]
[null,246,"Day 246",{"$f":"'Demand Profile'!C250","v":40},89,0,49,500,197,"",0,null,246,"Day 246",{"$f":"'Demand Profile'!D250","v":114},278,0,164,500,323,"",0]
[null,247,"Day 247",{"$f":"'Demand Profile'!C251","v":27},49,0,22,500,269,"",0,null,247,"Day 247",{"$f":"'Demand Profile'!D251","v":76},164,0,88,500,355,"",0]
[null,248,"Day 248",{"$f":"'Demand Profile'!C252","v":50},22,500,472,0,226,"",0,null,248,"Day 248",{"$f":"'Demand Profile'!D252","v":74},88,0,14,500,397,"",0]
[null,249,"Day 249",{"$f":"'Demand Profile'!C253","v":13},472,0,459,0,262,"",0,null,249,"Day 249",{"$f":"'Demand Profile'!D253","v":12},14,0,2,500,523,"Yes",521]
[null,250,"Day 250",{"$f":"'Demand Profile'!C254","v":19},459,0,440,0,289,"",0,null,250,"Day 250",{"$f":"'Demand Profile'!D254","v":30},2,500,472,521,552,"",0]
[null,251,"Day 251",{"$f":"'Demand Profile'!C255","v":2},440,0,438,0,303,"",0,null,251,"Day 251",{"$f":"'Demand Profile'!D255","v":39},472,0,433,521,555,"",0]
[null,252,"Day 252",{"$f":"'Demand Profile'!C256","v":20},438,0,418,0,300,"",0,null,252,"Day 252",{"$f":"'Demand Profile'!D256","v":92},433,0,341,521,587,"",0]
[null,253,"Day 253",{"$f":"'Demand Profile'!C257","v":66},418,0,352,0,318,"",0,null,253,"Day 253",{"$f":"'Demand Profile'!D257","v":108},341,0,233,521,518,"",0]
[null,254,"Day 254",{"$f":"'Demand Profile'!C258","v":99},352,0,253,0,226,"",0,null,254,"Day 254",{"$f":"'Demand Profile'!D258","v":116},233,0,117,521,514,"",0]
[null,255,"Day 255",{"$f":"'Demand Profile'!C259","v":7},253,0,246,0,258,"Yes",500,null,255,"Day 255",{"$f":"'Demand Profile'!D259","v":138},117,521,500,0,482,"",0]
[null,256,"Day 256",{"$f":"'Demand Profile'!C260","v":49},246,0,197,500,264,"",0,null,256,"Day 256",{"$f":"'Demand Profile'!D260","v":59},500,0,441,0,530,"Yes",500]
[null,257,"Day 257",{"$f":"'Demand Profile'!C261","v":46},197,{"$f":"IF(B272<=LT_Store1,0,OFFSET(K272,-1*LT_Store1,0,1,1))","v":0},151,{"$f":"SUM(OFFSET(K272,-1,0,-1*(LT_Store1-1),1))","v":500},{"$f":"SUM(OFFSET(D273,0,0,LT_Store1,1))","v":231},"",{"$f":"IF(J272=\"Yes\",MAX(I272-G272,MOQ),0)","v":0},null,257,"Day 257",{"$f":"'Demand Profile'!D261","v":42},441,{"$f":"IF(M272<=LT_Store2,0,OFFSET(V272,-1*LT_Store2,0,1,1))","v":0},399,{"$f":"SUM(OFFSET(V272,-1,0,-1*(LT_Store2-1),1))","v":500},{"$f":"SUM(OFFSET(O273,0,0,LT_Store2,1))","v":592},"",{"$f":"IF(U272=\"Yes\",MAX(T272-R272,MOQ),0)","v":0}]
[null,258,"Day 258",{"$f":"'Demand Profile'!C262","v":16},151,0,{"$f":"E273+F273-D273","v":135},500,251,{"$f":"IF(I273<G273+H273,\"\",\"Yes\")","v":""},0,null,258,"Day 258",{"$f":"'Demand Profile'!D262","v":124},399,0,275,500,484,"",0]
[null,259,"Day 259",{"$f":"'Demand Profile'!C263","v":17},{"$f":"G273","v":135},0,118,500,321,"",0,null,259,"Day 259",{"$f":"'Demand Profile'!D263","v":39},{"$f":"R273","v":275},0,236,500,465,"",0]
[null,260,"Day 260",{"$f":"'Demand Profile'!C264","v":84},118,0,34,500,335,"",0,null,260,"Day 260",{"$f":"'Demand Profile'!D264","v":112},236,0,124,500,415,"",0]
[null,261,"Day 261",{"$f":"'Demand Profile'!C265","v":7},34,0,27,500,394,"",0,null,261,"Day 261",{"$f":"'Demand Profile'!D265","v":106},124,0,{"$f":"P276+Q276-O276","v":18},500,381,{"$f":"IF(T276<R276+S276,\"\",\"Yes\")","v":""},0]
[null,262,"Day 262",{"$f":"'Demand Profile'!C266","v":39},27,500,488,0,453,"",0,null,262,"Day 262",{"$f":"'Demand Profile'!D266","v":107},18,500,411,0,310,"",0]
[null,263,"Day 263",{"$f":"'Demand Profile'!C267","v":55},488,0,433,0,465,"Yes",500,null,263,"Day 263",{"$f":"'Demand Profile'!D267","v":104},411,0,307,0,300,"",0]
[null,264,"Day 264",{"$f":"'Demand Profile'!C268","v":13},433,0,420,500,472,"",0,null,264,"Day 264",{"$f":"'Demand Profile'!D268","v":16},307,0,291,0,416,"Yes",500]
[null,265,"Day 265",{"$f":"'Demand Profile'!C269","v":36},420,0,384,500,530,"",0,null,265,"Day 265",{"$f":"'Demand Profile'!D269","v":20},291,0,271,500,427,"",0]
[null,266,"Day 266",{"$f":"'Demand Profile'!C270","v":87},384,0,297,500,478,"",0,null,266,"Day 266",{"$f":"'Demand Profile'!D270","v":62},271,0,209,500,393,"",0]
[null,267,"Day 267",{"$f":"'Demand Profile'!C271","v":98},297,0,199,500,401,"",0,null,267,"Day 267",{"$f":"'Demand Profile'!D271","v":72},209,0,137,500,415,"",0]
[null,268,"Day 268",{"$f":"'Demand Profile'!C272","v":66},199,0,133,500,416,"",0,null,268,"Day 268",{"$f":"'Demand Profile'!D272","v":36},137,0,101,500,438,"",0]
[null,269,"Day 269",{"$f":"'Demand Profile'!C273","v":98},133,0,35,500,384,"",0,null,269,"Day 269",{"$f":"'Demand Profile'!D273","v":94},101,0,7,500,451,"",0]
[null,270,"Day 270",{"$f":"'Demand Profile'!C274","v":67},35,500,468,0,408,"",0,null,270,"Day 270",{"$f":"'Demand Profile'!D274","v":132},7,500,375,0,394,"Yes",500]
[null,271,"Day 271",{"$f":"'Demand Profile'!C275","v":20},468,0,448,0,464,"Yes",500,null,271,"Day 271",{"$f":"'Demand Profile'!D275","v":31},375,0,344,500,441,"",0]
[null,272,"Day 272",{"$f":"'Demand Profile'!C276","v":94},448,0,354,500,404,"",0,null,272,"Day 272",{"$f":"'Demand Profile'!D276","v":28},344,0,316,500,496,"",0]
[null,273,"Day 273",{"$f":"'Demand Profile'!C277","v":35},354,0,319,500,467,"",0,null,273,"Day 273",{"$f":"'Demand Profile'!D277","v":94},316,0,222,500,483,"",0]
[null,274,"Day 274",{"$f":"'Demand Profile'!C278","v":21},319,0,298,500,460,"",0,null,274,"Day 274",{"$f":"'Demand Profile'!D278","v":59},222,0,163,500,453,"",0]
[null,275,"Day 275",{"$f":"'Demand Profile'!C279","v":81},298,0,217,500,433,"",0,null,275,"Day 275",{"$f":"'Demand Profile'!D279","v":107},163,0,56,500,463,"",0]
[null,276,"Day 276",{"$f":"'Demand Profile'!C280","v":66},217,0,151,500,464,"",0,null,276,"Day 276",{"$f":"'Demand Profile'!D280","v":75},56,500,481,0,443,"",0]
[null,277,"Day 277",{"$f":"'Demand Profile'!C281","v":91},151,0,60,500,378,"",0,null,277,"Day 277",{"$f":"'Demand Profile'!D281","v":78},481,0,403,0,381,"",0]
[null,278,"Day 278",{"$f":"'Demand Profile'!C282","v":76},60,500,484,0,358,"",0,null,278,"Day 278",{"$f":"'Demand Profile'!D282","v":83},403,0,320,0,423,"Yes",500]
[null,279,"Day 279",{"$f":"'Demand Profile'!C283","v":34},484,0,450,0,370,"",0,null,279,"Day 279",{"$f":"'Demand Profile'!D283","v":81},320,0,239,500,371,"",0]
[null,280,"Day 280",{"$f":"'Demand Profile'!C284","v":98},450,0,352,0,352,"Yes",500,null,280,"Day 280",{"$f":"'Demand Profile'!D284","v":29},239,0,210,500,419,"",0]
[null,281,"Day 281",{"$f":"'Demand Profile'!C285","v":14},352,0,338,500,432,"",0,null,281,"Day 281",{"$f":"'Demand Profile'!D285","v":117},210,0,93,500,316,"",0]
[null,282,"Day 282",{"$f":"'Demand Profile'!C286","v":54},338,0,284,500,463,"",0,null,282,"Day 282",{"$f":"'Demand Profile'!D286","v":55},93,0,38,500,319,"",0]
[null,283,"Day 283",{"$f":"'Demand Profile'!C287","v":97},284,0,187,500,421,"",0,null,283,"Day 283",{"$f":"'Demand Profile'!D287","v":16},38,0,22,500,351,"",0]
[null,284,"Day 284",{"$f":"'Demand Profile'!C288","v":5},187,0,182,500,491,"",0,null,284,"Day 284",{"$f":"'Demand Profile'!D288","v":125},22,500,397,0,355,"",0]
[null,285,"Day 285",{"$f":"'Demand Profile'!C289","v":56},182,0,126,500,512,"",0,null,285,"Day 285",{"$f":"'Demand Profile'!D289","v":29},397,0,368,0,397,"Yes",500]
[null,286,"Day 286",{"$f":"'Demand Profile'!C290","v":46},126,0,80,500,487,"",0,null,286,"Day 286",{"$f":"'Demand Profile'!D290","v":77},368,0,291,500,458,"",0]
[null,287,"Day 287",{"$f":"'Demand Profile'!C291","v":80},80,500,500,0,427,"",0,null,287,"Day 287",{"$f":"'Demand Profile'!D291","v":14},291,0,277,500,539,"",0]
[null,288,"Day 288",{"$f":"'Demand Profile'!C292","v":94},500,0,406,0,403,"",0,null,288,"Day 288",{"$f":"'Demand Profile'!D292","v":58},277,0,219,500,513,"",0]
[null,289,"Day 289",{"$f":"'Demand Profile'!C293","v":85},406,0,321,0,327,"Yes",500,null,289,"Day 289",{"$f":"'Demand Profile'!D293","v":48},219,0,171,500,478,"",0]
[null,290,"Day 290",{"$f":"'Demand Profile'!C294","v":55},321,0,266,500,308,"",0,null,290,"Day 290",{"$f":"'Demand Profile'!D294","v":129},171,0,42,500,487,"",0]
[null,291,"Day 291",{"$f":"'Demand Profile'!C295","v":75},266,0,191,500,239,"",0,null,291,"Day 291",{"$f":"'Demand Profile'!D295","v":71},42,500,471,0,536,"Yes",500]
[null,292,"Day 292",{"$f":"'Demand Profile'!C296","v":77},191,0,114,500,211,"",0,null,292,"Day 292",{"$f":"'Demand Profile'!D296","v":138},471,0,333,500,432,"",0]
[null,293,"Day 293",{"$f":"'Demand Profile'!C297","v":21},114,0,93,500,197,"",0,null,293,"Day 293",{"$f":"'Demand Profile'!D297","v":95},333,0,238,500,377,"",0]
[null,294,"Day 294",{"$f":"'Demand Profile'!C298","v":20},93,0,73,500,269,"",0,null,294,"Day 294",{"$f":"'Demand Profile'!D298","v":32},238,0,206,500,429,"",0]
[null,295,"Day 295",{"$f":"'Demand Profile'!C299","v":70},73,0,3,500,204,"",0,null,295,"Day 295",{"$f":"'Demand Profile'!D299","v":13},206,0,193,500,514,"",0]
[null,296,"Day 296",{"$f":"'Demand Profile'!C300","v":9},3,500,494,0,200,"",0,null,296,"Day 296",{"$f":"'Demand Profile'!D300","v":138},193,0,55,500,504,"",0]
[null,297,"Day 297",{"$f":"'Demand Profile'!C301","v":36},494,0,458,0,173,"",0,null,297,"Day 297",{"$f":"'Demand Profile'!D301","v":120},55,500,435,0,426,"",0]
[null,298,"Day 298",{"$f":"'Demand Profile'!C302","v":6},458,0,452,0,263,"",0,null,298,"Day 298",{"$f":"'Demand Profile'!D302","v":34},435,0,401,0,405,"Yes",500]
[null,299,"Day 299",{"$f":"'Demand Profile'!C303","v":49},452,0,403,0,216,"",0,null,299,"Day 299",{"$f":"'Demand Profile'!D303","v":40},401,0,361,500,473,"",0]
[null,300,"Day 300",{"$f":"'Demand Profile'!C304","v":7},403,0,396,0,235,"",0,null,300,"Day 300",{"$f":"'Demand Profile'!D304","v":84},361,0,277,500,433,"",0]
[null,301,"Day 301",{"$f":"'Demand Profile'!C305","v":92},396,0,304,0,185,"",0,null,301,"Day 301",{"$f":"'Demand Profile'!D305","v":98},277,0,179,500,361,"",0]
[null,302,"Day 302",{"$f":"'Demand Profile'!C306","v":5},304,0,299,0,264,"",0,null,302,"Day 302",{"$f":"'Demand Profile'!D306","v":128},179,0,51,500,289,"",0]
[null,303,"Day 303",{"$f":"'Demand Profile'!C307","v":5},299,0,294,0,326,"Yes",500,null,303,"Day 303",{"$f":"'Demand Profile'!D307","v":42},51,0,9,500,378,"",0]
[null,304,"Day 304",{"$f":"'Demand Profile'!C308","v":9},294,0,285,500,399,"",0,null,304,"Day 304",{"$f":"'Demand Profile'!D308","v":13},9,500,496,0,492,"",0]
[null,305,"Day 305",{"$f":"'Demand Profile'!C309","v":96},285,0,189,500,364,"",0,null,305,"Day 305",{"$f":"'Demand Profile'!D309","v":108},496,0,388,0,439,"Yes",500]
[null,306,"Day 306",{"$f":"'Demand Profile'!C310","v":2},189,0,187,500,451,"",0,null,306,"Day 306",{"$f":"'Demand Profile'!D310","v":44},388,0,344,500,473,"",0]
[null,307,"Day 307",{"$f":"'Demand Profile'!C311","v":26},187,0,161,500,523,"",0,null,307,"Day 307",{"$f":"'Demand Profile'!D311","v":26},344,0,318,500,465,"",0]
[null,308,"Day 308",{"$f":"'Demand Profile'!C312","v":42},161,0,119,500,566,"",0,null,308,"Day 308",{"$f":"'Demand Profile'!D312","v":56},318,0,262,500,534,"",0]
[null,309,"Day 309",{"$f":"'Demand Profile'!C313","v":84},119,0,35,500,484,"",0,null,309,"Day 309",{"$f":"'Demand Profile'!D313","v":131},262,0,131,500,448,"",0]
[null,310,"Day 310",{"$f":"'Demand Profile'!C314","v":67},35,500,468,0,444,"",0,null,310,"Day 310",{"$f":"'Demand Profile'!D314","v":127},131,0,4,500,332,"",0]
[null,311,"Day 311",{"$f":"'Demand Profile'!C315","v":82},468,0,386,0,392,"Yes",500,null,311,"Day 311",{"$f":"'Demand Profile'!D315","v":55},4,500,449,0,329,"",0]
[null,312,"Day 312",{"$f":"'Demand Profile'!C316","v":61},386,0,325,500,339,"",0,null,312,"Day 312",{"$f":"'Demand Profile'!D316","v":78},449,0,371,0,280,"",0]
[null,313,"Day 313",{"$f":"'Demand Profile'!C317","v":89},325,0,236,500,343,"",0,null,313,"Day 313",{"$f":"'Demand Profile'!D317","v":18},371,0,353,0,349,"",0]
[null,314,"Day 314",{"$f":"'Demand Profile'!C318","v":98},236,0,138,500,307,"",0,null,314,"Day 314",{"$f":"'Demand Profile'!D318","v":125},353,0,228,0,296,"Yes",500]
[null,315,"Day 315",{"$f":"'Demand Profile'!C319","v":85},138,0,53,500,312,"",0,null,315,"Day 315",{"$f":"'Demand Profile'!D319","v":45},228,0,183,500,298,"",0]
[null,316,"Day 316",{"$f":"'Demand Profile'!C320","v":2},53,0,51,500,336,"",0,null,316,"Day 316",{"$f":"'Demand Profile'!D320","v":11},183,0,172,500,320,"",0]
[null,317,"Day 317",{"$f":"'Demand Profile'!C321","v":27},51,0,24,500,329,"",0,null,317,"Day 317",{"$f":"'Demand Profile'!D321","v":52},172,0,120,500,379,"",0]
[null,318,"Day 318",{"$f":"'Demand Profile'!C322","v":30},24,500,494,0,304,"",0,null,318,"Day 318",{"$f":"'Demand Profile'!D322","v":29},120,0,91,500,474,"",0]
[null,319,"Day 319",{"$f":"'Demand Profile'!C323","v":8},494,0,486,0,314,"",0,null,319,"Day 319",{"$f":"'Demand Profile'!D323","v":87},91,0,4,500,433,"",0]
[null,320,"Day 320",{"$f":"'Demand Profile'!C324","v":93},486,0,393,0,297,"",0,null,320,"Day 320",{"$f":"'Demand Profile'!D324","v":72},4,500,432,0,459,"Yes",500]
[null,321,"Day 321",{"$f":"'Demand Profile'!C325","v":62},393,{"$f":"IF(B336<=LT_Store1,0,OFFSET(K336,-1*LT_Store1,0,1,1))","v":0},331,{"$f":"SUM(OFFSET(K336,-1,0,-1*(LT_Store1-1),1))","v":0},{"$f":"SUM(OFFSET(D337,0,0,LT_Store1,1))","v":312},"",{"$f":"IF(J336=\"Yes\",MAX(I336-G336,MOQ),0)","v":0},null,321,"Day 321",{"$f":"'Demand Profile'!D325","v":47},432,{"$f":"IF(M336<=LT_Store2,0,OFFSET(V336,-1*LT_Store2,0,1,1))","v":0},385,{"$f":"SUM(OFFSET(V336,-1,0,-1*(LT_Store2-1),1))","v":500},{"$f":"SUM(OFFSET(O337,0,0,LT_Store2,1))","v":519},"",{"$f":"IF(U336=\"Yes\",MAX(T336-R336,MOQ),0)","v":0}]
[null,322,"Day 322",{"$f":"'Demand Profile'!C326","v":90},331,0,{"$f":"E337+F337-D337","v":241},0,322,{"$f":"IF(I337<G337+H337,\"\",\"Yes\")","v":"Yes"},500,null,322,"Day 322",{"$f":"'Demand Profile'!D326","v":33},385,0,352,500,594,"",0]
[null,323,"Day 323",{"$f":"'Demand Profile'!C327","v":26},{"$f":"G337","v":241},0,215,500,457,"",0,null,323,"Day 323",{"$f":"'Demand Profile'!D327","v":111},{"$f":"R337","v":352},0,241,500,495,"",0]
[null,324,"Day 324",{"$f":"'Demand Profile'!C328","v":20},215,0,195,500,546,"",0,null,324,"Day 324",{"$f":"'Demand Profile'!D328","v":124},241,0,117,500,460,"",0]
[null,325,"Day 325",{"$f":"'Demand Profile'!C329","v":5},195,0,190,500,683,"",0,null,325,"Day 325",{"$f":"'Demand Profile'!D329","v":46},117,0,{"$f":"P340+Q340-O340","v":71},500,649,{"$f":"IF(T340<R340+S340,\"\",\"Yes\")","v":"Yes"},578]
[null,326,"Day 326",{"$f":"'Demand Profile'!C330","v":18},190,0,172,500,766,"Yes",594,null,326,"Day 326",{"$f":"'Demand Profile'!D330","v":98},71,500,473,578,739,"",0]
[null,327,"Day 327",{"$f":"'Demand Profile'!C331","v":76},172,0,96,1094,781,"",0,null,327,"Day 327",{"$f":"'Demand Profile'!D331","v":107},473,0,366,578,773,"",0]
[null,328,"Day 328",{"$f":"'Demand Profile'!C332","v":77},96,0,19,1094,837,"",0,null,328,"Day 328",{"$f":"'Demand Profile'!D332","v":108},366,0,258,578,865,"Yes",607]
[null,329,"Day 329",{"$f":"'Demand Profile'!C333","v":100},19,500,419,594,825,"",0,null,329,"Day 329",{"$f":"'Demand Profile'!D333","v":12},258,0,246,1185,987,"",0]
[null,330,"Day 330",{"$f":"'Demand Profile'!C334","v":161},419,0,258,594,859,"Yes",601,null,330,"Day 330",{"$f":"'Demand Profile'!D334","v":89},246,0,157,1185,1090,"",0]
[null,331,"Day 331",{"$f":"'Demand Profile'!C335","v":109},258,0,149,1195,921,"",0,null,331,"Day 331",{"$f":"'Demand Profile'!D335","v":235},157,578,500,607,956,"",0]
[null,332,"Day 332",{"$f":"'Demand Profile'!C336","v":142},149,0,7,1195,844,"",0,null,332,"Day 332",{"$f":"'Demand Profile'!D336","v":188},500,0,312,607,889,"",0]
[null,333,"Day 333",{"$f":"'Demand Profile'!C337","v":101},7,594,500,601,845,"",0,null,333,"Day 333",{"$f":"'Demand Profile'!D337","v":141},312,0,171,607,870,"Yes",699]
[null,334,"Day 334",{"$f":"'Demand Profile'!C338","v":91},500,0,409,601,904,"",0,null,334,"Day 334",{"$f":"'Demand Profile'!D338","v":200},171,607,578,699,846,"",0]
[null,335,"Day 335",{"$f":"'Demand Profile'!C339","v":133},409,0,276,601,867,"",0,null,335,"Day 335",{"$f":"'Demand Profile'!D339","v":134},578,0,444,699,874,"",0]
[null,336,"Day 336",{"$f":"'Demand Profile'!C340","v":88},276,0,188,601,855,"Yes",667,null,336,"Day 336",{"$f":"'Demand Profile'!D340","v":192},444,0,252,699,872,"",0]
[null,337,"Day 337",{"$f":"'Demand Profile'!C341","v":195},188,601,594,667,723,"",0,null,337,"Day 337",{"$f":"'Demand Profile'!D341","v":101},252,0,151,699,1009,"Yes",858]
[null,338,"Day 338",{"$f":"'Demand Profile'!C342","v":171},594,0,423,667,716,"",0,null,338,"Day 338",{"$f":"'Demand Profile'!D342","v":121},151,0,30,1557,1012,"",0]
[null,339,"Day 339",{"$f":"'Demand Profile'!C343","v":65},423,0,358,667,813,"",0,null,339,"Day 339",{"$f":"'Demand Profile'!D343","v":122},30,699,607,858,1102,"",0]
[null,340,"Day 340",{"$f":"'Demand Profile'!C344","v":102},358,0,256,667,839,"",0,null,340,"Day 340",{"$f":"'Demand Profile'!D344","v":176},607,0,431,858,1129,"",0]
[null,341,"Day 341",{"$f":"'Demand Profile'!C345","v":150},256,0,106,667,781,"Yes",675,null,341,"Day 341",{"$f":"'Demand Profile'!D345","v":162},431,0,269,858,1087,"",0]
[null,342,"Day 342",{"$f":"'Demand Profile'!C346","v":96},106,0,10,1342,822,"",0,null,342,"Day 342",{"$f":"'Demand Profile'!D346","v":190},269,0,79,858,1051,"Yes",972]
[null,343,"Day 343",{"$f":"'Demand Profile'!C347","v":76},10,667,601,675,849,"",0,null,343,"Day 343",{"$f":"'Demand Profile'!D347","v":238},79,858,699,972,987,"",0]
[null,344,"Day 344",{"$f":"'Demand Profile'!C348","v":63},601,0,538,675,904,"",0,null,344,"Day 344",{"$f":"'Demand Profile'!D348","v":124},699,0,575,972,1002,"",0]
[null,345,"Day 345",{"$f":"'Demand Profile'!C349","v":164},538,0,374,675,841,"",0,null,345,"Day 345",{"$f":"'Demand Profile'!D349","v":212},575,0,363,972,969,"",0]
[null,346,"Day 346",{"$f":"'Demand Profile'!C350","v":162},374,0,212,675,812,"",0,null,346,"Day 346",{"$f":"'Demand Profile'!D350","v":203},363,0,160,972,869,"",0]
[null,347,"Day 347",{"$f":"'Demand Profile'!C351","v":128},212,0,84,675,773,"Yes",689,null,347,"Day 347",{"$f":"'Demand Profile'!D351","v":120},160,0,40,972,986,"",0]
[null,348,"Day 348",{"$f":"'Demand Profile'!C352","v":92},84,675,667,689,816,"",0,null,348,"Day 348",{"$f":"'Demand Profile'!D352","v":154},40,972,858,0,978,"Yes",500]
[null,349,"Day 349",{"$f":"'Demand Profile'!C353","v":137},667,0,530,689,863,"",0,null,349,"Day 349",{"$f":"'Demand Profile'!D353","v":174},858,0,684,500,976,"",0]
[null,350,"Day 350",{"$f":"'Demand Profile'!C354","v":103},530,0,427,689,943,"",0,null,350,"Day 350",{"$f":"'Demand Profile'!D354","v":139},684,0,545,500,951,"",0]
[null,351,"Day 351",{"$f":"'Demand Profile'!C355","v":118},427,0,309,689,979,"",0,null,351,"Day 351",{"$f":"'Demand Profile'!D355","v":179},545,0,366,500,875,"Yes",509]
[null,352,"Day 352",{"$f":"'Demand Profile'!C356","v":101},309,0,208,689,951,"Yes",743,null,352,"Day 352",{"$f":"'Demand Profile'!D356","v":103},366,0,263,1009,888,"",0]
[null,353,"Day 353",{"$f":"'Demand Profile'!C357","v":133},208,0,75,1432,883,"",0,null,353,"Day 353",{"$f":"'Demand Profile'!D357","v":237},263,0,26,1009,758,"",0]
[null,354,"Day 354",{"$f":"'Demand Profile'!C358","v":89},75,689,675,743,870,"",0,null,354,"Day 354",{"$f":"'Demand Profile'!D358","v":146},26,500,380,509,701,"",0]
[null,355,"Day 355",{"$f":"'Demand Profile'!C359","v":135},675,0,540,743,880,"",0,null,355,"Day 355",{"$f":"'Demand Profile'!D359","v":172},380,0,208,509,741,"Yes",533]
[null,356,"Day 356",{"$f":"'Demand Profile'!C360","v":184},540,0,356,743,827,"",0,null,356,"Day 356",{"$f":"'Demand Profile'!D360","v":114},208,0,94,1042,825,"",0]
[null,357,"Day 357",{"$f":"'Demand Profile'!C361","v":183},356,0,173,743,777,"",0,null,357,"Day 357",{"$f":"'Demand Profile'!D361","v":103},94,509,500,533,900,"",0]
[null,358,"Day 358",{"$f":"'Demand Profile'!C362","v":154},173,0,19,743,806,"Yes",787,null,358,"Day 358",{"$f":"'Demand Profile'!D362","v":116},500,0,384,533,1019,"Yes",635]
[null,359,"Day 359",{"$f":"'Demand Profile'!C363","v":73},19,743,689,787,733,"",0,null,359,"Day 359",{"$f":"'Demand Profile'!D363","v":107},384,0,277,1168,994,"",0]
[null,360,"Day 360",{"$f":"'Demand Profile'!C364","v":65},689,0,624,787,668,"",0,null,360,"Day 360",{"$f":"'Demand Profile'!D364","v":89},277,0,188,1168,905,"",0]
[null,361,"Day 361",{"$f":"'Demand Profile'!C365","v":76},624,0,548,787,592,"",0,null,361,"Day 361",{"$f":"'Demand Profile'!D365","v":212},188,533,509,635,693,"",0]
[null,362,"Day 362",{"$f":"'Demand Profile'!C366","v":145},548,0,403,787,447,"",0,null,362,"Day 362",{"$f":"'Demand Profile'!D366","v":198},509,0,311,635,495,"",0]
[null,363,"Day 363",{"$f":"'Demand Profile'!C367","v":131},403,0,272,787,316,"",0,null,363,"Day 363",{"$f":"'Demand Profile'!D367","v":178},311,0,133,635,317,"",0]
[null,364,"Day 364",{"$f":"'Demand Profile'!C368","v":133},272,0,139,787,183,"",0,null,364,"Day 364",{"$f":"'Demand Profile'!D368","v":235},133,635,533,0,82,"",0]
[null,365,"Day 365",{"$f":"'Demand Profile'!C369","v":183},139,787,743,0,0,"",0,null,365,"Day 365",{"$f":"'Demand Profile'!D369","v":82},533,0,451,0,0,"",0]

{"sheet":"Simulation Data","index":3,"n_rows":35,"n_cols":27,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,null,"Selected Day",{"$f":"Selected_Day","v":1}]
[]
[null,null,null,null,"Selected Store-->",{"$f":"Selected_Store","v":"Store 1"},null,null,null,null,null,null,"Store 1",null,null,null,null,null,null,null,"Store 2"]
[null,null,null,null,"S.N.","Day","Demand","Opening Stock","Order Placed","Stock Received","In-Transit",null,"S.N.","Day","Demand","Opening Stock","Order Placed","Stock Received","In-Transit",null,"S.N.","Day","Demand","Opening Stock","Order Placed","Stock Received","In-Transit"]
[null,null,null,null,1,{"$f":"IF(Selected_Day<=20,IF(E6<=Selected_Day,E6,\"\"),Selected_Day-(20-E6))","v":1},{"$f":"IF(Selected_Store=\"Store 1\",O6,W6)","v":100},{"$f":"IF(Selected_Store=\"Store 1\",P6,X6)","v":500},{"$f":"IF(Selected_Store=\"Store 1\",Q6,Y6)","v":500},{"$f":"IF(Selected_Store=\"Store 1\",R6,Z6)","v":{"$error":"#N/A"}},{"$f":"IF(Selected_Store=\"Store 1\",S6,AA6)","v":{"$error":"#N/A"}},null,1,{"$f":"F6","v":1},{"$f":"OFFSET(Working!$D$15,$F6,0,1,1)","v":100},{"$f":"OFFSET(Working!$E$15,$F6,0,1,1)","v":500},{"$f":"IF(OFFSET(Working!$K$15,$F6,0,1,1)=0,NA(),OFFSET(Working!$K$15,$F6,0,1,1))","v":500},{"$f":"IF(OFFSET(Working!$F$15,$F6,0,1,1)=0,NA(),OFFSET(Working!$F$15,$F6,0,1,1))","v":{"$error":"#N/A"}},{"$f":"IF(OFFSET(Working!$H$15,$F6,0,1,1)=0,NA(),OFFSET(Working!$H$15,$F6,0,1,1))","v":{"$error":"#N/A"}},null,1,{"$f":"F6","v":1},{"$f":"OFFSET(Working!$O$15,$F6,0,1,1)","v":105},{"$f":"OFFSET(Working!$P$15,$F6,0,1,1)","v":800},{"$f":"IF(OFFSET(Working!$V$15,$F6,0,1,1)=0,NA(),OFFSET(Working!$V$15,$F6,0,1,1))","v":{"$error":"#N/A"}},{"$f":"IF(OFFSET(Working!$Q$15,$F6,0,1,1)=0,NA(),OFFSET(Working!$Q$15,$F6,0,1,1))","v":{"$error":"#N/A"}},{"$f":"IF(OFFSET(Working!$S$15,$F6,0,1,1)=0,NA(),OFFSET(Working!$S$15,$F6,0,1,1))","v":{"$error":"#N/A"}}]
[null,null,null,null,2,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,2,{"$f":"F7","v":""},{"$f":"OFFSET(Working!$D$15,N7,0,1,1)","v":{"$error":"#VALUE!"}},{"$f":"OFFSET(Working!$E$15,$F7,0,1,1)","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$K$15,$F7,0,1,1)=0,NA(),OFFSET(Working!$K$15,$F7,0,1,1))","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$F$15,$F7,0,1,1)=0,NA(),OFFSET(Working!$F$15,$F7,0,1,1))","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$H$15,$F7,0,1,1)=0,NA(),OFFSET(Working!$H$15,$F7,0,1,1))","v":{"$error":"#VALUE!"}},null,2,{"$f":"F7","v":""},{"$f":"OFFSET(Working!$O$15,$F7,0,1,1)","v":{"$error":"#VALUE!"}},{"$f":"OFFSET(Working!$P$15,$F7,0,1,1)","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$V$15,$F7,0,1,1)=0,NA(),OFFSET(Working!$V$15,$F7,0,1,1))","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$Q$15,$F7,0,1,1)=0,NA(),OFFSET(Working!$Q$15,$F7,0,1,1))","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$S$15,$F7,0,1,1)=0,NA(),OFFSET(Working!$S$15,$F7,0,1,1))","v":{"$error":"#VALUE!"}}]
[null,null,null,null,3,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,3,"",{"$f":"OFFSET(Working!$D$15,N8,0,1,1)","v":{"$error":"#VALUE!"}},{"$f":"OFFSET(Working!$E$15,$F8,0,1,1)","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$K$15,$F8,0,1,1)=0,NA(),OFFSET(Working!$K$15,$F8,0,1,1))","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$F$15,$F8,0,1,1)=0,NA(),OFFSET(Working!$F$15,$F8,0,1,1))","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$H$15,$F8,0,1,1)=0,NA(),OFFSET(Working!$H$15,$F8,0,1,1))","v":{"$error":"#VALUE!"}},null,3,"",{"$f":"OFFSET(Working!$O$15,$F8,0,1,1)","v":{"$error":"#VALUE!"}},{"$f":"OFFSET(Working!$P$15,$F8,0,1,1)","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$V$15,$F8,0,1,1)=0,NA(),OFFSET(Working!$V$15,$F8,0,1,1))","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$Q$15,$F8,0,1,1)=0,NA(),OFFSET(Working!$Q$15,$F8,0,1,1))","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$S$15,$F8,0,1,1)=0,NA(),OFFSET(Working!$S$15,$F8,0,1,1))","v":{"$error":"#VALUE!"}}]
[null,null,null,null,4,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,4,"",{"$f":"OFFSET(Working!$D$15,N9,0,1,1)","v":{"$error":"#VALUE!"}},{"$f":"OFFSET(Working!$E$15,$F9,0,1,1)","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$K$15,$F9,0,1,1)=0,NA(),OFFSET(Working!$K$15,$F9,0,1,1))","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$F$15,$F9,0,1,1)=0,NA(),OFFSET(Working!$F$15,$F9,0,1,1))","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$H$15,$F9,0,1,1)=0,NA(),OFFSET(Working!$H$15,$F9,0,1,1))","v":{"$error":"#VALUE!"}},null,4,"",{"$f":"OFFSET(Working!$O$15,$F9,0,1,1)","v":{"$error":"#VALUE!"}},{"$f":"OFFSET(Working!$P$15,$F9,0,1,1)","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$V$15,$F9,0,1,1)=0,NA(),OFFSET(Working!$V$15,$F9,0,1,1))","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$Q$15,$F9,0,1,1)=0,NA(),OFFSET(Working!$Q$15,$F9,0,1,1))","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$S$15,$F9,0,1,1)=0,NA(),OFFSET(Working!$S$15,$F9,0,1,1))","v":{"$error":"#VALUE!"}}]
[null,null,null,null,5,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,5,"",{"$f":"OFFSET(Working!$D$15,N10,0,1,1)","v":{"$error":"#VALUE!"}},{"$f":"OFFSET(Working!$E$15,$F10,0,1,1)","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$K$15,$F10,0,1,1)=0,NA(),OFFSET(Working!$K$15,$F10,0,1,1))","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$F$15,$F10,0,1,1)=0,NA(),OFFSET(Working!$F$15,$F10,0,1,1))","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$H$15,$F10,0,1,1)=0,NA(),OFFSET(Working!$H$15,$F10,0,1,1))","v":{"$error":"#VALUE!"}},null,5,"",{"$f":"OFFSET(Working!$O$15,$F10,0,1,1)","v":{"$error":"#VALUE!"}},{"$f":"OFFSET(Working!$P$15,$F10,0,1,1)","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$V$15,$F10,0,1,1)=0,NA(),OFFSET(Working!$V$15,$F10,0,1,1))","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$Q$15,$F10,0,1,1)=0,NA(),OFFSET(Working!$Q$15,$F10,0,1,1))","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$S$15,$F10,0,1,1)=0,NA(),OFFSET(Working!$S$15,$F10,0,1,1))","v":{"$error":"#VALUE!"}}]
[null,null,null,null,6,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,6,"",{"$f":"OFFSET(Working!$D$15,N11,0,1,1)","v":{"$error":"#VALUE!"}},{"$f":"OFFSET(Working!$E$15,$F11,0,1,1)","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$K$15,$F11,0,1,1)=0,NA(),OFFSET(Working!$K$15,$F11,0,1,1))","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$F$15,$F11,0,1,1)=0,NA(),OFFSET(Working!$F$15,$F11,0,1,1))","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$H$15,$F11,0,1,1)=0,NA(),OFFSET(Working!$H$15,$F11,0,1,1))","v":{"$error":"#VALUE!"}},null,6,"",{"$f":"OFFSET(Working!$O$15,$F11,0,1,1)","v":{"$error":"#VALUE!"}},{"$f":"OFFSET(Working!$P$15,$F11,0,1,1)","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$V$15,$F11,0,1,1)=0,NA(),OFFSET(Working!$V$15,$F11,0,1,1))","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$Q$15,$F11,0,1,1)=0,NA(),OFFSET(Working!$Q$15,$F11,0,1,1))","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$S$15,$F11,0,1,1)=0,NA(),OFFSET(Working!$S$15,$F11,0,1,1))","v":{"$error":"#VALUE!"}}]
[null,null,null,null,7,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,7,"",{"$f":"OFFSET(Working!$D$15,N12,0,1,1)","v":{"$error":"#VALUE!"}},{"$f":"OFFSET(Working!$E$15,$F12,0,1,1)","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$K$15,$F12,0,1,1)=0,NA(),OFFSET(Working!$K$15,$F12,0,1,1))","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$F$15,$F12,0,1,1)=0,NA(),OFFSET(Working!$F$15,$F12,0,1,1))","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$H$15,$F12,0,1,1)=0,NA(),OFFSET(Working!$H$15,$F12,0,1,1))","v":{"$error":"#VALUE!"}},null,7,"",{"$f":"OFFSET(Working!$O$15,$F12,0,1,1)","v":{"$error":"#VALUE!"}},{"$f":"OFFSET(Working!$P$15,$F12,0,1,1)","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$V$15,$F12,0,1,1)=0,NA(),OFFSET(Working!$V$15,$F12,0,1,1))","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$Q$15,$F12,0,1,1)=0,NA(),OFFSET(Working!$Q$15,$F12,0,1,1))","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$S$15,$F12,0,1,1)=0,NA(),OFFSET(Working!$S$15,$F12,0,1,1))","v":{"$error":"#VALUE!"}}]
[null,null,null,null,8,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,8,"",{"$f":"OFFSET(Working!$D$15,N13,0,1,1)","v":{"$error":"#VALUE!"}},{"$f":"OFFSET(Working!$E$15,$F13,0,1,1)","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$K$15,$F13,0,1,1)=0,NA(),OFFSET(Working!$K$15,$F13,0,1,1))","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$F$15,$F13,0,1,1)=0,NA(),OFFSET(Working!$F$15,$F13,0,1,1))","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$H$15,$F13,0,1,1)=0,NA(),OFFSET(Working!$H$15,$F13,0,1,1))","v":{"$error":"#VALUE!"}},null,8,"",{"$f":"OFFSET(Working!$O$15,$F13,0,1,1)","v":{"$error":"#VALUE!"}},{"$f":"OFFSET(Working!$P$15,$F13,0,1,1)","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$V$15,$F13,0,1,1)=0,NA(),OFFSET(Working!$V$15,$F13,0,1,1))","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$Q$15,$F13,0,1,1)=0,NA(),OFFSET(Working!$Q$15,$F13,0,1,1))","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$S$15,$F13,0,1,1)=0,NA(),OFFSET(Working!$S$15,$F13,0,1,1))","v":{"$error":"#VALUE!"}}]
[null,null,null,null,9,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,9,"",{"$f":"OFFSET(Working!$D$15,N14,0,1,1)","v":{"$error":"#VALUE!"}},{"$f":"OFFSET(Working!$E$15,$F14,0,1,1)","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$K$15,$F14,0,1,1)=0,NA(),OFFSET(Working!$K$15,$F14,0,1,1))","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$F$15,$F14,0,1,1)=0,NA(),OFFSET(Working!$F$15,$F14,0,1,1))","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$H$15,$F14,0,1,1)=0,NA(),OFFSET(Working!$H$15,$F14,0,1,1))","v":{"$error":"#VALUE!"}},null,9,"",{"$f":"OFFSET(Working!$O$15,$F14,0,1,1)","v":{"$error":"#VALUE!"}},{"$f":"OFFSET(Working!$P$15,$F14,0,1,1)","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$V$15,$F14,0,1,1)=0,NA(),OFFSET(Working!$V$15,$F14,0,1,1))","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$Q$15,$F14,0,1,1)=0,NA(),OFFSET(Working!$Q$15,$F14,0,1,1))","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$S$15,$F14,0,1,1)=0,NA(),OFFSET(Working!$S$15,$F14,0,1,1))","v":{"$error":"#VALUE!"}}]
[null,null,null,null,10,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,10,"",{"$f":"OFFSET(Working!$D$15,N15,0,1,1)","v":{"$error":"#VALUE!"}},{"$f":"OFFSET(Working!$E$15,$F15,0,1,1)","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$K$15,$F15,0,1,1)=0,NA(),OFFSET(Working!$K$15,$F15,0,1,1))","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$F$15,$F15,0,1,1)=0,NA(),OFFSET(Working!$F$15,$F15,0,1,1))","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$H$15,$F15,0,1,1)=0,NA(),OFFSET(Working!$H$15,$F15,0,1,1))","v":{"$error":"#VALUE!"}},null,10,"",{"$f":"OFFSET(Working!$O$15,$F15,0,1,1)","v":{"$error":"#VALUE!"}},{"$f":"OFFSET(Working!$P$15,$F15,0,1,1)","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$V$15,$F15,0,1,1)=0,NA(),OFFSET(Working!$V$15,$F15,0,1,1))","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$Q$15,$F15,0,1,1)=0,NA(),OFFSET(Working!$Q$15,$F15,0,1,1))","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$S$15,$F15,0,1,1)=0,NA(),OFFSET(Working!$S$15,$F15,0,1,1))","v":{"$error":"#VALUE!"}}]
[null,null,null,null,11,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,11,"",{"$f":"OFFSET(Working!$D$15,N16,0,1,1)","v":{"$error":"#VALUE!"}},{"$f":"OFFSET(Working!$E$15,$F16,0,1,1)","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$K$15,$F16,0,1,1)=0,NA(),OFFSET(Working!$K$15,$F16,0,1,1))","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$F$15,$F16,0,1,1)=0,NA(),OFFSET(Working!$F$15,$F16,0,1,1))","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$H$15,$F16,0,1,1)=0,NA(),OFFSET(Working!$H$15,$F16,0,1,1))","v":{"$error":"#VALUE!"}},null,11,"",{"$f":"OFFSET(Working!$O$15,$F16,0,1,1)","v":{"$error":"#VALUE!"}},{"$f":"OFFSET(Working!$P$15,$F16,0,1,1)","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$V$15,$F16,0,1,1)=0,NA(),OFFSET(Working!$V$15,$F16,0,1,1))","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$Q$15,$F16,0,1,1)=0,NA(),OFFSET(Working!$Q$15,$F16,0,1,1))","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$S$15,$F16,0,1,1)=0,NA(),OFFSET(Working!$S$15,$F16,0,1,1))","v":{"$error":"#VALUE!"}}]
[null,null,null,null,12,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,12,"",{"$f":"OFFSET(Working!$D$15,N17,0,1,1)","v":{"$error":"#VALUE!"}},{"$f":"OFFSET(Working!$E$15,$F17,0,1,1)","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$K$15,$F17,0,1,1)=0,NA(),OFFSET(Working!$K$15,$F17,0,1,1))","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$F$15,$F17,0,1,1)=0,NA(),OFFSET(Working!$F$15,$F17,0,1,1))","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$H$15,$F17,0,1,1)=0,NA(),OFFSET(Working!$H$15,$F17,0,1,1))","v":{"$error":"#VALUE!"}},null,12,"",{"$f":"OFFSET(Working!$O$15,$F17,0,1,1)","v":{"$error":"#VALUE!"}},{"$f":"OFFSET(Working!$P$15,$F17,0,1,1)","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$V$15,$F17,0,1,1)=0,NA(),OFFSET(Working!$V$15,$F17,0,1,1))","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$Q$15,$F17,0,1,1)=0,NA(),OFFSET(Working!$Q$15,$F17,0,1,1))","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$S$15,$F17,0,1,1)=0,NA(),OFFSET(Working!$S$15,$F17,0,1,1))","v":{"$error":"#VALUE!"}}]
[null,null,null,null,13,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,13,"",{"$f":"OFFSET(Working!$D$15,N18,0,1,1)","v":{"$error":"#VALUE!"}},{"$f":"OFFSET(Working!$E$15,$F18,0,1,1)","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$K$15,$F18,0,1,1)=0,NA(),OFFSET(Working!$K$15,$F18,0,1,1))","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$F$15,$F18,0,1,1)=0,NA(),OFFSET(Working!$F$15,$F18,0,1,1))","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$H$15,$F18,0,1,1)=0,NA(),OFFSET(Working!$H$15,$F18,0,1,1))","v":{"$error":"#VALUE!"}},null,13,"",{"$f":"OFFSET(Working!$O$15,$F18,0,1,1)","v":{"$error":"#VALUE!"}},{"$f":"OFFSET(Working!$P$15,$F18,0,1,1)","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$V$15,$F18,0,1,1)=0,NA(),OFFSET(Working!$V$15,$F18,0,1,1))","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$Q$15,$F18,0,1,1)=0,NA(),OFFSET(Working!$Q$15,$F18,0,1,1))","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$S$15,$F18,0,1,1)=0,NA(),OFFSET(Working!$S$15,$F18,0,1,1))","v":{"$error":"#VALUE!"}}]
[null,null,null,null,14,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,14,"",{"$f":"OFFSET(Working!$D$15,N19,0,1,1)","v":{"$error":"#VALUE!"}},{"$f":"OFFSET(Working!$E$15,$F19,0,1,1)","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$K$15,$F19,0,1,1)=0,NA(),OFFSET(Working!$K$15,$F19,0,1,1))","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$F$15,$F19,0,1,1)=0,NA(),OFFSET(Working!$F$15,$F19,0,1,1))","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$H$15,$F19,0,1,1)=0,NA(),OFFSET(Working!$H$15,$F19,0,1,1))","v":{"$error":"#VALUE!"}},null,14,"",{"$f":"OFFSET(Working!$O$15,$F19,0,1,1)","v":{"$error":"#VALUE!"}},{"$f":"OFFSET(Working!$P$15,$F19,0,1,1)","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$V$15,$F19,0,1,1)=0,NA(),OFFSET(Working!$V$15,$F19,0,1,1))","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$Q$15,$F19,0,1,1)=0,NA(),OFFSET(Working!$Q$15,$F19,0,1,1))","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$S$15,$F19,0,1,1)=0,NA(),OFFSET(Working!$S$15,$F19,0,1,1))","v":{"$error":"#VALUE!"}}]
[null,null,null,null,15,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,15,"",{"$f":"OFFSET(Working!$D$15,N20,0,1,1)","v":{"$error":"#VALUE!"}},{"$f":"OFFSET(Working!$E$15,$F20,0,1,1)","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$K$15,$F20,0,1,1)=0,NA(),OFFSET(Working!$K$15,$F20,0,1,1))","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$F$15,$F20,0,1,1)=0,NA(),OFFSET(Working!$F$15,$F20,0,1,1))","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$H$15,$F20,0,1,1)=0,NA(),OFFSET(Working!$H$15,$F20,0,1,1))","v":{"$error":"#VALUE!"}},null,15,"",{"$f":"OFFSET(Working!$O$15,$F20,0,1,1)","v":{"$error":"#VALUE!"}},{"$f":"OFFSET(Working!$P$15,$F20,0,1,1)","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$V$15,$F20,0,1,1)=0,NA(),OFFSET(Working!$V$15,$F20,0,1,1))","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$Q$15,$F20,0,1,1)=0,NA(),OFFSET(Working!$Q$15,$F20,0,1,1))","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$S$15,$F20,0,1,1)=0,NA(),OFFSET(Working!$S$15,$F20,0,1,1))","v":{"$error":"#VALUE!"}}]
[null,null,null,null,16,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,16,"",{"$f":"OFFSET(Working!$D$15,N21,0,1,1)","v":{"$error":"#VALUE!"}},{"$f":"OFFSET(Working!$E$15,$F21,0,1,1)","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$K$15,$F21,0,1,1)=0,NA(),OFFSET(Working!$K$15,$F21,0,1,1))","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$F$15,$F21,0,1,1)=0,NA(),OFFSET(Working!$F$15,$F21,0,1,1))","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$H$15,$F21,0,1,1)=0,NA(),OFFSET(Working!$H$15,$F21,0,1,1))","v":{"$error":"#VALUE!"}},null,16,"",{"$f":"OFFSET(Working!$O$15,$F21,0,1,1)","v":{"$error":"#VALUE!"}},{"$f":"OFFSET(Working!$P$15,$F21,0,1,1)","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$V$15,$F21,0,1,1)=0,NA(),OFFSET(Working!$V$15,$F21,0,1,1))","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$Q$15,$F21,0,1,1)=0,NA(),OFFSET(Working!$Q$15,$F21,0,1,1))","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$S$15,$F21,0,1,1)=0,NA(),OFFSET(Working!$S$15,$F21,0,1,1))","v":{"$error":"#VALUE!"}}]
[null,null,null,null,17,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,17,"",{"$f":"OFFSET(Working!$D$15,N22,0,1,1)","v":{"$error":"#VALUE!"}},{"$f":"OFFSET(Working!$E$15,$F22,0,1,1)","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$K$15,$F22,0,1,1)=0,NA(),OFFSET(Working!$K$15,$F22,0,1,1))","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$F$15,$F22,0,1,1)=0,NA(),OFFSET(Working!$F$15,$F22,0,1,1))","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$H$15,$F22,0,1,1)=0,NA(),OFFSET(Working!$H$15,$F22,0,1,1))","v":{"$error":"#VALUE!"}},null,17,"",{"$f":"OFFSET(Working!$O$15,$F22,0,1,1)","v":{"$error":"#VALUE!"}},{"$f":"OFFSET(Working!$P$15,$F22,0,1,1)","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$V$15,$F22,0,1,1)=0,NA(),OFFSET(Working!$V$15,$F22,0,1,1))","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$Q$15,$F22,0,1,1)=0,NA(),OFFSET(Working!$Q$15,$F22,0,1,1))","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$S$15,$F22,0,1,1)=0,NA(),OFFSET(Working!$S$15,$F22,0,1,1))","v":{"$error":"#VALUE!"}}]
[null,null,null,null,18,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,18,"",{"$f":"OFFSET(Working!$D$15,N23,0,1,1)","v":{"$error":"#VALUE!"}},{"$f":"OFFSET(Working!$E$15,$F23,0,1,1)","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$K$15,$F23,0,1,1)=0,NA(),OFFSET(Working!$K$15,$F23,0,1,1))","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$F$15,$F23,0,1,1)=0,NA(),OFFSET(Working!$F$15,$F23,0,1,1))","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$H$15,$F23,0,1,1)=0,NA(),OFFSET(Working!$H$15,$F23,0,1,1))","v":{"$error":"#VALUE!"}},null,18,"",{"$f":"OFFSET(Working!$O$15,$F23,0,1,1)","v":{"$error":"#VALUE!"}},{"$f":"OFFSET(Working!$P$15,$F23,0,1,1)","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$V$15,$F23,0,1,1)=0,NA(),OFFSET(Working!$V$15,$F23,0,1,1))","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$Q$15,$F23,0,1,1)=0,NA(),OFFSET(Working!$Q$15,$F23,0,1,1))","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$S$15,$F23,0,1,1)=0,NA(),OFFSET(Working!$S$15,$F23,0,1,1))","v":{"$error":"#VALUE!"}}]
[null,null,null,null,19,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,19,"",{"$f":"OFFSET(Working!$D$15,N24,0,1,1)","v":{"$error":"#VALUE!"}},{"$f":"OFFSET(Working!$E$15,$F24,0,1,1)","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$K$15,$F24,0,1,1)=0,NA(),OFFSET(Working!$K$15,$F24,0,1,1))","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$F$15,$F24,0,1,1)=0,NA(),OFFSET(Working!$F$15,$F24,0,1,1))","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$H$15,$F24,0,1,1)=0,NA(),OFFSET(Working!$H$15,$F24,0,1,1))","v":{"$error":"#VALUE!"}},null,19,"",{"$f":"OFFSET(Working!$O$15,$F24,0,1,1)","v":{"$error":"#VALUE!"}},{"$f":"OFFSET(Working!$P$15,$F24,0,1,1)","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$V$15,$F24,0,1,1)=0,NA(),OFFSET(Working!$V$15,$F24,0,1,1))","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$Q$15,$F24,0,1,1)=0,NA(),OFFSET(Working!$Q$15,$F24,0,1,1))","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$S$15,$F24,0,1,1)=0,NA(),OFFSET(Working!$S$15,$F24,0,1,1))","v":{"$error":"#VALUE!"}}]
[null,null,null,null,20,"",{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},null,20,"",{"$f":"OFFSET(Working!$D$15,N25,0,1,1)","v":{"$error":"#VALUE!"}},{"$f":"OFFSET(Working!$E$15,$F25,0,1,1)","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$K$15,$F25,0,1,1)=0,NA(),OFFSET(Working!$K$15,$F25,0,1,1))","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$F$15,$F25,0,1,1)=0,NA(),OFFSET(Working!$F$15,$F25,0,1,1))","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$H$15,$F25,0,1,1)=0,NA(),OFFSET(Working!$H$15,$F25,0,1,1))","v":{"$error":"#VALUE!"}},null,20,"",{"$f":"OFFSET(Working!$O$15,$F25,0,1,1)","v":{"$error":"#VALUE!"}},{"$f":"OFFSET(Working!$P$15,$F25,0,1,1)","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$V$15,$F25,0,1,1)=0,NA(),OFFSET(Working!$V$15,$F25,0,1,1))","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$Q$15,$F25,0,1,1)=0,NA(),OFFSET(Working!$Q$15,$F25,0,1,1))","v":{"$error":"#VALUE!"}},{"$f":"IF(OFFSET(Working!$S$15,$F25,0,1,1)=0,NA(),OFFSET(Working!$S$15,$F25,0,1,1))","v":{"$error":"#VALUE!"}}]
[]
[null,null,null,null,"Text Box Content"]
[null,null,null,null,{"$f":"\"Day \"&Selected_Day","v":"Day 1"}]
[null,null,null,null,{"$f":"\"Demand: \"&VLOOKUP(Selected_Day,$F$6:$G$25,2,0)&\" units\"","v":"Demand: 100 units"}]
[null,null,null,null,{"$f":"\"Opening Stock: \"&VLOOKUP(Selected_Day,$F$6:$H$25,3,0)&\" units\"","v":"Opening Stock: 500 units"}]
[null,null,null,null,{"$f":"IFERROR(\"Stock In-Transit: \"&VLOOKUP(Selected_Day,$F$6:$K$25,6,0)&\" units\",\"\")","v":""}]
[null,null,null,null,"Order Placed Text Box"]
[null,null,null,null,{"$f":"IF(_xlfn.IFNA(F33,\"NA\")=\"NA\",\"\",\"Order Placed: \"&F33&\" units\")","v":"Order Placed: 500 units"},{"$f":"VLOOKUP(Selected_Day,$F$6:$I$25,4,0)","v":500}]
[null,null,null,null,"Stock Received Text Box"]
[null,null,null,null,{"$f":"IF(_xlfn.IFNA(F35,\"NA\")=\"NA\",\"\",\"Stock Received: \"&F35&\" units\")","v":""},{"$f":"VLOOKUP(Selected_Day,$F$6:$J$25,5,0)","v":{"$error":"#N/A"}}]