Q&A Forum
Hi , opening up CSV files in Microsoft Excel to show raw data captured is great feature but the information displayed is a bit hard to read and not very presentable to customer's.
Is it possible to format the
displayed raw data and like in
my case I'm using the yourdyno
as a engine dyno setup not as
a road/hub dyno arrangment.
The Excel spread file shows
both engine HP/Torque and Wheel HP/Wheel Torque.
1 - I only need HP/Torque to be printed.
2 - The number of digits after the decimal point is way to much in total 18 digits. This needs to be less .
3 - Also the legend title needs to be formatted with HP - Torque - RPM , showing them first then followed by other relevant data captured.
Or is this just on my PC how it is displayed?
upload my picture of one of my examples Microsoft Excel Comma Separated Value files ( CSV).
I'm no expert in Microsoft Excel? So be gentle on criticising my pc proess!!!
Sorry double post "DELETED"
Hi,
You need to specify ";" as the value separator. Then the file displays all values in columns and you can modify as you want with decimal points, etc.
You can specify this in Windows options, but the easiest is to just rename the file to something else than .csv, for example .yourdyno. When opening that file in Excel you are prompted what the separator is. Just choose semicolon.
Unfortunately comma and period are used interchangeably around the world as the decimal point, so we cannot use comma as the value separator, therefore the semicolon.
Cheers,
Jostein
Hi Jostein, thank you for a quick reply , you exaple spread sheet shows also two horsepowers and two torques. Is there a automatic method to switch off the last two columns Wheel HP/Wheel Torque so they are not printed as my setup is a engine dyno? Don't require wheel hp/tq as it is meaningless.
So switch that off once amd forget about it. Sorry I can be at times convoluted with a specific question and explanation?
Sorry for my poor picture quality I posted it was taken live with my mobile telephone and posted from my phone also.
Hi, you mean remove the columns in Excel? That's very easy, just select the full column and Ctrl-minus (or right-click and use the menu). Note you will not be able to read this file back into YourDyno if you do this modification.
Hi Jostein, thank for the information, ok just did a crash course on How to import CSV files into Microsoft Excel and replace comma separated values with semicolon display.
May help others that need this feature here is the process i followed.
1 - Open new Microsoft Excel window
2 - on the top menu tool bar to import the CSV file by clicking " Data " box.
3 - Then go to the 2nd top menu tool bar and on the left hand side select "From Text ".
4 - A new window will open up and select the CSV file you want to open and convert to Semicolon then click Import.
5 - A new dialog box will open up called " Text Import Wizard" . Text Import Wizard step 1 of 3 , make sure the "Delimited " box is clicked , then click next.
6 - Text Import Wizard step 2 of 3 will open up , select " Semicolon " , unselect the " Tab " box and then click " Next ".
7 - Text Import Wizard step 3 of 3 will open select " Finish ".
8 - New window menu pops_up select "OK" and first stage is done.
At least it is readable now but way to many lines of data for one second run you have one hundred lines of engine dyno raw data logged so for a six to ten seconds dyno run thats a fare bit of data to printout. A lot of paper wasted and from 0.01 seconds to 1.00 seconds that's 100 lines.
I think every 200 RPM increments needs to be printed from RPM start point to RPM finished point dyno run. If one is going to present this as a printout to a client.
Im not very good with Microsoft Excel so this is going to be trick for me to customize the test result the way i would like it.
I haven't yet done the decimal point the number of digits to display in the spreadsheet . My idea is only one digit number is sufficient after the decimal point for a test report.
Also the fact my yourdyno is being setup for a engine dynamometer application i don't need the " Wheel HP and Wheel Torque " displayed in printed report must delete this.
I haven't either consider business header/logo details plus a " www.yourdyno.com " ad also and other report details to be presentable.
Hi,
Thanks for the procedure, that's useful!
As for your other points; the .csv format is the native format that YourDyno stores the files, so it needs all the data. The system needed a format in any case, and I chose one that could imported in excel. The point was not to make pretty reports out of it, but more in case anyone wants to do data investigation, you can delete portions, make other graphs, etc. The data to present to the customer is normally the plot.
That said, you can relatively easily, with some excel tricks, get what you want. Here are some things to try:
- Change decimal numbers by selecting a column (or many columns) and press the "Decrease decimal" icon which is in the Number icon group on the Home menu
- Delete columns by selecting it and pressing Ctrl-Minus
- The data consolidation is more tricky. You can create a new column (Ctrl-plus) and use the "floor" function on the RPM/200 (if you want every 200 rpm to show), then use Remove duplicates. The you are left with the first line of every 200 RPM. If you want to round the RPM of those lines to the nearest 200 you use =floor(RPM/200)*200. See attached the result.
- Excel supports pictures/logos. Just copy it in where you want.
Again, making presentable reports was not what I had in mind when I made the format compatible with Excel, but Excel is a very powerful tool, you can do almost anything you want with data there.
A very useful feature is to delete rows if for example the start or the end of the run contains some effects you want to remove. Just remove the first second for example is very easy. It can also be done in a text editor like Notepad.
Cheers,
Jostein
Hi Jostein , I know what you are saying also, for analytical work the full power data log is great capturing data at 0.02 seconds but if a customer wants a printout in text form that's a lot of paper so to make the information more legible and precise to the point to be printed out one sheet of paper, that's all a customer wants to see plus a graph run too.
I chose 200 RPM as arbitrary number again it's a little like scaling the information to a format as I don't have any raw engine dyno power results of my own.
That attached example you post is good and all on one sheet of paper. I can imagine you are being bombarded by people with many questions and I for one have many more. SORRY!
Microsoft Excel has a lot of features one can play around with the list is endless, Microsoft Excel is just another program i have to learn now, deleting and moving columns of information around isn't that hard once one familiarise one self with the Microsoft Excel functions and icons it is just time consuming for a beginner user.
The tricky part is the Envir Sensors cells crossover all the columns so mucks up the delete process but I will custom structure the semicolon excel spreadsheet to suit my needs eventually.