tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: tracy_geaccone__40260__C0366-112458
Sheet: Dept_100186

ENRON PROPERTY & SERVICES CORP
1400 Smith Street
Houston, Texas   77251 - 1188
MONTHLY INVOICE DETAIL
FACILITY OPERATIONS - Dept. 100186
June, 2001
0366  EOC - Executive
Date | Ticket Number | Work Order | Service Name | Service Description | # [NAME] | Unit Cost | UOM | Service | Ticket
 |  |  |  |  |  |  |  | Total | Total
 |  |  | R/C 112458
2001-06-21 00:00:00 | FOP100186-2001-06-0366-112458 |  | Facilities Operations | Sq. Ft. Occupied | 165 | 0.05 | /EACH | 7.92
 |  |  |  |  |  |  | Ticket Total |  | 7.92
 |  |  |  |  |  |  | Total for R/C: 112458 |  | 7.92
 |  |  |  |  |  |  | Total for Dept_100186 |  | 7.92
Spreadsheet: 272670d1382459410-display-minimum-value-in-array-minimum-bid-example
Sheet: Misc

Misc Specialties
 | Materials
Company | Wood Doors | Hardware | HM | Total Bid | Minimum Bid (Combining lowest price for each item)
Lowest Bid | 500 | 1800 | 500 |  | 2800
abc door | 1000 | 2000 | 500 | 3500
[NAME] | 800 | 1800 | 600 | 3200
commerical door | 3000 | * | * | 3000
specialty door | 500 | 1900 | 700 | 3100
Spreadsheet: sally_beck__35756__MgmtSum-Q1-0222
Sheet: Summary YTD

PLAN99 | ACTUAL |  |  |  | NET_INCOME |  |  | [NAME] |  |  |  | TOT_OPS_EXPENSES | TOT_ALLOCATION |  |  | [NAME] | TOT_OPS_EXPENSES | TOT_ALLOCATION |  |  | [NAME] | TOT_OPS_EXPENSES | CAP_CHRG | TOT_ALLOCATION
1999-12-01 00:00:00 | 1999-09-01 00:00:00 |  |  |  |  |  |  | CAP_CHRG
M.QTD | M.YTD | ENRON NORTH AMERICA
ECT |  | 4TH QUARTER 1999 EARNINGS ESTIMATE
 |  | [NAME] through Q4
 |  |  |  | Earnings Before Tax |  |  |  | Components of Earnings Before Tax |  |  |  |  |  |  |  | Variances from Plan
 |  |  |  |  |  |  |  | Actual | Deals | Forecast | Total | Direct | Allocated |  |  | Gross | Direct | Allocated | Total
 |  | Business Team |  | Estimate | Plan | [NAME] |  | Margin | Identified | Margin | Margin | Expenses | Expenses | Total |  | Margin | Expense | Expense | Fav/(Unfav)
[NAME] |  | Gas Trading
E_PWR_TR |  | East Power Trading
W_PWR_TR |  | West Power Trading
IR_FX |  | Interest Rate & Currency Trading
TRD_MKT |  | Canada - Trading & Marketing
COAL |  | Coal
[NAME] |  | Equity Trading
WEATHER |  | Weather
SO2 |  | SO2
INSURANCE |  | Insurance Group |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0
EXEC_TRD |  | Executive Trading
 |  | Total Trading & Risk Management
E_ORG | CLEAN_ENG | East Midstream
W_ORIG |  | West Midstream
PAPER |  | Industrial Downstream - Paper
DWNSTRM_IND_ORIG |  | Industrial Downstream - Chemicals
PROD_FIN |  | Upstream E&P
ENVR_ENGY | ENGY_FIN | Environmental Energy
MEXICO |  | Mexico
 |  | Total Origination
GENCOS |  | Genco
N_BS_DEV |  | Generation Investments
ASST_ORIG |  | Gas Assets
ASST_TRD |  | Gas Assets - Trading
 |  | Total Assets
EQUITY |  | Principal Investing
RESTRUCTURING |  | Restructuring
FIN |  | Canada - Investing
 |  | Total Investing
treasury |  | Treasury |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
CTG_OM |  | Commercial Transactions Group
OF_CHAIR |  | Office of the Chairman |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  | Total Commercial
GROUP |  | Group
TREASURY_INT |  | Other Interest Related Charges
TREAS |  | Capital Charge Offset |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 0
 |  | Overview |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 138187
 |  | ENA EBIT
 |  | Interest Income/(Expense) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 24200
 |  | [NAME]
Spreadsheet: 841520d1693703009-update-the-values-in-a-column-based-on-matching-data-in-other-columns-intended-result
Sheet: Intended Result

TIME | DC
1030 | 9
1031 | 9
1032 | 9
1033 | 7
1034 | 9
1035 | 9
1036 | 9
1037 | 7
1038 | 9
1039 | 9
1040 | 9
Spreadsheet: mary_fischer__25616__34L
Sheet: E15.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 034L
COMPANY NAME   Enron EES Acquisition I Corp
ANALYSIS OF MINORITY INTERESTS
FOR THE PERIOD ENDING 6-30-2001
PREPARED BY: [NAME]
EXTENSION: 52580 |  |  |  |  |  |  |  |  |  |  |  | E-15
 |  |  |  | 12-31-2000 Balance
 |  |  |  | BEGINNING |  | AMOUNT |  |  |  |  |  | 12-31-2001
[NAME] OR ENTITY |  | ENRON'S |  | BALANCE |  | PER INCOME |  | OTHER |  |  |  | BALANCE
 |  | OWNERSHIP % |  | DR. (CR.) |  | STATEMENT |  | AMOUNT |  | (DESCRIBE) |  | DR. (CR.)
(PROVIDE DETAIL OF INDIVIDUAL ITEMS
IN EXCESS OF $200,000.)
Total Minority Interest | * |  |  |  |  |  |  |  |  |  |  |  | *
* MUST TIE TO HYPERION ACCOUNT 0855  DR/(CR)
Spreadsheet: 36106d1233863255-help-with-cubic-spline-data-spline
Sheet: Sheet1

 | [NAME]
Data to Fit |  |  |  | Cubic Spline coefficients
x | y |  |  | a3 | a2 | a1 | a0
0 | 0 |  | 1st spline= | 0.2014892685063513 | 0 | 1.798510731493649 | 0
1 | 2 |  | 2nd spline= | -0.8783764053146446 | 0.604467805519054 | 2.402978537012703 | 2
2.5 | 4 |  | 3rd spline= | 5.547087166009637 | -3.348226018396847 | -1.712658782303986 | 4
3 | 3 |  | 4th spline= | -3.071835304424003 | 4.972404730617608 | -0.9005694261936048 | 3
4 | 4 |  | 5th spline= | 1.414367060884801 | -4.243101182654402 | -0.1712658782303986 | 4
5 | 1
x | y
0
0.1
0.2
0.3
0.4
0.5
0.6
0.7
0.8
0.9
1
1.1
1.2
1.3
1.4
1.5
1.6
1.7
1.8
1.9
2
2.1
2.2
2.3
2.4
2.5
2.6
2.7
2.8
2.9
3
3.1
3.2
3.3
3.4
3.5
3.6
3.7
3.8
3.9
4
4.1
4.2
4.3
4.4
4.5
4.6
4.7
4.8
4.9
5
Spreadsheet: 05d13b4b-dcc4-4c9d-9851-9db68c942c16
Sheet: 2007-08

Table T2
Non-UK Domiciled Student Numbers by Ethnic Group
Ethnic Group | Undergraduate | Graduate | Total
Asian or Asian British
- Bangladeshi | 10 | 10
- Indian | 45 | 106
- Pakistani | 23 | 39
- Other | 161 | 247
Subtotal
Black or Black British
- African | 11 | 58
- Caribbean | 7 | 11
- Other | 5 | 15
Subtotal
Chinese
Chinese | 429 | 432
Subtotal
Mixed
[NAME] and Asian | 20 | 25
[NAME] and Black African | 10 | 11
[NAME] and Black Caribbean | 1 | 5
- Other | 25 | 68
Subtotal
White
- British | 42 | 41
- Irish | 12 | 73
- Irish Traveller | 0 | 0
- Scottish | 1 | 2
[NAME] (not used for applicants after 2000) | 111 | 32
- Other | 655 | 1317
Subtotal
Other
Other Ethnic Background | 50 | 117
Information Refused | 692 | 68
Not Known | 1268 | 352
Subtotal
Total
This table is concerned with students whose domicile at the time of application is outside the UK irrespective of nationality.
Spreadsheet: 118891d1314083551-how-to-get-sum-of-deliveries-made-against-a-period-separated-by-months-sample
Sheet: Sheet1

Actual Delivery
Item | Qty | Del date | Pending | Planned Dates
A | 15000 | 2011-05-13 00:00:00 | 15000 | 2011-05-13 00:00:00
B | 1590 | 2011-01-01 00:00:00 | 1590 | 2011-01-01 00:00:00
C | 6600 | 2011-01-01 00:00:00 | 6600 | 2011-01-01 00:00:00
D | 6600 | 2011-07-31 00:00:00 | 6600 | 2011-07-31 00:00:00
E | 6600 | 2011-04-15 00:00:00 | 6600 | 2011-04-15 00:00:00
F | 76800 | 2011-05-01 00:00:00 | 76800 | 2011-05-01 00:00:00
F | 124000 | 2011-06-01 00:00:00 | 124000 | 2011-06-01 00:00:00
F | 197000 | 2011-07-01 00:00:00 | 197000 | 2011-07-01 00:00:00
C | 1500 | 2011-08-01 00:00:00 | 1500 | 2011-08-01 00:00:00
A | 1000 | 2011-06-01 00:00:00 | 1000 | 2011-06-01 00:00:00
E | 41 | 2011-07-01 00:00:00 | 41 | 2011-07-01 00:00:00
A | 3000 | 2011-05-16 00:00:00 | 3000 | 2011-05-16 00:00:00
Spreadsheet: 846176d1697463005-how-to-transform-data-from-a-weekly-schedule-into-daily-shifts-shift-coverage-excel
Sheet: Coverage

 | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday
All Depts | 2023-10-02 00:00:00 | 2023-10-03 00:00:00 | 2023-10-04 00:00:00 | 2023-10-05 00:00:00 | 2023-10-06 00:00:00 | 2023-10-07 00:00:00 | 2023-10-08 00:00:00
00:00:00
01:00:00
02:00:00
03:00:00
04:00:00
05:00:00
06:00:00
07:00:00
08:00:00
09:00:00
10:00:00
11:00:00
12:00:00
13:00:00
14:00:00
15:00:00
16:00:00
17:00:00
18:00:00
19:00:00
20:00:00
21:00:00
22:00:00
23:00:00
 |  |  |  |  |  |  |  | 0 Coverage
Spreadsheet: 148384d1333380384-multi-worksheet-2-dimensional-lookups-help-appreciated-sample_slar
Sheet: June 2012

 |  |  |  |  | SLA's & Client Specific Notes
 | Month |  |  | June
 | Week |  |  | Week 1 |  |  |  |  |  |  | Week 2 |  |  |  |  |  |  | Week 3 |  |  |  |  |  |  | Week 4 |  |  |  |  |  |  | Week 5
 | Day |  |  | Monday | Tuesday | Wednesday | Thursday | Friday |  |  | Monday | Tuesday | Wednesday | Thursday | Friday |  |  | Monday | Tuesday | Wednesday | Thursday | Friday |  |  | Monday | Tuesday | Wednesday | Thursday | Friday |  |  | Monday | Tuesday | Wednesday | Thursday | Friday
Mailing Code | Date | Column1 | Column2 | 28/05/2012 | 29/05/2012 | 30/05/2012 | 31/05/2012 | 01/06/2012 | 02/06/2012 | 03/06/2012 | 04/06/2012 | 05/06/2012 | 06/06/2012 | 07/06/2012 | 08/06/2012 | 09/06/2012 | 10/06/2012 | 11/06/2012 | 12/06/2012 | 13/06/2012 | 14/06/2012 | 15/06/2012 | 16/06/2012 | 17/06/2012 | 18/06/2012 | 19/06/2012 | 20/06/2012 | 21/06/2012 | 22/06/2012 | 23/06/2012 | 24/06/2012 | 25/06/2012 | 26/06/2012 | 27/06/2012 | 28/06/2012 | 29/06/2012
BG37 |  |  |  |  |  |  | Text
CH98 |  |  |  |  | Data Cleanse | Data Code | Text |  |  |  |  |  |  | Text
CH99 |  |  |  |  |  |  |  | Order Source Codes |  |  |  |  |  | Text | Selections |  |  | Artwork Delivery | Data Cleanse | Data Code | Text |  |  |  |  |  |  | Text
HH82 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Order Source Codes |  |  |  |  |  | Text | Selections |  |  | Artwork Delivery | Data Cleanse | Data Code | Text
CH100 |  |  |  | Internal Strategy Meeting |  |  |  | Text |  |  | Agree Offers | Agree Contact Strategies |  | [NAME] |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Order Source Codes
CH101 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Internal Strategy Meeting |  |  |  |  |  |  |  |  | Text
Spreadsheet: 123989d1317983529-sumproduct-criteria-problem-capex-and-opex-stock-distribution-bc2
Sheet: Sheet1

 |  |  |  |  |  | ID No. | opex open stock | opex stock in | opex stock out | Opex Running Stock |  | capex open stock | capex stock in | capex stock out | Capex Running Stock | Total Running Stock
 |  |  |  |  |  | 001 | 1 | 2 | 1 | 2 |  | 1 | 3 | 4 | 0 | 2
 |  |  |  |  | Adjusted | 001 | 1 | 2 | 2 | 1 |  | 1 | 3 | 3 | 1 | 2
 | Rec No / Order No. | Initials / Del | Stock In / Out | Prod ID No. |  |  | Opening Balance | Stock In | Stock Out | Closing Balance |  | Opening Balance | Stock In | Stock Out | Closing Balance | Total Closing
0 |  |  |  |  |  |  | 1 |  |  | 1 |  | 1 |  |  | 1 | 2 |  |  |  | When the stock item (001) is removed from the store it needs to be taken first from the capex stock out column until that has been exhausted and then the opex stock out column until that stock has been exhausted, no stock can show minus figures.                                                              I have set up the sheet so that when stock is delivered with a C prefix it is automatically put into capex stock, but a delivery number without the C prefix is put into opex stock. The two formulas to look at are in E2 and J2.
1 | 2221 | KM | 1 | 001 |  |  | 1 | 0 | 0 | 1 |  | 1 | 0 | -1 | 0 | 1
2 | 2222 | KM | 1 | 001 |  |  | 1 | 0 | -1 | 0 |  | 0 | 0 | 0 | 0 | 0
3 | 122578 | DEL | 1 | 001 |  |  | 0 | 1 | 0 | 1 |  | 0 | 0 | 0 | 0 | 1
4 | C1768 | DEL | 1 | 001 |  |  | 1 | 0 | 0 | 1 |  | 0 | 1 | 0 | 1 | 2
5 | 2223 | km | 1 | 001 |  |  | 1 | 0 | 0 | 1 |  | 1 | 0 | -1 | 0 | 1
6 | 125579 | DEL | 1 | 001 |  |  | 1 | 1 | 0 | 2 |  | 0 | 0 | 0 | 0 | 2
7 | C1768 | DEL | 1 | 001 |  |  | 2 | 0 | 0 | 2 |  | 0 | 1 | 0 | 1 | 3
8 | 2224 | km | 1 | 001 |  |  | 2 | 0 | 0 | 2 |  | 1 | 0 | -1 | 0 | 2
9 | 2225 | km | 1 | 001 |  |  | 2 | 0 | -1 | 1 |  | 0 | 0 | 0 | 0 | 1
10 | C1234 | DEL | 1 | 001 |  |  | 1 | 0 | 0 | 1 |  | 0 | 1 | 0 | 1 | 2
11 |  |  |  |  |  |  | 1 | 0 | 0 | 1 |  | 1 | 0 | 0 | 1 | 2
12 |  |  |  |  |  |  | 1 | 0 | 0 | 1 |  | 1 | 0 | 0 | 1 | 2
Spreadsheet: 619546c6-772e-4973-ad37-5038f98a5509
Sheet: 2014-2015

2015-2016 Class Schedule |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | You may select up to three classroom attributes.  Select only course requirements, as the number of available classrooms will be reduced with each attribute selected.
Chemistry
Fall 2015
Subject | Course and Title | Subtitle/Alternate Title | Days | Times | Sec | Part of Term | Credits | Hamline Plan | Instructor(s) | Instructor ID | FT or Adj | [NAME] | Registration Approval Required? | [NAME] | Seats to be Saved | Saved Seats Type | Campus: [NAME], [NAME], Online, Blended |  |  |  | Cross list? SUBJ CRSE SEC | XLST total enrl | Areas of Study | Comments
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Classroom Attribute A | Classroom Attribute B | Classroom Attribute C
Spreadsheet: 470235d1468405706-removing-symbol-book1
Sheet: DataRaw EU

Date | No | [NAME] | Dispatch | [NAME] | Reg No. of Vessel
2015-08-03 00:00:00 | 1 | Bag No:  1-400 | Date    : | A | IND-KA-02-MM-115
 | 1 | Processing Line :  A | Inv No : | B | IND-KA-02-MM-971
 | 1 |  | Party    : | C | IND-KA-02-MM-123
 | 1 | (On 2nd) | VhlNo  : | V | IND-KA-02-MM-202
 | 1 | Shift Manager :  Ravi | Trsnprt : | W | IND-KA-02-MM-203
 | 1 | Operator :  [NAME]
 | 1 | Production Time:
 | 1 | 12.00 A.M - 4.00 A.M
Spreadsheet: 155819d1337067012-file-format-for-attachment-car-log-12-new
Sheet: Completion Efficiency

 | Actual | Target
January | 0.5714285714285714 | 1
February | 1 | 1
March | 1 | 1
April | 1 | 1
May |  | 1
June |  | 1
July |  | 1
August |  | 1
September |  | 1
October |  | 1
November |  | 1
December |  | 1
Spreadsheet: 717520d1612710850-index-match-problem-i-cant-seem-to-fix-job-tracking-experimental-ans
Sheet: Project 

Created Date | Project Location |  |  | Project Title / Description |  | PO # / Date |  | Terms | [NAME] Project Manager |  |  | Customer Project Manager
2021-02-04 00:00:00 | Abingdon Medical Center |  |  | Phone Room Split Systems |  | 2020-12-30 00:00:00 |  |  | Name |  |  | Name
 |  |  |  |  |  |  |  |  | [NAME] |  |  | [NAME]
 |  |  |  | BMS Job # |  | PO# |  |  | Phone |  |  | Phone
Forecast Project Costs & Profit |  |  |  | Days in Our Court |  | Proj. Completion Date |  | BOD ? |  | Proj. Duration | Reason
Sold Price |  |  | 1000 | Actual Project Costs & Profit |  | 2021-02-28 00:00:00 |  |  |  |  | Weather
Profit |  |  |  | Actual Profit
Percentage |  |  |  | Actual Percentage
Projected Total Project Cost |  |  |  | Actual Total Cost
Projected Equipment Cost |  |  |  | Actual Equipment Cost
Projected Sub Contractor Cost |  |  |  | Actual Sub Contractor Cost
Equipment Vendors |  |  |  | Equipment Description |  |  |  |  |  | Original Quote | Additional Costs | Submittal
Sub Contractors |  |  |  | Sub Contractor Scope
 |  |  |  |  |  |  |  |  |  | Original Quote | Additional Cost | Change Orders
Engineering / Coring / Testing and BOD |  |  |  |  |  | BOD REQUIRED
Mechanical
Electrical
Sheet Metal & Duct
Controls
Rigging
Pipe Fitting
Plumbing
Balancing
Insulation
Fire & Sprinkler
Cleaning & Misc
Spreadsheet: 702896d1604595547-get-highest-value-based-on-two-columns-sample-data
Sheet: Sheet1

Concatenate | Month | Agent | Amount1 | Amount2
 | 2020 JUL | [NAME] | 9 | 481
 | 2020 JUL | [NAME] | 5 | 344
 | 2020 JUL | [NAME] | 20 | 971 |  |  | JUL
 | 2020 JUL | Reeve | 8 | 85
 | 2020 JUL | [NAME] | 2 | 182
 | 2020 JUL | Clementine | 13 | 542
 | 2020 JUL | Brett | 10 | 211 |  |  |  |  | * Get the higest value from "Amount2" if "Month" column ends with H5, but "Agent" column is NOT "Total"
 | 2020 JUL | Chase | 11 | 766
 | 2020 JUL | Sean | 12 | 1828 |  |  |  |  | Expected result: 1,828
 | 2020 JUL | Olive | 13 | 324
 | 2020 JUL | [NAME] | 8 | 716
 | 2020 JUL | [NAME] | 26 | 440
 | 2020 JUL | TOTAL | 137 | 6890
 | 2019 AUG | [NAME] | 10 | 218
 | 2019 AUG | [NAME] | 3 | 227
 | 2019 AUG | [NAME] | 16 | 929
 | 2019 AUG | Reeve | 3 | 50
 | 2019 AUG | [NAME] | 3 | 132
 | 2019 AUG | Clementine | 6 | 347
 | 2019 AUG | Brett | 15 | 188
 | 2019 AUG | Chase | 8 | 827
 | 2019 AUG | Sean | 6 | 1276
 | 2019 AUG | Olive | 6 | 357
 | 2019 AUG | [NAME] | 5 | 423
 | 2019 AUG | [NAME] | 15 | 392
 | 2019 AUG | TOTAL | 96 | 5366
 | 2018 JUL | [NAME] | 9 | 354
 | 2018 JUL | [NAME] | 3 | 320
 | 2018 JUL | [NAME] | 21 | 943
 | 2018 JUL | Reeve | 20 | 227
 | 2018 JUL | [NAME] | 1 | 320
 | 2018 JUL | Clementine | 9 | 454
 | 2018 JUL | Brett | 20 | 234
 | 2018 JUL | Chase | 22 | 857
 | 2018 JUL | Sean | 12 | 1758
 | 2018 JUL | Olive | 5 | 355
 | 2018 JUL | [NAME] | 5 | 436
 | 2018 JUL | [NAME] | 13 | 163
 | 2018 JUL | TOTAL | 140 | 6421
Spreadsheet: 709975d1608647156-returning-a-column-of-data-removing-blanks-and-summing-the-result-book2
Sheet: Sheet1

 | A | B | C | D
Q | 1 | 2 |  | 3
W | 4 |  | 5
E | 6
R |  | 7 | 8 | 9
T |  | 10
Y | 11 |  |  | 12
Spreadsheet: 688856d1595984859-extract-text-found-in-a-cell-that-appears-after-text-that-is-found-in-a-separate-cell-excel-forum-wb-2020-07-28
Sheet: Sheet1

Shipped From | Notes | Order
DS | FLAT SHOELACES 54" / RED - 54 shipping from DS; Qty 1.0 | 215675
DS | SCARF / GREY PLAID - ONE SIZE shipping from DS; Qty 1.0 | 215675
DS | Premium Poster [NAME] Issue 42 - The No Doubt Issue - One Size shipping from Toronto; Qty 1.0 | 215675
DS | CALCULATOR WATCH / GOLD - ONE SIZE shipping from DS; Qty 1.0 | 215675
DS | FLAT SHOELACES 54" / RED - 54 shipping from DS; Qty 1.0 | 215675
DS | SCARF / GREY PLAID - ONE SIZE shipping from DS; Qty 1.0 | 215675
DS | Premium Poster [NAME] Issue 42 - The No Doubt Issue - One Size shipping from Toronto; Qty 1.0 | 215675
DS | CALCULATOR WATCH / GOLD - ONE SIZE shipping from DS; Qty 1.0 | 215675
DS | FLAT SHOELACES 54" / RED - 54 shipping from DS; Qty 1.0 | 215675
DS | SCARF / GREY PLAID - ONE SIZE shipping from DS; Qty 1.0 | 215675
DS | Premium Poster [NAME] Issue 42 - The No Doubt Issue - One Size shipping from Toronto; Qty 1.0 | 215675
DS | CALCULATOR WATCH / GOLD - ONE SIZE shipping from DS; Qty 1.0 | 215675
DS | FLAT SHOELACES 54" / RED - 54 shipping from DS; Qty 1.0 | 215675
DS | SCARF / GREY PLAID - ONE SIZE shipping from DS; Qty 1.0 | 215675
DS | Premium Poster [NAME] Issue 42 - The No Doubt Issue - One Size shipping from Toronto; Qty 1.0 | 215675
DS | CALCULATOR WATCH / GOLD - ONE SIZE shipping from DS; Qty 1.0 | 215675
Spreadsheet: 677717d1589482579-need-formula-to-extract-values-from-the-data-sample
Sheet: Dash

INDEX | YEAR | MONTH |  |  |  | INDEX
1 | 1 | 1
 |  |  | Dates | MN | HR | RH |  |  |  |  | I need the kind of formula so that the values can be taken from the DATA sheet and can be changed if I change the INDEX or YEAR or MONTH. I have got a huge data for the 53 years.. Please help me. Thanks
 |  |  | 1 | 1 | 3 | 97
 |  |  | 2 | 1 | 3 | 100
 |  |  | 3 | 1 | 3 | 96
 |  |  | 4 | 1 | 3 | 93
 |  |  | 5 | 1 | 3 | 96
 |  |  | 6
 |  |  | 7
 |  |  | 8
 |  |  | 9
 |  |  | 10
 |  |  | 11
 |  |  | 12
 |  |  | 13
 |  |  | 14
 |  |  | 15
 |  |  | 16
 |  |  | 17
 |  |  | 18
 |  |  | 19
 |  |  | 20
 |  |  | 21
 |  |  | 22
 |  |  | 23
 |  |  | 24
 |  |  | 25
 |  |  | 26
 |  |  | 27
 |  |  | 28 | 1 | 12 | 49
 |  |  | 29 | 1 | 12 | 57
 |  |  | 30 | 1 | 12 | 100
 |  |  | 31 | 1 | 12 | 67
Spreadsheet: jeff_dasovich__14103__California PJM and NE Tables revised2
Sheet: A39

TABLE A39 FREQUENCY OF PRICE SPIKES IN THE NEW ENGLAND TEN-MINUTE SPINNING RESERVE MARKET AFTER ISO-NE REVISIONS
PRICE EQUALS OR EXCEEDS | FY 00/99 | FY 99/98
 | # of hours
 | % of available hours
100 | 9 | NA
 | 0.00102
250 | 2 | NA
 | 0.00023
500 | 2 | NA
 | 0.00023
750 | 1 | NA
 | 0.00011
1000 | 1 | NA
 | 0.00011
Source:  ISO-NE Website (www.iso-ne.com).
FY 00/99: 8/16/1999-8/15/2000
FY 99/98: 8/16/1998-8/15/1999
Spreadsheet: 840853d1693058738-lookup-help-prizes
Sheet: Sheet1

 |  | No | Dog Name | Name |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
 | 1st |  |  |  |  | Dog Name 1 | Dog Name 2 | Dog Name 3 | Dog Name 4 | Dog Name 5 | Dog Name 6 | Dog Name 7 | Dog Name 8 | Dog Name 9 | Dog Name 10
 | 2nd |  |  |  |  | Name | Name | Name | Name | Name | Name | Name | Name | Name | Name
 | 3rd |  |  |  |  | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20
 |  |  |  |  |  | Dog Name 11 | Dog Name 12 | Dog Name 13 | Dog Name 14 | Dog Name 15 | Dog Name 16 | Dog Name 17 | Dog Name 18 | Dog Name 19 | Dog Name 20
 |  |  |  |  |  | Name | Name | Name | Name | Name | Name | Name | Name | Name | Name
 |  |  |  |  |  | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30
 |  |  |  |  |  | Dog Name 21 | Dog Name 22 | Dog Name 23 | Dog Name 24 | Dog Name 25 | Dog Name 26 | Dog Name 27 | Dog Name 28 | Dog Name 29 | Dog Name 30
 |  |  |  |  |  | Name | Name | Name | Name | Name | Name | Name | Name | Name | Name
 |  |  |  |  |  | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40
 |  |  |  |  |  | Dog Name 31 | Dog Name 32 | Dog Name 33 | Dog Name 34 | Dog Name 35 | Dog Name 36 | Dog Name 37 | Dog Name 38 | Dog Name 39 | Dog Name 40
 |  |  |  |  |  | Name | Name | Name | Name | Name | Name | Name | Name | Name | Name
Spreadsheet: 97363d1296579510-average-with-if-statement-average-with-if
Sheet: Sheet1

Type | Value
A | 333 |  | AVERAGE A
B | 5542 |  | AVERAGE B
C | 52452 |  | AVERAGE C
A | 243
A | 464
B | 262
B | 5242
C | 254
C | 262
C | 6747
A | 653
A | 25
B | 742
A | 845
B | 563
C | 365
Spreadsheet: 153093d1335766633-back-count-10-cells-book1-14-
Sheet: table

day | Close
2012-03-07 00:00:00 | 0.56
2012-03-08 00:00:00 | 0.565
2012-03-09 00:00:00 | 0.57
2012-03-12 00:00:00 | 0.57
2012-03-13 00:00:00 | 0.57
2012-03-14 00:00:00 | 0.58
2012-03-15 00:00:00 | 0.58
2012-03-16 00:00:00 | 0.58
2012-03-19 00:00:00 | 0.575
2012-03-20 00:00:00 | 0.585
2012-03-21 00:00:00 | 0.58
2012-03-22 00:00:00 | 0.58
2012-03-23 00:00:00 | 0.575
2012-03-26 00:00:00 | 0.575
2012-03-27 00:00:00 | 0.575
2012-03-28 00:00:00 | 0.575
2012-03-29 00:00:00 | 0.575
2012-03-30 00:00:00 | 0.575
2012-04-02 00:00:00 | 0.58
2012-04-03 00:00:00 | 0.58
2012-04-04 00:00:00 | 0.585
2012-04-05 00:00:00 | 0.585
2012-04-09 00:00:00 | 0.58
2012-04-10 00:00:00 | 0.58
2012-04-11 00:00:00 | 0.575
2012-04-12 00:00:00 | 0.575
2012-04-13 00:00:00 | 0.58
2012-04-16 00:00:00 | 0.58
2012-04-17 00:00:00 | 0.58
2012-04-18 00:00:00 | 0.58
2012-04-19 00:00:00 | 0.58
2012-04-20 00:00:00 | 0.58
2012-04-23 00:00:00 | 0.58
2012-04-24 00:00:00 | 0.58
2012-04-25 00:00:00 | 0.575
2012-04-26 00:00:00 | 0.58
2012-04-27 00:00:00 | 0.575
Spreadsheet: 36780d1234724032-example-of-job-tracking-report-example-of-job-tracking-report
Sheet: Report analysis

Year: | 2008
Month | date of receiving paper work | # of closing per month
January |  | 0
February |  | 0
March |  | 1
April |  | 0
May |  | 3
June |  | 6
July |  | 0
August |  | 1
September |  | 2
Oktober |  | 4
November |  | 1
December |  | 5
Spreadsheet: 129126d1321461490-excel-2007-pivot-table-counting-unique-values-in-a-row-and-grouping-start-and-end-dates-example
Sheet: Sheet5

Customer | (All)
 |  | Data
Years | Start Date | Count of Project ID | Count of Tech Name | Sum of Ave Hours a Month
2010 | Nov | 1 | 1 | 5
 | Dec | 1 | 1 | 2
2011 | Jan | 1 | 1 | 9
 | Feb | 1 | 1 | 6.666666666666667
 | Mar | 1 | 1 | 50
 | Jul | 1 | 1 | 1.5
 | Aug | 4 | 4 | 28.5
 | Sep | 4 | 4 | 36
Grand Total |  | 14 | 14 | 138.6666666666667