tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: a53c9c3a-24b5-40f2-8b68-133c0be9e2a8
Sheet: Sheet1

[NAME] | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
Quelle: http://ergebnisse.vimentis.ch/
Frage:
Ich bin bereit, länger zu arbeiten, damit meine [NAME] ist.
 | Ich bin mit der Politik in der [NAME] zufrieden.
Antwort | [NAME] | [NAME] eher zu | Neutral / Weiss nicht | [NAME] eher nicht zu | [NAME] nicht zu
Ja | 0.56 | 0.43 | 0.29 | 0.32 | 0.27
Neutral / Weiss nicht | 0.2 | 0.24 | 0.3 | 0.21 | 0.16
[NAME] | 0.25 | 0.33 | 0.42 | 0.47 | 0.57
Angaben zu den [NAME]
Erhebungsjahr | 2011
Stichprobengrösse | 30565
Erhebungszeitraum | 05.11.2011 bis: 30.12.2011
[NAME] | [NAME]
Methodik / Repräsentativität
Um soziodemographische Verzerrungen [NAME], wurden sämtliche [NAME] nach [NAME], Alter, Bildung und Region gemäss der wahren [NAME] älter als 15 Jahre gewichtet. Es bleibt eine psychographische Verzerrung wegen
der [NAME] über das Internet, welche nicht korrigiert [NAME]. Diese Verzerrung wird anhand einzelner [NAME] für jede [NAME] abgeschätzt. Demnach sind [NAME] auf dieser Seite angegebenen [NAME] mit einer
Präzision von &plusmn;2% [NAME].
[NAME] und [NAME] auf dieser Seite dürfen unter Angabe der Quelle weiterverwendet werden.
Spreadsheet: 125062d1318859004-want-to-change-in-format-daily-sales-report-format
Sheet: 16

 |  |  |  |  |  |  |  |  |  |  | Target |  | Acheivement |  |  | Touch | Single | Dual | Smart | [NAME] | Activations |  |  | Competition |  |  | Market Share
S.No. | Dealer Code | Outlet Name | [NAME] | Designation | Channel Type | State | City | [NAME] | FFASM | FFASM No | Monthly | Daily Tgt | Value | Volume | ASP | & Type | [NAME] | [NAME] | Phone | Value | NMS | Music | Whats App | Value | Volume | ASP | Value | Volume | Remarks
1 | NJ&K00352 | abc | A | CMO - Promoter | UMR | AAA | TR | AAABBB | NBNN | 9679676 | 1150000 |  | 39889 | 13 |  | 8424 | 19201 | 20688 |  |  | 1 |  |  | 35000 | 6
2 | NJ&K00360 | dfd | B | CMO - Promoter | UMR | AAA | YRG | AAABBB | NBNN | 9679676 | 6110000 |  | 144280 | 25 |  | 144280 | 119102 | 25178 | 83061 | 3807 | 3 |  |  | 120000 | 25
3 | NJ&K00341 | gee | C | CMO - Promoter | UMR | BBB | HR | AAABBB | NBNN | 9679676 | 650000
4 | NJ&K00397 | dger | D | CMO - Promoter | NSP | CCC | HFR | AAABBB | NBNN | 9679676 | 4290000 |  | 11162 | 3 |  | 7355 | 9424 | 1738 |  | 1350 | 1 |  |  | 61956 | 7
5 | NJ&K00519 | bgec | E | CMO - Solution Specialist | NSP | BBB | FGR | AAABBB | NBNN | 9679676 | 2600000
6 | NJ&K00530 | dsgfew | F | CMO - Promoter | NSP | BBB | HR | AAABBB | NBNN | 9679676 | 2990000
7 | NJ&K00605 | wedd | G | CMO - Promoter | NPP | BBB | FGR | AAABBB | NBNN | 9679676 | 3000000 |  | 48655 | 10 |  | 43759 | 22011 | 26644 | 14824 | 900 | 1
8 | NJ&K00381 | ged | H | Sales Assistant | UMR | BBB | HRT | AAABBB | NBNN | 9679676 | 780000 |  | 7277 | 4 |  |  | 4167 | 3110 |  |  |  |  |  | 1250 | 1
9 | NJ&K00410 | gdf | I | Sales Assistant | UMR | BBB | ESDFD | AAABBB | NBNN | 9679676 | 780000
10 | NJ&K00460 | gfe | J | Sales Assistant | UMR | BBB | OUJH | AAABBB | NBNN | 9679676 | 780000 |  | 38665 | 12 |  | 8424 | 19349 | 19316 | 16055 | 644 |  |  |  | 20100 | 7
11 | NJ&K00646 | ger | K | Sales Assistant | UMR | AAA | KJTY | AAABBB | NBNN | 9679676 | 520000
12 | NJ&K00128 | ger | L | Sales Assistant | UMR | BBB | MTY | AAABBB | NBNN | 9679676 | 650000
13 | NJ&K00186 | noi | M | Sales Assistant | UMR | BBB | JTD | AAABBB | NBNN | 9679676 | 520000
14 | NJ&K03258 | ber | N | Sales Assistant | UMR | CCC | FCVTFGR | AAABBB | NBNN | 9679676 | 520000 |  | 18580 | 7 |  | 4212 | 7506 | 11074 | 5493 |  |  |  |  | 4100 | 2
15 | NJ&K00415 | ouj | O | Sales Assistant | UMR | AAA | TRESS | AAABBB | NBNN | 9679676 | 520000 |  | 42485 | 16 |  | 16299 | 18957 | 23528 |  |  |  |  |  | 13984 | 5
Spreadsheet: 860798d1708798298-sum-values-based-on-specific-end-text-word-and-year-example
Sheet: Out

D&T H | D&T | Year | Month | Day | Date | Overall Item | Item | Store | Location | Cost
41488 |  | 2023 | August |  | 2nd | Milk | Milk 1L | Store 1 | Fake Street 1 Wexford | 1.5
41488 |  | 2023 | August |  | 2nd | Bread | Sliced Bread | Store 2 | Fake Street 2 Amsterdam | 1.2
41489 |  | 2023 | August |  | 3rd | Meat | Rashers | Store 3 | Wexford Street 3 Porto | 2
41490 |  | 2023 | August |  | 4th | Entertainment | Cinema | Store 1 | Fake Street 1 Wexford | 30
41490 |  | 2024 | August |  | 4th | Travel | Bus Ticket | Store 2 | Fake Street 2 Amsterdam | 5
41493 |  | 2024 | August |  | 7th | Travel | Bus Ticket | Store 3 | Fake Street 3 Porto | 16
41494 |  | 2024 | August |  | 8th | Miscellaneous | Watch Battery | Store 1 | Fake Street 1 Wexford | 5
41494 |  | 2024 | August |  | 8th | Drink | Club Lemon | Store 2 | Fake Street 2 Amsterdam | 3
41494 |  | 2024 | August |  | 8th | Miscellaneous | Frying Pan | Store 3 | Wexford Street 3 Porto | 15
Spreadsheet: 00e64d2b-8198-4825-b67a-b83132ff963a
Sheet: Sheet1

[NAME] | Temporada | Cama
 | I
 | P
 | V
 | O
 | I
 | P
 | V
 | O
 | I
 | P
 | V
 | O
 | I
 | P
 | V
 | O
 | I
 | P
 | V
 | O
Spreadsheet: 479144d1473252175-working-days-based-on-month-work-day-calculator
Sheet: CPM

Critical Path Method
HELP
 | Start Date |  |  |  |  |  |  |  |  |  | Days to Completion
 | 2015-01-11 00:00:00
 | Finish Date
 |  |  |  |  |  |  |  |  |  | Times (in Days)
 |  |  |  |  |  |  |  |  |  |  | Time Distribution: | Triangular |  |  |  |  |  | [42] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Series Used in the Gantt Chart |  |  |  |  |  |  |  | Weeks | Days
ID | Task Name |  |  | Predecessors (Enter one ID per cell) |  |  |  |  |  | O (min) | M (most likely) | P ([NAME]) | Duration (exp. time) | ES | EF | LS | LF | Slack |  | EF of Predecessors |  |  |  |  |  |  | Successors |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | LS of Successors |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ES | Critical | +T | -T | Duration | +T | -T | Slack | Events | Events | Axis
1 | Start |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -0.5
2 | Task1
3 | [NAME]
4 | Task3
5 | Task4
6 | Task5
7 | Task6
8 | Task7
9 | Task8
10 | Task9
11 | Task10
12 | Task11
13 | Task12
14 | Task13
15 | Task14
16 | Task15
17 | Task16
18 | Task17
19 | Task18
20 | Task19
21 | Task20
22 | Task21
23 | Task22
24 | Task23
25 | Task24
26 | Task25
27 | Task26
28 | Task27
29 | Task28
30 | Task29
31 | Task30
32 | Task31
33 | Task32
34 | Task33
35 | Task34
36 | Task35
37 | Task36
38 | Task37
39 | Task38
40 | Task39
41 | Task40
42 | Task41
43 | Task42
44 | Task43
45 | [NAME]
46 | Task45
47 | Task46
48 | Task47
49 | Task48
50 | Task49
51 | Task50
52 | Task51
53 | Task52
54 | Task53
55 | Task54
56 | Task55
57 | Task56
58 | Task57
59 | Task58
60 | Task59
61 | Task60
62 | Task61
63 | Task62
64 | Task63
65 | Task64
66 | Task65
67 | Task66
68 | Task67
69 | Task68
70 | Task69
71 | Task70
72 | Task71
73 | Task72
74 | [NAME]
75 | Task74
76 | Task75
77 | Task76
78 | Task77
79 | Task78
80 | Task79
81 | Task80
82 | Task81
83 | Task82
84 | Task83
85 | Task84
86 | Task85
87 | Task86
88 | Finish
Spreadsheet: 683098d1592484415-cant-figure-out-mid-function-shift-leave
Sheet: Formula

 |  | 2017 | 2018 | 2019 | 2020
 |  | 1 | 3 | 2 | 4 | 1 | 3 | 2 | 4
 |  | 2 | 4 | 1 | 3 | 2 | 4 | 1 | 3
 |  | 3 | 2 | 4 | 1 | 3 | 2 | 4 | 1
 |  | 4 | 1 | 3 | 2 | 4 | 1 | 3 | 2
 | * | 2017 | 2018 | 2019 | 2020
 |  | 1 | 3 | 2 | 4 | 1 | 3 | 2 | 4
 |  | 2 | 4 | 1 | 3 | 2 | 4 | 1 | 3
 |  | 3 | 1 | 4 | 2 | 3 | 1 | 4 | 2
 |  | 4 | 2 | 3 | 1 | 4 | 2 | 3 | 1
Spreadsheet: darrell_schoolcraft__7346__imball0201
Sheet: Agave

Agave imbalance
 | Measured | Scheduled | Imbalance
56339 |  | 529719
78311 |  | 187452 |  |  |  |  |  |  |  | 2000-01-06 00:00:00 | paper | 0.5
500238 |  | 461928 |  |  |  |  |  |  |  |  | lunch | 7.6
500239 |  | 426881
500293 | 258156 | 276810
500302 |  | 4701
500303 |  | 167805
500305 |  | 826001
500307 |  | 19152
500313 |  | 909
500314
500655
500657 |  | 118988
INDEX
2001-12-31 00:00:00 |  |  | 40609.26
2002-01-17 00:00:00
CBS Volume
 |  |  | 31706
Spreadsheet: feef86f3-7c08-42d4-9685-99505588a25d
Sheet: Sheet1

electronica 2010 - List of exhibitors | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Search by product and service index (6 Entries):
 | 7 Electronic Design (ED/EDA) 7.7 Design and development systems
No. | Company | Country | City | [NAME] | Hall/Booth
1 | [NAME][NAME] | Germany | [NAME] | 51570 | B1.550
2 | dm elektron S.p.A. | Italy | Buja (UD) | 33030 | A1.660
3 | EDA Solutions Limited | Germany | München | 80939 | A4.148
4 | ELiNTER AG | Switzerland | [NAME] | 6330 | A2.258
5 | MathWorks GmbH | Germany | Aachen | 52064 | A6.307
6 | System Plus Consulting | France | Nantes, Cedex | 44307 | A2.533
Spreadsheet: 776773d1649912724-adding-starting-ticket-number-to-raffle-ticket-tracking-raffle_drawing
Sheet: Sheet1

 | Total Tickets Sold
 | Winning Number
 | Winner
Name | Tickets | Lookup
Anne | 5
[NAME] | 5
[NAME] | 12
[NAME] | 7
[NAME] | 8
Fran | 2
George | 5
[NAME] | 3
Ida | 5
[NAME] | 2
 |  |  | << make sure you extend this formula one row below the names, as shown
Spreadsheet: 132631d1323868029-nested-if-and-countif-problem-test
Sheet: Sheet3

Data | Data
1 | 2008-01-05 00:00:00
2 | 2008-02-05 00:00:00
3 | 2008-03-05 00:00:00
4 | 2008-04-05 00:00:00
5 | 2008-05-05 00:00:00
6 | 2008-06-05 00:00:00
[NAME] | Description | Result
 | Counts how many numbers between 1 and 6 (not including 1 and 6) are contained in cells A2 through A7. | 4
 | Counts how many rows have numbers that are less than 5 in cells A2 through A7, and also have dates that are are earlier than 5/3/2008 in cells B2 through B7. | 2
 | Same description as the previous example, but using cell references instead of constants in the criteria.
Spreadsheet: 879712d1727269510-return-list-of-people-at-specific-date-and-shift-nihilimus-excelforum-22-spill-365-aligw
Sheet: Blad1

 | 2024-01-01 00:00:00 | 2024-01-02 00:00:00 | 2024-01-03 00:00:00 | 2024-01-04 00:00:00 | 2024-01-05 00:00:00
[NAME] | v | v | v | v | v
[NAME] | v | l | l | v | v
[NAME] | d | l | l | v | v
[NAME] | d | v | v | d | v
[NAME] | l | v | v | v | v
Available people at specific date:
Type date:
v | l | d
[NAME] | [NAME] | [NAME]
[NAME] |  | [NAME]
 | l | d
[NAME] |  | [NAME]
[NAME]
[NAME]
[NAME]
Spreadsheet: 185625d1349788109-copying-columns-by-set-multiple-samplesheet
Sheet: 2 TRAVEL

person nos | person1 | person2 | person3 | person4 | person5 | person6 |  |  | person1 | person2 | person3 | person4 | person5 | person6
TRAVEL
SECTION 2
Qu1
1 work-emplyd
1 work-self
1 work-student
1 unemployd
1 home
1 retired
1 other
Qu2
2 dist - none
2 dist -5
2 dist -10
2dist +more
2 dist away
Qu3
3 how - car
3 how - bus
3 how - mbike
3 how - share
3 how - bike
3 how - train
3 how - other
Qu4
4 to-Taunton
4  to-Bwater
4 to-Yeovil
4 to-W'lintn
4 to-Station
4 to-Honiton
2.4 other
Qu5
5 gotoHspt'l
5 gotoMedic
5 goto shop
5 gotoHkrdge
5gotoW'lingtn
5 gotoOther
Qu6
6 parish Yes
6 parish No
6 parish NK
6 opinion
 | GOTO [NAME] |  |  |  |  |  |  |  | GOTO [NAME]
Spreadsheet: 802063d1666621767-change-color-of-rows-depending-on-content-exceltest
Sheet: Schedule

UID | Status - ideally the cells below would auto-populate with the status based on the condition in the asset checklist sheet-- "complete" for rows that are green in asset checklist, "in progress" for rows that are orange, and "not started" for rows that have no color
8-020323-S
8-020423
8-020423-S
66-120123
18-112122
2-120122
22-120122
12-010123
12-010123-LL
12-010123-S
12-010223
12-010223-LL
12-010223-S
14-120522
16-120522
18-120522
302-010123
14-121922
16-121922
300-010123
Spreadsheet: 75042d1275564045-linking-cells-with-check-boxes-book2
Sheet: Complaints Higher Tier

 |  | TCF Compliance
 |  |  | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | 2010-09-01 00:00:00 | 2010-10-01 00:00:00 | 2010-11-01 00:00:00 | 2010-12-01 00:00:00
 |  | All closed complaints as % of claims received | 0.0075 | 0 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  | % of complaints not closed within 24hrs | 0.3333333333333333 | 0 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  | % of cases with a compensation payment from all closed complaints | 0.6666666666666666 | 0 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  | Y | 0 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  | 0 | 0 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  | 0 | 0 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | 0.0075 | 0 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  | 0.3333333333333333 | 0 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
 |  |  | 0.6666666666666666 | 0 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Spreadsheet: 715997d1611952767-showing-zero-in-cell-book1b
Sheet: Sheet1

 | Starting | 507.89
 | Payment | Balance
 | 30
 | 20
 | 10
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
 | 0
Spreadsheet: 119510d1314476164-count-if-if-value-in-other-cell-in-the-row-matches-book2
Sheet: Sheet4

name | city | letter |  | city | letter | Count
tom | new york | A |  | all | A
[NAME] | new york |  |  | all | B
[NAME] | london | B |  | all | C
kate | washington | C |  | new york | A
jake | washington | A |  | new york | B
 |  |  |  | new york | C
 |  |  |  | london | A
 |  |  |  | london | B
 |  |  |  | london | C
all |  |  |  | washington | A
A |  |  |  | washington | B
B |  |  |  | washington | C
C
new york
A
B
C
london
A
B
C
washington
A
B
C
Spreadsheet: 725109d1616532394-annual-pay-raise-formula-to-add-to-personnel-budget-costs-payroll-annual-raises-formula-v2
Sheet: Personnel

 | Job Title | Employee Name | Status | Hire Date | Term Date | Annual Pay | FT or PT | [NAME] or Hourly | [NAME] |  | 2019-01-01 00:00:00
 | Art Director |  | Filled | 2018-07-15 00:00:00 | 2020-01-31 00:00:00 | 150000 | FT | Salary
 | Senior Marketing Manager |  | Filled | 2019-03-20 00:00:00 |  | 150000 | FT | Salary
 | VP Product |  | Filled | 2022-03-01 00:00:00 |  | 150000 | FT | Salary
 | Annual raises on anniversary date of hire: |  | 0.03
 | Start date of annual raises: |  | 2022-01-01 00:00:00
Spreadsheet: 722746d1615390815-formula-fails-to-copy-correctly-example
Sheet: Rates

 | Band |  |  |  |  |  | Bonus
 | 0 | 0
 | 1 | 9 |  |  |  |  | 1001
 | 2 | 9.5 |  |  |  |  | 1002
 | 3 | 10.5 |  |  |  |  | 1003
 | 4 | 15 |  |  |  |  | 1004
 | 5 | 17 |  |  |  |  | 1005 |  |  |  |  |  | Overnight |  | 100
 | 6 | 20 |  |  |  |  | 1006
 | 7 | 14.65 |  |  |  |  | 1007
 | 8 | 0 |  |  |  |  | 1008
 | 9 | 0 |  |  |  |  | 1009
 | 10 | 0
 | 11 | 0
 | 12 | 0
 | 13 | 0
 | 14 | 0
 | 15 | 0
 | 16 | 0
 | 17 | 0
 | 18 | 0
 | 19 | 0
 | 20 | 0
 | 21 | 0
 | 22 | 0
 | 23 | 0
 | 24 | 0
 | 25 | 0
 | 26 | 0
 | 27 | 0
 | 28 | 0
 | 29 | 0
 | 30 | 0
Spreadsheet: kam_keiser__17993__ECC counterparties
Sheet: Sheet1

Global Id | Counterparties with Master Agreements with ECC
53490 | Agrium Inc.   (Enron Canada Corp.)
11108 | Alberta Energy Company Ltd. (Enron Canada Corp.)
50591 | Aquila Canada Corp.
102342 | Aquila Capital & Trade
46749 | BC Gas Utility Ltd.  (ECC)
6194 | Beau Canada Exploration Ltd. (Enron Canada Corp.)
6203 | Blue Range Resource Corporation   (Enron Canada Corp.)
55399 | Calibre Energy Inc.  (f\k\a Deep Basin Energy Inc.) (Enron Canada Corp.)
54449 | Canadian Forest Oil Ltd. (f\k\a Saxon Petroleum Inc.)   (Enron Canada Corp.)
58979 | Canadian Natural Resources   (Enron Canada Corp.)
69336 | Cannat Resources Inc. (f\k\a Sceptre Resources Limited) (Enron Canada Corp.)
26427 | Consumers' Gas Company Ltd. (The) (Enron Canada Corp.)
23846 | Corvair Oils Ltd. (Enron Canada Corp.)
11106 | Crestar Energy, Inc. (f\k\a Grad & Walker Energy Corporation) (Enron Canada Corp.)
11110 | Dow Chemical Canada Inc. (Enron Canada Corp.)
54980 | Duke Energy Marketing Limited Partnership (Enron Canada Corp.)
65292 | Dynegy Canada Inc. (f\k\a Novagas Clearinghouse Limited Partnership)   (Enron Canada Corp.)
65345 | Edge Energy Inc.  (f\k\a Alberta Oil & Gas Limited) (Enron Canada Corp.)
11105 | Encal Energy Ltd. (Enron Canada Corp.)
1579 | Energy West Incorporated   (Enron Canada Corp.)
53341 | Engage Energy Canada, L.P. (Enron Canada Corp.)
49845 | Fletcher Challenge Industries Limited (Enron Canada Corp.)
64048 | Forte Energy Ltd. (Enron Canada Corp.)
26206 | Fortune Energy Inc. (Enron Canada Corp.)
11111 | Gulf Canada Resources Limited   (Enron Canada Corp.)
11332 | Humble Petroleum Marketing Ltd. (Enron Canada Corp.)
6186 | [NAME]   (Enron Canada Corp.)
46469 | Jolliet Energy Resources Inc. (Enron Canada Corp.)
6214 | Methanex Corp. (Enron Canada Corp.)
26085 | Northrock Resources Ltd. (Enron Canada Corp.)
69369 | NOVA Chemicals Corporation   (Enron Canada Corp.)
26211 | Oiltec Resources Ltd. (Enron Canada Corp.)
54438 | PG&E Energy Trading, Canada Corporation   (Enron Canada Corp.)
64368 | Papier [NAME]. (Enron Canada Corp.)
26037 | Petro-Canada   (Enron Canada Corp.)
6192 | Pinnacle Resources Ltd.   (Enron Canada Corp.)   (Trades may not exceed two (2) years)
5177 | SaskEnergy Incorporated   (Enron Canada Corp.)
5196 | Startech Energy Inc. (Enron Canada Corp.)
6218 | Talisman Energy, Inc. (Enron Canada Corp.)
55898 | TransAlta Energy Marketing Corp.   (Enron Canada Corp.)
48528 | TransCanada Energy Financial Products Limited    (Enron Canada Corp.)
10839 | Vermont Gas Systems Inc. (Enron Canada Corp.)
 | highlighted counterparties are not active counterparties on EOL - as of 2/22/2001
Spreadsheet: 860695d1708697678-need-formula-to-automatically-calculate-the-incentive-incentive-calculation-query
Sheet: Sheet1

Need to count how much excess achievement against target per slab
Examples
Green will always change |  | Blue should be formula
Target | Acheivement | 0-10 | 11-15 | 16-20 | 21+
5 | 12 | 5 | 2 | 0 | 0 | if target is 5, 6th-10th will be counted in 0-10 column and 11th-12th will be counted in 11-15 column
7 | 26 | 3 | 5 | 5 | 6
12 | 18 | 0 | 3 | 3 | 0
10 | 8 | 0 | 0 | 0 | 0
Spreadsheet: 735167d1622731735-difficulty-exclusding-duplicates-when-using-sumproduct-or-sumifs-with-multiple-criteria-test-data
Sheet: data

Period | Cost Centre | Name | Time
1 | H0F100 | Mrs A | 1
1 | H0F100 | Miss B | 1
1 | H0F100 | Mr J | 0.44
1 | H0F100 | Mr T | 0.48
1 | H0F100 | Mr T | 0.48
1 | H0F120 | Miss H | 0.8
1 | H0F120 | Mr B | 1
1 | H0F130 | Mr G | 1
1 | H0F100 | Miss B | 1
1 | H0F130 | Mr F | 0.6
2 | H0F100 | Mrs A | 1
2 | H0F100 | Miss B | 1
2 | H0F100 | Mr J | 0.44
2 | H0F100 | Mr T | 0.48
2 | H0F100 | Mr T | 0.48
2 | H0F120 | Miss H | 0.8
2 | H0F120 | Mr B | 1
2 | H0F130 | Mr G | 1
2 | H0F100 | Miss B | 1
2 | H0F130 | Mr F | 0.6
2 | H0F120 | Miss H | 0.8
2 | H0F130 | Mr G | 1
2 | H0F130 | Mr G | 1
2 | H0F100 | Mr J | 0.44
Spreadsheet: 718527d1613165445-return-unique-count-example
Sheet: Example

ID | Value | Comment
A1 | 10 | Price
A1 | 10 | Price
A1 | 10 | Price
B1 | 5 | Value
B1 | 5 | Value
C1 | 20
D1 | 15 | Value
D1 | 14 | Value
Spreadsheet: 79811d1280045813-transposing-multiple-rows-example
Sheet: Sheet4

 | Distance(m)
Sum of Value | Column Labels
Depth(m) | 1 | 2 | 3 | 4
1.11 | 0.72 | 8.58 | 2.98 | 3.98
1.36 | 1.89 | 9.32 | 6.9 | 4.25
1.61 | 7.54 | 11.96 | 10.67 | 3.24
1.86 | 3.72 | 7.48 | 14.41 | 2.95
Spreadsheet: mark_haedicke__24598__Budget Worksheet-MEH
Sheet: Sheet1

Budget Worksheet - 2001 - 2002
 |  |  | 2001 Plan |  |  |  | 2002 Plan
 | Inside | Outside | Total |  | Inside | Outside | Total
EWS* | 18947969 | 22873102 |  |  |  | 31000000 | 53825782
Enron Canada-Keohane |  | 713134 | 713134 |  |  | 151000 | 1171844
Enron Europe-Evans
EES-Sharp |  | 14984877 | 22098265 |  |  | 12000000 | 22450837
Global Finance-Mintz |  | 129080 | 2556212 |  |  | 100066 | 2638645
M&A-Mordaunt | 0 | 0 | 0 |  |  | 8000000 | 9294669
Total
*Excludes Global Assets (Lundstrom) and South America (Novak)
Spreadsheet: jeffrey_a_shankman__13996__Exhibit 14 (Scenario 2)
Sheet: DWR Billing Determinants (2)

DWR Billing Determinants
Update July 22, 2001
 | System |  |  | SB 43 Customers |  |  | AB 265 Customers
Period | GWh | Current Rate | Revenues | Sales | Current Rate | Revenues | Sales | Current Rate | Revenues
Q1,2001 | 1096 | 6.5 |  |  | 6.5 |  |  | 6.5
Q2,2001 | 1919 | 6.5 |  |  | 6.5 |  |  | 6.5
Q3,2001 | 2443 | 6.5 |  |  | 6.5 |  |  | 6.5
Q4,2001 | 2348 | 6.5 |  |  | 6.5 |  |  | 6.5
Q1,2002 | 2514 | 6.5 |  |  | 6.5 |  |  | 6.5
Q2,2002 | 2662 | 6.5 |  |  | 6.5 |  |  | 6.5
Q3,2002 | 2994 | 6.5 |  |  | 6.5 |  |  | 6.5
Q4,2002 | 2655 | 6.5 |  |  | 6.5 |  |  | 6.5
Jan01-Dec02
Oct01-Dec02
Mar27-Dec02
Oct01-Sept03
Mar27-Dec03
Spreadsheet: 7908f776-ff12-4f6f-87e8-d77ecf535439
Sheet: SY2013 - Public Form

Responsible form completer:
 |  | Name  (Type full name to serve as electronic signature) |  |  | Title |  |  | Date |  | E-mail |  |  | Phone
By initialing in the accompany box, I agree that the below information is accurate, void of duplications and/or other fraudulent errors. |  |  |  |  |  |  |  |  | Electronic verification
District authorization:
 |  | Name  (Type full name to serve as electronic signature) |  |  | Title |  |  | Date |  | E-mail |  |  | Phone
By initialing in the accompany box, in witness whereof, I agree the below information is accuracte, void of duplications and/or other fraudulent errors. |  |  |  |  |  |  |  |  | Electronic verification
District/Building Info. |  | [NAME]. |  |  |  |  | Certification(s) Earned (List each incentivized certification earned by the student.)
USD# | SchoolName | F-Name | L-Name | [NAME] | DOB | GradDate | CertCode1 | TestDate1 | CertCode2 | TestDate2 | CertCode3 | [NAME] | CertCode4 | TestDate4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -          District Name/Number
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -          Student Name
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -          Student ID
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -          Student DOB
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -          Graduation date
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -          Certification earned