tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 683151d1592513016-need-help-on-sumifs-for-horizontal-and-vertical-criteria-from-2-different-tabs-need-help-on-sumifs-for-horizontal-and-vertical-criteria-from-2-different-tabs-v2
Sheet: Sheet1

 |  |  | Q1 | Q2 | Q3 | Q4 | Total |  | What I need |  |  |  |  |  |  | What I need
 | CNN | ALABEL_CONT | 315480.24210288 | 1135165.754609993 | 1071306.625136332 | 667796.802792415 |  |  |  |  |  |  |  |  |  | Sheet1 | CNN | ALABEL_CONT | Q1 | 315480.24210288
 | CNN | COGS_CC | 55207.44856978 | 160759.3861043007 | 93302.44596697259 | 88920.7411886433 |  |  |  |  |  |  |  |  |  | Sheet1 | CNN | ALABEL_CONT | Q2 | 1135165.754609993
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sheet1 | CNN | ALABEL_CONT | Q3 | 1071306.625136332
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sheet1 | CNN | ALABEL_CONT | Q4 | 667796.802792415
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sheet1 | CNN | COGS_CC | Q1 | 55207.44856978
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sheet1 | CNN | COGS_CC | Q2 | 160759.3861043007
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sheet1 | CNN | COGS_CC | Q3 | 93302.44596697259
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sheet1 | CNN | COGS_CC | Q4 | 88920.7411886433
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sheet2 | FP&A | BLABEL_CONT | Q1 | 0.3648460706249971
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sheet2 | FP&A | BLABEL_CONT | Q2 | 0.3648460706249971
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sheet2 | FP&A | BLABEL_CONT | Q3 | 0.3980660706250019
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sheet2 | FP&A | BLABEL_CONT | Q4 | 0.401199710625
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sheet2 | FP&A | COGS_CC | Q1 | 1.459384282499988
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sheet2 | FP&A | COGS_CC | Q2 | 1.459384282499988
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sheet2 | FP&A | COGS_CC | Q3 | 1.592264282500008
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sheet2 | FP&A | COGS_CC | Q4 | 1.6047988425
Spreadsheet: 813555d1673857687-pls-help-average-with-if-conditions-need-average-of-each-product-specified-by-year-and-market-entry-date-for-blank-1
Sheet: Product Price & Average

Data |  |  |  |  |  |  |  | Average
 |  |  |  |  |  |  |  |  |  |  |  | 2017 |  |  |  | 2014 |  | 2019 |  |  | 2020 |  |  | 2021 |  |  | 2022 |  |  | 2023 |  |  | 2024
Product ID | Product Name | Amount | Effective Date | Expiration Date | Start Year | End Year |  | Product ID | Product Name | Market Entry Date | Market Entry Year | Average Amt for 2017 | % Increased based on previous year | Amount Increased Based on Previous Year | Average Amt for 2018 | % Increased based on previous year | Amount Increased Based on Previous Year | Average Amt for 2019 | % Increased based on previous year | Amount Increased Based on Previous Year | Average Amt for 2020 | % Increased based on previous year | Amount Increased Based on Previous Year | Average Amt for 2021 | % Increased based on previous year | Amount Increased Based on Previous Year | Average Amt for 2022 | % Increased based on previous year | Amount Increased Based on Previous Year | Average Amt for 2023 | % Increased based on previous year | Amount Increased Based on Previous Year | Average Amt for 2024 | % Increased based on previous year | Amount Increased Based on Previous Year
1003 | Candy A | 8754.9 | 2018-01-01 00:00:00 | 2018-12-31 00:00:00 |  |  |  | 1003 | Candy A
1003 | Candy A | 9297.7 | 2019-01-01 00:00:00 | 2019-12-31 00:00:00 |  |  |  | 1004 | Candy B
1003 | Candy A | 9985.73 | 2020-01-01 00:00:00 | 2020-12-31 00:00:00 |  |  |  | 1005 | Candy C
1003 | Candy A | 10604.85 | 2021-01-01 00:00:00 | 2022-01-13 00:00:00 |  |  |  | 1006 | Candy D
1003 | Candy A | 11124.49 | 2022-01-14 00:00:00 | 2023-01-02 00:00:00
1003 | Candy A | 11680.71 | 2023-01-03 00:00:00 | 4700-12-31 00:00:00
1004 | Candy B | 370.29 | 2013-12-27 00:00:00 | 2014-06-30 00:00:00
1004 | Candy B | 388.44 | 2014-07-01 00:00:00 | 2014-12-30 00:00:00
1004 | Candy B | 415.24 | 2014-12-31 00:00:00 | 2015-12-22 00:00:00
1004 | Candy B | 443.89 | 2015-12-23 00:00:00 | 2016-12-25 00:00:00
1004 | Candy B | 465.64 | 2016-12-26 00:00:00 | 2017-12-21 00:00:00
1004 | Candy B | 497.77 | 2017-12-22 00:00:00 | 4700-12-31 00:00:00
1005 | Candy C | 3225.88 | 2022-09-13 00:00:00 | 2023-01-02 00:00:00
1005 | Candy C | 3451.69 | 2023-01-03 00:00:00 | 4700-12-31 00:00:00 |  |  |  |  |  | Not pulling data correctly based on Product ID
1006 | Candy D | 18272.79 | 2022-12-15 00:00:00 | 2023-01-02 00:00:00 |  |  |  |  | 1st Condition | if product ID in I Column matches Product ID Data Table
1006 | Candy D | 19734.61 | 2023-01-03 00:00:00 | 4700-12-31 00:00:00 |  |  |  |  | 2nd Condition | if start year and end year matches year in S2
 |  |  |  |  |  |  |  |  | 3rd Condition | then give me the average of Amount
 |  |  |  |  |  |  |  |  |  | =[NAME] Year],2019)
 |  |  |  |  |  |  |  |  |  | =AVERAGE(IF(TableData[[Start Year]:[End Year]]=2019,TableData[Amount]))
Spreadsheet: 91147d1290874899-a-formula-to-multiple-search-the-value-and-total-up-weight3
Sheet: Block A

 |  |  |  |  |  |  | Date | Type no | SF
 |  | Block A |  |  |  |  | Block A
 |  |  |  |  |  |  | 27/11 | 30 | 1277
 |  |  |  |  |  |  | 27/11 | 35 | 1000
 |  |  |  |  |  |  | 27/11 | 30 | 5499
 |  |  |  |  |  |  | 27/11 | 32 | 10273
 |  |  |  |  |  |  | 27/11 | 32 | 1593
 |  |  |  |  |  |  | 27/11 | 35 | 1363
 |  |  |  |  |  |  | 27/11 | 32 | 690
 |  | Block B |  |  |  |  | Block B
 |  |  |  |  |  |  | 28/11 | 30 | 7078
 |  |  |  |  |  |  | 28/11 | 30 | 40
 |  | Block C |  |  |  |  | Block C
 |  |  |  |  |  |  | 28/11 | 30 | 442
 |  |  |  |  |  |  | 29/11 | 30
 |  | weight= SF / profile
 |  |  | weight |  |  | type no | profile
 |  | Block A |  |  |  | 35 | 5500
 |  | Block A & C |  |  |  | 32 | 4500
 |  |  |  |  |  | 30 | 3500
 |  |  |  |  |  | 28 | 3000
 |  |  |  |  |  | 26 | 2500
 |  |  |  |  |  | 24 | 2200
Spreadsheet: 693596d1599052433-sumifs-not-working-pulling-zero-monthly-example
Sheet: details

 | Name | date | type | money | hours | month
 | Me | 2020-10-01 00:00:00 | rg | 775 | 9
 | Me | 2020-10-02 00:00:00 | rg | 775 | 9
 | Me | 2020-10-03 00:00:00 | rg | 775 | 9
 | Me | 2020-10-04 00:00:00 | rg | 775 | 9
 | Mom | 2020-10-05 00:00:00 | rg | 775 | 9
 | Mom | 2020-10-06 00:00:00 | rg | 775 | 9
 | Mom | 2020-09-07 00:00:00 | rg | 775 | 9
 | Mom | 2020-09-08 00:00:00 | rg | 775 | 9
 | Sis | 2020-10-01 00:00:00 | rg | 775 | 9
 | Sis | 2020-10-02 00:00:00 | rg | 775 | 9
 | Sis | 2020-10-03 00:00:00 | rg | 775 | 9
 | Sis | 2020-12-14 00:00:00 | rg | 775 | 9
 | Sis | 2020-12-15 00:00:00 | rg | 775 | 9
 | Sis | 2020-12-16 00:00:00 | rg | 775 | 9
 | Sis | 2020-12-17 00:00:00 | rg | 775 | 9
 | [NAME] | 2020-10-01 00:00:00 | rg | 775 | 9
 | [NAME] | 2020-10-02 00:00:00 | rg | 775 | 9
 | [NAME] | 2020-10-03 00:00:00 | rg | 775 | 9
 | [NAME] | 2020-10-04 00:00:00 | rg | 775 | 9
 | [NAME] | 2020-12-05 00:00:00 | rg | 775 | 9
 | [NAME] | 2020-12-06 00:00:00 | rg | 775 | 9
 | [NAME] | 2020-12-07 00:00:00 | rg | 775 | 9
 | [NAME] | 2020-12-08 00:00:00 | rg | 775 | 9
 | [NAME] | 2020-11-09 00:00:00 | rg | 775 | 9
 | [NAME] | 2020-11-10 00:00:00 | rg | 775 | 9
 | [NAME] | 2020-11-11 00:00:00 | rg | 775 | 9
 | [NAME] | 2020-11-12 00:00:00 | rg | 775 | 9
 | [NAME] | 2020-11-13 00:00:00 | rg | 775 | 9
 | [NAME] | 2020-11-14 00:00:00 | rg | 775 | 9
 | Lil | 2020-11-05 00:00:00 | rg | 775 | 9
 | Lil | 2020-11-06 00:00:00 | rg | 775 | 9
 | Lil | 2020-11-07 00:00:00 | rg | 775 | 9
 | Lil | 2020-11-08 00:00:00 | rg | 775 | 9
Spreadsheet: 0a805602-a27a-4620-9383-c5440c47562a
Sheet: 9a

Product1 | Cleared2 | Uncleared | TOTAL
Fixed-Float | 1084280 | 97339 | 1181619
FRA | 559066 | 38284 | 597350
OIS | 172546 | 52753 | 225299
OTHER* | 11328 | 262229 | 273557
TOTAL
*OTHER variable includes the following products: Basis, Cap/Floor, Debt Option, Exotic, Fixed-Fixed, Inflation, and Swaption.
Spreadsheet: 838476d1691042279-textsplit-function-is-it-possible-to-spill-an-empty-cell-with-zero-txtsplit-aligw-2-
Sheet: Sheet1

 | # Name |  | E1 | E2/ LP | Speed |  | E1 | E2 | LP | Speed
 | 1 Smoke Wagon |  | 86 | 85/ 73 | 67 |  |  |  | 73 |  |  |  |  |  |  |  |  | 85 | 73 | 67
 | 2 Global Hysteria |  | No Starts Available |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0
 | 3 I Strong |  | 86 | [NAME] 75 * | 71* |  |  |  | 75 |  |  |  |  |  |  |  | 86 | 86 | 75 | 71
 | 4 Maluma |  | No Starts Available |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0
 | 5 Warrior's Cause |  | 93 | 91/ 65 | 66 |  |  |  | 65 |  |  |  |  |  |  |  | 93 | 91 | 65 | 66
 | 6 Exclusive Entry |  | No Starts Available |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0
 | 7 Bundaburg |  | No Starts Available |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0
 | 8 Imposter Syndrome |  | 85 | 87/ 75 | 72 |  |  |  | 75 |  |  |  |  |  |  |  | 85 | 87 | 75 | 72
 | # Name |  | E1 | E2/ LP | Speed |  | E1 | E2 | LP | Speed
 | 3 Protectthewitness |  | 95 | 85/ 57 * | 66* |  |  |  | 57 |  |  |  |  |  |  |  |  | 85 | 57 | 66
 | 2 R Girl Faith |  | 79 | 73/ 61 * | 63* |  |  |  | 61 |  |  |  |  |  |  |  | 79 | 73 | 61 | 63
 | 5 Vaccina |  | 88 | 81/ 55 * | 63* |  |  |  | 55 |  |  |  |  |  |  |  | 88 | 81 | 55 | 63
 | 1 Phancy Philly |  | 79 | 67/ 51 * | 54* |  |  |  | 51 |  |  |  |  |  |  |  | 79 | 67 | 51 | 54
 | 4 Sailor's Salute |  | 82 | 71/ 50 * | 53* |  |  |  | 50 |  |  |  |  |  |  |  | 82 | 71 | 50 | 53
 | 6 Calvary Kat
Spreadsheet: 289780d1389691445-consolidating-data-from-many-worksheets-example
Sheet: Sheet2

Employee | Payroll No. | Paycode | Hours | Adjustment/Notes | Amount
Employee 2 | 2
 |  | LE Company Basic | 31 | _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ | 245.21
 |  | Employee Totals : | 31 |  | 245.21
Employee 9 | 9
 |  | LE Company Basic | 23.25 | _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ | 183.9075
 |  | LE Company BH | 7.75 | _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ | 80.057501
 |  | LE Company Nights Premium | 0 | _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ | 35.28
 |  | Employee Totals : | 31 |  | 299.245001
Employee 10 | 10
 |  | LE Company Basic | 27.75 | _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ | 219.5025
 |  | LE Company Early Premium | 0 | _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ | 8.84
 |  | Employee Totals : | 27.75 |  | 228.3425
Employee 11 | 11
 |  | LE Company Basic | 23.25 | _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ | 183.907501
 |  | LE Company BH | 7.75 | _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ | 80.0575
 |  | LE Company Nights Premium | 0 | _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ | 35.28
 |  | Employee Totals : | 31 |  | 299.245001
employee 12 | 12
 |  | LE Company Basic | 31 | _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ | 245.209999
 |  | Employee Totals : | 31 |  | 245.209999
Spreadsheet: 677934d1589596975-progressive-sum-with-condition-somma
Sheet: Foglio1

Codice | Data | Valore | [NAME] (?) | result
L1 | 2020-01-01 00:00:00 | 5 |  | 5
L2 | 2020-01-02 00:00:00 | 9 |  | 14
L1 | 2020-01-03 00:00:00 | 11 |  | 20
L3 | 2020-01-04 00:00:00 | 8 |  | 28
L1 | 2020-01-05 00:00:00 | 7 |  | 24
[NAME] | 2020-01-06 00:00:00 | 4 |  | 28
L2 | 2020-01-07 00:00:00 | 5 |  | 24
L1 | 2020-01-08 00:00:00 | 1 |  | 18
L2 | 2020-01-09 00:00:00 | 15 |  | 28
L2 | 2020-01-10 00:00:00 | 18 |  | 31
L5 | 2020-01-11 00:00:00 | 22 |  | 53
L3 | 2020-01-12 00:00:00 | 9 |  | 54
L5 | 2020-01-13 00:00:00 | 1 |  | 33
[NAME] | 2020-01-14 00:00:00 | 18 |  | 41
L2 | 2020-01-15 00:00:00 | 4 |  | 33
Spreadsheet: 150993d1334753268-using-if-and-count-if-register-test
Sheet: Test

WEEK COMMENCING |  |  | 2012-04-16 00:00:00
Name | REFERENCE | MONDAY |  | TUESDAY |  | WEDNESDAY |  | THURDAY |  | FRIDAY |  | SATURDAY | SUNDAY | TOTAL SESSION      2 sessions for each half day max 14 but total days will be a max of 7 | TOTAL DAY  max of 7 (goes up in whole numbers)
 |  | AM | PM | AM | PM | AM | PM | AM | PM | AM | PM
 |  | Ws | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 5 | 3 | 5 sessions / by 2 = 2.5 but needs to show as 3 days
 |  | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 8 | 4.5 | Needs to show as 4
 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 10 | 5
 |  | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 1
 |  | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 4 | 2
 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 10 | 5
 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 10 | 5
 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 10 | 5
 |  | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 1
 |  | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 1 | 1 | 0 | 0 | 4 | 2
 |  | 1 | 1 | 0 | 0 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 8 | 4
 |  | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 1
 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 10 | 5
 |  | HS | HS | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 10 | 5
 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 0 | 0 | 0 | 0 | 8 | 4
Number of Sessions |  | 7 | 7 | 11 | 11 | 12 | 12 | 11 | 11 | 9 | 9 | 0 | 0 | 100 | 50
Number of HS Sessions |  | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 1
Number of WS  Sessions |  | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0.5
Total Sessions |  | 9 | 8 | 11 | 11 | 12 | 12 | 11 | 11 | 9 | 9 | 0 | 0 | 103 | 51.5
KEY:
0 | DOES NOT ATTEND SERVICE
1 | DOES ATTEND SERVICE
HS | Home Support - IS SUPPORTED AT HOME BY STAFF FROM DAY SERVICE
WS | [NAME], Supported by Staff out in the community,  NO support given at home or in DTS
Spreadsheet: 581920d1531589329-how-to-manually-create-own-calendar-calendar-v1
Sheet: Sheet1

 | MONTHLY TIMETABLE
 | 2018-07-01 00:00:00 | SUNDAY | MONDAY | TUESDAY | WEDNESDAY | THURSDAY | FRIDAY | SATURDAY
Spreadsheet: 855122d1704809711-search-function-that-keeps-all-data-hidden-except-what-is-being-searched-sample-customer-search
Sheet: Sheet1

ALL NAMES ARE FICTIONAL
 |  |  |  |  | First name:
First Name | Last Name | Phone Number |  | First Name | Last Name | Phone Number
Valentin | Castellano | 5551787286
Lina | [NAME] | 5551159127
Elvis | Dobbins | 5555226522
[NAME] | [NAME] | 5551222998
Elaina | Chambers | 5559919665
[NAME] | [NAME] | 5552827175
Chassidy | Reynoso | 5555228126
Brayden | [NAME] | 5557765625
Cristobal | Infante | 5555711977
Rafael | Felix | 5557721592
Kendell | [NAME] | 5559161121
Eunice | Holton | 5557721721
Charity | Jacobsen | 5555976222
Mandy | Roberson | 5551116985
[NAME] | Simons | 5551291886
Reina | Gray | 5552712999
Roderick | Thai | 5557126125
[NAME] | Garner | 5557721211
Gregorio | Corbin | 5555558612
[NAME] | Wenger | 5552729728
Kiera | Neumann | 5552281262
Kahlil | Bassett | 5557229682
Mina | Mcnabb | 5552698222
Laurel | [NAME] | 5555112855
Keshon | [NAME] | 5551772597
Spreadsheet: 740838d1626620727-calculate-countifs-across-multiple-sheets-bo-backtesting
Sheet: RESULTS

 | NOTES |  |  |  |  |  |  |  |  |  |  |  | MARKET CAP |  | Min 5 results per section
 |  |  |  |  |  |  |  |  |  |  |  |  | FLOAT
 | Entry is within 10c of BO level
 | [NAME] stop loss on losing trades is -30c |  |  |  |  |  |  |  |  |  |  |  | WIN % | 1-3M | 3-5M | 5-10M | 10-20M | 20-50M | 50-100M | 100M <
 |  |  |  |  |  |  |  |  |  |  |  |  | < 100M
 |  |  |  |  |  |  |  |  |  |  |  |  | 100-500M
 | GAIN/LOSS |  |  |  |  |  |  |  |  |  |  |  | 500M-1B
 |  |  |  |  |  |  |  |  |  |  |  |  | 1B <
 | Win/Loss %
 | Trading Days
 | Trades
 | Wins
 | Gain /s (Total) |  |  |  |  |  | WEEKLY
 | Gain /s (Total < 15) |  |  |  |  |  | WEEK | TRADES | WIN % | G/L | G/L < 15
 | Gain /s /wk (Ave) |  |  |  |  |  | 28 |  | 0.63 | 32.03 | 22.72
 |  |  |  |  |  |  | 27 |  | 0.38 | 26.51 | -1.5
 |  |  |  |  |  |  | 26 |  | 0.61 | 29.4 | 10.85
 | SETUP % |  |  |  |  |  | 25 |  | 0.5263157894736842 | 8.6 | 8.09
 |  | Trades | Traded % | Win % | G/L |  | 24 |  |  | 11.72 | 10.5
 | PMH |  |  |  |  |  | 23 |  |  | 9.39 | 3.61
 | PM Consolidation |  |  |  |  |  | 22 |  |  | 1.71 | 1.71
 | Consolidation |  |  |  |  |  | 21 |  |  | 18.51 | 17.53
 | Pivot |  |  |  |  |  | 20 |  | 0.33 | -1.14 | -1
 | HOD
 | POP
 | Daily Resistance
 | HIGHS %
 |  | Ave | Mean Ave
 | Entry-High
 | High-Close
 | ENTRY PRICE
 |  | Trades | Traded % | Win % | Ave G/L
 | < 3.00
 | 3.00-5.00
 | 5.00-7.00
 | 7.00-10.00
 | 10.00-15.00
 | 15.00-20.00
 | 20.00-25.00
 | 25.00-30.00
 | 30.00 <
 | ENTRY TIMES (WINNING TRADES)
 |  | Trades | Traded % | Ave Entry
 | 8:00-8:59
 | 9:00-9:29
 | 9:30-9:49
 | 9:50-10:29
 | 10:30-11:29
 | 11:30-14:59
Spreadsheet: stacey_white__38870__20000 11 flash report Final
Sheet: REC 

 |  |  |  |  | RECONCILIATION
 | ****  All in "Flash" signs, where negative=expense  and positive=revenue
 | UNIFY versus GL (SAP)
 |  |  |  |  | total Inter. Manuals in Unify don't need to be taken from GL manuals
 |  |  |  | ALL Data |  |  | see inter - rec | (Unify vs GL - difference)
 |  |  |  | SYSTEM | MANUALS | Reconciled by Others accounts- manual | to tie Intercompany(what's in Unify vs. what booked) | TOTALS
 |  |  | [NAME]'s file | -153980.38 | 38670069 |  | -17723497.18
 |  | -3510699.57 | SAP |  | -32629843.16 |  |  |  | took out below margin accounts from GL number (P)
 | KH's | 89253016.84
 |  |  | two inter. entries
 |  |  |  |  |  |  | Difference
 | TG's | 89422048
take out - below margin | 11 | 553 | 52506000 | Fines & Penalt |  | 0 | 11866 | 0 |  | 25 | USD |  | 5612111 | ITPS2000 | 0 | 100006789 | 3 | BATCH_AP | S
take out - below margin | 11 | 553 | 59002000 | Franchise/Annu |  | 0 | 11866 | 0 |  | 50 | USD |  | 5612111 | ITPS2000 | 0 | 100006789 | 2 | BATCH_AP | S
Spreadsheet: 865742d1712748361-new-invoice-allocation-register-test-invoice-allocation-register-emmagizer-amended-1-aligw
Sheet: Output

 | Enter Job Number here: | JN23/001
PO | PO Description | PO status | PO Value  (ex GST)
Spreadsheet: don_baughman__8636__12_05_00 EPMI IPG INDEXES
Sheet: Sheet1

HOURLY DEALS
TradersNews
Cinergy hub
Fax: [PHONE]
Phone: [PHONE]
or [PHONE]
Note:
No bal-day deals
No pre-scheduled
 | PRICE | VOLUME | TOTAL $ | TOT VOL | RUN TOT | PRICE | VOLUME | TOTAL $ | TOT VOL | RUN TOT | PRICE | VOLUME | TOTAL $ | TOT VOL | RUN TOT | PRICE | VOLUME | TOTAL $ | TOT VOL | RUN TOT | PRICE | VOLUME | TOTAL $ | TOT VOL | RUN TOT | PRICE | VOLUME | TOTAL $ | TOT VOL | RUN TOT | PRICE | VOLUME | TOTAL $ | TOT VOL | RUN TOT | PRICE | VOLUME | TOTAL $ | TOT VOL | RUN TOT | PRICE | VOLUME | TOTAL $ | TOT VOL | RUN TOT | PRICE | VOLUME | TOTAL $ | TOT VOL | RUN TOT | PRICE | VOLUME | TOTAL $ | TOT VOL | RUN TOT | PRICE | VOLUME | TOTAL $ | TOT VOL | RUN TOT | PRICE | VOLUME | TOTAL $ | TOT VOL | RUN TOT | PRICE | VOLUME | TOTAL $ | TOT VOL | RUN TOT | PRICE | VOLUME | TOTAL $ | TOT VOL | RUN TOT | PRICE | VOLUME | TOTAL $ | TOT VOL | RUN TOT | WACOP | LOW | HIGH | Location
CINERGY
PEAK
Hour Ending: | BID* | ASK*
7 | 60* | 95*
8 | 55* | 85*
9 | 50* | 80*
10 | 45* | 65* |  |  |  | 65 | 103
11 | 40* | 52* |  |  |  | 52 | 103
12 | 20* | 37* |  |  |  | 37 | 54
13 | 18* | 32*
14 | 20* | 33*
15 | 20* | 34*
16 | 18* | 35*
17 | 40* | 65*
18 | 85* | 95*
19 | 65* | 95*
20 | 70* | 100*
21 | 55* | 90* |  |  |  |  |  |  |  |  | BID | ASK
22 | 50* | 80* |  |  |  |  |  |  |  |  | 19 | 23
AEP
PEAK
Hour Ending:
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
Entergy
PEAK |  |  |  |  |  | TRADES
Hour Ending: | Bid | Ask |  |  |  | PRICE | VOL
7 | 68* | 110*
8 | 68* | 110*
9 | 65* | 100*
10 | 60* | 95*
11 | 53* | 80*
12 | 50* | 80*
13 | 35* | 75*
14 | 35* | 75*
15 | 35* | 75*
16 | 35* | 78*
17 | 30* | 75*
18 | 50* | 79*
19 | 50* | 85*
20 | 58* | 90*
21 | 52* | 84*
22 | 65* | 80*
Spreadsheet: 70636d1271345503-distance-formula-adaptation-book1
Sheet: Map 1

1,1 |  | 5,40 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 |  | 5 | 40
Home 2
X | Y |  |  | - |  |  |  |  | - |  |  |  |  | - |  |  |  |  | - |  |  |  |  | - |  |  |  |  | -
→ | ↓ | 0 | 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
 | 0
 | 1
l | 2
 | 3
 | 4
 | 5
 | 6
l | 7
 | 8
 | 9
 | 10
 | 11
l | 12
 | 13
 | 14
 | 15
 | 16
l | 17
 | 18
 | 19
 | 20
 | 21
l | 22
 | 23
 | 24
 | 25
 | 26
l | 27
 | 28
 | 29
 | 30
 | 31
l | 32
 | 33
 | 34
 | 35
 | 36
l | 37
 | 38
 | 39
 | 40
 | 41
l | 42
 | 43
 | 44
 | 45
 | 46
l | 47
 | 48
 | 49
Spreadsheet: lisa_gang__22244__EPE_MARCH_2002
Sheet: APRIL(1)

To: El Paso Marketing   -  fax # [PHONE]
El Paso Generation   -  fax # [PHONE]
 | 2002-04-01 00:00:00
HR ENDING | HR ENDING | FOUR CORNERS | PALO VERDE | PALO VERDE |  | FOUR CORNERS
Pacific | Mountain | SALE | SALE | SALE |  | PURCHASE
Standard | Standard | EPMI | PNM | PNM |  | PNM
Time | Time | 22.25
 |  | CARRY OVER FROM 3/31 | CARRY OVER FROM 3/31 | CARRY OVER FROM 3/31 |  | CARRY OVER FROM 3/31
 |  | 3/1/02-3/31/02 | 3/28/02-3/29/02 | 3/28/02-3/29/02 |  | 3/30/01-3/31/02
 |  | EPMI TAG#41760 | TEMU TAG#120W191 | WESCO TAG#58608 |  | EPMI TAG#41768 |  | TOTAL NET | NET PALO VERDE | NET FOUR CORNERS | NET EDDY
PST | MST | DIRECT BILL | DIRECT BILL | DIRECT BILL |  | DIRECT BILL
2400 | 0100 | 25 | 25 | 25 |  | -50
0100 | 0200 | 0 | 0 | 0 |  | 0
0200 | 0300 | 0 | 0 | 0 |  | 0
0300 | 0400 | 0 | 0 | 0 |  | 0
0400 | 0500 | 0 | 0 | 0 |  | 0
0500 | 0600 | 0 | 0 | 0 |  | 0
0600 | 0700 | 0 | 0 | 0 |  | 0
0700 | 0800 | 0 | 0 | 0 |  | 0
0800 | 0900 | 0 | 0 | 0 |  | 0
0900 | 1000 | 0 | 0 | 0 |  | 0
1000 | 1100 | 0 | 0 | 0 |  | 0
1100 | 1200 | 0 | 0 | 0 |  | 0
1200 | 1300 | 0 | 0 | 0 |  | 0
1300 | 1400 | 0 | 0 | 0 |  | 0
1400 | 1500 | 0 | 0 | 0 |  | 0
1500 | 1600 | 0 | 0 | 0 |  | 0
1600 | 1700 | 0 | 0 | 0 |  | 0
1700 | 1800 | 0 | 0 | 0 |  | 0
1800 | 1900 | 0 | 0 | 0 |  | 0
1900 | 2000 | 0 | 0 | 0 |  | 0
2000 | 2100 | 0 | 0 | 0 |  | 0
2100 | 2200 | 0 | 0 | 0 |  | 0
2200 | 2300 | 0 | 0 | 0 |  | 0
2300 | 2400 | 0 | 0 | 0 |  | 0
2400 | 0100 | 0 | 0 | 0 |  | 0
 | MST Total |  |  |  |  |  |  |  |  |  |  | Today's Scheduled MWh
 |  |  |  |  | TOTAL SALES |  | TOTAL PURCHASES
 | PST TOTAL
 |  | EPE(G)4C | EPE(G)PV | EPE(G)PV |  | PNM(G)4C345
 |  | EPMI | PNM | PNM |  | EPMI
 |  | AZPS(T)FC3/PPD2 | EPMI | EPMI |  | EPE
 |  | WALC(T)PPD2/COOLIDGE | NEVP | NEVP |  | EPE(T4C345/4C345
 |  | CRSP(L)COOLIDGE | PAC | PAC |  | EPE(L)4C345
 |  |  | APC | WESCO
 |  |  | TEMU | ISO(T0PVD/SP15
 |  |  | LDWP | WESCP(L)SP15
 |  |  | LDWP(T)PVD/SYLMAR/SYS
 |  |  | [NAME]
Spreadsheet: 12b9ae3c-64ef-4724-9bb6-b5abe827319c
Sheet: Sheet1

Date | Sport | Opponent | Time | Results
10/12/2014 | Rifle | TCU | 09:00 AM | W, 4712-4664
10/25/2014 | Rifle | at Akron* | 08:00 AM | W, 4695-4611
10/26/2014 | Rifle | at Ohio State | 08:00 AM | W, 4695-4652
11/08/2014 | Rifle | Memphis* | 08:00 AM
11/15/2014 | Rifle | vs. Mississippi* (West Point, N.Y.) | 08:00 AM
11/16/2014 | Rifle | at Army* | 08:00 AM
11/22/2014 | Rifle | Navy* | 08:00 AM
11/23/2014 | Rifle | [NAME]* | 08:00 AM
01/17/2015 | Rifle | Nebraska* | 08:00 AM
01/31/2015 | Rifle | at Alaska-Fairbanks | 08:00 AM
02/01/2015 | Rifle | at Alaska-Fairbanks | 08:00 AM
02/07/2015 | Rifle | at Kentucky* | 08:00 AM
02/21/2015 | Rifle | [NAME] (TBA)
02/28/2015 | Rifle | GARC Championships (Oxford, Miss.) | 08:00 AM
03/01/2015 | Rifle | GARC Championships (Oxford, Miss.) | 08:00 AM
03/13/2015 | Rifle | NCAA Championships (Fairbanks, Alaska) | 08:00 AM
03/14/2015 | Rifle | NCAA Championships (Fairbanks, Alaska) | 08:00 AM
Spreadsheet: gerald_nemec__11334__Kennedy Pmt Apdx a 9-13-01
Sheet: Kennedy

Appendix A
Kennedy Oil
July and August Payment Calculations
 |  |  | JULY |  | AUGUST |  | TOTAL
 | ACTUAL VOLUME (1) |  | 93822.51282051281 |  | 114700
 | MARKET PRICE (2) |  | 4.162939561550751 |  | 0.5
 | SUPPLY PRICE (3) |  | 2.228461712778763 |  | -0.88
 | TARIFF RATE (4) |  | 1.10968931653321 |  | 0.9369
 | PAYMENT RATIO |  | 0.25 |  | 0.25
 | TOTAL PAYMENT |  | 19345.93316004616 |  | 12705.8925 |  | 32051.82566004616
 | Payment as Calculated in Precedent Agreement:
 | Actual Volume * [(Market Price - Supply Price) - Tariff Rate] * Payment Ratio
 | (1) Actual volumes for July based on an 81.8% flow rate on 3,700 a day volume.
 | August assumes 100% flows.
 | (2) August market price based on SoCal basis of $1.92 and index of ($1.42)
 | (3) August supply price based on Rockies basis of ($[NAME]) and index of $.08
 | (4) Total estimated July tariffs of $104,114 versus total estimated August tariffs of $107,481.
 | Per unit total tariff is lower for July due to lower volume.