tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 03056401-4331-425f-9451-29bae7c6a4d3
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | [NAME] for Classes 07, 08, 09, 10 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
Major | # year 1 | # year 2 | Retention 1 to 2 | # year 3 | Retention 2 to 3 | # year 4 | Retention 3 to 4 | # still attending after 4 years | # Graduated in 5 or less | % Graduated in 5 years
 |  |  | Class of 2007
BA | 30 | 24 | 0.8 | 23 | 0.9583333333333334 | 14 | 0.6086956521739131 | 0 | 9 | 0.3
ET | 53 | 49 | 0.9245283018867925 | 47 | 0.9591836734693877 | 44 | 0.9361702127659575 | 23 | 40 | 0.7547169811320755
GSMA | 12 | 12 | 1 | 10 | 0.8333333333333334 | 10 | 1 | 0 | 9 | 0.75
ME | 45 | 31 | 0.6888888888888889 | 24 | 0.7741935483870968 | 23 | 0.9583333333333334 | 5 | 23 | 0.5111111111111111
MT | 82 | 76 | 0.926829268292683 | 73 | 0.9605263157894737 | 63 | 0.863013698630137 | 16 | 61 | 0.7439024390243902
 |  |  | Class of 2008
BA | 35 | 26 | 0.7428571428571429 | 21 | 0.8076923076923077 | 16 | 0.7619047619047619 | 0 | 8 | 0.2285714285714286
ET | 43 | 38 | 0.8837209302325582 | 35 | 0.9210526315789473 | 35 | 1 | 4 | 30 | 0.6976744186046512
GSMA | 19 | 18 | 0.9473684210526315 | 16 | 0.8888888888888888 | 15 | 0.9375 | 0 | 18 | 0.9473684210526315
ME | 38 | 33 | 0.868421052631579 | 28 | 0.8484848484848485 | 28 | 1 | 5 | 23 | 0.6052631578947368
MT | 79 | 69 | 0.8734177215189873 | 63 | 0.9130434782608695 | 60 | 0.9523809523809523 | 1 | 59 | 0.7468354430379747
 |  |  | Class of 2009
BA | 21 | 15 | 0.7142857142857143 | 8 | 0.5333333333333333 | 8 | 1
ET | 46 | 39 | 0.8478260869565217 | 35 | 0.8974358974358975 | 30 | 0.8571428571428571
GSMA | 33 | 25 | 0.7575757575757576 | 25 | 1 | 20 | 0.8 |  | 6
ME | 36 | 31 | 0.8611111111111112 | 28 | 0.9032258064516129 | 27 | 0.9642857142857143
MT | 99 | 89 | 0.898989898989899 | 75 | 0.8426966292134831 | 66 | 0.88
 |  |  | Class of 2010
BA | 29 | 23 | 0.7931034482758621 | 16 | 0.6956521739130435
ET | 57 | 40 | 0.7017543859649122 | 41 | 1.025
GSMA | 26 | 16 | 0.6153846153846154 | 9 | 0.5625 |  |  |  | 1
ME | 42 | 37 | 0.8809523809523809 | 28 | 0.7567567567567568
MT | 88 | 82 | 0.9318181818181818 | 75 | 0.9146341463414634
Notes: 1.  [NAME] is in % returning, graduation in is % graduated.  The 2007 and 2008 graduation % will increase as there are still
students attending from those classes.
2.  These numbers treat all students a freshmen regardless of transfer credits.  These numbers will be different that the IPEDs report
which focus on First-time freshmen.
Spreadsheet: kam_keiser__18045__Summary of Book Requests PowerUpdate
Sheet: TAGG

 | COUNTERPARTY |  | BOOK PURPOSE |  |  | TAGG |  |  |  |  |  |  |  |  | BOOK INFORMATION
 |  |  | Type Of Transactions |  |  | Book Mapping
 | Short Name | Long Name | Internal | External | Both | Code | Region | P | B | Idx | [NAME] | PHY | Y | Commodity/UOM/Curr | [NAME] | MTM/ACCRUAL | Reason For Book | Date Needed
166967 | PWR-GAS-NW | POWERGASNORTHWEST | x |  |  | MJ | NYMEX2 | x |  |  |  |  |  | GAS/MMBTU/USD | [NAME] | MTM | Netco | ASAP
166968 | PWR-GAS-SW | POWERGASSOUTHWEST | x |  |  | MJ | NYMEX3 | x |  |  |  |  |  | GAS/MMBTU/USD | [NAME] | MTM | Netco | ASAP
166969 | PWR-GAS-CALI | POWERGASCALIFORNIA | x |  |  | MJ | NYMEX4 | x |  |  |  |  |  | GAS/MMBTU/USD | [NAME] | MTM | Netco | ASAP
166973 | PWR-GAS-MGMT | POWER GAS MANAGEMENT | x |  |  | ME | NYMEX1 |  |  |  | x |  | x | GAS/MMBTU/USD | [NAME] | MTM | Netco | ASAP
166961 | PWR-GAS-OPTION | POWER GAS OPTION | x |  |  | ME | NYMEX2 |  |  |  | x |  | x | GAS/MMBTU/USD | [NAME] | MTM | Netco | ASAP
167192 | PWR-GAS-PJM | POWER GAS PJM | x |  |  | ME | NYMEX3 |  |  |  | x |  | x | GAS/MMBTU/USD | [NAME] | MTM | Netco | ASAP
166962 | PWR-GAS-NE | POWER GAS NORTHEAST | x |  |  | ME | NYMEX4 |  |  |  | x |  | x | GAS/MMBTU/USD | [NAME] | MTM | Netco | ASAP
166963 | PWR-GAS-MW | POWER GAS MIDWEST | x |  |  | ME | NYMEX5 |  |  |  | x |  | x | GAS/MMBTU/USD | [NAME] | MTM | Netco | ASAP
166965 | PWR-GAS-ERCOT | POWER GAS ERCOT | x |  |  | ME | NYMEX6 |  |  |  | x |  | x | GAS/MMBTU/USD | [NAME] | MTM | Netco | ASAP
167108 | PWR-GAS-LT-ERCT | POWER GAS LONG TERM ERCOT | x |  |  | MQ | NYMEX1 | x |  |  | x |  | x | GAS/MMBTU/USD | [NAME] | MTM | Netco | ASAP
167109 | PWR-GAS-SE | POWER GAS SOUTHEAST | x |  |  | MQ | NYMEX2 | x |  |  | x |  | x | GAS/MMBTU/USD | [NAME] | MTM | Netco | ASAP
167111 | PWR-GAS-ST-PJM | POWER GAS SHORT TERM PJM | x |  |  | MQ | NYMEX3 | x |  |  | x |  | x | GAS/MMBTU/USD | [NAME] | MTM | Netco | ASAP
167113 | PWR-GAS-ST-ERCT | POWER GAS SHORT TERM ERCOT | x |  |  | MQ | NYMEX4 | x |  |  | x |  | x | GAS/MMBTU/USD | [NAME] | MTM | Netco | ASAP
167114 | PWR-GAS-ST-NY | POWER GAS SHORT TERM NEW YORK | x |  |  | MQ | NYMEX5 | x |  |  | x |  | x | GAS/MMBTU/USD | [NAME] | MTM | Netco | ASAP
167115 | PWR-GAS-ST-MW | POWER GAS SHORT TERM MIDWEST | x |  |  | MQ | NYMEX6 | x |  |  | x |  | x | GAS/MMBTU/USD | [NAME] | MTM | Netco | ASAP
167116 | PWR-GAS-OPTB | POWER GAS OPTION B | x |  |  | MQ | NYMEX7 | x |  |  | x |  | x | GAS/MMBTU/USD | [NAME] | MTM | Netco | ASAP
167199 | PWR-GAS-OPTA | POWER GAS OPTION A | x |  |  | MQ | NYMEX8 |  |  |  | x |  | x | GAS/MMBTU/USD | [NAME] | MTM | Netco | ASAP
167200 | PWR-GAS-ST-SE | POWER GAS SHORT TERM SOUTHEAST | x |  |  | MQ | NYMEX9 |  |  |  | x |  | x | GAS/MMBTU/USD | [NAME] | MTM | Netco | ASAP
Spreadsheet: 815537d1675016599-formula-to-show-numbers-for-timestamps-book3
Sheet: Sheet1

00:00:00 | 0
1900-01-01 00:00:00 | 0
00:02:00 | 2
00:03:00 | 3
00:04:00 | 4
00:05:00 | 5
00:07:00 | 7
00:08:00 | 8
00:10:00 | 10
00:11:00 | 11
00:12:00 | 12
00:14:00 | 14
00:15:00 | 15
00:17:00 | 17
00:18:00 | 18
00:19:00 | 19
00:20:00 | 20
Spreadsheet: 738401d1625016263-required-only-filtered-data-which-are-out-but-not-recd-back-summary-index-and-aggregate-ajay45822-
Sheet: Data

 | product code | detail 1 | detail 2 | detail 3 | detial 4
1 | kk546 | inhouse | netherland
2 |  | sent |  | kk546 | rock
3 | kk547 | inhouse | finland
4 |  | sent |  | kk547 | mark
5 |  | sent |  | kk547 | [NAME]
6 |  | sent |  | kk547 | flip
7 | kk548 | inhouse | netherland
8 |  | recd |  | kk547 | mark
9 |  | Sent |  | kk547 | mark
10 |  | recd |  | kk546 | rock
11 |  | Sent |  | kk548 | mark
12 | kk549 | inhouse | Australia
Spreadsheet: d71ac47f-b94d-412f-b089-3ba555f97d5a
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
9840 | Test | 9840 | Periodic Acid-Schiff (PAS) Stain | Periodic Acid-Schiff (PAS) ST | Includes pathology consultation charged separately. | Formalin-fixed, paraffin-embedded tumor tissue block. Include 1 H & E slide: FFPTHE |  |  |  | Varies | Container/Tube:  Preferred: Formalin-fixed, paraffin-embedded tissue block Acceptable: Tissue in formalin Collection Instructions: Include 1 hematoxylin-and-eosin stained slide. |  | Hemolysis	NA Thawing	NA Lipemia	NA Icterus	NA Other	NA | The laboratory will provide a pathology consultation and stained slide. | Monday through Friday 7 a.m. | 2 days | 5 days | 1 | 88313 |  |  |  |  | Rochester
9840 | [NAME] | TISSUE | Tissue |  |  |  | Ambient
9840 | Result | 9840 | Periodic Acid-Schiff (PAS) ST | Periodic Acid-Schiff (PAS) ST |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6675-3
Spreadsheet: 851098d1701349541-bracket-manager-help-march-madness-march-madness-bracket-master
Sheet: 2024

2024 HMRC Basketball Pool
Entries | Tie Breaker | Paid | Round 1 (1 pt.) | Round 1 Bonus | Round 2 (2pt.) | [NAME] (5pt.) | [NAME] (8pt.) | Final Four Bonus (4pt.) | Final Four (10pt.) | Championship (16pt.) | Total | Championship Pick
Spreadsheet: 800992d1666023190-formula-to-get-value-according-date-copy-of-book1-1-
Sheet: Sheet1

 |  |  |  |  |  |  | Date | 2022-10-13 00:00:00 | 2022-10-13 00:00:00 | 2022-10-13 00:00:00 | 2022-10-13 00:00:00 | 2022-10-13 00:00:00 | 2022-10-14 00:00:00 | 2022-10-14 00:00:00 | 2022-10-14 00:00:00 | 2022-10-14 00:00:00 | 2022-10-14 00:00:00 | 2022-10-15 00:00:00 | 2022-10-15 00:00:00 | 2022-10-15 00:00:00 | 2022-10-15 00:00:00 | 2022-10-15 00:00:00
 |  |  |  |  |  |  |  | Math | Science | Geo | History | English | Math | Science | Geo | History | English | Math | Science | Geo | History | English
 |  |  |  |  |  |  | George | A | A | A | P | P | A | A | A | A | A | A | A | P | A | A
 |  |  |  |  |  |  | [NAME] | P | P | P | P | P | A | A | A | A | A | P | P | P | P | A
 |  |  |  |  |  |  | Leen | A | A | A | A | P | P | P | P | P | P | P | P | P | P | A
 |  |  |  |  |  |  | [NAME] | A | P | P | A | A | P | A | A | A | A | A | A | A | A | A
 |  |  |  |  |  |  | [NAME] | A | A | A | A
 |  |  |  |  |  |  | Sara | A | A | A |  |  | A | A | A | A | A | P | P | P | P | P
 |  |  |  |  |  |  | Toni | A | A | A | P | P |  | A | A | A | A
 |  |  |  |  |  |  | [NAME] | A | A | A | A | A | P | P | P | P | P
 |  |  |  |  |  |  | Rachel | A | A | A | A | P | A | A | A | A | A | A | A | A | A | P
 |  |  |  |  |  |  | Dima | A | A | A | A | A | P | A | A | A | A | P | A | A | A | A
 |  |  |  |  |  |  | each date has five hours for five subject along the year
 |  |  |  |  |  |  | I need formula to search for the name that has at least one letter A as ( Absent ) and get the five letter (A and P)  according the date I entered below
 |  |  |  |  |  |  | and ignore the name that has letter P as (Present) in the five hours in that date
 |  |  |  |  |  |  | Example
 |  |  |  |  |  |  | Date | 2022-10-13 00:00:00 |  |  |  |  |  | if date I cell I25 = 15-10-2022
 |  |  |  |  |  |  |  |  | A | A | P | P
 |  |  |  |  |  |  |  |  | A | A | A | P
 |  |  |  |  |  |  |  |  | P | P | A | A
 |  |  |  |  |  |  |  |  | A | A | A
 |  |  |  |  |  |  |  |  | A | A
 |  |  |  |  |  |  |  |  | A | A | P | P
 |  |  |  |  |  |  |  |  | A | A | A | A
 |  |  |  |  |  |  |  |  | A | A | A | P
 |  |  |  |  |  |  |  |  | A | A | A | A
Spreadsheet: 125118d1318882408-looking-for-calendar-w-daily-cash-flow-register-checkbook-register
Sheet: Help

Check Book Register - HELP |  |  |  |  |  |  | © 2008 Vertex42 LLC
 |  |  |  |  |  |  |  | [42]
1. Enter your starting balance in the Balance column in the first row of the register.
2. In subsequent transactions, the Balance will be calculated for you.
3. To add a transaction, copy an existing row and paste it in a blank row after the last transation.
You may need to first insert a row after the last transaction by right-clicking on the last row
number and selecting "Insert 1 Below".
4. You will need to copy the formula in the Balance column when adding a transaction.
When adding, deleting, inserting, copying, or pasting transactions in the Register,
you will have fewer errors or problems if you delete/insert/copy/paste the entire row.
This is done by first right-clicking on the Row number.
The Balance formula will not work if you leave a blank row in between transactions.
Deleting a Transaction
To delete a transaction, right-click on the Row number and select "Delete Row".
If you select the Row number and press the Delete key, it will only clear the
contents of the row, instead of removing the entire row.
Example Entries in the NUM Field
2032 | (check number)
EFT | (electronic funds transfer)
DEP | (deposit)
TXFR | (transfer to/from other account)
CARD | (debit/check card)
FEE | (bank fees)
"R" is for "Reconcile"
When balancing your check book, add an R in this column to indicate that the
transaction is correct and reconciled with your bank statement.
Spreadsheet: 855131d1704814192-vba-code-to-make-my-classes-schedule-for-number-of-days-with-available-faculty-test-file-rohan999-
Sheet: Sheet1

faculty available NAME | No of days Program | Subjects | which faculty takes which class | each day classes | each session hr | Session start date | DATE ON WHICH SOME FACULTY IS NOT AVAIBALE | FACULTY NAME WHO IS NOT AVAILABLE | Class Times
[NAME] | 21 | a1 | ANUJ | 4 | 1.3 | 2023-12-29 00:00:00 | 2023-12-30 00:00:00 | ANUJ | 10:00:00 |  |  |  |  | tab of vba to click
RAGHAV |  | a2 | RAGHAV |  |  | End | 2024-01-01 00:00:00 | GOKUL | 11:45:00
NITIN |  | a3 | ANUJ |  |  |  |  |  | 13:45:00 |  |  |  |  | on clicking [NAME]
GOKUL |  | a4 | GOKUL |  |  |  |  |  | 15:30:00 |  |  |  |  | the result permutations and schedule will come at sHEET 2 of same workbook
 |  | a5 | NITIN
 |  | a6 | RAGHAV
 |  | a7 | ANUJ
 |  | [NAME] | GOKUL
 |  | a9 | RAGHAV
 |  | a10 | NITIN
 |  | a11 | ANUJ
 |  | a12 | GOKUL
 |  | a13 | RAGHAV
 |  | a14 | GOKUL
 |  | a15 | NITIN
 |  | a16 | ANUJ
 |  | a17 | GOKUL
 |  | a18 | NITIN
 |  | a19 | RAGHAV
 |  | a20 | GOKUL
 |  | a21 | NITIN
[NAME] | 2 | b1 | ANUJ | 4 | 1.3 | 2024-01-02 00:00:00
RAGHAV |  | b2 | GOKUL |  |  | End
NITIN |  | b3 | RAGHAV
GOKUL |  | b4 | NITIN
 |  | [NAME] | GOKUL
 |  | b6 | RAGHAV
 |  | b7 | NITIN
 |  | b8 | ANUJ
Spreadsheet: 825868d1681595492-convert-from-a-vertical-list-to-a-horizontal-list-cant-use-transpose-sample-data
Sheet: Sheet1

Student ID | Last Name | First Name | Course
12345 | Smith | [NAME] | English
12345 | Smith | [NAME] | Calculus
12345 | Smith | [NAME] | French I
12345 | Smith | [NAME] | World History
12345 | Smith | [NAME] | Chemistry
12345 | Smith | [NAME] | Physical Education
12345 | Smith | [NAME] | Business 101
205032 | Johnston | [NAME] | English
205032 | Johnston | [NAME] | Algebra I
205032 | Johnston | [NAME] | Chemistry
205032 | Johnston | [NAME] | Spanish II
205032 | Johnston | [NAME] | Physical Education
205032 | Johnston | [NAME] | AP Computer Science
To:
Student ID | Last Name | First Name | Course
Spreadsheet: 874699d1721233619-needs-if-formula-for-certain-condition-to-meet-team-bonus-farooq48-
Sheet: BONUS CALCULATOR

 |  |  |  |  |  |  |  | 2023-01-01 00:00:00 |  |  |  |  |  |  | ACTUAL PAYMENT FACTORS
Employee ID | Full Name | Designation | Under Pre-Opening? (Yes/No) | Local Currency | Net / Gross | Annual Salary | Hire Date (M/D/YYYY) | Begin Date (M/D/YYYY) | End Date (M/D/YYYY) | Eligible? (Yes/No) | # of Eligible Days | % of Eligibility | Target Full Year Bonus Opportunity % | Actual [NAME] Achieved - Manager to indicated award % Mixed - 0%-75% Strong - 100%-150% Exceptional - 150%-200% | OP %  (30% weighting) | Core Team metrics i.e. PGI% + GSI% + RGI% (70% weighting) | Actual Bonus Award % | Reduction Factor (applicable only if GOP achieved is less than 95% of budget) | Final Bonus Award after applying reduction factor % | Bonus Amount (Local Currency) | Bonus Payment (IN USD) | Actual Bonus as % of Base | Comments
Input | Input | Dropdown | Dropdown | Input | Input | Input | Input | Calc | Input | Calc/Input | Calc | Calc | Calc | Input | Calc | Calc | Calc | Calc | Calc | Calc | Calc | Calc | Input
1262 | Test | test | No | USD | 100 |  | 2023-03-26 00:00:00 |  | 2023-12-31 00:00:00 |  |  |  |  | 1.5
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Local Currency is SAR
 |  | GOP (absolute) |  |  |  | PERFORMANCE RESULTS: |  |  |  |  |  |  |  |  | Not a preopenning Team
 | Actual Achievement | 950 |  |  |  |  |  |  |  |  |  |  |  |  | All Employee eligible
 | [NAME] GOP amount | 1000 |  |  |  | Measures | % of Budget Achieved | % Target Payment Factor | % Actual Payment Factor |  |  |  |  |  | Target Full year Bonus opportunity is 20%
 | % of GOP Budget Achieved |  |  |  |  | %PGI | 1.09 |  |  | <<<<<
 |  |  |  |  |  | RGI | 0.95
 | Meet GOP Target? |  |  |  |  | GSI | 0.95
 |  |  |  |  |  | Totals
 | If GOP Actual Results for the current year are less than 95% of Target GOP then the Multipler equals "0.00" - no payout will be achieved.
 | Metric achievement | Payout
 | 1.2 | 2
 | 1.1 | 1.5
 | 1 | 1
 | 0.95 | 0.5
 | 0 | 0
 | Metric achievement | Payout
 | 1.2 | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | <<<<<<<<<<<<<<<
 | 1.19 | 1.95
 | 1.18 | 1.9
 | 1.17 | 1.85
 | 1.16 | 1.8
 | 1.15 | 1.75
 | 1.14 | 1.7
 | 1.13 | 1.65
 | 1.12 | 1.6
 | 1.11 | 1.55
 | 1.1 | 1.5
 | 1.09 | 1.45
 | 1.08 | 1.4
 | 1.07 | 1.35
 | 1.06 | 1.3
 | 1.05 | 1.25
 | 1.04 | 1.2
 | 1.03 | 1.15
 | 1.02 | 1.1
 | 1.01 | 1.05
 | 1 | 1
 | 0.99 | 0.9
 | 0.98 | 0.8
 | 0.97 | 0.7
 | 0.96 | 0.6
 | 0.95 | 0.5
 | 0 | 0
Spreadsheet: 27ed571e-260c-45aa-859a-f384662fa267
Sheet: Chen et al 2007

Agilent ID | Symbol
A_23_P100632 | HN1
[NAME] | DTL
A_23_P104651 | CDCA5
A_23_P107421 | TK1
A_23_P107421 | TK1
A_23_P112673 | ZWILCH
A_23_P115482 | UBE2T
A_23_P115872 | CEP55
A_23_P116091 | DPP3
A_23_P118815 | BIRC5
A_23_P118834 | TOP2A
A_23_P118834 | TOP2A
A_23_P122197 | CCNB1
A_23_P125265 | KPNA2
A_23_P126782 | F3
A_23_P131866 | AURKA
A_23_P135061 | CORO2A
A_23_P138507 | CDC2
A_23_P145376 | MAPK13
A_23_P146284 | SQLE
A_23_P148475 | KIF4A
A_23_P149200 | CDC20
A_23_P151150 | FOXM1
A_23_P152804 | NME1
A_23_P155815 | HCAP-G
A_23_P155989 | CENPK
A_23_P159893 | CHRDL1
A_23_P16078 | PAFAH1B3
A_23_P163481 | BUB1B
A_23_P166686 | AMOTL2
A_23_P200310 | DEPDC1
A_23_P202104 | PPIF
A_23_P202316 | BUB3
A_23_P206059 | PRC1
A_23_P207301 | PRR11
A_23_P21376 | MAGI2
A_23_P214779 | UTRN
A_23_P215875 | WDSOF1
A_23_P217054 | WDR32
[NAME] | HMGB3
A_23_P217411 | SMC1A
A_23_P250735 | CBX7
A_23_P254733 | MLF1IP
A_23_P256956 | KIF20A
A_23_P257104 | NCBP1
[NAME] | EZH2
A_23_P28886 | PCNA
A_23_P329335 | IQGAP3
A_23_P329335 | IQGAP3
A_23_P356684 | ANLN
A_23_P370989 | MCM4
A_23_P375104 | KIAA1794
A_23_P384024 | CCDC50
A_23_P404606 | LOC153222
A_23_P40866 | ZBTB20
A_23_P42178 | HIST1H2BF::HIST1H2BG
A_23_P425502 | DONSON
A_23_P428129 | CDKN1C
A_23_P431789 | ARF4
A_23_P48669 | CDKN3
A_23_P48835 | KIF23
A_23_P50096 | TYMS
A_23_P50108 | KNTC2
A_23_P52017 | ASPM
A_23_P52278 | KIF11
A_23_P53276 | TIMELESS
A_23_P59388 | DST
A_23_P63789 | ZWINT
A_23_P63789 | ZWINT
A_23_P65110 | RACGAP1
A_23_P65401 | CFL2
A_23_P66241 | [NAME]
A_23_P66241 | [NAME]
A_23_P68610 | TPX2
A_23_P70007 | HMMR
A_23_P71727 | CKS2
A_23_P72668 | SDPR
A_23_P73763 | LAGE3
A_23_P82941 | ARFGEF1
A_23_P88331 | DLG7
A_23_P91900 | SMC4
A_23_P92441 | MAD2L1
A_23_P94422 | MELK
A_23_P96590 | ARMCX5::GPRASP2
A_23_P99292 | RAD51AP1
A_24_P119665 | [NAME]
A_24_P156501 | EBF
A_24_P191790 | TMEM33
A_24_P218979 | CDCA3
A_24_P225616 | RRM2
A_24_P225616 | RRM2
A_24_P257099 | DKFZp762E1312
A_24_P282000 | NUP210
A_24_P297539 | UBE2C
A_24_P352445 | MRPL42
A_24_P354468 | H2AFZ
A_24_P354468 | H2AFZ
A_24_P379765 | MOBK1B
A_24_P38895 | H2AFX
A_24_P416079 | NUSAP1
A_24_P416079 | NUSAP1
A_24_P566891 | ARF1
A_24_P57631 | GPC3
A_24_P66027 | APOBEC3A::APOBEC3B
A_32_P101235 | UHRF1
A_32_P103633 | MCM2
A_32_P160972 | C6orf115
A_32_P228618 | RBMS3
A_32_P228618 | RBMS3
A_32_P62997 | PBK
A_32_P72447 | UBE2S
A_32_P72822 | [NAME]
A_32_P95729 | KIAA1794
Spreadsheet: 468674d1467446376-copy-paste-special-between-sheets-problem1
Sheet: 10okt

 |  | st rita2 |  |  |  | kontich |  |  |  | [NAME] | rumst
 |  | 9,98/u | 13,26/u |  | 13,26/u | 9,98/u | 13,26/u | 13,26/u | 6,63/u | 20/u | 14/u | 14/u
 |  | 24.95 | 19.89 |  | 33.15 | 19.96 | 26.52 | 33.15 | 16.58 | 70 | 35 | 24.5
 |  | za | za | woe | di | za | za | di | do | ma | zo | woe
 |  | 9-11.30 | 11.30-13 | 13-15 | 20-22.30 | 9-11 | 11-13 | 20-22.30 | 20-22.30 | 19-22.30 | 19-21.30 | 20.30-22.15
do | 2015-10-01 00:00:00 |  |  |  |  |  |  |  | ok
vr | 2015-10-02 00:00:00
za | 2015-10-03 00:00:00 | ok eb | ok
zo | 2015-10-04 00:00:00 |  |  |  |  |  |  |  |  |  | ok
ma | 2015-10-05 00:00:00 |  |  |  |  |  |  |  |  | ok
di | 2015-10-06 00:00:00 |  |  |  | ok pn
wo | 2015-10-07 00:00:00 |  |  | nhp |  |  |  |  |  |  |  | ok k
do | 2015-10-08 00:00:00 |  |  |  |  |  |  |  | ok
vr | 2015-10-09 00:00:00
za | 2015-10-10 00:00:00 | ok eb | ok
zo | 2015-10-11 00:00:00 |  |  |  |  |  |  |  |  |  | ok
ma | 2015-10-12 00:00:00 |  |  |  |  |  |  |  |  | ok
di | 2015-10-13 00:00:00 |  |  |  | ok pn
wo | 2015-10-14 00:00:00 |  |  | nhp |  |  |  |  |  |  |  | ok k
do | 2015-10-15 00:00:00 |  |  |  |  |  |  |  | ok
vr | 2015-10-16 00:00:00
za | 2015-10-17 00:00:00 | ok eb | ok
zo | 2015-10-18 00:00:00
ma | 2015-10-19 00:00:00 |  |  |  |  |  |  |  |  | ok
di | 2015-10-20 00:00:00 |  |  |  | ok pn
wo | 2015-10-21 00:00:00 |  |  | nh |  |  |  |  |  |  |  | ok k
do | 2015-10-22 00:00:00
vr | 2015-10-23 00:00:00
za | 2015-10-24 00:00:00 | ok eb | ok
zo | 2015-10-25 00:00:00 |  |  |  |  |  |  |  |  |  | ok
ma | 2015-10-26 00:00:00 |  |  |  |  |  |  |  |  | ok
di | 2015-10-27 00:00:00
wo | 2015-10-28 00:00:00 |  |  | nhp |  |  |  |  |  |  |  | ok k
do | 2015-10-29 00:00:00
vr | 2015-10-30 00:00:00
za | 2015-10-31 00:00:00 | ok eb | ok
Spreadsheet: 122473d1316831225-sumifs-returns-0-when-i-dont-want-it-to-sumifs_example
Sheet: Data1

LotID | Diff_Count
A77 | NA
[NAME] | NA
A20 | 28
A2 | 28
A2 | 28
A20 | 28
A2 | 28
A7 | 28
A20 | 28
A1 | 28
A20 | 28
A7 | 28
A7 | 22
A7 | 28
A2 | 28
A2 | 28
A7 | 28
A7 | 28
A20 | 28
A7 | 28
[NAME] | 28
A77 | 28
A59 | 28
[NAME] | 28
A73 | 28
A15 | 28
A63 | 28
A64 | 28
A27 | 28
A49 | 28
[NAME] | 28
A15 | 28
A46 | 28
A73 | 28
[NAME] | 28
A25 | 28
A32 | 28
A41 | 28
A38 | 28
A49 | 28
A27 | 28
A64 | 28
A46 | 28
A41 | 28
A32 | 28
A38 | 28
A25 | 28
[NAME] | 27
A59 | 27
A69 | 27
A77 | 27
A46 | 27
[NAME] | 27
A59 | 27
[NAME] | 27
A64 | 28
A27 | 28
A70 | 28
A67 | 70
A31 | 28
A15 | 61
A53 | 71
A27 | 68
A32 | 71
A40 | 71
A80 | 72
A76 | 71
[NAME] | 71
A49 | 71
A73 | 71
A52 | 50
A58 | 50
A59 | 50
A41 | NA
A72 | NA
A18 | NA
[NAME] | NA
A19 | NA
A67 | NA
A7 | NA
Spreadsheet: 377404d1423965025-how-to-ignore-empty-cells-when-i-use-the-match-function-for-an-array-match
Sheet: Sheet1

ABC |  | 1
DEF |  | 2
GHI |  | 3
JKL |  | 4
MNO |  | 5
PQR |  | 6
STU |  | 7
VW |  | 8
XYZ |  | 9
Spreadsheet: 40265d1238575008-can-excel-return-the-earliest-date-using-if-nextappointment
Sheet: Sheet1

Date | # of Appts | # Reserved | Free/Full
2009-04-01 00:00:00 | 20 | 20 | full |  | Next free date: | 2009-04-21 00:00:00
2009-04-03 00:00:00 | 20 | 20 | full
2009-04-20 00:00:00 | 8 | 8 | full
2009-04-21 00:00:00 | 1 |  | free
2009-04-22 00:00:00 | 0 |  | full
2009-04-23 00:00:00 | 12 |  | free
2009-04-24 00:00:00 | 4 |  | free
2009-04-27 00:00:00 | 9 |  | free
2009-04-28 00:00:00 | 8 |  | free
2009-04-30 00:00:00 | 14 |  | free