Random Quasi Game Development Tips

A little off beat post – I decided to ask a few people around the studio some of their top tips for whatever they were working on at the EXACT moment I asked them.

Graham is going to start us off with this little gem:

[Graham]

My favorite trick that I use pretty regularly is the use of “$” to flag rows or columns as absolute references in MS Excel / Google Sheets

By default, when you reference a cell as part of a formula by clicking on that cell, spreadsheet programs will treat the reference as a “relative reference”. This means if you copy and paste that cell, your referenced cell will change in the pasted cell. For example, if you copy the formula “=A1*B1” from row 1 to row 2, the formula will become “=A2*B2”.

 

This is great in many cases, but sometimes you don’t want the spreadsheet to change your referenced cell when you copy/paste. In our example, if you wanted to multiply cell A1 by each item in column B, you’d want the formula on row 2 to be “=A1*B2”, and on row 3 to be “=A1*B3”, etc.

 

To have your spreadsheet behave like this, you simply have to change the reference from a relative reference to an absolute reference by adding the “$” character in front of the row/column that you don’t want to change when the formula is pasted. In our example, “=$A$1*B1” would cause the B1 to change when pasted, but the A1 reference to always remain the same.

 

 

Some more complex examples can be found here: 

 

 

To be honest, I thought everyone knew that trick. Graham doesn’t get out much. Alright, let’s move on to Augusto – Augusto, what do you have for us?

 

[Augusto]
Paste Special in Toonboom allows a variety of settings. I like this because I can duplicate the art, but retain individual animation on each. So this is flexible for the animation team, and our Editor just reads the 1 drawing instead of quadruple-ying (?) it.
It’s great to make adjustments to the art later in the project and not go crazy

If I edit one drawing (I extend one vertix)…

 

…it updates in the other copies of the drawing.


Whoah, nerd alert amiright? George, good old George, what say you?

[George]
Hiding the damn canvas in the scene view of Unity:
If you’ve got a canvas in your seen set to camera/screen fit, you’ll be happy to know you can hide that giant monstrosity in the scene view via the “Layers” dropdown in the top right corner of the editor. You can use this to hide the UI, or any other Layers within the scene view!
 

 

Thanks George. Now trusty David, take us home with a major whallop of a tip:

[David]
It’s pretty trivial but seems not widely known: Gmail ignores any dots in your name, so coolmcguy@gmail.com  and cool.mc.guy and c.o.o.l.m.c.g.u.y are all equivalent

 


 

Well if tips were like baseball, that’d be a sure home run David.
Hope you learned something, and if you have your own tip, tweet us @DrinkBoxStudios or email us at contact at drinkboxstudios.com.

 

Comments are closed.