Brummieboy

Hi there. I have an issue with a spreadsheet I print off daily at my sales based job. I have a formulated spreadsheet that I track everyone figures and at the end of it an area I print out which shows each member of staffs performance. I reset this weekly and when I do this all the formulas come back saying DIV/0!

is the anyway I can make this cells say N/A or something of that nature every time it resets..without typing it in and then re doing the formula when they start selling

cheers

hey, i'm doing a spreadsheet on numbers and i need help with some colour formatting.

basically I am making a table of everyones performance in my store at work and ranking them 1-8. Now i have sorted all the formulas and got it to the point where I have a final rank of 1-8.

what i want to do now is have it so the Number 1 ranked person's cell comes up in green. the number 8 person comes up in red and then the number in between gradually move from green to red.

i used to do this in excel so assumed the is a way to do this on numbers. obviously i want a formula for this rather than actually haven't to click on each individual person and change the colour

cheers

hi there, basically I have been doing some video editing for a friend. but he sends me the files in the MOV format, there a nightmare to edit, I have trid converting them to AVI but 99% of the converters only convert the audio.

I finally found 1 that converts the video and audio but my problem is that it will only convert files that are 100mb or smaller.

so basically I am looking for some software that will simply split my file in half (most are around 160mb) so i can split them in half, then convert the split files and then finally beging editing.

cheers for any advice. much needed and appreciated.

Hello I need a website where I can upload a video file to it. Send a link and password to a friend so he can then download the video file

Hi there, i played football (soccer) on Sunday, and after jumping for a header I landed awkwardly and sprained my ankle. The ref at the time told me he heard a pop but i really Don't remember the incident. I was carried to the changing rooms and the moment I got there my ankle had like a golfball sized lump on the outside. I immediately did a day's worth of R.I.C.E on it and the swelling went down a considerable amount and the was a little bruising. I then bandaged it and worked on it from 4 on monday until 10. When I got home the was alot of bruising, my foot was practically purple all down my left side of my foot and also at the bottom of my calf on the outside of my leg. Also the was a little bruising on the top and bottom of my foot.

I believe the colour has come out alot because I was working on it, so the was alot of blood flowing through my leg. The swelling has gone down a fair bit and now the is just a tiny amount. I am continuing to ice it and now have two days off work. I also jogged a little on the way back to my car and could do it without any discomfort really. My foot hurt when I first got to work but after 20 minutes or so of walking around it was fine.

I have three questions.

1) i have my cup final on Sunday Afternoon, do you think I will be able to play??? I know I won't be 100% fit but I think with pain killers and some deep heat I should be able to get through. Hopefully I can get through 1 match and then rest it for a few weeks.

2) since I have two days off and nothing to do. What do you recommended are the best actions to take to improve my chances of playing on Sunday.

3) can anyone recommend some strong pain killers that can get me through the game without knocking me out. My dad gave me some pain killers when I did it but i would never be able to play on them, they made me dizzy. Anybody know an pain killers that won't effect my concentration too much

Hey tonight playing football (soccer for americans) I went to block a shot and the guy kicked it so hard it bent my foot back and was quite painful. When I got home after the moment I took my shin pads off (with ankle protectors) my ankle immediatly ballooned and swelled up. The swelling is just on the ankle not on any of the rest of my foot and it's all down the outside not inside (it's my right foot). I can walk on it and although the is some discomfort it is not overly painful! When i rest it sat down I can feel it, it feels quite numb around my foot, like a numb pain but no really agonising or seriours pain.

My question is how long before The swelling goes down and I can get back to playing football. I have a cup final on the 17th May (so 19 days time) do you reckon my foot will be ok for that final?

Cheers for any reply

Hello, i have has a few drinks tonight! Im not smashed drunk but am a bit drunk! Whatnis the best way to avoid me waking up with a hangover! Im home now and about to go to bed but dont want a hangiver jn the mornung

Hi there, i have recently been going to the gym alot with my friend who has been working out for a good few years now. He has taught me how to do correct form, about keeping up my food intake etc. but one thing I am unsure of is how I am doing as regards to my size as he is a good 5/6 inches taller than me and i physically bigger guy (although that has comes from his gym time and i'm starting to catch him up).

So yeah i am 5ft 4 and I weigh 10 stone 6. Which i believe is 66kg.

Today at the gym I benched 65kg for 3 reps. I also deadlifted 110kg for 3 reps. Is that good for someone of my size.

I have been going to the gym for a good 5/6 months now (atleast 3 sometimes 4 times a week) and we have 5 set workouts which we rotate (2 arms, 1 chest, 1 shoulders and 1 back) but we always make sure we do the same Chest workout once a week.

So for example 1 week we may do Main Chest workout, then 1 arm, 1 shoulder and another chest.. Then next week we do Maun chest again followe by the other arm, then the back then possibly arms again. This is to keep the body guessing we are constantly mixing it up but making sure we are focusing on chest at least once a week and swapping it about to keep our body's guessing.

Our main chest workout involves doing 50kg on decline, incline and flat to fail. Then 3 reps on 65kg. Followed by 20 k flys on both incline and flat. Then Deadlifts and abs after that.

Hopefully will be going up to 55k soon for the first three lot of reps.

Sorry for the essay but yeah two questions really

1. Is 65k bench and 110k deadlift good for a 66k, 5ft 4 guy.

2. Does that chest workout sound effective to you? Certainly working for me

Hi there, i have been working out seriously for a good 3/4 months now. I'm happy that i'm starting to see some signs of muscle building, at the moment I have 1 protein shake after every workout and work our atleast 4 times a week. I get decent amount of protein in my meals i believe and i also don't drink and avoid all junk food (mcdonalds, KFC, any fast food really).

The question I have is that i'm considering buying a bulk amount of protein and having protein as my drink all the time(like not drinking anything else) so having it with meals and when i'm thirsty.

Is this recommended or not and can you please explain why. I am extremely active guy so trust me i will use up all the energy I gain from this and am looking for mass muscle building (i do very heavy weights for small reps when I go to the gym)

Cheers for any reply

Hey there, i'm going on a big night out that has been planned for months tomorrow night (our friend is returning for a week after moving to Dubai last year). I'm at work from 10-2 in the morning then going straight from work to the pub and the drinking starts (my mates are starting at 1 ill join a bit late).

Now the issue I have is that I messed up my sleeping pattern pretty bad due to the fact I had my baby nephew for the whole of last week keeping me up.

It is currently 3 in the morning and I know I won't get to sleep for at least an hour or two as i'm not tired at all, but I need to be up for work at 9. Then i want to go straight to town after work as some of my friends are only coming out for a few hours and i don't want to end up miles behind all my friends.

So my question is what alcoholic drinks do people recommended to get me through the day (bare in mind we will be drinking until around 2/3 in the morning).

Are the any drinks I should avoid that will make me sleepy..

And is the anything else i can do to keep me awake/make me fall asleep quicker now

I have VirginMedia Internet. I used to have just a modem with a Belkin Router and I could play PS3 games fine. I just upgraded the Internet to a faster speed which included getting a free VirginMedia HUB. So I sold the belkin router as I had no need for it. Now I can still get online and connect.. I just have a problem that when I play FIFA. Every 4/5 games i play online it will throw me out and say I've been disconnected from the EA Servers. I can rejoin straight away and it doesn't log me out onplaystaion network.. Just the EA servers. This is getting really annoying so any help would be appreciated cheers

Hi there, I currently have 2 tattoos. A Lion with a tribal design around it (Lion because i'm a Leo and Tribal design because I love the tribal ones and want to extend it) this is on my Right Arm Shoulder. On my Lower right arm I have a Dagger tattoo which my father also had a similar dagger tattoo. Family means alot to me and I have always said that i want to turn my right arm and right side of my body into a big tribal peace for personal enjoyment.

On my left arm I decided a while ago that this would be for family, this would be where I got my kids names etc etc. for a while now I have been thinking about getting something for my immediate family and had the idea of getting 4 chinese symbols on my forearm. The chinese for Father, Mother Brother and Sister.

I'm aksing if anyone could send me the symbols for these 4 things please. Any font is fine but if you could ut them together and make them big enough to be tattoo onto a forearm that would be great but if not just showing me the signs would be fantastic.

Cheers

Hi there, I currently have 2 tattoos. A Lion with a tribal design around it (Lion because i'm a Leo and Tribal design because I love the tribal ones and want to extend it) this is on my Right Arm Shoulder. On my Lower right arm I have a Dagger tattoo which my father also had a similar dagger tattoo. Family means alot to me and I have always said that i want to turn my right arm and right side of my body into a big tribal peace for personal enjoyment.

On my left arm I decided a while ago that this would be for family, this would be where I got my kids names etc etc. for a while now I have been thinking about getting something for my immediate family and had the idea of getting 4 chinese symbols on my forearm. The chinese for Father, Mother Brother and Sister.

I'm aksing if anyone could send me the symbols for these 4 things please. Any font is fine but if you could ut them together and make them big enough to be tattoo onto a forearm that would be great but if not just showing me the signs would be fantastic.

Cheers

Just had my dinner then got a phone call to see if I could play six a side footy in an hour. What is the best way to get rid of this full stomach quickly and to avoid feeling bloated in the game

hey there, ok basically I have an iphone and ipad that are both synced to the same itunes on my mac. I have now set it up so both of this can sync wireless with my mac when they are plugged into a power supply. They always auto sync which I don't mind but what is annoying me is that they sync everything. 1st of all I don't want my movies on my iphone just my ipad, how can I set it so it only sync's to the ipad.

I want the same music on both but the main thing that annoys me is that it sync's each others apps. So my iPad get lots of iphone apps all the time and I don't want them on there.

this is really annoying me

so Basically can you tell me how to

a) make it so just my iPad has the movies

b) make it so my iphone apps don't get automatically synced accross to my iPad

top points for answers

hi there, I don't really have a question but I would appreciate if you guys could answer some survery questions for a project i'm doing

that would be great cheers

1. Are you Male or Female

2. How Old are you a) 0-25 b) 25-50 c) 50+

3. Do you believe Violence in Media Entertainment (Films, TV and Video Games Specifically) influences people who commit violent acts in the real world?

4. Do you believe young people, (up to and including 25) are more likely to be influenced by violence in the media than people above the age of 25?

5. Should more be done to limit the access young people have to violent content?

6. Do you believe that a) Violence in the media is ok b) Violence should be allowed but limited in it's realism and intensity levels or c) No violence should be portrayed at all through media outlets.

7. Should the age limit for certain films, TV and video games by raised to a minimum of 21 years of age?

8. If a Documentary was made about Violence in media and it's effects on social violence, would you be likely to watch it?

hey I have an iphone 4 and I hate it, so I was wondering if I sell it and keep the sim card and then buy a cheap 3g phone on the same network. can I just pop the sim card into the new phone and use that? anybody that can answer would be great

hey I have ordered the degale vs groves fight on one tv, I have virgin media.

Can i go and watch it on another tv in the same house that also is virgin media all set up together on the same account? because when I try to watch it it doesn't load

any advice will get top marks