tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 60563d1261075186-excel-2007-autofill-help-current-frieght-cc-test
Sheet: SaiaCC

[NAME] |  |  |  |  |  |  |  |  |  | Fuel Charge: |  | 0.2
State | First | Additional | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
AL | 80.75 | 42.75
AR | 95 | 42.75
AZ | 161.5 | 71.25
CA | 166.25 | 85.5
CO | 161.55 | 66.45
CT | 90 | 45
DC | 100 | 35
DE | 100 | 40
FL | 85.5 | 42.75
GA | 76 | 28.5
IA | 99.75 | 47.5
ID | 161.5 | 85.5
IL | 90.25 | 39.9
IN | 90.25 | 38
KS | 99.75 | 47.5
KY | 85.5 | 33.25
LA | 104.5 | 47.5
MA | 100 | 45
MD | 85 | 35
ME | 110 | 55
MI | 90.25 | 38
MN | 95 | 52.25
MO | 95 | 38
MS | 95 | 38
MT | 175 | 100
NC | 61.75 | 28.5
ND | 161.5 | 61.75
NE | 104.5 | 61.75
NH | 105 | 45
NJ | 85 | 40
NM | 161.5 | 66.5
NV | 166.25 | 80.75
NY | 100 | 45
OH | 90.25 | 28.5
OK | 95 | 47.5
OR | 166.25 | 76
PA | 85 | 35
RI | 105 | 45
SC | 68.4 | 28.5
SD | 161.5 | 57
TN | 76 | 33.25
TX | 99.75 | 47.5
UT | 166.25 | 66.5
VA | 75 | 30
VT | 105 | 50
WA | 142.5 | 76
WI | 95 | 38
WV | 105 | 35
WY | 142.5 | 76
Spreadsheet: 841530d1693720683-need-help-with-resource-forecasting-formula-resource-plan-draft_v2
Sheet: Resource Heatmap

Resource Bandwidth/Heatmap
 |  | Day of the selected Month
Resource Name | September 2023 | 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
Person 1
Person 2
Person 3
Person 4
Person 5
Person 6
Person 7
Person 8
Person 9
Person 10
Spreadsheet: 690307d1597028213-countifs-question-based-on-exact-values-production-schedule-forum
Sheet: Production

 |  | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
 |  | 2020-08-10 00:00:00
Project A | 1
Scheduled |  |  | 1 | 1
Cast |  | 1
Remaining
[NAME], [NAME]
Walls and Columns
required
remaining
Project B | 2
Scheduled |  | 1 | 1 | 1
Cast |  | 1
Remaining
Project C | 3
Scheduled |  | 1 | 1 | 1
Cast
Remaining
Remaining Total |  | 1 | 3 | 3 | 0 | 0 | 0
Weekly
Spreadsheet: monika_causholli__28273__Price Forecast
Sheet: Recovered Paper

Recovered Paper Forecast |  |  | $
Firm/Analyst | Units | Current | 2000 | 1Q01 | 2Q01 | 3Q01 | 4Q01 | 2001E | 1Q02 | 2Q02 | 3Q02 | 4Q02 | 2002E | 2003E |  | Date |  | Notes
[NAME] | sh.ton |  |  |  |  |  |  | 45 |  |  |  |  | 45 |  |  | 2001-09-05 00:00:00
CIBC Securities
CS First Boston -OCC | sh.ton |  | 72 |  | 33 | 35 | 35 | 34q | 35 |  |  |  | 44q |  |  | 2001-10-01 00:00:00 |  | 200E decreased from 35 to 34. 2002E decreased from 49 to 44.
Deutsche Bank - OCC |  |  | 82 | 41 | 39 | 40 | 40 | 40q | 40 | 45 | 55 | 65 | 51q | 80 |  | 2001-09-25 00:00:00 |  | 2001E decreased by $1 -2002E decreased from 70 to 51.
Deutsche Bank - DLK |  |  | 102 | 54 | 52 | 52 | 50 | 52q | 50 | 60 | 75 | 85 | 68q | 105 |  | 2001-09-25 00:00:00 |  | 2001E decreased by $3 - 2002E decreased from 90 to 68
Deutsche Bank - ONP |  |  | 60 | 60 | 53 | 46 | 45 | 51q | 40 | 35 | 35 | 40 | 38q | 55 |  | 2001-09-25 00:00:00 |  | 2001E decreased by $1 - 2002E decreased from 60 to 38
First Associate Investment Inc.
Goldman Sachs OMG | mt |  | 80 |  |  |  |  | 74 |  |  |  |  |  |  |  | 2001-06-24 00:00:00
Goldman Sachs OCC | sh.ton |  | 70 |  |  |  |  | 80 |  |  |  |  |  |  |  | 2001-03-15 00:00:00
JP Morgan
[NAME]
[NAME]
Merrill Lynch
Morgan Stanley
ONP (8) | sh.ton | 51 | 83 |  |  |  |  | 53 |  |  |  |  | 62 | 81 |  | 2001-10-31 00:00:00
ONP (6) | sh.ton | 34 | 59 |  |  |  |  | 36 |  |  |  |  | 39 | 54 |  | 2001-10-31 00:00:00
OCC (11) | sh.ton | 43 | 80 |  |  |  |  | 41 |  |  |  |  | 60 | 92 |  | 2001-10-31 00:00:00
Dbl.  [NAME] (13) | sh.ton | 51 | 96 |  |  |  |  | 51 |  |  |  |  | 81 | 124 |  | 2001-10-31 00:00:00
Mixed Paper (1) | sh.ton | 23 | 50 |  |  |  |  | 24 |  |  |  |  | 29 | 41 |  | 2001-10-31 00:00:00
Magazines (10) | sh.ton | 48 | 70 |  |  |  |  | 52 |  |  |  |  | 53 | 66 |  | 2001-10-31 00:00:00
Boxboard (4) | sh.ton | 39 | 60 |  |  |  |  | 38 |  |  |  |  | 47 | 60 |  | 2001-10-31 00:00:00
Envelope Cuttings (31) | sh.ton | 210 | 373 |  |  |  |  | 228 |  |  |  |  | 230 | 307 |  | 2001-10-31 00:00:00
Hard White Shavings (30) | sh.ton | 193 | 335 |  |  |  |  | 206 |  |  |  |  | 206 | 281 |  | 2001-10-31 00:00:00
White News Blanks (24) | sh.ton | 166 | 149 |  |  |  |  | 161 |  |  |  |  | 165 | 164 |  | 2001-10-31 00:00:00
Sorted Office Paper (37) | sh.ton | 76 | 145 |  |  |  |  | 82 |  |  |  |  | 86 | 130 |  | 2001-10-31 00:00:00
Coated Book Stock (43) | sh.ton | 77 | 144 |  |  |  |  | 84 |  |  |  |  | 88 | 131 |  | 2001-10-31 00:00:00
Salomon Smith Barney
Scotiabank
TD Securities
Spreadsheet: 219570d1362788317-find-string-other-than-specified-strings-example
Sheet: Sheet2

 |  | Activities
 | Activities | Workshop | Funding | Training | Mentors | Other
Organization 1 | Training |  |  |  |  | 0
Organization 2 | Funding, Training, Mentors |  |  |  |  | 0
Organization 3 | Workshops |  |  |  |  | 0
Organization 4 |  |  |  |  |  | 0
Organization 5 |  |  |  |  |  | 0
Organization 6 | Mentors, Workshops, Goldman Sachs 10,000 Small Businesses |  |  |  |  | 1
Organization 7 | Workshops |  |  |  |  | 0
Organization 8 | Partnerships |  |  |  |  | 0
Organization 9 | Workshops, Partnerships |  |  |  |  | 1
Organization 10 | Funding |  |  |  |  | 0
Organization 11 | Mentor |  |  |  |  | 0
Spreadsheet: 718074d1612974259-averaging-formula-with-multiple-criteria-speed-average-example
Sheet: Sheet1

Player ID | SPEED
0 | 1
0 | 0.24
0 | 0.67
0 | 0.12
1 | 0 |  | average ID 1
1 | 0.89
1 | 3.2 |  | excluding values 0-0,2
1 | 0.45
1 | 0
2 | 0.29
2 | 0.12
2 | 2.16
3 | 1.45
3 | 0
3 | 0
3 | 1.21
3 | 0.48
3 | 0.12
3 | 0.96
Spreadsheet: daren_farmer__5037__HPLN0407
Sheet: Sheet1

HPLN0407.XLS |  | Fax # [PHONE]
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL;  LIZ BELLAMY / ENRON
FROM:  MELISSA JONES - TXU ELECTRIC & GAS  (TU ELECTRIC)
SUBJECT:  TXU FUELS NOMINATION - April 7, 2001
 |  |  |  |  |  | **Sat/Sun | **Monday
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 4/7-8/2001 | 2001-04-09 00:00:00
 |  |  |  |  |  | Eff. 0900 hrs. | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream
 |  | Firm Summary
Enron (S) |  | Sandhills |  | Enron | 8 | 0 | 0
 |  | Enron North America Spot/3959
OTHER ENRON/HPL TRANSPORTS: |  |  |  | Downstream
 |  | Total Other Transports:
NOTE:  Additional swing volumes may be requested at Teco Tap, or Texoma by TUFCO Gas Control under either the
Wagner Brown K# 1901 or HPL K# 3949 agreements.
*  Nominations to continue until TU Electric changes such nominations.
CC:   [NAME] | [NAME]
R. Skerik | [NAME]
G. Green | K. English
B. Fleming | GCC Dispatcher
Spreadsheet: daren_farmer__5643__HPLN1227
Sheet: Sheet1

HPLN1227.XLS |  | Fax # [PHONE]
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL;  LIZ BELLAMY / ENRON
FROM:  MELISSA JONES - TXU ELECTRIC & GAS  (TU ELECTRIC)
SUBJECT:  TXU FUELS NOMINATION - December 27, 2000
 |  |  |  |  |  | **Wednesday
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 2000-12-27 00:00:00
 |  |  |  |  |  | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream
 |  | Firm Summary
Enron (S) |  | Oasis Turbine |  | Enron | 10 | 10
Enron (S) |  | LS HPL [NAME] |  | Enron | 0 | 0
Enron (S) |  | Texoma |  | Enron | 0 | 30 | *
Enron (S) |  | Oasis Sealy |  | Enron | 0 | 20 | *
 |  | Enron North America Spot/3959
OTHER ENRON/HPL TRANSPORTS: |  |  |  | Downstream
 |  | Total Other Transports:
NOTE:  Additional swing volumes may be requested at Teco Tap, or Texoma by TUFCO Gas Control under either the
Wagner Brown K# 1901 or HPL K# 3949 agreements.
*  Nominations to continue until TU Electric changes such nominations.
CC:   [NAME] | [NAME]
R. Skerik | [NAME]
G. Green | K. English
B. Fleming | GCC Dispatcher
Spreadsheet: 5ddda306-86b7-4649-a943-ec903128cdab
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
MSH6M | Test | MSH6M | MSH6 Mutation Screen, Blood | MSH6 Mutation Screen, B | Polymerase Chain Reaction (PCR) Followed by DNA Sequence Analysis and Gene Dosage Analysis by [NAME] (MLPA) (PCR is utilized pursuant to a license agreement with Roche Molecular Systems, Inc.) |  |  |  | 3 | mL | [NAME] must arrive within 96 hours of draw.   [NAME] blood Container/Tube: Preferred: Lavender top (EDTA) or yellow top (ACD) Acceptable: Any anticoagulant [NAME]: 3 mL	 Collection Instructions:		 1. Invert several times to mix blood. 2. Send specimen in original tube. Forms:	 1. Molecular Genetics-Inherited Cancer Syndromes Patient Information Sheet (Supply T519) in Special Instructions 2. 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. 3. If not ordering electronically, submit a Molecular Genetics Request Form (Supply T245) with the specimen. | 1 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | An interpretive report will be provided. | Friday; 10 a.m. | 14 days | 20 days |  | Profile |  |  |  |  | Rochester
MSH6M | [NAME] | VARIES | Varies |  |  |  | Ambient
MSH6M | Result | 22748 | Reason For Referral | Reason For Referral | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42349-1 | Reason for referral:Find:Pt:^Patient:Nar:
MSH6M | Result | 22750 | Result | Result | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
MSH6M | Result | 22751 | Interpretation | Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 69047-9 | Service comment 01:Imp:Pt:[NAME]:Nom:
MSH6M | Result | 22749 | Method | Method | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 49549-9
MSH6M | Result | 22752 | Amendment | Amendment | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
MSH6M | Result | 22744 | [NAME] | [NAME] | Alphanumeric
MSH6M | Result | 22746 | Source | Source | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31208-2 | [NAME] source:Prid:Pt:[NAME]:Nom:
MSH6M | Result | 22753 | Reviewed By: | Reviewed By: | Alphanumeric
MSH6M | Result | 22754 | Release Date | Release Date | Alphanumeric
MSH6M | Billing Component | MSH6M |  | MSH6 GENE DUP/DELETE VARIANT |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 81300
MSH6M | Billing Component | MSH6M |  | MSH6 GENE FULL SEQ |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 81298
Spreadsheet: 540378d1506670820-sum-two-cells-from-two-different-tables-excel-help-example
Sheet: Dec17

 |  |  |  |  |  |  |  | Mon | Tue | Wed | Thu | Fri | Sat | Sun
 |  |  |  |  |  |  | 48 |  |  |  |  | 1 | 2 | 3 |  | Total days: | 19
 |  |  |  |  |  |  | 49 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |  | Work hours:
 |  |  |  |  |  |  | 50 | 11 | 12 | 13 | 14 | 15 | 16 | 17
 |  |  |  |  |  |  | 51 | 18 | 19 | 20 | 21 | 22 | 23 | 24
 |  |  |  |  |  |  | 52 | 25 | 26 | 27 | 28 | 29 | 30 | 31 |  | Bank holyday: | 2
Not-uniqe | Not-uniqe2 | Cost Center | % | Time spent | Comment
FDASD |  | 1
FDASD |  | 2
 |  | 3
ASD |  | 4
ASD |  | 5
 |  | 6
 |  | 7
 |  | 8
 |  | 9
 |  | 10
 |  | 11
 |  | 12
 |  | 13
 |  | 14
 |  | 15
 |  | 16
 |  | 17
 |  | 18
 |  | 19
 |  | 20 |  | 0:30:00
 |  | 21 |  | 0:11:00
 |  | 22 |  | 5:00:00
 |  | 23 |  | 1 day, 4:00:00
 |  | 24
 |  | 25
 |  | 26
 |  | 27
 |  | 28
 |  | 29
 |  | 30
 |  | 31
 |  | 32
 |  | 33
 |  | 34
 |  | 35
 |  | 36
 |  | 37
 |  | 38
 |  | 39
Total
Spreadsheet: 872610d1718978262-pull-data-from-4-lists-and-group-into-one-excel-help-list
Sheet: Sheet1

List 1 |  |  | List 2 |  |  | List 3 |  |  | List 4 |  |  | output list needed
name | add to output list |  | name | add to output list |  | name | add to output list |  | name | add to output list
red |  |  | fish |  |  | tv |  |  | cactus |  |  | blue
blue | x |  | cow | x |  | clock |  |  | flower | x |  | white
orange |  |  | rabbit |  |  | cushion |  |  | soil | x |  | cow
black |  |  | kangaroo |  |  | cup | x |  | dirt |  |  | bird
grey |  |  | bird | x |  | table |  |  | digger |  |  | cup
white | x |  | penguin |  |  | carpet |  |  | house plant | x |  | flower
 |  |  |  |  |  |  |  |  |  |  |  | soil
Spreadsheet: 468272d1467211421-time-to-assign-qualify-meals-for-trip-sampledailymeals
Sheet: Form

Traveller input date and time (maximum up to 9 days). The date and time will be populated in the Meal Calculator
table below where each date and time will be assigned to in each column. It will identify whether BF, [NAME], and DI is payable to the traveller.
Date between [NAME] and Return will be labeled as 12:00 AM to represent the whole day.
Parameter |  |  |  |  |  |  | Cut Off Time
Travel depart before or at 7:00 am and arrive before 12:00 pm = BF |  |  |  |  |  |  | 07:00:00
Travel depart after 7:00 am and arrive before 12:00 pm = $0.00 breakfast
Travel depart before or at 12:00 pm and arrive before 7:00 pm = [NAME] |  |  |  |  |  |  | 12:00:00
Travel depart after 12:00 pm and arrive before 7:00 pm = $0.00 lunch
Travel arrive after 7:00 PM = DI |  |  |  |  |  |  | 19:00:00
Travel arrive before 7:00 PM = $0.00 dinner
Travel Itinerary: | Date | Time
[NAME]: | 2016-01-02 00:00:00 | 22:00:00
Return: | 2016-01-04 00:00:00 | 14:00:00 |  |  |  | Are you claiming Meals? | Yes | (Yes or No answer)
 | [NAME]/dd/yyyy | h:[NAME]
Meal Calculator
Dates
Meals          Time
Breakfast
Lunch
Dinner
[NAME] not populating correctly.
B24 should show DI, arrive after 7 pm
[NAME] should show 0 and not DI because return at 2 pm which is befor 7 pm
Two Questions:
1. Current formula not able to identify correctly the departure and returning time that qualify for meals type.
All formula is in the same structure/format and the only different is pointing to the different Cut Off Time for each meals.
Suspect something is missing from the formula and don't know how to correct it.
2. What is the best format for time in between [NAME] and Return to identify as whole day qualify for all 3 meals?
Issue arrise when traveller returning at 12:00 AM and should not get all 3 meals. Or it does not matter depending on the formula structure in question 1.
Spreadsheet: 77444d1277912916-finding-lowest-cost-price-with-multiple-criteria-lowest-cost-price-example2
Sheet: Pricing (FOB & Landed)

Part Code | Supplier | Supplier Location | $FOB
AAA1 | factory a | xiamen | 5
AAA1 | factory b | xiamen | 10
AAA1 | factory c | xiamen | 15
AAA1 | factory d | shenzhen | 5
AAA1 | factory e | shenzhen | 10
AAA1 | factory f | shenzhen | 15
BBB1 | factory a | xiamen | 8
BBB1 | factory b | xiamen | 10
BBB1 | factory c | xiamen | 15
BBB1 | factory d | shenzhen | 5
BBB1 | factory e | shenzhen | 10
BBB1 | factory f | shenzhen | 15
Spreadsheet: 692399d1598305226-combination-of-sumproduct-and-index-match-to-sum-all-positive-numbers-excelforum
Sheet: SalesAnalysis

Stock Sales By Period
NZ UNIFORMS LIMITED
System Date: | 2020-08-23 00:00:00
Product: 10KBIBS---------NVYFOR---18-   to   ZSPONS  All Locations (Excluding Location'00')  Sales Group: 'ROL'
 |  |  | 1st | 1st | 1st | 2nd | 2nd | 2nd | 3rd | 3rd | 3rd | 4th | 4th | 4th
Product Code | Description | In Stock | Aug 2019 | Sep 2019 | Oct 2019 | Nov 2019 | Dec 2019 | Jan 2020 | Feb 2020 | Mar 2020 | Apr 2020 | May 2020 | Jun 2020 | Jul 2020 | TOTAL
ACEROLRBS/KB----NVY------12- | Rolleston College Rugby Shorts Navy 12 | 14 | 1 |  | -5 |  | 1 | 9 | 1 |  |  | 2
ACEROLRBS/KB----NVY------14- | Rolleston College Rugby Shorts Navy 14 | 23 |  |  | 1 |  |  | 8
ACEROLRBS/KB----NVY------2XL | Rolleston College Rugby Shorts Navy 2XL | 10 |  |  |  |  | 1 |  |  |  |  | 1 | -3
ACEROLRBS/KB----NVY------3XL | Rolleston College Rugby Shorts Navy 3XL | 6 |  |  |  |  |  | 1
ACEROLRBS/KB----NVY------L-- | Rolleston College Rugby Shorts Navy L | 31 | -3 |  |  |  |  | 18 | -5
ACEROLRBS/KB----NVY------M-- | Rolleston College Rugby Shorts Navy M | 33 |  |  |  |  | 6 | 4 |  | 1
ACEROLRBS/KB----NVY------S-- | Rolleston College Rugby Shorts Navy S | 8 | 1 |  |  |  | 3 | 26 | 5 |  |  |  | 1 | 1
ACEROLRBS/KB----NVY------XL- | Rolleston College Rugby Shorts Navy XL | 5 | 1 |  | 2 |  |  | 7 | 1 |  |  |  | 1
ACEROLRBS/KB----NVY------XS- | Rolleston College Rugby Shorts Navy XS | 27 |  |  |  |  |  | 8 |  |  |  |  |  | -1
Spreadsheet: 328842d1404114614-formula-not-working-to-convert-state-names-to-abbreviations-sample2
Sheet: Sheet1

 |  |  |  | State |  |  | Alabama | AL
 |  |  |  | Florida |  |  | Alaska | AK
 |  |  |  | Florida |  |  | Arizona | AZ
 |  |  |  | Florida |  |  | Arkansas | AR
 |  |  |  | Arizona |  |  | California | CA
 |  |  |  | Oklahoma |  |  | Colorado | CO
 |  |  |  | Arkansas |  |  | Connecticut | CT
 |  |  |  | Illinois |  |  | Delaware | DE
 |  |  |  | Arkansas |  |  | Florida | FL
 |  |  |  | Arkansas |  |  | Georgia | GA
 |  |  |  | Missouri |  |  | Hawaii | HI
 |  |  |  | Oklahoma |  |  | Idaho | ID
 |  |  |  | Missouri |  |  | Illinois | IL
 |  |  |  | Kansas |  |  | Indiana | IN
 |  |  |  | Arkansas |  |  | Iowa | IA
 |  |  |  | Oklahoma |  |  | Kansas | KS
 |  |  |  | Arizona |  |  | Kentucky | KY
 |  |  |  | Oklahoma |  |  | Louisiana | LA
 |  |  |  | Arizona |  |  | Maine | ME
 |  |  |  | Missouri |  |  | Maryland | MD
 |  |  |  | Illinois |  |  | Massachusetts | MA
 |  |  |  | Missouri |  |  | Michigan | MI
 |  |  |  | Illinois |  |  | Minnesota | MN
 |  |  |  |  |  |  | Mississippi | MS
 |  |  |  |  |  |  | Missouri | MO
 |  |  |  |  |  |  | Montana | MT
 |  |  |  |  |  |  | Nebraska | NE
 |  |  |  |  |  |  | Nevada | NV
 |  |  |  |  |  |  | New Hampshire | NH
 |  |  |  |  |  |  | New Jersey | NJ
 |  |  |  |  |  |  | New Mexico | NM
 |  |  |  |  |  |  | New York | NY
 |  |  |  |  |  |  | North Carolina | NC
 |  |  |  |  |  |  | North Dakota | ND
 |  |  |  |  |  |  | Ohio | OH
 |  |  |  |  |  |  | Oklahoma | OK
 |  |  |  |  |  |  | Oregon | OR
 |  |  |  |  |  |  | Pennsylvania | PA
 |  |  |  |  |  |  | Rhode Island | RI
 |  |  |  |  |  |  | South Carolina | SC
 |  |  |  |  |  |  | South Dakota | SD
 |  |  |  |  |  |  | Tennessee | TN
 |  |  |  |  |  |  | Texas | TX
 |  |  |  |  |  |  | Utah | UT
 |  |  |  |  |  |  | Vermont | VT
 |  |  |  |  |  |  | Virginia | VA
 |  |  |  |  |  |  | Washington | WA
 |  |  |  |  |  |  | West Virginia | WV
 |  |  |  |  |  |  | Wisconsin | WI
 |  |  |  |  |  |  | Wyoming | WY
Spreadsheet: 794118d1661885286-calculate-number-of-days-between-two-dates-that-are-formatted-like-6-30-2021-16-05-sample
Sheet: Original

 | Date & time (PointClickCare software) | # of days
 | 8/11/2021 22:34
 | 8/4/2021 22:30
 | 7/1/2021 22:56
 | 6/30/2021 16:05
 | 5/5/2021 16:30
 | 4/21/2021 21:01
 | 4/7/2021 21:18
 | 4/7/2021 21:18
 | 3/17/2021 10:09
 | 2/10/2021 16:25
 | 2/4/2021 01:19
 | 1/31/2021 16:10
 | 1/31/2021 11:18
 | 1/4/2021 14:35
 | 1/4/2021 14:34
 | 12/7/2020 21:22
 | 11/4/2020 15:09
Original data:
I copied dates (with hours and minutes) from PointClickCare software and pasted it into this Excel sheet in column B.
Excel does not seem to recognize the format of column B data as dates with hours and minutes.
If I try to calculate the number of days between two dates, I get a #[NAME] error.
Spreadsheet: 726426d1617224403-data-validation-formula-to-list-all-associated-employers-based-on-two-source-ids-book2
Sheet: Employer

REF # | ID |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | business address
913075200 | 61298249 |  |  |  |  |  |  |  |  |  |  |  | 882344620 | BOWLING INC | 1355 AREWE THERE YET RD |  |  | BIRMINGHAM | AL | 76766
913075200 | 61298249 |  |  |  |  |  |  |  |  |  |  |  | 982538297 | [NAME] | 32673 E SOMEWERE RD |  |  | PAW PAW | MI | 49079
913075200 | 61298249 |  |  |  |  |  |  |  |  |  |  |  | 621822806 | UNEMPLOYMENT INSURANCE AGENCY | 44455 OURWE THERE YET RD. |  |  | DETROIT | MI | 48202
786666544 | 6169975 |  |  |  |  |  |  |  |  |  |  |  | 780629973 | 32673 E RED BEER HWY | 7301 PARKED WRONG DR |  |  | HANOVER | MD | 21076
913075200 | 61298249 |  |  |  |  |  |  |  |  |  |  |  | 710754409 | I'M BROKE CASINO | 11111 WILSON CARD RD |  |  | NEW BUFFALO | MI | 49117
913075200 | 61298249 |  |  |  |  |  |  |  |  |  |  |  | 382348620 | WALMART | 7775 SESAME ST. |  |  | BENTONVILLE | AR | 72716
913256070 | 61298249 |  |  |  |  |  |  |  |  |  |  |  | 982538297 | [NAME] | 32673 E SOMEWERE RD |  |  | PAW PAW | MI | 49079
913256070 | 61298249 |  |  |  |  |  |  |  |  |  |  |  | 621822806 | UNEMPLOYMENT INSURANCE AGENCY | 44455 OURWE THERE YET RD. |  |  | DETROIT | MI | 48202
909090 | 73598350 |  |  |  |  |  |  |  |  |  |  |  | 780629973 | 32673 E RED BEER HWY | 7301 PARKED WRONG DR |  |  | HANOVER | MD | 21076
913256070 | 61298249 |  |  |  |  |  |  |  |  |  |  |  | 710754409 | I'M BROKE CASINO | 11111 WILSON CARD RD |  |  | NEW BUFFALO | MI | 49117
913256070 | 61298249 |  |  |  |  |  |  |  |  |  |  |  | 382348620 | WALMART | 7775 SESAME ST. |  |  | BENTONVILLE | AR | 72716
913256070 | 61298249 |  |  |  |  |  |  |  |  |  |  |  | 710796611 | IMAKE STUFF GROUP INC | 32673 E RED BEER HWY
Spreadsheet: 105922d1303205327-count-formula-book1
Sheet: Sheet1

 | Status 1 | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A | A
Formula Condition`s | Status 2 | B | B | B | B | B | B | B | B | B | B | B | B | B | B | B | B | B | B | B | B | B | B | B | B | B | B | B | B | B | B | B | B | B | B | B | B | B | B | B | B
For Status 1, I need to write a formula to count "A" from ([NAME]) and highlight the cell count equal 30, which is (AF5)
For Status 2, I need to write a formula to count "B" from (C4:AP4) and highlight the cell count equal 40, which is (AP6)
For Status 1, I need to write a formula to count "A" from ([NAME]) and highlight the cell count equal 15, which is (Q7)
Note:No need to add any extra data to this sheet, it should be remain as it is.
Spreadsheet: 0d288fa0-47e1-4731-a35b-3ac5604ac05b
Sheet: Sheet1

Breakaway Bicycle Company, Inc. | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
Bilan - 31 Décembre 2000
[NAME]
[NAME] à court terme:
Espèces |  |  |  |  | 50000
Comptes débiteurs |  |  | 20000
Moins: Provisions pour Cr | Provision pour Créances Douteuses |  | 5000 |  | 15000
Stock de Marchandises |  |  |  |  | 5000
[NAME] payés d'avance |  |  |  |  | 500
Effets à recevoir |  |  |  |  | 0
 | Total des Actifs à court terme |  |  |  |  |  | 70500
Immobilisations:
Véhicules |  |  | 15000
Moins: | Amortissement Cumulé |  | 15000 |  | 0
Mobilier et Agencements |  |  | 15000
Moins: | Amortissement Cumulé |  | 5000 |  | 10000
Equipement |  |  | 100000
Moins: | Amortissement Cumulé |  | 48000 |  | 52000
 | Total des Immobilisations |  |  |  |  |  | 62000
[NAME]:
Fonds Commercial |  |  |  |  | 0
 | Total des Autres [NAME] |  |  |  |  |  | 0
Total de l'Actif |  |  |  |  |  |  | 132500
 | Passif et Capital
Passif à court terme:
[NAME] |  |  |  |  | 4200
Taxes de Vente Exigibile |  |  |  |  | 2000
Charges Sociales Exigibles |  |  |  |  | 1523
Rémunérations Accumulées Exigibles |  |  |  |  | 4125
[NAME] |  |  |  |  | 20000
 | Total du Passif à court terme |  |  |  |  |  | 31848
Passif à long terme:
Effets à Payer à long terme |  |  |  |  | 0
Emprunt Hypothécaire |  |  |  |  | 0
 | Total du Passif à long terme |  |  |  |  |  | 0
Total du Passif |  |  |  |  |  |  | 31848
Capital:
[NAME] |  |  |  |  | 100652
Total du Capital |  |  |  |  |  |  | 100652
Total du Passif et du Capital |  |  |  |  |  |  | 132500
0