tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 694776d1599786283-lookup-help-sheq-metric
Sheet: xxx Graph

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | xxx- 12MM, 6MM TRIFR & Reportable Injuries
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Month | 12MM TRIFR | 6MM TRIFR | LTI- Actual | RWC- Actual | MTI - Actual | TRIFR Target | Employee | Business Partner | TRI Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 46
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 44
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 40
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 38
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 36
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 34
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 32
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 30
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 28
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 26
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 24
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 18
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Spreadsheet: drew_fossum__8885__EWE ll Deal Structure
Sheet: Sheet1

 |  |  |  |  |  | PROJECT "EWE ll"
 |  | NISOURCE |  | 0.5 |  |  | 0.5 | ENRON
 | RE-MINN |  |  |  | NEWCO (JV) |  |  |  | REFS
 |  |  |  |  | (GPG - Operater)
 | RE-ARKLA |  |  |  |  |  |  |  | COVE POINT LNG
 |  |  |  | CT |  | REGT |  |  | TPC/MHP
 |  |  |  | CG |  | MRT |  |  | Telecommunication
 |  |  |  |  |  |  |  |  | OBJECTIVES
 | PROJECT EWE ll - VALUATION SCHEDULE |  |  |  |  |  |  | ENE |  |  | NISOURCE
 |  |  |  |  | Unlevered !! |  | Grow PL assets off balance sheet |  |  |  | Grow LDC asset base
 | RE-MINN   (Minnegasco) |  |  |  | 465488 | MM | Avoid PUHCA |  |  |  | w/o incurring add'l debt
 | RE-ARKLA   (Arkla LDC) |  |  |  | 361063 | MM | Add complementary storage assets |  |  |  | Reduces current debt as
 | REGT   (Reliant Energy Gas Transmission) |  |  |  | 911020 | MM | Add strategic LNG facilities (ENA) |  |  |  | other assets are added
 | MRT   (Mississippi River Transmission) |  |  |  | 247851 | MM | Exploit "best in class" operating capability |  |  |  | to sales package
 | REFS   (Reliant Energy Field Services) |  |  |  | 195386 | MM
 | TOTAL PROJECT EWE ll |  |  |  |  | MM | TRANSACTION CASH SUMMARY
 |  |  |  |  |  |  | NISOURCE CASH IN (OUT) |  |  |  |  | MM
 | OTHER POSSIBLE ACQUISITIONS |  |  |  |  |  | ENRON CASH IN (OUT) |  |  |  |  | MM
 | CG/CT   (Columbia Gulf & Columbia Trans.) |  |  |  | 2900000 | MM
 | COVE POINT   (LNG terminal) |  |  |  | 80000 | MM  (guestimate?)
 | Telecommunications (Fiber on CG/CT) |  |  |  |  | MM  (don't even have a guess)
 | TPC/MHP   (Tejas Power/Market Hub Partners) |  |  |  | 200000 | MM  (guestimate?)
Spreadsheet: 54227d1254246429-overtime-rotating-seniority-list-seniority-list-9-09-test
Sheet: Sheet1

Name | Seniority Date | 2009-10-01 00:00:00 | Name | 2009-10-02 00:00:00 | Name | 2009-10-03 00:00:00
Last Name, First Name | 1985-10-21 00:00:00
Last Name, First Name | 1987-01-13 00:00:00
Last Name, First Name | 1987-04-28 00:00:00
Last Name, First Name | 1990-12-03 00:00:00
Last Name, First Name | 1993-09-29 00:00:00
Last Name, First Name | 1996-08-13 00:00:00
Last Name, First Name | 1997-08-02 00:00:00
Last Name, First Name | 1997-10-13 00:00:00
Last Name, First Name | 1997-11-18 00:00:00
Last Name, First Name | 1997-12-08 00:00:00
Last Name, First Name | 1998-10-05 00:00:00
Last Name, First Name | 1999-03-29 00:00:00
Last Name, First Name | 2001-04-06 00:00:00
Last Name, First Name | 2003-01-21 00:00:00
Last Name, First Name | 2003-02-10 00:00:00
Last Name, First Name | 2003-02-10 00:00:00
Last Name, First Name | 2003-04-07 00:00:00
Last Name, First Name | 2003-09-08 00:00:00
Last Name, First Name | 2003-12-01 00:00:00
Last Name, First Name | 2004-06-01 00:00:00
Last Name, First Name | 2004-11-22 00:00:00
Last Name, First Name | 2005-09-12 00:00:00
Last Name, First Name | 2006-01-09 00:00:00
Last Name, First Name | 2006-02-06 00:00:00
Last Name, First Name | 2006-04-03 00:00:00
Last Name, First Name | 2007-08-06 00:00:00
Last Name, First Name | 2007-08-27 00:00:00
Last Name, First Name | 2008-08-04 00:00:00
Last Name, First Name | 2008-08-04 00:00:00
Last Name, First Name | 2009-01-12 00:00:00
Last Name, First Name | 2009-02-02 00:00:00
Last Name, First Name | 2009-02-02 00:00:00
Last Name, First Name | 2009-02-09 00:00:00
Last Name, First Name | 2009-02-23 00:00:00
Last Name, First Name | 2009-03-16 00:00:00
Last Name, First Name | 2009-03-16 00:00:00
Last Name, First Name | 2009-03-23 00:00:00
Last Name, First Name | 2009-03-30 00:00:00
Last Name, First Name | 2009-06-08 00:00:00
Last Name, First Name | 2009-06-08 00:00:00
Last Name, First Name | 2009-06-15 00:00:00
Last Name, First Name | 2009-06-15 00:00:00
Last Name, First Name | 2009-06-22 00:00:00
Last Name, First Name | 2009-08-24 00:00:00
Last Name, First Name | 2009-08-31 00:00:00
Subs
Last Name, First Name
Last Name, First Name
Last Name, First Name
Last Name, First Name
Last Name, First Name
Last Name, First Name
Last Name, First Name
Last Name, First Name
Last Name, First Name
Last Name, First Name
Last Name, First Name
Last Name, First Name
Last Name, First Name
Last Name, First Name
Last Name, First Name
Last Name, First Name
Last Name, First Name
Last Name, First Name
Spreadsheet: joe_quenet__15074__PJM
Sheet: DJ PJM Electricity Index

 | DATE |  |  |  | Firm On Peak |  | MW |  | [NAME]
 | 2001-10-19 00:00:00 |  |  |  | 25.5 |  | 1250 |  | 20000
 | 2001-10-18 00:00:00 |  |  |  | 26.93 |  | 2600 |  | 41600
 | 2001-10-17 00:00:00 |  |  |  | 25.28 |  | 2750 |  | 44000
 | 2001-10-16 00:00:00 |  |  |  | 26.48 |  | 900 |  | 14400
 | 2001-10-15 00:00:00 |  |  |  | 26.31 |  | 1050 |  | 16800
 | 2001-10-14 00:00:00
 | 2001-10-13 00:00:00
 | 2001-10-12 00:00:00 |  |  |  | 23.51 |  | 2100 |  | 33600
 | 2001-10-11 00:00:00 |  |  |  | 23.98 |  | 1350 |  | 21600
 | 2001-10-10 00:00:00 |  |  |  | 25.31 |  | 1800 |  | 28800
 | 2001-10-09 00:00:00 |  |  |  | 28.25 |  | 1800 |  | 28800
 | 2001-10-08 00:00:00 |  |  |  | 29.17 |  | 3850 |  | 61600
 | 2001-10-07 00:00:00
 | 2001-10-06 00:00:00
 | 2001-10-05 00:00:00 |  |  |  | 28.6 |  | 1950 |  | 31200
 | 2001-10-04 00:00:00 |  |  |  | 28.93 |  | 1350 |  | 21600
 | 2001-10-03 00:00:00 |  |  |  | 27.5 |  | 900 |  | 14400
 | 2001-10-02 00:00:00 |  |  |  | 26.01 |  | 1000 |  | 16000
 | 2001-10-01 00:00:00 |  |  |  | 24.71 |  | 2050 |  | 32800
 | 2001-09-30 00:00:00
 | 2001-09-29 00:00:00
 | 2001-09-28 00:00:00 |  |  |  | 23.73 |  | 3450 |  | 55200
 | 2001-09-27 00:00:00 |  |  |  | 24.58 |  | 3200 |  | 51200
 | 2001-09-26 00:00:00 |  |  |  | 25.14 |  | 3600 |  | 57600
 | 2001-09-25 00:00:00 |  |  |  | 25.91 |  | 3650 |  | 58400
 | 2001-09-24 00:00:00 |  |  |  | 26.97 |  | 5450 |  | 87200
 | 2001-09-23 00:00:00
 | 2001-09-22 00:00:00
 | 2001-09-21 00:00:00 |  |  |  | 25.63 |  | 5300 |  | 84800
 | 2001-09-20 00:00:00 |  |  |  | 26.12 |  | 2600 |  | 41600
Spreadsheet: 105102d1302561064-question-with-several-combining-if-functions-yoyoyo-3-
Sheet: Sheet1

Sell value | 1.5 | Buy new | 0.7
Day | OPEN | LOW | HIGH
1 | 0.35 | 0.35 | 0.35
2 | 0.4 | 0.4 | 0.4
3 | 0 | 0 | 0
4 | 0 | 0 | 0
5 | 0 | 0 | 0
6 | 0.25 | 0.2 | 0.25
7 | 0 | 0 | 0
8 | 0 | 0 | 0
9 | 0 | 0 | 0
10 | 0.15 | 0.15 | 0.3
11 | 0.1 | 0.1 | 0.1
12 | 0.25 | 0.15 | 0.25
13 | 0.15 | 0.15 | 0.2
14 | 0.3 | 0.25 | 0.35
15 | 0 | 0 | 0
16 | 0.25 | 0.25 | 0.25
17 | 0.2 | 0.2 | 0.2
18 | 0.15 | 0.15 | 0.15
19 | 0.15 | 0.15 | 0.15
20 | 0 | 0 | 0
21 | 0.05 | 0.05 | 0.05
22 | 0 | 0 | 0
23 | 0.15 | 0.15 | 0.15
24 | 0.1 | 0.1 | 0.25
25 | 0 | 0 | 0
26 | 0 | 0 | 0
27 | 0.05 | 0.05 | 0.05
28 | 0 | 0 | 0
29 | 0 | 0 | 0
30 | 0 | 0 | 0
31 | 0 | 0 | 0
32 | 0 | 0 | 0
 |  |  |  |  |  | You should buy when your bought price is higher than 150 percent in the high culumn
 |  |  |  |  |  | You should buy when your bought pirce is lower then 70 per cent in the low column
 |  |  |  |  |  | If you buy you buy the next day, and you cant't buy when price is zero
 |  |  |  |  |  | You can check whether it's allright with the yellow marks. Yellow means buying
Spreadsheet: 685170d1593774500-vlookup-and-match-two-values-sample-data
Sheet: target

SOURCE_SYSTEM_ID | PERSON_ID | EFFECTIVE_START_DATE | EFFECTIVE_ | BLOOD_TYPE | CORRESPONDENCE_LANGUAGE | COUNTRY_OF_BIRTH | [NAME] | REGION_OF_BIRTH | TOWN_OF_BIRTH | PERSON_NUMBER | SOURCE_SYSTEM_ID
19494 | 1.00000010670614E14 | 1988-07-01T00:00:00.000+00:00 | 4712-12-31 00:00:00 |  |  |  | 1951-07-08T00:00:00.000+00:00 |  |  | 117 | 19494
19498 | 1.00000014918828E14 | 1988-10-01T00:00:00.000+00:00 | 4712-12-31 00:00:00 |  |  |  | 1950-09-12T00:00:00.000+00:00 |  |  | 123 | 19498
19563 | 1.0000001492478E14 | 2016-05-01T00:00:00.000+00:00 | 4712-12-31 00:00:00 |  |  |  | 1948-06-27T00:00:00.000+00:00 |  |  | 978 | 19563
19570 | 1.0000001491493E14 | 2018-08-01T00:00:00.000+00:00 | 4712-12-31 00:00:00 |  |  |  | 1954-05-07T00:00:00.000+00:00 |  |  | 8424 | 19570
19859 | 3.00000033331924E14 | 2020-06-08T00:00:00.000+00:00 | 4712-12-31 00:00:00 |  |  |  | 1966-05-31T00:00:00.000+00:00 |  |  | 32047 | 19859
19901 | 3.00000033498009E14 | 2020-06-08T00:00:00.000+00:00 | 4712-12-31 00:00:00 |  |  |  | 1940-12-05T00:00:00.000+00:00 |  |  | 43662 | 19901
19907 | 3.00000033303948E14 | 2020-06-08T00:00:00.000+00:00 | 4712-12-31 00:00:00 |  |  |  | 1944-01-27T00:00:00.000+00:00 |  |  | 30035 | 19907
19907 | 3.00000033303948E14 | 2020-06-08T00:00:00.000+00:00 | 4712-12-31 00:00:00 |  |  |  | 1944-01-27T00:00:00.000+00:00 |  |  | 30035 | 19907
19907 | 3.00000033303948E14 | 2020-06-08T00:00:00.000+00:00 | 4712-12-31 00:00:00 |  |  |  | 1944-01-27T00:00:00.000+00:00 |  |  | 30035 | 19907
19907 | 3.00000033303948E14 | 2020-06-08T00:00:00.000+00:00 | 4712-12-31 00:00:00 |  |  |  | 1944-01-27T00:00:00.000+00:00 |  |  | 30035 | 19907
19949 | 3.00000033337499E14 | 2020-06-08T00:00:00.000+00:00 | 4712-12-31 00:00:00 |  |  |  | 1942-11-09T00:00:00.000+00:00 |  |  | 32353 | 19949
20064 | 3.00000033333802E14 | 2020-06-08T00:00:00.000+00:00 | 4712-12-31 00:00:00 |  |  |  | 1942-05-24T00:00:00.000+00:00 |  |  | 32132 | 20064
Spreadsheet: kate_symes__18324__DJ Index 4-23
Sheet: Sheet1

Electricity Price Index Report
Rep. [NAME]: | 2001-04-23 00:00:00
Flow Date: | 2001-04-23 00:00:00
From: | Enron Power Marketing Inc. - Kate Symes
Phone: | (800) 464-7486
Fax: | (503) 464-3740
To: | [NAME] or [NAME]
Phone: | (609) 520-4683 ([NAME])
Phone: | (609) 520-4663 (Earnest Onukogu)
Fax: | (609) 452-3531
COB
Designation | Type | Weighted Avg. Price | MWH Vol.
On [NAME] | Firm Trades Sales | 256.6666666666666 | 2400
 | Firm Trades Purchases | #[NAME]! | 0
[NAME] | Firm Trades Sales | 207.5 | 400
 | Firm Trades Purchases | #[NAME]! | 0
MID COLUMBIA
Designation | Type | Weighted Avg. Price | MWH Vol.
On [NAME] | Firm Trades Sales | 263.25 | 4000
 | Firm Trades Purchases | 265 | 400
[NAME] | Firm Trades Sales | 220 | 600
 | Firm Trades Purchases | #[NAME]! | 0
PALO VERDE
Designation | Type | Weighted Avg. Price | MWH Vol.
On [NAME] | Firm Trades Sales | 186.5249140893471 | 9312
 | Firm Trades Purchases | 189.4594594594595 | 2960
[NAME] | Firm Trades Sales | 100.5448275862069 | 3480
 | Firm Trades Purchases | 98.75 | 480
MEAD
Designation | Type | Weighted Avg. Price | MWH Vol.
On [NAME] | Firm Trades Sales | #[NAME]! | 0
 | Firm Trades Purchases | 195 | 112
[NAME] | Firm Trades Sales | #[NAME]! | 0
 | Firm Trades Purchases | 108.936170212766 | 376
NP-15
Designation | Type | Weighted Avg. Price | MWH Vol.
On [NAME] | Firm Trades Sales | 237.5 | 4800
 | Firm Trades Purchases | 230 | 800
[NAME] | Firm Trades Sales | 173.0403458213256 | 2776
 | Firm Trades Purchases | 169.1666666666667 | 1200
SP-15
Designation | Type | Weighted Avg. Price | MWH Vol.
On [NAME] | Firm Trades Sales | 198.6666666666667 | 2400
 | Firm Trades Purchases | 195.1764705882353 | 1360
[NAME] | Firm Trades Sales | 104.6153846153846 | 2600
 | Firm Trades Purchases | 106.3095238095238 | 840
Spreadsheet: 743645d1628645900-formula-needed-for-splitting-hours-using-different-production-rates-to-get-a-balanced-production
Sheet: Sheet1

 |  | Fruit | Production Rate | Picked | Goal |  | Percent of Hours Used |  | [NAME] | Production Percent
 |  | Apples | 200 | 3625
 |  | Oranges | 150 | 2402
 |  | Peaches | 175 | 3100
 |  |  |  | Goal |  |  |  |  |  | I want each category to have the same %
 |  |  |  | Hours Used | 71.5
Spreadsheet: 0af3e029-6f66-4f19-a12c-d5e5fc1c7b2c
Sheet: D

Course color corresponds with term of offering.  RED for Fall semester, PURPLE for J-term, GREEN for both Fall and J-term.
 | AOK Designation | CAR Designation | Comment
Drama
DRAM 111 | Arts & Literature-Arts
DRAM 211 | Arts & Literature-Arts
DRAM 212 | Arts & Literature-Arts
DRAM 215 | Arts & Literature-Arts
DRAM 310 | Arts & Literature-Arts (3 times at 1 hour)
DRAM 320 | Arts & Literature-Arts
 | OR Arts & Literature-Literature
DRAM 330 | Arts & Literature-Arts
DRAM 331 | Arts & Literature-Arts | Computing
DRAM 332 | Arts & Literature-Arts
DRAM 333 | Arts & Literature-Arts
DRAM 334 | Arts & Literature-Arts
DRAM 341 | Arts & Literature-Arts
DRAM 342 | Arts & Literature-Arts
DRAM 381 |  | Experiential-Research
DRAM 381 | Arts & Literature-Arts |  | J-term 2012 (Black American Theater)
DRAM 381 | Arts & Literature-Arts |  | J-term 2013 (Playmaking: The Playwright's Process)
DRAM 382 |  | Experiential-Research
DRAM 422 |  | Experiential-Research; Capstone
Spreadsheet: 6c6c4b36-3ec3-4441-b224-8abdd7127dca
Sheet: Sheet1

COURT OF CHANCERY COURTROOM CALENDAR FOR THE WEEK OF SEPTEMBER 29, 2014 THROUGH OCTOBER 3, 2014 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
TIME | CASE # | JUDGE | PROCEEDING | CASE CAPTION | SITE
Monday, September 29, 2014
09:30:00 | CA#7937-VCP | Vice Chancellor Parsons | Trial | Kan-di-ki v. Suer | [NAME]
09:30:00 | CA#5009-VCG | Vice Chancellor Glasscock | Trial | State of Delaware v. Sweetwater Point LLC | Georgetown
10:00:00 | CA#9170-CB | Chancellor [NAME] | Settlement Hearing | In re Solta Medical, Inc. Stockholders Litigation | [NAME]
10:00:00 | CA#9418-ML | Master [NAME] | Oral Argument | IMO LW&T of Welcher; [NAME] v. [NAME] | [NAME]
02:30:00 | CA#9985-CB | Chancellor [NAME] | In-Ct. [NAME]. | In re Family Dollar Stores, Inc. | [NAME]
Tuesday, September 30, 2014
09:00:00 | CA#7937-VCP | Vice Chancellor Parsons | Trial | Kan-di-ki v. Suer | [NAME]
09:30:00 | CA#9324-ML | Master [NAME] | Oral Argument | Morgan v. [NAME] | [NAME]
02:00:00 | CA#9432-ML | Master [NAME] | Oral Argument | [NAME] v. Ham et al. | [NAME]
02:00:00 | CA#8958-VCG | Vice Chancellor [NAME] | Settlement Hearing | In re MAKO Surgical Corp. Stockholder Litigation | Georgetown
Wednesday, October 1, 2014
09:00:00 | CA#7937-VCP | Vice Chancellor Parsons | Trial | Kan-di-ki v. Suer | [NAME]
09:30:00 | CA#9606-MA | Master [NAME] | Hearing | Nationstar v. Street | Georgetown
10:00:00 |  | Chancellor [NAME] | Guardianship Hearing |  | [NAME]
10:30:00 | CA#9548-MA | Master [NAME] | Hearing | [NAME] v. Tull | Georgetown
11:30:00 | CA#9518-MA | Master [NAME] | MDJ Hearing | Bank of America v. Stratton | Georgetown
01:30:00 | CA#8390-MA | Master [NAME] | MTD Hearing | IN RE:  Est of Genelda Cornwell | Georgetown
Thursday, October 2, 2014
09:00:00 | CA#8728-VCG | Vice Chancellor Glasscock | Oral Argument | [NAME] | Georgetown
09:45:00 | CA#7937-VCP | Vice Chancellor Parsons | Trial | Kan-di-ki v. Suer | [NAME]
10:00:00 | CA#9069-CB | Chancellor [NAME] | Oral Argument | [NAME] Official Payments Holdings Inc. | [NAME]
10:00:00 |  | Master [NAME] | Guardianship Hearing |  | [NAME]
11:00:00 | CA#10033-MA | Master [NAME] | Hearing | Est of [NAME], Sr. | Georgetown
01:00:00 | CA#9818-MA | Master [NAME] | MDJ Hearing | Sasada, Trustee of Banks Trust v. Coy | Georgetown
Friday, October 3, 2014
09:00:00 | CA#7937-VCP | Vice Chancellor Parsons | Trial | Kan-di-ki v. Suer | [NAME]
11:00:00 | CA#9702-VCG | Vice Chancellor Glasscock | RTSC Hearing | Matlack Properties PA I, LP | Georgetown
02:00:00 | CA#9575-VCN | Vice Chancellor [NAME] | Oral Argument | 3850 & 3860 Colonial Blvd, LLC v. Griffin | Dover
Spreadsheet: darrell_schoolcraft__7757__Project Info r053001
Sheet: Contacts

 | Contacts
 |  |  |  | Phone Numbers
 | Team Members |  |  | Office | Cell | Pager | Fax | Conference Ph#
 | [NAME] |  |  | [PHONE] | [PHONE] | [PHONE] | [PHONE]
 | [NAME] |  |  | [PHONE] | [PHONE] | [PHONE]
 | [NAME] |  |  | [PHONE] | [PHONE]
 | [NAME], Analyst |  |  | [PHONE] ext 111 | c.[PHONE]     v.[PHONE] | [PHONE]
 | [NAME] (Sta 2 )
 | [NAME] ( Sta 1 ) |  |  | [PHONE] | [PHONE] | [PHONE] | [PHONE]
 | JB Callado ( Sta 3 ) |  |  | [PHONE]
 | [NAME] ( Sta 3 ) |  |  | [PHONE]
 | [NAME] ( Sta 4 ) |  |  | [PHONE]
 | [NAME] ( Sta 4 ) |  |  | [PHONE]
 | Other Contacts
 | [NAME] |  |  | [PHONE]
 | Rich Jolly
 | [NAME], Advisor |  |  | [PHONE] x112 | [PHONE] | [PHONE] | [PHONE]
 | [NAME] Advisor
 | [NAME], Planning
 | [NAME], Planning |  |  | [PHONE] | ----------------------------------------------------- |  |  | [PHONE] | 9473
 | [NAME], GC |  |  | [PHONE] | [PHONE] | [PHONE]
 | [NAME], Analyst
 | [NAME], Analyst
 | [NAME], Enviro Spec |  |  | [PHONE] | [PHONE]
 | [NAME], D-R Serv. Mgr. |  |  | [PHONE]
 | [NAME], D-R Mech Supr |  |  | [PHONE]
 | [NAME], D-R Mech |  |  | [PHONE]
 | [NAME] Inc |  |  | 800- 228- 5267
 | [NAME],Mfg Mgr - KAMs Inc |  |  | 405- 232- 2636
 | [NAME], CECO ---- |  |  | [PHONE] |  |  |  |  |  | www.ceconet.com
 | [NAME] |  |  | [PHONE]
 |  |  |  | [PHONE]
 | [NAME] |  |  | [PHONE]
 | [NAME] |  |  | [PHONE] |  |  |  |  |  | Engineer
 | [NAME] |  |  | [PHONE] |  |  |  |  |  | Sales..
Spreadsheet: 736704d1623828463-nested-if-formula-with-isblank-and-max-functions-testing_formulas
Sheet: Sheet1

 | hse1 | hse1c | hse2 | hse2c | hse3 | hse3c | final (it should always show the last result) | Result (based on cell H - but this I have) |  | Different versions of what I tried. The simpler versions that I used in the original file and work, they do not include the 'c' cells
student 1 | 70 |  |  |  |  |  |  | Pass |  | IF(ISBLANK(E2),C2,IF(ISBLANK(A2),"",MAX(A2,B2),IF(NOT(ISBLANK(C2),MAX(C2,D2),IF(NOT(ISBLANK(E2),MAX(E2,F2))))))
student 2 | 50 |  | 45 | 50 | 30 |  |  | Fail |  | IFS(NOT(ISBLANK(A3),MAX(A3,B3),IF(NOT(ISBLANK(C3),MAX(C3,D3),IF(NOT(ISBLANK(E3),MAX(E3,F3),"")
student 3 | 65 | 67.5 |  |  |  |  |  | Pass |  | IF(ISBLANK(A4),"n/a",IF(ISBLANK(C4),A4,IF(ISBLANK(A4),MAX(B4,A4))))
student 4 | 50 |  | 55 |  | 60 | 62.5 |  | Pass |  | IF(ISBLANK(E2),C2,MAX(F2,E2)),IF(ISBLANK(C2),A2,MAX(D2,C2)),IF(ISBLANK(A2),"",MAX(B2,A2))
student 5 | 50 |  | 50 | 55 |  |  |  | Fail |  | IF(NOT(ISBLANK(B5)),B5,IF(NOT(ISBLANK(C5)),C5,IF(NOT(ISBLANK(D5)),D5,IF(NOT(ISBLANK(E5)),E5,"novalue"))))
 |  |  |  |  |  |  |  |  |  | This formula works when there are no columns with dates involved:
 |  |  |  |  |  |  |  |  |  | INDEX(A2:G2,1,MATCH(9^99,A2:G2))
 |  |  |  |  |  |  |  |  |  | IF HSE attempt 3 is blank; then check IF HSE attempt 2 is blank ; then check if HSE attempt 1 is blank, show “N/A”, else then [NAME] attempt 1, else show HSE attempt 2, else show HSE attempt 3).
Spreadsheet: 117688d1312966432-ytd-using-match-and-offset-example-ytd
Sheet: Summary

 | Mar
 |  | Description |  | YTD | FY
 |  | 1 - TOTAL Project Invoices Issued
 |  | 2 - TOTAL Project Direct Costs
 |  | 2B - Currency exchange differential
 |  | 3 - TOTAL Staff Costs
 |  | 4 - TOTAL Travel/Lodging/Subsistance
 |  | 5 - TOTAL Rent and Insurance
 |  | 6 - TOTAL Administrative
 |  | 7 - TOTAL Fixed Assets
 |  | 8 - TOTAL Stock for Resale
 |  | 9 - TOTAL Debtors
 |  | 10 - TOTAL Deposits / Prepayments
 |  | 11 - TOTAL Cash at Bank
 |  | 12 - TOTAL Creditors and Accruals
 |  |  |  | - Need monthly figures based on month selected in cell B2 - data in "DETAIL" sheet
 |  |  |  | - Need YTD figures based on month selected in cell B2 - data in "DETAIL" sheet
Spreadsheet: 769006d1645244933-getting-a-sum-not-the-basic-formula-forum-post
Sheet: Sheet1

12 | 12 | 12 | 4/8K | D | D | D | 12A | 12B | 12F | 4/8K | 12 | D | D
1st set |  |  |  |  |  |  | 2nd set
this would be the standard look - 40 with 8K |  |  |  |  |  |  | counting the 12's with  A, B, F would be 52 with 8K, red would a fault needing to be corrected
 |  |  |  |  |  |  | my base would be the 40
 |  |  |  |  |  |  | once I make the correction
 |  |  |  |  |  |  | 12A | 12B | 12F | 4/8K | 12K | D | D
 |  |  |  |  |  |  | no fault shown
Spreadsheet: 04d04a0e-c9c2-449a-a435-fded920ed29e
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
Training Center
Course Approval Form
Provider Courses
 | ACLS |  | Initial | Physician Instructor serving as Course Director or Co-Director
 |  |  | Renewal
 |  |  |  | Name
 | PALS |  | Initial
 |  |  | Renewal
Instructor Courses
 | ACLS |  |  | Regional Faculty Serving  as  Course Director or Co-Director
 | PALS |  |  | Name
 | BLS
Course Information (please complete all information
Course Dates
Course Location
Course Director
Provide a list of Course Faculty on back of this form
Attach a course outline to this form
Class [NAME] |  | Course Fee |  |  | Target Audience
Is there space available for additional participants? |  |  |  |  |  | YES |  | NO
How will student receive Provider or Instructor Manuals?
 | Included in course fee an sent upon registration
 | Included in course registration and handed out in class
 | Made available to purchase prior to course start date
 | Made available for purchase at first class
 | Other
Contact person
 | Address
 | Phone
Training Center - Dept 696
Medical Center Boulevard - Winston-Salem, North Carolina 27157
www.wfubmc.edu/tc