Freelancer: DanMh
Chia sẻ:
Báo cáo bài thi

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.


                                                                                                            Bài tham dự cuộc thi #                                        34
                                     cho                                         Building a excel layout for data collection
Bài tham dự #34

Bảng thông báo công khai

  • Kordelectrical
    Chủ cuộc thi
    • cách đây 2 tháng

    **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 Milli Amp test any number higher than 30mA is a fail. For the Milli Second test any number higher than 40mS is a fail. Can that be automated?

    • cách đây 2 tháng
  • Kordelectrical
    Chủ cuộc thi
    • cách đây 2 tháng

    This is a good layout Daniel

    • cách đây 2 tháng