tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 536852f3-a007-4d89-b226-f89d570b5047
Sheet: Sheet1

Figure 1: Trends in passenger transport demand and GDP, EEA32 (without LI) | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14
 | 1995 | 1996 | 1997 | 1998 | 1999 | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008
pkm | 90.74265772327831 | 92.44608067758867 | 94.05669836948972 | 96.04342720193624 | 98.18390382124149 | 100 | 101.4792253522704 | 102.8091373274276 | 103.4755998355542 | 105.4231416075549 | 105.7832508051447 | 108.5138488870421 | 110.6359353872736 | 110.3963561375291
GDP (2000 base year) | 86.45207911289859 | 88.25529051319982 | 90.84748689240766 | 93.55627773739228 | 96.18266433776023 | 100 | 101.7320949330259 | 103.1174610391383 | 104.5558178396625 | 107.4244356530568 | 109.7833154703106 | 113.3842015281493 | 116.6914112064454 | 117.5815273339497
Decoupling |  | 0.002043291353376886 | 0.01160837432387507 | 0.008442502785804495 | 0.005628248760710886 | 0.02038256176007047 | 0.002485642126233145 | 0.0005056389865986111 | 0.007363488641952909 | 0.008384916948383392 | 0.01814423712046498 | 0.00676490840966737 | 0.00933983927453419 | 0.009719284815000728
Spreadsheet: 688867d1595987989-sumproduct-with-comparing-condition-sumproduct-with-comparing-condition
Sheet: Sheet1

Parameter | Value
date0 | 4
date1 | date2 | amount |  |  | supporting column
1 | 5 | 10
2 | 3 | 15
3 | 4 | 20
 |  |  |  | Expected result:
Spreadsheet: 672463d1586877707-re-running-count-by-hour-of-the-day-thread-running-count-per-15-minutes
Sheet: Calendar

Date | Index | Year | Month
2020-01-01 00:00:00 | 0 | 2020 | 1
2020-01-02 00:00:00 | 1 | 2020 | 1
2020-01-03 00:00:00 | 2 | 2020 | 1
2020-01-04 00:00:00 | 3 | 2020 | 1
2020-01-05 00:00:00 | 4 | 2020 | 1
2020-01-06 00:00:00 | 5 | 2020 | 1
2020-01-07 00:00:00 | 6 | 2020 | 1
2020-01-08 00:00:00 | 7 | 2020 | 1
2020-01-09 00:00:00 | 8 | 2020 | 1
2020-01-10 00:00:00 | 9 | 2020 | 1
2020-01-11 00:00:00 | 10 | 2020 | 1
2020-01-12 00:00:00 | 11 | 2020 | 1
2020-01-13 00:00:00 | 12 | 2020 | 1
2020-01-14 00:00:00 | 13 | 2020 | 1
2020-01-15 00:00:00 | 14 | 2020 | 1
2020-01-16 00:00:00 | 15 | 2020 | 1
2020-01-17 00:00:00 | 16 | 2020 | 1
2020-01-18 00:00:00 | 17 | 2020 | 1
2020-01-19 00:00:00 | 18 | 2020 | 1
2020-01-20 00:00:00 | 19 | 2020 | 1
2020-01-21 00:00:00 | 20 | 2020 | 1
2020-01-22 00:00:00 | 21 | 2020 | 1
2020-01-23 00:00:00 | 22 | 2020 | 1
2020-01-24 00:00:00 | 23 | 2020 | 1
2020-01-25 00:00:00 | 24 | 2020 | 1
2020-01-26 00:00:00 | 25 | 2020 | 1
2020-01-27 00:00:00 | 26 | 2020 | 1
2020-01-28 00:00:00 | 27 | 2020 | 1
2020-01-29 00:00:00 | 28 | 2020 | 1
2020-01-30 00:00:00 | 29 | 2020 | 1
2020-01-31 00:00:00 | 30 | 2020 | 1
Spreadsheet: 471758d1469179006-transpose-data-tabela
Sheet: Tabela de conrespondencias

 | Legenda: | 0 - Unconfirmed
 |  | 1 - Confirmed
Tabela 1 |  |  |  |  |  |  |  | Tabela 2
 |  | A |  |  |  |  |  | A | B | Resultado
 | Conexões | 1 | 2 | 3 | 4 | 5 |  | 1 | 2 | Unconfirmed
B | 1 |  |  |  |  |  |  | 1 | 3 | Confirmed
 | 2 | 0 |  |  |  |  |  | 1 | 4 | Unconfirmed
 | 3 | 1 | 0
 | 4 | 0 |  | 1
 | 5
Spreadsheet: 38536d1236695789-i-keep-getting-na-s-not-sure-where-im-going-wrong-itassignworkinprogress
Sheet: Salespersons

The Salesperson Codes refer to the names given below
Code | Name | Surname | Firstname
1 | [NAME] | Jones | [NAME]
2 | [NAME] | [NAME] | [NAME]
3 | [NAME] | Jenkins | [NAME]
 |  |  |  |  |  | Bonus scheme (Quarter)
 |  |  |  |  |  | Sales above | Bonus
 |  |  |  |  |  | 30000 | 500
 |  |  |  |  |  | 40000 | 1000
 |  |  |  |  |  | 50000 | 2000
Spreadsheet: 37950d1236070627-data-validation-problem-cricket
Sheet: BOWLING STATS

BOWLING STATISTICS
 | Player |  | Overs | Maidens | Runs | Wickets | Average |  | Economy | [NAME] | Best Bowl. | 4's | 6's | % Bound. | % Wickets
 | BARBER, [NAME] |  | #N/A | #N/A | #N/A | #N/A | #N/A |  | #N/A | #N/A |  | #N/A | #N/A | #N/A | #N/A
 | BARBER, [NAME]. |  | #N/A | #N/A | #N/A | #N/A | #N/A |  | #N/A | #N/A |  | #N/A | #N/A | #N/A | #N/A
 | BISHOP, [NAME] |  | #N/A | #N/A | #N/A | #N/A | #N/A |  | #N/A | #N/A |  | #N/A | #N/A | #N/A | #N/A
 | CHAPMAN, [NAME] |  | #N/A | #N/A | #N/A | #N/A | #N/A |  | #N/A | #N/A |  | #N/A | #N/A | #N/A | #N/A
 | COSGROVE, [NAME] |  | #N/A | #N/A | #N/A | #N/A | #N/A |  | #N/A | #N/A |  | #N/A | #N/A | #N/A | #N/A
 | COSGROVE, [NAME] |  | #N/A | #N/A | #N/A | #N/A | #N/A |  | #N/A | #N/A |  | #N/A | #N/A | #N/A | #N/A
 | COUCHMAN, [NAME] |  | #N/A | #N/A | #N/A | #N/A | #N/A |  | #N/A | #N/A |  | #N/A | #N/A | #N/A | #N/A
 | GOODWIN, [NAME] |  | #N/A | #N/A | #N/A | #N/A | #N/A |  | #N/A | #N/A |  | #N/A | #N/A | #N/A | #N/A
 | HIRST, [NAME] |  | #N/A | #N/A | #N/A | #N/A | #N/A |  | #N/A | #N/A |  | #N/A | #N/A | #N/A | #N/A
 | [NAME], [NAME] |  | #N/A | #N/A | #N/A | #N/A | #N/A |  | #N/A | #N/A |  | #N/A | #N/A | #N/A | #N/A
 | MEREDITH, [NAME] |  | #N/A | #N/A | #N/A | #N/A | #N/A |  | #N/A | #N/A |  | #N/A | #N/A | #N/A | #N/A
 | RICHARDSON, [NAME] |  | #N/A | #N/A | #N/A | #N/A | #N/A |  | #N/A | #N/A |  | #N/A | #N/A | #N/A | #N/A
 | SIMPSON, [NAME] |  | #N/A | #N/A | #N/A | #N/A | #N/A |  | #N/A | #N/A |  | #N/A | #N/A | #N/A | #N/A
 | SKERRETT, [NAME] |  | #N/A | #N/A | #N/A | #N/A |  |  | #N/A |  |  | #N/A | #N/A | #N/A | #N/A
 |  |  | #N/A | #N/A | #N/A | #N/A |  |  | #N/A |  |  | #N/A | #N/A | #N/A | #N/A
 |  |  | #N/A | #N/A | #N/A | #N/A |  |  | #N/A |  |  | #N/A | #N/A | #N/A | #N/A
 |  |  | #N/A | #N/A | #N/A | #N/A |  |  | #N/A |  |  | #N/A | #N/A | #N/A | #N/A
 |  |  | #N/A | #N/A | #N/A | #N/A |  |  | #N/A |  |  | #N/A | #N/A | #N/A | #N/A
 |  |  | #N/A | #N/A | #N/A | #N/A |  |  | #N/A |  |  | #N/A | #N/A | #N/A | #N/A
 |  |  | #N/A | #N/A | #N/A | #N/A |  |  | #N/A |  |  | #N/A | #N/A | #N/A | #N/A
 |  |  | #N/A | #N/A | #N/A | #N/A |  |  | #N/A |  |  | #N/A | #N/A | #N/A | #N/A
 |  |  | #N/A | #N/A | #N/A | #N/A |  |  | #N/A |  |  | #N/A | #N/A | #N/A | #N/A
 |  |  | #N/A | #N/A | #N/A | #N/A |  |  | #N/A |  |  | #N/A | #N/A | #N/A | #N/A
 |  |  | #N/A | #N/A | #N/A | #N/A | #N/A |  | #N/A | #N/A |  | #N/A | #N/A | #N/A | #N/A
 |  |  | #N/A | #N/A | #N/A | #N/A | #N/A |  | #N/A | #N/A |  | #N/A | #N/A | #N/A | #N/A
Spreadsheet: larry_campbell__21327__AMP_COST_WORKSHEET
Sheet: Variable Prod Costs

Variable Production Cost and Variable Operation and [NAME]
Variable Production Cost -- Primary Fuel
 | Segments | Output Segment (MW) | Heat Rate for Segment (BTU/KWh) | Fuel Cost ($/MMBTU) | Cost $/MWH |  | Heat Rate Weighting | Fuel Cost Weighting
1 |  | 0 | 0
2 |  | 0 | 0
3 |  | 0 | 0
4 |  | 0 | 0
5 |  | 0 | 0
6 |  | 0 | 0
Weighted Averages
Variable Production Cost -- Secondary Fuel
 | Segments | Output Segment (MW) | Heat Rate for Segment (BTU/KWh) | Fuel Cost ($/MMBTU) | Cost $/MWH |  | Heat Rate Weighting | Fuel Cost Weighting
1 |  | 0 | 0
2 |  | 0 | 0
3 |  | 0 | 0
4 |  | 0 | 0
5 |  | 0 | 0
6 |  | 0 | 0
Weighted Averages
Variable Production Cost -- Other Fuel
 | Segments | Output Segment (MW) | Heat Rate for Segment (BTU/KWh) | Fuel Cost ($/MMBTU) | Cost $/MWH |  | Heat Rate Weighting | Fuel Cost Weighting
1 |  | 0 | 0
2 |  | 0 | 0
3 |  | 0 | 0
4 |  | 0 | 0
5 |  | 0 | 0
6 |  | 0 | 0
Weighted Averages
Variable Production Cost -- Combination Fuel
 | Segments | Output Segment (MW) | Heat Rate for Segment (BTU/KWh) | Fuel Cost ($/MMBTU) | Cost $/MWH |  | Heat Rate Weighting | Fuel Cost Weighting
1 |  | 0 | 0
2 |  | 0 | 0
3 |  | 0 | 0
4 |  | 0 | 0
5 |  | 0 | 0
6 |  | 0 | 0
Weighted Averages
Variable O&M |  |  |  |  | Cost $/MWH
 | Description | List by items or activities
1 |  |  |  |  | 0
2 |  |  |  |  | 0
3 |  |  |  |  | 0
4 |  |  |  |  | 0
 | Total
Variable cost other than Fuel and O&M |  |  |  |  | Cost $/MWH
 | Description | List by items or activities
1 |  |  |  |  | 0
2 |  |  |  |  | 0
3 |  |  |  |  | 0
4 |  |  |  |  | 0
 | Total
 |  |  |  |  | Cost $/MWH
Total O&M and Other Costs
Spreadsheet: 228344d1366086715-return-value-per-record-where-1-row-per-record-based-on-criteria-for-multiple-columns-question2
Sheet: Sheet1

Input |  |  |  |  | To select a score
Student | Date | Error | Score |  | if for any student:
1 | 2013-04-28 00:00:00 | 5 | 60 |  | 1. there exists only one row (score), then use that one.
1 | 2013-04-29 00:00:00 | 6 | 95 |  | 2. Otherwise, if there is >1 row for a student, then
1 | 2013-04-29 00:00:00 | 5 | 95 |  | 3. take the score from the row with the "largest" date value (most recent date)
2 | 2013-04-28 00:00:00 | 5 | 52 |  | 4. but if the "largest" date value has >1 occurrence for that student, then
2 | 2013-04-29 00:00:00 | 6 | 97 |  | 5. take the score from the row with the smallest value of error
3 | 2013-04-29 00:00:00 | 6 | 50 |  | 6. but if the smallest value of error has >1 occurrence for that student then
4 | 2013-04-28 00:00:00 | 6 | 75 |  | 7. take the score from the row with the highest score
4 | 2013-04-29 00:00:00 | 5 | 75
4 | 2013-04-29 00:00:00 | 5 | 75
Output
Student | Score | Note
1 | 95
2 | 97
3 | 50
4 | 75
Spreadsheet: 267627d1380123324-need-help-with-calendar-formula-for-previous-year-and-next-year-planning-calendar
Sheet: Calendar

2014
 |  | January |  |  |  |  |  |  |  | February |  |  |  |  |  |  |  | March |  |  |  |  |  |  |  | April
 |  | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S
 |  | May |  |  |  |  |  |  |  | June |  |  |  |  |  |  |  | July |  |  |  |  |  |  |  | August
 |  | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S
 |  | September |  |  |  |  |  |  |  | October |  |  |  |  |  |  |  | November |  |  |  |  |  |  |  | December
 |  | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S
 |  | The section above is what I found and am able to use.  Simply change the year in the colored area and the rest of the calendar updates.
 |  | The section below is where I tried to create two more months using the same formula but changing from A4 to A34 or [NAME] respectively for the months
2013 |  | but can not get the two months below to work for me.
2015
 |  | S | M | T | W | T | F | S |  | S | M | T | W | T | F | S
Spreadsheet: 582403d1531859407-unwanted-printing-of-headings-account-balances
Sheet: Process

1 | After check run for the 25th of the month, look at spreadsheet that summarizes amount due from
 | vendors with anticipation discounts.   Calculate which vendors currently have anticipation
 | discounts available.
2 | Give the Michelin and Nokian payment bundles to Scott for his approval 2 days before the
 | first of the month.   (Currently [NAME] is paying everything early, but that could
 | change in the future.)
3 | Prepare the Michelin and Nokian payments to be made on the first of the month.
4 | Toyo you will need to have the month end statement before you can process to check the
 | anticipation discounts.   Could probably be paid on the 10th or 15th.
 | Yokohama you will need the month end statement before you can process so you can check
 | to make sure you have all the credit memos.   Credit memos have to be deducted before
 | the anticipation discounts can be calculated
 | Bridgestone will have to be paid on the 15th of the month to allow Gretchen enough
 | time to have all the credit memos entered.
5 | For the check run on the 20th, go through the process again to see if any more invoices
 | have come in and are available for anticipation discounts.
Spreadsheet: 234519d1368118053-create-master-list-from-multiple-sheets-in-the-same-format-example
Sheet: Account 3

Date | [NAME] | Value | Category
2013-01-03 00:00:00 | NPOWER | -10 | Utilities
2013-01-03 00:00:00 | NPOWER | -25 | Utilities
2013-01-04 00:00:00 | NSPCC | -16 | Charity
2013-01-04 00:00:00 | PAYPAL PAYMENT | -50 | Misc
Spreadsheet: 99017d1297801296-lookup-in-several-tables-copy-of-test-for-hlookup
Sheet: Sheet1

 | Keyword 1 |  |  |  | [NAME] |  |  |  | [NAME] |  |  |  | [NAME] |  |  |  | Keyword 5 |  |  |  | Keyword 6 |  |  |  | [NAME]
 |  | Revenue | Number of Orders |  |  | Revenue | Number of Orders |  |  | Revenue | Number of Orders |  |  | Revenue | Number of Orders |  |  | Revenue | Number of Orders |  |  | Revenue | Number of Orders |  |  | Revenue | Number of Orders
 | Jul | 363 | 16 |  | Jul | 409 | 9 |  | Jul | 216 | 13 |  | Jul | 399 | 18 |  | Jul | 272 | 16 |  | Jul | 446 | 8 |  | Jul | 475 | 15
 | Aug | 265 | 10 |  | Aug | 214 | 12 |  | Aug | 462 | 17 |  | Aug | 253 | 5 |  | Aug | 406 | 16 |  | Aug | 381 | 11 |  | Aug | 311 | 5
 | Sep | 443 | 3 |  | Sep | 221 | 19 |  | Sep | 231 | 17 |  | Sep | 305 | 4 |  | Sep | 345 | 18 |  | Sep | 280 | 19 |  | Sep | 315 | 6
 | Oct | 355 | 5 |  | Oct | 316 | 18 |  | Oct | 215 | 19 |  | Oct | 487 | 4 |  | Oct | 226 | 16 |  | Oct | 426 | 2 |  | Oct | 242 | 9
 | Nov | 357 | 20 |  | Nov | 267 | 15 |  | Nov | 397 | 18 |  | Nov | 392 | 10 |  | Nov | 398 | 8 |  | Nov | 394 | 3 |  | Nov | 354 | 18
 | Dec | 457 | 7 |  | Dec | 475 | 5 |  | Dec | 466 | 10 |  | Dec | 317 | 10 |  | Dec | 294 | 14 |  | Dec | 489 | 15 |  | Dec | 230 | 12
 | Jan | 226 | 18 |  | Jan | 250 | 10 |  | Jan | 258 | 2 |  | Jan | 488 | 12 |  | Jan | 473 | 15 |  | Jan | 275 | 4 |  | Jan | 239 | 14
 | Dec | Revenue | Number of Orders
 | Keyword1
 | Keyword2
 | Keyword3
 | Keyword4
 | Keyword5
 | Keyword6
 | Keyword7
Spreadsheet: ae9c7988-ed0d-4218-bb07-9e07f163d9ac
Sheet: Approp

 |  | APPROPRIATION TRANSACTION
 |  | CITY  OF  KANSAS  CITY,  MISSOURI
 |  |  | DEPARTMENT:
BUSINESS UNIT: |  |  |  | KCMBU |  | DATE: |  | 2012-05-04 00:00:00 |  | JOURNAL ID:
LEDGER GROUP: |  |  |  |  | APPROP
FY |  | FUND |  | DEPT ID |  | ACCOUNT |  | PROJECT |  | AMOUNT |  | INC/DEC
13 |  | 3090 |  | 808505 |  | B |  | 82000173 |  | -293000 |  | DEC
13 |  | 3090 |  | 808508 |  | B |  | 89003451 |  | 293000 |  | INC
 |  |  |  |  |  |  |  |  |  |  |  | TOTAL
BUSINESS UNIT: |  |  |  | KCMBU |  | DATE: |  | 2012-05-04 00:00:00 |  | JOURNAL ID: |  | C
 |  |  |  |  |  |  |  |  |  |  |  | (same as above, except
LEDGER GROUP: |  |  |  |  | ADMIN |  |  | BUDGET PERIOD: |  |  |  | prefixed by a C)
FY |  | FUND |  | DEPT ID |  | ACCOUNT |  | PROJECT |  | AMOUNT |  | INC/DEC
13 |  | 3090 |  | 808505 |  | 611060 |  | 82000173 |  | -293000 |  | DEC
13 |  | 3090 |  | 808508 |  | 611060 |  | 89003451 |  | 293000 |  | INC
 |  |  |  |  |  |  |  |  |  |  |  | TOTAL
[NAME]: |  |  |  |  |  |  |  |  |  |  |  | NET
APPROVED BY: |  |  |  |  |  | DATE |  | APPROVED BY:  DEPARTMENT HEAD |  |  |  |  |  | DATE
Spreadsheet: 138619d1327768574-excel-2007-performing-calculations-in-cells-2012-income
Sheet: first aug

2011-08-08 00:00:00
0 |  | yes | Amount | Taxable Merch | Shipping Taxable | Sales Tax Payable | Non- taxable Merch | Shipping Non-Taxable | Income Tax Income | MiscellaneousNon- Taxable | Owner Loan
Received From | Check No | Invoices Paid | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 125394d1319013438-multiple-if-statements-in-a-conditional-formatting-issue1
Sheet: Sheet2

 | INC | Severity | OpCat1 | OpCat2 | OpCat3 | ProdCat1 | ProdCat2 | ProdCat3 | Model | Reported Time | Response Time | Lasts updated Time | Resolution Time
1 | 21154 | 1 | Ser | Ser | Ser | ddd | ddd | ddd | KIO | 2011-01-12 15:00:00 | 2011-01-12 15:11:00 | 2011-01-12 15:00:00 | 2011-01-12 20:08:00
2 | 23341 | 1 | Fro | Fro | Fro | [NAME] | [NAME] | [NAME] | KIO | 2011-01-13 15:00:00 | 2011-01-13 15:11:00 | 2011-01-13 15:00:00 | 2011-01-13 20:11:00
3 | 24561 | 3 | Ser | Ser | Ser | saa | saa | saa | KIO | 2011-01-14 15:00:00 | 2011-01-14 15:14:00 | 2011-01-14 15:00:00 | 2011-01-14 17:14:00
4 | 12434 | 2 | Frp | Frp | Frp | aaa | aaa | aaa | KIO | 2011-01-15 15:00:00 | 2011-01-17 14:00:00 | 2011-01-15 15:00:00 | 2011-01-17 12:00:00
5 | 22165 | 3 | Sad | Sad | Sad | sss | sss | sss | KIO | 2011-01-16 15:00:00 | 2011-01-16 15:00:00 | 2011-01-16 15:00:00 | 2011-01-20 11:00:00
6 | 24567 | 4 | Fro | Fro | Fro | [NAME] | [NAME] | [NAME] | KIO | 2011-01-17 15:00:00 | 2011-01-17 15:01:00 | 2011-01-17 15:00:00 | 2011-01-17 15:01:00
7 | 56331 | 1 | Ser | Ser | Ser | ddd | ddd | ddd | KIO | 2011-01-18 15:00:00 | 2011-01-18 15:12:00 | 2011-01-18 15:00:00 | 2011-01-18 15:12:00
8 | 46884 | 4 | Fto | Fto | Fto | aaa | aaa | aaa | KIO | 2011-01-19 15:00:00 | 2011-01-19 15:00:00 | 2011-01-19 15:00:00 | 2011-01-19 15:22:00
9 | 37899 | 2 | Daf | Daf | Daf | ddd | ddd | ddd | KIO | 2011-01-20 15:00:00 | 2011-01-20 15:00:00 | 2011-01-20 15:00:00 | 2011-01-20 15:21:59.995000
10 | 20096 | 4 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | KIO | 2011-01-21 15:00:00 | 2011-01-21 15:00:00 | 2011-01-21 15:00:00 | 2011-01-21 15:21:59.995000
11 | 29758 | 1 | Eat | Eat | Eat | saa | saa | saa | KIO | 2011-01-22 15:00:00 | 2011-01-22 15:00:00 | 2011-01-22 15:00:00 | 2011-01-22 15:21:59.995000
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
Spreadsheet: 868749d1715427643-formula-to-find-value-in-table-file
Sheet: Sheet1

 | Date | Name | Price | Another price
 | 2020-01-01 00:00:00 | Dog | 2.99 | 4.99
 | 2020-01-01 00:00:00 | Cat | 3.99 | 5.99
 | 2020-01-01 00:00:00 | Crocodile | 4.49 | 7.15
 | 2020-01-04 00:00:00 | Dinosaur | 7.49 | 8.12
 | 2020-01-05 00:00:00 | Dragon | 0.99 | 1.65
 | 2020-01-06 00:00:00 | Fish | 0.99 | 1.45
 | 2020-01-07 00:00:00 | Table | 5.49 | 6.32
 | 2020-01-08 00:00:00 | Leg | 2.99 | 5.23
 |  |  |  |  |  |  | Date | some value from a table
 |  |  |  |  |  |  | Name | some value from a table
 |  |  |  |  |  |  | Price | some value from a table
 |  |  |  |  |  |  | Another price: | ?
Spreadsheet: 139243d1328150012-countif-formula-usage-ptengineersbydate_updated
Sheet: Sheet1

Engineer | Company | Date
[NAME] | XYZ Pte Ltd | 2011-01-04 00:00:00
[NAME] | XYZ Pte Ltd | 2011-01-04 00:00:00
[NAME] | ABC Pte Ltd | 2011-01-04 00:00:00
[NAME] | QWE Pte Ltd | 2011-01-05 00:00:00 |  | Count of Company | Date
[NAME] | QWE Pte Ltd | 2011-01-05 00:00:00 |  | Engineer | 2011-01-04 00:00:00 | 2011-01-05 00:00:00 | 2011-01-06 00:00:00 | Grand Total
[NAME] | ASD Pte Ltd | 2011-01-06 00:00:00 |  | [NAME] | 3 | 2 | 2 | 7
[NAME] | ASD Pte Ltd | 2011-01-06 00:00:00 |  | [NAME] |  |  | 2 | 2
[NAME] | ASD Pte Ltd | 2011-01-06 00:00:00 |  | Grand Total | 3 | 2 | 4 | 9
[NAME] | ASD Pte Ltd | 2011-01-06 00:00:00
Spreadsheet: daren_farmer__6635__Texas Nat_Gas Ops 0200 O&M Report
Sheet: 2664

2664 |  |  |  |  |  |  |  |  |  |  |  |  |  | ASSOCHC | TOTAL_HEADCOUNT
 |  |  |  |  |  |  |  |  |  |  |  |  |  | ALYSTHC | 2000-01-01 00:00:00 |  | 2000-02-01 00:00:00 |  | 2000-03-01 00:00:00 |  | 2000-04-01 00:00:00 |  | 2000-05-01 00:00:00 |  | 2000-06-01 00:00:00 |  | 2000-07-01 00:00:00 |  | 2000-08-01 00:00:00 |  | 2000-09-01 00:00:00 |  | 2000-10-01 00:00:00 |  | 2000-11-01 00:00:00 |  | 2000-12-01 00:00:00
 |  | ACTUAL |  | PLAN2000 |  |  |  | ACTUAL |  | PLAN2000
 |  | M.PER |  | M.PER |  |  |  | M.YTD |  | M.YTD |  |  |  |  | M.PER |  | M.PER |  | M.PER |  | M.PER |  | M.PER |  | M.PER |  | M.PER |  | M.PER |  | M.PER |  | M.PER |  | M.PER |  | M.PER
 |  |  |  |  |  | Monthly |  |  |  |  |  | YTD |  |  | January |  | February |  | March |  | April |  | May |  | June |  | July |  | August |  | September |  | October |  | November |  | December
 |  | Actual |  | Plan |  | [NAME] |  | Actual YTD |  | Plan YTD |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
 | Direct Expense:
TOT_COMP | Compensation |  |  |  |  |  |  |  |  |  |  |  |  | Headcount
[NAME] | Benefits and Payroll Taxes |  |  |  |  |  |  |  |  |  |  |  |  | Analysts and Associates
TOT_EMP_EXP | Employee Expenses
TOT_RECRUITING | Recruiting & Relocations
TOT_OSIDE_SERV | Outside Services |  |  |  |  |  |  |  |  |  |  |  |  | Direct Expense:
[NAME] | Supplies and Expense |  |  |  |  |  |  |  |  |  |  |  |  | Compensation
TOT_MKT | Marketing |  |  |  |  |  |  |  |  |  |  |  |  | Benefits and Payroll Taxes
TOT_CHAR_CONT | Charitable Contributions |  |  |  |  |  |  |  |  |  |  |  |  | Employee Expenses
TOT_RENT | Rent (3rd Party) |  |  |  |  |  |  |  |  |  |  |  |  | Recruiting & Relocations
TOT_TECH | Technology |  |  |  |  |  |  |  |  |  |  |  |  | Outside Services
TOT_TRANS | Transportation |  |  |  |  |  |  |  |  |  |  |  |  | Supplies and Expense
CORP_IT | Corporate IT |  |  |  |  |  |  |  |  |  |  |  |  | Marketing
CORP_RENT | Corporate Rent |  |  |  |  |  |  |  |  |  |  |  |  | Charitable Contributions
TOT_OTH_EXP | Other Expenses |  |  |  |  |  |  |  |  |  |  |  |  | Rent (3rd Party)
[NAME] | Taxes Other Than Income |  |  |  |  |  |  |  |  |  |  |  |  | Technology
[PHONE] | Capital Allocation |  |  |  |  |  |  |  |  |  |  |  |  | Transportation
TOT_DEP_AMOR | Depreciation & Amortization |  |  |  |  |  |  |  |  |  |  |  |  | Corporate IT
 | Total Direct Expenses |  |  |  |  |  |  |  |  |  |  |  |  | Corporate Rent
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Other Expenses
9230999860 | Allocated Intercompany Billings |  |  |  |  |  |  |  |  |  |  |  |  | Taxes Other Than Income
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Capital Allocation
 | Net Expenses |  |  |  |  |  |  |  |  |  |  |  |  | Depreciation & Amortization
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Direct Expenses
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Allocated Intercompany Billings
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Net Expenses
Spreadsheet: 833078d1686764838-showing-a-cell-as-blank-with-a-prefilled-formula-until-data-is-entered-on-another-sheet-master-project-template-help
Sheet: Project Timeline

 |  |  |  |  | Due Date |  | Blockout |  |  |  |  |  | Preliminary |  |  |  |  | Final CD |  |  |  |  | Engineering |  |  |  |  | Permit |  |  |  | Construction Sets Issued
Project | Project Manager | Contract Date | Due Date Days | Date | Due Date Deadline | Blockout Days | Proposed Blockout Deadline | Actual Blockout Deadline | [NAME] | Blockout CA | Prelim Days | Proposed Preliminary Deadline | Preliminary Deadline | Preliminary Sent | Preliminary CA | Final Days | Proposed Final CD Deadline | Final CD Deadline | Final CD Sent | Final CA | Engineering Days | Proposed Engineering Deadline | Engineering Deadline | Engineering Sent | Engineering CA | Permit Days | Proposed Permit Deadline | Actual Permit Deadline | Permit Sent | Permit CA | Proposed Construction Sets Deadline | Actual Construction Sets Deadline | Construction Sets Sent | Construction Sets Marketing | Notes
 |  |  | 90 |  |  | 21 |  |  |  |  | 30 |  |  | 2023-03-22 00:00:00 |  | 30 |  |  |  |  | 7 |  |  |  |  | 4
 |  |  | 90 |  |  | 21 |  |  |  |  | 30 |  |  |  |  | 30 |  |  |  |  | 7 |  |  |  |  | 4
 |  |  | 90 |  |  | 21 |  |  |  |  | 30 |  |  |  |  | 30 |  |  |  |  | 7 |  |  |  |  | 4
 |  |  | 90 |  |  | 21 |  |  |  |  | 30 |  |  |  |  | 30 |  |  |  |  | 7 |  |  |  |  | 4
 |  |  | 90 |  |  | 21 |  |  |  |  | 30 |  |  |  |  | 30 |  |  |  |  | 7 |  |  |  |  | 4
 |  |  | 90 |  |  | 21 |  |  |  |  | 30 |  |  |  |  | 30 |  |  |  |  | 7 |  |  |  |  | 4
 |  |  | 90 |  |  | 21 |  |  |  |  | 30 |  |  |  |  | 30 |  |  |  |  | 7 |  |  |  |  | 4
 |  |  | 90 |  |  | 21 |  |  |  |  | 30 |  |  |  |  | 30 |  |  |  |  | 7 |  |  |  |  | 4
 |  |  | 90 |  |  | 21 |  |  |  |  | 30 |  |  |  |  | 30 |  |  |  |  | 7 |  |  |  |  | 4
Spreadsheet: 873692d1720202409-updating-multiple-worksheets-into-one-worsheet-sample-data7_5
Sheet: Jan

First | Last | Case
[NAME] | Smith | Banking
Billy | Jones | Online
[NAME] | Jones | Branch
Greg | Leone | Lending
Sean | [NAME] | Virtual
[NAME] | [NAME] | Call Center
[NAME] | Merrick | Business Development
[NAME] | Malone | VRU