Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Wrong Reference in 'Monte Carlo Valuation'!N15 #30

Open
janmayer opened this issue Mar 27, 2021 · 0 comments
Open

Wrong Reference in 'Monte Carlo Valuation'!N15 #30

janmayer opened this issue Mar 27, 2021 · 0 comments

Comments

@janmayer
Copy link

In the file Tesla 2025 Valuation Extract for Github_3.18.21.xlsx, Sheet Monte Carlo Valuation, Cell N15, the formula is

=('Monte Carlo Inputs'!D43-'Monte Carlo Inputs'!C43)/2+'Monte Carlo Inputs'!C43

which is the "Tesla platform cut in China".
However, this value is used in Cell H15, with values from row 14 of the input sheet ('Monte Carlo Inputs'!D14 etc.), and is about the "% of cars sold into human driven ride-hail network in 2025".

The formula should probably be:

=('Monte Carlo Inputs'!D14-'Monte Carlo Inputs'!C14)/2+'Monte Carlo Inputs'!C14
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant