tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 455647d1460451469-locate-highest-status-and-return-xyz-based-on-what-is-located-into-new-cell-same-row-sample
Sheet: Sheet1

 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8
 | PICKUP phase |  | DEPARTURE phase |  | ARRIVAL phase |  | DELIVERY phase |  | Result
 | Estimated | Actual | Estimated | Actual | Estimated | Actual | Estimated | Actual
 | 2016-04-01 00:00:00 | 2016-04-01 00:00:00 | 2016-04-02 00:00:00 | 2016-04-02 00:00:00 | 2016-04-03 00:00:00 | 2016-04-03 00:00:00 | 2016-04-04 00:00:00 | 2016-04-04 00:00:00 | 8
 | 2016-04-01 00:00:00 | 2016-04-01 00:00:00 |  |  | 2016-04-03 00:00:00 |  |  |  | 5
 | 2016-04-01 00:00:00 |  | 2016-04-02 00:00:00 | 2016-04-02 00:00:00 |  | 2016-04-03 00:00:00 |  |  | 6
 | 2016-04-01 00:00:00 | 2016-04-01 00:00:00 | 2016-04-02 00:00:00 | 2016-04-02 00:00:00 | 2016-04-03 00:00:00 | 2016-04-03 00:00:00 | 2016-04-04 00:00:00 |  | 7
 | 2016-04-01 00:00:00 | 2016-04-01 00:00:00 | 2016-04-02 00:00:00 | 2016-04-02 00:00:00 |  |  |  |  | 4
 |  |  |  | 2016-04-02 00:00:00 |  |  |  |  | 4
 |  |  |  |  |  | 2016-04-03 00:00:00 | 2016-04-04 00:00:00 | 2016-04-04 00:00:00 | 8
 |  |  |  |  |  | 2016-04-03 00:00:00 |  |  | 6
 | 2016-04-01 00:00:00 |  |  |  |  |  |  |  | 1
 | 2016-04-01 00:00:00 | 2016-04-01 00:00:00 |  |  |  |  |  |  | 2
 | 2016-04-01 00:00:00 | 2016-04-01 00:00:00 | 2016-04-02 00:00:00 |  |  |  |  |  | 3
 |  |  |  |  |  |  |  | 2016-04-04 00:00:00 | 8
 |  |  |  | 2016-04-02 00:00:00 |  |  |  |  | 4
Dates are NOT necessarily in chronological order
 | 2016-04-01 00:00:00 | 2016-04-03 00:00:00 | 2016-04-02 00:00:00 | 2016-04-04 00:00:00 | 2016-04-04 00:00:00 | 2016-04-05 00:00:00 | 2016-04-06 00:00:00 | 2016-04-05 00:00:00 | 8
 | 2016-04-01 00:00:00 | 2016-04-03 00:00:00 |  |  | 2016-04-04 00:00:00 |  |  |  | 5
 | 2016-04-01 00:00:00 |  | 2016-04-02 00:00:00 | 2016-04-04 00:00:00 |  | 2016-04-05 00:00:00 |  |  | 6
 | 2016-04-01 00:00:00 | 2016-04-03 00:00:00 | 2016-04-02 00:00:00 | 2016-04-04 00:00:00 | 2016-04-04 00:00:00 | 2016-04-05 00:00:00 | 2016-04-05 00:00:00 |  | 7
 | 2016-04-01 00:00:00 | 2016-04-03 00:00:00 | 2016-04-02 00:00:00 | 2016-04-04 00:00:00 |  |  |  |  | 4
 |  |  |  | 2016-04-04 00:00:00 |  |  |  |  | 4
 |  |  |  |  |  | 2016-04-05 00:00:00 | 2016-04-04 00:00:00 | 2016-04-06 00:00:00 | 8
 |  |  |  |  |  | 2016-04-05 00:00:00 |  |  | 6
 | 2016-04-01 00:00:00 |  |  |  |  |  |  |  | 1
 | 2016-04-01 00:00:00 | 2016-04-03 00:00:00 |  |  |  |  |  |  | 2
 | 2016-04-01 00:00:00 | 2016-04-03 00:00:00 | 2016-04-02 00:00:00 |  |  |  |  |  | 3
 |  |  |  |  |  |  |  | 2016-04-06 00:00:00 | 8
 |  |  |  | 2016-04-04 00:00:00 |  |  |  |  | 4
Spreadsheet: 41176d1239701169-creating-customized-sequence-in-excel-excel-forum-copy-to-own-column
Sheet: Sheet1

item_desc |  | item_desc1 | item_desc2 | item_desc3 | item_desc4 | item_desc5 | item_desc6 | item_desc7 | item_desc8 | item_desc9 | item_desc10 | item_desc11
a |  | a | a | a | a
b |  | b | b | b
c |  | c | c | c | c | c
a
b
c
a
b
c
a
c
c
Spreadsheet: 731839d1620638172-count-in-a-range-along-a-row-instances-that-occur-only-on-before-today-of-a-value-anonymised-blue-green-mauve-red
Sheet: BLUE

BLUE ENTITIES |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTALS PER ENTITY |  |  |  |  | 153153155
 |  |  | 2021-03-02 00:00:00 | 2021-03-09 00:00:00 | 2021-03-16 00:00:00 | 2021-03-23 00:00:00 | 2021-03-30 00:00:00 | 2021-04-06 00:00:00 | 2021-04-13 00:00:00 | 2021-04-20 00:00:00 | 2021-04-27 00:00:00 | 2021-05-04 00:00:00 | 2021-05-11 00:00:00 | 2021-05-18 00:00:00 | 2021-05-25 00:00:00 | @ | % | ! | _
 | Estefana | [NAME] | % | % | % | % | @ | @ | % | % | @ | @ | @ | @ | @ |  |  |  |  |  |  | 221,235,247
 | [NAME] | [NAME] | @ | ! | @ | @ | ! | @ | @ | @ | @ | ! | @ | @ | @ |  |  |  |  |  |  | @
 | Lashunda | Mckenzie | ! | @ | @ | _ | _ | _ | @ | _ | @ | _ | @ | @ | @ |  |  |  |  |  |  | %
 | [NAME] | [NAME] | @ | @ | @ | _ | _ | _ | _ | @ | @ | _ | @ | @ | @ |  |  |  |  |  |  | !
 | [NAME] | [NAME] | @ | @ | @ | @ | @ | @ | _ | @ | @ | @ | @ | @ | @ |  |  |  |  |  |  | F | FLOATING
 | Denyse | [NAME] | ! | ! | ! | ! | @ | @ | @ | @ | ! | @ | @ | @ | @ |  |  |  |  |  |  | _ | [NAME]
 | Lakita | Rona | @ | % | @ | @ | @ | @ | ! | @ | @ | @ | @ | @ | @ |  |  |  |  |  |  | N/A
 | [NAME] | Bart | @ | @ | % | @ | % | @ | @ | % | @ | % | @ | @ | @ |  |  |  |  |  |  |  | follow up
 | [NAME] | Carmen | @ | @ | @ | ! | @ | @ | @ | ! | ! | @ | @ | @ | @
 | Sharita | [NAME] | @ | @ | @ | @ | ! | @ | _ | ! | @ | ! | @ | @ | @
 | [NAME] | [NAME] | @ | @ | @ | @ | @ | @ | ! | @ | @ | @ | @ | @ | @
 | Preston | Dimple | N/A | N/A | N/A | N/A | N/A | N/A | N/A | @ | ! | N/A | @ | @ | @
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021 BLUE entities
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2020 BLUE entities |  |  | 44
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Increase/decrease
_  s N/A
_  s N/A
 |  | confirm
Spreadsheet: 47865d1247036883-sorting-non-unique-rows-of-data-into-another-worksheet-example
Sheet: 210

Account | ID# | Src | Date | Memo/Payee | Debit | Credit | Code | Job No. | Job Name
01 | ID-2 | GJ | 3/2/2009 |  | 500 |  | 210
01 | ID-2 | GJ | 1/2/2009 |  | 5235 |  | 210
01 | ID-2 | GJ | 1/2/2009 |  | 345 |  | 210
01 | ID-2 | GJ | 1/2/2009 |  | 5436 |  | 210
Spreadsheet: 79485d1279735833-formula-to-update-first-and-last-day-of-month-first-and-last-day-of-month
Sheet: Sheet1

2010 | First day | Last day |  | Mo, Year
 | 2010-01-01 00:00:00 | 2010-01-31 00:00:00 |  | Jan,10
 | 2010-02-01 00:00:00 | 2010-02-28 00:00:00 |  | Feb,10
 | 2010-03-01 00:00:00 | 2010-03-30 00:00:00 |  | Mar,10
 | 2010-04-01 00:00:00 | 2010-04-30 00:00:00 |  | Apr,10
 | 2010-05-01 00:00:00 | 2010-05-31 00:00:00 |  | May,10
 | 2010-06-01 00:00:00 | 2010-06-30 00:00:00 |  | Jun,10
 | 2010-07-01 00:00:00 | 2010-07-31 00:00:00 |  | Jul,10
 | 2010-08-01 00:00:00 | 2010-08-31 00:00:00 |  | Aug,10
 | 2010-09-01 00:00:00 | 2010-09-30 00:00:00 |  | Sep,10
 | 2010-10-01 00:00:00 | 2010-10-31 00:00:00 |  | Oct,10
 | 2010-11-01 00:00:00 | 2010-11-30 00:00:00 |  | Nov,10
 | 2010-12-01 00:00:00 | 2010-12-31 00:00:00 |  | Dec,10
Spreadsheet: acc39e1d-2806-4f65-bb20-c84d1af89679
Sheet: 12d

Product | 0-3** | 3-6 | 6-12 | 12-24 | 24-60 | 60-120 | 120+ | TOTAL
Basis*
FRA
IRS- [NAME]
OIS
VNS
Zero Coupon
TOTAL | N/A*** | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Estimated swap dollar volumes, week ending July 26, by product type and tenor (millions of USD), cleared swaps only, all participant types and tenors. Data are adjusted for double-counting of cleared trades to show a single exposure for each trade.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown. See Explanatory Notes for more detail.
*See Data Dictionary for product descriptions.
**See Explanatory Notes for tenor bucket descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 547198d1510390112-mortgage-paydown-projection-table-mortgage-paydown-projection-table-rental-valuation-breakdown
Sheet: Sheet1

[NAME]
ASKING |  |  | 203000
RV |  |  | 203000
DISCOUNT
PURCHASE AMOUNT |  |  | 140000
20% DISCOUNT IS
CASH FROM ME |  | 0.2
LOAN AMOUNT
BANK INTEREST RATE |  |  | 0.0439
LOAN TERM (YEARS) |  |  | 15
Weekly Rent |  |  | 260 | 0.8% RENT ON ASKING
GROSS INCOME |  |  |  | 0.8% RENT ON PURCHASE
Rates |  |  | 2107
Insurance |  |  | 0
Body Corp |  |  | 2424
Vacancy | 2 | Weeks
Maintenance | 3 | Weeks
Property Manager | 0
Interest on loan
Total Expenses
NET INCOME (AFTER INTEREST NO TAX) |  |  |  | NOI
(MONTHLY)
(WEEKLY)
 |  |  |  | REMAINING AFTER MORTGAGE PAYMENTS (WEEKLY)
 |  |  |  | REMAINING AFTER MORTGAGE PAYMENTS(YEARLY)
NET YIELD ON DEPOSIT |  |  |  | CAP
Tax on profit
PROFIT AFTER TAX
Spreadsheet: 852449d1702483917-need-help-moving-cells-that-meet-conditions-to-bottom-of-my-sheet-scheduling-12132023
Sheet: Cut Only

CUT ONLY |  | Total hours |  |  |  |  | 2023-11-30 00:00:00 |  | 11:59:19
Time to Print | Job # | Line # | Customer | QTY | H | W | Material | Sides to Print | [NAME] | Due_Date | Est. usage | PRESS | Notes
 | 242111 | 1 | Caleres | 4050 | 28 | 47 | PAP-SO-1374 - FOAMCORE 3/16IN WHITE 48X96 | 2 | 4 Pass | 2024-01-15 00:00:00 |  | CUT ONLY | For production quote- [NAME]
Spreadsheet: 129487d1321633046-if-sumproduct-formula-question-sample
Sheet: Sheet1

 |  |  |  | 1 | 1 |  | 1 |  |  | 1 |  | 2
 |  |  |  |  | 1 |  | 3 |  |  | 1 |  | 1
 |  |  |  | 2 |  | 1 | 1 |  |  | 2 |  |  |  |  | Shouldn't this be a checkmark?
 |  |  | 1 |  |  |  | 1 |  |  | 1 | 2 | 1
 |  |  | 1 |  |  |  | 1 |  | 2 | 1 |  | 1
 |  |  |  | 2 | 1 | 1 | 1 |  |  | 1
 |  |  |  |  |  | 2 |  | 1 | 1 | 2
 |  |  | 1 |  | 1 | 1 | 1 |  | 1 |  | 1
 |  |  | 1 |  |  |  | 2 |  |  | 1 | 1 | 1
 |  |  | 1 |  |  | 2 |  |  | 1 |  | 1 | 1
 |  |  | 2 | 2 |  | 1 |  |  |  |  | 1
 |  |  |  |  | 1 | 1 | 1 | 1 |  | 1 |  | 1
 |  |  | 1 |  |  | 1 | 1 | 1 | 1 | 1
 |  |  |  |  |  | 1 | 2 |  | 2 | 1
 |  |  | 1 |  |  | 1 |  | 2 |  |  | 1 | 1
 |  |  |  | 1 |  | 1 | 1 |  |  | 1 | 1 | 1
 |  |  | 1 | 1 |  |  | 1 | 1 |  | 1 | 1
 |  |  | 1 |  |  |  | 2 | 1 |  | 1 |  | 1
 |  |  |  |  |  |  | 2 |  | 2 | 1 | 1
 |  |  |  |  | 1 |  | 1 | 1 | 1 | 1 |  | 1
 |  |  | 1 |  | 1 |  | 1 |  |  | 3
 |  |  | 2 |  | 1 |  |  | 1 |  |  | 1 | 1
 |  |  |  | 1 |  |  | 2 | 1 | 1 |  | 1
 |  |  | 3 | 1 |  |  | 1 | 1
 |  |  |  | 2 |  | 1 |  |  |  | 1 |  | 2
 |  |  |  |  | 2 | 1 |  | 1 |  | 1 |  | 1
 |  |  |  | 1 | 1 |  | 2 | 1 |  | 1
 |  |  |  | 1 | 1 | 1 |  |  | 1 |  | 2
 |  |  | 1 | 1 |  |  | 1 |  | 1 |  | 1 | 1
 |  |  |  | 1 | 1 |  | 1 | 1 |  |  | 2
 |  |  |  | 3 |  | 1 |  | 1 | 1
 |  |  |  | 1 |  |  |  | 3 | 2
 |  |  |  | 2 | 3 |  |  |  |  | 1
 |  |  |  | 1 |  | 2 | 1 |  |  |  | 1 | 1
 |  |  |  | 1 |  |  | 1 | 1 | 2 |  | 1
 |  |  |  |  | 2 |  | 1 | 1 |  |  | 2
 |  |  | 1 |  | 1 |  |  |  | 1 | 2 | 1
 |  |  | 2 |  |  | 1 | 1 | 1 |  | 1
 |  |  |  | 1 |  | 2 |  |  | 2 | 1
 |  |  | 1 |  |  | 1 | 1 | 1 | 1 | 1
 |  |  | 1 |  |  | 1 |  | 1 | 3
 |  |  |  | 1 | 1 |  |  | 1 | 1 | 1 |  | 1
 |  |  |  |  |  | 1 |  | 1 | 1 | 1 | 1 | 1
 |  |  |  |  | 2 |  |  | 1 | 2 |  | 1
 |  |  |  |  | 1 |  |  | 1 |  | 1 | 3
 |  |  | 1 |  |  |  | 1 |  | 2 | 1 |  | 1
 |  |  | 1 |  |  |  |  | 1 |  | 1 | 1 | 2
 |  |  |  | 2 | 2 |  |  | 1 |  |  |  | 1
Spreadsheet: 230792d1366879387-drop-down-list-using-multiple-worksheets-0sor
Sheet: July 2013

Customer Name | Customer Address | Postcode | Date Enquiry Taken | Heard of us how? | Call Centre Member | Viewing Booked? Y/N | Viewing Date & Time | Viewer | Price Quoted | Clearance Booked? Y/N | Clearance Date | [NAME]? Y/N | Amount Received
Mr. [NAME] | 23 Acacia Avenue, [NAME] | CF45 4GG | 2013-05-15 00:00:00 | Word of Mouth | Anne | yes | 2011-05-20 00:00:00 | Siôn | 300 | Yes | 2013-05-25 00:00:00 | Yes | 300
Mr. [NAME] | 24 Acacia Avenue, [NAME] | CF45 4GG | 2013-05-16 00:00:00 | Leaflet | Leanne | yes | 2011-05-21 00:00:00 | Siôn | 200 | Yes | 2013-05-26 00:00:00 | Yes | 200
Ms. [NAME] | 25 Acacia Avenue, [NAME] | CF45 4GG | 2013-05-17 00:00:00 | Leaflet | Helena | yes | 2011-05-22 00:00:00 | Siôn | 250 | Yes | 2013-05-27 00:00:00 | Yes | 250
Mr. [NAME] | 26 Acacia Avenue, [NAME] | CF45 4GG | 2013-05-18 00:00:00 | Website | Leanne | yes | 2011-05-23 00:00:00 | Siôn | 200 | Yes | 2013-05-28 00:00:00 | Yes | 200 |  | Total Prices Quoted | 1500
Mrs. [NAME] | 27 Acacia Avenue, [NAME] | CF45 4GG | 2013-05-19 00:00:00 | Store Visit | Anne | yes | 2011-05-24 00:00:00 | Siôn | 300 | Yes | 2013-05-29 00:00:00 | Yes | 300 |  | Total Amounts Received | 1250
Mr. [NAME] | 28 Acacia Avenue, [NAME] | CF45 4GG | 2013-05-20 00:00:00 | Word of Mouth | [NAME] | yes | 2011-05-25 00:00:00 | Siôn | 250 | Yes | 2013-05-30 00:00:00 | No | 0
Spreadsheet: 771302d1646599298-sort-filter-data-based-on-id-number-and-date-entered-closest-to-end-of-month-test_data_02_a-bubblecandie-
Sheet: Sheet1

Date | ID Number | Amount | Timestamp
2021-01-13 00:00:00 | 12 | 900 | 2021-01-13 00:00:00
2021-01-14 00:00:00 | 12 | 42 | 2021-01-14 00:00:00 |  | ID Number | Years | Date | Max of Date
2021-01-15 00:00:00 | 12 | 99 | 2021-01-15 00:00:00 |  | 12 | 2021 | Jan | 2021-01-15 00:00:00
2022-02-02 00:00:00 | 12 | 108 | 2022-02-02 00:00:00 |  |  | 2022 | Feb | 2022-02-04 00:00:00
2022-02-03 00:00:00 | 12 | 50 | 2022-02-03 00:00:00 |  | 67 | 2022 | Jan | 2022-01-30 00:00:00
2022-02-04 00:00:00 | 12 | 63 | 2022-02-04 00:00:00 |  |  |  | Feb | 2022-02-18 00:00:00
2022-01-02 00:00:00 | 67 | 525 | 2022-01-02 00:00:00 |  |  |  | Mar | 2022-03-01 00:00:00
2022-01-03 00:00:00 | 67 | 584 | 2022-01-03 00:00:00
2022-01-30 00:00:00 | 67 | 777 | 2022-01-30 00:00:00
2022-01-27 00:00:00 | 67 | 50 | 2022-01-27 00:00:00
2022-01-24 00:00:00 | 67 | 25 | 2022-01-24 00:00:00
2022-02-01 00:00:00 | 67 | 22 | 2022-02-01 00:00:00
2022-02-04 00:00:00 | 67 | 13 | 2022-02-04 00:00:00
2022-02-05 00:00:00 | 67 | 218 | 2022-02-05 00:00:00
2022-03-01 00:00:00 | 67 | 5 | 2022-03-01 00:00:00
2022-02-18 00:00:00 | 67 | 18 | 2022-02-18 00:00:00
Spreadsheet: 213636d1360599731-show-data-based-on-selected-parameters-table6
Sheet: MAIN

Populate Numbers from the data sheet based on the selected month and hotel.
SelectMonth |  | FEBRUARY 2013
Select Hotel |  | Hotel1 |  |  |  |  |  |  |  |  | Hotel1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | JANUARY 2013 |  |  | Hotel1
 |  |  |  |  |  |  |  |  |  |  | Hotel2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | FEBRUARY 2013 |  |  | Hotel2
GHA BRAND | Hotel |  |  |  |  |  |  | MARCH 2013 |  |  | Hotel3
Brand1 |  |  |  |  |  |  |  | APRIL 2013 |  |  | Hotel4
Brand2 |  |  |  |  |  |  |  | MAY 2013 |  |  | Hotel5
Brand3 |  |  |  |  |  |  |  | JUNE 2013 |  |  | Hotel6
Brand4 |  |  |  |  |  |  |  | JULY 2013 |  |  | Hotel7
Brand5 |  |  |  |  |  |  |  | AUGUST 2013 |  |  | Hotel8
Brand6 |  |  |  |  |  |  |  | SEPTEMBER 2013 |  |  | Hotel9
Brand7 |  |  |  |  |  |  |  | OCTOBER 2013 |  |  | Hotel10
Brand8 |  |  |  |  |  |  |  | NOVEMBER 2013 |  |  | Hotel11
Brand9 |  |  |  |  |  |  |  | DECEMBER 2013 |  |  | Hotel12
Brand10 |  |  |  |  |  |  |  |  |  |  | Hotel13
Brand11 |  |  |  |  |  |  |  |  |  |  | Hotel14
Brand12 |  |  |  |  |  |  |  |  |  |  | Hotel15
Brand13 |  |  |  |  |  |  |  |  |  |  | Hotel16
Grand Total |  |  |  |  |  |  |  |  |  |  | Hotel17
 |  |  |  |  |  |  |  |  |  |  | Hotel18 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hotel18
 |  |  |  |  |  |  |  |  |  |  | Hotel19 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hotel19
 |  |  |  |  |  |  |  |  |  |  | Hotel20 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hotel20
 |  |  |  |  |  |  |  |  |  |  | Hotel21 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hotel21
 |  |  |  |  |  |  |  |  |  |  | Hotel22 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hotel22
 |  |  |  |  |  |  |  |  |  |  | Hotel23 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hotel23
 |  |  |  |  |  |  |  |  |  |  | Hotel24 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hotel24
Spreadsheet: 153226d1335808828-making-a-schedule-with-auto-time-format-and-adding-total-hours-se-schedule
Sheet: apr 23

 | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday |  | total hours
 | 2012-04-30 00:00:00 |  | 2012-05-01 00:00:00 |  | 2012-05-02 00:00:00 |  | 2012-05-03 00:00:00 |  | 2012-05-04 00:00:00 |  | 2012-05-05 00:00:00
 | In | Out | In | Out | In | Out | In | Out | In | Out | In | Out
[NAME] | off
Lunch Time
[NAME]
Lunch Time
Ray
Lunch Time
[NAME]
Lunch Time
[NAME]
Lunch Time
Kat
Lunch Time
[NAME]
Lunch Time
 |  |  |  |  |  |  |  |  |  |  |  |  | total hours
Spreadsheet: 824077d1680276759-use-vlookup-and-if-or-sort-unique-and-frequency-sample-data
Sheet: Sheet1

Worker ID | [NAME] |  |  |  | Worker ID | Consecutive Weeks
12345678 | 2022-10-09 00:00:00
12345678 | 2022-10-16 00:00:00 |  |  |  | 345987
12345678 | 2022-10-23 00:00:00 |  |  |  | 713190
12345678 | 2022-10-30 00:00:00 |  |  |  | 743911 | 2
12345678 | 2022-11-06 00:00:00 |  |  |  | 765402
12345678 | 2022-11-13 00:00:00 |  |  |  | 1645089
12345678 | 2022-11-20 00:00:00 |  |  |  | 12345678
345987 | 2023-01-01 00:00:00 |  |  |  | 66042154
345987 | 2023-01-08 00:00:00 |  |  |  | Worker ID
345987 | 2023-01-15 00:00:00 |  |  |  | 0
345987 | 2023-01-01 00:00:00
345987 | 2023-01-29 00:00:00
345987 | 2023-02-05 00:00:00
1645089 | 2022-09-25 00:00:00
1645089 | 2022-10-02 00:00:00
1645089 | 2022-10-09 00:00:00
713190 | 2023-01-01 00:00:00
713190 | 2023-01-08 00:00:00
713190 | 2023-01-15 00:00:00
713190 | 2023-01-22 00:00:00
713190 | 2023-01-29 00:00:00
125777 | 2023-01-01 00:00:00
125777 | 2023-01-08 00:00:00
125777 | 2023-01-15 00:00:00
125777 | 2023-01-22 00:00:00
125777 | 2023-01-29 00:00:00
743911 | 2022-12-18 00:00:00
743911 | 2022-12-25 00:00:00
743911 | 2023-01-15 00:00:00
765402 | 2022-12-18 00:00:00
765402 | 2022-12-25 00:00:00
765402 | 2023-01-15 00:00:00
66042154 | 2022-11-27 00:00:00
66042154 | 2022-12-04 00:00:00
66042154 | 2022-12-11 00:00:00
66042154 | 2022-12-18 00:00:00
Spreadsheet: 66925d1267607718-vlookup-match-name-and-date-book2
Sheet: Sheet1

 | Time | Type |  |  |  | Date: |  |  | No: | Pcs: | Stats: | Username: |  | [NAME]:
 |  |  |  |  |  |  |  |  |  |  |  | USER1
 |  |  |  |  |  | 2010-02-01 00:00:00 |  |  | 6 | 18 | 10.05 |  |  | Date: | 2010-02-01 00:00:00 | 2010-02-02 00:00:00 | 2010-02-03 00:00:00 | 2010-02-04 00:00:00 | 2010-02-05 00:00:00 | 2010-02-06 00:00:00 | 2010-02-07 00:00:00 | 2010-02-08 00:00:00 | 2010-02-09 00:00:00 | 2010-02-10 00:00:00 | 2010-02-11 00:00:00 | 2010-02-12 00:00:00 | 2010-02-13 00:00:00 | 2010-02-14 00:00:00 | 2010-02-15 00:00:00 | 2010-02-16 00:00:00 | 2010-02-17 00:00:00 | 2010-02-18 00:00:00 | 2010-02-19 00:00:00 | 2010-02-20 00:00:00 | 2010-02-21 00:00:00 | 2010-02-22 00:00:00 | 2010-02-23 00:00:00 | 2010-02-24 00:00:00 | 2010-02-25 00:00:00 | 2010-02-26 00:00:00 | 2010-02-27 00:00:00 | 2010-02-28 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | USER5
 | 8 | 1 |  |  |  |  |  |  |  |  |  |  |  | USER1
 | 9 | 1
 | 10 | 1
 | 11 | 0
 | 12 | 1
 | 13 | 1
 |  |  |  |  |  | 2010-02-02 00:00:00 | - | - | - | - | -
 |  |  |  |  |  | 2010-02-03 00:00:00 | - | - | - | - | -
 |  |  |  |  |  | 2010-02-04 00:00:00 |  |  |  |  | 20.43
 | 3 | 1
 | 3 | 1
 | 3 | 0
 | 3 | 0
 | 3 | 0
 | 3 | 1
 | 3 | 1
 |  |  |  |  |  |  |  |  |  |  |  | USER5
 |  |  |  |  |  | 2010-02-01 00:00:00 |  |  | 6 | 18 | 11.05
 | 8 | 1
 | 9 | 1
 | 10 | 1
 | 11 | 0
 | 12 | 1
 | 13 | 1
 |  |  |  |  |  | 2010-02-02 00:00:00 |  |  |  |  | 20.43
 | 3 | 1
 | 3 | 1
 | 3 | 0
 | 3 | 0
 | 3 | 0
 | 3 | 1
 | 3 | 1
Spreadsheet: darrell_schoolcraft__7314__imball0202
Sheet: Mojave

56696
Day | Measured | Scheduled
1 | -20864 | -19960
2 | -20875 | -19960
3 | -20001 | -19960
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2002-01-31 00:00:00 |  |  | 177959
2002-02-03 00:00:00
CBS Dollars
 |  |  | 181376
Spreadsheet: 733379d1621535112-data-validation-based-on-criteria-demo
Sheet: Sheet1

Employee | Unit
[NAME] | WEL001
[NAME] | WEL002
[NAME] | SUP001
[NAME] | SUP002
[NAME] | SUP003
[NAME] | PFT001
[NAME] | drop-down list containing WEL001 & WEL002
[NAME] | drop-down list containing SUP001 & SUP002 & SUP003
[NAME] | drop-down list containing PFT001
Spreadsheet: 749126d1632517433-trying-to-match-next-highest-number-position-in-a-column-match-questions-tms
Sheet: Sheet1

 | 7th Inning
 | Points | Items |  | XP | Next Step | Next Item | To Next | To Finish | Daily XP Gain |  | Earned | New Total
0 | 0 | xxx |  | 3550 |  |  |  |  | Games: |  | 2
1 | 5000 | [NAME] 1,500 Stubs |  |  |  | =IFERROR(INDEX(C$3:C$39,MATCH(F3,B$3:B$39,1)),"") |  |  | Moments: |  | 6000
 | 10000 | The Show Pack (5) |  |  |  |  |  |  | Other: |  | 6
 | 17500 | Nameplate & 3,000 Stubs |  |  |  | =MATCH(E3,B3:B39,1) |  |  | End:
 | 25000 | Headliners Pack (2) |  |  |  | =MATCH(E3,B3:B39,1)+3 |  |  | Total Earned:
 | 32500 | Unlockables Pack & 3,000 Stubs |  |  |  | =SUM(MATCH(E3,B3:B39,1)+3)
 | 40000 | Diamond Batting Glove |  |  |  | ="L"&SUM(MATCH(E3,B3:B39,1)+3)
 | 45000 | Diamond Cleats |  |  |  | =INDIRECT("L"&SUM(MATCH(E3,B3:B39,1)+3))
 | 55000 | [NAME]' is a Habit Pack (2)
 | 70000 | Diamond Unlockable
 | 85000 | The Show Pack (10) |  |  |  | =IFERROR(IF(SUM(F3-E3)<0,0,""),"") |  |  |  | =IFERROR(IF(SUM(F3-E3)<0,0,"over"),"")
 | 100000 | 6th Inning Diamond Card |  |  |  | =IF(SUM(F3-E3)<0,0,"") |  |  |  | =IF(SUM(F3-E3)<0,0,"over")
 | 115000 | Royals Uniform & 5,000 Stubs |  |  |  | =IF((F3-E3)<0,0,"") |  |  |  | =IF((F3-E3)<0,0,"over")
 | 130000 | Headliners Pack (2) |  |  |  | =IF(F3-E3<0,0,"") |  |  |  | =IF(F3-E3<0,0,"over")
 | 145000 | Gold Ballplayer Pack
 | 160000 | [NAME]' is a Habit Pack (2) |  |  |  | SUM is redundant in these formulae
 | 175000 | 6th Inning Diamond Classics Card
 | 190000 | Unlockable & 5,000 Stubs
 | 205000 | Unlockable
 | 220000 | [NAME] 32 (2)
 | 235000 | Gold Ballplayer Pack
 | 250000 | Equipment Item & 5,000 Stubs
 | 270000 | The Show Pack (5)
 | 290000 | Legends Icons Pack
 | 310000 | [NAME] 33
 | 330000 | Red Sox Uniform & 5,000 Stubs
 | 350000 | 6th Inning Bosses Pack
 | 380000 | Gold Ballplayer Pack
 | 410000 | Classic Stadium Pack
 | 440000 | The Show Pack (10)
 | 470000 | Angels Uniform & 5,000 Stubs
 | 500000 | [NAME]' is a Habit Pack (5)
 | 530000 | Diamond Ballplayer Pack
 | 560000 | ASG Pack
 | 590000 | HRD Pack
 | 620000 | The Show Pack (20)
 | 650000 | 90+ Live Series Pack
Spreadsheet: 195b33ef-683f-4b89-9189-2ad6d484c25c
Sheet: Sheet1

Seattle University | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
Science & Engineering Project Center
Budget Request Form
Project Team
Faculty Project Advisor Signature |  |  |  | Date
S&E Project Center (authorization) |  |  |  | Date
The overall budget must be approved by the Project Center before any purchases or reimbursements will be authorized. Revisions to the budget (including transfer of funds between categories) must also be requested in writing to the Project Center.
Reference Materials |  |  |  | TOTAL: ( A )
(ie: library searches, reference documents, manuals)
Office Supplies |  |  |  | TOTAL: ( B ) | 0
(i.e. binders, paper, disks, printer supplies, photocopying, telephone, postage, fax, etc.)
Office Equipment
Printing & Photocopying
Telephone Usage
Postage
Expendable Supplies
(ie: chips, LEDs, connectors, lab/shop testing supplies) |  |  |  | TOTAL: ( C ) | 0
Project Equipment (under $500)
Parking
Mileage
Capital Equipment
**Any purchase over $500.00 |  |  |  | TOTAL: ( D )
(ie: software packages, test equipment and instruments, major laboratory components)
Team Building |  |  |  | TOTAL: ( E ) | 150
**Limited to $150 per project team
(Food purchases only, unless otherwise approved by the Project Center!)
Total Projected Budget (A, B, C, D, and E) |  | TOTAL PROJECTED BUDGET: |  |  | 150
*BUDGETS ARE DUE TO THE PROJECT CENTER BY 4PM ON FRIDAY, NOVEMBER 8, 2013!
Spreadsheet: 270163d1381407345-extracting-numbers-from-a-column-that-are-evenly-spaced-14-rows-apart-gl-test-file
Sheet: Sheet1

 |  |  | using vlookup | 14 | using index
[NAME] | [NAME]'s value I want | [NAME] |  | 2
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
 |  | [NAME]
[NAME] | [NAME]'s value I want
[NAME] | [NAME]'s value I want
[NAME] | Alice's value I want
[NAME] | [NAME]'s value I want