zhuj / estimation-tools Goto Github PK

describe goals & provide documentation

mark and collect assumptions into a separate page

Add MVP column and its estimation with formulas below the table next to the total row

It's required to implement full theme support.
Theme should decide which style is required for each column, row and cell.

i.e. by calling Java+POI, if it's available:

http://stackoverflow.com/questions/23885116/is-there-any-way-to-create-a-pivot-table-in-excel-using-apache-poi

see

https://www.py4j.org/index.html
http://pyjnius.readthedocs.io/en/latest/
https://pypi.python.org/pypi/JCC

or directly from VBA

https://msdn.microsoft.com/ru-ru/library/office/hh243933(v=office.14).aspx
https://support.office.com/en-us/article/Automatically-run-a-macro-when-opening-a-workbook-1e55959b-e077-4c88-a696-c3017600db44?ui=en-US&rs=en-US&ad=US&fromAR=1

It's required to apply row visibility filter based on the value of column 'B' (a multiplier column) with the following values:

• 1 - for estimations - visible;
• 0 - for roles - invisible;
• (empty) - for section columns - visible.

use autofiltering feature for this.

It will make possible to show/hide roles row from standard Excel interface as well as it will make easier to insert new rows in the report (by hand).

It's required to ship the solution as a single python-compatible file (i.e., .py or .egg).
At the same time it's desired to have well-structured separate modules (themes, xml, estimation, nodes, freemind, ...) - it'll make the code be easy.

TBD: look for and use a build system which provide necessary result.

• create Wiki
• look at readthedocs.io

Make all texts origin from theme

Module: https://openpyxl.readthedocs.io
Usage: https://openpyxl.readthedocs.io/en/default/usage.html

Openpyxl has already been used for testing purposes due to the fact it can read xlsx files.

Goals:

• compare features
• PoC & code generalization (maybe abstraction)
• choose solution

Implement tests (both unit and acceptance)