A reserve fund study is a report that assists condo corporations in understanding what they own, how much money they have, the timing of potential replacements, future costs, and, ultimately, how to pay for the replacements when they are due. CubeDrive helps the condominium manager translate their reserve fund study from MS Excel to online application with ease.
Existing Excel problem
In general, the reserve fund study is prepared by the engineer. Engineers will utilize a Reserve Fund Study template, frequently a complex Excel spreadsheet with many algorithms. Engineers will input data and supplement this document with a detailed narrative that analyses and reports the building’s condition.
Here comes some issues for the existing Excel solution:
Reserve fund study Online Solution
CubeDrive helps the engineer move the reserve fund study from Excel to online application with ease. It allows customers easily access the data from any device, anytime, anywhere with the fine grained control. And all data can be exported as MS Excel. With CubeDrive form and flow, managing your reserve funds accurately has never been easier.Tip: Different engineers can enter the data separately, even with their mobile, and a reserve fund study report can be generated automatically online.
Create different forms
Before business creates the project and put all data together, they need generate the related applications. In this example, the following forms are created:Tip: Manager only need share [CIVIL, ARCHITECTURAL] form to the civil engineer to fill the data. Business can create as many form as needed.
Login to the CubeDrive account, manager needs to click Kanban management icon on the sidebar to start building the reserve fund study with a drag and drop method. See the following example for the existing one.Tip: you can move the mouse around the item, a popped link will appear for the business to view the detail information.
Project related information is configured by the business. Business can setup condition and status as needed.Tip: Click "Edit Kanban Flow", business will be able to configure the project as needed.
Generate Reserve Fund Study report
Before business can generate report, the following setting need to be processed. You can navigate to "Basic" tab and click "Setting" to process configure:
With all the raw data input into the system by the engineers, the manager will be able to generate the Reserve Fund Study report.
Click the "Generate report" link, the system will extract the related information from the above forms and generate an online spreadsheet with customer required format for future reference. Customers can export it as a MS Excel file.Tip: Please click this LINK to download the exported Excel file.
For each condo item, business can also setup task with custom categories. Business can assign the task to the different engineer, such as: reminder, due date, priority etc.
You can access all of your project information from a mobile device.