tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 36699d1234552419-using-list-function-with-hiding-irrelevant-outputs-monthly-models-3
Sheet: VOLUMES 

Entire 2008 |  |  | 0.01
Source | A |  | B | C | Total
COMPANY 2 | 8899 | 0 | 60.77 | 3813 | 12772.77
COMPANY 2 - Total | 8899 | 0 | 60.77 | 3813 | 12772.77
2008-01-01 00:00:00
COMPANY 2 | 530 |  | 4.69 | 321 | 855.69
COMPANY 2 - Total | 530 | 0 | 4.69 | 321 | 855.69
2008-02-01 00:00:00
COMPANY 2 | 390 |  | 3.16 | 207 | 600.1600000000001
COMPANY 2 - Total | 390 | 0 | 3.16 | 207 | 600.1600000000001
2008-03-01 00:00:00
COMPANY 2 | 465 |  | 2.62 | 171 | 638.62
COMPANY 2 - Total | 465 | 0 | 2.62 | 171 | 638.62
2008-04-01 00:00:00
COMPANY 2 | 944 |  | 4.51 | 199 | 1147.51
COMPANY 2 - Total | 944 | 0 | 4.51 | 199 | 1147.51
2008-05-01 00:00:00
COMPANY 2 | 1028 |  | 7.09 | 304 | 1339.09
COMPANY 2 - Total | 1028 | 0 | 7.09 | 304 | 1339.09
2008-06-01 00:00:00
COMPANY 2 | 944 |  | 8.34 | 249 | 1201.34
COMPANY 2 - Total | 944 | 0 | 8.34 | 249 | 1201.34
2008-07-01 00:00:00
COMPANY 2 | 1005 |  | 6.59 | 226 | 1237.59
COMPANY 2 - Total | 1005 | 0 | 6.59 | 226 | 1237.59
2008-08-01 00:00:00
COMPANY 2 | 860 |  | 5.75 | 197 | 1062.75
COMPANY 2 - Total | 860 | 0 | 5.75 | 197 | 1062.75
2008-09-01 00:00:00
COMPANY 2 | 769 |  | 5.93 | 619 | 1393.93
COMPANY 2 - Total | 769 | 0 | 5.93 | 619 | 1393.93
2008-10-01 00:00:00
COMPANY 2 | 847 |  | 4.26 | 369 | 1220.26
COMPANY 2 - Total | 847 | 0 | 4.26 | 369 | 1220.26
2008-11-01 00:00:00
COMPANY 2 | 606 |  | 3.75 | 472 | 1081.75
COMPANY 2 - Total | 606 | 0 | 3.75 | 472 | 1081.75
2008-12-01 00:00:00
COMPANY 2 | 511 |  | 4.08 | 479 | 994.08
COMPANY 2 - Total | 511 | 0 | 4.08 | 479 | 994.08
Spreadsheet: 703375d1604958811-separating-text-and-numbers-paragon-excel
Sheet: Sheet1

 | 41000-00 Association Fees |  | 41000-00 |  | Association Fees
 | 41001-00 Special Assessment |  | 41001-00 |  | Special Assessment
 | 41006-00 Utility Reimbursement |  | 41006-00 |  | Utility Reimbursement
 | 41007-00 Rental - Guest Suite |  | 41007-00 |  | Rental - Guest Suite
 | 41010-10 [NAME] |  | 41010-10 |  | [NAME]
 | 41100-00 Late Fees |  | 41100-00 |  | Late Fees
 | 41210-00 Insurance - Reimb RTA |  | 41210-00 |  | Insurance - Reimb RTA
 | 41220-00 Gate Access Key/Fobs |  | 41220-00 |  | Gate Access Key/Fobs
 | 41300-00 Miscellaneous Income |  | 41300-00 |  | Miscellaneous In come
 | 41310-00 Administrative Fee |  | 41310-00 |  | Administrative Fee
 | 42002-00 Misc. Extraordinary Income |  | 42002-00 |  | [NAME]. Extraordinary Income
Spreadsheet: 867055d1713958138-formulae-to-copy-data-between-sheets-with-only-a-certan-value-rams-sample-aligw
Sheet: Method Statement

Highlighted Hazards:
1
2
3
4
5
6
7
8
9
10
Controls Required per Hazard listed above:
1
2
3
4
5
6
7
8
9
10
Spreadsheet: 1587c510-1ca7-40d1-9855-6450bcf154a4
Sheet: Sheet1

Library web server <http://www.library.uri.edu/> | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13
Statistics
1996-1997
DIRECTORY | 1996-07-01 00:00:00 | 1996-08-01 00:00:00 | 1996-09-01 00:00:00 | 1996-10-01 00:00:00 | 1996-11-01 00:00:00 | 1996-12-01 00:00:00 | 1997-01-01 00:00:00 | 1997-02-01 00:00:00 | 1997-03-01 00:00:00 | 1997-04-01 00:00:00 | 1997-05-01 00:00:00 | 1997-06-01 00:00:00 | ANNUAL TOTAL
Total requests* |  |  |  |  |  |  |  |  |  |  | 31486 | 35074
Total page requests*
Total visits*
Total visitors*
Average time per visit (seconds)
Busiest day of week |  |  |  |  |  |  |  |  |  |  | [NAME] | Mon
Peak hours |  |  |  |  |  |  |  |  |  |  | 9am-4pm | 11am-4pm
Average response delay
Most popular URL |  |  |  |  |  |  |  |  |  |  | Home_Page.html | Home_Page.html
Second most popular URL |  |  |  |  |  |  |  |  |  |  | db.html | db.html
Third most popular URL |  |  |  |  |  |  |  |  |  |  | LiveCams.html | LiveCams.html
*May only covers 5/16/1997-5/30/1997
Spreadsheet: 887936d1738250521-rotating-schedule-advice-line-assignment
Sheet: March 4- April 28 2024

Line # | PRI | LINE ASSIGNEMENT | SENIORITY
1 | 74470434 | [NAME] | 24
2 | 23744138 | [NAME] SUPT | 49
3 | 17694647 | [NAME] | 9
4 |  | [NAME] | 31
5 | 72583983 | [NAME] | 22A
6 | 96710802 | [NAME] | 45
7 | 14055201 | TERRY TEAL | 1
8 | 80764576 | Sacha Provencher | 12A
9 | 38296314 | Real Picard | 13
10 | 96994835 | [NAME] | 21
11 | 39606759 | Robyn Hronyak | 22D
12 | 48632201 | [NAME] | 15
13 | 53572114 | [NAME] | 39B
14 | 22473521 | [NAME] | 53
15 |  | [NAME] | 22C
16 | 70483566 | [NAME] | 52
17 | 22025448 | [NAME] | 17
18 | 69212074 | [NAME] | 36B
19 | 62359622 | [NAME] | 38A
20 | 99717662 | [NAME] | 8
21 | 57182604 | [NAME] | 10
22 | 48910368 | [NAME] Roy | 56
23 | 24252204 | [NAME] | 46B
24 | 17642418 | [NAME] | 27
25 | 50473190 | [NAME] | 37
26 | 60559721 | [NAME] | 34
27 |  | [NAME] Dodd- Ass Carm | 36C
28 | 23877944 | [NAME] | 11
29 | 26290499 | [NAME] | 20
30 |  | Ryan Willick- CEU | 28B | Borrayo
31 | 54010810 | Eva Zajac | 23
32 |  | Jason Glumac- HCVM | 18
33 |  | [NAME] Harris- A/ Supt Traffic | 7
34 | 56735057 | [NAME] | 29
35 | 97028126 | [NAME] | 22B
36 | 46545786 | [NAME] | 30
37 | 39537714 | [NAME] | 25
38 | 38704552 | [NAME] | 36A
39 | 54174449 | [NAME] | 14
40 | 80229522 | Jusitn Hall | 28A
41 | 24564591 | [NAME] | 3
42 | 11404574 | [NAME] | 43
43 | 61474940 | GERRY GAGNON | 2
44 |  | [NAME] | 16
45 | 19680880 | [NAME] | 38C
46 | 30337526 | [NAME] | 33
47 | 13820311 | [NAME] | 5
48 | 59711582 | [NAME] | 32 | [NAME]
49 |  | [NAME] Amos- CEU | 42
50 |  | Emilio Mollo- CEU | 50B
51 | 93909454 | [NAME] | 19
52 | 97873233 | [NAME] | 38B
53 | 37015923 | [NAME] | 39A
54 | 95806474 | [NAME] | 47
55 | 88663760 | [NAME] | 55
56 | 60855495 | [NAME] | 41
57 |  | [NAME] HCVM | 50A
58 | 55107613 | [NAME] | 54
59 | 14440237 | [NAME] | 35
60 | 94685045 | [NAME] | 46A
61
62
63 | 86407643 | [NAME]
64 | 27328198 | [NAME]
65 | P/T
66 | 92699685 | [NAME]
67
68 | 81680244 | [NAME]
69 |  | [NAME] | 4
70
71 | 70600287 | [NAME] | 44
72 |  | [NAME]
73
74 | 12731471 | [NAME] | 40
75 | 49413503 | [NAME] | 12B
76 | 31395554 | [NAME] | 48
Spreadsheet: 75291d1275887086-identifying-data-within-data-borroughs
Sheet: Sheet1

Employee ID | Office number | Borough
 |  | The first letter of each school number indicates the borough that the office is in.  Determine which borrough each office is located in. (X: Bronx, M: Manhattan, Q: Queens, R: Staten Island, K: Brooklyn) |  |  |  |  | Code | Borrough
111213 | M497 |  |  |  |  |  | X | Bronx
111910 | K195 |  |  |  |  |  | M | Manhattan
112310 | X525 |  |  |  |  |  | Q | Queens
112410 | Q496 |  |  |  |  |  | R | Staten Island
113610 | X430 |  |  |  |  |  | K | Brooklyn
115210 | K012
115315 | Q217
116510 | K361
117110 | X184
117610 | K440
117910 | M164
119110 | Q090
Spreadsheet: 107942d1305064629-count-cells-with-same-color-and-value-sample
Sheet: Sheet1

Class |  |  | 28
Fixed |  | Fixed | 28
I&E |  | I&E | 28
I&E |  | ELECT | 28
I&E |  | Rotating | 28
Fixed
Fixed
Fixed
Fixed
Fixed
Fixed
Rotating
Rotating
Rotating
Rotating
ELECT
ELECT
ELECT
ELECT
ELECT
ELECT
Fixed
Fixed
Fixed
Fixed
Fixed
Fixed
Fixed
Rotating
Rotating
Rotating
Rotating
Rotating
Rotating
Rotating
Rotating
Fixed
ELECT
ELECT
ELECT
ELECT
ELECT
ELECT
ELECT
I&E
I&E
I&E
I&E
I&E
I&E
I&E
I&E
I&E
I&E
I&E
I&E
I&E
I&E
I&E
I&E
I&E
I&E
I&E
I&E
I&E
I&E
I&E
I&E
I&E
I&E
I&E
I&E
I&E
I&E
I&E
I&E
I&E
I&E
I&E
I&E
I&E
I&E
I&E
I&E
I&E
I&E
I&E
I&E
I&E
I&E
I&E
I&E
I&E
I&E
I&E
I&E
I&E
I&E
I&E
I&E
I&E
I&E
I&E
I&E
I&E
I&E
I&E
I&E
I&E
I&E
I&E
I&E
I&E
I&E
I&E
I&E
I&E
I&E
I&E
I&E
Fixed
Fixed
Fixed
Fixed
Fixed
Fixed
Fixed
Fixed
Fixed
Fixed
Fixed
Fixed
Fixed
Fixed
Fixed
Fixed
Fixed
Fixed
Fixed
Fixed
Fixed
Fixed
Fixed
Fixed
Fixed
Fixed
Fixed
Fixed
Fixed
Fixed
Fixed
Fixed
Fixed
Fixed
Fixed
Fixed
Fixed
Fixed
Fixed
Fixed
Fixed
Fixed
Fixed
Fixed
Fixed
Fixed
Fixed
Fixed
Fixed
Fixed
Fixed
Fixed
Fixed
Fixed
Fixed
Fixed
Fixed
Fixed
Fixed
Fixed
Fixed
Fixed
Fixed
Fixed
Fixed
Fixed
Fixed
Fixed
Fixed
Fixed
Fixed
Fixed
Fixed
Fixed
Fixed
Fixed
Fixed
Fixed
Fixed
Fixed
Fixed
Fixed
Fixed
Fixed
Fixed
Fixed
Fixed
Fixed
Fixed
Fixed
Spreadsheet: 873515d1720012066-how-to-extract-the-number-of-working-hours-for-all-employees-and-extract-the-start-and-end-office-2003-time-33-aligw
Sheet: ورقة1

Name | Date | Time
[NAME] | 01/07/2024 | 21:57:21 |  |  | Name | 01/07/2024
Name1 | 01/07/2024 | 21:54:15 |  |  |  | Start Time | End Time | Total Work
Name1 | 01/07/2024 | 21:46:02 |  |  | Name1
Name1 | 01/07/2024 | 21:44:02 |  |  | [NAME]
[NAME] | 01/07/2024 | 21:43:45
Name1 | 01/07/2024 | 21:43:36
[NAME] | 01/07/2024 | 21:41:46
Name1 | 01/07/2024 | 21:41:41
Name1 | 01/07/2024 | 21:40:18
Spreadsheet: 02d81e9d-93b2-4e71-899f-8db1b5e25959
Sheet: Credit Recovery & AP

Credit Recovery-Supplemental | 9 | 10 | 11 | 12 | Total
Yearly registrations | 0 | 0 | 0 | 0
Yearly completionss | 0 | 0 | 0 | 0
Total
Advanced Placement | 9 | 10 | 11 | 12 | Total
Course Registrations | 0 | 0 | 0 | 0
Course Completions | 0 | 0 | 0 | 0
AP Exams Completed | 0 | 0 | 0 | 0
AP Exams Scores >3 | 0 | 0 | 0 | 0
End of Credit Recovery and AP worksheet 4 of 4.
Spreadsheet: 477619d1472412477-how-to-highlight-multiple-cells-based-off-a-value-fantasy-football
Sheet: K

RK | Player | Pos | Team | Bye
1 | [NAME] | K | NE | 9
2 | [NAME] | K | NYG | 8
3 | [NAME] | K | IND | 10
4 | [NAME] | K | ARZ | 9
5 | [NAME] | K | CAR | 7
6 | [NAME] | K | BAL | 8
7 | [NAME] | K | DAL | 7
8 | [NAME] | K | GB | 4
9 | [NAME] | K | PIT | 8
10 | [NAME] | K | SEA | 5
11 | D. Hopkins | K | WAS | 9
12 | [NAME] | K | MIN | 6
13 | [NAME] | K | SD | 11
14 | [NAME] | K | NO | 5
15 | M. Prater | K | DET | 10
16 | [NAME] | K | CIN | 9
17 | [NAME] | K | KC | 5
18 | [NAME] | K | TB | 6
19 | [NAME] | K | BUF | 10
20 | [NAME] | K | ATL | 11
21 | [NAME] | K | NYJ | 11
22 | [NAME] | K | DEN | 11
23 | [NAME] | K | MIA | 8
24 | [NAME] | K | JAC | 5
25 | [NAME] | K | OAK | 10
26 | [NAME] | K | CHI | 9
27 | [NAME] | K | LAR | 8
28 | [NAME] | K | PHI | 4
29 | [NAME] | K | HOU | 9
30 | [NAME] | K | SF | 8
31 | T. Coons | K | CLE | 13
32 | [NAME] | K | TEN | 13
Spreadsheet: 8b71153e-e8f0-4721-9ea6-bbf9505e2765
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
6478 | 8033 | Arnott | [NAME] | GBR | 262 | 00:53:49 | 00:02:10 | 01:38:23 | 00:02:04 | 00:23:55 | 1 | 03:00:25
6478 | 44567 | [NAME] | Young | GBR | 261 | 01:03:29 | 00:02:23 | 01:24:48 | 00:03:11 | 00:28:46 | 2 | 03:02:40
Spreadsheet: 169204d1342725553-excel-2007-rearranging-data-set-fish_excel
Sheet: File Info

WA25_Monthly Landings_12-30-11.xls
 | Date Last Modified: | 2011-12-30 00:00:00
 | By: | [NAME], Abt Associates Inc.
 | Data Sources: | Commercial fisheries landings data, by species, month, year and region (NOAA National Marine Fisheries Service, http://www.st.nmfs.noaa.gov/st1/commercial/landings/gear_landings.html). Data range: Jan 1990 - Dec 2010.
 | Description: | Commercial, non-confidential landings of fish and shellfish species important to [NAME], as landed in New England, the Mid-Atlantic, [NAME], the South Atlantic, and Gulf of Mexico.
 | Purpose: | Provide NCEE with data requested under WA-25, Task 4 (commercial fish demand modeling).
 | Worksheet | Description
 | croaker | Lists landings for Atlantic croaker.
 | menhaden | Lists landings for Atlantic menhaden.
 | bsb | Lists landings for black sea bass.
 | bluefish | Lists landings for bluefish.
 | bcrab | Lists landings for blue crab. Data have been merged across 'blue crab' [unspecified type], 'blue crab- soft,' 'blue crab- peeler' and 'blue crab- soft and peeler' per instructions on http://www.st.nmfs.noaa.gov/st1/commercial/landings/caveat.html
 | quahog | Lists landings for northern quahog.
 | oyster | Lists landings for eastern oyster.
 | sbass | Lists landings for striped bass.
 | sflounder | Lists landings for summer flounder.
 | spot | Lists landings for spot.
 | tautog | Lists landings for tautog.
 | perch | Lists landings for white perch.
 | eel | Lists landings for American eel.
 | catfish | Lists landings for catfishes and bullheads.
Spreadsheet: 92050d1291728088-need-to-divide-hours-evenly-between-multiple-fields-to-maintain-averages-solver_production_test2
Sheet: Test 1

Test 1
PRODUCT | Custom Built | Hours | CBPH |  | AVERAGE | keep as close as possible
Sedans & Coupes | 3.2 | 1 | 3.2 |  | 3.3
Sedans & Coupes & Assistance | 3.2 | 1 | 3.2 |  | 2.6
Sedans | 3.2 | 1 | 3.2 |  | 3.2
Cycle | 0 | 0 | 0 |  | 10
Coupes | 0 | 0 | 0 |  | 3.5
Assistance | N/A | 0 | 0 |  | 0.18
 | TOTAL HOURS | 1
 | Target total hrs | 6.5
Don't forget to update target value in Solver.
I've added a starting value in C5
Spreadsheet: 126512d1319727806-excel-2007-question-about-geometric-means-for-annualized-returns-geomean-sample-data
Sheet: Sheet1

 |  |  |  | Geometric Mean
 |  |  |  | Manual Calculation | Excel [NAME]
Original Set | 0.25 | -0.25 | 0.25
+1
+100
+.[PHONE]
Questions to Answer:
Which one is the real annualized return?
Why?
If none of the above is correct, then how would I find the correct answer?
Spreadsheet: 139503d1328279044-excel-2007-countif-problem-2011-stats
Sheet: SIN

Pos | Driver | Team | Nation | Points | Laps | [NAME] | Grid | Gained | Classification | Race Distance | Qualifying Time
1 | [NAME] |  |  | 25 | 61 | 00:01:48.688000 | 1 |  | 1 |  | 00:01:44.381000
2 | [NAME] |  |  | 18 | 61 | 00:01:48.454000 | 3 |  | 2 |  | 00:01:44.804000
3 | [NAME] |  |  | 15 | 61 | 00:01:50.088000 | 2 |  | 3 |  | 00:01:44.732000
4 | [NAME] |  |  | 12 | 61 | 00:01:50.891000 | 5 |  | 4 |  | 00:01:44.874000
5 | [NAME] |  |  | 10 | 61 | 00:01:50.832000 | 4 |  | 5 |  | 00:01:44.809000
6 | [NAME] |  |  | 8 | 61 | 00:01:54.239000 | 10 |  | 6 |  | 00:01:47.486000
7 | [NAME] |  |  | 6 | 60 | 00:01:54.383000 | 7 |  | 7 |  | 00:01:46.013000
8 | [NAME] |  |  | 4 | 60 | 00:01:54.564000 | 9 |  | 8 |  | 00:01:47.093000
9 | [NAME] |  |  | 2 | 60 | 00:01:52.550000 | 6 |  | 9 |  | 00:01:45.800000
10 | [NAME] |  |  | 1 | 60 | 00:01:54.615000 | 11 |  | 10 |  | 00:01:47.616000
11 | Pastor Maldonado |  |  | 0 | 60 | 00:01:53.198000 | 13 |  | 11 |  | 00:01:48.270000
12 | Sebastien Buemi |  |  | 0 | 60 | 00:01:52.197000 | 14 |  | 12 |  | 00:01:48.634000
13 | [NAME] |  |  | 0 | 60 | 00:01:55.235000 | 12 |  | 13 |  | 00:01:48.082000
14 | [NAME] |  |  | 0 | 59 | 00:01:51.329000 | 17 |  | 14 |  | 00:01:48.054000
15 | [NAME] |  |  | 0 | 59 | 00:01:53.774000 | 15 |  | 15 |  | 00:01:48.662000
16 | [NAME] |  |  | 0 | 59 | 00:01:54.063000 | 19 |  | 16 |  | 00:01:50.948000
17 | [NAME] |  |  | 0 | 59 | 00:01:54.204000 | 18 |  | 17 |  | 00:01:49.835000
18 | [NAME] |  |  | 0 | 59 | 00:01:58.730000 | 22 |  | 18 |  | 00:01:52.363000
19 | [NAME] |  |  | 0 | 57 | 00:01:59.064000 | 23 |  | 19 |  | 00:01:52.404000
20 | [NAME] |  |  | 0 | 57 | 00:01:58.283000 | 24 |  | 20 |  | 00:01:52.810000
21 | [NAME] |  |  | 0 | 56 | 00:01:53.676000 | 16 |  | 21 |  | 00:01:49.862000
22 | Jarno [NAME] |  |  | - | 47 | 00:01:57.126000 | 20 |  | RET |  | 00:01:51.012000
23 | [NAME] |  |  | - | 28 | 00:01:53.096000 | 8 |  | RET |  | 00:01:46.043000
24 | [NAME] |  |  | - | 9 | 00:02:00.412000 | 21 |  | RET |  | 00:01:52.154000
Spreadsheet: 785046d1656095958-importing-data-from-one-tab-into-another-test-data
Sheet: Sheet2

AJ011100 | 124 bent street | 4521.12 | 15101
AJ011101 | 15 hell street | 999.25 | 15102
AJ011102 | 19 bell street | 145.25 | 15103
AJ011103 | 8 banana avenue | 1245.02 | 15104
AJ011104 | 8 great hill | 125.36 | 15105
AJ011105 | 96 hump hill | 178.36 | 15106
AJ011106 | 14 hastle drive | 542.36 | 15107
AJ011107 | 6 millers way | 2.36 | 15108
Spreadsheet: 151258d1334843903-index-and-match-formulas-workbook2
Sheet: Sheet2

AMT | POSTDATE | POSTDATE | POSTDATE | POSTDATE
 | 2012-01-01 00:00:00 | 2012-02-01 00:00:00 | 2012-03-01 00:00:00 | 2012-04-01 00:00:00
PNAME1 | January | February | March | April
Product1
Product2
Product3
Product4
Product5
Product6
Product7
Product8
Product9
Product10
Product11
Product12
Product13
Spreadsheet: brad_mckay__1422__Wk 15 Results 
Sheet: Sheet1

Teams |  | Team #1 | Pts. | TM |  | Team #2 | Pts. | TM |  | Team #3 | Pts. | TM |  | Team #4 | Pts. | TM
 |  | Mills/Brad |  |  |  | Greer |  |  |  | Les/John |  |  |  | [NAME]
QB's |  | [NAME] |  | TB | X | K. Warner | 6 | STL | X | [NAME] | 4 | TB | X | Manning | 0 | Indy
 | X | [NAME] | 8 | NYG |  | Batch |  | [NAME] |  | T. Green |  | STL |  | [NAME] |  | Jets
Rec | X | [NAME] | 0 | Wash | X | [NAME] | 1 | Minn |  | Small |  | [NAME] | X | [NAME] | 1 | GB
 |  | [NAME] |  | NYG | X | [NAME] | 7 | [NAME] | X | McCaffery | 4 | Den | X | [NAME] | 1 | Oak
 | X | [NAME] | 7 | SF |  | [NAME] |  | Sea | X | [NAME] | 1 | [NAME] |  | [NAME] |  | Jets
 |  | [NAME] |  | NYG | X | [NAME] | 0 | Indy | X | [NAME] | 2 | KC | X | [NAME] | 0 | SF
 | X | [NAME] | 0 | SD |  | [NAME] |  | [NAME] |  | [NAME] |  | Sea |  | [NAME] |  | Atl
RB's | X | [NAME] | 7 | Indy |  | [NAME] |  | TB |  | [NAME] |  | Den |  | [NAME] |  | Atl
 | X | K. Anders | 0 | KC | X | Holcombe | 0 | STL | X | [NAME] | 0 | SF | X | [NAME] | 2 | Oak
 |  | [NAME] |  | KC | X | [NAME] | 0 | Sea |  | [NAME] |  | [NAME] | X | M. Pittman | 0 | Ariz
 |  | Watson |  | STL |  | [NAME] |  | Oak | X | [NAME] | 2 | NYG |  | Huntley |  | Pit
Rookies |  | [NAME] |  | GB | X | [NAME] | 0 | NO |  | T. Jones |  | Ariz | X | [NAME] | 2 | [NAME]
 | X | Lindell | 1.25 | Sea |  | Coles |  | Clev | X | [NAME] | 2 | Sea |  | S. Morris |  | KC
Kickers |  | [NAME] |  | Wash |  | [NAME] |  | KC | X | [NAME] | 8.25 | [NAME] | X | [NAME] | 1.75 | [NAME]
 | X | [NAME] | 0.75 | Minn | X | Nedney | 0.5 | Car |  | [NAME] |  | Pitt |  | [NAME] |  | Atl
Defense | X | St. Louis |  |  | X | Tennessee | 0 |  | X | Washington | 0 |  | X | Baltimore | 2
 |  | Buffalo | 0 |  |  | Arizona |  |  |  | New England |  |  |  | Oakland
week total
golden toe |  |  |  |  |  |  |  |  |  |  | 3
 |  |  | 0 |  |  |  | 0 |  |  |  | 0 |  |  |  | 0
Spreadsheet: 275831d1383660066-complex-excel-formula-required-for-obtaining-values-based-on-column-and-row-example-data
Sheet: Sheet1

Shift | 1 | 2 | 3 | 4 | 5 | 6 | 7
SF1 | Name1 | [NAME] | [NAME] |  |  | Name4 | Name4
SF2 | Name3 | Name1 | Name4 |  |  |  | [NAME]
SF3 | [NAME] | Name3 |  | Name3 | [NAME] | [NAME]
SF4 | Name4 | Name4 | Name3 | Name1 | [NAME] | Name3 | Name4
Shift | 1 | 2 | 3 | 4 | 5 | 6 | 7
[NAME] | SF3 | SF1 | SF1 |  | SF3, SF1 | SF3 | SF2
Name1 | SF1 | SF2
Name3 | SF2 | SF3 | SF1 | SF3 |  | SF1
Name4 | SF1 | SF1 | SF2 | SF1 |  | SF1 | SF1, SF4
Spreadsheet: 714169d1611128939-sumproduct-iferror-help-needed-forumhelp
Sheet: ENTRY

NUMBER | serial | ext | OUTPUT_survey | totalext | crop | cropext | cultivator | Column1
721468155261
968047478678
558862288012
597882830394
399900960516
394588931704
214880810005
840352530148
827853029063
363276262465
472116109840
888443886880
483278995489
458020255975
385291345637
507145249800
994588620209
897818448887
350910187470
635340796248
342276210202
709310903391
274726168458
989685953421
507468221728
698122155915
404673635421
576977801502
416252875853
201328094894
881700929090
940465231889
780600840974
420476284557
740252787736
573639020337
573275752520
607424311888
763383563525
987906951019
655773911445
732333003115
963258385708
494728102774
505632342203
245755630955
603386751964
810829261815
703539890657
561598098569
619313011545
693578007959
430570964109
679224591379
325610712737
630928545676
937167810080
371226046753
740222514316
611912683888
885243644294
554777273528
552529500854
959632508807
358499405281
256242713615
955858359065
826706848246
625546448059
315815792660
893378791115
823757444311
447249375852
707814348159
590016634753
594044027725
893336946397
822769047145
203048866149
716800274959
545440484267
477644154278
402418208184
556515541498
766456060526
318109223507
633884781867
501173918273
587779773640
352912009909
955463425027
652885776075
573027861381
610655245644
735700984298
370464426681
237636028359
762818705508
643573434719
964631323046
990727020614
679478590938
968167010499
868241651090
654384006450
734739314878
776890526946
867959747088
468727892883
912543297977
402930281417
622686104331
623914051773
451036809220
920201997069
908428507962
850821400940
252889501962
386797707260
375779898935
861541642277
495205971521
605315820358
279071201872
899807296688
824415066093
644546513242
829412958589
701862963251
317390933614
688282937240
891008501313
425358764814
383500920069
707848393916
878736280278
451828146705
688170502234
481347258638
866521427291
544817108103
424871238953
758601256055
535286845884
611729210757
516519797999
633625335557
772245648352
409207086978
564033834134
837607689065
782226321970
607915727072
908921340810
315609231337
519701877407
604498111914
381807369641
556595317945
289141454821
675361867392
960670905959
541398733094
986135748691
586285919483
362968736694
768964097182
436443767411
721297532815
904704913240
692959113936
723061128124
349042051324
987294550265
416346574784
643433756681
476790809364
259853454017
317550675147
713722500483
963483740465
257211302149
627068500504
418064932515
330934732470
Spreadsheet: 55639d1255728373-pivot-tables-help-on-pivot-tables
Sheet: Sheet4

Count of ID de demande | Type | Installation week planned
 | INSTALL |  |  | INSTALL Total | PROGRAM | PROGRAM Total | Grand Total
Execution week | Semaine du 21 Septembre 2009 | Semaine du 28 Septembre 2009 | Semaine du 5 Octobre 2009 |  | Semaine du 21 Septembre 2009
Semaine du 21 Septembre 2009 | 6 |  |  | 6 |  |  | 6
Semaine du 28 Septembre 2009 | 18 | 1 |  | 19 |  |  | 19
Semaine du 5 Octobre 2009 | 16 |  |  | 16 |  |  | 16
#N/A | 14 | 28 | 4 | 46 | 16 | 16 | 62
Grand Total | 54 | 29 | 4 | 87 | 16 | 16 | 103
Spreadsheet: darrell_schoolcraft__7814__Southpoint Gas Model
Sheet: Sheet1

Southpoint |  |  | Transwestern's 24 hr Gas Control [PHONE]
 |  |  | Gas Nomination for 1st = 65000
 |  |  | SoCal Gas Price |  | 2.325
 |  |  | San Juan Gas Price |  | 2.045
 |  |  | Unit 1 | Unit 2 | Steam TurB | Total MW | HR | Total Gas Usage
he 6 | 07:00:00 |  | 0 | 0 | 0 | 233 | 7
he 7 | 08:00:00 |  | 0 | 0 | 0 | 485 | 7
he8 | 09:00:00 |  | 0 | 0 | 0 | 485 | 7
he9 | 10:00:00 |  | 0 | 0 | 0 | 485 | 7
he10 | 11:00:00 |  | 0 | 0 | 0 | 485 | 7
he11 | 12:00:00 |  | 0 | 0 | 0 | 485 | 7
he12 | 13:00:00 |  | 0 | 0 | 0 | 485 | 7
[NAME] | 14:00:00 |  | 0 | 0 | 0 | 485 | 7
he14 | 15:00:00 |  | 0 | 0 | 0 | 485 | 7
he15 | 16:00:00 |  | 0 | 0 | 0 | 485 | 7
he16 | 17:00:00 |  | 0 | 0 | 0 | 485 | 7
he17 | 18:00:00 |  | 0 | 0 | 0 | 485 | 7
he18 | 19:00:00 |  | 0 | 0 | 0 | 485 | 7
he19 | 20:00:00 |  | 0 | 0 | 0 | 485 | 7
he20 | 21:00:00 |  | 0 | 0 | 0 | 485 | 7
he21 | 22:00:00 |  | 0 | 0 | 0 | 485 | 7
he22 | 00:00:00 |  | 0 | 0 | 0 | 485 | 7
he23 | 01:00:00 |  | 0 | 0 | 0 | 233 | 7
he24 | 02:00:00 |  | 0 | 0 | 0 | 233 | 7
he1 | 03:00:00 |  | 0 | 0 | 0 | 233 | 7
he2 | 04:00:00 |  | 0 | 0 | 0 | 233 | 7
he3 | 05:00:00 |  | 0 | 0 | 0 | 233 | 7
he4 | 06:00:00 |  | 0 | 0 | 0 | 233 | 7
[NAME] | 07:00:00 |  | 0 | 0 | 0 | 233 | 7