• Log InLog In
  • Register
Liquid`
Team Liquid Liquipedia
EDT 18:14
CEST 00:14
KST 07:14
  • Home
  • Forum
  • Calendar
  • Streams
  • Liquipedia
  • Features
  • Store
  • EPT
  • TL+
  • StarCraft 2
  • Brood War
  • Smash
  • Heroes
  • Counter-Strike
  • Overwatch
  • Liquibet
  • Fantasy StarCraft
  • TLPD
  • StarCraft 2
  • Brood War
  • Blogs
Forum Sidebar
Events/Features
News
Featured News
Maestros of the Game: Week 1/Play-in Preview9[ASL20] Ro24 Preview Pt2: Take-Off7[ASL20] Ro24 Preview Pt1: Runway132v2 & SC: Evo Complete: Weekend Double Feature4Team Liquid Map Contest #21 - Presented by Monster Energy9
Community News
Weekly Cups (August 25-31): Clem's Last Straw?22Weekly Cups (Aug 18-24): herO dethrones MaxPax6Maestros of The Game—$20k event w/ live finals in Paris46Weekly Cups (Aug 11-17): MaxPax triples again!15Weekly Cups (Aug 4-10): MaxPax wins a triple6
StarCraft 2
General
Weekly Cups (August 25-31): Clem's Last Straw? #1: Maru - Greatest Players of All Time Maestros of the Game: Week 1/Play-in Preview Weekly Cups (Aug 11-17): MaxPax triples again! 2024/25 Off-Season Roster Moves
Tourneys
Sparkling Tuna Cup - Weekly Open Tournament Maestros of The Game—$20k event w/ live finals in Paris Monday Nights Weeklies LiuLi Cup - September 2025 Tournaments 🏆 GTL Season 2 – StarCraft II Team League
Strategy
Custom Maps
External Content
Mutation # 489 Bannable Offense Mutation # 488 What Goes Around Mutation # 487 Think Fast Mutation # 486 Watch the Skies
Brood War
General
BGH Auto Balance -> http://bghmmr.eu/ ASL20 General Discussion BW General Discussion No Rain in ASL20? Starcraft at lower levels TvP
Tourneys
[Megathread] Daily Proleagues Is there English video for group selection for ASL [ASL20] Ro24 Group F [IPSL] CSLAN Review and CSLPRO Reimagined!
Strategy
Simple Questions, Simple Answers Muta micro map competition Fighting Spirit mining rates [G] Mineral Boosting
Other Games
General Games
Stormgate/Frost Giant Megathread Nintendo Switch Thread Mechabellum Teeworlds - online game General RTS Discussion Thread
Dota 2
Official 'what is Dota anymore' discussion
League of Legends
Heroes of the Storm
Simple Questions, Simple Answers Heroes of the Storm 2.0
Hearthstone
Heroes of StarCraft mini-set
TL Mafia
TL Mafia Community Thread Vanilla Mini Mafia
Community
General
US Politics Mega-thread Things Aren’t Peaceful in Palestine Russo-Ukrainian War Thread Canadian Politics Mega-thread YouTube Thread
Fan Clubs
The Happy Fan Club!
Media & Entertainment
Anime Discussion Thread Movie Discussion! [Manga] One Piece [\m/] Heavy Metal Thread
Sports
2024 - 2026 Football Thread Formula 1 Discussion TeamLiquid Health and Fitness Initiative For 2023
World Cup 2022
Tech Support
Computer Build, Upgrade & Buying Resource Thread High temperatures on bridge(s) Gtx660 graphics card replacement
TL Community
The Automated Ban List TeamLiquid Team Shirt On Sale
Blogs
A very expensive lesson on ma…
Garnet
hello world
radishsoup
Lemme tell you a thing o…
JoinTheRain
How Culture and Conflict Imp…
TrAiDoS
RTS Design in Hypercoven
a11
Evil Gacha Games and the…
ffswowsucks
INDEPENDIENTE LA CTM
XenOsky
Customize Sidebar...

Website Feedback

Closed Threads



Active: 712 users

MS Excel Help for Card Game

Blogs > VelRa_G
Post a Reply
VelRa_G
Profile Blog Joined March 2010
Canada304 Posts
January 30 2013 17:41 GMT
#1
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!

Nuda Veritas
GohgamX
Profile Joined April 2011
Canada1096 Posts
January 30 2013 17:51 GMT
#2
I think you should look up excel macros. Also there are a lot of helpful videos on youtube.
Time is a great teacher, unfortunate that it kills all its pupils ...
category
Profile Joined July 2009
United States85 Posts
January 31 2013 02:05 GMT
#3
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?
Chill
Profile Blog Joined January 2005
Calgary25981 Posts
January 31 2013 02:24 GMT
#4
LOL I just did this. It's a lot of work. Here I'll take a pic.

[image loading]


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.
Moderator
Chill
Profile Blog Joined January 2005
Calgary25981 Posts
January 31 2013 02:30 GMT
#5
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.
Moderator
VelRa_G
Profile Blog Joined March 2010
Canada304 Posts
January 31 2013 19:44 GMT
#6
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.

[image loading]


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
Nuda Veritas
Please log in or register to reply.
Live Events Refresh
Next event in 1h 46m
[ Submit Event ]
Live Streams
Refresh
StarCraft: Brood War
Artosis 214
sSak 39
NaDa 17
yabsab 3
Dota 2
monkeys_forever444
League of Legends
Reynor12
Counter-Strike
Stewie2K568
Foxcn259
Super Smash Bros
PPMD64
Heroes of the Storm
Liquid`Hasu506
Other Games
Grubby2601
FrodaN1292
summit1g344
Sick203
C9.Mang0175
Mew2King62
ForJumy 26
Maynarde11
Organizations
Other Games
BasetradeTV23
StarCraft 2
Blizzard YouTube
StarCraft: Brood War
BSLTrovo
sctven
[ Show 16 non-featured ]
StarCraft 2
• StrangeGG 23
• AfreecaTV YouTube
• intothetv
• Kozan
• IndyKCrew
• LaughNgamezSOOP
• Migwel
• sooper7s
StarCraft: Brood War
• BSLYoutube
• STPLYoutube
• ZZZeroYoutube
Dota 2
• masondota22701
• WagamamaTV771
Counter-Strike
• Shiphtur191
Other Games
• Scarra1604
• imaqtpie1480
Upcoming Events
PiGosaur Monday
1h 46m
LiuLi Cup
12h 46m
Replay Cast
1d 1h
The PondCast
1d 11h
RSL Revival
1d 11h
Maru vs SHIN
MaNa vs MaxPax
Maestros of the Game
1d 18h
OSC
2 days
MaNa vs SHIN
SKillous vs ShoWTimE
Bunny vs TBD
Cham vs TBD
RSL Revival
2 days
Reynor vs Astrea
Classic vs sOs
Maestros of the Game
2 days
BSL Team Wars
2 days
Team Bonyth vs Team Dewalt
[ Show More ]
CranKy Ducklings
3 days
RSL Revival
3 days
GuMiho vs Cham
ByuN vs TriGGeR
Cosmonarchy
3 days
TriGGeR vs YoungYakov
YoungYakov vs HonMonO
HonMonO vs TriGGeR
Maestros of the Game
3 days
[BSL 2025] Weekly
3 days
RSL Revival
4 days
Cure vs Bunny
Creator vs Zoun
Maestros of the Game
4 days
BSL Team Wars
4 days
Team Hawk vs Team Sziky
Sparkling Tuna Cup
5 days
Liquipedia Results

Completed

CSL Season 18: Qualifier 2
SEL Season 2 Championship
HCC Europe

Ongoing

Copa Latinoamericana 4
BSL 20 Team Wars
KCM Race Survival 2025 Season 3
BSL 21 Qualifiers
ASL Season 20
CSL 2025 AUTUMN (S18)
Maestros of the Game
Sisters' Call Cup
BLAST Open Fall Qual
Esports World Cup 2025
BLAST Bounty Fall 2025
BLAST Bounty Fall Qual
IEM Cologne 2025
FISSURE Playground #1
BLAST.tv Austin Major 2025

Upcoming

LASL Season 20
2025 Chongqing Offline CUP
BSL Season 21
BSL 21 Team A
Chzzk MurlocKing SC1 vs SC2 Cup #2
RSL Revival: Season 2
EC S1
BLAST Rivals Fall 2025
Skyesports Masters 2025
IEM Chengdu 2025
PGL Masters Bucharest 2025
MESA Nomadic Masters Fall
Thunderpick World Champ.
CS Asia Championships 2025
ESL Pro League S22
StarSeries Fall 2025
FISSURE Playground #2
BLAST Open Fall 2025
TLPD

1. ByuN
2. TY
3. Dark
4. Solar
5. Stats
6. Nerchio
7. sOs
8. soO
9. INnoVation
10. Elazer
1. Rain
2. Flash
3. EffOrt
4. Last
5. Bisu
6. Soulkey
7. Mini
8. Sharp
Sidebar Settings...

Advertising | Privacy Policy | Terms Of Use | Contact Us

Original banner artwork: Jim Warren
The contents of this webpage are copyright © 2025 TLnet. All Rights Reserved.