tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 728371d1618419122-need-to-format-date-time-and-calculate-duration-user-with-time
Sheet: single_user_report (53)

Username | [NAME] | Logout Time | Session Duration | Auth Result | Failure Reason | Session Compliance | Test Login Time | Logout
bbbser | Mon Apr 12 04:16:36 2021 | Mon Apr 12 07:04:01 2021 | 2h 47m 25s | Success |  | Compliant
bbbser | Sun Apr 11 23:04:13 2021 | Mon Apr 12 04:15:09 2021 | 5h 10m 56s | Success |  | Compliant
bbbser | Sun Apr 11 05:26:40 2021 | Sun Apr 11 07:05:42 2021 | 1h 39m 2s | Success |  | Compliant
bbbser | Sun Apr 11 03:22:05 2021 | Sun Apr 11 05:25:36 2021 | 2h 3m 31s | Success |  | Compliant
bbbser | Sun Apr 11 02:02:39 2021 | Sun Apr 11 03:21:15 2021 | 1h 18m 36s | Success |  | Compliant
bbbser | Sat Apr 10 22:28:37 2021 | Unknown | N/A | Success |  | Compliant
bbbser | Sat Apr 10 01:42:15 2021 | Sat Apr 10 07:02:49 2021 | 5h 20m 34s | Success |  | Compliant
bbbser | Fri Apr 09 22:55:49 2021 | Sat Apr 10 01:40:07 2021 | 2h 44m 18s | Success |  | Compliant
bbbser | Fri Apr 09 05:41:53 2021 | Fri Apr 09 07:09:43 2021 | 1h 27m 50s | Success |  | Compliant
bbbser | Fri Apr 09 02:30:55 2021 | Fri Apr 09 05:40:46 2021 | 3h 9m 51s | Success |  | Compliant
bbbser | Thu Apr 08 04:55:08 2021 | Thu Apr 08 07:04:55 2021 | 2h 9m 47s | Success |  | Compliant
bbbser | Thu Apr 08 02:30:16 2021 | Thu Apr 08 04:53:54 2021 | 2h 23m 38s | Success |  | Compliant
bbbser | Wed Apr 07 23:30:37 2021 | Thu Apr 08 02:28:48 2021 | 2h 58m 11s | Success |  | Compliant
bbbser | Wed Apr 07 22:49:51 2021 | Wed Apr 07 23:30:45 2021 | 40m 54s | Success |  | Compliant
bbbser | Mon Apr 05 01:16:37 2021 | Mon Apr 05 07:06:15 2021 | 5h 49m 38s | Success |  | Compliant
bbbser | Sun Apr 04 22:50:19 2021 | Mon Apr 05 01:13:51 2021 | 2h 23m 32s | Success |  | Compliant
bbbser | Fri Apr 02 03:06:44 2021 | Fri Apr 02 03:54:54 2021 | 48m 10s | Success |  | Compliant
bbbser | Fri Apr 02 02:47:08 2021 | Fri Apr 02 02:51:25 2021 | 4m 17s | Success |  | Compliant
bbbser | Thu Apr 01 14:17:51 2021 | Thu Apr 01 18:52:53 2021 | 4h 35m 2s | Success |  | Compliant
bbbser | Thu Apr 01 08:01:09 2021 | Thu Apr 01 14:16:51 2021 | 6h 15m 42s | Success |  | Compliant
bbbser | Thu Apr 01 07:56:56 2021 |  |  | Failure | Account LockedOut | Compliant
bbbser | Thu Apr 01 07:39:52 2021 |  |  | Failure | Account LockedOut | Compliant
bbbser | Thu Apr 01 05:06:04 2021 | Thu Apr 01 07:36:06 2021 | 2h 30m 2s | Success |  | Compliant
Spreadsheet: 233252d1367701537-found-opposite-of-pattern-of-xs-copy-of-book1-2
Sheet: Sheet1

Finds the closest opposite pattern of [NAME] from the list below: |  |  |  |  |  |  |  | binary:
 | x |  | x
Refer data |  |  |  |  |  |  |  | 16s | 9s | 4s | 2s | 1s | Binary
x |  |  |  | x |  |  |  |  |  |  |  |  |  |  | 1
 |  | x | x |  |  |  |  |  |  |  |  |  |  |  | 3
 | x |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
Spreadsheet: harry_arora__12146__Staffing Report 12-8-2000
Sheet: Laura

ENRON NET WORKS STAFFING REPORT
Name: | Staffers
Week: | December 8th - 31st
 |  |  | Total # | Total # | Total# |  | New | Total# | Total#
 |  |  | Openings | Add | Rep |  | This Wk | Add | Rep |  | Cancelled
Stock |  |  |  | 1 | 0 |  |  | 0 | 0 |  | 0
[NAME] |  |  |  | 5 | 0 |  |  | 1 | 0 |  | 0
[NAME] |  |  |  | 5 | 0 |  |  | 0 | 0 |  | 0
Burchfield |  |  |  | 7 | 3 |  |  | 4 | 2 |  | 3
Internet |  |  |  | 0 | 0 |  |  | 0 | 0 |  | 0
Hanz |  |  |  | 15 | 0 |  |  | 5 | 0 |  | 1
[NAME] |  |  |  | 0 | 0 |  |  | 0 | 0 |  | 0
Gubser |  |  |  | 1 | 0 |  |  | 0 | 0 |  | 0
McAuliffe |  |  |  | 7 | 4 |  |  | 5 | 0 |  | 2
Dziadek |  |  |  | 1 | 0 |  |  | 1 | 0 |  | 0
[NAME] |  |  |  | 3 | 0 |  |  | 0 | 2 |  | 1
Rub - Projects & Oversight |  |  |  | 0 | 0 |  |  | 0 | 0 |  | 0
Webb |  |  |  | 22 | 0 |  |  | 2 | 0 |  | 0
[NAME] |  |  |  | 7 | 0 |  |  | 0 | 0 |  | 4
Montagne |  |  |  | 5 | 0 |  |  | 3 | 0 |  | 0
Elrod |  |  |  | 10 | 0 |  |  | 20 | 0 |  | 0
Pavetto |  |  |  | 5 | 0 |  |  | 13 | 0 |  | 1
Garner |  |  |  | 2 | 0 |  |  | 2 | 0 |  | 0
[NAME] |  |  |  | 0 | 0 |  |  | 0 | 0 |  | 0
Forster |  |  |  | 0 | 1 |  |  | 0 | 0 |  | 0
Piper |  |  |  | 1 | 0 |  |  | 0 | 0 |  | 0
Kinneman |  |  |  | 0 | 0 |  |  | 0 | 0 |  | 0
Munk |  |  |  | 1 | 0 |  |  | 0 | 0 |  | 0
Hotte |  |  |  | 2 | 3 |  |  | 1 | 0 |  | 1
[NAME] |  |  |  | 6 | 0 |  |  | 1 | 0 |  | 0
Contractors Started this Week
source: | agencies |  |  |  |  |  | 24
 | Enron recruiters |  |  |  |  |  | 0
 | employee referrals |  |  |  |  |  | 0
Spreadsheet: 37e3f617-48c0-4444-aa33-16ffc15903d4
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
SURM | Test | SURM | Trimipramine (Surmontil) | Trimipramine (Surmontil) | Liquid Chromatography/Tandem Mass Spectrometry (LC/MS/MS) | Green-Top Tube (Sodium Heparin): GrnNaHp OR Plain, Red-Top Tube: Red OR |  |  | 2 | mL | Submit only 1 of the following specimens:  Plasma Draw blood in a green-top (sodium heparin) tube(s), plasma gel tube is not acceptable. Spin down and send 2 mL of sodium heparin plasma refrigerated in a plastic vial.   Serum Draw blood in a plain red-top tube(s), serum gel tube is not acceptable. Spin down and send 2 mL of serum refrigerated in a plastic vial. | 0.25 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | [NAME]: 50 - 300 ng/mL   Test Performed By:	Medtox Laboratories, Inc. 402 W. County Road D St. Paul, MN  55112 | Monday through Sunday | 3 days | 5 - 7 days | 1 | 82542 |  |  |  |  | Medtox Laboratories, Inc.
SURM | [NAME] | VARIES | Varies |  |  |  | Refrigerated | 7 days
SURM | Result | Z1126 | Trimipramine (Surmontil) | Trimipramine (Surmontil) | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: phillip_m_love__30654__9902_OA
Sheet: EAST-CON-VAR

ENRON CAPITAL & TRADE RESOURCES
OPERATIONAL ANALYSIS - VARIANCE
COMPANY:  ECTR (EGM) / LRC
REGION: EAST
 |  |  | Reported |  | Actuals |  | [NAME]
 |  |  | Volume | $'s | Volume | $'s | Volume | $'s
 | Sales:
1 |  | 3rd Party / Inter Enron
2 |  | Liquidations
3 |  | Interdesk
4 |  | Option Premiums
5 |  | Dmd Reimbursements
 | Total Sales:
 | Purchases:
6 |  | 3rd Party / Inter Enron
7 |  | Liquidations
8 |  | Interdesk
9 |  | Option Premiums
10 |  | [NAME]
 | Total Purchases:
 | Intra CTS (EGM / HPL / LRC):
11 |  | Sales
12 |  | Purchases
 | Total Intra CTS Sales / Purchases
 | Imbalances:
13 |  | In Kind
14 |  | Cash Out
15 |  | Cash In
16 |  | Synthetic Storage
 | Total Imbalances:
 | Storage:
17 |  | Injection (Sales to Stg)
18 |  | W/D (Purchase from Stg)
19 |  | Inventory Profit
 |  | Total W/D
 | Total Storage:
20 | Linepack:
21 | Shrinkage:
22 | UA4:
23 | Fuel:
 | Transport Expense:
24 |  | Commodity
25 |  | Demand
 | Total Transport Expense:
 | Transport Revenue:
26 |  | Interstate
27 |  | Intrastate
 | Total Transport Revenue:
 | Intra CTS (EGM / HPL / LRC):
28 |  | Transport Expense
29 |  | Transport Revenue
 | Total Intra CTS Transport
 | Tie Out Schedule Items:
 |  | MTM Income:
30 |  | Current Gross Book Balance
31 |  | Prior Month Book Balance
 |  | Total MTM Income
32 |  | Prudency
33 |  | Financial Liquidations
34 |  | Originations
35 |  | Broker Fees
36 |  | Asset Group Demand Charges
37 |  | [NAME]
38 |  | Interdesk Charges
39 |  | Canada
40 |  | Miscellaneous
 |  | TOTAL
FT-South East
 |  | Current Month MTM
 |  | Financial Liquidations
 |  | Originations
 |  | TOTAL FIRM TRADING
 |  | TOTAL GL
Spreadsheet: 218482d1362482919-using-dates-with-a-max-table-test
Sheet: Sheet1

 |  | Mon | Tue | Wed | Thur | Fri
 |  | 2013-03-04 00:00:00 | 2013-03-05 00:00:00 | 2013-03-06 00:00:00 | 2013-03-07 00:00:00 | 2013-03-08 00:00:00
1 - RV53B | Maximum Staff Requirement | 0 | 3 | 2 | 0 | 0
2 - RV74 | Maximum Staff Requirement | 0 | 2 | 2 | 1 | 0
3 - RV53 | Maximum Staff Requirement | 0 | 3 | 3 | 0 | 0
4 - RDKP72 | Maximum Staff Requirement | 0 | 2 | 2 | 0 | 1
5 - KIEFEL | Maximum Staff Requirement | 0 | 0 | 0 | 0 | 0
6 - RDKP72 | Maximum Staff Requirement | 0 | 2 | 0 | 3 | 0
7 - RDKP54 | Maximum Staff Requirement | 0 | 1 | 2 | 0 | 0
Spreadsheet: kate_symes__18080__5-31 Deal Summary
Sheet: EOL Deals

EOL Deals | From: 5/1/2000   To: 5/31/2000 |  |  | EnPower Deals | From: 5/1/2000   To: 5/31/2000
Desk | Total MWH | Total Deals |  | Desk | Total MWH | Total Deals
EPMI Long Term California | 3332800 | 153 |  | EPMI Long Term California | 3574674 | 225
EPMI Long Term Northwest | 1300800 | 55 |  | EPMI Long Term Northwest | 24095508 | 877
EPMI Long Term Southwest | 1789200 | 88 |  | EPMI Long Term Southwest | 16600609 | 577
EPMI Short Term California | 118400 | 106 |  | EPMI Long Term West Management | 1254001 | 44
EPMI Short Term Northwest | 154800 | 218 |  | EPMI Short Term California | 7298990 | 5499
EPMI Short Term Southwest | 358000 | 133 |  | EPMI Short Term Northwest | 2150269 | 1234
 |  |  |  | EPMI Short Term Southwest | 2322140 | 1304
Grand Total | 7054000 | 753 |  | EPMI Short Term West BOM | 8055 | 24
 |  |  |  | EPMI Short Term West Hourly | 137005 | 1274
EOL Deals | From: 5/31/2000   To: 5/31/2000
Desk | Total MWH | Total Deals |  | Grand Total | 57441251 | 11058
EPMI Long Term California | 337200 | 11 |  | EnPower Deals | From: 5/31/2000   To: 5/31/2000
EPMI Long Term Northwest | 214800 | 9 |  | Desk | Total MWH | Total Deals
EPMI Long Term Southwest | 542000 | 21
EPMI Short Term California | 1200 | 3 |  | EPMI Long Term California | 243600 | 8
EPMI Short Term Northwest | 12800 | 8 |  | EPMI Long Term Northwest | 2166176 | 44
EPMI Short Term Southwest | 23200 | 10 |  | EPMI Long Term Southwest | 505700 | 23
 |  |  |  | EPMI Short Term California | 587862 | 200
Grand Total | 1131200 | 62 |  | EPMI Short Term Northwest | 27262 | 49
 |  |  |  | EPMI Short Term Southwest | 131120 | 53
 |  |  |  | EPMI Short Term West BOM | 200 | 1
 |  |  |  | EPMI Short Term West Hourly | 2757 | 37
 |  |  |  | Grand Total | 3664677 | 415
Spreadsheet: darrell_schoolcraft__7287__saledoc03_14aTW
Sheet: Sheet1

Transwestern Pipeline Company
GAS [NAME]
 | GAS SALE INFORMATION |  |  |  |  | PURCHASE PARTY
Account Manager |  |  | [NAME] |  |  | Company: |  | Astra Power
Deal Date: |  |  | 2002-03-13 00:00:00 |  |  | Contact Name: |  | [NAME]
Gas Sale Date (s) |  |  | 3/14/2002 |  |  | FAX Number:
Total Quantity |  |  | 20000 | MMBtu |  | Address: |  | Phone: [PHONE]
Gas Sale Price |  |  | 2.755
GAS SALE TERMS
 |  | Contract Quantity (MMBtu)
SALE DATES |  |  |  | Daily
Start | End | Monthly |  | Min |  | [NAME] |  | Other
3/14/2002 | 2002-03-14 00:00:00 | 20000 |  | 20000 |  | 51052
RELATED SCHEDULING AND TRANSPORTATION REQUIREMENTS
Tranwestern Receipt/Delivery Point |  |  |  |  |  |  | DOWNSTREAM |  | TW UPSTREAM
Name |  |  | POI # |  | Daily Volume |  | Contract # |  | Contract Number
West Texas Pool |  |  | 58649 |  | 20000 |  |  |  | 22948
 |  |  | BILLING BY THIRD PARTY |  |  |  |  | Please direct all invoices to:
 |  |  | Month [NAME] Rec'd |  | Expected [NAME] |  |  | Debbie Mosely
 |  |  |  |  | To be determined |  |  | Transwestern Pipeline Company
 |  |  |  |  |  |  |  | P.O. Box 1188
 |  |  |  |  |  |  |  | Houston, TX  77251-1188
Comments:
Buyer: Please acknlowledge confirmation of the above deal by signing below and faxing this confirmation to:
[NAME] [PHONE]   Phone [PHONE]
Gas Buyer Signature |  |  |  |  |  |  | Date:
TW Acct Manager Signature |  |  |  |  |  |  | Date:
Spreadsheet: 876630d1723360629-how-to-link-or-import-data-between-two-excel-workbooks-with-very-different-formats-daily-sheets
Sheet: 06.24.24

 | AM SHIFT REPORT
 |  |  |  | 2024-06-24 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 | 3 | 0 | 1 | 0 | 0 | 0 | 1 | 1 | 0
 | 4TH FL | 38 | 22 | 18 | 0 | 4 | 0 | 1 | 0 | 0 | 2 | 0
 | 5TH FL | 34 | 20 | 16 | 0 | 4 | 1 | 0 | 0 | 0 | 2 | 0
 | ABC | 27 | 18 | 21 | 0 | 5 | 1 | 0 | 0 | 0 | 3 | 0
 | MNO | 12 | 6 | 5 | 0 | 3 | 1 | 1 | 0 | 1 | 1 | 0
 | Total MED
 | JKL | 26 | 4 | 5 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0
 | DEF | 10 | 4 | 5 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
 | GHI | N/A | N/A | 1 | 0 | 3 | 0 | 0 | 0 | 0 | 1 | 0
 | Total MAT
 | Total Holds AM | N/A | N/A | 0 | 0 | 4 | 0 | 0 | 1 | 1 | 2 | 0
 | Total Holds MID |  |  | 0 | 0 | 4 | 1 | 0 | 0 | 0 | 1 | 0
 | Total House Census
 | PM SHIFT REPORT
 |  |  |  | 2024-06-24 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 | 5 | 0 | 1 | 1 | 0 | 0 | 0 | 1 | 0
 | 4TH FL | 38 | 22 | 21 | 0 | 4 | 0 | 1 | 0 | 0 | 2 | 0
 | 5TH FL | 34 | 20 | 17 | 0 | 4 | 0 | 3 | 0 | 0 | 1 | 0
 | ABC | 27 | 18 | 18 | 0 | 5 | 2 | 1 | 0 | 0 | 1 | 0
 | MNO | 12 | 6 | 4 | 0 | 3 | 0 | 1 | 0 | 0 | 1 | 0
 | Total MED
 | JKL | 26 | 4 | 6 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
 | DEF | 10 | 4 | 4 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0
 | GHI | N/A | N/A | 0 | 0 | 3 | 2 | 0 | 0 | 0 | 1 | 0
 | Total MAT
 | Total Holds PM | N/A | N/A | 0 | 0 | 6 | 2 | 0 | 0 | 0 | 1 | 0
 | Total House Census
Spreadsheet: 110696d1307324643-excel-2007-if-formula-sample-workbook
Sheet: Sheet1

Commission Schedule
200 | 3
200 | $3 + $0.015
Buy | Sell | Total
# of Shares | # of Shares | Total Commission
200 | 10
150 | 20
201 | 50
 | 100
 | 150
 | 200
 | 201
 | 202
 | 203
 | 300
 | 400
 | 1000
Spreadsheet: 713200d1610590474-sumproduct-with-2-criteria-from-date-and-specific-text-sumproduct_text_with_date_text
Sheet: Sheet1

 | TABLE 1: DATA SOURCE |  |  |  |  |  |  |  |  |  |  |  | TABLE 2: DATA PREP
 | No | Dates | Day | EMP1 | EMP2 | EMP3 | EMP4 | EMP5 | EMP6 | EMP7 | [NAME] |  | Month | EMP1 | EMP2 | EMP3 | EMP4 | EMP5 | EMP6 | EMP7 | [NAME]
 | 1 | 2021-01-13 00:00:00 |  |  |  |  | 1 | 1 |  |  |  |  | Jan
 | 2 | 2021-01-14 00:00:00 |  |  |  |  | 1 |  |  |  |  |  | Feb
 | 3 | 2021-01-15 00:00:00 |  |  |  |  |  | 1 |  |  |  |  | Mar
 | 4 | 2021-01-16 00:00:00 |  |  |  |  |  |  |  |  |  |  | Apr
 | 5 | 2021-01-17 00:00:00 |  |  |  |  |  |  |  |  |  |  | May
 | 6 | 2021-01-18 00:00:00 |  |  |  |  | 1 |  |  |  |  |  | Jun
 | 7 | 2021-01-19 00:00:00 |  |  |  |  |  | 1 |  |  |  |  | Jul
 | 8 | 2021-01-20 00:00:00 |  |  |  |  | 1 |  |  |  |  |  | Aug
 | 9 | 2021-01-21 00:00:00 |  |  |  |  |  | 1 |  |  |  |  | Sep
 | 10 | 2021-01-22 00:00:00 |  |  |  |  | 1 |  |  |  |  |  | Oct
 | 11 | 2021-01-23 00:00:00 |  |  |  |  |  |  |  |  |  |  | Nov
 | 12 | 2021-01-24 00:00:00 |  |  |  |  |  |  |  |  |  |  | Dec
 | 13 | 2021-01-25 00:00:00 |  |  |  |  |  | 1 |  |  |  |  | TOTAL
 | 14 | 2021-01-26 00:00:00 |  |  |  |  | 1
 | 15 | 2021-01-27 00:00:00 |  |  |  |  |  | 1
 | 16 | 2021-01-28 00:00:00
 | 17 | 2021-01-29 00:00:00 |  |  |  |  | 1
 | 18 | 2021-01-30 00:00:00
 | 19 | 2021-01-31 00:00:00
 | 20 | 2021-02-01 00:00:00 |  |  |  |  | 1
 | 21 | 2021-02-02 00:00:00 |  |  |  |  |  | 1
 | 22 | 2021-02-03 00:00:00 |  |  |  |  | 1
 | 23 | 2021-02-04 00:00:00 |  |  |  |  |  | 1
 | 24 | 2021-02-05 00:00:00 |  |  |  |  | 1
 | 25 | 2021-02-06 00:00:00
 | 26 | 2021-02-07 00:00:00
 | 27 | 2021-02-08 00:00:00 |  |  |  |  |  | 1
 | 28 | 2021-02-09 00:00:00 |  |  |  |  | 1
 | 29 | 2021-02-10 00:00:00 |  |  |  |  |  | 1
 | 30 | 2021-02-11 00:00:00
 | 31 | 2021-02-12 00:00:00
 | 32 | 2021-02-13 00:00:00
Spreadsheet: 869668d1716280481-required-multilevel-sequence-serial-numbers-book1-new
Sheet: Sheet2

 | Area-1 | Topic-1
 | Area-1 | Topic-2 |  |  | Area-2
 | Area-1 | Topic-3 |  |  | Area-3
 | Area-1 | Topic-4
 | Area-1 | Topic-5
 | Area-1 | Topic-6
 | Area-1 | Topic-7
 | Area-1 | Topic-8
 | Area-1 | Topic-9
 | Area-1 | Topic-10
 | Area-2 | Topic-A
 | Area-2 | Topic-B
 | Area-2 | Topic-C
 | Area-2 | Topic-D
 | Area-2 | Topic-E
 | Area-2 | Topic-F
 | Area-3 | Topic-X1
 | Area-3 | Topic-X2
 | Area-3 | Topic-X3
 | Area-3 | Topic-X4
 | Area-3 | Topic-X5
 | Area-3 | Topic-X6
 | Area-3 | Topic-X7
 | Area-3 | Topic-X8
 | Area-3 | Topic-X9
 | Area-3 | Topic-X10
 | Area-3 | Topic-X11
 | Area-3 | Topic-X12
 | Area-3 | Topic-X13
 | Area-3 | Topic-X14
Spreadsheet: 74956d1275491441-vlookup-for-a-range-vlookup
Sheet: Sheet1

VALUE | RESULT |  | TABLE
29 | "Between -30 and -40" |  | 40 | "Between 30 and 40"
-4 | "Between -30 and -40" |  | 30 | "Between 20 and 30"
30 | "Between -30 and -40" |  | 20 | "Between 10 and 20"
10 | "Between -30 and -40" |  | 10 | "Between 0 and 10"
13 | "Between -30 and -40" |  | 0 | "No change"
-24 | #N/A |  | -10 | "Between 0 and -10"
9 | "Between -30 and -40" |  | -20 | "Between -10 and -20"
-39 | "Between -30 and -40" |  | -30 | "Between -20 and -30"
-26 | "Between -30 and -40" |  | -40 | "Between -30 and -40"
18 | #N/A
-24 | #N/A
35 | #N/A
28 | #N/A
13 | #N/A
-39 | #N/A
16 | #N/A
14 | #N/A
1 | #N/A
32 | #N/A
23 | #N/A
40 | #N/A
-7 | #N/A
-22 | #N/A
22 | #N/A
-25 | #N/A
36 | #N/A
23 | #N/A
2 | #N/A
-39 | #N/A
24 | #N/A
-28 | #N/A
12 | #N/A
-3 | #N/A
-35 | #N/A
-15 | #N/A
-34 | #N/A
5 | #N/A
Spreadsheet: 880264d1727887026-rolling-count-of-all-the-overlapping-days-for-multiple-date-ranges-new-example
Sheet: Sheet2

Range# (A) | Start Date (B) | End Date (C) | Expected count (D) | Explination (E) | Current Duration (F) | ED - 30 days | SD List | Amended SD List | ED List | COUNT | SUM | With LET | windknife
1 | 2024-06-01 00:00:00 | 2024-06-03 00:00:00 | 2
2 | 2024-06-04 00:00:00 | 2024-06-10 00:00:00 | 8 | 6 + 2 |  |  |  |  |  |  |  |  | 8
3 | 2024-06-22 00:00:00 | 2024-06-29 00:00:00 | 15 | 7 + 6 + 2 |  |  |  |  |  |  |  |  | 15
4 | 2024-07-05 00:00:00 | 2024-07-15 00:00:00 | 17 | 10 + 7 |  |  |  |  |  |  |  |  | 17
5 | 2024-07-16 00:00:00 | 2024-07-25 00:00:00 | 23 | 9 + 10 + 4 |  |  |  |  |  |  |  |  | 23
6 | 2024-07-28 00:00:00 | 2024-08-05 00:00:00 | 27 | 8 + 9 + 10 |  |  | 2024-07-05 00:00:00 | 2024-07-05 00:00:00 | 2024-07-15 00:00:00 | 10 |  |  | 26
7 | 2024-08-20 00:00:00 | 2024-08-23 00:00:00 | 13 | 3 + 8 + 2 |  |  | 2024-07-16 00:00:00 | 2024-07-16 00:00:00 | 2024-07-25 00:00:00 | 9 |  |  | 12
Spreadsheet: 118069d1313421349-best-way-to-represent-this-data-move-stats-by-shift
Sheet: by week

Shift Move Stats | Tool
Week & Shift | T2 | Total
Week 27
A
Day 1 | 357 | 357
Day 2 | 565 | 565
Day 3 | 65 | 65
Day 4 | 200 | 200
A Total | 1187 | 1187
B
Day 1 | 442 | 442
Day 2 | 307 | 307
Day 3 | 183 | 183
B Total | 932 | 932
C
Day 1 | 211 | 211
Day 2 | 359 | 359
Day 3 | 92 | 92
Day 4 | 79 | 79
C Total | 741 | 741
D
Day 1 | 295 | 295
Day 2 | 23 | 23
Day 3 | 291 | 291
D Total | 609 | 609
Week 27 Total | 3469 | 3469
Week 28
A
Day 1 | 75 | 75
Day 2 | 558 | 558
Day 3 | 355 | 355 |  |  |  |  | when you want to look at the graph will likely want to put day in middle and shift at bottom in the axis fields
Day 4 | 560 | 560 |  |  |  |  | when you want to look at the table will likely want to put shift in middle and day at bottom in the axis fields
A Total | 1548 | 1548
B
Day 1 | 74 | 74
Day 2 | 372 | 372
Day 3 | 525 | 525
B Total | 971 | 971
C
Day 1 | 50 | 50
Day 2 | 499 | 499
Day 3 | 168 | 168
Day 4 | 39 | 39
C Total | 756 | 756
D
Day 1 | 97 | 97
Day 2 | 149 | 149
Day 3 | 475 | 475
D Total | 721 | 721
Week 28 Total | 3996 | 3996
Total | 7465 | 7465
Spreadsheet: 218804d1362585279-football-league-table-database
Sheet: Sumário - Tabela 2-3-1-1-1-1-1-

Jornada | 11
Arsenal | 3 | 3 | Fulham
Everton | 2 | 1 | Sunderland
Reading | 0 | 0 | Norwich City
Southampton | 1 | 1 | Swansea City
Stoke City | 1 | 0 | Queen Parks Rangers
Wigan Athletic | 1 | 2 | West Bromwich Albion
[NAME] | 2 | 3 | [NAME]
Manchester City | 2 | 1 | [NAME]
Newcastle United | 0 | 1 | West Ham United
Chelsea | 1 | 1 | Liverpool
Spreadsheet: 197895d1354600613-remove-to-a-new-sheet-duplicate-rows-spuros
Sheet: Master 2 

date | demo | [NAME] | contract | comments | [NAME] | demo4 | demo5 | demo6 | demo7 | demo8 | demo9 | demo10
2012-12-01 00:00:00 | [NAME] | [NAME] | 121 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
2012-12-03 00:00:00 | [NAME] | [NAME] | 125 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
2012-12-04 00:00:00 | [NAME] | [NAME] | 128 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
2012-12-06 00:00:00 | [NAME] | [NAME] | 130 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
2012-12-08 00:00:00 | [NAME] | [NAME] | 139 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
2012-12-09 00:00:00 | [NAME] | [NAME] | 147 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
2012-12-11 00:00:00 | [NAME] | [NAME] | 220 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
2012-12-12 00:00:00 | [NAME] | [NAME] | 225 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
2012-12-13 00:00:00 | [NAME] | [NAME] | 226 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
2012-12-14 00:00:00 | [NAME] | [NAME] | 289 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
2012-12-15 00:00:00 | [NAME] | [NAME] | 299 | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
Spreadsheet: 811211d1672348417-solved-replace-colon-with-decimal-excel-sample-data
Sheet: Sheet1

2UPac | 2UPac Dbl Time | 2UPac Overtime | 3UPac | 3UPac Overtime | Bereavement | Double Time | Holiday | Jury | Old Shift 3U OT | Overtime | PTO | Regular | Regular Salary | Salary
00:00 | 00:00 | 00:00 | 00:00 | 00:00 | 00:00 | 00:00 | 00:00 | 00:00 | 00:00 | 16:00 | 00:00 | 46:00 | 00:00 | 00:00
00:00 | 00:00 | 00:00 | 00:00 | 00:00 | 00:00 | 00:00 | 00:00 | 00:00 | 00:00 | 00:00 | 00:00 | 16:00 | 00:00 | 00:00
00:00 | 00:00 | 00:00 | 00:00 | 00:00 | 00:00 | 00:00 | 00:00 | 00:00 | #[NAME]! | 8:00 | 00:00 | 70:00 | 00:00 | 00:00
00:00 | 00:00 | 00:00 | 00:00 | 00:00 | 00:00 | 00:00 | 00:00 | 00:00 | 00:00 | 8:00 | 00:00 | 38:00 | 00:00 | 00:00 |  |  | This is data exported with hours worked. I am hoping to replace the colon with a decimal.                                                                                                                                     For example: I would like to see [NAME] as 46 hours and M7 as 146.15 and any with 00:00 as 0.
00:00 | 00:00 | 00:00 | 00:00 | 00:00 | 00:00 | 00:00 | 24:00 | 00:00 | 00:00 | 40:00 | 00:00 | 280:00 | 00:00 | 00:00
00:00 | 00:00 | 00:00 | 00:00 | 00:00 | 00:00 | 00:00 | 00:00 | 00:00 | 00:00 | 8:00 | 00:00 | 146:15 | 00:00 | 00:00
00:00 | 00:00 | 00:00 | 00:00 | 00:00 | 8:00 | 00:00 | 48:00 | 00:00 | 00:00 | 64:00 | 00:00 | 583:30 | 00:00 | 00:00
00:00 | 00:00 | 00:00 | 00:00 | 00:00 | 00:00 | 00:00 | 00:00 | 00:00 | 00:00 | 12:00 | 00:00 | 76:30 | 00:00 | 00:00
00:00 | 00:00 | 00:00 | 00:00 | 00:00 | 00:00 | 00:00 | 00:00 | 00:00 | 00:00 | 31:30 | 00:00 | 160:00 | 00:00 | 00:00
00:00 | 00:00 | 00:00 | 00:00 | 00:00 | 00:00 | 00:00 | 40:00 | 00:00 | 00:00 | 91:15 | 192:00 | 537:30 | 00:00 | 00:00 |  |  | Regular | Regular Salary |  | Regular | Regular Salary
00:00 | 00:00 | 00:00 | 00:00 | 00:00 | 00:00 | 00:00 | 16:00 | 00:00 | 00:00 | 00:00 | 00:00 | 00:00 | 00:00 | 00:00 |  |  | 46:00 | 00:00 |  | 46 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 16:00 | 00:00 |  | 16 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 70:00 | 00:00 |  | 70 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 38:00 | 00:00 |  | 38 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 280:00 | 00:00 |  | 280 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 146:15 | 00:00 |  | 146.15 | 0