tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: kam_keiser__17940__B-JAN09-3-ST-7
Sheet: Sheet1

From: | Risk Management -Controls |  |  |  |  |  |  |  |  |  |  |  |  |  | Department: | Risk Management
Subject: | New Book Request # [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | Date:
Requestor: | [NAME]
COUNTERPARTY |  | BOOK PURPOSE |  |  | TAGG |  |  |  |  |  |  |  |  | BOOK INFORMATION |  |  |  |  | Reporting -Subledger
 |  | Type Of Transactions |  |  | Book Mapping
Short Name | Long Name | Internal | External | Both | Code | Region | P | B | Idx | [NAME] | PHY | Y | Commodity/UOM/Curr | [NAME] | MTM/ACCRUAL | Reason For Book | Date Needed |  | MTM | Prud | Realized
PERFORMANCE | PERFORMANCE |  |  | X | HO | DESK | X | X | X | X |  | X | NG/MMBTU/USD |  | MTM | Estate book
IM-PERFORMANCE | IM-PERFORMANCE |  |  | X | HP | DESK |  |  |  |  | X |  | NG/MMBTU/USD |  | MTM | Estate book
FT-PERFORMANCE | FT-PERFORMANCE |  |  | X | HQ | DESK |  |  |  |  | X |  | NG/MMBTU/USD |  | MTM | Estate book
(Note 1) Please ensure access to both production and stage to enter deals, calculate books and set the official flag.
*A unique portfolio/book code will be assigned to your book unless you request a specific portfolio/book code.
BOOK CANNOT BE SET UP IF THERE IS ANY MISSING INFORMATION.
***Please provide login names for book administrators.***
 |  |  |  |  |  |  |  |  |  |  |  |  | RisktRAC Check List |  | Added (Y/N) | Processors ID
IT SECURITY | Book |  |  |  |  |  |  |  |  |  |  |  | Created in RisktRAC |  | Y | ST
Access List | Administrator* |  |  |  |  |  |  |  |  |  |  |  | Hierarchy |  | Y | ST
trohaue |  |  |  |  |  |  |  |  |  |  |  |  | Sent to GCP |  | Y | ST
[NAME] (emclaug) |  |  |  |  |  |  |  |  |  |  |  |  | Created in TAGG/ERMS |  | Y | ST
[NAME] (kloibl) |  |  |  |  |  |  |  |  |  |  |  |  | Cross-Commodity DBA |  | N/A | N/A
[NAME] ([NAME])
[NAME] (bjones7) |  |  |  |  |  |  |  |  |  |  |  |  | PORTFOLIO NAME |  | Added (Y/N) | Processors ID
[NAME] (molney) |  |  |  |  |  |  |  |  |  |  |  | ALL: | AGG-CREDIT
[NAME] (dbailey) |  |  |  |  |  |  |  |  |  |  |  |  | AGG-PROD-DPR-BU
[NAME] ([NAME]) |  |  |  |  |  |  |  |  |  |  |  |  | AGG-PROD-DPR-CM
[NAME] (lvargas2) |  |  |  |  |  |  |  |  |  |  |  |  | DISCOUNTING USD
[NAME] (acavazos) |  |  |  |  |  |  |  |  |  |  |  | IF: | GDI
 |  |  |  |  |  |  |  |  |  |  |  |  | AGG-GD-INDEX
 |  |  |  |  |  |  |  |  |  |  |  | IF: | Index
 |  |  |  |  |  |  |  |  |  |  |  |  | AGG-INDEX
 |  |  |  |  |  |  |  |  |  |  |  | IF: | Gas
 |  |  |  |  |  |  |  |  |  |  |  |  | AGG-GAS III & IV
ADDITIONAL COMMODITIES FOR BANKRUPTCY-EGM BOOK : |  |  |  |  |  |  |  |  |  |  |  | ALL: | AGG-TEST BU
CL | GOIP | MEOH | PARA | COND
[NAME] | GOSG | NC4 | STYR | DUBA
CLCM | PN | BLND | XYLE | NAPS
BRNT | BENZ | IC4 | MEG | 61NY
BRCM | COAL | IC4= | PYGS | 61GC
HO | PYST | C5+ | ETHE | 63GC
[NAME] | TOLU | C2GC | PVC | LSNF
KERO | PLYE | NC4E | PROP | HSNF
KERS | HG | NAPE | PYPP | 62NY
.2GO | MTBE | C3E | PYST | TAPI
HSFS | 63NY | FTR | DISL | KERE
Spreadsheet: 28794610-5b34-426d-8ef8-3e1b8f2e6aa2
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
FFTLB | Test | FFTLB | Toluene, Occupational Exposure, Blood | Toluene, Blood | Headspace Gas Chromatography/Flame Ionization Detection (GC-FID) | Green-Top Tube (Sodium Heparin): GrnNaHp |  |  |  |  | Draw blood in 2 green top (sodium heparin) tubes. Tubes should be filled to prevent loss of volatile compound into headspace. Send 20 mL of sodium heparin whole blood refrigerated. | 2.5 mL | Hemolysis	NA Thawing	NA Lipemia	NA Icterus	NA Other	NA | Units:	mg/L  Normal (unexposed population):	None detected  Exposed: Biological Exposure Index (BEI):	0.05 mg/L (prior to last shift of workweek) Biological Tolerance Value (BAT):	1.0 mg/L (end of exposure or end of shift)  Toxic: Blood levels between 50 and 79 mg/L were found in people who died of acute toluene inhalation.  Test Performed By:	Medtox Laboratories, Inc.  			402 W. County Road D 			St. Paul, MN 55112 | Monday through Sunday | 7 days | 9 - 11 days | 1 | 84600 |  |  |  |  | Medtox Laboratories, Inc.
FFTLB | [NAME] | WBNAH | WB Sodium Heparin |  |  |  | Refrigerated | 14 days
FFTLB | Result | Z1203 | Toluene | Toluene | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 827059d1682450595-unable-to-get-countif-formula-to-calculate-two-columns-vehicle-inventory-3
Sheet: Sheet1

DISTRICT / SITE | PARKING SLOT # | VIN | MAKE | MODEL
1/1 | 120 | JH4KA3170LC006787 | Chevrolet | 2.6
1/4 | 11 | [NAME] | Ford | Type III
1/1 | 12 | 2C4GM68475R667819 | Dodge | ORV
1/3 | 65 | 1P4GH44R0RX359386 | Chevrolet | 2.1
1/3 | 12 | 1P4GH44R0RX359386 | Toyota | ORV II
1/1 | 1 | 1GBJ7D1B4BV132373 | Ford | Type III
1/4 | 66 | JH4KA2640GC004861 | Toyota | ORV II
1/2 | 41 | JH4CC2640NC004693 | Toyota | ORV II
 | Chevrolet | Toyota | Dodge | Ford | Ford Type III
Site 1
Site 2
Site 3
Site 4
Spreadsheet: 748735d1632319356-work-out-daily-amount-to-target-31-day-figures
Sheet: 12th

 |  |  |  | TURNOVER |  |  |  |  | REVENUE
 | AREA 3 |  |  | Target | Needed Daily | Actual | [NAME] |  | Target | Needed Daily | Actual | [NAME] |  | [NAME]'s | ATV |  | [NAME] | SALT £ |  | TMC |  | BB+ |  | Errors
 | Asda - Aintree
 | Asda - Huyton
 | Asda - Hunts Cross
 | Asda - Horwich
 | Asda - Leigh
 | Asda - Burnley
 | Asda - Westbrook
 | Asda - Widnes
 | Asda - Bromborough
 | Asda - Accrington
 | Asda - Colne
 | Asda - Clayton Green
 | Asda - Runcorn
 | Asda - Blackburn
 | Asda - Walton
 | Asda - Blackpool
 | Asda - Wigan
 | Asda - Preston
Spreadsheet: 97240d1296481686-if-statement-and-summing-excel
Sheet: Sheet1

Company | Days | Days overtime | Sum of company A | Sum of company B | Sum of Company C | Date
A | 8 | 2 | 10 | 0 | 0 | 2011-01-14 00:00:00
B | 8 | 5 |  |  |  | 2011-01-31 00:00:00
C | 8 | 3 |  |  |  | 2011-02-03 00:00:00
Spreadsheet: 733391d1621542721-second-screen-projections-issue-example-book
Sheet: Data

Name | Points | Place | Points | Place | Points | Place | Points | Place |  | Total | Weeks Played
[NAME] | 70 | 3 | 80 | 2
[NAME] | 50 | 5 | 100 | 1
[NAME] | 100 | 1 | 40 | 6
Wayne | 80 | 2 | 60 | 4
[NAME] | 60 | 4 | 70 | 3
Fred | 40 | 6 | 50 | 5
Spreadsheet: 155272d1336748435-how-to-fill-in-cells-with-reference-column-an-row-0h
Sheet: Sheet2

 | leeftijd | sporten | reporten
pieter | 21 | voetbal | 6
gerard | 23 | basketball | 8
[NAME] | 20 | hockey | 8
[NAME] | 32 | voetbal | 3
joop | 22 | paardrijden | 6
Spreadsheet: 06db43f8-aab8-48d1-9702-33850812574a
Sheet: Sheet1

2013 BUDGET FOR WMF PROPOSALS | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
PROJECT NAME: | Our Weed Management Project
DESCRIPTION - EXAMPLE |  | CDA WMF FUNDS | MATCHING FUNDS |  | PARTNER CASH | PARTNER IN-KIND | OTHER CASH | OTHER IN-KIND | ITEM TOTAL
 |  |  | APPLICANT CASH | APPLICANT IN-KIND
EXPENSES
Contracted Services |  | 2150 | 2500 |  | 4000 |  | 150 |  | 6650
[NAME] labor (25 people x 20 hrs x $12/hr) |  |  |  | 5000 |  | 1000 |  |  | 6000
Equipment - handheld GPS units (2) |  | 250 |  |  |  |  |  |  | 0
Equipment - herbicide |  | 500 | 2000 |  | 1000 |  |  |  | 3000
Educational - 1,000 door hangers |  | 100 |  |  |  |  | 100 |  | 100
Educational - 1,000 brochures - fair booth |  |  |  |  |  |  | 250 |  | 250
Seasonal employee |  | 4500 | 3000 | 500 |  |  |  |  | 3500
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0
SUMMARY OF PROJECT FUNDS |  | 7500 | 7500 | 5500 | 5000 | 1000 | 500 | 0 | 19500
AMOUNT OF WMF GRANT REQUEST: |  | 7500
REQUIRED MINIMUM MATCH: |  | 15000
PROPOSED MATCH: |  | 19500
Spreadsheet: 180986d1347891927-find-match-a-cell-value-to-another-cell-and-return-all-column-values-book2
Sheet: Sheet1

Name G | Name C | Name C | Name A | Name E | Name F | Name X | Name B
1 | 2 | 4 | 18 | 3 | 8 | 10 | 20
1 | 2 | 4 | 18 | 3 | 8 | 10 | 20
1 | 2 | 4 | 18 | 3 | 8 | 10 | 20
1 | 2 | 4 | 18 | 3 | 8 | 10 | 20
1 | 2 | 4 | 18 | 3 | 8 | 10 | 20
1 | 2 | 4 | 18 | 3 | 8 | 10 | 20
1 | 2 | 4 | 18 | 3 | 8 | 10 | 20
1 | 2 | 4 | 18 | 3 | 8 | 10 | 20
1 | 2 | 4 | 18 | 3 | 8 | 10 | 20
1 | 2 | 4 | 18 | 3 | 8 | 10 | 20
1 | 2 | 4 | 18 | 3 | 8 | 10 | 20
1 | 2 | 4 | 18 | 3 | 8 | 10 | 20
1 | 2 | 4 | 18 | 3 | 8 | 10 | 20
1 | 2 | 4 | 18 | 3 | 8 | 10 | 20
1 | 2 | 4 | 18 | 3 | 8 | 10 | 20
1 | 2 | 4 | 18 | 3 | 8 | 10 | 20
1 | 2 | 4 | 18 | 3 | 8 | 10 | 20
1 | 2 | 4 | 18 | 3 | 8 | 10 | 20
1 | 2 | 4 | 18 | 3 | 8 | 10 | 20
1 | 2 | 4 | 18 | 3 | 8 | 10 | 20
Spreadsheet: 40491d1238789871-importing-data-conditionally-from-1-worksheet-to-another-book2-1
Sheet: Sheet2

Label: | 2 |  | Count: | 3
ID | Label | INFOA | INFOB | INFOC
4 | 2 | [NAME] | [NAME] | dsa
5 | 2 | asdf | asdf | asdf
6 | 2 | [NAME] | [NAME] | dsa
Spreadsheet: 59979d1260495908-vlookup-or-conditional-lookup-red-or-green-master-with-contest-
Sheet: TRENDS

Sales Rep | Post Goal | Post Actual | Other Goal | Other Actual | Accessory Goal | Accessory Actual | At Home Goal | At Home Actual | Upgrade Goal | Upgrade Actual
[NAME] | 24 | 7 | 6 | 4 | 950 | 425 | 1 | 0 | 71 | 7
[NAME] | 24 | 0 | 7 | 1 | 1075 | 46 | 1 | 0 | 78 | 6
Axel | 24 | 2 | 6 | 4 | 950 | 222 | 1 | 0 | 71 | 10
Kaleb | 24 | 7 | 6 | 4 | 950 | 208 | 1 | 0 | 71 | 15
[NAME] | 24 | 6 | 6 | 1 | 950 | 298 | 1 | 0 | 71 | 8
Jordyn | 24 | 4 | 7 | 2 | 1075 | 635 | 1 | 0 | 78 | 10
[NAME] | 28 | 5 | 10 | 3 | 1221 | 146 | 1 | 1 | 92 | 7
Store | 172 | 31 | 48 | 19 | 7171 | 1994 | 7 | 1 | 532 | 64
 |  |  |  |  |  |  | Numbers Updated As Of: |  |  | 8
Rep | Post % | Other % | Accessory % | At Home % | Upgrade %
 |  |  |  |  |  |  | Rep | Combined % to goal
[NAME] | 1.09375 | 2.5 | 1.677631578947368 | 0 | 0.3697183098591549
[NAME] | 0 | 0.5357142857142857 | 0.1604651162790698 | 0 | 0.2884615384615384 |  | [NAME] | 1.375
Axel | 0.3125 | 2.5 | 0.8763157894736842 | 0 | 0.528169014084507 |  | [NAME] | 0.1209677419354839
Kaleb | 1.09375 | 2.5 | 0.8210526315789474 | 0 | 0.7922535211267606 |  | Axel | 0.75
[NAME] | 0.9375 | 0.625 | 1.176315789473684 | 0 | 0.4225352112676056 |  | Kaleb | 1.375
Jordyn | 0.625 | 1.071428571428571 | 2.215116279069767 | 0 | 0.4807692307692308 |  | [NAME] | 0.875
[NAME] | 0.6696428571428571 | 1.125 | 0.4484029484029484 | 3.75 | 0.2853260869565217 |  | Jordyn | 0.7258064516129032
Store | 0.6758720930232558 | 1.484375 | 1.042741598103472 | 0.5357142857142857 | 0.4511278195488722 |  | [NAME] | 0.7894736842105263
 |  |  |  |  |  |  | Store | 0.8522727272727273
Rep | Feature | PHP | VOC
[NAME] | 38 | 0.57 | 0.68 |  | STORE LEVEL GOALS
[NAME] | 0 | 0.75 |  |  | Post | Other | Accessory | At Home | Upgrade
Axel | 75 | 0.36 |  |  | 172 | 48 | 7171 | 7 | 532
Kaleb | 26 | 0.74
[NAME] | 47 | 0.17 | 1
Jordyn | 71 | 0.59 | 1 |  |  | Store Conversion
[NAME] | 35 | 0.79 |  |  |  | 0.033
Store | 44 | 0.58 | 0.89
Spreadsheet: 127307d1320278707-excel-2007-need-to-find-if-duplicate-values-exist-in-a-master-sheet-compare-in-new-generated-sh-example-1
Sheet: Output

priority | internal | co no | pol no | rid no | proces | step
5 | 1 | 3K | 4567253 | 0 | WYN | ZOC
5 | 2 | 3G | 12345785 | 0 | WYN | POL
5 | 3 | 2R | 12345785 | 0 | SNA | LOP
Spreadsheet: 199943d1355368580-help-a-teacher-day-how-to-pull-data-from-a-sheet-to-enter-in-a-calendar-example1
Sheet: Student1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Weekly Progress Report
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Parent Signature : _____________________   Date:__________
 |  | Points |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Teacher Comments
Monday | On time |  |  |  |  |  |  |  |  |  |  | Time |  | Comment
 | Tardy
 | On Task
____/____ | Response
 | Disruption
 | Homework
 | Classwork
 | Points
Tuesday | On time |  |  |  |  |  |  |  |  |  |  | Time |  | Comment
 | Tardy
 | On Task
____/____ | Response
 | Disruption
 | Homework
 | Classwork
 | Points
Wed. | On time |  |  |  |  |  |  |  |  |  |  | Time |  | Comment
 | Tardy
 | On Task
____/____ | Response
 | Disruption
 | Homework
 | Classwork
 | Points
Thursday | On time |  |  |  |  |  |  |  |  |  |  | Time |  | Comment
 | Tardy
 | On Task
____/____ | Response
 | Disruption
 | Homework
 | Classwork
 | Points
Friday | On time |  |  |  |  |  |  |  |  |  |  | Time |  | Comment
 | Tardy
 | On Task
____/____ | Response
 | Disruption
 | Homework
 | Classwork
 | Points
Spreadsheet: 793652d1661612217-how-to-repeatedly-add-charges-from-one-row-to-another-within-a-block-of-rows-2022-08-27-oeldere-joseph222555-sample-workbook-2-
Sheet: PT

Som [NAME] | Kolomlabels
Rijlabels | RENT | sales | Eindtotaal
111 | 230 | 2105 | 2335
Cable Television Charges |  | 90 | 90
First Floor | 75 |  | 75
Garage Parking Charges |  | 150 | 150
Pet Yard | 125 |  | 125
Rent |  | 1800 | 1800
RUBS - Pest Control |  | 15 | 15
RUBS - Valet Trash |  | 35 | 35
Technology Fee |  | 15 | 15
Washer/Dryer | 30 |  | 30
112 | 105 | 1466.95 | 1571.95
Cable Television Charges |  | 90 | 90
First Floor | 75 |  | 75
Mitigated Risk |  | 11.95 | 11.95
Rent |  | 1300 | 1300
RUBS - Pest Control |  | 15 | 15
RUBS - Valet Trash |  | 35 | 35
Technology Fee |  | 15 | 15
Washer/Dryer | 30 |  | 30
113 | 230 | 1961.95 | 2191.95
Cable Television Charges |  | 90 | 90
First Floor | 75 |  | 75
Mitigated Risk |  | 11.95 | 11.95
Pet Rent |  | 20 | 20
Pet Yard | 125 |  | 125
Pool View |  | 25 | 25
Rent |  | 1750 | 1750
RUBS - Pest Control |  | 15 | 15
RUBS - Valet Trash |  | 35 | 35
Technology Fee |  | 15 | 15
Washer/Dryer | 30 |  | 30
114 | 230 | 1541.95 | 1771.95
Cable Television Charges |  | 90 | 90
First Floor | 75 |  | 75
Mitigated Risk |  | 11.95 | 11.95
Pet Yard | 125 |  | 125
Pool View |  | 25 | 25
Rent |  | 1350 | 1350
RUBS - Pest Control |  | 15 | 15
RUBS - Valet Trash |  | 35 | 35
Technology Fee |  | 15 | 15
Washer/Dryer | 30 |  | 30
115 | 105 | 1526.95 | 1631.95
Cable Television Charges |  | 90 | 90
First Floor | 75 |  | 75
Mitigated Risk |  | 11.95 | 11.95
Rent |  | 1360 | 1360
RUBS - Pest Control |  | 15 | 15
RUBS - Valet Trash |  | 35 | 35
Technology Fee |  | 15 | 15
Washer/Dryer | 30 |  | 30
Eindtotaal | 900 | 8602.8 | 9502.8
Spreadsheet: 598914d1542791211-reducing-drop-down-list-options-with-some-static-items-book1
Sheet: Sheet1

Name | Number | Available
 |  | Sick
q |  |  |  |  | Sick
w
e |  |  |  |  | w
r |  |  |  |  | Sick
t |  |  |  |  | r
y
u
i
o
p
a
Spreadsheet: darrell_schoolcraft__7346__imball0201
Sheet: Calpine

 | Calpine So. Point Power Del
 | 78113
Day | Measured | Scheduled
1 | -80749 | -80287 |  |  |  |  |  |  |  | San Juan
2 | -84767 | -80299 |  |  |  | Month | Measured | Scheduled | Imbalance | Index | Amount
3 | -83988 | -90299 |  |  |  | 2001-02-01 00:00:00 | -537 | -5933 |  | 5.62
4 | -99040 | -90299 |  |  |  | 2001-03-01 00:00:00 | -80533 | -96000 |  | 4.98
5 | -88188 | -70519 |  |  |  | 2001-04-01 00:00:00 | -819833 | -1020974 |  | 4.87
6 | -84068 | -85299 |  |  |  | 2001-05-01 00:00:00 |  | -1252019 |  | 3.82
7 | -87540 | -86191 |  |  |  | 2001-06-01 00:00:00 |  | -1589467 |  | 3.2
8 | -85134 | -87137 |  |  |  | 2001-07-01 00:00:00 | -2051914 | -1898771 |  | 2.77
9 | -85234 | -101799 |  |  |  | 2001-08-01 00:00:00 | -2021619 | -1999977 |  | 2.77
10 | -87361 | -95299
11 | -89069 | -85299
12 | -86933 | -86648
13 | -85505 | -85277
14 | -88136 | -85286 |  |  |  | 9/1 - 9/25
15 | -88250 | -90299
16 | -82036 | -85299
17 | -57349 | -85299
18
19 |  |  |  |  |  | Accumulated @ 9/25/01
20
21 |  |  |  |  |  | Equilalent volumes at 9/25/01
22
23
24
25
26
27
28
29
30
31
2001-12-31 00:00:00 |  |  | 178976.97
2002-01-17 00:00:00
CBS Volume
 |  |  | 173146
Spreadsheet: 3176dc6c-eea7-43f1-9b38-40abaa2eac87
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
4179 | 15132 | [NAME] | Figari | PER | 0 | 00:17:46 | 00:00:00 | 01:07:52 | 00:00:00 | 00:28:10 | 1 | 01:53:49
4179 | 15371 | [NAME] | Tellechea | ARG | 0 | [NAME] | 00:00:00 | [NAME] | 00:00:00 | 00:29:12 | 2 | 01:54:50
4179 | 22097 | Mario | [NAME] | ARG | 0 | 00:16:25 | 00:00:00 | 01:14:01 | 00:00:00 | 00:31:36 | 3 | [NAME]
4179 | 15974 | Rodrigo | [NAME] | PER | 0 | 00:17:33 | 00:00:00 | [NAME] | 00:00:00 | 00:35:35 | 4 | 02:22:21
4179 | 15306 | [NAME] | Del Carpio Delgado | PER | 0 | 00:20:57 | 00:00:00 | [NAME] | 00:00:00 | 00:40:01 | 5 | [NAME]
Spreadsheet: 65123d1265854188-vlookup-with-potential-for-multiple-matches-mail-test-mod
Sheet: Mail

Assigned Date | Received Date | CN | ID | EIP Name | [NAME] | File Handler ID
2010-02-03 00:00:00 | 2010-01-29 00:00:00 | 156581530 | 6 |  |  | LD0P | 1 | LD0P1 | 156581530
 |  | 156581531 |  |  |  | LD0P | 2 | LD0P2 | 156581531
2010-02-03 00:00:00 | 2010-02-01 00:00:00 | 156553737 | 1 |  |  | MKNB | 1 | MKNB1 | 156553737
 |  | 156553738 |  |  |  | MKNB | 2 | MKNB2 | 156553738
 |  |  |  |  |  |  | A VLOOKUP only works properly when the value being looked for is in the first column and the range is sorted on the first column.
Spreadsheet: 862010d1709814528-summarizing-no-of-orders-from-the-different-sheets-to-a-table-master-plan-202403-rev-2
Sheet: MAR 2024

MASTER PLAN MAR 2024
Legend:
(M) - Monthly |  | (Q) - Quarterly
(B) - Bi-Monthly |  | (A) - Annually
(H) - Half-Yearly |  | (PITC) - 5 Yearly inspection
(#) - 1 hr On-load test
(ON) - Genset On-Load Test
(OFF) - Genset Off-Load Test
 | Item | 2024-03-01 00:00:00
 | 1
 | 2
 | 3
 | 4
 | 5
 | 6
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15
 | 16
 | 17
 | 18
 | 19
 | 20
Spreadsheet: 1b09c658-948a-4184-a432-a3c62bd9d0a4
Sheet: 9c

Product1 | 0-34 | 3-6 | 6-12 | 12-24 | 24-60 | 60-120 | 120-360 | 360+ | TOTAL
Fixed-Float | 326585 | 67380 | 139033 | 324873 | 730490 | 350721 | 183495 | 28693 | 2151271
OTHER* | 101572 | 103260 | 257144 | 200477 | 186196 | 61540 | 105321 | 9169 | 1024679
TOTAL | 428157 | 170640 | 396177 | 525350 | 916686 | 412261 | 288816 | 37862 | 3175950
*OTHER variable includes the following products: FRA, Cap/Floor, Debt Option, Exotic, Fixed-Fixed, Inflation, OIS, Swaption, and Basis.
Spreadsheet: 718168d1613030749-index-match-multiple-criteria-greater-than-value-excelforum-index-match-greater-than_gt
Sheet: Sheet1

Dynamic Data |  |  |  |  | Static Data
Bank | CET1 |  |  |  | Bank | CET1 | Tier
GS | 5 |  |  |  | GS | 1 | Unsatisfactory
GS | 27 |  |  |  | GS | 50 | Satisfactory
GS | 49 |  |  |  | GS | 75 | Compliant
GS | 170 |  |  |  | GS | 125 | Buffered
BNPP | 20 |  |  |  | BNPP | 1 | Unsatisfactory
BNPP | 30 |  |  |  | BNPP | 25 | Satisfactory
BNPP | 50 |  |  |  | BNPP | 50 | Compliant
BNPP | 120 |  |  |  | BNPP | 100 | Buffered
Spreadsheet: 866399d1713321368-multiple-checks-across-text-values-for-condition-to-be-returned-4-possible-outcomes-caculation-assistance
Sheet: Sheet1

Calculated values from previous data entry across 5 areas |  |  |  |  | Evaluation of values '= IF (****<0, "Improved", IF(X2>0, "Deteriorated",  "Unchanged")) |  |  |  |  | Need help to determine this column formula
-1 | 0 | 0 | 1 | 1 | Improved | Unchanged | Unchanged | Deteriorated | Deteriorated | MIXED
2 | 2 | 1 | 1 | 2 | Deteriorated | Deteriorated | Deteriorated | Deteriorated | Deteriorated | Deteriorated
0 | 0 | -1 | 0 | -1 | Unchanged | Unchanged | Improved | Unchanged | Improved | MIXED
-1 | -1 | -2 | -1 | 0 | Improved | Improved | Improved | Improved | Unchanged | MIXED
-1 | 1 | 4 | -1 | 0 | Improved | Deteriorated | Deteriorated | Improved | Unchanged | MIXED
-1 | 0 | 4 | 0 | 0 | Improved | Unchanged | Deteriorated | Unchanged | Unchanged | MIXED
 | Multiple checks across text values for condition to be returned - 4 possible outcomes
 | I have a data set looking at outcomes and need to apply a formula to review text based evaluation (where there is a possible of 3 different values - improved, deteriorated, unchanged) across an individual row (5 columns) for the following conditions:
 | If there is at least one "improved", AND no "deteriorated"; return value of "better"
 | If there is at least one "deteriorated", AND no "improved"; return value of "worse"
 | If there is at least one "improved" AND one "deteriorated"; return value of "mixed"
 | If ALL values are "unchanged"; return value of "unchanged"
Spreadsheet: 167031d1341872086-matching-date-to-values-excel-help1
Sheet: Sheet1

Vlookup Example
Date | Canadian Spot | CAD:USD | USD:CAD | USD Spot | Exchange Spread |  | Canadian Spot Statistics |  | Date
2012-01-01 00:00:00 | 1.51 | 1.5144 | 0.6603 | 80.31 |  |  | High
2012-01-02 00:00:00 | 1.52 | 1.5199 | 0.6579 | 79.63 |  |  | Low
2012-01-03 00:00:00 | 1.52 | 1.522 | 0.657 | 80.1 |  |  | Average
2012-01-04 00:00:00 | 1.53 | 1.5302 | 0.6535 | 80.95 |  |  | Median
2012-01-05 00:00:00 | 1.54 | 1.5366 | 0.6508 | 81.25 |  |  | Range
2012-01-06 00:00:00 | 1.53 | 1.5348 | 0.6516 | 80.96
2012-01-07 00:00:00 | 1.54 | 1.5391 | 0.6497 | 80.9
2012-01-08 00:00:00 | 1.54 | 1.5441 | 0.6476 | 81.3
2012-01-09 00:00:00 | 1.54 | 1.5385 | 0.65 | 80.78
2012-01-10 00:00:00 | 1.56 | 1.556 | 0.6427 | 81.45
2012-01-11 00:00:00 | 1.58 | 1.5785 | 0.6335 | 81.44
2012-01-12 00:00:00 | 1.58 | 1.576 | 0.6345 | 81.09
2012-01-13 00:00:00 | 1.57 | 1.5726 | 0.6359 | 80.52
2012-01-14 00:00:00 | 1.59 | 1.5865 | 0.6303 | 80.05
Spreadsheet: frank_ermis__11031__CheyennHub
Sheet: CheyenneHub

COUNTERPARTY | Trade Date | Flow Date | Location | Daily QTY | TOTAL QTY | Fixed Price |  | VOLUME | Price | Total $
Reliant Energy Services, Inc. | 04/24/2001 09:41AM | 2001-05-01 00:00:00 | CHEYENNE HUB | 5000 |  | 4.1
Reliant Energy Services, Inc. | 04/24/2001 09:57AM | 2001-05-01 00:00:00 | CHEYENNE HUB | 5000 |  | 4.09
Reliant Energy Services, Inc. | 04/24/2001 10:00AM | 2001-05-01 00:00:00 | CHEYENNE HUB | 5000 |  | 4.07
Reliant Energy Services, Inc. | 04/24/2001 10:37AM | 2001-05-01 00:00:00 | CHEYENNE HUB | 5000 |  | 4.04
HS Energy Services, Inc. | 04/24/2001 11:06AM | 2001-05-01 00:00:00 | CHEYENNE HUB | 5000 |  | 4.075
HS Energy Services, Inc. | 04/24/2001 11:57AM | 2001-05-01 00:00:00 | CHEYENNE HUB | 5000 |  | 4.02
HS Energy Services, Inc. | 04/24/2001 12:08PM | 2001-05-01 00:00:00 | CHEYENNE HUB | 5000 |  | 4.03
Reliant Energy Services, Inc. | 04/24/2001 12:19PM | 2001-05-01 00:00:00 | CHEYENNE HUB | 5000 |  | 4.02
Reliant Energy Services, Inc. | 04/24/2001 01:41PM | 2001-05-01 00:00:00 | CHEYENNE HUB | 5000 |  | 4.01
Barrett Resources Corporation | 04/24/2001 02:07PM | 2001-05-01 00:00:00 | CHEYENNE HUB | 5000 |  | 4.05
ONEOK Energy Marketing and Trading Company, L.P. | 04/25/2001 09:13AM | 2001-05-01 00:00:00 | CHEYENNE HUB | 5000 |  | 3.995
HS Energy Services, Inc. | 04/25/2001 09:56AM | 2001-05-01 00:00:00 | CHEYENNE HUB | 5000 |  | 3.995
e prime, inc. | 04/25/2001 12:42PM | 2001-05-01 00:00:00 | CHEYENNE HUB | 5000 |  | 3.995
Aquila Energy Marketing Corporation | 04/25/2001 02:12PM | 2001-05-01 00:00:00 | CHEYENNE HUB | 5000 |  | 3.995
Aquila Energy Marketing Corporation | 04/26/2001 08:18AM | 2001-05-01 00:00:00 | CHEYENNE HUB | 5000 |  | 4.04
HS Energy Services, Inc. | 04/26/2001 09:38AM | 2001-05-01 00:00:00 | CHEYENNE HUB | 5000 |  | 4.01
Aquila Energy Marketing Corporation | 04/26/2001 11:12AM | 2001-05-01 00:00:00 | CHEYENNE HUB | 5000 |  | 4.06
El Paso Merchant Energy, L.P. | 04/26/2001 11:31AM | 2001-05-01 00:00:00 | CHEYENNE HUB | 2500 |  | 4.1
WACOG
Spreadsheet: 216c1ba5-109b-4bbf-bdf4-99cf20fa0054
Sheet: Sheet1

[NAME] | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
TEAM ROSTER
(NUMERICAL ORDER)
PLAYERS NAME | NUMBER | HEIGHT | POSITION | CLASS
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
HEAD COACH: _______________________ |  |  | MASCOT: ______________________
ASSISTANT COACH:__________________ |  |  | SCHOOL COLORS: _____________
ASSISTANT COACH:__________________ |  |  | LAST YEARS' RECORD: _________
MANAGERS: _________________________
_____________________________________