Veda2.0 Released!


Using TFM_UPD table to project costs
#1
Hi all,
I'm currently trying to produce some cost projections for a large number of technologies (all CCS technologies in my model, which is a version of ETSAP-TIAM). 

In the SubRES files, these technologies have a cost defined for their start year, e.g. INVCOST in 2020, but no further projections.

Due to the large number of technologies I am changing, I would like to be able to do this with a TFM_UPD table. I had a go at creating one, which would slowly reduce the INVCOST of a technology based on my own defined trajectory (see attached file).

However, when syncing this file, I get the warning message 'Info: UPD table row did not generate any records.' The problem is that, while the INVCOST is known for the whole period (as INVCOST is extrapolated by the default method), it's not explicitly defined for each period. I.e. there isn't an INVCOST~2030 that the model can update using the TFM_UPD table. So the TFM_UPD table only applies to 2020 where INVCOST is explicitly defined, rather than any future periods.

Does anyone know a way around this, that will allow me to use TFM_UPD tables to produce cost trajectories? Or will I have to manually specify costs using a TFM_INS table?

All the best,
Neil Grant


Attached Files
.xlsx   TFM_UPD Example.xlsx (Size: 12.99 KB / Downloads: 13)
Reply
#2
This is the precise use case for the TFM_MIG tag. Please see the attached workbook.

you can use this for attribute, timeslice, and limtype dimensions too.


Attached Files
.xlsx   TFM_MIG Example.xlsx (Size: 13.47 KB / Downloads: 39)
Reply
#3
(12-09-2019, 08:11 PM)AKanudia Wrote: This is the precise use case for the TFM_MIG tag. Please see the attached workbook.

you can use this for attribute, timeslice, and limtype dimensions too.

Thanks so much Amit! 

Your prompt and clear replies are so helpful.

Cheers,
Neil
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  Early Retirement Costs Felix 10 11,239 22-06-2022, 06:33 PM
Last Post: Ceas19
  UPD table row did not generate any records [email protected] 5 9,331 11-02-2021, 09:16 PM
Last Post: annagnv
  Info: UPD table row did not generate any records in SysSettings RodrigoCR 1 2,416 24-12-2020, 06:22 AM
Last Post: Antti-L
  Solar lower costs impact capacity constraints LucasD 10 10,013 18-12-2020, 03:04 PM
Last Post: AKanudia
  COMEMI table JozefO 2 3,795 01-12-2020, 06:47 PM
Last Post: JozefO
  PRCCOMEMI table MikkelBosack 7 11,671 27-02-2019, 07:07 PM
Last Post: Vikrant
  Sunken Costs of Trade Processes mresende 2 5,836 03-02-2018, 01:24 AM
Last Post: mresende
  Problem in importing ~COMAGG table saleh 5 12,786 05-12-2017, 11:08 AM
Last Post: Vikrant
  TFM_INS Table is not working Tanzeel 2 7,129 18-08-2017, 04:15 PM
Last Post: Tanzeel
  Ramping costs GustafY 4 9,454 19-05-2017, 03:14 PM
Last Post: GustafY

Forum Jump:


Users browsing this thread: 1 Guest(s)