25:["$","title",null,{"children":"Food Delivery | Shivangi Singh's Workspace | Observable"}] 49: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) 4a:Tdda9,OptimizationProblem = { let input_json = { vehicles: [], jobs: [], shipments: [], depots: [], options: { objective: { travel_cost: "distance" }, constraints: { max_vehicle_overtime: 0, max_visit_lateness: 0 }, objectives: { travel_cost: "duration", minimise_num_depots: false } }, locations: { id: 1, location: [] } }; let input_vehicles = [ { Id: 1, Vehicle: "Rider 1", Capacity: 6, Zone: "MUM1", Skills: 1, Start_Location: "19.0413436,72.8433324", Vendor_Name: "Vendor ACTIVeat" }, { Id: 2, Vehicle: "Rider 2", Capacity: 6, Zone: "MUM1", Skills: 1, Start_Location: "19.0413436,72.8433324", Vendor_Name: "Vendor ACTIVeat" }, { Id: 3, Vehicle: "Rider 3", Capacity: 6, Zone: "MUM1", Skills: 1, Start_Location: "19.0413436,72.8433324", Vendor_Name: "Vendor ACTIVeat" }, { Id: 4, Vehicle: "Rider 4", Capacity: 6, Zone: "MUM1", Skills: 1, Start_Location: "19.0413436,72.8433324", Vendor_Name: "Vendor ACTIVeat" }, { Id: 5, Vehicle: "Rider 5", Capacity: 6, Zone: "MUM3", Skills: 2, Start_Location: "19.0217311,72.8584702", Vendor_Name: "Vendor Arigato" }, { Id: 6, Vehicle: "Rider 6", Capacity: 6, Zone: "MUM3", Skills: 2, Start_Location: "19.0217311,72.8584702", Vendor_Name: "Vendor Arigato" }, { Id: 7, Vehicle: "Rider 7", Capacity: 6, Zone: "MUM3", Skills: 2, Start_Location: "19.0217311,72.8584702", Vendor_Name: "Vendor Arigato" }, { Id: 8, Vehicle: "Rider 8", Capacity: 6, Zone: "MUM3", Skills: 2, Start_Location: "19.0217311,72.8584702", Vendor_Name: "Vendor Arigato" }, { Id: 9, Vehicle: "Rider 9", Capacity: 6, Zone: "MUM4", Skills: 3, Start_Location: "19.1244872,72.8691749", Vendor_Name: "Vendor Crossways Gourmet Foods - Mumbai" }, { Id: 10, Vehicle: "Rider 10", Capacity: 6, Zone: "MUM4", Skills: 3, Start_Location: "19.1127721,72.8478788", Vendor_Name: "Vendor Fresh Fusion" }, { Id: 11, Vehicle: "Rider 11", Capacity: 6, Zone: "MUM4", Skills: 3, Start_Location: "19.1127721,72.8478788", Vendor_Name: "Vendor Fresh Fusion" }, { Id: 12, Vehicle: "Rider 12", Capacity: 6, Zone: "MUM4", Skills: 3, Start_Location: "19.1097712,72.8582672", Vendor_Name: "Vendor Fittr Plattr" }, { Id: 13, Vehicle: "Rider 13", Capacity: 6, Zone: "NMM2", Skills: 4, Start_Location: "19.018856,73.0175905999999", Vendor_Name: "Vendor Fruit affair" }, { Id: 14, Vehicle: "Rider 14", Capacity: 6, Zone: "NMM2", Skills: 4, Start_Location: "19.018856,73.0175905999999", Vendor_Name: "Vendor Fruit affair" }, { Id: 15, Vehicle: "Rider 15", Capacity: 6, Zone: "NMM2", Skills: 4, Start_Location: "19.018856,73.0175905999999", Vendor_Name: "Vendor Fruit affair" }, { Id: 16, Vehicle: "Rider 16", Capacity: 6, Zone: "NMM2", Skills: 4, Start_Location: "19.018856,73.0175905999999", Vendor_Name: "Vendor Fruit affair" }, { Id: 17, Vehicle: "Rider 17", Capacity: 6, Zone: "THN", Skills: 5, Start_Location: "19.2183307,72.9780897", Vendor_Name: "Vendor Be Good Meals" }, { Id: 18, Vehicle: "Rider 18", Capacity: 6, Zone: "THN", Skills: 5, Start_Location: "19.2183307,72.9780897", Vendor_Name: "Vendor Be Good Meals" }, { Id: 19, Vehicle: "Rider 19", Capacity: 6, Zone: "THN", Skills: 5, Start_Location: "19.2183307,72.9780897", Vendor_Name: "Vendor Be Good Meals" }, { Id: 20, Vehicle: "Rider 20", Capacity: 6, Zone: "THN", Skills: 5, Start_Location: "19.2183307,72.9780897", Vendor_Name: "Vendor Be Good Meals" } ]; let orders = [ { Id: 6, Vendor_name: "Vendor ACTIVeat", Pickup_Location: "19.0413436,72.8433324", Pickup_Zone: "MUM1", Pickup_Skills: 1, Cx_Name: "Laboni chatterjee", Customer_Number: 9930591495, Customer_Address: "D 502, Rameshwar, Neelkanth Heights, Pokhran Road 2, Thane West Thane City 400610 Maharashtra", 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, Vendor_name: "Vendor ACTIVeat", Pickup_Location: "19.0413436,72.8433324", Pickup_Zone: "MUM1", Pickup_Skills: 1, Cx_Name: "Sachin nair", Customer_Number: 7738154249, Customer_Address: "233, C wing, ebony, kalpataru sunrise Kolshet Road, Thane", 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, Vendor_name: "Vendor ACTIVeat", Pickup_Location: "19.0413436,72.8433324", Pickup_Zone: "MUM1", Pickup_Skills: 1, Cx_Name: "Dr Sonali S", Customer_Number: 9819528680, Customer_Address: "2503, Auralis The Twins, Opposite LIC Office, Behind RTO Office, Louis Wadi, Thane (West), 400604 https://goo.gl/maps/bzuYp5Jgro2aCfSC9", 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, Vendor_name: "Vendor ACTIVeat", Pickup_Location: "19.0413436,72.8433324", Pickup_Zone: "MUM1", Pickup_Skills: 1, Cx_Name: "Gaurav Gupta", Customer_Number: 9920978888, Customer_Address: "A5/405 , Runwal Plaza, Vartak Nagar, Thane(w)", 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, Vendor_name: "Vendor ACTIVeat", Pickup_Location: "19.0413436,72.8433324", Pickup_Zone: "MUM1", Pickup_Skills: 1, Cx_Name: "Bharat Kulhalli", Customer_Number: 9820959033, Customer_Address: "Bharat Kulhalli C - 1801 Runwal Pride, Behind R-Mall Lal Bahadur Shastri Road,LBS, MULUND West Mumbai Maharashtra", 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, Vendor_name: "Vendor ACTIVeat", Pickup_Location: "19.0413436,72.8433324", Pickup_Zone: "MUM1", Pickup_Skills: 1, Cx_Name: "Prabodh Desaid", Customer_Number: 9920186296, Customer_Address: "A/102, Ankur Condominium,opp Hypercity, Link Road,Goregaon West, Mumbai 400104", 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, Vendor_name: "Vendor ACTIVeat", Pickup_Location: "19.0413436,72.8433324", Pickup_Zone: "MUM1", Pickup_Skills: 1, Cx_Name: "Raju pillai", Customer_Number: 9769922782, Customer_Address: "Sheth Avalon, 803H, Near Jupiter Hospital, Thane west 400606", 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, Vendor_name: "Vendor ACTIVeat", Pickup_Location: "19.0413436,72.8433324", Pickup_Zone: "MUM1", Pickup_Skills: 1, Cx_Name: "Shivani Aadhi", Customer_Number: 8610601508, Customer_Address: "E502, Kanakia Rainforest Bhawani Nagar Road, Marol Mumbai 400059 Maharashtra", 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, Vendor_name: "Vendor ACTIVeat", Pickup_Location: "19.0413436,72.8433324", Pickup_Zone: "MUM1", Pickup_Skills: 1, Cx_Name: "Kaustubh Kumbhare", Customer_Number: 8390776772, Customer_Address: "Kokuyo Camlin Hilton House, MIDC Andheri area Marol, Andheri Mumbai 400093", 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, Vendor_name: "Vendor ACTIVeat", Pickup_Location: "19.0413436,72.8433324", Pickup_Zone: "MUM1", Pickup_Skills: 1, Cx_Name: "Hiroshi Doisaki", Customer_Number: 8657007631, Customer_Address: "Ocean Network Express ( India ) Private Limited 3rd Floor, A-Wing, Fulcrum, Hiranandani Business Park, Sahar Road, Andheri (East), Mumbai, MH, 400099,", 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, Vendor_name: "Vendor ACTIVeat", Pickup_Location: "19.0413436,72.8433324", Pickup_Zone: "MUM1", Pickup_Skills: 1, Cx_Name: "Priyanka Kanetkar", Customer_Number: 9321159993, Customer_Address: "5th floor, Imperium building, opposite police camp quarters, Marol maroshi road Above HDFC ATM. Andheri east. Mumbai 400059", 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, Vendor_name: "Vendor ACTIVeat", Pickup_Location: "19.0413436,72.8433324", Pickup_Zone: "MUM1", Pickup_Skills: 1, Cx_Name: "Ajay Singh", Customer_Number: 7304219206, Customer_Address: "701 Shivneri IIT Staff Hsg Soc. Behind Shetty School Mumbai 400076 Maharashtra", 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, Vendor_name: "Vendor ACTIVeat", Pickup_Location: "19.0413436,72.8433324", Pickup_Zone: "MUM1", Pickup_Skills: 1, Cx_Name: "Shyam Kumar", Customer_Number: 9819959476, Customer_Address: "I602, Panch Ritu Apartments, IRB Rd, MHADA Colony 20, Powai, Mumbai, Maharashtra 400072 Mumbai 400072 Maharashtra", 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, Vendor_name: "Vendor Arigato", Pickup_Location: "19.0217311,72.8584702", Pickup_Zone: "MUM3", Pickup_Skills: 2, Cx_Name: "Jimmy Cooper", Customer_Number: "#ERROR!", Customer_Address: "Address- Wadhwa Dukes Horizon Sales office, 1 Floor residential building, Waman Tukaram Patil Marg, Chembur, Mumbai, Maharashtra 400088", 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, Vendor_name: "Vendor Arigato", Pickup_Location: "19.0217311,72.8584702", Pickup_Zone: "MUM3", Pickup_Skills: 2, Cx_Name: "Rhituparna Mitra", Customer_Number: "#ERROR!", Customer_Address: "102, Arihant Ansh, Plot 20, Sector 26, Vashi, Navi Mumbai - 400705", 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, Vendor_name: "Vendor Arigato", Pickup_Location: "19.0217311,72.8584702", Pickup_Zone: "MUM3", Pickup_Skills: 2, Cx_Name: "RENUKA SHETTY", Customer_Number: "#ERROR!", Customer_Address: "RENUKA SHETTY 2A GIRIRAJ 2ND FLOOR 11 ALTAMOUNT ROAD MUMBAI 400026 NEAR ANTILIA AMBANIS", 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, Vendor_name: "Vendor Be Good Meals", Pickup_Location: "19.2183307,72.9780897", Pickup_Zone: "THN", Pickup_Skills: 5, Cx_Name: "Neha Rawat", Customer_Number: 9873786340, Customer_Address: "Marathon NextGen Innova 001/C-Wing, Ground Floor Lower parel Mumbai", 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, Vendor_name: "Vendor Be Good Meals", Pickup_Location: "19.2183307,72.9780897", Pickup_Zone: "THN", Pickup_Skills: 5, Cx_Name: "Anaya Lal", Customer_Number: "#ERROR!", Customer_Address: "B2105 Runwal Elegante Lokhandwala Andheri West Mumbai", 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, Vendor_name: "Vendor Be Good Meals", Pickup_Location: "19.2183307,72.9780897", Pickup_Zone: "THN", Pickup_Skills: 5, Cx_Name: "Dheeraj", Customer_Number: "#ERROR!", Customer_Address: "Vaijanath Realtors LLP DHEERAJ JAISINGHANI 1002, Octavius Hiranandani Gardens, Powai Mumbai Maharashtra", 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, Vendor_name: "Vendor Be Good Meals", Pickup_Location: "19.2183307,72.9780897", Pickup_Zone: "THN", Pickup_Skills: 5, Cx_Name: "Manan Vaishnav", Customer_Number: 919931000000, Customer_Address: "951A, Floor 2, Rational House, Appasaheb Marathe Marg Next to Kia Motors Showroom, Prabhadevi, Mumbai Mumbai", 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, Vendor_name: "Vendor Be Good Meals", Pickup_Location: "19.2183307,72.9780897", Pickup_Zone: "THN", Pickup_Skills: 5, Cx_Name: "Mitali Vakil", Customer_Number: 8080160076, Customer_Address: "68/A, Rungta house , Rungta lane , Napeansea road Ground floor , gate no 1 Mumbai", 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, Vendor_name: "Vendor Be Good Meals", Pickup_Location: "19.2183307,72.9780897", Pickup_Zone: "THN", Pickup_Skills: 5, Cx_Name: "Prerna Arora", Customer_Number: 9867292389, Customer_Address: "C - 305 Regent HillsHiranandani Garden Powai Mumbai", 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, Vendor_name: "Vendor Be Good Meals", Pickup_Location: "19.2183307,72.9780897", Pickup_Zone: "THN", Pickup_Skills: 5, Cx_Name: "Dakshata", Customer_Number: 9820213170, Customer_Address: "411-2/A, Hemu Kalani Marg, behind Acres Club, Sindhi Society, Chembur, Mumbai", 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, Vendor_name: "Vendor Be Good Meals", Pickup_Location: "19.2183307,72.9780897", Pickup_Zone: "THN", Pickup_Skills: 5, Cx_Name: "NATARAJAN SUBRAMANIAM", Customer_Number: 9920827717, Customer_Address: "1430 SUMANGAL BY HERITAGE GROUP, TRIMURTI ROAD NEXT TO INDU GANESH CO-OP HOUSING SOCIETY, SION CHUNABATTI Mumbai", 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, Vendor_name: "Vendor Be Good Meals", Pickup_Location: "19.2183307,72.9780897", Pickup_Zone: "THN", Pickup_Skills: 5, Cx_Name: "Surbhi Sen", Customer_Number: "#ERROR!", Customer_Address: "C-1601, Delta Central, Sec-23, Kharghar,", 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, Vendor_name: "Vendor Be Good Meals", Pickup_Location: "19.2183307,72.9780897", Pickup_Zone: "THN", Pickup_Skills: 5, Cx_Name: "Pranali Kadrekar", Customer_Number: 8149458554, Customer_Address: "B 303, shiv kripa, model town Four bunglows, Andheri west Mumbai", 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, Vendor_name: "Vendor Be Good Meals", Pickup_Location: "19.2183307,72.9780897", Pickup_Zone: "THN", Pickup_Skills: 5, Cx_Name: "Mitali Vakil", Customer_Number: 8080160076, Customer_Address: "68/A, Rungta house , Rungta lane , Napeansea road Ground floor , gate no 1 Mumbai", 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, Vendor_name: "Vendor Be Good Meals", Pickup_Location: "19.2183307,72.9780897", Pickup_Zone: "THN", Pickup_Skills: 5, Cx_Name: "Prerna Arora", Customer_Number: 9867292389, Customer_Address: "C - 305 Regent HillsHiranandani Garden Powai Mumbai", 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, Vendor_name: "Vendor Be Good Meals", Pickup_Location: "19.2183307,72.9780897", Pickup_Zone: "THN", Pickup_Skills: 5, Cx_Name: "monica juvekar", Customer_Number: 917507000000, Customer_Address: "1601 Leona Rodas enclave hiranandani estate Thane w Near Rodas", 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, Vendor_name: "Vendor Be Good Meals", Pickup_Location: "19.2183307,72.9780897", Pickup_Zone: "THN", Pickup_Skills: 5, Cx_Name: "Dr. Neelu", Customer_Number: "#ERROR!", Customer_Address: "Mulund - Goregaon Link Rd, Nahur West, Industrial Area, Bhandup West, Mumbai, Maharashtra", 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, Vendor_name: "Vendor Be Good Meals", Pickup_Location: "19.2183307,72.9780897", Pickup_Zone: "THN", Pickup_Skills: 5, Cx_Name: "Priyanka Palwankar", Customer_Number: 8432128888, Customer_Address: "Lodha Splendora Tierra C wing Flat no 1801 Bhayandapada Thane West", 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, Vendor_name: "Vendor Be Good Meals", Pickup_Location: "19.2183307,72.9780897", Pickup_Zone: "THN", Pickup_Skills: 5, Cx_Name: "Anjali Hariprasad", Customer_Number: 8879720027, Customer_Address: "1801/Elecia, Dosti imperia,Manpada Manpada", 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, Vendor_name: "Vendor Be Good Meals", Pickup_Location: "19.2183307,72.9780897", Pickup_Zone: "THN", Pickup_Skills: 5, Cx_Name: "Vasanti", Customer_Number: "#ERROR!", Customer_Address: "Monte Vista flat no 3304 near by achija hotel telllphone exchange Mulund West", 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, Vendor_name: "Vendor Be Good Meals", Pickup_Location: "19.2183307,72.9780897", Pickup_Zone: "THN", Pickup_Skills: 5, Cx_Name: "Krish", Customer_Number: "#ERROR!", Customer_Address: "Sindh Sagar Rd Number 14, Kasturba Gandhi Nagar, Wadla Village, Wadala, Mumbai, Maharashtra", 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, Vendor_name: "Vendor Be Good Meals", Pickup_Location: "19.2183307,72.9780897", Pickup_Zone: "THN", Pickup_Skills: 5, Cx_Name: "Vrinda Makhija", Customer_Number: 9820689449, Customer_Address: "Flat No. 301, B Wing, Siddhi Garima, Tapasya Apartments CHS, Collector Colony, next to Vivekananda Pharmacy College, Chembur East", 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, Vendor_name: "Vendor Crossways Gourmet Foods - Mumbai", Pickup_Location: "19.1244872,72.8691749", Pickup_Zone: "MUM4", Pickup_Skills: 3, Cx_Name: "Mrinal Achrekar", Customer_Number: 9969945136, Customer_Address: "Aai Building, Saraswat Bank, Baji Prabhu Deshpande Road, Vishnu Nagar Naupada Thane West 400602, Vishnu Nagar, Thane West, Thane, Maharashtra 400602,", 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, Vendor_name: "Vendor Crossways Gourmet Foods - Mumbai", Pickup_Location: "19.1244872,72.8691749", Pickup_Zone: "MUM4", Pickup_Skills: 3, Cx_Name: "Ashwini Manerikar", Customer_Number: "98921 02914", Customer_Address: "G3, Building A15, Happy Valley House CHS( Phase II) , Tikujini wadi road, Manpada, Thane west 400610", 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, Vendor_name: "Vendor Fittr Plattr", Pickup_Location: "19.1097712,72.8582672", Pickup_Zone: "MUM4", Pickup_Skills: 3, Cx_Name: "Anuja Jain", Customer_Number: "97497 29039", Customer_Address: "Evershine Cosmic , A wing, 11th floor, flat 1101, Off veera desai road", 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, Vendor_name: "Vendor Fittr Plattr", Pickup_Location: "19.1097712,72.8582672", Pickup_Zone: "MUM4", Pickup_Skills: 3, Cx_Name: "Swati Vasan", Customer_Number: "98204 36564", Customer_Address: "Rowhouse No. 1, Ashok Vatika, next to Safal Heights bldg., Ghatla Village Rd., Chembur east", 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, Vendor_name: "Vendor Fittr Plattr", Pickup_Location: "19.1097712,72.8582672", Pickup_Zone: "MUM4", Pickup_Skills: 3, Cx_Name: "Suresh Kumar", Customer_Number: "98214 81298", Customer_Address: "Dynamcom Tankers Management Pvt Ltd, 402, A wing, Business Square, Sir Mathuradas Vissanji Marg, Chakala, Andheri east, Opp Kanakia Wall Street", 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, Vendor_name: "Vendor Fittr Plattr", Pickup_Location: "19.1097712,72.8582672", Pickup_Zone: "MUM4", Pickup_Skills: 3, Cx_Name: "Sanjana Kamat", Customer_Number: "98701 08364", Customer_Address: "A-12, 3rd floor, Model House, Proctor Rd, Opp Edubridge International School, Grant Rd (E),", 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, Vendor_name: "Vendor Fittr Plattr", Pickup_Location: "19.1097712,72.8582672", Pickup_Zone: "MUM4", Pickup_Skills: 3, Cx_Name: "Jinita Shah", Customer_Number: "90040 46405", Customer_Address: "G-62/63,R galleria,Runwal greens,off,Mulund-Goregaon Link Road,Mulund West", 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, Vendor_name: "Vendor Fittr Plattr", Pickup_Location: "19.1097712,72.8582672", Pickup_Zone: "MUM4", Pickup_Skills: 3, Cx_Name: "Karan Nirbhavne", Customer_Number: "90296 69197", Customer_Address: "7/124 JAI-VIKRANT CHSL, SAHAKAR NAGAR-5, SHE'LL COLONY CHEMBUR MUMBAI-400071", 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, Vendor_name: "Vendor Fittr Plattr", Pickup_Location: "19.1097712,72.8582672", Pickup_Zone: "MUM4", Pickup_Skills: 3, Cx_Name: "Krunal", Customer_Number: "97694 71305", Customer_Address: "1, Kors Rd, Patil Wadi, Sawarkar Nagar, Patil Nagar, Thane West, Thane, Maharashtra 400606", 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, Vendor_name: "Vendor Fittr Plattr", Pickup_Location: "19.1097712,72.8582672", Pickup_Zone: "MUM4", Pickup_Skills: 3, Cx_Name: "Priya Iyer", Customer_Number: "93702 30390", Customer_Address: "A-502, Jalaram CHS, Near Bhandup Sonapur Signal, LBS Marg, Bhandup West, Mumbai-79", 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, Vendor_name: "Vendor Fittr Plattr", Pickup_Location: "19.1097712,72.8582672", Pickup_Zone: "MUM4", Pickup_Skills: 3, Cx_Name: "Lekshmi", Customer_Number: "98202?92152", Customer_Address: "302, Autumn Hay, Neptune Living point, LBS Road, Bhandup West", 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, Vendor_name: "Vendor Fittr Plattr", Pickup_Location: "19.1097712,72.8582672", Pickup_Zone: "MUM4", Pickup_Skills: 3, Cx_Name: "Jayanti Parmeshwar", Customer_Number: "97699 22818", Customer_Address: "B 402 Ruparel Orion, Swastik Park,Chembur", 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, Vendor_name: "Vendor Fittr Plattr", Pickup_Location: "19.1097712,72.8582672", Pickup_Zone: "MUM4", Pickup_Skills: 3, Cx_Name: "Sugandhi Vasudevan", Customer_Number: "95950 44565", Customer_Address: "211 veekay avanna Swastik plaza c wing plot no 54 opp daya Ghar building Swastik park chembur", 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, Vendor_name: "Vendor Fittr Plattr", Pickup_Location: "19.1097712,72.8582672", Pickup_Zone: "MUM4", Pickup_Skills: 3, Cx_Name: "Insiya Relekar", Customer_Number: "97690 37333", Customer_Address: "A5 1001 coral heights , Kavesar, Ghodhbunder road, thane west 400615", 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, Vendor_name: "Vendor Fittr Plattr", Pickup_Location: "19.1097712,72.8582672", Pickup_Zone: "MUM4", Pickup_Skills: 3, Cx_Name: "Gauravi", Customer_Number: "98674 93148", Customer_Address: "Lalani Residency, D 1404, Opp Suraj Water Park, Ghodbunder Road.", 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, Vendor_name: "Vendor Fittr Plattr", Pickup_Location: "19.1097712,72.8582672", Pickup_Zone: "MUM4", Pickup_Skills: 3, Cx_Name: "Anushka", Customer_Number: "75068 82922", Customer_Address: "A wing,506,Neelkanth Enclave,LBS Marg Shreyas,Ghatkopar West", 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, Vendor_name: "Vendor Fittr Plattr", Pickup_Location: "19.1097712,72.8582672", Pickup_Zone: "MUM4", Pickup_Skills: 3, Cx_Name: "Poornima", Customer_Number: 9769907934, Customer_Address: "602, 5 Diamond Garden, Opposite Kalpana Padma Tower, 5th Road, Diamond Garden, Chembur,", 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, Vendor_name: "Vendor Fittr Plattr", Pickup_Location: "19.1097712,72.8582672", Pickup_Zone: "MUM4", Pickup_Skills: 3, Cx_Name: "Shweta", Customer_Number: "82914 59665", Customer_Address: "A-101, Tulip CHS, Hiranandani Gardens, Powai", 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, Vendor_name: "Vendor Fittr Plattr", Pickup_Location: "19.1097712,72.8582672", Pickup_Zone: "MUM4", Pickup_Skills: 3, Cx_Name: "Meghna Dongre", Customer_Number: 8978544011, Customer_Address: "Address 901, Jamaica, Nahar Amrit Shakti,Chandivali Mumbai Pincode 400072", 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, Vendor_name: "Vendor Fresh Fusion", Pickup_Location: "19.1127721,72.8478788", Pickup_Zone: "MUM4", Pickup_Skills: 3, Cx_Name: "Mrunal Kulkarni", Customer_Number: 919821000000, Customer_Address: "B 1604 Greeshma Residency, Mental Hospital Road , Thane, Maharashtra 400604", 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, Vendor_name: "Vendor Fresh Fusion", Pickup_Location: "19.1127721,72.8478788", Pickup_Zone: "MUM4", Pickup_Skills: 3, Cx_Name: "Ketki Joshi", Customer_Number: 919892000000, Customer_Address: "A 205/203 Crescent Solitaire Andheri Kurla Road opp. Central Hospital , Mumbai Suburban, Maharashtra 400072", 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, Vendor_name: "Vendor Fresh Fusion", Pickup_Location: "19.1127721,72.8478788", Pickup_Zone: "MUM4", Pickup_Skills: 3, Cx_Name: "Rudra Deosthali", Customer_Number: 7032623195, Customer_Address: "Parinam Law Associates, 4th Floor, Express Towers, Nariman Point : Behind Air India Building,", 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, Vendor_name: "Vendor Fresh Fusion", Pickup_Location: "19.1127721,72.8478788", Pickup_Zone: "MUM4", Pickup_Skills: 3, Cx_Name: "Swanandi", Customer_Number: 9004271117, Customer_Address: "128Shreenivas hindu colony 5th lane Dadar east Mumbai , Mumbai, Maharashtra 400014", 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, Vendor_name: "Vendor Fresh Fusion", Pickup_Location: "19.1127721,72.8478788", Pickup_Zone: "MUM4", Pickup_Skills: 3, Cx_Name: "Vivekkumar Margam", Customer_Number: 918098000000, Customer_Address: "C6, 603 Cowork Space Matulya Centre, 2nd Floor, Senapati Bapat Marg, ,Mumbai, Maharashtra 400013", 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, Vendor_name: "Vendor Fruit affair", Pickup_Location: "19.018856,73.0175905999999", Pickup_Zone: "NMM2", Pickup_Skills: 4, Cx_Name: "Dr Arun Mishra", Customer_Number: "95949 42064", Customer_Address: "Mishraveda Clinic C 17-18,Second Floor, Manav Welfare Trust, Dadar tt circle, Dadar East -400014.", 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 + "; Vendor: " + vehicle.Vendor_Name; 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; }4b: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; }4c: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; }4d:[{"id":"279b4a871e2ed22f8b809db70bc81ffde63cc0bd86ce211c1bfa3ee7f501591fcdcd84c798bf21eafa011b8bafd48ce9dc3def44002a585d2b76c61f76896f49","href":"https://static.observableusercontent.com/files/279b4a871e2ed22f8b809db70bc81ffde63cc0bd86ce211c1bfa3ee7f501591fcdcd84c798bf21eafa011b8bafd48ce9dc3def44002a585d2b76c61f76896f49","name":"input_orders_with_handovers@3.csv","type":"text/csv","lastModified":1706070144659.835,"size":18680},{"id":"1f331e733e31c7c279f30e5325060eaea36338e97de4a9b3daa95c147facf34422214725da72d9a4d1a6eea8ff023ad6c506106474439201508c52e48bcc681d","href":"https://static.observableusercontent.com/files/1f331e733e31c7c279f30e5325060eaea36338e97de4a9b3daa95c147facf34422214725da72d9a4d1a6eea8ff023ad6c506106474439201508c52e48bcc681d","name":"input_vehicles_planto@1.csv","type":"text/csv","lastModified":1706070144659.835,"size":1365}] 29:{"id":"55ad05a8bfffbe33","slug":null,"title":"Food Delivery","thumbnail":"a6dfe3d9f92b1eb09b6573feba8a9938857ed503bd68a59a80ca42be69cb19c2","access_level":"public","create_time":"$D2024-01-24T04:22:24.659Z","update_time":"$D2024-01-24T04:23:05.354Z","view_time":null,"first_public_time":"$D2024-01-24T04:22:24.659Z","has_unpublished_edits":null,"fork":{"id":"6037f25a72c940ac","slug":null,"title":"Food Delivery","owner":{"id":"05baed136f9134c1","login":"nbai","name":"NB.AI Solutions Team"}},"stars":0,"starred":false,"owner":{"type":"team","id":"3e5ed3ee32e07821","login":"shivangi-singh-ws","name":"Shivangi Singh's Workspace","avatar_url":"https://avatars-next.observableusercontent.com/aa4ea7b412320dd2084139f833e132c5c6d47f6ad56456127e3a2ecbc5be13a1","tier":"starter_2024","bio":"","followed_by_you":false,"follows_you":false},"version":4514,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"9049640116869d1d","login":"shivangi-singh","name":"Shivangi Singh","avatar_url":"https://avatars-next.observableusercontent.com/398cee709426b5862783ffbfa602d641803c857f766d87615ba9d59033004a2f","tier":null,"bio":"","followed_by_you":false,"follows_you":false}],"members":[{"type":"individual","id":"9049640116869d1d","login":"shivangi-singh","name":"Shivangi Singh","avatar_url":"https://avatars-next.observableusercontent.com/398cee709426b5862783ffbfa602d641803c857f766d87615ba9d59033004a2f","tier":null,"role":"editor"},{"type":"team","id":"3e5ed3ee32e07821","login":"shivangi-singh-ws","name":"Shivangi Singh's Workspace","avatar_url":"https://avatars-next.observableusercontent.com/aa4ea7b412320dd2084139f833e132c5c6d47f6ad56456127e3a2ecbc5be13a1","tier":"starter_2024","role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":0,"collection":null,"type":"notebook","body":{"titling":"auto","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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":2518,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":2517,"value":"toc(\"h2, h3, h4\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2516,"value":"---\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":508,"value":"$49","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":4343,"value":"orders = await FileAttachment(\"orders (1).csv\").csv({typed: \"auto\"})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"orders","database":"$undefined"},{"id":1236,"value":"---\n","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":4278,"value":"input_vehicles = await FileAttachment(\"input_vehicles (1).csv\").csv({typed: \"auto\"})","pinned":true,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":3434,"value":"$4a","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2414,"value":"### KPIs for all Vehicles","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":341,"value":"### Other Dependencies","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":352,"value":"styling = html`\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1613,"value":"html`${viewof requestResult}`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1005,"value":"viewof requestResult = Inputs.button(\"Request Result\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1686,"value":"mutable inputData_a = null","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":2051,"value":"mutable run_optimization = false;","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1098,"value":" jobs = [\"5\",\"10\",\"25\"]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1111,"value":"vehicles = [\"5\",\"10\",\"20\",\"50\",\"100\"]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":1523,"value":"$4b","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":924,"value":"$4c","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$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","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W4d","stdlib":"1"}} 24:null