tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 713026d1610533112-make-list-from-match-in-table-menu-items-and-inventory
Sheet: CK Inv List

American Breakfast | Caesar Dressing
American Breakfast Toastie | Cheese Sauce
Ham & Cheese Toastie | Chili Sauce
Ham Cheese Panini | Choron Mayo
Pancakes | [NAME]
Yogurt & berries | [NAME] Dressing
Chicken & Bacon | [NAME]
Ham Cheese Mayo | Lemon Sour Cream
[NAME] | [NAME]
Vegan Hummus & Beedroot | Mayonnaise
Copenhagen Hotdog | [NAME]
Chili Cheese Dog | [NAME]
Roast Beef & Avocado | Chocolate Sauce
[NAME] | Caramel Sauce
Vegan [NAME] | Falafel Balls
Submarine Supreme | Sliced Ham
Chili Cheese Steak | Roast Beef
American Moby | Vegan Pumpkin Hummus
Lucky 13 Burger | MX Spice (Mixed)
The Black Pearl | SW Spice (Shawarma)
Vegan Mexican Burger | Pickled Beetroot
Premium Cheese Fries | Pickled Cucumber
[NAME] | Whole Pickled Jalapeño
[NAME] | Sun Dried Tomato
[NAME] | Roasted Nuts
Falafel Balls | Peanuts
French Fries | Emmentaler Cheese
Fries n Crispy | Mozzarella Cheese
Onion Rings | Cheddar Cheese
[NAME] | Yoghurt
Caesar Wrap | [NAME]
[NAME] | Muffin [NAME]
[NAME] | Pancakes
Falafel Wrap | [NAME]
[NAME]
Beef mexi wrap
Caesar Salad
Add chicken
Falafel Salad
Smoked Salmon Salad
Tomato Salad
[NAME]
[NAME]
[NAME]
Pancake Dessert
Spreadsheet: 101506d1299618661-combining-tasks-workbook1
Sheet: Sheet1

284 |  |  |  |  | 284
884 |  |  |  |  | 182
182 |  |  |  |  | 058
058 |  |  |  |  | 452
711 |  |  |  |  | 805
119 |  |  |  |  | 345
699 |  |  |  |  | 290
452 |  |  |  |  | 215
805 |  |  |  |  | 542
345 |  |  |  |  | 432
290 |  |  |  |  | 398
215 |  |  |  |  | 423
200 |  |  |  |  | 287
542
432
551
398
423
287
966
Spreadsheet: 264104d1378786608-cross-referencing-columns-test1
Sheet:  Service Dropper Count

 |  | Number Of Droppers per Room
 |  |  | Individualy Piped | [NAME] | Hose Station & Double Hand Wash | [NAME] | Double Hand Wash | Red Meat Thermoformer | [NAME] | [NAME] | Single Hand Wash | Totals per Room
 |  | Drawing Numbers |  | 1501-S046 | 1501-S047 | 1501-S048 | 1501-S040 | 1501-S019 Sht1 | 1501-S019 Sht2 | 1501-S049 | 1501-S044
 |  | Total per Dropper Type
 |  |  |  | Total [NAME] in process rooms = |  |  |  |  |  |  |  | (All droppers/supplies)
 |  |  |  | (Excludes types SD0, SD4,SD5,SD6,SD8 droppers
Spreadsheet: daren_farmer__5972__Enron Nom Change
Sheet: Sheet1

To:   [NAME]          (Enron) |  |  |  |  |  | Phone: | (713) 853-9272
From:  Jan Svajian      ([NAME]) |  |  |  |  |  | FAX: | (713) 646-2391
Date:  6/13/00 |  |  |  |  |  | E-Mail: | [EMAIL]
Subject:  New Well Nomination for June 14th and June 15th
Effective Date | CTP NAME | Gross Vol. (MMBtu/d) | DBQ Available | Excess Available | First of the month original nomination |  | Pipeline affected
2000-06-14 00:00:00 | Haynes 21 | 1000 | 750 | 250 | 0 |  | TEJAS
2000-06-15 00:00:00 | Haynes 21 | 2500 | 1875 | 625 | 0 |  | TEJAS
This new well is expected to begin flow to Tejas the afternoon of June 14th.  The Tejas meter number is
23-805-24.
I tried to find out the name of the scheduler for the Tejas Pipeline but no one has called me back
as yet.  If you know the name and number of the person handling this Tejas meter, please let
me know.
Spreadsheet: 94411d1294240201-look-up-references-prob1
Sheet: Sheet1

a | 2011-01-07 00:00:00
b
c
d
e
Spreadsheet: 825528d1681379284-how-to-get-sum-of-rows-where-several-rows-are-empty-in-between-s666-pt-get-sum-of-rows-where-several-rows-are-empty-in-between
Sheet: Sheet1

Field name |  | Total Time par fields
Test1
Test2
Test3
Test4
Test5
Test6
[NAME]
Test8
Test9
Spreadsheet: 155975d1337120378-vlookup-information-is-different-but-i-get-the-same-answer-copy-of-vlookup
Sheet: Seller's % (2)

 |  |  |  |  | GPM | < 4.5 |  | GPM | >= 4.5
Company | Volume | GPM | Price |  | Volume | Price |  | Volume | Price
Vendor 1 | 5000 | 4.6 | 1.68 |  | 0 | 1.38 |  | 0 | 1.38
Vendor 2 | 2500 | 4.9 | 1.58 |  | 500 | 1.38 |  | 500 | 1.48
Vendor 3 | 2500 | 4.4 | 1.48 |  | 2000 | 1.48 |  | 2000 | 1.58
Vendor 4 | 2500 | 4.5 | 1.58 |  | 5000 | 1.58 |  | 5000 | 1.68
 |  |  |  |  | 10001 | 1.68 |  | 10001 | 1.78
Price | 1.9785005
Spreadsheet: 31899d1227900300-formulae-which-can-calculate-the-count-between-time-range-book2
Sheet: Sheet1

Call Date | Duration | Userfield
00:02:00 | 99 | 1.22617e+16 |  | #N/A
00:08:00 | 44 | 1.22617e+16 |  | count entries between every half hour |  |  |  |  |  | Entries between 0:00 to 0:30
00:10:00 | 110 | 1.22617e+16 |  | Corelate that half hour and count the number of entries in column C |  |  |  |  |  | Count of entries in column C between 0:00 to 0:30
00:11:00 | 156 | 1.22617e+16 |  |  |  |  |  |  |  | average of entries in column B between 0:00 to 0:30
00:14:00 | 139 | 1.22617e+16
00:15:00 | 72 | 1.22617e+16
00:16:00 | 47 | 1.22617e+16
00:16:00 | 133 | 1.22617e+16
00:17:00 | 86 | 1.22617e+16
00:16:00 | 184 | 1.22617e+16
00:27:00 | 150 | 1.22617e+16
00:29:00 | 182 | 1.22617e+16
00:31:00 | 42 | 1.22617e+16
00:32:00 | 91 | 1.22617e+16
00:32:00 | 232 | 1.22617e+16
00:35:00 | 129 | 1.22617e+16
00:37:00 | 89 | 1.22617e+16
00:37:00 | 146 | 1.22617e+16
00:38:00 | 108 | 1.22617e+16
00:40:00 | 64 | 1.22617e+16
00:40:00 | 61 | 1.22617e+16
00:42:00 | 78 | 1.22617e+16
00:44:00 | 95 | 1.22617e+16
00:48:00 | 38 | 1.22617e+16
00:53:00 | 105 | 1.22617e+16
01:03:00 | 63 | 1.22617e+16
01:07:00 | 18 | 1.22617e+16
01:06:00 | 100 | 1.22617e+16
01:10:00 | 98 | 1.22617e+16
01:12:00 | 9
01:14:00 | 111 | 1.22617e+16
01:33:00 | 77 | 1.22617e+16
01:36:00 | 62 | 1.22617e+16
01:38:00 | 157 | 1.22617e+16
01:48:00 | 183 | 1.22618e+16
01:52:00 | 17 | 1.22618e+16
01:53:00 | 105 | 1.22618e+16
01:59:00 | 153 | 1.22618e+16
02:07:00 | 242 | 1.22618e+16
02:12:00 | 87 | 1.22618e+16
02:17:00 | 47 | 1.22618e+16
02:20:00 | 201 | 1.22618e+16
02:26:00 | 58 | 1.22618e+16
02:27:00 | 33 | 1.22618e+16
02:32:00 | 36 | 1.22618e+16
02:33:00 | 57 | 1.22618e+16
02:39:00 | 35 | 1.22618e+16
02:42:00 | 102 | 1.22618e+16
02:48:00 | 85 | 1.22618e+16
02:52:00 | 81 | 1.22618e+16
02:54:00 | 10
02:55:00 | 93 | 1.22618e+16
02:56:00 | 68 | 1.22618e+16
02:59:00 | 105 | 1.22618e+16
03:26:00 | 71 | 1.22618e+16
Spreadsheet: 114162d1309980564-excel-2007-conditional-formatting-formula-problem-workbook1
Sheet: GRPS Output

Product Tracking
 |  |  |  |  |  | 2011 |  |  |  | 2012 |  |  |  | 2013 |  |  |  | 2014 |  |  |  | 2015 |  |  |  | 2016
 |  |  |  |  |  | 2011 | 2011 | 2011 | 2011 | 2012 | 2012 | 2012 | 2012 | 2013 | 2013 | 2013 | 2013 | 2014 | 2014 | 2014 | 2014 | 2015 | 2015 | 2015 | 2015 | 2016 | 2016 | 2016 | 2016
 |  |  |  |  |  | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4 | 1 | 2 | 3 | 4
 |  |  |  |  |  | 1Q | 2Q | 3Q | 4Q | 1Q | 2Q | 3Q | 4Q | 1Q | 2Q | 3Q | 4Q | 1Q | 2Q | 3Q | 4Q | 1Q | 2Q | 3Q | 4Q | 1Q | 2Q | 3Q | 4Q
Launch Year | Launch QTR | Out Year | OUT QTR | Brand | Line Name
2011 | 2 | 2015 | 3 | [NAME] | Super Tractor 2
Spreadsheet: 706693d1606835189-look-for-specific-text-in-a-cell-and-return-that-text-look_for
Sheet: Sheet1

List 1 | List 2 | Look for | Values found in list 1/2
1A-Ax | 4B-Az | Ax
2A-Ay | 5A-Ax | Ay | Ay
3B-Az | 6A-Ax | Az | Az
2A-Ax | 10Ax-1-Bz | Cx | Cx
2A-Ax |  | Cy
16C-Cx |  | Cz
18X-Bx |  | Bx | Bx
 |  | By
 |  | Bz | Bz
Spreadsheet: 82955d1282933331-formula-to-create-a-delivery-schedule-from-table-deliveryschedule
Sheet: Delivery Schedule

2010-08-23 00:00:00 | w/c
FLEX | 1
 | Day |  |  | Monday |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tuesday |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Wednesday |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Thursday |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Friday
 | Shift |  |  | 1 |  |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  | 3 |  |  |  |  |  |  |  | 4 |  |  |  |  |  |  |  | 5 |  |  |  |  |  |  |  | 6 |  |  |  |  |  |  |  | 7 |  |  |  |  |  |  |  | 8 |  |  |  |  |  |  |  | 9 |  |  |  |  |  |  |  | 10 |  |  |  |  |  |  |  | 11 |  |  |  |  |  |  |  | 12 |  |  |  |  |  |  |  | 13 |  |  |  |  |  |  |  | 14
 | MANUAL
 | DELIVERIES | 53138 | H |  |  |  |  |  |  |  |  | 22
 |  | 96484 | L |  |  |  |  | 22
 |  | 55315 | C |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 22 |  |  |  |  |  |  |  |  |  |  |  |  | 22 |  |  |  |  |  |  |  |  | 22 |  |  |  |  |  |  |  |  |  |  |  |  |  | 25
 |  | 96493 | D |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 37 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6
 | [NAME] to return SKU (in COLUMN C), Volume (in BLACK CELLS) and corresponding time. Sorted in ascending chronological order So this entry would look like this----> |  |  |  |  |  |  |  |  | SKU |  |  |  |  |  |  |  |  |  | QUANTITY |  |  |  |  | Delivery Time |  |  |  |  |  |  |  |  | Earliest delivery  Date / Time |  |  |  |  |  |  |  |  | Latest delivery  Date / Time
 | There is space for 15 deliveries. If you have more, just copy the formulas down. Rows 10 and 11 are helper rows. VERY IMPORTANT: these formulas only work for one delivery per time slot.
Spreadsheet: 525433d1498719274-output-a-number-based-on-depth-and-date-when-there-are-overlapping-dates-and-depths-bhaslideexample-bw
Sheet: Sheet1

Date |  | BHA |  | Start Date | End Date | depth in | depth out | BHA #
2017-06-30 00:00:00 | 326 |  |  |  |  | 109 | 723 | 1
2017-07-02 00:00:00 | 1085 |  |  |  |  | 723 | 2390 | 2
2017-07-04 00:00:00 | 1218 |  |  |  |  | 878 | 1668 | 3
2017-07-05 00:00:00 | 2085 |  |  |  |  | 1668 | 2111 | 4
2017-07-08 00:00:00 | 1426 |  |  |  |  | 816 | 2161 | 5
2017-07-10 00:00:00 | 2200 |  |  |  |  | 778 | 2455 | 6
Spreadsheet: 806743d1669550552-populating-cells-with-number-of-hours-taken-during-that-week-book2-update
Sheet: Sheet1

Member | First Day Of Leave | Last Day Of Leave | Hours Per Day | Working Days Taken
[NAME] | 2022-11-21 00:00:00 | 2022-11-30 00:00:00 | 7.5 | 8
[NAME] | 2023-02-13 00:00:00 | 2023-02-14 00:00:00 | 4 | 2
Mark | 2022-01-03 00:00:00 | 2022-01-04 00:00:00 | 4 | 2
f
Spreadsheet: 069e9432-6128-49ac-9493-5b885932c03e
Sheet: York Cty

 |  |  |  |  |  |  | 2013 York County
 | January |  |  |  |  |  | February |  |  |  |  |  | March
 | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr
 |  | 1 | 2 | 3 | 4 |  |  |  |  |  | 1 |  |  |  |  |  | 1
 | 7 | 8 | 9 | 10 | 11 |  | 4 | 5 | 6 | 7 | 8 |  | 4 | 5 | 6 | 7 | 8
 | 14 | 15 | 16 | 17 | 18 |  | 11 | 12 | 13 | 14 | 15 |  | 11 | 12 | 13 | 14 | 15
 | 21 | 22 | 23 | 24 | 25 |  | 18 | 19 | 20 | 21 | 22 |  | 18 | 19 | 20 | 21 | 22
 | 28 | 29 | 30 | 31 |  |  | 25 | 26 | 27 | 28 |  |  | 25 | 26 | 27 | 28 | 29
 | April |  |  |  |  |  | May |  |  |  |  |  | June
 | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr
 | 1 | 2 | 3 | 4 | 5 |  |  |  | 1 | 2 | 3
 | 8 | 9 | 10 | 11 | 12 |  | 6 | 7 | 8 | 9 | 10 |  | 3 | 4 | 5 | 6 | 7
 | 15 | 16 | 17 | 18 | 19 |  | 13 | 14 | 15 | 16 | 17 |  | 10 | 11 | 12 | 13 | 14
 | 22 | 23 | 24 | 25 | 26 |  | 20 | 21 | 22 | 23 | 24 |  | 17 | 18 | 19 | 20 | 21
 | 29 | 30 |  |  |  |  | 27 | 28 | 29 | 30 | 31 |  | 24 | 25 | 26 | 27 | 28
 | July |  |  |  |  |  | August |  |  |  |  |  | September
 | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr
 | 1 | 2 | 3 | 4 | 5 |  |  |  |  | 1 | 2 |  | 2 | 3 | 4 | 5 | 6
 | 8 | 9 | 10 | 11 | 12 |  | 5 | 6 | 7 | 8 | 9 |  | 9 | 10 | 11 | 12 | 13
 | 15 | 16 | 17 | 18 | 19 |  | 12 | 13 | 14 | 15 | 16 |  | 16 | 17 | 18 | 19 | 20
 | 22 | 23 | 24 | 25 | 26 |  | 19 | 20 | 21 | 22 | 23 |  | 23 | 24 | 25 | 26 | 27
 | 29 | 30 | 31 |  |  |  | 26 | 27 | 28 | 29 | 30 |  | 30
 | October |  |  |  |  |  | November |  |  |  |  |  | December
 | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr
 |  | 1 | 2 | 3 | 4 |  |  |  |  |  | 1 |  | 2 | 3 | 4 | 5 | 6
 | 7 | 8 | 9 | 10 | 11 |  | 4 | 5 | 6 | 7 | 8 |  | 9 | 10 | 11 | 12 | 13
 | 14 | 15 | 16 | 17 | 18 |  | 11 | 12 | 13 | 14 | 15 |  | 16 | 17 | 18 | 19 | 20
 | 21 | 22 | 23 | 24 | 25 |  | 18 | 19 | 20 | 21 | 22 |  | 23 | 24 | 25 | 26 | 27
 | 28 | 29 | 30 | 31 |  |  | 25 | 26 | 27 | 28 | 29 |  | 30 | 31
 | Various days throughout month.  [NAME] is subject to change.  Call CPFB with questions [PHONE]. Thank you.
 |  |  | Holiday closures. |  |  |  | Shrewsbury/Red Lion |  |  |  |  | Inventory - warehouse closures.
 |  | York City/York Benevolent Assoc. |  |  |  |  |  | York City Drops |  |  | St. Matthew's Drop Site Pickups
Spreadsheet: 126123d1319538712-excel-2007-list-of-dates-events-and-timeline-book1
Sheet: Sheet1

Date
2008-06-09 00:00:00
2008-06-25 00:00:00
2008-07-03 00:00:00
2008-07-09 00:00:00
2008-07-22 00:00:00
2008-09-09 00:00:00
2008-09-10 00:00:00
2008-09-10 00:00:00
2008-09-10 00:00:00
2008-09-11 00:00:00
2009-10-22 00:00:00
2009-11-07 00:00:00
2009-11-15 00:00:00
2009-11-21 00:00:00
2009-12-04 00:00:00
2010-01-22 00:00:00
2010-01-23 00:00:00
2010-01-23 00:00:00
2010-01-23 00:00:00
2010-01-24 00:00:00
2011-03-06 00:00:00
2011-03-22 00:00:00
2011-03-30 00:00:00
2011-04-05 00:00:00
2011-04-18 00:00:00
2011-06-06 00:00:00
2011-06-07 00:00:00
2011-06-07 00:00:00
2011-06-07 00:00:00
2011-06-08 00:00:00
2012-07-18 00:00:00
2012-08-03 00:00:00
2012-08-11 00:00:00
2012-08-17 00:00:00
2012-08-30 00:00:00
2012-10-18 00:00:00
2012-10-19 00:00:00
Spreadsheet: chris_germany__2034__AppalPay200203
Sheet: CNRVol

802041 | 00003 | BADGER OIL AND GAS CO INC |  | 0 | 2025 | 25
821780 | 00058 | [NAME] INC. |  | 0 | 2549 | 25
805080 | 00081 | HARRIS | J E | 0 | 945 | 25
804452 | 00083 | PAYNE GAS COMPANY |  | 0 | 175 | 25
801852 | 00089 | LITTLETON, EXECUTRIX | [NAME] | 0 | 650 | 25
800785 | 00115 | PUTNAM NATURAL GAS CO.  INC. |  | 0 | 125 | 25
801153 | 00130 | THOMPSON | [NAME] | 0 | 60 | 25
804513 | 00164 | PINE MOUNTAIN OIL AND GAS INC |  | 0 | 3373 | 25
827984 | 00506 | ARIES PETROLEUM CORPORATION |  | 0 | 0 | 25
826176 | 00523 | PINE MOUNTAIN OIL AND GAS INC |  | 0 | 59 | 25
833349 | 00523 | PINE MOUNTAIN OIL AND GAS INC |  | 0 | 0 | 0
800289 | 00552 | JCR PETROLEUM INC. |  | 0 | 83 | 25
833596 | 00552 | JCR PETROLEUM INC. |  | 0 | 469 | 25
833848 | 00552 | JCR PETROLEUM INC. |  | 0 | 780 | 25
800134 | 00612 | [NAME] | WILLIAM T | 0 | 57 | 12.5
800176 | 00612 | [NAME] | WILLIAM T | 0 | 477 | 12.5
834862 | 00618 | STATUS OIL WELLS |  | 0 | 0 | 25
635377 | 00621 | ELTON ENERGY |  | 0 | 234 | 25 | EES
Spreadsheet: 847546d1698416519-gather-information-across-multiple-sheets-where-the-info-may-be-in-different-cells-sample-workbook
Sheet: Sheet2

 |  |  |  |  |  |  |  |  |  |  |  |  |  | Service Order Detailed Analysis Report
 |  |  |  |  | Service Order |  |  |  |  |  |  | 15544213 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | End On Date/ Time |  |  |  |  |  |  |  |  |  |  |  | 2023-10-02 16:41:00
 |  |  |  |  | Primary Technician
 |  |  |  |  | Service Location
 |  |  |  |  | Location Bill To
 |  |  | Service Agreement |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  | Age Of Equipment |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Age Of Home
 |  |  | Reference Number |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Lead Turnover
 |  |  | Quote Signature |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Final Signature
 |  |  |  | Totals
 |  |  |  | Revenue |  |  | Discount |  |  |  |  |  |  |  |  | Sales Tax |  |  |  |  | Total |  |  |  |  | Prepaid Revenue |  |  |  |  |  |  | Inventory |  |  |  |  |  |  |  |  |  |  | Expenses |  |  |  |  |  | Net Revenue
 | Quoted Lines
 | Member Of |  |  |  |  |  |  |  |  | Type |  |  |  |  |  |  |  | Description |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Qty |  |  |  |  |  | Price |  |  |  |  |  |  | Event
 | Performed Lines
 | Type |  |  |  |  | Description |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Qty |  |  |  |  | Price |  |  |  |  |  |  |  | Event |  |  |  |  |  |  | PPEDate
 | Expense Lines
 | Type |  |  |  |  | Date |  |  |  |  |  |  |  |  | Description |  |  |  |  |  |  | Qty |  |  | Cost |  |  |  |  | Event |  |  |  |  |  |  |  | PO |  |  |  |  |  |  |  |  |  | Transferred |  |  |  | PPEDate
 | Purchase Orders
 | PO |  |  |  |  | Vendor |  |  |  |  |  |  |  |  |  |  | Name |  |  |  |  |  |  |  |  |  |  |  | Total |  |  |  |  |  | Event |  |  |  |  |  |  |  |  |  |  | Created On |  |  |  |  | Received On
 | Payments
 | Payment Method |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Amount |  |  | Number |  |  |  |  |  |  |  |  |  |  | Date |  |  |  |  |  |  |  |  | Provider
 | Service Order Notes
 |  |  | Dispatch Notes
 |  | Tech Office Notes
 |  |  |  | Equipment
 |  |  |  | Equipment Name |  |  |  | Age |  |  |  |  | Make |  |  |  |  |  | Model |  |  |  |  | Serial Number |  |  |  |  |  |  | Install |  |  |  |  |  |  |  |  |  | Warranty Name |  |  |  |  |  |  |  |  |  |  |  | Warranty End
 |  |  |  | WATER HEATER - ELECTRIC |  |  |  | 0 |  |  |  |  | Rheem |  |  |  |  |  | XE50M12CS55U1 |  |  |  |  | Q242320161 |  |  |  |  |  |  | 2023-10-02 04:00:00
Spreadsheet: 675848d1588523007-pull-column-values-from-another-sheet-that-are-in-the-current-sheet-sample_miss-val
Sheet: Sheet B

VALUE C | VALUE B | VALUE D | VALUE E | VALUE F
A1 | B1 | D1 | E1 | E1
A2 | B2 | D2 | E2 | E2
A3 | B3 | D3 | E3 | E3
A4 | B4 | D4 | E4 | E4
A5 | B5 | D5 | E5 | E5
A6 | B6 | D6 | E6 | E6
A7 | B7 | D7 | E7 | E7
A8 | B8 | D8 | E8 | E8
A9 | B9 | D9 | E9 | E9
A10 | B10 | D10 | E10 | E10
A11 | B11 | D11 | E11 | E11
A12 | B12 | D12 | E12 | E12
A13 | B13 | D13 | [NAME]
A14 | B14 | D14
A15 | [NAME]
Spreadsheet: tracy_geaccone__40235__enron corp infomation request-egas
Sheet: EGS IS

$Millions |  | September
Gross Margin by Business Unit |  | Year-to-Date
ETS
EGAS |  | 332.9 |  | This represent total EGA consolidated which included consolidated operating projects
PGE
EOTT
EREC
Azurix/Wessex
EEOS
Other
Total Gross Margin
Operating Expenses |  | -256.9
Depreciation and Amortization |  | -102.9
Taxes Other Than Income |  | -13.9
Other Income (Loss) |  | 153.8 |  | Include equity earnings of $128M
Income / (Loss) Before Interest & Taxes
(3)
Spreadsheet: 84321d1284383224-index-match-problem-for-multiple-matches-index
Sheet: Sheet3

 | SUN | MON | TUE | WED | THU | FRI | SAT
JANUARY |  |  |  |  |  | 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 | 30
FEBRUARY | 31 | 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
[NAME] |  | 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 | 30 | 31
APRIL |  |  |  |  | 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 | 30
MAY |  |  |  |  |  |  | 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
[NAME] | 30 | 31 | 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 | 30
2010
 | SUN | MON | TUE | WED | THU | FRI | SAT
 |  |  |  |  | 1 | 2 | 3 | JULY
 | 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 | 30 | 31
 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | AUGUST
 | 8 | 9 | 10 | 11 | 12 | 13 | 14
 | 15 | 16 | 17 | 18 | 19 | 20 | 21
 | 22 | 23 | 24 | 25 | 26 | 27 | 28
 | 29 | 30 | 31
 |  |  |  | 1 | 2 | 3 | 4 | SEPTEMBER
 | 5 | 6 | S5, L1 | b1-7 | 9 | 10 | 11
 | 12 | 13 | 14 | 15 | 16 | 17 | 18
 | 19 | 20 | 21 | 22 | 23 | 24 | 25
 | 26 | 27 | 28 | 29 | 30
 |  |  |  |  |  | 1 | 2 | OCTOBER
 | 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 | 30
 | 31 | 1 | 2 | 3 | 4 | 5 | 6 | NOVEMBER
 | 7 | 8 | 9 | 10 | 11 | 12 | 13
 | 14 | 15 | 16 | 17 | 18 | 19 | 20
 | 21 | 22 | 23 | 24 | 25 | 26 | 27
 | 28 | 29 | 30
 |  |  |  | 1 | 2 | 3 | 4 | DECEMBER
 | 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 | 30 | 31
Spreadsheet: 67852d1268368310-return-sales-for-specified-month-and-department-examples
Sheet: Table

 | Member
 | No. | Name | Type | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00
 | 222 | [NAME] | [NAME] | 1 | 5 | 6 | 4 | 3 | 7
 | 456 | [NAME] | [NAME] | 4 | 9 | 5 | 3 | 1 | 7
 | 843 | [NAME] | Ladies | 5 | 6 | 9 | 8 | 1 | 3
 | 359 | [NAME] | [NAME] | 8 | 7 | 3 | 5 | 4 | 1
 | 320 | [NAME] | Ladies | 3 | 4 | 3 | 6 | 5 | 4
Spreadsheet: 118363d1313622314-countif-or-a-better-solution-time_count
Sheet: Sheet1

Time | Orders |  |  | Time Period | Calls | Orders
09:00:00 | 1 |  |  | 00:00 - 00:59
09:23:00 | 3 |  |  | 01:00 - 01:59
11:25:00 | 1 |  |  | 02:00 - 02:59
12:05:00 | 1 |  |  | 03:00 - 03:59
13:06:00 | 4 |  |  | 04:00 - 04:59
14:12:00 | 1 |  |  | 05:00 - 05:59
14:14:00 | 1 |  |  | 06:00 - 06:59
15:26:00 | 1 |  |  | 07:00 - 07:59
15:40:00 | 2 |  |  | 08:00 - 08:59
16:02:00 | 1 |  |  | 09:00 - 09:59
17:26:00 | 1 |  |  | 10:00 - 10:59
18:30:00 | 7 |  |  | 11:00 - 11:59
18:58:00 | 1 |  |  | 12:00 - 12:59
19:33:00 | 1 |  |  | 13:00 - 13:59
19:59:00 | 5 |  |  | 14:00 - 14:59
20:39:00 | 1 |  |  | 15:00 - 15:59
 |  |  |  | 16:00 - 16:59
 |  |  |  | 17:00 - 17:59
 |  |  |  | 18:00 - 18:59
 |  |  |  | 19:00 - 19:59
 |  |  |  | 20:00 - 20:59
 |  |  |  | 21:00 - 21:59
 |  |  |  | 22:00 - 22:59
 |  |  |  | 23:00 - 23:59
 |  |  |  | Total