tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 53293d1253190855-excel-cell-min-and-max-limits-book1
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | Total Cargo Value (USD) | Value exposed to Primary $100m layer | Value exposed to $400m x/s $100m layer | Value exposed to $100m x/s $500m layer
 |  |  |  |  |  |  |  |  | 254000000 | 100000000 | 254000000 | 254000000
 |  |  |  |  |  |  |  |  | 200000 | 200000 | 0 | 0
 |  |  |  |  |  |  |  |  | 750000000 | 100000000 | 400000000 | 500000000
 |  |  |  |  |  |  |  |  | 600000000 | 100000000 | 400000000 | 500000000
 |  |  |  |  |  |  |  |  | 140000000 | 100000000 | 140000000 | 140000000
 |  |  |  |  |  |  |  |  | 520000000 | 100000000 | 400000000 | 500000000
 |  |  |  |  |  |  |  |  | 2264200000
 |  |  |  |  |  |  |  |  | 11568546
 |  |  |  |  |  |  |  |  | 457893.15
 |  |  |  |  |  |  |  |  | 789316.23
 |  |  |  |  |  |  |  |  | 13457894
 |  |  |  |  |  |  |  |  | 4654873
 |  |  |  |  |  |  |  |  | 4576.89
 |  |  |  |  |  |  |  |  | 30933099.27
 |  |  |  |  |  |  |  |  | 11568546
 |  |  |  |  |  |  |  |  | 457893.15
 |  |  |  |  |  |  |  |  | 789316.23
 |  |  |  |  |  |  |  |  | 13457894
 |  |  |  |  |  |  |  |  | 4654873
 |  |  |  |  |  |  |  |  | 4576.89
 |  |  |  |  |  |  |  |  | 30933099.27 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | 11568546
 |  |  |  |  |  |  |  |  | 457893.15
 |  |  |  |  |  |  |  |  | 789316.23
 |  |  |  |  |  |  |  |  | 13457894
 |  |  |  |  |  |  |  |  | 4654873
 |  |  |  |  |  |  |  |  | 30928522.38
 |  |  |  |  |  |  |  |  | 11568546
 |  |  |  |  |  |  |  |  | 457893.15
 |  |  |  |  |  |  |  |  | 789316.23
 |  |  |  |  |  |  |  |  | 12815755.38
 |  |  |  |  |  |  |  |  | 11568546
 |  |  |  |  |  |  |  |  | 457893.15
 |  |  |  |  |  |  |  |  | 12026439.15
 |  |  |  |  |  |  |  |  | 2381836915.45
Spreadsheet: 227580d1365756069-splitting-data-from-cells-examples-included-template-for-data-result
Sheet: Sheet1

Title | Foremane | Surname | Add1 | Add2 | Add3 | Add4 | Postcode | Tel1 | Tel2 | Tel3
Mr | [NAME] | Twoshoes | 1 Green Park Lane | [NAME] | [NAME] | West Yorkshire | BD74  7RE | [PHONE] | [PHONE] | [PHONE]
Mrs | Dawn | Thorn | 18 Horace Street | [NAME] | [NAME] | West Yorkshire | BD25 7RE | [PHONE] | [PHONE] | [PHONE]
Mr | [NAME] | Shaw | 54A Acacia Avenue | [NAME] | [NAME] | West Yorkshire | BD26 7RE | [PHONE] | [PHONE] | [PHONE]
Spreadsheet: 09f63114-4741-4d92-820c-826cb539cfca
Sheet: Sheet1

BA | Business Area (BA) Name | Point of Contact (POC) | POC | POC.1
Number | Name | Name | Phone# | [NAME]
10.. | Aging | [NAME] | (717) 772-7203 | [EMAIL]
11.. | Corrections | [NAME] | (717) 975-4991 | [EMAIL]
12.. | Labor & Industry | [NAME] | (717) 787-6188 | [EMAIL]
13.. | Military & Veterans Affairs | [NAME] | (717) 861-8854 | [NAME]
15.. | General Services | [NAME] | (717) 214-7081 | [NAME]
16.. | Education | [NAME] | (717) 783-9793 | [NAME]
17.. | PUC - Public Utility Commission | [NAME] | 7177876687 | [EMAIL]
18.. | Revenue | [NAME] | (717) 772-9692 | [NAME]
19.. | State | [NAME] | (717) 214-7081 | [NAME]
20.. | State Police | [NAME] | (717) 540-5050 | [EMAIL]
21.. | DPW - Public Welfare | [NAME] | (717) 772-7203 | [EMAIL]
22.. | Fish & Boat Commission | [NAME] | 7177057903 | [EMAIL]
23.. | Game Commission | [NAME] | 7177875670 | [EMAIL]
24.. | DCED - Community&Economic Development | [NAME] | (717) 720-1390 | [NAME]
25.. | Probation & Parole | [NAME] | (717) 787-5699 | [NAME]
26.. | LCB - Liquor Control Board | [NAME] | (717) 787-6645 | [EMAIL]
27.. | Milk Marketing | [NAME] | (717) 787-4647 | [EMAIL]
28.. | Lieutenant Gov. Office | [NAME] | (717) 214-7081 | [NAME]
30.. | Historical & Museum Commission | [NAME] | (717) 214-7081 | [NAME]
31.. | PEMA - PA Emergency Management Agency | [NAME] | (717) 214-7081 | [NAME]
32.. | Civil Service | [NAME] | (717) 787-6976 | [EMAIL]
33.. | PIIA - PA Infrastructure Investment Authority | [NAME] | (717) 705-4473 | [NAME]
35.. | DEP - Environmental Protection | [NAME] | (717) 705-4018 | [EMAIL]
36.. | State Tax Equalization Board | [NAME] | (717) 787-5950 | [NAME]
37.. | Environmental Hearing Board | [NAME] | (717) 783-4741 | [NAME]
38.. | DCNR - Conservation&Natural Resources | [NAME] | (717) 787-5415 | [EMAIL]
40.. | Ethics Commission | [NAME] | 7177831610 | [EMAIL]
65.. | Gaming Board | [NAME] | (717) 772-9691 | [EMAIL]
66.. | PSC - PA Securities Commission | [NAME] | (717) 783-2378 | [EMAIL]
67.. | Health | [NAME] | (717) 703-5772 | [NAME]
68.. | Agriculture | [NAME] | (717) 787-9394 | [NAME]
70.. | SERS - State Emp. [NAME]. | [NAME] | (717) 237-0350 | [EMAIL]
71.. | PA Municipal Retirement Board | Maryann Fischer | (717) 787-2065 | [EMAIL]
72.. | PSERS - Public School Emp. [NAME]. | [NAME] | (717) 720-4766 | [NAME]
75.. | Banking | [NAME] | (717) 783-8241 | [NAME]
78.. | DOT - PennDot | [NAME] | (717) 772-3333 | [NAME]
79.. | Insurance | [NAME] | (717) 787-6469 | [NAME]
81.. | OA - Office of Administration | [NAME] | (717) 214-7081 | [NAME]
81.. | OB - Office of Budget | [NAME] | (717) 214-7081 | [NAME]
81.. | OIG - Inspector General | [NAME] | (717) 783-7756 | [NAME]
81.. | PCCD - PA Commission on Crime & Delinquency | [NAME] | (717) 787-5152 | [EMAIL]
81.. | HRC - Human Relations Commission | [NAME] | (717) 772-2210 | [NAME]
99.. | Governor's Office | [NAME] | (717) 787-5330 | [NAME]
Spreadsheet: 861667d1709553818-search-book1-26-
Sheet: Sheet2

Program | Days and Times | Concat | Participants | Staff | Hours | Apportion of Shift | In Activity Transport | Transport Cost
Day Community Break | Monday 09:00 to 15:00 |  |  | 2 |  |  | Transport 0-10 km
Digital Fun | Monday 09:00 to 15:00 |  |  | 1
[NAME] | Monday 15:00 to 17:30 |  |  | 1
Meal Masters | Tuesday 09:00 to 12:00 |  |  | 1
Let's Get Moving | Tuesday 12:00 to 15:00 |  |  | 1 |  |  | Transport 10-20 km
Life Skills | Wednesday 09:00 to 15:00 |  |  | 1 |  |  | Transport 10-20 km
Evening Gym Program | Wednesday 19:00 to 20:00 |  |  | 2
Out and About Community Connections | Thursday 09:00 to 15:00 |  |  | 1 |  |  | Transport 40-100 km
Evening Social Club | Thursday 18:30 to 21:30 |  |  | 5 |  |  | Transport 0-10 km
Art and Games | Friday 09:00 to 12:00 |  |  | 1
Sports and Recreation | Friday 12:00 to 15:00 |  |  | 1 |  |  | Transport 10-20 km
Saturday Recreational Program | Saturday 09:00 to 15:00 |  |  | 2 |  |  | Transport 40-100 km
Transport AM 1 | Monday 07:30 to 09:00 |  |  | 1 |  |  | Transport 20-40 km
Transport AM 2 | Tuesday 08:15 to 09:00 |  |  | 1 |  |  | Transport 20-40 km
Transport AM 3 | Wednesday 07:30 to 09:00 |  |  | 1 |  |  | Transport 40-100 km
Transport AM 4 | Thursday 08:00 to 09:00 |  |  | 1 |  |  | Transport 20-40 km
Transport AM 5 | Friday 07:45 to 09:00 |  |  | 1 |  |  | Transport 40-100 km
Transport AM 6 | Friday 07:30 to 09:00 |  |  | 1 |  |  | Transport 20-40 km
Transport PM 1 | Monday 15:00 to 16:30 |  |  | 1 |  |  | Transport 20-40 km
Transport PM 2 | Tuesday 15:00 to 15:45 |  |  | 1
Transport PM 3 | Wednesday 15:00 to 16:30 |  |  | 1 |  |  | Transport 40-100 km
Transport PM 4 | Thursday 15:00 to 15:45 |  |  | 1
Transport PM 5 | Friday 15:00 to 16:15 |  |  | 1 |  |  | Transport 20-40 km
Transport PM 6 | Friday 15:00 to 16:30 |  |  | 1
[NAME] | Monday 14:15 to 15:00 |  |  | 1 |  |  | Transport 10-20 km
[NAME] | Monday 17:15 to 18:00 |  |  | 1
[NAME] | Monday 17:15 to 18:45 |  |  | 1 |  |  | Transport 40-100 km
Evening Transport Gym | Wednesday 18:00 to 19:00 |  |  | 1 |  |  | Transport 40-100 km
Evening Transport Gym | Wednesday 20:00 to 21:00 |  |  | 1 |  |  | Transport 40-100 km
Evening Transport Social 1 | Thursday 17:15 to 18:30 |  |  | 1 |  |  | Transport 40-100 km
Evening Transport Social 2 | Thursday 17:15 to 18:30 |  |  | 1 |  |  | Transport 40-100 km
Evening Transport Social 3 | Thursday 17:30 to 18:30 |  |  | 1 |  |  | Transport 40-100 km
Evening Transport Social 1 | Thursday 21:30 to 22:45 |  |  | 1 |  |  | Transport 40-100 km
Evening Transport Social 2 | Thursday 21:30 to 22:45 |  |  | 1 |  |  | Transport 40-100 km
Evening Transport Social 3 | Thursday 21:30 to 22:30 |  |  | 1 |  |  | Transport 40-100 km
Saturday Transport AM | Saturday 09:00 to 10:00 |  |  | 1 |  |  | Transport 20-40 km
Saturday Transport PM | Saturday 15:00 to 16:00 |  |  | 1 |  |  | Transport 20-40 km
Spreadsheet: 739503d1625747214-xlookup-more-than-3-results-from-data-set-multiple-lookup-populating-a-calendar
Sheet: DATA

Project | Type | Trial begins | Rollout begins | Trial Start Lookup (Year/Week) | Rollout Start Lookup (Year/Week)
Project 1 | 1 | 2021-07-24 00:00:00 | 2021-07-02 00:00:00
Project 2 | 1 | 2021-08-24 00:00:00 | TBC
Project 3 | 1 | 2021-08-25 00:00:00 | 2021-09-13 00:00:00
Project 4 | 1 | 2021-09-01 00:00:00 | TBC
Project 5 | 1 | 2021-09-02 00:00:00 | TBC
Project 6 | 1 | 2021-10-03 00:00:00 | TBC
Project 7 | 1 | 2021-10-04 00:00:00 | TBC
Project 8 | 1 | 2021-11-05 00:00:00 | TBC
Project 9 | 1 | 2021-11-06 00:00:00 | 2022-01-01 00:00:00
Project 10 | 1 | 2021-11-07 00:00:00 | N/A
Project 11 | 1 | 2021-12-08 00:00:00 | 2022-07-01 00:00:00
Project 12 | 1 | 2021-12-09 00:00:00 | 2022-07-01 00:00:00
Project 13 | 1 | N/A | 2022-05-01 00:00:00
Project 14 | 2 | N/A | 2022-01-01 00:00:00
Project 15 | 2 | N/A | 2022-01-01 00:00:00
Project 16 | 2 | N/A | 2022-01-01 00:00:00
Project 17 | 2 | N/A | 2021-11-02 00:00:00
Project 18 | 2 | N/A | 2021-10-15 00:00:00
Project 19 | 2 | N/A | TBC
Project 20 | 2 | N/A | 2021-09-01 00:00:00
Project 21 | 2 | N/A | 2021-09-01 00:00:00
Project 22 | 2 | N/A | 2021-09-02 00:00:00
Project 23 | 2 | N/A | 2021-10-27 00:00:00
Project 24 | 2 | N/A | 2021-09-02 00:00:00
Spreadsheet: 45742d1244558236-help-consolidating-data-from-multiple-rows-book1-example
Sheet: Example

Store | Chair | Lamp | Desk | Table | Bed
Ikea |  |  |  |  | 2002-06-04 00:00:00
Ikea |  |  | 2007-01-28 00:00:00
Ikea |  | 2008-04-08 00:00:00
Ikea |  |  |  | 2009-06-02 00:00:00
Ikea | 2004-02-08 00:00:00
Office Max | 2009-11-14 00:00:00
Office Max | 2007-11-12 00:00:00
Office Max |  |  | 2007-12-08 00:00:00
Home Depot |  |  |  | 2009-01-14 00:00:00
Home Depot |  |  | 2005-10-15 00:00:00
Sears | 2008-09-01 00:00:00
Sears |  |  |  | 2002-06-07 00:00:00
Sears |  | 2008-01-14 00:00:00
Sears |  |  | 2007-01-08 00:00:00
Sears |  | 2007-09-08 00:00:00
Spreadsheet: 473475d1470233668-stage-progression-example
Sheet: Sheet1

level | s | n | Test 1 | Test 2 | Test 3 | Test 1 | Test 2 | Test 3 | Test 1 | Test 2 | Test 3
 | Doe | [NAME] | 2015-06-01 00:00:00 | 2015-07-01 00:00:00 | 2015-08-01 00:00:00 | 2015-09-01 00:00:00 | 2015-10-01 00:00:00 | 2015-11-01 00:00:00 | 2015-12-01 00:00:00
 | Smith | [NAME] | 2015-11-01 00:00:00 | 2015-12-01 00:00:00 | 2016-01-01 00:00:00 | 2016-02-01 00:00:00
 | Jones | [NAME] | 2016-04-01 00:00:00
Spreadsheet: john_forney__15539__fronteracalc
Sheet: frontcalc

 |  |  |  |  |  |  | 2001-09-28 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FRONTERA
 |  |  |  |  |  |  |  |  | PROPOSED |  |  |  |  |  |  | ACTUAL | GENERATION
 | FRONTERA GEN CALC |  |  |  |  |  |  |  | DAILY SALE |  |  | DAILY SALE REVENUE |  | FINANCIAL SWAP EXPENSE |  | GENERATION | EXPENSE
 |  |  |  |  |  |  | HE1 |  |  |  |  |  |  | BUY FIXED, SELL FLOAT
 |  |  |  |  |  |  | HE2 | 30 | 4
 | 1.9 | HSC Gas Cost |  |  |  |  | HE3 | 30 | 4
 | 7.7 | heat rate |  |  |  |  | HE4 | 135 | 4
 | 0.22 | gas transport* | (.10 late schedule penalty) |  |  |  | HE5 | 200 | 4
 |  |  |  |  |  |  | [NAME] | 280 | 4
 |  |  |  |  |  |  | HE7 |  |  |  | 340 | 21 |  |  | 20
 | 2.75 | O&M |  |  |  |  | HE8 |  |  |  | 340 | 21 |  |  | 20
Cost to Gen |  |  |  |  |  |  | HE9 |  |  |  | 340 | 21 |  |  | 20
 |  |  |  |  |  |  | HE10 |  |  |  | 340 | 21 |  |  | 20
 |  |  |  |  |  |  | HE11 |  |  |  | 340 | 21 |  |  | 20
 |  |  |  |  |  |  | HE12 |  |  |  | 340 | 21
 |  |  |  |  |  |  | HE13 |  |  |  | 340 | 21
 |  |  |  |  |  |  | HE14 |  |  |  | 340 | 21
 |  |  |  |  |  |  | HE15 |  |  |  | 340 | 21
 |  |  |  |  |  |  | HE16 |  |  |  | 340 | 21
 |  |  |  |  |  |  | HE17 |  |  |  | 340 | 21
 |  |  |  |  |  |  | HE18 |  |  |  | 340 | 21
 |  |  |  |  |  |  | HE19 |  |  |  | 340 | 21
 |  |  |  |  |  |  | HE20 |  |  |  | 340 | 21
 |  |  |  |  |  |  | HE21 |  |  |  | 340 | 21
 |  |  |  |  |  |  | HE22 |  |  |  | 340 | 21
 |  |  |  |  |  |  | HE23
 |  |  |  |  |  |  | HE24
 |  |  |  |  |  |  |  | SCENARIO I
 |  |  |  |  |  |  |  |  |  |  | SCENARIO II
Spreadsheet: 76614d1277155159-nesting-more-than-7-if-then-statements-without-using-vlookup-grade-template2
Sheet: DO NOT ALTER(2)

0 | F
1 | D
1.3 | [NAME]
1.7 | C-
2 | C
2.3 | C+
2.7 | B-
3 | B
3.3 | [NAME]
3.7 | A-
4 | A
Spreadsheet: 292600d1390680003-faster-way-than-deleting-columns-one-by-one-to-reduce-my-data-to-the-correct-columns-master2-new-example
Sheet: Master

Timestamp | First name | Last Name | Phone # (with area code) | Guardian Name(s) | [NAME] | Street Address | City | State (two letter) | Zip Code | Departing School | Cumulative GPA | What is your School's GPA range?
1 | first1 | last1 | [NAME] | guard1 | email1 | street1 | city1 | state1 | [NAME] | school1 | gpa1 | range1
1.1 | first2 | last2 | phone2 | guard2 | [NAME] | street2 | city2 | state2 | zip2 | [NAME] | gpa2 | range2
1.2 | first3 | [NAME] | [NAME] | guard3 | [NAME] | street3 | city3 | state3 | zip3 | school3 | gpa3 | range3
Spreadsheet: 867547d1714392392-find-the-corresponding-numbers-for-english-letters-separately-ex429
Sheet: Sheet1

 | A | B | C | D | E
 | 1 | 2 | 3 | 4 | 5
AAB | 4
AB | 3
ABC | 6
CDE | 12
EE | 10
Spreadsheet: 797082d1663697064-macro-which-removes-the-rows-other-than-starting-with-a-number-macro-which-deletes-the-other-cells-than-starting-with-number
Sheet: Sheet1

0:00:00 Orchestral Suite No. 3 in D Major, BWV 1068: II. Air on the G String |  |  |  |  |  |  |  |  | 0:00:00 Orchestral Suite No. 3 in D Major, BWV 1068: II. Air on the G String
Metamorphose [NAME], [NAME] |  |  |  |  |  |  |  |  | 0:05:49 Cantata, BWV 147: Jesu, Joy of Man's Desiring
 |  |  |  |  |  |  |  |  | 0:10:06 Ave [NAME], CG 89a
0:05:49 Cantata, BWV 147: Jesu, Joy of Man's Desiring |  |  |  |  |  |  |  |  | 0:14:50 Keyboard Concerto No. 5 in F Minor, BWV 1056: II. Largo
Metamorphose [NAME], [NAME]
0:10:06 Ave [NAME], CG 89a
Metamorphose [NAME], [NAME]
0:14:50 Keyboard Concerto No. 5 in F Minor, BWV 1056: II. Largo
Metamorphose [NAME], [NAME]
[NAME], piano
0:17:52 The Well-Tempered Clavier, Book I: No. 1, Prelude in C Major, BWV 846
[NAME]
0:19:46 [NAME], BWV 208: Sheep May Safely Graze
[NAME]
0:23:55 The Well-Tempered Clavier, Book I: Prelude in E Minor, BWV 855a (Arr. for [NAME] by [NAME])
Vadim Chaimovich
0:28:18 French Suite No. 3 in B Minor, BWV 814: III. Sarabande
Vadim Chaimovich
[NAME], Op. 4, BWV 988: Aria
[NAME]
0:37:36 Brandenburg Concerto No. 3 in G Major, BWV 1048: II. Adagio
[NAME], [NAME]
0:38:02 Suite No. 2 in B Minor, BWV 1067: III. Sarabande
[NAME], [NAME], [NAME]
0:41:00 Suite No. 2 in B Minor, BWV 1067: [NAME]
[NAME], [NAME]
[NAME], flute
0:44:26 Suite No. 2 in B Minor, BWV 1067: VI. Minuetto
[NAME], [NAME]
[NAME], flute
0:45:40 Cello Suite No. 1 in G Major, BWV 1007: I. Prélude
Nadia David
0:48:22 [NAME] No. 1 in G Major, BWV 1007: II. Allemande
Nadia David
0:52:54 [NAME] No. 1 in G Major, BWV 1007: IV. Sarabande
Nadia David
0:55:50 Chorale Prelude 'Ich ruf zu dir, [NAME], BWV 639 (Arr. for [NAME] by [NAME])
Vadim Chaimovich
0:59:17 French Suite No. 5 in G Major, BWV 816: III. Sarabande
Vadim Chaimovich
1:04:58 Concerto No. 3 (After Alessandro Marcello's Concerto for [NAME] and Strings) in D Minor, BWV 974: II. Adagio
Vadim Chaimovich
1:09:46 Notebooks for Anna Magdalena Bach: Menuet in G Minor, BWV Anh. 114
Giovanni Umberto Battel
1:11:03 Orchestral Suite No. 3 in D Major, BWV 1068: II. Air on [NAME] (Arr. for [NAME])
Giovanni Umberto Battel
1:17:24 The Well-Tempered Clavier, Book 1, Prelude and Fugue No 16 in G Minor, BWV 861
[NAME]
1:22:14 Goldberg-Variationen, Op. 4, BWV 988: Variation 12, Canone alla Quarta
[NAME]
1:25:22 Goldberg-Variationen, Op. 4, BWV 988: Variation 13
[NAME]
1:29:57 Keyboard Concerto No. 2 in E Major, BWV 1053: II. Siciliano
Metamorphose [NAME], [NAME]
[NAME], piano
1:35:19 Keyboard Concerto No. 3 in D Major, BWV 1054: II. Adagio
Metamorphose [NAME], [NAME]
[NAME], piano
1:41:38 Keyboard Concerto No. 7 in G Minor, BWV 1058: II. Andante
Metamorphose [NAME], [NAME]
[NAME], piano
1:47:50 Cello Suite No. 2 in D Minor, BWV 1008: IV. Sarabande
Nadia David
1:52:23 Cello Suite No. 3 in C Major, BWV 1009: IV. Sarabande
Nadia David
Spreadsheet: 709124d1608175541-adding-shipment-quantities-to-get-future-arrival-dates-inventory-status-example
Sheet: Availability

 | Model # |  | Next Arriving Qty | Next 'Arriving Qty Date' | Next Availability Date
 | P12-A-168 | -145
 | P12-A-168-RK | 339
 | P12-ADI-A | 0
 | P12-BIKE-DLC15 | -2
 | P12-BIKE-DLC25 | 4
 | P12-BIKE-DLC35 | -5
 | P12-BIKE-GPIO | 6
 | P12-BIKE-KB0 | -5
 | P12-BIKE-KB48 | 5
 | P12-BIKE-KB64 | -2
 | P12-BIKE-KKB32 | 7
 | P12-BIKE-KKB48 | 5
 | P12-BIKE-KKB64 | -6
 | P12-CTZ100 | -1
 | P12-LK012 | -2
 | P12-LK012-RK | 0
 | P12-LK164-W | 18
 | P12-LK168 | -109
 | P12-M-MADI2-A | -96
 | P12-MDS-16 | -1
 | P12-M-R24-AN | -16
 | P12-M-S4-A | -3
 | P12-M-S-A | -1
 | P12-VC11333 | 4
 | P12-VC11334 | 14
 | P12-VC9458 | -226
Spreadsheet: 830535d1684959444-combing-unique-values-from-duplicate-rows-horizontally-samplespreadsheet
Sheet: How I want it look

ID # | Student Name | Grade Level | Course Name | Teacher Name | Grade | Percent | Course Name | Teacher Name | Grade | Percent | Course Name | Teacher Name | Grade | Percent
Spreadsheet: 477397d1472271723-how-to-count-the-datas-from-multiple-range-procurement-initiatives_pmo-tracker_260816
Sheet: Sheet2

 | RM |  |  | Closed |  |  | Closed |  |  | Closed |  |  | Closed
 | Month |  | 1st week |  |  | 2nd week |  |  | 3rd week |  |  | 4th week
 |  |  | Target | Actual |  | Target | Actual |  | Target | Actual |  | Target | Actual
 | APR
 | MAY
 | JUN
 | JULY
 | AUG |  |  |  |  | 3 | 3
 | SEP
 | OCT
 | NOV
 | DEC
 | JAN
 | FEB
 | MAR
 | PM |  |  | Closed |  |  | Closed |  |  | Closed |  |  | Closed
 | Month |  | 1st week |  |  | 2nd week |  |  | 3rd week |  |  | 4th week
 |  |  | Target | Actual |  | Target | Actual |  | Target | Actual |  | Target | Actual
 | APR
 | MAY
 | JUN
 | JULY
 | AUG
 | SEP
 | OCT
 | NOV
 | DEC
 | JAN
 | FEB
 | MAR
Spreadsheet: 764012d1642526854-order-scheduler-formula-help-required-please-order-schedule-test-jt
Sheet: WK2

Product Code | Description | Order | [NAME] | Date Required (Week Commencing) |  | New Order | Amended Order | Delayed | Rought forward
Product 1 |  | 468550 | 2000 | 2021-12-13 00:00:00
Product 10 |  | 456820 | 3042 | 2022-02-07 00:00:00
Product 10 |  | 477069 | 4000 | 2022-03-14 00:00:00
Product 2 |  | 469944 | 1850 | 2022-01-24 00:00:00
Product 3 |  | 468542 | 1820 | 2022-01-10 00:00:00
Product 3 |  | 472923 | 1820 | 2022-01-17 00:00:00
Product 3 |  | 479841 | 1820 | 2022-03-07 00:00:00
Product 4 |  | 469945 | 1820 | 2022-01-17 00:00:00
Product 4 |  | 477064 | 1820 | 2022-01-31 00:00:00
Product 4 |  | 478386 | 1820 | 2022-03-07 00:00:00
Product 4 |  | 478387 | 1820 | 2022-03-28 00:00:00
Product 5 |  | 477065 | 2028 | 2022-02-21 00:00:00
Product 6 |  | 467287 | 3042 | 2022-01-24 00:00:00
Product 6 |  | 481161 | 3042 | 2022-02-07 00:00:00
Product 6 |  | 481162 | 3042 | 2022-03-07 00:00:00
Product 7 |  | 439127 | 3042 | TBC
Product 7 |  | 442911 | 3042 | TBC
Product 7 |  | 444593 | 3042 | TBC
Product 8 |  | 463348 | 3042 | 2022-02-17 00:00:00
Product 9 |  | 477067 | 2704 | 2022-02-07 00:00:00
Product 9 |  | 477068 | 2660 | 2022-02-28 00:00:00
Product 9 |  | 479842 | 2704 | 2022-03-21 00:00:00
Spreadsheet: f7f322f4-cb42-41d9-b16f-1d3804ade8a5
Sheet: Sheet1

School District | School Building | IRN | Contact First Name | ConTact Last Name | Address 1 | City | State | Zip
Ashtabula Area SD | Lakeside Jr. High School | 43513 | [NAME] | Spence | 401 W 44th Street | Ashtabula | OH | 44005-0290
Bedford City Schools | Central Primary School | 43562 | [NAME] | [NAME] | 481 Northfield Rd | Bedford | OH | 44146
[NAME] | Ridgeview Elementary School | 45856 | [NAME] | Hasek | 3436 Edgewood Dr | Ashtabula | OH | 44004-5967
Canton City Schools | Summit Elementary School | 43711 | [NAME] | Krane | 617 Mckinley Ave SW | Canton | OH | 44707-4798
Canton Local | [NAME] | 49833 | Roberta | Leahy | 4526 Ridge Ave SE | Canton | OH | 44707-1118
Cincinnati Public Schools | Winton Hills Academy | 43752 | [NAME] | Kelly | 2315 Iowa Avenue | Cincinnati | OH | 45206
Cincinnati Public Schools | Burton Elementary School | 43752 | [NAME] | Kelly | 2315 Iowa Avenue | Cincinnati | OH | 45206
Clearview Local Schools | [NAME] | 48132 | [NAME] | [NAME] | 4700 Broadway | Lorain | OH | 44052-5542
Conneaut Area City School | [NAME] | 43810 | [NAME] | Antila | 400 [NAME] | [NAME] | OH | 44030-2794
Federal Hocking | Coolville Elementary School | 45914 | [NAME] | Linscott | PO Box 117 | [NAME] | OH | 45778-0117
Gahanna-Jefferson Public Schools | Goshen [NAME] | 46961 | [NAME] | Mc Cafferty | 160 [NAME] Rd | Gahanna | OH | 43230
Huntington Local SD | Huntington Elmentary School | 49502 | June | Shelton | 188 Huntsman Rd | Chillicothe | OH | 45601-9378
LaBrae Local Schools | LaBrae Middle School | 50245 | [NAME] | Jones | 1001 N [NAME] | [NAME] | OH | 44430-9644
Liberty Local SD | [NAME] | 50195 | [NAME] | Dorbish | 4115 [NAME] Rd | Youngstown | OH | 44505-1353
[NAME] | [NAME] | 48520 | [NAME] | Meier | 41765 Pomeroy Pike | Pomeroy | OH | 45769-0272
New Lexington City Schools | New Lexington ES | 44479 | [NAME] | Braglin | 101 Third Ave. | New Lexington | OH | 43764
New Miami Local SD | New Miami Local Schools | 46136 | [NAME] | Dotson | 600 Seven Mile Ave | [NAME] | OH | 45011
Plain Local SD | Avondale Elementary School | 49932 | Carrie | Beegle | 2300 Schneider Road | Canton | OH | 44721
Princeton City School District | Heritage Hill ES | 44677 | [NAME] | Bass-Wiley | 25 W Sharon Rd | Cincinnati | OH | 45246-4322
Quest Academy | Quest Academy | 133363 | Karin | Mears | 190 E. Eighth St. | Lima | OH | 45804
[NAME] | West Main ES | 44685 | [NAME] | Grant | 315 North Walnut Street | [NAME] | OH | 44266
Scioto County Jt Voc SD | Scioto County Jt Voc School | 51490 | Judi | Schott | 951 Vern Riffe Dr | Lucasville | OH | 45648
Southwest Licking Local SD | Pataskala Elementary School | 48041 | [NAME] | Riley | PO Box 180 | Etna | OH | 43018-0180
[NAME] | Cornerstone ES | 45120 | [NAME] | Lewis | 144 N Market St | Wooster | OH | 44691-4810
Zenith Academy | Zenith Academy | 725 | Ashfaq | Tashfeen | 8210 [NAME] | Blacklick | OH | 43004