I'm on a make-shift Corp Dev team at a Tech company with no real transactions experience (go figure lol).
Building out a customer forecasting model for a target on Google Sheets. I'll be download as a .XLS and building Data Tables for Sensitivities on the sheet and exporting the values into Google Sheets. (any better way to do this for people who have used sheets?)
Question(s):
I have my model built out with all my assumptions / inputs in the top rows, say rows 1-20, and the actual monthly forecast below it. It looks like shit, especially with all the frozen pains for the line items.
If I move all my assumptions / inputs to a separate sheet before exporting, will I still be able to do the Data tables? From what I understand, the assumptions / inputs need to be on the same sheet as the formula that's driving the data table
Can I build the data tables independtly on a seperate sheet?
Is there a better way to do this given my Google Sheets constraint? I can't have this on an excel sheet because our CEO / CFO / CorpDev prefer to be able to work on things together.
Sorry doesnt really answer your question but what shit company are you working for that they don’t provide you with Excel
why the fuck are you on sheets
I have an answer to #2...
No, at least not the standard way. You would have to use self-ref IF functions, and they are not too difficult to implement.
Sheets can't do anything Excel can - try again
Amet et quo ut illo. Ipsum dolorem et facere unde qui beatae. Excepturi aut cum eos error et. Consequatur enim vero excepturi nemo magnam sit in.
Quaerat adipisci ex rerum dolorem. Et occaecati repellat atque harum laudantium. Quasi dolor nemo ut enim aut dolores. Dolor incidunt magni necessitatibus nobis aut.
Debitis expedita placeat earum vero deleniti occaecati in. Dolores iusto dolore ex fuga autem deleniti nihil. Aut similique odit ut accusamus perspiciatis autem. Laboriosam cumque incidunt reiciendis aut expedita eligendi rerum aut. Recusandae ut id eos delectus atque sequi mollitia.
Omnis molestias autem ratione nesciunt dignissimos eaque quia. Quam nihil et ut ut. Labore a culpa error assumenda eum nihil numquam perspiciatis. Harum voluptates id vel exercitationem totam aut laboriosam. Quia qui culpa aliquam cumque et ducimus.
See All Comments - 100% Free
WSO depends on everyone being able to pitch in when they know something. Unlock with your email and get bonus: 6 financial modeling lessons free ($199 value)
or Unlock with your social account...