In-Cell Calculator - Download and Install Page

Supported Versions of Excel and Windows

Excel: In–Cell requires Excel 2000 or later, (version 9 or later.)
Excel 2000 is version 9. Version numbers can be found by clicking the 'Help' menu item, in Excel and choosing 'About ... Excel'
After the name of the Excel product, e.g., Excel 2003, there is a version number. There may be minor version numbers as well, such as 11.8120, but it is the first number (11 in this example) which is the version number.

Windows: In–Cell will run on Windows XP, Windows 2000, Windows NT version 4 and Windows 98SE
On Windows 98 and Windows NT, In–Cell only supports one user profile. On the other, later versions of Windows, In–Cell supports a separate profile for each user who has their own log–on name.

How to Install the In–Cell Program

The following steps show how to download and manually put the In–Cell file in the right location for Excel, and then how to make Excel load the file.
As an alternative for XP users I have a small program that will do all of the install once you have downloaded the file. Go to the XP installer.

1. Download the File and Save to your PC

Follow the instructions on the download page to access and download the file. Unzip the download file and make a note of the directory that you extracted the In–Cell Calculator.xla file to.

2. Find the Install Directory

In–Cell is an Excel Add–In. Excel provides some Add–Ins with its original distribution, and these provide additional functionality, such as the Analysis toolpack which includes the useful end of month function EOMONTH.

If you are using Windows 2000, or Windows XP:

open a directory search window, such as 'My Computer' from the desktop
enter the following into the address box: %USERPROFILE%\Application Data\ (you can copy and paste this).
Hit 'return' and the text you have just entered will change to a normal path, starting with a drive letter, e.g., C:
In the main part of the Window there will be a list of software suppliers such as Adobe and Microsoft. Create a new directory (File menu – New – Folder) or right click in the main window and select New – Folder.
Name the new folder In–Cell
move to the new directory/folder you have just created
Copy the file In–Cell Calculator.xla to this directory/folder

If more than one user is going to access In–Cell, repeat the process after each user has logged–on.
The new folder you created will also be used to store the user's settings file. (The file is named InCalcN.txt, where N is a version number.

Note that no changes are made to the Registry.

If you are using Windows NT4:

If you are using Windows 98SE:

If you are using Windows 98 open a directory search window, such as 'My Computer' from the desktop and enter the following into the address box: %Windir%\Profiles\All Users\Application Data\ (you can copy and paste this). Hit 'return' and the text you have just entered will change to a normal path, starting with a drive letter, e.g., C: . In the main part of the Window will be a list of software suppliers such as Adobe and Microsoft. Create a new directory (File menu – New – Folder) or right click in the main window and select New – Folder. Name the new folder In–Cell, and move to this directory/folder.
Copy the file In–Cell Calculator.xla to this directory/folder.

C:
Documents and Settings
The folder with your User name
(If you are the only user and have not set up a user profile, go to the All Users directory.
Application Data
The Application Data folder and subsequent folders are 'hidden' folders, so if you don't see these folders go to Tools – Folder options –View – Advanced settings, and select 'Show hidden files and folders'.
then open the folder named Microsoft,
and finally the folder named 'AddIns'

This is the place to load the In–Cell calculator Add–in named 'In–Cell Calculator.xla'

There is another way to get to this folder using the Windows Command Line:
Click 'Start', select 'Run', enter the letters cmd and click OK. Up comes a text window, like the old DOS window.
In this window:

type C: and hit enter
type CD\ and hit enter. The new line should show C:\>
Enter the following: CD %systemdrive%/%homepath%/
(note the space between CD and % but no other spaces), and hit enter.

This should display the path to your current user directory. Use this path information to navigate to the user folder, where you will find the Application folder (unhide if necessary), then go to the Microsoft directory and finally the AddIns directory.
Now you are ready to copy the In–Cell file : In–Cell Calculator.xla, to this directory.

Excel 2000

Excel 2000 stores Add–In's in various locations. The preferred location to put the In–Cell Calculator.xla file is C:\WINDOWS\Profiles\User Name\Application Data\Microsoft\AddIns, where 'User Name' is the name of the logged-on user. If individual profiles have not been created, try C:\WINDOWS\Profiles\User Name\Application Data\. If this path /directory does not exist, it should be created.

3. Move the In–Cell File to the Add In Directory

Go to the location that you downloaded the In–Cell file to. Copy the file and then goto your User AddIns directory and paste the file.
If you can't remember the download location, use the file search function, (Start – Search) to find the file In–Cell Calculator.xla.

4. Set Excel to Load In–Cell

Open Excel and go to the Tools menu, Add–Ins. There may be several Add–Ins shown in the dialog box that opens, and one of them should be In–Cell Calculator. Check the box next to it.
In–Cell should now load automatically every time you start Excel. The calculator itself won't open automatically, but the right–click menu should include In–Cell Calculator which can be clicked to open it.

How to Uninstall In–Cell

Open Excel and click on the Tools menu, and the Add–Ins item. Clear the check box alongside In–Cell Calculator. Close the Add–Ins dialog, and quit Excel. The next time you start Excel, the In–Cell Calculator option will not be available from the cell, right–click menu.
To completely remove In–Cell, delete the file In–Cell calculator.xla, (see the install section for how to find this folder, or use Start, Search, to open a search function, and search for In–Cell Calculator.xla. Open the folder the file is in and delete the file.
then go up two directory level to the folder named Application Data, and go to the In–Cell folder. In this folder delete the user settings file InCalc2.txt. See below for the location when running Windows 98.
If more than one user has setup In–Cell, then the xla file and the settings file will have to be removed from each users folders.

In Windows 98, the path for the InCalc2.txt file is different. If Windows is in the directory C:\Windows, then goto the C:\Windows\Profiles\All Users\Application Data\In-Cell\ directory, and delete the InCalc2.txt file.
For Excel 2000 (also known as Excel 9), Excel is loaded, by default, at C:\MSOffice\Excel. The AddIns directory is C:\WINDOWS\Profiles\User Name\Application Data\Microsoft\AddIns\, (where User Name is the name of the logged–on user. The In–Cell file, In-Cell Calculator.xla should be in this directory, or in the C:\WINDOWS\Profiles\All Users\Application Data\Microsoft\AddIns\. Alternatively use 'Start' and 'Search' or 'Start' and 'Find' (depending on version of Windows), to find the file. The search option should be set to include system and hidden directories.

Download

To download, click on the following link:
Download In–Cell Beta version

Depending on your browser you may be asked whether to just download, or open the zip file. Choose download.

Thank you for trying this beta version of the calculator.
The Beta version is good until the end of December 2009.
Feedback is welcome.

Questions or comments can be sent to Feedback
or feedback@in–cell.org

The End of Month Function

EoMonth is an Excel formula which returns the last day of a month. The formula takes a date which can be any date or the function 'Now' which returns today's date, and a second argument which is the number of months away from the month of the date entered. The number of months away can be negative for months before this date's month, zero for the end of the entered date's month or positive, for the end of months after the entered date. In other words, if the first argument entered is the date 10 January 2006, and the second argument is 1, the result is the last day of the month after January 2006, which in this case is 28 February 2006. If the second argument was 25, then the value returned is 29 February 2008. (2008 will be a leap year).
One of the uses of this function is to create a table of start and end dates of periods, such as quarters. The function actually returns date values, and dates in a table can be compared to the start and end dates to determine which period they are in.

The formula used in the centre of the table is in the following form: =IF(AND($C24>=D$14,$C24<=D$15),"X",""), this formula was from cell D24.
The formulas in the first set of rows labelled 14 and 15 are just copies of the cells in rows 14 and 15 showing the formulas, so that you can see both the formulas and what is displayed.
The way dates are displayed depends on the date formatting applied to the individual cells. Cell D14 has the date for the start of the periods, all the other dates are calculated either by the EOMONTH formula or =+1 which is one day after the end of the month, i.e., the 1st of the next month.

Image of dates allocated to periods table in Excel

Download and Install