Welcome, Guest
Username: Password: Remember me
1. The "search..." box above searches the Docs & Forum Posts. The "Search" tab above just searches the Forum Posts. :side:
Please use these to search for your issue *before* creating a new message topic, as your issue may have been previously solved.
2. Please put your Club # and Club Web Address in your Forum Signature (best) OR in each post to get faster support from us.
Click here to edit your signature at the bottom of the Profile Information tab.
3. Our user and admin docs are available at: support.toastmastersclubs.org/doc "There's a doc for that!" ;)
4. There is an "Opt In" Feature for newly added members. The Opt In document explains the strikethrough member information. Click Here to View the Post
5. When posting a New Topic , please include all relevant details and be specific. When did your issue 1st occur? What operating system, browser, & browser version are you using? Did you refresh your browser cache? Are your cookies enabled? Lastly, a screen shot is often helpful.
6. Please abide by the Terms of Use . We are volunteers contributing our spare time. We are happy to assist you, so long as you are respectful and courteous.
7. We are always looking for new FreeToastHost Ambassadors to join our team and support fellow Toastmasters in their use of the FreeToastHost website system. If you are familiar with the system and have some interest, send a Send Us a Private Message.
  • Page:
  • 1

TOPIC:

how to get spreadsheet based report of roles performed without pending roles 4 months 3 weeks ago #91777

  • haeaton
  • haeaton's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
  • 713.664.6970
  • Posts: 27
  • Thank you received: 1
If I had a spreadsheet report on complted roles with one number per cell, I could create very useful reports.  Since the current spreadsheet report shows ("completed roles / future roles") in the same cell, it is difficult to summarize the data further.  Would you please change the report or create separate reports for completed and future roles?
Club # 1294652
Club name: Houston Galleria Project Management Toastmasters
Club website URL: hgpmt.org
The topic has been locked.

how to get spreadsheet based report of roles performed without pending roles 4 months 3 weeks ago #91778

  • Brian
  • Brian's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 11666
  • Thank you received: 3880
Use the date select in the pull request.

Thank you,

Brian McDonald DTM, PDD D61
FTH Lead Technical Support
member Cataraqui Valley Toastmaster 9560
The topic has been locked.

how to get spreadsheet based report of roles performed without pending roles 4 months 2 weeks ago #91788

  • haeaton
  • haeaton's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
  • 713.664.6970
  • Posts: 27
  • Thank you received: 1
Brian, thank you for your response.

When you say, "Use the date select in the pull request", I think you mean one of the date options.  
To create the report, I use the "head & shoulders" "Meeting Reports Icon"
I select:
Report Type as> "Meeting Role Tally (xlsx)"
Report for: "All"
Select Start Date:  I have used "Current TM Year July/1"  or "Select Start Date".  I think this option is what you mean whey you say, "Use the date select in the pull request".   No date choice seems to change the report format. 
The spreadsheet cells with data content are in the format of: "1/0", 2/0, "1/1".  The legend key says: "Completed roles / future roles".

What I am looking for is cells with a single number so I can apply formulas and pivot tables to to the content.  I would much prefer separate columns for completed role and future roles.  Please help if you can.
Club # 1294652
Club name: Houston Galleria Project Management Toastmasters
Club website URL: hgpmt.org
The topic has been locked.

how to get spreadsheet based report of roles performed without pending roles 4 months 2 weeks ago #91806

  • Brian
  • Brian's Avatar
  • Offline
  • Administrator
  • Administrator
  • Posts: 11666
  • Thank you received: 3880
use the text to columns excel tool to split the column.

If you want the reports changed put in a suggestion.

Thank you,

Brian McDonald DTM, PDD D61
FTH Lead Technical Support
member Cataraqui Valley Toastmaster 9560
The topic has been locked.

how to get spreadsheet based report of roles performed without pending roles 4 months 2 weeks ago #91812

  • haeaton
  • haeaton's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
  • 713.664.6970
  • Posts: 27
  • Thank you received: 1
Brian, Thanks for the excellent suggestion regarding splitting the columns containing two numbers "completed / future roles".  I will give it a try.

I also would like to take your advice on submitting a suggestion, but don't see where. 
Please point me to where to submit our suggestion.

Our purpose on putting separate numbers in separate columns is to more easily use your reports to score our members on their club contributions similar to the Toastmaster DCP program that rates clubs.  If we reward those that have done the most for the club in terms of roles performed, we think we can encourage participation and contribution.  This ability of FTH would encourage even more clubs to make more valuable use of the FTH reports.

We are grateful for your advice.
Club # 1294652
Club name: Houston Galleria Project Management Toastmasters
Club website URL: hgpmt.org
The topic has been locked.

how to get spreadsheet based report of roles performed without pending roles 4 months 2 weeks ago #91814

  • haeaton
  • haeaton's Avatar Topic Author
  • Offline
  • Junior Member
  • Junior Member
  • 713.664.6970
  • Posts: 27
  • Thank you received: 1
I have tried the spreadsheet Data "Text to columns tool" in both Excel and Google sheets.  The tool is very useful, but both spreadsheets require the user to process one column at a time.  Since there are 18 columns in my report, it would takes some time.  

I now see the option to submit suggestions and will do so.
Thanks, again.
Club # 1294652
Club name: Houston Galleria Project Management Toastmasters
Club website URL: hgpmt.org
The topic has been locked.
  • Page:
  • 1
Moderators: Pamrhtaylor3jliumarc33NotLiabledeedubbleyooNSBPhyllis Kirouac
Time to create page: 0.038 seconds
Powered by Kunena Forum