ABC
1
2
Communauto Cruncher - Versions & Errata
3
by Charles Akben-Marchand (Mastodon, blog, ko-fi)
4
5
Get the Latest version:
6
0.96 (Released 2026-05-10):
7
Beta version (Ottawa rates only, no FLEX)
8
https://docs.google.com/spreadsheets/d/1T2FM0HRRfCNuuMssxYEFhLIlR_uzZ_LJeXlB2KKKOZY/edit
9
10
Introduction:
11
Hi! I am a member (customer) of the Communauto (formerly Vrtucar) car sharing service in Ottawa.
12
I built the Communauto Cruncher tool to help me analyze my Communauto bills to see how much I could save by switching to a different plan (hundreds of dollars per year!). I've added a number of other features too.
13
I am making this tool available for free so that other Communauto members (at least those in Ontario who don't use FLEX) can analyze their usage and plan selection.
14
This document tracks the latest version of the Communauto Cruncher tool and errata (known bugs/shortcomings/feature ideas).
15
This tool is not associated with or endorsed by Communauto.
16
17
To get your copy:
18
Click on the Google Docs link above to open the lastest read-only version, linked above.
19
After opening that file, click on File > Make A Copy to save a copy to your Google Drive that you are able to edit.
20
21
Do you work for Communauto?
22
Please see the "Attn Communauto" tab for lists of questions and website feedback I have for you.
23
24
Version 0.96 (Released 2026-05-10):
25
Updates completed in version 0.96, released 2026-05-10:
• Protect non data entry fields
• Include additional driver fee on dashboard
• Mobile friendly interface
• Display additional driver fee with monthly fee on Dashboard rate summary
• Calculated monthly fees missing amounts if no trips
• Per-km rate to increase by $0.02 to $0.04 on 2026-04-11
26
See the "Errata" tab for unencountered scenarios that may not be accurately reflected in this document, and other limitations (like no FLEX calculations). (Make a copy of this document to refilter/sort the errata table and see completed item details)
27
To upgrade your file to a new version, download the latest version and copy your data from the Trip Data and Monthly Summaries tabs (only the bold fields). Additional instructions will be provided if/when I release a new version.
28
29
Disclaimers:
30
I cannot guarantee that the calculations are completely accurate for every situation. Communauto's rates and fees are subject to change and might not all be reflected in these tools.
31
I can't promise that I'll do further development of this tool. Additional data/feedback will help (see Contribute/Feedback section below)
32
33
Contribute/Feedback:
34
If you found this tool helpful, consider sending me a "tip" on ko_fi:
35
https://ko-fi.com/centretowner
36
Please fill out this Google Form if:
• This tool helped you understand your Communauto account better
• You found a bug or miscalculation
• You want to share invoice/trip information to help me develop this tool further
• You have other feedback or suggestions not already listed on the Errata tab
37
https://forms.gle/wbvbvbyXzosx6ErUA
38
You can also email me, including to send me data examples:
39
centretown.ottawa@gmail.com
40