tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 837713d1690375520-calculate-top-7-team-points-and-sort-by-scores-2023-gacx-results-work
Sheet: Team Standings

 | Team Name | Total | ELKS | GPCX | BW | DLV | MACON | NASH | ATH1 | ATH2 |  | Behind Leader | Behind next place |  |  |  |  |  |  |  |  |  |  |  |  |  | Team Master list | Series Points | ELKS | GPCX | BW | DLV | MACON | NASH | ATH1 | ATH2
1 | Gulo Composite | 178 |  |  |  | 0 | 0 | 0 | 0 | 0 |  | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | MACC RACING |  |  |  |  | 0 | 0 | 0 | 0 | 0
2 | The Paceline Project p/b LC Food | 145 |  |  |  | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Thunder Thighs |  |  |  |  | 0 | 0 | 0 | 0 | 0
3 | Force ATL | 129 |  |  |  | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  | 0 | 0 | 0 | 0 | 0
4 | Nomad Cycling Services | 128 |  |  |  | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Gulo Composite |  |  |  |  | 0 | 0 | 0 | 0 | 0
5 | MACC RACING | 52 |  |  |  | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | The Paceline Project p/b LC Food |  |  |  |  | 0 | 0 | 0 | 0 | 0
6 | [NAME] | 51 |  |  |  | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Force ATL |  |  |  |  | 0 | 0 | 0 | 0 | 0
7 | Women’s Health Professionals race team | 49 |  |  |  | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  | 0 | 0 | 0 | 0 | 0
8 | Team Type 1 | 38 |  |  |  | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Women’s Health Professionals race team |  |  |  |  | 0 | 0 | 0 | 0 | 0
9 | [NAME] | 30 |  |  |  | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nomad Cycling Services |  |  |  |  | 0 | 0 | 0 | 0 | 0
10 | Sorella Cycling p/b Hincapie Sportswear | 27 |  |  |  | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Team Type 1 |  |  |  |  | 0 | 0 | 0 | 0 | 0
11 | Thunder Thighs | 19 |  |  |  | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mission Devo Cycling p/b Tyler Perry Studios |  |  |  |  | 0 | 0 | 0 | 0 | 0
12 | Mission Devo Cycling p/b Tyler Perry Studios | 19 |  |  |  | 0 | 0 | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sorella Cycling p/b Hincapie Sportswear |  |  |  |  | 0 | 0 | 0 | 0 | 0
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
Spreadsheet: andy_zipper__464__11_26_01LO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | CL F2 | 18.5 | 215 | 230 | 65.7 | 70.3 | 0.79 | 2001-11-26 10:14:00
 | CL G2 | 19 | 340 | 360 | 60.4 | 64 | 0.74 | 2001-11-26 10:14:00
 | CL H2 | 19 | 400 | 420 | 57 | 59.9 | 0.7 | 2001-11-26 10:14:00
 | CL J2 | 19 | 440 | 460 | 53.9 | 56.4 | 0.66 | 2001-11-26 10:14:00
 | CL K2 | 19.5 | 480 | 505 | 50.4 | 53.1 | 0.63 | 2001-11-26 10:14:00
 | CL M2 | 19.5 | 500 | 520 | 48.1 | 50 | 0.6 | 2001-11-26 10:14:00
 | CL N2 | 19.5 | 515 | 535 | 45.7 | 47.5 | 0.57 | 2001-11-26 10:14:00
 | CL Q2 | 20 | 540 | 560 | 43.7 | 45.4 | 0.56 | 2001-11-26 10:14:00
 | CL U2 | 20 | 545 | 565 | 41.7 | 43.3 | 0.53 | 2001-11-26 10:14:00
 | [NAME] | 20 | 555 | 580 | 40.3 | 42.1 | 0.52 | 2001-11-26 10:14:00
 | CL X2 | 20 | 555 | 580 | 38.5 | 40.3 | 0.5 | 2001-11-26 10:14:00
 | [NAME] | 20 | 555 | 585 | 37 | 39.1 | 0.48 | 2001-11-26 10:14:00
 | CL M3 | 20.5 | 570 | 600 | 31 | 32.6 | 0.41 | 2001-11-26 10:14:00
 | CL Z3 | 20.5 | 570 | 600 | 27.5 | 29 | 0.36 | 2001-11-26 10:14:00
 | CL M4 | 21 | 570 | 600 | 24.6 | 25.9 | 0.33 | 2001-11-26 10:14:00
Spreadsheet: 889965d1741037445-reference-a-table-object-in-let-merge-tables-with-inheritance
Sheet: Child

All these are 'children' of the first three primary' records.
Key Value | Parent | Value 2 | Value 4 | Value 5
234577 | 1234561
234578 | 1234562
234579 | 1234563
234580 | 1234561
234581 | 1234562
234582 | 1234563
234583 | 1234561
234584 | 1234562
234585 | 1234563
234586 | 1234561
234587 | 1234562
234588 | 1234563
234589 | 1234561
234590 | 1234562
234590 | 1234563
Spreadsheet: 60568d1261083859-printed-sheet-in-different-format-than-worksheet-before-print
Sheet: RFPs

CLIENT | DUE | REQ | OFFERING | BUDGET | AE | STATUS
The Ladders | 2009-12-23 00:00:00 | 2009-12-20 00:00:00 | (2) [NAME], (1) Below the Line, (1/stunt) Open, (1) Tagged Promos | $100K | CH | Submitted
Maybelline | 2009-12-25 00:00:00 | 2009-12-20 00:00:00 | 52 week elements across fashion week, stunts, holiday, festivals | $1M | CH | Submitted
Spreadsheet: 125819d1319225203-source-of-a-cell-reference-gwa000-2011-10-21
Sheet: Sheet1

Selected item |  |  | Row
widget | 10 |  | 15
Item | Price
hot dogs | 2.59
hamburgers | 3.59
apples | 1.03
bananas | 0.59
oranges | 2.27
widget | 10
carrots | 0.89
potatoes | 3.59
beans | 1.29
Spreadsheet: 262421d1378141889-choosing-one-of-the-duplicate-customer-info-testworkbook_unsort_optimize_customer_-ijulian-_
Sheet: Report

Date From | 2013-01-01 00:00:00
Date To | 2013-08-27 00:00:00
Agent | Customer | PENDING | CANCEL | GOOD | Total | Column2
 | 2012 A J And Carol Manker Family Trust Dated 06/22/2012,  9-180038527
 | Abalos, Heather Oro 9-178537891
 | Abantao, [NAME] 9-178524376
 | Abshire, Kimberly D 9-175949879
 | Academia, [NAME]
 | Acosta, Josafath 9-177958678
 | Adams, Jr, [NAME] 9-178588989
 | Adams, Lannia Alvanie 9-178968403
Total
Spreadsheet: 333263e9-5b66-4089-86d4-22fafde55a50
Sheet: Sheet1

Rank | Reference | Outcome
1 | BB/L014130/1 | Funded
2 | BB/L013940/1 | Funded
3 | BB/L01386X/1 | Funded
4 | BB/L013916/1 | Fundable
5 | BB/L013886/1 | Fundable
6 | BB/L013878/1 | Fundable
7 | BB/L013843/1 | Fundable
8 | BB/L013894/1 | Fundable
9 | BB/L013983/1 | Fundable
10 | BB/L013967/1 | Fundable
11 | BB/L013924/1 | Fundable
12 | BB/L013908/1 | Fundable
13 | BB/L013975/1 | Fundable
14 | BB/L013932/1 | Fundable
15 | BB/L013959/1 | Not fundable
Spreadsheet: 172016d1343951588-sumif-with-match-functionality-sumif-and-match
Sheet: Sheet1

 |  | DATA |  |  |  |  |  |  |  | Final Report
 |  | Name | 2012-01-01 00:00:00 | 2012-04-15 00:00:00 | 2012-01-03 00:00:00 | 2012-01-04 00:00:00 | 2012-01-05 00:00:00 |  |  | Name | 2012-01-01 00:00:00 | 2012-01-03 00:00:00 | 2012-01-04 00:00:00 | 2012-01-05 00:00:00 | 2012-04-15 00:00:00
 |  | [NAME] | 45 | 50 | 50 | 50 | 50 |  |  | [NAME]
 |  | [NAME] | 50 | 55 | 55 | 55 | 55 |  |  | [NAME]
 |  | Sue | 55 | 60 | 50 | 60 | 60 |  |  | Sue
 |  | [NAME] | 60 | 45 | 55 | 45 | 45
 |  | [NAME] | 45 | 50 | 60 | 50 | 50 |  |  | I am looking for an equation that allows me to sumif the category name in column K from column C but also add the functionality of matching the dates in row 3 versus just dragging the equation over.  I can do the sumif but not sure where to add in the match to the equation to ensure I am pulling over the correct date.  Any other suggestions would be much appreciated.  Thank you
 |  | [NAME] | 50 | 55 | 45 | 55 | 55
 |  | Sue | 55 | 60 | 50 | 60 | 60
 |  | [NAME] | 60 | 45 | 55 | 55 | 50
 |  | [NAME] | 45 | 50 | 60 | 60 | 55
 |  | [NAME] | 50 | 55 | 45 | 45 | 50
 |  | Sue | 55 | 60 | 50 | 50 | 55
 |  | [NAME] | 60 | 55 | 55 | 55 | 60
Spreadsheet: 751598d1634205001-matrix-to-row-matriz_inadimplentes_ask_v2
Sheet: BD

Name | Value | Month
Spreadsheet: 491365d1480438898-months-since-last-purchase-and-reseller-count-copy-of-months-since-purchase-and-reseller-count
Sheet: Resellers per SKU

 | Reseller Count
Product | 2016-05-01 00:00:00 | 2016-06-02 00:00:00 | 2016-07-03 00:00:00 | 2016-08-04 00:00:00 | 2016-09-05 00:00:00 | 2016-10-06 00:00:00
Product 1
Product 2
Product 3
Product 4
Product 5
Product 6
Spreadsheet: 727275d1617814072-removing-duplicates-leaving-a-set-amount-countif-and-filter-aligw
Sheet: Sheet1

Company | [NAME] | Count
cra | [EMAIL]
cra | [EMAIL]
cra | [EMAIL]
cra | [EMAIL]
cra | [EMAIL]
cra | [EMAIL]
cra | [EMAIL]
halliburton | [EMAIL]
halliburton | [EMAIL]
halliburton | [EMAIL]
halliburton | [EMAIL]
halliburton | [EMAIL]
halliburton | [EMAIL]
halliburton | [EMAIL]
huawei | [EMAIL]
huawei | [EMAIL]
huawei | [EMAIL]
huawei | [EMAIL]
huawei | [EMAIL]
kbr | [EMAIL]
kbr | [EMAIL]
kbr | [EMAIL]
kbr | [EMAIL]
kbr | [EMAIL]
[NAME] | [EMAIL]
[NAME] | [EMAIL]
[NAME] | [EMAIL]
[NAME] | [EMAIL]
[NAME] | [EMAIL]
[NAME] | [EMAIL]
[NAME] | [EMAIL]
microsoft | [EMAIL]
microsoft | [EMAIL]
microsoft | [EMAIL]
microsoft | [EMAIL]
microsoft | [EMAIL]
microsoft | [EMAIL]
[NAME] | [EMAIL]
[NAME] | [EMAIL]
[NAME] | [EMAIL]
[NAME] | [EMAIL]
nokia | [EMAIL]
nokia | [EMAIL]
nokia | [EMAIL]
nokia | [EMAIL]
nokia | [EMAIL]
qnb | [EMAIL]
qnb | [EMAIL]
qnb | [EMAIL]
qnb | [EMAIL]
qnb | [EMAIL]
qnb | [EMAIL]
qnb | [EMAIL]
safarigroup | [NAME]
safarigroup | [NAME]
safarigroup | [NAME]
safarigroup | [NAME]
safarigroup | [NAME]
siemens | [EMAIL]
siemens | [EMAIL]
siemens | [EMAIL]
siemens | [EMAIL]
siemens | [EMAIL]
siemens | [EMAIL]
siemens | [EMAIL]
tamu | [EMAIL]
tamu | [EMAIL]
tamu | [EMAIL]
tamu | [EMAIL]
weatherford | [EMAIL]
weatherford | [EMAIL]
weatherford | [EMAIL]
weatherford | [EMAIL]
weatherford | [EMAIL]
weatherford | [EMAIL]
zeronetechnologies | [EMAIL]
zeronetechnologies | [EMAIL]
zeronetechnologies | [EMAIL]
zeronetechnologies | [EMAIL]
zeronetechnologies | [EMAIL]
zeronetechnologies | [EMAIL]
Spreadsheet: 776411d1649728213-how-to-find-multiple-row-headers-based-on-two-values-from-cell-s-issues
Sheet: Sheet1

Catgory |  |  | cfcldx0021 | cfcldx0041 | cfcldx0042 | cfcldx0051 | cfcldx0055 | cfcldx0057 | cfcldx0059 | cfcldx0077 | [NAME]
System is exposed to Exadata Critical Issue EX71 |  |  | Diff | Diff | Diff | Good | Good | Good | Good | Good | Diff
One or more InfiniBand network parameters on [NAME] are not as expected |  |  | Good | Good | Good | Good | Good | Good | Good | Good | Good
One or more data (non-system) disks contains partitions |  |  | Good | Good | Good | Good | Good | Diff | Diff | Good | Good
One or more griddisks examined were not configured as recommended |  |  | Good | Diff | Good | Good | Good | Good | Good | Good | Good
Expected Output
Compliance Issue (Catgory) - Select drop down list | System is exposed to Exadata Critical Issue EX71
Good or Diff - Select drop down list | Diff
Impacted Hosts ( Results)
Spreadsheet: 96669d1296005335-excel-2007-need-to-lock-in-merged-cells-when-selecting-insert-table-example
Sheet: Original Output

Name | hhmmss.dd | data | hhmmss.dd | data
Name1 | time1 | data | time1 | data
 |  | more data |  | more data
 |  | even more data |  | even more data
[NAME] | time2 | data | time2 | data
 |  | more data |  | more data
 |  | even more data |  | even more data
Name1 | time1 | data | time1 | data
 |  | more data |  | more data
 |  | even more data |  | even more data
Name3 | time3 | data | time3 | data
 |  | more data |  | more data
 |  | even more data |  | even more data
Name3 | time3 | data | time3 | data
 |  | more data |  | more data
 |  | even more data |  | even more data
Spreadsheet: 869800d1716363990-find-the-time-period-a-customer-returns-test-customer-aligw
Sheet: Sheet1

 |  |  |  | Customer |  | Date |  |  | formula | What it should be
 |  |  |  | 6 |  | 2024-03-20 00:00:00 |  | 0 - 1 month |  | 5
 |  |  |  | 11 |  | 2024-01-01 00:00:00 |  | 1- 3 month | #[NAME]! | 2
 |  |  |  | 11 |  | 2024-01-09 00:00:00 |  | 3 - 6 month | #[NAME]! | 0
 |  |  |  | 11 |  | 2024-01-23 00:00:00 |  | 6 - 12 month | #[NAME]! | 1
 |  |  |  | 11 |  | 2024-02-02 00:00:00 |  | 12 - 24 month | #[NAME]! | 0
 |  |  |  | 11 |  | 2024-04-03 00:00:00 |  | 24+ | #[NAME]! | 0
 |  |  |  | 11 |  | 2024-04-22 00:00:00
 |  |  |  | 22 |  | 2024-03-03 00:00:00
 |  |  |  | 22 |  | 2024-05-11 00:00:00
 |  |  |  | 33 |  | 2024-06-22 00:00:00
 |  |  |  | 44 |  | 2024-02-12 00:00:00
 |  |  |  | 55 |  | 2024-02-22 00:00:00
 |  |  |  | 55 |  | 2024-03-03 00:00:00
 |  |  |  | 55 |  | 2024-10-09 00:00:00
Spreadsheet: chris_germany__3151__BBC Feb2000 NYSEG
Sheet: Sheet1

Belden & Blake Corporation
February 2000 NYSEG Production Gas
Purchase Calculation
 | Allocated |  | PURCHASE PRICES
 | [NAME] |  | 2.8 | 2.91
AZON CORP | 12925
[NAME] | 695
[NAME] | 769
HADCO | 13186
INDUSTRIAL PAINT | 992
JOHNSTON MEMORIAL UM HOMES | 704
LOCKHEED | 1161
SCHAPIRO | 1175 |  |  |  | 848
BATES TROY | 2408
CANDOR ELEMENTARY | 880
CANDOR HIGH SCHOOL | 880
NORBORD | 13341
SHELTERED | 1107
SPENCER VAN ETTEN | 880
 | 0
Allocated Volumes
Price Tiers
Invoice Amount
Spreadsheet: 890059d1741206811-return-same-value-based-on-2-different-searches-masterprojectlist-test
Sheet: Search

 | Search your job name below
Searcy by Job Name: | DECATUR | q | Job Number: |  | Status:
Delete job name above to search for job number instead
Search by Job Number: | 7102219 | q | Job Name: |  | Status:
Address:
01 - PROJECT EXECUTIVE
02 - SR. PROJECT MANAGER
03 - PROJECT MANAGER |  |  | [NAME]
04 - ASST. PROJECT MANAGER
05 - MECH SUPERINTENDENT
06 - ELECTRICAL SUPERINTENDENT
07 - SR PROJECT ENGINEER
08 - PROJECT ENGINEER
11 - SR. PROJECT ACCT |  |  | TYLER PANELLA-AYHENS
12 - PROJECT ACCT |  |  | MARTHA ZAMORA
13 - ASST PROJECT ACCT |  |  | ERNESTINE YELLOWHAIR-DEAL
14 - FPA TEAM LEAD |  |  | LASHUNDA PENNYWELL
15 - PROJECT ADMIN |  |  | LASHUNDA PENNYWELL
Spreadsheet: john_zufferli__16712__EOLTrades
Sheet: Table

EOL TRADING ACTIVITY FOR ALBERTA FINANCIAL POWER
 | # Deals | # [NAME] | Notional Value ($CDN) | [NAME] | Pool Price
Jan | 152 | 309625 | 42479645 |  | 131.22
Feb | 119 | 661230 | 74501165 |  | 116.75
Mar | 57 | 826828 | 86788942 |  | 97.23
Apr | 213 | 1192040 | 126847065 |  | 114.82
May | 204 | 1054240 | 95564140 |  | 88.34
Jun | 269 | 1593375 | 100250056 |  | 63.59
Jul | 320 | 1238995 | 61249623 |  | 53.47
Aug | 526 | 2947345 | 145673735
Sum
Spreadsheet: 5925a415-9065-446d-89d2-dad38df3804b
Sheet: EPR BS

CONSOLIDATED BALANCE SHEET ([NAME] and Condensed)
 | June 30, |  | September 30,
 | 2012 |  | 2011
(In millions)
Assets
Current assets
Cash and equivalents | 241.3 |  | 460
Restricted cash and investments | 86.2 |  | 92
Jackpot annuity investments | 60.9 |  | 63.2
Receivables, net | 483.4 |  | 487.2
Inventories | 104 |  | 73
Other assets and deferred costs | 209.2 |  | 234.5
Total current assets | 1185 |  | 1409.9
Property, plant and equipment, net | 563.7 |  | 552.1
Jackpot annuity investments | 305.4 |  | 324.6
Contracts and notes receivable, net | 140 |  | 126.4
Goodwill and other intangibles, net | 1699.6 |  | 1401.8
Other assets and deferred costs | 373.2 |  | 339.6
Total Assets | 4266.9 |  | 4154.400000000001
Liabilities and Shareholders' Equity
Current liabilities
Accounts payable | 100.2 |  | 103
Jackpot liabilities, current portion | 146.6 |  | 143
Dividends payable | 17.1 |  | 17.8
Other accrued liabilities | 315.9 |  | 270.9
Total current liabilities | 579.8000000000001 |  | 534.7
Long-term debt | 1969.8 |  | 1646.3
Jackpot liabilities | 338.3 |  | 365.4
Other liabilities | 267.2 |  | 163.2
Total Liabilities | 3155.1 |  | 2709.6
Total Equity | 1111.8 |  | 1444.8
Total Liabilities and Shareholders' Equity | 4266.9 |  | 4154.4
Spreadsheet: 142792d1330012206-excel-2010-matching-one-cell-to-a-list-of-cells-on-another-sheet-sites-and-dialplan-online-help
Sheet: CHS Sites

[NAME]
Name | Address | Location | Numbers
[NAME] |  | Barrie
[NAME] |  | Belleville
CHS Brantford Viavideo |  | Brantford
[NAME] |  | Brockville
[NAME] |  | Chatham
[NAME] |  | [NAME] | 3863101
[NAME] OIS VRI 1 |  | [NAME] | 3863102
[NAME] OIS VRI 2 |  | [NAME] | 3863103
[NAME] |  | [NAME] | 3863104
[NAME] lake Vcon |  | [NAME]
[NAME] |  | [NAME]
[NAME] |  | [NAME]
[NAME] room |  | Kingston
[NAME] |  | Kingston
[NAME] reed room |  | London
[NAME] meeting room A |  | London
[NAME] |  | Newmarket
[NAME] Via Video |  | [NAME]
CHS North Bay Vcon |  | North
CHS Ottawa Board room |  | Ottawa
CHS Ottawa viewstation |  | Ottawa
[NAME] |  | Peel
CHS Peterborough Counseling roo |  | Peterborough
CHS Peterborough Viewstation |  | Peterborough
CHS Sault St. Marie |  | Sault
[NAME] Brdroom A |  | Sudbury
[NAME] [NAME] |  | Sudbury
[NAME] RD-Vcon |  | Sudbury
CHS Thudbay Howard king |  | Thudbay
CHS Thudbay smallroom |  | Thudbay
[NAME] room |  | Timmins
CHS Toronto 3rd Floor Boardroom |  | Toronto
[NAME] [NAME] |  | Toronto
CHS Toronto Connect |  | Toronto
CHS Toronto COO |  | Toronto
[NAME] [NAME] |  | Toronto
[NAME] HR |  | Toronto
CHS Toronto Peikoff Room |  | Toronto
CHS Toronto President & CEO |  | Toronto
[NAME] [NAME] |  | Toronto
[NAME] |  | [NAME]
[NAME] |  | Windsor
CHSVCON - testing |  | Toronto
Spreadsheet: 138122d1327519987-excel-2007-picking-a-value-based-on-criteria-of-two-different-columons-student_classes
Sheet: Sheet1

Reference Table
Classes |  | Grading
Class | Student | Marks | Grade
Class 1 | S1 | 90 | A+
Class 1 | S2 | 80 | A
Class 2 | S1 | 70 | A+
Class 2 | S2 | 60 | A
Description
 | We have different grading system for different classes but same students
 | Marks col is the minimum value to obtain that perticular grade i.e. one should have 90 to obtain A+, if one is securing 89 he will be awarded A
Examples | Input |  |  |  | Output
 | Class | Student | Marks |  | Grade
 | Class 1 | S1 | 89 |  | A
 | Class 1 | S2 | 95 |  | A+
 | Class 2 | S2 | 60 |  | A
Spreadsheet: 692962d1598655935-get-duration-between-timestamp-sample
Sheet: eval

Agent Name | Incident Number | Start | [NAME] | Issue [NAME] | Member/Order Confirmation | Issue Probing | Research | Resolution Action | Transfer | Outbound Call | Gain Member's Agreement | Educate Member | [NAME] | End Call | Comment
Sample 1 | 2000814-000032 | 10:30:00 | 10:32:00 | 10:35:00 | 10:36:00 | 10:38:00 | 10:40:00 | 10:46:00 | 10:46:20 | 10:50:05 | 10:54:00 | 10:55:00 | 10:55:10 | 10:55:38
Sample 2 | 2000814-000033 | 10:45:00 | 10:45:12 | 10:46:00 | 10:46:16 | 10:47:20 | 10:48:00 | 10:50:00 |  |  | 10:52:00 | 10:53:00 | 10:53:56 | 10:54:00
Spreadsheet: 124729d1318571810-counting-unique-values-in-a-table-based-upon-criteria-of-other-columns-sample-worksheet-mod
Sheet: Data Split

 |  |  |  |  |  |  |  |  |  |  |  |  | Customers | Count | Count | Count | Count | Count | Count
Spreadsheet: 267862d1380252015-copy-data-from-one-row-to-another-worksheet-based-on-criteria-sample-proposal-log
Sheet: Proposal Log

Proposal # | Project Description | Customer/Client/Bid To | Bid Due Date | [NAME] | Project Price
1234 | Project 1 | ABC Construction | 2013-09-24 00:00:00 | Booked | 10000
1235 | Project 2 | ABC Construction | 2013-09-25 00:00:00 | Open | 12000
1236 | Project 3 | ABC Construction | 2013-09-26 00:00:00 | Lost | 5000
1237 | Project 4 | ABC Construction | 2013-09-27 00:00:00 | Lost | 3000
1238 | Project 5 | ABC Construction | 2013-09-28 00:00:00 | Open | 4500
1239 | Project 6 | ABC Construction | 2013-09-29 00:00:00 | Booked | 1000
1240 | Project 7 | ABC Construction | 2013-09-30 00:00:00 | Booked | 250
1241 | Project 8 | ABC Construction | 2013-10-01 00:00:00 | Booked | 6000
1242 | Project 9 | ABC Construction | 2013-10-02 00:00:00 | Lost | 3500
1243 | Project 10 | ABC Construction | 2013-10-03 00:00:00 | Lost | 4800
1244 | Project 11 | ABC Construction | 2013-10-04 00:00:00 | Open | 15000
1245 | Project 12 | ABC Construction | 2013-10-05 00:00:00 | Booked | 9000
1246 | Project 13 | ABC Construction | 2013-10-06 00:00:00 | Booked | 6500
1247 | Project 14 | ABC Construction | 2013-10-07 00:00:00 | Lost | 5000
1248 | Project 15 | ABC Construction | 2013-10-08 00:00:00 | Open | 1522
1249 | Project 16 | ABC Construction | 2013-10-09 00:00:00 | Open | 3250
1250 | Project 17 | ABC Construction | 2013-10-10 00:00:00 | Lost | 2750
Spreadsheet: 835491d1688632170-sumproduct-with-dynamic-arrays-query
Sheet: Sheet2

 | Table 1 |  |  |  |  |  |  | Table 2
 | Students |  | Maths | Commerce | Economics | Physics |  | Students | Multipler
 |  |  | 12 | 14 | 16 | 18
 | [NAME] | 15 | 17 | 19 | 21 | 23 |  | [NAME] | 19
 | [NAME] | 20 | 22 | 24 | 26 | 28 |  | [NAME] | 15
 | Joel | 25 | 27 | 29 | 31 | 33 |  | Joel | 11
 | Prasanth | 30 | 32 | 34 | 36 | 38 |  | Prasanth | 10
 | Joel | 35 | 37 | 39 | 41 | 43 |  | Joel | 6
 | [NAME] | 40 | 42 | 44 | 46 | 48 |  | [NAME] | 9
 | [NAME] | 45 | 47 | 49 | 51 | 53 |  | [NAME] | 23
 | [NAME] | 20 | 26 | 32 | 38 | 44 |  | [NAME] | 11
 | [NAME] | 50 | 52 | 54 | 56 | 58 |  | [NAME] | 12
 | Table 3 - Need dynamic formula in Cell C17 |  |  |  |  |  |  | Expected Result in Table 3
 | Students |  | Maths | Commerce | Economics | Physics |  | Students
 |  |  | 687 | 749 | 811 | 873
 | [NAME] | 865 | 987 | 1109 | 1231 | 1353
 | [NAME] | 300 | 330 | 360 | 390 | 420
 | Prasanth | 300 | 320 | 340 | 360 | 380
 | [NAME] | 1035 | 1081 | 1127 | 1173 | 1219
 | [NAME] | 600 | 624 | 648 | 672 | 696
Spreadsheet: 199259d1355160342-trying-to-calculate-day-and-night-hours-based-on-sunset-and-sunrise-sunset-1-
Sheet: Sunset

Flight | Date | A/C Type | Tail | Origin |  | Dest | [NAME] | Arrive | Block | Credit
 | 2012-12-01 00:00:00 | EM2 |  | PSP |  | LAX | 16:32:00 | 17:15:00 | 0.7 | 0.78
 | 2012-12-01 00:00:00 | EM2 |  | LAX |  | IYK | 18:53:00 | 19:43:00 | 0.8 | 0.9
Location |  | Sunrise | Sunset | Location | Date | Sunrise | Sunset
PSP | 2012-12-01 00:00:00 | 06:06:00 | 17:05:00 | LAX | 2012-12-01 00:00:00 | 06:14:00 | 17:11:00
PSP | 2012-12-02 00:00:00 | 06:07:00 | 17:05:00 | LAX | 2012-12-02 00:00:00 | 06:14:00 | 17:11:00
PSP | 2012-12-03 00:00:00 | 06:08:00 | 17:05:00 | LAX | 2012-12-03 00:00:00 | 06:15:00 | 17:11:00
PSP | 2012-12-04 00:00:00 | 06:09:00 | 17:05:00 | LAX | 2012-12-04 00:00:00 | 06:16:00 | 17:11:00
PSP | 2012-12-05 00:00:00 | 06:09:00 | 17:05:00 | LAX | 2012-12-05 00:00:00 | 06:17:00 | 17:11:00
Date | AC ID | AC Type | From | Enroute | To | [NAME] | Arrive | Total | DAY | Night
2012-12-01 00:00:00 | N583SW |  | PSP |  | LAX | 05:35:00 | 07:00:00
2012-12-02 00:00:00 | N583SW |  | LAX |  | IYK | 16:35:00 | 18:05:00
Spreadsheet: 31559d1227450524-lookup-multiple-instances-and-display-in-columns-extract-repts
Sheet: Sheet1

ITEMNuMBR | rec 1 | rec 2 | rec 3 | rec 4 | rec 5 | rec 6 | rec 7 | rec 8 | rec 9 | rec 10
25 | GRN-0008567
33 | GRN-0005857 | GRN-0007252
3600 | GRN-0005514 | GRN-0005514
32511 | GRN-0005190 | GRN-0005367
Spreadsheet: richard_shapiro__32151__Functional Leads ENA
Sheet: East Desk Support

Enron North America - East Desk  Government Affairs Support
 |  | GA Contact
 | Functional Area | Lead | Others
Wholesale Power | Policy Coordination/Development/Preparation | Steffes | GA Team
 | [NAME] (including final Sign Off on filings) | Scott
 | FERC Case Management (Northeast) | Novosel | Fulton
 | FERC Case Management (Midwest & Southeast) | Fulton | Novosel
 | Transmission Service Requests (non ERCOT) | Scott | Nicolay, Novosel
 | Transmission Service Requests (ERCOT) | Twiggs | Ryall, Scott
 | SPP | [NAME] | Twiggs
 | MISO/ARTO | Roan | Migden, Mangskau
 | SE Trans | Connor | Chapman
 | Grid Florida | Staines | Chapman
 | Grid South | Chapman | Connor
 | PJM | Hoatson | Novosel
 | ISO-NE | Allegretti | Novosel
 | NY-ISO | Fromer | Novosel
 | TVA | Connor | Nicolay
 | ERCOT | Twiggs | [NAME]
 | Qualifying Facilities | [NAME] | Scott, Twiggs
 | EWG Issues | Scott | Nicolay
 | Siting (Mid Continent) | Migden
 | Siting (Atlantic Seaboard) | Montovano
 | Siting (Texas) | Ryall
 | Interconnection Requests | Scott | Nicolay, [NAME]
 | Industrial Sales Issues | Scott | Nicolay, [NAME]
Wholesale Gas | Policy Coordination/Development/Preparation | Steffes | GA Team
 | [NAME] (including final Sign Off on filings) | Cantrell
 | FERC Case Management | Fulton | Novosel
 | Transportation Issues (FERC) | Lawner | Cantrell, Scott
 | Storage Issues (FERC) | Lawner | Cantrell, [NAME]
 | Transportation Issues (Texas) | Ryall
 | Storage Issues (Texas) | Ryall
State Level Activities | Mid Continent | Migden
 | Atlantic Seaboard | Montovano
 | Texas | Ryall
Other Federal Matters | Legislative | [NAME] | Shelk
 | DOE | [NAME] | [NAME]
 | EPA | [NAME] | Schoen
 | NERC | Yeung | Ingersoll, [NAME]
Spreadsheet: 819342d1677438295-plot-graph-without-blank-values-test3-tms
Sheet: SELECT

# | ID | distance (m1) | 0
 |  | hits (#)
1 | test
2
3
4
5