I want to show potential customers how to compare two different ways to pay for service. One is per employee per month, and the other is per hour. I have set up an excel spreadsheet where they input some variables and it tells them the cost of both and how much they can save, so they can see which model is cheaper for them.
I want to make it nicer to look at though, so when they visit me at my booth at a conference, we can do the math as part of an iPad presentation.
How would you do it?
Try embedding a Numbers table with your calculations into a Keynote slide.
I might think this way …
Old School - Embed the Number sheet in something.
New School - Run the Numbers sheet in a split view side-by-side with the presentation. This presumes that you have the iPad screen space to do it.
–
JJW
I’d consider just doing it in Numbers; it’s way prettier than Excel so you can get nice graphs and tables on screen together in a presentation style.
This is the Charting Basics template on my iPad.
I second this approach.
Or, to be more practical, the client will have an upper and lower limits for those factors affecting the model. I’d personally fill in those numbers, work out the numbers of both models, and show your client which factor impacts each model and quantify the impact.
So basically prepare all of that in a keynote, attach the numbers sheet in case your client needs to do the math later after the meeting.
But if you are a consultant, your client will appreciate seeing how you provide more visibility on how the models work and change. And that you did the math to help them decide before the meeting, than giving them a calculator to play with.
Oh, you can also make the cells use buttons or sliders to change values, so it’s pretty slick all things considered.
Scott, that’s what I was thinking. I want to see if I can move the spreadsheet off the screen and just show the input and output.
Thank- I’ll switch to numbers and make it look nicer
Try putting it in another sheet inside of the Numbers file, a graph can reference another sheet no problem (though another document entirely is tricky). And this way there’s nothing to scroll over to 