Jump to content

Muppet

Member
  • Posts

    36
  • Joined

  • Last visited

Reputation Activity

  1. Like
    Muppet reacted to 191x7 in Poll: What Content Do you Want to See from Linus Media Group   
    That game video was booooooooooooooring.
  2. Like
    Muppet got a reaction from Kuzma in Products that that you really want, but don't exist   
    A laptop with 2 screen!, one that folds out to the right. But why stop there, why not have another fold out to the left! The laptop may be a bit thick, not only from the extra screens but also the bigger graphics card that will be needed. 
  3. Like
    Muppet got a reaction from IAcKI in Products that that you really want, but don't exist   
    A laptop with 2 screen!, one that folds out to the right. But why stop there, why not have another fold out to the left! The laptop may be a bit thick, not only from the extra screens but also the bigger graphics card that will be needed. 
  4. Like
    Muppet reacted to WanderingFool in Excel limitations   
    Bit confused at what you are doing, given that =IF(OR(V26:V45>=13,W26:W45>=13,X26:X45>=13),"Rejected","Accepted")
    only looks at V26 >= 13, W26 >= 13 and X26 >= 13....if V27 were to be 14 it would still say "Accepted"....unless you are referring to each row being rejected....at which point the above if statement is needlessly long.
    e.g. if each row gets rejected =if(or(v26>13,w26>=13,x26>=13..... works just as well, with less confusion.
     
    Anyways that was assuming you meant rows get rejected if any of them exceed 13, the rest of this post will discuss if the entire 20x20 grid gets "rejected" if one column/row is invalid
     
    Since you have said you were googling for excel functions, might I recommend using the MAX function....from what I am assuming you could simplify it.
     
    e.g.
    =IF(MAX(V26:X45) >= 13, "Rejected", "Accepted")
    It should be noted in this example it does not perform the same way as your =IF(OR(V26:V45>=13,W26:W45>=13,X26:X45>=13),"Rejected","Accepted")
     
     
    Now I put the =IF(MAX(V26:X45) >= 13, "Rejected", "Accepted") in the cell Y26, now here is the trick that will help you in the future....I copied it, right click on B49 and paste special this opens a dialogue, now look for the check mark that says transpose, click ok....you should now get =IF(MAX(B46:U48) >= 13, "Rejected", "Accepted")
     
    Transpose basically turns a vertical calculation into a horizontal calculation.
     
    You now have two formulas, one that checks columns and one that checks rows...if you want you could reduce it by one by copying the text in one and or'ing the results from max
     
  5. Like
    Muppet reacted to mr moose in Australian National Broadband Network Discussion   
    Further information:
     
    I found this interesting: http://www.abs.gov.au/ausstats/abs@.nsf/Products/8153.0~December+2012~Chapter~Type+of+access+connection?OpenDocument
     
    These are the internet connection types in  Australia  in 2012, as you can see the number of people with mobile internet connections is more than the number of people with dsl and fibre together. This would go a very long way to reducing the national average for connection speed.  Please note that even though some of these people will have both a mobile connection and a dsl connection, this fact will not change the average national speed.
  6. Like
    Muppet reacted to mr moose in Australian Election 2013   
    I think your right, the people of Australia do tend to vote for the leader, and with the 24/7 news coverage and internet opinion being spread so easily it is getting harder and harder differentiate between who some is and who they are portrayed as. I have noticed over the last 20 years of following politics that to get to the actual truth of both policies and what Politian's are saying takes a lot longer. For every statement a Politian makes I have to read at least three news articles, check the relevant source then listen to the actual transcript of what was said before I know how far bent their words are or if I even agree. SO imagine how hard it is for someone who does not have the time, they will be basing their vote on what the media tells them or what their preferred party tells them. 
  7. Like
    Muppet reacted to Pvtjace in Australian Election 2013   
    Rudd wanted an NBN, he's a good direction in the IT sector of Australia.
    Rudd never wanted the Carbon tax, he was working on a trading scheme that wouldnt root big industries.
    Rudd is who I voted for, not some ranga who sways a party so Im glad our Kevin 07 is back, because frankly id rather move over seas then live under Abbot!
  8. Like
    Muppet got a reaction from ofr057 in Australian Election 2013   
    I'm glad to see Rudd back, I didn't like Gillard much. Also I definitely do not want Abbot as PM and we definitely do not want him representing us a t the G20 summit later this year. Abbot is wanting to take us backward in climate change policy and in our telecommunications infrastructure. Rudd was/is for climate change policy and the NBN. 
     
    Can Labor come back in the polls? If not how much will they be able to come back?, I think they might be able to come back to a close competition. Perhaps they are too unstable. But then again Rudd is rather popular among the younger generations. 

×