tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 00804e74-e582-4e81-bcfa-273bb26bfaf5
Sheet: Sheet1

1924 - 13th Coupe Aéronautique [NAME] | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
Starting Point: | Solbosch, Bruxelles, Belgium |  |  |  |  | 1924-06-15 00:00:00
 |  | Pilots Name |  | Co-Pilots Name
Rank | Country | Last | First | Last | First | BalloonName | LandingPlace | Distance km | Time
1 | BEL | Demuyter | Ernest | [NAME] | [NAME] | Belgica | St.Abb's Head/Edinburgh/Scottland | 714 | 1900-01-01 19:16:00
2 | FRA | Laporte | Fernand | [NAME] | E. | Ville de Bordeaux | Shoreham/Sussex | 330 | 1900-01-01 09:18:00
3 | ITA | Valle | Comm. [NAME] di | Ilari | Comm.[NAME] | Ciampino V | Thiergeville-les-Fecamp | 301 | 21:34:00
4 | ITA | [NAME] | (Maj.) | Medori | Maj. Ugo | Aerostiere III | [NAME] | 295 | 1900-01-01 02:55:00
5 | SPA | Casas | Lt. R. | [NAME] | J. | Hespherio | Rhodon-St.Remy-les-Chev. | 286 | 1900-01-01 01:45:00
6 | USA | Honeywell | [NAME] | Timmons | C.W. | [NAME] | [NAME] par Boos | 284 | 21:20:00
7 | GBR | [NAME] | Capt. Percival | Berry | [NAME] | [NAME] | Dieppe/France | 256 | 21:45:00
8 | SUI | [NAME] | Capt. [NAME] | Bachmann | Dr. O. | Helvetia | St.Martin au Bosc | 222 | 1900-01-01 05:40:00
9 | SPA | Balbas | Ct. V. | Maldonado | Maj. E. | Cpt. Penaranda | [NAME] | 222 | 1900-01-01 07:10:00
10 | FRA | Bienaime | [NAME] | Latu | René | La Picardie | [NAME] | 213 | 1900-01-01 04:00:00
11 | GBR | Baldwin | (Sq.Lead.) | Grosvenor | (Lord) | Banshee III | Noineville | 212 | 23:20:00
12 | BEL | Labrousse | Capt. M. | Dewandre | (Comm.) | Ville de Bruxelles | Gengoulph | 207 | 1900-01-01 00:45:00
13 | SPA | [NAME] | J. | Magdalena | E. | Jesu [NAME] | Bergneuilles/Ltt. | 173 | 1900-01-01 11:53:00
14 | USA | Orman | [NAME] | Wollam | [NAME] | Goodyear III | Amstelveen/ Amsterdam/ Netherlands | 170 | 1900-01-01 11:17:00
15 | FRA | Cormier | Georges |  |  | Anjou IV | [NAME]. | 144 | 1900-01-01 01:35:00
16 | USA | Peek | (Maj.) | Gray | Lt. [NAME] | US Army | Ligneuville-les-Malmedy | 128 | 1900-01-01 00:30:00
17 | BEL | [NAME] | [NAME] | [NAME] | [NAME] | Prince Leopold | Leffinghe/ Oostende/Belgium | 112 | 1900-01-01 09:20:00
Spreadsheet: 104641d1302169103-imputing-a-formular-or-fromat-that-checks-duplication-sales-report
Sheet: Sheet1

SALES REPORT
DATE | ST. NO. | VEH. NO. | INV. NO | QTY. | TONS | UNIT PRICE | CUSTOMER
1/4/2011 | 11002098 | XA   878   GWK | 1083 | 600 | 30 | 830000 | FAJUKBOL GLOBALINK
4/4/2011 | 11001952 | XA   389   BNS | 1087 | 600 | 30 | 830000 | GEOFFREY
4/4/2011 | 11002096 | XA   892   GWK | 1093 | 600 | 30 | 830000 | GEOFFREY
4/4/2011 | 11002094 | YD   252   ENU | 1091 | 600 | 30 | 830000 | UMENZE NIG CO.
4/4/2011 | 11001951 | XA   388   BNS | 1086 | 600 | 30 | 830000 | PAUL ENDWELL NIG LTD
4/4/2011 | 11002119 | XA   895   GWK | 1088 | 600 | 30 | 830000 | IBEKWE RUFUS
4/4/2011 | 11002123 | XE   524   WER | 1092 | 600 | 30 | 830000 | BEDE OBIAKO
4/4/2011 | 11002097 | XA   883   GWK | 1089 | 600 | 30 | 830000 | A.D. OBINNA
4/4/2011 | 11002099 | XA   766   GWK | 1094 | 600 | 30 | 830000 | A.D. OBINNA
4/4/2011 | 11002036 | XA   803   GWK | 1085 | 600 | 30 | 830000 | OZUMBA SUNDAY
4/4/2011 | 11002091 | XA   737   GWK | 1090 | 600 | 30 | 830000 | EJIKE AKAWO
4/4/2011 | 11001979 | XA   733   GWK | 1084 | 600 | 30 | 830000 | FAJUKBOL GLOBALINK
4/4/2011 | 11002121 | XN   668   KRD | 1095 | 600 | 30 | 830000 | CHIGBOGU CHIJIOKE
5/4/2011 | 11002128 | XC   808   APR | 1103 | 600 | 30 | 830000 | UMENZE NIG CO.
5/4/2011 | 11002118 | YD   252   ENU | 1105 | 600 | 30 | 830000 | UMENZE NIG CO.
5/4/2011 | 11002123 | XA   767   GWK | 1096 | 600 | 30 | 830000 | PAUL ENDWELL NIG LTD
5/4/2011 | 11002126 | XA   899   GWK | 1098 | 600 | 30 | 830000 | [NAME]
5/4/2011 | 11002130 | XB   425   KKE | 1100 | 600 | 30 | 830000 | [NAME] AMAKOR
5/4/2011 | 11002037 | XA   805   GWK | 1102 | 600 | 30 | 830000 | OZUMBA SUNDAY
5/4/2011 | 11001984 | XA   897   GWK | 1101 | 600 | 30 | 830000 | [NAME]
5/4/2011 | 11002125 | XA   896   GWK | 1104 | 594 | 29.7 | 821700 | LP's SPECTRUM
5/4/2011 | 11002129 | XB   424   KKE | 1099 | 600 | 30 | 830000 | FAJUKBOL GLOBALINK
5/4/2011 | 11002127 | XA   880   GWK | 1097 | 600 | 30 | 830000 | [NAME]
6/4/2011 | 11002032 | XX   703   FKJ | 1107 | 600 | 30 | 830000 | [NAME]
6/4/2011 | 11001968 | XR   679   BDG | 1108 | 600 | 30 | 830000 | AJUFO ARINZE
6/4/2011 | 11002131 | XE   425   WER | 1106 | 600 | 30 | 830000 | FAJUKBOL GLOBALINK
Spreadsheet: 780961d1652890458-two-different-rates-of-payment-for-duty-during-certain-times-sample-night-duty-copy
Sheet: Sheet1

Start Time | End Time | Night Duty Type 1 (6pm to 8pm) | Night Duty Type 2 (8pm to 8am)
16:00:00 | 18:00:00 | 0 | 0
18:00:00 | 19:00:00 | 1 | 0
18:00:00 | 21:00:00 | 2 | 1
18:30:00 | 01:00:00 | 1.5 | 5
19:00:00 | 23:00:00 | 1 | 3
21:00:00 | 03:00:00 | 0 | 6
Spreadsheet: 871204d1717596238-returning-a-value-where-a-condition-ends-get-last-header-in-block
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | Expected values:
 | Header | Input | Block # |  | End of Block |  | Block # | [NAME] | [NAME] | Col. Start | Col. End | No. Cols.
 |  |  |  |  |  |  |  |  | Hits released
 | Image |  |  |  |  |  | 2 | P&D status | Style | 7 | 18 | 12
 | Team Freeze | Y | 1 |  |  |  | 3 | Class |  | 20 | 20 | 1
 | [NAME] | Y |  |  |  |  | 4 | Code Sub-class |  | 22 | 22 | 1
 | Hits released | Y
 | Total Hits
 | P&D status | Y | 2
 | Sourcing status | Y
 | Merchant status | Y
 | Planning status | Y
 | General comments | Y
 | P&D comments | Y
 | Sourcing comments | Y
 | Merchant comments | Y
 | Planning comments | Y
 | Alloc. comments | Y
 | USIM | Y
 | Style | Y
 | Colour
 | Class | Y | 3
 | Class helper
 | Code Sub-class | Y | 4
 | Code
 | Class code
Spreadsheet: 688649d1595888916-using-data-validation-to-link-data-to-different-locations-excel-help-2
Sheet: Pro-Forma Balance Sheet

 | Opening 2012 | Adjustments  + | Adjustments - | ProForma  2012
Cash and Cash Equivalents | 250
Accounts Receivables | 450
Inventories | 600
Prepaids and Other Current Assets | 175
Total Current Assets
Property, Plant and Equipment, Net | 2500
Goodwill | 1000
Intangible Assets | 875
Other Assets | 150
Deferred Financing Fees
Total Assets
Accounts Payable | 215
Accrued Liabilities | 275
Other Current Liabilities | 100
Total Current Liabilities
Revolving Credit Facility
Term Loan A
Term Loan B
Term Loan C
2nd [NAME]
Existing Bank Debt | 1000
Senior Notes
Senior Suboridinate Notes
Senior Suboridinate Notes
Senior Bridge Facility
Senior Subordinate Bridge Facility
Existing Bond Debt | 500
Mezzanine Debt
Existing Mezzanine Debt
Deferred Income Taxes | 300
Other-Long Term Liabilities | 110
Total Liabilities
[NAME] | 0
Shareholders Equity | 3500
Existing Shareholders Equity
Total Shareholders Equity
Total Liabilities and Equity
Spreadsheet: 887535d1737755664-generating-1-column-of-data-into-a-calendar-reviews-calendar-test_3
Sheet: Family Calendar

 | Treatment Plan Reviews |  |  | 2026
 | Important Dates
birthday | Next Review Date | Client Name | Event Type
2000-01-29 00:00:00 |  | Spiderman |  | G |  | Set the First Day of the Week
2000-02-05 00:00:00 |  | Iron Man |  | H
2000-02-05 00:00:00 |  | Black Widow |  | G
2025-02-26 00:00:00 |  | Captain America |  | G |  | Sunday
2025-01-28 00:00:00 |  | Hawkeye |  | I |  |  |  |  |  |  |  |  | Black Widow
2025-01-29 00:00:00 |  | Hulk |  | G
2025-02-12 00:00:00 |  | Antman |  | G |  | Name up to 5 event categories
2025-01-28 00:00:00 |  | Red Guardian |  | I
2025-02-12 00:00:00 |  | [NAME] |  | G
2025-02-26 00:00:00 |  | Storm |  | G |  |  | Past Events
2025-03-12 00:00:00 |  | Deadpool |  | H |  |  | State Holiday
2025-01-28 00:00:00 |  | Wolverine |  | G |  |  | Other Major Events
 |  |  |  |  |  |  | G
 |  |  |  |  |  |  | H
 |  |  |  |  |  |  | I
 |  | New Year's Day |  | State Holiday
 | 2025-01-20 00:00:00 | MLK jr Day |  | State Holiday
 | 2025-02-17 00:00:00 | Presidents Day |  | State Holiday
 | 2025-02-12 00:00:00 | Lincoln Day |  | State Holiday
 | 2025-05-08 00:00:00 | Truman Day |  | State Holiday
 | 2025-05-26 00:00:00 | Memorial Day |  | State Holiday
 | 2025-06-19 00:00:00 | Juneteenth |  | State Holiday
 | 2025-07-04 00:00:00 | Independence Day |  | State Holiday
 | 2025-10-13 00:00:00 | [NAME] |  | State Holiday
 | 2025-11-11 00:00:00 | Veteran's Day |  | State Holiday
 | 2025-11-27 00:00:00 | Thanksgiving |  | State Holiday
 | 2025-12-25 00:00:00 | Christmas |  | State Holiday
Spreadsheet: 94979d1294706468-make-a-calendar-with-noted-birthdays-etc-my2011-25
Sheet: w2

 |  |  |  |  |  | Anniversaries
 |  |  |  |  |  | Sam & Betty wed | 2004-01-07 00:00:00
 |  |  |  |  |  | Mel & Ann wed | 1987-02-05 00:00:00
 |  |  |  |  |  | Tom & Sis wed | 1978-05-12 00:00:00
 |  |  | These Birthdays and Anniversaries would actually
 |  |  | be on the "Dates" worksheet (see the tab below).
 |  |  |  |  |  | DATEDIF figured out [NAME]'s age.
 |  |  | Shown here is only the first page for Weeks 1 and 2.
 |  |  | Of course, I'll make more worksheets for…
 | [NAME] is 35 |  | Weeks 3, 4, 5, 6, 7, etc…  for the year.
 |  |  | Sometimes, more than 1 event is on a certain date.
 |  |  | Sometimes even, more than 1 Birthday is on the same date.
 |  |  | I just want them all to go on lower lines.
 | [NAME] is 15
 | Sam & Betty wed: 7
This is 5 and 1/2 inches wide
Spreadsheet: 874487d1721091134-how-to-calculate-the-percentage-on-the-balance-paid-on-a-loan-loan-amortization-schedule1
Sheet: Loan Schedule

 |  | Loan amortization schedule
 | Enter values |  |  |  |  | Loan summary
 | Loan amount |  |  | 588700 |  | Scheduled payment
 | Annual interest rate |  |  | 0.025 |  | Scheduled number of payments
 | Loan period in years |  |  | 25 |  | Actual number of payments
 | Number of payments per year |  |  | 12 |  | Total early payments
 | Start date of loan |  |  | 2020-08-01 00:00:00 |  | Total interest
 | Optional extra payments |  |  | 0 |  | Lender name |  | Woodgrove Bank
 | Payment number | Payment date | Beginning balance | Scheduled payment | Extra payment | Total payment | Principal | Interest | Ending balance | Cumulative interest | Percentage of Balance Paid
Spreadsheet: 740808d1626604145-alternative-ways-to-calculate-circular-references-circular-reference-group
Sheet: Sheet1

 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: kevin_presto__19785__Power Projects
Sheet: Sheet1

Project Name |  |  | Estimated Completion Month | Estimated Completion Year | [NAME] | Purpose |  |  | EA LOB Served | System | Status | EA % | EA $ | EA $ [NAME] | EA $ Indirect Expense | EA $ Direct Project Expense
Power Fundamentals New Dev |  |  | 12 | 2002 | Belden/Presto | New business or change in business |  |  | Trading Support Power | Power Front Office | In Progress | 1 | 12381326 | 11013795 | 771066 | 596465
[NAME] and PMI Data |  |  | 12 | 2002 | Belden/Presto | New business or change in business |  |  | Trading Support Power | Power Front Office | In Progress | 1 | 1681710 | 1429387 | 143371 | 108952
Real-Time Workbench/Services Desk Tools |  |  | 12 | 2002 | Belden/Presto | New business or change in business |  |  | Trading Support Power | Power Front Office | In Progress | 1 | 1477794 | 1317907 | 90849 | 69039
Power Fundamentals Maintenance |  |  |  |  | Belden/Presto | Other/Maintenance |  |  | Trading Support Power | Power Front Office | In Progress | 1 | 6357820 | 0 | 654394 | 5703426
Power Risk Plan Expense |  |  |  |  | Belden/Presto | Other/Maintenance |  |  | Trading Support Power | Power Front Office | In Progress | 1 | 1493494 | 0 | 143371 | 1350124
Power Asset |  |  |  |  | Belden/Presto | Other/Maintenance |  |  | Trading Support Power | Power Front Office | In Progress | 1 | 1135655 | 0 | 100785 | 1034869
Consolidate Position Manager |  |  |  |  | Belden/Presto | Replace old tech or arch |  |  | Trading Support Power | Power Front Office | In Progress | 1 | 764273 | 654993 | 62093 | 47187
Spreadsheet: 271332d1381915767-help-needed-with-linking-2-worksheets-overview-delivery-teams2
Sheet: Personal numbers

Last name | First name | Phone | Mobile | E-mail
qwe | asd | 123 | 456 | a@b.c
asd | yxc | 456 | 789 | b@a.c
yxc | qwe | 789 | 123 | c@a.b
Spreadsheet: 234435d1368104514-conditional-formatting-time-hour
Sheet: Sheet1

00:01:00
01:01:00
02:01:00
03:01:00
04:01:00
05:01:00
06:01:00
07:01:00
08:01:00
09:01:00
10:01:00
11:01:00
12:01:00
13:01:00
14:01:00
15:01:00
16:01:00
17:01:00
18:01:00
19:01:00
20:01:00
21:01:00
22:01:00
23:01:00
Spreadsheet: 169443d1342845299-how-to-calculate-monthly-average-worksheet
Sheet: Assesment Group

 | SCORE CARD COACH RELATIONS
 | This is how I think it should be calculated
 |  |  |  | QA |  |  |  | [NAME] |  |  |  | SUSP |  |  |  | LATES |  |  |  | ADHERENCE |  |  |  | Overall Grade | QA |  |  |  |  | ABSNT |  |  |  | SUSP |  |  |  | LATES |  |  |  | ADHERENCE
 | [NAME] | EV2 | EV3 | W1 | [NAME] | W3 | W4 | W1 | [NAME] | W3 | W4 | W1 | [NAME] | W3 | W4 | W1 | [NAME] | W3 | W4 | W1 | [NAME] | W3 | W4 |  | AVER | QAP | QAG | QAPoints | LQA | AT | AG | APoints | LA | ST | SG | SPoints | LS | LT | LG | LPoints | LL | AD | ADPoints | LAD
WE 05/27 |  |  | 22 |  |  |  |  | 1 |  |  |  |  |  |  |  | 1 |  |  |  | 79
WE 06/03 |  |  | 27 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 99
WE 06/10 |  |  | 29 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 97
WE 06/17 | 26 | 28 | 30 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  | 95
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AVERAGE
 | This is how it's been currently been calculated |  |  | QA |  |  |  | [NAME] |  |  |  | SUSP |  |  |  | LATES |  |  |  | ADHERENCE |  |  |  | Overall Grade | QA |  |  |  |  | ABSNT |  |  |  | SUSP |  |  |  | LATES |  |  |  | ADHERENCE
 |  |  |  | W1 | [NAME] | W3 | W4 | W1 | [NAME] | W3 | W4 | W1 | [NAME] | W3 | W4 | W1 | [NAME] | W3 | W4 | W1 | [NAME] | W3 | W4 |  | AVER | QAP | QAG | QAPoints | LQA | AT | AG | APoints | LA | ST | SG | SPoints | LS | LT | LG | LPoints | LL | AD | ADPoints | LAD
 |  |  |  | 22 | 27 | 29 | 28 | 1 |  |  |  |  |  |  |  | 1 |  |  | 1 | 79 | 99 | 97 | 95
Spreadsheet: 818106d1676589958-if-and-or-q-and-d-feb-with-summary-end
Sheet: 1st

1 | Defect ID | Unit ID | Unit Date | Prod Date | Act Date | Shift | Year | Serial | z | ID #1 | ID #2 | ID #3 | Product | Color #1 | Color #2 | Part | Location | Concern | [NAME] | Rank | Grid Label | Responsible Area | Responsible Cell | Recording User | Recording Area | Recording Cell | Recording Station | Defect Status | Root Cause | Root Cause User | Comments | sequence no | 1st | 2nd | 3rd | Date | Station | OP |  |  | 1st session | 2nd session | 3rd session
2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16L |  |  | 16L
3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16l | IF(AH3=1,VLOOKUP(AL3,AO1:AR52,2,FALSE),OR(AI=1,VLOOKUP(AL3,AO1:AR52,3,FALSE))
4
5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17L
6
7
8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 17R
9
10
11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21L
12
13
14 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21R
15
16
17 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22L
18
19
20 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23L
21
22
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 23R
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25L
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 25R
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 27L
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 27R
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 28R
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 29L
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 29R
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31R
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 32L
Spreadsheet: 469203d1467817429-3-worksheets-input-into-1-worksheet-change-log-1
Sheet: DON

DESIGNER | PROJECT | DATE RECEIVED | DATE RESPONSE REQUIRED | [NAME]
DW | GLEN ELLEN | 2016-06-10 00:00:00 | 2016-06-10 00:00:00 | OLD
DW | GLEN ELLEN | 2016-06-10 00:00:00 | 2016-06-10 00:00:00 | OLD
DW | GLEN ELLEN | 2016-06-10 00:00:00 | 2016-06-10 00:00:00 | OLD
DW | GLEN ELLEN | 2016-06-10 00:00:00 | 2016-06-10 00:00:00 | OLD
DW | GLEN ELLEN | 2016-06-10 00:00:00 | 2016-06-10 00:00:00 | OLD
DW | GLEN ELLEN | 2016-06-10 00:00:00 | 2016-06-10 00:00:00 | OLD
DW | GLEN ELLEN | 2016-06-10 00:00:00 | 2016-06-10 00:00:00 | OLD
DW | GLEN ELLEN | 2016-06-10 00:00:00 | 2016-06-10 00:00:00 | OLD
DW | GLEN ELLEN | 2016-06-10 00:00:00 | 2016-06-10 00:00:00 | OLD
DW | GLEN ELLEN | 2016-06-10 00:00:00 | 2016-06-10 00:00:00 | OLD
DW | GLEN ELLEN | 2016-06-10 00:00:00 | 2016-06-10 00:00:00 | OLD
DW | GLEN ELLEN | 2016-06-10 00:00:00 | 2016-06-10 00:00:00 | OLD
DW | GLEN ELLEN | 2016-06-10 00:00:00 | 2016-06-10 00:00:00 | OLD
DW | GLEN ELLEN | 2016-06-10 00:00:00 | 2016-06-10 00:00:00 | OLD
DW | GLEN ELLEN | 2016-06-10 00:00:00 | 2016-06-10 00:00:00 | OLD
DW | GLEN ELLEN | 2016-06-10 00:00:00 | 2016-06-10 00:00:00 | OLD
DW | GLEN ELLEN | 2016-06-10 00:00:00 | 2016-06-10 00:00:00 | OLD
DW | GLEN ELLEN | 2016-06-10 00:00:00 | 2016-06-10 00:00:00 | OLD
DW | GLEN ELLEN | 2016-06-10 00:00:00 | 2016-06-10 00:00:00 | OLD
DW | GLEN ELLEN | 2016-06-10 00:00:00 | 2016-06-10 00:00:00 | OLD
DW | GLEN ELLEN | 2016-06-10 00:00:00 | 2016-06-10 00:00:00 | OLD
DW | GLEN ELLEN | 2016-06-10 00:00:00 | 2016-06-10 00:00:00 | OLD
DW | GLEN ELLEN | 2016-06-10 00:00:00 | 2016-06-10 00:00:00 | OLD
DW | GLEN ELLEN | 2016-06-10 00:00:00 | 2016-06-10 00:00:00 | OLD
Spreadsheet: 204257d1357411204-filter-a-column-for-specific-value-and-creates-a-list-from-the-corresponding-rows-classregistry
Sheet: Stats

Roll No. | Name |  | Enrolled
Spreadsheet: 111803d1308087178-merging-two-worksheets-and-setting-a-migration-date-merge-excel-worksheets3
Sheet: Sports Players

Name | Testing | Migration Date | Helper | Final Answer
[NAME] | a
[NAME] | b
[NAME] | c
[NAME] | d
[NAME] | e
[NAME] | f
[NAME] | g | 2011-06-06 00:00:00
[NAME] | h
[NAME] | i
[NAME] | j
[NAME] | k
[NAME] | l | 2011-06-10 00:00:00
Dirk Notitzki | m | 2011-06-13 00:00:00
[NAME] | n
Jean-Sebastien Giguere | o | 2011-06-14 00:00:00
[NAME] | p | 2011-06-14 00:00:00
[NAME] | q
[NAME] | r
Spreadsheet: tracy_geaccone__40453__Carryover from 2000
Sheet: IBIT Adj

Adjusted 2000 IBIT
NNG
2000 IBIT per December Forecast |  |  |  |  | 250.4
 | Adjustments That Have Been Booked
Dec. Margins |  |  |  |  | 2.6
Adjustment to gain on Cooper Inventory Sale |  |  |  |  | -4.5
NW Alaska Pipeline Indemnification |  |  |  |  | -0.5
Prepayment of Mobil |  |  |  |  | -1.5
SAP Reserve will not be reversed |  |  |  |  | -1.1
DOT User Fees paid in December |  |  |  |  | -1.3
Severance Pay accrual |  |  |  |  | -0.5
Home Purchase work order write-offs |  |  |  |  | -0.2
Write-off of obsolete inventory |  |  |  |  | -0.3
Property Tax Accrual Adjustment |  |  |  |  | -0.3
Accrual of under-billed EIS charges |  |  |  |  | -0.4
W/O of Base Gas Arrangement Fees |  |  |  |  | -0.3
Other O&M Variances |  |  |  |  | 1.4
Other |  |  |  |  | -1.2
 | Subtotal
Adjusted 2000 IBIT
 | Other Available Adjustments
Qtrly Capitalization of Specialized Overheads |  |  |  |  | 0.7
Write-off of unamortized arrangement fees |  |  |  |  | -0.3
Reverse SAP reserve |  |  |  |  | 1.1
Put Mobil Prepay back on B/S |  |  |  |  | 1.5
 | Subtotal Other Available Adjustments
TW
2000 IBIT per December Forecast |  |  |  |  | 99.8
 | Adjustments That Have Been Booked
Dec. Margins |  |  |  |  | 0.6
Dec. Fuel |  |  |  |  | 3.3
SAP Reserve will not be reversed |  |  |  |  | -0.3
DOT User Fees paid in December |  |  |  |  | -0.2
Severance Pay accrual |  |  |  |  | -0.1
Property Tax Accrual Adjustment |  |  |  |  | -0.2
Accrual of under-billed EIS charges |  |  |  |  | -0.1
Depreciation |  |  |  |  | 1.4
Other O&M Variances |  |  |  |  | -0.5
 | Subtotal
Adjusted 2000 IBIT
 | Other Available Adjustments
Qtrly Capitalization of Specialized Overheads |  |  |  |  | 0.1
Reverse SAP reserve |  |  |  |  | 0.3
 | Subtotal Other Available Adjustments
Spreadsheet: 715751d1611851217-sum-on-a-pivot-table-column-with-multiple-criteria-match-person-between-two-dates-summing-values-by-month-using-pt-or-formula-jcyr55-
Sheet: Sheet1

Sum of Allocation | End Date
Team Member | Feb | Mar | May | Jun | Jul | Oct | Dec
[NAME] | 0.39 |  |  | 0.35 | 0.35
[NAME] | 0.35 |  | 1.04 | 0.54 | 0.04
[NAME] |  |  | 0.5 | 1
[NAME] |  |  | 1
Ellen | 0.45 |  | 0.27 | 0.72 | 0.37 |  | 0.27
[NAME] |  |  | 0.1 | 1
[NAME] | 0.7799999999999999 |  | 0.34 | 0.8899999999999999 | 0.04
[NAME] | 0.39 |  | 0.35 | 0.39 | 0.35 |  | 0.35
[NAME] | 0.04 |  | 0.35 | 0.04 | 0.35 |  | 0.35
[NAME] |  |  |  | 1
[NAME] | 0.35 |  |  | 0.7 | 0.04 | 0.1
[NAME] |  |  | 1 | 0.08
[NAME] | 0.39 |  | 0.04 | 0.4299999999999999 |  | 0.35 | 0.04
[NAME] | 0.08 |  |  | 0.04 | 0.35
Troy |  | 0.35 | 1 | 0.1 |  | 0.35
Unassigned |  |  |  | 0.04 | 0.04 |  | 0.04
Spreadsheet: 764249d1642662661-index-required-by-matching-two-columns-index-with-match-two-columns
Sheet: Sheet2

Category | Grade | Slab
Category-A | Outstanding | 0.15
Category-A | Very Good | 0.12
Category-A | Good | 0.105
Category-A | Average | 0.06
Category-A | Below Average | 0
Category | Grade | Increment
Category-B | Outstanding | 0.12
Category-B | Very Good | 0.096
Category-B | Good | 0.08399999999999999
Category-B | Average | 0.048
Category-B | Below Average | 0
Category | Grade | Increment
Category-C | Outstanding | 0.1
Category-C | Very Good | 0.08000000000000002
Category-C | Good | 0.06999999999999999
Category-C | Average | 0.04000000000000001
Category-C | Below Average | 0
Category | Grade | Increment
Category-D | Outstanding | 0.08
Category-D | Very Good | 0.064
Category-D | Good | 0.05599999999999999
Category-D | Average | 0.032
Category-D | Below Average | 0
Spreadsheet: 840833d1693024973-index-match-returning-duplicate-results-example
Sheet: Data Rank

Top 10 Stores |  |  | Store | Result
Store | Results |  | UT 54th & Redwood | 36
 |  |  | UT Fort Union | 13
 | 99 |  | UT Kimball Junction | 29
 | 70 |  | UT Olympus Cove | 18
 | 63 |  | UT Park City | 7
 | 63 |  | UT Sugarhouse Center | 55
 | 55 |  | UT Tooele | 45
 | 46 |  | UT West Bountiful | 46
 | 45 |  | UT West Valley | 106
 | 45 |  | UT Woods Cross | 45
 | 39 |  | UT Draper | 37
 |  |  | UT Heber City | 27
Top 10 Stores |  |  | UT Lehi | 22
Store | Results |  | UT N State St | 18
 |  |  | UT Orem | 23
 | 23 |  | UT Payson | 28
 | 22 |  | UT [NAME] | 39
 | 22 |  | UT Richfield | 22
 | 18 |  | UT Riverton | 37
 | 18 |  | UT Spanish Fork | 99
 | 18 |  | ID Burley | 35
 | 13 |  | ID Hailey | 30
 | 8 |  | ID Pocatello | 70
 | 7 |  | ID Rexburg | 23
 |  |  | UT [NAME] | 30
 |  |  | UT Ogden | 63
 |  |  | UT Riverdale | 18
 |  |  | UT Sardine Canyon | 8
 |  |  | UT South Logan | 35
 |  |  | UT Station Park | 63