tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: daren_farmer__5028__HPLN0328
Sheet: Sheet1

HPLN0328.XLS |  | Fax # [PHONE]
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL;  LIZ BELLAMY / ENRON
FROM:  MELISSA JONES - TXU ELECTRIC & GAS  (TU ELECTRIC)
SUBJECT:  TXU FUELS NOMINATION - March 28, 2001
 |  |  |  |  |  | **Wednesday
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 2001-03-28 00:00:00
 |  |  |  |  |  | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream
 |  | Firm Summary
Enron (S) |  | Oasis Sealy |  | Enron | 10 | 0
Enron (S) |  | LS HPL [NAME] |  | Enron | 25 | 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: 846961d1698086871-value-split-based-on-the-slab-chargeable-days-split
Sheet: Sheet1

 |  |  | Days >> | 4 |  |  | X
 |  | Total Days | New Chargeable Days | Freetime | Slab 1 | Slab 2 | Slab 3
 |  | 14 | 10
 |  | 19 | 15 |  |  |  |  |  |  |  |  | Calender Days | Rate $/Day
 |  | 29 | 25 |  |  |  |  |  |  |  | Freetime | 4 | 25
 |  | 54 | 50 |  |  |  |  |  |  |  | Slab 1 | 6 | 35
 |  |  |  |  |  |  |  |  |  |  | Slab 2 | 7 | 45
 |  |  | expected results | 4 | 6 | 4 | 0 |  |  |  | Thereafter |  | 60
 |  |  |  | 4 | 6 | 7 | 2
 |  |  |  | 4 | 6 | 7 | 12
 |  |  |  | 4 | 6 | 7 | 37
Spreadsheet: 678734d1590043851-exact-if-not-formula-for-weight-2020-05-21-oeldere-visha_1984-678728d1590042790-exact-if-not-formula-for-weight-weight-formul
Sheet: WEIGHT

Total weight (KGs) | OUTPUT FORMULA
410 | 201 to 500 Kg
410 | 201 to 500 Kg
140 | 101 to 200 Kg
60 | 51 to 100 Kg
60 | 51 to 100 Kg
40 | Up to 50 Kg
140 | 101 to 200 Kg
430 | 201 to 500 Kg
488 | 201 to 500 Kg
140 | 101 to 200 Kg
410 | 201 to 500 Kg
330 | 201 to 500 Kg
180 | 101 to 200 Kg
100 | 51 to 100 Kg
150 | 101 to 200 Kg
453 | 201 to 500 Kg
150 | 101 to 200 Kg
490 | 201 to 500 Kg
300 | 201 to 500 Kg
200 | 101 to 200 Kg
500 | 201 to 500 Kg
400 | 201 to 500 Kg
500 | 201 to 500 Kg
200 | 101 to 200 Kg
830 | 501 to 1000 Kg
650 | 501 to 1000 Kg
780 | 501 to 1000 Kg
910 | 501 to 1000 Kg
1050 | 1001 to 2000 Kg
1500 | 1001 to 2000 Kg
1200 | 1001 to 2000 Kg
1658 | 1001 to 2000 Kg
1980 | 1001 to 2000 Kg
2050 | 2001 to 3000 Kg
2305 | 2001 to 3000 Kg
2854 | 2001 to 3000 Kg
2950 | 2001 to 3000 Kg
2760 | 2001 to 3000 Kg
2500 | 2001 to 3000 Kg
Spreadsheet: 34425d1231709401-return-a-value-if-2-other-criteria-match-lookhere
Sheet: Starts May

 | [NAME] |  |  |  |  |  |  |  |  |  | EXIT NOTIFICATIONS SENT |  | JOB OUTCOMES
 | Customer Name | NiNo. | Referral Source | Int. | Provider / Venue | Input on Adept | Start Date | Status | Caseworker | Errors | Customer Name | Caseworker | Customer Name | Exit Form Sent | Active | Last Date On Provision | Caseworker
Spreadsheet: 789149aa-7ebe-4fcc-9596-828f52081ce4
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2
 |  | U.S. Census Bureau
 |  | Source: Quarterly Services Survey
 |  | 51: Information: U.S. Total
 |  | Seasonally Adjusted Total Revenue [Millions of Dollars]
 |  | Period: 2003 to 2013
 |  | Data Extracted on: December 11, 2013 (12:08 pm)
Period | Value
Q1-2003 | X
Q2-2003 | X
Q3-2003 | X
Q4-2003 | 229371
Q1-2004 | 229175
Q2-2004 | 233474
Q3-2004 | 235336
Q4-2004 | 238105
Q1-2005 | 241837
Q2-2005 | 244380
Q3-2005 | 247183
Q4-2005 | 247443
Q1-2006 | 250954
Q2-2006 | 254990
Q3-2006 | 258328
Q4-2006 | 262731
Q1-2007 | 263776
Q2-2007 | 266272
Q3-2007 | 270025
Q4-2007 | 272054
Q1-2008 | 276013
Q2-2008 | 278199
Q3-2008 | 280692
Q4-2008 | 273583
Q1-2009 | 267567
Q2-2009 | 267416
Q3-2009 | 268461
Q4-2009 | 271132
Q1-2010 | 273221
Q2-2010 | 275247
Q3-2010 | 279408
Q4-2010 | 281844
Q1-2011 | 284136
Q2-2011 | 290132
Q3-2011 | 292370
Q4-2011 | 293684
Q1-2012 | 296354
Q2-2012 | 298357
Q3-2012 | 300019
Q4-2012 | 308848
Q1-2013 | 309155
Q2-2013 | 310908
Q3-2013 | X
Q4-2013 | X
Spreadsheet: 709881d1608603333-tabulate-and-graph-data-abc-client-data
Sheet: Pivot Data

Row Labels | (Attempt) Hurt Client | (Attempt) Hurt Staff | Attention Seeking | Crying/Teary | Escalation | Ignoring Staff | Pacing | Poking Staff | Pulling/Pushing Staff | Screaming /Yelling | (Attempt) Self-harm/injure | Vocal | Other
Client Name | 0 | 10 | 0 | 0 | 10 | 1 | 7 | 0 | 0 | 3 | 0 | 2 | 2
Grand Total | 0 | 10 | 0 | 0 | 10 | 1 | 7 | 0 | 0 | 3 | 0 | 2 | 2
Spreadsheet: kate_symes__18828__NP 15 pages
Sheet: DJ NP15

 |  |  | Firm | Volume | Firm | Volume | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | 24 HOUR | [NAME]
 | 2001-03-09 00:00:00 |  | 189.87 | 30000 | 155.94 | 17200
 | 2001-03-08 00:00:00 |  | 229.83 | 26400 | 158.24 | 4200
 | 2001-03-07 00:00:00 |  | 340.07 | 30160 | 231.96 | 15000
 | 2001-03-06 00:00:00 |  | 362.98 | 29744 | 264.17 | 13200
 | 2001-03-05 00:00:00 |  | 340.79 | 20544 | 261.21 | 8664
 | 2001-03-04 00:00:00 |  |  |  |  |  | 261.21 | 25992
 | 2001-03-03 00:00:00 |  | 271.59 | 21456 | 238.52 | 8664
 | 2001-03-02 00:00:00 |  | 271.59 | 21456 | 238.52 | 8664
 | 2001-03-01 00:00:00 |  | 282.13 | 32240 | 216.41 | 12640
 | 2001-02-28 00:00:00 |  | 210.95 | 35888 | 157.73 | 17224
 | 2001-02-27 00:00:00 |  | 212.87 | 43088 | 151.44 | 17224
 | 2001-02-26 00:00:00 |  | 213.28 | 12320 | 160.3 | 8024
 | 2001-02-25 00:00:00 |  |  |  |  |  | 160.3 | 24072
 | 2001-02-24 00:00:00 |  | 215.99 | 50624 | 158.85 | 20624
 | 2001-02-23 00:00:00 |  | 215.99 | 50624 | 158.85 | 20624
 | 2001-02-22 00:00:00 |  | 253.56 | 46656 | 179.33 | 2824
 | 2001-02-21 00:00:00 |  | 268.77 | 33504 | 198.68 | 16040
 | 2001-02-20 00:00:00 |  | 286.26 | 8880 | 216.91 | 3224
 | 2001-02-19 00:00:00 |  | 288.65 | 24912 | 233.15 | 15840
 | 2001-02-18 00:00:00 |  |  |  |  |  | 283.43 | 35232
 | 2001-02-17 00:00:00 |  | 326.1 | 15872 | 283.43 | 12024
 | 2001-02-16 00:00:00 |  | 437.9 | 29440 | 370.12 | 17208
 | 2001-02-15 00:00:00 |  | 437.9 | 29440 | 370.34 | 18008
 | 2001-02-14 00:00:00 |  | 319.81 | 40656 | 284.13 | 14112
 | 2001-02-13 00:00:00 |  | 284.75 | 33888 | 247.23 | 14448
 | 2001-02-12 00:00:00 |  | 252.44 | 33552 | 233.02 | 14640
 | 2001-02-11 00:00:00 |  |  |  |  |  | 233.02 | 43920
 | 2001-02-10 00:00:00 |  | 230.87 | 33120 | 229.16 | 17424
 | 2001-02-09 00:00:00 |  | 230.87 | 33120 | 229.16 | 17424
 | 2001-02-08 00:00:00 |  | 274.83 | 37456 | 223.07 | 17808
 | 2001-02-07 00:00:00 |  | 251 | 44352 | 218.57 | 14240
Spreadsheet: 162973d1340129826-need-help-with-offsetting-example
Sheet: Sheet1

 | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | Year 1 | Month 13 | Month 14 | Month 15 | Month 16 | Month 17 | Month 18 | Month 19 | Month 20 | Month 21 | Month 22 | Month 23 | Month 24 | Year 2
Total | 450.5176718975213 | 360.5741082847804 | 231.3177287399257 | 118.4183600966321 | 60.02903022797864 | 95.10262084086156 | 219.4398993077407 | 79.14553685620903 | 76.34604843784894 | 61.46876712884956 | 102.7412249538155 | 114.8990032278366 |  | 433.6232592013642 | 347.0525792241012 | 222.6433139121785 | 113.9776715930084 | 57.77794159442944 | 91.53627255932926 | 211.2109030837005 | 76.1775792241012 | 73.4830716214296 | 59.1636883615177 | 98.88842901804747 | 110.5902906067927
Cumulative
SPLIT (Old)
Spreadsheet: 67713d1268262852-unique-and-minimum-value-sample
Sheet: DATA

UID | Column1 | Column2 | Column3 | Column4 | Column5 | Column6
1 | 1_3_50 | 1_3_150 | 5_1_100 | 5_1_200 | 2_3_50
2 | 3_3_250 | 3_3_50 | 5_1_150 | 5_1_200 | 2_3_150 | 2_3_200
3 | 4_5_200 | 4_5_50 | 4_5_100
OUTPUT SHOULD BE LIKE
UID | Column1 | Column2 | Column3
1 | 1_3_50 | 5_1_100 | 2_3_50
2 | 3_3_50 | 5_1_150 | 2_3_150
3 | 4_5_50
Spreadsheet: 38635d1236781014-calculating-turn-around-time-complex-turn-around-time-calculation
Sheet: Sheet3

 | Date received | Time received | Date completed | Time completed by | TAT Outcome (manual) Yes / No | TAT outcome using [NAME] Yes / No |  | TAT target | < =2 hours (working hours only)
Scenario 1 | 2009-03-11 00:00:00 | 12:00:00 | 2009-03-11 00:00:00 | 14:00:00 | Yes |  |  | Day begin | 06:00:00
Scenario 2 | 2009-03-11 00:00:00 | 13:00:00 | 2009-03-11 00:00:00 | 16:00:00 | Yes |  |  | Day end | 14:30:00
Scenario 3 | 2009-03-11 00:00:00 | 13:00:00 | 2009-03-12 00:00:00 | 06:30:00 | Yes
Scenario 4 | 2009-03-13 00:00:00 | 13:00:00 | 2009-03-16 00:00:00 | 06:30:00 | Yes |  |  | Working days: | Monday to Friday
Scenario 5 | 2009-03-14 00:00:00 | 13:00:00 | 2009-03-15 00:00:00 | 13:00:00 | Yes
Scenario 6 | 2009-03-14 00:00:00 | 13:00:00 | 2009-03-16 00:00:00 | 08:00:00 | Yes |  |  | Holidays | 2009-04-10 00:00:00 | Good Friday
Scenario 7 | 2009-04-09 00:00:00 | 13:00:00 | 2009-04-14 00:00:00 | 06:30:00 | Yes |  |  |  | 2009-04-13 00:00:00 | easter Monday
 |  |  |  |  |  |  |  |  | 2009-12-25 00:00:00 | Christmas
Scenarios explained
Scenario 1 | Simple scenario where difference of completed & received time is checked to see if it is <= 2 hours
Scenario 2 | work received near to end of day, however job completed the same day, altough after office hours, hence it is considered as TAT met, since the client will consider his job was completed in 1.5 hours
Scenario 3 | work received 1.5 hours before End of day (EOD), officially my 2 hours completes the next day, hence TAT is met, if job completed latest by 6.30 am
Scenario 4 | job received on Friday at 1.00 pm and thus the TAT will be met if job is completed the next working day within a total time of 2 hours
Scenario 5 | if job is received on weekend and completed on weekend iteself, then regardless of time, job is considered within TAT
Scenario 6 | if job is received on weekend and completed on the next working day within a total time difference of 2 hours, it is considered TAT is met
Scenario 7 | if job is on the eve of a holiday almost at the end of the day, and if the job is completed within a total of 2 hours on the next working day, then TAT is met
Note : Altough we follow workdays and work hours, our customers may send jobs any time and any day.  To meet peak season workloads, we often work after hours and sometimes on weekends too.  To the customer, the committed TAT is 2 hours (working hours)
Spreadsheet: 101038d1299191668-sorting-pivot-table-by-show-value-as-pivot-sorting-example
Sheet: Data

Sum of Total | Column Labels
Row Labels | Spend | Status
Subject 1 | 49599396.33999944 | Preferred
Subject 2 | 22719265.76000003 | Preferred
Subject 3 | 10928138.64000009 | Preferred
Subject 4 | 11286177.81999998 | Preferred
Subject 5 | 11492469.13 | Preferred
Subject 6 | 9525420.690000001 | Preferred
Subject 7 | 10502775.96 | Preferred
Subject 8 | 9626565.149999999 | Preferred
Subject 9 | 5216715.180000001 | Preferred
Subject 10 | 7559590.150000001 | Preferred
Subject 11 | 7508091.85 | Preferred
Subject 12 | 6189164.4 | Preferred
Subject 13 | 3090273.779999999 | Preferred
Subject 14 | 4592208.04 | Preferred
Subject 15 | 5235549.3 | Preferred
Subject 16 | 501507.6299999999 | Preferred
Subject 17 | 2919970.740000001 | Preferred
Subject 18 | 1433774.880000001 | Preferred
Subject 19 | 625615.0800000002 | Preferred
Subject 20 | 1409194.73 | Preferred
Subject 21 | 542527.54 | Preferred
Subject 22 | 585707.2699999998 | Preferred
Subject 23 | 399124.0899999999 | Preferred
Subject 24 | 558792.0500000002 | Preferred
Subject 25 | 428271.5900000001 | Preferred
Subject 26 | 193367.21 | Preferred
Subject 27 | 445415.45 | Preferred
Subject 28 | 335695.1200000001 | Preferred
Subject 29 | 147775.25 | Preferred
Subject 30 | 222603.7800000001 | Preferred
Subject 31 | 48235.57 | Preferred
Subject 32 | 43029.31 | Preferred
Subject 33 | 1657.73 | Preferred
Subject 34 | 11851.24 | Preferred
Subject 35 | 2303.27 | Preferred
Subject 36 | 8350.620000000003 | Preferred
Subject 1 | 1983250.329999998 | Non-Preferred
Subject 2 | 3036393.700000002 | Non-Preferred
Subject 3 | 2783832.290000002 | Non-Preferred
Subject 4 | 1622393.189999998 | Non-Preferred
Subject 5 | 120792.44 | Non-Preferred
Subject 6 | 1888516.11 | Non-Preferred
Subject 7 | 320538.8300000001 | Non-Preferred
Subject 8 | 1156263.06 | Non-Preferred
Subject 9 | 4164183.68 | Non-Preferred
Subject 10 | 614963.6000000001 | Non-Preferred
Subject 11 | 476901.06 | Non-Preferred
Subject 12 | 676374.01 | Non-Preferred
Subject 13 | 2978506.5 | Non-Preferred
Subject 14 | 1387750 | Non-Preferred
Subject 15 | 74801.26999999999 | Non-Preferred
Subject 16 | 4017547.619999999 | Non-Preferred
Subject 17 | 324816.1900000001 | Non-Preferred
Subject 18 | 354133.73 | Non-Preferred
Subject 19 | 870075.9899999999 | Non-Preferred
Subject 20 | 34364.57 | Non-Preferred
Subject 21 | 766432.3199999998 | Non-Preferred
Subject 22 | 171718.52 | Non-Preferred
Subject 23 | 247816.48 | Non-Preferred
Subject 24 | 57749.96999999999 | Non-Preferred
Subject 25 | 76834.38 | Non-Preferred
Subject 26 | 255169.25 | Non-Preferred
Subject 27 |  | Non-Preferred
Subject 28 | 37992.41 | Non-Preferred
Subject 29 | 156553.8199999999 | Non-Preferred
Subject 30 | 9925.66 | Non-Preferred
Subject 31 | 114107 | Non-Preferred
Subject 32 | 78041.47 | Non-Preferred
Subject 33 | 10532.23 | Non-Preferred
Subject 34 | 160.6 | Non-Preferred
Subject 35 | 6750 | Non-Preferred
Subject 36 |  | Non-Preferred
Spreadsheet: 544839d1509048813-changing-color-of-line-chart-with-source-data-chart-samples
Sheet: Conditional Series Color 1

 |  |  |  |  |  | F9 to randomize data
# | Series 1 | Series 2 | Target 1 | Met Target
1 |  |  | 7
2 |  |  | 7
3 |  |  | 7
4 |  |  | 7
5 |  |  | 7
6 |  |  | 7
7 |  |  | 7
8 |  |  | 7
Spreadsheet: michelle_lokay__26569__imbalsumm0012
Sheet: CIG

 | Tumbleweed
 | 9198
Day | Measured | Scheduled
1 | 17996 | 25998
2 | 27242 | 40000
3 | 30344 | 39999
4 | 29336 | 38306
5 | 23080
6 | 31559 | 38450
7 | 30721 | 31076
8 | 25834 | 26000
9 | 26005 | 26000
10 | 25879 | 26000
11 | 27732 | 26000
12 | 33840 | 26000
13 | 28685 | 29986
14 | 30565 | 35963
15 | 24896 | 25999
16 | 24310 | 26000
17 | 24306 | 26000
18 | 24583 | 26000
19 | 24273 | 31000
20
21
22
23
24
25
26
27
28
29
30
31
2000-11-30 00:00:00 |  |  | -557795.86
2000-12-19 00:00:00
Spreadsheet: 113015d1308947873-pivot-table-help-test-data
Sheet: Sheet1

PART NUMBER |  | FORECAST DATE |  |  | JUNE-11 | JULY-11 | AUG-11 | SEPT-11 | OCT-11 | NOV-11 | DEC-11 | JAN-12 | FEB-12 | MAR-12 | APR-12 | MAY-12
xyz |  | 2011-01-01 00:00:00 |  |  | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45
 |  | 2011-07-01 00:00:00 |  |  | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45
 |  | 2011-10-01 00:00:00 |  |  | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45
 |  | 2011-12-01 00:00:00 |  |  | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45
abc |  | 2011-01-01 00:00:00 |  |  | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45
 |  | 2011-07-01 00:00:00 |  |  | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45
 |  | 2011-10-01 00:00:00 |  |  | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45
 |  | 2011-12-01 00:00:00 |  |  | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45
ghi |  | 2011-01-01 00:00:00 |  |  | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45
 |  | 2011-07-01 00:00:00 |  |  | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45
 |  | 2011-10-01 00:00:00 |  |  | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45
 |  | 2011-12-01 00:00:00 |  |  | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45
lmn |  | 2011-01-01 00:00:00 |  |  | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45
 |  | 2011-07-01 00:00:00 |  |  | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45
 |  | 2011-10-01 00:00:00 |  |  | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45
 |  | 2011-12-01 00:00:00 |  |  | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45
Spreadsheet: 755944d1637191812-excel-formula-with-criteria-sample-prob
Sheet: Sheet6

Average of Score | Column Labels
Row Labels | 1 | 2 | Grand Total
Antman | 0.7872340425531915 | 0.9787234042553191 | 0.8829787234042553
15548 |  | 0.9787234042553191 | 0.9787234042553191
19340 | 0.7872340425531915 |  | 0.7872340425531915
Black Widow | 0.9063829787234041 |  | 0.9063829787234041
12311 | 0.8581560283687942 |  | 0.8581560283687942
15544 | 0.9787234042553191 |  | 0.9787234042553191
[NAME] | 0.8829787234042553 | 0.9787234042553191 | 0.9308510638297872
10143 | 0.9787234042553191 |  | 0.9787234042553191
17302 | 0.7872340425531915 | 0.9787234042553191 | 0.9148936170212766
Spider-Man | 0.9787234042553191 |  | 0.9787234042553191
15548 | 0.9787234042553191 |  | 0.9787234042553191
War Machine | 0.9893617021276595 |  | 0.9893617021276595
17302 | 0.9787234042553191 |  | 0.9787234042553191
19340 | 1 |  | 1
Grand Total | 0.9129593810444875 | 0.9787234042553191 | 0.9270516717325228
Spreadsheet: daren_farmer__6608__TransportFlash
Sheet: Variances

November 1998 Transport Expense Variance
Pipe |  | Usage Tickets |  | Synergi-3rd Day |  | [NAME]
Black Marlin
Texas |  | 920 |  | 1226
Oasis Pipeline
Texas
Waha |  | 7490
Total
PG&E Valero
Texas |  | 492 |  | 91320
Waha |  | 88839
Total
 |  |  |  | Total Variance
 |  | Texas |  | Waha
Usage Tickets |  | 1113319 |  | 96329
Intrazone Transport |  | 228000 |  | 0
Black [NAME] |  | 306 |  | -
Oasis Variance |  | -15532 |  | 0
PG&E/Valero |  | 0 |  | 1989
Spreadsheet: 854325d1704248267-how-to-create-a-dynamic-unique-list-from-multiple-sheets-column-practice1
Sheet: Sheet1

 | Sheet 1 |  |  |  |  | Sheet 2 |  |  | Sheet 3 |  |  | Sheet 4
 | Items | Jan | Feb | Mar |  | Items | Jan |  | Items | Feb |  | Items | Mar
 | Apple |  |  |  |  | Apple | 6 |  | Iwatch | 3 |  | TV | 4
 | Watch |  |  |  |  | Watch | 2 |  | Apple | 5 |  | Watch | 5
 | Dell |  |  |  |  | Dell | 6 |  | Watch | 1 |  | Dell | 1
 | Iphone |  |  |  |  | Iphone | 7 |  | Samsung | 5 |  | Apple | 8
 | Iwatch |  |  |  |  |  |  |  | Dell | 2 |  | Huawei | 4
 | Samsung |  |  |  |  |  |  |  | Iphone | 3
 | Mac |  |  |  |  |  |  |  | Mac | 6
 | Nokia |  |  |  |  |  |  |  | Nokia | 7
 | TV
 | Huawei
 | Note: | Sheet 1 is the summary report
 | Yellow | Yellow highlight is the first items in Jan
 | Blue | Blue highlight items are the items getting from items in "Sheet 2, 3, 4" once it updates
 | Question: | How to automatically get the "Items" in "Sheet 2, 3, 4" into "Sheet 1 table" without duplicate
 |  | So the blue higlight items are the items that wanted to automatically update once there is data in Sheet 2, 3,4
Spreadsheet: 135729d1326210050-count-unique-values-in-three-columns-depending-on-multiple-values-sample2
Sheet: Sheet1

Statut | Semaine | Date début | Hr | Tech | Tech | Tech | Unique count Names | Day/Night work | unique count names formula
menu | Auto | [NAME]/jj | 24h00 | menu | menu | menu
[NAME] |  | 2011-10-07 00:00:00 | 8h00 | AM | AM | AnC | 4
Attente NI |  | 2011-10-07 00:00:00 | 8h00 | AuC | AuC | BR
Showstopper |  | 2011-10-12 00:00:00 | 00h01 | AnC | AnC |  | 1
[NAME] |  | 2011-10-12 00:00:00 | 8h00 | BO | BO |  | 10
[NAME] |  | 2011-10-12 00:00:00 | 8h00 | SJ | SJ | NB
Complété |  | 2011-10-12 00:00:00 | 8h00 | JMA | JMA | DV
[NAME] |  | 2011-10-12 00:00:00 | 8h00 | SJ | SJ
[NAME] |  | 2011-10-12 00:00:00 | 8h00 | GL | GL
[NAME] |  | 2011-10-12 00:00:00 | 8h00 | MP | MP | AO
[NAME] |  | 2011-10-12 00:00:00 | 8h00 | AnC | AnC | AuC
[NAME] |  | 2011-10-25 00:00:00 | 00h01 | PC | PC |  | 3
[NAME] |  | 2011-10-25 00:00:00 | 00h01 | BR | BR
[NAME] |  | 2011-10-25 00:00:00 | 00h01 | AnC | AnC
[NAME] |  | 2011-10-25 00:00:00 | 8h00 | AnC | AnC |  | 1
Spreadsheet: mary_fischer__25610__32D-2001
Sheet: E8.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 032D
COMPANY NAME  Enron Building Services, Inc.
ANALYSIS OF OTHER DEFERRED CHARGES
FOR THE 3 MONTHS ENDED 3-31-2001
PREPARED BY:[NAME]
EXTENSION:[PHONE] |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  | 12-31-2000 Balance |  |  |  | Charged to |  | Transfer / Reclasses
[NAME] |  | DR. (CR.) |  | Cash Pd / (Rec'd) |  | Income Statement |  | Amount |  | Hyperion Acct. # |  | DR. (CR.)
 |  | BEGINNING BALANCE |  | DR. (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | to / from |  | ENDING BALANCE |  | COMMENTS
(PROVIDE DETAIL OF INDIVIDUAL ITEMS
IN EXCESS OF $200,000.)
Work in Progress:
 |  | 0
Total  (Hyperion Line 0343)
Asset/Expense Accts:  DR/(CR)
Other Deferred Charges:
 |  | 0
Total (Hyperion line 360)
Asset/Expense Accts:  DR/(CR)
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Spreadsheet: 851095d1701347240-count-unique-vaues-based-on-multiple-criteria-count-values-but-exclude-duplicates
Sheet: Sheet1

Business Name | Zone | Manager | Status |  | Unique Counts |  | Criteria
Homer Home Improvements | A | Homer | Active |  |  |  | Homer
Homer Home Improvements | A | Homer | Active |  |  |  | Active
D'oh Playdough | B | [NAME] | Active |  |  |  | A
Santa's Little Helper Inc. | A | [NAME] | Inactive
Santa's Little Helper Inc. | A | [NAME] | Inactive
Santa's Little Helper Inc. | A | [NAME] | Inactive
Santa's Little Helper Inc. | A | [NAME] | Inactive
Straight A Tutors | B | [NAME] | Active
Straight A Tutors | B | [NAME] | Active
Straight A Tutors | B | [NAME] | Active
Duff LLC | C | Homer | Active
Poetry Club LLC | A | [NAME] | Active
Poetry Club LLC | A | [NAME] | Active
Spreadsheet: d8f40641-0595-43af-9d1d-b59556e74742
Sheet: Sheet1

Representative in Congress - REP (North Dakota) | Unnamed: 1 | Unnamed: 2
Downloaded at 5/18/2013 4:54:10 PM
Precincts Reporting: 528/528 - Total Ballots Cast: 102886
2008 Primary Election - OFFICIAL RESULTS
Precinct | [NAME] | TOTALS
Precinct 1401 | 14 | 14
Precinct 1402 | 18 | 18
Precinct 1403 | 11 | 11
Precinct 1404 | 131 | 131
Precinct 1405 | 28 | 28
Precinct 1406 | 35 | 35
TOTAL | 237 | 237
Results provided by the Office of North Dakota Secretary of State
Spreadsheet: benjamin_rogers__936__PJM Model
Sheet: Daily Curve

Operator | Unit | Model ID | Price | Nameplate | Fuel |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-10 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Operator | Unit | Model ID | Price | Nameplate | Fuel
Spreadsheet: e584e699-1805-4840-bfa3-cf79b3bfd25d
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | EcoCheck Data: Choptank River for 2009
Indicator | 2009
Chlorophyll a | 21.28
Aquatic Grasses | 5.9
[NAME] | 84.957
[NAME] | 34.85572463
Water Clarity | 35.538
Phytoplankton Index | 21.68512163
Water Quality Index | 47.25833333
Biotic Index | 20.81361542
Bay Health Index | 34.03597438
Spreadsheet: 155230d1336735018-excel-2007-line-referenced-drop-downs-example3
Sheet: REC

1500 | AUD
 | CAD
 | CHF
 | EUR
 | GBP
 | USD
1770 | AUD
 | CAD
 | CHF
 | EUR
 | GBP
 | USD
1775 | AUD
 | CAD
 | CHF
 | EUR
 | GBP
 | USD
1790 | AUD
 | CAD
 | CHF
 | EUR
 | GBP
 | USD
Spreadsheet: 866525d1713453941-xlookup-or-filter-matrix-result-expected-but-value-returned-sample-xlookup-function-v2-
Sheet: report

Report year | 2023 | (incl. full previous year)
Report month YTD | 5
Type | B
Code | ZY
Year | Month | S | D
 | 1 | #[NAME]! | #[NAME]!
2022 | 2 | #[NAME]! | #[NAME]!
2022 | 3 | #[NAME]! | #[NAME]!
2022 | 4 | #[NAME]! | #[NAME]!
2022 | 5 | #[NAME]! | #[NAME]!
2022 | 6 | #[NAME]! | #[NAME]!
2022 | 7 | #[NAME]! | #[NAME]!
2022 | 8 | #[NAME]! | #[NAME]!
2022 | 9 | #[NAME]! | #[NAME]!
2022 | 10 | #[NAME]! | #[NAME]!
2022 | 11 | #[NAME]! | #[NAME]!
2022 | 12 | #[NAME]! | #[NAME]!
2023 | 1 | #[NAME]! | #[NAME]!
2023 | 2 | #[NAME]! | #[NAME]!
2023 | 3 | #[NAME]! | #[NAME]!
2023 | 4 | #[NAME]! | #[NAME]!
2023 | 5 | #[NAME]! | #[NAME]!