{"text_format":"1","workbook":"xlsx","n_sheets":20,"sheets":["Operators & T F","Operators & T F (an)","IF","IF (an)","IF(HW)","Payroll Register","Payroll Register (an)","NOT NONE ONLY ALT+O+D","NOT NONE ONLY ALT+O+D (an)","HW ==>","P214-241","P214-241(2nd)","P242-243","P244-257","P257-259","P276-278","P278-280","PO611","Sheet2","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"defined_names":13,"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":"Operators & T F","index":0,"n_rows":19,"n_cols":10,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Description","Operator","Example 1","Resulting value","Example 2","Resulting value","Item 1","Item 2","Item 3","Item 4"]
["equal to"," =",{"$f":"\"=\"&G2&TRIM($B2)&H2","v":"=43=12"},null,"=Rad=rad",null,43,12,"Rad","rad"]
["Not equal to"," <>","=43<>12",null,"=Rad<>rad",null,43,12,"Rad","rad"]
["Greater than","  >","=43>12",null,"=12>43",null,43,12,12,43]
["Less than"," <","=43<12",null,"=12<43",null,43,12,12,43]
["Greater than or equal to"," >=","=43>=42",null,"=43>=42",null,43,42,43,42]
["Less than or equal to"," <=","=43<=42",null,"=43<=42",null,43,42,43,42]
[]
["Text with Operators (Alphabetic). Text is not case-sensitive"]
["Greater than"," >",{"$f":"\"=\"&E10&TRIM($B10)&F10","v":"=Rad>Cool"},null,"Rad","Cool"]
["Less than"," <",{"$f":"\"=\"&E11&TRIM($B11)&F11","v":"=Rad<Cool"},null,"Rad","Cool"]
[]
["Names with Operators"]
[null,null,null,null,"Rad","Cool"]
["Greater than"," >",{"$f":"\"=\"&rad&TRIM($B15)&cool","v":"=43>15"},null,43,15]
[]
["Dates in cells are numbers. Dates in formulas are math expressions (=1/12/1931)"]
["Greater than"," >",{"$f":"\"=\"&E18&TRIM($B18)&F18","v":"=21335>26335"},null,"1958-05-30","1972-02-06"]
["Greater than"," >"," =1/12/1931"]

{"sheet":"Operators & T F (an)","index":1,"n_rows":19,"n_cols":10,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Description","Operator","Example 1","Resulting value","Example 2","Resulting value","Item 1","Item 2","Item 3","Item 4"]
["equal to"," =",{"$f":"\"=\"&G2&TRIM($B2)&H2","v":"=43=12"},{"$f":"G2=H2","v":false},"=Rad=rad",{"$f":"I2=J2","v":true},43,12,"Rad","rad"]
["Not equal to"," <>","=43<>12",{"$f":"G3<>H3","v":true},"=Rad<>rad",{"$f":"I3<>J3","v":false},43,12,"Rad","rad"]
["Greater than","  >","=43>12",{"$f":"G4>H4","v":true},"=12>43",{"$f":"I4>J4","v":false},43,12,12,43]
["Less than"," <","=43<12",{"$f":"G5<H5","v":false},"=12<43",{"$f":"I5<J5","v":true},43,12,12,43]
["Greater than or equal to"," >=","=43>=42",{"$f":"G6>=H6","v":true},"=43>=42",{"$f":"I6>=J6","v":true},43,42,43,42]
["Less than or equal to"," <=","=43<=42",{"$f":"G7<=H7","v":false},"=43<=42",{"$f":"I7<=J7","v":false},43,42,43,42]
[]
["Text with Operators (Alphabetic). Text is not case-sensitive"]
["Greater than"," >",{"$f":"\"=\"&E10&TRIM($B10)&F10","v":"=Rad>Cool"},{"$f":"E10>F10","v":true},"Rad","Cool"]
["Less than"," <",{"$f":"\"=\"&E11&TRIM($B11)&F11","v":"=Rad<Cool"},{"$f":"E11<F11","v":false},"Rad","Cool"]
[]
["Names with Operators"]
[null,null,null,null,"Rad","Cool"]
["Greater than"," >",{"$f":"\"=\"&rad&TRIM($B15)&cool","v":"=43>15"},{"$f":"rad>cool","v":true},43,15]
[]
["Dates in cells are numbers. Dates in formulas are math expressions (=1/12/1931)"]
["Greater than"," >",{"$f":"\"=\"&E18&TRIM($B18)&F18","v":"=21335>26335"},{"$f":"E18>F18","v":false},"1958-05-30","1972-02-06"]
["Greater than"," >"," =1/12/1931",{"$f":"1/12/1931","v":4.3155532539271533E-5}]

{"sheet":"IF","index":2,"n_rows":73,"n_cols":7,"rows_kept":73,"cut":false,"hidden":false,"merged":[]}
["IF function:\nLogical Test that evaluates to TRUE or FALSE,\nWhat to put in cell if TRUE,\nWhat to put in cell if FALSE"]
[]
["TRUE / FALSE (Boolean Logic) examples:"]
["Revenue:",5000,null,"Does DR = CR?","DR","CR"]
["Hurdle to get bonus:",4000,null,null,500,499.99]
["Is Revenue greater than Hurdle?"]
[null,null,null,"Credit Score",2]
["Text","Excel is fun!",null,"Credit Score Hurdle",3]
["ISTEXT",null,null,"Asset Value",125000]
[null,null,null,"Asset Value Hurdle",100000]
["Blank Cell",null,null,"Are Both Hurdles met? AND"]
["Is the cell blank?",null,null,"Is At Least 1 Hurdle met? OR"]
[]
["IF function examples:"]
["Put 1 of 2 numbers in the cell",null,null,"Put a blank or a formula in the cell"]
["Revenue",5000,null,"Date","Withdraw","Deposit","Balance"]
["Bonus Hurdle",6000,null,"Bal For",null,null,500]
["Bonus Amount",500,null,"2008-03-12",20]
["Bonus Expense",null,null,"2008-03-13",null,50]
[null,null,null,"2008-03-14",200]
["Put 1 of 2 Text strings in the cell",null,null,null,null,null,{"$f":"IF(D21=\"\",\"\",G20+F21-E21)","v":""}]
["Revenue",5000]
["Expense",2000,null,"Put a 1 of 2 ranges in a function"]
[null,{"$f":"B22-B23","v":3000},null,"Department","Jan Rev.","Feb Rev.","Mar Rev."]
[null,null,null,"Dept01",16,15,29]
["Put a 1 of 2 formulas in the cell",null,null,"Dept02",39,21,44]
["Revenue",5000,null,"SUM of Rev. by Department","Type Dept:"]
["Expense",6000,null,null,"Dept01"]
[]
[null,null,null,"IF that uses AND function as Logical Test"]
[null,null,null,"Credit Score",2]
[null,null,null,"Credit Score Hurdle",3]
[null,null,null,"Asset Value",125000]
[null,null,null,"Asset Value Hurdle",100000]
[null,null,null,"IF Both hurdles are met we will extend credit:"]
[]
[null,null,null,"IF that uses OR function as Logical Test"]
[null,null,null,"Credit Score",2]
[null,null,null,"Credit Score Hurdle",3]
[null,null,null,"Asset Value",125000]
[null,null,null,"Asset Value Hurdle",100000]
[null,null,null,"IF Both hurdles are met we will extend credit:"]
[]
[null,null,null,"More than 1 IF: It is best to set up mutually exclusive Categories and go from the top to the bottom or bottom to top (However, if categories are mutually exclusive, then if you set the formula up right, you can go in any order. If the categories are not mutually exclusive, you can only go in the direction that the criteria states)."]
[null,null,null,"Upper limit for Balance","% Charge on Bal"]
[null,null,null,0,0.01]
[null,null,null,2500,0.02]
[null,null,null,10000,0.03]
[null,null,null,20000,0.05]
[null,null,null,null,null,null,"Even better is the IF and VLOOKUP together"]
[null,null,null,0,null,null,{"$f":"D51","v":0}]
[null,null,null,1500,null,null,1500]
[null,null,null,2000,null,null,2000]
[null,null,null,2500,null,null,2500]
[null,null,null,2500.5,null,null,2500.5]
[null,null,null,2501,null,null,2501]
[null,null,null,2502,null,null,2502]
[null,null,null,2577,null,null,2577]
[null,null,null,9999,null,null,9999]
[null,null,null,10000,null,null,10000]
[null,null,null,50000,null,null,50000]
[]
[null,null,null,0,{"$f":"IF(AND(D63>=$D$46,D63<$D$47),D63*$E$46,IF(AND(D63>=$D$47,D63<$D$48),D63*$E$47,IF(AND(D63>=$D$48,D63<$D$49),D63*$E$48,IF(D63>=$D$49,D63*$E$49))))","v":0}]
[null,null,null,1500,15]
[null,null,null,2000,20]
[null,null,null,2500,50]
[null,null,null,2500.5,50.01]
[null,null,null,2501,50.02]
[null,null,null,2502,50.04]
[null,null,null,2577,51.54]
[null,null,null,9999,199.98000000000002]
[null,null,null,10000,300]
[null,null,null,50000,2500]

{"sheet":"IF (an)","index":3,"n_rows":73,"n_cols":8,"rows_kept":73,"cut":false,"hidden":false,"merged":[]}
["IF function:\nLogical Test that evaluates to TRUE or FALSE,\nWhat to put in cell if TRUE,\nWhat to put in cell if FALSE"]
[]
["TRUE / FALSE examples:"]
["Revenue:",5000,null,"Does DR = CR?","DR","CR"]
["Hurdle to get bonus:",4000,null,{"$f":"E5=F5","v":false},500,499.99]
["Is Revenue greater than Hurdle?",{"$f":"B4>=B5","v":true}]
[null,null,null,"Credit Score",2]
["Text","Excel is fun!",null,"Credit Score Hurdle",3]
["ISTEXT",{"$f":"ISTEXT(B8)","v":true},null,"Asset Value",125000]
[null,null,null,"Asset Value Hurdle",100000]
["Blank Cell",null,null,"Are Both Hurdles met? AND",{"$f":"AND(E7>=E8,E9>=E10)","v":false}]
["Is the cell blank?",{"$f":"B11=\"\"","v":true},null,"Is At Least 1 Hurdle met? OR",{"$f":"OR(E7>=E8,E9>=E10)","v":true}]
[]
["IF function examples:"]
["Put 1 of 2 numbers in the cell",null,null,"Put a blank or a formula in the cell"]
["Revenue",5000,null,"Date","Withdraw","Deposit","Balance"]
["Bonus Hurcle",6000,null,"Bal For",null,null,500]
["Bonus Amount",500,null,"2008-03-12",20,null,{"$f":"IF(D18=\"\",\"\",G17+F18-E18)","v":480}]
["Bonus Expense",{"$f":"IF(B16>=B17,B18,0)","v":0},null,"2008-03-13",null,50,{"$f":"IF(D19=\"\",\"\",G18+F19-E19)","v":530}]
[null,null,null,"2008-03-14",200,null,{"$f":"IF(D20=\"\",\"\",G19+F20-E20)","v":330}]
["Put 1 of 2 Text strings in the cell",null,null,null,null,null,{"$f":"IF(D21=\"\",\"\",G20+F21-E21)","v":""}]
["Revenue",5000]
["Expense",2000,null,"Put a 1 of 2 ranges in a function"]
[{"$f":"IF(B22>=B23,\"Net Income\",\"Net Loss\")","v":"Net Income"},{"$f":"B22-B23","v":3000},null,"Department","Jan Rev.","Feb Rev.","Mar Rev."]
[null,null,null,"Dept01",16,15,29]
["Put a 1 of 2 formulas in the cell",null,null,"Dept02",39,21,44]
["Revenue",5000,null,"SUM of Rev. by Department","Type Dept:"]
["Expense",6000,null,{"$f":"SUM(IF(E28=\"Dept01\",E25:G25,E26:G26))","v":60},"Dept01"]
[{"$f":"IF(B27>=B28,\"Net Income\",\"Net Loss\")","v":"Net Loss"},{"$f":"IF(B27>=B28,B27-B28,B28-B27)","v":1000}]
[null,null,null,"IF that uses AND function as Logical Test"]
[null,null,null,"Credit Score",2]
[null,null,null,"Credit Score Hurdle",3]
[null,null,null,"Asset Value",125000]
[null,null,null,"Asset Value Hurdle",100000]
[null,null,null,"IF Both hurdles are met we will extend credit:",{"$f":"IF(AND(E31>=E32,E33>=E34),\"Extend Credit\",\"No Credit\")","v":"No Credit"}]
[]
[null,null,null,"IF that uses OR function as Logical Test"]
[null,null,null,"Credit Score",2]
[null,null,null,"Credit Score Hurdle",3]
[null,null,null,"Asset Value",125000]
[null,null,null,"Asset Value Hurdle",100000]
[null,null,null,"IF Both hurdles are met we will extend credit:",{"$f":"IF(OR(E38>=E39,E40>=E41),\"Extend Credit\",\"No Credit\")","v":"Extend Credit"}]
[]
[null,null,null,"More than 1 IF: It is best to set up mutually exclusive Categories and go from the top to the bottom or bottom to top (However, if categories are mutually exclusive, then if you set the formula up right, you can go in any order. If the categories are not mutually exclusive, you can only go in the direction that the criteria states)."]
[null,null,null,"Upper limit for Balance","% Charge on Bal"]
[null,null,null,0,0.01]
[null,null,null,2500,0.02]
[null,null,null,10000,0.03]
[null,null,null,20000,0.05]
[null,null,null,null,null,null,"Even better is the IF and VLOOKUP together"]
[null,null,null,0,{"$f":"IF(D51>=$D$49,D51*$E$49,IF(D51>=$D$48,D51*$E$48,IF(D51>=$D$47,D51*$E$47,IF(D51>=$D$46,D51*$E$46))))","v":0},null,{"$f":"D51","v":0},{"$f":"VLOOKUP(G51,$D$46:$E$49,2)*G51","v":0}]
[null,null,null,1500,{"$f":"IF(D52>=$D$49,D52*$E$49,IF(D52>=$D$48,D52*$E$48,IF(D52>=$D$47,D52*$E$47,IF(D52>=$D$46,D52*$E$46))))","v":15},null,1500,{"$f":"VLOOKUP(G52,$D$46:$E$49,2)*G52","v":15}]
[null,null,null,2000,20,null,2000,20]
[null,null,null,2500,50,null,2500,50]
[null,null,null,2500.5,50.01,null,2500.5,50.01]
[null,null,null,2501,50.02,null,2501,50.02]
[null,null,null,2502,50.04,null,2502,50.04]
[null,null,null,2577,51.54,null,2577,51.54]
[null,null,null,9999,199.98000000000002,null,9999,199.98000000000002]
[null,null,null,10000,300,null,10000,300]
[null,null,null,50000,2500,null,50000,2500]
[]
[null,null,null,0,{"$f":"IF(AND(D63>=$D$46,D63<$D$47),D63*$E$46,IF(AND(D63>=$D$47,D63<$D$48),D63*$E$47,IF(AND(D63>=$D$48,D63<$D$49),D63*$E$48,IF(D63>=$D$49,D63*$E$49))))","v":0}]
[null,null,null,1500,15]
[null,null,null,2000,20]
[null,null,null,2500,50]
[null,null,null,2500.5,50.01]
[null,null,null,2501,50.02]
[null,null,null,2502,50.04]
[null,null,null,2577,51.54]
[null,null,null,9999,199.98000000000002]
[null,null,null,10000,300]
[null,null,null,50000,2500]

{"sheet":"IF(HW)","index":4,"n_rows":99,"n_cols":13,"rows_kept":99,"cut":false,"hidden":false,"merged":[]}
["IF function"]
["Delivers 1 of 2 things to a cell or formula"]
["You can deliver: Words, Numbers, or Formulas to a cell or formula"]
["argument 1","This is a TRUE/FALSE test. The test either evaluates to TRUE, or FALSE"]
["argument 2","What to put in the cell or formula if the test evaluates to TRUE"]
["argument 3","What to put in the cell or formula if the test evaluates to FALSE"]
[null,null,null,null,"Deliver 1 of 2 Numbers to cell "]
[null,null,null,null,"Sales",300]
[null,null,null,null,"Sales Hurdle",250]
[null,null,null,null,"Bonus if Hurdle met",10]
[null,null,null,null,"Bonus if Hurdle not met",0]
[null,null,null,null,"Bonus Amount",{"$f":"IF(F8>=F9,F10,F11)","v":10}," =IF(F8>=F9,F10,F11)"]
[]
[null,null,null,null,"Deliver 1 of 2 possible Text items to the cell"]
[null,null,null,null,"Sales",500]
[null,null,null,null,"Expenses",200]
[null,null,null,null,{"$f":"IF(F15>=F16,\"Net Income\",\"Net Loss\")","v":"Net Income"},{"$f":"F15-F16","v":300}," =IF(F15>=F16,\"Net Income\",\"Net Loss\")"]
[]
[null,null,null,null,"Deliver 1 of 2 possible Formulas to cell"]
[null,null,null,null,"Sales",500]
[null,null,null,null,"Expenses",200]
[null,null,null,null,{"$f":"IF(F20>=F21,\"Net Income\",\"Net Loss\")","v":"Net Income"},{"$f":"IF(F20>=F21,F20-F21,F21-F20)","v":300}," =IF(F20>=F21,F20-F21,F21-F20)"]
[]
[null,null,null,null,"More than one IF ==> Delivering 1 of 3 Text items to the cell"]
[null,null,null,null,"Sales",{"$f":"F20","v":500}]
[null,null,null,null,"Expenses",500]
[null,null,null,null,{"$f":"IF(F25>F26,\"Net Income\",IF(F25=F26,\"Break Even\",\"Net Loss\"))","v":"Break Even"},{"$f":"IF(F25>=F26,F25-F26,F26-F25)","v":0}," =IF(F25>F26,\"Net Income\",IF(F25=F26,\"Break Even\",\"Net Loss\"))"]
[]
[null,null,null,null,"More than one IF (delivering 1 of 7 possible formulas to the cell) ==> Where you actually should use VLOOKUP",null,null,"Days Invoice Overdue","Description","Interest Rate Late Fee","The rule is: set up Mutually Exclusive categories (for both IF and VLOOKUP) and formula creation time and error will be minimized."]
[null,null,null,null,"Invoice Total Due",7123.76,null,{"$f":"L30","v":0},{"$f":"IF(H30=$L$37,\"Over \"&L30,\"Over \"&L30&\" but less than \"&M30)","v":"Over 0 but less than 10"},0,null,0,{"$f":"L31","v":10}]
[null,null,null,null,"Invoice Due Date",{"$f":"F32-INT(RAND()*200)","v":"2008-02-24"},null,{"$f":"L31","v":10},{"$f":"IF(H31=$L$37,\"Over \"&L31,\"Over \"&L31&\" but less than \"&M31)","v":"Over 10 but less than 20"},0.01,null,10,20]
[null,null,null,null,"Today",{"$f":"TODAY()","v":"2008-04-22"},null,20,{"$f":"IF(H32=$L$37,\"Over \"&L32,\"Over \"&L32&\" but less than \"&M32)","v":"Over 20 but less than 30"},0.02,null,20,30]
[null,null,null,null,"Days Invoice Over Due",{"$f":"F32-F31","v":58},null,30,"Over 30 but less than 40",0.03,null,30,40]
[null,null,null,null,"Late Fee",{"$f":"ROUND(IF(F33>=H37,F30*J37,IF(F33>=H36,F30*J36,IF(F33>=H35,F30*J35,IF(F33>=H34,F30*J34,IF(F33>=H33,F30*J33,IF(F33>=H32,F30*J32,IF(F33>=H31,F30*J31,0))))))),2)","v":356.19},null,40,"Over 40 but less than 50",0.04,null,40,50]
[null,null,null,null,null,null,null,50,"Over 50 but less than 90",0.05,null,50,90]
[null,null,null,null,null,null,null,90,"Over 90 but less than 120",0.06,null,90,120]
[null,null,null,null,null,null,null,120,"Over 120",7.0000000000000007E-2,null,120]
["VLOOKUP function"]
["Delivers one thing from a vertical list of things to a cell or formula"]
["You can deliver: Words or Numbers to a cell or formula"]
["argument 1","What value to you want to \"take\" from a cell and go over to the Vertical List and try and find"]
["argument 2","Were is the Vertical List with the first column that is filled with \"lookup\" values and the remaining columns that have values that you want to return to the cell or formula from the same row as the value you found in the first column. (Remember: the first column has to be sorted in ascending order)."]
["argument 3","What column should the VLOOKUP function look in in the Vertical List to find the value to deliver back to the cell or formula? Should it be the 2nd column (2), or 3rd (3), or…? (Remember, the first column in the Vertical List is considered column 1 (1)). "]
["argument 4","In the 1st column, are you looking up an exact match (0), or are you looking for the closet match that is not bigger than the value you are trying to find? (A great analogy is the idea that the VLOOKUP function looks down the first column until it finds a value greater than it and then selects the row above that one from which to return a value. If the first value in the first column is greater than the value you are trying to find, a #N/A error is returned."]
[null,null,null,null,"More than one IF (delivering 1 of 7 possible formulas to the cell) ==> USE VLOOKUP",null,null,"Days Invoice Overdue","Description","Interest Rate Late Fee"]
[null,null,null,null,"Invoice Total Due",7123.76,null,{"$f":"L46","v":0},{"$f":"IF(H46=$L$37,\"Over \"&L46,\"Over \"&L46&\" but less than \"&M46)","v":"Over 0 but less than 10"},0,null,0,{"$f":"L47","v":10}]
[null,null,null,null,"Invoice Due Date",{"$f":"F31","v":"2008-02-24"},null,{"$f":"L47","v":10},{"$f":"IF(H47=$L$37,\"Over \"&L47,\"Over \"&L47&\" but less than \"&M47)","v":"Over 10 but less than 20"},0.01,null,10,20]
[null,null,null,null,"Today",{"$f":"TODAY()","v":"2008-04-22"},null,20,{"$f":"IF(H48=$L$37,\"Over \"&L48,\"Over \"&L48&\" but less than \"&M48)","v":"Over 20 but less than 30"},0.02,null,20,30]
[null,null,null,null,"Days Invoice Over Due",{"$f":"F48-F47","v":58},null,30,"Over 30 but less than 40",0.03,null,30,40]
[null,null,null,null,"Late Fee",{"$f":"ROUND(VLOOKUP(F49,H30:J37,3)*F46,2)","v":356.19},null,40,"Over 40 but less than 50",0.04,null,40,50]
[null,null,null,null,null,null,null,50,"Over 50 but less than 90",0.05,null,50,90]
[null,null,null,null,null,null,null,90,"Over 90 but less than 120",0.06,null,90,120]
[null,null,null,null,null,null,null,120,"Over 120",7.0000000000000007E-2,null,120]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,"More than one IF (delivering 1 of 12 possible formulas to the cell) ==> Where you actually should use VLOOKUP",null,null,"Days Invoice Overdue","Description","Interest Rate Late Fee"]
[null,null,null,null,"Invoice Total Due",7123.76,null,{"$f":"L64","v":0},{"$f":"IF(H64=$L$75,\"Over \"&L64,\"Over \"&L64&\" but less than \"&M64)","v":"Over 0 but less than 10"},0,null,0,{"$f":"L65","v":10}]
[null,null,null,null,"Invoice Due Date",{"$f":"F32-INT(RAND()*400)","v":"2008-02-13"},null,{"$f":"L65","v":10},"Over 10 but less than 20",0.01,null,10,{"$f":"L66","v":20}]
[null,null,null,null,"Today",{"$f":"TODAY()","v":"2008-04-22"},null,20,"Over 20 but less than 30",0.02,null,20,{"$f":"L67","v":30}]
[null,null,null,null,"Days Invoice Over Due",{"$f":"F66-F65","v":69},null,30,"Over 30 but less than 40",0.03,null,30,40]
[null,null,null,null,"Late Fee",{"$f":"IF(F67<H65,J64*F64,IF(F67<H66,F64*J65,IF(F67<H67,F64*J66,IF(F67<H68,F64*J67,IF(F67<H69,F64*J68,IF(F67<H70,F64*J69,IF(F67<H71,F64*J70,0)))))))+IF(AND(F67>=H71,F67<H72),F64*J71,IF(AND(F67>=H72,F67<H73),F64*J72,IF(AND(F67>=H73,F67<H74),F64*J73,IF(AND(F67>=H74,F67<H75),F64*J74,IF(F67>H75,F64*J75)))))","v":356.18800000000005},null,40,"Over 40 but less than 50",0.04,null,40,50]
[null,null,null,null,null,null,null,50,"Over 50 but less than 90",0.05,null,50,90]
[null,null,null,null,null,null,null,90,"Over 90 but less than 120",0.06,null,90,120]
[null,null,null,null,null,null,null,120,"Over 120 but less than 160",7.0000000000000007E-2,null,120,160]
[null,null,null,null,null,null,null,160,"Over 160 but less than 190",0.08,null,160,190]
[null,null,null,null,null,null,null,190,"Over 190 but less than 250",0.09,null,190,250]
[null,null,null,null,null,null,null,250,"Over 250 but less than 365",0.1,null,250,365]
[null,null,null,null,null,null,null,365,"Over 365",0.11,null,365]
[]
[null,null,null,null,"More than one IF (delivering 1 of 7 possible formulas to the cell) ==> USE VLOOKUP",null,null,"Days Invoice Overdue","Description","Interest Rate Late Fee"]
[null,null,null,null,"Invoice Total Due",7123.76,null,{"$f":"L78","v":0},{"$f":"IF(H78=$L$75,\"Over \"&L78,\"Over \"&L78&\" but less than \"&M78)","v":"Over 0 but less than 10"},0,null,0,{"$f":"L79","v":10}]
[null,null,null,null,"Invoice Due Date",{"$f":"F65","v":"2008-02-13"},null,{"$f":"L79","v":10},"Over 10 but less than 20",0.01,null,10,{"$f":"L80","v":20}]
[null,null,null,null,"Today",{"$f":"TODAY()","v":"2008-04-22"},null,20,"Over 20 but less than 30",0.02,null,20,{"$f":"L81","v":30}]
[null,null,null,null,"Days Invoice Over Due",{"$f":"F80-F79","v":69},null,30,"Over 30 but less than 40",0.03,null,30,40]
[null,null,null,null,"Late Fee",{"$f":"ROUND(VLOOKUP(F81,H78:J89,3)*F78,2)","v":356.19},null,40,"Over 40 but less than 50",0.04,null,40,50]
[null,null,null,null,null,null,null,50,"Over 50 but less than 90",0.05,null,50,90]
[null,null,null,null,null,null,null,90,"Over 90 but less than 120",0.06,null,90,120]
[null,null,null,null,null,null,null,120,"Over 120 but less than 160",7.0000000000000007E-2,null,120,160]
[null,null,null,null,null,null,null,160,"Over 160 but less than 190",0.08,null,160,190]
[null,null,null,null,null,null,null,190,"Over 190 but less than 250",0.09,null,190,250]
[null,null,null,null,null,null,null,250,"Over 250 but less than 365",0.1,null,250,365]
[null,null,null,null,null,null,null,365,"Over 365",0.11,null,365]
[]
[]
[]
[null,null,null,null,{"$f":"H93","v":"Product ID"},{"$f":"J93","v":"Price"},null,"Product ID","Description","Price"]
[null,null,null,null,"Product 1",{"$f":"VLOOKUP(E94,H94:J99,3,0)","v":8},null,"Product 1",{"$f":"H94&ROW()","v":"Product 194"},8]
[null,null,null,null,null,null,null,"Product 2","Product 295",24]
[null,null,null,null,null,null,null,"Product 3","Product 396",24]
[null,null,null,null,null,null,null,"Product 4","Product 497",8]
[null,null,null,null,null,null,null,"Product 5","Product 598",10]
[null,null,null,null,null,null,null,"Product 6","Product 699",24]

{"sheet":"Payroll Register","index":5,"n_rows":25,"n_cols":15,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,"Taxable Earnings",null,null,"Deductions"]
["Name","Hours","Wage","Gross","Beg Cumulative","End Cumulative","UnEm",{"$f":"H22","v":"SS"},{"$f":"I22","v":"Medicare"},{"$f":"H2","v":"SS"},{"$f":"I2","v":"Medicare"},{"$f":"J22","v":"Pension"},"Total Ded.","Net Pay","Expense"]
["Employee 1",33,12.55,{"$f":"ROUND(B3*C3,2)","v":414.15},25001.37,{"$f":"SUM(D3:E3)","v":25415.52},null,null,null,{"$f":"ROUND(H3*H$23,2)","v":0},0,{"$f":"ROUND(D3*J$23,2)","v":8.2799999999999994},{"$f":"SUM(J3:L3)","v":8.2799999999999994},{"$f":"D3-M3","v":405.87},{"$f":"D3","v":414.15}]
["Employee 2",30,25,750,36589.74,37339.74,null,null,null,0,0,15,15,735,750]
["Employee 3",38,23,874,115450.01,116324.01,null,null,null,0,0,17.48,17.48,856.52,874]
["Employee 4",40,22,880,5000.0600000000004,5880.06,null,null,null,0,0,17.600000000000001,17.600000000000001,862.4,880]
["Employee 5",32,24,768,6999,7767,null,null,null,0,0,15.36,15.36,752.64,768]
["Employee 6",40,17,680,7000.34,7680.34,null,null,null,0,0,13.6,13.6,666.4,680]
["Employee 7",37,13,481,7001.93,null,null,null,null,0,0,9.6199999999999992,9.6199999999999992,471.38,481]
["Employee 8",39,24.75,965.25,94199.64,null,null,null,null,0,0,19.309999999999999,19.309999999999999,945.94,965.25]
["Employee 9",32,17,544,94200.5,null,null,null,null,0,0,10.88,10.88,533.12,544]
["Employee 10",38,24.19,919.22,94201.13,{"$f":"SUM(D12:E12)","v":95120.35},null,null,null,0,0,18.38,18.38,900.84,919.22]
["Employee 11",33,19,627,95000.49,95627.49,null,null,null,0,0,12.54,12.54,614.46,627]
["Employee 12",39,20.350000000000001,793.65,125000.35,125794,null,null,null,0,0,15.87,15.87,777.78,793.65]
["Employee 13",39,18,702,500.67,1202.67,null,null,null,0,0,14.04,14.04,687.96,702]
["Employee 14",32,11,352,6850.76,7202.76,null,null,null,0,0,7.04,7.04,344.96,352]
["Employee 15",30,18,540,20000,20540,null,null,null,0,0,10.8,10.8,529.20000000000005,540]
["Employee 16",37,12.45,460.65,93990.66,94451.31,null,null,null,0,0,9.2100000000000009,9.2100000000000009,451.44,460.65]
[null,{"$f":"SUM(B3:B18)","v":569},301.29000000000002,10750.92,826986.65,640345.25,0,0,0,0,0,215.01,215.01,10535.910000000002,10750.92]
[]
[null,null,null,null,null,"Assumptions"]
[null,null,null,null,null,"UnEm State","UnEm Fed","SS","Medicare","Pension"]
[null,null,null,null,null,5.3999999999999999E-2,8.0000000000000004E-4,6.2E-2,1.4500000000000001E-2,0.02]
[null,null,null,null,null,null,{"$f":"G22&\" Ceiling\"","v":"UnEm Fed Ceiling"},{"$f":"H22&\" Ceiling\"","v":"SS Ceiling"}]
[null,null,null,null,null,null,7000,94200]

{"sheet":"Payroll Register (an)","index":6,"n_rows":25,"n_cols":15,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,"Taxable Earnings",null,null,"Deductions"]
["Name","Hours","Wage","Gross","Beg Cumulative","End Cumulative","UnEm",{"$f":"H22","v":"SS"},{"$f":"I22","v":"Medicare"},{"$f":"H2","v":"SS"},{"$f":"I2","v":"Medicare"},{"$f":"J22","v":"Pension"},"Total Ded.","Net Pay","Expense"]
["Employee 1",33,12.55,{"$f":"ROUND(B3*C3,2)","v":414.15},25001.37,{"$f":"SUM(D3:E3)","v":25415.52},{"$f":"IF($E3>=G$25,0,IF($F3<=G$25,$D3,G$25-$E3))","v":0},414.15,{"$f":"D3","v":414.15},{"$f":"ROUND(H3*H$23,2)","v":25.68},6.01,{"$f":"ROUND(D3*J$23,2)","v":8.2799999999999994},{"$f":"SUM(J3:L3)","v":39.97},{"$f":"D3-M3","v":374.17999999999995},{"$f":"D3","v":414.15}]
["Employee 2",30,25,{"$f":"ROUND(B4*C4,2)","v":750},36589.74,{"$f":"SUM(D4:E4)","v":37339.74},0,750,750,46.5,10.88,15,72.38,677.62,750]
["Employee 3",38,23,874,115450.01,116324.01,0,0,874,0,12.67,17.48,30.15,843.85,874]
["Employee 4",40,22,880,5000.0600000000004,5880.06,880,880,880,54.56,12.76,17.600000000000001,84.920000000000016,795.07999999999993,880]
["Employee 5",32,24,768,6999,7767,1,768,768,47.62,11.14,15.36,74.12,693.88,768]
["Employee 6",40,17,680,7000.34,7680.34,0,680,680,42.16,9.86,13.6,65.61999999999999,614.38,680]
["Employee 7",37,13,481,7001.93,7482.93,0,481,481,29.82,6.97,9.6199999999999992,46.41,434.59000000000003,481]
["Employee 8",39,24.75,965.25,94199.64,95164.89,0,0.36000000000058208,965.25,0.02,14,19.309999999999999,33.33,931.92,965.25]
["Employee 9",32,17,544,94200.5,94744.5,0,0,544,0,7.89,10.88,18.77,525.23,544]
["Employee 10",38,24.19,919.22,94201.13,95120.35,0,0,919.22,0,13.33,18.38,31.71,887.51,919.22]
["Employee 11",33,19,627,95000.49,{"$f":"SUM(D13:E13)","v":95627.49},0,0,627,0,9.09,12.54,21.63,605.37,627]
["Employee 12",39,20.350000000000001,793.65,125000.35,125794,0,0,793.65,0,11.51,15.87,27.38,766.27,793.65]
["Employee 13",39,18,702,500.67,1202.67,702,702,702,43.52,10.18,14.04,67.740000000000009,634.26,702]
["Employee 14",32,11,352,6850.76,7202.76,149.23999999999978,352,352,21.82,5.0999999999999996,7.04,33.96,318.04000000000002,352]
["Employee 15",30,18,540,20000,20540,0,540,540,33.479999999999997,7.83,10.8,52.11,487.89,540]
["Employee 16",37,12.45,460.65,93990.66,94451.31,0,{"$f":"IF($E18>=H$25,0,IF($F18<=H$25,$D18,H$25-$E18))","v":209.33999999999651},460.65,12.98,6.68,9.2100000000000009,28.87,431.78,460.65]
[null,{"$f":"SUM(B3:B18)","v":569},301.29000000000002,10750.92,826986.65,837737.57000000007,1732.2399999999998,5776.8499999999967,10750.92,358.16,155.90000000000003,215.01,729.07,10021.85,10750.92]
[]
[null,null,null,null,null,"Assumptions"]
[null,null,null,null,null,"UnEm State","UnEm Fed","SS","Medicare","Pension"]
[null,null,null,null,null,5.3999999999999999E-2,8.0000000000000004E-4,6.2E-2,1.4500000000000001E-2,0.02]
[null,null,null,null,null,null,{"$f":"G22&\" Ceiling\"","v":"UnEm Fed Ceiling"},{"$f":"H22&\" Ceiling\"","v":"SS Ceiling"}]
[null,null,null,null,null,null,7000,94200]

{"sheet":"NOT NONE ONLY ALT+O+D","index":7,"n_rows":23,"n_cols":11,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["Is Account Suspended?","Customer","Credit Rating 01","Credit Rating 02","Asset Value",{"$f":"E20","v":"Past Year's Sales"},{"$f":"F20","v":"Current Over Due Balance"},{"$f":"H19","v":"Rule 1"},{"$f":"I19","v":"Rule 2"},"NONE: 2 rules not met)","ONLY:  Two rules are false, but Asset Hurdle Met"]
["Not Suspended","Customer 01",4,9,159441,332082,0]
["Not Suspended","Customer 02",4,6,796571,455968,1]
["Not Suspended","Customer 03",2,3,1243611,373892,1]
["Suspended","Customer 04",3,3,4939327,285446,1]
["Not Suspended","Customer 05",2,7,2647055,191068,0]
["Not Suspended","Customer 06",2,2,1409633,168029,0]
["Not Suspended","Customer 07",3,8,4350814,353054,1]
["Not Suspended","Customer 08",4,9,2395694,198841,0]
["Not Suspended","Customer 09",0,3,1629030,199163,1]
["Not Suspended","Customer 10",3,8,207371,189052,1]
["Suspended","Customer 11",0,5,4857701,347454,1]
["Not Suspended","Customer 12",3,4,1968563,90424,1]
["Not Suspended","Customer 13",3,8,3183148,169508,1]
["Not Suspended","Customer 14",2,7,3898837,238658,0]
["Not Suspended","Customer 15",0,9,4643757,439679,1]
[]
["Assumptions"]
[null,"Credit Criteria 1","Credit Criteria 2","Credit Criteria 3","Credit Criteria 4","Credit Criteria 5",null,"Rule 1","Rule 2"]
[null,"Hurdle Credit Rating 01","Hurdle Credit Rating 02","Hurdle Asset Value","Past Year's Sales","Current Over Due Balance","Is Account Suspended?",{"$f":"\"Not Suspended, No Overdue Balance and Past sales > \"&DOLLAR(E21)&\"\"","v":"Not Suspended, No Overdue Balance and Past sales > $50,000.00"},"Both Credit Hurdles must be met and at least 1 of the remaining criteria must be met"]
[null,2,4.5,200000,50000,0,"Suspended"]
["Low",0,0,null,null,null,"Not Suspended"]
["High",4,10]

{"sheet":"NOT NONE ONLY ALT+O+D (an)","index":8,"n_rows":23,"n_cols":11,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
["Is Account Suspended?","Customer","Credit Rating 01","Credit Rating 02","Asset Value",{"$f":"E20","v":"Past Year's Sales"},{"$f":"F20","v":"Current Over Due Balance"},{"$f":"H19","v":"Rule 1"},{"$f":"I19","v":"Rule 2"},"NONE: 2 rules not met)","ONLY:  Two rules are false, but Asset Hurdle Met"]
["Not Suspended","Customer 01",4,9,159441,332082,0,{"$f":"AND(A2<>G$21,G2=F$21,F2>=E$21)","v":true},{"$f":"AND(AND(C2>=B$21,D2>=C$21),OR(E2>=D$21,F2>=E$21,G2=F$21))","v":true},{"$f":"NOT(OR(H2:I2))","v":false},{"$f":"AND(E2>=D$21,NOT(OR(H2:I2)))","v":false}]
["Not Suspended","Customer 02",4,6,796571,455968,1,{"$f":"AND(A3<>G$21,G3=F$21,F3>=E$21)","v":false},true,false,false]
["Not Suspended","Customer 03",2,3,1243611,373892,1,false,false,true,true]
["Suspended","Customer 04",3,3,4939327,285446,1,false,false,true,true]
["Not Suspended","Customer 05",2,7,2647055,191068,0,true,true,false,false]
["Not Suspended","Customer 06",2,2,1409633,168029,0,true,false,false,false]
["Not Suspended","Customer 07",3,8,4350814,353054,1,false,true,false,false]
["Not Suspended","Customer 08",4,9,2395694,198841,0,true,true,false,false]
["Not Suspended","Customer 09",0,3,1629030,199163,1,false,false,true,true]
["Not Suspended","Customer 10",3,8,207371,189052,1,false,true,false,false]
["Suspended","Customer 11",0,5,4857701,347454,1,false,false,true,true]
["Not Suspended","Customer 12",3,4,1968563,90424,1,false,false,true,true]
["Not Suspended","Customer 13",3,8,3183148,169508,1,false,true,false,false]
["Not Suspended","Customer 14",2,7,3898837,238658,0,true,true,false,false]
["Not Suspended","Customer 15",0,9,4643757,439679,1,false,false,true,true]
[]
["Assumptions"]
[null,"Credit Criteria 1","Credit Criteria 2","Credit Criteria 3","Credit Criteria 4","Credit Criteria 5",null,"Rule 1","Rule 2"]
[null,"Hurdle Credit Rating 01","Hurdle Credit Rating 02","Hurdle Asset Value","Past Year's Sales","Current Over Due Balance","Is Account Suspended?",{"$f":"\"Not Suspended, No Overdue Balance and Past sales > \"&DOLLAR(E21)&\"\"","v":"Not Suspended, No Overdue Balance and Past sales > $50,000.00"},"Both Criteria Hurdles must be met and at least 1 of the remaining criteria must be met"]
[null,2,4.5,200000,50000,0,"Suspended"]
["Low",0,0,null,null,null,"Not Suspended"]
["High",4,10]

{"sheet":"HW ==>","index":9,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"P214-241","index":10,"n_rows":30,"n_cols":6,"rows_kept":30,"cut":false,"hidden":false,"merged":[[23,0,26,0]]}
["Credit approval indicator rules to each customer’s data. The three rules together suggest a customer's creditworthiness. A rejection on one rule does not automatically translate to automatic denial. For problem accounts, a False or Rejection is an indicator that we should further investigate the customer's creditworthiness."]
[null,null,"% of this year's total sales"]
["Rule 1 (FALSE is Reject)",{"$f":"\"Past due balance is less than \"&C3*100&C2","v":"Past due balance is less than 10% of this year's total sales"},0.1]
[null,"Not calculated for new customers","Composite credit appraisal value","PAYDEX score over"]
["Rule 2 (FALSE is Reject)",{"$f":"C4&\" of \"&C5&\" OR a \"&D4&\" \"&D5","v":"Composite credit appraisal value of 1 OR a PAYDEX score over 90"},1,90]
[]
["Rule 3 (FALSE is Reject)",{"$f":"C7&\" \"&DOLLAR(C8)&\" AND a \"&D7&\" \"&D8&\" AND \"&E7&\" \"&E8&\" AND a \"&F7&\" \"&F8","v":"Net worth of at least $500,000.00 AND a composite credit appraisal value less than or equal to 2 AND PAYDEX score over 70 AND a stress risk class of 1"},"Net worth of at least","composite credit appraisal value less than or equal to","PAYDEX score over","stress risk class of"]
[null,null,500000,2,70,1]
[]
["Formatting Rules"]
["Rule 1",{"$f":"\"Net worth is less than \"&DOLLAR(C11)","v":"Net worth is less than $1,000,000.00"},1000000]
["Rule 2",{"$f":"\"Net worth is greater than \"&DOLLAR(C12)","v":"Net worth is greater than $10,000,000.00"},10000000]
[]
[{"$f":"\"Rules for \"&A21&\"; \"&A22&\"; \"&A28","v":"Rules for Reject; Further Evaluate; Accept"}]
[]
["How many outcomes are there with this rule?",{"$f":"B18^B17","v":8}]
["How many experiments?",3]
["How many out comes for each experiment?",2]
[]
[null,"Rule #1","Rule #2","Rule #3"]
["Reject",false,false,false]
["Further Evaluate",true,false,false]
[null,null,"OR"]
["Inside an or",false,true,false]
[null,false,false,true]
[null,false,true,true]
[]
["Accept",true,true,true]
[null,true,false,true]
[null,true,true,false]

{"sheet":"P214-241(2nd)","index":11,"n_rows":26,"n_cols":14,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["Accounts Receivable Department - Customer Credit Analysis"]
["Customer Name","Current Credit Limit","Previous Year's Sales","Current Year's Sales","Past Due Balance","Net Worth in (000)","D&B Credit Rating Class","D&B Composite Credit Appraisal (1 Best)","D&B PAYDEX (100 Best)","D&B Stress Risk Class \n(1 Best)",{"$f":"'P214-241'!A3&\": \"&'P214-241'!B3","v":"Rule 1 (FALSE is Reject): Past due balance is less than 10% of this year's total sales"},{"$f":"'P214-241'!A5&\": \"&'P214-241'!B5","v":"Rule 2 (FALSE is Reject): Composite credit appraisal value of 1 OR a PAYDEX score over 90"},{"$f":"'P214-241'!A7&\": \"&'P214-241'!B7","v":"Rule 3 (FALSE is Reject): Net worth of at least $500,000.00 AND a composite credit appraisal value less than or equal to 2 AND PAYDEX score over 70 AND a stress risk class of 1"},"Reject? Further Evaluate? Accept?"]
["Athletic Gear Corp.",9000,15382,11952,0,450,"BA",4,15,3,{"$f":"IF(C3=\"\",\"\",E3<D3*'P214-241'!C$3)","v":true},{"$f":"OR(H3='P214-241'!C$5,I3>'P214-241'!D$5)","v":false},{"$f":"AND(F3*1000>='P214-241'!C$8,H3<='P214-241'!D$8,I3>'P214-241'!E$8,J3='P214-241'!F$8)","v":false},{"$f":"IF(NOT(OR(K3:M3)),\"Reject\",IF(OR(AND(OR(L3:M3),K3),AND(OR(L3:M3),NOT(K3))),\"FurtherEvaluate\",\"Accept\"))","v":"Accept"}]
["Baltimore O's",39000,10033,7789,0,1950,"3A",1,51,1,{"$f":"IF(C4=\"\",\"\",E4<D4*'P214-241'!C$3)","v":true},{"$f":"OR(H4='P214-241'!C$5,I4>'P214-241'!D$5)","v":true},{"$f":"AND(F4*1000>='P214-241'!C$8,H4<='P214-241'!D$8,I4>'P214-241'!E$8,J4='P214-241'!F$8)","v":false},{"$f":"IF(NOT(OR(K4:M4)),\"Reject\",IF(OR(AND(OR(L4:M4),K4),AND(OR(L4:M4),NOT(K4))),\"FurtherEvaluate\",\"Accept\"))","v":"FurtherEvaluate"}]
["Baseball & More",75000,60009,55342,13892,37500,"4A",2,70,1,{"$f":"IF(C5=\"\",\"\",E5<D5*'P214-241'!C$3)","v":false},{"$f":"OR(H5='P214-241'!C$5,I5>'P214-241'!D$5)","v":false},{"$f":"AND(F5*1000>='P214-241'!C$8,H5<='P214-241'!D$8,I5>'P214-241'!E$8,J5='P214-241'!F$8)","v":false},"Reject"]
["Canadian Ski Club",33000,35039,50921,495,1650,"BA",2,43,1,{"$f":"IF(C6=\"\",\"\",E6<D6*'P214-241'!C$3)","v":true},{"$f":"OR(H6='P214-241'!C$5,I6>'P214-241'!D$5)","v":false},{"$f":"AND(F6*1000>='P214-241'!C$8,H6<='P214-241'!D$8,I6>'P214-241'!E$8,J6='P214-241'!F$8)","v":false},"Accept"]
["Concord Pro Shop",null,null,null,null,10000,"4A",1,91,1,null,{"$f":"OR(H7='P214-241'!C$5,I7>'P214-241'!D$5)","v":true},{"$f":"AND(F7*1000>='P214-241'!C$8,H7<='P214-241'!D$8,I7>'P214-241'!E$8,J7='P214-241'!F$8)","v":true},"FurtherEvaluate"]
["Everything Golf",25000,15221,9483,2899,1250,"3A",3,76,1,{"$f":"IF(C8=\"\",\"\",E8<D8*'P214-241'!C$3)","v":false},{"$f":"OR(H8='P214-241'!C$5,I8>'P214-241'!D$5)","v":false},{"$f":"AND(F8*1000>='P214-241'!C$8,H8<='P214-241'!D$8,I8>'P214-241'!E$8,J8='P214-241'!F$8)","v":false},"Reject"]
["Lake Pro Shops",42000,80498,81126,0,2100,"3A",2,87,1,{"$f":"IF(C9=\"\",\"\",E9<D9*'P214-241'!C$3)","v":true},{"$f":"OR(H9='P214-241'!C$5,I9>'P214-241'!D$5)","v":false},{"$f":"AND(F9*1000>='P214-241'!C$8,H9<='P214-241'!D$8,I9>'P214-241'!E$8,J9='P214-241'!F$8)","v":true},"FurtherEvaluate"]
["Mars Dept. Store",27000,35354,20666,0,213,"BB",3,94,1,{"$f":"IF(C10=\"\",\"\",E10<D10*'P214-241'!C$3)","v":true},{"$f":"OR(H10='P214-241'!C$5,I10>'P214-241'!D$5)","v":true},{"$f":"AND(F10*1000>='P214-241'!C$8,H10<='P214-241'!D$8,I10>'P214-241'!E$8,J10='P214-241'!F$8)","v":false},"FurtherEvaluate"]
["RG Bradley",46000,90970,18343,0,2300,"3A",1,21,1,{"$f":"IF(C11=\"\",\"\",E11<D11*'P214-241'!C$3)","v":true},{"$f":"OR(H11='P214-241'!C$5,I11>'P214-241'!D$5)","v":true},{"$f":"AND(F11*1000>='P214-241'!C$8,H11<='P214-241'!D$8,I11>'P214-241'!E$8,J11='P214-241'!F$8)","v":false},"FurtherEvaluate"]
["RX for Sports",15000,5663,3014,0,750,"2A",1,59,1,{"$f":"IF(C12=\"\",\"\",E12<D12*'P214-241'!C$3)","v":true},{"$f":"OR(H12='P214-241'!C$5,I12>'P214-241'!D$5)","v":true},{"$f":"AND(F12*1000>='P214-241'!C$8,H12<='P214-241'!D$8,I12>'P214-241'!E$8,J12='P214-241'!F$8)","v":false},"FurtherEvaluate"]
["School Sports Supply",45000,50278,32338,0,2250,"3A",3,91,1,{"$f":"IF(C13=\"\",\"\",E13<D13*'P214-241'!C$3)","v":true},{"$f":"OR(H13='P214-241'!C$5,I13>'P214-241'!D$5)","v":true},{"$f":"AND(F13*1000>='P214-241'!C$8,H13<='P214-241'!D$8,I13>'P214-241'!E$8,J13='P214-241'!F$8)","v":false},"FurtherEvaluate"]
["Ski World",26000,25864,28154,0,300,"BA",2,82,1,{"$f":"IF(C14=\"\",\"\",E14<D14*'P214-241'!C$3)","v":true},{"$f":"OR(H14='P214-241'!C$5,I14>'P214-241'!D$5)","v":false},{"$f":"AND(F14*1000>='P214-241'!C$8,H14<='P214-241'!D$8,I14>'P214-241'!E$8,J14='P214-241'!F$8)","v":false},"Accept"]
["Sneaker Kingdom",45000,40157,25379,0,2250,"3A",2,71,1,{"$f":"IF(C15=\"\",\"\",E15<D15*'P214-241'!C$3)","v":true},{"$f":"OR(H15='P214-241'!C$5,I15>'P214-241'!D$5)","v":false},{"$f":"AND(F15*1000>='P214-241'!C$8,H15<='P214-241'!D$8,I15>'P214-241'!E$8,J15='P214-241'!F$8)","v":true},"FurtherEvaluate"]
["Sports & Stuff",15000,15898,14732,14383,450,"BA",1,67,1,{"$f":"IF(C16=\"\",\"\",E16<D16*'P214-241'!C$3)","v":false},{"$f":"OR(H16='P214-241'!C$5,I16>'P214-241'!D$5)","v":true},{"$f":"AND(F16*1000>='P214-241'!C$8,H16<='P214-241'!D$8,I16>'P214-241'!E$8,J16='P214-241'!F$8)","v":false},"FurtherEvaluate"]
["Toy Kingdom",22000,10073,1047,0,1100,"3A",3,14,1,{"$f":"IF(C17=\"\",\"\",E17<D17*'P214-241'!C$3)","v":true},{"$f":"OR(H17='P214-241'!C$5,I17>'P214-241'!D$5)","v":false},{"$f":"AND(F17*1000>='P214-241'!C$8,H17<='P214-241'!D$8,I17>'P214-241'!E$8,J17='P214-241'!F$8)","v":false},"Accept"]
["Under the Sea",45000,95411,64418,0,150,"CB",4,79,2,{"$f":"IF(C18=\"\",\"\",E18<D18*'P214-241'!C$3)","v":true},{"$f":"OR(H18='P214-241'!C$5,I18>'P214-241'!D$5)","v":false},{"$f":"AND(F18*1000>='P214-241'!C$8,H18<='P214-241'!D$8,I18>'P214-241'!E$8,J18='P214-241'!F$8)","v":false},"Accept"]
["US Olympic Team",20000,5621,6171,0,1000,"3A",1,87,1,{"$f":"IF(C19=\"\",\"\",E19<D19*'P214-241'!C$3)","v":true},{"$f":"OR(H19='P214-241'!C$5,I19>'P214-241'!D$5)","v":true},{"$f":"AND(F19*1000>='P214-241'!C$8,H19<='P214-241'!D$8,I19>'P214-241'!E$8,J19='P214-241'!F$8)","v":true},"FurtherEvaluate"]
["WWW Sports Inc.",100000,60009,60354,0,500000,"5A",2,97,1,{"$f":"IF(C20=\"\",\"\",E20<D20*'P214-241'!C$3)","v":true},{"$f":"OR(H20='P214-241'!C$5,I20>'P214-241'!D$5)","v":true},{"$f":"AND(F20*1000>='P214-241'!C$8,H20<='P214-241'!D$8,I20>'P214-241'!E$8,J20='P214-241'!F$8)","v":true},"FurtherEvaluate"]
["Zip & Sons",10000,15490,22760,0,620,"1A",2,96,1,{"$f":"IF(C21=\"\",\"\",E21<D21*'P214-241'!C$3)","v":true},{"$f":"OR(H21='P214-241'!C$5,I21>'P214-241'!D$5)","v":true},{"$f":"AND(F21*1000>='P214-241'!C$8,H21<='P214-241'!D$8,I21>'P214-241'!E$8,J21='P214-241'!F$8)","v":true},"FurtherEvaluate"]
[]
[]
[{"$f":"IF('P214-241'!A10=\"\",\"\",'P214-241'!A10)","v":"Formatting Rules"}]
[{"$f":"IF('P214-241'!A11=\"\",\"\",'P214-241'!A11)","v":"Rule 1"},{"$f":"IF('P214-241'!B11=\"\",\"\",'P214-241'!B11)","v":"Net worth is less than $1,000,000.00"},{"$f":"IF('P214-241'!C11=\"\",\"\",'P214-241'!C11)","v":1000000}]
[{"$f":"IF('P214-241'!A12=\"\",\"\",'P214-241'!A12)","v":"Rule 2"},{"$f":"IF('P214-241'!B12=\"\",\"\",'P214-241'!B12)","v":"Net worth is greater than $10,000,000.00"},{"$f":"IF('P214-241'!C12=\"\",\"\",'P214-241'!C12)","v":10000000}]

{"sheet":"P242-243","index":12,"n_rows":21,"n_cols":9,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
["PO 527 Bidder List Financial Evaluation"]
["Bidder List","Previous Experience Grade","Net Worth (Dollars)","D&B Composite Credit Appraisal (1 Best)","D&B PAYDEX (100 Best)","D&B Stress Risk Class \n(1 Best)",{"$f":"A13&\": \"&B13","v":"Rule 1: D&B Stress Risk Class (1 Best) Hurdle = 1"},{"$f":"A14&\": \"&B14","v":"Rule 2: D&B PAYDEX (100 Best) is greater than 60 AND D&B Composite Credit Appraisal (1 Best) is less than or equal to 2 AND Net Worth (Dollars) are greater than $1,000,000.00"},{"$f":"A15&\": \"&B15","v":"Rule 3: D&B PAYDEX (100 Best) is greater than or equal to 85 OR Previous Experience Grade is Satisfactory"}]
["Logistic SB Inc.","None",2500000,2,85,1,{"$f":"F3=C$13","v":true},{"$f":"AND(E3>C$14,D3<=D$14,C3>E$14)","v":true},{"$f":"OR(E3>=C$15,B3=D$15)","v":true}]
["XBE Corporation","Satisfactory",237000000,1,90,1,{"$f":"F4=C$13","v":true},{"$f":"AND(E4>C$14,D4<=D$14,C4>E$14)","v":true},{"$f":"OR(E4>=C$15,B4=D$15)","v":true}]
["Software Solutions","Satisfactory",1823000,3,55,2,{"$f":"F5=C$13","v":false},{"$f":"AND(E5>C$14,D5<=D$14,C5>E$14)","v":false},{"$f":"OR(E5>=C$15,B5=D$15)","v":true}]
["Exceed RW","Unsatisfactory",75000,2,38,1,{"$f":"F6=C$13","v":true},{"$f":"AND(E6>C$14,D6<=D$14,C6>E$14)","v":false},{"$f":"OR(E6>=C$15,B6=D$15)","v":false}]
["Roberts Wise Inc.","Satisfactory",680000,3,43,1,{"$f":"F7=C$13","v":true},{"$f":"AND(E7>C$14,D7<=D$14,C7>E$14)","v":false},{"$f":"OR(E7>=C$15,B7=D$15)","v":true}]
[]
[null,null,"Did any evaluate to TRUE?",null,null,null,{"$f":"OR(G3:G7)","v":true},{"$f":"OR(H3:H7)","v":true},{"$f":"OR(I3:I7)","v":true}]
[null,null,"Did all not evaluate to TRUE? Or Didd all come out false?",null,null,null,{"$f":"NOT(G9)","v":false},{"$f":"NOT(H9)","v":false},{"$f":"NOT(I9)","v":false}]
[]
[null,"Assumptions"]
["Rule 1",{"$f":"CLEAN(F2)&\" Hurdle = \"&C13","v":"D&B Stress Risk Class (1 Best) Hurdle = 1"},1]
["Rule 2",{"$f":"E2&\" is greater than \"&C14&\" AND \"&D2&\" is less than or equal to \"&D14&\" AND \"&C2&\" are greater than \"&DOLLAR(E14)","v":"D&B PAYDEX (100 Best) is greater than 60 AND D&B Composite Credit Appraisal (1 Best) is less than or equal to 2 AND Net Worth (Dollars) are greater than $1,000,000.00"},60,2,1000000]
["Rule 3",{"$f":"E2&\" is greater than or equal to \"&C15&\" OR \"&B2&\" is \"&D15","v":"D&B PAYDEX (100 Best) is greater than or equal to 85 OR Previous Experience Grade is Satisfactory"},85,"Satisfactory"]
[null,"Format if TRUE = Green",true]
[null,"Format if FALSE = Grey",false]
[null,"Format Bidder name who had Previous Eperience Grade \"Unsatisfactory\"","Unsatisfactory"]
[]
["Note:"]
["Conditional formatting in column A is based on values in Column B. The formula is: =B3=$C$18"]

{"sheet":"P244-257","index":13,"n_rows":47,"n_cols":12,"rows_kept":47,"cut":false,"hidden":false,"merged":[]}
["TheZone Customer Accounts - Credit & Payment Status"]
["Customer Name","Customer Type","Current Balance Due",{"$f":"B21&\"-Days Past Due\"","v":"30-Days Past Due"},{"$f":"C21&\"-Days Past Due\"","v":"60-Days Past Due"},{"$f":"D21&\"-Days Past Due\"","v":"90-Days Past Due"},"Total Past Due Balance","Current Credit Status (FALSE means that they have been denied credit but may still owe $)",{"$f":"A11&\" or \"&A12","v":"Credit Approved or Credit Denied"},{"$f":"A17","v":"If the 90-Days Past Due balance is greater than $200.00 then the large of $100.00 or 10% of 90 day balance"},{"$f":"A19&\": \"&B21&\" = \"&DOLLAR(B19)&\"; \"&C21&\" = \"&DOLLAR(C19)&\"; \"&D21&\" = \"&DOLLAR(D19)","v":"Alternative Penalty Scheme: 30 = $25.00; 60 = $50.00; 90 = $100.00"},{"$f":"B2&\" Late Fee\"","v":"Customer Type Late Fee"}]
["Athletic Gear Corp.","A",8612,0,0,0,{"$f":"SUM(D3:F3)","v":0},true,{"$f":"IF(H3,A$11,A$12)","v":"Credit Approved"},{"$f":"IF(F3>B$17,MAX(C$17,F3*D$17),0)","v":0},{"$f":"IF(F3>0,D$19,IF(E3>0,C$19,IF(D3>0,B$19,0)))","v":0},{"$f":"IF(G3>0,IF(B3=C$26,B$26,IF(B3=C$27,B$27,IF(B3=C$28,B$28))),0)","v":0}]
["Baltimore O's","B",0,0,0,0,0,true,"Credit Approved",0,0,0]
["Baseball & More","A",2345,3473,5556.8,4862.2,{"$f":"SUM(D5:F5)","v":13892},true,"Credit Approved",486.22,100,50]
["Canadian Ski Club","C",0,345,0,150,495,true,"Credit Approved",0,100,150]
["Everything Golf","A",0,0,2000,899,2899,false,"Credit Denied",100,100,50]
["Sports & Stuff","A",0,14000,383,0,14383,false,"Credit Denied",0,50,50]
[]
["Assumptions"]
["Credit Approved"]
["Credit Denied"]
[]
["Note: Order for non-mutually exclusive criteria matteres here because you can have balances in all three categroies (not mutually exclusive), and so you must test"]
[]
[null,"Minimum before applying surcharge","Minimun surcharge","Surchanrge % of 90 day balance"]
[{"$f":"\"If the \"&F2&\" balance is greater than \"&DOLLAR(B17)&\" then the large of \"&DOLLAR(C17)&\" or \"&TEXT(D17,\"0%\")&\" of 90 day balance\"","v":"If the 90-Days Past Due balance is greater than $200.00 then the large of $100.00 or 10% of 90 day balance"},200,100,0.1]
[null,{"$f":"\"Fee for \"&D2","v":"Fee for 30-Days Past Due"},{"$f":"\"Fee for \"&E2","v":"Fee for 60-Days Past Due"},{"$f":"\"Fee for \"&F2","v":"Fee for 90-Days Past Due"}]
["Alternative Penalty Scheme",25,50,100]
[null,"Past Due","Past Due","Past Due"]
["Days",30,60,90]
[]
["This example is of criteria that is mutually exclusive, the order of the logical tests does not matter."]
[]
[null,"Late Fee","Cust Type"]
[{"$f":"C26&\" Cust Type Late Fee\"","v":"A Cust Type Late Fee"},50,"A"]
[{"$f":"C27&\" Cust Type Late Fee\"","v":"B Cust Type Late Fee"},100,"B"]
[{"$f":"C28&\" Cust Type Late Fee\"","v":"C Cust Type Late Fee"},150,"C"]
[]
[]
["VLOOKUP if often better than many Ifs. But if you use Ifs, better to go from low to high or high to low instead of between."]
[null,"Hurdle","Penalty"]
[{"$f":"\"Level 1: less tha \"&DOLLAR(B33)","v":"Level 1: less tha $1,000.00"},1000,25]
[{"$f":"\"Level 2: less than \"&DOLLAR(B35)&\" and greater than or equal to \"&DOLLAR(B34)","v":"Level 2: less than $5,000.00 and greater than or equal to $1,000.00"},1000,50]
[{"$f":"\"Level 3 greater than \"&DOLLAR(B35)","v":"Level 3 greater than $5,000.00"},5000,100]
[]
[]
[]
["Past Due"," =IF(A40<B$33,C$33,IF(A40<B$35,C$34,C$35))",null,null," =IF(A40>B$35,C$35,IF(A40>B$34,C$34,C$33))",null,null,null," =IF(AND(A40>=B$34,A40<B$35),C$34,IF(A40<B$33,C$33,C$35))"]
[670,{"$f":"IF(A40<B$33,C$33,IF(A40<B$35,C$34,C$35))","v":25},null,null,{"$f":"IF(A40>B$35,C$35,IF(A40>B$34,C$34,C$33))","v":25},null,null,null,{"$f":"IF(AND(A40>=B$34,A40<B$35),C$34,IF(A40<B$33,C$33,C$35))","v":25}]
[141,{"$f":"IF(A41<B$33,C$33,IF(A41<B$35,C$34,C$35))","v":25},null,null,{"$f":"IF(A41>B$35,C$35,IF(A41>B$34,C$34,C$33))","v":25},null,null,null,{"$f":"IF(AND(A41>=B$34,A41<B$35),C$34,IF(A41<B$33,C$33,C$35))","v":25}]
[3893,50,null,null,50,null,null,null,50]
[4741,50,null,null,50,null,null,null,50]
[8434,100,null,null,100,null,null,null,100]
[7401,100,null,null,100,null,null,null,100]
[4819,50,null,null,50,null,null,null,50]
[8344,100,null,null,100,null,null,null,100]

{"sheet":"P257-259","index":14,"n_rows":16,"n_cols":11,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
["Fixed  Fee & 90 Day Penalties",null,null,"Graduated Penalties - Range",null,null,null,"Penalty",null,"Category Penalties"]
["Fixed Fee Penalty",50,null,"Graduated penalty <",null,null,1000,0,null,"Utilities",0.1]
["Hurdle for penalty",100,null,"Graduated penalty >=1000 but <",null,null,5000,100,null,"Labor",0.15]
["90-day penalty percentage",0.1,null,"Graduated penalty >=",null,null,5000,200,null,"Other",0.05]
[]
[]
["TheZone Accounts Payable - Outstanding Balance Report"]
["Vendor Name","Category","Applies Fixed Penalty","30-Days Past Due","60-Days Past Due","90-Days Past Due","Total Past Due Balance","Fixed Penalty","90-Day Penalty","Graduated Penalty","Category Penalty"]
["RTF Electric","Utilities",true,16254,0,0,{"$f":"SUM(D9:F9)","v":16254},{"$f":"IF(C9,B$2,0)","v":50},{"$f":"IF(F9>B$3,F9*B$4,0)","v":0},{"$f":"IF(G9<G$2,H$2,IF(G9<G$3,H$3,H$4))","v":200},{"$f":"IF(B9=J$2,K$2*G9,IF(B9=J$3,K$3*G9,K$4*G9))","v":1625.4}]
["Ross County Water & Sewer","Utilities",false,1435,0,0,1435,0,0,100,143.5]
["YNC Trucking","Transportation",true,0,0,3300,3300,50,330,100,165]
["Italian Leather Group Ltd.","Raw Materials",true,6756,0,5674,12430,50,567.4,200,621.5]
["Union Plastics","Raw Materials",true,0,436,0,436,50,0,0,21.8]
["Freight to Go","Transportation",false,0,0,873,873,0,87.300000000000011,0,43.650000000000006]
["Temps R'Us","Labor",false,2700,0,0,2700,0,0,100,405]
["Notworth Telephone","Telephone",true,0,0,2345,2345,50,234.5,100,117.25]

{"sheet":"P276-278","index":15,"n_rows":34,"n_cols":15,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[" Application for Employment"]
["Name","College GPA","Major Code","Refer-ences","Personal Interview Rating","Work Experience","Employment ExamScore","School Rank","InvalidScores/Major?","Automatically Disqualified","Automatically Hired","Not Automatically Disqualified","Not Automatically Hired","No Decision","No Decision"]
["Michael",3.6,2,3,5,true,700,12,{"$f":"OR(B3<E$19,B3>E$20,C3<B$21,C3>B$25,G3<B$29,G3>B$30)","v":false},{"$f":"OR(I3,B3<E$25,D3<E$26,G3<E$27,E3<E$28)","v":false},{"$f":"AND(B3>H$19,C3>=H$20,C3<=H$21,H3<=H$22,G3>H$23,E3>=H$24,F3)","v":false},{"$f":"NOT(J3)","v":true},true,{"$f":"NOT(OR(J3:K3))","v":true},{"$f":"AND(L3:M3)","v":true}]
["Brian",3.9,18,3,3,false,850,1,true,true,false,false,true,false,false]
["George",2.1,15,3,2,false,780,5,false,true,false,false,true,false,false]
["Jasen",3,30,3,5,true,710,3,false,false,false,true,true,true,true]
["Cindy",3.2,100,4,3,true,600,26,false,false,false,true,true,true,true]
["Sara",3.7,4,3,6,true,740,15,false,false,true,true,false,false,false]
["Courtney",4,16,5,4,false,720,8,false,false,false,true,true,true,true]
["Scott",2.1,260,2,2,false,590,33,true,true,false,false,true,false,false]
["Mark",2.8,20,3,5,false,760,6,false,false,false,true,true,true,true]
[null,null,null,null,null,null,null,"Total",{"$f":"SUM(IF(I3:I11=TRUE,1,0))","v":2},{"$f":"SUM(IF(J3:J11=TRUE,1,0))","v":3},{"$f":"SUM(IF(K3:K11=TRUE,1,0))","v":1},{"$f":"SUM(IF(L3:L11=TRUE,1,0))","v":6},{"$f":"SUM(IF(M3:M11=TRUE,1,0))","v":8},{"$f":"SUM(IF(N3:N11=TRUE,1,0))","v":5}]
[null,null,null,null,null,null,null,"Total",{"$f":"COUNTIF(I3:I11,TRUE)","v":2},3,1,6,8,5]
[null,null,null,null,null,null,"All are invalid",null,{"$f":"AND(I3:I11)","v":false},false,false,false,false,false]
[null,null,null,null,null,null,"Any are invalid?",null,{"$f":"OR(I3:I11)","v":true},true,true,true,true,true]
["Assumptions"]
["Job Applicants must supply the following information",null,null,{"$f":"A32","v":"Automatically disqualified"},null,null,{"$f":"A33","v":"Automatically hired"}]
["Valid GPA min",1.5,null,"If any of these are TRUE",null,null,"If all of these are TRUE"]
["Valid GPA max",4,null,{"$f":"A18","v":"Valid GPA min"},{"$f":"B18","v":1.5},null,"GPA score greater than",3.5]
["Standardized universal Major Code",null,null,{"$f":"A19","v":"Valid GPA max"},{"$f":"B19","v":4},null,"Major Code min",1]
["Engeneering",1,null,{"$f":"A29","v":"Valid Employment Exam Score min"},{"$f":"B29","v":200},null,"Major Code max",20]
["Business",2,null,{"$f":"A30","v":"Valid Employment Exam Score max"},{"$f":"B30","v":800},null,{"$f":"A31&\" less than or equal to\"","v":"Undergraduate school ranking less than or equal to"},25]
["Economics",3,null,{"$f":"\"Valid \"&A$20&\" min\"","v":"Valid Standardized universal Major Code min"},{"$f":"B21","v":1},null,"Employment Exam greater than",700]
["Physical Science",4,null,{"$f":"\"Valid \"&A$20&\" max\"","v":"Valid Standardized universal Major Code max"},{"$f":"B25","v":250},null,"Personal Interview rating greater than or equal to",4]
["Last one",250,null,"GPA less than",2.5,null,"Work Experience",{"$f":"B28","v":true}]
["Reference letters less than",3,null,{"$f":"A26","v":"Reference letters less than"},{"$f":"B26","v":3}]
["Personal Interview rating less than",3,null,"Employment Exam less than",600]
["Work Experience",true,false,{"$f":"A27","v":"Personal Interview rating less than"},{"$f":"B27","v":3}]
["Valid Employment Exam Score min",200]
["Valid Employment Exam Score max",800]
["Undergraduate school ranking"]
["Automatically disqualified"]
["Automatically hired"]
["Undecided","If the applicant does not fit into one of the other categories"]

{"sheet":"P278-280","index":16,"n_rows":26,"n_cols":14,"rows_kept":26,"cut":false,"hidden":false,"merged":[]}
["RJ Construction - Painting Estimator "]
[]
["Room","Length in Feet","Width in Feet","Height in Feet","Square Feet (SF) of Wall/Ceiling","Wall Condition",{"$f":"A19","v":"New Color Lighter ?"},{"$f":"A21","v":"Grade of Paint"},"Wall Repairs & Primer Costs","First Coat Painting Costs","Second Coat Painting Costs","Paint Quality Adjustment","Total Costs","High Price?"]
["Kitchen",20,15,8,{"$f":"2*B4*D4+2*C4*D4+B4*C4","v":860},2,true,"Premium",{"$f":"IF(F4=B$16,E4*C$16,0)","v":0},{"$f":"IF(F4=B$14,E4*D$14,IF(F4=B$15,D$15*E4,E4*D$16))","v":430},{"$f":"IF(G4=B$19,E4*D$19,IF(F4=B$16,E4*B$18,0))","v":258},{"$f":"IF(H4=A$22,B$22*E4,IF(H4=A$23,B$23*E4,0))","v":129},{"$f":"SUM(I4:L4)","v":817},{"$f":"M4>B$26","v":true}]
["Bedroom1",16,12,8,{"$f":"2*B5*D5+2*C5*D5+B5*C5","v":640},1,false,"Economy",{"$f":"IF(F5=B$16,E5*C$16,0)","v":0},{"$f":"IF(F5=B$14,E5*D$14,IF(F5=B$15,D$15*E5,E5*D$16))","v":288},{"$f":"IF(G5=B$19,E5*D$19,IF(F5=B$16,E5*B$18,0))","v":0},{"$f":"IF(H5=A$22,B$22*E5,IF(H5=A$23,B$23*E5,0))","v":-64},{"$f":"SUM(I5:L5)","v":224},{"$f":"M5>B$26","v":false}]
["Bedroom2",10,12,8,{"$f":"2*B6*D6+2*C6*D6+B6*C6","v":472},1,false,"Superior",{"$f":"IF(F6=B$16,E6*C$16,0)","v":0},{"$f":"IF(F6=B$14,E6*D$14,IF(F6=B$15,D$15*E6,E6*D$16))","v":212.4},{"$f":"IF(G6=B$19,E6*D$19,IF(F6=B$16,E6*B$18,0))","v":0},{"$f":"IF(H6=A$22,B$22*E6,IF(H6=A$23,B$23*E6,0))","v":0},{"$f":"SUM(I6:L6)","v":212.4},{"$f":"M6>B$26","v":false}]
["Bath",8,6,8,{"$f":"2*B7*D7+2*C7*D7+B7*C7","v":272},3,false,"Superior",{"$f":"IF(F7=B$16,E7*C$16,0)","v":136},{"$f":"IF(F7=B$14,E7*D$14,IF(F7=B$15,D$15*E7,E7*D$16))","v":163.19999999999999},{"$f":"IF(G7=B$19,E7*D$19,IF(F7=B$16,E7*B$18,0))","v":95.199999999999989},{"$f":"IF(H7=A$22,B$22*E7,IF(H7=A$23,B$23*E7,0))","v":0},{"$f":"SUM(I7:L7)","v":394.4},{"$f":"M7>B$26","v":false}]
["  Total",null,null,null,null,null,null,null,{"$f":"SUM(I4:I7)","v":136},{"$f":"SUM(J4:J7)","v":1093.5999999999999},{"$f":"SUM(K4:K7)","v":353.2},{"$f":"SUM(L4:L7)","v":65},{"$f":"SUM(M4:M7)","v":1647.8000000000002}]
["  Total Discounted Price:",null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(M8>=D25,M8*(1-E25),IF(AND(M8<D25,M8>=D24),(1-E24)*M8,IF(AND(M8<D24,M8>=D23),(1-E23)*M8,M8)))","v":1483.0200000000002}]
[]
[null,null,null,null,null,null,null,null,null,"alternative",null,"alternative","alternative"]
["Assumptions",null,null,null,null,null,null,null,null,{"$f":"E4*VLOOKUP(F4,PaintCost,3,0)","v":430},null,{"$f":"VLOOKUP(H4,GradePaint,2,0)*E4","v":129},{"$f":"M8*(1-VLOOKUP(M9,$D$22:$E$25,2))","v":1483.0200000000002}]
["Wall Condition","NO.","Cost primer","Cost of first coat",null,null,null,null,null,{"$f":"E5*VLOOKUP(F5,PaintCost,3,0)","v":288},null,{"$f":"VLOOKUP(H5,GradePaint,2,0)*E5","v":-64}]
["Excellent",1,0,0.45,null,null,null,null,null,{"$f":"E6*VLOOKUP(F6,PaintCost,3,0)","v":212.4},null,{"$f":"VLOOKUP(H6,GradePaint,2,0)*E6","v":0}]
["Reasonable",2,0,0.5,null,null,null,null,null,{"$f":"E7*VLOOKUP(F7,PaintCost,3,0)","v":163.19999999999999},null,{"$f":"VLOOKUP(H7,GradePaint,2,0)*E7","v":0}]
["Poor",3,0.5,0.6]
[]
["Cost per square foot for second coat when poor",0.35]
["New Color Lighter ?",true,false,0.3]
[]
["Grade of Paint","Cost",null,"Discounts"]
["Premium",0.15,null,0,0]
["Economy",-0.1,null,1000,0.1]
["Superior",0,null,2500,0.12]
[null,null,null,5000,0.15]
["High Price",450]

{"sheet":"PO611","index":17,"n_rows":29,"n_cols":9,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["PO 611 Bidder List Financial Evaluation"]
["Customer Name","Net Worth (Dollars)","D&B CCAR (1 Best)","D&B PAYDEX (100 Best)","D&B Stress Risk Class \n(1 Best)","Rule #1","Rule #2","Rule #3","Final Recommendation"]
["BFF Industries",157795,1,90,1,{"$f":"B3>B$16","v":false},{"$f":"AND(C3=B$17,E3=B$18)","v":true},{"$f":"D3>B$19","v":false},{"$f":"IF(NOT(OR(F3:H3)),A$21,IF(OR(AND(F3,NOT(OR(G3:H3))),AND(G3,NOT(OR(F3,H3)))),A$22,A$20))","v":"Get more data"}]
["NRKK ",387000,4,83,3,false,false,false,"Exclude"]
["Pergo Molding",775961,2,98,1,true,false,true,"Allow to bid"]
["Allma",17043973,3,55,2,true,false,false,"Get more data"]
["JF & Sons",35446678,1,32,1,true,true,false,"Allow to bid"]
["Argree Inc.",63545102,3,0,1,true,false,false,"Get more data"]
["RGM Plastics",64831692,2,85,1,true,false,false,"Get more data"]
["Soto Services",182686331,1,73,1,true,true,false,"Allow to bid"]
["NE Plastic",239227375,2,79,2,true,false,false,"Get more data"]
["SPDM",487215654,2,97,1,true,false,true,"Allow to bid"]
[]
[]
["Assumptions (HURDLES)",null,null,"Total outcomes = ",{"$f":"E18^E17","v":8}]
[{"$f":"B2","v":"Net Worth (Dollars)"},500000]
[{"$f":"C2","v":"D&B CCAR (1 Best)"},1,null,"Experiments",3]
[{"$f":"CLEAN(E2)","v":"D&B Stress Risk Class (1 Best)"},1,null,"Outcomes for each experiment",2]
[{"$f":"D2","v":"D&B PAYDEX (100 Best)"},90]
["Allow to bid",null,null,{"$f":"A21","v":"Exclude"},false,false,false]
["Exclude"]
["Get more data",null,null,{"$f":"A22","v":"Get more data"},true,false,false]
[null,null,null,null,false,true,false]
[]
[null,null,null,{"$f":"A20","v":"Allow to bid"},true,true,false]
[null,null,null,null,true,true,true]
[null,null,null,null,false,true,true]
[null,null,null,null,true,false,true]
[null,null,null,null,false,true,true]

{"sheet":"Sheet2","index":18,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Sheet3","index":19,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}