tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 6bc2252f-8e9b-441c-99b5-760568e60583
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
AXINK | Test | AXINK | AXIN2 Gene, Known Mutation | AXIN2 Gene, Known Mutation | Polymerase Chain Reaction (PCR) Amplification/DNA Sequencing (PCR is utilized pursuant to a license agreement with Roche Molecular Systems, Inc.) | EDTA (lavender-top) tube: EDTA Yellow-Top (ACD) Tube: ACD |  |  | 3 | mL | This test can only be performed if a mutation has previously been identified in a family member of this individual.   [NAME] must arrive within 96 hours of draw.   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-Colon Cancer Patient Information Sheet (Supply T521) 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. | 1 mL | Note: No specimen should be rejected. If specimen is received in wrong anticoagulant or at an inappropriate temperature, include note to laboratory. If questions, contact laboratory. | An interpretive report will be provided. | Wednesday; 10 a.m. | 10 days | 16 days | 1 | 81479 |  |  |  |  | Rochester
AXINK | [NAME] | VARIES | Varies |  |  |  | Ambient
AXINK | Result | 33943 | Reason for Referral | Reason for Referral | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42349-1 | Reason for referral:Find:Pt:^Patient:Nar:
AXINK | Result | 33944 | Result | Result | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
AXINK | Result | 33945 | Interpetation | Interpetation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
AXINK | Result | 33946 | Method | Method | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 49549-9 | Reference lab test method:Type:XXX:Reference lab test:Nar:
AXINK | Result | 33947 | Amendment | Amendment | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
AXINK | Result | 33948 | [NAME] | [NAME] | Alphanumeric
AXINK | Result | 33949 | Source | Source | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31208-2 | [NAME] source:Prid:Pt:[NAME]:Nom:
AXINK | Result | 33950 | Reviewed By | Reviewed By | Alphanumeric
AXINK | Result | 33951 | Release Date | Release Date | Alphanumeric
Spreadsheet: 186787d1350220563-counting-number-of-days-in-several-periods-ignoring-repeating-dates-example1
Sheet: 1

 | Date of arrival | Date of departure
Person 1 | 2011-04-09 00:00:00 | 2011-11-13 00:00:00
Person 2 | 2011-10-11 00:00:00 | 2012-04-03 00:00:00
Person 3 | 2012-02-12 00:00:00 | 2012-02-18 00:00:00
Person 4 | 2011-11-29 00:00:00 | 2012-02-18 00:00:00
Person 5 | 2012-07-05 00:00:00 | 2012-09-01 00:00:00
Person 6 | 2012-09-11 00:00:00 | 2012-09-19 00:00:00
Person 7 | 2012-07-07 00:00:00 | 2012-07-30 00:00:00
Person 8 | 2012-12-22 00:00:00 | 2012-02-27 00:00:00
Person 9 | 2012-03-12 00:00:00 | 2012-04-19 00:00:00
Person 10 | 2011-01-14 00:00:00 | 2011-03-06 00:00:00
Spreadsheet: 119697d1314666377-counting-cells-without-repeat-pivot-of-names-and-events
Sheet: Sheet1

Name | Event | Time Start | Time End
[NAME] | Holiday Inn | 1509 | 1709 |  |  | Do a Pivot Table for count of names |  |  | Another Pivot by Event.  Also a Calculated Field
[NAME] | Holiday Inn | 1809 | 1909 |  |  | Row Labels | Count of Name |  | Row Labels | Sum of Time End | Sum of Time Start | Sum of Tot Time
[NAME] | [NAME] | 1200 | 1500 |  |  | [NAME] | 2 |  | Chill Hotel | 2900 | 2100 | 800
[NAME] | Chill Hotel | 1200 | 1500 |  |  | [NAME] | 1 |  | [NAME] | 1400 | 900 | 500
[NAME] | Chill Hotel | 900 | 1400 |  |  | [NAME] | 2 |  | [NAME] | 1500 | 1200 | 300
 |  |  |  |  |  | Grand Total | 5 |  | [NAME] | 1500 | 1200 | 300
 |  |  |  |  |  |  |  |  | [NAME] | 1500 | 1200 | 300
 |  |  |  |  |  |  |  |  | Holiday Inn | 3618 | 3318 | 300
 |  |  |  |  |  |  |  |  | [NAME] | 3618 | 3318 | 300
 |  |  |  |  |  |  |  |  | Grand Total | 8018 | 6618 | 1400
Spreadsheet: 750080d1633223082-find-count-consecutive-entries-in-a-row-in-excel-counting
Sheet: Sheet1

 |  | 1 | 2 | 3 | 4 | 5 | 1 | 2 | 3 | 2 | 1 | 2 | 5 | 1 | 3 | 2 | 1 | 4 | 4 | 3 | 2 | 5
Spreadsheet: 36072d1233834766-between-command-for-if-equations-example
Sheet: Sheet1

1st Issued | Month Returned |  | Current Period: |  | 2008-10-01 00:00:00 | 2009-04-02 00:00:00
2008-10-01 00:00:00
2008-10-01 00:00:00
2008-10-01 00:00:00
2008-10-01 00:00:00
2008-10-01 00:00:00
2008-10-01 00:00:00
2008-10-01 00:00:00
2008-10-01 00:00:00
2008-10-01 00:00:00
2008-10-01 00:00:00 | 2009-01-01 00:00:00 |  |  |  | So in here I want to say, IF (B12) falls between F1 and G1, then SUM(B12-A12)
2008-10-01 00:00:00
2008-10-01 00:00:00
2008-10-01 00:00:00
2008-10-01 00:00:00
2008-10-01 00:00:00 | 2009-01-01 00:00:00
2008-10-01 00:00:00
2008-10-01 00:00:00
2008-10-01 00:00:00
2008-10-01 00:00:00
2008-10-01 00:00:00
2008-10-01 00:00:00
2008-10-01 00:00:00
2008-10-01 00:00:00
2008-10-01 00:00:00
2008-10-01 00:00:00
2008-10-01 00:00:00
2008-10-01 00:00:00
2008-10-01 00:00:00
2008-10-01 00:00:00
2008-10-01 00:00:00
2008-10-01 00:00:00
2008-10-01 00:00:00
2008-10-01 00:00:00
2008-10-01 00:00:00
2008-10-01 00:00:00
2008-10-01 00:00:00 | 2009-01-01 00:00:00
2008-10-01 00:00:00
2008-10-01 00:00:00
2008-10-01 00:00:00 | 2008-12-01 00:00:00
2008-10-01 00:00:00
2008-10-01 00:00:00
2008-10-01 00:00:00
2008-10-01 00:00:00
2008-10-01 00:00:00
2008-10-01 00:00:00
2008-10-01 00:00:00
2008-10-01 00:00:00
2008-10-01 00:00:00
2008-10-01 00:00:00
2008-10-01 00:00:00
2008-10-01 00:00:00
2008-10-01 00:00:00
2008-10-01 00:00:00
2008-10-01 00:00:00
2008-12-01 00:00:00
2008-12-01 00:00:00
2009-01-01 00:00:00
2009-01-01 00:00:00
2009-01-01 00:00:00
Spreadsheet: 155943d1337112327-using-countif-and-avoiding-duplicates-example1
Sheet: Sheet1

Opponent | Opp's Wins | Opp's Losses |  | [NAME] | Cumulative Losses
SF | 5 | 6 |  | 19 | 25
SF | 5 | 6
SF | 5 | 6
Pit | 3 | 6
Pit | 3 | 6
Pit | 3 | 6
Atl | 6 | 6
Atl | 6 | 6
Atl | 6 | 6
Atl | 6 | 6
Phi | 5 | 7
Phi | 5 | 7
Spreadsheet: 2eb56c63-6d23-414a-ba0a-fa600213d773
Sheet: DC Enrll by Campus

Dual Credit Enrollment
Students 2007-08 through 2011-12
Enrollment By Campus
 | Number of Students*
Campus | AY 2007-08 | AY 2008-09 | AY 2009-10 | AY 2010-11 | AY 2011-12
ADVANCED TECHNOLOGY CENTER |  |  |  |  | 22
MAIN CAMPUS | 509 | 544 | 539 | 532 | 539
MONTOYA CAMPUS | 343 | 424 | 437 | 473 | 434
OFF CAMPUS | 232 | 358 | 428 | 479 | 679
RIO RANCHO CAMPUS |  |  |  | 79 | 67
SOUTH VALLEY CAMPUS | 26 | 76 | 41 | 47 | 81
WESTSIDE | 354 | 423 | 422 | 253 | 211
WORKFORCE TRAINING CENTER | 32 | 46 | 7 | 6 | 15
DISTANCE LEARNING | 32 | 134 | 360 | 780 | 910
*Students are unduplicated for each campus, but each student is counted at each campus he or she attended during each academic year
Spreadsheet: 690099d1596872496-using-countifs-over-muttiple-colums-book2
Sheet: Sheet1

Type 1 | type 2 | type 3 | type 4 | dates
Cat |  |  |  | 1
Cat | Cow | Chicken | Horse | 1
Cat |  |  |  | 1
Cat | Dog |  |  | 2
Dog |  |  |  | 2
Cow |  |  |  | 3
Dog | Cow | Horse |  | 3
Horse
Spreadsheet: 874287d1720862685-name-by-the-line-of-the-sheet-of-excel-vinhas-livro111-aligw
Sheet: Folha1

LT 1 | AA
LT 2 | AB |  |  |  |  |  |  | NOME | A
LT 3 | ABC
LT 4 | DEE
LT 5 | DER
LT 6 | AFD
LT 7
LT 8
LT 9
LT 10
LT 11
LT 12
LT 13
Spreadsheet: 481612d1474551918-retaining-a-manual-entry-in-an-index-table-comments
Sheet: Data table

 | Name | Phone | [NAME] | Industry
 | [NAME] | [PHONE] | [EMAIL] | Manufacturing
 | [NAME] | [PHONE] | [EMAIL] | Plastics
 | [NAME] | [PHONE] | [EMAIL] | Marketing
 | [NAME] | [PHONE] | [EMAIL] | Automotive
 | Carol | [PHONE] | [EMAIL] | Manufacturing
 | [NAME] | [PHONE] | [EMAIL] | Marketing
 | [NAME] | [PHONE] | [EMAIL] | Legal
 | [NAME] | [PHONE] | [EMAIL] | Automotive
 | [NAME] | [PHONE] | [EMAIL] | Manufacturing
 | [NAME] | [PHONE] | [EMAIL] | Food & Beverage
Spreadsheet: 329680d1404382230-check-the-data-from-two-sheet-and-result-on-third-sheet-check-the-data-from-two-sheet-and-result-on-third-sheet-data_24062014
Sheet: gratuity

Emp. No. | Sub Type | First Name | Last Name | DOB | % | Sex (M/F) | Relation
11 | Gratuity | SOMALI | SARKAR | 09.11.1979 | 100 | F | SPOUSE | 11
114 | Gratuity | ADITI | BANERJEE | 04.12.1964 | 50 | F | SPOUSE | 114
114 | Gratuity | ABHIJEET | BANERJEE |  | 50 | M | CHILD | 114
129 | Gratuity | PRIYA A | TAMHANE | 26.08.1972 | 100 | F | SPOUSE | 129
336 | Gratuity | BABY | SINGH KUMAR | 15.12.1972 | 100 | F | SPOUSE | 336
336 | Gratuity | BABY | SINGH KUMAR | 15.12.1972 | 100 | F | SPOUSE | 336
337 | Gratuity | KAKALI | DAS | 01.01.1973 | 100 | F | SPOUSE | 337
409 | Gratuity | SUBHASH LAXMAN | SHAUBHAG | 22.10.1961 | 10 | M | SPOUSE | 409
409 | Gratuity | SOHAM SUBHASH | SHANBHAG | 09.06.1996 | 45 | M | CHILD | 409
409 | Gratuity | SACHIT SUBHASH | SHANBHAG | 11.06.1999 | 45 | M | CHILD | 409
417 | Gratuity | SANDHYA BALKRISHNA | CHAUDHARI | 12.07.1965 | 100 | F | SPOUSE | 417
418 | Gratuity | PRAMITA DIGAMBOR | TAMBOLI |  | 100 | F | SPOUSE | 418
419 | Gratuity | UMA ANAND | SINGH | 11.09.1968 | 50 | F | SPOUSE | 419
419 | Gratuity | ABHINAV ANAND | SINGH |  | 50 | M | CHILD | 419
841 | Gratuity | [NAME] | ANANT | 10.05.1957 | 100 | M | FATHER | 841
842 | Gratuity | [NAME] | KHARAT | 12.07.1982 | 100 | F | SPOUSE | 842
843 | Gratuity | SANGEETA VIJAY | TAMBITKAR |  | 100 | F | SPOUSE | 843
851 | Gratuity | VASANT DURGAJI | KHARIVALE |  | 100 | F | SPOUSE | 851
852 | Gratuity | MUKESH VIJAY | NIKAM | 30.11.1985 | 100 | F | MOTHER | 852
853 | Gratuity | AMRUTA ABHIJEET | PATIL | 14.07.1987 | 100 | F | SPOUSE | 853
854 | Gratuity | SONALI NILESH | DHENDE | 02.10.1987 | 100 | F | SPOUSE | 854
856 | Gratuity | [NAME] | NAIK | 13.03.1982 | 100 | F | SPOUSE | 856
857 | Gratuity | REKHA G. | [NAME] | 09.03.1976 | 100 | F | SPOUSE | 857
875 | Gratuity | [NAME] | PATIL | 30.07.1986 | 100 | M | SPOUSE | 875
876 | Gratuity | PATIL NILAM | RUPESH |  | 100 | F | SPOUSE | 876
877 | Gratuity | GULAB ANANT | PATIL |  | 100 | F | MOTHER | 877
878 | Gratuity | VIMAL | [NAME] |  | 100 | F | MOTHER | 878
880 | Gratuity | KUSUM S | SHARMA | 13.12.1985 | 100 | F | SPOUSE | 880
Spreadsheet: john_griffith__16188__1_29_02OH
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | HO G2 | EXP |  |  | 43 | 60 | 1.72 | 2002-01-25 15:07:00
 | [NAME] | 53 | 530 | 600 | 46.2 | 52.3 | 1.64 | 2002-01-29 14:58:00
 | HO J2 | 53 | 750 | 850 | 46 | 52.2 | 1.64 | 2002-01-29 14:58:00
 | HO K2 | 53 | 900 | 990 | 44.3 | 48.8 | 1.55 | 2002-01-29 14:58:00
 | HO M2 | 53 | 1000 | 1080 | 42 | 45.4 | 1.46 | 2002-01-29 14:58:00
 | HO N2 | 54 | 1100 | 1190 | 41 | 44.4 | 1.45 | 2002-01-29 14:58:00
 | HO Q2 | 55 | 1200 | 1250 | 40.1 | 41.7 | 1.41 | 2002-01-29 14:58:00
 | HO U2 | 56 | 1270 | 1350 | 38.5 | 41 | 1.4 | 2002-01-29 14:58:00
 | [NAME] | 57 | 1320 | 1390 | 37 | 39 | 1.36 | 2002-01-29 14:58:00
 | HO X2 | 58 | 1370 | 1450 | 35.6 | 37.6 | 1.33 | 2002-01-29 14:58:00
 | [NAME] | 58 | 1400 | 1500 | 34.7 | 37.2 | 1.31 | 2002-01-29 14:58:00
 | HO F3 | 59 | 1400 | 1550 | 32.7 | 36.2 | 1.28 | 2002-01-29 14:58:00
 | [NAME] | 59 | 1475 | 1625 | 33 | 36.4 | 1.29 | 2002-01-29 14:58:00
 | HO H3
 | HO J3 |  |  |  |  |  | 0.72 | 2001-07-18 22:45:00
 | [NAME]
Spreadsheet: cbb1199b-3f86-4524-9e8a-449888674421
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
GAABS | Test | GAABS | [NAME], Blood Spot | [NAME], BS | Fluorometric Enzyme Assay |  |  |  | 2 | Blood spots | Container/Tube:  Preferred: Whatman Protein Saver 903 Paper Acceptable: Ahlstrom 226 Filter Paper, Supplemental Newborn Screening Card (Supply T493) [NAME]: 2 blood spots Collection Instructions:  1. Do not use device or capillary tube containing EDTA to collect specimen. 2. An alternative blood collection option for a patient >1 year of age is fingerstick. 3. Let blood dry on the filter paper at ambient temperature in a horizontal position for 3 hours. 4. Do not expose specimen to heat or direct sunlight. 5. Do not stack wet specimens. 6. Keep specimen dry. 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. | Blood Spot: 1 | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	Blood spot specimen that shows serum rings or has multiple layers | Normal >7.4 pmol/punch/h | Thursday; morning | 8 days | 15 days | 1 | 82657 |  |  |  |  | Rochester
GAABS | [NAME] | BLOOD | Whole blood |  |  |  | Ambient | 87 days
GAABS | Result | 30096 | [NAME] | [NAME] | Alphanumeric
GAABS | Result | 30097 | [NAME] | [NAME] | Alphanumeric
GAABS | Result | 30098 | Source | Source | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 31208-2 | [NAME] source:Prid:Pt:[NAME]:Nom:
GAABS | Result | 30099 | Order Date | Order Date | Alphanumeric
GAABS | Result | 30100 | Reason For Referral | Reason For Referral | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 42349-1 | Reason for referral:Find:Pt:^Patient:Nar:
GAABS | Result | 30101 | Method | Method | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 49549-9
GAABS | Result | 30149 | Acid alpha-glucosidase | Acid alpha-glucosidase | Numeric |  |  |  |  | pmol/punch/h |  |  |  |  |  |  |  |  |  | 55827-0 | [NAME] glucosidase A:CCnc:Pt:Bld.dot:Qn:
GAABS | Result | 30102 | Interpretation | Interpretation | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 59462-2
GAABS | Result | 30103 | Amendment | Amendment | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
GAABS | Result | 30104 | Reviewed By | Reviewed By | Numeric
GAABS | Result | 30105 | Release Date | Release Date | Alphanumeric
Spreadsheet: 860986d1709005270-custom-formatting-time-duration-and-editing-a-time-calculation-efsumround
Sheet: Sheet1

Work Screen
Time In | Time Out | Duration | Employers Spreadsheet
10:00:00 | 22:00:00 |  | 12
06:00:00 | 08:06:00 |  | 2.1
17:32:00 | 20:32:00 |  | 3
21:11:00 | 23:34:00 |  | 2.38
06:01:00 | 08:00:00 |  | 1.98
17:39:00 | 20:30:00 |  | 2.85
20:40:00 | 23:47:00 |  | 3.12
06:30:00 | 07:56:00 |  | 1.43
17:26:00 | 20:35:00 |  | 3.15
20:54:00 | 23:23:00 |  | 2.48
06:38:00 | 08:04:00 |  | 1.43
17:47:00 | 20:50:00 |  | 3.05
21:09:00 | 23:46:00 |  | 2.62
16:24:00 | 23:23:00 |  | 6.98
16:59:00 | 20:27:00 |  | 3.47
 |  | Total Hours
Spreadsheet: 788026d1658230739-creating-automatic-list-of-active-employees-sheet1
Sheet: Sheet1

 | Employees | Resignation Date |  | Expected Results
 | Emp01
 | Emp02 | 2022-05-01 00:00:00
 | Emp03
 | [NAME]
 | Emp05 | 2022-07-01 00:00:00
 | Emp06
 | Emp07
 | Emp08
 | Emp09 | 2022-10-25 00:00:00
 | Emp10
Spreadsheet: 081fb29f-a255-4808-8777-d767fcaa672d
Sheet: Sheet1

MJ SPRING 2014 COURSE SCHEDULE | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
TRACKS | COURSE TITLE | SUBJ | NO | SEC | CREDITS | PROFESSOR
Corp-Standard-Smr 2012 | COMPLIANCE IRREGULARITIES & FINANCIAL FRAUD | MJ | 6029 | 0 | 3 | ROTTURA
Corp-Spr,Smr,Fall 2013,2014 | CONTRACT DRAFTING | MJ | 663 | 0 | 3 | ROTTURA
Corp-Cert Smr 2012 Graduating class | CAPSTONE FOR MJ CORPORATE: CERT IN REG ANALYSIS & COMPLIANCE | MJ | 728 | 0 | 3 | FLANAGAN
Corp Smr 2012 Graduating class | CORPORATE COMPLIANCE & ETHICS II | MJ | 725 | 0 | 3 | STITCHER
Corp-Smr 13  Fall 2014 | CORPORATE REGULATORY COMPLIANCE: RULES & STANDARDS | MJ | 6063 | 0 | 3 | TRULUCK
Spr 2014 all entering students | CRITICAL LEGAL ANALYSIS & WRITING | MJ | 509 | 0 | 3 | WALKER/KROH
Hlth-Smr 2012 Graduating class | HEALTHCARE COMPLIANCE & ETHICS II | MJ | 724 | 0 | 3 | FINKELSTEIN
Hlth Smr 2012 Graduating Class | CAPSTONE FOR MJ HEALTH: CERT IN REG ANALYSIS & COMPLIANCE | MJ | 729 | 0 | 3 | GLESSNER
Smr 2012 and Fall 2013 cert | HEALTHCARE & BUSINESS TRANSACTIONS | MJ | 600 | 0 | 3 | RHOADES
Spr 13 all; Smr 2013 | HEALTHCARE QUALITY & LIABILITY | MJ | 709 | 0 | 3 | BALLANTYNE
Spr 2014 all entering students | INTRODUCTION TO LAW | MJ | 500 | 0 | 2 | KROH/GRENA
Spr 2013, Smr 13, Fa 13 | INTRODUCTION TO LEGAL NURSE CONSULTING | MJ | 601 | 0 | 3 | LARSON
Smr 12 Graduating LNC's | LEGAL MEDICAL RESEARCH | MJ | 606 | 0 | 3 | DIAZ/GRENA
Smr 12 Graduating LNC's | PRINCIPLES & PRACTICES OF LEGAL NURSE CONSULTANT | MJ | 607 | 0 | 3 | KOPISHKE
Spreadsheet: 550251d1512173597-spreadsheet-to-automatically-compare-data-vs-the-same-day-last-year-copy-of-weather-example2
Sheet: Rework

 |  | Average Temperature
 |  | This Year | Last Year |  | vs Last Year |  | << difference in temperature returned in cell F2, updating with the new temperature difference after each new day input
Day
 | 2017-12-01 00:00:00 | 11 | 8
 |  | 10 | 9
 |  | 12 | 13
 |  |  | 12
 |  |  | 10
 |  |  | 9
 |  |  | 9
 |  |  | 9
 |  |  | 8
 |  |  | 9
 |  |  | 11
 |  |  | 13
 |  |  | 12
 |  |  | 11
 |  |  | 12
 |  |  | 13
 |  |  | 13
 |  |  | 13
 |  |  | 14
 |  |  | 14
 |  |  | 15
 |  |  | 16
 |  |  | 15
 |  |  | 14
 |  |  | 13
 |  |  | 13
 |  |  | 12
 |  |  | 12
 |  |  | 11
 |  |  | 11
 |  |  | 11
Spreadsheet: darrell_schoolcraft__7335__imball0203
Sheet: Amoco Abo

 | [NAME] |  | Amoco Abo fuel del
Day | Measured | Scheduled | Measured | Scheduled | Imbal
1 | 13 |  | -666
2 | 12 |  | -3300
3 |  |  | -3941
4 |  |  | -3861
5 |  |  | -3809
6 |  |  | -3887
7 |  |  | -3882
8 |  |  | -1118
9
10 | 1
11 | 678
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2002-02-28 00:00:00 |  |  |  |  | 178356.43
2002-03-12 00:00:00
CBS Volume
 |  |  | -355979
Spreadsheet: 808843d1670691380-coffee-bean-inventory-and-roasting-tracker-coffee-bean-roasting-tracker
Sheet: Green Bean Taken For Roast

Date | Coffee Beans With Origin | UOM | Stock On Hand | Taken for Roasting | Output of Roasting | Wastage Amount | Wastage %
 | Batch 001 - Chittagong |  | 13 | 4 | 3.9
 | Batch 001 - Chittagong |  | 9 | 3
 | Batch 001 - Chittagong |  | 6
Spreadsheet: 166288d1341520758-summary-sheet-help-game-stats
Sheet: Azalia Park 7-2-12

 | 1st | 2nd | 3rd | 4th | 5th | AB'S | QAB'S | QAB % | # of Innings | # of Batters | 1st Pitch Strike | Stikes | Balls | # of Pitches | Walks | [NAME] | Quality Inning | % Strikes | 1st Inning |  |  |  | 2nd Inning |  |  |  | 3rd Inning |  |  |  | 4th Inning |  |  |  | 5th Inning |  |  |  | 6th Inning
Player | HITTING |  |  |  |  |  |  |  | PITCHING |  |  |  |  |  |  |  |  |  | Pos | 7/13 | E | GP | Pos | 7/13 | E | GP | Pos | 7/13 | E | GP | Pos | 7/13 | E | GP | Pos | 7/13 | E | GP | Pos | 7/13 | E | GP | E's | GP's
Preston | 0 | 6 | 0 | 0 |  |  |  |  | 4 | 21 | 15 | 51 | 19 |  | 0 | 5 | 2 |  | 1 | ✔ |  |  | 1 | ✔ |  |  | 1 | ✔ |  |  | 1 | ✔ |  |  | 1,5 | ✔ |  |  | 5 | ✔
[NAME] | 2 | 6 | 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7 | ✔ |  |  | 7 | ✔ |  |  | 7 | ✔ |  | 2 | 7 | ✔ |  |  | 7 | ✔ |  |  | 7 | ✔ |  | 1
MA | 0 | 61 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6 | ✔ |  |  | 6 | ✔ |  |  | 6 | ✔ |  |  | 6 |  |  |  | 6 | ✔ |  |  | 6 | ✔
Brighton | 0 | 61 | 61 |  |  |  |  |  | 0.3333333333333333 | 1 |  | 1 | 1 |  | 0 | 0 |  |  | 5 | ✔ |  |  | 5 |  |  |  | 5 | ✔ |  |  | 5 | ✔ |  |  | 5,8 | ✔ | 2 |  | 8 | ✔
[NAME] | 0 | 0 | 0 |  |  |  |  |  | 1.666666666666667 | 5 | 2 | 15 | 5 |  | 0 | 4 | 2 |  | 8 | ✔ |  |  | 8 |  |  |  | 8 | ✔ |  |  | 8 | ✔ |  |  | 8,1 | ✔ |  |  | 1,8 | ✔ |  | 1
[NAME] | 65 | 0 | 64 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | ✔ |  |  | 4 | ✔ |  |  | 2 | ✔ |  |  | 2 | ✔ |  |  | 2 | ✔ |  |  | 2 | ✔
Aiden | 61 | 0 | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | ✔ |  |  | 3 | ✔ |  |  | 3 | ✔ |  |  | 3 | ✔ |  |  | 3 | ✔ |  |  | 3 | ✔
[NAME] | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | ✔ |  |  | 4 | ✔ |  |  |  |  |  |  | 4 | ✔
[NAME] | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 | ✔ |  |  | 9 | ✔ |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 | ✔
Tanner K | 61 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 | ✔
Tanner B | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 | ✔ |  |  | 9 | ✔
[NAME] | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | ✔
Tyler | 6 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | ✔ |  |  | 2 | ✔
TOTALS
Date | 2012-07-02 00:00:00
Opponent | Azalia Park
Result | W 9-5
B.A.S.E.2 CHECKLIST
 | B. | A. | S. | E. | 2 | TOTAL
 | 1 | 1 |  | 1 | 1
"Team Goal Oriented"
QUALITY AT BATS
1. Hit Ball Hard
2. Walk
3. Hit By Pitch
4. Move Runners with ≤ 1 Out
5. Score [NAME] from 3rd with < [NAME]
6. Base Hit
7. Six Pitch AB Not Ending in Strikeout
8. Nine Pitch AB Even Ending in Strikeout
9. Catcher Interference
Spreadsheet: 39690d1237979367-finding-the-modal-value-of-a-word-in-a-set-of-filtered-data-example
Sheet: Calculations (2)

 | Grower | Lot | Product | Variety | Amount Received | Amount Rejected | Reason | Percentage
 | GROWER1 | 1231453 | Product A | MIXED | 24000
 | GROWER2 | 2342342 | Product B | MIXED | 33655 | 2019.3 | OPEN BUDS | 6
 | GROWER2 | 23476623 | Product A | PINK FANCY | 55000 | 54000 | YELLOWING | 95
 | GROWER2 | 234623 | Product C | TASSMAN FA | 4000 | 120 |  | 3
 | GROWER2 | 23627 | Product D | GIOELLE FA | 6400 | 64 |  | 1
 | GROWER2 | 12336 | Product A | PINK FANCY | 11960 | 1674.4 | BRUISING | 14
 | GROWER2 | 23462345 | Product E | SPRAY PINK | 6200 | 62 |  | 1
 | GROWER2 | 6234 | Product F | ROSITAVEND | 2112 | 21.12 |  | 1
 | GROWER2 | 234156 | Product G | OCEANSONG | 1728 | 172.8 | BRUISING | 10
 | GROWER2 | 2356 | Product A | PINK FANCY | 14400 | 1152 | BRUISING | 8
 | GROWER2 | 236214 | Product N | PRADO | 1600 | 16 |  | 1
 | GROWER2 | 236243 | Product M | [NAME] | 1600 | 16 |  | 1
 | GROWER2 | 13625 | Product Z | VENDELA | 9024 | 902.4 | BRUISING | 10
 |  |  |  |  |  | Main Rejection Reason | BRUISING | <--------
Spreadsheet: 100988d1299175388-array-formula-help-suming-multiple-datasets-example-sumofdatasets
Sheet: Sheet1

 |  |  |  |  | I need an equation which returns the sum of datasets for each field of data, each field of data is spaciailly seperated by 4 rows.
 |  |  |  |  |  | I believe an array formulae will achieve this.
Data 1 | Data 2 | Data 3 | Sum data | sum of data sets
Data 1 | Data 2 | Data 3 | Sum data | sum of data sets
Data 1 | Data 2 | Data 3 | Sum data | sum of data sets
Spreadsheet: 866351d1713290370-cell-content-in-3-columns-to-copy-into-a-new-4th-column-excel-forum-sample-2
Sheet: Sheet2

 | Existing Data |  |  |  |  | Desired | Finished | Result
 |  | 1 |  |  |  |  | 1 | 1
1 |  |  |  |  | 1 |  |  | 1
1 |  |  |  |  | 1 |  |  | 1
 |  | 1 |  |  |  |  | 1 | 1
 |  | 1 |  |  |  |  | 1 | 1
 | 1 |  |  |  |  | 1 |  | 1
1 |  |  |  |  | 1 |  |  | 1
 | 1 |  |  |  |  | 1 |  | 1
1 |  |  |  |  | 1 |  |  | 1
 | 2 |  |  |  |  | 2 |  | 2
 |  | 1 |  |  |  |  | 1 | 1
 | 1 |  |  |  |  | 1 |  | 1
2 |  |  |  |  | 2 |  |  | 2
 |  | 2 |  |  |  |  | 2 | 2
 | 1 |  |  |  |  | 1 |  | 1
2 |  |  |  |  | 2 |  |  | 2
 |  | 3 |  |  |  |  | 3 | 3
 |  | 1 |  |  |  |  | 1 | 1
 | 2 |  |  |  |  | 2 |  | 2
1 |  |  |  |  | 1 |  |  | 1
1 |  |  |  |  | 1 |  |  | 1
 | 3 |  |  |  |  | 3 |  | 3