How to import and populate Application Cost data?

[Sittipol.Janswang]

Can anyone tell me the instructions to import and populate Application Cost data? Which launchpad and import spec that I can use for this?
I would like to see the graph and information in "Application Cost Dashboard" and "Application Cost Overview" view.
Many thanks in advance for your suggestion.

[JohnM]

I'm told these should work.

An import specification and 2 spreadsheets, one with examples in it, the other blank

[Sittipol.Janswang]

Hi JohnM,

Thanks a lot for your response. It works very well for me.
Another question, how can I consolidate this import spec and spreadsheet into another on that I already have?

[JohnM]

If you open the import spec in a dev tool you'll see it's XML. It's a bit fiddly but you can merge your existing import spec and this spec. Copy the <ns2:WorksheetImportSpec> tags into your existing spec, save it as a new xml file and then zip it up. Upload that to your import

Copy the sheets from the cost Excel workbook into main excel workbook, just make sure the tab names are the same as in the cost Excel one.

It should now import against your spec. Note If you have duplicate worksheet names then make sure you remap the import spec to any worksheet names you change