Spreadsheet: 72870d1273587442-auto-population-of-summary-sheet-test-data
Sheet: LR_CNF

BRANCH: JOBURG
LOADING REPORT (LR) FOR THE M/O : |  |  |  |  |  | 2010-04-28 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Prov Rate
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
S.No. | INDENT NO. | SHIPPING LINE | SL CODE | LCR CODE | BOOKING REFERENCE NO | [NAME] | EMPTY IN YARD (DATE) | FULL IN YARD (DATE) | NO. OF DAYS CONT. UNDER LOADING | CONTAINER NO. | SEAL NO. | BLR / SOB / BLI / BLN / CRS / FCL | DATE - CONT BECOMES CRS | DESTINATION  / DISCHARGE PORT | SUPPLIER NAME | LOADING SITE / YARD | QUALITY | EVEREST QUALITY MANUAL  MATERIAL CODE | MATERIAL [NAME] | PAY LOAD (MT) | TARE WEIGHT (MT) | NET WEIGHT (MT) | PRICE / MT (LC) | MATERIAL VALUE (LC) | EXCH RATE | PRICE / MT (USD) | EMPTY CONTAINER TRNSPORT (PORT - YARD) (LC / CONT) | FORKLIFT CHARGES FOR EMPTY ON + OFF (LC / CONT) | CRANE CHARGES (LIFTING OF FULL CONT) (LC / CONT) | FULL CONTAINER TRNSPORT (YARD - PORT) (LC / CONT) | TRANSPORTER NAME | LOADING / STUFFING / LABOUR CHARGES (LC) | WEIGHMENT CHARGES (LC / CONT) | CUSTOM CLEARING CHARGES / TRANSITING CHARGES (LC / CONT) | CUSTOM CLEARING AGENT NAME | BANK CHARGES /  FORM EX / EXPORT LICENSE (LC / MT) | INSPECTION CHARGES (LC / CONT) | INSPECTION AGENCY NAME | COMMISSION TO AGENT | NAME OF THE AGENT | INCOME TAX / VAT (LC / MT) | CUTTING CHARGES (LC / MT) | BUNDLING CHARGES (LC / MT) | YARD EXPENSES (LC / MT) | GROUND LOSS (LC / MT) | STORAGE CHARGES (LC / CONT) | STORAGE DEPOT | CTO FEES (LC / CONT) | RUSID CHARGES (LC / CONT) | DOCUMENT-ATION (LC / CONT) & B/L FEES | LOCAL SHIPPING CHARGES / STAMP DUTY / THC / ANY OTHER LOCAL SHIPPING CHARGES (LC / CONT) | LIFT ON / LIFT OFF CHARGES (LC / CONT) | X-HAUL CHARGES (LC / CONT) | DEMMURRAGE / DETENTION (LC / CONT) | [NAME] CHARGES (LC / CONT) | CUSTOM DUTY | MISC. EXPENSES (LC / CONT) | TOTAL FOB COST (LC) | FOB VALUE (USD) | FOB (USD / MT) | OCEAN FREIGHT / CONT (USD) | SELLING & DIST EXPS (USD 10 / PMT) | PSIC (USD  / PMT) | CNF COST (USD / MT) | INSPECTED BY | PHOTOS (NOS AVAILABLE) | PHOTOS SENT TO HO ON (DATE) | ANY SPECIFIC REMARK | CONT. PICKING MONTH | CONT TYPE (20 FT / 40FT) | BL DETAILS
1 | 1 | PIL |  |  |  |  | 2010-04-02 00:00:00 | 2010-04-07 00:00:00 | 1 | TTNU 2447737 | MO 136067 | CRS |  | PENANG | FINE TRADING | VOORTRECKKER Road | HMSS | EMHM82 |  | 28.26 | 2.22 | 25.7 | 2260 |  | 7.2 |  | 0 | 0 | 0 | 1020 | FREIGHT DYNAMICS | 0 | 0 | 0 | ROLIGH | 0 | 0 | NA | 0 | NA | 0 | 0 | 0 | 0 | 0 | 300 | EDGIN | 55 |  | 150 | 2432 | 180 | 350 |  | 0 | 0 | 0 |  |  |  | 759 | 10 | 0 |  |  |  |  | RANDOM INSPECTION
2 | 2 | PIL |  |  |  |  | 2010-04-02 00:00:00 | 2010-04-07 00:00:00 | 1 | PCIU 2694359 | MO 136082 | CRS |  | PENANG | FINE TRADING | VOORTRECKKER Road | HMSS | EMHM82 |  | 28.28 | 2.22 | 20.28 | 2260 |  | 7.2 |  | 0 | 0 | 0 | 1020 | FREIGHT DYNAMICS | 0 | 0 | 0 | ROLIGH | 0 | 0 | NA | 0 | NA | 0 | 0 | 0 | 0 | 0 | 300 | EDGIN | 55 |  | 150 | 2432 | 180 | 350 |  | 0 | 0 | 0 |  |  |  | 759 | 10 | 0 |  |  |  |  | RANDOM INSPECTION
3 | 3 | PIL |  |  |  |  | 2010-04-02 00:00:00 | 2010-04-07 00:00:00 | 1 | PCIU 3750400 | MO 136079 | CRS |  | PENANG | FINE TRADING | VOORTRECKKER Road | HMSS | EMHM82 |  | 28.26 | 2.22 | 17.4 | 2260 |  | 7.2 |  | 0 | 0 | 0 | 1020 | FREIGHT DYNAMICS | 0 | 0 | 0 | ROLIGH | 0 | 0 | NA | 0 | NA | 0 | 0 | 0 | 0 | 0 | 300 | EDGIN | 55 |  | 150 | 2432 | 180 | 350 |  | 0 | 0 | 0 |  |  |  | 759 | 10 | 0 |  |  |  |  | RANDOM INSPECTION
4 | 4 | PIL |  |  |  |  | 2010-04-02 00:00:00 | 2010-04-08 00:00:00 | 14 | PCIU3832473 | MO136149 | CRS |  | PENANG | MARKO METALS | VOORTRECKKER Road | HMSS | EMHM82 |  | 28.26 | 2.22 | 18.54 | 2260 |  | 7.2 |  | 0 | 0 | 0 | 1020 | FREIGHT DYNAMICS | 0 | 0 | 0 | ROLIGH | 0 | 0 | NA | 0 | NA | 0 | 0 | 0 | 0 | 0 | 300 | EDGIN | 55 |  | 150 | 2432 | 180 | 350 |  | 0 | 0 | 0 |  |  |  | 759 | 10 | 0 |  |  |  |  | RANDOM INSPECTION
5 | 5 | PIL |  |  |  |  | 2010-04-02 00:00:00 | 2010-04-08 00:00:00 | 8 | PCIU3819445 | MO136145 | CRS |  | PENANG | FINE TRADING | VOORTRECKKER Road | HMSS | EMHM82 |  | 28.26 | 2.22 | 24.54 | 2260 |  | 7.2 |  | 0 | 0 | 0 | 1020 | FREIGHT DYNAMICS | 0 | 0 | 0 | ROLIGH | 0 | 0 | NA | 0 | NA | 0 | 0 | 0 | 0 | 0 | 300 | EDGIN | 55 |  | 150 | 2432 | 180 | 350 |  | 0 | 0 | 0 |  |  |  | 759 | 10 | 0 |  |  |  |  | RANDOM INSPECTION
6 | 6 | PIL |  |  |  |  | 2010-04-02 00:00:00 | 2010-04-08 00:00:00 | 11 | PCIU2059857 | MO136073 | CRS |  | PENANG | FINE TRADING | VOORTRECKKER Road | HMSS | EMHM82 |  | 28.26 | 2.22 | 17.96 | 2260 |  | 7.2 |  | 0 | 0 | 0 | 1020 | FREIGHT DYNAMICS | 0 | 0 | 0 | ROLIGH | 0 | 0 | NA | 0 | NA | 0 | 0 | 0 | 0 | 0 | 300 | EDGIN | 55 |  | 150 | 2432 | 180 | 350 |  | 0 | 0 | 0 |  |  |  | 759 | 10 | 0 |  |  |  |  | RANDOM INSPECTION
7 | 7 | PIL |  |  |  |  | 2010-04-05 00:00:00 | 2010-04-09 00:00:00 | 2 | PCIU2818969 | MO136113 | CRS |  | PENANG | FINE TRADING | VOORTRECKKER Road | HMSS | EMHM82 |  | 28.26 | 2.22 | 17.66 | 2260 |  | 7.2 |  | 0 | 0 | 0 | 1020 | FREIGHT DYNAMICS | 0 | 0 | 0 | ROLIGH | 0 | 0 | NA | 0 | NA | 0 | 0 | 0 | 0 | 0 | 0 | EDGIN | 55 |  | 150 | 2432 | 0 | 0 |  | 0 | 0 | 0 |  |  |  | 759 | 10 | 0
8 | 8 | PIL |  |  |  |  | 2010-04-05 00:00:00 | 2010-04-09 00:00:00 | 2 | CLHU3482274 | MO186674 | CRS |  | PENANG | FINE TRADING | VOORTRECKKER Road | HMSS | EMHM82 |  | 28.26 | 2.22 | 19.24 | 2260 |  | 7.2 |  | 0 | 0 | 0 | 1020 | FREIGHT DYNAMICS | 0 | 0 | 0 | ROLIGH | 0 | 0 | NA | 0 | NA | 0 | 0 | 0 | 0 | 0 | 0 | EDGIN | 55 |  | 150 | 2432 | 0 | 0 |  | 0 | 0 | 0 |  |  |  | 759 | 10 | 0
9 | 9 | PIL |  |  |  |  | 2010-04-09 00:00:00 | 2010-04-12 00:00:00 | 2 | PCIU 2564606 | MO186673 | CRS |  | PENANG | FINE TRADING | VOORTRECKKER Road | HMSS | EMHM82 |  | 28.26 | 2.22 | 19.66 | 2260 |  | 7.2 |  | 0 | 0 | 0 | 1020 | FREIGHT DYNAMICS | 0 | 0 | 0 | ROLIGH | 0 | 0 | NA | 0 | NA | 0 | 0 | 0 | 0 | 0 | 0 | EDGIN | 55 |  | 150 | 2432 | 0 | 0 |  | 0 | 0 | 0 |  |  |  | 759 | 10 | 0
10 | 10 | PIL |  |  |  |  | 2010-04-09 00:00:00 | 2010-04-12 00:00:00 | 1 | PCIU 3732047 | MO136013 | CRS |  | PENANG | FINE TRADING | VOORTRECKKER Road | HMSS | EMHM82 |  | 28.26 | 2.22 | 18.98 | 2260 |  | 7.2 |  | 0 | 0 | 0 | 1020 | FREIGHT DYNAMICS | 0 | 0 | 0 | ROLIGH | 0 | 0 | NA | 0 | NA | 0 | 0 | 0 | 0 | 0 | 0 | EDGIN | 55 |  | 150 | 2432 | 0 | 0 |  | 0 | 0 | 0 |  |  |  | 759 | 10 | 0 |  |  |  |  | RANDOM INSPECTION
11 | 11 | PIL |  |  |  |  | 2010-04-12 00:00:00 | 2010-04-14 00:00:00 | 2 | PCIU 2094966 | MO13133 | CRS |  | PENANG | MARKO METALS | Becon Vaille | HMSS | EMHM82 |  | 28.2 | 2.28 | 19.96 | 2500 |  | 7.2 |  | 0 | 0 | 0 | 1600 | O.Bee Logistics | 0 | 0 | 0 | EVE | 0 | 0 | NA | 0 | NA | 0 | 0 | 0 | 0 | 0 | 0 | EDGIN | 45 |  | 150 | 2432 | 0 | 0 |  | 0 | 0 | 0 |  |  |  | 759 | 10 | 0
12 | 12 | PIL |  |  |  |  | 2010-04-14 00:00:00 | 2010-04-19 00:00:00 |  | PCIU3192611 | M0131333 | CRS |  | PENANG | MARKO METALS | Becon Vaille | HMSS | EMHM82 |  | 28.2 | 2.28 | 19.44 | 2500 |  | 7.2 |  | 0 | 0 | 0 | 1600 | O.Bee Logistics | 0 | 0 | 0 | EVE | 0 | 0 | NA | 0 | NA | 0 | 0 | 0 | 0 | 0 | 0 | EDGIN | 45 |  | 150 |  | 0 | 0 |  | 0 | 0 | 0 |  |  |  | 759 | 10 | 0
13 | 13 | PIL |  |  |  |  | 2010-04-19 00:00:00 | 2010-04-21 00:00:00 |  | PCIU 2027464 | M0131392 | CRS |  | PENANG | MARKO METALS | Becon Vaille | HMSS | EMHM82 |  | 28.23 | 2.25 | 20.98 | 2500 |  | 7.2 |  | 0 | 0 | 0 | 1600 | O.Bee Logistics | 0 | 0 | 0 | EVE | 0 | 0 | NA | 0 | NA | 0 | 0 | 0 | 0 | 0 | 0 | EDGIN | 45 |  | 150 |  | 0 | 0 |  | 0 | 0 | 0 |  |  |  | 759 | 10 | 0
14 | 14 | PIL |  |  |  |  | 2010-04-19 00:00:00 | 2010-04-22 00:00:00 |  | PCIU 2615576 | 131461 | CRS |  | [NAME] | SCRAP FOR AFRICA | PHILLIPI | HMSS | EMHM82 |  | 28.23 | 2.25 | 22.04 | 2550 |  | 7.2 |  | 0 | 0 | 0 | 2200 | STELVALL | 0 | 0 | 0 | EVE | 0 | 0 | NA | 0 | NA | 0 | 0 | 0 | 0 | 0 | 0 | EDGIN | 45 |  | 150 |  | 0 | 0 |  | 0 | 0 | 0 |  |  |  | 759 | 10 | 0
15 | 15 | PIL |  |  |  |  | 2010-04-19 00:00:00 | 2010-04-22 00:00:00 |  | PCIU 3804390 | 131393 | CRS |  | [NAME] | SCRAP FOR AFRICA | PHILLIPI | HMSS | EMHM82 |  | 28.23 | 2.25 | 22 | 2550 |  | 7.2 |  | 0 | 0 | 0 | 2200 | STELVALL | 0 | 0 | 0 | EVE | 0 | 0 | NA | 0 | NA | 0 | 0 | 0 | 0 | 0 | 0 | EDGIN | 45 |  | 150 |  | 0 | 0 |  | 0 | 0 | 0 |  |  |  | 759 | 10 | 0
16 | 16 | PIL |  |  |  |  | 2010-04-19 00:00:00 | 2010-04-22 00:00:00 |  | PCIU 3181474 | 131399 | CRS |  | [NAME] | SCRAP FOR AFRICA | PHILLIPI | HMSS | EMHM82 |  | 28.23 | 2.25 | 22.43 | 2550 |  | 7.2 |  | 0 | 0 | 0 | 2200 | STELVALL | 0 | 0 | 0 | EVE | 0 | 0 | NA | 0 | NA | 0 | 0 | 0 | 0 | 0 | 0 | EDGIN | 45 |  | 150 |  | 0 | 0 |  | 0 | 0 | 0 |  |  |  | 759 | 10 | 0
17 | 17 | PIL |  |  |  |  | 2010-04-19 00:00:00 | 2010-04-22 00:00:00 |  | PCIU 3676998 | 131363 | CRS |  | [NAME] | SCRAP FOR AFRICA | PHILLIPI | HMSS | EMHM82 |  | 28.23 | 2.25 | 22.36 | 2550 |  | 7.2 |  | 0 | 0 | 0 | 2200 | STELVALL | 0 | 0 | 0 | EVE | 0 | 0 | NA | 0 | NA | 0 | 0 | 0 | 0 | 0 | 0 | EDGIN | 45 |  | 150 |  | 0 | 0 |  | 0 | 0 | 0 |  |  |  | 759 | 10 | 0
18 | 18 | PIL |  |  |  |  | 2010-04-19 00:00:00 | 2010-04-22 00:00:00 |  | PCIU 3898547 | 131369 | CRS |  | [NAME] | SCRAP FOR AFRICA | PHILLIPI | HMSS | EMHM82 |  | 28.23 | 2.25 | 21.7 | 2550 |  | 7.2 |  | 0 | 0 | 0 | 2200 | STELVALL | 0 | 0 | 0 | EVE | 0 | 0 | NA | 0 | NA | 0 | 0 | 0 | 0 | 0 | 0 | EDGIN | 45 |  | 150 |  | 0 | 0 |  | 0 | 0 | 0 |  |  |  | 759 | 10 | 0
19 | 19 | PIL |  |  |  |  | 2010-04-19 00:00:00 | 2010-04-22 00:00:00 |  | TRLU 9091591 | 131462 | CRS |  | [NAME] | SCRAP FOR AFRICA | PHILLIPI | HMSS | EMHM82 |  | 28.23 | 2.25 | 23.48 | 2550 |  | 7.2 |  | 0 | 0 | 0 | 2200 | STELVALL | 0 | 0 | 0 | EVE | 0 | 0 | NA | 0 | NA | 0 | 0 | 0 | 0 | 0 | 0 | EDGIN | 45 |  | 150 |  | 0 | 0 |  | 0 | 0 | 0 |  |  |  | 759 | 10 | 0
20 | 20 | PIL |  |  |  |  | 2010-04-21 00:00:00 | 2010-04-24 00:00:00 |  | PCIU 2064160 | M0131468 | CRS |  | PENANG | MARKO METALS | Becon Vaille | HMSS | EMHM82 |  | 28.23 | 2.25 | 20.2 | 2500 |  | 7.2 |  | 0 | 0 | 0 | 1600 | O.Bee Logistics | 0 | 0 | 0 | EVE | 0 | 0 | NA | 0 | NA | 0 | 0 | 300 | 0 | 0 | 0 | EDGIN | 45 |  | 150 |  | 180 | 350 |  | 0 | 0 | 0 |  |  |  | 759 | 10 | 0
21 | 21 | MAERSK |  |  |  |  | 2010-02-25 00:00:00 | 2010-04-26 00:00:00 |  | MSKU 3232828 | ZA1652747 | CRS |  | PENANG | PENENSULA SCRAP | BELLVILLE | HMSS | EMHM82 |  | 28.23 | 2.25 | 17.65 | 2200 |  | 7.2 |  | 0 | 0 | 0 | 1600 | O.Bee Logistics | 0 | 0 | 0 | EVE | 0 | 0 | NA | 0 | NA | 0 | 0 | 300 | 0 | 0 | 0 | EDGIN | 45 |  | 150 |  | 180 | 350 |  | 0 | 0 | 0 |  |  |  | 806 | 10 | 0
NOTE
1 | LC STANDS FOR LOCAL CURRENCY
2 | LR SHALL BE PREPARED IN LOCAL CURRENCY ONLY
3 | NO CHANGE IN THIS FORMAT IS ACCEPTABLE
4 | BLR - | B/L RECEIVED
5 | FCL - | FULL CONTAINER LOAD
6 | BLN - | BLI NEEDED