I am looking to automate some pretty repetitive work I do regularly. I use Excel daily and can’t help but think theres a faster way to get some of this data processed more efficiently. I have JSON data from a device I use to take measurements, but do not know how to integrate it with Excel.
I have a form I would like the data to go and an idea of how the process should go. I need an expert in Excel, certifications helps, but I know there are people without certification that are far more experienced.
Tight deadlines need to be met and I will need you to offer more efficient/modular ways to complete functions. Attention to detail is crucial and it needs to look as good as it functions.
Below is the process:
1) Open Excel Form.
- Each form is the same layout.
- "Drawing" name should match the Tab at the bottom.
- IMPORT button will import JSON data and list it under
"Loc. ID" and "Distance".
- FLIP button will flip/reverse the data top-bottom
for "Loc. ID" and "Distance"..
- Button 3 - To be decided.
- Formulas under "KF" should be left alone.
2) JSON data has more data than needed. Will need to thin out and only import 2 columns of data - "Loc. ID" and "Distance".
- Data is stored in metric units. Will be to convert meters to feet for Excel Form under "Distance" column.
3) Will need a READ ME document explaining how to edit the form, VBA code, etc in the event I need to change something.
Hi, I ll code the 3 buttons. I have a large experience dealing with JSON files. I ll also provide the "Read me" documents. I m ready t start. Thanks
Relevant Skills and Experience
Excel/VBA Expert
Proposed Milestones
$750 USD - m
Greetings sir, i am an expert freelancer for this job and your 100% satisfaction is assured if you allow me to serve. i can do this Task as per your requirement.
Relevant Skills and Experience
I have the 5 years of experience with excellent knowledge. please give me a chance to work on your project
Proposed Milestones
$750 USD - payment once project delivered
Hello Good Day
We can achieve this using an excel add-in. We are experts in developing excel addins. I can help you on this project. Looking forward to hear from you.
Thanks
Rinsad
Hey I am highly experienced in handling JSON and have advanced knowledge in .Net as well. I think I can handle your queries. Let's talk over in chat and discuss there
Relevant Skills and Experience
JSON/Visual Basic/Programming
Proposed Milestones
$800 USD - for complete
Hello. I can do it the BEST for you. I have read the details completely.
Please have a look onto my employer's reviews on my profile so you can get an idea of my quality work :)
Inbox me so we can discuss and continue!