tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 828521d1683564223-sum-fte-counts-by-month-between-two-dates-test
Sheet: Schedule

 |  |  |  |  | 2023-10-31 00:00:00
 | Project Start Date | 2023-10-01 00:00:00 |  |  |  | Display Week | 2
 | Project Lead |  |  |  |  | FTE Wrap-Rate | 250000
WBS | TASK | SYSTEM | FTE | START | END | DAYS | % DONE | WORK DAYS
 | [Task Category] |  |  |  | 2023-12-31 00:00:00
 | [Task] |  | 5.5 | 2023-10-05 00:00:00 | 2023-11-03 00:00:00 | 225 | 0.85
 | [Task] |  | 6 |  |  | 58 | 0
 | [Task] |  |  |  |  |  | 0
 | [Task] |  |  |  |  |  | 0
 | [Task] |  |  |  |  |  | 0
 | [Task] |  |  |  |  |  | 0
 | [Task] |  |  |  |  |  | 0
 | [Task Category]
 | [Task]
 | [Task]
 | [Task]
 | [Task]
 | [Task]
 | [Task Category]
 | [Task]
 | [Task]
 | [Task]
 | [Task]
 | [Task]
 | [Task Category]
 | [Task]
 | [Task]
 | [Task]
 | [Task]
 | [Task]
[NAME] new rows above this one.
TEMPLATE ROWS
See the Help worksheet to learn how to use these rows. You can hide these rows before printing.
 | [ Level 1 Task or Phase ]
 | . [ Level 2 Task ]
 | . . [ Level 3 Task ]
 | . . . [ Level 4 Task ]
Spreadsheet: 703922d1605234217-conditional-formatting-a-range-of-cells-based-on-a-range-of-cells-on-another-sheet-schedule-opening-week-15-21
Sheet: Dining Room

Schedule - Dining Room
Holidays/Events | EMPLOYEE MEETING |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LOUNGE OPENING
Reservations/Banquets
Hotel Occupancy %
November | 2020-11-22 00:00:00 |  |  |  | 2020-11-23 00:00:00 |  |  |  | 2020-11-24 00:00:00 |  |  |  | 2020-11-25 00:00:00 |  |  |  | 2020-11-26 00:00:00 |  |  |  | 2020-11-27 00:00:00 |  |  |  | 2020-11-28 00:00:00
 | Sunday |  |  |  | Monday |  |  |  | Tuesday |  |  |  | Wednesday |  |  |  | Thursday |  |  |  | Friday |  |  |  | Saturday
Name | In | Out | hrs | hrs | In | Out | hrs | hrs | In | Out | hrs | hrs | In | Out | hrs | hrs | In | Out | hrs | hrs | In | Out | hrs | hrs | In | Out | hrs | hrs |  | Total
Akpik, [NAME] |  |  |  |  | 15:00:00 | 15:30:00
Bourgaize, [NAME]
Carbonneau, [NAME] |  |  |  |  | 15:00:00 | 23:00:00 |  |  | 15:00:00 | 23:00:00 |  |  | 15:00:00 | 23:00:00 |  |  | 15:00:00 | 23:00:00 |  |  | 15:00:00 | 23:00:00
[NAME], Harley
Cloutier-Ellsworth, Mister
D'argencourt, Katia
Dunford, Annie-Laurie
Eaton, [NAME] |  |  |  |  |  |  |  |  | 15:00:00 | 18:00:00
Freda, [NAME]
Kasaluak, Maria |  |  |  |  | 16:00:00 | 22:00:00
McNeil, Lauren |  |  |  |  | 16:00:00 | 22:00:00
Merritt, [NAME] |  |  |  |  | 16:00:00 | 22:00:00
Nobiss, Kaitlyn
Nowdlak, Haali
Okalik, Nathalia
Paquette, Darya |  |  |  |  | 15:00:00 | 22:00:00 |  |  | 15:00:00 | 22:00:00 |  |  | 15:00:00 | 22:00:00 |  |  | 15:00:00 | 22:00:00 |  |  | 15:00:00 | 22:00:00 |  |  | 15:00:00 | 22:00:00
Perez, Daylen
[NAME], Jared
Total Day
Spreadsheet: 887436d1737664448-spill-formula-to-split-data-to-3-tabs-based-on-several-criteria-aging-dec-24
Sheet: Table Summary

 |  | Shawn
 |  | Shawn | A Consumer Services
 |  | [NAME] | A HBH
 |  | [NAME] | A SaaS
 |  | Shawn | A Other
 |  | [NAME] | A LG Funnel
 |  | [NAME] | A Insurance
 |  | [NAME] | C Consumer Services
 |  | [NAME] | C Insurance
 |  | [NAME] | C Accelerator
 |  | Shawn | C SaaS
 |  | [NAME] | C Lending & Banking
 |  | Shawn | A Accelerator
 |  | Shawn | C HBH
 |  | Shawn | B Insurance
Spreadsheet: 102002d1300069232-table-ladder-with-high-score-can-move-the-formulas-poker-ex-1-
Sheet: Sheet2

 | Top Names | [NAME]
2009-06-10 00:00:00 | [NAME] | 5
2009-06-17 00:00:00 | [NAME] | 4
2009-06-20 00:00:00 | [NAME] | 3
2009-06-20 00:00:00 | [NAME] | 3
2009-06-24 00:00:00 | [NAME] | 2.5
2009-06-27 00:00:00 | [NAME] | 2
Spreadsheet: 104622d1302161068-vba-code-create-new-sheets-and-name-them-dummy
Sheet: Sheet1

 | Invoice No | Name | Amount | Paid | Date
 | 10332 | Smith |  | Yes | 2011-03-12 00:00:00
 |  | [NAME] | 335 | No
 |  | [NAME]
Spreadsheet: 701216d1603629117-count-consecutive-values-sample-4
Sheet: Sheet3

Positive | Negative | False/Fail | 1 | Answer Im Looking for
 | 1 |  |  |  |  | I want to count the number of times Column B has a value, while ignoring the values in Column C , A value I Column A is what halts the sequence. AliGW was good enough to write the formula in yellow for me for a totally different application . I have been trying to get it to work hear with helper rows etc , but Im stuck Answers Im after are in Column E--Thanks in anticipation
1
 |  | 1
 |  | 1
 | 1
 | 1
 |  | 1
 | 1
 | 1
 | 1 |  |  | 5
 |  | 1
 |  | 1
 |  | 1
1
 | 1
 |  | 1
 | 1
 | 1 |  |  | 3
1
1
 | 1
 | 1
 | 1
 |  | 1
 | 1
 | 1
 | 1 |  |  | 6
Spreadsheet: joe_parks__14915__3-29-02 Gas Cash
Sheet: Log

5 Day Rolling Cash Forecast:  Payment Log as of Mar-29-02
Payment Date | Amount | Deal Name | Counterparty | Commercial Contact | Physical or Financial? | Transaction Description
2002-04-01 00:00:00 | -228250 | Centana | JPMorgan | [NAME] | Phys | Pmt related to sale of Centana storage gas.  Funds to come from $2.7 MM sale above.  Note revised amount and payment date.
2002-04-02 00:00:00 | -279636.3810000001 | Florida Gas Transmission | Florida Gas Transmission | [NAME] | Phys | Pmt of post capacity release demand charges related to FGT contracts 5879, 6020, and 6089.  Amount is still and estimate, and is pending response from FGT.
2002-04-03 00:00:00 | -5313 | Bear Creek Storage | Bear Creek Storage | [NAME] | Phys | Reservation and commodity charges.  Note that this is still an estimated amount.  Cash request still pending.
2002-04-04 00:00:00 | -40000 | City of Tallahassee | Reliant Energy Services | [NAME] | Phys | Estimated swing gas prepay.
Spreadsheet: 719867d1613858269-if-statement-to-produce-value-if-cell-exceeds-45-rota-_-labour-margins-fault-with-overtime
Sheet: Sheet1

STAFF ROTA |  |  | WK |  |  |  |  |  |  |  |  |  |  |  |  | CALCULATE LABOUR HOURS |  |  |  |  |  |  |  |  | [NAME] STAFF
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | INSERT DATA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HOURLY STAFF
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NAME | GROSS HOURS | WEEKLY SALARY | WAGE HOURLY | COST | NET HOURS | O/T HOURS +45 | O/T COST
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hours Minus Breaks | Salary Hours over 45 | Overtime
 | MONDAY |  | TUESDAY |  | WEDNESDAY |  | THURSDAY |  | FRIDAY |  | SATURDAY |  | SUNDAY
Manager | 09:00:00 |  | 09:00:00 |  | 09:00:00 |  | 09:00:00 |  | 09:00:00 |  |  |  |  |  |  |  |  |  | 10 |  |  | 0
 | 17:00:00 |  | 17:00:00 |  | 17:00:00 |  | 17:00:00 |  | 17:00:00
Supervisor | 17:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10
 | 1900-01-01 00:00:00
B1 | 09:00:00 |  | 09:00:00 |  | 09:00:00 |  | 09:00:00 |  | 09:00:00 |  | 09:00:00 |  | 09:00:00 |  |  |  |  |  | 8
 | 17:00:00 |  | 17:00:00 |  | 17:00:00 |  | 17:00:00 |  | 17:00:00 |  | 17:00:00 |  | 17:00:00
B2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
B3
B4
B5
B6
HK
HK
DOOR
DOOR
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LABOUR FIGURES
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL HOURS HOURLY
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL WAGES HOURLY
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL HOURS SALARY
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL WAGES SALARY
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL OVERTIME HOURS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL OVERTIME WAGES
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL LABOUR COST
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AGREED WEEKLY BUDGET |  |  |  | 2000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | VARIATION
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ACCOUNTANT
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ACTUAL LABOUR COSTS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | PROJECTED SALES |  |  |  | 10000 |  | ACTUAL SALES
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ACTUAL LABOUR COSTS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LABOUR % |  |  |  |  |  | ACTUAL LABOUR %
Spreadsheet: 468970d1467704761-copy-paste-special-between-sheets-problem1
Sheet: 1jan

 |  | st rita2 |  |  |  | kontich |  |  |  | [NAME] | rumst
 |  | 9,98/u | 13,26/u |  | 13,26/u | 9,98/u | 13,26/u | 13,26/u | 6,63/u | 20/u | 14/u | 14/u
 |  | 24.95 | 19.89 |  | 33.15 | 19.96 | 26.52 | 33.15 | 16.58 | 70 | 35 | 24.5
 |  | za | za | woe | di | za | za | di | do | ma | zo | woe
 |  | 9-11.30 | 11.30-13 | 13-15 | 20-22.30 | 9-11 | 11-13 | 20-22.30 | 20-22.30 | 19-22.30 | 19-21.30 | 20.30-22.15
vr | 2015-01-01 00:00:00
za | 2015-01-02 00:00:00
zo | 2015-01-03 00:00:00 |  |  |  |  |  |  |  |  |  | x
ma | 2015-01-04 00:00:00 |  |  |  |  |  |  |  |  | ok
di | 2015-01-05 00:00:00 |  |  |  | ok
wo | 2015-01-06 00:00:00 |  |  |  |  |  |  |  |  |  |  | [NAME]
do | 2015-01-07 00:00:00 |  |  |  |  |  |  |  | ok
vr | 2015-01-08 00:00:00
za | 2015-01-09 00:00:00 | ok k | ok
zo | 2015-01-10 00:00:00 |  |  |  |  |  |  |  |  |  | x
ma | 2015-01-11 00:00:00 |  |  |  |  |  |  |  |  | ok
di | 2015-01-12 00:00:00 |  |  |  | npok
wo | 2015-01-13 00:00:00 |  |  |  |  |  |  |  |  |  |  | [NAME]
do | 2015-01-14 00:00:00 |  |  |  |  |  |  |  | ok
vr | 2015-01-15 00:00:00
za | 2015-01-16 00:00:00 | ok | ok
zo | 2015-01-17 00:00:00
ma | 2015-01-18 00:00:00 |  |  |  |  |  |  |  |  | ok
di | 2015-01-19 00:00:00 |  |  |  | npok
wo | 2015-01-20 00:00:00 |  |  |  |  |  |  |  |  |  |  | [NAME]
do | 2015-01-21 00:00:00 |  |  |  |  |  |  |  | ok
vr | 2015-01-22 00:00:00
za | 2015-01-23 00:00:00 | ok | ok
zo | 2015-01-24 00:00:00 |  |  |  |  |  |  |  |  |  | x
ma | 2015-01-25 00:00:00 |  |  |  |  |  |  |  |  | ok
di | 2015-01-26 00:00:00 |  |  |  | npok
wo | 2015-01-27 00:00:00 |  |  |  |  |  |  |  |  |  |  | [NAME]
do | 2015-01-28 00:00:00 |  |  |  |  |  |  |  | ok
vr | 2015-01-29 00:00:00
za | 2015-01-30 00:00:00 | ok | ok
zo | 2015-01-31 00:00:00 |  |  |  |  |  |  |  |  |  | x
Spreadsheet: 115098d1310727149-accurate-calculation-of-the-difference-between-two-dates-hopefully-the-best-date-difference-calculator-ever
Sheet: Sheet3

Number of leap years between two dates
Date1 | 1997-03-30 00:00:00
Date2 | 2008-03-28 00:00:00
When is the next leap year from date1
Date1 year
+1
+2
+3
+4
+5
+6
+7
+8
+9
+10
+11
+12
+13
+14
+15
+16
[NAME]
+18
+19
+20
+21
+22
+23
+24
+25
+26
+27
+28
+29
+30
+31
+32
+33
+34
+35
+36
+37
+38
[NAME]
[NAME]
+41
[NAME]
+43
+44
+45
+46
+47
+48
+49
+50
+51
+52
+53
+54
+55
+56
+57
+58
+59
+60
+61
+62
+63
+64
+65
+66
+67
+68
+69
+70
+71
+72
+73
+74
+75
+76
+77
+78
+79
+80
+81
+82
+83
+84
[NAME]
+86
[NAME]
+88
+89
+90
+91
+92
Spreadsheet: 57267d1257380033-unable-to-make-match-certain-values-sanitized-calc
Sheet: CPI

CPI
 | Total | NY | CH | LA | SF | AT | LV | PH | HO | DA
2009-06-01 00:00:00 | 0.2661367069154671 | 0.2318010083925487 | 0.2529888987045307 | 0.2392124390254866 | 0.2720359746471365 | 0.3348904889003443 | 0.3080476791310945 | 0.2747692056537085 | 0.2088412690483501 | #N/A
2009-07-01 00:00:00 | 0.2630147196962853 | 0.2278003682458344 | 0.256256427520099 | 0.2331664991867537 | 0.2723559994083393 | 0.3250981178639211 | 0.3029027440948017 | 0.2669866339523669 | 0.2162004875341956 | 0.1896645547020269
2009-08-01 00:00:00 | 0.2665253190332735 | 0.2327644004628849 | 0.2584643916151797 | 0.2443987854583113 | 0.2720678089614499 | 0.3265855637244301 | 0.3051429987140418 | 0.2709186472560744 | 0.2228233402335058 | 0.2097038243778303
2009-09-01 00:00:00 | 0.2661453470562131 | 0.2351668952703171 | 0.2555351540685147 | 0.2543345415302143 | 0.2656275553666579 | 0.3280462172863001 | 0.3019006561265181 | 0.2660816543311247 | 0.228127765737423 | 0.2249492001086263
2009-10-01 00:00:00 | 0.2656300462399634 | 0.2357387196264396 | 0.252915292591927 | 0.2536486738573634 | 0.2677531248701999 | 0.3289364893853897 | 0.2988917947175042 | 0.2612371052476838 | 0.2238105522012021 | 0.2389144001888063
2009-11-01 00:00:00 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
2009-12-01 00:00:00 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Spreadsheet: 1c238db8-173c-498c-9563-f4eb6bbf25d2
Sheet: 7a

Product1 | Cleared2 | Uncleared | TOTAL
Fixed-Float | 124710283 | 70076301 | 194786584
FRA | 52356684 | 8907787 | 61264470
OIS | 32051562 | 10213612 | 42265174
Swaption | 0 | 20058076 | 20058076
OTHER* | 6766248 | 24898642 | 31664891
TOTAL
* OTHER variable includes the following products: Basis, Cap/Floor, Debt Option, Exotic, Fixed-Fixed, and Inflation.
Spreadsheet: 109858d1306670636-countif-and-using-wildcard-general-liability-montly-audit-forum
Sheet: Form

Week | No. of Employee over 300 | LA Actual | AL Actual | Texas Actual
Week 1
Week 2
Week 3
Week 4
Week 5
Week 6
Week 7
Week 8
Week 9
Week 10
Week 11
Week 12
Week 13
Week 14
Week 15
Week 16
Week 17
Week 18
Week 19
Week 20
Week 21
Week 22
Week 23
Week 24
Week 25
Week 26
Week 27
Week 28
Week 29
Week 30
Week 31
Week 32
Week 33
Week 34
Week 35
Week 36
Week 37
Spreadsheet: 09d40ff4-05d0-47f0-b6a8-8c5ce94a414f
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
7132 | 30439 | Joleen | Hakker B1 | NED | 5 | 00:17:04 | 00:02:58 | 00:32:02 | 00:01:10 | 00:23:42 | 1 | 01:16:57
7132 | 50580 | [NAME] | [NAME] | GBR | 6 | 00:14:05 | 00:01:45 | 00:38:38 | 00:00:54 | 00:22:19 | 2 | 01:17:41
7132 | 40701 | [NAME] | Rodriguez | ESP | 9 | 00:15:35 | 00:02:13 | 00:35:37 | 00:01:06 | 00:23:12 | 3 | 01:17:42
7132 | 30795 | Sara | Butler | GBR | 7 | 00:14:00 | 00:01:26 | 00:00:00 | 00:00:00 | 00:00:00 | DNF | 00:00:00
Spreadsheet: 6350764d-fea7-464b-a78d-e83a755e20cc
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
8081 | 52738 | [NAME] | [NAME] | GBR | 0 | 00:18:02 | 00:01:17 | 00:34:16 | 00:01:26 | 00:10:33 | 1 | 01:05:32
8081 | 13586 | Dino | Beretta | ITA | 0 | 00:18:49 | 00:01:11 | 00:34:41 | 00:01:09 | 00:11:10 | 2 | 01:06:59
8081 | 12392 | Miroslav | Krsek | CZE | 0 | 00:19:12 | 00:01:32 | 00:34:01 | [NAME] | [NAME] | 3 | 01:07:29
8081 | 52801 | Trefor | Morgan | GBR | 0 | 00:26:02 | 00:01:55 | 00:38:37 | 00:01:52 | 00:15:10 | 4 | 01:23:33
8081 | 57245 | Jo | [NAME] | NED | 0 | 00:26:31 | 00:01:57 | 00:42:06 | 00:01:59 | 00:15:47 | 5 | [NAME]
Spreadsheet: 236701d1368956333-auto-list-depending-on-code-entered-lw-example
Sheet: Sheet1

 | Trade price | Colourways | Colour list
Accessories 3
LA0100 | 55
LA0101 | 95
LC1390 | 12.5
LC1391 | 12.5 | 2 | 1 Blue circus | 2 Pink circus
LC1392 | 12.5 | 1 | [NAME]
LC1393 | 12.5 | 1 | Control Freak
LC1394 | 12.5 | 1 | Doggie Sports Day
LC1395 | 12.5 | 3 | [NAME] | [NAME] | [NAME]
LC1396 | 12.5 | 1 | Robots and Friends
LC1397 | 12.5 | 1 | Dream House
LC1398 | 12.5 | 1 | Shoes and more Shoes
LC1399 | 12.5 | 1 | Danger keep out
LC1400 | 12.5 | 1 | [NAME]
LC1401 | 12.5 | 1 | Rock n Roll
LC1402 | 12.5 | 1 | Babushka
LC1405 | 12.5 | 1 | Skull check
LC1406 | 12.5 | 1 | Heart check
LC1407 | 12.5 | 1 | London check
LC1408 | 12.5 | 1 | Car check
LC1409 | 12.5 | 1 | [NAME] check
Amaya
LF1287C | 25.95 | 5 | 1 Bianco | 2 Tea Light | 3 Coraline | 4 Pale mint | 5 Twilight
LF1288C | 25.95 | 5 | 1 Moonshine | 2 Sand dune | 3 Sorrento | 4 Duck egg | 5 Pitch
LF1289C | 25.95 | 6
LF1290C | 25.95 | 7
LF1291C | 25.95 | 4
LF1292C | 25.95 | 6
LF1317FR | 28.7 | 5 | 1 Bianco | 2 Tea Light | 3 Coraline | 4 Pale mint | 5 Twilight
LF1318FR | 28.7 | 5 | 1 Moonshine | 2 Sand dune | 3 Sorrento | 4 Duck egg | 5 Pitch
Spreadsheet: 863105d1710671492-extracting-unique-data-from-repeating-parameters-in-excel-dynamic-approach-needed-nilaakash-aligw
Sheet: Sheet1

Parameter-a | Parameter-b | Data |  | AliGW | [NAME] set |  | Data output ([NAME]) |  |  |  |  | Average | Median | Standard Deviation
a1 | b1 | 75 |  | (fully dynamic) |  | b1 | 75 | 92
a1 | b1 | 92 |  |  | a1 | b2 | 61 | 31 | 75 |  |  | 55.66666666666666 | 61 | 18.35453319724827
a1 | b2 | 61 |  |  | a2 | b1 | 82 | 1931 | 1808 |  |  | 1273.666666666667 | 1808 | 844.1304533199961
a1 | b2 | 31 |  |  | a2 | b2 | 2575 | 1350 | 1268 | 1105 |  | 1574.5 | 1309 | 584.331455596907
a1 | b2 | 75
a2 | b1 | 82
a2 | b1 | 1931
a2 | b1 | 1808
a2 | b2 | 2575 |  | Your code |  | b1 | 75 | 92
a2 | b2 | 1350 |  | (dynamic) | a1 | b2 | 61 | 31 | 75
a2 | b2 | 1268 |  |  | a2 | b1 | 82 | 1931 | 1808
a2 | b2 | 1105 |  |  | a2 | b2 | 2575 | 1350 | 1268 | 1105
Spreadsheet: louise_kitchen__24128__Netco_Status
Sheet: Sheet1

Status as of 5:00 pm Thursday, January 3, 2002
Group |  | Who contacted |  | Status
Fin Ops |  | [NAME], [NAME] |  | Updated
Cash Operations |  | [NAME] |  | Updated
Tax |  | [NAME] |  | Updated
Regulatory Affairs |  | [NAME] |  | Updated
Credit |  | [NAME] |  | Updated
Research/Market Risk |  | [NAME] ([NAME]) |  | No changes per [NAME]. [NAME] out until Friday, but [NAME] was going to speak to him.
Energy Ops |  | [NAME] |  | Out of the office with the [NAME];  will return on the 4th
HR |  | [NAME] |  | Updated
IT - Infrastructure |  | [NAME] |  | Updated
IT - Development/EOL |  | [NAME] ([NAME]) |  | Updated
Canada Support |  | [NAME] |  | [NAME] will not submit until the morning of the 4th
Legal |  | [NAME] ([NAME]) |  | Updated
CABC |  | [NAME] |  | Updated
Weather |  | [NAME] |  | Updated
Canada Commercial |  | [NAME] |  | [NAME] will not submit until the morning of the 4th
East Power Trading |  | [NAME] |  | Updated
East Power Origination |  | [NAME] |  | Updated
Fundies |  | [NAME] |  | Updated
Structuring |  | [NAME] |  | Updated
Texas Gas Trading |  | [NAME] |  | Updated
East Gas Trading |  | [NAME] |  | Updated
Central Gas Trading |  | [NAME] |  | Updated
West Gas Trading |  | [NAME] |  | Updated
Financial Gas Trading |  | [NAME] |  | Updated
Texas Gas Origination |  | [NAME] |  | Updated
East Gas Origination |  | [NAME] |  | Updated
Central Gas Origination |  | [NAME] |  | Updated
West Gas Origination |  | [NAME] |  | Updated
Derivatives |  | [NAME] |  | Updated
Mexico |  | [NAME] |  | Updated
West Power Trading |  | [NAME] |  | Updated
West Power Orig |  | [NAME] |  | Updated
Spreadsheet: 867889d1714655522-vlookup-in-date-range-new-project
Sheet: 02

 |  | 1st Qtr |  |  | Number | Date |  | Start Date
No. | Date | No. | Date |  | 801 | 2024-01-09 00:00:00 |  | End Date
801 |  | 901 |  |  | 802 | 2024-03-12 00:00:00
802 |  | 902 |  |  | 803 | 2024-02-08 00:00:00
803 |  | 903 |  |  | 804 | 2024-01-22 00:00:00
804 |  | 904 |  |  | 805 | 2024-03-23 00:00:00
805 |  | 905 |  |  | 806 | 2024-03-15 00:00:00
806 |  | 906 |  |  | 807 | 2024-03-16 00:00:00
807 |  | 907 |  |  | 808 | 2024-02-03 00:00:00
808 |  | 908 |  |  | 809 | 2024-03-14 00:00:00
809 |  | 909 |  |  | 810 | 2024-01-28 00:00:00
810 |  | 910 |  |  | 811 | 2024-02-01 00:00:00
811 |  | 911 |  |  | 812 | 2024-03-03 00:00:00
812 |  | 912 |  |  | 813 | 2024-01-27 00:00:00
813 |  | 913 |  |  | 814 | 2024-03-17 00:00:00
814 |  | 914 |  |  | 815 | 2024-01-24 00:00:00
815 |  | 915 |  |  | 816 | 2024-03-29 00:00:00
816 |  | 916 |  |  | 901 | 2024-03-21 00:00:00
 |  |  |  |  | 902 | 2024-02-06 00:00:00
 |  |  |  |  | 903 | 2024-02-05 00:00:00
 |  |  |  |  | 904 | 2024-03-02 00:00:00
 |  |  |  |  | 905 | 2024-03-28 00:00:00
 |  |  |  |  | 906 | 2024-03-27 00:00:00
 |  |  |  |  | 907 | 2024-01-03 00:00:00
 |  |  |  |  | 908 | 2024-01-27 00:00:00
 |  |  |  |  | 909 | 2024-01-25 00:00:00
 |  |  |  |  | 910 | 2024-02-26 00:00:00
 |  |  |  |  | 911 | 2024-03-11 00:00:00
 |  |  |  |  | 912 | 2024-03-25 00:00:00
 |  |  |  |  | 913 | 2024-03-21 00:00:00
 |  |  |  |  | 914 | 2024-02-08 00:00:00
 |  |  |  |  | 915 | 2024-01-29 00:00:00
 |  |  |  |  | 916 | 2024-02-29 00:00:00
 |  |  |  |  | 801 | 2024-04-10 00:00:00
 |  |  |  |  | 802 | 2024-04-15 00:00:00
 |  |  |  |  | 803 | 2024-04-01 00:00:00
Spreadsheet: 726377d1617201309-automatically-shift-data-in-cells-according-to-date-change-sliding-dates-referencing-input-table-manishman-
Sheet: Sheet3

 |  |  |  | DAYS:
 |  |  |  | Agent 1
 |  |  |  | Agent 2
 |  |  |  | Total
 |  |  |  | Sun-Sat
 |  |  |  | Mon-Sun
 |  |  |  | Tue-Mon
 |  |  |  | Wed-Tue
 |  |  |  | [NAME]
 |  |  |  | Fri-Thu
 |  |  |  | Sat-Fri
 |  |  |  | Sun-Sat
Spreadsheet: bc228119-c133-4ede-bda9-645cd4cc9ad9
Sheet: EPR EBITDA FCF

 |  | Quarters Ended |  |  |  | Six Months Ended
 |  | March 31, |  |  |  | March 31,
 | 2012 |  | 2011 |  | 2012 |  | 2011
Adjusted EBITDA
GAAP Income from continuing operations | 62.40000000000006 |  | 67.70000000000002 |  | 112.6999999999999 |  | 140.5000000000001
Other (income) expense, net | 21.2 |  | 23.3 |  | 42 |  | 41
Income tax provision | 34.4 |  | 37.1 |  | 63.2 |  | 66.8
Depreciation and amortization | 60.60000000000001 |  | 52.8 |  | 115.2 |  | 106.1
Other charges:
Share-based compensation | 8.5 |  | 10.9 |  | 16.7 |  | 22.3
Contingent acquisition related costs | 11.7 |  | 0 |  | 11.7 |  | 0
Adjusted EBITDA | 198.8000000000001 |  | 191.8 |  | 361.4999999999998 |  | 376.7000000000001
Adjusted EBITDA (income from continuing operations before interest and other non-operating income/expense-net, income tax provision, depreciation and amortization, and other charges noted in the reconciliation) is a supplemental non-GAAP financial measure commonly used by our management and industry analysts to evaluate our financial performance.  Adjusted EBITDA provides useful information to investors regarding our ability to service debt and is a commonly used financial analysis tool for measuring and comparing gaming companies in several areas of liquidity, operating performance, valuation and leverage.  Adjusted EBITDA should not be construed as an alternative to operating income (as an indicator of our operating performance) or net cash from operations (as a measure of liquidity) determined in accordance with GAAP (generally accepted accounting principles).  All companies do not calculate Adjusted EBITDA in the same manner, and IGT's presentation may not be comparable to that of other companies.
 |  |  |  |  |  | Six Months Ended
 |  |  |  |  |  | March 31,
 |  |  |  |  | 2012 |  | 2011
Free Cash Flow
GAAP net operating cash flows |  |  |  |  | 176.6999999999999 |  | 263.7000000000002
Investment in property, plant and equipment |  |  |  |  | -34.5 |  | -8.4
Investment in gaming operations equipment |  |  |  |  | -87.1 |  | -80.2
Investment in intellectual property |  |  |  |  | -2 |  | -0.7
Free Cash Flow (before dividends) |  |  |  |  | 53.09999999999991 |  | 174.4000000000001
Dividends paid |  |  |  |  | -35.7 |  | -35.8
Free Cash Flow (after dividends) |  |  |  |  | 17.39999999999991 |  | 138.6000000000001
Free cash flow is a supplemental non-GAAP financial measure commonly used by our management and industry analysts to evaluate the discretionary amount of operating cash flows.  Free cash flow should not be construed as an alternative to net operating cash flows or other cash flow measurements determined in accordance with GAAP (generally accepted accounting principles).  All companies do not calculate free cash flow in the same manner, and IGT's presentation may not be comparable to that of other companies.