tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 807647d1669983694-is-there-a-fortnight-formula-like-eomonth-loan-amortisation-schedule1
Sheet: Loan Schedule

 |  | Loan Amortisation Schedule
 | Enter Values |  |  |  |  | Loan Summary
 | Loan amount |  |  | 5000 |  | Scheduled payment
 | Annual interest rate |  |  | 0.04 |  | Scheduled number of payments
 | Loan period in years |  |  | 1 |  | Actual number of payments
 | Number of payments per year |  |  | 12 |  | Total early payments
 | Start date of loan |  |  |  |  | Total interest
 | Optional extra payments |  |  | 100 |  | Lender name |  | Woodgrove Bank
 | Payment Number | Payment Date | Beginning Balance | Scheduled Payment | Extra Payment | Total Payment | Principal | Interest | Ending Balance | Cumulative Interest
Spreadsheet: monika_causholli__28120__Fiber Morphology1
Sheet: Sheet1

SPECIES OF PULPWOOD - FIBER CHARACTERISTICS
English Name | Latin Name | Origin | Pulp [NAME] | [NAME] |  | Wall Thickness |  | Wall Fraction | Fiber | Basic or Bulk Density | Ash | Cellulose DP
 |  |  | Description | Range | Average | Range | Average |  | Coarseness | OD Weight/Green Volume
SOFTWOOD - CONIFEROUS SPECIES
BC Interior
BC Coast
Pacific Fir
Western White Fir
Western Larch
Spruce
[NAME]
[NAME] or Radiata Pine
Loblolly Pine
[NAME] (High DF Pulps)
Western Red Cedar
HARDWOOD-BROADLEAF SPECIES
White Ash
European Ash
Sycamore
Red Maple
[NAME]
Paper (White) Birch
European Birch
Silver Birch
Red Gum
[NAME] or [NAME]
[NAME]
Southern Blue Gum
Giant Gum
[NAME]
American Beech
European Beech
American Red or Sweet Gum
Black Gum
European Poplar
European Aspen
American Aspen
[NAME]
[NAME]
[NAME]
[NAME] (Gmelina)
[NAME] ([NAME])
Southern Mixed HW (Hi Oak)
Southern Mixed HW (Low Oak)
[NAME] (Indonesia)
Spreadsheet: 21bd02d2-2822-4ba6-83ea-5cb3855e2001
Sheet: Sheet1

CSI022 | Fig. 5 | Percentage of European coastal bathing waters complying with mandatory values (or with at least sufficient quality) and meeting guide values (or with excellent quality) for the year 2011 by sea region | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
 | Table underpinning Fig.5 (sea regions arranged by the percentage):
 | Sea region | Number of bathing waters | Compliance with mandatory values or at least sufficient quality |  | Compliance with guide values or excellent quality
 |  |  | number | % | number | %
 | Black Sea (138) | 138 | 135 | 97.82608695652173 | 88 | 63.76811594202898
 | Mediterranean Sea (9989) | 9989 | 9540 | 95.50505556111723 | 8783 | 87.92671939133047
 | Greater North Sea (1643) | 1643 | 1550 | 94.33962264150944 | 1065 | 64.82045039561777
 | Europe (15525) | 15525 | 14515 | 93.49436392914654 | 12592 | 81.10789049919485
 | Baltic Sea (1218) | 1218 | 1126 | 92.44663382594418 | 832 | 68.30870279146141
 | Atlantic Ocean (2519) | 2519 | 2164 | 85.90710599444223 | 1824 | 72.40968638348551
Geographical coverage: | Mediterranean Sea, Atlantic Ocean, Greater North Sea, Baltic Sea, Black Sea
Data source: | WISE Bathing Water Quality database (data from annual reports by reporting countries)
Note: | Sea regions arranged by the percentage of compliance with mandatory values (or at least sufficient quality).
 | EU Member States, Croatia and Montenegro. Five Member States (Austria, the Czech Republic, Hungary, Luxembourg and Slovakia) and Switzerland have no coastal bathing waters.
 | The quality classes under the New Bathing Water Directive (2006/7/EC) are jointed with compliance categories under the Bathing Water Directive (76/160/EEC).
 | The sea region delineation is according to the Marine Strategy Framework Directive (MSFD) Article 4. As the catchment area of the North-east Atlantic Ocean region is very big, the sub-region level is used, i.e. the Greater North Sea incl. the Kattegat and the English Channel, while other subregions of the North-east Atlantic Ocean are merged into the Atlantic Ocean region. French bathing waters in the Northwest Atlantic Ocean are also included in the Atlantic Ocean region. The Mediterranean Sea region includes Spanish bathing waters on the African coasts. French bathing waters in the Indian Ocean are not included in regional statistics.
Spreadsheet: 70839d1271552071-excel-scheduler-car
Sheet: Sheet1

NAME | DATE | CAR REG | MAKE | MODEL | ENGINE | COLOR
rasel | 2010-04-18 00:00:00 | abc | Honda | Civic | 1.5 Petrol | Red
[NAME] | 2010-04-19 00:00:00 | def | Ford | Focus | 1.8 Diesel | Blue
tom | 2010-04-20 00:00:00 | ghi | VW | Polo | 2.0 Petrol | Green
jhon | 2010-04-21 00:00:00 | jkl | BMW | X5 | 2.0 Petrol | Green
kery | 2010-04-22 00:00:00 | mno | Vauxhall | Corsa | 1.2 Petrol | Black
Spreadsheet: 777863d1650643278-retrieving-average-data-cells-from-sheets-using-lists-test-data
Sheet: Analysis

InCAS Academic Analysis July 2021
Subject 1 |  |  |  | Subject 2
Select Class | Percentage with an Age Difference of < 0 Years | Percentage with an Age Difference of > 3 Years |  | Select Class | Percentage with an Age Difference of < 0 Years | Percentage with an Age Difference of > 3 Years |  | Class
6 |  |  |  | 2 |  |  |  | 1
2 |  |  |  | 3 |  |  |  | 2
3 |  |  |  | 1 |  |  |  | 3
5 |  |  |  | 5 |  |  |  | 4
4 |  |  |  | 6 |  |  |  | 5
1 |  |  |  | 4 |  |  |  | 6
Subject 3 |  |  |  | Subject 4
Select Class | Percentage with an Age Difference of < 0 Years | Percentage with an Age Difference of > 3 Years |  | Select Class | Percentage with an Age Difference of < 0 Years | Percentage with an Age Difference of > 3 Years
1 |  |  |  | 1
2 |  |  |  | 2
3 |  |  |  | 3
4 |  |  |  | 4
5 |  |  |  | 5
6 |  |  |  | 6
[NAME]
Select Class | Average Standardised Score
1
2
3
4
5
6
Spreadsheet: 718479d1613147828-isnumber-search-for-a-specific-word-project-tracking-experimental-1-
Sheet: Project 

Created Date | Project Location |  |  | Project Title / Description |  | PO # / Date |  | Terms |  |  | Our Project Manager |  |  | Customer Project Manager
 |  |  |  |  |  |  |  | BOD ? |  |  | Name |  |  | Name
 |  |  |  |  |  |  |  |  |  |  | [NAME] |  |  | [NAME]
 |  |  |  | BMS Job # |  | PO# |  | COM |  |  | Phone |  |  | Phone
Forecast Project Costs & Profit |  |  |  | Actual Project Costs & Profit |  | Proj. Close Date |  | Proj. Duration |  | Delay Reason (If Applicable) |  |  | Days In Our Court
Sold Price |  |  |  |  |  |  |  |  |  |  |  |  |  | LEAD DAYS | Order Date | Date Expected
Total Price With CO's |  |  |  |  |  | CO Explaination |  |  |  | Equipment Lead Time
CO 1 | CO Number |  |  | CO 1 Cost
CO 2 | CO Number |  |  | CO 2 Cost
Total CO Price |  |  |  | Total CO Cost
Profit |  |  |  | Actual Profit |  |  | CO Profit
Percentage |  |  |  | Actual Percentage |  |  | [NAME]
Projected Total Project Cost |  |  |  | Actual Total Cost
Projected Equipment Cost |  |  |  | Actual Equipment Cost
Projected Sub Contractor Cost |  |  |  | Actual Sub Contractor Cost
Equipment Vendors |  |  |  | Equipment Description |  |  |  |  |  |  |  | Original Quote | Additional Costs | Submittal |  | PO #
Sub Contractors |  |  |  | Sub Contractor Scope
 |  |  |  |  |  | LIFT PLAN |  |  |  |  |  | Original Quote | Additional Cost | Change Orders |  | PO #
Engineering / Coring / Testing and BOD |  |  |  |  |  | BOD REQUIRED |  |  |  |  |  |  |  |  |  |  | NULL | CO1 | CO2
Mechanical
Electrical
Sheet Metal & Duct
Controls
Rigging & Crane
Crane Rental Company
Pipe Fitting
Plumbing
Balancing
Insulation
Fire & Sprinkler
Cleaning & Misc
Spreadsheet: 547340d1510503270-filling-across-a-range-of-sheets-test
Sheet: No Worries

BOAT NAME
OWNER NAME
MOORING TYPE
ADDRESS
HOME TEL
MOBILE TEL
[NAME]
BOAT TYPE
LENGTH
HULL COLOUR
UPPER DECK
TENDER?
DURATION
FEE
NEXT INVOICE DUE DATE | 2017-11-12 00:00:00
INVOICE DUE DATE | INVOICE REMINDER DATE | INVOICE SENT DATE | DATE PAID | NOTES
2017-11-12 00:00:00
Spreadsheet: 31608d1227552747-dynamic-validation-without-using-named-ranges-validation-help
Sheet: Sheet1

 |  | Their code | Our code |  |  | Unique list of there codes |  | Unique list of our codes that match their codes
 |  | 1234 |  |  |  | 1234 | 1234 | A
 |  |  |  |  |  | 12345 | 1234 | B
 |  |  |  |  |  | 123456 | 1234 | C
 |  |  |  |  |  | 1234567 | 12345 | AB
 |  |  |  |  |  |  | 123456 | ABA
 |  |  |  |  |  |  | 123456 | ABB
 |  |  |  |  |  |  | 123456 | ABC
 |  |  |  |  |  |  | 123456 | ABD
 |  |  |  |  |  |  | 1234567 | ABCA
 |  | I would like a validation list in row "D6" that only shows our codes that pretain to their code.
 |  | for example:
 |  | if they use code 1234 the validation list would only show "A", "B", and "C"
 |  | if they use code 12345 the validation list would only show "AB"
Spreadsheet: 170513d1343306748-allocate-months-across-periods-in-which-they-fall-example-2
Sheet: Sheet1

 | Start | End | Term (months) | 2008-07-31 00:00:00 | 2009-07-31 00:00:00 | 2010-07-31 00:00:00 | 2011-07-31 00:00:00 | 2012-07-31 00:00:00 | 2013-07-31 00:00:00 | 2014-07-31 00:00:00 | 2015-07-31 00:00:00 | 2016-07-31 00:00:00 | 2017-07-31 00:00:00 | 2018-07-31 00:00:00 | 2019-07-31 00:00:00 | Total (check)
Original formula | 2009-08-19 00:00:00 | 2014-08-19 00:00:00 | 60
Attempt to turn to months | 2009-08-19 00:00:00 | 2014-08-19 00:00:00 | 60
Am aiming to achieve: | 2009-08-19 00:00:00 | 2014-08-19 00:00:00 | 60 | 0 | 0 | 11 | 12 | 12 | 12 | 12 | 1 | 0 | 0 | 0 | 0
Alternatively | 2009-08-19 00:00:00 | 2014-08-19 00:00:00 | 60 | 0 | 0 | 11.5 | 12 | 12 | 12 | 12 | 0.5 | 0 | 0 | 0 | 0
Spreadsheet: 835794d1688820130-summarize-data-with-2-variables-specimen-data
Sheet: Sheet1

Key items |  | Address 1 | Address 2 | Address 3 | Address 4 | Address 5 | Address 6 | Address 7 | Address 8 | Address 9 | Address 10 | Address 11 | Address 12 | Address 13 | Address 14 | Address 15 | Address 16
Model |  | Princeton | Creekview | Summerville | [NAME] | Creekview | Venice | Creekview | Summerville | Creekview | Creekview | Summerville | [NAME] | [NAME] | [NAME] | Princeton | Creekview
View |  | Preserve | Corner | Preserve | Preserve | Preserve | Lake | Preserve | Preserve | Lake | Preserve | Lake | Lake | Preserve | Corner | Preserve | Lake
Asking Price |  | 915000 | 897000 | 895000 | 630000 | 899000 | 650000 | 995000 | 899900 | 925000 | 949900 | 929000 | 759000 | 829000 | 699000 | 739900 | 899000
Days |  | 22 | 17 | 27 | 21 | 17 | 11 | 44 | 27 | 40 | 51 | 60 | 51 | 23 | 37 | 51 | 59
Bedrooms |  | 4 | 4 | 3 | 4 | 3 | 3 | 3 | 3 | 5 | 3 | 3 | 4 | 4 | 4 | 4 | 5
Bathrooms |  | 2 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 2 | 3
Garage |  | 3 | 3 | 3 | 2 | 3 | 2 | 3 | 3 | 3 | 3 | 3 | 2 | 2 | 2 | 3 | 3
SF |  | 2251 | 2491 | 2445 | 2032 | 2495 | 1852 | 2491 | 2434 | 2491 | 2491 | 2445 | 2032 | 2027 | 2032 | 2251 | 2491
Pool |  | Yes | Yes | Yes | NA | Salt | No | Yes | Yes | Salt | Yes | Yes | Salt | Salt | No | No | No
Spa |  | Yes | No | Yes | NA | Yes | NA | Yes | Yes | Yes | No | No | No | No | NA | No | No
Picture Window |  | No | No | No | NA | No | NA | No | No | Yes | No | No | Yes | Yes | NA | No | No
Views |  | 435 | 1029 | 666 | 461 | 502 | 939 | 516 | 300 | 392 | 442 | 1244 | 415 | 438 | 343 | 246 | 44
Views/Day
Saves |  | 34 | 53 | 47 | 36 | 34 | 29 | 26 | 23 | 23 | 21 | 19 | 16 | 12 | 11 | 7 | 4
Saves/Day |  |  | 53 | 47 | 36 | 34 | 29 | 26 | 23 | 23 | 21 | 19 | 16 | 12 | 11 | 7 | 4
 |  |  |  | Count of | Average Asking Price | Average Views/Day | Average Saves/Day
 |  |  | Princeton | 2 |  |  |  |  |  | 2 | 827450 | 12.29812834224599 | 4.272727272727272
 |  |  | Creekview | 6 |  |  |  |  | Creekview | 6 | 927483.3333333334 | 20.16642093920259 | 26.83333333333333
 |  |  | Summerville | 3 |  |  |  |  | Summerville | 3 | 907966.6666666666 | 18.83703703703704 | 29.66666666666667
 |  |  | [NAME] | 4 |  |  |  |  | [NAME] | 4 | 729250 | 14.60084609637039 | 18.75
 |  |  | Venice | 1 |  |  |  |  | Venice | 1 | 650000 | 85.36363636363636 | 29
Spreadsheet: 02518311-5b40-4a2d-b961-5c0ee54feba0
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5609.0 Housing Finance, Australia
 | TABLE 12. HOUSING LOAN OUTSTANDINGS TO HOUSEHOLDS (OWNER OCCUPATION AND INVESTMENT HOUSING)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Owner-occupied housing ;  [NAME] ; |  |  | Original | A2435226X | 2002-03-01 00:00:00 | 2011-02-01 00:00:00 | 108 | $ Millions | STOCK | Month | 1
Owner-occupied housing ;  Permanent Building Societies ; |  |  | Original | A2435228C | 2002-03-01 00:00:00 | 2011-02-01 00:00:00 | 108 | $ Millions | STOCK | Month | 1
Owner-occupied housing ;  Credit Co-operatives ; |  |  | Original | A2435230R | 2002-03-01 00:00:00 | 2011-02-01 00:00:00 | 108 | $ Millions | STOCK | Month | 1
Owner-occupied housing ;  Total Authorised Deposit-taking Institutions (ADIs) ; |  |  | Original | A2435232V | 2002-03-01 00:00:00 | 2011-02-01 00:00:00 | 108 | $ Millions | STOCK | Month | 1
Investment housing ;  [NAME] ; |  |  | Original | A2435227A | 2002-03-01 00:00:00 | 2011-02-01 00:00:00 | 108 | $ Millions | STOCK | Month | 1
Investment housing ;  Permanent Building Societies ; |  |  | Original | A2435229F | 2002-03-01 00:00:00 | 2011-02-01 00:00:00 | 108 | $ Millions | STOCK | Month | 1
Investment housing ;  Credit Co-operatives ; |  |  | Original | A2435231T | 2002-03-01 00:00:00 | 2011-02-01 00:00:00 | 108 | $ Millions | STOCK | Month | 1
Investment housing ;  Total Authorised Deposit-taking Institutions (ADIs) ; |  |  | Original | A2435233W | 2002-03-01 00:00:00 | 2011-02-01 00:00:00 | 108 | $ Millions | STOCK | Month | 1
All residential housing ;  [NAME] ; |  |  | Original | A2435234X | 2002-03-01 00:00:00 | 2011-02-01 00:00:00 | 108 | $ Millions | STOCK | Month | 1
All residential housing ;  Permanent Building Societies ; |  |  | Original | A2435235A | 2002-03-01 00:00:00 | 2011-02-01 00:00:00 | 108 | $ Millions | STOCK | Month | 1
All residential housing ;  Credit Co-operatives ; |  |  | Original | A2435245F | 2002-03-01 00:00:00 | 2011-02-01 00:00:00 | 108 | $ Millions | STOCK | Month | 1
All residential housing ;  Total Authorised Deposit-taking Institutions (ADIs) ; |  |  | Original | A2435246J | 2002-03-01 00:00:00 | 2011-02-01 00:00:00 | 108 | $ Millions | STOCK | Month | 1
All residential housing ;  Securitisation Vehicles ; |  |  | Original | A2435238J | 2002-03-01 00:00:00 | 2011-02-01 00:00:00 | 108 | $ Millions | STOCK | Month | 1
All residential housing ;  Other Lenders ; |  |  | Original | A2435241W | 2002-03-01 00:00:00 | 2011-02-01 00:00:00 | 108 | $ Millions | STOCK | Month | 1
All residential housing ;  Total (Lender Housing) ; |  |  | Original | A2435244C | 2002-03-01 00:00:00 | 2011-02-01 00:00:00 | 108 | $ Millions | STOCK | Month | 1
© Commonwealth of Australia  2011
Spreadsheet: 99858d1298403281-calculating-fuel-economy-from-a-list-of-purchases-samplefile
Sheet: Single vehicle

Unit: | X | Input
Start Date: |  | Input
End Date: |  | Input
 | Gallons purchased: |  | [NAME]: |  | End Odometer: |  | Total Miles:
Outputs>
Vehicle Number | Transaction Date: | [NAME] | Gallons purchased
x
x |  |  |  |  | <-All purchases from unit X
x
Spreadsheet: 330716d1404835241-how-to-expand-rows-unit-quote
Sheet: Clean Air Transitions

Size | Flatbar | Sheet | Rd. Flg markup | Rd. Flg | Paint | Shop Rate | Total
12x12x13 | 4.5 | 12 | 20 | 15.38461538461538 | 5 | 137.1153846153846 | 194
12x12x14 | 4.5 | 12 | 21 | 16.15384615384615 | 5 | 154.3461538461538 | 213
12x14x14 | 4.75 | 14 | 21 | 16.15384615384615 | 5.5 | 174.5961538461538 | 236
12x14x15 | 4.75 | 14 | 23 | 17.69230769230769 | 5.5 | 192.0576923076923 | 257
14x14x15 | 5.5 | 15 | 23 | 17.69230769230769 | 6 | 210.8076923076923 | 278
14x14x16 | 5.5 | 16 | 23 | 17.69230769230769 | 5 | 233.8076923076923 | 301
14x16x16 | 5.5 | 16 | 23 | 17.69230769230769 | 7 | 249.8076923076923 | 319
14x16x18 | 5.5 | 18 | 26 | 20 | 8 | 267.5 | 345
14x18x18 | 5.75 | 19.2 | 26 | 20 | 9 | 287.05 | 367
14x20x18 | 6 | 20 | 26 | 20 | 10 | 306 | 388
14x20x20 | 6 | 22 | 26 | 20 | 11 | 326 | 411
14x24x20 | 6.8 | 26 | 31 | 23.84615384615385 | 12 | 341.3538461538461 | 441
14x24x22 | 6.8 | 28 | 31 | 23.84615384615385 | 13 | 361.3538461538461 | 464
14x28x22 | 7.3 | 32 | 31 | 23.84615384615385 | 14 | 381.8538461538461 | 490
14x28x24 | 7.3 | 34 | 34 | 26.15384615384615 | 15 | 382.5461538461539 | 499
14x32x24 | 8.2 | 40.5 | 34 | 26.15384615384615 | 16 | 420.1461538461539 | 545
14x38x24 | 9.1 | 44.5 | 34 | 26.15384615384615 | 17 | 439.2461538461538 | 570
14x38x26 | 9.1 | 46.5 | 34 | 26.15384615384615 | 18 | 459.2461538461538 | 593
14x38x28 | 9.1 | 49.5 | 38 | 29.23076923076923 | 19 | 476.1692307692308 | 621
14x44x28 | 10 | 54.5 | 38 | 29.23076923076923 | 20 | 496.2692307692308 | 648
14x44x30 | 10 | 61 | 40 | 30.76923076923077 | 21 | 514.2307692307693 | 677
Spreadsheet: 708369d1607766541-for-every-row-that-contains-a-certain-piece-of-text-in-another-cell-give-a-sum-of-this-leave-tracker-v1
Sheet: Summary

Crew Member | 2021 PTO | Carry Over 2020 | Working Bank Holiday (1.5 days in lieu) | Not Working Bank Holiday | Total
Analyst 1 | 27 | 0
Analyst 1 | 27
Analyst 1 | 27
Analyst 1 | 27
Analyst 1 | 27
Analyst 1 | 27
Analyst 1 | 27
Analyst 1 | 27
Analyst 1 | 27
Analyst 1 | 27
IN
PTO
TIL
Working Bank Holiday (1.5 days in lieu)
Not Working Bank Holiday
Study Leave
Training
Spreadsheet: 138996d1328032514-excel-2008-bypassing-the-3-conditional-formatting-limit-in-office-08-mac_vacation_planner_final
Sheet: Summary

 |  |  |  |  |  |  |  |  |  | Start Date | 2012-01-01 00:00:00
Vacation Planner
Name | Date of Joining | Days Entitled to if 100% | Working Time | Vacation Entitlement this Year | Remaining Leave Last Year | Total Vacation Entitlement this Year | Vacation Planned | [NAME] this Year | Sick Days | Day of Working % Change | New # of Days Off
Peppina | 2011-01-01 00:00:00 |  | 80
Peppinb | 2011-01-05 00:00:00 |  | 100
Peppinc | 2011-01-05 00:00:00 |  | 60
Spreadsheet: 885263d1734712116-excel-function-that-can-take-an-array-value-for-rates-for-npv-with-multiple-rates-xnpv
Sheet: Sheet1

Rate | Dates | Values
START> | 2024-12-31 00:00:00 | 1256023.32
0.12 | 2025-09-14 00:00:00 | 3670998.19
0.07 | 2026-01-07 00:00:00 | 567283.99
0.06 | 2027-02-28 00:00:00 | 4226362.05
0.09 | 2027-05-28 00:00:00 | 7389020.34
0.15 | 2028-12-18 00:00:00 | 10455837.28
0.17 | 2029-05-09 00:00:00 | 14375800.65
Spreadsheet: 65178d1265895404-print-range-of-cells-factory-kpis-2010-2011new
Sheet: CNC Efficiency

 |  |  | Nr of operatives who produced data | 0 |  | CNC EFFICIENCY
Week commencing |  |  | Days under review | 0
 |  |  | Avg hours worked per week | 40.5 |  | 0
* denotes an input cell
 | Mins downtime
Weekly downtime by category (mins) |  |  | Total available hrs | 40.5
No Works Orders | 0 |  | Total available mins | 2430 | available hours * 60 - breaktimes
[NAME] | 0 |  | Avg Daily Downtime per person (mins) | #N/A | total downtime/nr of days under review/ nr of people |  |  |  |  |  | HOURS
Maintenance | 0 |  | % downtime | 0 | mins downtime / available mins *100 |  |  |  |  | MON | 8.5
Setting Rebate Jig Up | 0 |  | % uptime | 1 | 100 - % downtime |  |  |  |  | TUE | 8.5
Breakdown | 0 |  | CNC routed mins | 0 |  |  |  |  |  | WED | 8.5
Door Rebates | 0 |  | Nr of operatives working in the dept | 0 | Avg nr of people working in the dept |  |  |  |  | THUR | 8.5
Worktop bolt | 0 |  | Average weekly downtime by dept (mins) | #N/A | Avg nr of people working in the dept * avg downtime per person |  |  |  |  | FRI | 6.5
Change Tool | 0 |  | weekly Cost @ £10 p/h | #N/A | average weekly downtime by dept * £10 per hr |  |  |  |  |  | 40.5
[NAME] | 0 |  | Annual cost at this rate (46 working wks) | #N/A
Setting New Bed Up | 0
Total downtime (mins) | 0
Spreadsheet: 761521d1640975681-combine-multiple-sheets-into-one-example-sheet
Sheet: Export 1

Export Origin | Data Heading | Data Heading | Data Heading
Export 1 | Data from export | Data from export | Data from export
Export 1 | Data from export | Data from export | Data from export
Export 1 | Data from export | Data from export | Data from export
Export 1 | Data from export | Data from export | Data from export
Spreadsheet: 22178d1210781551-how-to-locate-a-value-and-display-the-match-item-sample-1
Sheet: Sheet1

Player | Game 1 | Game 2 | Game 3
AAA | 150 | 144 | 222
BBB | 148 | 110 | 133
CCC | 198 | 125 | 141
DDD | 166 | 158 | 151
EEE | 158 | 201 | 161
FFF | 147 | 220 | 180
Player
AAA | 222 | 1st
FFF | 220 | 2nd
EEE | 201 | 3rd
CCC | 198 | 4th
Spreadsheet: 782751d1654239634-finding-the-min-and-max-of-alphanumeric-values-based-on-multiple-criteria-max-min-bins-alphanumeric-ef-aligw
Sheet: Sheet1

ID | C1 | C2 | [NAME] | BIN |  |  | C1 | C2 | [NAME] | BIN_MIN | BIN_MAX
5 | A | F | L | AA506 |  |  | A | M | L
2 | A | F | L | AA610 |  |  | A | F | L
6 | A | F | L | AB066 |  |  | A | F | M
3 | A | F | L | AB076 |  |  | B | F | N
765 | A | F | M | AB224 |  |  | A | M | M
764 | A | F | M | AB283 |  |  | B | M | L
763 | A | F | M | AB293 |  |  | B | F | L
766 | A | F | M | [NAME]
4 | A | M | L | [NAME]
1 | A | M | L | AA484
769 | A | M | M | AB113
762 | A | M | M | AB126
767 | A | M | M | AB130
3 | B | F | L | AD404
1 | B | F | L | AD422
2 | B | F | L | AD432
3349 | B | F | N | [NAME]
3350 | B | F | N | BD188
3348 | B | F | N | BD201
3347 | B | F | N | BD203
228 | B | M | L | AC101
214 | B | M | L | BA142
227 | B | M | L | BA145
189 | B | M | L | BA361
Spreadsheet: 8f34b9c2-642f-4459-8240-7d1f3460fac3
Sheet: Sheet1

analytica 2012 - Aussteller Liste | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
 | Suche über Produkt- und Dienstleistungsverzeichnis (9 [NAME]):
 | 7 Biotechnologie 7.10 Labortechnik für die Biotechnologie und LifeSciences 7.10.7 Robotik
Nr. | Firma | Land | Ort | PLZ | Halle/Stand
1 | FESTO AG & Co.KG | Deutschland | Esslingen | 73734 | B1.305
2 | Agilent Technologies Sales & Services GmbH & Co. [NAME] | Deutschland | Waldbronn | 76337 | A2.105/206
3 | BioTek Instruments GmbH | Deutschland | Bad Friedrichshall | 74177 | A3.330
4 | Chemspeed Technologies AG | [NAME] | Augst | 4302 | A1.435
5 | [NAME] | Deutschland | [NAME] | 82152 | B1.203/304
6 | INyDIA Labs | Spanien | Madrid | 28210 | A3.131
7 | Labcon North America Inc. | USA | Petaluma | CA 94954 | B1.232
8 | Sias AG | [NAME] | Hombrechtikon | 8634 | B1.524
9 | SPI GmbH Scientific Precision Instruments GmbH | Deutschland | Oppenheim | 55276 | B2.526
Spreadsheet: 299248d1393061537-first-payment-of-each-group-thau-khoan-ver2
Sheet: Ct

 |  |  |  |  |  |  |  | thu
Payment [NAME]
No | id | id code | Date | Content | Contract | Settlement |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tổng
 |  |  |  | Tổng
Spreadsheet: 795781d1662936308-formulas-wanted-to-get-the-first-and-last-columns-where-non-zero-data-appears-get-first-and-last-cols-with-data-hd
Sheet: Sheet1

 |  | Empty fields are 0
 | Division | May-22 | Jun-22 | Jul-22 | Aug-22 | Sep-22 | Oct-22 | Nov-22 | Dec-22 | Jan-23 | Feb-23 | Mar-23 | Apr-23 | May-23 | Jun-23 | Jul-23 | Aug-23 | Sep-23 | Oct-23 |  | Start | End
 | Collaboration | 0 | 0 | 0 | 2 | 1 | 0 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Commercial | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 3 | 0 | 2 | 0 | 0 | 0 | 0 | 0
 | Eng | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  |  | These interim calcs are not wanted
 | H&S | 0 | 4 | 4 | 4 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 2 | 0 | 0 | 0 | 0 | 0 | 0
 | HR | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Months to capture: | From: | To:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Expected values: | 2022-06-01 00:00:00 | 2023-04-01 00:00:00