Welcome, Guest
Please Login or Register.    Lost Password?

Making a Excel shet to track Tiles with a pic why
(1 viewing) (1) Guest
Go to bottomPage: 1
TOPIC: Making a Excel shet to track Tiles with a pic why
#8250
Making a Excel shet to track Tiles with a pic why 8 Years, 9 Months ago  
I am starting a Excel sheet to track the tiles we have, I do plan to post after i am done.

I do need a little help, is there a way I can get pictures (like the ones you use on the store) of each tile by it self and maybe each of the add-on peaces. Something you can zip and e-mail to me or put on the site for me to download?

Thanks for making a great product

I hope i am not out of line by posting my pic in this group, if it is i will be glade to move it.
Click
Kobold
Posts: 7
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#8251
Making a Excel shet to track Tiles with a pic why 8 Years, 9 Months ago  
Hi Click

Something I did (albeit not for all pieces) was to start with the pictures in the shop. I downloaded them and combined 2-3 of them to make small labels for my storage boxes.

This wouldn't be complete - but it should be a start. I would ask first if you want to redistribute - but I guess such an Excel sheet would just be helpful so can't see anyone objecting.

Will see if I get the time to make a picture of my boxes and what I did there.

One box containing all floor pieces and the stairs has a floor piece and a stair on them. One box has all the corners and round corners etc.

Such a sheet would be useful to me to align what is where. The cavern set is really awkward to store/fit and after the game the right pieces need to go into the 4 different boxes to fit properly.

Thod
Thod
Minotaur
Posts: 1046
User Offline Click here to see the profile of this user
Location: Deal, United Kingdom
The administrator has disabled public write access.
 
#8252
Making a Excel shet to track Tiles with a pic why 8 Years, 8 Months ago  
My plan is to make it so everyone can use it.

and I think it would go comthing like this: Picture, part name, qty, size, total size (qty X Size) and the last colum would be a place for you to write in where the peace is stored ie: Box "A"

are alll of the pic still on the store, even the sets they stoped using? how about peaces that only come in sets, i would need to get them as single pictures

If anyone has more ideas i would beglade to add it to the list.
Click
Kobold
Posts: 7
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
#8253
Making a Excel shet to track Tiles with a pic why 8 Years, 8 Months ago  
My plan is to make it so everyone can use it.

and I think it would go comthing like this: Picture, part name, qty, size, total size (qty X Size) and the last colum would be a place for you to write in where the peace is stored ie: Box "A"

are alll of the pic still on the store, even the sets they stoped using? how about peaces that only come in sets, i would need to get them as single pictures

If anyone has more ideas i would beglade to add it to the list.



I Know that it is Sorta' Anal, but it might be Kewl to have a (Which Set Did this Piece Come out of" Catagory?)
MyLordVoid
Minotaur Lord
Posts: 2552
User Offline Click here to see the profile of this user
Location: Florida... (The One in North A
The administrator has disabled public write access.
"To Succeed We Attack!"
 
#8254
Making a Excel shet to track Tiles with a pic why 8 Years, 8 Months ago  
Click, MyLord

I'm not sure it works that simple with a column from which set this piece is. Some pieces are from different sets. But I think this is a good idea to be expanced. Have three columns. Total pieces, individual pieces, pieces from sets. Only the second column is a number - the total and the pieces from sets are formula.

On an additional sheet you have the number of sets you own. You buy a new set - add a number here. The pieces of sets will be linked by formula to this sheet and therefore automatically update.

This would keeping track / filling out the sheet a lot more user friendly. Having lost a piece (beware !!) or made a custum piece out of it - enter negative values in the individual column.

Click: In regard to the photos - NO - the order pages will contain currently only a fraction of what is available. But my suggestion would be - go to the pages and use them as a start.

With this build a first spreadsheet. Post in in the How to use section as an ongoing project. I'm happy to chime in at that stage and add some bits - time permitting. I also left my e-mail as a private message with you.

Thod
Thod
Minotaur
Posts: 1046
User Offline Click here to see the profile of this user
Location: Deal, United Kingdom
The administrator has disabled public write access.
 
#8255
Making a Excel shet to track Tiles with a pic why 8 Years, 7 Months ago  
Guys,

I'm a database specialist for my State government :oops: , and I gotta tell you, this sounds like a prime candidate for an Access spreadsheet!
You've inspired me; now I have to go build it!
Access can store PICs as well as text, numbers, etc.; and I "just happen :twisted:" to own a digital camera - a nice 4.1 megapixel Sony!!
Hee :twisted: Hee :twisted: Hee :twisted: :!:

Check with me later. I may be able to get it running and post it as a Zip file when it works. :P

I TOLD all of you I'm The Mad Yank!

Jim Kratzer
jkratzer
Minotaur Lord
Posts: 2057
User Offline Click here to see the profile of this user
Location: Baltimore, MD
The administrator has disabled public write access.
Jim Kratzer, a/k/a The Mad Yank
Proud Vietnam Veteran, LOUD VFW Lifer
insane GM
 
#8256
Making a Excel shet to track Tiles with a pic why 8 Years, 7 Months ago  
I have to ask you a few questions jkratzer.

1) Do you live in the city or county? If city, what sector? (e.g. Essex, Violetteville) If county, where? I had quarters in Catonsville for about two years in the mid-90s so I know the area a fair bit.

2) Is Shore Leave new since then? I never heard of it when I was posted there in the Baltimore area. At the time, if I played at a store, it was at The Armory's showroom/store.
RabidFox*
Ogre
Posts: 962
User Offline Click here to see the profile of this user
Location: Western U.S.A.
The administrator has disabled public write access.
SF: Starter(3), Passage(2), Alpha(7), Beta(2) someday soon;
Cavern: Cavern, Cavernous Passages, many individual pieces, Cavernous River & Wall and Cavernous Lake someday soon;
Fantasy: Room & Passages, Room, Octagonal Room, Wicked Additions I&II, Adv. Builder, Diagonal Walls Set, Dungeon Accessories, Medieval Furniture, many individual pieces.
 
#8257
Making a Excel shet to track Tiles with a pic why 8 Years, 7 Months ago  
jkratzer::: Please let me know if I can help. I can take some pics and send you or you can download them from me from kaza. taking picks of all the diff pieces my be daunting. If I can help in the medial task I will.
whitewind
Minotaur
Posts: 1229
User Offline Click here to see the profile of this user
The administrator has disabled public write access.
 
Go to topPage: 1
Your Cart:
0 Items Order Total: $0.00

0 Product
$0.00



Login to see your account info

Once you login you will be able to see your different account areas here, order history, shipping information and your account information.