tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 854436d1704310309-find-string-col-b-paste-in-col-a-until-it-changes-then-paste-new-string-test-tagging
Sheet: Result

5707.01.00 | Identifier | 5707.01.00
5707.01.00 | Description | ID 1
5707.01.00 | Term | 30
5707.01.00 | Cust # | 2320
5707.01.00
5707.01.00
5707.01.00
5707.01.00
5707.01.00 | Desc
5707.01.00
5707.01.00 | Revenue
5707.01.00
5707.01.00 | Cost
5707.01.00
5707.01.00 | Profit
5707.01.00
5707.01.00 | Margin
5707.01.00
5707.01.00
5707.01.00
5707.01.00
5707.02.00 | Identifier | 5707.02.00
5707.02.00 | Description | ID 1
5707.02.00 | Term | 30
5707.02.00 | Cust # | 2320
5707.02.00
5707.02.00
5707.02.00
5707.02.00
5707.02.00 | Desc
5707.02.00
5707.02.00 | Revenue
5707.02.00
5707.02.00 | Cost
5707.02.00
5707.02.00 | Profit
5707.02.00
5707.02.00 | Margin
5707.02.00
5707.02.00
5707.03.00 | Identifier | 5707.03.00
5707.03.00 | Description | ID 1
5707.03.00 | Term | 30
5707.03.00 | Cust # | 2320
5707.03.00
5707.03.00
5707.03.00
5707.03.00
5707.03.00 | Desc
5707.03.00
5707.03.00 | Revenue
5707.03.00
5707.03.00 | Cost
5707.03.00
5707.03.00 | Profit
5707.03.00
5707.03.00 | Margin
Spreadsheet: 630238e0-db4b-436b-82eb-455272a8f1f5
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Taseis | 664497477426 | Lingo | Representin' Tha Finest | 2004-05-04 | Compact Disc | Rap | 16.99 | N | To Be Retired
Taseis | 664497477020 | Lingo | All Things To All People | 2005-05-24 | Compact Disc | Rap | 12.99 | N | To Be Retired
Spreadsheet: 868974d1715679151-shrinking-dropdown-list-book2
Sheet: Sheet1

List | New List
REG101 |  |  | REG101
REG102 | REG203 |  | REG101 | EMP-2
REG103 |  |  | REG101 | EMP-3
REG201 |  |  | REG101 | EMP-4
REG202 |  |  | REG103 | EMP-1
REG203 |  |  | REG103 | EMP-2
 |  |  | REG103 | EMP-3
 |  |  | REG103 | EMP-4
 |  |  | REG103 | EMP-5
 |  |  | REG202 | EMP-1
 |  |  | REG202 | EMP-2
 |  |  | REG202 | EMP-3
 |  |  | REG202 | EMP-4
 |  |  | REG202 | EMP-5
 |  |  | REG202 | [NAME]
 |  |  | REG201 | EMP-1
Spreadsheet: 118711d1313940282-excel-2007-inconsistent-results-with-lookup-lookup-problem
Sheet: Sheet1

Student Name | Assigned Class | A | B | C | D | E | F | G
[NAME] |  | x |  | x |  | x | x | a
[NAME] |  | a | x | x | x |  | x
[NAME] |  | x | x | a |  | x |  | x
[NAME] |  |  | x | x | x | a | x
Janice |  | x | a | x |  |  | x | x
[NAME] |  | x | x |  | x |  | x | x
[NAME] |  | a | x | x |  | x |  | x
Jezebel |  |  | x | x | a |  | x | x
Spreadsheet: 0ef1ed5a-910a-40e9-9b07-ceef6b147d6b
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
Figure 5.5a: Water pricing and household water use in Spain
 |  | Average household water consumption | Unit value of water (unit values for water supply and sewage services)
 |  | [NAME] day | Euro per m³ | Source
 | 2000 | 168 | 0.73 | http://www.ine.es/prensa/np288.pdf
 | 2001 | 165 | 0.77 | http://www.ine.es/prensa/np288.pdf
 | 2002 | 164 | 0.81 | http://www.ine.es/prensa/np335.pdf
 | 2003 | 167 | 0.86 | http://www.ine.es/prensa/np382.pdf
 | 2004 | 171 | 0.96 | http://www.ine.es/prensa/np423.pdf
 | 2005 | 166 | 0.98 | http://www.ine.es/prensa/np470.pdf
 | 2006 | 160 | 1.08 | http://www.ine.es/prensa/np511.pdf
 | 2007 | 157 | 1.29 | http://www.ine.es/prensa/np561.pdf
 | 2008 | 154 | 1.31 | http://www.ine.es/prensa/np607.pdf
 | 2009 | 149 | 1.42 | http://www.ine.es/prensa/np659.pdf
Spreadsheet: 855438d1704992313-timesheet-database-sample-timesheet
Sheet: 12-Feb-24

Staff Name | Project | Project Number | Project Name | Mon | Tue | Wed | Thu | Fri
Employee 1 | 23001 - Project 1 |  |  |  |  |  |  | 7.5
Employee 1 | 23002 - Project 2
Employee 1 | 23003 - Project 3
Employee 1 | 23004 - Project 4 |  |  |  |  |  | 7.5
Employee 1 | 23005 - Project 5 |  |  | 7.5 | 7.5 | 7.5
Employee 1 | 23006 - Project 6
Employee 1 | 23007 - Project 7
Employee 1 | 23008 - Project 8
Employee 1 | 23009 - Project 9
Employee 1 | 23010 - Project 10
Spreadsheet: michelle_lokay__26547__EOLTWdeals
Sheet: EOLNov01

 |  |  |  |  | New This Week
 | PRODUCTION  MONTH : |  |  |  | 2001-11-01 00:00:00 |  |  |  | Transwestern Pipeline Company
 | Contract | Shipper |  | Non | Term | Term | Monthly | # |  | Demand | Demand | Commodity | Total | Monthly | Monthly | Total Monthly | NOTES
 | # |  | Daily | [NAME] | Start | End | Volume | Days | MDQ | Monthly $ | Daily $ | per [NAME] | Rate | Demand | Commodity | Revenue
1 | 27747 | Burlington Resources | n |  | 2001-11-01 00:00:00 | 2001-11-30 00:00:00 |  | 30 | 20000 |  | 0.05 | 1-Part |  |  | 0 |  | La Maquina to I/B Link
 | Total Deals
 |  |  |  |  |  |  | MMBtu |  | MMBtu |  |  |  |  | Monthly Demand | Commodity | Total Revenue
Spreadsheet: 4c4e47e8-c0c2-462a-b6bd-9125ef0f6eb6
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
OXU | Test | OXU | Oxalate, [NAME] | Oxalate, U | Enzymatic Using Oxalate Oxidase | [NAME], 24-hour graduated: 24Urine |  |  | 5 | mL | Container/Tube: Plastic, 10-mL urine tube (Supply T068) or a clean, plastic aliquot container with no metal cap or glued insert [NAME]: 5 mL Collection Instructions: 1. Collect urine for 24 hours. 2. Add 30 mL of 6N HCl at end of 24-hour urine collection (within 4 hours of completion of collection).  3. Adjust pH to 2.5 to 3 with 6N HCl and mix well before aliquot is taken. Additional Information: 1. 24-Hour volume is required. 2. Avoid taking large doses (>2 g orally/24 hours) of vitamin C during specimen collection. 3. See [NAME] in Special Instructions for multiple collections.   Urine Preservative Collection Options Ambient	Yes Refrigerated	Yes Frozen	Yes 6N HCl	Preferred 50% Acetic Acid	Yes Na2CO3	No Toluene	Yes 6N HNO3	Yes Boric Acid	Yes Thymol	Yes | 5 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	[NAME] collected or sent in container with metal cap | 0.11-0.46 mmol/specimen 9.7-40.5 mg/specimen The reference value is for a 24-hour collection. Specimens collected for other than a 24-hour time period are reported in unit of mmol/L for which reference values are not established. | Monday through Saturday; 1 p.m. | 3 days | 5 days | 1 | 83945 |  |  |  |  | Rochester
OXU | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 7 days
OXU | Order Question | TM17 | Collection Duration |  | Plain Text
OXU | Order Question | VL15 | [NAME] |  | Plain Text
OXU | Result | OCATE | Oxalate, U | Oxalate, U | Numeric |  |  |  |  | mmol/spec |  |  |  |  |  |  |  |  |  | 14862-7
OXU | Result | OXU1 | Oxalate, U | Oxalate, U | Numeric |  |  |  |  | mg/spec |  |  |  |  |  |  |  |  |  | 2701-1
OXU | Result | TM17 | Collection Duration | Collection Duration | Numeric |  |  |  |  | h |  |  |  |  |  |  |  |  |  | 13362-9
OXU | Result | VL15 | [NAME] | [NAME] | Numeric |  |  |  |  | mL |  |  |  |  |  |  |  |  |  | 28009-9
OXU | Result | OX_A | Ox Conc (mmol/L) | Ox Conc (mmol/L) | Numeric |  |  |  |  | mmol/L |  |  |  |  |  |  |  |  |  | 34349-1
OXU | Result | OXCN2 | Oxalate Concentration | Oxalate Concentration | Numeric |  |  |  |  | mg/L |  |  |  |  |  |  |  |  |  | 27222-9
Spreadsheet: 800428d1665664607-formula-to-determine-date-of-sunday-from-last-week-tn-jaipur-order
Sheet: Sheet2

 | RADCO MARKETING PVT. LTD.
 | SOLD TO | SHIP TO | MATERIAL CODE | QTY | PO NUMBER | PO DATE | BEARING NO.
 | 15317 | 34151 | 3011449 | 3 | 1 | 2022-10-13 17:57:05 | UCP215-48(PILLOWBLOCK.P.NPP01)
 |  |  | TOTAL | 3
 | SOLD TO | SHIP TO | MATERIAL CODE | QTY | PO NUMBER | PO DATE | BEARING NO.
 | 15317 | 34150 | 3008257 | 10 | 2 | 2022-10-13 17:57:05 | 1206K(P.NPP01)
 | 15317 | 34150 | 3007778 | 12 | 2 | 2022-10-13 17:57:05 | 33111(NSPP01).NC
 | 15317 | 34150 | 3011077 | 4 | 2 | 2022-10-13 17:57:05 | 3490/3420(P.NSP01)
 | 15317 | 34150 | 3008003 | 20 | 2 | 2022-10-13 17:57:05 | 509043(P.NPP01)
 | 15317 | 34150 | 3008418 | 180 | 2 | 2022-10-13 17:57:05 | 6202(NPP01).NC
 | 15317 | 34150 | 3013284 | 12 | 2 | 2022-10-13 17:57:05 | 6308N(NPP01).M
 | 15317 | 34150 | 3008165 | 6 | 2 | 2022-10-13 17:57:05 | BB1063(C3.EM.E.NPP01)
 | 15317 | 34150 | 3010873 | 32 | 2 | 2022-10-13 17:57:05 | BB1103(CNL.NPP01)
 | 15317 | 34150 | 3014869 | 4 | 2 | 2022-10-13 17:57:05 | CR-55 TM
 |  |  | TOTAL | 280
 | SOLD TO | SHIP TO | MATERIAL CODE | QTY | PO NUMBER | PO DATE | BEARING NO.
 | 15317 | 34340 | 3008086 | 10 | 3 | 2022-10-13 17:57:05 | 6211LLU(NPP01)
 |  |  | TOTAL | 10
Spreadsheet: 600097d1543463487-enter-data-based-on-2-different-cells-2-columns-different-sheets-grading-excel-form
Sheet: T3 AD

First name | Surname | ID number | Institution | Department | Email address | Attendance: Attendance | Assignment: Professionalism | Assignment: Assignment 1: (5 Concepts) | Assignment: Assignment 2: (5 Concepts) | Assignment: Assignment 3: (5 Concepts) | Course total
[NAME] ([NAME]) | [NAME] |  |  |  | [EMAIL] | 10 | 9 | 18 | 18 | 18 | 91.25
Qiran ([NAME]) | [NAME] |  |  |  | [EMAIL] | 10 | 5 | 0 | 0 | 0 | 18.75
Muxin | [NAME] |  |  |  | [EMAIL] | 3.33 | 5 | 0 | 18 | 18 | 55.42
[NAME] ([NAME]) | [NAME] |  |  |  | [EMAIL] | 10 | 9 | 17 | 18 | 18 | 90
Yiming ([NAME]) | [NAME] |  |  |  | [EMAIL] | 6.67 | 5 | 15 | 16 | 0 | 53.33
[NAME] ([NAME]) | Fang |  |  |  | [EMAIL] | 8.33 | 5 | 14 | 16 | 13 | 70.42
Qianyun (Fay) | Fang |  |  |  | [EMAIL] | 10 | 9 | 18 | 17 | 17 | 88.75
Yichao | Fu |  |  |  | [EMAIL] | 10 | 8 | 14 | 17 | 18 | 83.75
Junjie (Riol) | He |  |  |  | [EMAIL] | 10 | 9 | 16 | 17 | 18 | 87.5
Jiaqing (Agnes) | Kang |  |  |  | [EMAIL] | 10 | 9 | 18 | 18 | 18 | 91.25
Yuetong (Isabel) | [NAME] |  |  |  | [EMAIL] | 10 | 8 | 18 | 16 | 18 | 87.5
[NAME]) | [NAME] |  |  |  | [NAME] | 8.33 | 5 | 10 | 10 | 10 | 54.17
[NAME] (Klader) | [NAME] |  |  |  | [EMAIL] | 10 | 8 | 17 | 19 | 17 | 88.75
Ruimin (Vic) | [NAME] |  |  |  | [EMAIL] | 8.33 | 5 | 14 | 14 | 16 | 71.67
[NAME]) | [NAME] |  |  |  | [EMAIL] | 10 | 6 | 14 | 10 | 13 | 66.25
[NAME]Seven ） | Qi |  |  |  | [EMAIL] | 6.67 | 5 | 14 | 14 | 15 | 68.33
Junqi (Voang) | [NAME] |  |  |  | [EMAIL] | 10 | 6 | 14 | 16 | 17 | 78.75
[NAME]） | Xiao |  |  |  | [EMAIL] | 8.33 | 6 | 12 | 15 | 13 | 67.92
[NAME] (Leo) | [NAME] |  |  |  | [EMAIL] | 6.67 | 4 | 12 | 18 | 13 | 67.08
Chenyi (Freddie) | Zhang |  |  |  | [EMAIL] | 10 | 4 | 15 | 16 | 17 | 77.5
Linfeng (Wayne) | Zhang |  |  |  | [EMAIL] | 10 | 8 | 14 | 18 | 17 | 83.75
[NAME] (Vlad) | [NAME] |  |  |  | [EMAIL] | 10 | 9 | 18 | 17 | 17 | 88.75
Xinwei (Will) | [NAME] |  |  |  | [EMAIL] | 10 | 9 | 18 | 17 | 18 | 90
Hui ([NAME]) | Zhu |  |  |  | [EMAIL] | 10 | 9 | 17 | 17 | 17 | 87.5
Spreadsheet: 890036d1741170693-merge-formula-example
Sheet: Sheet1

[NAME] | Ext. number | Name 1 | Name 2 | Name 3 | Name 4 | Addresses-Street | Addresses-House number | Addresses-Country-ISO 2
ROATI1DE | 1 | Auchan Titan |  |  |  | Bulevardul 1 Decembrie 1918 | 33A | RO
 | 2 | Auchan Targu Mures Istoric |  |  |  | Strada Gheorghe Doja | 243 | RO
 | 3 | [NAME] |  |  |  | Dn 65 B, Nr F4 Comuna Bradu | F4 | RO
 | 4 | [NAME] |  |  |  | Strada Alexandru Vaida Voevod | 53B | RO
 | 10 | [NAME] |  |  |  | [NAME] | 564-560 | RO
 | 9 | [NAME] |  |  |  | Calea Unirii | 22 | RO
 | 7 | [NAME] |  |  |  | Strada Aristide Demetriade | 1 | RO
 | 8 | [NAME] |  |  |  | [NAME] Vlaicu | 220 | RO
 | 12 | [NAME] |  |  |  | Calea București | 80 | RO
 | 13 | Auchan City Crangasi |  |  |  | Bulevardul Constructorilor | 16A | RO
Spreadsheet: 34242d1231402744-working-with-dates-and-making-calculations-forum_example_aml_renove_2
Sheet: Hoja1

A_Inventory_Item | [NAME] | A_Manufacturer_Name | A_Installation_Date | A_User_Login | LIFE CYCLE | RENEWAL DATE
ITN0362450 | HW/PC DESKTOP | HP | 2003-12-01 00:00:00 | C11026 | 1/7/5 | 2109-06-02 00:00:00
ITN0398932 | HW/PC LAPTOP | COMPAQ | 2003-09-30 00:00:00 | c15879 | 1/7/3 | 2107-04-01 00:00:00
ITN0414098 | HW/PC Desktop CAD SP | COMPAQ | 2004-03-30 23:00:00 | c18014 | 1/7/3 | 2107-09-30 23:00:00
ITN0416359 | HW/PC LAPTOP | COMPAQ | 2006-01-16 16:16:29 | c33649 | 1/7/3 | 2109-07-18 16:16:29
ITN0137797 | HW/PC Desktop CAD SP | HP | 2002-11-29 12:00:00 | C33608 | 1/7/3 | 2106-05-31 12:00:00
ITN0229788 | HW/PC LAPTOP | COMPAQ | 2004-03-31 11:00:00 | ua4359 | 1/7/3 | 2107-10-01 11:00:00
ITN0344797 | HW/PC DESKTOP | COMPAQ | 2003-09-30 11:00:00 | c40015 | 1/7/5 | 2109-04-01 11:00:00
ITN0457051 | HW/PC DESKTOP | COMPAQ | 2005-04-07 23:00:00 | C40463 | 1/7/5 | 2110-10-08 23:00:00
ITN0305491 | HW/PC DESKTOP | DELL | 2002-12-01 12:00:00 | C11959 | 1/7/5 | 2108-06-02 12:00:00
X500000189 | HW/PC Desktop CAD SP | OTHER | 2008-09-15 00:00:00 | c12637 | 1/7/3 | 2112-03-17 00:00:00
ITN0382104 | HW/PC DESKTOP | ADVANCED | 2002-12-01 12:00:00 | C15009 | 1/7/5 | 2108-06-02 12:00:00
ITN0380146 | HW/PC LAPTOP | DELL | 2001-12-01 12:00:00 | C16709 | 1/7/3 | 2105-06-02 12:00:00
ITN0356644 | HW/PC DESKTOP | MEMOREX | 1994-12-01 12:00:00 | C12437 | 1/7/5 | 2100-06-02 12:00:00
A520080033 | HW/PC Desktop CAD SP | DELL | 2008-04-10 00:00:00 | C39788 | 1/7/3 | 2111-10-11 00:00:00
Spreadsheet: 217051d1361976907-subtracting-business-days-from-end-of-month-sample-1-date_etaf
Sheet: Sheet1

 | Days | End of Month | Date Funds Run Out
LCAT | 6.32 | 2013-03-31 00:00:00
 |  | 2013-04-01 00:00:00
 |  | 2013-04-02 00:00:00
 |  | 2013-04-03 00:00:00
 |  | 2013-04-04 00:00:00
 |  | 2013-04-05 00:00:00
 |  | 2013-04-06 00:00:00
 |  | 2013-04-07 00:00:00
 |  | 2013-04-08 00:00:00
 |  | 2013-04-09 00:00:00
 |  | 2013-04-10 00:00:00
 |  | 2013-04-11 00:00:00
 |  | 2013-04-12 00:00:00
 |  | 2013-04-13 00:00:00
 |  | 2013-04-14 00:00:00
 |  | 2013-04-15 00:00:00
 |  | 2013-04-16 00:00:00
 |  | 2013-04-17 00:00:00
Spreadsheet: 848594d1699295026-get-data-from-web-pq-3tables
Sheet: Table 1

Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column7 | Column8 | Column9 | Column10 | Column11 | Column12
[NAME] |  | Aktuel kurs | Den aktuelle kurs er Realkredit Danmarks markedskurs. [NAME] er den kurs, obligationen handles til, når vi opdaterer tabellen. [NAME] vises med et fradrag på 0,25 kurspoint. [NAME], at [NAME] have ændret sig siden opdateringen. | Tilbudskurs | Når vi afgiver et lånetilbud, anvender vi tilbudskursen. Tilbudskursen er Nasdaq Referencekurs. Den er beregnet på baggrund af de vægtede handler den foregående børsdag fratrukket 0,25 kurspoint. Findes der ikke en gennemsnitskurs, anvender vi et skøn. | UdbetalingskursFastkursaftale 27.11.2023 | Med en fastkursaftale udbetales lånet til en fastlåst kurs på en aftalt dato. [NAME] afhænger af den valgte udbetalingsdato. [NAME] i tabellen er udvalgte eksempler. Når vi beregner en fastkursaftale, anvender vi den [NAME] reguleret med et terminstillæg eller -fradrag alt efter den udbetalingsdato, du vælger. Tabellen viser udbetalingskursen ved seneste opdatering med et fradrag på 0,25 kurspoint. | UdbetalingskursFastkursaftale 29.12.2023 | Med en fastkursaftale udbetales lånet til en fastlåst kurs på en aftalt dato. [NAME] afhænger af den valgte udbetalingsdato. [NAME] i tabellen er udvalgte eksempler. Når vi beregner en fastkursaftale, anvender vi den [NAME] reguleret med et terminstillæg eller -fradrag alt efter den udbetalingsdato, du vælger. Tabellen viser udbetalingskursen ved seneste opdatering med et fradrag på 0,25 kurspoint. | UdbetalingskursFastkursaftale 27.03.2024 | Med en fastkursaftale udbetales lånet til en fastlåst kurs på en aftalt dato. [NAME] afhænger af den valgte udbetalingsdato. [NAME] i tabellen er udvalgte eksempler. Når vi beregner en fastkursaftale, anvender vi den [NAME] reguleret med et terminstillæg eller -fradrag alt efter den udbetalingsdato, du vælger. Tabellen viser udbetalingskursen ved seneste opdatering med et fradrag på 0,25 kurspoint.
Fastforrentet lån med afdrag (årgang 2056)30 år / 5,0 %DK0004626918 | SE DETALJER | 97,750 |  | 97,642 |  | 97,632 |  | 97,436 |  | 97,009
Fastforrentet lån med op til 10 års afdragsfrihed (årgang 2056)30 år / 5,0 %DK0004627056 | SE DETALJER | 97,000 |  | 96,988 |  | 96,881 |  | 96,684 |  | 96,250
[NAME] med op til 30 års afdragsfrihed (årgang 2056)30 år / 5,0 %DK0004626405 | SE DETALJER | 95,550 |  | 95,465 |  | 95,429 |  | 95,228 |  | 94,782
Fastforrentet lån med afdrag (årgang 2056)30 år / 4,0 %DK0004627130 | SE DETALJER | 93,200 |  | 93,960 |  | 93,127 |  | 93,007 |  | 92,788
Fastforrentet lån med afdrag (årgang 2046)20 år / 4,0 %DK0004626835 | SE DETALJER | 94,550 |  | 94,375 |  | 94,479 |  | 94,362 |  | 94,154
Fastforrentet lån med afdrag (årgang 2036)10 år / 3,0 %DK0004626751 | SE DETALJER | 94,810 |  | 94,700 |  | 94,791 |  | 94,761 |  | 94,801
Spreadsheet: 804644d1668195490-i-need-a-formula-for-an-avg-of-a-data-set-found-on-multiple-sheets-but-must-exclude-zeroes-mmjj-drivosity-scores-test
Sheet: 1554

First | Last | 4 week Score Avg | 4 week Incident per [NAME] | Week 41 Score | Week 41 Incidents Per Mile | Week 42 Score | Week 42 Incidents Per Mile | Week 43 Score | Week 43 Incidents Per Mile | Week 44 Score | Week 44 Incidents Per Mile
Branden | Arrolyo |  |  | 82 | 1.57 | 90 | 1.39 | 90 | 1.43 | n/a | n/a
[NAME] | Gariboldi |  |  | 98 | 0.4 | 96 | 0.68 | 98 | 0.26 | 98 | 0.32
Stephen | Griffin |  |  | n/a | n/a | n/a | n/a | 98 | 0.56 | n/a | n/a
[NAME] | Nau |  |  | 96 | 0.64 | 94 | 0.65 | 96 | 0.51 | 95 | 0.69
Ozgur | [NAME] |  |  | 96 | 0.59 | 93 | 0.87 | 97 | 0.33 | 94 | 0.64
 | Store Average
Spreadsheet: vkaminski__40831__SRMReport-3-31-01
Sheet: Capital Portfolio

 |  | DRAFT
 |  |  |  |  |  |  |  |  |  | SRM REPORT
 |  |  |  |  |  |  |  |  | As of
 |  | Net Open Position |  | Mark-to-Market Value |  |  | Value at Risk |  |  | Economic P&L ($ millions)
 |  | long / (short) |  | $ millions |  |  | 1-Day, 95% ($ millions) | 10 |  | QTD | YTD | YTD | LTD
Capital Portfolio
Raptor - Credit Capacity Foregone
UNITED STATES
CANADA
Active Power |  | 1021107 | Shares
AVICI |  | 1092426 | Shares
Hanover Compressor |  | 4181754 | Shares
New Power Company |  |  | Shares
Enron Stock Option Plans
UNITED STATES
CANADA
ENE Exercisable Options |  | -46437195 | Shares Equiv. |  |  |  | 172
Interest Rate Sensitivity |  | -2832.818178999999 | $/Bps
 |  |  |  |  |  |  |  |  |  | 37080
Spreadsheet: 44795d1243539365-lookup-sheets-and-sumifs-criteria-lookupsumif
Sheet: 66105

braches rent account
NL Code | Month | J R | Date | Ref 1 | Ref 2 | Amount
266105 | 1 | 196 | 2009-05-29 00:00:00 | CB |  | 500
566105 | 1 | 197 | 2009-05-29 00:00:00 | CB |  | 700
 |  |  |  |  |  | 1200
Spreadsheet: 715952d1611934099-index-match-and-sumifs-sample-data
Sheet: Analysis

Deck
Officer
 | Department A | Department B
Salary
Leave
Expenses
Deck
Rating
 | Department A | Department B
Salary
Leave
Expenses
Engine
Officer
 | Department A | Department B
Salary
Leave
Expenses
Engine
Rating
 | Department A | Department B
Salary
Leave
Expenses
Spreadsheet: 218822d1362587354-copy-formula-down-across-using-data-table-with-conditional-row-column-parameters-worked-example
Sheet: Forum Test

 |  |  |  | 2012-01-01 00:00:00 | 2012-02-01 00:00:00 | 2012-03-01 00:00:00 | 2012-04-01 00:00:00 | 2012-05-01 00:00:00 | 2012-06-01 00:00:00 | 2012-07-01 00:00:00 | 2012-08-01 00:00:00 | 2012-09-01 00:00:00 | 2012-10-01 00:00:00 | 2012-11-01 00:00:00 | 2012-12-01 00:00:00 | 2013-01-01 00:00:00 | 2013-02-01 00:00:00 | 2013-03-01 00:00:00 | 2013-04-01 00:00:00 | 2013-05-01 00:00:00 | 2013-06-01 00:00:00 | 2013-07-01 00:00:00 | 2013-08-01 00:00:00 | 2013-09-01 00:00:00 | 2013-10-01 00:00:00 | 2013-11-01 00:00:00 | 2013-12-01 00:00:00 | 2014-01-01 00:00:00 | 2014-02-01 00:00:00 | 2014-03-01 00:00:00 | 2014-04-01 00:00:00 | 2014-05-01 00:00:00 | 2014-06-01 00:00:00 | 2014-07-01 00:00:00 | 2014-08-01 00:00:00 | 2014-09-01 00:00:00 | 2014-10-01 00:00:00 | 2014-11-01 00:00:00 | 2014-12-01 00:00:00 | 2015-01-01 00:00:00 | 2015-02-01 00:00:00 | 2015-03-01 00:00:00 | 2015-04-01 00:00:00 | 2015-05-01 00:00:00 | 2015-06-01 00:00:00 | 2015-07-01 00:00:00 | 2015-08-01 00:00:00 | 2015-09-01 00:00:00 | 2015-10-01 00:00:00 | 2015-11-01 00:00:00 | 2015-12-01 00:00:00
 |  | Example for PO1 (Purchase Order) | PO1
 |  |  | PO2
 |  |  | PO3
 |  |  | PO4
 |  |  | PO5
 |  |  |  | Problem:
 |  |  | Sample from Cell E2 | INDEX('PIP Input'!$C$17:$C$29,MATCH(H$1,('PIP Input'!$H$17:$H$29),0),MATCH($B4,'PIP Input'!$H$15:$L$15,0)) (assume this is for PO1 on row 1)
 |  |  | Problem | The formula in E2 is inefficient and requires me to change the PO block as I copy the formula down.
 |  |  |  | The formula above is part way there, but the MATCH($B4,'PIP Input'!$H$15:$L$15,0) needs to be embedded perhaps into the first Match to somehow shift the array to the right.
 |  | Data Input Table
 |  |  |  |  | PO1 | PO2 | PO3 | PO4 | PO5
 |  |  | ADV |  | 2012-01-01 00:00:00 | 2012-02-01 00:00:00 | 2012-09-01 00:00:00 | 2012-10-01 00:00:00 | 2012-11-01 00:00:00
 |  |  | MAT |  | 2012-08-01 00:00:00 | 2013-09-01 00:00:00 | 2013-10-01 00:00:00 | 2013-11-01 00:00:00 | 2013-12-01 00:00:00
 |  |  | PPAC25% |  | 2013-04-01 00:00:00 | 2013-05-01 00:00:00 | 2013-06-01 00:00:00 | 2013-07-01 00:00:00 | 2013-08-01 00:00:00
 |  |  | PPAC50%
 |  |  | PPAC75%
 |  |  | PAC |  | 2013-09-01 00:00:00 | 2012-08-01 00:00:00 | 2013-11-01 00:00:00 | 2013-12-01 00:00:00 | 2013-11-01 00:00:00
 |  |  | FAC |  | 2014-02-01 00:00:00 | 2014-04-01 00:00:00 | 2014-06-01 00:00:00 | 2014-08-01 00:00:00 | 2014-10-01 00:00:00
Spreadsheet: holden_salisbury__12323__PrePay Accounting_1220
Sheet: Mead- Sun

Hour
Ending
Pacific | Mead physical | EOL | NEVP | [NAME] | IPC | From | From | PAC | Duke | To | To | WAPA Trans | Balance
Standard | position | Purch/Sale |  |  | Purch | CISO | CISO | Sale | Sale | CISO | CISO | to Pin Pk |  |  | Hour | Total | Total
(PST) |  |  | ld | ld | 28 | STSW | STSW | ld | ld | STSW | STCALI | 78 MW |  |  | Ending | To PX | From PX
100 | -79 |  | 50 | 100 | 104 |  |  | -50 | -125 |  |  |  |  |  | 100 |  |  | -1
200 | -79 |  | 50 | 100 | 104 |  |  | -50 | -125 |  |  |  |  |  | 200 |  |  | -1
300 | -79 |  | 50 | 100 | 104 |  |  | -50 | -125 |  |  |  |  |  | 300 |  |  | -1
400 | -79 |  | 50 | 100 | 104 |  |  | -50 | -125 |  |  |  |  |  | 400 |  |  | -1
500 | -79 |  | 50 | 100 | 104 |  |  | -50 | -125 |  |  |  |  |  | 500 |  |  | -1
600 | -79 |  | 50 | 100 | 104 |  |  | -50 | -125 |  |  |  |  |  | 600 |  |  | -1
700 | -29 |  | 50 | 100 | 54 |  |  | -50 | -125 |  |  |  |  |  | 700 |  |  | -1
800 | -29 |  | 50 | 100 | 54 |  |  | -50 | -125 |  |  |  |  |  | 800 |  |  | -1
900 | -29 |  | 50 | 100 | 54 |  |  | -50 | -125 |  |  |  |  |  | 900 |  |  | -1
1000 | -29 |  | 50 | 100 | 54 |  |  | -50 | -125 |  |  |  |  |  | 1000 |  |  | -1
1100 | -29 |  | 50 | 100 | 54 |  |  | -50 | -125 |  |  |  |  |  | 1100 |  |  | -1
1200 | -29 |  | 50 | 100 | 54 |  |  | -50 | -125 |  |  |  |  |  | 1200 |  |  | -1
1300 | -29 |  | 50 | 100 | 54 |  |  | -50 | -125 |  |  |  |  |  | 1300 |  |  | -1
1400 | -29 |  | 50 | 100 | 54 |  |  | -50 | -125 |  |  |  |  |  | 1400 |  |  | -1
1500 | -29 |  | 50 | 100 | 54 |  |  | -50 | -125 |  |  |  |  |  | 1500 |  |  | -1
1600 | -29 |  | 50 | 100 | 54 |  |  | -50 | -125 |  |  |  |  |  | 1600 |  |  | -1
1700 | -29 |  | 50 | 100 | 54 |  |  | -50 | -125 |  |  |  |  |  | 1700 |  |  | -1
1800 | -29 |  | 50 | 100 | 54 |  |  | -50 | -125 |  |  |  |  |  | 1800 |  |  | -1
1900 | -29 |  | 50 | 100 | 54 |  |  | -50 | -125 |  |  |  |  |  | 1900 |  |  | -1
2000 | -29 |  | 50 | 100 | 54 |  |  | -50 | -125 |  |  |  |  |  | 2000 |  |  | -1
2100 | -29 |  | 50 | 100 | 54 |  |  | -50 | -125 |  |  |  |  |  | 2100 |  |  | -1
2200 | -29 |  | 50 | 100 | 54 |  |  | -50 | -125 |  |  |  |  |  | 2200 |  |  | -1
2300 | -29 |  | 50 | 100 | 54 |  |  | -50 | -125 |  |  |  |  |  | 2300 |  |  | -1
2400 | -29 |  | 50 | 100 | 54 |  |  | -50 | -125 |  |  |  |  |  | 2400 |  |  | -1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Totals