This article gives details on updating prices in bulk using a formula and copying taxi fare prices from an existing vehicle price table.

[As of Cab Grid Pro version 4.2 icons for these functions have been updated: (apply a formula) (copy from vehicle) ]

Cab Grid Pro version 3.8 introduces preliminary work on bulk price updates. This facility allows all prices in vehicle price tables to be updated with one click via a formula.

There are three methods by which prices can be updated en-masse:
– ALL prices for the selected vehicle (the whole table).
– Prices FROM a selected place to all others (a single ROW in the price table).
– Prices TO a selected place from all others (a single COLUMN in the price table).

To update every price in the table click the icon at the top right of the table. This will open the formula modal box as an overlay.
To update all prices FROM a given location via a formula, click the label in the first column for that place’s row (the place name).
To update all prices TO a given destination via formula, click the label in the column heading for that place (the place name).

Once the formula box is open, you can enter a formula or a single price to update all the prices for the selected group.

Single price for every cell

So, at its most simple, you could set all prices to $10.00. To do this, you would simply enter ’10’ in the formula box and click the green APPLY button. The price for every possible journey will be set to $10.00. This could form a good starting point for further modifications.

Removing prices en masse

To remove prices for the selected set, enter ‘0’ in the formula box. This will reset all prices for the selected group.
Note: if a formula results in a value less than 0 (e.g. currentValue-100) then these prices will also be considered reset.

Using a formula to update taxi prices in bulk

To use a formula, the variable “currentValue” (as capitalised) can be used. It represents the current price for each individual journey. A calculation will be performed to update each price based on this.

The formula accepts common mathematical operators: plus/add (+), minus/subtract (-), multiply (*), divide (/), parenthesis, etc.

Example bulk price update formula

Copy prices from other vehicle

Each vehicle type added in Vehicles tab has its own price table in the Prices tab. Adding prices for multiple vehicles can be laborious, however it is possible to duplicate complete price sets from another vehicle as a starting point. Combining this with bulk updates via a formula (see above) can speed up price data entry.

How to use the duplicate price table feature…

• Click the copy icon at the top right of the destination vehicle table (that is the table the prices are to be copied to).
• A pop-up box will be displayed (see pic below).
• Select the source vehicle from the drop down menu (that is the vehicle prices are to be copied from)
• Click ‘Preview Changes’ to have the prices provisionally copied to the destination table (prices are not fully replaced yet)
• If the prices are acceptable, click ‘Update ALL Prices’. This will save the price changes to the destination vehicle table. (Click cancel to revert to the original prices for that vehicle)

Tags: bulk updates, calculation, formula, price table, prices, v4