Tuesday, March 19, 2013

yogi_Compute Stats Using Computed Columns For Data For Gambling Data Via Google Form


                                          Google Spreadsheet   Post  #1087
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Mar 19, 2013
user Jody.burgess question by Alvinator :(http://productforums.google.com/forum/?zx=2tcn4vc7qf84#!mydiscussions/docs/fQP-WD8Ejc0)
Hello there, is it possible for you to review my form input calculator?  I would like as well for my form to auto-create formulas as data flows in.  This is a private Casino losses calculator for a friend of mine who is in need of assistance in that field.  The goal is realization of spending.  Anyways, I've thrown in some arbitrary data for the first 5 rows, the TOP row's calculations are different than the rest (as they don't look to the cells above them for the cumulative totals), but 2 through 19 are all just copied down.  I would like the calculations in rows K through S to be copied throughout as data arrives.

Please see the attached link.  Sharing is limited to those with a link and editing is NOT available, please let me know if you will need it turned on...?
https://docs.google.com/spreadsheet/ccc?key=0AoIWja2HbFqpdDA3aVh1WUZfeE5pS2NiN1MwQ2ZiVmc&usp=sharing

Thank you so much in advance, there should really be a better guide posted out there for this.  I'm new to using forms (this is my first one) and that kind of guide would be substantially useful, perhaps after much more learning I would create one.  Anyways thanks again

----------------------------------------------------------------------------------------------------------------------------------
following is a solution to the problem

2 comments:

  1. Amazing thank you so much!! I wish this was better documented so I wouldn't have had to trouble you in the first place, but thank you :)

    ReplyDelete
  2. You Are Very Welcome Alvin ... Now Let us keep Googling.

    Make It A Great One
    Cheers!
    Yogi
    Cloud Computing -- Google Docs Way
    yogi--anand-consulting.blogspot.com

    ReplyDelete