tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 888125d1738556903-vacation-accrual-accr-pto_tk
Sheet: Sheet1

Years of svc | <4 | 120 hrs
Years of svc | >4 | 160 hrs
[NAME] cap |  | 240 hrs
Employee hire date |  | 2020-03-20 00:00:00
4 year anniversary |  | 2024-03-20 00:00:00
Beg period |  | 2024-01-01 00:00:00
End period |  | 2024-12-31 00:00:00
[NAME] balance |  | 117 hrs
Taken |  | 88 hrs
Vacattion Earned |  | ?
Q: calculate accrued vacation as of 12/31/2024?
Spreadsheet: eric_saibi__9785__020402R
Sheet: Beaver Valley 02

Owner Name |  | First Energy Corporation
Station Name |  | Beaver Valley Nuclear Power Station
Unit Name |  | Beaver Valley 02
NERC Region |  | ECAR
State |  | PA
Fuel Type |  | Nuclear
Capacity |  | 923
Start Date |  | 2002-02-04 00:00:00
End Date |  | 2002-03-10 00:00:00
Prv. Start Date |  | 2002-02-16 00:00:00
Prv. End Date |  | 2002-03-09 00:00:00
Comments |  | Refuel
SIC |  | 4911
Plant ID |  | 1017303
Unit ID |  | 1004149
Outage ID |  | 13006
Spreadsheet: 453662d1459404366-top-4-male-and-top-4-female-scores-with-4-more-top-scores-added-archery-scoring-template
Sheet: Sheet1

 | Top | 25 | 25 |  |  |  | Tag In | Hurdle |  |  |  | Male
 | Hurdle |  |  |  |  |  |  |  |  |  |  | Female
 | Count
 | Name | Tag In | Score | 10's | Rank in Div | Overall rank |  |  |  | RS
1 | [NAME] | Male | 273 | 16 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | *
2 | [NAME] | Male | 264 | 9
3 | [NAME] | Male | 263 | 7
4 | [NAME] | Male | 261 | 12
5 | [NAME] | Female | 203 | 2
6 | Morgan King | Female | 190 | 1
7 | [NAME] | Male | 261 | 7
8 | [NAME] | Female | 201 | 1
9 | [NAME] | Male | 260 | 7
10 | [NAME] | Male | 252 | 8
11 | [NAME] | Male | 246 | 5
12 | [NAME] | Male | 236 | 5
13 | Christian Popoca | Male | 235 | 6
14 | [NAME] | Male | 233 | 3
15 | [NAME] | Male | 232 | 7
16 | [NAME] | Male | 227 | 1
17 | [NAME] | Female | 224 | 1
18 | Rose Degrande | Female | 218 | 4
19 | [NAME] | Female | 218 | 0
20 | [NAME] | Male | 215 | 1
21 | [NAME] | Male | 166 | 2
22 | [NAME] | Female | 154 | 0
23 | [NAME] | Female | 0 | 3
24 | [NAME] | Male | 0 | 2
25 | [NAME] | Male | 0 | 1
Spreadsheet: 91704d1291376922-how-to-lookup-value-different-from-another-that-have-the-same-part-of-the-value-lookup
Sheet: Sheet1

P Intro 3 |  | P [NAME] should be 1 |  |  | P Intro | 1
[NAME] 2 |  |  |  |  | Intro | 2
Itm 1 |  |  |  |  | Itm | 3
Ele 2 |  |  |  |  | [NAME] | 4
B 1A 3 |  |  |  |  | B 1 | 5
B 2A 4 |  |  |  |  | B 2 | 6
B 3A 5 |  |  |  |  | B 3 | 7
P Intro 2 |  | P [NAME] should be 1
[NAME] 3
Itm 2 |  |  |  | I got problem to lookup "P Intro" because the formula read it as "Intro"
Ele 4 |  |  |  | How to make a formula that lookup as P Intro and Intro separately
B 1A 1
B 2A 2
B 3A 3
Spreadsheet: jonathan_mckay__17208__Atco Volumes
Sheet: MMcfd

Receipts
 | North |  | South |  | Total
Month | Receipts | Deliveries | Receipts | Deliveries | Receipts | Deliveries | Imbalance | YOY Growth |  | [NAME] (MMcf/d) | [NAME] (MMcf/d) | [NAME] (w/o [NAME])
1998-01-01 00:00:00
1998-02-01 00:00:00
1998-03-01 00:00:00
1998-04-01 00:00:00
1998-05-01 00:00:00
1998-06-01 00:00:00
1998-07-01 00:00:00
1998-08-01 00:00:00
1998-09-01 00:00:00
1998-10-01 00:00:00
1998-11-01 00:00:00
1998-12-01 00:00:00
1999-01-01 00:00:00 |  |  |  |  |  |  |  |  |  | 0 | 1765.228946352243 | 723.7073304964774
1999-02-01 00:00:00 |  |  |  |  |  |  |  |  |  | 0 | 1293.411761035152 | 507.1998254986117
1999-03-01 00:00:00 |  |  |  |  |  |  |  |  |  | 6.110444309012195 | 1074.1447889001 | 407.3167921099096
1999-04-01 00:00:00 |  |  |  |  |  |  |  |  |  | 24.63295301846212 | 1040.089402852944 | 427.9937636223576
1999-05-01 00:00:00 |  |  |  |  |  |  |  |  |  | 29.76062501316854 | 970.7607491654555 | 426.461681754253
1999-06-01 00:00:00 |  |  |  |  |  |  |  |  |  | 39.47186224581459 | 712.3472064315869 | 271.7024051469522
1999-07-01 00:00:00 |  |  |  |  |  |  |  |  |  | 41.01299372963708 | 771.787475371425 | 312.5432350615945
1999-08-01 00:00:00 |  |  |  |  |  |  |  |  |  | 55.01099142113394 | 621.2678816337647 | 221.0450775302377
1999-09-01 00:00:00 |  |  |  |  |  |  |  |  |  | 58.26368864986031 | 721.6149478755665 | 295.9822989637713
1999-10-01 00:00:00 |  |  |  |  |  |  |  |  |  | 46.44921491155836 | 919.0183723212346 | 390.7677478311122
1999-11-01 00:00:00 |  |  |  |  |  |  |  |  |  | 31.07296569353786 | 1148.974269120503 | 430.9296011219772
1999-12-01 00:00:00 |  |  |  |  |  |  |  |  |  | 22.37876169343526 | 1168.662547650725 | 462.7235817969898
2000-01-01 00:00:00 |  |  |  |  |  |  |  |  |  | 2.374910755320971 | 675.0418028031569 | 675.0418028031569
2000-02-01 00:00:00 |  |  |  |  |  |  |  |  |  | 9.976771787000343 | 530.2524721688392 | 530.2524721688392
2000-03-01 00:00:00 |  |  |  |  |  |  |  |  |  | 38.89563808683931 | 397.1218441835368 | 397.1218441835368
2000-04-01 00:00:00 |  |  |  |  |  |  |  |  |  | 41.0146182785259 | 390.1324209882929 | 390.1324209882929
2000-05-01 00:00:00 |  |  |  |  |  |  |  |  |  | 43.64733757195808 | 228.8861964792874 | 228.8861964792874
2000-06-01 00:00:00 |  |  |  |  |  |  |  |  |  | 51.99832760112925 | 203.1388089810749 | 203.1388089810749
2000-07-01 00:00:00 |  |  |  |  |  |  |  |  |  | 106.6453847329374 | 240.0360035573925 | 240.0360035573925
2000-08-01 00:00:00 |  |  |  |  |  |  |  |  |  | 97.16682348965145 | 289.8819593690408 | 289.8819593690408
2000-09-01 00:00:00 |  |  |  |  |  |  |  |  |  | 86.15793214477583 | 270.7189099134392 | 270.7189099134392
2000-10-01 00:00:00 |  |  |  |  |  |  |  |  |  | 79.57295902369948 | 360.5204851091588 | 360.5204851091588
2000-11-01 00:00:00 |  |  |  |  |  |  |  |  |  | 50.31434788776073 | 525.580234644147 | 525.580234644147
2000-12-01 00:00:00 |  |  |  |  |  |  |  |  |  | 49.78307395658557 | 524.7387213487278 | 524.7387213487278
2001-01-01 00:00:00
2001-02-01 00:00:00
2001-03-01 00:00:00
Spreadsheet: 789470d1659107302-hlook-up-not-working-last-man-standing-1-
Sheet: week 1

 | Week 1
 | NAME | TEAM
 |  |  |  | [NAME] | Norwich City
 |  |  |  | [NAME] | [NAME]
 |  |  |  | [NAME] | Northampton Town
 |  |  |  | [NAME] | Northampton Town
 |  |  |  | Shane | Tranmere Rovers
 |  |  |  | [NAME] | Northampton Town
 |  |  |  | [NAME] | Watford
 |  |  |  | [NAME] | Stockport County
 |  |  |  | [NAME] | [NAME]
 |  |  |  | [NAME] | Stockport County
 |  |  |  | [NAME] | Salford City
 |  |  |  | [NAME] | Stockport County
 |  |  |  | [NAME] | Sheffield Wednesday
 |  |  |  | [NAME] | Sheffield Wednesday
 |  |  |  | Declan Call | Ipswich Town
 |  |  |  | [NAME] | Sunderland
 |  |  |  | Billy | [NAME]
 |  |  |  | [NAME] | Derby County
 |  |  |  | [NAME] | [NAME]
 |  |  |  | [NAME] | Ipswich Town
 |  |  |  | [NAME] | Stockport County
 |  |  |  | [NAME] | Millwall
 |  |  |  | [NAME] | Northampton Town
 |  |  |  | [NAME] | Stockport County
 |  |  |  | 0
Spreadsheet: 137688d1327324684-return-name-with-largest-value-in-multiple-column-array-book4
Sheet: Sheet1

Name |  |  |  |  | Average |  |  |  |  | Top 5 Scores
[NAME] |  |  |  |  | 5.2
[NAME] |  |  |  |  | 6.9
[NAME] |  |  |  |  | 7.3
[NAME] |  |  |  |  | 5.9
[NAME] |  |  |  |  | 6.9
Wilma |  |  |  |  | 8.1
[NAME] |  |  |  |  | 5.5
[NAME] |  |  |  |  | 2.3
Doug |  |  |  |  | 7.3
Vito |  |  |  |  | 9.2
[NAME] |  |  |  |  | 6.3
Spreadsheet: 712971d1610503653-need-to-use-a-2nd-set-of-data-to-break-a-rank-tie-daily-wheel-new-2
Sheet: Sheet1

Today's marketers rank |  |  |  | Hour>>>
Marketer | Shift Start | Shift End | On Shift? | Conversion | Rank
Spreadsheet: 843043d1695019313-vlookup-with-multiple-columns-array-book2
Sheet: Sheet1

d |  |  |  |  |  | q | 20980 | 45180 | 41788 | 25748 | 22254 | 91386
 | 10454 | 47408 |  |  |  | w | 3317 | 76310 | 25291 | 44282 | 75547 | 49933
 |  |  |  |  |  | s | 9368 | 95243 | 32264 | 56942 | 42789 | 87888
 |  |  |  |  |  | a | 61771 | 97750 | 14048 | 57339 | 33518 | 65827
 |  |  |  |  |  | d | 42959 | 10454 | 15714 | 47408 | 72926 | 37981
Spreadsheet: 713773d1610925497-unique-count-formula-with-2-conditions-unique-count
Sheet: Template

 |  |  | Column A |  | Column J
 |  |  |  |  | 2
[PHONE]-DP
[PHONE]-DP |  |  |  |  |  |  |  |  | 7315.24
[PHONE]-DP |  |  |  |  |  |  |  |  | 2556.3
[PHONE]-DP |  |  |  |  |  |  |  |  | 0 | *
[PHONE]-DP |  |  |  |  |  |  |  |  | 12264.29
[PHONE]-DP |  |  |  |  |  |  |  |  | 938.25
[PHONE]-DP |  |  |  |  |  |  |  |  | 685.59
[PHONE]-DP |  |  |  |  |  |  |  |  | 0
[PHONE]-DP |  |  |  |  |  |  |  |  | 2173.16
[PHONE]-DP |  |  |  |  |  |  |  |  | 12159.49
[PHONE]-DP |  |  |  |  |  |  |  |  | 2101.95
[PHONE]-DP |  |  |  |  |  |  |  |  | 13389.19
[PHONE]-DP |  |  |  |  |  |  |  |  | 7025.83
[PHONE]-DP |  |  |  |  |  |  |  |  | 6627.57
[PHONE]-DP |  |  |  |  |  |  |  |  | 3812.94
[PHONE]-DP |  |  |  |  |  |  |  |  | 3215.05
[PHONE]-DP |  |  |  |  |  |  |  |  | 1094.5
[PHONE]-DP |  |  |  |  |  |  |  |  | 5815.42
[PHONE]-DP |  |  |  |  |  |  |  |  | 6125.46
[PHONE]-DS |  |  |  |  |  |  |  |  | 5551.64
[PHONE]-DP |  |  |  |  |  |  |  |  | 5449.59
[PHONE]-DP
[PHONE]-DP |  |  |  |  |  |  |  |  | 11763.62
[PHONE]-DP |  |  |  |  |  |  |  |  | 6398.18
[PHONE]-DP |  |  |  |  |  |  |  |  | 4693.93
[PHONE]-DP |  |  |  |  |  |  |  |  | 0
[PHONE]-DP |  |  |  |  |  |  |  |  | 6979.89
[PHONE]-DP |  |  |  |  |  |  |  |  |  | *
Spreadsheet: 328535d1403938556-bonus-disqualifiers-for-excess-vacation-days-bonus-disqualifiers-ans2
Sheet: Your help

base bonus amount | 2903.336
# of work days | 21
Agent | Leave(s) |  | bonus
Agent 01 | 0
Agent 02 | 0.5
Agent 03 | 1
Agent 04 | 1.5
Agent 05 | 2
Agent 06 | 2.5
Agent 07 | 3
Agent 08 | 3.5
Agent 09 | 4
Agent 10 | 4.5
Agent 11 | 5
Agent 12 | 5.5
Agent 13 | 6
Agent 14 | 6.5
Agent 15 | 7
Agent 16 | 7.5
Spreadsheet: 41250d1239739584-updating-dates-on-separate-tabs-based-on-date-in-first-tab-form-booking-sheets-all-1
Sheet: Charters

CHARTER | Day | _________ |  |  | DATE of SERVICE: __________________, 2008
Booking & Trip Sheet
Billable Party / Concierge | Contact Person | Phone# | Job # | Event | # in party
Itinerary | P/U Time | P/U Location | D/O TIme | D/O Location | Pay Method
Leg 1
[NAME]
Leg 3
[NAME]
Leg 5
Leg 6
Leg 7
Leg 8
Trip Charge |  | Gratuity | [NAME] | Total Charter Price
Prepay - cc | Credit Card Type |  | Card #
 | Expiration Date |  | Run Date
 | Address / Zip Code
Prepay - check | Ck# |  | Date Rcvd |  | Attach Copy
[NAME] | Inv# |  | Date |  | Posted
Notes
Booked by |  |  | Approved by
 |  |  |  | Supervisor
Customer |  |  | Date
Acceptance
Spreadsheet: c59362e0-1f4a-4337-be70-357f41257eb4
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12
 |  | U.S. Census Bureau
 |  | Source: Monthly Retail Trade and Food Services
 |  | 44X72: Retail Trade and Food Services: U.S. Total
 |  | Seasonally Adjusted Sales - Monthly [Millions of Dollars]
 |  | Period: 1992 to 2012
 |  | Data Extracted on: April 19, 2014 (12:45 am)
Year | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
1992 | 164083 | 164260 | 163747 | 164759 | 165617 | 166098 | 167305 | 167797 | 169407 | 170681 | 171025 | 172995
1993 | 175078 | 173770 | 172328 | 176766 | 178445 | 178201 | 180759 | 180692 | 181800 | 182910 | 184746 | 186339
1994 | 185128 | 188077 | 191588 | 191632 | 190940 | 193196 | 193763 | 196157 | 197754 | 199579 | 199723 | 200670
1995 | 201583 | 198383 | 200230 | 201048 | 202993 | 205507 | 204959 | 206529 | 206978 | 206157 | 208661 | 210434
1996 | 208731 | 212011 | 213855 | 214644 | 216304 | 216059 | 216374 | 216355 | 219240 | 221039 | 220989 | 221898
1997 | 223524 | 225409 | 226136 | 224588 | 222906 | 226048 | 228738 | 229317 | 230284 | 229822 | 230486 | 231197
1998 | 231605 | 231664 | 233043 | 235976 | 237055 | 238958 | 237423 | 236412 | 238542 | 242531 | 244307 | 246577
1999 | 246891 | 249510 | 250657 | 252418 | 254738 | 255472 | 257441 | 260253 | 261352 | 261825 | 264883 | 269876
2000 | 268091 | 272026 | 275214 | 270998 | 271418 | 273440 | 272638 | 272954 | 277523 | 276973 | 275928 | 275727
2001 | 278911 | 278799 | 276473 | 280798 | 281546 | 280393 | 279522 | 281423 | 276095 | 294613 | 286960 | 283704
2002 | 283583 | 285061 | 284257 | 288827 | 284987 | 287401 | 290427 | 292593 | 288428 | 289646 | 291475 | 293812
2003 | 295302 | 291188 | 296352 | 295656 | 296411 | 299679 | 302821 | 307768 | 305947 | 304857 | 308587 | 307384
2004 | 309266 | 311444 | 316972 | 313569 | 319002 | 315017 | 318587 | 318997 | 324668 | 326726 | 327892 | 331902
2005 | 329799 | 332804 | 332419 | 337992 | 334757 | 342841 | 347368 | 342818 | 343419 | 344697 | 347504 | 347730
2006 | 357814 | 354495 | 356172 | 358092 | 356240 | 357580 | 360175 | 360657 | 358887 | 358801 | 359544 | 365057
2007 | 363384 | 364187 | 367753 | 366063 | 371032 | 368651 | 370162 | 371241 | 374597 | 375105 | 378173 | 375728
2008 | 375595 | 372016 | 372720 | 374900 | 376187 | 377752 | 376023 | 373932 | 367078 | 353736 | 341589 | 332965
2009 | 337508 | 336864 | 331478 | 332457 | 336028 | 340552 | 341854 | 349067 | 340107 | 342862 | 346528 | 347869
2010 | 347854 | 348269 | 356067 | 358200 | 356231 | 355935 | 356446 | 359108 | 361534 | 366758 | 369001 | 371152
2011 | 373430 | 376425 | 380759 | 382726 | 382866 | 385784 | 386747 | 387099 | 389985 | 394706 | 395729 | 394282
2012 | 397083 | 402385 | 405211 | 404053 | 403404 | 400037 | 402603 | 407514 | 412547 | 412405 | 413444 | 414558
Spreadsheet: 1d731125-b12a-4c9c-b7d8-0f333d2559c6
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5671.0 Lending Finance, Australia
 | TABLE 40. OPERATING LEASE FINANCE COMMITMENTS: By Lender: Australia, Original ($000)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Banks ; |  |  | Original | A2413831L | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | $'000 | FLOW | Month | 1
Finance Companies ; |  |  | Original | A2413832R | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | $'000 | FLOW | Month | 1
General Financiers ; |  |  | Original | A2413833T | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | $'000 | FLOW | Month | 1
Other Lessors ; |  |  | Original | A2413834V | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | $'000 | FLOW | Month | 1
TOTAL OPERATING LEASE FINANCE ; |  |  | Original | A2413835W | 1985-01-01 00:00:00 | 2011-08-01 00:00:00 | 320 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2011
Spreadsheet: 673899d1587581331-extracting-unique-text-from-a-row-of-data-unique-text-in-rows
Sheet: Sheet1

[NAME] is the result I require | Categories1 | Categories2 | Categories3 | Categories4
 | Parts > Bale Handling > Kongslide > Bale Spikes > Bale Spike | Parts > Bale Handling > JF - Stoll > Bale Spikes > Bale Spike
 | Parts > Bale Handling > Kongslide > Bale Spikes > Bale Spike | Parts > Bale Handling > Kongslide > Bale Spikes
 | Parts > Bale Handling > Kuhn > Bale Spikes > Bale Spike | Parts > Bale Handling > Kuhn > Bale Spikes
 | Parts > Bale Handling > Kuhn > Bale Spikes > Bale Spike | Parts > Bale Handling > Kuhn > Bale Spikes
 | Parts > Bale Handling > Kverneland > Bale Spikes > Bale Spike | Parts > Bale Handling > Dan Chief-Zens > Bale Spikes > Bale Spike | Parts > Bale Handling > Redrock > Bale Spikes > Bale Spike
Parts, [NAME], Desvoys, Kverneland, [NAME], [NAME] | Parts > Bale Handling > Kverneland > Bale Spikes > Bale Spike | Parts > Bale Handling > Desvoys > Bale Spikes > Bale Spike | Parts > Bale Handling > Kverneland > Bale Spikes
 | Parts > Bale Handling > Kverneland > Bale Spikes > Bale Spike | Parts > Bale Handling > Kongslide > Bale Spikes > Bale Spike | Parts > Bale Handling > JF - Stoll > Bale Spikes > Bale Spike | Parts > Bale Handling > Desvoys > Bale Spikes > Bale Spike
 | Parts > Bale Handling > Kverneland > Bale Spikes > Bale Spike | Parts > Bale Handling > Kongslide > Bale Spikes > Bale Spike | Parts > Bale Handling > JF - Stoll > Bale Spikes > Bale Spike | Parts > Bale Handling > Desvoys > Bale Spikes > Bale Spike
 | Parts > Bale Handling > Kverneland > Bale Spikes > Bale Spike | Parts > Bale Handling > Redrock > Bale Spikes > Bale Spike | Parts > Bale Handling > Manitou > Bale Spikes > Bale Spike
 | Parts > Bale Handling > Kverneland > Bale Spikes > Bale Spike | Parts > Bale Handling > Schaffer > Bale Spikes > Bale Spike | Parts > Bale Handling > Manitou > Bale Spikes > Bale Spike
Spreadsheet: 873350d1719853202-find-balance-stock-stock-management-jt
Sheet: Sheet2 (2)

NO. | Name |  |  |  |  | 2024-06-24 00:00:00 |  | 2024-06-25 00:00:00 |  | 2024-06-26 00:00:00 |  | 2024-06-27 00:00:00 |  | 2024-06-28 00:00:00 |  | 2024-06-29 00:00:00
 |  | Bal Stock | Helper | Helper | Helper | STORE | AQUA | STORE | AQUA | STORE | AQUA | STORE | AQUA | STORE | AQUA | STORE | AQUA
A | DELUXE SCOTH WHISKY
1 | J.W BLACK LABEL |  |  |  |  | 6 | 2 | 4 | 7 | 12 | 2
2 | J.W RED LABEL |  |  |  |  | 4 | 4 | 10 | 6 | 12 | 7
3 | TEACHERS H.L.CREAM |  |  |  |  | 8 | 5 | 5 | 4 | 12 | 1
4 | TEACHERS H.L.CREAM |  |  |  |  | 4 | 1 | 3 | 3 | 12 | 4
5 | BLACK DOG |  |  |  |  | 5 | 5 | 12 | 8 | 12 | 4
6 | VAT 69 |  |  |  |  | 6 | 3 | 5 | 6 | 12 | 5
7 | BLACK AND WHITE |  |  |  |  | 4 | 2 | 5 | 1 | 12 | 1
8 | BALLANTINE'S |  |  |  |  | 9 | 7 | 20 | 7 | 6 | 5
9 | 100 PIPER |  |  |  |  | 6 | 1 | 3 | 7 | 12 | 3
10 | JAMESON |  |  |  |  | 12 | 4 | 8 | 4 | 6 | 4
11 | CHIVAS REGAL |  |  |  |  | 32 | 14 | 20 | 9 | 6 | 12
12 | AMERICAN |  |  |  |  | 50 | 34 | 30 | 42 | 60 | 38
13 | JAGERMEISTER |  |  |  |  | 5 | 5 | 12 | 9 | 12 | 12
Spreadsheet: 843048d1695023899-creating-a-student-attendance-sheet-with-automated-attendance-example-1-1
Sheet: Sheet1

 | 2023-09-16 00:00:00
Time | S/N | Student Name | [NAME]
10.30  -  12.00 |  | Adam | 1
 |  | [NAME] | 5
 |  | [NAME] | 2
 |  | Dane | 2
 |  | Emmy | 3
 |  | Fish | 7
 |  | Grace | 8
 | 8 | Test | -1
 |  | Adam
 |  | [NAME] | 6
 |  | [NAME] | 3
 |  | Dane | 3
 |  | Emmy | 4
 |  | Fish | 8
 |  | Grace | -1
 | 8 | Test | -2
Spreadsheet: 96041d1295520787-netting-down-amount-using-available-figures-simplegoalseektofindatotal-1-
Sheet: template

100 | 1
-10 |  | -1.917074024919469e+21 |  | To run this model:
-50 |  |  |  | Data.What_if.Goal_Seek
-33
-40 |  |  |  | • | Set cell: A10
 |  |  |  | • | To: 0
 |  |  |  | • | By changing: C2
 |  |  |  | • | Click: OK
Spreadsheet: 767918d1644735639-top-n-values-sample
Sheet: Sheet1

Student | Marks
Rajesh |  |  | Top N | Student | Marks
[NAME] |  |  | 2 | Ramesh | 0.67
Milton |  |  |  | Mark | -0.33
Mark
Ramesh
Martin
Spreadsheet: 649061d1573457921-run-time-error-in-macro-time-series-upper-aquifer-qw-spreadsheet
Sheet: Well 46

Well | Date | pH | EC | Ca | [NAME] | Na | Alk as CaCO3 | HCO3  as  CaCO3 | CO3  as  CaCO3 | SO4 | Cl | TDS | SAR | SARadj | B | NO3-N | Cu | Fe | Mn | Zn | L.I. |  | Sum cat | [NAME] | % dif
 | Sampled | unit | dS/m | meq/L | meq/L | meq/L | meq/L | meq/L | meq/L | meq/L | meq/L | mg/L |  |  | mg/L | mg/L | mg/L | mg/L | mg/L | mg/L | Calc
46 | 2007-02-16 00:00:00 | 7.8 | 0.81 | 5 | 1.9 | 2 | 3.6 |  |  |  | 3.5 |  | 1.522773975253762 | 1.3 | 0 | 10 |  |  |  |  | 0.6
Well #46 | 2013-10-11 00:00:00 | 6.7 | 1.58 | 8 | 3.07 | 3.2 | 1.3 |  |  | 3.9 | 9 |  | 1.4 | 2.7 | 0.05 | 5.4 |  | <0.10 | <0.02 |  | -0.8
Well - 46 | 2014-02-05 00:00:00 | 7.7 | 1.71 | 9.42 | 3.75 | 2.9 | 4.8 |  |  | 0.9 | 11 |  | 1.1 | 2.9 | 0.05 | 8.4 |  | <0.10 | <0.02 |  | 0.9
Well 46 | 2015-04-02 00:00:00 | 7.8 | 1.91 | 10.02 | 4.28 | 3.3 | 4.6 |  |  | 1 | 12 |  | 1.2 | 3.2 | <0.05 | 8 |  | <0.10 | <0.02 |  | 1
Well 46 | 2016-04-04 00:00:00 | 7.74 | 2.061 | 13 | 5.29 | 3.9 | 4.526017104947647 | 4.526017104947647 | 0 | 1.254 | 12.794 | 1318.4 | 1.29 | 3.24 | 0.04 | 8.301070000000001 | 0.024 | 0.005 | 0 | 0.037
W46 | 2018-05-29 00:00:00 | 7.98 | 2.006 | 12.7 | 5.17 | 4.32 |  | 4.779793781472304 | 0 | 1.25 | 9.214 | 1283.84 |  |  | 0.036 | 8.939 | 0.058 | 0 | 0 | 0.005
Spreadsheet: 106704d1303918061-transposing-row-from-one-tab-to-another-based-on-criteria-schedule_exp
Sheet: List

 | FORMULA | [NAME] | SCHEDULE MONTH
 | 1 | Product A | January
 | 2 | Product B | February
 | 3 | Product A | January
 | 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
Spreadsheet: 63419d1264344818-results-from-multiple-sheets-to-table-example
Sheet: Price

Plot | Type | Joists 1st | joists | Roof | Low Levels | Garage | 1st Fix | External | 2nd Fix | Final | Snag | Ironmongery | Total
 |  | floor | 2nd floor |  | Levels | Roof |  | doors
 |  |  |  |  |  |  |  |  |  | Job Total
 |  |  |  |  | 7
Spreadsheet: 738409d1625024193-xlookup-with-wildcards-sample
Sheet: Sheet1

 |  |  |  |  |  |  | Reference Table
 |  |  |  |  |  |  | Start Date | Day | Total duration | Cost
 |  |  |  |  |  |  | 2021-04-27 00:00:00 | Tuesday - Person 1 | 5.5 | 1
 |  |  |  |  |  |  | 2021-04-27 00:00:00 | Tuesday - Person 2 | 3.500000000000001 | 2
 |  |  |  |  |  |  | 2021-04-29 00:00:00 | Thursday - Person 3 | 1.000000000000002 | 3
 |  |  |  |  |  |  | 2021-05-04 00:00:00 | Tuesday - Person 3 | 4.500000000000002 | 4
 |  |  |  |  |  |  | 2021-05-11 00:00:00 | Tuesday - Person 2 | 5.5 | 5
Start Date | Day | Person 1 | Total duration | Cost Intened | Actual
2021-05-04 00:00:00 | Tuesday | Person 3 | 4.500000000000002 | 4
Spreadsheet: 151734d1335095757-error-message-the-pivottable-field-is-not-valid-3ak
Sheet: MC D IS 1

MARSHELLING CABINET  D IS - F
B |  |  |  | C |  |  |  | D
CABLE NO. | CABLE SIZE |  | SIGNALS NO. | CABLE NO. | CABLE SIZE |  | SIGNALS NO. | CABLE NO. | CABLE SIZE |  | SIGNALS NO.
1071-218-ESDV-034-LCP | 24P X 1.0 MM2 | #N/A | 16 | 1071-218-ESDV-254-LCP | 24P X 1.0 MM2 | #N/A | 14 | 1071-218-ESDV-314-LCP | 24P X 1.0 MM2 | #N/A | 16
1071-218-ESDV-035-LCP | 24P X 1.0 MM2 | #N/A | 16 | 1071-218-ESDV-255-LCP | 24P X 1.0 MM2 | #N/A | 15 | 1071-218-ESDV-327-LCP | 24P X 1.0 MM2 | #N/A | 15
1071-218-ESDV-047-LCP | 24P X 1.0 MM2 | #N/A | 16 | 1071-218-ESDV-313-LCP | 24P X 1.0 MM2 | #N/A | 17 | 1071-218-ESDV-360-LCP | 24P X 1.0 MM2 | #N/A | 17
 |  |  | 48 |  |  |  | 46 |  |  |  | 48
MARSHELLING CABINET  D IS - R
B |  |  |  |  | C
54 |  |  |  |  | 53
Spreadsheet: 748682d1632290478-populate-dynamic-calendar-with-tasks-based-on-task-frequency-tasks-calendar-ans3
Sheet: Oct 21

2021-10-01 00:00:00 | Task1 | [NAME] | Task3 | Task4 | Task5 | Task6 | Task7 | Task8 | Task9 | Task10
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Example
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Day one, week one should be the first Monday of the month.
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Quarterly should be January, April, July and October.
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Biannually should be March and September.
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Some days will have multiple tasks. No tasks fall on a Sunday, Wednesday or Saturday.
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Sample task one | Daily | Weekly | Monthly
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Sample task two | Day 1 | Week 1 | Odd Months |  | First Monday
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Sample task three | Day 2 | Week 2 | Even Months |  | second Tuesday
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Sample task four | Day 4 | Week 3 | Quarterly |  | Thursday
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Sample task five | Day 5 | Week 4 | Biannualy |  | Friday
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Sample task six | Day 2 | Odd Weeks | Monthly |  | Tuesday
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Sample task seven | Day 4 | Even Weeks | Monthly |  | Thursday
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Sample task eight | Day 2 | Weekly | Monthly |  | Monday
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Sample task nine | Day 4 | Weekly | Odd Months |  | Thursday
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Sample task ten | Day 5 | Weekly | Even Months |  | Friday