Would you like to inspect the original subtitles? These are the user uploaded subtitles that are being translated: 1 1 00:00:01,030 --> 00:00:02,640 Here's a full estimating spreadsheet 2 2 00:00:02,640 --> 00:00:05,110 that pulls together everything we've just covered, 3 3 00:00:05,110 --> 00:00:07,523 including productivity and availability. 4 4 00:00:08,480 --> 00:00:10,900 This estimate includes four human resources 5 5 00:00:10,900 --> 00:00:12,830 and some material and services 6 6 00:00:12,830 --> 00:00:15,163 and is broken down into 15 activities. 7 7 00:00:16,530 --> 00:00:18,510 At the top, we've entered the productivity 8 8 00:00:18,510 --> 00:00:21,653 and availability percentage for each human resource. 9 9 00:00:23,220 --> 00:00:26,460 Based on that data and the length of their standard day, 10 10 00:00:26,460 --> 00:00:29,500 the actual duration of each activity is calculated 11 11 00:00:29,500 --> 00:00:32,260 and totaled to give the overall duration 12 12 00:00:32,260 --> 00:00:33,613 of the whole deliverable. 13 13 00:00:35,280 --> 00:00:40,240 At the bottom, the effort total is shown in hours and days, 14 14 00:00:40,240 --> 00:00:41,790 along with the productive time 15 15 00:00:41,790 --> 00:00:44,140 factored by the productivity percentage 16 16 00:00:44,140 --> 00:00:46,773 and the duration time factored by availability. 17 17 00:00:48,180 --> 00:00:50,950 The productive time is the costed time, 18 18 00:00:50,950 --> 00:00:52,990 the amount of time it will really take them, 19 19 00:00:52,990 --> 00:00:54,690 and they will need to be paid for. 20 20 00:00:55,920 --> 00:00:58,020 You can download a copy of this spreadsheet, 21 21 00:00:58,020 --> 00:00:59,460 along with templates for all the other 22 22 00:00:59,460 --> 00:01:01,420 main project management documents, 23 23 00:01:01,420 --> 00:01:02,770 from the downloads section. 2016