|
Hey folks!
Hoping someone can help me with Excel here.
My friend and I are making a card game in the vein of MTG and Summoner Wars. We've created a database of all our cards and would like to begin playtesting. The plan is to take the spreadsheet data and place 9 cards per letter-sized page, then print it out on cardstock.
I'm having difficulty with the formulas to make this work. The formula works when I drag it horizontally for the top 3 cards on a page, but of course not for the rest of the 6. Not to mention when I try to drag all 9 to the next page...
I do not have too much experience with excel. I've tooled around with INDIRECT() to try and make something work but I can't make it work. Ideally what I would is a sheet where I can update or add cards in the database and it will automatically be reflected on the printout sheet...
Any helpers would be appreciated! 
|
I think you should look up excel macros. Also there are a lot of helpful videos on youtube.
|
I don't quite understand what you are trying to do. What are they cards? Are they themselves arrays of data? (Sorry, no clue what the two games you mentioned are)
When you say " The formula works when I drag it horizontally", are you saying that after putting the formula in for the first card, you are able to copy it horizontally to complete the top row of cards?
Are you familiar with absolute cell references?
|
Calgary25986 Posts
LOL I just did this. It's a lot of work. Here I'll take a pic.
Easiest way is with a word document and one of those paper cutters. I did it at my office on the weekend.
It's easier to print 100 templates and fill them in by hand while you watch TV / streams than to try to get a perfectly formatted excel file.
Source: I spent many, many hours doing this.
|
Calgary25986 Posts
To answer your Excel question: it could be done with a simple macro, or create a dummy worksheet that puts the database in a format that the cards worksheet can reference. Indirect() would be one way of doing this.
Honestly, unless you have 500 cards doing it manually will be fine.
|
On January 31 2013 11:24 Chill wrote:LOL I just did this. It's a lot of work. Here I'll take a pic. Easiest way is with a word document and one of those paper cutters. I did it at my office on the weekend. It's easier to print 100 templates and fill them in by hand while you watch TV / streams than to try to get a perfectly formatted excel file. Source: I spent many, many hours doing this.
Haha! Impressive amount of work there.
We have 300 cards to print, so I reeaaaaaally donnnnt wannnnt to do that!
I came up with a hackjob solution though. I created a dummy sheet as per your suggestion, transposing the database so it would increment by column when I dragged the formula horizontally. I then dragged it until I used it up. I then separated it into three equal chunks, used Cut and PASTE VALUE to get the cards on 3 separate lines. Then I used PASTE FORMAT to paste the formatting/borders I want over the whole entire thing and VIOLA!
Hurahhh
|
|
|
|
|
|
EPT![[image loading]](/staff/Chill/card_game.jpg)
