We have an existing Excel work page with VB code that needs to be updated and finalized.
I have all the necessary code.
This Excel page and VB code works for 95%. The original programmer has no longer time to fulfill this task because he changed from worksite and has no longer spare time to do this.
I’m looking for someone experienced with Excel/Vb and who’s willing to analyze first what’s already done and how it works and use also as much as possible the excisting code.
In attachment, you’ll find the files we use for this.
It’s a worksheet for technicians, getting its data from an external/coupled xls database.
We have clients (let’s say 1.000) with some emails connected to it. The client can have several emails (for sending the worksheet, sending the invoice…). Each client has several machines (sometimes 100/client)
Each machine has some connected ’hyperlinks’ switching to drawings, manuals, info of that specific machine and stored on the computer in my office.
Also, a database with spareparts we use (let’s say 1.500) at a client with several price levels /client( not every client pays the same price for a sparepart)
Also a possibility to work as a subcontractor where some items then change in the worksheet. Client can’t see prices because the main contractor sees everything.
Each client has a specific hourly rate we work at, each machine has some time ‘connected’ to it giving us the time it takes to go to that specific machine in a factory.
If a work is not finished, the sheet is stored in a map Work Not Finished. This sheet can then be recalled to finish the job, eventually by another technician.
We have a map with Finsihed Jobs.
We have a map with Maintenance.
We can look in the history and do a search in different ways. The VB-search module is already made and works fine.
The worksheet is sent to a specific email as a pdf and/or as an xls file on the main computer.
All this is already working and programmed.
Reading a QR code is still needed so that we can scan a code attached toe each machine and the code automatically finds the machine/client and its history so that the technician doesn't need to fill in the whole worksheet.
Code still needs to be finetuned.
The project is running on a PC in my office and the intention is to connect via Teamviewer or something similar and fill in the worksheet.
Better should be that we can do it on-site on a tablet or a laptop and that we can store it then somewhere in the cloud. Cloud is what I prefer. This is not done this way yet and I’m listening to your proposal because this should make it a much better way of working for us.
The original programmer had not enough experience to accomplish this.
I’m also willing to listen if you can re-code this so that it works better, faster…as long as everything we need is implemented.
So, analyze first what is already done and make me a proposal. I’m also interested if you can re-program it eventually so that it looks nicer.
I also want that you mention very specifically that you have read all what’s explained above because my experience is that many sent me immediately after posting an automated or standard message.
So automated or standard messages will be deleted immdiately
I want anyhow a price span for this job and I don’t want someone who’s working on an hourly base where I have the chance that I’m paying for someone not experienced with this kind of job and where I ‘m paying someone to improve his Excel Skills. This is what happened in another project.
Good communication is essential
19 freelancers are bidding on average €123 for this job
I have Read All Your Long Description and I feel That I can Do Your Work Perfectly. Because I have experience In Excel Since 3 Years. Thanks Regards Koustubh Verma
Hi, I can accomplish your task accurately. You can see my portfolios as a sample. We can discuss further details over chat. I look forward to hearing from you. Thanks.
hello i am a fullstack developer with strong experience in excel and vba i can get this job done for you you can check my portfolio for more information about me at: [login to view URL]