Best way to quantify time spent coding VBA?

[mykulpasskwa]

I'm working a very big VBA project from scratch and I'm supposed to present a demo to my boss on Monday. This week I've been working pretty much 4-5 hours a day and I'm barely an 1/18th of the way through if not less. I'm sure there are things I'm not accounting for.

If I were a say freelance coder and I wanted to figure out the best way to express to a client how much I can get done and how fast, is there a reasonable way to articulate that? For instance, is there a way to see how many lines are written for a project and I could figure out how many hours so that I could say "I can write 100 lines of code per hour and your project requires 1000 lines of code so i can finish it in 10 hours?"

My boss isn't going to ream me for not having much completed and I'm not going to be a freelance coder. I just want to figure out if theres a way to get that information in case those things ever do happen. Thanks for any input or ideas!

 

[J.Ty.]

Hi,

You might be interested to read this thread in StackExchange.
Keep in mind that coding is only part of the work, you will have start testing and debugging it at some point. And that eventually you will have to provide software maintenence.

J.Ty.

 

[mykulpasskwa]

Thats a very interesting read. Thanks for sharing that. I have to take a closer look at it when I have more time, but it's a really interesting premise. I wish I found coding when I was younger.