tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 792215d1660784237-compare-pricelist-conditional-formatting-troubles-compare-pricelists_workings
Sheet: 2011

 | Category | Product | Price
 | pipe fitting | AC2525 | 11.197251
 | pipe fitting | AC2532 | 10.323627
 | pipe fitting | AC2550 | 13.554567
 | pipe fitting | AC3232 | 11.197251
 | pipe fitting | AC3240 | 13.554567
 | pipe fitting | AC3250 | 15.322554
 | pipe fitting | AC4040 | 14.733225
 | pipe fitting | AC4050 | 14.733225
 | pipe fitting | AC5050 | 22.983831
 | pipe fitting | C2020 | 7.071948
 | pipe fitting | C2525 | 7.516778
 | pipe fitting | C2532 | 7.661277
 | pipe fitting | C2540 | 8.250606
 | pipe fitting | C2550 | 10.323627
 | pipe fitting | C3232 | 9.788981
 | pipe fitting | C3240 | 10.323627
 | pipe fitting | C3250 | 10.495496
 | pipe fitting | C4040 | 11.78658
 | pipe fitting | C4050 | 12.375909
 | pipe fitting | C5050 | 17.090541
 | pipe fitting | F20 | 2.081294
 | pipe fitting | F25 | 2.507708
 | pipe fitting | F32 | 2.794099
 | pipe fitting | F32H | 4.264362
 | pipe fitting | F32R | 5.3655
 | pipe fitting | F40 | 3.335148
 | pipe fitting | F40H | 4.652639
 | pipe fitting | F40R | 5.550062
 | pipe fitting | F50 | 4.117993
 | pipe fitting | F50H | 5.89329
 | pipe fitting | F50R | 5.89329
 | pipe fitting | M10X25-5 | 1.637025
 | pipe fitting | M10X40-5 | 2.0148
 | pipe fitting | M10X60-5 | 2.5185
 | pipe fitting | M10X70-5 | 2.77035
 | pipe fitting | M10X75-5 | 2.896275
 | pipe fitting | M10X80-5 | 3.0222
 | pipe fitting | M10X90-5 | 3.148125
 | pipe fitting | M8X50-5 | 1.385175
 | pipe fitting | M8X60-5 | 1.5111
 | pipe fitting | SS25 | 5.89329
 | pipe fitting | SS32 | 7.516778
 | pipe fitting | SS40 | 9.429264
 | pipe fitting | SS50 | 10.607922
 | pipe fitting | T1515 | 2.081294
 | pipe fitting | T2020 | 2.144931
 | pipe fitting | T2025 | 2.221317
 | pipe fitting | T2525 | 2.361339
 | pipe fitting | T2532 | 3.252416
 | pipe fitting | T2532-SPIGOT | 4.353498
 | pipe fitting | T2540 | 3.901585
 | pipe fitting | [NAME] | 3.17603
 | pipe fitting | T3225-SPIGOT | 4.353498
 | pipe fitting | T3232 | 3.398785
 | pipe fitting | T3240 | 4.181629
 | pipe fitting | T3240-SPIGOT | 5.645545
 | pipe fitting | T3250 | 5.89329
 | pipe fitting | T4025 | 3.831602
 | pipe fitting | T4032 | 3.971624
 | pipe fitting | T4032-SPIGOT | 5.645545
 | pipe fitting | T4040 | 4.862644
 | pipe fitting | T4050 | 6.332907
 | pipe fitting | T5025 | 5.550062
 | pipe fitting | T5032 | 5.760124
 | pipe fitting | T5040 | 7.071948
 | pipe fitting | T5050 | 7.661277
 | pipe fitting | T6550 | 8.839935
 | pipe fitting | T8025 | 7.661277
 | pipe fitting | T8032 | 8.051424
 | pipe fitting | T8040 | 10.018593
 | pipe fitting | T8050 | 12.375909
 | pipe fitting | X2020 | 4.652639
 | pipe fitting | X2525 | 4.862644
 | pipe fitting | X2532 | 5.015416
 | pipe fitting | X2532-SPIGOT | 5.89329
 | pipe fitting | X2540 | 5.550062
 | pipe fitting | [NAME] | 7.071948
 | pipe fitting | [NAME] | 5.89329
 | pipe fitting | [NAME] | 6.262924
 | pipe fitting | X3240-SPIGOT | 7.661277
 | pipe fitting | X3250 | 7.071948
 | pipe fitting | X4040 | 6.816666
 | pipe fitting | X4050 | 8.250606
 | pipe fitting | X5050 | 12.375909
 | pipe fitting | X5065 | 19.447857
Spreadsheet: 86706d1286664632-find-the-most-effective-manufacturer-per-sold-items-book19
Sheet: Sheet1

Manufacturer | Item: |  |  | Family car
Toyota | Motorcycle |  |  | Motorcycle
Toyota | Family car |  |  | Bicycle
Toyota | Motorcycle
Hyundai | Family car
Honda | Family car
Kawasaki | Motorcycle | Table cannot be sorted!
Hyundai | Family car
Honda | Family car
Hyundai | Family car
Raleigh | Bicycle
Reynolds | Bicycle
 |  | [NAME] with
 |  | Data Validation |  | [NAME] needed here
First runner-up seller of |  | Family car | is: | ???
When Family car is selected the result should be: Hyundai
When [NAME] is selected the result should be: Toyota
When [NAME] is selected the result should be: Raleigh BECAUSE IT IS THE FIRST MATCH FROM TWO POSSIBLE EQUAL MATCHES
Spreadsheet: 1123bc01-6b7a-4694-9b45-07c3dcf61812
Sheet: Sheet1

University of Idaho | Unnamed: 1 | Departmental Transfer Form                                 Please fill out one form for each box you are moving to the Records Center | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
Records Management Office
Student Union Building, Room 53
Moscow, ID  83844-4247
Phone (208) 885-2580
Full Name (Print): |  | E-mail: |  | Telephone Number: |  | Date:
Department Name: |  | Authorization Signature:
Box Information
Department Reference Name/Number |  |  |  | Comments:
Date to Review Contents (optional): |  | Set Number:
Records Start Date |  | Records End Date
Records Center Information (for Records Center use only)
Box Accession Number:
Series Title |  | Start Date | End Date | Series Number | Retention Period | Disposition Date
Records Center Officer Signature: |  |  |  |  | Date:
Spreadsheet: 3acd49a4-fc30-4698-85de-ff7dd0c856c1
Sheet: ITER

ITER Databases
2010-2011
COUNTER-Compliant?: | ?
 | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | #[NAME]! | 2010-10-01 00:00:00 | 2010-11-01 00:00:00 | 2010-12-01 00:00:00 | 2011-01-01 00:00:00 | 2011-02-01 00:00:00 | 2011-03-01 00:00:00 | 2011-04-01 00:00:00 | 2011-05-01 00:00:00 | 2011-06-01 00:00:00 | Total | 2010-2011 Price | Price per unit
Baptisteria [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  | Free
Sessions | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Searches | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A |  | 0
 | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | #[NAME]! | 2010-10-01 00:00:00 | 2010-11-01 00:00:00 | 2010-12-01 00:00:00 | 2011-01-01 00:00:00 | 2011-02-01 00:00:00 | 2011-03-01 00:00:00 | 2011-04-01 00:00:00 | 2011-05-01 00:00:00 | 2011-06-01 00:00:00 | Total | 2010-2011 Price | Price per unit
ITER Bibliography
Sessions | 0 | 2 | 42 | 47 | 64 | 416 | 5 | 11 | 25 | 13 | 12 | 3
Searches | 0 | 0 | 126 | 210 | 296 | 93 | 13 | 44 | 89 | 40 | 27 | 3 |  | 545.4
 | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | #[NAME]! | 2010-10-01 00:00:00 | 2010-11-01 00:00:00 | 2010-12-01 00:00:00 | 2011-01-01 00:00:00 | 2011-02-01 00:00:00 | 2011-03-01 00:00:00 | 2011-04-01 00:00:00 | 2011-05-01 00:00:00 | 2011-06-01 00:00:00 | Total | 2010-2011 Price | Price per unit
Gateway to the Middle Ages
Sessions | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Searches | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A |  | 0
 | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | #[NAME]! | 2010-10-01 00:00:00 | 2010-11-01 00:00:00 | 2010-12-01 00:00:00 | 2011-01-01 00:00:00 | 2011-02-01 00:00:00 | 2011-03-01 00:00:00 | 2011-04-01 00:00:00 | 2011-05-01 00:00:00 | 2011-06-01 00:00:00 | Total | 2010-2011 Price | Price per unit
Medici Archives Project |  |  |  |  |  |  |  |  |  |  |  |  |  | Free
Sessions | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Searches | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A |  | 0
Spreadsheet: 89232d1288977779-average-example
Sheet: Sheet1

Weeks open | Weeks until repaired
0 | 4 |  | Weeks Open | Average WUR
0 | 5 |  | 0 | 4.076923076923077
0 | 3 |  | 1 | 2.5
0 | 6 |  | 2 | 2.2
0 | 3 |  | 3 | 1.25
0 | 4
0 | 2
0 | 4
0 | 5
0 | 6
0 | 4
0 | 3
0 | 4
1 | 3
1 | 2
1 | 3
1 | 3
1 | 2
1 | 2
1 | 3
1 | 2
2 | 2
2 | 1
2 | 2
2 | 1
2 | 2
2 | 3
2 | 4
2 | 3
2 | 2
2 | 2
3 | 1
3 | 2
3 | 1
3 | 1
Spreadsheet: 19688c28-c080-4388-9024-e481515441ae
Sheet: Sheet1

1.2.4 - Evolución de las inversiones extranjeras en España y de las inversiones españolas en el exterior. En millones de euros. 1990-2007 | Unnamed: 1 | Unnamed: 2
 | Inversiones de España en el exterior | Inversiones del exterior en España
1990 | 10953.941 | 24804.234
1991 | 8587.978 | 28597.011
1992 | 27740.11 | 31463.749
1993 | 61495.659 | 63238.362
1994 | -3431.052 | 30.603
1995 | 31648.235 | 26657.86
1996 | 6967.438 | 23316.605
1997 | 28862.881 | 36760.01
1998 | 78120.676 | 69190.78
1999 | 107733.724 | 97817.151
2000 | 149000.345 | 163258.584
2001 | 74796.039 | 95317.976
2002 | 91341.808 | 115268.223
2003 | 117807.258 | 125441.543
2004 | 123199.112 | 152828.969
2005 | 164292.399 | 223304.8
2006 | 169639 | 251476
2007 (*) | 133334 | 238421
(*) Datos provisionales.
Fuente: Elaboración [NAME] a partir de Banco de España, [NAME] estadístico, varios [NAME].
Spreadsheet: 92378d1291939588-excel-2007-sumif-problem-example-1-
Sheet: Sheet1

 |  | DATE | PRODUCT | PROFIT |  |  |  | TOTAL
 |  | 2011-01-01 00:00:00 | Aluminium | 200 |  |  | Aluminium
 |  | 2011-01-01 00:00:00 | Aluminium | 201 |  |  | Lead
 |  | 2011-01-01 00:00:00 | Aluminium | 202 |  |  | Brass
 |  | 2011-01-01 00:00:00 | Brass | 203 |  |  | Zinc
 |  | 2011-01-01 00:00:00 | Aluminium | 204 |  |  | Iron
 |  | 2011-01-01 00:00:00 | Aluminium | 205 |  |  | S/Steel
 |  | 2011-01-01 00:00:00 | Aluminium | 206
 |  | 2011-01-01 00:00:00 | Iron | 207
 |  | 2011-01-01 00:00:00 | Aluminium | 208
 |  | 2011-01-01 00:00:00 | Aluminium | 209
 |  | 2011-01-01 00:00:00 | Iron | 210
 |  | 2011-01-01 00:00:00 | Aluminium | 211
 |  | 2011-01-01 00:00:00 | Aluminium | 212
 |  | 2011-01-01 00:00:00 | Aluminium | 213
Spreadsheet: phillip_m_love__30020__STORAGE
Sheet: November 2000 GulfCoast  

NGPL GULF COAST STORAGE
 | 1.70% for fuel
 | K#114786  MAX MDQ=18,283 |  |  |  |  | K#114846  MAX MDQ=13,333
 | LA Injection | LA Withdrawl | STX Injection | STX Withdrawl |  | [NAME] | LA Withdrawl | STX Injection | STX Withdrawl
 | October | November |  | November |  | 25658
Beg Balance | 0 | 540047 | 0 | 451596 |  |  | 631881 |  | 340978
2000-11-01 00:00:00 | 0 | -8697 | 0 | -5752 | 0 |  | 0 | 0 | 0
2000-11-02 00:00:00 | 0 | -11163 | 0 | -6822 | 0 | 0 | 0 | 0 | 0
2000-11-03 00:00:00 | 0 | -11682 | 0 | -6601 | 0 |  | -5742 | 0 | 0
2000-11-04 00:00:00 | 0 | -11251 | 0 | -6712 | 0 |  | 0 | 0 | 0
2000-11-05 00:00:00 | 0 | -11251 | 0 | -6712 | 0 |  | 0 | 0 | 0
2000-11-06 00:00:00 | 0 | -11251 | 0 | -6712 | 0 |  | 0 | 0 | 0
2000-11-07 00:00:00 | 0 | -10974 | 0 | -6712 | 0 |  | 0 | 0 | 0
2000-11-08 00:00:00 | 0 | -10974 | 0 | -6712 | 0 |  | 0 | 0 | 0
2000-11-09 00:00:00 | 0 | -10974 | 0 | -6712 | 0 |  | 0 | 0 | 0
2000-11-10 00:00:00 | 0 | -10974 | 0 | -6712 | 0 |  | 0 | 0 | 0
2000-11-11 00:00:00 | 0 | -8884 | 0 | -9399 | 0 |  | -4487 | 0 | 0
2000-11-12 00:00:00 | 0 | -8884 | 0 | -9399 | 0 |  | -4487 | 0 | 0
2000-11-13 00:00:00 | 0 | -8884 | 0 | -9399 | 0 |  | -4487 | 0 | 0
2000-11-14 00:00:00 | 0 | -8884 | 0 | -9399 | 0 |  | -4487 | 0 | 0
2000-11-15 00:00:00 | 0 | -8884 | 0 | -9399 | 0 |  | -4487 | 0 | 0
2000-11-16 00:00:00 | 0 | -8884 | 0 | -9399 | 0 |  | -4487 | 0 | 0
2000-11-17 00:00:00 | 0 | -8884 | 0 | -9399 | 0 |  | -10005 | 0 | 0
2000-11-18 00:00:00 | 0 | -8884 | 0 | -9399 | 0 |  | -12000 | 0 | 0
2000-11-19 00:00:00 | 0 | -8884 | 0 | -9399 | 0 |  | -12000 | 0 | 0
2000-11-20 00:00:00 | 0 | -8884 | 0 | -9399 | 0 |  | -12000 | 0 | 0
2000-11-21 00:00:00 | 0 | -7473 | 0 | -10810 | 0 |  | -9769 | 0 | 0
2000-11-22 00:00:00 | 0 | -8473 | 0 | -9810 | 0 |  | -12244 | 0 | 0
2000-11-23 00:00:00 | 0 | -8884 | 0 | -9399 | 0 | 387 | -5108 | 0 | 0
2000-11-24 00:00:00 | 0 | -8884 | 0 | -9399 | 0 | 26 | -5108 | 0 | 0
2000-11-25 00:00:00 | 0 | -8884 | 0 | -9399 | 0 | 339 | -5108 | 0 | 0
2000-11-26 00:00:00 | 0 | -8884 | 0 | -9399 | 0 | 320 | -5108 | 0 | 0
2000-11-27 00:00:00 | 0 | -8884 | 0 | -9399 | 0 | 315 | -5108 | 0 | 0
2000-11-28 00:00:00 | 0 | -8884 | 0 | 0 | 0 | 319 | -5108 | 0 | 0
2000-11-29 00:00:00 | 0 | -8884 | 0 | -9399 | 0 | 308 | -6109 | 0 | 0
2000-11-30 00:00:00 | 0 | -8884 | 0 | -9399 | 0 | 315 | -5108 | 0 | 0
 | 0 |  |  | 0 |  | 0
Net Withdrawl/Injection
Ending Balance
Diff Stor Bal & MWQ
Total Combined Balance
Spreadsheet: 98375d1297292607-multiple-ifs-sample
Sheet: Sheet1

Grade1 | Grade2 | Grade3 | Grade4 | Grade5 | Grade6 | Grade7 | Grade8 | Grade9 | Grade 10 | Passed?
A | A | A |  | A | A |  | A
Mandatory | Mandatory | Either cell |  | Grade 5 and Grade 6 or Grade 7 |  |  | Either of these grades
The cell needs to display a Y if ALL the following conditions are true and a N if they are not:
A2 contains either an A*, A, B, C+ or C-
B2 contains either an A*, A, B, C+ or C-
GQ3 or HC3 contains either a A*, A, B, C+ or C-
CM3 and CY3 or [NAME] contains either a A*, A, B, C+ or C-
IM3 or IY3 or JK3 contains either a A*, A, B, C+ or C-
Spreadsheet: 117277d1312614016-using-and-to-check-2-conditions-786879_portsample
Sheet: report

location | species | date | live count
[NAME] | electric |  | =INDEX(data!$A$1:$A$100,IF(data!$E$1:$E$100=$B$2,IF(data!$C$1:$C$100=$A$2,IF(data!$A$1:$A$100=$C2),ROW(data!$F$1:$F$100)))),ROWS($B$1:B1))))
[NAME] | diesel
Spreadsheet: 104412d1302027961-lock-rows-for-filter-favtypeoficecre
Sheet: Sheet1

Favorite Flavors Of Ice Crème
Flavor | Votes | Rank
Choc | 49 | 1
Vanilla | 45 | 2
[NAME] | 76 | 3
Melon | 19 | 4
Grape | 113 | 5
Sherbert | 89 | 6
Spreadsheet: darrell_schoolcraft__7563__2002 BLANCO HUB BUDGET
Sheet: 2002 HUB ATTCH#1

[NAME] HUB
2002 O&M BUDGET
ATTACHMENT #1
 |  |  |  |  |  |  |  | SALARIES AND WAGES - 000 |  |  |  |  | EMPLOYEE EXPENSES - 050
 |  |  |  |  |  | SALARIES | TAXES/BENEFITS | TOTAL | 2001 EMPL | STAFF ADDS | 2002 EMPL |  | SMNR/SCHL | DUES | BUSINESS | TOTAL
 | TRANSWESTERN OPERATIONS |  |  |  |  | 62376 | 16049 |  | 1 | 0 | 1 |  | 0 | 0 | 5691
 |  |  | TOTAL
 |  |  |  |  |  |  | COMPANY EQUIP USE - 100 |  |  |  | SUPPLIES AND EXPENSES - 150
 |  |  |  |  |  | NUMBER | EXPENSE | POOL CAR | TOTAL |  | CHEMICALS | ELECT POWER | OTHERS | ENVIRON | TOTAL
 | TRANSWESTERN OPERATIONS |  |  |  |  | 0 | 4590 | 0 |  |  | 0 | 28688 | 25556 | 0
 |  |  | TOTAL
 |  |  |  |  |  | OUTSIDE SERVICES - 200 |  |  |  |  | RENTS - 250
 |  |  |  |  |  | CNTRCTS | TMPRR | OTHERS | TOTAL |  | EQP | WRHS | OTHERS | TOTAL
 | TRANSWESTERN OPERATIONS |  |  |  |  | 18670 | 0 | 0 |  |  | 1147 | 0 | 0
 |  |  | TOTAL
 |  |  |  |  |  | COMPUTER SERVICES - 600 |  |  |  |  | TOTAL | TOTAL | BUDGET
 |  |  |  |  |  | PC'S | CMNCTN | TOTAL |  |  | P/R | NON P/R | TOTAL
 | TRANSWESTERN OPERATIONS |  |  |  |  | 1147 | 0
 |  |  | TOTAL
 |  |  |  |  |  |  |  |  |  | SUMMARY
 |  |  |  |  |  | NUMBER OF |  |  | SALARIES | EMPLOYEE | COMPANY | SUPPLIES | OUTSIDE |  | COMPUTER | TOTAL
 |  | GROSS |  |  |  | EMPLOYEES | TAXES/BENEFITS |  | & WAGES | EXPENSES | EQP USE | EXPENSES | SERVICES | RENTS | SERVICES | NON P/R | TOTAL
 | TRANSWESTERN OPERATIONS |  |  |  |  | 1
 | TOTAL GROSS
 | NOTE:  DOES NOT INCLUDE 15% OPERATOR'S DIRECT EMPLOYEE LABOR COSTS (OVERHEAD)
 | TRANSWESTERN OPERATIONS (36.19%)  $ 59,321
 | PNM (27.62%)  $ 45,273
 | NWPL (36.19%)  $ 59,320
Spreadsheet: 686806d1594820593-calculate-overlapping-leave-for-different-categories-overlapping_leave_powerquery_chris
Sheet: Using Power Query

NAME | CATEGORY | 1/07 | 2/07 | 3/07 | 4/07 | 5/07 | 6/07 | 7/07 | 8/07 | 9/07 | 10/07 | 11/07 | 12/07 | 13/07 | 14/07 | 15/07 | 16/07 | 17/07 | 18/07 | 19/07 | 20/07 | 21/07 | 22/07 | 23/07 | 24/07 | 25/07 | 26/07 | 27/07 | 28/07 | 29/07 | 30/07 | 31/07 | 1/08 | 2/08 | 3/08 | 4/08 | 5/08 | 6/08 | 7/08 | 8/08 | 9/08 | 10/08
Mr. [NAME] | STUDENT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Mr. [NAME] | TEACHER | 1 | 1 | 1 | 1 | 1
Mr. [NAME] | TEACHER |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1
Mr. [NAME] | PAINTER | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Mr. [NAME] | TEACHER | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | CATEGORY | 1/07 | 2/07 | 3/07 | 4/07 | 5/07 | 6/07 | 7/07 | 8/07 | 9/07 | 10/07 | 11/07 | 12/07 | 13/07 | 14/07 | 15/07 | 16/07 | 17/07 | 18/07 | 19/07 | 20/07 | 21/07 | 22/07 | 23/07 | 24/07 | 25/07 | 26/07 | 27/07 | 28/07 | 29/07 | 30/07 | 31/07 | 1/08 | 2/08 | 3/08 | 4/08 | 5/08 | 6/08 | 7/08 | 8/08 | 9/08 | 10/08
 | STUDENT |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | TEACHER | 2 | 2 | 2 | 3 | 3 | 2 | 2 | 2 | 2 | 2 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 | PAINTER | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
Spreadsheet: 81947d1282053915-converting-nominal-value-to-real-value-sample
Sheet: Sheet1

Company Name | Company 6-Digit CUSIP | Round Dates |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Round Amt, Disclosed ($000)
TeleCorp PCS | 879300 | 1994-12-01 00:00:00 | 1995-04-01 00:00:00 | 1995-10-01 00:00:00 | 1996-08-01 00:00:00 | 1997-04-01 00:00:00 | 1997-10-01 00:00:00 | 1998-03-31 00:00:00 | 1998-05-29 00:00:00 | 1998-07-17 00:00:00 | 1998-12-30 00:00:00 | 1999-05-25 00:00:00 | 1999-09-01 00:00:00 | 1999-09-30 00:00:00 | 1999-12-01 00:00:00 | 1999-12-15 00:00:00 | 2000-07-17 00:00:00 | 2000-10-01 00:00:00 | 2001-03-01 00:00:00 | 2001-07-01 00:00:00 | 2002-02-28 00:00:00 |  |  | 962 | 48 | 2031 | 7500 | 1310 | 29180 | 8500 | 1200 | 2991 | 2637 | 80000 | 26000 | 504 | 128 | 183 | 37650 | 1430 | 2084 | 11587 | 336
GDP DEFLATOR COEFFICIENT
1980 | 1981 | 1982 | 1983 | 1984 | 1985 | 1986 | 1987 | 1988 | 1989 | 1990 | 1991 | 1992 | 1993 | 1994 | 1995 | 1996 | 1997 | 1998 | 1999 | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010
54.043 | 59.119 | 62.726 | 65.207 | 67.655 | 69.713 | 71.25 | 73.196 | 75.694 | 78.557 | 81.59 | 84.443 | 86.386 | 88.381 | 90.259 | 92.106 | 93.852 | 95.414 | 96.472 | 97.868 | 100 | 102.399 | 104.187 | 106.404 | 109.463 | 113 | 116.567 | 119.682 | 122.087 | 124.298 | 126.598
Spreadsheet: e25c8299-1eaa-4d74-b7ee-e4f88c0c613a
Sheet: Sheet1

Slaughtering - 2011
Week-ended | Lambs over 13kg | Lambs < 13kg | Hoggets | Cast Ewes | Total
09.01.11 | 26766 | 65 | 0 | 4272
16.01.11 | 27957 | 36 | 0 | 4506
23.01.11 | 30527 | 64 | 0 | 4603
30.01.11 | 28916 | 90 | 0 | 4245
06.02.11 | 30593 | 80 | 0 | 4675
13.02.11 | 28926 | 53 | 0 | 4309
20.02.11 | 28440 | 42 | 0 | 4225
27.02.11 | 15136 | 33 | 9917 | 5029
06.03.11 | 13874 | 108 | 9490 | 3702
13.03.11 | 14451 | 38 | 9735 | 3749
20.03.11 | 8175 | 25 | 16098 | 3747
27.03.11 | 8748 | 61 | 14377 | 4431
03.04.11 | 9411 | 57 | 16451 | 4544
10.04.11 | 5807 | 42 | 20932 | 5593
17.04.11 | 10003 | 357 | 23228 | 5339
24.04.11 | 12853 | 45 | 20988 | 5092
01.05.11 | 13535 | 56 | 12597 | 5098
08.05.11 | 18913 | 63 | 9501 | 4455
15.05.11 | 23387 | 43 | 7387 | 4686
22.05.11 | 32303 | 45 | 4310 | 4841
29.05.11 | 34210 | 40 | 3055 | 4785
05.06.11 | 37990 | 64 | 1531 | 4730
12.06.11 | 39028 | 53 | 793 | 4781
19.06.11 | 42386 | 55 | 641 | 4652
26.06.11 | 42500 | 56 | 348 | 4906
03.07.11 | 39380 | 71 | 258 | 5469
10.07.11 | 43743 | 97 | 155 | 5060
17.07.11 | 42943 | 26 | 166 | 4772
24.07.11 | 45167 | 97 | 176 | 5755
31.07.11 | 49329 | 95 | 196 | 5756
07.08.11 | 44727 | 131 | 71 | 5516
14.08.11 | 40607 | 95 | 111 | 6956
21.08.11 | 41766 | 54 | 174 | 7531
28.08.11 | 44823 | 136 | 60 | 7533
04.09.11 | 45672 | 119 | 97 | 7333
11.09.11 | 45796 | 57 | 87 | 7402
18.09.11 | 42093 | 784 | 104 | 8029
25.09.11 | 40769 | 599 | 126 | 6660 | 48154
02.10.11 | 40390 | 641 | 37 | 6801
09.10.11 | 42531 | 667 | 78 | 7375
16.10.11 | 41071 | 699 | 63 | 6407
23.10.11 | 38566 | 680 | 87 | 5939
30.10.11 | 41896 | 156 | 60 | 5067
06.11.11 | 46805 | 102 | 37 | 4226
13.11.11 | 35492 | 341 | 71 | 5571
20.11.11 | 36019 | 255 | 97 | 5809
27.11.11 | 37320 | 62 | 45 | 6362
Cumulative
Spreadsheet: louise_kitchen__24127__North America Plan 01-02
Sheet: East Power Admins

 | East Power Admins
 | 2002 Plan
 |  |  |  |  |  |  |  |  |  | Per HC | New HC | Adjust Comp
 |  | 2001-09-01 00:00:00 |  | 2001 | 2002 |  | % |  |  |  |  |  |  | 2002
 |  | YTD Actual |  | Forecast | Plan |  | of Total |  |  |  |  |  |  | Plan
ENACOMP | Compensation |  |  |  |  |  |  |  | Compensation | 0
 | Special Pays
 | Analysts & Associates
ENABENTX | Benefits & Payroll Taxes |  |  |  |  |  |  |  | Other
ENAEMPEX | Employee Expense
ENAT&EEX | Travel & Entertainment Expense |  |  |  |  |  |  |  | Total
ENAOUTSV | Outside Services
ENASUPP | Supplies Expense
ENAMKTEX | Marketing |  |  |  |  |  |  |  | [NAME] | 33600 | 0
ENACONTR | Charitable Contributions |  |  |  |  |  |  |  | [NAME] | 52800 | 2
ENARENT | Rent |  |  |  |  |  |  |  | Staff | 54000 | 0
ENATECH | Technology |  |  |  |  |  |  |  | Specialist | 63000 | 0
ENATRANS | Transportation |  |  |  |  |  |  |  | Sr. Specialist | 78000 | 0
ENAOTHEX | Other Expenses |  |  |  |  |  |  |  | Analyst | 66000 | 0
ENATAXES | Taxes Other than Income |  |  |  |  |  |  |  | Associate | 97200 | 0
ENATOTDR | Total Direct Expenses |  |  |  |  |  |  |  | Manager | 120000 | 0
 |  |  |  |  |  |  |  |  | Director | 156000 | 0
 | Headcount |  |  |  |  |  |  |  | Sr. Director | 180000 | 0
 |  |  |  |  |  |  |  |  | VP | 216000 | 0
 | Analyst & Associate Headcount |  |  |  |  |  |  |  | MD | 240000 | 0
 | Total Headcount |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | Other Expense Calculation
 | Outside Services | 524067
 |  |  |  |  |  |  |  | Total Misc Exp | Old HC | Exp/Old HC | New HC | Exp/New HC
Spreadsheet: 112459d1308590986-simplify-if-function-small-excel-question19-06
Sheet: ALL GOOD(Brief)

Matrix Row | I want to  simplify the formula in column E, for small samples it is easy but I need to use it for a really large sample. |  |  |  |  |  |  |  |  |  | Form | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8
0 | The formula is a if function
1 |  |  |  |  |  |  |  |  |  |  | 1 | 1
2 | The formula: |  |  |  |  |  |  |  |  |  | 10 | 10 | 1
3 | look first if the formula above the cell is a zero if this is not the case, |  |  |  |  |  |  |  |  |  | 6 | 5 | 6 | 0
4 | look if the cell above that cell is a zero, if that is not the case look if the cell above that cell is a zero and so on. |  |  |  |  |  |  |  |  |  | 0 | 10 | 11 | 0 | 1
5 | If it is a one you have the answer is the cell right of it. |  |  |  |  |  |  |  |  |  | 7 | 5 | 6 | 7 | 8 | 1
6 |  |  |  |  |  |  |  |  |  |  | 14 | 10 | 11 | 12 | 13 | 14 | 1
7 |  |  |  |  |  |  |  |  |  |  | 0 | 5 | 6 | 7 | 8 | 9 | 0 | 1
8 |  |  |  |  |  |  |  |  |  |  | 15 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 0
0
Spreadsheet: mary_fischer__25624__31X
Sheet: E4.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 031X
COMPANY NAME     Harper Investment Company
ANALYSIS OF MERCHANT AND OTHER INVESTMENTS
FOR THE 6 MONTHS ENDED 6-30-2001
PREPARED BY:
EXTENSION: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | E-4
 |  | 12-31-2000 Balance |  | Cash Activity |  |  |  |  |  | Income Statement Activity |  |  |  | Transfer / Reclasses
[NAME] |  | DR. (CR.) |  | Cash Received - |  | Return of Principal |  | Cash Paid - |  | Realized Gain/(loss) |  | [NAME]) |  | Amount |  | Hyperion Acct. # |  | DR. (CR.)
 |  | BEGINNING BALANCE |  | Proceeds  (CR.) |  | (CR.) |  | Additions  DR. |  | DR. / (CR.) |  | DR. (CR.) |  | DR. (CR.) |  | to / from |  | ENDING BALANCE |  | COMMENTS
(PROVIDE DETAIL OF INDIVIDUAL ITEMS
IN EXCESS OF $200,000.)
Total Merchant Investment - Non Current:
 |  | 0
Total  (Hyperion Line 0269)
Asset/Expense Accts:  DR/(CR)
Total Notes Receivable - Non Current:
 |  | 0
Total  (Hyperion Line 0270)
Asset/Expense Accts:  DR/(CR)
Total Other Investments:
 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | *
Total  (Hyperion line 0280)
Asset/Expense Accts:  DR/(CR)
Hyperion lines 0269 and 0280 are the only accounts needed to prepare this schedule.
Spreadsheet: 838983d1691580912-highlight-the-highest-version-example
Sheet: Sheet1

42.01
42.02
42.03 | higest
41.00
41.01 | higest
43.00 | higest
44.00
44.01
44.02 | higest
45.00
45.01 | higest
46.00 | higest
47.00 | higest
48.00
48.01 | higest
49.00 | higest
50.00
50.01
50.02
50.03 | higest