{"id":"https://openalex.org/W2994587791","doi":null,"title":"Application of an Open Source Spreadsheet Solver in Single Depot Routing Problem","display_name":"Application of an Open Source Spreadsheet Solver in Single Depot Routing Problem","publication_year":2018,"publication_date":"2018-12-26","ids":{"openalex":"https://openalex.org/W2994587791","mag":"2994587791"},"language":"en","primary_location":{"id":"pmh:oai:eprints.binus.ac.id:34954","doi":null,"is_oa":true,"landing_page_url":"http://eprints.binus.ac.id/34954/1/Application%20of%20an%20Open%20Source%20Spreadsheet%20Solver.pdf","pdf_url":"http://eprints.binus.ac.id/34954/1/Application%20of%20an%20Open%20Source%20Spreadsheet%20Solver.pdf","source":{"id":"https://openalex.org/S4306401899","display_name":"Binus e-Thesis (Binus University)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I166073570","host_organization_name":"Binus University","host_organization_lineage":["https://openalex.org/I166073570"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"Article"},"volume":null,"type":"article","is_traditional":true,"indexed_in":[],"open_access":{"is_oa":true,"oa_status":"green","oa_url":"http://eprints.binus.ac.id/34954/1/Application%20of%20an%20Open%20Source%20Spreadsheet%20Solver.pdf","any_repository_has_fulltext":true},"authorships":[{"author_position":"first","author":{"id":"https://openalex.org/A5100612496","display_name":"Taufik Roni Sahroni","orcid":"https://orcid.org/0000-0002-8497-3947","observed_orcids":["https://orcid.org/0000-0002-8497-3947","https://orcid.org/0000-0001-9468-3997"]},"institutions":[{"id":"https://openalex.org/I166073570","display_name":"Binus University","ror":"https://ror.org/03zmf4s77","country_code":"ID","type":"education","lineage":["https://openalex.org/I166073570"]}],"countries":["ID"],"is_corresponding":false,"raw_author_name":"\u2060Taufik Roni Sahroni","raw_affiliation_strings":["Bina nusantara university"],"raw_orcid":"https://orcid.org/0000-0002-8497-3947","affiliations":[{"raw_affiliation_string":"Bina nusantara university","institution_ids":["https://openalex.org/I166073570"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5082498640","display_name":"Leo Adi Anggoro","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I166073570","display_name":"Binus University","ror":"https://ror.org/03zmf4s77","country_code":"ID","type":"education","lineage":["https://openalex.org/I166073570"]}],"countries":["ID"],"is_corresponding":false,"raw_author_name":"Leo Adi Anggoro","raw_affiliation_strings":["Bina nusantara university"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Bina nusantara university","institution_ids":["https://openalex.org/I166073570"]}]},{"author_position":"middle","author":{"id":"https://openalex.org/A5065920585","display_name":"Satria Ismail","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I166073570","display_name":"Binus University","ror":"https://ror.org/03zmf4s77","country_code":"ID","type":"education","lineage":["https://openalex.org/I166073570"]}],"countries":["ID"],"is_corresponding":false,"raw_author_name":"Satria Ismail","raw_affiliation_strings":["Bina nusantara university"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Bina nusantara university","institution_ids":["https://openalex.org/I166073570"]}]},{"author_position":"last","author":{"id":"https://openalex.org/A5014966736","display_name":"Aerna Aerna","orcid":null,"observed_orcids":[]},"institutions":[{"id":"https://openalex.org/I166073570","display_name":"Binus University","ror":"https://ror.org/03zmf4s77","country_code":"ID","type":"education","lineage":["https://openalex.org/I166073570"]}],"countries":["ID"],"is_corresponding":false,"raw_author_name":"Aerna Aerna","raw_affiliation_strings":["Bina nusantara university"],"raw_orcid":null,"affiliations":[{"raw_affiliation_string":"Bina nusantara university","institution_ids":["https://openalex.org/I166073570"]}]}],"institutions":[],"countries_distinct_count":1,"institutions_distinct_count":1,"corresponding_author_ids":[],"corresponding_institution_ids":["https://openalex.org/I166073570"],"apc_list":null,"apc_paid":null,"fwci":0.1657,"has_fulltext":true,"cited_by_count":2,"citation_normalized_percentile":{"value":0.56715958,"is_in_top_1_percent":false,"is_in_top_10_percent":false},"cited_by_percentile_year":{"min":88,"max":93},"biblio":{"volume":"7","issue":"6","first_page":"375","last_page":"381"},"is_retracted":false,"is_paratext":false,"is_xpac":false,"primary_topic":{"id":"https://openalex.org/T10567","display_name":"Vehicle Routing Optimization Methods","score":1.0,"subfield":{"id":"https://openalex.org/subfields/2209","display_name":"Industrial and Manufacturing Engineering"},"field":{"id":"https://openalex.org/fields/22","display_name":"Engineering"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},"topics":[{"id":"https://openalex.org/T10567","display_name":"Vehicle Routing Optimization Methods","score":1.0,"subfield":{"id":"https://openalex.org/subfields/2209","display_name":"Industrial and Manufacturing Engineering"},"field":{"id":"https://openalex.org/fields/22","display_name":"Engineering"},"domain":{"id":"https://openalex.org/domains/3","display_name":"Physical Sciences"}},{"id":"https://openalex.org/T12306","display_name":"Urban and Freight Transport Logistics","score":0.0,"subfield":{"id":"https://openalex.org/subfields/3313","display_name":"Transportation"},"field":{"id":"https://openalex.org/fields/33","display_name":"Social Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}},{"id":"https://openalex.org/T12709","display_name":"Optimization and Mathematical Programming","score":0.0,"subfield":{"id":"https://openalex.org/subfields/1803","display_name":"Management Science and Operations Research"},"field":{"id":"https://openalex.org/fields/18","display_name":"Decision Sciences"},"domain":{"id":"https://openalex.org/domains/2","display_name":"Social Sciences"}}],"keywords":[{"id":"https://openalex.org/keywords/vehicle-routing-problem","display_name":"vehicle routing","score":0.9470000267028809},{"id":"https://openalex.org/keywords/fast-moving-consumer-goods","display_name":"fast-moving consumer goods","score":0.8259999752044678},{"id":"https://openalex.org/keywords/distribution-logistics","display_name":"distribution logistics","score":0.48399999737739563},{"id":"https://openalex.org/keywords/distance-minimization","display_name":"distance minimization","score":0.8600000143051147},{"id":"https://openalex.org/keywords/route-optimization","display_name":"route optimization","score":0.4620000123977661}],"concepts":[{"id":"https://openalex.org/C2778770139","wikidata":"https://www.wikidata.org/wiki/Q1966904","display_name":"Solver","level":2,"score":0.8293850421905518},{"id":"https://openalex.org/C123784306","wikidata":"https://www.wikidata.org/wiki/Q944041","display_name":"Vehicle routing problem","level":3,"score":0.7552863955497742},{"id":"https://openalex.org/C21339974","wikidata":"https://www.wikidata.org/wiki/Q178413","display_name":"Gallon (US)","level":2,"score":0.6770406365394592},{"id":"https://openalex.org/C3018397939","wikidata":"https://www.wikidata.org/wiki/Q3644502","display_name":"Open source","level":3,"score":0.65489661693573},{"id":"https://openalex.org/C41008148","wikidata":"https://www.wikidata.org/wiki/Q21198","display_name":"Computer science","level":0,"score":0.6507790088653564},{"id":"https://openalex.org/C74172769","wikidata":"https://www.wikidata.org/wiki/Q1446839","display_name":"Routing (electronic design automation)","level":2,"score":0.6098570823669434},{"id":"https://openalex.org/C2776561332","wikidata":"https://www.wikidata.org/wiki/Q5554853","display_name":"Depot","level":2,"score":0.5276241302490234},{"id":"https://openalex.org/C42475967","wikidata":"https://www.wikidata.org/wiki/Q194292","display_name":"Operations research","level":1,"score":0.40512463450431824},{"id":"https://openalex.org/C111919701","wikidata":"https://www.wikidata.org/wiki/Q9135","display_name":"Operating system","level":1,"score":0.22928568720817566},{"id":"https://openalex.org/C149635348","wikidata":"https://www.wikidata.org/wiki/Q193040","display_name":"Embedded system","level":1,"score":0.2192557156085968},{"id":"https://openalex.org/C127413603","wikidata":"https://www.wikidata.org/wiki/Q11023","display_name":"Engineering","level":0,"score":0.1661631166934967},{"id":"https://openalex.org/C548081761","wikidata":"https://www.wikidata.org/wiki/Q180388","display_name":"Waste management","level":1,"score":0.10083472728729248},{"id":"https://openalex.org/C2777904410","wikidata":"https://www.wikidata.org/wiki/Q7397","display_name":"Software","level":2,"score":0.07948631048202515},{"id":"https://openalex.org/C199360897","wikidata":"https://www.wikidata.org/wiki/Q9143","display_name":"Programming language","level":1,"score":0.0},{"id":"https://openalex.org/C95457728","wikidata":"https://www.wikidata.org/wiki/Q309","display_name":"History","level":0,"score":0.0},{"id":"https://openalex.org/C166957645","wikidata":"https://www.wikidata.org/wiki/Q23498","display_name":"Archaeology","level":1,"score":0.0}],"mesh":[],"locations_count":2,"locations":[{"id":"pmh:oai:eprints.binus.ac.id:34954","doi":null,"is_oa":true,"landing_page_url":"http://eprints.binus.ac.id/34954/1/Application%20of%20an%20Open%20Source%20Spreadsheet%20Solver.pdf","pdf_url":"http://eprints.binus.ac.id/34954/1/Application%20of%20an%20Open%20Source%20Spreadsheet%20Solver.pdf","source":{"id":"https://openalex.org/S4306401899","display_name":"Binus e-Thesis (Binus University)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I166073570","host_organization_name":"Binus University","host_organization_lineage":["https://openalex.org/I166073570"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"Article"},{"id":"mag:2994587791","doi":null,"is_oa":false,"landing_page_url":"https://ojs.excelingtech.co.uk/index.php/IJSCM/article/download/2100/1338","pdf_url":null,"source":null,"license":null,"license_id":null,"version":null,"is_accepted":false,"is_published":false,"raw_source_name":"International Journal of Supply Chain Management","raw_type":null}],"best_oa_location":{"id":"pmh:oai:eprints.binus.ac.id:34954","doi":null,"is_oa":true,"landing_page_url":"http://eprints.binus.ac.id/34954/1/Application%20of%20an%20Open%20Source%20Spreadsheet%20Solver.pdf","pdf_url":"http://eprints.binus.ac.id/34954/1/Application%20of%20an%20Open%20Source%20Spreadsheet%20Solver.pdf","source":{"id":"https://openalex.org/S4306401899","display_name":"Binus e-Thesis (Binus University)","issn_l":null,"issn":null,"is_oa":false,"is_in_doaj":false,"is_core":false,"listed_in":[],"host_organization":"https://openalex.org/I166073570","host_organization_name":"Binus University","host_organization_lineage":["https://openalex.org/I166073570"],"host_organization_lineage_names":[],"type":"repository"},"license":null,"license_id":null,"version":"submittedVersion","is_accepted":false,"is_published":false,"raw_source_name":"","raw_type":"Article"},"sustainable_development_goals":[{"score":0.5378999710083008,"id":"https://metadata.un.org/sdg/9","display_name":"Industry, innovation and infrastructure"}],"study_designs":[],"awards":[],"funders":[],"has_content":{"pdf":true,"grobid_xml":true},"content_urls":{"pdf":"https://content.openalex.org/works/W2994587791.pdf","grobid_xml":"https://content.openalex.org/works/W2994587791.grobid-xml"},"referenced_works_count":20,"referenced_works":["https://openalex.org/W1972645701","https://openalex.org/W1988548390","https://openalex.org/W2003337479","https://openalex.org/W2006487034","https://openalex.org/W2009375919","https://openalex.org/W2018691209","https://openalex.org/W2028630422","https://openalex.org/W2033211895","https://openalex.org/W2037119827","https://openalex.org/W2052172017","https://openalex.org/W2063277077","https://openalex.org/W2063489629","https://openalex.org/W2063605597","https://openalex.org/W2083689835","https://openalex.org/W2099860183","https://openalex.org/W2111581650","https://openalex.org/W2155735286","https://openalex.org/W2167890839","https://openalex.org/W2170908015","https://openalex.org/W2197395854"],"related_works":["https://openalex.org/W2596350817","https://openalex.org/W7014013079","https://openalex.org/W4405858223","https://openalex.org/W4388841841","https://openalex.org/W3167004854","https://openalex.org/W2921440767","https://openalex.org/W7217272824","https://openalex.org/W4404085371","https://openalex.org/W7000270684","https://openalex.org/W7053144442"],"abstract_inverted_index":{"The":[0],"VRP":[1],"has":[2],"been":[3],"broadly":[4],"developed":[5],"with":[6],"additional":[7],"feature":[8],"such":[9,98],"as":[10,41,99],"deliveries,":[11],"selective":[12],"pickups":[13],"and":[14,109,135,144,154],"time":[15,106,132,141],"windows.This":[16],"paper":[17],"presents":[18],"the":[19,52,155],"application":[20],"of":[21,46,148],"an":[22,168],"open":[23,159,169],"source":[24,160,170],"spreadsheet":[25,161,171],"solver":[26,162,172],"in":[27,68,75,87,176],"single":[28,180],"depot":[29,181],"routing":[30,182],"problem.This":[31],"study":[32,90],"focuses":[33],"on":[34,112],"Fast":[35],"Moving":[36],"Consumer":[37],"Goods":[38],"(FMCG)":[39],"Company":[40,78,178],"a":[42,61,166],"case":[43,89],"study.The":[44],"objective":[45],"this":[47,88],"research":[48,55],"is":[49,163],"to":[50,92,107,117,121],"minimize":[51],"distance":[53,126],"travel.This":[54],"begins":[56],"by":[57,96],"collecting":[58],"data":[59],"from":[60],"respective":[62],"FMCG":[63,65,77,177],"Company.A":[64],"company":[66,97],"based":[67],"Jakarta,":[69],"Indonesia":[70],"provides":[71],"drinking":[72],"water":[73],"packaged":[74],"gallon.This":[76],"have":[79],"two":[80],"distributions":[81],"characteristic.Head":[82],"office":[83],"distribution":[84],"was":[85],"used":[86],"due":[91],"highest":[93],"internally":[94],"rejected":[95],"un-routed":[100],"order,":[101],"no":[102],"visit,":[103],"not":[104],"enough":[105],"visit":[108],"transportation":[110],"issue.Based":[111],"computational":[113],"results,":[114],"overall":[115],"solutions":[116,157],"delivered":[118],"214":[119],"gallons":[120],"26":[122],"customers":[123],"having":[124],"total":[125,130,138],"travelled":[127,150],"56.76":[128],"km,":[129],"driving":[131],"2":[133],"hour":[134],"49":[136],"minutes,":[137],"driver":[139],"working":[140],"7":[142],"hours":[143],"57":[145],"minutes.Total":[146],"savings":[147],"distances":[149],"between":[151],"current":[152],"route":[153],"proposed":[156],"using":[158],"7.25":[164],"km.As":[165],"result,":[167],"can":[173],"be":[174],"implemented":[175],"for":[179],"problem.":[183]},"counts_by_year":[{"year":2023,"cited_by_count":1},{"year":2020,"cited_by_count":1}],"updated_date":"2026-11-10T11:39:43.021295","created_date":"2019-12-13T00:00:00"}