Excel Template Stock Inventory - DPChallenge Forums

05/21/2007 01:33:08 AM · #26

Well the fact that you drew it out makes it easy to make the template. I dunno how much time you spent on it for me to get it straight would take forever in paint/photoshop. I find it quick todo in excel.

Once someone has it visual its easy for me to make, talking it out would take awhile and create disaster. When my current boss (who sucks with excel) needs a form i say scribble it on a post it note and ill get around to it later.

On that note i need to stop posting.... my new goal now that i vote on 100% of challenges is to eventually have as many comments as i do posts... the more i post the further away i get away from it and ill never catch up....

Message edited by author 2007-05-21 01:34:11.

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

05/21/2007 01:40:09 AM · #27

Judi, send me an email from you email account so i can reply and attach the excel ss. It was just a quick one and I can adjust it for you if you need me too.

As it sits now. It will hold 84 products with 1000 entries each. It will keep a running total in the bal area of each product as you enter the "in" and "out" table.

Scott

scottwhiddon@knology.net

Message edited by author 2007-05-21 01:41:25.

05/21/2007 01:41:20 AM · #28

Originally posted by RainMotorsports:

Thanks heaps for that. It only took me 5 mins to make in PS but I sat in front of Excel for 20 mins...lost!! LOL!!

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

05/21/2007 01:49:02 AM · #29

You should have it. Let me know if you need it adjusted or if you need any other info added to it.
SDW

05/21/2007 01:57:51 AM · #30

It looks great. I have a dummy question though...why is it duplicated with two separate horizontal scroll bars with both areas having the same information?

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

05/21/2007 02:02:06 AM · #31

Originally posted by Judi:

It looks great. I have a dummy question though...why is it duplicated with two separate horizontal scroll bars with both areas having the same information?

The vertical bar separates the left side information that you want to always stay in view. On the right side of the bar you can scroll to the product you want and enter information in the in and out tables. You don't need to scroll the left side.

I just helps you see the complete spreadsheet without loosing the site of your entry info "date", "description", "product #", and "inventory #". So you can be all the way at product 84 and still see the above information.
SDW

05/21/2007 02:06:59 AM · #32

Originally posted by swhiddon:

Originally posted by Judi:
It looks great. I have a dummy question though...why is it duplicated with two separate horizontal scroll bars with both areas having the same information?

The vertical bar separates the left side information that you want to always stay in view. On the right side of the bar you can scroll to the product you want and enter information in the in and out tables. You don't need to scroll the left side.

I just helps you see the complete spreadsheet without loosing the site of your entry info "date", "description", "product #", and "inventory #". So you can be all the way at product 84 and still see the above information.
SDW

Oh DOH!! I knew it had to be something obvious...thankyou thankyou.

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

05/21/2007 02:08:01 AM · #33

Originally posted by Judi:

Originally posted by swhiddon:

Originally posted by Judi:
It looks great. I have a dummy question though...why is it duplicated with two separate horizontal scroll bars with both areas having the same information?

The vertical bar separates the left side information that you want to always stay in view. On the right side of the bar you can scroll to the product you want and enter information in the in and out tables. You don't need to scroll the left side.

I just helps you see the complete spreadsheet without loosing the site of your entry info "date", "description", "product #", and "inventory #". So you can be all the way at product 84 and still see the above information.
SDW

Oh DOH!! I knew it had to be something obvious...thankyou thankyou.

Your welcome, anytime I can be of help just let me know.
SDW

Message edited by author 2007-05-21 02:08:17.

Dirt_Diver

Nikon D3s

Nikon AF-S NIKKOR 24-70mm f/2.8G ED

05/21/2007 02:09:25 AM · #34

Did you get it Judi???

Nikon AF-S NIKKOR 24-70mm f/2.8G ED

05/21/2007 02:12:04 AM · #35

Its okay im glad Judi didnt yell at me for putting Cindi in the file name..... somehow ive mixed up the two!

Dirt_Diver

Nikon D3s

05/21/2007 02:26:24 AM · #36

Originally posted by RainMotorsports:

Its okay im glad Judi didnt yell at me for putting Cindi in the file name..... somehow ive mixed up the two!

I don't think you want to go there with that. hahaha

05/21/2007 02:49:51 AM · #37

It's okay...I let him off over the Cindi stuff up!! This time anyway!!

Thankyou so much Jeffrey and Scott for coming to my rescue...you have saved me many hours of writing cramps.

Thankyou to both of you....MWAH!! Please let me know if you both got my email.

And thanks Joe for checking to see if I got this sorted.

05/21/2007 02:58:55 AM · #38

I dont know what to say lol.... really im trying lol.

For one my membership doesn't end anytime soon so i feel a bit guilty.

2 - Scott did most of the work and it wouldn't have taken much effort for him to do the part i did. I did however enjoy participating.

I think it should goto someone more deserving.

Given it alot of thought and ive been trying to get my co worker tony on here. He is a part time photographer that is about to go digital. He has given me a part time job post processing his work which helps me pay rent.

So if you don't mind im gonna beat him over the head one more time and let him have this gift membership. Ill be seeing him in about 4 hours.

I dunno what else to say...

05/21/2007 03:05:37 AM · #39

Originally posted by RainMotorsports:

That makes me very happy. I have lost count of how many Gift Memberships I have given away....but sometimes they go to members who don't need it for whatever reason...and yet everytime....they always pass it on to someone who does need it. So thanks Jeffrey...now go and leave some comments on some images for others...hehehehe!!

05/21/2007 03:07:21 AM · #40

Yeah you have made alot of comments a little more then 50% of your posts. Lol well the SC complains i talk too much. Well i just want it to be down the road... i guess i vote and comment too much too? DO you not appreciate my mad participation?

LOL the voting parts easy its gonna take time to make constructive comments but im working on it!.

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

05/21/2007 03:20:02 AM · #41

Originally posted by Judi:

What email?

05/21/2007 03:20:59 AM · #42

You might not have gotten it. Just check your inbox and your junkmail.

05/21/2007 03:25:47 AM · #43

Originally posted by swhiddon:

Originally posted by Judi:
It's okay...I let him off over the Cindi stuff up!! This time anyway!!

Thankyou so much Jeffrey and Scott for coming to my rescue...you have saved me many hours of writing cramps.

Thankyou to both of you....MWAH!! Please let me know if you both got my email.

And thanks Joe for checking to see if I got this sorted.

What email?

I sent it to this addy scottwhiddon@knology.net about 45 minutes ago

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

05/21/2007 03:42:15 AM · #44

Originally posted by Judi:

Originally posted by swhiddon:

Originally posted by Judi:
It's okay...I let him off over the Cindi stuff up!! This time anyway!!

Thankyou so much Jeffrey and Scott for coming to my rescue...you have saved me many hours of writing cramps.

Thankyou to both of you....MWAH!! Please let me know if you both got my email.

And thanks Joe for checking to see if I got this sorted.

What email?

I sent it to this addy scottwhiddon@knology.net about 45 minutes ago

Sorry I didn't get it. I just check my email. What was it?

05/21/2007 03:46:08 AM · #45

Judi when u resend it just make sure u don't get the two mixed up.

05/21/2007 03:56:36 AM · #46

I just resent it...you should have it in 30 seconds.

05/21/2007 03:57:40 AM · #47

Originally posted by Judi:

I just resent it...you should have it in 30 seconds.

Estimated time to arrival...now! j/k lol

Message edited by author 2007-05-21 03:57:51.

05/21/2007 03:57:59 AM · #48

Scott....these are the last 4 characters of your Gift - PUMZ
Jeffrey....these are the last 4 characters of your Gift - DXVB

Please confirm that you have the correct ones.

05/21/2007 04:09:54 AM · #49

Mynes right. I just wanted to make sure with the resend you have it straight and all. I just cant wait to get tony on here.

Since he still doesn't have his 350 or 400D, i plan on dumping my old olympus on him till he gets it. For the moment hes shooting with a modified 35mm Rebel T2.