Okay, shouldn't need to go into all the nuts and bolts here...but...long story short, I reverse-engineered the Daily Cap Calc for a spreadsheet so I could fully understand how it works (I'm weird).
I finally got all of the numbers on the finance page related to the cap lined up on Excel - 99.9% perfectly. However, for some reason, the finance page has a $7 (yes, seven dollars) difference from my spreadsheet.
Another GM also does the same thing and noticed today he's $18 (eighteen dollars) short from his spreadsheet to the finance page. So it's adding a very tiny amount somewhere in the complex calculation...and we are stumped as to where it's coming from.
It's not a rounding thing...we tried that and the rounding effect of our spreadsheets was literal pennies. Simon, could you check the calculation in the coding (I know next to nothing about coding lol) and see if there's some tiny little thing causing this very small discrepancy?
EDIT: My smart wife who also has coded for SAS and Red Hat thinks it may be something related to a "floating point" issue, if that helps.
A $7 problem - sometimes $18...(Sim Finances being ever so slightly off lol)
-
- The Accomplished One / L'Accompli
- Posts: 138
- Joined: Sun Jul 12, 2020 12:22 pm
-
- STHS Owner / Propriétaire du STHS
- Posts: 14784
- Joined: Sat Oct 08, 2005 4:18 pm
- Location: Montreal, Canada
- Contact:
Re: A $7 problem - sometimes $18...(Sim Finances being ever so slightly off lol)
It could be related to floating point or/and integer issue.
But I'm happy you tell me I'm 7$ or 18$ from your calculation from of total of almost 1 million.
If you send me the SpreadSheet, I could look at it.
But I'm happy you tell me I'm 7$ or 18$ from your calculation from of total of almost 1 million.
If you send me the SpreadSheet, I could look at it.
-SimonT
Forum Administrator / Administrateur du Forum
STHS Owner / Propriètaire du STHS
English V2 & V3 Manual - Manuel V2 & V3 Français
Forum Administrator / Administrateur du Forum
STHS Owner / Propriètaire du STHS
English V2 & V3 Manual - Manuel V2 & V3 Français
-
- The Accomplished One / L'Accompli
- Posts: 138
- Joined: Sun Jul 12, 2020 12:22 pm
Re: A $7 problem - sometimes $18...(Sim Finances being ever so slightly off lol)
Link to my team's finance page in the OTHL:
https://othl.ca/File/2022-RegularSeason ... hp?Team=21 (click Finances)
Link to my spreadsheet:
https://www.dropbox.com/scl/fi/lkpcj1id ... 4cy2x1a284 (should be able to edit the doc too with this link - it's a copy, so have at it.)
https://othl.ca/File/2022-RegularSeason ... hp?Team=21 (click Finances)
Link to my spreadsheet:
https://www.dropbox.com/scl/fi/lkpcj1id ... 4cy2x1a284 (should be able to edit the doc too with this link - it's a copy, so have at it.)
-
- STHS Owner / Propriétaire du STHS
- Posts: 14784
- Joined: Sat Oct 08, 2005 4:18 pm
- Location: Montreal, Canada
- Contact:
Re: A $7 problem - sometimes $18...(Sim Finances being ever so slightly off lol)
Hi.
Before I check it out, I'll ask you one thing; active the "Output Salaries Remaining", "Output Salaries Average Total" and "Output Salaries Average Remaining" option. Then Output and look at page : https://othl.ca/File/2022-RegularSeason ... p?Number=9
You should find the issue by comparing your Excel to this page.
Before I check it out, I'll ask you one thing; active the "Output Salaries Remaining", "Output Salaries Average Total" and "Output Salaries Average Remaining" option. Then Output and look at page : https://othl.ca/File/2022-RegularSeason ... p?Number=9
You should find the issue by comparing your Excel to this page.
-SimonT
Forum Administrator / Administrateur du Forum
STHS Owner / Propriètaire du STHS
English V2 & V3 Manual - Manuel V2 & V3 Français
Forum Administrator / Administrateur du Forum
STHS Owner / Propriètaire du STHS
English V2 & V3 Manual - Manuel V2 & V3 Français
-
- The Accomplished One / L'Accompli
- Posts: 138
- Joined: Sun Jul 12, 2020 12:22 pm
Re: A $7 problem - sometimes $18...(Sim Finances being ever so slightly off lol)
Oh, I don't run this league - I'm a GM here (I run BEARD Hockey). But I have brought up that they don't have Salaries Remaining - I'll check with the commishes to see if they can do that and report back.