Excel Calculation /Formala Expert Create Scope of works

Befejezett Kiadva: 5 évvel ezelőtt Kiszállításkor fizetve
Befejezett Kiszállításkor fizetve

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 Mélyépítés Adatfeldolgozás Excel Magasépítészet

Projektazonosító: #18355877

A projektről

11 ajánlat Távolról teljesíthető projekt Utoljára aktív: 5 évvel ezelőtt

Odaítélve:

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 1 napon belül
(30 értékelés)
4.6

11 szabadúszó tett átlagosan 60$ összegű árajánlatot erre a munkára

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 5 napon belül
(184 vélemény)
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 1 napon belül
(60 vélemény)
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 1 napon belül
(131 vélemény)
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 Továbbiak

$55 AUD 1 napon belül
(73 vélemény)
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 1 napon belül
(38 vélemény)
5.9
Ashisjena2015

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

$30 AUD 0 napon belül
(38 vélemény)
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 Továbbiak

$25 AUD 1 napon belül
(5 vélemény)
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 3 napon belül
(5 vélemény)
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 1 napon belül
(11 vélemény)
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 Továbbiak

$30 AUD 1 napon belül
(6 vélemény)
2.6