tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 74121d1274721795-excel-2007-dependent-dropdown-data-validation-wiresizing
Sheet: Lists

RUN TYPE | CIRCUIT MATERIAL | CIRCUIT TEMP RATING | CONDUITCOPPER60C140F | CONDUITCOPPER70C167F | CONDUITCOPPER90C194F | CONDUITALUMINUM60C140F | CONDUITALUMINUM70C167F | CONDUITALUMINUM90C194F | CABLETRAYCOPPER60C140F | CABLETRAYCOPPER70C167F | CABLETRAYCOPPER90C194F | CABLETRAYALUMINUM60C140F | CABLETRAYALUMINUM70C167F | CABLETRAYALUMINUM90C194F | Lookup Table
CONDUIT | COPPER | 60°C (140°F) | TW | RHW | TBS | TW | RHW | TBS | TW | RHW | TBS | TW | RHW | TBS | CONDUITCOPPER60°C (140°F) | CONDUITCOPPER60C140F
CABLE TRAY | ALUMINUM | 70°C (167°F) | UF | THHW | SA | UF | THHW | SA | UF | THHW | SA | UF | THHW | SA | CONDUITCOPPER70°C (167°F) | CONDUITCOPPER70C167F
 |  | 90°C (194°F) | - | THW | SIS |  | THW | SIS |  | THW | SIS |  | THW | SIS | CONDUITCOPPER90°C (194°F) | CONDUITCOPPER90C194F
 |  |  | - | THWN | FEP |  | THWN | THHN |  | THWN | FEP |  | THWN | THHN | CONDUITALUMINUM60°C (140°F) | CONDUITALUMINUM60C140F
 |  |  | - | XHHW | FEPB |  | XHHW | THHW |  | XHHW | FEPB |  | XHHW | THHW | CONDUITALUMINUM70°C (167°F) | CONDUITALUMINUM70C167F
 |  |  | - | USE | MI |  | USE | THW-2 |  | ZW | MI |  |  | THW-2 | CONDUITALUMINUM90°C (194°F) | CONDUITALUMINUM90C194F
 |  |  |  | ZW | RHH |  |  | THWN-2 |  |  | RHH |  |  | THWN-2 | CABLE TRAYCOPPER60°C (140°F) | CABLETRAYCOPPER60C140F
 |  |  |  |  | RHW-2 |  |  | RHH |  |  | RHW-2 |  |  | RHH | CABLE TRAYCOPPER70°C (167°F) | CABLETRAYCOPPER70C167F
 |  |  |  |  | THHN |  |  | RHW-2 |  |  | THHN |  |  | RHW-2 | CABLE TRAYCOPPER90°C (194°F) | CABLETRAYCOPPER90C194F
 |  |  |  |  | THHW |  |  | USE-2 |  |  | THHW |  |  | USE-2 | CABLE TRAYALUMINUM60°C (140°F) | CABLETRAYALUMINUM60C140F
 |  |  |  |  | THW-2 |  |  | XHH |  |  | THW-2 |  |  | XHH | CABLE TRAYALUMINUM70°C (167°F) | CABLETRAYALUMINUM70C167F
 |  |  |  |  | THWN-2 |  |  | XHHW |  |  | THWN-2 |  |  | XHHW | CABLE TRAYALUMINUM90°C (194°F) | CABLETRAYALUMINUM90C194F
 |  |  |  |  | USE-2 |  |  | XHHW-2 |  |  | USE-2 |  |  | XHHW-2
 |  |  |  |  | XHH |  |  | ZW-2 |  |  | XHH |  |  | ZW-2
 |  |  |  |  | XHHW |  |  |  |  |  | XHHW
 |  |  |  |  | XHHW-2 |  |  |  |  |  | XHHW-2
 |  |  |  |  | ZW-2 |  |  |  |  |  | ZW-2
Spreadsheet: 111072d1307559594-array-formula-based-on-cell-entry-internship_program_test
Sheet: Daily

Winter 2011 Internship Daily Recruitment Report |  |  |  |  |  |  | 2011-05-26 00:00:00
Office | Active Internships | # Spots | Sources used | Applied | Failed | Eligible | Refs | Passed Int. | Hold | Hired
Los Angeles | Marketing | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 1
Total |  | 0 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 1
Note: select all rows visible and select unhide to show all offices, active and inactive, before creating a new office row
Spreadsheet: 456651d1460984811-invert-list-of-ip-addresses-ip-invert-2-
Sheet: BEFORE

192.168.1.0
192.168.1.1
192.168.1.3
192.168.1.4
192.168.1.5
192.168.1.6
192.168.1.7
192.168.1.8
192.168.1.9
192.168.1.10
192.168.1.12
192.168.1.13
192.168.1.14
192.168.1.15
192.168.1.16
192.168.1.17
192.168.1.18
192.168.1.19
192.168.1.20
192.168.1.22
192.168.1.24
192.168.1.25
192.168.1.26
192.168.1.27
192.168.1.28
192.168.1.29
192.168.1.30
192.168.1.31
192.168.1.32
192.168.1.33
192.168.1.34
192.168.1.35
192.168.1.36
192.168.1.37
192.168.1.38
192.168.1.39
192.168.1.40
192.168.1.41
192.168.1.42
192.168.1.43
192.168.1.44
192.168.1.45
192.168.1.46
192.168.1.47
192.168.1.48
192.168.1.50
192.168.1.51
192.168.1.52
192.168.1.53
192.168.1.55
192.168.1.56
192.168.1.57
192.168.1.58
192.168.1.61
192.168.1.62
192.168.1.63
192.168.1.64
192.168.1.65
192.168.1.68
192.168.1.69
192.168.1.70
192.168.1.71
192.168.1.72
192.168.1.73
192.168.1.74
192.168.1.75
192.168.1.77
192.168.1.78
192.168.1.79
192.168.1.80
192.168.1.81
192.168.1.82
192.168.1.83
192.168.1.84
192.168.1.85
192.168.1.86
192.168.1.87
192.168.1.89
192.168.1.92
192.168.1.94
192.168.1.96
192.168.1.97
192.168.1.98
192.168.1.99
192.168.1.101
192.168.1.102
192.168.1.103
192.168.1.104
192.168.1.105
192.168.1.106
192.168.1.107
192.168.1.108
192.168.1.109
192.168.1.110
192.168.1.112
192.168.1.113
192.168.1.114
192.168.1.118
192.168.1.119
192.168.1.120
192.168.1.121
192.168.1.122
192.168.1.123
192.168.1.124
192.168.1.125
192.168.1.126
192.168.1.127
192.168.1.128
192.168.1.160
192.168.1.192
192.168.1.193
192.168.1.195
192.168.1.196
192.168.1.197
192.168.1.198
192.168.1.200
192.168.1.201
192.168.1.202
192.168.1.203
192.168.1.204
192.168.1.205
192.168.1.206
192.168.1.209
192.168.1.210
192.168.1.211
192.168.1.212
192.168.1.213
192.168.1.214
192.168.1.215
192.168.1.216
192.168.1.217
192.168.1.218
192.168.1.219
192.168.1.220
192.168.1.223
192.168.1.225
192.168.1.226
192.168.1.227
192.168.1.228
192.168.1.230
192.168.1.231
192.168.1.232
192.168.1.233
192.168.1.234
192.168.1.238
192.168.1.239
192.168.1.243
192.168.1.244
192.168.1.245
192.168.1.246
192.168.1.247
192.168.1.248
192.168.1.251
192.168.1.252
192.168.1.253
192.168.1.254
192.168.8.30
192.168.8.45
192.168.8.56
192.168.8.220
192.168.8.223
192.168.8.225
192.168.8.226
192.168.8.227
192.168.8.228
192.168.8.230
192.168.8.231
192.168.8.232
192.168.8.233
192.168.8.234
192.168.8.238
192.168.8.239
192.168.8.243
192.168.8.244
192.168.8.245
192.168.8.246
192.168.8.247
192.168.8.248
192.168.8.251
192.168.8.252
192.168.8.253
192.168.8.254
172.16.10.5
172.16.10.6
172.16.10.7
10.0.0.5
10.0.0.6
10.0.0.8
10.0.0.10
10.0.0.11
10.0.0.12
10.0.0.13
10.0.0.14
Spreadsheet: 723666d1615826133-how-to-return-multiple-column-headers-based-on-a-difference-column-headers-based-on-differences-in-values-jayidhh-
Sheet: Week 1

 | Balance Of Remuneration | [NAME] | Family Leave | [NAME] | Irregular payment | Net Pay | q | Overtime 1.5 | Overtime 2.0 | Pay as you [NAME] | Performance bonus | Salary Cost | [NAME] | Skills Development Levy | r | Sunday Wage | Sundry Deduction | Total Company Contributions | Total Deductions | Total Earnings | Unemployment Insurance Fund | Unemployment Insurance Fund | Wage Hourly
 | Totals | Earning | Earning | Deduction | Earning | Totals | Deduction | Earning | Earning | Deduction | Earning | Totals | Earning | Company Contribution | Deduction | Earning | Deduction | Totals | Totals | Totals | Company Contribution | Deduction | Earning
Number 1 | 2021.55 | 0 | 0 | 0 | 0 | 1913.7 | 0 | 641.25 | 0 | 87.64 | 0 | 2061.98 | 0 | 20.22 | 0 | 240.3 | 0 | 40.43 | 107.85 | 2021.55 | 20.21 | 20.21 | 1140
Spreadsheet: 237499d1369233329-how-do-i-tie-a-column-to-a-pivot-table-z_examplefile
Sheet: Sheet11

Calculated Field
[NAME] | Field | [NAME]
1 | PromCrd | ='PC Passes'/'PC Calls'
2 | Comp | ='C Calls'/'C Passes'
3 | [NAME] | =EmailPass/EmailElig
4 | Cell | =CellPass/CellElig
5 | RecAsk | ='Rec Ask'/'Rec Elig'
6 | %$ | =(paidhours*Money)/(paidhours*ABSPaidHourGoal)
7 | rec | =Recur/Transac
8 | Avail | =TotNet/Totavail
9 | Unact | =Unacc/Totavail
10 | wrp | =Wrap/Logged
11 | ht | ='Total Time'/'IB Calls'
12 | Uncont | =Uncon/Totavail
Calculated Item
[NAME] | Item | [NAME]
Note: | When a cell is updated by more than one formula,
 | the value is set by the formula with the last solve order.
 | To change the solve order for multiple calculated items or fields,
 | on the Options tab, in the [NAME] group, click [NAME], and then click [NAME].
Spreadsheet: 158855d1338410020-results-summarizing-across-multiple-sheets-copy-of-guest-comments-card
Sheet: Optimus Summary

Aquarius Lunch | Very Satisfied | Satisfied | Dissatisfied | Does not Apply
Table reservation handling | 2
Table service |  | 2
Variety of food and beverage menu |  | 1 | 1
Server's knowledge of menu selection |  |  | 2
Quality and presentation of food | 1 | 1
Portion size of food | 1 |  | 1
Quality and presentation of beverage |  | 1 |  | 1
Restaurant atmosphere | 1 | 1
[NAME] handling |  |  | 2
Aquarius Dinner | Very Satisfied | Satisfied | Dissatisfied | Does not Apply
Table reservation handling | 1 |  |  | 1
Table service |  | 1 | 1
Variety of food and beverage menu | 1 |  | 1
Server's knowledge of menu selection |  | 2
Quality and presentation of food | 1 | 1
Portion size of food | 1 |  | 1
Quality and presentation of beverage |  | 1 |  | 1
Restaurant atmosphere |  | 1 | 1
[NAME] handling | 2
[NAME] Dinner | Very Satisfied | Satisfied | Dissatisfied | Does not Apply
Table reservation handling
Table service
Variety of food and beverage menu
Server's knowledge of menu selection
Quality and presentation of food
Portion size of food
Quality and presentation of beverage
Restaurant atmosphere
[NAME] handling
Spreadsheet: 765941d1643683748-pulling-dates-automatically-if-criteria-matches-finding-the-greatest-number-of-matches-between-a-one-and-two-dimensional-array-patcheen-
Sheet: cross check

 |  |  |  |  |  |  |  | Numbers drawn |  |  |  |  |  |  | Ive input dates manually to get required result | pulling dates automatically if criteria matches (excelforum.com)
 | Num 1 | Num 2 | Num 3 | Num 4 | Num 5 | Num 6 |  | 1 | 2 | 3 | 4 | 5 | 6
 | 1 | 2 | 3 | 4 | 5 | 6
 | 1 | 2 | 3 | 4 | 5 | 13 |  |  |  |  |  |  |  |  |  | Q3 is fine please don’t do anything to this
 | 1 | 2 | 3 | 4
 | 1 | 2 | 3
 | 1 | 2
 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | How do I get dates to populate automatcially between p3:p8?
Spreadsheet: 855058d1704781852-need-help-with-formulas-to-return-name-from-roster-on-calendar-resource-tracker-aligw
Sheet: Sep

 |  |  |  |  |  | CALENDAR MONTH | SEPTEMBER
 |  |  |  |  |  | CALENDAR YEAR
 |  |  |  |  |  | 1ST DAY OF WEEK | MONDAY
daily notes
daily notes
daily notes
daily notes
daily notes
 |  |  | Notes
daily notes
Spreadsheet: 718648d1613253591-count-unique-values-on-concurrent-dates-based-on-a-criteria-table-sample
Sheet: Sheet1

Date | Customer | Country
2021-02-13 00:00:00 | customer 1 | United States
2021-02-13 00:00:00 | customer 2 | Nigeria
2021-02-13 00:00:00 | customer 3 | Kenya
2021-02-13 00:00:00 | customer 4 | Netherlands
2021-02-13 00:00:00 | customer 5 | Canada
2021-02-13 00:00:00 | customer 6 | United States
2021-02-13 00:00:00 | customer 7 | United States
2021-02-13 00:00:00 | customer 8 | United Arab Emirates
2021-02-13 00:00:00 | customer 9 | Nigeria
2021-02-13 00:00:00 | customer 1 | United States
2021-02-13 00:00:00 | customer 10 | Portugal
2021-02-13 00:00:00 | customer 2 | Nigeria
2021-02-13 00:00:00 | customer 11 | Poland
2021-02-13 00:00:00 | customer 12 | Netherlands
2021-02-13 00:00:00 | customer 2 | Nigeria
2021-02-13 00:00:00 | customer 13 | Mexico
2021-02-13 00:00:00 | customer10 | Portugal
2021-02-13 00:00:00 | customer 14 | Kenya
2021-02-14 00:00:00 | customer 15 | Denmark
2021-02-14 00:00:00 | customer 16 | Brazil
2021-02-14 00:00:00 | customer 4 | Netherlands
2021-02-14 00:00:00 | customer 17 | Argentina
2021-02-14 00:00:00 | customer 2 | Nigeria
2021-02-14 00:00:00 | customer 18 | India
2021-02-14 00:00:00 | customer 3 | Kenya
2021-02-14 00:00:00 | customer 4 | Netherlands
2021-02-14 00:00:00 | customer 19 | Netherlands
2021-02-14 00:00:00 | customer 20 | Australia
2021-02-14 00:00:00 | customer 4 | Netherlands
2021-02-14 00:00:00 | customer 2 | Nigeria
2021-02-14 00:00:00 | customer 21 | Ukraine
2021-02-14 00:00:00 | customer 22 | Egypt
2021-02-14 00:00:00 | customer 23 | New Zealand
2021-02-14 00:00:00 | customer 24 | Greece
2021-02-14 00:00:00 | customer 25 | Peru
Spreadsheet: mary_fischer__25628__1473-2001
Sheet: E20.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
ANALYSIS OF OTHER INCOME AND DEDUCTIONS
FOR THE 6 MONTHS ENDED 6-30-2001
 |  |  |  |  |  |  |  |  |  | E-20
[NAME] |  | 1ST QTR |  | 2ND QTR |  | 3RD QTR |  | 4TH QTR |  | YEAR TO DATE
OTHER INCOME - OTHER
(PROVIDE DETAIL OF INDIVIDUAL ITEMS
IN EXCESS OF $200,000.)
Contribution in aid of construction |  | 2470
Total Other Income - Other
(MUST TIE TO HYPERION ACCOUNT 1690)
Income Accts:  DR/(CR)
Reverse signs from Hyperion
[NAME] |  | 1ST QTR |  | 2ND QTR |  | 3RD QTR |  | 4TH QTR |  | YEAR TO DATE
OTHER DEDUCTIONS - OTHER
(PROVIDE DETAIL OF INDIVIDUAL ITEMS
IN EXCESS OF $200,000.)
Total Other Deductions - Other
(MUST TIE TO HYPERION ACCOUNT 1775)
Asset/Expense Accts:  DR/(CR)
Same signs as Hyperion
 |  |  |  |  |  |  |  |  |  | E-20
Spreadsheet: 886602d1736654836-count-if-function-should-be-count-value-of-charactor-as-a-half-salary-nirman22-1-
Sheet: Before

SN |  | 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 | Full  Day | W/O | Leave | Total
1 | Deepak Gote | p | p | w | p | p | h | p | p | p | p | l | l | p | p | l | p | w | p | p | p | p | p | p | w | p | p | p | p | p | p | w |  | 5
2 | Atul Shinde | p | l | p | p | w | p | l | w | p | l | h | w | p | l | w | h | p | p | w | p | p | p | p | p | p | p | p | p | p | p | p |  | 5
3 | [NAME] | p | l | p | p | w | h | p | w | p | p | h | w | p | p | w | p | p | h | w | p | h | p | p | p | l | p | p | p | p | p | p |  | 5
4
5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 26
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
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
Spreadsheet: a58c1424-d152-408d-9fb4-3bf25c3f0ae7
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
FECRU | Test | FECRU | Iron/Creatinine Ratio, Random, [NAME] | Iron/Creat Ratio, Random, U | FECR: Inductively Coupled Plasma-Optical Emission Spectrometry (ICP-OES) CDCR: 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 a 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 gadolinium and iodine are known to interfere with most metals tests. If either gadolinium- or iodine-containing contrast media has been administered, a specimen should not be collected for 96 hours. | 0.8 mL | Hemolysis	NA Thawing	Warm Reject; Cold OK Lipemia	NA Icterus	NA Other	NA | > or =16 years: 100-300 mcg/g Creatinine Reference values have not been established for patients that are <16 years of age. | Wednesday, Friday; 5 p.m. | 1 day | 5 days |  | Profile |  |  |  |  | Rochester
FECRU | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 7 days
FECRU | Component | FECR | Iron/Creatinine Ratio, [NAME] | Iron/Creat Ratio, U | Only orderable as part of a profile. For further information see #60764 Iron/Creatinine Ratio, [NAME] |  |  |  |  |  | Only orderable as part of a profile. For further information see #60764 Iron/Creatinine Ratio, [NAME] |  |  | Only orderable as part of a profile. For further information see #60764 Iron/Creatinine Ratio, [NAME] |  |  |  | 1 | 83540 |  |  | Yes | No
FECR | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 7 days
FECR | Result | 32878 | Iron/Creat Ratio, U | Iron/Creat Ratio, U | Numeric |  |  |  |  | mcg/g |  |  |  |  |  |  |  |  |  | In Process
FECR | Result | 32893 | Fe Concentration | Fe Concentration | Numeric |  |  |  |  | mcg/L |  |  |  |  |  |  |  |  |  | In Process
FECRU | Component | CDCR | [NAME] | [NAME] | Only orderable as part of a profile. For further information see CTU / Creatinine, [NAME]. |  |  |  | 5 | mL | Only orderable as part of a profile. For further information see CTU / Creatinine, [NAME]. |  |  |  |  |  |  |  |  |  |  | Yes | No
CDCR | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 30 days
CDCR | Result | CDCR | [NAME] | [NAME] | Numeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | 35674-1 | Creatinine:MCnc:XXX:[NAME]:Qn:
Spreadsheet: 825442d1681316217-if-e4-y-copy-data-from-sheet-2-to-sheet-3-test-drawing-list-setup
Sheet: Instructions

DESIGN SCOPE OF SERVICES AND [NAME]
***This is a template only and requires input from all Project Managers to ensure the scope and deliverables being proposed are relevant and specific for the project requirements***
Instructions
1 | Refer to the Design Scope Tabs in turn.
2 | Project Meetings: Review project programme & BEP to enable you to specify sufficient number of meetings.
3 | Populate the X cells under each stage with the proposed number of meetings for the project.
4 | Design Element: Ensure OOBE are taking responsbility for all of the items listed with Y in the Responsibility column.
5 | Make changes to the Responsibility column as necessary using the options at the top of the sheet.
6 | Refer to the [NAME] (Drawings) tab
7 | Ensure OOBE are taking responsbility for all of the items listed with Y in the Included column
8 | Make changes to the Responsibility column as necessary using the options at the top of the sheet.
9 | Ensure that all deliverables required and relevant for each workstage are highlighted with a green fill and a bold dot in the cell
10 | Ensure those deliverables not required have a blank cell
11 | Ensure all Output Formats and the suggested scales are correct and relevant for the requirements of the project - only update if absolutely necessary and with the approval of a Director
12 | Refer to the [NAME] (Docs&other) tab
13 | Ensure OOBE are taking responsbility for all of the items listed with Y in the Included column
14 | Make changes to the Responsibility column as necessary using the options at the top of the sheet.
15 | Ensure that all deliverables required and relevant for each workstage are highlighted with a green fill and a bold dot in the cell
16 | Ensure those deliverables not required have a blank cell
17 | Ensure all Output Formats are correct and relevant for the requirements of the project - only update if absolutely necessary and with the approval of a Director
18 | Refer to the Deliverables (Model) tab
19 | Ensure OOBE are taking responsbility for all of the items listed with Y in the Included column
20 | Model Element: Ensure OOBE are taking responsbility for all of the items listed with Y in the Responsibility column.
21 | Make changes to the Responsibility column as necessary using the options at the top of the sheet.
22 | Make changes to the Responsibility column as necessary using the options at the top of the sheet.
23 | Print each Tab to A4 portrait using the current print settings - there should be no need to scale the schedules
24 | Combine the PDFs into one file in the order of the tabs
25 | Combine this with the proposal document / fee letter being issued as an Appendix
Notes
1 | The current options shown in this documents are based on typical projects, this may be different for this project - please ensure it is relevant for the project
2 | Do not change the list of Items unless absolutely necessary and with the approval of a Director
3 | Do not change the list of Comments/Inclusions/Exclusions unless absolutely necessary and with the approval of a Director
Spreadsheet: 264069d1378764562-complex-vacation-accural-formula-script-needed-vacation-master-log-4-
Sheet: Allocations

Employee | Hire Date | Years at Company | Number of Vacation Days  This Year | Number of Weeks This Year | email | Holiday year start | Requested | Remaining | 2014-02-24 00:00:00 | Comparison Date Ctrl + ; = today
A Daza | 2005-11-11 00:00:00 |  |  |  | [EMAIL]
A [NAME] | 2006-12-01 00:00:00 |  |  |  | [EMAIL]
B Ghazi | 2012-10-29 00:00:00 |  |  |  | [EMAIL]
B [NAME] | 2012-11-05 00:00:00 |  |  |  | [EMAIL]
D King | 2012-01-12 00:00:00 |  |  |  | [NAME]
D Kosen | 1994-04-01 00:00:00 |  |  |  | [EMAIL]
[NAME] | 2012-05-14 00:00:00 |  |  |  | [EMAIL]
J [NAME] | 2013-01-07 00:00:00 |  |  |  | [EMAIL]
[NAME] | 2013-02-25 00:00:00 |  |  |  | [NAME]
L Farris | 2012-01-09 00:00:00 |  |  |  | [EMAIL]
P Soh | 1996-06-01 00:00:00 |  |  |  | [EMAIL]
P [NAME] | 2011-07-11 00:00:00 |  |  |  | [EMAIL]
S Wachtel | 1997-03-01 00:00:00 |  |  |  | [EMAIL]
T Ghazalie | 1995-07-01 00:00:00 |  |  |  | [EMAIL]
T Newton | 2008-05-19 00:00:00 |  |  |  | [EMAIL]
T Santoso | 2003-10-01 00:00:00 |  |  |  | [EMAIL]
I [NAME] | 2009-10-03 00:00:00 |  |  |  | [EMAIL]
A | 2005-09-11 00:00:00 |  |  |  | [EMAIL]
bob | 2013-02-25 00:00:00 |  |  |  | [EMAIL]
Spreadsheet: 811044d1672244637-count-distinct-values-based-on-values-in-another-column-problem-example2
Sheet: Sheet1

 |  |  |  | Total count of fruit varieties in D (method A)
 |  |  |  | Total count of fruit varieties in D (method B)
 |  |  |  | How many varieties of Green coloured fruit?
 |  |  | Apple | Green
 |  |  | Apple | Green
 |  |  |  | Green
 |  |  | Apple | Green
 |  |  | Pear | Green
 |  |  | [NAME] | Yellow
 |  |  | [NAME] | Yellow
 |  |  | [NAME] | Yellow
Spreadsheet: 221291d1363456343-if-value-found-in-column-then-adjacent-cell-in-values-row-example-visits
Sheet: EXAMPLE VISITS

CITY | SIGHTS | DATE |  | CITIES | FREQUENCY | VISIT ONE | VISIT TWO | VISIT THREE
DALLAS |  | 2013-01-08 00:00:00 |  | DALLAS
DENVER |  | 2013-01-10 00:00:00 |  | DENVER
HOUSTON |  | 2013-01-15 00:00:00 |  | HOUSTON
LOS ANGELES |  | 2013-01-17 00:00:00 |  | LOS ANGELES
DALLAS |  | 2013-03-16 00:00:00
LOS ANGELES |  | 2013-03-16 00:00:00
Spreadsheet: cd5678b3-bb89-4d74-b126-af65221c3a06
Sheet: Basic Science

Dept No. | Department Name | Manager | Phone | Manager [NAME] | Manager [NAME] | Chair/Dean/Director | Phone | Chair Email | Department Address | Division
4204 | Cell Biology & Physiology | [NAME] (interim) | 966-1252 | [EMAIL] | [NAME] | [NAME] | 966-5215 | [EMAIL] | 5200 MBRB | Basic
4208 | Microbiology & Immunology | [NAME] | 966-3900 | [EMAIL] | [NAME] | [NAME] | 966-9580 | [EMAIL] | 804 [NAME] Building | Basic
4212 | Biochemistry | [NAME] | 843-9987 | [EMAIL] | [NAME] | [NAME] | 843-6894 | [EMAIL] | 3010 Genetic Medicine Building | Basic
4216 | Pathology | [NAME] | 966-4676 | [EMAIL] | [NAME] | [NAME] | 966-4676 | [EMAIL] | 301 Brinkhous Bullitt Building | Clinical
4218 | Genetics | [NAME] | 843-3549 | [EMAIL] | [NAME] | [NAME] | 843-6475 | [EMAIL] | Genetic Medicine Building, Fifth Floor | Basic
4220 | Pharmacology | [NAME] (interim) | 966-6849 | [EMAIL] | [NAME] | [NAME] | 843-3107 | [EMAIL] | 4009 Genetic Medicine Building | Basic
4275 | Biomedical Engineering | [NAME][NAME] | 966-[PHONE] | [EMAIL] [EMAIL] | [NAME] | [NAME] | 966-2291 | [EMAIL] | 152 MacNider Hall | Basic
4290 | Social Medicine | [NAME] | 843-8263 | [EMAIL] | [NAME] | [NAME] | 843-8268 | [EMAIL] | 348 MacNider Hall | Ctr/Prgm
Spreadsheet: 713387d1610688712-tat-with-time-time-tat-calculation
Sheet: Explanation With Output

Ref Number | Start Date | End Date | Time TAT |  |  |  |  |  |  | [NAME] number | MAX of group for ref number | MIN of group for ref number | Sum of ref number
2021-420800 | 2021-01-02 12:31:00 | 2021-01-02 12:32:00
2021-420623 | 2021-01-02 10:23:00 | 2021-01-02 10:28:00 |  | Which is greater take that and minus from smaller |  |  |  |  |  | 2021-420623
2021-421781 | 2021-01-03 12:29:00 | 2021-01-03 12:36:00 |  |  |  |  |  |  |  | 2021-421781
2021-421781 | 2021-01-03 17:53:00 | 2021-01-03 17:53:00 |  | Which is greater take that and minus from smaller |  |  |  |  |  | 2020-398759
2020-398759 | 2020-12-09 00:00:00 | 2021-01-11 08:46:00 |  |  |  |  |  |  |  | 2021-421701
2020-398759 | 2020-12-09 00:00:00 | 2021-01-11 08:47:00 |  |  |  |  |  |  |  | 2021-3344
2021-421701 | 2021-01-03 11:31:00 | 2021-01-03 11:40:00
2021-421701 | 2021-01-03 12:03:00 | 2021-01-03 12:04:00
2021-421701 | 2021-01-03 12:07:00 | 2021-01-03 12:15:00
2021-421701 | 2021-01-03 00:00:00 | 2021-01-03 12:23:00 |  | Which is greater take that and minus from smaller
2021-3344 | 2021-01-06 20:15:00 | 2021-01-06 20:21:00
2021-3344 | 2021-01-06 21:36:00 | 2021-01-06 21:37:00
2021-3344 | 2021-01-09 20:21:00 | 2021-01-09 20:23:00
2021-3344 | 2021-01-09 20:56:00 | 2021-01-09 20:58:00
2021-3344 | 2021-01-09 21:11:00 | 2021-01-09 21:17:00