Thanks for taking you time to view into this task.
When quoting for this I want, samples and basic terminology used.
If you refer to the business flow chart, this is the outcome I am after, you will also get and idea with what executive action i am after when you open and view the excel.
-Layout to be a interface that is visually easy, quick and simple
-Comments can easily be visible for each task, if there is an Issue or problem (as we get this a bit, machines are not as smart as us or mine anyway) hahah
-If emails with 1 or more jobs/files could pre populated into a job card for each file sent (not a requirement but would be great) or clients log onto a portal. I don't have a website but I have a domain, not really that interested as we only have 15 or so key clients.
-Time sheets need to be blocked out for them to edit but can see there past and present weeks earning
-Inventory to be updated on materials used, stocktake and restocking function
I have tried a number of apps but yet to find something that I was happy with the best one was Trello, I almost had job cards getting created and lists for each stage of the process, this will work but doesn't have a inventory or timesheet integration but with a bit of ironing out could work really good.
Currently I have a gmail account with 2 emails, but I am interested to move to the Microsoft E3 package + 3 users (yet to purchase)
If Excel is going to be used as a data collection point and the Microsoft business suite (power apps, Flow and BI) could be used to create an interface that ties all of the data together.
I do not want a big initial outlay, for this process
Please call me, once you have a read or need more info