12numbers | Easy Entry, for planning, budgeting and controlling in Excel.
EasyEntry is really a super powerful Excel Add In. And will definitely change your life, at least if you are controller or other other hardcore Excel-maniac. It enables you to enter numbers and expression like “+10%” in any calculated cell and it will - automatically and very intelligently - change all the preceding value cells to match the desired result in the calculated cell.
Excel, Planning, Budgeting, Controlling, Formulas, Data Entry
16681
page,page-id-16681,page-child,parent-pageid-15338,page-template-default,ajax_fade,page_not_loaded,,qode-theme-ver-6.5,wpb-js-composer js-comp-ver-4.4.3,vc_responsive

Easy Entry

Running Project

Table of Contents

Introduction to Easy Entry
more to come…

Introduction to Easy Entry

EasyEntry is really a super powerful Excel Add In. And will definitely change your life, at least if you are controller or other other hardcore Excel-maniac. It enables you to enter numbers and expression like “+10%” in any calculated cell and it will – automatically and very intelligently – change all the preceding value cells to match the desired result in the calculated cell.

splash

Imagine of the following Excel cells: A1 = 6, A2 = 4 and A3 = SUM(A1:A2) = 10. To invoke the magic of EasyEntry you must start your “easy entry” with a trigger. The default trigger for US keyboards is for instance the character “>”. Hence entering “> +50%” in cell A3 would not overwrite the formula but change the cells A1 and A2 to A1 = 9 and A2 = 6 and finally add up to A3 = SUM(A1:A2) = 15.

Now imagine that works for almost all often used Excel functions like SUMIF(), AVERAGE() or even IRR(). And imagine it also works 100% properly for complex formulas like this IF(A1 > 10, SUM(B1:B4), (H4/10)). Wouldn’t that be cool? I showed it a colleague of a mine, a controller and he just said:

This is unbelievable. Having this would save me days or weeks. Can I have it?

He already has it. And to be honest, EasyEntry is just a by-product of the Symbolic Planning software design and implementation. But it’s worse to make a separate small tool out of it. The software entry is currently in final development and testing, and will be hopefully released this year. Start of public beta testing will be announced in the blog.

more to come…