Ah hah! An excel data table. I used to have to do sensitivity analysis using these.
How do you find MS Excel?
I like the concept of it and the keyboard short cuts. It’s the best thing for playing around with numbers and equations.
But the formulas are hopeless. For example if cell A1 contains the number “2”, and cell B1 contains “=-A1^2”, then B1 will show 4, not -4. ??? It violates mathematics.
VLOOKUP sucks, as do ‘array’ functions such as SUM(IF(A1:A100=true, 1, 0)) {ctrl+shift+enter} since they don’t work with non-array functions. For example SUM(IF(AND(A1:A100>0, A1:A100<1, 1, 0)) will not work. You have to do SUM(IF((A1:A100>0)*(A1:A100<1), 1, 0)) which is quite frustrating.
I also hate how there’s 30 ways to paste a copied cell except there’s no way to copy the textual contents (formula text) of a cell without manually highlighting the text within the cell.
Also, VBA sucks compared to Java. I still don’t know how to use it, it appears to have no structure to its method names.
No, Excel is right here. It’s about order of operations.
Your B1 formula -A1^2 is -2^2 = 4, which is correct.
You need to add parentheses -(A1^2), then you get -4.
I have found Excel very useful tool when designing algorithms, ie. for combat systems.
I just tested it on wolfram alpha and it says its -4:
square of -2 is … +4 O_o
Yes of course:
-2^2=-4
(-2)^2=4
My bad. Funny how so basic things can go wrong.
Excel blasphemes the math.
Indeed, power should take precedence over negation.
Cas
I came across the bug by accident and it took hours to figure out what was wrong.
I just googled it and apparently it’s known: https://www.google.com.au/?#q=excel+order+of+operations+bug
It was funny reading the links and seeing smarter guys than us on engineering forums argue about order of operations too.
Microsoft must have made a conscious decision to keep that bug forever to preserve backwards compatibility. So funny. Many bank models and other important things are done using excel, I wonder how often that error pops up and invalidates their equations?
Today I’ve been working with some more Scene2D and learning about Actions. I wanted some fading out transitions for my game and it was the easiest way, considering I’ve used Stage in my project a fair amount.
Likely going to load up a new project tomorrow and mess around with more Box2D and I am looking to use it for my next game fun, fun!
I look at the first equation like this:
-1*2^2=-4
When written out like that, it is easier to see why the outcome is -4 <—edit: I meant negative
It should still be -4.
-12^2 Starting equation
-14 Solve exponent
-4 Multiply
I made a logo for my graphics library: (Has absolutely nothing to do with graphics, but most people use graphics to make games, right?)
I converted my game’s music engine to use SourceDataLines instead of Clips, so now there’s no load time for songs and it’s amazing! And I even got it to loop properly too.
I wrote an article on bit manipulation, messed around with Sencha Touch, advanced on my L-Systems which I hadn’t touched since my topic on it. You can make some beautiful things with it. Landed my first 5 stair today as well
Started on an isometric project.
@mag
That’s really neat! Is it rendered in 3D or 2D? I’m guessing 3D by the shadows but I’m not sure. Also, are you using a noise function for that?
@screem
Thank you, it’s rendered in 3d using an orthographic projection matrix. Mainly because I want to be able
to rotate to any given rotation and the lighting.
The world is generated using perlin noise.