25:["$","title",null,{"children":"Field Service Dispatch - multiday/prioritized_NewData | Dhivya SE Nb.ai | Observable"}] 49:T4cf,kpiTable = { if (!inputData_a) return; let kpis = []; mvrpIDCLM.forEach((sol) => { kpis.push(sol.kpis); }); yield Inputs.table(kpis, { columns: [ "nbrRoutes", "unassigned", "totalTime", "totalDistance", "avgStops" ], header: { nbrRoutes: "Routes", unassigned: "Unassigned", totalTime: "Total Time", totalDistance: "Total Distance", avgStops: "Avg. Stops per Veh" }, width: { planDate: 80, nbrRoutes: 80, unassigned: 80, totalItems: 80, totalTime: 120, totalDistance: 120, avgStops: 120 }, format: { type: (x) => x.toUpperCase(), unassigned: (x) => x, arrival: (x) => new Date(x * 1000).toLocaleTimeString([], { hour: "2-digit", minute: "2-digit", hour12: false }), totalTime: (x) => { const hours = Math.floor(x / 3600); // Get the whole number of hours const minutes = Math.floor((x % 3600) / 60); // Get the remaining minutes return `${hours} HR ${minutes} MIN`; // Format it as "x HR y MIN" } }, maxWidth: 1100, multiple: false, required: false, rows: 100 }); }4a:T918,viewof routeStatsTable = { yield Inputs.table(mvrpPostProcess[0].result.routes, { columns: [ "description", "startTime", "completionTime", "totalStops", "totalRouteTime", "duration", "distance", "service" ], header: { description: "Technician", startTime: "Start", completionTime: "End", loadWeight: "Weight", loadVolume: "Volume", totalItems: "Items", totalDelivery: "Delivery", totalPickup: "Pickup", totalRetrip: "Retrip", totalStops: "Stops", totalRouteTime: "Total Time", duration: "Drive Time", service: "Service Time" }, width: { description: 175, startTime: 50, completionTime: 50, loadWeight: 75, loadVolume: 75, totalItems: 50, totalStops: 50, totalRouteTime: 100, duration: 100, service: 100 }, format: { startTime: (x) => new Date(x * 1000).toLocaleTimeString([], { hour: "2-digit", minute: "2-digit", hour12: false }), completionTime: (x) => new Date(x * 1000).toLocaleTimeString([], { hour: "2-digit", minute: "2-digit", hour12: false }), loadWeight: (x) => `${x} lbs`, loadVolume: (x) => `${x} in³`, totalRouteTime: (x) => { const hours = Math.floor(x / 3600); // Get the whole number of hours const minutes = Math.floor((x % 3600) / 60); // Get the remaining minutes return `${hours} HR ${minutes} MIN`; // Format it as "x HR y MIN" }, distance: (x) => { return `${Math.floor(x * 0.000621371)} MI`; }, duration: (x) => { const hours = Math.floor(x / 3600); // Get the whole number of hours const minutes = Math.floor((x % 3600) / 60); // Get the remaining minutes return `${hours} HR ${minutes} MIN`; // Format it as "x HR y MIN" }, service: (x) => { const hours = Math.floor(x / 3600); // Get the whole number of hours const minutes = Math.floor((x % 3600) / 60); // Get the remaining minutes return `${hours} HR ${minutes} MIN`; // Format it as "x HR y MIN" } }, maxWidth: 1100, multiple: false, required: false, rows: 20 }); }4b:Ta1a,singleRoute = { if (!inputData_a) return; //routeStatsTable.steps = adjustStepTimes(routeStatsTable.steps); if (routeStatsTable) { yield Inputs.table(routeStatsTable.steps, { columns: [ "sequence_nbr", "order_id", "delivery_id", "arrival", "departure", "address", "distance", "duration", "service" ], header: { sequence_nbr: "Seq Nbr", arrival: "Arrival", order_id: "Order ID", departure: "Departure", distance: "Distance", duration: "Drive Time", service: "Service Time", delivery_id: "Account", address: "Address" }, width: { sequence_nbr: 20, order_id: 80, delivery_id: 120, address: 200, arrival: 50, distance: 80, duration: 80, service: 80, departure: 50 }, format: { description: (x) => { return x.split("|")[4]; }, arrival: (x) => new Date(x * 1000).toLocaleTimeString([], { hour: "2-digit", minute: "2-digit", hour12: false }), departure: (x) => new Date(x * 1000).toLocaleTimeString([], { hour: "2-digit", minute: "2-digit", hour12: false }), completionTime: (x) => new Date(x * 1000).toLocaleTimeString([], { hour: "2-digit", minute: "2-digit", hour12: false }), distance: (x) => { return `${(x / 1000).toFixed(1)} KM`; }, totalRouteTime: (x) => { const hours = Math.floor(x / 3600); // Get the whole number of hours const minutes = Math.floor((x % 3600) / 60); // Get the remaining minutes return `${hours} HR ${minutes} MIN`; // Format it as "x HR y MIN" }, duration: (x) => { const hours = Math.floor(x / 3600); // Get the whole number of hours const minutes = Math.floor((x % 3600) / 60); // Get the remaining minutes return `${hours} HR ${minutes} MIN`; // Format it as "x HR y MIN" }, service: (x) => { const hours = Math.floor(x / 3600); // Get the whole number of hours const minutes = Math.floor((x % 3600) / 60); // Get the remaining minutes return `${hours} HR ${minutes} MIN`; // Format it as "x HR y MIN" } }, maxWidth: 1400, multiple: false, required: false, rows: 100 }); } }4c:Tfd7,mvrpIDCLM = { function consolidateRelations(relations) { const vehicleMap = {}; // Group entries by vehicle relations.forEach((entry) => { const vehicle = entry.vehicle; if (!vehicleMap[vehicle]) { vehicleMap[vehicle] = { type: entry.type, vehicle, steps: [] }; } // Extract job steps and add them to the vehicle's steps array const jobSteps = entry.steps.filter((step) => step.type === "job"); vehicleMap[vehicle].steps.push(...jobSteps); }); // Create the consolidated relations array const consolidatedRelations = Object.values(vehicleMap).map((entry) => { // Ensure the steps begin with a "start" step const consolidatedSteps = [{ type: "start" }, ...entry.steps]; return { ...entry, steps: consolidatedSteps }; }); return consolidatedRelations; } if (inputData_a) { let location = []; //V2 API let loc_index = 0; let shipments = []; let jobs = []; let vehicles = []; let depots = []; let locations = []; let bodyData = []; let nbrVehicles = 1; let clusters = []; let clusterLocations = []; vehicles = []; shipments = []; let relations = []; locations = []; location = []; loc_index = 0; // Create Vehicle object // hardcoded capacity [weight,volume] for each box truck trucksCLM.forEach((v, idx) => { location.push(`${v["Latitude"]},${v["Longitude"]}`); for (let i = 4; i < 18; i++) { let startTimeStr = `01/${String(i).padStart(2, "0")}/2025 ${ v["Start Time"].split(" ")[0] }:00 CST`; let endTimeStr = `01/${String(i).padStart(2, "0")}/2025 ${ v["End Time"].split(" ")[0] }:00 CST`; // Parse the date and convert to UNIX epoch let starttimestamp = Math.floor(Date.parse(startTimeStr) / 1000); let endtimestamp = Math.floor(Date.parse(endTimeStr) / 1000) + 12 * 3600; let vehicle = { id: `${v["Tech ID#"]}-01/${String(i).padStart(2, "0")}`, description: `${v["Tech ID#"]}-${v["Tech Last Name"]}-01/${String( i ).padStart(2, "0")}`, start_index: loc_index, end_index: loc_index, skills: v.skills, time_window: [starttimestamp, endtimestamp] }; vehicles.push(vehicle); } loc_index++; }); let relationCount = 0; ordersCLM.forEach((o, idx) => { if (o.techID) { relationCount++; let relation = { type: "in_direct_sequence", vehicle: `${o.techID}-01/14`, steps: [ { type: "start" }, { type: "job", id: `${o["WO #"]}|${o.adjustedPriority}` } ] }; relations.push(relation); } let job = { id: `${o["WO #"]}|${o.adjustedPriority}`, description: `${o["WO #"]}|${o["Client (Loc)"]}|${o["Address 1"]},${o["City"]}, ${o["State"]}|${o["Tech Name"]}`, location_index: loc_index, skills: o.skills, service: parseFloat(o["Avg Time Per Category (HRS)"]) * 3600, priority: parseInt(o.adjustedPriority) }; jobs.push(job); location.push(`${o.Latitude},${o.Longitude}`); loc_index++; }); locations = { id: 12, location: location }; bodyData.push({ description: `CLM Test`, locations: locations, vehicles: vehicles, relations: consolidateRelations(relations), jobs: jobs, options: { routing: { mode: "car" }, objective: { solver_mode: "internal" } } }); console.log("Vehicles:", vehicles); console.log("Jobs:", jobs); console.log("Relations:", relations); console.log("Locations:", locations); console.log("Body Data:", bodyData); const result = await Promise.all( bodyData.map(async (data) => { return mvrp(data); }) ); return result; } }4d:T571,mvrpPostProcess = { let routes = []; mvrpIDCLM[0].result.routes.forEach((sol) => { let newSteps = []; const steps = sol.steps; let totalRouteTime = 0; if (steps && steps.length > 1) { totalRouteTime = steps[steps.length - 1].arrival - steps[0].arrival; } let completionTime = steps[steps.length - 1].arrival; let startTime = steps[0].arrival; let totalItems = 0; let totalStops = 0; let totalDelivery = 0; let totalPickup = 0; let totalRetrip = 0; steps.forEach((s, idx) => { if (s.type === "job") { totalStops++; } let step = { sequence_nbr: idx, order_id: s.description ? s.description.split("|")[0] : "", delivery_id: s.description ? s.description.split("|")[1] : "", address: s.description ? s.description.split("|")[2] : "", departure: s.arrival + s.service, ...s }; newSteps.push(step); }); sol.steps = newSteps; //sol.steps = adjustStepTimes(sol.steps); routes.push({ ...sol, completionTime: completionTime, startTime: startTime, totalItems: totalItems, totalStops: totalStops, totalDelivery: totalDelivery, totalPickup: totalPickup, totalRetrip: totalRetrip, totalRouteTime: totalRouteTime }); }); mvrpIDCLM[0].result.routes = routes; return mvrpIDCLM; }4e:T693,async function mvrp(data) { let url = ""; url = `https://api.nextbillion.io/optimization/v2`; progress.value = 0; const optimizeRequest = await axios .post(`${url}` + `?key=${apiKey}`, { ...data }) .then((res) => res.data); const mvrpRequestId = optimizeRequest.id; let attempts = 0; while (attempts < 100) { console.log(`attempts - ${attempts}`); const result = await axios({ url: `${url}/result?id=${mvrpRequestId}&key=${apiKey}`, method: "GET", headers: {} }); if ( result.data && result.data.status === "Ok" && result.data.message != "Job still processing" ) { result.data.id = mvrpRequestId; // KPIs let deliveryCount = 0; result.data.result.routes.forEach((rte, rteidx) => { rte.steps.forEach((step, index) => { if (step.id && step.id != 99) { ++deliveryCount; } }); }); result.data.kpis = { totalDistance: `${(result.data.result.summary.distance / 1000).toFixed( 1 )} km`, totalTime: result.data.result.summary.duration, nbrRoutes: result.data.result.summary.routes, nbrOrders: deliveryCount, avgStops: (deliveryCount / result.data.result.summary.routes).toFixed( 1 ), unassigned: result.data.result.summary.unassigned, planDate: result.data.description.split("|")[1], totalItems: result.data.description.split("|")[3] }; progress.value = 0; return result.data; } attempts++; progress.value += 2; await new Promise((resolve) => setTimeout(resolve, 5 * 1000)); } }4f:T5b8,trucksCLM = { // Create a lookup for categoryCLM by name const categoryLookup = {}; categoryCLM.forEach((item) => { categoryLookup[item.name.toLowerCase().trim()] = item.id; }); let theTrucks = await FileAttachment("Main sheet-Table 1@2.csv").csv(); theTrucks.forEach((truck) => { // Initialize an empty skills array truck.skills = []; // Remove all fields starting with 'Column' Object.keys(truck).forEach((key) => { if (key.startsWith("Column")) { delete truck[key]; } }); // Trim keys and update the object Object.keys(truck).forEach((key) => { const trimmedKey = key.trim(); // Remove whitespace around the key if (trimmedKey !== key) { truck[trimmedKey] = truck[key]; // Add new key with trimmed name delete truck[key]; // Remove old key } }); // Add skills based on matching trades Object.keys(truck).forEach((key) => { if (key.startsWith("Trade") && truck[key]) { const tradeName = truck[key].trim(); const skillId = categoryLookup[tradeName.toLowerCase()]; if (skillId) { truck.skills.push(skillId); } } }); truck.skills.push(1200); // UnKnown category // Remove all 'Trade n' keys with empty strings Object.keys(truck).forEach((key) => { if (key.startsWith("Trade") && truck[key].trim() === "") { delete truck[key]; } }); }); return theTrucks; }50:T8ba,ordersCLM = { function normalizePriorityScore(value, min, max) { if (typeof value === "string") { const priorityMap = { P1: 99, P2: 75, P3: 50, P4: 25, P5: 1, "SEV 1": 99, "SEV 2": 75, "SEV 3": 50 }; // Find the first matching key in the string for (const key in priorityMap) { if (value.startsWith(key)) { return priorityMap[key]; } } return Math.round(((value - min) / (max - min)) * (99 - 1) + 1); } // If value is numeric, normalize within the range return Math.round(((value - min) / (max - min)) * (99 - 1) + 1); } const techLookup = {}; trucksCLM.forEach((t) => { techLookup[`${t["Tech First Name"]} ${t["Tech Last Name"]}`] = t["Tech ID#"]; }); const categoryLookup = {}; categoryCLM.forEach((item) => { categoryLookup[item.name.toLowerCase().trim()] = item.id; }); let theOrders = await FileAttachment( "NextBillionData@1.csv" ).csv(); theOrders.forEach((order) => { // Normalize the priority string to something from 1-99 for NB.ai order.adjustedPriority = normalizePriorityScore( order["Priority Score"], 1, 540 ); // Initialize an empty skills array order.skills = []; // Trim keys and update the object Object.keys(order).forEach((key) => { const trimmedKey = key.trim(); // Remove whitespace around the key if (trimmedKey !== key) { order[trimmedKey] = order[key]; // Add new key with trimmed name delete order[key]; // Remove old key } }); Object.keys(order).forEach((key) => { if (key.startsWith("Tech Name2") && order[key] != "N/A") { const techId = techLookup[order["Tech Name2"]]; if (techId) { order.techID = techId; } } }); // Add skills based on matching trades Object.keys(order).forEach((key) => { if (key.startsWith("Category") && order[key]) { const tradeName = order[key].trim(); const skillId = categoryLookup[tradeName.toLowerCase()]; if (skillId) { order.skills.push(skillId); } } }); }); return theOrders; }51:Ta7a,styling = html` `52:[{"id":"4340c7143acc7fee2678d3b083c3c6f48fcf3092ce09ef05fa709245e6484cafbd949ff0e7a21bc53a9fb05bc9535393bbb34ab01ea458d2b59687337c1d7ca4","href":"https://static.observableusercontent.com/files/4340c7143acc7fee2678d3b083c3c6f48fcf3092ce09ef05fa709245e6484cafbd949ff0e7a21bc53a9fb05bc9535393bbb34ab01ea458d2b59687337c1d7ca4","name":"NextBillionData@1.csv","type":"text/csv","lastModified":1740488431415.355,"size":100127},{"id":"a2476dc4a2b847e73bc4ead218113babb405043b9cc80d7fb9e870867fcc8119868720cdb974e2c2139620bf584c717ed26e80e9797d1ddc34eb22121a3be15f","href":"https://static.observableusercontent.com/files/a2476dc4a2b847e73bc4ead218113babb405043b9cc80d7fb9e870867fcc8119868720cdb974e2c2139620bf584c717ed26e80e9797d1ddc34eb22121a3be15f","name":"Main sheet-Table 1@2.csv","type":"text/csv","lastModified":1740383480754.464,"size":87674}] 29:{"id":"632293f79e7e7121","slug":null,"title":"Field Service Dispatch - multiday/prioritized_NewData","thumbnail":"d1073d60bd25348165ec9a389a28b80bf5870ed4f9a6ab357f246c8480f9c8c9","access_level":"public","create_time":"$D2025-02-24T07:51:20.754Z","update_time":"$D2025-02-25T13:13:59.869Z","view_time":null,"first_public_time":"$D2025-02-25T13:14:21.890Z","has_unpublished_edits":null,"fork":true,"stars":0,"starred":false,"owner":{"type":"team","id":"92cd7e05d9eb53e5","login":"nextbillion","name":"Dhivya SE Nb.ai","avatar_url":"https://avatars-next.observableusercontent.com/21b1b4637facabb497b45850c02f201174399d01e2f9a14fb27232b052416674","tier":"starter_2024","bio":"","followed_by_you":false,"follows_you":false},"version":1025,"publish_version":null,"role":null,"authored":false,"authors":[{"type":"individual","id":"53e0d2bd94fa8912","login":"dhivya-s","name":"Dhivya Selvarajan","avatar_url":"https://avatars-next.observableusercontent.com/c2ddc5b79da0e63c190a3f3ac91670f23f26b4bc0b1be30699fe67082ccb4f0b","tier":null,"bio":"","followed_by_you":false,"follows_you":false}],"members":[{"type":"individual","id":"53e0d2bd94fa8912","login":"dhivya-s","name":"Dhivya Selvarajan","avatar_url":"https://avatars-next.observableusercontent.com/c2ddc5b79da0e63c190a3f3ac91670f23f26b4bc0b1be30699fe67082ccb4f0b","tier":null,"role":"editor"},{"type":"team","id":"92cd7e05d9eb53e5","login":"nextbillion","name":"Dhivya SE Nb.ai","avatar_url":"https://avatars-next.observableusercontent.com/21b1b4637facabb497b45850c02f201174399d01e2f9a14fb27232b052416674","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":"Field Service Dispatch - multiday/prioritized_NewData","cells":[{"id":0,"value":"# Field Service Dispatch - multiday/prioritized_NewData","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":353,"value":"----","pinned":false,"hidden":false,"mode":"md","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"","database":"$undefined"},{"id":914,"value":"viewof jobInputs = {\n yield Inputs.table(ordersCLM, {\n columns: [\n \"WO #\",\n \"Avg Time Per Category (HRS)\",\n \"Input Date/Time\",\n \"Client (Loc)\",\n \"Address 1\",\n \"City\",\n \"Status\",\n \"Category\",\n \"Priority Score\",\n \"adjustedPriority\"\n ],\n header: {\n \"Input Date/Time\": \"Entered\",\n \"Avg Time Per Category (HRS)\": \"Svc Time\",\n \"Client (Loc)\": \"Client\",\n \"Priority Score\": \"Priority\",\n adjustedPriority: \"Normalized Priority\"\n }\n });\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":876,"value":"viewof panel2 = Inputs.form(inputs, {\n template: (v) => htl.html`\n

\n ${v.delDate}\n ${v.depot}\n ${v.cluster}\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":874,"value":"{\n const button = html` `;\n button.onclick = () => {\n mutable inputData_a = panel2;\n button.disabled = true;\n };\n return html`${button}`;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":173,"value":"progress = html``","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":378,"value":"md`### 01/14/25 ${trucksCLM.length} Techs ${ordersCLM.length} Jobs`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":461,"value":"$49","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":469,"value":"$4a","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":518,"value":"$4b","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":156,"value":"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":5,"value":"{\n nextbillion.setApiKey(apiKey);\n return html`Set API key
nextbillion.setApiKey(${apiKey.substr(\n 0,\n 4\n )}....)`;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":150,"value":"ncc_url = {\n const result = await axios({\n url: `https://api.nextbillion.io/optimization/v2/create_shared_result?key=${apiKey}&id=${mvrpIDCLM[0].id}`,\n method: \"GET\",\n headers: {}\n });\n return `console.nextbillion.ai/route-planner-viewer?id=${result.data.id}&host=api.nextbillion.io`;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":780,"value":"$4c","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":554,"value":"$4d","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":135,"value":"findDuplicateOrders = {\n // Create a map to count occurrences of each \"Order id\"\n const orderCounts = ordersCLM.reduce((counts, order) => {\n counts[order[\"Order id\"]] = (counts[order[\"Order id\"]] || 0) + 1;\n return counts;\n }, {});\n\n // Filter the orders array to only include duplicates\n const duplicates = ordersCLM.filter(\n (order) => orderCounts[order[\"Order id\"]] > 1\n );\n\n return duplicates;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":141,"value":"$4e","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":10,"value":"import { nextbillion, parameters } 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":143,"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":751,"value":"$4f","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":748,"value":"$50","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":755,"value":"categoryCLM = [\n { id: 100, name: \"Plumbing\" },\n { id: 200, name: \"Preventative Maintenance\" },\n { id: 300, name: \"General Carpentry\" },\n { id: 400, name: \"Painting\" },\n { id: 500, name: \"HVAC\" },\n { id: 600, name: \"Lighting\" },\n { id: 700, name: \"Electrical\" },\n { id: 800, name: \"Doors\" },\n { id: 900, name: \"Flooring\" },\n { id: 1000, name: \"Other\" },\n { id: 1100, name: \"Equipment\" },\n { id: 1200, name: \"UnKnown\" },\n { id: 1300, name: \"Fencing\" },\n { id: 1400, name: \"Work Order\" },\n { id: 1500, name: \"Backflow\" },\n { id: 1600, name: \"Parking lot / Paving\" },\n { id: 1700, name: \"Pest Exclusionary\" },\n { id: 1800, name: \"Locksmith\" },\n { id: 1900, name: \"Drywall\" },\n { id: 2000, name: \"Power Wash\" },\n { id: 2100, name: \"Carpet\" },\n { id: 2200, name: \"General Maintenance\" },\n { id: 2300, name: \"Medicart\" }\n]","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":7,"value":"apiKey = \"73d4bee8352b46e483d75fb924889ada\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":82,"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":59,"value":"function parseDateStringWithOffset(dateString, offsetMinutes) {\n const [datePart, timePart] = dateString.split(\" \");\n const [day, month, year] = datePart.split(\"/\").map(Number);\n const [hours, minutes] = timePart.split(\":\").map(Number);\n\n // Create a Date object in the local time zone\n const localDate = new Date(year, month - 1, day, hours, minutes);\n\n // Convert local time to UTC\n const utcDate = new Date(\n localDate.getTime() - localDate.getTimezoneOffset() * 60000\n );\n\n // Apply the desired offset\n const offsetDate = new Date(utcDate.getTime() + offsetMinutes * 60000);\n\n return offsetDate;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":56,"value":"inputs = {\n const offset = new Date().getTimezoneOffset();\n\n let newBase = new Date(new Date().getTime() + 86400 * 1000);\n const inputString = \"05/07/2024 03:00\";\n const tmrwStart = parseDateStringWithOffset(inputString, 240);\n\n const endString = \"05/07/2024 13:00\";\n const tmrwEnd = parseDateStringWithOffset(endString, 240);\n\n const inputs = {\n serviceTime: Inputs.text({\n label: \"Service Time at Each Stop\",\n value: \"900\"\n })\n };\n return inputs;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":96,"value":"function convertToEpoch(dateString) {\n // Ensure the date string is in the format MM/DD/YY or MM/D/YY\n const formattedDate = dateString.replace(\n /(\\d{1,2})\\/(\\d{1,2})\\/(\\d{2})/,\n (match, month, day, year) => {\n // Pad single-digit day or month with zero if needed\n const paddedMonth = month.padStart(2, \"0\");\n const paddedDay = day.padStart(2, \"0\");\n return `${paddedMonth}/${paddedDay}/${year}`;\n }\n );\n\n // Append time and timezone information\n const dateTimeString = `${formattedDate} 08:00:00 EST`;\n\n // Parse the date and convert to UNIX epoch\n const timestamp = Date.parse(dateTimeString);\n\n // Return the UNIX epoch timestamp in seconds\n return Math.floor(timestamp / 1000);\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":255,"value":"function summarizeOrdersByDateAndLocation(orders) {\n // Create an object to store counts\n const summary = {};\n\n // Iterate over orders and count each fulfill location per delivery date\n orders.forEach((order) => {\n const date = order[\"Delivery date\"];\n const location = order[\"Fulfill location\"];\n\n if (!summary[date]) {\n summary[date] = {};\n }\n\n if (!summary[date][location]) {\n summary[date][location] = 0;\n }\n\n summary[date][location] += 1;\n });\n\n // Convert the summary object into a table format\n const dates = Object.keys(summary);\n const locations = [\n ...new Set(orders.map((order) => order[\"Fulfill location\"]))\n ];\n\n // Create the table with headers\n const table = dates.map((date) => {\n const row = { date };\n locations.forEach((location) => {\n row[location] = summary[date][location] || 0;\n });\n return row;\n });\n\n return table;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":545,"value":"function adjustStepTimes(steps) {\n // Iterate over the steps\n //steps.forEach((s) => {\n // s.departure = s.arrival + s.service;\n //});\n console.log(steps);\n for (let i = 0; i < steps.length - 1; i++) {\n let currentStep = steps[i];\n //console.log(currentStep.departure);\n let j = i + 1;\n\n // Check for successive steps with the same address\n while (j < steps.length && steps[j].address === currentStep.address) {\n // Adjust arrival and departure times\n currentStep.arrival = Math.min(currentStep.arrival, steps[j].arrival);\n currentStep.departure = Math.max(\n currentStep.departure,\n steps[j].departure\n );\n j++;\n }\n\n // Update all matching steps in the range\n for (let k = i + 1; k < j; k++) {\n steps[k].arrival = currentStep.arrival;\n steps[k].departure = currentStep.departure;\n }\n\n // Skip the processed range\n i = j - 1;\n }\n\n return steps;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"},{"id":84,"value":"$51","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined","tool":"$undefined","providerMetadata":"$undefined","attachments":"$undefined","output":"$undefined","database":"$undefined"}],"files":"$W52","stdlib":"1"}} 24:null