tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 674205d1587717256-count-if-adjacent-cell-to-count-falls-within-criteria-or-not-example
Sheet: Sheet1

 |  |  | Date Min |  | Date Max
Date Start | Date End | Deadline |  | Month | Due | On Time
2019-11-09 00:00:00 | 2020-02-14 00:00:00 | 2020-02-14 00:00:00
2019-11-19 00:00:00 | 2020-02-26 00:00:00 | 2020-02-23 00:00:00
2019-07-21 00:00:00 | 2019-07-25 00:00:00 | 2019-07-24 00:00:00
2019-07-23 00:00:00 | 2019-07-30 00:00:00 | 2019-07-29 00:00:00
2020-01-01 00:00:00 | 2020-01-07 00:00:00 | 2020-01-08 00:00:00
2020-04-20 00:00:00 | 2020-04-23 00:00:00 | 2020-04-26 00:00:00
2019-09-18 00:00:00 | 2019-10-16 00:00:00 | 2019-10-14 00:00:00
2019-09-23 00:00:00 | 2019-10-21 00:00:00 | 2019-10-23 00:00:00
2019-09-30 00:00:00 | 2019-10-28 00:00:00 | 2019-10-31 00:00:00
2019-10-10 00:00:00 | 2019-11-07 00:00:00 | 2019-11-06 00:00:00
2019-10-20 00:00:00 | 2019-11-17 00:00:00 | 2019-11-18 00:00:00
2019-11-11 00:00:00 | 2019-12-09 00:00:00 | 2019-12-09 00:00:00
2019-11-21 00:00:00 | 2019-12-19 00:00:00 | 2019-12-19 00:00:00
2019-12-26 00:00:00 | 2020-01-23 00:00:00 | 2020-01-23 00:00:00
2020-01-07 00:00:00 | 2020-02-04 00:00:00 | 2020-02-03 00:00:00
2020-01-17 00:00:00 | 2020-04-23 00:00:00 | 2020-04-26 00:00:00
2019-12-12 00:00:00 | 2019-12-19 00:00:00 | 2019-12-18 00:00:00
2019-12-22 00:00:00 | 2019-12-29 00:00:00 | 2019-12-28 00:00:00
2019-12-27 00:00:00 | 2020-01-03 00:00:00 | 2020-01-06 00:00:00
2019-12-03 00:00:00 | 2019-12-10 00:00:00 | 2019-12-12 00:00:00
2020-01-07 00:00:00 | 2020-01-14 00:00:00 | 2020-01-17 00:00:00
2020-01-17 00:00:00 | 2020-01-24 00:00:00 | 2020-01-21 00:00:00
2020-02-12 00:00:00 | 2020-02-19 00:00:00 | 2020-02-22 00:00:00
2020-03-13 00:00:00 | 2020-03-20 00:00:00 | 2020-03-18 00:00:00
2020-01-20 00:00:00 | 2020-01-27 00:00:00 | 2020-01-25 00:00:00
2020-01-21 00:00:00 | 2020-01-28 00:00:00 | 2020-01-30 00:00:00
2020-02-15 00:00:00 | 2020-02-22 00:00:00 | 2020-02-24 00:00:00
2020-03-06 00:00:00 | 2020-03-13 00:00:00 | 2020-03-12 00:00:00
2019-11-04 00:00:00 | 2019-11-11 00:00:00 | 2019-11-12 00:00:00
2019-12-06 00:00:00 | 2019-12-13 00:00:00 | 2019-12-11 00:00:00
2020-01-12 00:00:00 | 2020-01-19 00:00:00 | 2020-01-22 00:00:00
2020-04-14 00:00:00 | 2020-04-21 00:00:00 | 2020-04-23 00:00:00
2020-04-15 00:00:00 | 2020-04-22 00:00:00 | 2020-04-23 00:00:00
2020-04-16 00:00:00 | 2020-04-23 00:00:00 | 2020-04-21 00:00:00
2019-11-04 00:00:00 | 2019-11-11 00:00:00 | 2019-11-08 00:00:00
2019-11-18 00:00:00 | 2019-11-25 00:00:00 | 2019-11-27 00:00:00
2020-01-08 00:00:00 | 2020-01-15 00:00:00 | 2020-01-17 00:00:00
2020-04-22 00:00:00 | 2020-04-29 00:00:00 | 2020-05-02 00:00:00
2019-10-30 00:00:00 | 2019-11-06 00:00:00 | 2019-11-03 00:00:00
2019-12-05 00:00:00 | 2019-12-12 00:00:00 | 2019-12-12 00:00:00
Spreadsheet: tracy_geaccone__40168__2002 HDCT PLAN
Sheet: STAFFING BY LOCATION

2002 Operating and Strategic Plan
Staffing Summary - By Location
Co. Number: |  |  |  |  |  | Estimated
 |  |  |  |  |  | 12/31/02
Location of Total Employees
 | Domestic
 |  | Downtown Houston |  |  |  | 0
 |  | Houston - Other |  |  |  | 0
 |  | Omaha |  |  |  | 0
 |  | Portland |  |  |  | 0
 |  | California |  |  |  | 0
 |  | Washington |  |  |  | 0
 |  | Other (please list) |  |  |  | 0
 | Expatriates |  |  |  |  | 0
 | International |  |  |  |  | 0
 |  | London |  |  |  | 0
 |  | Other Europe |  |  |  | 0
 |  | Canada |  |  |  | 0
 |  | South America |  |  |  | 0
 |  | India |  |  |  | 0
 |  | Other (please list) - Calgary (3) Toronto (1) |  |  |  | 0
 | Total
Location of 3rd Party Contractors
 | Domestic
 |  | Downtown Houston |  |  |  | 0
 |  | Houston - Other |  |  |  | 0
 |  | Omaha |  |  |  | 0
 |  | Portland |  |  |  | 0
 |  | California |  |  |  | 0
 |  | Washington |  |  |  | 0
 |  | Other (please list) - New York |  |  |  | 0
 | Expatriates |  |  |  |  | 0
 | International |  |  |  |  | 0
 |  | London |  |  |  | 0
 |  | Other Europe |  |  |  | 0
 |  | Canada |  |  |  | 0
 |  | South America |  |  |  | 0
 |  | India |  |  |  | 0
 |  | Other (please list) |  |  |  | 0
 | Total
Total Employees by Location *
*Totals must tie to 'Staffing Employee by Status'
Spreadsheet: 867495d1714373316-condtional-format-excel-list-book1-3-
Sheet: Sheet1

List 1 | List 2 | List 3 | List 4 | List 5 | List 6 |  |  |  | My dependent lists that I can copy around the sheet | List 6
A | AA | AAA | AAAA | AAAAA | AAAAAA |  |  |  |  | [NAME]
B | BB | BBB | BBBB | BBBBB | BBBBBB
C | CC | CCC | CCCC | CCCCC | CCCCCC
D | DD | DDD | DDDD | DDDDD | [NAME] |  |  |  |  | List 4
E | EE | EEE | EEEE | EEEEE | EEEEEE |  |  |  |  | DDDD
F | FF | FFF | FFFF | FFFFF | FFFFFF
 |  |  |  |  |  |  |  |  |  | List 1
Spreadsheet: 89a14fd9-e565-411b-ab1a-9ba96cd744f9
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
6263 | 40957 | Iain | Dawson | GBR | 54 | 00:05:50 | 00:01:23 | 00:11:48 | 00:00:41 | 00:14:35 | 1 | 00:34:16
6263 | 30797 | [NAME] | [NAME] | GBR | 55 | 00:07:49 | 00:01:18 | 00:13:44 | 00:00:46 | 00:14:20 | 2 | 00:37:55
Spreadsheet: 191230d1351978684-error-in-opening-file-and-saving-a-file-customer-load-data
Sheet: Common Customers

Z00014
Z00014-A
[NAME] |  |  |  |  |  |  | customers  149
[NAME]
Z00019-A |  |  |  |  |  | cocd | 1000 | scrambling
Z00077 |  |  |  |  |  | cocd | 9000 | I need it
Z00077-A
Z00077-A01
[NAME]
Z00174-A
Z00174-A01
Z00174-A02
Z00174-A03
Z00174-A04
Z00174-A05
Z00174-A06
Z00174-A07
[NAME]
Z00174-A09
Z00174-A10
[NAME]
[NAME]
[NAME]
Z00174-A14
Z00174-A15
Z00213
Z00213-A
Z00213-A01
Z00213-A02
Z00236
Z00236-A
Z00236-A15
Z00236-A16
[NAME]
Z00236-A18
Z00236-A19
Z00960
Z00960-A
Z00960-A01
Z00960-B
Z00960-B01
Z00960-B02
Z00960-B03
Z00960-B04
Z00960-B05
Z00960-B06
Z00960-B07
Z00960-B08
Z00960-B09
Z00960-B10
Z00960-B11
Z00960-B13
Z00960-B14
Z01062
Z01062-A
Z01062-A01
Z01062-A02
Z01169
Z01169
Z01169-A
Z01169-A
Z01169-A01
Z01169-A01
Z01169-A03
Z01217
Z01217-A
Z01217-A01
[NAME]
[NAME]-A
Z01228-A01
Z01435
Z01435-A
Z01435-A01
Z01435-A02
Z01435-A03
[NAME]
Z01435-A05
[NAME]
Z01435-A07
[NAME]
Z01435-A09
Z01435-A10
[NAME]
Z01435-A12
Z01435-A14
Z01435-A15
Z01435-A16
[NAME]
[NAME]
Z01435-A19
Z01435-A20
[NAME]
Z01435-A22
Z01435-A23
Z01435-A24
Z01435-A25
[NAME]
[NAME]
Z01435-A28
[NAME]
Z01435-A30
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
[NAME]
Z01435-A37
[NAME]
Z01435-A39
Z01435-A40
Z01435-A41
Z01435-A42
Z01435-A43
[NAME]
Z01435-A45
Z01435-A46
[NAME]
Z01435-A48
Z01435-A49
Z01435-B
[NAME]
[NAME]
Z01450
Z01450-A
Z01450-A01
Z01450-A02
Z01450-A03
Z01450-A04
Z01450-A05
Z01450-A06
Z01450-A07
Z01450-A08
Z01450-A09
Z01450-B01
Z01451
Z01451-A
Z01451-A01
Z01472
Z01472-A
Z01472-A01
Z01472-A02
Z01490
Z01490-A
Z01493-A
Z01493-A01
Z01494
Z01494-A
Z01494-A01
Spreadsheet: 133268d1324312184-sorting-book1
Sheet: Sheet1

Initial |  | Sorted
03-6171 |  | 00-3291
01-4267A |  | 00-3293
02-5267A |  | 01-4267A
03-6168B |  | 01-4333
00-3293 |  | 01-5263
01-5263 |  | 02-5267A
00-3291 |  | 03-6168B
01-4333 |  | 03-6171
01-4333 |  | 00-3291
02-5263 |  | 00-3293
03-6171 |  | 01-4267A
00-3291 |  | 01-4333
00-3293 |  | 02-5263
01-4267A |  | 02-5267A
02-5267A |  | 03-6168B
03-6168B |  | 03-6171
Spreadsheet: 141855d1329485568-vlookup-with-multiple-criteria-multivlookupv2
Sheet: Sheet1

 | Monday | Room 1 | Jon |  |  | Monday | Thursday | Wednesday | Friday | Saturday | Sunday
 | Monday | Room 2 | [NAME] |  | Room 1
 | Monday | Room 3 | [NAME] |  | Room 2
 | Thursday | Room 1 | [NAME] |  | Room 3
 | Thursday | Room 2 | [NAME]
 | Thursday | Room 3 | [NAME]
 | Wednesday | Room 1 | [NAME]
 | Wednesday | Room 2 | Jon
 | Wednesday | Room 3 | Jon
 | Wednesday | Room 1 | [NAME]
 | Friday | Room 2 | [NAME]
 | Friday | Room 3 | Jon
 | Saturday | Room 1 | [NAME]
 | Sunday | Room 2 | [NAME]
Spreadsheet: 864328d1711545709-how-can-i-enhance-this-sumproduct-formula-to-only-counts-cells-greater-than-zero-sumproduct-question
Sheet: WORKING Version

Year | 2023 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2025 | 2025 | 2025 | 2025
Month | 2023-12-01 00:00:00 | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2024-06-01 00:00:00 | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00 | 2024-11-01 00:00:00 | 2024-12-01 00:00:00 | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00 | 2025-04-01 00:00:00
Users | 25 | 28 | 26 | 21 | 29 | 34 | 33 | 35 | 31 | 27 | 27 | 25 | 23 | 22 | 27 | 29 | 31
Hours | 501 | 608 | 612 | 574 | 773 | 809 | 768 | 811 | 809 | 639 | 622 | 611 | 634 | 620 | 799 | 632 | 733
Avg of Monthly Hours
Year Selected ([NAME]) | 2024
Spreadsheet: 053ef7c5-aed4-43bb-abb6-f6a8c1a9fb9c
Sheet: WebofScience

Web of Science
2005-2006
 | 2005-07-01 00:00:00 | 2005-08-01 00:00:00 | 2005-09-01 00:00:00 | 2005-10-01 00:00:00 | 2005-11-01 00:00:00 | 2005-12-01 00:00:00 | 2006-01-01 00:00:00 | 2006-02-01 00:00:00 | 2006-03-01 00:00:00 | 2006-04-01 00:00:00 | 2006-05-01 00:00:00 | 2006-06-01 00:00:00 | Total | 2005-2006 Price | Price per search
Web of Science
Sessions | 280 | 437 | 508 | 1034 | 834 | 477 | 404 | 506 | 534 | 677 | 455 | 376
Queries | 1138 | 1220 | 1907 | 2645 | 3056 | 1835 | 1408 | 1963 | 1933 | 2192 | 1245 | 1036 |  | 90186
Maximum Contractual Users | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
Turnaways | 1 | 24 | 19 | 4895 | 377 | 132 | 138 | 122 | 5 | 1522 | 866 | 715
Spreadsheet: 686761d1594807454-min-max-calc-for-financial-projection-fm-mhc-model-excelforum-
Sheet: Summary

Acquisition Summary |  | Purchase |  | Sale / Refinance |  | Project Level Returns |  |  | Equity Level Returns
 |  | [NAME]: |  | Term [NAME] %: |  |  | Unlevered | Levered |  | LP | GP
Acquisition Date: | 2019-10-01 00:00:00 | Purchase $: |  | Sale $/Value: |  | IRR: |  |  | IRR: |  | N/A
Hold Period: |  | Closing Costs: |  | SC 2.5%: |  | Multiple: |  |  | Multiple:
End Date: |  | CapEx: |  | Loan Payoff: |  | Investment: |  |  | Investment:
 |  | Equity: |  | Capital @ Sale: | 0 | Cash Flow: |  |  | Cash Flow:
Acquisition $/Unit: |  | Total Inv: |  | Sale/Refi $: |  | Total Proceeds: |  |  | Total Proceeds:
10-Year Operating Plan
 | In-Place
Lot Rent (Single)
Rent % G/(L)
Cum Rent % G/(L)
Net Occ Gain/(Loss)
[NAME])
Total Units
Occupancy
Occupancy %
Revenue
Operating Expense
OE %
NOI
NOI %
Capital Expense
Unlevered Cash Flow
Unlevered IRR
Debt Service
[NAME]
DCR-NOI
[NAME]
CF from Invest/Sale
Cash Flow
Equity & Preferred Return
Beginning Balance
Less: Pref Ret Paid
Less: Equity Repay
Ending Balance
Surplus after Payoff
Split of Surplus Proceeds
To LP
To GP
Investor Cash Flow
Initial Investment
Preferred Return
Investment Repayment
Excess Proceeds Split
Cash Flow
Cumulative Net CF
Investor IRR
Investment Multiple
Income Yield
Debt Yield
Cash on Cash
Leveraged CoC Yield
Spreadsheet: 155072d1336662190-x-axis-probklem-in-simple-line-charts-export-m
Sheet: data

 | B | C | D
 | Total | Knight | Castaldo
1977 | 223930 | 88880 | 135050
1978 | 278160 | 94560 | 183600
1979 | 294655 | 100813 | 193842
1980 | 247318 | 87398 | 159920
1981 | 294306 | 116056 | 178250
1982 | 367837 | 146275 | 221562
1983 | 387152 | 194917 | 192235
1984 | 423793 | 192198 | 231595
1985 | 566570 | 306930 | 259640
1986 | 658040 | 391476 | 266564
1987 | 697056 | 385810 | 311246
1988 | 758834 | 286147 | 472687
1989 | 795476 | 295431 | 500045
1990 | 964983 | 341022 | 623961
1991 | 986470 | 334845 | 651625
1992 | 1050545 | 360802 | 689743
1993 | 1414698 | 433195 | 981503
1994 | 1138928 | 368290 | 770638
1995 | 1333932 | 389818 | 944144
1996 | 1237839 | 401246 | 836593
1997 | 1323398 | 364568 | 958830
1998 | 1321399 | 365378 | 956021
1999 | 1556035 | 389110 | 1166924
2000 | 1728107 | 406942 | 1321165
2001 | 1748184 | 433106 | 1351078
2002 | 1762217 | 343715 | 1418502
2003 | 1815141 | 345659 | 1469482
2004 | 1963490 | 306987 | 1655229
2005 | 2185782 | 277386 | 1908396
2006 | 1578474 | 265323 | 1322151
2007 | 1774483 | 241124 | 1533359
2008 | 1902279 | 237059 | 1665220
2009 | 1425225 | 178956 | 1246269
2010 | 1529813 | 199759 | 1330054
2011
Spreadsheet: 757323d1638192120-why-v-lookup-is-not-showing-the-result-yarn-received-2021-22
Sheet: FOR MAIL

 |  | TOTAL WEIGHT | 5737.51 |  |  |  |  | TOTAL AMOUNT | 0
DATE | [NAME]. | PARTY NAME | WEIGHT | BOX | SHADE | RATE | TYPE | P.O. NO. | AMOUNT | 2021-11-01 00:00:00
2021-01-11 00:00:00 | 392 | FINE IMPEX | 1250 | 25 BAG | 2/5 COTTON | 124 | 2/5 COTTON | 4591
2021-02-11 00:00:00 | 1273 | KATYAL TRADING CO. | 291.81 | 12 BOX | 155 D AQUA | 182 | 155 D AQUA | 4591
2021-02-11 00:00:00 | 1273 | KATYAL TRADING CO. | 226.57 | 10 BOX | 155 D N BLUE | 182 | 155 D N BLUE | 4591
2021-02-11 00:00:00 | 1424 | AN YARN | 993.6 | 18 BAG | 2/5 COTTON | 118 | 2/5 COTTON | 4581 A
2021-02-11 00:00:00 | 1424 | AN YARN | 2911.5 | 53 BAG | 2/5 COTTON | 123 | 2/5 COTTON | 4582 B/4582 A
2021-06-11 00:00:00 | 2933 | RAYMONS YARN | 64.03 | 2 BOX | 1200 FILLER | 135 | 1200 FILLER | 3111
Spreadsheet: 59792d1260345169-formula-for-alert-or-message-test-name
Sheet: Sheet1

 |  | COMPANY | [NAME]
 |  |  |  |  | operator | XYZ |  | VALIDATION 1
 |  |  |  |  | operator | abc |  | VALIDATION 2
 |  | COMPANY | OPERATOR
 |  | [NAME] | MICHLE
 |  | [NAME] | [NAME]
 |  | [NAME] | ABC
 |  | [NAME] | XYZ
 |  | ABS CARS CO | CHRISTINA
 |  | ABS CARS CO | JOY
 |  | ABS CARS CO | ANNA
 |  | ABS CARS CO | MATHEW
Spreadsheet: 146387d1332163872-rearranging-row-data-into-column-headers-for-large-file-sample_workbook_problem
Sheet: How I would like to have it

 |  |  |  |  | Metric 1 | Metric 2 | Metric 3 | Metric 4 | Metric 5 | Metric 6 | Metric 7 | Metric 8 | Metric 9 | Metric 10 | Metric 11
 | Category 1
 | Sub-category 1 |  |  |  | Data 1 | Data 1 | Data 1 | Data 1 | Data 1 | Data 1 | Data 1 | Data 1 | Data 1 | Data 1 | Data 1
 | Sub-category 2 |  |  |  | Data 2 | Data 2 | Data 2 | Data 2 | Data 2 | Data 2 | Data 2 | Data 2 | Data 2 | Data 2 | Data 2
 | Sub-category 3 |  |  |  | Data 3 | Data 3 | Data 3 | Data 3 | Data 3 | Data 3 | Data 3 | Data 3 | Data 3 | Data 3 | Data 3
 | Category 2 |  |  |  | Data 4 | Data 4 | Data 4 | Data 4 | Data 4 | Data 4 | Data 4 | Data 4 | Data 4 | Data 4 | Data 4
 | Sub-category 1 |  |  |  | Data 5 | Data 5 | Data 5 | Data 5 | Data 5 | Data 5 | Data 5 | Data 5 | Data 5 | Data 5 | Data 5
Spreadsheet: 160163d1338993679-lookups-in-excel-2007-book1
Sheet: Sheet1

draft | [NAME] | 2011-12-01 00:00:00 | Book 1 in Law
draft | [NAME] | 2011-12-01 00:00:00 | Book 2 in Law
to be drafted | Sandra | 2011-12-01 00:00:00 | Autobiography
no | [NAME] | 2011-11-01 00:00:00 | Sample 1
no | [NAME] | 2011-11-01 00:00:00 | Sample 2
Note: if A:A contains the word "draft", I would like to pull the contents of B, C and D into sheet 2?
Spreadsheet: 874829d1721335383-counting-the-days-test2
Sheet: TEST

Item | Buy date |  |  | Item | Buy date
Chocolate | 2020-01-02 17:43:00 |  |  | Chocolate | 2020-04-01 22:58:00
Sweets | 2020-01-03 04:45:00 |  |  | Sweets | 2020-04-06 07:23:00
Potato | 2020-01-03 04:47:00 |  |  | Potato | 2020-04-10 05:46:00
Drinks | 2020-01-03 12:32:00 |  |  | Drinks | 2020-04-12 14:16:00
Potato | 2020-01-03 14:04:00 |  |  | Potato | 2020-04-13 22:53:00
Drinks | 2020-01-05 03:12:00 |  |  | Drinks | 2020-04-16 08:27:00
Potato | 2020-01-05 09:03:00 |  |  | Potato | 2020-04-18 16:39:00
Drinks | 2020-01-06 04:12:00 |  |  | Drinks | 2020-04-20 12:28:00
Drinks | 2020-01-06 23:21:00 |  |  | Drinks | 2020-04-21 17:54:00
Sweets | 2020-01-10 18:10:00 |  |  | Sweets | 2020-04-22 07:34:00
Drinks | 2020-01-14 04:27:00 |  |  | Drinks | 2020-04-26 14:10:00
Drinks | 2020-01-17 09:01:00 |  |  | Drinks | 2020-04-26 23:36:00
Chocolate | 2020-01-19 12:42:00 |  |  | Chocolate | 2020-04-29 03:07:00
Drinks | 2020-01-27 13:51:00 |  |  | Drinks | 2020-05-05 05:21:00
Drinks | 2020-01-30 17:50:00 |  |  | Drinks | 2020-05-06 08:15:00
Ice Cream | 2020-02-03 17:01:00 |  |  | Ice Cream | 2020-05-07 12:51:00
Drinks | 2020-02-05 12:32:00 |  |  | Drinks | 2020-05-10 02:01:00
Ice Cream | 2020-02-10 07:28:00 |  |  | Ice Cream | 2020-05-17 14:12:00
Drinks | 2020-02-11 16:30:00 |  |  | Drinks | 2020-05-21 15:16:00
Chocolate | 2020-02-16 20:13:00 |  |  | Chocolate | 2020-05-27 10:29:00
Chocolate | 2020-02-17 14:37:00 |  |  | Chocolate | 2020-06-02 00:11:00
Ice Cream | 2020-02-19 22:49:00 |  |  | Ice Cream | 2020-06-04 14:38:00
Chocolate | 2020-02-24 18:27:00 |  |  | Chocolate | 2020-06-10 20:03:00
Chocolate | 2020-02-26 02:58:00 |  |  | Chocolate | 2020-06-11 17:56:00
Ice Cream | 2020-03-01 17:34:00 |  |  | Ice Cream | 2020-06-15 06:12:00
Drinks | 2020-03-05 12:47:00 |  |  | Drinks | 2020-06-24 16:07:00
Chocolate | 2020-03-07 17:41:00 |  |  | Chocolate | 2020-06-27 20:23:00
Chocolate | 2020-03-11 18:28:00 |  |  | Chocolate | 2020-07-02 16:03:00
Chocolate | 2020-03-12 04:37:00 |  |  | Chocolate | 2020-07-08 14:21:00
Out | 2020-03-13 02:02:00 |  |  | Drinks | 2020-07-16 10:17:00
 |  |  |  | Drinks | 2020-07-21 09:49:00
 |  |  |  | Out | 2020-07-30 06:04:00
Spreadsheet: 861606d1709497614-time-calculation-formula-time-lapse-dj
Sheet: Sheet 1

Date | Day | Start of shift | End of shift |  |  |  |  |  |  | Operation | Start | Lenght (in hours)
01.01.2024. | Monday | 06:00:00 | 22:00:00 |  |  |  |  |  |  | 1 | 2024-01-01 06:00:00 | 36
02.01.2024. | Tuesday | 06:00:00 | 22:00:00 |  |  |  |  | 2024-01-03 10:00:00 |  | 2 |  | 85
03.01.2024. | Wednesday | 06:00:00 | 22:00:00 |  |  |  |  | 2024-01-10 07:00:00 |  | 3 |  | 13
04.01.2024. | Thursday | 06:00:00 | 22:00:00 |  |  |  |  | 2024-01-10 08:00:00 |  | 4 |  | 21
05.01.2024. | Friday | 06:00:00 | 22:00:00 |  |  |  |  | 2024-01-11 13:00:00 |  | 5
06.01.2024. | Saturday | 06:00:00 | 14:00:00
07.01.2024. | Sunday | Closed | Closed
08.01.2024. | Monday | 06:00:00 | 22:00:00
09.01.2024. | Tuesday | 06:00:00 | 22:00:00
10.01.2024. | Wednesday | 06:00:00 | 22:00:00
11.01.2024. | Thursday | 06:00:00 | 22:00:00
12.01.2024. | Friday | 06:00:00 | 22:00:00
13.01.2024. | Saturday | 06:00:00 | 14:00:00
14.01.2024. | Sunday | Closed | Closed
Spreadsheet: 27f11e35-ca56-478c-b936-25296f93f876
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
タイトル | [NAME] | 出版社 | 発行年月日 | ページ数 | 価格 | 本の形態 | ISBM
青い図書カード | [NAME] | 偕成社 | 1999-10-01 00:00:00 | 237 | 1365 |  | 9784037266608
みさきめぐりのとしょかんバス―としょかんバス・シリーズ〈1〉 (絵本の泉) | 松永 伊知子 | 岩崎書店 | 1996-05-01 00:00:00 | 32 | 1427 | 大型本(絵本） | 9784265033355
ぼくの図書館カード | ウィリアム ミラー; グレゴリー クリスティ | 新日本出版社 | 2010-11-01 00:00:00 | 31 | 1575 |  | 9784406054102
ファンタージエン 秘密の図書館 | ラルフ・イーザウ | ソフトバンククリエイティブ | 2005-09-29 00:00:00 | 512 | 1890 |  | 9784797329834
バスラの図書館員―イラクで本当にあった話 | ジャネット・ウィンター | 晶文社 | 2006-04-10 00:00:00 |  | 1680 | 大型本(絵本） | 9784794920423
トマスと図書館のおねえさん | パット モーラ | さえら書房 | 2010-02-01 00:00:00 |  | 1470 | 大型本(絵本） | 9784378041230
ぼくのブック・ウーマン | ヘザー ヘンソン | さえら書房 | 2010-04-01 00:00:00 |  | 1470 | 大型本(絵本） | 9784378041247
図書館ラクダがやってくる―子どもたちに本をとどける世界の活動 | マーグリート ルアーズ | さえら書房 | 2010-04-01 00:00:00 | 30 | 1470 | 大型本(絵本） | 9784378041254
つづきの図書館 | 柏葉 幸子 | [NAME] | 2010-01-15 00:00:00 | 242 | 1575 |  | 9784062160100
大草原のとしょかんバス―としょかんバス・シリーズ〈2〉 (絵本の泉) | 岸田 純一 | 岩崎書店 | 1996-08-01 00:00:00 | 32 | 1427 | 大型本(絵本） | 9784265033362
親愛なるブリードさま―強制収容された日系二世とアメリカ人図書館司書の物語 | ジョアンヌ オッペンハイム | 柏書房 | 2008-06-01 00:00:00 | 406 | 3360 |  | 9784760133888
しずかに!ここはどうぶつのとしょかんです | ドン [NAME] | BL出版 | 2008-05-01 00:00:00 |  | 1470 | 大型本(絵本） | 9784776402862
さびしい時間(とき)のとなり―けやき図書館物語 (for Boys and Girls) | 草谷 桂子 | [NAME] | 2000-01-01 00:00:00 | 175 | 1050 |  | 9784591062432
[NAME] | 魚瀬 ゆう子 | 桂書房 | 2009-07-01 00:00:00 |  | 1365 | 大型本(絵本） | 9784903351704
[NAME] (児童図書館・絵本の部屋) | デイヴィッド メリング | 評論社 | 2005-09-01 00:00:00 |  | 1470 | 大型本(絵本） | 9784566008137
がちょうのペチューニア | ロジャー・デュボワザン | [NAME] | 1999-01-16 00:00:00 | 32 | 1470 | 大型本(絵本） | 9784572003652
ビバリーとしょかんへいく | アレクサンダー スタッドラー | 文化出版局 | 2003-06-01 00:00:00 | 31 | 1470 | 大型本(絵本） | 9784579404230
としょかんへいくピープちゃん (児童図書館・絵本の部屋) | クレシッダ・コーウェル | 評論社 | 1999-04-01 00:00:00 |  | 1890 | 大型本(絵本） | 9784566004887
空へつづく神話 | 富安 陽子 | 偕成社 | 2000-06-01 00:00:00 | 285 | 1365 |  | 9784037270803
としょかんライオン (海外秀作絵本 17) | ミシェル・ヌードセン | 岩崎書店 | 2007-04-20 00:00:00 |  | 1680 | 大型本(絵本） | 9784265068173
晴れた日は図書館へいこう (文学の森) | 緑川 聖司 | 小峰書店 | 2003-10-01 00:00:00 | 206 | 1575 |  | 9784338174152
[NAME] (児童図書館・絵本の部屋) | J‐B. バロニアン | 評論社 | 1999-11-01 00:00:00 |  | 1365 | 大型本(絵本） | 9784566006645
コアラとお花 (ポプラせかいの絵本) | メアリ マーフィ | [NAME] | 2001-11-01 00:00:00 |  |  | 大型本(絵本） | 9784591069332
Spreadsheet: 694653d1599737109-excel-lookup-and-countif-issue-example-100920
Sheet: Sorted list by sector -analysis

ID | Name | Code | Main listing | Sector | Sub-sector | Territory |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Currency | Exchange Rate
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.1
966 | [NAME] | GSK | LSE | Pharma / Biotech | world's sixth largest pharmaceutical company | UK |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | GBP
1237 | Amazon | AMZN | NASDAQ | Retail | e-commerce, [NAME], digital streaming, and artificial intelligence | Global |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | USD
965 | Gilead Sciences | GILD | NASDAQ | Pharma / Biotech | antiviral drugs used in the treatment of HIV, hepatitis B, hepatitis C, and influenza, including [NAME] and [NAME] | US |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | USD
921 | [NAME] | CRSP | NASDAQ | Pharma / Biotech | CRISPR gene editing | US |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | USD
Spreadsheet: d035072b-a633-496d-8b7d-fc058b01e3de
Sheet: Sheet1

PAY PERIOD ENDING DATE | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | INDIANA UNIVERSITY OF PENNSYLVANIA | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18 | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23 | Unnamed: 24 | Unnamed: 25 | Unnamed: 26
IF ADJUSTMENT, PAY PERIOD ENDING DATE |  |  |  |  |  |  |  |  |  |  | TIME AND ATTENDANCE RECORD
 |  |  |  |  |  |  |  |  |  |  |  | FULL TIME SCUPA
EMPLOYEE NAME |  |  |  |  |  |  | EMPLOYEE ID NUMBER |  |  |  |  |  | BU# |  |  | TIMEKEEPER'S # |  |  |  | STATUS: |  | PERM |  | TEMP |  | WAGE
 |  | LAST |  |  | FIRST | MI
 | REGULAR SCHEDULED WORK DAY | O  V  E R  T  I  M  E |  |  |  |  |  |  | OVERTIME CALL |  | OT      STANDBY      .25 | OT HALFTIME |  |  | P    A    I    D        L    E   A    V    E    S |  |  |  |  |  |  | UNPAID    LEAVES | COMMENTS
DATE |  | START | END | START | END | OT      1.0 | OT      1.5 | OT      2.0 | OT      1.0 | OT      1.5 |  | OT          .5 | OT HOLIDAY .5 | OT      HOLIDAY 1.5 | A | S | SF                    SB | P | CL | H
 | 7.50
 | 7.50
 | 7.50
 | 7.50
 | 7.50
 | 7.50
 | 7.50
 | 7.50
 | 7.50
 | 7.50
REVISED 3/06 |  | TIME AND ATTENDANCE CODES |  |  |  | 210 | 215 | 220 | 235 | 240 | 255 | 200 | 205 | 230 | 300 | 310 | 312 314 | 320 | 330 | 350
 |  |  |  | TOTALS
FOR PAYROLL USE ONLY
Input Date |  |  | Pay Date |  |  | Initials |  |  |  |  |  | Supervisor's Signature and Date |  |  |  |  |  |  |  |  | Employee Signature and Date
Please document stand-by hours, if applicable
 |  |  |  |  |  |  |  |  |  |  |  | Pre-Authorized