I need a really simple spreadsheet....

robfosters · 4 Nov 2013 at 21:58

but my Excel skills suck

Basically, it's to track daily betting.

I need four currency columns. Stakes, Return, Daily P/L and Running P/L. The stakes column needs to be negative value so I don't have to type a minus sign in every time.

I imagine it's pretty self explanatory what I'm looking for. So grateful if anyone can help.

Thanks.

gillywibble · 4 Nov 2013 at 22:09

The stakes can be positive, you just need to use a formula to calculate the other cells.

I'll do it in the morning if someone else doesn't get to it first.

The__Malteser · 4 Nov 2013 at 22:11

What formulas do you want for Return, Daily and Running?

At the moment I have this (random values inputted)

Not sure if I can do stakes negative and currency at the same time.

PMKeates · 4 Nov 2013 at 22:11

Are you kidding me? Why not do it yourself? Are you stupid or extremely lazy?

robfosters
-----
Occupation
Unemployed at present

robfosters · 4 Nov 2013 at 22:29

PMKeates said:
Are you kidding me? Why not do it yourself? Are you stupid or extremely lazy?

robfosters
-----
Occupation
Unemployed at present

There's no need for that. That's just spiteful. I'm unemployed due to serious disability (stroke, heart disease). I actually used to be in the diplomatic service. But lets not let that get in the way of an insult eh.

I have tried, but I just do not understand excel. Word, I'm fine with. But Excel. I just fail completely.

robfosters · 4 Nov 2013 at 22:35

The__Malteser said:
What formulas do you want for Return, Daily and Running?

At the moment I have this (random values inputted)

Not sure if I can do stakes negative and currency at the same time.

This looks exactly what I want. If the stakes were negative and we entered a new line on 3, I assume C3 would be (A3+B3) and D would be D2 plus C3.

Judgeneo · 4 Nov 2013 at 22:37

robfosters said:
There's no need for that. I'm unemployed due to serious disability (stroke, heart disease). I actually used to be in the diplomatic service. But lets not let that get in the way of an insult eh.

I have tried, but I just do not understand excel. Word, I'm fine with. But Excel. I just fail completely.

If your currently unemployed then you have plenty of time to learn. The functionality you are after is among the most basic that excel offers, getting to grips with it will allow you to plan your finances much more efficiently

robfosters · 4 Nov 2013 at 22:41

Judgeneo said:
If your currently unemployed then you have plenty of time to learn. The functionality you are after is among the most basic that excel offers, getting to grips with it will allow you to plan your finances much more efficiently

I don't believe this thread. I ask for a simple bit of help. the likes of I would be more than glad to provide others, and all I get is lifestyle advice and a character assassination.

youdsy · 4 Nov 2013 at 22:44

robfosters said:
I don't believe this thread. I ask for a simple bit of help. the likes of I would be more than glad to provide others, and all I get is lifestyle advice and a character assassination.

welcome to OCUK forums

bJN · 4 Nov 2013 at 22:45

robfosters said:
I don't believe this thread. I ask for a simple bit of help. the likes of I would be more than glad to provide others, and all I get is lifestyle advice and a character assassination.

Welcome to OCUK, you must be new here?

Doomedspeed · 4 Nov 2013 at 22:48

robfosters said:
I don't believe this thread. I ask for a simple bit of help. the likes of I would be more than glad to provide others, and all I get is lifestyle advice and a character assassination.

I feel for you,

It seemed to turn sour very quickly, for no reason..

My excel skills suck too.. (so i can't help you, sorry).

Raumarik · 4 Nov 2013 at 23:06

This is a big over the top guys, simple request asked quite politely and The__Malteser has at least attempted to do so.

I don't quite get why anyone is getting on the OP's back about this, poor show - this isn't GD!

edit: just realised this was originally posted in GD, crickey!

robfosters · 5 Nov 2013 at 00:38

gillywibble said:
The stakes can be positive, you just need to use a formula to calculate the other cells.

I'll do it in the morning if someone else doesn't get to it first.

Thanks for your offer Gilly, but I did manage to do it myself in the end. I never realised that when you copy and paste formulas, it automatically adjusts the cells it calculates. That makes it really easy.

However, I still haven't found a way of entering negative numbers automatically.

Lartyconshayo · 5 Nov 2013 at 06:25

make a column with the formula =0-$D. Replace $D with the correct column name. Copy the formula to the end of the column. Put positive values in column D and whatever column has the formula should automatically output negative values. Use that column for your calculations.

paradigm · 5 Nov 2013 at 07:09

The__Malteser said:
Not sure if I can do stakes negative and currency at the same time.

Course you can, that's exactly what the custom formatting is for!

djferrick said:
make a column with the formula =0-$D. Replace $D with the correct column name. Copy the formula to the end of the column. Put positive values in column D and whatever column has the formula should automatically output negative values. Use that column for your calculations.

Why bother, just use the custom formatting for cells and use:

-£#,##0.00

The__Malteser · 5 Nov 2013 at 07:16

I went to sleep thats why I didn't continue.

I had tried custom formatting, but they weren't coming as I want to.

Glad you did it yourself though.

robfosters · 5 Nov 2013 at 10:18

paradigm said:
Course you can, that's exactly what the custom formatting is for!

Why bother, just use the custom formatting for cells and use:

-£#,##0.00

Thanks Paradigm,

Why that does indeed turn everything into a negative, for some bizarre reason, the auto sum still treats it as a positive, so even though I have -£20 in the stakes column and £20 in the returns column, it still sums it at £40 rather than £0.

I've tried ways that I've found online, yet none of them work. I thought this would have been very easy to accomplish.

gillywibble · 5 Nov 2013 at 10:33

Leave the stake as positive. Then under cell D2, enter the following formula -

=SUM(-A2+B2)

I think you need an additional column to show daily (as opposed to overall) stakes. You will then be able to enter a formula for Daily P/L.

Gilly · 5 Nov 2013 at 10:48

Are you kidding me? Unwarranted personal attacks?

PMKeates
-----
Account
Suspended at present

robfosters · 5 Nov 2013 at 11:05

gillywibble said:
Leave the stake as positive. Then under cell D2, enter the following formula -

=SUM(-A2+B2)

I think you need an additional column to show daily (as opposed to overall) stakes. You will then be able to enter a formula for Daily P/L.

I thought this after. I mean, a stake still is a positive number. It's not negative. So I left it as a currency cell and altered the formula slightly. In the end I have ended up with something like this. Bit loud I know, but I find it easy enough to read and manipulate.