Find Jobs
Hire Freelancers

Build me a excel calculator for estimating required Days+Staff

$30-250 AUD

Complété
Publié il y a plus de 5 ans

$30-250 AUD

Payé lors de la livraison
Build me a excel calculator for estimating required Days+Staff We would like to use this calculator to calculate every job fast and efficient. Here is description (also in excel sheet attached) Floor Area Grinding Calculator m2 = Square Metres (Width x Length) We diamond grind concrete floors. I would like to create a calculator to be able to calculate the required amount of Staff (D5 workers) and the required amount of Days (D4) to complete the works based on the size of the Floor Area - m2 (Yellow box D3). This is my first attempt and I am not too sure if this is the right way. I need someone to use this as a guide to build a New Calculator making sure it is easy to change values in the future (So we can improve the accuracy of how long and required staff based on us back costing future jobs) Yellow = Enter m2 - Floor measurements in square metres Green = Result Red = Price Result Blue = All Related Cost Purple = Table to Calculate From Requirements 1: Read this description and write a proposal related only to this project ( Not Copied and paste like most proposals i see on here). 2: Ask questions if you do not understand. 3: Build New Calculator based on your knowledge and expertise and NOT mine as I am not a expert like you. 4: Set it up so values for data can be adjusted by us in future (to improve accuracy) 5: Have Fun
N° de projet : 17464745

Concernant le projet

56 propositions
Projet à distance
Actif à il y a 6 ans

Cherchez-vous à gagner de l'argent ?

Avantages de faire une offre sur Freelancer

Fixez votre budget et vos délais
Soyez payé pour votre travail
Surlignez votre proposition
Il est gratuit de s'inscrire et de faire des offres sur des travaux
Décerné à :
Avatar de l'utilisateur
Hi! I can improve your template by, for instance, calculating how many days a surface will take with a constraint of 2 staff or how many staff are required if your client demands the surface to be done in 3 days. I do this kind of Excel work daily at my job as Financial Auditor so please contact me to let me know what you need exactly. Fee is dependent on amount of work. Thanks, Adrian
$60 AUD en 3 jours
4,6 (5 commentaires)
2,2
2,2
56 freelancers are bidding on average $145 AUD for this job
Avatar de l'utilisateur
Hi there, Warm Greetings We came along with your request for Build me a excel calculator for estimating required Days+Staff and we reviewed your project description. We'd like to help you with confidence and satisfying results. We have professionals working here with 100% results and more creative and renovative ideas for our clients ! We have worked on several similar projects before! We are offering our services for more than 5 years in the field of Excel, Excel Macros, Excel VBA, Mathematics, Programming We have worked on 350+ Projects. Please check the profile reviews Feel free to message us to discuss briefly about your project !
$180 AUD en 3 jours
4,9 (498 commentaires)
8,4
8,4
Avatar de l'utilisateur
Hi, I am good at Excel advanced formulas and vba programming for automation. I would like to take this opportunity to introduce me that i have Engineering background and i am aware of the basic dimesional calculations and proposal calculations Hopefully, it helps me in analyzing and improving your requirements. Looking forward to discuss further in the chat. I have reviewed the file. Happy to have discussion. -Chandra
$150 AUD en 2 jours
5,0 (1129 commentaires)
8,3
8,3
Avatar de l'utilisateur
I am proficient with excel macro/VBA development, I can deliver the calculator macro for you, if you are interested feel free to message me, looking forward to chat further and work on your project
$100 AUD en 3 jours
5,0 (156 commentaires)
7,5
7,5
Avatar de l'utilisateur
Dear Client, I understand the scope of work. I can build the calculator which you mentioned. Basically the calculator will calculate number of workers and days based on the area. I believe I can help you in this project. But I want to have a dicussion beforehand. So please contact me. Roy
$100 AUD en 2 jours
4,9 (492 commentaires)
7,4
7,4
Avatar de l'utilisateur
We can talk in more details about the concept of your calculator. Below is my credentials: """I am an Excel Expert with Professional experience working with Excel both with Formulas and Macro. Working with complicated formula and Developing Macro programs are part and parcel of my daily work. Completed more than 190+ jobs on Freelancer majority of which was 5 star work. I understand the value of deadline and do not compromise on quality. I believe I can do a great work for you and ensure your complete Satisfaction. I am a Business (MBA) Graduate with major in Finance and MARKETING along with 5 years of experience in different analytical roles. Currently I am working for a MNC as an B2B Analyst Manager.I believe I can do a fantastic work for you if you provide me the opportunity. """
$100 AUD en 3 jours
4,9 (273 commentaires)
7,1
7,1
Avatar de l'utilisateur
Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered twenty four excel vba projects in the past one twenty days. Willing to take up your project. Thank you, Regards.
$155 AUD en 3 jours
5,0 (186 commentaires)
7,0
7,0
Avatar de l'utilisateur
Hey there! I checked the attached excel file. I already see a fully functional sheet doing all the calculations as required. Could you please explain exactly what more/added functionality are you looking to be added on this sheet? Best Sourabh
$49 AUD en 1 jour
5,0 (178 commentaires)
6,3
6,3
Avatar de l'utilisateur
Hi, I have checked your project description and file attached. So, want to create a Grinding Calculator so that you can calculate the number of staff, number of days etc requirements against the mentioned area of grinding. I will help you in this and will build one perfect calculator for you. I have many years of experience in Excel,data analysis, pivots and VBA macros etc. I have finished many such projects. Please give me this opportunity to work on your project. Quality work with high accuracy and 100% customer satisfaction is guaranteed. Thanks and regards, Peter
$199 AUD en 5 jours
5,0 (94 commentaires)
6,5
6,5
Avatar de l'utilisateur
Bsc software engineering. PhD in computer science having seven years of experience in Excel development like : Excel calculators. excel models designing. Excel dashboards designing. I already done many Excel calculators like: Excel Mortgage calculator.
$250 AUD en 1 jour
4,8 (109 commentaires)
6,5
6,5
Avatar de l'utilisateur
Hi, I can automate your excel in order to select the number of people and days required from the purple table (you can update values from the table anytime and the formula will update the result) based on the surface filled in. I saw an error in your file in the blue table, the 25/30 grit price per m2 is using the surface from the 50/60 grit (N19 instead N18). I will be glad to help you with your project and I am sure you will be satisfied with my professionalism and the quality of my work. Best regards, Florin Enache.
$90 AUD en 1 jour
5,0 (23 commentaires)
5,7
5,7
Avatar de l'utilisateur
Hi, there I hope all's well with you. I see you'r looking for a developer proficient in Ms Excel/VB. Really all my projects here I've developed for Ms Access/Excel/VB projects. I'll do your current Ms Excel macro enabled project very professionally and on time. Here is my introduction: I’m a ms Access/Excel/VB programmer, a mathematician and a full time developer with a strong background developing a wide range of accounting, economical, statistical and mixed type projects using Ms Access, Ms Excel, VBA, ADO, SQL , including projects for start-up companies and small businesses. For over the last 20 years I’ve worked in a variety of industries. I have a deep passion for coding and guarantee that all of developing is 100% original. I highly value professionalism and hold myself strictly accountable to represent my client’s brand. I aim to form a long-term working relationship. Please, let me know what is needed to secure this bid! Thank you for your consideration. Zura
$833 AUD en 10 jours
4,8 (33 commentaires)
5,9
5,9
Avatar de l'utilisateur
Hello, I am interested in your project and like to handle it and deliver high quality solution.......... Regards, Iyad
$277 AUD en 3 jours
5,0 (13 commentaires)
5,5
5,5
Avatar de l'utilisateur
Hi Good Day! Sorry for the high Project Bid, but I checked your file and saw that there's a lot of thing that we need to do. I know it's a little bit high than other but I'll make sure that it's worth it. I put 5 days of work so we have a lot of time just in case you need some changes and adjustments. No need to accept my bid immediately, just message me and discuss about this project. Message me so I can start analyzing all the required fields. By the way, I am a MS Excel certified and has a strong knowledge with VBA Macro. I know I can help yu with this. Thank you!
$150 AUD en 5 jours
4,7 (81 commentaires)
5,6
5,6
Avatar de l'utilisateur
Hello, Your excel file is pretty amazing How did you get the purple color table data? It seems correct with the vlookup, and with the TRUE value Kindly discuss with me, any improvement do you need I saw you are looking for a new calculator I can think about that but need to familiar more about the purple table I am looking forward to hearing from you Thanks Regards Thusahra
$100 AUD en 3 jours
5,0 (37 commentaires)
5,2
5,2
Avatar de l'utilisateur
I am a mechanical engineer. My major is energy and I have studied automation as well. I also teach physics and math at high school and college level and visiting lecturer in fluid, mechanics of material, dynamics and energy subjects. I have 5 years’ experience in teaching. I have used excel in various applications so I can do your work accurately
$200 AUD en 3 jours
4,9 (42 commentaires)
5,4
5,4
Avatar de l'utilisateur
I am very able to create a excel calculatir for estimating days and staff. I am ready to start regards
$99 AUD en 2 jours
4,6 (43 commentaires)
5,6
5,6
Avatar de l'utilisateur
Greetings, I am a professionally qualified Accountant from Sri Lanka with A degree in Management & Finance. I am a QuickBooks Pro-Advisor. I have the experience in various types of models using Excel and I am proficient with Dash Boards, VBA, and Excel. I can do a better job for you with my financial knowledge. I also have done various jobs in my career calculating job costing and man-hours. I am very good at management Accounts. So, I understand your requirements. Look forward to discussing with you the opportunity further. Kind regards, Dilip.
$150 AUD en 7 jours
4,8 (14 commentaires)
4,9
4,9
Avatar de l'utilisateur
Sir, I have gone through your project description and am looking to provide my service for developing excel calculator. For more than 7 years I’ve worked in this field.
$155 AUD en 3 jours
5,0 (10 commentaires)
4,1
4,1
Avatar de l'utilisateur
Hello I would love to help you with you calculator. I do have a few questions which I've noted below if you could provide clarification on: - are all our calculations based on the values in the purple cells? so there's a set amount of people always employed for a specific size of area? - to be honest, I think the calculator you've made is very good for it's functionality. I'll look to see if I can make any changes, and my bid price is based on this additional work, however if there's nothing I can do to improve then I'll charge less for the job. I may move some of the constant data, but otherwise I think it already looks pretty good. For reference, my name is Steve, I have over 10 years experience with excel working for a financial services company. I worked on creating and manipulating large complex spreadsheet on a daily basis. In this time I became a local lead for excel and vba issues so I believe I have the correct experience for this task. Please let me know if you require any further information. Kind regards Steve
$155 AUD en 3 jours
5,0 (9 commentaires)
4,3
4,3
Avatar de l'utilisateur
Hi, I have read the project description and I am willing to do the project why don't we first do linear programming optimization and then build the calculator so that it can be used to do the best resource utilization and can be used with any set of data only we have to program the excel sheet once withe formulas More we can discuss in chat if you are interested in my proposal
$105 AUD en 3 jours
5,0 (16 commentaires)
3,8
3,8

À propos du client

Drapeau de AUSTRALIA
Murrumbeena, Australia
5,0
43
Membre depuis mai 1, 2018

Vérification du client

Merci ! Nous vous avons envoyé un lien par e-mail afin de réclamer votre crédit gratuit.
Une erreur a eu lieu lors de l'envoi de votre e-mail. Veuillez réessayer.
Utilisateurs enregistrés Total des travaux publiés
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Chargement de l'aperçu
Permission donnée pour la géolocalisation.
Votre session de connexion a expiré et vous avez été déconnecté. Veuillez vous connecter à nouveau.