tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 739922d1626087945-calculating-data-from-several-columns-based-on-separate-months-spreadsheet-bit
Sheet: DATASHEET

2021 | 2021-01-01 00:00:00 | 2021-02-01 00:00:00 | 2021-03-01 00:00:00 | 2021-04-01 00:00:00 | 2021-05-01 00:00:00 | 2021-06-01 00:00:00 | 2021-07-01 00:00:00 | 2021-08-01 00:00:00 | 2021-09-01 00:00:00 | 2021-10-01 00:00:00 | 2021-11-01 00:00:00 | 2021-12-01 00:00:00
[NAME] directly to Person's listed email address
Architect
Read
Undelivered
Deleted
[NAME]
[NAME]
Added to Tender List
Client
Read
Undelivered
Deleted
[NAME]
[NAME]
Added to Tender List
Project Manager
Read
Undelivered
Deleted
[NAME]
[NAME]
Added to Tender List
Structural Engineer
Read
Undelivered
Deleted
[NAME]
[NAME]
Added to Tender List
[NAME] directly to Company's listed email address
Architect
Read
Undelivered
Deleted
[NAME]
[NAME]
Added to Tender List
Client
Read
Undelivered
Deleted
[NAME]
[NAME]
Added to Tender List
Project Manager
Read
Undelivered
Deleted
[NAME]
[NAME]
Added to Tender List
Structural Engineer
Read
Undelivered
Deleted
[NAME]
[NAME]
Added to Tender List
Spreadsheet: 189925d1351452731-multiple-columns-into-one-column-and-autofill-question-ef241_example-current
Sheet: Sheet1

YEAR | COMPANY | CURRENT ASSETS
Spreadsheet: 873684d1720192276-help-with-copying-rows-raid-logs-1-
Sheet: Risks

RISKS
Risk No. | Date Identified | Description | Probability | Impact | Preventative Actions | Contingent Actions | Owner | Actions by | Target  Date | Status | Notes
Spreadsheet: michelle_lokay__26740__imball0203
Sheet: WTG inc

 | contract 21816
 | 10518 |  | 13276 |  | 13475 |  | 500176 |  | 500390 |  | 500612
 | WTX Gas Parmer |  | Fred Born #1 |  | WTX Water Systems |  | [NAME] |  | [NAME] |  | TW/WTG Hansford
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 |  |  |  |  |  |  |  |  |  |  | -807 | -906
2 |  |  |  |  |  |  |  |  |  |  | -804 | -906
3 |  |  |  |  |  |  |  |  |  |  | -817 | -906
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-02-28 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  | 20990
2002-03-03 00:00:00
CBS Volume
 |  |  | 6566
Spreadsheet: 0090cd22-cdd0-4932-bfbf-a2955c630f5b
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Travel and Training January 16, 2012  through March 15, 2012 | Unnamed: 4 | Unnamed: 5
 | Name | Month | Vendor | Amount | Description
City Manager | [NAME] | Jan 16 to Mar 15 |  | 55 | NM Municipal League Municipal Day Registration
 |  |  |  | 50 | NM Regional Chamber Municipal Day
 |  |  |  | 275 | ICMA Internet Mountain Plains Conference
Municipal Judge | Judge [NAME] | Jan 16 to Mar 15 |  | 717.72 | Southwest Airlines - National Conference
 |  |  |  | 1230 | Registration - National Conference
 |  |  |  | Note: Other conference reimbursements were paid and will be reported for the period March 16, 2012 to June 30, 2012
Governing Body | Councilors | Jan 16 to Mar 15 |  | 100 | Colley Rio Rancho Regional Chamber Municipal Day
Spreadsheet: 39282d1237460041-formual-error-error-formula
Sheet: Sheet1

 |  |  |  |  |  | Col A | Col B | Col C | Col D | Col E | Col F
 |  |  |  |  |  | 300133 | A | A | 14130344 | Yes | 1
 |  |  |  |  |  | 300123 | B | B | 3213788 | Yes | 2
[NAME] |  |  |  |  |  | 57118 | C | CC | 2093007 | No | 3
 |  |  |  |  |  | 300124 | D | D | 1423858 | Yes | 4
 |  |  |  |  |  | 300009 | EE | E | 921597 | No | 5
 |  |  |  |  |  | 61235 | F | F | 848925 | Yes | 6
Name of meeting Attendee | C |  |  |  | 57118 | 61024 | G | GG | 604754 | No | 7
 |  |  |  |  |  | 300121 | H | HH | 491304 | No | 8
Name of Shareholder | Number of Shares | Attendee is |  |  |  | 300114 | G | GG | 440612 | No | 9
 |  | Owner | Proxy |  |  | 61571 | C | CC | 294400 | Yes | 10
#N/A | #N/A | #N/A | #N/A
#N/A | #N/A | #N/A | #N/A
Total number | #N/A
ShareholderNo | Name of Meeting Attendee | Name | No of Shares | Owner (Y/N)
Spreadsheet: 8d971a11-6d53-4693-a841-95cf78bc0919
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2011-10-04 09:37:28.260000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.375 | 101.875 | 101.75 | 101.625 | 101.25 |  | and are added to price quote
4.25 | 101.682 | 101.557 | 101.432 | 101.057
4.125 | 101.312 | 101.187 | 101.062 | 100.687 |  | Note: | Refer To Price [NAME]
4 | 100.917 | 100.792 | 100.667 | 100.292 |  |  | For all Price Adjs
3.875 | 100.39 | 100.265 | 100.14 | 99.515
3.75 | 99.497 | 99.372 | 99.247 | 98.622
 |  |  |  |  |  | NEW!!!!!
 |  |  |  |  |  | Please note availability of
 |  |  |  |  |  | Servicing Retained Product for
 |  |  |  |  |  | Conventional Loans Only.
 |  |  |  |  |  | A .25 adjustment to SRP
 |  |  |  |  |  | Will apply.
 |  |  |  |  |  | NEW!!!!
 |  |  |  |  |  | Improved 15 day price for
 |  |  |  |  |  | Conventional Product
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.875 | 101.875 | 101.75 | 101.625 | 101.25
3.75 | 101.487 | 101.362 | 101.237 | 100.862
3.625 | 101.124 | 100.999 | 100.874 | 100.499
3.5 | 100.771 | 100.646 | 100.521 | 100.146
3.375 | 100.371 | 100.246 | 100.121 | 99.496
3.25 | 99.834 | 99.709 | 99.584 | 98.959
 |  |  |  |  |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2011-10-18 09:37:28.260000
30 DAY | 2011-11-02 09:37:28.260000
45 DAY | 2011-11-17 09:37:28.260000
60 DAY | 2011-12-02 09:37:28.260000
90 DAY | 2012-01-01 09:37:28.260000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 669075d1585180323-multiple-entries-in-a-cell-help-change-data-structure-acct-to-pivot
Sheet: Sheet1

Date | Dividends | Account
2017-03-31 00:00:00 | 21 | 10
2017-06-30 00:00:00 | 22 | 10 |  | Account | 10 | << Select Acct Here
2017-09-17 00:00:00 | 22 | 10
2017-12-29 00:00:00 | 22 | 10 |  | Row Labels | Sum of Dividends
2018-03-29 00:00:00 | 22 | 10 |  | 2017 | 87
2018-06-29 00:00:00 | 23 | 10 |  | 2018 | 91
2018-09-28 00:00:00 | 23 | 10 |  | Qtr1 | 22
2018-12-31 00:00:00 | 23 | 10 |  | Qtr2 | 23
2019-03-29 00:00:00 | 23 | 10 |  | Qtr3 | 23
2019-06-28 00:00:00 | 24.15 | 10 |  | Qtr4 | 23
2019-09-30 00:00:00 | 24.15 | 10 |  | 2019 | 95.44999999999999
2019-12-31 00:00:00 | 24.15 | 10 |  | Grand Total | 273.45
2017-03-31 00:00:00 | 21 | 11
2017-06-30 00:00:00 | 22 | 11
2017-09-17 00:00:00 | 22 | 11
2017-12-29 00:00:00 | 22 | 11
2018-03-29 00:00:00 | 22 | 11
2018-06-29 00:00:00 | 23 | 11
2018-09-28 00:00:00 | 23 | 11
2018-12-31 00:00:00 | 23 | 11
2019-03-29 00:00:00 | 23 | 11
2019-06-28 00:00:00 | 24.15 | 11
2019-09-30 00:00:00 | 24.15 | 11
2019-12-31 00:00:00 | 24.15 | 11
Spreadsheet: darrell_schoolcraft__7585__imball0112
Sheet: Amarillo

Amarillo Natural Gas |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Contract  21579
contract 21534
 | poi 28786 |  | poi 56993 |  | poi 500170 |  | poi 10746 |  | poi 13247 |  | poi 500520 |  | poi 500171
 | Adobe [NAME] |  | [NAME] |  | ANG-Scott/Bandy II |  | [NAME] |  | [NAME] |  | [NAME] |  | ANG O Neal&Shadid
 | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | -3406 |  |  | -25 |  | -30 |  | -12 |  |  |  |  |  | -7
2 | -1974 |  |  | -25 |  | -30 |  | -12 |  |  |  |  |  | -7
3 | -1939 | -1900 |  | -25 |  | -30 |  | -12 |  |  |  |  |  | -7
4 | -1840 | -2104 |  | -25 |  | -30 |  | -12 |  |  |  |  |  | -7
5 | -1968 | -2104 |  | -25 |  | -30 |  | -12 |  |  |  |  |  | -7
6 | -1992 | -2104 |  | -25 |  | -30 |  | -12 |  |  |  |  |  | -7
7 | -1997 | -2104 |  | -25 |  | -30 |  | -12 |  |  |  |  |  | -7
8 | -2162 | -2104 | -3 | -25 |  | -30 |  | -12 |  |  |  |  |  | -7
9 | -2166 | -2104 |  | -25 |  | -30 |  | -12 |  |  |  |  |  | -7
10 | -2130 | -2104 | -7 | -25 |  | -30 |  | -12 |  |  |  |  |  | -7
11 | -2131 | -2104 |  | -25 |  | -30 |  | -12 |  |  |  |  |  | -7
12 | -2157 | -2104 |  | -25 |  | -30 |  | -12 |  |  |  |  |  | -7
13 | -2181 | -2104 |  | -25 |  | -30 |  | -12 |  |  |  |  |  | -7
14 | -2112 | -2104 |  | -25 |  | -30 |  | -12 |  |  |  |  |  | -7
15 | -2111 | -2104 |  | -25 |  | -30 |  | -12 |  |  |  |  |  | -7
16 | -2215 | -2104 |  | -25 |  | -30 |  | -12 |  |  |  |  |  | -7
17 | -2164 | -2104 |  | -25 |  | -30 |  | -12 |  |  |  |  |  | -7
18 | -2162 | -2104 | -18 | -25 |  | -30 |  | -12 |  |  |  |  |  | -7
19 | -2159 | -2104 |  | -25 |  | -30 |  | -12 |  |  |  |  |  | -7
20 | -2140 | -2104 |  | -1 |  | -1 |  | -2 |  |  |  |  |  | 0
21 | -2115 | -2104 |  | -25 |  | -30 |  | -12 |  |  |  |  |  | -7
22 | -2176 | -2104 |  | -25 |  | -30 |  | -12 |  |  |  |  |  | -7
23 | -2183 | -2104 |  | -25 |  | -30 |  | -12 |  |  |  |  |  | -7
24 | -2174 | -2104 |  | -25 |  | -30 |  | -12 |  |  |  |  |  | -7
25 | -2182 | -2104 |  | -25 |  | -30 |  | -12 |  |  |  |  |  | -7
26
27
28
29
30
31
index
2001-11-30 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 102894.9
2001-12-25 00:00:00
CBS Volume
 |  |  | 43028
Spreadsheet: 757751d1638446754-im-looking-for-help-on-how-link-a-master-sheet-to-populate-another-sheets-in-the-workbook-team-roster
Sheet: FGB

Washington Nationals
Team Owner
Team Salary
[NAME]
Available Salary
Roster
Minor League Players
Name-Pitchers | Salary | Years | Tm | Lg | W | L | W-L% | ERA | G | GS | GF | CG | SHO | SV | IP | H | R | ER | HR | BB | IBB | SO | HBP | BK | WP | BF | ERA+ | FIP | WHIP | H9 | HR9 | BB9 | SO9 | SO/W
[NAME] |  |  |  | AL | 0 | 0 | 0 | 3.27 | 10 | 0 | 7 | 0 | 0 | 0 | 11 | 9 | 4 | 4 | 3 | 4 | 0 | 9 | 0 | 0 | 0 | 44 | 128 | 6.17 | 1.182 | 7.4 | 2.5 | 3.3 | 7.4 | 2.25
[NAME] |  |  |  | AL | 0 | 0 | 0 | 5.6 | 16 | 0 | 4 | 0 | 0 | 0 | 17.2 | 23 | 12 | 11 | 1 | 7 | 1 | 10 | 0 | 0 | 0 | 82 | 83 | 3.96 | 1.698 | 11.7 | 0.5 | 3.6 | 5.1 | 1.43
[NAME] |  |  |  | NL | 0 | 0 | 0 | 6.75 | 7 | 1 | 2 | 0 | 0 | 0 | 17.1 | 20 | 15 | 13 | 7 | 11 | 0 | 12 | 0 | 0 | 2 | 82 | 64 | 8.94 | 1.788 | 10.4 | 3.6 | 5.7 | 6.2 | 1.09
[NAME] |  |  |  | NL | 0 | 0 | 0 | 3.38 | 1 | 1 | 0 | 0 | 0 | 0 | 5.1 | 6 | 2 | 2 | 1 | 3 | 0 | 9 | 1 | 0 | 1 | 24 | 128 | 4.48 | 1.688 | 10.1 | 1.7 | 5.1 | 15.2 | 3
[NAME] |  |  | Tm | Lg | G | PA | AB | R | H | 2B | 3B | HR | RBI | SB | CS | BB | SO | BA | OBP | SLG | OPS | P
[NAME] |  |  |  | AL | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] |  |  |  | AL | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] |  |  |  | AL | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Starling Marte
Spreadsheet: 109193d1306133090-looking-up-a-value-and-returning-a-list-of-non-blank-values-within-that-row-book2-2-
Sheet: Desired Outcome

PTP1 | [NAME] | [NAME] | [NAME] | [NAME]
PTP2 | [NAME] | [NAME] | [NAME] | Al | Rich
PTP3 | [NAME] | Al | Will | [NAME]
PTP4 | [NAME] | Al | Will
PTP5 | [NAME] | Rich
PTP6 | [NAME] | [NAME] | Rich
PTP7 | [NAME] | [NAME] | Will | [NAME]
PTP8 | [NAME] | [NAME]
PTP9 | [NAME] | [NAME]
PTP10 | [NAME] | [NAME]
Spreadsheet: 756714d1637735125-sum-column-based-on-date-range-excel-forum
Sheet: Sheet1

Brand | Factory | Start | Finish | Cars per day
Mazda | New York | 2022-03-09 00:00:00 | 2022-03-22 00:00:00 | 3
Mazda | Rome | 2022-03-17 00:00:00 | 2022-03-29 00:00:00 | 4
Mazda | Paris | 2022-02-25 00:00:00 | 2022-03-09 00:00:00 | 5
Mazda | London | 2022-09-06 00:00:00 | 2022-09-16 00:00:00 | 6
Mazda | Sydney | 2022-06-03 00:00:00 | 2022-06-17 00:00:00 | 7
Mazda | Munich | 2022-03-16 00:00:00 | 2022-08-20 00:00:00 | 8
2022-03-16 00:00:00 | 2022-03-17 00:00:00 | 2022-03-18 00:00:00 | 2022-03-19 00:00:00 | 2022-03-21 00:00:00 | 2022-03-22 00:00:00 | 2022-03-23 00:00:00 | 2022-03-24 00:00:00 | 2022-03-25 00:00:00 | 2022-03-26 00:00:00 | 2022-03-27 00:00:00 | 2022-03-28 00:00:00
Spreadsheet: c315d090-47e7-410d-90d3-b13e5b5605d6
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
258971 | 29738 | Fran | Bungay | GBR |  | 00:18:20 | 00:01:02 | 00:35:14 | 00:00:46 | 00:10:53 | 1 | 01:06:13
258971 | 56423 | Christine | Bertram | GBR |  | 00:18:42 | 00:00:53 | 00:36:09 | 00:00:44 | 00:10:47 | 2 | 01:07:13
258971 | 70656 | [NAME] | Spillane | GBR |  | 00:18:29 | 00:01:08 | [NAME] | 00:00:55 | 00:11:02 | 3 | 01:08:57
258971 | 70612 | [NAME] | Peers | GBR |  | 00:22:50 | 00:01:16 | [NAME] | 00:00:59 | 00:13:11 | 4 | 01:17:16
Spreadsheet: 098b0266-fc2f-4d6d-a219-8dc8d1f8f7a8
Sheet: Sheet1

*Please complete this form and email to [EMAIL].
If email is not an option, please fax to [PHONE] (*email is preferred).
COMPANY
JOB TITLE
FIRST NAME
LAST NAME
BUSINESS STREET
BUSINESS STREET 2
BUSINESS CITY
BUSINESS STATE
BUSINESS POSTAL CODE
BUSINESS PHONE #
EMAIL ADDRESS
WEB PAGE
RESELLER PERMIT #
STATE ISSUED
PREFERRED DISTRIBUTOR #1 |  | ACCOUNT #
PREFERRED DISTRIBUTOR #2 |  | ACCOUNT #
PREFERRED DISTRIBUTOR #3 |  | ACCOUNT #
*CasePartners will respond to your request within 3-4 weeks.
Spreadsheet: 145714d1331721578-sumif-prep-data-test
Sheet: MTD

 |  | Y | Y | Y | Y |  |  |  | Y | Y | Y |  |  |  |  | Y | Y | Y | Y |  |  |  | Y | Y | Y |  |  |  |  | H | H
Line # | 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 | 26 | 27 | 28 | 29 | 30 | 31 |  | Total
3 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 2 | 2 | 0 | 3 | 2 | 2 | 2 | 1 | 0 | 2 | 0 | 0 | 1 | 2 | 0 | 0 |  | 21
4 | 0 | 0 | 1 | 1 | 1 | 1 | 0 | 0 | 2 | 1 | 2 | 0 | 0 | 0 | 0 | 1 | 1 | 1 | 3 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 |  | 18
5 | 1 | 0 | 1 | 1 | 0 | 3 | 0 | 0 | 0 | 2 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 |  | 10
6 | 0 | 0 | 1 | 0 | 2 | 2 | 2 | 1 | 1 | 1 | 1 | 0 | 1 | 0 | 1 | 0 | 0 | 0 | 0 | 2 | 1 | 1 | 1 | 0 | 1 | 0 | 0 | 1 | 0 | 0 | 0 |  | 20
8 | 0 | 3 | 1 | 1 | 0 | 0 | 1 | 0 | 0 | 1 | 0 | 1 | 4 | 1 | 1 | 1 | 0 | 2 | 1 | 2 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 |  | 23
12 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 2 | 0 | 1 | 1 | 2 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 2 | 1 | 0 | 0 | 1 | 0 | 0 | 0 | 0 |  | 12
14 | 0 | 0 | 0 | 1 | 1 | 2 | 2 | 1 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 8
 | 1 | 4 | 4 | 4 | 4 | 8 | 5 | 4 | 3 | 6 | 5 | 3 | 6 | 2 | 3 | 4 | 3 | 4 | 7 | 6 | 3 | 5 | 5 | 2 | 3 | 0 | 2 | 3 | 3 | 0 | 0 |  | 112
 |  | Day of Month | 12 | 0
 |  |  | Line 3 | Line 4 | Line 5 | Line 6 | Line 8 | Line 12 | Line 14
Day Shift | Job 1 | Work Order
 |  | Type
 |  | Total Time
 | Job 2 | Work Order |  |  |  |  |  | 2032650
 |  | Type |  |  |  |  |  | DIA |  | F
 |  | Total Time
 | Job 3 | Work Order
 |  | Type
 |  | Total Time
 | Job 4 | Work Order
 |  | Type
 |  | Total Time
Night Shift | Job 1 | Work Order
 |  | Type
 |  | Total Time
 | Job 2 | Work Order |  |  |  |  | 2032130 | 2032640
 |  | Type |  |  |  |  | DIA | L3 |  | G
 |  | Total Time |  |  |  |  |  | 9.5
 | Job 3 | Work Order
 |  | Type
 |  | Total Time
 | Job 4 | Work Order
 |  | Type
 |  | Total Time
Spreadsheet: 94977d1294703243-adding-info-book1
Sheet: ADDING LOCATIONS

S14001A1 | S14001A1 |  | S14002A1 | S14002A1
 | S14001A2 |  |  | S14002A2
 | S14001A3 |  |  | S14002A3
 | S14001A4 |  |  | S14002A4
 | S14001A5 |  |  | S14002A5
 | S14001B1 |  |  | S14002B1
 | S14001B2 |  |  | S14002B2
 | S14001B3 |  |  | S14002B3
 | S14001B4 |  |  | S14002B4
 | S14001B5 |  |  | S14002B5
 | S14001C1 |  |  | S14002C1
 | S14001C2 |  |  | S14002C2
 | S14001C3 |  |  | S14002C3
 | S14001C4 |  |  | S14002C4
 | S14001C5 |  |  | S14002C5
 | S14001D1 |  |  | S14002D1
 | S14001D2 |  |  | S14002D2
 | S14001D3 |  |  | S14002D3
 | S14001D4 |  |  | S14002D4
 | S14001D5 |  |  | [NAME]
 | S14001E1 |  |  | S14002E1
 | S14001E2 |  |  | S14002E2
 | S14001E3 |  |  | S14002E3
 | S14001E4 |  |  | S14002E4
 | S14001E5 |  |  | S14002E5
 | S14001F1 |  |  | S14002F1
 | S14001F2 |  |  | S14002F2
 | S14001F3 |  |  | S14002F3
 | S14001F4 |  |  | S14002F4
 | S14001F5 |  |  | S14002F5
Spreadsheet: f87ab11e-0796-491f-a9ed-2d5e8ae0bf78
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
43159916 | 2014-09-14 20:24:54 | ALLIES | 0 | 2 | 6 | 679790 | Hermann | 11520 | western | 1944-06-06 |  | Omaha Beach- Easy Green & Dog Red
43178801 | 2014-09-16 03:08:50 | ALLIES | 0 | 2 | 6 | 679790 | Hermann | 11520 | western | 1944-06-06 |  | Omaha Beach- Easy Green & Dog Red
43178884 | 2014-09-16 03:16:15 | ALLIES | 0 | 3 | 6 | 679790 | Hermann | 11520 | western | 1944-06-06 |  | Omaha Beach- Easy Green & Dog Red
43178949 | 2014-09-16 03:31:05 | AXIS | 0 | 3 | 6 | 679790 | Hermann | 13376 | mediterranean | 1941-02-05 | 1941-02-07 |  | [NAME] Février 1941 - 07 Février 1941
Spreadsheet: 725085d1616521892-formula-needed-for-several-scenerios-summary-report-details
Sheet: July-20

 | Month: | 2020-07-01 00:00:00 |  |  |  |  |  |  |  |  |  |  | New Credits
 | SC # | SC Name | 2019-09-01 00:00:00 | 2019-10-01 00:00:00 | 2019-11-01 00:00:00 | 2019-12-01 00:00:00 | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-01 00:00:00 | 2020-04-01 00:00:00 | 2020-05-01 00:00:00 | 2020-06-01 00:00:00 | 2020-07-01 00:00:00 | 2020-08-01 00:00:00 | 2020-09-01 00:00:00 | Total |  |  | Pre-Invoice Amounts | CR Applied | Invoice Amts
Prior/Current | 1234 | Example Name | 0 | 0 | 12430.46 | 2015.04 | 11294.35 | 2364.01 | 1271.04 | 340.55 | 173.86 | 1001.09 | 1265.51 |  |  |  |  |  | 2537.41
Prior/Current | 2345 | Example Name | 0 | 0 | 0 |  | 4139.48 | 2002.86 | 65.53 | 62.55 | 124.65 | 77.4 | 34.86 |  |  |  |  |  | 1181.25
Prior/Current | 3456 | Example Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 87983.13 | 15395.92 | 639.64 |  |  |  |  |  | 8030.23
Prior/Current | 4567 | Example Name | 0 | 0 | 0 | 0 | 2458.07 | 868.01 | 325.14 | 221.6 | 305.99 | 30.8 | 482.43 |  |  |  |  |  | 838.49
Prior/Current | 5678 | Example Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 845.2 | 1448.59 |  |  |  |  |  | 16282.43
Prior/Current | 6789 | Example Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1040.88 |  |  |  |  |  | 8103.95
Prior/Current | 7890 | Example Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 18708.56 | 463.06 | 373.47 |  |  |  |  |  | 2383.56
Prior/Current | 8901 | Example Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 265.16 |  |  |  |  |  | 4300.14
Prior/Current | 9012 | Example Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 84057.14 | 76.31 | 67.07 |  |  |  |  |  | 1438.62
Prior/Current | 9013 | Example Name | 0 | 0 | 0 | 0 | 1652.36 | 1279.49 | 2214.81 | 245.23 | 262.39 | 563.85 | 2676.81 |  |  |  |  |  | 2669.68
Used | 1234 | Example Name | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Used | 2345 | Example Name | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0
Used | 3456 | Example Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0
Used | 4567 | Example Name | 0 | 0 | 0 | 0 |  | 0 | 0 | 0 | 0 | 0 | 0
Used | 5678 | Example Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -845.2 | -1448.59
Used | 6789 | Example Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -1040.88
Used | 7890 | Example Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -2383.56 | 0 | 0
Used | 8901 | Example Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -265.16
Used | 9012 | Example Name | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -1438.62 | 0 | 0
Used | 9013 | Example Name | 0 | 0 | 0 | 0 | -1652.36 | -1017.32 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  | `
Spreadsheet: sally_beck__35164__MgmtSum-Q3-0921_Global
Sheet: CapChrg-AllocExp

PLAN2000
CAP_CHRG | ENRON GLOBAL MARKETS |  |  |  |  |  |  |  |  |  |  |  |  |  |  | DEALS IDENTIFIED
TOT_ALLOCATION | 3RD QUARTER 2000 CAPITAL CHARGE & ALLOCATED EXPENSES
2000-09-01 00:00:00 | Results based on activity through September 21, 2000
M.QTD
ENA
 |  |  | Capital Charge |  |  |  |  |  |  | Allocated Expenses
 | Business Team |  | Forecast | Plan | [NAME] | Explanation |  |  |  | Forecast | Plan | [NAME] | Explanation
 | Liquids |  | 0 | 0 | 0 |  |  |  |  | 5596 | 5296 | -300 | London plan shortfall
COAL | Coal |  | 665 | 783 | 118 |  |  |  |  | 2476 | 1641.9 | -834 | London plan shortfall
SO2 | Emissions |  | 0 | 0 | 0 |  |  |  |  | 236.4 | 236.4 | 0
WEATHER | Weather |  | 0 | 0 | 0 |  |  |  |  | 773.2 | 773.2 | 0
INSURANCE | Global Risk Markets |  | 0 | 0 | 0 |  |  |  |  | 446 | 36 | -410
ECT_INV_IRFX | Financial Trading |  | 0 | 0 | 0 |  |  |  |  | 1822.594 | 1822.7 | 0
 | Office of the Chairman |  | 0 | 0 | 0 |  |  |  |  | 0 | 0 | 0
 | Subtotal |  | 665 | 783 | 118 |  |  |  |  | 11350.194 | 9806.2 | -1544
 | [NAME] |  | -665 | -783 | -118 |  |  |  |  | 0 | 0 | 0
 | Group |  | 0 | 0 | 0 |  |  |  |  | -11350.194 | -9806.2 | 1543.994000000001
 | Total |  | 0 | 0 | 0 |  |  |  |  | 0 | 0 | -0.005999999999403371
Spreadsheet: 887799d1738111547-fixed-asset-depreciation-fixed-asset-depreciation-v2
Sheet: v2

 | Summary |  | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 | Year 8 | Year 9 | Year 10 | Total
 | Net Book Value b/f |  | 0
 | Addition |  | 500000 |  | 300000 |  |  |  |  |  |  |  |  |  |  | Input cells
 | Initial Depreciation | 0.2 |  | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | [NAME] required
 | Annual Depreciation | 0.1
 | Net Book Value c/f
 | Year 1 |  | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 | Year 8 | Year 9 | Year 10 | Total
 | Net Book Value b/f |  | 0
 | Addition |  | 500000
 | Initial Depreciation | 0.2
 | Annual Depreciation | 0.1
 | Net Book Value c/f
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Remove this section
 | Year 3 |  | Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 | Year 8 | Year 9 | Year 10 | Total
 | Net Book Value b/f |  | 0
 | Addition |  |  |  | 300000
 | Initial Depreciation | 0.2
 | Annual Depreciation | 0.1
 | Net Book Value c/f
 | Further to my post in:
 | https://www.excelforum.com/excel-formulas-and-functions/1432561-fixed-asset-depreciation.html#post6008830
 | I need a formula for Initial Depreciation and Annual Depreciation for the purchase of new assets without having to break down the 2 purchases and then add them up.
Spreadsheet: 758647d1638980918-auto-populate-master-data-into-individual-employee-time-sheet-using-drop-down-list-book2_temp
Sheet: time sheet

Employee Attendance Record
Time Sheet
Emp. ID | 50001 |  |  |  |  | For the Month: | 2021-11-01 00:00:00
Name |  |  |  |  |  |  |  |  |  |  |  |  |  | Emp. No. | Month
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 50001 | 2021-01-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 50002 | 2021-02-01 00:00:00
Date | Day | Time In | Time Out | Work Hrs. | [NAME]. | Early Departue | OT. Hrs. | Remarks |  |  |  |  |  | 50003 | 2021-03-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 50004 | 2021-04-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 50005 | 2021-05-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-06-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-07-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-08-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-09-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-10-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-11-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2021-12-01 00:00:00