3e:null 3f:["$","title",null,{"children":"Solution to Employee Transport and Planning | Prashanth Hiremath | Observable"}] 45:T992,function loadMapResources(nbmap){ nbmap.on("load", function () { let pickupsGeojson = { type: "FeatureCollection", features: [] }; inputPickups.forEach(function(entry){ let feature = new Object; feature.type = "Feature"; feature.properties = { id: entry.pickup.id, description: entry.pickup.description }; let coord = entry.pickup.location; coord = coord.split(","); let coordObj = new Object; coordObj.lat = Number(coord[0]); coordObj.lon = Number(coord[1]); feature.geometry = { type: "Point", coordinates: [coordObj.lon, coordObj.lat] }; pickupsGeojson.features.push(feature); coordObj = new Object feature = new Object; }) if (!nbmap.map.getSource("pickups")) { nbmap.map.addSource("pickups", { type: "geojson", data: pickupsGeojson, cluster: false }); } else { nbmap.map.getSource("pickups").setData(pickupsGeojson); } nbmap.map.addLayer({ id: "pickups", type: "circle", source: "pickups", paint: { 'circle-radius': 5, 'circle-color': '#FFFF00' } // 'filter': ['==', '$type', 'Point'] }); let tempData = new Object; tempData.lat = Number(inputVehicles[0].Office_Location.split(",")[0]); tempData.lon = Number(inputVehicles[0].Office_Location.split(",")[1]); console.log(tempData); let office_loc = { type: "FeatureCollection", features: [ { type: "Feature", properties: {}, geometry: { coordinates: [ tempData.lon, tempData.lat ], type: "Point" } } ] }; if (!nbmap.map.getSource("officeLoc")) { nbmap.map.addSource("officeLoc", { type: "geojson", data: office_loc, cluster: false }); } else { nbmap.map.getSource("officeLoc").setData(office_loc); } nbmap.map.addLayer({ id: "officeLocation", type: "circle", source: "officeLoc", paint: { 'circle-radius': 8, 'circle-color': 'red' } // 'filter': ['==', '$type', 'Point'] }); }) }46:T106e,async function loadRoutes(mapComponent, resource){ if (mapComponent.value.map.getLayer("route")) { mapComponent.value.map.removeLayer("route"); // Remove the layer first } if (mapComponent.value.map.getSource("route")) { mapComponent.value.map.removeSource("route"); // Remove the source } mapComponent.value.map.addSource("route", { type: "geojson", data: { type: "Feature", properties: {}, geometry: { type: "LineString", coordinates: nextbillion.utils.polyline .decode(resource[0].geometry, 5) .map((c) => c.reverse()) } } }); const sourceData = mapComponent.value.map.getSource("route")._data; const bbox = turf.bbox(sourceData); // [minLng, minLat, maxLng, maxLat] mapComponent.value.map.addLayer({ id: "route", type: "line", source: "route", layout: { "line-join": "round", "line-cap": "round" }, paint: { "line-color": "#FFFF00", "line-width": 5 } }); mapComponent.value.map.fitBounds(bbox, { padding: 20, // Optional padding around the bounds maxZoom: 14 // Optional maximum zoom level }); // To load points along the route const pickupPoints = resource[0].steps.filter(step => step.type === "pickup"); const officeLoc = resource[0].steps.filter(step => step.type === "end")[0]; // console.log(pickupPoints); // console.log(officeLoc); //Add office location marker // if (marker){ // marker.remove(); // popup.remove(); // } // let marker = null; // let popup = null; // let popup = new nextbillion.maps.Popup({ // offset: 25, // closeButton: false // }).setText("Office Location"); // let marker = new nextbillion.maps.Marker() // // .setLngLat({ lat: officeLoc.location[0], lng: officeLoc.location[1]}) // .setPopup(popup) // .addTo(mapComponent.value.map); // marker.togglePopup(); const routesgeojsonData = { type: "FeatureCollection", features: [] }; pickupPoints.forEach(function(pick,ind){ ind = ind+1; let feature = { type: "Feature", geometry: { type: "Point", coordinates: [pick.location[1], pick.location[0]] }, properties: { number: ind // The number to display } }; routesgeojsonData.features.push(feature); }) // console.log(routesgeojsonData); if (mapComponent.value.map.getLayer("pick-layer")) { mapComponent.value.map.removeLayer("pick-layer"); // Remove the source }; if (mapComponent.value.map.getLayer("label-layer")) { mapComponent.value.map.removeLayer("label-layer"); // Remove the source }; if (mapComponent.value.map.getSource("pick-source")) { mapComponent.value.map.removeSource("pick-source"); // Remove the layer first }; mapComponent.value.map.addSource("pick-source", { type: 'geojson', data: routesgeojsonData }); // Add the layers after the source addCircleWithLabelLayers(); function addCircleWithLabelLayers() { // Add the circle layer mapComponent.value.map.addLayer({ id: "pick-layer", type: "circle", source: "pick-source", paint: { "circle-radius": 15, // "circle-color": "#007cbf", "circle-color": "blue", "circle-opacity": 0.7 } }); // Add the number label layer mapComponent.value.map.addLayer({ id: "label-layer", type: "symbol", source: "pick-source", layout: { "text-field": ["get", "number"], // Display the "number" property "text-size": 12, // Font size "text-font": ["Open Sans Bold", "Arial Unicode MS Bold"], // Fonts "text-justify": "center", // Center alignment "text-anchor": "center" // Center anchor }, paint: { "text-color": "#ffffff" // Label color } }); } }47:T605,async function optimizeProblemStatement() { // console.log(inputPickups); // let location = ""; // let loc_index = 0; // let shipments = []; // let vehicles = []; let options = new Object; let objValue = ""; let opt = new Object; if(form.objective == "Minimize distance"){ objValue = "distance" } else if(form.objective == "Minimize duration"){ objValue = "duration" } let locations = { id: 1, location: input_locations }; inputPickups.forEach(function(shipment) { shipment.max_time_in_vehicle = form.maxTimeinVehicle*60; shipment.delivery.time_windows = [[ Date.parse(form.arrivalTimeStart)/1000, Date.parse(form.arrivalTimeEnd)/1000 ]] }) const mvrpRequest = { description: `Employee Transportation Notebook ${new Date().toISOString()}`, locations: locations, vehicles: inputVehicles, shipments: inputPickups, jobs: [], options: { objective: { solver_mode: "internal", travel_cost: objValue, // custom: false } } }; console.log(JSON.stringify(mvrpRequest)); let reqId = null; let req = await axios .post( `https://api.nextbillion.io/optimization/v2?key=${apikey}`, mvrpRequest ) .then((response) => { // console.log(response.data); // reqId = JSON.parse(response.data); console.log(response.data.id); reqId = response.data.id; }) .catch((response) => response.data); return reqId; }48:T1753,inputVehicles = [ { "id": "2", "capacity": [ 4 ], "end_index": 0, "Office_Location": "17.240597,78.474209", "description": "Pickup Vehicle - 1" }, { "id": "3", "capacity": [ 4 ], "end_index": 0, "Office_Location": "17.240597,78.474209", "description": "Pickup Vehicle - 2" }, { "id": "4", "capacity": [ 4 ], "end_index": 0, "Office_Location": "17.240597,78.474209", "description": "Pickup Vehicle - 3" }, { "id": "5", "capacity": [ 4 ], "end_index": 0, "Office_Location": "17.240597,78.474209", "description": "Pickup Vehicle - 4" }, { "id": "6", "capacity": [ 4 ], "end_index": 0, "Office_Location": "17.240597,78.474209", "description": "Pickup Vehicle - 5" }, { "id": "7", "capacity": [ 4 ], "end_index": 0, "Office_Location": "17.240597,78.474209", "description": "Pickup Vehicle - 6" }, { "id": "8", "capacity": [ 4 ], "end_index": 0, "Office_Location": "17.240597,78.474209", "description": "Pickup Vehicle - 7" }, { "id": "9", "capacity": [ 4 ], "end_index": 0, "Office_Location": "17.240597,78.474209", "description": "Pickup Vehicle - 8" }, { "id": "10", "capacity": [ 4 ], "end_index": 0, "Office_Location": "17.240597,78.474209", "description": "Pickup Vehicle - 9" }, { "id": "11", "capacity": [ 4 ], "end_index": 0, "Office_Location": "17.240597,78.474209", "description": "Pickup Vehicle - 10" }, { "id": "12", "capacity": [ 4 ], "end_index": 0, "Office_Location": "17.240597,78.474209", "description": "Pickup Vehicle - 11" }, { "id": "13", "capacity": [ 4 ], "end_index": 0, "Office_Location": "17.240597,78.474209", "description": "Pickup Vehicle - 12" }, { "id": "14", "capacity": [ 4 ], "end_index": 0, "Office_Location": "17.240597,78.474209", "description": "Pickup Vehicle - 13" }, { "id": "15", "capacity": [ 4 ], "end_index": 0, "Office_Location": "17.240597,78.474209", "description": "Pickup Vehicle - 14" }, { "id": "16", "capacity": [ 4 ], "end_index": 0, "Office_Location": "17.240597,78.474209", "description": "Pickup Vehicle - 15" }, { "id": "17", "capacity": [ 4 ], "end_index": 0, "Office_Location": "17.240597,78.474209", "description": "Pickup Vehicle - 16" }, { "id": "18", "capacity": [ 4 ], "end_index": 0, "Office_Location": "17.240597,78.474209", "description": "Pickup Vehicle - 17" }, { "id": "19", "capacity": [ 4 ], "end_index": 0, "Office_Location": "17.240597,78.474209", "description": "Pickup Vehicle - 18" }, { "id": "20", "capacity": [ 4 ], "end_index": 0, "Office_Location": "17.240597,78.474209", "description": "Pickup Vehicle - 19" }, { "id": "21", "capacity": [ 4 ], "end_index": 0, "Office_Location": "17.240597,78.474209", "description": "Pickup Vehicle - 20" }, { "id": "22", "capacity": [ 4 ], "end_index": 0, "Office_Location": "17.240597,78.474209", "description": "Pickup Vehicle - 21" }, { "id": "23", "capacity": [ 4 ], "end_index": 0, "Office_Location": "17.240597,78.474209", "description": "Pickup Vehicle - 22" }, { "id": "24", "capacity": [ 4 ], "end_index": 0, "Office_Location": "17.240597,78.474209", "description": "Pickup Vehicle - 23" }, { "id": "25", "capacity": [ 4 ], "end_index": 0, "Office_Location": "17.240597,78.474209", "description": "Pickup Vehicle - 24" }, { "id": "26", "capacity": [ 4 ], "end_index": 0, "Office_Location": "17.240597,78.474209", "description": "Pickup Vehicle - 25" }, { "id": "27", "capacity": [ 4 ], "end_index": 0, "Office_Location": "17.240597,78.474209", "description": "Pickup Vehicle - 26" }, { "id": "28", "capacity": [ 4 ], "end_index": 0, "Office_Location": "17.240597,78.474209", "description": "Pickup Vehicle - 27" }, { "id": "29", "capacity": [ 4 ], "end_index": 0, "Office_Location": "17.240597,78.474209", "description": "Pickup Vehicle - 28" }, { "id": "30", "capacity": [ 4 ], "end_index": 0, "Office_Location": "17.240597,78.474209", "description": "Pickup Vehicle - 29" }, { "id": "31", "capacity": [ 4 ], "end_index": 0, "Office_Location": "17.240597,78.474209", "description": "Pickup Vehicle - 30" } ]49:T719c,inputPickups = [ { "pickup": { "id": "01060", "location": "17.40655069,78.45563488", "description": "Pickup - Employee 1", "location_index": 1 }, "delivery": { "id": "01060", "location": "17.240597,78.474209", "description": "Description - Employee 1", "location_index": 0 }, "amount": [ 1 ] }, { "pickup": { "id": "01918", "location": "17.21049577,78.47627221", "description": "Pickup - Employee 2", "location_index": 2 }, "delivery": { "id": "01918", "location": "17.240597,78.474209", "description": "Description - Employee 2", "location_index": 0 }, "amount": [ 1 ] }, { "pickup": { "id": "02107", "location": "17.37920787,78.53792934", "description": "Pickup - Employee 3", "location_index": 3 }, "delivery": { "id": "02107", "location": "17.240597,78.474209", "description": "Description - Employee 3", "location_index": 0 }, "amount": [ 1 ] }, { "pickup": { "id": "02775", "location": "17.31780985,78.52353484", "description": "Pickup - Employee 4", "location_index": 4 }, "delivery": { "id": "02775", "location": "17.240597,78.474209", "description": "Description - Employee 4", "location_index": 0 }, "amount": [ 1 ] }, { "pickup": { "id": "04660", "location": "17.41959769,78.51782975", "description": "Pickup - Employee 5", "location_index": 5 }, "delivery": { "id": "04660", "location": "17.240597,78.474209", "description": "Description - Employee 5", "location_index": 0 }, "amount": [ 1 ] }, { "pickup": { "id": "1039075", "location": "17.39229815,78.52725829", "description": "Pickup - Employee 6", "location_index": 6 }, "delivery": { "id": "1039075", "location": "17.240597,78.474209", "description": "Description - Employee 6", "location_index": 0 }, "amount": [ 1 ] }, { "pickup": { "id": "20102011", "location": "17.46010933,78.35409304", "description": "Pickup - Employee 7", "location_index": 7 }, "delivery": { "id": "20102011", "location": "17.240597,78.474209", "description": "Description - Employee 7", "location_index": 0 }, "amount": [ 1 ] }, { "pickup": { "id": "20102012", "location": "17.45491713,78.58134742", "description": "Pickup - Employee 8", "location_index": 8 }, "delivery": { "id": "20102012", "location": "17.240597,78.474209", "description": "Description - Employee 8", "location_index": 0 }, "amount": [ 1 ] }, { "pickup": { "id": "260652", "location": "17.21263593,78.47880973", "description": "Pickup - Employee 9", "location_index": 9 }, "delivery": { "id": "260652", "location": "17.240597,78.474209", "description": "Description - Employee 9", "location_index": 0 }, "amount": [ 1 ] }, { "pickup": { "id": "261281", "location": "17.44031908,78.42531855", "description": "Pickup - Employee 10", "location_index": 10 }, "delivery": { "id": "261281", "location": "17.240597,78.474209", "description": "Description - Employee 10", "location_index": 0 }, "amount": [ 1 ] }, { "pickup": { "id": "270362", "location": "17.52424411,78.37906092", "description": "Pickup - Employee 11", "location_index": 11 }, "delivery": { "id": "270362", "location": "17.240597,78.474209", "description": "Description - Employee 11", "location_index": 0 }, "amount": [ 1 ] }, { "pickup": { "id": "270425", "location": "17.37316057,78.52098998", "description": "Pickup - Employee 12", "location_index": 12 }, "delivery": { "id": "270425", "location": "17.240597,78.474209", "description": "Description - Employee 12", "location_index": 0 }, "amount": [ 1 ] }, { "pickup": { "id": "270948", "location": "17.4413861,78.44772286", "description": "Pickup - Employee 13", "location_index": 13 }, "delivery": { "id": "270948", "location": "17.240597,78.474209", "description": "Description - Employee 13", "location_index": 0 }, "amount": [ 1 ] }, { "pickup": { "id": "273686", "location": "17.34528116,78.4847768", "description": "Pickup - Employee 14", "location_index": 14 }, "delivery": { "id": "273686", "location": "17.240597,78.474209", "description": "Description - Employee 14", "location_index": 0 }, "amount": [ 1 ] }, { "pickup": { "id": "282657", "location": "17.31014547,78.52784539", "description": "Pickup - Employee 15", "location_index": 15 }, "delivery": { "id": "282657", "location": "17.240597,78.474209", "description": "Description - Employee 15", "location_index": 0 }, "amount": [ 1 ] }, { "pickup": { "id": "294275", "location": "17.49384579,78.32058339", "description": "Pickup - Employee 16", "location_index": 16 }, "delivery": { "id": "294275", "location": "17.240597,78.474209", "description": "Description - Employee 16", "location_index": 0 }, "amount": [ 1 ] }, { "pickup": { "id": "295262", "location": "17.14659947,78.52749112", "description": "Pickup - Employee 17", "location_index": 17 }, "delivery": { "id": "295262", "location": "17.240597,78.474209", "description": "Description - Employee 17", "location_index": 0 }, "amount": [ 1 ] }, { "pickup": { "id": "297425", "location": "17.20905546,78.4761414", "description": "Pickup - Employee 18", "location_index": 18 }, "delivery": { "id": "297425", "location": "17.240597,78.474209", "description": "Description - Employee 18", "location_index": 0 }, "amount": [ 1 ] }, { "pickup": { "id": "297668", "location": "17.44170833,78.45101605", "description": "Pickup - Employee 19", "location_index": 19 }, "delivery": { "id": "297668", "location": "17.240597,78.474209", "description": "Description - Employee 19", "location_index": 0 }, "amount": [ 1 ] }, { "pickup": { "id": "298198", "location": "17.5411749,78.43383697", "description": "Pickup - Employee 20", "location_index": 20 }, "delivery": { "id": "298198", "location": "17.240597,78.474209", "description": "Description - Employee 20", "location_index": 0 }, "amount": [ 1 ] }, { "pickup": { "id": "5000867", "location": "17.34055278,78.54264346", "description": "Pickup - Employee 21", "location_index": 21 }, "delivery": { "id": "5000867", "location": "17.240597,78.474209", "description": "Description - Employee 21", "location_index": 0 }, "amount": [ 1 ] }, { "pickup": { "id": "6005044", "location": "17.49183314,78.46193289", "description": "Pickup - Employee 22", "location_index": 22 }, "delivery": { "id": "6005044", "location": "17.240597,78.474209", "description": "Description - Employee 22", "location_index": 0 }, "amount": [ 1 ] }, { "pickup": { "id": "6026380", "location": "17.34845931,78.64696821", "description": "Pickup - Employee 23", "location_index": 23 }, "delivery": { "id": "6026380", "location": "17.240597,78.474209", "description": "Description - Employee 23", "location_index": 0 }, "amount": [ 1 ] }, { "pickup": { "id": "6052072", "location": "17.4839236,78.41624086", "description": "Pickup - Employee 24", "location_index": 24 }, "delivery": { "id": "6052072", "location": "17.240597,78.474209", "description": "Description - Employee 24", "location_index": 0 }, "amount": [ 1 ] }, { "pickup": { "id": "6053186", "location": "17.52416904,78.29713786", "description": "Pickup - Employee 25", "location_index": 25 }, "delivery": { "id": "6053186", "location": "17.240597,78.474209", "description": "Description - Employee 25", "location_index": 0 }, "amount": [ 1 ] }, { "pickup": { "id": "6054699", "location": "17.50914863,78.31190273", "description": "Pickup - Employee 26", "location_index": 26 }, "delivery": { "id": "6054699", "location": "17.240597,78.474209", "description": "Description - Employee 26", "location_index": 0 }, "amount": [ 1 ] }, { "pickup": { "id": "BAL22582", "location": "17.33973721,78.48606724", "description": "Pickup - Employee 27", "location_index": 27 }, "delivery": { "id": "BAL22582", "location": "17.240597,78.474209", "description": "Description - Employee 27", "location_index": 0 }, "amount": [ 1 ] }, { "pickup": { "id": "ROH3755", "location": "17.41514735,78.57566135", "description": "Pickup - Employee 28", "location_index": 28 }, "delivery": { "id": "ROH3755", "location": "17.240597,78.474209", "description": "Description - Employee 28", "location_index": 0 }, "amount": [ 1 ] }, { "pickup": { "id": "SSK40191", "location": "17.31174608,78.50104659", "description": "Pickup - Employee 29", "location_index": 29 }, "delivery": { "id": "SSK40191", "location": "17.240597,78.474209", "description": "Description - Employee 29", "location_index": 0 }, "amount": [ 1 ] }, { "pickup": { "id": "T03547", "location": "17.26307437,78.39878082", "description": "Pickup - Employee 30", "location_index": 30 }, "delivery": { "id": "T03547", "location": "17.240597,78.474209", "description": "Description - Employee 30", "location_index": 0 }, "amount": [ 1 ] }, { "pickup": { "id": "T03799", "location": "17.33949333,78.53261232", "description": "Pickup - Employee 31", "location_index": 31 }, "delivery": { "id": "T03799", "location": "17.240597,78.474209", "description": "Description - Employee 31", "location_index": 0 }, "amount": [ 1 ] }, { "pickup": { "id": "T03808", "location": "17.45717024,78.41939106", "description": "Pickup - Employee 32", "location_index": 32 }, "delivery": { "id": "T03808", "location": "17.240597,78.474209", "description": "Description - Employee 32", "location_index": 0 }, "amount": [ 1 ] }, { "pickup": { "id": "T03837", "location": "17.35570853,78.42301571", "description": "Pickup - Employee 33", "location_index": 33 }, "delivery": { "id": "T03837", "location": "17.240597,78.474209", "description": "Description - Employee 33", "location_index": 0 }, "amount": [ 1 ] }, { "pickup": { "id": "T03875", "location": "17.53122742,78.29428867", "description": "Pickup - Employee 34", "location_index": 34 }, "delivery": { "id": "T03875", "location": "17.240597,78.474209", "description": "Description - Employee 34", "location_index": 0 }, "amount": [ 1 ] }, { "pickup": { "id": "T03921", "location": "17.50632751,78.41132222", "description": "Pickup - Employee 35", "location_index": 35 }, "delivery": { "id": "T03921", "location": "17.240597,78.474209", "description": "Description - Employee 35", "location_index": 0 }, "amount": [ 1 ] }, { "pickup": { "id": "T03965", "location": "17.38620619,78.53151464", "description": "Pickup - Employee 36", "location_index": 36 }, "delivery": { "id": "T03965", "location": "17.240597,78.474209", "description": "Description - Employee 36", "location_index": 0 }, "amount": [ 1 ] }, { "pickup": { "id": "T04014", "location": "17.41126319,78.39498187", "description": "Pickup - Employee 37", "location_index": 37 }, "delivery": { "id": "T04014", "location": "17.240597,78.474209", "description": "Description - Employee 37", "location_index": 0 }, "amount": [ 1 ] }, { "pickup": { "id": "T04033", "location": "17.35731358,78.42074648", "description": "Pickup - Employee 38", "location_index": 38 }, "delivery": { "id": "T04033", "location": "17.240597,78.474209", "description": "Description - Employee 38", "location_index": 0 }, "amount": [ 1 ] }, { "pickup": { "id": "T04092", "location": "17.42687847,78.54729763", "description": "Pickup - Employee 39", "location_index": 39 }, "delivery": { "id": "T04092", "location": "17.240597,78.474209", "description": "Description - Employee 39", "location_index": 0 }, "amount": [ 1 ] }, { "pickup": { "id": "T04128", "location": "17.45156162,78.36683829", "description": "Pickup - Employee 40", "location_index": 40 }, "delivery": { "id": "T04128", "location": "17.240597,78.474209", "description": "Description - Employee 40", "location_index": 0 }, "amount": [ 1 ] }, { "pickup": { "id": "T04142", "location": "17.44601125,78.44701594", "description": "Pickup - Employee 41", "location_index": 41 }, "delivery": { "id": "T04142", "location": "17.240597,78.474209", "description": "Description - Employee 41", "location_index": 0 }, "amount": [ 1 ] }, { "pickup": { "id": "T04182", "location": "17.30769801,78.53620541", "description": "Pickup - Employee 42", "location_index": 42 }, "delivery": { "id": "T04182", "location": "17.240597,78.474209", "description": "Description - Employee 42", "location_index": 0 }, "amount": [ 1 ] }, { "pickup": { "id": "T04191", "location": "17.38738759,78.52918599", "description": "Pickup - Employee 43", "location_index": 43 }, "delivery": { "id": "T04191", "location": "17.240597,78.474209", "description": "Description - Employee 43", "location_index": 0 }, "amount": [ 1 ] }, { "pickup": { "id": "T04226", "location": "17.32817017,78.55290067", "description": "Pickup - Employee 44", "location_index": 44 }, "delivery": { "id": "T04226", "location": "17.240597,78.474209", "description": "Description - Employee 44", "location_index": 0 }, "amount": [ 1 ] }, { "pickup": { "id": "T04228", "location": "17.32595099,78.57287212", "description": "Pickup - Employee 45", "location_index": 45 }, "delivery": { "id": "T04228", "location": "17.240597,78.474209", "description": "Description - Employee 45", "location_index": 0 }, "amount": [ 1 ] }, { "pickup": { "id": "T04256", "location": "17.51442819,78.50559862", "description": "Pickup - Employee 46", "location_index": 46 }, "delivery": { "id": "T04256", "location": "17.240597,78.474209", "description": "Description - Employee 46", "location_index": 0 }, "amount": [ 1 ] }, { "pickup": { "id": "T04296", "location": "17.27136069,78.57809723", "description": "Pickup - Employee 47", "location_index": 47 }, "delivery": { "id": "T04296", "location": "17.240597,78.474209", "description": "Description - Employee 47", "location_index": 0 }, "amount": [ 1 ] }, { "pickup": { "id": "T04299", "location": "17.49873804,78.39371219", "description": "Pickup - Employee 48", "location_index": 48 }, "delivery": { "id": "T04299", "location": "17.240597,78.474209", "description": "Description - Employee 48", "location_index": 0 }, "amount": [ 1 ] }, { "pickup": { "id": "T04309", "location": "17.36422168,78.42460431", "description": "Pickup - Employee 49", "location_index": 49 }, "delivery": { "id": "T04309", "location": "17.240597,78.474209", "description": "Description - Employee 49", "location_index": 0 }, "amount": [ 1 ] }, { "pickup": { "id": "T04338", "location": "17.48821574,78.39994429", "description": "Pickup - Employee 50", "location_index": 50 }, "delivery": { "id": "T04338", "location": "17.240597,78.474209", "description": "Description - Employee 50", "location_index": 0 }, "amount": [ 1 ] }, { "pickup": { "id": "T04380", "location": "17.39318915,78.55934704", "description": "Pickup - Employee 51", "location_index": 51 }, "delivery": { "id": "T04380", "location": "17.240597,78.474209", "description": "Description - Employee 51", "location_index": 0 }, "amount": [ 1 ] }, { "pickup": { "id": "T04417", "location": "17.2009586,78.46820119", "description": "Pickup - Employee 52", "location_index": 52 }, "delivery": { "id": "T04417", "location": "17.240597,78.474209", "description": "Description - Employee 52", "location_index": 0 }, "amount": [ 1 ] }, { "pickup": { "id": "T04451", "location": "17.40248928,78.40913493", "description": "Pickup - Employee 53", "location_index": 53 }, "delivery": { "id": "T04451", "location": "17.240597,78.474209", "description": "Description - Employee 53", "location_index": 0 }, "amount": [ 1 ] }, { "pickup": { "id": "T04487", "location": "17.4992745,78.39226207", "description": "Pickup - Employee 54", "location_index": 54 }, "delivery": { "id": "T04487", "location": "17.240597,78.474209", "description": "Description - Employee 54", "location_index": 0 }, "amount": [ 1 ] }, { "pickup": { "id": "T04491", "location": "17.36637985,78.52197904", "description": "Pickup - Employee 55", "location_index": 55 }, "delivery": { "id": "T04491", "location": "17.240597,78.474209", "description": "Description - Employee 55", "location_index": 0 }, "amount": [ 1 ] }, { "pickup": { "id": "T04560", "location": "17.21071448,78.47501135", "description": "Pickup - Employee 56", "location_index": 56 }, "delivery": { "id": "T04560", "location": "17.240597,78.474209", "description": "Description - Employee 56", "location_index": 0 }, "amount": [ 1 ] }, { "pickup": { "id": "T04563", "location": "17.48234275,78.40764931", "description": "Pickup - Employee 57", "location_index": 57 }, "delivery": { "id": "T04563", "location": "17.240597,78.474209", "description": "Description - Employee 57", "location_index": 0 }, "amount": [ 1 ] }, { "pickup": { "id": "T04615", "location": "17.37451763,78.50286686", "description": "Pickup - Employee 58", "location_index": 58 }, "delivery": { "id": "T04615", "location": "17.240597,78.474209", "description": "Description - Employee 58", "location_index": 0 }, "amount": [ 1 ] }, { "pickup": { "id": "T04635", "location": "17.44387887,78.44280251", "description": "Pickup - Employee 59", "location_index": 59 }, "delivery": { "id": "T04635", "location": "17.240597,78.474209", "description": "Description - Employee 59", "location_index": 0 }, "amount": [ 1 ] }, { "pickup": { "id": "T04650", "location": "17.40247323,78.56693101", "description": "Pickup - Employee 60", "location_index": 60 }, "delivery": { "id": "T04650", "location": "17.240597,78.474209", "description": "Description - Employee 60", "location_index": 0 }, "amount": [ 1 ] }, { "pickup": { "id": "TTLTemp18", "location": "17.45471361,78.39097492", "description": "Pickup - Employee 61", "location_index": 61 }, "delivery": { "id": "TTLTemp18", "location": "17.240597,78.474209", "description": "Description - Employee 61", "location_index": 0 }, "amount": [ 1 ] }, { "pickup": { "id": "TTLTemp20", "location": "17.37973,78.5589207", "description": "Pickup - Employee 62", "location_index": 62 }, "delivery": { "id": "TTLTemp20", "location": "17.240597,78.474209", "description": "Description - Employee 62", "location_index": 0 }, "amount": [ 1 ] }, { "pickup": { "id": "TTLTemp34", "location": "17.34762248,78.64419121", "description": "Pickup - Employee 63", "location_index": 63 }, "delivery": { "id": "TTLTemp34", "location": "17.240597,78.474209", "description": "Description - Employee 63", "location_index": 0 }, "amount": [ 1 ] }, { "pickup": { "id": "TTLTemp44", "location": "17.341316,78.39201449", "description": "Pickup - Employee 64", "location_index": 64 }, "delivery": { "id": "TTLTemp44", "location": "17.240597,78.474209", "description": "Description - Employee 64", "location_index": 0 }, "amount": [ 1 ] }, { "pickup": { "id": "TTLTemp53", "location": "17.39564146,78.52252487", "description": "Pickup - Employee 65", "location_index": 65 }, "delivery": { "id": "TTLTemp53", "location": "17.240597,78.474209", "description": "Description - Employee 65", "location_index": 0 }, "amount": [ 1 ] } ]4a:T889,input_locations = [ "17.240597,78.474209", "17.40655069,78.45563488", "17.21049577,78.47627221", "17.37920787,78.53792934", "17.31780985,78.52353484", "17.41959769,78.51782975", "17.39229815,78.52725829", "17.46010933,78.35409304", "17.45491713,78.58134742", "17.21263593,78.47880973", "17.44031908,78.42531855", "17.52424411,78.37906092", "17.37316057,78.52098998", "17.4413861,78.44772286", "17.34528116,78.4847768", "17.31014547,78.52784539", "17.49384579,78.32058339", "17.14659947,78.52749112", "17.20905546,78.4761414", "17.44170833,78.45101605", "17.5411749,78.43383697", "17.34055278,78.54264346", "17.49183314,78.46193289", "17.34845931,78.64696821", "17.4839236,78.41624086", "17.52416904,78.29713786", "17.50914863,78.31190273", "17.33973721,78.48606724", "17.41514735,78.57566135", "17.31174608,78.50104659", "17.26307437,78.39878082", "17.33949333,78.53261232", "17.45717024,78.41939106", "17.35570853,78.42301571", "17.53122742,78.29428867", "17.50632751,78.41132222", "17.38620619,78.53151464", "17.41126319,78.39498187", "17.35731358,78.42074648", "17.42687847,78.54729763", "17.45156162,78.36683829", "17.44601125,78.44701594", "17.30769801,78.53620541", "17.38738759,78.52918599", "17.32817017,78.55290067", "17.32595099,78.57287212", "17.51442819,78.50559862", "17.27136069,78.57809723", "17.49873804,78.39371219", "17.36422168,78.42460431", "17.48821574,78.39994429", "17.39318915,78.55934704", "17.2009586,78.46820119", "17.40248928,78.40913493", "17.4992745,78.39226207", "17.36637985,78.52197904", "17.21071448,78.47501135", "17.48234275,78.40764931", "17.37451763,78.50286686", "17.44387887,78.44280251", "17.40247323,78.56693101", "17.45471361,78.39097492", "17.37973,78.5589207", "17.34762248,78.64419121", "17.341316,78.39201449", "17.39564146,78.52252487" ]4b:T28ac,pickupsTable = [ { "id": "01060", "location": "17.40655069,78.45563488", "description": "Pickup - Employee 1", "location_index": 1 }, { "id": "01918", "location": "17.21049577,78.47627221", "description": "Pickup - Employee 2", "location_index": 2 }, { "id": "02107", "location": "17.37920787,78.53792934", "description": "Pickup - Employee 3", "location_index": 3 }, { "id": "02775", "location": "17.31780985,78.52353484", "description": "Pickup - Employee 4", "location_index": 4 }, { "id": "04660", "location": "17.41959769,78.51782975", "description": "Pickup - Employee 5", "location_index": 5 }, { "id": "1039075", "location": "17.39229815,78.52725829", "description": "Pickup - Employee 6", "location_index": 6 }, { "id": "20102011", "location": "17.46010933,78.35409304", "description": "Pickup - Employee 7", "location_index": 7 }, { "id": "20102012", "location": "17.45491713,78.58134742", "description": "Pickup - Employee 8", "location_index": 8 }, { "id": "260652", "location": "17.21263593,78.47880973", "description": "Pickup - Employee 9", "location_index": 9 }, { "id": "261281", "location": "17.44031908,78.42531855", "description": "Pickup - Employee 10", "location_index": 10 }, { "id": "270362", "location": "17.52424411,78.37906092", "description": "Pickup - Employee 11", "location_index": 11 }, { "id": "270425", "location": "17.37316057,78.52098998", "description": "Pickup - Employee 12", "location_index": 12 }, { "id": "270948", "location": "17.4413861,78.44772286", "description": "Pickup - Employee 13", "location_index": 13 }, { "id": "273686", "location": "17.34528116,78.4847768", "description": "Pickup - Employee 14", "location_index": 14 }, { "id": "282657", "location": "17.31014547,78.52784539", "description": "Pickup - Employee 15", "location_index": 15 }, { "id": "294275", "location": "17.49384579,78.32058339", "description": "Pickup - Employee 16", "location_index": 16 }, { "id": "295262", "location": "17.14659947,78.52749112", "description": "Pickup - Employee 17", "location_index": 17 }, { "id": "297425", "location": "17.20905546,78.4761414", "description": "Pickup - Employee 18", "location_index": 18 }, { "id": "297668", "location": "17.44170833,78.45101605", "description": "Pickup - Employee 19", "location_index": 19 }, { "id": "298198", "location": "17.5411749,78.43383697", "description": "Pickup - Employee 20", "location_index": 20 }, { "id": "5000867", "location": "17.34055278,78.54264346", "description": "Pickup - Employee 21", "location_index": 21 }, { "id": "6005044", "location": "17.49183314,78.46193289", "description": "Pickup - Employee 22", "location_index": 22 }, { "id": "6026380", "location": "17.34845931,78.64696821", "description": "Pickup - Employee 23", "location_index": 23 }, { "id": "6052072", "location": "17.4839236,78.41624086", "description": "Pickup - Employee 24", "location_index": 24 }, { "id": "6053186", "location": "17.52416904,78.29713786", "description": "Pickup - Employee 25", "location_index": 25 }, { "id": "6054699", "location": "17.50914863,78.31190273", "description": "Pickup - Employee 26", "location_index": 26 }, { "id": "BAL22582", "location": "17.33973721,78.48606724", "description": "Pickup - Employee 27", "location_index": 27 }, { "id": "ROH3755", "location": "17.41514735,78.57566135", "description": "Pickup - Employee 28", "location_index": 28 }, { "id": "SSK40191", "location": "17.31174608,78.50104659", "description": "Pickup - Employee 29", "location_index": 29 }, { "id": "T03547", "location": "17.26307437,78.39878082", "description": "Pickup - Employee 30", "location_index": 30 }, { "id": "T03799", "location": "17.33949333,78.53261232", "description": "Pickup - Employee 31", "location_index": 31 }, { "id": "T03808", "location": "17.45717024,78.41939106", "description": "Pickup - Employee 32", "location_index": 32 }, { "id": "T03837", "location": "17.35570853,78.42301571", "description": "Pickup - Employee 33", "location_index": 33 }, { "id": "T03875", "location": "17.53122742,78.29428867", "description": "Pickup - Employee 34", "location_index": 34 }, { "id": "T03921", "location": "17.50632751,78.41132222", "description": "Pickup - Employee 35", "location_index": 35 }, { "id": "T03965", "location": "17.38620619,78.53151464", "description": "Pickup - Employee 36", "location_index": 36 }, { "id": "T04014", "location": "17.41126319,78.39498187", "description": "Pickup - Employee 37", "location_index": 37 }, { "id": "T04033", "location": "17.35731358,78.42074648", "description": "Pickup - Employee 38", "location_index": 38 }, { "id": "T04092", "location": "17.42687847,78.54729763", "description": "Pickup - Employee 39", "location_index": 39 }, { "id": "T04128", "location": "17.45156162,78.36683829", "description": "Pickup - Employee 40", "location_index": 40 }, { "id": "T04142", "location": "17.44601125,78.44701594", "description": "Pickup - Employee 41", "location_index": 41 }, { "id": "T04182", "location": "17.30769801,78.53620541", "description": "Pickup - Employee 42", "location_index": 42 }, { "id": "T04191", "location": "17.38738759,78.52918599", "description": "Pickup - Employee 43", "location_index": 43 }, { "id": "T04226", "location": "17.32817017,78.55290067", "description": "Pickup - Employee 44", "location_index": 44 }, { "id": "T04228", "location": "17.32595099,78.57287212", "description": "Pickup - Employee 45", "location_index": 45 }, { "id": "T04256", "location": "17.51442819,78.50559862", "description": "Pickup - Employee 46", "location_index": 46 }, { "id": "T04296", "location": "17.27136069,78.57809723", "description": "Pickup - Employee 47", "location_index": 47 }, { "id": "T04299", "location": "17.49873804,78.39371219", "description": "Pickup - Employee 48", "location_index": 48 }, { "id": "T04309", "location": "17.36422168,78.42460431", "description": "Pickup - Employee 49", "location_index": 49 }, { "id": "T04338", "location": "17.48821574,78.39994429", "description": "Pickup - Employee 50", "location_index": 50 }, { "id": "T04380", "location": "17.39318915,78.55934704", "description": "Pickup - Employee 51", "location_index": 51 }, { "id": "T04417", "location": "17.2009586,78.46820119", "description": "Pickup - Employee 52", "location_index": 52 }, { "id": "T04451", "location": "17.40248928,78.40913493", "description": "Pickup - Employee 53", "location_index": 53 }, { "id": "T04487", "location": "17.4992745,78.39226207", "description": "Pickup - Employee 54", "location_index": 54 }, { "id": "T04491", "location": "17.36637985,78.52197904", "description": "Pickup - Employee 55", "location_index": 55 }, { "id": "T04560", "location": "17.21071448,78.47501135", "description": "Pickup - Employee 56", "location_index": 56 }, { "id": "T04563", "location": "17.48234275,78.40764931", "description": "Pickup - Employee 57", "location_index": 57 }, { "id": "T04615", "location": "17.37451763,78.50286686", "description": "Pickup - Employee 58", "location_index": 58 }, { "id": "T04635", "location": "17.44387887,78.44280251", "description": "Pickup - Employee 59", "location_index": 59 }, { "id": "T04650", "location": "17.40247323,78.56693101", "description": "Pickup - Employee 60", "location_index": 60 }, { "id": "TTLTemp18", "location": "17.45471361,78.39097492", "description": "Pickup - Employee 61", "location_index": 61 }, { "id": "TTLTemp20", "location": "17.37973,78.5589207", "description": "Pickup - Employee 62", "location_index": 62 }, { "id": "TTLTemp34", "location": "17.34762248,78.64419121", "description": "Pickup - Employee 63", "location_index": 63 }, { "id": "TTLTemp44", "location": "17.341316,78.39201449", "description": "Pickup - Employee 64", "location_index": 64 }, { "id": "TTLTemp53", "location": "17.39564146,78.52252487", "description": "Pickup - Employee 65", "location_index": 65 } ]4c:[] 43:{"id":"c69886d3a8adc962","slug":"employee-transportation","title":"Solution to Employee Transport and Planning","thumbnail":"49e3b8e7b5c25c76853ac31b4ed41e895e2facb91573182f4e68e995d0ccb899","access_level":"public","create_time":"$D2024-12-11T17:51:04.994Z","update_time":"$D2024-12-13T19:10:23.878Z","view_time":null,"first_public_time":"$D2024-12-13T08:05:09.030Z","has_unpublished_edits":null,"fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"dd0e5f46c5ca7028","login":"prashanthnbai","name":"Prashanth Hiremath","avatar_url":"https://avatars-next.observableusercontent.com/b9301f97a26bb44aeaae28e826065fbeae5e487ffe4c7fe7bb35ce9fff2c6252","tier":"starter_2024","bio":""},"version":714,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"7c6aa4c7c386f728","login":"prashanthnbai","name":"Prashanth Hiremath","avatar_url":"https://avatars-next.observableusercontent.com/b9301f97a26bb44aeaae28e826065fbeae5e487ffe4c7fe7bb35ce9fff2c6252","tier":null,"bio":""}],"members":[{"type":"individual","id":"7c6aa4c7c386f728","login":"prashanthnbai","name":"Prashanth Hiremath","avatar_url":"https://avatars-next.observableusercontent.com/b9301f97a26bb44aeaae28e826065fbeae5e487ffe4c7fe7bb35ce9fff2c6252","tier":null,"role":"editor"},{"type":"team","id":"dd0e5f46c5ca7028","login":"prashanthnbai","name":"Prashanth Hiremath","avatar_url":"https://avatars-next.observableusercontent.com/b9301f97a26bb44aeaae28e826065fbeae5e487ffe4c7fe7bb35ce9fff2c6252","tier":"starter_2024","role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"lapsed":null,"subscribed":null,"forks":1,"collection":null,"type":"notebook","body":{"titling":"auto","title":"Solution to Employee Transport and Planning","cells":[{"id":0,"value":"# Solution to Employee Transport and Planning\n#### Employees pickup with real world constraints","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":4,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":389,"value":"### Introduction\nIn this tutorial, we will walk you through the steps to build, solve, and visualize a complex employee transportation problem, incorporating multiple constraints.\n- Picking up employees from their home/start location\n- Ensuring that employees are dropped off at the office as per their shift timings\n- Defining the maximum time an employee can spend in the cab\n- Ensuring that a cab does not exceed the specified travel distance","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":22,"value":"viewof apikey = secret2(\"apiKey\", {\n title: \"NextBillion.ai API Key\",\n submit: \"Set\",\n description: \"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":407,"value":"### Problem Statement\nHere we are setting the overall problem statement including the objective function to use, arrival time at the office, maximum time that an employee can spend in the cab etc.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":71,"value":"viewof form = Inputs.form({\n // city: Inputs.radio([\"Bengaluru\", \"Hyderabad\"], {label: \"Select city\", value: \"Bengaluru\"}),\n // option2: Inputs.range([0, 100], {label: \"Amount\", step: 1}),\n // employees: Inputs.select([25, 30, 35, 40, 45, 50], {label: \"Number of employees\"}),\n // vehicles: Inputs.select([10, 20, 30, 40, 50, 100], {label: \"Number of vehicles\"}),\n // vehCapacity: Inputs.select([4, 6, 12, 24], {label: \"Vehicle capacity\"}),\n objective: Inputs.select([\"Minimize distance\", \"Minimize duration\"], {label: \"Objective\", value: \"Minimize duration\"}),\n arrivalTimeStart: Inputs.datetime({label: \"Earliest arrival at work\",value: new Date()}),\n arrivalTimeEnd: Inputs.datetime({label: \"Latest arrival at work\",value: new Date(new Date().getTime() + 15 * 60 * 1000)}),\n maxTimeinVehicle: Inputs.radio([60, 90, 120],{label: \"Maximum time an employee can spend in vehicle (mins)\", value: 90})\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":486,"value":"viewof optimizeButton = Inputs.button(\"Optimize\")","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":489,"value":"mvrpid = optimizeButton ? optimizeProblemStatement() : \"\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":177,"value":"---\n### Data used for the problem statement\nLet's take a look at the data used to construct the problem statement.\n\n#### Vehicles\nHere is a list of vehicles along with the constraints defined for the employee pickup phase.\nThe vehicles listed here have varying properties, including seating capacity and the designated office location for employee drop-offs.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":276,"value":"inputVehicles","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":421,"value":"---\n#### Pickup locations of employees\nHere is a list of employees and their pickup locations.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":426,"value":"pickupsTable","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":300,"value":"### Data visualization\nThe map below shows yellow markers representing employees' pickup locations, while the red marker denotes the office location for drop-offs.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":294,"value":"myMap = {\n apikey;\n await visibility();\n const container = html`

`;\n yield container;\n let pos = {\n lat: 17.404551559701872,\n lng: 78.46498762875386\n };\n\n nextbillion.setApiKey(apikey);\n const nbmap = (container.value = new nextbillion.maps.Map({\n container: document.getElementById(\"map\"),\n center: pos,\n zoom: 9.5,\n maxZoom: 21,\n minZoom: 2,\n style: \"https://api.nextbillion.io/maps/dark/style.json\",\n scrollZoom: true,\n hideAttribution: true,\n attributionControl: false\n }));\n loadMapResources(nbmap);\n return nbmap;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":500,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":514,"value":"### Submit the Problem to the Optimization API Endpoint\nThe problem statement has been put together in the request for optimization containing all the pickup locations, vehicles, and options for the solution.\n\nThe optimization API 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 textbox given below.","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":467,"value":"viewof text1 = Inputs.text({label: \"MVRP Request ID: \", value: mvrpid})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":502,"value":"viewof requestResultButton = 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":508,"value":"result = requestResultButton? requestResult(mvrpid) : null","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":656,"value":"#### Routes Summary","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":658,"value":"| KPI | Value |\n| ------ | -------- |\n| Total Routes | ${result.summary.routes}|\n| Unassigned employee pickups | ${result.summary.unassigned}|\n| Total distance | ${Math.round(result.summary.distance/1000)} km|\n| Total travel duration | ${Math.round(result.summary.duration/60)} minutes","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":707,"value":"##### Unassigned pickups","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":711,"value":"viewof table = Inputs.table(result.unassigned)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":702,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":558,"value":"viewof selectRoute = Inputs.select(await routesList(result), {label: \"Select Route\"})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":691,"value":"#### Route wise details","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":696,"value":"| Route | Value |\n| ------ | -------- |\n| Vehicle details | ${selectedRoute[0].description} |\n| Vehicle capacity | 4 |\n| Number of pickups | ${selectedRoute[0].pickup[0]} |\n| Total distance | ${Math.round(selectedRoute[0].distance/1000)} kms|\n| Total duration | ${Math.round(selectedRoute[0].duration/60)} mins |","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":550,"value":"routesMap = {\n apikey;\n await visibility();\n const container = html`

`;\n yield container;\n let pos = {\n lat: 17.404551559701872,\n lng: 78.46498762875386\n };\n\n nextbillion.setApiKey(apikey);\n let nbroutemap = (container.value = new nextbillion.maps.Map({\n container: document.getElementById(\"routesmap\"),\n center: pos,\n zoom: 9.5,\n maxZoom: 21,\n minZoom: 2,\n style: \"https://api.nextbillion.io/maps/dark/style.json\",\n scrollZoom: true,\n hideAttribution: true,\n attributionControl: false\n }));\n // loadRoutes(nbroutemap);\n return nbroutemap;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":589,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":573,"value":"selectedRoute = {\n selectRoute;\n result.routes;\n const vehicleFilter = result.routes.filter(route => route.description === selectRoute);\n loadRoutes(routesMap,vehicleFilter);\n return vehicleFilter;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":531,"value":"---","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":14,"value":"import{nextbillion, cities, secret2} from \"@nbai/nextbillion-ai-dependencies\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":366,"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":313,"value":"$45","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":554,"value":"$46","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":232,"value":"$47","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":519,"value":"async function requestResult(reqid){\n // yield Promises.delay(5000).then(() => {\n let resultjson = null;\n let optResult = await axios({\n method: \"GET\",\n url: `https://api.nextbillion.io/optimization/v2/result?id=${reqid}&key=${apikey}`,\n headers: {} \n }).then(res=> {\n console.log(res.data);\n resultjson = res.data.result;\n })\n .catch(error => {\n let optResult = {\n status: 'Error', \n error: JSON.stringify(error)\n }\n });\n // return {result: optResult};\n return resultjson;\n // })\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":566,"value":"async function routesList(resultJson){\n let routesArray = new Array;\n resultJson.routes.forEach(function(route){\n routesArray.push(route.description);\n })\n console.log(routesArray);\n return routesArray;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":246,"value":"$48","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":270,"value":"$49","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":339,"value":"$4a","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":423,"value":"$4b","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":346,"value":"options = {\n objective: {\n travel_cost: \"duration\"\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":315,"value":"turf = {\n let turf = await require(\"https://unpkg.com/@turf/turf@6/turf.min.js\");\n return turf;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W4c","stdlib":"1"}} 44:"$43:body"