tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 668500d1584879993-how-to-extract-specific-hourly-rows-based-on-the-maximum-daily-value-in-a-column-book1
Sheet: sheet1

DAY | HOUR | Counter A | Counter B | Counter C | Counter D | Flag |  |  |  |  |  |  | Flag | x
2020-03-09 00:00:00 | 00:00:00 | 28 | 18 | 45 | 34
 | 01:00:00 | 21 | 45 | 25 | 21 |  |  | [NAME] | [NAME] |  |  |  |  |  | Valori
 | 02:00:00 | 41 | 31 | 31 | 10 |  |  | 2020-03-09 00:00:00 | 50 |  |  |  | DAY | HOUR | Somma di Counter A | Somma di Counter B | Somma di Counter C | Somma di Counter C2
 | 03:00:00 | 46 | 44 | 38 | 50 |  |  | 2020-03-10 00:00:00 | 47 |  |  |  | 2020-03-09 00:00:00 | 14:00:00 | 24 | 15 | 50 | 35
 | 04:00:00 | 30 | 11 | 30 | 34 |  |  | Totale complessivo | 50 |  |  |  | 2020-03-10 00:00:00 | 07:00:00 | 29 | 25 | 47 | 14
 | 05:00:00 | 47 | 19 | 24 | 24
 | 06:00:00 | 20 | 35 | 36 | 49
 | 07:00:00 | 24 | 35 | 32 | 26
 | 08:00:00 | 11 | 44 | 43 | 24
 | 09:00:00 | 50 | 21 | 41 | 26
 | 10:00:00 | 27 | 14 | 26 | 40
 | 11:00:00 | 21 | 46 | 18 | 31
 | 12:00:00 | 24 | 10 | 34 | 41
 | 13:00:00 | 37 | 40 | 40 | 11
 | 14:00:00 | 24 | 15 | 50 | 35
 | 15:00:00 | 42 | 18 | 21 | 38
 | 16:00:00 | 50 | 17 | 11 | 37
 | 17:00:00 | 40 | 32 | 17 | 49
 | 18:00:00 | 11 | 37 | 40 | 12
 | 19:00:00 | 30 | 32 | 28 | 15
 | 20:00:00 | 38 | 21 | 20 | 32
 | 21:00:00 | 22 | 23 | 43 | 30
 | 22:00:00 | 43 | 15 | 24 | 46
 | 23:00:00 | 34 | 33 | 17 | 46
2020-03-10 00:00:00 | 00:00:00 | 13 | 43 | 23 | 28
 | 01:00:00 | 16 | 27 | 20 | 18
 | 02:00:00 | 30 | 36 | 31 | 11
 | 03:00:00 | 46 | 17 | 10 | 16
 | 04:00:00 | 44 | 26 | 41 | 27
 | 05:00:00 | 34 | 35 | 15 | 30
 | 06:00:00 | 42 | 25 | 40 | 41
 | 07:00:00 | 29 | 25 | 47 | 14
 | 08:00:00 | 46 | 36 | 24 | 31
 | 09:00:00 | 14 | 14 | 15 | 15
 | 10:00:00 | 28 | 21 | 18 | 22
 | 11:00:00 | 32 | 41 | 30 | 23
 | 12:00:00 | 15 | 39 | 13 | 17
 | 13:00:00 | 31 | 17 | 27 | 45
 | 14:00:00 | 31 | 21 | 21 | 35
 | 15:00:00 | 45 | 11 | 14 | 14
 | 16:00:00 | 15 | 14 | 14 | 44
 | 17:00:00 | 16 | 23 | 34 | 46
 | 18:00:00 | 34 | 43 | 14 | 30
 | 19:00:00 | 32 | 21 | 22 | 49
 | 20:00:00 | 23 | 46 | 28 | 46
 | 21:00:00 | 45 | 38 | 10 | 47
 | 22:00:00 | 36 | 10 | 27 | 48
 | 23:00:00 | 22 | 36 | 33 | 42
Spreadsheet: 794674d1662208029-dynamic-array-formula-to-indicate-which-rows-are-visible-and-which-are-not-2022-09-03-oeldere-marbleking-test_visibility_of_rows
Sheet: Sheet1

Helper | Data |  |  |  | Test
1 | 1
1 | 2
1 | 3
1 | 4
1 | 5
1 | 6
1 | 7
1 | 8
1 | 9
1 | 10
Spreadsheet: 886688d1736787411-extracting-column-header-relationships-repertory-data-test
Sheet: Reportorization

 | Bay leaf | Natrum flouratum | Oak | Wych Elm | Clay | [NAME] | Blue | Sea Holly | Conium | Rainbow | Ayahuasca | Viscum album | Sea Salt | Sandalwood
Addiction |  |  |  | 1 |  |  |  |  | 1
Allergies | 1 | 1 | 1 |  | 1 |  |  |  |  |  | 1 |  | 1
Arthritis | 1 |  |  |  | 1 |  | 1 | 1
Autism | 1 | 1 |  | 1 |  |  |  |  |  |  | 1
Dizziness |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 1
Domination |  |  |  |  |  |  |  |  | 1 |  |  | 1
Dryness | 1 |  |  |  | 1 |  |  |  | 1
Eating disorders |  |  |  | 1 |  |  |  | 1
Ego |  |  |  |  |  |  |  | 1 | 1
Exhaustion | 1 |  |  | 1
Gallstones |  |  | 1 |  | 1 |  |  | 1
Grounding |  | 1 | 1
Lethargy | 1 |  |  | 1 | 1 | 1 | 1 |  | 1 |  |  |  | 1
Miasms-Petrochemical |  |  | 1 |  |  |  |  |  |  | 1 |  |  | 1
[NAME], exposes |  |  |  |  |  | 1 |  |  |  | 1
Migraines |  | 1 | 1 |  |  |  |  |  |  |  |  | 1
Parkinson's |  | 1 |  |  |  |  |  |  |  |  |  | 1
Radiation-general |  | 1 |  | 1 | 1 | 1 |  | 1 |  | 1 | 1 |  | 1
Radiation-Miasm |  | 1 |  |  |  |  |  |  |  | 1
Sexual balancing |  |  | 1 |  |  | 1 | 1
Stoic | 1 |  | 1 |  |  |  |  | 1
Stress |  | 1 | 1 |  |  |  | 1 |  |  |  |  |  |  | 1
Transitions | 1 | 1 |  | 1 |  | 1 |  | 1 | 1 |  | 1 |  |  | 1
Vaccination |  | 1 |  | 1 | 1 | 1 |  |  |  | 1 |  | 1 | 1
Eyes | 1 |  | 1 |  |  | 1 | 1 | 1 | 1 | 1 | 1 |  |  | 1
Gall bladder |  | 1 | 1 |  | 1
Head | 1 | 1 |  | 1
Liver | 1 |  | 1 |  | 1 | 1
Male organs |  |  | 1 |  |  |  | 1 |  | 1
Pancreas | 1 |  |  |  |  |  |  |  | 1 |  |  | 1
Anger |  |  | 1 |  | 1 |  | 1 |  |  |  |  |  | 1 | 1
Aura, heals and seals |  |  | 1 | 1 |  |  |  |  |  | 1 | 1 |  |  | 1
Catarrh | 1 |  |  |  | 1 |  |  |  |  |  | 1 | 1
Cleansing |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  | 1 | 1 | 1 | 1 | 1
Curses and Spells |  |  |  | 1 |  |  |  |  |  |  | 1
Depression |  | 1 |  |  | 1 | 1 | 1 |  | 1 | 1 |  | 1 | 1
Diabetes | 1 |  |  |  | 1 |  |  |  |  |  |  | 1
Drugs, recreational | 1 |  |  |  |  | 1 | 1 |  |  | 1
Guilt |  |  |  |  |  | 1 | 1 |  |  |  |  |  | 1
Grief |  |  | 1 |  |  |  | 1 | 1 | 1 |  | 1 |  |  | 1
ME (fatigue) | 1 | 1 |  | 1 | 1 | 1 | 1 |  |  |  | 1
[NAME] |  | 1 | 1 |  |  |  |  |  |  | 1 |  |  | 1 | 1
Miasm - Sycotic |  |  | 1 |  | 1 | 1 |  | 1 | 1 | 1
Miasm - Syphilitic | 1 | 1 | 1 |  |  | 1 |  |  | 1 | 1 | 1
Miasm - Tubercular |  |  | 1 |  |  |  | 1 | 1 |  | 1 |  | 1
Protection | 1 |  |  | 1 |  | 1
Self-esteem, lacking |  |  |  |  |  | 1 | 1 |  | 1 |  |  | 1
Pineal |  |  |  |  |  |  |  | 1 |  | 1 |  | 1
Pituitary | 1 | 1 |  |  | 1 |  | 1 |  |  | 1 |  | 1
Spine |  | 1 | 1 | 1 |  |  |  |  |  |  |  |  |  | 1
Spleen | 1 |  | 1 |  | 1
[NAME] |  | 1 |  |  | 1 | 1
Thyroid | 1 |  |  |  |  |  | 1 |  |  |  |  |  | 1
Circulatory | 1 |  |  | 1 |  | 1 | 1 | 1 | 1 |  | 1 |  |  | 1
Digestive | 1 |  |  |  | 1 |  |  |  |  |  | 1
Nervous | 1 | 1 |  | 1 |  | 1 | 1 |  |  |  |  | 1 |  | 1
Urinary |  | 1 | 1 |  | 1 |  |  | 1 |  |  |  | 1 | 1 | 1
Endocrine | 1 |  | 1 | 1 |  |  |  | 1 | 1
Spreadsheet: 883896d1732652310-formula-to-repeat-a-set-of-values-in-a-column-when-user-enters-a-records-template_1
Sheet: Sheet1

User Entry | Item
1 | [NAME]
1 | Keyboard
1 | Speaker
1 | Wires
1 | Adapter
1 | Monitor
1 | Headphone
1 | Webcam
2 | [NAME]
2 | Keyboard
2 | Speaker
2 | Wires
2 | Adapter
2 | Monitor
2 | Headphone
2 | Webcam
3 | [NAME]
3 | Keyboard
3 | Speaker
3 | Wires
3 | Adapter
3 | Monitor
3 | Headphone
3 | Webcam
Spreadsheet: 92727d1292278109-scroll-bar-wont-stop-scrolling-scroll-bar-example-working
Sheet: apr_data

employee # | area | sales $
1111 | east | 64432.61106667732
1112 | east | 4926.653776479295
1113 | east | 49565.52042202693
1114 | east | 56743.51354559626
1115 | west | 82510.13844024691
1116 | west | 85874.65087165296
1117 | west | 67587.71393526475
1118 | northeast | 74447.31932932144
1119 | northeast | 96305.89694023275
1120 | northeast | 2220.114182787647
1121 | northeast | 46937.25436369034
1122 | northeast | 90833.02191907894
1123 | northwest | 37680.92473855162
1124 | northwest | 98536.27719762761
1125 | northwest | 13190.52619163097
1126 | southeast | 91076.69841546351
1127 | southeast | 29296.38381994391
1128 | southeast | 32777.74932641035
1129 | southeast | 9827.028682930839
1130 | southeast | 81429.92436302787
1131 | southeast | 28016.47603900408
1132 | southwest | 92198.29462440785
1133 | southwest | 84181.12072313395
1134 | southwest | 71306.50081417817
1135 | midwest | 80811.91978568283
1136 | midwest | 67638.79071969315
1137 | midwest | 94217.72595712976
Spreadsheet: rick_buy__32741__Base_ERatings_053001_all countries
Sheet: Methodology

 | Methodology to update E-rating
 | Source | Where to collect info | Frequency | Data to update | Cost
 | S&P | e-source* (web) | as of | foreign currency rating | -
 | Moody's | e-source* (web) | as of | foreign long-term bonds and notes rating | -
 | [NAME] | www.fitchibca.com | as of | long-term foreign currency | -
 | International Country Risk | e-source* CD-Rom | monthly | Political /Financial/ Economic current ratings | -
 | Political Risk Letter | esource (PRS Group) | monthly | short and long term transfer/ investment/ export | 50
 | EIU | RAC order to e-source | quarterly |  | 98
 | Institutional Investor | www.iimagazine.com | March / September | Need to subscribe free user name and password | -
 | Euromoney | Research** | [NAME] | Rank, Score, [NAME], Econ Perf., debt indicators | 50
 | OPIC | www.opic.gov | as of | Country and area list | -
 | IMF Exchange Arrangements | Research** | March / October | update exchange arrangements | 95
 | Real GDP Growth | www.imf.org/external/pubs/ft/weo/ or http://www.iif.com/members/Reports/469report.pdf  or Political Risk Letter | Yearly for weo and periodically updated per country for iif | update yearly real GDP growth / choose the most updated version between weo and iif | -
 | Currency | www.bloomberg.com or IMF or http://pacific.commerce.ubc.ca/xr/currency_list.html#W | as of | update name of currencies | -
 | *Contact Esource - Cindy Irvin @34558
 | **Contact [NAME]
 |  |  |  |  |  |  | Scale for PRS Pol. Risk Letter
 |  |  |  |  |  |  | A+ | 10
 |  |  |  |  |  |  | A | 9
 |  |  |  |  |  |  | A- | 8
 |  |  |  |  |  |  | [NAME] | 7
 |  |  |  |  |  |  | B | 6
 |  |  |  |  |  |  | B- | 5
 |  |  |  |  |  |  | C+ | 4
 |  |  |  |  |  |  | C | 3
 |  |  |  |  |  |  | C- | 2
 |  |  |  |  |  |  | [NAME] | 1
 |  |  |  |  |  |  | D | 0
 |  |  |  |  |  |  | D- | -1
Spreadsheet: 125067d1318861548-time-formula-breaks-with-multiple-ins-per-day-test4
Sheet: Time Keeping

Week of | 2011-10-12 00:00:00 | [NAME] |  |  |  |  |  |  |  | Comments:
 | Clock-In Count | 2
 | In | 05:01:00
 | Out | 10:58:00
2011-10-12 00:00:00 | In | 12:05:00
2011-10-12 00:00:00 | Out | 14:06:00
 | job-
 | Lunch | 01:07:00
 | Hours | 07:58:00
 | Clock-In Count | 1
 | In | 06:17:00
 | Out
2011-10-13 00:00:00 | In
2011-10-13 00:00:00 | Out | 11:04:00
 | job-
 | Lunch
 | Hours | 04:47:00
 | Clock-In Count | 1
 | In | 07:03:00
 | Out
2011-10-14 00:00:00 | In
2011-10-14 00:00:00 | Out
 | job-
 | Lunch
 | Hours | 1900-01-01 00:00:00
 | Clock-In Count | 0
 | In | off
 | Out
2011-10-17 00:00:00 | In
2011-10-17 00:00:00 | Out
 | job-
 | Lunch
 | Hours | 1900-01-01 00:00:00
 | Clock-In Count | 0
 | In | off
 | Out
2011-10-18 00:00:00 | In
2011-10-18 00:00:00 | Out
 | job-
 | Lunch
 | Hours | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
 | Deciaml Time | 12.75 | #N/A | 0 | 0 | 0 | 0 | 0 | 0
 | Hours Total | 12:45:00 | #N/A | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00 | 1900-01-01 00:00:00
 | Hours Left | 1904-01-02 03:15:00 | #N/A | 1904-01-02 16:00:00 | 1904-01-02 16:00:00 | 1904-01-02 16:00:00 | 1904-01-02 16:00:00 | 1904-01-02 16:00:00 | 1904-01-02 16:00:00
Spreadsheet: 866575d1713484987-not-transferring-employee-names-to-main-sheets-employee-absence-schedule
Sheet: November

 | Employee absence schedule
 | November
 | Absence type key | V | Vacation |  |  | P | Personal |  |  | S | Sick |  |  | Custom 1 |  |  |  | Custom 2
 |  | Dates of absence
 | Employee name | 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 |  | Total days
 | [NAME]
 | [NAME]
 | Asaf Karten
 | [NAME]
 | [NAME]
Spreadsheet: 829577d1684321498-collect-data-from-other-sheets-based-on-periods-sample-138-aligw
Sheet: Sum

Period | Project Name | Total | [NAME]?
Jan | Project 1
Feb | Project 1
Mar | Project 1
Apr | Project 1
May | Project 1
Jun | Project 1
Jul | Project 1
Aug | Project 1
Sep | Project 1
Oct | Project 1
Nov | Project 1
Dec | Project 1
Jan | Project 2
Feb | Project 2
Mar | Project 2
Apr | Project 2
May | Project 2
Jun | Project 2
Jul | Project 2
Aug | Project 2
Sep | Project 2
Oct | Project 2
Nov | Project 2
Dec | Project 2
Spreadsheet: 787047d1657618313-formula-to-calculate-risk-formula-help
Sheet: Sheet1

With Date | Lead time | Stock Level | Cover | 2 month stock cover date | Expected Stock Out Date | Delivery Date | What this should be
 | 5 | 0 | 0 | 2022-05-13 00:00:00 | 2022-07-12 00:00:00 | 2022-07-29 00:00:00 | Out of Stock
 | 5 | 2000 | 4 | 2022-09-10 00:00:00 | 2022-11-09 00:00:00 | 2022-09-03 00:00:00 | Good Stock Level
 | 5 | 2000 | 8 | 2022-09-10 00:00:00 | 2022-11-09 00:00:00 | 2022-09-03 00:00:00 | Good Stock Level
 | 5 | 500 | 1 | 2022-06-12 00:00:00 | 2022-08-11 00:00:00 | 2022-09-03 00:00:00 | Will Go OOS
 | 5 | 1000 | 2 | 2022-07-12 00:00:00 | 2022-09-10 00:00:00 | 2022-08-24 00:00:00 | Risk of OOS
No Date | Lead time | Stock Level | Cover | 2 month stock cover date | Expected Stock Out Date | Delivery Date | What this should be
 | 5 | 0 | 0 | 2022-05-13 00:00:00 | 2022-07-12 00:00:00 |  | Out of Stock
 | 5 | 2000 | 4 | 2022-09-10 00:00:00 | 2022-11-09 00:00:00 |  | Will Go OOS
 | 5 | 2000 | 8 | 2022-09-10 00:00:00 | 2022-11-09 00:00:00 |  | Good Stock Level
 | 5 | 500 | 1 | 2022-06-12 00:00:00 | 2022-08-11 00:00:00 |  | Will Go OOS
 | 5 | 1000 | 2 | 2022-07-12 00:00:00 | 2022-09-10 00:00:00 |  | Will Go OOS
Rule | Status
if Stock Level = 0 | Out of stock
if cover is higher than lead time +2 | Good stock level
if delivery date is after expected stock out date | Will go OOS
if delivery date is after the 2 month stock cover date | Risk of OOS
Spreadsheet: 041e7a13-75ec-4fa0-8bef-e29956844fa5
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
BRAFM | Test | BRAFM | BRAF Mutation Analysis (V600), Melanoma | BRAF Mutation AnalysisV600 Melanoma | Polymerase Chain Reaction (PCR) Analysis (PCR is utilized pursuant to a license agreement with Roche Molecular Systems, Inc.) | Plastic container: PlCont |  |  |  |  | Pathology report must accompany specimen in order for testing to be performed.   Specimen Type: Tissue block or slide Collection Instructions: 1. Submit formalin-fixed, paraffin-embedded tissue block (preferred) or 1 slide stained with hematoxylin-and-eosin and 5 unstained, nonbaked slides (5-micron thick sections) of the tumor tissue. 2. Sections should contain both tumor and normal tissue. | Formalin-fixed, paraffin-embedde | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | An interpretative report will be provided. | Monday through Friday; Varies | 5 days | 7 days | 1 | 81210 |  |  |  |  | Rochester
BRAFM | [NAME] | VARIES | Varies |  |  |  | Ambient
BRAFM | Result | 34660 | [NAME] | [NAME] | Alphanumeric
BRAFM | Result | 34661 | [NAME] | [NAME] | Alphanumeric
BRAFM | Result | 34662 | Source | Source | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31208-2 | [NAME] source:Prid:Pt:[NAME]:Nom:
BRAFM | Result | 34663 | Order Date | Order Date | Alphanumeric
BRAFM | Result | 34664 | Reason For Referral | Reason For Referral | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42349-1 | Reason for referral:Find:Pt:^Patient:Nar:
BRAFM | Result | 34665 | Method | Method | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 49549-9 | Reference lab test method:Type:XXX:Reference lab test:Nar:
BRAFM | Result | 34666 | Result | Result | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
BRAFM | Result | 34667 | Interpretation | Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
BRAFM | Result | 34668 | Amendment | Amendment | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
BRAFM | Result | 34669 | Reviewed By: | Reviewed By: | Alphanumeric
BRAFM | Result | 34670 | Release Date | Release Date | Alphanumeric
BRAFM | [NAME] | SLRVW | Slide Review ([NAME] Only) | Slide Review |  |  |  |  |  |  | For billing purposes only. |  |  |  |  |  |  | 1 | 88381 |  |  | Yes | No
Spreadsheet: darrell_schoolcraft__7532__Eott Summary UAF Reports 2002
Sheet: Pearsall 

Pearsall Pipeline - Year 2001
 | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sept | Oct | Nov | Dec | Total
PEARSALL ([NAME]) 173129
Beginning Inventory | 43338.56
Receipts | 58091.47
Deliveries | 64820.64
Ending Inventory | 36947.66
Gain (Loss)-Bbls
Gain (Loss)- %
PMA's | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Adjusted G(L)-Bbls
Adjusted G(L)- %
PEARSALL (SOUR) 173130
Beginning Inventory | 7003.87
Receipts | 7016.78
Deliveries | 7684.43
Ending Inventory | 6737.6
Gain (Loss)-Bbls
Gain (Loss)- %
PMA's | 0 | 0 | 0 | -267.12 | 267.12 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Adjusted G(L)-Bbls
Adjusted G(L)- %
TOTAL PEARSALL
Beginning Inventory |  | 0
Receipts
Deliveries
Ending Inventory
Gain (Loss)-Bbls
Gain (Loss)- %
PMA's | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Adjusted G(L)-Bbls
Adjusted G(L)- %
Spreadsheet: 795785d1662939774-running-through-the-table-for-unique-security-code-and-date-security-code-hd-1-
Sheet: Sheet1

 | ID | Date | Security Code | Quantity |  |  |  |  | ID | Date | Security Code | Quantity
 | QTP11245 | 2022-09-11 00:00:00 | 6037569 | 800 |  |  |  |  | QTP11245 | 2022-09-11 00:00:00 | 6037569 | 800
 | QTP11245 | 2022-09-10 00:00:00 | 6037569 | 801 |  |  |  |  | QTP11245 | 2022-09-10 00:00:00 | 6037569 | 801
 | QTP11245 | 2022-09-12 00:00:00 | 6543346 | 9090 |  |  |  |  | QTP11245 | 2022-09-12 00:00:00 | 6543346 | 9090
 | QTP11245 | 2022-09-11 00:00:00 | 6543346 | 9090 |  |  |  |  | QTP11245 | 2022-09-11 00:00:00 | 6543346 | 9090
 | QTP11245 | 2022-09-12 00:00:00 | 7690043 | 9090 |  |  |  |  | QTP11245 | 2022-09-12 00:00:00 | 7690043 | 9090
 | QTP11246 | 2022-09-10 00:00:00 | 6672318 | 5567 |  |  |  |  | QTP11246 | 2022-09-10 00:00:00 | 6672318 | 5567
 | QTP11246 | 2022-09-08 00:00:00 | 6672318 | 5560 |  |  |  |  | QTP11246 | 2022-09-08 00:00:00 | 6672318 | 5560
 | QTP11247 | 2022-09-10 00:00:00 | 9802351 | 45776 |  |  |  |  | QTP11247 | 2022-09-10 00:00:00 | 9802351 | 45776
 | QTP11248 | 2022-09-12 00:00:00 | 1264988 | 12 |  |  |  |  | QTP11248 | 2022-09-12 00:00:00 | 1264988 | 12
 | QTP11248 | 2022-09-11 00:00:00 | 1264988 | 13 |  |  |  |  | QTP11248 | 2022-09-11 00:00:00 | 1264988 | 13
 | QTP11248 | 2022-09-12 00:00:00 | 4567209 | 100 |  |  |  |  | QTP11248 | 2022-09-12 00:00:00 | 4567209 | 100
 | QTP11248 | 2022-09-11 00:00:00 | 4567209 | 100 |  |  |  |  | QTP11248 | 2022-09-11 00:00:00 | 4567209 | 100
 | QTP11248 | 2022-09-10 00:00:00 | 4567209 | 100 |  |  |  |  | QTP11248 | 2022-09-10 00:00:00 | 4567209 | 100
 | QTP11249 | 2022-09-09 00:00:00 | 4567209 | 100 |  |  |  |  | QTP11249 | 2022-09-09 00:00:00 | 4567209 | 100
Spreadsheet: 744038d1628873470-minimum-out-put-from-2-inputs-example-1
Sheet: Sheet1

 | Quantity in M² | Price per M² | Total Price to the plasterer, must be min 5m²
OLD CODE that is currently being used
Plaster skim - per m² (minimum of total 5m²  for plastering) | 8 | 10
NEW CODES that I want to use
Plaster skim (Wall) - per m² (minimum of total 5m²  for plastering) | 1 | 10 |  | D6 and [NAME] should equal; 0, if 0 is entered in both B6 & B7  The output of B6 X C6 or B7 X C7, IF the total of [NAME] is greater than 5 5, If either [NAME] or [NAME] is equal to or greater than 1 but less than 5, however if B6 > 5 and D7 =0 then D6 needs to = 5 and D7=0 or vice versa. If both [NAME] or [NAME] are larger than 1 but the sum of [NAME] is less than 5 then the largest cell needs to be incresed so that the sum of [NAME] = 5.
Plaster skim (Ceiling) - per m² (minimum of total 5m²  for plastering) | 1 | 10
I have tried this formula in D6 --> but it just states false
Spreadsheet: 40281d1238587218-move-data-between-sheets-by-specifing-certain-criteria-order-2
Sheet: code2

Date: |  |  |  | Code: | 2 | Count:
Renfro Item | Description |  |  | SKU | Qty | Qty | Qty | Qty | Qty | Qty | Qty | Qty | Qty | Qty | Qty | Qty
Spreadsheet: 754413d1636147076-how-to-remove-alt-enter-from-an-excel-cell-addresses
Sheet: Address

Coluna1
Markayla Hobbs 826 Shelton Drive Albany, Georgia, 31705
[NAME]  634 Budleigh Circle  Lutherville, MD 21093
[NAME], 16414 [NAME], Charlotte, North Carolina 28277
[NAME] [NAME], Student Mail 70 Morningside Dr New York, NY 10027
[NAME]58 Snowdrop Tree, [NAME], CA, 92606
Ashlee p  7436 meadow st  Anchorage AK 99507
[NAME] Hickory Pointe Blvd  Ypsilanti, MI 48197
[NAME]2845 orchard grove court  [NAME], OH 44333
[NAME]17006 Blue Horizon  Elmendorf, TX 78112
[NAME]3322 Long Briar Ln Sugar Land, TX 77498
[NAME] S Church St Orange, CA, 92869
[NAME] [NAME], TX 75082
[NAME] S Church St Orange, CA, 92869
[NAME]3322 Long Briar Ln Sugar Land, TX 77498
[NAME]  609 Park Rd. Apt. 1 Sevierville, TN 37862
[NAME], 2201 SW 59TH TERRACE, RTABIZ-100011198, Florida, West Park, 33023
[NAME]1707 Ave D  Dodge City ,KS  67801
[NAME] 1304 Stanley Avenue Unit 5 Glendale, CA 91206 USA
Yik [NAME] 217 Centre st. #178 New York, NY 10013
Pk M 1211 Cook Ave E [NAME], MN 55106
[NAME]21503 Lone [NAME] [NAME], TX 77449
[NAME] 24th Ave Flushing, NY, 11357
[NAME] 469 West Elk Ave. [NAME], CA 91204
[NAME]252 Farrington Street Quincy, MA, 02170
S Akter 640 [NAME], New York, 11221
[NAME] 2920 N Union St Apt 5 [NAME], 54911
[NAME] 733 W Linden St. BLDG B Apartment B3300 Riverside, CA 92507 USA
[NAME] 51 NW 132 PL Miami, FL 33182
[NAME], 16414 [NAME], Charlotte, North Carolina 28277
[NAME]145 Pine View Dr [NAME], WI 53704
Markayla Hobbs 826 Shelton Drive Albany, Georgia, 31705
[NAME]7666 172nd St. Flushing, NY 11366
[NAME] [NAME], Student Mail 70 Morningside Dr New York, NY 10027
Ashlee p  7436 meadow st  Anchorage Al 99507
[NAME]3322 Long Briar Ln Sugar Land, TX 77498
[NAME] S Church St Orange, CA, 92869
2508 Kings Dr  Edinburg, Texas 78539
[NAME] Hickory Pointe Blvd, Ypsilanti, MI 48197
[NAME] S Church St Orange, CA, 92869
[NAME]17006 Blue Horizon  Elemendorf, TX 78112
[NAME] S Church St Orange, CA, 92869
[NAME]58 Snowdrop Tree,  [NAME], CA, 92606
[NAME] [NAME], TX 75082
[NAME] 609 Park Rd. Apt. 1 Sevierville, TN 37862
[NAME]1707 Ave D  Dodge City, KS 67801
[NAME], 2201 SW 59TH TERRACE, RTABIZ-100011198, Florida, West Park, 33023
[NAME]2845 orchard grove court  [NAME], OH 44333
[NAME] 1304 Stanley Avenue Unit 5 Glendale, CA 91206 USA
Pk M 1211 Cook Ave E [NAME], MN 55106
Yik [NAME] 217 Centre st. #178 New York, NY 10013
15767 24th Ave, flushing, ny, 11357
[NAME] 50 Young St. Quincy,MA 02171
yasmeen h 1534 chandlee ave panama city, FL 32405
[NAME] 469 West Elk Ave. [NAME], CA 9104
S Akter 640 [NAME], New York, 11221
[NAME] 2920 N Union St Apt 5 [NAME], 54911
[NAME] 733 W Linden St. BLDG B Apartment B3300 Riverside, CA 92507 USA
[NAME] 51 NW 132 PL Miami, FL 33182