tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 151917d1335186199-how-do-you-count-coloured-cells-in-a-selected-field-of-cells-deliveries-2012
Sheet: Annual

 | Timesheet
 |  |  |  |  |  |  |  |  | [NAME]
Clock No. | Name | Mon | Tue | Wed | Thu | Fri | Sat | Sun | x1 | x1.5 | x2 | Total Hrs | Name | Wages | Overtime | Total
12 | W Mcfadyen | 8 | 8 | 8 | 8 | 7 |  |  | 39 | 0 | 0 | 39 | W Mcfadyen | 256.23 | 0 | 256.23
30 | M Ivatt | 8 | 8 | 8 | 8 | 7 |  |  | 39 | 0 | 0 | 39 | M Ivatt | 370.5 | 0 | 370.5
34 | D Brown | 8 | 8 | 8 | 8 | 7 |  |  | 39 | 0 | 0 | 39 | D Brown | 256.23 | 0 | 256.23
39 | S [NAME] | 8 | 8 | 8 | 8 | 7 |  |  | 39 | 0 | 0 | 39 | S [NAME] | 256.23 | 0 | 256.23
51 | G Brown | 8 | 8 | 8 | 8 | 7 |  |  | 39 | 0 | 0 | 39 | G Brown | 256.23 | 0 | 256.23
56 | B Davidson | 8 | 8 | 8 | 8 | 7 |  |  | 39 | 0 | 0 | 39 | B Davidson | 256.23 | 0 | 256.23
64 | J Bruce | 8 | 8 | 8 | 8 | 7 |  |  | 39 | 0 | 0 | 39 | J Bruce | 370.5 | 0 | 370.5
77 | J.Aitchison | 8 | 8 | 8 | 8 | 7 |  |  | 39 | 0 | 0 | 39 | J.Aitchison | 331.0008 | 0 | 331.0008
88 | S Lavery | 4 | 4 | 4 | 4 | 4 |  |  | 20 | 0 | 0 | 20 | S Lavery | 131.4 | 0 | 131.4
91 | S Graham | 8 | 8 | 8 | 8 | 7 |  |  | 39 | 0 | 0 | 39 | S Graham | 256.23 | 0 | 256.23
108 | J Dunnachie | 8 | 8 | 8 | 8 | 7 |  |  | 39 | 0 | 0 | 39 | J Dunnachie | 256.23 | 0 | 256.23
112 | J Fleming | 8 | 8 | 8 | 8 | 7 |  |  | 39 | 0 | 0 | 39 | J Fleming | 256.23 | 0 | 256.23
115 | C Devine | 8 | 8 | 8 | 8 | 7 |  |  | 39 | 0 | 0 | 39 | C Devine | 256.23 | 0 | 256.23
118 | C Devine Jnr | 8 | 8 | 8 | 8 | 7 |  |  | 39 | 0 | 0 | 39 | C Devine Jnr | 256.23 | 0 | 256.23
119 | W McCormack | 8 | 8 | 8 | 8 | 7 |  |  | 39 | 0 | 0 | 39 | W McCormack | 256.23 | 0 | 256.23
120 | G Divine | 8 | 8 | 8 | 8 | 7 |  |  | 39 | 0 | 0 | 39 | G Divine | 256.23 | 0 | 256.23
121 | K Hamill | 8 | 8 | 8 | 8 | 7 |  |  | 39 | 0 | 0 | 39 | K Hamill | 256.23 | 0 | 256.23
122 | G Beatie | 8 | 8 | 8 | 8 | 7 |  |  | 39 | 0 | 0 | 39 | G Beatie | 256.23 | 0 | 256.23
 | [NAME] | 1.2 | 1.2 | 1.2 | 1.2 | 1.2 |  |  | 6 | 0 |  | 6 |  | 39.42
 |  |  |  |  |  |  |  | Totals | 689 | 0 | 0 | 689 |  | 4278.1608 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Plus N.I | 4278.1608
Spreadsheet: 25549d1216910747-how-can-i-make-a-chart-to-display-entered-data-in-a-field-examplehelp
Sheet: Sheet1

 | Apples | Oranges | Bananas | Pears
January | 2 | 3 | 5 | 1
February | 3 | 3 | 4 | 2
March | 4 | 3 | 6 | 3
April | 5 | 3 | 2 | 2
May | 6 | 3 | 4 | 1
June | 7 | 3 | 3 | 1
July | 8 | 3 | 5 | 2
August | 9 | 3 | 4 | 3
September | 10 | 3 | 6 | 2
October | 11 | 3 | 2 | 1
November | 12 | 3 | 4 | 2
December | 13 | 3 | 3 | 4
Spreadsheet: 72683d1273397298-how-to-shift-down-31-rows-everytime-i-copy-a-cell-testing1
Sheet: Sub Comment

Comments | 1
 |  |  | Filled down to row 2000
Hello | 3
Hi There | 5
How are you doing? | 7
Comments two | 1314
Hello two | 1316
Hi There two | 1318
How are you doing? two | 1320
Comments three | 1990
Hello three | 1992
Hi There three | 1994
How are you doing? Three | 1996
Spreadsheet: 474415d1470752464-xlsx-to-xls-calendar-template-book
Sheet: Homework List

 | TO HOMEWORK CALENDAR >>
 | HOMEWORK LIST
 | Date Due | Class | Assignment | Calendar Entry | Day | Month
 | 2016-08-01 00:00:00 | MAT1 | Pages 34-67 |  |  |  |  | TIPS:
 | 2016-08-05 00:00:00 | HIST2 | Worksheet 43 |  |  |  |  | Assignments entered on this sheet are automatically added to the Homework Calendar. The [NAME] number of  assignments shown on the calendar for each day is four. You can also use the filter buttons in the table to the left of these tips to display your homework list for a specific due date, class, or both.
 | 2016-08-08 00:00:00 | CHEM | Lab Results
 | 2016-08-09 00:00:00 | PSY2 | Study for test
 | 2016-08-10 00:00:00 | LIT2 | Outline Essay
 | 2016-08-12 00:00:00 | MAT1 | Worksheet 17
 | 2016-08-16 00:00:00 | HIST2 | Pages 80-120
 | 2016-08-18 00:00:00 | CHEM | Worksheet 3
Spreadsheet: 179144d1347039645-return-a-certain-value-if-cell-contains-text-timakachev_858775_07sep12_01
Sheet: Sheet1

FCV | 1 |  |  | V | 10
LCV | 2
PCV | 3
TCV | 4
LRV | 5
MV | 6
PRV | 7
PSV | 8
TRV | 9
V | 10
XV | 11
YV | 12
DP | 13
Spreadsheet: 761642d1641130832-formula-for-multiple-conditions-test-file-etaf-3-
Sheet: Sheet1

Name | Status | Completed On
A | Pending | 2021-12-28 02:00:00 |  |  |  |  | The person A should not be available if:    1. The DND status (Sheet2) of person A is Do Not Disturb.  2. The status of person A is pending (Sheet 1).  3. Person A has 2 or more status as Completed.
B | Completed | 2021-12-29 12:30:00
C | Pending | 2021-12-30 12:30:00
D | Completed | 2021-12-31 12:30:00
D | Completed | 2021-12-31 17:00:00
B | Completed
B | Completed
Spreadsheet: 0e7ce6ab-e5d2-4b10-8ef1-6b3562ae904a
Sheet: EMBASE

EMBASE
2009-2010
COUNTER-Compliant?: | No
 | 2009-07-01 00:00:00 | 2009-08-01 00:00:00 | 2009-09-01 00:00:00 | 2009-10-01 00:00:00 | 2009-11-01 00:00:00 | 2009-12-01 00:00:00 | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 | Total | 2009-2010 Price | Price per unit
EMBASE.com
Sessions | 50 | 46 | 175 | 208 | 161 | 132 | 95 | 250 | 305 | 256 | 50 | 92
Searches | 97 | 159 | 633 | 658 | 535 | 522 | 286 | 1286 | 1139 | 796 | 106 | 344 |  | 10927
Spreadsheet: 676694d1588937723-how-to-get-data-based-on-date-criteria-excel-solution-miranti-
Sheet: Sticker 1st solution

Period : | 2020-03-20 00:00:00 |  | 2020-04-20 00:00:00
Type | Start | Finish
abc | 2020-03-12 00:00:00 | 2020-04-12 00:00:00
lalal | 2020-04-12 00:00:00 | 2020-04-15 00:00:00
ZZZ | 2020-04-12 00:00:00 | 2020-04-15 00:00:00
[NAME] | 2020-04-13 00:00:00 | 2020-04-15 00:00:00
sss | 2020-04-14 00:00:00 | 2020-04-18 00:00:00
kkk | 2020-04-15 00:00:00 | 2020-04-18 00:00:00
mmm | 2020-04-16 00:00:00 | 2020-04-17 00:00:00
ppp | 2020-04-17 00:00:00 | 2020-04-18 00:00:00
gtet | 2020-04-18 00:00:00 | 2020-04-19 00:00:00
jdytdnj | 2020-04-19 00:00:00 | 2020-04-20 00:00:00
ytst | 2020-04-20 00:00:00 | 2020-04-21 00:00:00
Update production
Date | Type |  | Date | Type
Spreadsheet: 837076d1689836878-lookup-for-value-within-tolerance-from-two-columns-giwi342-xlookup-with-tolerance
Sheet: Sheet1

Compare this |  |  | To this |  |  | If both within range of X, return this
Longitude | Latitude |  | Lat | Lon |  | ID
24.625272 | 59.405251 |  | 24.61024014 | 59.42884049 |  | 1
24.898454 | 59.44571 |  | 24.61118004 | 59.43042055 |  | 6
24.898512 | 59.445643 |  | 24.6073425 | 59.43094134 |  | 77
24.898384 | 59.445796 |  | 24.63748214 | 59.42330986 |  | 15
24.746022 | 59.436453 |  | 24.63764335 | 59.42378331 |  | 3
24.746032 | 59.436492 |  | 24.63780914 | 59.42430388 |  | 4
Spreadsheet: 726732d1617389834-replace-nested-ifs-with-vlookup-forum-if-test-
Sheet: JAN

 |  |  |  |  |  |  | DEP GMT | ARR GMT | DEP LT | ARR LT
 |  |  | AAA | KKK |  |  | 2021-01-01 10:01:00 | 2021-01-01 12:00:00
 |  |  | DDD | GGG |  |  | 2021-01-01 12:43:00 | 2021-01-01 14:30:00
Spreadsheet: 874554d1721140411-ranking-team-scores-for-bowling-league-boharris-no-tap-bowling-scores-template-2-aligw
Sheet: Test

 | NO TAP & DRAW 4
LANE |  | 5 |  |  |  |  | DATE |  |  |  |  |  |  |  |  |  | LANE |  |  |  | 6 | Men |  |  |  |  | Women
# | NAME | M/W | HDCP | 1 | 2 | 3 | Total | W/H | # | NAME | M/W | HDCP | 1 | 2 | 3 | Total | W/H | Team/T | T/T | TEAM | $ | $ | # | NAME |  | SCORE | # | NAME |  | SCORE | $
LANE |  | 7 |  |  |  |  | DATE |  |  |  |  |  |  |  |  |  | LANE |  |  |  | 8
# | NAME | M/W | HDCP | 1 | 2 | 3 | Total | W/H | # | NAME | M/W | HDCP | 1 | 2 | 3 | Total | W/H | Team/T | T/T | TEAM | $
LANE |  | 9 |  |  |  |  | DATE |  |  |  |  |  |  |  |  |  | LANE |  |  |  | 10
# | NAME | M/W | HDCP | 1 | 2 | 3 | Total | W/H | # | NAME | M/W | HDCP | 1 | 2 | 3 | Total | W/H | Team/T | T/T | TEAM | $
LANE |  | 11 |  |  |  |  | DATE |  |  |  |  |  |  |  |  |  | LANE |  |  |  | 12
# | NAME | M/W | HDCP | 1 | 2 | 3 | Total | W/H | # | NAME | M/W | HDCP | 1 | 2 | 3 | Total | W/H | Team/T | T/T | TEAM | $
LANE |  | 13 |  |  |  |  | DATE |  |  |  |  |  |  |  |  |  | LANE |  |  |  | 14
# | NAME | M/W | HDCP | 1 | 2 | 3 | Total | W/H | # | NAME | M/W | HDCP | 1 | 2 | 3 | Total | W/H | Team/T | T/T | TEAM | $
LANE |  | 15 |  |  |  |  | DATE |  |  |  |  |  |  |  |  |  | LANE |  |  |  | 16
# | NAME | M/W | HDCP | 1 | 2 | 3 | Total | W/H | # | NAME | M/W | HDCP | 1 | 2 | 3 | Total | W/H | Team/T | T/T | TEAM | $
LANE |  | 17 |  |  |  |  | DATE |  |  |  |  |  |  |  |  |  | LANE |  |  |  | 18
# | NAME | M/W | HDCP | 1 | 2 | 3 | Total | W/H | # | NAME | M/W | HDCP | 1 | 2 | 3 | Total | W/H | Team/T | T/T | TEAM | $
LANE |  | 19 |  |  |  |  | DATE |  |  |  |  |  |  |  |  |  | LANE |  |  |  | 20
# | NAME | M/W | HDCP | 1 | 2 | 3 | Total | W/H | # | NAME | M/W | HDCP | 1 | 2 | 3 | Total | W/H | Team/T | T/T | TEAM | $
LANE |  | 21 |  |  |  |  | DATE |  |  |  |  |  |  |  |  |  | LANE |  |  |  | 22
# | NAME | M/W | HDCP | 1 | 2 | 3 | Total | W/H | # | NAME | M/W | HDCP | 1 | 2 | 3 | Total | W/H | Team/T | T/T | TEAM | $
LANE |  | 23 |  |  |  |  | DATE |  |  |  |  |  |  |  |  |  | LANE |  |  |  | 24
# | NAME | M/W | HDCP | 1 | 2 | 3 | Total | W/H | # | NAME | M/W | HDCP | 1 | 2 | 3 | Total | W/H | Team/T | T/T | TEAM | $
Spreadsheet: dana_davis__4508__1 Central Records Form
Sheet: ZOO74035

ENA |  |  |  |  |  |  |  | Page | of
 |  |  | RECORDS TRANSFER LIST |  |  |  |  | 1 | 1
[NAME] Number |  |  | R.C. Number |  | Company Number | Destination Date |  | Transfer Number
 | 404 |  | 0771 |  | 413
Company |  |  |  |  | Department |  |  | Section
ENRON CORP |  |  |  |  | Merchant Finance
Retention |  | [NAME] by Filing Arrangement and |  |  |  | [NAME] |  |  | Record
Schedule |  | Record Series Range, eg. 1-5, A-H, etc. |  |  |  |  |  | Container | Center Only
Item Number |  | (Title Same as Used in [NAME]) |  |  |  | From | To | Number | Location #
20715 |  | Cash Flow |  |  |  |  |  | Z0074035
 |  | Cash Flow Plan ECT |  |  |  | 1998-01-01 00:00:00 | 1998-12-31 00:00:00
 |  | Cash Flow Plan EI |  |  |  | 1997-01-01 00:00:00 | 1997-12-31 00:00:00
 |  | Cash Flow Plan Revised EI |  |  |  | 1997-01-01 00:00:00 | 1997-12-31 00:00:00
 |  | Co.002 Cash Flow (Enron Finance Corp) |  |  |  | 1997-01-01 00:00:00 | 1997-12-31 00:00:00
 |  | Co.003 Cash Flow (ERAC Finance Co.) |  |  |  | 1997-01-01 00:00:00 | 1997-12-31 00:00:00
 |  | Co.1N2 Cash Flow (ECT Finance) |  |  |  | 1997-01-01 00:00:00 | 1997-12-31 00:00:00
 |  | Co.623 Cash Flow (Mid-Gulf Drilling) |  |  |  | 1997-01-01 00:00:00 | 1997-12-31 00:00:00
Prepared By |  |  |  | Date | Building/Room/City
[NAME] |  |  |  |  | ENRON CORP./EB 2448a/HOUSTON
Department Head |  |  |  | Date | Computer Input By |  |  |  | Date
Hope Vargas
Checked and Received by |  |  |  | Date | Verified by |  |  |  | Date
Spreadsheet: 736735d1623839687-finding-the-matching-value-using-v-lookup-vlookup
Sheet: Sheet1

Order number | Lineitem barcode | KASUR MM | SWAT MM | SHADMAN MM | MATCHED
MM76420_1 | 7000000161423 | 7000000109452 | 7000000094942 | 7000000096466
MM76420_1 | 7000000173483 | 7000000109454 | 7000000107914 | 7000000133236
MM76420_1 | 7000000172223 | 7000000109455 | 7000000109455 | 7000000173483
MM76420_1 | 7000000171741 | 7000000173483 | 7000000109456 | 7000000161627
MM76420_1 | 7000000170783 | 7000000109457 | 7000000109457 | 7000000162729
Spreadsheet: 147476d1332812882-help-on-adding-a-yes-or-no-trapped-option-trappedoption
Sheet: Sheet2

W Width | T Width | Stack W | # Blades | trapped
0 | 0 | 0 | 0 | YES
1 | 13.75 | 4 | 3 | NO
12 | 20.25 | 4.5 | 5
18 | 26.75 | 5 | 7
24 | 33.25 | 5.5 | 9
30 | 40 | 6 | 11
36 | 46.5 | 6.5 | 13
42 | 53 | 7 | 15
48 | 59.5 | 7.5 | 17
54 | 66 | 8 | 19
60 | 72.5 | 8.5 | 21
66 | 79 | 9 | 23
72 | 85.5 | 9.5 | 25
78 | 92 | 10 | 27
84 | 98.5 | 10.5 | 29
90 | 105 | 11 | 31
96 | 111.5 | 11.5 | 33
102 | 118 | 12 | 35
108 | 124.5 | 12.5 | 37
114 | 131 | 13 | 39
120 | 137.5 | 13.5 | 41
126 | 144 | 14 | 43
132 | 150.5 | 14.5 | 45
138 | 157 | 15 | 47
144 | 163.5 | 15.5 | 49
150 | 170 | 16 | 51
156 | 176.5 | 16.5 | 53
162 | 183 | 17 | 55
168 | 189.5 | 17.5 | 57
174 | 196 | 18 | 59
180 | 202.5 | 18.5 | 61
186 | 209 | 19 | 63
192 | 215.5 | 19.5 | 65
198 | 222 | 20 | 67
204 | 228.5 | 20.5 | 69
210 | 235 | 21 | 71
216 | 241.5 | 21.5 | 73
222 | 248 | 22 | 75
228 | 254.5 | 22.5 | 77
234 | 261 | 23 | 79
240 | 267.5 | 23.5 | 81
246 | 274 | 24 | 83
252 | 280.5 | 24.5 | 85
258 | 267 | 25 | 87
264 | 293.5 | 25.5 | 89
270 | 300 | 26 | 91
276 | 306.5 | 26.5 | 93
282 | 313 | 27 | 95
288 | 319.5 | 27.5 | 97
294 | 326 | 28 | 99
300 | 332.5 | 28.5 | 101
306 | 339 | 29 | 103
312 | 345.5 | 29.5 | 105
318 | 352 | 30 | 107
324 | 358.5 | 30.5 | 109
330 | 365 | 31 | 111
336 | 371.5 | 31.5 | 113
342 | 378 | 32 | 115
348 | 384.5 | 32.5 | 117
354 | 391 | 33 | 119
360 | 397.5 | 33.5 | 121
366 | 404 | 34 | 123
372 | 410.5 | 34.5 | 125
378 | 417 | 35 | 127
384 | 423.5 | 35.5 | 129
390 | 430 | 36 | 131
396 | 436.5 | 36.5 | 133
402 | 443 | 37 | 135
408 | 449.5 | 37.5 | 137
414 | 456 | 38 | 139
420 | 462.5 | 38.5 | 141
426 | 469 | 39 | 143
432 | 475.5 | 39.5 | 145
438 | 482 | 40 | 147
444 | 488.5 | 40.5 | 149
450 | 495 | 41 | 151
456 | 501.5 | 41.5 | 153
462 | 508 | 42 | 155
468 | 514.5 | 42.5 | 157
474 | 521 | 43 | 159
480 | 527.5 | 43.5 | 161
486 | 534 | 44 | 163
492 | 540.5 | 44.5 | 165
Spreadsheet: 701034d1603474033-offset-isblank-not-working-in-array-formula-offset-issue-with-array-formula
Sheet: Survey

 | FAVORITE FRUIT |  |  |  |  |  |  |  | FAVORITE SEASON |  |  |  | ETC. |  | FRUIT | SEASON |  | FRUIT
NAME | APPLE | BANANA | GRAPE | PEACH | PEAR | CHERRY | STRAWBERRY | OTHER | SPRING | SUMMER | FALL | WINTER
[NAME] |  |  |  | Peach |  |  |  |  | Spring
[NAME] |  | [NAME] |  |  |  |  |  |  |  | Summer
Fred |  |  |  |  |  |  | [NAME] |  |  |  | Fall
[NAME] | Apple |  |  |  |  |  |  |  |  | Summer
[NAME] |  |  | Grape |  |  |  |  |  |  | Summer
 | Survey answers are distributed in separate columns (as in pink and yellow areas above).  I need to find the "answer number" to each question (its column position within its block).
 | I can hard-code the formulas (as in the green area), but actual data is a large sheet so I want to use OFFSET (with lookups to find the actual column range) so one formula will work for every question.
 | I tried using OFFSET with just hard-coded numbers (rather than lookups) as the next step in constructing the formula (see the blue cell), but for some reason it doesn't work??
 | Why does cell S3 (using the OFFSET function to return the range B3:I3) not return the same result as cell P4?
 | And just as proof:
 |  |  |  |  | COLUMN(OFFSET($A$1,ROW(S3)-1,1,1,8)) =
 |  |  |  |  | COLUMNS(OFFSET($A$1,ROW(S3)-1,1,1,8)) =
 |  |  |  |  | ROW(OFFSET($A$1,ROW(S3)-1,1,1,8)) =
 |  |  |  |  | ROWS(OFFSET($A$1,ROW(S3)-1,1,1,8)) =
 |  |  |  |  | RESULTING RANGE =
Spreadsheet: 867351d1714167204-solver-function-fails-book1
Sheet: Sheet1

Variable | ​Profit/sf | Square Feet Allotted | ​Investment/sf | ​Risk/sf | Minimum sf | Maximum sf
E | ​$13.00 | 0 | ​$100 | ​$24 | 7000 | 30000
F | ​$6.00 | 0 | ​$50 | ​$6 | 11000 | 30000
M | ​$2.00 | 0 | ​$30 | ​$1.50 | 2000 | 5000
C | ​$30.00 | 0 | [NAME] | ​$60 | 4000 | 40000
J | ​$20.00 | 0 | ​$900 | ​$126 | 1000 | 10000
B | ​$2.00 | 0 | ​$50 | ​$1 | 1000 | 7000
A | ​$14.00 | 0 | ​$400 | ​$12 | 13000 | 42000
Objective Function | maximum profit
Constraints | ​100,000
investment | ​20,000,000
risk
min
[NAME]
Spreadsheet: jeff_dasovich__14103__California PJM and NE Tables revised2
Sheet: A34

TABLE A34 FREQUENCY OF PRICE SPIKES IN THE NEW ENGLAND THIRTY-MINUTE OPERATING RESERVE MARKET BEFORE ISO-NE REVISIONS
PRICE EQUALS OR EXCEEDS | FY 00/99 | FY 99/98
 | # of hours
 | % of available hours
100 | 19 | NA
 | 0.00216
250 | 8 | NA
 | 0.00091
500 | 3 | NA
 | 0.00034
750 | 2 | NA
 | 0.00023
1000 | 0 | NA
 | 0
Source:  ISO-NE Website (www.iso-ne.com).
FY 00/99: 8/16/1999-8/15/2000
FY 99/98: 8/16/1998-8/15/1999
Spreadsheet: 164051d1340631058-find-the-accoutable-in-a-raci-matrix-raci_matrix
Sheet: Sheet1

 | accountable | informed | role 1 | role 2 | role 3 | role 4 | role 5 | role 6 | role 7 | role 8 | role 9 | role 10 | role 11 | role 12 | role 13 | role 14
product 1
product 2 | role 1 | role 4 | A |  |  | I
product 3 | role 2 | role 6 |  | A |  |  |  | I
product 4 | role 10 | role 3 |  |  | I |  |  |  |  |  |  | A
product 5
product 6
product 7
product 8
product 9
product 10
product 11
product 12
product 13
product 14
place A where role is accountable for product
place I where role has to be informed
column B and C would like to be achieved with 'lookups' somehow
Spreadsheet: f7980e13-5ae4-4492-91a5-5c49a7fa0706
Sheet: Sheet1

AGENDA SEMESTER II
BULAN | TGL | KELAS | AGENDA | KET
Maret | 14 - 24 | 7 & 8 (SMP) | UTS Semester Genap
 |  | 9 (SMP) | Ujian Pesantren & Praktek
 |  | 10 & 11 (SMA) | UTS Semester Genap
 |  | 12 (SMA) | [NAME]
April | 16 - 20 | 12 (SMA) | UN (Kelas lain belajar [NAME])
 | 23 - 27 | 9 (SMP) | UN (Kelas 7,8,10,11 Super Camp)
[NAME] | 29 Mei - 2 Juni | 7 & 8 (SMP) | [NAME]
 |  | 10 & 11 (SMA)
Juni | 3 | - | Wisuda Kelas 9 SMP
 | 5 - 16 | 7 & 8 (SMP) | Ujian Kenaikan Kelas
 |  | 10 & 11 (SMA)
 | 10 | Santri Baru SMA | [NAME], Kediri, [NAME]
 | 17 | - | [NAME] 12 SMA
 | 23 | 7 & 8 (SMP) | Bagi Rapor [NAME] [NAME] Kenaikan Kelas
 |  | 10 & 11 (SMA)
*   Libur santri dari pembagian rapor 23 Juni - 15 Juli 2012.
Santri sudah [NAME] pesantren tgl 15 Juli 2012, paling lambat sore hari.
** [NAME] : Santri baru, masuk ke pesantren hari Ahad, 8 Juli 2012.
Catatan :
[NAME] tentatif, sewaktu-waktu dapat berubah dengan pemberitahuan.
Spreadsheet: 37cab6f0-5f87-48d3-9f0c-0cc60c70c8de
Sheet: Korpri

RENCANA UMUM PENGADAAN BARANG/JASA PEMERINTAH
PA/KPA |  | : [NAME], [NAME]
K/L/D/I |  | : Instansi
SATKER/SKPD |  | : [NAME] Pengurus KORPRI
PPK |  | : [NAME] P, [NAME]
[NAME] |  | : 2013
NO | KEGIATAN | SUB KEGIATAN/ PEKERJAAN | NAMA PAKET PEKERJAAN | VOLUME | LOKASI PEKERJAAN (PROVINSI/KAB/KOTA) | RENCANA PENGANGGARAN |  |  | CARA PENGADAAN | PERKIRAAN WAKTU MULAI PELAKSANAAN PENGADAAN | WAKTU PELAKSANAAN (BULAN) | [NAME]
 |  |  |  |  |  | PERKIRAAN BIAYA (RP,-) | [NAME] (APBN/APBD) | RENCANA PEMBIAYAAN
(1) | (2) | (3) | (4) | (5) | (6) | (7) | (8) | (9) | (10) | (11) | (12) | (13)
1 | Penyediaan   Peralatan dan Perlengkapan kantor | Belanja Modal Pengadaan Komputer | Printer | 3 Unit | Jl. [NAME] Praja No. 01 Kelurahan Gunung [NAME]. [NAME]. [NAME] | 2550000 | APBD | Dibayarkan sesuai DPA [NAME] DP. [NAME] | Kontrak | [NAME] 2013 | 1 Bulan
 |  | Belanja Modal Pengadaan Mebeulair | Pengadaan Meja Kerja | 5 Buah | Jl. [NAME] Praja No. 01 Kelurahan Gunung [NAME]. [NAME]. [NAME] | 3500000 | APBD | Dibayarkan sesuai DPA [NAME] DP. [NAME] | Kontrak | [NAME] 2013 | 1 Bulan
 |  |  | Pengadaan Kursi Kerja | 5 Buah | Jl. [NAME] Praja No. 01 Kelurahan Gunung [NAME]. [NAME]. [NAME] | 3000000 | APBD | Dibayarkan sesuai DPA [NAME] DP. [NAME] | Kontrak | [NAME] 2013 | 1 Bulan
 |  | Belanja Modal Pengadaan Alat - alat studio | Pengadaan Proyektor | 1 Unit | Jl. [NAME] Praja No. 01 Kelurahan Gunung [NAME]. [NAME]. [NAME] | 10000000 | APBD | Dibayarkan sesuai DPA [NAME] DP. [NAME] | Kontrak | [NAME] 2013 | 1 Bulan
 |  |  |  |  |  |  |  |  |  | Batulicin , 14 Januari 2013
 |  |  |  |  |  |  |  |  |  | PA/KPA
 |  |  |  |  |  |  |  |  |  | Sadriansyah, [NAME]
 |  |  |  |  |  |  |  |  |  | NIP. 19600714 198103 1 018
Spreadsheet: 8eb23f4a-3b80-4b51-9932-7860d5afce5c
Sheet: Sheet1

CERTIFICATION TEST PASS RATES*  ([NAME] and Updated 11/7/11)
 | COMPLETION YEAR 2005 |  |  |  |  |  | COMPLETION YEAR 2006 |  |  |  |  |  | COMPLETION YEAR 2007 |  |  |  |  |  | COMPLETION YEAR 2008 |  |  |  |  |  | COMPLETION YEAR 2009 |  |  |  |  |  | COMPLETION YEAR 2010 |  |  | COMPLETION YEAR 2011
 | INITIAL |  |  | FINAL |  |  | INITIAL |  |  | FINAL |  |  | INITIAL |  |  | FINAL |  |  | INITIAL |  |  | FINAL |  |  | INITIAL |  |  | FINAL |  |  | FINAL |  |  | FINAL
Name of Test | Tests Taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate | Tests taken | Tests Passed | Pass Rate
History 8-12 | - | - | - | - | - | - | 3 | 3 |  | 3 | 3 |  | 3 | 3 |  | 4 | 3 |  | 5 | 5 |  | 5 | 5 | 1 | 4 | 4 | 1 | 4 | 4 | 1 | 6 | 6 | 1 | 5 | 3 | 0.6
Social Studies 4-8 | - | - | - | - | - | - | 1 | 1 |  | 1 | 1 |  | - | - | - | - | - | - | - | - | - | - | - | - | 1 | 1 | 1 | 1 | 1 | 1 | - | - | - | - | - | -
Social Studies 8-12 | 1 | 1 |  | 1 | 1 |  | 1 | 1 |  | 1 | 1 |  | 4 | 3 |  | 4 | 3 |  | 2 | 2 |  | 2 | 2 | 1 | 2 | 2 | 1 | 2 | 2 | 1 | 3 | 3 | 1 | 1 | 1 | 1
*Data obtained from Texas Education Agency's Accountability System for Educator Preparation (ASEP) report on pass rates sorted by Test.
*2010 Texas Education Agency starting using one yearly pass rate.
Spreadsheet: 144867d1331174728-counting-unique-customers-in-a-list-by-a-specific-date-range-excelhelp-frequency
Sheet: Sheet1

Order # | Customer Name | Shipping Name | Grand Total | Date | Match | Count | Frequency
3545696029 | [NAME] | [NAME] | 57.95 | 2011-04-01 09:01:25
3546555421 | [NAME] | [NAME] | 56.49 | 2011-04-01 13:26:43 | 2 |  | 3 |  | Start Date | 2011-04-01 00:00:00
3546676508 | [NAME] | [NAME] | 62.87 | 2011-04-01 14:12:02 | 1 |  | 0 |  | End Date | 2011-04-06 00:00:00
3554194409 | [NAME] | [NAME] | 56.49 | 2011-04-05 17:07:19 | 4 |  | 1
SPNFL7004 | [NAME] | [NAME] | 0 | 2011-04-05 19:58:48 | 5 |  | 2 |  | Total Unique Customers
3554421939 | [NAME] | [NAME] | 87.95 | 2011-04-05 20:09:40 | 1 |  | 0
SPNFL7006 | [NAME] | Tom & Alberta Fox | 0 | 2011-04-05 21:01:51 | 2 |  | 0
SPNFL7007 | [NAME] | [NAME] | 0 | 2011-04-06 00:06:44 | 8 |  | 1
3554689361 | [NAME] | Cree  Molina | 68.95 | 2011-04-06 02:34:06 | 1 |  | 0
SPNFL7009 | [NAME] | [NAME] | 0 | 2011-04-06 04:01:46 | 2 |  | 0
3555056449 | [NAME] | [NAME] | 47.95 | 2011-04-06 07:47:26 | 5 |  | 0
SPNFL7011 | [NAME] | Shannon Preble | 0 | 2011-04-06 08:10:07 | 1 |  | 0
Spreadsheet: 192162d1352322695-calculate-forecast-estimated-hours-to-complete-date-and-time
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | http://www.excelforum.com/excel-general/873191-calculate-forecast-estimated-hours-to-complete.html
Sample indata | Excel time serial number | Formatted differently |  |  | days | hours | minutes
00:25:00 |  |  |  | Formula1
297 |  |  |  | Formula2
Spreadsheet: 1fbbcde0-7cea-49fd-ac74-358990f116ba
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
3792 | 55590 | [NAME] | White | GBR | 240 | 00:36:49 | 00:00:36 | 01:03:27 | 00:00:41 | 00:18:32 | 1 | 02:00:04
3792 | 12408 | Jon | Cowell | GBR | 238 | 00:38:37 | 00:00:33 | 01:05:22 | 00:00:31 | 00:19:48 | 2 | [NAME]
3792 | 23815 | [NAME] | Brewer | GBR | 237 | 00:41:06 | 00:00:45 | 01:02:25 | [NAME] | 00:21:30 | 3 | 02:06:24
3792 | 23167 | Ian | Imeson | GBR | 239 | 00:37:48 | 00:00:52 | 01:10:05 | 00:00:34 | 00:20:08 | 4 | 02:09:26
3792 | 23645 | [NAME] | Braun | GER | 241 | 00:40:30 | 00:00:52 | 01:08:52 | [NAME] | 00:21:27 | 5 | 02:12:31
3792 | 14594 | Neofytos | Tzouanakis | GRE | 242 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | DNS | 00:00:00