|
|
Post by pepperpot on Oct 28, 2014 17:20:54 GMT
Yeah, I was about to butt in to say, either minuses or colour coded, both is ott imho
(I prefer colour coded)
|
|
|
|
Post by Ton ⓉⓞⓃ on Oct 28, 2014 17:24:24 GMT
Very Bad: -3.24
2.45
-6.32
29.50Less Bad: -3.24
2.45
-6.32
29.50Good: -3.24 2.45 -6.32 29.50 Very much better: -3.24 (apart from the alignment, which clearly I'm rubbish at  2.45 -6.32 29.50 Better still: 3.24 2.45 6.32 29.50 (Edited to add final option after discussion with OG below). I think AC are trying all the possible variations to see which generates the most and which the least complaints, in other words we're having a vote and no one said!
|
|
|
|
Post by badger on Oct 28, 2014 17:24:30 GMT
I would be happy with both red and a minus, it's one of the standard format options in Excel and I can't think that anyone would genuinely think it meant a positive number.
|
|
|
|
Post by Jack Barlow on Oct 28, 2014 17:25:49 GMT
ramblin rose, what you are proposing is no good for colour blind or for those wanting to process the numbers in spreadsheets. I think you need to retain the minus for -ve numbers.
|
|
|
|
Post by Ton ⓉⓞⓃ on Oct 28, 2014 17:27:52 GMT
I would be happy with both red and a minus, it's one of the standard format options in Excel and I can't think that anyone would genuinely think it meant a positive number. How do I get excel to sum all the minuses ignoring the positive figures when I download the csv? That's something I can never do...
|
|
ramblin rose
Member of DD Central
“Some people grumble that roses have thorns; I am grateful that thorns have roses.” — Alphonse Karr
Posts: 1,370
Likes: 857
|
Post by ramblin rose on Oct 28, 2014 17:28:46 GMT
ramblin rose, what you are proposing is no good for colour blind or for those wanting to process the numbers in spreadsheets. I think you need to retain the minus for -ve numbers. My own preference would be keeping the minus, as originally stated - it's how I work with my own spreadsheets, of which there are many - just agree with others that it is technically incorrect. Edit: I have little experience with colour blindness - I have always thought it was red v green that is the problem there. Are you saying that red v black is also a problem? Edit2: if red v black is an issue for colour blindness, surely the current solid mid-green or previous red must be a much worse issue? I've looked into it a little now and understand a bit better, and I still think distiguishing colours for negative v positive numbers is a good thing. Colour blind people would not see the red as red, but would see it as something different to the black I would have thought?
|
|
|
|
Post by pepperpot on Oct 28, 2014 17:29:19 GMT
ramblin rose, what you are proposing is no good for colour blind or for those wanting to process the numbers in spreadsheets. I think you need to retain the minus for -ve numbers. Good point Jack, I'll have to live with 'very much better' then. And I'll butt out now.
|
|
oldgrumpy
Member of DD Central
Posts: 5,087 
Likes: 3,233
|
Post by oldgrumpy on Oct 28, 2014 17:29:42 GMT
ramblin rose, what you are proposing is no good for colour blind or for those wanting to process the numbers in spreadsheets. I think you need to retain the minus for -ve numbers. Ah! Never thought of that! Maybe the correct practise should be debits and credits in separate columns (as in my 1960s insurance office days).
|
|
|
|
Post by Jack Barlow on Oct 28, 2014 17:33:12 GMT
How do I get excel to sum all the minuses ignoring the positive figures when I download the csv? That's something I can never do... =SUMIF([summation range],"<0") See also the SUMIFS function (Excel 2007 onwards) for extra conditional flexibility.
|
|
|
|
Post by Jack Barlow on Oct 28, 2014 18:00:49 GMT
ramblin rose, what you are proposing is no good for colour blind or for those wanting to process the numbers in spreadsheets. I think you need to retain the minus for -ve numbers. My own preference would be keeping the minus, as originally stated - it's how I work with my own spreadsheets, of which there are many - just agree with others that it is technically incorrect. Edit: I have little experience with colour blindness - I have always thought it was red v green that is the problem there. Are you saying that red v black is also a problem? Edit2: if red v black is an issue for colour blindness, surely the current solid mid-green or previous red must be a much worse issue? I've looked into it a little now and understand a bit better, and I still think distiguishing colours for negative v positive numbers is a good thing. Colour blind people would not see the red as red, but would see it as something different to the black I would have thought? Hi ramblin rose, I wasn't arguing with your choice of colours, I was just making the point (possibly not very well) that we can't use colour alone to identify whether a number is positive or negative, mainly because we may not retain the colour scheme when working with the numbers. Referring to colour blindness was probably a bit of a red-herring, though I believe there are variations of colour blindness that make red look greyish (which may be difficult to distinguish from black).
|
|
ramblin rose
Member of DD Central
“Some people grumble that roses have thorns; I am grateful that thorns have roses.” — Alphonse Karr
Posts: 1,370
Likes: 857
|
Post by ramblin rose on Oct 28, 2014 18:11:30 GMT
My own preference would be keeping the minus, as originally stated - it's how I work with my own spreadsheets, of which there are many - just agree with others that it is technically incorrect. Edit: I have little experience with colour blindness - I have always thought it was red v green that is the problem there. Are you saying that red v black is also a problem? Edit2: if red v black is an issue for colour blindness, surely the current solid mid-green or previous red must be a much worse issue? I've looked into it a little now and understand a bit better, and I still think distiguishing colours for negative v positive numbers is a good thing. Colour blind people would not see the red as red, but would see it as something different to the black I would have thought? Hi ramblin rose, I wasn't arguing with your choice of colours, I was just making the point (possibly not very well) that we can't use colour alone to identify whether a number is positive or negative, mainly because we may not retain the colour scheme when working with the numbers. Referring to colour blindness was probably a bit of a red-herring, though I believe there are variations of colour blindness that make red look greyish (which may be difficult to distinguish from black). Hey no worries - it made me think for a change  Almost wishing I hadn't started it - just had a bit of a 'Victor Meldrew' moment when the red had all turned green, thought maybe someone had let their kid loose on the code as it is half term, and my innate sarcasm managed to make a bid for freedom before I could stop it! Feeling chastened now, but still not really understanding why the fairly standard red/black wasn't taken up in the first place. No doubt the green was provided with the best of intentions, and there's probably a good reason for it.
|
|
|
|
Post by Jack Barlow on Oct 28, 2014 18:56:51 GMT
... still not really understanding why the fairly standard red/black wasn't taken up in the first place. No doubt the green was provided with the best of intentions, and there's probably a good reason for it. So far we've been talking exclusively about the entries on the Statement page, where green seems to have received a unanimous thumbs down. However, I think there could still be a good case for some use of green (with black and red) on the "Your Loans" page. At the moment all variables on the "Your Loans" page that are lender-dependent (i.e. the last three columns “Your Target”, “Your Holding” and “Interest Accrued”) are coloured green unless the value is zero in which case they're coloured black. I quite like having zero assigned a different colour in the "Your Holdings" column as this allows easy (except perhaps for the colour blind) identification of those loans which have been sold (holding=0) but on which unpaid interest has accrued. I think I'd like to see the visual information on this page enhanced further by highlighting differences between "Your Target" and "Your Holding" e.g. by adopting the following colour scheme: “Interest Accrued” column: zero set to red, positive set to black “Your Holding” column: zero set to red, positive set to black [i.e. as I've proposed for the "Accrued Interest" column] “Your Target” column: ="Your Holding" set to black, <"Your Holding" set to red, >"Your Holding" set to green. I'd be interested in other lenders' (and AC's) views on this.
|
|
kermie
Member of DD Central
Posts: 691
Likes: 462
|
Post by kermie on Oct 28, 2014 19:44:56 GMT
Stop logging me out, AC!!! 20 minutes is nowhere near long enough. I only have get distracted onto these forums or elsewhere on line and that time has gone, then its full emailmail, full password and full security question again and again.  Firefox - reload every 15 mins sorts it for me. Although I usually forget the first time I log in and only engage it on the second attempt.  I feel for you as your "emailmail" must take nearly twice as long as the rest of us to type  I've just installed Refresh Monkey for Chrome. Nice and simple.
|
|
|
|
Post by chris on Oct 28, 2014 21:26:38 GMT
chris any progress on making the auto log out user maintainable? I've been out the office most of the day today but will pick this up again tomorrow.
|
|
|
|
Post by bracknellboy on Oct 28, 2014 21:33:37 GMT
Stop logging me out, AC!!! 20 minutes is nowhere near long enough. I only have get distracted onto these forums or elsewhere on line and that time has gone, then its full emailmail, full password and full security question again and again. Simples: change your emailmail to a simple email, maybe OG@gmail.com, your password to OG, and the answer to all of your security questions to B [for Banana in case you're asking]. Fewer key strokes.
|
|
