tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 103348d1301078246-sumifs-sumifs_sample
Sheet: Facilator and location detail

 |  | No. | Training Start Date | Training End Date | Training Course | Facilitator (s) | Location
 |  | Ex. | 2011-01-24 00:00:00 | 2011-01-26 00:00:00 | Sales Executive | EXAMPLE - John DOE | Philadelphia
 |  |  | 2010-02-16 00:00:00 | 2010-02-18 00:00:00 | ISE | [NAME] | Newark
 |  |  | 2010-02-23 00:00:00 | 2010-02-25 00:00:00 | ISE/SE | Pascale Lessard | Quebec City
 |  |  |  | 2010-03-01 00:00:00 | ISE | [NAME] | Norfolk
 |  |  |  | 2010-04-01 00:00:00 | SE | [NAME] | Philadelphia
 |  |  |  | 2010-05-01 00:00:00 | SE | [NAME] | Atlanta
 |  |  |  | 2010-06-01 00:00:00 | SM/DSM | [NAME],Pauli Samra, [NAME] | Support Center
 |  |  | 2010-06-02 00:00:00 | 2010-06-03 00:00:00 | SM/GM/DSM | Pauli Samra | Denver
 |  |  | 2010-06-15 00:00:00 | 2010-06-17 00:00:00 | SE | Pauli Samra, [NAME] | Atlanta
 |  |  | June 22-10 | June 24-10 | SE | Pauli Samra | Los Angeles
 |  |  |  | 2010-08-01 00:00:00 | SE | [NAME] | Philadelphia
 |  |  |  | 2010-09-01 00:00:00 | SE | Pascale Lessard | Long Island
 |  |  | 2010-11-10 00:00:00 | 2010-11-11 00:00:00 | ISE/SE | [NAME],Pascale Lessard | San Francisco
 |  |  | 2010-11-15 00:00:00 | 2010-11-18 00:00:00 | ISE/SE | [NAME], Pascale Lessard | Philadelphia
 |  |  |  | 2010-12-01 00:00:00 | SM/DSM | [NAME],Pauli Samra, [NAME] | Support Center
 |  |  | 2010-12-14 00:00:00 | 2010-12-16 00:00:00 | ISE/SE | Pascale Lessard | Montreal
 |  |  | 2011-01-24 00:00:00 | 2011-01-26 00:00:00 | SE | [NAME] and [NAME] | Philadelphia
 |  |  | 2011-02-22 00:00:00 | 2011-02-24 00:00:00 | SE | [NAME], Pascale Lessard and [NAME] | Houston
 |  |  | 2011-03-15 00:00:00 | 2011-03-17 00:00:00 | SE | [NAME], Pascale Lessard and [NAME] | Toronto
Spreadsheet: 885595d1735333917-status-summary-on-form-completion-azaccaria-form-semaphore-v2
Sheet: Form2

Section | Field | Person 1 | Person 2 | Person 3
Address | Street | 123 [NAME]. | 234 Rue Rustique | 345 Calle Mayor
Address | City | London | Paris | Madrid
Address | Country | England | France | Spain
Access | Home | Yes | No | Yes
Access | VPN | Yes | Yes | No
Access | Other | No
Vehicle | Make |  |  | Cupra
Vehicle | Model |  |  | Terramar
Vehicle | Year
Spreadsheet: 745138d1629773084-index-formula-shading-user-error-raid-log-risks-
Sheet: Lists

Type | Status | Priority |  | Consequence/Impact | Likelihood/Probability
R | O | High | ✓ | 1 - Insignificant | 5 - Almost Certain
A | C | Medium | x | 2 - Minor | 2 - Unlikely
I | A | Low |  | 3  -Moderate | 3 - Possible
D | P |  |  | 4 - Major | 4 - Likely
 |  |  |  | 5 - Severe |  |  |  |  |  | 1 - Rare
 |  |  |  |  |  |  |  |  |  | 2 - Unlikely
 |  |  |  |  |  |  |  |  |  | 3 - Possible
 |  |  |  |  |  |  |  |  |  | 4 - Likely
 |  |  |  |  |  |  |  |  |  | 5 - Almost Certain
Spreadsheet: 156398d1337279417-use-of-sumif-function-figo-example
Sheet: Sheet1

 | Car Model | Color | Price | Mileage |  |  | Black | White
 | Figo | Black | 2000 | 12 |  | Figo
 | Swift | White | 1300 | 13 |  | Swift
 | WagonR | Black | 3400 | 21
 | Polo | Black | 5466 | 15
 | Swift | Black | 6473 | 16
 | Figo | Black | 3542 | 23
 | Figo | White | 6453 | 31
 | WagonR | White | 8700 | 10
 | Polo | White | 1542 | 16
 | Figo | Black | 2536 | 15
 | Figo | White | 9845 | 16
Spreadsheet: 70790d1271466504-names-to-numbers-new-mileage
Sheet: Mileage Log and Reimbursement

Mileage Log and Reimbursement Form |  |  |  |  |  |  |  | http://www.hypermiler.co.uk/mpg-calculator.html
 |  |  |  |  |  |  |  | http://www.hmrc.gov.uk/cars/advisory_fuel_current.htm
Employee Name | [NAME] |  |  |  |  | Rate Per Mile |  |  | 0.12 |  | per lit | 1.09
Employee ID |  |  |  |  |  | For Period |  |  | From 25/10/09 to 27/10/09 |  | per gal | 4.9595
Vehicle Description | fiat 500 |  |  |  |  | Total Mileage |  |  | 260 |  | per mile | 12p
Authorized By |  |  |  |  |  | Total Reimbursement |  |  | 31.2
Date |  | [NAME] 1 | [NAME] 2 | [NAME] 3 | [NAME] 4 | [NAME] 5 | [NAME] 6 | Hours | [NAME] | Odometer End | Mileage | Reimbursement
 |  |  |  |  |  |  |  |  | not used | not used
2009-10-25 00:00:00 |  | [NAME] | Mario | Rachelle | Chenga | Shahima |  |  |  |  | 190 | 22.8
2009-10-27 00:00:00 |  | Chenga | Chenga |  |  |  |  |  |  |  | 70 | 8.4
 |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  | 0 |  | Totals | 260 | 31.2
 |  |  |  |  |  | LIST
 |  |  |  |  |  | Mario | 45
 |  |  |  |  |  | Rachelle | 35
 |  |  |  |  |  | Shahima | 35
 |  |  |  |  |  | [NAME] | 40
 |  |  |  |  |  | Chenga | 35
 |  |  | Ok I have set a validation list of names for each cell in the colums
 |  |  | [NAME] 1,2,3,4,5,6   is there a way to add the miles from the list to the colum [NAME]
 |  |  | so what ever name I put in the lesson colums the milage colum will add the numbers
 |  |  | according to the names.
 |  |  | so chenga is 35 so kind of  (if C14 = chenga then +H32 to [NAME]
 |  |  | Hope this makes sense…. Probobly not.
Spreadsheet: 08d04bd8-805e-4d8f-b344-c993bd677a16
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2012-07-19 09:29:52.400000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4 | 102.125 | 102 | 101.875 | 101.5 |  | and are added to price quote
3.875 | 101.875 | 101.75 | 101.625 | 101.25
3.75 | 101.546 | 101.421 | 101.296 | 100.921 |  | Note: | Refer To Price [NAME]
3.625 | 101.136 | 101.011 | 100.886 | 100.511 |  |  | For all Price Adjs
3.5 | 100.551 | 100.426 | 100.301 | 99.676
3.375 | 99.666 | 99.541 | 99.416 | 98.791
3.25 | 98.708 | 98.583 | 98.458 | 97.833
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | TIB Servicing Retained Product
 |  |  |  |  |  | For Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | TIB Annual Mortgage Conference
 |  |  |  |  |  | October 3rd thru 5th
 |  |  |  |  |  | Register Now!!!
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.375 | 102.125 | 102 | 101.875 | 101.5
3.25 | 101.731 | 101.606 | 101.481 | 101.106
3.125 | 101.437 | 101.312 | 101.187 | 100.812
3 | 101.087 | 100.962 | 100.837 | 100.462
2.875 | 100.496 | 100.371 | 100.246 | 99.621
2.75 | 99.838 | 99.713 | 99.588 | 98.963
 |  |  |  |  |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2012-08-02 09:29:52.400000
30 DAY | 2012-08-17 09:29:52.400000
45 DAY | 2012-09-01 09:29:52.400000
60 DAY | 2012-09-16 09:29:52.400000
90 DAY | 2012-10-16 09:29:52.400000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 67632d1268211708-dectecting-changes-in-excel-720989
Sheet: Sheet1

x | y
a
a
a
a
a
b
b
b
b
b
c
c
c
c
d
d
d
Spreadsheet: 60264d1260831056-auto-link-to-another-worksheet-when-text-is-entered-in-cell-adhoc-metrics-sample-1
Sheet: UCAs

 |  |  |  |  |  |  |  |  |  | Today = Past Due Date
 |  |  |  |  |  | UCAs
Date Entered | Master Document # | Award # | Award Date | Contracting Officer |  | Due Date | Definitization Date | Definitized Amount ($) | Due Date to Definitization Date (days) | Today's Date to Due Date (days)
2008-10-04 00:00:00 | W813LT92323679 | W911QX-09-C-0078 | 2008-10-01 00:00:00 | Kathy |  | 2009-01-02 00:00:00 | 2009-02-01 00:00:00 | 1500000 | 30 | -346.616265856479
2009-01-02 00:00:00 | W813LT60895213 | W911QX-09-C-0091 | 2008-12-26 00:00:00 | [NAME] |  | 2009-01-22 00:00:00 | 2009-02-24 00:00:00 | 2560000 | 33 | -326.616265856479
2009-02-19 00:00:00 | W813LT60895343 | W911QX-09-C-0122 | 2009-02-11 00:00:00 | Christi |  | 2009-02-26 00:00:00 | 2009-03-15 00:00:00 | 2506400 | 17 | -291.616265856479
2009-12-09 00:00:00 | W71B7J43234480 | W911QX-10-C-0019 | 2009-09-07 00:00:00 | [NAME]
2008-10-09 00:00:00 | W813LT92326469 | W911QX-09-C-0075 | 2008-10-02 00:00:00 | [NAME]
2008-11-24 00:00:00 | W71B7J02345236 | W911QX-09-C-0089 | 2008-11-21 00:00:00 | [NAME]
Spreadsheet: 765979d1643708740-sumifs-with-date-and-time-criteria-rainfall-test-2-aligw
Sheet: Rainfall 15 min sum

Date and Time | Rainfall in 15 minutes ([NAME]) |  | Manual Calculation
2019-05-02 16:00:00 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 1.2
 |  |  | 0.6
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0.4
 |  |  | 0.2
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
Spreadsheet: 106042d1303277279-text-to-date-format-plus-9
Sheet: DetailedStatement

Go Markets |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Currency: AUD
Closed Transactions: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | paste from saved HTLM MT4 report.
demo account
 |  |  |  | % |  |  |  | PASTE BELOW HERE
profit $ |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | %
 |  | $ per | pips | trades | win | loss
Ticket | Open Time | Type | Size | Item | Price | S / L | T / P | Close Time | Price | Commission | Taxes | Swap | Profit | pips |  | enter | close | pips | win | loss
20947851 | 2011.03.16 15:05 | sell | 0.2 | usdchf | 0.91369 | 0.9122 | 0.89194 | 2011.03.17 00:30 | 0.8985 | 0 | 0 | -0.52 | 346.24
20947877 | 2011.03.16 14:37 | sell | 0.2 | usdjpy | 80.569 | 83.343 | 78.291 | 2011.03.16 23:13 | 78.291 | 0 | 0 | 0 | 595.02
20947882 | 2011.03.16 17:48 | sell | 0.2 | audjpy | 79.15 | 80.15 | 77.708 | 2011.03.16 23:11 | 77.708 | 0 | 0 | 0 | 371.13
20947889 | 2011.03.16 20:03 | sell | 0.2 | audusd | 0.98058 | 1.02026 | 0.96938 | 2011.03.17 00:29 | 0.97666 | 0 | 0 | -10.02 | 80.27
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | pips
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ave $ per pip
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | trades | win | loss
Spreadsheet: 767850d1644675112-extracting-data-from-another-workbook-example-bradleyn1-
Sheet: Sheet2

 | WORKBOOK 1
 |  | REVIEW 1 |  | REVIEW 2
 | ID | Status | Completed by | Status | Completed by
 | 1
 | 2
 | 3
 | 4
Spreadsheet: 274246d1383057088-sort-dates-with-a-formula-sort_dates
Sheet: Sheet2

Date
2013-02-01 00:00:00
2013-02-02 00:00:00
2013-02-03 00:00:00
2013-02-04 00:00:00
2013-02-05 00:00:00
2013-02-06 00:00:00
2013-02-07 00:00:00
2013-02-08 00:00:00
2013-02-09 00:00:00
2013-01-03 00:00:00
2013-02-11 00:00:00
2013-02-12 00:00:00
2013-01-04 00:00:00
2013-02-14 00:00:00
2013-02-15 00:00:00
2013-01-10 00:00:00
2013-02-17 00:00:00
2013-01-15 00:00:00
2013-02-19 00:00:00
2013-02-20 00:00:00
Spreadsheet: 266747d1379709670-30-files-received-type-data-all-different-but-needs-to-be-counted-as-the-same-in-1-sheet-final-should-look-like
Sheet: Should Look Like

Center | Date | Stand | Concierge | DHL | Groundballs | Flyballs | Bowling Balls | Rolling Balls | Desk | Hotel | Local | Other | Transition | Tree | Shrub
363 | 2010-10-08 00:00:00 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 457 | 0 | 0 | 0 | 0 | 0
363 | 2010-10-09 00:00:00 | 0 | 0 | 0 | 38 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5
363 | 2010-10-11 00:00:00 | 0 | 0 | 0 | 22 | 0 | 10 | 0 | 0 | 0 | 7 | 0 | 0 | 117 | 0
363 | 2010-10-12 00:00:00 | 0 | 0 | 0 | 27 | 0 | 7 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 0
3637 | 2010-10-08 00:00:00 | 0 | 0 | 0 | 27 | 0 | 16 | 0 | 0 | 0 | 0 | 0 | 0 | 42 | 2
3637 | 2010-10-09 00:00:00 | 0 | 0 | 0 | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 2
3637 | 2010-10-11 00:00:00 | 0 | 0 | 0 | 23 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 0 | 41 | 1
3637 | 2010-10-12 00:00:00 | 0 | 0 | 0 | 28 | 0 | 31 | 0 | 0 | 0 | 0 | 0 | 0 | 66 | 1
30+ files of Inbound Data as shown in other two tabs.
Spreadsheet: 885474d1735084781-countifs-function-countifs-function
Sheet: Sheet1

Person 1 | ü
Person 2 | ü
Person 3 | ü | late
Person 4 | ü
Person 5 | ü
Person 6 | ü | late
Person 7 | ü
Person 8 | ü
Person 9
Person 10
Person 11
Person 12
Person 13 | ü | late
Person 14 | ü
Person 15 | ü
Person 16 | ü
Person 17 | ü
Person 18 | ü
Person 19 | ü | late
Person 20 | ü
Person 21 | ü
Person 22
Person 23
Person 24
Totals
Spreadsheet: 287573d1388866330-planning-for-8-hour-a-day-without-weekends-book2
Sheet: Sheet1

1 | 2014-01-06 06:00:00
1
8
11
1
1
1
1
5
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
16
1
1
1
1
1
1
1
1
22
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
1
Spreadsheet: 707406d1607251206-using-a-list-to-reduce-worksheets-midshires-master
Sheet: KK

 |  |  |  | ADJUSTED HANDICAP |  |  |  |  |  | OFFICIAL HANDICAP |  |  |  |  | HANDICAPPING ALTERATIONS
hole | par | S/I | SHOTS | CALC | points | PAR 3 | SI/1 | SI/2 | S1/3 | SI/1 | S1/2 | S1/3 | CALC | points | EXACT | catagory | BUFFER | css | Nett | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HANDICAP |  | ZONE |  | Differential
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out |  |  |  |  |  | TOTAL
total
Spreadsheet: 831091d1685418122-identifying-most-common-occurrences-text-with-criteria-preppy_prince_example_30052023
Sheet: Sheet1

DATA | NAME | HOURS | CONTRACT | SUMMARY | NAME | HOURS | CONTRACT
 | [NAME] | 4 | Full-time
 | [NAME] | 4 | Part-time
 | Emma | 3 | Part-time
 | Sophie | 4 | Casual
 | [NAME] | 2.75 | Casual
 | Julie | 4 | Casual
 | Mark | 5 | Casual
 | [NAME] | 3 | Casual
 | [NAME] | 4 | Full-time
 | Mark | 3 | Casual
 | [NAME] | 5 | Full-time
 | [NAME] | 4 | Casual
 | Sophie | 5 | Casual
 | Sophie | 5 | Casual
 | [NAME] | 3 | Casual
 | [NAME] | 2.75 | Full-time
 | [NAME] | 2 | Part-time
 | [NAME] | 3 | Part-time
 | Sophie | 3 | Casual
 | Mark | 4 | Casual
 | [NAME] | 4 | Full-time
 | Sophie | 3 | Casual
 | Emma | 5 | Part-time
 | [NAME] | 3 | Full-time
 | Julie | 3.5 | Casual
 | Sophie | 4 | Casual
 | Julie | 4 | Casual
 | Mark | 4 | Casual
 | Emma | 3 | Part-time
 | Sophie | 3 | Casual
Spreadsheet: 1582850d-7843-44cb-82aa-066d0a19705f
Sheet: Data and graph

 | to EU-12 | to EFTA | to OECD (non-EFTA) | to non-OECD | to EU-15
2001 | 16.872 | 171.156 | 12.476 |  | 2946.321
2002 | 5.195 | 74.40100000000001 | 11.362 |  | 3563.255
2003 | 55.975 | 92.513 | 45.227 |  | 4166.111
2004 | 53.846 | 120.91 | 11.566 |  | 4788.709
2005 | 30.266 | 53.206 | 5.772 |  | 6457.456999999999
2006 | 97.954 | 81.46700000000001 | 6.234999999999999 |  | 6428.364
2007 | 115.463 | 128.117 | 6.303 |  | 7701.954
2008 | 171.287 | 174.143 | 16.871 |  | 7546.201000000001
2009 | 217.992 | 188.76 | 7.931 |  | 6961.391
Unknown wastetype, and destinations has been excluded. Unknown waste type refers to waste shipments that are not registered in any category in the country's reporting.
Spreadsheet: 707629d1607376841-calculate-median-by-certain-criteria-median-formula
Sheet: Sheet1

Region | Month | Sales | Median by Region
East | 1 | 522 | Need formula here that calculate sales (median) by region
East | 2 | 200
East | 3 | 325
East | 4 | 400
East | 5 | 152
West | 1 | 654
West | 2 | 218
West | 3 | 365
West | 4 | 584
West | 5 | 459
South | 1 | 351
South | 2 | 742
South | 3 | 954
South | 4 | 825
South | 5 | 452
North | 1 | 100
North | 2 | 200
North | 3 | 300 | example: answer for north is 300 (median)
North | 4 | 400
North | 5 | 500
Spreadsheet: 9ea774f0-2c18-4a20-8412-a77c19bb9cb1
Sheet: US ELL

Students Who Scored Unsatisfactory (US) on TCAP
 | Reading |  | Writing |  | Math |  | Science |  |  | FEP Includes M1, [NAME], and Exited Students
 | N | % US | N | % US | N | % US | N | % US
All English Language Learners (ELL) | 18644 | 21.41167283000666 | 8983 | 10.30207807697601 | 24893 | 28.49995420406668 | 13030 | 42.48589781212299
Not English Proficient (NEP) | 6290 | 70.76161547980651 | 4681 | 52.44817927170868 | 5642 | 62.397699623977 | 2071 | 87.23673125526538
Limited English Proficient (LEP) | 11269 | 24.82049248931765 | 3844 | 8.45504135139891 | 14435 | 31.7259719993846 | 8145 | 56.66875391358798
Fluent English Proficient (FEP) | 1085 | 3.309642192599823 | 458 | 1.396043527296004 | 4816 | 14.68158400146328 | 2814 | 20.21261313029737
Elementary
Students Who Scored Unsatisfactory (US) on TCAP
 | Reading |  | Writing |  | Math |  | Science
 | N | % US | N | % US | N | % US | N | % US
All English Language Learners (ELL) | 8241 | 21.40074789654098 | 4643 | 12.03504497265352 | 6546 | 16.923474663909 | 3879 | 32.24706958184388
Not English Proficient (NEP) | 3647 | 65.69987389659521 | 2772 | 49.70414201183432 | 2923 | 51.78033658104517 | 896 | 80
Limited English Proficient (LEP) | 4438 | 18.1017253334421 | 1784 | 7.268875035651713 | 3457 | 14.06599666354722 | 2804 | 38.65453542872898
Fluent English Proficient (FEP) | 156 | 1.848341232227488 | 87 | 1.028490365291406 | 166 | 1.962638921730906 | 179 | 4.897400820793433
Middle
Students Who Scored Unsatisfactory (US) on TCAP
 | Reading |  | Writing |  | Math |  | Science
 | N | % US | N | % US | N | % US | N | % US
All English Language Learners (ELL) | 7388 | 24.02523495170889 | 2398 | 7.798881228047352 | 9201 | 29.90444617784712 | 4519 | 44.54411039921143
Not English Proficient (NEP) | 1628 | 81.27808287568648 | 1088 | 54.45445445445446 | 1511 | 74.28711897738445 | 513 | 91.1190053285968
Limited English Proficient (LEP) | 5213 | 35.76427003293085 | 1208 | 8.283049917718047 | 6291 | 43.16591189790037 | 2975 | 71.12120487688262
Fluent English Proficient (FEP) | 547 | 3.859723398250071 | 102 | 0.7200338839474798 | 1399 | 9.879943502824858 | 1031 | 19.09612891276162
High
Students Who Scored Unsatisfactory (US) on TCAP
 | Reading |  | Writing |  | Math |  | Science
 | N | % US | N | % US | N | % US | N | % US
All English Language Learners (ELL) | 3015 | 16.92394049957901 | 1942 | 10.86798365885052 | 9146 | 51.10639248994189 | 4632 | 54.52619187757504
Not English Proficient (NEP) | 1015 | 76.02996254681648 | 821 | 60.81481481481481 | 1208 | 88.62802641232575 | 662 | 95.80318379160637
Limited English Proficient (LEP) | 1618 | 25.64590267871295 | 852 | 13.4448477197412 | 4687 | 73.83427851291745 | 2366 | 80.5858310626703
Fluent English Proficient (FEP) | 382 | 3.755776226526399 | 269 | 2.641917108623061 | 3251 | 31.91948944526264 | 1604 | 32.94987674609696
Spreadsheet: 554963d1515341119-stats-points-tracking-for-a-disc-golf-league-golf-disc-tournament-2018
Sheet: League Tables

 |  |  |  | Club Name | [NAME]
 |  |  |  | Tournament League Table
 |  |  |  | Tournament #
 |  |  |  | Date Played
 |  |  |  | # of Players
 | Total |  |  | Location
 | Club Players |  | Player | Date Joined | Total Score | Rank | Player | Score
 | [NAME] |  | [NAME] | 2018-01-07 00:00:00
 | Ima Dunce |  | Ima Dunce | 2018-01-07 00:00:00
 | Anne Other |  | Anne Other | 2018-01-07 00:00:00
 | [NAME] |  | [NAME] | 2018-01-07 00:00:00
 | Ima Belle |  | Ima Belle | 2018-01-07 00:00:00
 | [NAME] |  | [NAME] | 2018-01-07 00:00:00
 | [NAME] |  | [NAME] | 2018-01-07 00:00:00
 | [NAME] |  | [NAME] | 2018-01-07 00:00:00
 | [NAME] |  | [NAME] | 2018-01-07 00:00:00
 | [NAME] |  | [NAME] | 2018-01-07 00:00:00
 | [NAME] |  | [NAME] | 2018-01-07 00:00:00
 | [NAME] |  | [NAME] | 2018-01-07 00:00:00
 | P, [NAME] |  | P, [NAME] | 2018-01-07 00:00:00
 | [NAME] |  | [NAME] | 2018-01-07 00:00:00
 | [NAME] |  | [NAME] | 2018-01-07 00:00:00
 | [NAME] |  | [NAME] | 2018-01-07 00:00:00
Spreadsheet: 209313d1359061183-duplicates-in-separate-rows-combined-to-single-row-duplicates
Sheet: Sheet1

ACCT | SUB ACCT | BAL |  |  |  |  | ACCT | SUB ACCT | BAL | SUB ACCT | BAL
1234 | A | 100 |  |  |  |  | 1234 | A | 100 | B | 200
1234 | B | 200 |  |  |  |  | 5678 | A | 50
5678 | A | 50
Spreadsheet: 31757d1227709227-add-cells-with-color-only-generic-hours-and-miles_2008
Sheet: May

MAY | Month Total | Month Total | 08XXXX | City
CD? Then "Y" |  | CD
 | HOURS | [NAME] | HOURS | CD [NAME]
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
 |  | 0
Name
AB Hours /Job | 0 |  | 0
AB-CD /Job |  | 0
 | 0
Spreadsheet: 80054d1280284177-combo-and-selection-of-array-in-them-dynamically-rearrange_data_group_by_apc_1
Sheet: Sheet1

Site | Part_No | Product |  | Type | Latest FDM | Total QTY | Total $ Val
AMK | 0101312002W | A76 | 3 | Piece Parts | 1.24 | 99 | 123 | 3
AMK | 0101312003W | A76 | 3 | Piece Parts | 1.05 | 207 | 217 | 1 |  |  |  |  |  | A76
AMK | 1014059001 | A76 | 3 | Piece Parts | 17.25 | 90 | 1553 |  |  |  |  |  |  | E44
AMK | 1004021001 | A76 | 3 | Piece Parts | 27.3 | 36 | 983 |  |  |  |  |  |  | G34
AMK | 1002588001 | E44 | 3 | Piece Parts | 2.1018 | 28 | 59 |  |  |  |  |  |  | H21
AMK | 0171010G03 | G34 | 3 | Piece Parts | 3.492 | 19 | 66 |  | Latest FDM | Total QTY | Total $ Val |  |  | J11
AMK | 0171010G04 | G34 | 3 | Piece Parts | 3.468 | 7 | 24 |  | 17.25 | 90 | 1553
AMK | 0171010G12 | G34 | 3 | Piece Parts | 3.259 | 234 | 763
AMK | 0171010G13 | G34 | 3 | Piece Parts | 4.01 | 91 | 365
AMK | 10018230001 | G34 | 3 | Piece Parts | 4.828 | 39 | 188
AMK | 10018230002 | G34 | 3 | Piece Parts | 3.732 | 80 | 299
AMK | 10018230003 | G34 | 3 | Piece Parts | 3.67 | 5 | 18 |  |  |  | `
AMK | 1004021002 | H21 | 3 | Piece Parts | 27.65 | 57 | 1576
AMK | 1007540010 | J11 | 3 | Piece Parts | 13.0656 | 50 | 653
AMK | 1007559007 | J11 | 3 | Piece Parts | 22.5682 | 40 | 903
AMK | 1008787001 | J11 | 3 | Piece Parts | 14.93 | 100 | 1493
AMK | 1008842002 | J11 | 3 | Piece Parts | 8.7331 | 100 | 873
AMK | 1008952001 | J11 | 3 | Piece Parts | 0.81 | 100 | 81
AMK | 1008964002 | J11 | 3 | Piece Parts | 0.6878 | 45 | 31
Spreadsheet: 776154d1649529522-find-last-cell-in-a-column-up-until-the-current-row-has-a-value-and-calculate-sample
Sheet: Sheet1

100 | 50
200 | 75 | N
300 | 25 | N
400 | 50
500 | 75
100 | 50 | N
200 | 75
300 | 25
400 | 50
500 | 75
100 | 50 | N
200 | 75 | N
300 | 25 | N
400 | 50 | N
500 | 75
100 | 50
200 | 75
300 | 25
400 | 50
500 | 75
Spreadsheet: 584945d1533545646-split-text-with-varying-delimiter-sample
Sheet: Sheet1

Name | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9
[NAME] (1) Brown (2) [NAME] (3)
Expected Results
Name | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9
[NAME] (1) Brown (2) [NAME] (3) | [NAME] | 1 | [NAME] | 2 | [NAME] | 3
Spreadsheet: 786454d1657197941-reverse-lookup-example-reverse-lookup
Sheet: Blad1

 |  | Category | Bad | Accept. | Good | Great
 |  | Game A Juniors | 0 | 70 | 90 | 120
 |  | Game A Seniors | 0 | 105 | 135 | 180
 |  | Game B Juniors | 0 | 84 | 108 | 144
 |  | Game B Seniors | 0 | 98 | 126 | 168
 |  | Game C Juniors | 0 | 140 | 180 | 240
 |  | Game C Seniors | 0 | 175 | 225 | 300
 |  | Game D Juniors | 0 | 42 | 54 | 72
 |  | Game D Seniors | 0 | 60 | 77 | 102
 | Name | Category | Score | Pref. Result |  | Score | Result
 | [NAME] | Game A Juniors | 92 | Good |  | 70
 | [NAME] | Game A Juniors | 75 | Accept.
 | [NAME] | Game B Seniors | 135 | Good
 | Ahmed | Game D Juniors | 75 | Great
 | [NAME] | Game C Juniors | 85 | Bad