yogi_Rearrange Data From Columns Into Alternating Rows

Google Spreadsheet   Post  #2096

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Dec-16-2016

question by: mervin 123:

https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/O5FQNx14BwU;context-place=mydiscussions

Alternating Cells

I wanted to know if anyone has an idea how to accomplish something I am trying.  I can figure out how to pull data from one cell to another sheet, but What I want to do is have the data alternate cells in my destination  Does anyone know how to do this?

Basically I want to pull everything from Column A1 through A100, and place it onto a different sheet in Column A1, A3, A5, A7, A9 etc.

Edited

yogi_Rank Entities In Column C Based On Their Performance By Attributes In Fields F E And G

Google Spreadsheet   Post  #2095

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Dec-15-2016

question by: JkBix:

https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/46SbX5K4iIs;context-place=mydiscussions

Determining Rank across 3 variables / Google Sheets and Stats
I have been stumped with this one all day -- hoping someone might help me. I just don't know where to begin

I need to create a weighted ranking system which will assign a ranked value as a percentage.

The first data set is an integer value of anywhere from 0 - Infinity ( just depends on the data at hand) 

Second and third data set are percentage values of 1-100%

 

I have created an example sheet of my data -- you can see what I have in the link below

https://docs.google.com/spreadsheets/d/1ICMErqpGMHbIJUXC_Xmb-igns7VmeKjpWZRynd8Vk3E/edit?usp=sharing

The three data sets of concern are the Treats Eaten, Obedience Score, and Friendliness Score.

Days in training do not matter.

I want to know which dog has the highest ranking based on those scores. The most important value to consider is obedience, the second most important value is most treats eaten, and the third is Friendliness. 

I want to know which dogs have the best combinations of  highest obedience with the highest treats and the highest friendliness 

 Please help! 

Thank you so much!