tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 72707d1273433178-help-with-an-excel-lookup-forumula-that-returns-column-heading-student_presentations
Sheet: Presenter 6

Seats | Presenter 6 Time Slot 1 | Presenter 6 Time Slot 2 | Presenter 6 Time Slot 3 | Presenter 6 Time Slot 4 | Presenter 6 Time Slot 5 | Presenter 6 Time Slot 6 | Presenter 6 Time Slot 7 | Presenter 5 Time Slot 8
1 | Student 44 | Student 42 |  |  | Student 41 |  | Student 12
2 |  | Student 43
3
4
5
6
7
8
9
10
11
12
13
14
15
Spreadsheet: 714624d1611311378-how-to-add-multiple-columns-based-on-criteria-in-rows-sum-columns-based-on-crieteria-on-rows
Sheet: Sheet2

 | Destination | Sales R | Product | Wk-1 | Wk-2 | Wk-3 | Wk-4 | Wk-5 | Wk-6 | Wk-7 | Wk-8 | Wk-9 | Wk-10
 | US | All | Course | 151 | 138 | 135 | 198 | 104 | 103 | 178 | 198 | 152 | 106
 | Canada | Asia | Accommodation | 124 | 185 | 187 | 185 | 194 | 171 | 168 | 122 | 121 | 123
 | US | [NAME] | Course | 198 | 146 | 164 | 140 | 161 | 199 | 171 | 123 | 105 | 126
 | Canada | All | Course | 160 | 171 | 169 | 148 | 178 | 139 | 107 | 191 | 196 | 200
 | UK | Asia | Accommodation | 149 | 176 | 139 | 109 | 150 | 181 | 112 | 131 | 155 | 135
 |  |  | From Week | Wk-3
 |  |  | To Week | Wk-10
 |  |  | Destination | US
 |  |  | Sales R | [NAME]
 |  |  | Product | Course
 |  |  | Sum
 |  |  | In the above I just created a total for week 3 to week 10 for just the figures at row 7.  I want my formula to give me the sum in the yellow highlighted cells
 |  |  | based on the ctriteria in green above
Spreadsheet: 107170d1304395856-question-on-exact-formulae-of-numbers-in-linest-array-question_on_linest
Sheet: Linest

X | Y |  |  | LINEST ARRAY
2 | 2.3 |  | slope |  | -3.328571428571431 | intercept
3 | 4.5 |  | ± | 0.08499699874653442 | 0.4091055449865911 | ±
4 | 6.7 |  | r2 | 0.9958350001176554 | 0.3555679561329614 | [NAME])
5 | 9.8 |  | F | 956.3841807909596 | 4 | degree of freedom
6 | 12.3 |  | regression ss | 120.9142857142857 | 0.5057142857142862 | residual ss
7 | 15.4
 | Hi,  I got this example from the web. I know that the slope (E2) and the intercept  (F2) are calculated by least square regression. The article where this example is from gives the formulae for r2 (E4), regression ss (E6) and residual ss (F6). So totally I know how 5 of the 10 numbers are calculated. Can any one tell me the formulae how E3, F3 and F4 are calculated? Thanks a lot.
Spreadsheet: 6ed30c5c-1664-43bb-b11c-a27c54fb4a22
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
PACP | Test | PACP | Prostatic Acid Phosphatase (PAP), Serum | Prostatic Acid Phosphatase, S | Automated Chemiluminescent Immunometric Assay | Serum Gel Tube: SGT |  |  | 1 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 1 mL | 0.4 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | < or =2.1 ng/mL | Monday through Friday; 5 a.m.-12 a.m., Saturday; 6 a.m.-6 p.m. | Same day/1 day | 3 days | 1 | 84066 |  |  |  |  | Rochester
PACP | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 7 days
PACP | Result | PACP | Prostatic Acid Phosphatase, S | Prostatic Acid Phosphatase, S | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | 20420-6 | Acid phosphatase.prostatic:MCnc:Pt:Ser:Qn:
Spreadsheet: 269326d1381124939-vlookup-horizontal-to-vertical-dingdang
Sheet: Sheet1

2013-07-05 00:00:00 | 2013-07-06 00:00:00 | 2013-07-07 00:00:00 | 2013-07-08 00:00:00 | 2013-07-09 00:00:00 | 2013-07-10 00:00:00 | 2013-07-11 00:00:00 | 2013-07-12 00:00:00 | 2013-07-13 00:00:00 | 2013-07-15 00:00:00 | 2013-07-16 00:00:00 | 2013-07-17 00:00:00 | 2013-07-18 00:00:00
60.32 | 60.17 | 60.06 | 59.95 | 59.94 | 59.91 | 59.86 | 59.9 | 59.79 | 59.72 | 59.63 | 59.65 | 59.64
Date | Values (Option1) | Values (Option2) | Values (Option3)
2013-07-05 00:00:00
2013-07-06 00:00:00
2013-07-07 00:00:00
2013-07-08 00:00:00
2013-07-09 00:00:00
2013-07-10 00:00:00
2013-07-11 00:00:00
2013-07-12 00:00:00
2013-07-13 00:00:00
2013-07-15 00:00:00
2013-07-16 00:00:00
2013-07-17 00:00:00
2013-07-18 00:00:00
Spreadsheet: 794032d1661855841-modelling-working-capital-monthly-model-working-capital-2-
Sheet: Sheet 2

 |  | WORKING CAPITAL |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
1 |  | REVENUE
 |  | Total
 |  | Revenue 1 |  | 1000
 |  | Revenue 2 |  | 2000
 |  | Revenue 3 |  | 3000
 |  | Revenue 4 |  | 4000
 |  | Revenue 5 |  | 5000
 |  | % Payment per Period (Revenue 1) |  | 0.6 | 0.25 | 0.1 | 0.05 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | % Payment per Period (Revenue 2) |  | 0.7 | 0.2 | 0.05 | 0.05 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | % Payment per Period (Revenue 3) |  | 0.8 | 0.1 | 0.1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | % Payment per Period (Revenue 4) |  | 0.9 | 0.05 | 0.05 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | % Payment per Period (Revenue 5) |  | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2 |  | CASH PAYMENTS
 |  | Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
 |  | 2 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 3 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 4 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 5 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 6 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 7 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 8 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 9 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 10 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 11 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | 12 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 335733d1406689341-countif-involving-criteria-from-2-different-columns-bethsweddingguestlist
Sheet: RSVP Reception

 |  |  | Wedding Reception Guest List
WEDDING DATE
 |  |  | Guest Name | Sent | [NAME] | Party | Side | Relation | Address | City | State | Zip | Phone | Contact Email | Wine | Song
 |  |  | [NAME] | No |  |  | Bride | Brother | 4555 Some Road | Someplace | KS | 55555 | (123) 456-7890 | [EMAIL]
DAYS REMAINING |  |  | Guest 2 | No
 |  |  | Guest 3 | No
 |  |  | Guest 4 | No
INVITES SENT |  |  | Guest 5 | No
 |  |  | Guest 6 | No
 |  |  | Guest 7 | No
ATTENDING |  |  | Guest 8 | No
 |  |  | Guest 9 | No
 |  |  | Guest  10 | No
TOTAL IN PARTY |  |  | Guest 11 | No
NOT ATTENDING
[NAME]
Spreadsheet: 118489d1313726935-group-picker-improvement-fix-needed-grouppicker-jvr-4-and-5-4-and-3
Sheet: 4Matrix

[NAME]
Students | 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 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40
Foursomes | 0 | 1 | 2 | 0 | 1 | 2 | 3 | 1 | 2 | 3 | 4 | 2 | 3 | 4 | 5 | 3 | 4 | 5 | 6 | 4 | 5 | 6 | 7 | 5 | 6 | 7 | 8 | 6 | 7 | 8 | 8 | 7 | 8 | 8 | 8
Threesomes | 2 | 1 | 0 | 3 | 2 | 1 | 0 | 3 | 2 | 1 | 0 | 3 | 2 | 1 | 0 | 3 | 2 | 1 | 0 | 3 | 2 | 1 | 0 | 3 | 2 | 1 | 0 | 3 | 2 | 1 | 0 | 3 | 2 | 1 | 0
Students | 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 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40
 | 3 | 4 | 4 | 3 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4
 | 3 | 3 | 4 | 3 | 3 | 4 | 4 | 3 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4
 |  |  |  | 3 | 3 | 3 | 4 | 3 | 3 | 4 | 4 | 3 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4
 |  |  |  |  |  |  |  | 3 | 3 | 3 | 4 | 3 | 3 | 4 | 4 | 3 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4
 |  |  |  |  |  |  |  |  |  |  |  | 3 | 3 | 3 | 4 | 3 | 3 | 4 | 4 | 3 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 3 | 3 | 4 | 3 | 3 | 4 | 4 | 3 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 3 | 3 | 4 | 3 | 3 | 4 | 4 | 3 | 4 | 4 | 4 | 4 | 4 | 4 | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 3 | 3 | 4 | 3 | 3 | 4 | 4 | 3 | 4 | 4 | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 3 | 3 | 4 | 3 | 3 | 4 | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 3 | 3 | 4
Spreadsheet: 887631d1737903692-lost-in-a-challenging-formula-challenge-costs-with-revenue-word
Sheet: Identifier

 |  |  | Identifier | contract type | Costs
 |  |  | SE.100 | open book revenue | direct cost
 |  |  | SE.101 | lumpsum | indirect cost
 |  |  | SE.102 | open book revenue | indirect cost
 |  |  | SE.103 | open book revenue | indirect cost
 |  |  | SE.104 | lumpsum | indirect cost
 |  |  | SE.105 | lumpsum | direct cost
 |  |  | SE.106 | lumpsum | direct cost
 |  |  | SE.107 | open book revenue | direct cost
 |  |  | [NAME] | open book revenue | direct cost
Spreadsheet: 877042d1723724173-unequal-rows-together-in-excel-add
Sheet: Sheet1

cod | name | sales
3222 | benz | 18051 | 11 row
3222 | benz | 11024
3222 | benz | 13950
3222 | benz | 9774
3222 | benz | 499
3222 | benz | 2870
3222 | benz | 2785
3222 | benz | 5869
3222 | benz | 3833
3222 | benz | 5529
3222 | benz | 2004
total
64425 | bmw | 524185 | 13 row
64425 | bmw | 238597
64425 | bmw | 195618
64425 | bmw | 66463
64425 | bmw | 50211
64425 | bmw | 122789
64425 | bmw | 86433
64425 | bmw | 31304
64425 | bmw | 17396
64425 | bmw | 51245
64425 | bmw | 46980
64425 | bmw | 1265
64425 | bmw | 9651
total
1923 | [NAME] | 225589 | 7 row
1923 | [NAME] | 38938
1923 | [NAME] | 137206
1923 | [NAME] | 11979
1923 | [NAME] | 4685
1923 | [NAME] | 4119
1923 | [NAME] | 794
total
Spreadsheet: 862475d1710194636-sumproduct-property-tax-calculations-property-tax-calculator
Sheet: Sheet1

Stamp Duty Calculations
Purchase Price | 1100000 | Property purchase price
Breakdown
Band start | Band end | 1st home rate | Marginal Rate | 2nd home rate | Marginal Rate |  |  | Amount in band | 1st home stamp duty | 2nd home stamp duty
0 | 145000 | 0 | 0 | 0.06 | 0.06
145000 | 250000 | 0.02 |  | 0.08
250000 | 325000 | 0.05 |  | 0.11
325000 | 750000 | 0.1 |  | 0.16
750000 |  | 0.12 |  | 0.18
Total Stamp Duty
Single cell formula
 | 1st home | 2nd home
Total Stamp Duty
LAMBDA function
Spreadsheet: 724179d1616053617-how-to-pull-all-rows-of-data-where-specific-value-is-found-in-a-column-exampleexcelsheet
Sheet: Mike

Name | Color | Food | Book | Home | Goal | Assigned To:
Spreadsheet: 129891d1321964208-return-row-of-max-value-of-a-category-forum
Sheet: Sheet2

 | Customer | Item | amount |  | Customer | Item | amount
 | AAA | A | 20 |  | AAA
 | AAA | B | 31 |  | BBB
 | BBB | C | 10 |  | CCC
 | CCC | D | 22 |  | DDD
 | DDD | E | 66
 | DDD | F | 44
 | DDD | G | 97
 | BBB | H | 16
Spreadsheet: 817299d1676106287-negative-amount-and-summation-issue-2023-commission-for-designers-sample-ans
Sheet: Abby

ABBY | January | February | March | April | May | June | July | August | September | October | November | December |  | Sales | Bonus | Class
Sales Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Custom
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Custom
Subtotal |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Custom
Damage and Loss |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Custom
D&L Allowed |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Custom
Sub Allowed |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Custom
Open Inv - 120 D |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Custom
Bonus Expectation |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Custom
Bonus Total |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Custom
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Custom
 | ` |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Custom
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Custom
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Custom
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Custom
 | `
Spreadsheet: andy_zipper__177__DYNEGY-ICE VOL Apr25
Sheet: ICE-ECC

Enron Canada Corporation
Activity on ICE
UOM | Deals | Volume
 |  |  |  |  |  |  | START | END
Enron Canada Corp.
Commodity Type:  All
Instruments:  All
Trade Dates:  Apr-25-01 thru Apr-25-01
Trade Date | Deal ID | Leg ID | B/S | Product | Hub | Strip | START | END | Option | Strike | Style | Counterparty | Price | Price Units | Qty Per Period | Periods | Total Quantity | Qty Units | Trader
Spreadsheet: 887031d1737119258-can-excel-produce-list-of-items-when-you-punch-in-a-value-and-doesnt-duplicate-example-data
Sheet: INPUT AND OUTPUT

BAD OUTPUT |  |  |  |  |  | CORRECT OUTPUT
CODE | CP0754 |  |  |  |  | CODE | CP0754 |  |  |  |  | DATA SHEET SNIP
START DATE | 2022-01-17 00:00:00 | default (last 3 years) |  |  |  | START DATE | 2022-01-17 00:00:00 | default (last 3 years), edit for precise date range
END DATE | 2025-01-17 00:00:00 | default (last 3 years) |  |  |  | END DATE | 2025-01-17 00:00:00 | default (last 3 years), edit for precise date range
LAST 3 MONTHS | LAST 6 MONTHS | LAST 1 YEAR | Buttons for easy search/filter |  |  | LAST 3 MONTHS | LAST 6 MONTHS | LAST 1 YEAR | Buttons for easy search/filter
QLD | NSW | VIC |  |  |  | QLD | NSW | VIC
TAS | WA | NT |  |  |  | TAS | WA | NT
 |  | TOTAL SOLD |  | SUM OF WHAT IS LISTED |  |  |  | TOTAL SOLD |  | SUM OF WHAT IS LISTED
CODE | COLOURWAY | TOTAL UNITS SOLD (within the date range and/or state selected) | ORDERS PLACED (within the date range and/or state selected) |  |  | CODE | COLOURWAY | TOTAL UNITS SOLD (within the date range and/or state selected) | ORDERS PLACED (within the date range and/or state selected)
 |  |  |  |  |  | CP0754 | Gold | 352
 |  |  |  |  |  | CP0754 | Red | 460
 |  |  |  |  |  | CP0754 | Green | 205
 |  |  |  |  |  | CP0754 | Yellow | 199
Spreadsheet: 166438d1341585210-replicate-the-insert-rows-action-in-a-second-worksheet-automatically-book1example
Sheet: Sheet2

Place Name | Date
End
Spreadsheet: 879586d1727174823-points-table-to-show-total-points-scored-for-all-events-per-person-sports-carnival_2024
Sheet: Sheet1

 | Year 3 |  |  |  |  | Sawyers Valley Sports Day 13th September
 |  | Events | Cross Country | 400m | 200m A Division | 200m B Division | Triple  Jump | Long Jump | Throws | 75m A Division | 75m B Division | [NAME] | [NAME] | [NAME] | [NAME] Relay [NAME]m | Total Pts |  | Points Table |  |  |  |  |  | Overall Champion Girl & Boy
 | Students |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Events | 1st | 2nd | 3rd | 4th |  | Year 3 | Winner | Points
 | [NAME] | Position Finished | 3 |  |  | 1 |  |  | 3 |  | 1 | 1 | 1 | 1 | 1 |  |  | Cross Country | 5 | 3 | 2 | 1 |  | Champian Girl
 | [NAME] | Position Finished | 4 |  |  |  |  | 2 | 1 | 2 |  | 1 | 2 | 2 | 1 |  |  | 400m | 5 | 3 | 2 | 1 |  | Champion Boy | [NAME] | 53
 | [NAME] | Position Finished |  |  |  | 3 |  |  |  | 3 |  | 3 | 3 | 3 | 3 |  |  | 200m A Division | 5 | 3 | 2 | 1
 | [NAME] | Position Finished |  |  | 1 |  |  | 4 |  |  |  |  |  |  |  |  |  | 200m B Division | 5 | 3 | 2 | 1
 | [NAME] | Position Finished | 2 |  |  | 2 |  |  |  | 4 |  | 2 | 2 | 2 | 2 |  |  | Triple Jump | 5 | 3 | 2 | 1
 | [NAME] | Position Finished |  |  | 3 |  |  |  | 4 |  | 2 | 4 | 4 | 4 | 4 |  |  | Long Jump | 5 | 3 | 2 | 1
 | [NAME] | Position Finished |  |  | 2 |  |  | 1 |  | 1 |  | 1 | 1 | 1 | 1 |  |  | Throws | 5 | 3 | 2 | 1
 | [NAME] | Position Finished |  |  | 4 |  |  |  | 2 |  | 3 | 3 | 3 | 2 | 2 |  |  | 75m A Division | 5 | 3 | 2 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 75m B Division | 5 | 3 | 2 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 10 | 6 | 4 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 10 | 6 | 4 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 10 | 6 | 4 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] Relay [NAME]m | 10 | 6 | 4 | 2
 | Year 3 Boys
Spreadsheet: 675130d1588171506-extracting-and-ordering-data-from-a-list-badger-large-fb
Sheet: Milton games

Date | Opponent | at | Home/Host | at | Location | , | Time | Conf/Non
2020-08-21 00:00:00 | Milton | at | Fort Atkinson |  |  | , | 7 p.m. | (non-conference)
2020-08-28 00:00:00 | Lake Geneva Badger | at | Milton |  |  | , | 7 p.m. | (non-conference)
2020-09-04 00:00:00 | [NAME] | at | Milton |  |  | , | 7 p.m.
2020-09-11 00:00:00 | Milton | at | [NAME] |  |  | , | 7 p.m.
2020-09-18 00:00:00 | Milton | vs. | [NAME] | at | Monterey Stadium, Janesville | , | 7 p.m.
2020-09-25 00:00:00 | Watertown | at | Milton |  |  | , | 7 p.m.
2020-10-02 00:00:00 | Milton | at | DeForest |  |  | , | 7 p.m.
2020-10-09 00:00:00 | Oregon | at | Milton |  |  | , | 7 p.m.
2020-10-16 00:00:00 | Milton | vs. | [NAME] | at | Monterey Stadium, Janesville | , | 7 p.m.
Spreadsheet: phillip_m_love__30516__BLANKBOOKREQUEST
Sheet: Sheet1

From: | Risk Management -Controls
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 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] | PHY | Commodity/UOM/Curr | [NAME] | MTM/ACCRUAL | Reason for Book | Date Needed By | Administrator* | MTM | Prud | Realized
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 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
 | A unique portfolio/book code will be assigned to your book unless you request a specific portfolio/book code.
 | BOOK CANNOT BE SET UP IF THERE IS ANY MISSING INFORMATION.
 | Please provide a list of the people who need access to the above book(s).
 | ***'Please provide login names for book administrators.***
 | Access List:
 | trohaue (needs to have access to all books)
 |  |  | RisktRAC Check list |  | Added (y/n) | Processors ID
 | [NAME]
 | [NAME] |  | Created in RisktRAC
 | [NAME] |  | hierarchy
 | [NAME] |  | Master booklist
 | Any questions, please contact me |  | Sent to GCP
 |  |  | Sent to TAGG/ERMS
 | (x31462) |  | Active/Inactive Book List
Spreadsheet: 871386d1717766264-copy-multiple-rows-by-criteria-from-multiple-sheets-doable-mockup
Sheet: Overview

 |  |  | Start Date | End Date
 |  |  | 2024-10-01 00:00:00 | 2024-10-19 00:00:00 | [NAME] dates here
2024-10-01 00:00:00 | Account1 – Booking1
2024-10-02 00:00:00 | Account1 – Booking2
2024-10-03 00:00:00 | Account1 – Booking3
2024-10-04 00:00:00 | Account1 – Booking4
2024-10-05 00:00:00 | Account1 – Booking5
2024-10-10 00:00:00 | Account2 – Booking1
2024-10-11 00:00:00 | Account2 – Booking2
2024-10-12 00:00:00 | Account2 – Booking3
2024-10-13 00:00:00 | Account2 – Booking4
2024-10-14 00:00:00 | Account2 – Booking5
2024-10-15 00:00:00 | Account3 – Booking1
2024-10-16 00:00:00 | Account3 – Booking2
2024-10-17 00:00:00 | Account3 – Booking3
2024-10-18 00:00:00 | Account3 – Booking4
2024-10-19 00:00:00 | Account3 – Booking5
Spreadsheet: 145182d1331354333-data-validation-help-march-madness-bracket
Sheet: Sheet1

 |  |  |  |  |  |  | March Madness 2012
 | First Round | Second Round | Sweet Sixteen | Elite Eight | Final Four |  | Finals |  | Final Four | Elite Eight | Sweet Sixteen | 2nd Round | 1st Round
 | March 15-16 | March 17-18 | March 22-23 | March 24-25 | March 31 |  | April 2 |  | March 31 | March 24-25 | March 22-23 | March 17-18 | March 15-16
 |  |  |  |  |  |  | Points Per Round
 | 1 | 2 | 3 | 4 | 6 |  | 8 |  | 6 | 4 | 3 | 2 | 1
1 | Team 1 |  |  |  |  |  |  |  |  |  |  |  | Team1 | 1
16 | Team 16 |  |  |  |  |  |  |  |  |  |  |  | Team 16 | 16
8 | Team 8 |  |  |  |  |  |  |  |  |  |  |  | Team 8 | 8
9 | Team 9 |  |  |  |  |  |  |  |  |  |  |  | Team 9 | 9
5 | Team 5 |  |  |  |  |  |  |  |  |  |  |  | Team 5 | 5
12 | Team 12 |  |  |  |  |  |  |  |  |  |  |  | Team 12 | 12
 |  |  |  |  |  |  | Name
4 | Team 4 |  |  |  |  |  |  |  |  |  |  |  | Team 4 | 4
13 | Team 13 |  |  |  |  |  |  |  |  |  |  |  | Team 13 | 13
6 | Team 6 |  |  |  |  |  |  |  |  |  |  |  | Team 6 | 6
11 | Team 11 |  |  |  |  |  |  |  |  |  |  |  | Team 11 | 11
3 | Team 3 |  |  |  |  |  |  |  |  |  |  |  | Team 3 | 3
14 | Team 14 |  |  |  |  |  |  |  |  |  |  |  | Team 14 | 14
7 | Team 7 |  |  |  |  |  |  |  |  |  |  |  | Team 7 | 7
10 | Team 10 |  |  |  |  |  |  |  |  |  |  |  | Team 10 | 10
2 | Team 2 |  |  |  |  |  |  |  |  |  |  |  | Team 2 | 2
15 | Team 15 |  |  |  |  |  | National Champion |  |  |  |  |  | Team 15 | 15
1 | Team1 |  |  |  |  |  |  |  |  |  |  |  | Team1 | 1
16 | Team 16 |  |  |  |  |  |  |  |  |  |  |  | Team 16 | 16
8 | Team 8 |  |  |  |  |  |  |  |  |  |  |  | Team 8 | 8
9 | Team 9 |  |  |  |  |  |  |  |  |  |  |  | Team 9 | 9
5 | Team 5 |  |  |  |  |  |  |  |  |  |  |  | Team 5 | 5
12 | Team 12 |  |  |  |  |  | Total Score of Championship Game |  |  |  |  |  | Team 12 | 12
4 | Team 4 |  |  |  |  |  |  |  |  |  |  |  | Team 4 | 4
13 | Team 13 |  |  |  |  |  |  |  |  |  |  |  | Team 13 | 13
6 | Team 6 |  |  |  |  |  |  |  |  |  |  |  | Team 6 | 6
11 | Team 11 |  |  |  |  |  |  |  |  |  |  |  | Team 11 | 11
3 | Team 3 |  |  |  |  |  |  |  |  |  |  |  | Team 3 | 3
14 | Team 14 |  |  |  |  |  |  |  |  |  |  |  | Team 14 | 14
7 | Team 7 |  |  |  |  |  |  |  |  |  |  |  | Team 7 | 7
10 | Team 10 |  |  |  |  |  |  |  |  |  |  |  | Team 10 | 10
2 | Team 2 |  |  |  |  |  |  |  |  |  |  |  | Team 2 | 2
15 | Team 15 |  |  |  |  |  |  |  |  |  |  |  | Team 15 | 15
 |  |  |  |  |  |  | First Four
 |  |  |  | Play In Team 1 |  | Play In Team 3 |  | Play In Team 5 |  | Play In Team 7
 |  |  |  | Play In Team 2 |  | Play In Team 4 |  | Play In Team 6 |  | Play In Team 8
Spreadsheet: 3f190b49-f3c1-4ce6-a860-fed9c2e0a7bd
Sheet: 15a

Product1 | Cleared2 | Uncleared | TOTAL
Index Tranche | - | 481 | 481
Index | 232002 | 62636 | 294638
Europe | 121031 | 25106 | 146137
North America/Asia | 109448 | 35309 | 144757
Other | 1523 | 2221 | 3744
OTHER* | 3878 | 5718 | 9596
TOTAL | 235880 | 68835 | 304715
*OTHER variable includes exotic credit products, swaptions, and total return swaps.
Spreadsheet: 118980d1314119395-if-statements-to-count-values-within-selected-hours-days-months-of-a-year-poweroutputreport
Sheet: Pivot Reports

Window 1
Month | (Multiple Items) | ([NAME])
Hour | (Multiple Items) | (11-21)
Day of Week | (Multiple Items) | (Mon-Fri)
Sum of  Net Output
77569.33007025934
Window 2
Month | (Multiple Items) | ([NAME])
Hour | (Multiple Items) | (NOT 11-21)
Day | (All) | (Mon-Sun)
Sum of  Net Output
134473.5892930075
Window 3
Month | (Multiple Items) | (NOTJun-Sep)
Hour | (Multiple Items) | (8-21)
Day of Week | (Multiple Items) | (Mon-Fri)
Sum of  Net Output
228099.3284789271
Window 4
Month | (Multiple Items) | (NOTJun-Sep)
Hour | (Multiple Items) | (NOT 8-21)
Sum of  Net Output
251670.2157158119
Spreadsheet: daren_farmer__5940__EI305reveff061000_2
Sheet: Sheet1

To:   [NAME]          (Enron)
From: [NAME] ([NAME])
Date:  6/09/00
Subject:  Revised Availabilities Effective 6/10/00
Effective Date | CTP NAME | Gross Vol. (MMBtu/d) | PVR % | PVR Volume | Avail. After PVR (MMBtu/d) | DBQ | Excess
2000-06-10 00:00:00 | EI 305 | 3800 | 0 |  |  | 3280
1st of month DBQ = 3280/d
This change supersedes the previos change sent effective 6/10/00.  The Sea Robin Plant will
shut down Monday, June 12, 2000 at 9:00 a.m. for repairs and maintenance.  The plant should
be back up on Thursday, June 15, 2000.