tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 687971d1595511816-return-sheet-name-when-value-is-found-on-that-sheet-students-example
Sheet: Yolande

Yolande
 | 2020-07-29 00:00:00
 | Totaal aantal lessen |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Impro over Space Oddity? | Sweet child o mine? |  | Sweet child o mine?
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Pentatonic opbouwen
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nobody's wife
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Ritme klappen?
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | my girl? |  |  |  | [NAME] nog [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Miss you
 | 30 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | triads
 |  | Januari |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | hey jude met triads
 |  | Februari |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Beide comf numb solos
 |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Apache? | Apache?
 |  | april |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sweet home alabama
 |  | mei |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Pulp fiction??
 |  | juni
 |  | [NAME]
 |  | augustus
 |  | september
 |  | oktober
 |  | november
 |  | december
 | cash
Spreadsheet: 771068d1646404024-help-with-auto-populating-tables-ordering-sheet-2-new-
Sheet: Template Non-spares

Company Information |  |  | Merchant Preferences
Date Customer Requested Order | Spok Number | Company Details | Preferred Merchant | Are you willing to use a different merchant? | Deliverey or collection? | Preferred deliverey or collection date | Deliverey address / Collection area | Are you willing to travel? | Notes
[NAME] | Pending |  |  | MPN if available | Product Name |  |  | Price | Refund Requested
 |  |  | Item 1
BT Order Reference |  |  | Item 2
Confirmed Collection or Delivery Date |  |  | Item 3
Merchant Quote Number |  |  | Item 4
Opayo Invoice Number |  |  | Item 5
Sage Invoice Number |  |  | Item 6
Merchant Invoice Number |  |  | Item 7
Return Note Reference Number |  |  | Item 8
Merchant Credit Note Number |  |  | Item 9
Date Payment Link sent |  |  | Item 10
Date Paid |  |  | Item 11
Date ordered |  |  | Item 12
Date Cancellation/Refund requested |  |  | [NAME] if applicable
Date Refund Issued |  |  | Total Cost
Spreadsheet: 585247d1533678675-remove-or-highlight-duplicates-main1
Sheet: main1

URN | CompanyName | Address1 | Address2 | Town | County | Postcode | Phone | EmployeesOnSite | Website | Industry | Listref | ContactID | ContactTitle | ContactFirstname | ContactSurname | ContactJobTitle
A371343 | Company1 | Address1 | Address2a | BRISTOL | Avon | BS1 1SB | [PHONE] | 10 | www.website1.com | Night Clubs | SA248 Night Clubs | details1a | Mrs | [NAME] | Lastname | Managing Director
J5690249 | Company2 | Address2 | Address2a | BRISTOL | Avon | BS1 1SB | [PHONE] | 30 | www.website1.com | Marketing Consultants and Services | PB264 Marketing Consultants and Services | details1a | Mr | [NAME] | Lastname | Managing Director
J6534257 | Company3 | Address3 | Address2a | BRISTOL | Avon | BS1 1SB | [PHONE] | 15 | www.website1.com | Marketing Consultants and Services | PB264 Marketing Consultants and Services | details1a | Mr | [NAME] | Lastname | Managing Director
[NAME] | Company4 | Address4 | Address2a | BRISTOL | Avon | BS1 1SB | [PHONE] | 10 | www.website1.com | Universities & Medical Schools | EA244 Universities & Medical Schools | details1a | Mr | [NAME] | Lastname | Managing Director
A2533908 | Company5 | Address5 | Address2a | BRISTOL | Avon | BS1 1SB | [PHONE] | 25 | www.website1.com | Legal Services | LA168 Legal Services | details1a | Mr | [NAME] | Lastname | Chief Executive
A3304896 | Company6 | Address6 | Address2a | BRISTOL | Avon | BS1 1SB | [PHONE] | 25 | www.website1.com | Employment & Recruitment Agencies | CB139 Employment & Recruitment Agencies | details1a | Mr | [NAME] | Lastname | Director
Spreadsheet: 298439d1392804114-combine-two-columns-based-on-name-number-and-score-bb
Sheet: Sheet1

Players Name | Runs | Wkts
Praveen | 7 | 3
Santhosh | 14 | 3
Gopi | 2 | 1
[NAME] | 1 | 1
Ganesh | 8 | 1
[NAME] | 12 | 0
[NAME] | 12 | 0
Praveen | 24 | 2
Gopi | 12 | 1
As | 19 | 0
[NAME] | 10 | 1
Ganesh | 15 | 1
Vembuli | 9 | 0
Vijay | 17 | 1
Praveen | 12 | 0
Gopi | 11 | 0
[NAME] | 12 | 0
Vijay | 8 | 2
Santhosh | 7 | 3
Gopi | 15 | 0
[NAME] | 20 | 0
Praveen | 20 | 1
[NAME] | 16 | 1
Vijay | 21 | 1
Praveen | 36 | 0
Santhosh | 9 | 1
Vijay | 11 | 2
[NAME] | 16 | 0
Vembuli | 25 | 1
Spreadsheet: 266487d1379625219-use-selections-from-two-data-validation-lists-to-lookup-and-return-a-combined-result-state-countyfipscode1
Sheet: ALABAMA-1

 | COUNTY | CODE
 | Autauga | 1
 | Baldwin | 3
 | Barbour | 5
 | Bibb | 7
 | Blount | 9
 | Bullock | 11
 | Butler | 13
 | [NAME] | 15
 | Chambers | 17
 | Cherokee | 19
 | Chilton | 21
 | Choctaw | 23
 | Clarke | 25
 | Clay | 27
 | Cleburne | 29
 | Coffee | 31
 | Colbert | 33
 | Conecuh | 35
 | Coosa | 37
 | Covington | 39
 | Crenshaw | 41
 | Cullman | 43
 | Dale | 45
 | Dallas | 47
 | DeKalb | 49
 | Elmore | 51
 | Escambia | 53
 | Etowah | 55
 | Fayette | 57
 | Franklin | 59
 | Geneva | 61
 | Greene | 63
 | Hale | 65
 | [NAME] | 67
 | Houston | 69
 | [NAME] | 71
 | [NAME] | 73
 | Lamar | 75
 | Lauderdale | 77
 | [NAME] | 79
 | [NAME] | 81
 | Limestone | 83
 | Lowndes | 85
 | Macon | 87
 | [NAME] | 89
 | Marengo | 91
 | Marion | 93
 | [NAME] | 95
 | Mobile | 97
 | Monroe | 99
 | Montgomery | 101
 | Morgan | 103
 | [NAME] | 105
 | Pickens | 107
 | Pike | 109
 | Randolph | 111
 | [NAME] | 113
 | St. Clair | 115
 | Shelby | 117
 | Sumter | 119
 | [NAME] | 121
 | Tallapoosa | 123
 | Tuscaloosa | 125
 | Walker | 127
 | Washington | 129
 | Wilcox | 131
 | Winston | 133
Spreadsheet: 869676d1716284916-combine-multiple-vlookups-pc-test
Sheet: Sheet1

Postcode | SupplierPostcode |  | Lat_1 | Long_1 | Lat_2 | Long_2 | Distance (miles) |  | Lat1 Lookup
AL1 1AG | LS20 9PD |  | 51.1951342 | 0.0779767 | 53.8744534 | -1.7157506
PR26 7PD | LS20 9PD |  | 50.8167744 | 0.3261108 | 53.8744534 | -1.7157506
AB10 1AG | LS20 9PD |  | 50.8167744 | 0.3261108 | 53.8744534 | -1.7157506
CF10 1AE | LS20 9PD |  | 51.4307971 | -0.1648874 | 53.8744534 | -1.7157506
Spreadsheet: 51021d1250612173-complicated-conditional-formating-if-statement-condional-formatting-if-statement-1
Sheet: Sheet1

PNO | CT | WMA | DWA | RFW | WR(AB) | AD | WRD | DWR
1 | [NAME] | Mist | 2009-08-18 00:00:00 | NP | DN | 2009-08-02 00:00:00 | Mist | 2009-08-20 00:00:00
Examples of what I am looking for:
8 | C | AN | 2009-08-18 00:00:00 | NP | DN |  |  |  |  | G2 does not have data (need for info)
8 | C | AN | 2009-08-18 00:00:00 | NP | DN | 2009-08-20 00:00:00 |  |  |  | G2 has data (info added so the rest is pending)
8 | C | AN | 2009-08-18 00:00:00 | NP | DN | 2009-08-20 00:00:00 | MC | 2009-08-21 00:00:00 |  | I2 has data so the row is green (action complete)
Spreadsheet: chris_germany__2333__Transco_Doyle_confirms_Mar_2001
Sheet: external

DOYLE
MARCH    2001
 | GAS [NAME] |  |  |  |  |  | PURCHASE |  | TRANSPORT
 |  | PURCHASES |  |  |  |  |  |  | COMMODITY |  | DAILY TRANS
 | DAY AHEAD | RECEIPT | DELIVERY | [NAME] | IMBALANCE |  | STA 85 Gas Daily +0.05 |  | FT | IT @ .1840 | COST
DAY | REQUEST * |  |  |  |  |  |  |  | none for [NAME] |  | DEL'd x Comm.
2001-03-01 00:00:00 | 0 | 0 |  | 0 |  |  |  |  | 0.0306 | 0.184
2001-03-02 00:00:00 | 0 | 0 |  | 0 |  |  |  |  | 0.0306 | 0.184
2001-03-03 00:00:00 | 0 | 1500 | 1472 | 0 |  |  | 5.175 |  | 0.0306 | 0.184
2001-03-04 00:00:00 | 3000 | 1500 | 1472 | 0 |  |  | 5.175 |  | 0.0306 | 0.184
2001-03-05 00:00:00 | 3000 | 1500 | 1472 | 4497 |  |  | 5.175 |  | 0.0306 | 0.184
2001-03-06 00:00:00 | 3000 | 5000 |  | 2617 |  |  | 5.395 |  | 0.0306 | 0.184
2001-03-07 00:00:00 | 0 | 0 |  | 0 |  |  |  |  | 0.0306 | 0.184
2001-03-08 00:00:00 | 0 | 0 |  | 0 |  |  |  |  | 0.0306 | 0.184
2001-03-09 00:00:00 | 0 | 0 |  | 0 |  |  |  |  | 0.0306 | 0.184 | 0
2001-03-10 00:00:00 | 0 | 0 |  | 0 |  |  |  |  | 0.0306 | 0.184 | 0
2001-03-11 00:00:00 | 0 | 0 |  | 0 |  |  |  |  | 0.0306 | 0.184 | 0
2001-03-12 00:00:00 | 0 | 0 |  | 0 |  |  |  |  | 0.0306 | 0.184
2001-03-13 00:00:00 | 0 | 0 |  | 0 |  |  |  |  | 0.0306 | 0.184
2001-03-14 00:00:00 | 0 | 0 |  | 0 |  |  |  |  | 0.0306 | 0.184
2001-03-15 00:00:00 | 0 | 0 |  | 0 |  |  |  |  | 0.0306 | 0.184
2001-03-16 00:00:00 | 0 | 0 |  | 0 |  |  |  |  | 0.0306 | 0.184
2001-03-17 00:00:00 | 0 | 0 |  | 0 |  |  |  |  | 0.0306 | 0.184
2001-03-18 00:00:00 | 0 | 0 |  | 0 |  |  |  |  | 0.0306 | 0.184
2001-03-19 00:00:00 | 0 | 0 |  | 0 |  |  |  |  | 0.0306 | 0.184
2001-03-20 00:00:00 | 0 | 0 |  | 0 |  |  |  |  | 0.0306 | 0.184 | 0
2001-03-21 00:00:00 | testing | 0 |  | 3037 |  |  |  |  | 0.0306 | 0.184 | 0
2001-03-22 00:00:00 | 0 | 0 |  | 133 |  |  |  |  | 0.0306 | 0.184 | 0
2001-03-23 00:00:00 | 0 | 0 |  | 0 |  |  |  |  | 0.0306 | 0.184
2001-03-24 00:00:00 | 0 | 0 |  | 0 |  |  |  |  | 0.0306 | 0.184
2001-03-25 00:00:00 | 0 | 0 |  | 87 |  |  |  |  | 0.0306 | 0.184
2001-03-26 00:00:00 | 3000 | 0 |  | 3791 |  |  |  |  | 0.0306 | 0.184 | 0
2001-03-27 00:00:00 | 3000 | 3200 |  | 1800 |  |  | 5.275 |  | 0.0306 | 0.184
2001-03-28 00:00:00 | testing | 2000 |  | 0 |  |  | 5.45 |  | 0.0306 | 0.184
2001-03-29 00:00:00 | 0 | 0 |  | 0 |  |  |  |  | 0.0306 | 0.184
2001-03-30 00:00:00 | 0 | 0 |  | 0 |  |  |  |  | 0.0306 | 0.184
2001-03-31 00:00:00 | 0 | 0 |  | 0 |  |  |  |  | 0.0306 | 0.184
 | BOLD DATE = PIPELINE ACTUALS
 | DAY AHEAD REQUEST = "Schedule 8's" total MW x heat rate estimate of 12.1
 | *  Runs times were over morning peaks, ' Day Ahead Request ' represents gas day (9:00am - 9:00am)
 | All gas purchased at Sta 85 GD plus $0.05
 | Fuel for March equal to 19%
 | No FT purchased for March, IT rate = $0.1840 / mmbtu
Spreadsheet: 0b376e83-6550-4f33-8ccc-eb7a09c0bec3
Sheet: Sheet1

MISC INFO: |  |  | ACLS | 12-13 Stipends
Auditorium 280870 or 280871 | HR Benefits - 6089 | [NAME] | ANES, EM, FCM, INT MED | R1 - 50,000
LR A - 280891; LR B - 280882 | HR - CG640 | Dr. [NAME] | MED/PEDS, NEURO, NS | R2 - 51,500
[NAME] | Fingerprinting CG634 |  | ORTHO, PSYCH, SURG | R3 - 53,000
Cube in Cafeteria - 3283324 | Heather - 6205 | [NAME] |  | R4 - 55,000
[NAME] Jen Basselgia | Donna - 280479 | Domen - 5116 - p1524 - H6512A |  | R5 - 57,000
Catering - 285475 [NAME] |  | Carol Freer - Janice Arana x8801 | ATLS | R6 - 58,500
Events - 285153 [NAME] | Resident 7001 to 7006 | Brechbill - Mary Griffith x8802 | ANES, EM, NS, ORTHO | R7 - 60,000
Environmental Health - p0889 | Fellow 7103 to 7108 |  | SURG
[NAME] | Non ACGME 7100 | Meal Card Code 333 |  | 13-14 Stipends
[NAME] |  | Paper bags: GM01A - 0 5775 | Amelia - 7999 - 13 | R1 - 51,500
Compliance - 6755 | [NAME] |  | Beth - 5168 - 07 | R2 - 52,500
IT Acct Mgt - 4302 or 1604; fax 0261 | 364-8996 or 944-4473 | [NAME]: 1102800 | Colleen - 1368 - 08 | R3 - 54,000
[NAME] |  | PAN: 145099 | Crystal - 8644 - 15 | R4 - 56,000
[NAME]; f 0932; A541 | medical    psu.med3 |  | [NAME] | R5 - 58,000
[NAME] Becky Bock |  |  | [NAME] | R6 - 59,500
Employee Health - 8280 |  |  | Kathy - 7180 - 11 | R7 - 61,000
Spreadsheet: 125116d1318882168-excel-2007-sumif-problem-sumif
Sheet: Sheet2

Item # | Description | Qty
98916 | SCOOP-DECAFF COFFEE-1000i
1110-030 | PLATE COVER RFR TRAY SNSR
1110-030 | PLATE COVER RFR TRAY SNSR
1110-030 | PLATE COVER RFR TRAY SNSR
1110-030 | PLATE COVER RFR TRAY SNSR
1110-081 | METAL FAB LIMITER SWITCH
1110-081 | METAL FAB LIMITER SWITCH
1110-081 | METAL FAB LIMITER SWITCH
1110-081 | METAL FAB LIMITER SWITCH
1110-081 | METAL FAB LIMITER SWITCH
1110-081 | METAL FAB LIMITER SWITCH
1110-081 | METAL FAB LIMITER SWITCH
1110-081 | METAL FAB LIMITER SWITCH
1110-081 | METAL FAB LIMITER SWITCH
1110-081 | METAL FAB LIMITER SWITCH
1110-081 | METAL FAB LIMITER SWITCH
1110-081 | METAL FAB LIMITER SWITCH
1110-081 | METAL FAB LIMITER SWITCH
1110-081 | METAL FAB LIMITER SWITCH
1110-140 | BRACKET DRAIN TANK
1110-140 | BRACKET DRAIN TANK
1110-140 | BRACKET DRAIN TANK
1110-140 | BRACKET DRAIN TANK
1110-144 | DRAWER ELECT HIGH VOLT
1110-144 | DRAWER ELECT HIGH VOLT
1110-144 | DRAWER ELECT HIGH VOLT
1110-144 | DRAWER ELECT HIGH VOLT
1110-151 | BRIDGE WEB 995 2000
1110-151 | BRIDGE WEB 995 2000
1110-151 | BRIDGE WEB 995 2000
1110-151 | BRIDGE WEB 995 2000
Spreadsheet: 2b3e1566-de01-441e-8c2f-fe183b78b3de
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
259070 | 70965 | [NAME] | [NAME] | RSA |  | 00:44:49 | 00:00:00 | 01:23:26 | 00:00:00 | 00:24:39 | 1 | 02:32:54
259070 | 30837 | [NAME] | Babich | RSA |  | 00:51:10 | 00:00:00 | 01:42:04 | 00:00:00 | 00:29:15 | 2 | 03:02:29
259070 | 71931 | [NAME] | Eksteen | RSA |  | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | DNS | 00:00:00
Spreadsheet: 216832d1361903285-which-function-to-find-a-words-in-word-string-and-return-them-example
Sheet: Sheet1

 | What I need | My function | Correct function??
blue car | blue
sport car yellow | yellow
motocycle big |  |  |  |  |  |  |  |  |  |  |  | list of words
green bicycle | green |  |  |  |  |  |  |  |  |  |  | blue
red car | red |  |  |  |  |  |  |  |  |  |  | yellow
[NAME] | white |  |  |  |  |  |  |  |  |  |  | green
sport car |  |  |  |  |  |  |  |  |  |  |  | red
ice cream truck |  |  |  |  |  |  |  |  |  |  |  | white
green car | green |  |  |  |  |  |  |  |  |  |  | etc
etc |  |  |  |  |  |  |  |  |  |  |  | etc
etc |  |  |  |  |  |  |  |  |  |  |  | etc
etc |  |  |  |  |  |  |  |  |  |  |  | etc
etc |  |  |  |  |  |  |  |  |  |  |  | 100+rows
etc
3000 + rows
Spreadsheet: 97567d1296701711-looking-for-formula-that-will-catch-special-rule-abuse-for-the-same-id-copy-of-2011_02_02_reply2-1-
Sheet: Sheet1 (4)

ID | date | SLED |  | check
22 | 2010-01-27 00:00:00 | 2012-01-12 00:00:00 | 2012-01-12 00:00:00
22 | 2010-01-27 00:00:00 | 2012-01-14 00:00:00
22 | 2010-01-27 00:00:00 | 2012-01-17 00:00:00
22 | 2010-01-27 00:00:00 | 2012-01-12 00:00:00
22 | 2010-01-27 00:00:00 | 2012-01-20 00:00:00 |  | error
22 | 2010-01-27 00:00:00 | 2012-01-18 00:00:00
22 | 2010-01-27 00:00:00 | 2012-01-18 00:00:00
22 | 2010-01-27 00:00:00 | 2012-01-20 00:00:00 |  | error
22 | 2010-01-27 00:00:00 | 2012-01-19 00:00:00
22 | 2010-01-28 00:00:00 | 2012-01-19 00:00:00 | 2012-01-19 00:00:00
22 | 2010-01-28 00:00:00 | 2012-01-31 00:00:00 |  | error
22 | 2010-01-28 00:00:00 | 2012-01-28 00:00:00
22 | 2010-01-28 00:00:00 | 2012-02-20 00:00:00 |  | error
22 | 2010-01-28 00:00:00 | 2012-01-21 00:00:00
22 | 2010-01-29 00:00:00 | 2012-01-29 00:00:00
22 | 2010-01-29 00:00:00 | 2012-01-28 00:00:00 | 2012-01-28 00:00:00
22 | 2010-01-29 00:00:00 | 2012-01-28 00:00:00
22 | 2010-01-29 00:00:00 | 2012-02-29 00:00:00
22 | 2010-01-29 00:00:00 | 2012-01-28 00:00:00
Spreadsheet: 679546d1590486488-identify-duplicates-in-2-columns-duplicates
Sheet: Sheet1

100000 | 100000
0.7 | 4140
75903.8 | 62384
0 | 13519.8
4140 | 5759
10000 | 50000
0.5 | 2896
50000 | 0.7
5759 | 4320
2896 | 5759 |  |  | The result should show "Not Found" because there are no second duplicate in Column A
62384 | 9663.6
22910 | 7740
4140 | 4140 |  |  | Second time duplicate. The result should show Row 13 instead of 5
86099.1 | 200000
0.5
Spreadsheet: 130225d1322135156-excel-2007-total-and-the-breakup-exmple_jpr73
Sheet: Raw

Fruit | Store number | Date
switch | Store 1 | 2011-11-24 00:00:00
Board | store 1 | 2011-11-25 00:00:00 |  | Fruit | Date | Store number | Nombre de Store number
Board | Store 1 | 2011-11-24 00:00:00 |  | switch | 2011-11-24 00:00:00 | Store 1 | 1
switch | store 2 | 2011-11-25 00:00:00 |  |  | 2011-11-25 00:00:00 | store 2 | 1
Box | store 2 | 2011-11-24 00:00:00 |  | Total général |  |  | 2
switch | store 1 | 2011-11-22 00:00:00
Spreadsheet: andy_zipper__178__DYNEGY-ICE VOL Apr27
Sheet: ICE-ECC

Enron Canada Corporation
Activity on ICE
UOM | Deals | Volume
 |  |  |  |  |  |  | START | END
Enron Canada Corp.
Commodity Type:  All
Instruments:  All
Trade Dates:  Apr-27-01 thru Apr-27-01
Trade Date | Deal ID | Leg ID | B/S | Product | Hub | Strip | START | END | Option | Strike | Style | Counterparty | Price | Price Units | Qty Per Period | Periods | Total Quantity | Qty Units | Trader
Spreadsheet: 154005d1336146970-conditional-formatting-help-needed-250-cells-with-one-cf-formula-cf-excelforum2
Sheet: Sheet1

1 | 2 | 3 | 4 | 5 | 8 | 9 | 10 | 11 | 14 | 15 | 16 | 17 | 18 | 21 | 22 | 23 | 24 | 25 | 28 | 29 | 30 | 31 | 32
Test
1 | 2 | 4 | 1 | 5 | 8 | 4 | 2 | 6 | 4 | 9 | 1 | 10 | 11 | 12 | 9
Spreadsheet: 139659d1328370861-birthday-birthday
Sheet: Sheet2

 | 0103 | 1998 | BOB
 | 0305 | 1996 | TOM
 | 0506 | 1963 | RAY
 | 0103 | 1987 | GEORGE
 | 0506 | 1958 | CINDY
 | 0908 | 1985 | ROSE
 | 0103 | 1965 | SANDY
 | 1225 | 1988 | CAROL
 | 0506 | 1984 | KENNY
Spreadsheet: 462919d1464248749-div-0-error-work-around-required-test-calc
Sheet: Office

GRADE | LENGTH |  | WIDTH |  | THICKNESS |  | QTY
LD | 1211 | x | 150 | x | 10 | [NAME] | 1000
GRADE | LENGTH |  | WIDTH |  | THICKNESS |  | QTY
 |  | x |  | x |  | [NAME] |  | STACKS | SLABS | PIECES | VOLUME
Spreadsheet: 01d8bb0f-4c19-41fd-ad03-ec9799e1d47b
Sheet: FY 2003 Lease Turnover Analysis

FY 2003 Lease Turnover Analysis
Disposition Of Leases Expiring in FY 2003 | Sq Ft | % of Total Sq Ft | Count | % of Total Count
Leases Scheduled to Expire in FY 2003 | 25234910 | 1 | 1587 | 1
Extended in FY 2003 Beyond FY 2003 | 11755183 | 0.4658301931728704 | 949 | 0.5979836168872086
Renewed During FY 2003 | 3046945 | 0.1207432481431477 | 70 | 0.04410838059231254
Replaced in Same Building with New Leases | 3956697 | 0.1567945754512301 | 248 | 0.1562696912413359
Subtotal | 18758825 | 0.7433680167672482 | 1267 | 0.798361688720857
Leases Terminated | 4134535 | 0.1638418761945258 | 134 | 0.08443604284814114
Leases Moved to Another Leased Building | 2341550 | 0.09279010703822602 | 186 | 0.1172022684310019
Subtotal | 6476085 | 0.2566319832327518 | 320 | 0.201638311279143
Disposition of Leases Expiring After FY 2003
Leases Scheduled to Expire After FY 2003 | 128469357 | 1 | 5731 | 1
Lease Replaced In Same Leased Building After [NAME] | 177736 | 0.001383489449550214 | 21 | 0.003664281975222474
Lease Replaced In Same Leased Building Before Firm Term | 96587 | 0.0007518290918199272 | 6 | 0.001046937707206421
Lease Replaced In Different Leased Building After [NAME] | 486104 | 0.003783812820048597 | 59 | 0.01029488745419647
Lease Replaced In Different Leased Building Before Firm Term | 5119 | 3.984607784718655e-05 | 2 | 0.0003489792357354738
Lease Terminate W/O Lease Replacement After [NAME] | 359894 | 0.002801399558651173 | 45 | 0.00785203280404816
Lease Terminate W/O Lease Replacement Before Firm Term | 145854 | 0.001135321320242928 | 10 | 0.001744896178677369
FY 2003 Lease Turnover
Total Leases At Start of FY 2003 | 153704267 | 1 | 7318 | 1
Same/Replacement Leases Continued Past FY 2003 | 146231211 | 0.9513802957727907 | 6882 | 0.9404208800218639
Same Lease Space Dis-Continued Past FY 2003 (Turnover) | 7473056 | 0.04861970422720926 | 436 | 0.0595791199781361
Spreadsheet: 059ad0ff-b051-4d57-b070-824157fb81cd
Sheet: Contact Info & Definitions

CONTACT:
PA Department of Education
Division of Data Quality
333 Market Street
Harrisburg, PA  17126-0333
[NAME]:  [EMAIL]
Phone:  (717) 787-2644
Fax:  (717) 787-3148
Text Telephone TTY:  (717) 783-8445
PROFESSIONAL STAFF SUMMARY
This workbook contains 2012-13 full- and part-time professional staff counts for all public schools
in Pennsylvania as reported by school districts, area vocational-technical schools, charter schools,
intermediate units and state juvenile correctional institutes.
Average Salaries, Years of Service and Education Level are calculated from full-time staff only.
COUNTY AND STATEWIDE TOTAL NOTES
LEVEL TOTALS ARE DISTINCT WITHIN THE LEVEL:
Local Education Agency (LEA) Level: An individual is only counted once per LEA, regardless of the number of schools or buildings where she or he is employed.
County Level: An individual is only counted once per county, regardless of the number of LEAs where she or he is employed.
State Level: An individual is only counted once per state, regardless of the number of LEAs or counties where she or he is employed.
LEA TYPE CODES
CS - Charter School
CTC - Career Technical Center (AVTS)
IU - Intermediate Unit
SD - School District
SJCI - State Juvenile Correctional Institute
EDUCATION LEVEL CODES
1 - Less than high school graduate
2 - High school graduate
3 - Some college, less than bachelor's degree
4 - Bachelor's degree (includes master's equivalency)
5 - Master's degree
6 - Doctor's degree
SALARY CONTRACT YEAR
All salary data are based on the contract year noted in the LEA Averages worksheet. [NAME] names without footnotes in the LEA Averages worksheet reported salaries based on current contracts.
The contract exceptions footnoted in the LEA Averages worksheet apply to other sheets even though the LEA name is not footnoted.
\1 Salaries are based on a contract that expired during the 2011-12 school year.
\2 Salaries are based on a contract that expired during the 2010-11 school year.
\3 Salaries are based on a contract that expired during the 2009-10 school year.
\4 Salaries are based on a contract that expired during the 2008-09 school year.
Data Source: Pennsylvania Information Management System (PIMS)
2012-13 Professional Staff Collection
2013-05-31 00:00:00
Spreadsheet: 86968d1286903327-combination-question-golf_lineup-1-
Sheet: Roster & Pairings

Golf Outing
A Golfers |  | B Golfers |  | C Golfers |  | D Golfers
1 | Curt | 1 | [NAME] | 1 | Derek | 1 | Brett
2 | [NAME] | 2 | [NAME] | 2 | [NAME] | 2 | Adrian
3 | [NAME] | 3 | Burt | 3 | Marcus | 3 | [NAME]
4 | [NAME] | 4 | Ernie | 4 | [NAME] | 4 | Riley
5 | [NAME] | 5 | Ian | 5 | [NAME] | 5 | [NAME]
6 | [NAME] | 6 | Jimbo | 6 | [NAME] | 6 | Tyler
Day 1 Pairings
Team 1 |  | Team 2 |  | Team 3 |  | Team 4 |  | Team 5 |  | Team 6
1 | Curt | 1 | [NAME] | 1 | [NAME] | 1 | [NAME] | 1 | [NAME] | 1 | [NAME]
2 | [NAME] | 2 | [NAME] | 2 | Burt | 2 | Ernie | 2 | Ian | 2 | Jimbo
3 | Derek | 3 | [NAME] | 3 | Marcus | 3 | [NAME] | 3 | [NAME] | 3 | [NAME]
4 | Brett | 4 | Adrian | 4 | [NAME] | 4 | Riley | 4 | [NAME] | 4 | Tyler
Day 2 Pairings
Team 1 |  | Team 2 |  | Team 3 |  | Team 4 |  | Team 5 |  | Team 6
1 | Curt | 1 | [NAME] | 1 | [NAME] | 1 | [NAME] | 1 | [NAME] | 1 | [NAME]
2 | Jimbo | 2 | [NAME] | 2 | [NAME] | 2 | Burt | 2 | Ernie | 2 | Ian
3 | [NAME] | 3 | [NAME] | 3 | Derek | 3 | [NAME] | 3 | Marcus | 3 | [NAME]
4 | Riley | 4 | [NAME] | 4 | Tyler | 4 | Brett | 4 | Adrian | 4 | [NAME]
Day 3 Pairings
Team 1 |  | Team 2 |  | Team 3 |  | Team 4 |  | Team 5 |  | Team 6
1 | Curt | 1 | [NAME] | 1 | [NAME] | 1 | [NAME] | 1 | [NAME] | 1 | [NAME]
2 | Ian | 2 | Jimbo | 2 | [NAME] | 2 | [NAME] | 2 | Burt | 2 | Ernie
3 | Marcus | 3 | [NAME] | 3 | [NAME] | 3 | [NAME] | 3 | Derek | 3 | [NAME]
4 | Brett | 4 | Brett | 4 | Adrian | 4 | [NAME] | 4 | Riley | 4 | Tyler
Day 4 Pairings
Team 1 |  | Team 2 |  | Team 3 |  | Team 4 |  | Team 5 |  | Team 6
1 | Curt | 1 | [NAME] | 1 | [NAME] | 1 | [NAME] | 1 | [NAME] | 1 | [NAME]
2 | Ernie | 2 | Ian | 2 | Jimbo | 2 | [NAME] | 2 | [NAME] | 2 | Burt
3 | Marcus | 3 | [NAME] | 3 | [NAME] | 3 | [NAME] | 3 | Derek | 3 | [NAME]
4 |  | 4 |  | 4 |  | 4 |  | 4 |  | 4
Spreadsheet: 137709d1327330888-copy-values-from-one-sheet-to-the-other-day1
Sheet: control

 | Date | contract | activity | ressource | quantity
 | 2012-01-02 00:00:00 | testing | 1 | hammer | 1
 | 2012-01-02 00:00:00 | testing | 1 | [NAME] | 1
 | 2012-01-02 00:00:00 | testing | 1 | Worker | 2
 | 2012-01-02 00:00:00 | testing | 1 | Secretary | 3
 | 2012-01-02 00:00:00 | testing | 1 | Director | 8
 | 2012-01-02 00:00:00 | testing | 2 | [NAME] | 3
 | 2012-01-02 00:00:00 | testing | 2 | Secretary | 2
 | 2012-01-02 00:00:00 | testing | 3 | Car | 2
 | 2012-01-02 00:00:00 | testing | 3 | wheels | 6
 | 2012-01-02 00:00:00 | testing | 3 | [NAME] | 1
 | 2012-01-02 00:00:00 | testing | 3 | Director | 2