Bid workload planner
Several tenders, one team. Add each bid’s tasks and each person’s available hours, and see which days someone has more work than time.
How to plan bid work across several tenders
- Set the dates. Choose the week your plan starts and how many weeks it covers, from one to four.
- Add your team. Enter the hours each person has for bid work each day. Set every weekday at once, then change the days that differ.
- Add your bids. Give each one a name and its submission date.
- Add the tasks. Choose who does each one and type its hours into the days, or spread a total across a date range.
- Read the team rows. A day where someone has more work than time turns the alarm colour. Select it to see the tasks behind it, then move or reassign hours until the plan fits.
Reading the sheet
People sit at the top of the sheet and bids below, in the same day columns, so a busy day lines up with the tasks that fill it.
- Planned work
- A person’s day turns gold as its available hours fill, and the line beneath shows how full it is. The figure is the hours planned.
- More work than time
- The day turns the alarm colour and shows the hours over, such as +2.
- Unavailable or after submission
- Hatching marks a day set to 0 hours, and the days after a bid’s submission date in its rows, where any hours get a warning mark.
- Not set
- No hours entered for that day yet. Work planned there reads 4 / ?, never free and never over.
- Submission day
- A flag marks each bid’s submission date in its column.
Why unknown availability is not zero
A blank day and a day off are different facts. Zero means no time for bid work, so any hours planned that day count as over. Not set means you do not know yet: the planner shows ?, never counts it as free time or as a clash, and each person’s row counts the days still not set, so you know whose diary to check.
New people start with weekdays not set and weekends at zero. Enter the hours left after other work, or 0 for a day of leave.
Spreading hours and tidying up
When a task needs a set number of hours before a deadline, choose Spread hours from its menu. Enter the total and the dates, and the planner splits it evenly in half-hours, skipping weekends and days with no availability unless you say otherwise. You see the split before applying it, and only that task’s hours between those dates change.
A task’s menu can also move it a week earlier or later, or copy it for someone else. Removals happen at once, with Undo in the message that follows, and removing a person removes their tasks too. Every change can be undone from the toolbar or with Ctrl+Z (Cmd+Z on a Mac).
What the planner does not do
- It does not schedule work. It checks the hours you give it and never moves them by itself.
- It has no accounts and no sign-in.
- It has no cloud sharing, so two people cannot edit one plan at the same time.
- It does not track whether tasks are done, and it never moves your dates.
Your plan stays in this browser
The planner runs in this browser. What you type is not sent to Bidsights or anyone else, nor put in the page address. Unless you turn it off, a copy is saved on this device so you can carry on later. That copy is not encrypted, anyone using this browser profile can open it, and clearing browsing data deletes it.
To keep a plan or pass it on, use Download:
- Editable plan (.json) to reopen here later with Open a saved plan.
- Tasks spreadsheet and capacity spreadsheet (.csv) to open in Excel or another spreadsheet app.
- Print or save as PDF for a summary to take into your next planning meeting.
Questions about the planner
Is it free?
Yes. It needs no account and no sign-in. A plan covers one to four weeks and holds up to 20 people, 20 bids and 500 tasks.
Where is my plan stored?
In this browser, on this device, while saving on this device is on. You choose whether to continue it when you come back, which matters on a shared computer. It is not a backup, so download the editable plan file to keep a plan.
Can I open it in Excel?
Yes. The tasks spreadsheet has a row for each task on each day, and the capacity spreadsheet each person’s available and planned hours by day. Both are .csv files that Excel, Numbers and Google Sheets open. Keep the editable plan file to edit the plan here again.
Can my team edit the same plan?
Not at the same time: there is no cloud sharing. Send the editable plan file to whoever plans next, and they open it with Open a saved plan. Opening a file replaces the plan on screen; Undo brings the previous one back.
What does ‘not set’ mean?
No available hours have been entered for that person on that day, so the planner shows ? rather than guess. Enter 0 for a day someone cannot work on bids.
Does it work on my phone?
Yes. On a narrow screen it shows one day at a time, with each person’s load and that day’s bid work, and larger controls for changing hours.
Planning is one part of the bid
This planner checks hours for the weeks ahead. Bidsights is a CRM for bid management. It keeps each bid with its customer, bid/no-bid decision and tender pack, which you can review with Bidsights AI, plus tasks with owners and due dates, and the contract that follows a win.