tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 110679d1307294648-excel-2007-displaying-value-set-in-a-previous-row-lookups
Sheet: Sheet1

DATE | PRODUCT | PRICE |  |  |  |  |  |  |  |  |  |  |  |  | DATES
2011-01-01 00:00:00 | p1 | 1500 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-01-01 00:00:00
2011-01-01 00:00:00 | p2 | 2000 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-01-02 00:00:00
2011-01-20 00:00:00 | p1 | 1550 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-01-03 00:00:00
2011-01-31 00:00:00 | p2 | 1900 |  |  |  |  |  |  |  |  |  |  |  |  | 2011-01-04 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-01-05 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-01-06 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-01-07 00:00:00
EXAMPLE RESULT (1)… |  |  |  |  |  | EXAMPLE RESULT (3)… |  |  |  |  |  |  |  |  | 2011-01-08 00:00:00
This is straight forward |  |  |  |  |  | The price for p1 has changed but p2 is still unchanged since 1/1/2011 |  |  |  |  |  |  |  |  | 2011-01-09 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-01-10 00:00:00
DATE | 2011-01-01 00:00:00 |  |  |  |  | DATE | 2011-01-20 00:00:00 |  |  |  |  |  |  |  | 2011-01-11 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-01-12 00:00:00
PRODUCT | PRICE |  |  |  |  | PRODUCT | PRICE |  |  |  |  |  |  |  | 2011-01-13 00:00:00
p1 | 1500 |  |  |  |  | p1 | 1550 |  |  |  |  |  |  |  | 2011-01-14 00:00:00
p2 | 2000 |  |  |  |  | p2 | 2000 |  |  |  |  |  |  |  | 2011-01-15 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-01-16 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-01-17 00:00:00
EXAMPLE RESULT (2)… |  |  |  |  |  | EXAMPLE RESULT (4)… |  |  |  |  |  |  |  |  | 2011-01-18 00:00:00
No change by 1/5/2011 so the same is displayed as for 1/1/2011 |  |  |  |  |  | The price for p2 has changed but p1 is unchanged since 1/20/2011 |  |  |  |  |  |  |  |  | 2011-01-19 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-01-20 00:00:00
DATE | 2011-01-05 00:00:00 |  |  |  |  | DATE | 2011-02-01 00:00:00 |  |  |  |  |  |  |  | 2011-01-21 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-01-22 00:00:00
PRODUCT | PRICE |  |  |  |  | PRODUCT | PRICE |  |  |  |  |  |  |  | 2011-01-23 00:00:00
p1 | 1500 |  |  |  |  | p1 | 1550 |  |  |  |  |  |  |  | 2011-01-24 00:00:00
p2 | 2000 |  |  |  |  | p2 | 1900 |  |  |  |  |  |  |  | 2011-01-25 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-01-26 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-01-27 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-01-28 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-01-29 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-01-30 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-01-31 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2011-02-01 00:00:00
Spreadsheet: c546e8ea-ffec-44b8-8380-ba30219a5798
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
CORU | Test | CORU | Cobalt, Random, [NAME] | Cobalt, Random, U | Inductively Coupled Plasma-Mass Spectrometry (ICP-MS) | Plastic urine container with no metal cap or glued insert |  |  | 2 | mL | Collection Container/Tube: Clean, plastic urine collection container Submission Container/Tube: Plastic, 6-mL tube (Supply T465) or a clean, plastic aliquot container with no metal cap or glued insert [NAME]: 2 mL Collection Instructions: 1. Collect a random urine specimen. 2. See Metals Analysis-Collection and Transport in Special Instructions for complete instructions. Additional Information: High concentrations of gadolinium and iodine are known to interfere with most metals tests. If either gadolinium- or iodine-containing contrast media has been administered, a specimen should not be collected for 96 hours. | 0.4 mL | Hemolysis	NA Thawing	Warm OK; Cold OK Lipemia	NA Icterus	NA Other	NA | 0.0-1.9 mcg/L Reference values apply to all ages. | Thursday; 11 a.m. | 1 day | 7 days | 1 | 83018 |  |  |  |  | Rochester
CORU | [NAME] | URINE | [NAME] |  |  |  | Refrigerated | 28 days
CORU | Result | 60354 | Cobalt, Random, U | Cobalt, Random, U | Numeric |  |  |  |  | mcg/L |  |  |  |  |  |  |  |  |  | 5628-3 | Cobalt:MCnc:Pt:[NAME]:Qn:
Spreadsheet: 837580d1690270459-increasing-hours-to-accommodate-number-of-times-an-instructors-name-appears-academy-hours-aligw
Sheet: July

Name | Hours | Pay | 20 |  | AliGW
Stuti | 7
Taran | 10
Asis | 9.5
Chiraag | 7.5
Megha | 1.5
Soorya | 2.5
Amal | 4.5
 | Total
Spreadsheet: 850282d1700653923-creating-a-list-from-a-table-using-multiple-criteria-book2
Sheet: Tracker 2

Tracker 2
Item | Person | Date | Number
IP | [NAME] | 2023-08-04 00:00:00 | 6
IP | [NAME] | 2023-10-28 00:00:00 | 2
IP | Michelle | 2023-11-05 00:00:00 | 3
IPKL | Michelle | 2023-11-13 00:00:00 | 1
SO | [NAME] | 2023-11-20 00:00:00 | 1
Spreadsheet: 117125d1312467004-selective-columns-farthingstone-updated-old-format-
Sheet: bi

Bradley. [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HANDICAPPING
hole | par | stroke index | adjusted par | pts calc | [NAME] | strokes | points | PAR 3 | INDEX 1 | INDEX 2 | INDEX 3 | adjusted par | pts calc | [NAME] | points | handicap | handicap | handicap | catergory | Buffer Zone | css | Nett Differential | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nett | Nett
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | points | points
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 18 | 36
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | par 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out
total
Spreadsheet: dana_davis__4467__2000_Close_c
Sheet: Other Contacts

GROUP | Area | Contact | Phone Number | Pager Number | Mobile
COE | COE | Corp Helpline | [PHONE]
COE | ? | Brandee Sanborn | [PHONE]
COE | ? | [NAME] | [PHONE]
COE | ECCS | [NAME] | [PHONE]
COE | MM | [NAME] | [PHONE]
COE | AM/IM/PS | [NAME] | [PHONE]
COE | Technical | [NAME] | [PHONE]
TAX | TIS/EDS | [NAME] | [PHONE]
TAX | TIS/EDS | [NAME] | [PHONE]
TAX | Corp Tax | [NAME] | [PHONE]
TAX | TIS/EDS | [NAME] | [PHONE]
CORP CONSOL | Hyperion | [NAME] | [PHONE]
CORP CONSOL | Hyperion | [NAME] | [PHONE]
CORP CONSOL | Hyperion | [NAME] | [PHONE]
CORP CONSOL | Hyperion | [NAME] | [PHONE]
CORP CONSOL | Hyperion | [NAME] | [PHONE]
CORP CONSOL | Hyperion | [NAME] | [PHONE]
MSA |  | [NAME]
MSA |  | Debbie Yates
Spreadsheet: 704113d1605366232-find-and-replace-values-book3-copy
Sheet: Sheet1

name | Contains | Replace | Contains
1 oz Eau De Toilette Spray (unboxed) for Men | eau de toilette | 1 oz edt [NAME] (unboxed) for Men | eau de toilette
2.5 oz Eau De Toilette Spray (Tester) for Men edt | spray shampoo | 2.5 oz edt Spray (Tester) for Men edt | spray shampoo
Bond 1.6 oz  [NAME] shampoo for Men | eau de per | Bond 1.6 oz  [NAME] shampoo for Men | eau de per
shampoo 3.4 oz eau de perfume Spray (Tester) for Men | shampoo | shampoo 3.4 oz eau de perfume Spray (Tester) for Men | shampoo
body spray | body spray | body spray | body spray
Bond 1.6 oz Eau De Toilette Spray for Men | soap | Bond 1.6 oz edt Spray for Men | soap
Bond 1.6 oz Eau De Toilette Spray for Men |  | Bond 1.6 oz edt Spray for Men
Bond 1.6 oz Eau De Toilette Spray for Men |  | Bond 1.6 oz edt Spray for Men
Bond 1.6 oz Eau De Toilette Spray for Men |  | Bond 1.6 oz edt Spray for Men
soap |  | soap
Spreadsheet: 70663d1271362767-adjustable-template-projects-list-blank
Sheet: Sheet1

 |  |  |  |  |  | CONST. & MOD. PROJECTS LIST
Project & Address | Scope of Work | Contractor | Contract | Drawings |  | Mat.Delivery |  | Turnover |  | Last Visit | Commments | Follow up dates
 |  |  |  | Due |  | Due |  | Due
 |  |  |  | Act. |  | Act. |  | Act.
 |  |  |  | Rtrnd
 |  |  |  | Due |  | Due |  | Due
 |  |  |  | Act. |  | Act. |  | Act.
 |  |  |  | Rtrnd
 |  |  |  | Due |  | Due |  | Due
 |  |  |  | Act. |  | Act. |  | Act.
 |  |  |  | Rtrnd
 |  |  |  | Due |  | Due |  | Due
 |  |  |  | Act. |  | Act. |  | Act.
 |  |  |  | Rtrnd
 |  |  |  | Due |  | Due |  | Due
 |  |  |  | Act. |  | Act. |  | Act.
 |  |  |  | Rtrnd
 |  |  |  | Due |  | Due |  | Due
 |  |  |  | Act. |  | Act. |  | Act.
 |  |  |  | Rtrnd
 |  |  |  | Due |  | Due |  | Due
 |  |  |  | Act. |  | Act. |  | Act.
 |  |  |  | Rtrnd
 |  |  |  | Due |  | Due |  | Due
 |  |  |  | Act. |  | Act. |  | Act.
 |  |  |  | Rtrnd
 |  |  |  | Due |  | Due |  | Due
 |  |  |  | Act. |  | Act. |  | Act.
 |  |  |  | Rtrnd
 |  |  |  | Due |  | Due |  | Due
 |  |  |  | Act. |  | Act. |  | Act.
 |  |  |  | Rtrnd
 |  |  |  | Due |  | Due |  | Due
 |  |  |  | Act. |  | Act. |  | Act.
 |  |  |  | Rtrnd
 |  |  |  | Due |  | Due |  | Due
 |  |  |  | Act. |  | Act. |  | Act.
 |  |  |  | Rtrnd
 |  |  |  | Due |  | Due |  | Due
 |  |  |  | Act. |  | Act. |  | Act.
 |  |  |  | Rtrnd
 |  |  |  | Due |  | Due |  | Due
 |  |  |  | Act. |  | Act. |  | Act.
 |  |  |  | Rtrnd
 |  |  |  | Due |  | Due |  | Due
 |  |  |  | Act. |  | Act. |  | Act.
 |  |  |  | Rtrnd
 |  |  |  | Due |  | Due |  | Due
 |  |  |  | Act. |  | Act. |  | Act.
 |  |  |  | Rtrnd
 |  |  |  | Due |  | Due |  | Due
 |  |  |  | Act. |  | Act. |  | Act.
 |  |  |  | Rtrnd
 |  |  |  | Due |  | Due |  | Due
 |  |  |  | Act. |  | Act. |  | Act.
 |  |  |  | Rtrnd
 |  |  |  | Due |  | Due |  | Due
 |  |  |  | Act. |  | Act. |  | Act.
 |  |  |  | Rtrnd
 |  |  |  | Due |  | Due |  | Due
 |  |  |  | Act. |  | Act. |  | Act.
 |  |  |  | Rtrnd
 |  |  |  | Due |  | Due |  | Due
 |  |  |  | Act. |  | Act. |  | Act.
 |  |  |  | Rtrnd
 |  |  |  | Due |  | Due |  | Due
 |  |  |  | Act. |  | Act. |  | Act.
 |  |  |  | Rtrnd
 |  |  |  | Due |  | Due |  | Due
 |  |  |  | Act. |  | Act. |  | Act.
 |  |  |  | Rtrnd
 |  |  |  | Due |  | Due |  | Due
 |  |  |  | Act. |  | Act. |  | Act.
 |  |  |  | Rtrnd
Spreadsheet: 2221c500-1a35-40aa-b8bc-d710e0f6acb9
Sheet: 9a

Product |  | Cleared** | Uncleared | TOTAL
Swap* | Basis | 7043323 |  | 7043323
 | FRA | 32438401 |  | 32438401
 | Exotic
 | Inflation
 | IRS- [NAME] | 112278516 |  | 112278516
 | OIS | 19232322 |  | 19232322
 | VNS | <10,000 |  | <10,000
 | Zero Coupon | 221992 |  | 221992
With Optionality | Callable Swap
 | Cap/Floor
 | Debt Option
 | Exotic Option
 | Swaption
Cross-Currency | Exotic
 | Swap
TOTAL |  | 171214552 | N/A*** | 171214552
Estimated gross notional amount outstanding, December 21 weekly snapshot, by product type and tenor (millions of USD), all participant types and currencies. Data are adjusted for double-counting of cleared trades to show a single exposure for each trade.
Total(s) may be less than total shown for this asset class in the All Swaps reports and/or other CFTC Swaps Report tables if products were excluded from this table that (a) presented disclosure risk or (b) did not belong in the categories shown. See Explanatory Notes for more detail.
*See Data Dictionary for product descriptions and Explanatory Notes for data sources.
**See Explanatory Notes for cleared and uncleared descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL].
Spreadsheet: 733544d1621613127-sum-with-duplicates-dates-and-max-classeur2
Sheet: Feuil1

Phase | Clients | End date | Sq meters
Current OA | Client 1 | 2025-03-31 00:00:00 | 1256
Current OA | Client 2 | 2027-03-31 00:00:00 | 474.8
Current OA | Client 3 | 2022-10-31 00:00:00 | 1443.2
Current OA | Vacant | 2025-03-31 00:00:00 | 1263.8
Current OA | Parking | 2046-03-31 00:00:00 | 0
Current OA | Locaux entrepreneur immobilier | 2046-03-31 00:00:00 | 78.9
As Is Renewal | Client 6 | 2025-03-31 00:00:00 | 1443.2
As Is Renewal | Vacant | 2025-03-31 00:00:00 | 2397 |  | Duplicates
As Is Renewal | Vacant | 2046-03-31 00:00:00 | 2764.2
Fit up 100% | Client 1 | 2035-03-31 00:00:00 | 1256
Fit up 100% | Client 2 | 2037-03-31 00:00:00 | 474.8
Fit up 100% | Client 3 | 2035-03-31 00:00:00 | 1076
Current lease | Private client 4 | 2024-03-31 00:00:00 | 1133.2
Current lease | Private client 5 | 2023-11-30 00:00:00 | 0
What I need :
 | 1443,20+2764,20 |  |  |  |  | MS365
As Is Renewal |  | [NAME] that gives the addition of sq meter for this phase, but if there are any duplicates, the formula must only take into account the latest date.
 |  | Note that the phases will not be sorted all the time.
Current OA
Fit up 100% |  |  | No problem with these because there will never be duplicates.
Current lease
Spreadsheet: 283733d1386884756-error-in-deseasonalized-sales-forumla-array-starter
Sheet: A

Side Calculations
NumSalesPds
NumDataRows
DateTrendStarts
RowTrendStarts
Average Seasonal Index
Month | Average | SeasIndex
1
2
3
4
5
6
7
8
9
10
11
12
Totals
Seasonal Sales Data
Seq | Dates | ActSales | SlsRatio | DesSales | Forecast
 | 2009-01-01 00:00:00 | 144
 | 2009-02-01 00:00:00 | 105
 | 2009-03-01 00:00:00 | 107
 | 2009-04-01 00:00:00 | 105
 | 2009-05-01 00:00:00 | 133
 | 2009-06-01 00:00:00 | 123
 | 2009-07-01 00:00:00 | 241
 | 2009-08-01 00:00:00 | 219
 | 2009-09-01 00:00:00 | 164
 | 2009-10-01 00:00:00 | 176
 | 2009-11-01 00:00:00 | 176
 | 2009-12-01 00:00:00 | 201
 | 2010-01-01 00:00:00 | 178
 | 2010-02-01 00:00:00 | 230
 | 2010-03-01 00:00:00 | 143
 | 2010-04-01 00:00:00 | 168
 | 2010-05-01 00:00:00 | 203
 | 2010-06-01 00:00:00 | 229
 | 2010-07-01 00:00:00 | 231
 | 2010-08-01 00:00:00 | 158
 | 2010-09-01 00:00:00 | 151
 | 2010-10-01 00:00:00 | 124
 | 2010-11-01 00:00:00 | 119
 | 2010-12-01 00:00:00 | 141
 | 2011-01-01 00:00:00 | 139
 | 2011-02-01 00:00:00 | 175
 | 2011-03-01 00:00:00 | 225
 | 2011-04-01 00:00:00 | 168
 | 2011-05-01 00:00:00 | 113
 | 2011-06-01 00:00:00 | 136
 | 2011-07-01 00:00:00 | 163
 | 2011-08-01 00:00:00 | 198
 | 2011-09-01 00:00:00 | 147
 | 2011-10-01 00:00:00 | 113
 | 2011-11-01 00:00:00 | 102
 | 2011-12-01 00:00:00 | 100
 | 2012-01-01 00:00:00 | 90
 | 2012-02-01 00:00:00 | 144
 | 2012-03-01 00:00:00 | 294
 | 2012-04-01 00:00:00 | 176
 | 2012-05-01 00:00:00 | 172
 | 2012-06-01 00:00:00 | 206
 | 2012-07-01 00:00:00 | 210
 | 2012-08-01 00:00:00 | 218
 | 2012-09-01 00:00:00 | 193
 | 2012-10-01 00:00:00 | 172
 | 2012-11-01 00:00:00 | 123
 | 2012-12-01 00:00:00 | 151
 | 2013-01-01 00:00:00 | 153
 | 2013-02-01 00:00:00 | 162
 | 2013-03-01 00:00:00 | 167
 | 2013-04-01 00:00:00 | 174
 | 2013-05-01 00:00:00 | 166
 | 2013-06-01 00:00:00 | 205
 | 2013-07-01 00:00:00 | 275
 | 2013-08-01 00:00:00 | 284
 | 2013-09-01 00:00:00 | 260
 | 2013-10-01 00:00:00 | 196
 | 2013-11-01 00:00:00 | 167
 | 2013-12-01 00:00:00 | 45
 | 2014-01-01 00:00:00
 | 2014-02-01 00:00:00
 | 2014-03-01 00:00:00
 | 2014-04-01 00:00:00
 | 2014-05-01 00:00:00
 | 2014-06-01 00:00:00
 | 2014-07-01 00:00:00
 | 2014-08-01 00:00:00
 | 2014-09-01 00:00:00
 | 2014-10-01 00:00:00
 | 2014-11-01 00:00:00
 | 2014-12-01 00:00:00
 | 2015-01-01 00:00:00
Spreadsheet: 672044d1586701335-array-formula-help-with-error-in-the-array-array-query
Sheet: Sheet1

 |  | Plan Cases | Capacity
Product Name | Capacity cases per Day | 2020-04-06 00:00:00 | 2020-04-06 00:00:00
A | 1800
C | 15
D | 800 | 1764
E | 0 | 1764
 | Capacity Utilised
Spreadsheet: 376605d1423661659-assistance-in-linking-cells-into-several-worksheet-full-price-list-sample
Sheet: CON-LASH

Address : 60 Benoi Road F2 #02-11, SINGAPORE (629906)
Telephone : (65) 6265 8662            Fax : (65) 6265 7616
E-mail : [EMAIL]                 GST Reg No. 200708233N
No | IMPA No | ITEM | [NAME] | UNIT | CON-LASH | Remark
Spreadsheet: 763597d1642263792-look-for-last-instance-of-a-phrase-and-return-column-header-dashboard-setup
Sheet: Dashboard

Feature | Site1 | Site2 | Site3 | [NAME] | Site5 | Site6 | Site7 | Site8 | Site9
GLOBAL RELEASE
Environment Setup
Set up AWS Integration Infrastructure
DAX Integration
B2C Customer Group
B2B Customer Group
Initial Data Loads
Global Elements
Home Page
Global Cart
SHOPPING RELEASE
Product [NAME]
Product Listing Page & Search Results
Category Gateway Page
Login/Registration
Facets
Site Search
Inventory messaging
Product Kits (BOM)
Serialized Products & Core Charges
Product groups (Collections)
Product image zoom
Video in alt images
PowerReviews (Q&A / Customer reviews)
Pricing
Recently Viewed Products
Backorder Messaging
Kibo Personalization
Product Comparison NEW
CHECKOUT RELEASE
Cart
Checkout
Shipping Calculation
PayPal
Authorize.net
Avalara Tax / Tax Exempt / Address validation
Transactional emails
Coupons
Guest Checkout
Kount
Shipping Restrictions to HI and AK NEW
MY ACCOUNT RELEASE
Customer Service
GDPR + CCPA Compliance
My Account: Settings
My Account: Order History
Address book
My Account: Order Details
My Account: Order History shipping tracking
My Account: Favorite Parts (Wishlist) Management
My Account: Payment Methods
My Account: Returns
Google Analytics & GTM
DataLayer Support
Static Content Pages
301 Redirects
Google Shopping
Formstack
[NAME]
Klaviyo
My Account: Re-order
Blog
Test
Spreadsheet: 831738d1685859851-need-help-to-find-out-code-wise-rate-calculation-code-wise-rate-calculation-individual
Sheet: AGR

Code | [NAME] | Sr.No | From Date | To Date | From Load | To Load | Phase | [NAME] | Contract Demand | Rate/Month
AG |  | 34 | 2022-01-01 00:00:00 | 2022-01-31 00:00:00 | 1 | -- | -- | -- | -- | 20
AG |  | 35 | 2022-02-01 00:00:00 | 2022-03-31 00:00:00 | 1 | -- | -- | -- | -- | 20
AG |  | 36 | 2022-04-01 00:00:00 | 2022-06-30 00:00:00 | 1 | -- | -- | -- | -- | 20
AG |  | 37 | 2022-07-01 00:00:00 | 2022-09-28 00:00:00 | 1 | 7.5 | -- | -- | -- | 20
AG |  | 38 | 2022-07-01 00:00:00 | 2022-09-28 00:00:00 | 7.51 | 999 | -- | -- | -- | 20
AG |  | 39 | 2022-09-29 00:00:00 | 2022-12-31 00:00:00 | 7.51 | 999 | -- | -- | -- | 5
AG |  | 40 | 2022-09-29 00:00:00 | 2022-12-31 00:00:00 | 1 | 7.5 | -- | -- | -- | 10
AG |  | 41 | 2023-01-01 00:00:00 | 2023-03-31 00:00:00 | 7.51 | 999 | -- | -- | -- | 5
AG |  | 42 | 2023-01-01 00:00:00 | 2023-03-31 00:00:00 | 1 | 7.5 | -- | -- | -- | 10
AG |  | 43 | 2023-04-01 00:00:00 | -- | 7.51 | 999 | -- | -- | -- | 5
AG |  | 44 | 2023-04-01 00:00:00 | -- | 1 | 7.5 | -- | -- | -- | 10
Spreadsheet: 787298d1657720121-find-cell-based-on-date-index-and-matching-excelfiles1
Sheet: Blad2

What it should look like:
Transport | Last checkup | Next checkup week | Type of checkup
#1 | 2022-04-10 00:00:00 | 16 | GAS
#2 | 2022-03-25 00:00:00 | 16 | Oil,Gas,Battery
#3 | 2022-05-01 00:00:00 | 21 | Chain
… | … | … | …
Where I have been stuck
Transport | Last checkup | Next checkup | Type of checkup
#1
#2 |  | .=find first not empty cell after Last checkup and return date
#3 |  |  | .=get value of that cell
… | … | … | …
Spreadsheet: 847004d1698113550-calculate-1-minute-avergae-from-irregular-data-sample
Sheet: Sheet2

 |  | Number of "15 mins" | [NAME] reading each "15 mins" |  | Date-Time | Estimate reading
Date | Reading |  |  |  | 00:15:00
2022-04-27 09:45:00 | 36354776
2022-05-06 13:02:00 | 36825824
2022-05-13 10:39:00 | 37154325
2022-05-27 09:00:00 | 37382067
2022-06-09 11:57:00 | 38039704
2022-06-15 10:15:00 | 38341683
2022-06-23 12:55:00 | 38801428
2022-06-30 09:24:00 | 39149343
2022-07-05 09:24:00 | 39425617
2022-07-14 08:40:00 | 39868217
2022-07-21 15:46:00 | 40186389
2022-08-12 12:56:00 | 41426343
2022-08-16 10:04:00 | 41633560
2022-08-23 09:15:00 | 41834885
2022-09-02 09:11:00 | 42140615
2022-09-09 12:34:00 | 42490336
2022-09-15 13:18:00 | 42633516
2022-09-22 10:17:00 | 42890068
 |  |  |  |  |  |  | c
 |  |  |  |  |  |  | x
Spreadsheet: 719066d1613491799-counting-based-on-multiple-variables-training-database
Sheet: Database

 | Location: |  | F = first training attended |  |  | 2020-11-04 00:00:00
 | Dates covering: 1 Oct - |  | A = attendee |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13
 |  |  |  | Training title | Basic Covid IPC | Triage | Autoclave | IPC of Medical Devices | Environmental Cleaning | Covid-19 screening | Transmission-based PPE | CHW training
 |  |  |  | Trainer name
 | Name | Gender | Position | Training date | 2020-11-04 00:00:00 | 2020-11-11 00:00:00 | 2020-11-11 00:00:00 | 2020-11-11 00:00:00 | 2020-11-12 00:00:00 |  | 2020-11-30 00:00:00 | 2021-01-21 00:00:00
1 |  | Male | PHCC Manager
2 |  | Female | Medical doctor |  | F
3 |  | Female | Medical doctor
4 |  | Male | Medical doctor |  | F | A |  |  |  |  | A
5 |  | Male | Medical doctor |  |  |  |  |  |  |  | F
6 |  | Female | Pharmacist |  | F |  |  |  |  |  | A
7 |  | Male | Pharmacy assistant |  |  |  |  |  |  |  | F
8 |  | Male | Pharmacy assistant |  | F |  |  |  |  |  | A
9 |  | Female | Lab tech |  | F
10 |  | Male | Lab tech |  | F |  | A | A
11 |  | Male | Registrar |  | F | A |  |  |  |  | A
12 |  | Male | Guard |  | F
13 |  | Male | Guard |  | F
14 |  | Male | Guard |  | F
15 |  | Male | Guard |  | F
16 |  | Male | Guard
17 |  | Male | Guard
18 |  | Male | Cleaning agent |  | F |  |  |  | A |  | A
19 |  | Female | Cleaning agent |  | F |  |  |  | A
20 |  | Male | Ambulance Driver |  | F
21 |  | Male | Ambulance Driver |  | F
22 |  | Male | Ambulance Driver |  | F
23 |  | Female | CHW |  | F |  |  |  |  |  | A
24 |  | Female | CHW |  | F
25 |  | Female | Nurse |  |  |  |  |  |  |  | F
26 |  | Male | Nurse |  |  | F
27 |  | Male | Nurse |  |  | F
28 |  | Female | Nurse |  | F | A
29 |  | Female | Nurse |  |  | F |  |  |  |  | A
30 |  | Female | Nurse |  | F | A |  |  |  |  | A
31 |  | Male | Nurse |  | F | A | A | A |  |  | A
 |  |  |  | Total attendees:
Spreadsheet: 681500d1591609762-concatenate-all-values-in-row-without-numbers-in-front-mappe1
Sheet: Tabelle1

526|Shrek985|Fiona 5982|Hood| Farquaad #5465 | 526 | Shrek985 | [NAME] 5982 | 563Hood | 5522 [NAME] #5465
Bear bsf|Godmother4525|_Felina|Bishop_54546 | Bear bsf | Godmother4525 | 5465_Felina | Bishop_54546 | 123
Puss '455|! Ben|Farquaad #5465|Pan5522|Pan5522 Farquaad #5465 | Puss '455 | 458! [NAME] | Farquaad #5465 | Pan5522 | Pan5522 [NAME] #5465
Pinocchio|Jonas007|Charming|Donkey ß856 | Pinocchio | Jonas007 | 5894 Charming | Donkey ß856 | 984b58
Spreadsheet: 8f8f1750-dfcd-4225-88e2-da7221dfc7c2
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Word Records | 80688900625 | Meredith Andrews | Open Up The Heavens | 2014-10-14 | Studio Series 3-Key CD Trax | Na | 9.99 | Y | NYP
Word Records | 80688806323 | Meredith Andrews | In Your Arms | 2010-04-06 | Studio Series 3-Key CD Trax | Ac | 9.99 | Y | Available
Word Records | 80688754228 | Meredith Andrews | [NAME] | 2008-04-29 | Studio Series 3-Key CD Trax | Ac | 9.99 | Y | Available
Word Records | 80688874223 | Meredith Andrews | Strong God | 2013-06-09 | Studio Series 3-Key CD Trax | Na | 9.99 | Y | Available
Word Records | 80688873721 | Meredith Andrews | Pieces | 2013-04-23 | Studio Series 3-Key CD Trax | Na | 9.99 | Y | Available
Word Records | 80688873622 | Meredith Andrews | Not For A Moment (After All) | 2013-05-07 | Studio Series 3-Key CD Trax | Na | 9.99 | Y | Available
Word Records | 80688806224 | Meredith Andrews | Only To Be Yours | 2010-04-20 | Studio Series 3-Key CD Trax | Ac | 9.99 | N | To Be Retired
Word Records | 80688806125 | Meredith Andrews | Come Home | 2010-04-20 | Studio Series 3-Key CD Trax | Ac | 9.99 | N | To Be Retired
Word Records | 80688806026 | Meredith Andrews | How Great Is The Love | 2010-04-06 | Studio Series 3-Key CD Trax | Ac | 9.99 | N | To Be Retired
Word Records | 80688776626 | Meredith Andrews | New Song We Sing, The | 2008-09-09 | Studio Series 3-Key CD Trax | Ac | 9.99 | N | To Be Retired
Word Records | 80688754327 | Meredith Andrews | You Invite Me In | 2008-09-09 | Studio Series 3-Key CD Trax | Ac | 9.99 | N | To Be Retired