Excel Position Managent

[mja]

I have been asked to develop a somewhat complicated position control
management program for my employer. We have approx. 1057 full time benefited
employees.
I'm sure this will take several posts to aceive this but basically what they
want.
To use postion control for budget and forecating information and reports.
Iam trying to decide the best way to layout the information to be able to
utilize the information in many different reporting criteria. I also need to
be able to link a filled postion with a salary schedule and figure benefits
and also need to be able to track unfilled postions in the same manner, and
also maintane locations and expense code for each, and I need to be apble to
protect a portion of the input fields but let some fields be maintained by
others.
Thank you in advance for any suggestions or help.

[Dave F]

You'd need a database for this application, not a spreadsheet.

"mja" wrote:

> I have been asked to develop a somewhat complicated position control
> management program for my employer. We have approx. 1057 full time benefited
> employees.
> I'm sure this will take several posts to aceive this but basically what they
> want.
> To use postion control for budget and forecating information and reports.
> Iam trying to decide the best way to layout the information to be able to
> utilize the information in many different reporting criteria. I also need to
> be able to link a filled postion with a salary schedule and figure benefits
> and also need to be able to track unfilled postions in the same manner, and
> also maintane locations and expense code for each, and I need to be apble to
> protect a portion of the input fields but let some fields be maintained by
> others.
> Thank you in advance for any suggestions or help.
>

[[email protected]]

This really sounds like something that would be better done in a
database like access.

While I am not a religious zealot like some people who post here, I
really do believe that it is a mistake to use Excel as a database.




mja wrote:
> I have been asked to develop a somewhat complicated position control
> management program for my employer. We have approx. 1057 full time benefited
> employees.
> I'm sure this will take several posts to aceive this but basically what they
> want.
> To use postion control for budget and forecating information and reports.
> Iam trying to decide the best way to layout the information to be able to
> utilize the information in many different reporting criteria. I also need to
> be able to link a filled postion with a salary schedule and figure benefits
> and also need to be able to track unfilled postions in the same manner, and
> also maintane locations and expense code for each, and I need to be apble to
> protect a portion of the input fields but let some fields be maintained by
> others.
> Thank you in advance for any suggestions or help.

[mja]

Any further info and suggetions would be greatly apperciated

"Dave F" wrote:

> You'd need a database for this application, not a spreadsheet.
>
> "mja" wrote:
>
> > I have been asked to develop a somewhat complicated position control
> > management program for my employer. We have approx. 1057 full time benefited
> > employees.
> > I'm sure this will take several posts to aceive this but basically what they
> > want.
> > To use postion control for budget and forecating information and reports.
> > Iam trying to decide the best way to layout the information to be able to
> > utilize the information in many different reporting criteria. I also need to
> > be able to link a filled postion with a salary schedule and figure benefits
> > and also need to be able to track unfilled postions in the same manner, and
> > also maintane locations and expense code for each, and I need to be apble to
> > protect a portion of the input fields but let some fields be maintained by
> > others.
> > Thank you in advance for any suggestions or help.
> >

[mja]

any further info or suggestions will be greatly apperciated

"[email protected]" wrote:

> This really sounds like something that would be better done in a
> database like access.
>
> While I am not a religious zealot like some people who post here, I
> really do believe that it is a mistake to use Excel as a database.
>
>
>
>
> mja wrote:
> > I have been asked to develop a somewhat complicated position control
> > management program for my employer. We have approx. 1057 full time benefited
> > employees.
> > I'm sure this will take several posts to aceive this but basically what they
> > want.
> > To use postion control for budget and forecating information and reports.
> > Iam trying to decide the best way to layout the information to be able to
> > utilize the information in many different reporting criteria. I also need to
> > be able to link a filled postion with a salary schedule and figure benefits
> > and also need to be able to track unfilled postions in the same manner, and
> > also maintane locations and expense code for each, and I need to be apble to
> > protect a portion of the input fields but let some fields be maintained by
> > others.
> > Thank you in advance for any suggestions or help.
>
>

[Bill Ridgeway]

Whilst a NG such as this is good for how do you do this or that what you're
wanting sounds more like a project. It sounds more like a job for your
local spreadsheet guru. This may cost more to do but a spreadsheet on which
important financial decisions are based which has design flaws may cost a
whole lot more in the long run.

Regards.

Bill Ridgeway
Computer Solutions

"mja" <[email protected]> wrote in message
news:[email protected]...
>I have been asked to develop a somewhat complicated position control
> management program for my employer. We have approx. 1057 full time
> benefited
> employees.
> I'm sure this will take several posts to aceive this but basically what
> they
> want.
> To use postion control for budget and forecating information and reports.
> Iam trying to decide the best way to layout the information to be able to
> utilize the information in many different reporting criteria. I also need
> to
> be able to link a filled postion with a salary schedule and figure
> benefits
> and also need to be able to track unfilled postions in the same manner,
> and
> also maintane locations and expense code for each, and I need to be apble
> to
> protect a portion of the input fields but let some fields be maintained by
> others.
> Thank you in advance for any suggestions or help.
>