Try FD4Cast - robust but flexible Excel modelling and happy to do customisations where required.
Ratios and KPI analysis can be custom-designed to be exactly as you wish.
Happy to customise further for you if you wish, but essentially you just need to add new 'Case' statements for each type of transaction you need to analyse. Ideally I would build a table/ matrix / look-up list in an 'Admin' sheet in Excel with a list of string search options that you can look for which return the analysed values. That way you just add the new values to the table rather than having to adjust the VBA code every time.
Yes, what a way to destroy a business model....engage a team of web developers to make your website "mobile friendly" and give advertisers more prominence, and at the same time drive your target audience away in droves.
I keep trying to 'get with the program', but every time I try to read some content I get these annoying pop-ups asking me to register or login which seem impossible to close on a mobile device. In the end the only option is to give up.
This was the email I got from those people....
Dear Mr xxxxxxx,
I am contacting you as you have registered with one of our online partners who felt you might be interested in our services. Our Senior Consultant in your regional office has reviewed your details and asked me to contact you.
If you are actively job searching, we are confident that we could assist you in exploring your career options with the aim of significantly enhancing your career prospects.
PCS have assisted thousands of individuals secure their next role, primarily by exploring the unadvertised job market.
To enable me to arrange a convenient time for a meeting with our consultant please reply to this email confirming your desired salary and availability over the next 7 days.
I look forward to hearing from you.
Rebecca C Ripley
PA to Regional Director
No win - no fee
Get them to agree a suitable fee payable once they've secured you a job via their contacts, then just pass on this 'recruitment' fee to your new employer in terms of a higher salary request.
Who are these people anyway? Can you post some details?
Fully integrated P&L, BS and Cash Flow for forecasting, budgeting and reporting in MS Excel...
It's not really clear what your issue is. If you are trying to deploy a new "instance" of Excel (i.e. run Excel separately twice) then you will always get this issue - there's simply no avoiding it. It will give you a message that Personal can only open in "Read-Only" mode but it will still allow you to work on new spreadsheets.
However, I get the feeling there's something in your Personal.xls code that Excel doesn't like when creating new workbooks. The only way to solve this is to get someone to troubleshoot your code.
Get in contact if you wish me to have a look (no charge):- james at fd4cast.com
A simple VBA macro will do this for you. If you want me to knock something up for you that does this (no charge) then send me the spreadsheets to look at. It shouldn't take me more than a couple of hours to turn around.
But if it's an important part of your business then you really should look at getting your customers to order online via a secure site. These days what you're asking for can be done for as little as £400-£500 and looks much more professional than an Excel-based ordering system.
Perhaps go with my VBA solution first and see how it works for you? The code will only be contained in your master sheet so you won't need to send macro-enabled worksheets to your customers, just basic .xls or xlsx files.
If you're interested, get in touch at james at fd4cast dot com.
I use a bulk emailer built in Excel linked to Outlook.
It allows you to specify exactly who it goes to, CC, BCC, Subject, Greeting, and Attachments.
The idea is that for regular clients you can just refer to the emailer tool, click a button and the email gets built in a single second.
Once you set up each client, you'll never make another mistake in terms of recipients.
For a free copy simply download from here:-
It should be fairly intuitive, but please feel free to contact me for any help you require.