tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: b77dda66-6ba6-4b55-b370-77a8db6fd0e4
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
CREAZ | Test | CREAZ | Creatinine with Estimated GFR (MDRD), Serum | Creatinine with eGFR, S | Enzymatic Colorimetic Assay Also available as part of an electrolyte panel. | Serum Gel Tube: SGT AND |  |  | 0.5 | mL | Container/Tube:  Preferred: Serum gel Acceptable: Red top [NAME]: 0.5 mL Collection Instructions: Fasting Additional Information: Patient's age and sex are required. | 0.25 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	NA Icterus	NA Other	NA | CREATININE Males 1-2 years: 0.1-0.4 mg/dL 3-4 years: 0.1-0.5 mg/dL 5-9 years: 0.2-0.6 mg/dL 10-11 years: 0.3-0.7 mg/dL 12-13 years: 0.4-0.8 mg/dL 14-15 years: 0.5-0.9 mg/dL > or =16 years: 0.8-1.3 mg/dL Reference values have not been established for patients that are <12 months of age.  Females 1-3 years: 0.1-0.4 mg/dL 4-5 years: 0.2-0.5 mg/dL 6-8 years: 0.3-0.6 mg/dL 9-15 years: 0.4-0.7 mg/dL > or =16 years: 0.6-1.1 mg/dL Reference values have not been established for patients that are <12 months of age.  ESTIMATED GFR >60 mL/min/BSA Note: eGFR results will not be calculated for patients <18 or >70 years old. | Monday through Sunday; Continuously | Same day/1 day | 2 days | 1 | 82565 |  |  |  |  | Rochester
CREAZ | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 7 days
CREAZ | Result | CREAC | Creatinine, S | Creatinine, S | Numeric |  |  |  |  | mg/dL |  |  |  |  |  |  |  |  |  | 2160-0
CREAZ | Result | EGFN | eGFR-Non African American | eGFR-Non African American | Numeric |  |  |  |  | mL/min/BSA |  |  |  |  |  |  |  |  |  | 48642-3
CREAZ | Result | EGFA | eGFR-African American | eGFR-African American | Numeric |  |  |  |  | mL/min/BSA |  |  |  |  |  |  |  |  |  | 48643-1
Spreadsheet: 57908d1258123909-calculating-on-values-on-calender-that-meet-a-given-criteria-date-calc-query-example
Sheet: Sheet1

 |  | 2008-04-01 00:00:00 | 2008-05-01 00:00:00 | 2008-06-01 00:00:00 | 2008-07-01 00:00:00 | 2008-08-01 00:00:00 | 2008-09-01 00:00:00 | 2008-10-01 00:00:00 | 2008-11-01 00:00:00 | 2008-12-01 00:00:00 | 2009-01-01 00:00:00 | 2009-02-01 00:00:00 | 2009-03-01 00:00:00
 | [NAME] | 221.98 | 201.8 |  |  |  |  |  | 200 |  |  | 50
 | [NAME] | 62.8 | 62.8 | 62.8 | 31.4 | 31.4 | 56.35 |  | 64.4 | 32.2 | 32.2
 |  |  | [NAME] | Start Date | Days | Total Cost
 |  | [NAME] | 5 | 2008-09-15 00:00:00 | X | 250
 |  | [NAME] | 6 | 2008-06-10 00:00:00
 |  | x = total of any entries after 15/9/09, in this case £250
Spreadsheet: 109923d1306740462-cell-that-will-show-a-valid-task-when-another-cell-value-is-a-diff-task-sample
Sheet: Example2

 |  |  |  | Task | Start | End |  | Display
 |  |  |  | WASH DISHES | 2011-05-03 09:00:47 | 2011-05-03 09:05:34
 |  |  |  | COACHING | 2011-05-03 09:05:37 | 2011-05-03 09:10:25
 |  |  |  | ASDFSD | 2011-05-03 09:10:34 | 2011-05-03 09:14:52
 |  |  |  | BANANA | 2011-05-03 09:14:59 | 2011-05-03 09:19:22
 |  |  |  | QUICK | 2011-05-03 06:17:39 | 2011-05-03 06:23:27
 |  |  |  | DROWN | 2011-05-03 06:25:24 | 2011-05-03 06:31:06
 |  |  |  | EATING | 2011-05-03 06:31:14 | 2011-05-03 06:37:00
 |  |  |  | PLAYING | 2011-05-03 06:37:04 | 2011-05-03 06:41:26
 |  |  |  | SURFING | 2011-05-03 06:44:24 | 2011-05-03 06:48:59
 |  |  |  | COACHING | 2011-05-03 06:49:07 | 2011-05-03 07:09:10
 |  |  |  | SLEEPING | 2011-05-03 07:10:30 | 2011-05-03 07:18:21
 |  |  |  | BREAK | 2011-05-03 07:18:26 | 2011-05-03 07:25:58
 |  |  |  | FACING | 2011-05-03 07:26:41 | 2011-05-03 07:34:03
 |  |  |  | DANCING | 2011-05-03 07:34:35 | 2011-05-03 07:41:25
 |  |  |  | FACING | 2011-05-03 07:42:17 | 2011-05-03 07:49:26
 |  |  |  | FACING | 2011-05-03 07:49:36 | 2011-05-03 07:57:50
 |  |  |  | ASKING | 2011-05-03 08:00:46 | 2011-05-03 08:05:03
 |  |  |  | FACING | 2011-05-03 08:10:40 | 2011-05-03 08:16:47
 |  |  |  | BUYING | 2011-05-03 08:20:17 | 2011-05-03 08:24:59
 |  |  |  | FACING | 2011-05-03 08:25:09 | 2011-05-03 08:30:56
 |  |  |  | JOKING | 2011-05-03 08:31:01 | 2011-05-03 08:35:58
 |  |  |  | FACING | 2011-05-03 08:36:09 | 2011-05-03 08:40:27
 |  |  |  | FACING | 2011-05-03 08:40:32 | 2011-05-03 08:43:42
 |  |  |  | FACING | 2011-05-03 08:43:49 | 2011-05-03 08:48:34
Spreadsheet: 143246d1330328624-link-template-cell-to-workbook-excel-stumper
Sheet: Monthly Profits

 |  | x4 | pluse |  |  | pluse | min | pluse
 |  | Gal. Sold | Equip. Sold | Labor | Expenses | Serv. Charg. | Cost | 0.3 | Profit
 | Jan |  |  | 160 | 1000 | 0
 | Feb |  |  | 160 | 1000 | 0
 | Mar |  |  | 160 | 1000 | 0
 | Apr |  |  | 160 | 1000 | 0
 | May |  |  | 160 | 1000 | 0
 | Jun |  |  | 160 | 1000 | 0
 | Jul |  |  | 160 | 1000 | 0
 | Aug |  |  | 160 | 1000 | 0
 | Sep |  |  | 160 | 1000 | 0
 | Oct |  |  | 160 | 1000 | 0
 | Nov |  |  | 160 | 1000 | 0
 | Dec |  |  | 160 | 1000 | 0
Spreadsheet: 099ac61f-e86b-40b4-98c4-27adae7157ce
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19
 |  |  |  |  |  |  |  |  |  |  |  | To fill cell with color |  |  |  |  |  |  | To change the style of the arrow
 |  |  | To Draw straight lines |  |  |  |  |  |  |  |  |  |  |  |  |  |  | To change the style of the line
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | To change the width of the line
 |  |  |  | To draw an arrow |  |  |  |  |  |  | To insert a picture from your computer files
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | To change the color of the font
 |  |  |  |  | To draw a box |  |  |  |  | To insert clip art from the computers database
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | To change the color of the line
 |  |  |  |  |  | To draw a circle |  |  | To insert a diagram from your computer
 |  |  |  |  |  |  | Inserts a box to type text
How to enable the Drawing toolbar |  |  |  |  |  |  |  |  |  |  | How to enable [NAME]
1) Select the following path on your Menu bar to enable the drawing toolbar |  |  |  |  |  |  |  |  |  |  | 1) Select the following path on your Menu bar to enable the macros security
 | View <> Toolbar <> Drawing |  |  |  |  |  |  |  |  |  |  | Tools <> Macro <> Security
 |  | or |  |  |  |  |  |  |  |  |  |  | or
 | (Alt + V + T) <> Select Drawing |  |  |  |  |  |  |  |  |  |  | (Alt + T + M + S)
 |  |  |  |  |  |  |  |  |  |  | 2) Change the security level to Medium
How to make the legends visible within a box, circle or text box |  |  |  |  |  |  |  |  |  |  | 3) Save and close the file
1) Create the box, circle or text box to desired size |  |  |  |  |  |  |  |  |  |  | 4) Reopen the file
2) Right click on the mouse to open menu |  |  |  |  |  |  |  |  |  |  | 5) Select "Enable Macros"
3) Select Format AutoShape…
4) On the "Colors and Lines" tab, change the "Color Field to "No Fill"
5) Click "OK"
Spreadsheet: efbc57e5-ffee-481d-bb37-b5916cd21791
Sheet: Table 1.2

Monthly Statistical Bulletin
1.2 Unemployment
Month | 2009–10 | 2010–11 | 2011–12 | 2012–13 | 2013–14
Number unemployed (a) – '000
July | 652.2287371 | 618.6217823 | 605.7356246 | 625.6882369 | 692.565409
August | 656.4299196 | 585.3136546 | 621.3300513 | 612.3407138 | 703.6635642
September | 651.6469934 | 593.3754688 | 622.9430791 | 662.7915591 | 694.0337937
October | 643.7295416 | 616.9661725 | 610.8323385 | 645.9356679 | 702.1339524
November | 638.8197875 | 601.0965023 | 621.7921998 | 631.7430168 | 705.9781466
December | 633.6157725 | 572.629525 | 614.253464 | 652.3169492 | 715.3189757
January | 609.5879227 | 594.5058977 | 605.8128129 | 659.2974509 | 732.3286922
February | 611.6954763 | 586.291487 | 619.195761 | 655.7243058 | 742.1754314
March | 623.3975326 | 577.4357065 | 614.7168049 | 677.4336581
April | 632.5998087 | 580.3424626 | 591.9010853 | 674.9783622
May | 599.6759111 | 585.719078 | 618.0990706 | 673.6296934
June | 598.3691132 | 583.7241655 | 621.7601761 | 698.2571221
Annual average | 628.1305094416666 | 590.6837662416666 | 613.8477528583334 | 656.180680075
Unemployment rate (a) (b) – per cent
July | 5.6949567 | 5.314491 | 5.1231254 | 5.2236469 | 5.6929588
August | 5.7387394 | 5.0275426 | 5.247225 | 5.1168802 | 5.7823734
September | 5.6872571 | 5.0823061 | 5.2499887 | 5.5067202 | 5.7058662
October | 5.6118914 | 5.2613458 | 5.1484053 | 5.3705021 | 5.7662352
November | 5.5594961 | 5.1083926 | 5.2335637 | 5.2540336 | 5.7887167
December | 5.5015392 | 4.8766773 | 5.1832494 | 5.4100816 | 5.8724651
January | 5.2849478 | 5.0625069 | 5.0964255 | 5.4515432 | 5.9948893
February | 5.3046364 | 4.9845969 | 5.2091897 | 5.4117137 | 6.0472199
March | 5.3943333 | 4.8935989 | 5.1437592 | 5.5930597
April | 5.4642392 | 4.9307983 | 4.9665614 | 5.5548017
May | 5.1950869 | 4.9798244 | 5.158278 | 5.5484872
June | 5.1589201 | 4.9486338 | 5.1989102 | 5.7339148
Annual average | 5.466336966666667 | 5.039226216666666 | 5.163223458333333 | 5.431282074999999
(a) Monthly figures are seasonally adjusted.
(b) Number unemployed as a proportion of the labour force. |  |  |  |  |  |  |  | Update
Source: ABS, Labour force, Cat. no. 6202.0 |  |  |  |  |  |  |  | 2014-04-10 00:00:00
Spreadsheet: 730797d1619956869-expand-a-formula-to-other-cells-given-the-complexity-of-the-formula-a-bit-tricky-example
Sheet: INPUT

 | Categories |  |  | Expert |  | Competent |  | Medium |  | Beginner |  | Novice
 |  |  |  | 90% - 100% |  | 80% - 89% |  | 70% - 79% |  | 60% - 69% |  | 0% - 59%
 | Ability |  |  | 93
 | Velocity |  |  | 90
 | Push |  |  | 94
 | Pull |  |  | 94
 | Balance |  |  | 90
 |  |  |  | 99
 |  |  |  | 95
Spreadsheet: 41832d1240359958-array-formula-test10
Sheet: Data Information

Client Name | ABC Company |  |  | To include | To exclude
Employee enrollment | 350 |  |  | sc
Member [NAME] | 500 |  |  | bio
Budget | 20000
Wellness code to Narrow | BIO
Smoking Population | 150
Wellness Codes
SC | Smoking Cessation
EAP | EAP
BIO | Biometric screenings
GM | Gym Membership
Spreadsheet: 57691295-2c8c-4fb6-8ae4-22e160938c01
Sheet: Precipitation

 |  | SFR Precipitation Worksheet
 |  | Project Name:
 |  | Location of Precipitation Data:
 |  | Starting Year of Data Record:
 |  | Ending Year of Data Record:
 |  | Period of Record (years):
 |  | Source of Data:
 | 80th Percentile Annual Precipitation:
 |  |  |  | Mean Monthly Precipitation | % of Mean Annual Precipitation | 80th Percentile Monthly Precipitation
 |  |  | January
 |  |  | February
 |  |  | March
 |  |  | April
 |  |  | May
 |  |  | June
 |  |  | July
 |  |  | August
 |  |  | September
 |  |  | October
 |  |  | November
 |  |  | December
 |  |  | Total =
Spreadsheet: 715652d1611817674-sum-if-lookng-at-thethe-using-the-month-book1
Sheet: Sheet1

Debit Note Number | 8D Number | Date | DNote / Invoice | Customer | Part Number | Description | Customer Number | QTY | Price | Cost | Status | Comments
L-0016/20 | 820 | 2021-01-01 00:00:00 |  | Huf Germany | 66001248 | F01 LHL STD HAVANNA | 66001248 | 20 | 29.78 | 595.6 | Accept | [NAME] Ordered the wrong [NAME]
00239/20 | 1020 | 2021-02-01 00:00:00 |  | Huf Germany | 15097121 | RAHMEN REAR | 15097121 | 920 | 15.89 | 14618.8 | Accept | Short Shot
Status | Status Cost | Total Debit Notes
Accept | 15214.4 | 2
Rejected | 0 | 0
On Hold | 0 | 0
January |  | count  col c based on the Month in A
February | 0
March
April
May
June
July
August
September
October
November
December
Spreadsheet: 3b31bc7e-c27a-479e-a03b-9ce5f221c6ec
Sheet: Clinical

Dept No. | Department Name | Manager | Phone | Manager [NAME] | Manager [NAME] | Chair/Dean/Director | Phone | Chair Email | Department Address | Division
4215 | Urology | [NAME] | 445-5298 | [NAME] | [NAME] | Raj Pruthi | 843-9330 | [EMAIL] | 2113 Physicians Office Building | Clinical
4216 | Pathology | [NAME] | 966-4676 | [EMAIL] | [NAME] | [NAME] | 966-4676 | [EMAIL] | 301 Brinkhous Bullitt Building | Clinical
4222 | UNC Center for Heart & Vascular Care | [NAME] | 843-5429 | [EMAIL] | [NAME] | [NAME] | 966-2561 | [EMAIL] | 101 Manning Drive | Clinical
4228 | Medicine | Bruce Wicks  [NAME] | 843-[PHONE] | [EMAIL]  [EMAIL] | [NAME] | Marschall Runge | 966-4468 | [EMAIL] | 125 MacNider Hall | Clinical
4229 | Dermatology | [NAME] | 843-4911 | [EMAIL] | [NAME] | [NAME] | 843-6756 | [EMAIL] | 405 [NAME] | Clinical
4230 | Neurology | [NAME] | 966-5548 | [EMAIL] | [NAME] | [NAME] | 966-5522 | [EMAIL] | Physicians Office Building, 170 Manning Drive | Clinical
4232 | Family Medicine | [NAME] | 966-3102 | [EMAIL] | [NAME] | [NAME] | 966-3711 | [EMAIL] | 590 Manning Drive | Clinical
4233 | Neurosurgery | [NAME] | 962-5099 | [EMAIL] | [NAME] | [NAME] | 966-1374 | [EMAIL] | Physicians Office Building, 170 Manning Drive | Clinical
4236 | Obstetrics & Gynecology | [NAME] | 966-8938 | [EMAIL] | [NAME] | [NAME] | 966-5281 | [EMAIL] | 3009 Old Clinic Building | Clinical
4238 | Otolaryngology (ENT) | [NAME] | 966-3342 | [EMAIL] | [NAME] | [NAME] | 966-8926 | [EMAIL] | Physicians Office Building, Room G-190 | Clinical
4244 | Ophthalmology | [NAME] | 966-5296 | [EMAIL] | [NAME] | [NAME] | 843-0297 | [EMAIL] | 5151 Bioinformatics Building | Clinical
4248 | Pediatrics | [NAME] (interim) [NAME] | 966-[PHONE] | [NAME] | [NAME] | [NAME] | 966-9145 | [EMAIL] | 260 MacNider Hall | Clinical
4256 | Psychiatry | [NAME] | 966-8485 | [EMAIL] | [NAME] | [NAME] | 966-4738 | [EMAIL] | 10617 Neurosciences Hospital | Clinical
4260 | Radiology | [NAME] | 966-3521 | [EMAIL] | [NAME] | [NAME] | 966-4406 | [EMAIL] | 2006 Old Clinic Builidng | Clinical
4262 | Radiation Oncology | [NAME] | 966-0400 | [EMAIL] | [NAME] | [NAME] | 966-0400 | [EMAIL] | 101 [NAME], [NAME], Room CB325 | Clinical
4264 | Surgery | [NAME] | 843-1236 | [EMAIL] | [NAME] | [NAME] | 966-4320 | [EMAIL] | 4001 Burnett-Womack Building | Clinical
4265 | Orthopaedics | [NAME] | 966-4540 | [EMAIL] | [NAME] | [NAME] | 966-9066 | [EMAIL] | 3147 Bioinformatics Building | Clinical
4266 | Emergency Medicine | [NAME] | 843-2611 | [EMAIL] | [NAME] | [NAME] | 843-3045 | [EMAIL] | Physicians Office Building, 170 Manning Drive | Clinical
4268 | Anesthesiology | [NAME] | 966-6182 | [EMAIL] | [NAME] | [NAME] | 966-5136 | [EMAIL] | N2198 UNC Hospitals | Clinical
4273 | Allied Health | [NAME] | 843-4828 | [EMAIL] | [NAME] | [NAME] | 966-5171 | [EMAIL] | 3108 Bondurant Hall | Clinical
4296 | Physical Medicine & Rehabilitation | [NAME] | 966-0316 | [EMAIL] | [NAME] | [NAME] | 966-5164 | [NAME] | [NAME] 7009 UNC [NAME] | Clinical
Spreadsheet: 840266d1692616764-populate-data-into-field-based-on-numbers-all-times-required-example-sheet-2-1-
Sheet: Sheet2

Reference | LeadGroup | Status | Telephone1 | Total Dials | Total Duration Talking | Summary of call times
196219131 | PPC Leads | [NAME] | 7302089232
196235552 | Web Leads | No Answer | 7469193999 |  |  | 19:11,19:01,19:00,17:00:00
196215613 | Web Leads | IVA Prospect | 7470082888
196240648 | PPC Leads | DNQ - Other Reason | 7488303232
196180071 | Web Leads | [NAME] | 7512672111
196181054 | PPC Leads | Call Back - Initial stage | 7534562232
196217750 | PPC Leads | Sold PBS | 7547264232
196221053 | PPC Leads | No Answer | 7725126232
196229828 | Web Leads | DNQ - Affordability Issue | 7776755222
196225583 | Web Leads | Not Interested | 7908358232
Spreadsheet: 160361d1339065942-referencing-a-sheet-that-doesnt-exist-yet-project-managment-sheet
Sheet: Project Sheet 1

[INSERT PROJECT NUMBER]
Days worked |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTAL
Week | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33 | 34 | 35 | 36 | 37 | 38 | 39 | 40 | 41 | 42 | 43 | 44 | 45 | 46 | 47 | 48 | 49 | 50 | 51 | 52
[NAME] person
[NAME] person 2
[NAME] person 3
[NAME]
[NAME]
Bianca Abulafia
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Project Number | 1
Project Description | A Project
Staff costs |  |  |  |  |  | Project cost
Name | Grade | Rate card cost per day | Actual cost per day (inc. overheads) | Resourced project days | Actual project days | Resourced project cost | Actual project cost
[NAME] person | Director
[NAME] person 2 | Consultant
[NAME] person 3 | Business Analyst
Total
Project revenue
Actual project revenue | Resourced project gross profit | Actual project gross profit
Profit margins
Resourced profit margin | Actual profit margin | Over-resourced days
Spreadsheet: 180370d1347569487-pivot-table-of-grand-total-aj
Sheet: Sheet4

 | Values
Row Labels | Sum of Operating Income | Sum of Operating Margin | Sum of Net Income | Sum of EPS
Apple | 0 | 0.3333333333333333 | 0.5 | 0.25
Dell | 0.25 | 0.3333333333333333 | 0 | 0
Google | 0.25 | 0 | 0 | 0.25
HP | 0.25 | 0 | 0 | 0.25
Microsoft | 0.25 | 0.3333333333333333 | 0.5 | 0.25
Grand Total | 1 | 1 | 1 | 1
Spreadsheet: 694781d1599790419-large-and-small-functions-with-multiple-criteria-find-top-and-bottom-3-numbers-sample123456789
Sheet: Sheet1

Material | Data | Data 1 | Year 1 | Year 2 | Year 3 | Year 4
Silk | Yes | xyz | 1 | 400 | 35 | 550
Velvet | No | xyz | 100 | 200 | 89 | 300
Cotton | Yes | abc | 400 | 150 | 90 | 120
[NAME] | No | xyz | 3 | 300 | 100 | 600
Flannel | No | xyz | 45 | 20 | 789 | 300
Wool | No | abc | 900 | 80 | 500 | 250
Cashmere | No | abc | 29 | 120 | 300 | 467
Plyester | Yes | abc | 45 | 100 | 230 | 777
TOP 3 NUMBERS
BOTTOM 3 NUMBERS
Material | Data | Data 1 | Year 1 | Year 2 | Year 3 | Year 4
Silk | Yes | xyzB | 1 | 400 | 35 | 550
Velvet | No | xyzA | 100 | 200 | 89 | 300
Cotton | Yes | abcD | 400 | 150 | 90 | 120
[NAME] | No | xyz12 | 3 | 300 | 100 | 600
Flannel | No | xyz55 | 45 | 20 | 789 | 300
Wool | No | abc23 | 900 | 80 | 500 | 250
Cashmere | No | abcde | 29 | 120 | 300 | 467
Plyester | Yes | abcwe | 45 | 100 | 230 | 777
TOP 3 NUMBERS
BOTTOM 3 NUMBERS
Spreadsheet: 215211d1361306175-find-lowest-value-in-corresponding-cells-on-multiple-worksheets-return-value-and-location-book1
Sheet: Summary

 | Minimum | Minimum
 | Val A | Val B | Val A | Val B
Spreadsheet: 747263d1631312384-please-help-beginner-with-another-20-number-problem-please-help-with-this-formula
Sheet: Sheet1

 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20
A |  |  | 3 | 4 | 5 |  |  | 8 |  |  | 11 |  | 13 | 14 |  |  | 17 | 18 | 19
B | 1 |  | 3 | 4 | 5 |  | 7 | 8 |  | 10 |  |  |  | 14 |  |  | 17 | 18
C | 1 |  | 3 |  | 5 |  |  |  |  | 10 | 11 |  | 13 | 14 |  | 16 |  | 18 |  | 20
D | 1 | 2 | 3 |  |  | 6 | 7 |  | 9 |  | 11 |  |  | 14 |  | 16 | 17
E |  | 2 | 3 | 4 | 5 | 6 |  | 8 |  |  | 11 |  |  |  |  | 16 | 17 |  | 19
F |  | 2 | 3 | 4 | 5 |  |  | 8 |  |  | 11 | 12 | 13 |  | 15 |  |  |  | 19
G |  | 2 | 3 | 4 |  |  |  | 8 | 9 | 10 |  |  | 13 |  | 15 |  |  |  | 19 | 20
H | 1 | 2 |  |  |  |  | 7 | 8 |  |  | 11 | 12 |  |  | 15 |  | 17 |  | 19 | 20
I | 1 | 2 | 3 |  |  |  | 7 | 8 | 9 |  | 11 |  |  |  |  | 16 | 17 |  | 19
J | 1 |  | 3 | 4 | 5 | 6 |  |  | 9 | 10 |  |  | 13 |  |  | 16 | 17
Solutions
1st solution A+B | 1 |  | 3 | 4 | 5 |  | 7 | 8 |  | 10 | 11 |  | 13 | 14 |  |  | 17 | 18 | 19
2nd solution B+C | 1 |  | 3 | 4 | 5 |  | 7 | 8 |  | 10 | 11 |  | 13 | 14 |  | 16 | 17 | 18 |  | 20
3rd solution C+D | 1 | 2 | 3 |  | 5 | 6 | 7 |  | 9 | 10 | 11 |  | 13 | 14 |  | 16 |  | 18 |  | 20
4th solution D+E | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 |  | 11 |  |  | 14 |  | 16 | 17 |  | 19
5th solution E+F |  | 2 | 3 | 4 | 5 | 6 |  | 8 |  |  | 11 | 12 | 13 |  | 15 | 16 | 17 |  | 19
6th solution F+G |  | 2 | 3 | 4 | 5 |  |  | 8 | 9 | 10 | 11 | 12 | 13 |  | 15 |  |  |  | 19
7th solution G+H | 1 | 2 | 3 | 4 |  |  | 7 | 8 | 9 | 10 |  |  | 13 |  | 15 |  |  |  | 19 | 20
8th solution H+I | 1 | 2 | 3 |  |  |  | 7 | 8 | 9 |  | 11 | 12 |  |  | 15 | 16 | 17 |  | 19 | 20
9th solution I+J | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 |  |  |  |  | 16 | 17 |  | 19
Spreadsheet: 861311d1709213357-unique-and-choosecols-return-0-for-blank-cells-sample
Sheet: Sheet5

Project Name | Current State |  |  | [NAME] |  | Current State
PD IND - CAEUPU4400C-CA | January 1 |  |  |  | PD IND - CAEUPU4400C-CA | January 1
PD IND - CAEUPU4400C-CA | January 2 |  |  |  | PD IND - CAEUPU4400C-CA | January 2
PD IND Administration - CAEUPU4400C-CF | January 1 |  |  |  | PD IND Administration - CAEUPU4400C-CF | January 1
PD IND Administration - CAEUPU4400C-CF | January 2 |  |  |  | PD IND Administration - CAEUPU4400C-CF | January 2
 |  |  |  |  | 0 | 0
 |  |  |  |  |  | Current State
 |  |  |  |  | PD IND - CAEUPU4400C-CA | January 1
 |  |  |  |  | PD IND - CAEUPU4400C-CA | January 2
 |  |  |  |  | PD IND Administration - CAEUPU4400C-CF | January 1
 |  |  |  |  | PD IND Administration - CAEUPU4400C-CF | January 2
Spreadsheet: 296618d1392141078-copying-rows-without-numbers-ascending-example
Sheet: Sheet1

 | Standings | Overall Points | Race Points | Poles | Wins | Top 3 | Top 5 | Qualifying:  Exact Picks | Race:      Exact Picks
1 | 2dumb
2 | asphalt-angel
3 | budman271
4 | [NAME]
5 | Dog
6 | drivendirty
7 | eitsfan
8 | lostyankee
9 | m&mfan
10 | [NAME]
11 | rolltide
12 | RoushRanger1
13 | skidmark
14 | vegashotshoe
15 | warrior
Spreadsheet: 805317d1668619735-check-qualification-based-on-multiple-criteria-using-a-table-with-logic-operators-qualification-test
Sheet: Sheet1

Tier 1 - Must have at least $1m in current business
AND
1. - At least 10 new client sales worth at least $250,000 in new sales
OR
2. - At least $500,000 in new sales
[NAME] have less than $1m in current business
AND
1. - At least 10 new client sales worth at least $100,000 in new sales
OR
2. - At least $250,000 in new sales
Current Amounts (Input) |  |  |  |  |  |  |  | Output
Current Business | New Clients | New Sales $ |  |  |  |  |  | Tier | Sub-Tier
1000000 | 10 | 250000
Table of Rules
Symb.1 | Current Business $ | Operator1 | Symb.2 | New Clients | Operator2 | [NAME] | New Sales $ | Tier | Sub-Tier
>= | 1000000 | AND | >= | 10 | AND | > | 250000 | Tier 1 | 1
>= | 1000000 | AND | >= | N/A | AND | > | 500000 | Tier 1 | 2
< | 1000000 | AND | >= | 10 | AND | > | 100000 | [NAME] | 1
< | 1000000 | AND | >= | N/A | AND | > | 250000 | [NAME] | 2
Potential Future Scenerio
Table of Rules
Symb.1 | Current Business $ | Operator1 | Symb.2 | New Clients | Operator2 | [NAME] | New Sales $ | Tier | Sub-Tier
>= | 5000000 | AND | >= | 20 | OR | > | 400000 | Tier 1 | 1
>= | 5000000 | AND | >= | N/A | AND | > | 600000 | Tier 1 | 2
>= | 5000000 | AND | >= | 15 | AND | > | 300000 | Tier 1 | 3
>= | 3000000 | AND | >= | 15 | OR | > | 250000 | [NAME] | 1
>= | 3000000 | AND | >= | N/A | AND | > | 500000 | [NAME] | 2
< | 1000000 | AND | >= | 10 | AND | > | 100000 | Tier 3 | 1
< | 1000000 | AND | >= | N/A | AND | > | 250000 | Tier 3 | 2
< | 1000000 | OR | >= | 30 | OR |  | 500000 | [NAME] | 1
Spreadsheet: 751511d1634147632-formula-for-glide-path-test-file
Sheet: Sheet3

YTD Score | Glidepath
-100 |  |  |  |  |  | 60
50 |  |  |  |  |  | 60
40 |  |  |  |  |  | 60
20 |  |  |  |  |  | 60
100 |  |  |  |  |  | 60
50 |  |  |  |  |  | 60
80 |  |  |  |  |  | 60
70 |  |  |  |  |  | 60
50 |  |  |  |  |  | 60
60 |  |  |  |  |  | 60
 | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6