You can't really use ratio metrics for cells to GB, it's too variable
The sizing is as follows for any line item or list property. The "cell count" for properties will be the number of members in the list (including subsets)
Boolean = 1b
List, Time, Date formatted = 4b
Number and Text = 8b
As @usman.zia said each list item = 500b (including the name and code properties)
You also need to account for subsets = these also count as list members too, so 1m items and 2 subsets of 500k each = 2m
Finally you need to throw switchover into the mix. This can reduce model cell count too as the "actual" periods are not counted
I hope that helps
David
Gigabyte Missing for Workspace Calculation
Hello Anaplanners,
I am currently working on a size simulation model. The purpose is to reproduce the "model info" shown in a model and apply some changes (create new module, extend a time range...) to see the impact on the model size.
I have already calculated the cell counts of my source model but I am not matching the size in Gigabytes.
The cell count from the source module matches well with my cell count calculated by format.
Please see attached, a screenshot of the “OUTPUT FORMAT MODULE”. I have also included in my calculation the list members (500bytes/item)
Sourced Module is 3.17 GB with 440 million cell count.
I calculated the 440 million (Checked) but it represents only 3.04 GB and I am left with 0.13 GB uncalculated (~3%), See attached “Output in GB”
I need your assistance and please let me know if I am missing any step that uses space.
Thanks,
Irish
Comments
-
List subsets will take same size of lists. This can be one potential reason for deviation
V.Sai Bharadwaj
0 -
-
Thanks for your swift reply, I will be happy to discuss about it. Im connecting to your linkedin
Thanks for your swift reply, i didnt know about that buffer. It can consume up to 3% of the total GB consumption. i will surely have a look to the link. have you ever gone through this situation?
0 -
Refer to this post:
You may be missing:
- List properties
- Subsets
- Switchover may also impact your final result as a reduction of cells
0