{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Demand","Answer Report 1","n-Centroid"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":55,"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":"Demand","index":0,"n_rows":2678,"n_cols":156,"rows_kept":2678,"cut":false,"hidden":false,"merged":[[5,12,5,14],[26,13,27,13],[26,14,27,14],[32,0,33,8]]}
[]
[]
[]
[]
[]
[null,"Step 1: Enter Demand Locations",null,null,null,null,"Step 2: Enter Number of Greenfield Plants",null,null,null,null,null,"Results"]
[null,"Demand Region","Demand (Qty)","Latitude","Longitude",null,"(max 5)",null,null,null,null,null,"Greenfield Locations"]
[null,"Region 1 - Delhi",67,28.61,77.23,null,4,null,null,null,null,null,"Plant","Latitude","Longitude"]
[null,"Region 2 - Mumbai",70,18.975000000000001,72.825833000000003,null,null,null,null,null,null,null,{"$f":"IF($G$8>=1,\"Greenfield 1\",\"\")","v":"Greenfield 1"},{"$f":"IF($G$8>=1,'n-Centroid'!N33,\"\")","v":13.596411072782958},{"$f":"IF($G$8>=1,'n-Centroid'!N34,\"\")","v":78.481900590571001}]
[null,"Region 3 - Kolkata",70,22.566666999999999,88.366667000000007,null,"Step 3: Reset Solver",null,null,null,null,null,{"$f":"IF($G$8>=2,\"Greenfield 2\",\"\")","v":"Greenfield 2"},{"$f":"IF($G$8>=2,'n-Centroid'!O33,\"\")","v":22.566667027306931},{"$f":"IF($G$8>=2,'n-Centroid'!O34,\"\")","v":88.366666500424344}]
[null,"Region 4 - Chennai",46,13.083333,80.266666999999998,null,null,null,null,null,null,null,{"$f":"IF($G$8>=3,\"Greenfield 3\",\"\")","v":"Greenfield 3"},{"$f":"IF($G$8>=3,'n-Centroid'!P33,\"\")","v":23.029966710027082},{"$f":"IF($G$8>=3,'n-Centroid'!P34,\"\")","v":72.580002895095831}]
[null,"Region 5 - Bangalore",54,12.966666999999999,77.566666999999995,null,null,null,null,null,null,null,{"$f":"IF($G$8>=4,\"Greenfield 4\",\"\")","v":"Greenfield 4"},{"$f":"IF($G$8>=4,'n-Centroid'!Q33,\"\")","v":26.904048612836263},{"$f":"IF($G$8>=4,'n-Centroid'!Q34,\"\")","v":77.468303850422785}]
[null,"Region 6 - Bhopal",66,23.25,77.416667000000004,null,null,null,null,null,null,null,{"$f":"IF($G$8>=5,\"Greenfield 5\",\"\")","v":""},{"$f":"IF($G$8>=5,'n-Centroid'!R33,\"\")","v":""},{"$f":"IF($G$8>=5,'n-Centroid'!R34,\"\")","v":""}]
[null,"Region 7 - Ahmedabad",78,23.03,72.58,null,"Step 4: Run Solver"]
[null,"Region 8 - Hyderabad",44,17.37,78.48,null,null,null,null,null,null,null,"Demand Region Mapping"]
[null,"Region 9 - Jaipur",19,26.9,75.8,null,"Select worksheet 'n-Centroid'",null,null,null,null,null,"Demand Region","Serving Greenfield","Service Distance (km)"]
[null,"Region 10 - Lucknow",28,26.8,80.900000000000006,null,"Click Data tab --> Solver",null,null,null,null,null,"Region 1 - Delhi",{"$f":"\"Greenfield \"&MATCH(1,'n-Centroid'!$N23:$R23,0)","v":"Greenfield 4"},{"$f":"CHOOSE(MATCH(1,'n-Centroid'!$N23:$R23,0),'n-Centroid'!V23,'n-Centroid'!W23,'n-Centroid'!X23,'n-Centroid'!Y23,'n-Centroid'!Z23)","v":191.13678460748008}]
[null,null,null,null,null,null,"Click \"Solve\"",null,null,null,null,null,"Region 2 - Mumbai",{"$f":"\"Greenfield \"&MATCH(1,'n-Centroid'!$N24:$R24,0)","v":"Greenfield 3"},{"$f":"CHOOSE(MATCH(1,'n-Centroid'!$N24:$R24,0),'n-Centroid'!V24,'n-Centroid'!W24,'n-Centroid'!X24,'n-Centroid'!Y24,'n-Centroid'!Z24)","v":451.61286330697169}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Region 3 - Kolkata",{"$f":"\"Greenfield \"&MATCH(1,'n-Centroid'!$N25:$R25,0)","v":"Greenfield 2"},{"$f":"CHOOSE(MATCH(1,'n-Centroid'!$N25:$R25,0),'n-Centroid'!V25,'n-Centroid'!W25,'n-Centroid'!X25,'n-Centroid'!Y25,'n-Centroid'!Z25)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Region 4 - Chennai",{"$f":"\"Greenfield \"&MATCH(1,'n-Centroid'!$N26:$R26,0)","v":"Greenfield 1"},{"$f":"CHOOSE(MATCH(1,'n-Centroid'!$N26:$R26,0),'n-Centroid'!V26,'n-Centroid'!W26,'n-Centroid'!X26,'n-Centroid'!Y26,'n-Centroid'!Z26)","v":201.35278822814197}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Region 5 - Bangalore",{"$f":"\"Greenfield \"&MATCH(1,'n-Centroid'!$N27:$R27,0)","v":"Greenfield 1"},{"$f":"CHOOSE(MATCH(1,'n-Centroid'!$N27:$R27,0),'n-Centroid'!V27,'n-Centroid'!W27,'n-Centroid'!X27,'n-Centroid'!Y27,'n-Centroid'!Z27)","v":121.2998384091411}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Region 6 - Bhopal",{"$f":"\"Greenfield \"&MATCH(1,'n-Centroid'!$N28:$R28,0)","v":"Greenfield 4"},{"$f":"CHOOSE(MATCH(1,'n-Centroid'!$N28:$R28,0),'n-Centroid'!V28,'n-Centroid'!W28,'n-Centroid'!X28,'n-Centroid'!Y28,'n-Centroid'!Z28)","v":406.34492915139333}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Region 7 - Ahmedabad",{"$f":"\"Greenfield \"&MATCH(1,'n-Centroid'!$N29:$R29,0)","v":"Greenfield 3"},{"$f":"CHOOSE(MATCH(1,'n-Centroid'!$N29:$R29,0),'n-Centroid'!V29,'n-Centroid'!W29,'n-Centroid'!X29,'n-Centroid'!Y29,'n-Centroid'!Z29)","v":3.7109866751501297E-3}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Region 8 - Hyderabad",{"$f":"\"Greenfield \"&MATCH(1,'n-Centroid'!$N30:$R30,0)","v":"Greenfield 1"},{"$f":"CHOOSE(MATCH(1,'n-Centroid'!$N30:$R30,0),'n-Centroid'!V30,'n-Centroid'!W30,'n-Centroid'!X30,'n-Centroid'!Y30,'n-Centroid'!Z30)","v":419.60399335420755}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Region 9 - Jaipur",{"$f":"\"Greenfield \"&MATCH(1,'n-Centroid'!$N31:$R31,0)","v":"Greenfield 4"},{"$f":"CHOOSE(MATCH(1,'n-Centroid'!$N31:$R31,0),'n-Centroid'!V31,'n-Centroid'!W31,'n-Centroid'!X31,'n-Centroid'!Y31,'n-Centroid'!Z31)","v":165.43106735765474}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Region 10 - Lucknow",{"$f":"\"Greenfield \"&MATCH(1,'n-Centroid'!$N32:$R32,0)","v":"Greenfield 4"},{"$f":"CHOOSE(MATCH(1,'n-Centroid'!$N32:$R32,0),'n-Centroid'!V32,'n-Centroid'!W32,'n-Centroid'!X32,'n-Centroid'!Y32,'n-Centroid'!Z32)","v":340.62903919439657}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Weigted Avg Service Distance -->",{"$f":"ROUND('n-Centroid'!AA34,0)&\" kms\"","v":"218 kms"}]
[]
[]
[]
[]
[]
["© 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."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"© 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":"Answer Report 1","index":1,"n_rows":165,"n_cols":11,"rows_kept":165,"cut":false,"hidden":false,"merged":[]}
["Microsoft Excel 15.0 Answer Report"]
["Worksheet: [Greenfield v2.xlsm]n-Centroid"]
["Report Created: 8/2/2017 7:24:10 AM"]
["Result: Solver has converged to the current solution.  All Constraints are satisfied."]
["Solver Engine"]
[null,"Engine: GRG Nonlinear"]
[null,"Solution Time: 3446.047 Seconds."]
[null,"Iterations: 77 Subproblems: 6",null,null,null,null,null,null,null,null,{"$f":"3446/60","v":57.43333333333333}]
["Solver Options"]
[null,"Max Time Unlimited,  Iterations Unlimited, Precision 0.000000001, Use Automatic Scaling"]
[null," Convergence 0.000001, Population Size 100, Random Seed 0, Derivatives Central,  Multistart, Require Bounds"]
[null,"Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1%, Assume NonNegative"]
[]
["Objective Cell (Min)"]
[null,"Cell","Name","Original Value","Final Value"]
[null,"$AA$33","Σ Dist x Demand Dist x Demand",0,118193.91839855361]
[]
[]
["Variable Cells"]
[null,"Cell","Name","Original Value","Final Value","Integer"]
[null,"$N$23","Region 1 - Delhi Plant 1",0,0,"Binary"]
[null,"$O$23","Region 1 - Delhi Plant 2",0,0,"Binary"]
[null,"$P$23","Region 1 - Delhi Plant 3",0,0,"Binary"]
[null,"$Q$23","Region 1 - Delhi Plant 4",0,1,"Binary"]
[null,"$R$23","Region 1 - Delhi Plant 5",0,0,"Binary"]
[null,"$N$24","Region 2 - Mumbai Plant 1",0,0,"Binary"]
[null,"$O$24","Region 2 - Mumbai Plant 2",0,0,"Binary"]
[null,"$P$24","Region 2 - Mumbai Plant 3",0,1,"Binary"]
[null,"$Q$24","Region 2 - Mumbai Plant 4",0,0,"Binary"]
[null,"$R$24","Region 2 - Mumbai Plant 5",0,0,"Binary"]
[null,"$N$25","Region 3 - Kolkata Plant 1",0,0,"Binary"]
[null,"$O$25","Region 3 - Kolkata Plant 2",0,1,"Binary"]
[null,"$P$25","Region 3 - Kolkata Plant 3",0,0,"Binary"]
[null,"$Q$25","Region 3 - Kolkata Plant 4",0,0,"Binary"]
[null,"$R$25","Region 3 - Kolkata Plant 5",0,0,"Binary"]
[null,"$N$26","Region 4 - Chennai Plant 1",0,1,"Binary"]
[null,"$O$26","Region 4 - Chennai Plant 2",0,0,"Binary"]
[null,"$P$26","Region 4 - Chennai Plant 3",0,0,"Binary"]
[null,"$Q$26","Region 4 - Chennai Plant 4",0,0,"Binary"]
[null,"$R$26","Region 4 - Chennai Plant 5",0,0,"Binary"]
[null,"$N$27","Region 5 - Bangalore Plant 1",0,1,"Binary"]
[null,"$O$27","Region 5 - Bangalore Plant 2",0,0,"Binary"]
[null,"$P$27","Region 5 - Bangalore Plant 3",0,0,"Binary"]
[null,"$Q$27","Region 5 - Bangalore Plant 4",0,0,"Binary"]
[null,"$R$27","Region 5 - Bangalore Plant 5",0,0,"Binary"]
[null,"$N$28","Region 6 - Bhopal Plant 1",0,0,"Binary"]
[null,"$O$28","Region 6 - Bhopal Plant 2",0,0,"Binary"]
[null,"$P$28","Region 6 - Bhopal Plant 3",0,0,"Binary"]
[null,"$Q$28","Region 6 - Bhopal Plant 4",0,1,"Binary"]
[null,"$R$28","Region 6 - Bhopal Plant 5",0,0,"Binary"]
[null,"$N$29","Region 7 - Ahmedabad Plant 1",0,0,"Binary"]
[null,"$O$29","Region 7 - Ahmedabad Plant 2",0,0,"Binary"]
[null,"$P$29","Region 7 - Ahmedabad Plant 3",0,1,"Binary"]
[null,"$Q$29","Region 7 - Ahmedabad Plant 4",0,0,"Binary"]
[null,"$R$29","Region 7 - Ahmedabad Plant 5",0,0,"Binary"]
[null,"$N$30","Region 8 - Hyderabad Plant 1",0,1,"Binary"]
[null,"$O$30","Region 8 - Hyderabad Plant 2",0,0,"Binary"]
[null,"$P$30","Region 8 - Hyderabad Plant 3",0,0,"Binary"]
[null,"$Q$30","Region 8 - Hyderabad Plant 4",0,0,"Binary"]
[null,"$R$30","Region 8 - Hyderabad Plant 5",0,0,"Binary"]
[null,"$N$31","Region 9 - Jaipur Plant 1",0,0,"Binary"]
[null,"$O$31","Region 9 - Jaipur Plant 2",0,0,"Binary"]
[null,"$P$31","Region 9 - Jaipur Plant 3",0,0,"Binary"]
[null,"$Q$31","Region 9 - Jaipur Plant 4",0,1,"Binary"]
[null,"$R$31","Region 9 - Jaipur Plant 5",0,0,"Binary"]
[null,"$N$32","Region 10 - Lucknow Plant 1",0,0,"Binary"]
[null,"$O$32","Region 10 - Lucknow Plant 2",0,0,"Binary"]
[null,"$P$32","Region 10 - Lucknow Plant 3",0,0,"Binary"]
[null,"$Q$32","Region 10 - Lucknow Plant 4",0,1,"Binary"]
[null,"$R$32","Region 10 - Lucknow Plant 5",0,0,"Binary"]
[null,"$N$33","Plant Lat Plant 1",0,13.596411072782958,"Contin"]
[null,"$O$33","Plant Lat Plant 2",0,22.566667027306931,"Contin"]
[null,"$P$33","Plant Lat Plant 3",0,23.029966710027082,"Contin"]
[null,"$Q$33","Plant Lat Plant 4",0,26.904048612836263,"Contin"]
[null,"$R$33","Plant Lat Plant 5",0,0,"Contin"]
[null,"$N$34","Plant Long Plant 1",0,78.481900590571001,"Contin"]
[null,"$O$34","Plant Long Plant 2",0,88.366666500424344,"Contin"]
[null,"$P$34","Plant Long Plant 3",0,72.580002895095831,"Contin"]
[null,"$Q$34","Plant Long Plant 4",0,77.468303850422785,"Contin"]
[null,"$R$34","Plant Long Plant 5",0,0,"Contin"]
[]
[]
["Constraints"]
[null,"Cell","Name","Cell Value","Formula","Status","Slack"]
[null,"$S$23","Region 1 - Delhi Sum",1,"$S$23=1","Binding",0]
[null,"$S$24","Region 2 - Mumbai Sum",1,"$S$24=1","Binding",0]
[null,"$S$25","Region 3 - Kolkata Sum",1,"$S$25=1","Binding",0]
[null,"$S$26","Region 4 - Chennai Sum",1,"$S$26=1","Binding",0]
[null,"$S$27","Region 5 - Bangalore Sum",1,"$S$27=1","Binding",0]
[null,"$S$28","Region 6 - Bhopal Sum",1,"$S$28=1","Binding",0]
[null,"$S$29","Region 7 - Ahmedabad Sum",1,"$S$29=1","Binding",0]
[null,"$S$30","Region 8 - Hyderabad Sum",1,"$S$30=1","Binding",0]
[null,"$S$31","Region 9 - Jaipur Sum",1,"$S$31=1","Binding",0]
[null,"$S$32","Region 10 - Lucknow Sum",1,"$S$32=1","Binding",0]
[null,"$N$23","Region 1 - Delhi Plant 1",0,"$N$23<=$G$23","Not Binding",1]
[null,"$O$23","Region 1 - Delhi Plant 2",0,"$O$23<=$H$23","Not Binding",1]
[null,"$P$23","Region 1 - Delhi Plant 3",0,"$P$23<=$I$23","Binding",0]
[null,"$Q$23","Region 1 - Delhi Plant 4",1,"$Q$23<=$J$23","Binding",0]
[null,"$R$23","Region 1 - Delhi Plant 5",0,"$R$23<=$K$23","Binding",0]
[null,"$N$24","Region 2 - Mumbai Plant 1",0,"$N$24<=$G$24","Binding",0]
[null,"$O$24","Region 2 - Mumbai Plant 2",0,"$O$24<=$H$24","Not Binding",1]
[null,"$P$24","Region 2 - Mumbai Plant 3",1,"$P$24<=$I$24","Binding",0]
[null,"$Q$24","Region 2 - Mumbai Plant 4",0,"$Q$24<=$J$24","Not Binding",1]
[null,"$R$24","Region 2 - Mumbai Plant 5",0,"$R$24<=$K$24","Binding",0]
[null,"$N$25","Region 3 - Kolkata Plant 1",0,"$N$25<=$G$25","Not Binding",1]
[null,"$O$25","Region 3 - Kolkata Plant 2",1,"$O$25<=$H$25","Binding",0]
[null,"$P$25","Region 3 - Kolkata Plant 3",0,"$P$25<=$I$25","Not Binding",1]
[null,"$Q$25","Region 3 - Kolkata Plant 4",0,"$Q$25<=$J$25","Not Binding",1]
[null,"$R$25","Region 3 - Kolkata Plant 5",0,"$R$25<=$K$25","Binding",0]
[null,"$N$26","Region 4 - Chennai Plant 1",1,"$N$26<=$G$26","Binding",0]
[null,"$O$26","Region 4 - Chennai Plant 2",0,"$O$26<=$H$26","Not Binding",1]
[null,"$P$26","Region 4 - Chennai Plant 3",0,"$P$26<=$I$26","Not Binding",1]
[null,"$Q$26","Region 4 - Chennai Plant 4",0,"$Q$26<=$J$26","Not Binding",1]
[null,"$R$26","Region 4 - Chennai Plant 5",0,"$R$26<=$K$26","Binding",0]
[null,"$N$27","Region 5 - Bangalore Plant 1",1,"$N$27<=$G$27","Binding",0]
[null,"$O$27","Region 5 - Bangalore Plant 2",0,"$O$27<=$H$27","Not Binding",1]
[null,"$P$27","Region 5 - Bangalore Plant 3",0,"$P$27<=$I$27","Not Binding",1]
[null,"$Q$27","Region 5 - Bangalore Plant 4",0,"$Q$27<=$J$27","Not Binding",1]
[null,"$R$27","Region 5 - Bangalore Plant 5",0,"$R$27<=$K$27","Binding",0]
[null,"$N$28","Region 6 - Bhopal Plant 1",0,"$N$28<=$G$28","Not Binding",1]
[null,"$O$28","Region 6 - Bhopal Plant 2",0,"$O$28<=$H$28","Not Binding",1]
[null,"$P$28","Region 6 - Bhopal Plant 3",0,"$P$28<=$I$28","Not Binding",1]
[null,"$Q$28","Region 6 - Bhopal Plant 4",1,"$Q$28<=$J$28","Binding",0]
[null,"$R$28","Region 6 - Bhopal Plant 5",0,"$R$28<=$K$28","Binding",0]
[null,"$N$29","Region 7 - Ahmedabad Plant 1",0,"$N$29<=$G$29","Not Binding",1]
[null,"$O$29","Region 7 - Ahmedabad Plant 2",0,"$O$29<=$H$29","Not Binding",1]
[null,"$P$29","Region 7 - Ahmedabad Plant 3",1,"$P$29<=$I$29","Binding",0]
[null,"$Q$29","Region 7 - Ahmedabad Plant 4",0,"$Q$29<=$J$29","Not Binding",1]
[null,"$R$29","Region 7 - Ahmedabad Plant 5",0,"$R$29<=$K$29","Binding",0]
[null,"$N$30","Region 8 - Hyderabad Plant 1",1,"$N$30<=$G$30","Binding",0]
[null,"$O$30","Region 8 - Hyderabad Plant 2",0,"$O$30<=$H$30","Not Binding",1]
[null,"$P$30","Region 8 - Hyderabad Plant 3",0,"$P$30<=$I$30","Not Binding",1]
[null,"$Q$30","Region 8 - Hyderabad Plant 4",0,"$Q$30<=$J$30","Not Binding",1]
[null,"$R$30","Region 8 - Hyderabad Plant 5",0,"$R$30<=$K$30","Binding",0]
[null,"$N$31","Region 9 - Jaipur Plant 1",0,"$N$31<=$G$31","Not Binding",1]
[null,"$O$31","Region 9 - Jaipur Plant 2",0,"$O$31<=$H$31","Not Binding",1]
[null,"$P$31","Region 9 - Jaipur Plant 3",0,"$P$31<=$I$31","Not Binding",1]
[null,"$Q$31","Region 9 - Jaipur Plant 4",1,"$Q$31<=$J$31","Binding",0]
[null,"$R$31","Region 9 - Jaipur Plant 5",0,"$R$31<=$K$31","Binding",0]
[null,"$N$32","Region 10 - Lucknow Plant 1",0,"$N$32<=$G$32","Not Binding",1]
[null,"$O$32","Region 10 - Lucknow Plant 2",0,"$O$32<=$H$32","Not Binding",1]
[null,"$P$32","Region 10 - Lucknow Plant 3",0,"$P$32<=$I$32","Not Binding",1]
[null,"$Q$32","Region 10 - Lucknow Plant 4",1,"$Q$32<=$J$32","Binding",0]
[null,"$R$32","Region 10 - Lucknow Plant 5",0,"$R$32<=$K$32","Binding",0]
[null,"$N$33","Plant Lat Plant 1",13.596411072782958,"$N$33<=90","Not Binding",76.403588927217044]
[null,"$O$33","Plant Lat Plant 2",22.566667027306931,"$O$33<=90","Not Binding",67.433332972693066]
[null,"$P$33","Plant Lat Plant 3",23.029966710027082,"$P$33<=90","Not Binding",66.970033289972918]
[null,"$Q$33","Plant Lat Plant 4",26.904048612836263,"$Q$33<=90","Not Binding",63.095951387163737]
[null,"$R$33","Plant Lat Plant 5",0,"$R$33<=90","Not Binding",90]
[null,"$N$33","Plant Lat Plant 1",13.596411072782958,"$N$33>=-90","Not Binding",103.59641107278296]
[null,"$O$33","Plant Lat Plant 2",22.566667027306931,"$O$33>=-90","Not Binding",112.56666702730693]
[null,"$P$33","Plant Lat Plant 3",23.029966710027082,"$P$33>=-90","Not Binding",113.02996671002708]
[null,"$Q$33","Plant Lat Plant 4",26.904048612836263,"$Q$33>=-90","Not Binding",116.90404861283626]
[null,"$R$33","Plant Lat Plant 5",0,"$R$33>=-90","Not Binding",90]
[null,"$N$34","Plant Long Plant 1",78.481900590571001,"$N$34<=180","Not Binding",101.518099409429]
[null,"$O$34","Plant Long Plant 2",88.366666500424344,"$O$34<=180","Not Binding",91.633333499575656]
[null,"$P$34","Plant Long Plant 3",72.580002895095831,"$P$34<=180","Not Binding",107.41999710490417]
[null,"$Q$34","Plant Long Plant 4",77.468303850422785,"$Q$34<=180","Not Binding",102.53169614957721]
[null,"$R$34","Plant Long Plant 5",0,"$R$34<=180","Not Binding",180]
[null,"$N$34","Plant Long Plant 1",78.481900590571001,"$N$34>=-180","Not Binding",258.481900590571]
[null,"$O$34","Plant Long Plant 2",88.366666500424344,"$O$34>=-180","Not Binding",268.36666650042434]
[null,"$P$34","Plant Long Plant 3",72.580002895095831,"$P$34>=-180","Not Binding",252.58000289509584]
[null,"$Q$34","Plant Long Plant 4",77.468303850422785,"$Q$34>=-180","Not Binding",257.46830385042279]
[null,"$R$34","Plant Long Plant 5",0,"$R$34>=-180","Not Binding",180]
[null,"$N$23:$R$32=Binary"]

{"sheet":"n-Centroid","index":2,"n_rows":2678,"n_cols":156,"rows_kept":2678,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[null,null,"Set No of Centroids (max 5)",{"$f":"Demand!G8","v":4}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Helper Matrix",null,null,null,null,null,null,null,null,null,"Decision Matrix",null,null,null,null,null,null,null,"Objective Function"]
[null,null,null,null,null,null,{"$f":"IF($D$7>=1,1,0)","v":1},{"$f":"IF($D$7>=2,1,0)","v":1},{"$f":"IF($D$7>=3,1,0)","v":1},{"$f":"IF($D$7>=4,1,0)","v":1},{"$f":"IF($D$7>=5,1,0)","v":0}]
[null,null,{"$f":"Demand!B7","v":"Demand Region"},{"$f":"Demand!C7","v":"Demand (Qty)"},{"$f":"Demand!D7","v":"Latitude"},{"$f":"Demand!E7","v":"Longitude"},"Plant 1","Plant 2","Plant 3","Plant 4","Plant 5",null,{"$f":"C22","v":"Demand Region"},"Plant 1","Plant 2","Plant 3","Plant 4","Plant 5","Sum",null,{"$f":"M22","v":"Demand Region"},{"$f":"N22","v":"Plant 1"},"Plant 2","Plant 3","Plant 4",{"$f":"R22","v":"Plant 5"},"Dist x Demand"]
[null,null,{"$f":"Demand!B8","v":"Region 1 - Delhi"},{"$f":"Demand!C8","v":67},{"$f":"Demand!D8","v":28.61},{"$f":"Demand!E8","v":77.23},{"$f":"G$21","v":1},{"$f":"H$21","v":1},1,1,0,null,{"$f":"C23","v":"Region 1 - Delhi"},0,0,0,1,0,{"$f":"SUM(N23:R23)","v":1},null,{"$f":"M23","v":"Region 1 - Delhi"},{"$f":"G23* (ACOS(COS(RADIANS(90-N$33)) *COS(RADIANS(90-$E23)) +SIN(RADIANS(90-N$33)) *SIN(RADIANS(90-$E23)) *COS(RADIANS(N$34-$F23))) *6371)","v":1674.436869247219},{"$f":"H23* (ACOS(COS(RADIANS(90-O$33)) *COS(RADIANS(90-$E23)) +SIN(RADIANS(90-O$33)) *SIN(RADIANS(90-$E23)) *COS(RADIANS(O$34-$F23))) *6371)","v":1302.4248900770058},775.43661182921142,191.13678460748008,0,{"$f":"D23*((V23*N23)+(O23*W23)+(X23*P23)+(Y23*Q23)+(R23*Z23))","v":12806.164568701166}]
[null,null,{"$f":"Demand!B9","v":"Region 2 - Mumbai"},{"$f":"Demand!C9","v":70},{"$f":"Demand!D9","v":18.975000000000001},{"$f":"Demand!E9","v":72.825833000000003},{"$f":"G$21","v":1},1,1,1,0,null,"Region 2 - Mumbai",0,0,1,0,0,{"$f":"SUM(N24:R24)","v":1},null,"Region 2 - Mumbai",{"$f":"G24* (ACOS(COS(RADIANS(90-N$33)) *COS(RADIANS(90-$E24)) +SIN(RADIANS(90-N$33)) *SIN(RADIANS(90-$E24)) *COS(RADIANS(N$34-$F24))) *6371)","v":849.57197239904917},{"$f":"H24* (ACOS(COS(RADIANS(90-O$33)) *COS(RADIANS(90-$E24)) +SIN(RADIANS(90-O$33)) *SIN(RADIANS(90-$E24)) *COS(RADIANS(O$34-$F24))) *6371)","v":1663.3981049461984},{"$f":"I24* (ACOS(COS(RADIANS(90-P$33)) *COS(RADIANS(90-$E24)) +SIN(RADIANS(90-P$33)) *SIN(RADIANS(90-$E24)) *COS(RADIANS(P$34-$F24))) *6371)","v":451.61286330697169},{"$f":"J24* (ACOS(COS(RADIANS(90-Q$33)) *COS(RADIANS(90-$E24)) +SIN(RADIANS(90-Q$33)) *SIN(RADIANS(90-$E24)) *COS(RADIANS(Q$34-$F24))) *6371)","v":1001.38328378585},{"$f":"K24* (ACOS(COS(RADIANS(90-R$33)) *COS(RADIANS(90-$E24)) +SIN(RADIANS(90-R$33)) *SIN(RADIANS(90-$E24)) *COS(RADIANS(R$34-$F24))) *6371)","v":0},{"$f":"D24*((V24*N24)+(O24*W24)+(X24*P24)+(Y24*Q24)+(R24*Z24))","v":31612.900431488019}]
[null,null,{"$f":"Demand!B10","v":"Region 3 - Kolkata"},{"$f":"Demand!C10","v":70},{"$f":"Demand!D10","v":22.566666999999999},{"$f":"Demand!E10","v":88.366667000000007},1,1,1,1,0,null,"Region 3 - Kolkata",0,1,0,0,0,1,null,"Region 3 - Kolkata",1443.4041096820072,0,1618.2957292281246,1201.0259968094701,0,0]
[null,null,{"$f":"Demand!B11","v":"Region 4 - Chennai"},{"$f":"Demand!C11","v":46},{"$f":"Demand!D11","v":13.083333},{"$f":"Demand!E11","v":80.266666999999998},1,1,1,1,0,null,"Region 4 - Chennai",1,0,0,0,0,1,null,"Region 4 - Chennai",201.35278822814197,1358.2555933446624,1371.6199231457206,1564.1787916889637,0,9262.2282584945315]
[null,null,{"$f":"Demand!B12","v":"Region 5 - Bangalore"},{"$f":"Demand!C12","v":54},{"$f":"Demand!D12","v":12.966666999999999},{"$f":"Demand!E12","v":77.566666999999995},1,1,1,1,0,null,"Region 5 - Bangalore",1,0,0,0,0,1,null,"Region 5 - Bangalore",121.2998384091411,1563.0147192643651,1236.6410750529278,1549.7999994152563,0,6550.1912740936195]
[null,null,{"$f":"Demand!B13","v":"Region 6 - Bhopal"},{"$f":"Demand!C13","v":66},{"$f":"Demand!D13","v":23.25},{"$f":"Demand!E13","v":77.416667000000004},1,1,1,1,0,null,"Region 6 - Bhopal",0,0,0,1,0,1,null,"Region 6 - Bhopal",1079.2780432291854,1123.8539532805744,495.12585663921982,406.34492915139333,0,26818.76532399196]
[null,null,{"$f":"Demand!B14","v":"Region 7 - Ahmedabad"},{"$f":"Demand!C14","v":78},{"$f":"Demand!D14","v":23.03},{"$f":"Demand!E14","v":72.58},1,1,1,1,0,null,"Region 7 - Ahmedabad",0,0,1,0,0,1,null,"Region 7 - Ahmedabad",1219.545247829762,1618.2958924424067,3.7109866751501297E-3,654.36995494464372,0,0.28945696066171012]
[null,null,{"$f":"Demand!B15","v":"Region 8 - Hyderabad"},{"$f":"Demand!C15","v":44},{"$f":"Demand!D15","v":17.37},{"$f":"Demand!E15","v":78.48},1,1,1,1,0,null,"Region 8 - Hyderabad",1,0,0,0,0,1,null,"Region 8 - Hyderabad",419.60399335420755,1183.295486575355,880.17272838006841,1065.2290381696041,0,18462.575707585132]
[null,null,{"$f":"Demand!B16","v":"Region 9 - Jaipur"},{"$f":"Demand!C16","v":19},{"$f":"Demand!D16","v":26.9},{"$f":"Demand!E16","v":75.8},1,1,1,1,0,null,"Region 9 - Jaipur",0,0,0,1,0,1,null,"Region 9 - Jaipur",1505.3521802090449,1356.6715705841509,538.95466498709709,165.43106735765474,0,3143.1902797954399]
[null,null,{"$f":"Demand!B17","v":"Region 10 - Lucknow"},{"$f":"Demand!C17","v":28},{"$f":"Demand!D17","v":26.8},{"$f":"Demand!E17","v":80.900000000000006},1,1,1,1,0,null,"Region 10 - Lucknow",0,0,0,1,0,1,null,"Region 10 - Lucknow",1489.5668266789901,888.89241921458176,937.59745102518616,340.62903919439657,0,9537.6130974431035]
[null,null,null,null,null,null,null,null,null,null,null,null,"Plant Lat",13.596411072782958,22.566667027306931,23.029966710027082,26.904048612836263,0,null,null,null,null,null,null,null,"Σ Dist x Demand",{"$f":"SUM(AA23:AA32)","v":118193.91839855361}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Plant Long",78.481900590571001,88.366666500424344,72.580002895095831,77.468303850422785,0,null,null,null,null,null,null,null,"Weighted Avg Distance",{"$f":"AA33/SUM(D23:D32)","v":218.06996014493285}]
[null,null,null,null,null,null,null,null,null,null,null,null,"Min Lat",-90,-90,-90,-90,-90,null,null,null,null,null,null,null,"(in kms)"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Min Long",-180,-180,-180,-180,-180]
[null,null,null,null,null,null,null,null,null,null,null,null,"Max Lat",90,90,90,90,90]
[null,null,null,null,null,null,null,null,null,null,null,null,"Max Long",180,180,180,180,180]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"© 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."]