Being nosey... How many Regular Saver accounts do you have?

Bobblehat

Ch1ll1Phlakes said:

Also don't want to step on anyone's toes but here's an example.



Not perfect saying I downloaded the most up to date pic but works ok. Hope this helps.

Yes ... it does help. Saved me from trying what you just did ... so big thanks.

How do people like this solution? Better than "Divisions"?

janusd

Bobblehat said:

I should explain what the problem is I'm trying to solve (or head off).

As the table has grown, so has the size of the image file I insert into the post. A couple of weeks back I hit a forum "limit" when I tried to insert an updated image and I had to "resize" the image to lower the file size (~200KB) before the insert process accepted the image. Resizing the image lowered the readability of the text in the table as it reduced the apparent size of the font, and its "clarity". I'm not sure what property of the image is causing the rejection of the insert, is it the file size, file type, aspect ratio of the image, or something else?

A week or so ago, the table having grown again, I had to repeat the process and the text got slightly "fuzzier" again as I tried to keep the image file under the limit. I realised that this solution was not going to be repeatable for too many iterations. 

So one solution I thought of was the splitting of the image into several smaller images, such that each one was well within the forum insert limit .... this lead on to the "Divisions" idea.

I'm not dead set on that route if a better solution to the problem can be found, and there may well be forumites who have solved a similar problem here (or elsewhere), or can think outside the box and suggest an alternative solution. As I said a few posts back, the "Division" solution was just my initial thoughts and has a possible advantage of breaking up a long, thin image (and may get even longer!) which requires a good deal of scrolling to view.

All suggestions welcome.

a couple of thoughts...

1. could you not upload the image externally, e.g postimages.org and then use the direct link URL of the uploaded image in your post rather than uploading the images directly at mse forums ? that should bypass whatever upload issues you're running into here..

2. what format is the table created in? i'm just wondering if copy & paste could be a viable option?

I just created a dummy table in Excel, and if I copy & paste it into here, then I get this...

Forumite	Count	Per Month	Value	Return
exel1966	76
RosieRooBear + hubby	72
surreysaver	54			2500
janusd	19	6000	2600	>1800

that's not really practical or visually clear, but if you them manually centre the values of the cells in the last four columns (cell by cell - pita), it does become clearer...

Forumite	Count	Per Month	Value	Return
exel1966	76
RosieRooBear + hubby	72
surreysaver	54			2500
janusd	19	6000	2600	>1800

there is also the option of using a converter to change your code into either HTML or Markdown... you would just need to copy & paste your excel table into the page, and it can convert it to various formats...

so if you wanted to post a html table, then you just take the code provided by the above, enable the html view toggle above and paste the code in...

Forumite	Count	Per Month	Value	Return
exel1966	76
RosieRooBear + hubby	72
surreysaver	54			2500
janusd	19	6000	2600	>1800

alternatively, if you used Markdown as the output option, you would again enable html view toggle, manually enter < p r e > (remove spaces - just pre with angle brackets!) then paste the markdown code and finish with a closing < / p r e > (again remove spaces) after the markdown - it should look like this...

| Forumite             | Count  | PM   | Value | Return |
|:--------------------:|:------:|:----:|:-----:|:------:|
| exel1966             | 76     |      |       |        |
| RosieRooBear + hubby | 72     |      |       |        |
| surreysaver          | 54     |      |       | 2500   |
| janusd               | 19     | 6000 | 2600  | >1800  |

that may sound horrendous, but it's just copy & pasting from the spreadsheet to the converter and then the resulting code into the forum post... it might take a few goes to get it right, but it would remove the hassle of dealing with images, leagues, divisions, European places, play-offs etc. 

Bobblehat

After Ch1ll1Phlakes experiment, I thought I'd see what the table would look like being generated directly from the spreadsheet (instead of coped from the forum) ....



Edit: Apart from the gap (which is not a blank line), I'd say this simple solution does the job! If the table were to expand to 3 figures of contributors in the future, I'd say this method will cope and provide a perfectly readable table.

p.s. Sorry Ch1lliPhlakes, it's pure coincidence that the split put you at the bottom of section 1. I feel slightly guilty about this after your help   

Ch1ll1Phlakes

Bobblehat said:

After Ch1ll1Phlakes experiment, I thought I'd see what the table would look like being generated directly from the spreadsheet (instead of coped from the forum) ....



Edit: Apart from the gap (which is not a blank line), I'd say this simple solution does the job! If the table were to expand to 3 figures of contributors in the future, I'd say this method will cope and provide a perfectly readable table.

p.s. Sorry Ch1lliPhlakes, it's pure coincidence that the split put you at the bottom of section 1. I feel slightly guilty about this after your help   

Looks good. Can always change as needed but hopefully the simple solution works for a while. Thanks for maintaining the table, and no problem the way I see it is it looks like I may need a few more accounts if I'm to stay in the top half 

EDIT: Funny that quoting a previous post actually groups the pictures closer together and making the table that bit slightly more readable.

UKX69

Bobblehat said:

Ch1ll1Phlakes said:

Also don't want to step on anyone's toes but here's an example.



Not perfect saying I downloaded the most up to date pic but works ok. Hope this helps.

Yes ... it does help. Saved me from trying what you just did ... so big thanks.

How do people like this solution? Better than "Divisions"?

I like it. I think we don’t want it to get too complicated, as it is just a bit of fun after all. It’s just nice to see where other enthusiasts are at. For myself, with just 2 RS at the moment ( Monmouth/ Principality), I fully fund them @ 1200 pm, but expect that and the number of RS to rise in the future as more funds become available. 

Bobblehat’s efforts are very much appreciated.

poolboy

The only thing I miss seeing is people's min %, mines 5.0.  There's a few below it but I can't see the value.  My feeders chase 4.75 so I want 0.25% premium for my efforts.

UKX69

poolboy said:

The only thing I miss seeing is people's min %, mines 5.0.  There's a few below it but I can't see the value.  My feeders chase 4.75 so I want 0.25% premium for my efforts.

For me, I’m working from the top down with the aim of best % with max funding.

n15h

clairec666 said:

Here's a simplified version of mine that I shared earlier in the year:

https://docs.google.com/spreadsheets/d/1qAg4gDqIIuX9YO7JG7uHY5nggL90aUQMqrhUtn3JHPo/edit?usp=sharing

To extend it to the following months, select cells J3 to L15 (i.e. the June columns) and drag into July.
I highlight the "deposit" cells for a particular month and un-highlight them when I've made the deposit.
Interest calculations assume that you're depositing at the start of the month.
Columns AP-AR do nothing, they're just for your own personal reference.

@clairec666
thanks for sharing which will no doubt help manage multiple RSs once they start accumulating (I'm only at a modest 4 RSs but this will grow in the coming years, no doubt!)

n15h

Bobblehat said:

Yes ... it does help. Saved me from trying what you just did ... so big thanks.

How do people like this solution? Better than "Divisions"?

Honestly, I'm grateful for the work you and other people put into running/maintaining the thread.
I'm good with whichever solution makes your life easier

trickydicky14

I don't want to upset anyone, but why include folks that don't actually have any regular savers?
And thankyou Bobblehat  for all your hard work.