Spreadsheet: 77889d1278394977-excel-2007-running-totals-example
Sheet: Sheet1

Job No | Mov No | Type | Date | Week No | Year | Storage | Product Code | Depot | Qty In | Qty Out | Running Total | Pallet Ratio | Pallets Actual | Pallets Roundup
1105242 | 1322132 | IN | 2009-12-15 00:00:00 |  |  |  | 1213 | [NAME] | 372 | 0 |  | 12
1105242 | 1322143 | IN | 2009-12-15 00:00:00 |  |  |  | 1213 | [NAME] | 4 | 0 |  | 12
1110458 | 1334697 | OUT | 2010-01-12 00:00:00 |  |  |  | 1213 | [NAME] | 0 | 8 |  | 12
1110464 | 1334880 | OUT | 2010-01-12 00:00:00 |  |  |  | 1213 | [NAME] | 0 | 8 |  | 12
1110469 | 1335038 | OUT | 2010-01-12 00:00:00 |  |  |  | 1213 | [NAME] | 0 | 8 |  | 12
1110484 | 1335218 | OUT | 2010-01-12 00:00:00 |  |  |  | 1213 | [NAME] | 0 | 8 |  | 12
1110490 | 1335323 | OUT | 2010-01-13 00:00:00 |  |  |  | 1213 | [NAME] | 0 | 8 |  | 12
1110493 | 1335388 | OUT | 2010-01-13 00:00:00 |  |  |  | 1213 | [NAME] | 0 | 8 |  | 12
1110522 | 1335720 | OUT | 2010-01-13 00:00:00 |  |  |  | 1213 | [NAME] | 0 | 8 |  | 12
1112641 | 1337751 | OUT | 2010-01-15 00:00:00 |  |  |  | 1213 | [NAME] | 0 | 8 |  | 12
1117735 | 1344878 | OUT | 2010-01-27 00:00:00 |  |  |  | 1213 | [NAME] | 0 | 8 |  | 12
1117735 | 1344910 | OUT | 2010-01-27 00:00:00 |  |  |  | 1213 | [NAME] | 0 | 8 |  | 12
1120427 | 1348471 | OUT | 2010-02-01 00:00:00 |  |  |  | 1213 | [NAME] | 0 | 8 |  | 12
1120442 | 1348643 | OUT | 2010-02-02 00:00:00 |  |  |  | 1213 | [NAME] | 0 | 8 |  | 12
1120445 | 1348886 | OUT | 2010-02-02 00:00:00 |  |  |  | 1213 | [NAME] | 0 | 8 |  | 12
1120450 | 1348924 | OUT | 2010-02-02 00:00:00 |  |  |  | 1213 | [NAME] | 0 | 8 |  | 12
1120460 | 1349273 | OUT | 2010-02-02 00:00:00 |  |  |  | 1213 | [NAME] | 0 | 8 |  | 12
1120460 | 1349287 | OUT | 2010-02-02 00:00:00 |  |  |  | 1213 | [NAME] | 0 | 8 |  | 12
1120472 | 1349447 | OUT | 2010-02-03 00:00:00 |  |  |  | 1213 | [NAME] | 0 | 8 |  | 12
1120472 | 1349459 | OUT | 2010-02-03 00:00:00 |  |  |  | 1213 | [NAME] | 0 | 8 |  | 12
1120478 | 1349481 | OUT | 2010-02-03 00:00:00 |  |  |  | 1213 | [NAME] | 0 | 8 |  | 12
1120478 | 1349580 | OUT | 2010-02-03 00:00:00 |  |  |  | 1213 | [NAME] | 0 | 8 |  | 12
1120484 | 1349630 | OUT | 2010-02-03 00:00:00 |  |  |  | 1213 | [NAME] | 0 | 8 |  | 12
1123545 | 1353213 | OUT | 2010-02-08 00:00:00 |  |  |  | 1213 | [NAME] | 0 | 8 |  | 12
1123546 | 1353222 | OUT | 2010-02-08 00:00:00 |  |  |  | 1213 | [NAME] | 0 | 8 |  | 12
1123552 | 1353287 | OUT | 2010-02-08 00:00:00 |  |  |  | 1213 | [NAME] | 0 | 8 |  | 12
1123576 | 1353781 | OUT | 2010-02-09 00:00:00 |  |  |  | 1213 | [NAME] | 0 | 2 |  | 12
1123582 | 1353934 | OUT | 2010-02-10 00:00:00 |  |  |  | 1213 | [NAME] | 0 | 4 |  | 12
1126639 | 1358760 | OUT | 2010-02-15 00:00:00 |  |  |  | 1213 | [NAME] | 0 | 8 |  | 12
1126648 | 1358798 | OUT | 2010-02-15 00:00:00 |  |  |  | 1213 | [NAME] | 0 | 8 |  | 12
1126650 | 1358813 | OUT | 2010-02-15 00:00:00 |  |  |  | 1213 | [NAME] | 0 | 8 |  | 12
1126660 | 1358965 | OUT | 2010-02-16 00:00:00 |  |  |  | 1213 | [NAME] | 0 | 8 |  | 12
1126664 | 1359289 | OUT | 2010-02-16 00:00:00 |  |  |  | 1213 | [NAME] | 0 | 8 |  | 12
1126849 | 1360032 | OUT | 2010-02-17 00:00:00 |  |  |  | 1213 | [NAME] | 0 | 8 |  | 12
1126849 | 1360038 | OUT | 2010-02-17 00:00:00 |  |  |  | 1213 | [NAME] | 0 | 16 |  | 12
1126849 | 1360048 | OUT | 2010-02-17 00:00:00 |  |  |  | 1213 | [NAME] | 0 | 8 |  | 12
1127271 | 1360920 | OUT | 2010-02-17 00:00:00 |  |  |  | 1213 | [NAME] | 0 | 8 |  | 12
1132910 | 1370547 | OUT | 2010-03-03 00:00:00 |  |  |  | 1213 | [NAME] | 0 | 6 |  | 12
1132936 | 1369938 | OUT | 2010-03-03 00:00:00 |  |  |  | 1213 | [NAME] | 0 | 8 |  | 12
1140314 | 1378891 | OUT | 2010-03-17 00:00:00 |  |  |  | 1213 | [NAME] | 0 | 6 |  | 12
1142842 | 1380896 | OUT | 2010-03-23 00:00:00 |  |  |  | 1213 | [NAME] | 0 | 8 |  | 12
1142884 | 1381689 | OUT | 2010-03-24 00:00:00 |  |  |  | 1213 | [NAME] | 0 | 8 |  | 12
1144200 | 1382728 | IN | 2010-03-24 00:00:00 |  |  |  | 1213 | [NAME] | 6 | 0 |  | 12
1144789 | 1383007 | OUT | 2010-03-25 00:00:00 |  |  |  | 1213 | [NAME] | 0 | 8 |  | 12
1151958 | 1391380 | OUT | 2010-04-12 00:00:00 |  |  |  | 1213 | [NAME] | 0 | 8 |  | 12
1151967 | 1391502 | OUT | 2010-04-13 00:00:00 |  |  |  | 1213 | [NAME] | 0 | 8 |  | 12
1155365 | 1395375 | OUT | 2010-04-19 00:00:00 |  |  |  | 1213 | [NAME] | 0 | 8 |  | 12
1155408 | 1395807 | OUT | 2010-04-20 00:00:00 |  |  |  | 1213 | [NAME] | 0 | 8 |  | 12
1155408 | 1395819 | OUT | 2010-04-20 00:00:00 |  |  |  | 1213 | [NAME] | 0 | 8 |  | 12
1155429 | 1395872 | OUT | 2010-04-20 00:00:00 |  |  |  | 1213 | [NAME] | 0 | 8 |  | 12
1156063 | 1396918 | OUT | 2010-04-20 00:00:00 |  |  |  | 1213 | [NAME] | 0 | 8 |  | 12
1164312 | 1405322 | IN | 2010-05-06 00:00:00 |  |  |  | 239525 | [NAME] | 1 | 0 | 1 | 48
0 | 1334329 | IN | 2010-01-01 00:00:00 |  |  |  | 2245A | [NAME] | 6 | 0 |  | 6
0 | 1334331 | IN | 2010-01-01 00:00:00 |  |  |  | 2245A | [NAME] | 5 | 0 |  | 6
0 | 1348509 | IN | 2010-01-01 00:00:00 |  |  |  | 2245A | [NAME] | 36 | 0 |  | 6
1110458 | 1334700 | OUT | 2010-01-12 00:00:00 |  |  |  | 2245A | [NAME] | 0 | 1 |  | 6
1110464 | 1334886 | OUT | 2010-01-12 00:00:00 |  |  |  | 2245A | [NAME] | 0 | 1 |  | 6
1110469 | 1335042 | OUT | 2010-01-12 00:00:00 |  |  |  | 2245A | [NAME] | 0 | 1 |  | 6
1110484 | 1335224 | OUT | 2010-01-12 00:00:00 |  |  |  | 2245A | [NAME] | 0 | 1 |  | 6
1110490 | 1335328 | OUT | 2010-01-13 00:00:00 |  |  |  | 2245A | [NAME] | 0 | 1 |  | 6
1110493 | 1335394 | OUT | 2010-01-13 00:00:00 |  |  |  | 2245A | [NAME] | 0 | 1 |  | 6
1110522 | 1335723 | OUT | 2010-01-13 00:00:00 |  |  |  | 2245A | [NAME] | 0 | 1 |  | 6
1112641 | 1337755 | OUT | 2010-01-15 00:00:00 |  |  |  | 2245A | [NAME] | 0 | 1 |  | 6
1117735 | 1344886 | OUT | 2010-01-27 00:00:00 |  |  |  | 2245A | [NAME] | 0 | 1 |  | 6
1117735 | 1344912 | OUT | 2010-01-27 00:00:00 |  |  |  | 2245A | [NAME] | 0 | 1 |  | 6
1117735 | 1344926 | OUT | 2010-01-27 00:00:00 |  |  |  | 2245A | [NAME] | 0 | 1 |  | 6
1120427 | 1348525 | OUT | 2010-02-01 00:00:00 |  |  |  | 2245A | [NAME] | 0 | 1 |  | 6
1120442 | 1348645 | OUT | 2010-02-02 00:00:00 |  |  |  | 2245A | [NAME] | 0 | 1 |  | 6
1120445 | 1348889 | OUT | 2010-02-02 00:00:00 |  |  |  | 2245A | [NAME] | 0 | 1 |  | 6
1120450 | 1348928 | OUT | 2010-02-02 00:00:00 |  |  |  | 2245A | [NAME] | 0 | 1 |  | 6
1120472 | 1349449 | OUT | 2010-02-03 00:00:00 |  |  |  | 2245A | [NAME] | 0 | 1 |  | 6
1120472 | 1349461 | OUT | 2010-02-03 00:00:00 |  |  |  | 2245A | [NAME] | 0 | 1 |  | 6
1120478 | 1349483 | OUT | 2010-02-03 00:00:00 |  |  |  | 2245A | [NAME] | 0 | 1 |  | 6
1120478 | 1349582 | OUT | 2010-02-03 00:00:00 |  |  |  | 2245A | [NAME] | 0 | 1 |  | 6
1120484 | 1349632 | OUT | 2010-02-03 00:00:00 |  |  |  | 2245A | [NAME] | 0 | 1 |  | 6
1123545 | 1353215 | OUT | 2010-02-08 00:00:00 |  |  |  | 2245A | [NAME] | 0 | 1 |  | 6
1123546 | 1353226 | OUT | 2010-02-08 00:00:00 |  |  |  | 2245A | [NAME] | 0 | 1 |  | 6
1123552 | 1353289 | OUT | 2010-02-08 00:00:00 |  |  |  | 2245A | [NAME] | 0 | 1 |  | 6
1126639 | 1358762 | OUT | 2010-02-15 00:00:00 |  |  |  | 2245A | [NAME] | 0 | 1 |  | 6
1126648 | 1358802 | OUT | 2010-02-15 00:00:00 |  |  |  | 2245A | [NAME] | 0 | 1 |  | 6
1126650 | 1358814 | OUT | 2010-02-15 00:00:00 |  |  |  | 2245A | [NAME] | 0 | 1 |  | 6
1126660 | 1358966 | OUT | 2010-02-16 00:00:00 |  |  |  | 2245A | [NAME] | 0 | 1 |  | 6
1126664 | 1359290 | OUT | 2010-02-16 00:00:00 |  |  |  | 2245A | [NAME] | 0 | 1 |  | 6
1126849 | 1360033 | OUT | 2010-02-17 00:00:00 |  |  |  | 2245A | [NAME] | 0 | 1 |  | 6
1126849 | 1360039 | OUT | 2010-02-17 00:00:00 |  |  |  | 2245A | [NAME] | 0 | 2 |  | 6
1126849 | 1360049 | OUT | 2010-02-17 00:00:00 |  |  |  | 2245A | [NAME] | 0 | 1 |  | 6
1127271 | 1360922 | OUT | 2010-02-17 00:00:00 |  |  |  | 2245A | [NAME] | 0 | 1 |  | 6
1132936 | 1369941 | OUT | 2010-03-03 00:00:00 |  |  |  | 2245A | [NAME] | 0 | 1 |  | 6
1136354 | 1374806 | OUT | 2010-03-11 00:00:00 |  |  |  | 2245A | [NAME] | 0 | 1 |  | 6
1142842 | 1380898 | OUT | 2010-03-23 00:00:00 |  |  |  | 2245A | [NAME] | 0 | 1 |  | 6
1142884 | 1381691 | OUT | 2010-03-24 00:00:00 |  |  |  | 2245A | [NAME] | 0 | 1 |  | 6
1144789 | 1383009 | OUT | 2010-03-25 00:00:00 |  |  |  | 2245A | [NAME] | 0 | 1 |  | 6
1151958 | 1391381 | OUT | 2010-04-12 00:00:00 |  |  |  | 2245A | [NAME] | 0 | 1 |  | 6
1151967 | 1391511 | OUT | 2010-04-13 00:00:00 |  |  |  | 2245A | [NAME] | 0 | 1 |  | 6
1155365 | 1395376 | OUT | 2010-04-19 00:00:00 |  |  |  | 2245A | [NAME] | 0 | 1 |  | 6
1155408 | 1395811 | OUT | 2010-04-20 00:00:00 |  |  |  | 2245A | [NAME] | 0 | 1 |  | 6
1155408 | 1395823 | OUT | 2010-04-20 00:00:00 |  |  |  | 2245A | [NAME] | 0 | 1 |  | 6
1155429 | 1395874 | OUT | 2010-04-20 00:00:00 |  |  |  | 2245A | [NAME] | 0 | 1 |  | 6
1156063 | 1396920 | OUT | 2010-04-20 00:00:00 |  |  |  | 2245A | [NAME] | 0 | 1 |  | 6
1158472 | 1399569 | OUT | 2010-04-29 00:00:00 |  |  |  | 2245A | [NAME] | 0 | 1 |  | 6
1158472 | 1399577 | OUT | 2010-04-29 00:00:00 |  |  |  | 2245A | [NAME] | 0 | 1 |  | 6