sample data chart part 2updated.xlsx

	B	C	E	F	G	H	I	J	K	L	M
1				Region
2	Quarterly Sales	Sales	Item	Central	East	West	Sales
3	2018		Cell Phone	6075	39375	17100	62550
4	Qtr1-2018	255101	Desk	875		375	1250
5	Qtr2-2018	403826	Home Theater	212000	117000	32000	361000
6	Qtr3-2018	98116	Television	596604	155740	105424	857768
7	Qtr4-2018	121986	Video Games	14215.5	8892		23107.5
8	Qtr1-2019	74925	Grand Total	829769.5	321007	154899	1305675.5
9	Qtr2-2019	204787
10	Qtr3-2019	35162.5
11	Qtr4-2019	111772						Province	Cities in NCR	Country	Population
12	Grand Total	1305675.5						National Capital Region	Caloocan City, Philippines	Philippines	1,661,584
13								National Capital Region	City of Las Piñas	Philippines	606,293
14								National Capital Region	City of Makati	Philippines	629,616
15								National Capital Region	City of Malabon	Philippines	380,522
16								National Capital Region	City of Mandaluyong	Philippines	425,758
17								National Capital Region	City of Manila	Philippines	1,846,513
18								National Capital Region	City of Marikina	Philippines	456,059
19								National Capital Region	City of Muntinlupa	Philippines	543,445
20								National Capital Region	City of Navotas	Philippines	247,543
21								National Capital Region	City of Parañaque	Philippines	689,992
22								National Capital Region	City of Pasay	Philippines	440,656
23								National Capital Region	City of Pasig	Philippines	803,159
24								National Capital Region	Quezon City	Philippines	2,960,048
25								National Capital Region	City of San Juan	Philippines	126,347
26								National Capital Region	City of Taguig	Philippines	886,722
27								National Capital Region	City of Valenzuela	Philippines	714,978
28								National Capital Region	Municipality of Pateros	Philippines	63,643
29
30
31
32
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