tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 64356d1265221970-date-validation-to-get-perfect-tat-time-management
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | Comp. TAT |  |  | Sear. TAT
File # | County | ST. | Received Time | Completed Time | On Hold | Search Start Time | Search End Time | Comment | Search
ABC123456789 | [NAME] | IL | 2010-02-02 11:33:16 | 2010-02-02 12:33:16 | No |  |  | Compeleted | No | 01:00:00
XYZ123456789 | Du Page | IL | 2010-02-02 11:33:16 | Pending | Yes | 2010-02-02 11:53:16 | 2010-02-02 13:43:16 | Search Incomplete | Yes | 02:10:00
XYZ123456789 | Du Page | IL | 2010-02-02 11:33:16 | Pending | Yes | 2010-02-02 11:53:16 | Pending | Search Incomplete | No
ABC123456789 | [NAME] | IL | 2010-02-02 11:33:16 | 2010-02-02 12:33:16 | No |  |  | Compeleted | No | 01:00:00
 |  |  |  | TAT Between H - D |  |  | TAT Between H - D
 |  |  |  |  | TAT Between E - D
First Query |  |  | TAT Between E - D |  |  | Final Query
 |  |  |  |  |  |  |  | TAT Between H - G
ON HOLD |  |  |  |  | TAT
If | YES | Start Search Time |  |  | If On hold = Yes, TAT Between H6-D6 (Search End Time - Recd. Time)
If | Search Completed | End Search Time |  |  | If On hold = No, TAT Between E6-D6 (Completed Time - Recd. Time)
Second Query
If | NO | User will Generate the [NAME] time Manualy
Even I don’t know how to activate the all three buttons.
Please Help me.
Spreadsheet: 0c79b9a8-fb2f-4909-9abd-067130a9002f
Sheet: 2007

2007 Rank | NAME OF EMPLOYER | EMPLOYEES(1) | BUSINESS | 2006 Rank
1 | HARVARD UNIVERSITY | 10031 | HIGHER EDUCATION | 1
2 | MASSACHUSETTS INSTITUTE OF TECHNOLOGY | 8044 | HIGHER EDUCATION | 2
3 | CITY OF CAMBRIDGE(2) | 2857 | GOVERNMENT | 3
4 | MT. AUBURN HOSPITAL | 1875 | MEDICAL | 4
5 | BIOGEN IDEC | 1543 | BIOTECHNOLOGY | 7
6 | CAMBRIDGE HEALTH ALLIANCE | 1436 | MEDICAL | 5
7 | FEDERAL GOVERNMENT | 1426 | GOVERNMENT | 6
8 | NOVARTIS INSTITUTE FOR BIOMEDICAL RESEARCH | 1399 | BIOTECHNOLOGY | 9
9 | GENZYME CORPORATION | 1388 | BIOTECHNOLOGY | 8
10 | DRAPER LABORATORY | 1123 | RESEARCH & DEVELOPMENT | 11
11 | COMMONWEALTH OF MASSACHUSETTS | 1012 | GOVERNMENT | 12
12 | MILLENIUM PHARMACEUTICALS | 932 | BIOTECHNOLOGY | 10
13 | VERTEX PHARMACEUTICALS | 894 | BIOTECHNOLOGY | 13
14 | QUEST DIAGNOSTICS | 854 | CLINICAL TESTING SERVICES | 18
15 | [NAME] CAMBRIDGE | 684 | BIOTECHNOLOGY | 14
16 | CAMP, DRESSER & MCKEE | 673 | ENGINEERING CONSULTANTS | 16
17 | YOUVILLE HOSPITAL & REHABILITATION CENTER | 660 | MEDICAL | 21
18 | EF INTERNATIONAL | 636 | TRAVEL & EXCHANGE PROGRAMS | 15
19 | SHIRE HGT | 602 | BIOTECHNOLOGY | 20
20 | AKAMAI | 539 | INTERNET NETWORK SERVICES | 24
21 | LESLEY UNIVERSITY | 525 | HIGHER EDUCATION | 19
22 | WHOLE FOODS | 509 | SUPERMARKET | 17
23 | FORRESTER RESEARCH | 490 | BUSINESS SERVICES | 23
24 | BBN TECHNOLOGIES(3) | 422 | RESEARCH & DEVELOPMENT | 26
25 | MONITOR GROUP | 412 | MANAGEMENT CONSULTING | 22
Spreadsheet: 706806d1606904937-lookup-across-multiple-columns-across-multiple-sheets-test
Sheet: Sheet1

123 | Apple | Yes | Red |  | 847 | Apple | No | Red |  | 998 | Apple | Yes | Red
156 | Orange | Yes | Blue |  | 156 | Orange | No | Yellow |  | 156 | Orange | No | Purple
745 | Apple | No | Blue |  | 108 | Apple | Yes | Blue |  | 745 | [NAME] | Yes | Red
859 | [NAME] | Yes | Yellow |  | 859 | Orange | No | Purple |  | 859 | Pear | Yes | Yellow
Spreadsheet: 848412d1699132049-golf-leaderboard-not-updating-for-last-quarter-of-year-form-2003_leaderboard-auto-update
Sheet: Jul-Sep

Form 2003A |  | LEADERBOARD 2023 |  |  |  | https://hinterlandgolfgroup.wixsite.com/my-site
Win 8pts = 6+2  /  2nd 7pts = 5+2  /  3rd 6pts  /  4th 5pts  /   5th 4pts  /  6th 3pts / 2 pts for playing
 | Year to Date | PTS |  | JUL | PTS |  | AUG | PTS |  | SEP | PTS
1 | [NAME] |  |  | [NAME] | 20 |  | [NAME] | 17 |  | Lower [NAME] | 17
2 | [NAME] |  |  | [NAME] | 17 |  | Lower [NAME] | 15 |  | Trounce [NAME] | 17
3 | [NAME] |  |  | [NAME] | 15 |  | [NAME] | 14 |  | Stenhouse Neil | 16
4 | [NAME] |  |  | [NAME] | 14 |  | [NAME] | 14 |  | [NAME] | 15
5 | [NAME] |  |  | [NAME] | 14 |  | [NAME] | 12 |  | [NAME] | 15
6 | [NAME] |  |  | [NAME] | 12 |  | [NAME] | 11 |  | [NAME] | 14
7 | [NAME] |  |  | Lower [NAME] | 11 |  | [NAME] | 10 |  | [NAME] | 13
8 | Beaman Eve |  |  | [NAME] | 11 |  | Stenhouse Neil | 9 |  | [NAME] | 13
9 | [NAME] |  |  | [NAME] | 10 |  | [NAME] | 9 |  | [NAME] | 13
10 | [NAME] |  |  | [NAME] | 10 |  | Lower Simon | 8 |  | [NAME] | 12
11 | [NAME] |  |  | [NAME] | 8 |  | [NAME] | 8 |  | [NAME] | 12
12 | [NAME] |  |  | Trounce [NAME] | 8 |  | [NAME] | 7 |  | [NAME] | 12
13 | [NAME] |  |  | [NAME] | 7 |  | [NAME] | 7 |  | [NAME] | 11
14 | Trounce [NAME] |  |  | Beaman Eve | 6 |  | Durack David | 6 |  | [NAME] | 11
15 | [NAME] |  |  | [NAME] | 6 |  | [NAME] | 6 |  | [NAME] | 11
16 | Lower [NAME] |  |  | [NAME] | 5 |  | Trounce [NAME] | 6 |  | Beaman Eve | 10
17 | [NAME] |  |  | [NAME] | 5 |  | [NAME] | 5 |  | [NAME] | 10
18 | Shortus Heather |  |  | Stenhouse Neil | 5 |  | [NAME] | 4 |  | [NAME] | 10
19 | [NAME] |  |  | [NAME] | 5 |  | [NAME] | 4 |  | [NAME] | 8
20 | Stenhouse Neil |  |  | Shortus Heather | 4 |  | [NAME] | 4 |  | [NAME] | 7
21 | [NAME] |  |  | [NAME] | 4 |  | [NAME] | 4 |  | [NAME] | 6
22 | [NAME] |  |  | [NAME] | 2 |  | Beaman Eve | 4 |  | [NAME] | 6
23 | [NAME] |  |  | [NAME] | 2 |  | [NAME] | 2 |  | [NAME] | 4
24 | [NAME] |  |  | [NAME] | 2 |  | Brownsworth John | 2 |  | [NAME] | 4
25 | [NAME] |  |  | [NAME] | 2 |  | [NAME] | 2 |  | [NAME] | 4
26 | [NAME] |  |  | Griffin [NAME] | 2 |  | [NAME] | 2 |  | Durack David | 4
27 | Durack David |  |  |  |  |  | [NAME] | 2 |  | [NAME] | 2
28 | Brownsworth John |  |  |  |  |  | Griffin [NAME] | 2 |  | Lower Simon | 2
29 | [NAME] |  |  |  |  |  |  |  |  | Shortus Heather | 2
30 | Lower Simon
31 | [NAME]
32 | [NAME]
33 | [NAME]
34 | [NAME]
35 | [NAME]
34 | [NAME]
35 | Griffin [NAME]
36 | [NAME] | 2
37 | [NAME]
38 | [NAME]
39 | Stanlake Helen
40 | Stanlake [NAME]
41 | [NAME]
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
Spreadsheet: 76599d1277148533-excel-2007-adding-text-to-a-cell-that-already-has-conditional-formatting-applied-new-sample-2007-
Sheet: Gantt Chart

 | Today
 | Current Period | 74 |  |  |  | Construction |  |  |  |  |  |  |  | Operation to Date |  |  |  |  |  |  |  |  | Remaining
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | This is a line of text |  |  |  |  |  |  |  |  |  | why doesn't this work
Spreadsheet: 858388d1707109269-copying-data-from-daily-time-break-sheet-test-42-ans
Sheet: Mon

 | 2024-01-01 00:00:00 | 2024-01-08 00:00:00 | 2024-01-15 00:00:00 | 2024-01-22 00:00:00 | 2024-01-29 00:00:00
TimeSlice | Monday | Monday | Monday | Monday | Monday
08:15:00
08:30:00
08:45:00
09:00:00
09:15:00
09:30:00
09:45:00
10:00:00
10:15:00
10:30:00
10:45:00
11:00:00
11:15:00
11:30:00
11:45:00
12:00:00
12:15:00
12:30:00
12:45:00
13:00:00
13:15:00
13:30:00
13:45:00
14:00:00
14:15:00
14:30:00
14:45:00
15:00:00
15:15:00
15:30:00
15:45:00
16:00:00
16:15:00
16:30:00
16:45:00
17:00:00
17:15:00
17:30:00
17:45:00
18:00:00
18:15:00
18:30:00
18:45:00
19:00:00
19:15:00
19:30:00
19:45:00
20:00:00
20:15:00
20:30:00
20:45:00
21:00:00
21:15:00
21:30:00
21:45:00
22:00:00
22:15:00
22:30:00
22:45:00
23:00:00
23:15:00
23:30:00
23:45:00
00:00:00
00:15:00
00:30:00
00:45:00
01:00:00
01:15:00
Spreadsheet: 133874d1324737335-excel-2007-automatically-group-rows-in-text-only-table-book1
Sheet: pivot

 | expanded |  |  |  |  |  |  | collapsed
 | pivot set to tabular and all subtotals and grand totals off |  |  |  |  |  |  | same settings as on left but the issue is when it is collapsed it
 | this is exactly what i want the finished report to look like |  |  |  |  |  |  | shows the totals for each product not what is in warehouse 1,
 | when expanded |  |  |  |  |  |  | also desc & warehouse are now blank
 | [NAME] | desc | warehouse | Sum of qty |  |  |  | [NAME] | desc | warehouse | Sum of qty
 | product 1 | description a | warehouse 1 | 6 |  |  |  | product 1 |  |  | 26
 |  |  | warehouse 2 | 2 |  |  |  | product 2 |  |  | 20
 |  |  | warehouse 3 | 4 |  |  |  | product 3 |  |  | 22
 |  |  | warehouse 4 | 6 |  |  |  | product 4 |  |  | 5
 |  |  | warehouse 5 | 8 |  |  |  | product 5 |  |  | 23
 | product 2 | description b | warehouse 1 | 8
 |  |  | warehouse 2 | 2
 |  |  | warehouse 3 | 2
 |  |  | warehouse 4 | 8 |  |  |  | take a look at 'grouped' sheet, this is exactly the look I want to acheive
 | product 3 | description c | warehouse 1 | 2 |  |  |  | warehouse 1 is the main data that is to be presented
 |  |  | warehouse 2 | 6
 |  |  | warehouse 3 | 4
 |  |  | warehouse 4 | 5
 |  |  | warehouse 5 | 5
 | product 4 | description d | warehouse 1 | 5
 | product 5 | description e | warehouse 1 | 5
 |  |  | warehouse 2 | 4
 |  |  | warehouse 3 | 6
 |  |  | warehouse 4 | 8
Spreadsheet: 693405d1598959379-index-match-left-and-middle-equations-warehouse
Sheet: Sheet1

Products | WH1 | WH2
PD-8310AK150-52-SR | 7 | 16
PD-8310AK200-52-SR | 2 | 22 |  |  |  |  |  |  |  | WH2
PD-8310BK150-52-SR |  | 2
PD-8310CK150-52-SR |  | 2 |  |  |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | PD-8801 | PD-8801 | PD-8801 | PD-8801
PD-8310DK200-52-SR |  | 2 |  |  |  | AK | BK | CK | DK | AK | BK | CK | DK | EK | FK | BK | FK | NK | PK
PD-8312AK150-53-SR |  | 10 |  |  | 100
PD-8312AK200-53-SR |  | 8 |  |  | 150
PD-8312BK100-51-SR |  | 20 |  |  | 200
PD-8312BK150-51-SR | 1 | 42 |  |  | 250
PD-8312BK200-51-SR | 4 | 36
PD-8312BK250-51-SR |  | 20
PD-8312CK100-53-SR | 3 | 13
PD-8312CK150-53-SR | 3 | 38
PD-8312CK200-53-SR | 7 | 31 |  |  |  |  |  |  |  | WH1
PD-8312CK250-53-SR |  | 16
PD-8312DK200-51-SR | 1 | 1 |  |  |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | PD-8801 | PD-8801 | PD-8801 | PD-8801
PD-8312EK150-51-SR |  | 2 |  |  |  | AK | BK | CK | DK | AK | BK | CK | DK | EK | FK | BK | FK | NK | PK
PD-8312FK200-53-SR |  | 2 |  |  | 100
PD-8801BK100-48 | 15 | 33 |  |  | 150
PD-8801BK150 | 1 |  |  |  | 200
PD-8801BK150-48 | 22 | 30 |  |  | 250
PD-8801BK200-48 | 18 | 25
PD-8801BK250-48 | 20 | 27
PD-8801FK100-48 | 14 | 22
PD-8801FK150-48 | 28 | 19
PD-8801FK200-48 | 30 | 16
PD-8801FK250-48 | 16 | 20
PD-8801NK100-48 | 8 | 29
PD-8801NK150-48 | 19 | 24
PD-8801NK200-48 | 21 | 24
PD-8801NK250-48 | 19 | 27
PD-8801PK100-48 | 17 | 30
PD-8801PK150-48 | 35 | 26
PD-8801PK200-48 | 25 | 24
PD-8801PK250-48 | 23 | 26
Grand Total | 359 | 685
Spreadsheet: 803831d1667730878-formula-to-calculate-transit-times-example-39-
Sheet: Sheet1

Day of Collection | Next Departure | No of Days to [NAME] (min)
1 | 1
1 | 2
1 | 3
1 | 4
1 | 5
2 | 1
2 | 2
2 | 3
2 | 4
2 | 5
3 | 1
3 | 2
3 | 3
3 | 4
3 | 1
4 | 2
4 | 3
4 | 4
4 | 5
4 | 1
5 | 2
5 | 3
5 | 4
5 | 5
5 | 1
Key
Monday | 1
Tuesday | 2
Wednesday | 3
Thursday | 4
Friday | 5
Spreadsheet: 81397d1281604865-get-info-from-one-row-into-another-based-on-a-cell-example_need_help
Sheet: sheet2

Comment | Name | Age | Location | Time | Appears on
Msg 1 | Tom00 | 25 | Norway | 17:15:00
[NAME] | Tom01 | 26 | Norway01 | 22:00:00
Msg 3 | Tom02 | 27 | Norway | 21:45:00
Msg 4 | Tom03 | 28 | Norway02 | 16:30:00
Msg 5 | Tom04 | 29 | Norway | 17:45:00
Msg 6 | Tom05 | 30 | Norway03 | 22:00:00
Msg 7 | Tom06 | 31 | Norway | 19:30:00
Msg 8 | Tom07 | 32 | Norway04 | 17:00:00
Msg 9 | Tom08 | 33 | Norway | 21:45:00
Msg 10 | Tom09 | 34 | Norway05
Msg 11 | [NAME] | 35 | Norway
Msg 12 | Tom11 | 36 | Norway06
Msg 13 | Tom12 | 37 | Norway
Msg 14 | Tom13 | 38 | Norway07
Msg 15 | Tom14 | 39 | Norway
Msg 16 | Tom15 | 40 | Norway08
Msg 17 | Tom16 | 41 | Norway
Msg 18 | Tom17 | 42 | Norway09
 |  |  |  |  | Sheet0 - Sheet1 | <- Example
 |  |  |  |  | Sheet2 | <- Example
 |  |  |  |  | NO APPEARANCE | <- Example
* | On row F I want it to show on what sheet the row appears on.
* | Prefferbly  with posibability with more then one.
* | If it doe's not appear anywhere I want the cell to format to for example red
Spreadsheet: 228205d1366040024-filter-issue-data-does-not-appear-in-filter-box-special-project-cdl-premier_d
Sheet: Contract converter

 |  |  |  |  | non LOC Contracts |  | contracts customer is missing | CustNo | BillName | BillCity | BillState | Mfg | Contract | BeginDate | EndDate | Factor
 |  |  |  |  | 8000002516 |  |  |  |  |  |  |  |  | 2013-04-15 00:00:00 | 2013-04-30 00:00:00
 |  |  |  |  | 8000002685 |  |  |  |  |  |  |  |  | 2013-04-15 00:00:00 | 2013-04-30 00:00:00
 |  |  |  |  | 8000003987 |  |  |  |  |  |  |  |  | 2013-04-15 00:00:00 | 2013-04-30 00:00:00
 |  |  |  |  | 8000000251 |  |  |  |  |  |  |  |  | 2013-04-15 00:00:00 | 2013-05-31 00:00:00
 |  |  |  |  | 8000002492 |  |  |  |  |  |  |  |  | 2013-04-15 00:00:00 | 2013-09-30 00:00:00
 |  |  |  |  | 8000002549 |  |  |  |  |  |  |  |  | 2013-04-15 00:00:00 | 2013-11-30 00:00:00
 |  |  |  |  | 8000002152 |  |  |  |  |  |  |  |  | 2013-04-15 00:00:00 | 2013-12-31 00:00:00
 |  |  |  |  | 8000002506 |  |  |  |  |  |  |  |  | 2013-04-15 00:00:00 | 2013-12-31 00:00:00
 |  |  |  |  | 8000002544 |  |  |  |  |  |  |  |  | 2013-04-15 00:00:00 | 2013-12-31 00:00:00
 |  |  |  |  | 8000017493 |  |  |  |  |  |  |  |  | 2013-04-15 00:00:00 | 2014-08-31 00:00:00
 |  |  |  |  | 8000002621 |  |  |  |  |  |  |  |  | 2013-04-15 00:00:00 | 2014-10-31 00:00:00
 |  |  |  |  | 8000004735 |  |  |  |  |  |  |  |  | 2013-04-15 00:00:00 | 2015-03-31 00:00:00
 |  |  |  |  | 8000014486 |  |  |  |  |  |  |  |  | 2013-04-15 00:00:00 | 2015-07-31 00:00:00
 |  |  |  |  | 8000015735 |  |  |  |  |  |  |  |  | 2013-04-15 00:00:00 | 2015-07-31 00:00:00
 |  |  |  |  | 8000015985 |  |  |  |  |  |  |  |  | 2013-04-15 00:00:00 | 2015-07-31 00:00:00
 |  |  |  |  | 8000021235 |  |  |  |  |  |  |  |  | 2013-04-15 00:00:00 | 2015-10-31 00:00:00
 |  |  |  |  | 8000022485 |  |  |  |  |  |  |  |  | 2013-04-15 00:00:00 | 2015-11-30 00:00:00
 |  |  |  |  | 8000022494 |  |  |  |  |  |  |  |  | 2013-04-15 00:00:00 | 2015-11-30 00:00:00
CustNo | BillName | BillCity | BillState | Mfg | Contract | BeginDate | EndDate | Factor
5555 | Test Hospital | URBANA | IL | CDL | 8000002621 | 2012-02-06 00:00:00 | 2014-10-31 00:00:00 | 1.08
5555 | Test Hospital | URBANA | IL | CDL | 8000002689 | 2012-02-06 00:00:00 | 2013-04-30 00:00:00 | 1.08
5555 | Test Hospital | URBANA | IL | CDL | 8000004735 | 2012-04-01 00:00:00 | 2015-03-31 00:00:00 | 1.08
5555 | Test Hospital | URBANA | IL | CDL | 8000017485 | 2012-08-01 00:00:00 | 2013-12-31 00:00:00 | 1.08
5555 | Test Hospital | URBANA | IL | CDL | 8000017493 | 2012-11-07 00:00:00 | 2014-08-31 00:00:00 | 1.08
5555 | Test Hospital | URBANA | IL | CDL | 8000021235 | 2012-11-01 00:00:00 | 2015-10-31 00:00:00 | 1.08
5555 | Test Hospital | URBANA | IL | CDL | 8000022485 | 2012-12-01 00:00:00 | 2015-11-30 00:00:00 | 1.08
Spreadsheet: 94123d1293989175-search-for-string-in-worksheet-s-and-return-results-in-sequential-order-sample-workbook-mahju
Sheet: Facilties

Status | Name | ID | Hire Date
Active | [NAME] | 58.88855863405411 | 2001-05-13 00:00:00
Inactive | [NAME] | 280.8997048636497 | 1999-02-07 00:00:00
Active | [NAME] | 732.5559100162666 | 2006-05-30 00:00:00
Active | [NAME] | 943.6884675896359 | 1997-07-18 00:00:00
Inactive | [NAME] | 358.1255816510792 | 1984-11-03 00:00:00
Inactive | [NAME] | 817.0125171234417 | 2009-04-30 00:00:00
Inactive | [NAME] | 823.3920114019417 | 2002-01-06 00:00:00
Spreadsheet: eab37a56-9819-4e68-a275-71a7c660bd9a
Sheet: Sheet1

Unnamed: 0 | GOVERNOR - DEMOCRATIC | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
2002-09-10 00:00:00
Belknap County | [NAME], d | Hollingworth, d | Benson, r | Haas, r | Humphrey, r | Keough, r | Kingsbury, r | Kroepel, r | [NAME]
Alton | 77 | 62 | 4 | - | 2 | 0 | - | - | 1
Barnstead | 131 | 106 | 4 | - | 0 | 2 | - | - | 0
Belmont | 111 | 91 | 14 | - | 3 | 6 | - | - | 2
Center Harbor | 46 | 12 | 0 | - | 0 | 0 | - | - | 0
Gilford | 190 | 109 | 6 | - | 1 | 10 | - | - | 4
Gilmanton | 92 | 55 | 3 | - | 0 | 1 | - | - | 0
[NAME] | 59 | 80 | 4 | - | 0 | 0 | - | - | 0
[NAME] | 44 | 58 | 9 | - | 3 | 2 | - | - | 2
[NAME] 3 | 69 | 63 | 1 | - | 1 | 0 | - | - | 0
[NAME] | 54 | 63 | 8 | - | 1 | 2 | - | - | 5
[NAME] | 57 | 47 | 7 | - | 1 | 1 | - | - | 1
[NAME] 6 | 52 | 52 | 4 | - | 0 | 1 | - | - | 5
Meredith | 127 | 120 | 9 | - | 1 | 7 | - | - | 0
New Hampton | 85 | 31 | 6 | - | 2 | 1 | - | - | 0
Sanbornton | 100 | 53 | 6 | - | 3 | 2 | - | - | 1
[NAME] | 76 | 83 | 5 | - | 0 | 3 | - | - | 1
TOTALS | 1370 | 1085 | 90 |  | 18 | 38 |  |  | 22
 | GOVERNOR - DEMOCRATIC
Carroll County | [NAME], d | Hollingworth, d | Benson, r | Haas, r | Humphrey, r | Keough, r | Kingsbury, r | Kroepel, r | [NAME]
Albany | 22 | 10 | 1 | - | 0 | 0 | - | - | 0
[NAME] | 72 | 65 | 2 | - | 0 | 4 | - | - | 0
[NAME] | 16 | 17 | 4 | - | 0 | 0 | - | - | 0
Chatham | 6 | 2 | 0 | - | 0 | 0 | - | - | 3
Conway | 161 | 116 | 13 | - | 1 | 10 | - | - | 0
Eaton | 16 | 10 | 0 | - | 0 | 0 | - | - | 0
[NAME] | 38 | 25 | 0 | - | 0 | 0 | - | - | 0
Freedom | 42 | 32 | 4 | - | 0 | 1 | - | - | 0
Hale's Location | 1 | 2 | 0 | - | 0 | 0 | - | - | 0
Hart's Location | 1 | 1 | 0 | - | 0 | 0 | - | - | 0
[NAME] | 51 | 32 | 0 | - | 0 | 0 | - | - | 0
[NAME] | 44 | 34 | 0 | - | 1 | 3 | - | - | 0
Moultonborough | 85 | 50 | 5 | - | 2 | 5 | - | - | 0
Ossipee | 57 | 48 | 12 | - | 2 | 2 | - | - | 0
Sandwich | 146 | 40 | 0 | - | 0 | 1 | - | - | 0
Tamworth | 109 | 53 | 0 | - | 0 | 0 | - | - | 2
Tuftonboro | 41 | 45 | 2 | - | 0 | 1 | - | - | 0
Wakefield | 54 | 67 | 4 | - | 1 | 3 | - | - | 2
Wolfeboro | 129 | 114 | 0 | - | 0 | 0 | - | - | 0
TOTALS | 1091 | 763 | 47 |  | 7 | 30 |  |  | 7
Spreadsheet: holden_salisbury__12296__$ Calculator
Sheet: You Call It

 |  | 16 Hr Schedules | You Call It !
 |  | # of HLH Days = | 4
 |  | # of LLH Days = | 1 | Wheeling | Losses | Delivered Price
 |  | Price for HLH  = | 21.5 | 2 | 0.03
 |  | Price for LLH  = | 15.5 | 1.4 | 0.03
 |  | 24 Hr Schedules | You Call It !
 |  | # of HLH Days = | 22
 |  | # of LLH Days = | 4 | Wheeling | Losses | Delivered Price
 |  | Price for HLH  = | 23 | 1.75 | 0.025
 |  | Price for 16 LLH = | 15 | 1.25 | 0.025
 |  | Price for 8 LLH = | 13.25 | 1.25 | 0.025
 |  | Flat Price = |  |  | Flat Price =
 |  | "Off Peak" Price  = |  |  | "Off Peak" Price  =
 |  | KW Month  to  MWH |  |  | Hours per Month
 |  | KW Month Price = | 2.5 |  | Days per Month = | 30
 |  | # of hrs/month = | 733 |  | Hours per Month =
 |  | $ per MWH =
Spreadsheet: 97695d1296802255-pivot-table-subtotals-on-inner-row-label-fields-pivot-chart-table-help
Sheet: #2 Pivot Table with Bad Chart

Row Labels | Sample Size | Sum of Income ($)
Alabama |  | 2750000
 | 27 | 800000 |  |  |  |  |  |  |  |  |  |  |  |  |  | Bad Chart
 | 32 | 750000
 | 45 | 500000
 | 71 | 100000
 | 140 | 100000
 | 153 | 500000
Calif |  | 3800000
 | 6 | 750000 |  |  |  |  |  |  |  |  |  |  |  |  |  | Note: Sample [NAME] is charted on thecorrect axis, but it is not subtotaled.
 | 20 | 800000
 | 27 | 800000
 | 35 | 500000
 | 80 | 750000
 | 128 | 100000
 | 396 | 100000
Texas |  | 4400000
 | 5 | 750000
 | 8 | 100000
 | 19 | 500000
 | 34 | 100000
 | 56 | 750000
 | 60 | 800000
 | 73 | 100000
 | 78 | 800000
 | 90 | 500000
Grand Total |  | 10950000
Spreadsheet: 158986d1338472230-excel-2007-formula-which-returns-the-working-days-of-a-month-stopping-at-the-end-of-it-0spiros-working-days
Sheet: 2012 - Working Days

 |  | Do you like this format, more??
 | 2011-12-31 00:00:00 | 2012-01-31 00:00:00 | 2012-02-29 00:00:00 | 2012-03-31 00:00:00 | 2012-04-30 00:00:00 | 2012-05-31 00:00:00 | 2012-06-30 00:00:00 | 2012-07-31 00:00:00 | 2012-08-31 00:00:00 | 2012-09-30 00:00:00 | 2012-10-31 00:00:00 | 2012-11-30 00:00:00
1
2 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-01-01 00:00:00 | Holidays
3 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-01-06 00:00:00
4 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-02-27 00:00:00
5 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-03-25 00:00:00
6 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-04-13 00:00:00
7 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-04-15 00:00:00
8 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-04-16 00:00:00
9 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-05-01 00:00:00
10 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-08-15 00:00:00
11 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-10-28 00:00:00
12 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-11-17 00:00:00
13 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-12-25 00:00:00
14 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-12-26 00:00:00
15
16
17
18
19
20
21
22
23
Spreadsheet: lisa_gang__22249__EPE_APRIL_2002
Sheet: APRIL (4)

To: El Paso Marketing   -  fax # [PHONE]
El Paso Generation   -  fax # [PHONE]
 | 2002-04-04 00:00:00
HR ENDING | HR ENDING | FOUR CORNERS
Pacific | Mountain | SALE
Standard | Standard | EPMI
Time | Time | 22.25
 |  | CARRY OVER FROM 4/3
 |  | 4/1/02-4/30/02
 |  | EPMI TAG#41860 |  |  | TOTAL NET | NET PALO VERDE | NET FOUR CORNERS | NET EDDY
PST | MST | DIRECT BILL
2400 | 0100 | 25
0100 | 0200 | 0
0200 | 0300 | 0
0300 | 0400 | 0
0400 | 0500 | 0
0500 | 0600 | 0
0600 | 0700 | 0
0700 | 0800 | 0
0800 | 0900 | 0
0900 | 1000 | 0
1000 | 1100 | 0
1100 | 1200 | 0
1200 | 1300 | 0
1300 | 1400 | 0
1400 | 1500 | 0
1500 | 1600 | 0
1600 | 1700 | 0
1700 | 1800 | 0
1800 | 1900 | 0
1900 | 2000 | 0
2000 | 2100 | 0
2100 | 2200 | 0
2200 | 2300 | 0
2300 | 2400 | 0
2400 | 0100 | 0
 | MST Total |  |  |  |  |  |  |  | Today's Scheduled MWh
 |  |  | TOTAL SALES | TOTAL PURCHASES
 | PST TOTAL
 |  | EPE(G)4C
 |  | EPMI
 |  | AZPS(T)FC3/PPD2
 |  | WALC(T)PPD2/COOLIDGE
 |  | CRSP(L)COOLIDGE
Spreadsheet: 121474d1316090793-how-to-use-multiple-autofilters-nhl94-player-ratings
Sheet: New Jersey

Devils
Pos. | Name | Hand | # | Wgt | [NAME] | Spd | Off | Def | [NAME] | Chk | [NAME] | Shot Acc | Endr | Stick Lt | [NAME] | Glove Lt
G | [NAME] | L | 31 | 156 | 65 | 65 | 65 | 65 | 55 | 25 | 25 | 25 | 55 | 55 | 55 | 55
G | [NAME] | L | 1 | 172 | 55 | 65 | 45 | 45 | 35 | 25 | 25 | 25 | 45 | 45 | 45 | 45
Pos. | Name | Hand | # | Wgt | [NAME] | Spd | Off | Def | [NAME] | Chk | [NAME] | Shot Acc | Endr | ??? | Pass | Aggr
C | [NAME] | R | 20 | 188 | 65 | 55 | 65 | 65 | 55 | 55 | 65 | 65 | 55 | 45 | 65 | 45
C | [NAME] | R | 19 | 188 | 55 | 55 | 65 | 55 | 55 | 35 | 65 | 45 | 55 | 25 | 65 | 55
C | [NAME] | L | 26 | 212 | 65 | 55 | 55 | 65 | 55 | 55 | 65 | 65 | 55 | 45 | 65 | 35
C | [NAME] | L | 34 | 212 | 45 | 45 | 55 | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 55 | 45
C | [NAME] | R | 11 | 204 | 55 | 55 | 45 | 55 | 55 | 55 | 45 | 55 | 55 | 45 | 45 | 45
LW | [NAME] | L | 25 | 188 | 65 | 65 | 65 | 55 | 55 | 35 | 65 | 55 | 55 | 35 | 65 | 55
LW | Stephane Richer | R | 44 | 212 | 65 | 65 | 65 | 55 | 85 | 45 | 65 | 55 | 65 | 65 | 55 | 45
LW | [NAME] | R | 16 | 220 | 55 | 65 | 55 | 55 | 55 | 55 | 55 | 55 | 65 | 85 | 55 | 55
LW | [NAME] | L | 18 | 188 | 45 | 55 | 55 | 55 | 45 | 45 | 45 | 55 | 45 | 45 | 45 | 55
LW | [NAME] | R | 9 | 212 | 45 | 45 | 55 | 45 | 35 | 45 | 55 | 45 | 45 | 45 | 55 | 45
LW | Troy Mallette | L | 8 | 220 | 45 | 45 | 45 | 45 | 35 | 35 | 45 | 65 | 35 | 55 | 35 | 55
RW | [NAME] | R | 22 | 228 | 65 | 65 | 65 | 55 | 65 | 55 | 55 | 45 | 65 | 55 | 55 | 65
RW | [NAME] | R | 15 | 212 | 55 | 55 | 55 | 65 | 65 | 55 | 55 | 55 | 65 | 65 | 45 | 55
RW | [NAME] | R | 12 | 212 | 45 | 45 | 55 | 45 | 55 | 45 | 55 | 55 | 45 | 55 | 45 | 55
RW | [NAME] | R | 21 | 188 | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 55 | 65 | 45 | 65
Pos. | Name | Hand | # | Wgt | [NAME] | Spd | Off | Def | [NAME] | Chk | [NAME] | Shot Acc | Endr | ??? | Pass | Aggr
D | [NAME] | L | 4 | 228 | 65 | 65 | 55 | 65 | 65 | 85 | 65 | 45 | 85 | 25 | 65 | 55
D | [NAME] | L | 23 | 188 | 55 | 55 | 55 | 65 | 45 | 55 | 55 | 45 | 65 | 45 | 55 | 45
D | [NAME] | L | 2 | 228 | 65 | 45 | 45 | 65 | 65 | 65 | 65 | 35 | 55 | 25 | 65 | 65
D | [NAME] | L | 3 | 220 | 45 | 45 | 35 | 65 | 35 | 65 | 45 | 25 | 65 | 65 | 35 | 65
D | [NAME] | L | 27 | 212 | 55 | 55 | 55 | 55 | 55 | 55 | 55 | 45 | 55 | 35 | 55 | 45
D | [NAME] | L | 6 | 196 | 55 | 45 | 45 | 55 | 45 | 45 | 55 | 25 | 55 | 55 | 45 | 45
D | [NAME] | L | 5 | 196 | 35 | 35 | 25 | 35 | 35 | 35 | 35 | 25 | 35 | 55 | 25 | 55
D | [NAME] | R | 34 | 212 | 45 | 45 | 35 | 45 | 45 | 55 | 45 | 35 | 45 | 55 | 35 | 55