I run a lab company. We create customized reports for our clients, however these reports take a long time to create and edit. I want to create a piece of software cuts down on the time it takes to create a document like this.
I am attaching pictures of what I would like to do. Each picture has a number on it to hopefully make it clear what I need/want.
When I open the software I want three options to show up (1. Opening Page).
The three options are
1. Create Report
2. Create Format
When you Click "Database" I want (Picture [login to view URL]) to be taken inside the program to this fully functional and editable excel sheet. Now this excel sheet it directly linked to the graphics and other numbers in the final report. The formulas for the charts as well and data are already in this.
When you click Create Format (Picture 2. Create Format) I want these two options to appear.
The two options are
1. Create Company
2. Create Oil
1. When you click Create Company I would like a box with two options that I can put in and edit.
#1 Company name-
#2 Logo - this I need to be able to move and crop just like word
This is then saved under the companies name so when I click it in "create report" it automatically adds the name of the company and logo. An example of the word doc can be found "Create Company"
2. When you click create oil, a box comes up with
(End results should like this Name (Botanical Name) in report. ex. Bay (Pimenta racemosa))
Picture on the cover page: This I need to be able to edit the size ect...
When you click create report I want (Picture 5. Create Report) boxes on the left side, with the word doc in the middle and view of the first page of the database on the right side.
The boxes on the right side will determine what the word doc looks like.
When I select
Company Name: this adds the correct company name and logo to the report.
When I add in Batch #: this adds a number where the batch number is.
When I select Oil name/botanical name: this adds both those and the picture from "create oil" to the final doc.
There is a box called Pass/Fail where I will select Pass or Fail. This will change the word doc to display two options based on Pass/Fail. Those can be found under Word Doc (Pass and Fail). The information in the "Conclusions and the picture" change depending on pass or fail.
The final box needs to be a "comments" section. This will automatically be added to the bottom just like in "5. Final Report"
I also need to be able to add in information to the Database sheet which will then automatically transfer into the word doc (like in 5. Finalized Report)
Last of all I need to be able to add in a picture that (chromotograph) that with be copied from another program. I will do this manually.
The finalized product will look like (5. Finalized Report). This can then be saved as a PDF like in normal word.
Let me know if this is doable. I am willing to spend $200-300 on this project.
17 freelancerów złożyło ofertę na kwotę $584 do tego projektu
Hello. I can provide good, robust excel dashboard as per your requirements and drawings attached. 30 % of employers hiring me once hired me again. I have experience in the same. I CAN do this job, and do it well!
Hi, My name is Anis, i can do this program with the excel sheet (with a VBA program) If you are interested by this solution, we can speak about the all details over chat. Br;
Hi, I DON'T HAVE ANY PROJECT NOW I'm in programation since 10 years, It's my home really I CAN DO YOUR PROJECT PERFECTLY Please let me know if you want very good job Best regards, WGURU229 Thanks