google spreadsheet - comparing 65 possible scores with 4225 possible combinations to come up with 4 possible answers -

- 

d28 = blue team score f28 = red team score

a score has 65 possible outcomes (0-16 in .25 increments) so:

0, 0.25, 0.5, 0.75, 1, 1.25, 1.5, 1.75, 2, 2.25, 2.5, 2.75, 3, 3.25, 3.5, 3.75, 4, 4.25, 4.5, 4.75, 5, 5.25, 5.5, 5.75, 6, 6.25, 6.5, 6.75, 7, 7.25, 7.5, 7.75, 8, 8.25, 8.5, 8.75, 9, 9.25, 9.5, 9.75, 10, 10.25, 10.5, 10.75, 11, 11.25, 11.5, 11.75, 12, 12.25, 12.5, 12.75, 13, 13.25, 13.5, 13.75, 14, 14.25, 14.5, 14.75, 15, 15.25, 15.5, 15.75 , 16

what compare every possible combination between blue team score , red team score, , based on combination, formula display 4 possible placeholder texts: "0-2", "2-0", "2-1" , "1-2"

0 being lowest score , 16 being highest score out of 65 possible scores. place holder texts show based on this:

if blue team score between 16 - 12 , red team between 4 - 0, answer "2 - 0"

if red team score between 16 - 12 , blue team between 4 - 0, answer "0 - 2"

if blue team score between 12 - 8 , red team between 8 - 4, answer "2 - 1"

if red team score between 12 - 8 , blue team between 8 - 4, answer "1 - 2"

so mean 4,225 possible combinations 4 placeholder texts between combinations based on above.

this may visually, i've labeled cell "help" need placeholder text show.

https://docs.google.com/spreadsheets/d/1g7ffkbh2ldnrzvrhob3p-afei39cbb2vqc0vgkckgl0/pubhtml?widget=true&headers=false

in example blue team has final score of 5.25 , red team has final score of 5. should display placeholder text "2 - 1".

finally, place holder text background fade between green red based on how far final scores away each other.

example: 

16 vs 8 = "2 - 1" (green background) 12 vs 8 = "2 - 1" (brown, or whatever color produced in fade)  9 vs 8 = "2 - 1" (red background)

based on rules here formula

=if(and(team1>=12,team2<=4),"2-0",if(and(team2>=12,team1<=4),"0-2",if(and(team1>=8,and(team2<=8,team2>=4)),"1-2",if(and(team2>=8,and(team1<=8,team1>=4)),"1-2", "not defined"))))

note if both score 5 there no rule defined. have used named reference more readable

you should able extend fill out more of missing rules


Comments

Post a Comment

Popular posts from this blog

Export Excel workseet into txt file using vba - (text and numbers with formulas) -

-
i new vba have developed code use in excel move text/numbers txt file. issue have 3 functions need go same txt file. when run first function has set fs = createobject("scripting.filesystemobject") set = fs.createtextfile(module1.nys45uploadfilename, true) a.writeline (str) a.close. the other 2 functions had save. set fs = createobject("scripting.filesystemobject") set = fs.savetextfile(module1.nys45uploadfilename, true) a.writeline (str) a.close. the first function go txt file, other 2 error object doesn't support property or method. when changed 3 create last function goes txt file. can not figure out word use in order make other 2 functions follow txt file in order keyed. the entire code follows private sub addrecord_click() on error goto errhandler module1.nys45uploadfilename = application.getsaveasfilename(filefilter:="textfiles (*.txt), *.txt") if module1.nys45uploadfilename = "false" exit sub ...
Read more

wordpress - (T_ENDFOREACH) php error -

-
creating wordpress website , i'm getting following php error: parse error: syntax error, unexpected 'endforeach' (t_endforeach) in /home/soralmedia/public_html/wp-content/themes/soral media/woocommerce/myaccount/my-orders.php on line 98 here's code file: <?php /** * orders * * shows recent orders on account page. * * template can overridden copying yourtheme/woocommerce/myaccount/my-orders.php. * * however, on occasion woocommerce need update template files , (the theme developer). * need copy new files theme maintain compatibility. try this. * little possible, happen. when occurs version of template file will. * bumped , readme list important changes. * * @see http://docs.woothemes.com/document/template-structure/ * @author woothemes * @package woocommerce/templates * @version 2.5.0 */ if ( ! defined( 'abspath' ) ) { exit; } $my_orders_columns = apply_filters( 'woocommerce_my_account_my_orders_columns', array( ...
Read more

delphi - cxGrid : instead of "go to next cell on enter" using "enter" do that with the arrow keys -

-
Image
is there way can achieve cxgrid's functionality "go next cell on enter" using arrow keys on keyboard instead of hitting "enter" ??? right can navigate arrow keys cells move not selected (blue color). if edit cell in column , move cell beneath (with arrow key) , grid jumps other random record in grid,which annoying. is question of settings or must program functionality ? edit : simple temporary table use gather data. has no indexed fields or autoinc field : procedure tform3.cxbutton1click(sender: tobject); begin datamodule2.acrquery2.close; datamodule2.acrquery2.sql.clear; datamodule2.acrquery2.sql.text :='insert temp select company_id,member_id,surname,name members company_id =:a1'; datamodule2.acrquery2.params.parambyname('a1').value :=cxlookupcombobox2.text; datamodule2.acrquery2.execsql; datamodule2.acrquery3.close; datamodule2.acrquery3.sql.clear; datamodule2.acrquery3.sql.text :='update temp set month=:a1,year=:a2'; data...
Read more