shimself
Member of DD Central
Posts: 2,563 
Likes: 1,171
|
Post by shimself on Nov 8, 2017 11:08:13 GMT
Vote result was as follows
Option A: 4.36%
Option B: 4.34%
Given the closeness of the vote, the percentage was counted to 30 decimal places which is the maximum permitted by Excel.
3 decimal places would obv hav done it but AC just love that shrapnel
|
|
Mike
Member of DD Central
Posts: 651
Likes: 446
|
Post by Mike on Nov 8, 2017 12:53:06 GMT
The Borrower asks for £
The loan is split among lenders as %age
But the %age represents £
The loan emails say votes are £-weighted
Then the %age weighting is converted into £-weighting is converted into %age again by Excel?
More importantly...
What is their obsession with %ages?
|
|
Neil_P2PBlog
P2P Blogger
Use @p2pblog to tag me :-)
Posts: 355
Likes: 209
|
Post by Neil_P2PBlog on Nov 8, 2017 12:59:23 GMT
Vote result was as follows
Option A: 4.36%
Option B: 4.34%
Given the closeness of the vote, the percentage was counted to 30 decimal places which is the maximum permitted by Excel.3 decimal places would obv hav done it but AC just love that shrapnel Excel is not reliable to do checks at that type of accuracy anyway, e.g.: A1: 0.000123456789012345 B1: 1 C1: =A1+B1 Excel answer: 1.00012345678901 Source/Explanation: support.microsoft.com/en-us/help/78113/floating-point-arithmetic-may-give-inaccurate-results-in-excel
|
|
mikes1531
Member of DD Central
Posts: 6,453
Likes: 2,320
|
Post by mikes1531 on Nov 8, 2017 22:28:40 GMT
This is all interesting, but the significant point I see is that more than 90% of the investors didn't bother to vote!
|
|
markb
Member of DD Central
Posts: 79
Likes: 43
|
Post by markb on Nov 9, 2017 13:42:33 GMT
What loan number is this?
|
|
