• Replies 3 replies
  • Subscribers 337 subscribers
  • Views 49 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

    Hi Beth,

     

    After changing the format to Number in excel, you can copy the entire spreadsheet and paste it into a new instance of excel. Then, you should be able to run formulas on the data.

     

    Also, you can try verifying that the edit mas in T_KEYWORD is set to number for your attribute.

     

    Cheers,

    KMK

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Beth Varro
    Sent: Tuesday, April 30, 2013 4:02 PM
    To: Kayleb McKelvain
    Subject: [Tessitura Technical Forum] Output set format issue

     

    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

    Hi Beth,

     

    After changing the format to Number in excel, you can copy the entire spreadsheet and paste it into a new instance of excel. Then, you should be able to run formulas on the data.

     

    Also, you can try verifying that the edit mas in T_KEYWORD is set to number for your attribute.

     

    Cheers,

    KMK

     

    From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Beth Varro
    Sent: Tuesday, April 30, 2013 4:02 PM
    To: Kayleb McKelvain
    Subject: [Tessitura Technical Forum] Output set format issue

     

    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