By continuing to use this site, you agree to our use of cookies. Find out more
Forum sponsored by:
Forum sponsored by Allendale Jan 24th

Excel Spreadsheet Help Requested

All Topics | Latest Posts

Search for:  in Thread Title in  
Peter Greene 🇨🇦02/12/2021 01:55:02
356 forum posts
4 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
19604 forum posts
997 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
7924 forum posts
1725 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

Support Our Partners
cowells
JD Metals
rapid Direct
Warco
emcomachinetools
MIDLNDS GARDEN RAIL Jan 2022
Eccentric July 5 2018
Eccentric Engineering
Subscription Offer

Latest "For Sale" Ads
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