tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 758636d1638977893-calculating-total-workload-across-numerous-contracts-sample-td
Sheet: Sheet1

Client | Owner | Funded Allocation (Hours per Week) | Actual Allocation (Hours per Week) | Funded Allocation FTE | Actual Allocation FTE |  | Owner | Funded Allocation (Hours per Week) | Actual Allocation (Hours per Week) | Funded Allocation FTE | Actual Allocation FTE
A | [NAME] | 0 | 0.8 | 0 | 0.02 |  | [NAME]
B | [NAME] | 4 | 8 | 0.1 | 0.2 |  | [NAME]
C | [NAME] | 1.6 | 4 | 0.04 | 0.1 |  | Feargal Sharkey
D | Feargal Sharkey | 10 | 10.4 | 0.25 | 0.26 |  | [NAME]
E | [NAME] | 0 | 6 | 0 | 0.15 |  | [NAME] Lauper/ [NAME]
F | [NAME] | 0 | 2.8 | 0 | 0.07 |  | [NAME]
G | [NAME] | 40 | 50.4 | 1 | 1.26 |  | [NAME]
H | [NAME] | 0 | 0.4 | 0 | 0.01 |  | [NAME]
I | [NAME] | 0 | 0.8 | 0 | 0.02 |  | [NAME]
J | [NAME] Lauper/ [NAME] | 64 | 78.8 | 1.6 | 1.97 |  | [NAME]
K | [NAME] | 2.4 | 1.2 | 0.06 | 0.03
L | [NAME] | 2.4 | 0.8 | 0.06 | 0.02
M | [NAME] | 0 | 2.8 | 0 | 0.07
N | [NAME] | 0 | 2.4 | 0 | 0.06
O | [NAME] | 1.2 | 3.6 | 0.03 | 0.09
P | [NAME] | 20 | 46.4 | 0.5 | 1.16
Q | [NAME] | 12 | 11.6 | 0.3 | 0.29
R | [NAME] | 0 | 26.4 | 0 | 0.66
S | [NAME] | 8 | 26.4 | 0.2 | 0.66
T | [NAME] | 0 | 0.4 | 0 | 0.01
U | [NAME] | 0 | 6.800000000000001 | 0 | 0.17
V | [NAME] | 20 | 32 | 0.5 | 0.8
W | [NAME] | 2.4 | 1.6 | 0.06 | 0.04
X | [NAME] | 8 | 11.6 | 0.2 | 0.29
Y | [NAME] | 16 | 15.2 | 0.4 | 0.38
Z | [NAME] | 0 | 1.2 | 0 | 0.03
A1 | [NAME] | 0 | 0 | 0 | 0
B1 | [NAME] | 0 | 2.8 | 0 | 0.07
C1 | [NAME] | 0 | 11.6 | 0 | 0.29
D1 | Feargal Sharkey | 20 | 31.6 | 0.5 | 0.79
E1 | Feargal Sharkey | 40 | 28.8 | 1 | 0.72
F1 | [NAME] | 4 | 11.6 | 0.1 | 0.29
[NAME] | [NAME] | 0 | 5.2 | 0 | 0.13
H1 | [NAME] | 0 | 0.4 | 0 | 0.01
Total |  | 276 | 444.8000000000001 | 6.899999999999999 | 11.12
Spreadsheet: 145465d1331598012-make-line-chart-not-show-contain-formula-keepformularnotshowzerovalueonlinechart
Sheet: Sheet1

 | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008
Value 1 | 1 | 5 | 9 | 13
Value 2 | 4 | 8 | 12 | 16
 |  |  |  |  |  |  |  | Has formular so it will be a blank if there is nothing to update
 | 2004 | 2005 | 2006 | 2007 | 2008
Value 1
Value 2
 |  |  |  |  |  |  |  |  |  |  |  | CHART 2
 | As we can see, the range F2:J3 contain formular and in chart it will show 0 value but I want it to be like in CHART 2
 | How can I make the chart like in CHART 2 while still keep formular
Spreadsheet: 57406278-b339-4892-adf9-280db77ef2b9
Sheet: Sheet1

Unnamed: 0 | REIMBURSEMENT REQUEST FORM | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
Division of Water Infrastructure |  |  | Project No.________________
Period Covered by this Report - From ________ To ________
Recipient Organization
Name: |  |  | Payment No.______________
Address: |  |  | Page No._______ of _______
City, State & Zip:
Please Label Each Column Use separate column for each contract. | Example Column Labels
Use additional sheets if needed. Use a "[NAME]." column if needed. | Engineer | Contract #1, ABC Const. Co. | Contract #2, XYZ Utility Inc.
Classification of | A | B | C | Total
Planning & Design Fees
Engr's Fees Admin
Inspection Fees
Construction Cost
Equipment
[NAME].
Deductions (income)
Total Cumulative to date
Previous Received
Amount Requested
Percent Complete
Certification
I certify that to the best of my knowledge and belief the billed costs or disbursements are in accordance with
terms of the project and that this request represents the monies due which have not been previously received and
that an inspection has been performed and all work is in accordance with the terms of the award.
You must check ONE of the boxes below or your payment will not be processed:
The funds requested above have already been paid to the respective vendors, consultants & contractors
by the award recipient.
OR
The funds requested above have not been paid to the respective vendors, consultants & contractors.
Funds received from the State will be disbursed to these entities within three (3) banking days.
Recipient |  | Signature of Authorized Representative |  | Date
 | Type or Print Name and Title
DWI comments
Spreadsheet: 810456d1671782612-cant-make-a-total-from-a-match-formula-repack-supplies-form-2
Sheet: Used Box

 |  |  |  |  | A1 | A3 | C1 | C2 | [NAME] | a1 | E0 | E1 | E3 | E4 | E6 | E7 | E36 | G10 | G20 | G30 | G40 | K20 | K30 | K40 | K50 | K60 | K80 | MP10 | V07 | V40 | V70
 | [NAME] scanned
 | A3
 |  |  |  | Total
Spreadsheet: 49d387b2-6d2c-4c12-9bb4-cc2c5b657990
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
FEC | Test | FEC | Iron and Total Iron-Binding Capacity, Serum | Iron and Total Fe Binding Cap, S | Immunoturbidimetric Assay | Serum Gel Tube: SGT |  |  | 1 | mL | Container/Tube:  Preferred: Serum gel Acceptable: Red top [NAME]: 1 mL Collection Instructions:  1. Fasting (12 hours) 2. Draw blood before 12 noon (preferred). Additional Information: 1. Patient's age and sex are required. 2. Iron-containing supplements should be avoided for 24 hours prior to draw. | 0.50 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	Mild OK; [NAME] OK Other	NA | IRON Males: 50-150 mcg/dL Females: 35-145 mcg/dL   TOTAL BINDING CAPACITY 250-400 mcg/dL   PERCENT SATURATION 14-50% | Monday through Saturday; Continuously | Same day/1 day | 2 days |  | Profile |  |  |  |  | Rochester
FEC | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 7 days
FEC | Result | IRON | Iron | Iron | Numeric |  |  |  |  | mcg/dL |  |  |  |  |  |  |  |  |  | 2498-4
FEC | Result | TIBC | Total Iron Binding Capacity | Total Iron Binding Capacity | Numeric |  |  |  |  | mcg/dL |  |  |  |  |  |  |  |  |  | 2500-7
FEC | Result | SAT | Percent Saturation | Percent Saturation | Numeric |  |  |  |  | % |  |  |  |  |  |  |  |  |  | 14801-5
FEC | Billing Component | FEC |  | IRON BINDING TEST |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 83550
FEC | Billing Component | FEC |  | ASSAY OF IRON |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 83540
Spreadsheet: 748001d1631820055-monthly-repayments-with-no-interest-book1
Sheet: Sheet1

 | M1 | M2 | M3 | M4 | M5 | M6 | M7 | M8 | M9 | M10 | M11 | M12
BNPL1 | 508968.75 | 524660.625 | 540941.9624999999 | 557838.333 | 575376.5074725 | 593584.5158250749 | 612491.708254858 | 632128.8196389001 | 652528.0371115712 | 673723.0709876894 | 695749.229198025 | 718643.4954120961
BNPL2 | 712556.25 | 734524.875 | 757318.7474999998 | 780973.6662 | 805527.1104614999 | 831018.3221551047 | 857488.3915568012 | 884980.3474944601 | 913539.2519561996 | 943212.2993827651 | 974048.9208772349 | 1006100.893576935
BNPL3 | 814350 | 839457 | 865507.1399999999 | 892541.3328 | 920602.411956 | 949735.2253201199 | 979986.733207773 | 1011406.11142224 | 1044044.859378514 | 1077956.913580303 | 1113198.76671684 | 1149829.592659354
Repayments 1
Repayments 2
Repayments 3
Spreadsheet: 600317d1543599320-how-can-i-see-the-formula-used-in-this-example-audit-scorecard-master
Sheet: Reasons Data

Reasons For No Categories |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
Referral
Does not meet eligibility criteria
Relevant forms not on file
Forms incomplete/not sufficient detail
No signatures/dates
Entry/Induction
Forms not on file
Forms incomplete/not sufficient detail
No signatures/dates
Complaints procedures not explained
Needs Assessment
Does not meet eligibility criteria
Relevant forms not on file
Forms incomplete/not sufficient detail
No signatures/dates
Risk Assessment
Does not meet eligibility criteria
Relevant forms not on file
Forms incomplete/not sufficient detail
No signatures/dates
Does not identify risks to self and others
No evidence that risks are managed
Not reviewed regulary/updated
Care Plan & Reviews
Forms incomplete/not sufficient detail
No signatures/dates
Objectives not SMART
Does not address needs identification assessment
Reviews not in date
Does not respond to changing need
Does not include other agencies
Does not include an exit plan
Case Notes
Not completed/not sufficient detail
No signatures/dates
Not up to date
Not linked to care/support plan
Notes do not reflect support given by worker and progress made
No reference to interagency working
Correspondence
Not on file or in line with project procedures
Does not support service delivered
Exits
Levels of outreach not sufficient
Inappropriate discharge reason selected
Exit questionnaire not completed
Relevant forms not on file
Forms incomplete/not sufficient detail
Exit TOPS not completed/not in date
Evidence for Contract Targets
Relevant forms not on file
Forms incomplete/not sufficient detail
No signatures/dates
Required evidence not present e.g. evidence of outcomes, onward referrals, consent
Protection/Safeguarding/Complaints
Relevant forms not on file
Forms incomplete/not sufficient detail
No signatures/dates
Project Specific Records
Relevant forms not on file
Forms incomplete/not sufficient detail
No signatures/dates
Total
Spreadsheet: 67878d1268396366-excel2003-alternative-to-if-function-when-dealing-with-more-than-7-ifs-base-rota2
Sheet: Sheet1

 | KATH
 | SYLVIA |  | Floor
 | [NAME] |  | Bar
 | ADELE |  | Both
 | AMY
 | CAMILLA
 | DREW
 | FLO
 | GEMMA 1
 | GEMMA 2
 | HAYLEY
 | [NAME]
 | JULIE
 | KATHERINE
 | KATIE
 | KERRI L
 | KERRY
 | KIMBERLEY
 | MANDY
 | MGOSIA 2
 | [NAME]
 | MIGOSIA 1
 | NICOLA
 | PAULINE
 | SIMON
 | SORELLE
 | TASHA
 | TOM
 | VICKI
Spreadsheet: jonathan_mckay__17203__Tariffs New Update
Sheet: Summary

TARIFF SUMMARY | 2001-07-01 00:00:00
 |  |  |  |  |  |  |  |  | Mids Date:
FX
Aeco to Border | 0 | $C/GJ
Aeco to Border |  | $US/MMBTU
Gas Prices | $C/GJ | $US/MMBTU
AECO
Empress/Border
Station 2
Stanfield
Sumas
Emerson
TARIFF SUMMARY | 2001-07-01 00:00:00 |  |  | USD/MM |  |  |  | CAN | /GJ
Transportation Point | % Fuel | Fuel | Firm Var | IT Var | FirmTotal | IT Total |  | FirmTotal | IT Total
ABC to [NAME]
ABC to Stanfield*
ABC to Stanfield (NWPL)*
ABC to Malin*
Empress to Saskatchewan
Empress to GLGT
Empress to Dawn
Empress to [NAME]
Empress to Iroquois
Empress to Chippawa
Empress to Phillipsburg
Empress to St Clair
Empress to Ventura
Empress to Chicago
Empress to Parkway
Empress to St. Clair (GLGT) w/o GLGT
Emerson to St. Clair (GLGT) w/o GLGT
Emerson to Fortune Lake (GLGT) w/o GLGT
Emerson to Carlton (GLGT) w/o GLGT
Alberta to Chicago via Alliance
BC to Chicago via Alliance
Stanfield to Malin*
Station 2 to AECO
Station 2 to Huntingdon
Station 2 to NWPL*
Huntingdon to NWPL*
AECO to Station 2 **
All numbers in $US/MMBtu
*Includes GRI
**AECO to Station 2 IT priced off of Empress
Station 2 to NWPL IT has T-South firm and NWPL IT
TCPL IT costs assume floor bid of 80% of firm
Spreadsheet: 754876d1636551546-sort-without-zeros-sort-and-zeros
Sheet: sort

a | 1 |  |  | 6 |  |  | a | 1 |  |  | 1 |  |  | 1
b | 2 |  | 0 | 7 |  |  | b | 2 |  | b | 2 |  | b | 2
0 | 6 |  | 0 | 8 |  |  | c | 3 |  | c | 3 |  | c | 3
c | 3 | --> | 0 | 9 |  | i want | d | 4 |  | d | 4 |  | d | 4
d | 4 |  | a | 1 |  |  | e | 5 |  | e | 5 |  | e | 5
0 | 7 |  | b | 2
0 | 8 |  | c | 3
0 | 9 |  | d | 4
e | 5 |  | e | 5
 |  |  | 0 | 0
 |  |  | 0 | 0
 |  |  | formula
 |  |  | SORT(A1:B11;1;1)
Spreadsheet: 10c7e8dc-95f6-4ec1-b486-d9564e29b119
Sheet: Total

Contextual Factor | Score
External Motivators
External Project Sponsorship
Organizational QI Leadership
Organization Senior Leader [NAME]
Organization QI Culture
Organization QI Maturity
QI Workforce Focus
Resource Availability
Data Infrastructure
QI Team Leadership
QI Team Diversity
QI Team Subject Matter Expert
QI Team Decision-Making Processes
QI Team Norms
QI Team QI Skill
QI Team Physician Involvement
QI Team Prior QI Experience
QI Team Tenure
Microsystem QI Leadership
Microsystem Motivation
Microsystem QI Capability
Microsystem QI Culture
Task Strategic Importance to the Organization
Triggering Event
Spreadsheet: 98209d1297228518-converting-3-sec-data-into-9-sec-data-and-60-sec-data-andy-pope
Sheet: Sheet1

Time | Torque-3 |  | Torque-9 | Time' |  | Torque-60 | Time''
9:30:03 AM | 0 |  |  | 09:30:00 |  |  | 09:30:00
9:30:06 AM | 0
9:30:09 AM | 0
9:30:12 AM | 0
9:30:15 AM | -0.813008130081301
9:30:18 AM | 0.6802721088435373
9:30:21 AM | -2.857142857142857
9:30:24 AM | 2.272727272727272
9:30:27 AM | -3.846153846153846
9:30:30 AM | 0.6289308176100628
9:30:33 AM | 0
9:30:36 AM | 1.694915254237288
9:30:39 AM | 0
9:30:42 AM | 0
9:30:45 AM | 0
9:30:48 AM | -0.3472222222222224
9:30:51 AM | -0.6578947368421052
9:30:54 AM | 0
9:30:57 AM | 7.692307692307693
9:31:00 AM | 0
9:31:03 AM | -7.692307692307693
9:31:06 AM | 3.846153846153846
9:31:09 AM | -2.631578947368421
9:31:12 AM | 8.333333333333332
9:31:15 AM | 0
9:31:18 AM | 1.219512195121951
9:31:21 AM | -0.5434782608695652
Spreadsheet: 10c21b9e-d392-4f83-9c4f-b12cecfa313c
Sheet: Sheet1

Table S5
 | In situ |  | 6 wk deacclimation |  | F1
Enzyme | HA | LA | HA | LA | HA | LA
CS | 55.0  ±  7.0 | 49.5 ± 6.4 | 34.0 ± 3.9 | 31.7 ± 3.8 | 52.4 ± 6.7 | 55.1 ± 6.9
COx | 36.3 ± 5.7 | 30.8 ± 5.7 | 14.7 ± 2.0 | 12.0 ± 2.9 | 32.6 ± 6.1 | 27.1 ± 5.1
IDH | 7.0 ± 0.7 | 7.9 ± 1.6 | 5.7 ± 0.6 | 4.7 ± 0.5 | 8.2 ± 0.9 | 7.8 ± 1.1
HOAD | 41 ± 5.1 | 31.0 ± 0.5 | 27.7 ± 2.7 | 22.5 ± 2.4 | 32.2 ± 3.4 | 35.8 ± 4.8
HK | 4.0 ± 0.4 | 3.7 ± 0.5 | 3.1 ± 0.4 | 2.6 ± 0.3 | 3.8 ± 0.5 | 4.2 ± 0.6
PFK | 31.8 ± 4.5 | 35.2 ± 3.8 | 21.2 ± 1.9 | 23.4 ± 2.9 | 28.3 ± 2.5 | 38.6 ± 3.0
PK | 202 ± 23 | 219 ± 29 | 150 ± 7 | 153 ± 16 | 168 ± 21 | 252 ± 29
LDH | 532 ± 64 | 731 ± 92 | 227 ± 12 | 278 ± 33 | 495 ± 54 | 749 ± 96
Spreadsheet: 811ebc4b-243c-4714-8d1c-f539abec9e52
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Warner Records | 825646933068 | Enya | And [NAME]... | 2008-11-11 | Compact Disc | Christmas | 18.99 | Y | Available
Spreadsheet: 116920d1312305760-selective-columns-farthingstone
Sheet: sa

Scott. [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HANDICAPPING
hole | par | stroke index | adjusted par | pts calc | [NAME] | strokes | points | PAR 3 | INDEX 1 | INDEX 2 | INDEX 3 | adjusted par | pts calc | [NAME] | points | handicap | handicap | handicap | catergory | Buffer Zone | css | Nett Differential | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nett | Nett
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | points | points
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 18 | 36
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | par 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out
total
Spreadsheet: 863892d1711296740-vlookup-keeps-looking-through-0-blank-values-book1
Sheet: Sheet1

Category 1 | [NAME] | [NAME] | [NAME] | [NAME] | Categoey 6 |  |  |  | Check | VLOOKUP
1 |  |  | yes |  |  |  |  |  | 1
2 |  |  | no |  |  |  |  |  | 2 |  |  |  | no
3 |  |  |  |  |  |  |  |  | 3 |  |  |  | no
3 |  |  |  |  |  |  |  |  | 4
3 |  |  | no |  |  |  |  |  | 5 |  |  |  | yes
4 |  |  |  |  |  |  |  |  | 6 |  |  |  | yes
5 |  |  | yes |  |  |  |  |  | 7 |  |  |  | no
6 |  |  |  |  |  |  |  |  | 8 |  |  |  | yes
6 |  |  | yes |  |  |  |  |  | 9 |  |  |  | yes
6 |  |  |  |  |  |  |  |  | 10 |  |  |  | yes
7
7
7 |  |  | no
8 |  |  | yes
9 |  |  | yes
10 |  |  | yes
Spreadsheet: 0c3ecdad-2435-4a0a-a299-a233787517a6
Sheet: Sheet1

First | Last | TICKET SALE ACTIVITY |  |  |  |  |  |  |  |  | # OF RETURNED CARDS |  | # Of Outstanding Cards | Outstanding Money Due | Total #   Cards Sold | Total $ Amount Sold | COMMISSION EARNED BY SCOUT
 |  | # OF CARDS TAKEN |  |  |  | MONEY TURNED IN
Spreadsheet: 769725d1645654031-connected-workbook-shifting-data-in-rows-receive
Sheet: Sheet1

a | b | d | e | f | Column1
A | 11 | 11 | 11 | 11 | data
B | 12 | 12 | 12 | 12
C | 13 | 13 | 13 | 13
D | 14 | 14 | 14 | 14 | data
E | 15 | 15 | 15 | 15
F | 16 | 16 | 16 | 16
G | 17 | 17 | 17 | 17
new | 18 | 18 | 18 | 18
new2 | 19 | 19 | 19 | 19 | data
Spreadsheet: 65996d1266611415-formula-averages-by-name-and-differences-of-averages-example
Sheet: Sheet1

Name | Test A | Test B | Average Test A | Average Test B | Difference of averages A and B
[NAME] | 3.4 | 3.6 | Stay blank
[NAME] | 3.5 | 3.8 | Stay blank
[NAME] | 3.4 | 3.7 | Value | Value | Value
Cathy | 6.8 | 7.3 | Stay blank
Cathy | 4.7 | 5.5 | Stay blank
Cathy | 3.5 | 3.9 | Stay blank
Cathy | 4.1 | 4.2 | Stay blank
Cathy | 6 | 7 | Value | Value | Value
[NAME] | 5 | 6
[NAME] | 4 | 5
[NAME] | 3 | 4
[NAME] | 3 | 3
[NAME] | 4 | 5
Spreadsheet: 36229d1234044006-adding-and-subtracting-numbers-within-the-same-cell-newman100
Sheet: Sheet1

 | Team 1 | Team 2 | Team 3 | Team 4 | Team 5 | Team 6 | Team 7 | Team 8 | Team 9 | Team 10 |  |  | Points | Team 1 | Team 2 | Team 3 | Team 4 | Team 5 | Team 6 | Team 7 | Team 8 | Team 9 | Team 10
Team 1 |  | 1,2 | 3,2 | 1,4 | 1,5 | 1,6 | 1,7 | 1,8 | 1,9 | 1,10 |  | Team 1 | 9 |  | A | H | A | A | A | A | A | A | A
Team 2 | 2,1 |  | 2,3 | 2,4 | 2,5 | 2,6 | 2,7 | 2,8 | 2,9 | 2,10 |  | Team 2 | 11 | H |  | A | A | A | A | A | A | A | A
Team 3 | 3,2 | 3,3 |  | 3,5 | 3,6 | 3,7 | 3,8 | 3,9 | 3,10 | 3,11 |  | Team 3 | 13 | H | D |  | A | A | A | A | A | A | A
Team 4 | 3,5 | 3,6 | 3,7 |  | 3,9 | 5,10 | 3,11 | 3,12 | 3,13 | 3,14 |  | Team 4 | 12 | A | A | A |  | A | A | A | A | A | A
Team 5 | 5,1 | 5,2 | 5,3 | 5,4 |  | 5,6 | 5,7 | 5,8 | 5,9 | 5,10 |  | Team 5 | 29 | H | H | H | H |  | A | A | A | A | A
Team 6 | 6,2 | 6,3 | 6,4 | 6,5 | 6,6 |  | 6,8 | 6,9 | 6,10 | 6,11 |  | Team 6 | 34 | H | H | H | H | D |  | A | A | A | A
Team 7 | 4,3 | 4,4 | 4,5 | 4,6 | 4,7 | 4,8 |  | 4,10 | 4,11 | 4,12 |  | Team 7 | 27 | H | D | A | A | A | A |  | A | A | A
Team 8 | 7,1 | 7,2 | 7,3 | 7,4 | 7,5 | 7,6 | 7,7 |  | 7,9 | 7,10 |  | Team 8 | 46 | H | H | H | H | H | H | D |  | A | A
Team 9 | 5,1 | 5,2 | 5,3 | 5,4 | 5,5 | 5,6 | 5,7 | 5,8 |  | 5,10 |  | Team 9 | 40 | H | H | H | H | D | A | A | A |  | A
Team 10 | 2,8 | 8,3 | 8,4 | 8,5 | 8,6 | 8,7 | 8,8 | 8,9 | 8,10 |  |  | Team 10 | 43 | A | H | H | H | H | H | D | A | A
 | Goals for | Goals Against
Team 1 | 35 | 90
Team 2 | 45 | 95
Team 3 | 61 | 104
Team 4 | 70 | 128
Team 5 | 99 | 89
Team 6 | 116 | 98
Team 7 | 106 | 106
Team 8 | 144 | 84
Team 9 | 135 | 85
Team 10 | 164 | 96
Spreadsheet: 471361d1468969718-excel-calculation-problem-of-the-pi-value-nnsw-roadbase-blends-2014-15-16-1-
Sheet: BOA DGS40 CHCC AUS

DGS40 AUS SPEC CHCC
 | % Passing Sieve |  |  |  |  |  |  | % Passing | CHCC SPEC |  | RMS Specification |  | Deviation | % Retained | [NAME] |  | Deviation | Result | Spec
Sieve mm | Mansand | 0103-2  original 10-3 | 0604-1 with Ballast | 0103-2 15% Ballast | 50mm -Ballast | 0504-1 10% Ballast | Beach Sand | Blend Result | Passing Lower | Passing Upper | Passing Lower | Passing Upper | Passing | Blend Result | Lower | Upper | Retained | ABC
26.5 | 100 | 95 | 92 | 85 | 26 | 90 | 100 | 86.5 | 75 | 95 | 100 | 100 | 0
19 | 100 | 90 | 84 | 72 | 6 | 78 | 100 | 74.8 | 50 | 85 | 95 | 100 | 0 | 11.7
13.2 | 100 | 84 | 74 | 50 | 2 | 67 | 100 | 55 | 78 | 92 | 78 | 92 | -23 | 19.8 | 6 | 18 | 1.799999999999997
9.5 | 100 | 74 | 65 | 6 | 2 | 58 | 100 | 15.4 | 63 | 83 | 63 | 83 | -47.6 | 39.6 | 7 | 17 | 22.6
6.7 | 100 | 63 | 56 | 48 | 1 | 48 | 100 | 53.2 | 30 | 55 | 50 | 70 |  |  | 10 | 21
4.75 | 98 | 53 | 46 | 54 | 1 | 40 | 100 | 58.4 | 44 | 64 | 44 | 64 | 0 | -43 | 13 | 25 | -56
2.36 | 68 | 31 | 26 | 24 | 0 | 21 | 100 | 28.4 | 25 | 50 | 33 | 49 | 0 | 30 | 7 | 19 | 11
0.425 | 11 | 11 | 10 | 13 | 0 | 8 | 100 | 12.8 | 14 | 23 | 14 | 23 | -1.199999999999999 | 15.6 | 14 | 30 | 0 | 45.07042253521127 | 35-60
0.075 | 7 | 6 | 5 | 7 | 0 | 5 | 1 | 7 | 7 | 14 | 7 | 14 | 0 | 5.800000000000001 | 6 | 13 | -0.1999999999999993 | 54.6875 | 45-65
0.0135 | 4 | 4 | 4 | 5 | 0 | 3 | 0 | 4.9 | 3 | 7 | 3 | 7 | 0 | 2.1 | 3 | 8 | -0.9000000000000004 | 70 | 35-60
PI | 8 | 6 | 7 | 8 | 0 | 0 |  | 8 | 0 | 12 | 2 | 6 | 0
Ratio | 10 |  |  | 90 | 0 | 0 | 0 | 100 | Min CBR | 0
 | 1000t | 1000t | 1000t
Spreadsheet: 804091d1667888934-count-the-no-of-with-a-value-greater-than-7-based-on-results-from-2-other-columns-book1
Sheet: Sheet1

Helper
Total (<7) | Value 1 | Value 2
 | 2 | 5
 | 3 | 8
 | 1 | 9
 | 1 | 5
 | 0 | 7
 | 4 | 20
 | 2 | 2
2
Spreadsheet: 109329d1306231953-sumproduct-and-sumif-j-morrow_master_2
Sheet: Data Returns

PM2 Required | Base Location | Page | Section | Total
REQUIRED | Base1 | Hostile | Caliper | 2 |  |  | SUMPRODUCT(--(Master!$B$2:$B$2500=$A2),--(Master!$G$2:$G$2500=$B2),--(Master!$H$2:$H$2500=$C2),--(Master!$I$2:$I$2500=$D2))
GOOD | Base1 | Cal_Test | Bridle | 0
GOOD | Base1 | Cal_Test | BlstMtr | 2
GOOD | Base1 | Cal_Test | FlkMtr | 3
GOOD | Base1 | Cal_Test | Lud3 | 3
GOOD | Base1 | Cal_Test | Meggar | 1
Check list
Function | OTSD NOMEM | Other Open NTFY
COUNTA | 129 | 231
COUNT | 108 | 151
Count Strings | 21 | 80
[NAME] Numbers | 27 | 111
TOTAL | 156 | 342
TOTAL | 156 | 342 |  | Your one step formula |  |  | SUM(IF(LEN(TRIM('Master'!j2:[NAME]:[NAME]:j199," ",""))+1))
 |  |  |  |  |  |  | Note: to make the above array formula work, after typing in the formula, press ctrl+shift_enter
Spreadsheet: 788859d1658767903-how-to-find-a-minimum-maximum-values-with-vlookup-formula-2022-07-25-oeldere-herring282-teamdata_ch220725_forum
Sheet: Pivot Table

Rijlabels | [NAME] | Min van Value
10yd Sprint | 1.93 | 1.44
Athlete 1 | 1.76 | 1.44
Athlete 2 | 1.6 | 1.6
Athlete 3 | 1.88 | 1.77
Athlete 5 | 1.6 | 1.59
Athlete 6 | 1.93 | 1.73
20yd Sprint | 3.35 | 2.58
Athlete 1 | 2.74 | 2.58
Athlete 2 | 2.83 | 2.65
Athlete 3 | 3.25 | 2.9
Athlete 4 | 2.83 | 2.66
Athlete 5 | 2.74 | 2.64
Athlete 6 | 3.35 | 3.04
BW | 368.3 | 180
Athlete 1 | 192 | 180
Athlete 2 | 196.8 | 190
Athlete 3 | 368.3 | 317.5
Athlete 4 | 191 | 189.6
Athlete 5 | 193.5 | 182
Athlete 6 | 300 | 201.5
CMJ | 36.8 | 19.1
Athlete 1 | 34.4 | 29.6
Athlete 2 | 34.4 | 28.5
Athlete 3 | 26.1 | 19.1
Athlete 4 | 30.5 | 25.6
Athlete 5 | 36.8 | 28.4
Athlete 6 | 27.7 | 21.2
DECEL | 4.5 | 2.5
Athlete 1 | 4.5 | 3
Athlete 2 | 3.5 | 3.5
Athlete 3 | 3.5 | 2.5
Athlete 4 | 3 | 3
Athlete 5 | 4.5 | 4
Athlete 6 | 3.5 | 3
Fly 10 | 1.37 | 0.95
Athlete 1 | 1.09 | 0.98
Athlete 2 | 1.03 | 0.95
Athlete 3 | 1.26 | 1.25
Athlete 4 | 0.99 | 0.99
Athlete 5 | 1.1 | 0.99
Athlete 6 | 1.37 | 1.33
MPH | 21.9 | 14.9
Athlete 1 | 21.3 | 18.8
Athlete 2 | 21.9 | 19.9
Athlete 3 | 16.8 | 16
Athlete 4 | 20.7 | 20.7
Athlete 5 | 20.7 | 18.7
Athlete 6 | 16.6 | 14.9
Pro Agility | 5.22 | 4.34
Athlete 1 | 4.6 | 4.51
Athlete 2 | 0 | 0
Athlete 3 | 5.22 | 4.91
Athlete 4 | 4.75 | 4.75
Athlete 5 | 4.6 | 4.34
Athlete 6 | 5.16 | 5.1
Eindtotaal | 368.3 | 0.95