Hi contest holder, I would like to submit an entry for this contest. I have a few draft idea that I've already start working on, might consider a discussion with you before I start fully develop Excel spreadsheet for this project. Thank you
The more I can understand, the more I can automate. For the Milli Ampere Test and Milli Second Test, it's pretty straightforward with a threshold. For the rest, it might be possible to do conditional tests with inputs from user. For eg, Push button for them to choose Completed or Fail. If they choose Fail, they need to specify reasons or actions (eg. requires replacement).
I don't know your industry well, but line chart seems weird since it's not about a trend. I could be wrong though. Happy to discuss further.
cách đây 2 tháng
Chủ cuộc thi
cách đây 2 tháng
The line chart is just for visual image of threshold and if the RCD tests above the line its a fail. If you can think of a better way I'm open.
The inputs are to show the mA and mS tests. The other tests we do are easily put into an over view area. Its more of a check list, to show we have completed screw test and x screws were loose. We have completed fire rating, we have completed push button test. Any findings are then written so the client can see what we have fixed.
It does help if the template is in a report style as this is much easier on the eyes for the clients.
#14 . Sir this is very near to your demand. I am willing to work with you on this. Reply soon. Sir everything in my data sheet is auto generated after the values mentioned in word doc table are put. It needs replacement or not is also processed and a remark is generated: "PBS fail for Lights & Door" as I have shown on in my entry. I am excited to hear from you.
This is Ramsha, Recently I was just looking for the similar job. Being a Freelancer I always try my best to make my clients happy and their satisfaction is my first priority. working for you would be honour for me .Thanks ?
Hi there, it is interesting work. I am working on it. I will update you with first Draft version of excel format of given information. I also want to know, will you be more happy to same things with some more facilities like search and generate reports etc using GUI with from and MS Access Database. Santosh
Thanks for update.
I think I was on wrong track.
I have more focused on Excel Table.
I am just submitting my entry to verify the the way data you are collecting and just to start chat and show something which you may like useful for your purpose.