tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 6542d3d3-1d96-49dd-a464-73d899d8829e
Sheet: Sheet1

Excavation Deposit Calculations | Unnamed: 1 | Unnamed: 2 | Sq. Feet | Amount
 | Small |  | 1 to 10 | 25
 | Medium |  | 11 to 50 | 100
Input your Length & Width w/in our right-of-way | Length | [NAME] | SF
for larger excavations in Feet---> | 15 | 18 | 270 | 650
Spreadsheet: 67801d1268323100-using-auto-complete-horizontally-test1
Sheet: Test

Date | Cell B1
Host/Sponsor | Cell B2
Location | Cell B3
Audience | Cell B4
Themes | Cell B5
Notes | Cell B6
Past Participation | Cell B7
Cost | Cell B8
Org Participation | Cell B9
Key Personnel | Cell B10
Spreadsheet: 36350d1234241345-formula-that-returns-the-contents-of-every-fourth-row-except-when-that-row-is-empty-example-of-desired-results-andysurtees
Sheet: Sheet1

Number | First Name | Last Name | Account | Status | Amount | Credit Card Number | [NAME] | [NAME] | Lead Source | Date | Memo | Shipping Address 1 | Shipping Address 2 | Shipping City | Shipping State/Province | [NAME] | Item
SO1000 | [NAME] | Doe | Sales Orders | Pending Fulfillment | 139.9 | 1234123412341234 | 06/10 | J Doe | CP1000 | 2009-01-30 00:00:00 | top doorbell | 15 Yemen Road |  | Yemen | Yemen | 3037
SO1000 | [NAME] | Doe | 4000 Sales | Pending Fulfillment | 118.14 | 1234123412341234 | 06/10 | J Doe | CP1000 | 2009-01-30 00:00:00 | ADD POSTAGE @ $9.95 | 15 Yemen Road |  | Yemen | Yemen | 3037 | Light kit
SO1000 | [NAME] | Doe | 4000 Sales | Pending Fulfillment | 9.05 | 1234123412341234 | 06/10 | J Doe | CP1000 | 2009-01-30 00:00:00 |  | 15 Yemen Road |  | Yemen | Yemen | 3037 | Postage, Standard
SO1000 |  |  | GST Collected | Pending Fulfillment | 12.71 |  |  |  | CP1000 | 2009-01-30 00:00:00 | Tax | 15 Yemen Road |  | Yemen | Yemen | 3037 | TS-AU
SO1000 | [NAME] | Doe | Sales Orders | Pending Fulfillment | 139.9 | 1234123412341234 | 06/10 | J Doe | CP1000 | 2009-01-30 00:00:00 | top doorbell ADD POSTAGE @ $9.95 | 15 Yemen Road |  | Yemen | Yemen | 3037 | Light kit
Spreadsheet: 732374d1620917655-group-by-driver-id-number-document-a-values-which-are-not-n-a-power-pivot-adding-count-with-condition-montgai-
Sheet: Sheet1

 | company | department | driver id number | document a |  | Row Labels | Nº Drivers | No Drivers Not N/A
 | comp1 | dep1 | 111111X | N/A |  | comp1 | 5 | 3
 | comp1 | dep1 | 222223Y | Accepted |  | comp2 | 2 | 1
 | comp1 | dep1 | 333333T | Rejected |  | Grand Total | 7 | 4
 | comp1 | dep2 | 111111X | N/A
 | comp1 | dep2 | 444444R | Empty
 | comp1 | dep3 | 222223Y | Accepted
 | comp1 | dep4 | 222223Y | Accepted
 | comp1 | dep4 | 444444R | Empty
 | comp1 | dep4 | 555555Q | N/A
 | comp2 | dep5 | 666666O | N/A
 | comp2 | dep5 | 777777W | Accepted
 | comp2 | dep6 | 666666O | N/A
Spreadsheet: 879588d1727177762-grassroots-football-team-season-stat-tracker-deddymanager1-gameday-stats-spill-365-aligw
Sheet: Season Totals

Player Name | Started | Sub | Goals | Disallowed Goal | Pens | Overall Goals | Assists | Yellow | Red | [NAME] | Pen conceeded | MOTM | Clean Sheet | Fines | Fine Paid? (Y/N)
Player 1 |  | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Player 2 | 1 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Player 3 | 2 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Player 4 | 1 | 2 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Player 5 | 0 | 3 | 3 | 0 | 0 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Player 6 | 2 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0
Player 7 | 2 | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Player 8 | 2 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Player 9 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Player 10 | 3 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Player 11 | 3 | 0 | 1 | 1 | 0 | 1 | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Player 12 | 1 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Player 13 | 3 | 0 | 0 | 1 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0
Player 14 | 3 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Player 15 | 2 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Player 16 | 3 | 0 | 3 | 0 | 1 | 3 | 3 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0
Player 17 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 04bd6a86-1c62-410d-9882-f03379d08e17
Sheet: Table 5.5

Monthly Statistical Bulletin
5.5 Stock exchange indexes
Month | 2010–11 | 2011–12 | 2012–13 | 2013–14 | 2014-15
All ordinaries index (a)
July | 4507.4 | 4500.5 | 4289.400000000001 | 5035.7 | 5623.1
August | 4438.8 | 4369.9 | 4339 | 5125.3 | 5624.6
September | 4636.9 | 4070.7 | 4406.3 | 5217.7
October | 4733.4 | 4360.5 | 4535.4 | 5420.3
November | 4676.4 | 4184.7 | 4518 | 5314.3
December | 4846.9 | 4111 | 4664.6 | 5353.1
January | 4850 | 4325.7 | 4901 | 5205.1
February | 4923.6 | 4388.1 | 5120.38 | 5415.4
March | 4928.6 | 4420 | 4979.9 | 5403
April | 4899 | 4467.2 | 5168.6 | 5470.8
May | 4788.9 | 4133.7 | 4914 | 5473.8
June | 4659.8 | 4135.5 | 4775.4 | 5382
S&P/ASX 200 index (b)
July | 4493.5 | 4424.6 | 4269.1 | 5052 | 5623.9
August | 4404.2 | 4296.5 | 4316.1 | 5135 | 5625.9
September | 4582.9 | 4008.6 | 4387 | 5218.9
October | 4661.6 | 4298.1 | 4517 | 5425.5
November | 4584.4 | 4119.8 | 4506 | 5320.1
December | 4745.2 | 4056.6 | 4648.9 | 5352.2
January | 4753.9 | 4262.7 | 4878.8 | 5190
February | 4831.7 | 4298.5 | 5104.08 | 5404.8
March | 4837.9 | 4335.2 | 4966.5 | 5394.8
April | 4823.2 | 4396.6 | 5191.2 | 5489.1
May | 4708.3 | 4076.3 | 4926.6 | 5492.5
June | 4608 | 4094.6 | 4802.6 | 5395.7
(a) Index at the end of the month. Base: December 1979 = 500.0. (In March 2000 the
all ordinaries index was at 3 133.3, and this was the base used for the S&P/ASX200
index.)
(b) Index at the end of the month. Base: March 2000 = 3 133.3.
Source: Australian Financial Review | http://www.afr.com/home/
 |  |  |  |  |  |  |  | Update
 |  |  |  |  |  |  |  | 1 October 2014
Spreadsheet: 329260d1404241043-obtaining-a-average-price-from-vlookup-formula-assembly-evaluation-before
Sheet: Weed Eater

Kit # | SKU | Quantity | Initial Cost | eBay     Price | Amazon Price | Averge Price | Percent | Item Cost | StoneEdge Current
WE966-721101 | WDE-AMB-WE966_721101 |  | 45 | 110 | 106 |  |  |  | X
 | WDE-HGT-HT_20v | 1 |  | 50 | 50 |  |  |  | X
 | WDE-BAT-WE29068 | 1 |  | 55 | 55 |  |  |  | X
 | WDE-CHG-WE29058 | 1 |  | 25 | 25 |  |  |  | X
WE966-709600 | WDE-AMB-WE966_709600 |  | 45 | 110 | 110 |  |  |  | X
 | WDE-BLO-LB_20v | 1 |  | 58 | 58 |  |  |  | X
 | WDE-BAT-WE29068 | 1 |  | 55 | 55 |  |  |  | X
 | WDE-CHG-WE29058 | 1 |  | 25 | 25 |  |  |  | X
- |  |  | 0
 |  | 1 |  | 0 | 0
 |  | 1 |  | 0 | 0
 |  | 1 |  | 0 | 0
 |  | 1 |  | 0 | 0
 |  | 1 |  | 0 | 0
 |  | 1 |  | 0 | 0
 |  | 1 |  | 0 | 0
 |  | 1 |  | 0 | 0
Spreadsheet: benjamin_rogers__1246__CIPCO model version 04-25-00
Sheet: IS

INCOME STATEMENT
('000 $)
 |  | 2001-12-31 00:00:00 | 2002-12-31 00:00:00 | 2003-12-31 00:00:00 | 2004-12-31 00:00:00 | 2005-12-31 00:00:00 | 2006-12-31 00:00:00 | 2007-12-31 00:00:00 | 2008-12-31 00:00:00 | 2009-12-31 00:00:00 | 2010-12-31 00:00:00 | 2011-12-31 00:00:00 | 2012-12-31 00:00:00 | 2013-12-31 00:00:00 | 2014-12-31 00:00:00 | 2015-12-31 00:00:00 | 2016-12-31 00:00:00 | 2017-12-31 00:00:00 | 2018-12-31 00:00:00 | 2019-12-31 00:00:00 | 2020-12-31 00:00:00 | 2021-12-31 00:00:00 | 2022-12-31 00:00:00 | 2023-12-31 00:00:00 | 2024-12-31 00:00:00 | 2025-12-31 00:00:00 | 2026-12-31 00:00:00 | 2027-12-31 00:00:00 | 2028-12-31 00:00:00 | 2029-12-31 00:00:00 | 2030-12-31 00:00:00 | 2031-12-31 00:00:00
Revenue
Capacity Revenue
Energy Revenue
Ancillary Services |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total Revenue
Expense
Fuel
Fixed Operating Expenses
Variable Operating Expenses
Major [NAME]
Insurance
SG&A
Start Charge
Property Tax |  | 0
Franchise Tax
[NAME] |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Debt Service Reserve [NAME]
Marketing Fee
Administrative Fee
O&M Fees
Total Expense
EBITDA
Depreciation & Amortization
EBIT
Interest Expense
Pretax Book Income
Book State Tax Benefit / (Expense)
Shareholder Fed. Tax Benefit / (Expense)
Net Income
Spreadsheet: 147081d1332516487-is-there-a-formula-for-this-when-working-with-2-tabs-example-of-problem
Sheet: Sheet1

 |  | Enrolments
 | Name | Football | Netball | Hockey | Yoga
 | [NAME] | 2011-11-23 00:00:00 | 2011-11-30 00:00:00 | 2011-12-22 00:00:00
 | [NAME] |  | 2011-11-30 00:00:00 | 2011-12-22 00:00:00 | 2012-01-05 00:00:00
 | Harriet | 2011-12-13 00:00:00 |  |  | 2012-01-24 00:00:00
 | Abbigail | 2011-11-23 00:00:00 | 2011-11-30 00:00:00 | 2011-12-22 00:00:00 | 2012-01-05 00:00:00
 | [NAME] |  | 2011-12-01 00:00:00 | 2011-12-23 00:00:00
 | Leanne | 2011-11-25 00:00:00 | 2011-12-02 00:00:00 |  | 2011-01-07 00:00:00
 | [NAME] | 2011-12-20 00:00:00 | 2011-12-27 00:00:00 | 2011-12-28 00:00:00 | 2012-01-11 00:00:00
 | Bev | 2011-12-20 00:00:00 |  | 2011-12-28 00:00:00 | 2012-01-11 00:00:00
Spreadsheet: 153538d1335957702-rolling-over-man-hours-into-next-month-page-tab-complete-ps-2012
Sheet: Dec 2012

2012-12-01 00:00:00
Date Submitted | Job No | Site | Customer | Project Engineer / Manager | Scope of work | Min People | Actual People | Budget Hours | Actual Hours | Field of work | Start Date | Finish Date | Comments / Additional Information | Special Tools |  |  | Match
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Man Hours | Available Hrs
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Electrical
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Mechanical
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Site Electrical
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Site Mechanical
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Site Supervisor
Spreadsheet: andy_zipper__139__ICE - Mar12 Power & Gas VOL
Sheet: Financial Gas

 |  |  |  |  |  |  | FINANCIAL GAS VOLUME |  |  | TRANSACTIONS
'); } else { document.write(''); } } else { if (navigator.platform == "[NAME]") { document.write(''); } else { document.write(''); } }
Commodity Type:   Financial Gas Swaps/Forwards
Hub:  All
Trade Dates:  Mar-12-01 thru Mar-12-01
 | Description | Strip | Low Price | High Price | Weighted | Last Price | Last Price Date | Volume
 |  |  |  |  | Average Price
 | NG Fin BS, LD1 for GDM
 | NG Fin BS, LD1 for GDM - Mich - Apr01-Oct01 | Apr01-Oct01 | 0.228 | 0.228 | 0.228 | 0.228 | Mar-12-01 19:25 GMT | 1070000 | MMBtus
 | NG Fin BS, LD1 for IF
 | NG Fin BS, LD1 for IF - Henry - Apr01 | Apr01 | 0 | 0 | 0 | 0 | Mar-12-01 16:32 GMT | 300000 | MMBtus
 | NG Fin BS, LD1 for IF - TET M3 - Apr01 | Apr01 | 0.41 | 0.41 | 0.41 | 0.41 | Mar-12-01 17:44 GMT | 150000 | MMBtus
 | NG Fin BS, LD1 for IF - TGT-SL - Apr01-Oct01 | Apr01-Oct01 | -0.02 | -0.02 | -0.02 | -0.02 | Mar-12-01 16:31 GMT | 2140000 | MMBtus
 | NG Fin Sw Swap, FP for GDD
 | NG Fin Sw Swap, FP for GDD - Henry - Bal Month Gas | Bal Month Gas | 5 | 5.09 | 5.044 | 5.09 | Mar-12-01 19:34 GMT | 275000 | MMBtus
 | NG Fin, FP for LD1
 | NG Fin, FP for LD1 - Henry - Apr01 | Apr01 | 5.005 | 5.145 | 5.053 | 5.14 | Mar-12-01 20:02 GMT | 6300000 | MMBtus
 | NG Fin, FP for LD1 - Henry - May01 | May01 | 5.063 | 5.11 | 5.086 | 5.11 | Mar-12-01 14:55 GMT | 310000 | MMBtus
 | NG Fin, FP for LD1 - Henry - Apr01-Oct01 | Apr01-Oct01 | 5.11 | 5.24 | 5.174 | 5.24 | Mar-12-01 21:03 GMT | 20330000 | MMBtus
 | NG Fin, FP for LD1 - Henry - Cal 02 | Cal 02 | 4.765 | 4.765 | 4.765 | 4.765 | Mar-12-01 20:30 GMT | 1825000 | MMBtus
 | NG Fin, FP for LD1 - Henry - Cal 03 | Cal 03 | 4.46 | 4.46 | 4.46 | 4.46 | Mar-12-01 19:17 GMT | 1825000 | MMBtus
Spreadsheet: 761941d1641308750-multiple-dynamic-rows-to-be-filter-based-criteria-on-another-sheet-demo_v01
Sheet: Sheet1

Team A
DATE | NAME | SITE | SHIFT | PROJECT | TASK | Complexity | HOURS WORKED | NOTES
2021-12-02 00:00:00 | Emma | USA | Morning | love_watch | 15696 | Simple | 8 | Good
2021-12-02 00:00:00 | Michel | USA | Morning | Leave | - | - | - | -
2021-12-02 00:00:00 | Victor | USA | Evening | love_watch | 15696 | Mid | 4 | Average Quality
2021-12-02 00:00:00 | Parker | USA | Evening | [NAME] | 9588 | Hard | 2 | Good
2021-12-03 00:00:00 | Mark | USA | Morning | love_watch | 65986 | Hard | 6 | Average work
2021-12-03 00:00:00 | [NAME] | USA | Evening | love_watch | 15696 | Mid | 8 | Good
2021-12-03 00:00:00 | Parker | USA | Night | [NAME] | 9588 | Simple | 2 | Good
2021-12-04 00:00:00 | [NAME] | USA | Night | P_6255 | 1023 | Simple | 8 | Good
2021-12-04 00:00:00 | Smith | USA | Morning | P_6255 | 1023 | Simple | 8 | Good
2021-12-04 00:00:00 | [NAME] | USA | Evening | RV_156689 | 986 | Hard | 8 | Good
2021-12-05 00:00:00 | Rose | USA | Morning | Leave | - | - | - | -
2021-12-08 00:00:00 | Michel | USA | Evening | love_watch | 889 | Simple | 6 | Average
2021-12-09 00:00:00 | Victor | USA | Night | love_watch | 15696 | Mid | 8 | Good
Spreadsheet: 775969d1649420037-display-set-value-based-on-location-of-item-in-counted-range-puch-count-test-2
Sheet: Sheet1

ACOSTA, JUAN | AcostaJ | 2021-12-20 00:00:00 | 00:02:00 |  |  |  |  | ACOSTA, JUAN | AcostaJ | 2021-12-20 00:00:00 | 00:02:00 | In
ACOSTA, JUAN | AcostaJ | 2021-12-20 00:00:00 | 17:26:00 |  |  |  |  | ACOSTA, JUAN | AcostaJ | 2021-12-20 00:00:00 | 17:26:00 | Break
ACOSTA, JUAN | AcostaJ | 2021-12-21 00:00:00 | 13:24:00 |  |  |  |  | ACOSTA, JUAN | AcostaJ | 2021-12-21 00:00:00 | 13:24:00 | In
ACOSTA, JUAN | AcostaJ | 2021-12-21 00:00:00 | 19:37:00 |  |  |  |  | ACOSTA, JUAN | AcostaJ | 2021-12-21 00:00:00 | 19:37:00 | Break
ACOSTA, JUAN | AcostaJ | 2021-12-21 00:00:00 | 20:00:00 |  |  |  |  | ACOSTA, JUAN | AcostaJ | 2021-12-21 00:00:00 | 20:00:00 | Break
ACOSTA, JUAN | AcostaJ | 2021-12-21 00:00:00 | 23:31:00 |  |  |  |  | ACOSTA, JUAN | AcostaJ | 2021-12-21 00:00:00 | 23:31:00 | Break
Spreadsheet: 84347d1284397441-question-related-to-pivot-tables-test-table
Sheet: Data

Product | manufacturer | year | indicator 1 | indicator 2 | indicator 3 | country
a | lab1 | 2001 | Hypertention | Fever |  | in
b | lab1 | 2001 | Hypertention |  |  | in
c | lab1 | 2002 | Hypertention |  |  | in
d | lab2 | 1999 | Fever |  |  | ch
e | lab3 | 2000 | Fever |  |  | ch
f | lab3 | 2005 | Fever |  |  | ch
g | lab4 | 2006 | Diabetes |  |  | il
h | lab5 | 2006 | Diabetes |  |  | il
i | [NAME] | 2007 | Diabetes |  |  | us
j | [NAME] | 2007 | Diabetes |  |  | us
k | lab7 | 2008 | TB |  |  | il
l | [NAME] | 2004 | HepB | TB |  | in
m | lab9 | 2005 | HepB | TB |  | ch
n | lab10 | 2004 | Fever | TB |  | us
o | [NAME] | 2003 | TB | HepB | HepA | ca
p | [NAME] | 2000 | Fever |  |  | ca
Spreadsheet: 148423d1333396619-creating-a-report-to-show-vehicle-tax-due-tax-disc-log-trial
Sheet: 444RF

 |  |  |  |  | 444RF
Registration number : | 444RF |  | Date Taxed | Duration | Tax Expiry  Date | Cost (£)
Description : | Trade Plates |  | 1996-12-23 00:00:00 | 12 Months | 1998-01-01 00:00:00 | 145
 |  |  | 1997-12-31 00:00:00 | 12 Months | 1999-01-01 00:00:00 | 150
 |  |  | 1998-12-31 00:00:00 | 12 Months | 2000-01-01 00:00:00 | 150
 |  |  | 1999-12-30 00:00:00 | 12 Months | 2001-01-01 00:00:00 | 155
Back To Index |  |  | 2000-12-29 00:00:00 | 12 Months | 2002-01-01 00:00:00 | 155
 |  |  | 2001-12-31 00:00:00 | 12 Months | 2003-01-01 00:00:00 | 160
 |  |  | 2002-12-31 00:00:00 | 12 Months | 2004-01-01 00:00:00 | 160
 |  |  | 2003-12-31 00:00:00 | 12 Months | 2005-01-01 00:00:00 | 165
 |  |  | 2004-12-31 00:00:00 | 12 Months | 2006-01-01 00:00:00 | 165
 |  |  | 2005-11-30 00:00:00 | 12 Months | 2007-01-01 00:00:00 | 165
 |  |  | 2006-11-30 00:00:00 | 12 Months | 2008-01-01 00:00:00 | 165
 |  |  | 2007-11-30 00:00:00 | 12 Months | 2009-01-01 00:00:00 | 165
 |  |  | 2008-11-30 00:00:00 | 12 Months | 2010-01-01 00:00:00 | 165
 |  |  | 2009-12-10 00:00:00 | 12 Months | 2011-01-01 00:00:00 | 165
 |  |  | 2010-12-13 00:00:00 | 12 Months | 2012-01-01 00:00:00 | 165
 |  |  | 2011-12-08 00:00:00 | 12 Months | 2013-01-01 00:00:00 | 165
Spreadsheet: 58995d1259317732-finding-the-column-with-unique-value-and-copying-whole-column-to-another-workbook-trial1
Sheet: Sheet1

 |  | Bell | [NAME] | Fort
 |  | 7.2 | 15.61 | 57.3
 |  | 3 | 18 | 11.98
 |  | 5 | 43 | 41.7
 |  | 6 | 76 | 43
 |  | 19 | 18 | 67.2
 |  | 11 | 27 | 19.3
 |  | 24 | 43 | 61.55
 |  | 18 | 61.9 | 4.33
Spreadsheet: 153254d1335830886-find-the-first-second-third-etc-values-in-an-alphabetical-lists-sortalphalistremovedupes
Sheet: Sheet1

Data List | Remove Duplicates | [NAME] | Result
C | A | 65 | A
A | Ab | 65.66 | Ab
Ab | Da | 67 | C
Da | Db | 68.65 | Da
Db | C | 68.66 | Db
A
C
C
A
Spreadsheet: 112515d1308635736-countif-for-two-criteria-calculation
Sheet: Unknown Customer New Upgrade

cust_id | bank_section_Canada | [NAME] | bank_ret_cu | upgrade_second | upgrade_ret | upgrd_abc | cls_flag | ip_id | bank_code | week_start | account name | cust_no_random | Remark | account reprsentative | monitor | date of complete
19293949 | 5 | 2 | 3 | 3 | 5 | 5 |  |  | 11333 | week1 | BBABCD123456789 |  | sales complete | [NAME] | y | 20110420
19320932 | 5 | 4 | 3 | 5 | 5 | 7 |  |  | 44333 | week2 | BBABCD030221111 |  | customer refuse | [NAME] | n | 20110319
23493222 | 3 | 5 | 5 | 6 | 6 | 7 |  |  | 44555 | week2 | BBABCD300000123 |  |  | [NAME] | n | 20110301
43243131 | 5 | 1 | 3 | 3 | 5 | 6 |  |  | 43343 | week2 | BBABCD300000113 |  | customer refuse | [NAME] | y | 20110222
32112312 | 7 | 2 | 2 | 4 | 7 | 6 |  |  | 32433 | week2 | BBABCD300000143 |  | sales complete | [NAME] | y | 20110222
10203047 | 4 | 2 | 4 | 4 | 5 | 6 |  |  | 22333 | week3 | BBABCD203002000 |  | sales decline | [NAME] | y | 20110222
43000020 | 7 | 3 | 4 | 4 | 3 | 4 |  |  | 43342 | week4 | BBABCD300000977 |  | sales decline | Tin | y | 20110222
23429900 | 5 | 2 | 3 | 3 | 5 | 5 |  |  | 43343 | week4 | BBABCD300000999 |  | business retain | [NAME] | y | 20110222
12313123 | 6 | 3 | 4 | 3 | 4 | 6 |  |  | 34242 | week5 | BBABCD300000133 |  | sales decline | Baggio | y | 20110222
Spreadsheet: elizabeth_sager__9638__midamerican
Sheet: Sheet1

ENRON'S DEAL # | DEAL DATE | FLOW START | FLOW END | PRICE | VOLUME | DELIVERY POINT | DEAL TYPE | ENRON'S BUY/SALE | FIRMNESS
672627.1 | 2001-07-03 00:00:00 | 2002-05-01 00:00:00 | 2002-05-31 00:00:00 | 34.75 | 17600 | CINERGY (Into) System | FORWARD | B | Firm
676434.1 | 2001-07-06 00:00:00 | 2002-05-01 00:00:00 | 2002-05-31 00:00:00 | 36 | 17600 | CINERGY (Into) System | FORWARD | B | Firm
684454.1 | 2001-07-13 00:00:00 | 2001-10-01 00:00:00 | 2001-10-31 00:00:00 | 28.5 | 18400 | CINERGY (Into) System | FORWARD | S | Firm
711274.1 | 2001-07-31 00:00:00 | 2002-10-01 00:00:00 | 2002-12-31 00:00:00 | 30 | 51200 | CINERGY (Into) System | FORWARD | B | Firm
735954.1 | 2001-08-16 00:00:00 | 2002-10-01 00:00:00 | 2002-12-31 00:00:00 | 31.75 | 51200 | CINERGY (Into) System | FORWARD | B | Firm
775540.1 | 2001-09-14 00:00:00 | 2002-10-01 00:00:00 | 2002-12-31 00:00:00 | 32.25 | 51200 | CINERGY (Into) System | FORWARD | B | Firm
792444.1 | 2001-09-27 00:00:00 | 2002-01-01 00:00:00 | 2002-02-28 00:00:00 | 27.15 | 33600 | CINERGY (Into) System | FORWARD | S | Firm
Spreadsheet: 38250d1236353649-data-sorting-example
Sheet: Sheet1

User Name | Login atamps | Last login
abbas1711 | 4 | 2009-03-06 16:05:21
abdul09471 | 8 | 2009-03-06 09:20:35
abdul293 | 3 | 2009-03-06 09:25:17
abid1689 | 2 | 2009-03-06 14:51:04
[NAME] | 2 | 2009-03-06 09:29:56
adnan390 | 1 | 2009-03-06 09:17:18
[NAME] | 5 | 2009-03-06 09:20:54
ahmed1184 | 1 | 2009-03-06 09:31:07
ahmer1911 | 1 | 2009-03-06 10:03:41
ajeet521 | 1 | 2009-03-06 10:04:50
ali09533 | 12 | 2009-03-06 09:35:40
[NAME] | 1 | 2009-03-06 10:05:19
ali550 | 3 | 2009-03-06 14:26:15
amir09483 | 3 | 2009-03-06 09:47:19
amir09540 | 4 | 2009-03-06 09:13:38
amir1632 | 1 | 2009-03-06 09:35:44
anwar1985 | 2 | 2009-03-06 09:47:12
arif594 | 2 | 2009-03-06 10:30:12
Spreadsheet: 165523d1341256531-variable-print-output-display-as-well-if-possible-example-1
Sheet: Summary

Office # | 1 |  |  | Office # |  |  |  | Office # |  |  |  |  |  | Offices to Display
Address: | 123 Street Ave. |  |  | Address: |  |  |  | Address: |  |  |  |  |  | 1
 | SomeCity, Some State, 12345 |  |  |  |  |  |  |  |  |  |  |  |  | 2
Name | Position | Phone # |  | Name | Position | Phone # |  | Name | Position | Phone #
[NAME] | Type 1 Manager | 1111111111
[NAME] | Type 2 Manager | 2222222222
Office # | 1 |  |  | Office #
Address: | 123 Street Ave. |  |  | Address:
 | SomeCity, Some State, 12345 |  |  |  |  |  |  | Office #
Name | Position | Phone # |  | Name | Position | Phone # |  | Address:
[NAME] | Type 1 Manager | 4567891230
[NAME] | Type 3 Manager | 2345678910 |  |  |  |  |  | Name | Position | Phone #
[NAME] | Type 4 Manager | 7894561230
 |  |  |  | Office #
Office # |  |  |  | Address:
Address:
 |  |  |  | Name | Position | Phone # |  | Office # | 1
Name | Position | Phone # |  |  |  |  |  | Address: | 123 Street Ave.
 |  |  |  |  |  |  |  |  | SomeCity, Some State, 12345
 |  |  |  |  |  |  |  | Name | Position | Phone #
 |  |  |  | Office #
 |  |  |  | Address:
Office # | 1 |  |  | Name | Position | Phone # |  | Office #
Address: | 123 Street Ave. |  |  |  |  |  |  | Address:
 | SomeCity, Some State, 12345
Name | Position | Phone # |  |  |  |  |  | Name | Position | Phone #
Spreadsheet: chris_germany__2113__Transco_Doyle_confirms_Jan_2001
Sheet: external

DOYLE
'   JANUARY  2001
 | GAS [NAME] |  |  |  |  |  | PURCHASE |  | TRANSPORT
 |  | PURCHASES |  |  |  |  | Delivered Price |  | COMMODITY |  | DAILY TRANS
 | DAY AHEAD | RECEIPT | DELIVERY | [NAME] | IMBALANCE |  |  |  | FT | IT @ .1907 | COST
DAY | REQUEST |  |  |  |  |  |  |  | zero |  | DEL'd x Comm.
2001-01-01 00:00:00 | 0 | 0 |  | 0 |  |  |  |  | 0.0306 | 0.1907
2001-01-02 00:00:00 | 0 | 0 |  | 0 |  |  |  |  | 0.0306 | 0.1907
2001-01-03 00:00:00 | 0 | 0 |  | 0 |  |  |  |  | 0.0306 | 0.1907
2001-01-04 00:00:00 | 21000 | 20000 | 20000 | 16507 |  |  | fixed 10,000 @$13.00 |  | 0.0306 | 0.1907 | 0
2001-01-05 00:00:00 | 0 | 0 |  | 187 |  |  | 10,000 @ 11.50 |  | 0.0306 | 0.1907 | 0
2001-01-06 00:00:00 | 0 | 0 |  | 0 |  |  |  |  | 0.0306 | 0.1907
2001-01-07 00:00:00 | 0 | 0 |  | 0 |  |  |  |  | 0.0306 | 0.1907
2001-01-08 00:00:00 | 0 | 0 |  | 0 |  |  |  |  | 0.0306 | 0.1907
2001-01-09 00:00:00 | 0 | 0 |  | 0 |  |  |  |  | 0.0306 | 0.1907 | 0
2001-01-10 00:00:00 | 6500 | 1900 | 1900 | 4611 |  |  | fixed  $12.00 |  | 0.0306 | 0.1907 | 0
2001-01-11 00:00:00 | 0 | 1900 | 1900 | 0 |  |  | fixed  $12.00 |  | 0.0306 | 0.1907 | 0
2001-01-12 00:00:00 | 0 | 0 |  | 0 |  |  |  |  | 0.0306 | 0.1907
2001-01-13 00:00:00 | 0 | 0 |  | 0 |  |  |  |  | 0.0306 | 0.1907
2001-01-14 00:00:00 | 0 | 0 |  | 0 |  |  |  |  | 0.0306 | 0.1907
2001-01-15 00:00:00 | 0 | 0 |  | 0 |  |  |  |  | 0.0306 | 0.1907
2001-01-16 00:00:00 | 0 | 0 |  | 0 |  |  |  |  | 0.0306 | 0.1907
2001-01-17 00:00:00 | 0 | 0 |  | 0 |  |  |  |  | 0.0306 | 0.1907
2001-01-18 00:00:00 | 0 | 0 |  | 0 |  |  |  |  | 0.0306 | 0.1907
2001-01-19 00:00:00 | 0 | 0 |  | 0 |  |  |  |  | 0.0306 | 0.1907
2001-01-20 00:00:00 | 0 | 2500 | 2500 | 0 |  |  | fixed $8.90 |  | 0.0306 | 0.1907 | 0
2001-01-21 00:00:00 | 5000 | 2500 | 2500 | 6106 |  |  | fixed $8.90 |  | 0.0306 | 0.1907 | 0
2001-01-22 00:00:00 | 5000 | 2500 | 2500 | 6322 |  |  | fixed $8.90 |  | 0.0306 | 0.1907 | 0
2001-01-23 00:00:00 | 0 | 0 |  | 122 |  |  |  |  | 0.0306 | 0.1907
2001-01-24 00:00:00 | 0 | 0 |  | 0 |  |  |  |  | 0.0306 | 0.1907
2001-01-25 00:00:00 | 5750 | 0 |  | 5750 |  |  |  |  | 0.0306 | 0.1907
2001-01-26 00:00:00 | 1750 | 10000 | 10000 | 1750 |  |  | fixed $8.50 |  | 0.0306 | 0.1907
2001-01-27 00:00:00 | 0 | 0 |  | 0 |  |  |  |  | 0.0306 | 0.1907
2001-01-28 00:00:00 | 0 | 0 |  | 0 |  |  |  |  | 0.0306 | 0.1907
2001-01-29 00:00:00 | 0 | 0 |  | 0 |  |  |  |  | 0.0306 | 0.1907
2001-01-30 00:00:00 | 0 | 0 |  | 0 |  |  |  |  | 0.0306 | 0.1907
2001-01-31 00:00:00
 | BOLD DATE = PIPELINE ACTUALS
 | DAY AHEAD REQUEST = "Schedule 8's" total MW x heat rate estimate of 12.1