Study Buddy

1…198199201203204…424

Comments

  • System
    System Posts: 100,537 πŸ€– Admin πŸ€–
    Re:Study Buddy

    Very true, I have applied.
  • System
    System Posts: 100,537 πŸ€– Admin πŸ€–
    Re:Study Buddy

    Great stuff
  • System
    System Posts: 100,537 πŸ€– Admin πŸ€–
    Re:Study Buddy

    :arrow: double post!
  • System
    System Posts: 100,537 πŸ€– Admin πŸ€–
    Re:Study Buddy

    Easy, boy. He tell us in his own sweet time, he doesn't want us going for it :lol:
  • System
    System Posts: 100,537 πŸ€– Admin πŸ€–
    Re:Study Buddy
    19051984 wrote:
    And Peugeout, are you from Manchester?


    He goes clubbing in Manchester
  • System
    System Posts: 100,537 πŸ€– Admin πŸ€–
    Re:Study Buddy
    19051984 wrote:
    when did you apply, this morning, yesterday, last week? Agency or direct to the firm... tell us more - WE NEED MORE DAMN IT

    I applied this morning, but its gonna be real awkward seen as where I want to work is 45 mile from where i live! Dont know how ill make the interview. Thinking of telling the gaffer that Im relocating, so I need to take time unpaid, and I will work out of hours if need be.
  • System
    System Posts: 100,537 πŸ€– Admin πŸ€–
    Re:Study Buddy

    Be careful, you don't want catching out on a fib. What if you don't get it? Why not just take some leave?
  • System
    System Posts: 100,537 πŸ€– Admin πŸ€–
    Re:Study Buddy

    Ive only got three days left, so I can do that for a short while
  • System
    System Posts: 100,537 πŸ€– Admin πŸ€–
    Re:Study Buddy

    bet your loving the fact knowing you are leaving and moving jobs dont you
  • System
    System Posts: 100,537 πŸ€– Admin πŸ€–
    Re:Study Buddy

    Well no, Im moving to Derbyshire end of the summer so thats why Im applying.
  • System
    System Posts: 100,537 πŸ€– Admin πŸ€–
    Re:Study Buddy

    I don't know how many miles my work is away from my house but it takes 2 hours to get here :shock:
  • System
    System Posts: 100,537 πŸ€– Admin πŸ€–
    Re:Study Buddy

    Gem go on aa route planner and type the post codes in, that will tell you the distance.
  • System
    System Posts: 100,537 πŸ€– Admin πŸ€–
    Re:Study Buddy


    I used to travel 5 hours a day...

    :cry:

    Now it's a five minute walk!
  • System
    System Posts: 100,537 πŸ€– Admin πŸ€–
    Re:Study Buddy

    that makes sense...... were you not a good driver?
  • System
    System Posts: 100,537 πŸ€– Admin πŸ€–
    Re:Study Buddy

    One for Jamie or any other Excel kings out there.

    I want to update my Excel CIS control register and would like it to auto-calculate my payment to the subbie for me. I could do this manually but am rather too lazy...

    I have a box that says VAT registered with yes or no as the selectable options. I then have another box after it that will look at the the previous yes or no box and then work out the VAT element on the total net amount charged by the subbie should he be registered.

    So the formula is essentially; if cell A (or whatever cell) equals 'yes', then rounddown the total net amount x 17.5%, otherwise leave zero. So it's a mix of IF and rounddown formulae.

    Clear? I'm sure it's not too difficult a one but I'm having a bad day today so far...!

    Robert
  • System
    System Posts: 100,537 πŸ€– Admin πŸ€–
    Re:Study Buddy

    did that work rob?
  • System
    System Posts: 100,537 πŸ€– Admin πŸ€–
    Re:Study Buddy
    19051984 wrote:
    After last night, I have proof that women can drive me crazy

    :oops:
  • System
    System Posts: 100,537 πŸ€– Admin πŸ€–
    Re:Study Buddy

    It's only 45 miles :shock:
  • System
    System Posts: 100,537 πŸ€– Admin πŸ€–
    Re:Study Buddy
    19051984 wrote:
    And Peugeout, are you from Manchester?

    I live in Bolton but work in Sale which is down the road from where you work. I know the McDonalds you mentioned the other day as I used to go there when I was studying.

  • System
    System Posts: 100,537 πŸ€– Admin πŸ€–
    Re:Study Buddy

    Is that 'cos you walk slowly, dragging your bag behind you. It's only 20 mins down the road but you hate going :lol:
  • System
    System Posts: 100,537 πŸ€– Admin πŸ€–
    Re:Study Buddy
    peugeot wrote:
    I live in Bolton but work in Sale which is down the road from where you work.
    Ahh. That explains it...
  • System
    System Posts: 100,537 πŸ€– Admin πŸ€–
    Re:Study Buddy
    blobbyh wrote:
    So the formula is essentially; if cell A (or whatever cell) equals 'yes', then rounddown the total net amount x 17.5%, otherwise leave zero. So it's a mix of IF and rounddown formulae.

    Clear? I'm sure it's not too difficult a one but I'm having a bad day today so far...!

    Try this - you're almost threre by the way.. where I use Buff you change to the cell location where you have yes/no

    Go to the cell you want the VAT amount to go into and type:

    =if(Buff="Yes", (NetAmntCell*0.175),"")

    So, if cell says YES then multiply the amount in the NET TOTAL cell by 0.175, otherwise put the amount of zero.

    Qhy would you want to round down the net amount when calculating VAT on it, why not just leave it as it stands (sorry, not much of an AAT Student now so not up to scratch on workings)

    J

    Robert
  • System
    System Posts: 100,537 πŸ€– Admin πŸ€–
    Re:Study Buddy

    Ooh everyone POTC3 is really good :D not as good as the first 2 but its good :D

    And Will Turner is sexier than Capt Jack Sparrow in this one :shock: theres a bit at the end where I could have scratched elizabeth swans eyes out :evil:
  • System
    System Posts: 100,537 πŸ€– Admin πŸ€–
    Re:Study Buddy

    cool, glad it's right rob
  • System
    System Posts: 100,537 πŸ€– Admin πŸ€–
    Re:Study Buddy


    Sale is well known for its George Clooney lookalikes.

    There was something in the paper the other day about it.

  • System
    System Posts: 100,537 πŸ€– Admin πŸ€–
    Re:Study Buddy
    Gem7321 wrote:
    And Will Turner is sexier than Capt Jack Sparrow in this one

    Thats not possible!
  • System
    System Posts: 100,537 πŸ€– Admin πŸ€–
    Re:Study Buddy

    Oh believe me - it is!

    I was shocked. The first moment I saw Will I went all tingly :shock: but I didn't when I saw Jack. I feel like I've cheated on him!
  • System
    System Posts: 100,537 πŸ€– Admin πŸ€–
    Re:Study Buddy

    Thanks Jamie - works a treat now! I wanted to round down the VAT element only but since it's only ever gonna be one pence out at most, I'll manually adjust it when and if it happens!

    Robert
  • System
    System Posts: 100,537 πŸ€– Admin πŸ€–
    Re:Study Buddy

    Still cant believe its only me that thinks Orlando Bloom is an ugly wart :shock:
  • System
    System Posts: 100,537 πŸ€– Admin πŸ€–
    Re:Study Buddy

    I think it's the rugged look that does it for me. In this one he looks more rough, with sideburns and a beard etc and he had his chest out for nearly all of it *swoon*

Categories

Privacy Policy