tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 863798d1711191768-formula-for-a-variable-value-every-nth-month-1
Sheet: 1

 |  |  | 2024-07-01 00:00:00
Upfront Client Payment: | 0.3
First Client Payment During Construction Period: | 0.1
Second Client Payment During Construction Period: | 0.1
Third Client Payment During Construction Period: | 0.1
Client Payment Upon Construction End: | 0.4
Months between each payment during Construction | 6
Total Value of Apartments Sold: |  |  | 0 | 0 | 0 | 0 | 20000000 | 21000000 | 22050000 | 23152500 | 15558480 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Residential Units
Upfront Client Payment: |  |  |  |  |  |  |  |  |  |  | 0
First Client Payment During Construction Period: |  |  |  |  |  |  |  |  |  |  |  |  | ? | ? | ? | ?
Second Client Payment During Construction Period: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ? | ? | ? | ?
Third Client Payment During Construction Period: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ? | ? | ? | ?
Client Payment Upon Construction End:
Spreadsheet: 799859d1665370525-gantt-chart-showing-milestone-overdue-with-revised-date-gantt-chart-with-revised-date
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  | 2022 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023
 |  |  |  |  |  |  |  |  |  |  | Quarter 1 |  |  |  |  |  |  |  |  |  |  |  |  | Quarter 2 |  |  |  |  |  |  |  |  |  |  |  |  | Quarter 3 |  |  |  |  |  |  |  |  |  |  |  |  | Quarter 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | May |  |  |  |  | June |  |  |  | July |  |  |  | Aug |  |  |  |  | Sept |  |  |  | Oct |  |  |  |  | Nov |  |  |  | Dec |  |  |  | Jan |  |  |  |  | Feb |  |  |  | Mar
PROJECT | ANNUAL  GOAL | [NAME] ID | MILESTONE | REPORTING CONTACT | START  DATE | END  DATE | REVISED DATE | # DAYS | %  DONE | CURRENT MIL STATUS | 2022-04-04 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | If milestone OR project has minor deviations or major deviations, explain why, and specify how timelline changes.
Health Care Worker Mental Health & Addictions Supports Program | Sustain Health Care Worker Mental Health Supports Program | 1 | Develop new pathway to include referral or transfer of referral to OPA. | Monisha Patel | 2022-06-30 00:00:00 | 2022-10-19 00:00:00 | 2022-12-31 00:00:00 |  | 0.9 | On Track
 |  | 2 | Continue to provide timely (<7 days) access to 1:1 supports | Monisha Patel | 2022-04-01 00:00:00 | 2022-06-30 00:00:00 | 2023-01-11 00:00:00 |  | 0.5 | On Track
 |  | 3 | Continue to sustain the program ​ | Monisha Patel | 2022-07-01 00:00:00 | 2023-03-31 00:00:00 |  |  | 0.5 | Minor Deviation
Youth Wellness Hubs Ontario | Support Expansion of Youth Wellness Hubs | 1 | Develop workplans with YWHO | TBD | 2022-04-01 00:00:00 | 2022-06-30 00:00:00 |  |  | 1 | Complete
 |  | 2 | Issue funding letter to YWHO (via CAMH) | TBD | 2022-07-01 00:00:00 | 2022-09-30 00:00:00 |  |  | 1 | Complete
Mobile Mental Health & Addiction Clinics | Implement and evaluate MMHACs in Ontario | 1 | Receive ADM funding letter for up to 3 additional MMHACs | Monisha Patel | 2022-04-01 00:00:00 | 2022-06-30 00:00:00 |  |  | 0.75 | On Track
 |  | 2 | Launch 4 MMHACs so they can start to accept referrals and see clients | Monisha Patel | 2022-04-01 00:00:00 | 2023-03-31 00:00:00 |  |  | 0.5 | Major Deviation
 |  | 3 | Complete the review process to onboard one additional MMHAC | Monisha Patel | 2022-04-01 00:00:00 | 2022-06-30 00:00:00
 |  | 4 | Issue funding agreements for up to 3 additional MMHACs | Monisha Patel | 2022-07-01 00:00:00 | 2022-09-30 00:00:00
 |  | 5 | Develop an evaluation framework | Monisha Patel | 2022-10-01 00:00:00 | 2023-03-31 00:00:00
 |  | 6 | Onboard the 4 approved MMHACs to be fully operational | Monisha Patel | 2022-10-01 00:00:00 | 2022-12-31 00:00:00
 |  | 7 | Collect baseline data | Monisha Patel | 2023-01-01 00:00:00 | 2023-03-31 00:00:00
Spreadsheet: 750725d1633607824-count-continuous-instances-and-get-max-value-from-corresponding-column-sample
Sheet: Sheet1

Quantity | Category |  | Variable | Values
625 | 1 |  | Low-Count | 7
616 | 1 |  | Low-maxQtyForLow | 1030
578 | 1 |  | Low-continuous count | 5
571 | 1 |  | Low-maxQtyForContinuousCount | 625
571 | 1
6030 | 2 |  | Medium-Count | 6
2430 | 2 |  | Medium-maxQtyForMedium | 6030
1030 | 1 |  | Medium-continuous count | 4
920 | 1 |  | Medium-maxQtyForContinuousCount | 6030
2920 | 2
2750 | 2
2690 | 2
2540 | 2
Spreadsheet: 792953d1661245394-creating-a-results-list-of-multiple-races-results-1-
Sheet: Sheet1

 |  | Plaats | place | Race 2 | Race 3 | Race 4 |  |  | Place | [NAME] number | Points
 |  | 1 | 147 | 85 | 147 | 85 |  |  |  | 147 | 34
 |  | 2 | 200 | 7 | 114 | 63 |  |  |  | 200 | 20
 |  | 3 | 7 | 63 | 14 | 133 |  |  |  | 7 | 11
 |  | 4 | 220 | 250 | 19 | 222 |  |  |  | 220 | 22
 |  | 5 | 48 | 133 | 222 | 19 |  |  |  | 48 | 27
 |  | 6 | 14 | 222 | 7 | 1015 |  |  |  | 14 | 30
 |  | 7 | 87 | 113 | 250 | 200
 |  | 8 | 1015 | 19 | 85 | 220
 |  | 9 | 199 | 87 | 48 | 113
 |  | 10 | 63 | 220 | 113 | 87
 |  | 11 | 85 | 200 | 63 | 6
 |  | 12 | 145 | 2 | 2 | 145
 |  | 13 | 19 | 48 | 87 | 1013
 |  | 14 | 57 | 960 | 1015 | 960
 |  | 15 | 3 | 14 | 960 | 2
 |  | 16 | 2 | 147 | 1013 | 147
 |  | 17 | 960 | 199 | 145 | 599
Spreadsheet: 465430d1465645959-find-similar-coordinate-pairs-in-a-2-column-list-closest-coordinate-pairs
Sheet: Sheet1

 |  |  | closest coordinate pair |  | 2nd closest pair
1 | -5.63 | 48.77
2 | -12 | 49.18
3 | -40.35 | 51.02
4 | -18.46 | 49.6
5 | -15.13 | 49.38
6 | -33.33 | 50.57
7 | -38.1 | 58.55
8 | -31.29 | 51.5
9 | -32.45 | 52.57
10 | -32.77 | 50.53
11 | -39.54 | 59.58
12 | -28.87 | 50.28
13 | -5.69 | 48.87
14 | -5.55 | 48.57
 | Match Tolerances
1 | -5.63 | 48.77
2 | -12 | 49.18
3 | -40.35 | 51.02
4 | -18.46 | 49.6
5 | -15.13 | 49.38
6 | -33.33 | 50.57
7 | -38.1 | 58.55
8 | -31.29 | 51.5
9 | -32.45 | 52.57
10 | -32.77 | 50.53
11 | -39.54 | 59.58
12 | -28.87 | 50.28
13 | -5.69 | 48.87
14 | -5.55 | 48.57
Spreadsheet: john_griffith__16174__1_29_02LO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | CL H2 | 19.5 | 168 | 178 | 51.6 | 54.7 | 0.65 | 2002-01-29 10:10:00
 | CL J2 | 20 | 270 | 280 | 48.4 | 50.2 | 0.62 | 2002-01-29 10:10:00
 | CL K2 | 20 | 346 | 356 | 47.4 | 48.7 | 0.6 | 2002-01-29 10:10:00
 | CL M2 | 20.5 | 393 | 405 | 45 | 46.4 | 0.59 | 2002-01-29 10:10:00
 | CL N2 | 20.5 | 430 | 450 | 43.4 | 45.4 | 0.57 | 2002-01-29 10:10:00
 | CL Q2 | 20.5 | 460 | 475 | 42.2 | 43.6 | 0.55 | 2002-01-29 10:10:00
 | CL U2 | 20.5 | 475 | 490 | 40.5 | 41.8 | 0.53 | 2002-01-29 10:10:00
 | [NAME] | 20.5 | 485 | 505 | 38.4 | 40 | 0.51 | 2002-01-29 10:10:00
 | CL X2 | 20.5 | 485 | 510 | 36.2 | 38.1 | 0.48 | 2002-01-29 10:10:00
 | [NAME] | 20.5 | 490 | 515 | 34.9 | 36.7 | 0.46 | 2002-01-29 10:10:00
 | CL F3 | 20.5 | 490 | 530 | 33.3 | 36.1 | 0.45 | 2002-01-29 10:10:00
 | CL G3 | 20.5 | 495 | 535 | 32.3 | 34.9 | 0.43 | 2002-01-29 10:10:00
 | CL M3 | 20.5 | 530 | 560 | 30.4 | 32.2 | 0.4 | 2002-01-29 10:10:00
 | CL Z3 | 20.5 | 540 | 560 | 27 | 28 | 0.35 | 2002-01-29 10:10:00
 | CL M4 |  |  |  | 21.8 | 24.4 | 0.31 | 2002-01-04 13:39:00
 |  |  |  |  |  |  |  | ,
Spreadsheet: 783902d1655288640-countifs-without-knowing-which-column-countifs-help
Sheet: Sheet1

User ID | Product number | Sweet | Salty | Sour | Bitter | Umami
1 | Product 1 | 2 | 1 | 4 | 2 | 4 |  | Sweet | Product 1 | Product 2 | Product 3 |  | Salty | Product 1 | Product 2 | Product 3
1 | Product 2 | 1 | 2 | 2 | 1 | 2 |  | 1 |  |  |  |  | 1
1 | Product 3 | 2 | 2 | 1 | 4 | 2 |  | 2 |  |  |  |  | 2
2 | Product 1 | 3 | 4 | 5 | 5 | 5 |  | 3 |  |  |  |  | 3
2 | Product 2 | 5 | 1 | 4 | 2 | 2 |  | 4 |  |  |  |  | 4
2 | Product 3 | 3 | 1 | 4 | 5 | 4 |  | 5 |  |  |  |  | 5
3 | Product 1 | 3 | 5 | 4 | 3 | 5
3 | Product 2 | 5 | 3 | 4 | 2 | 5
3 | Product 3 | 1 | 5 | 5 | 1 | 4 |  | Sour | Product 1 | Product 2 | Product 3 |  | Bitter | Product 1 | Product 2 | Product 3
4 | Product 1 | 2 | 3 | 3 | 4 | 3 |  | 1 |  |  |  |  | 1
4 | Product 2 | 3 | 5 | 2 | 2 | 3 |  | 2 |  |  |  |  | 2
4 | Product 3 | 4 | 2 | 2 | 2 | 4 |  | 3 |  |  |  |  | 3
5 | Product 1 | 2 | 3 | 3 | 2 | 3 |  | 4 |  |  |  |  | 4
5 | Product 2 | 2 | 3 | 4 | 4 | 1 |  | 5 |  |  |  |  | 5
5 | Product 3 | 5 | 1 | 1 | 1 | 1
6 | Product 1 | 4 | 5 | 2 | 1 | 2 |  | Umami | Product 1 | Product 2 | Product 3
6 | Product 2 | 4 | 1 | 5 | 1 | 1 |  | 1
6 | Product 3 | 3 | 5 | 5 | 5 | 2 |  | 2
7 | Product 1 | 5 | 1 | 1 | 1 | 5 |  | 3
7 | Product 2 | 1 | 2 | 2 | 3 | 3 |  | 4
7 | Product 3 | 1 | 2 | 3 | 5 | 3 |  | 5
8 | Product 1 | 5 | 5 | 4 | 4 | 5
8 | Product 2 | 5 | 3 | 2 | 5 | 3
8 | Product 3 | 2 | 2 | 4 | 5 | 4
9 | Product 1 | 5 | 1 | 2 | 3 | 2
9 | Product 2 | 2 | 2 | 2 | 3 | 5
9 | Product 3 | 3 | 2 | 5 | 4 | 3
10 | Product 1 | 2 | 1 | 3 | 4 | 2
10 | Product 2 | 5 | 2 | 2 | 3 | 5
10 | Product 3 | 1 | 1 | 3 | 1 | 5
11 | Product 1 | 2 | 2 | 4 | 5 | 2
11 | Product 2 | 1 | 5 | 5 | 2 | 4
11 | Product 3 | 4 | 4 | 4 | 1 | 1
Spreadsheet: 85697d1285759591-automatic-sorting-by-price-wine-list-trial
Sheet: Under 35

wines under 30 | Price
Fresh & Crisp Whites
St. Jorge Winery Verdelho, Lodi 2009 | 25
Peltier Station [NAME], Lodi 2007 | 25
[NAME] Sauvignon Blanc, Lake County 2009 | 25
Van Ruiten Family Vineyard Chardonnay, Lodi  2009 | 30
[NAME], Terra Alta, Lodi 2008 | 30
[NAME]
Polka Dot Riesling 'Semi Sweet', Pfalz, Germany 2008 | 25
L'Uvaggio di Giacomo Vermentino, Lodi  2008 | 26
[NAME] Brio Pinot Grigio, Lodi  2008 | 28
Vicarmont Sauvignon Blanc, Lodi 2009 | 30
Dancing Coyote Gewürztraminer, Clarksburg 2009 | 30
Easygoing Reds
Peirano Estate Vineyard '6th Clone' Merlot, Lodi  2007 | 25
Oakridge 'OZV' Old Zin Vines Zinfandel, [NAME],  2006 | 25
LangeTwins Estate Grown Zinfandel, Lodi 2007 | 26
[NAME]6th Sense' [NAME], Lodi  2007 | 28
Dancing Coyote Pinot Noir, Clarksburg 2009 | 30
Mac Murray Pinot Noir, Sonoma Coast 2008 | 30
Van Ruiten Family [NAME], Lodi 2006 | 30
Vicarmont Eclectic Pink Rosé, Lodi 2009 | 30
Aromatic Reds
[NAME], Lodi  2008 | 28
[NAME], Napa Valley  2006 | 30
St. Amant Barbera, Lodi  2008 | 30
Van Ruiten Family Vineyards 'Old Vine' Zinfandel, Lodi  2008 | 30
Akin Estates Tannat, [NAME], Lodi,  2006 | 30
Klinker Brick Winery 'Old Vine' Zinfandel, Lodi  2007 | 30
De Tierra Pinot Noir, Monterey  2006 | 30
Spreadsheet: tracy_geaccone__40591__CF_GPG_CONS
Sheet: MayCM

Enron Gas Pipeline Group
Statement of Consolidated Cash Flows
For the 1 month ended May 31, 2000
 | CONSOLIDATED |  |  |  |  |  |  | HPLO | HPL | LRC | LIQUIDS | GATHER | LIQUIDS | SERVICE |  |  | TOTAL
(In Thousands) | GPG & EOTT |  | GPG | NNG | TW | EC | NP | 543 | 584 | 583 | DOMESTIC |  | GROUP | COS | OTHER |  | EOTT
Operating Cash Inflows (Outflows)
Net income before financing costs
Financing costs
NI after financing costs (excluding cons subs equity earn)
Depreciation, depletion and amortization
Deferred income taxes
Gains on sales of assets and investments
Dividends on pref securities of subsidiary cos.
Equity earnings
Equity/partnership distributions
Other, net
Funds Flow
Changes in components of working capital
Receivables
A/R, A/P - Intercompany
Inventories
Prepayments
Payables
Exchange Rec/Payable
Accrued taxes
Accrued interest
Other working capital
Total changes in components of working capital
Net Cash Provided by Operating Activities
Investing Cash Inflows (Outflows)
Proceeds from sale of assets and investments
Capital Expenditures
Underground Storage,Salvage & Removal Costs
EOTT Revolver and API's
Other investing activities - intercompany
Other investing activities, net
Net Cash Provided by Investing Activities
Cash Flows From Financing Activities
Net increase (decrease) in short-term borrowings
Issuance of long-term debt
Repayment of long-term debt
Other financing activities - I/C
Other financing activities, net
Net Cash Provided by Financing Activities
INC (DEC) IN CASH & CASH EQUIV, I/C CASH FROM CORP
INC (DEC) IN CASH & CASH EQUIV |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
INC (DEC) INTERCOMPANY CASH FROM CORPORATE
Change in other obligations
Change in total obligations
Spreadsheet: 145410d1331573072-excel-2007-referening-from-one-workbook-to-another-formula-inside-turnover1
Sheet: Inside Turnover

 | Memphis LRC |  |  | Last Injury | 2012-03-06 00:00:00 | 6 | Service - Cost Control - Asset Utilization - Safety - People
Date |  |  | 2012-03-12 00:00:00 | Shift
HHP | 0 | LHP | 0 | STRG | 0 |  | Total | 0
Track | Position | L / H  HP | Unit | Pred'd out | Ready | FX/SV | Notes | Assigned Employee
1 | E |  | 1200 | 3am
 | M
 | W
2 | E
 | M
 | W
3 | E
 | M
 | W
4 | E
 | M
 | W
5 | Wash
 | F / TRK
 | Wheel Mach.
 | JT
 | BTS
 | D/T
 | LB
 | OWH
 | W&D
 | RUNAROUND TRACK
 | 1
 | 2
 | 3
 | 4
 | 5
 | Released |  |  | Shopped |  |  | Units Coming
 | OUTSIDE TRACKS
1 | E - 1
 | E - 1
 | W - 1
 | W - 1
2 | E - 1
 | E - 1
 | W - 1
 | W - 1
3 | E - 1
 | E - 1
 | W - 1
 | W - 1
4 | E - 1
 | E - 1
 | W - 1
 | W - 1
5 | E - 1
 | E - 1
 | W - 1
 | W - 1
Spreadsheet: 52834d1252650719-extracting-data-to-another-workbook-with-a-certain-cretira-vlookup-example
Sheet: Sheet2

Enter Name | First
Date | Operator | Service | Destination | ID Number | Time | Comments
2009-09-09 00:00:00 | First | 6 | Livinghston | DEF 11 | 10:15:00 | No rear Display
2009-09-09 00:00:00 | First | 12 | Broxburn | ABC 123 | 10:00:00 | Ok
2009-09-09 00:00:00 | First | 89 | [NAME] | IO1 LTD | 10:40:00 | Ok
Spreadsheet: 690505d1597147822-formula-to-calculate-scheduling-time-test
Sheet: Foglio1

Matricola | [NAME]. | [NAME] | Q.tà Prodotta | [NAME] | Pz./ora | Ore di Produzione | Ore Attrezzaggio | ORE TOTALI | N° TURNI (da 8 ore) | DATA INIZIO | DATA DI FINE | F.P. | [NAME] | DATA FINE PROD
aaa | 111 | 5818 |  | 23000 | 1000 |  | 1:00:00 |  | 1 | 2020-08-01 06:00:00 |  |  | 02:00:00
bbb | 111222 | 5223 |  | 23000 | 1000 |  | 1:00:00 |  | 2 | 2020-08-01 06:00:00
Spreadsheet: 685844d1594222851-needing-help-with-find-and-add-between-dates-type-formulas-fuel-tracking
Sheet: Sheet2

 |  |  |  |  |  |  |  | Today
Date | Equipment # | Hours | Gallons |  |  |  |  | Past Days in Period |  | 40
2020-05-03 00:00:00 | 32 | 7500 | 34
2020-05-10 00:00:00 | 45 | 12540 | 50 |  |  |  |  | Equipment # |  | 45
2020-05-17 00:00:00 | 32 | 7645 | 45
2020-05-17 00:00:00 | 45 | 12600 | 75 |  |  |  |  | Beginning Date |  | 2020-06-01 00:00:00
2020-05-24 00:00:00 | 45 | 12702 | 60 |  |  |  |  | Hours on Beginning Date day |  | 12800
2020-05-25 00:00:00 | 17 | 5640 | 24 |  |  |  |  | Gallons on Beginning day |  | 55
2020-05-31 00:00:00 | 32 | 7700 | 61
2020-06-01 00:00:00 | 45 | 12800 | 55
2020-06-03 00:00:00 | 17 | 5700 | 27
2020-06-05 00:00:00 | 32 | 7731 | 34 |  |  |  |  | Ending Date |  | 2020-07-03 00:00:00
2020-06-07 00:00:00 | 45 | 12900 | 47 |  |  |  |  | Hours on ending day |  | 13375
2020-06-12 00:00:00 | 45 | 13134 | 60
2020-06-12 00:00:00 | 32 | 7789 | 29
2020-06-12 00:00:00 | 17 | 5757 | 35 |  |  |  |  | Total Gallons |  | 518
2020-06-18 00:00:00 | 45 | 13200 | 78
2020-06-18 00:00:00 | 32 | 7812 | 15
2020-06-18 00:00:00 | 17 | 5805 | 14
2020-06-22 00:00:00 | 17 | 5834 | 30
2020-06-24 00:00:00 | 45 | 13264 | 59 |  |  |  |  |  | Inputs=>
2020-06-24 00:00:00 | 32 | 7869 | 60
2020-06-29 00:00:00 | 17 | 5867 | 32
2020-07-01 00:00:00 | 45 | 13307 | 34
2020-07-01 00:00:00 | 17 | 5890 | 27 |  |  |  | Based on a variable beginning date and how many days forward to analyze, I need to sum up all the fuel
2020-07-02 00:00:00 | 32 | 7900 | 59 |  |  |  | used on the equipment# shown in K45.
2020-07-03 00:00:00 | 45 | 13375 | 65 |  |  |  | Peach colored cells are the input cells, yellow cells are where we need the outputs.
2020-07-03 00:00:00 | 17 | 5903 | 24
2020-07-05 00:00:00 | 32 | 7960 | 45 |  |  |  | K7 = Returns closest date in table that pertains to Eq# in K5
2020-07-06 00:00:00 | 17 | 5922 | 27.5 |  |  |  | K8 = Returns hours pertaining to date used in K7
 |  |  |  |  |  |  | K9 = Returns gallons pertaining to date used in K7
 |  |  |  |  |  |  | K13 = Returns past date closest to 45 days(K3) back from variable date
 |  |  |  |  |  |  | K14 = Hours pertaining to the date used in K13
 |  |  |  |  |  |  | K17 = Returns a total of all the gallons used by Equipment#(K5) between the two found dates. The
 |  |  |  |  |  |  | summation need to exclude the last gallon value (Found on returned date of K13)
 |  |  |  |  |  |  | I've gone in a manually filled in the data for reference
Spreadsheet: 748580d1632226036-populate-dynamic-calendar-with-tasks-based-on-task-frequency-tasks-calendar-ans-1-
Sheet: Calendar

Sep | Task1 | [NAME] | Task3 | Task4 | Task5 | Task6 | Task7 | Task8 | Task9 | Task10 | Task11 | Task12 | Task13 | Task14 | Task15
2021-09-01 00:00:00
2021-09-02 00:00:00 |  |  |  |  | Y |  |  |  |  | Example
2021-09-03 00:00:00 | Y |  |  |  |  |  | Y
2021-09-04 00:00:00
2021-09-05 00:00:00 |  |  | Y
2021-09-06 00:00:00
2021-09-07 00:00:00
2021-09-08 00:00:00
2021-09-09 00:00:00
2021-09-10 00:00:00
2021-09-11 00:00:00
2021-09-12 00:00:00
2021-09-13 00:00:00
2021-09-14 00:00:00
2021-09-15 00:00:00
2021-09-16 00:00:00
2021-09-17 00:00:00
2021-09-18 00:00:00
2021-09-19 00:00:00
2021-09-20 00:00:00
2021-09-21 00:00:00
2021-09-22 00:00:00
2021-09-23 00:00:00
2021-09-24 00:00:00
2021-09-25 00:00:00
2021-09-26 00:00:00
2021-09-27 00:00:00
2021-09-28 00:00:00
2021-09-29 00:00:00
2021-09-30 00:00:00
2021-10-01 00:00:00
2021-10-02 00:00:00
2021-10-03 00:00:00
2021-10-04 00:00:00
2021-10-05 00:00:00
2021-10-06 00:00:00
2021-10-07 00:00:00
2021-10-08 00:00:00
2021-10-09 00:00:00
2021-10-10 00:00:00
2021-10-11 00:00:00
2021-10-12 00:00:00
2021-10-13 00:00:00
2021-10-14 00:00:00
2021-10-15 00:00:00
2021-10-16 00:00:00
2021-10-17 00:00:00
2021-10-18 00:00:00
2021-10-19 00:00:00
2021-10-20 00:00:00
2021-10-21 00:00:00
2021-10-22 00:00:00
2021-10-23 00:00:00
2021-10-24 00:00:00
2021-10-25 00:00:00
2021-10-26 00:00:00
2021-10-27 00:00:00
2021-10-28 00:00:00
2021-10-29 00:00:00
2021-10-30 00:00:00
2021-10-31 00:00:00
2021-11-01 00:00:00
2021-11-02 00:00:00
2021-11-03 00:00:00
2021-11-04 00:00:00
2021-11-05 00:00:00
2021-11-06 00:00:00
Spreadsheet: 49992d1249407978-count-and-total-the-unknown-matching-data-occurences-across-multi-worksheets-dummy2
Sheet: Sept

cow | 703
cow | 703
cow | 703
cow | 703
cow | 703
cow | 703
cow | 702
cow | 702
cow | 702
cow | 702
cow | 702
cow | 702
bird | 1
pig | 552
pig | 552
pig | 552
pig | 552
pig | 552
pig | 552
pig | 552
pig | 552
pig | 552
Spreadsheet: 026bdcb3-4e1e-4170-afcf-20463afe6d77
Sheet: Sheet1

[NAME]. | [NAME] | Pareigybinis atlyg.
2 | Pavardenis | 600
3 | [NAME] | 600
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
Spreadsheet: 718726d1613313484-extract-values-into-column-a-to-column-k-of-sheet-named-here_1-ignoring-blanks-extract-values-ignoring-blanks
Sheet: Okay

Name_1 | Name_2 | Middle | Area | Area Time | Local Time | GPS | Letter | District Name | Distance | Status
Spreadsheet: 766672d1643992168-distributing-cost-over-multiple-years-based-on-start-and-end-date-costdistributionbyyearsample
Sheet: Tabular Data

Total Cost | Start Date | End Date | 2022 | 2023 | 2024 | 2025 | 2026 | 2027 | 2028 | 2029 | 2030 | 2031
200000 | 2022-04-01 00:00:00 | 2031-11-01 00:00:00
100000 | 2023-04-01 00:00:00 | 2028-11-01 00:00:00
50000 | 2026-04-01 00:00:00 | 2026-11-01 00:00:00
30000 | 2027-04-01 00:00:00 | 2028-11-01 00:00:00
Sample Correct Outcome
Total Cost | Start Date | End Date | 2022 | 2023 | 2024 | 2025 | 2026 | 2027 | 2028 | 2029 | 2030 | 2031
200000 | 2022-04-01 00:00:00 | 2031-11-01 00:00:00
Spreadsheet: 0dfa670e-c8e7-483a-943a-58546413c33c
Sheet: Sheet1

 |  | Pilots N Paws 19 Jan 2013  KJYO to  KLDJ
Leg # | [NAME] | Pilot | Arrive | FBO/Location | Aircraft | Ground contact
1 | KJYO | [NAME] | KCRW | Exec Air Terminal | Mooney N210AK | [NAME]
 | 08:00:00 | [PHONE] | 09:45:00 | [PHONE] |  | [PHONE]
2 | CRW | [NAME] | KJYO | [NAME]'s hangar | Mooney N210AK | [NAME]
 | 10:15:00 |  | 11:45:00
3 | KJYO | [NAME] | KLDJ | Linden Aprt Mgmt Corp | Twin Cessna N5U | [NAME]
 | 12:15:00 | [PHONE] | 13:45:00 | [PHONE] |  | [PHONE]
4 | KLDJ | [NAME] | KJYO
 | 14:30:00 |  | 15:45:00
[NAME]
 | [NAME]
 | [EMAIL]
 | [NAME]
 | [EMAIL]
 | Christina
 | [EMAIL]
 | [NAME] or [EMAIL]
 | [NAME]
 | [EMAIL]
 |  | Name
Passengers | [NAME] | Gabe?
 | [NAME] | Hugh?
 | Terrier 1
 | Terrier 2
 | Tibetan S/T
Spreadsheet: 98642d1297503072-repeat-material-codes-copy-of-problem-1
Sheet: Sheet1

Desired Result
 | Material | 5008300001 | Shortage
 | Order | 81000000 | 1
 | Order | 81000001 | 2
 | Order | 81000002 | 3
 | Order | 81000003 | 4
 | Material | 5008300002
 | Order | 81000010 | 12
 | Order | 81000011 | 13
 | Order | 81000012 | 14
 | Order | 81000013 | 15
 | Order | 81000014 | 16
 | Order | 81000015 | 17
 | Order | 81000016 | 18
 | Order | 81000017 | 19
 | Order | 81000018 | 20
 | Material | 5008300003
 | Order | 81000010 | 12
 | Order | 81000011 | 13
 | Order | 81000012 | 14
 | Order | 81000013 | 15
 | Order | 81000014 | 16
 | Order | 81000015 | 17
 | Order | 81000016 | 18
 | Order | 81000017 | 19
 | Order | 81000018 | 20
Spreadsheet: 827225d1682558245-rolling-average-over-moving-dataset-rolling-average-over-moving-dataset
Sheet: Monthly Capture

 | Month Results | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00 | 2022-01-01 00:00:00 | 2022-02-01 00:00:00 | 2022-03-01 00:00:00 | 2022-04-01 00:00:00 | 2022-05-01 00:00:00 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | 2022-10-01 00:00:00 | 2022-11-01 00:00:00 | 2022-12-01 00:00:00 | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00
 | Store A | 6 | 4 | 8 | 8 | 6 | 7 | 9 | 6 | 4 | 8 | 8 | 6 | 7 | 9 | 7 | 8 | 10 | 7 | 6 | 13 | 7 | 8 | 13 | 4 | 10 | 9 | 10
 | Store B | 11 | 12 | 9 | 8 | 9 | 6 | 9 | 11 | 12 | 9 | 8 | 9 | 6 | 9 | 12 | 7 | 12 | 9 | 7 | 12 | 8 | 8 | 10 | 8 | 10 | 11 | 11
 | Store C | 31 | 22 | 26 | 37 | 27 | 33 | 20 | 31 | 22 | 26 | 37 | 27 | 33 | 20 | 25 | 16 | 21 | 21 | 17 | 24 | 25 | 27 | 24 | 18 | 22 | 16 | 46
 | Store D | 59 | 38 | 40 | 62 | 35 | 55 | 33 | 59 | 38 | 40 | 62 | 35 | 55 | 33 | 41 | 32 | 44 | 42 | 41 | 49 | 40 | 54 | 51 | 36 | 44 | 36 | 46
 | Store E | 24 | 19 | 29 | 14 | 23 | 18 | 24 | 24 | 19 | 29 | 14 | 23 | 18 | 24 | 37 | 16 | 34 | 28 | 26 | 17 | 18 | 19 | 27 | 26 | 40 | 24 | 31
Spreadsheet: 751769d1634308436-find-the-last-value-to-calculate-the-total-amount-forumhelp_10-15
Sheet: Sheet1

name | Total inventory quantity | The final total amount |  | Date | name | Inbound quantity | price
Apple | 380 | 3484 |  | 2021-08-07 00:00:00 | Apple | 89 | 1.2
pear | 950 | 6466.3 |  | 2021-08-08 00:00:00 | pear | 100 | 1.3
banana | 500 | 5296 |  | 2021-08-09 00:00:00 | banana | 156 | 1.4
Grape | 330 | 4216 |  | 2021-09-10 00:00:00 | Grape | 200 | 2.4
 |  |  |  | 2021-09-11 00:00:00 | Apple | 100 | 3.4
 |  |  |  | 2021-09-12 00:00:00 | pear | 505 | 4.4
 |  |  |  | 2021-09-13 00:00:00 | banana | 160 | 5.4
 |  |  |  | 2021-09-14 00:00:00 | Grape | 264 | 6.4
 |  |  |  | 2021-10-15 00:00:00 | Apple | 186 | 7.4
 |  |  |  | 2021-10-16 00:00:00 | pear | 188 | 8.4
 |  |  |  | 2021-10-17 00:00:00 | banana | 289 | 9.4
 |  |  |  | 2021-10-18 00:00:00 | Grape | 185 | 10.4
 |  |  |  | 2021-10-19 00:00:00 | Apple | 181 | 11.4
 |  |  |  | 2021-10-20 00:00:00 | pear | 210 | 12.4
 |  |  |  | 2021-10-21 00:00:00 | banana | 180 | 13.4
 |  |  |  | 2021-10-22 00:00:00 | Grape | 196 | 14.4
Spreadsheet: 862978d1710525367-calendar-formulas-and-conditional-formatting-annual-calendar-dj
Sheet: November

 |  |  |  |  |  |  |  |  | NOV
 | NOTES