Joined
·
1,343 Posts
This is the way I post logs when I need help and the way I prefer to view them when I am helping others. Iwill try to walk people through it so that they can get them posted up to google docs correctly as it seems to be a common issue.
Go to docs.google.com you can log in with your email address. If you don’t have one sign up for one. I wont be walking you through setting up an account it is pretty straight forward.
![]()
When you log in you will see something like this.
![]()
Click create on the left that is pointed out with the red arrow. Then you will have a choice of documents you can create. Choose spread sheet for log files. This will create a new tab in chrome with an unsaved ss documents as shown below.
![]()
Now open your log file with excel or whatever ss app you use. Copy and paste all applicable parts into the google apps doc. I have found that this works much more easily if I format the logs in excel to clean out(delete) any worthless driving around, and then just select all with ctrl+a and then copy with ctrl+c and then highlight the 1A cell of the google doc and paste with ctrl+v. Make sure you copy the first line that explains the units we are looking at. There is a limit of 1000 lines that can be copied and pasted into google apps at once. Seen as there is almost no chance that much of a log is relevant, this should not cause an issue. Below is a screen shot of someone’s random log file that I had looked at and was handy pasted into a google doc.
![]()
As you can see there is a warning that the doc is unsaved yet. To save it click File and then click publish to the web. It will ask for a file name. Set this to whatever is reasonable so you can remember what it is in the future. It will then show a publish settings box, check to make sure all sheets is chosen at the top, then you can click close. Now you need to share it so we can all see it. Click the blue share box in the upper right had corner of the window. You will see a box like this:
![]()
Where I put the big red arrow by change… click that to change access rights to the file. Click the box next to the choice for “anyone with the link” As there is no reason to publish it to the web. Leave the checkbox empty for allow anyone to edit. So people can’t fat finger it or monkey with it. Then click save at the bottom. The window will now come up with the file link which looks like this:
![]()
The link should already be highlighted so you can copy it and paste it into your post and we are all set. It is the same link you will have in your url bar when you are viewing the document so if you lose that link somehow you can always just open the document through google docs and copy and paste the url into the forum.
Go to docs.google.com you can log in with your email address. If you don’t have one sign up for one. I wont be walking you through setting up an account it is pretty straight forward.
When you log in you will see something like this.
Click create on the left that is pointed out with the red arrow. Then you will have a choice of documents you can create. Choose spread sheet for log files. This will create a new tab in chrome with an unsaved ss documents as shown below.
Now open your log file with excel or whatever ss app you use. Copy and paste all applicable parts into the google apps doc. I have found that this works much more easily if I format the logs in excel to clean out(delete) any worthless driving around, and then just select all with ctrl+a and then copy with ctrl+c and then highlight the 1A cell of the google doc and paste with ctrl+v. Make sure you copy the first line that explains the units we are looking at. There is a limit of 1000 lines that can be copied and pasted into google apps at once. Seen as there is almost no chance that much of a log is relevant, this should not cause an issue. Below is a screen shot of someone’s random log file that I had looked at and was handy pasted into a google doc.
As you can see there is a warning that the doc is unsaved yet. To save it click File and then click publish to the web. It will ask for a file name. Set this to whatever is reasonable so you can remember what it is in the future. It will then show a publish settings box, check to make sure all sheets is chosen at the top, then you can click close. Now you need to share it so we can all see it. Click the blue share box in the upper right had corner of the window. You will see a box like this:
Where I put the big red arrow by change… click that to change access rights to the file. Click the box next to the choice for “anyone with the link” As there is no reason to publish it to the web. Leave the checkbox empty for allow anyone to edit. So people can’t fat finger it or monkey with it. Then click save at the bottom. The window will now come up with the file link which looks like this:
The link should already be highlighted so you can copy it and paste it into your post and we are all set. It is the same link you will have in your url bar when you are viewing the document so if you lose that link somehow you can always just open the document through google docs and copy and paste the url into the forum.
