Guides

@RottingFlesh Wow, I'm super impressed at how quickly you hammered that out! And it seems to work great, too :D

@Poisonedpaper hehe *super proud* I literally have no life, and stuff like coding really fascinates me c: Feel free to copy the codes for future projects! c;

@RottingFlesh Hey, at least there's two of us getting excited over spreadsheets here! I might use your code in the future (with proper credit, of course), a Sales Helper might be a good addition here :)

@Poisonedpaper Hehe, yeah cx. Oh, credit isn't necessary! ^^ And yeah, sales helper could be useful c: Or something along the lines of what I did, but like, fancier, a way to announce hatchlings! You could probably do something along the lines of the auction one (that one's awesome btw), with little to no altering. Anyway, I'm off to bed! cx

@RottingFlesh Goodnight! And let me know if you code any more exciting things ;)

@Poisonedpaper I found an error in the coding! In the concatenate part of the scry I forgot to add "=" after "&prig" [quote=original code] =CONCATENATE("http://flightrising.com/image_generators/dragonpic2.php?body=",C5,"&wing=",C7,"&style=",C1,"&gender=",C2,"&ages=",C3,[b]"&prig"[/b],C4,"&secg=",C6,"&tert=",C9,"&elem=",C10,"&tertgene=",C8,"&spec=prev.png")[/quote] [quote=actual working code] =CONCATENATE("http://flightrising.com/image_generators/dragonpic2.php?body=",C5,"&wing=",C7,"&style=",C1,"&gender=",C2,"&ages=",C3[b],"&prig=",[/b]C4,"&secg=",C6,"&tert=",C9,"&elem=",C10,"&tertgene=",C8,"&spec=prev.png")[/quote] Figured you'd like to know in case you had copied it somewhere cx

@RottingFlesh Yep, I actually came across that one myself, earlier ^^ Was going to ping you about it, but wanted to see if I came across anything else first. There's also a typo, "shadow" is misspelled in all the colour cells. I'm doing a bit of an overhaul on your code, by the way! Instead of endlessly listing if/thens I'm making it refer to a list instead, using VLOOKUP. It makes it easier to add new breeds/genes later on. If you do it with if/then you'll have to update every formula on every sheet separately, whereas if you use a reference list you only have to update one reference list (: https://docs.google.com/spreadsheets/d/1TZHABU9ikjeeMMClwA_zvVBne36GYK939Vu7mU1UnZ4/edit#gid=1843723106 ---------- This is what my sales template looks like right now: [columns][url=http://flightrising.com/main.php?dragon=30125][img]http://flightrising.com/image_generators/dragonpic2.php?body=12&wing=1&style=2&gender=1&ages=1&prig=1&secg=12&tert=28&elem=8&tertgene=0&spec=prev.png[/img][/url][nextcol][center][url=http://flightrising.com/main.php?dragon=30125][img]http://flightrising.com/rendern/avatars/302/30125.png[/img][/url] ========== [size=4][b]Whyrthala[/b][/size] Female Light dragon Shadow | Maize | Caribbean Iridescent | Toxin | Basic ========== Price: 8kt/5g Note 1 Note 2[/columns] [size=2][right][color=#CCCCCC]Auction/sales helper spreadsheet: [url=http://www1.flightrising.com/forums/gde/1815878]x[/url][/color][/right][/size]

@Poisonedpaper Oh crap cx. I'm still learning about it, so I didn't really know about VLOOKUP, but honestly that's probably what I'll do cx. It'll make it easier to add stuff! c:

@PoisonedPaper
Hey, thanks to you I just spent 3 hours on making my own bio template, and I didn't have any experience with formulas at all. That was a pain.
..and I think it actually turned out quite well.
At least those 3 hours weren't spent on nothing, I needed a new layout anyway xD
link if you want to take a look or something

@Poisonedpaper *screams*

The other day I created a template from scratch because I got inspired by chespin's super nice flight banners and then of course I had to make it into an auto formatting thing. Lemme tell you, it was a royal pain in my butt. All that code. SO MUCH CODE!!!!

Anyway, I think it looks A+, and if you do too, add it to your sheet because I love to spread things I've created and like *shrug* whatevs. Without further explanation, here's my "super annoying to code" bio template:

[linky]


Also, features:
- Changes colors and flag depending on flight
- rpg style abilities
- a lil quote
- a title
- text
- up to 12 friends/pals/enemies/frenemies etc
- up to 12 items with a cute shelf underneath


ALSO ALSO!!! I don't understand how you can even bother to make it look good, it just takes so much time (or maybe I'm just really lazy *x-files theme song*)