- This topic has 5 replies, 2 voices, and was last updated 18 years, 7 months ago by
.
-
Posts
-
-
I am looking for software that will help me remember where I have stored stuff in the boat and keep track of how much of each kind of stuff I have left. I’ve looked around the web with no success. Does anyone have a suggestion?
Lee Y.
#43Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now.
Post generated from Pearson424 Forum using Mail2Forum
-
There’s an excel sheet on the website that works ok.
On 3/28/08 7:55 PM, Lee Yonkers wrote :
I am looking for software that will help me remember where I have stored stuff in the boat and keep track of how much of each kind of stuff I have left. I’ve looked around the web with no success. Does anyone have a suggestion?
Lee Y.
#43Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. <http://us.rd.yahoo.com/evt=51733/*http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ >
Post generated from Pearson424 Forum using Mail2Forum
-
Lee,
In the past I've used exclusively manual inventory spreadsheets that allowed me to sort and print the inventory in a quasi-organized format, but it really didn't provide me with inventory control, just a baseline and penciled-in changes on a printed inventory. Because of the limitations these spreadsheets were used only for consumable items (e.g., food) and not spare parts and other important inventory items. I was never satisfied with this approach, but it allowed my to get by.
Because of your post and Pete Dubler's spreadsheet I have been motivated to re-look at this application. I spent this afternoon developing an inventory spreadsheet based on Pete's locker graphic that may eventually (if I actually finish it) provide a database of inventory items that can be sorted, printed, edited and whatever.
I've attached the current version of this spreadsheet. Most of the functions are just stubs (respond to mouse clicks, but don't do anything). The only function that works is the Inventory Entry function. I have used it to inventory the contents of one locker on Sarah. I have provided this very preliminary application not to solicit input on things that should be included in the final product, but just to let you know someone is looking at this with the P424 specifically in mind. It'll be a free application if I ever finish it as my motivation to do this is to satisfy my requirements. However, my goal is that the application can be modified by Excel-knowledgeable users without having to learn VBA (the application code).
Pete,
One thing I could use is your graphic of the storage lockers on Regina Oceani. I'd like to modify that graphic for the different locker configurations on the various P424s.John
On Sat, Mar 29, 2008 at 4:54 AM, Aaron Lynch < ([email][/email])> wrote:
There’s an excel sheet on the website that works ok.
On 3/28/08 7:55 PM, Lee Yonkers wrote :
I am looking for software that will help me remember where I have stored stuff in the boat and keep track of how much of each kind of stuff I have left. I've looked around the web with no success. Does anyone have a suggestion?
Lee Y.
#43Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. <http://us.rd.yahoo.com/evt=51733/*http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ >
—
Regards,
John Stevenson
http://www.svsarah.comPost generated from Pearson424 Forum using Mail2Forum
-
Here you go John, three versions: Powerpoint, gif, and jpg. I edit in
Powerpoint and then export in other formats.Could you throw them up on the website with your program (as you
complete it)?By the way, I had my boats whole maintenances history and complete
inventory in the Cap’n and the datafiles disappeared somehow. Still
searching backups for them… Time for a better program…Pete
John Stevenson wrote:
Lee,
In the past I’ve used exclusively manual inventory spreadsheets that
allowed me to sort and print the inventory in a quasi-organized
format, but it really didn’t provide me with inventory control, just a
baseline and penciled-in changes on a printed inventory. Because of
the limitations these spreadsheets were used only for consumable items
(e.g., food) and not spare parts and other important inventory items.
I was never satisfied with this approach, but it allowed my to get by.
Because of your post and Pete Dubler’s spreadsheet I have been
motivated to re-look at this application. I spent this afternoon
developing an inventory spreadsheet based on Pete’s locker graphic
that may eventually (if I actually finish it) provide a database of
inventory items that can be sorted, printed, edited and whatever.
I’ve attached the current version of this spreadsheet. Most of the
functions are just stubs (respond to mouse clicks, but don’t do
anything). The only function that works is the Inventory Entry
function. I have used it to inventory the contents of one locker on
Sarah. I have provided this very preliminary application not to
solicit input on things that should be included in the final product,
but just to let you know someone is looking at this with the P424
specifically in mind. It’ll be a free application if I ever finish it
as my motivation to do this is to satisfy my requirements. However,
my goal is that the application can be modified by Excel-knowledgeable
users without having to learn VBA (the application code).
Pete,
One thing I could use is your graphic of the storage lockers on Regina
Oceani. I’d like to modify that graphic for the different locker
configurations on the various P424s.John
On Sat, Mar 29, 2008 at 4:54 AM, Aaron Lynch <
There’s an excel sheet on the website that works ok.
On 3/28/08 7:55 PM, Lee Yonkers wrote :
I am looking for software that will help me remember where I
have stored stuff in the boat and keep track of how much of
each kind of stuff I have left. I’ve looked around the web
with no success. Does anyone have a suggestion?Lee Y.
#43
Be a better friend, newshound, and know-it-all with Yahoo!
Mobile. Try it now.
<http://us.rd.yahoo.com/evt=51733/*http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
<http://us.rd.yahoo.com/evt=51733/*http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ>—
Regards,
John Stevenson
http://www.svsarah.com <http://www.svsarah.com>
To unsubscribe, e-mail:
For additional commands, e-mail:
To unsubscribe, e-mail:
For additional commands, e-mail:Post generated from Pearson424 Forum using Mail2Forum
-
This is really cool John. I thought I was pretty good with Excel, but I
bow at your feet.So tell me, how does one bring back the menus once they close? I did
not find any macros to edit and study. Where are they or how did you do
this?Thanks,
PEte
John Stevenson wrote:
Lee,
In the past I’ve used exclusively manual inventory spreadsheets that
allowed me to sort and print the inventory in a quasi-organized
format, but it really didn’t provide me with inventory control, just a
baseline and penciled-in changes on a printed inventory. Because of
the limitations these spreadsheets were used only for consumable items
(e.g., food) and not spare parts and other important inventory items.
I was never satisfied with this approach, but it allowed my to get by.
Because of your post and Pete Dubler’s spreadsheet I have been
motivated to re-look at this application. I spent this afternoon
developing an inventory spreadsheet based on Pete’s locker graphic
that may eventually (if I actually finish it) provide a database of
inventory items that can be sorted, printed, edited and whatever.
I’ve attached the current version of this spreadsheet. Most of the
functions are just stubs (respond to mouse clicks, but don’t do
anything). The only function that works is the Inventory Entry
function. I have used it to inventory the contents of one locker on
Sarah. I have provided this very preliminary application not to
solicit input on things that should be included in the final product,
but just to let you know someone is looking at this with the P424
specifically in mind. It’ll be a free application if I ever finish it
as my motivation to do this is to satisfy my requirements. However,
my goal is that the application can be modified by Excel-knowledgeable
users without having to learn VBA (the application code).
Pete,
One thing I could use is your graphic of the storage lockers on Regina
Oceani. I’d like to modify that graphic for the different locker
configurations on the various P424s.John
On Sat, Mar 29, 2008 at 4:54 AM, Aaron Lynch <
There’s an excel sheet on the website that works ok.
On 3/28/08 7:55 PM, Lee Yonkers wrote :
I am looking for software that will help me remember where I
have stored stuff in the boat and keep track of how much of
each kind of stuff I have left. I’ve looked around the web
with no success. Does anyone have a suggestion?Lee Y.
#43
Be a better friend, newshound, and know-it-all with Yahoo!
Mobile. Try it now.
<http://us.rd.yahoo.com/evt=51733/*http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
<http://us.rd.yahoo.com/evt=51733/*http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ>—
Regards,
John Stevenson
http://www.svsarah.com <http://www.svsarah.com>
To unsubscribe, e-mail:
For additional commands, e-mail:
To unsubscribe, e-mail:
For additional commands, e-mail:Post generated from Pearson424 Forum using Mail2Forum
-
Pete,
That's what we call the “next release”. Currently you have to close the spreadsheet and re-open it to re-activate the menus.
The macros (actually VB code) should be available under that VB editor (Tools/Macro/VB Editor on the Excel menu)On Sat, Mar 29, 2008 at 9:39 PM, Pete Dubler < ([email][/email])> wrote:
This is really cool John. I thought I was pretty good with Excel, but I
bow at your feet.So tell me, how does one bring back the menus once they close? I did
not find any macros to edit and study. Where are they or how did you do
this?Thanks,
PEte
John Stevenson wrote:
Lee,
In the past I've used exclusively manual inventory spreadsheets that
allowed me to sort and print the inventory in a quasi-organized
format, but it really didn't provide me with inventory control, just a
baseline and penciled-in changes on a printed inventory. Because of
the limitations these spreadsheets were used only for consumable items
(e.g., food) and not spare parts and other important inventory items.
I was never satisfied with this approach, but it allowed my to get by.
Because of your post and Pete Dubler's spreadsheet I have been
motivated to re-look at this application. I spent this afternoon
developing an inventory spreadsheet based on Pete's locker graphic
that may eventually (if I actually finish it) provide a database of
inventory items that can be sorted, printed, edited and whatever.
I've attached the current version of this spreadsheet. Most of the
functions are just stubs (respond to mouse clicks, but don't do
anything). The only function that works is the Inventory Entry
function. I have used it to inventory the contents of one locker on
Sarah. I have provided this very preliminary application not to
solicit input on things that should be included in the final product,
but just to let you know someone is looking at this with the P424
specifically in mind. It'll be a free application if I ever finish it
as my motivation to do this is to satisfy my requirements. However,
my goal is that the application can be modified by Excel-knowledgeable
users without having to learn VBA (the application code).
Pete,
One thing I could use is your graphic of the storage lockers on Regina
Oceani. I'd like to modify that graphic for the different locker
configurations on the various P424s.John
On Sat, Mar 29, 2008 at 4:54 AM, Aaron Lynch < ([email][/email])
There's an excel sheet on the website that works ok.
On 3/28/08 7:55 PM, Lee Yonkers wrote :
I am looking for software that will help me remember where I
have stored stuff in the boat and keep track of how much of
each kind of stuff I have left. I've looked around the web
with no success. Does anyone have a suggestion?Lee Y.
#43
Be a better friend, newshound, and know-it-all with Yahoo!
Mobile. Try it now.
<http://us.rd.yahoo.com/evt=51733/*http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ
<http://us.rd.yahoo.com/evt=51733/*http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ>—
Regards,
John Stevenson
http://www.svsarah.com <http://www.svsarah.com>
To unsubscribe, e-mail: ()
For additional commands, e-mail: ()
To unsubscribe, e-mail: ()
For additional commands, e-mail: ()—
Regards,
John Stevenson
http://www.svsarah.comPost generated from Pearson424 Forum using Mail2Forum
-
- You must be logged in to reply to this topic.