There are three different sets of data. Production, Sales and Consignment. The idea is to track the Quantity of Sales/Production/Consignment on each Product (30k, 25k, 10k, 5k, 3k, 1k, 550litre, Cartage, Slimline 2100, Donga Tank, Round Tub, 25 Trough, 35 Trough, 300 Bund, 1000 Bund, Septic 3k) over a period of time. Each of these correlate to a number of Kilograms of Product which I also what to track. Amounts of material are used each day (Mist, Merino, Mt Blue, D Green, Slate) and that needs to be input also.
All this data needs to be input using a google form (for people without any excel or sheets experience). The form needs to be able to be published to a web page. The data will input automatically into a google sheet so we can create a dashboard with adjustable time parameters (day by day, week by week, month by month, year by year ect.). It must look tidy and clean.
I can elaborate on anything you need.
I will NOT work on milestone payments, I will pay once the job is done.
Unless you are 100% sure you can complete this job please don't bid.
Local Australian with extensive business analytics/vba/excel dashboard creation experience. Ive worked as an operations analyst at some of the biggest ecommerce companies in aus/globally (eBay, Groupon) creating dynamic automated reporting solutions in excel/google sheets to cater for business needs. Can get this done for you quickly and accurately. Happy to share examples of previous work.
[login to view URL]
$666 AUD in 5 days
5.0 (1 review)
1.2
1.2
6 freelancers are bidding on average $443 AUD for this job
so it seems you are having your own mini MRP :)
I can design you a comprehensive database on google, the input of which will be your google forms. It will be shared among authorized people to maintain.
Once having Production, Sales and Consignment information, you have different ways to design dashboards. I'm expert in that as well, so can advise/suggest to have better analysis
looking forward to have working relationship with you
do check my profile which speaks about my work and working relationship with clients ;)
all payments to be made after finalization of the project.
cheers,
Hi, I am interested in your project but I have some questions. First, you want to create a Google Sheet or a Google Form? And second, how exactly I have to input the data?
I have 12 years’ experience in Word, Excel and Data Entry and Process and alsi in Google Forms.
I am experienced in Excel functions and I can easily operate Excel spreadsheets.
Please contact me for more details. Thank you!