*
It is currently Tue Oct 14, 2025 1:15 pm

All times are UTC - 6 hours




Post new topic Reply to topic  [ 11 posts ]  Go to page 1, 2  Next
Author Message
 Post subject: xlsx spreadsheet
PostPosted: Mon Aug 24, 2009 5:55 pm 
Offline
User avatar

Joined: Sat Jul 18, 2009 1:40 pm
Posts: 749
I've got an xlsx spreadsheet that makes it easy (for me) to track drinks. If someone could host it for me or tell me about an easy hosting solution I could post it up for newbies or anyone who wants one. I'm sure I could convert it to xls too.


Image

Here it is: http://www.tsmnet.net/spreadsheet/

_________________
Graph Of My Units Over 182 Days

Weeks 0-26: 80, 65, 97, 90, 80, 101, 104, 83, 83, 88, 91, 83, 100, 39, 32, 71, 51, 34, 4.5, 0, 5, 3, 6, 11, 0, 0, 0u

I'll always naltreksonipillerin advance

---Lo0p (resident geek :roll: )


Last edited by Lo0p on Mon Aug 24, 2009 9:02 pm, edited 4 times in total.

Top
 Profile E-mail  
 
 Post subject: Re: xlsx spreadsheet
PostPosted: Mon Aug 24, 2009 7:06 pm 
Offline
User avatar

Joined: Thu Feb 05, 2009 12:54 pm
Posts: 536
Location: Oregon, USA
Probably the easiest thing to do would be to import your spreadsheet into a Google Docs spreadsheet, then use the sharing option to get a link to post up here.

Q

_________________
Started TSM: February 2009 Cured: August 2009

Restart TSM: July 2012 (65 units/week)

Weekly Progress:
Units: 45, 41, 44, 53, 42, 45, 41, 42, 40, 48, 39, 27, 12, 30, 45, 35, 45, 50, 48, 50, 35, 46, 44, 56, 52, 45


Top
 Profile E-mail  
 
 Post subject: Re: xlsx spreadsheet
PostPosted: Mon Aug 24, 2009 7:26 pm 
Offline
User avatar

Joined: Sat Jul 18, 2009 1:40 pm
Posts: 749
PlainVanilla is gonna put it up on tsmnet.net I think. Thanks!

_________________
Graph Of My Units Over 182 Days

Weeks 0-26: 80, 65, 97, 90, 80, 101, 104, 83, 83, 88, 91, 83, 100, 39, 32, 71, 51, 34, 4.5, 0, 5, 3, 6, 11, 0, 0, 0u

I'll always naltreksonipillerin advance

---Lo0p (resident geek :roll: )


Top
 Profile E-mail  
 
 Post subject: Re: xlsx spreadsheet
PostPosted: Mon Aug 24, 2009 7:34 pm 
Offline
User avatar

Joined: Mon Jun 29, 2009 9:23 am
Posts: 261
Location: Oregon, USA
Hopefully this will work: http://www.tsmnet.net/spreadsheet/

_________________
The Sinclair Method worked for me - week by week, month by month.
One step to sobriety; my higher power was science.


Top
 Profile E-mail  
 
 Post subject: Re: xlsx spreadsheet
PostPosted: Mon Aug 24, 2009 7:41 pm 
Offline
User avatar

Joined: Sat Jul 18, 2009 1:40 pm
Posts: 749
It works but I gave you the wrong version for the xls one :(

edit: I don't know maybe it just loses all that functionality in an excel 97-2003 format. Unless I'm exporting it incorrectly.

_________________
Graph Of My Units Over 182 Days

Weeks 0-26: 80, 65, 97, 90, 80, 101, 104, 83, 83, 88, 91, 83, 100, 39, 32, 71, 51, 34, 4.5, 0, 5, 3, 6, 11, 0, 0, 0u

I'll always naltreksonipillerin advance

---Lo0p (resident geek :roll: )


Top
 Profile E-mail  
 
 Post subject: Re: xlsx spreadsheet
PostPosted: Mon Aug 24, 2009 7:57 pm 
Offline
User avatar

Joined: Mon Jun 29, 2009 9:23 am
Posts: 261
Location: Oregon, USA
I have a Mac version of Excel so I'm afraid to open and resave it. If you find you have the wrong version for reals, feel free to resend.

~Q~'s idea about Google Docs is an excellent one too.

_________________
The Sinclair Method worked for me - week by week, month by month.
One step to sobriety; my higher power was science.


Top
 Profile E-mail  
 
 Post subject: Re: xlsx spreadsheet
PostPosted: Mon Aug 24, 2009 8:22 pm 
Offline
User avatar

Joined: Sat Jul 18, 2009 1:40 pm
Posts: 749
I just sent you the right one via email. Thx!

_________________
Graph Of My Units Over 182 Days

Weeks 0-26: 80, 65, 97, 90, 80, 101, 104, 83, 83, 88, 91, 83, 100, 39, 32, 71, 51, 34, 4.5, 0, 5, 3, 6, 11, 0, 0, 0u

I'll always naltreksonipillerin advance

---Lo0p (resident geek :roll: )


Top
 Profile E-mail  
 
 Post subject: Re: xlsx spreadsheet
PostPosted: Mon Aug 24, 2009 8:56 pm 
Offline
User avatar

Joined: Mon Jun 29, 2009 9:23 am
Posts: 261
Location: Oregon, USA
Replaced.

_________________
The Sinclair Method worked for me - week by week, month by month.
One step to sobriety; my higher power was science.


Top
 Profile E-mail  
 
 Post subject: Re: xlsx spreadsheet
PostPosted: Sun Aug 30, 2009 4:06 pm 
Offline
User avatar

Joined: Fri Jun 19, 2009 8:43 am
Posts: 73
Location: Connecticut
What a fantastically designed spreadsheet! I wish I had that grasp of Excel; I just know the basics.

The spreadsheet says "read only" but by randomly changing numbers, inserting cells, columns, lines, it seems it is modifiable although I have not yet saved it to my local machine (I have MS Office Excel 2003) on an XP Pro SP2 desktop. Unfortunately, I have not kept track of my units (lazy about that kind of stuff) since I began tsm on June 11, but things do seem to improving. I'm definitely getting to like the stuff less and starting the wine later in the evening. But not over the hump yet. It would probably be a good idea to start graphing now, even if it's not from the beginning. I have to figure how to move some of the stuff around and how the graphs are constructed in order to personalize it. Excel is an extremely powerful tool that, not being a mathematician (although I do know what exponential moving averages and trend lines are, etc.,) tends to overwhelm as well as impress me! Being of a curious (very much so) nature, I'm going to try to reverse engineer this to see if I can understand what's under the hood. (Don't worry I won't break anything, try to upload anything to the site, and any tinkering I do will be saved only to my own machine.)

Truly impressive--and a fantastic tool for demonstrating the efficacy of tsm!

Mike


Top
 Profile E-mail  
 
 Post subject: Re: xlsx spreadsheet
PostPosted: Sun Aug 30, 2009 4:22 pm 
Offline
User avatar

Joined: Sat Jul 18, 2009 1:40 pm
Posts: 749
Thanks! Put your start date in cell A2 and the rest of the dates will update. Then click on your line in the line chart and drag the box around your actual data on the left to update your chart.

_________________
Graph Of My Units Over 182 Days

Weeks 0-26: 80, 65, 97, 90, 80, 101, 104, 83, 83, 88, 91, 83, 100, 39, 32, 71, 51, 34, 4.5, 0, 5, 3, 6, 11, 0, 0, 0u

I'll always naltreksonipillerin advance

---Lo0p (resident geek :roll: )


Top
 Profile E-mail  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 11 posts ]  Go to page 1, 2  Next

All times are UTC - 6 hours


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
Jump to:  
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group