Find Jobs
Hire Freelancers

Build VBA model from existing excel spreadsheet

$750-1500 NZD

In Progress
Posted over 5 years ago

$750-1500 NZD

Paid on delivery
We are a woodware manufacturer in New Zealand and we focus on making ethnic flavoured giftware for the New Zealand souvenir market (see [login to view URL]) We have been in business for over 25 years and use a custom built excel spreadsheet to calculate initial and ongoing product costs and to assist with the setting of sell prices. Our business has grown from 20 odd products to over 180 products and the spreadsheet is now cumbersome, easy to “corrupt” and difficult to navigate. We seek a VBA expert to re-write our software to correct the above issues. ie standardised entry forms for stock, standard template for new product entry, time trial database & linking, labour cost analysis, projected profit analysis per item, ability to create components as stock items, linked navigation, etc. As the spreadsheet is of an extremely commercially sensitive nature, I am reluctant to attach it here where anybody can access it. Instead I have attached some snapshots of the various portions to give you an over-view of the spreadsheet we wish to automate. Please respond with why I should select you, your confidentiality agreement, hourly rate and cost estimate to complete this project (to the nearest NZD$250). I will shortlist likely candidates based on this response.
Project ID: 18097140

About the project

41 proposals
Remote project
Active 5 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hi, I'm Chris from the UK and this is the sort of project that I love doing! I've not only had over 10years experience in excel and VBA, but my job is to apply this logic in a manufacturing environment - I work for a door manufacturing company. I've done many jobs similar to this in the past and I already have some ideas as to how we could handle your ever growing list of products. What I've done for a clothing distributor in the UK is to add an "Enable / Disable" option in the table so he can easily switch on and off products - without deleting the item so it can also be enabled in future. What I've also noticed is that you have a really good labor and BOM (Bill of Materials) setup. I've actually done something almost identical for an Australian client, we called them "Job Packs" and we could build them up based on the requirements if a new product. e.g. when we setup a product we can tick "Needs cutting, Needs Varnish etc." and the "Standard" run rates and components are applied and special requirements can be added after. I've also spent 4 years studying Purchasing, Supply and warehouse management which covered areas such as stock management / stock control etc. and I would apply this logic to your sheet. It would be great to discuss further and hopefully we can take it from there. There is no pressure to award to me at all if we chat - I won't be chasing you if you choose someone else :) Cheers Chris
$1,200 NZD in 10 days
5.0 (9 reviews)
4.7
4.7
41 freelancers are bidding on average $1,023 NZD for this job
User Avatar
Hello, Hope you are doing well. I can help with you in your project Build VBA model from existing excel spreadsheet. I can assure you the quality job. I have good experience in Data Processing, Excel, Microsoft Access, Visual Basic, Visual Basic for Apps. We have worked on several similar projects before! We have worked on 400+ Projects. Please check the profile reviews. I can deliver your job with in your deadline. Please ping me for more discussion. I can assure the 100% job satisfaction. Thanks,
$750 NZD in 6 days
4.9 (369 reviews)
8.1
8.1
User Avatar
Hi! I wonder - do not you want to move this to the real database? Excel is good as a spreadsheet but quite poor as a database as you noted. Personally, I think if you move forward with Excel the things will complicate even further. If you like the idea, we can discuss the details (I am interested in details as well, this is a kind of a blind bid). Regards, Branislav Mihalljev
$1,250 NZD in 20 days
5.0 (270 reviews)
7.7
7.7
User Avatar
Hello! My name is Paris. According to your brief, you need a developer that will elaborate your existing Excel spreadsheet. I will write the required VBA code that will automate the functionality, and turn your spreadsheet to an efficient assistant of yours. To answer your questions, I'm among the most experienced and skilled MS Excel and VBA developers on this platform as you can quickly check for yourself. I can sign a confidentiality agreement upon request. Finally, my pay rate is 30NZD/hour and, I expect this project to cost no more than 1,000-1,200 based on the attached pics. You're welcome to visit my page on this platform (https://www.freelancer.com/u/paris2785) and get an idea of who I am and what services I deliver to my clients. We need to discuss the details. I'm available from 8 am to 9 pm, Athens time. When does it work for you? I'm looking forward to hearing from you. Sincerely, Paris Pallas
$1,200 NZD in 14 days
4.9 (309 reviews)
7.7
7.7
User Avatar
Hi there,I am Miljan,Excel VBA expert from Bosnia & Herzegovina,Europe. I have carefully gone through with your requirements and I would like to help you with this job ! I can start immediately and finish it within the agreed deadline. Check out my profile, portfolio and former clients feedback - that'll let you know everything about me. Please feel free to contact me so that we can discuss further details. Thank you for taking the time to read my proposal.I am looking forward to hearing from you. Best regards, Miljan
$1,250 NZD in 20 days
4.9 (142 reviews)
7.4
7.4
User Avatar
I read your requirements carefully and I confirm that I can do exactly what you need. I'm a computer science professional with a PhD degree and extensive experience in VBA programming for Excel. I've developed many similar business dashboards over 20+ years of my career. I'm a resident of the USA and I have no problem with signing an NDA when I receive it from you. I often perform projects related to sensitive business data. My quote for this project is $1000 NZD. Since you listed it as a fixed amount project, you don't have to worry about my hourly rate or the number of hours. I have a very good idea what to do and how much work this would require of me, so I'm comfortable with a firm quote which I won't exceed. Just FYI, I own a small engineering consulting business registered in the state of Illinois. You could pay me as an individual freelancer or as a business, whichever suits you better. Please have a look at some Excel projects I've done: https://www.freelancer.com/projects/Excel/Build-Excel-reports-dashboard/ https://www.freelancer.com/projects/Excel/Calculate-the-semi-deviation-each/ https://www.freelancer.com/projects/Excel/Recreate-online-calculator-using-Excel/
$1,000 NZD in 10 days
4.8 (202 reviews)
7.2
7.2
User Avatar
Dear, we are Team of French + US. I checked your project description, and I confirm I can develop your MS-Access program. Please give me more details about your project. I will focus on user friendly interface. As you can see I have very good rate, you can be sure I am serious. Regards, Fabrice
$833 NZD in 20 days
4.7 (92 reviews)
7.3
7.3
User Avatar
Hello, my name is Cristian, I have a degree in Business and work with excel every day. I have much experience with spreadsheets, formulas, models and macros. You must choose me because i am VBA Top freelancer and i only take projects that i can carry out, I do not outsource any part of the project, i develop it from start to finish. My hourly rate is around 20NZD, and I need to see the file to give you an estimate of hours. Check my reviews, they speak for themselves. Best regards
$1,250 NZD in 10 days
4.9 (259 reviews)
7.0
7.0
User Avatar
Hello? How are you? I have good experiences in "Build VBA model from existing excel spreadsheet" as you can see my profile for these (Data Processing, Excel, Microsoft Access, Visual Basic, Visual Basic for Apps). I have been working for 7 yrs in this scope. While we contract and work in our jobs, I will get paid once you have confirmed satisfied result. If I do not deliver satisfied result, I will never get paid from you. We can discuss more details to understand more easily if you have other infos. Hope to work with you. Thank you.
$800 NZD in 3 days
4.8 (103 reviews)
6.8
6.8
User Avatar
Hi, Nice to know your requirement. I am an excel vba, vb6 expert and have delivered fifty excel vba projects in the recent eight months. Well. I have delivered similar solutions already, and can deliver this for you. You could believe me on the confidentiality part, and I am willing to sign an confidentiality agreement if required. My Hourly rate ranges from 20 USD to 50 USD based on the expertise required for the job. For this job, 25 USD Per hour would suffice. My bid comes around 665 USD, that will enable me to work for you for around 34 Hours over the 10 days time period. We can have the stages/milestones discussed at the start of the project. Willing to take up your project. Thank you, Regards.
$1,000 NZD in 10 days
5.0 (122 reviews)
6.5
6.5
User Avatar
Hello, I am experienced excel expert. I can help with this task with quick turnaorund. Looking to hearing from you. Kind regards PS : Let's discuss further. I can also offer a solution as proper window application as well.
$800 NZD in 20 days
5.0 (106 reviews)
6.3
6.3
User Avatar
Dear, I read your requirement and your company is same like me, I work as Costing at Honda - Manufacter Company. As this position, I deloyed a VBA file to automate costing system and it have us to reduce book closing so much.I set deal this because I think u in the same situation with us and I can give u a hand. Feel free to contact me.
$750 NZD in 20 days
5.0 (195 reviews)
6.3
6.3
User Avatar
Hourly Rate: 20NZD Having more than 14 years of experience in banking /finance /accounting, Business analysis, Data analysis, Software development, Software Testing, SDLC, Budgeting, estimation, Project management, Process re-engineering, Statistics, Bookkeeping, HR, Payroll, AR/AP, copy typing, ebook creation, publishing, Web research, Social media marketing, lead generation, etc Completed numerous similar projects in the past and always impressed the clients with my excellent solutions. You can refer my freelancer profile for reviews and completed tasks: https://www.freelancer.com/u/kevivu.html Out of my 75 projects, almost 70+ are complex PYTHON/VB/VBA/.Net/Design/Webscrapping projects, hence i can definitely deliver an excellent solution to your requirement. Expert in PYTHON/VBA/VB/.NET, SQL, Adobe packages, MS Office, Access/Excel/Word/Outlook, Database, complex Formulae, Statistical analysis, Macros (VBA), pivot, Charts, formatting, templates, dashboard, etc. Worked on several complex Webscrapping (Amazon / Aliexpress / eBay), PYTHON, VBA projects, viz converting Raw data to structured report, sales dashboard, PO tracking, Invoice Automation, budgeting, profitability, estimation, time management dashboards, etc. Also I am a quick learner and complete tasks very quickly using keyboard shortcuts and multitasking skills. And I have been consistently rated as excellent by all the employers
$750 NZD in 10 days
4.8 (77 reviews)
5.9
5.9
User Avatar
Hi, I read your project with interest and am pleased to make my best bid for developing a database to manage your business operations. Based on the information provided, this needs to be developed as an Access database, with the data transfered from Excel to Access, then you can use the database in your office, even multiple users can access the same data at a time (multi-user access). It will take me a month (or less) to complete, and I will work with you to get your feedback and to give you daily status reports of work completed. Good quality work done, and I will remain avialable in future for any support required. Thanks for considering my bid. Bests, Steve
$1,500 NZD in 28 days
4.9 (49 reviews)
5.8
5.8
User Avatar
Hi, my name is Rodrigo. I believe I can help you out with this project, as a matter of a fact the reason why I think you should select me is because I could make an entire system based on your specifications in .NET which does calculations as required. Please send me a message to further discuss.
$1,111 NZD in 10 days
4.7 (29 reviews)
5.9
5.9
User Avatar
Hello there, I have gone through your project description. **For a confidentiality agreement, freelancer has an option to add an NDA to a project and you should add that to your bid, which I will confirm. **The cost estimate for the project is NZD$1250 to be completed in about 15 days including compiling project requirements, development and reviews of the solution. This amount can be split into different milestones according to the agreed approach. **According to your description and the many sheets that I see in your document, you may also need to consider moving over the solution to a database. Though I am capable of developing an Excel based solution based on Formulas and VBA with required linking between sheets. A database like MS Access will provide more options, such as sharing amongst different users on your network, creation of forms for data entry, security access, creation of reports, invoices and so on. I am also capable of providing additional functionality such as saving to PDF, printing, email and so on. I look forward to your response. Moosa
$1,250 NZD in 15 days
4.9 (44 reviews)
5.5
5.5
User Avatar
I would love the opportunity to chat with you further about your project, as it would be great to get an idea of the scope of the workbook (I can see from the time trial collection there are quite a few tabs)? However, it's probably best I start my proposal addressing the 3 questions you have posed - 1. Why you should select me - I am a professional business analyst with over 15 years experience building complex tracking and analysis models with Excel, Access, VBA, SQL. In addition to expert level technical skills I have a strong retail planning background which would allow me to bring subject matter expertise to this project. I am passionate about my work - I love using tools which businesses already have access to, to create deceptively simple tools which save time for busy people. I am located in Queensland Australia, which may be of some assistance timezone wise. From reviewing your screenshots I was wondering how married you are to an Excel based solution? While I am 100% confident in my ability to deliver within Excel - I think given the size of the project and the amount of historical data Access may be a better delivery mechanism. 2. I am 100% willing to commit to confidentiality, sign an NDA, etc. 3. I have provided a cost estimate of NZD $1,500 - however as I mentioned I would love to chat further about project scope as this would impact my quote.
$1,500 NZD in 15 days
5.0 (29 reviews)
5.1
5.1
User Avatar
I'm an experience MS Access and vba developer, have been in this field for almost 10 years and working many MS Access or MS Access related project (using other development platforms). I'm also Brainbench MS Access certified. I'm confidence I can help you to finish this project for you as requested.
$750 NZD in 10 days
4.9 (37 reviews)
4.7
4.7
User Avatar
Hi Good Day! A serious freelancer here! I'm ok with 250NZD Budget. I have a lots of available time for this work, but need to know the full requirements to assess how long would it take to complete this project. I am a vba macro developer for over 8 years now and has strong knowledge with Ms Excel Formulas and Functions. I created different template and tools for financial reports. I am also a Project Management Analyst that focused in Financial and Metrics report and analyzation. Feel free to message me to discuss more about this project. Hope you will consider me to this project, I'll promise to give you the high quality of work. You can check my portfolio for some of my previous project in Ms Excel Macro Thank you!
$750 NZD in 3 days
4.9 (43 reviews)
4.6
4.6
User Avatar
Hello, I have much experience in VBA, VB development. I have solution to develop various kinds of applications such as finance app, enterprise app. I want discuss further via interview. Thanks Lang .....................................
$1,250 NZD in 20 days
5.0 (3 reviews)
4.2
4.2
User Avatar
Hi, you had selected a project cost between NZD 750-1500 and in your project description you mentioned nearly NZD 250. I am ready to make this project at NZD 250. I have 10+ years of experience in Advance Excel, VBA, Macros, Ms access and other office integration development.
$750 NZD in 10 days
5.0 (11 reviews)
4.2
4.2

About the client

Flag of NEW ZEALAND
Rotorua, New Zealand
0.0
0
Payment method verified
Member since Nov 5, 2018

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759) & Freelancer Online India Private Limited (CIN U93000HR2011FTC043854)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.