tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 715768d1611856027-formula-to-show-if-data-is-consecutive-or-intermittent-example
Sheet: Sheet1

Month1 | Month2 | Month3 | Month4 | Month5 | Result
1 | 1 |  |  | 2 | Intermittent
1 | 2 | 1 | 3 | 1 | Consecutive
 | 1 | 3 | 1 |  | Consecutive
1 |  | 1 |  | 1 | Intermittent
Spreadsheet: 130228d1322136024-rank-text-by-number-of-appearance-top3mostoccuring
Sheet: Sheet1

 |  |  |  |  | Top 3 most occuring strings |  |  | [NAME]
 |  |  |  |  |  |  |  | Name_1
 | Name_1 |  |  |  |  |  |  | Name_2
 | Name_2 |  |  |  |  |  |  | Name_4
 | Name_2
 | Name_4
 | Name_1
 | Name_2
 | Name_7
 | Name_8
 | Name_9
 | Name_1
 | Name_11
 | Name_2
 | Name_4
 | Name_14
 | Name_3
 | Name_16
 | Name_17
 | Name_1
 | Name_19
 | Name_20
Spreadsheet: mary_fischer__25719__PRM-Ptshp PhoneList
Sheet: Sheet1

PRM/PARTNERSHIPS Phone List
NAME | EXT. | LOC. | Shift | TITLE | HOME | D.O.B
PRM/PARTNERSHIPS |  |  |  |  |  | Fax: [PHONE]
Ashton, [NAME] | x5-7250 | 1719d | Reg | Tax Specialist | [PHONE] | 2001-11-28 00:00:00
Caminos, [NAME] | x5-4771 | 1730a | 2 | Tax Analyst | [PHONE] | 2001-03-31 00:00:00
[NAME], [NAME] (Helen) | x5-4518 | 1705b | 2 | Tax Analyst | [PHONE] | 2001-11-19 00:00:00
Fischer, [NAME] | x3-5449 | 1715d | 2 | Supervisor | [PHONE] | 2001-10-20 00:00:00
[NAME], [NAME] | x3-0341 | 1714a | 1 | Tax Analyst | [PHONE] | 2000-06-28 00:00:00
Hall,Heather | X5-7982 | 1715f | 2 | Tax Analyst | [PHONE] | 2001-01-17 00:00:00
[NAME], [NAME] | x5-6317 | 1715c | 1 | Tax Specialist | [PHONE] | 2001-12-15 00:00:00
Mathew-Joy, [NAME] | x5-8337 | 1727b | 1 | Tax Specialist | [PHONE] | 2001-11-26 00:00:00
Matthews, Jackie | x5-4720 | 1782a | 1 | Tax Analyst | [PHONE] | 2001-06-27 00:00:00
Merritt, [NAME] | x5-3862 | 1710b | 2 | Tax Analyst | [PHONE] | 2001-09-12 00:00:00
Ng, [NAME] | x3-3205 | 1720 | 1 | Manager | [PHONE] | 2000-12-04 00:00:00
Nugent, Caroline | x3-0910 | 1725 | 1 | Manager | [PHONE] | 2000-06-17 00:00:00
Ramsey, [NAME] | x5-4413 | 1704a | 2 | Tax Analyst | [PHONE] | 2001-11-14 00:00:00
Reyna, Selma | x3-1765 | 1727a | Reg | Asst.Admin II | [PHONE] | 1975-09-14 00:00:00
Richards, Todd | x5-3522 | 1715b | 2 | Sr. Tax Analyst | [PHONE] | 2001-07-12 00:00:00
Swafford, [NAME] | x3-6124 | 1724 | 2 | Sr. Director | [PHONE] | 2000-12-31 00:00:00
Zhang, [NAME] | x3-5735 | 1715e | 2 | Sr. Tax Analyst | [PHONE] | 2001-01-20 00:00:00
Zarate, [NAME] | x5-6883 | 1729 | Reg | Student Learner | [PHONE] | 2001-12-10 00:00:00
BUSINESS  ANALYSIS & REPORTING
Burgess,  [NAME] | x5-5045 | 3AC1352 | 2 | Director | [PHONE] | 2001-09-07 00:00:00
Eggebrecht, Kurt | x3-3979 | 1734 | 1 | Director | [PHONE] | 2001-06-19 00:00:00
Esperance, [NAME] | x5-5650 | 3ac1359a | 1 | Tax Specialist | [PHONE] | 2001-08-08 00:00:00
Guthrie, [NAME] | x3-9605 | 1726 | Reg | Director | [PHONE] | 2001-09-18 00:00:00
[NAME], [NAME] | x5-8276 | 1734 | 2 | Director | [PHONE] | 2001-07-04 00:00:00
Kent, [NAME] | x5-4774 | 1714c | 2 | Sr. Tax Specialist | [PHONE] | 2001-11-08 00:00:00
Locklear, [NAME] | x3-9701 | 1762 | 2 | Director | [PHONE] | n/a
[NAME], [NAME] | x6-6011 | 3ac1349 | 2 | Tax Clerk | [PHONE] | 2001-09-25 00:00:00
Sharp, [NAME] | x3-0931 | 1742c | 2 | Tax Specialist | [PHONE] | 2001-05-08 00:00:00
Smith, [NAME] | x6-6141 | 3ac1359 | Reg | Contractor | N/A | 2001-04-27 00:00:00
Ware, [NAME] | x5-6594 | 3ac1364 | Reg | Director | [PHONE] | 2001-08-09 00:00:00
[NAME], [NAME] | x 3-6432 | 1738 | Reg | Director | [PHONE] | 2001-10-06 00:00:00
INTERNS
HR REPS
[NAME] | x5-7809 | 1029
[NAME] | x3-9058 | 1751c
Clerks
[NAME] |  |  | [NAME]
West, [NAME] |  |  | [NAME], [NAME]
TREASURY DEPT.
[NAME] |  | **[NAME]
VENDOR SET UP HOT-LINE - 3-7373
*[NAME] | x3-6382 |  | x5-7706 | Helena Payne | Chely Mondragon | x3-7227
[NAME] | x3-3505 |  | x3-3067 | [NAME]
AP Hotline: x3-7127 | Resolution Center  x3-1411 |  | Computer Help: x3-4727 |  | Phone Help x3-1717 | SAP Help 5-4727
Spreadsheet: 707053d1607014804-index-match-vlookup-type-formula-off-of-drop-down-menu-named-range-retail-test-spreadsheet
Sheet: Ralston

Pad | ASW# | Brand | Vtg | Product | Pk | Size | UPC | Type |  | Auth Note | Vdr Rpt $ | ED Cost | [NAME] | ED Margin | TPR Cost | [NAME] | TPR Margin | [NAME] | Plan Dates | Temp / Sale Cost | Temp / Sale Retail | Temp / Sale Margin | Temp / Sale Date | [NAME] | [NAME] | Var Date | Online Price | Ck Date | Notes | Plan | Cost Adj | Retail | Margin
VTG | 01452397 |  | NV | ABC Wine | 12 | 750ml | [PHONE] |  |  |  |  | 2.5 | 6.99 |  | 1.5 | 6.99 |  | Feb20
VTG | 67638396 |  | [NAME] | [NAME] | 12 | 750ml | [PHONE] |  |  |  |  | 4.5 | 8.99 |  | 3.5 | 8.99
VTG | 09850396 |  | XX-2018 | [NAME] | 12 | 750ml | [PHONE] |  |  |  |  | 5.5 | 9.99 |  | 4.5 | 9.99 |  | Apr20
VTG | 09857396 |  | XX-2018 | MNO Wine | 12 | 750ml | [PHONE] |  |  |  |  | 6.5 | 10.99 |  | 5.5 | 10.99
VTG | 09855396 |  | 2017 | PQR Wine | 12 | 750ml | [PHONE] |  |  |  |  | 7.5 | 11.99 |  | 6.5 | 11.99 |  | Jun20
PLT | 60629396 |  | XX-2016 | STU Wine | 12 | 750ml | [PHONE] |  |  |  |  | 8.5 | 12.99 |  | 7.5 | 12.99
PMR | 81585404 |  |  | VWX Wine | 12 | 750ml | [PHONE] |  |  |  |  | 9.5 | 13.99 |  | 8.5 | 13.99 |  | Aug20
Spreadsheet: 2988a443-321b-44a1-8851-f68dd179b22a
Sheet: Sheet1

Unnamed: 0 | Permit No.: | WQ0014091 | Unnamed: 3 | Facility Name: | Unnamed: 5 | White Oak Trailer Wash Facility | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | County: | Unnamed: 13 | Duplin | Unnamed: 15 | Month: | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Year: | Unnamed: 21
 |  | Field Name: |  | 1 |  | Field Name: |  | 2 |  | Field Name: |  | 3 |  | Field Name: |  | 4 |  | Field Name: |  | 5
 |  | Area (acres): |  | 2.22 |  | Area (acres): |  | 3.56 |  | Area (acres): |  | 3.81 |  | Area (acres): |  | 3.94 |  | Area (acres): |  | 3.3
 |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop:
 |  | Load Type: |  | PAN |  | Load Type: |  | PAN |  | Load Type: |  | PAN |  | Load Type: |  | PAN |  | Load Type: |  | PAN
 |  | [NAME]? |  |  |  | [NAME]? |  |  |  | [NAME]? |  |  |  | [NAME]? |  |  |  | [NAME]?
 | Date | Volume Applied | Average PAN Concentration | Monthly PAN Load | Cumulative PAN Load | Volume Applied | Average PAN Concentration | Monthly PAN Load | Cumulative PAN Load | Volume Applied | Average PAN Concentration | Monthly PAN Load | Cumulative PAN Load | Volume Applied | Average PAN Concentration | Monthly PAN Load | Cumulative PAN Load | Volume Applied | Average PAN Concentration | Monthly PAN Load | Cumulative PAN Load
 | Month | gal | mg/L | lbs/ac | lbs/ac | gal | mg/L | lbs/ac | lbs/ac | gal | mg/L | lbs/ac | lbs/ac | gal | mg/L | lbs/ac | lbs/ac | gal | mg/L | lbs/ac | lbs/ac
 | 12 Month Floating PAN Load (lbs/ac/yr):
 | Annual PAN Load Limit (lbs/ac/yr):
Spreadsheet: 328377d1403881528-football-predictor-football-prediction-fixed-copy
Sheet: Leaderboard

 | Position | Name | Total | week 23 | week 24 | week 25 | week 26 | week 27 | week 28 | week 29 | week 30 | week 31 | week 32 | week 33 | week 34 | week 35 | week 36 | week 37 | week 38
 | 1
 | 2
 | 3
 | 4
 | 5
 | 6
Spreadsheet: 105533d1302854473-updating-the-changing-price-of-product-by-date-murphree-5-5h8-volume-accounting-sheet-in-edit-2
Sheet: Diesel

Diesel Cost and Usage |  |  |  |  |  |  |  | Diesel Loads
Report # | Date | Daily Diesel  Used (gal) | Current Cost of Diesel | Daily  Diesel  Cost | Daily Product  Cost |  |  | Number  of Loads | Date | Diesel Price | Gallons  Delivered
1 | 2011-03-29 00:00:00 |  | 3.29 | 0 | 2434.09 |  |  | 1 | 2011-03-30 00:00:00 | 3.27 | 3502
2 | 2011-03-30 00:00:00 | 1169 | 3.27 | 3822.63 | 6065.67 |  |  | 2 | 2011-03-31 00:00:00 | 3.26 | 2500
3 | 2011-03-31 00:00:00 | 941 | 3.26 | 3067.66 | 5626.44 |  |  | 3 | 2011-04-04 00:00:00 | 3.37 | 6907
4 | 2011-04-01 00:00:00 | 1932 | 3.26 | 6298.32 | 14668.47 |  |  | 4 | 2011-04-06 00:00:00 | 3.42 | 1000
5 | 2011-04-02 00:00:00 | 1428 | 3.26 | 4655.28 | 11692.69 |  |  | 5 | 2011-04-08 00:00:00 | 3.29 | 1000
6 | 2011-04-03 00:00:00 | 2379 | 3.26 | 7755.54 | 12609.01 |  |  | 6
7 | 2011-04-04 00:00:00 | 4132 | 3.37 | 13924.84 | 9105.32 |  |  | 7
8 | 2011-04-05 00:00:00 | 1 | 3.37 | 3.37 |  |  |  | 8
9 | 2011-04-06 00:00:00 | 1 | 3.42 | 3.42 |  |  |  | 9
10 | 2011-04-07 00:00:00 | 1 | 3.42 | 3.42 |  |  |  | 10
11 | 2011-04-08 00:00:00 | 1 | 3.29 | 3.29 |  |  |  | 11
12 | 2011-04-09 00:00:00 | 1 | 3.29 | 3.29 |  |  |  | 12
13 | 2011-04-10 00:00:00 | 3000 | 3.29 | 9870 |  |  |  | 13
14 | 2011-04-11 00:00:00 |  |  |  |  |  |  | 14
15 | 2011-04-12 00:00:00 |  |  |  |  |  |  | 15
16 | 2011-04-13 00:00:00 |  |  |  |  |  |  | 16
17 | 2011-04-14 00:00:00 |  |  |  |  |  |  | 17
18 | 2011-04-15 00:00:00 |  |  |  |  |  |  | 18
19 | 2011-04-16 00:00:00 |  |  |  |  |  |  | 19
20 | 2011-04-17 00:00:00 |  |  |  |  |  |  | 20
21 | 2011-04-18 00:00:00 |  |  |  |  |  |  | 21
22 | 2011-04-19 00:00:00 |  |  |  |  |  |  | 22
23 | 2011-04-20 00:00:00 |  |  |  |  |  |  | 23
24 | 2011-04-21 00:00:00 |  |  |  |  |  |  | 24
25 | 2011-04-22 00:00:00 |  |  |  |  |  |  | 25
26 | 2011-04-23 00:00:00 |  |  |  |  |  |  | Total  Delivered |  |  | 14909
27 | 2011-04-24 00:00:00
28 | 2011-04-25 00:00:00
29 | 2011-04-26 00:00:00
30 | 2011-04-27 00:00:00 |  |  |  |  |  | For Diesel loads to calculate the proper amount of diesel we must measure
Totals |  | 14986 |  | 49411.06 | 62201.69 |  | diesel levels before and after to have a proper strap on diesel received.
DIESEL & PRODUCT TOTAL |  |  |  |  | 111612.75
Spreadsheet: 153226d1335808828-making-a-schedule-with-auto-time-format-and-adding-total-hours-se-schedule
Sheet: JUNE 6

 | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
 | 2011-06-06 00:00:00 | 2011-06-07 00:00:00 | 2011-06-08 00:00:00 | 2011-06-09 00:00:00 | 2011-06-10 00:00:00 | 2011-06-11 00:00:00
[NAME] |  | 9:30-5:30 | 8:00-5:00 | 8:00-5:00 | 8:30-5:30 | 9:00-4:00 | 38
 | off | 12:00-1:00 | 12:00-1:00 | 12:00-1:00 | 12:00-1:00 | 12:00-1:00
[NAME] | 8:30-5:30 | 8:30-5:30 | 9:30-5:30 | 8:30-5:30 | 9:30-5:30 | off | 38
 | 2:00-3:00 | 2:00-3:00 | 2:00-3:00 | 2:00-3:00 | 2:00-3:00 | off
Ray | 8:00-5:00 | 8:00-5:00 | 8:00-4:00 | 7:00-4:00 | 8:00-4:00 |  | 38
 | 12:00-1:00 | 12:00-1:00 | 12:00-1:00 | 12:00-1:00 | 12:00-1:00 | off
Mark | 8:30-5:30 | 9:00-4:00 | 8:30-5:30 | 8:30-5:30 | off | 9:00-5:15 | 38
 | 1:00-2:00 | 1:00-2:00 | 1:00-2:00 | 1:00-2:00 | off | 1:00-2:15
[NAME] | 8:00-4:00 | off | 8:30-5:30 | 7:00-4:00-HOMER | 8:00-5:00 | 9:15-5:15-ctr | 38
 | 11:00-12:00 | off | 11:00-12:00 | 1ub | 11:00-12:00 | 11:00-12:00
Kat |  |  | 8:00-5:00 |  |  | 9:00-4:00 | 14
 |  |  | 12:00-1:00 |  |  | 12:00-1:00
 |  |  | 12:00-1:00
 |  |  |  |  |  | total hours | 204
Spreadsheet: 818303d1676722627-model-with-weights-trying-to-perform-2m-vlookups-model-and-weights-query
Sheet: Sheet1

uuid | Segment | Answer 1 | Answer 2 | Answer 3 | Answer 4 | Answer 5 | Answer 6 | Answer 7 | Answer 8 | Answer 9 | Answer 10 | Answer 11 | Answer 12 | Answer 13 | Answer 14 | Answer 15 | Answer 16 | Answer 17 | Answer 18 | Answer 19 | Answer 20 | Answer 21 | Answer 22 | Answer 23 | Answer 24 | Answer 25 | Answer 26 | Answer 27 | Answer 28 | Answer 29 | Answer 30 | Answer 31 | Answer 32 | Answer 33 | Answer 34 | Answer 35 | Answer 36 | Answer 37 | Answer 38 | Answer 39 | Answer 40 | Answer 41 | Answer 42 | Answer 43 | Answer 44 | Answer 45 | Answer 46 | Answer 47 | Answer 48 | Answer 49 | Answer 50 | Answer 51 | Answer 52 | Answer 53 | Answer 54 | Answer 55 | Answer 56 | Answer 57 | Answer 58 |  | Personality 1 | Answer 1 | Answer 2 | Answer 3 | Answer 4 | Answer 5 | Answer 6 | Answer 7 | Answer 8 | Answer 9 | Answer 10 | Answer 11 | Answer 12 | Answer 13 | Answer 14 | Answer 15 | Answer 16 | Answer 17 | Answer 18 | Answer 19 | Answer 20 | Answer 21 | Answer 22 | Answer 23 | Answer 24 | Answer 25 | Answer 26 | Answer 27 | Answer 28 | Answer 29 | Answer 30 | Answer 31 | Answer 32 | Answer 33 | Answer 34 | Answer 35 | Answer 36 | Answer 37 | Answer 38 | Answer 39 | Answer 40 | Answer 41 | Answer 42 | Answer 43 | Answer 44 | Answer 45 | Answer 46 | Answer 47 | Answer 48 | Answer 49 | Answer 50 | Answer 51 | Answer 52 | Answer 53 | Answer 54 | Answer 55 | Answer 56 | Answer 57 | Answer 58
[NAME] | A | N | Y | Y | Y | N | Y | Y | N | N | N | N | Y | Y | Y | N | Y | Y | N | N | N | N | Y | Y | Y | N | Y | Y | N | N | N | N | Y | Y | Y | N | Y | Y | N | N | N | N | Y | Y | Y | N | Y | Y | N | N | N | N | Y | Y | Y | N | Y | Y | N
9ue5mfpmxp50srzf | B | Y | N | Y | Y | N | N | Y | Y | N | N | Y | N | Y | Y | N | N | Y | Y | N | N | Y | N | Y | Y | N | N | Y | Y | N | N | Y | N | Y | Y | N | N | Y | Y | N | N | Y | N | Y | Y | N | N | Y | Y | N | N | Y | N | Y | Y | N | N | Y | Y
xfdxay29z555pvb4 | C | N | N | N | Y | N | N | Y | Y | N | Y | N | N | N | Y | N | N | Y | Y | N | Y | N | N | N | Y | N | N | Y | Y | N | Y | N | N | N | Y | N | N | Y | Y | N | Y | N | N | N | Y | N | N | Y | Y | N | Y | N | N | N | Y | N | N | Y | Y
Spreadsheet: 674187d1587707614-calculating-values-depending-on-variable-suppliers-new-daily-costings-sample-beamer-2-
Sheet: Rates

 | Supplier | Shift | Resource
 |  | [NAME] | Product 1 | Product 2 | Product 3 | Product 4 | Product 5 | Product 6 | Product 7 | Product 8 | Product 9 | Product 10 | Product 11
Supplier 1Day | Supplier 1 | Day | 134.5 | 93 | 51.5 | 41 | 116 | 41 | 76 |  |  | 100
Supplier 1Night |  | Night | 176.4 | 123.2 | 66 | 56 | 131 | 66 | 90 |  |  | 100
Supplier 1Weekend |  | Weekend | 211 | 144 | 77 | 67 | 142 | 77 | 102 |  |  | 100
Supplier 2Day | Supplier 2 | Day | 120 | 100 | 45 | 50 | 130 | 130 | 100 | 450 | 500 | 1300 | 200
Supplier 2Night |  | Night | 180 | 110 | 70 | 55 | 140 | 170 | 105 | 700 | 550 | 1400 | 300
Supplier 2Weekend |  | Weekend | 210 | 150 | 80 | 75 | 145 | 210 | 105 | 800 | 750 | 1450 | 350
Supplier 3Day
Supplier 3Night
Supplier 3Weekend
Supplier 4Day
Supplier 4Night
Supplier 4Weekend
Supplier 5Day
Supplier 5Night
Supplier 5Weekend
Supplier 6Day
Supplier 6Night
Supplier 6Weekend
Spreadsheet: 886148d1736183624-sorting-data-from-a-dynamic-list-jeffcmusic-excel-help-tms
Sheet: Stop List

 | STOP NUMBER |  | BUS STOP NAME | ON STREET / ROAD | POINT LETTER | ROUTES | Closure Type
 | 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
 | 32
 | 33
 | 34
 | 35
 | 36
 | 37
 | 38
 | 39
 | 40
 | 41
 | 42
 | 43
 | 44
 | 45
 | 46
 | 47
 | 48
 | 49
 | 50
 | 51
 | 52
 | 53
 | 54
 | 55
 | 56
 | 57
 | 58
 | 59
 | 60
Spreadsheet: f992d3a0-399f-4a9b-bd08-01ca08d3c8f8
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
FEWS | Test | FEWS | Ewing Sarcoma (EWS) 22q12 Rearrangement, FISH, Tissue | EWSR1, 22q12, FISH | Fluorescence In Situ Hybridization (FISH) |  |  |  |  |  | Please provide a pathology report with each specimen. The laboratory will not reject a specimen that arrives without this information but will hold the specimen until a pathology report is received.   Submit only 1 of the following specimens:   Container/Tube: Preferred: Formalin-fixed, paraffin-embedded tumor tissue block and 1 hematoxylin and [NAME] (H and E)-stained slide Acceptable: Four consecutive, unstained, 5 micron-thick sections placed on positively-charged slides and 1 H and E-stained slide Forms: If not ordering electronically, complete and submit a Hematopathology/Molecular Oncology Request Form (Supply T241) with the specimen. | 2 unstained slides and 1 hematox | Note: No specimen should be rejected. If specimen not received at appropriate temperature or in wrong anticoagulant, include note to laboratory. If questions, contact laboratory. | An interpretive report will be provided. | Samples processed Monday through Sunday. Results reported Monday through Friday 8am-5pm CST | 7 days | 10 days |  | Profile |  |  |  |  | Rochester
FEWS | [NAME] | TISSUE | Tissue |  |  |  | Ambient
FEWS | Order Question | CG072 | Reason For Referral |  | Plain Text
FEWS | Result | 22657 | [NAME] | [NAME] | Alphanumeric
FEWS | Result | 22658 | [NAME] | [NAME] | Alphanumeric
FEWS | Result | 22659 | Source | Source | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31208-2 | [NAME] source:Prid:Pt:[NAME]:Nom:
FEWS | Result | 22660 | Order Date | Order Date | Alphanumeric
FEWS | Result | CG072 | Reason For Referral | Reason For Referral | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42349-1 | Reason for referral:Find:Pt:^Patient:Nar:
FEWS | Result | 22661 | Method | Method | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 49549-9
FEWS | Result | 22663 | Results | Results | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 21783-6 | Cells.t(12,22)(ATF1,EWSR1)/Cells.total:NFr:Pt:Bld/Tiss:Qn:Molgen
FEWS | Result | 22664 | Interpretation | Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 69965-2
FEWS | Result | 22665 | Amendment | Amendment | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
FEWS | Result | 22666 | Consultant | Consultant | Alphanumeric
FEWS | Result | 22667 | Report Date | Report Date | Alphanumeric
Spreadsheet: 124305d1318322670-skipping-empty-cells-and-putting-a-list-together-remove-blanks-demo
Sheet: Sheet1

Data List | Unique Values | Listed | List from Formula > | Unique Values | Unique Values |  | List from Paste Values > | Unique Values | Unique Values |  | List with empty cells cleared > | Unique Values | Unique Values
Blue |  | Blue |  |  |  |  |  |  |  |  |  |  | Blue
Blue |  | Red |  |  |  |  |  |  |  |  |  |  | Red
Red |  | Green |  |  |  |  |  |  |  |  |  |  | Green
Blue | Blue | Yellow |  | Blue | Blue |  |  | Blue | Blue |  |  | Blue | Yellow
Green |  | Purple |  |  |  |  |  |  |  |  |  |  | Purple
Red | Red |  |  | Red | Unique Values |  |  | Red | Unique Values |  |  | Red
Green |  |  |  |  | Blue |  |  |  | Blue
Green | Green |  |  | Green | Red |  |  | Green | Red |  |  | Green
Yellow |  |  |  |  | Green |  |  |  | Green
Yellow | Yellow |  |  | Yellow | Yellow |  |  | Yellow | Yellow |  |  | Yellow
Purple | Purple |  |  | Purple | Purple |  |  | Purple | Purple |  |  | Purple
Spreadsheet: 102010d1300082262-stacked-bar-chart-columns-are-in-reverse-order-sample
Sheet: Calculator

 | Sample data set
 | Data is dynamically created, with a variable number of "series" which is why in this sample there are "blanks"
 |  | Time1 | Time2 | Time3
 | A Series | 2 | 3 | 4
 | B Series | 3 | 4 | 5
 | C Series | 5 | 6 | 7
 | Blank
 | Blank
 | Blank
 | The next 2 charts show how I'm trying to display the data
 | First, is a pie chart showing "time zero" values in pie form in order to show the relative starting amounts. Next to the pie is the ledgend in the same order as the data set.
 | Second, is a stacked column chart showing the amounts by time moving forward. I want the top column item to be the 1st series, and the bottom column item to be the last series.
 | The issue is 1) the column chart appers in reverse order from the data set and 2) is backwards from the ledgend in the pie chart, the "blanks" also appear at the top of the ledgend.
 | I'd like the column chart to 1) match the data set order 2) match the ledgend in the pie chart 3) automatically match the colors in the pie chart |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | i.e. Look like this, except I want the colors to match.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | But if I make a "reversed" data set, the colors no longer match |  |  |  |  |  |  |  |  | Time1 | Time2 | Time3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Blank
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Blank
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Blank
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | C Series | 5 | 6 | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | B Series | 3 | 4 | 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A Series | 2 | 3 | 4
 | With "Value in Reverse Order" |  |  |  |  |  |  |  | With "Maximum axis value"
Spreadsheet: john_griffith__15827__Daily Settles
Sheet: Sheet1

Today's Settles
$5 Swaption on CY 02 |  | 0
Cal 02 |  | 3.154
$6 Calls on Q1 02 |  | .035 @ .055 | 8 delta
$5.25 Calls on Cal 02 |  | .09 @ .11 | 16 delta
Jan 02 3.50 Calls |  | .25 @ .27 | 42 delta
Dec 01 $2.25 Puts (Gas Daily) |  | .10 @ .12 | -18 delta
Dec 01 $3.50 Calls (Gas Daily) |  | .20 @ .22 | 35 delta
Spreadsheet: darrell_schoolcraft__7640__OutageRequest 401 for 040102
Sheet: Sheet1

Enron Transportation Services
System Outage Request/Notification
 |  |  |  |  |  | Submittal Date: ____ | 2002-01-11 00:00:00
 |  |  |  | Planned: X |  | Late: | Unplanned:
 | Region/Location: |  | [NAME] 4
 | Reported By: |  | [NAME] |  |  |  |  | New: | x | Revised
 | Telephone No: |  | [PHONE] or3038 |  |  | If a Revision Enter outage ID#
 |  |  |  |  |  | or the Original Est. Start Date
 | FAX No: |  | [PHONE]
 | Starting Date: |  | 2002-04-01 00:00:00 | Time: | 08:00 | Completion Date: |  | 2002-04-07 00:00:00 | Time: | 18:00
 | Descripition of Work: |  |  | ESD the station for our annual test, start unit 402 and403 up.  Unit 401 will have all main bearing , 2 pistons and liners changed, both aftercoolers, all fuel valves, lifters,spark plugs , finfan motors , [NAME], compressor rods and pistons an
 | Facilities Affected
 | Compressor Station: |  | Station 4 ([NAME]) |  |  |  |  | Estimated Volume: |  | 250 to 400 mcf
 |  | Units: | Unit 401 |  |  |  |  | Horse Power: |  | 4000hp
 | Services Affected
 | Mainline: |  | na |  |  |  |  | Aprox. [NAME]: |  | na
 | Branchline/Transmission: |  | na |  |  |  | Reduced Operation Pressure: |  |  | na
 |  | TBS: |  |  |  |  |  | Farmtap: |  | na
 | Comments: |  | This is part of our annual April outage.
 | All Outages Fax Or E:mail To   ([NAME]) |  |  |  | fax# (713)-345-3478   Houston
 | Facility Planning               (Outage Coordinator) |  |  |  |  | fax# (402)-3987041     Omaha
 | For Unplanned Outages Add these Burst FAX Numbers ( Project Link):
 | ( For unplanned outages in the [NAME], Liberal, Mullinville & Amarillo Regions Only)
 | Oneok - Tulsa |  | [NAME] |  |  | (918) 732-1355 |  | ET&S Gas Control (Houston): |  |  | 7138539155
 | Oneok - Bushton |  | [NAME] |  |  | (316) 562-4373 |  | ET&S [NAME]: |  |  | 7136468000
 | Exxon-Mobil-Liberal |  | Ulysses |  |  | (316) 356-7580
 |  |  |  |  |  |  |  | Anadarko: |  |  | 3166294505
 | OXY-Liberal |  | [NAME] |  |  | (316) 624-7014
 | ETS - Liberal Operatons |  |  |  |  | (316) 626-2251