+ Reply to Thread
Results 1 to 2 of 2

Fancy Fat Loss Spreadsheet

  1. #1
    Registered User
    Join Date
    10-28-2008
    Location
    Orange County, CA
    Posts
    5

    Lightbulb Fancy Fat Loss Spreadsheet

    I am trying to create a spreadsheet that tracks our patients fat loss from a first visit throughout their treatment schedule here at our Health/Fitness studio. The desired functionality of this spreadsheet would be:
    • Patient Name
    • Initial Visit weigh-in (Track date)
    • Future visit weigh-ins (Track dates)
    • Total the amount of weight lost by patient.


    The trick is, we'd like to track the dates of each weigh in for each client, but they're going to be different for every client. Some clients weigh in every week... some weigh in once every other month.

    I can't figure out how to associate dates to weigh-ins. I've attached my lame attempt at trying to build this spreadsheet. Any pointers are greatly appreciated!

    Greg Frichette
    Attached Files Attached Files

  2. #2
    Forum Expert Palmetto's Avatar
    Join Date
    04-04-2007
    Location
    South Eastern, USA
    MS-Off Ver
    XP, 2007, 2010
    Posts
    3,978

    Re: Fancy Fat Loss Spreadsheet

    See attached.
    New database table, patient list for data validation drop down and a pivot table to sum weight loss.

    2012 weigh-in chart.xlsx
    Palmetto

    Do you know . . . ?

    You can leave feedback and add to the reputation of all who contributed a helpful response to your solution by clicking the star icon located at the left in one of their post in this thread.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1