tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 328512d1403925094-overtime-over-40-hours-timesheet
Sheet: Sheet1

 |  |  |  |  | Weekly Time Record
Western Jet Aviation, Inc.
Employee:
Period Beginning: | 2014-06-16 00:00:00 |  |  | Period Ending: | 2014-07-01 00:00:00
Day | In | Out | In | Out | Regular Hrs. | [NAME]. | [NAME]. | Vacation Hrs. | Holiday Hrs.
2014-06-16 00:00:00 | 07:30:00 | 11:30:00 | 12:00:00 | 16:00:00 | 8 | 0.00
2014-06-17 00:00:00 | 07:30:00 | 11:30:00 | 12:00:00 | 16:00:00 | 8 | 0.00
2014-06-18 00:00:00 | 07:30:00 | 11:30:00 | 12:00:00 | 18:00:00 | 8 | 0.00
2014-06-19 00:00:00 | 07:00:00 | 11:30:00 | 12:00:00 | 16:00:00 | 8 | 0.00
2014-06-20 00:00:00 | 07:00:00 | 11:30:00 | 12:00:00 | 16:00:00 | 8 | 0.00
2014-06-21 00:00:00 | 08:00:00 |  |  | 11:00:00 | 3 | 3
2014-06-22 00:00:00 |  |  |  |  | 0 | 0
2014-06-23 00:00:00 | 07:30:00 | 11:30:00 | 12:00:00 | 16:00:00 | 8 | 0.00
2014-06-24 00:00:00 | 07:30:00 | 11:30:00 | 12:00:00 | 16:00:00 | 8 | 0.00
2014-06-25 00:00:00 | 07:30:00 | 11:30:00 | 12:00:00 | 16:30:00 | 8 | 0.00
2014-06-26 00:00:00 | 07:00:00 | 11:30:00 | 12:00:00 | 16:00:00 | 8 | 0.00
2014-06-27 00:00:00 | 07:30:00 | 11:30:00 | 12:00:00 | 16:00:00 | 8 | 0.00
2014-06-28 00:00:00 |  |  |  |  | 0 | 0.00
2014-06-29 00:00:00 |  |  |  |  | 0 | 0.00
2014-06-30 00:00:00 | 07:30:00 | 13:00:00 | 13:30:00 | 16:00:00 | 7.999999999999998 | 0
2014-07-01 00:00:00 |  |  |  |  | 0 | 0
 |  |  | Column Totals |  | 88 | 3 | 0 | 0 | 0
 |  |  | Total Hours. |  | 91
Spreadsheet: 02620ebc-2b95-4511-8895-502854a3370d
Sheet: Sheet1

2014 ITF SCOTLAND - NATIONAL CHAMPIONSHIPS | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16 | Unnamed: 17 | Unnamed: 18
RAVENSCRAIG REGIONAL SPORTS FACITLITY, O'DONNELL WAY, MOTHERWELL, ML1 1 AD
 | School: | GMAC |  |  |  | Instructor: |  |  |  | Degree:
 | ITF Plaque No: |  |  |  |  | Contact No: |  |  |  | email:
 | Address:
Competitor's Top Sheet
All Parts must be complete
 |  |  |  |  |  |  |  |  |  |  | PLEAESE CROSS THE APPROPRIATE EVENTS |  |  |  | * Insert Team Name next to competitor for Pre-Arranged Sparring
No | FORENAME |  | SURNAME |  | D/O/B | Sex (M/F) | Height (cms) | Weight (kgs) | Age Group | Grade | Pattern | Sparring | [NAME] | Power Test | Pre-Arranged* | EVENT FEE | Licence Number | [NAME]
 |  |  |  |  |  | Male |  |  | 7yrs & under | White |  |  |  |  |  | 0
 |  |  |  |  |  | Female |  |  | 8 - 10 yrs | Yellow |  |  |  |  |  | 20
 |  |  |  |  |  |  |  |  | 11 - 13 yrs | Green
 |  |  |  |  |  |  |  |  | 14 - 17 yrs | Blue
 |  |  |  |  |  |  |  |  | 18 - 35 yrs | Red
 |  |  |  |  |  |  |  |  | 36yrs & over | 1st [NAME]
 |  |  |  |  |  |  |  |  |  | 2nd [NAME]
 |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  | [NAME]
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
Payment method: |  |  | Cheque |  |  | BACS |  | Date Sent |  | Received |  |  | TOTAL COST |  |  | 0
All entries should be sent to [EMAIL] on or before the closing date of 1st April 2014.  All payments should be made via BACS to account; International Taekwon-Do Federation (Scotland) Limited, No. 43740861, SC. 09-01-28
Please note entries will not be allocated to the draw until payment has been confirmed.  No cash payments on the day of tournament.  All entries after the closing date will include a penalty.
Spreadsheet: 147457d1332800798-comparing-dates-from-multiple-cells-comparing-dates
Sheet: Formula

ID | Name | Start | End | [NAME] | Reference
123 | [NAME] | 2012-01-01 00:00:00 | 2012-03-01 00:00:00 |  | 123
123 | [NAME] | 2012-03-01 00:00:00 | Open |  | 123
123 | [NAME] | 2012-04-01 00:00:00 | 2012-05-01 00:00:00 |  | 123
456 | Angus | 2012-03-01 00:00:00 | Open |  | 456
Spreadsheet: 299077d1392996776-calculate-number-of-days-between-invoice-date-and-todays-date-help-with-excel
Sheet: Sheet1

Invoice Received Date | Date Paid | Date bill needs to be payed | Number of days [NAME] needs to be paid | [NAME]
2014-01-08 00:00:00 | 2014-01-30 00:00:00
2014-01-13 00:00:00 | 2014-01-30 00:00:00
2014-01-10 00:00:00 | 2014-01-24 00:00:00
2014-01-12 00:00:00 | 2013-02-11 00:00:00
2014-01-15 00:00:00 | 2014-02-11 00:00:00
2014-01-15 00:00:00 | 2014-02-11 00:00:00
2014-01-20 00:00:00 | 2014-02-11 00:00:00
2014-01-22 00:00:00 | 2014-02-11 00:00:00
2014-01-29 00:00:00
2014-01-23 00:00:00 | 2014-02-19 00:00:00
2014-01-22 00:00:00
2014-01-23 00:00:00 | 2014-02-11 00:00:00
2014-01-24 00:00:00
2014-01-24 00:00:00 | 2014-02-11 00:00:00
2014-01-24 00:00:00
2014-01-24 00:00:00
2014-01-29 00:00:00 | 2014-02-19 00:00:00
2014-01-29 00:00:00
2014-01-29 00:00:00
2014-01-29 00:00:00
2014-01-30 00:00:00
2014-02-10 00:00:00
2014-02-20 00:00:00
2014-02-13 00:00:00
2014-02-13 00:00:00
2014-02-13 00:00:00
2014-02-19 00:00:00
2014-02-18 00:00:00
Spreadsheet: 213520d1360553167-date-range-to-calendar-holidaycalendarsol4
Sheet: ThirdSolution

1900-01-01 00:00:00 | Holiday Sheet
1900-02-01 00:00:00 | Year | 2013-01-01 00:00:00
1900-03-01 00:00:00 | Month | 1900-07-01 00:00:00
1900-04-01 00:00:00 |  | dd/mm/yyyy-dd/mm/yyyy | <---MUST be in 1or2 character day (ie- 1/01 for jan)/1or2haracter month (ie-1/01 for the first)/2or4 character year (2013, or 13) followed by (an optional space(" ")), a(required) dash("-"),(an optional space(" ")), then  1or2 character day (ie- 1/01 for [NAME] character month(ie-1/01 for the Jan)/2or4 character year (2013, or 13)
1900-05-01 00:00:00 | Name | Dates Off | Start | End | Type
1900-06-01 00:00:00 | Person 1 | 9/5/2013 - 17/5/13 |  |  | PTO
1900-07-01 00:00:00 | Person 2 | 28/08/2013 - 30/08/2013 |  |  | PTO
1900-08-01 00:00:00 | Person 3 | 11/09/2013 - 13/09/2013 |  |  | PTO
1900-09-01 00:00:00 | Person 4 | 11/07/2013 - 12/07/2013 |  |  | PTO
1900-10-01 00:00:00 | Person 5
1900-11-01 00:00:00 | Person 6
1900-12-01 00:00:00 | Person 7
 | Person 8
2000-01-01 00:00:00 | Person 9
2001-01-01 00:00:00 | Person 10
2002-01-01 00:00:00 | Person 11
2003-01-01 00:00:00 | Person 12
2004-01-01 00:00:00 | Person 13
2005-01-01 00:00:00 | Person 14
2006-01-01 00:00:00 | Person 15
2007-01-01 00:00:00
2008-01-01 00:00:00
2009-01-01 00:00:00
2010-01-01 00:00:00
2011-01-01 00:00:00
2012-01-01 00:00:00
2013-01-01 00:00:00
2014-01-01 00:00:00
2015-01-01 00:00:00
2016-01-01 00:00:00
2017-01-01 00:00:00
2018-01-01 00:00:00
2019-01-01 00:00:00
Spreadsheet: 39036d1237249138-taking-information-from-a-database-summarybycategorykey
Sheet: Category1

Company | Category | Subcategory | Date | Cost | Budget |  | Category | 1 | Just change these first two numbers to cause the summary to
[NAME]. | 1 | 2 | 2000-01-04 00:00:00 | 100 | 110 |  | Subcategory | 2 | reassert new data. There are no arrays in this setup so it will scale up cleanly.
[NAME]'s Parts | 1 | 2 | 2000-01-18 00:00:00 | 200 | 175 |  | Entries | 2
 |  |  |  |  |  |  | Key | 1-2
 |  |  | Total | 300 | 285
Spreadsheet: darron_c_giron__7957__midland_cogen
Sheet: firm9704

ENRON CAPITAL & TRADE RESOURCES
NETBACK AND FIRM CALCULATIONS
APRIL 1997
IFGMR (TRKL/TX) |  |  | 1.73 |  |  | No. of Days: | 30
IFGMR (TRKL/LA) |  |  | 1.76
IFGMR (PEPL/TX/OK) |  |  | 1.71
IFGMR (ANR/LA) |  |  | 1.75
IFGMR (HENRY HUB) |  |  | 1.85
MIDLAND COGENERATION VENTURES
CONTRACT #16-60548-302 (Ultramar)
FIXED CONTRACT: | YEAR | PRICE | YEAR | PRICE
 | 1992 | 2.52 | 2001 | 3.93
 | 1993 | 2.4 | 2002 | 4.23
 | 1994 | 2.51 | 2003 | 4.73
 | 1995 | 2.61 | 2004 | 5.07
 | 1996 | 2.53 | 2005 | 5.43
 | 1997 | 2.65 | 2006 | 5.82 | JAN-SEP
 | 1998 | 2.67 | 2006 | 5.95 | OCT-DEC
 | 1999 | 2.9 | 2007 | 6.37
 | 2000 | 3.33
TERM: Through year 2004 ([NAME])  with annual renewal thereafter.
MaxDQ: 8500 MMBtu/DAY
MinDQ: 60% OF MaxDQ F7,000 MMBtu/DAY | DQ for December, January, and February, 80% of MaxDQ for all other months.
MIDLAND COGENERATION VENTURES
CONTRACT #016-60548-305 (Union Pacific)
PEPL VOLUME |  |  |  | BASIS DIFFERENTIAL
CONTRACT PRICE |  | 2.45 |  | IFGMR (HENRY HUB)
LESS BASIS DIFF |  |  |  | LESS IFGMR(PEPL-TX/OK)
FINAL SALES PRICE |  |  |  | BASIS DIFFERENTIAL
TERM: JUNE 1, 1996 THROUGH SEPTEMBER 30, 2006
DESIGNATED QUANTITY -PEPL |  | 5000 | MMBTU/D
ANR VOLUME |  |  |  | BASIS DIFFERENTIAL
CONTRACT PRICE |  | 2.45 |  | IFGMR (HENRY HUB)
LESS BASIS DIFF |  |  |  | LESS IFGMR (ANR/LA)
FINAL SALES PRICE |  |  |  | BASIS DIFFERENTIAL
TERM: JUNE 1, 1996 THROUGH SEPTEMBER 30, 2006
[NAME] -ANR |  | 4000 | MMBTU/D
TRKL/ LA-TRKL/TX AVG  VOLUME |  |  |  | BASIS DIFFERENTIAL
CONTRACT PRICE |  | 2.45 |  | IFGMR (HENRY HUB)
LESS BASIS DIFF |  |  |  | LESS AVG IFGMR (TRKL/LA)/IFGMR(TRKL/TX)
FINAL SALES PRICE |  |  |  | BASIS DIFFERENTIAL
DESIGNATED TRKL TOTAL |  | 6000 | MMBTU/D
*Customer prefers rounding to nearest penny.
Spreadsheet: 872349d1718735926-populate-in-to-a-calendar-data-from-multiple-customers-and-products-bogus-data-test-forecast
Sheet: Forecast

 |  | May | June | July | August | September | October
Customer1 | Item 1A |  |  |  |  | 5000
Customer1 | Item 2A |  |  |  |  | 10000
Customer1 | Item 3A |  |  |  |  | 2000
Customer1 | Item 4A |  |  |  |  | 25000
Customer1 | Item 5A |  |  |  |  | 7
Customer2 | Item 1B |  |  |  | 14
Customer2 | Item 2B |  |  |  | 10000
Customer2 | Item 3B |  |  |  | 750 | 750
Customer2 | Item 4B |  |  |  | 85000
Customer2 | Item 5B |  |  |  | 9
Spreadsheet: 729093d1618911151-sorting-with-text-sorttext
Sheet: Sheet1

Code | Check-in Date
HANZ1 | 2022-11-01 00:00:00
HANZ10 | 2023-03-21 00:00:00
HANZ11 | 2023-03-28 00:00:00
HANZ12 | 2023-04-11 00:00:00
HANZ13 | 2023-05-16 00:00:00
HANZ2 | 2022-11-15 00:00:00
HANZ3 | 2022-11-22 00:00:00
HANZ4 | 2022-11-29 00:00:00
HANZ5 | 2023-02-14 00:00:00
HANZ6 | 2023-02-21 00:00:00
HANZ7 | 2023-02-28 00:00:00
HANZ8 | 2023-03-07 00:00:00
[NAME] | 2023-03-14 00:00:00
How can I sort as
HANZ1
HANZ2
HANZ3
HANZ4
Spreadsheet: a831b9c3-d0e7-4f42-a064-d89a55df9e8c
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
7503 | 55383 | Alejandro Edmundo | Ulfeldt | ARG | 0 | 00:34:52 | 00:02:40 | 01:17:58 | 00:02:23 | 01:04:40 | 1 | 03:02:34
7503 | 5927 | [NAME] | Delpodio | ARG | 0 | [NAME] | 00:02:54 | 01:19:09 | 00:04:21 | 01:06:17 | 2 | 03:04:20
7503 | 55382 | [NAME] | Giraldi | ARG | 0 | 00:39:22 | 00:02:02 | 01:29:48 | 00:03:15 | 01:05:38 | 3 | 03:20:07
Spreadsheet: craig_dean__4381__MDEA P&L Report
Sheet: May1

Profit Sharing Summary
Operation Day: |  | 2001-05-01 00:00:00
 |  |  |  | Gen Cost Reference |  |  | Gross Savings |  | Net Share of Savings (Per Agreement) |  |  |  | Costs by each party |  |  |  |  | Net Profit/Savings Summary
 |  |  |  |  |  |  | MDEA Gross Savings | MDEA Gross Savings | EPMI Share | MDEA Share | EPMI Share | MDEA Share | Per Mwh |  | Cost * Mwh
 |  |  |  | Day-Ahead | Day-Ahead | Day-Ahead Gen | (BEFORE EPMI Share) | (BEFORE EPMI Share) | 40% Pk,$1 OffPk | 60% Share Pk* | 40% Share Pk | 60% Share Pk |  |  |  | (EPMI to bill MDEA) |  | EPMI | MDEA
Date | Hour | Qty | Delivered Market Price | Gas Cdale | Gas Yazoo City | Gen Cost | [NAME] vs. [NAME] (per Mwh) | Per Mwh Savings * Mwhs | Per Mwh | Per Mwh | Per Mwh Savings * Mwhs | Per Mwh Savings * Mwhs | EPMI | MDEA | EPMI | MDEA |  | (Profit) | (Savings)
2001-05-01 00:00:00 | 1 | 15 | 22 | 5.01 | 5.25 | 65.2
2001-05-01 00:00:00 | 2 | 12 | 22 | 5.01 | 5.25 | 65.2
2001-05-01 00:00:00 | 3 | 12 | 22 | 5.01 | 5.25 | 65.2
2001-05-01 00:00:00 | 4 | 12 | 22 | 5.01 | 5.25 | 65.2
2001-05-01 00:00:00 | 5 | 13 | 22 | 5.01 | 5.25 | 65.2
2001-05-01 00:00:00 | 6 | 16 | 22 | 5.01 | 5.25 | 65.2
2001-05-01 00:00:00 | 7 | 0 | 0 | 5.01 | 5.25 | 65.2
2001-05-01 00:00:00 | 8 | 0 | 0 | 5.01 | 5.25 | 65.2
2001-05-01 00:00:00 | 9 | 0 | 0 | 5.01 | 5.25 | 65.2
2001-05-01 00:00:00 | 10 | 0 | 0 | 5.01 | 5.25 | 65.2
2001-05-01 00:00:00 | 11 | 0 | 0 | 5.01 | 5.25 | 65.2
2001-05-01 00:00:00 | 12 | 0 | 0 | 5.01 | 5.25 | 65.2
2001-05-01 00:00:00 | 13 | 0 | 0 | 5.01 | 5.25 | 65.2
2001-05-01 00:00:00 | 14 | 0 | 0 | 5.01 | 5.25 | 65.2
2001-05-01 00:00:00 | 15 | 0 | 0 | 5.01 | 5.25 | 65.2
2001-05-01 00:00:00 | 16 | 7 | 60.42 | 5.01 | 5.25 | 65.2
2001-05-01 00:00:00 | 17 | 7 | 60.42 | 5.01 | 5.25 | 65.2
2001-05-01 00:00:00 | 18 | 7 | 60.42 | 5.01 | 5.25 | 65.2
2001-05-01 00:00:00 | 19 | 7 | 60.42 | 5.01 | 5.25 | 65.2
2001-05-01 00:00:00 | 20 | 7 | 60.42 | 5.01 | 5.25 | 65.2
2001-05-01 00:00:00 | 21 | 0 | 0 | 5.01 | 5.25 | 65.2
2001-05-01 00:00:00 | 22 | 0 | 0 | 5.01 | 5.25 | 65.2
2001-05-01 00:00:00 | 23 | 25 | 59 | 5.01 | 5.25 | 65.2
2001-05-01 00:00:00 | 24 | 20 | 58 | 5.01 | 5.25 | 65.2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6701.62 |  | 191.92 | 3730.38
 | match value | 1
Spreadsheet: 95000d1294726778-need-2-x-ticker-label-moving-text-from-right-to-left-linked-dynamically-to-dropdown-multilookup-sort
Sheet: M

Sr.No | Policy Holders Name | POLICY NO | Date of  Comm | T-T | MODE | NAME OF THE PLAN | Plan Type | SUM ASSURED | Current Pay-By Date | PREMIUM
1 | [NAME] | 705787833 | 2003-01-14 00:00:00 | 48-25 | [NAME] | LIMITED PYMNT WITH PROFITS | Insurance | 100000 | 2011-01-14 00:00:00 | 3000 |  |  |  |  | 705787833 | 2003-01-14 00:00:00
2 | [NAME] | 702383786 | 2004-06-28 00:00:00 | 14-30 | SGL | ENDOWMENT  WITH BONUS | Insurance | 55000 | 2011-06-28 00:00:00 | 6000 |  |  |  |  | 702383786 | 2004-06-28 00:00:00
3 | [NAME] | 702383787 | 2004-06-28 00:00:00 | 14-31 | [NAME] | ENDOWMENT  WITH BONUS | Insurance | 55000 | 2011-06-28 00:00:00 | 9000 |  |  |  |  | 702383787 | 2004-06-28 00:00:00
4 | [NAME] | 702383788 | 2004-06-28 00:00:00 | 14-32 | SGL | ENDOWMENT  WITH BONUS | Insurance | 55000 | 2011-06-28 00:00:00 | 12000 |  |  |  |  | 702383788 | 2004-06-28 00:00:00
5 | [NAME] | 702007563 | 2005-02-15 00:00:00 | 169-22 | [NAME] | JEEVAN NIDHI WITH GUAR ADDTNS | Pension | 220000 | 2011-02-15 00:00:00 | 15000 |  |  |  |  | 702007563 | 2005-02-15 00:00:00
6 | [NAME] | 702007568 | 2005-02-15 00:00:00 | 14-32 | [NAME] | ENDOWMENT  WITH BONUS | Insurance | 55000 | 2011-02-15 00:00:00 | 18000 |  |  |  |  | 702007568 | 2005-02-15 00:00:00
7 | [NAME] | 702007560 | 2005-02-15 00:00:00 | 14-33 | [NAME] | ENDOWMENT  WITH BONUS | Insurance | 55000 | 2011-02-15 00:00:00 | 21000 |  |  |  |  | 702007560 | 2005-02-15 00:00:00
8 | [NAME] | 703572877 | 2008-06-27 00:00:00 | 165-35 | ECS | JEEVAN SARAL | Insurance | 250000 | 2011-06-27 00:00:00 | 24000 |  |  |  |  | 703572877 | 2008-06-27 00:00:00
 |  | http://www.5min.com/Video/How-to-do-a-Reverse-Lookup-in-Excel-110673575
Spreadsheet: 784632d1655881367-progress-of-task-in-day-by-day-if-task-finishes-earlier-than-expected-sample-day-by-day-v2
Sheet: Sheet1

 |  |  |  |  |  |  | 2022-08-18 00:00:00 | 2022-08-19 00:00:00 | 2022-08-20 00:00:00 | 2022-08-21 00:00:00 | 2022-08-22 00:00:00 | 2022-08-23 00:00:00 | 2022-08-24 00:00:00
 | Planned | Days on Task/person | % Daily | % Complete | Plan |  | Task A | Task A | Task A | Task A | Task A | Task A | Task A
Day 1 |  | 1
Day 2 |  | 1
Day 3 |  | 1 |  |  |  |  | Day 1 | Day 2 | Day 3 | Day 4 | Day 5 | Day 6 | Day 7 | Day 8 | Day 9
Day 4 |  | 1 |  |  | Task A | Plan %
Day 5 |  | 1 |  |  |  | Actual % |  |  |  |  | 1
Day 6
Day 7
Day 8
Day 9
TOTAL | 7
 |  | Task Completed | Yes
Spreadsheet: 76f02a24-ae2e-403e-b4e7-ed98ad670c22
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
263467 | 51375 | [NAME] | Walsh | USA |  | 00:15;47 | 00:01:36 | 00:35:54 | 00:01:46 | 00:23:07 | 1 | 01:18:12
263467 | 25148 | [NAME] | Mosquera | USA |  | 00:18:23 | 00:01:59 | 00:38:27 | 00:02:19 | 00:22:42 | 2 | 01:23:53
Spreadsheet: 685064d1593700634-create-summary-page-referencing-multiple-sheets-loading-schedule-example-1-
Sheet: A

Device Name/Number | Device Type | Location | IP Address
A1 | PC | Finance | 10.10.10.1
A2 | LAPTOP | HR | 10.10.10.2
A3 | PRINTER | Design | 10.10.10.3
A4 | PC | Warehouse | 10.10.10.4
A5 | LAPTOP | Engineering | 10.10.10.5
Spreadsheet: b7b329d6-d20c-4781-bcc6-1d6a226d1ff8
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SNOWSHOE | T1 | SKATE | T2 | SKI | POSITION | TOTAL TIME
2267 | 10368 | Emilie | Darras | FRA | 0 | 0.43.54 | 00:00:00 | 0.58.02 | 00:00:00 | 0.52.34 | 3 | 2.34.30
2267 | 6522 | Radka | [NAME] | CZE | 73 | 0.34.27 | 00:00:00 | 0.44.52 | 00:00:00 | 0.35.35 | 1 | 1.54.54
2267 | 6007 | Lydia | Weydahl | NOR | 72 | 0.34.46 | 00:00:00 | 0.41.43 | 00:00:00 | 0.34.54 | 2 | 1.51.23
Spreadsheet: 798476d1664494332-how-to-populate-other-cells-based-on-drop-down-value-plus-a-couple-other-questions-sample-pd-sheet
Sheet: Stipends

PSID | Rcd | Name | Stipend Name | Special Assignment 1 | Special Assignment 2 | Special Assignment 3 | PP | Fund | Dept | S/C | Account | Total Amount
110350077 | 0 | Smith, VALERIE | Post |  |  |  | 2022-09-22 00:00:00 | 90000 | 43425 | 00000 | 601934 | 200
105089348 | 0 | Jones, [NAME] | Adv Post |  |  |  | 2022-09-22 00:00:00 | 90000 | 43425 | 00000 | 601934 | 450
101016366 | 0 | Test, RICHARD | Post | Range Master | CRU |  | 2022-09-22 00:00:00 | 90000 | 43425 | 00000 | 601937 | 400
Spreadsheet: d606e959-3285-497d-9c69-23cba66418b8
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | SKI | POSITION | TOTAL TIME
7548 | 46480 | [NAME] | Räsänen | FIN | 148 | 00:17:57 | 00:00:31 | 00:22:08 | 00:01:30 | 00:16:29 | 1 | 00:58:39
7548 | 21752 | Kaarel | [NAME] | EST | 150 | 00:17:32 | 00:00:56 | 00:24:36 | 00:01:34 | 00:19:45 | 2 | 01:04:26
7548 | 7906 | Matti | Norja | FIN | 147 | [NAME] | 00:01:08 | 00:25:54 | 00:01:58 | 00:17:29 | 3 | 01:06:14
7548 | 46485 | Risto | Nordman | FIN | 146 | 00:21:35 | 00:01:01 | 00:28:08 | 00:01:38 | 00:20:31 | 4 | 01:12:58
7548 | 7907 | Eino | Lipponen | FIN | 0 | 00:20:01 | 00:01:16 | 00:28:10 | [NAME] | 00:20:34 | 5 | 01:13:09
7548 | 14373 | Sergey | [NAME] | RUS | 149 | 00:22:38 | 00:00:49 | 00:37:05 | 00:01:34 | 00:25:02 | 6 | 01:27:10
Spreadsheet: 702356d1604313723-depreciation-formula-using-drop-down-list-depreciation-using-drop-down-list
Sheet: Sheet1

Kindly asking for a depreciation formula for columns M, N and O. Please note that in column L8, L9, L10 , there is a drop down list where you select either SLN or DB.
** Land and [NAME] should not be depreciated
** In case of disposal ([NAME]) Annual depreciation should be zero
** After the useful life of the asset depreciation should not be calculated.
 |  |  |  |  |  |  | SLN
 |  |  |  |  |  |  | DB
Asset Code | Asset Name | Asset Category | Acquisition Date | Cost | Salvage | Useful life | End of Useful Life | Years To Date | Valuation | Disposals | Depreciation Method | Accumulated Depreciation | Annual Dpreciation | Asset Value end of Year | Profit / (Loss) on Disposal | Revaluation Gain / (Loss)
LB001 | Land and Buiding | Land and Building | 2015-04-10 00:00:00 | 60000
OA001 | Computer | Office Appliance | 2018-05-03 00:00:00 | 5000 | 1000 | 5 |  |  |  | 2000
MV001 | Motor Vehicle | Motor Vehicles | 2016-10-01 00:00:00 | 12000 | 3000 | 5
ME001 | Sawmill | Machinery and Equipment | 2020-01-01 00:00:00 | 10000 | 2000 | 8
Spreadsheet: 833915d1687344403-count-values-and-exclude-range-based-on-criterias-sample-lp
Sheet: Sheet2

Leave Planner 2023 |  |  |  |  |  | 2023-06-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-07-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-08-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-09-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-10-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-11-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-12-01 00:00:00
# | Name | Collar Type | Balance as June 2023 | Planned Leave Days | Remaining Balance as December 2023
1 | Employee 1 | White | 5 |  |  | V | V | V | V | V | V | V | V |  |  |  |  |  |  |  | V | V | V | V
2 | Employee 2 | Blue | 15 |  |  |  |  | V | V | V | V | V | V | V | V |  |  |  |  |  |  |  | V | V | V | V
3 | Employee 3 | White | 55 |  |  |  |  |  |  |  |  | V | V | V | V | V | V | V | V |  |  |  |  |  |  |  | V | V | V | V
4 | Employee 4 | Blue | 24 |  |  |  |  |  |  |  |  |  |  |  |  |  | V | V | V | V | V | V | V | V |  |  |  |  |  |  |  | V | V | V | V
5 | Employee 5 | Blue | 17 | 0
6 | Employee 6 | White | 15 |  |  |  |  |  |  |  |  |  |  |  | V | V | V |  | V | V | V | V | V | V | V | V |  |  |  |  |  |  |  | V | V | V | V
7 | Employee 7 | Blue | 52.9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | V | V | V | V | V | V | V | V |  |  |  |  |  |  |  | V | V | V | V
Spreadsheet: 550679d1512490027-possibly-using-pivot-table-to-sort-this-matrix-compatibility-matrix
Sheet: Sheet1

 | Micro A | Micro B | Micro C |  | Phone | Compatible Micro's |  | Micros | Compatible Phones
Phone 1 |  |  | X |  | Phone 2 |  |  | Micro C
Phone 2 | X |  | X
Phone 3
Phone 4 |  | X
Spreadsheet: 19a1873e-dc27-4591-9bb2-ff3b5964e6e4
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
40355868 | 2014-03-04 21:02:17 | AXIS | 1 | 7 | 5 | 288073 | Dukik-Team du Sud | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
40356346 | 2014-03-04 21:29:52 | ALLIES | 0 | 5 | 7 | 288073 | Dukik-Team du Sud | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
Spreadsheet: 272272d1382328959-attempting-to-flatten-multiple-temporal-data-points-for-single-identifier-book2
Sheet: Sheet1

ID | Day | Level
143 | Day 0 | 0 | 9 | 2 | 4 | 0
143 | Day 1 | 1
143 | Day 2 | 2
143 | Day 3 | 2 | 0 | 9 | 4 | 1
150 | Day 0 | 0
150 | Day 1 | 1
150 | Day 2 | 3
23 | Day 0 | 0 | 3 | 2 | 0 | 8
23 | Day 1 | 0
23 | Day 2 | 1
23 | Day 3 | 2
23 | Day 4 | 0
23 | Day 5 | 1
[NAME]What I need  it to look likev v v |  |  |  | *= doesn’t matter what it shows there, can be any day
143 | * | 2 | 9 | 2 | 4 | 0
150 | * | 3 | 0 | 9 | 4 | 1
23 | * | 2 | 3 | 2 | 0 | 8
Spreadsheet: 70660d1271359081-formula-compatibilities-claims-example
Sheet: Claim_ref

Ship Date | Tracking Number | Case Number | Status Type | Reason | Claim File Date | Claim Resolution Date | Claim Amount | Payment Amount | Payment Type | Customer Reference Number
2009-10-20 00:00:00 | 131804811980723 | 129529069 | Paid | Paid Full Amount Claimed | 2010-01-29 00:00:00 | 2010-01-31 00:00:00 | 38.99 | 38.99 | Check Payment