• Replies 3 replies
  • Subscribers 337 subscribers
  • Views 47 views
  • Users 0 members are here
Related

Output set format issue

Beth Varro
$organization

Hello, Tessitura geniuses:

I just ran an output set to export an attribute from certain constituents.  This attribute is a number, but when I save it out to excel the column is formatted as a "general" field.  Even if I change the format within excel to be a "number" format, I am not able to run excel formulas on the data. The goal is to be able to run an average on this number; there are 1000 rows, so I can't realistically do it manually.

Any thoughts on how I can get from here to there?  Is there some setting in Tessitura to change?  Or some kind of monkeying in excel that would fix this?

Thanks!
Beth

Parents
  • $organization
    Brilliant!  I knew there must be a workaround I was missing - thank you, Terry!!

    Beth

    * * * * *
    "Tornado Alley will blow you away," said Pioneer Press movie critic Chris Hewitt about the current film in the Science Museum of Minnesota's Omnitheater. Audiences will experience "how thrilling it can be to chase after big storms." Make plans to see Tornado Alley in the Omnitheater and BODY WORLDS & The Cycle of Life in the Science Museum exhibit halls. Reserve your tickets at www.smm.org.

    Elizabeth A Varro
    Membership Manager
    Science Museum of Minnesota
    (651) 265-9829
    From: "Terry Stevens" <bounce-terrystevens8563@tessituranetwork.com>
    To: bvarro@smm.org
    Sent: Tuesday, April 30, 2013 4:12:41 PM
    Subject: Re: [Tessitura Technical Forum] Output set format issue

    Beth,

     

    I have found that I need to save the file from Tessitura to a Tab Delimited, then open in Excel and you can change the format.  If you save it from Tessitura as an Excel file it never lets me change the formats.  Hope this is a quick help.

    From: Beth Varro <bounce-elizabethvarro6946@tessituranetwork.com>
    Sent: 4/30/2013 3:52:45 PM

    Hello, Tessitura geniuses:

    I just ran an output set to export an attribute from certain constituents.  This attribute is a number, but when I save it out to excel the column is formatted as a "general" field.  Even if I change the format within excel to be a "number" format, I am not able to run excel formulas on the data. The goal is to be able to run an average on this number; there are 1000 rows, so I can't realistically do it manually.

    Any thoughts on how I can get from here to there?  Is there some setting in Tessitura to change?  Or some kind of monkeying in excel that would fix this?

    Thanks!
    Beth




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

Reply
  • $organization
    Brilliant!  I knew there must be a workaround I was missing - thank you, Terry!!

    Beth

    * * * * *
    "Tornado Alley will blow you away," said Pioneer Press movie critic Chris Hewitt about the current film in the Science Museum of Minnesota's Omnitheater. Audiences will experience "how thrilling it can be to chase after big storms." Make plans to see Tornado Alley in the Omnitheater and BODY WORLDS & The Cycle of Life in the Science Museum exhibit halls. Reserve your tickets at www.smm.org.

    Elizabeth A Varro
    Membership Manager
    Science Museum of Minnesota
    (651) 265-9829
    From: "Terry Stevens" <bounce-terrystevens8563@tessituranetwork.com>
    To: bvarro@smm.org
    Sent: Tuesday, April 30, 2013 4:12:41 PM
    Subject: Re: [Tessitura Technical Forum] Output set format issue

    Beth,

     

    I have found that I need to save the file from Tessitura to a Tab Delimited, then open in Excel and you can change the format.  If you save it from Tessitura as an Excel file it never lets me change the formats.  Hope this is a quick help.

    From: Beth Varro <bounce-elizabethvarro6946@tessituranetwork.com>
    Sent: 4/30/2013 3:52:45 PM

    Hello, Tessitura geniuses:

    I just ran an output set to export an attribute from certain constituents.  This attribute is a number, but when I save it out to excel the column is formatted as a "general" field.  Even if I change the format within excel to be a "number" format, I am not able to run excel formulas on the data. The goal is to be able to run an average on this number; there are 1000 rows, so I can't realistically do it manually.

    Any thoughts on how I can get from here to there?  Is there some setting in Tessitura to change?  Or some kind of monkeying in excel that would fix this?

    Thanks!
    Beth




    This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!

Children
No Data