# think-cell chart (incl. Round)

think-cell Sales GmbH & Co. KG · from CHF 1327.79 · In stock

think-cell round – Always correct

## Details

| Field | Value |
| --- | --- |
| Producer | think-cell Sales GmbH & Co. KG |
| OS | WIN/MAC |
| Version | 12.x |
| Language | EN |
| DescriptionAdditional | Annual license incl. Updates and Support |
| LicenseLevelFrom | 1 |
| LicenseLevelTo | - |
| Delivery | ESD |
| SoftwareOneSku | TCC10 |
| ComsoftSku | TCC10 |
| LicenseType | Corporate |
| Description | think-cell chart (incl. Round) 10 User |
| Size | 1+ User(s) |

## Variants

| Variant | SKU | Price | Availability |
| --- | --- | --- | --- |
| Annual license incl. Updates and Support / 1+ User(s) | TCC10 | CHF 2533.21 | In stock |
| Annual license incl. Updates and Support / 1+ User(s) | TCC12 | CHF 2995.80 | In stock |
| Annual license incl. Updates and Support / 1+ User(s) | TCC15 | CHF 3671.32 | In stock |
| Annual license incl. Updates and Support / 1+ User(s) | TCC20 | CHF 4723.77 | In stock |
| Annual license incl. Updates and Support / 1+ User(s) | TCC25 | CHF 5782.33 | In stock |
| Annual license incl. Updates and Support / 1+ User(s) | TCC30 | CHF 6828.66 | In stock |
| Annual license incl. Updates and Support / 1+ User(s) | TCC35 | CHF 7795.44 | In stock |
| Annual license incl. Updates and Support / 1+ User(s) | TCC40 | CHF 8811.17 | In stock |
| Annual license incl. Updates and Support / 1+ User(s) | TCC45 | CHF 9802.43 | In stock |
| Annual license incl. Updates and Support / 1+ User(s) | TCC05 | CHF 1327.79 | In stock |
| Annual license incl. Updates and Support / 1+ User(s) | TCC50 | CHF 10769.21 | In stock |
| Annual license incl. Updates and Support / 1+ User(s) | TCC06 | CHF 1578.67 | In stock |
| Annual license incl. Updates and Support / 1+ User(s) | TCC07 | CHF 1824.65 | In stock |
| Annual license incl. Updates and Support / 1+ User(s) | TCC08 | CHF 2065.73 | In stock |
| Annual license incl. Updates and Support / 1+ User(s) | TCC09 | CHF 2290.90 | In stock |

## Description

When data is compiled for a report or PowerPoint presentation rounding summations in Excel is a frequent problem.
	It is often desirable but difficult to achieve that rounded totals match the total of the rounded addends.
	think-cell round addresses this problem in an automated and easy-to-use way.

	Let's look at a simple example and a more complex example with row and column sums.

	Simple example

			1.5 + 2.6 + 3.6 = 7.7

	Complex example

Total:

4.315.321.441.0

10.57.63.721.8

17.518.319.555.3

11.517.420.949.8

		Total:43.858.665.5167.9

	When rounding all numbers to the nearest integer, you get the following. Totals that appear to be "miscalculated" are in bold.

	Simple example

			2 + 3 + 4 = 8

	Complex example

Total:

4152141

118422

18182055

12172150

		Total:445966168

	For some, this is the most desirable outcome, because each number is as close to the unrounded number as possible.
	In the simple example the largest deviation is 0.5, from 1.5 to 2. You can achieve this result in Excel by using
	"Format Cell" on each value.

	But some people object, because the arithmetic is not correct. They propose to add up the rounded values. Totals
	that deviate from the original value by 1 or more are in bold.

	Simple example

			2 + 3 + 4 = 9

	Complex example

Total:

4152140

118423

18182056

12172150

      	Total:455866169

	You can do this in Excel by using =ROUND(x,0) on the addends. The problem is that now
	in the simple example the largest deviation, from 7.7 to 9, is 1.3, much larger than before.

	Is there some middle-ground between correct rounding and correct arithmetic?
	Yes, there is, because you can round as rendered by the following table. "Tuned" values are in bold.

	Simple example

			1 + 3 + 4 = 8

	Complex example

Total:

4152241

108422

18181955

12172150

		Total:445866168

	The sum adds up and in the simple example the maximum deviation is now 0.5, from 1.5 to 1.
	Rounding in such a way is trivial in this case,	but becomes very complicated if you sum over
	larger two- or even three-dimensional tables. This process is what think-cell round automates.

	Using think-cell round, you can achieve consistently rounded totals with minimal "tuning":
	While most values are rounded to the nearest integer, a few values are rounded in the opposite direction,
	thus maintaining correct calculations without accumulating rounding error.

	Since there are many possibilities to achieve correctly rounded totals by changing values,
	the software picks a solution that requires the minimum number of values changed and the minimum
	deviation from the precise values.

---

Canonical page: https://sparkdynamic.vinosoft.shop/en/shop/product/1d157163-f0d4-47dd-956f-91569fdbfa22