World of KJ
http://worldofkj.com/forum/

Can someone help me out....
http://worldofkj.com/forum/viewtopic.php?f=3&t=6144		 Page 1 of 1
Author:  matatonio [ Tue Mar 29, 2005 9:15 pm ]
Post subject:  Can someone help me out....
Hello! :D

Can someone pretty please help me out with a spreadsheet, ive been doing my calculation by calculator all this time and im getting pretty sick of it!
ive been trying to make one but im not to good at using Excel an even worse doing the formulas :oops:

so... thanks in advance :smile: ........... :oops:
Author:  Anonymous [ Tue Mar 29, 2005 9:23 pm ]
Post subject: 
Will make you one in a few minutes.
Author:  matatonio [ Tue Mar 29, 2005 9:25 pm ]
Post subject: 
thank you so much Nebs! :smile:
Author:  Anonymous [ Tue Mar 29, 2005 9:28 pm ]
Post subject: 
There you go.

http://free-zg.htnet.hr/nebuka/predictionsheet.xls

There are probably some better formulas (which I forgot), but this seems to be working just fine.
Author:  matatonio [ Tue Mar 29, 2005 9:31 pm ]
Post subject: 
THANKS AGAIN!! :D
Author:  Anonymous [ Tue Mar 29, 2005 9:34 pm ]
Post subject: 
No problem. Hopefully it will serve you good. :-)
Author:  matatonio [ Tue Mar 29, 2005 9:38 pm ]
Post subject: 
isnt there one were you calculate the % drops, and that kinda things.... :???: ...
Author:  Anonymous [ Tue Mar 29, 2005 9:44 pm ]
Post subject: 
Not sure what you mean exactly, but probably it can be done.

Explain a bit more.
Author:  matatonio [ Tue Mar 29, 2005 9:51 pm ]
Post subject: 
well the predicting the % drops

an X movie does $35.5M and i want to calculate its possible drop for next week......



if you dont know, theres no problem ill figure it out.
Author:  El Maskado [ Tue Mar 29, 2005 10:01 pm ]
Post subject: 
Oh so are seperating the columns for a certain movie into weeks. Can I ask if each week uses the same drop multiplier because the way you set up the spreadsheet say that if colum A is for your total for a movie and B is the second week
and third is column C
You will have to do something like
=A1-(A1*.35) into column B
and something like if you need the 3rd week it would be B1-(b1*.35)=c

I have to run right now, if you still need help Ill be here tommorrow
I mainly use spreadsheets for cost estimates
Author:  Anonymous [ Tue Mar 29, 2005 10:11 pm ]
Post subject: 
matatonio, download again from same link.

There, you'll see where you can type what you think it will gross, and what you think it will drop, both options are there.

And results for each will be on right side.

Though, you'll have to type last weekends numbers there as well.

And remember, sheet uses , instead of . --> well, atleast I didn't found a way to use latter.
Author:  matatonio [ Tue Mar 29, 2005 10:16 pm ]
Post subject: 
its the same one... :???:
Author:  Anonymous [ Tue Mar 29, 2005 10:26 pm ]
Post subject: 
That's weird...I somehow lost it as well. Will get back soon.
Author:  Anonymous [ Tue Mar 29, 2005 10:50 pm ]
Post subject: 
Ok try now, it should be correct one.

Added daily increases on weekend as well. My best work! If it works that is. :D

In first row, you just type your predictions, last weekend grosses if you want, and actuals (estimates, projections). Rest is calculated.

In second, last weekend has to be added, and you can type gross, or percentage drop/increase, and results will come on right side for each of those two options.

And in third row, thursday gross is most important. And now just play with fri-sat-sun increases/drops. Nothing to be added in their gross selection, that's calculated.

Basicaly, where ever is zero, those cells are to be typed in. Gross, or drops/increases in %.


Now if someone could remind me what to do if my prediction is twice as big as actual? Getting negative %, so have to type 0% instead.
Author:  matatonio [ Tue Mar 29, 2005 10:57 pm ]
Post subject: 
:shock: Holy crap Nebs, thats great!!

Its indeed your best Work :D i really appreciate it!
Thanks!

i owe one :wink:
Author:  Anonymous [ Tue Mar 29, 2005 11:00 pm ]
Post subject: 
Well, it'll help me as well. ;)

Btw, as I mentioned above, if your prediction is twice as big as actual/estimate/projection, you'll have to manually type 0% in the cell with result. Otherwise, negative percentage comes out. It's a minor thing.
Author:  matatonio [ Tue Mar 29, 2005 11:03 pm ]
Post subject: 
got it! :smile:
Page 1 of 1 All times are UTC - 5 hours [ DST ]
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
http://www.phpbb.com/