tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: daren_farmer__5223__BMSPT051
Sheet: BMSPT066

BAMMEL STORAGE ACTIVITY
VOLUME SPLIT BY Counterparties
2001-05-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | SWING CONTRACT VOLUMES |  |  |  |  | ECT LONG/(SHORT) |  |  |  | LONG/(SHORT)
 |  | HPL INDEX |  |  | HPL FIXED PRICE |  |  |  |  | TOTAL | HL&P | CP&L | TUFCO | TOTAL |  | ECT FIRST OF THE MONTH | TUFCO/ HL&P/ CP&L SWING VOLUME | ECT LONG OR (SHORT) |  | ECT TOTAL | HPLC Excluding 3rd Party | Net LONG/ (SHORT)
 |  | MTD Adjustment | CURRENT DAY | Total | MTD Adjustment | CURRENT DAY | Total | 3rd Party | HPLC Total |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  | Reinject Fees
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Injected Volume | Value
Beginning Balance
1 | Scheduled |  |  |  |  |  |  |  |  |  | 0 | 0
 | Scheduled
 | Estimated
 | Estimated
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected
 | Projected |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Index: | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fuel: | 0.01
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Fuel Rate:
Ending Balance |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Prod.[NAME]:
Variances:
Total Projected
April 28 thru May 4
May 5 thru May 11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Previous Position: |  | 240210.677642663
May 12 thru May 18 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]:
May 19 thru May 25
Spreadsheet: 794880d1662378235-absence-trackershowing-extra-days-in-some-months-how-to-fix-employee-absence-tracker
Sheet: May Abs Data

 |  |  | PLEASE NOTE:  The start day is the first day of leave/sickness and the end date is the last day of leave/sickness and NOT the day that they retun to work
 | Employee Name | Start Date | End Date | Type of Leave | Reason for Sickness Absence | Other reasons for Leave Of Absence | Days | Self Cert Completed | Teaching / Non Teaching | Continued absence from previous month? | Has a Doctors Note been submitted? | Doctors Note Start | Doctors Note End | Is the [NAME] ongoing at the end of the month
 | Employee 1 | 2022-12-22 00:00:00 | 2022-12-30 00:00:00 | Sickness Absence | Heart (Pressure, Circulation etc)
 | Employee 1 | 2022-08-03 00:00:00 | 2022-08-05 00:00:00 | Sickness Absence | Mental Health (Stress / Anxiety etc)
 | Employee 1 | 2022-08-10 00:00:00 | 2022-08-12 00:00:00 | Sickness Absence | Back / Neck
 | Employee 1 | 2022-08-17 00:00:00 | 2022-08-19 00:00:00 | Dependant Care Paid
 | Employee 1 | 2022-08-24 00:00:00 | 2022-08-26 00:00:00 | Compassionate Paid
 | Employee 1 | 2022-12-22 00:00:00 | 2022-12-29 00:00:00 | Leave of Absence Paid |  | Fertility
 | Employee 1 | 2022-03-03 00:00:00 | 2022-03-10 00:00:00 | Leave of Absence Unpaid |  | Study Leave
 | Employee 1 | 2022-05-05 00:00:00 | 2022-05-15 00:00:00 | Dependant Care Unpaid
 | Employee 1
 | Employee 1
Spreadsheet: 33792d1230591770-array-sum-formula-problem-sample
Sheet: Sheet1

Summary | PERIOD
Code | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
a
b
c
d
e
f
g
Bulk data
Code | Period | Value |  | a/1
a | 6 | 1171 |  | 0
b | 2 | 1031 |  | 0
e | 7 | 1168 |  | 0
f | 11 | 1461 |  | 0
d | 1 | 1469 |  | 0
d | 11 | 508 |  | 0
c | 5 | 1135 |  | 0
e | 9 | 1479 |  | 0
a | 11 | 1481 |  | 0
e | 12 | 848 |  | 0
f | 11 | 530 |  | 0
d | 1 | 974 |  | 0
b | 1 | 1118 |  | 0
e | 12 | 1077 |  | 0
f | 12 | 1256 |  | 0
d | 9 | 904 |  | 0
d | 11 | 943 |  | 0
c | 4 | 880 |  | 0
e | 1 | 963 |  | 0
d | 8 | 537 |  | 0
d | 11 | 1153 |  | 0
d | 2 | 1108 |  | 0
a | 1 | 1072 |  | 1072
e | 8 | 726 |  | 0
d | 11 | 531 |  | 0
e | 5 | 1275 |  | 0
f | 2 | 1410 |  | 0
d | 4 | 1130 |  | 0
b | 1 | 1130 |  | 0
e | 9 | 1088 |  | 0
f | 4 | 584 |  | 0
d | 7 | 1260 |  | 0
b | 2 | 1050 |  | 0
e | 12 | 629 |  | 0
f | 12 | 1310 |  | 0
d | 6 | 1467 |  | 0
d | 3 | 717 |  | 0
c | 8 | 1275 |  | 0
e | 9 | 1417 |  | 0
d | 5 | 782 |  | 0
d | 8 | 681 |  | 0
d | 12 | 792 |  | 0
c | 5 | 1143 |  | 0
e | 5 | 1025 |  | 0
f | 3 | 1433 |  | 0
d | 9 | 986 |  | 0
d | 1 | 1092 |  | 0
c | 6 | 957 |  | 0
e | 9 | 1151 |  | 0
d | 4 | 997 |  | 0
e | 2 | 1498 |  | 0
f | 8 | 1485 |  | 0
d | 2 | 1031 |  | 0
b | 9 | 942 |  | 0
e | 1 | 608 |  | 0
f | 9 | 1474 |  | 0
d | 12 | 794 |  | 0
d | 8 | 1131 |  | 0
c | 8 | 737 |  | 0
e | 6 | 831 |  | 0
d | 5 | 1372 |  | 0
a | 1 | 1141 |  | 1141
d | 11 | 505 |  | 0
c | 7 | 1484 |  | 0
e | 7 | 920 |  | 0
d | 11 | 1266 |  | 0
e | 3 | 1275 |  | 0
f | 8 | 1399 |  | 0
d | 12 | 1391 |  | 0
b | 5 | 699 |  | 0
e | 11 | 917 |  | 0
f | 5 | 789 |  | 0
d | 1 | 1485 |  | 0
b | 3 | 627 |  | 0
e | 3 | 1035 |  | 0
f | 2 | 1131 |  | 0
d | 2 | 792 |  | 0
b | 4 | 1039 |  | 0
e | 6 | 1117 |  | 0
f | 10 | 953 |  | 0
d | 3 | 892 |  | 0
d | 3 | 1355 |  | 0
c | 8 | 629 |  | 0
e | 6 | 754 |  | 0
d | 12 | 1452 |  | 0
d | 9 | 1000 |  | 0
d | 3 | 991 |  | 0
c | 4 | 1370 |  | 0
e | 7 | 973 |  | 0
f | 11 | 955 |  | 0
Spreadsheet: 767557d1644516866-extracting-first-instance-from-index-match-function-book1
Sheet: Sheet1

0.2 | 1
0.5 | 2
0.8 | 3
1.67 | 4
0.5 | 5
1 | 6
0.9 | 7
1.69 | 8
1.3 | 9
1.7 | 10
2.8 | 11
1 | 12
0.5 | 13
Spreadsheet: 26996d1219761016-sumif-with-multiple-criteria-not-sure-what-functions-to-use-trend-graph1-rev2
Sheet: lookupbranchtable

AL | st albans
CB | peterborough
HA | st albans
hp | st albans
ip | peterborough
lu | st albans
n | st albans
nr | peterborough
nw | st albans
ox | sunbury
pe | peterborough
rg | sunbury
sg | st albans
sl | st albans
sw | sunbury
tw | sunbury
w | sunbury
wd | st albans
Spreadsheet: 837100d1689850671-indirect-a1-a5-and-a1-to-spill-a1-from-other-sheets-doesnt-work-how-could-i-do-it-example-132-aligw
Sheet: Sheet2

ANSW2 | 1 | 2 | 3 | 4 | 5 |  |  | 1 - This is Pricing 2
10
20 |  |  |  |  |  |  |  | 2 - This pricing is pasted from an erp to here in this format.
30
40 |  |  |  |  |  |  |  | 3 - Each year we paste a pricesheet to the excel file.
50
Spreadsheet: 86037d1286005804-using-a-date-format-in-a-cell-instead-of-a-text-format-to-support-a-formula-cash-deposits-and-orders-sample-3-
Sheet: 09-15-10

CASH ORDER
Denomination |  | 2010-09-15 00:00:00 | Area #1 | Area #2 | Area #3 | Area #4 | Area #5 | Area #6 | Total
100 |  | 1853300 |  | 1523500
20 |  | 3639320 |  | 819620
10 |  | 134670 | 15940 | 0
5 |  | 411590 |  | 194425
1 |  | 132782 |  | 62214
0.25 |  | 20681 | 11163 | 0
0.05 |  | 7340 | 1202 | 0
0.01 |  | 1201 | 429 | 0
Total
Spreadsheet: 877374d1724196515-sumifs-and-sumproduct-dynamic-range-book
Sheet: Result

 |  |  |  | Quantity |  |  | Cost |  |  | Revenue
 |  |  |  | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00
Task Order Number | Task Name | WBS Task Ref | Cost Centre
UK-70096062-100 | 40 HOV - Stage 4 | BM-90096062-100 - IND - Void 4 | BM121217-UK-BSV-Srv Perth
UK-70096062-200 | 40 HOV - Stage 5 | BM-90096062-200 - IND - Void 5 | BM121217-UK-BSV-Srv Perth
UK-70096062-300 | 40 HOV - Stage 6 | BM-90096062-300 - IND - Void 6 | UK010117-UK-BSV-Srv Perth
UK-70096062-MAN | 40 HOV - Management | BM-90096062-MAN - IND - Management | UK010117-UK-BSV-Srv Perth
UK-70096062-CON | 40 HOV - Contingency | BM-90096062-CON - IND - Contingency | UK010117-UK-BSV-Srv Perth
 |  |  |  |  |  |  | (employee 1 cost rate X employee 1 Hours)+(employee 2 cost rate X employee 2 Hours) and so on
 |  |  |  |  |  |  | https://www.excelforum.com/excel-general/1427562-sumifs-and-sumproduct-dynamic-range.html#post5975758
 |  |  |  |  |  |  | Qty:
 |  |  |  |  |  |  | [code]
 |  |  |  |  |  |  | =SUMPRODUCT((Lookup!$C$3:$C$500=$C4)*(Lookup!$A$3:$A$500=$D4)
 |  |  |  |  |  |  | *(Lookup!$F$1:$BC$1=E$3)*Lookup!$F$3:$BC$500)
 |  |  |  |  |  |  | [/code]
 |  |  |  |  |  |  | Cost, H4
 |  |  |  |  |  |  | [code]
 |  |  |  |  |  |  | =SUMPRODUCT((Lookup!$C$3:$C$500=$C4)*(Lookup!$A$3:$A$500=$D4)
 |  |  |  |  |  |  | *Lookup!$E$3:$E$500*(Lookup!$F$1:$BC$1=H$3)*Lookup!$F$3:$BC$500)
 |  |  |  |  |  |  | [/code]
 |  |  |  |  |  |  | Revenue, K4
 |  |  |  |  |  |  | [code]
 |  |  |  |  |  |  | [/code]
Spreadsheet: 271999d1382127219-how-to-determine-which-range-a-value-falls-within-and-output-a-value-from-the-same-row-sample
Sheet: Sheet1

min | [NAME] | Date |  | collection # | Date
33 | 56 | 2009-05-07 00:00:00 |  | 75
73 | 92 | 2009-06-04 00:00:00 |  | 35
108 | 121 | 2009-06-12 00:00:00 |  | 109
137 | 168 | 2009-09-08 00:00:00 |  | 120
 |  |  |  | 42
 |  |  |  | 138
 |  |  |  | 152
Spreadsheet: 848197d1698966582-let-unique-formula-only-display-results-based-on-text-in-column-unique-values-test-05
Sheet: Sheet1

DATE | SHIFT | PATRON | CR # | ISSUES | STATUS |  | NAME | NUMBER | TRANS | TOTAL
 |  | JOE | 123 | 10 | PAID |  |  | 123 | 4 | 120
 |  | JOE | 123 | 15 | OS |  | SUE | 456 | 2 | 90
 |  | SUE | 456 | 30 | OS |  | SUE | 888 | 2 | 20
 |  | MARK | 789 | 5 | PAID |  | MARK | 789 | 1 | 5
 |  | LISA | 12 | 20 | PAID |  | LISA | 12 | 1 | 20
 |  | SUE | 456 | 60 | OS
 |  | JOE | 123 | 80 | OS
 |  | JOE | 123 | 15 | PAID
 |  | SUE | 888 | 10 | PAID
 |  | SUE | 888 | 10 | PAID
Spreadsheet: 852628d1702596391-trying-to-set-up-a-formula-that-enables-a-leapfrog-points-system-for-a-sports-ladder-tennis-ladder
Sheet: Results

Match Date | Challenger | Sets | Sets | Opponent | Points for challenger | Points for opponent
 | [NAME] | 2 | 1 | Guy |  |  |  | Win points | 2 | HOW TO USE
 |  |  |  |  |  |  |  | Loss points | 0
 |  |  |  |  |  |  |  |  |  | 1. The challenger's name goes in the left collumn
 |  |  |  |  |  |  |  |  |  | 2. Enter the scores in sets (3rd set is a 10 point tie break) - i.e. 2:1
 |  |  |  |  |  |  |  |  |  | 3. Click the date box - it will automatically update
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | Clive
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | Guy
 |  |  |  |  |  |  |  | Ian
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | Julian
 |  |  |  |  |  |  |  | Martin
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | Nick
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  | Zak
Spreadsheet: kimberly_watson__20563__010720Al
Sheet: LetterSizeRegionLoc 

ETS Planned And Unplanned Outages - January 1, 2001 Through December, 2001
Albuquerque Region Only - Sorted By Region/Location
The information provided is tentative and may be changed without further notice.  Northern Natural Gas, [NAME] and Florida Gas Transmission are not responsible for any reliance on this information.
Data Extracted July 20, 2001 |  |  |  |  |  |  |  |  |  |  | Est. Flow | Est. Vol. |  |  | Act. | Act. | Act.
No. | ID# | Location | Units | Title | EstStart | EstComp | Duration | Line | Proj. Mgr | W.O. # | Affected | Affected | DescOfWork | DescOfWork2 | Start | Compl. | [NAME]. | P/U | Pub | Ver
 |  |  |  |  |  |  |  |  |  |  | (Mmcfd) | (Mmcf)
1 | 16194 | STATION 1 | 102 | SAFETY DEVICES | 2001-09-18 08:00:00 | 2001-09-20 16:00:00 | 2.3 |  | OPS |  | 50 | 116.7 | Safety devices. |  |  |  | 0 | P | N | N
2 | 16195 | STATION 1 | 101 | SAFETY DEVICES | 2001-09-25 08:00:00 | 2001-09-27 16:00:00 | 2.3 |  | OPS |  | 50 | 116.7 | Safety devices. |  |  |  | 0 | P | N | N
3 | 17090 | STATION 2 | MAINLINE | RED ROCK TIE-IN | 2001-10-22 08:00:00 | 2001-10-26 16:00:00 | 4.3 |  | OPS |  | 130 | 563.3 | New block and side valve assemblies for new compressor and scrubbers will be installed on the suction side main and loop lines at each station. The tie-in will entail isolating a line segment within the plant yard. |  |  |  | 0 | P | N | N
4 | 17091 | STATION 2 | LOOP LINE | RED ROCK TIE-IN | 2001-11-05 08:00:00 | 2001-11-07 16:00:00 | 2.3 |  | OPS |  | 130 | 303.3 | New block and side valve assemblies for new compressor and scrubbers will be installed on the sucton side main and loop lines at each station. The tie-in will entail isolating a line segment within the plant yard. |  |  |  | 0 | P | N | N
5 | 16521 | STATION 3 | 321 | OVERHAUL | 2001-11-05 08:00:00 | 2001-11-23 16:00:00 | 18.3 |  | OPS |  | 0 | 0 | Engine overhaul. |  |  |  | 0 | P | N | N
6 | 16900 | STATION 8 | MAINLINE | MAINLINE BLOCK | 2001-07-23 08:00:00 | 2001-08-03 16:00:00 | 11.3 |  | OPS |  | 0 | 0 | Remove 1 section of mainline from service for 4 days.  Block pipeline for 2 hours to use station compression to lower section pressure by transferring gas from mainline west of station to mainline east of station  then reestablish bypass conditions. |  |  |  | 0 | P | N | N
7 | 16752 | STATION 8 | 2 | AUTOMATION | 2001-09-04 08:00:00 | 2001-10-31 16:00:00 | 57.3 |  | OPS |  | 0 | 0 | Station 8 automation project. 8000 HP |  |  |  | 0 | P | N | N
8 | 17089 | STATION 9 | CHECK VALVE | REPLACE CHECK VALVE | 2001-07-20 09:00:00 | 2001-07-20 13:00:00 | 0.2 |  | OPS |  | 0 | 0 | They need to replace leaking check valve on the surge valve. |  |  |  | 0 | U | N | N
Spreadsheet: 180489d1347622445-trying-to-combine-multiple-rows-of-data-into-one-excel-forum-example-sheet
Sheet: Sheet1

Engine | Campaign | Ad Group | Keyword | [NAME] | Match Type | [NAME] | [NAME] | Impressions | Clicks | CTR | Conversions | Conversion Rate | Assists | Cost | Revenue | COA
Google-PE 3 | 510IndustrialWipes | [touch free hand sanitizer dispenser] | touch free hand sanitizer dispenser | Active | Exact | 1.45 | 1.953 | 993 | 26 | 0.0262 | 0 | 0 | 0 | 37.66 | 0
Google-PE 2 | 510IndustrialWipes | [touch free hand sanitizer dispenser] | touch free hand sanitizer dispenser | Active | Exact | 1.57 | 2.646 | 630 | 9 | 0.0143 | 0 | 0 | 0 | 14.11 | 0
 | 510IndustrialWipes | [touch free hand sanitizer dispenser] | touch free hand sanitizer dispenser
Google-PE 3 | 604RemediationEquipm | [tower fan with remote] | tower fan with remote | Active | Exact | 1.42 | 1.262 | 5855 | 7 | 0.0012 | 0 | 0 | 0 | 9.94 | 0
Google-PE 2 | 604RemediationEquipm | [tower fan with remote] | tower fan with remote | Active | Exact | 1.49 | 1.451 | 11207 | 28 | 0.0025 | 0 | 0 | 0 | 41.72 | 0
 | 604RemediationEquipm | [tower fan with remote] | tower fan with remote
Google-PE 3 | 65MoldTesting | [toxic mold inspection] | toxic mold inspection | Active | Exact | 1.97 | 5.298 | 114 | 1 | 0.0088 | 0 | 0 | 0 | 1.97 | 0
Google-PE 2 | 65MoldTesting | [toxic mold inspection] | toxic mold inspection | Active | Exact | 2.94 | 4.059 | 188 | 6 | 0.0319 | 0 | 0 | 0 | 17.63 | 0
 | 604RemediationEquipm | [tower fan with remote] | tower fan with remote
Google-PE 3 | 65MoldTesting | [toxic mold remediation] | toxic mold remediation | Active | Exact | 0 | 4.764 | 186 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Google-PE 2 | 65MoldTesting | [toxic mold remediation] | toxic mold remediation | Active | Exact | 3.26 | 2.86 | 214 | 5 | 0.0234 | 0 | 0 | 0 | 16.28 | 0
 | 604RemediationEquipm | [tower fan with remote] | tower fan with remote
Spreadsheet: kam_keiser__17989__booket info needed
Sheet: Sheet1

ENE
11/30 DPR & Supporting Documentation
 |  |  |  |  |  |  | Risk Lead
Section 1: | Summary ENE DPR 11/30 |  |  |  |  |  | Wilson
 |  | including:  Gross PRMA, A/R, A/P & Unbilled Services | Gross PRMA/L, A/R, A/P & Unbilled Services
 |  |  | (both with & without I/Co, when available)
Section 2 thru 8: | Summary 11/30 DPR for Each Wholesale Business Unit
 |  |  | ENA Gas |  |  |  | R Hall/Albrecht
 |  |  | ENA Power |  |  |  | R Hall/Albrecht
 |  |  | Canada |  |  |  | R Hall/Albrecht
 |  |  | EIM  (with ECTRIC split) |  |  |  | Sweeney
 |  |  | EGM (with ECTRIC split) |  |  |  | Sweeney
 |  |  | EBS |  |  |  | Miralles
 |  |  | EES |  |  |  | Mills
 |  |  | Europe (ECTRIC) |  |  |  | Horn
 |  | including: | Rolls supporting the DPR information
 |  |  | Gross PRMA, A/R, A/P & Unbilled Services
 |  |  | (both with & without I/Co, when available)
 |  |  | Net PRMA
 |  |  | Number of Active Counterparties as at 11/30
 |  |  | Number of Open Transactions as at 11/30
 |  |  | Number of Books (with DPR's for each Book)
 |  |  | Number of people, both Comm & Comm Supp as at 11/30
 |  |  | Average number of Transactions per day for 2001
 |  | plus: | E&Y Information
 |  |  | - requests to be provided by [NAME]
 |  |  | - will focus on Realizable Values
 |  |  | - will focus on CP's
 |  |  | - will focus on Legal Entities
Section 9: | Summary 11/30 DPR for Each Non-Wholesale Business Unit
Spreadsheet: vkaminski__40923__Nordic_VAR_Module
Sheet: Curves

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Price curves: Report from riskdesk, daily forward date is required |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Volatility curves: Report from riskdesk, daily forward date is required
Price | Volatility | ForwardDate | Finland:Day:Price | Finland:Night:Price | Smestad:Day:Price | Smestad:Night:Price | Strinda:Day:Price | Strinda:Night:Price | Sweden:Day:Price | Sweden:Night:Price | System:Day:Price | System:Night:Price | Tromso:Day:Price | Tromso:Night:Price | Finland:Day:Volatility | Finland:Night:Volatility | Smestad:Day:Volatility | Smestad:Night:Volatility | Strinda:Day:Volatility | Strinda:Night:Volatility | Sweden:Day:Volatility | Sweden:Night:Volatility | System:Day:Volatility | System:Night:Volatility | Tromso:Day:Volatility | Tromso:Night:Volatility
Spreadsheet: 867963d1714691066-trying-to-exclude-certain-results-from-location-columns-in-a-transactional-inventory-manufacturing-inventory
Sheet: Transactions

LAST TRANS. |  | TRANSACTION INFORMATION |  |  |  |  |  | PART INFORMATION
BIN NO. | NAME | DATE | REASON | QUANTITY | COMING FROM | GOING TO |  | ITEM NO. | [NAME] | O.H. QTY REMAINING | WIP QTY REMAINING
1 | [NAME] | 2024-05-01 00:00:00 | Test | 12 | Vendor | 400 Storage Shelf
2 | [NAME] | 2024-05-01 00:00:00 | Alpha Build | 25 | Vendor | [NAME]
3 | [NAME] | 2024-05-01 00:00:00 | Stocking Part | 12 | Vendor | 400 Storage Shelf
4 | [NAME] | 2024-05-02 00:00:00 | Receieved part | 10 | Vendor | WIP Shelf
4 | [NAME] | 2024-05-02 00:00:00 | Machined part | 5 | WIP Shelf | 400 Storage Shelf
2 | [NAME] | 2024-05-03 00:00:00 | Ppulled Part for machining | 2 | [NAME] | Quality
5 | [NAME] | 2024-05-03 00:00:00 | New part | 100 | Vendor | [NAME]
5 | [NAME] | 2024-05-03 00:00:00 | Maintenance | 50 | [NAME] | Quality
2 | [NAME] | 2024-05-03 00:00:00 | Test | 10 | Vendor | Quality
2 |  |  |  | 30 | Vendor | Quality
 |  |  |  | 15 | Quality | 400 Storage Shelf
Spreadsheet: 158244d1338109894-excel-vlookup-issue-testsetup-3-
Sheet: Sheet1

 |  |  |  | Size | 54" 10'
Name | CH | LF | OP | Pan | Net Pan | Yds
WC-q | 8 | 453 | 1 | 104.5465035771982 | 105 | 286.3636363636364
 |  |  |  | note since all these values are the same the result will never change
Size | Result | Result2
54" 8' | 4.333 | /11*30
54" 9' | 4.333 | /9*30
54" 10' | 4.333 | /8*30
Spreadsheet: phillip_m_love__30139__200006_OA
Sheet: TX-EGM-FLSH

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - REPORTED
COMPANY:  ECTR (EGM)
 |  |  | NGP&L |  | CPR Adjustments |  | 3rd Day CPR |  | [NAME] |  | [NAME]
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron | 12058069 | 38430000.50999999
2 |  | Liquidations | 0 | 0
3 |  | Interdesk | 0 | 0
4 |  | Option Premiums | 0 | 0
5 |  | Dmd Reimbursements | 0 | 0
 | Total Sales: |  | 12058069 | 38430000.50999999
 |  |  | 0 | 0
 | Purchases: |  | 0 | 0
6 |  | 3rd Party / Inter Enron | -7716905 | -24767566.75999999
7 |  | Liquidations | 0 | 0
8 |  | Interdesk | 0 | 0
9 |  | Option Premiums | 0 | 0
10 |  | [NAME] | 16787 | 58072
 | Total Purchases: |  | -7700118 | -24709494.75999999
 |  |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC): |  | 0 | 0
11 |  | Sales | 22328896 | 78557718.52000001
12 |  | Purchases | -23023876 | -81056970.81
 | Total Intra CTS Sales / Purchases |  | -694980 | -2499252.289999992
 |  |  | 0 | 0
 | Imbalances: |  | 0 | 0
13 |  | In Kind | 537385 | 3
14 |  | Cash Out | -536755 | -16109
15 |  | Cash In | 0 | 0
16 |  | Synthetic Storage | 0 | 0
 | Total Imbalances: |  | 630 | -16106
 |  |  | 0 | 0
 | Storage: |  | 0 | 0
17 |  | Injection (Sales to Stg) | 0 | 0
18 |  | W/D (Purchase from Stg) | 0 | 0
19 |  | Inventory Profit | 0 | 0
 |  | Total W/D | 0 | 0
 | Total Storage: |  | 0 | 0
 |  |  | 0 | 0
20 | Linepack: |  | 0 | 0
 |  |  | 0 | 0
21 | Shrinkage: |  | 0 | 0
 |  |  | 0 | 0
22 | UA4: |  | -3662971 | -15687545.48416742
 |  |  | 0 | 0
23 | Fuel: |  | -16787 | 0
 |  |  | 0 | 0
 | Transport Expense: |  | 0 | 0
24 |  | Commodity | 0 | 0
25 |  | Demand | 0 | 0
 | Total Transport Expense: |  | 0 | 0
 |  |  | 0 | 0
 | Transport Revenue: |  | 0 | 0
26 |  | Interstate | 0 | 0
27 |  | Intrastate | 0 | 0
 | Total Transport Revenue: |  | 0 | 0
 |  |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC): |  | 0 | 0
28 |  | Transport Expense | 0 | 0
29 |  | Transport Revenue | 0 | 0
 | Total Intra CTS Transport |  | 0 | 0
 |  |  | 0 | 0
 | Tie Out Schedule Items: |  | 0 | 0
 |  | MTM Income: | 0 | 0
30 |  | Current Gross Book Balance | 0 | 519130.8
31 |  | Prior Month Book Balance | 0 | -6879227
 |  | Total MTM Income | 0 | -6360096.2
32 |  | Prudency | 0 | 0
33 |  | Financial Liquidations | 0 | 5792644
34 |  | Originations | 0 | 308
35 |  | Broker Fees | 0 | -1000
36 |  | Asset Group Demand Charges | 0 | -98300
37 |  | [NAME] | 0 | 0
38 |  | Interdesk Charges | 0 | 0
39 |  | Canada | 0 | 0
40 |  | Miscellaneous | 0 | 2228
 |  | TOTAL INTRA-MTH
FT-South Texas
 |  | Current Month MTM | 0
 |  | Financial Liquidations | 0 | 0
 |  | Originations | 0 | -686167
 |  | TOTAL FIRM TRADING
 |  | TOTAL NGPL
Spreadsheet: 886504d1736522379-how-to-automatically-remove-or-identify-the-most-recent-row-based-on-a-combo-of-data-latest-unique-rows-required-darrenj1471-
Sheet: Current

ID | Code | Value | EffectiveFrom | DESIRED OUTCOME | Keep |  | ID | Code | Value | EffectiveFrom
/SO9/ | Pension EE | 7 | 2024-06-01 00:00:00
/SO9/ | Pension ER | 12 | 2024-06-01 00:00:00
/xckh | Pension EE | 7 | 2021-04-01 00:00:00 | THIS SHOULD BE REMOVED AS THE COMBO OF COLUMN A AND B BUT ISNT THE LATEST DATED ENTRY
/xckh | Pension EE | 9 | 2024-04-01 00:00:00
/xckh | Pension ER | 12 | 2021-04-01 00:00:00
+5uKY | Pension EE | 3 | 2024-11-01 00:00:00
+5uKY | Pension ER | 6 | 2024-11-01 00:00:00
+67Rb | Pension EE | 3 | 2023-08-01 00:00:00
+67Rb | Pension ER | 6 | 2023-08-01 00:00:00
+7vOX | Pension EE | 9 | 2021-04-01 00:00:00 | THIS SHOULD BE REMOVED AS THE COMBO OF COLUMN A AND B BUT ISNT THE LATEST DATED ENTRY
+7vOX | Pension EE | 14 | 2024-04-01 00:00:00
+7vOX | Pension ER | 12 | 2021-04-01 00:00:00
+AiQq | Pension EE | 5 | 2023-08-01 00:00:00
+AiQq | Pension ER | 10 | 2023-08-01 00:00:00
+bxir | Pension EE | 5 | 2021-04-01 00:00:00 | THIS SHOULD BE REMOVED AS THE COMBO OF COLUMN A AND B BUT ISNT THE LATEST DATED ENTRY
+bxir | Pension EE | 5 | 2021-04-01 00:00:00
+bxir | Pension ER | 10 | 2021-04-01 00:00:00
+HPQk | Pension EE | 3 | 2024-03-01 00:00:00
+HPQk | Pension ER | 6 | 2024-03-01 00:00:00
+U65E | Pension EE | 5 | 2020-06-01 00:00:00 | THIS SHOULD BE REMOVED AS THE COMBO OF COLUMN A AND B BUT ISNT THE LATEST DATED ENTRY
+U65E | Pension EE | 5 | 2021-04-01 00:00:00
+U65E | Pension ER | 10 | 2020-06-01 00:00:00
Spreadsheet: 182054d1348246810-drop-down-lists-fotis_fl_book1-2-
Sheet: Sheet1

 |  |  |  |  | 0.6 | <<<<Validation List
 | 1 | 92 | 115 | 100 | 200 | 10
 | 2 | 196 | 115 | 37 | 54 | 20
 | 3 | 78 | 85 | 103 | 84 | 10 |  |  |  |  | List of your percentage
 | 4 | 182 | 85 | 118 | 172 | 10 |  |  |  |  | 0.1
 | 5 | 173 | 114 | 114 | 29 | 50 |  |  |  |  | 0.15
 |  |  |  |  |  |  |  |  |  |  | 0.2
 |  | RESULTS |  |  |  |  |  |  |  |  | 0.25
 | 1 |  |  |  |  |  |  |  |  |  | 0.3
 | 2 |  |  |  |  |  |  |  |  |  | 0.35
 | 3 |  |  |  |  |  |  |  |  |  | 0.4
 | 4 |  |  |  |  |  |  |  |  |  | 0.45
 | 5 |  |  |  |  |  |  |  |  |  | 0.5
 |  |  |  |  |  |  |  |  |  |  | 0.55
 |  |  |  |  |  |  |  |  |  |  | 0.6
 |  |  |  |  |  |  |  |  |  |  | 0.65
 |  |  |  |  |  |  |  |  |  |  | 0.7