I too use a simple excel sheet with days 1-31 on top row, & mm-yy on first column. Each habit either has a scale of 1 to 5; or has something like X for done, v

I too use a simple excel sheet with days 1-31 on top row, & mm-yy on first column. Each habit either has a scale of 1 to 5; or has something like X for done, v for half done, o for not done etc. A conditional formatting either gradient colors the squares, or colors them good or bad colors. Columns after 31 keep count of each value in this month. Some summary tables use sumproduct to pull some trends.