The budget as a spreadsheet, keyboard and pasting

The budget on the Cost items tab works like a spreadsheet. The columns run Item, Qty, Days / hours, Rate.

Moving between cells

Moving works across category boundaries too. Collapsed categories are skipped.

Pasting from a spreadsheet

Select a few cells in Excel, Numbers or Google Sheets, copy them and paste into a budget cell. The block spreads right and down from the cursor, in the order of the budget columns. Columns beyond Rate are left out.

• If there are not enough rows, new ones are added at the end of the same category. The block never spills into the next one.
• Spaces and currency signs are stripped from amounts, so “1 500,00 zł” or “€1,500.00” paste as a number.
• Pasting overwrites cells, as in a spreadsheet, and cannot be undone. A single value pastes the usual way, with undo inside the field.

Copying a row

Put the cursor in any cell of a row and press Cmd+C (Ctrl+C on Windows) with nothing selected. The whole row is copied: name, quantity, days and rate. Paste it with Cmd+V into the Item cell of another row, in another category or in Excel. If you select text in a field, Cmd+C copies just the selection, as usual.

Reordering

Categories, items within a category, markups and the production subtotal line are reordered with the ⠿ handle. Drag it, or reach it with the Tab key and use the up and down arrows. You can also move an item straight from a cell with Alt and the up or down arrow (Option on a Mac). Items move within their category. To get one into another category, copy the row.

Windows and help