tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 847846d1698686128-if-cell-is-not-empty-then-join-two-cells-in-textjoin-formula-monthly-work-schedule-template-7shifts
Sheet: Schedule

 | Sat | Sun | Mon | [NAME] | Wed | Thurs | Fri |  |  | Sat | Sun | Mon | [NAME] | Wed | Thurs | Fri |  | Sat | Sun | Mon | [NAME] | Wed | Thurs | Fri |  | Sat | Sun | Mon | [NAME] | Wed | Thurs | Fri
 | 2023-11-01 00:00:00 |  |  |  |  |  |  |  |  | 2018-11-08 00:00:00 |  |  |  |  |  |  |  | 2018-11-15 00:00:00 |  |  |  |  |  |  |  | 2018-11-22 00:00:00
 | Markout |  |  |  |  |  |  |  | Markout |  |  |  |  |  |  |  | Markout |  |  |  |  |  |  |  | Markout
Employee 1 | ABC Homes - 920 56512 TWP 252
 | New
Employee 2 | The Rockies - 5628 28 Avenue
 | New
Employee 3
 | Roughin |  |  |  |  |  |  |  | Roughin |  |  |  |  |  |  |  | Roughin |  |  |  |  |  |  |  | Roughin
Employee 4
Employee 5
Employee 6
Employee 7
Employee 8
Employee 9
 | Ductwork |  |  |  |  |  |  |  | Ductwork |  |  |  |  |  |  |  | Ductwork |  |  |  |  |  |  |  | Ductwork
Employee 10
Employee 11
Employee 12
 | Heat Final |  |  |  |  |  |  |  | Heat Final |  |  |  |  |  |  |  | Heat Final |  |  |  |  |  |  |  | Heat Final
Employee 13
Employee 14
Employee 15
Employee 16
Employee 17
Employee 18
Spreadsheet: 77415d1277901065-count-and-sum-calculations-excel-query1
Sheet: Sheet1

Name | Rupees
Amit | 1000
Raju | 1000
[NAME] | 1000
Amit | 1000
Raju | 1000
[NAME] | 1000
Kapil | 1000
Amit | 1000
Amit | 1000
Amit | 1000
Amit | 1000
 |  |  |  |  |  | SUM | COUNT
 |  |  |  |  | Amit | 6000 | 6
 |  |  |  |  | Raju | 2000 | 2
 |  |  |  |  | [NAME] | 2000 | 2
 |  |  |  |  | Kapil | 1000 | 1
Spreadsheet: 707958d1607550895-check-if-the-values-are-on-the-required-period-book3-1-
Sheet: Expenditure P90_P50

 |  |  |  |  |  |  |  |  |  |  | Quarter
 |  |  |  |  |  | 2020-09-30 00:00:00
 |  |  |  |  | Actual Expenditure | period 0* | period 1* | period 2 | period 3 | period 4 | period 5 | period 6 | period 7
 | Item | Total | Start Date | Complete Date | 0 | 0
 |  |  |  | 2018-06-14 00:00:00
False | Delivery Readiness | 1016565 | 2018-06-15 00:00:00 | 2021-05-23 00:00:00 | 729793 | 45883.52 | 143386 | 68825.28 | 28677.2 | 28677.2
 | Delivery Readiness1 | 123456 | 2019-06-15 00:00:00 | 2022-05-23 00:00:00 | 1212 | 45883.52 | 143386 | 68825.28 | 28677.2
 | Delivery Readiness2 | 123456 | 2019-06-15 00:00:00 | 2022-05-23 00:00:00 | 1212 |  | 143386 | 68825.28 | 28677.2
 |  |  | 2021-05-24 00:00:00 | 2022-06-18 00:00:00 | 0
 |  |  |  |  | Period
 |  |  |  |  | Month
 |  |  |  |  | Quarter
 |  |  |  |  | Half Yearly
 |  |  |  |  | Year
Spreadsheet: 769058d1645275133-how-many-unique-areas-have-been-visited-by-vehicle-in-date-range-report
Sheet: Report

Weekly Number of DO per vehicle
From | To | 11/17055 | 1/63335 | 1/64134 | 1/67031 | 11/69228 | 13/51504 | 13/51623 | 13/51814 | 13/54318 | 13/807714 | 13/80774 | 13/80857 | 15/70824 | 2/98435 | 3/15531 | 8/12539
2021-11-01 00:00:00
Monthly
In below table I would like to count no of area delivered by each vehicle during the week
From | To | 11/17055 | 1/63335 | 1/64134 | 1/67031 | 11/69228 | 13/51504 | 13/51623 | 13/51814 | 13/54318 | 13/807714 | 13/80774 | 13/80857 | 15/70824 | 2/98435 | 3/15531 | 8/12539
2021-11-01 00:00:00
Spreadsheet: 537802d1505269324-index-and-macth-index-match-with-identification
Sheet: Sheet1

PIPE SIZES INCHES | OUTSIDE DIAMETER INCHES | [NAME]  by STD&XS | Iron Pipe by Schedule | Stainless Pipe by Schedule | WALL THICKNESS INCHES | INSIDE DIAMETER INCHES
0.25 | 0.54 |  |  | 10S | 0.065 | 0.41
0.25 |  | STD | 40 | 40S | 0.088 | 0.364
0.25 |  | XS | 80 | 80S | 0.119 | 0.302
0.375 | 0.675 |  |  | 10S | 0.065 | 0.545 |  | pipe size | 0.25
0.375 |  | STD | 40 | 40S | 0.091 | 0.493 |  | identification | [NAME]  by STD&XS
0.375 |  | XS | 80 | 80S | 0.126 | 0.423 |  | select schedule | XS
0.5 | 0.84 |  |  | 5S | 0.065 | 0.71 |  | inside diameter
0.5 |  |  |  | 10S | 0.083 | 0.674
0.5 |  | STD | 40 | 40S | 0.109 | 0.622
0.5 |  | XS | 80 | 80S | 0.147 | 0.546
 |  |  | 160 |  | 0.187 | 0.466
0.5 |  | [NAME] |  |  | 0.294 | 0.252
0.75 | 1.05 |  |  | 5S | 0.065 | 0.92
0.75 |  |  |  | 10S | 0.083 | 0.884
0.75 |  | STD | 40 | 40S | 0.113 | 0.824
0.75 |  | XS | 80 | 80S | 0.154 | 0.742
0.75 |  |  | 160 |  | 0.219 | 0.612
0.75 |  | [NAME] |  |  | 0.308 | 0.434
1 | 1.315 |  |  | 5S | 0.065 | 1.185
1 |  |  |  | 10S | 0.109 | 1.097
1 |  | STD | 40 | 40S | 0.133 | 1.049
1 |  | XS | 80 | 80S | 0.179 | 0.957
1 |  |  | 160 |  | 0.25 | 0.815
1 |  | [NAME] |  |  | 0.358 | 0.599
1.25 | 1.66 |  |  | 5S | 0.065 | 1.53
1.25 |  |  |  | 10S | 0.109 | 1.442
1.25 |  | STD | 40 | 40S | 0.14 | 1.38
1.25 |  | XS | 80 | 80S | 0.191 | 1.278
1.25 |  |  | 160 |  | 0.25 | 1.16
1.25 |  | [NAME] |  |  | 0.382 | 0.896
1.5 | 1.9 |  |  | 5S | 0.065 | 1.77
1.5 |  |  |  | 10S | 0.109 | 1.682
1.5 |  | STD | 40 | 40S | 0.145 | 1.61
1.5 |  | XS | 80 | 80S | 0.2 | 1.5
1.5 |  |  | 160 |  | 0.281 | 1.338
1.5 |  | [NAME] |  |  | 0.4 | 1.1
2 | 2.375 |  |  | 5S | 0.065 | 2.245
2 |  |  |  | 10S | 0.109 | 2.157
2 |  | STD | 40 | 40S | 0.154 | 2.067
2 |  | XS | 80 | 80S | 0.218 | 1.939
2 |  |  | 160 |  | 0.344 | 1.687
2 |  | [NAME] |  |  | 0.436 | 1.503
2.5 | 2.875 |  |  | 5S | 0.083 | 2.709
2.5 |  |  |  | 10S | 0.12 | 2.635
2.5 |  | STD | 40 | 40S | 0.203 | 2.469
2.5 |  | XS | 80 | 80S | 0.276 | 2.323
2.5 |  |  | 160 |  | 0.375 | 2.125
2.5 |  | [NAME] |  |  | 0.552 | 1.771
Spreadsheet: 34345d1231512902-define-list-in-workbook-states-not-a-valid-name-dependent_drop_down_v1
Sheet: Lists

starting letter |  | RowStart | 5 |  |  | AdvFilter_Criteria |  |  | DDL_List
[NAME] |  | RowEnd | 30 |  |  | Key | food |  | food
A |  |  |  |  |  | S |  |  | S
B |  |  |  |  |  |  |  |  | Salt, table (tsp)
C |  |  |  |  |  |  |  |  | Sausage - Hatfield Country (dutch rope)  2oz pan fried (=56 grams)
D |  |  |  |  |  |  |  |  | Smart  Balance 50/50 butter blend (tablespoon)
E |  |  |  |  |  |  |  |  | [NAME] 50/50 buter blend (grams)
F |  |  |  |  |  |  |  |  | Sour Cream - Lite  (grams)
G |  |  |  |  |  |  |  |  | Sour Cream - Lite (1 tablespoon)
H |  |  |  |  |  |  |  |  | Sour Cream, Fat Free (1 Tblsp = 15 grams)
I |  |  |  |  |  |  |  |  | [NAME] (1 Tblsp = 16 grams)
J |  |  |  |  |  |  |  |  | Soy Sauce - Lite (1 Tblsp = 16 grams)
K |  |  |  |  |  |  |  |  | Spaghetti Sauce (Hunts Traditional) 5.96 servings per can (SERVING)
L |  |  |  |  |  |  |  |  | Spaghetti Sauce (Hunts Traditional)1 serving = 1/2 cup (cups)
M |  |  |  |  |  |  |  |  | Spaghetti Sauce (Hunts Traditional) 1 serving = 126 [NAME]
N |  |  |  |  |  |  |  |  | [NAME] (tablespoon)
O |  |  |  |  |  |  |  |  | [NAME] (cup) no carb count
P |  |  |  |  |  |  |  |  | [NAME] (cup) .5 carbs per tablespoon
Q |  |  |  |  |  |  |  |  | Splenda - Brown (grams)
R |  |  |  |  |  |  |  |  | Sugar, Brown (grams)
S |  |  |  |  |  |  |  |  | Sugar, Granulated (cup)
T |  |  |  |  |  |  |  |  | Sugar, granulated (grams)
U |  |  |  |  |  |  |  |  | Sugar, granulated (ounces)  (3.8oz = 1/2 cup as per one site)
V |  |  |  |  |  |  |  |  | sugar, granulated (tsp)
W |  |  |  |  |  |  |  |  | Swiss Cheese (as per giant) - low fat  (Ounce)
X |  |  |  |  |  |  |  |  | Swiss Cheese - Boars Head Lacey (ounce)
Y
Z
Spreadsheet: 5658bcbd-6fbe-4d0a-b46f-af712416b13a
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | 2011-2012 Funded Projects | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
 |  | Community Development Block Grant Economic Development Grant Program
 | Community | Name of Business | Total Amount Requested | Approved | Number of Jobs | Project Description | Project Status
 | Rockport* | Avena Botanicals | 40000 | 40000 | 8 | additional funding to complete project which included the retention of jobs and an expansion and  to the company's manufacturing facility | Pending final closeout
 | York | Maine Coast Shellfish | 200000 | 200000 | 7 | equipment and working capital | Pending final closeout
 | Pittsfield | Argo Marketing Group, Inc. | 85000 | 85000 | 24 | equipment and working capital | funds drawn/needs to be monitored & closed out
 | Hancock | PRL Hancock, LLC | 200000 | 200000 | 7 | purchase and installation of energy-efficient dry kilns | funds drawn/needs to be monitored & closed out
 | Madawaska | The Inn of Acadia | 300000 | 300000 | 11 | site improvements, HVAC system, elevator repairs | under contract
 | Brunswick | Integrated Marine Systems, Inc. | 200000 | 200000 | 7 | purchase control network equipment | under contract
 | Winslow | Orion Ropeworks, LLC | 400000 | 400000 | 15 | purchase of equipment | funds drawn/needs to be monitored & closed out
 | Saint Agatha | Our Father's Place | 50000 | 50000 | 2 | purchase of equipment and working capital | under contract
 | [NAME] | Todd's Custom Contracting | 50000 | 50000 | 2 | purchase of equipment | under contract
 | Eagle Lake | Phoenix Firewood, Inc. | 47500 | 47500 | 2 | capital equipment | completing Phase II
 | Milo | Elaine's Basket [NAME] and [NAME], LLC | 60000 | 60000 | 2 | purchase of equipment | under contract
 | [NAME] | New England Truck Tire Centers | 200000 | 200000 | 7 | purchase of equipment | completing Phase II
 | Vassalboro | DP Industries | 150000 | 150000 | 5 | equipment/working capital | under contract
 | Orland | Freshwater Stone & Brickwork Inc | 180000 | 180000 | 6 | equipment/working capital | completing Phase II
 | Monroe | Stone Fox Farm Creamery | 60000 | 60000 | 2 | purchase of equipment | completing Phase II
 | [NAME] | Growing Concern | 60000 | 60000 | 2 | upgrading facility, utility structure & Installation | completing Phase II
 | Community | Name of Business | Total Amount Requested | Approved | Number of Jobs | Project Description
 | Lincoln* | [NAME], LLC | 200000 | 0 | 8 | retention of 8 jobs/ increase production
 | Belfast | Front Street Shipyard | 200000 | 0 | 10 | 30 ton capacity crane; heated spray booth; upgrade dock
 | [NAME] | Riverview Homes, Inc. | 90000 | 0 | 3 | expansion of workshop facility
 | Winslow | Orion Ropeworks, LLC | 115000 | 0 | 4 | municipal owned infrastructure improvements  (roof, sewer pump, furnaces, etc.)
 | Hartland | Tasman Leather Group, LLC | 200000 | 0 | 7 | new steam generators; increase production
 | TOTAL |  | 3087500 | 2282500 | 141
 | * = job retention project
Spreadsheet: 815957d1675282716-how-to-build-stock-trading-track-spreadsheet-sample-stock-tracking
Sheet: Sheet1

Mutual Fund Performance Analyzer |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Amount
 | ******** Transaction ******** |  |  |  | ******** Tax Ledger ******** |  |  | ************ Market Value ************ |  |  |  | ********** Return on Investment **********
Sample Stock |  |  |  |  |  |  |  |  |  |  |  |  | Fund | Annualized
 |  | Number | Cost |  | Number |  | Average |  |  |  | Market | Outside | Assets + | Return on | Annualized
 |  | of | Per |  | of | Tax | Cost |  | Per |  | Gain or | Assets | Cash | Initial | Periodic
Date | Transaction | Shares | Share | Amount | Shares | Cost | Per Shr | Date | Share | Total | (Loss) | Invested | Withdrawals | Investment | Return
 |  |  |  | Amount
2015-07-08 00:00:00 | Init. Purchase | 100 | 131.54
2015-09-01 00:00:00 | Dividend | 0 | 120.31 | 97.5
2015-12-01 00:00:00 | Dividend | 0 | 92.41 | 97.5
2015-12-28 00:00:00 | Sale | -100 | 86.67 | -8666.94
Spreadsheet: 766d0731-84aa-4949-a9f2-b928440db9f6
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
6MAMM | Test | 6MAMM | 6-Monoacetylmorphine (6-MAM), Confirmation, Meconium | 6-MAM Confirmation, M | Liquid Chromatography-Tandem Mass Spectrometry (LC-MS/MS) | Stool Container: Stool |  |  | 5 | g | Chain-of-custody is recommended for this test. Chain-of-Custody Meconium Kit (Supply T653) is available upon request.      Container/Tube: Stool container (Supply T288) [NAME]: 5 g (approximately 1 tablespoon) Collection Instructions:  1. Collect entire random meconium specimen. 2. Send specimen frozen; 6-MAM is unstable at any other temperature. Additional Information:  1. For chain-of-custody information, see Chain-of-Custody Meconium Kit (Supply T653). 2. Specimen that arrives with a broken seal does not meet the chain-of-custody requirements. 3. The laboratory recommends sending chain-of-custody specimens by overnight shipment. | 2 g (approximately 1 teaspoon) | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	Grossly bloody reject; Pink OK | Negative Positives are reported with a quantitative LC-MS/MS result. [NAME] concentration: 6-MAM by LC-MS/MS: >5 ng/g | Monday through Sunday; Varies | 2 days |  | 1 | 83925 |  |  |  |  | Rochester
6MAMM | [NAME] | [NAME] | Meconium |  |  |  | Frozen | 14 days
6MAMM | Result | 31874 | 6-MAM | 6-MAM | Numeric |  |  |  |  | ng/g |  |  |  |  |  |  |  |  |  | 29345-6
6MAMM | Result | 31875 | Interpretation | Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 69050-3
6MAMM | Result | 32011 | Chain of Custody | Chain of Custody | Numeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 275471d1383530304-nested-if-statements-are-returning-false-values-cannot-find-error-in-code-fairbank-roster-summary-page
Sheet: Food Coatings

 | Fairbank |  | ROSTER | Food Coatings |  |  |  |  |  |  |  | WEEK ENDING:
 |  |  | MONDAY |  | 2013-11-04 00:00:00 | TUESDAY |  | 2013-11-05 00:00:00 | WEDNESDAY |  | 2013-11-06 00:00:00 | THURSDAY |  | 2013-11-07 00:00:00 | FRIDAY |  | 2013-11-08 00:00:00 | SATURDAY |  | 2013-11-09 00:00:00 | SUNDAY |  | 2013-11-10 00:00:00
 |  | ROLE | NAME | TIME | HRS | NAME | TIME | HRS | NAME | TIME | HRS | NAME | TIME | HRS | NAME | TIME | HRS | NAME | TIME | HRS | NAME | TIME | HRS
Morning Shift | Non-Skilled
 |  |  | MONDAY |  |  | TUESDAY |  |  | WEDNESDAY |  |  | THURSDAY |  |  | FRIDAY |  |  | SATURDAY |  |  | SUNDAY
 |  | ROLE | NAME | TIME | HRS | NAME | TIME | HRS | NAME | TIME | HRS | NAME | TIME | HRS | NAME | TIME | HRS | NAME | TIME | HRS | NAME | TIME | HRS
 | SKILLED |  | [NAME] | 8am |  | [NAME] | 8am |  | [NAME] | 8am |  | [NAME] | 8am |  | [NAME] | 8am |  | [NAME] | 8am |  | [NAME] | 8am
 |  |  | MONDAY |  | 1899-12-24 00:00:00 | TUESDAY |  | 1899-12-25 00:00:00 | WEDNESDAY |  | 1899-12-26 00:00:00 | THURSDAY |  | 1899-12-27 00:00:00 | FRIDAY |  | 1899-12-28 00:00:00 | SATURDAY |  | 1899-12-29 00:00:00 | SUNDAY |  | 00:00:00
 |  | ROLE | NAME | TIME | HRS | NAME | TIME | HRS | NAME | TIME | HRS | NAME | TIME | HRS | NAME | TIME | HRS | NAME | TIME | HRS | NAME | TIME | HRS
[NAME] | Non-Skilled
 |  |  | MONDAY |  |  | TUESDAY |  |  | WEDNESDAY |  |  | THURSDAY |  |  | FRIDAY |  |  | SATURDAY |  |  | SUNDAY
 |  | ROLE | NAME | TIME | HRS | NAME | TIME | HRS | NAME | TIME | HRS | NAME | TIME | HRS | NAME | TIME | HRS | NAME | TIME | HRS | NAME | TIME | HRS
 | SKILLED
Spreadsheet: rick_buy__32874__Enron-Dynegy
Sheet: Merger

 |  |  |  |  |  | Merger probablity | Merger probablity | Merger probablity
 | ENE | DYN |  | ENE exchange | ENE price as % of | with ENE equity | with ENE equity | with ENE equity
 | closing | closing | Exchange | ratio adjusted | DYN exchange ratio | Value at | value at | value at
Date | price | price | ratio | price | adjusted price | $1 / share | $4 / share | $7 / share
2001-11-12 00:00:00 | 9.24 | 44.31 | 0.2685
 | 9.98 | 46.94 | 0.2685
 | 10 | 46.2 | 0.2685
Spreadsheet: 204855d1357665352-timesheet-unable-to-code-overtime-130-ts_proposal
Sheet: TOM

Billable to Dept A
 | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Total
Week1 |  | 10 | 10 | 10 | 10 | 9 | 4
Week2
Week3
Week4
Billable to Dept B
 | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Total
Week1 |  | 3 | 0 | 0 | 5 | 0 | 4
Week2
Week3
Week4
Billable to Dept C
 | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Total
Week1 |  | 4 | 0 | 8 | 5 | 2 | 4
Week2
Week3
Week4
Spreadsheet: daef673b-550c-4986-8bdb-a3d38feaad9b
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
EHRCP | Test | EHRCP | Ehrlichia Antibody Panel, Serum | Ehrlichia Ab Panel | Immunofluorescence Assay (IFA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL | 0.25 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	Mild OK; Gross reject Icterus	NA Other	Heat-inactivated specimen | <1:64 | Monday through Friday; 9 a.m. | Same day/1 day | 3 days |  | Profile |  |  |  |  | Rochester
EHRCP | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
EHRCP | Component | ANAP | Anaplasma phagocytophilum (Human Granulocytic Ehrlichiosis) Antibody, Serum | Anaplasma phagocytophilum Ab, IgG,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. | 1 day | 3 days | 1 | 86666 |  |  | Yes | Yes
ANAP | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
ANAP | Result | 81157 | Anaplasma phagocytophilum Ab, IgG,S | Anaplasma phagocytophilum Ab, IgG,S | Alphanumeric |  |  |  |  | titer |  |  |  |  |  |  |  |  |  | 23877-4 | Anaplasma phagocytophilum Ab.[NAME]:Titr:Pt:Ser:Qn:IF
EHRCP | Component | EHRC | Ehrlichia chaffeensis (HME) Antibody, IgG, Serum | Ehrlichia Chaffeensis (HME) Ab, IgG | 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	Heat-inactivated specimen | <1:64 | Monday through Friday; 9 a.m. | Same day/1 day | 3 days | 1 | 86666 |  |  | Yes | Yes
EHRC | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
EHRC | Result | 81478 | Ehrlichia Chaffeensis (HME) Ab, IgG | Ehrlichia Chaffeensis (HME) Ab, IgG | Alphanumeric |  |  |  |  | titer |  |  |  |  |  |  |  |  |  | 47405-6 | Ehrlichia chaffeensis [NAME].IgG:Titr:Pt:Ser:Qn:IF
Spreadsheet: 774272d1648344982-5-year-moving-average-that-restarts-at-every-new-category-5-year-moving-average-that-restarts-at-every-new-category
Sheet: Sheet1

Country | Year | Calorie intake | 5 year moving average |  | Year Count | [NAME] |  | Combined Formula
Afghanistan | 1961 | 2069.31 | #N/A
Afghanistan | 1962 | 2012.73 | #N/A
Afghanistan | 1963 | 1861.62 | #N/A
Afghanistan | 1964 | 2037.57 | #N/A
Afghanistan | 1965 | 2039.64 | 2004.174
Afghanistan | 1966 | 1888.53 | 1968.018
Afghanistan | 1967 | 2049.99 | 1975.47
Afghanistan | 1968 | 2013.42 | 2005.83
Afghanistan | 1969 | 2025.15 | 2003.346
Afghanistan | 1970 | 1748.46 | 1945.11
Afghanistan | 1971 | 1733.28 | 1914.06
Albania | 1963 | 1487.64 | #N/A
Albania | 1964 | 1566.3 | #N/A
Albania | 1965 | 1555.26 | #N/A
Albania | 1966 | 1555.26 | #N/A
Albania | 1967 | 1560.78 | 1545.048
Albania | 1968 | 1616.67 | 1570.854
Albania | 1969 | 1658.76 | 1589.346
Albania | 1970 | 1666.35 | 1611.564
Albania | 1971 | 1628.4 | 1626.192
Algeria | 1965 | 1097.79
Algeria | 1966 | 1083.99
Algeria | 1967 | 1136.43
Algeria | 1968 | 1177.14
Algeria | 1969 | 1176.45
Algeria | 1970 | 1155.75
Algeria | 1971 | 1186.8
Angola | 1961 | 1240.62
Angola | 1962 | 1255.11
Angola | 1963 | 1278.57
Angola | 1964 | 1284.78
Angola | 1965 | 1295.13
Angola | 1966 | 1304.1
Angola | 1967 | 1325.49
Angola | 1968 | 1280.64
Angola | 1969 | 1342.74
Angola | 1970 | 1355.85
[NAME] and [NAME] | 1961 | 1385.52
[NAME] and [NAME] | 1962 | 1507.65
[NAME] and [NAME] | 1963 | 1415.88
[NAME] and [NAME] | 1964 | 1466.94
[NAME] and [NAME] | 1965 | 1533.18
[NAME] and [NAME] | 1966 | 1498.68
[NAME] and [NAME] | 1967 | 1351.71
[NAME] and [NAME] | 1968 | 1384.83
[NAME] and [NAME] | 1969 | 1417.95
[NAME] and [NAME] | 1970 | 1545.6
[NAME] and [NAME] | 1971 | 1493.85
Spreadsheet: 875621d1722222701-return-highest-count-of-consecutive-numbers-that-have-the-same-first-or-last-digit-consecutive-last-digit
Sheet: Sheet1

Consecutive Example: 5 numbers in a row
 |  |  |  |  |  |  | Result
1 | 5 | 8 | 18 | 28 |  |  | 3 |  | 8 was repeated 3 times cosecutively (08, 18, and 28).
4 | 14 | 24 | 25 | 35 |  |  | 3 |  | 4 was repeated 3 times consecutively (4,14,24)
3 | 13 | 17 | 23 | 33 |  |  | 2 |  | 3 was repeated 2 times consecutively twice (3,13 ), (23,33)
Example with 6 numbers in a row:
 |  |  |  |  |  |  | Result
2 | 10 | 12 | 20 | 22 | 36 |  | 0 |  | no number of the last digits were repeated consecutively
4 | 11 | 14 | 15 | 25 | 34 |  | 2 |  | 5 was repeated 2 times consecutively (15,25)
12 | 17 | 22 | 27 | 37 | 47 |  | 3 |  | 7 was repeated 3 times consecutively (27,37,47)
Spreadsheet: 83004d1283014254-excel-2007-keeping-the-value-of-a-countif-after-removing-duplicates-count-and-delete-duplicates
Sheet: Sheet1

1234 | Yes | 2901 | 4243 | 2222337 | [NAME] | [NAME] | Calvin | AB | CA | 1 | 2010-07-06 19:19:25 | 2010-07-06 19:28:10 | C | 111.32 | 30 | 0
1234 | No | 3428 | 5242 | 2222337 | [NAME] | [NAME] | Calvin | AB | CA | 1 | 2010-07-06 19:19:25 | 2010-07-06 19:28:10 | C | 0 | 30 | 0
1234 | Maybe | 3192 | 4705 | 2222337 | [NAME] | [NAME] | Calvin | AB | CA | 1 | 2010-07-06 19:19:25 | 2010-07-06 19:28:10 | C | 1 | 30 | 0
1234 | Pickle | 3079 | 3340 | 2222337 | [NAME] | [NAME] | Calvin | AB | CA | 1 | 2010-07-06 19:19:25 | 2010-07-06 19:28:10 | C | 60 | 30 | 0
5555 | Mustard | 4212 | 4781 | 357642 | Orlando | [NAME] | Negative | QC | CA | 1 | 2009-04-13 14:23:28 | 2010-05-26 11:37:01 | P | 20 | 60 | 0
5555 | Mustard | 3237 | 3403 | 357642 | Orlando | [NAME] | Negative | QC | CA | 1 | 2009-04-13 14:23:28 | 2010-05-26 11:37:01 | P | 3 | 50 | 0
Spreadsheet: 46123d1245015286-want-to-automate-the-recording-of-data-from-one-worksheet-to-another-fruitexample2
Sheet: Apples

Key | Date | Fruit | Units | Cost |  | Status: OK
1 | 2009-02-17 00:00:00 | Apples | 2 | 14
2 | 2009-02-17 00:00:00 | Apples | 4 | 28 |  | Key column in column A on each fruit page, you can hide this
3 | 2009-02-18 00:00:00 | Apples | 3 | 21 |  | column once you've copied the formula down far enough.
4 | 2009-02-19 00:00:00 | Apples | 3 | 21
5 | 2009-02-20 00:00:00 | Apples | 5 | 35