Excel layout for data collection
Hello! Thanks for accepting and seeing my work on this project. "** I have included a page with an intro (the 1st page of the word file) but, if you think it's not useful you can erase it. **On the tab ""DB_RDC"" you can see that I have consolidate everything in one single table for a better and friendlier manipulation of the information, you can edit whatever that you want, I also added a graph that will automatically update when you change the numbers in ""Milli Ampere test"" or ""Milli Second Test"". **For the column of Pass| fail it will automatically change the color font whether is Pass or fail, I don't know if there is any criteria so that base on the numbers of Ampere/Second test it can just automatically fill (if you want that please let me know) meanwhile you have to fill it manually. **For the overview column the font color is all manual. **A PLUS :) ... I also added a super simple dashboard where you can select a unit and the information will show it.