need 2 templates

[Jennifer]

I need to find a way to track all of our various store leases - when started
- deposits paid, renewal dates - some 3 years, some 5 years, landlord,
address, etc. A way to put the lease amount in and know when the lease
payments are going up automaticially and then if possible a way to use this
information for our 10Q SEC filing by being able to figure out a drop dead
amount if we were to close the doors.
I also want to trace deposits on the buildings which may include not only
the lease deposit, but the various utilites also at each location.

 

[Gordon]

I need to find a way to track all of our various store leases - when
started
- deposits paid, renewal dates - some 3 years, some 5 years, landlord,
address, etc. A way to put the lease amount in and know when the lease
payments are going up automaticially and then if possible a way to use
this
information for our 10Q SEC filing by being able to figure out a drop dead
amount if we were to close the doors.
I also want to trace deposits on the buildings which may include not only
the lease deposit, but the various utilites also at each location.

Just a simple spreadsheet, with columns for all those details would
do....have you TRIED to set one up?

 

[JoAnn Paules]

I agree with Gordon. Sometimes we get so hung up on using templates and
making things "sexy", that we forget that the primary concern should be
functionality. One reason why I prefer not using templates in Excel is that
I need to understand what's going on with the various formulas because if
something goes wrong, I have to be able to fix it. If I created it, chances
are I can recreate it.

--

JoAnn Paules
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"

 

[Craig S Burchfiel]

Jennifer use the new office accounting 2008 it will do all you arte asking for,

 

[Jennifer]

We have a spreadsheet, but it is not dynamic enough - but thanks.

I agree with Gordon. Sometimes we get so hung up on using templates and
making things "sexy", that we forget that the primary concern should be
functionality. One reason why I prefer not using templates in Excel is that
I need to understand what's going on with the various formulas because if
something goes wrong, I have to be able to fix it. If I created it, chances
are I can recreate it.

--

JoAnn Paules
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"

Just a simple spreadsheet, with columns for all those details would
do....have you TRIED to set one up?

 

[JoAnn Paules]

What do you want it to do dynamically?

--

JoAnn Paules
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"

We have a spreadsheet, but it is not dynamic enough - but thanks.

I agree with Gordon. Sometimes we get so hung up on using templates and
making things "sexy", that we forget that the primary concern should be
functionality. One reason why I prefer not using templates in Excel is
that
I need to understand what's going on with the various formulas because if
something goes wrong, I have to be able to fix it. If I created it,
chances
are I can recreate it.

--

JoAnn Paules
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"

I need to find a way to track all of our various store leases - when
started
- deposits paid, renewal dates - some 3 years, some 5 years, landlord,
address, etc. A way to put the lease amount in and know when the lease
payments are going up automaticially and then if possible a way to use
this
information for our 10Q SEC filing by being able to figure out a drop
dead
amount if we were to close the doors.
I also want to trace deposits on the buildings which may include not
only
the lease deposit, but the various utilites also at each location.


Just a simple spreadsheet, with columns for all those details would
do....have you TRIED to set one up?