Filetype Excel XLSX | Posted on 14 Aug 2022 | 3 years ago
Authentication
digital resources
230x Filetype XLSX File size 2.85 MB Source: www.wisconsin.edu
Quick Inflation Factor Update (QIFU) Worksheet
A B C
1 LOCATION: X
2 PROJECT TITLE: X
3
4 06/2022 Base Date
5 01/2027 Inflation Date (defaults to Bid Date from PBW, can be manually overwritten)
6 1.6134 Inflation Factor (Value)
7 ENR Index'!$EL$202 Inflation Factor (ENR Index Worksheet Cell Reference)
8
9
10 REVISED ESTIMATE
11
12 $ - Construction Cost (Unescalated)
13 $ - Hazardous Materials (Unescalated)
14 $ - Construction Total (Unescalated)
15 $ - 0.0000%Design Contingency
16 $ - 0.0000%Overhead & Profit (OH&P)
17 $ - Total Construction (Unescalated)
18 $ - 1.6134 ENR Inflation Factor and Inflation Budget Estimate
19 $ - Total Construction (Escalated)
20
21
22
23 $ - Construction Budget Total
24
25 #VALUE! Design Fees (Basic)
26 #VALUE! Design Fees (Other)
27 #VALUE! Design Fees Budget Total
28
29 #VALUE! Contingency
30
31 #VALUE! Management Fees
32
33 $ - FF&E: Owner Furnished, Contractor Installed (OFCI)
34 $ - FF&E: Owner Furnished, Owner Installed (OFOI)
35 $ - Furnishings, Fixtures, & Equipment Budget (FF&E) Total
36
37 #VALUE! TOTAL BUDGET
38
39 Notes:
40
41 This worksheet references data from the [PBW] and [PBW_Summary] worksheets. It is intended to provide a quick budget estimate based on updated
42 ENR Building Cost Index values when they are published in subsequent PBW templates. The current budget estimate is based on the Inflation Factor
43 displayed in cells [A6] and [B17]. Assuming no other changes to the PBW content other than ENR Index values, the value in cell [B17] may be
44 overwritten based on the new Inflation Factor contained in subsequent PBW templates. Simply open the newest PBW template and find the current
45 Inflation Factor calculated for the specified Based Date and Bid Date in the [ENR] worksheet, which is located in the cell reference displayed in cell [A7].
46 Enter that new Inflation Factor value in cell [B17] in this workbook, and the new project budget estimate will be calculated and updated to current ENR
47 Index standards.
48
49
50
51
08/14/2022 PBW Quick Inflation Factor Upate (QIDU) 1 of 40
Quick Inflation Factor Update (QIFU) Worksheet
D
1
2
3
4 06/2022
5 12/1899
6 1.6134
7
8
9
10 ORIGINAL ESTIMATE
11
12 $ -
13 $ -
14 $ -
15 $ -
16 $ -
17 $ -
18 $ -
19 $ -
20
21
22
23 $ -
24
25 $ -
26 $ -
27 $ -
28
29 $ -
30
31 $ -
32
33 $ -
34 $ -
35 $ -
36
37 $ -
38
39
40
41
This worksheet references data from the [PBW] and [PBW_Summary] worksheets. It is intended to provide a quick budget estimate based on updated
42
ENR Building Cost Index values when they are published in subsequent PBW templates. The current budget estimate is based on the Inflation Factor
displayed in cells [A6] and [B17]. Assuming no other changes to the PBW content other than ENR Index values, the value in cell [B17] may be
43
overwritten based on the new Inflation Factor contained in subsequent PBW templates. Simply open the newest PBW template and find the current
44
Inflation Factor calculated for the specified Based Date and Bid Date in the [ENR] worksheet, which is located in the cell reference displayed in cell [A7].
45
Enter that new Inflation Factor value in cell [B17] in this workbook, and the new project budget estimate will be calculated and updated to current ENR
46
47
48
49
50
51
08/14/2022 PBW Quick Inflation Factor Upate (QIDU) 2 of 40
Quick Inflation Date Update (QIDU) Worksheet
A B C
1 LOCATION: X
2 PROJECT TITLE: X
3
4 06/2022 Base Date
5 01/2027 Inflation Date (defaults to Bid Date from PBW, can be manually overwritten)
6 1.6134 Inflation Factor (Value)
7 ex'!$EL$202 Inflation Factor (ENR Index Worksheet Cell Reference)
8
9
10 REVISED ESTIMATE
11
12 $ - Construction Cost (Unescalated)
13 $ - Hazardous Materials (Unescalated)
14 $ - Construction Total (Unescalated)
15 $ - 0.0000%Design Contingency
16 $ - 0.0000%Overhead & Profit (OH&P)
17 $ - Total Construction (Unescalated)
18 $ - 1.6134 ENR Inflation Factor and Inflation Budget Estimate
19 $ - Total Construction (Escalated)
20
21
22
23 $ - Construction Budget Total
24
25 #VALUE! Design Fees (Basic)
26 #VALUE! Design Fees (Other)
27 #VALUE! Design Fees Budget Total
28
29 #VALUE! Contingency
30
31 #VALUE! Management Fees
32
33 $ - FF&E: Owner Furnished, Contractor Installed (OFCI)
34 $ - FF&E: Owner Furnished, Owner Installed (OFOI)
35 $ - Furnishings, Fixtures, & Equipment Budget (FF&E) Total
36
37 #VALUE! TOTAL BUDGET
38
39 Notes:
40
41 This worksheet references data from the [PBW] and [PBW_Summary] worksheets. It is intended to provide a quick budget estimate based on updated
42 ENR Building Cost Index values when they are published in subsequent PBW templates. The current budget estimate is based on the Inflation Factor
43 displayed in cells [A6] and [B17]. Changing the Inflation Date value in cell [A5], which defaults to the Projected Bid Date value from the [PBW] worksheet
44 cell [H11], will change the Inflation Factor used in calculating the budget estimate in cells [A6] and [B17]. This methodology assumes no other changes to
45 PBW content values other than the ENR Index values corresponding to the new Inflation Date.
46
47
48
49
50
51
08/14/2022 PBW Quick Inflation Date Upate (QIDU) 3 of 40
Quick Inflation Date Update (QIDU) Worksheet
D
1
2
3
4 06/2022
5 12/1899
6 1.6134
7
8
9
10 ORIGINAL ESTIMATE
11
12 $ -
13 $ -
14 $ -
15 $ -
16 $ -
17 $ -
18 $ -
19 $ -
20
21
22
23 $ -
24
25 $ -
26 $ -
27 $ -
28
29 $ -
30
31 $ -
32
33 $ -
34 $ -
35 $ -
36
37 $ -
38
39
40
41
This worksheet references data from the [PBW] and [PBW_Summary] worksheets. It is intended to provide a quick budget estimate based on updated
42
ENR Building Cost Index values when they are published in subsequent PBW templates. The current budget estimate is based on the Inflation Factor
displayed in cells [A6] and [B17]. Changing the Inflation Date value in cell [A5], which defaults to the Projected Bid Date value from the [PBW] worksheet
43
cell [H11], will change the Inflation Factor used in calculating the budget estimate in cells [A6] and [B17]. This methodology assumes no other changes to
44
45
46
47
48
49
50
51
08/14/2022 PBW Quick Inflation Date Upate (QIDU) 4 of 40
no reviews yet
Please Login to review.
