tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 672093d1586727996-need-to-pull-data-from-one-worksheet-into-another-and-sort-data-formula-example-charlie18-
Sheet: Master

Last Name | First Name | Score
 |  |  |  |  | Last Name | First Name | Sum of Score
 |  |  |  |  | Rojas | Dionne | 87
 |  |  |  |  | [NAME] | Hashir | 50
 |  |  |  |  | Stout | Zaydan | 34
 |  |  |  |  | Grand Total |  | 171
Spreadsheet: 879357d1726838959-sum-a-range-of-cells-sum-to-forum
Sheet: Sheet1

 |  |  |  |  |  |  | # of occcurances | Day |  |  | total of Occurances
 |  |  |  |  |  |  | 10 | 1 | 1 to 5
 |  |  |  |  |  |  | 2 | 2 | 5.25 to 10
 |  |  |  |  |  |  | 5 | 3 | 10.25 to 20 |  |  | Continue formula in L4 down through data set
 |  |  |  |  |  |  | 6 | 4 | 20.25 to 30
 |  |  |  |  |  |  | 12 | 5
 |  |  |  |  |  |  | 2 | 6
 |  |  |  |  |  |  | 1 | 7
 |  |  |  |  |  |  | 8 | 8
 |  |  |  |  |  |  | 4 | 9
 |  |  |  |  |  |  | 3 | 10
 |  |  |  |  |  |  | 2 | 11
 |  |  |  |  |  |  | 9 | 12
 |  |  |  |  |  |  | 8 | 13
 |  |  |  |  |  |  | 4 | 14
 |  |  |  |  |  |  | 2 | 15
 |  |  |  |  |  |  | 6 | 16
 |  |  |  |  |  |  | 6 | 17
 |  |  |  |  |  |  | 8 | 18
 |  |  |  |  |  |  | 5 | 19
 |  |  |  |  |  |  | 6 | 20
 |  |  |  |  |  |  | 4 | 21
 |  |  |  |  |  |  | 4 | 22
 |  |  |  |  |  |  | 3 | 23
 |  |  |  |  |  |  | 2 | 24
 |  |  |  |  |  |  | 2 | 25
 |  |  |  |  |  |  | 1 | 26
 |  |  |  |  |  |  | 1 | 27
 |  |  |  |  |  |  | 5 | 28
 |  |  |  |  |  |  | 3 | 29
 |  |  |  |  |  |  | 4 | 30
 |  |  |  |  |  |  | 1 | 31
Spreadsheet: 766627d1643973404-day-count-for-act-365-fixed-convention-day-count-aligw
Sheet: Sheet1

2020-12-31 00:00:00
 |  |  | Start: | 2022-06-01 00:00:00
 |  |  | End: | 2024-12-31 00:00:00
Spreadsheet: kam_keiser__18014__Reco!J11
Sheet: BS Rec

Enron North America
Business Analysis & Reporting - Portfolio Accounting
Balance Sheet Reconciliation
Book: | [NAME]
Month:
Mark to Market Assets/Liabilities
 | General [NAME] |  | Profit Center |  | Total (M$)
 | (company/account)
 | 967.21060000 |  | 39651229
 | 967.25100000 |  | 1341965
 | 967.30300000 |  | -38789660
 | 967.33100000 |  | -1810333
 | Total  MTM Assets/Liab
 | Daily Position Report - Amounts from Roll Forward
 | Explanation of Difference:
Third Party Accrual
 | General [NAME]
 | 364.20011000 |  | 0
 | Daily Position Report - Amounts from Roll Forward
 | Explanation of Difference:
Credit Reserve
 | General [NAME] |  | [NAME] |  | Total
 | (company/major/sub/sl)
 | Credit Reserves:
Accrual
 | General [NAME] |  | Profit Center |  | Total
 | 967.20011000 |  | 69918
 | Accrual from LTD Rec
 | Explanation of Difference:
Spreadsheet: 878609d1725763012-fixing-time-sheet-timesheet
Sheet: Sheet1

 | Date | Start Time | Finish Time | Hours
 | 2024-06-30 00:00:00
 |  | 10:00:00 | 23:30:00
 |  | 08:00:00 | 16:00:00
 |  | 02:00:00 | 10:00:00
 |  | 05:00:00 | 17:00:00
 |  | 04:30:00 | 17:00:00
 |  | 06:00:00 | 12:00:00
 |  | 03:00:00 | 12:00:00
 |  | 12:00:00 | 23:00:00
 |  | 03:00:00 | 17:00:00
 |  | 06:00:00 | 15:00:00
 |  | 03:00:00 | 17:30:00
 |  | Total Hours
 |  |  |  |  |  |  | Start Time | Finish Time
 | AFTER HOUR WORK |  |  |  |  | After hour timing | 05:00:00 | 17:00:00
 | 2024-07-03 00:00:00
 | 2024-07-05 00:00:00
 | 2024-07-06 00:00:00
 | 2024-07-08 00:00:00
 | 2024-07-09 00:00:00
 | 2024-07-10 00:00:00
 | 2024-07-12 00:00:00
 | 2024-07-12 00:00:00
 |  | Total After Hour Work
Spreadsheet: 734593d1622258934-standard-deviation-question-std-dev
Sheet: std dev

data | z-score
1 |  |  | mean
2 |  |  | std dev
3
4
5
6
7
8
9
10
Spreadsheet: 72cf05f0-a6ac-461d-8570-25e16eaf336a
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
RA1M | Test | RA1M | Alpha-1-Microglobulin, Random, [NAME] | Alpha-1-Microglobulin, Random, U | CTUR/24017: Enzymatic Colorimetric Assay AIMR/24015: Immunonephelometry | [NAME]: Urine |  |  | 5 | mL | Container/Tube: Plastic, 6-mL tube (Supply T465) [NAME]: 5 mL Collection Instructions: 1. Collect a random urine specimen. 2. No preservative. | 1 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | <50 years: <13 mg/g creatinine > or =50 years: <20 mg/g creatinine | Varies; 8 a.m.-4 p.m. | 1 day | 7 days | 1 | 83883 |  |  |  |  | Rochester
RA1M | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 7 days
RA1M | Component | CTUR | Creatinine Concentration, [NAME] | [NAME] | For further information see CTU/8513 Creatinine, [NAME]. | [NAME]: Urine |  |  | 5 | mL | 5 mL from a random urine collection. No preservative.  Send specimen refrigerated in a plastic, 6 mL urine tube.  For further information see #8513 "Creatinine, [NAME]." | 1.0 mL |  | For further information see #8513 "Creatinine, [NAME]." |  |  |  | 1 |  |  |  | Yes | Yes (order CTU)
CTUR | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 30 days
CTUR | Result | CTUR | [NAME] | [NAME] | Numeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | 35674-1 | Creatinine:MCnc:XXX:[NAME]:Qn:
RA1M | Component | AIMR | Alpha-1-Microglobulin, Random, [NAME] | Alpha-1-Microglobulin, Random, U | Only orderable as part of a profile. For further information see #84448 "Alpha-1-Microglobulin, Random, [NAME]." | [NAME]: Urine |  |  | 5 | mL | Only orderable as part of a profile. For further information see #84448 "Alpha-1-Microglobulin, Random, [NAME]." | 4.00 mL |  | Only orderable as part of a profile. For further information see #84448 "Alpha-1-Microglobulin, Random, [NAME]." |  |  |  | 1 | 83883 |  |  | Yes | No
AIMR | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 7 days
AIMR | Result | A1M_U | Alpha-1-Microglobulin, Random, U | Alpha-1-Microglobulin, Random, U | Numeric |  |  |  |  | mg/L |  |  |  |  |  |  |  |  |  | 46723-3 | Alpha-1-Microglobulin:MCnc:Pt:[NAME]:Qn:
AIMR | Result | A1M_R | A1M/Creat Ratio | A1M/Creat Ratio | Numeric |  |  |  |  | mg/g Cr |  |  |  |  |  |  |  |  |  | 48415-4 | Alpha-1-Microglobulin/Creatinine:MCrto:Pt:[NAME]:Qn:
Spreadsheet: 849508d1699961374-match-maybe-to-return-if-cells-exists-with-value-test
Sheet: Sheet1

Test |  |  |  |  | Expected
Order | Part | Desc | Assembly |  | Order | Part | Desc | Assembly
741 | 1234 | PartA |  |  | 741 | 1234 | PartA | 1
852 | 4567 | PartB |  |  | 852 | 4567 | PartB
963 | 1234 | PartA |  |  | 963 | 1234 | PartA | 1
1014 | 4567 | PartB |  |  | 1014 | 4567 | PartB | 1
741 | Assembly | Assembly |  |  | 741 | Assembly | Assembly
963 | Assembly | Assembly |  |  | 963 | Assembly | Assembly
1014 | Assembly | Assembly |  |  | 1014 | Assembly | Assembly
Spreadsheet: 116d57ad-ecea-4533-8a4c-3d893137d01c
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
6202 | 5547 | [NAME] | [NAME] | RSA | 17 | 00:36:53 | 00:00:00 | 01:11:07 | 00:00:00 | 00:19:04 | 1 | 02:07:04
6202 | 33629 | Yolande | [NAME] | RSA | 19 | 00:40:24 | 00:00:00 | 01:12:29 | 00:00:00 | 00:21:19 | 2 | 02:14:13
6202 | 16708 | Daria | Pletikapa | CRO | 18 | 00:41:35 | 00:00:00 | 01:15:43 | 00:00:00 | 00:22:39 | 3 | 02:19:58
6202 | 33503 | Marina | Milković | CRO | 20 | [NAME] | 00:00:00 | 01:19:11 | 00:00:00 | [NAME] | 4 | [NAME]
Spreadsheet: 708362d1607760357-counting-discount-based-on-date-criteria-and-top-3-first-discount_problem
Sheet: EDITED

 |  |  |  |  |  |  |  |  |  | 2021-01-31 00:00:00
 |  |  |  |  |  |  | my expected result |  |  | 2021-03-31 00:00:00
 |  |  | name | date payment |  | name | discount
 |  |  | jhon | 2020-12-04 00:00:00 |  | jhon | 100
 |  |  | [NAME] | 2020-12-05 00:00:00 |  | [NAME] | 100
 |  |  | frans | 2021-01-31 00:00:00 |  | frans | 100
 |  |  | darius | 2021-01-31 00:00:00 |  | darius | 50 |  | over top 3
 |  |  | [NAME] | 2021-02-01 00:00:00 |  | [NAME] | 50 |  | payment between 1/2/2021 till 31/03/2021
 |  |  | joko | 2021-03-31 00:00:00 |  | joko | 50 |  | payment between 1/2/2021 till 31/03/2021
 |  |  | sisca | 2021-04-01 00:00:00 |  | sisca | 0 |  | over date 31/03/2021
 |  |  | [NAME] | 2021-04-02 00:00:00 |  | [NAME] | 0 |  | over date 31/03/2021
Spreadsheet: 152106d1335262037-variable-values-dependant-on-values-in-a-cell-help
Sheet: Direct

Item | Weight | DS | VAT | Sub | Postage | Retail |  | Profit/Loss |  | Postage
Crystal Bible | 300 | 22 |  |  |  | 35 |  |  |  | 0-100g | 1.5
Christening - Bear | 300 | 22 |  |  |  | 35 |  |  |  | 101-250g | 1.9
Christening - Dove/Bible | 100 | 22 |  |  |  | 35 |  |  |  | 251-500g | 2.5
 |  |  |  |  |  |  |  |  |  | 501-750g | 2.75
 |  |  |  |  |  |  |  |  |  | 751-999g | 3.5
 |  |  |  |  |  |  |  |  |  | 1kg+ | 4.25
Spreadsheet: 820722d1678268556-counting-available-beds-in-a-facility-new-sample
Sheet: Tabelle1

 | Room | Sex | Name | Infos | Planning |  | Available Beds
 | 1
 | 2 |  |  |  | 2023/03/10 New Patient |  | Female
 | 2 | f | Mrs. [NAME]
 | 3
 | 3 |  |  |  |  |  | Male
 | 4
 | 4 | m | Mr XY
 | 5 |  |  |  |  |  | Unisex
 | 6
 | 7
 | 7
Spreadsheet: 839449d1691995653-need-de-normalize-the-raw-data-into-many-rows-but-less-column-version-need_denormalize_rawdata_into_duplicate_way-1
Sheet: Input

index | custno | custtype | product_1 | qty_1 | price_1 | product_2 | qty_2 | price_2 | product_3 | qty_3 | price_3 | country_1 | city_1 | location_1 | country_2 | city_2 | location_2 | country_3 | city_3 | location_3 | country_4 | city_4 | location_4
A000001 | 100001 | B | Banana03 | 200 | 5.5 | Apple02 | 140 | 9.6 | Orange01 | 120 | 8.7 | USA | New York | NY221 | UK | London | [NAME] | Japan | Tokyo | TY950
A000002 | 100002 | A | Apple02 | 110 | 9.6 | Banana01 | 70 | 5.8 |  |  |  | Japan | Osaka | OK910 | Deutschland | Berlin | BE312 | Nederland | Amsterdam | [NAME] | France | Paris | PS532
Spreadsheet: 744632d1629361785-converting-aggregate-to-small-formula-does-not-work-small
Sheet: Foglio1

 | DAL | AL
 | 2021-08-12 00:00:00 | 2021-08-17 00:00:00
 | 528650 | /19
 |  | 10 | 2021-08-12 00:00:00
 |  | 10 | 2021-08-17 00:00:00
 |  | 10 | 2021-08-16 00:00:00
 |  | 10 | 2021-08-17 00:00:00
 |  | 10 | 2021-08-17 00:00:00
 |  | 10
 |  | 10
 |  | 10 | 2021-07-15 00:00:00
 |  | 10
 |  | 10 | 2021-08-17 00:00:00
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 | 48550 | /19
 |  | =[NAME])
 |  | 20 | 2021-08-18 00:00:00
 |  | 20
 |  | 20 | 2021-08-17 00:00:00
 |  | 20
 |  | 20
 |  | 20
 |  | 20
 |  | 20 | 2021-08-16 00:00:00
 |  | 20
 |  | 20
 |  | 20
 |  | 20
Spreadsheet: 267465d1380087035-if-formula-with-multiple-values-nicko54
Sheet: Sheet1

Customer ID | Customer Name | PPV | LINEAR PACK | TVOD | Freeloader | Packer | Demander | Spectator | [NAME] | Packer Plus | Utopia
104201 | [NAME] | 0 | 0 | 0
105501 | [NAME] | 4 | 0 | 0
111701 | Wayne | 0 | 4 | 6
120901 | nathan | 0 | 2 | 0
122401 | [NAME] | 0 | 2 | 0
Spreadsheet: 40021d1238318275-month-list-to-return-date-month-sheet
Sheet: Sheet1

 |  |  |  |  |  | 2009-01-01 00:00:00 | OVERDUE
 |  |  |  |  |  | 2009-02-01 00:00:00 | 25
 |  |  |  |  |  | 2009-03-01 00:00:00 | 75
 |  |  |  |  |  | 2009-04-01 00:00:00 | 100
 |  |  |  |  |  | 2009-05-01 00:00:00
 |  |  |  |  |  | 2009-06-01 00:00:00
 |  |  |  |  |  | 2009-07-01 00:00:00
 |  |  |  |  |  | 2009-08-01 00:00:00
 |  |  |  |  |  | 2009-09-01 00:00:00
 |  |  |  |  |  | 2009-10-01 00:00:00
 |  |  |  |  |  | 2009-11-01 00:00:00
 |  |  |  |  |  | 2009-12-01 00:00:00
 |  |  |  |  |  | Select Month | Figure
 |  |  |  |  |  | Mar | Result to show figure
Spreadsheet: 143517d1330449316-standings-auto-sort-problem-nascar2012_pt1_testng
Sheet: Standings

 |  |  |  |  |  |  | Consecutive
 |  | OWNER | TEAM | POINTS | BEHIND |  | Ranking |  | OWNER | TEAM | POINTS
 | 1 | [NAME] |  | 12 |  |  | 12 | 12 | B. Shuler | MJR MOTORSPORTS | 0
 | 2 | Krissy & Mark |  | 11 | 1 |  | 3 | 3 | [NAME] | BUSHBOY RACING | 10
 | 3 | [NAME] |  | 10 | 2 |  | 13 | 12 | [NAME] | STUDENT DRIVER | 0
 | 4 | Rand Hopkins |  | 9 | 3 |  | 14 | 12 | [NAME] | THE WINNER | 0
 | 5 | [NAME] |  | 8 | 4 |  | 15 | 12 | Brad Shuler | [NAME] | 0
 | 6 | Shane Jansen |  | 7 | 5 |  | 8 | 8 | [NAME] | DIRTY BED RACING | 5
 | 7 | [NAME] |  | 6 | 6 |  | 16 | 12 | [NAME] | SKIDMARK | 0
 | 8 | [NAME] |  | 5 | 7 |  | 7 | 7 | [NAME] | CTO RACING | 6
 | 9 | Mikey Jr. |  | 4 | 8 |  | 17 | 12 | [NAME] | RUG RAT RACING | 0
 | 10 | [NAME] |  | 3 | 9 |  | 18 | 12 | [NAME] | WRECKING CREW | 0
 | 11 | [NAME] |  | 2 | 10 |  | 19 | 12 | [NAME] | GHOSTRIDER RACING | 0
 | 12 | B. Shuler |  | 0 | 12 |  | 20 | 12 | Greg Estes | THROTTLED | 0
 |  |  |  |  |  |  | 21 | 12 | [NAME] | I CAN FLY | 0
 |  |  |  |  |  |  | 1 | 1 | [NAME] | BAIL OUT | 12
 |  |  |  |  |  |  | 22 | 12 | [NAME] | IRON CURTIN | 0
 |  |  |  |  |  |  | 23 | 12 | [NAME] | TEAM RED TIDE | 0
 |  |  |  |  |  |  | 24 | 12 | [NAME] | SEPERAC RACING | 0
 |  |  |  |  |  |  | 25 | 12 | [NAME] | WHISKEY TANGO | 0
 |  |  |  |  |  |  | 26 | 12 | [NAME] | HOLY SMOKES | 0
 |  |  |  |  |  |  | 27 | 12 | [NAME] | WILDCAT RACING | 0
 |  |  |  |  |  |  | 2 | 2 | Krissy & Mark | BUDDA BUTTS | 11
 |  |  |  |  |  |  | 28 | 12 | [NAME] | WOLFPACK RACING | 0
 |  |  |  |  |  |  | 29 | 12 | [NAME] | TIN LIZZY | 0
 |  |  |  |  |  |  | 5 | 5 | [NAME] | COUGAR RACING | 8
 |  |  |  |  |  |  | 11 | 11 | [NAME] | FLORIDA'S FOLLY | 2
 |  |  |  |  |  |  | 9 | 9 | Mikey Jr. | DIRTY DIAPER DRIVER | 4
 |  |  |  |  |  |  | 30 | 12 | [NAME] | HOTMOM MOTORSPORTS | 0
 |  |  |  |  |  |  | 10 | 10 | [NAME] | DUMB BLONDE RACING | 3
 |  |  |  |  |  |  | 4 | 4 | Rand Hopkins | CANNONBALL RUN | 9
 |  |  |  |  |  |  | 31 | 12 | [NAME] | LITTLE RASCAL RACING | 0
 |  |  |  |  |  |  | 32 | 12 | [NAME] | SIDEWAYS STIZZ RACING | 0
 |  |  |  |  |  |  | 33 | 12 | [NAME] | MORNINGWOOD MOTORSPORTS | 0
 |  |  |  |  |  |  | 6 | 6 | Shane Jansen | CRASH N BURN | 7
 |  |  |  |  |  |  | 34 | 12 | [NAME] | LIL MISS ATTITUDE | 0
 |  |  |  |  |  |  | 35 | 12 | [NAME] | [NAME] | 0
 |  |  |  |  |  |  | 36 | 12 | Terra Barczak | LOUIS VAROOM | 0
 |  |  |  |  |  |  | 37 | 12 | Traci Curtin | TRIXIE RACING | 0
Spreadsheet: 708019d1607588686-how-can-i-add-alternate-cells-in-a-row-if-the-adjacent-column-meets-a-certain-criteria-book1-3-1-
Sheet: Sheet1

Header 1 | [NAME] | [NAME] | [NAME] | [NAME] | Header 6 | [NAME] | [NAME]
732.56 | frsdf# | 563.18 | frsdf# | 522.34 | frsdf# | 761.25 | frsdf#
349.88 | sfv | 338.66 | sfv | 200 | cash | 100 | cash
727 | fvfev | 341.39 | fvfev | 517.71 | fvfev | 930.77 | fvfev
335.88 | ev | 782.64 | hgfd | 500 | cash | 200 | cash
212.81 | fvfev | 559.81 | fvfev | 768.26 | fvfev | 311.61 | fvfev
1000 | cash | 946.32 | rfv | 619.87 | rfv | 536.9 | rfv
24.93 | efv | 149.2 | efv | 853.56 | efv | 828.88 | efv
872.39 | fg | 1000 | cash | 437.91 | fg | 314.05 | fg
Spreadsheet: 66997d1267644631-excel-2007-table-structured-references-example
Sheet: Report

 |  |  | 1Q11 | 2Q11 | 3Q11 | 4Q11 | FY11 | FY12 | FY13
 | Boston | Revenue
 | Boston | Gross Profit
 | Boston | Opex--CDO
 | Boston | Opex--WWOPS
 | Boston | Opex--CA
 | Boston | Opex--CMO
 | Boston | Opex--Finance
 | Boston | Opex--Operations
 | Boston | Opex--Other
 | Boston | Opex--TOTAL
 | Boston | Contribution Margin  $
 | Boston | Contribution Margin  %
Spreadsheet: 697014d1601088944-count-the-qty-based-on-the-cell-text-value-sample
Sheet: TUESDAY

 |  | TUESDAY
 | NAME | ORDER | QTY | PRICE
 | Name 1 | Menu 3 | 1 | 100
 | Name 2 | Menu 1 | 2 | 100
 | Name 3 | Menu 1 | 3 | 100
 | Name 4 | Menu 1 | 2 | 100
Spreadsheet: lisa_gang__22465__Hanson Scheduling Model_6_4
Sheet: Scheduling

 |  |  |  |  | HANSON PERMANENTE CEMENT
 |  |  |  |  |  | Power Usage Forecast
 | CALIFORNIA SCHEDULING COORDINATION AND
 | ENERGY PURCHASES AND SALES AGREEMENT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Monday: Tuesday Scheduling
 | Day of Scheduling |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tuesday: Wednesday Scheduling
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Wednesday: Thursday Scheduling
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Thursday: Friday & Saturday Scheduling
 | 2002-06-04 00:00:00 | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | HE | Total |  |  |  |  |  |  |  |  | Friday: Sunday and Monday LLH Scheduling
 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 |  |  |  |  |  |  |  |  |  | Friday: Monday HLH
 |  | 24.948 | 24.504 | 23.052 | 23.244 | 23.256 | 26.544 | 29.568 | 26.544 | 25.128 | 24.336 | 22.428 | 23.904 | 23.952 | 23.544 | 22.836 | 23.076 | 25.596 | 28.812 | 30.576 | 29.832 | 26.916 | 26.112 | 26.424 | 26.412 |  |  |  |  |  |  |  |  |  | Holiday
 |  | 31.61023590669259 | 31.61023590669259 | 31.61023590669259 | 31.61023590669259 | 32.36023590669259 | 32.36023590669259 | 32.56023590669258 | 25.50023590669258 | 25.50023590669258 | 25.50023590669258 | 25.50023590669258 | 25.50023590669258 | 13.885 | 13.885 | 14.635 | 13.755 | 14.265 | 14.265 | 31.48023590669258 | 31.48023590669258 | 32.36023590669259 | 32.36023590669259 | 31.61023590669259 | 31.61023590669259
 | Day Ahead Incremental Quantity (Hanson needs to purchase)
 | Day Ahead Decremental Quantity (Hanson needs to sell)
 | Contact Persons
 | EPMI | Telephone |  |  | E-Mail
 | [NAME] | 503/464-3829 |  |  | [EMAIL]
 | [NAME] | 503/464-5053 |  |  | [EMAIL]
 | [NAME] | 503/464-3822 |  |  | [EMAIL]
 | [NAME] | 503/464-3824 |  |  | [EMAIL]
 | [NAME] | [PHONE] |  |  | [EMAIL]
 | Hanson | Telephone |  |  | E-Mail
 | [NAME] Manager | [PHONE] |  |  | [EMAIL]
 | [NAME] Engineer | [PHONE] |  |  | [EMAIL]
 | [NAME]  - VP Operations | [PHONE] |  |  | [EMAIL]
 | [NAME] | [PHONE] |  |  | [EMAIL]
Spreadsheet: 184242d1349192656-advanced-if-function-help-sample-template
Sheet: Sheet1

Portfolio Description | Account Number | Billing Number | Billing Amount | Current Cash Balance |  | Enough Cash for Fees?
Jon A | 111 | 111 | 2 | 3
Jon B | 222 | 111 | 3 | 1
Jon C | 333 | 111 | 4 | 1
Jon D | 444 | 444 | 5 | 7
Jon E | 555 | 555 | 6 | 8
[NAME] | 666 | 666 | 7 | 9
Spreadsheet: 889412d1740177031-help-with-lookup-cells-from-data-put-into-another-cell-with-an-alphabet-letter-book2
Sheet: book2

 | Name: | Por2gal
 | number
 | 2
 | 2T
 | number
 | 2T
 | 2
 | 2 | 07:15:00 | 08:50:00 |  | 14:45:00 | 16:45:00 | G37 and [NAME] with any number '2' placed in cells B8, B14,B20,B26,B32
 | 0002T | 07:00:00 | 08:50:00 |  | 14:30:00 | 16:15:00 | G38 and H38 Highlights with any number '2T' placed in cells B8, B14,B20,B26,B32
 | D37 and [NAME] with any number '2' placed in cells B7,B13,B19,B25,B31
 | D38 and [NAME] with any number '2T' placed in cells B7,B13,B19,B25,B31
Spreadsheet: 583753d1532623864-maximization-problem-excel-help
Sheet: Blank

Rotational ETF Ranking - MONTH DAY YEAR  BT (Trade Day MONTH DAY)
ETF | 15D Return | 15D Volatility | 30D Return | 30D Volatility | Combined Rank | 90D Return | 90D Volatility | 180D Return | 180D Volatility |  | 15D [NAME] | 30D Ratio | 90D [NAME] | 180D [NAME] | Logical [NAME] |  | Jan 4th | Bought
ACWV |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
AOA |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
AOM |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
AOR
BNDX
CMF |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Started | 10000
CVY |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ended
CWB
DLS
EFG
EMLC
EWC
FENY
FHLC
FLRN
FNDF
FREL
GMF
GVI
GXC
HYEM
HYMB
IBDL
IBMG
IEFA
IEMG
IEUR
IJH
ILF
ILTB
INDA
IPAC
IPE
ITE
IVOV
IWP
IYF
MGV
MNA
MUB
NFRA
NYF
PBP
PFXF
PWZ
QAI
SCHC
SCJ
SGDM
SHYG
SLQD
SLV
SNLN
VAW
VB
VCR
VGT
VIOG
VIOV
VIS
VNQI
VOX
VPU
VTEB
VTI
VUG
XLP
YYY
RFR
Spreadsheet: 697870d1601575930-calculating-overtime-past-40-hours-work-hours-and-cost-estimate
Sheet: Work Hours and Cost Estimate

People per Shift | 10
Total Man hours | 4000
Regular Rate | 75
OT Rate | 140
Scenario | Hours | RP | Total Hours | OT Factor | OT Hours |  | Calc | Number of Hours | Number of Days | Regular Rate Cost | OT Rate Cost | [NAME] | Total Cost
8x5 | 8 | 5 |  | 0
8x5+Sat | 8 | 6 |  | 8
8x5+Sat/Sun | 8 | 7 |  | 16
10x5 | 10 | 5 |  | 10
10x5+Sat | 10 | 6 |  | 20
10x5+Sat/Sun | 10 | 7 |  | 30
12x5 | 12 | 5 |  | 20
12x5+Sat | 12 | 6 |  | 32
12x5+Sat/Sun | 12 | 7 |  | 44
16x5 CON | 16 | 5
16x6 Sat CON | 16 | 6
16x7 Sun CON | 16 | 7
20x5 CON | 20 | 5
20x6 CON | 20 | 6
24x5 CON | 24 | 5
24x6 CON | 24 | 6
 | Need to add overtime hours after regular dayshift
 | 5/6/7 day option 16 hours for sat/sun
Spreadsheet: 792986d1661252077-formulas-to-create-table-via-match-help-07-ans
Sheet: Sheet1

 | COACHING STAGE |  |  |  |  | Site Wide | Gantry | Roof | SGA1 | Infra | Core
 | Team | Assigned Coach | Date assigned |  |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
 | SGA1 |  |  |  |  | benny | benny | PETER | [NAME] | benny | benny
 | Infra |  |  |  |  |  | HELI | ALEX | benny | Cute | Bye
 |  |  |  |  |  |  |  | benny |  |  | Thailand
 | After select Column B dropdown
 | Column C dropdown will base on column b selection to select coach
Spreadsheet: 880606d1728411492-automated-calendar-with-changing-holidays-vakantie-template-mbv-cadix_2
Sheet: juli

 | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Opgenomen vakantie | Resterende vakantie
 |  |  | 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
 | Maxime
VPK | [NAME]
 | Cédric
 | Elke
 | Ellen
 | Els
 | Gert
 | Ief
 | [NAME]
 | Joeri
 | [NAME]
 | Kelly
 | [NAME]
 | [NAME]
 | Michel
 | Mirthe
 | Nadia
 | Neslihan
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | Aanwezig | 1
 | ADV | A
 | Vakantie | V
 | Ziek | Z
ZK | Annelies
 | Herly
 | Nadia
 | Nele
 | Ranka
 | Sid
 | Aanwezig | 1
 | ADV | A
 | Vakantie | V
 | Ziek | Z
[NAME] | [NAME]
 | [NAME]
 | Hilde
 | Samira
 | Vicky
 | Tyra
 | Aanwezig | 1
 | ADV | A
 | Vakantie | V
 | Ziek | Z