tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 34388d1231609063-matching-name-then-adding-book1-1-
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Amount Won
[NAME] | 152 | √ | 189 | √ | 180 | √ | 169 | √ | 178 | √ | 168 | √ |  |  |  |  |  |  |  |  |  |  |  |  | 35
[NAME] |  |  |  |  |  |  | 140 | √ | 188 | √ | 206 | √ | 181 | √ | 132 | √ | 214 | √ | 175 | √ | 215 | √ | 144 | √ | 40
[NAME] |  |  |  |  |  |  | 170 | √ | 156 | √ | 143 | √ | 170 | √ | 180 | √ | 171 | √ | 164 | √ | 134 | √ | 145 | √ | 0
Gayle | 209 | √ | 156 | √ | 155 | √ | 176 | √ | 157 | √ | 175 | √ | 201 | √ | 185 | √ | 226 | √ | 156 | √ | 175 | √ | 167 | √ | 0
George |  |  |  |  |  |  |  |  |  |  |  |  | 183 | √ | 212 | √ | 173 | √ | 212 | √ | 194 | √ | 223 | √ | 80
Ian T | 216 | √ | 177 | √ | 170 | √ | 220 | √ | 188 | √ | 158 | √ | 224 | √ | 207 | √ | 269 | √ | 199 | √ | 221 | √ | 196 | √ | 160
Ian |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 146 | √ | 162 | √ | 182 | √ | 0
[NAME] | 165 | √ | 153 | √ | 173 | √ |  |  |  |  |  |  | 213 | √ | 145 | √ | 184 | √ |  |  |  |  |  |  | 0
[NAME] | 239 | √ | 182 | √ | 184 | √ | 198 | √ | 163 | √ | 201 | √ | 140 | √ | 146 | √ | 149 | √ | 171 | √ | 175 | √ | 185 | √ | 35
[NAME] | 212 | √ | 165 | √ | 170 | √ | 170 | √ | 193 | √ | 154 | √ | 194 | √ | 237 | √ | 203 | √ | 196 | √ | 182 | √ | 201 | √ | 80
[NAME] | 178 | √ | 168 | √ | 201 | √ | 208 | √ | 158 | √ | 166 | √ |  |  |  |  |  |  |  |  |  |  |  |  | 35
 | [NAME] |  |  |  | 239 | 35 | Ian T |  |  |  | 220 | 40 | Ian T |  |  |  | 224 | 40 | George |  |  |  | 212 | 40
 | [NAME] |  |  |  | 189 | 35 | [NAME] |  |  |  | 193 | 40 | [NAME] |  |  |  | 237 | 40 | Ian T |  |  |  | 221 | 40
 | [NAME] |  |  |  | 201 | 35 | [NAME] |  |  |  | 206 | 40 | Ian T |  |  |  | 269 | 40 | George |  |  |  | 223 | 40
Spreadsheet: 831203d1685498098-sumifs-and-subtotal-issue-subtotal-and-pivot-table-bvj-
Sheet: Pivot table Option (on sheet1)

Accounting Period | 2023002
 | Currency Code
 | AED |  | CAD |  | USD |  | Total  USD | Total base currency
Year | USD | base currency | USD | base currency | USD | base currency
ANAP
2023
Qtr1 |  |  | 13127.47 | 17574.58 | 144.9500000000001 | 135.1199999999997 | 13272.42 | 17709.7
NADYETI
2023
Qtr1 | 12926.96 | 11901.98 |  |  |  |  | 12926.96 | 11901.98
Grand Total | 12926.96 | 11901.98 | 13127.47 | 17574.58 | 144.9500000000001 | 135.1199999999997 | 26199.38 | 29611.68
Spreadsheet: 835332d1688505928-use-of-indirect-i-think-11-for-test
Sheet: Summary

Round 1
Time Slot
Attendees
Job satisfaction
Action points
Round 2
Time Slot
Attendees
Job satisfaction
Key action points
Spreadsheet: 7fa4d033-e696-4b3f-bbdc-02b2f92a1eac
Sheet: Sheet1

Special Education Maintenance of Effort and Excess Costs Calculations FY13 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
Gifted Expenditures | 2010-11 Actual |  | 2011-12 Actual |  | 2012-13 Budgeted
 | FTE | $ | FTE | $ | FTE | $
Professional Salaries
Paraeducator Salaries
Administrative Salaries
Employee Benefits
Instructional Materials & Equipment from Code 30-Interlocal and districts or Code 78-Cooperative
Transportation from Code 30-Interlocal and districts or Code 78-Cooperative
TOTALS for Year * | 0 | 0 | 0 | 0 | 0 | 0
Special Education Maintenance of Effort |  | 10-11 Actual |  | 11-12 Actual |  | 12-13 Budgeted
Line 7a. District funds expended for Special Education:
Line 7b. Additional Special Ed expenditures from funds other than special ed Code 30 (transportation, equipment, etc.).
Line 7c. Special Ed audit corrections, adjusted upward from CPA audit, if not already included in funds:
Line 7d. Special Ed audit corrections, adjusted downward from CPA audit, if not already included in funds:
7e.  Subtotal of district special ed expenditures |  | 0 |  | 0 |  | 0
Special Education Revenue and Adjustments
Line 8a. All  VI-B special education federal funds drawn down
Line 8b. FY10 and FY11 enter all special education federal revenue included in 8a, but not expended during that year (VI-B Code 30, Line 55; Other Code 30, Line 65):
8c.  Enter federal carry-over funds received in prior year, but expended in next year. (District enters federal carry-over funds from year 2008-09 into year 2009-10,  Program enters amount from line 8b for 2010-11 and 2011-2012.) |  |  |  | 0 |  | 0
8d.  Total Federal Funds expended |  | 0 |  | 0 |  | 0
Line 9. Total Gifted Expenditures from Gifted Expenditure Report: |  | 0 |  | 0 |  | 0
Line 10. ALL Part C expenditures if reported in special ed Code 30. |  |  |  | 0 |  | 0
50% Reduction Rule and Allowable Exceptions
Line 11. Available 50% MOE Reduction Rule based on % of increase in federal funds. (District was at Meets Requirements as of July 1, 2010) LEA enters 10-11 amount taken)
Allowable Exceptions (Per 34 [NAME] 300.204) Requires Prior Approval by KSDE SES Team |  |  |  | 0
STATE AND LOCAL MAINTENANCE OF EFFORT |  |  | Adjusted |  | 11-12 MOE Level
 |  |  | 11-12 MOE Level |  | Met/Not Met?
Line 12.  STATE AND LOCAL EFFORT: |  | 0 | 0 | 0 | NO | 0
Line 13. 12/1 Special Education Child Count:
Line 14. Per Pupil Expenditure for Special Education:
[NAME] OF EFFORT
Line 15. Total State Aid Minus Gifted and [NAME]: |  |  |  |  |  | 0
Line 16. Special Education Local Effort: |  | 0 | 0 | 0 | NO | 0
Line 17. Per Pupil  Local Effort:
Spreadsheet: 268719d1380752289-pilot-logbook-index-and-match-flightnduty
Sheet: BLANK

Pilot: | ST
Duty | Flight |  |  | In the last 30 days |  |  |  | IF Hours | Days off
30 Days | 7 Days | 28 Days | 90 Days | NDB | VOR | LOC | GPS | 30 Days | Last Day Off |  | Last 2 Days Off
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Consecutive Days
Date | Aircraft | Type | Flight Hours | T/O & LDG | IF | NDB | VOR | LOC | GPS | Sign On | Sign Off | Sign On | Sign Off | Duty Hours | Day On |  | Days Off | Dates Off
2013-09-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
2013-09-02 00:00:00
2013-09-03 00:00:00
2013-09-04 00:00:00
2013-09-05 00:00:00
2013-09-06 00:00:00
2013-09-08 00:00:00
2013-09-09 00:00:00
2013-09-10 00:00:00
2013-09-11 00:00:00
2013-09-12 00:00:00
2013-09-13 00:00:00
2013-09-15 00:00:00
2013-09-16 00:00:00
2013-09-17 00:00:00
2013-09-18 00:00:00
2013-09-19 00:00:00
2013-09-20 00:00:00
2013-09-22 00:00:00
2013-09-23 00:00:00
2013-09-24 00:00:00
2013-09-25 00:00:00
2013-09-29 00:00:00
2013-09-30 00:00:00
2013-10-01 00:00:00
Spreadsheet: da1f0220-00d6-4481-904f-a81da38f2cae
Sheet: SOLID-1

FORM SOLID-1 |  |  |  | Manure Solids Application Field Record
 |  |  |  | For Recording Manure Solids Applicaton Events on Different Fields
 | Farm Owner |  |  |  | Facility Number |  | -
 | Spreader Operator
 |  |  |  |  |  | Number |  | Volume of
Tract & | Date | ***Weather | Crop Type | Field Size | Application | of Loads |  | each Load**
Field # | (mm/dd/yr) | Code |  | (acres) | Method* | per Field |  | (tons)
*  SI = soil incorporated (disked); BR = broadcast (surface applied).
** Can be found in operator's manual for the spreader.  Contact a local dealer if you do not have your owner's manual.
*** Weather Codes: C-Clear, PC-Partly Cloudy, Cl-Cloudy, R-Rain, S-Snow/Sleet, W-Windy |  |  |  |  |  |  |  | 2003-03-14 00:00:00
Spreadsheet: 153226d1335808828-making-a-schedule-with-auto-time-format-and-adding-total-hours-se-schedule
Sheet: sept 26

 | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
 | 2011-09-26 00:00:00 | 2011-09-27 00:00:00 | 2011-09-28 00:00:00 | 2011-09-29 00:00:00 | 2011-09-30 00:00:00 | 2011-10-01 00:00:00
[NAME] | off | 9:30-5:30 | 8:00-5:00 | 8:00-5:00 | 8:30-5:30 | 9:15-5:15
 |  | 12:00-1:00 | 12:00-1:00 | 12:00-1:00 | 12:00-1:00 | 12:00-1:00
[NAME] | 8:30-5:30 | 8:30-5:30 | 9:30-5:30 | 8:30-5:30 | 9:30-5:30 | off
 | 2:00-3:00 | 2:00-3:00 | 2:00-3:00 | 2:00-3:00 | 2:00-3:00
Ray | 8:00-5:00 | 8:00-5:00 | 8:00-4:00 | 7:00-4:00 | 8:00-4:00 | off
 | 12:00-1:00 | 12:00-1:00 | 12:00-1:00 | 12:00-1:00 | 12:00-1:00
Mark | 8:30-5:30 | off | 9:30-5:30 | 8:30-5:30 | 8:00-5:00 | 9:00-5:00
 | 1:00-2:00 |  | 1:00-2:00 | 1:00-2:00 | 11:00-12:00 | 1:00-2:00
[NAME] | 8:00-4:00 | 9:00-4:00 | 8:00-5:00 | 7:00-4:00-HOMER | off | 9:15-5:15-ctr
ctr 12-2 | 11:00-12:00 | 1:00-2:00 | 11:00-12:00 | 1ub |  | 11:00-12:00
Kat |  |  | 8:00-5:00 |  |  | 9:15-5:15
 |  |  | 12:00-1:00 |  |  | 12:00-1:00
 |  |  | 12:00-1:00
Spreadsheet: 93858d1293641669-help-with-an-sum-if-sumproduct-statement-book1
Sheet: Sheet1

[NAME]
[NAME]
[NAME]
[NAME]
Name |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Y/N |  |  |  |  |  | Amount
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | y |  |  |  |  |  | 50
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | n |  |  |  |  |  | 80
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | y |  |  |  |  |  | 80
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | n |  |  |  |  |  | 20
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | n |  |  |  |  |  | 20
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | y |  |  |  |  |  | 15
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | n |  |  |  |  |  | 10
Spreadsheet: 703347d1604952194-possible-vlookup-badge2
Sheet: Sheet1

Name | Primary|Labor Acct | Sch|Hours | Proj|Hours | ACA Status | Phone 2 | Phone 3 | Row Type | Day | Primary Job | Shift Start Date | Shift Start Time | Shift End Time | Shift End Date | Segment Start Date | Type | Segment Start Time | Segment End Time | Segment End Date | Sch Hrs.
Doe, [NAME] | 1001100 | 8 | 0 |  | (789) 854-7514 |  | Shift | Mon |  | 2020-11-09 00:00:00 | 08:00:00 | 17:00:00 | 2020-11-09 00:00:00 | 2020-10-30 00:00:00 | Regular | 08:00:00 | 12:00:00 | 2020-10-30 00:00:00 | 4
Doe, [NAME] | 1001100 | 8 | 0 |  | (789) 854-7515 |  | Shift | Mon |  | 2020-11-09 00:00:00 | 08:00:00 | 17:00:00 | 2020-11-09 00:00:00 | 2020-10-30 00:00:00 | Break | 12:00:00 | 13:00:00 | 2020-10-30 00:00:00 | 1
Doe, [NAME] | 1001100 | 8 | 0 |  | (789) 854-7516 |  | Shift | Mon |  | 2020-11-09 00:00:00 | 08:00:00 | 17:00:00 | 2020-11-09 00:00:00 | 2020-10-30 00:00:00 | Regular | 13:00:00 | 17:00:00 | 2020-10-30 00:00:00 | 4
Spreadsheet: a20a101e-50d8-464d-8870-c4a8903e1f93
Sheet: Sheet1

Table S7 - Set of ChrXIV-L MLPA Probes
Ty Locus Target | (C)entromeric/(T)elomeric | Gene | Systematic Name | Left Probe Oligo | Right Probe Oligo | Length of Ligated Product
TEL14L | C | RPD3 | YNL330C | GGGTTCCCTAAGGGTTGGAGGTATATGAAGCAACACCTTTTGATCCGATCA | CGGTCAAGCCAAGCGATAAAAGACGCGTTGCATCTAGATTGGATCTTGCTGGCAC | 106
YNLCTy1-1 | T | CUS2 | YNL286W | GGGTTCCCTAAGGGTTGGAGGAGATGAGAACACTTCAAGCACAAGTGA | CAAGAATGAGGACAGCGAAGTGGAAGATGACCTTATATCTAGATTGGATCTTGCTGGCAC | 108
YNLCTy1-1 | C | MRPL10 | YNL284C | GGGTTCCCTAAGGGTTGGACTCCAGAGAAGGATTGGGTGCCAGTTGTGTCTAATTCTAA | AGTCATGAACATCAAGGCTTTGGACCACTATCTAGATTGGATCTTGCTGGCAC | 112
YNLWTy1-2 | T | POR1 | YNL055C | GGGTTCCCTAAGGGTTGGACACTTCTTTGACTCCAGGCGTCGCCAAGT | CCGCCGTCTTAAACACTACGTTCACACAACCTTTCTTCACCGCAAGAGGTCTAGATTGGATCTTGCTGGCAC | 120
YNLWTy1-2 | C | VAC7 | YNL054W | GGGTTCCCTAAGGGTTGGACGTTGTACAGCATAATTTGCCCACCATA | GATAACAATTTAATGGATTCCGATGCCACGTCACTCTAGATTGGATCTTGCTGGCAC | 104
YNLCTy2-1 | T | NCE103 | YNL036W | GGGTTCCCTAAGGGTTGGACTGTGCAAACTGCTGTACAAAATGGAGAATTACAG | GTATACGGTCTGCTTTACAACGTAGAGGACGGTCTACTGTCTAGATTGGATCTTGCTGGCAC | 116
YNLCTy2-1 | C | [NAME] | [NAME] | GGGTTCCCTAAGGGTTGGATATGAAGGTCATCGGTAGCGACTTCTC | TGCTGGTCATCTAGTTAGTAGCGCCTCTATCTCTAGATTGGATCTTGCTGGCAC | 100
CEN14 | T | MRP7 | YNL005C | GGGTTCCCTAAGGGTTGGAGAAGAGCGTTTGAAGGCAAGGAGAGA | AAGCTGGACGAATGAGAAATTGTCGGAGTCTAGATTGGATCTTGCTGGCAC | 96
Spreadsheet: 155850d1337084097-find-second-third-most-usual-values-in-auto-filtered-range-0mode-example
Sheet: Φύλλο1

First more usual age   >> | 15 |  | <<First more usual Name
Second more usual age  >>> |  |  | <<2nd
Third more usual age  >>> |  |  | <<3d
Dates | Names | Ages | Genter
2012-05-23 00:00:00 | A | 12
2012-05-23 00:00:00 | B | 15
2012-05-23 00:00:00 | C | 15 | 1
2012-05-23 00:00:00 | G | 18 | 1
2012-05-23 00:00:00 | H | 15 | 1
2012-05-23 00:00:00 | A | 12
2012-05-23 00:00:00 | V | 12 | 1
2012-05-23 00:00:00 | A | 15 | 1
2012-05-23 00:00:00 | G | 18 | 1
2012-05-23 00:00:00 | J | 16
2012-05-24 00:00:00 | T | 17
2012-05-24 00:00:00 | E | 18 | 1
2012-05-24 00:00:00 | G | 15 | 1
2012-05-24 00:00:00 | A | 14
2012-05-24 00:00:00 | H | 15 | 1
2012-05-24 00:00:00 | J | 19
2012-05-24 00:00:00 | K | 20
Spreadsheet: 73669d1274288586-vlookup-error-on-letter-a-vlookuperror
Sheet: Sheet1

 |  | <<,error if word begins with a
 |  | <<no error if it doesn’t
LOOKUP TABLE |  |  |  |  |  |  | SOURCE
 | a |  |  |  |  |  | Furniture and cabinet makers
 | b |  |  |  |  |  | Decorators & Painters
 | c |  |  |  |  |  | Lighting suppliers and installers
 | d |  |  |  |  |  | Tile installers
 | e |  |  |  |  |  | Custom iron forgers
 | f |  |  |  |  |  | area rugs
 | g |  |  |  |  |  | Stained glass designers
 | h |  |  |  |  |  | Floor & masonry refinishing
 | i |  |  |  |  |  | Flooring contractors
 | j |  |  |  |  |  | Electricians
Spreadsheet: 737905d1624648798-combining-or-sorting-non-numerical-values-by-their-adjacent-duplicate-acc-s-into-1-row-example-of-query
Sheet: Sheet1

Account Number | Symbol (Holding) | Account Numbers Unique | Holdings (Desired Outcome 1) | If first outcome is impossible, here's another desired outcome that would still work for me
ABC123 | AEG |  |  | AEG | AMRX | AMZN | APTS
ABC123 | AMRX | DEF123 |  | CBOE | CNC | CVS | FNF | KO | MS | ORCL | SLF | TY
ABC123 | AMZN | GHI123 |  | CNC | KO | MS | PRLB | SLF | TY
ABC123 | APTS | JKL123 |  | CBOE | CNC | FNF | KO | MS | ORCL | SLF | TY
DEF123 | CBOE | MNO123 |  | GE | GM | MARA | T
DEF123 | CNC
DEF123 | CVS
DEF123 | FNF
DEF123 | KO
DEF123 | MS
DEF123 | ORCL
DEF123 | SLF
DEF123 | TY
GHI123 | CNC
GHI123 | KO
GHI123 | MS
GHI123 | PRLB
GHI123 | SLF
GHI123 | TY
JKL123 | CBOE
JKL123 | CNC
JKL123 | FNF
JKL123 | KO
JKL123 | MS
JKL123 | ORCL
JKL123 | SLF
JKL123 | TY
MNO123 | GE
MNO123 | GM
MNO123 | MARA
MNO123 | T
Spreadsheet: 274761d1383214913-copy-row-from-one-worksheet-to-another-based-on-cell-value-test-data
Sheet: Keysheet

Keysheet
Keysheet Number: |  |  | Issue No: |  |  |  |  | [NAME]: |  |  | Vehicle Quanity
Date: |  |  |  |  |  |  |  | Issued to Engineering Date:
[NAME]: |  |  | Order No:
Customer: |  |  | Order Date: |  |  |  |  | Engineering Signature:
End User: |  |  |  |  |  |  |  | Engineering Sign Off Date:
Framework:
Required Delivery Date:
Chassis |  |  |  |  |  |  |  | Body
[NAME] |  |  |  |  |  |  |  | Body Options
Seating
Wheelbase (Inner)
Engine
Gearbox
Suspension | [NAME]
 | Axle 2
 | Axle 3
 | Axle 4
Tyres | [NAME]
 | Axle 2
 | Axle 3
 | Axle 4
Chassis Options |  |  |  |  |  |  |  | Tailgate Options
 |  |  |  |  |  |  |  | Software & Programming
Additional Items |  |  |  | Status |  | [NAME] |  | [NAME]
 |  |  |  |  |  |  |  | Additional Items |  |  | Status |  | [NAME]
Notes |  |  |  |  |  |  |  | Notes
Spreadsheet: 80607d1280833942-lookup-on-2-rows-group-sales
Sheet: Sheet1

 | Sales |  | look for | Product c | glasgow |  |  | London | 1
Product A | 1431 |  |  |  |  |  |  | [NAME] | 2
London | 1095
[NAME] | 336
Product B | 5440
London | 4192
[NAME] | 1248
Product C | 9364
London | 6726
[NAME] | 2638
Spreadsheet: darrell_schoolcraft__7324__imball0202
Sheet: Oasis

POI  8516
 | Measured | Scheduled | Imbal
1 | -13510 | -13500
2 | -19133 | -19000
3 | -17376 | -17500
4 | -2958 | -2500
5 | -6727 | -5000
6
7 | -6319 | -5000
8 | -352 | -6899
9
10 | -6424
11 | -13804 | -20000
12
13 | -16324 | -16000
14 | -23772 | -23741
15 | -15589 | -15000
16 | -14045 | -14000
17 | -15357 | -14000
18 | -14292 | -14000
19 | -14173 | -14000
20
21
22
23
24
25
26
27
28
29
30
31
2002-01-31 00:00:00 |  |  | 20075.23
2002-02-19 00:00:00
CBS Volume
 |  |  | 7554
Spreadsheet: 35223d1232755144-percentage-question-qc-sheet-master
Sheet: Sheet1

 | Technician |  |  |  |  | Jobs Routed | [NAME] | Jobs Not Completed | Completion % | Jobs taken to QC | Total QC Completed | QC % Per Tech | Pass | Fail | QC Failure %
 | 1
 | 2
 | 3
 | 4
 | 5
 | 6
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15
 | 16
 | 17
 | 18
 | 19
 | 20
 | 21
 | 22
 | 23
 | 24
 | 25
Spreadsheet: 796214d1663159765-combine-multiple-rows-data-in-to-one-row-combine-multiple-rows-data-in-one-row
Sheet: Sheet1

JOB NO. | WBS Element | [NAME]. | Phase | MT | Customer | Clearance
HY-05436.06.37 | HY-05436 | B1 | 45 | 38.73699999999999 | APOLLO | YES
HY-05436.06.39 | HY-05436 | B1 | 47 | 1.265 | APOLLO | YES
HY-05436.03.05 | HY-05436 | B1 | 52 | 3.971 | APOLLO | NO
HY-05436.07.06 | HY-05436 | C1 | 5 | 14.413 | APOLLO | NO
HY-05445.01.12 | HY-05445 | A1 | 11 | 375.989 | S&P | YES
HY-05445.01.17 | HY-05445 | A1 | 15 | 260.818 | S&P | NO
HY-05445.01.19 | HY-05445 | A1 | 16 | 8.183 | S&P | NO
HY-05445.01.24 | HY-05445 | A1 | 21 | 270.041 | S&P | NO
HY-05445.01.26 | HY-05445 | A1 | 23 | 308.62 | S&P | NO
In the above table, each job is bifurcated in to phases.  I would like to make a job-wise summary / pivot and I would like to get the Phases cleared / To be cleared (YES / NO) similar to below table.  Pl help.
JOB | MT | CUSTOMER | CLEARANCE | Phases |  | WBS Element | Customer | Clearance | MT | Phases
HY-05436 | 40.002 | APOLLO | YES | B4/45,B1/47 |  | HY-05436 | APOLLO | YES | 40.002 | B1/45, B1/47
HY-05436 | 18.384 | APOLLO | NO | B1/52,C1/5 |  | HY-05436 | APOLLO | NO | 18.384 | B1/52, C1/5
HY-05445 | 375.989 | S&P | YES | A1/11 |  | HY-05445 | S&P | YES | 375.989 | A1/11
HY-05445 | 847.662 | S&P | NO | A1/15,A1/16,A1/21,A1/23 |  | HY-05445 | S&P | NO | 847.662 | A1/15, A1/16, A1/21, A1/23
Spreadsheet: 56154d1256242371-data-lookup-exampledatalookup
Sheet: WIP Count Sheet

Date | 2009-07-07 00:00:00
 |  | [NAME] | Heat Treat | Shot Blast | Pack | FG (bx) |  |  |  |  | 1 |  |  |  |  | Blend Qty | [NAME] | [NAME] | [NAME].
0293A | SL | 1 | 2 | 3 | 4 | 5 |  |  |  |  | 2 |  |  | Total Pcs. |  | 150000 | 19050 | 3000 | 30000
 | Qty. | 19050 | 38100 | 57150 | 76200 | 15000 |  |  |  |  | 3 |  |  | 206650
 | Hold Qty. | 210 | 220 | 230 | 240 | 250 |  |  |  |  | 4
 |  |  |  |  |  |  |  |  |  |  | 5
 |  | [NAME] | Heat Treat | Shot Blast | Pack | FG (bx) |  |  |  |  | 6 |  |  |  |  | Blend Qty | [NAME] | [NAME] | [NAME].
0348A | SL | 1 | 2 | 3 | 4 | 5 |  |  |  |  | 7 |  |  | Total Pcs. |  | 150000 | 19050 | 3000 | 18000
 | Qty. | 19050 | 38100 | 57150 | 76200 | 15000 |  |  |  |  | 8 |  |  | 206800
 | Hold Qty. | 240 | 250 | 260 | 270 | 280 |  |  |  |  | 9
 |  |  |  |  |  |  |  |  |  |  | 10
 |  | [NAME] | Zion | Shot Blast | Mag | [NAME]. | Sort | FG (bx) | FG (Skid) |  | 11 |  |  |  |  | Blend Qty | [NAME] | [NAME] | [NAME].
0513A | SL | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 |  | 12 |  |  | Total Pcs. |  | 5300 | 1080 | 50 | 1200
 | Qty. | 1080 | 2160 | 3240 | 4320 | 5400 | 6480 | 350 | 9600 |  | 13 |  |  | 34590
 | Hold Qty. | 210 | 220 | 230 | 240 | 250 | 260 | 270 | 280 |  | 14
 |  |  |  |  |  |  |  |  |  |  | 15
 |  | [NAME] | Coin | Zion | Shot Blast | Mag | [NAME]. | Sort | FG (bx) | FG (Skid) | 16 |  |  |  |  | Blend Qty | [NAME] | [NAME] | [NAME].
0572A | SL | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 17 |  |  | Total Pcs. |  | 3773 | 1080 | 15 | 1080
 | Qty. | 1080 | 2160 | 3240 | 4320 | 5400 | 6480 | 7560 | 120 | 9720 | 18 |  |  | 42240
 | Hold Qty. | 200 | 210 | 220 | 230 | 240 | 250 | 260 | 270 | 280 | 19
 |  |  |  |  |  |  |  |  |  |  | 20
 |  | [NAME] | Coin | [NAME]. | Zion | Mag | Vision | FG (bx) | FG (Skid) |  | 21 |  |  |  |  | Blend Qty | [NAME] | [NAME] | [NAME].
0579A | SL | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 |  | 22 |  |  | Total Pcs. |  | 5779 | 840 | 54 | 3240
 | Qty. | 840 | 1680 | 2520 | 3360 | 4200 | 5040 | 378 | 25920 |  | 23 |  |  | 45898
 | Hold Qty. | 210 | 220 | 230 | 240 | 250 | 260 | 270 | 280 |  | 24
 |  |  |  |  |  |  |  |  |  |  | 25
 |  | [NAME] | Coin | [NAME]. | [NAME] | Zion | Mag | Vision | FG (bx) | FG (Skid) | 26 |  |  |  |  | Blend Qty | [NAME] | [NAME] | [NAME].
0580A | SL | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 27 |  |  | Total Pcs. |  | 7630 | 1100 | 54 | 3240
 | Qty. | 1100 | 2200 | 3300 | 4400 | 5500 | 6600 | 7700 | 432 | 29160 | 28 |  |  | 62552
 | Hold Qty. | 200 | 210 | 220 | 230 | 240 | 250 | 260 | 270 | 280 | 29
Spreadsheet: 749208d1632590811-standard-and-non-standard-date-formats-dates
Sheet: Sheet1

S.No. | Non-Standard Format | [NAME] | [NAME] Used
1 | 16\12\2015
2 | 2015 December 16
3 | 16.12.2015
4 | 16 December,2015
5 | Tuesday, Dec 16,2015
6 | 2015-Dec-16,Tue
7 | 16th Dec 2015
8 | 16 12 2015
9 | Dec 16 2015
10 | 16122015
Spreadsheet: 76556c14-4bb9-4f69-b133-d735e577e25a
Sheet: Sheet8

Reason Codes
1 | Travel between the relative home and school, to the extent that school transportation is not provided. |  |  |  |  |  |  |  | Child Person ID
2 | Travel to physical or behavioral health appointments.
3 | Travel for administrative case or judicial review, team meetings, foster parent training or visitations.
4 | Travel for Headstart, summer school, pre-school, summer camp or driver's education class.
5 | Travel for youth sixteen (16) year and older to and from employment or searching for job.
6 | Other: Must be authorized by Department and must have prior Local Office Director approval before
 | the trip, please attach authorization.
Month of Travel
Date | Starting Address (number and street, city, state and ZIP code): |  |  |  | Destination Address (number and street, city, state and ZIP code): |  |  |  |  | Reason Code | [NAME]
Pursuant to the provision and penalties of Indiana Code 5-11-10-1, I hereby certify that the foregoing invoice is just and correct, that the amount claimed is legally due, after allowing all just credits, and that no part of the same has been paid. |  |  |  |  |  |  |  |  | Total Miles Driven
I hereby swear and affirm under the penalties of perjury the attached bill contains the actual travel costs provided for the individual(s) listed on such bill.  The dates, destinations, reasons and mileage for travel are true and accurate.  I understand that in submitting this that I am under oath stating and affirming that this travel was provided and fully understand that this may be independently audited and that any discrepancy may be referred to a local prosecutor for criminal prosecution.
Relative Family Name |  |  |  |  | Relative Family Address (number and street, city, state and ZIP code)
Relative Family Email Address |  |  |  |  |  |  |  |  | Relative Family ST Number
Relative Family Signature |  |  |  |  | Relative Family Telephone Number |  |  |  | Date of Signature (month, day, year)
Spreadsheet: 92799d1292346319-how-to-do-a-formula-within-a-formula-s-help
Sheet: Sheet1

Team | RANK | POINTS
A | 1
B | 2
C | 3
D | 4
E | 5
F | 7
Spreadsheet: benjamin_rogers__1144__00 Depreciation - 11-00
Sheet: Sheet1

Depreciation Estimate
00 Peakers
Commercial Ops Assumption: |  |  | 2000-06-01 00:00:00 |  | 2000-06-01 00:00:00 |  | 2000-06-01 00:00:00
 |  |  | [NAME] |  | [NAME] |  | Wheatland |  | Total
Depreciation Estimate:
Estimated Project Cost (11/20 Wkly Summary) |  |  | 268928337 |  | 176033425 |  | 157980763
Less:
Land
Pre-Mobilization Exps |  |  |  | 0
Spare Parts
Project Cost
Salvage Value - 10%
Estimated Useful Life - Years |  |  | 30 |  | 30 |  | 30
Estimated Annual Depreciation
Estimated Monthly Depreciation
June Depreciation (booked in 7/00)
July Depreciation |  |  | 646714 |  | 422616 |  | 376529.7360750001
August Depreciation |  |  | 645627 |  | 419953.0592 |  | 375556
September Depreciation |  |  | 666032 |  | 437150 |  | 387278
October Depreciation |  |  | 666812 |  | 436504 |  | 387515
November Depreciation
Total LTD Depreciation Booked
Total per Calculation
Depreciation - 11/00