Calculation discrepancies

[SanjayRedScarf]

-- Macmillan, healthcare project 2016 -- error seems to be that overheads are not added on https://app.sogive.org/#edit?charityId=macmillan-cancer-support To see a comparison with the calculations I would expect, go to the old SoGive spreadsheet and find the 'Macmillan' tab (over to the far right) https://docs.google.com/spreadsheets/d/1Gy4sZv_WZRQzdfwVH0e3tBvyBnuEJnhSFx7_7BHLSDI/edit#gid=1413883026

-- People against poverty, Child sponsorship / way of joy / family partnership projects -- error seems to be that overheads are not added on https://app.sogive.org/#edit?charityId=people-against-poverty To see a comparison with the calculations I would expect, go to the old SoGive spreadsheet and find the 'People against poverty' tab (roughly in the middle) https://docs.google.com/spreadsheets/d/1Gy4sZv_WZRQzdfwVH0e3tBvyBnuEJnhSFx7_7BHLSDI/edit#gid=1792632738

-- Marie Curie, nurses project 2015-16 -- not sure what the error is https://app.sogive.org/#edit?charityId=marie-curie-formerly-marie-curie-cancer-care To see a comparison with the calculations I would expect, go to the old SoGive spreadsheet and find Marie Curie in the 'Main data' tab (far left). Cell AM88 shows an expected cost of £1,312, but the editor calculates it as £3,209

-- Scotland's Charity Air ambulance, overall figures -- not sure what the error is https://app.sogive.org/#edit?charityId=scotland-s-charity-air-ambulance (sorry no audit trail of calcs on this, but I can recreate it if that helps)

Not sure if this should be separated out into multiple issues?

[winterstein]

per ben of

On 6 June 2018 at 10:32, SanjayLikesCharities notifications@github.com wrote:

-- Macmillan, healthcare project 2016 -- error seems to be that overheads are not added on https://app.sogive.org/#edit?charityId=macmillan-cancer-support To see a comparison with the calculations I would expect, go to the old SoGive spreadsheet and find the 'Macmillan' tab (over to the far right) https://docs.google.com/spreadsheets/d/1Gy4sZv_WZRQzdfwVH0e3tBvyBnuEJnhSFx7_7BHLSDI/edit#gid=1413883026

Looking at the first one:

app.sogive: £10 may fund 0.24 people reached

2015 overall data is being used costs: 240491000 people reached: 5800000 cost per ben: £41.46

All looks correct -- the odd thing is that 2015 is set as the representative project.

-- People against poverty, Child sponsorship / way of joy / family partnership projects -- error seems to be that overheads are not added on https://app.sogive.org/#edit?charityId=people-against-poverty To see a comparison with the calculations I would expect, go to the old SoGive spreadsheet and find the 'People against poverty' tab (roughly in the middle) https://docs.google.com/spreadsheets/d/1Gy4sZv_WZRQzdfwVH0e3tBvyBnuEJnhSFx7_7BHLSDI/edit#gid=1792632738

Hm - I hit a bug with some over-zealous data validation blocking the view. I will switch to fixing that.

-- Marie Curie, nurses project 2015-16 -- not sure what the error is https://app.sogive.org/#edit?charityId=marie-curie-formerly-marie-curie-cancer-care To see a comparison with the calculations I would expect, go to the old SoGive spreadsheet and find Marie Curie in the 'Main data' tab (far left). Cell AM88 shows an expected cost of £1,312, but the editor calculates it as £3,209

3 inputs -- annual costs 71780158 trading costs 6982865 income from bens 23147000

the output is 31756

a cost per ben of £3209 is correct

Unless income from bens should not be included in the calculation? Which would give £2480 here.

So it looks like the system is behaving correctly, and it's just different data between the spreadsheet and the editor.

• Daniel

[SanjayRedScarf]

re Macmillan: I agree that Macmillan overall 2015 is fine. However the issue does not relate to Macmillan overall 2015, it relates to Macmillan healthcare project 2016. Having seen that numbers appeared wrong, I didn't update the representative project (surely that would be premature?) If you would be able to comment on Macmillan healthcare project 2016, that would be helpful

re Marie Curie: I have looked through each item -- the data in the spreadsheet is the same as the data you've included in your comment. Would you be able to explain how you got to £3209?

[winterstein]

On 6 June 2018 at 18:13, SanjayLikesCharities notifications@github.com wrote:

re Marie Curie: I have looked through each item -- the data in the spreadsheet is the same as the data you've included in your comment. Would you be able to explain how you got to £3209?

(71780158 + 6982865 + 23147000) / 31756 = £3209

[SanjayRedScarf]

The spreadsheet uses (71780158 - 6982865 - 23147000) / 31756 = £1312 Would it be OK to update the SoGive editor accordingly?