tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: ea3d8d8e-46f6-440d-b01c-f40e63d065a6
Sheet: Doubles C

 | DOUBLES | FLIGHT "C"
 |  |  | Leelavanich/De Vries (BU)
 |  |  |  | Boston
 |  |  | BYE
 |  |  | Cohen/Goldstein (UC) |  | Leelavanich/ De Vries (BU)
 |  |  |  |  | 83
 |  |  |  | Cohen/Goldstein (UC)
 |  |  | Bogdanovich/ Budrawich (SH) | 83
 |  |  |  |  |  | Ezaka/Haraguchi (QU)
 |  |  | [NAME] (Bry) |  |  | 85
 |  |  |  | Teran/Cepeda (BU)
 |  |  | Teran/Cepeda (BU) | 84
 |  |  | Montes/Max (Hart) |  | Ezaka/Haraguchi (QU)
 |  |  |  |  | 82
 |  |  |  | Ezaka/Haraguchi (QU)
 |  |  | Ezaka/Haraguchi (QU) | 82
 |  |  | Saturday 9:00am | Saturday | Saturday
 |  |  | UCONN | UCONN | UCONN
 |  |  | Quarter Finals | Semi Finals | Finals
Spreadsheet: 779090d1651583817-sum-datas-by-date-across-different-sheets-sample
Sheet: December

Date | Sales
2022-12-01 00:00:00 | 1
2022-12-02 00:00:00 | 1
2022-12-03 00:00:00 | 1
2022-12-04 00:00:00 | 1
2022-12-05 00:00:00 | 1
2022-12-06 00:00:00 | 1
2022-12-07 00:00:00 | 1
2022-12-08 00:00:00 | 1
2022-12-09 00:00:00 | 1
2022-12-10 00:00:00 | 1
2022-12-11 00:00:00 | 1
2022-12-12 00:00:00 | 1
2022-12-13 00:00:00 | 1
2022-12-14 00:00:00 | 1
2022-12-15 00:00:00 | 1
2022-12-16 00:00:00 | 1
2022-12-17 00:00:00 | 1
2022-12-18 00:00:00 | 1
2022-12-19 00:00:00 | 1
2022-12-20 00:00:00 | 1
2022-12-21 00:00:00 | 1
2022-12-22 00:00:00 | 1
2022-12-23 00:00:00 | 1
2022-12-24 00:00:00 | 1
2022-12-25 00:00:00 | 1
2022-12-26 00:00:00 | 1
2022-12-27 00:00:00 | 1
2022-12-28 00:00:00 | 1
2022-12-29 00:00:00 | 1
2022-12-30 00:00:00 | 1
2022-12-31 00:00:00 | 1
Spreadsheet: 802722d1666986791-index-match-return-result-which-formula-among-the-combination-is-satisfied-mpf_work_help
Sheet: Sheet2

SKU | price | mpf | slab id |  |  |  |  | slab id | primary slab | slab rate | overall rate | mpf
AA | 223.53 | 32.35 |  |  |  |  |  | 1 | 100 | 8 | 10
AB | 254.07 | 35.41 |  |  |  |  |  |  | 100 | 8 | 12
AC | 301.06 | 40.11 |  |  |  |  |  |  | 100 | 8 | 15
AD | 769.99 | 82.6 |  |  |  |  |  |  | 100 | 10 | 8
AE | 119.63 | 16.57 |  |  |  |  |  |  | 100 | 10 | 12
AF | 260 | 36 |  |  |  |  |  |  | 100 | 10 | 15
AG | 239 | 33.9 |  |  |  |  |  |  | 100 | 12 | 8
AH | 419 | 54.52 |  |  |  |  |  |  | 100 | 12 | 10
AI | 387 | 51.96 |  |  |  |  |  |  | 100 | 12 | 15
AJ | 360 | 49.8 |  |  |  |  |  |  | 100 | 15 | 8
AK | 482.08 | 59.57 |  |  |  |  |  |  | 100 | 15 | 10
AL | 396.39 | 52.71 |  |  |  |  |  |  | 100 | 15 | 12
AM | 618.3 | 70.46 |  |  |  |  |  |  | 200 | 8 | 10
AN | 211.27 | 31.13 |  |  |  |  |  |  | 200 | 8 | 12
 |  |  |  |  |  |  |  |  | 200 | 8 | 15
 |  |  |  |  |  |  |  |  | 200 | 10 | 8
 |  |  |  |  |  |  |  |  | 200 | 10 | 12
 |  |  |  |  |  |  |  |  | 200 | 10 | 15
 |  |  |  |  |  |  |  |  | 200 | 12 | 8
 |  |  |  |  |  |  |  |  | 200 | 12 | 10
 |  |  |  |  |  |  |  |  | 200 | 12 | 15
 |  |  |  |  |  |  |  |  | 200 | 15 | 8
 |  |  |  |  |  |  |  |  | 200 | 15 | 10
 |  |  |  |  |  |  |  |  | 200 | 15 | 12
 |  |  |  |  |  |  |  |  | 300 | 8 | 10
 |  |  |  |  |  |  |  |  | 300 | 8 | 12
 |  |  |  |  |  |  |  |  | 300 | 8 | 15
 |  |  |  |  |  |  |  |  | 300 | 10 | 8
 |  |  |  |  |  |  |  |  | 300 | 10 | 12
 |  |  |  |  |  |  |  |  | 300 | 10 | 15
 |  |  |  |  |  |  |  |  | 300 | 12 | 8
 |  |  |  |  |  |  |  |  | 300 | 12 | 10
 |  |  |  |  |  |  |  |  | 300 | 12 | 15
 |  |  |  |  |  |  |  |  | 300 | 15 | 8
 |  |  |  |  |  |  |  |  | 300 | 15 | 10
 |  |  |  |  |  |  |  |  | 300 | 15 | 12
 |  |  |  |  |  |  |  |  | 0 | 8 | 0
 |  |  |  |  |  |  |  |  | 0 | 10 | 0
 |  |  |  |  |  |  |  |  | 0 | 12 | 0
 |  |  |  |  |  |  |  |  | 0 | 15 | 0
 |  |  |  |  |  |  |  |  | 0 | 16 | 0
 |  |  |  |  |  |  |  |  | 0 | 17 | 0
 |  |  |  |  |  |  |  |  | 0 | 20 | 0
Spreadsheet: 781613d1653443790-amend-dates-in-respective-cells-when-a-certain-date-is-reached-and-recycle-monthly-dajmcnn_example
Sheet: Sheet2

 | Today |  |  |  |  |  | Target date | diff
 | Wanted Date number (only date number 1 to 31)
 | Day Num | Date | Description | Amt
 | 1
 | 1
 | 2
 | 11
 | 11
 | 18
 | 19
 | 20
 | 21
 | 22
 | 23
 | 24
 | 25
 | 26
 | 27
 | 28
 | 29
 | 30
 | 31
Spreadsheet: 774071d1648203408-formula-to-change-the-score-according-to-multiple-variants-andry79-aligw
Sheet: Sheet1

 |  | Situation | sub score |  |  | Score
 |  | a | 0.02 |  |  |  |  | High
 |  | b | 0.04
 |  | Classification | score adjustment | revised score
 |  | Prohibited | 2 | 8
 |  | Very High | 2 | 8
 |  | High | 1 | 7
 |  | Medium | 0 | 6
 |  | Low | -2 | 4
 |  | Condition: based on the different classification (prohibited, Very high,high,medium and low) the Score of 6  will change according to the score adjustment e.g if high, the score will be 7 (6+1), if low the score will be 4 (6-2) etc.
Spreadsheet: 667281d1584153963-how-can-i-create-sequential-number-with-in-between-numbers-period-between-counting-digits-2
Sheet: Sheet2

ABCD_ | 0
ABCD_ | 1
ABCD_ | 2
ABCD_ | 3
ABCD_ | 4
ABCD_ | 5
ABCD_ | 6
ABCD_ | 7
ABCD_ | 8
ABCD_ | 9
ABCD_ | 10
ABCD_ | 11
ABCD_ | 12
ABCD_ | 13
ABCD_ | 14
ABCD_ | 15
ABCD_ | 16
ABCD_ | 17
ABCD_ | 18
ABCD_ | 19
ABCD_ | 20
ABCD_ | 21
ABCD_ | 22
ABCD_ | 23
ABCD_ | 24
ABCD_ | 25
ABCD_ | 26
Spreadsheet: 688822d1595970305-small-function-based-on-one-criteria-2020-07-28-oeldere-rachste-688777d1595952128-small-function-based-on-one-criteria-excelform-
Sheet: 688777d1595952128-small-functio

Name | Count |  | Name | Location | Moderator Count | Scribe Count
Manager 11 | 0 |  | Manager 8 | [NAME] | 6 | 4
#[NAME]! | 0 |  | Manager 4 | [NAME] | 6 | 4
#[NAME]! | 0 |  | Manager 3 | [NAME] | 6 | 4
#[NAME]! | 0 |  | Manager 2 | [NAME] | 6 | 2
#[NAME]! | 0 |  | Manager 1 | [NAME] | 6 | 2
#[NAME]! | 0 |  | Manager 16 | [NAME] | 5 | 5
#[NAME]! | 0 |  | Manager 6 | [NAME] | 4 | 4
Manager 9 | 2 |  | Manager 17 | [NAME] | 4 | 6
Manager 20 | 3 |  | Manager 14 | [NAME] | 4 | 7
Manager 6 | 4 |  | Manager 13 | [NAME] | 4 | 6
Manager 10 | 4 |  | Manager 10 | [NAME] | 4 | 6
Manager 13 | 4 |  | Manager 20 | [NAME] | 3 | 6
Manager 14 | 4 |  | Manager 9 | [NAME] | 2 | 4
Manager 17 | 4 |  | Manager 11 | [NAME] | 0 | 0
Manager 16 | 5 |  | Manager 7 | LOC2 | 0 | 0
Manager 1 | 6 |  | Manager 5 | LOC2 | 0 | 0
Manager 2 | 6 |  | Manager 19 | LOC2 | 0 | 0
Manager 3 | 6 |  | Manager 18 | LOC2 | 0 | 0
Manager 4 | 6 |  | Manager 15 | LOC2 | 0 | 0
Manager 8 | 6 |  | Manager 12 | LOC2 | 0 | 0
To summarize, in COL B I have
[NAME]:
=IFERROR(SMALL($F$2:$F$30,ROW(1:1)),"")
that's pulling in all numbers from COL F, but I only want it to pull in numbers that have "LOC1" adjacent in COL E. You can see that I have this criteria set for the formula in COL A and it's displaying #[NAME]! for when it's unable to match to the number in COLB. While wrapping this formula in IFERROR helps, I would prefer to only display numbers based on the criteria set.
I've attached a sample worksheet that hopefully helps illustrate everything.
Spreadsheet: 704838d1605772145-calculating-total-using-if-and-vlookup-chemical-inventory-control
Sheet: Block Info

 | Block Info
 | Block | Ha | Cultivar
 | A | 10 | Cultivar 1
 | B | 15 | Cultivar 2
 | C | 20 | Cultivar 3
 | D | 25 | Cultivar 4
 | E | 30 | Cultivar 5
 | Stock | Stock | Stock
Spreadsheet: 86625d1286556952-dependent-drop-down-list-using-numbers-book3-dynamicdvlistfromlargerlist
Sheet: Lists

[NAME] |  | 16 | 10 |  | Select Box Length First
16 |  | 16 | 11
18 |  | 16 | 13
20 |  | 16 | 14 |  | to add to this list, simply add more options at the bottom
24 |  | 18 | 10 |  | and then sort both columns by column C to keep the items
30 |  | 18 | 11 |  | together that belong together.
32 |  | 18 | 13
34 |  | 18 | 14
40 |  | 20 | 10 |  | this page has dynamic ranges for Length, [NAME] and Sizes.
42 |  | 20 | 11 |  | If you add to the bottom of the ranges, the name ranges expand
 |  | 20 | 13 |  | themselves with no editing on your part.
 |  | 20 | 14
 |  | 20 | 16
 |  | 20 | 18
 |  | 24 | 14
 |  | 24 | 16
 |  | 24 | 19
 |  | 24 | 20
 |  | 24 | 21
 |  | 30 | 20
 |  | 30 | 21
 |  | 30 | 23
 |  | 30 | 24
 |  | 30 | 26
Spreadsheet: 105649d1302949777-2-way-lookup-with-rule-2-way-lookup
Sheet: Sheet1

Wall | 1 | 2 | 3 | 4 | 5 |  | Colors
Back wall | Green | Blue | Yellow | Red | Green |  | Green
Front Wall | Yellow | Red | Orange | Blue | Green |  | Blue
Side Wall | Yellow | Green | Yellow | Orange | Orange |  | Yellow
Ceiling | Blue | Red | Orange | Green | Yellow |  | Red
 |  |  |  |  |  |  | Orange
Wall | 1 | 2 | 3 | 4 | 5
Back wall
Front Wall
Side Wall
Ceiling
Spreadsheet: 847033d1698140735-linking-independent-and-dependent-drop-down-costs-to-master-budgets-to-upload
Sheet: Master Budget

One | 2023 FP3 | 1-1 Tuition | 15669.88457
One | 2023 FP3 | Summer Academy Tutors | 5586.993936
One | 2023 FP3 | Cover | 1856.598192
One | 2023 FP3 | Student Ambassadors | 4076.4867
Two | 2023 FP3 | Staff Development | 1630.59468
Two | 2023 FP3 | Other staff costs (projects & initiatives) | 2226.059952
Two | 2023 FP3 | Staff Cover (illness) | 1644.397524
Two | 2023 FP3 | Extracurricula sessions outside of Enrichment week | 1300.832092
Two | 2023 FP3 | Student embassador | 489.178404
Two | 2023 FP3 | Conference Visits | 815.29734
Two | 2023 FP3 | Conversion activities | 1114.611576
Two | 2023 FP3 | ENRICHMENT 100 HOURS | 3339.089928
Two | 2023 FP3 | Extra Marking 50 hours | 926.09698
Two | 2023 FP3 | Appraisals | 1608.99716
Two | 2023 FP3 | Enrichment | 3201.51654
Two | 2023 FP3 | Probation | 805.2445
Two | 2023 FP3 | Resits | 1370.817746
Three | 2023 FP3 | Staff Cover | 5343.2517
Three | 2023 FP3 | Accompanists/musicians for auditions | 3201.51654
Three | 2023 FP3 | Auditions | 1608.99716
Three | 2023 FP3 | Recruitment activity | 1067.17218
Three | 2023 FP3 | Open Days | 804.49858
Three | 2023 FP3 | 2nd marking | 2315.98796
Three | 2023 FP3 | Staff development (appraisals) | 1310.23047
Four | 2023 FP3 | Accompanists/musicians for auditions | 2892.47148
Four | 2023 FP3 | Auditions | 4186.276704
Four | 2023 FP3 | Events | 3490.58292
Four | 2023 FP3 | Conversion activity | 5238.90288
Four | 2023 FP3 | Staff cover | 6369.63379
Four | 2023 FP3 | Enrichment | 6939.96108
Four | 2023 FP3 | Extracurricular sessions outside of enrichment week | 4345.478475
Five | 2023 FP3 | Staff Development | 3492.60192
Five | 2023 FP3 | Accompanist/musicians for curriculum delivery | 14484.9534
Five | 2023 FP3 | Module Coordination | 1746.30096
Five | 2023 FP3 | Other staff costs | 5212.97361
Five | 2023 FP3 | Follow up lessons and external auditions | 4368.7809
Five | 2023 FP3 | Academic T S | 62500
Five | 2023 FP3 | Generation B | 1266.520225
Five | 2023 FP3 | Additional Teaching Cover | 22542
Spreadsheet: 173345d1344521474-using-2-conditional-formatting-rules-on-multiple-rows-conditional-formatting-example
Sheet: Sheet1

Amount Paid | Total Cost
50 | 100
50 | 100
50 | 100
100 | 100
50 | 100
100 | 100
50 | 100
50 | 100
100 | 100
50 | 100
50 | 100
50 | 100
100 | 100
50 | 100
50 | 100
50 | 100
100 | 100
50 | 100
50 | 100
50 | 100
 |  |  |  | 1. Select ALL cells A2:A21
 |  |  |  | 2. Click 'Conditional Formatting' on Home Ribbon
 |  |  |  | 3. Select 'New Rule'
 |  |  |  | 4. Select 'Use a formula to determine which cells to format'
 |  |  |  | 5. Apply rules as in the above screen shots.
Spreadsheet: 67a53b03-e79d-4720-b1e3-fdc1254dac99
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
RESERVATION INFORMATION
 |  | WHERE DID YOU HEAR ABOUT US?
Travel Agent
First Name |  | Brochure
Last Name |  | Function
Postal Address |  | Guide Book
Town/City |  | [NAME]
Zip/Code |  | Internet
Country |  | Previous Stay
Telephone Number |  | Publication/ Advert
Cell Number |  | Referral
Fax Number |  | Tour Operator/ Travel Agent
E-mail address |  | Voucher/ Educational
Reservation contact |  | Other
Contact Number |  | WHERE IS YOUR NEXT DESTINATION AND WHERE WILL YOU BE STAYING?
Date Booked
Date Check In
Date Check Out |  | SPECIAL REQUIREMENTS
Number of nights
Number of Pax
Room Rate
Room Number
 |  | BANK DETAILS FOR DIRECT BANK DEPOSITS
 |  | NAME | Grete Hollenbach, [NAME]
 |  | BANK | First National Bank
 |  | BRANCH | Fish Hoek
 |  | BRANCH NUMBER | 202309
Signature |  | ACCOUNT NUMBER | 50140030574
By signing the authorisation above, you acknowledge that you have read, and agree to the terms and conditions.
TERMS AND CONDITIONS
1. Guests stay at The Glen Lodgel at their own risk, and we do not accept responsibility for injury or loss or
damage to property, however caused.
2. The account for accommodation and extras must be settled before departure.
3. Reservations will be confirmed upon receipt of a 50% deposit of the total amount due.
4.The deposit must be received within 5 working days of the reservation, failing which this reservation will lapse.
5. If the reservation is cancelled more than 30 days before the date of arrival, the deposit will be refunded,
less a cancellation fee of 10% of the contracted value.
6. If the reservation is cancelled or reduced within 30 days of the date of arrival, the deposit will not be refunded.
7. Method of payment accepted is  direct bank transfers, and cash.
FOR OFFICE USE ONLY
Total Accomm Value
Discount Allowed |  | Method of Deposit Payment
Commission due |  | Deposit Paid By: (i.e. Booking Agent, etc)
Deposit Due |  | Date of Deposit Payment
Balance Due |  | Reference Number
Spreadsheet: 672795d1587014201-function-to-pull-entire-row-based-on-criteria-macro12_-example-month_1
Sheet: Example

 |  |  | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-01 00:00:00
[NAME] | [NAME]
[NAME] | Project A | [NAME]
[NAME] | Project B | [NAME]
[NAME] | Project C | [NAME]
A012345 | [NAME]
A012345 | Project A | [NAME]
A012345 | Project B | [NAME]
A012345 | Project C | [NAME]
[NAME] | [NAME]
A009876 | Project A | [NAME]
A009876 | Project B | [NAME]
A009876 | Project C | [NAME]
 |  |  | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-01 00:00:00
[NAME] | [NAME]
[NAME] | Project A | [NAME] | 5
[NAME] | Project B | [NAME] |  | 20
[NAME] | Project C | [NAME] |  |  | 80
A012345 | [NAME]
A012345 | Project A | [NAME] | 55
A012345 | Project B | [NAME] | 93 | 2090
A012345 | Project C | [NAME]
[NAME] | [NAME]
A009876 | Project C | [NAME] |  |  | 87
A009876 | Project C | [NAME] |  |  | 87
A009876 | Project C | [NAME] |  |  | 87
Spreadsheet: 329476d1404317853-adding-indirect-formula-to-a-countif-es3-cs-wholesale-load-tracking-report-test
Sheet: 5-19

ES3/C&S WHOLESALE LOAD TRACKING
STOP 1 WILL ALWAYS BE ORIGIN - LEAVE SECTION BLANK FOR ANY NON-APPLICALBE STOP, ON ANY GIVE LOAD
REPORTING UPDATE TIME | TRUCK # | ROUTE # | STORE # STOP 1 | ARRIVAL | DEPARTURE | SRC | STORE # STOP 2 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC | STORE # STOP 3 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC | STORE # STOP 4 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC
07:00:00 | 21525 | 43501 | Hammond | 03:43:00 | 04:03:00 |  | 448 | 167 |  |  |  |  | 445
08:00:00
09:00:00
10:00:00
11:00:00
12:00:00
13:00:00
REPORTING UPDATE TIME | TRUCK # | ROUTE # | STORE # STOP 1 | ARRIVAL | DEPARTURE | SRC | STORE # STOP 2 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC | STORE # STOP 3 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC | STORE # STOP 4 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC
07:00:00 | 21445 | 43502 | Hammond | 04:00:00 | 04:14:00 |  | 460 | 200 |  |  |  |  | 456
08:00:00
09:00:00
10:00:00
11:00:00
12:00:00
13:00:00
REPORTING UPDATE TIME | TRUCK # | ROUTE # | STORE # STOP 1 | ARRIVAL | DEPARTURE | SRC | STORE # STOP 2 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC | STORE # STOP 3 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC | STORE # STOP 4 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC
07:00:00 | 32502 | 43503 | Hammond | 03:28:00 |  |  | [NAME]
08:00:00 |  |  |  |  |  |  | [NAME]
09:00:00 |  |  |  |  |  |  | [NAME]
10:00:00 |  |  |  |  |  |  | [NAME]
11:00:00
12:00:00
13:00:00
REPORTING UPDATE TIME | TRUCK # | ROUTE # | STORE # STOP 1 | ARRIVAL | DEPARTURE | SRC | STORE # STOP 2 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC | STORE # STOP 3 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC | STORE # STOP 4 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC
07:00:00 |  |  | Hammond |  |  |  | [NAME]
08:00:00 |  |  |  |  |  |  | [NAME]
09:00:00 |  |  |  |  |  |  | [NAME]
10:00:00 |  |  |  |  |  |  | [NAME]
11:00:00 |  |  |  |  |  |  | [NAME]
12:00:00
13:00:00
REPORTING UPDATE TIME | TRUCK # | ROUTE # | STORE # STOP 1 | ARRIVAL | DEPARTURE | SRC | STORE # STOP 2 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC | STORE # STOP 3 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC | STORE # STOP 4 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC
07:00:00 |  |  | Hammond |  |  |  | [NAME]
08:00:00 |  |  |  |  |  |  | [NAME]
09:00:00 |  |  |  |  |  |  | [NAME]
10:00:00 |  |  |  |  |  |  | [NAME]
11:00:00 |  |  |  |  |  |  | [NAME]
12:00:00
13:00:00
REPORTING UPDATE TIME | TRUCK # | ROUTE # | STORE # STOP 1 | ARRIVAL | DEPARTURE | SRC | STORE # STOP 2 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC | STORE # STOP 3 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC | STORE # STOP 4 | [NAME] TO STOP | ETA | ARRIVAL | DEPARTURE | SRC
07:00:00 |  |  | Hammond |  |  |  | [NAME]
08:00:00 |  |  |  |  |  |  | [NAME]
09:00:00 |  |  |  |  |  |  | [NAME]
10:00:00 |  |  |  |  |  |  | [NAME]
11:00:00 |  |  |  |  |  |  | [NAME]
12:00:00
13:00:00
Spreadsheet: 867879d1714653762-return-value-based-on-multiple-selections-issue-log-ans
Sheet: Issue Log (2)

 | Issue Log
 | Team name |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Effort | Benefit | Result
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Low | Low | 5
ID | Issue Description | Captured by | Raised by | Date captured | Issue Type | Status | Root Cause Analysis | Resolution | MoSCoW | Effort | Benefit | Rating | Update Log |  |  |  |  |  |  |  |  |  |  |  |  |  | Low | Medium | 3
1 |  |  |  |  |  |  |  |  | Should Have | Low | Medium |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Low | High | 2
2 |  |  |  |  |  |  |  |  | Must Have |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Low | Very High | 1
3 |  |  |  |  |  |  |  |  | Won't Have |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Medium | Low | 6
4 |  |  |  |  |  |  |  |  | Could Have |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Medium | Medium | 4
5 |  |  |  |  |  |  |  |  | Must Have |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Medium | High | 3
6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Medium | Very High | 2
7 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | High | Low | 7
8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | High | Medium | 6
9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | High | High | 4
10 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | High | Very High | 3
11 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Very High | Low | 8
12 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Very High | Medium | 7
13 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Very High | High | 6
14 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Very High | Very High | 5
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
41
42
43
44
45
46
47
48
49
50
Spreadsheet: joe_parks__14577__Nymex Mar 18
Sheet: VAR-EES

Enron Energy Services
Net Open Nymex positions by forward strip
Proxy VAR Sensitivity & Maintenance Margins
NESCO Portfolio Only
 | Nymex Contracts Needed to hedge | Current Price levels | Annualized Volatility Levels | Days until Expiration |  | 1 Standard Deviation (68%) | 1.645 Standard Deviations (95%) | 1.96 Standard Deviations (97.5%) | Possible Maintenance Margin Call (1SD) | Possible Maintenance Margin Call (1.645SD) | Possible Maintenance Margin Call (1.96SD)
2002-04-01 00:00:00 | -232.2903677199 |  | 0.66
2002-05-01 00:00:00 | -159.629803646 |  | 0.44
2002-06-01 00:00:00 | -105.2730722144 |  | 0.41
2002-07-01 00:00:00 | -89.85326701880001 |  | 0.42
2002-08-01 00:00:00 | -85.8066435156 |  | 0.42
2002-09-01 00:00:00 | -87.33199790789999 |  | 0.42
2002-10-01 00:00:00 | -114.7403898929 |  | 0.42
2002-11-01 00:00:00 | -142.3660592502 |  | 0.43
2002-12-01 00:00:00 | -172.6245053556 |  | 0.45
 | 0
TOTAL 2002
 | 0
2003 | -1076.9915769668 |  | 0.38
2004 | -1303.4409 | 3.4 | 0.31
2005 | -734.9284 | 3.5 | 0.28
2006 | -257.5453 | 3.6 | 0.2
2004-2016 | -1395.843884838001 |  | 0.16
 | 0
TOTAL
Spreadsheet: 13798a7d-9ca2-4d28-987f-ea09105df8ec
Sheet: PONDERADOS

PONDERADO CATEGORIA SUB 14 MIXTO - 6a PARADA MEDELLIN
 | PAR. [NAME] | PAR. GANADOS | PAR. EMPATADOS | PAR. PERDIDOS | PUNTOS | GOLES A FAVOR | GOLES CONTRA | GOL DIFERENCIA | PONDERADO | BONIFICACION | TOTAL | PUESTO
EQUIPOS
 |  |  |  |  |  |  |  |  |  | 2.2 |  | 1
 |  |  |  |  |  |  |  |  |  | 2 |  | 2
 |  |  |  |  |  |  |  |  |  | 1.9 |  | 3
 |  |  |  |  |  |  |  |  |  | 1.7 |  | 4
 |  |  |  |  |  |  |  |  |  | 1 |  | 5
 |  |  |  |  |  |  |  |  |  | 1 |  | 6
 |  |  |  |  |  |  |  |  |  | 1 |  | 7
PONDERADO CATEGORIA SUB 19 VARONES - 6a PARADA - MEDELLIN
 | PAR. [NAME] | PAR. GANADOS | PAR. EMPATADOS | PAR. PERDIDOS | PUNTOS | GOLES A FAVOR | GOLES CONTRA | GOL DIFERENCIA | PONDERADO | BONIFICACION | TOTAL | PUESTO
EQUIPOS
 |  |  |  |  |  |  |  |  |  | 2.2 |  | 1
 |  |  |  |  |  |  |  |  |  | 2.0 | 4.0 | 2
 |  |  |  |  |  |  |  |  |  | 1.9 |  | 3
 |  |  |  |  |  |  |  |  |  | 1.7 |  | 4
 |  |  |  |  |  |  |  |  |  | 1 |  | 5
 |  |  |  |  |  |  |  |  |  | 1 |  | 6
 |  |  |  |  |  |  |  |  |  | 1 |  | 7
 |  |  |  |  |  |  |  |  |  | 1 |  | 8
 |  |  |  |  |  |  |  |  |  | 1 |  | 9
 |  |  |  |  |  |  |  |  |  | 1 |  | 10
Spreadsheet: 160216d1339009300-how-to-combine-if-statement-in-offset-function-please-help-timesheet-upload
Sheet: Task

Name: | Short List: | Full List:
A.K | Full List | Task for A.K 01
A.K | Task for A.K 05 | Task for A.K 02
A.K | Task for A.K 10 | Task for A.K 03
A.K | Task for A.K 16 | Task for A.K 04
A.K | Task for A.K 19 | Task for A.K 05
A.K | Task for A.K 21 | Task for A.K 06
A.K |  | Task for A.K 07
A.K |  | Task for A.K 08
A.K |  | Task for A.K 09
A.K |  | Task for A.K 10
A.K |  | Task for A.K 11
A.K |  | Task for A.K 12
A.K |  | Task for A.K 13
A.K |  | Task for A.K 14
A.K |  | Task for A.K 15
A.K |  | Task for A.K 16
A.K |  | Task for A.K 17
A.K |  | Task for A.K 18
A.K |  | Task for A.K 19
A.K |  | Task for A.K 20
A.K |  | Task for A.K 21
M.C | Full List | Task for M.C 01
M.C | Task for M.C 01 | Task for M.C 02
M.C | Task for M.C 08 | Task for M.C 03
M.C | Task for M.C 12 | Task for M.C 04
M.C | Task for M.C 14 | Task for M.C 05
M.C | Task for M.C 16 | Task for M.C 06
M.C |  | Task for M.C 07
M.C |  | Task for M.C 08
M.C |  | Task for M.C 09
M.C |  | Task for M.C 10
M.C |  | Task for M.C 11
M.C |  | Task for M.C 12
M.C |  | Task for M.C 13
M.C |  | Task for M.C 14
M.C |  | Task for M.C 15
M.C |  | Task for M.C 16
M.C |  | Task for M.C 17
M.C |  | Task for M.C 18
M.C |  | Task for M.C 19
M.C |  | Task for M.C 20
M.C |  | Task for M.C 21
T.G | Full List | Task for T.G 01
T.G | Task for T.G 4 | Task for T.G 02
T.G | Task for T.G 6 | Task for T.G 03
T.G | Task for T.G 12 | Task for T.G 04
T.G | Task for T.G 15 | Task for T.G 05
T.G | Task for T.G 19 | Task for T.G 06
T.G |  | Task for T.G 07
T.G |  | Task for T.G 08
T.G |  | Task for T.G 09
T.G |  | Task for T.G 10
T.G |  | Task for T.G 11
T.G |  | Task for T.G 12
T.G |  | Task for T.G 13
T.G |  | Task for T.G 14
T.G |  | Task for T.G 15
T.G |  | Task for T.G 16
T.G |  | Task for T.G 17
T.G |  | Task for T.G 18
T.G |  | Task for T.G 19
T.G |  | Task for T.G 20