tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 567d5433-d030-4eb9-86fd-bfdd7ca914df
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
[NAME] | Test | [NAME] | Zinc/Creatinine Ratio, Random, [NAME] | Zinc/Creat Ratio, Random, U | ZNCR/32497: Dynamic Reaction Cell-Inductively Coupled Plasma-Mass Spectrometry (DRC-ICP-MS) CDCR/7243: Enzymatic Colorimetric Assay | Plastic urine container with no metal cap or glued insert |  |  | 3 | mL | Collection Container/Tube: Clean, plastic urine collection container Submission Container/Tube: Plastic, 10-mL urine tube (Supply T068) or clean, plastic aliquot container with no metal cap or glued insert [NAME]: 3 mL Collection Instructions:  1. Collect a random urine specimen. 2. See Metals Analysis-Collection and Transport in Special Instructions for complete instructions. Additional Information: High concentrations of barium are known to interfere with most metals tests. If barium-containing contrast media has been administered, a specimen should not be collected for 96 hours. | 0.7 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | 300-600 mcg/g Creatinine Reference values apply to all ages. | Monday, Wednesday, Friday, 8 a.m. to 11 a.m. | 1 day | 4 days |  | Profile |  |  |  |  | Rochester
[NAME] | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 28 days
[NAME] | Component | ZNCR | Zinc/Creatinine Ratio, [NAME] | Zinc/Creat Ratio, U | Only orderable as part of a profile. For further information see #60527 Zinc/Creatinine Ratio, Random, [NAME] |  |  |  |  |  | Only orderable as part of a profile. For further information see #60527 Zinc/Creatinine Ratio, Random, [NAME] |  |  | Only orderable as part of a profile. For further information see #60527 Zinc/Creatinine Ratio, Random, [NAME] |  |  |  | 1 | 84630 |  |  | Yes | No
ZNCR | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 28 days
ZNCR | Result | 32876 | Zinc/Creat Ratio, U | Zinc/Creat Ratio, U | Numeric |  |  |  |  | mcg/g |  |  |  |  |  |  |  |  |  | In Process
ZNCR | Result | 32891 | Zn Concentration | Zn Concentration | Numeric |  |  |  |  | mcg/L |  |  |  |  |  |  |  |  |  | In Process
[NAME] | Component | CDCR | [NAME] | [NAME] | For further information see #8513 "Creatinine, U." |  |  |  | 5 | mL | Only orderable as part of a profile. For further information  see #8513 "Creatinine, [NAME]." |  |  |  |  |  |  |  |  |  |  | Yes | No
CDCR | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 30 days
CDCR | Result | CDCR | [NAME] | [NAME] | Numeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | 35674-1
Spreadsheet: 845580d1697033675-problem-incrementing-or-decrementing-a-cells-value-based-on-a-filters-value-golfscoresmultiplayerliveck76bak-aligw
Sheet: Summary

 | Golf Scores - Team Summary |  |  |  |  |  |  |  |  |  | Team: | Team2
 | Rounds Played |  |  |  | High Score |  |  |  |  |  |  |  |  | Data Entry |  |  | Below Par
 |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  | Par |  |  | Most frequent
 |  | 1st | 2nd | 3rd | 4th | 5th | 6th | 7th | 8th | 9th | Front | 10th | 11th | 12th | 13th | 14th | 15th | 16th | 17th | 18th | Back | Total
 | Course Par | 4 | 4 | 3 | 5 | 4 | 4 | 4 | 3 | 4 |  | 4 | 4 | 3 | 4 | 5 | 3 | 4 | 4 | 5
 | HighScore
 | AvScore
 | <= -3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -3
 | Eagles |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -2
 | Birdies |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -1
 | Pars |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 | Bogeys |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
 | Double Bogeys |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 | >= +3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
 | Total
Spreadsheet: louise_kitchen__23935__AugYTD Orig w notes
Sheet: Derivatives

Derivatives
By Team
Originator |  | Commodity |  | Team |  | Total |  | %Total
[NAME] |  | Gas |  | Derivatives |  | 7592350
Lagrasta |  | Gas |  | Derivatives
Black |  | Gas |  | Derivatives |  | 2590709
Abramo |  | Gas |  | Derivatives
Otto |  | Gas |  | Derivatives |  | 1817797
Breslau |  | Gas |  | Derivatives |  | 1727257
Smith, [NAME] |  | Gas |  | Derivatives |  | 1545138
[NAME] |  | Gas |  | Derivatives |  | 1317548
Ortiz |  | Gas |  | Derivatives |  | 667200
[NAME] |  | Gas |  | Derivatives |  | 601115
Abramo |  | Gas |  | Derivatives |  | 496920
Shipos |  | Gas |  | Derivatives |  | 261137
Figueroa |  | Gas |  | Derivatives |  | 170105
Prevatt |  | Gas |  | Derivatives
Fuller |  | Gas |  | Derivatives |  | 100796
Feitler |  | Gas |  | Derivatives
Titus |  | Gas |  | Derivatives |  | 81049
[NAME] |  | Gas |  | Derivatives |  | 29707
Enduser |  | Gas |  | Derivatives |  | 17739.32000000007
Berkeland |  | Gas |  | Derivatives |  | 17148
Wilson |  | Gas |  | Derivatives |  | 13500
Villarreal |  | Gas |  | Derivatives |  | 7360
Racicot |  | Gas |  | Derivatives |  | 5059
Goodell |  | Gas |  | Derivatives |  | 2315
Munir |  | Gas |  | Derivatives |  | 1007
Seske |  | Gas |  | Derivatives |  | 1000
Singer |  | Gas |  | Derivatives |  | 210
Breglam |  | Gas |  | Derivatives |  | 273
Total
Spreadsheet: benjamin_rogers__1099__2000 peaker performance data
Sheet: Sheet1

 | Corrected to 90F, 60%, 14.696 psia |  |  |  | Corrected to 15% O2
[NAME] | Turbine | Net Electrical Output | Heat Rate | Aux. Loads | Nox (corr.) | CO (corr.) | Starts | Total Run-Hours
 |  | (kW) | Btu/kWh (LHV) | (kW) | [NAME] | [NAME]
Unit 1 | Westinghouse 501FD | 178188 | 9908 | 293 | 24.45 | 10.44
Unit 2 | Westinghouse 501FD | 181976 | 9821 | 273 | 24.25 | 15.44
Unit 3 | Westinghouse 501FC | 180619 | 9888 | 369 | 23.9 | 13.8
Control System - Westinghouse WDPF
Wheatland
Unit 1 | Westinghouse 501D5A | 119445 | 10540 | 215 | 23 | 6.1
Unit 2 | Westinghouse 501D5A | 120217 | 10451 | 213 | 24.3 | 21.8
Unit 3 | Westinghouse 501D5A | 116109 | 10465 | 189 | 22.3 | 6.8
Unit 4 | Westinghouse 501D5A | 119227 | 10433 | 204 | 23.7 | 11.2
Control System - Westinghouse WDPF
 | Corrected to 90F, 60%, 14.34 psia
Wilton/Lincoln Center
 |  |  |  |  | Raw Emissions Data
Unit 1 | General Electric 7EA | 78166 | 10622 | 166 | 9.44 | 11.78
Unit 2 | General Electric 7EA | 77651 | 10641 | 166 | 9.18 | 18.37
Unit 3 | General Electric 7EA | 76539 | 10545 | 163 | 8.76 | 12.6
Unit 4 | General Electric 7EA | 76685 | 10650 | 158 | 8.84 | 33.11
Unit 5 | General Electric 7EA | 77293 | 10717 | 166 | 8.33 | 55.52
Unit 6 | General Electric 7EA | 78368 | 10641 | 159 | 9.53 | 15.73
Unit 7 | General Electric 7EA | 78360 | 10690 | 158 | 7.48 | 62.59
Unit 8 | General Electric 7EA | 77708 | 10694 | 160 | 7 | N/A
Control System - GE Mark V
Spreadsheet: 835067d1688264576-formula-to-allocate-my-reorder-quantity-in-quarter-columns-based-on-reorder-points-book3
Sheet: Sheet1

 |  |  | TSL
Part Number | Part Name | Reorder Point | TSL (Stock [NAME]) | Reorder Quanity (= TSL-Reorder point) | Units on Hand (Global OH Serviceable from BSAS by Location) | On Order | IN Repair | Unserviceable Inventory | Total Inventory (=Sum(OH+OO+IN+UNSER)) | Forecast Demand | Forecast Quarterly | Intitial Order Quanity or Deplete stock to ROP (TOI-ROP= IOQ) | Number of Quarters till First Reorder Point (=roundup(IOQ/Quarterly Forecast Demand) | Count of Quarters till first ROP | Number of Quarters till 2nd Reorder Point and Beyond (=roundup(ROQ/QU)) | Q3 2023 | Q4 2023 | Q1 2024 | Q2 2024 | Q3 2024 | Q4 2024 | Q1 2025 | Q2 2025 | Q3 2025 | Q4 2025 | Q1 2026 | Q2 2026 | Q3 2026 | Q4 2026
Part 1 | BEARING | 160 | 203 |  | 225 | 0 | 0 | 0 | 225 | 6.010355 |  |  |  |  |  | 0 | 0 | 0 |  | 0 | 0 | 43 | 0 | 0 | 43 | 0 | 0 | 43 | 0
Part 1 | BEARING | 160 | 203 |  | 225 | 0 | 0 | 0 | 225 | 6.010355
Spreadsheet: 170a8571-3617-42b2-81bc-3971f4210d6d
Sheet: Sheet1

Date | Sport | Opponent | Time | Results
10/05/2013 | Men's Swimming & Diving | Gold-Blue Meet | 12:00 AM | Gold 231.5-199.5
10/11/2013 | Men's Swimming & Diving | West Virginia State Games (Morgantown, W.Va.) | 12:00 AM | 1st Place
10/12/2013 | Men's Swimming & Diving | West Virginia State Games (Morgantown, W.Va.) | 12:00 AM | 1st Place
10/18/2013 | Men's Swimming & Diving | at Penn State | 12:00 AM | L 127-161
10/25/2013 | Men's Swimming & Diving | WVU Invite (Morgantown, W.Va.) | 12:00 AM | 1st Place
10/26/2013 | Men's Swimming & Diving | WVU Invite (Morgantown, W.Va.) | 12:00 AM | 1st Place
11/08/2013 | Men's Swimming & Diving | Big 12/ACC Challenge (Charlottesville, Va.) | 12:00 AM | Results
11/09/2013 | Men's Swimming & Diving | Big 12/ACC Challenge (Charlottesville, Va.) | 12:00 AM | Results
11/21/2013 | Men's Swimming & Diving | Mizzou Invite (Columbia, Mo.) | 12:00 AM | Results
11/22/2013 | Men's Swimming & Diving | Mizzou Invite (Columbia, Mo.) | 12:00 AM | Results
11/23/2013 | Men's Swimming & Diving | Mizzou Invite (Columbia, Mo.) | 12:00 AM | Results
01/03/2014 | Men's Swimming & Diving | Orange Bowl Swim Classic (Key Largo, Fla.) | 12:00 AM | 2nd Place
01/11/2014 | Men's Swimming & Diving | Pitt | 12:00 AM | L 139-161
01/18/2014 | Men's Swimming & Diving | at TCU | 12:00 AM | W 167-133
01/31/2014 | Men's Swimming & Diving | at Ohio State | 12:00 AM | L 99-151
[NAME] | Men's Swimming & Diving | Big 12 Championships (Austin, Texas) | 12:00 AM | Results
02/27/2014 | Men's Swimming & Diving | Big 12 Championships (Austin, Texas) | 12:00 AM | Results
02/28/2014 | Men's Swimming & Diving | Big 12 Championships (Austin, Texas) | 12:00 AM | Results
03/01/2014 | Men's Swimming & Diving | Big 12 Championships (Austin, Texas) | 12:00 AM | Results
03/10/2014 | Men's Swimming & Diving | [NAME] "A" Diving Championships (Blacksburg, Va.) | 09:00 AM | Results
03/11/2014 | Men's Swimming & Diving | [NAME] "A" Diving Championships (Blacksburg, Va.) | 09:00 AM | Results
03/27/2014 | Men's Swimming & Diving | Men's NCAA Championships (Austin, Texas) | 12:00 PM | 23rd Place
[NAME] | Men's Swimming & Diving | Men's NCAA Championships (Austin, Texas) | 12:00 PM | 23rd Place
[NAME] | Men's Swimming & Diving | Men's NCAA Championships (Austin, Texas) | 12:00 PM | 23rd Place
Spreadsheet: 139563d1328303462-excel-2007-vlookup-worktabs-vlookup-within-worktabs-book1
Sheet: D

Manager [NAME]: |  | D
Coverage Analyst:
Date of Review
Monthly:
 | 1) Two Pager
 | 2) Data Form
 | 3) Manager [NAME]
Semi-Annually:
 | 1) Manager [NAME]
Annual / Other Periodic:
 | 1) Ops DD Report
 | 2) IC Recommendation Memo
 | 3) Term Sheet
 | 4) Reference Lists
 | 5) News Article
 | 6) Background Check Reports
 | 7) Marketing Presentations and Others
 | 8) Current AFS
Notes / Comments:
Spreadsheet: 160580d1339124628-multiple-drop-down-list-that-automatically-update-using-offset-and-named-ranges-offset-drop-down-lists-with-indirect-named-ranges
Sheet: Data

State | Oregon | California | Nevada | Florida
Oregon | Portland | Los Angeles | Las Vegas | Boyton Beach
California | Beaverton | Cerritos | Reno | Miami
Nevada | Bend | [NAME] | Nevada3 | West Palm
State4 | Oregon City | Santa Monica | Nevada4 | Florida4
State5 | Oregon5 | California5 |  | Florida5
State6 | Oregon6 | California6
State7
Spreadsheet: 583056d1532205645-using-if-function-across-separate-tables-items-example
Sheet: Sheet1

 | Order ID | Device | Item
 | M3VMP1NNRXKJ0 |  | Appe
 | M3VMP1NNRXKJ0 |  | Pear
 | M3VMP1NNRXKJ0 |  | Bannana
 | V0AYZ14YVRCCR |  | Meat
 | V0AYZ14YVRCCR |  | Cheese
 | Z0K8EP92C31AP |  | Chocolate
 | KCFZBMNGDENC0 |  | Pear
 | KCFZBMNGDENC0 |  | Cheese
 | What It should be
 | Order ID | Device | Item
 | M3VMP1NNRXKJ0 | Store 1 | Appe
 | M3VMP1NNRXKJ0 | Store 1 | Pear
 | M3VMP1NNRXKJ0 | Store 1 | Bannana
 | V0AYZ14YVRCCR | Store 2 | Meat
 | V0AYZ14YVRCCR | Store 2 | Cheese
 | Z0K8EP92C31AP | Store 3 | Chocolate
 | KCFZBMNGDENC0 | Store 1 | Pear
 | KCFZBMNGDENC0 | Store 1 | Cheese
Spreadsheet: darrell_schoolcraft__7775__imbalsumm0106
Sheet: PG&E

56698
Day | Scheduled | Measured
1 | 199560 | 201126
2 | 147248 | 148629
3 | 192955 | 194271
4 | 192652 | 193485
5 | 169009 | 165596
6 | 114940 | 116973
7 | 160759 | 162355
8 | 98370 | 98207
9 | 62643 | 63670
10 | 91985 | 93377
11 | 102048 | 103020
12 | 66395 | 66527
13 | 82203 | 82687
14 | 24040 | 26899
15 | 89433 | 90967
16 | 74986 | 75328
17 | 55046 | 56156
18 | 58054 | 60523
19 | 141458 | 117983
20 | 67088 | 71618
21 | 89187 | 89692
22 | 109277 | 110124
23 | 125238 | 117326
24 | 72075 | 74353
25
26
27
28
29
30
31
2001-05-31 00:00:00 |  |  | -10045
2001-06-24 00:00:00
Spreadsheet: 686755d1594803061-cell-referencing-from-multiple-sheets-if-value-of-specific-cell-matches-trial-outstanding-returns-small
Sheet: Data

 | 2020 | CLIENT LIST
Ref | Comments | Name | Form  Type |  |  |  |  | Status
Coles | 11 | Coles | A1 |  |  | [NAME] |  | Not Started
Woolworths | 11 | Woolworths | A1 |  |  | [NAME] |  | No Longer Client
BIGW | 22 | Big W | A1 |  |  | [NAME] |  | Waiting on info
Target | 22 | Target | A1 |  |  | Lina |  | Waiting to Finalise
JustJeans | 11 | Just Jeans | B1 |  |  | Ornina |  | Completed
[NAME] | 11 | [NAME] | B1 |  |  | Ash
DavidJones | 33 | [NAME] | B1
SushiSushi | 33 | [NAME] | B1
CocaCola | 44 | Coca Cola | B1
Microsoft | 44 | Microsoft | B1
[NAME] | 33 | Alumina Ltd | B1
BHPGroup | 55 | BHP Group Ltd | C1
AGLEnergy | 55 | AGL Energy Ltd | C1
AMP | 44 | AMP Ltd | C1
Ansell | 22 | Ansell Ltd | C1
Afterpay | 11 | Afterpay Ltd | C1
Ausnet | 33 | Ausnet Services Ltd | C1
Spreadsheet: d6047c89-944f-4237-a03d-27cf4d4f25f5
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
7891 | 49627 | [NAME] | [NAME] | TPE | 81 | 00:47:25 | 00:00:43 | 01:14:42 | 00:01:08 | 00:21:49 | 1 | 02:25:49
7891 | 46337 | [NAME] | Mohammadi | IRI | 82 | 00:47:24 | 00:00:55 | 01:22:30 | 00:01:44 | [NAME] | 2 | 02:39:11
7891 | 52947 | [NAME] | [NAME] | TPE | 85 | 00:57:32 | 00:00:55 | 01:23:40 | 00:01:17 | 00:17:57 | 3 | 02:41:21
7891 | 46527 | Zukhra | Vakhitova | UZB | 83 | 00:41:25 | [NAME] | 01:08:06 | 00:01:39 | 00:20:16 | DQ | 00:00:00
Spreadsheet: 840521d1692796358-table-to-work-out-take-home-pay-from-total-commission-comms-summary-dqb
Sheet: Sheet1

 | Month | Comms
 | 1 | 0 |  | Manual input rows in Green
 | 2 | 0
 | 3 | 1000 |  | A
 | Total
0.05 | 0-15000 |  |  | his should display 5% of 1000
0.1 | 15001-35000 | 0
0.2 | 35000+ | 0
 | [NAME] | 750
Spreadsheet: 778760d1651299451-formula-conditional-formatting-to-highlight-upcoming-oil-change-week-sample
Sheet: MP10

Oil Change Plan
 | Week # |  |  | Oil change due reading |  | 91190 |  |  |  |  |  |  | 2021-06-01 00:00:00 |  |  |  | 2021-07-01 00:00:00 |  |  |  | 2021-08-01 00:00:00 |  |  |  | 2021-09-01 00:00:00 |  |  |  | 2021-10-01 00:00:00 |  |  |  | 2021-11-01 00:00:00 |  |  |  | 2021-12-01 00:00:00 |  |  |  | 2022-01-01 00:00:00 |  |  |  | 2022-02-01 00:00:00 |  |  |  | 2022-03-01 00:00:00 |  |  |  | 2022-04-01 00:00:00 |  |  |  | 2022-05-01 00:00:00 |  |  |  | 2022-06-01 00:00:00
Last Replacment Date: |  | 2021-06-27 00:00:00 |  | Reading date |  | 2022-04-27 00:00:00 |  | Doc 1 |  |  |  |  | W1 | [NAME] | W3 | W4 | W1 | [NAME] | W3 | W4 | W1 | [NAME] | W3 | W4 | W1 | [NAME] | W3 | W4 | W1 | [NAME] | W3 | W4 | W1 | [NAME] | W3 | W4 | W1 | [NAME] | W3 | W4 | W1 | [NAME] | W3 | W4 | W1 | [NAME] | W3 | W4 | W1 | [NAME] | W3 | W4 | W1 | [NAME] | W3 | W4 | W1 | [NAME] | W3 | W4 | W1 | [NAME] | W3 | W4
M/ Unit | Point No | Description | Quantity (L) | Code | Date Oil Change | Status | Oil Change Meter Reading | RunningHours | Remaining Hours | Total run Hours | Running days | Per day Run
M1 | 1 | Agitator [NAME] | 0.5 | Shell Omla EP150 | 2018-09-17 00:00:00 |  | 85047 | 6000
 | 2 | Hopper pusher unit | 8 | Shell Omla EP150 | 2018-01-04 00:00:00 |  | 85047 | 6000
 | 3 | Cig. Pocket pusher unit | 6 | Shell Omla EP150 | 2018-01-04 00:00:00 |  | 85047 | 6000
Spreadsheet: matthew_lenhart__26358__TexacoPG&ETopock deals
Sheet: 693800

Deal Id | 693800 |  |  |  |  |  | Original Deal Volume |  |  | Deal Price
Month | 2001-04-01 00:00:00 |  |  |  |  |  | 5000 |  |  | 7.04
 |  | Pipe | Zone | MeterCode
 |  | PG&E |  |  | Sum
 |  | SBELP TPCK |  | Sum |  |  |  |  | PG&E Large Packages |  |  | Contract |  | PG&E Large Packages
 | Date | EP0202RSB - SB-EPNG/ | Sum |  |  |  | Volume Cut |  | Gas Daily Price |  |  | Penalty |  | Gas Daily Hi Price |  | Hi - Penalty
 | 1 |  |  |  |  |  |  |  | 7.65 |  |  |  |  | 8.31
 | 2 | 4300 | 4300 | 4300 | 4300 |  |  |  | 7.65 |  |  |  |  | 8.31
 | 3 | 4763 | 4763 | 4763 | 4763 |  |  |  | 6.035 |  |  |  |  | 6.66
 | 4 | 4602 | 4602 | 4602 | 4602 |  |  |  | 7.96 |  |  |  |  | 9.3
 | 5 | 2560 | 2560 | 2560 | 2560 |  |  |  | 10.895 |  |  |  |  | 12.12
 | 6 | 3642 | 3642 | 3642 | 3642 |  |  |  | 11.59 |  |  |  |  | 12.99
 | 7 |  |  |  |  |  |  |  | 11.83 |  |  |  |  | 12.24
 | 8 | 5000 | 5000 | 5000 | 5000 |  |  |  | 11.83 |  |  |  |  | 12.24
 | 9 | 5000 | 5000 | 5000 | 5000 |  |  |  | 11.83 |  |  |  |  | 12.24
 | 10 | 5000 | 5000 | 5000 | 5000 |  |  |  | 11.575 |  |  |  |  | 12.25
 | 11 | 5000 | 5000 | 5000 | 5000 |  |  |  | 11.73 |  |  |  |  | 11.93
 | 12 | 5000 | 5000 | 5000 | 5000 |  |  |  | 11.62 |  |  |  |  | 12.23
 | 13 | 5000 | 5000 | 5000 | 5000 |  |  |  | 11.805 |  |  |  |  | 12.3
 | 14 | 5000 | 5000 | 5000 | 5000 |  |  |  | 11.805 |  |  |  |  | 12.3
 | 15 | 5000 | 5000 | 5000 | 5000 |  |  |  | 11.805 |  |  |  |  | 12.3
 | 16 | 4827 | 4827 | 4827 | 4827 |  |  |  | 11.805 |  |  |  |  | 12.3
 | 17 |  |  |  |  |  |  |  | 11.775 |  |  |  |  | 12
 | 18 | 5000 | 5000 | 5000 | 5000 |  |  |  | 11.42 |  |  |  |  | 11.9
 | 19 | 383 | 383 | 383 | 383 |  |  |  | 11.37 |  |  |  |  | 11.9
 | 20 | 4956 | 4956 | 4956 | 4956 |  |  |  | 11.045 |  |  |  |  | 11.67
 | 21 | 2967 | 2967 | 2967 | 2967 |  |  |  | 10.67 |  |  |  |  | 11.23
 | 22 | 5000 | 5000 | 5000 | 5000 |  |  |  | 10.67 |  |  |  |  | 11.23
 | 23 | 5000 | 5000 | 5000 | 5000 |  |  |  | 10.67 |  |  |  |  | 11.23
 | 24 | 5000 | 5000 | 5000 | 5000 |  |  |  | 10.855 |  |  |  |  | 11.42
 | 25 | 5000 | 5000 | 5000 | 5000 |  |  |  | 11.995 |  |  |  |  | 12.6
 | 26 | 5000 | 5000 | 5000 | 5000 |  |  |  | 12.52 |  |  |  |  | 13.1
 | 27 | 5000 | 5000 | 5000 | 5000 |  |  |  | 12.105 |  |  |  |  | 12.6
 | 28 | 5000 | 5000 | 5000 | 5000 |  |  |  | 12.005 |  |  |  |  | 12.18
 | 29 | 5000 | 5000 | 5000 | 5000 |  |  |  | 12.005 |  |  |  |  | 12.18
 | 30 | 5000 | 5000 | 5000 | 5000 |  |  |  | 12.005 |  |  |  |  | 12.18
 | Sum |  | 123000 | 123000 | 123000
Spreadsheet: 175171d1345443985-drop-down-list-linking-data-issue-0a2fworkbook
Sheet: Sheet1

Date | Details |  |  |  |  |  | Amount | Paid | [NAME]
 | Patient :                                                          ID No :
 | DOB :
 | Treating Provider :
 | ICD-10/Diagnoses :
 | Procedure(s) / Modifiers
AM | 72006 - INT Laser beam
 | 0006
Spreadsheet: 125954d1319430372-dynamic-sumif-ranges-based-on-hlookup-criteria-dynamic-sum-if-range
Sheet: Source Data

 | Actual | Actual | Actual | Actual | Actual | Estimate | Estimate | Estimate
 | 08/2011 | 09/2011 | 10/2011 | 11/2011 | 12/2011 | 10/2011 | 11/2011 | 12/2011
A
B
K | 10
D | 20
Z
F
Y
H
I
J
K | 252
L | 420 | 84
Spreadsheet: 469854d1468218877-input-data-validation-of-swim-times-mm-ss-milli-swimtimes_question_version3
Sheet: Sheet1

 |  |  |  |  | [NAME]:[NAME] | [NAME]:[NAME]
 | Race Name | Gender | Age | Event | Level 1 | Level 3 |  |  |  |  | Correct
 |  | F | 10 | 100m Back | 00:01:47.040000 | 01:14:35 | <<< should actually be this value here: |  |  |  | 00:01:14.350000
 |  | F | 10 | 100m [NAME] | 00:02:00.540000 | 1900-02-10 04:33:36 | <<< not sure how a date got in here
 |  | M | 10 | 200m Breast | 00:03:54.500000 | 00:03:38.680000
 |  | M | 10 | 200m Free | 00:03:14.080000 | 00:02:55.740000
My Logic:
 | No timed swim ever reaches one hour:
 | 1hour in hh:[NAME]:ss:.mili format: | 01:00:00
 | …1 hour in date format
 | …as decimal value: |  | … SO then it follows, data validation can just check input is a decimal less than 0.04166667!! :)
A Simple Check:
 | Is this user input correct? | Input time (hh:[NAME]:ss.milli) | As Date | As Decimal value | Validation Test
 | No (from example above)
 | No (from example above)
 | Yes (from example above)
 | Yes (from example above)
 | Yes (zero) | 00:00:00
 |  | 06:05:56
Final Solution (Data Validation of Cell): |  | 00:02:03.220000
Spreadsheet: 545346d1509421518-counting-non-zero-cells-across-multiple-columns-with-changing-criteria-counting-non-zero-cells-across-multiple-columns-with-changing-criteria
Sheet: Sheet1

BC |  |  | A | B | C |  |  |  | A | B | C | AB | AC | BC
 |  |  | 0 | 1 | 0
 |  |  | 1 | 0 | 1
 |  |  | 0 | 0 | 2
 |  |  | 0 | 0 | 0
 |  |  |  |  |  |  |  |  | =SUM(--(MMULT(ISNUMBER(FIND($F$1:$H$1,A1))*($F$2:$H$5>0),{1;1;1})>0))
Spreadsheet: 3c7f51cf-6e01-4861-80db-8b2b609ab8f2
Sheet: Table 7.1

Monthly Statistical Bulletin
7.1 Population
Quarter | 2008–09 | 2009–10 | 2010–11 | 2011–12 | 2012–13
Estimated resident population (a) – '000
September
December
March
June
Annual change – '000
September
December
March
June
Annual change – per cent
September
December
March
June
(a) At the end of the quarter.
Source: ABS, Australian demographic statistics, Cat. no. 3101.0 | http://www.rba.gov.au/Statistics/exchange_rates.html | http://www.rba.gov.au/Statistics/exchange_rates.html | http://www.rba.gov.au/Statistics/exchange_rates.html | http://www.abs.gov.au/AUSSTATS/abs@.nsf/second+level+view?ReadForm&prodno=3101.0&viewtitle=Australian%20Demographic%20Statistics~Sep%202007~Latest~19/03/2008&&tabname=Past%20Future%20Issues&prodno=3101.0&issue=Sep%202007&num=&view=&
 |  |  |  |  |  |  |  | Update