Building a excel layout for data collection

Offentlig Præciserings Opslagstavle

• 

  xcelinfinity

  • 3 år siden

  I hope you actually went through all the entries. I spent an hour on it but you didn't rate it. It's fine though if you saw it and didn't like it.

  • 3 år siden
• 

  guyarnaud2

  • 3 år siden

  Thanks a lot , I wish The Application i have done will be chosen for the Happiness of your workers and and the efficiency of the work

  • 3 år siden
• 

  ashrafularifin

  • 3 år siden

  Hw about entry #61

  • 3 år siden
• 

  ajayasrpb

  • 3 år siden

  What do you think of #14 ?

  • 3 år siden
• 

  ashrafularifin

  • 3 år siden

  Graduate Engineer. 10 years of Excel experience. Interested for the job.

  • 3 år siden
• 

  sfaridahani98

  • 3 år siden

  Hye contest holder. I have submitted my sample draft regarding of data entry skills. It would be glad if you review my sample. Thank you!

  • 3 år siden
• 

  afikrifadzil

  • 3 år siden

  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

  • 3 år siden
• 

  Farrukh Saeed

  • 3 år siden

  hi dear contest holder. please review #52
  and provide your feedback for further improvements

  • 3 år siden
• 

  xcelinfinity

  • 3 år siden

  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.

  • 3 år siden
  1. 
     Konkurrenceafholder

     • 3 år siden

     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.
     
     Im open to designs that look more professional

     • 3 år siden
  2. 

     xcelinfinity

     • 3 år siden

     didn't know there won't be notifications when you reply. apologies for overlooking this. I'll do up a demo video for this by tomorrow.

     • 3 år siden
• 

  blui88

  • 3 år siden

  Kindly see entry# 44.
  
  Thanks
  
  Santosh

  • 3 år siden
• 

  azirasalim

  • 3 år siden

  Hi sir, please check my entry #43 . Kindly review, rate or any changes you want? Thank you in advance.

  • 3 år siden
• 

  Farrukh Saeed

  • 3 år siden

  please answer comments in #42

  • 3 år siden
• 

  Farrukh Saeed

  • 3 år siden

  wait for my entry I will give you fully automated resuable solution.
  I will submit my entry within a day

  • 3 år siden
• 

  maxius24

  • 3 år siden

  Hello, please see #36, Luis Fernando G. Thanks.

  • 3 år siden
• 

  mostafa24

  • 3 år siden

  Hello, please see #35 , Mostafa. I'm sure that you'll find it interesting. Thanks!

  • 3 år siden
• 

  DanMh

  • 3 år siden

  Hello, please see #34 porDaniel M. I'm sure that you'll find it interesting. Thanks!

  • 3 år siden
• 

  ajayasrpb

  • 3 år siden

  You missed #14 . Please rate it. Entry 13 and 15 are rated, but 14 is left

  • 3 år siden
• 

  muradutjaman

  • 3 år siden

  Can you please check the entry no 30???

  • 3 år siden
• 

  shivajishinde144

  • 3 år siden

  Hi,

  • 3 år siden
• 

  abdo65619

  • 3 år siden

  Please send me the conditions that determine the pass and fail of the tests.

  • 3 år siden
• 

  ranadeep1

  • 3 år siden

  I understand your requirement to create a template can we have zoom call or some other call to discuss clearly on what exactly your looking for.. I am intrested to solve your problem

  • 3 år siden
  1. 
     Konkurrenceafholder

     • 3 år siden

     Happy to discuss. Do you have a report style you have built that you can show me.

     • 3 år siden
  2. 

     ranadeep1

     • 3 år siden

     Yes i have some examples reports which i have worked on you can go through them during the call..

     • 3 år siden
• 

  ajayasrpb

  • 3 år siden

  #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.

  • 3 år siden
  1. 

     ajayasrpb

     • 3 år siden

     I did modify the layout slightly, but it will be beneficial for your team without any issue to client. Ping me for any further clarification

     • 3 år siden
• 

  blui88

  • 3 år siden

  Please check my entry# 20.
  And kindly, share your views to made further changes.

  • 3 år siden
• 

  muradutjaman

  • 3 år siden

  Please check the entry #18

  • 3 år siden
• 

  Mainman67

  • 3 år siden

  Hello Employer, I would like to know whether you only want the data presented in the table or is there anything else to be presented in the template Thank you.

  • 3 år siden
  1. 

     Mainman67

     • 3 år siden

     This is my first time.

     • 3 år siden
  2. 
     Konkurrenceafholder

     • 3 år siden

     Hi Amir, I will be delivering the same report again on a different building. I want to keep that layout just make it a template style so its quick to use on the next job.

     • 3 år siden
• 

  kalhororamsha123

  • 3 år siden

  Hii Kieran!
  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 ?

  • 3 år siden
• 

  ishwar32012

  • 3 år siden

  Hello sir, give me one chance to do your work. l saw your PDF. & I am very good in graph reading . l do your work in before your given time . please mail me for further details.

  • 3 år siden
• 

  blui88

  • 3 år siden

  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

  • 3 år siden
  Vis 1 besked mere
  1. 

     blui88

     • 3 år siden

     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.
     Thanks
     
     Santosh

     • 3 år siden
  2. 

     blui88

     • 3 år siden

     Kindly see my comments and my entry# 4.

     • 3 år siden
• 

  fahadkhan0612

  • 3 år siden

  Dear CH, do you want this data to be transported into excel or are there any specific requirements?

  • 3 år siden
  1. 
     Konkurrenceafholder

     • 3 år siden

     It would be best if I had some kind of template that I could use from Google doc or Google spreadsheet. Right now we collect data in a Google doc and its a lot of back and forth.

     • 3 år siden
• 

  mohamedflifl

  • 3 år siden

  What is the file format your RCD units store it's data in which will be processed from and exported to an Excel file?

  • 3 år siden
  1. 
     Konkurrenceafholder

     • 3 år siden

     At the moment I collect in google docs. I'm open to ideas as keeping with the existing template and making it easy for me to reuse would be the most beneficial.

     • 3 år siden
• 

  saif12me

  • 3 år siden

  can you please share your existing layout or format?

  • 3 år siden
  1. 
     Konkurrenceafholder

     • 3 år siden

     Hi please have a look at the existing report style i uploaded. If you have a better design than this to show the information and can build a template around that. Happy to answer any questions

     • 3 år siden

Vis flere kommentarer