tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 09ae7a7e-fc8e-4eba-b5c4-1e2036a9c697
Sheet: 9 - 5yr Collision (Previous)

ATTACHMENT 9:  Prior 5-Year Collision Data (2004-2008)
Collision Reports 2004-2008
Vasco Road Safety Improvements - Phase 2
Source: Collision Reports, California Highway Patrol (CHP)
Primary Cause | 2004 | 2005 | 2006 | 2007 | 2008 | Total | %
[NAME] | 7 | 3 | 3 | 2 | 2
Wrong Side of Road | 1 | 0 | 0 | 0 | 3
Unsafe Lane Change | 1 | 0 | 0 | 1 | 1
Unsafe Speed | 12 | 13 | 16 | 6 | 2
Other Equipment | 0 | 0 | 0 | 0 | 1
[NAME] | 1 | 2 | 0 | 1 | 1
Auto R/W Violation | 0 | 1 | 2 | 2 | 0
Following Too Closely | 0 | 0 | 2 | 1 | 0
Driving Under Influence | 2 | 0 | 2 | 0 | 0
Other Than Driver or Ped | 3 | 2 | 1 | 0 | 0
Unknown | 1 | 0 | 0 | 0 | 0
Traffic Signals and Signs | 1 | 0 | 0 | 0 | 0
Other Hazardous Movement | 1 | 0 | 0 | 0 | 0
Total
 | 2004 | 2005 | 2006 | 2007 | 2008 | Total
Total Collisions | 30 | 21 | 26 | 13 | 10
Injury Collisions | 11 | 8 | 12 | 5 | 4
Fatal Collisions | 1 | 1 | 2 | 0 | 0
Severity | 2004 | 2005 | 2006 | 2007 | 2008 | Total
Injuries | 20 | 13 | 17 | 5 | 4
Fatalities | 4 | 1 | 5 | 0 | 0
Total
Collisions that could have been prevented by median barrier:
Severity | 2004 | 2005 | 2006 | 2007 | 2008 | Total
Injuries | 6 | 4 | 7 | 2 | 2
Fatalities | 4 | 1 | 4 | 0 | 0
Total
 | 5-Year Total | Prevented | % | 5-Year Average
Injuries
Fatalities
Spreadsheet: 68971d1269509386-colouring-numbers-in-a-chart-vehicle-status-chart
Sheet: Sheet1

Vehicle Status Chart
Fully Charged |  |  |  |  |  |  | Flat
1 | 2 | 3 | 4 | 5 | 6 |  | 1 | 2 | 3 | 4 | 5 | 6
7 | 8 | 9 | 10 | 11 | 12 |  | 7 | 8 | 9 | 10 | 11 | 12
13 | 14 | 15 | 16 | 17 | 18 |  | 13 | 14 | 15 | 16 | 17 | 18
19 | 20 | 21 | 22 | 23 | 24 |  | 19 | 20 | 21 | 22 | 23 | 24
Spreadsheet: 813318d1673662679-lookup-and-count-values-across-multiple-tables-problem-example
Sheet: Sheet1

 | Group | Person 1 | Person 2 | Person 3 | Person 4 | Person 5 |  | Group | Characteristic
 | Group A | X |  | X |  |  |  | Group A | C1
 | Group B |  | X | X |  |  |  | Group A | C2
 | Group C |  |  |  | X |  |  | Group A | [NAME]
 |  |  |  |  |  |  |  | Group B | C1
 |  |  |  |  |  |  |  | Group B | C4
 |  |  |  |  |  |  |  | Group C | C2
 |  |  |  |  |  |  |  | Group C | C4
 |  |  |  |  |  |  |  | Group C | C5
 | Correct Output:
 | Characteristic | Person 1 | Person 2 | Person 3 | Person 4 | Person 5
 | C1
 | C2 | 1 |  | 1 | 1
 | [NAME] | 1 |  | 1
 | C4 |  | 1 | 1 | 1
 | C5 |  |  |  | 1
 | C6
Spreadsheet: 4d50c8e8-6d70-4d66-a722-e03c68c7d226
Sheet: Colombia

Export Sales | Unshipped Balance |  | Accumulated Exports |  | Total Commitments
Colombia | this year | last year | this year | last year | this year | last year
Spreadsheet: 8a4f90d8-7688-41c4-8b28-887bcd5fe201
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
43050809 | 2014-09-07 00:28:22 | AXIS | 1 | 5 | 3 | 506159 | Hurletout | 6157 | western | 1944-11-19 | 1944-11-23 | Saverne Gap | [NAME]
43051020 | 2014-09-07 00:41:41 | ALLIES | 0 | 2 | 5 | 506159 | Hurletout | 6157 | western | 1944-11-19 | 1944-11-23 | Saverne Gap | [NAME]
43142804 | 2014-09-13 18:04:32 | ALLIES | 1 | 5 | 3 | 379890 | Wun-Lon | 6157 | western | 1944-11-19 | 1944-11-23 | Saverne Gap | [NAME]
43143023 | 2014-09-13 18:22:42 | AXIS | 1 | 5 | 3 | 379890 | Wun-Lon | 6157 | western | 1944-11-19 | 1944-11-23 | Saverne Gap | [NAME]
43176084 | 2014-09-15 22:58:15 | ALLIES | 1 | 5 | 2 | 1373296 | player1373296 | 6157 | western | 1944-11-19 | 1944-11-23 | Saverne Gap | [NAME]
43176335 | 2014-09-15 23:15:05 | ALLIES | 0 | 5 | 6 | 1617365 | hailKingFrank | 12501 | western | 1940-05-21 | 1940-05-21 | Counter-Attack at Arras | Contre-attaque d'Arras
43176554 | 2014-09-15 23:33:52 | AXIS | 1 | 6 | 3 | 1617365 | hailKingFrank | 12501 | western | 1940-05-21 | 1940-05-21 | Counter-Attack at Arras | Contre-attaque d'Arras
43176871 | 2014-09-15 23:52:03 | AXIS | 1 | 6 | 3 | 1617365 | hailKingFrank | 12506 | eastern | 1941-07-21 | 1941-07-31 | [NAME] | Percée russe
43177063 | 2014-09-16 00:07:02 | ALLIES | 0 | 5 | 6 | 1617365 | hailKingFrank | 12506 | eastern | 1941-07-21 | 1941-07-31 | [NAME] | Percée russe
43226839 | 2014-09-19 20:39:13 | ALLIES | 0 | 4 | 5 | 1227655 | rwhgeek | 6157 | western | 1944-11-19 | 1944-11-23 | Saverne Gap | [NAME]
43227080 | 2014-09-19 20:53:32 | AXIS | 1 | 5 | 2 | 1227655 | rwhgeek | 6157 | western | 1944-11-19 | 1944-11-23 | Saverne Gap | [NAME]
43227267 | 2014-09-19 21:06:09 | ALLIES | 1 | 5 | 3 | 1602000 | Stipo | 6157 | western | 1944-11-19 | 1944-11-23 | Saverne Gap | [NAME]
43227424 | 2014-09-19 21:19:36 | AXIS | 1 | 5 | 2 | 1602000 | Stipo | 6157 | western | 1944-11-19 | 1944-11-23 | Saverne Gap | [NAME]
43227621 | 2014-09-19 21:37:14 | ALLIES | 1 | 5 | 3 | 407643 | WitJR | 6157 | western | 1944-11-19 | 1944-11-23 | Saverne Gap | [NAME]
43227858 | 2014-09-19 22:02:23 | AXIS | 0 | 4 | 5 | 407643 | WitJR | 6157 | western | 1944-11-19 | 1944-11-23 | Saverne Gap | [NAME]
Spreadsheet: 27d67f7f-eb6b-4ed3-9c63-9cf737602853
Sheet: Sheet1

New Member Report Form
Begin by entering your chapter name and the division and chapter number. Enter your name and contact information as well as the date. Begin entering new members by selecting their member type from the drop down at the beginning of each line. Fill in the name, address, and contact information fields. Select the appropriate length of membership from the drop down. If it is a former member, check the appropriate box and, if available, enter the previous ID number. Print two copies and submit along with your tally sheet and check! You can also save the completed sheet as an Excel file for future reference.
Chapter Name: |  |  |  | Division and Chapter Number: |  | State:
Your Name: |  |  |  |  |  | Phone:
E-mail: |  |  |  |  |  | Date:
Member | Birth Date | Name | Address | Phone Numbers (home, work, cell) | Length of | Former Member | Sponsor/Recruiter
Type | ([NAME]) | (First, Initial, Last) | (Street, Apt., [NAME], City, State, Zip) | and [NAME] | Membership | and ID # | Full Name and ID #
STATE |  | MEMBER TYPES
Alabama |  | RG    Individual
California |  | FM    Family
Colorado |  | ST    Student
England |  | YH    Youth
Florida |  | LF    Life
Georgia |  | FL    Family Life
Idaho |  | LB    Life Benefactor
Illinois |  | FB    Family Life Benefactor
Indiana |  | SC    Division Senior
Iowa
Maryland
Massachusetts |  | Length of Membership
Michigan |  | 1 Year
Minnesota |  | 1/2 Year
Nebraska |  | 1-1/2 Year
New Jersey
New York
North Carolina
North Dakota
Ohio
Oklahoma
Oregon
Pennsylvania
South Dakota
Tennessee
Virginia
Washington
West Virginia
Wisconsin
Wyoming
Spreadsheet: 870090d1716608962-grabbing-data-from-a-data-table-between-2-dates-excel-2010-tornadoes-between-date-bvj-s
Sheet: ben's sol'n

Occurrences | Date | Start Time | End Time | # of Counties | Counties | Length | [NAME] | Deaths | Injuries | Rating |  | RawData | =[NAME]
 |  |  |  |  |  |  |  |  |  |  |  | RawDataHeaders | =Sheet1!$B$5:$K$5
 |  |  |  |  |  |  |  |  |  |  |  | RptEnd | =Sheet1!$Q$2
 |  |  |  |  |  |  |  |  |  |  |  | RptStart | =Sheet1!$O$2
Spreadsheet: 785998d1656918859-how-to-transpose-a-complex-table-ppsolution
Sheet: Sheet1

ID | Language | Term |  |  | NewTerm | Column Labels
1 | EN | Term 1 |  |  | Row Labels | EN | FR
1 | EN | Synonym to term 1 |  |  | 1 | Term 1, Synonym to term 1 | Term 1
1 | FR | Term 1 |  |  | 2 | Term 2
2 | EN | Term 2
Spreadsheet: 60113d1260643847-creating-automatic-customer-code-by-index-temp_avk
Sheet: Sheet1

code | name | FORMULA FOR AUTOMATIC CREATEING CUSTOMER CODE
A001 | A AMARCHAND
A002 | A TO Z ENGINEERING
A003 | A.A.ENARGY
B001 | BAHUBALI CONST
B002 | BAIG CONST
C001 | CHANDRAKANT JAISWAL
C002 | CHANDRAPUR HEALTH CARE LTD.
C003 | CHANDRASHEKHAR C.
C004 | CHANDULAL CHAGANLAL POBARU TAB
Spreadsheet: 01e118d2-4d57-43b6-b1bf-5ad2f5dedb28
Sheet: Criminal Justice Certificates

CRIMINAL JUSTICE                                        Student Name:  __________________________________
ID # ____________________________________________
Certificates
Criminal Justice Core | Semester | Grade
___ CRJ 100 (3)Introduction to Criminal Justice
___ CRJ 202 (3) Issues and Ethics in Criminal Justice
___ CRJ 204 (3) Criminal Investigation
___ CRJ 216 (3) Criminal Law
___ CRJ 217 (3) Criminal Procedures
Corrections
___ CRJ 102 (3) Introduction to Criminal Justice
___ CRJ 203 (3) Community Corrections:  Probation and Parole
___ CRJ 208 (3) Delinquency and the Juvenile Justice System
___ CRJ 222 (3) Prison and Jail Administration
___ CRJ 231 (3) Legal Aspects of Corrections
Law Enforcement
___ CRJ 215 (3) Introduction to Law Enforcement
___ CRJ 218 (3) Pollice Supervision
___ CRJ 204 (3) Criminal Investigations
OR ___ CRJ 201 (3) Introduction to Criminalistics
___ CRJ 211 (3) Liability and Legal Issues
___ CRJ 208 (3) Delinquency and the Juvenile Justice System
Security and Loss Prevention
___ CRJ 110 Principles of Asset Protection
___ CRJ 210 (3) Physical Security Technology & Systems
___ CRJ 211 (3) Liability and Legal Issues
___ CRJ 240 (3) Intorduction to Corporate Security
___ CRJ 220 (3) Introduction to Computer Forensics
Spreadsheet: 774387d1648453420-removing-time-stamps-that-are-less-then-x-seconds-after-the-previous-time-stamp-example
Sheet: Sheet1

YEAR |  | MONTH |  | DAY |  | HOUR |  | MINUTE |  | SECOND |  |  | DATE | TIME
2022 |  | 03 |  | 16 |  | 06 |  | 37 |  | 37.286888201
2022 |  | 03 |  | 16 |  | 06 |  | 38 |  | 57.803293075
2022 |  | 03 |  | 16 |  | 06 |  | 39 |  | 55.702696583
2022 |  | 03 |  | 16 |  | 06 |  | 40 |  | 52.298832157
2022 |  | 03 |  | 16 |  | 06 |  | 41 |  | 22.361894449
2022 |  | 03 |  | 16 |  | 06 |  | 41 |  | 53.759021682
2022 |  | 03 |  | 16 |  | 06 |  | 42 |  | 32.563458551
2022 |  | 03 |  | 18 |  | 01 |  | 47 |  | 16.772180474
2022 |  | 03 |  | 18 |  | 01 |  | 55 |  | 29.081497242
2022 |  | 03 |  | 18 |  | 01 |  | 56 |  | 48.992103445
2022 |  | 03 |  | 18 |  | 01 |  | 57 |  | 06.153136562
2022 |  | 03 |  | 18 |  | 02 |  | 00 |  | 51.205823250
2022 |  | 03 |  | 18 |  | 02 |  | 01 |  | 21.268773632
2022 |  | 03 |  | 18 |  | 02 |  | 03 |  | 42.641710577
2022 |  | 03 |  | 18 |  | 02 |  | 09 |  | 38.327256588
2022 |  | 03 |  | 18 |  | 02 |  | 10 |  | 08.390222403
2022 |  | 03 |  | 18 |  | 02 |  | 13 |  | 22.675620826
2022 |  | 03 |  | 18 |  | 02 |  | 13 |  | 52.738636748
2022 |  | 03 |  | 18 |  | 02 |  | 15 |  | 29.579837570
2022 |  | 03 |  | 18 |  | 02 |  | 19 |  | 42.015558157
2022 |  | 03 |  | 18 |  | 02 |  | 25 |  | 08.590306199
2022 |  | 03 |  | 18 |  | 02 |  | 25 |  | 38.653283326
Spreadsheet: 705823d1606319744-trying-to-determine-cost-based-on-multiple-variables-using-vlookup-to-price-by-quadrants
Sheet: Sheet2

Indicator | # of Units | Cost |  |  |  |  |  |  | Cost per Unit Should be | Cost Should be
10123 | 4 |  |  |  | 101 |  |  |  | 5000
10342 | 42 |  |  |  | 0 | 5000 |  |  | 2000
10287 | 86 |  |  |  | 5 | 2500 |  |  | 600
10267 | 22 |  |  |  | 20 | 1500 |  |  | 2000
10316 | 12 |  |  |  | 50 | 1000 |  |  | 4500
10114 | 7 |  |  |  | 100 | 400 |  |  | 2500
10349 | 1.5 |  |  |  |  |  |  |  | 6000
10135 | 18 |  |  |  | 102 |  |  |  | 2500
 |  |  |  |  | 0 | 4000
 |  |  |  |  | 3 | 3000
 |  |  |  |  | 15 | 2000
 |  |  |  |  | 40 | 1200
 |  |  |  |  | 75 | 600
 |  |  |  |  | 103
 |  |  |  |  | 0 | 6000
 |  |  |  |  | 10 | 4500
 |  |  |  |  | 30 | 2000
 |  |  |  |  | 80 | 1500
Spreadsheet: 271106d1381826872-creating-a-list-from-a-roster-testsheet
Sheet: Ward Clerks

Ward Clerks |  | Mon |  | [NAME] |  | Wed |  | Thurs |  | Fri |  | Sat |  | Sun |  | Mon |  | [NAME] |  | Wed |  | Thurs |  | Fri |  | Sat |  | Sun
 |  | 2013-10-07 00:00:00 |  | 2013-10-08 00:00:00 |  | 2013-10-09 00:00:00 |  | 2013-10-10 00:00:00 |  | 2013-10-11 00:00:00 |  | 2013-10-12 00:00:00 |  | 2013-10-13 00:00:00 |  | 2013-10-14 00:00:00 |  | 2013-10-15 00:00:00 |  | 2013-10-16 00:00:00 |  | 2013-10-17 00:00:00 |  | 2013-10-18 00:00:00 |  | 2013-10-19 00:00:00 |  | 2013-10-20 00:00:00
Name
Bette Becenti | Early | Bette Becenti |  | Bette Becenti |  | Bette Becenti |  | Dylan Dicus |  | Dylan Dicus |  |  |  |  |  | Bette Becenti |  | Bette Becenti |  | Bette Becenti |  | Bette Becenti |  | [NAME] Spinella
Dylan Dicus | Late
[NAME] Spinella
Spreadsheet: 118754d1313983324-how-to-capture-most-latest-childs-birth-date-for-albert-from-raw-data-book1-1-
Sheet: Sheet1

Raw Data |  |  |  |  |  | [NAME]
ID | Name | Member | Type of family | Birth Date
1254 | [NAME] | 1 | Spouse | 06.09.1971 |  | 09/06/1971 | 1971-09-06 00:00:00
1254 | [NAME] | 2 | Child | 14.06.1996 |  | 06/14/1996 | 1996-06-14 00:00:00
1254 | [NAME] | 2 | Child | 29.05.2001 |  | 05/29/2001 | 2001-05-29 00:00:00
1254 | [NAME] | 2 | Child | 09.06.2011 |  | 06/09/2011 | 2011-06-09 00:00:00
1647 | [NAME] | 1 | Spouse | 09.09.1979 |  | 09/09/1979 | 1979-09-09 00:00:00
1647 | [NAME] | 2 | Child | 09.06.2005 |  | 06/09/2005 | 2005-06-09 00:00:00
1647 | [NAME] | 2 | Child | 20.02.2011 |  | 02/20/2011 | 2011-02-20 00:00:00
How to capture most latest child's birth date for [NAME] from raw data? |  |  |  |  |  | 20.02.2011 | Note: confirm the formula through Ctrl+Shift+Enter
Answer = 20.02.2011 |  |  |  |  | or | 20.02.2011 | Note: confirm the formula through Ctrl+Shift+Enter
* Result I would like to show is 20.02.2011 (General format)
Spreadsheet: 0780fbf6-4f13-4b6d-988d-932b43f206e1
Sheet: Property Services (400)

Part II Budget Detail
Amounts paid for services, rendered by organizations or personnel not on payroll of the school, to operate, repair, maintain, insure and rent property
owned and/or used by the school.
Purchased Property Services (400)
Description | Project Year 1 | Project Year 2 | Project Year 3 | Total
Spreadsheet: 788952d1658821777-collate-data-from-other-sheets-by-list-selection-sample
Sheet: Master

 |  | Hours Actual | Hours Target | Contract Actual | Contract Target |  |  |  |  |  |  | Outs Training | Outs Other
 | Store
 | Store 1
 | Store 2
 | Store 3
 | Store 4
 | Store 5
 | Store 6
 | Store 7
 | Store 8
 | Store 9
 | Store 10
 | Store 11
 | Store 12
 | Store 13
 | Store 14
 | Store 15
 | Store 16
 | Store 17
 | Area Total
Spreadsheet: chris_dorland__1623__Forwards Detail_MIRANT_CAD_DEC27
Sheet: Pivot

CAD/GJ
Sum of Value
Deal Num | Total
(blank)
QP7039.1 | 1388353.3668
V64794.1 | -1882321.5623
V67831.1 | -1486845.7481
V70968.1 | -1191885.9411
V92532.1 | -441183.4113000002
V98653.1 | 1894846.3145
VB4050.1 | 4950293.313699999
VC5783.3 | 9006471.581699997
VD3558.1 | 7448980.856500003
VF2542.1 | 236640.3811000001
[NAME] | -1416798.9074
VG9103.1 | -258996.4061
VH0021.1 | 1409387.3197
VQ9540.1 | -720109.663
VT2543.1 | 354003.8461999999
VT5299.1 | 161769.8461
Y46805.1 | 9266053.368899995
Y92833.1 | -117899.0828
YA7382.1 | -198800.2098
YA7382.2 | 137876.8105
YA7593.1 | -95477.9009
YA7593.2 | 32822.35619999999
YA8854.1 | -84889.91849999999
YA8854.2 | 32822.35619999999
YC1650.1 | -55942.8849
YE3026.1 | -640647.4321
YF5957.1 | -51633.41050000001
YF5957.2 | 43041.2778
Y52420.1 | -3592.7269
Y52471.1 | -2694.4104
Y81297.1 | -6603.049300000001
Grand Total | 27707040.33049999
Spreadsheet: 689823d1596681190-fill-range-of-cells-with-corresponding-data-this-example-b6
Sheet: Layout

 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
A
B
C
D
E
F
G
H
Spreadsheet: 701373d1603725891-automatically-sort-data-in-alphabetical-order-using-formula-array-and-non-array-formula-sort_alphanetically_sample
Sheet: Sort

Sales | Sort
 | Apple
 | Corn
 | Married
 | Single
Spreadsheet: 836043d1689066063-summary-across-multiple-sheets-and-reference-list-excel-linup-help-game-lineup-2023-07-07
Sheet: G1 - 9 - Marengo

Date: |  | 2023-07-09 00:00:00 |  |  | Field: | 6 |  | Start Time: |  | 09:00:00
Home: |  | SYB 8U All Star Black |  |  | 3rd | Set Up
Visitors: |  | Marengo |  |  | 1st | Clean Up
 |  |  |  |  | Inning
 |  | Player |  |  | Coach Pitch |  |  |  |  |  | Innings on Bench | Innings in Infield | Inninings in Outfield |  | [NAME]
Order |  | First | Last | # | 1 | 2 | 3 | 4 | 5 | 6 |  |  |  |  | First Name | Last Name | Number
1 | 12 | Player | One | 1 | LCF | LCF | LCF | SS | SS | SS |  |  |  |  | Player | One | 1
2 | 11 | Player | Two | 2 | SS | SS | SS | LF | LF | LF |  |  |  |  | Player | Two | 2
3 | 1 | Player | Three | 3 | 1B | 1B | 1B | LCF | LCF | LCF |  |  |  |  | Player | Three | 3
4 | 2 | Player | Four | 4 | X | X | P | 1B | 1B | 1B |  |  |  |  | Player | Four | 4
5 | 4 | Player | Five | 5 | LF | LF | LF | 2B | 2B | 2B |  |  |  |  | Player | Five | 5
6 | 5 | Player | Six | 6 | 2B | 2B | 2B | RCF | RCF | RCF |  |  |  |  | Player | Six | 6
7 | 10 | Player | Seven | 7 | 3B | 3B | 3B | RF | RF | RF |  |  |  |  | Player | Seven | 7
8 | 9 | Player | Eight | 8 | RF | RF | RF | P | C | C |  |  |  |  | Player | Eight | 8
9 | 6 | Player | Nine | 9 | RCF | RCF | RCF | 3B | 3B | 3B |  |  |  |  | Player | Nine | 9
10 | 7 | Player | Ten | 10 | C | C | X | X | P | P |  |  |  |  | Player | Ten | 10
11 | 8 | Player | Eleven | 11 | P | P | C | C | X | X |  |  |  |  | Player | Eleven | 11
Out
 | 9
 | 9
Notes:
 |  |  |  | Players on [NAME]
Spreadsheet: 871854d1718252235-summate-count-by-month-summate-average-by-month-ignoring-if-incomplete-data-excel-help-forum-date-lookup-summation-count-and-average
Sheet: Outcomes for graphing

Date (month) | better | Unchanged | worse | Average start score | average finish score | Count of change score >14 | Count change score 0-14 | count change score <0
February | 2 | 1 | 0 | 0.31 | 0.81 | 3
March | 1 | 2 | 2 | 0.45 | 0.72 | 2 | 1 | 1
April | 2 | 2 | 1 | 0.19 | 0.55 | 4 | 1
Spreadsheet: 826765d1682255452-help-with-lookup-function-table-example
Sheet: Sheet5

 |  | TREE
 |  | 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
ROW | 1 |  |  |  |  | 0.02
 | 2 |  |  |  |  |  |  |  |  |  |  |  | 0.05 |  |  |  |  |  |  |  |  |  |  |  |  | 0.45
 | 3 |  | 0.2 |  |  |  |  |  | 0.08 |  |  |  |  |  |  | 0.06 |  |  |  |  | 0.3
 | 4
 | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.5
 | 6 |  |  |  |  |  |  |  |  |  |  | 0.1 |  |  |  |  |  |  |  |  | 0.4
 | 7 |  |  |  |  | -0.1
 | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -0.15 |  |  |  | 0.2
 | 9 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.3
 | 10
 | 11 |  |  |  |  | 0.06 |  |  |  |  | 0.09 |  |  |  |  |  |  |  |  |  |  |  | 0.02
 | 12 |  | -0.09
 | 13 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.5
 | 14
 | 15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.05 |  |  |  | 0.07
 | 16 |  |  |  |  |  |  | -0.1 |  |  |  |  |  | -0.5 |  |  | 0.08
 | 17 |  | 0.2 |  |  |  |  |  |  |  | -0.4
 | 18
 | 19 |  |  |  |  |  |  |  | -0.15 |  |  | -0.3 |  |  |  |  |  |  |  |  |  | 0.03
 | 20 |  |  |  |  |  |  |  |  |  |  |  |  | -0.35
 | 21 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -0.08
 | 22 |  |  |  | 0.3 |  |  |  |  |  | -0.2 |  |  |  |  |  |  |  |  |  |  |  |  |  | -0.6
 | 23
 | 24 |  |  |  |  |  |  |  |  |  |  |  |  | 0.05 |  |  |  |  |  |  |  |  |  | -0.4
 | 25 | 0.01 |  |  |  |  |  | 0.05 |  |  |  |  |  |  |  |  |  |  |  |  |  | -0.5 |  |  |  | -0.3
Spreadsheet: 297792d1392586638-i-need-a-formula-to-report-back-cells-that-meet-multiple-criteria-part-no-date-due-qty
Sheet: Summary After

 |  | part no | due date | quantity
 |  | part a | wk 31 | 1000
 |  | part f | wk 31 | 400
 |  | part j | wk 31 | 200
 |  | part l | wk 31 | 6000
 |  | part a | wk 33 | 500
 |  | part c | wk 33 | 25000
 |  | part f | wk 33 | 400
 |  | part m | wk 33 | 550
 |  | part h | wk 36 | 12000
 |  | part g | wk 38 | 6620
Spreadsheet: 483637d1475762655-unable-to-produce-league-table-chart-based-on-data-test-data-league
Sheet: Data

Date | Week | Store | Type of Merch | Recovery? | Value of Recovery | Points | Employee Name
2016-10-05 00:00:00 | 36 | 3604 Basildon | Lego | Yes | 120 | 120 | [NAME]
2016-10-06 00:00:00 | 36 | 3602 Sheffield | Lego | Yes | 45 | 45 | [NAME]
2016-10-07 00:00:00 | 36 | 3604 Basildon | Lego | Yes | 80 | 80 | [NAME]
2016-10-08 00:00:00 | 36 | 3606 Bristol | Lego | Yes | 1250 | 1250 | [NAME]
2016-10-09 00:00:00 | 37 | 3605 Cardiff | Lego | Yes | 500 | 500 | [NAME]
2016-10-10 00:00:00 | 37 | 3608 Southampton | Lego | Yes | 90 | 90 | [NAME]
2016-10-11 00:00:00 | 37 | 3603 Bedford | Lego | Yes | 18 | 18 | [NAME]
Spreadsheet: 73889d1274431712-looking-for-a-period-within-a-string-of-dates-split
Sheet: Sheet1

 |  | Start | End
 | Step 1 | 2010-01-01 00:00:00 | 2010-03-19 00:00:00
 | Step 2 | 2010-03-20 00:00:00 | 2010-09-12 00:00:00
 | Step 3 | 2010-09-13 00:00:00 | 2010-12-31 00:00:00
 |  | Step 1 | Step 2 | Step 3
 | Cost | 1000 | 2000 | 3000
 | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | 2010-09-01 00:00:00 | 2010-10-01 00:00:00 | 2010-11-01 00:00:00 | 2010-12-01 00:00:00
Cost
Spreadsheet: 723180d1615553141-formula-to-alter-calculation-dependant-on-drop-down-list-value-peters-version-of-tim-recording-sheet-modbyjt
Sheet: WEEK 1

 | Monday | Minute |  |  |  |  |  |  | Tuesday | Minute
 | Hour From | 0 | 10 | 20 | 30 | 40 | 50 |  | Hour From | 0 | 10 | 20 | 30 | 40 | 50
 | 6 |  |  |  |  |  |  |  | 6 | L15
 | 7 |  |  |  |  |  |  |  | 7
 | 8 | C1 |  |  |  |  |  |  | 8
 | 9 |  |  |  |  |  |  |  | 9
 | 10 | c2 | C25,C25 | C25 | C25 | C10 | c25 |  | 10
 | 11 |  |  |  | C25 |  |  |  | 11
 | 12 |  |  |  |  |  |  |  | 12
 | 13 |  |  |  |  |  |  |  | 13
 | 14 |  |  |  |  |  |  |  | 14
 | 15 |  |  |  |  |  |  |  | 15
 | 16 |  |  |  |  |  |  |  | 16
 | 17 |  |  |  |  |  |  |  | 17
 | 18 |  |  |  |  |  |  |  | 18
 | 19 |  |  |  |  |  |  |  | 19 |  |  |  |  |  | l23
 | Wednesday | Minute |  |  |  |  |  |  | Thursday | Minute
 | Hour From | 0 | 10 | 20 | 30 | 40 | 50 |  | Hour From | 0 | 10 | 20 | 30 | 40 | 50
 | 6 | C10 |  |  |  |  |  |  | 6 | C1
 | 7 |  |  |  |  |  |  |  | 7
 | 8 |  |  |  |  |  |  |  | 8
 | 9 |  |  |  |  |  |  |  | 9
 | 10 |  |  |  |  |  |  |  | 10
 | 11 |  |  |  |  |  |  |  | 11
 | 12 |  |  |  |  |  |  |  | 12
 | 13 |  |  |  |  |  |  |  | 13
 | 14 |  |  |  |  |  |  |  | 14
 | 15 |  |  |  |  |  |  |  | 15
 | 16 |  |  |  |  |  |  |  | 16
 | 17 |  |  |  |  |  |  |  | 17
 | 18 |  |  |  |  |  |  |  | 18
 | 19 |  |  |  |  |  | C11 |  | 19 |  |  |  |  |  | C5
 | Friday | Minute
 | Hour From | 0 | 10 | 20 | 30 | 40 | 50
 | 6 | P1
 | 7
 | 8
 | 9
 | 10
 | 11
 | 12
 | 13
 | 14
 | 15
 | 16
 | 17
 | 18
 | 19 |  |  |  |  |  | P11
Spreadsheet: 28295d1222354724-sumif-with-2-variables-sumproduct5
Sheet: Sheet1

Date | Class | Payment |  |  | CLASS
2008-01-25 00:00:00 | h | 188 |  | Month | a | b | c | d | e | f | g | h | i | j | k | l
2008-01-26 00:00:00 | l | 187 |  | 1 | 469 | 0 | 489 | 399 | 0 | 0 | 468 | 188 | 171 | 0 | 0 | 187
2008-01-27 00:00:00 | c | 489 |  | 2 | 273 | 883 | 290 | 282 | 521 | 593 | 812 | 554 | 116 | 1011 | 357 | 912
2008-01-28 00:00:00 | d | 399 |  | 3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2008-01-29 00:00:00 | g | 468 |  | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2008-01-30 00:00:00 | i | 171 |  | 5 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2008-01-31 00:00:00 | a | 469 |  | 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2008-02-01 00:00:00 | a | 273 |  | 7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2008-02-02 00:00:00 | b | 78 |  | 8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2008-02-03 00:00:00 | k | 246 |  | 9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2008-02-04 00:00:00 | i | 116 |  | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2008-02-05 00:00:00 | l | 186 |  | 11 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2008-02-06 00:00:00 | e | 175 |  | 12 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2008-02-07 00:00:00 | g | 464 |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2008-02-08 00:00:00 | h | 315
2008-02-09 00:00:00 | f | 492
2008-02-10 00:00:00 | l | 116
2008-02-11 00:00:00 | b | 99
2008-02-12 00:00:00 | j | 224
2008-02-13 00:00:00 | j | 372
2008-02-14 00:00:00 | k | 111
2008-02-15 00:00:00 | l | 312
2008-02-16 00:00:00 | c | 231
2008-02-17 00:00:00 | e | 346
2008-02-18 00:00:00 | g | 348
2008-02-19 00:00:00 | h | 161
2008-02-20 00:00:00 | b | 339
2008-02-21 00:00:00 | j | 415
2008-02-22 00:00:00 | h | 78
2008-02-23 00:00:00 | f | 101
2008-02-24 00:00:00 | b | 367
2008-02-25 00:00:00 | l | 298
2008-02-26 00:00:00 | d | 282
2008-02-27 00:00:00 | c | 59