tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: chris_dorland__1621__2002 Canadian Holidays - For Intranet
Sheet: Sheet1

2002 Holiday Schedule
Canada*
New Year's Day |  | Tuesday |  | 2001-01-01 00:00:00
Family Day |  | Monday |  | 2001-02-18 00:00:00
Good Friday |  | Friday |  | 2001-03-29 00:00:00
[NAME] |  | Monday |  | 2001-05-20 00:00:00
Canada Day |  | Monday |  | 2001-07-01 00:00:00
Civic Day |  | Monday |  | 2001-08-05 00:00:00
Labour Day |  | Monday |  | 2001-09-02 00:00:00
Thanksgiving |  | Monday |  | 2001-10-14 00:00:00
Christmas Day |  | Wednesday |  | 2000-12-25 00:00:00
Boxing Day |  | Thursday |  | 2000-12-26 00:00:00
In Lieu of Remembrance Day |  | Discretionary Day** |  | Discretionary Day**
(November 11th)
In Lieu of St. Jean Baptiste*** |  | Discretionary Day*** |  | Discretionary Day***
(June 24th)
* Includes employees in Alberta & Ontario & Quebec
** You may use a discretionary holiday at any time during the year with the approval of your supervisor.
*** Discretionary Day in Quebec in lieu of Remembrance Day
Spreadsheet: 46136d1245035221-if-function-formatting-issue-grater-than-less-than-between-if-function
Sheet: Sheet1

NES 1 | OSHA Adjusted Standard 1 | Action Level 1 | Sample Result 1 | Filter 1 for MM
10 | 8.39 | 4.2 | 2.9 |  | converted to number as per error message and formula works. All columns are in number format already?
3 | 2.52 | 1.26 | 1.3
10 | 5.83 | 2.92 | 8.6
10 | 5.83 | 2.92 | VOID
10 | 5.83 | 2.92 | 0.4
3.00 | 1.75 | 0.88 | 1.2 |  | [NAME] error message - Convert to Number Formula not working  The two in red should return OSHA breach in E17 & E18  The VOID is working  The result highlighted orange should return [NAME] in E14
10.00 | 5.83 | 2.92 | VOID
3.00 | 2.45 | 1.23 | 0.8
3.00 | 2.45 | 1.23 | 0.3
3.00 | 1.51 | 0.76 | 0.1
3.00 | 2.45 | 1.23 | 0.3
3.00 | 2.45 | 1.23 | 0.1
10.00 | 8.16 | 4.08 | 4.5
10.00 | 8.16 | 4.08 | 0.2
10.00 | 5.02 | 2.51 | 0.6
10.00 | 8.16 | 4.08 | 18
10.00 | 8.16 | 4.08 | 30
0.10 | 0.08 | 0.04 | 0.01
10.00 | 8.16 | 4.08 | 0.4
3.00 | 2.45 | 1.23 | 0.2
Spreadsheet: 281926d1386203123-auto-populate-excel-calendar-based-on-date-ranges-calendar-auto-populate
Sheet: PROJECT TRACKER

Project Name | START | End Projected | Duration
conversion | 2014-01-11 00:00:00 | 2014-01-21 00:00:00
migration | 2014-01-15 00:00:00 | 2014-01-22 00:00:00
Forensics | 2014-01-20 00:00:00 | 2014-01-23 00:00:00
IPv6 | 2014-01-23 00:00:00 | 2014-01-23 00:00:00
eXGW | 2014-02-01 00:00:00 | 2014-02-05 00:00:00
Brix | 2014-02-03 00:00:00 | 2014-02-25 00:00:00
ASCO | 2014-02-11 00:00:00 | 2014-02-25 00:00:00
7750 | 2014-02-20 00:00:00 | 2014-02-24 00:00:00
MME | 2014-02-25 00:00:00 | 2014-03-03 00:00:00
CMS | 2014-03-01 00:00:00 | 2014-03-10 00:00:00
3100 | 2014-03-05 00:00:00 | 2014-03-18 00:00:00
C27 | 2014-03-11 00:00:00 | 2014-03-15 00:00:00
QT 610 | 2014-03-12 00:00:00 | 2014-03-22 00:00:00
GT10 | 2014-03-16 00:00:00 | 2014-03-23 00:00:00
SNAP | 2014-03-21 00:00:00 | 2014-03-24 00:00:00
COIN | 2014-03-24 00:00:00 | 2014-03-24 00:00:00
01 EOL | 2014-04-02 00:00:00 | 2014-04-06 00:00:00
[NAME] | 2014-04-04 00:00:00 | 2014-04-26 00:00:00
JDSU | 2014-04-12 00:00:00 | 2014-04-26 00:00:00
MGX- | 2014-04-21 00:00:00 | 2014-04-25 00:00:00
OMPv4 | 2014-04-26 00:00:00 | 2014-05-02 00:00:00
Umpire | 2014-04-30 00:00:00 | 2014-05-09 00:00:00
4th PCF | 2014-05-04 00:00:00 | 2014-05-17 00:00:00
TAPS | 2014-05-10 00:00:00 | 2014-05-14 00:00:00
SHELF 7 | 2014-05-11 00:00:00 | 2014-05-21 00:00:00
SHELF 6 | 2014-05-15 00:00:00 | 2014-05-22 00:00:00
SHELF 5 | 2014-05-20 00:00:00 | 2014-05-23 00:00:00
ALU | 2014-05-23 00:00:00 | 2014-05-23 00:00:00
L-ESS | 2014-06-01 00:00:00 | 2014-06-05 00:00:00
SHELF 3 | 2014-06-03 00:00:00 | 2014-06-25 00:00:00
SHELF 4 | 2014-06-11 00:00:00 | 2014-06-25 00:00:00
EUGENE | 2014-06-20 00:00:00 | 2014-06-24 00:00:00
EVDO | 2014-06-25 00:00:00 | 2014-07-01 00:00:00
CRS3-16 | 2014-06-29 00:00:00 | 2014-07-08 00:00:00
ASR1 | 2014-07-03 00:00:00 | 2014-07-16 00:00:00
SOURCEFIRE | 2014-07-09 00:00:00 | 2014-07-13 00:00:00
NIKSUN | 2014-07-10 00:00:00 | 2014-07-20 00:00:00
Autotester | 2014-07-14 00:00:00 | 2014-07-21 00:00:00
BrSNAP | 2014-07-19 00:00:00 | 2014-07-22 00:00:00
7750Ld | 2014-07-22 00:00:00 | 2014-07-22 00:00:00
Netscout | 2014-07-31 00:00:00 | 2014-08-04 00:00:00
Spreadsheet: 660965d1580820707-conditional-format-formula-sample
Sheet: Sheet1

No. | Type | Starting Date | Ending Date | Amount | Client | Notes
 | New |  |  |  |  |  |  |  |  |  | New | Ahmed
 |  |  |  |  |  |  |  |  |  |  | Renewal | Mohamed
 | Renewal |  |  |  |  |  |  |  |  |  | Cancel | Mahmoud
 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 | Cancel |  |  |  |  |  |  |  |  |  |  | [NAME]
 | Renewal
Total
No. | Type | Starting Date | Ending Date | Amount | Client | Notes
 | New |  |  |  |  |  | I want to apply conditional format here to match above sample.
Total |  |  |  |  |  |  | For New type I want to color only A,B,D, and F cells on the same row.
 |  |  |  |  |  |  | For Renewal type I want to color only A,B,C,E, and G cells on the same row.
 |  |  |  |  |  |  | For Cancel type I want to color only A,B,C,E, F and G cells on the same row.
Spreadsheet: 783094d1654580319-check-if-value-on-one-sheet-exists-in-a-range-on-another-practice-vlookup-not-vlookup-aligw
Sheet: Sheet1

ID | IS IT ON SHEET 2?
5088
36702
39405
40167
41595
43575
43786
43794
43798
43801
Spreadsheet: 266302d1379578213-how-many-followup-made-by-a-salesman-between-a-particular-set-of-dates-help
Sheet: Sheet1

date | name | age | salesman |  |  | between dates
20130429 | VERMA | 29 | 4840374 |  |  | 20130401 | 20130731
20130429 | RAJAK | 47 | 4840374
20130515 | NEMA | 19 | 4840374 |  |  | salesman
20130515 | NEMA | 27 | 4840374 |  |  | 4840374 | 0
20130524 | BABBAR | 37 | 4840374 |  |  | 5842374 | 1
20130608 | THAKUR | 33 | 4840374
20130628 | BHAN | 38 | 4840374
20130715 | KHATRI | 5 | 4840374
20130726 | AGRAWAL | 27 | 4840374
20130810 | WADHAWA | 6 | 4840374
20130911 | BHASIN | 29 | 4840374
20130417 | GOHIYA | 24 | 5842374 |  |  | In this example salesman 4840374 met "nema" more than 1 time but the age dose not match hence they are different people.
20130417 | [NAME] | 26 | 5842374
20130513 | RAJAK | 38 | 5842374
20130715 | KOHLI | 39 | 5842374
20130715 | KOHLI | 39 | 5842374
20130715 | KOHLI | 39 | 5842374
20130717 | KOHLI | 39 | 5842374
20130717 | KOHLI | 39 | 5842374
20130731 | SEN | 24 | 5842374
Spreadsheet: 710331d1608847257-help-pulling-data-from-a-range-copy-of-attendance-template-w-formula
Sheet: October

Employee Absence Schedule
October | Dates of Absence
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
Employee 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 | CI | T | NCNS | Total Points
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Obed Attamah
[NAME]
[NAME]
Keath Grimes
[NAME]
[NAME]
[NAME]
[NAME]
Spreadsheet: 845868d1697193752-pulling-specific-customer-data-froma-lookup-sheet-into-another-sheet-how-to-excel-book
Sheet: RESULT SHEET

 | HOW TO LOOK UP DATA IN BELOW COLUMNS FROM DATA SHEET
 |  | A/C TITLE | A/C NUMBER | AMOUNT USD |  |  | SECURITY CODE | MATURITY DATE | ISSUE DATE
 | DEBIT | SETTLE A/C USD CERTIFICATES | [PHONE]
 |  | CUSTOMER NAME | CUSTOMER A/C # | AMOUNT TO BE CREDITED
1 | CREDIT | [NAME] |  |  |  |  | 371200-865
 | CREDIT | [NAME] |  |  |  |  | 371200-857
 | CREDIT | [NAME] |  |  |  |  | 371200-857
 | CREDIT | [NAME] |  |  |  |  | 372200-767
 | CREDIT | Natasha |  |  |  |  | 373100-582
Spreadsheet: d96b67a9-0078-4876-9a47-723a23889dc8
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
CAF | Test | CAF | Calcium, Feces | Calcium, F | Inductively Coupled Plasma-Optical Emission Spectrometry (ICP-OES) | Stool Container: Stool |  |  |  | Varies | Container/Tube: Stool container (Supply T291) [NAME]: Entire stool collection Collection Instructions: See Stool Collection Information Sheet in Special Instructions. Additional Information: 1. Random or timed specimen is acceptable. 2. Results will be reported as mg/kg regardless of collection duration. | 3 g | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | 800-1,200 mg/kg Reference values apply to all ages. | Monday through Friday; evening | 2 days | 5 days | 1 | 82310 |  |  |  |  | Rochester
CAF | [NAME] | FECAL | Fecal |  |  |  | Frozen | 14 days
CAF | Result | 8379 | Calcium, F | Calcium, F | Numeric |  |  |  |  | mg/kg |  |  |  |  |  |  |  |  |  | 53455-2
CAF | Result | 7603 | Total Weight | Total Weight | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 34648-6
Spreadsheet: 866731d1713631524-if-cell-contains-specific-text-from-one-of-multiple-lists-return-list-header-sample-lists
Sheet: Sheet1

Product name | Result | Result formula |  | Duo-caps |  | Trio-caps |  | Power-mix caps |  | Discs
Bright Yellow 3+1PowerCaps | Trio-caps |  |  | Duo |  | 3+1 |  | Power Mix |  | Disc
Bright [NAME] | Trio-caps |  |  | 2in1 |  | 3In1 |  | Power-Mix
RED CAPS 3IN1 ALPINE CONC 1 X | Trio-caps |  |  |  |  | 3+1
Green DUO CAPS Bright CONC | Duo-caps
[NAME] | Discs
Yellow Power Mix Extreme Power Capsul | Power-mix caps
Le Blue DuoBullesLexpert | Duo-caps
Le Blue Sensitive Capsul Conctrd Uni
[NAME] | Duo-caps
Green Power-Mix Caps Universal Capsul | Power-mix caps
Spreadsheet: 170044d1343145831-looking-to-get-rows-in-order-top-8-then-alphabetical-copycopy
Sheet: Sat-21-07-12

sold | 464
 | 63 |  | 21 |  | 31
 | 81 |  | 24 |  | 34
 |  |  | 37 |  | 52
Totals
 | 3 |  | 0 |  | 0
 | 9 |  | 3 |  | 3
 | 6 |  | 0 |  | 0
 | 1 |  | 0 |  | 0
 | 2 |  | 2 |  | 2
 | 1 |  | 1 |  | 2
 | 0 |  | 0 |  | 0
 | 1 |  | 0 |  | 0
 | 6 |  | 0 |  | 0
 | 2 |  | 0 |  | 0
 | 1 |  | 1 |  | 1
Totals
 | 7
 | 1
 | 1 |  | 0 |  | 0
 | 0 |  | 0 |  | 0
 | 0 |  | 0 |  | 0
 | 0 |  | 0 |  | 0
 | 1 |  | 1 |  | 1
 | 1 |  | 1 |  | 1
 | 1 |  | 0 |  | 0
 | 1 |  | 0 |  | 0
Page Totals
 | 1 |  | 0 |  | 0
 | 1 |  | 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
Page Totals
Page Totals
Other Grand Totals
Spreadsheet: 819166d1677258892-sumifs-over-two-worksheets-bank-account-and-project-reports-workings
Sheet: CF report

Project Cashflow Report
Project 1
 | Forecast |  |  |  |  |  |  | Actual |  |  |  |  |  |  | Difference
 | 2022-06-01 00:00:00 | 2022-07-01 00:00:00 | 2022-08-01 00:00:00 | 2022-09-01 00:00:00 | None | None | Total |  |  |  |  |  |  | Total |  |  |  |  |  |  | Total
Income
Income - Ticket Sales | 2000 | 2000 | 4000
Income - Programme Sales |  |  | 2000
Income - LA Contribution | 1000
Income - Arts Council | 90942
Income - Sponsorship | 2500 | 2500
Income - Gifts / Donations
Income - Workshops
Income - Consultancy
Income - Other
Total Income
Spend
Spend - Classes
Spend - TLT Travel
Spend - Drawings
Spend - Dancers |  | 9166.7 | 18333.3
Spend - Choreo | 1500 | 1500 | 3000
Spend - Videography | 1000 |  | 2000 | 2000
Spend - Director of photography |  |  | 2250 | 2250
Spend - Editor |  |  |  | 500
Spend - Colour grader |  |  | 2000
Spend - Film crew | 1500 |  |  | 1500
Spend - Producer | 825 | 825
Spend - Costume designer | 1500 | 1500
Spend - Musician |  | 2100 | 4200
Spend - Artists accom. - dancers |  |  | 800
Spend - Artists accom. - film team | 1064
Spend - Artists travel - choreo | 600 | 736
Spend - Artists travel - dancers |  | 800
Spend - Artist travel - film team |  | 2520 | 5040
Spend - Artists per diem | 2115
Spend - Studio hire | 2800
Spend - Marketing PR | 700 | 700 | 700
Spend - Venue hire |  |  | 4600
Spend - Event mgt |  |  | 9000
Spend - Accessibility |  |  | 2000
Spend - Programmes |  | 500
Spend - Catering |  |  | 990
Spend - Marquee |  |  |  | 5
Spend - Sound system |  |  |  | 200
Spend - HR and admin | 350 | 175 | 175
Spend - Evaluation |  |  |  | 700
Spend - Accountancy |  |  |  | 500
Spend - Other
Spend sub-total
Contingency
0.1
Total Outflow
Cashflow
Opening balance | 0 |  |  |  |  |  |  | 0 |  |  |  |  |  |  | 0
Net cashflow
Closing balance
Spreadsheet: 275508d1383555353-change-value-of-a-cell-from-another-cell-excelforum1
Sheet: Sheet1

102 | 202 | 302
103 | 203 | 303
104 | 204 | 304
105 | 205 | 305
106 | 206 | 306
107 | 207 | 307
108 | 208 | 308
109 | 209 | 309
110 | 210 | 310
111 | 211 | 311
112 | 212 | 312
113 | 213 | 313
114 | 214 | 314
115 | 215 | 315
116 | 216 | 316
117 | 217 | 317
118 | 218 | 318
119 | 219 | 319
120 | 220 | 320
121 | 221 | 321
122 | 222 | 322
123 | 223 | 323
124 | 224 | 324
Spreadsheet: 777761d1650594259-auto-populating-cells-on-multiple-tabs-based-on-the-date-entered-in-a-log-2022-trading-journal
Sheet: June

Sunday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday |  | Weekly Totals
 |  |  |  |  |  | 2022-06-01 00:00:00 |  | 2022-06-02 00:00:00 |  | 2022-06-03 00:00:00 |  | 2022-06-04 00:00:00
Sunday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday
2022-06-05 00:00:00 |  | 2022-06-06 00:00:00 |  | 2022-06-07 00:00:00 |  | 2022-06-08 00:00:00 |  | 2022-06-09 00:00:00 |  | 2022-06-10 00:00:00 |  | 2022-06-11 00:00:00
Sunday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday
2022-06-12 00:00:00 |  | 2022-06-13 00:00:00 |  | 2022-06-14 00:00:00 |  | 2022-06-15 00:00:00 |  | 2022-06-16 00:00:00 |  | 2022-06-17 00:00:00 |  | 2022-06-18 00:00:00
Sunday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday
2022-06-19 00:00:00 |  | 2022-06-20 00:00:00 |  | 2022-06-21 00:00:00 |  | 2022-06-22 00:00:00 |  | 2022-06-23 00:00:00 |  | 2022-06-24 00:00:00 |  | 2022-06-25 00:00:00
Sunday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday
2022-06-26 00:00:00 |  | 2022-06-27 00:00:00 |  | 2022-06-28 00:00:00 |  | 2022-06-29 00:00:00 |  | 2022-06-30 00:00:00
Spreadsheet: darrell_schoolcraft__7331__imball0203
Sheet: Amoco Abo

 | [NAME] |  | Amoco Abo fuel del
Day | Measured | Scheduled | Measured | Scheduled | Imbal
1 | 13 |  | -666
2 | 12 |  | -3300
3 |  |  | -3941
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
2002-02-28 00:00:00 |  |  |  |  | 178356.43
2002-03-03 00:00:00
CBS Volume
 |  |  | -355979
Spreadsheet: 38443d1236615305-excel-2007-having-problem-with-averageifs-formula-monthly-gas-reports-2009-ne
Sheet: 2-2 thru 2-8

 |  |  |  |  |  | System:
 |  |  | 2009-02-02 00:00:00 |  | Thru
 |  | Mon | Tue | Wed | Thur | Fri | Sat | Sun
Technician |  | 2009-02-02 00:00:00 |  |  |  |  |  |  | Total
1
2
3 |  |  |  |  | 58.01
4 |  |  | 40.95 |  | 36.87
5 |  | 36.23 |  | 34.87 |  |  | 29.41
6 |  | 37.5 |  |  |  | 40.63
7 |  |  | 38.15 |  |  |  | 38.65
8 |  |  |  |  | 36.19
9 |  | 39.15 |  |  |  |  | 35.44
10 |  |  |  |  | 35.02
11
12 |  | 34 |  | 28 |  | 32.01
13 |  | 39.2 |  |  | 39.73 |  | 38.15
14 |  |  |  | 38.4 |  |  |  | 39
15 |  | 33 |  | 36
16 |  | 31.57 |  |  | 36.21 | 28.06
17 |  | 31.64 |  |  |  | 27
18 |  |  | 25.79 |  | 32.02
19 |  |  | 33.35 |  |  | 36.2
20
21
22
23
24
25
 |  |  |  |  |  |  | Total:
Spreadsheet: 43773d1242386570-cell-formatting-research
Sheet: aggregare result

Resource | Req/Avl | jan | feb | mrz | apr | mai | juni | [NAME] | august | september
X | Req | 9 | 8 | 5 | 2 | 6 | 5 | 36 | 0 | 0
 | [NAME] | 5 | 5 | 5 | 5 | 5 | 4 | 4 | 4 | 0
Y | Req | 4 | 6 | 17 | 1 | 5 | 4 | 30 | 0 | 0
 | [NAME] | 5 | 7 | 5 | 5 | 5 | 6 | 6 | 6 | 0
Z | Req | 3 | 10 | 7 | 5 | 3 | 7 | 37 | 0 | 0
 | [NAME] | 5 | 5 | 5 | 5 | 5 | 3 | 3 | 3 | 0
Spreadsheet: 298789d1392909044-separating-text-and-numbers-in-different-columns-ef571a_separating-text-from-no
Sheet: Sheet1

COMPUTER HARDWARE -- 2.5%
1,847,222  Dell, Inc., Term Loan B ..............................      4.50%       04/29/13         1,835,862
--------------
CONSTRUCTION & FARM MACHINERY & HEAVY TRUCKS -- 0.3%
231,229  Navistar, Inc., Term Loan B ..........................      5.75%       08/17/17           235,564
--------------
CONSUMER FINANCE -- 0.8%
587,210  Walter Investment Management Corp., First Lien,
Tranche B Term Loans ..............................      5.75%       11/28/17           592,225
--------------
ELECTRIC UTILITIES -- 0.1%
100,000  Texas Competitive Electric Holdings Co., LLC,
Non-Extended Term Loan ............................  3.67%-3.77%     10/10/14            67,271
--------------
ENVIRONMENTAL & FACILITIES SERVICES -- 0.3%
208,729  EnergySolutions LLC, Term Loan........................      6.75%       08/15/16           210,165
 |  |  | Output desired
 |  |  | 1847222 | Dell, Inc., Term Loan B .............................. | 0.045 | 2013-04-29 00:00:00 | 1835862
Spreadsheet: kate_symes__18482__Cob
Sheet: DJ COB Electricity Index

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume |  | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME] |  | 24 HOUR | [NAME]
 | 2001-01-22 00:00:00 |  | 477.5 | 1600 | 325 | 200
 | 2001-01-21 00:00:00 |  |  |  |  |  |  |  | 475.58 | 3225 |  | 312.5 | 1200
 | 2001-01-20 00:00:00 |  | 600 | 400 | 325 | 0 | 428.07 | 2240 | 404.59 | 1115
 | 2001-01-19 00:00:00 |  | 600 | 400 | 362.5 | 0 | 417.35 | 3625 | 425 | 250
 | 2001-01-18 00:00:00 |  | 479.29 | 5600 | 233.33 | 600 | 475 | 0 | 185 | 225
 | 2001-01-17 00:00:00 |  | 264.55 | 5840 | 196.25 | 800 | 210 | 135 | 250 | 0
 | 2001-01-16 00:00:00 |  | 183.82 | 8800 | 163.58 | 2400 | 450 | 300 | 170 | 235
 | 2001-01-15 00:00:00 |  | 183.82 | 8800 | 163.58 | 2400 | 183.5 | 0 | 165 | 0
 | 2001-01-14 00:00:00 |  |  |  |  |  |  |  | 129.41 | 170 |  | 152.43 | 8400
 | 2001-01-13 00:00:00 |  | 168.69 | 5200 | 154.24 | 3680 | 115 | 33 | 140 | 20
 | 2001-01-12 00:00:00 |  | 176.68 | 10000 | 152.98 | 2080 | 209.62 | 720 | 134.57 | 350
 | 2001-01-11 00:00:00 |  | 176.75 | 9600 | 152.5 | 1680 | 181.82 | 275 | 185 | 50
 | 2001-01-10 00:00:00 |  | 168.05 | 8800 | 150 | 800 | 172.22 | 1360 | 166.03 | 696
 | 2001-01-09 00:00:00 |  | 165.55 | 8000 | 149.11 | 1080 | 175 | 75 | 150 | 65
 | 2001-01-08 00:00:00 |  | 154.06 | 12320 | 139.02 | 2440 | 170.92 | 1100 | 124.59 | 1220
 | 2001-01-07 00:00:00 |  |  |  |  |  |  |  | 120.71 | 2304 |  | 139.02 | 7320
 | 2001-01-06 00:00:00 |  | 146 | 9600 | 142.53 | 3000 | 119.57 | 1585 | 110.85 | 1970
 | 2001-01-05 00:00:00 |  | 146.36 | 10000 | 142.53 | 3000 | 168.87 | 1857 | 148.05 | 1001
 | 2001-01-04 00:00:00 |  | 154.8 | 8000 | 154.29 | 1400 | 172.79 | 3571 | 156.13 | 1435
 | 2001-01-03 00:00:00 |  | 180.29 | 4160 | 172.5 | 800 | 160.85 | 4323 | 147.25 | 922
 | 2001-01-02 00:00:00 |  | 185 | 800 | 176.58 | 584 | 149.75 | 2900 | 144.12 | 170
 | 2001-01-01 00:00:00 |  |  |  |  |  |  |  | 138.83 | 1790 |  | 175.74 | 2112
 | 2000-12-31 00:00:00 |  |  |  |  |  |  |  | 147.02 | 3015 |  | 150 | 600
 | 2000-12-30 00:00:00 |  | 165.5 | 4000 | 150 | 200 | 154.23 | 1750 | 155.43 | 460
 | 2000-12-29 00:00:00 |  | 219.29 | 5600 | 180 | 296 | 213.59 | 745 | 172.12 | 353
 | 2000-12-28 00:00:00 |  | 219.29 | 5600 | 180 | 296 | 205.42 | 300 | 181.32 | 285
 | 2000-12-27 00:00:00 |  | 396.43 | 2800 | 255 | 200 | 176.08 | 3130 | 186.7 | 684
 | 2000-12-26 00:00:00 |  | 461.25 | 1600 | 442.5 | 0 | 185 | 65 | 200 | 0
 | 2000-12-25 00:00:00 |  |  |  |  |  |  |  | 300 | 600
 | 2000-12-24 00:00:00 |  |  |  |  |  |  |  | 336.11 | 450
 | 2000-12-23 00:00:00 |  | 470.93 | 3440 | 311.96 | 1528 | 500 | 825 | 250 | 25
 | Explanatory Notes
 | R = REVISED |  |  | S = SURVEYED DATA |  |  |  | N/Q - NO QUOTE
 | Index: Weighted average price of megawatthours sold at COB. The Index is quoted in $/Mwh.
 | For questions or comments please call Antoine Eustache (609)520-7058 or [NAME] (609) 520-7067.
Spreadsheet: 355939d1414866856-rota-with-4-shifts-calculate-hours-rota-example_2
Sheet: Sheet1

 |  | START | Morning | END | START | Lunchtime | END | START | Afternoon | END | START | Evening | END | TOTAL | DCN
 | Person 1 | 09:00:00 |  | 12:00:00 | 12:00:00 | DCN | 16:00:00 | 16:00:00 |  | 18:00:00 | 22:00:00 |  | 1900-01-01 02:00:00 |  | 4
 | Person 2 | 11:00:00 | DCN |  |  |  |  |  |  | 18:00:00 |  |  |  |  | 7
Spreadsheet: 145616d1331663823-sumif-prep-data-test
Sheet: MTD

 |  | Y | Y | Y | Y |  |  |  | Y | Y | Y |  |  |  |  | Y | Y | Y | Y |  |  |  | Y | Y | Y |  |  |  |  | H | H
Line # | 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
3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 2 | 2 | 0 | 3 | 2 | 2 | 2 | 1 | 0 | 2 | 0 | 0 | 1 | 2 | 0 | 0 |  | 21
4 | 0 | 0 | 1 | 1 | 1 | 1 | 0 | 0 | 2 | 1 | 2 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 3 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 |  | 18
5 | 1 | 0 | 1 | 1 | 0 | 3 | 0 | 0 | 0 | 2 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 |  | 10
6 | 0 | 0 | 1 | 0 | 2 | 2 | 2 | 1 | 1 | 1 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 2 | 1 | 1 | 1 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 |  | 20
8 | 0 | 3 | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 1 | 4 | 1 | 1 | 1 | 0 | 2 | 1 | 2 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 |  | 23
12 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 1 | 1 | 2 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 2 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 |  | 12
14 | 0 | 0 | 0 | 1 | 1 | 2 | 2 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 8
 | 1 | 4 | 4 | 4 | 4 | 8 | 5 | 4 | 3 | 6 | 5 | 3 | 6 | 2 | 3 | 4 | 3 | 4 | 7 | 6 | 3 | 5 | 5 | 2 | 3 | 0 | 2 | 3 | 3 | 0 | 0 |  | 112
 |  | Day of Month | 1 | 0
 |  |  | Line 3 | Line 4 | Line 5 | Line 6 | Line 8 | Line 12 | Line 14
Day Shift | Job 1 | Work Order
 |  | Type
 |  | Total Time
 | Job 2 | Work Order
 |  | Type |  |  |  |  |  |  |  | F
 |  | Total Time
 | Job 3 | Work Order
 |  | Type
 |  | Total Time
 | Job 4 | Work Order
 |  | Type
 |  | Total Time
Night Shift | Job 1 | Work Order |  |  | 2030490
 |  | Type |  |  | HS
 |  | Total Time
 | Job 2 | Work Order
 |  | Type |  |  |  |  |  |  |  | G
 |  | Total Time
 | Job 3 | Work Order
 |  | Type
 |  | Total Time
 | Job 4 | Work Order
 |  | Type
 |  | Total Time