View Poll Results: VBA Production coding rate

Voters
2361. You may not vote on this poll
  • Less than 50 lines per day

    732 31.00%
  • Less than 200 lines per day

    649 27.49%
  • Less than 500 lines per day

    563 23.85%
  • More than 500 lines per day

    188 7.96%
  • Wouldn't install it on a bet

    139 5.89%
  • SP2/ What's that?

    39 1.65%
  • I DO NOT have a jumpy mouse pointer with <b>Windows ME</b> and USB

    9 0.38%
  • I have a jumpy mouse pointer with <b>Windows 2000</b>

    8 0.34%
  • I DO NOT have a jumpy mouse pointer with <b>Windows 2000</b> and USB

    21 0.89%
  • I have a jumpy mouse pointer with <b>Windows XP</b>

    11 0.47%
  • I DO NOT have a jumpy mouse pointer with <b>Windows XP</b> and USB

    2 0.08%
Results 1 to 2 of 2
  1. #1
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Yilgarn region of Toronto, Ontario
    Posts
    5,453
    Thanks
    0
    Thanked 0 Times in 0 Posts

    VBA coding rates (office 2000+)

    What do you think your coding rate is today for production code in Office/VBA?

    Back in the early seventies we were told that studies showed that a good programmer could fully code (design, write and test)
    <UL><LI>50 lines of Machine language per day
    <LI>100 lines of Assembly language per day
    <LI>200 lines of 3rd generation code per day (COBOL, FORTRAN etc.)[/list]Note that this is more than "cutting code"; it is partitioning code into named procedures, developing suitable tests to prove the code worked, commenting the code, and writing up programmer documentation.
    Note too that this is for production code, not the throw-away samples we often write to see how something works.

    You can/should include the work involved in creating GUI forms by dragging controls onto the form, then double-clicking each control to generate event code for the controls.
    If you are engaged full-time as a VBA programmer and your company uses a library, you might tally the lines of code lodged in that library by you over the past year and divide by 220 business days per year.

    <FORM METHOD=POST ACTION="http://www.wopr.com/cgi-bin/w3t/dopoll.pl"><INPUT TYPE=HIDDEN NAME="pollname" VALUE="1230563894chrisgreaves">
    VBA Production coding rate
    <INPUT TYPE=RADIO NAME=option VALUE="1"> Less than 50 lines per day
    <INPUT TYPE=RADIO NAME=option VALUE="2"> Less than 200 lines per day
    <INPUT TYPE=RADIO NAME=option VALUE="3"> Less than 500 lines per day
    <INPUT TYPE=RADIO NAME=option VALUE="4"> More than 500 lines per day
    <INPUT TYPE=SUBMIT NAME="PollSubmit" VALUE="Submit vote" CLASS="buttons"></FORM>

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: VBA coding rates (office 2000+)

    I have no idea! Would take me too much time to figure out.

    And if I would havean idea, I think the variation in lines per day might give more information than the average itself <img src=/S/smile.gif border=0 alt=smile width=15 height=15>
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •