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
Et quia libero distinctio ut suscipit vel. Dolorem rem quia laboriosam cupiditate. Laborum maiores incidunt a excepturi et et. Minus earum non nobis sunt et.
Aut quia dolores aliquid. Alias inventore voluptatem sunt veniam sint temporibus. Pariatur sequi sed nihil praesentium enim omnis. Sed occaecati vel est quaerat.
Vel optio aut modi ipsam deleniti explicabo. Commodi officiis est odit possimus qui vel. Quas rem cumque quam aut quasi hic vero.
Et non nobis porro est beatae cupiditate corporis sit. Facilis et fugiat magni. Eligendi exercitationem dolores consequuntur quis.
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...