tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 218313d1362425967-need-a-way-of-matching-data-between-sheets-upon-entry-of-data-215-index-match-prob-mini
Sheet: Main

2012 | Code | Amount |  | 2012 | Code | Amount |  | 9/1/11 - 12/31/11 | Geozip | Code | Amount
Region 1 | 99601 |  |  | Region 1 | A0021 |  |  | All geozips | 600 | 10021
Prof Serv | 99602 |  |  | Healthcare | [NAME] |  |  | Prof Serv | 601 | 10021
(10021 – 99607) | 99605 |  |  | (A0021-V5364) | A0398 |  |  | (10021-99607)
 | 99606
 | 99601 |  |  |  |  |  |  | 248763
 | 10021
 | 99605
 | 99606
 | 99607
 | 99512
 | 99512
 | 99512
 | 99512
 | 99512
 | 99512
 | 99512
 | 99512
 | 99512
 | 99512
 | 99512
 | 99512
 | 99512
 | 99512
 | 99512
 | 99512
 | 99512
 | 99512
 | 99512
 | 99512
 | 99512
Spreadsheet: 598141d1542272318-text-categorisation-if-cell-contains-several-text-in-a-single-cell-then-return-a-value-text-categorisation-sample-v2
Sheet: Text Categorisation

Text Description | Category |  | KW 1 | KW 2 | KW 3 | Category
PE Inspection |  |  | Repair | Vacuum |  | Vacuum Repair Services
Yadda yadda |  |  | PE | Inspection |  | Hello
Road Transportation Jan'17 |  |  | Road | Transportation |  | Land Transportation Services
Air Transportation Jan'17 |  |  | Air | Transportation |  | Air Transportation Services
Description needs to contain all the text in the categorisation table to be categorised accordingly
Spreadsheet: 0529af7d-b58e-40f9-bfe3-40ef7ce6ab3b
Sheet: Sheet1

RECRUITMENT EXPENSE REPORT | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
DEPARTMENT:
CANDIDATE'S NAME:
EXPENSE ITEMS |  |  |  |  |  |  | TOTALS
Lodging |  |  |  |  |  |  | 0
Breakfast* (attach receipts) |  |  |  |  |  |  | 0
Lunch* (attach receipts) |  |  |  |  |  |  | 0
Dinner* (attach receipts) |  |  |  |  |  |  | 0
Air Travel (attach original ticket) |  |  |  |  |  |  | 0
Airport/SMU Transport  (attach receipt) |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 0
TOTAL EXPENSE |  |  | 0 | 0 | 0 | 0 | 0
 |  |  |  |  | Cross Total: |  | 0
PLEASE PREPARE INDIVIDUAL REIMBURSEMENTS TO THE FOLLOWING:
PAYEE |  |  | AMOUNT
 |  |  |  |  | *Include names of participants on each receipt;
 |  |  |  |  | the College will pay the the candidate's meals as well as
 |  |  |  |  | the meals for two accompanying faculty.
 |  |  |  |  | The College will pay up to the amount indicated
 |  |  |  |  | below for the total charge for each event.
 |  |  |  |  | Breakfast:  $25
 |  |  |  |  | Lunch:  $75
TOTALS |  |  | 0 |  | Dinner:  $100
Spreadsheet: 866564d1713472198-vat-calculation-product-list
Sheet: TXNS

I'm kindly requesting a formula to calculate VAT using the information on the product list worksheet.
 |  |  |  |  |  | Desired Solution |  |  | [NAME]
Description |  |  |  | Qty | Price | VAT | Total (exc VAT) |  | VAT
Bottled Water |  |  |  | 2 |  | 0.15
Coke |  |  |  | 3 |  | 0.54
Fertiliser |  |  |  | 6 |  | 0
Heater |  |  |  | 3 |  | 6.75
Screwdrive |  |  |  | 2 |  | 0
Spreadsheet: 763084d1641986700-count-based-on-entry-uk-prod-lt-holiday-calendar-2022-copy
Sheet: Overviews

 | Employee Names
 | Employee Names |  | Total Holidays (Inc 8 BH's) |  | Site Lead Cover  NAME | Site Lead Cover _x000D_ E-Mail | Site Lead Cover  MOBILE PHONE NUMBER
 | [NAME] |  |  |  | [NAME]
 | Fran |  |  |  | [NAME]
 |  |  |  |  | [NAME]
 | [NAME] |  |  |  | [NAME]
 | Jo |  |  |  | [NAME]
 | Maria |  |  |  | [NAME]
 | Mark |  |  |  | n/a
 | Michelle |  |  |  | n/a
 | [NAME] |  |  |  | [NAME]
 | [NAME] |  |  |  | [NAME]
 | [NAME] |  |  |  | [NAME]
 | [NAME] |  |  |  | [NAME]
 | Zak
Spreadsheet: 453922d1459518982-attendance-point-tracker-attendance-tracker
Sheet: Depot Referrals

QA | WTN | Model | Agent | TL | Site | Pre-qualified | Reason | Call Date | SM | Completed | Comments
Julie | 6784277816 | Motorola V3 RAZR | [NAME] | [NAME] | NM - Rio Rancho | No | n/a | 2007-04-14 00:00:00 | Aragon | No
Julie | 7702624682 | Motorola V557 | [NAME] | Baumgardner | NM - Rio Rancho | No | n/a | 2007-04-14 00:00:00 | Aragon | No
Nico | 4042901842 | Motorola V3 RAZR | [NAME] | Baumgardner | NM - Rio Rancho | No | n/a | 2007-04-14 00:00:00 | Aragon | No
Nico | 4102279056 | Nokia 6102i | Chantelle White | Smith1 | NM - Rio Rancho | No | n/a | 2007-04-14 00:00:00 | [NAME] | No
Nico | 7705401320 | Motorola V3 RAZR | [NAME] | Baumgardner | NM - Rio Rancho | No | n/a | 2007-04-14 00:00:00 | Aragon | No
Nico | 4044059363 | Motorola V3 RAZR | [NAME] | [NAME] | NM - Rio Rancho | No | n/a | 2007-04-14 00:00:00 | [NAME] | No
[NAME] | 2027147245 | Motorola V3 RAZR | [NAME] | Baumgardner | NM - Rio Rancho | No | n/a | 2007-04-14 00:00:00 | Aragon | No
[NAME] | 4437945201 | Motorola V3 RAZR | Gregory Cline | Ramsey | NM - Rio Rancho | No | n/a | 2007-04-14 00:00:00 | [NAME] | No
[NAME] | 2025381497 | Motorola V3 RAZR | [NAME] | Chester | NM - Rio Rancho | No | n/a | 2007-04-14 00:00:00 | [NAME] | No
Dom | 2024982679 | Samsung C417 | [NAME] | [NAME] | NM - Rio Rancho | No | n/a | 2007-04-14 00:00:00 | Aragon | No
Dom | 4109712685 | Motorola V3 RAZR | [NAME] | Ramos | NM - Rio Rancho | No | n/a | 2007-04-15 00:00:00 | [NAME] | No
Dom | 4437905443 | Motorola V3 RAZR | Crystal Skinner | Ramos | NM - Rio Rancho | No | n/a | 2007-04-15 00:00:00 | [NAME] | No
Boom | 7033035742 | Motorola V557 | [NAME] | Perea | NM - Rio Rancho | No | n/a | 2007-04-15 00:00:00 | [NAME] | No
Boom | 4044058537 | Motorola V3 RAZR | [NAME] | [NAME] | NM - Rio Rancho | No | n/a | 2007-04-15 00:00:00 | [NAME] | No
Boom | 4044553753 | Motorola L7 (Sliver) | [NAME] | Ramsey | NM - Rio Rancho | No | n/a | 2007-04-15 00:00:00 | [NAME] | No
Boom | 2405353028 | Motorola L7 (Sliver) | Gregory2 [NAME] | [NAME] | NM - Rio Rancho | No | n/a | 2007-04-15 00:00:00 | [NAME] | No
Boom | 2024125840 | Motorola V3 RAZR | [NAME] | Ramsey | NM - Rio Rancho | Yes | Site/Location | 2007-04-15 00:00:00 | [NAME] | No
Spreadsheet: e52f090a-7348-4897-a020-84580fffab54
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
LORAZ | Test | LORAZ | Lorazepam (Ativan), Serum | Lorazepam (Ativan) | Liquid Chromatography/Tandem Mass Spectrometry (LC/MS/MS) | Green-Top Tube (Sodium Heparin): GrnNaHp |  |  |  |  | Submit only 1 of the following specimens:   Plasma Draw blood in a green-top sodium heparin tube(s), plasma gel tube is not acceptable. Spin down and send 2 mL of plasma refrigerated in a plastic vial.   Serum Draw blood in a plain, red-top tube(s), serum gel tube is not acceptable.  Spin down and send 2 mL of serum refrigerated in a plastic vial. | 0.6 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | Reference Range: 50.0-240.0 ng/mL   Test Performed By: Medtox Laboratories, Inc.                              402 W. County Road D                              St. Paul, MN 55112 | Monday through Sunday | 5 days | 7 - 9 days | 1 | 80154 |  |  |  |  | Medtox Laboratories, Inc.
LORAZ | [NAME] | VARIES | Varies |  |  |  | Refrigerated | 7 days
LORAZ | Result | Z1123 | Lorazepam (Ativan) | Lorazepam (Ativan) | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 63421d1264346371-date-and-count-number-of-items-mtd-testsheet
Sheet: Main

 | Month To Date Totals
Name | Total MTD | Code 01 | Code 02 | Amount | Date Range
[NAME]
[NAME]
[NAME]
Spreadsheet: 687042d1594924474-formula-help-to-average-cells-based-on-set-number-of-entries-excel-help_3
Sheet: Oeldere2

Criteria => | 2020-12-01 00:00:00 |  | 12 | yes |  | 24 | 5
 |  |  |  |  |  |  |  |  | 12 month
Project | Booking Date | SM | 12 month | 24 month | 5 criteria | combined |  |  | 24 month
Project H | 2017-05-26 00:00:00
Project H | 2018-02-21 00:00:00
Project H | 2018-02-21 00:00:00
Project H | 2018-12-31 00:00:00
Project H | 2019-01-16 00:00:00
Project H | 2019-01-16 00:00:00
Project H | 2019-01-16 00:00:00
Project A | 2019-06-01 00:00:00 | 0.9
Project B | 2019-07-01 00:00:00 | 0.4
Project C | 2019-08-01 00:00:00 | 0.541
Project D | 2019-08-01 00:00:00 | 0.579
Project E | 2019-08-01 00:00:00 | 0.695
Project F | 2019-10-01 00:00:00 | 0.723
Project C | 2019-11-01 00:00:00 | 5
Project D | 2019-11-01 00:00:00 | 6
Project E | 2019-11-01 00:00:00 | 7
Project G | 2020-01-01 00:00:00 | 8
Project H | 2020-06-01 00:00:00 | 9
 | Average
Spreadsheet: 678879d1590095487-finding-consecutive-occurrences-of-countries-parkrun-my-parkrun-record-consecutive-different-countries-reduced
Sheet: All Completed Runs - L C

MY parkruns - ALL COMPLETED RUNS - LLOYD CLUB
Unique Country # | Country | Event (Venue) | Date Completed
 | United Kingdom | [NAME]-on-Wye parkrun | 2019-08-03 00:00:00
 | Denmark | Amager Fælled parkrun | 2019-08-10 00:00:00
 | Australia | St Peters parkrun | 2019-08-17 00:00:00
 | USA | Mansfield OH parkrun | 2019-08-24 00:00:00
 | South Africa | Oudtshoorn parkrun | 2019-08-31 00:00:00
 | Poland | parkrun Gdańsk | 2019-09-07 00:00:00
 | New Zealand | Lower Hutt parkrun | 2019-09-14 00:00:00
 | Ireland | [NAME] parkrun | 2019-09-21 00:00:00
Spreadsheet: 156609d1337357178-copying-columns-a-bit-complex-vicvic_copy_columns_18may12_02
Sheet: Sheet1

Length | 4 | By changing B1 the length of column varies |  |  |  | Number | Name | Group | Number | Name | Group
Starting | 5 | Cell B2 is always less than or equal to B1 |  |  |  | 1 |  |  |  | Pear1
1 | Apple |  |  |  |  |  |  |  |  | Cherry1 |  |  | I want 2 columns which
2 | Orange |  |  |  |  |  |  |  |  | Banana1 | Group2 |  | Copy as many as you can from group 1, (taking only those appear, excluding "")
3 | Pear |  |  |  |  |  |  | Group1 |  | aa |  |  | and continues copy the remaining in group 2
4 | [NAME] |  |  |  |  |  |  |  |  | bb
5 | [NAME] |  |  |  |  |  |  |  |  | cc |  |  | e.g. in this case, the result should look like
6 | Grapes |  |  |  |  |  |  |  |  |  |  |  | 1 | Apple
7 | Kiwi |  |  |  |  |  |  |  |  |  |  |  | 2 | Orange
 |  |  |  |  |  |  |  |  |  |  |  |  | 3 | Pear
 |  |  |  |  |  |  |  |  |  |  |  |  | 4 | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | 5 | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  | 6 | Cherry1
 |  |  |  |  |  |  |  |  |  |  |  |  | 7 | Banana1
 |  |  |  |  |  |  |  |  |  |  |  |  | 8 | aa
 |  |  |  |  |  |  |  |  |  |  |  |  | 9 | bb
 |  |  |  |  |  |  |  |  |  |  |  |  | 10 | cc
 |  |  |  |  |  |  |  |  |  |  |  |  | How should I make this?
Spreadsheet: 65548d1266273456-find-a-value-across-multiple-sheets-in-another-workbook-sales-orders_2010
Sheet: SalesSep

Expected Sales Proceeds For JANUARY 2010
 |  |  |  |  |  |  | FX | 0.9135
 | INVOICE | INVOICE DATE | CUSTOMER | PRODUCT | Quantity | PRICE        USD / MT | AMOUNT (USD) | AMOUNT (AUD)
EXPORT
 | 100906 | 2010-09-12 00:00:00 | Customer1 | Product101 | 4789 | 3.340780956358321 | 15999 | 17513.95730706075
 | 100907 | 2010-09-13 00:00:00 | Customer2 | Product202 | 5221 | 3.355678988699483 | 17520 | 19178.98193760263
 | 100908 | 2010-09-14 00:00:00 | Customer3 | Product303 | 5653 | 3.368300017689722 | 19041 | 20844.0065681445
 | 100909 | 2010-09-15 00:00:00 | Customer4 | Product404 | 6085 | 3.379129005751849 | 20562 | 22509.03119868637
 | 100910 | 2010-09-16 00:00:00 | Customer5 | Product505 | 6517 | 3.388522326223723 | 22083 | 24174.05582922824
 | 100911 | 2010-09-17 00:00:00 | Customer6 | Product606 | 6949 | 3.396747733486833 | 23604 | 25839.08045977012
 | 100912 | 2010-09-18 00:00:00 | Customer7 | Product707 | 7381 | 3.404010296707763 | 25125 | 27504.10509031199
 | 100913 | 2010-09-19 00:00:00 | Customer8 | Product808 | 7813 | 3.410469729937284 | 26646 | 29169.12972085386
 | 100914 | 2010-09-20 00:00:00 | Customer9 | Product909 | 8245 | 3.416252274105518 | 28167 | 30834.15435139573
DOMESTIC
Spreadsheet: 30069d1225373547-realtime-copying-of-rows-with-particular-attributes-to-other-worksheets-making-lists-sales-data-test
Sheet: ProductInfo

Item | FieldB | FieldC | FieldD | FieldE | FieldF | FieldG
30x96 | 67864 | 3850 | 234324 | 5444 | 23124 | 4652756
32x96 | 275059 | 457059 | 62000 | 20000 | 326000 | 216000
34x96 | 3453534 | 151334 | 5000 | 23424 | 4325546 | 76346
36x96 | 23415 | 24423` | 15000 | 144423 | 354325 | 6345
40x96 | 2432455 | 34243 | 25000 | 215120 | 43414 | 541346
42x96 | 6535431 | 10000 | 150000 | 295000 | 365000 | 435345
Spreadsheet: 145506d1331627083-about-column-chart-818613b
Sheet: 5

data | [NAME] | frquency | %
0.4747765192177438 | 0.1
0.2368296949413358 | 0.2 | 3
0.8029807100895727 | 0.3 | 1
0.4586084257227299 | 0.4 | 0
0.5260953931122121 | 0.5 | 7
0.122167220516036 | 0.6 | 2
0.4701451170543325 | 0.7 | 1
0.940842112000909 | 0.8 | 2
0.4702137045887462 | 0.9 | 3
0.4752698020103026 | 1 | 1
0.1661522285227299
0.728783673306717
0.4087543367812358
0.8115954071871174
0.8594223761163091
0.6519699014015607
0.4002621682814311
0.7215366767367675
0.5939157954989271
0.1741168973511673
Spreadsheet: 38009d1236118219-excel-2007-hide-items-in-page-field-pivot-tables-pivot-test-page-field-issues
Sheet: Pivot

Time Periods | (All)
Geographies | (All)
 | Data
Products | Max of Dollar Sales | RMA Dollar Sales % Chg YAgo | RMA Unit Sales | RMA Unit [NAME] | ROM Dollar Sales | ROM Dollar Sales % Chg YAgo | ROM Unit Sales | ROM Unit [NAME]
VARIETY | 165160 | 10.3038 | 149040 | 1.65885 | 165160 | 10.3038 | 149040 | 1.65885
PRIVATE LABEL | 68568.65 | 32.18851 | 70683 | 14.50534 | 68568.65 | 32.18851 | 70683 | 14.50534
SUN VISTA | 45936.83 | -11.74454 | 37993 | -20.54167 | 45936.83 | -11.74454 | 37993 | -20.54167
S & W | 30673.93 | 1075.37775 | 34576 | 1768.75 | 30673.93 | 1075.37775 | 34576 | 1768.75
KUNERS | 27334.63 | -2.43674 | 20049 | -27.3271 | 27334.63 | -2.43674 | 20049 | -27.3271
RANCH STYLE | 25537.66 | 9.86317 | 23391 | 8.49761 | 25537.66 | 9.86317 | 23391 | 8.49761
BUSH BROTHERS BUSHS BEST | 23749.7 | -8.8959 | 16807 | -24.30302 | 23749.7 | -8.8959 | 16807 | -24.30302
EL MEXICANO | 17130.35 | -24.25137 | 11685 | -31.22425 | 17130.35 | -24.25137 | 11685 | -31.22425
LA COSTENA | 10837.7 | 126.28921 | 9060 | 76.31579 | 10837.7 | 126.28921 | 9060 | 76.31579
GOYA | 7680.26 | 24.62592 | 5144 | 13.24503 | 7680.26 | 24.62592 | 5144 | 13.24503
ROSARITA | 6258.9 |  | 6225 |  | 6258.9 |  | 6225
BUSHS BEST | 5768.76 | -20.49604 | 3702 | -37.73966 | 5768.76 | -20.49604 | 3702 | -37.73966
PROGRESSO | 4417.54 | 7.14305 | 2336 | -15.57644 | 4417.54 | 7.14305 | 2336 | -15.57644
WESTBRAE NATURAL | 2296.46 | 46.37091 | 1154 | 20.71006 | 2296.46 | 46.37091 | 1154 | 20.71006
EDEN | 1676.87 | 66.43429 | 755 | 70.58824 | 1676.87 | 66.43429 | 755 | 70.58824
TEASDALE | 1637.53 | 49.15073 | 733 | 22.16495 | 1637.53 | 49.15073 | 733 | 22.16495
DEL MONTE FRESH CUT SPECIALTIES | 1616.33 | -12.23895 | 847 | -16.39785 | 1616.33 | -12.23895 | 847 | -16.39785
GLORY FOODS | 174.53 | -5.53691 | 107 | -15.74803 | 174.53 | -5.53691 | 107 | -15.74803
FARAON | 0 |  | 0 |  | 0 |  | 0
[NAME] BROTHERS | 0 |  | 0 |  | 0 |  | 0
Spreadsheet: 793601d1661562864-conditional-count-for-the-denominator-of-average-formula-sample-golf-
Sheet: Sheet1

 | 2022-08-01 00:00:00 | 2022-08-03 00:00:00 | 2022-08-04 00:00:00 | 2022-08-10 00:00:00 | 2022-08-15 00:00:00 | 2022-08-17 00:00:00 | 2022-08-24 00:00:00 |  | average round
9 or 18 | 1 | 1 | 0.5 | 1 | 0.5 | 1 | 0.5
Player 1 | 80 | 82 | 40 | 79 | 43 |  | 43
player 2 | 77 |  | 41 | 75 | 37
Spreadsheet: 183154d1348725199-cell-referencing-diff-in-average_sample
Sheet: Sheet1

1 |  |  |  |  |  |  |  | 1
2
3
4
5
6
4
6
7
8
43
45
6
7
76
8
567
686
54
343
43
4342
54
5643
464
6
4
343
45
6
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
Spreadsheet: 882775d1731244301-transpose-data-into-multiple-columns-based-on-numbers-book-2
Sheet: Sheet1

1 | MEMBER ID: 1234
1 | Organization Name: ABC Corp
1 | Mobile Number: [PHONE]
1 | Representative Name: [NAME]
2 | MEMBER ID: 5678
2 | Organization Name: XYZ Ltd
2 | Mobile Number: [PHONE]
2 | Representative Name: [NAME]
3 | MEMBER ID: 59862
3 | Organization Name: HGTLtd
3 | Mobile Number: 1258932
4 | MEMBER ID: 1258
4 | Organization Name: LGB Corp
Spreadsheet: 830004d1684616034-conditional-formatting-to-highlight-a-valve-shown-on-a-separate-worksheet-test-conditional-formatting-copy
Sheet: Sheet2

Tee Sheet
08:20:00 | POSSLEY, ROBERT | DINESEN, NIEL |  | [NAME], [NAME] | KNOECKLEIN, MAX
08:28:00 | THEVENET, TED | BISHOP, DAVE |  | O'MALLEY, TOM | BERGER, DAVE
08:36:00 | WHAM, ROBERT | SCHLAEFER, STEVE |  | SHEEHAN, BOB | [NAME], [NAME]
Spreadsheet: 871102d1717533672-would-like-to-add-automatic-date-and-day-yearly-xda-sickness-file
Sheet: FEBRUARY

 | DATE | DAY | STAFF NAME | HOURS | CODE |  | STAFF NAME | HOURS | CODE |  | STAFF NAME | HOURS | CODE |  | STAFF NAME | HOURS | CODE |  | STAFF NAME | HOURS | CODE |  | STAFF NAME | HOURS | CODE |  | STAFF NAME | HOURS | CODE |  | STAFF NAME | HOURS | CODE |  | STAFF NAME | HOURS | CODE
 |  |  | Total Hours |  |  |  | Total Hours |  |  |  | Total Hours |  |  |  | Total Hours |  |  |  | Total Hours |  |  |  | Total Hours |  |  |  | Total Hours |  |  |  | Total Hours |  |  |  | Total Hours
 | DATE | DAY | STAFF NAME | PAY | TOIL
 |  |  | TOTALS
Spreadsheet: 857232d1706257346-needing-help-with-if-statement-in_out-1-
Sheet: Sheet1

INDEX | In or Out
72 |  | When the index drops below 70 get "out" & stay "out" until the index drops below 50 then get back "in"
66
62
64
45
51
72
69
Spreadsheet: 5c348948-8437-4db7-b442-0f7b65ed0d64
Sheet: Sheet1

Bevölkerung des Freistaates Sachsen nach ausgewählten Altersgruppen | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
[NAME]
Alter von ... bis                     unter ... Jahren | 2011 | 2015 | 2020 | 2025
1 000
unter 55 | 45931 | 40918 | 35579 | 31340
55 - 60 | 6807 | 6092 | 5851 | 4663
60 - 65 | 6435 | 6867 | 5881 | 5689
65 - 75 | 9442 | 9537 | 11289 | 11662
75 - 85 | 6861 | 7500 | 7448 | 7360
85 und mehr | 2230 | 2845 | 3155 | 3766
Insgesamt | 77706 | 73759 | 69203 | 64480
%
unter 55 | 59.10869173551592 | 55.47526403557532 | 51.41251101830846 | 48.60421836228288
55 - 60 | 8.759941317272798 | 8.259331064683632 | 8.45483577301562 | 7.231699751861043
60 - 65 | 8.281213805883715 | 9.31005029894657 | 8.49818649480514 | 8.82289081885856
65 - 75 | 12.15092785627879 | 12.92994753182662 | 16.31287660939554 | 18.08622828784119
75 - 85 | 8.829434020538955 | 10.16825065415746 | 10.76253919627762 | 11.41439205955335
85 und mehr | 2.869791264509819 | 3.857156414810396 | 4.559050908197621 | 5.840570719602978
Insgesamt | 100 | 100 | 100 | 100
Gebietsstand: | 31. [NAME] 2008
Quelle: | 2011 Bevölkerungsfortschreibung auf Basis der [NAME] vom 03. Oktober 1990
 | 2012 - 2025 Bevölkerungsprognose
Bevölkerung jeweils am 31. Dezember
Prognoseergebnisse werden bei der Veröffentlichung immer auf volle [NAME] gerundet. [NAME] basieren [NAME] ungerundeten Werten. Beim [NAME] der [NAME] werden Ihnen die ungerundeten [NAME] zur Verfügung gestellt, damit [NAME] eigenen Berechnungen genauer durchführen können. Die Darstellung der Ergebnisse sollte dann aber wieder gerundet erfolgen.
Spreadsheet: 377670d1424112494-sum-amounts-by-month-paid-pt-grouped-by-yr-and-month-amts
Sheet: Sheet1

Date | To | What? | Amt
2014-08-28 00:00:00 | Barclays HQ | 11
2014-08-29 00:00:00 | Teleconference | 1
2014-09-05 00:00:00 | partner Offices | 11 |  |  |  | Row Labels | Sum of Amt
2014-09-24 00:00:00 | Barclays HQ | 11.5 |  |  |  | 2014
2014-10-17 00:00:00 | Park Plaza | 1.5 |  |  |  | Aug | 192
2014-10-31 00:00:00 | Teleconference | 0.5 |  |  |  | Barclays HQ | 176
2014-11-21 00:00:00 | partner Offices | 9 |  |  |  | Teleconference | 16
2014-12-03 00:00:00 | head office | 3 |  |  |  | Sep | 360
2014-12-03 00:00:00 | partner Offices | 3 |  |  |  | Barclays HQ | 184
2014-12-17 00:00:00 | partner Offices | 13.5 |  |  |  | partner Offices | 176
2015-01-12 00:00:00 | Park Plaza | 2 |  |  |  | Oct | 32
2015-01-13 00:00:00 | Park Plaza | 3 |  |  |  | Park Plaza | 24
 |  |  |  |  |  | Teleconference | 8
 |  |  |  |  |  | Nov | 144
 |  |  |  |  |  | partner Offices | 144
 |  |  |  |  |  | Dec | 312
 |  |  |  |  |  | head office | 48
 |  |  |  |  |  | partner Offices | 264
 |  |  |  |  |  | 2015
 |  |  |  |  |  | Jan | 80
 |  |  |  |  |  | Park Plaza | 80
 |  |  |  |  |  | Grand Total | 1120
Spreadsheet: 772749d1647451557-task-list-to-auto-populate-into-a-calendar-with-12-entries-bi-weekly-calendar_multi_lookup
Sheet: Calendar

 | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
1 |  |  |  |  |  |  |  |  | Month | 9
2 |  |  |  |  |  |  |  |  | Year | 2021
3
4
5
6
7
1
2
3
4
5
6
7
1
2
3
4
5
6
7
1
2
3
4
5
6
7
1
2
3
4
5
6
7
1
2
3
4
5
6
7
Spreadsheet: 859729d1708004547-combine-all-tables-of-the-workbook-into-one-but-column-headers-are-different-sample
Sheet: Batch C21

Summary of Assessment Outcome  Name of Programme: det   Name of [NAME] SSO Name- swa
[NAME] result Sheet
Student ID | First Name | Surname | Result Unit 502  IV- tab | Result Unit 503   IV- tab | 1st Term Progression | Result Unit 417  IV- tab | Result Unit 506 IV- win | Result Unit 423 IV- win | 2st Term Progression | Result Unit 426 IV- tab | Result Unit 501 IV- tab | 3rd Term Progression | Unit Pass        out of 7 units | Certificate Claimed Yes/No | Claimed by | Date of Certificate Recieving | Received by | Certificate Claim File | Incorrect Name | [NAME] only File | Wrong Certificate only File | Correct Name As pe Passport | Checked by
21099 | Karim | OLTEANU | Resit-Pass | Resit-Pass | PP | Resit-Pass | Resit-Pass | Pass | PP | Pass | Pass | PP | 7 | No |  | 14/02/2023 |  |  |  |  |  |  | 14th feb
21114 | AHMED | CHOWDHURY | Pass | Pass | PP | Pass | Pass | Resit-Pass | PP | Pass | Pass | PP | 7 | YEs | Exam Officer |  |  |  |  |  |  |  | 24th May
21149 | Chowdhury | AHMED | Resit-Pass | Resit-Pass | PP | Resit-Pass | Pass | Refer | PT | Pass | Pass | PT | 6 | No
21126 | Sampson Osei | Begum | Resit-Pass | Resit-Pass | PP | Pass | Resit-Pass | Resit-Pass | PP | Not Submitted | Not Submitted | PT | 5 | No
21077 | RAHAMAN | Begum | Pass | Pass | PP | Re-Refer | Pass | Pass | PT | Resit-Pass | Re-Refer | PT | 5 | Yes | Exam Officer | 2023-03-01 00:00:00 | Jhansi
21131 | NAZRUL | FARUQ | Pass | Resit-Pass | PP | Resit-Pass | Re-Refer | Resit-Pass | PT | Re-Refer | Resit-Pass | PT | 5 | No
21118 | FOYSAL | Karim | Pass | Pass | PP | Not Submitted | Pass | Pass | PT | Not Submitted | Not Submitted | PT | 4 | No
21097 | Orohiri Zephirin | AHMED | Resit-pass | Pass | PP | Resit-Pass | Refer | Pass | PT | Not Submitted | Not Submitted | PT | 4 | No
21084 | MD FAKHRU | Chowdhury | Pass | Resit-Pass | PP | Resit-Pass | Re-Refer | Re-Refer | PT | Re-Refer | Refer | PT | 3 | No
PP= Pass & Progress
PT= Progress with Trailing
Total Student |  |  | 31 | 31 |  | 31 | 31 | 31 |  | 31 | 31 | 31 | 19
Submission |  |  | 31 | 31 |  | 30 | 30 | 30 |  | 25 | 26
Submission Rate
Pass |  |  | 29 | 27 |  | 25 | 23 | 25 |  | 21 | 21
Refer |  |  | 2 | 4 |  | 5 | 7 | 5 |  | 4 | 5
Marking Pending |  |  | 0 | 0 |  | 0 | 0 | 0 |  | 0 | 0
Not Submitted |  |  | 0 | 0
Passing rate |  |  |  |  |  |  |  |  |  |  |  | Overall achievement Rate