Capn Frank Posted May 17, 2016 Posted May 17, 2016 Account Summary This topic is to discuss perceived errors in your account. If you'd like to discuss your account in private, you may submit an entry with the Adjudication Form. Providing links related to builds being discussed really speeds up verification of your request. Each citizen, settlement, trade company, and faction have their own account. These sheets are live. If you submit a form, your account will be updated right away. Account Summaries: May-Jun 2023 Mar-Apr 2023 Archives Spoiler Nov-Dec 2022 Sep-Oct 2022 Jul-Aug 2022 May-Jun 2022 Mar-Apr 2022 Jan-Feb 2022 Nov-Dec 2021 Sep-Oct 2021 Jul-Aug 2021 May-June 2021 March-April 2021 January-February 2021 November-December 2020 August-October 2020 July 2020 October 2019 - July 2020 September-October 2019 May-August 2019 April 2019 January 2019 December 2018 November 2018 October 2018 September 2018 August 2018 July 2018 June 2018 May 2018 April 2018 March 2018 February 2018 January 2018 December 2017 November 2017 October 2017 September 2017 August 2017 July 2017 June 2017 May 2017 April 2017 March 2017 February 2017 January 2017 December 2016 November 2016 October 2016 September 2016 August 2016 July 2016 June 2016 May 2016 January through April 2016: This sheet is big and slow. If you would like a reminder as to what you've submitted in the past, feel free to use the following forms. Remember, spelling is important. Free Build Entry List Property License Entry List Ship License Entry List Additional Notes: Some sheets require some manual entry for the entry to be calculated correctly. Mines require manual entry for the application of the prospecting or license fee until the Property Form is updated. Monopolies are not automatically applied when a form is submitted. Monopoly modifiers are entered manually until the Property Form is updated. Ship licenses are nearly always a manual entry, unless you are paying a standard price for your vessel. A special thanks to Captain Genaro and Dr. Spock for helping me set up the Google Sheets and Forms. Quote
Elostirion Posted May 17, 2016 Posted May 17, 2016 Elostirion, line 52 January: It states 40, I say it's 44. February: It states 185, I say it's 193 (=149+44). Also see our private conversation from May 3rd/4th. March * Property licenses: Expense 50, Yield 18 => should result in -32, results in -33 in the sheet? Rounding? * sheet states that I paid 225 DBs as ship licenses. I didn't. I bought one ship via auction, and paid the according 33 DBs via transaction form. I did not buy a real license. Maybe I misfilled the form. April: no complaints May: no complaints Except for the 225 DBs for the ship that's only minor stuff. Thanks a lot for doing this, helps a lot! Quote
CelesAurivern Posted May 17, 2016 Posted May 17, 2016 March * sheet states that I paid 225 DBs as ship licenses. I didn't. I bought one ship via auction, and paid the according 33 DBs via transaction form. I did not buy a real license. Maybe I misfilled the form. Had the same issue. I think it was because the old form didn't have the auction option. Adjucation form submitted. Quote
Legostone Posted May 17, 2016 Posted May 17, 2016 Same here with a ship bought in auction! I think we need a tickbox in the ship license form as in ()ship not licensed ()ship not licensed, bought from another player ()ship licensed, captured ()ship licensed, bought from another player/faction/NPC ()ship licensed, should be unlicensed I think that should be all cases that matter. Would make licensing ships won in an auction and or captured a little less of a hassle for us and makes it easier to keep an overview for you I think;) The value I'm talking about should be in Y58 in April btw;) Great job anyways, the small differences are just minor inconveniences ;) Quote
The Sarge Posted May 17, 2016 Posted May 17, 2016 Which column is supposed to be our current balance? According to my own spreadsheet I'm supposed to have a balance of 7 dubloons, pending the MCRA resolution. Shall I type it up and send it to you for evaluation? The one error I may have made is in income. If I liscence a property in say, February, do I see income from it in March or in April? I figured not until April so I may have shorted myself. Quote
CelesAurivern Posted May 17, 2016 Posted May 17, 2016 (edited) Which column is supposed to be our current balance? According to my own spreadsheet I'm supposed to have a balance of 7 dubloons, pending the MCRA resolution. Shall I type it up and send it to you for evaluation? The one error I may have made is in income. If I liscence a property in say, February, do I see income from it in March or in April? I figured not until April so I may have shorted myself. I think the best way is to check your own monthly and point out exactly which cell data is incorrect. Also, it seems like property income comes after 30 days, so if you licence in Feb, you won't see it until end Mar. Edited May 17, 2016 by CelesAurivern Quote
The Sarge Posted May 17, 2016 Posted May 17, 2016 Thanks, looks like I did income correctly then. I'll have to set down this weekend and comb through the sheets to figure it out. Quote
Mike S Posted May 17, 2016 Posted May 17, 2016 January- MRCA income is not correct, should be 247 February- is correct March- is correct April- 100db for Sulky upgrade needs to be switched out of transactions, MRCA not added yet so can't check final total May- correct so far Quote
SilentWolf Posted May 17, 2016 Posted May 17, 2016 (edited) I spent 5 dbs on a small residence in April. I checked and the license did get purchased. Thus, I should have an ending balance of 16 (without the MRCA which just posted). Otherwise it looks great to me. I like this form as it makes it easy to check each category. Edited May 17, 2016 by SilentWolf Quote
Kwatchi Posted May 17, 2016 Posted May 17, 2016 Seems Charlatan Bay didn't get entered as a settlement. Quote
Capt Wolf Posted May 17, 2016 Posted May 17, 2016 (edited) Two errors in the Capt Wolf account, in reverse order: The ship I licensed in April was a free license (I had lost my ships in the March MRCA), so I shouldn't be charged the 150 there. The large plantation (with monopoly bonus) I licensed in March was an expansion of an earlier medium plantation, not a new property. The license cost should only be the difference (100-75=25), so my total property license expenses for March should be 50, not 125. Furthermore, all subsequent property yield numbers are 23 doubloons too high, as they give me credit for both a medium plantation (w monopoly bonus) and a large plantation (w monopoly bonus) when I only have the large plantation. Link to the original medium plantation. Link the upgraded large plantation. Edited May 19, 2016 by Phred Quote
Captain Becker Posted May 17, 2016 Posted May 17, 2016 Think that seems right to me. All is in goo order. Its 35 dbs form entering and putting it as a FB. now I need to wait for the dbs to arrive from the MRCA and pay the escort taxes off. I dont like paying, but if I want to make such good profits in the next MRCA the coming, well, its a must! Like it or not... Captain Becker Quote
MKJoshA Posted May 17, 2016 Posted May 17, 2016 It looks like the MCRA freebuilds are being entered at 5DBs instead of 10DBs. Are the forms registering the MCRAs as a 3rd freebuild instead of the MCRA? Quote
Franco Clarke Posted May 17, 2016 Posted May 17, 2016 Thank you for taking the time to set this up, I'm sure it will be very useful! Quote
Capn Frank Posted May 17, 2016 Author Posted May 17, 2016 Additional Notes: Some sheets require some manual entry for the entry to be calculated correctly. Mines require manual entry for the application of the prospecting or license fee until the Property Form is updated. Monopolies are not automatically applied when a form is submitted. Monopoly modifiers are entered manually until the Property Form is updated. Ship licenses are nearly always a manual entry, unless you are paying a standard price for your vessel. It looks like the MCRA freebuilds are being entered at 5DBs instead of 10DBs. Are the forms registering the MCRAs as a 3rd freebuild instead of the MCRA? No, MRCA builds should be 10 DB. Let me know if there is an error. Except for the 225 DBs for the ship that's only minor stuff. Thanks a lot for doing this, helps a lot! Had the same issue. I think it was because the old form didn't have the auction option. Adjucation form submitted. I sent you each a PM with details. Let me know if everything is good to go. Quote
TitusV Posted May 18, 2016 Posted May 18, 2016 so, I don't want to be whiny, but in my own calculations I end on (after May's MRCA) 191DBs... I have not yet checked the other niets to see what could have gone wrong, but I'll try to do that ASAP Quote
MKJoshA Posted May 18, 2016 Posted May 18, 2016 No, MRCA builds should be 10 DB. Let me know if there is an error. Just to follow up on this, I checked the logs and somehow I must not have marked it as an MCRA build so it was logged as a 3rd freebuild. I sent the adjudication form yesterday. Just wanted you to know the automation still seems to be working. Quote
Capn Frank Posted May 18, 2016 Author Posted May 18, 2016 Same here with a ship bought in auction! I think we need a tickbox in the ship license form as in ()ship not licensed ()ship not licensed, bought from another player ()ship licensed, captured ()ship licensed, bought from another player/faction/NPC ()ship licensed, should be unlicensed I think that should be all cases that matter. Would make licensing ships won in an auction and or captured a little less of a hassle for us and makes it easier to keep an overview for you I think;) The value I'm talking about should be in Y58 in April btw;) Great job anyways, the small differences are just minor inconveniences ;) Your ship license has been adjusted to 0 DB with the free license. The ship form will be updated to remove all the manual entry ...eventually. Seems Charlatan Bay didn't get entered as a settlement. It is now. Also, I took care of your Adjudication for your factory. Quote
Tezclatipoca Posted May 18, 2016 Posted May 18, 2016 Excellent job doing this Phred ! I have noticed that in my sheet that I paid the license of the ships, but I hadn't to pay for them because there were all free licenses ! I lost both the Appleseed and the Raenette that were free licensed ships. I used my free license in February on the Raenette when I lost the Appleseed in the January MRCA. And I sistershipped a Raenette II on my free license in April when I lost the Raenette in Bloody Billy's attack in the March MRCA ! (I especially talked to KaiNRG about that and that leaded to the rule that is excluing the class0 ships in the ship count in order to have a free license) So I hadn't to pay 100 in ship license in February, and the same happened in April, I hadn't to pay 100 in the license for the ship. So my May total is wrong because of that; I should have 200 more in the total : I should have 216 in total in May. But the rest is right; you even already counted the Commerce bonus ! Good job ! Quote
Capn Frank Posted May 18, 2016 Author Posted May 18, 2016 Also, it seems like property income comes after 30 days, so if you licence in Feb, you won't see it until end Mar. Correct, yields and upkeep are applied the following month the license has been paid. Quote
Vedauwoo Posted May 18, 2016 Posted May 18, 2016 Is this post a replacement for the old monthly "scorecard," or is the scorecard still going to be posted as well? Quote
Capn Frank Posted May 18, 2016 Author Posted May 18, 2016 January- MRCA income is not correct, should be 247 February- is correct March- is correct April- 100db for Sulky upgrade needs to be switched out of transactions, MRCA not added yet so can't check final total May- correct so far In January, Black Marlin made 136 DB, and the Sulky Harlequin made 96 DB. The total for MRCA was 232. Your account total according to Ska's calculations was 247 DB. April MRCA has been added to the Summary. Do Sulky upgrades need to remain out of the transactions? I spent 5 dbs on a small residence in April. I checked and the license did get purchased. Thus, I should have an ending balance of 16 (without the MRCA which just posted). Otherwise it looks great to me. I like this form as it makes it easy to check each category. The license expense is now being shown. Is this post a replacement for the old monthly "scorecard," or is the scorecard still going to be posted as well? I am not sure yet. You could say this summary is the current scorecard. Quote
Mike S Posted May 18, 2016 Posted May 18, 2016 In January, Black Marlin made 136 DB, and the Sulky Harlequin made 96 DB. The total for MRCA was 232. Your account total according to Ska's calculations was 247 DB. April MRCA has been added to the Summary. Do Sulky upgrades need to remain out of the transactions? Yes, I figured out the discrepancy was elsewhere. As far as the 100DBs for the Sulky upgrade, shouldn't that be placed in ship license instead of transactions? Quote
Capn Frank Posted May 18, 2016 Author Posted May 18, 2016 As far as the 100DBs for the Sulky upgrade, shouldn't that be placed in ship license instead of transactions? Yes, it should. Corrington only gets half of license fees, not the whole thing. I've already moved your Transaction to the Ship License forms. you should be good to go. Quote
Fuzzy MacFuzz Posted May 18, 2016 Posted May 18, 2016 (edited) Hi Phred, thanks for all your hard work preparing this amazing summary. I don't really understand how the settlements work but I think Port Raleigh should have at least some value as it has a few good buildings. Ska has calculated its setlement value as 8, whatever that means. Please check and amend the summary sheet when you get time. Thanks! Edited May 18, 2016 by Fuzzy MacFuzz Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.