Spreadsheet: 117824d1313057548-excel-2007-working-with-two-sheets-of-data-need-help-exercise
Sheet: Pick-up Tariffs SLO

2008-01-01 00:00:00 |  | [NAME] (in EUR) - Gewichtsstaffelung
Input | 25 | 50 | 100 | 150 | 200 | 250 | 300 | 350 | 400 | 450 | 500 | 600 | 700 | 800 | 900 | 1000 | 1200 | 1400 | 1600 | 1800 | 2000 | 2200 | 2400 | 2600 | 2800 | 3000
 | 1 | 26 | 51 | 101 | 151 | 201 | 251 | 301 | 351 | 401 | 451 | 501 | 601 | 701 | 801 | 901 | 1001 | 1201 | 1401 | 1601 | 1801 | 2001 | 2201 | 2401 | 2601 | 2801
1 | 4 | 6 | 9 | 15 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 29 | 30 | 33 | 35 | 38 | 40 | 43 | 45 | 48 | 50 | 53 | 55
2 | 4 | 6 | 10 | 17 | 21 | 23 | 26 | 27 | 29 | 30 | 31 | 33 | 35 | 38 | 41 | 44 | 47 | 50 | 54 | 57 | 60 | 64 | 68 | 71 | 75 | 79
3 | 4 | 6 | 11 | 19 | 23 | 27 | 32 | 34 | 37 | 39 | 42 | 44 | 47 | 49 | 53 | 57 | 61 | 66 | 70 | 75 | 80 | 84 | 89 | 93 | 98 | 102
Output | 25 | 50 | 100 | 150 | 200 | 250 | 300 | 350 | 400 | 450 | 500 | 600 | 700 | 800 | 900 | 1000 | 1200 | 1400 | 1600 | 1800 | 2000 | 2200 | 2400 | 2600 | 2800 | 3000
 | 1 | 26 | 51 | 101 | 151 | 201 | 251 | 301 | 351 | 401 | 451 | 501 | 601 | 701 | 801 | 901 | 1001 | 1201 | 1401 | 1601 | 1801 | 2001 | 2201 | 2401 | 2601 | 2801
1 | 10 | 10 | 12 | 17 | 22 | 27 | 30 | 33 | 36 | 39 | 42 | 45 | 48 | 51 | 54 | 57 | 60 | 63 | 68 | 70 | 73 | 77 | 82 | 85 | 90 | 94
2 | 12 | 12 | 14 | 22 | 25 | 32 | 38 | 41 | 44 | 47 | 50 | 54 | 58 | 62 | 66 | 70 | 76 | 82 | 88 | 94 | 100 | 102 | 104 | 106 | 108 | 110
3 | 14 | 14 | 17 | 26 | 30 | 35 | 38 | 42 | 46 | 49 | 52 | 58 | 64 | 70 | 75 | 80 | 86 | 92 | 98 | 104 | 110 | 114 | 118 | 122 | 126 | 130
 | 1 m³ = 200 kg
 | 1 ldm = 1000 kg
PLZ | Zone
0 | 3
1000 | 1
1001 | 1
1101 | 1
1102 | 1
1103 | 1
1104 | 1
1105 | 1
1106 | 1 |  | If the ZIP codes are not it Excel table on the left the ZONE is 3.
1107 | 1
1108 | 1
1109 | 1
1110 | 1
1111 | 1
1112 | 1
1113 | 1
1114 | 1
1115 | 1
1116 | 1
1117 | 1
1118 | 1
1119 | 1
1120 | 1
1122 | 1
1129 | 1
1210 | 1
1211 | 1
1215 | 1
1216 | 1
1217 | 1
1218 | 2
1219 | 2
1221 | 2
1222 | 2
1223 | 2
1224 | 2
1225 | 2
1230 | 1
1231 | 1
1232 | 1
1233 | 1
1234 | 1
1235 | 1
1236 | 1
1240 | 2
1241 | 2
1242 | 2
1251 | 2
1252 | 2
1260 | 1
1261 | 1
1262 | 1
1270 | 2
1272 | 2
1273 | 2
1274 | 2
1275 | 2
1276 | 2
1277 | 2
1281 | 2
1282 | 2
1290 | 1
1291 | 1
1292 | 1
1293 | 1
1294 | 2
1295 | 2
1296 | 2
1301 | 2
1302 | 2
1303 | 2
1310 | 2
1311 | 2
1312 | 2
1313 | 2
1314 | 2
1315 | 2
1316 | 2
1317 | 2
1318 | 2
1319 | 2
1330 | 2
1331 | 2
1332 | 2
1333 | 2
1334 | 2
1335 | 2
1336 | 2
1337 | 2
1338 | 2
1351 | 1
1352 | 2
1353 | 2
1354 | 2
1355 | 2
1356 | 1
1357 | 1
1360 | 2
1370 | 2
1371 | 2
1372 | 2
1373 | 2
1380 | 2
1381 | 2
1382 | 2
1383 | 2
1384 | 2
1385 | 2
1386 | 2
1410 | 2
1411 | 2
1412 | 2
1413 | 2
1414 | 2
1420 | 2
1422 | 2
1423 | 2
1430 | 2
1431 | 2
1432 | 2
1433 | 2
1434 | 2
1500 | 1
1501 | 1
1502 | 1
1503 | 1
1504 | 1
1505 | 1
1506 | 1
1507 | 1
1509 | 1
1510 | 1
1511 | 1
1512 | 1
1513 | 1
1514 | 1
1516 | 1
1517 | 1
1518 | 1
1519 | 1
1520 | 1
1521 | 1
1522 | 1
1523 | 1
1524 | 1
1525 | 1
1526 | 1
1527 | 1
1528 | 1
1529 | 1
1532 | 1
1533 | 1
1534 | 1
1535 | 1
1536 | 1
1537 | 1
1538 | 1
1540 | 1
1542 | 1
1543 | 1
1544 | 1
1545 | 1
1546 | 1
1547 | 1
1550 | 1
1600 | 1
1606 | 1
4210 | 2
5275 | 2
5280 | 2
5281 | 2
5282 | 2
6232 | 2