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

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

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

Using django-mptt to get only the categories that have items -

-
sample structure: all uppercase: category mixed case: item root ├── books │   ├── fiction │   │   └── classics │   └── non-fiction ├── clothing └── electronics ├── laptops ├── phones │   ├── apple │   │   ├── iphone 6 │   │   ├── iphone 6 plus │   │   ├── iphone 6s │   │   └── iphone 6s plus │   ├── motorola │   │   ├── moto g4 │   │   ├── moto g4 play │   │   ├── moto g4 plus │   │   └── moto x │   └── samsung └── tablets └── apple i'm trying have index page show "electronics" category. "clothing" category shouldn't show since it's empty , "books" category shouldn't show either since, although has child categories, child categories don't have items. similarly, "electronics" page should show "phones" category. "laptops" category shouldn't show since it's empty , "tablets" category shouldn't show either since...
Read more