tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 98533d1297386639-average-columns-across-multiple-sheets-compare
Sheet: Sheet2

A7 | 5788 | [NAME]
27 | 5798 | ONG CHOON ANN |  | CRLIMT | LMS Day Buy | LMS Day Sell | [NAME] | LMS Nite Sell
LJ | 6283 | TAN TECK LOON |  |  | Credit Limit | Credit Limit | Credit Limit | Credit Limit
TE | 6345 | TAN YEW LEE |  | 500006 | 1000006 | 1500006 | 50000 | 75000
J5 | 26022 | MOK KIAT JOO |  | 20007 | 170076 | 255076 | 20007 | 30007
1B | 29839 | TANG YENG FATT  OR TAN PEH | SUAN | 20000 | 100006 | 150006 | 100006 | 150006
C2 | 30622 | CHUA CHENG KONG |  | 50026 | 26 | 26 | 26 | 26
4B | 33341 | SUHONTO NGATIMIN |  | 400000 | 300006 | 450006 | 20000 | 30000
KW | 33643 | YEO CHOR MENG |  | 1000006 | 200006 | 300006 | 100006 | 150006
71 | 46128 | LEOW [NAME] |  | 700006 | 100006 | 150006 | 200006 | 300006
YQ | 46891 | HO WING CHUEN |  | 100006 | 200006 | 300006 | 100006 | 150006
76 | 48743 | TANG TZE TOH JAMES |  | 20000 | 300006 | 450006 | 168 | 168
7M | 49593 | KOK [NAME] MEI REGINA |  | 20026 | 50026 | 75026 | 26 | 26
HX | 56803 | TAN GRACEA STELLA SUTANTO |  | 300006 | 20000 | 30000 | 20000 | 30000
HX | 56805 | LIEM ING TJAY |  | 60000 | 20000 | 30000 | 200006 | 300006
J5 | 2973 | VIJEYACONE ARIYACONE | @ VIJEYARETNAM
HX | 56810 | [NAME] |  | 50000 | 200006 | 300006 | 20000 | 30000
HX | 56818 | CHEW CHONG TONG |  | 100006 | 150006 | 225006 | 50006 | 75006
HX | 56856 | CHIA CHIOW SOON |  | 500006 | 20000 | 30000 | 500006 | 750006
5Y | 62625 | WU TENG SIONG |  | 1000006 | 20000 | 30000 | 600006 | 900006
3A | 77527 | YEOMAN CAPITAL MANAGEMENT | PTE LTD | 1000006 | 20000 | 30000 | 1000006 | 1500006
RE | 102709 | NG CHEOW BOO |  | 1000006 | 20000 | 30000 | 1000006 | 1500006
RE | 102745 | CHAN HAN CHONG |  | 250006 | 20000 | 30000 | 100006 | 150006
W4 | 111049 | CHOW KONG HOE JEFFREY | ([NAME] GUANGHAO JEFFREY) | 1000006 | 100000 | 150000 | 1500006 | 2250006
6U | 111090 | GOH WUI JIET | (WU WEIJIE) | 1000006 | 100000 | 150000 | 500006 | 750006
KD | 111746 | LIM BOON HOWE EDWIN |  | 1000006 | 100000 | 150000 | 500006 | 750006
KD | 111762 | FONG SEH MOI |  | 250006 | 100006 | 150006 | 250006 | 375006
Spreadsheet: 294075d1391184587-aggregate-score-sheet-for-golf-test-sheet
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  | top |  | 5
SATURDAY CROWD Aggregate Scores |  |  |  |  |  |  |  |  |  |  |  |  |  | hurdle
 |  |  |  |  |  |  |  |  |  |  |  |  |  | count |  | 40
 | This weeks scores | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rank | Top Score | Top Player
[NAME] |  | 28 | 28 | 0 | 28 | 0
[NAME] |  | 0 | 0 | 23 | 0 | 0
[NAME] |  | 32 | 32 | 34 | 32 | 35
Churchy |  | 36 | 36 | 32 | 36 | 0
[NAME] |  | 0 | 0 | 26 | 0 | 34
[NAME] |  | 0 | 0 | 0 | 0 | 0
[NAME] |  | 37 | 37 | 37 | 37 | 38
[NAME]. |  | 0 | 0 | 0 | 0 | 0
[NAME] |  | 0 | 0 | 0 | 0 | 0
[NAME] |  | 32 | 32 | 34 | 32 | 32
[NAME] |  | 31 | 31 | 0 | 31 | 0
[NAME] |  | 35 | 35 | 33 | 35 | 33
[NAME] |  | 0 | 0 | 0 | 0 | 0
[NAME] |  | 31 | 31 | 34 | 31 | 36
[NAME] |  | 30 | 30 | 30 | 30 | 34
[NAME] |  | 33 | 33 | 36 | 33 | 0
[NAME] |  | 0 | 0 | 28 | 0 | 0
Les |  | 39 | 39 | 37 | 39 | 33
[NAME] |  | 0 | 0 | 0 | 0 | 0
[NAME] |  | 29 | 29 | 33 | 29 | 35
[NAME] |  | 0 | 0 | 0 | 0 | 0
[NAME] |  | 35 | 35 | 28 | 35 | 34
[NAME] |  | 0 | 0 | 0 | 0 | 0
[NAME] |  | 0 | 0 | 0 | 0 | 0
[NAME] |  | 0 | 0 | 0 | 0 | 0
[NAME] (B) |  | 0 | 0 | 30 | 0 | 0
[NAME] |  | 33 | 33 | 39 | 33 | 27
[NAME]. |  | 0 | 0 | 21 | 0 | 0
[NAME] |  | 0 | 0 | 0 | 0 | 0
[NAME] |  | 29 | 29 | 29 | 29 | 33
[NAME] |  | 0 | 0 | 0 | 0 | 0
[NAME] |  | 35 | 35 | 30 | 35 | 40
[NAME] |  | 31 | 31 | 34 | 31 | 31
[NAME] |  | 0 | 0 | 0 | 0 | 0
[NAME] |  | 33 | 33 | 35 | 33 | 34
[NAME] |  | 29 | 29 | 32 | 29 | 30
Wayman |  | 36 | 36 | 0 | 36 | 34
Spreadsheet: 005a6c98-2c90-45b8-b38c-4173174c1017
Sheet: Sheet1

Grant Personnel Overtime Activity Report | 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 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23 | Unnamed: 24 | Unnamed: 25 | Unnamed: 26 | Unnamed: 27 | Unnamed: 28 | Unnamed: 29 | Unnamed: 30 | Unnamed: 31 | Unnamed: 32 | Unnamed: 33
INSTRUCTIONS:  Enter hours worked in hourly increments.  Enter total overtime worked for each day in the appropriate column.  For all OT hours worked, enter the description of work activity.   By signing the Grant Personnel Activity Report, you are certifying the report to be correct.
Agency Name: |  |  |  |  |  | Employee Name: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Month / Year:
 |  | Grant # |  |  |  |  |  |  | Grant Period |  |  |  |  |  |  |  |  |  | Overtime Amount |  |  |  |  |  |  |  | Overtime Remaining
Grant # | Description of Work Activity | Day of the Month
 |  | 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 | Total
 | Total
 |  |  |  | If the employee is (ABTPA) grant-funded, the [NAME] should check this box and sign below to also certify that the employee worked solely on the ABTPA grant for the period covered above.
 | Employee / Volunteer Signature |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Supervisor Signature
 |  | Certified Correct |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Certified Correct
Spreadsheet: 709a83a9-5988-46a7-b4cf-6a6aa757e816
Sheet: 2015-2016

2015-2016 Class Schedule |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | You may select up to three classroom attributes.  Select only course requirements, as the number of available classrooms will be reduced with each attribute selected.
Biology
Spring 2016
Subject | Course and Title | Subtitle/Alternate Title | Days | Times | Sec | Part of Term | Credits | Hamline Plan | Instructor(s) | Instructor ID | FT or Adj | [NAME] | Registration Approval Required? | [NAME] | Seats to be Saved | Saved Seats Type | Campus: [NAME], [NAME], Online, Blended |  |  |  | Cross list? SUBJ CRSE SEC | XLST total enrl | Areas of Study | Comments
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Classroom Attribute A | Classroom Attribute B | Classroom Attribute C
Spreadsheet: 132573d1323821321-pdf-text-to-excel-spreadsheet-travelleisure
Sheet: Page_9

 |  |  |  | Media Outlet Results
Outlet Name | Outlet City | Outlet State | Outlet Type  Outlet Website |  |  | Outlet E-mail |  | Outlet Phone Number Outlet Circulation Keyword Outlet Source  AudienceRelevance
HSMAI | McLean | VA | [NAME] |  | http://www.h |  |  | (703) 506-3280 | 9,000 | 40 | S
Marketing |  |  | zine, |  | smai.org/res
Review |  |  | trade/ |  | ources/revie
 |  |  | indust |  | w.cfm
 |  |  | ry
Lodging Law | Washington | DC | [NAME] |  | [NAME] |  |  | (202) 289-3100 | 9,000 | 43 | S
 |  |  | zine, |  | hla.com
 |  |  | trade/
 |  |  | indust
 |  |  | ry
Southern | Tallahassee | FL | [NAME] |  | http://www.s | editor@sout |  | (850) 386-7401 | 8,650 | 43 | S
Hospitality |  |  | zine, |  | outhernhosp | hernhospital
Magazine - |  |  | trade/ |  | italitymagazi | itymagazine
Professional |  |  | indust |  | [NAME] | .com
 |  |  | ry |  | essional.ht
 |  |  |  |  | ml
Convention | [NAME] | FL | [NAME] |  | http://www.c | editor@con |  | (877) 494-7323 | 8,000 | 30 | S
Forum |  |  | zine, |  | onventionfor | ventionforu
 |  |  | trade/ |  | um.com/ | m.com
 |  |  | indust
 |  |  | ry
HSMAI Update | McLean | VA | [NAME] |  | http://www.h |  |  | (703) 506-3280 | 7,000 | 23 | S
 |  |  | zine, |  | smai.org/
 |  |  | trade/
 |  |  | indust
 |  |  | ry
Resort Trades' | Crossville | TN | [NAME] |  | http://www.r |  |  | (931) 484-8819 | 6,371 | 52 | S
Management & |  |  | zine, |  | esorttrades.
Operations |  |  | trade/ |  | com/
 |  |  | indust
 |  |  | ry
[NAME] | Raleigh | NC | [NAME] |  | http://www.n |  |  | (919) 844-0098 | 6,250 | 34 | S
 |  |  | zine, |  | crla.biz/
 |  |  | trade/
 |  |  | indust
 |  |  | ry
Page: 9 |  |  |  |  |  |  |  |  |  |  | 12/13/2011
Spreadsheet: 755676d1637024915-points-for-multiple-choice-questions-book1
Sheet: Sheet1

 | True | False | Checked | Points
1 | abc | de | abc
2 | abc | de | ab
3 | abc | de | abcd
4 | abc | de | bcd
5 | abc | de | cde
5 | abc | de | de
Spreadsheet: andy_zipper__177__DYNEGY-ICE VOL Apr25
Sheet: ICE-ENA

Enron North America
Activity on ICE
UOM | Deals | Volume
MMBtus
bbl
 |  |  |  |  |  |  | START | END
Enron North America Corp.
Commodity Type:  All
Instruments:  All
Trade Dates:  Apr-25-01 thru Apr-25-01
Trade Date | Deal ID | Leg ID | B/S | Product | Hub | Strip | START | END | Option | Strike | Style | Counterparty | Price | Price Units | Qty Per Period | Periods | Total Quantity | Qty Units | Trader
Apr-25-01 | 644266825 |  | Sold | Gasoline Crack | USGC Conv Unl 87/WTI 1st line swap | 2001-05-01 00:00:00 | May-01-01 | May-31-01 |  |  |  | Valero Marketing & Supply Co. | 10.1 | USD / bbl | 50000 | Monthly | 50000 | bbl | Gagliardi, L
Apr-25-01 | 164456283 |  | Sold | NG Fin, FP for LD1 | [NAME] | [NAME] | May-01-01 | Oct-31-01 |  |  |  | Bank of America, N.A. | 5.1 | USD / MMBtu | 2500 | Daily | 460000 | MMBtus | [NAME], J
Apr-25-01  Deals
Spreadsheet: 210254d1359409234-how-to-lookup-multiple-rows-from-a-table-help-me
Sheet: Needs to be Done

 | S | T | U | V | W | X | Y | Z | 4
 |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 | 0 | #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
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 147104d1332526144-value-with-dget-figuring-out-dget
Sheet: Rate

Vendor | Classification |  | ST Rate | OT Rate
Vendor A | Assistant | Vendor A Assistant | 50 | 75
Vendor A | Safety | Vendor A Safety | 50 | 75
Vendor B | Roustabout | Vendor B Roustabout | 70 | 105
Vendor B | Electrician | Vendor B Electrician | 65 | 90
Vendor B | Apprentice | Vendor B Apprentice | 80 | 120
Vendor B | Supervisor | Vendor B Supervisor | 90 | 150
Spreadsheet: 798691d1664644347-sum-values-according-to-dates-dates
Sheet: Sheet1

Name | Value | Start Date | Qt of Payments | End Date | Payment |  | \ | Year
A | 949 | 2022-09-01 00:00:00 | 6 |  |  |  | Month |  | Value
B | 346.91 | 2022-03-01 00:00:00 | 7 |  |  |  | 1
C | 12250 | 2022-03-01 00:00:00 | 25 |  |  |  | 2
D | 1000 | 2022-03-02 00:00:00 | 4 |  |  |  | 3
E | 5000 | 2022-03-03 00:00:00 | 2 |  |  |  | 4
F | 15700 | 2022-03-04 00:00:00 | 8 |  |  |  | 5
 |  |  |  |  |  |  | 6
 |  |  |  |  |  |  | 7
 |  |  |  |  |  |  | 8
 |  |  |  |  |  |  | 9
 |  |  |  |  |  |  | 10
 |  |  |  |  |  |  | 11
 |  |  |  |  |  |  | 12
Spreadsheet: 298475d1392816584-creating-a-data-entry-form-tournament-entry-log
Sheet: Max Team per age grp

 |  | Entered | Available | Approved | Unapproved
 | Under 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Under 6 | 12
 | Under 7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Under 7 | 18
 | Under 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Under 8 | 18
 | Under 9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Under 9 | 20
 | Under 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Under 10 | 20
 | Under 11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Under 11 | 20
 | Under 12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Under 12 | 20
 | Under 13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Under 13 | 20
 | Under 14 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Under 14 | 20
Approved Y/N | Age Group | Club Name | FA Charter No. | Club Secretary | Affiliation No. | Team Name | Manager [NAME] | Address line 1 | Address line 2 | Address line 3 | Address line 4 | Post Code | Contact No | e-mail address | Paid Y/N | Account Name on Cheque | Chq No.
Spreadsheet: 43399d1242071353-format-of-cells-from-database-test2
Sheet: Sheet1

 |  |  |  |  |  |  | 0038
 |  |  |  |  |  |  | 0003
 |  |  |  |  |  |  | 0006
 |  |  |  |  |  |  | 0003
 |  |  |  |  |  |  | N/A
 |  |  |  |  |  |  | N/A
 |  |  |  |  |  |  | 0016
 |  |  |  |  |  |  | 0007
 |  |  |  |  |  |  | N/A
 |  |  |  |  |  |  | 0004
 |  |  |  |  |  |  | 0005
 |  |  |  |  |  |  | 0006
 |  |  |  |  |  |  | 0002
 |  |  |  |  |  |  | 0003
 |  |  |  |  |  |  | 0027
 |  |  |  |  |  |  | N/A
 |  |  |  |  |  |  | N/A
 |  |  |  |  |  |  | N/A
 |  |  |  |  |  |  | N/A
 |  |  |  |  |  |  | N/A
 |  |  |  |  |  |  | N/A
 |  |  |  |  |  |  | N/A
 |  |  |  |  |  |  | N/A
 |  |  |  |  |  |  | 0002
 |  |  |  |  |  |  | N/A
 |  |  |  |  |  |  | 0009
 |  |  |  |  |  |  | N/A
 |  |  |  |  |  |  | N/A
Spreadsheet: 271692d1382022660-drawing-information-from-multiple-worksheets-to-generate-a-summary-report-sample-data
Sheet: Name2

Name: | [NAME]
Rec | Input Date | Workstream | Projects | Internal Requests | External Requests | CPCMEC Tasking | Management | Tasks | Priority | Comments | Task Progress (%) | Upcoming DD | Concluded
4 | 2013-10-01 00:00:00 | Projects | Project2 |  |  |  |  | Review Paper | Low |  | 100 | 2013-10-31 00:00:00 | 2013-10-10 00:00:00
5 | 2013-10-05 00:00:00 | External Request |  |  | Stats |  |  | Generate spreadsheet | Medium |  | 50 | 2013-10-31 00:00:00
Spreadsheet: 810207d1671602188-convert-horizontal-table-to-vertical-table-form-conversion
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  | Result |  |  |  | [NAME]
A | Bangkok | 0.05 | Phuket | 0.06 | Nakhon Sawan | 0.07 |  |  |  |  | A | Bangkok | 0.05 |  |  | Bangkok | 0.05
B | [NAME] | 0.07 | Ayutthaya | 0.04 |  |  |  |  |  |  | A | Phuket | 0.06 |  | A | Phuket | 0.06
C | Pattaya | 0.03 | [NAME] | 0.1 | [NAME] | 0.09 | Pattani | 0.07 |  |  | A | Nakhon Sawan | 0.07 |  | A | Nakhon Sawan | 0.07
D | Rayong | 0.02 |  |  |  |  |  |  |  |  | B | [NAME] | 0.07 |  | B | [NAME] | 0.07
 |  |  |  |  |  |  |  |  |  |  | B | Ayutthaya | 0.04 |  | B | Ayutthaya | 0.04
 |  |  |  |  |  |  |  |  |  |  | C | Pattaya | 0.03 |  | C | Pattaya | 0.03
 |  |  |  |  |  |  |  |  |  |  | C | [NAME] | 0.1 |  | C | [NAME] | 0.1
 |  |  |  |  |  |  |  |  |  |  | C | [NAME] | 0.09 |  | C | [NAME] | 0.09
 |  |  |  |  |  |  |  |  |  |  | C | Pattani | 0.07 |  | C | Pattani | 0.07
 |  |  |  |  |  |  |  |  |  |  | D | Rayong | 0.02 |  | D | Rayong | 0.02
Spreadsheet: 271707d1382025177-if-function-for-a-wrap-time-sheet-wrap-time-sheet
Sheet: Raw Data

 | JANUARY
Agents | Performance | % | [NAME] | Value | Rank | Comcast CE | Value | Rank | HP | Value | Rank | NCP | Value | Rank
[NAME] |  |  | 00:01:00 |  |  | 00:04:00
Daine |  |  | 00:02:00 |  |  | 00:00:01
Sheldon |  |  | 00:00:30
Prass |  |  | 03:00:45
[NAME] |  |  | 04:00:45
 |  |  | 05:00:45
 |  |  | 06:00:45
 |  |  | 07:00:45
 |  |  | 08:00:45
 |  |  | 09:00:45
 |  |  | 10:00:45
 |  |  | 11:00:45
 |  |  | 12:00:45
 |  |  | 13:00:45
 |  |  | 14:00:45
 |  |  | 15:00:45
 |  |  | 16:00:45
 |  |  | 17:00:45
 |  |  | 18:00:45
 |  |  | 19:00:45
 |  |  | 20:00:45
 |  |  | 21:00:45
 |  |  | 22:00:45
 |  |  | 23:00:45
 |  |  | 1900-01-01 00:00:45
 |  |  | 1900-01-01 01:00:45
 |  |  | 1900-01-01 02:00:45
 |  |  | 1900-01-01 03:00:45
 |  |  | 1900-01-01 04:00:45
 |  |  | 1900-01-01 05:00:45
 |  |  | 1900-01-01 06:00:45
 |  |  | 1900-01-01 07:00:45
 |  |  | 1900-01-01 08:00:45
 |  |  | 1900-01-01 09:00:45
 |  |  | 1900-01-01 10:00:45
Spreadsheet: 585645d1533887528-help-with-solver-inputs-wall-design-hydr-
Sheet: 1. General Variables

Geometry |  |  | Parameters |  |  | Material Rates
Group Number | 7 |  | [NAME] | 1.2 | m | [NAME] (incl. GST) |  | $/m3
H |  | m
0.4H |  | m |  |  |  | Concrete Rate (incl. GST) | 475 | $/m3
Post Length |  | m
Acoustic Barrier Height |  | m |  |  |  | Steel Post Rate (incl. GST) | 4180 | $[NAME]
Acoustic Barrier Length | 1200 | m |  |  |  | Steel Post Misc Items Rate  (incl. GST) | 0.05 | % Steel Post Cost
[NAME] | 0.3 | m |  |  |  | Girt and Components Supply Rate | 0.5 | % Girt and Components Cost
[NAME] | 0.3 | m
[NAME] | 0.3 | m3
[NAME]
Spreadsheet: 200146d1355427973-excel-highlighting-cells-rotaexample
Sheet: Wednesday

Employee | 07:00:00 | 07:30:00 | 08:00:00 | 08:30:00 | 09:00:00 | 09:30:00 | 10:00:00 | 10:30:00 | 11:00:00 | 11:30:00 | 12:00:00 | 12:30:00 | 13:00:00 | 13:30:00 | 14:00:00 | 14:30:00 | 15:00:00 | 15:30:00 | 16:00:00 | 16:30:00 | 17:00:00 | 17:30:00 | 18:00:00 | 18:30:00 | 19:00:00 | 19:30:00 | 20:00:00 | 20:30:00 | 21:00:00 | 21:30:00 | 22:00:00 | 22:30:00
Staff 1
Staff 2 |  |  |  |  | Start |  |  |  |  |  |  |  |  |  |  |  |  | Finish
Staff 3 | Start |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Finish
Staff 4 | Start |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Finish
Staff 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Start |  |  |  |  |  |  |  |  | Finish
Staff 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Start |  |  |  |  |  |  |  |  |  |  | Finish
Staff 7 |  |  |  |  |  |  |  |  |  |  |  |  | Start |  |  |  |  |  |  | Finish
Staff 8
Staff 9
Spreadsheet: 871144d1717571479-struggling-with-multiple-dependent-drop-downs-cambridge-fireworks-stock-and-display-sheet-24-25
Sheet: FT

Firework Type | < Sorted with spaces removed
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Cake
Candle
Candle
Candle
Candle
Candle
Candle
Candle
Candle
Candle
Candle
Candle
Candle
Candle
Candle
Candle
Candle
Candle
Candle
Candle
Candle
Candle
Candle
Candle
Candle
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Flashpot
Fountain
Fountain
Fountain
Ignitor
Mine
Shell
Shell
Shell
Shell
Shell
Shell
Shell
Shell
Shell
Shell
Shell
Shell
Shell
Shell
Shell
Shell
Shell
Shell
Shell
Shell
Shell
Shell
Shell
Shell
Shell
Shell
Shell
Shell
Shell
Shell
Shell
Shell
Shell
Shell
Shell
Shell
Shell
Shell
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Strobe
Strobe
Spreadsheet: 817744d1676424298-calculating-payment-due-dates-automatically-subscription-tracker-1-
Sheet: Interface

 | Service details |  |  | Billing period |  |  |  |  |  | Context
 | Subscription | Date commenced | Payment Next Due | QTY | Unit |  |  |  |  | 1 | The date as of me creating this is 14 Feb 23.
 | Spotify | 2019-12-18 00:00:00 |  | 12 | m |  |  |  |  | 2 | The cells that are highlighted orange are user input. (Column B, C, E, F)
 | ExpressVPN | 2022-04-19 00:00:00 |  | 3 | m |  |  |  |  | 3 | The cells that are white with orange text are automatic calculations. (Column D)
 | Hulu | 2021-07-21 00:00:00 |  | 1 | m |  |  |  |  | 4 | Column D (Payment Next Due) needs to update every time the previous due date has passed.
 | [NAME] | 2023-01-29 00:00:00 |  | 1 | w |  |  |  |  | 5 | Cell [NAME] is left blank to provide space for solution.
 | Amazon Prime | 2023-02-11 00:00:00 |  | 1 | d |  |  |  |  | 6 | Problem: How do I create the auto-calculations for column D? Thank you for your time.
 | MasterClass | 2023-02-12 00:00:00 |  | 2 | d
 | Tidal | 2023-02-13 00:00:00 |  | 3 | d
 | Apple Music | 2021-11-09 00:00:00 |  | 12 | m
 | HubSpot | 2022-08-16 00:00:00 |  | 1 | m
 | Zenefits | 2020-07-22 00:00:00 |  | 1 | m
 | Disney+ | 2023-01-06 00:00:00 |  | 1 | w
 | Audible | 2022-04-26 00:00:00 |  | 1 | d
 | GrandBox | 2021-11-11 00:00:00 |  | 3 | m
 | Kindle Direct | 2021-02-11 00:00:00 |  | 3 | m
 | Netflix | 2022-01-09 00:00:00 |  | 12 | m
 | [NAME] | 2022-05-26 00:00:00 |  | 1 | m
Spreadsheet: 175926d1345669749-if-not-if-vlookup-holiday
Sheet: Employee Data

Employee | Start | End | total days
[NAME] | 2012-01-03 00:00:00 | 2012-01-07 00:00:00
[NAME] | 2012-01-06 00:00:00 | 2012-01-09 00:00:00
Stephen | 2012-01-09 00:00:00 | 2012-01-12 00:00:00
Walter | 2012-02-02 00:00:00 | 2012-02-10 00:00:00
[NAME] | 2012-01-17 00:00:00 | 2012-01-24 00:00:00
[NAME] | 2012-02-04 00:00:00 | 2012-02-07 00:00:00
Spreadsheet: drew_fossum__8680__midam_oba
Sheet: Sheet1

 | Midamerican's Northern Natural OBA calculation for Cedar Rapids and Quad Cities
 |  |  |  |  |  |  |  |  |  |  |  | Applicable
 |  |  |  |  |  |  | Imbalances |  |  |  |  | Cash out Tier
 |  |  |  |  |  |  | over  the |  |  |  |  | T1 <+/-20k@100% |  | Daily | Daily Valuation
 |  |  |  |  |  |  | Daily Threshold |  | [NAME] used | [NAME] |  | T2  +/-20 to 40k@90%/110% |  | Valuation | for Daily Imb
 |  |  |  |  |  | Daily | (not included in | Cummulative | to calculate | Gas |  | T3  >+/-40k@80%/120% |  | for Monthly | above
 |  |  | Day | Nomination | Actual | Imbalance | monthly cum. | Imbalance | monthly excess | Daily | 100% | 90%/110% | 80%/120% | Excess | Threshold
 |  |  | 1 | 30000 | 50000 |  |  |  |  | 4
 |  |  | 2 | 25000 | 45000 |  |  |  |  | 4.1
 |  |  |  | 32000 | 49000
 |  |  |  | 28000 | 45000
 |  |  |  | 25000 | 44000
 |  |  |  | 22000 | 38000
 |  |  |  | 27000 | 41000
 | Day w/ Imb > 20,000 |  |  | 24000 | 50000 |  | -4800
 |  |  |  | 23400 | 38000
 | Day w/ Imb > 20,000 |  |  | 22800 | 48000
 |  |  |  | 22200 | 40000
 |  |  |  | 21600 | 35000
 |  |  |  | 21000 | 36000
 |  |  |  | 20400 | 37000
 |  |  |  | 25000 | 38000
 |  |  |  | 27000 | 39000
 |  |  |  | 31000 | 50000
 | Balance Day |  |  | 34000 | 41000
 |  |  |  | 29000 | 41000
 |  |  |  | 30000 | 40000
 |  |  |  | 31000 | 48000
 |  |  |  | 26000 | 41000
 |  |  |  | 25000 | 35000
 | Balance Day |  |  | 32000 | 36000
 |  |  |  | 33000 | 51000
 |  |  |  | 28000 | 47000
 |  |  |  | 25000 | 44000
 | [NAME] |  |  | 28000 | 48000 |  |  |  | 14040 |  | 14040
 |  |  |  | 32000 | 16000 |  |  |  | 0 |  | 0
 | [NAME] |  |  | 34000 | 52000 |  |  |  | 18000 |  | 5960
 | [NAME] |  |  | 35000 | 54000 |  |  |  | 19000 |  | 0
 |  |  |  |  |  |  |  |  |  |  | MIP | 4.3
 | MIP Price |  | 4.3 | (example price) |  |  |  |  |  |  | (example only)
 | MIP Price is calculated per Tariff as of Aug. 31 2000
 | Imbalances over daily threshold allow for 5% tolerance of nominations.
 | Imbalances over daily thresholds at Daily Price.
 | Imbalances over daily thresholds not in monthly threshold.
 |  |  |  |  |  |  |  | Monthly Charges |  |  |  |  |  | Total Imbalance
 |  |  |  |  |  |  |  | (not including transportation) |  | Price |  |  |  | charges
 |  |  |  |  |  |  |  | Monthly excess
 |  |  |  |  |  |  |  | Daily execess
 |  |  |  |  |  |  |  | MIP imbalance | -400000
 |  |  |  |  |  |  |  | Total Monthly Imbalance
Spreadsheet: 144147d1330724206-pivot-table-help-pivot-table-help
Sheet: PIVOT

 | a SHEET 1 | a SHEET 2 | b SHEET 1 | b SHEET 2 | c SHEET 1 | c SHEET 2 | d SHEET 1 | d SHEET 2 | e SHEET 1 | e SHEET 2
1 | X | X | X | X | X | X | X | X
2 | X | X | X | X | X | X | X | X
3 | X | X | X | X |  | X
4 | X | X | X | X | X | X
5 | X | X | X | X | X | X
6 | X | X | X | X | X | X | X | X
7 | X | X |  | X
8 | X | X | X | X | X | X |  | X
9 |  | X |  | X |  | X