Excel Calculation /Formala Expert Create Scope of works

Completed Posted 5 years ago Paid on delivery
Completed Paid on delivery

I would like someone with the skills to create a sheet for task below for our flooring company estimators. There might be an easier way to work out how long it will take the job to be done or ways to lay it out.

Result is enter the floor area (m2 square metres)

Based on the m2 for the sheet to calculate how many days it will take to complete each stage.

Stage 1 = diamond grind floor, m2/200 = days ( 3 staff can diamond grind 200 m2 per day.

Stage 2 = appling 1st coat of epoxy = 0-100m2 is half a day 101-500m is 1 day whole day.

Stage 3 = appling 2nd coat of epoxy = 0-100m2 is half a day 101-500m2 is 1 day whole day.

Stage 4 (Opitional for our clients) = Apply clear coat of uv stable polyurethane.

Example

Based on 300m2 this is the results

Day 1 = Diamond grinding

Day 2 = Daimond grinding - and Apply 1st coat of epoxy

Day 3 = Apply 2nd coat of epoxy

Day 4 Optional = Apply clear coat of UV stable epoxy

Example

Based on 450m2 this is the results

Day 1 = Diamond grinding

Day 2 = Daimond grinding

Day 3 = Daimond grinding .25 of the day - Apply 1st coat of epoxy

Day 4 = Apply 2nd coat of epoxy

Day 5 = Optional = Apply clear coat of UV stable epoxy

Example small area 80m2

Day 1 = Diamond grind floor - Apply 1st coat of epoxy

Day 2 = Apply 2nd coat of epoxy

Day 3 Optional = Apply clear coat of UV stable epoxy

AutoCAD Civil Engineering Data Processing Excel Structural Engineering

Project ID: #18355877

About the project

11 proposals Remote project Active 5 years ago

Awarded to:

sevillajk01

hello! let me do it for you. Just award the project to me and I will take care of the rest. Please see reviews on my previous projects to assess my capability. thanks

$20 AUD in 1 day
(30 Reviews)
4.6

11 freelancers are bidding on average $60 for this job

zebracaro

I can make it by vba, it will be simple with one click for showing all data you need. Please contact me for saving your time and your money .

$350 AUD in 5 days
(184 Reviews)
7.4
natalka503

Hello, I have big experience in that kind of projects and I would really like to help you. Please contact me on chat to discuss details. Greetings, Natalie

$35 AUD in 1 day
(60 Reviews)
5.9
androaiad

Hello dear, I am a M.Sc. engineer, I am expert in Excel. I understood what you need and will finish the Excel file in two hours max. Thanks.

$20 AUD in 1 day
(131 Reviews)
6.6
kevivu

Completed numerous similar projects in the past and always impressed the clients with my excellent solutions. Expert in PYTHON,.NET, VB, VBA, MYSQL, SQL, MS Office, Access/Excel/Word/Outlook, Database, complex Formu More

$55 AUD in 1 day
(73 Reviews)
5.9
RavinduJayzz

Hey can you please explain the requirement abit more ? That will help me understand it better. Hope to hear from you ! Thanks !

$30 AUD in 1 day
(38 Reviews)
5.9
Ashisjena2015

Hi, I'm an advanced excel expert. I can do this job..........................................................................................................................

$30 AUD in 0 days
(38 Reviews)
5.2
QueenArt66

Hi, I am an expert in this field. Please give me a job. I am sure that you like my work and quality. I have read Your project description regarding Excel Calculation /Formula Expert . I am very interested in your More

$25 AUD in 1 day
(5 Reviews)
3.2
DominikKrivarics

Hi, It looks like something i would like to work on! Let me know if you have time for a quick chat and after that i'm ready to start. BR, Dominik

$55 AUD in 3 days
(5 Reviews)
2.6
JorgeBece

Hello, I've read your project. It can be done easily combining conditional and text fórmulas, so, please , contact me to know more about details.

$10 AUD in 1 day
(11 Reviews)
2.7
bytebolt

I After reading your requirement I seems that that will be easy for me to do as I am currently working in India reputed IT company TCS. And to make a algorithm for this will be easy for me. I also have a knowledge of M More

$30 AUD in 1 day
(6 Reviews)
2.6