test_data_v2.xlsx

	A	B	C	D	E	F	G	H
1	Shock Type	Value Type	Year	Fee Type	Scenario Parent	Scenario	Sales Delta	Value
2	Market Shock	Delta	2022	Total Revenue	All Consulting	All Consulting		97
3	Market Shock	Delta	2022	Total Revenue	Tech Consulting	Tech Consulting +50% Sales	+50%	8
4	Market Shock	Delta	2022	Total Revenue	Tech Consulting	Tech Consulting -50% Sales	-50%	6
5	Market Shock	Delta	2022	Total Revenue	Management Consulting	Management Consulting + 50% Sales	+50%	7
6	Market Shock	Delta	2022	Total Revenue	Management Consulting	Management Consulting - 50% Sales	-50%	3
7	Market Shock	Delta	2022	Total Revenue	Tech & Management Consulting	Tech & Management Consulting + 50% Sales	+50%	4
8	Market Shock	Delta	2022	Total Revenue	Tech & Management Consulting	Tech & Management Consulting -50% Sales	-50%	1
9	Market Shock	Delta	2022	Total Revenue	Aerospace Consulting	Aerospace Consulting +100% Sales	+100%	9
10	Market Shock	Delta	2022	Total Revenue	Aerospace Consulting	Aerospace Consulting -100% Sales	-100%	1
11	Market Shock	Delta	2022	Total Revenue	Defense Consulting	Defense Consulting +100% Sales	+100%	4
12	Market Shock	Delta	2022	Total Revenue	Defense Consulting	Defense Consulting -100% Sales	-100%	5
13	Market Shock	Delta	2022	Total Revenue	Operations Consulting	Operations Consulting		1
14	Market Shock	Delta	2023	Total Revenue	All Consulting	All Consulting		98
15	Market Shock	Delta	2023	Total Revenue	Tech Consulting	Tech Consulting +50% Sales	+50%	7
16	Market Shock	Delta	2023	Total Revenue	Tech Consulting	Tech Consulting -50% Sales	-50%	2
17	Market Shock	Delta	2023	Total Revenue	Management Consulting	Management Consulting + 50% Sales	+50%	7
18	Market Shock	Delta	2023	Total Revenue	Management Consulting	Management Consulting - 50% Sales	-50%	10
19	Market Shock	Delta	2023	Total Revenue	Tech & Management Consulting	Tech & Management Consulting + 50% Sales	+50%	9
20	Market Shock	Delta	2023	Total Revenue	Tech & Management Consulting	Tech & Management Consulting -50% Sales	-50%	6
21	Market Shock	Delta	2024	Total Revenue	Aerospace Consulting	Aerospace Consulting +100% Sales	+100%	9
22	Market Shock	Delta	2023	Total Revenue	Aerospace Consulting	Aerospace Consulting -100% Sales	-100%	7
23	Market Shock	Delta	2023	Total Revenue	Defense Consulting	Defense Consulting +100% Sales	+100%	10
24	Market Shock	Delta	2023	Total Revenue	Defense Consulting	Defense Consulting -100% Sales	-100%	7
25	Market Shock	Delta	2023	Total Revenue	Operations Consulting	Operations Consulting		2
26	Market Shock	Delta	2024	Total Revenue	All Consulting	All Consulting		113
27	Market Shock	Delta	2024	Total Revenue	Tech Consulting	Tech Consulting +50% Sales	+50%	9
28	Market Shock	Delta	2024	Total Revenue	Tech Consulting	Tech Consulting -50% Sales	-50%	4
29	Market Shock	Delta	2024	Total Revenue	Management Consulting	Management Consulting + 50% Sales	+50%	2
30	Market Shock	Delta	2024	Total Revenue	Management Consulting	Management Consulting - 50% Sales	-50%	9
31	Market Shock	Delta	2024	Total Revenue	Tech & Management Consulting	Tech & Management Consulting + 50% Sales	+50%	5
32	Market Shock	Delta	2024	Total Revenue	Tech & Management Consulting	Tech & Management Consulting -50% Sales	-50%	3
33	Market Shock	Delta	2024	Total Revenue	Aerospace Consulting	Aerospace Consulting +100% Sales	+100%	8
34	Market Shock	Delta	2024	Total Revenue	Aerospace Consulting	Aerospace Consulting -100% Sales	-100%	3
35	Market Shock	Delta	2024	Total Revenue	Defense Consulting	Defense Consulting +100% Sales	+100%	2
36	Market Shock	Delta	2024	Total Revenue	Defense Consulting	Defense Consulting -100% Sales	-100%	9
37	Market Shock	Delta	2024	Total Revenue	Operations Consulting	Operations Consulting		5
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