By continuing to use this site, you agree to our use of cookies. Find out more
Forum sponsored by:
Forum sponsored by Forum House Ad Zone

Excel Spreadsheet Help Requested

All Topics | Latest Posts

Search for:  in Thread Title in  
Peter Greene 🇨🇦02/12/2021 01:55:02
557 forum posts
8 photos
Posted by Michael Gilligan on 01/12/2021 23:13:05:

That’s the part where my little formulae might help … by providing a basic stock-control feature

 

I couldn't really see what your formula did for me Michael .... but then I readily admit to being as thick as three short planks when it comes to spreadsheets.

I really thought there would be a simpler answer. There is an existing function (on the right click button) which says "Delete entire row" .... it's what I use to do it manually - either one row at at time or CTRL or SHIFT select for multiple rows. (And in all honesty, it doesn't take that long - it's just tedious).

I thought there might be a way of checking a cell and invoking the aforementioned function if the cell is empty.

 

| Edited to kill the stupid smiley things   "

 

(Wouldn't it be nice if we could do inline responses? Real ones I mean.)

Edited By Peter Greene on 02/12/2021 01:57:34

Michael Gilligan02/12/2021 07:06:26
avatar
20289 forum posts
1064 photos
Posted by Peter Greene on 02/12/2021 01:55:02:
Posted by Michael Gilligan on 01/12/2021 23:13:05:

That’s the part where my little formulae might help … by providing a basic stock-control feature

 

I couldn't really see what your formula did for me Michael ....

.

Column B shows your current stock-count

Column C is the quantity that you like to have in stock

Column D makes the decision whether you should buy more

Column E tells you how many to buy [to restore your preferred stock-level]

.

If you print it out, complete with the blanks, then ; when the Supermarket has a special offer … you can easily make an informed decision ‘on the hoof’

MichaelG.

Edited By Michael Gilligan on 02/12/2021 07:07:14

SillyOldDuffer02/12/2021 10:30:45
Moderator
8893 forum posts
1998 photos
Posted by Michael Gilligan on 02/12/2021 07:06:26:
Posted by Peter Greene on 02/12/2021 01:55:02:
Posted by Michael Gilligan on 01/12/2021 23:13:05:

That’s the part where my little formulae might help … by providing a basic stock-control feature

I couldn't really see what your formula did for me Michael ....

.

Column B shows your current stock-count

Column C is the quantity that you like to have in stock

Column D makes the decision whether you should buy more

Column E tells you how many to buy [to restore your preferred stock-level]

.

If you print it out, complete with the blanks, then ; when the Supermarket has a special offer … you can easily make an informed decision ‘on the hoof’

MichaelG.

...

And if really keen, Michael's approach can be extended by adding more columns, such as:

Column F - Due-Out (quantity booked for later consumption, such as tomorrows dinner.)

Column G - Future Requirement (quantity known to be required in future, such as Xmas Turkey)

Column H - Due-In (quantity ordered in advance but not delivered yet)

Column I - Lead Time (time taken between reordering and actual delivery)

Column J - Shelf Life (time after which the item goes bad, such as Milk)

and many more...

I write lists on the back of an envelope and forget to take them with me...

smiley

Dave

All Topics | Latest Posts

Please login to post a reply.

Magazine Locator

Want the latest issue of Model Engineer or Model Engineers' Workshop? Use our magazine locator links to find your nearest stockist!

Find Model Engineer & Model Engineers' Workshop

Sign up to our Newsletter

Sign up to our newsletter and get a free digital issue.

You can unsubscribe at anytime. View our privacy policy at www.mortons.co.uk/privacy

Support Our Partners
Dreweatts
Eccentric Engineering
cowells
Eccentric July 5 2018
Rapid RC
Subscription Offer

Latest "Wanted" Ads
Get In Touch!

Do you want to contact the Model Engineer and Model Engineers' Workshop team?

You can contact us by phone, mail or email about the magazines including becoming a contributor, submitting reader's letters or making queries about articles. You can also get in touch about this website, advertising or other general issues.

Click THIS LINK for full contact details.

For subscription issues please see THIS LINK.

Digital Back Issues

Social Media online

'Like' us on Facebook
Follow us on Facebook

Follow us on Twitter
 Twitter Logo

Pin us on Pinterest

 

Donate

donate