tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: jeffrey_a_shankman__14018__m010822
Sheet: Sheet1

Interest rate |  |  |  | Volume
Amount | Rate | Interest |  |  | Demand
8500 | 0.0577 |  |  | PG&E | 80000000
4000 | 0.0777 |  |  | Edison | 82000000
 |  |  |  | SDG&E | 16000000
 |  |  |  | Total
Share of DWR costs (2001&2002) |  |  | Costs (USD billions)
 |  |  |  |  |  |  | Regulatory
 | Share |  |  | Undercollection | Bonds | Contracts | Asset
PG&E |  |  | PG&E | 6.7 |  |  | 1.872
Edison |  |  | Edison | 3.2 |  |  | 2.741
SDG&E |  |  | SDG&E | 0.932 |  |  | 0
Total |  |  | Total
Unit Charge per kwh
PG&E |  |  |  |  |  | Extended CTC Costs Beyond March 31, 2002
Amortization | Utility Undercollection | Bonds | Contracts | Total | Total less | EmployeeTrans-ition costs | Power Purchase Obligations | Nuclear Incre-mental costs | CTC Exempts | FTA Related to Rate Reduction Bonds | Total Regulatory | Nuclear Decom-mission | Grand Total
Years |  |  |  |  | Contracts
5
7
10
12
15
Edison |  |  |  |  |  | Extended CTC Costs Beyond March 31, 2002
Amortization | Utility Undercollection | Bonds | Contracts | Total | Total less | EmployeeTrans-ition costs | Power Purchase Obligations | Nuclear Incre-mental costs | CTC Exempts | FTA Related to Rate Reduction Bonds | Total Regulatory | Nuclear Decom-mission | Grand Total
Years |  |  |  |  | Contracts
5
7
10
12
15
SDG&E |  |  |  |  |  | Extended CTC Costs Beyond March 31, 2002
Amortization | Utility Undercollection | Bonds | Contracts | Total | Total less | EmployeeTrans-ition costs | Power Purchase Obligations | Nuclear Incre-mental costs | CTC Exempts | FTA Related to Rate Reduction Bonds | Total Regulatory | Nuclear Decom-mission | Grand Total
Years |  |  |  |  | Contracts
5
7
10
12
15
Total |  |  |  |  |  | Extended CTC Costs Beyond March 31, 2002
Amortization | Utility Undercollection | Bonds | Contracts | Total | Total less | EmployeeTrans-ition costs | Power Purchase Obligations | Nuclear Incre-mental costs | CTC Exempts | FTA Related to Rate Reduction Bonds | Total Regulatory | Nuclear Decom-mission | Grand Total
Years |  |  |  |  | Contracts
5
7
10
12
15
Spreadsheet: 134534d1325410749-lookup-question-807619_brewers7
Sheet: Birthdays

Name | DOB
[NAME] | 1972-02-12 00:00:00
[NAME] | 1974-02-10 00:00:00
[NAME] | 1975-05-13 00:00:00
Dikembe Mutombo | 1966-06-25 00:00:00
[NAME] | 1975-09-27 00:00:00
[NAME] | 1966-03-12 00:00:00
[NAME] | 1974-09-29 00:00:00
LaPhonso Ellis | 1970-05-05 00:00:00
[NAME] | 1960-11-05 00:00:00
[NAME] | 1967-03-20 00:00:00
[NAME] | 1975-11-17 00:00:00
[NAME] | 1975-04-05 00:00:00
[NAME] | 1969-03-31 00:00:00
Tyrone Corbin | 1962-12-31 00:00:00
Spreadsheet: 864242d1711479912-create-running-total-by-year-inside-a-table-running-total-updated
Sheet: Sheet1

c1 | c2 | c3 | yy1 | yy2 | rr | c7 | j" | Run y
2023-07-24 00:00:00 | rr | 15 | 0 |  |  |  |  |  | Running totals only for year 2023
2023-09-15 00:00:00 | rr | 14.52 | 0
2023-10-23 00:00:00 | rr | 14.95 | 0
2023-10-23 00:00:00 | rr | 15.03 | 0
2023-10-27 00:00:00 | rr | 16.2 | 0
2023-11-28 00:00:00 | y |  | 25.89
2023-11-28 00:00:00 | y |  | 163.91
2023-12-21 00:00:00 | y |  | 13.2 | 19
2024-01-03 00:00:00 | y |  |  | 29.45 |  |  |  |  | Running totals only for year 2024
2024-02-02 00:00:00 | y |  | 31.09
2024-03-01 00:00:00 | y |  | 40.85
2024-03-12 00:00:00 | rr | 15.14
2024-03-13 00:00:00 | rr | 12
 |  |  | These two columns are added to the running total for "y" by year. |  | This is the only column for running total for "rr" by year.
should be
 |  |  |  |  |  |  | Running total rr | Running total y
2023-07-24 00:00:00 | rr | 15 | 0
2023-09-15 00:00:00 | rr | 14.52 | 0
2023-10-23 00:00:00 | rr | 14.95 | 0
2023-10-23 00:00:00 | rr | 15.03 | 0
2023-10-27 00:00:00 | rr | 16.2 | 0
2023-11-28 00:00:00 | y |  | 25.89
2023-11-28 00:00:00 | y |  | 163.91
2023-12-21 00:00:00 | y |  | 13.2 | 19
2024-01-03 00:00:00 | y |  |  | 29.45
2024-02-02 00:00:00 | y |  | 31.09
2024-03-01 00:00:00 | y |  | 40.85
2024-03-12 00:00:00 | rr | 15.14
2024-03-13 00:00:00 | rr | 13.1 |  |  |  | 2024
Spreadsheet: 66648d1267285475-linking-data-to-different-tabs-in-excel-staff-5
Sheet: Sheet1

task No |  | date
Task 1 | Employee 1 | 2010-06-01 00:00:00 | 1-Employee 1
Task 2 | Employee 2 |  | 1-Employee 2
Task 3 | Employee 1 | 2010-08-01 00:00:00 | 2-Employee 1
Task 4 | Employee 2 | 2010-03-01 00:00:00 | 2-Employee 2
Task 5 | Employee 3 | 2010-11-01 00:00:00 | 1-Employee 3
Task 6 | Employee 2 |  | 3-Employee 2
Task 7 | Employee 3 |  | 2-Employee 3
Task 8 | Employee 5 | 2010-02-27 00:00:00 | 1-Employee 5
Task 9
Task 10
Task 11
Task 12
Task 13
Task 14
Task 15
Task 16
Task 17
Task 18
Task 19
Task 20
Task 21
Task 22
Task 23
Task 24
Task 25
Task 26
Task 27
Task 28
Task 29
Task 30
Task 31
Task 32
Task 33
Task 34
Task 35
Task 36
Task 37
Task 38
Task 39
Task 40
Task 41
Task 42
Task 43
Task 44
Task 45
Task 46
Task 47
Task 48
Task 49
Task 50
Task 51
Task 52
Task 53
Task 54
Task 55
Task 56
Task 57
Task 58
Task 59
Task 60
Task 61
Task 62
Task 63
Task 64
Task 65
Task 66
Task 67
Task 68
Task 69
Task 70
Task 71
Task 72
Task 73
Task 74
Task 75
Task 76
Task 77
Task 78
Task 79
Task 80
Task 81
Task 82
Task 83
Task 84
Task 85
Task 86
Task 87
Task 88
Task 89
Task 90
Spreadsheet: 418de071-1d68-4089-b685-b32243a47a83
Sheet: Ohio 8 School Districts

COUNTY | DISTRICT NAME | DISTRICT IRN
Summit | Akron City | 043489
[NAME] | Canton City | 043711
[NAME] | Cincinnati City | 043752
Cuyahoga | Cleveland Municipal | 043786
Franklin | Columbus City | 043802
Montgomery | Dayton City | 043844
Lucas | Toledo City | 044909
Mahoning | Youngstown City | 045161
Spreadsheet: 238476d1369580815-4-digit-code-for-similar-product-new-product-unique-code-4-digit-codes-cleaned-up-again
Sheet: Sheet2

 | Fruit | ID |  |  | This is an information sheet only and may be deleted
1 | Apple | 1449
2 | Orange | 5405
3 | Peach | 3215
4 | Grapes | 6124
5 | Grapefruit | 2704
6 | Tangerine | 8215
7 | #N/A | #N/A
8 | #N/A | #N/A
9 | #N/A | #N/A
10 | #N/A | #N/A
11 | #N/A | #N/A
Spreadsheet: 83290d1283289055-sumproduct-and-if-statement-together-test-book-3
Sheet: Sheet1

Results
Product | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | State
Porudct A | 109 | 85 | 124 | 113 | 85 | 63 | NY
Porudct A | 49.2 | 63.9 | 58.8 | 80 | 39 | 47 | NJ
Product B | 4 | 6 | 8 | 7 | 5 | 3 | NY
Product B | 3.2 | 4.5 | 7.5 | 9.5 | 5.5 | 3.5 | NJ
Spreadsheet: 697354d1601317852-cagr-formula-for-multiple-stocks-cagr
Sheet: Sheet1

 |  | CAGR
 | START | COMPOUND ANNUAL GAIN % | YEAR 1 | YEAR 2 | YEAR 3 | YEAR 4
STOCK A | 100 | 0.03
STOCK B | 100 | 0.15
STOCK C | 100 | 0.4
TOTAL |  | TOTAL
 |  | CAGR
 |  |  | CAGR | CAGR | CAGR | CAGR
 | AVERAGE CAGR FOR ALL 3 STOCKS |  | 1 | 2 | 3 | 4
Spreadsheet: 86511d1286472069-excel-2007-finding-the-difference-in-time-sample_timedifference-v2
Sheet: Sheet1

Original Data Set
End date Range |  | Start Date
1/11/2009 01:00 - 02:00 |  | 2009-10-07 14:35:49
Step 1:
End Date Range | End Date instance | Start Date
1/11/2009 01:00 - 02:00 |  | 2009-10-07 14:35:49
Step 2:
End Date Range | End Date instance | Start Date | Time Window
1/11/2009 01:00 - 02:00 |  | 2009-10-07 14:35:49
Possible Solution:
End date Range | End Date Instance | Start Date | Time Window
1/11/2009 01:00 - 02:00 |  | 2009-10-07 14:35:49 |  | Daddlylonglegs
1/11/2009 01:00 - 02:00 |  | 2009-10-07 14:35:49 |  | DonkeyOte
New Issue:
End Date Window |  | Start Date | Time Difference
9/11/2009 04:00 - 12/11/2009 22:00 |  | 2009-06-11 11:02:00 |  | Daddlylonglegs
9/11/2009 13:00 - 13/11/2009 17:00 |  | 2009-06-11 13:25:00
9/11/2009 04:00 - 12/11/2009 22:00 |  | 2009-06-11 11:02:00 |  | DonkeyOte
9/11/2009 13:00 - 13/11/2009 17:00 |  | 2009-06-11 13:25:00
Spreadsheet: 1d411637-dc3b-4a31-9e13-6ce2031a0e4d
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
 | [NAME] | Open Lab Hours |  | Fall 2012
 |  | MC 108 | MC 114 | MC 116
 | Monday | 6:30 am- 9:00 pm | 6:00 am - 8:30 am 1:30 pm - 5:00 pm | 6:00 am - 9:30 am 11:30 am - 5:00 pm
 | Tuesday | 6:30 am- 9:00 pm | 6:00 am - 5:00 pm | 6:00 am - 9:00 am 12:00 pm - 1:30 pm 3:00 pm - 5:00 pm
 | Wednesday | 6:30 am- 9:00 pm | 6:00 am - 8:30 am 1:30 pm - 5:00 pm | 6:00 am - 9:30 am 11:30 am - 5:00 pm
 | Thursday | 6:30 am- 9:00 pm | 6:00 am - 5:00 pm | 6:00 am - 9:00 am 12:00 pm - 1:30 pm 3:00 pm - 5:00 pm
 | Friday | 6:30 am- 9:00 pm | 6:00 am - 5:00 pm | 6:00 am - 9:30 am 11:30 am - 5:00 pm
 | Saturday | 6:30 am- 9:00 pm | CLOSED | CLOSED
 | Sunday | 6:30 am- 9:00 pm | CLOSED | CLOSED
 | Holidays | Labs are closed on holidays.
 | Reserved classes may pre-empt open lab |  |  | 2012-08-15 00:00:00
Spreadsheet: 77121d1277585067-does-this-require-vlookup-service-dispatch-w-tabs
Sheet: INTERNALS

Status | A Customer | S.A. | RO | Model | Promised | A-Tech | Hours | Dispatched At | Completed At | Job Description |  |  |  |  | Reason for Hold
ASSIGNED | INTERNAL | 11912 | 65678 | 10 XL1200X | ASAP | TF | 27.85 | 4/14/20104:36 PM |  | INST ACCYS
ASSIGNED | INTERNAL / KAEHLER / SCHNEIDER | 11856 | 66067 | 10 FLHTCU | 6/15 @ 12 | RAS | 0.5 | 6/14/20102:28 PM |  | INSTALL ACCYS
ASSIGNED | INTERNAL | AK | 66450 | 07 FLHX | 2010-05-24 00:00:00 | AC | 1.5 | 5/27/201010:13 AM |  | PERFORM UVD/ 15 POINT INSPECTION
ASSIGNED | INTERNAL | 11914 | 66541 | 10 FXDWG | 2010-05-27 00:00:00 | RAS | 4 | 5/27/20108:52 AM |  | IK SERVICE
ASSIGNED | INTERNAL MAJOR UNIT | 11965 | 66555 | 10 FXD | 2010-05-27 00:00:00 | MK | 0.75 | 6/3/201010:41 AM |  | DEALER TRADE
ASSIGNED | INTERNAL | 11928 | 66576 | 98 FLSTC | 2010-05-28 00:00:00 | DAN | 1.4 | 6/16/20101:32 PM |  | INSTALL ACCESSORIES
ASSIGNED | INTERNAL MAJOR UNIT | 11924A | 66623 | 03 FLSTF | 2010-06-01 00:00:00 | RS | 1.5 | 6/2/20103:53 PM |  | PERFORM UVD/15-PT INSPECTION, PERFORM RECALL 0119
ASSIGNED | INTERNAL MAJOR UNIT | 11975 | 66788 | 85 FLHS | 2010-06-08 00:00:00 | RS | 1.5 | 6/9/20104:23 PM |  | UVD/15-PT INSPECTION
ASSIGNED | INTERNAL | 11984 | 66875 | 02 FLSTCI | 2010-06-11 00:00:00 | MH | 1.5 | 6/15/201010:26 AM |  | UVD/15-PT INSPECTION
ASSIGNED | INTERNAL | 11998 | 67096 | 09 FLHX |  | MH | 1.5 | 6/25/20108:12 AM |  | PERFORM UVD/15-PT INSPECTION
ASSIGNED | INTERNAL / LEUBKE |  | 67119 | 05 XL883L | 2010-06-25 00:00:00 | MH | 1.5 | 6/25/20101:27 PM |  | PERFORM UVD/15-PT INSPECTION
HOLD - NO BIKE | INTERNAL / LENZEN | 11869 | 65844 | 10 FLHTK | 2010-05-14 00:00:00 | JZ | 15.05 | 5/10/201010:17 AM |  | INST ACCYS/ DYNO TIME
HOLD - PARTS - FUEL GAUGE | INTERNAL | Z401A | 66943 | 01 FLHTCU | 2010-06-16 00:00:00 |  | 1.5 |  |  | UVD/15-PT INSPECTION
HOLD - WAITING TO TALK TO AMY | INTERNAL | 11972 | 66693 | 04 FLSTFI | 2010-06-03 00:00:00 | RS | 1.5 | 6/8/201012:03 PM |  | PERFORM UVD/15-PT INSPECTION
NEEDS DYNO | INTERNAL | 11924 | 66479 | 10 FLHX | 2010-06-10 00:00:00 | AC | 6.95 | 6/9/201010:44 AM
 | SALES | 11771A | 66635 |  | 2010-06-11 00:00:00 |  | 1.5 |  |  | PERFORM UVD/15-PT INSPECTION
ASSIGNED | INTERNAL / ROBERT | Z384 | 66750 | 04 VRSC | WAITER | BS | 0.6 | 6/26/20109:48 AM |  | INSTALL ACCESSORIES
Spreadsheet: 143174d1330256365-using-sum-function-book1_charlesch
Sheet: CAUL_2012-02-25_R1

number 1 | number 2 | number 3 | total
16.09 (1) | 12.05 (2) | 12.23 (2) | 40.37 | 40.37 |  | 40.37 |  | 40.37
16.21 (3) | 12.25 (3) | 12.24 (3) | 40.70 | 40.7 |  | 40.7 |  | 40.7
16.52 (5) | 12.70 (6) | 11.99 (6) | 39.221 | 41.21000000000001 |  | 41.21000000000001 |  | 41.21
16.27 (4) | 12.28 (4) | 12.18 (4) | 40.73 | 40.73 |  | 40.73 |  | 40.73
16.18 (2) | 11.87 (1) | 12.22 (1) | 39.127 | 40.27 |  | 40.27 |  | 40.27
16.58 (6) | 12.41 (5) | 12.17 (5) | 40.116 | 41.16 |  | 41.16 |  | 41.16
Spreadsheet: 762260d1641476204-modify-existing-if-and-iferror-formula-permit-register-example-6-1-22
Sheet: Inspections

ABC Job Number | Address | Permit Number | Date of Inspection | Type of  Inspection | Date & Inspection Type (Merged) | Report  Completed | Comments
ABC-21001 |  |  | 2021-01-04 00:00:00 | Final
ABC-21010 |  |  | 2021-01-10 00:00:00 | Waterproofing |  | Y
ABC-21005 |  |  | 2021-01-15 00:00:00 | Final
ABC-21002 |  |  | 2021-01-15 00:00:00 | [NAME] |  | Y
ABC-21015 |  |  | 2021-01-15 00:00:00 | Wall Framing & Wet Area |  | Y
ABC-21003 |  |  | 2021-01-15 00:00:00 | Final |  | Y
ABC-21007 |  |  | 2021-01-15 00:00:00 | Final
ABC-21008 |  |  | 2021-01-15 00:00:00 | Final
ABC-21020 |  |  | 2021-01-15 00:00:00 | Waterproofing |  | Y
ABC-21010 |  |  | 2021-01-15 00:00:00 | Final
ABC-21004 |  |  | 2021-01-18 00:00:00 | Waterproofing |  | Y
ABC-21006 |  |  | 2021-01-18 00:00:00 | Final |  | Y
ABC-21009 |  |  | 2021-01-18 00:00:00 | Final |  | Y
ABC-21011 |  |  | 2021-01-18 00:00:00 | Footing
ABC-21012 |  |  | 2021-01-18 00:00:00 | Slab & Footings
ABC-21015 |  |  | 2021-01-19 00:00:00 | Final
ABC-21020 |  |  | 2021-01-19 00:00:00 | Final
ABC-21013 |  |  | 2021-01-20 00:00:00 | Shed
ABC-21014 |  |  | 2021-01-20 00:00:00 | Footings
Spreadsheet: 329329d1404273368-dynamic-top-5-customer-per-month-dynamic-top-5-customer-per-month-ans1
Sheet: Desired Result (new data)

Helper Columns |  |  |  | Desired Correct Helper Columns
 |  | OK |  | Customer A | 162
 |  |  |  | Customer B | 25
 |  |  |  | Customer C | 9
 |  |  |  | Customer D | 5
 |  |  |  | Customer E | 3
 |  | OK |  | Customer A | 201
 |  |  |  | Customer B | 16
 |  |  |  | Customer C | 14
 |  |  |  | Customer D | 5
 |  |  |  | Customer I | 4
 |  | Duplicates of Customer S |  | Customer A | 144
 |  |  |  | Customer C | 10
 |  |  |  | Customer B | 8
 |  |  |  | Customer S | 7
 |  |  |  | Customer X | 7
 |  | Duplicates of Customer B |  | Customer A | 89
 |  |  |  | Customer C | 13
 |  |  |  | Customer B | 7
 |  |  |  | Customer E | 7
 |  |  |  | Customer I | 7
ABOVE HAS FORMULA
Spreadsheet: 65978d1266597339-overtime-after-40-hours-employee-timesheet-with-breaks2
Sheet: Biweekly

Biweekly Employee Time Sheet
http://www.vertex42.com/ExcelTemplates/free-timesheet-template.html | http://www.vertex42.com/ExcelTemplates/free-timesheet-template.html | http://www.vertex42.com/ExcelTemplates/free-timesheet-template.html | http://www.vertex42.com/ExcelTemplates/free-timesheet-template.html |  |  |  |  |  | © 2003 Vertex42 LLC
[Company Name]
 |  |  |  |  | Employee Name:
[Address 1]
[Address 2] |  |  |  |  | Manager [NAME]:
[City, State  ZIP]
[Phone] |  |  |  |  | Week Starting: |  | 2008-10-10 00:00:00 |  |  | [42]
Day of Week | Time In | Time Out |  | Time In | Time Out | Total Hrs | Regular Hrs | Overtime Hrs | Sick Hrs | Vacation Hrs
 | 08:00:00 | 11:33:00 |  | 12:07:00 | 17:00:00 |  | 8 | 0.43
 |  |  |  |  | Total Hrs:
 |  |  |  |  | Rate/Hr: |  | 15 | 23 | 15 | 15
 |  |  |  |  | Total $:
Employee Signature |  |  | Date
Manager Signature |  |  | Date
Spreadsheet: 123129d1317365418-when-using-match-function-can-your-lookup-array-be-multiple-rows-and-columns-help
Sheet: formulas

What works |  |  |  | What I want to work but won't
Reference to find row for | 11AW |  |  | Reference to find row for | 11AW |  |  |  |  |  |  | =INDEX(H3:H7,MATCH(A3&B3,INDEX(F3:F7&G3:G7,0),0))
Row Reference is in | 2 |  |  | Row Reference is in | #N/A | #N/A | 2
Ref. to find column for | BCWP |  |  | Ref. to find column for | BCWP
Column Ref is in | 5 |  |  | Column Ref is in | #N/A | #N/A | 5
Value returned by index function | hello |  |  | Value returned by index function | #N/A |  | Note array formula is used and should be confirmed though the Ctrl+Shift+Enter
or | hello |  |  | or
if my raw data doesn't always have 11AW in column C though the formula breaks
Spreadsheet: 713088d1610552715-showing-only-90-day-range-of-data-book10-example
Sheet: Dashboard

Days to go back
90 | Contract | Award | Description | Execution Date | Sum of Value
 |  |  |  |  |  |  | =IF($I9-$J$6>30,"LOW",IF($I9>$J$6,"AT RISK","LATE"))
Spreadsheet: 206392d1358177412-tracking-construction-employee-hours-across-sheets-hours-per-installer-per-job-tracker
Sheet: Job 1

Date | Installer | Category | Type |  | Hours |  |  |  | Month | Day | Year
2013-01-07 00:00:00 | Alpha |  |  |  | 1 |  |  | Beginning
2013-01-08 00:00:00 | Bravo |  |  |  | 2 |  |  | Ending | 4
2013-01-09 00:00:00 | [NAME] |  |  |  | 3
2013-01-10 00:00:00 | Delta |  |  |  | 4 |  | [NAME] # |  | Category --> | a | b | c | d |  |  |  |  |  |  | Totals
2013-01-11 00:00:00 | Echo |  |  |  | 5 |  |  |  | Type --> | 1 | 2 | 3 | 4
2013-01-07 00:00:00 | Foxtrot |  |  |  | 6 |  |  | Total Hrs
2013-01-08 00:00:00 | Golf |  |  |  | 7 |  |  | Name
2013-01-09 00:00:00 | Hotel |  |  |  | 8 |  | 1
2013-01-10 00:00:00 | India |  |  |  | 9 |  | 5
2013-01-11 00:00:00 | [NAME] |  |  |  | 10 |  | 8
2013-01-07 00:00:00 | Kilo |  |  |  | 1 |  | 19
2013-01-08 00:00:00 | Lima |  |  |  | 2 |  | 22
2013-01-09 00:00:00 | [NAME] |  |  |  | 3 |  | 4
2013-01-10 00:00:00 | November |  |  |  | 4
2013-01-11 00:00:00 | [NAME] |  |  |  | 5
2013-01-07 00:00:00 | Papa |  |  |  | 6
2013-01-08 00:00:00 | Quebec |  |  |  | 7
2013-01-09 00:00:00 | Romeo |  |  |  | 8
2013-01-10 00:00:00 | Sierra |  |  |  | 9
2013-01-11 00:00:00 | Tango |  |  |  | 10
2013-01-21 00:00:00 | Uniform |  |  |  | 1
2013-01-22 00:00:00 | Victor |  |  |  | 2
2013-01-23 00:00:00 | Whiskey |  |  |  | 3
2013-01-24 00:00:00 | Xray |  |  |  | 4
2013-01-25 00:00:00 | Yankee |  |  |  | 5
2013-01-21 00:00:00 | Zulu |  |  |  | 6
2013-01-22 00:00:00 | Person 007 |  |  |  | 7
2013-01-23 00:00:00 | Person 008 |  |  |  | 8
2013-01-24 00:00:00 | Person 009 |  |  |  | 9
2013-01-25 00:00:00 | Person 010 |  |  |  | 10
2013-01-28 00:00:00 | Person 011 |  |  |  | 1
2013-01-29 00:00:00 | Person 012 |  |  |  | 2
2013-01-30 00:00:00 | Person 013 |  |  |  | 3
2013-01-31 00:00:00 | Person 014 |  |  |  | 4
2013-02-01 00:00:00 | Person 015 |  |  |  | 5
2013-01-28 00:00:00 | Person 016 |  |  |  | 6
2013-01-29 00:00:00 | Person 017 |  |  |  | 7
2013-01-30 00:00:00 | Person 018 |  |  |  | 8
2013-01-31 00:00:00 | Person 019 |  |  |  | 9
2013-02-01 00:00:00 | Person 020 |  |  |  | 10
Spreadsheet: louise_kitchen__24136__North America Plan 01-08 adj
Sheet: Reg Affairs

 | Regulatory Affairs
 | 2002 Plan
 |  |  |  |  |  |  |  |  | Per HC | New HC | Adjust Comp
 |  | 2001-09-01 00:00:00 |  | 2001 |  | 2002 |  |  |  |  |  |  |  | 2002
 |  | YTD Actual |  | Forecast |  | Plan |  |  |  |  |  |  |  | Plan
ENACOMP | Compensation |  |  |  |  |  |  | Compensation | 0
 | Special Pays | 0 |  |  |  | 0
 | Analyst & Assoicate | 0 |  |  |  | 0
ENABENTX | Benefits & Payroll Taxes |  |  |  |  |  |  | Other
ENAEMPEX | Employee Expense
ENAT&EEX | Travel & Entertainment Expense |  |  |  |  |  |  | Total |  |  |  |  | 1893527
ENAOUTSV | Outside Services | 0 |  |  |  | 4200000
ENASUPP | Supplies Expense
ENAMKTEX | Marketing |  |  |  |  |  |  | [NAME] | 28000 | 0
ENACONTR | Charitable Contributions |  |  |  |  |  |  | [NAME] | 36000 | 0
ENARENT | Rent |  |  |  |  |  |  | Coordinator | 48000 | 0
ENATECH | Technology |  |  |  |  |  |  | Specialist | 52500 | 0
ENATRANS | Transportation |  |  |  |  |  |  | Sr. Specialist | 65000 | 0
ENAOTHEX | Other Expenses |  |  |  |  |  |  | Analyst | 55000 | 0
ENATAXES | Taxes Other than Income |  |  |  |  |  |  | Associate | 81000 | 0
ENATOTDR | Total Direct Expenses |  |  |  |  |  |  | Manager |  | 1
 |  |  |  |  |  |  |  | Director |  | 3
 | Headcount |  |  | 111 |  |  |  | Sr. Director |  | 4
 |  |  |  |  |  |  |  | VP |  | 2
 | A&A Headcount |  |  |  |  |  |  | MD |  | 0
 | Total Headcount |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  |  |  | Benefits & Taxes |  |  | 0.2
ENAOUTLG | Outside Legal
ENAOUTTX | Outside Tax
ENAINSUR | Insurance
ENASYSDV | System Development |  |  |  |  |  |  | Other Expense Calculation
ENACORIT | Controllable Infrastructure
ENACORRN | Corporate Rent |  |  |  |  |  |  | Based on Legal Expenses
ENAOTHAL | Other Allocated Direct  Expenses
ENADEPR | Depreciation & Amortization
ENAOUTSV | Outside Services | 24143776.43 |  | 32191701.90666667
Spreadsheet: 870825d1717263687-how-do-i-calculate-data-from-various-excel-sheets-sample-data1
Sheet: table_3

TABLE 3
Nr | Data col.1 | Data col.2 | Data col.3 | Data col.4
1 | dfd | 3001 | 43 | yq
2 | dsfs | 3002 | 44 | ewe
3 | sd | 3003 | 45 | wewe
4 | aas | 3004 | 46 | ewe
5 | d | 3005 | 47 | wewe
6 | sd | 3006 | 48 | ewe
7 | h | 3007 | 49 | wewe
8 | d | 3008 | 50 | ewe
9 | aas | 3009 | 51 | wewe
10 | fghdf | 3010 | 52 | ewe
11 | mbn | 3011 | 53 | wewe
12 | dsfs | 3012 | 54 | ewe
13 | gh | 3013 | 55 | wewe
14 | ghf | 3014 | 56 | ewe
15 | xcz | 3015 | 57 | wewe
16 | j | 3016 | 58 | ewe
17 | f | 3017 | 59 | wewe
18 | d | 3018 | 60 | ewe
19 | s | 3019 | 61 | wewe
20 | u | 3020 | 62 | ewe
21 | u | 3021 | 63 | wewe
22 | j | 3022 | 64 | ewe
23 | sadas | 3023 | 65 | wewe
24 |  | 3024 | 66 | ewe
25 | fjhdfh | 3025 | 67 | wewe
26 | fghdf | 3026 | 68 | ewe
27 | dasd | 3027 | 69 | wewe
28 | fh | 3028 | 70 | ewe
29 | lj | 3029 | 71 | wewe
30 | k | 3030 | 72 | ewe
Spreadsheet: 115528d1311102367-excel-2007-countif-is-off-book2
Sheet: Sheet2

no_news
1
0
1
1
1
0
0
1
1
1 |  |  |  | Newsletter |  |  | 305
1
1 |  |  |  | PDF in Email |  |  | 607
FALSE
0
1
1
1
FALSE
1
1
1
1
0
0
0
0
1
1
1
0
1
1
FALSE
1
1
1
1
0
1
1
1
1
1
FALSE
1
1
0
1
1
0
1
0
1
0
1
0
0
1
1
1
0
0
1
0
0
0
0
0
1
0
1
1
0
0
1
0
0
FALSE
0
0
1
1
FALSE
1
0
1
1
1
1
1
1
1
1
1
0
1
FALSE
1
1
0
1
1
0
1
1
FALSE
0
0
1
1
FALSE
0
1
0
0
1
0
FALSE
1
0
0
1
0
0
1
1
1
0
FALSE
1
1
1
1
0
0
0
0
0
0
1
1
1
1
1
0
1
1
1
0
1
1
1
0
1
0
0
1
1
1
1
0
0
1
1
1
0
1
1
1
1
1
0
0
1
0
1
FALSE
1
1
1
0
1
1
0
0
FALSE
1
0
1
1
1
1
1
1
0
0
0
1
1
0
0
FALSE
1
0
1
1
0
1
0
1
1
1
1
FALSE
0
1
1
0
1
1
0
0
1
1
1
1
FALSE
FALSE
0
0
1
1
1
0
1
1
1
1
1
0
1
1
1
1
0
0
1
FALSE
0
0
1
0
1
1
1
1
0
1
0
0
1
1
1
0
FALSE
1
1
1
1
1
0
0
0
FALSE
1
1
1
1
1
0
0
0
1
0
1
1
1
1
0
0
FALSE
1
1
0
1
0
FALSE
1
1
1
0
1
0
0
0
1
0
1
FALSE
0
0
1
0
0
FALSE
1
1
FALSE
FALSE
1
0
0
0
1
1
1
1
1
0
FALSE
0
1
1
0
1
FALSE
0
TRUE
1
1
1
1
1
1
1
1
0
1
0
0
1
1
1
1
0
1
1
1
1
0
0
0
1
1
1
FALSE
1
1
1
1
1
1
FALSE
1
0
1
1
1
1
FALSE
0
FALSE
1
1
1
0
1
1
1
0
1
1
1
1
0
1
FALSE
FALSE
0
0
0
1
0
0
1
0
0
1
1
1
FALSE
1
0
0
1
1
1
1
0
FALSE
1
1
1
1
0
1
0
1
0
0
1
1
1
1
1
0
0
0
1
0
0
0
1
0
1
1
1
1
1
1
1
1
1
0
1
1
1
1
1
1
0
1
0
1
1
1
0
1
1
1
1
1
0
1
1
1
1
1
0
1
0
1
1
0
1
1
1
1
1
1
1
1
1
1
0
1
1
1
0
1
1
0
FALSE
0
1
1
1
1
1
1
0
0
0
1
1
1
1
1
1
0
1
1
1
0
1
1
1
FALSE
1
1
FALSE
1
1
0
1
1
1
1
0
1
1
1
FALSE
1
1
FALSE
0
1
1
0
1
1
0
1
1
1
1
1
0
0
1
1
1
0
1
1
0
1
0
0
0
0
0
0
1
1
1
0
1
1
FALSE
FALSE
0
1
FALSE
1
1
1
1
1
1
1
1
0
0
0
1
1
0
1
0
0
FALSE
1
0
1
1
0
1
1
FALSE
1
1
FALSE
1
1
1
1
1
1
1
FALSE
FALSE
1
1
1
0
FALSE
1
FALSE
1
1
1
1
1
0
1
1
0
1
1
1
0
1
FALSE
1
FALSE
FALSE
1
0
1
FALSE
1
FALSE
1
1
1
0
0
1
0
0
1
0
1
1
1
0
0
1
1
0
1
1
FALSE
FALSE
1
1
1
1
0
1
1
1
0
1
1
0
1
0
1
1
0
FALSE
0
0
0
0
0
0
0
0
1
0
FALSE
1
0
0
FALSE
0
1
0
1
0
1
0
1
0
1
0
1
1
0
1
1
1
1
0
1
FALSE
1
1
1
1
1
1
1
1
1
0
1
1
1
0
1
1
1
FALSE
1
1
0
1
1
0
FALSE
1
1
0
1
0
FALSE
1
1
1
1
1
0
1
0
1
0
FALSE
1
1
0
0
FALSE
1
1
0
1
1
1
1
1
FALSE
1
1
0
0
0
FALSE
1
1
1
1
FALSE
1
FALSE
1
1
1
0
0
1
FALSE
1
1
1
1
1
1
0
1
0
0
FALSE
0
1
1
0
1
1
1
1
1
1
0
0
1
0
1
1
0
0
FALSE
1
0
1
1
1
1
0
1
1
FALSE
0
1
1
0
1
1
1
FALSE
1
1
0
1
1
1
0
1
1
0
1
1
FALSE
0
0
1
1
1
1
1
0
1
1
0
1
1
0
1
1
1
0
1
1
0
0
0
FALSE
0
1
0
1
1
FALSE
0
1
1
1
1
0
0
0
0
1
FALSE
1
0
1
1
1
1
FALSE
FALSE
1
0
0
1
1
0
0
0
1
1
0
1
1
1
1
1
0
1
1
1
0
1
1
1
1
FALSE
1
1
1
1
FALSE
1
0
1
1
1
0
1
0
0
0
0
1
1
1
1
FALSE
1
1
1
1
0
0
FALSE
1
1
1
0
0
1
1
1
1
1
0
1
1
1
1
1
FALSE
FALSE
0
FALSE
0
0
1
0
FALSE
FALSE
1
1
FALSE
1
1
1
0
1
FALSE
1
FALSE
Spreadsheet: 54905d1254945620-formatting-rows-to-columns-format-sample
Sheet: Sheet1

985-0050 | PART NUMBER | [NAME] | DESC2 | PRICE
3PAR ADVANTAGE, PRICE PER NODE FOR 4, 6, | 985-0050 | 3PAR ADVANTAGE, PRICE PER NODE FOR 4, 6, | 3PAR ADVANTAGE, PRICE PER NODE FOR 4, 6, AND 8 NODES | 14876
3PAR ADVANTAGE, PRICE PER NODE FOR 4, 6, AND 8 NODES | 985-0051 | 3PAR ADVANTAGE, PRICE PER NODE FOR 4, 6, | 3PAR ADVANTAGE, PRICE PER NODE FOR 4, 6, AND 8 NODES | 15000
14876 | 985-0052 | 3PAR ADVANTAGE, PRICE PER NODE FOR 4, 6, | 3PAR ADVANTAGE, PRICE PER NODE FOR 4, 6, AND 8 NODES | 18000
985-0051 | 0 | 0 | 0 | 0
3PAR ADVANTAGE, PRICE PER NODE FOR 4, 6, | 0 | 0 | 0 | 0
3PAR ADVANTAGE, PRICE PER NODE FOR 4, 6, AND 8 NODES
15000
985-0052
3PAR ADVANTAGE, PRICE PER NODE FOR 4, 6,
3PAR ADVANTAGE, PRICE PER NODE FOR 4, 6, AND 8 NODES
18000