tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 677139d1589210928-populate-calendar-and-summary-invercargill-leave-copy
Sheet: Datatable

Employee | Location | Date | Leave Type | Hours | Staff List.Location Equal to Location??
Name1 | [NAME] | 2020-05-11 00:00:00 | Annual | 10 | [NAME] |  |  | Last Column Staff List Location have equal values like Location
Name1 | [NAME] | 2020-05-15 00:00:00 | Sick | 10 | [NAME] |  |  | Is it redundant or required?
Name1 | [NAME] | 2020-05-16 00:00:00 | Annual | 10 | [NAME]
Name1 | [NAME] | 2020-06-06 00:00:00 | Sick | 10 | [NAME]
[NAME] | [NAME] | 2020-05-18 00:00:00 | Annual | 10 | [NAME]
[NAME] | [NAME] | 2020-05-23 00:00:00 | Long Service | 10 | [NAME]
[NAME] | [NAME] | 2020-05-25 00:00:00 | Sick | 10 | [NAME]
[NAME] | [NAME] | 2020-05-26 00:00:00 | Annual | 10 | [NAME]
Name3 | [NAME] | 2020-05-18 00:00:00 | Annual | 12 | [NAME]
Name3 | [NAME] | 2020-05-19 00:00:00 | Annual | 12 | [NAME]
Name3 | [NAME] | 2020-05-20 00:00:00 | Long Service | 12 | [NAME]
Name4 | [NAME] | 2020-06-02 00:00:00 | Annual | 10 | [NAME]
Name4 | [NAME] | 2020-06-03 00:00:00 | Annual | 10 | [NAME]
Name4 | [NAME] | 2021-06-04 00:00:00 | Annual | 10 | [NAME]
Name4 | [NAME] | 2020-06-05 00:00:00 | Sick | 10 | [NAME]
Name5 | [NAME] | 2020-06-10 00:00:00 | Annual | 12 | [NAME]
Name5 | [NAME] | 2020-06-11 00:00:00 | Annual | 8 | [NAME]
Name5 | [NAME] | 2020-06-08 00:00:00 | Annual | 12 | [NAME]
Name5 | [NAME] | 2020-06-09 00:00:00 | Annual | 12 | [NAME]
Name6 | [NAME] | 2020-06-15 00:00:00 | Annual | 10 | [NAME]
Name6 | [NAME] | 2021-06-20 00:00:00 | Annual | 10 | [NAME]
Name6 | [NAME] | 2020-06-22 00:00:00 | Long Service | 10 | [NAME]
Name6 | [NAME] | 2020-06-23 00:00:00 | Annual | 10 | [NAME]
Name7 | [NAME] | 2020-06-23 00:00:00 | Annual | 8 | [NAME]
Name7 | [NAME] | 2021-06-24 00:00:00 | Annual | 8 | [NAME]
Name7 | [NAME] | 2020-06-25 00:00:00 | Sick | 8 | [NAME]
Name7 | [NAME] | 2020-06-26 00:00:00 | Annual | 8 | [NAME]
Name7 | [NAME] | 2020-06-27 00:00:00 | Annual | 8 | [NAME]
Name8 | Christchurch | 2020-06-27 00:00:00 | Annual | 10 | Christchurch
Name9 | Christchurch | 2020-05-15 00:00:00 | Long Service | 12 | Christchurch
Name10 | Christchurch | 2020-05-28 00:00:00 | Annual | 16 | Christchurch
Name10 | Christchurch | 2020-06-01 00:00:00 | Annual | 8 | Christchurch
Spreadsheet: 218240d1362407316-extract-certain-value-and-combine-sample-data
Sheet: Sample 1

[NAME] | group1111 | group2222 | group8293
group2222 | group4444 | [NAME] | [NAME]
Expected result:
1234, 1111, 2222, 8293
2222, 4444, 1122, 8888
1234 | 1111 | 2222 | 8293
2222 | 4444 | 1122 | 8888
1234,1111,2222,8293
2222,4444,1122,8888
Spreadsheet: 533124d1502663409-pivot-table-displaying-old-data-s666-53rd-street-cost-schedule-after
Sheet: Lookup

Line Item | Type
88 | Advertising
2E | Arborist
1A | Architecture
18 | Asphalt Paving
70 | Bathroom Accessories
30 | Block/Retaining Walls
72 | Built-in Appliances
48 | Cabinets
66 | Carpeting
63 | Ceramic Tile Flooring
2A | Civil
9 | Clean Up
96 | Closing Costs/Fees
84 | Communications Equipment
97 | Complaint Abatement/Goodwill
90 | Contingencies
89 | Cost of Sale
17 | Curb, Gutter, Sidewalk Off-Site
10 | Demolition
5B | Development Impact Fees
13 | Drainage
59 | Drywall
82 | Electrical
74 | Elevator
57 | Enclosures
40 | Engineered Wood Beams
4 | Entitlements/Permits
2D | Environmental
12 | Erosion Control
47 | Exterior Doors
19 | Fencing
45 | Finish Carpentry
20 | Finish Grading
69 | Finish Hardware
46 | Finish Trim/Interior Doors
73 | Fire Extinguishers
81 | [NAME]
32 | Fireplace
83 | Fixtures
61 | [NAME]
25 | Foundation Footing & Slab
68 | Garage Door
93 | GC Profit
92 | GC Supervision
62 | Granite Countertops
8 | Guard Services
79 | Heating
80 | HVAC System
95 | Inspections
52 | Insulation
91 | Insurance Premiums
94 | Interest Reserve
99 | Land Draw
1B | Landscape Architecture
21 | Landscaping
27 | Lightweight Concrete
71 | Luminous Ceiling
2B | MEP
37 | Metal Doors & Frames
36 | Metal Fireplace
38 | Metal Service Doors
56 | Mirrors
98 | Miscellaneous Costs
7 | Miscellaneous Rentals
85 | [NAME]
86 | [NAME]
87 | Model Utilities
60 | Painting
39 | Panelized [NAME]
58 | Plaster/Stucco
77 | Plumbing
75 | Pool
24 | Reinforcing Steel
64 | Resilient Flooring
42 | [NAME]
50 | Roofing
44 | Rough Carpentry
11 | Rough Grading
33 | Rough Hardware
43 | Rough Lumber
15 | Sewer System
5A | Sewer/Water Fees
51 | Sheetmetal
53 | Skylight
3 | Soil Testing
76 | Solar
34 | Steel Columns & Beams
35 | Steel Stairs & Railings
54 | Storefront Sash Glazing
22 | Street Lights
23 | Street Signs
28 | StrucSlab/Columns/Beams
2C | Structural
67 | Suspended Ceiling
6 | Temporary Utilities
29 | Trash Enclosure
14 | Utility Trenching
31 | Veneer
78 | Ventilation
26 | Walks, Patios, Courtyards
16 | Water & Gas Connection
49 | Waterproofing
55 | Windows & Sliders
65 | Wood Floors
41 | Wood Siding
Spreadsheet: 852246d1702331946-power-query-get-dynamic-headers-from-another-table-and-vlookup-pq-headerstoexistingtable
Sheet: Sheet1

tblSales |  |  |  | tblCost |  |  |  | tblCategory |  |  |  | Desired Result
ID | Buyer | Sales Amount |  | ID | Cost Code | Amount |  | Category | Cost Code |  |  | ID | Buyer | Sales Amount | General | Mechanical | Inspection
[NAME] | [NAME] | 1000 |  | [NAME] | 1510.1000 | 128 |  | General | 1510.3000 |  |  | [NAME] | [NAME] | 1000
A102 | [NAME] | 1500 |  | [NAME] | 1510.1100 | 97 |  | General | 1510.3100 |  |  | A102 | [NAME] | 1500
A103 | [NAME] | 2500 |  | [NAME] | 1510.2000 | 747 |  | Mechanical | 1510.3200 |  |  | A103 | [NAME] | 2500
A104 | Doe | 3000 |  | [NAME] | 1510.2100 | 161 |  | Mechanical | 1510.3300 |  |  | A104 | Doe | 3000
 |  |  |  | [NAME] | 1510.3000 | 204 |  | Inspection | 1510.3400
 |  |  |  | [NAME] | 1510.3100 | 119 |  | Inspection | 1510.3500 |  |  | ID | Buyer | Sales Amount | General | Mechanical | Inspection
 |  |  |  | [NAME] | 1510.3200 | 830 |  |  |  |  |  | [NAME] | [NAME] | 1000 | 1232 | 1764 | 1510
 |  |  |  | [NAME] | 1510.3300 | 178 |  |  |  |  |  | A102 | [NAME] | 1500 | 1062 | 888 | 911
 |  |  |  | [NAME] | 1510.3400 | 112 |  |  |  |  |  | A103 | [NAME] | 2500 | 1339 | 1747 | 1260
 |  |  |  | [NAME] | 1510.3500 | 597
 |  |  |  | A102 | 1510.1000 | 333
 |  |  |  | A102 | 1510.1100 | 169
 |  |  |  | A102 | 1510.2000 | 492
 |  |  |  | A102 | 1510.2100 | 282
 |  |  |  | A102 | 1510.3000 | 468
 |  |  |  | A102 | 1510.3100 | 383
 |  |  |  | A102 | 1510.3200 | 433
 |  |  |  | A102 | 1510.3300 | 261
 |  |  |  | A102 | 1510.3400 | 351
 |  |  |  | A102 | 1510.3500 | 201
 |  |  |  | A103 | 1510.1000 | 703
 |  |  |  | A103 | 1510.1100 | 592
 |  |  |  | A103 | 1510.2000 | 315
 |  |  |  | A103 | 1510.2100 | 660
 |  |  |  | A103 | 1510.3000 | 341
 |  |  |  | A103 | 1510.3100 | 352
 |  |  |  | A103 | 1510.3200 | 190
 |  |  |  | A103 | 1510.3300 | 756
 |  |  |  | A103 | 1510.3400 | 513
 |  |  |  | A103 | 1510.3500 | 85
 |  |  |  | [NAME] | 1510.1000 | 56
 |  |  |  | [NAME] | 1510.1100 | 212
 |  |  |  | [NAME] | 1510.2000 | 406
 |  |  |  | [NAME] | 1510.2100 | 72
 |  |  |  | [NAME] | 1510.3000 | 412
 |  |  |  | [NAME] | 1510.3100 | 497
 |  |  |  | [NAME] | 1510.3200 | 375
 |  |  |  | [NAME] | 1510.3300 | 381
 |  |  |  | [NAME] | 1510.3400 | 402
 |  |  |  | [NAME] | 1510.3500 | 399
 |  |  |  | A102 | 1510.1000 | 282
 |  |  |  | A102 | 1510.1100 | 106
 |  |  |  | A102 | 1510.2000 | 447
 |  |  |  | A102 | 1510.2100 | 497
 |  |  |  | A102 | 1510.3000 | 37
 |  |  |  | A102 | 1510.3100 | 174
 |  |  |  | A102 | 1510.3200 | 145
 |  |  |  | A102 | 1510.3300 | 49
 |  |  |  | A102 | 1510.3400 | 30
 |  |  |  | A102 | 1510.3500 | 329
 |  |  |  | A103 | 1510.1000 | 196
 |  |  |  | A103 | 1510.1100 | 218
 |  |  |  | A103 | 1510.2000 | 52
 |  |  |  | A103 | 1510.2100 | 150
 |  |  |  | A103 | 1510.3000 | 247
 |  |  |  | A103 | 1510.3100 | 399
 |  |  |  | A103 | 1510.3200 | 484
 |  |  |  | A103 | 1510.3300 | 317
 |  |  |  | A103 | 1510.3400 | 197
 |  |  |  | A103 | 1510.3500 | 465
Spreadsheet: 828582d1683623610-formulas-to-reference-different-columns-depending-on-input-value-sample-book2-aligw
Sheet: Data

Incident Number | Priority | Status | Description | Status Category | Converted Priority | Open Date | Res Date | Data Type | B2C | B2B
INC1000001 | Medium | Closed | Ticket1 | Resolved | P3 | 2022-02-08 00:00:00 | 2023-02-14 00:00:00 | B2B | False | True
INC1000002 | Medium | Closed | Ticket2 | Resolved | P3 | 2022-03-29 00:00:00 | 2023-02-23 00:00:00 | B2B | True | False
INC1000003 | Medium | Closed | Ticket3 | Resolved | P3 | 2022-07-14 00:00:00 | 2023-02-14 00:00:00 | Both | True | True
INC1000004 | Medium | Closed | Ticket4 | Resolved | P3 | 2022-08-24 00:00:00 | 2023-03-06 00:00:00 | B2B | True | False
INC1000005 | Medium | Closed | Ticket5 | Resolved | P3 | 2022-08-24 00:00:00 | 2023-02-10 00:00:00 | B2B | True | False
INC1000006 | Medium | Closed | Ticket6 | Resolved | P3 | 2022-08-24 00:00:00 | 2023-02-10 00:00:00 | B2B | False | True
INC1000007 | Medium | Closed | Ticket7 | Resolved | P3 | 2022-08-26 00:00:00 | 2023-02-10 00:00:00 | B2B | True | False
Spreadsheet: adb8cd25-bc61-4f07-ac02-4081f3025299
Sheet: U13GD

 |  |  |  | BE CORNWALL SILVER U13
 |  |  |  |  | GIRLS DOUBLES 2011
 |  | GROUP MATCHES   Best of 3 games to 15
 |  |  |  |  |  |  |  | Games
 |  | GROUP A |  | 1 | 2 | 3 | 4 | Won | Points
 | 1 | A Walker/E Reed | Co/Co |  | 2 .10. | 1.10. | 10.8. | 0 | 41
 | 2 | A Polglase/F Cameron-Webb | Co/Co | 15.15. |  | 6.15.4. | 15.15. | 5 | 85 |  |  | BOWMAN-PIKE
 | 3 | R Bowman/B Pike | Dv/Dv | 15.15. | 15.12.15. |  | 15.15. | 6 | 102 |  |  | FINAL
 | 4 | L Cole/E Killoran | Dv/Dv | 15.15. | 10.4. | 9.4. |  | 2 | 57
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] -PIKE
 |  |  |  |  |  |  |  | Games |  |  |  |  | WINNER
 |  | GROUP A |  | 1 | 2 | 3 | 4 | Won | Points |  |  |  | 15.5. 16.14.
 | 1 | S Frost/A Grout | Co/Co |  | 11.8. | 13.6. | 15.18. | 2 | 71
 | 2 | C Cosgrove/P Morris | Wo/Co | 15.15. |  | 9.6. | 15.15. | 4 | 75 |  |  | BROWN-COOPER
 | 3 | K Brown/L Cooper | Dv/Dv | 15.15. | 15.15. |  | 15.15. | 6 | 90 |  |  | FINAL
 | 4 | E Watkinson/M Isley | Co/Co | 13.16. | 8.7. | 4.5. |  | 0 | 53
Spreadsheet: 58803d1259069236-if-between-value-range-if-statement
Sheet: Sheet1

If Function |  |  |  |  |  |  |  |  |  | Pass if Avg > 50% |  | If with And Function
 | English |  | Maths |  | Science |  |  | Average |  | Overall Result |  | Selection for Maths Quiz if Overall Result Pass & Maths result >50%
[NAME] | 0.8 |  | 0.53 |  | 0.49
[NAME] | 0.4 |  | 0.35 |  | 0.65
[NAME] | 0.55 |  | 0.55 |  | 0.3
Spreadsheet: 794632d1662163656-employee-absence-tracker-rolling-12-month-window-needed-2022-exempt-sick-test
Sheet: AllMonths

 | Month Name | January
 | Count of REASON | Column Labels
 | Row Labels | FMLA | Left Early | LOA | Other | Personal | Sick | (blank) | Grand Total
 | FT | 4 | 2 | 26 |  | 1 | 10 |  | 43
 | (blank) | 4 | 2 | 26 |  | 1 | 10 |  | 43
 | GP |  |  |  | 1 |  | 10 |  | 11
 | (blank) |  |  |  | 1 |  | 10 |  | 11
 | Hotel |  | 1 |  | 1 |  | 11 |  | 13
 | (blank) |  | 1 |  | 1 |  | 11 |  | 13
 | HP | 6 |  |  |  |  |  |  | 6
 | (blank) | 6 |  |  |  |  |  |  | 6
 | IC |  |  |  |  |  | 5 |  | 5
 | (blank) |  |  |  |  |  | 5 |  | 5
 | RL |  | 1 |  | 1 |  | 7 |  | 9
 | (blank) |  | 1 |  | 1 |  | 7 |  | 9
 | RM |  |  |  |  |  | 3 |  | 3
 | (blank) |  |  |  |  |  | 3 |  | 3
 | Shipping | 2 |  |  | 1 |  |  |  | 3
 | (blank) | 2 |  |  | 1 |  |  |  | 3
 | SP |  |  |  |  | 1 | 5 |  | 6
 | (blank) |  |  |  |  | 1 | 5 |  | 6
 | [NAME] |  | 1 |  |  | 1 | 10 |  | 12
 | (blank) |  | 1 |  |  | 1 | 10 |  | 12
 | (blank) |  |  |  |  |  | 5 |  | 5
 | (blank) |  |  |  |  |  | 5 |  | 5
 | Grand Total | 12 | 5 | 26 | 4 | 3 | 66 |  | 116
Spreadsheet: darrell_schoolcraft__7805__imbalsumm0108
Sheet: PGETX

 |  |  |  |  | 12283
 | [NAME] |  | Pecos Del |  | Gunpoint #2
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | -132997 | -79207 | -39109 | -92874
2 | -112568 | -53005 | -40001 | -99950 |  |  |  |  |  |  |  |  |  | Avg
3 | -144086 | -117734 | -40000 | -65000 |  |  |  |  |  | Month | Measured | Scheduled | Imbalance | Index | Amount
4 | -151514 | -150002 | -55771 | -56162
5 | -151656 | -150001 | -55077 | -56162
6 | -153786 | -150001 | -52179 | -56162 |  |  |  |  |  | 2001-01-01 00:00:00 | -715680 | -705664 |  | 8.21
7 | -138012 | -58418 | -1800 | -79718 |  |  |  |  |  | 2001-02-01 00:00:00 | -661568 | -648307 |  | 5.62
8 | -144890 | -82115 | -48170 | -109950 |  |  |  |  |  | 2001-03-01 00:00:00 | -1831536 | -1828209 |  | 4.98
9 | -123111 | -64023 | -1611 | -59950 |  |  |  |  |  | 2001-04-01 00:00:00 |  | -3486797 |  | 4.87
10 | -150424 | -90703 |  | -59808 |  |  |  |  |  | 2001-05-01 00:00:00 | -3735499 | -3753054 |  | 3.82
11 | -159237 | -138136 | -58416 | -79950 |  |  |  |  |  | 2001-06-01 00:00:00 |  | -5025875 |  | 3.2
12 | -153130 | -130080 | -56945 | -79950 |  |  |  |  |  | 2001-07-01 00:00:00 | -4565965 | -4525416 |  | 2.77
13 | -136048 | -141366 | -105213 | -100666
14 | -141659 | -117756 | -48404 | -72615
15 | -141744 | -97671 | -39144 | -73315
16 | -131618 | -109589 | -88744 | -109950
17 | -142840 | -150006 | -124297 | -120000
18
19
20
21
22
23
24
25
26
27
28
29
30
31
 |  |  |  | 2001-07-31 00:00:00 |  |  | 460835.37
 |  |  |  | 2001-08-17 00:00:00
 | CBS Volume
 |  |  |  | 111236
Spreadsheet: 856103d1705483176-find-value-return-sheet-colum-and-row-name-searchexample_excelforum_v3
Sheet: Sheet1

Sheet1
 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
A | A1_F | A2_F | A3_F | A4_F | A5_F | A6_F | A1_R | A2_R | A3_R | [NAME]
B | A5_R | A6_R | B1_F | B2_F | B3_F | B4_F | B5_F | B6_F | B1_R | B2_R
C | B3_R | B4_R | [NAME] | B6_R | C1_F | C2_F | C3_F | C4_F | C5_F | C6_F
D | C1_R | C2_R | C3_R | C4_R | C5_R | [NAME] | D1_F | D2_F | D3_F | D4_F
E | D5_F | D6_F | D1_R | [NAME] | D3_R | D4_R | D5_R | D6_R | E1_F | E2_F
F | [NAME] | E4_F | E5_F | E6_F | E1_R | E2_R | E3_R | E4_R | E5_R | [NAME]
G | F1_F | [NAME] | F3_F | F4_F | F5_F | F6_F | F1_R | F2_R | F3_R | F4_R
H | F5_R | [NAME] | G1_F | [NAME] | [NAME] | G4_F | [NAME] | G6_F | G1_R | G2_R
I | G3_R | G4_R | [NAME] | G6_R | [NAME] | H2_F | [NAME] | H4_F | H5_F | H6_F
J | H1_R | H2_R | H3_R | [NAME] | H5_R | H6_R | I1_F | I2_F | I3_F | I4_F
Spreadsheet: 708095d1607614264-average-last-3-cells-in-a-column-that-are-not-blank-excel-help
Sheet: Sheet1

Week
1 | 1
2 | 2
3 | 3
4
5 | 5
6 | 2
7 | 3
8
9
10 | 13
11
12 | 17
13 | 24
Spreadsheet: 142517d1329882731-excel-2007-consolidating-different-values-under-different-names-indifferent-tabs-to-master-sheet-varification-doc
Sheet: RAJORIGARDEN ADMN BLK

RAJORIGARDEN ADMIN BLOCK |  |  |  |  |  |  |  | RAJORIGARDEN |  |  |  | RAJORIGARDEN |  |  |  | RAJORIGARDEN |  |  |  | RAJORIGARDEN |  |  |  | RAJORIGARDEN |  |  |  | RAJORIGARDEN |  |  |  | RAJORIGARDEN |  |  |  | RAJORIGARDEN |  |  |  | RAJORIGARDEN |  |  |  | RAJORIGARDEN |  |  |  | RAJORIGARDEN |  |  |  | RAJORIGARDEN |  |  |  | RAJORIGARDEN |  |  |  | RAJORIGARDEN |  |  |  | RAJORIGARDEN |  |  |  | RAJORIGARDEN |  |  |  | RAJORIGARDEN |  |  |  | RAJORIGARDEN |  |  |  | RAJORIGARDEN |  |  |  | RAJORIGARDEN |  |  |  | RAJORIGARDEN |  |  |  | RAJORIGARDEN |  |  |  | RAJORIGARDEN |  |  |  | RAJORIGARDEN |  |  |  | RAJORIGARDEN |  |  |  | RAJORIGARDEN |  |  |  | RAJORIGARDEN |  |  |  | RAJORIGARDEN |  |  |  | RAJORIGARDEN |  |  |  | RAJORIGARDEN |  |  |  | RAJORIGARDEN |  |  |  | RAJORIGARDEN |  |  |  | RAJORIGARDEN |  |  |  | RAJORIGARDEN |  |  |  | RAJORIGARDEN |  |  |  | RAJORIGARDEN |  |  |  | RAJORIGARDEN |  |  |  | RAJORIGARDEN |  |  |  | RAJORIGARDEN |  |  |  | RAJORIGARDEN |  |  |  | RAJORIGARDEN |  |  |  | RAJORIGARDEN |  |  |  | RAJORIGARDEN |  |  |  | RAJORIGARDEN |  |  |  | RAJORIGARDEN |  |  |  | RAJORIGARDEN |  |  |  | RAJORIGARDEN |  |  |  | RAJORIGARDEN |  |  |  | RAJORIGARDEN |  |  |  | RAJORIGARDEN |  |  |  | RAJORIGARDEN |  |  |  | RAJORIGARDEN |  |  |  | RAJORIGARDEN |  |  |  | RAJORIGARDEN |  |  |  | RAJORIGARDEN |  |  |  | RAJORIGARDEN |  |  |  | RAJORIGARDEN |  |  |  | RAJORIGARDEN |  |  |  | RAJORIGARDEN |  |  |  | RAJORIGARDEN |  |  |  | RAJORIGARDEN |  |  |  | RAJORIGARDEN
SNO | Part Code | Description | Qty | Qty (As on Date 16th Jan-2012)
Section-V,  Part A, SNO-3, 5 | PE-SV Router, PE-SDN Router |  | 1
Existing Material Redeployment
A | Power System
 | 30 KVA PP (9+2)x100-13 |  | 1
 | 100 A modules |  | 1
Spreadsheet: 864309d1711534603-booking-document-need-help-booking-ramadhan-ballroom
Sheet: F&B Summary 

Total booking code | Booking code | Total in IDR
 | 250323
 | 260323
 | 270323
 | 280323
 | 290323
 | 300323
 | 310323
 | 10423
 | 20423
 | 30423
 | 40423
 | 50423
 | 60423
 | 70423
 | 80423
 | 90423
 | 100423
 | 110423
 | 120423
 | 130423
 | 140423
 | 150423
 | 160423
 | 170423
 | 180423
 | 190423
 | 200423
 | 210423
 | 220423
Spreadsheet: 202630d1356653664-how-to-narrow-selection-of-2nd-drop-down-box-based-on-the-1st-drop-downs-pcb-
Sheet: Sheet1

Style | Color |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HighRecKolA: | 8 |  | Styles
Style 1 | Black |  | Task 1:  Make the values in the drop down box at A2 unique when user wants to view them. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Style 1
Style 1 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Style | Color |  | Style 2
Style 1 | Red |  | Task 2:  Only show the colors that go with the style selection.  For instance, when |  |  |  |  |  |  |  |  |  |  |  |  | Style 2 | Black |  | Style 3
Style 2 | Black |  | user selects Style 1, only Black, Brown and Red should show up. |  |  |  |  |  |  |  |  |  |  |  |  | Style 1 | Black
Style 3 | Blue |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Style 3 | Green
Style 3 | Green
Style 3 | Yellow
Spreadsheet: 835143d1688344391-need-help-with-excel-file-and-slicer-calculation-issue-dvg_inventory_tracker_reports-mehdi_154-
Sheet: Help

Product Name | Current Inventory | Pending Purchases | Re-Order Point | Re-order - Curr Inv | Amount | Quantity | Rank |  |  |  | RANK | PRODUCT NAME | AMOUNT | QUANTITY
Spreadsheet: phillip_m_love__30669__200002_OA
Sheet: ONT_GL 

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - ACTUALS
REGION:  ONTARIO
REGION:  ONTARIO
 |  |  | Total |  | Reclasses |  | February |  | March |  | April
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron
2 |  | Liquidations
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron
7 |  | Liquidations |  |  |  |  |  |  |  | 64180.02
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME]
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind
14 |  | Cash Out
15 |  | Cash In
16 |  | Synthetic Storage
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg)
18 |  | W/D (Purchase from Stg)
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4:
23 | Fuel:
 | Transport Expense:
24 |  | Commodity
25 |  | Demand
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous
 |  | TOTAL
FT-Ontario
 |  | Current Month MTM |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 109023 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Financial Liquidations |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Originations |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | TOTAL FIRM TRADING
 |  | TOTAL GL
Spreadsheet: daren_farmer__5463__hpl0908
Sheet: Sheet1

HPLN0908.XLS |  | Fax # [PHONE]
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL;  AMI_CHOSKI / ENRON
FROM:  [NAME]  (TU ELECTRIC)
SUBJECT:  TXU FUELS NOMINATION - September 08, 2000 |  |  |  |  |  | REVISION #1
 |  |  |  |  |  | ** Friday
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 2000-09-08 00:00:00
 |  |  |  |  |  | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream
Enron (FM) |  | LS HPL [NAME] |  | HPL
 |  |  |  |  | 0 to 30  0900hrs | 0 to 30  0900hrs
 |  |  |  |  | 30  to 0 2100hrs | 30  to 0 2100hrs
 |  | Firm Summary
Enron (S) |  | LS HPL [NAME] |  | ENA | 10 | 0
Enron (S) |  | Oasis Turbine |  | ENA | 10 | 11.8
Enron (S) |  | Reklaw |  | ENA | 10 | 30
 |  | Enron North America Spot/3959
OTHER ENRON/HPL TRANSPORTS: |  |  |  | Downstream
 |  | Total Other Transports:
NOTE:  Additional swing volumes may be requested at Teco Tap, or Texoma by TUFCO Gas Control under either the
Wagner Brown K# 1901 or HPL K# 3949 agreements.
*  Nominations to continue until TU Electric changes such nominations.
CC:   [NAME] | [NAME]
R. Skerik | [NAME]
G. Green | K. English
B. Fleming | GCC Dispatcher
Spreadsheet: 788294d1658390618-split-data-with-filter-xml-function-xml-filter-different-result
Sheet: Blad1

original | subsstring 1 | subsstring 2 | subsstring 3 | subsstring 4 | subsstring 5 | subsstring 6 | subsstring 7
10,20,30,40,50,60,70
15,20,30,40,50,60,71
10,20,30,40,50,60,72
10,20,30,40,50,60,73
10,20,30,40,50,60,74
16,20,30,40,50,60,75
10,20,30,40,50,60,76
10,20,30,40,50,60,77
10,20,30,40,50,60,78
10,20,30,40,50,60,79
Spreadsheet: 218107d1362350312-assistance-with-array-or-advanced-filter-please-lmgtfy-4
Sheet: f

 | Group Name :
 | Group Count :
 | Birthday Range
 | Start Date:
 | End Date:
Parent's
First Name | Child | Child's dob
Spreadsheet: 631839d1562857002-distance-between-coordinates-shown-in-a-sorted-list-xlf_1282014_part2
Sheet: Desirable outcome

Location ID | Coordinate X | Coordinate Y | 1st closest location | distance (m) | 2nd closest location | distance (m)
PG343 | 646860 | 248249 | AG_4190C | 64.8 | AABF | 69.8
PL122 | 646860 | 248249 | SCRU | 65.4 | AG_7513A | 70.4
[NAME] | 647150 | 249980 | MEKE | 94.9 | AASI | 99.9
KO420 | 665069 | 259111 | AG_0034A | 91.7 | BABS | 96.7
OL942 | 656550 | 256150 | VORD | 70 | ZH955-1 | 75
PY492 | 643443 | 237911 | AG_0712A | 3.6 | [NAME] | 8.6
PT940 | 643443 | 237911 | ROIN | 0 | BORA | 5
HY675 | 655820 | 257720 | SUPF | 87.3 | BRWI | 92.3
[NAME] | 656260 | 249240 | HEKO | 5 | LELI | 10
KH387 | 648322 | 246675 | AG_4616A | 1.4 | AG_0501B | 6.4
UB482 | 655642 | 247923 | AG212-1 | 94.8 | LEST | 99.8
HF029 | 653510 | 246900 | BADE | 5 | SCHH | 10
RH392 | 653510 | 246900 | ZH246-1 | 8.9 | AG_0627A | 13.9
LN392 | 671310 | 243990 | AG_7519A | 0 | AG_4190C | 5
ES492 | 650560 | 236088 | AG959-1 | 0 | SCRU | 5
NJ111 | 656622 | 232628 | AG082-2 | 79.7 | MEKE | 84.7
LK392 | 656622 | 232628 | AABF | 73.5 | AG_0034A | 78.5
KL329 | 635070 | 236500 | AG_7513A | 99.6 | VORD | 104.6
GF329 | 635070 | 236500 | AASI | 100.9 | AG_0712A | 105.9
DF392 | 633251 | 239845 | BABS | 62.8 | ROIN | 67.8
DR029 | 638611 | 263271 | ZH955-1 | 0 | SUPF | 5
SD932 | 637023 | 261981 | [NAME] | 15 | HEKO | 20
WE942 | 637023 | 261981 | BORA | 1.4 | AG_4616A | 6.4
DE902 | 668849 | 245006 | BRWI | 12.5 | AG212-1 | 17.5
[NAME] | 665580 | 258800 | LELI | 94.9 | BADE | 99.9
RH992 | 665580 | 258800 | AG_0501B | 46.1 | ZH246-1 | 51.1
LR012 | 645850 | 249150 | LEST | 50.5 | AG_7519A | 55.5
[NAME] | 665470 | 258450 | SCHH | 86.6 | AG959-1 | 91.6
OR654 | 668855 | 245017 | AG_0627A | 12.5 | AG082-2 | 17.5