Spreadsheet: 201208d1355917789-line-showing-todays-date-in-chart-dashboard-charts
Sheet: Totals

 | Forecast (monthly) |  |  | 2013 |  |  |  |  |  |  |  |  |  |  |  | 2014
 | Value (SEK) |  | Summary | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC
 |  | Project Manager
 |  | PD0-DP1
 |  | OPEX Internal | 48000 | 48000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | OPEX External | 213750 | 85500 | 128250 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | DP1-DP2
 |  | OPEX Internal | 40000 | 0 | 40000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | OPEX External | 206625 | 0 | 57000 | 114000 | 35625 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | DP2-DP3
 |  | OPEX Internal | 232000 | 0 | 0 | 0 | 160000 | 72000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | OPEX External | 192000 | 0 | 0 | 0 | 96000 | 96000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | CAPEX Internal | 345000 | 0 | 0 | 0 | 0 | 69000 | 276000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | CAPEX External | 256500 | 0 | 0 | 0 | 0 | 28500 | 228000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | DP3-DP4
 |  | OPEX Internal | 232000 | 0 | 0 | 0 | 0 | 0 | 64000 | 136000 | 32000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | OPEX External | 192000 | 0 | 0 | 0 | 0 | 0 | 0 | 160000 | 32000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | CAPEX Internal | 207000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 138000 | 69000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | CAPEX External | 142500 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 85500 | 57000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | [NAME]
 |  | OPEX Internal | 232000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 32000 | 136000 | 64000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | OPEX External | 192000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 128000 | 64000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | CAPEX Internal | 414000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 207000 | 207000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | CAPEX External | 285000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 114000 | 171000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | DP5-DP6
 |  | OPEX Internal | 40000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 8000 | 32000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | OPEX External | 116000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 80000 | 36000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | EP
 |  | OPEX Internal
 |  | OPEX External
 |  | General costs
 |  | Travel cost
 |  | Events
 |  |  |  | 2013-01-01 00:00:00 | 2013-02-01 00:00:00 | 2013-03-01 00:00:00 | 2013-04-01 00:00:00 | 2013-05-01 00:00:00 | 2013-06-01 00:00:00 | 2013-07-01 00:00:00 | 2013-08-01 00:00:00 | 2013-09-01 00:00:00 | 2013-10-01 00:00:00 | 2013-11-01 00:00:00 | 2013-12-01 00:00:00 | 2014-01-01 00:00:00 | 2014-02-01 00:00:00 | 2014-03-01 00:00:00 | 2014-04-01 00:00:00 | 2014-05-01 00:00:00 | 2014-06-01 00:00:00 | 2014-07-01 00:00:00 | 2014-08-01 00:00:00 | 2014-09-01 00:00:00 | 2014-10-01 00:00:00 | 2014-11-01 00:00:00 | 2014-12-01 00:00:00
 | Forecast | Total OPEX Internal | 824000 | 48000 | 40000 | 0 | 160000 | 72000 | 64000 | 136000 | 64000 | 136000 | 64000 | 8000 | 32000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Total OPEX External | 1112375 | 85500 | 185250 | 114000 | 131625 | 96000 | 0 | 160000 | 32000 | 128000 | 64000 | 0 | 80000 | 36000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Total CAPEX Internal | 966000 | 0 | 0 | 0 | 0 | 69000 | 276000 | 0 | 138000 | 69000 | 207000 | 207000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Total CAPEX External | 684000 | 0 | 40000 | 0 | 160000 | 100500 | 228000 | 0 | 85500 | 57000 | 114000 | 171000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Total Cost | Forecast | 3586375 | 133500 | 225250 | 114000 | 291625 | 265500 | 568000 | 296000 | 319500 | 390000 | 449000 | 386000 | 112000 | 36000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | Accumulated | 133500 | 358750 | 472750 | 764375 | 1029875 | 1597875 | 1893875 | 2213375 | 2603375 | 3052375 | 3438375 | 3550375 | 3586375 | 3586375 | 3586375 | 3586375 | 3586375 | 3586375 | 3586375 | 3586375 | 3586375 | 3586375 | 3586375 | 3586375
 |  |  |  | 2013-01-01 00:00:00 | 2013-02-01 00:00:00 | 2013-03-01 00:00:00 | 2013-04-01 00:00:00 | 2013-05-01 00:00:00 | 2013-06-01 00:00:00 | 2013-07-01 00:00:00 | 2013-08-01 00:00:00 | 2013-09-01 00:00:00 | 2013-10-01 00:00:00 | 2013-11-01 00:00:00 | 2013-12-01 00:00:00 | 2014-01-01 00:00:00 | 2014-02-01 00:00:00 | 2014-03-01 00:00:00 | 2014-04-01 00:00:00 | 2014-05-01 00:00:00 | 2014-06-01 00:00:00 | 2014-07-01 00:00:00 | 2014-08-01 00:00:00 | 2014-09-01 00:00:00 | 2014-10-01 00:00:00 | 2014-11-01 00:00:00 | 2014-12-01 00:00:00
 | Actual | Total OPEX Internal | 320000 | 48000 | 40000 | 0 | 160000 | 72000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Total OPEX External | 637875 | 103500 | 156750 | 114000 | 131625 | 96000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 36000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Total CAPEX Internal | 69000 | 0 | 0 | 0 | 0 | 69000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Total CAPEX External | 28500 | 0 | 0 | 0 | 0 | 28500 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Total Cost | Actual | 1055375 | 151500 | 196750 | 114000 | 291625 | 265500 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 36000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | Accumulated | 151500 | 348250 | 462250 | 753875 | 1019375 | 1019375 | 1019375 | 1019375 | 1019375 | 1019375 | 1019375 | 1019375 | 1055375 | 1055375 | 1055375 | 1055375 | 1055375 | 1055375 | 1055375 | 1055375 | 1055375 | 1055375 | 1055375 | 1055375
 |  |  |  | 2013-01-01 00:00:00 | 2013-02-01 00:00:00 | 2013-03-01 00:00:00 | 2013-04-01 00:00:00 | 2013-05-01 00:00:00 | 2013-06-01 00:00:00 | 2013-07-01 00:00:00 | 2013-08-01 00:00:00 | 2013-09-01 00:00:00 | 2013-10-01 00:00:00 | 2013-11-01 00:00:00 | 2013-12-01 00:00:00 | 2014-01-01 00:00:00 | 2014-02-01 00:00:00 | 2014-03-01 00:00:00 | 2014-04-01 00:00:00 | 2014-05-01 00:00:00 | 2014-06-01 00:00:00 | 2014-07-01 00:00:00 | 2014-08-01 00:00:00 | 2014-09-01 00:00:00 | 2014-10-01 00:00:00 | 2014-11-01 00:00:00 | 2014-12-01 00:00:00
 | Budget & Baseline | Total OPEX Internal | 824000 | 48000 | 40000 | 0 | 160000 | 72000 | 64000 | 136000 | 64000 | 136000 | 64000 | 8000 | 32000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Total OPEX External | 1276250 | 85500 | 185250 | 228000 | 181500 | 96000 | 0 | 160000 | 32000 | 128000 | 64000 | 0 | 80000 | 36000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Total CAPEX Internal | 897000 | 0 | 0 | 0 | 0 | 69000 | 276000 | 0 | 241500 | 103500 | 103500 | 103500 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Total CAPEX External | 541500 | 0 | 0 | 0 | 0 | 28500 | 228000 | 0 | 85500 | 57000 | 57000 | 85500 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | Total Cost | Budget & Baseline | 3538750 | 133500 | 225250 | 228000 | 341500 | 265500 | 568000 | 296000 | 423000 | 424500 | 288500 | 197000 | 112000 | 36000 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  |  | Accumulated | 133500 | 358750 | 586750 | 928250 | 1193750 | 1761750 | 2057750 | 2480750 | 2905250 | 3193750 | 3390750 | 3502750 | 3538750 | 3538750 | 3538750 | 3538750 | 3538750 | 3538750 | 3538750 | 3538750 | 3538750 | 3538750 | 3538750 | 3538750