Excel Template Stock Inventory - DPChallenge Forums

05/21/2007 12:44:05 AM · #1

I am hoping someone here knows how to use Excel...cause I don't. What I am after is a programme for stock Control. Below is a very basic sample that I quickly did up in PS. Basically I want to be able to put in each transaction for my products...whether it be stock in or stock out and a running balance but without having to manually do the balance totals each time.

Any ideas?

05/21/2007 12:45:18 AM · #2

The Layout is easy if it wasn't almost 1 in the morning id do it for you.

Then you just need a couple formula's to total things up as you enter items.

05/21/2007 12:46:59 AM · #3

Hehehe...that's where I come to a screaming halt....I take one look at Excel and just go blank. I really don't want to have to write out stock cards manually...yuck!

Tamron AF 28-300mm f/3.5-6.3 XR Di LD Aspherical IF for Canon

05/21/2007 12:50:09 AM · #4

ALright fine look give me like 5 or 6 minute ill make and upload the template.

Im starting now!

SDW

Canon EOS-60D

05/21/2007 12:51:37 AM · #5

Are you just needing the Bal table to add automatically?
How many products?
Do you want a total products table?

05/21/2007 12:53:13 AM · #6

Wow thanks guys.

At this stage it is just for 50 products...ranging from postcards, magnets, calendars...and whatever else will be added down the track. I have quite a few clients and over 4000 items already in stock and moving fast. So I have to get this sorted before I lose track of where I am up to.

05/21/2007 12:54:34 AM · #7

Originally posted by swhiddon:

Are you just needing the Bal table to add automatically?
How many products?
Do you want a total products table?

Im about 1 minute away from finishing the formatted template... if you hold up you can have it and insert the formulas for her.

05/21/2007 12:54:57 AM · #8

Originally posted by swhiddon:

Are you just needing the Bal table to add automatically?

Yes please.

Originally posted by swhiddon:

How many products?

Up to 50 at this stage.

Originally posted by swhiddon:

Do you want a total products table?

That would be great. Thankyou so much both of you.

Tamron AF 28-300mm f/3.5-6.3 XR Di LD Aspherical IF for Canon

05/21/2007 12:55:11 AM · #9

Originally posted by RainMotorsports:

Originally posted by swhiddon:
Are you just needing the Bal table to add automatically?
How many products?
Do you want a total products table?

Im about 1 minute away from finishing the formatted template... if you hold up you can have it and insert the formulas for her.

Yayyyyyyyyy thankyou.

SDW

Canon EOS-60D

05/21/2007 12:55:43 AM · #10

Originally posted by Judi:

What ver. of excel do you use and have you consider MS access. You can build a nice Database with it and put as many products as you wish as needed.

05/21/2007 12:56:35 AM · #11

Originally posted by swhiddon:

Originally posted by Judi:
Wow thanks guys.

At this stage it is just for 50 products...ranging from postcards, magnets, calendars...and whatever else will be added down the track. I have quite a few clients and over 4000 items already in stock and moving fast. So I have to get this sorted before I lose track of where I am up to.

What ver. of excel do you use and have you consider MS access. You can build a nice Database with it and put as many products as you wish as needed.

As far as a programatic way of doing it if you know how to use access that would be best.

05/21/2007 12:57:18 AM · #12

Originally posted by swhiddon:

I am open to all ideas. When I used to do stock control for companies it was all by hand...computers weren't in then.

I do have Microsoft Office Excel 2003.

05/21/2007 12:59:49 AM · #13

Okay im done it looks 95-100% liek what u drafted up including the red double lines lol.

Im uploading a picture then ill link a file. Then yall can decide if u want to use it or do something else lol.

05/21/2007 01:01:19 AM · #14

Thats what it looks like give me a second to upload the excel file to my ftp server.

05/21/2007 01:01:25 AM · #15

Originally posted by RainMotorsports:

Thankyou so much for that...!! I can't wait to see it. One day I will teach myself that stuff....!!LOL!!

05/21/2007 01:05:54 AM · #16

Thats what it looks like

and the link theres no formula's if scott wants to put some in or whatever go ahead, i just got bored enough to replicate ur picture.

//www.rainmotorsports.com/DPC/Book1-Cindi.xls

Page margins are set 0.9 inches at top for clipboard space. and 0.25 on the outer edges to maximize page usage.

Message edited by author 2007-05-21 01:07:09.

05/21/2007 01:10:39 AM · #17

I also didnt put in a total field. You can adjust the last line or so's borders or i can or scott can and put the lines and what not in.

05/21/2007 01:12:24 AM · #18

Thanks for that Jeffrey. The layout is just what I want...I just need the formulas now...!

Tamron AF 28-300mm f/3.5-6.3 XR Di LD Aspherical IF for Canon

05/21/2007 01:15:38 AM · #19

I can change the last line for the totals. Ive decided not to sleep lol. Been awake for only 8 hours anyways.

Um what are the totals supposed to look like? Im kind aholding off waiting for scott to say what the rest of his ideas are.

As far as access goes u can make output tables that look like our excel file. Then make an input form to put all the data into and itll osrt and total and even make reports. Thats once u got it all together im not all up on that.

However scott has alot more experience with excel and access then i do.

SDW

Canon EOS-60D

05/21/2007 01:15:42 AM · #20

Give me a few and I will have your formulas in place.

05/21/2007 01:17:43 AM · #21

Originally posted by RainMotorsports:

Wow...that sounds like magic.

05/21/2007 01:19:18 AM · #22

I mean its not something to whip up in 5 seconds but once someone gets it all setup its like a mini database program. I could actually write an actual database program... id rather let scott just do it in access lol.

Ive sorta given up pascal.

05/21/2007 01:21:02 AM · #23

Well it's all French to me lol!! You guys are great.

05/21/2007 01:23:51 AM · #24

Originally posted by Judi:

Well it's all French to me lol!! You guys are great.

Im not sure what scotts background is but at 19 i became the store manager of a new dunkin donuts/baskin robbins franchise. Well Dunkin brands doesnt exactly give u forms. They give you some guidelines and a franchise service manager for 24 hours lol.

I took office systems in high school so I had to take what i knew and well learn more lmao. Excel is a great tool for designing forms wether u want to actually use them on the computer or print them out and use them on a clip board.

Im still learning all the time.

Message edited by author 2007-05-21 01:24:08.