{"id":10522,"date":"2021-05-27T16:24:32","date_gmt":"2021-05-27T14:24:32","guid":{"rendered":"https:\/\/blog.ptvgroup.com\/?p=10522"},"modified":"2021-10-14T13:27:43","modified_gmt":"2021-10-14T11:27:43","slug":"bulkberekeningen-excel","status":"publish","type":"post","link":"https:\/\/blog.ptvlogistics.com\/nl\/transport-en-logistiek\/bulkberekeningen-excel\/","title":{"rendered":"Snel en eenvoudig bulkberekeningen in Excel uitvoeren"},"content":{"rendered":"<div class=\"wpb-content-wrapper\"><p>[vc_row][vc_column][vc_column_text]De veranderingen in transportbehoefte kunnen uiteenlopende gevolgen hebben. Denk aan verladers die nieuwe vervoerscontracten willen afsluiten of moeten verhuizen naar een andere locatie. Of aan logistiek dienstverleners die hun distributienetwerk moeten uitbreiden of hun wagenpark deels gaan elektrificeren.<\/p>\n<p>Bedrijven die weloverwogen beslissingen willen nemen, zullen flink moeten rekenen. Welke tarieven moeten in de transportofferte staan? Wat is het effect op de kosten als de vrachtwagens voortaan elders moeten laden? Hoeveel bespaar ik op transportkosten met een extra hub? Wat is het effect op de totale CO2-uitstoot als ik elektrische vrachtwagens aanschaf?[\/vc_column_text][\/vc_column][\/vc_row][vc_row][vc_column][vc_column_text]<\/p>\n<h2 style=\"text-align: center;\">Bulkberekeningen uitvoeren in Excel?<\/h2>\n<p>[\/vc_column_text]\n\t\t\t<div class=\"ult_dual_button  ult-adjust-bottom-margin to-center  \"  data-response=\"on\" id=\"ult_btn_3681882550\">\n\n\t\t\t<div id=\"dualbtn-5398\" class=\"ulitmate_dual_buttons ult-dual-btn ult_main_dualbtn \" data-bcolor=\"#333333\"data-bhcolor=\"\">\n\n\t\t\t<div class=\"ult_dualbutton-wrapper btn-inline place-template bt1 \"><a href=\"https:\/\/www.tlnplanner.nl\/download-quick-guide-tender-plus\" target=\"_blank\" rel=\"noopener\"  class=\"ult_ivan_button round-square with-icon icon-before with-text place-template ult_dual1\" style=\";margin-right:px;;background-color:#ffffff !important;; border-color:#333333;border-style:;border-width:0px;border-radius:px;;\">\n\t\t\t<span class=\"ult-dual-btn-1 Style 1\" style=\"\"  data-bgcolor=\"#ffffff\" data-bghovercolor=\"#d93344\" data-icon_color=\"#333333\" data-icon_hover_color=\"#333333\" data-textcolor=\"#d93344\" data-texthovercolor=\"#ffffff\" data-iconbgcolor=\"transperent\" data-iconbghovercolor=\"transperent\" data-iconborder=\"transperent\" data-iconhoverborder=\"transperent\" >\n\t\t\t<span class=\"icon-simple icon-left1 ult_btn1span ult-dual-btn-no-icon\"  style=\";padding-left:0px; \"><\/span>\n\t\t\t<span class=\"text-btn ult-dual-button-title ult-responsive\"  data-ultimate-target='#dualbtn-5398 .ult-dual-button-title'  data-responsive-json-new='{\"font-size\":\"desktop:20px;\",\"line-height\":\"desktop:15px;\"}'  style=\"font-weight:bold;color:#d93344;\">Download gratis QuickGuide<\/span>\n\n\t\t\t<\/span>\n\t\t\t<\/a><span class=\"middle-text\" style=\"line-height: 1.8em;color:#ffffff;background-color:#d93344;border-width:0px;\">\n\t\t\t<span class=\"middle-inner\"  >or<\/span>\n\t\t\t<\/span>\n\n\t\t\t<\/div>\n\n\t\t\t<div class=\"ult_dualbutton-wrapper btn-inline place-template btn2 \"><a href=\"https:\/\/www.tlnplanner.nl\/contact-tender-plus\" target=\"_blank\" rel=\"noopener\"  class=\"ult_ivan_button round-square with-icon icon-after with-text place-template ult_dual2\"  style=\";background-color:#ffffff !important;;margin-left:px;;border-color:#333333;border-style:;border-width:0px;border-radius:px;\">\n\t\t\t<span class=\"ult-dual-btn-2 Style 1\"  data-bgcolor=\"#ffffff\" data-bghovercolor=\"#d93344\" data-icon_color=\"#333333\" data-icon_hover_color=\"#333333\" data-textcolor=\"#d93344\" data-texthovercolor=\"#ffffff\" data-iconbgcolor=\"transperent\" data-iconbghovercolor=\"transperent\" data-iconborder=\"transperent\" data-iconhoverborder=\"transperent\" >\n\t\t\t<span class=\"text-btn ult-dual-button-title\" style=\"font-weight:bold;color:#d93344;\">Neem contact op<\/span>\n\n\t\t\t<span class=\"icon-simple icon-right2 ult_btn1span ult-dual-btn-no-icon\"  style=\";padding-left:0px; \"><\/span>\n\t\t\t<\/span>\n\t\t\t<\/a><\/div>\n\t\t\t<\/div>\n\t\t\t<\/div>[\/vc_column][\/vc_row][vc_row][vc_column][vc_column_text]<\/p>\n<h2>Tijdrovend en riskant<\/h2>\n<p>[\/vc_column_text][vc_column_text]Binnen veel bedrijven vindt deze calculatie nog grotendeels handmatig plaats. Per rit worden de <a href=\"https:\/\/www.tlnplanner.nl\/vrachtwagen-routeplanner\/transportkosten-berekenen\" target=\"_blank\" rel=\"noopener\">transportkosten berekent<\/a>, rekenen ze uit wat de afstand en rijtijd zijn, hoeveel ze aan tolkosten kwijt zijn en hoeveel <a href=\"https:\/\/blog.ptvgroup.com\/nl\/stad-en-mobiliteit\/energie-transitie-decarbonisation-alliantie-emissies\/\" target=\"_blank\" rel=\"noopener\">CO<sub>2<\/sub><\/a> ze uitstoten. De uitkomsten van alle ritten gaan in een Excel-tabel, waarna met toepassing van de juiste rekenformules een totaaloverzicht volgt.<\/p>\n<p>Dat is een tijdrovend proces wat uren en dagen kan kosten. Bovendien is het een riskant proces, want tijdens het invoeren of het knippen en plakken van data is een fout snel gemaakt. In een sector waarin marges laag zijn, kan een verkeerde calculatie grote gevolgen hebben. En als de omstandigheden of de inzichten veranderen, kan de hele calculatie weer overnieuw beginnen.[\/vc_column_text][\/vc_column][\/vc_row][vc_row][vc_column width=&#8221;1\/2&#8243;][vc_column_text]<\/p>\n<h2>Rekenen met Tender+<\/h2>\n<div>Met de additionele functie <a href=\"https:\/\/www.tlnplanner.nl\/wat-is-tlnplanner\/tender-plus\" target=\"_blank\" rel=\"noopener\">Tender+<\/a> in TLNplanner zijn deze bulkberekeningen nog maar een fluitje van een cent. Het enige wat nodig is, is het uploaden van het Excel-bestand met ritten in deze standaard routeplanner. Vervolgens gaat TLNplanner op de achtergrond aan de slag, zelfs als TLNplanner is afgesloten en de computer uit staat. Als de bulkberekeningen klaar zijn, geeft TLNplanner een seintje en kan het resultaat als Excel-bestand worden gedownload.<\/div>\n<p>Een interface is dus niet nodig om een groot rittenbestand volledig automatisch door te rekenen. Het uploaden van een Excel-bestand is dus al voldoende. Aan dat bestand kunnen naast de start- en eindpunten van alle ritten ook meerdere tussenpunten per rit worden toegevoegd. Wel zo gemakkelijk nu zendingen steeds kleiner worden en het gemiddelde aantal stops per rit in het wegtransport toeneemt.[\/vc_column_text][\/vc_column][vc_column width=&#8221;1\/2&#8243;][vc_empty_space height=&#8221;78px&#8221;][vc_empty_space height=&#8221;78px&#8221;][vc_single_image image=&#8221;10590&#8243; img_size=&#8221;medium&#8221; onclick=&#8221;link_image&#8221;][\/vc_column][\/vc_row][vc_row][vc_column][vc_column_text]<\/p>\n<h2>Voor tenders en meer<\/h2>\n<p>[\/vc_column_text][vc_column_text]Zoals de naam Tender+ al aangeeft, is deze additionele module in <a href=\"https:\/\/www.tlnplanner.nl\/wat-is-tlnplanner\" target=\"_blank\" rel=\"noopener\">TLNplanner<\/a> uitermate geschikt voor transportbedrijven die zijn uitgenodigd om deel te nemen aan een tender. Ze kunnen snel en gemakkelijk afstanden, rijtijden en tolkosten doorrekenen, rekening houdend met de verschillende voertuigprofielen, de laatste wijzigingen in het wegennetwerk en actuele en toekomstige tolkosten.<\/p>\n<p>Maar zoals aangegeven is Tender+ ook geschikt voor de onderbouwing van andere strategische beslissingen. Wat is het effect van een extra hub op de transportkosten en de CO<sub>2<\/sub>-uitstoot? Is het zinvol om te investeren in een ander type voertuig? Hoeveel moet ik doorberekenen aan klanten als de tolkosten omhoog gaan? Ook is het mogelijk om de al uitgevoerde ritten nog eens door te rekenen en rapportages over de winstgevendheid per klant te maken. Wie eenmaal het gemak heeft ervaren, zal Tender+ steeds vaker inzetten om meer inzicht in de transportoperatie te krijgen.[\/vc_column_text][\/vc_column][\/vc_row][vc_row][vc_column][vc_cta h2=&#8221;&#8221; shape=&#8221;square&#8221; style=&#8221;flat&#8221; color=&#8221;black&#8221; add_button=&#8221;bottom&#8221; btn_title=&#8221;Download Quick Guide&#8221; btn_style=&#8221;flat&#8221; btn_shape=&#8221;square&#8221; btn_color=&#8221;white&#8221; btn_link=&#8221;url:https%3A%2F%2Fwww.tlnplanner.nl%2Fdownload-quick-guide-tender-plus|target:_blank&#8221;]<\/p>\n<h2>Automatisch bulkberekeningen uitvoeren?<\/h2>\n<p>Download de gratis Quick Guide![\/vc_cta][\/vc_column][\/vc_row]<\/p>\n<\/div>","protected":false},"excerpt":{"rendered":"<p class=\"card-text\">Binnen veel bedrijven vinden bepaalde calculaties nog grotendeels handmatig in Excel plaats. Per rit handmatig berekenen wat de afstand en rijtijd is, de tolkosten, de transportkosten en hoeveel CO2 ze uitstoten. Met Tender+ berekent u deze gegevens automatisch in Excel uit. [&#8230;]<\/p>\n<p class=\"m-0\"><a class=\"btn btn-outline-secondary btn-read-more\" href=\"https:\/\/blog.ptvlogistics.com\/nl\/transport-en-logistiek\/bulkberekeningen-excel\/\">Lees meer<\/a><\/p>\n","protected":false},"author":72,"featured_media":10899,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1542,1539],"tags":[],"class_list":["post-10522","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-routeplanning","category-transport-en-logistiek"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.3 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Snel en eenvoudig bulkberekeningen in Excel uitvoeren | PTV Logistics Blog<\/title>\n<meta name=\"description\" content=\"Automatisch bulkberekeningen in Excel uitvoeren van bijvoorbeeld: transportkosten, tolkosten, CO2-uitstoot, tijden en afstanden. Meer weten?\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/blog.ptvlogistics.com\/nl\/transport-en-logistiek\/bulkberekeningen-excel\/\" \/>\n<meta property=\"og:locale\" content=\"nl_NL\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Snel en eenvoudig bulkberekeningen in Excel uitvoeren | PTV Logistics Blog\" \/>\n<meta property=\"og:description\" content=\"Automatisch bulkberekeningen in Excel uitvoeren van bijvoorbeeld: transportkosten, tolkosten, CO2-uitstoot, tijden en afstanden. Meer weten?\" \/>\n<meta property=\"og:url\" content=\"https:\/\/blog.ptvlogistics.com\/nl\/transport-en-logistiek\/bulkberekeningen-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"PTV Logistics Blog\" \/>\n<meta property=\"article:published_time\" content=\"2021-05-27T14:24:32+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2021-10-14T11:27:43+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/blog.ptvlogistics.com\/wp-content\/uploads\/2021\/05\/1025x577.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1025\" \/>\n\t<meta property=\"og:image:height\" content=\"577\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Joost de Ouden\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Geschreven door\" \/>\n\t<meta name=\"twitter:data1\" content=\"Joost de Ouden\" \/>\n\t<meta name=\"twitter:label2\" content=\"Geschatte leestijd\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minuten\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/blog.ptvlogistics.com\\\/nl\\\/transport-en-logistiek\\\/bulkberekeningen-excel\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/blog.ptvlogistics.com\\\/nl\\\/transport-en-logistiek\\\/bulkberekeningen-excel\\\/\"},\"author\":{\"name\":\"Joost de Ouden\",\"@id\":\"https:\\\/\\\/blog.ptvlogistics.com\\\/en\\\/#\\\/schema\\\/person\\\/a1a1a0f06f9ac0f856f4f92dce090ac9\"},\"headline\":\"Snel en eenvoudig bulkberekeningen in Excel uitvoeren\",\"datePublished\":\"2021-05-27T14:24:32+00:00\",\"dateModified\":\"2021-10-14T11:27:43+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/blog.ptvlogistics.com\\\/nl\\\/transport-en-logistiek\\\/bulkberekeningen-excel\\\/\"},\"wordCount\":762,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\\\/\\\/blog.ptvlogistics.com\\\/en\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/blog.ptvlogistics.com\\\/nl\\\/transport-en-logistiek\\\/bulkberekeningen-excel\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/blog.ptvlogistics.com\\\/wp-content\\\/uploads\\\/2021\\\/05\\\/1025x577.jpg\",\"articleSection\":[\"Routeplanning\",\"Transport &amp; Logistiek\"],\"inLanguage\":\"nl-NL\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/blog.ptvlogistics.com\\\/nl\\\/transport-en-logistiek\\\/bulkberekeningen-excel\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/blog.ptvlogistics.com\\\/nl\\\/transport-en-logistiek\\\/bulkberekeningen-excel\\\/\",\"url\":\"https:\\\/\\\/blog.ptvlogistics.com\\\/nl\\\/transport-en-logistiek\\\/bulkberekeningen-excel\\\/\",\"name\":\"Snel en eenvoudig bulkberekeningen in Excel uitvoeren | PTV Logistics Blog\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/blog.ptvlogistics.com\\\/en\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/blog.ptvlogistics.com\\\/nl\\\/transport-en-logistiek\\\/bulkberekeningen-excel\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/blog.ptvlogistics.com\\\/nl\\\/transport-en-logistiek\\\/bulkberekeningen-excel\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/blog.ptvlogistics.com\\\/wp-content\\\/uploads\\\/2021\\\/05\\\/1025x577.jpg\",\"datePublished\":\"2021-05-27T14:24:32+00:00\",\"dateModified\":\"2021-10-14T11:27:43+00:00\",\"description\":\"Automatisch bulkberekeningen in Excel uitvoeren van bijvoorbeeld: transportkosten, tolkosten, CO2-uitstoot, tijden en afstanden. Meer weten?\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/blog.ptvlogistics.com\\\/nl\\\/transport-en-logistiek\\\/bulkberekeningen-excel\\\/#breadcrumb\"},\"inLanguage\":\"nl-NL\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/blog.ptvlogistics.com\\\/nl\\\/transport-en-logistiek\\\/bulkberekeningen-excel\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\\\/\\\/blog.ptvlogistics.com\\\/nl\\\/transport-en-logistiek\\\/bulkberekeningen-excel\\\/#primaryimage\",\"url\":\"https:\\\/\\\/blog.ptvlogistics.com\\\/wp-content\\\/uploads\\\/2021\\\/05\\\/1025x577.jpg\",\"contentUrl\":\"https:\\\/\\\/blog.ptvlogistics.com\\\/wp-content\\\/uploads\\\/2021\\\/05\\\/1025x577.jpg\",\"width\":1025,\"height\":577,\"caption\":\"Bulkberekeningen in Excel\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/blog.ptvlogistics.com\\\/nl\\\/transport-en-logistiek\\\/bulkberekeningen-excel\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Startseite\",\"item\":\"https:\\\/\\\/blog.ptvlogistics.com\\\/nl\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Snel en eenvoudig bulkberekeningen in Excel uitvoeren\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/blog.ptvlogistics.com\\\/en\\\/#website\",\"url\":\"https:\\\/\\\/blog.ptvlogistics.com\\\/en\\\/\",\"name\":\"PTV Logistics Blog\",\"description\":\"We bieden technologie\u00ebn met de beste algoritmen en gegevens om besparingen te realiseren in logistieke kosten en emissies.\",\"publisher\":{\"@id\":\"https:\\\/\\\/blog.ptvlogistics.com\\\/en\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/blog.ptvlogistics.com\\\/en\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"nl-NL\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/blog.ptvlogistics.com\\\/en\\\/#organization\",\"name\":\"PTV Logistics\",\"url\":\"https:\\\/\\\/blog.ptvlogistics.com\\\/en\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\\\/\\\/blog.ptvlogistics.com\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/blog.ptvlogistics.com\\\/wp-content\\\/uploads\\\/2023\\\/08\\\/PTV_Logistics_black_black.png\",\"contentUrl\":\"https:\\\/\\\/blog.ptvlogistics.com\\\/wp-content\\\/uploads\\\/2023\\\/08\\\/PTV_Logistics_black_black.png\",\"width\":1479,\"height\":266,\"caption\":\"PTV Logistics\"},\"image\":{\"@id\":\"https:\\\/\\\/blog.ptvlogistics.com\\\/en\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/be.linkedin.com\\\/company\\\/ptvlogistics\",\"https:\\\/\\\/www.youtube.com\\\/@PTVGroupLogistics\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/blog.ptvlogistics.com\\\/en\\\/#\\\/schema\\\/person\\\/a1a1a0f06f9ac0f856f4f92dce090ac9\",\"name\":\"Joost de Ouden\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"nl-NL\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/9a094a7c10ee5b885108bbca69f56cc0e1ade05fef2e9a12e449b7fdf37ba271?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/9a094a7c10ee5b885108bbca69f56cc0e1ade05fef2e9a12e449b7fdf37ba271?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/9a094a7c10ee5b885108bbca69f56cc0e1ade05fef2e9a12e449b7fdf37ba271?s=96&d=mm&r=g\",\"caption\":\"Joost de Ouden\"},\"description\":\"Joost is known for his extensive knowledge and experience in route planning and optimization. In addition, Joost has excellent skills to help organizations with issues in this area. This results in success stories concerning TLNplanner, which Joost is very enthusiastic about.\",\"sameAs\":[\"PTV Group\"],\"url\":\"https:\\\/\\\/blog.ptvlogistics.com\\\/nl\\\/author\\\/joost\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Snel en eenvoudig bulkberekeningen in Excel uitvoeren | PTV Logistics Blog","description":"Automatisch bulkberekeningen in Excel uitvoeren van bijvoorbeeld: transportkosten, tolkosten, CO2-uitstoot, tijden en afstanden. Meer weten?","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/blog.ptvlogistics.com\/nl\/transport-en-logistiek\/bulkberekeningen-excel\/","og_locale":"nl_NL","og_type":"article","og_title":"Snel en eenvoudig bulkberekeningen in Excel uitvoeren | PTV Logistics Blog","og_description":"Automatisch bulkberekeningen in Excel uitvoeren van bijvoorbeeld: transportkosten, tolkosten, CO2-uitstoot, tijden en afstanden. Meer weten?","og_url":"https:\/\/blog.ptvlogistics.com\/nl\/transport-en-logistiek\/bulkberekeningen-excel\/","og_site_name":"PTV Logistics Blog","article_published_time":"2021-05-27T14:24:32+00:00","article_modified_time":"2021-10-14T11:27:43+00:00","og_image":[{"width":1025,"height":577,"url":"https:\/\/blog.ptvlogistics.com\/wp-content\/uploads\/2021\/05\/1025x577.jpg","type":"image\/jpeg"}],"author":"Joost de Ouden","twitter_card":"summary_large_image","twitter_misc":{"Geschreven door":"Joost de Ouden","Geschatte leestijd":"3 minuten"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/blog.ptvlogistics.com\/nl\/transport-en-logistiek\/bulkberekeningen-excel\/#article","isPartOf":{"@id":"https:\/\/blog.ptvlogistics.com\/nl\/transport-en-logistiek\/bulkberekeningen-excel\/"},"author":{"name":"Joost de Ouden","@id":"https:\/\/blog.ptvlogistics.com\/en\/#\/schema\/person\/a1a1a0f06f9ac0f856f4f92dce090ac9"},"headline":"Snel en eenvoudig bulkberekeningen in Excel uitvoeren","datePublished":"2021-05-27T14:24:32+00:00","dateModified":"2021-10-14T11:27:43+00:00","mainEntityOfPage":{"@id":"https:\/\/blog.ptvlogistics.com\/nl\/transport-en-logistiek\/bulkberekeningen-excel\/"},"wordCount":762,"commentCount":0,"publisher":{"@id":"https:\/\/blog.ptvlogistics.com\/en\/#organization"},"image":{"@id":"https:\/\/blog.ptvlogistics.com\/nl\/transport-en-logistiek\/bulkberekeningen-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/blog.ptvlogistics.com\/wp-content\/uploads\/2021\/05\/1025x577.jpg","articleSection":["Routeplanning","Transport &amp; Logistiek"],"inLanguage":"nl-NL","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/blog.ptvlogistics.com\/nl\/transport-en-logistiek\/bulkberekeningen-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/blog.ptvlogistics.com\/nl\/transport-en-logistiek\/bulkberekeningen-excel\/","url":"https:\/\/blog.ptvlogistics.com\/nl\/transport-en-logistiek\/bulkberekeningen-excel\/","name":"Snel en eenvoudig bulkberekeningen in Excel uitvoeren | PTV Logistics Blog","isPartOf":{"@id":"https:\/\/blog.ptvlogistics.com\/en\/#website"},"primaryImageOfPage":{"@id":"https:\/\/blog.ptvlogistics.com\/nl\/transport-en-logistiek\/bulkberekeningen-excel\/#primaryimage"},"image":{"@id":"https:\/\/blog.ptvlogistics.com\/nl\/transport-en-logistiek\/bulkberekeningen-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/blog.ptvlogistics.com\/wp-content\/uploads\/2021\/05\/1025x577.jpg","datePublished":"2021-05-27T14:24:32+00:00","dateModified":"2021-10-14T11:27:43+00:00","description":"Automatisch bulkberekeningen in Excel uitvoeren van bijvoorbeeld: transportkosten, tolkosten, CO2-uitstoot, tijden en afstanden. Meer weten?","breadcrumb":{"@id":"https:\/\/blog.ptvlogistics.com\/nl\/transport-en-logistiek\/bulkberekeningen-excel\/#breadcrumb"},"inLanguage":"nl-NL","potentialAction":[{"@type":"ReadAction","target":["https:\/\/blog.ptvlogistics.com\/nl\/transport-en-logistiek\/bulkberekeningen-excel\/"]}]},{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/blog.ptvlogistics.com\/nl\/transport-en-logistiek\/bulkberekeningen-excel\/#primaryimage","url":"https:\/\/blog.ptvlogistics.com\/wp-content\/uploads\/2021\/05\/1025x577.jpg","contentUrl":"https:\/\/blog.ptvlogistics.com\/wp-content\/uploads\/2021\/05\/1025x577.jpg","width":1025,"height":577,"caption":"Bulkberekeningen in Excel"},{"@type":"BreadcrumbList","@id":"https:\/\/blog.ptvlogistics.com\/nl\/transport-en-logistiek\/bulkberekeningen-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Startseite","item":"https:\/\/blog.ptvlogistics.com\/nl\/"},{"@type":"ListItem","position":2,"name":"Snel en eenvoudig bulkberekeningen in Excel uitvoeren"}]},{"@type":"WebSite","@id":"https:\/\/blog.ptvlogistics.com\/en\/#website","url":"https:\/\/blog.ptvlogistics.com\/en\/","name":"PTV Logistics Blog","description":"We bieden technologie\u00ebn met de beste algoritmen en gegevens om besparingen te realiseren in logistieke kosten en emissies.","publisher":{"@id":"https:\/\/blog.ptvlogistics.com\/en\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/blog.ptvlogistics.com\/en\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"nl-NL"},{"@type":"Organization","@id":"https:\/\/blog.ptvlogistics.com\/en\/#organization","name":"PTV Logistics","url":"https:\/\/blog.ptvlogistics.com\/en\/","logo":{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/blog.ptvlogistics.com\/en\/#\/schema\/logo\/image\/","url":"https:\/\/blog.ptvlogistics.com\/wp-content\/uploads\/2023\/08\/PTV_Logistics_black_black.png","contentUrl":"https:\/\/blog.ptvlogistics.com\/wp-content\/uploads\/2023\/08\/PTV_Logistics_black_black.png","width":1479,"height":266,"caption":"PTV Logistics"},"image":{"@id":"https:\/\/blog.ptvlogistics.com\/en\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/be.linkedin.com\/company\/ptvlogistics","https:\/\/www.youtube.com\/@PTVGroupLogistics"]},{"@type":"Person","@id":"https:\/\/blog.ptvlogistics.com\/en\/#\/schema\/person\/a1a1a0f06f9ac0f856f4f92dce090ac9","name":"Joost de Ouden","image":{"@type":"ImageObject","inLanguage":"nl-NL","@id":"https:\/\/secure.gravatar.com\/avatar\/9a094a7c10ee5b885108bbca69f56cc0e1ade05fef2e9a12e449b7fdf37ba271?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/9a094a7c10ee5b885108bbca69f56cc0e1ade05fef2e9a12e449b7fdf37ba271?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/9a094a7c10ee5b885108bbca69f56cc0e1ade05fef2e9a12e449b7fdf37ba271?s=96&d=mm&r=g","caption":"Joost de Ouden"},"description":"Joost is known for his extensive knowledge and experience in route planning and optimization. In addition, Joost has excellent skills to help organizations with issues in this area. This results in success stories concerning TLNplanner, which Joost is very enthusiastic about.","sameAs":["PTV Group"],"url":"https:\/\/blog.ptvlogistics.com\/nl\/author\/joost\/"}]}},"_links":{"self":[{"href":"https:\/\/blog.ptvlogistics.com\/nl\/wp-json\/wp\/v2\/posts\/10522","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ptvlogistics.com\/nl\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ptvlogistics.com\/nl\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ptvlogistics.com\/nl\/wp-json\/wp\/v2\/users\/72"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ptvlogistics.com\/nl\/wp-json\/wp\/v2\/comments?post=10522"}],"version-history":[{"count":19,"href":"https:\/\/blog.ptvlogistics.com\/nl\/wp-json\/wp\/v2\/posts\/10522\/revisions"}],"predecessor-version":[{"id":13374,"href":"https:\/\/blog.ptvlogistics.com\/nl\/wp-json\/wp\/v2\/posts\/10522\/revisions\/13374"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ptvlogistics.com\/nl\/wp-json\/wp\/v2\/media\/10899"}],"wp:attachment":[{"href":"https:\/\/blog.ptvlogistics.com\/nl\/wp-json\/wp\/v2\/media?parent=10522"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ptvlogistics.com\/nl\/wp-json\/wp\/v2\/categories?post=10522"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ptvlogistics.com\/nl\/wp-json\/wp\/v2\/tags?post=10522"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}