ATAR Notes: Forum
VCE Stuff => VCE Technology => VCE Mathematics/Science/Technology => VCE Subjects + Help => VCE Computing: Data Analytics => Topic started by: Faraz on August 13, 2008, 07:52:02 pm
-
guys I got this like super hard IT SAC the excel one its killing me the therory part is alright I can handel that but the excel formulas I need to use are something I have never seen or tryed doing before I mean I can do the simple IF and vLookup ones but damn are these hard I remembered one so I could see if anyone could help me out
its goes like this
*Light and sound equipment = $100 per hour per item
*Use = Yes, 4 staff for 10 nights, 5.5 hours
can any one work out the formula for it in excel 2007
cause I cants and this is like the most easy one GOD HELP ME
-
It's hard to work it with the small amount of information that you provided. Could you explain a little bit more and then I could help.
-
well thats all i was given Mao asked the same thing tho so Ill try to explain again with the two given info I am ment to produce and formula to work out the cost for example the cost of lighting is $100 per hour per item somehow I am ment to work out the cost with this info 4 staff for 10 nights, 5.5 hours so something like this I quess 4 staff which = $100 per hour for like 10x5.5 nights something like that in a excel formula
-
wow.. that's confusing. I have no idea what your saying.. to me, nothing makes sense. sorry.
-
Wait on. Is this a SAC?
A SAC is a test of your knowledge so I'm not sure I want to help. Sorry.
-
guys I got this like super hard IT SAC the excel one its killing me the therory part is alright I can handel that but the excel formulas I need to use are something I have never seen or tryed doing before I mean I can do the simple IF and vLookup ones but damn are these hard I remembered one so I could see if anyone could help me out
its goes like this
*Light and sound equipment = $100 per hour per item
*Use = Yes, 4 staff for 10 nights, 5.5 hours
can any one work out the formula for it in excel 2007
cause I cants and this is like the most easy one GOD HELP ME
What's the cost for labour? Do you have any constraints on that?
How many items are there per night?
It sounds like a simple arithmetic, but we need more information.
-
resolved.
quite a bit of data was given, inc the rate of labour, no. of items per night, etc.
it was all simple arithmetics, just quite a few variables that need to be recognised