tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 455002d1460060505-conditional-formating-help
Sheet: 4-6-2016

Person ID | CoDscrp | Company | Name | Division | Dept | Location | Job Title | Supervisor | Original Hire | Deadline | New Employee 2016 Information Security: | New Employee 2016 EIDS Policy: | New Employee 2016 Corporate Code of Ethics: | 2015 Information Security: | 2015 Red Flag Training: |  | 2015 WTFC EIDS Policy: | 2015 WTFC Corporate Code of Ethics: | New Employe Training Complete Timely | NOTES (Provided by Training Dept./Human Resources)
10102 | Bank | AVD | [NAME] | Lending | Community Advantage | Avadanade | Loan Processor | [NAME] | 2001-05-29 00:00:00 |  | 2015-05-03 00:00:00 | 2015-06-29 00:00:00 | 2015-08-08 00:00:00 |  | 2016-03-18 00:00:00 |  |  | 2015-09-19 00:00:00
10103 | Bank | AVD | [NAME] | Retail | Teller | Avadanade | Teller | [NAME] | 2015-12-28 00:00:00 |  | 2015-03-22 00:00:00 |  |  |  | 2016-01-21 00:00:00 |  | 2016-01-21 00:00:00 | 2016-01-21 00:00:00
10104 | Bank | AVD | [NAME] | Retail | Branch Management | Avadanade | Branch President | [NAME] | 2009-06-30 00:00:00 |  | 2015-11-20 00:00:00 |  |  |  | 2016-01-21 00:00:00 |  |  | 2015-07-12 00:00:00
10105 | Bank | AVD | [NAME] | Retail | Teller | Avadanade | Teller Supervisor | [NAME] | 1992-02-03 00:00:00 |  | 2016-01-01 00:00:00 |  |  |  | 2016-02-04 00:00:00 |  |  | 2015-08-19 00:00:00
10106 | Bank | AVD | [NAME] | Lending | Commercial | Avadanade | VP, Lending | [NAME] | 2012-07-02 00:00:00 |  | 2016-08-07 00:00:00 |  |  |  | 2016-03-11 00:00:00 |  |  | 2015-08-31 00:00:00
10107 | Bank | AVD | Bret Anna | Retail | Teller | Avadanade | Teller Manager | [NAME] | 2011-06-29 00:00:00 |  | 2016-02-02 00:00:00 |  |  |  | 2016-02-04 00:00:00 |  |  | 2015-06-25 00:00:00
10108 | Bank | AVD | [NAME] | Lending | Commercial | Avadanade | AVP, Lending | [NAME] | 11/17/2008 |  | 2011-02-03 00:00:00 |  |  |  | 2016-03-24 00:00:00 |  |  | 2015-09-16 00:00:00
10109 | Bank | AVD | Casim Abu | Retail | Personal Banking | Avadanade | AVP, Personal Banking | [NAME] | 9/10/1996 |  | 2016-03-06 00:00:00 |  |  |  | 2016-03-12 00:00:00 |  |  | 2015-09-19 00:00:00
10110 | Bank | AVD | [NAME] | Retail | Teller | Avadanade | Teller | [NAME] | 9/12/2005 |  | 2005-12-12 00:00:00 |  |  |  | 2016-01-21 00:00:00 |  |  | 2015-09-03 00:00:00
10111 | Bank | AVD | [NAME] | Retail | Teller | Avadanade | Teller | [NAME] | 2001-08-28 00:00:00 |  | 2001-10-25 00:00:00 |  |  |  | 2016-01-27 00:00:00 |  |  | 2015-09-02 00:00:00
10112 | Bank | AVD | [NAME] | Lending | Community Advantage | Avadanade | VP, Community Advantage | [NAME] | 7/30/2007 |  | 2015-08-11 00:00:00 |  |  |  | 2016-03-22 00:00:00 |  |  | 2015-09-18 00:00:00
Spreadsheet: 103341d1301072250-finding-duplicate-accounts-using-formula-instead-of-filtering-allowedrentals
Sheet: Sheet1

 | Customer ID | [NAME] | Start Date | End Date | Outcome | Start by Sorting by ID and then by [NAME] and then Start Date
 | 0001 | A | 2011-01-01 00:00:00 | 2011-01-31 00:00:00 | Allowed - unique charge band |  | << Look at this formula after the sort and pull down.
 | 0001 | B | 2011-01-01 00:00:00 | 2011-01-31 00:00:00 | Allowed - unique charge band
 | 0056 | C | 2011-02-10 00:00:00 | 2011-02-13 00:00:00 | Allowed - charge band not unique but dates not concurrent
 | 0056 | C | 2011-02-14 00:00:00 | 2011-02-28 00:00:00 | allowed - charge band not unique but dates not concurrent
 | 0106 | D | 2011-03-01 00:00:00 | 2011-03-31 00:00:00 | Not allowed - charge band not unique & running concurrently
 | 0106 | D | 2011-03-01 00:00:00 | 2011-03-31 00:00:00 | Not allowed - charge band not unique & running concurrently
Spreadsheet: 18408ef9-6979-40fc-9aa7-ac3682908487
Sheet: Table 7.1

Monthly Statistical Bulletin
7.1 Population
Quarter | 2009–10 | 2010–11 | 2011–12 | 2012–13 | 2013-14
Estimated resident population (a) – '000
September | 21788.1 | 22104.4 | 22432 | 22830.4 | 23235.8
December | 21865.6 | 22172.5 | 22520.3 | 22924.8
March | 21964.1 | 22268.8 | 22637.1 | 23039.5
June | 22031.8 | 22340 | 22728.3 | 23135.3
Annual change – '000
September | 422 | 316.3 | 327.6 | 398.4 | 405.4
December | 390 | 306.8 | 347.8 | 404.5
March | 362.4 | 304.7 | 368.4 | 402.4
June | 340.1 | 308.3 | 388.2 | 407
Annual change – per cent
September | 1.74 | 1.21 | 1.24 | 1.78 | 1.78
December | 1.58 | 1.16 | 1.36 | 1.8
March | 1.44 | 1.14 | 1.65 | 1.78
June | 1.32 | 1.17 | 1.74 | 1.79
(a) At the end of the quarter.
Source: ABS, Australian demographic statistics, Cat. no. 3101.0 | http://www.rba.gov.au/Statistics/exchange_rates.html | http://www.rba.gov.au/Statistics/exchange_rates.html | http://www.rba.gov.au/Statistics/exchange_rates.html | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=3101.0&viewtitle=Australian%20Demographic%20Statistics~Sep%202007~Latest~19/03/2008&&tabname=Past%20Future%20Issues&prodno=3101.0&issue=Sep%202007&num=&view=&
 |  |  |  |  |  |  |  | Update
 |  |  |  |  |  |  |  | 2014-06-19 00:00:00
Spreadsheet: 125654d1319142925-text-to-columns-changing-the-format-of-imported-contacts-example-forum-1
Sheet: Example of What I Have NOW

[NAME]
 | 123 Main Street
 | Cell Phone: | (000)000-000
 | [NAME]: | [EMAIL]
[NAME] | 456 Main Street
Company Name: | [NAME] LLC | (111)111-1111
 | [NAME]: | [EMAIL]
 | [NAME]: | [EMAIL]
 | [NAME]: | janesmith@alternate_email.com
[NAME] | 789 Main Street
Company name: | Cell Phone | (222)222-2222
 | [NAME]: | [EMAIL]
 | Company Name: | Solar Company
[NAME]
 | Cell Phone | (333) 333-3333
 | Company Name: | Tile Company
Spreadsheet: 868970d1715674476-sumif-_conditioned-of-performance-sumif_cond_values-of-specs-sent-in-each-group_percentagewise_brauns
Sheet: new request

Group | Members | Specification  Sent / No | Value, €
Group5 | Jan | yes | 2
Group2 | [NAME] | yes | 112
Group3 | Volker | 0 | 1
Group2 | Maria | 0 | 1
Group1 | [NAME] | 0 | 25
Group2 | [NAME] | yes | 50
Group3 | [NAME] | 0 | 60
Group4 | Katha | yes | 75
Group3 | [NAME] | yes | 15
Group4 | Holger | 0 | 12
Group1 | Anto | yes | 250
Group4 | Bernd | 0 | 4
Group3 | [NAME] | 0 | 85 |  | Amont of groups, in which specs "sent" are exceeding 50% with their value the total  specs value of the group
Group5 | Anna | yes | 60 |  | "3" | expected result
Group5 | Caroline | 0 | 20
Group1 | Alla | 0 | 75
Group2 | [NAME] | 0 | 38
Group3 | [NAME] | 0 | 42
Group3 | Tizian | yes | 120
Group4 | Vitus | 0 | 250
Group4 | Niklas | yes | 10
Group4 | [NAME] | yes | 100
Group1 | Xavier | 0 | 0 | Challenge:
Group1 | Oxana | 0 | 4 | -count amount of Groups (not members) which have SENT out a specification (column "C"=yes), however only THEN, when the total money value (within this particular group) of specificaitons [NAME] are equal or exceeding 50% of the total specification's VALUE (column "D") of this particular group.
Group5 | Cam | 0 | 90 | -Example on "Group 3": total specifications "sent" - 135€ out of 323€ of the whole group. Since it equals to LESS than 50% (135/323), => "Group 3" should not be counted for the final result.
Group5 | Uzay | 0 | 10 | - please in case if there are no entries in columns "Specification" and "Value, €", the result should be Zero , and not "1".
Group5 | Atakan | yes | 180
Group2 | [NAME] | yes | 300
Group6 | Vasja | 0 | 0 | PS  - Members are not important for this logic, names entries are just put for demo reasons
Group6 | Petja | 0 | 0
Group6 | Asja | 0 | 0
Spreadsheet: 695383d1600183212-if-false-ignore-and-skip-to-next-row-sample_anon_data
Sheet: Sheet1

9T | [NAME] | Faith | F | 9AB | Monitored | 116 | A | 5/6
9C | Boswell | [NAME] | M | 9BC |  | 92 | C | 2/3
9T | Cox | [NAME] | F | 9CD | Active |  |  | 4
9T | [NAME] | [NAME] | M | 9DE | Active |  |  | 5
9A | Evans | [NAME] | F | 9CD |  |  |  | 3
9B | Frederichs | [NAME] | M | 9AB | Active
Spreadsheet: 144534d1331031454-draw-the-chart-chart
Sheet: Sheet1

date | account A |  | date | Account B |  |  |  |  |  |  |  | area
0 | 280 |  | 0 | 299 |  | 0 | 0 |  |  | 250 | 200 | 150 | 100 | 50 | 0
77 | 281 |  | 77 | 298 |  | 77 | 13
160 | 282 |  | 160 | 297 |  | 160 | 26
243 | 283 |  | 243 | 296 |  | 243 | 39
326 | 284 |  | 326 | 295 |  | 326 | 52
409 | 285 |  | 409 | 294 |  | 409 | 65
492 | 286 |  | 492 | 293 |  | 492 | 78
575 | 287 |  | 575 | 292 |  | 575 | 91
658 | 288 |  | 658 | 291 |  | 658 | 104
741 | 289 |  | 741 | 290 |  | 741 | 117
824 | 290 |  | 824 | 289 |  | 824 | 130
907 | 291 |  | 907 | 288 |  | 907 | 143
990 | 292 |  | 990 | 287 |  | 990 | 156
1073 | 293 |  | 1073 | 286 |  | 1073 | 169
1156 | 294 |  | 1156 | 285 |  | 1156 | 182
1239 | 295 |  | 1239 | 284 |  | 1239 | 195
1322 | 296 |  | 1322 | 283 |  | 1322 | 208
1405 | 298 |  | 1405 | 282 |  | 1405 | 221
1488 | 299 |  | 1488 | 281 |  | 1488 | 234
1571 | 300 |  | 1571 | 280 |  | 1571 | 247
Spreadsheet: eric_saibi__9839__100401R
Sheet: San Juan 04 Planned

Owner Name |  | New Mexico Public Service Company
Station Name |  | San Juan Generating Station
Unit Name |  | San Juan 04
NERC Region |  | WSCC
State |  | NM
Fuel Type |  | Coal
Capacity |  | 534 MW
Start Date |  | 2001-10-06 00:00:00
End Date |  | 2001-11-04 00:00:00
Prv. Start Date |  | 2001-10-05 00:00:00
Prv. End Date |  | 2001-11-04 00:00:00
Comments |  | Planned outage
SIC |  | 4911
Plant ID |  | 1016385
Unit ID |  | 1007773
Outage ID |  | 18528
Spreadsheet: 791928d1660662120-change-many-column-in-one-row-i-have-to-use-something-else-than-transpose-tablenew
Sheet: Sheet1

Day | Time | 01-05-2022 | 02-05-2022 |  |  |  | Day | Time | Staff
 | Time 1 | 0 | 0 |  |  |  |  |  |  | Day 1, 1st of May
 | Time 2 | 0 | 0
 | Time 3 | 0 | 0
 | Time 4 | 0 | 0
 | Time 5 | 0 | 0
 | Time 6 | 3 | 6
 | Time 7 | 5 | 11
 | Time 8 | 2 | 17
 | Time 9 | 2 | 2
 | Time 10 | 0 | 3
 | Time 11 | 2 | 0
 | Time 12 | 0 | 0
 | Time 13 | 0 | 1
 | Time 14 | 3 | 2
 | Time 15 | 2 | 3
 | Time 16 | 2 | 2
 | Time 17 | 2 | 0
 | Time 18 | 0 | 0
 | Time 19 | 0 | 0
 | Time 20 | 6 | 0
 | Time 21 | 0 | 0
 | Time 22 | 3 | 3
 | Time 23 | 0 | 0
 | Time 24 | 2 | 7
 |  |  |  |  |  |  |  |  |  | Day 2, 2nd of May
I have this tabe, day 1 in column C, day 2 in column D etc., coloured blue
I want to change it like yellow column and rows.
My task is change blue table to the yellow one.
My table has many days
Spreadsheet: 157518d1337779661-excel-2007-bringing-back-the-final-date-time-combo-of-multiple-calls-example-2
Sheet: Data

Job Number | Log | [NAME] | Completed | No of Visits
1-123456789
1-234567890
1-123456789
Spreadsheet: 859938d1708156371-sum-across-multiple-columns-meeting-3-criteria-v-month-on-month-balances-demo
Sheet: Summary

 |  | 2023-04-30 00:00:00 | 2024-01-31 00:00:00 | Total
 | Income
Main Heading | - Auctions
Sub Heading | Auction |  | -59239.85271942443
Sub Heading | AutoKart | -53.52517985611511 | -779.5125572978906
 | =SUM(FILTER(T!F2:I20,(T!D2:D20=Summary!A5)*(T!E2:E20=Summary!A6)*(T!A2:A20=Summary!B3)*(T!F3:I3=Summary!A7)))
 | =SUM(FILTER(T!F2:I20,(T!D2:D20=Summary!A5)*(T!E2:E20=Summary!A6)*(T!A2:A20=Summary!C3)*(T!F3:I3=Summary!A7)))
 | Auction | -6006.172172661868 | -59239.85271942443
 | AutoKart | -53.52517985611511 | -779.5125572978906
 | Could you pls. help me pull the data from (Sum from all the column meeting conditions) from "T" worksheet based on following 3 criteria
 | 1 | Main Heading
 | 2 | Sub Heading
 | 3 | Month Criteria
Spreadsheet: 114395d1310133633-sumifs-copy-of-copy-of-dummybook2
Sheet: Performance

Negotiator ID | Negotiator | APR/REJ | 2011-06-01 00:00:00 | 2011-06-02 00:00:00 | 2011-06-03 00:00:00 | 2011-06-04 00:00:00 | 2011-06-05 00:00:00 | 2011-06-06 00:00:00 | 2011-06-07 00:00:00 | 2011-06-08 00:00:00 | 2011-06-09 00:00:00 | 2011-06-10 00:00:00
000001 | Amber Simms | APR | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
000001 | Amber Simms | REJ | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | data | =Performance!$D$2:$M$7
000002 | [NAME] | APR | 1 | 0 | 2 | 0 | 0 | 1 | 2 | 0 | 4 | 0 |  |  | name | =Performance!$B$2:$B$7
000002 | [NAME] | REJ | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | type | =Performance!$C$2:$C$7
000003 | [NAME] | APR | 34 | 20 | 37 | 0 | 0 | 40 | 25 | 36 | 25 | 41
000003 | [NAME] | REJ | 0 | 0 | 6 | 0 | 0 | 0 | 1 | 5 | 3 | 3
 | [NAME] | Apr
Spreadsheet: 785551d1656490443-how-index-and-match-with-multiple-criteria-sample-workbook-index-match-
Sheet: Shipment List

Date Create | Shipment ID | HWO# | Product Name | Weight | Qty | Product Weight | Subtotal Prod Weight
2022-06-13 00:00:00 | A22052BBB | WO-22052 | Butter 8oz | 0.5 | 65
2022-06-13 00:00:00 | A22052BBB | WO-22052 | Cream 1lb | 1 | 176
2022-06-13 00:00:00 | A22052BBB | WO-22052 | Cream 3lb | 3 | 48
2022-06-13 00:00:00 | A22052BBB | WO-22052 | Tea 1lb | 1 | 96
2022-06-13 00:00:00 | A22052BBB | WO-22052 | Powder 1lb | 1 | 80
2022-06-13 00:00:00 | A22052BBB | WO-22052 | Flax 5lb | 5 | 64
2022-06-13 00:00:00 | A22052BBB | WO-22052 | Hemp 2x1lb | 2 | 138
2022-06-13 00:00:00 | A22052BBB | WO-22052 | Nibs 2lb | 2 | 120
2022-06-13 00:00:00 | A22052BBB | WO-22052 | Red Quinoa 5lb | 6 | 130
2022-06-13 00:00:00 | A22052BBB | WO-22052 | [NAME]oz | 0.5 | 24
2022-06-13 00:00:00 | A22052BBB | WO-22052 | [NAME]lb | 2 | 120
2022-06-13 00:00:00 | A22052BBB | WO-22053 | Butter 8oz | 1 | 52
2022-06-13 00:00:00 | BBB212356 | WO-22053 | Cream 1lb | 1 | 144
2022-06-13 00:00:00 | BBB212356 | WO-22053 | Cream 3lb | 3 | 76
2022-06-13 00:00:00 | BBB212356 | WO-22053 | Tea 1lb | 1 | 84
2022-06-13 00:00:00 | BBB212356 | WO-22053 | Powder 1lb | 1 | 80
2022-06-13 00:00:00 | BBB212356 | WO-22053 | Flax 5lb | 5 | 96
2022-06-13 00:00:00 | BBB212356 | WO-22053 | Hemp 2x1lb | 2 | 102
2022-06-13 00:00:00 | BBB212356 | WO-22053 | Nibs 2lb | 2 | 110
2022-06-13 00:00:00 | BBB212356 | WO-22053 | Red Quinoa 5lb | 5 | 195
2022-06-13 00:00:00 | BBB212356 | WO-22053 | [NAME]oz | 0.5 | 48
2022-06-13 00:00:00 | BBB212356 | WO-22053 | [NAME]lb | 2 | 120
Total
Spreadsheet: 167100d1341901330-filtering-one-specific-name-in-excel-2010-copy-of-morning-attendance-2-
Sheet: 05 Feb 2012

Daily Morning Staff |  |  |  |  | Sunday
 | 07:30-14:30 |  | 2012-02-05 00:00:00
Name | Staff No. | Title | Time In | Out | Locations | Remarks
Naima Mohamed | 2166 | Client Ralation Supervisor | 07:30:00 | 14:30:00 | EFS
Sheikha [NAME] | 2120 | Reservation Officer | 07:30:00 | 14:30:00 | TOPS
Syed Sultan | 2888 | Supervisor | 07:30:00 | 14:30:00 | EFS
[NAME] | 4143 | Aircraft Team Leader | Annual | Annual | EFS | Annual
Jalil Nushadi | 1889 | Driver | 05:45:00 | 14:30:00 | EFS
[NAME] | 624 | Driver | 07:30:00 | 14:30:00 | EFS
Soud Sharar | 2097 | [NAME] Officer | Annual | Annual | [NAME] | Annual
[NAME] | 1897 | Manager | 07:30:00 | 14:30:00 | EFS
[NAME] | 4440 | Attendant | S/L | S/L | EFS | Sick leave
[NAME] | 1861 | Duty Officer | 07:30:00 | 14:30:00 | EFS
Spreadsheet: 106454d1303746791-finding-duplicate-for-different-dates-duplicates
Sheet: Sheet1

2009-11-20 00:00:00 | aa1
2009-11-20 00:00:00 | aa1
2009-11-20 00:00:00 | aa2
2009-11-20 00:00:00 | aa3
2009-11-20 00:00:00 | aa4
2010-01-22 00:00:00 | bb1
2010-01-22 00:00:00 | bb2
2010-01-22 00:00:00 | bb3
2010-01-22 00:00:00 | bb4
2010-01-22 00:00:00 | bb1
2010-01-22 00:00:00 | bb1
2010-01-22 00:00:00 | bb1
Spreadsheet: 107165d1304386419-sumif-by-month-and-year-profit-sheet-month-formula
Sheet: Sheet1

450 | 2011-02-05 00:00:00
44 | 2010-02-18 00:00:00
1554 | 2010-01-29 00:00:00
700 | 2010-10-18 00:00:00
56 | 2010-12-06 00:00:00
470 | 2010-11-12 00:00:00
80 | 2010-11-03 00:00:00
1600 | 2010-10-28 00:00:00
40 | 2010-10-26 00:00:00
280 | 2011-01-05 00:00:00
408 | 2010-12-04 00:00:00 |  |  | Jan
844.8 | 2010-11-30 00:00:00 |  |  | Feb
1364 | 2010-12-18 00:00:00 |  |  | March
439.04 | 2010-12-31 00:00:00
28 | 2010-12-06 00:00:00
572 | 2009-01-14 00:00:00
197.88 | 2011-01-13 00:00:00
214.4 | 2011-02-12 00:00:00
500 | 2011-01-10 00:00:00
308 | 2011-02-13 00:00:00
40 | 2011-01-10 00:00:00
348 | 2011-02-13 00:00:00
360 | 2011-01-07 00:00:00
40 | 2011-02-22 00:00:00
412 | 2011-02-22 00:00:00
921.6 | 2011-02-18 00:00:00
2360 | 2011-01-29 00:00:00
440 | 2011-01-29 00:00:00
48 | 2011-03-03 00:00:00
Spreadsheet: 860207d1708401559-formula-calculator-for-range-of-values-formula-calculator-ans
Sheet: Sheet1

Round | Home | Score | Score2 | Away
1 | [NAME] | 21 | 13 | Nathan
1 | [NAME] | 21 | 15 | Nathan
1 | [NAME] | 11 | 4 | Nathan
1 | Nathan | 21 | 17 | [NAME]
1 | Nathan | 21 | 14 | [NAME]
1 | Nathan | 11 | 5 | [NAME]
1 | [NAME] | 21 | 18 | Mark
1 | [NAME] | 21 | 13 | Pratik
2 | [NAME] | 21 | 9 | Nathan
2 | [NAME] | 21 | 11 | [NAME]
2 | Nathan | 21 | 17 | [NAME]
2 | Nathan | 21 | 14 | [NAME]
2 | [NAME] | 21 | 12 | Pratik
2 | [NAME] | 21 | 19 | Mark
2 | Mark | 11 | 8 | [NAME]
Spreadsheet: 455970d1460578687-assign-points-based-on-place-finished-in-race-race-sheet-copy-bsb-
Sheet: Sheet1

Sailor (First & Last Name / Sail Number) |  | 1st Race |  |  |  | 2nd Race |  |  |  | 3rd Race |  |  |  | Total | Rank
 |  | Elapsed Time | Corrected Time | Finish | Points | Elapsed Time | Corrected Time | Finish | Points | Elapsed Time | Corrected Time | Finish | Points
Spreadsheet: 680978d1591283692-functions-to-link-data-over-multiple-sheets-excel-forum-example-kanga-azz-
Sheet: March

 |  |  |  |  |  |  |  |  |  |  | Item Used |  | Amount
 |  |  |  |  |  |  |  |  |  |  | Data 1 |  | 3 |  |  |  | Data 1
 |  |  |  |  |  |  |  |  |  |  | Data 5 |  | 5 |  |  |  | Data 2
 |  |  |  |  |  |  |  |  |  |  | Data 7 |  | 4 |  |  |  | Data 3
 |  |  |  |  |  |  |  |  |  |  | Data 9 |  | 8 |  |  |  | Data 4
 |  |  |  |  |  |  |  |  |  |  | Data 10 |  | 6 |  |  |  | Data 5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Data 6
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Data 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Data 8
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Data 9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Data 10
Spreadsheet: 126468d1319711225-reference-to-a-column-of-flexible-length-rowstocolumns
Sheet: Steering

Age Group Definition | Years
0~4 | 2010
5~9 | 2009
10~14 | 2008
15~19 | 2007
20~24
25~29
30~34
35~39
40~44
45~49
50~54
55~59
60~64
65~69
70~74
75~79
80~84
85~89
90~94
95~
Spreadsheet: 065e111b-2fd3-495f-90f8-aa148d642a39
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 |  |  | COMPLETION YEAR 2012
 | INITIAL |  |  | FINAL |  |  | INITIAL |  |  | FINAL |  |  | INITIAL |  |  | FINAL |  |  | INITIAL |  |  | FINAL |  |  | INITIAL |  |  | FINAL |  |  | 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 | Tests taken | Tests Passed | Pass Rate
Pedagogy and Professional Responsibilities 4-8 | 12 | 11 |  | 12 | 11 |  | 10 | 10 |  | 10 | 10 |  | 17 | 17 |  | 17 | 17 |  | 14 | 14 |  | 14 | 14 | 1 | 16 | 16 | 1 | 16 | 16 | 1 | 19 | 19 | 1 | 28 | 28 | 1 | 1 | 1 | 1
Pedagogy and Professional Responsibilities 8-12 | 53 | 49 |  | 53 | 49 |  | 34 | 31 |  | 34 | 31 |  | 32 | 29 |  | 33 | 32 |  | 32 | 31 |  | 34 | 33 | 0.971 | 29 | 28 | 0.966 | 29 | 28 | 0.966 | 42 | 42 | 1 | 41 | 40 | 0.976 | 1 | 1 | 1
Pedagogy and Professional Responsibilities EC-12 | 32 | 29 |  | 32 | 29 |  | 48 | 44 |  | 48 | 44 |  | 44 | 42 |  | 45 | 44 |  | 41 | 32 |  | 40 | 38 | 0.95 | 37 | 31 | 0.838 | 37 | 31 | 0.838 | 23 | 23 | 1 | 36 | 32 | 0.889 | 128 | 125 | 0.977
Pedagogy and Professional Responsibilities EC-4 | 113 | 112 |  | 113 | 112 |  | 86 | 83 |  | 86 | 83 |  | 88 | 83 |  | 88 | 83 |  | 86 | 83 |  | 87 | 86 | 0.989 | 83 | 79 | 0.952 | 83 | 79 | 0.952 | 45 | 45 | 1 | - | - | - | - | - | -
Pedagogy and Professional Responsibilities EC-6 *New 2009* |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 29 | 29 | 1 | 54 | 53 | 0.981 | 16 | 15 | 0.938
*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: 187369d1350419819-validation-list-test
Sheet: TEST1

 | Month | Name | Ans | Off | % |  | Month | Name | Ans | Off | % |  | The name below will change and the formula will need to notice this
 | January | RoryJanuary | 1 | 2 | 3 |  | July | RoryJuly | 1 | 2 | 3 |  | [NAME] |  | Ans | Off | %
 | February | RoryFebruary | 1 | 2 | 3 |  | August | RoryAugust | 1 | 2 | 3 |  | January |  | 4 | 5 | 6
 | March | RoryMarch | 1 | 2 | 3 |  | September | RorySeptember | 1 | 2 | 3 |  | February |  | 4 | 5 | 6
 | April | RoryApril | 1 | 2 | 3 |  | October | RoryOctober | 1 | 2 | 3 |  | March |  | 4 | 5 | 6
 | May | RoryMay | 1 | 2 | 3 |  | November | RoryNovember | 1 | 2 | 3 |  | April |  | 4 | 5 | 6
 | June | RoryJune | 1 | 2 | 3 |  | December | RoryDecember | 1 | 2 | 3 |  | May |  | 4 | 5 | 6
 | Half Year | Rory | 6 | 12 | 3 |  | Half Year | Rory | 6 | 12 | 3 |  | June |  | 4 | 5 | 6
 |  |  |  |  |  |  |  |  |  |  |  |  | July |  | 4 | 5 | 6
 | Month | Name | Ans | Off | % |  | Month | Name | Ans | Off | % |  | August |  | 4 | 5 | 6
 | January | ChrisJanuary | 4 | 5 | 6 |  | July | ChrisJuly | 4 | 5 | 6 |  | September |  | 4 | 5 | 6
 | February | ChrisFebruary | 4 | 5 | 6 |  | August | ChrisAugust | 4 | 5 | 6 |  | October |  | 4 | 5 | 6
 | March | ChrisMarch | 4 | 5 | 6 |  | September | ChrisSeptember | 4 | 5 | 6 |  | November |  | 4 | 5 | 6
 | April | ChrisApril | 4 | 5 | 6 |  | October | ChrisOctober | 4 | 5 | 6 |  | December |  | 4 | 5 | 6
 | May | ChrisMay | 4 | 5 | 6 |  | November | [NAME] | 4 | 5 | 6
 | June | ChrisJune | 4 | 5 | 6 |  | December | ChrisDecember | 4 | 5 | 6
 | Half Year | [NAME] | 24 | 30 | 6 |  | Half Year | [NAME] | 24 | 30 | 6
 | Month | Name | Ans | Off | % |  | Month | Name | Ans | Off | %
 | January | DannyJanuary | 7 | 8 | 9 |  | July | DannyJuly | 7 | 8 | 9
 | February | DannyFebruary | 7 | 8 | 9 |  | August | DannyAugust | 7 | 8 | 9
 | March | DannyMarch | 7 | 8 | 9 |  | September | DannySeptember | 7 | 8 | 9
 | April | DannyApril | 7 | 8 | 9 |  | October | DannyOctober | 7 | 8 | 9
 | May | DannyMay | 7 | 8 | 9 |  | November | [NAME] | 7 | 8 | 9
 | June | DannyJune | 7 | 8 | 9 |  | December | DannyDecember | 7 | 8 | 9
 | Half Year | [NAME] | 42 | 48 | 9 |  | Half Year | [NAME] | 42 | 48 | 9
Spreadsheet: 61397d1262209937-macro-or-excel-if-statement-example
Sheet: Data

Minutes exercised | 120
Minutes Ran |  | Range of minutes 5% below | Range of minutes 120% over | Calories burned
50 |  | 47.5 | 60 | 100
100 |  | 95 | 120 | 200
150 |  | 142.5 | 180 | 300
200 |  | 190 | 240 | 400
250 |  | 237.5 | 300 | 500
300 |  | 285 | 360 | 600
350 |  | 332.5 | 420 | 700
400 |  | 380 | 480 | 800