click here for a list of all existing Templot documentation
  Important Privacy Information cookie information pre-print options:    

 click image to open Templot Club in a new tab             Search           remove page highlighting
Templot club top logo
    looking for help? -                         enjoy using Templot? -
looking for Templot? - (free)



 you are not logged in  - Login | Join


receive all messages by email: info


Recent Topics
Front Page  Search  Image Gallery  Gallery Upload  My Account  Members  Open Source  TemplotMEC  Help  
make a donation  
please click: important information for new members and first-time visitors Templot Companion - User Guide
            messages archive on Yahoo
page trail:  Templot Club > Forums > I wish it would... > Spreadsheets.
Templot web site

                 Spreadsheets.
     
 Start new topic   Reply blank   Printer friendly 
  Rate this topic  
AuthorMessage
 Clicked a link? Wrong message? Wait until the page has finished loading, click in the address bar and then press the Enter key. This is a timing bug in some browsers.
1st message | this message only posted: 28 Oct 2014 11:49
 PM  Reply with quote  Reply blank 
from:
Tony W
North Notts., United Kingdom

 

view images in gallery
view images as slides
Hello Martin.
Is there a reason why .xls spreadsheet files are not one of the permitted file types that can be attached to a forum posting?
Regards
Tony W.

__________
message ref: 17540

 
 Clicked a link? Wrong message? Wait until the page has finished loading, click in the address bar and then press the Enter key. This is a timing bug in some browsers.
2nd message | this message only posted: 28 Oct 2014 12:03
 PM  Reply with quote  Reply blank 
from:
Martin Wynne
West Of The Severn, United Kingdom



view images in gallery
view images as slides

Please do not send requests for help direct to me via email or PM.

Post your questions on the forum where everyone can see them and add helpful replies.
Tony W wrote: Is there a reason why .xls spreadsheet files are not one of the permitted file types that can be attached to a forum posting?Hi Tony,

They are now. :)

But please note that not everyone has the means to open them -- me included. :(

It would be much better to export them from Excel in a format which everyone can access such as PDF.

Or if you export them as CSV or HTML you could copy them directly into your message. :)

regards,

Martin.

__________
message ref: 17541

 
 Clicked a link? Wrong message? Wait until the page has finished loading, click in the address bar and then press the Enter key. This is a timing bug in some browsers.
3rd message | this message only posted: 28 Oct 2014 12:48
 PM  Reply with quote  Reply blank 
from:
Tony W
North Notts., United Kingdom

 

view images in gallery
view images as slides
Hi Martin.
I realise that not everyone can use spreadsheets whether they be Excel format or otherwise and they are normally written for a particular operating system. However I have a small spreadsheet, which I wanted to post for those who may find it useful and found I could not post it last night. For a given Radius curve, Chord and Versine, if you know two of them it will calculate the third. It is very easy to use. I will try again later.
Regards
Tony.

__________
message ref: 17542

 
 Clicked a link? Wrong message? Wait until the page has finished loading, click in the address bar and then press the Enter key. This is a timing bug in some browsers.
4th message | this message only posted: 28 Oct 2014 13:03
 PM  Reply with quote  Reply blank 
from:
Martin Wynne
West Of The Severn, United Kingdom



view images in gallery
view images as slides

Please do not send requests for help direct to me via email or PM.

Post your questions on the forum where everyone can see them and add helpful replies.
Hi Tony,

XLS spreadsheet files can now be attached here.

However, calculating versines can be done directly in Templot: :)



The dummy vehicle clearance mouse action can be used to measure the centre axle side-play needed on 6-wheel vehicles at different radii.

1. set the control template to the desired radius.

2. set the body length to match the wheelbase (dimensions... button).

3. set the body width to match the track gauge.

The clearance marker can then be adjusted by mouse action to align with the outer rail. Read the versine dimension as the clearance showing (in prototype inches):





regards,

Martin.

__________
message ref: 17543

 
 Clicked a link? Wrong message? Wait until the page has finished loading, click in the address bar and then press the Enter key. This is a timing bug in some browsers.
5th message | this message only posted: 4 Nov 2014 19:13
 PM  Reply with quote  Reply blank 
from:
Tony W
North Notts., United Kingdom

 

view images in gallery
view images as slides
Hi Martin.
I now have a bit of time to follow up on this thread. First let me say that your dummy vehicle tool is a brilliant concept and I have found it very useful for checking clearances and I fully accept that it can be used for measuring versines and end throw for any pre-defined vehicle / wheelbase size / combination. The graphical interface makes it very appealing for anyone regardless of their technical abilities and is doubtless why you chose this approach.
My little speadsheet is intended for general use and not just with model railways.  For instance, it can be used in different ways and not just for calculating versines, if you have a curve of unknown radius, you can mark a chord and measure the versine. It will calculate the radius of that curve. I will post it as a separate topic rather than add it to the end of this where it is less obvious.

Thanks
Tony.

__________
message ref: 17620

 
This is topic ID = 2564     Page created at 22:08 (local time)  
You can type a quick reply to this topic here.

Click in the box to begin.


But to reply to an individual message, or to include images, attachments and formatted text, use the reply buttons on each message above.

To start a new topic in this forum, click the Start new topic button below.
To start a new topic in a different forum, click the Forum Jump drop-down list below.

             Start new topic 

 click to jump to a different forum:     Back to top of page

about Templot Club

list recently active topics Templot Companion - User Guide - A-Z Index Templot Explained for beginners Please click: important information for new members and first-time visitors.
indexing link for search engines

back to top of page


Please read this important note about copyright: Unless stated otherwise, all the files submitted to this web site are copyright and the property of the respective contributor. You are welcome to use them for your own personal non-commercial purposes, and in your messages on this web site. If you want to publish any of this material elsewhere or use it commercially, you must first obtain the owner's permission to do so.

The small print: All material submitted to this web site is the responsibility of the respective contributor. By submitting material to this web site you acknowledge that you accept full responsibility for the material submitted. The owner of this web site is not responsible for any content displayed here other than his own contributions. The owner of this web site may edit, modify or remove any content at any time without giving notice or reason.
Problems with this web site? Contact webmaster@templot.com.   This web site uses cookies: click for information.  
© 2019  

Powered by UltraBB - © 2009 Data 1 Systems