tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 284d34fb-5d77-468f-8be3-22951b7e5951
Sheet: Sheet1

As of 25-Oct-12 | Casting subject to change. | Unnamed: 2 | Unnamed: 3
 | Fri | Sat Mat | [NAME]
 | 2012-11-02 00:00:00 | 2012-11-03 00:00:00 | 2012-11-03 00:00:00
 | 19:30:00 | 14:00:00 | 19:30:00
ARMS THAT WORK
 | IMLER | IMLER | IMLER
 | NAKAMURA | NAKAMURA | NAKAMURA
 | GENEROSA | GENEROSA | GENEROSA
 | O'CONNOR | O'CONNOR | O'CONNOR
 | ANSPACH | ANSPACH | ANSPACH
 | PASCH | PASCH | PASCH
 | MOORE | MOORE | MOORE
 | THOMSON | THOMSON | THOMSON
 | PORRETTA | PORRETTA | PORRETTA
Pause
LOST IN LIGHT
 | KORBES | KORBES | KORBES
 | CRUZ | CRUZ | CRUZ
 | [NAME] | [NAME] | [NAME]
 | [NAME] | [NAME] | [NAME]
 | SAMUELSON | SAMUELSON | SAMUELSON
 | GAINES | GAINES | GAINES
 | [NAME] | [NAME] | [NAME]
 | LIN-YEE | LIN-YEE | LIN-YEE
 | REID | REID | REID
 | GRIFFITHS | GRIFFITHS | GRIFFITHS
Intermission
As of 25-Oct-12 | Casting subject to change.
 | Fri | Sat Mat | [NAME]
 | 2012-11-02 00:00:00 | 2012-11-03 00:00:00 | 2012-11-03 00:00:00
 | 19:30:00 | 14:00:00 | 19:30:00
KAMMERMUSIK NO. 3
Women |  |  | IMLER
 | IMLER | [NAME] | KORBES
 | KORBES | MULLIN | GILBREATH
 | GILBREATH | PASCH | [NAME]
 | [NAME] | LOVE | MURPHY
 | MURPHY | O'CONNOR | REID
 | REID | ANSPACH
Men |  |  | LIN-YEE
 | LIN-YEE | ORZA | MOORE
 | MOORE | PORRETTA | THOMSON
 | THOMSON | GRIFFITHS | CARDEA
 | CARDEA | BARTEE | DAVIS
 | DAVIS | LOCH | [NAME]
 | [NAME] | SUDDARTH
Intermission
As of 25-Oct-12 | Casting subject to change.
 | Fri | Sat Mat | [NAME]
 | 2012-11-02 00:00:00 | 2012-11-03 00:00:00 | 2012-11-03 00:00:00
 | 19:30:00 | 14:00:00 | 19:30:00
SUM STRAVINSKY
1. Tempo Giusto
Principal couple | IMLER | RICARD | NAKAMURA
 | PORRETTA | MOORE | GRIFFITHS
Corps couples
 | ANSPACH | RESHEF | ANSPACH
 | BARTEE | CARDEA | BARTEE
 | BIASUCCI | GENEROSA | BIASUCCI
 | DAVIS | HIPOLITO | DAVIS
 | REID | LOVE | REID
 | THOMSON | ROLLOFSON | THOMSON
 | SAMUELSON | NELSON | SAMUELSON
 | SUDDARTH | SUDDARTH | SUDDARTH
2. Allegretto
Principal couple | CHAPMAN | CHAPMAN | [NAME]
 | CRUZ | CRUZ | ORZA
3. [NAME]
Principal couple | RAUSCH | GILBREATH | KORBES
 | [NAME] | ORZA | [NAME]
Corps couples
 | [NAME] | MURPHY | [NAME]
 | MCCALL | MCCALL | MCCALL
 | CLARK | CLARK | CLARK
 | GRANT | GRANT | GRANT
 | O'CONNOR | PASCH | O'CONNOR
 | LIN-YEE | LIN-YEE | LIN-YEE
Spreadsheet: phillip_m_love__30697__east0726
Sheet: p_chgs

Period |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | if-ANR/LA |  |  |  |  |  |  |  |  |  |  |  | NGW-IROQ/Z2
------ | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | --------------- | ---------------
2000-07-01 00:00:00
2000-08-01 00:00:00
2000-09-01 00:00:00
2000-10-01 00:00:00
2000-11-01 00:00:00
2000-12-01 00:00:00
2001-01-01 00:00:00
2001-02-01 00:00:00
2001-03-01 00:00:00
2001-04-01 00:00:00
2001-05-01 00:00:00
2001-06-01 00:00:00
2001-07-01 00:00:00
2001-08-01 00:00:00
2001-09-01 00:00:00
2001-10-01 00:00:00
2001-11-01 00:00:00
2001-12-01 00:00:00
2002-01-01 00:00:00
2002-02-01 00:00:00
2002-03-01 00:00:00
2002-04-01 00:00:00
2002-05-01 00:00:00
2002-06-01 00:00:00
2002-07-01 00:00:00
2002-08-01 00:00:00
2002-09-01 00:00:00
2002-10-01 00:00:00
2002-11-01 00:00:00
2002-12-01 00:00:00
2003-01-01 00:00:00
2003-02-01 00:00:00
2003-03-01 00:00:00
2003-04-01 00:00:00
2003-05-01 00:00:00
2003-06-01 00:00:00
2003-07-01 00:00:00
2003-08-01 00:00:00
2003-09-01 00:00:00
2003-10-01 00:00:00
2003-11-01 00:00:00
2003-12-01 00:00:00
2004-01-01 00:00:00
2004-02-01 00:00:00
2004-03-01 00:00:00
2004-04-01 00:00:00
2004-05-01 00:00:00
2004-06-01 00:00:00
2004-07-01 00:00:00
2004-08-01 00:00:00
2004-09-01 00:00:00
2004-10-01 00:00:00
2004-11-01 00:00:00
2004-12-01 00:00:00
2005-01-01 00:00:00
2005-02-01 00:00:00
2005-03-01 00:00:00
2005-04-01 00:00:00
2005-05-01 00:00:00
2005-06-01 00:00:00
2005-07-01 00:00:00
2005-08-01 00:00:00
2005-09-01 00:00:00
2005-10-01 00:00:00
2005-11-01 00:00:00
2005-12-01 00:00:00
2006-01-01 00:00:00
2006-02-01 00:00:00
2006-03-01 00:00:00
2006-04-01 00:00:00
2006-05-01 00:00:00
2006-06-01 00:00:00
2006-07-01 00:00:00
2006-08-01 00:00:00
2006-09-01 00:00:00
2006-10-01 00:00:00
2006-11-01 00:00:00
2006-12-01 00:00:00
2007-01-01 00:00:00
2007-02-01 00:00:00
2007-03-01 00:00:00
2007-04-01 00:00:00
2007-05-01 00:00:00
2007-06-01 00:00:00
2007-07-01 00:00:00
2007-08-01 00:00:00
2007-09-01 00:00:00
2007-10-01 00:00:00
2007-11-01 00:00:00
2007-12-01 00:00:00
2008-01-01 00:00:00
2008-02-01 00:00:00
2008-03-01 00:00:00
2008-04-01 00:00:00
2008-05-01 00:00:00
2008-06-01 00:00:00
2008-07-01 00:00:00
2008-08-01 00:00:00
2008-09-01 00:00:00
2008-10-01 00:00:00
Spreadsheet: 6133e846-2998-426a-bcc5-0d835a9e3474
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Taseis | 801193153227 | Dale Ciceron & Optimistic | Breakthrough | 2012-01-10 | Compact Disc | Gospel | 10.99 | Y | Available
Spreadsheet: 65619d1266335995-help-with-if-formula-for-dates-pivot1
Sheet: Sheet2

date | value 1 | value 2 | diference |  |  | Sum of diference
2003-01-02 00:00:00 | 2 |  | 2 |  |  | date | Total
2003-01-02 00:00:00 |  | 1 | -1 |  |  | 2003-01-02 00:00:00 | -1
2003-01-02 00:00:00 |  | 2 | -2 |  |  | 2003-01-03 00:00:00 | 7
2003-01-03 00:00:00 | 2 |  | 2 |  |  | 2003-01-04 00:00:00 | -4
2003-01-03 00:00:00 | 2 |  | 2
2003-01-03 00:00:00 | 2 |  | 2
2003-01-03 00:00:00 | 1 |  | 1
2003-01-04 00:00:00 | 3 |  | 3
2003-01-04 00:00:00 |  | 5 | -5
2003-01-04 00:00:00 |  | 2 | -2
Spreadsheet: jonathan_mckay__16905__Point on the Bow - Trading
Sheet: Point-Bow

Enron Direct Deal Sheet |  |  |  |  |  |  |  |  |  |  |  |  | 1 | January
 |  |  |  |  |  |  |  |  |  |  |  |  | 2 | February
Counterparty Name: | Point on the Bow Condominium Corporation |  |  |  | Deal Date: | 2001-07-12 00:00:00 |  |  |  |  |  |  | 3 | March
Originator: | Greg Frers |  |  |  | Deal ID #: |  |  |  |  |  |  |  | 4 | April
 |  |  |  |  |  |  |  |  |  |  |  |  | 5 | May
Deal Start Date: | 2001-11-01 00:00:00 |  |  |  | Unit of Measure: | GJ |  |  |  |  |  |  | 6 | June
Deal End Date: | 2002-10-31 00:00:00 |  |  |  | Volume (Monthly/Daily): | Monthly |  |  |  |  |  |  | 7 | July
Term Duration (months): |  |  |  |  |  |  |  |  |  |  |  |  | 8 | August
 |  |  |  |  | Price: | 5.47 |  |  |  |  |  |  | 9 | September
Fuel Rate %: | 0.01561 |  |  |  | Buy/Sell: | Sell |  |  |  |  |  |  | 10 | October
 |  |  |  |  |  |  |  |  |  |  |  |  | 11 | November
 |  |  |  |  |  |  |  |  |  |  |  |  | 12 | December
 | Month | Rate 11 Volume | Rate 13 Volume | Combined Volume | Fuel | Total
 | January | 0 | 2278
 | February | 0 | 1547
 | March | 0 | 1300
 | April | 0 | 800
 | May | 0 | 650
 | June | 0 | 350
 | July | 0 | 300
 | August | 0 | 300
 | September | 0 | 596
 | October | 0 | 1113
 | November | 0 | 1610
 | December | 0 | 2056
 | TOTAL:
Spreadsheet: 38349d1236488927-countif-with-multiple-criteria-and-with-in-a-range-poker-stats
Sheet: Total Stats

Total Stats: | Games | ITM% | $Won | Net$Won | ROI% | 1st | 2nd | 3rd
ALL
45 Man Games | Games | ITM% | $Won | Net$Won | ROI% | 1st | 2nd | 3rd | 4th-7th
1.1
3.25
6.5
12
Totals:
90 Man Games | Games | ITM% | $Won | Net$Won | ROI% | 1st | 2nd | 3rd | 4th-12th
1.1
3.25
6.5
12
Totals:
180 Man Games | Games | ITM% | $Won | Net$Won | ROI% | 1st | 2nd | 3rd | 4th-9th
2.2
7.7
12
Totals:
Spreadsheet: d972ec5c-068b-4150-ba75-cde72884b727
Sheet: New Table 1_Inde

 | Table 1
 | Grain Transport Cost Indicators1
 |  | Truck | Rail |  | Barge | Ocean
 | Week ending |  | Unit Train | Shuttle |  | Gulf | Pacific
 | 1Indicator:  Base year 2000 = 100; Weekly updates include truck = diesel ($/gallon); rail = near-month secondary rail market bid and monthly tariff rate with fuel
 | surcharge ($/car); barge = Illinois River barge rate (index = percent of tariff rate); and ocean = routes to Japan ($/metric ton)
 | Source:  Transportation & Marketing Programs/AMS/USDA
Spreadsheet: mary_fischer__25622__87P
Sheet: E36.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 087P
COMPANY NAME  EFS Water Treatment Services
EQUITY INVESTEE'S SUMMARIZED INFORMATION
FOR THE 6 MONTHS ENDED 6-30-2001
PREPARED BY:[NAME]
EXTENSION:[PHONE]
 |  |  |  | E-36
NAME OF INVESTEE:
% OF OWNERSHIP:
THIS E-SCHEDULE IS REQUIRED FOR ALL OWNED EQUITY INVESTEES.
Please note the relationship and the differences between the E-3 (Analysis of Investment in Unconsolidated Equity Subsidiaries) and the E-36 (Equity
Investee's Summarized Information).  The E-3 seeks details of the Enron consolidating subsidiaries' (i.e. the investor) investment account.  The E-36
seeks summarized income statement and balance sheet information of the unconsolidated subsidiary (i.e. the investee).
If an E-3 has been prepared for an equity investment, then an E-36 for the related in investee needs to be completed.
Include all investees, regardless of Enron's ownership interest.
PLEASE PROVIDE THE FOLLOWING SUMMARIZED FINANCIAL INFORMATION AS IT
WOULD APPEAR IN THE INVESTEE'S FINANCIAL STATEMENTS (100%).
 |  |  |  | BALANCE AT
BALANCE SHEET (100%) |  |  |  | END OF QUARTER
CURRENT ASSETS |  |  |  | 0
PROPERTY, PLANT AND EQUIPMENT, NET. |  |  |  | 0
OTHER NONCURRENT ASSETS |  |  |  | 0
CURRENT LIABILITIES |  |  |  | 0
LONG-TERM DEBT |  |  |  | 0
ADVANCES FROM ENRON COMPANIES |  |  |  | 0
OTHER NON-CURRENT LIABILITIES |  |  |  | 0
OWNERS' EQUITY |  |  |  | 0
Memo:
AMOUNT RECEIVABLE FROM ENRON (included above) |  |  |  | 0
AMOUNT PAYABLE TO ENRON (included above) |  |  |  | 0
INVESTMENT IN UNCONSOLIDATED
EQUITY INVESTEE
(must tie to Hyperion acct TOT_INVEST_SUBS & E-3) |  | 0
Asset/Expense Accts:  DR/(CR)
INCOME STATEMENT (100%) |  |  |  | YEAR-TO-DATE
OPERATING REVENUES |  |  |  | 0
OPERATING EXPENSES |  |  |  | 0
GROSS INTEREST EXPENSE (3rd Party Only) |  |  |  | 0
OTHER INCOME & DEDUCTIONS |  |  |  | 0
INCOME TAXES |  |  |  | 0
NET INCOME
INVESTMENT IN NET INCOME
(must tie to Hyperion acct TOT_EQEARN_OTH & E-3) |  | 0
Income Accts:  DR/(CR)
Memo:
CAPITALIZED INTEREST |  |  |  | 0
RENTAL EXPENSE |  |  |  | 0
 |  |  |  | E-36
Spreadsheet: 187416d1350453517-help-with-look-up-functions-example17th
Sheet: Sheet1

Number | Box Number
176 | 139
207 | 283
56 | 977
738 | 367
625 | 373
974 | 643
148 | 915
153 | 655
31 | 191
421 | 488
164 | 250
172 | 352
272 | 442
89 | 158
750 | 996
910 | 997
993 | 11
300 | 406
584 | 302
664 | 500
402 | 296
830 | 324
779 | 646
54 | 472
255 | 824
712 | 920
487 | 456
500 | 36
609 | 360
Spreadsheet: 769601d1645617607-pulling-through-entire-row-of-data-test-data
Sheet: 111

Site: | 111
 | Property | Date | Item | Who | Income | Expenditure
Spreadsheet: 690567d1597168274-conditional-formatting-finding-duplicates-across-multple-sheets-asset-management-and-location-information
Sheet: 2020 Completed Refresh

 |  | Notes | Ordered? | Received | New CI | New CI S/N | New CI Model | Tag Number | CRQ | Old CI Name | Old CI S/N | Tag Number | Old [NAME] | Status | Status Reason / Last Connected | [NAME] | Product Categorization Tier 1 | Product Categorization Tier 2 | Product Categorization Tier 3 | System Role | System Environment | Company | Site | Room | Inventory Name | Managed By | Used By | Owner Name | Owner Contact | Submitter | Audit Date | Purchase Date | Received Date | Create Date | Confirmed Date | Last Scan Date | Disposal Date | [NAME]
 | 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
 | 32
 | 33
 | 34
 | 35
 | 36
 | 37
 | 38
 | 39
 | 40
 | 41
 | 42
 | 43
 | 44
 | 45
 | 52
 | 53
 | 54
 | 55
 | 56
 | 57
 | 58
 | 59
 | 60
 | 61
 | 62
 | 63
 | 64
 | 65
 | 67
 | 70
 | 71
 | 72
 | 73
 | 74
 | 75
 | 76
 | 77
 | 78
 | 79
 | 80
 | 81
 | 82
 | 83
 | 84
 | 85
 | 86
 | 87
 | 88
 | 89
 | 90
 | 91
 | 92
 | 93
 | 94
 | 95
 | 96
 | 97
 | 98
 | 99
 | 100
Spreadsheet: 146665d1332291544-determining-distance-using-latitude-and-longitude-gps-calc
Sheet: Sheet1

Latitude | Longitude | Precision | Address | City | State |  |  | Latitude | Longitude | Precision | Address | City | State |  | Zip | dist - cell | dist - vba | dist - form
36.277966 | -115.143685 |  |  |  | ca | US | 89031 | 34.193935 | -118.463192 |  | 15107 VanOwen Street | [NAME] | CA | US | 91405 | 236.2518666959629 | 217.4382958937297 | 217.2783341565958
33.786594 | 118.298662 |  |  |  | ca | US | 91344 | 34.193935 | 118.463192 |  | 15107 VanOwen Street | [NAME] | CA | US | 91405 | 29.68088379264692 | 217.4382958937297 | 217.2783341565958
Spreadsheet: 755382d1636822106-retrieve-data-from-string-of-text-retrievedata
Sheet: Sheet1

Raw Data | Result (retrieve values with underscore) | Result (retrieve first date in string, if any) | Result (retrieve second date in string, if any) | Result (value that starts with "ABCD")
Raja 20211113_83378 complete his project of 23/10/2021 by 25/10/2021
[NAME] has 81918191 by 21/10/2021 of 26/11/2021
[NAME] has ABCD-1212-14444-4444 of 88110011 by 24/11/2021
[NAME] has 2029221_2291 by 28/10/2021
[NAME] wants ABCD-111-222-991 of 25/10/2021
Spreadsheet: 132481d1323788253-how-to-make-representation-graph-by-country-name-pivotchartcountrynames
Sheet: Sheet1

Name | Country
Name1 | USA
[NAME] | UAE
Name3 | France
Name4 | Germany |  |  | Row Labels | Count of Country
Name5 | USA |  |  | France | 26
Name6 | UAE |  |  | Germany | 14
Name7 | France |  |  | UAE | 22
Name8 | Germany |  |  | USA | 19
Name9 | USA |  |  | Grand Total | 81
Name10 | UAE
Name11 | France
Name12 | Germany
Name13 | USA
Name14 | UAE
Name15 | France
[NAME] | Germany
Name17 | Usa
Name18 | Usa
Name19 | Germany
[NAME] | France
Name21 | France
Name22 | France
Name23 | France
Name24 | USA
Name25 | UAE
Name26 | UAE
Name27 | UAE
Name28 | UAE
Name29 | France
Name30 | Germany
Name31 | USA
Name32 | UAE
Name33 | France
[NAME] | Germany
Name35 | Usa
Name36 | Usa
Name37 | Germany
Name38 | France
[NAME] | France
Name40 | France
Name41 | France
Name42 | USA
Name43 | UAE
Name44 | UAE
Name45 | UAE
Name46 | UAE
[NAME] | France
Name48 | Germany
Name49 | USA
Name50 | UAE
Name51 | France
[NAME] | Germany
Name53 | Usa
Name54 | Usa
Name55 | Germany
Name56 | France
Name57 | France
Name58 | France
Name59 | France
Name60 | USA
Name61 | UAE
Name62 | UAE
Name63 | UAE
Name64 | UAE
Name65 | France
Name66 | Germany
[NAME] | USA
[NAME] | UAE
Name69 | France
Name70 | Germany
Name71 | Usa
Name72 | Usa
[NAME] | Germany
Name74 | France
Name75 | France
Name76 | France
Name77 | France
Name78 | USA
Name79 | UAE
Name80 | UAE
Name81 | UAE
Spreadsheet: 269360d1381140656-counts-unique-values-per-dates-albert28
Sheet: Sheet1

Account Number | Dates |  | 2013-10-02 00:00:00 | 2013-10-03 00:00:00
10001 | 2013-10-02 00:00:00
10001 | 2013-10-02 00:00:00
10001 | 2013-10-02 00:00:00
1002 | 2013-10-02 00:00:00
10001 | 2013-10-02 00:00:00
10023 | 2013-10-02 00:00:00
10001 | 2013-10-03 00:00:00
10001 | 2013-10-03 00:00:00
10001 | 2013-10-03 00:00:00
1002 | 2013-10-03 00:00:00
10001 | 2013-10-03 00:00:00
10023 | 2013-10-03 00:00:00
Spreadsheet: 719426d1613660841-creating-a-top-5-list-with-conditionals-top5list
Sheet: Sheet1

Sales ID | Species | Sold by | Sold for
10 | Duck | [NAME] | 25
20 | Dog | [NAME] | 109
30 | Parrot | Grant | 23
40 | Cat | Grant | 64
50 | Cat | [NAME] | 60
60 | Dog | [NAME] | 90
70 | Horse | [NAME] | 975
80 | Dog | [NAME] | 160
90 | Parrot | [NAME] | 65
100 | Parrot | [NAME] | 80
110 | Sheep | [NAME] | 199
120 | Dog | [NAME] | 250
130 | Lion | [NAME] | 573
140 | Lion | [NAME] | 620
150 | Dog | [NAME] | 321
160 | Horse | [NAME] | 546
170 | Cat | [NAME] | 75
180 | Parrot | [NAME] | 33
190 | Cat | [NAME] | 60
200 | Duck | [NAME] | 39
210 | Lion | [NAME] | 346
220 | Tiger | [NAME] | 846
230 | Cat | [NAME] | 40
240 | Parrot | [NAME] | 31
250 | Cat | [NAME] | 25
260 | Dog | Grant | 205
270 | Tiger | [NAME] | 625
280 | Horse | [NAME] | 764
290 | Dog | [NAME] | 126
300 | Cat | [NAME] | 48
Cats |  |  |  | Dogs
Sales ID | Name | Sold for |  | Sales ID | Name | Sold for
170 | [NAME] | 75 |  | 150 | [NAME] | 321
40 | Grant | 64 |  | 120 | [NAME] | 250
50 | [NAME] | 60 |  | 260 | Grant | 205
190 | [NAME] | 60 |  | 80 | [NAME] | 160
300 | [NAME] | 48 |  | 290 | [NAME] | 126
Parrots |  |  |  | Horses
Sales ID | Name | Sold for |  | Sales ID | Name | Sold for
100 | [NAME] | 80 |  | 70 | [NAME] | 975
90 | [NAME] | 65 |  | 280 | [NAME] | 764
180 | [NAME] | 33 |  | 160 | [NAME] | 546
240 | [NAME] | 31
30 | Grant | 23
Spreadsheet: 148778d1333551900-excel-2007-3-way-lookup-index-match-2
Sheet: Sheet2

Date |  | 2012-01-01 00:00:00
site no | address | cost
Spreadsheet: 839608d1692109808-how-to-concatenate-and-show-ranking-formulas-ranking-example
Sheet: Sheet1

Name 1 | [NAME] | Address | Phone No | Visits
Elvis | Presley | 2 West Street | 55987 | 23
[NAME] | [NAME] | 15 West Street | 16579 | 18 |  |  | Rank 2 = [NAME] |  |  | Rank 2 = [NAME]
Clint | Eastwood | 2 North Row | 78945 | 4 |  |  | Rank 3 = [NAME] 55 |  |  | Rank 3 = [NAME] 55
[NAME] | Wayne | 54 East Avenue | 22265 | 66 |  |  | Rank 4 = [NAME] 23 |  |  | Rank 4 = [NAME] 23
Elvis | Presley | 2 West Street | 55987 | 15 |  |  | Rank 5 = [NAME] 18 |  |  | Rank 5 = [NAME] 18
[NAME] | [NAME] | 15 West Street | 16579 | 9 |  |  | Rank 6 = [NAME] 15 |  |  | Rank 6 = [NAME] 15
Clint | Eastwood | 2 North Row | 78945 | 1 |  |  | Rank 7 = [NAME] 13 |  |  | Rank 7 = [NAME] 13
[NAME] | Wayne | 54 East Avenue | 22265 | 77 |  |  | Rank 8 = Elton John 9 |  |  | Rank 8 = Elton John 9
Elvis | Presley | 2 West Street | 55987 | 8 |  |  | Rank 9 = Elvis  Presley 8 |  |  | Rank 9 = Elvis  Presley 8
[NAME] | [NAME] | 15 West Street | 16579 | 1 |  |  | Rank 10 = [NAME] |  |  | Rank 10 = [NAME]
Clint | Eastwood | 2 North Row | 78945 | 13 |  |  | Rank 11 = [NAME] |  |  | Rank 11 = [NAME]
[NAME] | Wayne | 54 East Avenue | 22265 | 55 |  |  | Rank 11 = [NAME] John 1 |  |  | Rank 11 = [NAME] John 1
Spreadsheet: 726732d1617389834-replace-nested-ifs-with-vlookup-forum-if-test-
Sheet: DATA

 |  |  |  | PLACE | LT | PLACE | LT | PLACE | LT | PLACE | LT | PLACE | LT | PLACE | LT | PLACE | LT | PLACE | LT
 |  |  |  | MMM | 3.5 | 22 | -8 | GMT +3.5 From 22 SEP to 21 MAR
 |  |  |  | GGG | 2 | 26 | 29 | GMT +2 From 29 OCT to 25 MAR
 |  |  |  | HHH | 2 | 26 | 29 | GMT +2 From 29 OCT to 25 MAR
 |  |  |  | CCC | 1 | 28 | 31 | GMT +1 From 31 OCT to 27 MAR
 |  |  |  | DDD | 1 | 28 | 31 | GMT +1 From 31 OCT to 27 MAR
 |  |  |  | AAA | 3
 |  |  |  | BBB | 3
 |  |  |  | EEE | 2
 |  |  |  | FFF | 2
 |  |  |  | III | 4
 |  |  |  | JJJ | 4
 |  |  |  | KKK | 5
 |  |  |  | LLL | 5
Spreadsheet: 73169d1273810766-vlookup-with-two-lookup-values-vlookup
Sheet: Sheet1

 | PARAMETER | Wind Speed / dir | Wave height / dir | Swell height / dir
2010-04-28 00:00:00 | 2400H | 1 | 2 | 3
 | 0600H | 1 | 2 | 3
 | 1200H | 1 | 2 | 3
 | 1800H | 1 | 2 | 3
2010-04-29 00:00:00 | 2400H | 1999H | abc | abc
 | 0600H | 1900H | def | def
 | 1200H | 1000HH | xyz | xyz
 | 1800H | 1777H | ddd | ddd
2010-04-30 00:00:00 | 2400H | 40 | 30 | 20
 | 0600H | 33 | 22 | 11
 | 1200H | 44 | 32 | 12
 | 1800H | 22 | 32 | 54
Spreadsheet: 761788d1641223891-employee-attendance-tracker-starting-september-for-12-months-calendar-sample-workbook
Sheet: Calendar View

 | EMPLOYEE ATTENDANCE RECORD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Select an Employee: |  |  |  |  |  |  |  |  | [NAME] (27+4.5)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Select a Year: |  |  |  |  |  |  |  |  | 2021
 |  |  |  |  |  |  | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S | S | M | T | W | T | F | S
 |  | KEY STATISTICS
 |  |  | Days on Leave |  |  |  |  |  | Working Days |  |  |  |  |  | # Days Sick |  |  |  |  |  | # Days Annual Leave |  |  |  |  |  |  |  | # days [NAME] |  |  |  |  |  |  | # days Time Owing |  |  |  |  |  |  | # days Other
Spreadsheet: 817592d1676342122-calculating-payment-due-dates-automatically-subscription-tracker
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 |  | 3 | y |  |  |  |  | 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 |  | 1 | y
 | 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 |  | 1 | q
 | Kindle Direct | 2021-02-11 00:00:00 |  | 1 | q
 | Netflix | 2022-01-09 00:00:00 |  | 1 | y
 | [NAME] | 2022-05-26 00:00:00 |  | 1 | m
Spreadsheet: benjamin_rogers__1239__Simple Cycle Florida model
Sheet: IS

INCOME STATEMENT
('000 $)
 |  | 2001-12-31 00:00:00 | 2002-12-31 00:00:00 | 2003-12-31 00:00:00 | 2004-12-31 00:00:00 | 2005-12-31 00:00:00 | 2006-12-31 00:00:00 | 2007-12-31 00:00:00 | 2008-12-31 00:00:00 | 2009-12-31 00:00:00 | 2010-12-31 00:00:00 | 2011-12-31 00:00:00 | 2012-12-31 00:00:00 | 2013-12-31 00:00:00 | 2014-12-31 00:00:00 | 2015-12-31 00:00:00 | 2016-12-31 00:00:00 | 2017-12-31 00:00:00 | 2018-12-31 00:00:00 | 2019-12-31 00:00:00 | 2020-12-31 00:00:00 | 2021-12-31 00:00:00 | 2022-12-31 00:00:00 | 2023-12-31 00:00:00 | 2024-12-31 00:00:00 | 2025-12-31 00:00:00 | 2026-12-31 00:00:00 | 2027-12-31 00:00:00 | 2028-12-31 00:00:00 | 2029-12-31 00:00:00 | 2030-12-31 00:00:00 | 2031-12-31 00:00:00
Revenue
Capacity Revenue
Energy Revenue
Ancillary Services |  | 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
Total Revenue
Expense
Fuel
Fixed Operating Expenses
Variable Operating Expenses
Major [NAME]
Insurance
SG&A
Start Charge
Property Tax
Franchise Tax
[NAME] |  | 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
Debt Service Reserve [NAME]
Marketing Fee
Administrative Fee
O&M Fees
Total Expense
EBITDA
Depreciation & Amortization
EBIT
Interest Expense
Pretax Book Income
Book State Tax Benefit / (Expense)
Shareholder Fed. Tax Benefit / (Expense)
Net Income