tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 684254d1593229938-calendar-showing-multiple-assignments-on-one-date-follow-up
Sheet: Month View

 | FOLLOW UP | WEEK VIEW
 | Select Month: | Enter Year:
 | July
 | MONTH VIEW
 | SUNDAY | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY
Spreadsheet: 148957d1333630687-conditional-formating-question
Sheet: sheet1

A | B | C | Minimum | Median | Maximum
5143.71 | 2649.9 | 3690.5 | 2649.9 | 3690.5 | 5143.71
5203 | 2649.9 | 3690.5 | 2649.9 | 3690.5 | 5203
3872 | 2649.9 | 2843.5 | 2649.9 | 2843.5 | 3872
3872 | 2649.9 | 2843.5 | 2649.9 | 2843.5 | 3872
4235 | 1887.6 | 2843.5 | 1887.6 | 2843.5 | 4235
3388 | 1887.6 | 2843.5 | 1887.6 | 2843.5 | 3388
3509 | 2649.9 | 2843.5 | 2649.9 | 2843.5 | 3509
653.4 | 943.8 | 1512.5 | 653.4 | 943.8 | 1512.5
363 | 840.95 | 502.15 | 363 | 502.15 | 840.95
6413 | 1324.95 | 4833.95 | 1324.95 | 4833.95 | 6413
6413 | 1324.95 | 4833.95 | 1324.95 | 4833.95 | 6413
2783 | 992.2 | 1512.5 | 992.2 | 1512.5 | 2783
5082 | 2649.9 | 2843.5 | 2649.9 | 2843.5 | 5082
3872 | 2976.6 | 4833.95 | 2976.6 | 3872 | 4833.95
4985.2 | 2649.9 | 4833.95 | 2649.9 | 4833.95 | 4985.2
2420 | 2649.9 | 1512.5 | 1512.5 | 2420 | 2649.9
2299 | 992.2 | 1512.5 | 992.2 | 1512.5 | 2299
2541 | 1681.9 | 1512.5 | 1512.5 | 1681.9 | 2541
2662 | 2649.9 | 1512.5 | 1512.5 | 2649.9 | 2662
1452 | 992.2 | 429.55 | 429.55 | 992.2 | 1452
4235 | 1984.4 | 1512.5 | 1512.5 | 1984.4 | 4235
3025 | 1984.4 | 1512.5 | 1512.5 | 1984.4 | 3025
4235 | 1984.4 | 1512.5 | 1512.5 | 1984.4 | 4235
786.5 | 1324.95 | 1512.5 | 786.5 | 1324.95 | 1512.5
2783 | 992.2 | 3690.5 | 992.2 | 2783 | 3690.5
1331 | 2649.9 | 2722.5 | 1331 | 2649.9 | 2722.5
3751 | 1984.4 | 4833.95 | 1984.4 | 3751 | 4833.95
3267 | 2649.9 | 3690.5 | 2649.9 | 3267 | 3690.5
2783 | 2649.9 | 2843.5 | 2649.9 | 2783 | 2843.5
363 | 992.2 | 429.55 | 363 | 429.55 | 992.2
4840 | 5299.8 | 4833.95 | 4833.95 | 4840 | 5299.8
423.5 | 1984.4 | 429.55 | 423.5 | 429.55 | 1984.4
1996.5 | 1984.4 | 3611.85 | 1984.4 | 1996.5 | 3611.85
1815 | 1984.4 | 2843.5 | 1815 | 1984.4 | 2843.5
1815 | 1960.2 | 2843.5 | 1815 | 1960.2 | 2843.5
387.2 | 435.6 | 514.25 | 387.2 | 435.6 | 514.25
2662 | 1984.4 | 2843.5 | 1984.4 | 2662 | 2843.5
786.5 | 992.2 | 1512.5 | 786.5 | 992.2 | 1512.5
786.5 | 1984.4 | 2843.5 | 786.5 | 1984.4 | 2843.5
629.2 | 992.2 | 429.55 | 429.55 | 629.2 | 992.2
113862.21 | 78492.69999999998 | 100750.65 | 66459.25000000001
Spreadsheet: 690365d1597069114-need-formula-to-create-list-from-high-to-low-numerical-order-new-project
Sheet: Sheet1

S.No | Salesman | Total Sales | Daily Sales |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Perfomance Chat |  | Percentage
 |  |  | 1 | 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 |  |  | Sales Man | Total sales
1 | Asif |  | 1 | 2 |  |  | 2 |  | Off |  |  | 2 |  |  |  | Off |  |  |  | 1 |  |  | Off |  |  | 4 | 2 |  | 2 | Off |  |  |  |  | No 1 Performer | Shabbir | 27 | Need you Suggestions
2 | Ghani |  | 2 |  | 1 |  |  |  |  |  |  | 3 |  |  |  |  |  |  |  | 4 |  |  |  |  |  | 4 |  |  |  |  |  |  |  |  | No 2 Performer | [NAME] | 23
3 | Chritopher |  | 3 |  |  | 2 |  |  |  |  |  | 2 |  |  | 2 |  |  |  | 2 |  |  |  |  |  |  | 3 |  |  | 4 |  |  |  | 4 |  |  | Chritopher | 22
4 | Shabbir |  | 1 |  | 4 |  |  |  |  |  |  | 4 |  | 4 |  |  |  |  | 4 |  | 4 |  |  |  |  | 4 |  |  |  |  |  | 2 |  |  |  | Lukman | 21
5 | [NAME] |  | 2 |  | 1 |  |  |  |  |  | 4 |  | 3 |  |  |  |  |  | 2 |  |  | 4 |  |  |  | 4 |  |  | 2 |  |  |  | 1 |  |  | Bania | 19
6 | Bania |  | 2 | 4 |  |  | 1 |  |  |  |  | 2 |  |  |  |  |  |  |  | 3 |  |  |  |  |  | 4 |  |  |  |  |  |  | 3 |  |  | Asif | 16
7 | Lukman |  | 4 |  |  | 4 |  |  |  |  |  | 2 |  |  |  |  |  |  | 4 |  |  |  |  |  |  | 2 |  | 4 |  |  |  |  | 1 |  |  | Ghani | 14
Spreadsheet: 855109d1704804537-help-with-let-function-digital-operator-production-log-v3-3-
Sheet: Garrett Matthews

Client | Job # | Lettercode/ Part | Remake # | Printer | Speed | Today's Date | Scheduled  Time | Start Time | Stop Time | Actual Time | [NAME] | Sheets Printed | Material | [NAME] | Height | # Up | Column1 | Column2 | Square Feet | Sq. Feet / Hr | MS UPDATE
HH GLOBAL TMOBILE | 243775 | 1,2 |  | 3R-2 | 6 Pass | 2024-01-09 00:00:00 | 0.5 | 07:00:00 | 15:30:00 |  |  | 650 | [NAME] | 48 | 41 | 2
[NAME] | 243684 | 2 |  | 3R-1 | 5 Pass | 2024-01-10 00:00:00 | 1.25 | 08:00:00 | 08:20:00 |  |  | 3 | ART-4393 | 27 | 23 | 1 |  |  |  |  | Yes
GGPM | 20307 | 403.1 | 143961 | Big HP | 5 Pass | 2024-01-11 00:00:00 | 0.75 | 08:30:00 | 08:40:00 |  |  | 30 | ART-4388 | 50 | 6 | 9
GGPM | 20314 | 384.3 |  | 3R-1 | 5 Pass | 2024-01-12 00:00:00 | 0.55 | 09:30:00 | 15:30:00 |  |  | 1388 | ART-4388 | 50 | 8 | 3
AD TRENDS ADVERTISING INC. | 243741 | 1 |  | 3R-1 | 5 Pass | 2024-01-13 00:00:00 | 0.35 | 11:00:00 | 11:20:00 |  |  | 2 | ART-2150 | 22 | 13 | 2
Total
 |  |  |  |  |  |  |  |  | Press Summary
 |  |  |  |  |  |  |  |  | Press | Hrs | Sq. Ft | % SchHrs | % of SqFt | Run Time | SqFt/Hr
 |  |  |  |  |  |  |  |  | GS3250
 |  |  |  |  |  |  |  |  | HS125
 |  |  |  |  |  |  |  |  | Tauro-1
 |  |  |  |  |  |  |  |  | Tauro-2
 |  |  |  |  |  |  |  |  | 3R-1
 |  |  |  |  |  |  |  |  | 3R-2
Spreadsheet: 133522d1324454596-basic-vlookup-with-if-i-cant-work-this-out-practice
Sheet: Without

 |  | ID | Type | Title | Initial | Surname | Status | Issue | st | Amount 2 | item | Amount | Type | CARD | month | year | Bank | [NAME] | [NAME] | Swift | COST | Account | Date | Completed | enter | done | who | when
3 |  | 123456 | Individual | Ms | S | [NAME] | l | bl | ee | 172.5 | 0 | #N/A
4 |  | 123457 | Individual | Ms | A | [NAME] | p | sl | ee | 1126 | 0
 |  |  |  |  |  |  |  | sl
5 |  | 123456 | Individual | Miss | D | [NAME] | z | sl | ee | 774.42 | 0
6 |  | 123459 | Individual | Mr | T | [NAME] | r | sl | ee | 1347.77 | 0
7 |  | 123455 | Individual | Mr | D | manly | r | sl | ff | 1125.94 | 0
Spreadsheet: 835234d1688433320-excel-formula-for-search-from-sentence-search-formula
Sheet: Sheet1

Cheque/Card No | Comment | Amount | Customer No |  | Document Number
DD30/6/2023A | W182697 |  |  |  | W548279
DD30/6/2023 | W545898 |  |  |  | W182697
DD30/6/2023 | W181884 |  |  |  | W545594
DD30/6/2023 | W549636 |  |  |  | W181212
DD30/6/2023 | W546953 |  |  |  | W179858
DD30/6/2023 | W551762 |  |  |  | W546765
DD30/6/2023 | W548279 | Pyrmont |  |  |  | W182697
DD30/6/2023 | Vendor - 61728 |WHOLESALE |  |  |  | W545898
DD30/6/2023 | SCT DEPOSIT | W181455 PAY |  |  |  | W181884
DD30/6/2023 | WELD SUPPLY |  |  |  | W549636
DD30/6/2023 | True Protein | True Protein Pty |  |  |  | W546953
DD30/6/2023a | SCT DEPOSIT | W182622 PAYTRON |  |  |  | W551671
DD30/6/2023 | 89008 | Posh Fo y L |  |  |  | W539436
DD30/6/2023 | W181492 | SYM P LTD |  |  |  | W182292
DD30/6/2023 | POPP  |  UNLIMITED P |  |  |  | W182293
DD30/6/2023 | W546214 | BRADEY A |  |  |  | W551762
DD30/6/2023a | True Protein | True Py |  |  |  | W182291
DD30/6/2023b | True Protein | True Py |  |  |  | W548123
DD30/6/2023c | True Protein | True Py |  |  |  | W548118
DD30/6/2023d | True Protein | True Py |  |  |  | W182622
DD30/6/2023e | True Protein | True Py |  |  |  | W182295
DD30/6/2023 | OSKO DEPOSIT | Invoice W545860 |  |  |  | W182294
DD30/6/2023 | W182378 | JBS Australia Pt |  |  |  | W182296
DD30/6/2023 | W548214 | [NAME] |  |  |  | W182297
DD30/6/2023 | [NAME] | Nuline Resources |  |  |  | W550758
DD30/6/2023 | OSKO DEPOSIT | [NAME]28 04 2023 |  |  |  | W547723
DD30/6/2023 | W547459 | Mudgee Ridge |  |  |  | W546700
DD30/6/2023 | MARGAN | [NAME] |  |  |  | W175055
DD30/6/2023 | W546093 | Cognescenti Pty |  |  |  | W542490
DD30/6/2023 | OSKO DEPOSIT | w551374  [NAME] |  |  |  | W549327
Spreadsheet: 877479d1724313181-redundancy-calc-with-a-difference-a-formula-question-thenewunion-redundancy-calc-with-a-difference-v3
Sheet: Sheet1

 | Redundancy Calc with a difference
 |  |  |  |  | Age @ | Years | Age @ | 0.5 | 1 | 1.5 | Completed | Total
 | Employee Name | DOB | Hire Date | Exit Date | Hire | Worked | Exit | X | Y | Z | Years | Weeks | Status | Expected Output
 | Empl 001 | 1990-09-30 00:00:00 | 2009-03-09 00:00:00 | 2024-08-13 00:00:00 |  |  |  |  |  |  |  |  | Correct | 13 |  | Perfect!
 | Empl 002 | 1974-03-22 00:00:00 | 2008-01-04 00:00:00 | 2024-10-31 00:00:00 |  |  |  |  |  |  |  |  | Correct | 20.5 |  | Perfect!
 | Empl 003 | 1980-04-18 00:00:00 | 2020-07-27 00:00:00 | 2024-12-31 00:00:00 |  |  |  |  |  |  |  |  | Correct | 5.5 |  | Perfect!
 | Empl 004 | 1969-04-03 00:00:00 | 2008-06-25 00:00:00 | 2025-03-06 00:00:00 |  |  |  |  |  |  |  |  | Correct | 23 |  | Perfect!
 | Empl 008 | 1990-07-21 00:00:00 | 2012-12-03 00:00:00 | 2024-11-30 00:00:00 |  |  |  |  |  |  |  |  | ? | 11 |  | -1 for 1.5 weeks is incorrect, expect 11 weeks in 1 and 0 in 0.5 and 1.5
 |  | 0.5 week’s pay for each full year worked when you’re under 22
 |  | 1 week’s pay for each full year worked when you’re between 22 and 41
 |  | 1.5 week’s pay for each full year worked when you’re 41 or older
Spreadsheet: 229856d1366618554-gantt-chart-sumproduct-excel-forum-example
Sheet: Gantt

 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | Today's Date:
 |  |  |  |  |  |  |  |  | (vertical red line)
 |  | Project Lead:
 |  | Start Date: | 2013-04-15 00:00:00
[42] |  |  |  |  |  |  |  |  |  |  | First Day of Week (Mon=2): | 2
WBS | Department | Task | Accountable | Responsible | Start | End | Duration (Days) | % Complete | Working Days | Days Complete | Days Remaining
 |  |  |  |  | 2013-05-01 00:00:00 |  | 10 | 0.5
 |  |  |  |  | 2013-05-05 00:00:00 |  | 5 | 0
 |  |  |  |  | 2013-05-30 00:00:00 |  | 46 | 0.7
 |  | Level 3 Task |  |  | 2013-05-05 00:00:00 |  | 2 | 0
 |  |  |  |  | 2013-05-31 00:00:00 |  | 26 | 0.2
 |  |  |  |  |  |  | 12 | 0
TEMPLATE ROWS: Copy and insert the entire section, or just the specific sub tasks, depending on which level you want to use (formulas are different for different WBS levels)
 |  | Task Category 1 |  |  | 2013-05-05 00:00:00 |  | 0
 |  | Sub Task level 2 |  |  | 2013-05-05 00:00:00 |  | 0 | 0
 |  | Level 3 Task |  |  | 2013-05-05 00:00:00 |  | 0 | 0
 |  | Level 4 task |  |  | 2013-05-05 00:00:00 |  | 0 | 0
Spreadsheet: 727753d1618071004-formula-to-work-out-postage-costs-etsy-calculator-
Sheet: Costs

number of times relisted | date | item name | make costs | sale price | Shipping destination | shipping type | actual shipping costs | listed shipping cost | packaging type | packaging cost | transaction fee 5% | etsy payments fee 4% +£0.20 | listing fee | total fees | profit | offsite ads fee | Profit with offsite ads
 |  |  |  |  | UK | Rolled
Spreadsheet: 762042d1641376285-indexing-from-a-table-on-another-sheet-book1
Sheet: Sheet1

Name | Job | Number | Date
Q | A | 1 | 2021-01-05 00:00:00
W | S | 2 | 2021-01-01 00:00:00
E | D | 3 | 2021-01-02 00:00:00
R | F | 4 | 2021-01-05 00:00:00
T | G | 5 | 2021-01-03 00:00:00
Y | H | 6 | 2021-01-05 00:00:00
U | J | 7 | 2021-01-04 00:00:00
I | K | 8 | 2021-01-05 00:00:00
Spreadsheet: 47063d1245958931-auto-populate-multiple-cells-based-on-a-list-selection-golf1
Sheet: Courses

 | 1 | HC | 2 | HC | 3 | HC | 4 | HC | 5 | HC | 6 | HC | 7 | HC | 8 | HC | 9 | HC
Pebble Beach | 3 | 1 | 3 | 2 | 2 | 1 | 3 | 1 | 3 | 2 | 2 | 1 | 3 | 1 | 3 | 2 | 2 | 1
[NAME] | 3 | 1 | 3 | 2 | 3 | 1 | 3 | 1 | 3 | 2 | 3 | 1 | 3 | 1 | 3 | 2 | 3 | 1
Acadia Bluffs | 3 | 1 | 4 | 2 | 5 | 1 | 3 | 1 | 4 | 2 | 5 | 1 | 3 | 1 | 4 | 2 | 5 | 1
Spyglass Hill | 3 | 1 | 5 | 2 | 4 | 1 | 3 | 1 | 5 | 2 | 4 | 1 | 3 | 1 | 5 | 2 | 4 | 1
South Run | 3 | 1 | 4 | 2 | 3 | 1 | 3 | 1 | 4 | 2 | 3 | 1 | 3 | 1 | 4 | 2 | 3 | 1
Spreadsheet: 864179d1711461946-need-help-split-text-if-possible-with-specific-condition-fm-sof-30e-1-
Sheet: Sheet1

Question : How to [NAME] all text separate by "/" or If possible [NAME] all text where the length is 11
MARKS&NUMBERSCONTAINERNO./SEALNO. | What I want is separate with this order if possible
MRTU2044435/H827075/1*20GP/ MRTU2086301/H827076/1*20GP/ MRTU2169659/H827073/1*20GP/ MRTU2175965/H827074/1*20GP/
HPCU4319413/H658405/1*40HC/ HPCU4313776/H658406/1*40HC/
HPCU2217372/H657912/1*20GP/
HPCU2216890/H657971/1*20GP/ HPCU2231560/H657972/1*20GP/
HPCU2226610/H657902/1*20GP/ HPCU2224896/H657906/1*20GP/ HPCU2229650/H657905/1*20GP/ HPCU2228309/H657903/1*20GP/ HPCU2229178/H657904/1*20GP/
MRLU5211368/H658676/1*40MH/ MRLU5211603/H658675/1*40MH/ TCNU4450995/H658677/1*40HC/
Spreadsheet: mary_fischer__25611__32E-2001
Sheet: ELIST.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 032E |  | (Please print)  PREPARED BY: | [NAME]
COMPANY NAME    Enron Building Services, Invest Co
E-SCHEDULES CHECK LIST
For the period ending: 06/30/2001 |  | REVIEWED BY: | [NAME]
*  PRIORITY SCHEDULE
SCH | CONSOL ACCT | QUARTERLY SCHEDULES | COMPLETED or N/A
E-1 | 053, 060 | A/R - Other | N/A
E-2 * | 195 | Other Current Assets | N/A
E-3 * | TOT_INVEST_SUBS | Investment in Unconsolidated
 | TOT_EQEARN_OTH | Affiliates, Partnerships & Joint Ventures | N/A
E-4 * | 269, 270, 280 | Merchant and Other Investments | N/A
E-5 | 344 | Goodwill | N/A
E-6 * | TOT_PPE | Property, Plant & Equipment | N/A
 | [NAME] | Depreciation, Depletion & Amortization
[NAME] * | 343, 360 | Other Deferred Charges | N/A
E-11* | 655 | Other Current Liabilities | N/A
E-12 * | 450,  TOT_NP_OTHER | Short-Term and Long-Term Debt | N/A
 | 770,  705,  775,  765
E-14* | 860 | Other Deferred Credits | N/A
E-15 | 855 | Minority Interests | N/A
E-16* | 1676 | (Gain) Loss on Sales of Assets | N/A
E-20* | 1690, 1775 | Other Income and Other Deductions | N/A
E-21 |  | Lease Expense & Future Lease Commitments | Completed
E-31 | TOT_SHARE_EQU | Reconciliation of Stockholders' Equity and Investment in Sub | Completed
E-36 | TOT_INVEST_SUBS | Investee's Summarized Information | N/A
 | TOT_EQEARN_OTH
 |  | ADDITIONAL SCHEDULES FOR YEAR END ONLY
E-18 | 65, 641, 815, 840 | Analysis of Reserve Items | N/A
Spreadsheet: 801597d1666267404-get-another-result-directly-from-two-tables-without-auxiliary-columns-help10-20
Sheet: Sheet2

 | TABLE A |  |  |  |  |  | TABLE B | nation | Asia | Americas | Europe | Japan | Korea
 | salesman |  | nation |  | Amount | Helper column |  | discount factor | 0.1 | 0.06 | 0.08 | 0.03 | 0.12
 | A |  | Asia |  | 100
 | B |  | Americas |  | 200
 | C |  | Japan |  | 300 |  |  | salesman | Amount after discount
 | D |  | Europe |  | 400 |  |  | A
 | E |  | Korea |  | 500 |  |  | B
 | F |  | Asia |  | 600 |  |  | C
 | G |  | Japan |  | 700 |  |  | D
 | H |  | Asia |  | 800 |  |  | E
 | A |  | Americas |  | 900 |  |  | F
 | B |  | Japan |  | 1000 |  |  | G
 | C |  | Europe |  | 1100 |  |  | H
 | D |  | Korea |  | 1200
 | E |  | Asia |  | 1300
 | F |  | Japan |  | 1400
 | G |  | Asia |  | 1500
 | H |  | Americas |  | 1600
 | A |  | Japan |  | 1700
 | B |  | Europe |  | 1800
 | C |  | Korea |  | 1900
 | D |  | Asia |  | 2000
 | E |  | Japan |  | 2100
 | F |  | Asia |  | 2200
 | G |  | Americas |  | 2300
 | H |  | Japan |  | 2400
 | A |  | Europe |  | 2500
 | B |  | Korea |  | 2600
 | C |  | Asia |  | 2700
 | D |  | Japan |  | 2800
 | E |  | Asia |  | 2900
 | F |  | Americas |  | 3000
 | G |  | Japan |  | 3100
 | H |  | Europe |  | 3200
 | A |  | Korea |  | 3300
 | B |  | Asia |  | 3400
 | C |  | Japan |  | 3500
 | D |  | Asia |  | 3600
 | E |  | Americas |  | 3700
 | F |  | Japan |  | 3800
 | G |  | Europe |  | 3900
 | H |  | Korea |  | 4000
Spreadsheet: tracy_geaccone__40259__C0366-111727
Sheet: Dept_100188

ENRON PROPERTY & SERVICES CORP
1400 Smith Street
Houston, Texas   77251 - 1188
MONTHLY INVOICE DETAIL
TRANS. SUBSIDY - Dept. 100188
June, 2001
0366  EOC - Executive
Date | Ticket Number | Work Order | Service Name | Service Description | # [NAME] | Unit Cost | UOM | Service | Ticket
 |  |  |  |  |  |  |  | Total | Total
 |  |  | R/C 111727
2001-06-07 00:00:00 | TRA06/01-57295 |  | [NAME],[NAME] | D-SVC | 1 | 130 | /MNTH | 130
 |  |  |  |  |  |  | Ticket Total |  | 130
 |  |  |  |  |  |  | Total for R/C: 111727 |  | 130
 |  |  |  |  |  |  | Total for Dept_100188 |  | 130
Spreadsheet: 171220d1343663376-trasformation-graph-848797
Sheet: Sheet1

 |  | Data |  |  | DummyAxis
 | [NAME] | 12 |  | 0.5 | 1 | 1
 | [NAME] | 120 |  | 0.5 | 10 | 10
 | [NAME] | 1200 |  | 0.5 | 100 | 10²
 | [NAME] | 12000 |  | 0.5 |  | 10³
 | [NAME] | 120000 |  | 0.5 |  | 10⁴
 |  |  |  | 0.5 |  | 10⁵
 |  |  |  | 0.5 |  | 10⁶
 |  |  |  | 0.5 |  | 10⁷
Spreadsheet: 106102d1303323339-false-negatives-in-nested-vlookup-confirmed-billing-error
Sheet: Confirmed

Resource | Date | WO # | Status | Room | Budget Code | Job Name | Project | Start | Stop | Qty | Amount | Date2
[NAME] | 4/13/2011 | 2-1007593 | Confirmed | Suite 44 | 026.86520004.601978/120/US |  | 2107107 | 9:00 AM | 5:30 PM | 8.5 | 0
[NAME] | 4/14/2011 | 2-1007594 | Confirmed | Suite 44 | 026.86520004.601978/120/US |  | 2107107 | 9:00 AM | 11:00 PM | 14 | 0
[NAME] | 4/18/2011 | 2-1007596 | Confirmed | Suite 44 | 026.86520004.601978/120/US |  | 2107107 | 9:00 AM | 5:30 PM | 8.5 | 0
[NAME] | 4/18/2011 | 2-1010978 | Confirmed | Suite 44 | 026.87020001.601054/120/US |  | 2108924 | 6:00 PM | 8:00 PM | 2 | 0
Spreadsheet: 170464d1343292943-lookup-lowest-value-in-a-list-for-an-item-for-a-specific-date-book4
Sheet: Sheet1

Contracts Table
Contract Number | Contract Start Date | Date of First Service in List | Date of First Service in Contract | <Should Return
1 | 2012-01-01 00:00:00 |  |  | 2012-02-01 00:00:00
2 | 2012-01-01 00:00:00 |  |  | 2012-02-02 00:00:00
Services Table
Contract Number | Service Date | Is this in Contract?
1 | 2011-05-30 00:00:00
1 | 2012-02-01 00:00:00
1 | 2012-05-01 00:00:00
2 | 2011-01-01 00:00:00
2 | 2012-02-02 00:00:00
2 | 2012-02-05 00:00:00
Spreadsheet: 105169d1302617321-how-to-work-out-a-time-formula-to-ignore-certain-information-register
Sheet: Sheet1

DAILY REGISTER
MONTH: |  | 2011-04-01 00:00:00
DATE |  | NAME | START1 | FINISH1 | START2 | FINISH2 | HRS PER CHILD
FRI | 1 | A.PERSON | 07:30:00 | 09:00:00 | 15:00:00 | 18:00:00
 |  | B.PERSON | 07:30:00 | 09:00:00 | 15:00:00 | 18:00:00
 |  | C.PERSON | 08:00:00 | 12:00:00
 |  | D.PERSON | 09:00:00 | 10:00:00
Spreadsheet: 700131d1602986011-countif-cell-has-higher-value-than-adjoining-cells-example
Sheet: Sheet1

 |  | Score
Round | Month | [NAME] | [NAME] | [NAME] | [NAME]
1 | Jan | 6 | 7 | 8 | 9
2 | Jan | 5 | 3 | 6 | 4
3 | Jan | 8 | 5 | 3 | 2
4 | Jan | 6 | 7 | 9 | 8
5 | Jan | 8 | 7 | 5 | 6
6 | Jan | 6 | 4 | 5 | 3
7 | Jan | 9 | 6 | 4 | 5
8 | Jan | 6 | 8 | 4 | 7
9 | Jan | 7 | 9 | 8 | 5
10 | Feb | 1 | 2 | 3 | 4
11 | Feb | 1 | 2 | 3 | 4
12 | Feb | 1 | 2 | 3 | 4
 |  |  |  |  |  |  | Manually Calculated
No. times best score |  | [NAME] | [NAME] | [NAME] | [NAME] |  | [NAME] | [NAME] | [NAME] | [NAME]
Jan |  |  |  |  |  |  | 4 | 2 | 2 | 1
Feb
 |  |  |  |  |  |  | Manually Calculated
No. times worst score |  | [NAME] | [NAME] | [NAME] | [NAME] |  | [NAME] | [NAME] | [NAME] | [NAME]
Jan |  |  |  |  |  |  | 2 | 1 | 3 | 3
Feb
Spreadsheet: 08c04032-0b6c-47b3-b038-6fa840d65f8a
Sheet: 1-Cover Page

Expelled and At Risk Student Services Grant Budget
 | STATE GRANT CODE:  3183
Year 1 (7/01/14 - 06/30/15), Year 2 (7/1/15-6/30/16), Year 3 (7/1/16-6/30/17), Year 4 (7/1/17-6/30/18)
 | Funding is contingent upon future appropriations for the EARSS Program
THIS FILE CONTAINS THE BUDGET AND AFR REQUIRED FOR ALL 4 YEARS OF THIS GRANT
 | Enter District/BOCES Code/Facility Code |  |  | Enter School Name:
 | Agency Name: |  |  | Enter Facility Name:
 |  | If you do not have a 4-digit code, enter School or Facility Name
 | Budget Report: |  |  |  | Annual Financial Report-YEARS 1-4
 | Revision number: |  |  | Date Completed Year 1:
 | Date: |  |  | Date Completed Year 2:
 |  |  |  | Date Completed Year 3:
 |  |  |  | Date Completed Year 4:
 | Fiscal/Business Office Information: |  |  | Program Contact Information:
 | Name: |  |  | Name:
 | Phone No.: |  |  | Phone No.:
 | E-mail: |  |  | E-mail:
 | Update the Contact Information as required.
 | FOR RFP PROCESS SUBMIT THIS EXCEL FILE TO: | [EMAIL]
 | Program Contact: | Phone No: | E-mail Address:
 | [NAME] | [PHONE] | [EMAIL]
 | Office of Grants Fiscal Contact: | Phone No: | E-mail Address:
 | Marti Rodriguez | [PHONE] | [EMAIL]
CDE use only |  |  |  | CDE use only
Funding Summary |  |  |  | Received Date:
Year | Request on Budget | Non-Grant Summary | Approved by CDE | Submission #:
One |  |  |  | Review Date:
Two |  |  |  | [NAME] Manager:
Three |  |  |  | Preliminary App:
Four |  |  |  | Prog Managers App:
Total: |  |  |  | Approved Date:
 | 1415v3p
Spreadsheet: 798844d1664782272-search-and-count-data-from-different-column-address-checking
Sheet: address

Original Data |  |  | Split data by comma into different columns |  |  |  |  |  |  | Question :How to list Staff ID who address include cell [NAME] and Field B3
Staff ID | Address |  | Address | Address | Address | Address | Address |  |  | Pittsburgh | Teatown Road |  | Pittsburgh | Teatown Road
A1 | 3211 Temple Ave, Pomoma, CA 12345, US |  | 3211 Temple Ave | Pomoma | CA 12345 | US |  |  |  | A2 | A3
A2 | 48 Fifth Ave, Pittsburgh, PA 999, US |  | 48 Fifth Ave | Pittsburgh | PA 999 | US |  |  |  | A4 | A5 |  | A4 | A5
A3 | 159 Teatown Road, Croton-on-Hudson, NY 1111 |  | 159 Teatown Road | Croton-on-Hudson | NY 1111 |  |  |  |  |  | A6 |  |  | A6
A4 | 46, Fifth Ave, Pittsburgh, PA 999, US |  | 46 | Fifth Ave | Pittsburgh | PA 999 | US |  |  |  | A7 |  |  | A7
A5 | 888,  Teatown Road, Croton-on-Hudson, NY 1111 |  | 888 | Teatown Road | Croton-on-Hudson | NY 1111
A6 | 999 Teatown Road, Croton-on-Hudson, NY 1111 |  | 999 Teatown Road | Croton-on-Hudson | NY 1111
A7 | 333,  Teatown Road, Croton-on-Hudson, NY 1111 |  | 333 | Teatown Road | Croton-on-Hudson | NY 1111
Spreadsheet: 886782d1736886872-xlookup-help-test-worksheet
Sheet: Finance Sheet

Project Number | CT Number | Project Name | Project Name Short | Awarded Contractor | Awarded Contractor Code | Commodity Line | Accounting Line | Fund | Dept | Unit | Object | Activity | Amount | Commodity Line | Accounting Line | Fund | Dept | Unit | Object | Activity | Amount | Commodity Line | [NAME] | Fund | Dept | Unit | Object | Activity | Amount | Commodity Line | Acctounting Line | Fund | Dept | Unit | Object | Activity | Amount | Commodity Line | Accounting Line | Fund | Dept | Unit | Object | Activity | Amount | Commodity Line | Accounting Line | Fund | Dept | Unit | Object | Activity | Amount | Total Amount
12345 | 10012345 | Test Project | Short Test Project | 1st Test Company | Test0123 | 1 | 1 | 0123 | 45 | 6789 | 1011 | FY25 | 21000 | 1 | 2 | 0123 | 45 | 6789 | 1011 | FY25 | 21000 | 1 | 3 | 0123 | 45 | 6789 | 1011 | FY25 | 21000 | 1 | 4 | 0123 | 45 | 6789 | 1011 | FY25 | 21000 | 1 | 5 | 0123 | 45 | 6789 | 1011 | FY25 | 21000 | 1 | 6 | 0123 | 45 | 6789 | 1011 | FY25 | 21000
12346 | 10012346 | Test Project 2 | Short Test Project 2 | 2nd Test Company | Test0124 | 1 | 1 | 0123 | 45 | 6789 | 1011 | FY25 | 21000 | 1 | 2 | 0123 | 45 | 6789 | 1011 | FY25 | 21000 | 1 | 3 | 0123 | 45 | 6789 | 1011 | FY25 | 21000 | 1 | 4 | 0123 | 45 | 6789 | 1011 | FY25 | 21000 | 1 | 5 | 0123 | 45 | 6789 | 1011 | FY25 | 21000 | 1 | 6 | 0123 | 45 | 6789 | 1011 | FY25 | 21000
12347 | 10012347 | Test Project 3 | Short Test Project 3 | 3rd Test Company | Test0125 | 1 | 1 | 0123 | 45 | 6789 | 1011 | FY25 | 21000 | 1 | 2 | 0123 | 45 | 6789 | 1011 | FY25 | 21000 | 1 | 3 | 0123 | 45 | 6789 | 1011 | FY25 | 21000 | 1 | 4 | 0123 | 45 | 6789 | 1011 | FY25 | 21000 | 1 | 5 | 0123 | 45 | 6789 | 1011 | FY25 | 21000 | 1 | 6 | 0123 | 45 | 6789 | 1011 | FY25 | 21000
12348 | 10012348 | Test Project 4 | Short Test Project 4 | 4thTest Company | Test0126 | 1 | 1 | 0123 | 45 | 6789 | 1011 | FY25 | 21000 | 1 | 2 | 0123 | 45 | 6789 | 1011 | FY25 | 21000 | 1 | 3 | 0123 | 45 | 6789 | 1011 | FY25 | 21000 | 1 | 4 | 0123 | 45 | 6789 | 1011 | FY25 | 21000 | 1 | 5 | 0123 | 45 | 6789 | 1011 | FY25 | 21000 | 1 | 6 | 0123 | 45 | 6789 | 1011 | FY25 | 21000
12349 | 10012349 | Test Project 5 | Short Test Project 5 | 5tht Test Company | [NAME] | 1 | 1 | 0123 | 45 | 6789 | 1011 | FY25 | 21000 | 1 | 2 | 0123 | 45 | 6789 | 1011 | FY25 | 21000 | 1 | 3 | 0123 | 45 | 6789 | 1011 | FY25 | 21000 | 1 | 4 | 0123 | 45 | 6789 | 1011 | FY25 | 21000 | 1 | 5 | 0123 | 45 | 6789 | 1011 | FY25 | 21000 | 1 | 6 | 0123 | 45 | 6789 | 1011 | FY25 | 21000