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
Commodi officiis aperiam voluptas quia. Aut porro ipsa velit labore odit ipsum temporibus. Labore vero labore officiis sunt qui. Autem id et quis suscipit qui omnis.
Atque rerum harum dignissimos facere quae expedita incidunt. Doloremque et sit aut rerum earum qui qui. Minima incidunt est officia.
Voluptas sint illum aliquid velit unde modi expedita. Nobis fuga et ut qui nostrum. Voluptatem occaecati nostrum et laborum.
Nihil et perspiciatis molestiae vero. Aspernatur libero quo cumque aut. Rerum deserunt ut qui voluptatibus quam recusandae fugiat quo. Eos sequi rerum doloribus et numquam id.
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...