tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 0cc80a85-cebe-4977-bf4c-57eae654b701
Sheet: Sheet1

Permit No.: | Unnamed: 1 | Unnamed: 2 | WQ0028860 | Unnamed: 4 | Unnamed: 5 | Facility Name: | Unnamed: 7 | American Soil and Mulch | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | County: | Wake | Unnamed: 16 | Month: | Unnamed: 18 | Unnamed: 19 | Year: | Unnamed: 21
Did irrigation occur    at this facility? |  |  |  |  |  | Field Name: |  | 1 |  | Field Name: |  |  |  | Field Name: |  |  |  | Field Name:
 |  |  |  |  |  | Area (acres): |  | 0.1 |  | Area (acres): |  |  |  | Area (acres): |  |  |  | Area (acres):
 |  |  |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop: |  |  |  | Cover Crop:
 |  |  |  |  |  | [NAME] (in): |  | 0.3 |  | [NAME] (in): |  |  |  | [NAME] (in): |  |  |  | [NAME] (in):
 |  |  |  |  |  | Annual Rate (in): |  | 22.48 |  | Annual Rate (in): |  |  |  | Annual Rate (in): |  |  |  | Annual Rate (in):
Day | Weather |  |  | Freeboard |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated? |  |  |  | Field Irrigated?
 | Weather Code | Temperature | Precipitation | Storage | 5-Day Upset (if applicable) | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time    Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading | Volume Applied | Time   Irrigated | Daily   Loading | Maximum Hourly Loading
 |  | ºF | in | ft | ft | gal | min | in | in | gal | min | in | in | gal | min | in | in | gal | min | in | in
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
Monthly Loading:
12 Month Floating Total (in):
Spreadsheet: 744849b9-211f-4195-a17a-9179e1741123
Sheet: Sheet1

Permit No.: | Unnamed: 1 | WQ0011928 | Unnamed: 3 | Facility Name: | Unnamed: 5 | Olde Sycamore WWTP | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | County: | Union | Unnamed: 13 | Month: | Unnamed: 15 | Unnamed: 16 | Year: | Unnamed: 18
PPI: |  | 001 | Flow Measuring Point: |  |  |  |  |  |  | Parameter Monitoring Point:
Parameter Code |  |  | 50050
Day | ORC Arrival Time | ORC Time On Site | Flow
 | 24-hr | hrs | GPD
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
Average:
Daily Maximum:
Daily Minimum:
Sampling Type: |  |  | Recorder
Monthly Limit: |  |  | 150000
Daily Limit:
Sample Frequency: |  |  | [NAME]
 |  | Average
 |  | Geomean
 |  | MAX/MIN
Spreadsheet: 1a6b7115-d671-4bb8-9cac-8437ac53f83c
Sheet: Sheet1

SUMMARY BY COUNTIES - DEMOCRATIC - Vice President | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Write-In Votes | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
2008-01-08 00:00:00 | Biden, d | [NAME], d | [NAME], d | Edwards, d | Gravel, d | [NAME], d | [NAME], d | Obama, d | [NAME], d | Barnes, r | [NAME], r
Belknap County | 72 | 192 | 12 | 587 | 2 | 2 | 41 | 351 | 269 | 0 | 2
Carroll County | 71 | 135 | 14 | 476 | 6 | 1 | 49 | 300 | 325 | 0 | 0
Cheshire County | 95 | 283 | 24 | 871 | 10 | 1 | 110 | 489 | 492 | 1 | 4
Coos County | 26 | 104 | 11 | 324 | 5 | 1 | 11 | 181 | 134 | 0 | 4
Grafton County | 126 | 282 | 17 | 864 | 14 | 2 | 82 | 555 | 524 | 0 | 6
Hillsborough County | 380 | 794 | 48 | 2427 | 11 | 3 | 161 | 1533 | 1215 | 3 | 9
Merrimack County | 154 | 414 | 25 | 1445 | 11 | 2 | 61 | 792 | 876 | 25 | 6
Rockingham County | 370 | 721 | 45 | 2061 | 22 | 3 | 120 | 1237 | 979 | 26 | 6
Strafford County | 149 | 322 | 20 | 990 | 9 | 4 | 84 | 655 | 488 | 2 | 4
Sullivan County | 69 | 172 | 8 | 488 | 1 | 1 | 43 | 309 | 223 | 2 | 5
Total | 1512 | 3419 | 224 | 10533 | 91 | 20 | 762 | 6402 | 5525 | 59 | 46
2008-01-08 00:00:00 | Huckabee, r | [NAME], r | [NAME], r | [NAME], r | Romney, r | Thompson, r | [NAME] | [NAME] | [NAME] | Other
Belknap County | 3 | 0 | 12 | 10 | 2 | 0 | 35 | 15 | 4 | 124
Carroll County | 4 | 0 | 8 | 10 | 0 | 0 | 37 | 15 | 4 | 146
Cheshire County | 6 | 1 | 22 | 17 | 4 | 0 | 62 | 32 | 2 | 197
Coos County | 2 | 1 | 10 | 5 | 0 | 1 | 15 | 16 | 2 | 37
Grafton County | 8 | 1 | 37 | 10 | 4 | 7 | 88 | 24 | 3 | 415
Hillsborough County | 18 | 4 | 88 | 48 | 22 | 5 | 284 | 90 | 14 | 1050
Merrimack County | 3 | 0 | 26 | 18 | 3 | 0 | 160 | 41 | 6 | 379
Rockingham County | 8 | 2 | 51 | 31 | 17 | 1 | 177 | 92 | 19 | 646
Strafford County | 4 | 2 | 24 | 13 | 7 | 0 | 89 | 39 | 7 | 306
Sullivan County | 7 | 0 | 15 | 14 | 7 | 0 | 19 | 24 | 6 | 107
Total | 63 | 11 | 293 | 176 | 66 | 14 | 966 | 388 | 67 | 3407
Candidates receiving 10 votes or less statewide:  [NAME], d, 10: [NAME], d, 1: [NAME], d, 2: [NAME], d, 1: Savior, d, 3: Fendig, Jr., d, 1: [NAME], r, 4: Supreme, r, 7: Tancredo, r, 2
Spreadsheet: 53420d1253295210-conditional-format-for-entire-row-upon-value-change-excel-forum-cf-on-value-change
Sheet: Sheet1

1
1
1
1
2
2
2
2
2
3
3
3
3
3
3
3
4
4
4
4
4
4
4
4
4
4
4
4
4
4
5
5
5
5
6
6
6
6
6
7
7
7
7
9
conditional format for entire row upon value change - Excel Help Forum
Spreadsheet: 60130d1260663277-vlookup-scheduletemplate4
Sheet: Lineup

Station | Day Shift Name | MGR Initials | Station | Night Shift Name | MGR Initials
1045 |  |  | 400
1100
 |  |  | 430
1130
 |  |  | 500
1200
 |  |  | 600
Cocktail |  |  | Cocktail
1 |  |  | 1
2 |  |  | 2
3 |  |  | 3
Patio |  |  | Patio
1 |  |  | 1
2 |  |  | 2
3 |  |  | 3
Reserve |  |  | Reserve
1 |  |  | 1
2 |  |  | 2
3 |  |  | 3
EXPO |  |  | EXPO
Run |  |  | Run
Run |  |  | Run
BAR |  |  | BAR
1 |  |  | 1
2 |  |  | 2
Spreadsheet: 8fd37488-9570-474c-a259-8494c40cfcb0
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
BABG | Test | BABG | Babesia microti IgG Antibodies, Serum | Babesia microti IgG Ab, S | Immunofluorescence Assay (IFA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL | 0.15 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	Mild OK; Gross reject Icterus	NA Other	NA | <1:64 | Monday through Friday; 9 a.m. | Same day/1 day | 3 days | 1 | 86753 |  |  |  |  | Rochester
BABG | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
BABG | Result | 81128 | Babesia microti IgG Ab, S | Babesia microti IgG Ab, S | Alphanumeric |  |  |  |  | titer |  |  |  |  |  |  |  |  |  | 16117-4 | Babesia microti Ab.[NAME]:Titr:Pt:Ser:Qn:
Spreadsheet: 692143d1598113612-formula-to-calculate-the-time-esclation_incident
Sheet: Sheet1

Esclation time | Incident time | Incident day | Incident Remark | Working Time
2020-01-01 09:41:00 | 2020-01-01 00:00:00 | Wed |  | 2020-01-01 07:30:00
2020-01-05 13:44:00 | 2020-01-03 17:00:00 | Fri | Weekend | 2020-01-05 07:30:00
2020-01-06 08:33:00 | 2020-01-03 17:00:00 | Fri | Weekend | 2020-01-06 07:30:00
2020-02-24 10:58:00 | 2020-02-23 12:00:00 | Sun |  | 2020-02-24 07:30:00
2020-02-25 10:06:00 | 2020-02-25 00:00:00 | Tue |  | 2020-02-25 07:30:00
2020-02-26 08:27:00 | 2020-02-24 12:00:00 | Mon |  | 2020-02-26 07:30:00
2020-03-03 08:19:00 | 2020-03-02 15:00:00 | Mon |  | 2020-03-03 07:30:00
2020-03-08 13:31:00 | 2020-03-05 14:00:00 | Thu | [NAME] | 2020-03-08 07:30:00
2020-03-15 08:33:00 | 2020-03-14 14:00:00 | Sat | Weekend | 2020-03-15 07:30:00
2020-03-16 14:19:00 | 2020-03-16 10:00:00 | Mon |  | 2020-03-16 07:30:00
2020-03-24 16:22:00 | 2020-03-24 10:00:00 | Tue |  | 2020-03-24 07:30:00
2020-03-26 08:28:00 | 2020-03-25 18:00:00 | Wed |  | 2020-03-26 07:30:00
2020-03-30 15:28:00 | 2020-03-30 12:00:00 | Mon |  | 2020-03-30 07:30:00
2020-06-24 08:47:00 | 2020-06-23 18:00:00 | Tue |  | 2020-06-24 07:30:00
2020-06-25 15:34:00 | 2020-06-25 14:00:00 | Thu |  | 2020-06-25 07:30:00
2020-06-28 15:46:00 | 2020-06-28 12:00:00 | Sun |  | 2020-06-28 07:30:00
2020-07-02 08:48:00 | 2020-07-01 15:00:00 | Wed |  | 2020-07-02 07:30:00
2020-07-02 09:48:00 | 2020-07-01 23:00:00 | Wed |  | 2020-07-02 07:30:00
2020-07-06 09:38:00 | 2020-07-05 21:00:00 | Sun | [NAME] | 2020-07-06 07:30:00
2020-07-07 16:01:00 | 2020-07-07 10:00:00 | Tue |  | 2020-07-07 07:30:00
2020-07-08 17:25:00 | 2020-07-08 15:00:00 | Wed |  | 2020-07-08 07:30:00
2020-07-12 08:57:00 | 2020-07-11 17:00:00 | Sat | Weekend | 2020-07-12 07:30:00
2020-07-13 15:51:00 | 2020-07-13 10:00:00 | Mon |  | 2020-07-13 07:30:00
2020-07-16 09:24:00 | 2020-07-15 15:00:00 | Wed |  | 2020-07-16 07:30:00
2020-07-28 08:36:00 | 2020-07-20 03:00:00 | Mon |  | 2020-07-28 07:30:00
2020-07-28 08:36:00 | 2020-07-28 02:00:00 | Tue |  | 2020-07-28 07:30:00
Spreadsheet: 004195ad-cc1e-405c-a13d-6476916a6ff2
Sheet: Sheet1

[NAME] Advanced Research Program - 2013
Institution Selection - Maximum Number of Pre-proposals Going Forward
Directions:  Return a list of project numbers of pre-proposals that will go forward for review.  The number of pre-proposals in the list should match the number in the right-most column for your institution. Email the list to [EMAIL].  Please return the list by close of business November 21, 2013.
 | Institution | Submitted Pre-proposals: Basic Research in Biomedicine | Submitted Pre-proposals: Basic Research in Energy and the Environment | Total Submitted Pre-proposals | Proportional Share | Reallocation Based on Proportional Share | Number of Calculated Limit for Institution
1 | Baylor College of Medicine | 9 | 0 | 9
2 | Baylor University | 3 | 5 | 8
3 | Lamar University | 1 | 1 | 2
4 | Prairie View A&M University | 1 | 0 | 1
5 | Rice University | 3 | 2 | 5
6 | Southern Methodist University | 2 | 1 | 3
7 | Southwestern University | 0 | 1 | 1
8 | St. Edward's University | 1 | 0 | 1
9 | Tarleton State University | 1 | 1 | 2
10 | Texas A&M AgriLife Research | 8 | 1 | 9
11 | Texas A&M Engineering Experiment Station | 1 | 7 | 8
12 | Texas A&M Health Science Center | 2 | 0 | 2
13 | Texas A&M International University | 1 | 1 | 2
14 | Texas A&M University | 3 | 1 | 4
15 | Texas A&M University - Corpus Christi | 2 | 2 | 4
16 | Texas A&M University - Kingsville | 1 | 2 | 3
17 | Texas A&M University-Commerce | 2 | 1 | 3
18 | Texas Christian University | 1 | 0 | 1
19 | Texas College | 1 | 0 | 1
20 | Texas Southern University | 2 | 2 | 4
21 | Texas State University | 2 | 4 | 6
22 | Texas Tech University | 3 | 11 | 14
23 | Texas Tech University Health Sciences Center | 2 | 0 | 2
24 | Texas Woman's University | 1 | 0 | 1
25 | The University of Texas - Pan American | 0 | 2 | 2
26 | The University of Texas at Arlington | 5 | 13 | 18
27 | The University of Texas at Austin | 9 | 10 | 19
28 | The University of Texas at Dallas | 3 | 3 | 6
29 | The University of Texas at El Paso | 4 | 12 | 16
30 | The University of Texas at San Antonio | 5 | 6 | 11
31 | The University of Texas at Tyler | 0 | 1 | 1
32 | The University of Texas Health Science Center at Houston | 1 | 0 | 1
33 | The University of Texas Health Science Center at San Antonio | 11 | 0 | 11
34 | The University of Texas Medical Branch at Galveston | 3 | 0 | 3
35 | The University of Texas Southwestern Medical Center | 11 | 0 | 11
36 | University of Houston | 11 | 13 | 24
37 | University of Houston - Clear Lake | 0 | 1 | 1
38 | University of Houston - Downtown | 1 | 1 | 2
39 | University of North Texas | 1 | 5 | 6
40 | University of North Texas Health Science Center at Fort Worth | 6 | 0 | 6
41 | UT M.D. [NAME] | 20 | 0 | 20
42 | West Texas A&M University | 0 | 2 | 2
 | total
 | Prepared by: Texas Higher Education Coordinating Board, Workforce, Academic Affairs and Research, 11/4/2013 ([NAME])
Spreadsheet: 885240d1734683880-tracker-to-be-populated-the-data-based-on-frequency-count-frequency-tracker-jt-
Sheet: Sheet1

 |  | Frequency | Frequency Count | Start Month | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec |  | Try, in F5, copy down:
 |  | HY | 6 | Apr |  |  |  | HY |  |  |  |  |  | HY
 |  | HY | 6 | Jan |  |  |  |  |  |  | HY
 |  | Q | 3 | JUN |  |  |  |  |  | Q |  |  | Q |  |  | Q
 |  | M | 1 | Jan |  | M | M | M | M | M | M | M | M | M | M | M
 |  | Y | 12 | Jan
 |  |  |  | Repeat months |  | 10
 |  |  |  | Convert months to numbers |  | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
 |  |  |  | Check if match with repeat months |  | False | False | True | False | False | False | False | False | True | False | False
 |  |  |  | Combined formula |  |  |  | HY |  |  |  |  |  | HY
 |  | Expected Result
 |  | Frequency | Frequency Count | Start Month | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 |  | HY | 6 | Apr |  |  |  | HY |  |  |  |  |  | HY
 |  | HY | 6 | Jan | HY |  |  |  |  |  | HY
 |  | Q | 3 | Jun |  |  |  |  |  | Q |  |  | Q |  |  | Q
 |  | M | 12 | Jan | M | M | M | M | M | M | M | M | M | M | M | M
 |  | Y | 1 | Jan | Y
Spreadsheet: 594594d1539866671-campaign-plan-with-two-tabs-content-view-and-date-view-campaigns-2019-test
Sheet: Date View

Campaign | 2018-10-15 00:00:00 | 2018-10-22 00:00:00 | 2018-10-29 00:00:00 | 2018-11-05 00:00:00 | 2018-11-12 00:00:00 | 2018-11-19 00:00:00 | 2018-11-26 00:00:00 | 2018-12-03 00:00:00 | 2018-12-10 00:00:00 | 2018-12-17 00:00:00 | 2018-12-24 00:00:00 | 2018-12-31 00:00:00 | 2019-01-07 00:00:00 | 2019-01-14 00:00:00 | 2019-01-21 00:00:00 | 2019-01-28 00:00:00
Black Friday | Webpage |  |  | [NAME] | Newsletter |  | Event
120th Anniversary |  |  |  |  |  |  |  |  |  |  |  | Webpage |  | Newsletter
Christmas |  |  |  |  |  |  |  | [NAME] |  |  | Event
Spreadsheet: 9b2d17d5-e768-4aaf-9b41-a019e9c94fe9
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
MNCRU | Test | MNCRU | Manganese/Creatinine Ratio, Random, [NAME] | Manganese/Creat Ratio, Random, U | MNCR/32487: 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 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 OK; Cold OK Lipemia	NA Icterus	NA Other	NA | > or =16 years: 0.1-1.3 mcg/g creatinine Reference values have not been established for patients that are <16 years of age. | Tuesday, Thursday; 3 p.m. | 1 day | 5 days |  | Profile |  |  |  |  | Rochester
MNCRU | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 28 days
MNCRU | Component | [NAME] | Manganese/Creatinine Ratio, [NAME] | Manganese/Creat Ratio, U | Only orderable as part of a profile. For further information see #60027 Manganese/Creatinine Ratio, Random, [NAME] |  |  |  |  |  | Only orderable as part of a profile. For further information see #60027 Manganese/Creatinine Ratio, Random, [NAME] |  |  | Only orderable as part of a profile. For further information see #60027 Manganese/Creatinine Ratio, Random, [NAME] |  |  |  | 1 | 83785 |  |  | Yes | No
[NAME] | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 28 days
[NAME] | Result | 32867 | Manganese/Creat Ratio, U | Manganese/Creat Ratio, U | Numeric |  |  |  |  | mcg/g |  |  |  |  |  |  |  |  |  | In Process
[NAME] | Result | 32882 | Mn Concentration | Mn Concentration | Numeric |  |  |  |  | mcg/L |  |  |  |  |  |  |  |  |  | In Process
MNCRU | 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: 806437d1669301513-matching-notes-from-yesterdays-data-to-todays-newly-imported-data-example
Sheet: Yesterday

Inv | Date | Supplier | Cost | Notes
1 | 2022-11-20 00:00:00 | A Bloggs | 1 | Notes for invoice 1
2 | 2022-11-21 00:00:00 | B [NAME] | 2 | Notes for invoice 2
3 | 2022-11-22 00:00:00 | C [NAME] | 3 | Notes for invoice 3
4 | 2022-11-23 00:00:00 | D Bloggs | 4 | Notes for invoice 4
5 | 2022-11-24 00:00:00 | E Bloggs | 5 | Notes for invoice 5
6 | 2022-11-25 00:00:00 | f Bloggs | 6 | Notes for invoice 6
7 | 2022-11-26 00:00:00 | G Bloggs | 7 | Notes for invoice 7
8 | 2022-11-27 00:00:00 | H Bloggs | 8 | Notes for invoice 8
9 | 2022-11-28 00:00:00 | I [NAME] | 9 | Notes for invoice 9
10 | 2022-11-29 00:00:00 | J Bloggs | 10 | Notes for invoice 10
Spreadsheet: 795944d1663013431-counting-cells-with-specific-text-and-on-certain-date-example
Sheet: Sheet1

Month | 1 | Count | 2022-01-01 00:00:00 | 2022-01-02 00:00:00 | 2022-01-03 00:00:00 | 2022-01-04 00:00:00 | 2022-01-05 00:00:00 | 2022-01-06 00:00:00 | 2022-01-07 00:00:00 | 2022-01-08 00:00:00 | 2022-01-09 00:00:00 | 2022-01-10 00:00:00 | 2022-01-11 00:00:00 | 2022-01-12 00:00:00 | 2022-01-13 00:00:00 | 2022-01-14 00:00:00 | 2022-01-15 00:00:00 | 2022-01-16 00:00:00 | 2022-01-17 00:00:00 | 2022-01-18 00:00:00 | 2022-01-19 00:00:00 | 2022-01-20 00:00:00 | 2022-01-21 00:00:00 | 2022-01-22 00:00:00 | 2022-01-23 00:00:00 | 2022-01-24 00:00:00 | 2022-01-25 00:00:00 | 2022-01-26 00:00:00 | 2022-01-27 00:00:00 | 2022-01-28 00:00:00 | 2022-01-29 00:00:00 | 2022-01-30 00:00:00 | 2022-01-31 00:00:00 | 2022-02-01 00:00:00 | 2022-02-02 00:00:00 | 2022-02-03 00:00:00 | 2022-02-04 00:00:00 | 2022-02-05 00:00:00 | 2022-02-06 00:00:00 | 2022-02-07 00:00:00 | 2022-02-08 00:00:00 | 2022-02-09 00:00:00 | 2022-02-10 00:00:00 | 2022-02-11 00:00:00 | 2022-02-12 00:00:00
[NAME] |  |  | DI | D | D | DO |  |  |  | DI | D | DO |  | DI | D | D | DO |  |  |  | DI | D | DO |  | DI | D | D | DO |  |  |  | DI | D | DO
Adam |  |  |  | DI | D | D | DO
Spreadsheet: 33235d1229534835-excel-2007-is-this-a-dynamic-range-issue-interpolation-program
Sheet: Interpolated Data

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1
Spreadsheet: 86052d1286026989-compile-data-from-several-worksheets-to-one-exceltesting
Sheet: 24.0611

 |  | Chainage | X coordinate | Ycoordinate | Elevation
 |  | -23.79 | 481981.32 | 1772981.34 | 255
 |  |  |  |  | 253.11
 |  |  |  |  | 245.93
 |  |  |  |  | 244.23
 |  |  |  |  | 244.22
 |  |  |  |  | 244.21
 |  |  |  |  | 244.21
 |  |  |  |  | 244.09
 |  |  |  |  | 244.09
 |  |  |  |  | 244.01
 |  |  |  |  | 244
 |  |  |  |  | 244.01
 |  |  |  |  | 244
 |  |  |  |  | 243.95
 |  |  |  |  | 243.89
 |  |  |  |  | 243.89
 |  |  |  |  | 243.86
 |  |  |  |  | 243.71
 |  |  |  |  | 243.56
 |  |  |  |  | 243.55
 |  |  |  |  | 241.85
 |  |  |  |  | 241.23
 |  |  |  |  | 240.98
 |  |  |  |  | 236.94
 |  |  |  |  | 236.1
 |  |  |  |  | 235
 |  |  |  |  | 229.47
 |  |  |  |  | 228.73
 |  |  |  |  | 224.92
 |  |  |  |  | 224.55
 |  |  |  |  | 224.5
 |  |  |  |  | 223.72
 |  |  |  |  | 223.81
 |  |  |  |  | 223.85
 |  |  |  |  | 223.79
 |  |  |  |  | 223.76
 |  |  |  |  | 223.7
 |  |  |  |  | 223.34
 |  |  |  |  | 223.32
 |  |  |  |  | 223.09
 |  |  |  |  | 222.9
 |  |  |  |  | 222.86
 |  |  |  |  | 222.83
 |  |  |  |  | 222.86
 |  |  |  |  | 222.89
 |  |  |  |  | 222.82
 |  |  |  |  | 222.78
 |  |  |  |  | 222.67
 |  |  |  |  | 222.56
 |  |  |  |  | 222.82
 |  |  |  |  | 222.87
 |  |  |  |  | 223.31
 |  |  |  |  | 223.54
 |  |  |  |  | 223.7
 |  |  |  |  | 223.87
 |  |  |  |  | 224.07
 |  |  |  |  | 224.52
 |  |  |  |  | 224.77
 |  |  |  |  | 226.14
 |  |  |  |  | 226.17
 |  |  |  |  | 227.59
 |  |  |  |  | 227.92
 |  |  |  |  | 229.54
 |  |  |  |  | 230.46
 |  |  |  |  | 231.17
 |  |  |  |  | 231.96
 |  |  |  |  | 232.26
 |  |  |  |  | 232.99
 |  |  |  |  | 233.38
 |  |  |  |  | 235.88
 |  |  |  |  | 236
 |  |  |  |  | 238.06
 |  |  |  |  | 238.61
 |  |  |  |  | 238.86
 |  |  |  |  | 239.02
 |  |  |  |  | 239.08
 |  |  |  |  | 239.21
 |  |  |  |  | 239.23
 |  |  |  |  | 239.2
 |  |  |  |  | 239.23
 |  |  |  |  | 239.33
 |  |  |  |  | 239.33
 |  |  |  |  | 239.38
 |  |  |  |  | 239.4
 |  |  |  |  | 243.01
 |  |  |  |  | 248.01
 |  |  |  |  | 253.03
 |  |  |  |  | 255
 |  |  |  |  | 259.82
 |  |  |  |  | 268.81
 |  |  |  |  | 279.62
 |  |  |  |  | 282.42
 |  |  |  |  | 295.69
 |  |  |  |  | 300.18
 |  |  |  |  | 319.43
 |  |  |  |  | 336.41
 |  |  |  |  | 339.52
 |  |  |  |  | 343.41
 |  |  |  |  | 360
 |  | 1000 |  |  | 324
Spreadsheet: 825225d1681195114-how-to-calculate-a-sum-when-its-an-empty-cell-project-velocity
Sheet: Sheet1 (2)

Project/Task L=Low Velocity (0-5 hrs/wk) M=Medium Velocity (5-10 hrs/wk) High Velocity (10-20 hrs/wk) Dedicated (20+ hrs/wk)
 | Person A | Person A | Person A | Person A | Person A | Person A | Person A | Person A | Person A | Person A
Project | L
Project | L
Project | L
Project | L
Project | L
Project |  | D
Project |  | L
Project |  | M
Project |  | L
Project |  | M
Project |  | L
Project |  | M
Project |  |  | H
Project |  |  | L
Project |  |  | L
Project |  |  | L
Project |  |  | L
Project |  |  | L
Project |  |  |  |  |  |  |  |  |  |  |  | Letter | Low Value |  | Letter | High Value
Project |  |  |  |  |  |  |  |  |  |  |  | L | 0 |  | L | 5
Project |  |  |  |  |  |  |  |  |  |  |  | M | 5 |  | M | 10
Project |  |  |  |  |  |  |  |  |  |  |  | H | 10 |  | H | 20
Project |  |  |  |  |  |  |  |  |  | L |  | D | 20 |  | D | 32
Project |  |  |  |  |  |  |  |  |  | L |  |  | 0 |  |  | 0
Project |  |  |  |  |  |  |  |  |  | L
Estimated Project/Task Hours/Wk  (Low)
Estimated Project/Task Hours/Wk (High)
Estimated Project/Task Hours/Wk (Average)
Spreadsheet: 272935d1382550554-get-the-total-values-based-on-date-question
Sheet: Sheet1

ID | Total Items | Date | Difference of total Items last active day
a | 1 | 2013-10-01 00:00:00 | 1
b | 2 | 2013-10-01 00:00:00 | 2
c | 3 | 2013-10-01 00:00:00 | 3
d | 4 | 2013-10-01 00:00:00 | 4
e | 5 | 2013-10-01 00:00:00 | 5
f | 6 | 2013-10-01 00:00:00 | 6
a | 13 | 2013-10-04 00:00:00 | 12 |  | The red values should be the answer
b | 15 | 2013-10-04 00:00:00 | 13
c | 12 | 2013-10-04 00:00:00 | 9
d | 22 | 2013-10-04 00:00:00 | 18
e | 9 | 2013-10-04 00:00:00 | 4
f | 7 | 2013-10-04 00:00:00 | 1
a | 1 | 2013-10-07 00:00:00 | 11
b | 2 | 2013-10-07 00:00:00 | 11
c | 3 | 2013-10-07 00:00:00 | 9
d | 4 | 2013-10-07 00:00:00 | 14
e | 3 | 2013-10-07 00:00:00 | 1
f | 1 | 2013-10-07 00:00:00 | 0