tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 787708d1657980512-need-formula-to-filter-student-information-based-on-a-condition-of-getting-subject-mark-le-student-filter
Sheet: Sheet2

Range 1 |  |  |  |  |  |  |  |  |  | Range 3
Semester | First | Stage | Second |  |  |  |  |  |  | Name | Stage | Semester | Subject
Name | Sub.1 | Sub.2 | Sub.3 | Sub.4 | Sub.5 |  |  |  |  | Student 1 | Second | First | sub.1
Student 1 | 45 | 67 | 66 | 51 | 47 |  |  |  |  | student 1 | Second | First | sub.5
Student 2 | 75 | 46 | 66 | 77 | 92 |  |  |  |  | student 2 | Second | First | sub,2
Student 3 | 35 | 55 | 60 | 51 | 43 |  |  |  |  | student 3 | Second | First | sub.1
Student 4 | 60 | 34 | 52 | 59 | 40 |  |  |  |  | student 3 | Second | First | sub,5
Student 5 | 55 | 60 | 55 | 59 | 69 |  |  |  |  | student 4 | Second | First | sub.2
Student 6 | 39 | 52 | 33 | 40 | 39 |  |  |  |  | student 4 | Second | First | sub.5
Student 7 | 71 | 65 | 68 | 77 | 59 |  |  |  |  | student 6 | Second | First | sub.1
Student 8 | 47 | 43 | 43 | 47 | 60 |  |  |  |  | student 6 | Second | First | [NAME]
 |  |  |  |  |  |  |  |  |  | student  6 | Second | First | sub.4
 |  |  |  |  |  |  |  |  |  | student 6 | Second | First | sub.5
Range 2 |  |  |  |  |  |  |  |  |  | student 8 | Second | First | sub.1
 |  |  |  |  |  |  |  |  |  | student 8 | Second | First | sub.2
Semester | First | Stage | Second |  |  |  |  |  |  | student 8 | Second | First | [NAME]
Name | Sub.6 | Sub.7 | Sub.8 | Sub.9 | Sub.10 |  |  |  |  | student 8 | Second | First | sub.4
Student 1 | 34 | 50 | 66 | 45 | 67 |  |  |  |  | student 1 | Second | second | sub.6
Student 2 | 51 | 92 | 66 | 55 | 46 |  |  |  |  | student 1 | Second | second | sub.9
Student 3 | 59 | 43 | 60 | 57 | 55 |  |  |  |  | student 2 | Second | second | sub.10
Student 4 | 34 | 40 | 52 | 40 | 34 |  |  |  |  | student3 | Second | second | sub.7
Student 5 | 46 | 69 | 55 | 35 | 60 |  |  |  |  | student 4 | Second | second | sub.6
Student 6 | 76 | 39 | 55 | 65 | 52 |  |  |  |  | student 4 | Second | second | sub.7
Student 7 | 61 | 59 | 68 | 55 | 65 |  |  |  |  | student 4 | Second | second | sub.9
Student 8 | 88 | 60 | 43 | 57 | 43 |  |  |  |  | student 4 | Second | second | sub.10
 |  |  |  |  |  |  |  |  |  | student 5 | Second | second | sub.6
 |  |  |  |  |  |  |  |  |  | student 5 | Second | second | sub,9
 |  |  |  |  |  |  |  |  |  | student 6 | Second | second | sub.7
 |  |  |  |  |  |  |  |  |  | student 8 | Second | second | sub.8
 |  |  |  |  |  |  |  |  |  | student 8 | Second | second | sub.10
Spreadsheet: 710076d1608711505-populate-a-named-range-by-looking-up-a-pivot-table-pivottest
Sheet: Pivot

Consequence | Severity Description | Sum of Severity Number |  | Very High
Consequence1 | Very High | 5 |  |  |  |  | High
Consequence1 | High | 4 |  |  |  |  | Medium
Consequence1 | Medium | 3 |  | Medium |  |  | Low
Consequence1 | Low | 2 |  |  |  |  | Very Low
Consequence1 | Very Low | 1
Consequence2 | Very High | 5
Consequence2 | High | 4
Consequence2 | Medium | 3
Consequence2 | Low | 2
Consequence2 | Very Low | 1
Consequence3 | Very High | 5
Consequence3 | High | 4
Consequence3 | Medium | 3
Consequence3 | Low | 2
Consequence3 | Very Low | 1
Consequence4 | Very High | 5
Consequence4 | High | 4
Consequence4 | Medium | 3
Consequence4 | Low | 2
Consequence4 | Very Low | 1
Consequence5 | Very High | 5
Consequence5 | High | 4
Consequence5 | Medium | 3
Consequence5 | Low | 2
Consequence5 | Very Low | 1
Spreadsheet: 807601d1669967016-formular-for-analyze-best-and-weak-students-g666-ver1-ans3-v2
Sheet: 5 BEST AND WEK STUDENTS

E. FIVE BEST STUDENTS
NO | NAME | SEX M=1 &F=2 | SCHOOL | WARD | SUBJECTS |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL | AVERAGE | GRADE
 |  |  |  |  | KISW |  | ENGL |  | HIS |  | SAY |  | M/JAM |  | URA |  | S/KAZI
 |  |  |  |  | A | D | A | D | A | D | A | D | A | D | A | D | A | D
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | On the basis of total marks
F. FIVE WEAK STUDENTS
NO | NAME | SEX M=1 &F=2 | SCHOOL | WARD | SUBJECTS |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL | AVERAGE | GRADE
 |  |  |  |  | KISW |  | ENGL |  | HIS |  | SAY |  | M/JAM |  | URA |  | S/KAZI
 |  |  |  |  | A | D | A | D | A | D | A | D | A | D | A | D | A | D
Spreadsheet: 774313d1648388561-lookup-rates-in-excelsheet-based-on-binning-buckets-instead-of-full-data-modification-invuloefening-2022-rates
Sheet: Rates

 | OLD
 | Interest rate
 | Period/ rates | 0.01 | 0.02 | 0.03 | 0.04 | 0.05 | 0.06 | 0.07 | 0.08 | 0.09 | 0.1 | 0.11 | 0.12 | 0.13 | 0.14 | 0.15 | 0.16 | 0.17 | 0.18 | 0.19 | 0.2 | 0.21 | 0.22 | 0.23 | 0.24 | 0.25 | 0.26 | 0.27 | 0.28 | 0.29 | 0.3 | 0.31 | 0.32 | 0.33 | 0.34 | 0.35 | 0.36 | 0.37 | 0.38 | 0.39 | 0.4 | 0.41 | 0.42 | 0.43 | 0.44 | 0.45 | 0.46 | 0.47 | 0.48 | 0.49 | 0.5 | 0.51 | 0.52 | 0.53 | 0.54 | 0.55 | 0.56 | 0.57 | 0.58 | 0.59 | 0.6 | 0.61 | 0.62 | 0.63 | 0.64 | 0.65 | 0.66 | 0.67 | 0.68 | 0.69 | 0.7 | 0.71 | 0.72 | 0.73 | 0.74 | 0.75 | 0.76 | 0.77 | 0.78 | 0.79 | 0.8 | 0.81 | 0.82 | 0.83 | 0.84 | 0.85 | 0.86 | 0.87 | 0.88 | 0.89 | 0.9 | 0.91 | 0.92 | 0.93 | 0.94 | 0.95 | 0.96 | 0.97 | 0.98 | 0.99 | 1
 | 10 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.0115 | 0.012 | 0.012 | 0.012 | 0.012 | 0.012 | 0.012 | 0.012 | 0.012 | 0.012 | 0.012 | 0.014 | 0.014 | 0.014 | 0.014 | 0.014 | 0.014 | 0.014 | 0.014 | 0.014 | 0.014 | 0.014 | 0.014 | 0.014 | 0.014 | 0.014 | 0.014 | 0.014 | 0.014 | 0.014 | 0.014 | 0.016 | 0.016 | 0.016 | 0.016 | 0.016 | 0.016 | 0.016 | 0.016 | 0.016 | 0.016
 | Old
 | Input
 | LTV | 0.6437
 | LTV (rounded
 | Rate
 | NEW
 | 0-60% | 60,00001-70% | 70,00001-90% | 90,00001-100%
 | 0.0115 | 0.012 | 0.014 | 0.016
 | New
 | LTV
 | Rate |  | ?
Spreadsheet: 861769d1709609181-making-bulk-substitutions-from-list-sample-file
Sheet: Substitutions

Look for Text | Corresponding Substitution to be made
Afghanistan
Albania
Algeria
Andorra
Angola
Argentina
Armenia
Australia
Austria
Azerbaijan
Bahamas
Bahrain
Bangladesh
Barbados
Belarus
Belgium
Belize
Benin
Bhutan
Bolivia
Bosnia and Herzegovina
Botswana
Brazil
Brunei
Bulgaria
[NAME]
Burundi
Cambodia
Cameroon
Canada
Cape Verde
Central African Republic
Chad
Chile
Spreadsheet: 764289d1642679172-more-levels-of-nesting-than-you-can-use-in-the-current-file-format-copy-of-example-1-aligw
Sheet: Age Sheet

 |  |  |  |  | Age Range | Last Age from the range | Staged Age
 |  |  |  |  | < 30 | 29 | 19
 |  |  |  |  | < 35 | 34 | 32
 |  |  |  |  | < 40 | 39 | 37
 |  |  |  |  | < 45 | 44 | 42
 |  |  |  |  | < 50 | 49 | 47
 |  |  |  |  | < 55 | 54 | 52
 |  |  |  |  | < 60 | 59 | 57
 |  |  |  |  | < 65 | 64 | 62
Spreadsheet: 6ce8998a-4d78-4503-aa2f-2adecbc074bc
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
FSCHS | Test | FSCHS | Schistosoma [NAME], FMI (Serum) | Schistosoma [NAME] (Serum) | Fluorescent [NAME] (FMI) | Plain, Red-Top or serum gel tube: Red |  |  | 1 | mL | Draw blood in a plain, red-top tube(s). Spin down and send 1 mL serum refrigerated.  Note: Serum gel tube is acceptable, but must pour off into a plastic vial. | 0.25 mL | Specimens other than	Serum Anticoagulants other than	NA Hemolysis	NA Thawing	NA Lipemia	NA Icteric	NA | REFERENCE RANGE:   <1.00      INTERPRETIVE CRITERIA:                 <1.00   Antibody Not Detected        > or = 1.00   Antibody Detected      This assay utilizes the microsomal fraction of adult S. mansoni worms (MAMA) as antigen, and is thus highly specific (99%) and sensitive (96%) for detection of infection caused by S. mansoni.  Although the assay is also highly specific for infections caused by other Schistosoma species  (S. japonicum, S. haematobium, [NAME]), its sensitivity for these infections is lower (55%).  Antibody levels do not correlate with intensity of infection.     Test Performed by: Focus Diagnostics, Inc.                              5785 Corporate Ave.                              Cypress, CA 90630-4750 | Wednesday | 1 - 8 days | 3 - 10 days | 1 | 86682 |  |  |  |  | Focus Diagnositics, Inc.
FSCHS | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
FSCHS | Result | Z0551 | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 749718d1632982747-ranking-without-duplicates-using-3-criteria-ranking-problem-all-data-included
Sheet: Tab1

 | 2nd | 3rd | 4th | 1st
Name | Games Correct | Margin Points | Margin Difference | Log points | Log Position | Actual Ranking
Player 1 | 6 | 0.5 | 92 | 6.5 |  | 27
Player 2 | 6 | 2 | 76 | 9 |  | 7
Player 3 | 3 | 1.5 | 123 | 4.5 |  | 35
Player 4 | 5 | 1.5 | 86 | 7.5 |  | 20
Player 5 | 6 | 2 | 81 | 8 |  | 14
Player 6 | 6 | 2 | 94 | 9 |  | 8
Player 7 | 6 | 1 | 74 | 7 |  | 23
Player 8 | 6 | 1.5 | 94 | 8.5 |  | 10
Player 9 | 6 | 2 | 82 | 8 |  | 15
Player 10 | 5 | 1.5 | 91 | 7.5 |  | 21
Player 11 | 5 | 0.5 | 137 | 5.5 |  | 32
Player 12 | 7 | 2.5 | 62 | 10.5 |  | 2
Player 13 | 7 | 2 | 74 | 9 |  | 6
Player 14 | 7 | 2 | 42 | 10 |  | 3
Player 15 | 8 | 1 | 53 | 11 |  | 1
Player 16 | 4 | 1.5 | 96 | 5.5 |  | 33
Player 17 | 6 | 1 | 89 | 8 |  | 18
Player 18 | 3 | 0 | 116 | 3 |  | 36
Player 19 | 6 | 1.5 | 99 | 8.5 |  | 11
Player 20 | 6 | 1.5 | 52 | 8.5 |  | 9
Player 21 | 6 | 1 | 74 | 7 |  | 23
Player 22 | 4 | 1.5 | 114 | 5.5 |  | 34
Player 23 | 7 | 1 | 80 | 8 |  | 12
Player 24 | 6 | 2 | 61 | 8 |  | 13
Player 25 | 6 | 1 | 99 | 7 |  | 25
Player 26 | 5 | 1 | 85 | 6 |  | 30
Player 27 | 3 | 1 | 114 | 6 |  | 31
Player 28 | 5 | 2 | 98 | 7 |  | 26
Player 29 | 6 | 1.5 | 81 | 7.5 |  | 19
Player 30 | 7 | 1.5 | 79 | 9.5 |  | 5
Player 31 | 5 | 1.5 | 93 | 7.5 |  | 22
Player 32 | 5 | 1.5 | 74 | 6.5 |  | 28
Player 33 | 7 | 2 | 65 | 10 |  | 4
Player 34 | 6 | 1 | 75 | 8 |  | 17
Player 35 | 5 | 1.5 | 85 | 6.5 |  | 29
Player 36 | 3 | 0 | 163 | 3 |  | 37
Player 37 | 6 | 2 | 83 | 8 |  | 16
Spreadsheet: 549690d1511877398-lookup-in-range-which-is-in-dependence-of-another-column-and-return-a-different-column-date-in-range-return-percentage
Sheet: Formula needed

PersNo | Date | Last name | First name
2861 | 2015-10-01 00:00:00 | [NAME] | Mairi | Look for PersNo in A2 in column A of HR query; look for Date in B2 in rang the PersNo in HR Query and dated in Column J and K and if the date from B2 is in the range then return value from G in HR Query
2861 | 2017-03-03 00:00:00 | [NAME] | Mairi
9961 | 2015-04-30 00:00:00 | Petri | Marzia
9961 | 2015-06-01 00:00:00 | Petri | Marzia
9961 | 2016-02-15 00:00:00 | Petri | Marzia
10401 | 2014-10-31 00:00:00 | Yong | Susanna
10401 | 2014-01-01 00:00:00 | Yong | Susanna
Spreadsheet: 48685d1247922464-automated-employee-order-chart-book3
Sheet: Sheet1

Session Date | Client | Technician Name | Session Type |  |  | Order | Tech Name | Last Appt Date | Last Client
2009-11-06 00:00:00 | Jones | [NAME] | In-Home |  |  | 1 | [NAME] | 2008-10-07 00:00:00 | [NAME]
2009-11-07 00:00:00 | Smith | [NAME] | In-Home |  |  | 2 | [NAME] | 2009-11-06 00:00:00 | Jones
2008-10-07 00:00:00 | [NAME] | [NAME] | In-Home |  |  | 3 | [NAME] | 2009-11-07 00:00:00 | Smith
 |  |  |  | s
Spreadsheet: 70865d1271610165-voedselgenerator-voedselgenerator-help-
Sheet: avondmaaltijd

[NAME]
stamppot andijvie
[NAME] | 300 | gram
Gesneden Andijvie | 150 | gram
Worst | 0.5 | stuk
Spekjes | 50 | gram
[NAME] | 0.05 | liter
Melk | 0.1 | liter
stamppot boerenkool
[NAME] | 300 | gram
Boerenkool | 150 | gram
Worst | 0.5 | stuk
Spekjes | 40 | gram
[NAME] | 0.05 | liter
Melk | 0.03 | liter
hutspot
[NAME] | 300 | gram
uien | 110 | gram
wortel | 110 | gram
Worst | 0.5 | stuk
[NAME] | 0.05 | liter
Melk | 0.03 | liter
stampot zuurkool
[NAME] | 300 | gram
zuurkool | 150 | gram
Worst | 0.5 | stuk
Spekjes | 50 | gram
[NAME] | 0.05 | liter
Melk | 0.03 | liter
annanas | 0.1 | blik
stampot snijbonen
[NAME] | 300 | gram
snijbonen | 150 | gram
Worst | 0.5 | stuk
[NAME] | 0.05 | liter
Melk | 0.03 | liter
nasí
[NAME]
rijst met [NAME]
Rijst | 100 | gram
Saus | 0.25 | pakje
[NAME] | 120 | gram
Kroepoek | 30 | gram
rijst met zoet zure saus
Rijst | 100 | gram
Saus | 165 | ml
kip | 120 | gram
Kroepoek | 30 | gram
chilli con carne
[NAME] bonen | 180 | gram
Ui | 0.4 | ui
prij | 35 | gram
paprika | 0.25 | stuk
Gehakt | 150 | gram
Mais | 15 | gram
Tomatenpuree | 15 | gram
Chili [NAME] | 0.25 | stuk
macaroni
macaroni | 100 | gram
Ham | 100 | gram
Ui | 0.25 | ui
Tomatenpuree | 0.25 | stuk
Macaroni mix | 0.25 | stuk
spaghetti
spaghetti | 100 | gram
Gehakt | 110 | gram
Ui | 0.25 | ui
Tomatenpuree | 0.25 | stuk
Macaroni mix | 0.25 | stuk
noodles
[NAME]
frikandel | 1 | stuks
hamburger | 1 | stuks
worst | 1 | stuks
saté stokjes | 2 | stuks
speklap | 1 | stuks
varkenslapje | 1 | stuks
stokbrood | 0.2 | brood
[NAME] | 0.2 | kuipje
komkommer | 0.15 | komkommer
tomaat | 0.33 | tomaat
annanas | 0.2 | blik
champignons | 0.2 | pakje
knoflooksaus | 0.025 | flesje
mosterdsaus | 0.025 | flesje
bbqsaus | 0.025 | flesje
satesaus | 0.05 | bak
mayonaise | 0.025 | flesje
salade | 0.15 | bak
gourmet
frikandel | 0.75 | stuks
hamburger | 0.75 | stuks
kipfilet | 0.5
gehakt | 80 | gram
spek | 3 | plakjes
[NAME] | 0.2 | pakje
varkenslapje | 0.75 | stuks
[NAME] | 80 | gram
stokbrood | 0.2 | brood
[NAME] | 0.2 | kuipje
komkommer | 0.15 | komkommer
tomaat | 0.33 | tomaat
annanas | 0.2 | blik
champignons | 0.2 | pakje
aardappelschijvjes | 0.15 | pakje
knoflooksaus | 0.025 | flesje
mosterdsaus | 0.025 | flesje
bbqsaus | 0.025 | flesje
satesaus | 0.05 | bak
mayonaise | 0.025 | flesje
salade | 0.15 | bak
eieren | 0.25 | ei
[NAME] | 0.05 | pak
ui | 0.2 | ui
paprika | 0.2 | [NAME]
olie | 0.01 | fles
fondue
kipfilet | 0.5
gehakt | 150 | gram
spek | 3 | plakjes
varkenslapje | 0.75 | stuks
stokbrood | 0.2 | brood
[NAME] | 0.2 | kuipje
komkommer | 0.15 | komkommer
tomaat | 0.33 | tomaat
annanas | 0.2 | blik
knoflooksaus | 0.025 | flesje
mosterdsaus | 0.025 | flesje
satesaus | 0.05 | bak
mayonaise | 0.025 | flesje
salade | 0.15 | bak
olie | 0.17 | fles
wraps
wraps | 2 | wraps
totaal.
product | hoeveelheid | [NAME] | [NAME]
 |  |  | kilo
 |  |  | gram
 |  |  | worsten
 |  |  | gram
 |  |  | liter
 |  |  | liter
 |  |  | kilo
 |  |  | gram
 |  |  | gram
 |  |  | kilo
 |  |  | blikken
 |  |  | kilo
Spreadsheet: 859494d1707869303-trigger-betting-function-trigger-betting-function-blacktiger1-
Sheet: पत्रक1

Enter Data | Actual Patterns | Bets | Actual Patterns | trigger! | Bets
B
P
B
P |  |  |  |  |  | Patterns | Frequency
B |  |  |  |  |  | BBB
P |  |  |  |  |  | BBP
B |  |  |  |  |  | BPP
P |  |  |  |  |  | BPB
P |  |  |  |  |  | PPP
B |  |  |  |  |  | PPB
P |  |  |  |  |  | PBB
B |  |  |  |  |  | PBP
B
B
B
B
B
B
B
B
B
B
B
P
P
P
P
P
P
B | trigger!
P | 1
B | 1
P | -1 | Desired Pattern was PBB
Spreadsheet: 65360d1266021349-organize-data-based-on-criteria-and-date-voucher-maintence
Sheet: C

Date | Last 6 | Driver # | Pick-up | 1 Stop | 2 Stop | 3 Stop | 4 Stop | W/T | Toll | Dri Fare | D Total | Co Fare | Profit
2010-01-12 00:00:00 | 123456 | 152 | 222 PICK UP | 333 1ST STOP | 3RD STOP |  |  |  |  | 36
2010-01-23 00:00:00 | 123456 | 241 | 222 ADDRESS | 333 [NAME] |  |  |  |  |  | 54
Spreadsheet: 876225d1722905976-need-formula-on-inventory-fifo
Sheet: Sheet1

 | Inventory with FIFO |  |  |  |  |  |  |  |  |  | Inventory with FIFO
 | Purchased |  |  | Sold |  |  | Balance |  |  |  | Purchased |  |  | Sold |  |  | Balance
 | Unit | Price | Total | Unit | Price | Total | Unit | Price | Total |  | Unit | Price | Total | Unit | Price | Total | Unit | Price | Total
 | 90 | 12 |  |  |  |  | 90 | 12 |  |  | 90 | 12
 | 82 | 13 |  |  |  |  | 82 | 13 |  |  | 82 | 13
 |  |  |  | 15 | 12 |  |  | 12 |  |  |  |  |  | 15
 |  |  |  |  |  |  | 82 | 13
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 50
 | Can anyone help me how to create a formula on Balance column,
 | that make purchase, sold data appear automatically on balance? |  |  |  |  |  |  |  |  |  |  |  |  | 100
 | I'm using FIFO Method. |  |  |  |  |  |  |  |  |  |  |  |  | 7
 | in FIFO, the first product to sold, is the product that come early.
Spreadsheet: 675204d1588192935-i-need-some-help-with-an-index-and-match-function-tracker-excel-blank-etaf-2-
Sheet: Sheet 1

 |  |  | Date
 |  |  |  |  |  |  | 2020-04-20 00:00:00 | 2020-04-21 00:00:00 | 2020-04-22 00:00:00 | 2020-04-23 00:00:00 | 2020-04-24 00:00:00 | 2020-04-25 00:00:00 | 2020-04-26 00:00:00 | 2020-04-27 00:00:00 | 2020-04-28 00:00:00 | 2020-04-29 00:00:00 | 2020-04-30 00:00:00 | 2020-05-01 00:00:00 | 2020-05-02 00:00:00 | 2020-05-03 00:00:00 | 2020-05-04 00:00:00 | 2020-05-05 00:00:00 | 2020-05-06 00:00:00 | 2020-05-07 00:00:00 | 2020-05-08 00:00:00 | 2020-05-09 00:00:00 | 2020-05-10 00:00:00 | 2020-05-11 00:00:00 | 2020-05-12 00:00:00 | 2020-05-13 00:00:00 | 2020-05-14 00:00:00 | 2020-05-15 00:00:00 | 2020-05-16 00:00:00 | 2020-05-17 00:00:00 | 2020-05-18 00:00:00 | 2020-05-19 00:00:00 | 2020-05-20 00:00:00 | 2020-05-21 00:00:00 | 2020-05-22 00:00:00 | 2020-05-23 00:00:00 | 2020-05-24 00:00:00 | 2020-05-25 00:00:00 | 2020-05-26 00:00:00 | 2020-05-27 00:00:00 | 2020-05-28 00:00:00 | 2020-05-29 00:00:00 | 2020-05-30 00:00:00 | 2020-05-31 00:00:00 | 2020-06-01 00:00:00 | 2020-06-02 00:00:00 | 2020-06-03 00:00:00 | 2020-06-04 00:00:00 | 2020-06-05 00:00:00 | 2020-06-06 00:00:00 | 2020-06-07 00:00:00 | 2020-06-08 00:00:00 | 2020-06-09 00:00:00 | 2020-06-10 00:00:00 | 2020-06-11 00:00:00 | 2020-06-12 00:00:00 | 2020-06-13 00:00:00 | 2020-06-14 00:00:00 | 2020-06-15 00:00:00 | 2020-06-16 00:00:00 | 2020-06-17 00:00:00 | 2020-06-18 00:00:00 | 2020-06-19 00:00:00 | 2020-06-20 00:00:00 | 2020-06-21 00:00:00 | 2020-06-22 00:00:00 | 2020-06-23 00:00:00 | 2020-06-24 00:00:00 | 2020-06-25 00:00:00 | 2020-06-26 00:00:00 | 2020-06-27 00:00:00 | 2020-06-28 00:00:00 | 2020-06-29 00:00:00 | 2020-06-30 00:00:00 | 2020-07-01 00:00:00 | 2020-07-02 00:00:00 | 2020-07-03 00:00:00 | 2020-07-04 00:00:00 | 2020-07-05 00:00:00 | 2020-07-06 00:00:00 | 2020-07-07 00:00:00 | 2020-07-08 00:00:00 | 2020-07-09 00:00:00 | 2020-07-10 00:00:00 | 2020-07-11 00:00:00 | 2020-07-12 00:00:00
Project ID | Project Name | Project Size | Start Date | End Date |  | Allocation
123456 | Test 1 | S | 2020-04-01 00:00:00 | 2020-06-30 00:00:00
Stage 1 |  | L | 2020-04-27 00:00:00 | 2020-05-02 00:00:00
Stage 2 |  | L | 2020-05-05 00:00:00 | 2020-05-17 00:00:00
Stage 3 |  | S | 2020-05-18 00:00:00 | 2020-05-20 00:00:00
Stage 4 |  | S | 2020-05-21 00:00:00 | 2020-05-22 00:00:00
Stage 5 |  | S | 2020-05-24 00:00:00 | 2020-05-30 00:00:00
234567 | Test 2 | M | 2020-04-21 00:00:00 | 2020-05-21 00:00:00
Stage 1 |  | XL | 2020-04-23 00:00:00 | 2020-04-24 00:00:00
Stage 2 |  | M | 2020-04-26 00:00:00 | 2020-04-27 00:00:00
Stage 3 |  | l | 2020-04-28 00:00:00 | 2020-05-03 00:00:00
Stage 4 |  | l | 2020-05-04 00:00:00 | 2020-05-14 00:00:00
Stage 5 |  | M | 2020-05-14 00:00:00 | 2020-05-21 00:00:00
Spreadsheet: 193793d1352950743-track-high-score-and-transfer-info-scoresummary-max-rev2
Sheet: Paul

Scores | Opponent
9 | Washington
8 | Adams
9 | [NAME]
8 | [NAME]
9 | [NAME]
8 | [NAME]
9 | Roosevelt
32 | Lincoln
8 | Truman
9 | [NAME]
8 | [NAME]
Spreadsheet: phillip_m_love__30141__200001_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 | 17467325 | 41711686.16
2 |  | Liquidations | 0 | 0
3 |  | Interdesk | 1475282 | 3402546.59
4 |  | Option Premiums | 0 | 0
5 |  | Dmd Reimbursements | 0 | 120000
 | Total Sales: |  | 18942607 | 45234232.75
 |  |  | 0 | 0
 | Purchases: |  | 0 | 0
6 |  | 3rd Party / Inter Enron | -4577602 | -10382268.05999999
7 |  | Liquidations | 0 | 0
8 |  | Interdesk | -139780 | -297683
9 |  | Option Premiums | 0 | 0
10 |  | [NAME] | 14 | 30.82
 | Total Purchases: |  | -4717368 | -10679920.23999999
 |  |  | 0 | 0
 | Intra CTS (EGM / HPL / LRC): |  | 0 | 0
11 |  | Sales | 16759808 | 39436699.72
12 |  | Purchases | -21047139 | -47754777.99
 | Total Intra CTS Sales / Purchases |  | -4287331 | -8318078.270000003
 |  |  | 0 | 0
 | Imbalances: |  | 0 | 0
13 |  | In Kind | 0 | 0
14 |  | Cash Out | 0 | 0
15 |  | Cash In | 0 | 0
16 |  | Synthetic Storage | 0 | 0
 | Total Imbalances: |  | 0 | 0
 |  |  | 0 | 0
 | Storage: |  | 0 | 0
17 |  | Injection (Sales to Stg) | 0 | 0
18 |  | W/D (Purchase from Stg) | -854082 | -1974467.45
19 |  | Inventory Profit | 0 | 0
 |  | Total W/D | -854082 | -1974467.45
 | Total Storage: |  | -854082 | -1974467.45
 |  |  | 0 | 0
20 | Linepack: |  | 0 | 0
 |  |  | 0 | 0
21 | Shrinkage: |  | 0 | 0
 |  |  | 0 | 0
22 | UA4: |  | -9083826 | -20648848.03708105
 |  |  | 0 | 0
23 | Fuel: |  | -14 | 0
 |  |  | 0 | 0
 | Transport Expense: |  | 0 | 0
24 |  | Commodity | 0 | -475000
25 |  | Demand | 0 | 0
 | Total Transport Expense: |  | 0 | -475000
 |  |  | 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 | -2639306.77
31 |  | Prior Month Book Balance | 0 | 739519
 |  | Total MTM Income | 0 | -1899787.77
32 |  | Prudency | 0 | 0
33 |  | Financial Liquidations | 0 | 1778233.65
34 |  | Originations | 0 | 17704
35 |  | Broker Fees | 0 | 0
36 |  | Asset Group Demand Charges | 0 | 0
37 |  | [NAME] | 0 | 0
38 |  | Interdesk Charges | 0 | 0
39 |  | Canada | 0 | 0
40 |  | Miscellaneous | 0 | -207047
 |  | TOTAL INTRA-MTH
FT-South Texas
 |  | Current Month MTM | 0 | 9167000
 |  | Financial Liquidations | 0 | 0
 |  | Originations | 0 | 0
 |  | TOTAL FIRM TRADING
 |  | TOTAL NGPL