Project manhours estimate

[Steve Z]

I know this isn't a code question, but could use some help.
What would a fair estimate be for the total manhours needed for a
non-certified person to develop a VB interface to an Access db with
reporting on time calculations between fields, monthly totals, and
cumulative totals?
It's not for me, it's for a friend. :)

[Bert Byfield]

Re: Project manhours estimate

> I know this isn't a code question, but could use some help.[color=blue]
> What would a fair estimate be for the total manhours needed for a
> non-certified person to develop a VB interface to an Access db with
> reporting on time calculations between fields, monthly totals, and
> cumulative totals?[/color]

"If you have to ask, you can't afford it."

[Steve Z]

Re: Project manhours estimate


"Bert Byfield" <BertByfield@no spam.not> wrote in message
news:S760e.1088 59$H05.97292@tw ister.nyroc.rr. com...[color=blue][color=green]
> > I know this isn't a code question, but could use some help.
> > What would a fair estimate be for the total manhours needed for a
> > non-certified person to develop a VB interface to an Access db with
> > reporting on time calculations between fields, monthly totals, and
> > cumulative totals?[/color]
>
> "If you have to ask, you can't afford it."
>[/color]
Correct.
However, there's no money connotation in my question. My...friend seeking
this information has no monetary incentive increase/decrease relative to the
answer, they simply want to assess how long a project like this could take
for a non-certified individual with some VB knowledge/experience and some VB
training in order to block time correctly.
Any input would be appreciated.

[Elef]

Re: Project manhours estimate

How skilled the developer?
How may reports?
How complex the DB?
How much "graphicall y refined" the reports?
How well defined the requests?
What's the change rate fo the report's design?
....
Complex reports may require programming.
Accessing the reports may require the construction of a user interface to
enter parameters.
....
As you see there's not a single answer, not even a range.

Bye
Elef.

"Steve Z" <stevez6996@hot mail.com> ha scritto nel messaggio
news:iQ30e.1199 4$wL6.5221@trnd dc03...[color=blue]
>I know this isn't a code question, but could use some help.
> What would a fair estimate be for the total manhours needed for a
> non-certified person to develop a VB interface to an Access db with
> reporting on time calculations between fields, monthly totals, and
> cumulative totals?
> It's not for me, it's for a friend. :)
>
>[/color]

[Steve Z]

Re: Project manhours estimate


"Elef" <m.p.b@*toglimi *rocketmail.com > wrote in message
news:aLW0e.2177 9$kC3.19@tornad o.fastwebnet.it ...[color=blue]
> How skilled the developer?[/color]
The developer has created databases and interfaces similar in the past under
no deadline. Subsequently they took considerable amount of time.[color=blue]
> How may reports?[/color]
10[color=blue]
> How complex the DB?[/color]
Not complex. Two tables, one relationship.[color=blue]
> How much "graphicall y refined" the reports?[/color]
Minimal. Standard report format.[color=blue]
> How well defined the requests?[/color]
Very well defined, monthly and cumulative as stated.[color=blue]
> What's the change rate fo the report's design?[/color]
These users will probably ask for additional reporting fields twice a year.[color=blue]
> ...
> Complex reports may require programming.
> Accessing the reports may require the construction of a user interface to
> enter parameters.[/color]
Yes, to enter date ranges.[color=blue]
> ...
> As you see there's not a single answer, not even a range.[/color]
You sure? I really just need a guesstimate. I'm figuring 80 manhours.[color=blue]
>
> Bye
> Elef.[/color]

[Elef]

Re: Project manhours estimate


"Steve Z" <stevez6996@hot mail.com> ha scritto nel messaggio
news:j8l1e.1199 8$uw6.5599@trnd dc06...[color=blue]
> [cut]
> You sure? I really just need a guesstimate. I'm figuring 80 manhours.
>[/color]

Based on your answers I guess that 80 manhours is reasonable.
A developer with some experience should take two day to fully understand the
db/requirements and prepare a basic report template (with you company's
logo, header and footer, etc.) with a nice date-range (and/or few other
params) entry form.
Add an *average* of 2 hours per report to build and debug every single
report.
Consider one or two days to review and refine them all with the customer
and, if you don't require any kind of tech or help doc, you have your job
done in even less time.

I forgot to ask you so I assumed thet the db is not very large and therefore
the performance is not an issue.

Bye
Elef

[Steve Z]

Re: Project manhours estimate


"Elef" <m.p.b@*toglimi *rocketmail.com > wrote in message
news:PbC1e.2384 0$kC3.10413@tor nado.fastwebnet .it...[color=blue]
>[/color]
{cut}[color=blue]
> I forgot to ask you so I assumed thet the db is not very large and[/color]
therefore[color=blue]
> the performance is not an issue.
>
> Bye
> Elef
>[/color]
Thanks for the confirmation and the responses.
You are correct, performance is a minimal issue, the db will handle 10-20
entries per day.