tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: b2fbf51b-4304-4501-a471-9ea528034280
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] | Beta-Galactosidase, Blood | Beta-Galactosidase, B | Fluorometric Enzyme Assay | EDTA (lavender-top) tube: EDTA |  |  | 2 | mL | Container/Tube:  Preferred: Lavender top (EDTA) Acceptable: Yellow top (ACD) [NAME]: 2 mL Additional Information: Provide a reason for referral with each specimen. Forms: New York Clients-Informed consent is required. Please document on the request form or electronic order that a copy is on file. An Informed Consent for Genetic Testing (Supply T576) is available in Special Instructions. | 0.5 mL | Hemolysis	NA Thawing	NA Lipemia	NA Icterus	NA Other	NA | > or =5.0 nmol/h/mL An interpretive report will be provided. | Friday; morning | 8 days | 15 days | 1 | 82657 |  |  |  |  | Rochester
[NAME] | [NAME] | BLOOD | Whole blood |  |  |  | Ambient | 7 days
[NAME] | Result | 60987 | Beta-Galactosidase, B | Beta-Galactosidase, B | Numeric |  |  |  |  | nmol/h/mL
[NAME] | Result | 34428 | Interpretation | Interpretation | Alphanumeric
[NAME] | Result | 34427 | Reason for Referral | Reason for Referral | Alphanumeric
[NAME] | Result | 34432 | Reviewed By | Reviewed By | Numeric
Spreadsheet: 875420d1721990561-sum-after-sort-unique-vstack-with-criteria-for-multiple-worksheet-vstack-with-criteria-3-
Sheet: P2

 |  |  |  | SN1 | SN2 | Particulars | ID |  |  |  |  |  |  |  |  |  |  | Header 1 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  | 77 |  | Apple | 5263 |  |  |  |  |  |  |  |  |  |  | 52
 |  |  |  | 321 |  | Orange | 125 |  |  |  |  |  |  |  |  |  |  | 36
 |  |  |  | 167 |  | Nuts | 3 |  |  |  |  |  |  |  |  |  |  | 4
 |  |  |  | 402 |  | Apple |  |  |  |  |  |  |  |  |  |  |  | 36
 |  |  |  | 919 |  | Text1 | 26 |  |  |  |  |  |  |  |  |  |  | 64
 |  |  |  |  | 37484 | Jasmine
 |  |  |  | 45 |  | Orange | 125 |  |  |  |  |  |  |  |  |  |  | 21
 |  |  |  | 55 |  | Deep | 412 |  |  |  |  |  |  |  |  |  |  | 44
 |  |  |  | 61 |  | Apple | 5263 |  |  |  |  |  |  |  |  |  |  | 95
 |  |  |  |  | 412 | Sunflower
Spreadsheet: 138630d1327771065-two-criteria-lookup-exact-and-closest-match-test-double-closest
Sheet: Test

Type | Cost | Adjustment
Blue Car | 20000 | 0 |  | Blue Bus | 25000 | #N/A
Blue Car | 30000 | 0.15
Blue Car | 40000 | 0.25
Blue Bus | 20000 | 0 |  | <----------------------- |  | Want it to return 0
Blue Bus | 30000 | 0.15
Blue Bus | 40000 | 0.25
Yellow Bus | 20000 | 0
Yellow Bus | 30000 | 0.15
Yellow Bus | 40000 | 0.25
Spreadsheet: 721071d1614450062-conditional-formatting-directional-arrows-seems-crazy-conditional-and-custom-formatting-to-display-variance-vonblack-
Sheet: 30+ OverDue

WE Date | 2021-01-03 00:00:00 | 2021-01-10 00:00:00 | 2021-01-17 00:00:00 | 2021-01-24 00:00:00 | 2021-01-31 00:00:00 | 2021-02-07 00:00:00 | 2021-02-14 00:00:00 | 2021-02-21 00:00:00 | 2021-02-28 00:00:00 | 2021-03-07 00:00:00
Account Manager | 791384.5199999998 | 766934.2599999997 | 749770.4199999997 | 730484.6099999998 | 758513.2699999998
User2 | 274731.29 | 275228.08 | 253444.74 | 248419.0799999999 | 256929.9499999999
User3 | 36758.99 | 36758.99 | 36758.99 | 36758.99 | 36758.99
User4 | 343685.7599999998 | 342100.0499999998 | 336495.4499999997 | 328906.5699999998 | 337180.5299999998
[NAME] | 136208.48 | 112847.14 | 123071.24 | 116399.97 | 127643.8
WE Date | 2021-01-03 00:00:00 | 2021-01-10 00:00:00 | 2021-01-17 00:00:00 | 2021-01-24 00:00:00 | 2021-01-31 00:00:00 | 2021-02-07 00:00:00 | 2021-02-14 00:00:00 | 2021-02-21 00:00:00 | 2021-02-28 00:00:00 | 2021-03-07 00:00:00
Account Manager | 791384.5199999998 | 766934.2599999997 | 749770.4199999997 | 730484.6099999998 | 758513.2699999998
User2 | 274731.29 | 275228.08 | 253444.74 | 248419.0799999999 | 256929.9499999999
User3 | 36758.99 | 36758.99 | 36758.99 | 36758.99 | 36758.99
User4 | 343685.7599999998 | 342100.0499999998 | 336495.4499999997 | 328906.5699999998 | 337180.5299999998
[NAME] | 136208.48 | 112847.14 | 123071.24 | 116399.97 | 127643.8
WE Date | 2021-01-03 00:00:00 | 2021-01-10 00:00:00 | Conditional | Custom | Copy Icons
Account Manager | 791384.5199999998 | 766934.2599999997 |  |  | ►▼▲
User2 | 274731.29 | 275228.08
User3 | 36758.99 | 36758.99
User4 | 343685.7599999998 | 342100.0499999998
[NAME] | 136208.48 | 112847.14
Spreadsheet: 73081d1273744707-the-source-currently-evaluates-to-an-error-bs7671-v7
Sheet: Factors (Ca)

Table 4B1 Rating factors for ambient temps other than 30Deg Cto be applied to the current carrying capacities for cable in free air
Ambient Temp Deg C | 70 Deg Thermoplastic | Ambient Temp Deg C | 90 Deg C Thermoplastic | Ambient Temp Deg C | Thermoplastic covered or bare and exposed to touch 70 Deg C | Ambient Temp Deg C | Bare and not exposed to touch to touch 105 Deg C
0 | 1.03 | 0 | 1.02 | 0 | 1.07 | 0 | 1.04
25 | 1.03 | 25 | 1.02 | 25 | 1.07 | 25 | 1.04
30 | 1 | 30 | 1 | 30 | 1 | 30 | 1
35 | 0.94 | 35 | 0.96 | 35 | 0.93 | 35 | 0.96
40 | 0.87 | 40 | 0.91 | 40 | 0.85 | 40 | 0.92
45 | 0.79 | 45 | 0.87 | 45 | 0.78 | 45 | 0.88
50 | 0.71 | 50 | 0.82 | 50 | 0.67 | 50 | 0.84
55 | 0.61 | 55 | 0.76 | 55 | 0.57 | 55 | 0.8
60 | 0.5 | 60 | 0.71 | 60 | 0.45 | 60 | 0.75
65 | 0.5 | 65 | 0.65 | 65 | 0.45 | 65 | 0.7
70 | 0.5 | 70 | 0.58 | 70 | 0.45 | 70 | 0.65
75 | 0.5 | 75 | 0.5 | 75 | 0.45 | 75 | 0.6
80 | 0.5 | 80 | 0.41 | 80 | 0.45 | 80 | 0.54
85 | 0.5 | 85 | 0.41 | 85 | 0.45 | 85 | 0.47
90 | 0.5 | 90 | 0.41 | 90 | 0.45 | 90 | 0.4
95 | 0.5 | 95 | 0.41 | 95 | 0.45 | 95 | 0.32
Tbale 4B2 Rating Factors for ambient ground temps other than 20 Deg C to be applied to the current carrying capacities for cables burried direct in the ground or in an undergound conduit system to BSEN50086-2-4
Ground temp | 70 Deg C Thermoplastic | Ground temp | 90 Deg Thermoplastic
0 | 1.1 | 0 | 1.07
10 | 1.1 | 10 | 1.07
15 | 1.05 | 15 | 1.04
20 | 1 | 20 | 1
25 | 0.95 | 25 | 0.96
30 | 0.89 | 30 | 0.93
35 | 0.84 | 35 | 0.89
40 | 0.77 | 40 | 0.85
45 | 0.71 | 45 | 0.8
50 | 0.63 | 50 | 0.76
55 | 0.55 | 55 | 0.71
60 | 0.45 | 60 | 0.65
65 | 0.45 | 65 | 0.6
70 | 0.45 | 70 | 0.53
75 | 0.45 | 75 | 0.46
80 | 0.45 | 80 | 0.38
Spreadsheet: 74326d1274873082-produce-data-from-pivot-table-jan-2010
Sheet: Filter Function

TCode 5 | (All)
TCode 1 | (All)
Type | (All)
Description | (All)
Reference | (All)
D/C | (All)
Line | (All)
Journal | (All)
Trans Date | (All)
Period | (All)
Account | (All)
Ldgr | (All)
Sum of Amount | Total
Total | 137388.34
Spreadsheet: 761253d1640779674-if-statement-to-include-3-conditions-and-outcomes-based-on-dates-and-blank-cells-deferred-income-subs-status-etaf
Sheet: Dec 21

Deferred Income Calculation
2021-12-31 00:00:00
ID | Organisation | First Joined | Live or Expired | Contract Value | Currency | Contract GBP Value | Contract Length (mths) | Contract Length (yrs) | Contract Start Date | Contract End Date
 | Expired Subscription | 2020-12-04 00:00:00 |  | 5000 | EUR |  | 12 |  | 2020-12-04 00:00:00 | 2021-12-03 00:00:00
 | Pending Subscription | 2021-11-01 00:00:00 |  |  |  |  | 12
 | Live Subscription | 2021-11-01 00:00:00 |  | 7000 | GBP |  | 12 |  | 2021-12-06 00:00:00 | 2022-12-05 00:00:00
 | If the date in cell K5 is before what's in A2 = Expired If the date in cell K5 is after what's in A2 = Live If there is nothing in cell K5 = Pending
Spreadsheet: 146920d1332424158-hlookup-to-return-last-value-example
Sheet: Report

Last Year | Person | 1974 | 1975 | 1976 | 1977 | 1978 | 1979 | 1980 | 1981 | 1982 | 1983 | 1984 | 1985 | 1986 | 1987 | 1988 | 1989 | 1990 | 1991 | 1992 | 1993 | 1994 | 1995 | 1996 | 1997 | 1998 | 1999 | 2000 | 2001 | 2002 | 2003 | 2004 | 2005 | 2006 | 2007 | 2008 | 2009 | 2010 | 2011 | 2012
1999 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
1984 | [NAME] | 1 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
2011 | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0
Spreadsheet: 737753d1624571119-sum-if-string-contains-given-characters-book1
Sheet: Sheet1

STRING | 1 | 2 | 3 | 4 | 5 |  |  |  | Character | 1 | 2 | 3 | 4 | 5
ABDRBGD |  |  |  |  |  |  |  |  | A | 1 |  | 2 | 1
EERACSSR |  |  |  |  |  |  |  |  | B | 2 | 1 |  |  | 1
ABHFG |  |  |  |  |  |  |  |  | C |  |  |  |  | 1
ZZZXFR
BCDCGGT
I have a simple formula in cells B2 to [NAME] if these strings contain the characters in the opposite table then sum the given values in that table, looking for a more elegant formula
Spreadsheet: 869434d1716000998-formula-to-find-vlookup-or-hlookup-for-values-report-formula
Sheet: BEFORE

REPORT FOR MONTH OF |  |  |  |  |  |  |  | January | January 1-31 | January 31 |  | 31 |  | 1
 |  |  |  |  | Monthly report |  |  | February | February 1-28 | February 28 |  | 28 |  | 1
MONTH | YEAR |  |  |  | Start of Project |  |  | March | March 1-31 | March 31 |  | 31 |  | 1
August | 2024 |  |  |  | End of Project |  |  | April | April 1-30 | April 30 |  | 30 |  | 1
 |  |  |  |  |  |  |  | May | May 1-31 | May 31 |  | 31 |  | 1
Type of Report | DATE |  |  |  |  |  |  | June | June 1-30 | June 30 |  | 30 |  | 1
 |  |  |  |  |  |  |  | July | July 1-31 | July 31 |  | 31 |  | 1
 |  |  |  |  |  |  |  | August | August 1-31 | August 31 |  | 31 |  | 1
 |  |  |  |  |  |  |  | September | September 1-30 | September 30 |  | 30 |  | 1
 |  |  |  |  |  |  |  | October | October 1-31 | October 31 |  | 31 |  | 1
Report Date |  |  |  |  |  |  |  | November | November 1-30 | November 30 |  | 30 |  | 1
Report Date |  |  |  |  |  |  |  | December | December 1-31 | December 31 |  | 31 |  | 1
 |  | Col 1 | Col 2
 | Monthly report
 | Start of Project
 | End of Project
Spreadsheet: 104258d1301916788-sumproduct-formula-help-dummy
Sheet: Sheet1

Emp No | Name | Department | Grade | Salary | Qualification
121 | [NAME] | Finance | M | 1000 | Graduate
114 | [NAME] | HR | M | 1100 | BBA
125 | [NAME] | Finance | S | 1400 | Masters
150 | [NAME] | Sales | E | 1200 | Graduate
152 | [NAME] | Finance | S | 1100 | MBA
155 | Anand | Finance | M | 1150 | Graduate
158 | George | HR | S | 1200 | Graduate
165 | Rishan | Finance | M | 1250 | Bcom
167 | Rohan | HR | M | 950 | Graduate
168 | [NAME] | Sales | E | 1000 | Masters
170 | Arjun | Sales | E | 1050 | Graduate
 | What I'm trying to do is a comparison study for a particular employee from the above list
 | Therefore I selected Emp No: 121 as an example
Emp No | Name | Department | Grade | Salary | Qualification |  | What I need
121 | [NAME] | Finance | M | 1000 | Graduate | In "Qualification" part need to consider relevant degrees, example for [NAME], then "BBA,Bcom" also shall be considered(from "Department & Grade" criteria). Apparently for masters degree "MBA" & other related degrees also should be considered.
 | Maximum Salary (in his dept with same grade) |  |  |  | 1150 | 1100
 | Minimum [NAME] (in his dept with same grade) |  |  |  | 1000
 |  | Mid Point |  |  | 1075 | 1050
Spreadsheet: darrell_schoolcraft__7319__imball0202
Sheet: Calpine

 | Calpine So. Point Power Del
 | 78113
Day | Measured | Scheduled
1 | -42385 | -39000 |  |  |  |  |  |  |  | San Juan
2 | -42398 | -40000 |  |  |  | Month | Measured | Scheduled | Imbalance | Index | Amount
3 | -42443 | -40000 |  |  |  | 2001-02-01 00:00:00 | -537 | -5933 |  | 5.62
4 | -41996 | -40000 |  |  |  | 2001-03-01 00:00:00 | -80533 | -96000 |  | 4.98
5 | -42071 | -40000 |  |  |  | 2001-04-01 00:00:00 | -819833 | -1020974 |  | 4.87
6 | -42172 | -42972 |  |  |  | 2001-05-01 00:00:00 |  | -1252019 |  | 3.82
7 | -48371 | -50000 |  |  |  | 2001-06-01 00:00:00 |  | -1589467 |  | 3.2
8 | -80802 | -70000 |  |  |  | 2001-07-01 00:00:00 | -2051914 | -1898771 |  | 2.77
9 | -82459 | -80300 |  |  |  | 2001-08-01 00:00:00 | -2021619 | -1999977 |  | 2.77
10 | -78069 | -80300
11
12
13
14 |  |  |  |  |  | 9/1 - 9/25
15
16
17
18
19 |  |  |  |  |  | Accumulated @ 9/25/01
20
21 |  |  |  |  |  | Equilalent volumes at 9/25/01
22
23
24
25
26
27
28
29
30
31
2002-01-31 00:00:00 |  |  | -2220
2002-02-10 00:00:00
CBS Volume
 |  |  | 86032
Spreadsheet: 844505d1696283285-sum-spilled-array-spilled-array-sum-function-ans
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  | 151+
 | 0 | 31 | 61 | 91 | 121 | 151 | 181 | 271 | 366
 | 30 | 60 | 90 | 120 | 150 | 180 | 270 | 365 |  | Grand Total | >90 | >=150
Level 1 | 0.9493547894929522 | 0.904783085731298 | 0.9655487161544682 | 0.6861963582878359 | 0.6961931991833352 | 0.2922003341515982 | 0.6556856414431802 | 0.6033548769741919 | 0.4350869493232514
Level 2 | 0.851858181620123 | 0.7220656043074298 | 0.2917728208923938 | 0.7015574181591908 | 0.5690542414651676 | 0.321483054192701 | 0.597426229003517 | 0.1673272183147085 | 0.3850874392344508
Level 3 | 0.8767090543738556 | 0.02040150656256112 | 0.9495993108657994 | 0.9774388093474402 | 0.1713337040688552 | 0.1042579629135236 | 0.6988723266072905 | 0.2955112617562148 | 0.7915259750591506
Spreadsheet: 773811d1648054160-wrong-nested-if-formula-ifnesdedformulas
Sheet: Sheet1

Field: | Formula 1: | [NAME] over 1: | Nested 1 and 2:
Not Excelent String
Bad Super String
Bad Ideal String
[NAME]
[NAME]
[NAME]
[NAME]
Spreadsheet: 101627d1299715213-number-of-counts-between-time-ranges-project-2
Sheet: Data

Before Any [NAME] (Raw Data Times)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Overlap to next day
Patient # | Time of Arrival | Sent to A Bed | 0:00 - 0:59 | 1:00 - 1:59 | 2:00 - 2:59 | 3:00 - 3:59 | 4:00 - 4:59 | 5:00 - 5:59 | 6:00 - 6:59 | 7:00 - 7:59 | 8:00 - 8:59 | 9:00 - 9:59 | 10:00 - 10:59 | 11:00 - 11:59 | 12:00 - 12:59 | 13:00 - 13:59 | 14:00 - 14:59 | 15:00 - 15:59 | 16:00 - 16:59 | 17:00 - 17:59 | 18:00 - 18:59 | 19:00 - 19:59 | 20:00 - 20:59 | 21:00 - 21:59 | 22:00 - 22:59 | 23:00 - 23:59 | 0:00 - 0:59 | 1:00 - 1:59 | 2:00 - 2:59 | 3:00 - 3:59 | 4:00 - 4:59
1 | 2011-01-01 04:47:48 | 2011-01-01 06:16:00
2 | 2011-01-01 04:37:09 | 2011-01-01 06:33:00
3 | 2011-01-01 04:55:54 | 2011-01-01 06:34:00
4 | 2011-01-01 05:21:03 | 2011-01-01 06:34:00
5 | 2011-01-01 06:48:20 | 2011-01-01 06:55:00
6 | 2011-01-01 06:52:26 | 2011-01-01 06:55:00
7 | 2011-01-01 06:47:29 | 2011-01-01 07:36:00
8 | 2011-01-01 07:34:43 | 2011-01-01 07:37:00
9 | 2011-01-01 07:06:48 | 2011-01-01 07:45:00
10 | 2011-01-01 22:19:04 | 2011-01-02 00:47:00
11 | 2011-01-01 22:33:39 | 2011-01-02 00:47:00
12 | 2011-01-01 23:07:05 | 2011-01-02 00:53:00
13 | 2011-01-02 00:30:03 | 2011-01-02 00:53:00
After
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Overlap to next day
Patient # | Time of Arrival | Sent to A Bed | 0:00 - 0:59 | 1:00 - 1:59 | 2:00 - 2:59 | 3:00 - 3:59 | 4:00 - 4:59 | 5:00 - 5:59 | 6:00 - 6:59 | 7:00 - 7:59 | 8:00 - 8:59 | 9:00 - 9:59 | 10:00 - 10:59 | 11:00 - 11:59 | 12:00 - 12:59 | 13:00 - 13:59 | 14:00 - 14:59 | 15:00 - 15:59 | 16:00 - 16:59 | 17:00 - 17:59 | 18:00 - 18:59 | 19:00 - 19:59 | 20:00 - 20:59 | 21:00 - 21:59 | 22:00 - 22:59 | 23:00 - 23:59 | 0:00 - 0:59 | 1:00 - 1:59 | 2:00 - 2:59 | 3:00 - 3:59 | 4:00 - 4:59
1 | 2011-01-01 04:47:48 | 2011-01-01 06:16:00 |  |  |  |  | 0.22 | 1 | 0.27
2 | 2011-01-01 04:37:09 | 2011-01-01 06:33:00 |  |  |  |  | 0.38 | 1 | 0.55
3 | 2011-01-01 04:55:54 | 2011-01-01 06:34:00 |  |  |  |  | 0.08 | 1 | 0.57
4 | 2011-01-01 05:21:03 | 2011-01-01 06:34:00 |  |  |  |  |  | 0.65 | 0.57
5 | 2011-01-01 06:48:20 | 2011-01-01 06:55:00 |  |  |  |  |  |  | 0.12
6 | 2011-01-01 06:52:26 | 2011-01-01 06:55:00 |  |  |  |  |  |  | 0.05
7 | 2011-01-01 06:47:29 | 2011-01-01 07:36:00 |  |  |  |  |  |  | 0.22 | 0.6
8 | 2011-01-01 07:34:43 | 2011-01-01 07:37:00 |  |  |  |  |  |  |  | 0.05
9 | 2011-01-01 07:06:48 | 2011-01-01 07:45:00 |  |  |  |  |  |  |  | 0.65
10 | 2011-01-01 22:19:04 | 2011-01-02 00:47:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.68 | 1 | 0.78
11 | 2011-01-01 22:33:39 | 2011-01-02 00:47:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.45 | 1 | 0.78
12 | 2011-01-01 23:07:05 | 2011-01-02 00:53:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.88 | 0.88
13 | 2011-01-02 00:30:03 | 2011-01-02 00:53:00 | 0.38
Spreadsheet: 1939d2c7-52ec-4efe-bd48-b0c85592f332
Sheet: nSTEMI - DGH

nSTEMI - Non-Interventional Hospital | Demographics | Admission details | Reperfusion | Interventional audit | Examinations | Tests | Medical History | Drug Therapy | Diabetes | Complications | Investigations/interventions | Discharge details | NICE MI criteria
1.       [NAME] admitted to a non-interventional hospital with angio and PCI facilities and discharged home from there | All | 2.39, 3.06, 2.02, 3.17, 2.04, 2.23 | n/a | n/a | All | All that apply | All | All that apply | All | If applies | All | All that apply | Both
2.       [NAME] admitted to a non-interventional hospital with angio without PCI facilities, 'treat & return' and discharged home | All | 2.39, 3.06, 2.02, 3.17, 2.04, 2.23 | n/a | n/a | All | All that apply | All | All that apply | All | If applies | All | All that apply | Both
3.       [NAME] admitted to a non-interventional hospital without  angio facilities and discharged home with intended return for investigation/intervention | All | 2.39, 3.06, 2.02, 3.17, 2.04, 2.23 | n/a | n/a | All | All that apply | All | All that apply | All | If applies | 4.13 - planned after discharge. | All that apply | Both
Spreadsheet: 870339d1716882333-need-help-in-tranposing-table-exam-results-sample
Sheet: Sheet1

 | Extract from Tab Class A
 | Student | English Language - EXP |  | English Language - N(A) |  | English Language - N(T) |  | Chinese Language - EXP |  | Chinese Language - N(A) |  | Basic Chinese Language - N(T) |  | [NAME] |  | [NAME]) |  | [NAME] |  | Mathematics - EXP |  | Mathematics - N(A) |  | Mathematics - N(T) |  | Science - EXP |  | Science - N(A) |  | Science - N(T) |  | Geography - EXP |  | History - EXP |  | Literature in English - EXP |  | Geography - N(A) |  | History - N(A) |  | Literature in English - N(A) |  | Art - CMN |  | Computer Applications - N(T) |  | Design & Technology - CMN |  | Food & Consumer Education - CMN
 |  | % | Grade | % | Grade | % | Grade | % | Grade | % | Grade | % | Grade | % | Grade | % | Grade | % | Grade | % | Grade | % | Grade | % | Grade | % | Grade | % | Grade | % | Grade | % | Grade | % | Grade | % | Grade | % | Grade | % | Grade | % | Grade | % | Grade | % | Grade | % | Grade | % | Grade
 | StudentA1 | 73 | A2 |  |  |  |  | 66 | B3 |  |  |  |  |  |  |  |  |  |  | 53 | C6 |  |  |  |  | 55 | C5 |  |  |  |  | 81 | A1 | 69 | B3 | 70 | A2 |  |  |  |  |  |  | 84 | P |  |  | VR | VR | 73 | P
 | Added column for highest for each subject and removed no score subjects manually
 |  | English Language - EXP |  |  | Chinese Language - EXP |  |  | Mathematics - EXP |  |  | Science - EXP |  |  | Geography - EXP |  |  | History - EXP |  |  | Literature in English - EXP |  |  | Art - CMN |  |  | Food & Consumer Education - CMN
 |  | % | Grade | Highest | % | Grade | Highest | % | Grade | Highest | % | Grade | Highest | % | Grade | Highest | % | Grade | Highest | % | Grade | Highest | % | Grade | Highest | % | Grade | Highest
 | StudentA1 | 67 | B3 | 73 | 48 | D7 | 81 | 80 | A1 | 97 | 54 | C6 | 93 | 71 | A2 | 86 | 71 | A2 | 88 | 65 | B3 | 95 | 90 | P | 98 | 80 | P | 97
 | Aim to achieve this table for individual students
 |  | % | Highest
 | English Language - EXP | 67 | 73
 | Chinese Language - EXP | 48 | 81
 | Mathematics - EXP | 80 | 97
 | Science - EXP | 54 | 93
 | Geography - EXP | 71 | 86
 | History - EXP | 71 | 88
 | Literature in English - EXP | 65 | 95
 | Art - CMN | 90 | 98
 | Food & Consumer Education - CMN | 80 | 97
Spreadsheet: 586455d1534394856-allocating-contract-costs-by-fiscal-month-copy-of-contract-spend-example-mps1228-
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC | JAN
 |  |  |  |  |  |  |  |  | 2018-02-04 00:00:00 | 2018-03-04 00:00:00 | 2018-04-08 00:00:00 | 2018-05-06 00:00:00 | 2018-06-03 00:00:00 | 2018-07-08 00:00:00 | 2018-08-05 00:00:00 | 2018-09-02 00:00:00 | 2018-10-07 00:00:00 | 2018-11-04 00:00:00 | 2018-12-02 00:00:00 | 2019-01-06 00:00:00
 | SPEND | START | END | EOY | TOTAL DAYS | FISCAL DAYS | COST/DAY |  | 2018-03-03 00:00:00 |  |  |  |  |  |  |  |  |  |  | 2019-02-02 00:00:00
 | 40161.44 | 2018-06-11 00:00:00 | 2018-10-19 00:00:00 | 2019-02-02 00:00:00
 | 10462.32 | 2018-06-25 00:00:00 | 2018-07-18 00:00:00 | 2019-02-02 00:00:00
 | 63406.61 | 2018-04-02 00:00:00 | 2019-07-01 00:00:00 | 2019-02-02 00:00:00
Spreadsheet: 751162d1633943579-number-of-values-within-each-closed-interval-example
Sheet: Sheet1

15.0225 | 31.8477 | 29.6444 | 18.4276 | 8.2123 | 9.4141 | 6.609900000000001 | 6.609900000000001 | 8.012 | 7.611400000000001 | 11.2168 | 11.2168
34.051 | 35.2528 | 19.8297 | 7.611400000000001 | 5.0075 | 6.4096 | 4.6069 | 26.4396 | 25.0375 | 15.4231 | 21.6324 | 31.2468
26.4396 | 36.054 | 21.6324 | 9.4141 | 9.2138 | 11.2168 | 14.6219 | 19.6294 | 15.4231 | 12.6189 | 12.6189 | 15.6234
44.8672 | 46.66990000000001 | 38.2573 | 22.8342 | 35.4531 | 13.4201 | 54.68190000000001 | 36.054 | 11.4171 | 9.6144 | 9.8147 | 11.8177
46.66990000000001 | 55.4831 | 37.8567 | 26.2393 | 13.4201 | 10.2153 | 19.2288 | 25.8387 | 16.024 | 11.2168 | 9.8147 | 14.2213
Expected solution below
Start of interval | End of interval | Number of values from Rows 1-5 that are within each closed interval
48.21507142857143 | 55.4831 | 2 | (2 values are between the closed interval of 48.21507143 and 55.4831), by closed interval the upper and lower limits are included as well
40.9470428571429 | 48.21507142857143 | 3 | (3 values are between the closed interval of 40.[PHONE] and 48.21507143), by closed interval the upper and lower limits are included as well
33.67901428571428 | 40.94704285714285 | same rule as above
26.41098571428571 | 33.67901428571428 | same rule as above
19.14295714285714 | 26.41098571428571 | same rule as above
11.87492857142856 | 19.14295714285714 | same rule as above
4.6069 | 11.87492857142856 | same rule as above
My attempt
Start of interval | End of interval | Number of values from Rows 1-5 that are within each closed interval
48.21507142857143 | 55.4831 |  | (2 values are between the closed interval of 48.21507143 and 55.4831), by closed interval the upper and lower limits are included as well
40.9470428571429 | 48.21507142857143 |  | (3 values are between the closed interval of 40.[PHONE] and 48.21507143), by closed interval the upper and lower limits are included as well
33.67901428571428 | 40.94704285714285
26.41098571428571 | 33.67901428571428
19.14295714285714 | 26.41098571428571
11.87492857142856 | 19.14295714285714
4.6069 | 11.87492857142856
Spreadsheet: 739583d1625805207-countif-while-distinguishing-1-20-and-1-2-decimal
Sheet: Sheet1

 |  |  |  | [NAME] |  | Range | Criteria | COUNTIF
 |  |  |  |  |  | 1.2 | 1.2
 |  |  |  |  |  | 1.20
 |  |  |  | Mockup |  | Range | Criteria | COUNTIF
 |  |  |  |  |  | 1.2 | 1.2 | 1
 |  |  |  |  |  | 1.20
 |  |  |  | Mockup |  | Range | Criteria | COUNTIF
 |  |  |  |  |  | 1.2 | 1.20 | 1
 |  |  |  |  |  | 1.20