maths help please

[Lady E]

no sniggering at my thickness please...

im doing some of our book-keeping - bleep.com sales between october and now - and having inputted a large amount of data i realise that each individual entry needs to be reduced by 35% (that's their cut)

i need a formula that i can use to find 35% of a total.

for example, when wanting to find the VAT included in a total amount, you use the following:

amount x [7/47]

then minus the result from the total.

or if anyone knows of an easier way that i can do this i would be very grateful got to go back and re-enter them all...

[FiST]

i'm sure you can do stuff like this in excel, but i'm not very good with excel or word but someone here is bound to know how to set it up.

cheers for editing that thread btw :)

[Hagbard]

Emma, Multiply the figure by 0.35 to calcute their cut, or by 0.65 to get your cut.

So to find out VAT, you can do it simply by multiplying by 0.175.. although thats not business rate VAT..

[Lady E]

steev that is really simple thanks!

DURRR im so thick

to find out the VAT on an item that is ex-VAT then obviously yes, x 0.175

i was getting confused because if you need to know the VAT included already in a total ie £1.50 then you need to use my formula which gives you the VAT included, so then gives you the price of the item + the further 17.5% of that price.

which would mean VAT= 0. 22p
price of item: 1.28 p
total: 1.50 p

so that kind of formula is really irrelevant to what im doing because i just need a simple percentage.

DUMB BITCH!

[Hagbard]

Hehe. Maths is just practice innit. My girlfriend has been fretting about the maths tests she has to do for teaching training, I think she got a B at GCSE so I don't think she should worry.

[Lighter Thief]

Maths is despicable and evil. Let's hear no more talk on the subject.

[joe pinapples]

maths is like magic without the fun

[Lady E]

Originally posted by Steev
Hehe. Maths is just practice innit. My girlfriend has been fretting about the maths tests she has to do for teaching training, I think she got a B at GCSE so I don't think she should worry.

im not bloody surprised - ive seen all about those tests. they are hideous. they are aural - i have already started doing the practice ones with my mum who is ace at maths and im fretting hard about it too. and i only got a C at GCSE, hard won it was too.

i have to do a lot of numbers in my job though and no matter what i do it just will not come naturally. like how stupid is that not to know how to find a percentage. the fact is i did know but i wasnt confident enough to believe it was that.

sigh. i feel like giving up today. :(

[Hagbard]

Well if you think you know but aren't sure then just do some little tests to confirm, I use Excel to do that all the time... you know that 35% of 100 will be 35.. so test your best guesses first.

Still I think Maths does come fairly naturally to me so it would be a bit like a painter saying to me 'just do some little tests to find out the complementary colour..'.

I do love maths. Didn't realise the tests were Aural.. thats odd, I'm gonna be her maths coach ;)

[Lighter Thief]

Steev - are you that dude who was on Channel 5 last night who can recite pye to 100500 decimal places?

[Lady E]

hmm. yes, i do know all that and often do it but i just panic sometimes and my mind goes blank. i blame the onset of calculators which took all my mental arithmatic skills away from me.

i was in the top set for maths at school for ages and had to beg and plead my parents and teachers to be allowed to go down to set 2...i think i have been seriously traumatised somewhere along the line!

[phil]

ur thick

[Hagbard]

Heheh... I was in the bottom set for GCSE maths and got an A ;)

That may have been due to my behaviour tho....

I was traumatised by English grammar for years, I still don't know where to put a semicolon or an apostrophe...

[phil]

I did A level maths and got an A. Im the fucking Don mate. i see everything as numbers.

[Lady E]

Originally posted by Steev
Heheh... I was in the bottom set for GCSE maths and got an A ;)

That may have been due to my behaviour tho....

I was traumatised by English grammar for years, I still don't know where to put a semicolon or an apostrophe...

i'm not so hot on that either. this teaching lark is starting to look a bit shady...

[Hagbard]

Originally posted by Lighter Thief
Steev - are you that dude who was on Channel 5 last night who can recite pye to 100500 decimal places?

hehe.. did he actually do that with maths in his head? I thought it was one of those silly memorisation tasks.

anyway no.. that wasn't me.. I love Maths but GCSE was my pinnacle.. I fell over on the Maths on my degree...

[Lighter Thief]

Then it was YOU who was on Channel 5 last night, Phil. Seriously man, the guy was nuts. He learnt how to speak Icelandic in a week.

[Spandex]

I did A level maths and got a fucking B... nice n all.. but I was one of those people maths just came easy to... strolled through it all with straight A's without even working.. then I get to the only important exam I'll ever take in the subject and get a fucking B. That'll learn me not to be a cocky bastad.

Actually.. no it didn't :)

[Lighter Thief]

Originally posted by Steev


hehe.. did he actually do that with maths in his head? I thought it was one of those silly memorisation tasks.

Well, they ran all sorts of tests to see if it was memory techniques he was using to do calculations. Obviously you've got to be fairly sceptical of anything you see on TV - especially channel 5 - but it looked as if he really did actually have some kind of mad mathematical ability. It was pretty interesting. Like Phil he reckoned he sees everything as numbers.

[Patrick]

Originally posted by emma

i was in the top set for maths at school for ages and had to beg and plead my parents and teachers to be allowed to go down to set 2...i think i have been seriously traumatised somewhere along the line!

Sounds quite similiar to my own experience, except I don't think I was seriously traumatised, I know it. I used to be really good until I ended up in the class of a sadistic, short-arse, bully priest who used to make me, and others, stand in a corner holding my arms out with a pile of books in each hand. He'd give us an occassional whack accross the arse or back with a hurley stick if we lowered our arms too much. So pretty soon I was pleading to drop down a grade after I realised that the equation was going something like this : Stand in corner = miss lesson = learn fuck all = fail test = get more beating. Repeat. Aaah, the joys of being educated by priests in an Irish school.

[Spandex]

There's a difference though... that Channel5 chap saw constantly shifting numbers, the awe-inspiring patterns of creation... Phil just sees number twos everywhere.

[Lighter Thief]

Originally posted by Patrick


Sounds quite similiar to my own experience, except I don't think I was seriously traumatised, I know it. I used to be really good until I ended up in the class of a sadistic, short-arse, bully priest who used to make me, and others, stand in a corner holding my arms out with a pile of books in each hand. He'd give us an occassional whack accross the arse or back with a hurley stick if we lowered our arms too much. So pretty soon I was pleading to drop down a grade after I realised that the equation was going something like this : Stand in corner = miss lesson = learn fuck all = fail test = get more beating. Repeat. Aaah, the joys of being educated by priests in an Irish school.

Christ. That sounds ugly. Was it back when all this were nowt but fields?

[penciLneck]

thats so fucking out of order. bastards.

[Hagbard]

Originally posted by Spandex
There's a difference though... that Channel5 chap saw constantly shifting numbers, the awe-inspiring patterns of creation... Phil just sees number twos everywhere.

heheheheheh.. oh that's tickled me..

anyway the real dude is that savant guy I posted about a while ago who visualises maths in his head as moving planes of colour or something.. he was amazing..

[Patrick]

Originally posted by Lighter Thief


Christ. That sounds ugly. Was it back when all this were nowt but fields?

Yeah, it was in the 80s in fairness. I probably had a mullet so it might have been deserved.

Scarey thing is he wasn't even the worst priest at our school. The monster who was de-frocked by pope JP II shortly before his death after he had been found guilty of sexually abusing some of the boys there was probably a bit worse. Got sentenced to four years, had to serve.......*drumroll*........ fucking none of them on the grounds of ill health. Well done catholic church. Look after your own.

Sorry, Emma, taking your thread off on a dark tangent.

[phil]

Im 28. thats a perfect number. du sum of all its factors apart from itselff

[kams]

Originally posted by Steev


heheheheheh.. oh that's tickled me..

anyway the real dude is that savant guy I posted about a while ago who visualises maths in his head as moving planes of colour or something.. he was amazing..
Thats similar to the bloke who can smell and taste words...

[Patrick]

edit

[Patrick]

Synaesthesia, isn't it ?

[Hagbard]

Yeah the cross sense thing is Synaesthesia but that is like some crazy feedback loop in a fairly normal brain as far as I know.. the Savant guy just seemed to have a properly mutant brain.

[Spandex]

I've got those synthaesthesia documentaries they did on R4 a while back if anyone's interested..

oh... they're still on Listen Again anyway
http://www.bbc.co.uk/radio4/science/hearingcolours.shtml

[Lady E]

Originally posted by Patrick


Yeah, it was in the 80s in fairness. I probably had a mullet so it might have been deserved.

Scarey thing is he wasn't even the worst priest at our school. The monster who was de-frocked by pope JP II shortly before his death after he had been found guilty of sexually abusing some of the boys there was probably a bit worse. Got sentenced to four years, had to serve.......*drumroll*........ fucking none of them on the grounds of ill health. Well done catholic church. Look after your own.

Sorry, Emma, taking your thread off on a dark tangent.

oh no, be my guest - experienced a similar thing at my convent school. our priest was found to be head of a child porn ring and it was all over the tabloids...this bloke, Father Towner, was shipped off to a monastery in the outer hebrides after his trial, apparently.

[Hagbard]

The maths teacher who helped me get an A was sacked for taking pictures of kids in the showers, the headmaster used to go on 'Organ tours' round Europe molesting kids, he committed suicide.. one of my biology teachers killed his wife with a shovel... my Religious studies teacher wrote a book about how child abuse has 'no long term affects'... ah teachers eh...

fucking hell.. I'm gonna be living with one soon!

[Lighter Thief]

Originally posted by emma


oh no, be my guest - experienced a similar thing at my convent school. our priest was found to be head of a child porn ring and it was all over the tabloids...this bloke, Father Towner, was shipped off to a monastery in the outer hebrides after his trial, apparently.

To be fair, that actually sounds worse than prison.

[grobelaar]

maths is just bizarre. I used to be really good, got an A at GCSE and then it all fucked off to the pub - and I don't mean that literally.