++++++++团长留言区++++++++晕倒，第一次做这个google docs，万一不成功的话，大家还是用原始方法跟单吧。。。
========账单详情按items的==========
折后总计1171.58胖子，账单显示2470.94新币，其中278.09胖子即586.77sgd为运费，所以items金额为1884.17新币
gst收了165.65新币（又跟singpost打电话半天解释说这是四箱的总额，每一箱上贴的都是全部的总数不是每箱的单价。。。唉，跟singpost的沟通真是部口水史。。。），这样加上gst得到的items的汇率为2.2942。各item单价按8折后得到其sgd
运费部分是运费586.77sgd除以items总重量58.375kg得到0.01sgd/g，然后乘上各item重量，液体的就按体积数1ml＝1g.只能这样精确了，大家不要介意包装盒瓶子的重量了吧。。。
所以各item总价包含gst运费的sgd是最后一栏
擦汗～我反复确认过了，应该没啥错，小数点后保留了2位
quantity price each £ price aft discounts price S$ weight/g post fee s$ total s$
250ml Blue Melton Plastic Bottle (Caps EXCLUDED)（set of 5）） 1 3.25 2.6 5.96492 250 2.75 8.72
After Sun Soothing Gel & (60ml) x2 set of 5 2 6.5 5.2 11.92984 60 0.66 12.59
Almond Sweet Carrier Oil 100ml 1 2.5 2 4.5884 100 1.1 5.69
Aloe Vera & Rose Hydrating Gel 1Lx2 2 15 12 27.5304 1000 11 38.53
Aloe Vera & rose hydrating gel , 500ml 1 10.5 8.4 19.27128 500 5.5 24.78
Aloe Vera & Seaweed Gel (Premium) 1Lx3 3 9 7.2 16.51824 1000 11 27.52
Aloe Vera & Seaweed Gel (Premium)500mlx22 22 6 4.8 11.01216 500 5.5 16.52
Aloe Vera Gel with Seaweed Extract (500ml) with Free E-Recipe Book x3 3 5.58 4.464 10.2413088 500 5.5 15.75
Aloe Vera, Elderflower & Seaweed Eye Gel (60ml) 1 6.38 5.104 11.7095968 60 0.66 12.37
Aromatherapy Face Mask Kit £13.95 1 13.95 11.16 25.603272 400 4.4 30
Aromatherapy Massage Oil Gift Set x2 2 11.5 9.2 21.10664 300 3.3 24.41
Bergamot FCF Essential Oil 5ml 1 2.21 1.768 4.0561456 5 0.055 4.12
Chamomile Hydrolat &500ml 1 10 8 18.3536 500 5.5 23.86
Chamomile Hydrolat (Organic) 200MLx3 3 5 4 9.1768 200 2.2 11.38
Clary Sage Essential Oil 50ml 1 16 12.8 29.36576 50 0.55 29.92
Cleanser (with Cucumber Extract) 1L 1 10 8 18.3536 1000 11 29.36
Cleanser (with Cucumber Extract) 500mlx3 3 6 4.8 11.01216 500 5.5 16.52
Compressed Face Mask Towels (pack of 20) 1 2.99 2.392 5.4877264 50 0.55 6.04
Eye Rescue Balm (15ml)x2 2 4.21 3.368 7.7268656 15 0.165 7.9
Freesia Queen of Florals Fragrance Oil 1pc 1 1.5 1.2 2.75304 10 0.11 2.86304
French Ultra Fine Green Clay 175gx2 0 0 0 0
Grapeseed Carrier Oil 100mlx2 4 2.5 2 4.5884 100 1.1 5.69
Hair Conditioner (SLS free) 500ml 1 6 4.8 11.01216 500 5.5 16.52
Handmade Lavender Soap 1 1.99 1.592 3.6523664 80 0.88 4.54
Handmade Lemongrass and Chamomile Soapx2 2 1.99 1.592 3.6523664 80 0.88 4.54
Handmade Patchouli and Sandalwood Scrub 1 1.99 1.592 3.6523664 80 0.88 4.54
Handmade Patchouli, Ylang Ylang and Rosehip Soap 1 1.99 1.592 3.6523664 80 0.88 4.54
Handmade Rose Geranium Soap 1 1.99 1.592 3.6523664 80 0.88 4.54
Handmade Tea Tree, Eucalyptus and Sandalwood Soapx2 2 1.99 1.592 3.6523664 80 0.88 4.54
Hazelnut Carrier Oil (100ml) 1 4 3.2 7.34144 100 1.1 8.45
Home Essentials Essential Oil Gift Set 1 8.92 7.136 16.3714112 40 0.44 16.82
Jasmin Nights Fragrance Oilx2 2 1.5 1.2 2.75304 10 0.11 2.87
Jojoba Carrier Oil 100ml 1pc 1 5 4 9.1768 100 1.1 10.28
Lavender (Croatia) Essential Oil -10mlx2 2 3.36 2.688 6.1668096 10 0.11 6.28
Lavender (Croatia) Essential Oil-5ml 1 2.21 1.768 4.0561456 5 0.055 4.12
Lavender (Lavende Fine) ORGANIC essential oil , 5ml 1 6 4.8 11.01216 10 0.11 11.13
Lavender French 40/42 Essential Oil 5mls 1 3.32 2.656 6.0933952 5 0.055 6.15
Lavender Hydrolat & 200mlx2 2 5 4 9.1768 200 2.2 11.38
Lavender Hydrolat (Organic) 500mlx7 7 10 8 18.3536 500 5.5 23.86
Lavender Spike Essential 5ml Oil 1 3.32 2.656 6.0933952 5 0.055 6.15
Lemon Balm (Melissa) Hydrolat (Organic) 500ml 0 0 0 0
Lemongrass Essential Oil 10ml 1 2 1.6 3.67072 10 0.11 3.78
Light White Lotion (500ml) with Free Recipe Sheet 1 5.5 4.4 10.09448 500 5.5 15.6
Lily of the Valley Fragrance Oil (premium)x2 2 1.5 1.2 2.75304 10 0.11 2.87
Lotion Pump White to fit 250ml Melton Rangex3 3 0.58 0.464 1.0645088 250 2.75 3.82
Mini Aromatherapy Oil Burner（orange) 1 1.49 1.192 2.7346864 300 3.3 6.04
Moisture Lotion (97% ORGANIC) 500ml 1 7.1 5.68 13.031056 500 5.5 18.54
Moisture Lotion 500ml 1 6 4.8 11.01216 500 5.5 16.52
Moisturising Cream II (Gardenia) & 500ml 1 10 8 18.3536 500 5.5 23.86
Myrtle Essential Oil 5ml 1 2.21 1.768 4.0561456 5 0.055 4.12
Orange Blossom in Spring Fragrance Oil 3pcx3 3 1.5 1.2 2.75304 10 0.11 2.87
Orange Flower (Neroli) Hydrolat (Organic), 500mlx25 25 10 8 18.3536 500 5.5 23.86
Orange Flower (Neroli) Hydrolat (Organic)_200mlx7 7 5 4 9.1768 200 2.2 11.38
Orange Sweet ORGANIC essential oil , 10ml 1 3.36 2.688 6.1668096 10 0.11 6.28
Peppermint (UK) Essential Oil 50ml 1 6 4.8 11.01216 50 0.55 11.57
Rose & Evening Primrose Facial Oil (30ml) 2pcx2 2 7.5 6 13.7652 30 0.33 14.1
Rose Bliss Fragrance Oilx2 2 1.5 1.2 2.75304 10 0.11 2.87
Rose Otto Hydrolat (Organic) 200mlx3 3 5 4 9.1768 200 2.2 11.38
Rose Otto Hydrolat(Organic) 500mlx18 18 10 8 18.3536 500 5.5 23.86
Sandalwood Lux Fragrance Oil 1 1.5 1.2 2.75304 10 0.11 2.87
Shampoo (SLS free) 500ml 1 4.5 3.6 8.25912 500 5.5 13.76
Standard Cap White to fit 250ml Melton Rangex3 3 0.13 0.104 0.2385968 250 2.75 2.99
Tea Tree Essential Oil 10mLx2 2 3.36 2.688 6.1668096 10 0.11 6.28
Tea Tree Essential Oil -50mlx2 2 10 8 18.3536 50 0.55 18.9
Vanilla Lux Fragrance Oilx2 2 1.5 1.2 2.75304 10 0.11 2.87
Witch Hazel Hydrolat 200ml 1 5 4 9.1768 200 2.2 11.38
Witch Hazel Hydrolat 500mlx2 2 10 8 18.3536 500 5.5 23.86
gst收了165.65新币（又跟singpost打电话半天解释说这是四箱的总额，每一箱上贴的都是全部的总数不是每箱的单价。。。唉，跟singpost的沟通真是部口水史。。。），这样加上gst得到的items的汇率为2.2942。各item单价按8折后得到其sgd
运费部分是运费586.77sgd除以items总重量58.375kg得到0.01sgd/g，然后乘上各item重量，液体的就按体积数1ml＝1g.只能这样精确了，大家不要介意包装盒瓶子的重量了吧。。。
所以各item总价包含gst运费的sgd是最后一栏
擦汗～我反复确认过了，应该没啥错，小数点后保留了2位
quantity price each £ price aft discounts price S$ weight/g post fee s$ total s$
250ml Blue Melton Plastic Bottle (Caps EXCLUDED)（set of 5）） 1 3.25 2.6 5.96492 250 2.75 8.72
After Sun Soothing Gel & (60ml) x2 set of 5 2 6.5 5.2 11.92984 60 0.66 12.59
Almond Sweet Carrier Oil 100ml 1 2.5 2 4.5884 100 1.1 5.69
Aloe Vera & Rose Hydrating Gel 1Lx2 2 15 12 27.5304 1000 11 38.53
Aloe Vera & rose hydrating gel , 500ml 1 10.5 8.4 19.27128 500 5.5 24.78
Aloe Vera & Seaweed Gel (Premium) 1Lx3 3 9 7.2 16.51824 1000 11 27.52
Aloe Vera & Seaweed Gel (Premium)500mlx22 22 6 4.8 11.01216 500 5.5 16.52
Aloe Vera Gel with Seaweed Extract (500ml) with Free E-Recipe Book x3 3 5.58 4.464 10.2413088 500 5.5 15.75
Aloe Vera, Elderflower & Seaweed Eye Gel (60ml) 1 6.38 5.104 11.7095968 60 0.66 12.37
Aromatherapy Face Mask Kit £13.95 1 13.95 11.16 25.603272 400 4.4 30
Aromatherapy Massage Oil Gift Set x2 2 11.5 9.2 21.10664 300 3.3 24.41
Bergamot FCF Essential Oil 5ml 1 2.21 1.768 4.0561456 5 0.055 4.12
Chamomile Hydrolat &500ml 1 10 8 18.3536 500 5.5 23.86
Chamomile Hydrolat (Organic) 200MLx3 3 5 4 9.1768 200 2.2 11.38
Clary Sage Essential Oil 50ml 1 16 12.8 29.36576 50 0.55 29.92
Cleanser (with Cucumber Extract) 1L 1 10 8 18.3536 1000 11 29.36
Cleanser (with Cucumber Extract) 500mlx3 3 6 4.8 11.01216 500 5.5 16.52
Compressed Face Mask Towels (pack of 20) 1 2.99 2.392 5.4877264 50 0.55 6.04
Eye Rescue Balm (15ml)x2 2 4.21 3.368 7.7268656 15 0.165 7.9
Freesia Queen of Florals Fragrance Oil 1pc 1 1.5 1.2 2.75304 10 0.11 2.86304
French Ultra Fine Green Clay 175gx2 0 0 0 0
Grapeseed Carrier Oil 100mlx2 4 2.5 2 4.5884 100 1.1 5.69
Hair Conditioner (SLS free) 500ml 1 6 4.8 11.01216 500 5.5 16.52
Handmade Lavender Soap 1 1.99 1.592 3.6523664 80 0.88 4.54
Handmade Lemongrass and Chamomile Soapx2 2 1.99 1.592 3.6523664 80 0.88 4.54
Handmade Patchouli and Sandalwood Scrub 1 1.99 1.592 3.6523664 80 0.88 4.54
Handmade Patchouli, Ylang Ylang and Rosehip Soap 1 1.99 1.592 3.6523664 80 0.88 4.54
Handmade Rose Geranium Soap 1 1.99 1.592 3.6523664 80 0.88 4.54
Handmade Tea Tree, Eucalyptus and Sandalwood Soapx2 2 1.99 1.592 3.6523664 80 0.88 4.54
Hazelnut Carrier Oil (100ml) 1 4 3.2 7.34144 100 1.1 8.45
Home Essentials Essential Oil Gift Set 1 8.92 7.136 16.3714112 40 0.44 16.82
Jasmin Nights Fragrance Oilx2 2 1.5 1.2 2.75304 10 0.11 2.87
Jojoba Carrier Oil 100ml 1pc 1 5 4 9.1768 100 1.1 10.28
Lavender (Croatia) Essential Oil -10mlx2 2 3.36 2.688 6.1668096 10 0.11 6.28
Lavender (Croatia) Essential Oil-5ml 1 2.21 1.768 4.0561456 5 0.055 4.12
Lavender (Lavende Fine) ORGANIC essential oil , 5ml 1 6 4.8 11.01216 10 0.11 11.13
Lavender French 40/42 Essential Oil 5mls 1 3.32 2.656 6.0933952 5 0.055 6.15
Lavender Hydrolat & 200mlx2 2 5 4 9.1768 200 2.2 11.38
Lavender Hydrolat (Organic) 500mlx7 7 10 8 18.3536 500 5.5 23.86
Lavender Spike Essential 5ml Oil 1 3.32 2.656 6.0933952 5 0.055 6.15
Lemon Balm (Melissa) Hydrolat (Organic) 500ml 0 0 0 0
Lemongrass Essential Oil 10ml 1 2 1.6 3.67072 10 0.11 3.78
Light White Lotion (500ml) with Free Recipe Sheet 1 5.5 4.4 10.09448 500 5.5 15.6
Lily of the Valley Fragrance Oil (premium)x2 2 1.5 1.2 2.75304 10 0.11 2.87
Lotion Pump White to fit 250ml Melton Rangex3 3 0.58 0.464 1.0645088 250 2.75 3.82
Mini Aromatherapy Oil Burner（orange) 1 1.49 1.192 2.7346864 300 3.3 6.04
Moisture Lotion (97% ORGANIC) 500ml 1 7.1 5.68 13.031056 500 5.5 18.54
Moisture Lotion 500ml 1 6 4.8 11.01216 500 5.5 16.52
Moisturising Cream II (Gardenia) & 500ml 1 10 8 18.3536 500 5.5 23.86
Myrtle Essential Oil 5ml 1 2.21 1.768 4.0561456 5 0.055 4.12
Orange Blossom in Spring Fragrance Oil 3pcx3 3 1.5 1.2 2.75304 10 0.11 2.87
Orange Flower (Neroli) Hydrolat (Organic), 500mlx25 25 10 8 18.3536 500 5.5 23.86
Orange Flower (Neroli) Hydrolat (Organic)_200mlx7 7 5 4 9.1768 200 2.2 11.38
Orange Sweet ORGANIC essential oil , 10ml 1 3.36 2.688 6.1668096 10 0.11 6.28
Peppermint (UK) Essential Oil 50ml 1 6 4.8 11.01216 50 0.55 11.57
Rose & Evening Primrose Facial Oil (30ml) 2pcx2 2 7.5 6 13.7652 30 0.33 14.1
Rose Bliss Fragrance Oilx2 2 1.5 1.2 2.75304 10 0.11 2.87
Rose Otto Hydrolat (Organic) 200mlx3 3 5 4 9.1768 200 2.2 11.38
Rose Otto Hydrolat(Organic) 500mlx18 18 10 8 18.3536 500 5.5 23.86
Sandalwood Lux Fragrance Oil 1 1.5 1.2 2.75304 10 0.11 2.87
Shampoo (SLS free) 500ml 1 4.5 3.6 8.25912 500 5.5 13.76
Standard Cap White to fit 250ml Melton Rangex3 3 0.13 0.104 0.2385968 250 2.75 2.99
Tea Tree Essential Oil 10mLx2 2 3.36 2.688 6.1668096 10 0.11 6.28
Tea Tree Essential Oil -50mlx2 2 10 8 18.3536 50 0.55 18.9
Vanilla Lux Fragrance Oilx2 2 1.5 1.2 2.75304 10 0.11 2.87
Witch Hazel Hydrolat 200ml 1 5 4 9.1768 200 2.2 11.38
Witch Hazel Hydrolat 500mlx2 2 10 8 18.3536 500 5.5 23.86
Huasing Association 1999 - 2013