tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 868015d1714730920-why-is-this-not-working-test
Sheet: Bud24

Test
Profit & Loss Account
Test
 |  |  | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2023 | 2022 | 2021 | 2020 | 2019
 |  |  | Actual | Actual | Actual | Actual | Actual | Actual | Projections | Projections | Projections | Projections | Projections | Projections
 |  |  | 2024-01-31 00:00:00 | 2024-02-29 00:00:00 | 2024-03-31 00:00:00 | 2024-04-30 00:00:00 | 2024-05-31 00:00:00 | 2024-06-30 00:00:00 | 2024-07-31 00:00:00 | 2024-08-31 00:00:00 | 2024-09-30 00:00:00 | 2024-10-31 00:00:00 | 2024-11-30 00:00:00 | 2024-12-31 00:00:00 | Total | Total | Total | Total | Total | Total | Period | YTD
 |  |  | £ | £ | £ | £ | £ | £ | £ | £ | £ | £ | £ | £ | £ | £ | £ | £ | £ | £
Turnover
FC | 0 | FC |  |  |  |  |  |  |  |  |  |  |  |  | 0
EF | 0.55 | EF | 393628.3149758456 | 442831.8543478262 | 548973.3080917876 | 449191.2293478262 | 449191.2293478262 | 548629.5580917876 | 486437.6338768117 | 548801.4330917876 | 486437.6338768117 | 473964.8740338166 | 548457.6830917876 | 344424.7756038647 | 5720969.527777779
S | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
T | 0.15 |  | 107353.1768115942 | 120772.3239130435 | 149719.9931159421 | 122506.6989130435 | 122506.6989130435 | 149626.2431159421 | 132664.8092391304 | 149673.1181159421 | 132664.8092391304 | 129263.1474637681 | 149579.3681159421 | 93934.02971014493 | 1560264.416666667
E | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
A | 0.15 |  | 107353.1768115942 | 120772.3239130435 | 149719.9931159421 | 122506.6989130435 | 122506.6989130435 | 149626.2431159421 | 132664.8092391304 | 149673.1181159421 | 132664.8092391304 | 129263.1474637681 | 149579.3681159421 | 93934.02971014493 | 1560264.416666667
D | 0.15 |  | 107353.1768115942 | 120772.3239130435 | 149719.9931159421 | 122506.6989130435 | 122506.6989130435 | 149626.2431159421 | 132664.8092391304 | 149673.1181159421 | 132664.8092391304 | 129263.1474637681 | 149579.3681159421 | 93934.02971014493 | 1560264.416666667
Other incl accrued income adj
 |  |  | 715687.8454106282 | 805148.8260869567 | 998133.2874396137 | 816711.3260869567 | 816711.3260869567 | 997508.2874396137 | 884432.061594203 | 997820.7874396137 | 884432.061594203 | 861754.3164251209 | 997195.7874396137 | 626226.8647342995 | 10401762.77777778 |  |  |  |  |  |  |  |  |  |  | 755769
Spreadsheet: 81253d1281486650-organizing-data-by-time-on-a-different-sheet-tourneyprogram
Sheet: Sheet1

Name | Day 1 - Tee Time | Day 1 - Starting Tee
[NAME] | 08:40:00 | 1
[NAME] | 08:50:00 | 1
[NAME] | 09:00:00 | 1
[NAME], [NAME] | 09:10:00 | 1 |  | Look at the code and see if this is what you want.
Eastern, [NAME] | 09:20:00 | 1
Fisher, [NAME] | 09:30:00 | 1
[NAME], [NAME] | 09:40:00 | 1
Likkel, [NAME] | 09:50:00 | 1
[NAME], [NAME] | 10:00:00 | 1
Engstrom, [NAME] | 10:10:00 | 1
Mills, [NAME] | 10:20:00 | 1
Weil, [NAME] | 10:30:00 | 1
Yager, Arne | 10:40:00 | 1
Dworkis, Rich | 10:50:00 | 1
Campbell, [NAME] | 08:40:00 | 10
Lauer, Dale | 08:50:00 | 10
Doherty, [NAME] | 09:00:00 | 10
Vanderhoek, Lanny | 09:10:00 | 10
Clarke, Greg | 09:20:00 | 10
Parsons, [NAME] | 09:30:00 | 10
[NAME], [NAME] | 09:40:00 | 10
Haugen, [NAME] | 09:50:00 | 10
Honjiyo, Wally | 10:00:00 | 10
Course Slope= | 10:10:00 | 10
[NAME], [NAME] | 10:20:00 | 10
Sorby, [NAME] | 10:30:00 | 10
[NAME], [NAME] | 10:40:00 | 10
Burgess, Jim | 10:50:00 | 10
Holmes, Doug | 08:40:00 | 1
Lewis, [NAME] | 08:50:00 | 1
Bankhead, [NAME] | 09:00:00 | 1
Emerson, [NAME] | 09:10:00 | 1
Sisson, [NAME] | 09:20:00 | 1
Nakao, [NAME] | 09:30:00 | 1
Colburn, [NAME] | 09:40:00 | 1
[NAME], [NAME] | 09:50:00 | 1
[NAME], [NAME] | 10:00:00 | 1
[NAME], [NAME] | 10:10:00 | 1
[NAME], [NAME] | 10:20:00 | 1
McDowell, [NAME] | 10:30:00 | 1
Neu, Fred | 10:40:00 | 1
Smith, [NAME] | 10:50:00 | 1
Ronhaar, [NAME] | 08:40:00 | 10
Hewitt, [NAME] | 08:50:00 | 10
[NAME], [NAME] | 09:00:00 | 10
[NAME], [NAME] | 09:10:00 | 10
[NAME], [NAME] | 09:20:00 | 10
Dawson, [NAME] | 09:30:00 | 10
[NAME], [NAME] | 09:40:00 | 10
Fischer, [NAME] | 09:50:00 | 10
Hopson, Clarence | 10:00:00 | 10
Hunkapiller, [NAME] | 10:10:00 | 10
[NAME], [NAME] | 10:20:00 | 10
Uno, Tosh | 10:30:00 | 10
Kopp, Bud | 10:40:00 | 10
Alexander, Dennis | 10:50:00 | 10
[NAME], [NAME] | 11:00:00 | 1
Fredrickson, [NAME] | 11:10:00 | 1
[NAME], [NAME] | 11:20:00 | 1
Primiani, [NAME] | 11:30:00 | 1
Canterbury, [NAME] | 11:40:00 | 1
[NAME], [NAME] | 11:50:00 | 1
[NAME], Robb | 12:00:00 | 1
Halley, [NAME] | 12:10:00 | 1
Spreadsheet: daren_farmer__5320__hpl0622
Sheet: Sheet1

HPLN0622.XLS |  | Fax # [PHONE]
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL;  AMI_CHOSKI / ENRON
FROM:  [NAME]  (TU ELECTRIC)
SUBJECT:  NOMINATIONS - Effective June 22, 2000
 |  |  |  |  |  | ** Wednesday
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 2000-06-21 00:00:00
 |  |  |  |  |  | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream | NOM
Enron (FM) |  | LS HPL [NAME] |  | HPL
 |  |  |  |  |  | 0 to 60  0900hrs
 |  |  |  |  |  | 60  to 0 2100hrs
Enron (FM) |  | HPL - Katy (DBND) |  | HPL | 0 | 0
 |  | Firm Summary
ENRON (S) |  | Oasis Turbine |  | ENA | 5 | 5
 |  | Enron North America Spot/3959
OTHER ENRON/HPL TRANSPORTS: |  |  |  | Downstream
Empire (Enron) |  | TOG 3 |  | Empire | 1.4 | 1.4
Empire (Enron) |  | [NAME]. |  | Empire | 8 | 8
Empire (Enron) |  | SANDHILLS |  | Empire | 0.65 | 0.65
Empire (Enron) |  | Oasis Turbine |  | Empire | 7.95 | 7.95
 |  | Total Other Transports:
NOTE:  Additional swing volumes may be requested at Teco Tap, or Texoma by TUFCO Gas Control under either the
Wagner Brown K# 1901 or HPL K# 3949 agreements.
*  Nominations to continue until TU Electric changes such nominations.
CC:   [NAME] | [NAME]
R. Skerik | [NAME]
G. Green | K. English
B. Fleming | GCC Dispatcher
Spreadsheet: 150094d1334278200-copying-data-to-another-worksheet-answer-sheet
Sheet: TEST #1

TEST 01 ANSWERS
FIRST NAME |  | [NAME] |  |  | INIT | B
LAST NAME |  | [NAME]
1 | B | B | 1
2 | C | C | 1
3 | C | C | 1
4 | A | A | 1
5 | B | B | 1
6 | D | D | 1
7 | B | B | 1
8 | C | B | 0
9 | D | D | 1
10 | C | C | 1
 |  |  | 9 | Points
 |  |  | 90 | %
Spreadsheet: 806743d1669550552-populating-cells-with-number-of-hours-taken-during-that-week-book2-update
Sheet: Sheet2

 | Week Ending
[NAME] | 2022-11-12 00:00:00 | 2022-11-19 00:00:00 | 2022-11-26 00:00:00 | 2022-12-03 00:00:00 | 2022-12-10 00:00:00 | 2022-12-17 00:00:00 | 2022-12-24 00:00:00 | 2022-12-31 00:00:00 | 2023-01-07 00:00:00 | 2023-01-14 00:00:00 | 2023-01-21 00:00:00 | 2023-01-28 00:00:00 | 2023-02-04 00:00:00 | 2023-02-11 00:00:00 | 2023-02-18 00:00:00 | 2023-02-25 00:00:00 | 2023-03-04 00:00:00 | 2023-03-11 00:00:00 | 2023-03-18 00:00:00 | 2023-03-25 00:00:00
Leave |  |  | 37.5 | 22.5 |  |  |  |  |  |  |  |  |  |  | 8
Spreadsheet: 170941d1343527087-populate-matrix-using-database-information-accounting
Sheet: Invoice

 |  |  |  |  |  | INVOICE
 |  |  |  |  | DATE:
 |  |  |  |  | INVOICE # | [123456]
 |  |  |  |  | Customer ID | [123]
BILL TO: |  |  | SHIP TO (if different):
[Name] |  |  | [Name]
[Street Address] |  |  | [Street Address]
[City, ST  ZIP] |  |  | [City, ST  ZIP]
[Phone] |  |  | [Phone]
For office use only | Referred by | Session date | Order date | Notes
ITEM # | [NAME] |  |  | QTY | UNIT PRICE | TOTAL
 | [NAME] |  |  | 1
 | iPhone Cover |  |  | 1
 | 16x20 |  |  | 3
 | Deluxe                                  1 - 11x14                               6 - Digital Files                    10 - Gift Prints                      1 - Mini Accordian Albums(3) |  |  | 1
 |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  | 54
 |  |  |  |  |  |  |  | 56
 |  |  |  | [42] | SUBTOTAL |  |  | 7
Other Comments or Special Instructions |  |  |  |  | TAX RATE | 0.0675 |  | 8
1. Total payment due in 30 days |  |  |  |  | TAX |  |  | 8
2. Please include the invoice number on your check |  |  |  |  | S & H | 0 |  | 9
 |  |  |  |  | OTHER | 0
 |  |  |  |  | TOTAL
Thank You For Your Business!
Please detach the portion below and return it with your payment.
REMITTANCE
 |  |  |  |  | DATE
 |  |  |  |  | INVOICE #
 |  |  |  |  | Customer ID
 |  |  |  | AMOUNT ENCLOSED
Spreadsheet: 815619d1675091446-compare-two-pair-of-cells-function-usage-rede-coletora-de-esgoto2
Sheet: APOIO

 | PV montante | [NAME] jusante | Comprimento
 | 117 | 118 | 56.596
 | 116 | 118 | 49.927
 | 115 | 116 | 51.409
 | 114 | 115 | 53.205
 | 113 | 116 | 9.672
 | 112 | 113 | 54.228
 | 111 | 112 | 43.143
 | 110 | 111 | 14.421
 | 109 | 110 | 15.495
 | 108 | 113 | 42.262
 | 107 | 108 | 47.584
 | 106 | 107 | 45.177
 | 105 | 106 | 18.445
 | 104 | 105 | 17.515
 | 103 | 104 | 14.831
 | 102 | 103 | 13.422
 | 101 | 108 | 9.371
 | 100 | 101 | 81.778
 | 99 | 100 | 32.617
 | 98 | 99 | 10.334
 | 97 | 98 | 26.181
 | 96 | 97 | 19.277
 | 95 | 96 | 21.452
 | 94 | 95 | 29.15
 | 93 | 101 | 42.687
 | 92 | 93 | 49.314
 | 91 | 92 | 38.643
 | 90 | 91 | 35.357
 | 89 | 90 | 9.634
 | 88 | 89 | 26.771
 | 87 | 88 | 20.934
 | 86 | 87 | 27.469
 | 85 | 86 | 20.316
 | 84 | 85 | 28.513
 | 83 | 87 | 10.019
 | 82 | 83 | 25.7
 | 81 | 82 | 23.889
 | 80 | 81 | 39.485
 | 79 | 80 | 49.494
 | 78 | 79 | 57.348
 | 77 | 118 | 46.093
 | 76 | 77 | 87.347
 | 75 | 76 | 53.328
 | 74 | 77 | 42.579
 | 73 | 74 | 74.624
 | 72 | 73 | 59.955
 | 71 | 72 | 13.041
 | 70 | 72 | 74.586
 | 69 | 70 | 59.063
 | 68 | 70 | 42.571
 | 67 | 68 | 59.378
 | 65 | 66 | 11.222
 | 64 | 65 | 73.256
 | 63 | 64 | 72.796
 | 62 | 63 | 75.809
 | 61 | 62 | 99.549
 | 60 | 61 | 60.816
 | 59 | 65 | 48.49
 | 58 | 59 | 89
 | 57 | 58 | 89.371
 | 56 | 59 | 10.475
 | 55 | 56 | 84.231
 | 54 | 55 | 89.461
 | 53 | 56 | 48.02
 | 52 | 53 | 92.1
 | 51 | 52 | 60.362
 | 50 | 53 | 10.67
 | 49 | 50 | 88.073
 | 48 | 49 | 58.862
 | 46 | 47 | 23.25
 | 45 | 46 | 37.574
 | 44 | 45 | 42.501
 | 43 | 44 | 23.25
 | 42 | 43 | 28.529
 | 41 | 42 | 23.111
 | 40 | 41 | 25.126
 | 39 | 40 | 21.574
 | 38 | 39 | 18.303
 | 37 | 38 | 56.191
 | 36 | 38 | 22.639
 | 35 | 36 | 33.464
 | 34 | 35 | 33.188
 | 33 | 34 | 10.307
 | 32 | 33 | 67.88
 | 31 | 32 | 55.771
 | 30 | 34 | 64.434
 | 29 | 30 | 55.275
 | 28 | 36 | 60.157
 | 27 | 42 | 11.925
 | 26 | 27 | 11.5
 | 25 | 26 | 11.282
 | 24 | 25 | 54.337
 | 23 | 24 | 92.246
 | 22 | 25 | 21.294
 | 21 | 22 | 98.016
 | 20 | 26 | 26.708
 | 19 | 20 | 90.547
 | 18 | 26 | 26.698
 | 17 | 18 | 21.396
 | 16 | 17 | 90.764
 | 15 | 27 | 81.457
 | 14 | 15 | 70.055
 | 13 | 27 | 42.42
 | 12 | 13 | 76.923
 | 11 | 12 | 74.466
 | 10 | 13 | 9.807
 | 9 | 10 | 40.819
 | 8 | 10 | 78.227
 | 7 | 8 | 72.467
 | 6 | 7 | 11.981
 | 5 | 6 | 19.196
 | 4 | 5 | 9.5
 | 3 | 4 | 76.871
 | 2 | 5 | 23.897
 | 01-C | 9 | 44.431
 | 01-B | 2 | 55.011
 | 01-A | 01-B | 56.275
Spreadsheet: 375931d1423412615-lists-and-sheets-materials
Sheet: Master List

Part No | QTY
 | 1
 | 3
 | 5
 | 6
 | 7
 | 8
 | 9
 | 8
 | 9
Spreadsheet: 43113d1241708665-nesting-various-formulas-using-dates-and-salary-example
Sheet: Acctg

 |  |  | Severance
 |  |  |  |  |  | Act | Act | Act | Fcst | Fcst | Fcst | Fcst | Fcst | Fcst | Fcst | Fcst | Fcst
 |  |  | Person | Salary |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Total
 |  |  | x | 100000 |  | 4166.666666666667 | 8333.333333333334 | 8333.333333333334 | 8333.333333333334 |  |  |  |  |  |  |  |  | 29166.66666666667
Spreadsheet: 034af40e-e6d4-464e-bff2-7b09b12e5c9d
Sheet: Rate Summary

Service Center Rate Summary Sheet - Operating Budget
 |  |  | TOTAL
 | Service 1 | Service 2
Prior Year Fund Balance (if applicable)
ANNUAL COSTS
Salaries and [NAME]
Travel
Operating Costs
Equipment < $5,000
Capital equipment depreciation
SUB-TOTAL ANNUAL SERVICE COSTS W/ SUBSIDIES
Estimated 2 months working capital
TOTAL ANNUAL SERVICE COSTS W/ SUBSIDIES
% of Total Costs
Revised Prior Year Balance (Add Deficit, Subtract Surplus)
TOTAL REVISED COSTS
# of Annual Units
Unit Base
CALCULATED RATE PER SERVICE PER UNIT W/ SUBSIDIES
UNIT RATE THAT WILL BE CHARGED TO [NAME] | 0 | 0
Current year rates
SUBSIDIES |  |  | TOTAL
Salaries
Travel
Operating Expense
Equipment <$5,000
Depreciation
TOTAL SUBSIDIES
TOTAL SERVICE COSTS (Excludes previous year carryforward)
FULLY COSTED RATES
Spreadsheet: 830820d1685133917-how-to-use-xlookup-with-a-max-date-criteria-sample-3-aligw
Sheet: Sheet1

[NAME] | Value | Value Date |  | Result |  | Value | Value Date
21185 | -1.27 | 2020-12-12 00:00:00 |  |  | 21185 | -1.27 | 2020-12-12 00:00:00
21185 | -0.25 | 2020-10-21 00:00:00 |  |  | 21219 | -1.1 | 2020-12-12 00:00:00
21185 | -0.25 | 2020-09-30 00:00:00 |  |  | 24011 | -0.95 | 2020-11-10 00:00:00
21219 | -1.1 | 2020-12-12 00:00:00 |  |  | 24015 | -0.45 | 2020-04-04 00:00:00
21219 | -0.4 | 2020-08-29 00:00:00 |  |  | 24031 | 0.111 | 2020-09-30 00:00:00
21219 | -1.29 | 2020-04-11 00:00:00
21219 | 0 | 2020-03-05 00:00:00
24011 | -0.95 | 2020-11-10 00:00:00
24011 | 0 | 2020-09-30 00:00:00
24011 | -0.52 | 2020-02-20 00:00:00
24015 | -0.43 | 2020-02-20 00:00:00
24015 | -0.45 | 2020-04-04 00:00:00
24031 | -0.38 | 2020-03-28 00:00:00
24031 | 0.111 | 2020-09-30 00:00:00
24031 | -0.71 | 2020-05-18 00:00:00
21182
21216
24014
24015
24031
Spreadsheet: 771727d1646819476-select-conditional-data-from-a-table-select-conditional-data-from-a-table-rev-001
Sheet: Sheet2

 |  |  | Desired result:All SerialNumber and Remark where Info is Good. Does not need to be a table |  |  | Actual Results
 |  |  |  |  |  |  |  |  |  | Apple
 |  |  |  |  |  |  |  |  | 645 | Burger
 |  |  |  |  |  |  |  |  | 166 | Pizza
Spreadsheet: 728352d1618414818-index-and-match-to-return-a-date-based-on-a-ranked-day-of-the-week-index-match-date-based-on-day-of-the-week-rank-my-solution
Sheet: Sheet2

Thu | 5
Fri | 1
Sat | 2
Sun | 3
Mon | 4
Tue | 6
Wed | 7
Spreadsheet: c21d9461-b533-41bd-8ab8-6cbc36b80526
Sheet: Sheet1

ROASTER FOR THE PERIOD OF APRIL TO MAY
NAME/DATE | MON30 | TUES01 | WED02 | THURS03 | FRI04 | SAT05 | SUN06
ALVIN | OFF | A.M | P.M | P.M | OFF | P.M | P.M
SHAHIL | P.M | P.M | OFF | A.M | P.M | OFF | OFF
ANUSHKA | A.M | OFF | A.M | OFF | A.M | A.M | A.M
TINA | A.M | OFF | A.M | OFF | A.M | A.M | A.M
NAME/DATE | MON07 | TUES08 | WED09 | THURS10 | FRI11 | SAT12 | SUN13
ALVIN | P.M | P.M | OFF | P.M | A.M | OFF | OFF
SHAHIL | OFF | A.M | P.M | OFF | P.M | P.M | P.M
ANUSHKA | A.M | OFF | A.M | A.M | OFF | A.M | A.M
TINA | A.M | OFF | A.M | A.M | OFF | A.M | A.M
NAME/DATE | MON14 | TUES15 | WED16 | THURS17 | FRI18 | SAT19 | SUN20
ALVIN | A.M | P.M | OFF | OFF | A.M | P.M | P.M
SHAHIL | P.M | OFF | P.M | P.M | P.M | OFF | OFF
TINA | OFF | A.M | A.M | A.M | OFF | A.M | A.M
ANUSHKA | OFF | A.M | A.M | A.M | OFF | A.M | A.M
NAME/DATE | MON21 | [NAME] | WED23 | THURS24 | FRI25 | SAT26 | SUN27
ALVIN | P.M | P.M | OFF | P.M | OFF | P.M | P.M
SHAHIL | A.M | OFF | P.M | OFF | P.M | A.M | A.M
ANUSHKA | OFF | A.M | A.M | A.M | A.M | OFF | OFF
TINA | OFF | A.M | A.M | A.M | A.M | OFF | OFF
Spreadsheet: 299962d1393338363-loop-through-log-extract-unique-name-and-populate-table-with-occurrences-my-sample
Sheet: Sheet1

 |  |  |  | 2014
Date | Referral Type | Source |  | Source | January | February | March | April | May | June | July | August | September | October | November | December | Current Year
2014-02-24 00:00:00 | Doctor | [NAME], [NAME] |  | [NAME], [NAME] |  | 3 | 1 | 1 |  |  |  |  |  |  |  |  | 5
2014-02-24 00:00:00 | Doctor | [NAME], [NAME] |  | Affordable Dental |  | 2 | 1 |  | 1 |  |  |  |  |  |  |  | 4
2014-02-24 00:00:00 | Doctor | Affordable Dental |  | [NAME], [NAME] |  |  | 1 | 1 |  |  |  |  |  |  |  |  | 2
2014-02-24 00:00:00 | Doctor | Affordable Dental |  | Hall, Angel |  |  | 1 |  |  |  |  |  |  |  |  |  | 1
2014-02-24 00:00:00 | Doctor | Affordable Dental |  | [NAME], [NAME] |  | 2 |  | 2 | 1 |  |  |  |  |  |  |  | 5
2014-02-24 00:00:00 | Doctor | [NAME], [NAME] |  | Smith, [NAME] |  |  |  |  | 1 |  |  |  |  |  |  |  | 1
2014-02-24 00:00:00 | Doctor | [NAME], [NAME]
2014-03-24 00:00:00 | Doctor | Hall, Angel
2014-03-24 00:00:00 | Doctor | Affordable Dental
2014-03-24 00:00:00 | Doctor | [NAME], [NAME]
2014-03-24 00:00:00 | Doctor | [NAME], [NAME]
2014-04-24 00:00:00 | Doctor | [NAME], [NAME]
2014-04-24 00:00:00 | Doctor | Affordable Dental
2014-04-24 00:00:00 | Doctor | [NAME], [NAME]
2014-04-24 00:00:00 | Doctor | [NAME], [NAME]
2014-05-25 00:00:00 | Doctor | Smith, [NAME]
2014-05-25 00:00:00 | Doctor | [NAME], [NAME]
2014-05-25 00:00:00 | Doctor | Affordable Dental
Spreadsheet: 873776d1720347490-how-to-find-total-of-working-hours-from-a-single-cell-kvemperor-working-hours-shop-aligw
Sheet: SUNDAYS 2024 (2)

 |  | 2024
 |  | SHOP1 |  |  | SHOP2
 |  | 2024-05-05 00:00:00 | PERSON 1 |  | 2024-05-05 00:00:00 | PERSON 1
 |  | 2024-05-12 00:00:00 | PERSON 2 |  | 2024-05-12 00:00:00 | PERSON 2
 |  | 2024-05-19 00:00:00 | PERSON 1 |  | 2024-05-19 00:00:00 | PERSON 5
 |  | 2024-05-26 00:00:00 | PERSON 3 |  | 2024-05-26 00:00:00 | PERSON 3
 |  | 2024-06-02 00:00:00 | PERSON 2 |  | 2024-06-02 00:00:00 | PERSON 2
 |  | 2024-06-02 00:00:00 | PERSON 4 |  | 2024-06-02 00:00:00 | PERSON 4
 |  | 2024-06-09 00:00:00 | PERSON 1 |  | 2024-06-09 00:00:00 | PERSON 1
 |  | NUMBERS OF SUNDAYS |  |  | NUMBERS OF SUNDAYS
 |  | PERSON 1 |  |  | PERSON 1
 |  | PERSON 2 |  |  | PERSON 2
 |  | PERSON 3 |  |  | PERSON 3
 |  | PERSON 4 |  |  | PERSON 4
 |  | PERSON 5 |  |  | PERSON 5
 |  | PREFERRED RESULT
Spreadsheet: 801822d1666388520-consolidation-of-data-from-multiple-sheets-with-different-headers-s666-pq-test-excel-sample
Sheet: Consolidated

DEVELOPMENT PROFORMA
Offset Reference | 10
Period | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 | Year 8 | Year 9 | Year 10 | Year 11 | Year 12 | Year 13 | Year 14 |  | 1
Date |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-01-01 00:00:00
Year | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
Spreadsheet: 685285d1593879942-fill-blanks-from-other-tabs-holiday-chart
Sheet: June

Name | Site |  |  | 2021-06-01 00:00:00 | 2021-06-02 00:00:00 | 2021-06-03 00:00:00 | 2021-06-04 00:00:00 | 2021-06-05 00:00:00 | 2021-06-06 00:00:00 | 2021-06-07 00:00:00 | 2021-06-08 00:00:00 | 2021-06-09 00:00:00 | 2021-06-10 00:00:00 | 2021-06-11 00:00:00 | 2021-06-12 00:00:00 | 2021-06-13 00:00:00 | 2021-06-14 00:00:00 | 2021-06-15 00:00:00 | 2021-06-16 00:00:00 | 2021-06-17 00:00:00 | 2021-06-18 00:00:00 | 2021-06-19 00:00:00 | 2021-06-20 00:00:00 | 2021-06-21 00:00:00 | 2021-06-22 00:00:00 | 2021-06-23 00:00:00 | 2021-06-24 00:00:00 | 2021-06-25 00:00:00 | 2021-06-26 00:00:00 | 2021-06-27 00:00:00 | 2021-06-28 00:00:00 | 2021-06-29 00:00:00 | 2021-06-30 00:00:00 | Total holidays | Total sick days | Total training days | Total days in lieu | Total weekend working
A Sample | [NAME]
B
C
D
E
F
G
H
I
Spreadsheet: 808390d1670437572-count-fields-based-on-month-ortho-ed-and-discharge-new
Sheet: Jan

Description | BMI > 40 | Total ASA 3 | Total ASA 4 | ALOS | Median | Totals
Total Knee - 1
Total Hip - 2
Total Shoulder - 3
Spine - 4
Bilat. Total Knee - 5
Bilat. Total Hip - 6
Spreadsheet: 833717d1687211240-extracting-variable-length-names-from-email-addresses-s666-pq-extracting-variable-length-names-from-email-addresses
Sheet: Sheet1

Column1 |  | Column1 | TBD | TBtD
[EMAIL] |  | [EMAIL] | Fred | Bloggs
[NAME].Duck@ nowhere.com |  | [NAME].Duck@ nowhere.com | [NAME] | Duck
[EMAIL] |  | [EMAIL] | Aaa | Bbb
[EMAIL] |  | [EMAIL] | [NAME] | Rfc
[EMAIL] |  | [EMAIL] | [NAME] | Test
Spreadsheet: 329697d1404386395-help-to-prepare-dynamic-table-in-excel-dummy
Sheet: Sheet1

 | Weeks | Product | Quantity
 | week-22 | a | 19
 | week-22 | b | 20
 | week-22 | c | 30
 | week-22 | d | 28
 | week-22 | e | 14
 | week-22 | f | 16
 | week-23 | c | 12
 | week-23 | d | 11
 | week-23 | e | 26
 | week-23 | f | 11
 | week-23 | g | 29
 | week-23 | i | 18
 | week-24 | d | 29
 | week-24 | e | 20
 | week-24 | f | 14
 | week-24 | c | 18
 | week-24 | g | 13
 | week-24 | m | 24
Spreadsheet: 488359d1478625252-multiple-if-statements-on-range-sample_if-statement-issue
Sheet: Lookup

Month | Fiscal
1 | 2
 | 1
Spreadsheet: 868842d1715564596-custom-calendar-help-dynamic-calendar-3-
Sheet: AUG

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A | B | C | D
 |  |  |  |  |  |  |  | D |  | D |  | D
 |  |  |  |  |  |  |  | C |  | C |  | C
D |  | A |  | A |  | A |  | A |  | C |  | C
C |  | B |  | B |  | B |  | B |  | D |  | D
C |  | C |  | B |  | B |  | B |  | B |  | D
D |  | D |  | A |  | A |  | A |  | A |  | C
D |  | D |  | D |  | A |  | A |  | A |  | A
C |  | C |  | C |  | B |  | B |  | B |  | B
C |  | C |  | C |  | C |  | B |  | B |  | B
D |  | D |  | D |  | D |  | A |  | A |  | A
Spreadsheet: 875332d1721917334-how-to-automatically-filter-multiple-arrays-of-data-by-their-relevant-headings-lookup-sheet-test
Sheet: Accidents & Causes Lookup

HazardID: | HazardName: | Description: | CauseID: | CauseName: | Description: | AccidentID: | AccidentName: | Description:
519500
 |  |  | 441053 | CN56 | CD56 | 358064 | AN1 | AD1
 |  |  | 441200 | CN5 | CD5 | 358066 | AN2 | AD2
 |  |  | 441186 | CN37 | CD37 | 358065 | AN3 | AD3
 |  |  | 441176 | CN32 | CD32 | 358060 | AN4 | AD4
 |  |  | 441048 | CN35 | CD35
 |  |  | 441049 | CN41 | CD41
 |  |  | 441039 | CN38 | CD38
 |  |  | 441040 | CN39 | CD39
 |  |  | 441166 | CN44 | CD44
 |  |  | 441158 | CN33 | CD33
 |  |  | 441160 | CN45 | CD45
 |  |  | 441162 | CN51 | CD51
 |  |  | 441155 | [NAME] | CD53
 |  |  | 441156 | [NAME] | CD54
 |  |  | 441179 | CN31 | CD31
 |  |  | 441032 | CN191 | CD191
 |  |  | 441214 | CN89 | CD89
 |  |  | 441170 | CN15 | CD15
 |  |  | 441090 | CN142 | CD142
 |  |  | 441268 | CN241 | CD241
Spreadsheet: 7c2493f0-226a-4c22-8403-6ebdf020bb0c
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
6520 | 39762 | [NAME] | Löffel | GER | 142 | [NAME] | [NAME] | 02:05:11 | 00:01:22 | 00:54:54 | 1 | 03:29:00
Spreadsheet: lynn_blair__24306__TropicalAllison
Sheet: Sheet1

 |  |  | Personnel Working Through Tropical Storm Allison
 |  |  |  |  | June 8-11, 2001
Friday Night Through Sunday |  |  |  |  |  | IT
[NAME] |  |  |  |  |  | [NAME] (TMS Support)
[NAME] |  |  |  |  |  | [NAME] (TMS Support)
[NAME] |  |  |  |  |  | [NAME] (Scada)
[NAME] |  |  |  |  |  | [NAME] (Desk Top Support)
[NAME]
[NAME] |  |  |  |  |  | Operations
[NAME] (Home at night) |  |  |  |  |  | [NAME]
 |  |  |  |  |  | Field Personnel at Manned stations
Gas Control |  |  |  |  |  | [NAME]
[NAME]
[NAME]
Helen Cummings
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Additional
Beverly (Work from Home)
[NAME] (Sunday)
[NAME] (Sunday)
[NAME] (Sunday)
Omaha
[NAME]
[NAME]
[NAME] January
[NAME]
[NAME]
[NAME]
[NAME] (On Vac in Iowa)
Helped from Home
[NAME]
[NAME] (work with [NAME] til 3:00 a.m. [NAME]. [NAME].)
[NAME] (covered TW Sun Night)
Darrell Schoolcraft
[NAME]
[NAME] (EDI)
[NAME]