Estimating Programming times

[GerryB55]

I'm working on a spreadsheet to estimate costs. In the past I have used a 'best guess' for estimating the actual PLC and HMI programming times. Does anyone have any ideas, or know where I might get some, on estimating times based on I/O count, number of modules, tags, number of screens etc? Any ideas gratfully recieved. Thanks in advance

[Chris Elston]

I use a rule "1 hour per I/O point". That seems to get me pretty close. Also you can use this spread sheet too. I think you'll like it. It uses minutes to calculate operations. plc_estimate.xlt

[TConnolly]

Excellent spreadsheet Chakorules. I use 8 hrs per page for electrical drawings + 1 day. I use a parametric build utility to generate the rough drawing from a spreadsheet, then I detail it. Double the time when its an IEC drawing. Each specialty symbol on the drawings adds 2 hours to the estimate. For programming: I use 1 day/discrete IO card upto 16 points, 2 days for 32 point cards. Analog entirely depends upon the application and my own experience. I swag it on the HMI, I haven't really developed a method there except to rely on my experience, sometime I take a bath on those.

[PdL]

Whatever you estimate on hours, if you think you got it all - multiply times 2. In the end it proves to work out that way.

[gravitar]

I've found that this formula works well on estimating materials cost, too :)

[LarryE77]

On ‎6‎/‎17‎/‎2005 at 0:18 PM, Chris Elston said:

I use a rule "1 hour per I/O point". That seems to get me pretty close. Also you can use this spread sheet too. I think you'll like it. It uses minutes to calculate operations. plc_estimate.xlt

How can I get a copy of the plc_estimate.xlt ?

[ControlsGirl]

On 6/17/2005 at 1:18 PM, Chris Elston said:

I use a rule "1 hour per I/O point". That seems to get me pretty close. Also you can use this spread sheet too. I think you'll like it. It uses minutes to calculate operations. plc_estimate.xlt

could you share this again?

[Chris Elston]

On 12/6/2024 at 4:19 PM, ControlsGirl said:

could you share this again?

This thread is 19 years old. LOL. I am not sure if I still have this file. I will check it might take me a few days because I am traveling until Thursday. I'll check though.

[Chris Elston]

@ControlsGirl okay I think this is it? The pricing and data is old. For Allen Bradley, I typically use the Proposal Works software now to get pricing but you can adjust hourly rates here to get an idea on quoting. I hope it helps.

plc_estimate.xlt