orders_Notebook.csv
Type Table, then Shift-Enter. Ctrl-space for more options.
input_vehicles_Notebook.csv
Type Table, then Shift-Enter. Ctrl-space for more options.
OptimizationProblem = {
let input_json = {
vehicles: [],
jobs: [],
shipments: [],
depots: [],
options: {
objective: {
travel_cost: `${inputs.objectiveFunction.value.value}`
},
constraints: {
max_vehicle_overtime: 0,
max_visit_lateness: 0
}
},
locations: {
id: 1,
location: []
}
};
let input_vehicles = [
{
Id: 1,
Vehicle: "Rider 1",
Capacity: 6,
Zone: "MUM1",
Skills: 1,
Start_Location: "19.0413436,72.8433324"
},
{
Id: 2,
Vehicle: "Rider 2",
Capacity: 6,
Zone: "MUM1",
Skills: 1,
Start_Location: "19.0413436,72.8433324"
},
{
Id: 3,
Vehicle: "Rider 3",
Capacity: 6,
Zone: "MUM1",
Skills: 1,
Start_Location: "19.0413436,72.8433324"
},
{
Id: 4,
Vehicle: "Rider 4",
Capacity: 6,
Zone: "MUM1",
Skills: 1,
Start_Location: "19.0413436,72.8433324"
},
{
Id: 5,
Vehicle: "Rider 5",
Capacity: 6,
Zone: "MUM3",
Skills: 2,
Start_Location: "19.0217311,72.8584702"
},
{
Id: 6,
Vehicle: "Rider 6",
Capacity: 6,
Zone: "MUM3",
Skills: 2,
Start_Location: "19.0217311,72.8584702"
},
{
Id: 7,
Vehicle: "Rider 7",
Capacity: 6,
Zone: "MUM3",
Skills: 2,
Start_Location: "19.0217311,72.8584702"
},
{
Id: 8,
Vehicle: "Rider 8",
Capacity: 6,
Zone: "MUM3",
Skills: 2,
Start_Location: "19.0217311,72.8584702"
},
{
Id: 9,
Vehicle: "Rider 9",
Capacity: 6,
Zone: "MUM4",
Skills: 3,
Start_Location: "19.1244872,72.8691749"
},
{
Id: 10,
Vehicle: "Rider 10",
Capacity: 6,
Zone: "MUM4",
Skills: 3,
Start_Location: "19.1127721,72.8478788"
},
{
Id: 11,
Vehicle: "Rider 11",
Capacity: 6,
Zone: "MUM4",
Skills: 3,
Start_Location: "19.1127721,72.8478788"
},
{
Id: 12,
Vehicle: "Rider 12",
Capacity: 6,
Zone: "MUM4",
Skills: 3,
Start_Location: "19.1097712,72.8582672"
},
{
Id: 13,
Vehicle: "Rider 13",
Capacity: 6,
Zone: "NMM2",
Skills: 4,
Start_Location: "19.018856,73.0175905999999"
},
{
Id: 14,
Vehicle: "Rider 14",
Capacity: 6,
Zone: "NMM2",
Skills: 4,
Start_Location: "19.018856,73.0175905999999"
},
{
Id: 15,
Vehicle: "Rider 15",
Capacity: 6,
Zone: "NMM2",
Skills: 4,
Start_Location: "19.018856,73.0175905999999"
},
{
Id: 16,
Vehicle: "Rider 16",
Capacity: 6,
Zone: "NMM2",
Skills: 4,
Start_Location: "19.018856,73.0175905999999"
},
{
Id: 17,
Vehicle: "Rider 17",
Capacity: 6,
Zone: "THN",
Skills: 5,
Start_Location: "19.2183307,72.9780897"
},
{
Id: 18,
Vehicle: "Rider 18",
Capacity: 6,
Zone: "THN",
Skills: 5,
Start_Location: "19.2183307,72.9780897"
},
{
Id: 19,
Vehicle: "Rider 19",
Capacity: 6,
Zone: "THN",
Skills: 5,
Start_Location: "19.2183307,72.9780897"
},
{
Id: 20,
Vehicle: "Rider 20",
Capacity: 6,
Zone: "THN",
Skills: 5,
Start_Location: "19.2183307,72.9780897"
}
];
let orders = [
{
Id: 6,
Pickup_Location: "19.0413436,72.8433324",
Pickup_Zone: "MUM1",
Pickup_Skills: 1,
Cx_Name: "Laboni chatterjee",
City: "Mumbai",
Delivery_Location: "19.2205557,72.9586769",
Delivery_Zone: "THN",
Pickup_Start_Time: "17-07-2023 07:00",
Pickup_End_Time: "17-07-2023 07:30",
delivery_start_time: "17-07-2023 08:30",
delivery_end_time: "17-07-2023 09:00",
no_of_Orders: 1,
Delivery_Skills: 5,
Difference: "FALSE",
Handover_point: "SION",
Handover_Location: "19.0422288,72.8620784"
},
{
Id: 7,
Pickup_Location: "19.0413436,72.8433324",
Pickup_Zone: "MUM1",
Pickup_Skills: 1,
Cx_Name: "Sachin nair",
City: "Mumbai",
Delivery_Location: "19.2283188,72.9870717",
Delivery_Zone: "THN",
Pickup_Start_Time: "17-07-2023 07:00",
Pickup_End_Time: "17-07-2023 07:30",
delivery_start_time: "17-07-2023 08:30",
delivery_end_time: "17-07-2023 09:00",
no_of_Orders: 1,
Delivery_Skills: 5,
Difference: "FALSE",
Handover_point: "SION",
Handover_Location: "19.0422288,72.8620784"
},
{
Id: 8,
Pickup_Location: "19.0413436,72.8433324",
Pickup_Zone: "MUM1",
Pickup_Skills: 1,
Cx_Name: "Dr Sonali S",
City: "Mumbai",
Delivery_Location: "19.1929647,72.9615584",
Delivery_Zone: "THN",
Pickup_Start_Time: "17-07-2023 07:00",
Pickup_End_Time: "17-07-2023 07:30",
delivery_start_time: "17-07-2023 08:30",
delivery_end_time: "17-07-2023 09:00",
no_of_Orders: 1,
Delivery_Skills: 5,
Difference: "FALSE",
Handover_point: "SION",
Handover_Location: "19.0422288,72.8620784"
},
{
Id: 10,
Pickup_Location: "19.0413436,72.8433324",
Pickup_Zone: "MUM1",
Pickup_Skills: 1,
Cx_Name: "Gaurav Gupta",
City: "Mumbai",
Delivery_Location: "19.207961,72.9579689999999",
Delivery_Zone: "THN",
Pickup_Start_Time: "17-07-2023 07:00",
Pickup_End_Time: "17-07-2023 07:30",
delivery_start_time: "17-07-2023 08:30",
delivery_end_time: "17-07-2023 09:00",
no_of_Orders: 1,
Delivery_Skills: 5,
Difference: "FALSE",
Handover_point: "SION",
Handover_Location: "19.0422288,72.8620784"
},
{
Id: 11,
Pickup_Location: "19.0413436,72.8433324",
Pickup_Zone: "MUM1",
Pickup_Skills: 1,
Cx_Name: "Bharat Kulhalli",
City: "Mumbai",
Delivery_Location: "19.1725542,72.942537",
Delivery_Zone: "THN",
Pickup_Start_Time: "17-07-2023 07:00",
Pickup_End_Time: "17-07-2023 07:30",
delivery_start_time: "17-07-2023 08:30",
delivery_end_time: "17-07-2023 09:00",
no_of_Orders: 1,
Delivery_Skills: 5,
Difference: "FALSE",
Handover_point: "SION",
Handover_Location: "19.0422288,72.8620784"
},
{
Id: 15,
Pickup_Location: "19.0413436,72.8433324",
Pickup_Zone: "MUM1",
Pickup_Skills: 1,
Cx_Name: "Prabodh Desaid",
City: "Mumbai",
Delivery_Location: "19.2457714,72.9800115",
Delivery_Zone: "THN",
Pickup_Start_Time: "17-07-2023 07:00",
Pickup_End_Time: "17-07-2023 07:30",
delivery_start_time: "17-07-2023 08:30",
delivery_end_time: "17-07-2023 09:00",
no_of_Orders: 1,
Delivery_Skills: 5,
Difference: "FALSE",
Handover_point: "SION",
Handover_Location: "19.0422288,72.8620784"
},
{
Id: 22,
Pickup_Location: "19.0413436,72.8433324",
Pickup_Zone: "MUM1",
Pickup_Skills: 1,
Cx_Name: "Raju pillai",
City: "Mumbai",
Delivery_Location: "19.2095172,72.9732993",
Delivery_Zone: "THN",
Pickup_Start_Time: "17-07-2023 07:00",
Pickup_End_Time: "17-07-2023 07:30",
delivery_start_time: "17-07-2023 08:30",
delivery_end_time: "17-07-2023 09:00",
no_of_Orders: 1,
Delivery_Skills: 5,
Difference: "FALSE",
Handover_point: "SION",
Handover_Location: "19.0422288,72.8620784"
},
{
Id: 23,
Pickup_Location: "19.0413436,72.8433324",
Pickup_Zone: "MUM1",
Pickup_Skills: 1,
Cx_Name: "Shivani Aadhi",
City: "Mumbai",
Delivery_Location: "19.1229582,72.8840058",
Delivery_Zone: "MUM4",
Pickup_Start_Time: "17-07-2023 07:00",
Pickup_End_Time: "17-07-2023 07:30",
delivery_start_time: "17-07-2023 08:30",
delivery_end_time: "17-07-2023 09:00",
no_of_Orders: 1,
Delivery_Skills: 3,
Difference: "FALSE",
Handover_point: "SION",
Handover_Location: "19.0422288,72.8620784"
},
{
Id: 24,
Pickup_Location: "19.0413436,72.8433324",
Pickup_Zone: "MUM1",
Pickup_Skills: 1,
Cx_Name: "Kaustubh Kumbhare",
City: "Mumbai",
Delivery_Location: "19.1173012,72.8840395",
Delivery_Zone: "MUM4",
Pickup_Start_Time: "17-07-2023 07:00",
Pickup_End_Time: "17-07-2023 07:30",
delivery_start_time: "17-07-2023 08:30",
delivery_end_time: "17-07-2023 09:00",
no_of_Orders: 1,
Delivery_Skills: 3,
Difference: "FALSE",
Handover_point: "SION",
Handover_Location: "19.0422288,72.8620784"
},
{
Id: 25,
Pickup_Location: "19.0413436,72.8433324",
Pickup_Zone: "MUM1",
Pickup_Skills: 1,
Cx_Name: "Hiroshi Doisaki",
City: "Mumbai",
Delivery_Location: "19.103998,72.8721073",
Delivery_Zone: "MUM4",
Pickup_Start_Time: "17-07-2023 07:00",
Pickup_End_Time: "17-07-2023 07:30",
delivery_start_time: "17-07-2023 08:30",
delivery_end_time: "17-07-2023 09:00",
no_of_Orders: 1,
Delivery_Skills: 3,
Difference: "FALSE",
Handover_point: "SION",
Handover_Location: "19.0422288,72.8620784"
},
{
Id: 26,
Pickup_Location: "19.0413436,72.8433324",
Pickup_Zone: "MUM1",
Pickup_Skills: 1,
Cx_Name: "Priyanka Kanetkar",
City: "Mumbai",
Delivery_Location: "19.1227071,72.8797348",
Delivery_Zone: "MUM4",
Pickup_Start_Time: "17-07-2023 07:00",
Pickup_End_Time: "17-07-2023 07:30",
delivery_start_time: "17-07-2023 08:30",
delivery_end_time: "17-07-2023 09:00",
no_of_Orders: 1,
Delivery_Skills: 3,
Difference: "FALSE",
Handover_point: "SION",
Handover_Location: "19.0422288,72.8620784"
},
{
Id: 27,
Pickup_Location: "19.0413436,72.8433324",
Pickup_Zone: "MUM1",
Pickup_Skills: 1,
Cx_Name: "Ajay Singh",
City: "Mumbai",
Delivery_Location: "19.101171,72.910286",
Delivery_Zone: "MUM4",
Pickup_Start_Time: "17-07-2023 07:00",
Pickup_End_Time: "17-07-2023 07:30",
delivery_start_time: "17-07-2023 08:30",
delivery_end_time: "17-07-2023 09:00",
no_of_Orders: 1,
Delivery_Skills: 3,
Difference: "FALSE",
Handover_point: "SION",
Handover_Location: "19.0422288,72.8620784"
},
{
Id: 28,
Pickup_Location: "19.0413436,72.8433324",
Pickup_Zone: "MUM1",
Pickup_Skills: 1,
Cx_Name: "Shyam Kumar",
City: "Mumbai",
Delivery_Location: "19.1135247,72.9040445",
Delivery_Zone: "MUM4",
Pickup_Start_Time: "17-07-2023 07:00",
Pickup_End_Time: "17-07-2023 07:30",
delivery_start_time: "17-07-2023 08:30",
delivery_end_time: "17-07-2023 09:00",
no_of_Orders: 1,
Delivery_Skills: 3,
Difference: "FALSE",
Handover_point: "SION",
Handover_Location: "19.0422288,72.8620784"
},
{
Id: 29,
Pickup_Location: "19.0217311,72.8584702",
Pickup_Zone: "MUM3",
Pickup_Skills: 2,
Cx_Name: "Jimmy Cooper",
City: "Mumbai",
Delivery_Location: "19.0506687,72.9104477",
Delivery_Zone: "MUM3",
Pickup_Start_Time: "17-07-2023 11:30",
Pickup_End_Time: "17-07-2023 12:00",
delivery_start_time: "17-07-2023 13:00",
delivery_end_time: "17-07-2023 13:30",
no_of_Orders: 1,
Delivery_Skills: 2,
Difference: "TRUE",
Handover_point: "o",
Handover_Location: "NA"
},
{
Id: 30,
Pickup_Location: "19.0217311,72.8584702",
Pickup_Zone: "MUM3",
Pickup_Skills: 2,
Cx_Name: "Rhituparna Mitra",
City: "Mumbai",
Delivery_Location: "19.0889807,73.0143075",
Delivery_Zone: "NMM2",
Pickup_Start_Time: "17-07-2023 13:00",
Pickup_End_Time: "17-07-2023 13:30",
delivery_start_time: "17-07-2023 16:00",
delivery_end_time: "17-07-2023 16:30",
no_of_Orders: 1,
Delivery_Skills: 4,
Difference: "FALSE",
Handover_point: "Mankhurd Bridge",
Handover_Location: "19.051389,72.9319581"
},
{
Id: 32,
Pickup_Location: "19.0217311,72.8584702",
Pickup_Zone: "MUM3",
Pickup_Skills: 2,
Cx_Name: "RENUKA SHETTY",
City: "Mumbai",
Delivery_Location: "18.9665901,72.8094627999999",
Delivery_Zone: "MUM1",
Pickup_Start_Time: "17-07-2023 16:00",
Pickup_End_Time: "17-07-2023 16:30",
delivery_start_time: "17-07-2023 18:00",
delivery_end_time: "17-07-2023 18:30",
no_of_Orders: 1,
Delivery_Skills: 1,
Difference: "FALSE",
Handover_point: "SION",
Handover_Location: "19.0422288,72.8620784"
},
{
Id: 34,
Pickup_Location: "19.2183307,72.9780897",
Pickup_Zone: "THN",
Pickup_Skills: 5,
Cx_Name: "Neha Rawat",
City: "Mumbai",
Delivery_Location: "18.9968444,72.8246097",
Delivery_Zone: "MUM1",
Pickup_Start_Time: "17-07-2023 07:30",
Pickup_End_Time: "17-07-2023 08:00",
delivery_start_time: "17-07-2023 12:30",
delivery_end_time: "17-07-2023 13:00",
no_of_Orders: 1,
Delivery_Skills: 1,
Difference: "FALSE",
Handover_point: "SION",
Handover_Location: "19.0422288,72.8620784"
},
{
Id: 36,
Pickup_Location: "19.2183307,72.9780897",
Pickup_Zone: "THN",
Pickup_Skills: 5,
Cx_Name: "Anaya Lal",
City: "Mumbai",
Delivery_Location: "19.1413335,72.8287063",
Delivery_Zone: "MUM4",
Pickup_Start_Time: "17-07-2023 07:30",
Pickup_End_Time: "17-07-2023 08:00",
delivery_start_time: "17-07-2023 12:30",
delivery_end_time: "17-07-2023 13:00",
no_of_Orders: 1,
Delivery_Skills: 3,
Difference: "FALSE",
Handover_point: "SION",
Handover_Location: "19.0422288,72.8620784"
},
{
Id: 39,
Pickup_Location: "19.2183307,72.9780897",
Pickup_Zone: "THN",
Pickup_Skills: 5,
Cx_Name: "Dheeraj",
City: "Mumbai",
Delivery_Location: "19.1145719,72.9129274",
Delivery_Zone: "MUM4",
Pickup_Start_Time: "17-07-2023 07:30",
Pickup_End_Time: "17-07-2023 08:00",
delivery_start_time: "17-07-2023 10:00",
delivery_end_time: "17-07-2023 10:30",
no_of_Orders: 1,
Delivery_Skills: 3,
Difference: "FALSE",
Handover_point: "SION",
Handover_Location: "19.0422288,72.8620784"
},
{
Id: 40,
Pickup_Location: "19.2183307,72.9780897",
Pickup_Zone: "THN",
Pickup_Skills: 5,
Cx_Name: "Manan Vaishnav",
City: "Mumbai",
Delivery_Location: "19.0137045,72.829448",
Delivery_Zone: "MUM1",
Pickup_Start_Time: "17-07-2023 07:30",
Pickup_End_Time: "17-07-2023 08:00",
delivery_start_time: "17-07-2023 11:30",
delivery_end_time: "17-07-2023 12:00",
no_of_Orders: 1,
Delivery_Skills: 1,
Difference: "FALSE",
Handover_point: "SION",
Handover_Location: "19.0422288,72.8620784"
},
{
Id: 41,
Pickup_Location: "19.2183307,72.9780897",
Pickup_Zone: "THN",
Pickup_Skills: 5,
Cx_Name: "Mitali Vakil",
City: "Mumbai",
Delivery_Location: "18.9545549,72.7968398",
Delivery_Zone: "MUM1",
Pickup_Start_Time: "17-07-2023 07:30",
Pickup_End_Time: "17-07-2023 08:00",
delivery_start_time: "17-07-2023 10:30",
delivery_end_time: "17-07-2023 11:00",
no_of_Orders: 1,
Delivery_Skills: 1,
Difference: "FALSE",
Handover_point: "SION",
Handover_Location: "19.0422288,72.8620784"
},
{
Id: 43,
Pickup_Location: "19.2183307,72.9780897",
Pickup_Zone: "THN",
Pickup_Skills: 5,
Cx_Name: "Prerna Arora",
City: "Mumbai",
Delivery_Location: "19.1239285,72.9094406999999",
Delivery_Zone: "MUM4",
Pickup_Start_Time: "17-07-2023 07:30",
Pickup_End_Time: "17-07-2023 08:00",
delivery_start_time: "17-07-2023 10:00",
delivery_end_time: "17-07-2023 10:30",
no_of_Orders: 1,
Delivery_Skills: 3,
Difference: "FALSE",
Handover_point: "SION",
Handover_Location: "19.0422288,72.8620784"
},
{
Id: 45,
Pickup_Location: "19.2183307,72.9780897",
Pickup_Zone: "THN",
Pickup_Skills: 5,
Cx_Name: "Dakshata",
City: "Mumbai",
Delivery_Location: "19.0526588,72.8920924999999",
Delivery_Zone: "MUM3",
Pickup_Start_Time: "17-07-2023 07:30",
Pickup_End_Time: "17-07-2023 08:00",
delivery_start_time: "17-07-2023 11:30",
delivery_end_time: "17-07-2023 12:00",
no_of_Orders: 1,
Delivery_Skills: 2,
Difference: "FALSE",
Handover_point: "SION",
Handover_Location: "19.0422288,72.8620784"
},
{
Id: 48,
Pickup_Location: "19.2183307,72.9780897",
Pickup_Zone: "THN",
Pickup_Skills: 5,
Cx_Name: "NATARAJAN SUBRAMANIAM",
City: "Mumbai",
Delivery_Location: "19.0945991,72.8992025",
Delivery_Zone: "MUM3",
Pickup_Start_Time: "17-07-2023 14:30",
Pickup_End_Time: "17-07-2023 15:00",
delivery_start_time: "17-07-2023 18:30",
delivery_end_time: "17-07-2023 19:00",
no_of_Orders: 1,
Delivery_Skills: 2,
Difference: "FALSE",
Handover_point: "SION",
Handover_Location: "19.0422288,72.8620784"
},
{
Id: 50,
Pickup_Location: "19.2183307,72.9780897",
Pickup_Zone: "THN",
Pickup_Skills: 5,
Cx_Name: "Surbhi Sen",
City: "Mumbai",
Delivery_Location: "19.0550026,73.0673388",
Delivery_Zone: "NMM2",
Pickup_Start_Time: "17-07-2023 14:30",
Pickup_End_Time: "17-07-2023 15:00",
delivery_start_time: "17-07-2023 19:00",
delivery_end_time: "17-07-2023 19:30",
no_of_Orders: 1,
Delivery_Skills: 4,
Difference: "FALSE",
Handover_point: "SION",
Handover_Location: "19.0422288,72.8620784"
},
{
Id: 51,
Pickup_Location: "19.2183307,72.9780897",
Pickup_Zone: "THN",
Pickup_Skills: 5,
Cx_Name: "Pranali Kadrekar",
City: "Mumbai",
Delivery_Location: "19.1331626,72.8233997",
Delivery_Zone: "MUM4",
Pickup_Start_Time: "17-07-2023 14:30",
Pickup_End_Time: "17-07-2023 15:00",
delivery_start_time: "17-07-2023 17:30",
delivery_end_time: "17-07-2023 18:00",
no_of_Orders: 1,
Delivery_Skills: 3,
Difference: "FALSE",
Handover_point: "SION",
Handover_Location: "19.0422288,72.8620784"
},
{
Id: 52,
Pickup_Location: "19.2183307,72.9780897",
Pickup_Zone: "THN",
Pickup_Skills: 5,
Cx_Name: "Mitali Vakil",
City: "Mumbai",
Delivery_Location: "18.9545549,72.7968398",
Delivery_Zone: "MUM1",
Pickup_Start_Time: "17-07-2023 14:30",
Pickup_End_Time: "17-07-2023 15:00",
delivery_start_time: "17-07-2023 18:00",
delivery_end_time: "17-07-2023 18:30",
no_of_Orders: 1,
Delivery_Skills: 1,
Difference: "FALSE",
Handover_point: "SION",
Handover_Location: "19.0422288,72.8620784"
},
{
Id: 53,
Pickup_Location: "19.2183307,72.9780897",
Pickup_Zone: "THN",
Pickup_Skills: 5,
Cx_Name: "Prerna Arora",
City: "Mumbai",
Delivery_Location: "19.1239285,72.9094406999999",
Delivery_Zone: "MUM4",
Pickup_Start_Time: "17-07-2023 14:30",
Pickup_End_Time: "17-07-2023 15:00",
delivery_start_time: "17-07-2023 16:30",
delivery_end_time: "17-07-2023 17:00",
no_of_Orders: 1,
Delivery_Skills: 3,
Difference: "FALSE",
Handover_point: "SION",
Handover_Location: "19.0422288,72.8620784"
},
{
Id: 55,
Pickup_Location: "19.2183307,72.9780897",
Pickup_Zone: "THN",
Pickup_Skills: 5,
Cx_Name: "monica juvekar",
City: "Mumbai",
Delivery_Location: "19.2599828,72.9862392",
Delivery_Zone: "THN",
Pickup_Start_Time: "17-07-2023 14:30",
Pickup_End_Time: "17-07-2023 15:00",
delivery_start_time: "17-07-2023 16:30",
delivery_end_time: "17-07-2023 17:00",
no_of_Orders: 1,
Delivery_Skills: 5,
Difference: "TRUE",
Handover_point: "o",
Handover_Location: "NA"
},
{
Id: 56,
Pickup_Location: "19.2183307,72.9780897",
Pickup_Zone: "THN",
Pickup_Skills: 5,
Cx_Name: "Dr. Neelu",
City: "Mumbai",
Delivery_Location: "19.1618187,72.9438633",
Delivery_Zone: "THN",
Pickup_Start_Time: "17-07-2023 14:30",
Pickup_End_Time: "17-07-2023 15:00",
delivery_start_time: "17-07-2023 17:00",
delivery_end_time: "17-07-2023 17:30",
no_of_Orders: 1,
Delivery_Skills: 5,
Difference: "TRUE",
Handover_point: "o",
Handover_Location: "NA"
},
{
Id: 57,
Pickup_Location: "19.2183307,72.9780897",
Pickup_Zone: "THN",
Pickup_Skills: 5,
Cx_Name: "Priyanka Palwankar",
City: "Mumbai",
Delivery_Location: "19.2836895,72.9541998",
Delivery_Zone: "THN",
Pickup_Start_Time: "17-07-2023 14:30",
Pickup_End_Time: "17-07-2023 15:00",
delivery_start_time: "17-07-2023 17:00",
delivery_end_time: "17-07-2023 17:30",
no_of_Orders: 1,
Delivery_Skills: 5,
Difference: "TRUE",
Handover_point: "o",
Handover_Location: "NA"
},
{
Id: 58,
Pickup_Location: "19.2183307,72.9780897",
Pickup_Zone: "THN",
Pickup_Skills: 5,
Cx_Name: "Anjali Hariprasad",
City: "Mumbai",
Delivery_Location: "19.2322091,72.9753984",
Delivery_Zone: "THN",
Pickup_Start_Time: "17-07-2023 14:30",
Pickup_End_Time: "17-07-2023 15:00",
delivery_start_time: "17-07-2023 17:30",
delivery_end_time: "17-07-2023 18:00",
no_of_Orders: 1,
Delivery_Skills: 5,
Difference: "TRUE",
Handover_point: "o",
Handover_Location: "NA"
},
{
Id: 59,
Pickup_Location: "19.2183307,72.9780897",
Pickup_Zone: "THN",
Pickup_Skills: 5,
Cx_Name: "Vasanti",
City: "Mumbai",
Delivery_Location: "19.1193,72.9116349999999",
Delivery_Zone: "THN",
Pickup_Start_Time: "17-07-2023 14:30",
Pickup_End_Time: "17-07-2023 15:00",
delivery_start_time: "17-07-2023 18:00",
delivery_end_time: "17-07-2023 18:30",
no_of_Orders: 1,
Delivery_Skills: 5,
Difference: "TRUE",
Handover_point: "o",
Handover_Location: "NA"
},
{
Id: 60,
Pickup_Location: "19.2183307,72.9780897",
Pickup_Zone: "THN",
Pickup_Skills: 5,
Cx_Name: "Krish",
City: "Mumbai",
Delivery_Location: "19.0222268,72.8600635",
Delivery_Zone: "MUM3",
Pickup_Start_Time: "17-07-2023 14:30",
Pickup_End_Time: "17-07-2023 15:00",
delivery_start_time: "17-07-2023 18:30",
delivery_end_time: "17-07-2023 19:00",
no_of_Orders: 1,
Delivery_Skills: 2,
Difference: "FALSE",
Handover_point: "JVLR Junction",
Handover_Location: "19.124199,72.938451"
},
{
Id: 61,
Pickup_Location: "19.2183307,72.9780897",
Pickup_Zone: "THN",
Pickup_Skills: 5,
Cx_Name: "Vrinda Makhija",
City: "Mumbai",
Delivery_Location: "19.045479,72.8909618",
Delivery_Zone: "MUM3",
Pickup_Start_Time: "17-07-2023 14:30",
Pickup_End_Time: "17-07-2023 15:00",
delivery_start_time: "17-07-2023 18:00",
delivery_end_time: "17-07-2023 18:30",
no_of_Orders: 1,
Delivery_Skills: 2,
Difference: "FALSE",
Handover_point: "JVLR Junction",
Handover_Location: "19.124199,72.938451"
},
{
Id: 63,
Pickup_Location: "19.1244872,72.8691749",
Pickup_Zone: "MUM4",
Pickup_Skills: 3,
Cx_Name: "Mrinal Achrekar",
City: "Mumbai",
Delivery_Location: "19.1875,72.969227",
Delivery_Zone: "THN",
Pickup_Start_Time: "17-07-2023 10:00",
Pickup_End_Time: "17-07-2023 10:30",
delivery_start_time: "17-07-2023 12:30",
delivery_end_time: "17-07-2023 13:00",
no_of_Orders: 1,
Delivery_Skills: 5,
Difference: "FALSE",
Handover_point: "JVLR Junction",
Handover_Location: "19.124199,72.938451"
},
{
Id: 66,
Pickup_Location: "19.1244872,72.8691749",
Pickup_Zone: "MUM4",
Pickup_Skills: 3,
Cx_Name: "Ashwini Manerikar",
City: "Mumbai",
Delivery_Location: "19.2161572,72.9560276",
Delivery_Zone: "THN",
Pickup_Start_Time: "17-07-2023 16:00",
Pickup_End_Time: "17-07-2023 16:30",
delivery_start_time: "17-07-2023 19:00",
delivery_end_time: "17-07-2023 19:30",
no_of_Orders: 1,
Delivery_Skills: 5,
Difference: "FALSE",
Handover_point: "JVLR Junction",
Handover_Location: "19.124199,72.938451"
},
{
Id: 67,
Pickup_Location: "19.1097712,72.8582672",
Pickup_Zone: "MUM4",
Pickup_Skills: 3,
Cx_Name: "Anuja Jain",
City: "Mumbai",
Delivery_Location: "19.1403097,72.8381529",
Delivery_Zone: "MUM4",
Pickup_Start_Time: "17-07-2023 10:00",
Pickup_End_Time: "17-07-2023 10:30",
delivery_start_time: "17-07-2023 11:00",
delivery_end_time: "17-07-2023 11:30",
no_of_Orders: 1,
Delivery_Skills: 3,
Difference: "TRUE",
Handover_point: "o",
Handover_Location: "NA"
},
{
Id: 68,
Pickup_Location: "19.1097712,72.8582672",
Pickup_Zone: "MUM4",
Pickup_Skills: 3,
Cx_Name: "Swati Vasan",
City: "Mumbai",
Delivery_Location: "19.0499116,72.9066747999999",
Delivery_Zone: "MUM3",
Pickup_Start_Time: "17-07-2023 10:30",
Pickup_End_Time: "17-07-2023 11:00",
delivery_start_time: "17-07-2023 12:30",
delivery_end_time: "17-07-2023 13:00",
no_of_Orders: 1,
Delivery_Skills: 2,
Difference: "FALSE",
Handover_point: "JVLR Junction",
Handover_Location: "19.124199,72.938451"
},
{
Id: 69,
Pickup_Location: "19.1097712,72.8582672",
Pickup_Zone: "MUM4",
Pickup_Skills: 3,
Cx_Name: "Suresh Kumar",
City: "Mumbai",
Delivery_Location: "19.1137308,72.8611943",
Delivery_Zone: "MUM4",
Pickup_Start_Time: "17-07-2023 10:30",
Pickup_End_Time: "17-07-2023 11:00",
delivery_start_time: "17-07-2023 12:30",
delivery_end_time: "17-07-2023 13:00",
no_of_Orders: 1,
Delivery_Skills: 3,
Difference: "TRUE",
Handover_point: "o",
Handover_Location: "NA"
},
{
Id: 70,
Pickup_Location: "19.1097712,72.8582672",
Pickup_Zone: "MUM4",
Pickup_Skills: 3,
Cx_Name: "Sanjana Kamat",
City: "Mumbai",
Delivery_Location: "19.0759837,72.8776559",
Delivery_Zone: "MUM1",
Pickup_Start_Time: "17-07-2023 10:30",
Pickup_End_Time: "17-07-2023 11:00",
delivery_start_time: "17-07-2023 12:30",
delivery_end_time: "17-07-2023 13:00",
no_of_Orders: 1,
Delivery_Skills: 1,
Difference: "FALSE",
Handover_point: "JVLR Junction",
Handover_Location: "19.124199,72.938451"
},
{
Id: 71,
Pickup_Location: "19.1097712,72.8582672",
Pickup_Zone: "MUM4",
Pickup_Skills: 3,
Cx_Name: "Jinita Shah",
City: "Mumbai",
Delivery_Location: "19.1699931,72.9442019999999",
Delivery_Zone: "THN",
Pickup_Start_Time: "17-07-2023 10:30",
Pickup_End_Time: "17-07-2023 11:00",
delivery_start_time: "17-07-2023 12:30",
delivery_end_time: "17-07-2023 13:00",
no_of_Orders: 1,
Delivery_Skills: 5,
Difference: "FALSE",
Handover_point: "JVLR Junction",
Handover_Location: "19.124199,72.938451"
},
{
Id: 74,
Pickup_Location: "19.1097712,72.8582672",
Pickup_Zone: "MUM4",
Pickup_Skills: 3,
Cx_Name: "Karan Nirbhavne",
City: "Mumbai",
Delivery_Location: "19.0641849,72.8908314999999",
Delivery_Zone: "MUM3",
Pickup_Start_Time: "17-07-2023 10:30",
Pickup_End_Time: "17-07-2023 11:00",
delivery_start_time: "17-07-2023 12:30",
delivery_end_time: "17-07-2023 13:00",
no_of_Orders: 1,
Delivery_Skills: 2,
Difference: "FALSE",
Handover_point: "JVLR Junction",
Handover_Location: "19.124199,72.938451"
},
{
Id: 75,
Pickup_Location: "19.1097712,72.8582672",
Pickup_Zone: "MUM4",
Pickup_Skills: 3,
Cx_Name: "Krunal",
City: "Mumbai",
Delivery_Location: "19.2058651,72.9554685",
Delivery_Zone: "THN",
Pickup_Start_Time: "17-07-2023 11:30",
Pickup_End_Time: "17-07-2023 12:00",
delivery_start_time: "17-07-2023 12:30",
delivery_end_time: "17-07-2023 13:00",
no_of_Orders: 1,
Delivery_Skills: 5,
Difference: "FALSE",
Handover_point: "JVLR Junction",
Handover_Location: "19.124199,72.938451"
},
{
Id: 76,
Pickup_Location: "19.1097712,72.8582672",
Pickup_Zone: "MUM4",
Pickup_Skills: 3,
Cx_Name: "Priya Iyer",
City: "Mumbai",
Delivery_Location: "19.1453453,72.9352244999999",
Delivery_Zone: "MUM4",
Pickup_Start_Time: "17-07-2023 14:00",
Pickup_End_Time: "17-07-2023 14:30",
delivery_start_time: "17-07-2023 16:00",
delivery_end_time: "17-07-2023 16:30",
no_of_Orders: 1,
Delivery_Skills: 3,
Difference: "TRUE",
Handover_point: "o",
Handover_Location: "NA"
},
{
Id: 77,
Pickup_Location: "19.1097712,72.8582672",
Pickup_Zone: "MUM4",
Pickup_Skills: 3,
Cx_Name: "Lekshmi",
City: "Mumbai",
Delivery_Location: "19.1428595,72.9309878",
Delivery_Zone: "THN",
Pickup_Start_Time: "17-07-2023 15:30",
Pickup_End_Time: "17-07-2023 16:00",
delivery_start_time: "17-07-2023 19:00",
delivery_end_time: "17-07-2023 19:30",
no_of_Orders: 1,
Delivery_Skills: 5,
Difference: "FALSE",
Handover_point: "JVLR Junction",
Handover_Location: "19.124199,72.938451"
},
{
Id: 78,
Pickup_Location: "19.1097712,72.8582672",
Pickup_Zone: "MUM4",
Pickup_Skills: 3,
Cx_Name: "Jayanti Parmeshwar",
City: "Mumbai",
Delivery_Location: "19.0587825,72.8909974",
Delivery_Zone: "MUM3",
Pickup_Start_Time: "17-07-2023 15:30",
Pickup_End_Time: "17-07-2023 16:00",
delivery_start_time: "17-07-2023 19:00",
delivery_end_time: "17-07-2023 19:30",
no_of_Orders: 1,
Delivery_Skills: 2,
Difference: "FALSE",
Handover_point: "Bhandup Pumping",
Handover_Location: "19.1546808,72.9553981"
},
{
Id: 79,
Pickup_Location: "19.1097712,72.8582672",
Pickup_Zone: "MUM4",
Pickup_Skills: 3,
Cx_Name: "Sugandhi Vasudevan",
City: "Mumbai",
Delivery_Location: "19.0574838,72.8901772999999",
Delivery_Zone: "MUM3",
Pickup_Start_Time: "17-07-2023 15:30",
Pickup_End_Time: "17-07-2023 16:00",
delivery_start_time: "17-07-2023 18:00",
delivery_end_time: "17-07-2023 18:30",
no_of_Orders: 1,
Delivery_Skills: 2,
Difference: "FALSE",
Handover_point: "JVLR Junction",
Handover_Location: "19.124199,72.938451"
},
{
Id: 81,
Pickup_Location: "19.1097712,72.8582672",
Pickup_Zone: "MUM4",
Pickup_Skills: 3,
Cx_Name: "Insiya Relekar",
City: "Mumbai",
Delivery_Location: "19.2603355,72.9713156999999",
Delivery_Zone: "THN",
Pickup_Start_Time: "17-07-2023 15:30",
Pickup_End_Time: "17-07-2023 16:00",
delivery_start_time: "17-07-2023 18:30",
delivery_end_time: "17-07-2023 19:00",
no_of_Orders: 1,
Delivery_Skills: 5,
Difference: "FALSE",
Handover_point: "JVLR Junction",
Handover_Location: "19.124199,72.938451"
},
{
Id: 82,
Pickup_Location: "19.1097712,72.8582672",
Pickup_Zone: "MUM4",
Pickup_Skills: 3,
Cx_Name: "Gauravi",
City: "Mumbai",
Delivery_Location: "19.2572501,72.9719806",
Delivery_Zone: "THN",
Pickup_Start_Time: "17-07-2023 15:30",
Pickup_End_Time: "17-07-2023 16:00",
delivery_start_time: "17-07-2023 18:00",
delivery_end_time: "17-07-2023 18:30",
no_of_Orders: 1,
Delivery_Skills: 5,
Difference: "FALSE",
Handover_point: "Bhandup Pumping",
Handover_Location: "19.1546808,72.9553981"
},
{
Id: 83,
Pickup_Location: "19.1097712,72.8582672",
Pickup_Zone: "MUM4",
Pickup_Skills: 3,
Cx_Name: "Anushka",
City: "Mumbai",
Delivery_Location: "19.0927642,72.9136195999999",
Delivery_Zone: "MUM3",
Pickup_Start_Time: "17-07-2023 15:30",
Pickup_End_Time: "17-07-2023 16:00",
delivery_start_time: "17-07-2023 18:30",
delivery_end_time: "17-07-2023 19:00",
no_of_Orders: 1,
Delivery_Skills: 2,
Difference: "FALSE",
Handover_point: "JVLR Junction",
Handover_Location: "19.124199,72.938451"
},
{
Id: 84,
Pickup_Location: "19.1097712,72.8582672",
Pickup_Zone: "MUM4",
Pickup_Skills: 3,
Cx_Name: "Poornima",
City: "Mumbai",
Delivery_Location: "19.0523986,72.9023211",
Delivery_Zone: "MUM3",
Pickup_Start_Time: "17-07-2023 15:30",
Pickup_End_Time: "17-07-2023 16:00",
delivery_start_time: "17-07-2023 18:30",
delivery_end_time: "17-07-2023 19:00",
no_of_Orders: 1,
Delivery_Skills: 2,
Difference: "FALSE",
Handover_point: "JVLR Junction",
Handover_Location: "19.124199,72.938451"
},
{
Id: 85,
Pickup_Location: "19.1097712,72.8582672",
Pickup_Zone: "MUM4",
Pickup_Skills: 3,
Cx_Name: "Shweta",
City: "Mumbai",
Delivery_Location: "19.113645,72.8697339",
Delivery_Zone: "MUM4",
Pickup_Start_Time: "17-07-2023 15:30",
Pickup_End_Time: "17-07-2023 16:00",
delivery_start_time: "17-07-2023 18:30",
delivery_end_time: "17-07-2023 19:00",
no_of_Orders: 1,
Delivery_Skills: 3,
Difference: "TRUE",
Handover_point: "o",
Handover_Location: "NA"
},
{
Id: 86,
Pickup_Location: "19.1097712,72.8582672",
Pickup_Zone: "MUM4",
Pickup_Skills: 3,
Cx_Name: "Meghna Dongre",
City: "Mumbai",
Delivery_Location: "19.1058279,72.8999841",
Delivery_Zone: "MUM4",
Pickup_Start_Time: "17-07-2023 15:30",
Pickup_End_Time: "17-07-2023 16:00",
delivery_start_time: "17-07-2023 19:00",
delivery_end_time: "17-07-2023 19:30",
no_of_Orders: 1,
Delivery_Skills: 3,
Difference: "TRUE",
Handover_point: "o",
Handover_Location: "NA"
},
{
Id: 87,
Pickup_Location: "19.1127721,72.8478788",
Pickup_Zone: "MUM4",
Pickup_Skills: 3,
Cx_Name: "Mrunal Kulkarni",
City: "Mumbai",
Delivery_Location: "19.0759837,72.8776559",
Delivery_Zone: "THN",
Pickup_Start_Time: "17-07-2023 10:00",
Pickup_End_Time: "17-07-2023 10:30",
delivery_start_time: "17-07-2023 12:30",
delivery_end_time: "17-07-2023 13:00",
no_of_Orders: 1,
Delivery_Skills: 5,
Difference: "FALSE",
Handover_point: "JVLR Junction",
Handover_Location: "19.124199,72.938451"
},
{
Id: 91,
Pickup_Location: "19.1127721,72.8478788",
Pickup_Zone: "MUM4",
Pickup_Skills: 3,
Cx_Name: "Ketki Joshi",
City: "Mumbai",
Delivery_Location: "19.1007674,72.8830242",
Delivery_Zone: "MUM4",
Pickup_Start_Time: "17-07-2023 16:00",
Pickup_End_Time: "17-07-2023 16:30",
delivery_start_time: "17-07-2023 18:00",
delivery_end_time: "17-07-2023 18:30",
no_of_Orders: 1,
Delivery_Skills: 3,
Difference: "TRUE",
Handover_point: "o",
Handover_Location: "NA"
},
{
Id: 92,
Pickup_Location: "19.1127721,72.8478788",
Pickup_Zone: "MUM4",
Pickup_Skills: 3,
Cx_Name: "Rudra Deosthali",
City: "Mumbai",
Delivery_Location: "18.9280162,72.8220979",
Delivery_Zone: "MUM1",
Pickup_Start_Time: "17-07-2023 16:00",
Pickup_End_Time: "17-07-2023 16:30",
delivery_start_time: "17-07-2023 18:00",
delivery_end_time: "17-07-2023 18:30",
no_of_Orders: 1,
Delivery_Skills: 1,
Difference: "FALSE",
Handover_point: "SION",
Handover_Location: "19.0422288,72.8620784"
},
{
Id: 95,
Pickup_Location: "19.1127721,72.8478788",
Pickup_Zone: "MUM4",
Pickup_Skills: 3,
Cx_Name: "Swanandi",
City: "Mumbai",
Delivery_Location: "19.021431,72.847121",
Delivery_Zone: "MUM1",
Pickup_Start_Time: "17-07-2023 16:00",
Pickup_End_Time: "17-07-2023 16:30",
delivery_start_time: "17-07-2023 18:00",
delivery_end_time: "17-07-2023 18:30",
no_of_Orders: 1,
Delivery_Skills: 1,
Difference: "FALSE",
Handover_point: "SION",
Handover_Location: "19.0422288,72.8620784"
},
{
Id: 96,
Pickup_Location: "19.1127721,72.8478788",
Pickup_Zone: "MUM4",
Pickup_Skills: 3,
Cx_Name: "Vivekkumar Margam",
City: "Mumbai",
Delivery_Location: "18.9988295,72.8276284",
Delivery_Zone: "MUM1",
Pickup_Start_Time: "17-07-2023 16:00",
Pickup_End_Time: "17-07-2023 16:30",
delivery_start_time: "17-07-2023 18:00",
delivery_end_time: "17-07-2023 18:30",
no_of_Orders: 1,
Delivery_Skills: 1,
Difference: "FALSE",
Handover_point: "SION",
Handover_Location: "19.0422288,72.8620784"
},
{
Id: 97,
Pickup_Location: "19.018856,73.0175905999999",
Pickup_Zone: "NMM2",
Pickup_Skills: 4,
Cx_Name: "Dr Arun Mishra",
City: "Mumbai",
Delivery_Location: "19.0172337,72.8469138999999",
Delivery_Zone: "MUM1",
Pickup_Start_Time: "17-07-2023 10:00",
Pickup_End_Time: "17-07-2023 10:30",
delivery_start_time: "17-07-2023 12:00",
delivery_end_time: "17-07-2023 12:30",
no_of_Orders: 1,
Delivery_Skills: 1,
Difference: "FALSE",
Handover_point: "JVLR Junction",
Handover_Location: "19.124199,72.938451"
}
];
function convertTimeToEpoch(dateString) {
let dateTimeSplit = dateString.split(" ");
let dateSplit = dateTimeSplit[0].split("-");
let timeSplit = dateTimeSplit[1].split(":");
let date = new Date();
date.setFullYear(dateSplit[2], dateSplit[1] - 1, dateSplit[0]);
date.setHours(timeSplit[0], timeSplit[1], 0, 0);
return date.getTime() / 1000;
}
let increment = 0;
let i = 0;
let k = 0;
orders.forEach(function (element) {
let checkIfSameZone = element.Difference;
console.log("start");
switch (checkIfSameZone) {
case "FALSE":
let object1 = new Object();
object1.amount = [element.no_of_Orders];
object1.skills = [element.Pickup_Skills];
object1.pickup = new Object();
object1.pickup.id = k;
object1.pickup.description = "ID:" + element.Id + ";Type:Handover";
input_json.locations.location.push(element.Pickup_Location);
object1.pickup.location_index = increment;
increment++;
object1.pickup.service = 60;
object1.pickup.time_windows = [
[
convertTimeToEpoch(element.Pickup_Start_Time),
convertTimeToEpoch(element.Pickup_End_Time)
]
];
object1.delivery = new Object();
object1.delivery.id = k;
k++;
object1.delivery.description = "ID:" + element.Id + ";Type:Handover";
input_json.locations.location.push(element.Handover_Location);
object1.delivery.location_index = increment;
increment++;
object1.delivery.service = 120;
input_json.shipments.push(object1);
let object2 = new Object();
object2.amount = [element.no_of_Orders];
object2.skills = [element.Delivery_Skills];
object2.pickup = new Object();
object2.pickup.id = k;
object2.pickup.description = "ID:" + element.Id + ";Type:Handover";
input_json.locations.location.push(element.Handover_Location);
object2.pickup.location_index = increment;
increment++;
object2.pickup.service = 60;
object2.delivery = new Object();
object2.delivery.id = k;
k++;
object2.delivery.description = "ID:" + element.Id + ";Type:Handover";
input_json.locations.location.push(element.Delivery_Location);
object2.delivery.location_index = increment;
increment++;
object2.delivery.service = 120;
object2.delivery.time_windows = [
[
convertTimeToEpoch(element.delivery_start_time),
convertTimeToEpoch(element.delivery_end_time)
]
];
input_json.shipments.push(object2);
console.log(i++);
break;
case "TRUE":
let object3 = new Object();
object3.amount = [element.no_of_Orders];
object3.skills = [element.Pickup_Skills];
object3.pickup = new Object();
object3.pickup.id = k;
object3.pickup.description = "ID:" + element.Id + ";Type:Direct";
input_json.locations.location.push(element.Pickup_Location);
object3.pickup.location_index = increment;
increment++;
object3.pickup.service = 60;
object3.pickup.time_windows = [
[
convertTimeToEpoch(element.Pickup_Start_Time),
convertTimeToEpoch(element.Pickup_End_Time)
]
];
object3.delivery = new Object();
object3.delivery.id = k;
k++;
object3.delivery.description = "ID:" + element.Id + ";Type:Direct";
input_json.locations.location.push(element.Delivery_Location);
object3.delivery.location_index = increment;
increment++;
object3.delivery.service = 120;
object3.delivery.time_windows = [
[
convertTimeToEpoch(element.delivery_start_time),
convertTimeToEpoch(element.delivery_end_time)
]
];
input_json.shipments.push(object3);
console.log(i++);
break;
default:
console.log("WRONG INFO");
}
console.log("end");
});
let length = input_json.locations.location.length;
console.log(length);
input_vehicles.forEach(function (vehicle) {
let vehObj = new Object();
input_json.locations.location.push(vehicle.Start_Location);
vehObj.start_index = length;
length = length + 1;
vehObj.id = vehicle.Id;
vehObj.description = "ID:" + vehicle.Vehicle + "; Zone: " + vehicle.Zone;
vehObj.capacity = [vehicle.Capacity];
vehObj.skills = [vehicle.Skills];
input_json.vehicles.push(vehObj);
});
console.log("endForAll");
let result = {
vehicles: input_json.vehicles,
shipments: input_json.shipments,
options: input_json.options,
locations: input_json.locations,
input_json: input_json
};
let jsonString = JSON.stringify(result);
console.log(jsonString);
return result;
}
One platform to build and deploy the best data apps
Experiment and prototype by building visualizations in live JavaScript notebooks. Collaborate with your team and decide which concepts to build out.
Use Observable Framework to build data apps locally. Use data loaders to build in any language or library, including Python, SQL, and R.
Seamlessly deploy to Observable. Test before you ship, use automatic deploy-on-commit, and ensure your projects are always up-to-date.