I need to improve on my existing excel estimating solution

I have created an Excel workbook that connects to an Access DB. It pulls the labor and material and other information. The sales agent will review the plans and determine the SOW for the job and preselect the material for the estimator. After the estimator completes the takeoff and enters the quantities it will automatically calculate the labor and material cost, then add any taxes, commissions, markup etc. to determine a total job cost.

This should automatically create a material list and proposal to send to the customer. My office manager will manually enter the material list into QuickBooks and email to our supplier.

Phase I

- review existing spreadsheet and offer suggestions for improvement

- offer suggestions to make it more user friendly. I need this to walk them through the process and reduce the possibility for errors.

- I would like it to be as close to data entry as possible so it's easy for my sales agents to use and/or I can hire a low level person to complete the estimates. ie. walk them through the process of plan review and creating a SOW

- complete the material list and proposal portion

Phase II

- QuickBooks integration

- Add macros to automate certain processes ie. saving as PDF and emailing to the customer

- Save jobs with proposals and material lists for future use. We have customers who do the same job multiple times.

Phase III

- integration with CRM and Project Management software

- determine it should be web based

- Possible full VBA app.

I am open to suggestions

Beceriler: Excel, Microsoft Access, Excel VBA

Daha fazlasını gör: i have 12 scanned images and each one has 30 rows and 15 column i need you will type the data from images to excel, i have 36 statements that i need entered into excel the maximum number of entries per statement is 86 rows and two columns one c, i have 500 pdf to be transcribed in excel in 10 different fields need it quick!, i have 500 pdf to be transcribed in excel in 10 different fields need it quick, i have 60 business cards which i need the data to be entered into an excel sheet each category to have, i have 8600 full names and addresses of people that i need to be able to find their phones numbers i have the data in excel spre, i have an excel spreadsheet that needs some final touches to be ready i need an absolute expert at working an excel, i need a christmas and new year ecard for my prague czech republic based travel business the text needs to be editable i will ne, i need you to fill in a spreadsheet with data its an easy task to enter the data in excel sheet, i need a typist to type letters and excel spread sheets alexandra, i need to find a person with advanced excel skills, I need someone who is ready ton a project and ready to deliver it within 30-60 minutes only once job is started. , I need a small packaging solution designed and created that needs to look like a miniature cement bag with an envelope style pou, I need part time/ freelance video editor who knows to create special effects. It will be better if he could create some animated, I need a logo for a site where you can sell FUT (FIFA Ultimate Team) accounts. The name of the site is Sell FUT Accounts., I need a double sided business card created today, I need a banner for our health supplement website which sells vitamins, herbs and health products. The current website is at pur, I need an existing template redesigned with a specific target market in mind, I need an existing template redesigned, I need an existing website rebuilt

İşveren Hakkında:
( 0 değerlendirme ) Romania

Proje NO: #30975185

Bu iş için 19 freelancer ortalamada $168 teklif veriyor

(244 Değerlendirme)
(420 Değerlendirme)
(115 Değerlendirme)
(13 Değerlendirme)

Senior Excel VBA Expert. As 9+ years experiences in these field. I can give good quality work. I have read the guidelines of your work.I believe that i can provide you the best quality works you are anticipating from Daha Fazla

$200 USD in 5 gün içinde
(105 Değerlendirme)
(29 Değerlendirme)

Hello sir/ma, I'm interested in taking this task up for you. I'm a professional and also have good command over MS Excel especially pivot table, charts, advanced formulas, formatting, Excel VBA, R Programming Language Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(8 Değerlendirme)

Hello. From your job description I have learned that the requirements you have asked for are possessed by me very well. I am a graduate of computer science. Also, I have several good records in this field as I have be Daha Fazla

$60 USD in 2 gün içinde
(10 Değerlendirme)
(3 Değerlendirme)

Hi Hope you are doing good, I can perfectly help you with that. I am a professional Excel expert holding 7 years of experience in utilizing advance level tools and functions of Google sheets & Excel (including VBA an Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(11 Değerlendirme)

Hello there! Good day! I am interested in this project. I am an expert in handling projects like these. I have more than 10 years of experience in handling excel work. Please reach out to me to discuss further. Than Daha Fazla

$250 USD in 7 gün içinde
(5 Değerlendirme)

Greetings I have advanced knowledge of Microsoft Excel and I can help you complete this work. I am at your disposal for further clarification

$118 USD in 7 gün içinde
(2 Değerlendirme)

Hi, Greetings! ✅Checked your project details: Improve Excel file ✅Completed Time: 72 hours or your required deadline. Kindly, I work on many projects like your request, I can send you many samples of my work in Exce Daha Fazla

$83 USD in 2 gün içinde
(6 Değerlendirme)

Hi, Hope you are doing well. I have over 6 years of rich experience in data science and machine learning. I have worked hands on in Python with different datasets for data wrangling, data manipulation, data analysi Daha Fazla

$111 USD in 7 gün içinde
(1 Yorum)
(0 Değerlendirme)

✅ Convenient Price ✅ Best Ideas ✅ Perfect Implementations ✅ Fast Delivery in Deadline ✅ Regular Update ✅ 24 * 7 Live Support

$100 USD in 3 gün içinde
(0 Değerlendirme)

Hi, I read your project carefully and ready to work on it. I am waiting for details to start working on it. Hope to hire from you soon to discuss the details. Best greetings

$30 USD in 2 gün içinde
(0 Değerlendirme)

Hi, I'm an Excel VBA expert, gradute as process engineer. would be ready to assist in this mission related to VBA EXCEL. Looking forward to assisting you. Best regards. Yassine.

$250 USD in 7 gün içinde
(0 Değerlendirme)

Sounds similar to one of the projects i recently did : A sourcing tool for purchasing dept, that was integrated with a mysql database, generated pdfs, ppt presentations and approval request emails along the way. Will Daha Fazla

$200 USD in 7 gün içinde
(0 Değerlendirme)