Spreadsheet: 846072d1697371222-formula-to-split-prorata-taxes-and-vat-based-on-3-criteria-columns-of-summary-sheet-dummy-tax-ca-sample-
Sheet: DETAIL BREAKDOWN expected resul

Référence | Container # | Manifreste | Ligne | Référence Commande | Autre Référence | Code Fournisseur | [NAME] | Code Article | Description Article | Code Article Fournisseur | HSCode | Duty % | HSCode Celero | Duty %2 | Qté | Devise  d'Achat | Prix d'Achat en Devise | Total Prix d'Achat en Devise | Itemised | DUTY expected results | VAT expected results | TARIFF | [NAME] | origin.
IPINV0004175 | CAIU812654/8 | 1 | 785 | POTR0005558 | IN67230729 | GALI | GALIX SOLAIRE JIAWEI EUROPE SAS | 0101985 | Torche solaire en résine 12 led ambrée vacillantes - GALIX | G2304 | 85131000 | 36 |  |  | 72 | EUR | 4.07 | 293.26 | 1 |  |  | 94054920 | SOLAR LED LAMPS. | CN
IPINV0004175 | CAIU812654/8 | 1 | 786 | POTR0005558 | IN67230729 | GALI | GALIX SOLAIRE JIAWEI EUROPE SAS | 0101979 | Décoration de table solaire verre/corde blanc - GALIX | G2312 | 94054920 | 0 |  |  | 12 | EUR | 7.27 | 87.28 | 1 |  |  | 94054920 | SOLAR LED LAMPS. | CN
IPINV0004175 | CAIU812654/8 | 1 | 787 | POTR0005558 | IN67230729 | GALI | GALIX SOLAIRE JIAWEI EUROPE SAS | 0101978 | Sphère solaire effet verre brisé Ø10  cm - GALIX | G2011/10 | 94054920 | 0 |  |  | 8 | EUR | 6.79 | 54.31 | 1 |  |  | 94054920 | SOLAR LED LAMPS. | CN
IPINV0004175 | CAIU812654/8 | 1 | 786 | POTR0005558 | IN67230729 | GALI | GALIX SOLAIRE JIAWEI EUROPE SAS | 0101979 | Décoration de table solaire verre/corde blanc - GALIX | G2312 | 94054920 | 0 |  |  | 12 | EUR | 7.27 | 87.28 | 1 |  |  | 94054920 | SOLAR LED LAMPS. | CN
IPINV0004175 | CAIU812654/8 | 1 | 787 | POTR0005558 | IN67230729 | GALI | GALIX SOLAIRE JIAWEI EUROPE SAS | 0101978 | Sphère solaire effet verre brisé Ø10  cm - GALIX | G2011/10 | 94054920 | 0 |  |  | 8 | EUR | 6.79 | 54.31 | 1 |  |  | 94054920 | SOLAR LED LAMPS. | CN
IPINV0004098 | CAIU812654/8 | 2 | 13 | POTR0005520 | 41331397 | CIME | INTERGES.COM CIME | 0043809 | [NAME] | 11214.4 | 56029000 | 0 |  |  | 10 | EUR | 0.72 | 7.2 | 2 |  |  | 56029000 | FELT ARTICLES | CN
IPINV0004098 | CAIU812654/8 | 2 | 14 | POTR0005520 | 41331397 | CIME | INTERGES.COM CIME | 0002869 | CH PIANO 32X1740 AC LAIT | 50641 | 83021000 | 0 |  |  | 4 | EUR | 3.01 | 12.04 | 3 |  |  | 83021000 | HINGES | CN
IPINV0004098 | CAIU812654/8 | 2 | 19 | POTR0005520 | 41331397 | CIME | INTERGES.COM CIME | 0057399 | CH INV D26 REC A/R+PLAQUE | 51876 | 83021000 | 0 |  |  | 10 | EUR | 1.43 | 14.3 | 3 |  |  | 83021000 | HINGES | CN
IPINV0004098 | CAIU812654/8 | 2 | 56 | POTR0005520 | 41331397 | CIME | INTERGES.COM CIME | 0044070 | CHARNIERE COFFRET 25X13 LA X2 | CQ.12151.2 | 83021000 | 0 |  |  | 5 | EUR | 0.96 | 4.8 | 3 |  |  | 83021000 | HINGES | CN
IPINV0004098 | CAIU812654/8 | 2 | 15 | POTR0005520 | 41331397 | CIME | INTERGES.COM CIME | 0003148 | TUBE PENDERIE ROND 2M D=19 | 50738 | 83024900 | 0 |  |  | 5 | EUR | 5.03 | 25.15 | 4 |  |  | 83024900 | STEEL TUBES | FR
IPINV0004098 | CAIU812654/8 | 2 | 16 | POTR0005520 | 41331397 | CIME | INTERGES.COM CIME | 0002394 | Equerre embouti acier laqué 150 x 200 mm blanc - CIME | 51073 | 83024900 | 0 |  |  | 40 | EUR | 0.32 | 12.8 | 5 |  |  | 83024900 | BASED METAL MOUNTINGS | CN
IPINV0004098 | CAIU812654/8 | 2 | 17 | POTR0005520 | 41331397 | CIME | INTERGES.COM CIME | 0043851 | PIED D50X150 HET.BR.VIS MONTEE | 51635 | 83024900 | 0 |  |  | 4 | EUR | 1.79 | 7.16 | 5 |  |  | 83024900 | BASED METAL MOUNTINGS | CN
IPINV0004098 | CAIU812654/8 | 2 | 20 | POTR0005520 | 41331397 | CIME | INTERGES.COM CIME | 0057400 | EQUERRE ASS ENTR32 AC ZG | 51910 | 83024900 | 0 |  |  | 4 | EUR | 0.41 | 1.64 | 5 |  |  | 83024900 | BASED METAL MOUNTINGS | CN
IPINV0004098 | CAIU812654/8 | 2 | 22 | POTR0005520 | 41331397 | CIME | INTERGES.COM CIME | 0003030 | CONS MULTI H 150X200X18X11(F) | 52461 | 83024900 | 0 |  |  | 10 | EUR | 1.29 | 12.9 | 5 |  |  | 83024900 | BASED METAL MOUNTINGS | CN
IPINV0004098 | CAIU812654/8 | 2 | 30 | POTR0005520 | 41331397 | CIME | INTERGES.COM CIME | 0043921 | PIED CYLIND HETRE BRUT H80 D68 | 53555 | 83024900 | 0 |  |  | 4 | EUR | 2.03 | 8.12 | 5 |  |  | 83024900 | BASED METAL MOUNTINGS | CN
IPINV0004098 | CAIU812654/8 | 2 | 33 | POTR0005520 | 41331397 | CIME | INTERGES.COM CIME | 0076234 | CONS LEONARD AC MP NR 144X240 | 54034 | 83024900 | 0 |  |  | 10 | EUR | 1.16 | 11.6 | 5 |  |  | 83024900 | BASED METAL MOUNTINGS | CN
IPINV0004098 | CAIU812654/8 | 2 | 35 | POTR0005520 | 41331397 | CIME | INTERGES.COM CIME | 0076222 | Equerre [NAME] 250 x 250 mm blanc - CIME | 54084 | 83024900 | 0 |  |  | 10 | EUR | 2.76 | 27.6 | 5 |  |  | 83024900 | BASED METAL MOUNTINGS | CN
IPINV0004098 | CAIU812654/8 | 2 | 48 | POTR0005520 | 41331397 | CIME | INTERGES.COM CIME | 0101577 | Console double 32 x 370 mm gris alu - CIME | B3D.037.11.BG | 83024900 | 0 |  |  | 10 | EUR | 1.27 | 12.7 | 5 |  |  | 83024900 | BASED METAL MOUNTINGS | CN
IPINV0004098 | CAIU812654/8 | 2 | 49 | POTR0005520 | 41331397 | CIME | INTERGES.COM CIME | 0100018 | Console double 32 x 370 mm blanc - CIME | B3D.037.11.BW | 83024900 | 0 |  |  | 20 | EUR | 1.26 | 25.2 | 5 |  |  | 83024900 | BASED METAL MOUNTINGS | CN
IPINV0004098 | CAIU812654/8 | 2 | 50 | POTR0005520 | 41331397 | CIME | INTERGES.COM CIME | 0104765 | Console simple 50 x 350 mm blanc - CIME | B5S.035.11.BW |  | 0 |  |  | 10 | EUR | 0.84 | 8.4 | 5 |  |  | 83024900 | BASED METAL MOUNTINGS | CN
IPINV0004098 | CAIU812654/8 | 2 | 58 | POTR0005520 | 41331397 | CIME | INTERGES.COM CIME | 0091338 | SUP EXT OUV D25 ZK CHR X2 | CQ.14088.2 | 83024900 | 0 |  |  | 4 | EUR | 3.13 | 12.52 | 5 |  |  | 83024900 | BASED METAL MOUNTINGS | CN
IPINV0004098 | CAIU812654/8 | 2 | 65 | POTR0005520 | 41331397 | CIME | INTERGES.COM CIME | 0076217 | Equerre charge lourde 400 x 350 mm alu gris - CIME | EQ.014.BX | 83024900 | 0 |  |  | 10 | EUR | 10.51 | 105.1 | 5 |  |  | 83024900 | BASED METAL MOUNTINGS | CN
IPINV0004098 | CAIU812654/8 | 2 | 66 | POTR0005520 | 41331397 | CIME | INTERGES.COM CIME | 0044147 | EQU ASS 24X24 AC ZG X10 | VS.1372010 | 83024100 | 0 |  |  | 5 | EUR | 1.26 | 6.3 | 5 |  |  | 83024900 | BASED METAL MOUNTINGS | CN