tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: e5702996-71be-4af6-ad7f-ab69db36f2ed
Sheet: CHINA

CHINA | Unshipped Balance |  | Accumulated Exports |  | Total Commitments
EXPORT SALES, Egypt | this year | last year | this year | last year | this year | last year
2013-05-23 00:00:00 | 58.4 | 55.8 | 740.4 | 534.3 |  |  | 1443.2
 | 57 | 55.8 | 741.8 | 534.3 |  |  | 1464
 | 1465.3 | 167 | 57.8 | 57.8
 | 1498.3 | 281.5 | 115.6 | 57.8
 | 1473.8 | 280 | 115.6 | 59.2
 | 1480.1 | 277.5 | 348.6 | 61.8
 | 2329 | 274.3 | 523.4 | 64.9
 | 2741 | 273.5 | 531.4 | 65.8
 | 2847.1 | 272 | 603.2 | 67.2
 | 2790.7 | 213.6 | 789.4 | 127.6
 | 2671.2 | 211.3 | 969.7 | 129.9
 | 2602.1 | 169.6 | 1099.8 | 173.6
 | 2413.8 | 167.6 | 1340.4 | 175.5
 | 2221.4 | 167.2 | 1534.7 | 176
 | 2041.8 | 111.2 | 1720.6 | 234.6
 | 1746.4 | 55.2 | 2021.3 | 348.4
 | 1334.2 | 2.2 | 2428 | 406.1
 | 1267.1 | 2 | 2666.6 | 406.2
 | 1084 | 2 | 2848 | 406.2
 | 962.1 | 3 | 3018.1 | 406.2
 | 596.7 | 2.7 | 3427.9 | 407.1
 | 599.3 | 2 | 3428.3 | 407.8
 | 539.3 | 0.8 | 3487.1 | 409
 | 479.3 | 0.4 | 4546.2 | 409.5
 | 478.4 | 55.4 | 3606.8 | 409.5
 | 418.4 | 55.4 | 3669.3 | 409.5
 | 298.4 | 55.4 | 3785.9 | 409.5
 | 243.4 | 55 | 3838.2 | 409.9
 | 298.4 | 55.5 | 3838.2 | 409.9
 | 298.4 | 55.5 | 3838.2 | 409.9
 | 298.4 | 55.5 | 3838.2 | 409.9
 | 178.4 | 167.2 | 4017 | 409.9
 | 118.4 | 112.2 | 4078.9 | 467.7
 | 118.2 | 112.2 | 4078.9 | 467.7
 | 118.2 | 112.2 | 4078.9 | 468.7
 | 118.2 | 168.2 | 4078.9 | 467.7
 | 117.2 | 254.2 | 4081.9 | 467.7
 | 117.2 | 199.4 | 4081.9 | 468.4
Spreadsheet: 35009d1232478750-conditional-i-think-if-statment-maybe-more-do-ranka
Sheet: Gate info

Galaxy Gate Rewards
 |  |  |  |  |  |  |  |  |  |  |  |  | Amount | Amount | Amount
Alpha | # | Exp | Honour | Credits | Uri | Prometium | Terbium | Endurium | Prometid | Duranium | Promerium | Total Cargo | Prometid | Duranium | Promerium
Streuners | 40 | 16000 | 80 | 16000 | 40 | 400 | 0 | 400 | 0 | 0 | 0 | 800
Lordakians | 40 | 32000 | 160 | 32000 | 80 | 800 | 800 | 800 | 0 | 0 | 0 | 2400
Mordons | 40 | 128000 | 640 | 256000 | 320 | 3200 | 3200 | 3200 | 320 | 320 | 40 | 10280
Saimons | 80 | 128000 | 640 | 128000 | 320 | 3200 | 3200 | 3200 | 160 | 160 | 0 | 9920
Devolarium | 20 | 128000 | 640 | 1024000 | 320 | 800 | 800 | 800 | 40 | 40 | 0 | 2480
Sks | 80 | 512000 | 2560 | 1024000 | 1280 | 8000 | 8000 | 8000 | 1280 | 1280 | 80 | 26640
Sibelons | 20 | 256000 | 1280 | 2048000 | 640 | 4000 | 4000 | 4000 | 4000 | 640 | 80 | 16720
Sibelonits | 80 | 256000 | 1280 | 1024000 | 960 | 8000 | 8000 | 8000 | 640 | 640 | 80 | 25360
Bks | 16 | 819200 | 4096 | 6553600 | 2048 | 4800 | 4800 | 4800 | 2048 | 2048 | 256 | 18752
Protegits | 30 | 192000 | 960 | 384000 | 480 | 3000 | 3000 | 3000 | 480 | 480 | 60 | 10020
Total | 446 | 2467200 | 12336 | 12489600 | 6488
 |  | Exp | Honour | Uri | Cargo |  | Prometid | Duranium | Promerium |  | Prometium | 20
Rewards | Alpha | 4000000 | 200000 | 20000 | 123372 |  | 1810 | 1790 |  |  | Endurium | 10
 | Betta | 8000000 | 400000 | 40000 | 245144 |  |  |  |  |  | Terbium | 20
 | Yamma | 12000000 | 600000 | 60000 | 360516
Total Reward | Alpha | 6467200 | 212336 | 26488
 | Beta | 12934400 | 424672 | 52976 |  |  | 35800 | 36200
 | Yamma | 19401600 | 637008 | 79464
Spreadsheet: 269726d1381258501-populate-cell-based-on-table-example-attached-allowance
Sheet: Sheet1

 |  |  | Start Date | Entitlement | Pro Rata | Entitlement | Pro Rata | Entitlement | Pro Rata
 |  |  |  | 15 | 15 | 20 | 20 | 25 | 25
 |  |  |  | 15 | 15 | 20 | 20 | 25 | 25
 |  |  |  | 15 | 15 | 20 | 20 | 25 | 25
 |  |  |  | 15 | 15 | 20 | 20 | 25 | 25
 |  |  |  | 15 | 15 | 20 | 20 | 25 | 25
 | Start Date |  |  | 15 | 15 | 20 | 20 | 25 | 25
 | 2013-01-01 00:00:00 |  |  | 15 | 15 | 20 | 20 | 25 | 25
 | Entitlement |  |  | 15 | 15 | 20 | 20 | 25 | 25
 | 25 |  |  | 15 | 15 | 20 | 20 | 25 | 25
 | Pro Rata Answer |  |  | 15 | 15 | 20 | 20 | 25 | 25
 | 15 |  |  | 15 | 15 | 20 | 20 | 25 | 25
 |  |  |  | 15 | 15 | 20 | 20 | 25 | 25
 | Start Date |  |  | 15 | 15 | 20 | 20 | 25 | 25
 | 2013-01-16 00:00:00 |  |  | 15 | 15 | 20 | 20 | 25 | 25
 | Entitlement |  |  | 15 | 15 | 20 | 20 | 25 | 25
 | 20 |  |  | 15 | 14.5 | 20 | 19 | 25 | 24
 | Pro Rata Answer |  |  | 15 | 14.5 | 20 | 19 | 25 | 24
 | 19 |  |  | 15 | 14.5 | 20 | 19 | 25 | 24
 |  |  |  | 15 | 14.5 | 20 | 19 | 25 | 24
 |  |  |  | 15 | 14.5 | 20 | 19 | 25 | 24
 |  |  |  | 15 | 14.5 | 20 | 19 | 25 | 24
 |  |  |  | 15 | 14.5 | 20 | 19 | 25 | 24
 |  |  |  | 15 | 14.5 | 20 | 19 | 25 | 24
 |  |  |  | 15 | 14.5 | 20 | 19 | 25 | 24
 |  |  |  | 15 | 14.5 | 20 | 19 | 25 | 24
 |  |  |  | 15 | 14.5 | 20 | 19 | 25 | 24
 |  |  |  | 15 | 14.5 | 20 | 19 | 25 | 24
 |  |  |  | 15 | 14.5 | 20 | 19 | 25 | 24
 |  |  |  | 15 | 14.5 | 20 | 19 | 25 | 24
 |  |  |  | 15 | 14.5 | 20 | 19 | 25 | 24
 |  |  |  | 15 | 14.5 | 20 | 19 | 25 | 24
 |  | Hire Date
 | Allowance | Jan  1 - 15 | Jan  16-31 | Feb  1 - 16 | Feb  16-29 | [NAME] | [NAME] | Apr  1-15 | April 16-30 | May  1-15 | May  16-31 | Jun 1-15 | Jun  16-30 | Jul 1-15 | Jul  16-31 | Aug 1-15 | Aug 16-31 | Sep 1-15 | Sep 16-30 | Oct 1-15 | Oct 16-31 | Nov 1-15 | Nov 16-31 | Dec 1-15 | Dec 16-31
 | 15 | 15 | 14.5 | 14 | 13 | 12.5 | 12 | 11.5 | 10.5 | 10 | 9.5 | 9 | 8 | 7.5 | 7 | 6.5 | 5.5 | 5 | 4.5 | 4 | 3 | 2.5 | 2 | 1.5 | 0.5
 | 20 | 20 | 19 | 18.5 | 17.5 | 16.5 | 16 | 15 | 14 | 13.5 | 12.5 | 11.5 | 11 | 10 | 9 | 8.5 | 7.5 | 6.5 | 6 | 5 | 4 | 3.5 | 2.5 | 1.5 | 1
 | 25 | 25 | 23 | 23 | 22 | 21 | 20 | 18.5 | 17.5 | 16.5 | 15.5 | 14.5 | 13.5 | 12.5 | 11.5 | 10.5 | 9.5 | 8.5 | 7.5 | 6 | 5 | 4 | 3 | 2 | 1
Spreadsheet: 216522d1361800267-conditional-formatting-with-formula-forum
Sheet: Sheet1

Client | 2010 | 2011 | 2012 | Trend | 2010 Vs 2012 | 2011 Vs 2012
Constantine Cannon LLP | 527583.32 | 74646.61 | 5022.9 | downward trend | 522560.4199999999
Kessler Topaz Meltzer & Check, LLP | 664067.6 | 535114.83 | 249242.2 | downward trend | 414825.4
Liddle & Robinson LLP | 515460.13 | 272733.34 | 267965.95 | downward trend | 247494.18
Korshin & Welden Law Offices | 225677.2 | 44884.05 | 36949.02 | downward trend | 188728.18
Kirkland & Ellis LLP | 254672.21 | 110105.08 | 75739.08 | downward trend | 178933.13
FINRA Enforcement | 174927.3 | 7296.5 | 7103.3 | downward trend | 167824
FINRA Enforcement OOT | 151204.05 | 11293 | 1579.5 | downward trend | 149624.55
Thompson Coburn LLP | 127477.81 | 88626.91 | 1882.25 | downward trend | 125595.56
[NAME] | 132399.32 | 48426.54 | 13479.12 | downward trend | 118920.2
Congdon Flaherty O'Callaghan Reid Donlon Travis & Fishlinger | 153011.66 | 91926.29 | 35413.99 | downward trend | 117597.67
[NAME] | 113945.07 | 31951.37 | -314.95 | downward trend | 114260.02
[NAME] LLP | 192633.93 | 184160.62 | 78741.9 | downward trend | 113892.03
[NAME] | 220526.16 | 114430.44 | 107211.61 | downward trend | 113314.55
Orrick Herrington & Sutcliffe LLP | 147438.02 | 132527.64 | 37937.44 | downward trend | 109500.58
Westermann Sheehy Keenan Saaman Aydelott LLP | 136290.39 | 79252.97 | 33293.27 | downward trend | 102997.12
Armstrong Teasdale LLP | 94935.06 | 450 |  | downward trend | 94935.06
Kohn Shands Elbert Gianoulakis & Giljum | 94162.88 | 1312.5 |  | downward trend | 94162.88
Lester [NAME] | 126360.14 | 102621.45 | 36162.65 | downward trend | 90197.48999999999
Nassau County Attorney Office | 143194.5 | 130524 | 53224.55 | downward trend | 89969.95
Morgan Lewis & Bockius | 88655.14 | 66187.76 | -323.5 | downward trend | 88978.64
Gersowitz Libo & Korek | 96366.41 | 18375.11 | 11133.93 | downward trend | 85232.48000000001
Giskan Solotaroff Anderson & Stewart LLP | 106027.45 | 56201.65 | 29252 | downward trend | 76775.45
Friedland Laifer & Robbins LLP | 82605.35 | 10212.5 | 7874.94 | downward trend | 74730.41
Spreadsheet: 90211d1289962437-data-all-over-the-sheet-to-be-cleaned-example
Sheet: Main Sheet

Group # AAA
Number | Name | Amount
111111111 | [NAME] | 200
111111111 | [NAME] | 300
222222222 | [NAME] | 400
333333333 | Jake | 255
Group # AAA
444444444 | [NAME] | 200
555555555 | [NAME] | 300
666666666 | [NAME] | 400
Group # AAA
777777777 | Pauline | 200
666666666 | [NAME] | 300
888888888 | Timmy | 400
999999999 | [NAME] | 255
Group # [NAME]
777777777 | Pauline | 200
666666666 | [NAME] | 300
888888888 | Timmy | 400
999999999 | [NAME] | 255
Group # [NAME]
777777777 | Pauline | 200
666666666 | [NAME] | 6554
888888888 | Timmy | 554
999999999 | [NAME] | 255
Group # CCC
Number | Name | Amount
111111111 | [NAME] | 200
111111111 | [NAME] | 300
222222222 | [NAME] | 400
333333333 | Jake | 255
Group # CCC
Number | Name | Amount
111111111 | [NAME] | 200
111111111 | [NAME] | 300
222222222 | [NAME] | 400
333333333 | Jake | 255
Group # CCC
444444444 | [NAME] | 200
555555555 | [NAME] | 300
666666666 | [NAME] | 400
Group # CCC
777777777 | Pauline | 200
666666666 | [NAME] | 300
888888888 | Timmy | 400
999999999 | [NAME] | 255
Group # [NAME]
777777777 | Pauline | 200
666666666 | [NAME] | 300
888888888 | Timmy | 400
999999999 | [NAME] | 255
Group # [NAME]
777777777 | Pauline | 200
666666666 | [NAME] | 6554
888888888 | Timmy | 554
999999999 | [NAME] | 255
Group # [NAME]
Number | Name | Amount
111111111 | [NAME] | 200
111111111 | [NAME] | 300
222222222 | [NAME] | 400
333333333 | Jake | 255
Spreadsheet: 58721d1258990778-excel-marco-vs-excel-functions-sample
Sheet: A1

 | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Actual | Forecast | Forecast
 | 2009-01-01 00:00:00 | 2009-02-28 00:00:00 | 2009-03-31 00:00:00 | 2009-04-30 00:00:00 | 2009-05-31 00:00:00 | 2009-06-30 00:00:00 | 2009-07-31 00:00:00 | 2009-08-31 00:00:00 | 2009-09-30 00:00:00 | 2009-10-31 00:00:00 | 2009-11-30 00:00:00 | 2009-12-31 00:00:00 | Total
Housing Allowance | 0.0005951343807630849 | 0.1458609298452589 | 0.1937314943642834 | 0.1050055848997271 | 0.3164636917708037 | 0.5854961349785772 | 0.5284644471265043 | 0.04370078819221934 | 0.7384949961411467 | 0.6229943805809661 | 0.1202941850224635 | 0.09874705570182041 | 3.499848823004534
Legal Fee | 0.0778687792654229 | 0.6535905216175175 | 0.1532299024500059 | 0.9351501453932034 | 0.3996946029436907 | 0.9333804946310809 | 0.9593739349957471 | 0.2385740241013299 | 0.3895970491713927 | 0.2181274097464243 | 0.787876760902728 | 0.5327875527948107 | 6.279251178013354
MV Expenses | 0.8784470104762239 | 0.7622170815824536 | 0.03947436515812619 | 0.3391226513917067 | 0.9361237899753947 | 0.3529263489824177 | 0.4384285661094731 | 0.4249297822547118 | 0.8372485293777423 | 0.5098029669600241 | 0.5215122470211 | 0.9333527332765263 | 6.973586072565901
Professional Fee | 0.1895770856127392 | 0.8471152525181096 | 0.198587944433622 | 0.105950905441321 | 0.06127835754845767 | 0.04620766021363831 | 0.2043260441148447 | 0.8610273820477401 | 0.1838314410787472 | 0.9801997964171951 | 0.1391181068242335 | 0.9147699461393533 | 4.731989922390002
Repair & Maintenance | 0.6784572715663206 | 0.2696927803665883 | 0.714873747796438 | 0.241192089401669 | 0.9420063361333986 | 0.190985822108062 | 0.9355219483865778 | 0.3332472258314887 | 0.9983832743455725 | 0.06707872307337048 | 0.8947618872364071 | 0.7105827402974179 | 6.97678384654331
Salary | 0.3340965147300325 | 0.2667045194948239 | 0.4266246523394126 | 0.07430599277007843 | 0.005611431738923756 | 0.7074125874887538 | 0.8280260339310996 | 0.9958082469217509 | 0.1211457274100103 | 0.1808630080656286 | 0.4618689461160324 | 0.708250706228724 | 5.110718367235271
Stationery | 0.2359348886145669 | 0.04707816416384647 | 0.02925000169262582 | 0.2273238197165366 | 0.6576552783898963 | 0.07887591454419374 | 0.9705121484970975 | 0.6177232435704536 | 0.7892369403371569 | 0.7613592174619326 | 0.3338050244821782 | 0.4947309269885873 | 5.243485568459072
Spreadsheet: 855409d1704983213-updating-a-calendar-from-dates-test-calendar-v1
Sheet: September

 |  |  | SEPTEMBER
 |  |  | SUNDAY |  | MONDAY |  | TUESDAY |  | WEDNESDAY |  | THURSDAY |  | FRIDAY |  | SATURDAY
 |  |  |  |  |  | Notes :
9
7
2
 |  |  | © 2018 - excelcalendars.net
Spreadsheet: 70371d1271152590-excel-2007-pivot-table-display-eg1
Sheet: Sheet1

Unit | Actual Task | Completed
377101 | B1 | 2009-04-23 00:00:00
377101 | AS1 | 2009-05-28 00:00:00
377101 | C2 | 2009-07-06 00:00:00
377101 | UAT | 2009-07-06 00:00:00
377101 | AS1 | 2009-08-12 00:00:00
377101 | [NAME] | 2009-08-23 00:00:00
377101 | B1 | 2009-09-18 00:00:00
377101 | AS1 | 2009-10-22 00:00:00
377101 | B2 | 2009-11-29 00:00:00
377101 | AS1 | 2010-01-05 00:00:00
377101 | B1 | 2010-02-11 00:00:00
377101 | AS1 | 2010-03-19 00:00:00
377102 | B1 | 2009-04-02 00:00:00
377102 | AS1 | 2009-05-10 00:00:00
377102 | [NAME] | 2009-05-17 00:00:00
377102 | B2 | 2009-06-23 00:00:00
377102 | AS1 | 2009-07-23 00:00:00
377102 | B1 | 2009-08-26 00:00:00
377102 | AS1 | 2009-10-07 00:00:00
377102 | UAT | 2009-11-13 00:00:00
377102 | C2 | 2009-11-14 00:00:00
377102 | AS1 | 2009-12-19 00:00:00
377102 | B1 | 2010-02-04 00:00:00
377102 | AS1 | 2010-03-14 00:00:00
Spreadsheet: 776307d1649682939-xlookup-to-pull-from-master-workbook-and-cover-4-scenarios-new-feet-template
Sheet: Sheet3

Vehicle Type | Status | Location ID | Location Name | Province of Registration | Unit Number | Year | Make | Model | Description | VIN | Upfit Serial # | Plate | Assigned Driver | Engine Type | Engine Size (Litres) | Axles | [NAME] (lbs) | [NAME] (lbs) | 407ETR Transponder (ON only)
Passenger | Active | 2000 | Head office | ON | 1 | 2019 | Ford | [NAME] | Test | 4 | 5 | CAJX 096 | [NAME] |  |  |  |  |  | E87GHRFT
Delivery | Active | 2003 | City A | ON | 2 | 2020 | [NAME] | 1400 | Test | 5 | 2 | AW 5478 | [NAME]
Passenger | Active | 2007 | City B | ON | 3 | 2021 | Ford | [NAME] | Test | 8 | 36 | BA 9076 | [NAME] |  |  |  |  |  | E7HNTRN
Delivery | Active | 2014 | City C | ON | 4 | 2022 | [NAME] | 1400 | Test | 2 | 3 | BB 4567
Delivery | Active | 2051 | City D | ON | 5 | 2019 | Int'l | 5600 | Test | 3 | 6 | AX 0987 |  |  |  |  |  |  | E86LOTMN
Spreadsheet: 787955d1658171216-count-the-number-of-unique-data-with-multiple-conditions-help-7-18
Sheet: Sheet1

 | fruit name | Amount | Date |  |  | Date | Amount 1-10 | Amount 11-20 | Amount 21-50 | Amount 51-100 | Amount100+
 | apple | 53 | 2022-07-01 00:00:00 |  | TABLE B | 2022-07-01 00:00:00 | 0 | 0 | 3 | 4 | 1
 | pear | 33 | 2022-07-01 00:00:00 |  |  | 2022-07-02 00:00:00 | 1 | 0 | 2 | 3 | 2
 | apple | 7 | 2022-07-01 00:00:00 |  |  | 2022-07-03 00:00:00 | 0 | 1 | 3 | 2 | 1
 | banana | 29 | 2022-07-01 00:00:00
 | durian | 27 | 2022-07-01 00:00:00 |  |  | Count of Amount | Group
 | Grape | 67 | 2022-07-01 00:00:00 |  |  | Date | Amount 1-10 | Amount 11-20 | Amount 21-50 | Amount 51-101 | Amount 101+
 | Grape | 85 | 2022-07-01 00:00:00 |  |  | 2022-07-01 00:00:00 | 0 | 0 | 3 | 4 | 1
 | peach | 61 | 2022-07-01 00:00:00 |  |  | 2022-07-02 00:00:00 | 1 | 0 | 2 | 3 | 2
 | pear | 46 | 2022-07-01 00:00:00 |  |  | 2022-07-03 00:00:00 | 0 | 1 | 3 | 2 | 1
 | longan | 89 | 2022-07-01 00:00:00
 | litchi | 23 | 2022-07-01 00:00:00
 | apple | 89 | 2022-07-02 00:00:00
 | pear | 61 | 2022-07-02 00:00:00
 | apple | 27 | 2022-07-02 00:00:00
 | apple | 14 | 2022-07-02 00:00:00
 | banana | 30 | 2022-07-02 00:00:00
 | durian | 43 | 2022-07-02 00:00:00
 | Grape | 41 | 2022-07-02 00:00:00
 | Grape | 6 | 2022-07-02 00:00:00
 | durian | 4 | 2022-07-02 00:00:00
 | Grape | 7 | 2022-07-02 00:00:00
 | Grape | 75 | 2022-07-02 00:00:00
 | peach | 85 | 2022-07-02 00:00:00
 | pear | 13 | 2022-07-02 00:00:00
 | longan | 51 | 2022-07-02 00:00:00
 | litchi | 7 | 2022-07-02 00:00:00
 | longan | 12 | 2022-07-03 00:00:00
 | litchi | 88 | 2022-07-03 00:00:00
 | apple | 5 | 2022-07-03 00:00:00
 | pear | 38 | 2022-07-03 00:00:00
 | apple | 7 | 2022-07-03 00:00:00
 | apple | 16 | 2022-07-03 00:00:00
 | banana | 39 | 2022-07-03 00:00:00
 | durian | 78 | 2022-07-03 00:00:00
 | Grape | 23 | 2022-07-03 00:00:00
 | Grape | 87 | 2022-07-03 00:00:00
 | durian | 6 | 2022-07-03 00:00:00
 | Grape | 19 | 2022-07-03 00:00:00
 |  | TABLE A
Spreadsheet: daren_farmer__5401__hpl0803
Sheet: Sheet1

HPLN0803XLS |  | Fax # [PHONE]
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL;  AMI_CHOSKI / ENRON
FROM:  [NAME]  (TU ELECTRIC)
 |  |  |  |  |  | ** Thursday
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 2000-08-03 00:00:00
 |  |  |  |  |  | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream
Enron (FM) |  | LS HPL [NAME] |  | HPL
 |  |  |  |  | 0 to 54  0900hrs | 0 to 40  0900hrs
 |  |  |  |  | 54  to 0 2100hrs | 40  to 0 2100hrs
 |  | Firm Summary
Enron (S) |  | Oasis Turbine |  | ENA | 7.4 | 0
Enron (S) |  | Reklaw |  | ENA | 20 | 30
Enron (S) |  | Oasis Sealy |  | ENA | 20 | 0
 |  | Enron North America Spot/3959
OTHER ENRON/HPL TRANSPORTS: |  |  |  | Downstream
Empire (Enron) |  | [NAME]. |  | Empire | 8 | 8
Empire (Enron) |  | Oasis Turbine |  | Empire | 10 | 10
 |  | 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: 763460d1642180508-index-match-formula-to-exclude-blank-cells-test-excel-sheet
Sheet: Distribution

Team | Recipient
Red | Coffee
Red | Lemonade
Red | Coffee
Red | Tea
Pink | Lemonade
Red | Lemonade
Red | Coffee
Pink | Lemonade
Green | Tea
Blue | Tea
Blue | Tea
Pink | Cola
Pink | Cola
Blue | Cola
Green | Tea
Blue | Tea
Blue | Tea
Pink | Cola
Red | Cola
Red | Lemonade
Red | Lemonade
Green | Tea
Pink | Coffee
Blue | Cola
Pink | Lemonade
Red | Cola
Pink | Coffee
Spreadsheet: daren_farmer__5944__EI333reveff061000
Sheet: Sheet1

To:   [NAME]          (Enron)
From: [NAME] ([NAME])
Date:  6/09/00
Subject:  Revised Availabilities Effective 6/10/00
Effective Date | CTP NAME | Gross Vol. (MMBtu/d) | PVR % | PVR Volume | Avail. After PVR (MMBtu/d) | DBQ | Excess
2000-06-10 00:00:00 | EI 333 | 4084 | 0 |  |  | 2918
1st of month DBQ = 2918/d
The Sea Robin Plant will shut down Monday, June 12, 2000 at 9:00 a.m. for repairs and maintenance.
The plant should be back up on Thursday, June 15, 2000.
Spreadsheet: 843288d1695184699-a-doosy-complex-logic-for-filtering-can-you-figure-it-out-test-formulas-smaller
Sheet: Scratch

Vendor | Library Type | Instrument Types A | Instrument Types B | Instrument Types C | Instrument Types D | Instrument Types ALL | Applications A | Applications B | Applications C | Applications ALL |  |  |  |  |  |  |  |  |  |  |  |  |  | Instrument Types ALL HELPER | Applications ALL HELPER
8Dio |  | [NAME] |  |  |  | [NAME]
Cinesamples
Spreadsheet: 170817d1343415450-need-a-macro-to-delete-all-cells-that-do-not-fall-under-one-category-example
Sheet: Sheet1

I need this: |  |  |  | To look like this after a macro...
Supervisor | Center | ID Number |  | Supervisor | Center | ID Number
Sean | A | 1 |  | Sean | A | 1
[NAME] | B | 2 |  | Sean | J | 10
Ye | C | 3 |  | Sean | N | 14
[NAME] | D | 4
[NAME] | E | 5
Ye | F | 6
[NAME] | G | 7
[NAME] | H | 8
Ye | I | 9
Sean | J | 10
[NAME] | K | 11
[NAME] | L | 12
Ye | M | 13
Sean | N | 14
Spreadsheet: 133754d1324578787-extract-data-from-one-tab-to-another-based-on-a-rule-customer-20brand-20and-20depot-20data-2-
Sheet: brands and depots

[NAME] | BRAND | Customer Brand | Customer depot | Brand-Depot | ADDRESS 1 | ADDRESS 2 | ADDRESS 3 | ADDRESS 4 | POSTCODE | PHONE NUMBER | FAX NUMBER
[NAME] | EMO OIL | 3 | 301 | 3-301 | 3 Cooper Drive |  | Braintree | Essex | CM7 2RF | 01376 852369 | 01376 858585
Ellesmere Port | EMO OIL | 3 | 305 | 3-305 | The High Street | Chelmer Way | [NAME] | Essex | CM1 2ED | 01245 124578 | 01245 568923
Trafford Park | EMO OIL | 3 | 306 | 3-306 | The Retail Park | Butler Way | Halstead | Essex | CO9 1RF | 01787 126987 | 01787 457896
Spreadsheet: 191174d1351956334-counting-the-numbers-with-3-book1-36-
Sheet: Sheet1

Year | 2009 |  | Consumption Ratio |  |  |  |  |  | All | All | All
Month | Aug |  |  |  |  |  |  |  | 2009 | Jan | A
Product | B |  | to get the cosumption ratio i need to show herethe result of column F with number  <= 3 over the total number of items in the same column |  |  |  |  |  | 2010 | Feb | B
 |  |  | the result will be based on the criteria which the user will select in the 1st 3 row of column B |  |  |  |  |  | 2011 | Mar | C
 |  |  |  |  |  |  |  |  | 2012 | Apr | D
 |  |  |  |  |  |  |  |  |  | May
Product | Year | Month | Stock | Consumed | left |  |  |  |  | Jun
B | 2009 | Aug | 20 | 1 | 1 |  |  |  |  | Jul
B | 2010 | Apr | 10 | 8 |  |  |  |  |  | Aug
C | 2010 | May | 9 |  |  |  |  |  |  | Sep
D | 2011 | Jun | 12 | 5 |  |  |  |  |  | Oct
A | 2012 | Jul | 7 | 3 |  |  |  |  |  | Nov
B | 2009 | Aug | 5 |  | 2 |  |  |  |  | Dec
C | 2010 | Sep | 34 | 34
D | 2009 | Jan | 5 | 8
A | 2010 | Feb | 6 | 7
D | 2010 | Mar | 23 | 20
D | 2011 | Apr | 45 | 20
A | 2012 | May | 3 | 1
Spreadsheet: 172595d1344266704-pulling-multiple-lines-from-several-sheets-into-1-based-on-a-single-value-sample1
Sheet: PR-203

Note | Index Allocated to/From | As Of Date | Amount Added to [NAME] | Amount Allocated out | New Running Total | Coresponding JE | Account
 | RBC351 | 2012-08-06 00:00:00 | 21250 |  |  | [NAME] | 203
 | RBC002 | 2012-08-06 00:00:00 | 42000 |  |  | JBC12S45 | 203
 | RBC025 | 2012-08-06 00:00:00 | 75000 |  |  | JBB12S28 | 203
 | RBC351 | 2012-08-17 00:00:00 | 16000 |  |  |  | 203
 | RBC351 | 2012-08-17 00:00:00 |  | 5000 |  |  | 203
Spreadsheet: darrell_schoolcraft__7659__CMSDAILYOBA2002
Sheet: CMS Daily Report

 | CMS CONTINENTAL DAILY REPORT
Prepared by: [NAME] on |  | for | Gas Day:
 | K#22952 |  | Current Avg | SCHEDULED | DEV | % |  |  | CHECK THE DATES
LE | 380
NNG Beaver (C Line) | 1309 |  | 0 | 0
NNG Beaver #2 | 57461 |  | -0.3 | 0
Beaver Plant Delivery (B Line) | 59370 |  | -40 | -36.6
Beaver Plant Delivery (A Line) | 62880 |  | -8.4 | -12.1
TOTALS
 | K#NEW 5/1/01
LE | 11657
*NNG/CNG Ellis County I/C | 63023 | MMasters | 4.8 | 4.8
TOTALS
 | K# 101510
LE | 11657
Perryton Compressor(10"Beaver A suction) | 2509 |  | 7.7 | 7.6
Continental Janzen | 59531 |  | 2.8 | 1.4
CNG Gathering/NNG Northrup | 59945 |  | 0 | 0
Spearman Inlet/Continental Compressor | 62789 |  | 0 | 0
TOTALS
MTD |  | CMS Continental
 |  | K#22952
 |  | SCHEDULED | ACTUAL | DEV
NNG Beaver (C Line) | 1309 | 555961 | 603541 |  | Est.
NNG Beaver #2 | 57461 | -3624 | 0 |  | Est.
Beaver Plant Delivery (B Line) | 59370 | -438833 | -455569 |  | Act.
Beaver Plant Delivery (A Line) | 62880 | -145632 | -100416 |  | Act.
Continental Natural Gas |  | K#101510
Gathering, LLC |  | SCHEDULED | ACTUAL | DEV
Perryton Compressor(10"Beaver A suction) | 2509 | 91404 | 88144 |  | Act.
Continental Janzen | 59531 | 22640 | 22065 |  | Act.
CNG Gathering/NNG [NAME] | 59945 | 0 | 0
Spearman Inlet/Continental Compressor | 62789 | 0 | 0
Continental Natural Gas |  | K#NEW 5/1/01
Gathering, LLC |  | SCHEDULED | ACTUAL | DEV
*NNG/CNG Ellis County I/C | 63023 | 50144 | 50144 |  | Est.
Total All Volumes MTD
 |  | SUMMARY
2001-11-01 00:00:00 | K#22952 | K#101510 | DEVIATION
 | CMS CONT. | CONTINENTAL
Previous Month-end Imbalance | 121906 | 53466
MTD ESTIMATE
CURRENT
TOTALS
Negative + due NNG
Positive = due [NAME]
Total All Volumes MTD |  | SCHEDULED | ACTUAL | DEV | %
 | 1 | 0 | 0
 | 2 | 0 | 0
 | 3 | 0 | 0
 | 4 | 0 | 0
 | 5 | 0 | 0
 | 6 | 0 | 0
 | 7 | 0 | 0
 | 8 | 0 | 0
 | 9 | 0 | 0
 | 10 | 0 | 0
 | 11 | 0 | 0
 | 12 | 132060 | 207909
 | 13 | 0 | 0
 | 14 | 0 | 0
 | 15 | 0 | 0
 | 16 | 0 | 0
 | 17 | 0 | 0
 | 18 | 0 | 0
 | 19 | 0 | 0
 | 20 | 0 | 0
 | 21 | 0 | 0
 | 22 | 0 | 0
 | 23 | 0 | 0
 | 24 | 0 | 0
 | 25 | 0 | 0
 | 26 | 0 | 0
 | 27 | 0 | 0
 | 28 | 0 | 0
 | 29 | 0 | 0
 | 30 | 0 | 0
 | 31 | 0 | 0
 |  | 0 | 0
OBA COMMUNICATIONS WITH CMS
1/24/01 - [NAME] changed the capacity to aid in getting in balance at POI 2509 Perryton
01/25/01 - Melissa Masters called reporting that she was long to us at Beaver by 52,000 and asked us to
remove the allocation for the 25th gas day.  [NAME] did so. I have changed my daily report to reflect volumes taken from the pre-accum in SCADA.
2/21/00 [NAME] discovered that the BTU factor for POI 1309 is 1.1383 and it should be 1.000 per CMS.  CMS is sending a field rep out to investigate
and recalibrate if necessary.