Professional needed for Excel coding
- or -
Post a project like this2444
$$$
- Posted:
- Proposals: 1
- Remote
- #1655595
- Awarded
Description
Experience Level: Expert
Description of excel work: Excel professional required for coding of Fit Out Calculator - used to calculate cost for interior design of office space. All the rows that have estimates provided need to add up to provide the user with a total estimate. The below costs are also included in a work sheet as seen in the attached document. The document includes Fit out calculator draft (excluding actual calculations) and costs. Please provide estimated time required to complete the work in your reply to the post.
Row 5: Answer is number in sqft the number input must be multiplied by £4
Row 6: If answer is yes, in row 6 than 7 & 8 are not applicable
Row 7: If Row 7 is Y take answer in sqft provided in row 5 and multiply by £75, this would render row 6 and 8 not applicable.
Row 8: If Y take answer provided in row 5 and multiply by £14, this would render row 7 and 6 not applicable.
Row 11: Y take number provided in row 13 and multiply by £215
Row 18: Y take number in row 5 and multiply by £2.80 this renders row 20 void
Row 20: Y take number in row 5 and multiply by £12.50 this renders row 18 void
Row 24: Multiply by £130
Row 27: Number provided to be multiplied by £1500
Row 29: Number provided to be multiplied by £1800
Row 30: Number provided to be multiplied by £2200
Row 33: Number provided to be multiplied by £2800
Row 34: Number provided to be multiplied by £3600
Row 35: Number provided to be multiplied by £4200
Row 38: Number provided to be multiplied by £1500
Row 39: Number provided to be multiplied by £3000
Row 40: Number provided to be multiplied by £7000
Row 44: if Y take number in row 5 and multiply by £2.90 per sqft
Row 47: if Y add £5000
Row 51: If Y take answer in row 5 and multiply by £1.00
Row 55: If Y add £6000
Row 61: Take number provided and multiply by £215
Row 62: Take number provided and multiply by £275
Row 63: Take number provided and multiply by £740
Row 66: Take number provided and multiply by £165
Row 67: Take number provided and multiply by £190
Row 68: Take number provided and multiply by £200
Row 71: Take number provided and multiply by £145
Row 72: Take number provided and multiply by £135
Row 75: Take number provided and multiply by £195
Row 76: Take number provided and multiply by £265
Row 77: Take number provided and multiply by £385
Extra notes:
Row 5: Answer is number in sqft the number input must be multiplied by £4
Row 6: If answer is yes, in row 6 than 7 & 8 are not applicable
Row 7: If Row 7 is Y take answer in sqft provided in row 5 and multiply by £75, this would render row 6 and 8 not applicable.
Row 8: If Y take answer provided in row 5 and multiply by £14, this would render row 7 and 6 not applicable.
Row 11: Y take number provided in row 13 and multiply by £215
Row 18: Y take number in row 5 and multiply by £2.80 this renders row 20 void
Row 20: Y take number in row 5 and multiply by £12.50 this renders row 18 void
Row 24: Multiply by £130
Row 27: Number provided to be multiplied by £1500
Row 29: Number provided to be multiplied by £1800
Row 30: Number provided to be multiplied by £2200
Row 33: Number provided to be multiplied by £2800
Row 34: Number provided to be multiplied by £3600
Row 35: Number provided to be multiplied by £4200
Row 38: Number provided to be multiplied by £1500
Row 39: Number provided to be multiplied by £3000
Row 40: Number provided to be multiplied by £7000
Row 44: if Y take number in row 5 and multiply by £2.90 per sqft
Row 47: if Y add £5000
Row 51: If Y take answer in row 5 and multiply by £1.00
Row 55: If Y add £6000
Row 61: Take number provided and multiply by £215
Row 62: Take number provided and multiply by £275
Row 63: Take number provided and multiply by £740
Row 66: Take number provided and multiply by £165
Row 67: Take number provided and multiply by £190
Row 68: Take number provided and multiply by £200
Row 71: Take number provided and multiply by £145
Row 72: Take number provided and multiply by £135
Row 75: Take number provided and multiply by £195
Row 76: Take number provided and multiply by £265
Row 77: Take number provided and multiply by £385
Extra notes:
Ebba N.
100% (8)Projects Completed
6
Freelancers worked with
7
Projects awarded
56%
Last project
18 Jun 2019
United Kingdom
New Proposal
Login to your account and send a proposal now to get this project.
Log inClarification Board Ask a Question
-
Did you have a budget in mind for this task? The reason I ask is that someone charging £10.00 / hour might take 7 hours, someone charging £30.00 / hour might take 1.5 hours?
Did you have any company images, addresses etc that can be used on the new quotation sheet, for print and / or email?
Regards
Tony H
468993
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