2b:null 2c:["$","title",null,{"children":"Food Delivery | NB.AI Solutions Team | Observable"}] 31:T15db, ### Introduction Food delivery route optimisation is the solution to the problems faced by the Food delivery service providers. It's a sophisticated process that leverages cutting-edge technology and mathematical algorithms to design the most efficient routes for delivery drivers. By optimising delivery routes, businesses in the food industry can achieve several crucial objectives: Cost Reduction: Optimised routes minimize fuel consumption and reduce overall operational costs, enhancing a company's profitability. Faster Deliveries: Customers receive their orders more quickly, leading to higher satisfaction and potentially increased customer loyalty. Environmental Benefits: Reduced mileage and fuel consumption contribute to a smaller carbon footprint, aligning with sustainability goals. Resource Management: Delivery vehicles, drivers, and time are all utilised more effectively, increasing the productivity of the workforce. Improved Customer Experience: Reliable, timely deliveries lead to happier customers, which can drive positive reviews and word-of-mouth recommendations. In the following sections, we will delve deeper into the methods, technologies, and real-world applications that power this essential aspect of modern food delivery services. Whether you're a restaurant owner, a logistics manager, or simply someone curious about the mechanics of your favourite food arriving promptly at your door, this journey promises to reveal the intricate art and science behind efficient food delivery route planning.
### Problem Statement This notebook provides an overview of Nextbillion.ai's route optimization solution implemented for a food delivery company in India. The company specializes in delivering pre-booked orders of freshly prepared meals to customers within a strict two-hour window following food preparation, or at a time specified by the customer. Unlike a conventional pickup and delivery problem, this company has intricately divided its service areas into various zones, with each zone being allocated a dedicated team of delivery executives and vehicles. The key challenge lies in the fact that customers have the flexibility to place food orders from any location, irrespective of the predefined zones. However, the delivery executives are not allowed to cross zone boundaries during the delivery process. To address this challenge, the company has established multiple designated handover points strategically placed within the zones. Here's how the process works: if a customer places an order from a location outside their assigned zone, the delivery executive from the food preparation zone takes charge. They pick up the order and deliver it to the specified handover location within their zone. Subsequently, the delivery executive assigned to the customer's zone takes over, picking up the order from the handover point and completing the final delivery to the customer's specified address. This intricate system ensures efficient and zone-compliant food deliveries, even when customers order from outside their designated zones. Nextbillion.ai's route optimization solution plays a pivotal role in orchestrating this complex operation, streamlining the delivery process, and enhancing the overall customer experience.
### Solution Approach for Efficient Vehicle Allocation and Route Optimization: Inputs: We begin with the allocation of vehicles to each specific zone, each vehicle's unique details including its identification, starting location, and additional relevant information. We also consider the pickup locations of hotels, complete with latitude and longitude coordinates, along with corresponding zone assignments and designated pickup time windows. Additionally, we gather data on customers' delivery addresses, their respective geographical zones, and specified delivery time windows. Our optimization process revolves around allocating vehicles to zones in a strategic manner, primarily for the purpose of pickups. When the delivery destination is within the same zone, our delivery executives will handle the entire delivery process, transporting the food directly to the customer. However, when the delivery spans different zones, our optimization system employs a two-step process: Handover Location Assignment: We designate a handover location as the drop-off point for the executive responsible for the initial food pickup. This ensures smooth transitions between zones. Zone-Specific Delivery Assignment: Subsequently, we allocate the delivery task to an executive situated within the customer's zone. This executive retrieves the order from the designated handover location and completes the delivery to the customer's address. Our route optimization algorithm rigorously analyzes the available data and generates efficient delivery routes. This involves the careful assignment of orders to our field delivery executives, maximizing efficiency and ensuring timely deliveries. For detailed information and technical specifications, please consult our API documentation available at API Documentation. Our API documentation provides comprehensive insights into our optimization strategies and how to leverage our services effectively for your business needs.
In this tutorial, we'll guide you through the steps that you can take to build, solve, and visualize complex multi-vehicle routing problem applied to this particular Use-Case.

Refer to the API documentation at this page for more supporting details: [API doc](https://docs.nextbillion.ai/docs/optimization/api/route-optimization-v2) 32:Tabba,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; }33:T680,inputs = { let tomorrowStart = new Date(); tomorrowStart.setDate(new Date().getDate() + 1); tomorrowStart.setHours(6); tomorrowStart.setMinutes(0); tomorrowStart.setSeconds(0); tomorrowStart.setMilliseconds(0); let tomorrowEnd = new Date(); tomorrowEnd.setDate(new Date().getDate() + 1); tomorrowEnd.setHours(9); tomorrowEnd.setMinutes(0); tomorrowEnd.setSeconds(0); tomorrowEnd.setMilliseconds(0); let startISOTime = new Date(tomorrowStart).toISOString().slice(0, -1) + "-04:00"; let endISOTime = new Date(tomorrowEnd).toISOString().slice(0, -1) + "-04:00"; const inputs = { city: Inputs.select(cities, { label: "Select city", format: (x) => x.name, value: cities.find((t) => t.name === "Paris") }), jobs: Inputs.select(jobs, { label: "Number of Employees", value: "25" }), vehicles: Inputs.select(vehicles, { label: "Number of vehicles", value: "10" }), maxDriveTime: Inputs.number({ label: "Max Drive Time (in minutes)", value: 160 }), shiftEnd: Inputs.datetime({ label: "Shift End", value: endISOTime }), useCase: Inputs.select(useCases, { label: "Use Case", format: (x) => x.name, value: useCases.find((t) => t.name === "service") }), objectiveFunction: Inputs.select(objectives, { label: "Objective Function", format: (x) => x.name, value: objectives.find((t) => t.name === "Minimize Time") }), serviceTime: Inputs.text({ label: "Service Time at Each Stop", value: "30" }), capacity: Inputs.text({ label: "Capacity", value: "6" }) }; return inputs; }34:T550,routesGeoJson = { let routesGeoJson = { type: "FeatureCollection", features: [] }; // we create a geojson object to send to our mapview elements // It will be a feature collection of all the route polylines checkStatus.result.routes.forEach((rte, idx) => { //console.log(rte); let feature = { type: "Feature", properties: { id: rte.vehicle, vin: rte.description }, geometry: { coordinates: nextbillion.utils.polyline .decode(rte.geometry, 5) .map((c) => c.reverse()), type: "LineString" } }; routesGeoJson.features.push(feature); rte.steps.forEach((st, stIdx) => { let epochGMT = st.arrival; let ISTOffset = 3.5 * 60 * 60; let epochIST = epochGMT + ISTOffset; let stop = { type: "Feature", properties: { id: rte.vehicle, vin: rte.description, description: st.description, stop_idx: stIdx, arrival: epochIST, type: st.type, pointType: (st.type == "start") | (st.type == "end") ? 16 : 255 }, geometry: { coordinates: [st.location[1], st.location[0]], type: "Point" } }; routesGeoJson.features.push(stop); }); }); console.log(routesGeoJson); return routesGeoJson; }35:[{"id":"46c8ab0772145ed2e36c2d9ee767de3e559cbcd2b399b114878e78cffb80aee67f29e5b673096d6569b7325efec7880470b42f59c9a37c0b7195013009572adc","href":"https://static.observableusercontent.com/files/46c8ab0772145ed2e36c2d9ee767de3e559cbcd2b399b114878e78cffb80aee67f29e5b673096d6569b7325efec7880470b42f59c9a37c0b7195013009572adc","name":"orders_Notebook.csv","type":"text/csv","lastModified":1706071501370.23,"size":11612},{"id":"30e891b9929d296a9e5f2310b049b17024438337e3f39744413b7978f2a1030fa0425978d5cc08d1057a94c644566ec67f69bb73c7f974b65f94f5e9743a1f68","href":"https://static.observableusercontent.com/files/30e891b9929d296a9e5f2310b049b17024438337e3f39744413b7978f2a1030fa0425978d5cc08d1057a94c644566ec67f69bb73c7f974b65f94f5e9743a1f68","name":"input_vehicles_Notebook.csv","type":"text/csv","lastModified":1706071556264.083,"size":963}] 2f:{"id":"6037f25a72c940ac","slug":null,"title":"Food Delivery","thumbnail":"35e3ff5316856c464b279fb8e0de56e6f0b22b138c206f11d5c7dbc811dc8061","access_level":"public","create_time":"$D2023-10-03T07:07:13.153Z","update_time":"$D2025-01-21T08:08:01.797Z","view_time":null,"first_public_time":"$D2024-01-12T12:09:09.873Z","has_unpublished_edits":null,"fork":true,"stars":0,"starred":false,"owner":{"type":"team","id":"05baed136f9134c1","login":"nbai","name":"NB.AI Solutions Team","avatar_url":"https://avatars-next.observableusercontent.com/7a25d1b5deb9c5290b12e4e0914aacdbd4196bb5c3a94c63a0fda0fe706d28b2","tier":"starter_2024"},"version":4529,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"53e0d2bd94fa8912","login":"dhivya-s","name":"Dhivya Selvarajan","avatar_url":"https://avatars-next.observableusercontent.com/c2ddc5b79da0e63c190a3f3ac91670f23f26b4bc0b1be30699fe67082ccb4f0b","tier":null}],"members":[{"type":"individual","id":"bcb6b2e256659128","login":"jim-welch","name":"Jim Welch","avatar_url":"https://avatars-next.observableusercontent.com/6334ed2ccd004bd8ab34e9f05c047bf4ef291dea914767f26079d7756d073607","tier":null,"role":"editor"},{"type":"team","id":"05baed136f9134c1","login":"nbai","name":"NB.AI Solutions Team","avatar_url":"https://avatars-next.observableusercontent.com/7a25d1b5deb9c5290b12e4e0914aacdbd4196bb5c3a94c63a0fda0fe706d28b2","tier":"starter_2024","role":"viewer"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":1,"collection":{"id":"73d557bcc8a3ebc8","slug":"solutions","title":"Solutions","owner":{"id":"05baed136f9134c1","login":"nbai","name":"NB.AI Solutions Team"}},"type":"notebook","body":{"title":"Food Delivery","cells":[{"id":0,"value":"![text](https://nextbillion.ai/wp-content/uploads/2022/01/logo-nb-colored.png)\n\n# Food Delivery\n# Proof Of Concept","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":2518,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":2517,"value":"toc(\"h2, h3, h4\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2516,"value":"---\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":508,"value":"$31","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":3715,"value":"viewof apiKey = secret2(\"apiKey\", {\n title: \"NextBillion.ai API Key\",\n submit: \"Set\",\n description:\n \"Contact support@nextbillion.ai to get your API key\"\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2024,"value":"viewof panel_random = Inputs.form(inputs, {\n template: (v) => htl.html`\n \n`\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":4343,"value":"orders = await FileAttachment(\"orders_Notebook.csv\").csv({typed: \"auto\"})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"orders","database":"$undefined"},{"id":1236,"value":"---\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":4278,"value":"input_vehicles = await FileAttachment(\"input_vehicles_Notebook.csv\").csv({typed: \"auto\"})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"input_vehicles","database":"$undefined"},{"id":2490,"value":"### Problem Constraints\n\nHere we are setting a few constrains including the driver maximum drive time and objective function to use.\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":2038,"value":"viewof panel_mvrp = Inputs.form(inputs, {\n template: (v) => htl.html`\n

\n \n ${v.objectiveFunction}\n

\n\n`\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3434,"value":"$32","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2042,"value":"{\n const button_mvrp = html` `;\n button_mvrp.onclick = () => {\n mutable run_optimization = true;\n mutable inputData_a = panel_mvrp;\n button_mvrp.disabled = true;\n };\n return html`${button_mvrp}`;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":594,"value":"---\n### Submit the Problem to the MVRP API Endpoint\nWe are now to the point where we can put together the full MVRP request containing all of our pickup locations, vehicles, and options for the solution.\n

\nThe MVRP endpoint is a non-blocking/asynchronous endpoint. We will receive back a reference ID for the optimization job and a status message as seen below. We've highlighted the reference ID in green.\n

\nNote: if you see an error in this section, more than likely you have an invalid API Key set in the input box above. \n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":221,"value":"mvrpID = {\n let shipments = OptimizationProblem.shipments;\n let vehicles = OptimizationProblem.vehicles;\n let locations = OptimizationProblem.locations;\n let options = OptimizationProblem.options;\n const mvrpRequest = {};\n\n mvrpRequest.description = `MVRP Tutorial ${new Date().toISOString()}`;\n mvrpRequest.locations = locations;\n mvrpRequest.vehicles = vehicles;\n mvrpRequest.shipments = shipments;\n mvrpRequest.options = options;\n console.log(mvrpRequest);\n\n try {\n let resp = await axios.post(\n `https://api.nextbillion.io/optimization/v2?key=${apiKey}`,\n mvrpRequest\n );\n return resp.data;\n } catch (error) {\n return {\n status: \"Error\",\n error: JSON.stringify(error)\n };\n }\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":348,"value":"viewof jobID = htl.html`MVRP Request ID: ${\n mvrpID ? mvrpID.id : mvrpID\n}`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":601,"value":"---\n### Retrieve MVRP Result\nOnce we have the reference ID for the MVRP request, we can poll that MVRP status endpoint to get the solution. In this tutorial, we are waiting 10 seconds before polling for the solution. When you see a status message of `Ok` you can browse the result to see the optimized routing solution.\n

","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":720,"value":"html`IMPORTANT
If you get a status message indicating Job still processing just wait a few seconds and press this button.

${viewof requestResult}`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":242,"value":"checkStatus = {\n mvrpID;\n await visibility();\n requestResult;\n yield Promises.delay(5000).then(() => {\n let mvrpResult = axios({\n method: \"GET\",\n url: `https://api.nextbillion.io/optimization/v2/result?id=${mvrpID.id}&key=${apiKey}`,\n headers: {}\n })\n .then((res) => res.data)\n .catch((error) => {\n let mvrpResult = {\n status: \"Error\",\n error: JSON.stringify(error)\n };\n });\n return mvrpResult;\n });\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":631,"value":"kpiStats = {\n let deliveryCount = 0;\n checkStatus.result.routes.forEach((rte, rteidx) => {\n rte.steps.forEach((step, index) => {\n if (step.id && step.id != 99) {\n ++deliveryCount;\n }\n });\n });\n return {\n totalDistance: `${(checkStatus.result.summary.distance / 1000).toFixed(\n 1\n )} km`,\n totalTime: `${(checkStatus.result.summary.duration / 60).toFixed(1)} mn`,\n nbrRoutes: checkStatus.result.summary.routes,\n avgStops: (deliveryCount / checkStatus.result.summary.routes).toFixed(1),\n unassigned: checkStatus.result.summary.unassigned\n };\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2414,"value":"### KPIs for all Vehicles","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":645,"value":"| KPI | Value |\n| ------ | -------- |\n| Total Distance | ${kpiStats.totalDistance} |\n| Total Time | ${kpiStats.totalTime} |\n| Number of Routes | ${kpiStats.nbrRoutes} |\n| Average capacity Per Vehicle | ${kpiStats.avgStops/2}|\n| Unassigned job | ${kpiStats.unassigned}","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1261,"value":"viewof routeSelector = Inputs.select(routesGeoJson.features.filter(f => f.geometry.type === 'LineString'), {multiple: false, label: \"Select route to view\", format: x => x.properties.vin, value: t => t.properties.vin})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1676,"value":"green marker is the vehicle start location (the office) and red markers are delivery and handover locations. You can click on the markers to get details.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":997,"value":"{\n return geoviewer(routesFiltered, {\n width: \"100%\",\n height: \"550\",\n col: \"#8058a0\",\n fillOpacity: 0.9,\n lineWidth: 3,\n style: \"nbai\",\n apiKey: apiKey\n });\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1862,"value":"Inputs.table(selectedRoute[0].steps, {\n columns: [\"type\", \"arrival\", \"description\", \"duration\"],\n header: {\n type: \"Task\",\n arrival: \"Arrival Time\",\n //load: \"Nbr Loaded\",\n description: \"ID, Type\",\n duration: \"Duration\"\n },\n width: {\n type: 40,\n arrival: 30,\n //load: 80,\n description: 180,\n duration: 100\n },\n format: {\n type: (x) => x.toUpperCase(),\n arrival: (x) =>\n new Date(x * 1000).toLocaleTimeString(\"en-US\", {\n hour: \"2-digit\",\n minute: \"2-digit\",\n hour12: false,\n timeZone: \"Asia/Kolkata\"\n }),\n duration: (x) => (x / 60).toFixed(1) + \" mn\"\n },\n\n rows: 11,\n maxWidth: 800,\n multiple: false,\n required: false\n})\n\n//.toLocaleString(\"en-US\", { timeZone: \"Asia/Calcutta\" });","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1898,"value":"selectedRoute = checkStatus.result.routes.filter(f => f.description === routeSelector.properties.vin)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2743,"value":"### Visualize All Routes Using Optimizer \nIf you want to visualize the optimized routing solution along with the sequencing of the stops, the NB.ai Optimization Tester tool is available at NB.AI MVRP Playground App","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1000,"value":"\n\n\n\n---\n### Additional Tools \nIf you want to visualize the optimized routing solution along with the sequencing of the stops, the NB.ai Optimization Tester tool is available. \n\nNB.AI MVRP Playground App (should automatically load the current solution)\n- Select the `SOLUTION` tab\n- Enter the same NB.ai API key used for the MVRP solution\n- Paste the MVRP Request ID into the input box `${mvrpID.id}`\n- Press the `Load` button","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":341,"value":"### Other Dependencies","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","output":"","database":"$undefined"},{"id":1139,"value":"import {nextbillion,cities,secret2} from \"@yvannbai/nextbillion-ai-helpers\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":334,"value":"axios = {\n let axios = await require('axios');\n return axios;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":352,"value":"styling = html`\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":849,"value":"geoviewer = require(\"https://static.nextbillion.io/nbai-demo/nb_geoverview2.js\").then(\n (f) => f.view\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1613,"value":"html`${viewof requestResult}`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1005,"value":"viewof requestResult = Inputs.button(\"Request Result\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1686,"value":"mutable inputData_a = null","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2051,"value":"mutable run_optimization = false;","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1098,"value":" jobs = [\"5\",\"10\",\"25\"]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1111,"value":"vehicles = [\"5\",\"10\",\"20\",\"50\",\"100\"]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1163,"value":"useCases = [\n {name: \"Delivery\", value: \"delivery\"},\n {name: \"Service Worker\", value: \"service\"}\n ]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1175,"value":"objectives = [\n {name: \"Minimize Time\", value: \"duration\"},\n {name: \"Minimize Distance\", value: \"distance\"}\n]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2241,"value":"officeLocation = {\n return \"12.978527,77.665694\";\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":3624,"value":"function toEpoch(timeString) {\n // Split date and time\n const [date, time] = timeString.split(\" \");\n\n // Split year, month, day\n const [year, month, day] = date.split(\"-\");\n\n // Split hour, minute, second\n const [hour, minute, second] = time.split(\":\");\n\n // Create date object in UTC\n // Note: JavaScript's month is 0-indexed\n const dateObj = new Date(\n Date.UTC(year, month - 1, day, hour - 5, minute - 30, second)\n );\n\n // Convert to epoch time (in seconds)\n const epoch = Math.floor(dateObj.getTime() / 1000);\n\n return epoch;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1523,"value":"$33","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":924,"value":"$34","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":1279,"value":"routesFiltered = Object({\n type: 'FeatureCollection',\n features: routesGeoJson.features.filter(f => f.properties.vin === routeSelector.properties.vin)\n});","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"},{"id":2511,"value":"import { toc } from \"@nebrius/indented-toc\" // This component generates the Table of Contents","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W35","stdlib":"1","titling":"auto"}} 30:"$2f:body"