tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 718351d1613111864-required-formula-to-generate-leave-register-additional-requirement-sample_leavebook2
Sheet: Result-For Period

 |  | Period From | 2021-02-11 00:00:00 | Period To | 2021-03-15 00:00:00
 |  | Leaves
 | [NAME]
 | Micheal
 | [NAME]
 | Ahmed
 | [NAME]
 | Greg
 | Micky
 | Trace
 | Lisy
 | Saraham
 | Leave - Monthwise
 | Name | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00
 | [NAME]
 | Micheal
 | [NAME]
 | Ahmed
 | [NAME]
 | Greg
 | Micky
 | Trace
 | Lisy
 | Saraham
 | Total
Spreadsheet: 771688d1646795760-aggregate-statistics-across-multiple-sheets-if-multiple-critereon-met-tiers-statistics-2
Sheet: Client00001

 | Simple |  | Medium |  | Complex
[NAME] |  |  |  |  |  | x | Tasks | Simple
 |  |  |  |  |  | x |  | Medium
External |  |  |  |  |  | x |  | Complex
 |  |  |  |  |  |  |  | Total
 |  |  |  |  |  |  | >3 Complex = Complex > 10 Medium = Complex > 25 Medium + Simple = Complex
Internal
Spreadsheet: 21778d1209694113-lookup-and-if-help-resi-weekly-update
Sheet: Thursday

 |  |  | Thursday
 |  |  | Contract Number | Comments |  |  |  |  |  | TVP done
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
Back to worksheet |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 |  | 0 |  |  |  |  |  |  |  |  | 0
 | Total | 0 |  |  |  |  |  |  |  |  | 0 | Total
Spreadsheet: 35081d1232584916-changing-sheet-name-reference-automatically-purchases-compilation-autosaved-
Sheet: BULL&BUSH

 |  | PUB NAME |  |  |  |  | PERIOD
 | PERIOD CASH SALES TARGET | 543
 | TARGET GP% TO ACHIEVE | 0.54
 | WET/DRY SPLIT | WET | DRY
 |  | 0.23 | 0.77
 | PERIOD DRY SALES TARGET | 418.11
 | WEEK | 1 | 2 | 3 | 4 | PERIOD TOTAL
 | SALES TARGET | 104.5275 | 104.5275 | 104.5275 | 104.5275 | 418.11
 | ACTUAL SALES | 333 | 334 | 332 | 334 | 1333
 | SALES VARIANCE | 228.4725 | 229.4725 | 227.4725 | 229.4725 | 914.89
 | ALLOWABLE PURCHASES | 48.08265 | 48.08265 | 48.08265 | 48.08265 | 192.3306
 | ACTUAL PURCHASES | 132 | 0 | 0 | 0 | 132
 | REMAINING TO SPEND | -83.91735 | BULL | 48.08265 | 48.08265 | 12.24795
 | CURRENT GP% ACHIEVED | 60.36036036036036 | 100 | 100 | 100 | 90.09009009009009
 | PURCHASE BREAKDOWN | WEEK 1 |  | WEEK 2 |  | WEEK 3 |  | WEEK 4
 |  | SPEND | % OF SPEND | SPEND | % OF SPEND | SPEND | % OF SPEND | SPEND | % OF SPEND
 | FAIRFAX | 44 | 0.3333333333333333 | 0 | #N/A | 0 | #N/A | 0 | #N/A
 | M+J SEAFOODS | 0 | 0 | 0 | #N/A | 0 | #N/A | 0 | #N/A
 | FRESH DIRECT | 22 | 0.1666666666666667 | 0 | #N/A | 0 | #N/A | 0 | #N/A
 | WEST COUNTRY | 22 | 0.1666666666666667 | 0 | #N/A | 0 | #N/A | 0 | #N/A
 | HOPWELLS | 0 | 0 | 0 | #N/A | 0 | #N/A | 0 | #N/A
 | 3663 | 44 | 0.3333333333333333 | 0 | #N/A | 0 | #N/A | 0 | #N/A
 | OTHER SUPPLIERS | 0 | 0 | 0 | #N/A | 0 | #N/A | 0 | #N/A
Spreadsheet: 881795d1729974875-xlookup-to-get-values-based-on-date-and-time-calendar-sample-rj
Sheet: List Data

TIME
All
00:00:00
01:00:00
02:00:00
03:00:00
04:00:00
05:00:00
06:00:00
07:00:00
08:00:00
09:00:00
10:00:00
11:00:00
12:00:00
13:00:00
14:00:00
15:00:00
16:00:00
17:00:00
18:00:00
19:00:00
20:00:00
21:00:00
22:00:00
23:00:00
Spreadsheet: 695385d1600183763-calculating-date-from-years-months-and-days-hire-date-sample-etaf
Sheet: Sheet1

Date Pulled Information | Length of Service | Hire Date |  | YEAR | Month | Day
2020-09-02 00:00:00 | 19 Years 8 Months 24 days
2020-09-02 00:00:00 | 7 Years 8 Months 27 days
2020-09-02 00:00:00 | 2 Years 11 Months 13 days
2020-09-02 00:00:00 | 21 Years 4 Months 15 days
2020-09-02 00:00:00 | 24 Years 8 Months 17 days
2020-09-02 00:00:00 | 5 Years 10 Months 1 days
2020-09-02 00:00:00 | 15 Years 7 Months 11 days
2020-09-02 00:00:00 | 4 Years 6 Months 6 days
2020-09-02 00:00:00 | 9 Years 11 Months 15 days
2020-09-02 00:00:00 | 0 Years 9 Months 4 days
2020-09-02 00:00:00 | 99 Years 12 Months 31 days
Spreadsheet: 272448d1382387360-days-hours-minues-time-string-conversion
Sheet: Sheet1

 | Time Fluffy Unicorn Spends in the Bathroom
 | Old | New | Days | Hours | Minutes | Seconds
Spreadsheet: 539502d1506179056-sum-amount-diffrent-sample
Sheet: Sheet1

 | 1523 | 5.5+17% | 1523 | 9800.505000000001 |  | 9800.51
 | 148 | 5.5+17% | 148 | 952.38 |  | 952.38
 | 471 | 5.5+17% | 471 | 3030.885 |  | 3030.89
 | 80 | 3+17% | 80 | 280.8 |  | 280.8
Spreadsheet: 190574d1351702357-conditional-formatting-replace-date-with-yes-or-no-check-date
Sheet: Sheet1

 |  |  |  |  |  | Check Date
 |  |  |  |  |  | 2012-05-05 00:00:00
 | 2012-02-25 00:00:00
 | 2012-04-01 00:00:00
 | 2012-04-15 00:00:00
 | 2012-05-15 00:00:00
 | 2012-06-21 00:00:00
 | 2012-06-29 00:00:00
 | 2012-07-05 00:00:00
 | 2012-07-18 00:00:00
 | 2012-08-12 00:00:00
 | 2012-08-28 00:00:00
 | 2012-09-06 00:00:00
 | 2012-10-16 00:00:00
 | 2012-10-31 00:00:00
Spreadsheet: 328520d1403930203-recurring-due-date-for-annual-event-recurring-due-date-help
Sheet: Sheet1

Name | Due month | Completion date | Due by |  | Should read
[NAME] | 1900-09-30 00:00:00 | 2013-09-15 00:00:00 |  | <-- | 2014-09-30 00:00:00
[NAME] | 1900-02-28 00:00:00 | 2014-01-15 00:00:00 |  | <-- | 2015-02-28 00:00:00
Adam | 1900-07-31 00:00:00 | 2013-07-23 00:00:00 |  | <-- | 2014-07-31 00:00:00
Nick | 1900-05-31 00:00:00 | 2013-05-12 00:00:00 |  | <-- | 2014-05-31 00:00:00
[NAME] | 1900-06-30 00:00:00 | 2014-05-24 00:00:00 |  | <-- | 2014-06-30 00:00:00
[NAME] | 1900-12-31 00:00:00 | 2013-12-31 00:00:00 |  | <-- | 2014-12-31 00:00:00
Spreadsheet: 876630d1723360629-how-to-link-or-import-data-between-two-excel-workbooks-with-very-different-formats-daily-sheets
Sheet: 06.02.24

 | AM SHIFT REPORT
 |  |  |  | 2024-06-02 00:00:00
 | UNIT | Bed Capacity | [NAME] | Census | Census Pending | RN's | RN PD | Travel | RN OT | RN Sick | Tech | N.A. | Comments
 | 3RD FL | 13 | 7 | 10 | 0 | 2 | 1 | 0 | 0 | 0 | 1 | 0
 | 4TH FL | 38 | 22 | 24 | 0 | 4 | 0 | 0 | 0 | 0 | 2 | 0
 | 5TH FL | 34 | 20 | 18 | 0 | 3 | 0 | 0 | 0 | 1 | 2 | 0
 | ABC | 27 | 18 | 21 | 0 | 5 | 0 | 1 | 0 | 0 | 2 | 0
 | MNO | 12 | 6 | 6 | 0 | 3 | 0 | 0 | 0 | 0 | 1 | 0
 | Total MED
 | JKL | 26 | 4 | 3 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0
 | DEF | 10 | 4 | 3 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
 | GHI | N/A | N/A | 2 | 0 | 2 | 0 | 0 | 0 | 1 | 1 | 0
 | Total MAT
 | Total Holds AM | N/A | N/A | 1 | 0 | 4 | 1 | 0 | 0 | 0 | 2 | 0
 | Total Holds MID |  |  | 0 | 0 | 5 | 0 | 0 | 1 | 0 | 1 | 0
 | Total House Census
 | PM SHIFT REPORT
 |  |  |  | 2024-06-02 00:00:00
 | UNIT | Bed Capacity | Bud. Beds | Census | Census Pending | RN's | RN PD | Travel | RN OT | RN Sick | Tech | N.A. | Comments
 | 3RD FL | 13 | 7 | 7 | 0 | 1 | 0 | 0 | 0 | 0 | 1 | 0
 | 4TH FL | 38 | 22 | 25 | 0 | 4 | 0 | 2 | 0 | 0 | 2 | 0
 | 5TH FL | 34 | 20 | 18 | 0 | 3 | 0 | 1 | 0 | 0 | 2 | 0
 | ABC | 27 | 18 | 20 | 0 | 6 | 0 | 3 | 0 | 0 | 1 | 0
 | MNO | 12 | 6 | 6 | 0 | 3 | 0 | 0 | 0 | 0 | 1 | 0
 | Total MED
 | JKL | 26 | 4 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
 | DEF | 10 | 4 | 2 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0
 | GHI | N/A | N/A | 2 | 0 | 3 | 0 | 1 | 0 | 0 | 1 | 0
 | Total MAT
 | Total Holds PM | N/A | N/A | 0 | 0 | 5 | 2 | 0 | 0 | 0 | 1 | 0
 | Total House Census
Spreadsheet: 57933d1258143299-joining-two-spreadsheets-example1
Sheet: Master

personel# | surname | first name | manager | dept | role | data 1 | data 2
1235 | DENT | JENNA | SMITH | SF | FRONT OFFICE | M | 3
1399 | WHEELER | ANNA | SMITH | SF | FRONT OFFICE | F | 4
1778 | AHMED | VIKRAM | SMITH | SF | FRONT OFFICE | M | 3
1266 | BULMER | LEIGH | SMITH | SF | FRONT OFFICE | F | 3
1382 | WHITE | MARK | SMITH | SF | FRONT OFFICE | M | 4
1284 | HALEY | [NAME] | JONES | NB | MANAGER | M | 1
1932 | SAUER | [NAME] | JONES | NB | COORDINATOR | M | 4
1360 | [NAME] | STEVE | JONES | NB | PROJECT MANAGER | M | 1
1534 | LEROY | MICHELLE | JONES | NB | COORDINATOR | M | 3
1540 | JARDINE | PIERRE | JONES | NB | COORDINATOR | M | 3
9957 | [NAME] | MARCUS | JONES | NB | COORDINATOR | M | 2
Spreadsheet: 265480d1379290591-merge-a-couple-of-spreadsheets-with-common-column-field-sample
Sheet: Sheet2

IM_SKU | ImageFront | ImageRear | ImageTop | ImageLeft | ImageRight | DefaultID | Video | Brochure | Date
1260785 | 8_HPW06002_Front.jpg |  |  |  |  | 1 |  |  | 2010-10-29 20:58:36
1000004 | 8_HPW05755_Front.JPG |  |  |  |  | 1 |  |  | 2011-01-11 19:24:45
1000003 | 8_HPW05516_Front.jpg |  |  |  |  | 1 |  |  | 2010-11-10 17:10:09
1000001 | 8_HPG9453_Front.jpg |  |  |  |  | 1 |  |  | 2010-12-20 14:58:05
1000005 | 8_HPW05484_Front.JPG |  |  |  |  | 1 |  |  | 2010-11-03 19:36:26
Spreadsheet: 1e06dc08-476e-47bc-a6d1-312c2a510b41
Sheet: ModInCmp

CatModRowNbr | ModId | ModLabel | ModuleStartsOnFwkRow | ModId | [NAME] | FirstIntOnCatIntRow | NbrOfCovInd | FirstCovIndOnCatCovRow |  | <= Framework offset from top
Spreadsheet: 888229d1738707691-summary-of-data-book2
Sheet: Sheet1

 | data | Color
 | 500 | Red
 | 501 | Green |  | Row Labels | Colors
 | 502 | Red |  | 500 | Red
 | 503 | Blue |  | 501 | Green
 | 504 | Purple |  | 502 | Red
 | 504 | Red |  | 503 | Blue
 | 504 | Blue |  | 504 | Purple, Red, Blue
 | 505 | Green |  | 505 | Green
 | 506 | Yellow |  | 506 | Yellow
 | 507 | Black |  | 507 | Black
Spreadsheet: 830493d1684943242-combing-unique-values-from-duplicate-rows-horizontally-samplespreadsheet
Sheet: How I want it look

ID # | Student Name | Grade Level | Course Name #1 | Teacher Name #1 | Grade #1 | Percent #1 | Course Name #2 | Teacher Name #2 | Grade #2 | Percent #2 | Course Name #3 | Teacher Name #3 | Grade #3 | Percent #3
1 | Student A | 9 | Example 1 | Teacher 1 | F | 0 | Example 2 | Teacher 2 | F | 0 | Example 3 | Teacher 3 | F | 0
2 | Student B | 10 | Example 1 | Teacher 1 | F | 0
3 | Student C | 11 | Example 1 | Teacher 1 | F | 0
4 | Student D | 12 | Example 1 | Teacher 1 | F | 0 | Example 2 | Teacher 2 | F | 0
5 | Student E | 10 | Example 1 | Teacher 1 | F | 0
Spreadsheet: 774754d1648645234-find-numbers-in-a-non-linear-series-minor-help-new-microsoft-office-excel-worksheet
Sheet: Sheet1

 | A | B
 | 10 | 1.2
 | 5 | 3.6
 | 1 | 12
 | 0.05 | 120
 | 0.004 | 1200
 | 3e-05 | 12000
What will be the value of B when A=
 | A | B
 | 0.1 | ?
 | 0.01 | ?
 | 0.001 | ?
 | 0.0001 | ?
Spreadsheet: 720240d1614085492-blank-cell-not-blank-test-isblank
Sheet: Sheet1

DATA |  |  |  | PASTE VALUES |  |  | TEST ISBLANK COL F
VALUE | VALUE>5 |  |  | VALUE | VALUE>5
4 |  |  |  | 4
9 |  |  |  | 9 | 9
5 |  |  |  | 5
6 |  |  |  | 6 | 6
2 |  |  |  | 2
8 |  |  |  | 8 | 8
7 |  |  |  | 7 | 7
1 |  |  |  | 1
4 |  |  |  | 4
Spreadsheet: 26016d1217883608-generating-reports-online
Sheet: Sheet1

Unit | Size | Tentant | Market | Move-IN | Move-Out | Water | Balance | Rent | Current Balance | Payments | Notes
100B1101 | over1x1c | a | 579 | 2007-06-28 00:00:00 | 2008-08-31 00:00:00 | 69.19 | 1836.62 | -150 | 1755.81
100B1103 | over1x1c | b | 579 | 2008-03-21 00:00:00 | 2009-03-31 00:00:00 | 69.19 | -68.19 | 579 | 580
100B1105 | over1x1c | c | 579 | 2007-12-28 00:00:00 | 2009-02-28 00:00:00 | 69.19 | -1.98 | 500 | 567.21
100B1107 | over1x1c | d | 579 | 2007-04-20 00:00:00 | 2008-06-30 00:00:00 | 69.19 | 1301.21 | 0 | 1370.4
100B1111 | over1x1c | e | 579 | 2005-10-14 00:00:00 | 2008-11-30 00:00:00 | 69.19 | 678.74 | 579 | 1326.93
100B1112 | over1x1c | f | 579 | 2008-05-31 00:00:00 | 2009-06-30 00:00:00 | 69.19 | -450 | 0 | -380.81
100B1113 | over1x1c | g | 579 | 2005-01-04 00:00:00 | 2008-11-30 00:00:00 | 69.19 | -100 | 584 | 553.19
100B1114 | over1x1c | h | 579 | 2007-08-25 00:00:00 | 2008-09-30 00:00:00 | 69.19 | 2297.99 | 0 | 2367.18
100B1115 | over1x1c | I | 579 | 2008-06-30 00:00:00 | 2009-08-31 00:00:00 | 69.19 | -34 | 537 | 35.19000000000005 | 537
100B1117 | over1x1c | j | 579 | 2007-03-19 00:00:00 | 2009-06-30 00:00:00 | 69.19 | 109.16 | 579 | 757.35
100B1118 | over1x1c | k | 579 | 2007-12-28 00:00:00 | 2009-02-28 00:00:00 | 69.19 | 50 | 500 | 50 | 569.19
Spreadsheet: 75086d1275611559-comparing-data-on-sheets-with-conditional-formatting-richard-h-highlight-row-if-number-found-on-other-sheet
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | 92
 |  |  |  |  |  |  |  |  |  | 86
 |  |  |  |  |  |  |  |  |  | 61
 |  |  |  |  |  |  |  |  |  | 16
 |  |  |  |  |  |  |  |  |  | 85
 |  |  |  |  |  |  |  |  |  | 88
 |  |  |  |  |  |  |  |  |  | 72
 |  |  |  |  |  |  |  |  |  | 96
 |  |  |  |  |  |  |  |  |  | 13
 |  |  |  |  |  |  |  |  |  | 74
 |  |  |  |  |  |  |  |  |  | 69
 |  |  |  |  |  |  |  |  |  | 52
 |  |  |  |  |  |  |  |  |  | 98
 |  |  |  |  |  |  |  |  |  | 33
 |  |  |  |  |  |  |  |  |  | 9
 |  |  |  |  |  |  |  |  |  | 72
 |  |  |  |  |  |  |  |  |  | 7
 |  |  |  |  |  |  |  |  |  | 77
 |  |  |  |  |  |  |  |  |  | 81
 |  |  |  |  |  |  |  |  |  | 95
 |  |  |  |  |  |  |  |  |  | 38
Spreadsheet: 47595d1246648967-excel-2007-check-cell-value-and-change-another-cell-based-on-precentage-calculation-book_locations
Sheet: Sheet1

COMPANY | CATEGORY NAME | CITY | PROVINCE | CONTACT NAME | PHONE NUMBER | POSTAL CODE | E-mail | BUSINESS EXCHANGE | Re-Stock BEX | BEX TOTAL AMOUNT | Old BEX  Picked up | RACK | Titles | Real Estate EXCHANGE | Re-Stock REX | REX TOTAL AMOUNT | Old REX  Picked up | BC Business EXCHANGE | Re-Stock BC BEX | BC TOTAL AMOUNT
AAA |  | Toronto | Ontario |  |  |  |  | 4 |  | 4 |  | Store Rack | Bex & Rex | 4 |  | 4 |  |  |  | 0
[NAME] |  | Toronto | Ontario |  |  |  |  | 12 |  | 12 |  | Three Tiered | Bex & Rex | 11 |  | 11 |  |  |  | 0
CCC |  | Toronto | Ontario |  |  |  |  | 3 |  | 3 |  | Counter | Bex & Rex | 4 |  | 4 |  |  |  | 0
Green |  | Toronto | Ontario |  |  |  |  | 6 |  | 6 |  | Three Tiered | Bex & Rex | 6 |  | 6 |  |  |  | 0
Convenience |  | Toronto | Ontario |  |  |  |  | 4 |  | 4 |  | Store Rack | Bex & Rex | 3 |  | 3 |  |  |  | 0
Spreadsheet: 485622d1476979101-count-if-ryan-project-1
Sheet: Sheet5

Category # | What Happened | My Conclusion | Report # | Firm Name | Stock Symbol | What Issue | Trade Date
1 | insert explation here | what I think | EF741 | Firm E | QWA | Gems | 2015-10-03 00:00:00
2 | insert explation here | what I think | [NAME] | FIRM A | KMN | B/A | 2015-10-03 00:00:00
3 | insert explation here | what I think | BC345 | FIRM C | KMJ | RWNA | 2015-10-03 00:00:00
4 | insert explation here | what I think | [NAME] | Firm B | ASD | Gems | 2015-10-03 00:00:00
5 | insert explation here | what I think | BC457 | Firm B | LKI | Gems | 2015-10-03 00:00:00
Spreadsheet: 123996d1317987521-find-cells-with-data-cheat-sheet
Sheet: rotas

BAR ROTA |  |  | MONDAY 3rd Oct to 9th Oct |  |  |  |  |  |  |  |  | BAR ROTA
 | Monday | 3rd | Tuesday | 4th | Wednesday | 5th | Thursday | 6th | Friday | 7th | Saturday | 8th | Sunday | 9th
NAME | AM | PM | AM | PM | AM | PM | AM | PM | AM | PM | AM | PM | AM | PM |  | SHIFTS |  | DAYS OFF |  | SHIFTS
[NAME] |  | 7-CL | OFF | OFF |  | 5-CL |  | 5-CL | 1015-5 | 7-11 | 1030-5 | 6-CL | OFF | OFF |  | 7 | 4 | 2 | 0 | 7
[NAME] | 1030-5 |  |  | 5-CL | OFF | OFF | 1015-5 | 7-CL |  | 5-CL | OFF | OFF | 1030-4 | 5-CL |  | 7 | 4 | 2 | 0 | 7
[NAME] |  |  |  |  |  |  |  |  |  |  | 1130-4 | 5-10 | OFF | OFF |  | 2 | 2 | 1 | 0 | 2
[NAME] |  |  |  | 7-CL |  | OFF |  | OFF |  | 630-CL | SB | 4-CL | 1130-5 | 6-CL |  | 6 | 2 | 1 | 1 | 5
[NAME] |  | 5-CL | 1030-5 |  | 1030-5 | 7-CL | OFF | OFF | OFF | OFF | 12-5 | 6-11 | 12-6 |  |  | 7 | 4 | 2 | 0 | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 29 |  |  |  | 28
 | BACK BAR
 | MONDAY |  | TUESDAY |  | WEDNESDAY |  | THURSDAY |  | FRIDAY |  | SATURDAY |  | SUNDAY
 | AM | PM | AM | PM | AM | PM | AM | PM | AM | PM | AM | PM | AM | PM
 | CLOSED | CLOSED | CLOSED | CLOSED | CLOSED | CLOSED | CLOSED | CLOSED | CLOSED | RYAN | [NAME] | [NAME] | LAURA | CLOSED
 |  | 1030
 |  | code | start | finish
 |  | 1030-5 | 1030 | 1700
 |  | 7-CL | 1900 | 0000
 |  | 5-CL
Spreadsheet: 851940d1702055384-matching-groups-that-are-designated-by-dates-of-a-project-to-a-given-timeline-book2
Sheet: Sheet1

 | Group 1 | Group 2 | Group 3 | Group 4 | Group 5 |  | 2023-01-01 00:00:00
Project A | 2023-01-01 00:00:00 | 2023-02-01 00:00:00 | 2023-03-01 00:00:00 | 2023-04-01 00:00:00 | 2023-05-01 00:00:00 |  |  | Group 2 | Group 3 | Group 4 | Group 5 | Group 5 | Group 5 | Group 5 | Group 5 | Group 5 | Group 5 | Group 5
Project B | 2023-04-01 00:00:00 | 2023-07-01 00:00:00 | 2023-01-01 00:00:00 | 2023-09-01 00:00:00 | 2023-02-01 00:00:00 |  | Group 3 | Group 5 | Group 5 | Group 1 | Group 1 | Group 1 | Group 2 | Group 2 | Group 4 | Group 4 | Group 4 | Group 4
Project C | 2023-05-01 00:00:00 | 2023-03-01 00:00:00 | 2023-04-01 00:00:00 | 2023-02-01 00:00:00 | 2023-01-01 00:00:00 |  | Group 5 | Group 4 | Group 2 | Group 3 | Group 1 | Group 1 | Group 1 | Group 1 | Group 1 | Group 1 | Group 1 | Group 1
Spreadsheet: acb58cff-4f88-4182-9fe0-ca0ce5813799
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
PHMA | Test | PHMA | Phoma betae, IgE | [NAME], IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube:  Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m.-8 p.m., Saturday; 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
PHMA | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
PHMA | Result | PHMA | [NAME], IgE | [NAME], IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 6216-6 | Phoma betae Ab.IgE:ACnc:Pt:Ser:Qn:
Spreadsheet: 836258d1689218048-create-a-new-column-that-renames-top-6-ranks-sample_top
Sheet: Sheet1

Department | Id | Emp_Name | Flag | Amount | Rank | New_Column
Food | 101 | [NAME] | High | 104 | 5 | Top 6
Food | 101 | [NAME] | Low | 25 | 2 | Low
Food | 101 | [NAME] | Medium | 80 | 3 | Medium
Food | 101 | [NAME] | High | 200 | 9 | Top 6
Food | 101 | [NAME] | Low | 10 | 1 | Low
Food | 101 | [NAME] | High | 100 | 4 | Top 6
Food | 101 | [NAME] | High | 120 | 8 | Top 6
Food | 101 | [NAME] | High | 115 | 7 | Top 6
Food | 101 | [NAME] | High | 108 | 6 | Top 6
Beauty | 102 | [NAME] | High | 135 | 6 | Top 6
Beauty | 102 | [NAME] | High | 128 | 5 | Top 6
Beauty | 102 | [NAME] | Medium | 80 | 4 | Medium
Beauty | 102 | [NAME] | Low | 30 | 2 | Low
Beauty | 102 | [NAME] | Medium | 65 | 3 | Medium
Beauty | 102 | [NAME] | Low | 5 | 1 | Low
Hardware | 103 | [NAME] | High | 240 | 6 | Top 6
Hardware | 103 | [NAME] | High | 210 | 4 | Top 6
Hardware | 103 | [NAME] | High | 300 | 8 | Top 6
Hardware | 103 | [NAME] | High | 105 | 2 | High
Hardware | 103 | [NAME] | High | 222 | 5 | Top 6
Hardware | 103 | [NAME] | High | 102 | 1 | High
Hardware | 103 | [NAME] | High | 169 | 3 | Top 6
Hardware | 103 | [NAME] | High | 243 | 7 | Top 6
Spreadsheet: 52625d1252485524-impossible-with-pivot-table-test_enquete_results
Sheet: data

Taal | Einde bereikt | Browser | Besturingssysteem | q1_1 | q1_2 | q2_1 | q2_2
NL | 2008-09-26 00:00:00 | IE | a | 1 | 2 | 2 | 4
NL | 2009-09-29 00:00:00 | fire | b | 2 | 2 | 3 | 1
Spreadsheet: 30084d1225384202-transferring-data-from-a-price-list-to-a-bill-of-materials-ses-grid-tie-dc-power-worksheet-10-24-08
Sheet: Bill of Materials

 |  | BILL OF MATERIALS-CONFIDENTIAL
Vendor | Vendor Code | [NAME] | Qty | Dealer Cost | Total Cost
 |  | Solar Modules
 |  | Prosolar Mounting System
 |  | AC/DC Disconnects, MC Cables, etc.
 |  | Grid Interactive Solar Inverter
 |  | Engineering Services
 |  |  |  | Tax
Project for: |  |  |  | Total | #N/A
 |  |  |  | [NAME] | #N/A
 |  |  |  | System $/Watt Cost | #N/A
 |  |  |  | 15% markup | #N/A
 |  |  |  | System $/Watt sell | #N/A
[NAME]
PO
Spreadsheet: 883998d1732839319-ranking-multiple-groups-rank-example
Sheet: Sheet1

Group |  |  | Score |  | Rank
A | 1 |  | 88 |  | 1
A |  |  | 85 |  | 2
A |  |  | 85 |  | 2
A |  |  | 84 |  | 4
A |  |  | 79.5 |  | 5
A |  |  | 79.5 |  | 5
A |  |  | 79 |  | 7
A |  |  | 78 |  | 8
A |  |  | 77 |  | 9
A |  |  | 74 |  | 10
Group |  |  | Score |  | Rank
B |  |  | 80.5 |  | 1
B |  |  | 79.5 |  | 2
B |  |  | 79.5 |  | 2
B |  |  | 77.5 |  | 4
B |  |  | 77 |  | 5
B |  |  | 75.5 |  | 6
B |  |  | 74 |  | 7
B |  |  | 69 |  | 8
B |  |  | 67.5 |  | 9
Group |  |  | Score |  | Rank
C |  |  | 120.5 |  | 1
C |  |  | 119.5 |  | 2
C |  |  | 118 |  | 3
C |  |  | 118 |  | 3
C |  |  | 118 |  | 3
C |  |  | 116 |  | 6
C |  |  | 115 |  | 7
C |  |  | 114.7 |  | 8
C |  |  | 114 |  | 9
C |  |  | 113.5 |  | 10
C |  |  | 113 |  | 11
C |  |  | 112 |  | 12
C |  |  | 112 |  | 12
C |  |  | 111 |  | 14
Spreadsheet: 53838d1253766989-remain-cell-counting-sample
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | This area I keep make on other sheet.
 | My sample table |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Purpose for input data
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | You can key into any cell below table 2 digit/cell (00-99)
 |  |  | 00 | 10 | 20 | 30 | 40 | 50 | 60 | 70 | 80 | 90 |  |  |  |  |  |  | 84 |  |  |  | 00 | 30
 |  |  | 01 | 11 | 21 | 31 | 41 | 51 | 61 | 71 | 81 | 91 |  |  | Matching Number |  |  |  | 72 | 22 |  | 55 |  | 31
 |  |  | 02 | 12 | 22 | 32 | 42 | 52 | 62 | 72 | 82 | 92 |  |  | check |  |  |  | 93 |  |  | 50 |  | 32
 |  |  | 03 | 13 | 23 | 33 | 43 | 53 | 63 | 73 | 83 | 93 |  |  |  |  |  |  | 19 |  |  | 11 |  | 33
 |  |  | 04 | 14 | 24 | 34 | 44 | 54 | 64 | 74 | 84 | 94 |  |  |  |  |  |  | 37 |  |  |  |  | 34
 |  |  | 05 | 15 | 25 | 35 | 45 | 55 | 65 | 75 | 85 | 95 |  |  |  |  |  |  | 87 |  |  |  |  | 35
 |  |  | 06 | 16 | 26 | 36 | 46 | 56 | 66 | 76 | 86 | 96 |  |  |  |  |  |  | 43 | 53 | 63 | 73 | 83 | 36
 |  |  | 07 | 17 | 27 | 37 | 47 | 57 | 67 | 77 | 87 | 97
 |  |  | 08 | 18 | 28 | 38 | 48 | 58 | 68 | 78 | 88 | 98
 |  |  | 09 | 19 | 29 | 39 | 49 | 59 | 69 | 79 | 89 | 99
Show Result = |  |  | ???
 | I need this formula for countting
 | Between background white color
 | or background gray color.
 | if I use =counta(array) function
 |  |  | 100 |  |  |  | cell
 | I use you formula recommen. Always show = 90
 |  |  | 90 |  |  | = | COUNTIF(D$4:M$13,">="&0)
 |  |  | 90 |  |  | = | COUNTIF(D$4:M$13,">="&1)