Forum Discussion

deokars43's avatar
deokars43
Copper Contributor
Oct 29, 2022

Microsoft excel average function.

Spoiler
 

I want help with Microsoft excel average function. Please help me with following conditions in excel.
Data is attached below.

1What is the average total USD rev/parent?
2What is the average total USD rev/parent if you exclude parents which have revenue only in D product (i.e 0 rev in other products)
3What % of revenue comes from parents whose total revenue <100 USD, 100-200 USD, 200-500 USD, >500 USD
4How many parents have revenue >100 USD in date range of Dec 1 to Dec 10

 

Data 

All rev in USD     
Child IdParent Company IDDate RangeRev from Product ARev from Product BRev from Product CRev from Product D
1b12017-12-01 -> 2017-12-0100.1900
2b12017-12-18 -> 2017-12-18000.310
3b12017-12-07 -> 2017-12-07000.460
4b22017-12-24 -> 2017-12-25001.070
5b32017-12-06 -> 2017-12-20001.180
6b32017-12-24 -> 2017-12-29001.470
1b12017-12-01 -> 2017-12-01002.180
2b12017-12-01 -> 2017-12-01002.690
3b12017-12-26 -> 2017-12-30002.970
4b22017-12-01 -> 2017-12-01002.990
5b32017-12-19 -> 2017-12-30004.270
6b32017-12-21 -> 2017-12-22005.010
7b72017-12-29 -> 2017-12-30006.820
1b12017-12-01 -> 2017-12-02006.790
1b12017-12-01 -> 2017-12-23008.650
12b82017-12-16 -> 2017-12-17008.910
17b92017-12-18 -> 2017-12-3109.7200
18b92017-12-01 -> 2017-12-01010.5200
19b102017-12-01 -> 2017-12-030011.260
20b102017-12-08 -> 2017-12-31011.3600
21b112017-12-24 -> 2017-12-270012.930
22b112017-12-07 -> 2017-12-090013.610
23b22017-12-01 -> 2017-12-040013.990
24b22017-12-22 -> 2017-12-220014.410
25b132017-12-17 -> 2017-12-210015.490
26b132017-12-13 -> 2017-12-260015.580
27b142017-12-01 -> 2017-12-300015.590
28b142017-12-01 -> 2017-12-140015.670
29b32017-12-30 -> 2017-12-3116.13000
30b32017-12-01 -> 2017-12-070016.090
31b162017-12-07 -> 2017-12-07019.0700
32b162017-12-01 -> 2017-12-030019.670
33b172017-12-04 -> 2017-12-26020.9800
34b172017-12-06 -> 2017-12-1021.42000
35b42017-12-02 -> 2017-12-0508.6713.430
36b42017-12-20 -> 2017-12-230022.660
37b192017-12-12 -> 2017-12-190022.590
38b192017-12-21 -> 2017-12-300021.551.88
39b202017-12-28 -> 2017-12-3023.49000
40b202017-12-05 -> 2017-12-120023.310
41b212017-12-28 -> 2017-12-310024.070
42b212017-12-07 -> 2017-12-160021.283.12
43b222017-12-01 -> 2017-12-020024.790
44b62017-12-21 -> 2017-12-31025.0700
45b72017-12-01 -> 2017-12-050024.830
46b232017-12-07 -> 2017-12-2200620.040
47b242017-12-04 -> 2017-12-05024.8200
48b242017-12-15 -> 2017-12-190025.520
49b252017-12-12 -> 2017-12-170025.580
50b252017-12-01 -> 2017-12-030025.930
51b262017-12-08 -> 2017-12-110026.130
52b262017-12-13 -> 2017-12-170026.450
53b272017-12-06 -> 2017-12-130026.40
54b272017-12-16 -> 2017-12-160026.820
55b282017-12-01 -> 2017-12-040026.780
56b282017-12-11 -> 2017-12-13027.8900
57b292017-12-21 -> 2017-12-260028.960
58b292017-12-01 -> 2017-12-300027.321.88
59b302017-12-10 -> 2017-12-120029.770
60b302017-12-03 -> 2017-12-090030.210
61b312017-12-07 -> 2017-12-23455.26000
62b312017-12-01 -> 2017-12-170031.020
63b322017-12-21 -> 2017-12-280032.490
64b322017-12-01 -> 2017-12-0532.9000
65b332017-12-01 -> 2017-12-030033.080
66b332017-12-07 -> 2017-12-190034.120
67b342017-12-04 -> 2017-12-300035.220
68b342017-12-01 -> 2017-12-03035.300
69b352017-12-01 -> 2017-12-150036.970
70b352017-12-12 -> 2017-12-180037.680
71b362017-12-08 -> 2017-12-120038.290
72b362017-12-16 -> 2017-12-19039.700
73b372017-12-21 -> 2017-12-300041.70
74b372017-12-01 -> 2017-12-300041.510
75b382017-12-01 -> 2017-12-090046.480
76b382017-12-27 -> 2017-12-290047.580
77b392017-12-04 -> 2017-12-280034.9213.16
78b392017-12-01 -> 2017-12-2002.5325.4120.86
79b402017-12-01 -> 2017-12-040050.250
80b402017-12-13 -> 2017-12-160050.560
81b412017-12-01 -> 2017-12-040051.460
82b412017-12-15 -> 2017-12-180053.820
83b422017-12-07 -> 2017-12-180053.750
84b422017-12-01 -> 2017-12-2303.5150.670
85b432017-12-05 -> 2017-12-200048.355.91
86b432017-12-20 -> 2017-12-300054.790
87b442017-12-01 -> 2017-12-050054.660
88b442017-12-01 -> 2017-12-090055.910
89b452017-12-07 -> 2017-12-080056.030
90b452017-12-01 -> 2017-12-070056.240
91b462017-12-05 -> 2017-12-100056.671.55
92b462017-12-20 -> 2017-12-2658.95000
93b472017-12-01 -> 2017-12-20058.8800
94b472017-12-01 -> 2017-12-080059.190
95b482017-12-28 -> 2017-12-310060.60
96b482017-12-01 -> 2017-12-070060.390
97b492017-12-01 -> 2017-12-150061.130
98b492017-12-04 -> 2017-12-300062.870
99b502017-12-04 -> 2017-12-060065.060
100b502017-12-06 -> 2017-12-280065.520
101b512017-12-01 -> 2017-12-150065.510
102b512017-12-15 -> 2017-12-270066.780
103b522017-12-01 -> 2017-12-180069.390
104b522017-12-10 -> 2017-12-260070.560
105b532017-12-01 -> 2017-12-120021.3549.68
106b532017-12-01 -> 2017-12-090071.140
107b542017-12-01 -> 2017-12-300072.490
108b542017-12-01 -> 2017-12-300073.270
109b552017-12-01 -> 2017-12-300073.530
110b552017-12-01 -> 2017-12-220075.240
111b562017-12-27 -> 2017-12-300075.770
112b562017-12-03 -> 2017-12-150075.20
113b572017-12-01 -> 2017-12-030077.820
114b572017-12-01 -> 2017-12-070078.270
115b582017-12-01 -> 2017-12-19078.500
116b582017-12-01 -> 2017-12-190079.010
117b592017-12-12 -> 2017-12-160079.330
118b592017-12-26 -> 2017-12-300080.540
119b602017-12-01 -> 2017-12-250081.060
120b602017-12-21 -> 2017-12-300083.370
121b612017-12-11 -> 2017-12-31084.8100.31
122b612017-12-29 -> 2017-12-300086.130
123b622017-12-04 -> 2017-12-170086.50
124b622017-12-01 -> 2017-12-28087.700
125b632017-12-01 -> 2017-12-31087.9300
126b632017-12-01 -> 2017-12-050089.580
127b642017-12-05 -> 2017-12-300091.980
128b642017-12-22 -> 2017-12-300097.140
129b652017-12-01 -> 2017-12-100098.350
130b652017-12-01 -> 2017-12-050098.780
131b662017-12-21 -> 2017-12-3100101.050
132b662017-12-14 -> 2017-12-16000204.03
133b672017-12-04 -> 2017-12-130096.245.28
134b672017-12-28 -> 2017-12-3174.84029.570
135b682017-12-07 -> 2017-12-200060.5344.7
136b682017-12-01 -> 2017-12-2700107.930
137b692017-12-01 -> 2017-12-2500110.990
138b692017-12-26 -> 2017-12-3000112.180
139b702017-12-09 -> 2017-12-1900113.50
140b702017-12-01 -> 2017-12-3000116.890
141b712017-12-07 -> 2017-12-31024.8391.921.87
142b712017-12-01 -> 2017-12-1600119.310
143b722017-12-11 -> 2017-12-3000120.410
144b722017-12-01 -> 2017-12-1100121.480
145b732017-12-01 -> 2017-12-3001.83121.440
146b732017-12-11 -> 2017-12-280100.61028.38
147b742017-12-01 -> 2017-12-31046.5683.410
148b742017-12-20 -> 2017-12-3000132.120
149b752017-12-01 -> 2017-12-2300132.280
150b752017-12-08 -> 2017-12-3005.41121.310.29
151b762017-12-01 -> 2017-12-1700137.460
152b762017-12-20 -> 2017-12-3000139.820
153b772017-12-01 -> 2017-12-0900138.770
154b772017-12-30 -> 2017-12-31070.5772.230
155b782017-12-01 -> 2017-12-1200143.870
156b782017-12-05 -> 2017-12-2400145.860
157b792017-12-12 -> 2017-12-3000146.530.31
158b792017-12-01 -> 2017-12-1100146.980
159b802017-12-17 -> 2017-12-3000156.590
160b802017-12-02 -> 2017-12-30049.72107.230
161b812017-12-01 -> 2017-12-2500160.80.31
162b812017-12-01 -> 2017-12-3000161.510
163b822017-12-02 -> 2017-12-1304.84157.720
164b822017-12-29 -> 2017-12-3008.29156.160
165b832017-12-01 -> 2017-12-1900164.60
166b832017-12-15 -> 2017-12-2900167.461.87
167b842017-12-01 -> 2017-12-3000169.980
168b842017-12-21 -> 2017-12-2900172.240
169b852017-12-01 -> 2017-12-11170.76000
170b852017-12-01 -> 2017-12-21139.34038.460
171b862017-12-01 -> 2017-12-2500177.510
172b862017-12-10 -> 2017-12-1900179.610
173b872017-12-19 -> 2017-12-3103.5178.50
174b872017-12-27 -> 2017-12-30097.2590.620
175b882017-12-01 -> 2017-12-3100187.10
176b882017-12-01 -> 2017-12-310192.9600
177b892017-12-01 -> 2017-12-3100179.8913.08
178b892017-12-04 -> 2017-12-070192.4500
179b902017-12-01 -> 2017-12-1500192.590
180b902017-12-01 -> 2017-12-2900200.830
181b912017-12-01 -> 2017-12-2700210.430
182b912017-12-13 -> 2017-12-3000212.940
183b922017-12-15 -> 2017-12-2500214.480
184b922017-12-01 -> 2017-12-080065.89152.68
185b932017-12-18 -> 2017-12-3000231.980
186b932017-12-06 -> 2017-12-2989.710142.310
187b942017-12-11 -> 2017-12-2900236.690
188b942017-12-01 -> 2017-12-1100238.180
189b952017-12-15 -> 2017-12-2700243.220
190b952017-12-01 -> 2017-12-3000243.020
191b962017-12-01 -> 2017-12-3100245.750
192b962017-12-01 -> 2017-12-18246.13000
193b972017-12-12 -> 2017-12-3000248.850
194b972017-12-01 -> 2017-12-070252.2100
195b982017-12-16 -> 2017-12-3000264.760
196b982017-12-01 -> 2017-12-2300266.30
197b992017-12-01 -> 2017-12-2900269.460
198b992017-12-01 -> 2017-12-1800270.020
199b1002017-12-01 -> 2017-12-30095.01177.660
200b1002017-12-15 -> 2017-12-2100271.291.88
201b1012017-12-01 -> 2017-12-2000277.780
202b1012017-12-01 -> 2017-12-2200279.470
203b1022017-12-20 -> 2017-12-2500075.18
204b1022017-12-01 -> 2017-12-300127.97153.830
205b1032017-12-01 -> 2017-12-1100282.80
206b1032017-12-06 -> 2017-12-2300285.460
207b1042017-12-10 -> 2017-12-3000291.490
208b1042017-12-21 -> 2017-12-2700285.279.19
209b1052017-12-13 -> 2017-12-3000302.520
210b1052017-12-01 -> 2017-12-1700305.730
211b1062017-12-23 -> 2017-12-300052.3914.76
212b1062017-12-23 -> 2017-12-2701.75310.110
213b1072017-12-18 -> 2017-12-2700311.40
214b1072017-12-18 -> 2017-12-2700311.320
215b1082017-12-22 -> 2017-12-280065.130
216b1082017-12-11 -> 2017-12-2700310.360
217b1092017-12-05 -> 2017-12-2700064.13
218b1092017-12-13 -> 2017-12-2700310.330
219b1102017-12-22 -> 2017-12-290062.340
220b1102017-12-07 -> 2017-12-2700310.010
221b1102017-12-12 -> 2017-12-2508.27301.720
222b1102017-12-19 -> 2017-12-2900312.990
223b1102017-12-13 -> 2017-12-3000312.480
224b1102017-12-07 -> 2017-12-19010.44300.810
225b1102017-12-11 -> 2017-12-2900312.250
226b1102017-12-01 -> 2017-12-2200290.7528.19
227b1102017-12-05 -> 2017-12-2800057.98
228b1102017-12-01 -> 2017-12-3000328.670
229b1102017-12-01 -> 2017-12-2900331.340.31
230b1152017-12-01 -> 2017-12-13330.83000
231b1162017-12-01 -> 2017-12-1700334.370
232b1162017-12-05 -> 2017-12-3000339.490
233b1172017-12-01 -> 2017-12-2100341.890
234b1172017-12-01 -> 2017-12-31342.5000
235b1182017-12-01 -> 2017-12-1500349.60
236b1182017-12-01 -> 2017-12-2600350.660
237b1192017-12-01 -> 2017-12-1800355.260
238b1192017-12-22 -> 2017-12-290051.190
239b1202017-12-01 -> 2017-12-3100359.320
240b1202017-12-01 -> 2017-12-3100360.110.31
241b1212017-12-01 -> 2017-12-23362.68000
242b1212017-12-01 -> 2017-12-110373.2100
243b1222017-12-06 -> 2017-12-170379.2800
244b1222017-12-07 -> 2017-12-090047.310
245b1232017-12-15 -> 2017-12-2700384.190
246b1232017-12-01 -> 2017-12-310383.2700
247b1242017-12-01 -> 2017-12-310216169.810
248b1242017-12-07 -> 2017-12-2900041.3
249b1252017-12-22 -> 2017-12-280039.740
250b1252017-12-01 -> 2017-12-160386.1100
251b1262017-12-22 -> 2017-12-270039.560
252b1262017-12-20 -> 2017-12-2600389.360
253b1272017-12-01 -> 2017-12-270172.79240.490
254b1272017-12-01 -> 2017-12-31302.8815.6499.260
255b1282017-12-22 -> 2017-12-290036.420
256b1282017-12-22 -> 2017-12-300035.990
257b1292017-12-01 -> 2017-12-270418.2400
258b1292017-12-22 -> 2017-12-3100422.780
259b1302017-12-01 -> 2017-12-2700420.820
260b1302017-12-01 -> 2017-12-140193.11115.78119.33
261b1312017-12-01 -> 2017-12-3000430.70
262b1312017-12-01 -> 2017-12-2900451.880
263b1322017-12-01 -> 2017-12-1600451.480
264b1322017-12-01 -> 2017-12-28088.88374.380
265b1332017-12-01 -> 2017-12-150462.4600
266b1332017-12-01 -> 2017-12-2500463.910
267b1342017-12-14 -> 2017-12-1900028.99
268b1342017-12-24 -> 2017-12-2700470.190
269b1352017-12-12 -> 2017-12-3100469.010
270b1352017-12-05 -> 2017-12-2996.05336.9334.970
271b1362017-12-06 -> 2017-12-2600026.8
272b1362017-12-05 -> 2017-12-2800468.290
273b1372017-12-07 -> 2017-12-27034.98433.830
274b1372017-12-09 -> 2017-12-31386.84096.270
275b1382017-12-01 -> 2017-12-3000485.570
276b1382017-12-19 -> 2017-12-3000026
277b1392017-12-01 -> 2017-12-2900511.510
278b1392017-12-01 -> 2017-12-300105.97408.640.99
279b1402017-12-14 -> 2017-12-280509.5233.470
280b1402017-12-01 -> 2017-12-3000539.139.69
281b1412017-12-01 -> 2017-12-290264.29367.120
282b1412017-12-16 -> 2017-12-3103.14685.760
283b1422017-12-15 -> 2017-12-2900699.810
284b1422017-12-01 -> 2017-12-31046.53694.210
285b1432017-12-05 -> 2017-12-3100743.390
286b1432017-12-01 -> 2017-12-3000743.580
287b1442017-12-01 -> 2017-12-230743.7900
288b1442017-12-01 -> 2017-12-240399.4369.640
289b1452017-12-01 -> 2017-12-2100023.31
290b1452017-12-01 -> 2017-12-3000780.930
291b1462017-12-01 -> 2017-12-3000787.070
292b1462017-12-19 -> 2017-12-270789.7600
293b1472017-12-05 -> 2017-12-2200791.070
294b1472017-12-28 -> 2017-12-2900815.290
295b1482017-12-22 -> 2017-12-300020.790
296b1482017-12-01 -> 2017-12-3000020.19
297b1492017-12-01 -> 2017-12-2600020.03
298b1492017-12-01 -> 2017-12-270768.4289.310
299b1502017-12-01 -> 2017-12-300772.85126.210
300b1502017-12-22 -> 2017-12-300018.580
301b1512017-12-09 -> 2017-12-2100018.33
302b1512017-12-29 -> 2017-12-300017.540
303b1522017-12-22 -> 2017-12-300016.280
304b1522017-12-01 -> 2017-12-3000912.630
305b1532017-12-12 -> 2017-12-27389.43264.39281.80
306b1532017-12-01 -> 2017-12-2900951.010
307b1542017-12-01 -> 2017-12-30001013.890
308b1542017-12-01 -> 2017-12-27001012.948.8
309b1552017-12-06 -> 2017-12-3000015.54
310b1552017-12-01 -> 2017-12-2800871.33164.55
311b1562017-12-01 -> 2017-12-230101.15881.6862.08
312b1562017-12-01 -> 2017-12-3100014.41
313b1572017-12-12 -> 2017-12-2801171.3800
314b1572017-12-26 -> 2017-12-290013.970
315b1582017-12-01 -> 2017-12-30001170.80
316b1582017-12-28 -> 2017-12-3000013.46
317b1592017-12-04 -> 2017-12-2100013.37
318b1592017-12-22 -> 2017-12-280013.170
319b1602017-12-09 -> 2017-12-1701168.2600
320b1602017-12-11 -> 2017-12-1200012.74
321b1612017-12-01 -> 2017-12-2800011.88
322b1612017-12-08 -> 2017-12-2700011.54
323b1622017-12-22 -> 2017-12-270011.410
324b1622017-12-01 -> 2017-12-27001131.6951.23
325b1632017-12-01 -> 2017-12-30001356.930
326b1632017-12-11 -> 2017-12-2800010.93
327b1642017-12-01 -> 2017-12-2501472.2900
328b1642017-12-14 -> 2017-12-1400010.26
329b1652017-12-01 -> 2017-12-23001506.30
330b1652017-12-29 -> 2017-12-300009.72
331b1662017-12-01 -> 2017-12-30001561.10
332b1662017-12-22 -> 2017-12-29008.860
333b1672017-12-02 -> 2017-12-240875.59686.30
334b1672017-12-28 -> 2017-12-28008.550
335b1682017-12-25 -> 2017-12-280008.15
336b1682017-12-02 -> 2017-12-110008.07
337b1692017-12-06 -> 2017-12-220007.78
338b1692017-12-12 -> 2017-12-300007.78
339b1702017-12-19 -> 2017-12-260007.51
340b1702017-12-18 -> 2017-12-280007.19
341b1712017-12-06 -> 2017-12-180006.89
342b1712017-12-19 -> 2017-12-31022.161566.320
343b1722017-12-01 -> 2017-12-2901268.35391.210
344b1722017-12-01 -> 2017-12-290006.54
345b1732017-12-27 -> 2017-12-270005.92
346b1732017-12-22 -> 2017-12-30005.840
347b1742017-12-22 -> 2017-12-23005.780
348b1742017-12-04 -> 2017-12-310005.61
349b1752017-12-23 -> 2017-12-240005.33
350b1752017-12-21 -> 2017-12-220005.32
351b1762017-12-12 -> 2017-12-210005.31
352b1762017-12-01 -> 2017-12-290625.61363.140
353b1772017-12-01 -> 2017-12-300005
354b1772017-12-01 -> 2017-12-310004.89
355b1782017-12-11 -> 2017-12-290004.67
356b1782017-12-04 -> 2017-12-210004.66
357b1792017-12-07 -> 2017-12-110004.35
358b1792017-12-07 -> 2017-12-140004.35
359b1802017-12-04 -> 2017-12-070004.35
360b1802017-12-01 -> 2017-12-030004.34
361b1812017-12-01 -> 2017-12-31002071.820
362b1812017-12-30 -> 2017-12-300004.08
363b1822017-12-22 -> 2017-12-270004.07
364b1822017-12-06 -> 2017-12-240004.06
365b1832017-12-05 -> 2017-12-280004.05
366b1832017-12-27 -> 2017-12-30003.890
367b1842017-12-22 -> 2017-12-270003.76
368b1842017-12-01 -> 2017-12-010003.72
369b1852017-12-07 -> 2017-12-310003.71
370b1852017-12-30 -> 2017-12-300003.45
371b1862017-12-22 -> 2017-12-270003.45
372b1862017-12-21 -> 2017-12-210003.45
373b1872017-12-13 -> 2017-12-290003.42
374b1872017-12-29 -> 2017-12-300003.13
375b1882017-12-19 -> 2017-12-190003.12
376b1882017-12-13 -> 2017-12-240003.12
377b1892017-12-14 -> 2017-12-260003.11
378b1892017-12-01 -> 2017-12-2602103.3900
379b1902017-12-21 -> 2017-12-30019.332349.750
380b1902017-12-01 -> 2017-12-310002.81
381b1912017-12-01 -> 2017-12-080002.8
382b1912017-12-07 -> 2017-12-110002.8
383b1922017-12-01 -> 2017-12-281285.1301557.050
384b1922017-12-20 -> 2017-12-250002.51
385b1932017-12-14 -> 2017-12-250002.5
386b1932017-12-08 -> 2017-12-200002.49
387b1942017-12-11 -> 2017-12-280002.49
388b1942017-12-01 -> 2017-12-300002.48
389b1952017-12-01 -> 2017-12-240298400
390b1952017-12-15 -> 2017-12-210002.18
391b1962017-12-13 -> 2017-12-230002.18
392b1962017-12-07 -> 2017-12-110002.17
393b1972017-12-13 -> 2017-12-130002.17
394b1972017-12-01 -> 2017-12-010002.17
395b1982017-12-04 -> 2017-12-280001.96
396b1982017-12-11 -> 2017-12-130001.96
397b1992017-12-22 -> 2017-12-28001.920
398b1992017-12-16 -> 2017-12-260001.88
399b2002017-12-20 -> 2017-12-200001.88
400b2002017-12-13 -> 2017-12-270001.87
401b2012017-12-13 -> 2017-12-190001.87
402b2012017-12-04 -> 2017-12-040001.86
403b2022017-12-19 -> 2017-12-300001.57
404b2022017-12-23 -> 2017-12-310001.57
405b2032017-12-23 -> 2017-12-290001.57
406b2032017-12-02 -> 2017-12-310001.56
407b2042017-12-15 -> 2017-12-150001.56
408b2042017-12-03 -> 2017-12-260001.56
409b2052017-12-11 -> 2017-12-220001.56
410b2052017-12-26 -> 2017-12-29003550.80
411b2062017-12-29 -> 2017-12-30001.370
412b2062017-12-27 -> 2017-12-280001.25
413b2072017-12-11 -> 2017-12-190001.24
414b2072017-12-04 -> 2017-12-300001.24
415b2082017-12-11 -> 2017-12-110001.24
416b2082017-12-13 -> 2017-12-130001.24
417b2092017-12-04 -> 2017-12-130001.24
418b2092017-12-04 -> 2017-12-312505.15385.44723.580
419b2102017-12-01 -> 2017-12-312235.2419.452263.120
420b2102017-12-01 -> 2017-12-180001
421b2112017-12-15 -> 2017-12-290000.99
422b2112017-12-06 -> 2017-12-280000.99
423b2122017-12-13 -> 2017-12-130000.98
424b2122017-12-23 -> 2017-12-260000.94
425b2132017-12-18 -> 2017-12-260000.94
426b2132017-12-28 -> 2017-12-300000.94
427b2142017-12-21 -> 2017-12-210000.94
428b2142017-12-28 -> 2017-12-280000.94
429b2152017-12-14 -> 2017-12-140000.93
430b2152017-12-06 -> 2017-12-080000.93
431b2162017-12-22 -> 2017-12-28000.830
432b2162017-12-01 -> 2017-12-030000.77
433b2172017-12-04 -> 2017-12-070000.77
434b2172017-12-22 -> 2017-12-28000.650
435b2182017-12-23 -> 2017-12-230000.63
436b2182017-12-23 -> 2017-12-270000.63
437b2192017-12-26 -> 2017-12-280000.63
438b2192017-12-21 -> 2017-12-210000.63
439b2202017-12-01 -> 2017-12-260000.62
440b2202017-12-12 -> 2017-12-180000.62
441b2212017-12-15 -> 2017-12-150000.62
442b2212017-12-04 -> 2017-12-190000.62
443b2222017-12-01 -> 2017-12-210000.62
444b2222017-12-04 -> 2017-12-040000.62
445b2232017-12-04 -> 2017-12-040000.62
446b2232017-12-01 -> 2017-12-126208.44000
447b2242017-12-01 -> 2017-12-31037.676815.380
448b2242017-12-30 -> 2017-12-300000.31
449b2252017-12-23 -> 2017-12-290000.31
450b2252017-12-29 -> 2017-12-290000.31
451b2262017-12-28 -> 2017-12-300000.31
452b2262017-12-05 -> 2017-12-300000.31
453b2272017-12-17 -> 2017-12-170000.31
454b2272017-12-19 -> 2017-12-190000.31
455b2282017-12-15 -> 2017-12-170000.31
456b2282017-12-14 -> 2017-12-140000.31
457b2292017-12-14 -> 2017-12-140000.31
458b2292017-12-05 -> 2017-12-090000.31
459b2302017-12-05 -> 2017-12-050000.31
460b2302017-12-11 -> 2017-12-110000.31
461b2312017-12-06 -> 2017-12-120000.31
462b2312017-12-14 -> 2017-12-140000.31
463b2322017-12-09 -> 2017-12-090000.31
464b2322017-12-13 -> 2017-12-130000.31
465b2332017-12-03 -> 2017-12-030000.31
466b2332017-12-22 -> 2017-12-28000.290
467b2342017-12-22 -> 2017-12-22000.280
468b2342017-12-19 -> 2017-12-28000.260
469b2352017-12-01 -> 2017-12-210249.4410169.30
470b2352017-12-28 -> 2017-12-28000.040
Spoiler
 

I want help with Microsoft excel average function. Please help me with following conditions in excel.
Data is attached below.

1What is the average total USD rev/parent?
2What is the average total USD rev/parent if you exclude parents which have revenue only in D product (i.e 0 rev in other products)
3What % of revenue comes from parents whose total revenue <100 USD, 100-200 USD, 200-500 USD, >500 USD
4How many parents have revenue >100 USD in date range of Dec 1 to Dec 10

 

Data 

All rev in USD     
Child IdParent Company IDDate RangeRev from Product ARev from Product BRev from Product CRev from Product D
1b12017-12-01 -> 2017-12-0100.1900
2b12017-12-18 -> 2017-12-18000.310
3b12017-12-07 -> 2017-12-07000.460
4b22017-12-24 -> 2017-12-25001.070
5b32017-12-06 -> 2017-12-20001.180
6b32017-12-24 -> 2017-12-29001.470
1b12017-12-01 -> 2017-12-01002.180
2b12017-12-01 -> 2017-12-01002.690
3b12017-12-26 -> 2017-12-30002.970
4b22017-12-01 -> 2017-12-01002.990
5b32017-12-19 -> 2017-12-30004.270
6b32017-12-21 -> 2017-12-22005.010
7b72017-12-29 -> 2017-12-30006.820
1b12017-12-01 -> 2017-12-02006.790
1b12017-12-01 -> 2017-12-23008.650
12b82017-12-16 -> 2017-12-17008.910
17b92017-12-18 -> 2017-12-3109.7200
18b92017-12-01 -> 2017-12-01010.5200
19b102017-12-01 -> 2017-12-030011.260
20b102017-12-08 -> 2017-12-31011.3600
21b112017-12-24 -> 2017-12-270012.930
22b112017-12-07 -> 2017-12-090013.610
23b22017-12-01 -> 2017-12-040013.990
24b22017-12-22 -> 2017-12-220014.410
25b132017-12-17 -> 2017-12-210015.490
26b132017-12-13 -> 2017-12-260015.580
27b142017-12-01 -> 2017-12-300015.590
28b142017-12-01 -> 2017-12-140015.670
29b32017-12-30 -> 2017-12-3116.13000
30b32017-12-01 -> 2017-12-070016.090
31b162017-12-07 -> 2017-12-07019.0700
32b162017-12-01 -> 2017-12-030019.670
33b172017-12-04 -> 2017-12-26020.9800
34b172017-12-06 -> 2017-12-1021.42000
35b42017-12-02 -> 2017-12-0508.6713.430
36b42017-12-20 -> 2017-12-230022.660
37b192017-12-12 -> 2017-12-190022.590
38b192017-12-21 -> 2017-12-300021.551.88
39b202017-12-28 -> 2017-12-3023.49000
40b202017-12-05 -> 2017-12-120023.310
41b212017-12-28 -> 2017-12-310024.070
42b212017-12-07 -> 2017-12-160021.283.12
43b222017-12-01 -> 2017-12-020024.790
44b62017-12-21 -> 2017-12-31025.0700
45b72017-12-01 -> 2017-12-050024.830
46b232017-12-07 -> 2017-12-2200620.040
47b242017-12-04 -> 2017-12-05024.8200
48b242017-12-15 -> 2017-12-190025.520
49b252017-12-12 -> 2017-12-170025.580
50b252017-12-01 -> 2017-12-030025.930
51b262017-12-08 -> 2017-12-110026.130
52b262017-12-13 -> 2017-12-170026.450
53b272017-12-06 -> 2017-12-130026.40
54b272017-12-16 -> 2017-12-160026.820
55b282017-12-01 -> 2017-12-040026.780
56b282017-12-11 -> 2017-12-13027.8900
57b292017-12-21 -> 2017-12-260028.960
58b292017-12-01 -> 2017-12-300027.321.88
59b302017-12-10 -> 2017-12-120029.770
60b302017-12-03 -> 2017-12-090030.210
61b312017-12-07 -> 2017-12-23455.26000
62b312017-12-01 -> 2017-12-170031.020
63b322017-12-21 -> 2017-12-280032.490
64b322017-12-01 -> 2017-12-0532.9000
65b332017-12-01 -> 2017-12-030033.080
66b332017-12-07 -> 2017-12-190034.120
67b342017-12-04 -> 2017-12-300035.220
68b342017-12-01 -> 2017-12-03035.300
69b352017-12-01 -> 2017-12-150036.970
70b352017-12-12 -> 2017-12-180037.680
71b362017-12-08 -> 2017-12-120038.290
72b362017-12-16 -> 2017-12-19039.700
73b372017-12-21 -> 2017-12-300041.70
74b372017-12-01 -> 2017-12-300041.510
75b382017-12-01 -> 2017-12-090046.480
76b382017-12-27 -> 2017-12-290047.580
77b392017-12-04 -> 2017-12-280034.9213.16
78b392017-12-01 -> 2017-12-2002.5325.4120.86
79b402017-12-01 -> 2017-12-040050.250
80b402017-12-13 -> 2017-12-160050.560
81b412017-12-01 -> 2017-12-040051.460
82b412017-12-15 -> 2017-12-180053.820
83b422017-12-07 -> 2017-12-180053.750
84b422017-12-01 -> 2017-12-2303.5150.670
85b432017-12-05 -> 2017-12-200048.355.91
86b432017-12-20 -> 2017-12-300054.790
87b442017-12-01 -> 2017-12-050054.660
88b442017-12-01 -> 2017-12-090055.910
89b452017-12-07 -> 2017-12-080056.030
90b452017-12-01 -> 2017-12-070056.240
91b462017-12-05 -> 2017-12-100056.671.55
92b462017-12-20 -> 2017-12-2658.95000
93b472017-12-01 -> 2017-12-20058.8800
94b472017-12-01 -> 2017-12-080059.190
95b482017-12-28 -> 2017-12-310060.60
96b482017-12-01 -> 2017-12-070060.390
97b492017-12-01 -> 2017-12-150061.130
98b492017-12-04 -> 2017-12-300062.870
99b502017-12-04 -> 2017-12-060065.060
100b502017-12-06 -> 2017-12-280065.520
101b512017-12-01 -> 2017-12-150065.510
102b512017-12-15 -> 2017-12-270066.780
103b522017-12-01 -> 2017-12-180069.390
104b522017-12-10 -> 2017-12-260070.560
105b532017-12-01 -> 2017-12-120021.3549.68
106b532017-12-01 -> 2017-12-090071.140
107b542017-12-01 -> 2017-12-300072.490
108b542017-12-01 -> 2017-12-300073.270
109b552017-12-01 -> 2017-12-300073.530
110b552017-12-01 -> 2017-12-220075.240
111b562017-12-27 -> 2017-12-300075.770
112b562017-12-03 -> 2017-12-150075.20
113b572017-12-01 -> 2017-12-030077.820
114b572017-12-01 -> 2017-12-070078.270
115b582017-12-01 -> 2017-12-19078.500
116b582017-12-01 -> 2017-12-190079.010
117b592017-12-12 -> 2017-12-160079.330
118b592017-12-26 -> 2017-12-300080.540
119b602017-12-01 -> 2017-12-250081.060
120b602017-12-21 -> 2017-12-300083.370
121b612017-12-11 -> 2017-12-31084.8100.31
122b612017-12-29 -> 2017-12-300086.130
123b622017-12-04 -> 2017-12-170086.50
124b622017-12-01 -> 2017-12-28087.700
125b632017-12-01 -> 2017-12-31087.9300
126b632017-12-01 -> 2017-12-050089.580
127b642017-12-05 -> 2017-12-300091.980
128b642017-12-22 -> 2017-12-300097.140
129b652017-12-01 -> 2017-12-100098.350
130b652017-12-01 -> 2017-12-050098.780
131b662017-12-21 -> 2017-12-3100101.050
132b662017-12-14 -> 2017-12-16000204.03
133b672017-12-04 -> 2017-12-130096.245.28
134b672017-12-28 -> 2017-12-3174.84029.570
135b682017-12-07 -> 2017-12-200060.5344.7
136b682017-12-01 -> 2017-12-2700107.930
137b692017-12-01 -> 2017-12-2500110.990
138b692017-12-26 -> 2017-12-3000112.180
139b702017-12-09 -> 2017-12-1900113.50
140b702017-12-01 -> 2017-12-3000116.890
141b712017-12-07 -> 2017-12-31024.8391.921.87
142b712017-12-01 -> 2017-12-1600119.310
143b722017-12-11 -> 2017-12-3000120.410
144b722017-12-01 -> 2017-12-1100121.480
145b732017-12-01 -> 2017-12-3001.83121.440
146b732017-12-11 -> 2017-12-280100.61028.38
147b742017-12-01 -> 2017-12-31046.5683.410
148b742017-12-20 -> 2017-12-3000132.120
149b752017-12-01 -> 2017-12-2300132.280
150b752017-12-08 -> 2017-12-3005.41121.310.29
151b762017-12-01 -> 2017-12-1700137.460
152b762017-12-20 -> 2017-12-3000139.820
153b772017-12-01 -> 2017-12-0900138.770
154b772017-12-30 -> 2017-12-31070.5772.230
155b782017-12-01 -> 2017-12-1200143.870
156b782017-12-05 -> 2017-12-2400145.860
157b792017-12-12 -> 2017-12-3000146.530.31
158b792017-12-01 -> 2017-12-1100146.980
159b802017-12-17 -> 2017-12-3000156.590
160b802017-12-02 -> 2017-12-30049.72107.230
161b812017-12-01 -> 2017-12-2500160.80.31
162b812017-12-01 -> 2017-12-3000161.510
163b822017-12-02 -> 2017-12-1304.84157.720
164b822017-12-29 -> 2017-12-3008.29156.160
165b832017-12-01 -> 2017-12-1900164.60
166b832017-12-15 -> 2017-12-2900167.461.87
167b842017-12-01 -> 2017-12-3000169.980
168b842017-12-21 -> 2017-12-2900172.240
169b852017-12-01 -> 2017-12-11170.76000
170b852017-12-01 -> 2017-12-21139.34038.460
171b862017-12-01 -> 2017-12-2500177.510
172b862017-12-10 -> 2017-12-1900179.610
173b872017-12-19 -> 2017-12-3103.5178.50
174b872017-12-27 -> 2017-12-30097.2590.620
175b882017-12-01 -> 2017-12-3100187.10
176b882017-12-01 -> 2017-12-310192.9600
177b892017-12-01 -> 2017-12-3100179.8913.08
178b892017-12-04 -> 2017-12-070192.4500
179b902017-12-01 -> 2017-12-1500192.590
180b902017-12-01 -> 2017-12-2900200.830
181b912017-12-01 -> 2017-12-2700210.430
182b912017-12-13 -> 2017-12-3000212.940
183b922017-12-15 -> 2017-12-2500214.480
184b922017-12-01 -> 2017-12-080065.89152.68
185b932017-12-18 -> 2017-12-3000231.980
186b932017-12-06 -> 2017-12-2989.710142.310
187b942017-12-11 -> 2017-12-2900236.690
188b942017-12-01 -> 2017-12-1100238.180
189b952017-12-15 -> 2017-12-2700243.220
190b952017-12-01 -> 2017-12-3000243.020
191b962017-12-01 -> 2017-12-3100245.750
192b962017-12-01 -> 2017-12-18246.13000
193b972017-12-12 -> 2017-12-3000248.850
194b972017-12-01 -> 2017-12-070252.2100
195b982017-12-16 -> 2017-12-3000264.760
196b982017-12-01 -> 2017-12-2300266.30
197b992017-12-01 -> 2017-12-2900269.460
198b992017-12-01 -> 2017-12-1800270.020
199b1002017-12-01 -> 2017-12-30095.01177.660
200b1002017-12-15 -> 2017-12-2100271.291.88
201b1012017-12-01 -> 2017-12-2000277.780
202b1012017-12-01 -> 2017-12-2200279.470
203b1022017-12-20 -> 2017-12-2500075.18
204b1022017-12-01 -> 2017-12-300127.97153.830
205b1032017-12-01 -> 2017-12-1100282.80
206b1032017-12-06 -> 2017-12-2300285.460
207b1042017-12-10 -> 2017-12-3000291.490
208b1042017-12-21 -> 2017-12-2700285.279.19
209b1052017-12-13 -> 2017-12-3000302.520
210b1052017-12-01 -> 2017-12-1700305.730
211b1062017-12-23 -> 2017-12-300052.3914.76
212b1062017-12-23 -> 2017-12-2701.75310.110
213b1072017-12-18 -> 2017-12-2700311.40
214b1072017-12-18 -> 2017-12-2700311.320
215b1082017-12-22 -> 2017-12-280065.130
216b1082017-12-11 -> 2017-12-2700310.360
217b1092017-12-05 -> 2017-12-2700064.13
218b1092017-12-13 -> 2017-12-2700310.330
219b1102017-12-22 -> 2017-12-290062.340
220b1102017-12-07 -> 2017-12-2700310.010
221b1102017-12-12 -> 2017-12-2508.27301.720
222b1102017-12-19 -> 2017-12-2900312.990
223b1102017-12-13 -> 2017-12-3000312.480
224b1102017-12-07 -> 2017-12-19010.44300.810
225b1102017-12-11 -> 2017-12-2900312.250
226b1102017-12-01 -> 2017-12-2200290.7528.19
227b1102017-12-05 -> 2017-12-2800057.98
228b1102017-12-01 -> 2017-12-3000328.670
229b1102017-12-01 -> 2017-12-2900331.340.31
230b1152017-12-01 -> 2017-12-13330.83000
231b1162017-12-01 -> 2017-12-1700334.370
232b1162017-12-05 -> 2017-12-3000339.490
233b1172017-12-01 -> 2017-12-2100341.890
234b1172017-12-01 -> 2017-12-31342.5000
235b1182017-12-01 -> 2017-12-1500349.60
236b1182017-12-01 -> 2017-12-2600350.660
237b1192017-12-01 -> 2017-12-1800355.260
238b1192017-12-22 -> 2017-12-290051.190
239b1202017-12-01 -> 2017-12-3100359.320
240b1202017-12-01 -> 2017-12-3100360.110.31
241b1212017-12-01 -> 2017-12-23362.68000
242b1212017-12-01 -> 2017-12-110373.2100
243b1222017-12-06 -> 2017-12-170379.2800
244b1222017-12-07 -> 2017-12-090047.310
245b1232017-12-15 -> 2017-12-2700384.190
246b1232017-12-01 -> 2017-12-310383.2700
247b1242017-12-01 -> 2017-12-310216169.810
248b1242017-12-07 -> 2017-12-2900041.3
249b1252017-12-22 -> 2017-12-280039.740
250b1252017-12-01 -> 2017-12-160386.1100
251b1262017-12-22 -> 2017-12-270039.560
252b1262017-12-20 -> 2017-12-2600389.360
253b1272017-12-01 -> 2017-12-270172.79240.490
254b1272017-12-01 -> 2017-12-31302.8815.6499.260
255b1282017-12-22 -> 2017-12-290036.420
256b1282017-12-22 -> 2017-12-300035.990
257b1292017-12-01 -> 2017-12-270418.2400
258b1292017-12-22 -> 2017-12-3100422.780
259b1302017-12-01 -> 2017-12-2700420.820
260b1302017-12-01 -> 2017-12-140193.11115.78119.33
261b1312017-12-01 -> 2017-12-3000430.70
262b1312017-12-01 -> 2017-12-2900451.880
263b1322017-12-01 -> 2017-12-1600451.480
264b1322017-12-01 -> 2017-12-28088.88374.380
265b1332017-12-01 -> 2017-12-150462.4600
266b1332017-12-01 -> 2017-12-2500463.910
267b1342017-12-14 -> 2017-12-1900028.99
268b1342017-12-24 -> 2017-12-2700470.190
269b1352017-12-12 -> 2017-12-3100469.010
270b1352017-12-05 -> 2017-12-2996.05336.9334.970
271b1362017-12-06 -> 2017-12-2600026.8
272b1362017-12-05 -> 2017-12-2800468.290
273b1372017-12-07 -> 2017-12-27034.98433.830
274b1372017-12-09 -> 2017-12-31386.84096.270
275b1382017-12-01 -> 2017-12-3000485.570
276b1382017-12-19 -> 2017-12-3000026
277b1392017-12-01 -> 2017-12-2900511.510
278b1392017-12-01 -> 2017-12-300105.97408.640.99
279b1402017-12-14 -> 2017-12-280509.5233.470
280b1402017-12-01 -> 2017-12-3000539.139.69
281b1412017-12-01 -> 2017-12-290264.29367.120
282b1412017-12-16 -> 2017-12-3103.14685.760
283b1422017-12-15 -> 2017-12-2900699.810
284b1422017-12-01 -> 2017-12-31046.53694.210
285b1432017-12-05 -> 2017-12-3100743.390
286b1432017-12-01 -> 2017-12-3000743.580
287b1442017-12-01 -> 2017-12-230743.7900
288b1442017-12-01 -> 2017-12-240399.4369.640
289b1452017-12-01 -> 2017-12-2100023.31
290b1452017-12-01 -> 2017-12-3000780.930
291b1462017-12-01 -> 2017-12-3000787.070
292b1462017-12-19 -> 2017-12-270789.7600
293b1472017-12-05 -> 2017-12-2200791.070
294b1472017-12-28 -> 2017-12-2900815.290
295b1482017-12-22 -> 2017-12-300020.790
296b1482017-12-01 -> 2017-12-3000020.19
297b1492017-12-01 -> 2017-12-2600020.03
298b1492017-12-01 -> 2017-12-270768.4289.310
299b1502017-12-01 -> 2017-12-300772.85126.210
300b1502017-12-22 -> 2017-12-300018.580
301b1512017-12-09 -> 2017-12-2100018.33
302b1512017-12-29 -> 2017-12-300017.540
303b1522017-12-22 -> 2017-12-300016.280
304b1522017-12-01 -> 2017-12-3000912.630
305b1532017-12-12 -> 2017-12-27389.43264.39281.80
306b1532017-12-01 -> 2017-12-2900951.010
307b1542017-12-01 -> 2017-12-30001013.890
308b1542017-12-01 -> 2017-12-27001012.948.8
309b1552017-12-06 -> 2017-12-3000015.54
310b1552017-12-01 -> 2017-12-2800871.33164.55
311b1562017-12-01 -> 2017-12-230101.15881.6862.08
312b1562017-12-01 -> 2017-12-3100014.41
313b1572017-12-12 -> 2017-12-2801171.3800
314b1572017-12-26 -> 2017-12-290013.970
315b1582017-12-01 -> 2017-12-30001170.80
316b1582017-12-28 -> 2017-12-3000013.46
317b1592017-12-04 -> 2017-12-2100013.37
318b1592017-12-22 -> 2017-12-280013.170
319b1602017-12-09 -> 2017-12-1701168.2600
320b1602017-12-11 -> 2017-12-1200012.74
321b1612017-12-01 -> 2017-12-2800011.88
322b1612017-12-08 -> 2017-12-2700011.54
323b1622017-12-22 -> 2017-12-270011.410
324b1622017-12-01 -> 2017-12-27001131.6951.23
325b1632017-12-01 -> 2017-12-30001356.930
326b1632017-12-11 -> 2017-12-2800010.93
327b1642017-12-01 -> 2017-12-2501472.2900
328b1642017-12-14 -> 2017-12-1400010.26
329b1652017-12-01 -> 2017-12-23001506.30
330b1652017-12-29 -> 2017-12-300009.72
331b1662017-12-01 -> 2017-12-30001561.10
332b1662017-12-22 -> 2017-12-29008.860
333b1672017-12-02 -> 2017-12-240875.59686.30
334b1672017-12-28 -> 2017-12-28008.550
335b1682017-12-25 -> 2017-12-280008.15
336b1682017-12-02 -> 2017-12-110008.07
337b1692017-12-06 -> 2017-12-220007.78
338b1692017-12-12 -> 2017-12-300007.78
339b1702017-12-19 -> 2017-12-260007.51
340b1702017-12-18 -> 2017-12-280007.19
341b1712017-12-06 -> 2017-12-180006.89
342b1712017-12-19 -> 2017-12-31022.161566.320
343b1722017-12-01 -> 2017-12-2901268.35391.210
344b1722017-12-01 -> 2017-12-290006.54
345b1732017-12-27 -> 2017-12-270005.92
346b1732017-12-22 -> 2017-12-30005.840
347b1742017-12-22 -> 2017-12-23005.780
348b1742017-12-04 -> 2017-12-310005.61
349b1752017-12-23 -> 2017-12-240005.33
350b1752017-12-21 -> 2017-12-220005.32
351b1762017-12-12 -> 2017-12-210005.31
352b1762017-12-01 -> 2017-12-290625.61363.140
353b1772017-12-01 -> 2017-12-300005
354b1772017-12-01 -> 2017-12-310004.89
355b1782017-12-11 -> 2017-12-290004.67
356b1782017-12-04 -> 2017-12-210004.66
357b1792017-12-07 -> 2017-12-110004.35
358b1792017-12-07 -> 2017-12-140004.35
359b1802017-12-04 -> 2017-12-070004.35
360b1802017-12-01 -> 2017-12-030004.34
361b1812017-12-01 -> 2017-12-31002071.820
362b1812017-12-30 -> 2017-12-300004.08
363b1822017-12-22 -> 2017-12-270004.07
364b1822017-12-06 -> 2017-12-240004.06
365b1832017-12-05 -> 2017-12-280004.05
366b1832017-12-27 -> 2017-12-30003.890
367b1842017-12-22 -> 2017-12-270003.76
368b1842017-12-01 -> 2017-12-010003.72
369b1852017-12-07 -> 2017-12-310003.71
370b1852017-12-30 -> 2017-12-300003.45
371b1862017-12-22 -> 2017-12-270003.45
372b1862017-12-21 -> 2017-12-210003.45
373b1872017-12-13 -> 2017-12-290003.42
374b1872017-12-29 -> 2017-12-300003.13
375b1882017-12-19 -> 2017-12-190003.12
376b1882017-12-13 -> 2017-12-240003.12
377b1892017-12-14 -> 2017-12-260003.11
378b1892017-12-01 -> 2017-12-2602103.3900
379b1902017-12-21 -> 2017-12-30019.332349.750
380b1902017-12-01 -> 2017-12-310002.81
381b1912017-12-01 -> 2017-12-080002.8
382b1912017-12-07 -> 2017-12-110002.8
383b1922017-12-01 -> 2017-12-281285.1301557.050
384b1922017-12-20 -> 2017-12-250002.51
385b1932017-12-14 -> 2017-12-250002.5
386b1932017-12-08 -> 2017-12-200002.49
387b1942017-12-11 -> 2017-12-280002.49
388b1942017-12-01 -> 2017-12-300002.48
389b1952017-12-01 -> 2017-12-240298400
390b1952017-12-15 -> 2017-12-210002.18
391b1962017-12-13 -> 2017-12-230002.18
392b1962017-12-07 -> 2017-12-110002.17
393b1972017-12-13 -> 2017-12-130002.17
394b1972017-12-01 -> 2017-12-010002.17
395b1982017-12-04 -> 2017-12-280001.96
396b1982017-12-11 -> 2017-12-130001.96
397b1992017-12-22 -> 2017-12-28001.920
398b1992017-12-16 -> 2017-12-260001.88
399b2002017-12-20 -> 2017-12-200001.88
400b2002017-12-13 -> 2017-12-270001.87
401b2012017-12-13 -> 2017-12-190001.87
402b2012017-12-04 -> 2017-12-040001.86
403b2022017-12-19 -> 2017-12-300001.57
404b2022017-12-23 -> 2017-12-310001.57
405b2032017-12-23 -> 2017-12-290001.57
406b2032017-12-02 -> 2017-12-310001.56
407b2042017-12-15 -> 2017-12-150001.56
408b2042017-12-03 -> 2017-12-260001.56
409b2052017-12-11 -> 2017-12-220001.56
410b2052017-12-26 -> 2017-12-29003550.80
411b2062017-12-29 -> 2017-12-30001.370
412b2062017-12-27 -> 2017-12-280001.25
413b2072017-12-11 -> 2017-12-190001.24
414b2072017-12-04 -> 2017-12-300001.24
415b2082017-12-11 -> 2017-12-110001.24
416b2082017-12-13 -> 2017-12-130001.24
417b2092017-12-04 -> 2017-12-130001.24
418b2092017-12-04 -> 2017-12-312505.15385.44723.580
419b2102017-12-01 -> 2017-12-312235.2419.452263.120
420b2102017-12-01 -> 2017-12-180001
421b2112017-12-15 -> 2017-12-290000.99
422b2112017-12-06 -> 2017-12-280000.99
423b2122017-12-13 -> 2017-12-130000.98
424b2122017-12-23 -> 2017-12-260000.94
425b2132017-12-18 -> 2017-12-260000.94
426b2132017-12-28 -> 2017-12-300000.94
427b2142017-12-21 -> 2017-12-210000.94
428b2142017-12-28 -> 2017-12-280000.94
429b2152017-12-14 -> 2017-12-140000.93
430b2152017-12-06 -> 2017-12-080000.93
431b2162017-12-22 -> 2017-12-28000.830
432b2162017-12-01 -> 2017-12-030000.77
433b2172017-12-04 -> 2017-12-070000.77
434b2172017-12-22 -> 2017-12-28000.650
435b2182017-12-23 -> 2017-12-230000.63
436b2182017-12-23 -> 2017-12-270000.63
437b2192017-12-26 -> 2017-12-280000.63
438b2192017-12-21 -> 2017-12-210000.63
439b2202017-12-01 -> 2017-12-260000.62
440b2202017-12-12 -> 2017-12-180000.62
441b2212017-12-15 -> 2017-12-150000.62
442b2212017-12-04 -> 2017-12-190000.62
443b2222017-12-01 -> 2017-12-210000.62
444b2222017-12-04 -> 2017-12-040000.62
445b2232017-12-04 -> 2017-12-040000.62
446b2232017-12-01 -> 2017-12-126208.44000
447b2242017-12-01 -> 2017-12-31037.676815.380
448b2242017-12-30 -> 2017-12-300000.31
449b2252017-12-23 -> 2017-12-290000.31
450b2252017-12-29 -> 2017-12-290000.31
451b2262017-12-28 -> 2017-12-300000.31
452b2262017-12-05 -> 2017-12-300000.31
453b2272017-12-17 -> 2017-12-170000.31
454b2272017-12-19 -> 2017-12-190000.31
455b2282017-12-15 -> 2017-12-170000.31
456b2282017-12-14 -> 2017-12-140000.31
457b2292017-12-14 -> 2017-12-140000.31
458b2292017-12-05 -> 2017-12-090000.31
459b2302017-12-05 -> 2017-12-050000.31
460b2302017-12-11 -> 2017-12-110000.31
461b2312017-12-06 -> 2017-12-120000.31
462b2312017-12-14 -> 2017-12-140000.31
463b2322017-12-09 -> 2017-12-090000.31
464b2322017-12-13 -> 2017-12-130000.31
465b2332017-12-03 -> 2017-12-030000.31
466b2332017-12-22 -> 2017-12-28000.290
467b2342017-12-22 -> 2017-12-22000.280
468b2342017-12-19 -> 2017-12-28000.260
469b2352017-12-01 -> 2017-12-210249.4410169.30
470b2352017-12-28 -> 2017-12-28000.040

Resources

"}},"componentScriptGroups({\"componentId\":\"custom.widget.MicrosoftFooter\"})":{"__typename":"ComponentScriptGroups","scriptGroups":{"__typename":"ComponentScriptGroupsDefinition","afterInteractive":{"__typename":"PageScriptGroupDefinition","group":"AFTER_INTERACTIVE","scriptIds":[]},"lazyOnLoad":{"__typename":"PageScriptGroupDefinition","group":"LAZY_ON_LOAD","scriptIds":[]}},"componentScripts":[]},"cachedText({\"lastModified\":\"1745505309787\",\"locale\":\"en-US\",\"namespaces\":[\"components/community/NavbarDropdownToggle\"]})":[{"__ref":"CachedAsset:text:en_US-components/community/NavbarDropdownToggle-1745505309787"}],"cachedText({\"lastModified\":\"1745505309787\",\"locale\":\"en-US\",\"namespaces\":[\"shared/client/components/common/QueryHandler\"]})":[{"__ref":"CachedAsset:text:en_US-shared/client/components/common/QueryHandler-1745505309787"}],"cachedText({\"lastModified\":\"1745505309787\",\"locale\":\"en-US\",\"namespaces\":[\"components/messages/EscalatedMessageBanner\"]})":[{"__ref":"CachedAsset:text:en_US-components/messages/EscalatedMessageBanner-1745505309787"}],"cachedText({\"lastModified\":\"1745505309787\",\"locale\":\"en-US\",\"namespaces\":[\"components/users/UserLink\"]})":[{"__ref":"CachedAsset:text:en_US-components/users/UserLink-1745505309787"}],"cachedText({\"lastModified\":\"1745505309787\",\"locale\":\"en-US\",\"namespaces\":[\"shared/client/components/users/UserRank\"]})":[{"__ref":"CachedAsset:text:en_US-shared/client/components/users/UserRank-1745505309787"}],"cachedText({\"lastModified\":\"1745505309787\",\"locale\":\"en-US\",\"namespaces\":[\"components/messages/MessageTime\"]})":[{"__ref":"CachedAsset:text:en_US-components/messages/MessageTime-1745505309787"}],"cachedText({\"lastModified\":\"1745505309787\",\"locale\":\"en-US\",\"namespaces\":[\"components/messages/MessageSolvedBadge\"]})":[{"__ref":"CachedAsset:text:en_US-components/messages/MessageSolvedBadge-1745505309787"}],"cachedText({\"lastModified\":\"1745505309787\",\"locale\":\"en-US\",\"namespaces\":[\"components/messages/MessageSubject\"]})":[{"__ref":"CachedAsset:text:en_US-components/messages/MessageSubject-1745505309787"}],"cachedText({\"lastModified\":\"1745505309787\",\"locale\":\"en-US\",\"namespaces\":[\"components/messages/MessageBody\"]})":[{"__ref":"CachedAsset:text:en_US-components/messages/MessageBody-1745505309787"}],"cachedText({\"lastModified\":\"1745505309787\",\"locale\":\"en-US\",\"namespaces\":[\"components/messages/MessageCustomFields\"]})":[{"__ref":"CachedAsset:text:en_US-components/messages/MessageCustomFields-1745505309787"}],"cachedText({\"lastModified\":\"1745505309787\",\"locale\":\"en-US\",\"namespaces\":[\"components/messages/MessageReplyButton\"]})":[{"__ref":"CachedAsset:text:en_US-components/messages/MessageReplyButton-1745505309787"}],"cachedText({\"lastModified\":\"1745505309787\",\"locale\":\"en-US\",\"namespaces\":[\"shared/client/components/users/UserAvatar\"]})":[{"__ref":"CachedAsset:text:en_US-shared/client/components/users/UserAvatar-1745505309787"}],"cachedText({\"lastModified\":\"1745505309787\",\"locale\":\"en-US\",\"namespaces\":[\"shared/client/components/ranks/UserRankLabel\"]})":[{"__ref":"CachedAsset:text:en_US-shared/client/components/ranks/UserRankLabel-1745505309787"}],"cachedText({\"lastModified\":\"1745505309787\",\"locale\":\"en-US\",\"namespaces\":[\"components/messages/AcceptedSolutionButton\"]})":[{"__ref":"CachedAsset:text:en_US-components/messages/AcceptedSolutionButton-1745505309787"}],"message({\"id\":\"message:2060297\"})":{"__ref":"ForumReplyMessage:message:2060297"},"cachedText({\"lastModified\":\"1745505309787\",\"locale\":\"en-US\",\"namespaces\":[\"components/tags/TagView/TagViewChip\"]})":[{"__ref":"CachedAsset:text:en_US-components/tags/TagView/TagViewChip-1745505309787"}]},"CachedAsset:pages-1745485687373":{"__typename":"CachedAsset","id":"pages-1745485687373","value":[{"lastUpdatedTime":1745485687373,"localOverride":null,"page":{"id":"BlogViewAllPostsPage","type":"BLOG","urlPath":"/category/:categoryId/blog/:boardId/all-posts/(/:after|/:before)?","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745485687373,"localOverride":null,"page":{"id":"CasePortalPage","type":"CASE_PORTAL","urlPath":"/caseportal","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745485687373,"localOverride":null,"page":{"id":"CreateGroupHubPage","type":"GROUP_HUB","urlPath":"/groups/create","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745485687373,"localOverride":null,"page":{"id":"CaseViewPage","type":"CASE_DETAILS","urlPath":"/case/:caseId/:caseNumber","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745485687373,"localOverride":null,"page":{"id":"InboxPage","type":"COMMUNITY","urlPath":"/inbox","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745485687373,"localOverride":null,"page":{"id":"HelpFAQPage","type":"COMMUNITY","urlPath":"/help","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745485687373,"localOverride":null,"page":{"id":"IdeaMessagePage","type":"IDEA_POST","urlPath":"/idea/:boardId/:messageSubject/:messageId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745485687373,"localOverride":null,"page":{"id":"IdeaViewAllIdeasPage","type":"IDEA","urlPath":"/category/:categoryId/ideas/:boardId/all-ideas/(/:after|/:before)?","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745485687373,"localOverride":null,"page":{"id":"LoginPage","type":"USER","urlPath":"/signin","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745485687373,"localOverride":null,"page":{"id":"BlogPostPage","type":"BLOG","urlPath":"/category/:categoryId/blogs/:boardId/create","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745485687373,"localOverride":null,"page":{"id":"UserBlogPermissions.Page","type":"COMMUNITY","urlPath":"/c/user-blog-permissions/page","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745485687373,"localOverride":null,"page":{"id":"ThemeEditorPage","type":"COMMUNITY","urlPath":"/designer/themes","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745485687373,"localOverride":null,"page":{"id":"TkbViewAllArticlesPage","type":"TKB","urlPath":"/category/:categoryId/kb/:boardId/all-articles/(/:after|/:before)?","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1730819800000,"localOverride":null,"page":{"id":"AllEvents","type":"CUSTOM","urlPath":"/Events","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745485687373,"localOverride":null,"page":{"id":"OccasionEditPage","type":"EVENT","urlPath":"/event/:boardId/:messageSubject/:messageId/edit","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745485687373,"localOverride":null,"page":{"id":"OAuthAuthorizationAllowPage","type":"USER","urlPath":"/auth/authorize/allow","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745485687373,"localOverride":null,"page":{"id":"PageEditorPage","type":"COMMUNITY","urlPath":"/designer/pages","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745485687373,"localOverride":null,"page":{"id":"PostPage","type":"COMMUNITY","urlPath":"/category/:categoryId/:boardId/create","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745485687373,"localOverride":null,"page":{"id":"ForumBoardPage","type":"FORUM","urlPath":"/category/:categoryId/discussions/:boardId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745485687373,"localOverride":null,"page":{"id":"TkbBoardPage","type":"TKB","urlPath":"/category/:categoryId/kb/:boardId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745485687373,"localOverride":null,"page":{"id":"EventPostPage","type":"EVENT","urlPath":"/category/:categoryId/events/:boardId/create","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745485687373,"localOverride":null,"page":{"id":"UserBadgesPage","type":"COMMUNITY","urlPath":"/users/:login/:userId/badges","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745485687373,"localOverride":null,"page":{"id":"GroupHubMembershipAction","type":"GROUP_HUB","urlPath":"/membership/join/:nodeId/:membershipType","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745485687373,"localOverride":null,"page":{"id":"MaintenancePage","type":"COMMUNITY","urlPath":"/maintenance","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745485687373,"localOverride":null,"page":{"id":"IdeaReplyPage","type":"IDEA_REPLY","urlPath":"/idea/:boardId/:messageSubject/:messageId/comments/:replyId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745485687373,"localOverride":null,"page":{"id":"UserSettingsPage","type":"USER","urlPath":"/mysettings/:userSettingsTab","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745485687373,"localOverride":null,"page":{"id":"GroupHubsPage","type":"GROUP_HUB","urlPath":"/groups","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745485687373,"localOverride":null,"page":{"id":"ForumPostPage","type":"FORUM","urlPath":"/category/:categoryId/discussions/:boardId/create","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745485687373,"localOverride":null,"page":{"id":"OccasionRsvpActionPage","type":"OCCASION","urlPath":"/event/:boardId/:messageSubject/:messageId/rsvp/:responseType","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745485687373,"localOverride":null,"page":{"id":"VerifyUserEmailPage","type":"USER","urlPath":"/verifyemail/:userId/:verifyEmailToken","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745485687373,"localOverride":null,"page":{"id":"AllOccasionsPage","type":"OCCASION","urlPath":"/category/:categoryId/events/:boardId/all-events/(/:after|/:before)?","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745485687373,"localOverride":null,"page":{"id":"EventBoardPage","type":"EVENT","urlPath":"/category/:categoryId/events/:boardId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745485687373,"localOverride":null,"page":{"id":"TkbReplyPage","type":"TKB_REPLY","urlPath":"/kb/:boardId/:messageSubject/:messageId/comments/:replyId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745485687373,"localOverride":null,"page":{"id":"IdeaBoardPage","type":"IDEA","urlPath":"/category/:categoryId/ideas/:boardId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745485687373,"localOverride":null,"page":{"id":"CommunityGuideLinesPage","type":"COMMUNITY","urlPath":"/communityguidelines","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745485687373,"localOverride":null,"page":{"id":"CaseCreatePage","type":"SALESFORCE_CASE_CREATION","urlPath":"/caseportal/create","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745485687373,"localOverride":null,"page":{"id":"TkbEditPage","type":"TKB","urlPath":"/kb/:boardId/:messageSubject/:messageId/edit","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745485687373,"localOverride":null,"page":{"id":"ForgotPasswordPage","type":"USER","urlPath":"/forgotpassword","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745485687373,"localOverride":null,"page":{"id":"IdeaEditPage","type":"IDEA","urlPath":"/idea/:boardId/:messageSubject/:messageId/edit","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745485687373,"localOverride":null,"page":{"id":"TagPage","type":"COMMUNITY","urlPath":"/tag/:tagName","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745485687373,"localOverride":null,"page":{"id":"BlogBoardPage","type":"BLOG","urlPath":"/category/:categoryId/blog/:boardId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745485687373,"localOverride":null,"page":{"id":"OccasionMessagePage","type":"OCCASION_TOPIC","urlPath":"/event/:boardId/:messageSubject/:messageId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745485687373,"localOverride":null,"page":{"id":"ManageContentPage","type":"COMMUNITY","urlPath":"/managecontent","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745485687373,"localOverride":null,"page":{"id":"ClosedMembershipNodeNonMembersPage","type":"GROUP_HUB","urlPath":"/closedgroup/:groupHubId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745485687373,"localOverride":null,"page":{"id":"CommunityPage","type":"COMMUNITY","urlPath":"/","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745485687373,"localOverride":null,"page":{"id":"ForumMessagePage","type":"FORUM_TOPIC","urlPath":"/discussions/:boardId/:messageSubject/:messageId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745485687373,"localOverride":null,"page":{"id":"IdeaPostPage","type":"IDEA","urlPath":"/category/:categoryId/ideas/:boardId/create","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1730819800000,"localOverride":null,"page":{"id":"CommunityHub.Page","type":"CUSTOM","urlPath":"/Directory","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745485687373,"localOverride":null,"page":{"id":"BlogMessagePage","type":"BLOG_ARTICLE","urlPath":"/blog/:boardId/:messageSubject/:messageId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745485687373,"localOverride":null,"page":{"id":"RegistrationPage","type":"USER","urlPath":"/register","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745485687373,"localOverride":null,"page":{"id":"EditGroupHubPage","type":"GROUP_HUB","urlPath":"/group/:groupHubId/edit","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745485687373,"localOverride":null,"page":{"id":"ForumEditPage","type":"FORUM","urlPath":"/discussions/:boardId/:messageSubject/:messageId/edit","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745485687373,"localOverride":null,"page":{"id":"ResetPasswordPage","type":"USER","urlPath":"/resetpassword/:userId/:resetPasswordToken","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1730819800000,"localOverride":null,"page":{"id":"AllBlogs.Page","type":"CUSTOM","urlPath":"/blogs","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745485687373,"localOverride":null,"page":{"id":"TkbMessagePage","type":"TKB_ARTICLE","urlPath":"/kb/:boardId/:messageSubject/:messageId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745485687373,"localOverride":null,"page":{"id":"BlogEditPage","type":"BLOG","urlPath":"/blog/:boardId/:messageSubject/:messageId/edit","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745485687373,"localOverride":null,"page":{"id":"ManageUsersPage","type":"USER","urlPath":"/users/manage/:tab?/:manageUsersTab?","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745485687373,"localOverride":null,"page":{"id":"ForumReplyPage","type":"FORUM_REPLY","urlPath":"/discussions/:boardId/:messageSubject/:messageId/replies/:replyId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745485687373,"localOverride":null,"page":{"id":"PrivacyPolicyPage","type":"COMMUNITY","urlPath":"/privacypolicy","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745485687373,"localOverride":null,"page":{"id":"NotificationPage","type":"COMMUNITY","urlPath":"/notifications","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745485687373,"localOverride":null,"page":{"id":"UserPage","type":"USER","urlPath":"/users/:login/:userId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745485687373,"localOverride":null,"page":{"id":"OccasionReplyPage","type":"OCCASION_REPLY","urlPath":"/event/:boardId/:messageSubject/:messageId/comments/:replyId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745485687373,"localOverride":null,"page":{"id":"ManageMembersPage","type":"GROUP_HUB","urlPath":"/group/:groupHubId/manage/:tab?","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745485687373,"localOverride":null,"page":{"id":"SearchResultsPage","type":"COMMUNITY","urlPath":"/search","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745485687373,"localOverride":null,"page":{"id":"BlogReplyPage","type":"BLOG_REPLY","urlPath":"/blog/:boardId/:messageSubject/:messageId/replies/:replyId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745485687373,"localOverride":null,"page":{"id":"GroupHubPage","type":"GROUP_HUB","urlPath":"/group/:groupHubId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745485687373,"localOverride":null,"page":{"id":"TermsOfServicePage","type":"COMMUNITY","urlPath":"/termsofservice","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745485687373,"localOverride":null,"page":{"id":"CategoryPage","type":"CATEGORY","urlPath":"/category/:categoryId","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745485687373,"localOverride":null,"page":{"id":"ForumViewAllTopicsPage","type":"FORUM","urlPath":"/category/:categoryId/discussions/:boardId/all-topics/(/:after|/:before)?","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745485687373,"localOverride":null,"page":{"id":"TkbPostPage","type":"TKB","urlPath":"/category/:categoryId/kbs/:boardId/create","__typename":"PageDescriptor"},"__typename":"PageResource"},{"lastUpdatedTime":1745485687373,"localOverride":null,"page":{"id":"GroupHubPostPage","type":"GROUP_HUB","urlPath":"/group/:groupHubId/:boardId/create","__typename":"PageDescriptor"},"__typename":"PageResource"}],"localOverride":false},"CachedAsset:text:en_US-components/context/AppContext/AppContextProvider-0":{"__typename":"CachedAsset","id":"text:en_US-components/context/AppContext/AppContextProvider-0","value":{"noCommunity":"Cannot find community","noUser":"Cannot find current user","noNode":"Cannot find node with id {nodeId}","noMessage":"Cannot find message with id {messageId}"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/common/Loading/LoadingDot-0":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/common/Loading/LoadingDot-0","value":{"title":"Loading..."},"localOverride":false},"User:user:-1":{"__typename":"User","id":"user:-1","uid":-1,"login":"Deleted","email":"","avatar":null,"rank":null,"kudosWeight":1,"registrationData":{"__typename":"RegistrationData","status":"ANONYMOUS","registrationTime":null,"confirmEmailStatus":false,"registrationAccessLevel":"VIEW","ssoRegistrationFields":[]},"ssoId":null,"profileSettings":{"__typename":"ProfileSettings","dateDisplayStyle":{"__typename":"InheritableStringSettingWithPossibleValues","key":"layout.friendly_dates_enabled","value":"false","localValue":"true","possibleValues":["true","false"]},"dateDisplayFormat":{"__typename":"InheritableStringSetting","key":"layout.format_pattern_date","value":"MMM dd yyyy","localValue":"MM-dd-yyyy"},"language":{"__typename":"InheritableStringSettingWithPossibleValues","key":"profile.language","value":"en-US","localValue":"en","possibleValues":["en-US"]}},"deleted":false},"Theme:customTheme1":{"__typename":"Theme","id":"customTheme1"},"Category:category:microsoft365":{"__typename":"Category","id":"category:microsoft365","entityType":"CATEGORY","displayId":"microsoft365","nodeType":"category","depth":3,"title":"Microsoft 365","shortTitle":"Microsoft 365","parent":{"__ref":"Category:category:products-services"},"categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:top":{"__typename":"Category","id":"category:top","displayId":"top","nodeType":"category","depth":0,"title":"Top","entityType":"CATEGORY","shortTitle":"Top"},"Category:category:communities":{"__typename":"Category","id":"category:communities","displayId":"communities","nodeType":"category","depth":1,"parent":{"__ref":"Category:category:top"},"title":"Communities","entityType":"CATEGORY","shortTitle":"Communities"},"Category:category:products-services":{"__typename":"Category","id":"category:products-services","displayId":"products-services","nodeType":"category","depth":2,"parent":{"__ref":"Category:category:communities"},"title":"Products","entityType":"CATEGORY","shortTitle":"Products"},"Forum:board:ExcelGeneral":{"__typename":"Forum","id":"board:ExcelGeneral","entityType":"FORUM","displayId":"ExcelGeneral","nodeType":"board","depth":4,"conversationStyle":"FORUM","title":"Excel","description":"Your community for how-to discussions and sharing best practices on Microsoft Excel. If you’re looking for technical support, please visit Microsoft Support Community.","avatar":null,"profileSettings":{"__typename":"ProfileSettings","language":null},"parent":{"__ref":"Category:category:microsoft365"},"ancestors":{"__typename":"CoreNodeConnection","edges":[{"__typename":"CoreNodeEdge","node":{"__ref":"Community:community:gxcuf89792"}},{"__typename":"CoreNodeEdge","node":{"__ref":"Category:category:communities"}},{"__typename":"CoreNodeEdge","node":{"__ref":"Category:category:products-services"}},{"__typename":"CoreNodeEdge","node":{"__ref":"Category:category:microsoft365"}}]},"userContext":{"__typename":"NodeUserContext","canAddAttachments":false,"canUpdateNode":false,"canPostMessages":false,"isSubscribed":false},"boardPolicies":{"__typename":"BoardPolicies","canPublishArticleOnCreate":{"__typename":"PolicyResult","failureReason":{"__typename":"FailureReason","message":"error.lithium.policies.forums.policy_can_publish_on_create_workflow_action.accessDenied","key":"error.lithium.policies.forums.policy_can_publish_on_create_workflow_action.accessDenied","args":[]}}},"shortTitle":"Excel","repliesProperties":{"__typename":"RepliesProperties","sortOrder":"REVERSE_PUBLISH_TIME","repliesFormat":"threaded"},"eventPath":"category:microsoft365/category:products-services/category:communities/community:gxcuf89792board:ExcelGeneral/","tagProperties":{"__typename":"TagNodeProperties","tagsEnabled":{"__typename":"PolicyResult","failureReason":null}},"requireTags":true,"tagType":"PRESET_ONLY"},"Rank:rank:37":{"__typename":"Rank","id":"rank:37","position":18,"name":"Copper Contributor","color":"333333","icon":null,"rankStyle":"TEXT"},"User:user:928153":{"__typename":"User","id":"user:928153","uid":928153,"login":"itzikassafoutlookcom","deleted":false,"avatar":{"__typename":"UserAvatar","url":"https://techcommunity.microsoft.com/t5/s/gxcuf89792/m_assets/avatars/default/avatar-7.svg?time=0"},"rank":{"__ref":"Rank:rank:37"},"email":"","messagesCount":1,"biography":null,"topicsCount":1,"kudosReceivedCount":0,"kudosGivenCount":0,"kudosWeight":1,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2021-01-13T11:43:41.714-08:00","confirmEmailStatus":null},"followersCount":null,"solutionsCount":0},"ForumTopicMessage:message:2058369":{"__typename":"ForumTopicMessage","uid":2058369,"subject":"Excel Menu Bar","id":"message:2058369","revisionNum":1,"repliesCount":1,"author":{"__ref":"User:user:928153"},"depth":0,"hasGivenKudo":false,"board":{"__ref":"Forum:board:ExcelGeneral"},"conversation":{"__ref":"Conversation:conversation:2058369"},"readOnly":false,"editFrozen":false,"moderationData":{"__ref":"ModerationData:moderation_data:2058369"},"body":"

The Data option in the menu bar is completely not available, the same with the View-->Custom Views Option

","body@stringLength":"115","rawBody":"

The Data option in the menu bar is completely not available, the same with the View-->Custom Views Option

","kudosSumWeight":0,"postTime":"2021-01-13T12:52:22.699-08:00","images":{"__typename":"AssociatedImageConnection","edges":[],"totalCount":0,"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"attachments":{"__typename":"AttachmentConnection","pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null},"edges":[]},"tags":{"__typename":"TagConnection","pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null},"edges":[{"__typename":"TagEdge","cursor":"MjUuMXwyLjF8b3wxMHxfTlZffDE","node":{"__typename":"Tag","id":"tag:excel","text":"excel","time":"2016-06-21T14:08:51.129-07:00","lastActivityTime":null,"messagesCount":null,"followersCount":null}}]},"timeToRead":1,"currentRevision":{"__ref":"Revision:revision:2058369_1"},"latestVersion":null,"metrics":{"__typename":"MessageMetrics","views":1106},"visibilityScope":"PUBLIC","canonicalUrl":null,"seoTitle":null,"seoDescription":null,"isEscalated":null,"placeholder":false,"originalMessageForPlaceholder":null,"messagePolicies":{"__typename":"MessagePolicies","canModerateSpamMessage":{"__typename":"PolicyResult","failureReason":{"__typename":"FailureReason","message":"error.lithium.policies.feature.moderation_spam.action.moderate_entity.allowed.accessDenied","key":"error.lithium.policies.feature.moderation_spam.action.moderate_entity.allowed.accessDenied","args":[]}}},"archivalData":null,"searchSnippet":"The Data option in the menu bar is completely not available, the same with the View-->Custom Views Option","replies":{"__typename":"MessageConnection","edges":[{"__typename":"MessageEdge","cursor":"MjUuMXwyLjF8aXwxMHwxMzI6MHxpbnQsMjA2MDI5NywyMDYwMjk3","node":{"__ref":"ForumReplyMessage:message:2060297"}}],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"customFields":[]},"Conversation:conversation:2058369":{"__typename":"Conversation","id":"conversation:2058369","solved":false,"topic":{"__ref":"ForumTopicMessage:message:2058369"},"lastPostingActivityTime":"2021-01-14T03:12:04.131-08:00","lastPostTime":"2021-01-14T03:12:04.131-08:00","unreadReplyCount":1,"isSubscribed":false},"ModerationData:moderation_data:2058369":{"__typename":"ModerationData","id":"moderation_data:2058369","status":"APPROVED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"Revision:revision:2058369_1":{"__typename":"Revision","id":"revision:2058369_1","lastEditTime":"2021-01-13T12:52:22.699-08:00"},"CachedAsset:theme:customTheme1-1745485686809":{"__typename":"CachedAsset","id":"theme:customTheme1-1745485686809","value":{"id":"customTheme1","animation":{"fast":"150ms","normal":"250ms","slow":"500ms","slowest":"750ms","function":"cubic-bezier(0.07, 0.91, 0.51, 1)","__typename":"AnimationThemeSettings"},"avatar":{"borderRadius":"50%","collections":["default"],"__typename":"AvatarThemeSettings"},"basics":{"browserIcon":{"imageAssetName":"favicon-1730836283320.png","imageLastModified":"1730836286415","__typename":"ThemeAsset"},"customerLogo":{"imageAssetName":"favicon-1730836271365.png","imageLastModified":"1730836274203","__typename":"ThemeAsset"},"maximumWidthOfPageContent":"1300px","oneColumnNarrowWidth":"800px","gridGutterWidthMd":"30px","gridGutterWidthXs":"10px","pageWidthStyle":"WIDTH_OF_BROWSER","__typename":"BasicsThemeSettings"},"buttons":{"borderRadiusSm":"3px","borderRadius":"3px","borderRadiusLg":"5px","paddingY":"5px","paddingYLg":"7px","paddingYHero":"var(--lia-bs-btn-padding-y-lg)","paddingX":"12px","paddingXLg":"16px","paddingXHero":"60px","fontStyle":"NORMAL","fontWeight":"700","textTransform":"NONE","disabledOpacity":0.5,"primaryTextColor":"var(--lia-bs-white)","primaryTextHoverColor":"var(--lia-bs-white)","primaryTextActiveColor":"var(--lia-bs-white)","primaryBgColor":"var(--lia-bs-primary)","primaryBgHoverColor":"hsl(var(--lia-bs-primary-h), var(--lia-bs-primary-s), calc(var(--lia-bs-primary-l) * 0.85))","primaryBgActiveColor":"hsl(var(--lia-bs-primary-h), var(--lia-bs-primary-s), calc(var(--lia-bs-primary-l) * 0.7))","primaryBorder":"1px solid transparent","primaryBorderHover":"1px solid transparent","primaryBorderActive":"1px solid transparent","primaryBorderFocus":"1px solid var(--lia-bs-white)","primaryBoxShadowFocus":"0 0 0 1px var(--lia-bs-primary), 0 0 0 4px hsla(var(--lia-bs-primary-h), var(--lia-bs-primary-s), var(--lia-bs-primary-l), 0.2)","secondaryTextColor":"var(--lia-bs-gray-900)","secondaryTextHoverColor":"hsl(var(--lia-bs-gray-900-h), var(--lia-bs-gray-900-s), calc(var(--lia-bs-gray-900-l) * 0.95))","secondaryTextActiveColor":"hsl(var(--lia-bs-gray-900-h), var(--lia-bs-gray-900-s), calc(var(--lia-bs-gray-900-l) * 0.9))","secondaryBgColor":"var(--lia-bs-gray-200)","secondaryBgHoverColor":"hsl(var(--lia-bs-gray-200-h), var(--lia-bs-gray-200-s), calc(var(--lia-bs-gray-200-l) * 0.96))","secondaryBgActiveColor":"hsl(var(--lia-bs-gray-200-h), var(--lia-bs-gray-200-s), calc(var(--lia-bs-gray-200-l) * 0.92))","secondaryBorder":"1px solid transparent","secondaryBorderHover":"1px solid transparent","secondaryBorderActive":"1px solid transparent","secondaryBorderFocus":"1px solid transparent","secondaryBoxShadowFocus":"0 0 0 1px var(--lia-bs-primary), 0 0 0 4px hsla(var(--lia-bs-primary-h), var(--lia-bs-primary-s), var(--lia-bs-primary-l), 0.2)","tertiaryTextColor":"var(--lia-bs-gray-900)","tertiaryTextHoverColor":"hsl(var(--lia-bs-gray-900-h), var(--lia-bs-gray-900-s), calc(var(--lia-bs-gray-900-l) * 0.95))","tertiaryTextActiveColor":"hsl(var(--lia-bs-gray-900-h), var(--lia-bs-gray-900-s), calc(var(--lia-bs-gray-900-l) * 0.9))","tertiaryBgColor":"transparent","tertiaryBgHoverColor":"transparent","tertiaryBgActiveColor":"hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.04)","tertiaryBorder":"1px solid transparent","tertiaryBorderHover":"1px solid hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.08)","tertiaryBorderActive":"1px solid transparent","tertiaryBorderFocus":"1px solid transparent","tertiaryBoxShadowFocus":"0 0 0 1px var(--lia-bs-primary), 0 0 0 4px hsla(var(--lia-bs-primary-h), var(--lia-bs-primary-s), var(--lia-bs-primary-l), 0.2)","destructiveTextColor":"var(--lia-bs-danger)","destructiveTextHoverColor":"hsl(var(--lia-bs-danger-h), var(--lia-bs-danger-s), calc(var(--lia-bs-danger-l) * 0.95))","destructiveTextActiveColor":"hsl(var(--lia-bs-danger-h), var(--lia-bs-danger-s), calc(var(--lia-bs-danger-l) * 0.9))","destructiveBgColor":"var(--lia-bs-gray-200)","destructiveBgHoverColor":"hsl(var(--lia-bs-gray-200-h), var(--lia-bs-gray-200-s), calc(var(--lia-bs-gray-200-l) * 0.96))","destructiveBgActiveColor":"hsl(var(--lia-bs-gray-200-h), var(--lia-bs-gray-200-s), calc(var(--lia-bs-gray-200-l) * 0.92))","destructiveBorder":"1px solid transparent","destructiveBorderHover":"1px solid transparent","destructiveBorderActive":"1px solid transparent","destructiveBorderFocus":"1px solid transparent","destructiveBoxShadowFocus":"0 0 0 1px var(--lia-bs-primary), 0 0 0 4px hsla(var(--lia-bs-primary-h), var(--lia-bs-primary-s), var(--lia-bs-primary-l), 0.2)","__typename":"ButtonsThemeSettings"},"border":{"color":"hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.08)","mainContent":"NONE","sideContent":"LIGHT","radiusSm":"3px","radius":"5px","radiusLg":"9px","radius50":"100vw","__typename":"BorderThemeSettings"},"boxShadow":{"xs":"0 0 0 1px hsla(var(--lia-bs-gray-900-h), var(--lia-bs-gray-900-s), var(--lia-bs-gray-900-l), 0.08), 0 3px 0 -1px hsla(var(--lia-bs-gray-900-h), var(--lia-bs-gray-900-s), var(--lia-bs-gray-900-l), 0.16)","sm":"0 2px 4px hsla(var(--lia-bs-gray-900-h), var(--lia-bs-gray-900-s), var(--lia-bs-gray-900-l), 0.12)","md":"0 5px 15px hsla(var(--lia-bs-gray-900-h), var(--lia-bs-gray-900-s), var(--lia-bs-gray-900-l), 0.3)","lg":"0 10px 30px hsla(var(--lia-bs-gray-900-h), var(--lia-bs-gray-900-s), var(--lia-bs-gray-900-l), 0.3)","__typename":"BoxShadowThemeSettings"},"cards":{"bgColor":"var(--lia-panel-bg-color)","borderRadius":"var(--lia-panel-border-radius)","boxShadow":"var(--lia-box-shadow-xs)","__typename":"CardsThemeSettings"},"chip":{"maxWidth":"300px","height":"30px","__typename":"ChipThemeSettings"},"coreTypes":{"defaultMessageLinkColor":"var(--lia-bs-link-color)","defaultMessageLinkDecoration":"none","defaultMessageLinkFontStyle":"NORMAL","defaultMessageLinkFontWeight":"400","defaultMessageFontStyle":"NORMAL","defaultMessageFontWeight":"400","forumColor":"#4099E2","forumFontFamily":"var(--lia-bs-font-family-base)","forumFontWeight":"var(--lia-default-message-font-weight)","forumLineHeight":"var(--lia-bs-line-height-base)","forumFontStyle":"var(--lia-default-message-font-style)","forumMessageLinkColor":"var(--lia-default-message-link-color)","forumMessageLinkDecoration":"var(--lia-default-message-link-decoration)","forumMessageLinkFontStyle":"var(--lia-default-message-link-font-style)","forumMessageLinkFontWeight":"var(--lia-default-message-link-font-weight)","forumSolvedColor":"#148563","blogColor":"#1CBAA0","blogFontFamily":"var(--lia-bs-font-family-base)","blogFontWeight":"var(--lia-default-message-font-weight)","blogLineHeight":"1.75","blogFontStyle":"var(--lia-default-message-font-style)","blogMessageLinkColor":"var(--lia-default-message-link-color)","blogMessageLinkDecoration":"var(--lia-default-message-link-decoration)","blogMessageLinkFontStyle":"var(--lia-default-message-link-font-style)","blogMessageLinkFontWeight":"var(--lia-default-message-link-font-weight)","tkbColor":"#4C6B90","tkbFontFamily":"var(--lia-bs-font-family-base)","tkbFontWeight":"var(--lia-default-message-font-weight)","tkbLineHeight":"1.75","tkbFontStyle":"var(--lia-default-message-font-style)","tkbMessageLinkColor":"var(--lia-default-message-link-color)","tkbMessageLinkDecoration":"var(--lia-default-message-link-decoration)","tkbMessageLinkFontStyle":"var(--lia-default-message-link-font-style)","tkbMessageLinkFontWeight":"var(--lia-default-message-link-font-weight)","qandaColor":"#4099E2","qandaFontFamily":"var(--lia-bs-font-family-base)","qandaFontWeight":"var(--lia-default-message-font-weight)","qandaLineHeight":"var(--lia-bs-line-height-base)","qandaFontStyle":"var(--lia-default-message-link-font-style)","qandaMessageLinkColor":"var(--lia-default-message-link-color)","qandaMessageLinkDecoration":"var(--lia-default-message-link-decoration)","qandaMessageLinkFontStyle":"var(--lia-default-message-link-font-style)","qandaMessageLinkFontWeight":"var(--lia-default-message-link-font-weight)","qandaSolvedColor":"#3FA023","ideaColor":"#FF8000","ideaFontFamily":"var(--lia-bs-font-family-base)","ideaFontWeight":"var(--lia-default-message-font-weight)","ideaLineHeight":"var(--lia-bs-line-height-base)","ideaFontStyle":"var(--lia-default-message-font-style)","ideaMessageLinkColor":"var(--lia-default-message-link-color)","ideaMessageLinkDecoration":"var(--lia-default-message-link-decoration)","ideaMessageLinkFontStyle":"var(--lia-default-message-link-font-style)","ideaMessageLinkFontWeight":"var(--lia-default-message-link-font-weight)","contestColor":"#FCC845","contestFontFamily":"var(--lia-bs-font-family-base)","contestFontWeight":"var(--lia-default-message-font-weight)","contestLineHeight":"var(--lia-bs-line-height-base)","contestFontStyle":"var(--lia-default-message-link-font-style)","contestMessageLinkColor":"var(--lia-default-message-link-color)","contestMessageLinkDecoration":"var(--lia-default-message-link-decoration)","contestMessageLinkFontStyle":"ITALIC","contestMessageLinkFontWeight":"var(--lia-default-message-link-font-weight)","occasionColor":"#D13A1F","occasionFontFamily":"var(--lia-bs-font-family-base)","occasionFontWeight":"var(--lia-default-message-font-weight)","occasionLineHeight":"var(--lia-bs-line-height-base)","occasionFontStyle":"var(--lia-default-message-font-style)","occasionMessageLinkColor":"var(--lia-default-message-link-color)","occasionMessageLinkDecoration":"var(--lia-default-message-link-decoration)","occasionMessageLinkFontStyle":"var(--lia-default-message-link-font-style)","occasionMessageLinkFontWeight":"var(--lia-default-message-link-font-weight)","grouphubColor":"#333333","categoryColor":"#949494","communityColor":"#FFFFFF","productColor":"#949494","__typename":"CoreTypesThemeSettings"},"colors":{"black":"#000000","white":"#FFFFFF","gray100":"#F7F7F7","gray200":"#F7F7F7","gray300":"#E8E8E8","gray400":"#D9D9D9","gray500":"#CCCCCC","gray600":"#717171","gray700":"#707070","gray800":"#545454","gray900":"#333333","dark":"#545454","light":"#F7F7F7","primary":"#0069D4","secondary":"#333333","bodyText":"#1E1E1E","bodyBg":"#FFFFFF","info":"#409AE2","success":"#41C5AE","warning":"#FCC844","danger":"#BC341B","alertSystem":"#FF6600","textMuted":"#707070","highlight":"#FFFCAD","outline":"var(--lia-bs-primary)","custom":["#D3F5A4","#243A5E"],"__typename":"ColorsThemeSettings"},"divider":{"size":"3px","marginLeft":"4px","marginRight":"4px","borderRadius":"50%","bgColor":"var(--lia-bs-gray-600)","bgColorActive":"var(--lia-bs-gray-600)","__typename":"DividerThemeSettings"},"dropdown":{"fontSize":"var(--lia-bs-font-size-sm)","borderColor":"var(--lia-bs-border-color)","borderRadius":"var(--lia-bs-border-radius-sm)","dividerBg":"var(--lia-bs-gray-300)","itemPaddingY":"5px","itemPaddingX":"20px","headerColor":"var(--lia-bs-gray-700)","__typename":"DropdownThemeSettings"},"email":{"link":{"color":"#0069D4","hoverColor":"#0061c2","decoration":"none","hoverDecoration":"underline","__typename":"EmailLinkSettings"},"border":{"color":"#e4e4e4","__typename":"EmailBorderSettings"},"buttons":{"borderRadiusLg":"5px","paddingXLg":"16px","paddingYLg":"7px","fontWeight":"700","primaryTextColor":"#ffffff","primaryTextHoverColor":"#ffffff","primaryBgColor":"#0069D4","primaryBgHoverColor":"#005cb8","primaryBorder":"1px solid transparent","primaryBorderHover":"1px solid transparent","__typename":"EmailButtonsSettings"},"panel":{"borderRadius":"5px","borderColor":"#e4e4e4","__typename":"EmailPanelSettings"},"__typename":"EmailThemeSettings"},"emoji":{"skinToneDefault":"#ffcd43","skinToneLight":"#fae3c5","skinToneMediumLight":"#e2cfa5","skinToneMedium":"#daa478","skinToneMediumDark":"#a78058","skinToneDark":"#5e4d43","__typename":"EmojiThemeSettings"},"heading":{"color":"var(--lia-bs-body-color)","fontFamily":"Segoe UI","fontStyle":"NORMAL","fontWeight":"400","h1FontSize":"34px","h2FontSize":"32px","h3FontSize":"28px","h4FontSize":"24px","h5FontSize":"20px","h6FontSize":"16px","lineHeight":"1.3","subHeaderFontSize":"11px","subHeaderFontWeight":"500","h1LetterSpacing":"normal","h2LetterSpacing":"normal","h3LetterSpacing":"normal","h4LetterSpacing":"normal","h5LetterSpacing":"normal","h6LetterSpacing":"normal","subHeaderLetterSpacing":"2px","h1FontWeight":"var(--lia-bs-headings-font-weight)","h2FontWeight":"var(--lia-bs-headings-font-weight)","h3FontWeight":"var(--lia-bs-headings-font-weight)","h4FontWeight":"var(--lia-bs-headings-font-weight)","h5FontWeight":"var(--lia-bs-headings-font-weight)","h6FontWeight":"var(--lia-bs-headings-font-weight)","__typename":"HeadingThemeSettings"},"icons":{"size10":"10px","size12":"12px","size14":"14px","size16":"16px","size20":"20px","size24":"24px","size30":"30px","size40":"40px","size50":"50px","size60":"60px","size80":"80px","size120":"120px","size160":"160px","__typename":"IconsThemeSettings"},"imagePreview":{"bgColor":"var(--lia-bs-gray-900)","titleColor":"var(--lia-bs-white)","controlColor":"var(--lia-bs-white)","controlBgColor":"var(--lia-bs-gray-800)","__typename":"ImagePreviewThemeSettings"},"input":{"borderColor":"var(--lia-bs-gray-600)","disabledColor":"var(--lia-bs-gray-600)","focusBorderColor":"var(--lia-bs-primary)","labelMarginBottom":"10px","btnFontSize":"var(--lia-bs-font-size-sm)","focusBoxShadow":"0 0 0 3px hsla(var(--lia-bs-primary-h), var(--lia-bs-primary-s), var(--lia-bs-primary-l), 0.2)","checkLabelMarginBottom":"2px","checkboxBorderRadius":"3px","borderRadiusSm":"var(--lia-bs-border-radius-sm)","borderRadius":"var(--lia-bs-border-radius)","borderRadiusLg":"var(--lia-bs-border-radius-lg)","formTextMarginTop":"4px","textAreaBorderRadius":"var(--lia-bs-border-radius)","activeFillColor":"var(--lia-bs-primary)","__typename":"InputThemeSettings"},"loading":{"dotDarkColor":"hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.2)","dotLightColor":"hsla(var(--lia-bs-white-h), var(--lia-bs-white-s), var(--lia-bs-white-l), 0.5)","barDarkColor":"hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.06)","barLightColor":"hsla(var(--lia-bs-white-h), var(--lia-bs-white-s), var(--lia-bs-white-l), 0.4)","__typename":"LoadingThemeSettings"},"link":{"color":"var(--lia-bs-primary)","hoverColor":"hsl(var(--lia-bs-primary-h), var(--lia-bs-primary-s), calc(var(--lia-bs-primary-l) - 10%))","decoration":"none","hoverDecoration":"underline","__typename":"LinkThemeSettings"},"listGroup":{"itemPaddingY":"15px","itemPaddingX":"15px","borderColor":"var(--lia-bs-gray-300)","__typename":"ListGroupThemeSettings"},"modal":{"contentTextColor":"var(--lia-bs-body-color)","contentBg":"var(--lia-bs-white)","backgroundBg":"var(--lia-bs-black)","smSize":"440px","mdSize":"760px","lgSize":"1080px","backdropOpacity":0.3,"contentBoxShadowXs":"var(--lia-bs-box-shadow-sm)","contentBoxShadow":"var(--lia-bs-box-shadow)","headerFontWeight":"700","__typename":"ModalThemeSettings"},"navbar":{"position":"FIXED","background":{"attachment":null,"clip":null,"color":"var(--lia-bs-white)","imageAssetName":"","imageLastModified":"0","origin":null,"position":"CENTER_CENTER","repeat":"NO_REPEAT","size":"COVER","__typename":"BackgroundProps"},"backgroundOpacity":0.8,"paddingTop":"15px","paddingBottom":"15px","borderBottom":"1px solid var(--lia-bs-border-color)","boxShadow":"var(--lia-bs-box-shadow-sm)","brandMarginRight":"30px","brandMarginRightSm":"10px","brandLogoHeight":"30px","linkGap":"10px","linkJustifyContent":"flex-start","linkPaddingY":"5px","linkPaddingX":"10px","linkDropdownPaddingY":"9px","linkDropdownPaddingX":"var(--lia-nav-link-px)","linkColor":"var(--lia-bs-body-color)","linkHoverColor":"var(--lia-bs-primary)","linkFontSize":"var(--lia-bs-font-size-sm)","linkFontStyle":"NORMAL","linkFontWeight":"400","linkTextTransform":"NONE","linkLetterSpacing":"normal","linkBorderRadius":"var(--lia-bs-border-radius-sm)","linkBgColor":"transparent","linkBgHoverColor":"transparent","linkBorder":"none","linkBorderHover":"none","linkBoxShadow":"none","linkBoxShadowHover":"none","linkTextBorderBottom":"none","linkTextBorderBottomHover":"none","dropdownPaddingTop":"10px","dropdownPaddingBottom":"15px","dropdownPaddingX":"10px","dropdownMenuOffset":"2px","dropdownDividerMarginTop":"10px","dropdownDividerMarginBottom":"10px","dropdownBorderColor":"hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.08)","controllerBgHoverColor":"hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.1)","controllerIconColor":"var(--lia-bs-body-color)","controllerIconHoverColor":"var(--lia-bs-body-color)","controllerTextColor":"var(--lia-nav-controller-icon-color)","controllerTextHoverColor":"var(--lia-nav-controller-icon-hover-color)","controllerHighlightColor":"hsla(30, 100%, 50%)","controllerHighlightTextColor":"var(--lia-yiq-light)","controllerBorderRadius":"var(--lia-border-radius-50)","hamburgerColor":"var(--lia-nav-controller-icon-color)","hamburgerHoverColor":"var(--lia-nav-controller-icon-color)","hamburgerBgColor":"transparent","hamburgerBgHoverColor":"transparent","hamburgerBorder":"none","hamburgerBorderHover":"none","collapseMenuMarginLeft":"20px","collapseMenuDividerBg":"var(--lia-nav-link-color)","collapseMenuDividerOpacity":0.16,"__typename":"NavbarThemeSettings"},"pager":{"textColor":"var(--lia-bs-link-color)","textFontWeight":"var(--lia-font-weight-md)","textFontSize":"var(--lia-bs-font-size-sm)","__typename":"PagerThemeSettings"},"panel":{"bgColor":"var(--lia-bs-white)","borderRadius":"var(--lia-bs-border-radius)","borderColor":"var(--lia-bs-border-color)","boxShadow":"none","__typename":"PanelThemeSettings"},"popover":{"arrowHeight":"8px","arrowWidth":"16px","maxWidth":"300px","minWidth":"100px","headerBg":"var(--lia-bs-white)","borderColor":"var(--lia-bs-border-color)","borderRadius":"var(--lia-bs-border-radius)","boxShadow":"0 0.5rem 1rem hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.15)","__typename":"PopoverThemeSettings"},"prism":{"color":"#000000","bgColor":"#f5f2f0","fontFamily":"var(--font-family-monospace)","fontSize":"var(--lia-bs-font-size-base)","fontWeightBold":"var(--lia-bs-font-weight-bold)","fontStyleItalic":"italic","tabSize":2,"highlightColor":"#b3d4fc","commentColor":"#62707e","punctuationColor":"#6f6f6f","namespaceOpacity":"0.7","propColor":"#990055","selectorColor":"#517a00","operatorColor":"#906736","operatorBgColor":"hsla(0, 0%, 100%, 0.5)","keywordColor":"#0076a9","functionColor":"#d3284b","variableColor":"#c14700","__typename":"PrismThemeSettings"},"rte":{"bgColor":"var(--lia-bs-white)","borderRadius":"var(--lia-panel-border-radius)","boxShadow":" var(--lia-panel-box-shadow)","customColor1":"#bfedd2","customColor2":"#fbeeb8","customColor3":"#f8cac6","customColor4":"#eccafa","customColor5":"#c2e0f4","customColor6":"#2dc26b","customColor7":"#f1c40f","customColor8":"#e03e2d","customColor9":"#b96ad9","customColor10":"#3598db","customColor11":"#169179","customColor12":"#e67e23","customColor13":"#ba372a","customColor14":"#843fa1","customColor15":"#236fa1","customColor16":"#ecf0f1","customColor17":"#ced4d9","customColor18":"#95a5a6","customColor19":"#7e8c8d","customColor20":"#34495e","customColor21":"#000000","customColor22":"#ffffff","defaultMessageHeaderMarginTop":"40px","defaultMessageHeaderMarginBottom":"20px","defaultMessageItemMarginTop":"0","defaultMessageItemMarginBottom":"10px","diffAddedColor":"hsla(170, 53%, 51%, 0.4)","diffChangedColor":"hsla(43, 97%, 63%, 0.4)","diffNoneColor":"hsla(0, 0%, 80%, 0.4)","diffRemovedColor":"hsla(9, 74%, 47%, 0.4)","specialMessageHeaderMarginTop":"40px","specialMessageHeaderMarginBottom":"20px","specialMessageItemMarginTop":"0","specialMessageItemMarginBottom":"10px","__typename":"RteThemeSettings"},"tags":{"bgColor":"var(--lia-bs-gray-200)","bgHoverColor":"var(--lia-bs-gray-400)","borderRadius":"var(--lia-bs-border-radius-sm)","color":"var(--lia-bs-body-color)","hoverColor":"var(--lia-bs-body-color)","fontWeight":"var(--lia-font-weight-md)","fontSize":"var(--lia-font-size-xxs)","textTransform":"UPPERCASE","letterSpacing":"0.5px","__typename":"TagsThemeSettings"},"toasts":{"borderRadius":"var(--lia-bs-border-radius)","paddingX":"12px","__typename":"ToastsThemeSettings"},"typography":{"fontFamilyBase":"Segoe UI","fontStyleBase":"NORMAL","fontWeightBase":"400","fontWeightLight":"300","fontWeightNormal":"400","fontWeightMd":"500","fontWeightBold":"700","letterSpacingSm":"normal","letterSpacingXs":"normal","lineHeightBase":"1.5","fontSizeBase":"16px","fontSizeXxs":"11px","fontSizeXs":"12px","fontSizeSm":"14px","fontSizeLg":"20px","fontSizeXl":"24px","smallFontSize":"14px","customFonts":[{"source":"SERVER","name":"Segoe UI","styles":[{"style":"NORMAL","weight":"400","__typename":"FontStyleData"},{"style":"NORMAL","weight":"300","__typename":"FontStyleData"},{"style":"NORMAL","weight":"600","__typename":"FontStyleData"},{"style":"NORMAL","weight":"700","__typename":"FontStyleData"},{"style":"ITALIC","weight":"400","__typename":"FontStyleData"}],"assetNames":["SegoeUI-normal-400.woff2","SegoeUI-normal-300.woff2","SegoeUI-normal-600.woff2","SegoeUI-normal-700.woff2","SegoeUI-italic-400.woff2"],"__typename":"CustomFont"},{"source":"SERVER","name":"MWF Fluent Icons","styles":[{"style":"NORMAL","weight":"400","__typename":"FontStyleData"}],"assetNames":["MWFFluentIcons-normal-400.woff2"],"__typename":"CustomFont"}],"__typename":"TypographyThemeSettings"},"unstyledListItem":{"marginBottomSm":"5px","marginBottomMd":"10px","marginBottomLg":"15px","marginBottomXl":"20px","marginBottomXxl":"25px","__typename":"UnstyledListItemThemeSettings"},"yiq":{"light":"#ffffff","dark":"#000000","__typename":"YiqThemeSettings"},"colorLightness":{"primaryDark":0.36,"primaryLight":0.74,"primaryLighter":0.89,"primaryLightest":0.95,"infoDark":0.39,"infoLight":0.72,"infoLighter":0.85,"infoLightest":0.93,"successDark":0.24,"successLight":0.62,"successLighter":0.8,"successLightest":0.91,"warningDark":0.39,"warningLight":0.68,"warningLighter":0.84,"warningLightest":0.93,"dangerDark":0.41,"dangerLight":0.72,"dangerLighter":0.89,"dangerLightest":0.95,"__typename":"ColorLightnessThemeSettings"},"localOverride":false,"__typename":"Theme"},"localOverride":false},"CachedAsset:text:en_US-components/common/EmailVerification-1745505309787":{"__typename":"CachedAsset","id":"text:en_US-components/common/EmailVerification-1745505309787","value":{"email.verification.title":"Email Verification Required","email.verification.message.update.email":"To participate in the community, you must first verify your email address. The verification email was sent to {email}. To change your email, visit My Settings.","email.verification.message.resend.email":"To participate in the community, you must first verify your email address. The verification email was sent to {email}. Resend email."},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/common/Loading/LoadingDot-1745505309787":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/common/Loading/LoadingDot-1745505309787","value":{"title":"Loading..."},"localOverride":false},"CachedAsset:quilt:o365.prod:pages/forums/ForumMessagePage:board:ExcelGeneral-1745502712805":{"__typename":"CachedAsset","id":"quilt:o365.prod:pages/forums/ForumMessagePage:board:ExcelGeneral-1745502712805","value":{"id":"ForumMessagePage","container":{"id":"Common","headerProps":{"backgroundImageProps":null,"backgroundColor":null,"addComponents":null,"removeComponents":["community.widget.bannerWidget"],"componentOrder":null,"__typename":"QuiltContainerSectionProps"},"headerComponentProps":{"community.widget.breadcrumbWidget":{"disableLastCrumbForDesktop":false}},"footerProps":null,"footerComponentProps":null,"items":[{"id":"section-1733174818610","layout":"ONE_COLUMN","bgColor":null,"showTitle":null,"showDescription":null,"textPosition":null,"textColor":null,"sectionEditLevel":null,"bgImage":null,"disableSpacing":null,"edgeToEdgeDisplay":null,"fullHeight":null,"showBorder":null,"__typename":"OneColumnQuiltSection","columnMap":{"main":[],"__typename":"OneSectionColumns"}},{"id":"message-list","layout":"MAIN_SIDE","bgColor":null,"showTitle":null,"showDescription":null,"textPosition":null,"textColor":null,"sectionEditLevel":null,"bgImage":null,"disableSpacing":null,"edgeToEdgeDisplay":null,"fullHeight":null,"showBorder":null,"__typename":"MainSideQuiltSection","columnMap":{"main":[{"id":"messages.widget.topicWithThreadedReplyListWidget","className":"lia-topic-with-replies","props":{"editLevel":"CONFIGURE"},"__typename":"QuiltComponent"}],"side":[{"id":"custom.widget.Featured_Resources","className":null,"props":{"widgetVisibility":"signedInOrAnonymous","useTitle":true,"useBackground":true,"title":"Resources","lazyLoad":false},"__typename":"QuiltComponent"}],"__typename":"MainSideSectionColumns"}}],"__typename":"QuiltContainer"},"__typename":"Quilt","localOverride":false},"localOverride":false},"CachedAsset:text:en_US-pages/forums/ForumMessagePage-1745505309787":{"__typename":"CachedAsset","id":"text:en_US-pages/forums/ForumMessagePage-1745505309787","value":{"title":"{contextMessageSubject} | {communityTitle}","errorMissing":"This message cannot be found","name":"Forum Message Page","section.message-list.title":"Forum Discussion","archivedMessageTitle":"This Content Has Been Archived","section.TqVYTs.title":"Forum Discussion"},"localOverride":false},"CachedAsset:quiltWrapper:o365.prod:Common:1745505310885":{"__typename":"CachedAsset","id":"quiltWrapper:o365.prod:Common:1745505310885","value":{"id":"Common","header":{"backgroundImageProps":{"assetName":null,"backgroundSize":"COVER","backgroundRepeat":"NO_REPEAT","backgroundPosition":"CENTER_CENTER","lastModified":null,"__typename":"BackgroundImageProps"},"backgroundColor":"transparent","items":[{"id":"community.widget.navbarWidget","props":{"showUserName":true,"showRegisterLink":true,"useIconLanguagePicker":true,"useLabelLanguagePicker":true,"className":"QuiltComponent_lia-component-edit-mode__0nCcm","links":{"sideLinks":[],"mainLinks":[{"children":[],"linkType":"INTERNAL","id":"gxcuf89792","params":{},"routeName":"CommunityPage"},{"children":[],"linkType":"EXTERNAL","id":"external-link","url":"/Directory","target":"SELF"},{"children":[{"linkType":"INTERNAL","id":"microsoft365","params":{"categoryId":"microsoft365"},"routeName":"CategoryPage"},{"linkType":"INTERNAL","id":"windows","params":{"categoryId":"Windows"},"routeName":"CategoryPage"},{"linkType":"INTERNAL","id":"Common-microsoft365-copilot-link","params":{"categoryId":"Microsoft365Copilot"},"routeName":"CategoryPage"},{"linkType":"INTERNAL","id":"microsoft-teams","params":{"categoryId":"MicrosoftTeams"},"routeName":"CategoryPage"},{"linkType":"INTERNAL","id":"microsoft-securityand-compliance","params":{"categoryId":"microsoft-security"},"routeName":"CategoryPage"},{"linkType":"INTERNAL","id":"azure","params":{"categoryId":"Azure"},"routeName":"CategoryPage"},{"linkType":"INTERNAL","id":"Common-content_management-link","params":{"categoryId":"Content_Management"},"routeName":"CategoryPage"},{"linkType":"INTERNAL","id":"exchange","params":{"categoryId":"Exchange"},"routeName":"CategoryPage"},{"linkType":"INTERNAL","id":"windows-server","params":{"categoryId":"Windows-Server"},"routeName":"CategoryPage"},{"linkType":"INTERNAL","id":"outlook","params":{"categoryId":"Outlook"},"routeName":"CategoryPage"},{"linkType":"INTERNAL","id":"microsoft-endpoint-manager","params":{"categoryId":"microsoftintune"},"routeName":"CategoryPage"},{"linkType":"EXTERNAL","id":"external-link-2","url":"/Directory","target":"SELF"}],"linkType":"EXTERNAL","id":"communities","url":"/","target":"BLANK"},{"children":[{"linkType":"INTERNAL","id":"a-i","params":{"categoryId":"AI"},"routeName":"CategoryPage"},{"linkType":"INTERNAL","id":"education-sector","params":{"categoryId":"EducationSector"},"routeName":"CategoryPage"},{"linkType":"INTERNAL","id":"partner-community","params":{"categoryId":"PartnerCommunity"},"routeName":"CategoryPage"},{"linkType":"INTERNAL","id":"i-t-ops-talk","params":{"categoryId":"ITOpsTalk"},"routeName":"CategoryPage"},{"linkType":"INTERNAL","id":"healthcare-and-life-sciences","params":{"categoryId":"HealthcareAndLifeSciences"},"routeName":"CategoryPage"},{"linkType":"INTERNAL","id":"microsoft-mechanics","params":{"categoryId":"MicrosoftMechanics"},"routeName":"CategoryPage"},{"linkType":"INTERNAL","id":"public-sector","params":{"categoryId":"PublicSector"},"routeName":"CategoryPage"},{"linkType":"INTERNAL","id":"s-m-b","params":{"categoryId":"MicrosoftforNonprofits"},"routeName":"CategoryPage"},{"linkType":"INTERNAL","id":"io-t","params":{"categoryId":"IoT"},"routeName":"CategoryPage"},{"linkType":"INTERNAL","id":"startupsat-microsoft","params":{"categoryId":"StartupsatMicrosoft"},"routeName":"CategoryPage"},{"linkType":"INTERNAL","id":"driving-adoption","params":{"categoryId":"DrivingAdoption"},"routeName":"CategoryPage"},{"linkType":"EXTERNAL","id":"external-link-1","url":"/Directory","target":"SELF"}],"linkType":"EXTERNAL","id":"communities-1","url":"/","target":"SELF"},{"children":[],"linkType":"EXTERNAL","id":"external","url":"/Blogs","target":"SELF"},{"children":[],"linkType":"EXTERNAL","id":"external-1","url":"/Events","target":"SELF"},{"children":[{"linkType":"INTERNAL","id":"microsoft-learn-1","params":{"categoryId":"MicrosoftLearn"},"routeName":"CategoryPage"},{"linkType":"INTERNAL","id":"microsoft-learn-blog","params":{"boardId":"MicrosoftLearnBlog","categoryId":"MicrosoftLearn"},"routeName":"BlogBoardPage"},{"linkType":"EXTERNAL","id":"external-10","url":"https://learningroomdirectory.microsoft.com/","target":"BLANK"},{"linkType":"EXTERNAL","id":"external-3","url":"https://docs.microsoft.com/learn/dynamics365/?WT.mc_id=techcom_header-webpage-m365","target":"BLANK"},{"linkType":"EXTERNAL","id":"external-4","url":"https://docs.microsoft.com/learn/m365/?wt.mc_id=techcom_header-webpage-m365","target":"BLANK"},{"linkType":"EXTERNAL","id":"external-5","url":"https://docs.microsoft.com/learn/topics/sci/?wt.mc_id=techcom_header-webpage-m365","target":"BLANK"},{"linkType":"EXTERNAL","id":"external-6","url":"https://docs.microsoft.com/learn/powerplatform/?wt.mc_id=techcom_header-webpage-powerplatform","target":"BLANK"},{"linkType":"EXTERNAL","id":"external-7","url":"https://docs.microsoft.com/learn/github/?wt.mc_id=techcom_header-webpage-github","target":"BLANK"},{"linkType":"EXTERNAL","id":"external-8","url":"https://docs.microsoft.com/learn/teams/?wt.mc_id=techcom_header-webpage-teams","target":"BLANK"},{"linkType":"EXTERNAL","id":"external-9","url":"https://docs.microsoft.com/learn/dotnet/?wt.mc_id=techcom_header-webpage-dotnet","target":"BLANK"},{"linkType":"EXTERNAL","id":"external-2","url":"https://docs.microsoft.com/learn/azure/?WT.mc_id=techcom_header-webpage-m365","target":"BLANK"}],"linkType":"INTERNAL","id":"microsoft-learn","params":{"categoryId":"MicrosoftLearn"},"routeName":"CategoryPage"},{"children":[],"linkType":"INTERNAL","id":"community-info-center","params":{"categoryId":"Community-Info-Center"},"routeName":"CategoryPage"}]},"style":{"boxShadow":"var(--lia-bs-box-shadow-sm)","controllerHighlightColor":"hsla(30, 100%, 50%)","linkFontWeight":"400","dropdownDividerMarginBottom":"10px","hamburgerBorderHover":"none","linkBoxShadowHover":"none","linkFontSize":"14px","backgroundOpacity":0.8,"controllerBorderRadius":"var(--lia-border-radius-50)","hamburgerBgColor":"transparent","hamburgerColor":"var(--lia-nav-controller-icon-color)","linkTextBorderBottom":"none","brandLogoHeight":"30px","linkBgHoverColor":"transparent","linkLetterSpacing":"normal","collapseMenuDividerOpacity":0.16,"dropdownPaddingBottom":"15px","paddingBottom":"15px","dropdownMenuOffset":"2px","hamburgerBgHoverColor":"transparent","borderBottom":"1px solid var(--lia-bs-border-color)","hamburgerBorder":"none","dropdownPaddingX":"10px","brandMarginRightSm":"10px","linkBoxShadow":"none","collapseMenuDividerBg":"var(--lia-nav-link-color)","linkColor":"var(--lia-bs-body-color)","linkJustifyContent":"flex-start","dropdownPaddingTop":"10px","controllerHighlightTextColor":"var(--lia-yiq-dark)","controllerTextColor":"var(--lia-nav-controller-icon-color)","background":{"imageAssetName":"","color":"var(--lia-bs-white)","size":"COVER","repeat":"NO_REPEAT","position":"CENTER_CENTER","imageLastModified":""},"linkBorderRadius":"var(--lia-bs-border-radius-sm)","linkHoverColor":"var(--lia-bs-body-color)","position":"FIXED","linkBorder":"none","linkTextBorderBottomHover":"2px solid var(--lia-bs-body-color)","brandMarginRight":"30px","hamburgerHoverColor":"var(--lia-nav-controller-icon-color)","linkBorderHover":"none","collapseMenuMarginLeft":"20px","linkFontStyle":"NORMAL","controllerTextHoverColor":"var(--lia-nav-controller-icon-hover-color)","linkPaddingX":"10px","linkPaddingY":"5px","paddingTop":"15px","linkTextTransform":"NONE","dropdownBorderColor":"hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.08)","controllerBgHoverColor":"hsla(var(--lia-bs-black-h), var(--lia-bs-black-s), var(--lia-bs-black-l), 0.1)","linkBgColor":"transparent","linkDropdownPaddingX":"var(--lia-nav-link-px)","linkDropdownPaddingY":"9px","controllerIconColor":"var(--lia-bs-body-color)","dropdownDividerMarginTop":"10px","linkGap":"10px","controllerIconHoverColor":"var(--lia-bs-body-color)"},"showSearchIcon":false,"languagePickerStyle":"iconAndLabel"},"__typename":"QuiltComponent"},{"id":"community.widget.breadcrumbWidget","props":{"backgroundColor":"transparent","linkHighlightColor":"var(--lia-bs-primary)","visualEffects":{"showBottomBorder":true},"linkTextColor":"var(--lia-bs-gray-700)"},"__typename":"QuiltComponent"},{"id":"custom.widget.community_banner","props":{"widgetVisibility":"signedInOrAnonymous","useTitle":true,"usePageWidth":false,"useBackground":false,"title":"","lazyLoad":false},"__typename":"QuiltComponent"},{"id":"custom.widget.HeroBanner","props":{"widgetVisibility":"signedInOrAnonymous","usePageWidth":false,"useTitle":true,"cMax_items":3,"useBackground":false,"title":"","lazyLoad":false,"widgetChooser":"custom.widget.HeroBanner"},"__typename":"QuiltComponent"}],"__typename":"QuiltWrapperSection"},"footer":{"backgroundImageProps":{"assetName":null,"backgroundSize":"COVER","backgroundRepeat":"NO_REPEAT","backgroundPosition":"CENTER_CENTER","lastModified":null,"__typename":"BackgroundImageProps"},"backgroundColor":"transparent","items":[{"id":"custom.widget.MicrosoftFooter","props":{"widgetVisibility":"signedInOrAnonymous","useTitle":true,"useBackground":false,"title":"","lazyLoad":false},"__typename":"QuiltComponent"}],"__typename":"QuiltWrapperSection"},"__typename":"QuiltWrapper","localOverride":false},"localOverride":false},"CachedAsset:text:en_US-components/common/ActionFeedback-1745505309787":{"__typename":"CachedAsset","id":"text:en_US-components/common/ActionFeedback-1745505309787","value":{"joinedGroupHub.title":"Welcome","joinedGroupHub.message":"You are now a member of this group and are subscribed to updates.","groupHubInviteNotFound.title":"Invitation Not Found","groupHubInviteNotFound.message":"Sorry, we could not find your invitation to the group. The owner may have canceled the invite.","groupHubNotFound.title":"Group Not Found","groupHubNotFound.message":"The grouphub you tried to join does not exist. It may have been deleted.","existingGroupHubMember.title":"Already Joined","existingGroupHubMember.message":"You are already a member of this group.","accountLocked.title":"Account Locked","accountLocked.message":"Your account has been locked due to multiple failed attempts. Try again in {lockoutTime} minutes.","editedGroupHub.title":"Changes Saved","editedGroupHub.message":"Your group has been updated.","leftGroupHub.title":"Goodbye","leftGroupHub.message":"You are no longer a member of this group and will not receive future updates.","deletedGroupHub.title":"Deleted","deletedGroupHub.message":"The group has been deleted.","groupHubCreated.title":"Group Created","groupHubCreated.message":"{groupHubName} is ready to use","accountClosed.title":"Account Closed","accountClosed.message":"The account has been closed and you will now be redirected to the homepage","resetTokenExpired.title":"Reset Password Link has Expired","resetTokenExpired.message":"Try resetting your password again","invalidUrl.title":"Invalid URL","invalidUrl.message":"The URL you're using is not recognized. Verify your URL and try again.","accountClosedForUser.title":"Account Closed","accountClosedForUser.message":"{userName}'s account is closed","inviteTokenInvalid.title":"Invitation Invalid","inviteTokenInvalid.message":"Your invitation to the community has been canceled or expired.","inviteTokenError.title":"Invitation Verification Failed","inviteTokenError.message":"The url you are utilizing is not recognized. Verify your URL and try again","pageNotFound.title":"Access Denied","pageNotFound.message":"You do not have access to this area of the community or it doesn't exist","eventAttending.title":"Responded as Attending","eventAttending.message":"You'll be notified when there's new activity and reminded as the event approaches","eventInterested.title":"Responded as Interested","eventInterested.message":"You'll be notified when there's new activity and reminded as the event approaches","eventNotFound.title":"Event Not Found","eventNotFound.message":"The event you tried to respond to does not exist.","redirectToRelatedPage.title":"Showing Related Content","redirectToRelatedPageForBaseUsers.title":"Showing Related Content","redirectToRelatedPageForBaseUsers.message":"The content you are trying to access is archived","redirectToRelatedPage.message":"The content you are trying to access is archived","relatedUrl.archivalLink.flyoutMessage":"The content you are trying to access is archived View Archived Content"},"localOverride":false},"CachedAsset:component:custom.widget.community_banner-en-1745485729404":{"__typename":"CachedAsset","id":"component:custom.widget.community_banner-en-1745485729404","value":{"component":{"id":"custom.widget.community_banner","template":{"id":"community_banner","markupLanguage":"HANDLEBARS","style":".community-banner {\n a.top-bar.btn {\n top: 0px;\n width: 100%;\n z-index: 999;\n text-align: center;\n left: 0px;\n background: #0068b8;\n color: white;\n padding: 10px 0px;\n display: block;\n box-shadow: none !important;\n border: none !important;\n border-radius: none !important;\n margin: 0px !important;\n font-size: 14px;\n }\n}\n","texts":null,"defaults":{"config":{"applicablePages":[],"description":"community announcement text","fetchedContent":null,"__typename":"ComponentConfiguration"},"props":[],"__typename":"ComponentProperties"},"components":[{"id":"custom.widget.community_banner","form":null,"config":null,"props":[],"__typename":"Component"}],"grouping":"CUSTOM","__typename":"ComponentTemplate"},"properties":{"config":{"applicablePages":[],"description":"community announcement text","fetchedContent":null,"__typename":"ComponentConfiguration"},"props":[],"__typename":"ComponentProperties"},"form":null,"__typename":"Component","localOverride":false},"globalCss":{"css":".custom_widget_community_banner_community-banner_1x9u2_1 {\n a.custom_widget_community_banner_top-bar_1x9u2_2.custom_widget_community_banner_btn_1x9u2_2 {\n top: 0;\n width: 100%;\n z-index: 999;\n text-align: center;\n left: 0;\n background: #0068b8;\n color: white;\n padding: 0.625rem 0;\n display: block;\n box-shadow: none !important;\n border: none !important;\n border-radius: none !important;\n margin: 0 !important;\n font-size: 0.875rem;\n }\n}\n","tokens":{"community-banner":"custom_widget_community_banner_community-banner_1x9u2_1","top-bar":"custom_widget_community_banner_top-bar_1x9u2_2","btn":"custom_widget_community_banner_btn_1x9u2_2"}},"form":null},"localOverride":false},"CachedAsset:component:custom.widget.HeroBanner-en-1745485729404":{"__typename":"CachedAsset","id":"component:custom.widget.HeroBanner-en-1745485729404","value":{"component":{"id":"custom.widget.HeroBanner","template":{"id":"HeroBanner","markupLanguage":"REACT","style":null,"texts":{"searchPlaceholderText":"Search this community","followActionText":"Follow","unfollowActionText":"Following","searchOnHoverText":"Please enter your search term(s) and then press return key to complete a search.","blogs.sidebar.pagetitle":"Latest Blogs | Microsoft Tech Community","followThisNode":"Follow this node","unfollowThisNode":"Unfollow this node"},"defaults":{"config":{"applicablePages":[],"description":null,"fetchedContent":null,"__typename":"ComponentConfiguration"},"props":[{"id":"max_items","dataType":"NUMBER","list":false,"defaultValue":"3","label":"Max Items","description":"The maximum number of items to display in the carousel","possibleValues":null,"control":"INPUT","__typename":"PropDefinition"}],"__typename":"ComponentProperties"},"components":[{"id":"custom.widget.HeroBanner","form":{"fields":[{"id":"widgetChooser","validation":null,"noValidation":null,"dataType":"STRING","list":null,"control":null,"defaultValue":null,"label":null,"description":null,"possibleValues":null,"__typename":"FormField"},{"id":"title","validation":null,"noValidation":null,"dataType":"STRING","list":null,"control":null,"defaultValue":null,"label":null,"description":null,"possibleValues":null,"__typename":"FormField"},{"id":"useTitle","validation":null,"noValidation":null,"dataType":"BOOLEAN","list":null,"control":null,"defaultValue":null,"label":null,"description":null,"possibleValues":null,"__typename":"FormField"},{"id":"useBackground","validation":null,"noValidation":null,"dataType":"BOOLEAN","list":null,"control":null,"defaultValue":null,"label":null,"description":null,"possibleValues":null,"__typename":"FormField"},{"id":"widgetVisibility","validation":null,"noValidation":null,"dataType":"STRING","list":null,"control":null,"defaultValue":null,"label":null,"description":null,"possibleValues":null,"__typename":"FormField"},{"id":"moreOptions","validation":null,"noValidation":null,"dataType":"STRING","list":null,"control":null,"defaultValue":null,"label":null,"description":null,"possibleValues":null,"__typename":"FormField"},{"id":"cMax_items","validation":null,"noValidation":null,"dataType":"NUMBER","list":false,"control":"INPUT","defaultValue":"3","label":"Max Items","description":"The maximum number of items to display in the carousel","possibleValues":null,"__typename":"FormField"}],"layout":{"rows":[{"id":"widgetChooserGroup","type":"fieldset","as":null,"items":[{"id":"widgetChooser","className":null,"__typename":"FormFieldRef"}],"props":null,"legend":null,"description":null,"className":null,"viewVariant":null,"toggleState":null,"__typename":"FormFieldset"},{"id":"titleGroup","type":"fieldset","as":null,"items":[{"id":"title","className":null,"__typename":"FormFieldRef"},{"id":"useTitle","className":null,"__typename":"FormFieldRef"}],"props":null,"legend":null,"description":null,"className":null,"viewVariant":null,"toggleState":null,"__typename":"FormFieldset"},{"id":"useBackground","type":"fieldset","as":null,"items":[{"id":"useBackground","className":null,"__typename":"FormFieldRef"}],"props":null,"legend":null,"description":null,"className":null,"viewVariant":null,"toggleState":null,"__typename":"FormFieldset"},{"id":"widgetVisibility","type":"fieldset","as":null,"items":[{"id":"widgetVisibility","className":null,"__typename":"FormFieldRef"}],"props":null,"legend":null,"description":null,"className":null,"viewVariant":null,"toggleState":null,"__typename":"FormFieldset"},{"id":"moreOptionsGroup","type":"fieldset","as":null,"items":[{"id":"moreOptions","className":null,"__typename":"FormFieldRef"}],"props":null,"legend":null,"description":null,"className":null,"viewVariant":null,"toggleState":null,"__typename":"FormFieldset"},{"id":"componentPropsGroup","type":"fieldset","as":null,"items":[{"id":"cMax_items","className":null,"__typename":"FormFieldRef"}],"props":null,"legend":null,"description":null,"className":null,"viewVariant":null,"toggleState":null,"__typename":"FormFieldset"}],"actionButtons":null,"className":"custom_widget_HeroBanner_form","formGroupFieldSeparator":"divider","__typename":"FormLayout"},"__typename":"Form"},"config":null,"props":[],"__typename":"Component"}],"grouping":"CUSTOM","__typename":"ComponentTemplate"},"properties":{"config":{"applicablePages":[],"description":null,"fetchedContent":null,"__typename":"ComponentConfiguration"},"props":[{"id":"max_items","dataType":"NUMBER","list":false,"defaultValue":"3","label":"Max Items","description":"The maximum number of items to display in the carousel","possibleValues":null,"control":"INPUT","__typename":"PropDefinition"}],"__typename":"ComponentProperties"},"form":{"fields":[{"id":"widgetChooser","validation":null,"noValidation":null,"dataType":"STRING","list":null,"control":null,"defaultValue":null,"label":null,"description":null,"possibleValues":null,"__typename":"FormField"},{"id":"title","validation":null,"noValidation":null,"dataType":"STRING","list":null,"control":null,"defaultValue":null,"label":null,"description":null,"possibleValues":null,"__typename":"FormField"},{"id":"useTitle","validation":null,"noValidation":null,"dataType":"BOOLEAN","list":null,"control":null,"defaultValue":null,"label":null,"description":null,"possibleValues":null,"__typename":"FormField"},{"id":"useBackground","validation":null,"noValidation":null,"dataType":"BOOLEAN","list":null,"control":null,"defaultValue":null,"label":null,"description":null,"possibleValues":null,"__typename":"FormField"},{"id":"widgetVisibility","validation":null,"noValidation":null,"dataType":"STRING","list":null,"control":null,"defaultValue":null,"label":null,"description":null,"possibleValues":null,"__typename":"FormField"},{"id":"moreOptions","validation":null,"noValidation":null,"dataType":"STRING","list":null,"control":null,"defaultValue":null,"label":null,"description":null,"possibleValues":null,"__typename":"FormField"},{"id":"cMax_items","validation":null,"noValidation":null,"dataType":"NUMBER","list":false,"control":"INPUT","defaultValue":"3","label":"Max Items","description":"The maximum number of items to display in the carousel","possibleValues":null,"__typename":"FormField"}],"layout":{"rows":[{"id":"widgetChooserGroup","type":"fieldset","as":null,"items":[{"id":"widgetChooser","className":null,"__typename":"FormFieldRef"}],"props":null,"legend":null,"description":null,"className":null,"viewVariant":null,"toggleState":null,"__typename":"FormFieldset"},{"id":"titleGroup","type":"fieldset","as":null,"items":[{"id":"title","className":null,"__typename":"FormFieldRef"},{"id":"useTitle","className":null,"__typename":"FormFieldRef"}],"props":null,"legend":null,"description":null,"className":null,"viewVariant":null,"toggleState":null,"__typename":"FormFieldset"},{"id":"useBackground","type":"fieldset","as":null,"items":[{"id":"useBackground","className":null,"__typename":"FormFieldRef"}],"props":null,"legend":null,"description":null,"className":null,"viewVariant":null,"toggleState":null,"__typename":"FormFieldset"},{"id":"widgetVisibility","type":"fieldset","as":null,"items":[{"id":"widgetVisibility","className":null,"__typename":"FormFieldRef"}],"props":null,"legend":null,"description":null,"className":null,"viewVariant":null,"toggleState":null,"__typename":"FormFieldset"},{"id":"moreOptionsGroup","type":"fieldset","as":null,"items":[{"id":"moreOptions","className":null,"__typename":"FormFieldRef"}],"props":null,"legend":null,"description":null,"className":null,"viewVariant":null,"toggleState":null,"__typename":"FormFieldset"},{"id":"componentPropsGroup","type":"fieldset","as":null,"items":[{"id":"cMax_items","className":null,"__typename":"FormFieldRef"}],"props":null,"legend":null,"description":null,"className":null,"viewVariant":null,"toggleState":null,"__typename":"FormFieldset"}],"actionButtons":null,"className":"custom_widget_HeroBanner_form","formGroupFieldSeparator":"divider","__typename":"FormLayout"},"__typename":"Form"},"__typename":"Component","localOverride":false},"globalCss":null,"form":{"fields":[{"id":"widgetChooser","validation":null,"noValidation":null,"dataType":"STRING","list":null,"control":null,"defaultValue":null,"label":null,"description":null,"possibleValues":null,"__typename":"FormField"},{"id":"title","validation":null,"noValidation":null,"dataType":"STRING","list":null,"control":null,"defaultValue":null,"label":null,"description":null,"possibleValues":null,"__typename":"FormField"},{"id":"useTitle","validation":null,"noValidation":null,"dataType":"BOOLEAN","list":null,"control":null,"defaultValue":null,"label":null,"description":null,"possibleValues":null,"__typename":"FormField"},{"id":"useBackground","validation":null,"noValidation":null,"dataType":"BOOLEAN","list":null,"control":null,"defaultValue":null,"label":null,"description":null,"possibleValues":null,"__typename":"FormField"},{"id":"widgetVisibility","validation":null,"noValidation":null,"dataType":"STRING","list":null,"control":null,"defaultValue":null,"label":null,"description":null,"possibleValues":null,"__typename":"FormField"},{"id":"moreOptions","validation":null,"noValidation":null,"dataType":"STRING","list":null,"control":null,"defaultValue":null,"label":null,"description":null,"possibleValues":null,"__typename":"FormField"},{"id":"cMax_items","validation":null,"noValidation":null,"dataType":"NUMBER","list":false,"control":"INPUT","defaultValue":"3","label":"Max Items","description":"The maximum number of items to display in the carousel","possibleValues":null,"__typename":"FormField"}],"layout":{"rows":[{"id":"widgetChooserGroup","type":"fieldset","as":null,"items":[{"id":"widgetChooser","className":null,"__typename":"FormFieldRef"}],"props":null,"legend":null,"description":null,"className":null,"viewVariant":null,"toggleState":null,"__typename":"FormFieldset"},{"id":"titleGroup","type":"fieldset","as":null,"items":[{"id":"title","className":null,"__typename":"FormFieldRef"},{"id":"useTitle","className":null,"__typename":"FormFieldRef"}],"props":null,"legend":null,"description":null,"className":null,"viewVariant":null,"toggleState":null,"__typename":"FormFieldset"},{"id":"useBackground","type":"fieldset","as":null,"items":[{"id":"useBackground","className":null,"__typename":"FormFieldRef"}],"props":null,"legend":null,"description":null,"className":null,"viewVariant":null,"toggleState":null,"__typename":"FormFieldset"},{"id":"widgetVisibility","type":"fieldset","as":null,"items":[{"id":"widgetVisibility","className":null,"__typename":"FormFieldRef"}],"props":null,"legend":null,"description":null,"className":null,"viewVariant":null,"toggleState":null,"__typename":"FormFieldset"},{"id":"moreOptionsGroup","type":"fieldset","as":null,"items":[{"id":"moreOptions","className":null,"__typename":"FormFieldRef"}],"props":null,"legend":null,"description":null,"className":null,"viewVariant":null,"toggleState":null,"__typename":"FormFieldset"},{"id":"componentPropsGroup","type":"fieldset","as":null,"items":[{"id":"cMax_items","className":null,"__typename":"FormFieldRef"}],"props":null,"legend":null,"description":null,"className":null,"viewVariant":null,"toggleState":null,"__typename":"FormFieldset"}],"actionButtons":null,"className":"custom_widget_HeroBanner_form","formGroupFieldSeparator":"divider","__typename":"FormLayout"},"__typename":"Form"}},"localOverride":false},"CachedAsset:component:custom.widget.Featured_Resources-en-1745485729404":{"__typename":"CachedAsset","id":"component:custom.widget.Featured_Resources-en-1745485729404","value":{"component":{"id":"custom.widget.Featured_Resources","template":{"id":"Featured_Resources","markupLanguage":"REACT","style":null,"texts":{"resourceTitle":"Title","titlePlaceholder":"Resource title","urlPlaceholder":"Resource URL","resourceUrl":"URL","addResource":"Add Resource","cancel":"Cancel","removeResource":"Remove Resource","error":"Error","itemNotSaved":"Item not saved. {message}","errorMessage":"An error occurred. Please try again."},"defaults":{"config":{"applicablePages":[],"description":null,"fetchedContent":null,"__typename":"ComponentConfiguration"},"props":[],"__typename":"ComponentProperties"},"components":[{"id":"custom.widget.Featured_Resources","form":null,"config":null,"props":[],"__typename":"Component"}],"grouping":"CUSTOM","__typename":"ComponentTemplate"},"properties":{"config":{"applicablePages":[],"description":null,"fetchedContent":null,"__typename":"ComponentConfiguration"},"props":[],"__typename":"ComponentProperties"},"form":null,"__typename":"Component","localOverride":false},"globalCss":null,"form":null},"localOverride":false},"CachedAsset:component:custom.widget.MicrosoftFooter-en-1745485729404":{"__typename":"CachedAsset","id":"component:custom.widget.MicrosoftFooter-en-1745485729404","value":{"component":{"id":"custom.widget.MicrosoftFooter","template":{"id":"MicrosoftFooter","markupLanguage":"HANDLEBARS","style":".context-uhf {\n min-width: 280px;\n font-size: 15px;\n box-sizing: border-box;\n -ms-text-size-adjust: 100%;\n -webkit-text-size-adjust: 100%;\n & *,\n & *:before,\n & *:after {\n box-sizing: inherit;\n }\n a.c-uhff-link {\n color: #616161;\n word-break: break-word;\n text-decoration: none;\n }\n &a:link,\n &a:focus,\n &a:hover,\n &a:active,\n &a:visited {\n text-decoration: none;\n color: inherit;\n }\n & div {\n font-family: 'Segoe UI', SegoeUI, 'Helvetica Neue', Helvetica, Arial, sans-serif;\n }\n}\n.c-uhff {\n background: #f2f2f2;\n margin: -1.5625;\n width: auto;\n height: auto;\n}\n.c-uhff-nav {\n margin: 0 auto;\n max-width: calc(1600px + 10%);\n padding: 0 5%;\n box-sizing: inherit;\n &:before,\n &:after {\n content: ' ';\n display: table;\n clear: left;\n }\n @media only screen and (max-width: 1083px) {\n padding-left: 12px;\n }\n .c-heading-4 {\n color: #616161;\n word-break: break-word;\n font-size: 15px;\n line-height: 20px;\n padding: 36px 0 4px;\n font-weight: 600;\n }\n .c-uhff-nav-row {\n .c-uhff-nav-group {\n display: block;\n float: left;\n min-height: 1px;\n vertical-align: text-top;\n padding: 0 12px;\n width: 100%;\n zoom: 1;\n &:first-child {\n padding-left: 0;\n @media only screen and (max-width: 1083px) {\n padding-left: 12px;\n }\n }\n @media only screen and (min-width: 540px) and (max-width: 1082px) {\n width: 33.33333%;\n }\n @media only screen and (min-width: 1083px) {\n width: 16.6666666667%;\n }\n ul.c-list.f-bare {\n font-size: 11px;\n line-height: 16px;\n margin-top: 0;\n margin-bottom: 0;\n padding-left: 0;\n list-style-type: none;\n li {\n word-break: break-word;\n padding: 8px 0;\n margin: 0;\n }\n }\n }\n }\n}\n.c-uhff-base {\n background: #f2f2f2;\n margin: 0 auto;\n max-width: calc(1600px + 10%);\n padding: 30px 5% 16px;\n &:before,\n &:after {\n content: ' ';\n display: table;\n }\n &:after {\n clear: both;\n }\n a.c-uhff-ccpa {\n font-size: 11px;\n line-height: 16px;\n float: left;\n margin: 3px 0;\n }\n a.c-uhff-ccpa:hover {\n text-decoration: underline;\n }\n ul.c-list {\n font-size: 11px;\n line-height: 16px;\n float: right;\n margin: 3px 0;\n color: #616161;\n li {\n padding: 0 24px 4px 0;\n display: inline-block;\n }\n }\n .c-list.f-bare {\n padding-left: 0;\n list-style-type: none;\n }\n @media only screen and (max-width: 1083px) {\n display: flex;\n flex-wrap: wrap;\n padding: 30px 24px 16px;\n }\n}\n\n.social-share {\n position: fixed;\n top: 60%;\n transform: translateY(-50%);\n left: 0;\n z-index: 1000;\n}\n\n.sharing-options {\n list-style: none;\n padding: 0;\n margin: 0;\n display: block;\n flex-direction: column;\n background-color: white;\n width: 43px;\n border-radius: 0px 7px 7px 0px;\n}\n.linkedin-icon {\n border-top-right-radius: 7px;\n}\n.linkedin-icon:hover {\n border-radius: 0;\n}\n.social-share-rss-image {\n border-bottom-right-radius: 7px;\n}\n.social-share-rss-image:hover {\n border-radius: 0;\n}\n\n.social-link-footer {\n position: relative;\n display: block;\n margin: -2px 0;\n transition: all 0.2s ease;\n}\n.social-link-footer:hover .linkedin-icon {\n border-radius: 0;\n}\n.social-link-footer:hover .social-share-rss-image {\n border-radius: 0;\n}\n\n.social-link-footer img {\n width: 40px;\n height: auto;\n transition: filter 0.3s ease;\n}\n\n.social-share-list {\n width: 40px;\n}\n.social-share-rss-image {\n width: 40px;\n}\n\n.share-icon {\n border: 2px solid transparent;\n display: inline-block;\n position: relative;\n}\n\n.share-icon:hover {\n opacity: 1;\n border: 2px solid white;\n box-sizing: border-box;\n}\n\n.share-icon:hover .label {\n opacity: 1;\n visibility: visible;\n border: 2px solid white;\n box-sizing: border-box;\n border-left: none;\n}\n\n.label {\n position: absolute;\n left: 100%;\n white-space: nowrap;\n opacity: 0;\n visibility: hidden;\n transition: all 0.2s ease;\n color: white;\n border-radius: 0 10 0 10px;\n top: 50%;\n transform: translateY(-50%);\n height: 40px;\n border-radius: 0 6px 6px 0;\n display: flex;\n align-items: center;\n justify-content: center;\n padding: 20px 5px 20px 8px;\n margin-left: -1px;\n}\n.linkedin {\n background-color: #0474b4;\n}\n.facebook {\n background-color: #3c5c9c;\n}\n.twitter {\n background-color: white;\n color: black;\n}\n.reddit {\n background-color: #fc4404;\n}\n.mail {\n background-color: #848484;\n}\n.bluesky {\n background-color: white;\n color: black;\n}\n.rss {\n background-color: #ec7b1c;\n}\n#RSS {\n width: 40px;\n height: 40px;\n}\n\n@media (max-width: 991px) {\n .social-share {\n display: none;\n }\n}\n","texts":{"New tab":"What's New","New 1":"Surface Laptop Studio 2","New 2":"Surface Laptop Go 3","New 3":"Surface Pro 9","New 4":"Surface Laptop 5","New 5":"Surface Studio 2+","New 6":"Copilot in Windows","New 7":"Microsoft 365","New 8":"Windows 11 apps","Store tab":"Microsoft Store","Store 1":"Account Profile","Store 2":"Download Center","Store 3":"Microsoft Store Support","Store 4":"Returns","Store 5":"Order tracking","Store 6":"Certified Refurbished","Store 7":"Microsoft Store Promise","Store 8":"Flexible Payments","Education tab":"Education","Edu 1":"Microsoft in education","Edu 2":"Devices for education","Edu 3":"Microsoft Teams for Education","Edu 4":"Microsoft 365 Education","Edu 5":"How to buy for your school","Edu 6":"Educator Training and development","Edu 7":"Deals for students and parents","Edu 8":"Azure for students","Business tab":"Business","Bus 1":"Microsoft Cloud","Bus 2":"Microsoft Security","Bus 3":"Dynamics 365","Bus 4":"Microsoft 365","Bus 5":"Microsoft Power Platform","Bus 6":"Microsoft Teams","Bus 7":"Microsoft Industry","Bus 8":"Small Business","Developer tab":"Developer & IT","Dev 1":"Azure","Dev 2":"Developer Center","Dev 3":"Documentation","Dev 4":"Microsoft Learn","Dev 5":"Microsoft Tech Community","Dev 6":"Azure Marketplace","Dev 7":"AppSource","Dev 8":"Visual Studio","Company tab":"Company","Com 1":"Careers","Com 2":"About Microsoft","Com 3":"Company News","Com 4":"Privacy at Microsoft","Com 5":"Investors","Com 6":"Diversity and inclusion","Com 7":"Accessiblity","Com 8":"Sustainibility"},"defaults":{"config":{"applicablePages":[],"description":"The Microsoft Footer","fetchedContent":null,"__typename":"ComponentConfiguration"},"props":[],"__typename":"ComponentProperties"},"components":[{"id":"custom.widget.MicrosoftFooter","form":null,"config":null,"props":[],"__typename":"Component"}],"grouping":"CUSTOM","__typename":"ComponentTemplate"},"properties":{"config":{"applicablePages":[],"description":"The Microsoft Footer","fetchedContent":null,"__typename":"ComponentConfiguration"},"props":[],"__typename":"ComponentProperties"},"form":null,"__typename":"Component","localOverride":false},"globalCss":{"css":".custom_widget_MicrosoftFooter_context-uhf_105bp_1 {\n min-width: 17.5rem;\n font-size: 0.9375rem;\n box-sizing: border-box;\n -ms-text-size-adjust: 100%;\n -webkit-text-size-adjust: 100%;\n & *,\n & *:before,\n & *:after {\n box-sizing: inherit;\n }\n a.custom_widget_MicrosoftFooter_c-uhff-link_105bp_12 {\n color: #616161;\n word-break: break-word;\n text-decoration: none;\n }\n &a:link,\n &a:focus,\n &a:hover,\n &a:active,\n &a:visited {\n text-decoration: none;\n color: inherit;\n }\n & div {\n font-family: 'Segoe UI', SegoeUI, 'Helvetica Neue', Helvetica, Arial, sans-serif;\n }\n}\n.custom_widget_MicrosoftFooter_c-uhff_105bp_12 {\n background: #f2f2f2;\n margin: -1.5625;\n width: auto;\n height: auto;\n}\n.custom_widget_MicrosoftFooter_c-uhff-nav_105bp_35 {\n margin: 0 auto;\n max-width: calc(100rem + 10%);\n padding: 0 5%;\n box-sizing: inherit;\n &:before,\n &:after {\n content: ' ';\n display: table;\n clear: left;\n }\n @media only screen and (max-width: 1083px) {\n padding-left: 0.75rem;\n }\n .custom_widget_MicrosoftFooter_c-heading-4_105bp_49 {\n color: #616161;\n word-break: break-word;\n font-size: 0.9375rem;\n line-height: 1.25rem;\n padding: 2.25rem 0 0.25rem;\n font-weight: 600;\n }\n .custom_widget_MicrosoftFooter_c-uhff-nav-row_105bp_57 {\n .custom_widget_MicrosoftFooter_c-uhff-nav-group_105bp_58 {\n display: block;\n float: left;\n min-height: 0.0625rem;\n vertical-align: text-top;\n padding: 0 0.75rem;\n width: 100%;\n zoom: 1;\n &:first-child {\n padding-left: 0;\n @media only screen and (max-width: 1083px) {\n padding-left: 0.75rem;\n }\n }\n @media only screen and (min-width: 540px) and (max-width: 1082px) {\n width: 33.33333%;\n }\n @media only screen and (min-width: 1083px) {\n width: 16.6666666667%;\n }\n ul.custom_widget_MicrosoftFooter_c-list_105bp_78.custom_widget_MicrosoftFooter_f-bare_105bp_78 {\n font-size: 0.6875rem;\n line-height: 1rem;\n margin-top: 0;\n margin-bottom: 0;\n padding-left: 0;\n list-style-type: none;\n li {\n word-break: break-word;\n padding: 0.5rem 0;\n margin: 0;\n }\n }\n }\n }\n}\n.custom_widget_MicrosoftFooter_c-uhff-base_105bp_94 {\n background: #f2f2f2;\n margin: 0 auto;\n max-width: calc(100rem + 10%);\n padding: 1.875rem 5% 1rem;\n &:before,\n &:after {\n content: ' ';\n display: table;\n }\n &:after {\n clear: both;\n }\n a.custom_widget_MicrosoftFooter_c-uhff-ccpa_105bp_107 {\n font-size: 0.6875rem;\n line-height: 1rem;\n float: left;\n margin: 0.1875rem 0;\n }\n a.custom_widget_MicrosoftFooter_c-uhff-ccpa_105bp_107:hover {\n text-decoration: underline;\n }\n ul.custom_widget_MicrosoftFooter_c-list_105bp_78 {\n font-size: 0.6875rem;\n line-height: 1rem;\n float: right;\n margin: 0.1875rem 0;\n color: #616161;\n li {\n padding: 0 1.5rem 0.25rem 0;\n display: inline-block;\n }\n }\n .custom_widget_MicrosoftFooter_c-list_105bp_78.custom_widget_MicrosoftFooter_f-bare_105bp_78 {\n padding-left: 0;\n list-style-type: none;\n }\n @media only screen and (max-width: 1083px) {\n display: flex;\n flex-wrap: wrap;\n padding: 1.875rem 1.5rem 1rem;\n }\n}\n.custom_widget_MicrosoftFooter_social-share_105bp_138 {\n position: fixed;\n top: 60%;\n transform: translateY(-50%);\n left: 0;\n z-index: 1000;\n}\n.custom_widget_MicrosoftFooter_sharing-options_105bp_146 {\n list-style: none;\n padding: 0;\n margin: 0;\n display: block;\n flex-direction: column;\n background-color: white;\n width: 2.6875rem;\n border-radius: 0 0.4375rem 0.4375rem 0;\n}\n.custom_widget_MicrosoftFooter_linkedin-icon_105bp_156 {\n border-top-right-radius: 7px;\n}\n.custom_widget_MicrosoftFooter_linkedin-icon_105bp_156:hover {\n border-radius: 0;\n}\n.custom_widget_MicrosoftFooter_social-share-rss-image_105bp_162 {\n border-bottom-right-radius: 7px;\n}\n.custom_widget_MicrosoftFooter_social-share-rss-image_105bp_162:hover {\n border-radius: 0;\n}\n.custom_widget_MicrosoftFooter_social-link-footer_105bp_169 {\n position: relative;\n display: block;\n margin: -0.125rem 0;\n transition: all 0.2s ease;\n}\n.custom_widget_MicrosoftFooter_social-link-footer_105bp_169:hover .custom_widget_MicrosoftFooter_linkedin-icon_105bp_156 {\n border-radius: 0;\n}\n.custom_widget_MicrosoftFooter_social-link-footer_105bp_169:hover .custom_widget_MicrosoftFooter_social-share-rss-image_105bp_162 {\n border-radius: 0;\n}\n.custom_widget_MicrosoftFooter_social-link-footer_105bp_169 img {\n width: 2.5rem;\n height: auto;\n transition: filter 0.3s ease;\n}\n.custom_widget_MicrosoftFooter_social-share-list_105bp_188 {\n width: 2.5rem;\n}\n.custom_widget_MicrosoftFooter_social-share-rss-image_105bp_162 {\n width: 2.5rem;\n}\n.custom_widget_MicrosoftFooter_share-icon_105bp_195 {\n border: 2px solid transparent;\n display: inline-block;\n position: relative;\n}\n.custom_widget_MicrosoftFooter_share-icon_105bp_195:hover {\n opacity: 1;\n border: 2px solid white;\n box-sizing: border-box;\n}\n.custom_widget_MicrosoftFooter_share-icon_105bp_195:hover .custom_widget_MicrosoftFooter_label_105bp_207 {\n opacity: 1;\n visibility: visible;\n border: 2px solid white;\n box-sizing: border-box;\n border-left: none;\n}\n.custom_widget_MicrosoftFooter_label_105bp_207 {\n position: absolute;\n left: 100%;\n white-space: nowrap;\n opacity: 0;\n visibility: hidden;\n transition: all 0.2s ease;\n color: white;\n border-radius: 0 10 0 0.625rem;\n top: 50%;\n transform: translateY(-50%);\n height: 2.5rem;\n border-radius: 0 0.375rem 0.375rem 0;\n display: flex;\n align-items: center;\n justify-content: center;\n padding: 1.25rem 0.3125rem 1.25rem 0.5rem;\n margin-left: -0.0625rem;\n}\n.custom_widget_MicrosoftFooter_linkedin_105bp_156 {\n background-color: #0474b4;\n}\n.custom_widget_MicrosoftFooter_facebook_105bp_237 {\n background-color: #3c5c9c;\n}\n.custom_widget_MicrosoftFooter_twitter_105bp_240 {\n background-color: white;\n color: black;\n}\n.custom_widget_MicrosoftFooter_reddit_105bp_244 {\n background-color: #fc4404;\n}\n.custom_widget_MicrosoftFooter_mail_105bp_247 {\n background-color: #848484;\n}\n.custom_widget_MicrosoftFooter_bluesky_105bp_250 {\n background-color: white;\n color: black;\n}\n.custom_widget_MicrosoftFooter_rss_105bp_254 {\n background-color: #ec7b1c;\n}\n#custom_widget_MicrosoftFooter_RSS_105bp_1 {\n width: 2.5rem;\n height: 2.5rem;\n}\n@media (max-width: 991px) {\n .custom_widget_MicrosoftFooter_social-share_105bp_138 {\n display: none;\n }\n}\n","tokens":{"context-uhf":"custom_widget_MicrosoftFooter_context-uhf_105bp_1","c-uhff-link":"custom_widget_MicrosoftFooter_c-uhff-link_105bp_12","c-uhff":"custom_widget_MicrosoftFooter_c-uhff_105bp_12","c-uhff-nav":"custom_widget_MicrosoftFooter_c-uhff-nav_105bp_35","c-heading-4":"custom_widget_MicrosoftFooter_c-heading-4_105bp_49","c-uhff-nav-row":"custom_widget_MicrosoftFooter_c-uhff-nav-row_105bp_57","c-uhff-nav-group":"custom_widget_MicrosoftFooter_c-uhff-nav-group_105bp_58","c-list":"custom_widget_MicrosoftFooter_c-list_105bp_78","f-bare":"custom_widget_MicrosoftFooter_f-bare_105bp_78","c-uhff-base":"custom_widget_MicrosoftFooter_c-uhff-base_105bp_94","c-uhff-ccpa":"custom_widget_MicrosoftFooter_c-uhff-ccpa_105bp_107","social-share":"custom_widget_MicrosoftFooter_social-share_105bp_138","sharing-options":"custom_widget_MicrosoftFooter_sharing-options_105bp_146","linkedin-icon":"custom_widget_MicrosoftFooter_linkedin-icon_105bp_156","social-share-rss-image":"custom_widget_MicrosoftFooter_social-share-rss-image_105bp_162","social-link-footer":"custom_widget_MicrosoftFooter_social-link-footer_105bp_169","social-share-list":"custom_widget_MicrosoftFooter_social-share-list_105bp_188","share-icon":"custom_widget_MicrosoftFooter_share-icon_105bp_195","label":"custom_widget_MicrosoftFooter_label_105bp_207","linkedin":"custom_widget_MicrosoftFooter_linkedin_105bp_156","facebook":"custom_widget_MicrosoftFooter_facebook_105bp_237","twitter":"custom_widget_MicrosoftFooter_twitter_105bp_240","reddit":"custom_widget_MicrosoftFooter_reddit_105bp_244","mail":"custom_widget_MicrosoftFooter_mail_105bp_247","bluesky":"custom_widget_MicrosoftFooter_bluesky_105bp_250","rss":"custom_widget_MicrosoftFooter_rss_105bp_254","RSS":"custom_widget_MicrosoftFooter_RSS_105bp_1"}},"form":null},"localOverride":false},"CachedAsset:text:en_US-components/community/Breadcrumb-1745505309787":{"__typename":"CachedAsset","id":"text:en_US-components/community/Breadcrumb-1745505309787","value":{"navLabel":"Breadcrumbs","dropdown":"Additional parent page navigation"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageBanner-1745505309787":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageBanner-1745505309787","value":{"messageMarkedAsSpam":"This post has been marked as spam","messageMarkedAsSpam@board:TKB":"This article has been marked as spam","messageMarkedAsSpam@board:BLOG":"This post has been marked as spam","messageMarkedAsSpam@board:FORUM":"This discussion has been marked as spam","messageMarkedAsSpam@board:OCCASION":"This event has been marked as spam","messageMarkedAsSpam@board:IDEA":"This idea has been marked as spam","manageSpam":"Manage Spam","messageMarkedAsAbuse":"This post has been marked as abuse","messageMarkedAsAbuse@board:TKB":"This article has been marked as abuse","messageMarkedAsAbuse@board:BLOG":"This post has been marked as abuse","messageMarkedAsAbuse@board:FORUM":"This discussion has been marked as abuse","messageMarkedAsAbuse@board:OCCASION":"This event has been marked as abuse","messageMarkedAsAbuse@board:IDEA":"This idea has been marked as abuse","preModCommentAuthorText":"This comment will be published as soon as it is approved","preModCommentModeratorText":"This comment is awaiting moderation","messageMarkedAsOther":"This post has been rejected due to other reasons","messageMarkedAsOther@board:TKB":"This article has been rejected due to other reasons","messageMarkedAsOther@board:BLOG":"This post has been rejected due to other reasons","messageMarkedAsOther@board:FORUM":"This discussion has been rejected due to other reasons","messageMarkedAsOther@board:OCCASION":"This event has been rejected due to other reasons","messageMarkedAsOther@board:IDEA":"This idea has been rejected due to other reasons","messageArchived":"This post was archived on {date}","relatedUrl":"View Related Content","relatedContentText":"Showing related content","archivedContentLink":"View Archived Content"},"localOverride":false},"Category:category:Exchange":{"__typename":"Category","id":"category:Exchange","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:Outlook":{"__typename":"Category","id":"category:Outlook","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:Community-Info-Center":{"__typename":"Category","id":"category:Community-Info-Center","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:EducationSector":{"__typename":"Category","id":"category:EducationSector","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:DrivingAdoption":{"__typename":"Category","id":"category:DrivingAdoption","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:Azure":{"__typename":"Category","id":"category:Azure","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:Windows-Server":{"__typename":"Category","id":"category:Windows-Server","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:MicrosoftTeams":{"__typename":"Category","id":"category:MicrosoftTeams","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:PublicSector":{"__typename":"Category","id":"category:PublicSector","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:IoT":{"__typename":"Category","id":"category:IoT","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:HealthcareAndLifeSciences":{"__typename":"Category","id":"category:HealthcareAndLifeSciences","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:ITOpsTalk":{"__typename":"Category","id":"category:ITOpsTalk","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:MicrosoftLearn":{"__typename":"Category","id":"category:MicrosoftLearn","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Blog:board:MicrosoftLearnBlog":{"__typename":"Blog","id":"board:MicrosoftLearnBlog","blogPolicies":{"__typename":"BlogPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}},"boardPolicies":{"__typename":"BoardPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:AI":{"__typename":"Category","id":"category:AI","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:MicrosoftMechanics":{"__typename":"Category","id":"category:MicrosoftMechanics","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:MicrosoftforNonprofits":{"__typename":"Category","id":"category:MicrosoftforNonprofits","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:StartupsatMicrosoft":{"__typename":"Category","id":"category:StartupsatMicrosoft","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:PartnerCommunity":{"__typename":"Category","id":"category:PartnerCommunity","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:Microsoft365Copilot":{"__typename":"Category","id":"category:Microsoft365Copilot","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:Windows":{"__typename":"Category","id":"category:Windows","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:Content_Management":{"__typename":"Category","id":"category:Content_Management","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:microsoft-security":{"__typename":"Category","id":"category:microsoft-security","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"Category:category:microsoftintune":{"__typename":"Category","id":"category:microsoftintune","categoryPolicies":{"__typename":"CategoryPolicies","canReadNode":{"__typename":"PolicyResult","failureReason":null}}},"QueryVariables:TopicReplyList:message:2058369:1":{"__typename":"QueryVariables","id":"TopicReplyList:message:2058369:1","value":{"id":"message:2058369","first":10,"sorts":{"postTime":{"direction":"DESC"}},"repliesFirst":3,"repliesFirstDepthThree":1,"repliesSorts":{"postTime":{"direction":"DESC"}},"useAvatar":true,"useAuthorLogin":true,"useAuthorRank":true,"useBody":true,"useKudosCount":true,"useTimeToRead":false,"useMedia":false,"useReadOnlyIcon":false,"useRepliesCount":true,"useSearchSnippet":false,"useAcceptedSolutionButton":true,"useSolvedBadge":false,"useAttachments":false,"attachmentsFirst":5,"useTags":true,"useNodeAncestors":false,"useUserHoverCard":false,"useNodeHoverCard":false,"useModerationStatus":true,"usePreviewSubjectModal":false,"useMessageStatus":true}},"ROOT_MUTATION":{"__typename":"Mutation"},"CachedAsset:text:en_US-components/community/Navbar-1745505309787":{"__typename":"CachedAsset","id":"text:en_US-components/community/Navbar-1745505309787","value":{"community":"Community Home","inbox":"Inbox","manageContent":"Manage Content","tos":"Terms of Service","forgotPassword":"Forgot Password","themeEditor":"Theme Editor","edit":"Edit Navigation Bar","skipContent":"Skip to content","gxcuf89792":"Tech Community","external-1":"Events","s-m-b":"Nonprofit Community","windows-server":"Windows Server","education-sector":"Education Sector","driving-adoption":"Driving Adoption","Common-content_management-link":"Content Management","microsoft-learn":"Microsoft Learn","s-q-l-server":"Content Management","partner-community":"Microsoft Partner Community","microsoft365":"Microsoft 365","external-9":".NET","external-8":"Teams","external-7":"Github","products-services":"Products","external-6":"Power Platform","communities-1":"Topics","external-5":"Microsoft Security","planner":"Outlook","external-4":"Microsoft 365","external-3":"Dynamics 365","azure":"Azure","healthcare-and-life-sciences":"Healthcare and Life Sciences","external-2":"Azure","microsoft-mechanics":"Microsoft Mechanics","microsoft-learn-1":"Community","external-10":"Learning Room Directory","microsoft-learn-blog":"Blog","windows":"Windows","i-t-ops-talk":"ITOps Talk","external-link-1":"View All","microsoft-securityand-compliance":"Microsoft Security","public-sector":"Public Sector","community-info-center":"Lounge","external-link-2":"View All","microsoft-teams":"Microsoft Teams","external":"Blogs","microsoft-endpoint-manager":"Microsoft Intune","startupsat-microsoft":"Startups at Microsoft","exchange":"Exchange","a-i":"AI and Machine Learning","io-t":"Internet of Things (IoT)","Common-microsoft365-copilot-link":"Microsoft 365 Copilot","outlook":"Microsoft 365 Copilot","external-link":"Community Hubs","communities":"Products"},"localOverride":false},"CachedAsset:text:en_US-components/community/NavbarHamburgerDropdown-1745505309787":{"__typename":"CachedAsset","id":"text:en_US-components/community/NavbarHamburgerDropdown-1745505309787","value":{"hamburgerLabel":"Side Menu"},"localOverride":false},"CachedAsset:text:en_US-components/community/BrandLogo-1745505309787":{"__typename":"CachedAsset","id":"text:en_US-components/community/BrandLogo-1745505309787","value":{"logoAlt":"Khoros","themeLogoAlt":"Brand Logo"},"localOverride":false},"CachedAsset:text:en_US-components/community/NavbarTextLinks-1745505309787":{"__typename":"CachedAsset","id":"text:en_US-components/community/NavbarTextLinks-1745505309787","value":{"more":"More"},"localOverride":false},"CachedAsset:text:en_US-components/authentication/AuthenticationLink-1745505309787":{"__typename":"CachedAsset","id":"text:en_US-components/authentication/AuthenticationLink-1745505309787","value":{"title.login":"Sign In","title.registration":"Register","title.forgotPassword":"Forgot Password","title.multiAuthLogin":"Sign In"},"localOverride":false},"CachedAsset:text:en_US-components/nodes/NodeLink-1745505309787":{"__typename":"CachedAsset","id":"text:en_US-components/nodes/NodeLink-1745505309787","value":{"place":"Place {name}"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageView/MessageViewStandard-1745505309787":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageView/MessageViewStandard-1745505309787","value":{"anonymous":"Anonymous","author":"{messageAuthorLogin}","authorBy":"{messageAuthorLogin}","board":"{messageBoardTitle}","replyToUser":" to {parentAuthor}","showMoreReplies":"Show More","replyText":"Reply","repliesText":"Replies","markedAsSolved":"Marked as Solved","movedMessagePlaceholder.BLOG":"{count, plural, =0 {This comment has been} other {These comments have been} }","movedMessagePlaceholder.TKB":"{count, plural, =0 {This comment has been} other {These comments have been} }","movedMessagePlaceholder.FORUM":"{count, plural, =0 {This reply has been} other {These replies have been} }","movedMessagePlaceholder.IDEA":"{count, plural, =0 {This comment has been} other {These comments have been} }","movedMessagePlaceholder.OCCASION":"{count, plural, =0 {This comment has been} other {These comments have been} }","movedMessagePlaceholderUrlText":"moved.","messageStatus":"Status: ","statusChanged":"Status changed: {previousStatus} to {currentStatus}","statusAdded":"Status added: {status}","statusRemoved":"Status removed: {status}","labelExpand":"expand replies","labelCollapse":"collapse replies","unhelpfulReason.reason1":"Content is outdated","unhelpfulReason.reason2":"Article is missing information","unhelpfulReason.reason3":"Content is for a different Product","unhelpfulReason.reason4":"Doesn't match what I was searching for"},"localOverride":false},"CachedAsset:text:en_US-components/messages/ThreadedReplyList-1745505309787":{"__typename":"CachedAsset","id":"text:en_US-components/messages/ThreadedReplyList-1745505309787","value":{"title":"{count, plural, one{# Reply} other{# Replies}}","title@board:BLOG":"{count, plural, one{# Comment} other{# Comments}}","title@board:TKB":"{count, plural, one{# Comment} other{# Comments}}","title@board:IDEA":"{count, plural, one{# Comment} other{# Comments}}","title@board:OCCASION":"{count, plural, one{# Comment} other{# Comments}}","noRepliesTitle":"No Replies","noRepliesTitle@board:BLOG":"No Comments","noRepliesTitle@board:TKB":"No Comments","noRepliesTitle@board:IDEA":"No Comments","noRepliesTitle@board:OCCASION":"No Comments","noRepliesDescription":"Be the first to reply","noRepliesDescription@board:BLOG":"Be the first to comment","noRepliesDescription@board:TKB":"Be the first to comment","noRepliesDescription@board:IDEA":"Be the first to comment","noRepliesDescription@board:OCCASION":"Be the first to comment","messageReadOnlyAlert:BLOG":"Comments have been turned off for this post","messageReadOnlyAlert:TKB":"Comments have been turned off for this article","messageReadOnlyAlert:IDEA":"Comments have been turned off for this idea","messageReadOnlyAlert:FORUM":"Replies have been turned off for this discussion","messageReadOnlyAlert:OCCASION":"Comments have been turned off for this event"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageReplyCallToAction-1745505309787":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageReplyCallToAction-1745505309787","value":{"leaveReply":"Leave a reply...","leaveReply@board:BLOG@message:root":"Leave a comment...","leaveReply@board:TKB@message:root":"Leave a comment...","leaveReply@board:IDEA@message:root":"Leave a comment...","leaveReply@board:OCCASION@message:root":"Leave a comment...","repliesTurnedOff.FORUM":"Replies are turned off for this topic","repliesTurnedOff.BLOG":"Comments are turned off for this topic","repliesTurnedOff.TKB":"Comments are turned off for this topic","repliesTurnedOff.IDEA":"Comments are turned off for this topic","repliesTurnedOff.OCCASION":"Comments are turned off for this topic","infoText":"Stop poking me!"},"localOverride":false},"Rank:rank:5":{"__typename":"Rank","id":"rank:5","position":7,"name":"MVP","color":"0069D4","icon":null,"rankStyle":"FILLED"},"User:user:521":{"__typename":"User","id":"user:521","uid":521,"login":"SergeiBaklan","biography":null,"registrationData":{"__typename":"RegistrationData","status":null,"registrationTime":"2016-07-15T09:33:17.456-07:00"},"deleted":false,"email":"","avatar":{"__typename":"UserAvatar","url":"https://techcommunity.microsoft.com/t5/s/gxcuf89792/images/dS01MjEtaGNpQXhx?image-coordinates=761%2C556%2C2907%2C2703"},"rank":{"__ref":"Rank:rank:5"},"entityType":"USER","eventPath":"community:gxcuf89792/user:521"},"ModerationData:moderation_data:2060297":{"__typename":"ModerationData","id":"moderation_data:2060297","status":"APPROVED","rejectReason":null,"isReportedAbuse":false,"rejectUser":null,"rejectTime":null,"rejectActorType":null},"ForumReplyMessage:message:2060297":{"__typename":"ForumReplyMessage","author":{"__ref":"User:user:521"},"id":"message:2060297","revisionNum":1,"uid":2060297,"depth":1,"hasGivenKudo":false,"subscribed":false,"board":{"__ref":"Forum:board:ExcelGeneral"},"parent":{"__ref":"ForumTopicMessage:message:2058369"},"conversation":{"__ref":"Conversation:conversation:2058369"},"subject":"Re: Excel Menu Bar","moderationData":{"__ref":"ModerationData:moderation_data:2060297"},"body":"

itzikassafoutlookcom 

\n

On which platform you are?

\n

In general check File->Options

\n

","body@stripHtml({\"removeProcessingText\":false,\"removeSpoilerMarkup\":false,\"removeTocMarkup\":false,\"truncateLength\":200})@stringLength":"100","kudosSumWeight":0,"repliesCount":0,"postTime":"2021-01-14T03:12:04.131-08:00","lastPublishTime":"2021-01-14T03:12:04.131-08:00","metrics":{"__typename":"MessageMetrics","views":1069},"visibilityScope":"PUBLIC","placeholder":false,"originalMessageForPlaceholder":null,"isEscalated":null,"solution":false,"entityType":"FORUM_REPLY","eventPath":"category:microsoft365/category:products-services/category:communities/community:gxcuf89792board:ExcelGeneral/message:2058369/message:2060297","replies":{"__typename":"MessageConnection","pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null},"edges":[]},"attachments":{"__typename":"AttachmentConnection","edges":[],"pageInfo":{"__typename":"PageInfo","hasNextPage":false,"endCursor":null,"hasPreviousPage":false,"startCursor":null}},"customFields":[]},"CachedAsset:text:en_US-components/community/NavbarDropdownToggle-1745505309787":{"__typename":"CachedAsset","id":"text:en_US-components/community/NavbarDropdownToggle-1745505309787","value":{"ariaLabelClosed":"Press the down arrow to open the menu"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/common/QueryHandler-1745505309787":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/common/QueryHandler-1745505309787","value":{"title":"Query Handler"},"localOverride":false},"CachedAsset:text:en_US-components/messages/EscalatedMessageBanner-1745505309787":{"__typename":"CachedAsset","id":"text:en_US-components/messages/EscalatedMessageBanner-1745505309787","value":{"escalationMessage":"Escalated to Salesforce by {username} on {date}","viewDetails":"View Details","modalTitle":"Case Details","escalatedBy":"Escalated by: ","escalatedOn":"Escalated on: ","caseNumber":"Case Number: ","status":"Status: ","lastUpdateDate":"Last Update: ","automaticEscalation":"automatic escalation","anonymous":"Anonymous"},"localOverride":false},"CachedAsset:text:en_US-components/users/UserLink-1745505309787":{"__typename":"CachedAsset","id":"text:en_US-components/users/UserLink-1745505309787","value":{"authorName":"View Profile: {author}","anonymous":"Anonymous"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/users/UserRank-1745505309787":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/users/UserRank-1745505309787","value":{"rankName":"{rankName}","userRank":"Author rank {rankName}"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageTime-1745505309787":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageTime-1745505309787","value":{"postTime":"Published: {time}","lastPublishTime":"Last Update: {time}","conversation.lastPostingActivityTime":"Last posting activity time: {time}","conversation.lastPostTime":"Last post time: {time}","moderationData.rejectTime":"Rejected time: {time}"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageSolvedBadge-1745505309787":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageSolvedBadge-1745505309787","value":{"solved":"Solved"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageSubject-1745505309787":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageSubject-1745505309787","value":{"noSubject":"(no subject)"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageBody-1745505309787":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageBody-1745505309787","value":{"showMessageBody":"Show More","mentionsErrorTitle":"{mentionsType, select, board {Board} user {User} message {Message} other {}} No Longer Available","mentionsErrorMessage":"The {mentionsType} you are trying to view has been removed from the community.","videoProcessing":"Video is being processed. Please try again in a few minutes.","bannerTitle":"Video provider requires cookies to play the video. Accept to continue or {url} it directly on the provider's site.","buttonTitle":"Accept","urlText":"watch"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageCustomFields-1745505309787":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageCustomFields-1745505309787","value":{"CustomField.default.label":"Value of {name}"},"localOverride":false},"CachedAsset:text:en_US-components/messages/MessageReplyButton-1745505309787":{"__typename":"CachedAsset","id":"text:en_US-components/messages/MessageReplyButton-1745505309787","value":{"repliesCount":"{count}","title":"Reply","title@board:BLOG@message:root":"Comment","title@board:TKB@message:root":"Comment","title@board:IDEA@message:root":"Comment","title@board:OCCASION@message:root":"Comment"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/users/UserAvatar-1745505309787":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/users/UserAvatar-1745505309787","value":{"altText":"{login}'s avatar","altTextGeneric":"User's avatar"},"localOverride":false},"CachedAsset:text:en_US-shared/client/components/ranks/UserRankLabel-1745505309787":{"__typename":"CachedAsset","id":"text:en_US-shared/client/components/ranks/UserRankLabel-1745505309787","value":{"altTitle":"Icon for {rankName} rank"},"localOverride":false},"CachedAsset:text:en_US-components/messages/AcceptedSolutionButton-1745505309787":{"__typename":"CachedAsset","id":"text:en_US-components/messages/AcceptedSolutionButton-1745505309787","value":{"accept":"Mark as Solution","accepted":"Marked as Solution","errorHeader":"Error!","errorAdd":"There was an error marking as solution.","errorRemove":"There was an error unmarking as solution.","solved":"Solved"},"localOverride":false},"CachedAsset:text:en_US-components/tags/TagView/TagViewChip-1745505309787":{"__typename":"CachedAsset","id":"text:en_US-components/tags/TagView/TagViewChip-1745505309787","value":{"tagLabelName":"Tag name {tagName}"},"localOverride":false}}}},"page":"/forums/ForumMessagePage/ForumMessagePage","query":{"boardId":"excelgeneral","messageSubject":"excel-menu-bar","messageId":"2058369"},"buildId":"HEhyUrv5OXNBIbfCLaOrw","runtimeConfig":{"buildInformationVisible":false,"logLevelApp":"info","logLevelMetrics":"info","openTelemetryClientEnabled":false,"openTelemetryConfigName":"o365","openTelemetryServiceVersion":"25.1.0","openTelemetryUniverse":"prod","openTelemetryCollector":"http://localhost:4318","openTelemetryRouteChangeAllowedTime":"5000","apolloDevToolsEnabled":false,"inboxMuteWipFeatureEnabled":false},"isFallback":false,"isExperimentalCompile":false,"dynamicIds":["./components/seo/QAPageSchema/QAPageSchema.tsx","./components/community/Navbar/NavbarWidget.tsx","./components/community/Breadcrumb/BreadcrumbWidget.tsx","./components/customComponent/CustomComponent/CustomComponent.tsx","./components/messages/TopicWithThreadedReplyListWidget/TopicWithThreadedReplyListWidget.tsx","./components/external/components/ExternalComponent.tsx","./components/messages/MessageView/MessageViewStandard/MessageViewStandard.tsx","./components/messages/ThreadedReplyList/ThreadedReplyList.tsx","../shared/client/components/common/List/UnstyledList/UnstyledList.tsx","./components/messages/MessageView/MessageView.tsx","../shared/client/components/common/List/UnwrappedList/UnwrappedList.tsx","./components/tags/TagView/TagView.tsx","./components/tags/TagView/TagViewChip/TagViewChip.tsx"],"appGip":true,"scriptLoader":[{"id":"analytics","src":"https://techcommunity.microsoft.com/t5/s/gxcuf89792/pagescripts/1730819800000/analytics.js?page.id=ForumMessagePage&entity.id=board%3Aexcelgeneral&entity.id=message%3A2058369","strategy":"afterInteractive"}]}