tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 2f139dd5-fac0-4891-9be9-d54b00c93bf1
Sheet: Sheet1

Unnamed: 0 | 1 | Unnamed: 2 | Unnamed: 3 | 2 | Unnamed: 5 | Unnamed: 6 | 3 | Unnamed: 8 | Unnamed: 9 | 4 | Unnamed: 11 | Unnamed: 12 | 5 | Unnamed: 14 | Unnamed: 15 | 6 | Unnamed: 17 | Unnamed: 18
 | [NAME] |  |  | [NAME] |  |  | [NAME] |  |  | [NAME] |  |  | [NAME] |  |  | [NAME]
 | Control | Motor |  | Control | Motor |  | Control | Motor |  | Control | Motor |  | Control | Motor |  | Control | Motor
B=Blue | B | B |  | B | B |  | B | Y |  | B | G |  | B | Y |  | B | G
G=Green | G | G |  | G | Y |  | G | G |  | G | B |  | G | B |  | G | Y
Y=Yellow | Y | Y |  | Y | G |  | Y | B |  | Y | Y |  | Y | G |  | Y | B
 | Phase Wires |  | Comment: | Phase Wires |  | Comment: | Phase Wires |  | Comment: | Phase Wires |  | Comment: | Phase Wires |  | Comment: | Phase Wires |  | Comment:
 | Control | Motor |  | Control | Motor |  | Control | Motor |  | Control | Motor |  | Control | Motor |  | Control | Motor
 | B | B |  | B | B |  | B | B |  | B | B |  | B | B | NO LOAD FORWARD | B | B | NR - BUT
1 | G | G | NR | G | G | NR | G | G | NR | G | G | NR | G | G | HIGH AMP DRAW | G | G | ROTOR SPINS
 | Y | Y |  | Y | Y |  | Y | Y |  | Y | Y |  | Y | Y | NOT CORRECT | Y | Y | BACKWARDS
 | B | B |  | B | B | RUNS GOOD | B | B |  | B | B | RUNS GOOD | B | B |  | B | B
2 | G | Y | NR | G | Y | CORRECT | G | Y | NR | G | Y | CORRECT | G | Y | NR | G | Y | NR
 | Y | G |  | Y | G | CONFIGURATION | Y | G |  | Y | G | CONFIGURATION | Y | G |  | Y | G
 | B | Y |  | B | Y |  | B | Y | RUNS GOOD | B | Y |  | B | Y |  | B | Y
3 | G | G | NR | G | G | NR | G | G | CORRECT | G | G | NR | G | G | NR | G | G | NR
 | Y | B |  | Y | B |  | Y | B | CONFIGURATION | Y | B |  | Y | B |  | Y | B
 | B | G |  | B | G |  | B | G |  | B | G |  | B | G |  | B | G
4 | G | B | NR | G | B | NR | G | B | NR | G | B | NR | G | B | NR | G | B | NR
 | Y | Y |  | Y | Y |  | Y | Y |  | Y | Y |  | Y | Y |  | Y | Y
 | B | Y | NR - BUT | B | Y |  | B | Y |  | B | Y |  | B | Y |  | B | Y
5 | G | B | ROTOR SPINS | G | B | NR | G | B | NR | G | B | NR | G | B | NR | G | B | NR
 | Y | G | BACKWARDS | Y | G |  | Y | G |  | Y | G |  | Y | G |  | Y | G
 | B | G | NO LOAD FORWARD | B | G |  | B | G |  | B | G |  | B | G | NR - BUT | B | G | NO LOAD FORWARD
6 | G | Y | HIGH AMP DRAW | G | Y | NR | G | Y | NR | G | Y | NR | G | Y | ROTOR SPINS | G | Y | HIGH AMP DRAW
 | Y | B | NOT CORRECT | Y | B |  | Y | B |  | Y | B |  | Y | B | BACKWARDS | Y | B | NOT CORRECT
 |  |  | NR = No Rotation
 |  |  | Bafang Motor and [NAME] |  |  |  | Bafang Motor Harness MUST be on RIGHT side of Bicycle
 |  |  | (The same configuration applies to the older controllers as well)
Spreadsheet: 91676d1291329852-horizontal-rolling-average-test-for-excel-forum
Sheet: Sheet1

 | Production (000)
 |  |  | 2010-11-01 00:00:00 | 2010-11-02 00:00:00 | 2010-11-03 00:00:00 | 2010-11-04 00:00:00 | 2010-11-05 00:00:00 | 2010-11-06 00:00:00 | 2010-11-07 00:00:00 | 2010-11-08 00:00:00 | 2010-11-09 00:00:00 | 2010-11-10 00:00:00 | 2010-11-11 00:00:00 | 2010-11-12 00:00:00 | 2010-11-13 00:00:00 | 2010-11-14 00:00:00 | 2010-11-15 00:00:00 | 2010-11-16 00:00:00 | 2010-11-17 00:00:00 | 2010-11-18 00:00:00 | 2010-11-19 00:00:00 | 2010-11-20 00:00:00 | 2010-11-21 00:00:00 | 2010-11-22 00:00:00 | 2010-11-23 00:00:00 | 2010-11-24 00:00:00 | 2010-11-25 00:00:00 | 2010-11-26 00:00:00 | 2010-11-27 00:00:00 | 2010-11-28 00:00:00 | 2010-11-29 00:00:00 | 2010-11-30 00:00:00 | 2010-12-01 00:00:00 | 2010-12-02 00:00:00
 | Grind (BU) | Planned | 70 | 70 | 70 | 70 | 65 | 70 | 90 | 90 | 80 | 0 | 90 | 90 | 90 | 70 | 70 | 70 | 70 | 70 | 65 | 70 | 70 | 70 | 70 | 70 | 35 | 35 | 65 | 65 | 80 | 90
30day Planned Average |  | Actual | 70 | 65 | 70 | 66 | 82 | 99 | 74 | 66 | 50 | 9.8 | 91 | 92 | 103 | 36 | 41 | 101 | 90 | 83 | 96 | 88 | 71 | 71 | 58 | 44 | 24 | 29 | 76 | 92 | 99 | 52
 |  | EDT |  |  |  | 0 |  |  | 0 | 0 | 7 |  |  |  |  | 15 | 15 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 7.5 | 3.25 | 5 |  |  | 2
30day Actual Average |  | ERR |  |  |  | 14 |  |  | 18 | 24 |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 24 |  |  | 4 |  |  |  |  |  | 6.5
 | this should actually be 69.3333
Spreadsheet: 541eb3a1-4532-46b7-beb4-2255c8701b68
Sheet: Sheet1

Permit No.: | Unnamed: 1 | WQ0002560 | Unnamed: 3 | Facility Name: | Unnamed: 5 | [NAME] | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | County: | Nash | Unnamed: 13 | Month: | Unnamed: 15 | Unnamed: 16 | Year: | Unnamed: 18
PPI: |  | 002 | Flow Measuring Point: |  |  |  |  |  |  | Parameter Monitoring Point:
Parameter Code |  |  | 50050 | 00310 | 00916 | 50060 | 31616 | 00927 | 00610 | 00400 | 00931 | 00929 | 00530
Day | ORC Arrival Time | ORC Time On Site | Flow | BOD5 | Calcium | Total Residual Chlorine | Fecal Coliform | Magnesium | Ammonia | pH | Sodium Adsorption Ratio | Sodium | Total Suspended Solids
 | 24-hr | hrs | GPD | mg/L | mg/L | mg/L | #/100 mL | mg/L | mg/L | su | Ratio | mg/L | mg/L
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
26
27
28
29
30
31
Average:
Daily Maximum:
Daily Minimum:
Sampling Type: |  |  | Estimate | Grab | Grab | Grab | Grab | Grab | Grab | Grab | Grab | Grab | Grab
Monthly Limit: |  |  | 43200
Daily Limit:
Sample Frequency: |  |  | Monthly | 3 x Year | 3 x Year | Per Event | Monthly | 3 x Year | 3 x Year | 3 x Year | 3 x Year | 3 x Year | 3 x Year
 |  | Average
 |  | Geomean
 |  | MAX/MIN
Spreadsheet: 143569d1330462501-excel-sum-error-issue
Sheet: Sheet1

 |  | [NAME]. | [NAME] | Poet Due
 |  |  |  | with Calculations | without Calculations
 |  | 0.25 | 62.5 |  | 15.63
 |  | 0.33 | 62.5 |  | 20.63
 |  | 3 | 62.5 |  | 187.5
 |  | 4 | 62.5 |  | 250
 |  | 4 | 62.5 |  | 250
 |  | 1 | 62.5 |  | 62.5
 |  | 0.5 | 62.5 |  | 31.25
 |  | 0.5 | 62.5 |  | 31.25
 |  | 4 | 62.5 |  | 250
 |  | 3.75 | 62.5 |  | 234.38
 |  | 2 | 62.5 |  | 125
 |  | 6 | 62.5 |  | 375
 |  | 1 | 62.5 |  | 62.5
 |  | 0.67 | 62.5 |  | 41.88
 |  | 3.33 | 62.5 |  | 208.13
 |  | 0.58 | 62.5 |  | 36.25
 |  | 3.42 | 62.5 |  | 213.75
 |  |  |  | incorrect sum | correct sum
Spreadsheet: 55623d1255714286-telling-excel-a-cell-equals-another-cell-on-a-worksheet-hprp-assessment-final-sample
Sheet: HPRP A-Employment Info

Homelessness Prevention and Rapid Re-Housing Program
APPLICANT INFORMATION
Intake Date: | 2009-10-25 00:00:00 |  |  | # in Household: | 3
Household Information
Last Name: | Doe | M. Initial: |  | First Name:
Last Name: | 0 | M. Initial: |  | First Name:
Home Phone: | [PHONE] |  | Cell [NAME]): | 0
Work [NAME]): | [PHONE] |  | [NAME]): | 0
HPRP ASSESSMENT
Employment Information
[NAME] |  |  |  | ANSWER
Do you have a high school diploma or GED?
What is your highest education level completed?
Do you have limited English proficiency?
Do you have reliable transportation?
Do you have reliable and affordable child care?
Are you and/or a member of your household currently employed?
If employed, please provide the following information.
Household Member: |  |  | Length of Time at Current Job:
Position: |  |  | Hours Per Week:
Work Address:
Temporary or seasonal? |  |  | Is the job stable?
Household Member: |  |  | Length of Time at Current Job:
Position: |  |  | Hours Per Week:
Work Address:
Temporary or seasonal? |  |  | Is the job stable?
Household Member: |  |  | Length of Time at Current Job:
Position: |  |  | Hours Per Week:
Work Address:
Temporary or seasonal? |  |  | Is the job stable?
Criminal History
[NAME] |  |  | ANSWER
Do you or a household member have a criminal record?
If yes, please explain: (Please include dates)
Type of crime(s)?
Do you have outstanding warrants?
Spreadsheet: 0dedede8-e2d6-42f7-8fea-e1c9e4e0808a
Sheet: Sheet1

Jurisdiction/Grantee Name:  City of Carson City, Nevada | Unnamed: 1 | CDBG-R Fomula Grant Amount: $118,516 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Date: May 21, 2009 | Unnamed: 7
Activity Name | Activity Description | Eligibility (Regulatory or HCDA Citation) | National Objective Citation | CDBG-R Project Budget ($) | Additional Recovery Funds ($) | Other Leveraged Funding ($) | Total Activity Budget
Empire School Area Sidewalk-ADA Project | Construction of new sidewalks and ADA-compliant corner curb ramps where none exist; construction of ADA-compliant corner curb ramps where none exist | 570.201(c) Pub. facilities & impr. | 570.208(a)(1) LMI area benefit | 100739 | 0 | 10000 | 110739
Family Enrichment Program Case Coordinator | Employing a case coordinator for the Program, which is intended to help low-income individuals and families achieve self sufficiency and prevent poverty | 570.201(e) Public services | 570.208(a) LMI persons benefit | 17777 | 0 | 0 | 17777
Spreadsheet: 836468d1689382789-combining-formulas-help
Sheet: Project Commitments

 |  |  |  | Commercial Customers
 |  |  |  | Wholesale Customers
 |  |  |  | Total Commercial Capex
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Year to Date
 |  |  | Project Number | Work Order Number | Project Site Name | Program | January | February | March | April | May | June | July | August | September | October | November | December |  | Approved | Status | Projects Completed | Projects Inflight | Approved  (Open Projects) | Committed  (Open Projects) | Total Committed |  | Invested | Budget | [NAME]
 |  |  | A-012345
 |  |  | A-012346
 |  |  | A-012347
 |  |  | [NAME]
 |  |  | A-012349
 |  |  | A-012350
 |  |  | A-012351
 |  |  | A-012352
 |  |  | A-012353
 |  |  | A-012354
 |  |  | A-012355
 |  |  | A-012356
 |  |  | A-012357
Spreadsheet: 727241d1617796476-need-to-extract-data-from-other-sheet-based-on-name-date-and-time-range-to-avoid-duplicates-varun_task-manager-copy_upload-1-
Sheet: Sheet2

 | Workers Name |  | Activity |  | Location
 | [NAME] |  | SORTING: INCOMING BOXES |  | OFFISTE
 | [NAME] |  | SORTING: TUB ROOM |  | ONSITE
 | [NAME] |  | SORTING: TRANSACTIONS
 | [NAME] |  | PRINT BOX BARCODES
 | [NAME] |  | TOTE & Picklist Labels
 | [NAME] |  | PUT AWAY CONTAINERS: OFFSITE
 | [NAME] |  | PUT AWAY CONTAINERS: ONSITE
 | [NAME] |  | ACTIVITIES: [NAME]-TRANSFERS
 | [NAME] |  | PUT AWAY RECORDS: OFFSITE
 | [NAME] |  | PUT AWAY RECORDS: ONSITE
 | [NAME] |  | DESTRUCTION BOX RETRIEVAL
 | [NAME] |  | DESTRUCTION BOX CHECKS
 | [NAME] |  | DESTRUCTION FILE RETRIEVAL
 | Masfiqur Rahman |  | DESTRUCTION FILE CHECKS
 | [NAME] |  | RETRIEVAL: OFFSITE
 | [NAME] |  | RETRIEVAL: URGENT
 | [NAME] |  | RETRIEVAL: OFFSITE DIGI
 | Radmila Ristivojevic |  | RETRIEVAL: HEALTH SENTENCE
 | [NAME] |  | RETRIEVAL: DIGITALISATION
 | [NAME] |  | RETRIEVAL: SYSCON
 | [NAME] |  | PREPARING PALLETS
 |  |  | PERSONAL ADMINISTRATION
 |  |  | TRANSFERS: FILE
 |  |  | GENERAL HOUSEKEEPING
 |  |  | LEAVE
 |  |  | MEAL BREAK
 |  |  | ACTIVITIES: DIGI
 |  |  | ACTIVITIES: FAST
 |  |  | ACTIVITIES: FILE RETRIEVAL
 |  |  | ACTIVITIES: HEALTH SENTENCE
 |  |  | ACTIVITIES: SYSCON
 |  |  | ARCHIVES SPACE MANAGEMENT
 |  |  | CONSERVATION
 |  |  | DELIVERY: TRANSPORT
 |  |  | DELIVERY: URGENT
 |  |  | OTHER: ASSISTING DEPARTMENTS
 |  |  | PROJECTS: [NAME]
 |  |  | PROJECTS: INFO PROCESS
 |  |  | PROJECTS: SITE COMP
 |  |  | PUT-AWAY: DIGITALISATION
 |  |  | PUT-AWAY: HEALTH SENTENCE
 |  |  | PUT-AWAY: SYSCON
 |  |  | TL: ALLOCATIONS
 |  |  | TL: AUDITING
 |  |  | TL: DATA ENTRY
 |  |  | TL: PERSONAL ADMINISTRATION
 |  |  | ONLINE TRAINING COURSE
 |  |  | CONTAINER MOVEMENTS
Spreadsheet: 204870d1357669741-how-do-i-automatically-highlight-a-cell-cf_try_example-2_rev_1
Sheet: Hourly List

employee number | month | hours
1 | 1 | 80
1 | 2 | 80
1 | 3 | 80
1 | 4 | 75
2 | 3 | 80
2 | 4 | 80
3 | 1 | 80
3 | 2 | 0
3 | 3 | 0
4 | 1 | 80
4 | 2 | 70
4 | 3 | 75
4 | 4 | 80
5 | 1 | 0
Spreadsheet: 69107d1269609380-hiding-specific-fields-on-pivot-table-fields-pt-example
Sheet: Query

Segment | Region | Customer | Country | Model | Period | Unit Sold | Gross Sales | Net Sales | Variable Costs | Marginal Profit | Fixed Costs | SG&A | Operating Profit
A | Europe | C1 | Italy | Civic | ABR 2010 | 25 | 51.92 | 51.92 | -50.48 | 1.44 | -7.27 | -2.6 | -8.43
B | Europe | C2 | Italy | Corolla | AGO 2010 | 30 | 51.92 | 51.92 | -54.15 | -2.23 | -6.5 | -2.69 | -11.42
C | Europe | C4 | US | Accord | ABR 2010 | 18 | 51.92 | 51.92 | -50.49 | 1.43 | -7.27 | -2.6 | -8.44
A | America | [NAME] | Canada | Corolla | AGO 2010 | 9 | 51.92 | 51.92 | -54.15 | -2.23 | -6.5 | -2.69 | -11.42
B | America | C4 | US | Camry | ABR 2010 | 52 | 103.83 | 103.83 | -79.85 | 23.98 | -14.28 | -4.6 | 5.1
A | America | C2 | Canada | Camry | AGO 2010 | 14 | 103.83 | 103.83 | -87.65 | 16.18 | -12.62 | -4.7 | -1.14
B | America | C1 | Italy | Civic | ABR 2010 | 51 | 103.83 | 103.83 | -79.85 | 23.98 | -14.28 | -4.6 | 5.1
B | America | C1 | US | Civic | AGO 2010 | 25 | 103.83 | 103.83 | -87.65 | 16.18 | -12.62 | -4.7 | -1.14
Spreadsheet: 32fa6358-e1e4-4850-9f3d-16f12093c9c8
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17
KENTUCKY TRANSPORTATION CABINET
DEPARTMENT OF HIGHWAYS
DIVISION OF CONSTRUCTION
RECORD OF TEST PILE
Test Pile No
Location of Structure |  |  |  |  |  |  |  |  |  |  |  |  | Page 1 | 0
 |  |  |  | Penetration (Feet) | No. of Blows per foot |  | Average Height of Fall** | Theoretical Bearing ([NAME]) |  | Penetration (Feet) | No. of Blows per foot |  | Average Height of Fall** | Theoretical [NAME]
 | Project Number |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6
 | Project Code Number |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Gravity
 | County |  |  | 35 |  |  |  |  |  |  |  |  |  |  |  |  | Single-Acting Air
 | Road Name |  |  | 34 |  |  |  |  |  | 65 |  |  |  |  |  |  | Single-Acting Diesel
 | Bridge Over |  |  | 33 |  |  |  |  |  | 64 |  |  |  |  |  |  | Double-Acting Air
 | Station |  |  | 32 |  |  |  |  |  | 63 |  |  |  |  |  |  | Double-Acting Diesel
 | Hammer ([NAME], Make) |  |  | 31 |  |  |  |  |  | 62
 | Formula |  |  | 30 |  |  |  |  |  | 61 |  |  |  |  |  |  | 4
 | Actual Stroke Length |  |  | 29 |  |  |  |  |  | 60 |  |  |  |  |  |  | Vertical
 | Weight of [NAME] (lbs.) |  |  | 28 |  |  |  |  |  | 59 |  |  |  |  |  |  | Batter 3 to 1
 | Fall (ft) |  |  | 27 |  |  |  |  |  | 58 |  |  |  |  |  |  | Batter 4 to 1
 | Type of Pile |  |  | 26 |  |  |  |  |  | 57
 | Orientation |  |  | 25 |  |  |  |  |  | 56
 | Gauge Pressure (psi) |  |  | 24 |  |  |  |  |  | 55
 | Energy/Blow (ft./lbs.) |  |  | 23 |  |  |  |  |  | 54
 | Blows Per Minute |  |  | 22 |  |  |  |  |  | 53
 | Plan Bearing (tons) |  |  | 21 |  |  |  |  |  | 52
 | Concrete Mix Used |  |  | 20 |  |  |  |  |  | 51
 | Orig. Length of Pile (ft.) |  |  | 19 |  |  |  |  |  | 50
 | Build Up (ft.) |  |  | 18 |  |  |  |  |  | 49
 | Cut-Off Elevation |  |  | 17 |  |  |  |  |  | 48
 | Cut-Off Length |  |  | 16 |  |  |  |  |  | 47
 | Final Elev. Tip of Pile |  |  | 15 |  |  |  |  |  | 46
 | Pay Length (ft.) | 0 |  | 14 |  |  |  |  |  | 45
 | Plan Qty. Length (ft.) |  |  | 13 |  |  |  |  |  | 44
 | Drawing Number |  |  | 12 |  |  |  |  |  | 43
 | Date Driven |  |  | 11 |  |  |  |  |  | 42
 |  |  |  | 10 |  |  |  |  |  | 41
 |  |  |  | 9 |  |  |  |  |  | 40
 |  |  |  | 8 |  |  |  |  |  | 39
 |  |  |  | 7 |  |  |  |  |  | 38
 |  |  |  | 6 |  |  |  |  |  | 37
Date Submitted |  | Project Engineer |  | 5 |  |  |  |  |  | 36
 |  |  |  |  | TIP
 |  | Total Penetration - Last 10 blows |  | in.@ |  |  | [NAME][NAME]. Bearing |  |  |  |  |  |  | [NAME]
Spreadsheet: 751156d1633941193-filter-dynamic-array-to-keep-rows-which-include-conditional-minimum-values-filter-dynamic-aray-to-keep-rows-which-include-conditional-minimum-values
Sheet: Sheet1

Table to be filtered |  |  |  |  | Filtered table |  |  |  |  | 1. Referencing columns directly
Column A | Column B | Column C | Column D |  | Column A | Column B | Column C | Column D |  | Column A | Column B | Column C | Column D
2018-11-14 00:00:00 | A | B | C |  | 2018-11-14 00:00:00 | A | B | C |  |  | A | B | C
2018-11-15 00:00:00 | A | B | C |  | 2018-11-16 00:00:00 | D | E | F |  | 2018-11-16 00:00:00 | D | E | F
2018-11-16 00:00:00 | D | E | F |  | 2018-11-20 00:00:00 | G | H | I |  | 2018-11-20 00:00:00 | G | H | I
2018-11-17 00:00:00 | D | E | F
2018-11-20 00:00:00 | G | H | I
Array version of table to be filtered |  |  |  |  | Array version of filtered table |  |  |  |  | 2. Referencing columns using INDEX
 | Column B | Column C | Column D |  |  | Column B | Column C | Column D |  | Column A | Column B | Column C | Column D
2018-11-14 00:00:00 | A | B | C |  | 2018-11-14 00:00:00 | A | B | C |  |  | A | B | C
2018-11-15 00:00:00 | A | B | C |  | 2018-11-16 00:00:00 | D | E | F |  | 2018-11-16 00:00:00 | D | E | F
2018-11-16 00:00:00 | D | E | F |  | 2018-11-20 00:00:00 | G | H | I |  | 2018-11-20 00:00:00 | G | H | I
2018-11-17 00:00:00 | D | E | F
2018-11-20 00:00:00 | G | H | I
Array version of table to be filtered |  |  |  |  | Array version of filtered table |  |  |  |  | 3. Referencing columns using CHOOSE and INDEX
 | Column B | Column C | Column D |  |  | Column B | Column C | Column D |  | Column A | Column B | Column C | Column D
2018-11-14 00:00:00 | A | B | C |  | 2018-11-14 00:00:00 | A | B | C
2018-11-15 00:00:00 | A | B | C |  | 2018-11-16 00:00:00 | D | E | F
2018-11-16 00:00:00 | D | E | F |  | 2018-11-20 00:00:00 | G | H | I
2018-11-17 00:00:00 | D | E | F
2018-11-20 00:00:00 | G | H | I
Spreadsheet: 729562d1619169695-fill-out-blank-with-the-assign-value-and-count-starts-with-6-book1
Sheet: Sheet1

No. | EXPECTED RESULT |  |  |  |  |  | NO. |  | [NAME] | [NAME]
1 | 10-11-1 | 10-11-1 | 1 |  |  |  | 1 | 10-11-1
2 |  | 10-11-1 | 2 |  |  |  | 2
3 |  | 10-11-1 | 3 |  |  |  | 3
4 |  | 10-11-1 | 4 |  |  |  | 4
5 |  | 10-11-1 | 5 |  |  |  | 5
6 | 10-11-2 | 10-11-2 | 1 |  |  |  | 6 | 10-11-2
7 | 10-11-3 | 10-11-3 | 1 |  |  |  | 7 | 10-11-3
8 |  | 10-11-3 | 2 |  |  |  | 8
9 |  | 10-11-3 | 3 |  |  |  | 9
10 |  | 10-11-3 | 4 |  |  |  | 10
11 |  | 10-11-3 | 5 |  |  |  | 11
12 |  | 10-11-3 | 6 |  |  |  | 12
13 |  | 10-11-3 | 7 |  |  |  | 13
14 | 10-11-4 | 10-11-4 | 1 |  |  |  | 14 | 10-11-4
15 | 10-11-5 | 10-11-5 | 1 |  |  |  | 15 | 10-11-5
16 | 10-11-6 | 10-11-6 | 1 |  |  |  | 16 | 10-11-6
17 |  | 10-11-6 | 2 |  |  |  | 17
18 |  | 10-11-6 | 3 |  |  |  | 18
19 |  | 10-11-6 | 4 |  |  |  | 19
20 |  | 10-11-6 | 5 |  |  |  | 20
Spreadsheet: 266600d1379675293-how-to-automatically-time-update-in-a-column-not-working
Sheet: Sheet1

9884444854
Spreadsheet: 271688d1382021994-need-formula-to-find-the-match-then-copy-and-paster-number-needformula1
Sheet: Sheet2

ColumnA | ColumnA | ColumnA | ColumnA | ColumnA | ColumnA | Part | ColumnA | ColumnA | Com | Ds | ColumnA | Qty1 | Qty2 | Qty3 | Qty4 | Qty5 | Num1 | Num2 | Num3 | Num4 | Num5
1 |  |  |  |  |  | Hon1 | a |  | com Hon1 | 1 |  | 1 |  |  |  |  | 293
2 |  |  |  |  |  | Hon1 | a |  | com Hon1 | 2 |  | 5 |  |  |  |  | 283
3 |  |  |  |  |  | Hon1 | a |  | com Hon1 | 3 |  | 10 |  |  |  |  | 272
4 |  |  |  |  |  | Hon2 | b |  | com Hon2 | 4 |  | 1 |  |  |  |  | 75.69
5 |  |  |  |  |  | Hon3 | c |  | com Hon3 | 5 |  | 1 |  |  |  |  | 125
6 |  |  |  |  |  | Hon3 | c |  | com Hon3 | 6 |  | 5 |  |  |  |  | 119
7 |  |  |  |  |  | Hon3 | c |  | com Hon3 | 7 |  | 10 |  |  |  |  | 115
8 |  |  |  |  |  | Hon4 | d |  | com Hon4 | 8 |  | 1 |  |  |  |  | 308
9 |  |  |  |  |  | Hon4 | d |  | com Hon4 | 9 |  | 3 |  |  |  |  | 303
10 |  |  |  |  |  | Hon4 | d |  | com Hon4 | 10 |  | 5 |  |  |  |  | 299
11 |  |  |  |  |  | Hon4 | d |  | com Hon4 | 11 |  | 10 |  |  |  |  | 291
12 |  |  |  |  |  | Hon5 | f |  | com Hon5 | 12 |  | 1 |  |  |  |  | 52.38
13 |  |  |  |  |  | Hon5 | f |  | com Hon5 | 13 |  | 5 |  |  |  |  | 48.54
14 |  |  |  |  |  | Hon5 | f |  | com Hon5 | 14 |  | 10 |  |  |  |  | 46.39
15 |  |  |  |  |  | Hon6 | g |  | com Hon6 | 15 |  | 1 |  |  |  |  | 59.06
16 |  |  |  |  |  | Hon6 | g |  | com Hon6 | 16 |  | 2 |  |  |  |  | 56.25
17 |  |  |  |  |  | Hon6 | g |  | com Hon6 | 17 |  | 5 |  |  |  |  | 43.71
18 |  |  |  |  |  | Hon6 | g |  | com Hon6 | 18 |  | 10 |  |  |  |  | 43.31
19 |  |  |  |  |  | Hon6 | g |  | com Hon6 | 19 |  | 25 |  |  |  |  | 43
20 |  |  |  |  |  | Hon7 | h |  | com Hon7 | 19 |  | 1 |  |  |  |  | 1
21 |  |  |  |  |  | Hon7 |  |  | com Hon7 | 19 |  | 1 |  |  |  |  | 100
Spreadsheet: 158073d1337969223-using-index-match-to-search-multiple-columns-quoteproductioncapacity2
Sheet: Capacity Chart

MACHINE CENTER | AVAILABLE HOURS | BOOKED HOURS | % OF AVAILABLE BOOK
SAW | 5
LATHE | 20
MILL | 20
EDM | 20
Spreadsheet: 888653d1739222042-change-format-of-data-diabetes-27-apr-2017-to-23-april-2018
Sheet: Table 16

00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
Fri 25 Aug Glucose mmol/L
 |  |  |  |  | 6.4 |  | 6.6 | 7.4 | 6.4
Sat 26 Aug Glucose mmol/L
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
 |  |  |  |  | 5.7 | 6.7
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
Sun 27 Aug Glucose mmol/L
Mon 28 Aug Glucose mmol/L
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
Tue 29 Aug Glucose mmol/L
Wed 30 Aug Glucose mmol/L
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
Thu 31 Aug Glucose mmol/L
 |  |  |  |  | 6.8
Legend          High Glucose (>13.3)            Low Glucose (<3.9)
Fri 1 Sep Glucose mmol/L
Spreadsheet: 686089d1594356688-more-efficient-counta-sumif-and-sum-formulas-needed-for-training-spreadsheet-training
Sheet: Training 3

 | Training 3
 |  |  | 7:30am | 8:00am | 8:00am | 8:00am | 8:30am | 8:30am | 8:30am | 9:00am | 9:30am | 9:30am | 10:00am | 10:00am | 10:00am | 10:00am | 10:30am | 11:00am | 11:00am | 11:00am | 11:00am | 11:00am | 1:00pm | 1:00pm | 1:00pm | 1:30pm | 1:30pm | 1:30pm | 3:00pm
 | # of Sessions |  | 1
 | # of Expected on Training Day |  | 1 | 2 | 2 | 3 | 3 | 2 | 3 | 3 | 2 | 3 | 3 | 3 | 3 | 2 | 2 | 3 | 3 | 3 | 2 | 3 | 2 | 2 | 3 | 2 | 2 | 2 | 3
 | # [NAME] |  | 1 | 2 | 1 | 3 | 3 | 2 | 2 | 2 | 0 | 2 | 3 | 3 | 3 | 2 | 2 | 3 | 3 | 3 | 1 | 3 | 2 | 2 | 3 | 2 | 2 | 2 | 3
 | New Hire Show Rate
 | [NAME] | The same for training 1-6
 | C6: | Count Row 6 from column D and over, Only the cells with data entered in them
 | C7: | Sum of row 7 tfrom Column D and over "IF" Row 8 has data enetered
 | C8: | Sum of Row 8 from Column D and over
 | Column D and Over: | Manually entered.
Spreadsheet: 123084d1317323954-conditional-formatting-in-relation-to-a-target-copy-of-revised-markbook-year-10
Sheet: Year 10 data

Surname | Forename | Form | Sex | Intervention | G&T? | Target | End of Year 9 Grade | Religion & Animals Mark | Religion and animals % | Religion and animals grade | Religion & Prejudice Mark | Religion & Prejudice % | Religion and prejudice grade | War & Peace Mark | War and Peace % | War and Peace grade | Does God Exist Mark | Does God exist % | Does God exist grade | Revelation Mark | Revelation % | Revelation grade | Religion and animals grade | Religion and prejudice grade | War and Peace grade | Does God exist grade | Revelation Grade
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Conditional Formatting
Zawadzki | [NAME] | 10.1 | M |  |  | C |  | 12 | 0.6666666666666666 | C | 9 | 0.5 | D |  |  |  | 10 | 0.5555555555555556 | D | 10 | 0.5555555555555556 | D | on target | off target |  | off target | off target |  | Red
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Green
 |  |  |  |  |  | A |  |  |  |  |  |  |  | 16 | 0.8888888888888888 | A |  |  |  |  |  |  |  |  | on target
 |  |  |  |  |  | D