tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 9871c0ba-e620-4b2f-b69f-77cde02ba037
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
FFRBS | Test | FFRBS | Friedreich Ataxia, Frataxin, Quantitative, Blood Spot | Frataxin, Quant, BS | Luminex Immunoassay | Whatman filter paper: WFP |  |  | 2 | Blood spots | Container/Tube:  Preferred: Whatman Protein Saver 903 Paper Acceptable: Ahlstrom 226 Filter Paper and Supplemental Newborn Screening Card (Supply T493)  [NAME]: 2 blood spots Collection Instructions:  1. An alternative blood collection option for a patient >1 year of age is fingerstick. 2. Let blood dry on the filter paper at ambient temperature in a horizontal position for 3 hours. 3. Do not expose specimen to heat or direct sunlight. 4. Do not stack wet specimens. 5. Keep specimen dry. Additional Information: Provide a reason for referral with each specimen. Forms: 1.   1. 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. 2.   2. If not ordering electronically, submit a Biochemical Genetics Request Form (Supply T439) with the specimen. | 1 blood spot | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	Blood spot specimen that shows serum rings or has multiple layers | Pediatric (<18 years) normal frataxin: > or =15 ng/mL  Adults (> or =18 years) normal frataxin: > or =21 ng/mL | Tuesday; 8 a.m. | 8 days | 16 days | 1 | 83520 |  |  |  |  | Rochester
FFRBS | [NAME] | BLOOD | Whole blood |  |  |  | Ambient | 30 days
FFRBS | Result | 32249 | Reason for Referral | Reason for Referral | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42349-1 | Reason for referral:Find:Pt:^Patient:Nar:
FFRBS | Result | 32250 | Method | Method | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 49549-9 | Reference lab test method:Type:XXX:Reference lab test:Nar:
FFRBS | Result | 32251 | Frataxin | Frataxin | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | In Process
FFRBS | Result | 32252 | Interpretation | Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 59462-2
Spreadsheet: 120166d1315037975-match-help-please-jollyfella-_file_to_excel_forum
Sheet: Sheet2

Ending Staff Count |  |  |  | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2009 | 2010 | 2010 | 2010 | 2010 | 2010 | 2010 | 2010 | 2010 | 2010 | 2010 | 2010 | 2010 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011 | 2011
 |  |  |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 |  |  |  | Q1 | Q1 | Q1 | Q2 | Q2 | Q2 | Q3 | Q3 | Q3 | Q4 | Q4 | Q4 | Q1 | Q1 | Q1 | Q2 | Q2 | Q2 | Q3 | Q3 | Q3 | Q4 | Q4 | Q4 | Q1 | Q1 | Q1 | Q2 | Q2 | Q2 | Q3 | Q3 | Q3 | Q4 | Q4 | Q4
 | Execs |  |  | 1625 | 1584 | 1507 | 1491 | 1472 | 1460 | 1547 | 1516 | 1459 | 1412 | 1399 | 1385 | 2010 | 2006 | 2001 | 1998 | 1980 | 1973 | 2303 | 2297 | 2286 | 2328 | 2323 | 2323 | 2277 | 2255 | 2240 | 2213 | 2195 | 2168 | 2155
 | Managers |  |  | 6527 | 6361 | 6050 | 5956 | 5825 | 5760 | 6218 | 6004 | 5652 | 5324 | 5243 | 5166 | 5706 | 5697 | 5700 | 5686 | 5586 | 5559 | 5049 | 5012 | 4972 | 5004 | 4967 | 4938 | 4742 | 4694 | 4644 | 4558 | 4489 | 4418 | 4358
 | Mid Managers |  |  | 66458 | 62695 | 59195 | 55635 | 53121 | 51104 | 63647 | 60122 | 56340 | 52654 | 50348 | 48502 | 60168 | 61488 | 62063 | 62182 | 60363 | 59059 | 58566 | 57663 | 56416 | 55156 | 54053 | 53037 | 50096 | 49029 | 48084 | 46638 | 45591 | 44525 | 43038
 | Staff |  |  | 477868 | 435998 | 397154 | 353880 | 327993.793 | 306801.793 | 490584.793 | 447811.793 | 401678.793 | 353385.793 | 329480.793 | 311434.793 | 398431 | 402109 | 402161 | 396204 | 372975 | 352929 | 409951 | 392881 | 366330 | 346893 | 331784 | 318151 | 301185 | 289732 | 278558 | 263706 | 254434 | 246638 | 229545
 | Workers |  |  | 53390 | 127100 | 183838 | 218151 | 251784 | 273316 | 90863 | 133368 | 189097 | 241261 | 281511 | 313799 | 232528 | 229689 | 239047 | 230357 | 239928 | 288847 | 245578 | 293875 | 272591 | 374468 | 403335 | 410341 | 396221 | 418224 | 442735 | 430246 | 448525 | 484640 | 426582
 | Others |  |  | 225 | 289 | 1350 | 1860 | 4013 | 5740 | 1363 | 1565 | 1693 | 1795 | 1907 | 1951 | 20 | 0 | 0 | 0 | 0 | 0 | 55 | 236 | 72057 | 698 | -5419 | -10743 | 16219 |  | 405 | 593 | 760 | 2096 | 59178
Spreadsheet: 724270d1616091438-2-way-index-match-headache-sample_online
Sheet: Pic

 | TABLE1
 | Year | Month | Metric | Lookup | Target | Actual | Var from Target | Bonus_Baseline | %Payout
 | 2021 | January | Profit |  | 1000000 | 1060000 |  | 700
 | 2021 | January | Count |  | 4000 | 3789 |  | 500
 | 2021 | February | Profit |  | 978686 | 812668 |  | 575
 | 2021 | February | Count |  | 3741 | 3855 |  | 600
 | [NAME]
 | Year | Month | Metric | Low | High | %Bonus_Earned | Lookup | Column1
 | 2021 | January | Profit | -1 | -0.2 | 0
 | 2021 | January | Profit | -0.1999 | -0.15 | 0.5
 | 2021 | January | Profit | -0.1499 | -0.1 | 0.65
 | 2021 | January | Profit | -0.0999 | -0.05 | 0.75
 | 2021 | January | Profit | -0.0499 | -0.0001 | 0.9
 | 2021 | January | Profit | 0 | 1 | 1.25
 | 2021 | January | Count | -1 | -0.5 | 0
 | 2021 | January | Count | -0.4999 | -0.25 | 0.15
 | 2021 | January | Count | -0.2499 | -0.0001 | 0.4
 | 2021 | January | Count | 0 | 0.08 | 0.65
 | 2021 | January | Count | 0.0801 | 0.2 | 0.9
 | 2021 | January | Count | 0.2001 | 1000 | 1.5
 | 2021 | February | Profit | -1 | -0.4 | 0
 | 2021 | February | Profit | -0.3999 | -0.2 | 0.48
 | 2021 | February | Profit | -0.1999 | 0.0001 | 0.63
 | 2021 | February | Profit | 0 | 0.15 | 0.73
 | 2021 | February | Profit | 0.1501 | 1000 | 0.88
 | 2021 | February | Profit | 0 | 1 | 1.23
 | 2021 | February | Count | -1 | -0.75 | 0.02
 | 2021 | February | Count | -0.7499 | -0.25 | 0.13
 | 2021 | February | Count | -0.2499 | -0.0001 | 0.38
 | 2021 | February | Count | 0 | 0.08 | 0.61
 | 2021 | February | Count | 0.0801 | 0.2 | 0.75
 | 2021 | February | Count | 0.2001 | 1000 | 1
Spreadsheet: 769933d1645726131-xlookup-assistance-sample-workbook
Sheet: PARTS

PART # | PART DESCRIPTION | VEHICLE | S | D
1A | TEST PART 1 |  | 1 | 0.5
2B | TEST PART 2 |  | 5 | 2.5
3C | TEST PART 3 |  | 10 | 5
4D | TEST PART 4 |  | 15 | 7.5
5E | TEST PART 5 |  | 20 | 10
6F | TEST PART 6 |  | 25 | 12.5
7G | TEST PART 7 |  | 30 | 15
8H | TEST PART 8 |  | 35 | 17.5
9I | TEST PART 9 |  | 40 | 20
10J | TEST PART 10 |  | 45 | 22.5
Spreadsheet: 853952d1703895959-chatgpt-says-this-cant-be-done-without-vba-track-menstruation
Sheet: Sheet1

[NAME] | Menstruation Start | Menstruation End | Fertile Start | Ovulating | Fertile End | Menstruation Period | Fertility Period
 |  |  |  |  |  |  |  |  | Your most recent cycle start date |  | 2023-12-08 00:00:00
 |  |  |  |  |  |  |  |  | Your typical cycle length in days |  | 31
 |  |  |  |  |  |  |  |  | Days from period start until ovulation begins |  | 14
 |  |  |  |  |  |  |  |  | Typical menstruation days |  | 4
Spreadsheet: 729401d1619073932-indirect-data-validation-problem-with-expanding-named-ranges-indirect-data-vailidation-example-sheet-2-
Sheet: Sheet1

TapeStretchfilm | HandTape | Masking |  |  | Category | Corrugated | Carton | Grade | TapeStretchfilm | HandTape
 |  |  |  |  | Corrugated | Carton | 0200 glued carton | B125KT | HandTape | PP
 |  |  |  |  | Tape/Stretch film | Fitment | 0201 glued carton | B125LT | Machine Tape | Vinyl
 |  |  |  |  | Plastics/Strapping |  | 0203 glued carton | B125TT | [NAME] film | Paper
 |  |  |  |  | Voidfill/Labels |  | 0300 glued carton | B125VT | [NAME] film | Gummed Paper
 |  |  |  |  | Tooling/Equipment |  | 0200 stitched carton | B125WT |  | Masking
 |  |  |  |  | Sheetboard/Paper |  | 0201 stitched carton | B150KT |  | Double Sided
 |  |  |  |  |  |  | 0203 stitched carton | B150KT(150S/C) |  | [NAME]
 |  |  |  |  |  |  | 0300 stitched carton | B150LT |  | Reinforced
 |  |  |  |  |  |  |  | B150LT(150S/C) |  | PVC Electrical
 |  |  |  |  |  |  |  | B150TT |  | PVC Lane Marking
 |  |  |  |  |  |  |  | [NAME] |  | Barrier
 |  |  |  |  |  |  |  | B150WT
 |  |  |  |  |  |  |  | B150WT(150FL)
 |  |  |  |  |  |  |  | B150WT(150S/C)
 |  |  |  |  |  |  |  | B180W200T
 |  |  |  |  |  |  |  | B180W200T(150S/C)
 |  |  |  |  |  |  |  | B200KT
 |  |  |  |  |  |  |  | B200KT(150S/C)
Spreadsheet: 220023d1363036291-m-and-a-event-study-excel-help-sample
Sheet: Daily Returns

Name | HYDRO INTERNATIONAL - TOT RETURN IND | K3 BUSINESS TECH.GP. - TOT RETURN IND | K3 BUSINESS TECH.GP. - TOT RETURN IND | K3 BUSINESS TECH.GP. - TOT RETURN IND | K3 BUSINESS TECH.GP. - TOT RETURN IND | K3 BUSINESS TECH.GP. - TOT RETURN IND | K3 BUSINESS TECH.GP. - TOT RETURN IND | K3 BUSINESS TECH.GP. - TOT RETURN IND | ADVANCED MED.SLTN.GP. - TOT RETURN IND | COBURG GROUP - TOT RETURN IND | FIRST GROUP - TOT RETURN IND
Code | 135085(RI) | 135109(RI) | 135109(RI) | 135109(RI) | 135109(RI) | 135109(RI) | 135109(RI) | 135109(RI) | 135127(RI) | 135227(RI) | 135229(RI)
 | 135085 | 135109 | 135109 | 135109 | 135109 | 135109 | 135109 | 135109 | 135127 | 135227 | 135229
Date | 2008-05-06 00:00:00 | 2007-03-28 00:00:00 | 2007-09-03 00:00:00 | 2007-12-17 00:00:00 | 2010-03-02 00:00:00 | 2011-03-04 00:00:00 | 2011-07-25 00:00:00 | 2011-12-20 00:00:00 | 2011-12-02 00:00:00 | 2006-04-21 00:00:00 | 2007-02-09 00:00:00
2005-12-01 00:00:00
2005-12-02 00:00:00
2005-12-05 00:00:00
2005-12-06 00:00:00
2005-12-07 00:00:00
2005-12-08 00:00:00
2005-12-09 00:00:00
2005-12-12 00:00:00
2005-12-13 00:00:00
2005-12-14 00:00:00
2005-12-15 00:00:00
2005-12-16 00:00:00
2005-12-19 00:00:00
2005-12-20 00:00:00
2005-12-21 00:00:00
2005-12-22 00:00:00
2005-12-23 00:00:00
2005-12-26 00:00:00
2005-12-27 00:00:00
2005-12-28 00:00:00
2005-12-29 00:00:00
2005-12-30 00:00:00
2006-01-02 00:00:00
2006-01-03 00:00:00
2006-01-04 00:00:00
2006-01-05 00:00:00
Spreadsheet: 705371d1606070507-formulas-for-counting-and-adding-rolling-data-excel-forum-question
Sheet: Sheet1

red | Total count of Blue and Red per last/rolling 100 entries: |  |  | 1 | Sum of all numbers for last/rolling 100 entries:
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1 |  |  | This should be 5099
red |  |  |  | 1
red | This should be 94 |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
Red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
red |  |  |  | 1
green |  |  |  | 5000
green
green
green
green
green
Spreadsheet: 887685d1737994631-how-to-sum-a-string-of-consecutive-numbers-example-for-help-on-fatigue-hours
Sheet: Sheet1

Employee | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Total Pay Period Hours Worked | Consecutive SUM (Need Help With This Formula) | Conditional Formating Alarm Indication for Hours Worked
 | 2025-01-01 00:00:00
[NAME] | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 9 | 9 | 9 | 9 |  |  | 10 |  | 106 | Too Many Consecutive Hours
[NAME] | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 9 |  | 9 | 9 | 9 | 9 |  |  | 79 | OK
[NAME] | 10 | 10 | 10 | 10 | 10 | 10 | 10 | 12 |  | 9 | 9 | 9 | 9 | 9 |  | 82 | OK
 | The employee is not allowed to work more than 105 hours consecutively, therefore [NAME] is over hours but [NAME] and [NAME] are not.  I need help for creatomg a formula for counting consecutive hours and flagging a cell if the hours entered exceeds 105 consecutive hours
 |  |  |  | `
Spreadsheet: 534677d1503394743-formula-to-find-variances-between-planned-and-actual-dates-sample
Sheet: Sheet1

 | Ticket # | Planned Date | Actual Completion Date | [NAME] | Variance in %
 | A83733 | 2017-04-30 00:00:00 | 2017-04-25 00:00:00
 | A81209 | 2017-04-30 00:00:00 | 2017-04-30 00:00:00
 | A83701 | 2017-04-30 00:00:00 | 2017-05-25 00:00:00
 | A82300 | 2017-04-30 00:00:00 | 2017-04-25 00:00:00
Spreadsheet: 474717d1470865257-copy-data-if-two-coditions-are-true-extract2
Sheet: Sheet1

 |  | Incorect result | Corect result
3 | skip
6 | skip
8 | ex |  | 8
3 | ex |  | 3
2 | ex |  | 2
4 | ex |  | 4
3 | ex |  | 3
6 | skip
6 | skip
7 | skip
4 | ex |  | 4
9 | ex |  | 9
7 | ex |  | 7
8 | ex |  | 8
5 | ex |  | 5
4 | ex |  | 4
5 | ex |  | 5
8 | skip
9 | skip
2 | ex
3 | skip
4 | ex
7 | ex
8 | ex
2 | skyp
3 | ex |  | 3
4 | ex |  | 4
5 | ex |  | 5
2 | ex |  | 2
3 | ex |  | 3
4 | ex |  | 4
2 | skip
Spreadsheet: 839898d1692285614-index-and-match-function-not-working-123-abc
Sheet: Sheet1 (2)

ألأسم | العمر | الفئة | الفئة | Age Category | Count
Name | Age | Category | Category |  |  |  | 1-5 | 6-10 | 11-15 | 16-20 | 21-25 | 26-30 | 31-35 | 36-40 | 41-45 | 46-50 | 51-55 | 56-60 | 61-65 | 66-70 |  |  |  |  | [NAME]
محسن منذر | 16 |  |  |  | 6
محمود إيمان | 15 |  |  | 6-10 | 7
سليم صابر | 15 |  |  | 11-15 | 3
فؤاد جمال | 3 |  |  | 16-20 | 5
موسى منصور | 4 |  |  | 21-25 | 7
مهيبة طيب | 5 |  |  | 26-30 | 5
إحسان عذاب | 1 |  |  | 31-35 | 7
[NAME] | 2 |  |  | 36-40 | 5
شهيد سراج | 4 |  |  | 41-45 | 5
شيماء حكيم | 16 |  |  | 46-50 | 4
صديق زكريا | 20 |  |  | 51-55 | 4
حكيم آيات | 18 |  |  | 56-60 | 5
ريحانة شعيب | 20 |  |  | 61-65 | 2
وحيد اخلاص | 23 |  |  | 66-70 | 4
فرج علي | 23
ميمونة بصير | 23
[NAME] | 24
فؤاد أماني | 21
يعقوب بشير | 24
سمية عزيز | 22
ساجد خليل | 26 |  |  |  |  |  | I need your help
سراج شهيد | 29 |  |  |  |  |  | Index and [NAME] are not working in Column H,I,J
مرجان نور | 27 |  |  |  |  |  | Please Taking inconsideration that I am using excel 365 but at work most employee use Excel 2010 or 2016
[NAME] | 28 |  |  |  |  |  | Many thanks for any help
قمر خليل | 26
عبدالله سمير | 35 |  |  |  |  |  | How to count content of each column
منى منتصر | 31
معمر أحلام | 33
ضياء أحلام | 35
إيناس منير | 64
بحر ناصر | 31
منير مبارك | 66
رغد إبراهيم | 33
حسن لطيف | 34
يعقوب مطر | 40
ابرار اسحاق | 38
سلوى داوود | 38
ناصح عزيز | 37
[NAME] | 38
حبيب جهاد | 42
داوود ناصح | 45
عزيز ناصح | 44
اسراء منتصر | 41
بديع سليمان | 44
لطيف حسن | 47
[NAME] | 50
رقية آدم | 48
بصير شهيد | 49
أحلام معمر | 54
بصير إكرام | 53
سلمى موسى | 53
إشراق هادي | 55
قارون بشير | 70
اسحاق أنعام | 64
مروى معمر | 57
[NAME] | 59
عيسى منذر | 69
آدم [NAME] | 68
يوسف علي | 7
[NAME] | 10
طيب اسلام | 6
سعيد نجم | 6
أمينة مرشد | 10
لميس ضياء | 57
داليا حسن | 8
جميل جواد | 59
إبراهيم جواد | 9
آيات ضياء | 13
جلال فضل | 58
Spreadsheet: 773951d1648130542-how-to-select-a-cell-at-random-without-repeating-cells-switch-list-generator-vtest2
Sheet: Empty Cars

Roadname | Number | Type | AAR |  | Available cars
Spreadsheet: 707389d1607243429-cell-reference-instead-hard-coded-values-example
Sheet: fdfd

Investment | Maturity | 2018-07-01 00:00:00 | 2018-08-01 00:00:00 | 2018-09-01 00:00:00 | 2018-10-01 00:00:00 | 2018-11-01 00:00:00 | 2018-12-01 00:00:00 | 2019-01-01 00:00:00 | 2019-02-01 00:00:00 | 2019-03-01 00:00:00 | 2019-04-01 00:00:00 | 2019-05-01 00:00:00 | 2019-06-01 00:00:00 | Total | Rate of profit
1000000 | MONTH
1000000 | MONTH
1000000 | MONTH
1000000 | MONTH
1000000 | MONTH
1000000 | MONTH
1000000 | MONTH
1000000 | MONTH
Spreadsheet: 751895d1634412504-paste-link-data-from-one-sheet-to-another-based-on-1-condition-excel-forum-sample
Sheet: CHRIS

YEAR | MONTH | WC | TODAYS DATE | PATIENT NAME | SEEN BY | APT TYPE | COST 1 | ADDITIONS | COST 2 | TOTAL | PAYMENT METHOD | PN | %
Spreadsheet: 784511d1655797719-ranking-based-on-combination-three-columns-in-excel-ranking-based-on-combination-three-columns-in-excel
Sheet: Sheet2

Name | Score | Rank |  |  | Name | Score | Rank |  |  | Name | Score | Rank
[NAME] | 80 |  |  |  | [NAME] | 80 |  |  |  | [NAME] | 80
[NAME] | 64 |  |  |  | [NAME] | 64 |  |  |  | [NAME] | 64
[NAME] | 65 |  |  |  | [NAME] | 65 |  |  |  | [NAME] | 65
[NAME] | 89 |  |  |  | [NAME] | 89 |  |  |  | [NAME] | 89
[NAME] | 76 |  |  |  | [NAME] | 76 |  |  |  | [NAME] | 76 |  |  |  | (1) [NAME] - (2) [NAME] - (3) [NAME]
[NAME] | 94 |  |  |  | [NAME] | 94 |  |  |  | [NAME] | 94 |  |  |  | (1) [NAME]2) [NAME] (3) [NAME]
[NAME] | 92 |  |  |  | [NAME] | 92 |  |  |  | [NAME] | 92 |  |  |  | (1) [NAME]2) [NAME] (3) [NAME]
[NAME] | 62 |  |  |  | [NAME] | 62 |  |  |  | [NAME] | 62
[NAME] | 45 |  |  |  | [NAME] | 45 |  |  |  | [NAME] | 45
[NAME] | 61 |  |  |  | [NAME] | 61 |  |  |  | [NAME] | 61
[NAME] | 72 |  |  |  | [NAME] | 72 |  |  |  | [NAME] | 72
 |  |  |  |  | [NAME] | 89 |  |  |  | [NAME] | 89
 |  |  |  |  | [NAME] | 150 |  |  |  | [NAME] | 150
 |  |  |  |  | [NAME] | 78 |  |  |  | [NAME] | 78
 |  |  |  |  | [NAME] | 85 |  |  |  | [NAME] | 85
 |  |  |  |  | [NAME] | 52 |  |  |  | [NAME] | 52
 |  |  |  |  | [NAME] | 84 |  |  |  | [NAME] | 84
 |  |  |  |  | [NAME] | 85 |  |  |  | [NAME] | 85
 |  |  |  |  | [NAME] | 45 |  |  |  | [NAME] | 45
 |  |  |  |  | [NAME] | 99 |  |  |  | [NAME] | 99
 |  |  |  |  | [NAME] | 88 |  |  |  | [NAME] | 88
 |  |  |  |  | [NAME] | 83 |  |  |  | [NAME] | 83
 |  |  |  |  |  |  |  |  |  | [NAME] | 60
 |  |  |  |  |  |  |  |  |  | [NAME] | 45
 |  |  |  |  |  |  |  |  |  | [NAME] | 47
 |  |  |  |  |  |  |  |  |  | [NAME] | 35
 |  |  |  |  |  |  |  |  |  | [NAME] | 38
 |  |  |  |  |  |  |  |  |  | [NAME] | 44
 |  |  |  |  |  |  |  |  |  | [NAME] | 50
 |  |  |  |  |  |  |  |  |  | [NAME] | 100
 |  |  |  |  |  |  |  |  |  | [NAME] | 54
 |  |  |  |  |  |  |  |  |  | [NAME] | 53
 |  |  |  |  |  |  |  |  |  | [NAME] | 62
Spreadsheet: 148002d1333079518-determine-the-last-value-from-an-array-before-a-specified-value-822287
Sheet: Sheet1

Customer | Description
1 | Enter Store
1 | Kids |  |  |  |  | Departments
1 | Womens |  |  |  |  | Kids
1 | Try on Clothes |  |  |  |  | Womens
1 | Customer Service |  |  |  |  | [NAME]
1 | [NAME] |  |  |  |  | Infant
2 | Enter Store |  |  |  |  | Electronics
2 | [NAME]
2 | Customer Service
2 | [NAME] |  |  |  |  | Determine last Department before Customer Service
3 | Enter Store |  |  |  |  | Customer 1 ?? |  | Would be Womens
3 | Kids |  |  |  |  | Customer 2?? |  | Would be Mens
3 | [NAME] |  |  |  |  | Customer 3?? |  | Would be Electronics
3 | Infant
3 | Electronics
3 | Restroom |  |  |  |  | Customer | Department
3 | Customer Service |  |  |  |  | 1
3 | [NAME] |  |  |  |  | 2
 |  |  |  |  |  | 3
Spreadsheet: 174a123a-b730-4784-8753-600da4111155
Sheet: John Moran

Rep [NAME]
Fair Share Fee: Those Who Don't Pay Their Fair Share
Agree
Explain your fair share position, if you choose.
No response
Teachers' Retirement: Support in the State Budget
Agree
Explain your teachers' retirement position, if you choose.
No response
Health Care: Continuing System Reform
Agree
Explain your health care reform position, if you choose
No response
Teaching Career: Retaining New Teachers
Agree
Explain your teaching career position, if you choose
No response
Teaching Profession: Simplifying Professional Relicensing
Agree
Explain your relicensing position, if you choose
No response
Name | email address | Address | Office sought | Are you an incumbent? |  | County
Rep. [NAME] | [EMAIL] | 58 Hi-Hopes Road | state rep reelect | Yes |  | Windham
Spreadsheet: 49986d1249402711-conditonal-formatting-a-cell-based-on-other-cells-offset-with-lookup
Sheet: Rack Configuration

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Backbone 1 | Backbone 2 |  | Weight
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 355
 |  | Possible [NAME] 19"
 |  | Jonas Data Server Dell Poweredge R710 3U |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 2 |  | 65
 |  | [NAME] Poweredge R610 1U |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 1 |  | 36
 |  | [NAME] Poweredge R610 1U |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 1 |  | 36
 |  | [NAME] Poweredge R610 1U |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 1 |  | 36
 |  |  |  |  |  |  | 8-Port Linksys Management NICs
 |  |  |  |  |  |  |  | Tape Drive |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 15
 |  | SUA3000R3XLNETPKG  2700Watts 3U |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 |  | 140
 |  | SUA48RMXLBP3U 48V Rack Mountable Battery Pack 3U |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 140
 |  | SUA3000R3XLNETPKG  2700Watts 3U |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 |  | 140
 |  | SUA48RMXLBP3U 48V Rack Mountable Battery Pack 3U |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 |  | 140
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Totals |  |  |  |  |  |  | 11 | 5 |  | 1103 Lbs
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16 Ports
Spreadsheet: 689708d1596609820-if-function-exceeding-8000-character-limit-need-help-on-shorter-formula-au-and-nz-vendor-margin-analysis-fy20-ytd-test
Sheet: May

Margin and Sales by Vendor - May 2020
Vendor | Sales | Margin $ | Margin %
Netapp Aust | 1 | 1
Palo Alto Networks | 1 | 1
F5 | 1 | 1
Tenable | 1 | 1
Riverbed | 1 | 1
Nutanix | 1 | 1
Pure Storage | 1 | 1
Broadcom Solutions | 1 | 1
Hewlett Packard Enterprise | 1 | 1
Sophos | 1 | 1
Gigamon | 1 | 1
ForeScout | 1 | 1
Extreme Networks | 1 | 1
Microsoft | 1 | 1
Avaya | 1 | 1
Channel Services | 1 | 1
Arista | 1 | 1
Ribbon | 1 | 1
Cylance | 1 | 1
CS Vendors | 1 | 1
FireEye | 1 | 1
Cohesity | 1 | 1
[NAME] | 1 | 1
Amazon Web Services | 1 | 1
Infoblox | 1 | 1
Symantec | 1 | 1
Mellanox | 1 | 1
[NAME] | 1 | 1
[NAME] | 1 | 1
Check Point | 1 | 1
AlgoSec | 1 | 1
Blue Coat Systems | 1 | 1
BitTitan | 1 | 1
MobileIron | 1 | 1
Grand Total