tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 9708bd4c-a54a-442c-9999-ce0bb0edf59b
Sheet: Sheet1

COMMUNITY PROJECT/ZONING | 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
Ordinance Fact Sheet |  |  |  |  |  |  | Ordinance Number
 | Case No. 1504-V
Brief Title |  |  | Approval Deadline |  | Reason
 | Vacating the east-west alley north of 44th Street west of Jefferson Street
Details |  |  |  |  | Positions/Recommendations
 | Specific Address |  |  |  | Sponsor | [NAME], AICP, Director
 |  |  |  |  |  | Department of City Planning and Development
 |  |  |  |  | Programs,
 |  |  |  |  | Departments, |  | 4th District
 |  |  |  |  | or Groups
 | Reason for Legislation |  |  |  | Affected |  | (Glover, Rowland)
 |  |  |  |  | Applicants / |  | Applicant
 |  |  |  |  | Proponents
 |  |  |  |  |  |  | City Department
 |  |  |  |  |  |  |  |  | City Development
 |  |  |  |  |  |  | Other
 |  |  |  |  | Opponents |  | Groups or Individuals
 |  |  |  |  |  |  | none known
 |  |  |  |  |  |  | Basis of opposition
 |  |  |  |  | Staff
 |  |  |  |  | Recommendation |  | X |  | For |  | with conditions
 |  |  |  |  |  |  |  |  | Against
 |  |  |  |  |  |  | Reason Against
 |  |  |  |  | Board or |  | City Plan Commission |  |  |  |  |  |  |  | (5-0)    5-21-05
 |  |  |  |  | Commission |  | By |  |  | ([NAME], Hernandez
 |  |  |  |  | Recommendation |  | Holwick, Jenks, Myers)
 |  |  |  |  |  |  |  |  | For |  |  |  | Against |  | No action taken
 |  |  |  |  |  |  | X |  | For, with revisions or conditions
 |  |  |  |  |  |  |  |  | (see details column for conditions)
 |  |  |  |  | Council
 |  |  |  |  | Committee Actions |  |  |  | Do pass
 |  |  |  |  |  |  |  |  | Do pass (as amended)
 |  |  |  |  |  |  |  |  | Committee Sub.
 |  |  |  |  |  |  |  |  | Without Recommendation
 |  |  |  |  |  |  |  |  | Hold
 |  |  |  |  |  |  |  |  | Do not pass
 |  |  |  |  |  |  |  |  |  |  |  | (Continued on reverse side)
Details |  |  |  |  | Policy/Program Impact
 |  |  |  |  | Policy or Program
 |  |  |  |  | Change |  |  |  | No |  |  |  | Yes
 |  |  |  |  | Operational
 |  |  |  |  | Impact
 |  |  |  |  | Assessment
 |  |  |  |  | Finances
 |  |  |  |  | Cost & Revenue
 |  |  |  |  | Projections --
 |  |  |  |  | Including Indirect
 |  |  |  |  | Costs
 |  |  |  |  | Financial Impact
 |  |  |  |  | Fund Source (s)
 |  |  |  |  | and Appropriation
 |  |  |  |  | Account Codes
 |  |  |  |  | Vacation forms sent to applicant 1-30-2005
 |  |  |  |  | Information per CPC received 6-24-05
Fact Sheet Prepared By: |  |  | Date:   7-8-05
 | [NAME]
 | Planner
Reviewed by: |  |  | Date:   7-11-05
 | [NAME], Manager
 | Development Management
Reference Numbers
 | Case No. 1504-V
 | [NAME] (continued)
Spreadsheet: 678907d1590112314-counting-over-several-pages-and-if-conditions-arent-met-then-blank-iauditor-dashboard-for-example-sammyghr-
Sheet: 27 Jan 20 - 01 Feb 20 

IAuditor Health & Safety Docs Dashboard
 | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Percentage
Daily Pre Start - Foremen | 2020-01-27 00:00:00 | 2020-01-28 00:00:00 | 2020-01-29 00:00:00 | 2020-01-30 00:00:00 | 2020-01-31 00:00:00 | 2020-02-01 00:00:00 | ❌ | ✓ |  | Weekly Workplace Inspection  - Foremen | 27/01/2020 - 01/02/2020
Dameon | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | Dameon | ✓
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | [NAME] | ✓
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | [NAME] | ❌
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | [NAME] | ✓
[NAME] | ✓ | ✓ | ✓ | ✓ | AWAY |  |  | 1 |  | [NAME] | ✓
Harley | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | Harley | ✓
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | [NAME] | ❌
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | [NAME] | ✓
Nathan | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |  | 1 |  | Nathan | ✓
[NAME] | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | [NAME] | N/A
[NAME] | ✓ | ✓ | ✓ | AWAY | AWAY |  |  | 1 |  | [NAME] | ❌
Tyson | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |  | 1 |  | Tyson | ✓
Will | ✓ | ✓ | ✓ | ✓ | ✓ | ✓ |  | 1 |  | Will | N/A
Daily Pre Start - Contractors |  |  |  |  |  |  |  |  |  | Weekly Workplace Inspection  - Contractors
 | ✓ | ✓ | ✓ | ✓ | ✓ |  |  | 1 |  | [NAME] | ✓
 | AWAY | ✓ | [NAME] | ✓ | ✓ |  |  | 0.75 |  | Daniel - Jaydee Roofing | ✓
 | ✓ | ✓ | ✓ | [NAME] | ✓ |  |  | 0.8 |  | [NAME] | ❌
Edge Protection [NAME] |  |  | 27/01/2020 - 01/02/2020 |  |  |  |  |  |  | Fortnightly [NAME] Foremen | 27/01/2020 - 01/02/2020
Canterbury Linen |  |  | ✓ |  |  |  |  |  |  | Dameon | ❌
Blum |  |  | ✓ |  |  |  |  |  |  | [NAME] | ❌
Komatsu |  |  | ✓ |  |  |  |  |  |  | [NAME] | ✓
Move |  |  | ❌ |  |  |  |  |  |  | [NAME] | ✓
85 [NAME] |  |  | ✓ |  |  |  |  |  |  | [NAME] | ✓
 |  |  |  |  |  |  |  |  |  | Harley | ✓
 |  |  |  |  |  |  |  |  |  | [NAME] | ❌
 |  |  |  |  |  |  |  |  |  | [NAME] | ✓`
 |  |  |  |  |  |  |  |  |  | Nathan | ✓`
*** Means received but had to ask for it |  |  |  |  |  |  |  |  |  | [NAME] | N/A
❌   Means did not get one at all |  |  |  |  |  |  |  |  |  | [NAME] | ✓
 |  |  |  |  |  |  |  |  |  | Tyson | ✓
 |  |  |  |  |  |  |  |  |  | Will | N/A
 |  |  |  |  |  |  |  |  |  | Fortnightly [NAME]
 |  |  |  |  |  |  |  |  |  |  | ❌
 |  |  |  |  |  |  |  |  |  |  | ❌
 |  |  |  |  |  |  |  |  |  |  | ❌
Spreadsheet: 036ba2fd-e7fc-46ff-ab3f-5d83fb7cd6e1
Sheet: Lucas County Pilot Project

COUNTY | DISTRICT NAME | DISTRICT IRN
Lucas | [NAME] | 048207
Lucas | Maumee City | 044362
Lucas | Oregon City | 044602
Lucas | Ottawa Hills Local | 048215
Lucas | Springfield Local | 048223
Lucas | Sylvania City | 044875
Lucas | Toledo City | 044909
Lucas | Washington Local | 048231
Spreadsheet: 726011d1617017358-how-to-categorize-using-multiple-currency-rate-multiple-currency-rev2
Sheet: Sheet2

Team | Request Ticket | Item | Category | Case code | Total Value | Currency | USD | Threshold
 | 12580243 | 10 | X |  | 15000 | USD
 | 17185628 | 10 | X |  | 100000 | USD
 | 55723648 | 40 | X |  | 2300000 | EUR
 | 51858337 | 30 | X |  | 1700 | USD
 | 11467077 | 10 | X |  | 70000 | [NAME]
 | 4420109 | 10 |  | ABC54656 | 170.14 | EUR
 | 11518185 | 10 |  |  | 2920 | AUD
 | 11518185 | 20 |  |  | 5920 | USD
 | 11467077 | 20 |  |  | 1000000 | [NAME]
 | 4420109 | 20 |  |  | 50000 | EUR
Spreadsheet: 376527d1423632240-merge-inconsistent-dates-stock-prices-from-ftse-merge-inconsistant-dates
Sheet: Summary

Date |  | AMEC |  | Index |  | Risk free
Spreadsheet: b63272e5-8340-40ba-82c0-f6ae39750926
Sheet: Sheet1

Release: Annual Estimates of the Population of Metropolitan and Micropolitan Statistical Areas | Unnamed: 1 | Unnamed: 2
Link: http://alfred.stlouisfed.org/release?rid=111
ALFRED (ArchivaL Federal Reserve Economic Data)
Economic Research Division
Federal Reserve Bank of St. Louis
File Created: 2014-04-19 6:58 PM [NAME]
 | Real-Time | Period
Name: | Start | End
Annual Estimates of the Population of Metropolitan and Micropolitan | 2005-06-07 00:00:00 | Current
Statistical Areas
Link:
http://www.census.gov/popest/ | 2005-06-07 00:00:00 | Current
Source:
U.S. Department of Commerce: Census Bureau | 2005-06-07 00:00:00 | Current
Release Dates Notes:
Release dates are determined by the following process:
When available, the actual release date as provided by the source is
entered into the ALFRED database.  If a release date is not available
from the source, the release date given by our data providers is used.
If a release date cannot be determined either from the source or from
our data providers, the date that the series was first available in
the St. Louis Fed's FRED database is used.
The release date list contains the dates when any series from this
release was revised.  Note that all series from a release do not
necessarily revise on every release date.
Release Dates:
2005-06-07 00:00:00
2006-01-19 00:00:00
2006-08-21 00:00:00
2006-09-14 00:00:00
2007-04-05 00:00:00
2008-03-27 00:00:00
2009-03-19 00:00:00
2010-03-25 00:00:00
2012-04-05 00:00:00
2013-03-27 00:00:00
Spreadsheet: 117130d1312468234-change-position-of-auto-filter-button-in-a-table-autofilter-along-column-not-row
Sheet: Sheet1

TABLE A: AUTO FILTER ALONG THE ROW |  |  |  |  |  |  | TABLE B: AUTO FILTER ALONG THE COLUMN???
 | Price | Beds | Baths | Agent
House 3 | 250000 | 5 | 4 | [NAME] |  |  | Price
House 2 | 155000 | 3 | 1 | [NAME] |  |  | Beds
House 5 | 100000 | 2 | 3 | [NAME] |  |  | Baths
House 1 | 80000 | 3 | 2 | Will |  |  | Agent
House 4 | 50000 | 1 | 1 | [NAME]
 | I would like the Table Auto Filter to be along the Column as in Table B, and not the Row as Table A.
 | For example, clicking "Price" in Table B should have the same effect as clicking the grey button next to "Price" in Table A.
 | Or, have the gray button also appearing beside "Price" in Table B.
 | In other words, I would like the functionality of Table A but with the appearance of Table B.
 | Table B a mirror image of Table A with my preferred appearance.
 | To Sort by in Table B, I have to click the grey button in Table A.
 | Is there was a way of Hyperlinking the blue underlined fields in Table B with the grey buttons in column A?
Spreadsheet: 853625d1703549470-trying-to-get-data-from-a-spreadsheet-and-break-it-down-per-customer-and-per-tech-results
Sheet: Sheet1

ACME
[NAME] | 16.46
[NAME] | 37.5
[NAME] | 19.65
[NAME] | 6.25
[NAME] | 47.86000000000001
[NAME] | 23.47000000000001
[NAME] | 60.66000000000001
[NAME] | 14.39
[NAME] | 5.26
Sara | 21.32999999999999
reception | 0.4700000000000001
Tine | 0.54
[NAME] | 1.04
[NAME] | 5
[NAME] | 0.21
US GOV
[NAME] | 6.5
[NAME] | 1.33
[NAME] | 9.090000000000002
[NAME] | 8.7
[NAME] | 0.22
Sara | 3.25
[NAME] | 20.18
[NAME] | 3.67
[NAME] | 2.48
reception | 0.03
[NAME]
[NAME] | 23.75999999999999
[NAME] | 5.02
[NAME] | 2.95
[NAME] | 8.959999999999999
[NAME] | 19.96
[NAME] | 5.76
[NAME] | 9.389999999999997
[NAME] | 8.45
[NAME] | 0.1
Sara | 9.35
[NAME] | 8.129999999999999
reception | 0.17
Spreadsheet: c8bebb58-780f-4713-a074-4687242196be
Sheet: Power by Week

Team | Week 1 | Week 2 | Week 3 | Week 4 | Week 5 | Week 6 | Week 7 | Week 8 | Week 9 | Week 10 | Week 11 | Week 12 | Week 13 | Week 14 | Week 15 | Week 16 | Week 17 | Average | Highest | Lowest | Biggest Gap | Team Change Code | Change from Last Week | Change from Week 1
New England Patriots | 2 | 1
San Francisco 49ers | 5 | 2
Baltimore Ravens | 4 | 3
Houston Texans | 6 | 4
Green Bay Packers | 3 | 5
Atlanta Falcons | 12 | 6
New York Giants | 1 | 7
Chicago Bears | 11 | 8
Denver Broncos | 10 | 9
Dallas Cowboys | 14 | 10
Pittsburgh Steelers | 8 | 11
Philadelphia Eagles | 7 | 12
Detroit Lions | 9 | 13
San Diego Chargers | 15 | 14
Washington Redskins | 25 | 15
New Orleans Saints | 13 | 16
New York Jets | 20 | 17
Cincinnati Bengals | 16 | 18
Kansas City Chiefs | 17 | 19
Arizona Cardinals | 19 | 20
Tampa Bay Bucs | 24 | 21
Tennessee Titans | 18 | 22
Carolina Panthers | 21 | 23
Buffalo Bills | 23 | 24
Oakland Raiders | 26 | 25
[NAME] | 22 | 26
St. Louis Rams | 29 | 27
Minnesota Vikings | 31 | 28
[NAME] | 28 | 29
[NAME] | 27 | 30
[NAME] | 30 | 31
Indianapolis Colts | 32 | 32
Spreadsheet: 668999d1585156865-move-rows-to-separate-sheets-new-budget-test
Sheet: 2100 21 7810

Date | Vendor | Item | P.O.# | Amount | Acct Code
Spreadsheet: 195567d1353557650-complex-data-transposing-pt-city-party-result
Sheet: Sheet1

City | Party | Result
City 1 | Party Z | 30
City 1 | Party Y | 20 |  | Sum of Result | Column Labels
City 1 | Party X | 10 |  | Row Labels | Party X | Party Y | Party Z | Grand Total
City 2 | Party Z | 40 |  | City 1 | 10 | 20 | 30 | 60
City 2 | Party Y | 30 |  | City 2 | 12 | 30 | 40 | 82
City 2 | Party X | 12 |  | City 3 | 10 | 10 | 40 | 60
City 3 | Party Z | 40 |  | Grand Total | 32 | 60 | 110 | 202
City 3 | Party Y | 10
City 3 | Party X | 10
Spreadsheet: 774931d1648730203-look-up-and-retrieve-excel-sample
Sheet: Feb 2022

ID # | Team A Maintenance Hours | Team B Maintenance Hours | Total [NAME]
[NAME] | 32 | 0
FE775 | 44 | 44
AS787 | 55 | 64
OP741 | 63 | 4
FD988 | 365 | 3
GG987 | 44.5 | 21
GG984 | 87.5 | 33
GG447 | 45.7 | 0
OP456 | 87 | 57
Spreadsheet: 820657d1678217878-need-a-formula-method-of-identifying-a-start-and-end-date-dates
Sheet: Sheet1

Date | DT IND | Cycle Title | [NAME] | En Dt | BEG-END DT
2023-01-01 00:00:00 | Day 1 | CY1
2023-01-02 00:00:00 | Day 2 | CY1
2023-01-03 00:00:00 | Day 3 | CY1
2023-01-04 00:00:00 | Day 4 | CY1
2023-01-05 00:00:00 | Day 5 | CY1
2023-01-06 00:00:00 | Day 6 | CY1
2023-01-07 00:00:00 | Day 7 | CY1
2023-01-08 00:00:00 | Day 1 | CY2
2023-01-09 00:00:00 | Day 2 | CY2
2023-01-10 00:00:00 | Day 3 | CY2
2023-01-11 00:00:00 | Day 4 | CY2
2023-01-12 00:00:00 | Day 5 | CY2
2023-01-13 00:00:00 | Day 6 | CY2
2023-01-14 00:00:00 | Day 7 | CY2
2023-01-15 00:00:00 | Day 1 | CY3
2023-01-16 00:00:00 | Day 2 | CY3
2023-01-17 00:00:00 | Day 3 | CY3
2023-01-18 00:00:00 | Day 4 | CY3
2023-01-19 00:00:00 | Day 5 | CY3
2023-01-20 00:00:00 | Day 6 | CY3
2023-01-21 00:00:00 | Day 7 | CY3
2023-01-22 00:00:00 | Day 1 | CY4
2023-01-23 00:00:00 | Day 2 | CY4
2023-01-24 00:00:00 | Day 3 | CY4
2023-01-25 00:00:00 | Day 4 | CY4
2023-01-26 00:00:00 | Day 5 | CY4
2023-01-27 00:00:00 | Day 6 | CY4
2023-01-28 00:00:00 | Day 7 | CY4
2023-01-29 00:00:00 | Day 1 | CY5
2023-01-30 00:00:00 | Day 2 | CY5
2023-01-31 00:00:00 | Day 3 | CY5
2023-02-01 00:00:00 | Day 4 | CY5
2023-02-02 00:00:00 | Day 5 | CY5
2023-02-03 00:00:00 | Day 6 | CY5
2023-02-04 00:00:00 | Day 7 | CY5
2023-02-05 00:00:00 | Day 1 | CY6
2023-02-06 00:00:00 | Day 2 | CY6
2023-02-07 00:00:00 | Day 3 | CY6
2023-02-08 00:00:00 | Day 4 | CY6
2023-02-09 00:00:00 | Day 5 | CY6
2023-02-10 00:00:00 | Day 6 | CY6
2023-02-11 00:00:00 | Day 7 | CY6
Spreadsheet: 716658d1612302416-using-1-duplicate-criteria-in-a-single-column-pull-row-details-into-a-new-spreadsheet-sample-sheet
Sheet: Bid Pending Award

Status | Project Office | Bid Type | PC Job # | Project Name | Project Address | Project Complexity | Chance of Winning | Bid Due Date | Estimated Cost | Per Diem | Project Start Date | Project Finish Date | Project Duration | Notes |  |  |  |  |  |  |  |  | Project Number | Project Name | Project  Complexity | Duration | Start | Finish | Superintendent | Start for Super if different than  [NAME] | End for Super if different than  [NAME] | Super  Level | Super Sit-in or 2nd | Superintendent (Sit-in) or Super #2 | Super  Level | Start Date | End Date | Project Manager | PM Level | Assistant Project Manager | APM Level | Project Coordinator | Travel Budget | Crystal Ball |  |  | Bid Pending Award
Bid Pending Award
Bid Pending Award
 | Georgia | Negotiated | 44202 | PC1002 | 0 | 0 | Project 2 | Address 2
 | Georgia | Negotiated | 44202 | PC1002 | 0 | 0 | Project 2 | Address 2
 | Georgia | Negotiated | 44202 | PC1002 | 0 | 0 | Project 2 | Address 2
 | Georgia | Negotiated | 44202 | PC1002 | 0 | 0 | Project 2 | Address 2
Bid Pending Award
Desired Outcome
Bid Pending Award | Georgia | Negotiated | PC1002 | Project 2 | Address 2 | 1 | 0.75 | 2020-03-23 00:00:00 | 14087 | No | 2021-03-01 00:00:00
Bid Pending Award | Georgia | Hard Bid | PC1003 | Project 3 | Address 3 | 1 | 1 | 2020-08-21 00:00:00 | 156304 | Yes | 2021-03-21 00:00:00
Bid Pending Award | Mid-Atlantic | Negotiated | PC1007 | Project 7 | Address 7 | 1 | 1 | 2020-12-30 00:00:00 | 6232.46 | No | 2021-01-01 00:00:00 | 2021-01-22 00:00:00 | 1
Bid Pending Award | Mid-Atlantic | Negotiated | PC1008 | Project 8 | Address 8 | 1 | 1 | 2020-12-30 00:00:00 | 6103.52 | No | 2021-01-01 00:00:00 | 2021-01-22 00:00:00 | 1
Bid Pending Award | North Carolina | Hard Bid | PC1009 | Project 9 | Address 9 | 1 | 0.5 | 2020-12-09 00:00:00 | 116007 | No | 2021-01-01 00:00:00 | 2021-02-01 00:00:00
Bid Pending Award | North Florida | Negotiated | PC1015 | Project 15 | Address 15 | 1 | 1 | 2020-11-13 00:00:00 | 6975 | No | 2021-03-21 00:00:00 |  | 1
Bid Pending Award | North Florida | Negotiated | PC1016 | Project 16 | Address 16 | 2 | 1 | 2020-11-13 00:00:00 | 8975 | No | 2021-03-21 00:00:00 |  | 1
Bid Pending Award | South Florida | Hard Bid | PC1018 | Project 18 | Address 18 | 3 | 0.25 | 2021-01-29 00:00:00 | 123707.21 | No | 2021-03-01 00:00:00 | 2021-05-03 00:00:00 | 9
Bid Pending Award | West Florida | Hard Bid | PC1019 | Project 19 | Address 19 | 2 | 0.25 | 2021-03-01 00:00:00 | 78150 | No | 2021-04-21 00:00:00
Bid Pending Award | South Florida | Hard Bid | PC1020 | Project 20 | Address 20 | 1 | 0.25 | 2021-01-29 00:00:00 | 100360.33 | No | 2021-02-01 00:00:00 | 2021-03-28 00:00:00 | 9
Bid Pending Award | South Florida | Hard Bid | PC1021 | Project 21 | Address 21 | 1 | 0.25 | 2021-01-29 00:00:00 | 240628.23 | No | 2021-02-01 00:00:00 | 2021-04-28 00:00:00 | 12
Spreadsheet: 731201d1620227121-conditional-formatting-by-matching-dates-book1
Sheet: Sheet1

Start | Finish |  |  |  |  | 2021-03-01 00:00:00 | 2021-03-05 00:00:00 | 2021-03-08 00:00:00 | 2021-03-12 00:00:00 | 2021-03-15 00:00:00 | 2021-03-19 00:00:00 | 2021-03-22 00:00:00 | 2021-03-26 00:00:00 | 2021-03-29 00:00:00 | 2021-04-02 00:00:00 | 2021-04-05 00:00:00 | 2021-04-09 00:00:00
 |  |  |  |  |  | For example I'd like this background to appear by reading the start and end date for cell A4 and A5?
2021-03-01 00:00:00 | 2021-03-12 00:00:00
2021-03-01 00:00:00 | 2021-03-12 00:00:00
2021-03-22 00:00:00 | 2021-04-02 00:00:00
2021-04-05 00:00:00 | 2021-04-09 00:00:00
2021-04-05 00:00:00 | 2021-04-09 00:00:00
2021-04-05 00:00:00 | 2021-04-09 00:00:00
2021-04-05 00:00:00 | 2021-04-09 00:00:00
2021-04-05 00:00:00 | 2021-04-09 00:00:00
Spreadsheet: 858720d1707302328-summary-table-lease-liability-sumif-filter-lease-liability-summary-problem
Sheet: Sheet1

Lease Liability - Data Table
Finance Org | Asset No | Asset Class | 2023-07-31 00:00:00 | 2023-08-31 00:00:00 | 2023-09-30 00:00:00 | 2023-10-31 00:00:00 | 2023-11-30 00:00:00 | 2023-12-31 00:00:00 | 2024-01-31 00:00:00 | 2024-02-29 00:00:00 | 2024-03-31 00:00:00 | 2024-04-30 00:00:00 | 2024-05-31 00:00:00 | 2024-06-30 00:00:00 | 2024-07-31 00:00:00 | 2024-08-31 00:00:00 | 2024-09-30 00:00:00
Bank A | EX01 | EX | 12883.69 | 12883.69 | 12883.69 | 12883.69 | 12883.69 | 12883.69 | 12883.69 | 12883.69 | 12883.69 | 12883.69 | 12883.69 | 12883.69 | 12883.69
Bank C | EX02 | EX | 28975.07 | 28975.07 | 28975.07 | 28975.07 | 28975.07 | 28975.07 | 28975.07 | 28975.07 | 28975.07 | 28975.07 | 28975.07 | 28975.07 | 28975.07 | 28975.07 | 28975.07
Bank B | GR33 | GR | 16403.51 | 16403.51 | 16403.51 | 16403.51 | 16403.51 | 16403.51 | 16403.51 | 16403.51 | 16403.51 | 16403.51
Bank A | DT41 | DT | 21596.13 | 21596.13 | 21596.13 | 21596.13 | 21596.13 | 21596.13 | 21596.13 | 21596.13 | 21596.13 | 21596.13 | 21596.13 | 21596.13
Bank C | WL20 | WL | 14006.89 | 14006.89 | 14006.89 | 14006.89 | 14006.89 | 14006.89 | 14006.89 | 14006.89 | 14006.89 | 14006.89 | 14006.89 | 14006.89 | 14006.89 | 14006.89
Summary Table - Example
Finance Org | Asset No | Asset Class | Date from | Liability
Bank A | EX01 | EX | 2023-09-30 00:00:00 |  | sum of liability from the month after 30/9/23 |  |  |  |  | EX01 | EX | 2023-09-30 00:00:00 | 128836.9
Bank A | DT41 | DT | 2023-09-30 00:00:00 |  | sum of liability from the month after 30/9/23 |  |  |  | Bank A | DT41 | DT | 2023-09-30 00:00:00 | 194365.17
Flexability to select Finance Org / Asset No. / Asset Class / Date & or all of the above
The Liability number is the value I am needing to report on.
Summary Table - Example
Finance Org | Asset No | Asset Class | Date from | Liability
Bank A | EX01 | EX | 2023-12-31 00:00:00 |  | sum of liability from the month after 31/12/23 |  |  |  |  | EX01 | EX | 2023-12-31 00:00:00 | 90185.83
Bank C | EX02 | EX | 2023-12-31 00:00:00 |  | sum of liability from the month after 31/12/23 |  |  |  | Bank C | EX02 | EX | 2023-12-31 00:00:00 | 260775.63
Spreadsheet: 91316d1291071008-showing-formula-results-excel-2010-test-1
Sheet: Dashboard

 | Global |  |  |  | NA West |  |  |  | NA North |  |  |  | NA South |  |  |  | LAPS |  |  |  | EU |  |  |  | MEA |  |  |  | Asia |  |  |  | China
 | #Def | #[NAME] | %Def |  | #Def | #[NAME] | %Def |  | #Def | #[NAME] | %Def |  | #Def | #[NAME] | %Def |  | #Def | #[NAME] | %Def |  | #Def | #[NAME] | %Def |  | #Def | #[NAME] | %Def |  | #Def | #[NAME] | %Def |  | #Def | #[NAME] | %Def
SAP# | 9 | 644 | 0.01397515527950311 |  | 4 | 109 | 0.03669724770642202 |  | 3 | 99 | 0.0303030303030303 |  | 0 | 98 | 0 |  | 0 | 60 | 0 |  | 2 | 83 | 0.02409638554216868 |  | 0 | 167 | 0 |  | 0 | 28 | 0 |  | 0 | 0 | #N/A
Project Type | 0 | 644 | 0 |  | 0 | 109 | 0 |  | 0 | 99 | 0 |  | 0 | 98 | 0 |  | 0 | 60 | 0 |  | 0 | 83 | 0 |  | 0 | 167 | 0 |  | 0 | 28 | 0 |  | 0 | 0 | #N/A
Role | 6 | 644 | 0.009316770186335404 |  | 1 | 109 | 0.009174311926605505 |  | 0 | 99 | 0 |  | 0 | 98 | 0 |  | 0 | 60 | 0 |  | 0 | 83 | 0 |  | 5 | 167 | 0.02994011976047904 |  | 0 | 28 | 0 |  | 0 | 0 | #N/A
FE assigned | 44 | 644 | 0.06832298136645963 |  | 4 | 109 | 0.03669724770642202 |  | 6 | 99 | 0.06060606060606061 |  | 10 | 98 | 0.1020408163265306 |  | 4 | 60 | 0.06666666666666667 |  | 9 | 83 | 0.108433734939759 |  | 10 | 167 | 0.05988023952095808 |  | 1 | 28 | 0.03571428571428571 |  | 0 | 0 | #N/A
PM | 1 | 644 | 0.001552795031055901 |  | 0 | 109 | 0 |  | 0 | 99 | 0 |  | 0 | 98 | 0 |  | 0 | 60 | 0 |  | 1 | 83 | 0.01204819277108434 |  | 0 | 167 | 0 |  | 0 | 28 | 0 |  | 0 | 0 | #N/A
0.05
0.1
0.15
Spreadsheet: 854830d1704589890-if-and-to-get-a-name-from-a-list-based-on-date-and-time-plus-extract-tl-name-daily-tl-report-mente73-
Sheet: TL Daily Shifts

 | 2024-01-01 00:00:00 | IN | OUT
 | 02444 Cespedes [NAME] | 06:00:00 | 15:30:00
 | 02461 Badilla Monge Nilly Michelle | 13:30:00 | 22:00:00
 | 02280 [NAME] Valeria | 21:00:00 | 03:00:00
 |  | IN | OUT
 | 02003 [NAME] [NAME] | 06:00:00 | 13:30:00
 | 02254 Quiros Ruiz Jose Daniel | 13:30:00 | 21:00:00
 | 02280 [NAME] Valeria | 20:00:00 | 02:00:00
 | 02211 Rouse [NAME] | 23:45:00 | 05:45:00
Spreadsheet: 869952d1716479362-monthly-calendar-with-recurring-activities-spanning-several-days-monthly-calendar-example-aligw
Sheet: Calendar

 | May |  |  |  |  |  | 2024
 | SUNDAY
 |  | 2024-04-29 00:00:00 | 2024-04-30 00:00:00 | 2024-05-01 00:00:00 | 2024-05-02 00:00:00 | 2024-05-03 00:00:00 | 2024-05-04 00:00:00
 |  | 2024-05-06 00:00:00 | 2024-05-07 00:00:00 | 2024-05-08 00:00:00 | 2024-05-09 00:00:00 | 2024-05-10 00:00:00 | 2024-05-11 00:00:00
 |  | 2024-05-13 00:00:00 | 2024-05-14 00:00:00 | 2024-05-15 00:00:00 | 2024-05-16 00:00:00 | 2024-05-17 00:00:00 | 2024-05-18 00:00:00
 |  |  |  | Activity 3 | Activity 3 | Activity 3 | Activity 3
 |  | 2024-05-20 00:00:00 | 2024-05-21 00:00:00 | 2024-05-22 00:00:00 | 2024-05-23 00:00:00 | 2024-05-24 00:00:00 | 2024-05-25 00:00:00
 | Activity 3 | Activity 5 | Activity 5 | Activity 5 | Activity 5
 |  | 2024-05-27 00:00:00 | 2024-05-28 00:00:00 | 2024-05-29 00:00:00 | 2024-05-30 00:00:00 | 2024-05-31 00:00:00 | 2024-06-01 00:00:00
 |  | 2024-06-03 00:00:00 | Notes:
Spreadsheet: louise_kitchen__24243__SepYTD Orig w notes Revised
Sheet: Restructuring

Restructuring
By Team
Originator |  | Commodity |  | Team |  | Total |  | %Total
MPR Activity
Lydecker |  | Venoco |  | Restructuring |  | 2129000
Lydecker |  | Other |  | Restructuring |  | 912000
Lydecker |  | [NAME] |  | Restructuring |  | 551000
Lydecker |  | Industrial Holdings |  | Restructuring |  | 500000
Lydecker |  | [NAME] |  | Restructuring |  | 410000
Lydecker |  | Hornbeck-Leevac |  | Restructuring |  | 0
Lydecker |  | LSI Preferred |  | Restructuring |  | -662000
Lydecker |  | City Forest Energy Advisory |  | Restructuring |  | -749000
Lydecker |  | EnSerCo Offshore ([NAME]) |  | Restructuring |  | -838000
Lydecker |  | Treasury Swap A |  | Restructuring |  | -999000
Lydecker |  | [NAME] |  | Restructuring |  | -1023000
Lydecker |  | Alpine Natural Gas |  | Restructuring |  | -2548000
Lydecker |  | Hanover Compressor |  | Restructuring |  | -4209000
Lydecker |  | Heartland Steel |  | Restructuring |  | -4381000
Lydecker |  | Inland |  | Restructuring |  | -4381000
Total