tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 66081d1266768559-sum-of-actual-months-with-reducing-numbers-of-forecast-months-sum-of-actual
Sheet: Sheet1

 | MTD | MTD | MTD | MTD | MTD | MTD | MTD | MTD | MTD | MTD | MTD | MTD | YTD
 | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 | 2010-07-01 00:00:00 | 2010-08-01 00:00:00 | 2010-09-01 00:00:00 | 2010-10-01 00:00:00 | 2010-11-01 00:00:00 | 2010-12-01 00:00:00 | 2010-12-01 00:00:00
 | Actual | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast | Forecast
REVENUE | 0.6168490411197523 | 0.05553503649481772 | 0.5337969230390192 | 0.885393481184094 | 0.2811916242298993 | 0.5519776601441322 | 0.3510266113809886 | 0.6759623671836232 | 0.1648817214527991 | 0.02402658043668571 | 0.7182237310477246 | 0.1111375926349965 | 0.1788172684647205 |  | -7.223371224972307
Spreadsheet: 374142d1422684691-conditional-formatting-groups-of-rows-bookexample2_formula-added
Sheet: Desired Formatting

 |  | Below is the formatting I would like to create using a formula with conditional formatting.  The only reliable indicator of the beginning of a new set of rows is the first column, Date.
 | Date | Header2 | Data | MoreData
1 | 2094-10-25 00:00:00 | Item1 | Text
 | 2094-10-25 00:00:00 | Item2 |  | 10.08
 | 2094-10-24 00:00:00 | Item3 |  | 0.02
 | 2094-10-27 00:00:00 | Item4
 |  | It's possible there could be text here…
 |  | …so only the date is a reliable indicator. |  | 238
 |  |  |  | 24
 |  |  |  | 2423
 | 2094-10-27 00:00:00 | Item5 |  | 232
 |  |  |  | 2
 | 2094-10-28 00:00:00 | Item6 |  | 23
 |  |  |  | 23
 | 2094-10-29 00:00:00 | Item7 |  | 23.27
 |  |  |  | 12
 |  |  |  | 1000
 | 2094-10-29 00:00:00 | Item8 |  | 124
 | 2094-10-29 00:00:00 | Item9 |  | 4222
 |  |  |  | 424
 |  |  |  | 32
 | 2094-10-30 00:00:00 | Item11 |  | 2
 |  |  |  | 2
Spreadsheet: 85670d1285741818-sum-formula-for-totalling-certain-colours-book1
Sheet: Outstanding

Inv Date | Invoice No. | Customer | Invoiced (net) |  | Invoiced (gross) |  | Outstanding Total | 7039.09
2010-07-01 00:00:00 | 20034 | 1 | 80 |  | 94
2010-07-01 00:00:00 | 20035 | 2 | 568.75 |  | 668.28 |  |  |  |  | 2nd City Chem-Dry
2010-07-01 00:00:00 | 20036 | 3 | 530 |  | 622.75 |  | I need the above total to just |  |  | A&G Chem-Dry
2010-07-01 00:00:00 | 20037 | 4 | 496 |  | 582.8 |  | add up the values in red NOT |  |  | Alliance Chem-Dry
2010-07-01 00:00:00 | 20038 | 5 | 228 |  | 267.9 |  | the yellow amounts |  |  | Avon Valley Chem-Dry
2010-07-01 00:00:00 | 20039 | 6 | 1176.9 |  | 1382.86 |  |  |  |  | Capital Chem-Dry
2010-07-01 00:00:00 | 20040 | 7 | 1039.06 |  | 1220.9 |  | Note there are hundreds of |  |  | Celtic Chem-Dry
2010-07-02 00:00:00 | 20041 | 8 | 1872 |  | 2199.6 |  | these amounts usually, this is |  |  | Chem-Dry Belfast and Lagan Valley
 |  |  |  |  |  |  | for example purpose's only!! |  |  | Chem-Dry Central
 |  |  |  |  |  |  |  |  |  | Chem-Dry Charlie
 |  |  |  |  |  |  |  |  |  | Chem-Dry Direct
 |  |  |  |  |  |  |  |  |  | Chem-Dry Dirtbusters
 |  |  |  |  |  |  |  |  |  | Chem-Dry Essex
 |  |  |  |  |  |  |  |  |  | Chem-Dry Excel
 |  |  |  |  |  |  |  |  |  | Chem-Dry Flair
 |  |  |  |  |  |  |  |  |  | Chem-Dry Hereford & Worcester
 |  |  |  |  |  |  |  |  |  | Chem-Dry Professional
 |  |  |  |  |  |  |  |  |  | Chem-Dry Restoration
 |  |  |  |  |  |  |  |  |  | Chem-Dry Royale
 |  |  |  |  |  |  |  |  |  | Chem-Dry Service Clean
 |  |  |  |  |  |  |  |  |  | Chem-Dry UK Ltd
 |  |  |  |  |  |  |  |  |  | Cornerstone Management Services
 |  |  |  |  |  |  |  |  |  | Derwent Shared Services
 |  |  |  |  |  |  |  |  |  | Direct Line
 |  |  |  |  |  |  |  |  |  | Doncaster and Rotherham Chem-Dry
 |  |  |  |  |  |  |  |  |  | DRJ Chem-Dry
 |  |  |  |  |  |  |  |  |  | GAB Robins UK Ltd
 |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  | INCSSUN00 Sundry Sales
 |  |  |  |  |  |  |  |  |  | Ist Choice Chem-Dry
 |  |  |  |  |  |  |  |  |  | L.M. Property Solutions
 |  |  |  |  |  |  |  |  |  | [NAME]'s Chem-Dry
 |  |  |  |  |  |  |  |  |  | Midlands Response Ltd
 |  |  |  |  |  |  |  |  |  | Rainbow International [NAME]
 |  |  |  |  |  |  |  |  |  | Rainbow International Watford
 |  |  |  |  |  |  |  |  |  | Restore Ltd
 |  |  |  |  |  |  |  |  |  | Universal
 |  |  |  |  |  |  |  |  |  | White Rose
 |  |  |  |  |  | Re-issued to CD UK 09.09.10
Spreadsheet: 855253d1704893143-need-help-solving-excell-formula-for-leave-plan-test-leave-plan-admin-shifts
Sheet: Record

Namelist |  |  |  |  | ADMIN (exclude weekends and public holidays) |  |  |  |  | A SHIFT (exc restdays, include weekends and public holidays) |  |  |  |  | Summary of leave days deducted
Nr | Comp | Leave SD | Leave ED |  |  |  |  |  |  |  |  |  |  |  | Calender days | Total Leave days
[NAME] | [NAME] | 2024-01-02 00:00:00 | 2024-01-04 00:00:00
[NAME] | [NAME] | 2024-02-02 00:00:00 | 2024-02-04 00:00:00
[NAME] | [NAME] | 2024-03-02 00:00:00 | 2024-03-04 00:00:00
[NAME] | [NAME] | 2024-04-01 00:00:00 | 2024-04-04 00:00:00
[NAME] | [NAME] | 2024-01-26 00:00:00 | 2024-02-04 00:00:00
[NAME] | [NAME] | 2024-02-01 00:00:00 | 2024-03-04 00:00:00
[NAME] | a-shift | 2024-02-01 00:00:00 | 2024-02-04 00:00:00
[NAME] | a-shift | 2024-02-01 00:00:00 | 2024-03-04 00:00:00
[NAME] | a-shift | 2024-03-01 00:00:00 | 2024-03-04 00:00:00
Spreadsheet: 145445d1331582401-sum-different-sheet-based-on-2-criteria-book8
Sheet: March 2012

 |  | RTS | IS | DF | Ven
500031 | zz | 1 | 7 | 4 | 1
500100 | xx | 3 | 2 | 7 | 1
500102 | cc | 9 | 7 | 8 | 1
500103 | vv | 1 | 7 | 6 | 7
500104 | nn | 6 | 4 | 5 | 7
Spreadsheet: albert_meyers__1__1-25act
Sheet: Economics

 | Commodity Revenue (Cost) | Demand Charge | Total | Total Volume | $/Mwhr Commodity Cost | $/Mwhr Total Cost
Purchases
[NAME]. Cost Est. |  |  |  |  | 20 | 0
Incremental Purchases
[NAME]
4C Balancing
4C Realtime
[NAME]
PV Balancing
PV Realtime
SPS Pre
Artesia Balancing
Artesia Realtime
Sales
Incremental Sales
[NAME]
4C Balancing
4C Realtime
[NAME]
PV Balancing
PV Realtime
[NAME]
Artesia Balancing
Artesia Realtime
 |  |  |  |  |  |  | Heat | Fuel
Generation |  |  |  |  |  |  | Rate | Cost
4 Corners Unit 4 |  |  |  |  |  |  | 10.0576 | 1.3
4 Corners Unit 5 |  |  |  |  |  |  | 10.0576 | 1.3
PV Unit 1 |  |  |  |  |  |  | 10.16 | 0.6
PV Unit 2 |  |  |  |  |  |  | 10.16 | 0.6
PV Unit 3 |  |  |  |  |  |  | 10.16 | 0.6
Newman 1
Newman 2 |  |  |  |  |  |  |  | 1.96
Newman 3
GT 1
GT 2
GT1+ST1
GT2+ST1
Newman 4 |  |  |  |  |  |  |  | 1.96
Copper
Rio Grande 6
Rio Grande 7
Rio Grande 8
Total
Spreadsheet: 841588d1693758595-extract-data-from-table-depending-upon-entered-cells-to-work-for-every-row-sample-for-excel-forum-electrical-for-365-aligw
Sheet: Sheet1

 |  |  | Floor | Name | ``` | Room | , [NAME] | , Pendent Light | , 5 amp Wall light | , Door controlled light | , LED Strip  Light | , Wall up/Down | ,  1 Gang Switch | , 2 Gang Switch | , 3 Gang Switch | , 4 Gang Switch | , [NAME] | , [NAME] | , PIR | , Single Socket | , Double Socket | , 5A Wall Socket | , [NAME] power | , Velux power | , Shaver  Socket | , [NAME] | , Heated Mirror | , [NAME] | , Extractor | , [NAME] | , Appliances | , Isolator | , Mesh | , Door entry | , TV Point | , Router | , [NAME] | , [NAME] | , Pressureized Sys | , [NAME] | , Thermostat | , Ethernet point
 |  |  |  |  |  |  | 3 |  |  |  | 1 |  |  |  |  |  |  |  |  |  | 4 |  |  |  |  |  |  |  |  |  | 6 | 6
 |  |  |  |  |  |  | 4 | 2 |  |  |  |  | 1 | 1 | 3 |  |  |  |  |  | 4 |  |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1 |  |  |  |  |  | 1
 |  |  |  |  |  |  | 5 |  | 2 | 2 |  |  | 1 | 2 | 2 |  |  |  |  |  | 5 | 2
 |  |  |  |  |  |  | 5 |  | 2 | 2 |  |  |  |  |  |  |  |  |  |  | 5 | 2 |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  | 1
 |  |  |  |  |  |  | 2 |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  |  | 1
Spreadsheet: 218764d1362571871-need-a-formula-to-explain-to-a-smaller-unit-217-need-a-formula-to-explain-to-a-smaller-unit
Sheet: Sample

DATA |  |  |  |  |  |  | REPORT
 |  |  | NETTO |  |  |  |  |  |  | NETTO
MENU | QTY |  | ML |  | OZ |  | MENU | QTY |  | BTL | OZ
A | 1 | = | 750 | = |  |  | A | 1000 | =
B | 1 | = | 700 | = |  |  | B | 500 | =
C | 1 | = | 630 | = |  |  | C | 1000 | =
D | 1 | = | 500 | = |  |  | D | 1000 | =
E | 1 | = | 800 | = |  |  | E | 1000 | =
 |  |  |  |  |  |  | QUESTIONS
 |  |  |  |  |  | 1. | I need a function to automaticaly written on the Green area, as the explanation from QTY area
 |  |  |  |  |  | 2. | Is it possible to use Center Across Selection for a vertical text alignment? (in blue area)
 |  |  |  |  |  |  | Like horizontal text alignment that I used in the Yellow area
Spreadsheet: 90724d1290486575-changing-adding-colours-in-a-template-marketing-calendar
Sheet: INSTRUCTION

Salent Features
1 | The Calender can be set to 12 months starting from any month and year.
2 | The calender can have week starting with any day of the week.
3 | The list of events mentioned in the specific column will get highlighted, if the date is part of the calender.
4 | It highlights today's date, if it is part of the calender, based on the system date.
5 | Top 10 events after today's date is highlighted.
6 | Colour can be changed between GREEN, BLUE, RED, ORANGE, AQUA
7 | The calender gives the information of week number also.
8 | You can translate Month and week names in many languages. Also provision for adding 15 more languges additionally.
9 | Calculated number of working days based on the week start selected and holidays listed.
10 | A photo has been placed at the top center of the calender, which can be repleced of your own wish.
Assumption
1 | Five working days in a week, hence last two days are coloured in different for holidays. Adjust start of week according to requirement
Instruction
1 | Enter colour, language as per your choice.
2 | Enter the year and month you want to start with.
3 | Select the week you want to start the week.
4 | Enter events you wish to have as part of calender in column AH and AI. Also mark whether it is holiday or not, which is considered for calculating workdays.
Spreadsheet: 594559d1539851769-vlookup-on-this-situation-excelforum
Sheet: FIRST

 |  |  |  |  |  |  |  | Date
 |  |  |  |  |  |  | Doc. No. | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8
 | Date | Doc. No. | Value |  |  |  | 12345
 | 1 | 12345 | 7878 |  |  |  | 23456
 | 2 | 23456 | 8989 |  |  |  | 34567
 | 3 | 34567 | 4545 |  |  |  | 45678
 | 4 | 45678 | 5656 |  |  |  | 56789
 | 5 | 56789 | 1212
 | 6 | 34567 | 2323
 |  | 34567 | 3232
 | 7 | 23456 | 7979
 | 8 | 12345 | 4646
Spreadsheet: 48664d1247881284-excel-template-possible-for-this-jloyzaga-final-cl8-grades-dev
Sheet: Class Roster

Last Name | First Name | Class Number: | 8
Baines | Kelsey | Population: | 30
Barta | Bence
Cah | Aden
Cincotta | Emily
[NAME] | [NAME]
Dacey | [NAME]
Dacey | [NAME]
[NAME] | Tess
[NAME] | Callum
[NAME] | Martin
Hall | Emily
Jones-Hughes | Delwyn
Jost | [NAME]
Kamper | Olivia
Kelly | Siobhan
Lodhia | Sheena
[NAME] | [NAME]
[NAME] | [NAME]
[NAME] | [NAME]
O'Doherty | Alexandra
[NAME] | Hilary
Roose | [NAME]
Strijakova | Vara
[NAME] | [NAME]
Towers | Jessica
Ulich | Kristina
Walters | [NAME]
Wilde | [NAME]
[NAME] | [NAME]
Spreadsheet: f1b517b5-b824-49c1-bc0b-c34eadba13e5
Sheet: EPR CF

CONSOLIDATED STATEMENTS OF CASH FLOW ([NAME] and Condensed)
 | Three Months Ended
 | December 31,
 | 2011 |  | 2010
(In millions)
Operating
Net income | 49.3 |  | 73.70000000000005
Depreciation and amortization | 54.6 |  | 55.1
Other non-cash items | 23.2 |  | 17.2
Changes in operating assets and liabilities, excluding acquisitions:
Receivables | 30.2 |  | 18.6
Inventories | -22.3 |  | -13.9
Accounts payable and accrued liabilities | -57 |  | -54.8
Jackpot liabilities | -5.899999999999999 |  | -22.9
Income taxes, net of employee stock plans | -8.8 |  | 22
Other assets and deferred costs | 1.5 |  | 7.4
Net operating cash flows | 64.8 |  | 102.4
Investing
Capital expenditures | -49.2 |  | -42.3
Jackpot annuity investments, net | 6.799999999999999 |  | 10.3
Changes in restricted cash | -10.7 |  | 5.5
Loans receivable, net | 7.4 |  | 6.9
Other | 17 |  | 18.7
Net investing cash flows | -28.7 |  | -0.9
Financing
Debt related proceeds (payments), net | 0 |  | -80
Employee stock plans | 8.700000000000001 |  | 5.5
Share repurchases | -4.4 |  | 0
Dividends paid | -17.8 |  | -17.9
Net financing cash flows | -13.5 |  | -92.4
Foreign exchange rates effect on cash | 2.1 |  | 1.2
Net change in cash and equivalents | 24.7 |  | 10.30000000000002
Beginning cash and equivalents | 460 |  | 158.4
Ending cash and equivalents | 484.7 |  | 168.7
Spreadsheet: 482012d1474852400-new-empty-table-for-each-element-of-dropdown-list-city-example-button
Sheet: Sheet3

City | Criteria | 2012 | 2013 | 2014 | 2015 | 2016 | 2017
City 1 | Population | 1 | 1 | 1 | 1 | 1 | 1
 | GDP | 2 | 2 | 2 | 2 | 2 | 2
 | Life expectancy | 3 | 3 | 3 | 3 | 3 | 3
City 2 | Population | 4 | 4 | 4 | 4 | 4 | 4
 | GDP | 5 | 5 | 5 | 5 | 5 | 5
 | Life expectancy | 6 | 6 | 6 | 6 | 6 | 6
City 3 | Population | 7 | 7 | 7 | 7 | 7 | 7
 | GDP | 8 | 8 | 8 | 8 | 8 | 8
 | Life expectancy | 9 | 9 | 9 | 9 | 9 | 9
City 4 | Population | 10 | 10 | 10 | 10 | 10 | 10
 | GDP | 11 | 11 | 11 | 11 | 11 | 11
 | Life expectancy | 12 | 12 | 12 | 12 | 12 | 12
City 5 | Population | 13 | 13 | 13 | 13 | 13 | 13
 | GDP | 14 | 14 | 14 | 14 | 14 | 14
 | Life expectancy | 15 | 15 | 15 | 15 | 15 | 15
City 6 | Population | 16 | 16 | 16 | 16 | 16 | 16
 | GDP | 17 | 17 | 17 | 17 | 17 | 17
 | Life expectancy | 18 | 18 | 18 | 18 | 18 | 18
City 7 | Population | 19 | 19 | 19 | 19 | 19 | 19
 | GDP | 20 | 20 | 20 | 20 | 20 | 20
 | Life expectancy | 21 | 21 | 21 | 21 | 21 | 21
City 8 | Population | 22 | 22 | 22 | 22 | 22 | 22
 | GDP | 23 | 23 | 23 | 23 | 23 | 23
 | Life expectancy | 24 | 24 | 24 | 24 | 24 | 24
City 9 | Population | 25 | 25 | 25 | 25 | 25 | 25
 | GDP | 26 | 26 | 26 | 26 | 26 | 26
 | Life expectancy | 27 | 27 | 27 | 27 | 27 | 27
Spreadsheet: 864560d1711689843-condition-formula-severance-pay
Sheet: Sheet1

STAFF NAME | APPOINTMENT DATE | Termination Date | Monthly Salary | Service Time(Years) | Answer
Stephen | 2012-08-09 00:00:00 | 2024-06-30 00:00:00 | 10000
Agnes | 2017-05-01 00:00:00 | 2024-06-30 00:00:00 | 8000
[NAME] | 2021-04-01 00:00:00 | 2024-06-30 00:00:00 | 7000
Innocent | 2023-12-18 00:00:00 | 2024-06-30 00:00:00 | 2000
 | Condition | Entitlement
 | more than 6 months but less than 1 year | 2 Weeks pay
 | more than 12 months but less than 5 years | 1 Months pay
 | more than 5 years but less than 10 years | 2 Months pay
 | 10 years or more | 3 Months Pay
 |  |  |  | 1 | 0.5
 |  |  |  | 5 | 1
 |  |  |  | 10 | 2
 |  |  |  | 40 | 3
Spreadsheet: 776663d1649852731-count-no-of-cases-based-on-a-given-date-range-countnoofcase-1
Sheet: Defect

 | S/No | Car | Defect | WO/JR No. | Since | Status | Clear | >3 | No of Case | >7
 | 1 | 28 |  | NA | 2021-12-01 00:00:00 | Pending Investigation
 | 2 | 16 |  | NA | 2021-12-08 00:00:00 | Pending Investigation | 2021-12-11 00:00:00
 |  | 5 |  |  | 06-12-21
Spreadsheet: 876870d1723584039-tranpose-data-from-row-to-column-based-on-sequence-repeat-row
Sheet: Sheet1

Key | Person 1 | Person 2 | Person 3 | Person 4
K123 | [NAME] | [NAME]
B456 | [NAME] | Will | Anna
Result Needed
Key | Person
 | [NAME]
K123 | [NAME]
B456 | [NAME]
B456 | Will
B456 | Anna
Spreadsheet: 124151d1318190326-product-and-quantity-price-break-input-into-invoice-quantity-discount-example
Sheet: Customer List

Company | Billing Address | City | Province | Postal Code | Phone
This Guy | 17 Summit Pointe Dr R.R.1 | Dewinton | Ab | T0L 0X0 | [PHONE] Fax 201-4235
That Guy | Rteteet | Tet | Ab | T4C 1A8
The Other Guy | #3, 104 Strathaven Dr. | Strathmore | Ab | T1P 7P7 | [PHONE] Fax Number 934-5237
Spreadsheet: 156430d1337284209-challenging-question-if-automatic-cells-change-from-order-and-others-dont-excel-forumq
Sheet: Sheet2

Name | ID | Age | date | comments
 |  |  | 11 | Yes,…
 |  |  | 10 | Yes…
 |  |  | 9 | No..
 |  |  | 8 | Indeed,…
 |  |  | 11 | Why….
 |  |  | 10 | That’s… |  |  | Column A, B and C are automatic (generated from the sheet1), column D an E are not automic
 |  |  | 9 | Ow.. |  |  | But if I change value in sheet 1 the compostion changes in sheet 2. (for example delete an age in sheet 1)
 |  |  | 8 | No.. |  |  | The values in column D and E supposed to be coupled to the right ID and age, but because of the movement this is not the case.
 |  |  | 11 | So, |  |  | How can I make sure that the information in column D and E is changes in order, together with the movement in column A, B and C?
 |  |  | 10 | Sofra…
 |  |  | 9 | Adieu
 |  |  | 8 | Yes,… |  |  | Example if I delete the age of Amelie in sheet 1 column C. The name Amelie (A6-A9) disappears and the ID and Age of Amelie also. Peter(A10-A13) moves up.
 |  |  | 11 | But,… |  |  | But the information in column D and E does now not belong to [NAME]. Because those cells are not automatic
 |  |  | 10 | Is it?... |  |  | Is there a way that the cells move togheter with the names??
 |  |  | 9 | Why,..
 |  |  | 8 | Sure,..
 |  |  | 11 | Yes,..
 |  |  | 10 | No,..
 |  |  | 9 | Ok,..
 |  |  | 8 | But,…
 |  |  | 11 | Why,..
 |  |  | 10 | True,..
 |  |  | 9 | But,..
 |  |  | 8 | False,..
 |  |  | 11 | Sure,..
 |  |  | 10 | Yes,..
 |  |  | 9 | No,..
 |  |  | 8 | Possible,..
 |  |  | 11 | Is,..
 |  |  | 10 | Probably,..
 |  |  | 9 | Sure,..
 |  |  | 8 | Yes,..
 |  |  | 11 | Ok,..
 |  |  | 10 | Let,..
 |  |  | 9 | Sure,..
 |  |  | 8 | Yes,..
Spreadsheet: 482814d1475253829-how-to-return-values-in-column-a-when-a-marker-x-is-present-in-the-second-column-matching-to-summarize
Sheet: Sheet1

Agent | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
[NAME] | x | x | x
[NAME] |  | x
[NAME] |  | x
Vince | x
Errol |  |  |  | x
[NAME] |  |  | x
Cosmon |  |  |  | x
[NAME] | x
Erika |  |  | x
Emiel |  |  | x
SUMMARY
 | [NAME] | [NAME] | [NAME] | Errol
 | Vince | [NAME] | [NAME] | Cosmon
 | [NAME] | [NAME] | Erika
 |  |  | Emiel
Spreadsheet: 734461d1622182273-add-in-a-column-down-dynamic-formulas-book2
Sheet: EEM Schedule 2021

 | Days |  |  |  |  |  | Names
Name 1 |  |  |  |  |  |  | Name 1
Project 1 | 5 |  |  |  |  |  | Name 2
Project 2 | 4 |  |  |  |  |  | Name 3
Project 3 | 8
Project 4 | 5
Project 5 | 4
Name 2
Project 2 | 7
Project 3 | 3
Project 4 | 1
Project 5 | 1
Project 6 | 7
Project 7 | 7
Project 8 | 10
Project 9 | 6
Project 10 | 10
Project 11 | 1
Name 3
Project 12 | 10
Project 13 | 3
Project 14 | 8
Project 15 | 2
Project 16 | 7
Spreadsheet: eb2117d9-8054-462c-82ba-56d2292a0001
Sheet: Table 4.2

4.2 Motor vehicle sales
Month | 2009-10 | 2010-11 | 2011-12 | 2012-13 | 2013-14
Number (a) (b)
July | 76479 | 85008 | 85884 | 90523 | 93673
August | 75774 | 83666 | 88484 | 94447 | 94399
September | 78559 | 85517 | 86639 | 97517 | 93898
October | 82156 | 84219 | 87869 | 96208 | 93125
November | 85650 | 84516 | 86761 | 95269 | 95143
December | 89029 | 86491 | 82560 | 96737 | 96550
January | 86145 | 83801 | 86272 | 95595 | 92706
February | 86014 | 85194 | 88032 | 96157 | 92799
March | 85879 | 87220 | 90895 | 94754
April | 92836 | 84492 | 90610 | 93480
May | 88775 | 75681 | 92851 | 94018
June | 87399 | 77124 | 90839 | 96940
Annual | 1014695 | 1002929 | 1057696 | 1141645
Annual change (a)(b) – per cent
July | -9.951607775723822 | 11.15208096340172 | 1.030491247882552 | 5.401471752596525 | 3.479778619798283
August | -5.974760823437442 | 10.41518198854488 | 5.758611622403366 | 6.739071470548348 | -0.05082215422406217
September | -1.949551303653225 | 8.857037385913772 | 1.312019832314043 | 12.55554657833077 | -3.711147799870792
October | 3.321385902031063 | 2.511076488631384 | 4.333938897398449 | 9.490263915601634 | -3.204515217029769
November | 15.99089948809621 | -1.32399299474606 | 2.656301765346207 | 9.806249351667223 | -0.1322570825767039
December | 16.52400397884928 | -2.850756495074639 | -4.544981558774901 | 17.17175387596899 | -0.1933076278983223
January | 14.62463741118237 | -2.720993673457543 | 2.948652164055322 | 10.80651891691395 | -3.022124588106073
February | 17.66621067031464 | -0.9533331783198083 | 3.331220508486513 | 9.22959832788077 | -3.492205455661054
March | 21.05693463582413 | 1.561499318809022 | 4.213483146067416 | 4.245558061499533
April | 29.42062120113757 | -8.987892627859882 | 7.240922217488047 | 3.167420814479638
May | 17.13132166088322 | -14.74964798648268 | 22.68733235554499 | 1.256852376387976
June | 7.507134422357803 | -11.75642741907802 | 17.78305067164566 | 6.716278250531158
Annual | 9.884927270049468 | -1.159560261950635 | 5.460705593317174 | 7.936968656400327
a. The statistics are based on the VFACTS series produced by the Federal Chamber of Automotive Industries. VFACTS reports the numbers of new motor vehicle sales by dealers and direct sales by manufacturers throughout Australia.
b. Monthly data is seasonally adjusted. |  |  |  |  |  |  |  | Update
Source: ABS, Sales of New Motor vehicles, Australia, cat. no. 9314.0 |  |  |  |  |  |  |  | 2014-04-17 00:00:00
Spreadsheet: 474877d1470941206-formula-to-pull-multiple-variables-for-pricing-stair-quoting
Sheet: Sheet3

 |  |  | Treads Only
 |  | Rubber |  |  | Polyaspartic
 |  | 9-10" | 11-12" |  | 9-10" | 11-12"
 | 36" | 100 | 115 |  | 75 | 85
 | 42" | 113 | 128 |  | 85 | 95
 | 48" | 125 | 140 |  | 95 | 105
 | 54" | 138 | 153 |  | 105 | 115
 | 60" | 150 | 165 |  | 115 | 125
 | 66" | 163 | 178 |  | 125 | 135
 | 72" | 175 | 190 |  | 135 | 145
 | 78" | 188 | 203 |  | 145 | 155
 | 84" | 200 | 215 |  | 155 | 165
 | 90" | 213 | 228 |  | 165 | 175
 | 96" | 225 | 240 |  | 175 | 185
 |  |  | Open Rise
 |  | Rubber |  |  | Polyaspartic
 |  | 9-10" | 11-12" |  | 9-10" | 11-12"
 | 36" | 150 | 175
 | 42" | 200 | 225
 | 48" | 275 | 300
 | 54" | 325 | 350
 | 60" | 375 | 400
 | 66" | 425 | 450
 | 72" | 475 | 500
 |  |  | Closed Rise
 |  | Rubber |  |  | Polyaspartic
 |  | 9-10" | 11-12" |  | 9-10" | 11-12"
 | 36" |  |  |  | 125
 | 42" |  |  |  | 150
 | 48" |  |  |  | 175
 | 54" |  |  |  | 200
 | 60" |  |  |  | 225
 | 66" |  |  |  | 250
 | 72" |  |  |  | 275