Spreadsheet: 731502d1620374708-easy-way-to-calculate-price-based-on-cbm-and-zone-test-sheet
Sheet: Price sheet

 | Standardpriser
 | op til | Zone 1 | Zone 2 | Zone 3 | Zone 4 | Zone 5 | Zone 6 | Zone 7 | Zone 8 | Zone 9 | Zone 10 | Zone 11 | Zone 12 | Zone 13 | Zone 14 | Zone 15 | Zone 16 | Zone 17 | Zone 18 | Zone 19 | Zone 20 | Zone 21
 | CBM
 | 0.5 | 287.0966076029934 | 272.4050829499761 | 258.3917725347326 | 484.8540907187174 | 272.4050829499761 | 333.4142514651212 | 210.5041755658312 | 210.5041755658312 | 228.9029981088601 | 200.5832418416489 | 228.9029981088601 | 200.5832418416489 | 184.5293672697903 | 200.5832418416489 | 200.5832418416489 | 210.5041755658312 | 200.5832418416489 | 200.5832418416489 | 157.6526559079147 | 184.5293672697903 | 200.5832418416489
 | 1 | 480.3931330923104 | 447.7423571699731 | 432.3618945190963 | 778.1774218441294 | 447.7423571699731 | 518.6633793934614 | 314.7641699763285 | 314.7641699763285 | 347.2326803463795 | 300.3337209229725 | 347.2326803463795 | 300.3337209229725 | 263.3556952237476 | 300.3337209229725 | 300.3337209229725 | 314.7641699763285 | 300.3337209229725 | 300.3337209229725 | 224.5738633928532 | 263.3556952237476 | 300.3337209229725
 | 1.5 | 654.8478482535921 | 609.9500313495826 | 589.3740705037751 | 987.1200686731898 | 609.9602282057181 | 694.5922098692615 | 400.7779715933999 | 400.7779715933999 | 450.6740242817347 | 366.9774197722697 | 450.6740242817347 | 366.9774197722697 | 333.1768679511395 | 366.9774197722697 | 366.9774197722697 | 400.7779715933999 | 366.9774197722697 | 366.9774197722697 | 282.4760402194443 | 333.1768679511395 | 366.9774197722697
 | 2 | 766.6718016423036 | 713.65346700069 | 690.0175081577183 | 1202.75959520831 | 713.65346700069 | 809.7222029430903 | 512.5029483026524 | 512.5029483026524 | 558.3751257741861 | 472.9579677237441 | 558.3751257741861 | 472.9579677237441 | 434.2038867564138 | 472.9579677237441 | 472.9579677237441 | 512.5029483026524 | 472.9579677237441 | 472.9579677237441 | 356.6957248217535 | 434.2038867564138 | 472.9579677237441
 | 3 | 925.4396142514071 | 905.1821850679173 | 832.9112081705665 | 1435.811008979185 | 905.2125283242615 | 997.035204919454 | 657.237577221457 | 657.237577221457 | 700.7370558582561 | 626.3924923699084 | 700.7370558582561 | 626.3924923699084 | 578.1476160636405 | 626.3924923699084 | 626.3924923699084 | 657.237577221457 | 626.3924923699084 | 626.3924923699084 | 463.4671723848062 | 578.1476160636405 | 626.3924923699084
 | 4 | 1249.986145638185 | 1195.863835342115 | 1125.008541591494 | 1753.243107046412 | 1195.863835342115 | 1311.545947588028 | 818.0954578710307 | 818.0954578710307 | 885.2525476962644 | 765.4381942580629 | 885.2525476962644 | 765.4381942580629 | 716.5966743851658 | 765.4381942580629 | 765.4381942580629 | 818.0954578710307 | 765.4381942580629 | 765.4381942580629 | 601.3612134350486 | 716.5966743851658 | 765.4381942580629
 | 5 | 1628.575078741034 | 1572.225070978532 | 1465.744944933999 | 0 | 1572.225070978532 | 1710.254863999222 | 892.1902635873008 | 892.1902635873008 | 990.70582924002 | 838.7698512263196 | 990.70582924002 | 838.7698512263196 | 778.4117229743016 | 838.7698512263196 | 838.7698512263196 | 892.1902635873008 | 838.7698512263196 | 838.7698512263196 | 664.6331823613021 | 778.4117229743016 | 838.7698512263196
 | 5.5 | 1628.575078741034 | 1572.225070978532 | 1465.744944933999 | 0 | 1572.225070978532 | 1710.254863999222 | 890.5474612520641 | 890.5474612520641 | 990.70582924002 | 838.7698512263196 | 989.4971791689601 | 838.7698512263196 | 778.4117229743016 | 838.7698512263196 | 838.7698512263196 | 890.5474612520641 | 838.7698512263196 | 838.7698512263196 | 664.6331823613021 | 778.4117229743016 | 838.7698512263196
 | 6 | 1628.575078741034 | 1572.225070978532 | 1465.744944933999 | 0 | 1572.225070978532 | 1710.254863999222 | 890.5474612520641 | 890.5474612520641 | 990.70582924002 | 838.7698512263196 | 989.4971791689601 | 838.7698512263196 | 778.4117229743016 | 838.7698512263196 | 838.7698512263196 | 890.5474612520641 | 838.7698512263196 | 838.7698512263196 | 664.6331823613021 | 778.4117229743016 | 838.7698512263196
 | 7 | 1925.80828817942 | 1851.571080663262 | 1733.259829502671 | 0 | 1851.571080663262 | 2006.032991900701 | 1005.275032611197 | 1005.275032611197 | 1101.015511907501 | 920.6348987405505 | 1101.015511907501 | 920.6348987405505 | 834.6072216916976 | 920.6348987405505 | 920.6348987405505 | 1005.275032611197 | 920.6348987405505 | 920.6348987405505 | 699.3217618164848 | 834.6072216916976 | 920.6348987405505
 | 8 | 1925.80828817942 | 2097.622160035417 | 1963.588795176924 | 0 | 2097.622160035417 | 2272.610164156227 | 1077.20602464 | 1077.20602464 | 1181.727500169047 | 988.1237509290013 | 1181.727500169047 | 988.1237509290013 | 895.7896551375954 | 988.1237509290013 | 988.1237509290013 | 1077.20602464 | 988.1237509290013 | 988.1237509290013 | 750.5868432075613 | 895.7896551375954 | 988.1237509290013
 | 9 | 2088.632945404027 | 2256.848460942096 | 2129.607746526964 | 0 | 2256.848460942096 | 2402.840438534196 | 1207.789543335976 | 1207.789543335976 | 1391.71310511402 | 1122.901745592264 | 1391.71310511402 | 1122.901745592264 | 1029.823019996089 | 1122.901745592264 | 1122.901745592264 | 1207.789543335976 | 1122.901745592264 | 1122.901745592264 | 845.8994582180451 | 1029.823019996089 | 1122.901745592264
 | 10 | 2088.632945404027 | 2256.848460942096 | 2129.607746526964 | 0 | 2256.848460942096 | 2402.840438534196 | 1206.16730928 | 1206.16730928 | 1391.71310511402 | 1122.901745592264 | 1391.71310511402 | 1122.901745592264 | 1029.823019996089 | 1122.901745592264 | 1122.901745592264 | 1206.16730928 | 1122.901745592264 | 1122.901745592264 | 845.8994582180451 | 1029.823019996089 | 1122.901745592264
 | 11 | 2268.596916171543 | 2401.501062592984 | 2313.102250472997 | 0 | 2401.501062592984 | 2593.031822186289 | 1458.580399979788 | 1458.580399979788 | 1620.644888866431 | 1355.448452506469 | 1620.644888866431 | 1355.448452506469 | 1222.850234326489 | 1355.448452506469 | 1355.448452506469 | 1458.580399979788 | 1355.448452506469 | 1355.448452506469 | 1074.202539333171 | 1222.850234326489 | 1355.448452506469
 | 12 | 2474.832999459866 | 2619.819341010529 | 2523.38427324327 | 0 | 2619.819341010529 | 2828.761987839589 | 1591.178618159769 | 1591.178618159769 | 1767.976242399743 | 1478.671039097967 | 1767.97624239974 | 1478.671039097967 | 1334.018437447079 | 1478.671039097967 | 1478.671039097967 | 1591.178618159769 | 1478.671039097967 | 1478.671039097967 | 1175.995110865277 | 1334.018437447079 | 1478.671039097967
 | 13 | 2681.069082748188 | 2838.137619428072 | 2733.666296013542 | 0 | 2838.137619428072 | 3064.492153492888 | 1723.776836339749 | 1723.776836339749 | 1915.307595933055 | 1601.893625689464 | 1915.307595933055 | 1601.893625689464 | 1445.186640567669 | 1601.893625689464 | 1601.893625689464 | 1723.776836339749 | 1601.893625689464 | 1601.893625689464 | 1277.787682397384 | 1445.186640567669 | 1601.893625689464
 | 14 | 2887.30516603651 | 3056.455897845617 | 2943.948318783815 | 0 | 3056.455897845617 | 3300.222319146187 | 1856.37505451973 | 1856.37505451973 | 2062.638949466366 | 1725.116212280961 | 2062.638949466366 | 1725.116212280961 | 1556.354843688258 | 1725.116212280961 | 1725.116212280961 | 1856.37505451973 | 1725.116212280961 | 1725.116212280961 | 1379.58025392949 | 1556.354843688258 | 1725.116212280961
 | 15 | 3093.541249324833 | 3274.77417626316 | 3154.230341554087 | 0 | 3274.77417626316 | 3535.952484799486 | 1988.973272699711 | 1988.973272699711 | 2209.970302999679 | 1848.338798872458 | 2209.970302999679 | 1848.338798872458 | 1667.523046808848 | 1848.338798872458 | 1848.338798872458 | 1988.973272699711 | 1848.338798872458 | 1848.338798872458 | 1481.372825461596 | 1667.523046808848 | 1848.338798872458
 | 16 | 3299.777332613155 | 3493.092454680705 | 3364.51236432436 | 0 | 3493.092454680705 | 3771.682650452785 | 2121.571490879692 | 2121.571490879692 | 2357.30165653299 | 1971.561385463956 | 2357.30165653299 | 1971.561385463956 | 1778.691249929438 | 1971.561385463956 | 1971.561385463956 | 2121.571490879692 | 1971.561385463956 | 1971.561385463956 | 1583.165396993703 | 1778.691249929438 | 1971.561385463956
 | 18 | 3712.249499189799 | 3929.729011515792 | 3785.076409864905 | 0 | 3929.729011515792 | 4243.142981759383 | 2386.767927239653 | 2386.767927239653 | 2651.964363599614 | 2218.00655864695 | 2651.964363599614 | 2218.00655864695 | 2001.027656170618 | 2218.00655864695 | 2218.00655864695 | 2386.767927239653 | 2218.00655864695 | 2218.00655864695 | 1751.926765586406 | 2001.027656170618 | 2218.00655864695
 | 20 | 4124.721665766443 | 4366.36556835088 | 4205.64045540545 | 0 | 4366.36556835088 | 4714.603313065981 | 2651.964363599614 | 2591.276700239617 | 2946.627070666238 | 2464.451731829945 | 2825.251743946241 | 2357.301656532991 | 2121.571490879692 | 2358.248320949945 | 2358.248320949945 | 2591.276700239617 | 2358.248320949945 | 2358.248320949945 | 1785.514819282131 | 2121.571490879692 | 2358.248320949945
 | 22 | 4017.006004431141 | 4390.474335292694 | 4095.811628226072 | 0 | 4390.474335292694 | 4714.603313065982 | 2593.031822186289 | 2653.719485546291 | 2828.761987839589 | 2357.301656532991 | 2950.137314559589 | 2463.505067412993 | 2227.774901759695 | 2464.451731829945 | 2464.451731829945 | 2653.719485546291 | 2464.451731829945 | 2464.451731829945 | 1915.33063041426 | 2227.774901759695 | 2464.451731829945
 | 24 | 4382.188368470336 | 4789.60836577385 | 4468.158139882988 | 0 | 4789.60836577385 | 5143.203614253798 | 2828.761987839589 | 2828.761987839589 | 3085.922168552279 | 2571.601807126899 | 3085.922168552279 | 2571.601807126899 | 2314.44162641421 | 2571.601807126899 | 2571.601807126899 | 2828.761987839589 | 2571.601807126899 | 2571.601807126899 | 1991.19020961426 | 2314.44162641421 | 2571.601807126899
 | 26 | 4747.370732509531 | 5188.742396255004 | 4840.504651539903 | 0 | 5188.742396255004 | 5571.803915441615 | 3064.492153492888 | 3064.492153492888 | 3343.082349264968 | 2785.901957720807 | 3343.082349264968 | 2785.901957720807 | 2507.311761948727 | 2785.901957720807 | 2785.901957720807 | 3064.492153492888 | 2785.901957720807 | 2785.901957720807 | 2078.734495242115 | 2507.311761948727 | 2785.901957720807
 | 28 | 5112.553096548725 | 5587.876426736158 | 5212.851163196819 | 0 | 5587.876426736158 | 6000.404216629431 | 3300.222319146187 | 3300.222319146187 | 3600.242529977658 | 3000.202108314716 | 3600.242529977658 | 3000.202108314716 | 2700.181897483244 | 3000.202108314716 | 3000.202108314716 | 3300.222319146187 | 3000.202108314716 | 3000.202108314716 | 2242.138360069971 | 2700.181897483244 | 3000.202108314716
 | 30 | 5477.73546058792 | 5987.010457217311 | 5585.197674853734 | 0 | 5987.010457217311 | 6429.004517817247 | 3535.952484799486 | 3535.952484799486 | 3857.402710690348 | 3214.502258908623 | 3857.402710690348 | 3214.502258908623 | 2893.052033017762 | 3214.502258908623 | 3214.502258908623 | 3535.952484799486 | 3214.502258908623 | 3214.502258908623 | 2405.542224897825 | 2893.052033017762 | 3214.502258908623
 | 32 | 5842.917824627115 | 6386.144487698466 | 5957.54418651065 | 0 | 6386.144487698466 | 6857.604819005064 | 3771.682650452785 | 3771.682650452785 | 4114.562891403039 | 3428.802409502532 | 4114.562891403039 | 3428.802409502532 | 3085.922168552279 | 3428.802409502532 | 3428.802409502532 | 3771.682650452785 | 3428.802409502532 | 3428.802409502532 | 2470.328636765678 | 3085.922168552279 | 3428.802409502532
 | 34 | 5842.917824627115 | 6386.144487698466 | 5957.54418651065 | 0 | 6386.144487698466 | 6857.604819005064 | 3771.682650452785 | 3771.682650452785 | 4114.562891403039 | 3428.802409502532 | 4114.562891403039 | 3428.802409502532 | 3085.922168552279 | 3428.802409502532 | 3428.802409502532 | 3771.682650452785 | 3428.802409502532 | 3428.802409502532 | 2509.865677495134 | 3085.922168552279 | 3428.802409502532
 | 36 | 6154.894259701692 | 6626.980406065213 | 6275.64097528852 | 0 | 6626.980406065213 | 7139.822681764052 | 3883.3912108461 | 3883.3912108461 | 4256.451288522288 | 3502.745175249912 | 4256.451288522288 | 3502.745175249912 | 3127.616031476397 | 3502.745175249912 | 3502.745175249912 | 3883.3912108461 | 3502.745175249912 | 3502.745175249912 | 2509.865677495134 | 3113.961307220397 | 3502.745175249912
 | 39 | 6466.870694776269 | 6867.81632443196 | 6593.73776406639 | 0 | 6867.81632443196 | 7422.040544523039 | 3995.099771239415 | 3995.099771239415 | 4398.339685641539 | 3576.687940997292 | 4398.339685641539 | 3576.687940997292 | 3169.309894400514 | 3576.687940997292 | 3576.687940997292 | 3995.099771239415 | 3576.687940997292 | 3576.687940997292 | 2546.63851369295 | 3142.000445888513 | 3576.687940997292
 | 42 | 6778.847129850848 | 7108.652242798707 | 6911.834552844261 | 0 | 7108.652242798707 | 7704.258407282027 | 4106.80833163273 | 4106.80833163273 | 4540.228082760789 | 3650.630706744672 | 4540.228082760789 | 3650.630706744672 | 3211.003757324631 | 3650.630706744672 | 3650.630706744672 | 4106.80833163273 | 3650.630706744672 | 3650.630706744672 | 2546.63851369295 | 3170.039584556631 | 3650.630706744672
 | 45 | 7090.823564925425 | 7349.488161165454 | 7229.931341622132 | 0 | 7349.488161165454 | 7986.476270041014 | 4218.516892026046 | 4218.516892026046 | 4682.11647988004 | 3724.573472492052 | 4682.11647988004 | 3724.573472492052 | 3252.697620248749 | 3724.573472492052 | 3724.573472492052 | 4218.516892026046 | 3724.573472492052 | 3724.573472492052 | 2546.63851369295 | 3198.078723224748 | 3724.573472492052
 | 48 | 7402.800000000002 | 7590.324079532201 | 7548.028130400003 | 0 | 7590.324079532201 | 8268.694132800001 | 4330.225452419361 | 4330.225452419361 | 4824.00487699929 | 3798.516238239432 | 4824.00487699929 | 3798.516238239432 | 3294.391483172865 | 3798.516238239432 | 3798.516238239432 | 4330.225452419361 | 3798.516238239432 | 3798.516238239432 | 2584.568303292951 | 3226.117861892865 | 3798.516238239432
 | 51 | 7402.8 | 7590.324079532199 | 7548.0281304 | 0 | 7590.324079532199 | 8268.694132800001 | 4330.225452419362 | 4330.225452419362 | 4824.00487699929 | 3798.516238239433 | 4824.00487699929 | 3798.516238239433 | 3294.391483172865 | 3798.516238239433 | 3798.516238239433 | 4330.225452419362 | 3798.516238239433 | 3798.516238239433 | 2584.568303292951 | 3226.117861892866 | 3798.516238239433
 | 55 | 7484.64 | 7749.629195852207 | 7631.47366752 | 0 | 7749.629195852207 | 8519.03074416 | 4375.741199939365 | 4375.741199939365 | 4861.934666599293 | 3889.547733279436 | 4861.934666599293 | 3889.547733279436 | 3294.391483172865 | 3889.547733279436 | 3889.547733279436 | 4375.741199939365 | 3889.547733279436 | 3889.547733279436 | 2622.498092892953 | 3226.117861892866 | 3889.547733279436
 | 60 | 7484.64 | 7749.629195852207 | 7631.47366752 | 0 | 7749.629195852207 | 8519.03074416 | 4375.741199939365 | 4375.741199939365 | 4861.934666599293 | 3889.547733279436 | 4861.934666599293 | 3889.547733279436 | 3294.391483172865 | 3889.547733279436 | 3889.547733279436 | 4375.741199939365 | 3889.547733279436 | 3889.547733279436 | 2622.498092892953 | 3241.289777732862 | 3889.547733279436
 | 66 | 7484.64 | 7749.629195852207 | 7631.47366752 | 0 | 7749.629195852207 | 8519.03074416 | 4375.741199939365 | 4375.741199939365 | 4861.934666599293 | 3889.547733279436 | 4861.934666599293 | 3889.547733279436 | 3294.391483172865 | 3889.547733279436 | 3889.547733279436 | 4375.741199939365 | 3889.547733279436 | 3889.547733279436 | 2622.498092892953 | 3241.289777732862 | 3889.547733279436
 | 72 | 7484.64 | 7749.629195852207 | 7631.47366752 | 0 | 7749.629195852207 | 8519.03074416 | 4375.741199939365 | 4375.741199939365 | 4861.934666599293 | 3889.547733279436 | 4861.934666599293 | 3889.547733279436 | 3294.391483172865 | 3889.547733279436 | 3889.547733279436 | 4375.741199939365 | 3889.547733279436 | 3889.547733279436 | 2622.498092892953 | 3241.289777732862 | 3889.547733279436
 | Tidslevering
 | 07-10 | 510 | 635 | 635 | 930 | 635 | 635 | 635 | 635 | 635 | 510 | 635 | 510 | 510 | 635 | 635 | 635 | 510 | 510 | 510 | 510 | 510
 | 09-15 | 510 | 635 | 635 | 930 | 635 | 635 | 635 | 635 | 635 | 510 | 635 | 510 | 510 | 635 | 635 | 635 | 510 | 510 | 510 | 510 | 510
 | 06-17 | 930 | 1015 | 1015 | 1270 | 1015 | 1015 | 1015 | 1015 | 1015 | 930 | 1015 | 930 | 930 | 1015 | 1015 | 1015 | 930 | 930 | 930 | 930 | 930