Login

Search the forums now!

Welcome, Guest. Please login or register.

April 29, 2024, 05:30:56 am
Pages: [1]   Go Down

Author Topic: urgent IT help (SAC IS HARD)  (Read 1403 times)  Share 

0 Members and 1 Guest are viewing this topic.

Faraz

  • Victorian
  • Trendsetter
  • **
  • Posts: 156
  • Respect: +1
urgent IT help (SAC IS HARD)
« on: August 13, 2008, 07:52:02 pm »
0
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
Logged
Currently bumming around VU doing marketing/international trade :)

jsimmo

  • Victorian
  • Forum Leader
  • ****
  • Posts: 847
  • Respect: +32
Re: urgent IT help (SAC IS HARD)
« Reply #1 on: August 13, 2008, 08:14:41 pm »
0
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.
Logged
2008: English , Business Management , IT: Applications , Further Maths , Studio Arts 
2009: Monash University

Faraz

  • Victorian
  • Trendsetter
  • **
  • Posts: 156
  • Respect: +1
Re: urgent IT help (SAC IS HARD)
« Reply #2 on: August 13, 2008, 08:21:21 pm »
0
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
Logged
Currently bumming around VU doing marketing/international trade :)

jsimmo

  • Victorian
  • Forum Leader
  • ****
  • Posts: 847
  • Respect: +32
Re: urgent IT help (SAC IS HARD)
« Reply #3 on: August 13, 2008, 08:24:37 pm »
0
wow.. that's confusing. I have no idea what your saying.. to me, nothing makes sense. sorry.
Logged
2008: English , Business Management , IT: Applications , Further Maths , Studio Arts 
2009: Monash University

Fitness

  • Victorian
  • Forum Obsessive
  • ***
  • Posts: 272
  • Respect: +1
Re: urgent IT help (SAC IS HARD)
« Reply #4 on: August 13, 2008, 11:02:46 pm »
0
Wait on. Is this a SAC?
A SAC is a test of your knowledge so I'm not sure I want to help. Sorry.
Logged
In 2006 Fitness played: IT - Processing and Management (32).
In 2007 Fitness played: English (28), Specialist Maths (25), Math Methods (32), Multimedia, Software Development (31).
In 2008 Fitness is playing: Computer and Mathematical sciences at Victoria University.

Quote from: enwiabe
Please don't ask for moderator. It will only hurt your chances.

Quote from: danieltennis
Hey guys,
How do I become a moderator?

excal

  • VN Security
  • Victorian
  • ATAR Notes Legend
  • *******
  • Posts: 3490
  • Über-Geek
  • Respect: +21
Re: urgent IT help (SAC IS HARD)
« Reply #5 on: August 13, 2008, 11:12:43 pm »
0
Quote from: 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

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.
Logged
excal (VCE 05/06) BBIS(IBL) GradCertSc(Statistics) MBBS(Hons) GCertClinUS -- current Master of Medicine candidate
Former Global Moderator

Mao

  • CH41RMN
  • Honorary Moderator
  • Great Wonder of ATAR Notes
  • *******
  • Posts: 9181
  • Respect: +390
  • School: Kambrya College
  • School Grad Year: 2008
Re: urgent IT help (SAC IS HARD)
« Reply #6 on: August 15, 2008, 04:37:41 pm »
0
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
Logged
Editor for ATARNotes Chemistry study guides.

VCE 2008 | Monash BSc (Chem., Appl. Math.) 2009-2011 | UoM BScHon (Chem.) 2012 | UoM PhD (Chem.) 2013-2015
Pages: [1]   Go Up