search

MarkBaggett / srum-dump

A forensics tool to convert the data in the Windows srum (System Resource Usage Monitor) database to an xlsx spreadsheet.
GNU General Public License v3.0
594 stars 97 forks source link

srum_dump_csv.exe outputs formulas instead of results #18

Closed nrrpinto closed 5 years ago

nrrpinto commented 5 years ago

Hi,

As can be seen in the image below, the output of the CSV(in this case the srumNetworkUsage.csv) is returned with the formulas, not with the result. If one wishes to consume the CSV outside of Excel, will not have the result.

image

MarkBaggett commented 5 years ago

All calculations on field are controlled by the template. The intention of the template is to give you, the analyst, the ability to add and remove or customize fields as you see fit. The template provided does include some calculations such as sum as examples that can be used. Those do assume that you are consuming the data in XLSX. If you are not using the sum function or do not have a tool such as excel that can do additional processing you can remove that column from the template.