Excel Spreadsheet Design
- or -
Post a project like this2857
$$
- Posted:
- Proposals: 4
- Remote
- #1188922
- Completed
Description
Experience Level: Intermediate
General information for the business: Fireplace Dealers
Industry: Business
Description of excel work: THORNHILL GALLERIES – JOB SHEET TEMPLATE
Thornhill Galleries is a family run fireplace company. We mainly deal in antique fireplaces, however we also make them to client’s specific requirements. We also offer all the other things associated with supplying a fireplace, namely – hearths, slips, installation, accessories, gas burners and we sometimes also coordinate any work to the flues.
Therefore we would like one master document template we can complete for each project/job which is what we would like your help with.
The following info will be the same across each job and therefore throughout the whole Excel document. Therefore the points below should be copied at the top of all worksheets that have been/are subsequently created.
• Site Address
• Client (Name and Contact Details fields)
• Interior Designer (Name and Contact Details fields)
• Contractor/Builder (Name and Contact Details fields)
• Architect (Name and Contact Details fields)
Each separate worksheet will be for a different room within the site. Therefore the following field names and dropdowns are to be in each separate worksheet, ready to be filled in:
• Room Name / Code / Location
• TG Product Code (and place to add photo if possible)
FRONT HEARTH
• Hearth Material (a dropdown with the following materials:
o Black Slate
o Belgian Fossil
o Basaltina
o Portland stone
o Bath stone
o Mocca stone
o Other (Will require a notes field to enter extra details)
Hearth material notes field
• Hearth Level (a dropdown with the following options:
o Raised (Will require a notes field to enter extra details)
o Flush
o Other (Will require a notes field to enter extra details)
Hearth level notes field
• Hearth size (width and height) fields
Hearth size notes field
BACK HEARTH
• Back Hearth Material (a dropdown with the following materials:
o Screed
o Black Slate
o Belgian Fossil
o Basaltina
o Portland stone
o Bath stone
o Mocca stone
o Other (Will require a notes field to enter extra details)
Back Hearth notes field
SLIPS
• Back Hearth Material (a dropdown with the following materials:
o Black Slate
o White marble
o Belgian Fossil
o Basaltina
o Portland stone
o Bath stone
o Mocca stone
o Other (Will require a notes field to enter extra details)
Slips notes field
FIREPLACE INTERIORS
• Interior Material (a dropdown with the following materials:)
o Cement Render
o Reeded Iron
o Plain Cast Iron
o Panelled Irons
o Plain Mild Steel
o Other (Will require a notes field to enter extra details)
FIREPLACE INSTALLATION
• Fixer (A dropdown with the following:)
o Guy Whicker
o Paul Chandler
o Builder / Other (Will require a notes field to enter extra details)
Fireplace Installation notes field
FIREPLACE ACCESSORIES
• TG Product Code (and place to add photo if necessary)
Fireplace Accessories notes field
FLUES
• TG to arrange new flue lining? (Dropdown with “yes/no” options. If “yes” is selected, the following fields will need to be completed)
• Type of lining (Dropdown with the following options:
o Furan Flex
o Steel liner
o Other (Will require a notes field to enter extra details)
• Company carrying out lining (Dropdown with the following options:)
o Chimney Care
o Bespoke Fires
o Essex Stoves & Chimneys
o Other (Will require a notes field to enter extra details)
Flues notes field
GAS
• TG supplying gas burner? (Dropdown with “yes/no” options. If “yes” is selected, the following fields will need to be completed)
o Ventilation required? (Yes/No dropdown)
Gas notes field
GENERAL NOTES field at bottom of page
Other general requirements:
• Automatically put “date last modified” stamp on it somewhere. Preferably also have someway of knowing who made changes. Is this possible?
• A4 size - each worksheet to be easily printable on an A4 page.
• It is to be easy to read and nicely presented. Make the background colour white as this will be printed regularly.
Looking to get someone booked in and this sorted ASAP.
Thanks
Extra notes: See attached Word doc with above info also
Industry: Business
Description of excel work: THORNHILL GALLERIES – JOB SHEET TEMPLATE
Thornhill Galleries is a family run fireplace company. We mainly deal in antique fireplaces, however we also make them to client’s specific requirements. We also offer all the other things associated with supplying a fireplace, namely – hearths, slips, installation, accessories, gas burners and we sometimes also coordinate any work to the flues.
Therefore we would like one master document template we can complete for each project/job which is what we would like your help with.
The following info will be the same across each job and therefore throughout the whole Excel document. Therefore the points below should be copied at the top of all worksheets that have been/are subsequently created.
• Site Address
• Client (Name and Contact Details fields)
• Interior Designer (Name and Contact Details fields)
• Contractor/Builder (Name and Contact Details fields)
• Architect (Name and Contact Details fields)
Each separate worksheet will be for a different room within the site. Therefore the following field names and dropdowns are to be in each separate worksheet, ready to be filled in:
• Room Name / Code / Location
• TG Product Code (and place to add photo if possible)
FRONT HEARTH
• Hearth Material (a dropdown with the following materials:
o Black Slate
o Belgian Fossil
o Basaltina
o Portland stone
o Bath stone
o Mocca stone
o Other (Will require a notes field to enter extra details)
Hearth material notes field
• Hearth Level (a dropdown with the following options:
o Raised (Will require a notes field to enter extra details)
o Flush
o Other (Will require a notes field to enter extra details)
Hearth level notes field
• Hearth size (width and height) fields
Hearth size notes field
BACK HEARTH
• Back Hearth Material (a dropdown with the following materials:
o Screed
o Black Slate
o Belgian Fossil
o Basaltina
o Portland stone
o Bath stone
o Mocca stone
o Other (Will require a notes field to enter extra details)
Back Hearth notes field
SLIPS
• Back Hearth Material (a dropdown with the following materials:
o Black Slate
o White marble
o Belgian Fossil
o Basaltina
o Portland stone
o Bath stone
o Mocca stone
o Other (Will require a notes field to enter extra details)
Slips notes field
FIREPLACE INTERIORS
• Interior Material (a dropdown with the following materials:)
o Cement Render
o Reeded Iron
o Plain Cast Iron
o Panelled Irons
o Plain Mild Steel
o Other (Will require a notes field to enter extra details)
FIREPLACE INSTALLATION
• Fixer (A dropdown with the following:)
o Guy Whicker
o Paul Chandler
o Builder / Other (Will require a notes field to enter extra details)
Fireplace Installation notes field
FIREPLACE ACCESSORIES
• TG Product Code (and place to add photo if necessary)
Fireplace Accessories notes field
FLUES
• TG to arrange new flue lining? (Dropdown with “yes/no” options. If “yes” is selected, the following fields will need to be completed)
• Type of lining (Dropdown with the following options:
o Furan Flex
o Steel liner
o Other (Will require a notes field to enter extra details)
• Company carrying out lining (Dropdown with the following options:)
o Chimney Care
o Bespoke Fires
o Essex Stoves & Chimneys
o Other (Will require a notes field to enter extra details)
Flues notes field
GAS
• TG supplying gas burner? (Dropdown with “yes/no” options. If “yes” is selected, the following fields will need to be completed)
o Ventilation required? (Yes/No dropdown)
Gas notes field
GENERAL NOTES field at bottom of page
Other general requirements:
• Automatically put “date last modified” stamp on it somewhere. Preferably also have someway of knowing who made changes. Is this possible?
• A4 size - each worksheet to be easily printable on an A4 page.
• It is to be easy to read and nicely presented. Make the background colour white as this will be printed regularly.
Looking to get someone booked in and this sorted ASAP.
Thanks
Extra notes: See attached Word doc with above info also
Richard W.
100% (14)Projects Completed
22
Freelancers worked with
21
Projects awarded
20%
Last project
31 Jan 2022
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Can we discuss elaborately?
22023
We collect cookies to enable the proper functioning and security of our website, and to enhance your experience. By clicking on 'Accept All Cookies', you consent to the use of these cookies. You can change your 'Cookies Settings' at any time. For more information, please read ourCookie Policy
Cookie Settings
Accept All Cookies