tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 90386d1290113751-excel-2007-need-to-count-add-records-values-in-a-date-range-forecast
Sheet: Dates

2010-01-03 00:00:00 | 2010-01-09 00:00:00
2010-01-10 00:00:00 | 2010-01-16 00:00:00
2010-01-17 00:00:00 | 2010-01-23 00:00:00
2010-01-24 00:00:00 | 2010-01-30 00:00:00
2010-01-31 00:00:00 | 2010-02-06 00:00:00
2010-02-07 00:00:00 | 2010-02-13 00:00:00
2010-02-14 00:00:00 | 2010-02-20 00:00:00
2010-02-21 00:00:00 | 2010-02-27 00:00:00
2010-02-28 00:00:00 | 2010-03-06 00:00:00
2010-03-07 00:00:00 | 2010-03-13 00:00:00
2010-03-14 00:00:00 | 2010-03-20 00:00:00
2010-03-21 00:00:00 | 2010-03-27 00:00:00
2010-03-28 00:00:00 | 2010-04-03 00:00:00
2010-04-04 00:00:00 | 2010-04-10 00:00:00
2010-04-11 00:00:00 | 2010-04-17 00:00:00
2010-04-18 00:00:00 | 2010-04-24 00:00:00
2010-04-25 00:00:00 | 2010-05-01 00:00:00
2010-05-02 00:00:00 | 2010-05-08 00:00:00
2010-05-09 00:00:00 | 2010-05-15 00:00:00
2010-05-16 00:00:00 | 2010-05-22 00:00:00
2010-05-23 00:00:00 | 2010-05-29 00:00:00
2010-05-30 00:00:00 | 2010-06-05 00:00:00
2010-06-06 00:00:00 | 2010-06-12 00:00:00
2010-06-13 00:00:00 | 2010-06-19 00:00:00
2010-06-20 00:00:00 | 2010-06-26 00:00:00
2010-06-27 00:00:00 | 2010-07-03 00:00:00
2010-07-04 00:00:00 | 2010-07-10 00:00:00
2010-07-11 00:00:00 | 2010-07-17 00:00:00
2010-07-18 00:00:00 | 2010-07-24 00:00:00
2010-07-25 00:00:00 | 2010-07-31 00:00:00
2010-08-01 00:00:00 | 2010-08-07 00:00:00
2010-08-08 00:00:00 | 2010-08-14 00:00:00
2010-08-15 00:00:00 | 2010-08-21 00:00:00
2010-08-22 00:00:00 | 2010-08-28 00:00:00
2010-08-29 00:00:00 | 2010-09-04 00:00:00
2010-09-05 00:00:00 | 2010-09-11 00:00:00
2010-09-12 00:00:00 | 2010-09-18 00:00:00
2010-09-19 00:00:00 | 2010-09-25 00:00:00
2010-09-26 00:00:00 | 2010-10-02 00:00:00
2010-10-03 00:00:00 | 2010-10-09 00:00:00
2010-10-10 00:00:00 | 2010-10-16 00:00:00
2010-10-17 00:00:00 | 2010-10-23 00:00:00
2010-10-24 00:00:00 | 2010-10-30 00:00:00
2010-10-31 00:00:00 | 2010-11-06 00:00:00
2010-11-07 00:00:00 | 2010-11-13 00:00:00
2010-11-14 00:00:00 | 2010-11-20 00:00:00
2010-11-21 00:00:00 | 2010-11-27 00:00:00
2010-11-28 00:00:00 | 2010-12-04 00:00:00
2010-12-05 00:00:00 | 2010-12-11 00:00:00
2010-12-12 00:00:00 | 2010-12-18 00:00:00
2010-12-19 00:00:00 | 2010-12-25 00:00:00
2010-12-26 00:00:00 | 2011-01-01 00:00:00
Spreadsheet: gstorey__12028__boces2
Sheet: Sheet1

 |  |  | US Chippewa | CNG [NAME]
 |  |  | 16359.6 | 82380.15 | 2002-09-01 00:00:00
 |  |  | 32718.6 | 197037.45 | 2002-10-01 00:00:00
 |  |  | 70890.6 | 365790.3 | 2002-11-01 00:00:00
 |  |  | 70890.6 | 448683.15 | 2002-12-01 00:00:00
 |  |  | 87250.2 | 554177.7 | 2003-01-01 00:00:00
 |  |  | 76344 | 494120.4 | 2003-02-01 00:00:00
 |  |  | 70890.6 | 388905.9 | 2003-03-01 00:00:00
 |  |  | 43624.2 | 223354.65 | 2003-04-01 00:00:00
 |  |  | 32718.6 | 131019.3 | 2003-05-01 00:00:00
 |  |  | 10906.2 | 35479.8 | 2003-06-01 00:00:00
 |  |  | 8179.8 | 32753.4 | 2003-07-01 00:00:00
 |  |  | 8019.6 | 32593.2 | 2003-08-01 00:00:00
 |  |  | 17041.25 | 85578.35 | 2003-09-01 00:00:00
 |  |  | 34081.875 | 204700.625 | 2003-10-01 00:00:00
 |  |  | 73844.375 | 380094.325 | 2003-11-01 00:00:00
 |  |  | 73844.375 | 466128.625 | 2003-12-01 00:00:00
 |  |  | 90885.625 | 575784.475 | 2004-01-01 00:00:00
 |  |  | 79525 | 513381 | 2004-02-01 00:00:00
 |  |  | 73844.375 | 404173.075 | 2004-03-01 00:00:00
 |  |  | 45441.875 | 232114.375 | 2004-04-01 00:00:00
 |  |  | 34081.875 | 136166.025 | 2004-05-01 00:00:00
 |  |  | 11360.625 | 36880.025 | 2004-06-01 00:00:00
 |  |  | 8520.625 | 34040.025 | 2004-07-01 00:00:00
 |  |  | 8353.75 | 33873.15 | 2004-08-01 00:00:00
 |  |  | 17722.9 | 88134.45 | 2004-09-01 00:00:00
 |  |  | 35445.15 | 210437.65 | 2004-10-01 00:00:00
 |  |  | 76798.15 | 390546 | 2004-11-01 00:00:00
 |  |  | 76798.15 | 479079.65 | 2004-12-01 00:00:00
 |  |  | 94521.05 | 591291.6 | 2005-01-01 00:00:00
 |  |  | 82706 | 527184 | 2005-02-01 00:00:00
 |  |  | 76798.15 | 414624.75 | 2005-03-01 00:00:00
 |  |  | 47259.55 | 238305.8 | 2005-04-01 00:00:00
 |  |  | 35445.15 | 140028.6 | 2005-05-01 00:00:00
 |  |  | 11815.05 | 37959.25 | 2005-06-01 00:00:00
 |  |  | 8861.45 | 35005.65 | 2005-07-01 00:00:00
Spreadsheet: 168860d1342612870-trying-to-excluding-the-2-highest-and-2-lowest-values-when-averaging-a-series-of-numbers-work-budget
Sheet: ORIGINAL DATA

PREVIOUS 8 WEEKS OF NET SALES
WEEK BEGINNING | DAY OF WEEK | NET SALES | GROSS SALES
2012-05-21 00:00:00 | MONDAY |  | 8948.54
2012-05-22 00:00:00 | TUESDAY |  | 10169.21
2012-05-23 00:00:00 | WEDNESDAY |  | 9545.3
2012-05-24 00:00:00 | THURSDAY |  | 11981.58
2012-05-25 00:00:00 | FRIDAY |  | 16867.08
2012-05-26 00:00:00 | SATURDAY |  | 13072.57
2012-05-27 00:00:00 | SUNDAY |  | 8225.58
2012-05-28 00:00:00 | MONDAY |  | 11712.77
2012-05-29 00:00:00 | TUESDAY |  | 10207.6
2012-05-30 00:00:00 | WEDNESDAY |  | 10379.7
2012-05-31 00:00:00 | THURSDAY |  | 12228.7
2012-06-01 00:00:00 | FRIDAY |  | 16745.84
2012-06-02 00:00:00 | SATURDAY |  | 10913.28
2012-06-03 00:00:00 | SUNDAY |  | 7744.88
2012-06-04 00:00:00 | MONDAY |  | 10646.47
2012-06-05 00:00:00 | TUESDAY |  | 9522.62
2012-06-06 00:00:00 | WEDNESDAY |  | 9769.91
2012-06-07 00:00:00 | THURSDAY |  | 13655.45
2012-06-08 00:00:00 | FRIDAY |  | 17659.12
2012-06-09 00:00:00 | SATURDAY |  | 12389.71
2012-06-10 00:00:00 | SUNDAY |  | 7569.3
2012-06-11 00:00:00 | MONDAY |  | 8903.49
2012-06-12 00:00:00 | TUESDAY |  | 10754.64
2012-06-13 00:00:00 | WEDNESDAY |  | 11092.98
2012-06-14 00:00:00 | THURSDAY |  | 12413.82
2012-06-15 00:00:00 | FRIDAY |  | 14380.29
2012-06-16 00:00:00 | SATURDAY |  | 11986.46
2012-06-17 00:00:00 | SUNDAY |  | 7761.69
2012-06-18 00:00:00 | MONDAY |  | 10281.13
2012-06-19 00:00:00 | TUESDAY |  | 11673.42
2012-06-20 00:00:00 | WEDNESDAY |  | 11810.06
2012-06-21 00:00:00 | THURSDAY |  | 15458.17
2012-06-22 00:00:00 | FRIDAY |  | 18023.59
2012-06-23 00:00:00 | SATURDAY |  | 14250.74
2012-06-24 00:00:00 | SUNDAY |  | 7194.69
2012-06-25 00:00:00 | MONDAY |  | 10206.24
2012-06-26 00:00:00 | TUESDAY |  | 13086.04
2012-06-27 00:00:00 | WEDNESDAY |  | 11594.55
2012-06-28 00:00:00 | THURSDAY |  | 11467.86
2012-06-29 00:00:00 | FRIDAY |  | 16346.1
2012-06-30 00:00:00 | SATURDAY |  | 10656.22
2012-07-01 00:00:00 | SUNDAY |  | 6935.86
2012-07-02 00:00:00 | MONDAY |  | 12000.09
2012-07-03 00:00:00 | TUESDAY |  | 9868.23
2012-07-04 00:00:00 | WEDNESDAY |  | 10151.99
2012-07-05 00:00:00 | THURSDAY |  | 14125.46
2012-07-06 00:00:00 | FRIDAY |  | 18447.64
2012-07-07 00:00:00 | SATURDAY |  | 12294.71
2012-07-08 00:00:00 | SUNDAY |  | 6158.84
2012-07-09 00:00:00 | MONDAY |  | 11764.63
2012-07-10 00:00:00 | TUESDAY |  | 10013.85
2012-07-11 00:00:00 | WEDNESDAY |  | 11826.19
2012-07-12 00:00:00 | THURSDAY |  | 11199.87
2012-07-13 00:00:00 | FRIDAY |  | 13956.19
2012-07-14 00:00:00 | SATURDAY |  | 12033.81
2012-07-15 00:00:00 | SUNDAY |  | 7567.66
Spreadsheet: louise_kitchen__22633__SepQTD Orig w notes Faith
Sheet: Mexico

Mexico Origination
For the Quarter Ended September 30
By Team
Originator |  | Commodity |  | Team |  | Total |  | %Total
[NAME] |  | Gas |  | Mexico Origination |  | 1444860
[NAME] |  | Gas |  | Mexico Origination |  | 4515
Total
Spreadsheet: 600689d1543913724-monster-conditional-formatting-dummy-data
Sheet: Dummy

 | Sun | [NAME] | Earth | Mars | Delivered To | From
 | -1 |  |  |  | Custom | Sun
 | -2 | 2 |  |  | [NAME] | Sun
 | -3 |  | 3 |  | Earth | Sun
 | -2 |  |  | 2 | Mars | Sun
 | 1 |  |  |  | Sun | Custom
 | 2 | -2 |  |  | Sun | [NAME]
 | 3 |  | -3 |  | Sun | Earth
 | 3 |  |  | -3 | Sun | Mars
 |  | -4 |  |  | Custom | [NAME]
 | 3 | -3 |  |  | Sun | [NAME]
 |  | -2 | 2 |  | Earth | [NAME]
 |  | -1 |  | 1 | Mars | [NAME]
 |  | 1 |  |  | [NAME] | Custom
 | -2 | 2 |  |  | [NAME] | Sun
 |  | 3 | -3 |  | [NAME] | Earth
 |  | 4 |  | -4 | [NAME] | Mars
 |  |  | -1 |  | Custom | Earth
 | 2 |  | -2 |  | Sun | Earth
 |  | 3 | -3 |  | [NAME] | Earth
 |  |  | -4 | 4 | Mars | Earth
 |  |  | 4 |  | Earth | Custom
 | -3 |  | 3 |  | Earth | Sun
 |  | -2 | 2 |  | Earth | [NAME]
 |  |  | 1 | -1 | Earth | Mars
 |  |  |  | -4 | Custom | Mars
 | 3 |  |  | -3 | Sun | Mars
 |  | 2 |  | -2 | [NAME] | Mars
 |  |  | 1 | -1 | Earth | Mars
 |  |  |  | 1 | Mars | Custom
 | -2 |  |  | 2 | Mars | Sun
 |  | -3 |  | 3 | Mars | [NAME]
 |  |  | -4 | 4 | Mars | Earth
Spreadsheet: 147310d1332723866-aggregating-time-series-data-test-data
Sheet: Recharge Potential

 |  | 00:00:00 | 01:00:00 | 02:00:00 | 03:00:00 | 04:00:00 | 05:00:00 | 06:00:00 | 07:00:00 | 08:00:00 | 09:00:00 | 10:00:00 | 11:00:00 | 12:00:00 | 13:00:00 | 14:00:00 | 15:00:00 | 16:00:00 | 17:00:00 | 18:00:00 | 19:00:00 | 20:00:00 | 21:00:00 | 22:00:00 | 23:00:00
UID | 00:00:00 | 01:00:00 | 02:00:00 | 03:00:00 | 04:00:00 | 05:00:00 | 06:00:00 | 07:00:00 | 08:00:00 | 09:00:00 | 10:00:00 | 11:00:00 | 12:00:00 | 13:00:00 | 14:00:00 | 15:00:00 | 16:00:00 | 17:00:00 | 18:00:00 | 19:00:00 | 20:00:00 | 21:00:00 | 22:00:00 | 23:00:00 | 1900-01-01 00:00:00
A | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | D | 0 | 0 | 0 | 0 | 0 | 0 | 0 | D | 1 | 1 | 1 | 1 | 1 | 1
A | 2 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | D | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | D | 1 | 1 | 1 | 1 | 1 | 1
B | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | D | 0 | 0 | 0 | D | 0 | 0 | D | 1 | 1 | 1 | 1 | 1
B | 2 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | D | 1 | 1 | 1 | 1 | 1 | 1 | 1 | D | 1 | 1 | 1 | 1 | 1 | 1
 | Charge Count
 | Total
 | % Charge
Spreadsheet: 723303d1615620663-lookup-formula-to-return-sum-value-from-separate-workbook-program-totals-test
Sheet: Sheet2

Maingays 30x45, 80m, 20x20 & 50x50 prep
Item | units | Machine | Hours | cost | cost per unit
pads | 43 | Loader | 76.5 |  |  | Per Pad
sumps | 60 | Ex | 140.5 |  |  | Per individual sump
Mob & inductions
Total Maingays earthworks cost
Spreadsheet: 139466d1328260500-lookup-vertically-maybe-example
Sheet: Sheet1

Username | Location | White | Yellow | Green |  | result
username.1 | 1001 |  | x |  |  | username.1 | 1001 | Yellow
username.2 | 1002 | x |  | x |  | username.2 | 1002 | White | Green
Username.3 | 1001 | x | x | x |  | Username.3 | 1001 | White | Yellow | Green
Username.4 | 1001 |  | x |  |  | Username.4 | 1001 | Yellow
Spreadsheet: 780848d1652813505-how-can-i-cycle-through-range-and-extract-text-from-rows-if-rows-contain-specific-text-example-sheet
Sheet: Sheet1

Services List | Extracted Main Service | Extracted Secondary service list for each main service
Discovery Meeting: Durlu | Discovery Meeting | Durlu, Discovery Research | <- example only
Discovery Meeting: Discovery Research | Location Scouting
Location Scouting: In Oradea | Creative Development
Creative Development: Creative Research | Production Management | Location Scouting | <- example only (I need to extract them without the string coming after the second ":"
Creative Development: Trends Research | Video Production
Creative Development: Roadmap Creation | Cloud Asset Management
Production Management: Location Scouting: In Oradea | Final Handout Message
Video Production: Camera Setup: With Collaborators
Cloud Asset Management: Copying
Final Handout Message
Spreadsheet: stacey_white__39179__E&Y Info Request - Form A
Sheet: Form A

All suggested threshold levels on the following forms are for placeholder purposes only.  Final buckets to be determined following more in-depth analysis.
Enron and Affiliates
[NAME] as of: Nov 30, 2001
Commodity: Power (East and West) | Date of Preparation:  1/18/02
Legal Entity:  EPMI
Statistic | Financial | Physical | Total
 | Net | Net
Estimated MTM 1 ($) | -93990261 | 903367537
# of Counterparties
Counterparty Distribution by MTM 2 (#)
<$0mm | 66 | 27
>=$0mm, <$1mm | 26 | 55
>=$1mm, <$5mm | 6 | 34
>=$5mm, <$10mm | 2 | 15
>=$10mm | 2 | 38
# of Transactions
Transaction Distribution by MTM (#)
<$0mm | 1433 | 21704
>=$0mm, <$1mm | 1286 | 19957
>=$1mm, <$5mm | 42 | 1536
>=$5mm, <$10mm | 3 | 208
>=$10mm | 1 | 120
Tenor Distribution by Transactions (#)
< 1 year | 2377 | 35309
>=1 year, =<3 years | 274 | 7206
>3 years, =<5 years | 98 | 638
>5year, =<10 years | 16 | 355
> 10 years | 0 | 17
Tenor Distribution by MTM ($)
< 1 year | -39261266 | 258719350
>=1 year, =<3 years | -37904289 | -56384025
>3 years, =<5 years | -11006032 | 254820505
>5year, =<10 years | -5818674 | 710038773
> 10 years | 0 | -263827066
Trade Type Distribution by Transactions (#)
Forward | 2507 | 42813
Option
Index Forward | 221 | 0
Swaption | 2507 | 95
Annuity | 5 | 70
Trade Type Distribution by MTM ($)
Forward | -99685212 | 1014396533
Option
Index Forward | 207626 | 0
Swaption | 0 | 40424394
Annuity | 295966 | -113285977
Notes
* Additional forms for each commodity should be labeled as [NAME], Form A2, etc.
1 MTM ([NAME]-to-Market Value) reflects no adjustment for Collateral or Accounts Payable/Receivable
2  < indicates less than, >= indicates greater than/equal to
3 To be expanded depending on the underlying commodity
4  Does not include intercompany, cross commodity or transactions with EES, Inc.
5  Does not include Canada Power
Spreadsheet: 122178d1316639166-formula-to-determine-day-of-week-checks-will-be-cut-copy-of-thom-1
Sheet: Sheet1

Week Ending | Next Workday | Differences in Dates for 10th and 25th of current and next month |  |  |  | Next Workday + Minimum Diff | Due date
2011-07-24 00:00:00 | 2011-07-25 00:00:00 | -15 | 0 | 16 | 31 | 2011-07-25 00:00:00 | 2011-07-25 00:00:00
2011-07-31 00:00:00 | 2011-08-01 00:00:00 | -22 | -7 | 9 | 24 | 2011-08-10 00:00:00 | 2011-08-10 00:00:00
2011-08-07 00:00:00 | 2011-08-08 00:00:00 | 2 | 17 | 33 | 48 | 2011-08-10 00:00:00 | 2011-08-10 00:00:00
2011-08-14 00:00:00 | 2011-08-15 00:00:00 | -5 | 10 | 26 | 41 | 2011-08-25 00:00:00 | 2011-08-25 00:00:00
2011-08-21 00:00:00 | 2011-08-22 00:00:00 | -12 | 3 | 19 | 34 | 2011-08-25 00:00:00 | 2011-08-25 00:00:00
2011-08-28 00:00:00 | 2011-08-29 00:00:00 | -19 | -4 | 12 | 27 | 2011-09-10 00:00:00 | 2011-09-09 00:00:00
2011-09-04 00:00:00 | 2011-09-05 00:00:00 | 5 | 20 | 35 | 50 | 2011-09-10 00:00:00 | 2011-09-09 00:00:00
2011-09-11 00:00:00 | 2011-09-12 00:00:00 | -2 | 13 | 28 | 43 | 2011-09-25 00:00:00 | 2011-09-26 00:00:00
Spreadsheet: 537848d1505299873-how-to-split-rows-by-date-and-time-s666-1200664-how-to-split-rows-by-date-and-time
Sheet: Sheet2

Start Date | Start Time | End Date | End Time
2016-10-07 00:00:00 | 17:45:00 | 2016-10-08 00:00:00 | 00:00:00
2016-10-08 00:00:00 | 00:00:00 | 2016-10-08 00:00:00 | 11:20:00
2016-10-08 00:00:00 | 13:05:00 | 2016-10-09 00:00:00 | 00:00:00
2016-10-09 00:00:00 | 00:00:00 | 2016-10-09 00:00:00 | 11:10:00
2016-10-09 00:00:00 | 11:10:00 | 2016-10-10 00:00:00 | 00:00:00
2016-10-10 00:00:00 | 00:00:00 | 2016-10-10 00:00:00 | 11:15:00
2016-10-10 00:00:00 | 11:45:00 | 2016-10-10 00:00:00 | 14:45:00
2016-10-10 00:00:00 | 15:35:00 | 2016-10-10 00:00:00 | 17:30:00
2016-10-10 00:00:00 | 18:10:00 | 2016-10-11 00:00:00 | 00:00:00
2016-10-11 00:00:00 | 00:00:00 | 2016-10-11 00:00:00 | 08:15:00
2016-10-11 00:00:00 | 08:15:00 | 2016-10-11 00:00:00 | 09:40:00
2016-10-11 00:00:00 | 10:35:00 | 2016-10-11 00:00:00 | 12:50:00
2016-10-11 00:00:00 | 13:50:00 | 2016-10-11 00:00:00 | 14:45:00
2016-12-15 00:00:00 | 19:50:00 | 2016-12-15 00:00:00 | 19:50:00
2016-12-15 00:00:00 | 21:05:00 | 2016-12-16 00:00:00 | 00:00:00
2016-12-16 00:00:00 | 00:00:00 | 2016-12-16 00:00:00 | 11:15:00
2016-12-16 00:00:00 | 14:05:00 | 2016-12-17 00:00:00 | 00:00:00
2016-12-17 00:00:00 | 00:00:00 | 2016-12-17 00:00:00 | 09:50:00
2016-12-17 00:00:00 | 11:05:00 | 2016-12-17 00:00:00 | 11:35:00
2016-12-17 00:00:00 | 16:25:00 | 2016-12-18 00:00:00 | 00:00:00
2016-12-18 00:00:00 | 00:00:00 | 2016-12-18 00:00:00 | 10:10:00
2016-12-18 00:00:00 | 12:15:00 | 2016-12-19 00:00:00 | 00:00:00
2016-12-19 00:00:00 | 00:00:00 | 2016-12-20 00:00:00 | 00:00:00
2016-12-20 00:00:00 | 00:00:00 | 2016-12-20 00:00:00 | 11:30:00
Spreadsheet: sally_beck__33995__Log as of 4_20_01
Sheet: Sum Mar 14 to Mar 20

 | Week summary ([NAME] 14 to Mar 20)
Category | Description | Total |  | Breakdown of Cat 1
1 | Human Errors |  |  | Process in place but not followed
2 | IT Hardware problems |  |  | Officialized on time but needed recalc
3 | IT Software Problems |  |  | Book not officialized
4 | Miscellaneous |  |  | No process in place
5 | Uncontrollable | 0 |  | Other
 | Total |  |  | Total
 |  |  |  | Breakdown of Cat 2
 |  |  |  | Computer breakdown | 0
 |  |  |  | Other
 |  |  |  | Total
 |  |  |  | Breakdown of Cat 3
 |  |  |  | Correct inputs, incorrect outputs
 |  |  |  | Slow feeds
 |  |  |  | Feed problem
 |  |  |  | Books shown as officialized, but not RiskTrac
 |  |  |  | Application down alternate system used
 |  |  |  | Other
 |  |  |  | Total
 |  |  |  | Breakdown of Cat 4
 |  |  |  | Credit interface | 0
 |  |  |  | Other | 0
 |  |  |  | Total
Spreadsheet: 43561d1242209483-viewing-multiple-worksheets-on-one-main-worksheet-2009-10-calendar
Sheet: June Child

CYPD TRAINING JUNE  2009
Sunday |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday
 |  | 2009-06-01 00:00:00 |  | 2009-06-02 00:00:00 |  | 2009-06-03 00:00:00 |  | 2009-06-04 00:00:00 |  | 2009-06-05 00:00:00 |  | 2009-06-06 00:00:00
2009-06-07 00:00:00 |  | 2009-06-08 00:00:00 |  | 2009-06-09 00:00:00 |  | 2009-06-10 00:00:00 |  | 2009-06-11 00:00:00 |  | 2009-06-12 00:00:00 |  | 2009-06-13 00:00:00
2009-06-14 00:00:00 |  | 2009-06-15 00:00:00 |  | 2009-06-16 00:00:00 |  | 2009-06-17 00:00:00 |  | 2009-06-18 00:00:00 |  | 2009-06-19 00:00:00 |  | 2009-06-20 00:00:00
2009-06-21 00:00:00 |  | 2009-06-22 00:00:00 |  | 2009-06-23 00:00:00 |  | 2009-06-24 00:00:00 |  | 2009-06-25 00:00:00 |  | 2009-06-26 00:00:00 |  | 2009-06-27 00:00:00
2009-06-28 00:00:00 |  | 2009-06-29 00:00:00 |  | 2009-06-30 00:00:00
 |  |  |  |  |  |  |  |  |  | Notes:
Spreadsheet: 3e7d8c7d-0de7-4135-a2a7-50173407a2fc
Sheet: REG 1 Staff

REGIONAL DIRECTORY 2014/2015
SANTA CLARA COUNTY OFFICE OF EDUCATION STAFF
PROGRAM ADMINISTRATORS | SUPPPORT STAFF | PROGRAM ADVOCATES
[NAME], Director | [NAME], Administrative Assistant III | Adriana Magallon, Program Advocate
1290 Ridder Park Dr. MC 233 | O: [PHONE] | O: [PHONE]
San Jose, [NAME] | [EMAIL] | C: [PHONE]
O: [PHONE] |  | [EMAIL]
C: [PHONE] | Simi Pannu, Enrollment Data Specialist II
F: [PHONE] | O: [PHONE] | [NAME], Program Advocate - OSY
[EMAIL] | [EMAIL] | O: [PHONE]
 |  | C: [PHONE]
[NAME], Program Manager | [NAME], Enrollment Data Specialist I | [EMAIL]
O: [PHONE] | O: [PHONE]
C: [PHONE] | [EMAIL] | Cecilia Real Prado, Program Advocate
[EMAIL] |  | O: [PHONE]
 | SPECIALISTS | C: [PHONE]
[NAME], Program Manager |  | [EMAIL]
O: [PHONE] | [NAME], OSY Program Specialist
C: [PHONE] | O: [PHONE] | Heather Valdez, Program Advocate
[EMAIL] | C: [PHONE] | O: [PHONE]
 | [EMAIL] | C: [PHONE]
[NAME], Preschool Coordinator |  | [EMAIL]
O: [PHONE] | [NAME], Parent Ed/Health Program Spe.
C: [PHONE] | O: [PHONE] | [NAME], Program Advocate
[EMAIL] | C: [PHONE] | O: [PHONE]
 | [EMAIL] | C: [PHONE]
[NAME], ID&R Supervisor |  | [EMAIL]
O: [PHONE] | Blanca Gomez-Anaya, Intervention Teacher
C: [PHONE] | O: [PHONE] | [NAME], Regional Community Liaison
[EMAIL] | C: [PHONE] | O: [PHONE]
 | [EMAIL] | C: [PHONE]
[NAME], Accountant Fiscal Services |  | [EMAIL]
1290 Ridder Park Dr. [NAME] | [NAME], Preschool Teacher/Coach
San Jose, [NAME] | O:  [PHONE] | [NAME], [NAME]
O: [PHONE] | C:  [PHONE] | O: [PHONE]/[PHONE]
F: [PHONE] | [EMAIL] | C: [PHONE]
[EMAIL] |  | [EMAIL]
 | Maria Carmen Navarro, Preschool Teacher
 | O: [PHONE]
 | C: [PHONE]
 | [EMAIL]
Spreadsheet: 853853d1703804826-ranking-and-grouping-data-ranking-and-grouping-data-v2
Sheet: Sheet1

Grouping thread
[NAME] | Team | Score |  | Final Group | Team A - 1 | Team A - 2 | Team A - 3 | Team B - 1 | Team B - 2 | Team B - 3
[NAME] | A | 65 |  | 1
[NAME] | A | 66 |  | 2
[NAME] | B | 67 |  | 3
[NAME] | B | 68 |  | 4
[NAME] | A | 69
[NAME] Im | A | 70
[NAME] | B | 71
[NAME] | A | 72
Mackenzie Hughes | B | 73
[NAME] | A | 70
[NAME] | A | 70
[NAME] | B | 70
[NAME] | A | 77
Lucas Glover | A | 78
[NAME] | A | 72
[NAME] | B | 72
[NAME] | B | 72
[NAME] | B | 82
[NAME] | B | 83
[NAME] | B | 84
[NAME] | A | 85
[NAME] | B | 86
[NAME] | B | 87
[NAME] | B | 88
Spreadsheet: 478859d1473113614-how-to-update-sheet1-from-sheet2-automatically-samplefile
Sheet: Sheet2

FirstName | LastName | ProductType | LastDatePurchased
FName100 | [NAME] | abc | 2010-01-01 00:00:00
FName200 | LName200 | def | 2011-01-01 00:00:00
FName3 | LName3 | food | 2012-01-01 00:00:00 | this date should go to sheet 1 for FName3-LName3
FName400 | LName400 | xyz | 2013-01-01 00:00:00
FName5 | LName5 | abc | 2014-01-01 00:00:00 | this date should NOT go to sheet 1 because it is not Food altough Fname5 is there
FName600 | LName600 | def | 2015-01-01 00:00:00
FName7 | LName7 | food | 2016-01-01 00:00:00 | this date should go to sheet 1 for FName7-LName7
FName8 | [NAME] | food | 2016-01-01 00:00:00 | this row should be added to Sheet1, extra record
FName9 | LName9 | food | 2016-01-01 00:00:00 | this row should be added to Sheet1, extra record
Spreadsheet: 150368d1334483652-when-2-columns-meet-criteria-find-the-max-in-another-column-and-subtract-from-another-col-example3
Sheet: TOTALS

G R O U P | C L A S S | S O U R C E | S A L E S | T1 | WKS | YEAR | CUST # | CUSTOMER | BANK | MACHINE | AVER WEEK | AVER MONTH | [NAME] | [NAME] 2 | [NAME] 3 | [NAME] 4 | TOTAL | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC |  | S WK
 |  |  |  |  |  | 2012 | 165 | [NAME] | 1 | 8272 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  | 2012 | 165 | [NAME] | 1 | 9565 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 |  |  |  |  |  | 2012 | 165 | [NAME] | 3 | 9873 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  | T1 |  | 2012 | 165 | [NAME] | company | ALL
Spreadsheet: 701623d1603857958-index-match-formula-problem-sample
Sheet: Options

OPTION | BOM | COST | IMAGE | =INDEX(BOM!H2:H2000,MATCH(B9,BOM!B2:B2000,0))
Pre-delivery
CMV | 100 | 2200
TATIARA | - | 1758.97
BAYSWATER | - | 1963.6
100l diesel & 40l adblue
AdBlue (40 l) & Diesel (100 l) | 101 | 154.8
Suzi coil + cable ties
Suzi Coil + Cable Ties | 102 | 81.31
Fire ex and air blower in cab
Fire 1.5kg ABE | 110 | 209.53 |  |  |  |  |  |  | =IFERROR(INDEX('BOM'!H2:$H2000,MATCH(B9,'BOM'!$B$2:$B$2000,0)),"")
Fire 2.5kg ABE (with vehicle brackets) | 111 | 223.28 |  |  |  |  |  |  | =IFERROR(INDEX(Labour,MATCH(Options!B9,Code,0)),"")
WHEEL ALLIGMENT
 |  |  |  |  |  |  |  |  | =IFERROR(INDEX(Labour,SMALL(IF(ISNUMBER(MATCH(Code,B9,0)),MATCH(ROW(Code),ROW(Code)),""),ROWS($A$1:A1))),"")
 |  |  |  |  |  |  |  |  | =VLOOKUP(B9,'BOM Codes'!$B$3:$H$154,7,FALSE)