tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 479264d1473283086-count-number-of-cells-that-contain-numbers-based-on-another-column-example
Sheet: Sheet1

Company
 |  | € | €
 |  | 2015-11-01 00:00:00 | 2015-12-01 00:00:00
Staff A | WP | 0 | 0
Staff A | WP | 1727 | 1492
Staff A | IT | 4166.67 | 4166.67
Staff A | WP | 1599 | 1782
Staff A | DR | 3200 | 2700
Staff A | WP | 2816.5 | 2427
Staff A | WP | 2557.5 | 2782
Staff A | WP | 2447.5 | 2495
Staff A | WP | 2266 | 2491
Staff A | D | 2948.33 | 3088.33
Staff A | DR | 2499.7 | 2499.7
Staff A | WP | 2647 | 2191
Staff A | D | 4370 | 4295
Staff A | WP | 2072 | 1786.5
Staff A | WP | 18284 | 6500
Staff A | WP | 2435 | 2181
Staff A | WP | 0 | 0
Staff A | DR | 1500 | 1650
Staff A | D | 2039.12 | 1983.33
Staff A | D | 1908.33 | 2008.33
Staff A | WP | 2317 | 1969.5
Staff A | D | 3126.67 | 3126.67
Staff A | D | 446.84 | 446.84
Staff A | D | 4066.67 | 3321.67
Staff A | WP | 3393.66 | 3211
Staff A | D | 4123.33 | 3453.33
Staff A | WP | 2383.33 | 2483.33
Staff A | WP | 1833.33 | 1833.33
Staff A | D | 18284 | 6500
Staff A | D | 2208.33 | 2738.33
Staff A | S | 3140.68 | 2946.67
Staff A | D | 2403.5 | 2475.5
Staff A | MK | 3384.62 | 3184.62
Staff A | WP | 0 | 0
Staff A | D | 0 | 0
Staff A | WP | 0 | 0
Staff A | EC | 1833.33 | 1833.33
Staff A | EC | 1833.33 | 1833.33
Staff A | D | 0 | 0
Staff A | D | 2000 | 2000
Staff A | EC | 355 | 1210
Staff A | D | 2493.33 | 2788.33
Staff A | D | 2033.33 | 2008.33
Staff A | WP | 2991 | 3029
Staff A | WP | 2531.5 | 2473.5
Staff A | WP | 2258 | 2120
Staff A | DR | 0 | 0
Staff A | WP | 2246 | 2320
Staff A | IT | 0 | 0
Staff A | WP | 0 | 0
Staff A | WP | 3471.5 | 2500
Staff A | WP | 1616 | 1447
Staff A | S | 3906 | 4100
Staff A | D | 0 | 0
Staff A | EC | 1003.33 | 1003.33
Staff A | EC | 2166.67 | 2166.67
Staff A | D | 2798.33 | 2953.33
Staff A | WP | 2802.5 | 2787
Staff A | S | 0 | 0
Totals
Company 2 |  | € | €
Staff B | D | 21697.44528 | 7355.837860000001
Staff B | EC | 4225.962079999999 | 5671.91786
Staff B | EC | 25632 | 24444
Staff B | EC | 25632 | 24444
Staff B | S | 0 | 0
Staff B | IT | 1929.8048 | 1875.50664
Headcount | D
 | WP
 | EC
 | DR
 | S
 | F
 | IT
 | MK
 | A
Spreadsheet: 129094d1321448578-unique-concatenate-text-sort-unique-concatenate-text
Sheet: Old Problem

Glass 1 | [NAME] 2 | Spacer | CONCATENATE |  |  | Advanced Filter CONCATENATE | Total |  | Count of CONCATENATE
10.8mm Optilam Clear Ct | 10mm Optifloat Clear | Silver Spacer | 10.8mm Optilam Clear Ct10mm Optifloat ClearSilver Spacer |  |  | 10.8mm Optilam Clear Ct10mm Optifloat ClearSilver Spacer | 1 |  | CONCATENATE | Total
10mm Optifloat Clear | 10.8mm Optilam Clear Ct | Silver Spacer | 10mm Optifloat [NAME] Optilam Clear CtSilver Spacer |  |  | 10mm Optifloat [NAME] Optilam Clear CtSilver Spacer | 1 |  | 10.8mm Optilam Clear Ct10mm Optifloat ClearSilver Spacer | 1
10.8mm Optilam Clear | 6.4mm Optilam Clear | Silver Spacer | 10.8mm Optilam Clear6.4mm Optilam Clear Silver Spacer |  |  | 10.8mm Optilam Clear6.4mm Optilam Clear Silver Spacer | 1 |  | 10.8mm Optilam Clear6.4mm Optilam Clear Silver Spacer | 1
6.4mm Optilam Clear | 10.8mm Optilam Clear | Silver Spacer | 6.4mm Optilam Clear 10.8mm Optilam ClearSilver Spacer |  |  | 6.4mm Optilam Clear 10.8mm Optilam ClearSilver Spacer | 1 |  | 10mm Optifloat [NAME] Optilam Clear CtSilver Spacer | 1
 |  |  |  |  |  | Grand Total | 4 |  | 6.4mm Optilam Clear 10.8mm Optilam ClearSilver Spacer | 1
 |  |  |  |  |  |  |  |  | Grand Total | 4
 |  |  |  |  |  | However only two different Products!!!!!!!!!!!! |  |  | However only two different Products!!!!!!!!!!!!
Spreadsheet: 51253d1250783265-hyperlink-function-help-695975b
Sheet: LIST

PRODUCT DEVELOPMENT INGREDIENT DATABASE
SUPPLIER | [NAME] | WEIGHT | QUANTITY | NO. | CODE | ALLERGENS | DATE IN | DATE OUT | F.A.O. | [NAME]
ALLCHEM INTER | SYNEVO | 100GM | 1 | 4 | [NAME] | AF | 2006-09-29 00:00:00 | 2007-03-01 00:00:00 | PER | LAB
ALL IN ALL INGREDIENTS | GREEN THAI PASTE HOT | 100GM | 1 | 23 | MB347 |  | 2009-07-16 00:00:00 | 2010-01-01 00:00:00 | PH | C/LAB
ALL IN ALL INGREDIENTS | GREEN THAI PASTE | 100GM | 1 | 24 | MB348 |  | 2009-07-16 00:00:00 | 2010-01-01 00:00:00 | PH | C/LAB
ARLA FOODS | HIGH FAT WHEY PROTEIN CONCENTRATE | 1KG | 3 | 1 | SP7089 | D | 2006-03-03 00:00:00 | 2007-03-01 00:00:00 | GW | C/LAB
ARLA FOODS | NUTRILAC RM 7025 | 1KG | 1 | 2 | 303928361 | D | 2006-05-11 00:00:00 | 2007-05-01 00:00:00 | PER | C/LAB
ARLA FOODS | NUTRILAC WHEY PROTEIN CONCENTRATE | 5KG | 1 | 4 | SP 7089 | D | 2006-09-27 00:00:00 | 2007-03-01 00:00:00 | PER | P/P
ARLA FOODS | NUTRILAC WHEY PROTEIN CONCENTRATE | 20KG | 1 | 5 | SP 7089 | D | 2006-09-27 00:00:00 | 2007-03-01 00:00:00 | PER | P/P
ARRHUS | OLIVE OIL | 25KG | 1 | 1 | 1788-06 | AF | 2006-10-09 00:00:00 | 2007-04-01 00:00:00 | GS | P/P
ARTHUR BRANWELL | SUPERCHOC 1 | 100GM | 1 | 1 | 604-35 | AF | 2008-01-31 00:00:00 | 2008-07-01 00:00:00 | PH | C/LAB
ARTHUR BRANWELL | LUXARA SPRAY DRIED LIQURICE EXTRACT | 100GM | 1 | 2 | 507-4 | AF | 2008-01-31 00:00:00 | 2008-07-01 00:00:00 | PH | C/LAB
ARTHUR BRANWELL | CHOCOLUX PLAIN | 100GM | 1 | 3 | 604-7 | D | 2008-01-31 00:00:00 | 2010-01-01 00:00:00 | PH | C/LAB
BACAREL | LACTOSALT OPTITASTE | 250GM | 1 | 1 | C10271 | D | 2007-11-15 00:00:00 | 2008-11-01 00:00:00 | KE | C/LAB
BARENTZ | DELI SPICE | 1KG | 1 | 8 | SMAK 2B-30 | AF | 2007-05-29 00:00:00 | 2007-11-01 00:00:00 | PER | LAB
BHJ | DRINDE | 1KG | 5 | 8 | 1015/SF | AF | 2008-05-07 00:00:00 | 2008-11-01 00:00:00 | CH | LAB
HAX | REDCURRANT POWDER TYPE S | 1.5KG | 1 | 1 | 06 2210 |  | 2006-07-24 00:00:00 | 2007-01-01 00:00:00 | JL | C/LAB
RAPS | AUTHENTIC PEPPERONI | 1KG | 2 | 59 | 1846UK |  | 2008-05-28 00:00:00 | 2009-04-01 00:00:00 | CH | LAB
RAPS | ACCELERATED PEPPERONI | 1KG | 2 | 60 | 01850KAN |  | 2008-05-28 00:00:00 | 2009-04-01 00:00:00 | CH | LAB
RAPS | [NAME] | 1KG | 2 | 61 | 4060D |  | 2008-05-28 00:00:00 | 2009-04-01 00:00:00 | CH | LAB
RAPS | SUPERQUICK GOLD | 1KG | 2 | 62 | _00100 |  | 2008-05-28 00:00:00 | 2009-04-01 00:00:00 | CH | LAB
RAPS | BUTTER BASTE INJECTION | 2KG | 1 | 63 | 77622/01 |  | 2009-03-27 00:00:00 | 2009-09-01 00:00:00 | GS | C/LAB
RAPS | CLIVIA - BOURBON & VANILLA | 1KG | 1 | 64 | 01154d |  | 2009-04-16 00:00:00 | 2010-06-01 00:00:00 | PH | LAB
Spreadsheet: 96712d1296037592-excel-2007-pivot-tables-combination-of-show-items-with-no-data-and-grouping-group-by-date-pivot_showitemswithnodate_vs_groupingdaterange
Sheet: STEP 4

Date | Summary |  |  |  | Count of Summary
2010-01-01 00:00:00 | Item 1 |  |  |  | Years | Date | Total
2010-03-01 00:00:00 | Item 2 |  |  |  | <1/07/2010 | <1/07/2010 | 2
2010-08-01 00:00:00 | Item 3 |  |  |  | 2010 | jan
2010-10-01 00:00:00 | Item 4 |  |  |  |  | feb
2010-10-05 00:00:00 | Item 5 |  |  |  |  | mrt
2010-12-01 00:00:00 | Item 6 |  |  |  |  | apr
2011-03-01 00:00:00 | Item 7 |  |  |  |  | mei
2011-08-01 00:00:00 | Item 8 |  |  |  |  | jun
 |  |  |  |  |  | jul
 |  |  |  |  |  | aug | 1
 |  |  |  |  |  | sep
 |  |  |  |  |  | okt | 2
 |  |  |  |  |  | nov
 |  |  |  |  |  | dec | 1
 |  |  |  |  | 2011 | jan
 |  |  |  |  |  | feb
 |  |  |  |  |  | mrt | 1
 |  |  |  |  |  | apr
 |  |  |  |  |  | mei
 |  |  |  |  |  | jun
 |  |  |  |  |  | jul
 |  |  |  |  |  | aug
 |  |  |  |  |  | sep
 |  |  |  |  |  | okt
 |  |  |  |  |  | nov
 |  |  |  |  |  | dec
 |  |  |  |  | >2/07/2011 | >2/07/2011 | 1
 |  |  |  |  | Grand Total |  | 8
STEP 4 | Setting the date range on the 'Group ...'
 |  | starting at |  | 2010-07-01 00:00:00
 |  | ending at |  | 2011-07-01 00:00:00
 | Problem
 |  | Months jan - feb - mrt- apr - may - jun of 2010 are shown, but are outside the Group range (before july 2010)
 |  | Months jan - aug, sep, okt, nov, dec of 2011 are shown, but are outside the Group range (after july 2011)
 |  | If I remove the option 'Show items with no data ' of Step 3, the filter works fine ...
Spreadsheet: 4a5060bc-b5bd-46b9-b378-bb9c0f17680f
Sheet: Page 10

Permit No.: |  |  | WQ0013200 |  |  | Facility Name: |  | Southeast Brunswick Sanitary District WWTF |  |  |  |  |  | County: | Brunswick |  | Month: |  |  | Year:
Did irrigation occur    at this facility? |  |  |  |  |  | Field Name: |  | L - 5 / (15) |  | Field Name: |  | L - 6 / (13) |  | Field Name: |  | L - 7 / (11) |  | Field Name: |  | L - 8 / (12)
 |  |  |  |  |  | Area (acres): |  | 0.36 |  | Area (acres): |  | 0.45 |  | Area (acres): |  | 0.49 |  | Area (acres): |  | 0.55
 |  |  |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop:
 |  |  |  |  |  | [NAME] (in): |  | 0.1 |  | [NAME] (in): |  | 0.1 |  | [NAME] (in): |  | 0.1 |  | [NAME] (in): |  | 0.1
 |  |  |  |  |  | Annual Rate (in): |  | 32.8 |  | Annual Rate (in): |  | 32.8 |  | Annual Rate (in): |  | 32.8 |  | Annual Rate (in): |  | 32.8
Day | Weather |  |  | Freeboard |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated?
 | Weather Code | Temperature | Precipitation | Storage | 5-Day Upset (if applicable) | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time    Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading
 |  | ºF | in | ft | ft | gal | min | in | in | gal | min | in | in | gal | min | in | in | gal | min | in | in
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
Monthly Loading:
12 Month Floating Total (in):
Spreadsheet: 694362d1599567977-copy-names-from-one-sheet-to-other-workbook-sheets-sample-scoring-spreadsheet1
Sheet: ORG 5

ESCF PROPOSAL EVALUATION SCORING
ORGANISATION NAME: |  | FIRST ROUND RESULT
NAME OF PROPOSAL:
 | Potential Impact - minimum threshold 42% | SCORE | NOTES
 | a)    Relevance and extent of the specific social challenge - What is the scale of the social challenge in the geographic area where the planning will take place? (15%)
 | b)   Potential impact on the challenge - What is the extent of the potential impact of this innovation on this social challenge in this geographic area? (15%)
 | c)    Evidence - What robust national and international evidence exists to support the model or innovation in terms of its effectiveness? What is the evidence on the cost implications of the model compared to alternative approaches? (20%)
 | d)   Scope of potential impact geographically - What is the evidence that the innovation is relevant across EU Member [NAME]? What evidence is there that the approach is relevant in Central and Eastern European Countries? To what extent has the innovation been applied in other countries in Europe? (10%)
 | e)    Promotion of citizen-centred approaches - Does the innovation support service users and end beneficiaries to be self-directed and to be involved in plans to scale social service innovations? (10%)
 | Potential Impact Total
 | Capacities - minimum threshold 12% | SCORE | NOTES
 | a)    Capacities of the applicants - Do the organisation(s) applying have the capacities to produce the plan for scaling the innovation? (10%)
 | b)   Networks and linkages - What is the evidence that key partners (public, private, non-profit, philanthropic) are open to collaborating on developing the plan in the geographic area where the planning will take place and what are the current linkages between the proposers and these organisations? Do the applicants have strong international linkages that could assist with this planning? (10%)
 | Capacities Total
 | Quality of the application to develop the plan - minimum threshold 6% | SCORE | NOTES
 | a)    Activities - Description of activities, timeframe, methodology, risk management. (5%)
 | b)   Budget - Are expenditures associated with the proposed planning activities reasonable and well-substantiated? (5%)
 | Quality of the application to develop the plan Total
 | Total Score
Spreadsheet: 207590d1358506297-filling-a-list-from-the-top-example
Sheet: MainList

 | Item | Description | date on | Date off | owner | contact | Sold? | Active Y/N
 | H1 | Tenerife | 2012-01-16 00:00:00 | 2012-02-18 00:00:00 | ZZ | 6162 |  | Y
 | H2 | Bermuda | 2012-01-19 00:00:00 | 2012-02-21 00:00:00 | XX | 6164 |  | N
 | H3 | Hawaii | 2012-01-22 00:00:00 | 2012-02-24 00:00:00 | AA | 1111 |  | Y
 | H4 | Scotland | 2012-01-25 00:00:00 | 2012-02-27 00:00:00 | BB | 2222 |  | Y
 | H5 | Wales | 2012-01-28 00:00:00 | 2012-03-01 00:00:00 | CC | 3333 |  | N
 | H6 | Australia | 2012-01-31 00:00:00 | 2012-03-04 00:00:00 | DD | 4444 |  | N
 | H7 | New Zealand | 2012-02-03 00:00:00 | 2012-03-07 00:00:00 | EE | 5555 |  | N
 | H8 | Sweden | 2012-02-06 00:00:00 | 2012-03-10 00:00:00 | FF | 6666 |  | Y
 | H9
 | H10
 | H11
 | H12
 | [NAME]
 | H14
 | H15
 | H16
 | H17
 | H18
 | H19
 | H20
Spreadsheet: 38443d1236615305-excel-2007-having-problem-with-averageifs-formula-monthly-gas-reports-2009-ne
Sheet: 2-23 thru 3-1

 |  |  |  |  |  | System:
 |  |  | 2009-02-23 00:00:00 |  | Thru
 |  | Mon | Tue | Wed | Thur | Fri | Sat | Sun
Technician |  | 2009-02-23 00:00:00 |  |  |  |  |  |  | Total
1 |  |  | 63
2 |  |  |  |  |  |  |  |  |  | N/A
3 |  |  |  |  |  | 55
4 |  |  |  |  | 38.65
5 |  |  |  |  | 31.29 |  | 35.27
6 |  | 39.39 |  |  |  |  |  | 31.91
7 |  | 37 |  |  |  | 38.38
8 |  |  |  |  |  |  |  |  |  | VA
9 |  |  |  |  |  |  | 38.5
10 |  |  |  |  |  | 35
11 |  |  |  |  |  |  |  |  |  | N/A
12 |  | 36.74 |  |  | 34
13 |  |  |  | 35.6 |  |  | 36.52
14 |  | 32.55 |  |  |  | 37
15 |  |  |  | 37.4
16 |  |  |  |  | 36.3
17 |  |  | 30.82 |  |  |  | 38.12
18 |  | 33.53 |  |  | 32.89
19 |  |  |  |  |  |  |  |  |  | VA
20
21
22
23
24
25
 |  |  |  |  |  |  | Total:
Spreadsheet: 677671d1589467143-power-query-merge-many-to-many-relationship-and-remove-duplicates-demo
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  | remove duplicates |  | remove duplicates |  | Desired Result
 |  |  |  |  | Database 1 |  | Database 2 |  | Merged DB |  | Column 1 |  | Column 2
 |  |  | Relationship
 |  |  | 3 to 3 |  | 1 |  | a |  | 1 | a | 1 | a | 1 | a | 1 | a
 |  |  |  |  | 2 |  | b |  | 1 | b | 2 | a | 1 | b | 2 | b
 |  |  |  |  | 3 |  | c |  | 1 | c | 3 | a | 1 | c | 3 | c
 |  |  |  |  |  |  |  |  | 2 | a | 4 | x | 4 | x | 4 | x
 |  |  | 2 to 2 |  | 4 |  | x |  | 2 | b | 5 | x | 4 | y | 5 | y
 |  |  |  |  | 5 |  | y |  | 2 | c | 6 | z | 6 | z | 6 | z
 |  |  |  |  |  |  |  |  | 3 | a
 |  |  | 1 to 1 |  | 6 |  | z |  | 3 | b
 |  |  |  |  |  |  |  |  | 3 | c
 |  |  |  |  |  |  |  |  | 4 | x
 |  |  |  |  |  |  |  |  | 4 | y
 |  |  |  |  |  |  |  |  | 5 | x
 |  |  |  |  |  |  |  |  | 5 | y
 |  |  |  |  |  |  |  |  | 6 | z
Spreadsheet: 676554d1588866287-select-dates-when-first-and-last-occurrence-of-a-value-below-date-row-occurs-workday-ranges
Sheet: Sheet1

 | 2020-06-01 00:00:00 | 2020-06-02 00:00:00 | 2020-06-03 00:00:00 | 2020-06-04 00:00:00 | 2020-06-05 00:00:00 | 2020-06-06 00:00:00 | 2020-06-07 00:00:00 | 2020-06-08 00:00:00 | 2020-06-09 00:00:00 | 2020-06-10 00:00:00 | 2020-06-11 00:00:00 | 2020-06-12 00:00:00 | 2020-06-13 00:00:00 | 2020-06-14 00:00:00 | 2020-06-15 00:00:00 | 2020-06-16 00:00:00 | 2020-06-17 00:00:00 | 2020-06-18 00:00:00 | 2020-06-19 00:00:00 | 2020-06-20 00:00:00 | 2020-06-21 00:00:00 | 2020-06-22 00:00:00 | 2020-06-23 00:00:00 | 2020-06-24 00:00:00 | 2020-06-25 00:00:00 | 2020-06-26 00:00:00 | 2020-06-27 00:00:00 | 2020-06-28 00:00:00 | 2020-06-29 00:00:00 | 2020-06-30 00:00:00
worker 1 | 24 | 24 | 24 | 24 |  |  |  |  |  | 24 | 24 | 24 | 24 |  |  | 24 | 24 | 24 |  |  |  |  | 24 | 24 | 24 | 24
worker 2 |  |  |  |  | 24 | 24 | 24 | 24 | 24 | 24 | 24 |  |  |  |  |  |  | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 |  |  |  |  | 24
 | Worker 1 |  | Worker 2
 | Start | End | Start | End
workdays range 1
workdays range 2
workdays range 3
workdays range 4
DFP
DFP
DFP
DFP
DFP
DFP
DFP
DFP
DFP
DFP
DFP
DFP
DFP
DFP
DFP
DFP
Spreadsheet: 729822d1619370189-unique-alphabetical-list-uni
Sheet: Foglio1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8H01
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8H01
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9I07
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8H01
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8H01
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8H01
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8H01
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8H01
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8H01
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8H01
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8H01
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8H01
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4N05
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4N05
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4V11
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4P06
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9U07
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4P06
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4P06
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4O05
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8U26
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4P06
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4P06
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4P06
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9U07
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4O05
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9W08
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9W08
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7X20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9U07
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9U07
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9S12
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8P21
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9F25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4O05
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3U40
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4O05
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9U07
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8P21
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9W08
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4P06
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4F04
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4O05
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8E20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8P20
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4P06
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4P06
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9W08
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3U40
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3U40
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4O05
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4P06
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3U40
Spreadsheet: debra_perlingiere__8429__TIE Info
Sheet: Sheet1

Texas Independent Energy
IPP Contract Information
Company Name |  | Guadalupe Power Partners, LP (GPP) | Odessa-Ector Power Partners, LP (OEPP)
Duns # |  | 16-093-4308 | 09-600-3871
Tax ID |  | 75-2778-388 | 75-2815-428
Address |  | 13760 Noel Road, Ste 930 | 13760 Noel Road, Ste 930
 |  | Dallas, TX  75240 | Dallas, TX  75240
Payment Info
 | Bank Name | Chase Manhattan Bank, N.A. | Chase Manhattan Bank, N.A.
 | Attn: | [NAME] | [NAME]
 | ABA # | 021000021 | 021000021
 | Account # | 9201073195 | 9201073195
 | SubAccount# | 04284400 | 04569300
Commercial Contact:
 | Name | [NAME] | [NAME]
 | Phone | [PHONE] | [PHONE]
 | Fax | [PHONE] | [PHONE]
 | [NAME] | [EMAIL] | [EMAIL]
Accounting Contact:
 | Name | [NAME] | [NAME]
 | Phone | [PHONE] | [PHONE]
 | Fax | [PHONE] | [PHONE]
Spreadsheet: louise_kitchen__24046__East Power Consolidation
Sheet: Northeast Origination

 |  | 2001-09-01 00:00:00 |  | 2001-09-01 00:00:00 |  | %
 |  | YTD Actual |  | Annualized |  | of Total
ENACOMP | Compensation
 | Special Pays | 50000
 | Analysts & Associates
ENABENTX | Benefits & Payroll Taxes
ENAEMPEX | Employee Expense
ENAT&EEX | Travel & Entertainment Expense
ENAOUTSV | Outside Services
ENASUPP | Supplies Expense
ENAMKTEX | Marketing
ENACONTR | Charitable Contributions
ENARENT | Rent
ENATECH | Technology
ENATRANS | Transportation
ENAOTHEX | Other Expenses
ENATAXES | Taxes Other than Income
ENATOTDR | Total Direct Expenses
 | Headcount |  |  | 9
 | Analyst & Associate Headcount |  |  | 5
 | Total Headcount
ENAOUTLG | Outside Legal
ENAOUTTX | Outside Tax
ENAINSUR | Insurance
ENASYSDV | System Development
ENACORIT | Controllable Infrastructure
ENACORRN | Corporate Rent
ENAOTHAL | Other Allocated Direct  Expenses
ENADEPR | Depreciation & Amortization
 | Boondoggle
Spreadsheet: 41806d1240341467-can-2-if-formulas-combine-as-one-test
Sheet: Pipeline Input

HB Graphix, Inc.
Strategic Sales Pipeline Management
Company Confidential
Opportunity Name | Customer Contact | Phone Number | Lead Source | Product Line | Forecast Amount | Sales Phase | Forecast Close | Probability percentage
[NAME] | [NAME] | [PHONE] | web site | promo | 500 | quoted | April | 0.5
 |  |  | customer reference | screen print | 500 | closed | May
 |  |  | web event | embroidery | 500 | contract | June
 |  |  | trade show | promo | 500 | contacted | July
 |  |  | web site | screen print | 500 | quoted | August
 |  |  | customer reference | embroidery | 500 | closed | September
 |  |  | web event | promo | 500 | contract | October
 |  |  | trade show | screen print | 500 | contacted | November
 |  |  | web site | embroidery | 500 | quoted | December
 |  |  | customer reference | promo | 500 | closed | January
 |  |  | web event | screen print | 500 | contract | February
 |  |  | trade show | embroidery | 500 | contacted | March
 |  |  | web site | promo | 500 | quoted | April
 |  |  | customer reference | screen print | 500 | closed | May
 |  |  | web event | embroidery | 500 | contract | June
 |  |  | trade show | promo | 500 | contacted | July
 |  |  | web site | screen print | 500 | quoted | August
 |  |  | customer reference | embroidery | 500 | closed | September
 |  |  | web event | promo | 500 | contract | October
TOTAL |  |  |  |  | 9500
Spreadsheet: 104657d1302180479-excel-2007-find-and-replace-cant-find-text-in-formulas-sample-find-and-replace-error
Sheet: Sheet1

Sample Find & Replace Error
Other Non Operating Income and (Expenses)
 |  |  | Current Year
 |  |  | Current Quarter | Year to Date
 | Detailed List
 | Stock Options
 | RSUs
 | FIN 47 Expense
 | Non-Op Income or Expense - Other -List below ($1M and over)
 | Total Other Non Operating Income and (Expenses)
 |  | Total per Submission
 |  | Difference
Spreadsheet: 57ad0059-c2e1-4ab0-8ada-65ba8584c0ef
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
FCING | Test | FCING | [NAME] | [NAME] | Enzyme Immunoassay (FEIA) |  |  |  |  |  | Draw blood in a plain red-top tube(s), serum gel tube(s) is acceptable. Spin down and send 0.5 mL of serum refrigerated in a plastic vial. | 0.5 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | <2 mcg/mL   The reference range listed on the report is the lower limit of quantitation for the assay. The clinical utility of food-specific IgG tests has not been established. These tests can be used in special clinical situations to select foods for evaluation by diet elimination and challenge in patients who have food-related complaints. It should be recognized that the presence of food-specific IgG alone cannot be taken as evidence of food allergy and only indicates immunologic sensitization by the food allergen in question. This test should only be ordered by physicians who recognize the limitations of the test.   Test Performed by:	Viracor-IBT Laboratories 			1001 NW Technology Dr. 			Lee's Summit, MO 64086 | Monday through Friday | 3 days | 5 - 7 days | 1 | 86001 |  |  |  |  | Viracor-IBT Laboratories
FCING | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 28 days
FCING | Result | FCING | [NAME] | [NAME] | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process