(no subject)

[somedaybitch]

what fucking MORON decided that subtraction functionality in Excel didn't deserve it's own pre-calculated formula???????????????????

W.T.F?????? i curse that idiot to the Special Hell.

everything BUT subtraction???????

and it's not bad enough that you can't do it pre-calculated, IT'S NINE TIMES AS MANY STEPS TO DO IT BY HAND.

dear Microsoft,

thanks for making my calculation of frame ranges per scene, and total frames [over 29 thousand, btw] a complete HELL. i hate you like i can't articulate.

no love whatsoFUCKINGEVER,

me.

p.s. you open office coders??? yeah, you can fuck off too, ya lazy bastards.

Comments

[thevaliumsofalj.livejournal.com]

ummmmm, don't hate me for not telling you this now... but, excel allows you to define a cell as a number, and then all you do is. when you're entering it in, enter it in as a negative number (-1.00) if you want it to subtract that number. So, then all you do is run the summation formula and it subtracts all the subtraction you want done.

[themonkeycabal.livejournal.com]

I'm not sure, but if I get what you're saying -- the problem was that the numbers were already in the cell, so to go through and change all those numbers, just so they could be subtracted, was a huge pain. And really, why should you have to?

We figured it out in Open Office/NeoOffice, though, so there's a bit less cussin' and spittin'. Maybe ...

[thevaliumsofalj.livejournal.com]

We figured it out in Open Office/NeoOffice, though, so there's a bit less cussin' and spittin'

good! yay! :)

you shouldn't really have to.. i don't understand why it's not a formula. I don't know why I always assumed it was one of the default formulas. strange...

[somedaybitch.livejournal.com]

spook speaks truly. it's not helpful, nor should i have to, if i need to know ahead of time what possibly math i might want to perform.

and while Open Office lets me open new tiles, it apparently doesn't do the subtraction thing either in a way that's helpful.

:::kicks technology:::

the problem is that my starting number, the frame beginning, will ALWAYS be smaller than my ending number, the frame ending...thus, Open Office calculates it as a negative number and i'm back to square one with having to remove the negative.

and apparently it's not a formula because some FUCKTARD figured it was too simple to bother with.

[arthurfrdent.livejournal.com]

make sure you wear your steel toes, dear. I'd hate for you to break a toe kicking technology...

maybe contact evie, er eve11. she seems like the kind of kid that might have a plugin workaround for such things... and? can you set it too multiply each cell by -1 to kill the negative sign?

in all honesty, I'm not much of a power user in excel... I'd be way more likely to export the excel as a flatfile, and write a little somethin' in C to do computations. I've just been party way too often of excel being patched, or going bonk or whatever to trust that the algorithms will remain the same. I mean, you should see how many sheets have been turned to garbage by someone else reformatting them and returning them to me...

[somedaybitch.livejournal.com]

:::wonders if steel toe inserts will fit in vans:::