MedicinesDiscountCalculator.xlsx

	A	B	C	D	E	F	G	I	J	K
1	Medicine discount calculating Sheet
2	Sl No.	Medicine name	MRP	Rate	With 5% GST	Discount	Discount %	With 18% GST	Discount	Discount %
3	1	Name	100	80	84	16	16.00	94.4	5.6	5.6
4	2	Name	150	120	126	24	16.00	141.6	8.4	5.6
5	3	Name	200	160	168	32	16.00	188.8	11.2	5.6
6	4	Name	250	200	210	40	16.00	236	14	5.6
7	5	Name	300	240	252	48	16.00	283.2	16.8	5.6
8	6	Name	350	280	294	56	16.00	330.4	19.6	5.6
9	7	Name	400	320	336	64	16.00	377.6	22.4	5.6
10	8	Name	450	360	378	72	16.00	424.8	25.2	5.6
11	9	Name	500	400	420	80	16.00	472	28	5.6
12	10	Name	550	440	462	88	16.00	519.2	30.8	5.6
13	11	Name	600	480	504	96	16.00	566.4	33.6	5.6
14	12	Name	650	520	546	104	16.00	613.6	36.4	5.6
15	13	Name	700	560	588	112	16.00	660.8	39.2	5.6
16	14	Name	750	600	630	120	16.00	708	42	5.6
17	15	Name	800	640	672	128	16.00	755.2	44.8	5.6
18	16	Name	850	680	714	136	16.00	802.4	47.6	5.6
19	17	Name	900	720	756	144	16.00	849.6	50.4	5.6
20	18	Name	950	760	798	152	16.00	896.8	53.2	5.6
21	19	Name	1000	800	840	160	16.00	944	56	5.6
22	20	Name	1050	840	882	168	16.00	991.2	58.8	5.6
23	21	Name	1100	880	924	176	16.00	1038.4	61.6	5.6
24	22	Name	1150	920	966	184	16.00	1085.6	64.4	5.6
25	23	Name	1200	960	1008	192	16.00	1132.8	67.2	5.6
26	24	Name	1250	1000	1050	200	16.00	1180	70	5.6
27	25	Name	1300	1040	1092	208	16.00	1227.2	72.8	5.6
28	26	Name	1350	1080	1134	216	16.00	1274.4	75.6	5.6
29	27	Name	1400	1120	1176	224	16.00	1321.6	78.4	5.6
30	28	Name	1450	1160	1218	232	16.00	1368.8	81.2	5.6
31	29	Name	1500	1200	1260	240	16.00	1416	84	5.6
32	30	Name	1550	1240	1302	248	16.00	1463.2	86.8	5.6
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100