tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: mike_grigsby__27935__HS_WESTminusPA1025
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WEST NATURAL GAS BASIS POSITIONS
 | 2001-10-24 00:00:00
 | West Region Basis Notional
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Intra-Month | Change | Prompt Month | Change | Winter 2001-02 | Change | Summer 2002 | Change | Winter 2002-03 | Change | Remainder | Change | Total | Change
 | TIME BUCKET/KEY: |  |  |  | REPORT REGION |  |  |  |  |  |  |  |  | RISK TYPE |  | 1
 | West Region Basis Notional
 | NGI-PGE/CG |  |  |  | NGI-PGE/CG |  | GDP-PG&E/CITIGA | NGI-PGE/CG | GDP-PG&E/LG-PKG |  |  |  | M | D
 | NGI-MALIN |  |  |  | NGI-MALIN |  | GDP-MALIN-CTYGA | NGI-MALIN |  |  |  |  | M | D
 | NGI-SOCAL |  |  |  | NGI-SOCAL | IF-SOCAL | GDP-CAL BORDER | NGI-SOCAL |  |  |  |  | M | D
 | TOPOCK |  |  |  | NGI-SOBDR-PG&E |  | NGI-SOBDR-PG&E |  |  |  |  |  | M | D
 | NWPL-ROCKIES |  |  | NW-STANFIELD | IF-NWPL_ROCKY_M | IF-QUESTAR | GDP-WYOMING | GDP-KERN/OPAL | GDP-NW STANFIEL | IF-NWPL_ROCKY_M | IF-QUESTAR | GDP-NWPL_ROCKYM | M | D
 | CIG-ROCKIES | IF-CIG/WINDRVR | IF-CIG/WIC | IF-CIG/RKYMTN | IF-CIG/SOUTHERN | IF-CIG/GLENROCK | IF-CIG/ROCKPORT | GDP-CIG/RKYMTN | GDP-CIG/CHEYENN | IM-CIG/SOUTHERN | IM_WINDRIVER |  | M | D
 | PERMIAN |  | IF-TW/PERMIAN |  | IF-ELPO/PERMIAN | IF-NNG/TOK | GDP-ELPO/PERM2 | IF-ELPO/PERMIAN | IF-TW/PERMIAN |  |  |  | M | D
 | SAN JUAN |  | IF-BONDAD(100%) | IF-ELPO/SJ | IF-EPSJ(BONDAD) |  | GDP-ELPO/SANJUA |  | IM-TW/SJ | IF-EPSJ(BONDAD) |  |  | M | D
 | KINGSGATE |  |  |  | CGPR-KINGSGATE |  | CGPR-KINGSGATE |  |  |  |  |  | M | D
 | WAHA |  |  |  | IF-WAHA-TX | IF-WAHA | WAHA KCBT | GDP-WAHA |  |  |  |  | M | D
 | Other |  |  |  |  |  |  |  |  |  |  |  | M | D
 | TOTAL
 | Western Canada Region Notional
 | SUMAS |  |  |  | IF-NTHWST/CANBR |  | SUMAS-US/IM | GDP-NTHWST/CANB | IF-NTHWST/CANBR |  |  |  | m | D
 | AECO/EMPRESS/STA2 |  |  |  | CGPR-AECO/BASIS |  | GD-CGPR-AECO/AV | GD-AECOCD/FRWKD | GD-AECOUS/FRWKD | [NAME] | GDP-AECO |  | m | D
 | Other |  |  |  |  |  |  |  |  |  |  |  | M | D
 | TOTAL |  |  |  |  |  |  |  |  |  |  |  |  | p
 | West Summary |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Intra-Month | Change | Prompt Month | Change | Winter 2001-02 | Change | Summer 2002 | Change | Winter 2002-03 | Change | Remainder | Change | Total | Change
 | TIME BUCKET/KEY: |  |  |  | REPORT REGION |  |  |  |  |  |  |  |  | RISK TYPE |  | 1 |  | 2 |  | 3 |  | 4 |  | 5 |  | 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2001-10-01 00:00:00 |  | 2001-11-01 00:00:00 |  | Dec-01/Mar-02 |  | Apr-02/Oct-02 |  | Nov-02/Mar-03 |  | Apr-03/Mar-29
 | CALIFORNIA
 | Socal
 | PG&E CTYG & TOPOCK
 | Malin
 | NorthWest
 | Sumas
 | Aeco & Kingsgate
 | Rockies (NW & CIG)
 | SouthWest
 | San Juan
 | Permian
 | Waha
Spreadsheet: 2c2f2e2d-9b3c-4d42-bd91-f7d63658d82e
Sheet: Sheet1

Permit No.: | Unnamed: 1 | Unnamed: 2 | WQ0004122 | Unnamed: 4 | Unnamed: 5 | Facility Name: | Unnamed: 7 | [NAME] | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | County: | Chatham | Unnamed: 16 | Month: | Unnamed: 18 | Unnamed: 19 | Year: | Unnamed: 21
Did irrigation occur    at this facility? |  |  |  |  |  | Field Name: |  | 1 |  | Field Name: |  | 2 |  | Field Name: |  | 3 |  | Field Name: |  | 4
 |  |  |  |  |  | Area (acres): |  | 4.3 |  | Area (acres): |  | 4.3 |  | Area (acres): |  | 4.3 |  | Area (acres): |  | 4.3
 |  |  |  |  |  | Cover Crop: |  | Trees |  | Cover Crop: |  | Trees |  | Cover Crop: |  | Trees |  | Cover Crop: |  | Trees
 |  |  |  |  |  | [NAME] (in): |  | 0.12 |  | [NAME] (in): |  | 0.12 |  | [NAME] (in): |  | 0.12 |  | [NAME] (in): |  | 0.12
 |  |  |  |  |  | Annual Rate (in): |  | 26 |  | Annual Rate (in): |  | 26 |  | Annual Rate (in): |  | 26 |  | Annual Rate (in): |  | 26
Day | Weather |  |  | Freeboard |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated?
 | Weather Code | Temperature | Precipitation | Storage | 5-Day Upset (if applicable) | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time    Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading
 |  | ºF | in | ft | ft | gal | min | in | in | gal | min | in | in | gal | min | in | in | gal | min | in | in
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
Monthly Loading:
12 Month Floating Total (in):
Spreadsheet: vkaminski__40933__raptor4b
Sheet: Amort

[NAME] to Talon Amortization Table
 | Inputs
Principle | 50000000
Annual Interest Rate | 0.07
Term (in months)
Payments Per Year | 2
Payment | 0
 | Period | Beginning Balance | Payment | Principle | Interest | Ending Balance | Cum. Interest
 | 0 |  | 0 |  | 0
 |  |  |  | Period
Principle Received | 0 |  |  | Date
Interest Received |  |  |  | Next Interest
Total Cash Received |  |  |  | Next Date
Time Outstanding
Interest Receivable:
Interest Income
[NAME] to Harrier Interest Calculation
 | Inputs
Principle | 400000000
Annual Interest Rate | 0.07
Payments Per Year | 2
 | Period | Beginning Balance | Increase (+) Decrease (-) | Principle | Interest | Ending Balance | Cum. Interest
2000-08-31 00:00:00 | 0 |  | 0 | 0 | 0
 |  |  |  | 0
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  |  | Period
 |  |  |  | Date
Interest to Note |  |  |  | Next Interest
Total |  |  |  | Next Date
Time Outstanding
Interest Payable:
Interest Expense
Notes:
 | increase to loan is settlement of Put option
 | addl. interest on Settlement
Spreadsheet: 120334d1315217580-vlookup-to-lookup-an-un-named-column-tfl-prices
Sheet: Sheet3

1 | 1 | Oyster Peak Single
2 | 2 | Oyster Off-Peak Single
3 | 3 | Oyster Peak Price [NAME]
4 | 4 | Oyster Off-Peak Price [NAME]
5 | 5 | Travel Card Day Anytime
6 | 6 | Travel Card Day Off-Peak
7 | 7 | Travel Card 7 Days
8 | 8 | Travel [NAME]
9 | 9 | Travel Card Annual
 | 9 Inc Watford
 | 9 Inc Greys
 | Watford
Spreadsheet: 811379d1672454515-need-formula-to-calculate-average-state-total-fuel-expense-and-price-per-gallon-average-sample1
Sheet: Sheet1

Type | Amount | State | PPG |  | Arizona Amount Average
Diesel | 170.54 | AZ | 5.12 |  | Diesel | Insert formula here
DEF | 25.32 | AZ | 3.99 |  | DEF | Insert formula here
DEF | 32.54 | CA | 3.99
DEF | 41.21 | CA | 3.99 |  | California Amount Average
Diesel | 109.56 | CA | 5.08 |  | Diesel | Insert formula here
DEF | 19.09 | AZ | 3.97 |  | DEF | Insert formula here
Diesel | 220.89 | AZ | 5.11
Diesel | 210.27 | AZ | 5.15 |  | Average PPG
DEF | 25.75 | AZ | 3.95 |  | Diesel | Insert formula here
Diesel | 178.12 | AZ | 5.01 |  | DEF | Insert formula here
Diesel | 164.02 | CA | 5.64
Diesel | 225.09 | AZ | 5.12
Diesel | 179.01 | CA | 5.15
Diesel | 190.09 | AZ | 5.1
DEF | 29.01 | AZ | 5.01
Diesel | 371.01 | CA | 5.5
DEF | 39.04 | CA | 5.49
Spreadsheet: vkaminski__40923__Nordic_VAR_Module
Sheet: Positions

All instruments
ForwardDate | Finland:Day:Position | Finland:Night:Position | Smestad:Day:Position | Smestad:Night:Position | Strinda:Day:Position | Strinda:Night:Position | Sweden:Day:Position | Sweden:Night:Position | System:Day:Position | System:Night:Position | Tromso:Day:Position | Tromso:Night:Position
Spreadsheet: 148905d1333611249-formulas-no-longer-working-with-date-format-excel-example_change-in-date-format
Sheet: Change Tracker

Change Number | Date Entered | Date Completed | [NAME] | Status | Change Type | Infrastructure Affected | Change Summary | Times rejected | Time Taken to Complete Change | Week Change Entered | Week Change Implemented
87470
87606
87688
87742
88374
88518
88530
88757
88847
90148
90233
89240
88505
88509
91505
89445
92745
88689
94540
90060
90063
90068
93847
92487
91236
94129
94133
94129
94254
94341
94347
94113
92491
94762
955238
95569 |  |  |  | Completed
95117
95431
95428
95429
95985
95658
95434
95572
95433
95573
97444
97461
97462
97463
97767
97833
97816
97905
98408
98591
98700
98747
98707
99056
99059
99319
99320
99323
100029
100031
97845
100279
100452
100765
101033
101110
101114
101116
101673
101872
101536
102073
103382
103086
104725
105148
105152
105154
105156
104792
104980
104983
106365
106369
106631
Spreadsheet: michelle_lokay__26621__imbalsumm0102
Sheet: EOG

 | 500249 |  | 500260 |  | 500646 |  | 500598
 | Pronghorn |  | Pitchfork Ranch |  | Tristi Draw
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | 33193 | 30049 | 10503 | 10000 | 23795 | 25000
2 | 33037 | 33666 | 10371 | 10000 | 24097 | 25000
3 | 32947 | 33000 | 10032 | 10000 | 24103 | 24718
4 | 32790 | 33000 | 10136 | 10000 | 23821 | 24718 | 212
5 | 32630 | 33000 | 10383 | 10000 | 24847 | 24718
6 | 32514 | 33000 | 10151 | 10000 | 24836 | 25666
7 | 32414 | 33000 | 8698 | 10000 | 24612 | 25666
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-01-31 00:00:00 |  |  |  |  |  |  |  |  | -341460
2001-02-07 00:00:00
 |  |  | 516.78
 |  |  | 212.08
 |  |  | 58.33
 |  |  | 25
Spreadsheet: 126645d1319805811-pivot-table-has-2-fridays-instead-of-1-comprehensive-data-analysis
Sheet: ANALYSIS

 |  | Analysis of Historical Web SelSum
 |  | Data from:  September 1, 2011 - October 17,2011
Averages
 | Rank | 1 | 2 | 3 | 4 | 5 | 6 | 7
 | Gross Web Sessions | Tuesdays | Wednesdays | Mondays | Thursdays | Fridays | Saturdays | Sundays | Overall Average
 |  | 161528.6 | 158337.8333333333 | 152682.1666666667 | 151495.7142857143 | 132917.1428571429 | 100897.7142857143 | 97724.14285714286 | 134555.6888888889
Averages
 | Rank | 1 | 2 | 3 | 4 | 5 | 6 | 7
 | Unique Web Sessions | Tuesdays | Wednesdays | Mondays | Thursdays | Fridays | Saturdays | Sundays | Overall Average
 |  | 154933 | 152036.8333333333 | 146289.3333333333 | 145247 | 127288.8571428571 | 96074.57142857143 | 93023.85714285714 | 128801.3777777778
Averages
 | Rank | 1 | 2 | 3 | 4 | 5 | 6 | 7
 | Total Connects - Eligible States | Fridays | Mondays | Saturdays | Sundays | Thursdays | Tuesdays | Wednesdays | Overall Average
 |  | 81174.14285714286 | 95976 | 59086.71428571428 | 56654.42857142857 | 94856 | 101944.6 | 99546.66666666667 | 82783.51111111112
Maximums
 | Rank | 1 | 2 | 3 | 4 | 5 | 6 | 7
 | Gross Web Sessions | Tuesday | Monday | Wednesday | Thursday | Friday | Saturday | Sunday | Overall Maximum
 |  | 164240 | 163460 | 162667 | 155613 | 138149 | 105148 | 101775 | 164240
Maximums
 | Rank | 1 | 2 | 3 | 4 | 5 | 6 | 7
 | Unique Web Sessions | Tuesday | Monday | Wednesday | Thursday | Friday | Saturday | Sunday | Overall Maximum
 |  | 157562 | 156829 | 156289 | 149534 | 132952 | 100130 | 96799 | 157562
Maximums
 | Rank | 1 | 2 | 3 | 4 | 5 | 6 | 7
 | Total Connects - Eligible States | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Overall Maximum
 |  | 103764 | 103668 | 103044 | 97417 | 83883 | 62599 | 59398 | 103764
Minimums
 | Rank | 1 | 2 | 3 | 4 | 5 | 6 | 7
 | Gross Web Sessions | Tuesday | Wednesday | Thursday | Friday | Monday | Saturday | Sunday | Overall Minimum
 |  | 157429 | 149838 | 145441 | 128963 | 112560 | 95876 | 88175 | 88175
Minimums
 | Rank | 1 | 2 | 3 | 4 | 5 | 6 | 7
 | Unique Web Sessions | Tuesday | Wednesday | Thursday | Friday | Monday | Saturday | Sunday | Overall Minimum
 |  | 151023 | 143510 | 139566 | 123264 | 107572 | 91044 | 84035 | 84035
Minimums
 | Rank | 1 | 2 | 3 | 4 | 5 | 6 | 7
 | Total Connects - Eligible States | Tuesday | Wednesday | Thursday | Friday | Monday | Saturday | Sunday | Overall Minimum
 |  | 100087 | 94057 | 91953 | 79087 | 67969 | 55745 | 50476 | 50476
Summary |  | Overall Average | Overall Maximum | Overall Minimum
 | Gross Web Sessions
 | Unique Web Sessions
 | Total Connects - Eligible States
Spreadsheet: 166015d1341427952-values-dependent-upon-drop-down-list-nutrition
Sheet: Recipes

recipes | ingredients | calories | total fat (g) | total carb (g) | protein (g) | sodium (mg) | sugars (g) | servings
breakfast shake |  |  |  |  |  |  |  | 1
egg sandwich |  |  |  |  |  |  |  | 1
pancakes |  |  |  |  |  |  |  | 1 of 4
french toast |  |  |  |  |  |  |  | 1
omelet |  |  |  |  |  |  |  | 1
potato hash |  |  |  |  |  |  |  | 1
chicken breast sandwich with honey mustard |  |  |  |  |  |  |  | 1
meatloaf sandwich with honey mustard |  |  |  |  |  |  |  | 1
chicken breast sandwich with mayo |  |  |  |  |  |  |  | 1
meatloaf sandwich with mayo |  |  |  |  |  |  |  | 1
[NAME] |  |  |  |  |  |  |  | 1
tuna sandwich |  |  |  |  |  |  |  | 1
green bean casserole |  |  |  |  |  |  |  | 6
broccoli casserole |  |  |  |  |  |  |  | 6
sweet potatoes (candied yams)
western vegetable salad |  |  |  |  |  |  |  | 1
eastern vegetable salad |  |  |  |  |  |  |  | 1
tuna casserole |  |  |  |  |  |  |  | 1
meatloaf |  |  |  |  |  |  |  | 9 slices
stuffed peppers |  |  |  |  |  |  |  | 4
protein shake |  |  |  |  |  |  |  | 1 pitcher
Spreadsheet: 52767bad-bd2c-445f-9e9a-d499f11708b2
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
SSPC | Test | SSPC | Sporothrix Antibody, Spinal Fluid | [NAME], CSF | Latex Agglutination | [NAME], round-bottom, plastic vial: ScwRBPl |  |  | 0.5 | mL | Container/Tube: Sterile vial [NAME]: 0.5 mL | 0.2 mL | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Negative | Monday, Wednesday, Friday; 9 a.m. | Same day/1day | 4 days | 1 | 86671 |  |  |  |  | Rochester
SSPC | [NAME] | CSF | CSF |  |  |  | Refrigerated | 14 days
SSPC | Result | 81532 | [NAME], CSF | [NAME], CSF | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 49860-0 | Sporothrix schenckii [NAME]:ACnc:Pt:CSF:[NAME]:LA
Spreadsheet: 43317d1241957581-analysing-survel-data-mode-or-count-survey-analysis
Sheet: Merge

1
2 | 432 |  |  |  |  |  |  | 5342
23 | 5 | 3 |  |  |  |  |  |  | 4 | 432
324 |  |  | 5 | 3 |  |  | 4325 | 45 |  | 4
32 |  |  | 5 | 4 |  | 34 |  |  |  |  | 243
4 |  |  | 34 |  |  | 4 |  | 452 |  |  | 4
543 |  |  |  | 32 | 4 |  |  |  | 52
5324
1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
5 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4
6 | 436 | 4 | 4 | 4 | 4 | 4 | 4 | 5346 | 4 | 4 | 4
27 | 9 | 7 | 4 | 4 | 4 | 4 | 4 | 4 | 8 | 440 | 8
332 | 8 | 8 | 13 | 11 | 8 | 8 | 4333 | 53 | 8 | 12 | 8
40 | 8 | 8 | 13 | 12 | 8 | 42 | 8 | 8 | 8 | 8 | 251
12 | 8 | 8 | 42 | 8 | 8 | 12 | 8 | 460 | 8 | 8 | 12
551 | 8 | 8 | 8 | 40 | 12 | 8 | 8 | 8 | 60 | 8 | 8
5332 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8
9 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8
9 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8
10 | 440 | 8 | 8 | 8 | 8 | 8 | 8 | 5350 | 8 | 8 | 8
31 | 13 | 11 | 8 | 8 | 8 | 8 | 8 | 8 | 12 | 440 | 8
332 | 8 | 8 | 13 | 11 | 8 | 8 | 4333 | 53 | 8 | 12 | 8
40 | 8 | 8 | 13 | 12 | 8 | 42 | 8 | 8 | 8 | 8 | 251
12 | 8 | 8 | 42 | 8 | 8 | 12 | 8 | 460 | 8 | 8 | 12
551 | 8 | 8 | 8 | 40 | 12 | 8 | 8 | 8 | 60 | 8 | 8
5332 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8
9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9
25 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16 | 16
36 | 190096 | 16 | 16 | 16 | 16 | 16 | 16 | 28579716 | 16 | 16 | 16
729 | 81 | 49 | 16 | 16 | 16 | 16 | 16 | 16 | 64 | 193600 | 64
110224 | 64 | 64 | 169 | 121 | 64 | 64 | 18774889 | 2809 | 64 | 144 | 64
1600 | 64 | 64 | 169 | 144 | 64 | 1764 | 64 | 64 | 64 | 64 | 63001
144 | 64 | 64 | 1764 | 64 | 64 | 144 | 64 | 211600 | 64 | 64 | 144
303601 | 64 | 64 | 64 | 1600 | 144 | 64 | 64 | 64 | 3600 | 64 | 64
28430224 | 64 | 64 | 64 | 64 | 64 | 64 | 64 | 64 | 64 | 64 | 64
81 | 64 | 64 | 64 | 64 | 64 | 64 | 64 | 64 | 64 | 64 | 64
81 | 64 | 64 | 64 | 64 | 64 | 64 | 64 | 64 | 64 | 64 | 64
100 | 193600 | 64 | 64 | 64 | 64 | 64 | 64 | 28622500 | 64 | 64 | 64
961 | 169 | 121 | 64 | 64 | 64 | 64 | 64 | 64 | 144 | 193600 | 64
110224 | 64 | 64 | 169 | 121 | 64 | 64 | 18774889 | 2809 | 64 | 144 | 64
1600 | 64 | 64 | 169 | 144 | 64 | 1764 | 64 | 64 | 64 | 64 | 63001
144 | 64 | 64 | 1764 | 64 | 64 | 144 | 64 | 211600 | 64 | 64 | 144
303601 | 64 | 64 | 64 | 1600 | 144 | 64 | 64 | 64 | 3600 | 64 | 64
28430224 | 64 | 64 | 64 | 64 | 64 | 64 | 64 | 64 | 64 | 64 | 64
81 | 81 | 81 | 81 | 81 | 81 | 81 | 81 | 81 | 81 | 81 | 81
Spreadsheet: darron_c_giron__7969__IMCENTMID2
Sheet: Sheet1

From: | Risk Management -Central Region
 |  |  |  |  |  |  |  |  |  |  |  | Department: | Risk Management
Subject: | New Book Request
 |  |  |  |  |  |  |  |  |  |  |  | Date:
 | COUNTERPARTY |  | BOOK PURPOSE |  |  | TAGG |  |  |  |  |  |  | IT SECURITY | Reporting -Subledger
 |  |  | Internal | External | Both | Book Mapping |  |  |  |  |  |  | Book
 | Short Name | [NAME] | Transactions | Transactions | Transactions | Code | Region | P | B | Idx | [NAME] | Commodity/UOM/Curr | Administrator* | MTM | Prud | Realized
 | IM-CENT-MID2 | IM-CENT-MID2 |  |  | x | P* | Central | x | x | x | x | NGI/MMBtu/us$ | See below
 | FIN-ECTI-ENERGY | Financial ECTI-Energy |  |  |  | I7 | EQUITIES | X | - | - | - | TN10/CNTR/USD
 | FIN-ECTI-PROP | Financial ECTI-Prop |  |  |  | I8 | EQUITIES | X | - | - | - | TN10/CNTR/USD
 | FIN-ECTI-ST | Financial ECTI-ST |  |  |  | I3 | EQUITIES | X | - | - | - | TN10/CNTR/USD
 | FINLAND-JV-.2GO | Finland JV GASOIL.2 |  |  |  | QM | DESK | X | - | - | - | TN10/CNTR/USD
 | UK-FO-LSSR | UK -Fuel Oil-LSSR |  |  |  | V# | DESK | X | - | - | - | TN10/CNTR/USD
 | (Note 1) Please ensure access to both production and stage to enter deals, calculate books and set the official flag
 | Please provide a list of the people who need access to the above book(s).
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | Brent Price
 | Access List:
 | Same as other Central books
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | Any questions, please contact me
 | (x39573)
Spreadsheet: ce673c47-e239-4987-9344-4c604b2badf9
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
CAI | Test | CAI | Calcium, Ionized, Serum | Calcium, Ionized, S | Ion-Selective Electrode (ISE) | Serum Gel Tube: SGT |  |  |  | Varies | Container/Tube: Serum gel or serum gel Microtainer [NAME]: Full tube Collection Instructions: 1. Allow blood to clot for 30 minutes. 2. Centrifuge with stopper in place for 10 minutes at 3,000 rpm to ensure that the gel barrier separates the serum and cells. 3. Keep specimen anaerobic (do not transfer). | 1.75 mL in a 3.5 mL serum [NAME] | Hemolysis	Mild OK; Gross reject Thawing	NA Lipemia	NA Icterus	NA Other	NA | Males 1-19 years: 5.1-5.9 mg/dL > or =20 years: 4.8-5.7 mg/dL Reference values have not been established for patients that are <12 months of age. Females 1-17 years: 5.1-5.9 mg/dL > or =18 years: 4.8-5.7 mg/dL Reference values have not been established for patients that are <12 months of age.   Pediatric ranges derived for GEM method from analytic comparison to reference method in: Snell J, [NAME], Colaco A, et al: Pediatric reference ranges for arterial pH, whole blood electrolytes and glucose. Clin Chem 1993;39:1173. | Monday through Sunday; Continuously | Same day/1 day | 1 day | 1 | 82330 |  |  |  |  | Rochester
CAI | [NAME] | SST | Serum SST |  |  |  | Refrigerated | 5 days
CAI | Result | CAIS | Calcium, Ionized, S | Calcium, Ionized, S | Numeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | 17863-2
CAI | Result | PHCC | pH | pH | Numeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2753-2
Spreadsheet: 809291d1671010556-find-and-show-the-last-value-from-a-row-examplefile
Sheet: Sheet1

test | testheader 2 | [NAME] testeheader 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Here find last info
Info1 | Info2 | [NAME] | [NAME]
Info1 | Info2 | [NAME] | [NAME] | Info 5 | Info 6 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Info1 | Info2 | [NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Info1 | Info2 | [NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Info1 | Info2 | [NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Info1 | Info2 | [NAME] | [NAME] | Info 5 | Info 6 | [NAME] | [NAME] 8 | [NAME] 9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] 9
Info1 | Info2 | [NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Info1 | Info2 | [NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Info1 | Info2 | [NAME] | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Info1 | Info2 | [NAME] | [NAME] | Info 5 | Info 6 | [NAME] | [NAME] 8 | [NAME] 9 | [NAME] 10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] 10
Spreadsheet: 152977d1335655952-excel-2007-conditional-formatting-with-2-variables-rick52
Sheet: Sheet1

0.1917 | 0.1636 |  |  |  | bio | a > 21 < 22 |  | b > 15 < 16 |  | c < 1 | d < 1
a | b |  |  |  | coa | a > 21 < 22 |  | b > 15 < 16 |  | c < 2 | d < 30
0.0532 | 0.0511 |  |  |  | dyn | a  > 18.5 < 19.5 |  | b > 20 < 21 |  | C < 2 | d < 2
c | d |  |  |  | nex | a > 19 < 20 |  | b > 15 < 18 |  | C < 1 | d < 5
A2 Text populated from drop down based in F3:F6
A3 & B3 manually populated
A5 & B5 manually populated
[NAME] (Green or Red) based on A3, B4 based on B3  etc.
The problem comes in with overlapping or differing values depending on product (from drop down) being produced.
How can the drop down or something else be used to select the values that trigger the format?
bio
coa
dyn
nex
Spreadsheet: 693849d1599184455-formula-to-copy-a-cell-in-an-array-with-data-and-ignore-cells-with-n-a-lookupx
Sheet: Sheet1

 |  |  |  |  |  |  |  | lookup value | Lookup list
 |  | List to seach |  |  |  |  |  | 16-X | 16X
 |  | 16x |  |  |  |  |  | 16-X | 16 X
 |  | 16-x |  |  |  |  |  | 16-X | X16
 |  |  |  |  |  |  |  | 16-X | X 16
 |  | X-16 |  |  |  |  |  | 16-X | 16-X
 |  |  |  |  |  |  |  | 16-X | X-16
 |  | Lookup2 - Find value |  |  |  |  |  | 16-X | 16/X
 |  | Lookup list | Vlookup
 |  | 16-X
Spreadsheet: 762510d1641584777-lookup-multiple-criteria-multiple-results-excel-q
Sheet: dot3

Location | Trainee First Name | Trainee Last Name | Position | Needs to Attend:               Day 1 and 2    (Y/N) | Needs to Attend:               DOT- Day 3          (Y/N) | [NAME] | [NAME]
Spreadsheet: bb246829-84c5-4345-80b0-a1e1b3b7f75a
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
PENSIÓN NO CONTRIBUTIVA DE JUBILACIÓN
Beneficiarios e importes de las nóminas
MELILLA
Mes/Año | Pensiones (1) | Importes (€) | Pensión media (€)
2006 | 1244 | 5087440.67 | 292.86
2007 | 1271 | 5483563.95 | 304.65
2008 | 1289 | 5752052.749999999 | 321.15
2009 | 1313 | 6012608.779999999 | 328.982840084555
2010 | 1318 | 6216890.540000001 | 331.37
2011 | 1319 | 6412418.01 | 338.9
2012 | 1329 | 6517073.41 | 353.61
2013
Enero | 1328 | 478007.49 | 359.9453990963855
Febrero | 1333 | 479411.31 | 359.6483945986497
Marzo | 1319 | 470563.25 | 356.7575815011372
Abril | 1314 | 479052.1 | 364.5754185692542
Mayo | 1318 | 472943.62 | 358.8343095599393
[NAME] (2)
[NAME]
[NAME]
Septiembre
Octubre
Noviembre (2)
Diciembre
1) Pensiones en vigor [NAME] mes
2) Junto a la mensualidad se abona una paga extra
FUENTE: Subdirección General de Gestión del Imserso. Área de Prestaciones Económicas