Mock-up Excel Dashboard.xlsx

	AJ	AK	AL	AM	AN	AO
1
2
3
4
5	Industry	Open	Open but limited operations	Temporarily closed	Permanently closed (will not reopen)
6	Entertainment & Recreation	16	83	87	3
7	Construction	15	35	162	2
8	Manufacturing	12	68	180	1
9	Accommodation and Food Service Activities	5	69	276	6
10	Wholesale and Retail Trade; Repair of Motor Vehicles and Motorcycles	16	155	356	7
11
12
13	Industry	Open	Open but limited operations	Temporarily closed	Permanently closed (will not reopen)
14	BARMM (formerly ARMM)	-	-	1	-
15	Region 8: Eastern Visayas	1	14	9	1
16	Region 13: Caraga	-	11	9	-
17	Region 9: Zamboanga Peninsula	-	9	11	-
18	Region 12: SOCCSKSARGEN	-	9	11	-
19	Cordillera Administrative Region	-	7	15	1
20	Region 2: Cagayan Valley	-	6	15	2
21	Region 1: Ilocos	1	8	17	-
22	Region 10: Northern Mindanao	-	18	30	-
23	MIMAROPA	1	10	35	-
24	Region 5: Bicol	-	14	35	2
25	Region 11: Davao	1	26	57	1
26	Region 6: Western Visayas	2	35	63	-
27	Region 7: Central Visayas	7	58	118	2
28	Region 3: Central Luzon	10	57	159	4
29	Region 4A: Calabarzon	15	97	233	2
30	National Capital Region	60	343	816	12
31
32	Firm Size	Within 2 weeks	1 month	1 to 3 months	More than 3 months	Unable to judge
33	Micro Business	23	27	176	396	664
34	Small Business	15	14	102	195	350
35	Medium Business	4	5	56	98	168
36	Large Business	2	8	29	53	94
37
38	Firm Size	Increased	Decreased	Remained the same
39	Micro Business	15	987	284
40	Small Business	5	520	151
41	Medium Business	6	254	71
42	Large Business	3	142	41
43
44	Industry	Hired	Laid off	Granted leave	Reduced salary/wages/benefit	Reduced working hours
45	Manufacturing	191	200	320	321	321
46	Construction	154	138	486	148	211
47	Accommodation and Food Service Activities	125	120	120	125	100
48	Professional, Scientific, and Technical Activities	53	111	53	53	53
49	Wholesale and Retail Trade; Repair of Motor Vehicles and Motorcycles	188	89	212	133	957
50	Information and Communication	100	80	500	700	445
51	Financial and Insurance Activities	353	55	496	30	4,355
52	Transportation and storage	119	50	750	55	400
53	Administrative and Support Service Activities	56	50	450	377	600
54	Arts, Entertainment, and Recreation	26	33	90	50	50
55	Education	8	25	20	24	21
56	Real Estate Activities	22	23	16	402	22
57	Electricity, Gas, Steam, and Air Conditioning Supply	16	10	15	30	16
58	Agriculture, Forestry, and Fishing	16	5	70	65	73
59	Water Supply, Sewerage, Waste Management, and Remediation Activities	4	-	62	20	62
60	Public Administration and Defense; Compulsory Social Security	-	-	-	-	-
61	Human Health and Social Work Activities	10	-	30	10	10
62
63
64	Customer less aware of product	3
65	Customers can't buy online	5
66	Quality of product decreased	5
67	Price of products increased	17
68	Others	21
69	Less interest from customers	22
70	Customers cant travel	37
71	Limited operations	51
72
73
74		Increased use	Use not increased	New adopters	Never adopted
75	Online sales or payment solutions	52	10	9	27
76	Social media for marketing	62	9	8	21
77	CRM or SRM software	62	8	6	62
78	ERP software	71	7	3	71
79
80
81	Reorganization cost resistance	4
82	No challenges	6
83	Uncertainty of the benefits of adopting technology	8
84	Other	8
85	No need	9
86	Costly to comply govt regulations	12
87	Lack of info on available technology	17
88	Lack of technical skills or skilled workers	20
89	Internet connection too expensive or unreliable	26
90	Lack of financial resources	54
91
92
93
94
95
96
97
98
99
100