{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Boolean","Boolean (an)"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Boolean","index":0,"n_rows":33,"n_cols":10,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
["BOOLEAN Logic:",null,null,"Date","Units","Product",null,"Year/Product","P1","P2"]
["TRUE = 1",null,null,"2010-07-10",74002,"P2",null,2010]
["FALSE = 0",null,null,"2010-07-10",67655,"P1",null,2011]
["AND = *",null,null,"2010-08-10",56053,"P2"]
["OR = +",null,null,"2010-08-10",68535,"P1",null,null," =SUMPRODUCT(--(YEAR($D$2:$D$19)=$D23),--($F$2:$F$19=E$22),$E$2:$E$19)"]
["If the calculation result is non-zero, the answer is TRUE",null,null,"2010-09-10",62429,"P2",null,null," --({TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;FALSE;FALSE;FALSE;FALSE;FALSE;FALSE}),--({FALSE;TRUE;FALSE;TRUE;FALSE;TRUE;FALSE;TRUE;FALSE;TRUE;FALSE;TRUE;FALSE;TRUE;FALSE;TRUE;FALSE;TRUE}),{74002;67655;56053;68535;62429;66272;72335;56837;57975;69091;86382;61401;82987;53824;54733;51948;79291;62134}"]
["If the calculation result = 0, the answer is FALSE",null,null,"2010-09-10",66272,"P1",null,null," {1;1;1;1;1;1;1;1;1;1;1;1;0;0;0;0;0;0},{0;1;0;1;0;1;0;1;0;1;0;1;0;1;0;1;0;1},{74002;67655;56053;68535;62429;66272;72335;56837;57975;69091;86382;61401;82987;53824;54733;51948;79291;62134}"]
[null,null,null,"2010-10-10",72335,"P2",null,null," {1;1;1;1;1;1;1;1;1;1;1;1;0;0;0;0;0;0}*{0;1;0;1;0;1;0;1;0;1;0;1;0;1;0;1;0;1}*{74002;67655;56053;68535;62429;66272;72335;56837;57975;69091;86382;61401;82987;53824;54733;51948;79291;62134}"]
["AND BOOLEAN logic","OR BOOLEAN logic",null,"2010-10-10",56837,"P1",null,null," {0;1;0;1;0;1;0;1;0;1;0;1;0;0;0;0;0;0}*{74002;67655;56053;68535;62429;66272;72335;56837;57975;69091;86382;61401;82987;53824;54733;51948;79291;62134}"]
[{"$f":"A19&\"*\"&B19&\" = \"&A15&\"*\"&B15&\" = \"&A15*B15&\" = \"&IF((A15=1)*(B15=1)=1,\"TRUE\",\"FALSE\")","v":"TRUE*TRUE = 1*1 = 1 = TRUE"},{"$f":"A19&\"+\"&B19&\" = \"&A15&\"+\"&B15&\"= \"&A15+B15&\" = \"&(A15=1)+(B15=1)&\" = \"&IF((A15=1)+(B15=1)<>0,\"TRUE\",\"FALSE\")","v":"TRUE+TRUE = 1+1= 2 = 2 = TRUE"},null,"2010-11-10",57975,"P2",null,null," {0;1;0;1;0;1;0;1;0;1;0;1;0;0;0;0;0;0}*{74002;67655;56053;68535;62429;66272;72335;56837;57975;69091;86382;61401;82987;53824;54733;51948;79291;62134}"]
[{"$f":"A20&\"*\"&B20&\" = \"&A16&\"*\"&B16&\" = \"&A16*B16&\" = \"&IF((A16=1)*(B16=1)=1,\"TRUE\",\"FALSE\")","v":"TRUE*FALSE = 1*0 = 0 = FALSE"},{"$f":"A20&\"+\"&B20&\" = \"&A16&\"+\"&B16&\"= \"&A16+B16&\" = \"&(A16=1)+(B16=1)&\" = \"&IF((A16=1)+(B16=1)<>0,\"TRUE\",\"FALSE\")","v":"TRUE+FALSE = 1+0= 1 = 1 = TRUE"},null,"2010-11-10",69091,"P1",null,null,"{0;67655;0;68535;0;66272;0;56837;0;69091;0;61401;0;0;0;0;0;0}"]
[{"$f":"A21&\"*\"&B21&\" = \"&A17&\"*\"&B17&\" = \"&A17*B17&\" = \"&IF((A17=1)*(B17=1)=1,\"TRUE\",\"FALSE\")","v":"FALSE*TRUE = 0*1 = 0 = FALSE"},{"$f":"A21&\"+\"&B21&\" = \"&A17&\"+\"&B17&\"= \"&A17+B17&\" = \"&(A17=1)+(B17=1)&\" = \"&IF((A17=1)+(B17=1)<>0,\"TRUE\",\"FALSE\")","v":"FALSE+TRUE = 0+1= 1 = 1 = TRUE"},null,"2010-12-10",86382,"P2"]
[{"$f":"A22&\"*\"&B22&\" = \"&A18&\"*\"&B18&\" = \"&A18*B18&\" = \"&IF((A18=1)*(B18=1)=1,\"TRUE\",\"FALSE\")","v":"FALSE*FALSE = 0*0 = 0 = FALSE"},{"$f":"A22&\"+\"&B22&\" = \"&A18&\"+\"&B18&\"= \"&A18+B18&\" = \"&(A18=1)+(B18=1)&\" = \"&IF((A18=1)+(B18=1)<>0,\"TRUE\",\"FALSE\")","v":"FALSE+FALSE = 0+0= 0 = 0 = FALSE"},null,"2010-12-10",61401,"P1"]
[null,null,null,"2011-01-10",82987,"P2"]
[1,1,null,"2011-01-10",53824,"P1"]
[1,0,null,"2011-02-10",54733,"P2"]
[0,1,null,"2011-02-10",51948,"P1"]
[0,0,null,"2011-03-10",79291,"P2"]
[{"$f":"A15=1","v":true},true,null,"2011-03-10",62134,"P1"]
[true,false]
[false,true,null,"Criteria 1","P1"]
[false,false,null,"Criteria 2",50]
[null,null,null,"Bonus",10]
[]
[null,null,null,"BOOLEAN"]
[null,null,null,"Pro","Sales","AND","OR","AND Bonus","OR Bonus"]
[null,null,null,"P1",17]
[null,null,null,"P2",85]
[null,null,null,"P1",37]
[null,null,null,"P2",41]
[null,null,null,"P1",84]
[null,null,null,"P2",36]
[null,null,null,"P1",12]

{"sheet":"Boolean (an)","index":1,"n_rows":33,"n_cols":10,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
["BOOLEAN Logic:",null,null,"Date","Units","Product",null,"Year/Product","P1","P2"]
["TRUE = 1",null,null,"2010-07-10",74002,"P2",null,2010,{"$f":"SUMPRODUCT(--(YEAR($D$2:$D$19)=$H2),--($F$2:$F$19=I$1),$E$2:$E$19)","v":389791},{"$f":"SUMPRODUCT(--(YEAR($D$2:$D$19)=$H2),--($F$2:$F$19=J$1),$E$2:$E$19)","v":409176}]
["FALSE = 0",null,null,"2010-07-10",67655,"P1",null,2011,{"$f":"SUMPRODUCT(--(YEAR($D$2:$D$19)=$H3),--($F$2:$F$19=I$1),$E$2:$E$19)","v":167906},{"$f":"SUMPRODUCT(--(YEAR($D$2:$D$19)=$H3),--($F$2:$F$19=J$1),$E$2:$E$19)","v":217011}]
["AND = *",null,null,"2010-08-10",56053,"P2"]
["OR = +",null,null,"2010-08-10",68535,"P1",null,null," =SUMPRODUCT(--(YEAR($D$2:$D$19)=$D23),--($F$2:$F$19=E$22),$E$2:$E$19)"]
["If the calculation result is non-zero, the answer is TRUE",null,null,"2010-09-10",62429,"P2",null,null," --({TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;TRUE;FALSE;FALSE;FALSE;FALSE;FALSE;FALSE}),--({FALSE;TRUE;FALSE;TRUE;FALSE;TRUE;FALSE;TRUE;FALSE;TRUE;FALSE;TRUE;FALSE;TRUE;FALSE;TRUE;FALSE;TRUE}),{74002;67655;56053;68535;62429;66272;72335;56837;57975;69091;86382;61401;82987;53824;54733;51948;79291;62134}"]
["If the calculation result = 0, the answer is FALSE",null,null,"2010-09-10",66272,"P1",null,null," {1;1;1;1;1;1;1;1;1;1;1;1;0;0;0;0;0;0},{0;1;0;1;0;1;0;1;0;1;0;1;0;1;0;1;0;1},{74002;67655;56053;68535;62429;66272;72335;56837;57975;69091;86382;61401;82987;53824;54733;51948;79291;62134}"]
[null,null,null,"2010-10-10",72335,"P2",null,null," {1;1;1;1;1;1;1;1;1;1;1;1;0;0;0;0;0;0}*{0;1;0;1;0;1;0;1;0;1;0;1;0;1;0;1;0;1}*{74002;67655;56053;68535;62429;66272;72335;56837;57975;69091;86382;61401;82987;53824;54733;51948;79291;62134}"]
["AND BOOLEAN logic","OR BOOLEAN logic",null,"2010-10-10",56837,"P1",null,null," {0;1;0;1;0;1;0;1;0;1;0;1;0;0;0;0;0;0}*{74002;67655;56053;68535;62429;66272;72335;56837;57975;69091;86382;61401;82987;53824;54733;51948;79291;62134}"]
[{"$f":"A19&\"*\"&B19&\" = \"&A15&\"*\"&B15&\" = \"&A15*B15&\" = \"&IF((A15=1)*(B15=1)=1,\"TRUE\",\"FALSE\")","v":"TRUE*TRUE = 1*1 = 1 = TRUE"},{"$f":"A19&\"+\"&B19&\" = \"&A15&\"+\"&B15&\"= \"&A15+B15&\" = \"&(A15=1)+(B15=1)&\" = \"&IF((A15=1)+(B15=1)<>0,\"TRUE\",\"FALSE\")","v":"TRUE+TRUE = 1+1= 2 = 2 = TRUE"},null,"2010-11-10",57975,"P2",null,null," {0;1;0;1;0;1;0;1;0;1;0;1;0;0;0;0;0;0}*{74002;67655;56053;68535;62429;66272;72335;56837;57975;69091;86382;61401;82987;53824;54733;51948;79291;62134}"]
[{"$f":"A20&\"*\"&B20&\" = \"&A16&\"*\"&B16&\" = \"&A16*B16&\" = \"&IF((A16=1)*(B16=1)=1,\"TRUE\",\"FALSE\")","v":"TRUE*FALSE = 1*0 = 0 = FALSE"},{"$f":"A20&\"+\"&B20&\" = \"&A16&\"+\"&B16&\"= \"&A16+B16&\" = \"&(A16=1)+(B16=1)&\" = \"&IF((A16=1)+(B16=1)<>0,\"TRUE\",\"FALSE\")","v":"TRUE+FALSE = 1+0= 1 = 1 = TRUE"},null,"2010-11-10",69091,"P1",null,null,"{0;67655;0;68535;0;66272;0;56837;0;69091;0;61401;0;0;0;0;0;0}"]
[{"$f":"A21&\"*\"&B21&\" = \"&A17&\"*\"&B17&\" = \"&A17*B17&\" = \"&IF((A17=1)*(B17=1)=1,\"TRUE\",\"FALSE\")","v":"FALSE*TRUE = 0*1 = 0 = FALSE"},{"$f":"A21&\"+\"&B21&\" = \"&A17&\"+\"&B17&\"= \"&A17+B17&\" = \"&(A17=1)+(B17=1)&\" = \"&IF((A17=1)+(B17=1)<>0,\"TRUE\",\"FALSE\")","v":"FALSE+TRUE = 0+1= 1 = 1 = TRUE"},null,"2010-12-10",86382,"P2"]
[{"$f":"A22&\"*\"&B22&\" = \"&A18&\"*\"&B18&\" = \"&A18*B18&\" = \"&IF((A18=1)*(B18=1)=1,\"TRUE\",\"FALSE\")","v":"FALSE*FALSE = 0*0 = 0 = FALSE"},{"$f":"A22&\"+\"&B22&\" = \"&A18&\"+\"&B18&\"= \"&A18+B18&\" = \"&(A18=1)+(B18=1)&\" = \"&IF((A18=1)+(B18=1)<>0,\"TRUE\",\"FALSE\")","v":"FALSE+FALSE = 0+0= 0 = 0 = FALSE"},null,"2010-12-10",61401,"P1"]
[null,null,null,"2011-01-10",82987,"P2"]
[1,1,null,"2011-01-10",53824,"P1"]
[1,0,null,"2011-02-10",54733,"P2"]
[0,1,null,"2011-02-10",51948,"P1"]
[0,0,null,"2011-03-10",79291,"P2"]
[{"$f":"A15=1","v":true},true,null,"2011-03-10",62134,"P1"]
[true,false]
[false,true,null,"Criteria 1","P1"]
[false,false,null,"Criteria 2",50]
[null,null,null,"Bonus",10]
[]
[null,null,null,"BOOLEAN"]
[null,null,null,"Pro","Sales","AND","OR","AND Bonus","OR Bonus"]
[null,null,null,"P1",17,{"$f":"($D27=$E$21)*($E27>$E$22)","v":0},{"$f":"($D27=$E$21)+($E27>$E$22)","v":1},{"$f":"($D27=$E$21)*($E27>$E$22)*$E$23","v":0},{"$f":"(($D27=$E$21)+($E27>$E$22)>0)*$E$23","v":10}]
[null,null,null,"P2",85,{"$f":"($D28=$E$21)*($E28>$E$22)","v":0},{"$f":"($D28=$E$21)+($E28>$E$22)","v":1},{"$f":"($D28=$E$21)*($E28>$E$22)*$E$23","v":0},{"$f":"(($D28=$E$21)+($E28>$E$22)>0)*$E$23","v":10}]
[null,null,null,"P1",37,0,1,0,10]
[null,null,null,"P2",41,0,0,0,0]
[null,null,null,"P1",84,1,2,10,10]
[null,null,null,"P2",36,0,0,0,0]
[null,null,null,"P1",12,0,1,0,10]