{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["NO","SimilarToHWExcelProject2","SimilarToHWExcelProject2 (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":"NO","index":0,"n_rows":22,"n_cols":12,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["Office 2013 Class #40: Excel Basics 22:"]
["Excel’s Golden Rule"]
["If a formula input can change, put it into a cell and refer to it with a cell reference."]
["If it will not change, you can type it into a formula."]
[null,null,null,null,null,null,null,null,null,null,"Okay to type formula inputs into formulas:"]
["Employee","Dependents","Hourly\r\nWage","Hours\r Worked\nFor 2 Weeks","Gross Pay","Federal Tax","State Tax","Overall Tax Rate","Net Pay",null,"Yearly Expense",5000]
["Jerald  Lucas",1,22,66.739999999999995,{"$f":"C7*D7","v":1468.28},{"$f":"(E7-25.15*B7)*0.2","v":288.62599999999998},{"$f":"E7*0.05","v":73.414000000000001},{"$f":"SUM(F7:G7)/E7","v":0.24657422290026423},{"$f":"E7-SUM(F7:G7)","v":1106.24},null,"Monthly Expense",{"$f":"L6/12","v":416.66666666666669}]
["Wilma  Frank",3,29.59,45.5,{"$f":"C8*D8","v":1346.345},{"$f":"(E8-25.15*B8)*0.2","v":254.179},{"$f":"E8*0.05","v":67.317250000000001},{"$f":"SUM(F8:G8)/E8","v":0.23879187726771373},{"$f":"E8-SUM(F8:G8)","v":1024.8487500000001}]
["Tammy  Rodgers",4,22.21,48.46,1076.2966000000001,195.13932000000003,53.814830000000008,0.23130626817923608,827.3424500000001,null,"Time In","08:00:00"]
["Bradley  Bush",2,28.06,70.959999999999994,1991.1375999999998,388.16751999999997,99.556879999999992,0.24494761185766367,1503.4132,null,"Time Out","14:00:00"]
["Justin  Gonzales",3,20.11,51.52,1036.0672,192.12343999999999,51.803359999999998,0.23543530767116264,792.1404,null,"Hours Worked",{"$f":"(L10-L9)*24","v":6.0000000000000018}]
["Rodney  Nguyen",4,24.02,48.53,1165.6905999999999,213.01812000000001,58.284529999999997,0.23273984537577985,894.38794999999982]
["Marco  Hamilton",3,23.8,49.08,1168.104,218.5308,58.405200000000008,0.23708162971790187,891.16800000000001]
["Connie  Bowman",2,23.25,64.02,1488.4649999999999,287.63299999999998,74.423249999999996,0.24324135938701952,1126.4087500000001]
["Donald  Jacobs",4,22.06,56.13,1238.2277999999999,227.52556000000001,61.911389999999997,0.23375097054031579,948.79084999999986]
["Total",null,null,{"$f":"SUM(D7:D15)","v":500.93999999999988},11978.613799999999,2264.9427599999999,598.93068999999991,null,9114.74035]
[]
["1) If you are multiplying and dividing decimals AND",null,null,null,null,"Assumption Table (Formula Inputs)"]
["using formula result in subsequent formulas, you must use ROUND.",null,null,null,null,"Fed Tax Rate","State Tax Rate"]
["2) If a formula input can change,",null,null,null,null,0.2,0.05]
["put it in cell and refer to it with cell reference.",null,null,null,null,"Exemption amount"]
[null,null,null,null,null,25.15]

{"sheet":"SimilarToHWExcelProject2","index":1,"n_rows":17,"n_cols":9,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Employee","Dependents","Hourly\r\nWage","Hours\r Worked\nFor 2 Weeks","Gross Pay","Federal Tax","State Tax","Overall Tax Rate","Net Pay"]
["Jerald  Lucas",1,22,66.739999999999995,null,null,null,{"$f":"IF(COUNT(E2:G2)=3,SUM(F2:G2)/E2,\"\")","v":""},{"$f":"E2-SUM(F2:G2)","v":0}]
["Wilma  Frank",3,29.59,45.5,null,null,null,{"$f":"IF(COUNT(E3:G3)=3,SUM(F3:G3)/E3,\"\")","v":""},{"$f":"E3-SUM(F3:G3)","v":0}]
["Tammy  Rodgers",4,22.21,48.46,null,null,null,"",0]
["Bradley  Bush",2,28.06,70.959999999999994,null,null,null,"",0]
["Justin  Gonzales",3,20.11,51.52,null,null,null,"",0]
["Rodney  Nguyen",4,24.02,48.53,null,null,null,"",0]
["Marco  Hamilton",3,23.8,49.08,null,null,null,"",0]
["Connie  Bowman",2,23.25,64.02,null,null,null,"",0]
["Donald  Jacobs",4,22.06,56.13,null,null,null,"",0]
["Total",null,null,{"$f":"SUM(D2:D10)","v":500.93999999999988},0,0,0,null,{"$f":"SUM(I2:I10)","v":0}]
[]
[null,null,null,null,null,"Assumption Table (Formula Inputs)"]
[null,null,null,null,null,"Fed Tax Rate","State Tax Rate"]
[null,null,null,null,null,0.2,0.05]
[null,null,null,null,null,"Exemption amount"]
[null,null,null,null,null,25.15]

{"sheet":"SimilarToHWExcelProject2 (an)","index":2,"n_rows":17,"n_cols":9,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
["Employee","Dependents","Hourly\r\nWage","Hours\r Worked\nFor 2 Weeks","Gross Pay","Federal Tax","State Tax","Overall Tax Rate","Net Pay"]
["Jerald  Lucas",1,22,66.739999999999995,{"$f":"ROUND(D2*C2,2)","v":1468.28},{"$f":"ROUND((E2-B2*$F$17)*$F$15,2)","v":288.63},{"$f":"ROUND(E2*$G$15,2)","v":73.41},{"$f":"SUM(F2:G2)/E2","v":0.24657422290026423},{"$f":"E2-SUM(F2:G2)","v":1106.24}]
["Wilma  Frank",3,29.59,45.5,{"$f":"ROUND(D3*C3,2)","v":1346.35},254.18,67.319999999999993,{"$f":"SUM(F3:G3)/E3","v":0.23879377576410296},{"$f":"E3-SUM(F3:G3)","v":1024.8499999999999}]
["Tammy  Rodgers",4,22.21,48.46,1076.3,195.14,53.82,0.23131097277710674,827.33999999999992]
["Bradley  Bush",2,28.06,70.959999999999994,1991.14,388.17,99.56,0.24495012907178801,1503.41]
["Justin  Gonzales",3,20.11,51.52,1036.07,192.12,51.8,0.23542810813941145,792.14999999999986]
["Rodney  Nguyen",4,24.02,48.53,1165.69,213.02,58.28,0.2327376918391682,894.3900000000001]
["Marco  Hamilton",3,23.8,49.08,1168.0999999999999,218.53,58.41,0.23708586593613562,891.15999999999985]
["Connie  Bowman",2,23.25,64.02,1488.47,287.63,74.42,0.2432363433592884,1126.42]
["Donald  Jacobs",4,22.06,56.13,1238.23,227.53,61.91,0.23375301842145643,948.79]
["Total",null,null,{"$f":"SUM(D2:D10)","v":500.93999999999988},11978.63,2264.9499999999998,598.92999999999995,null,{"$f":"SUM(I2:I10)","v":9114.75}]
[]
[null,null,null,null,null,"Assumption Table (Formula Inputs)"]
[null,null,null,null,null,"Fed Tax Rate","State Tax Rate"]
[null,null,null,null,null,0.2,0.05]
[null,null,null,null,null,"Exemption amount"]
[null,null,null,null,null,25.15]