{"text_format":"1","workbook":"xlsx","n_sheets":16,"sheets":["Cover","Date NF & Calcs","Date NF & Calcs (an)","Time NF & Calcs","Time NF & Calcs (an)","TimeSheet","HW ==>>","HW(1)","HW(1an)","HW(2)","HW(2an)","HW(3)","HW(3an)","HW(4)","HW(4an)","Do Formulas See NF"],"not_rendered":{"charts":0,"images":4,"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":"Cover","index":0,"n_rows":18,"n_cols":16,"rows_kept":18,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Excel Basics 10: Date & Time Number Formatting, Formulas, Functions & Calculations"]
[null,"Excel Basics 10: What is Under Date & Time Number Formatting? And How to Make Date & Time Formulas!"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Office 2016 Video #22"]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Topics:"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"1) Date Number Formatting"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2) Number Days Invoice Late Calc"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"3) Number Days in Project Calc"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"4) Loan Maturity Date Calc"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"5) EDATE Function"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6) EOMONTH Function"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"7) Time Number Formatting"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"8) Hours Worked Calc"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"9) Hours Worked Before and After Lunch Calc"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"10) Full Payroll Time Sheet Net Pay Template"]

{"sheet":"Date NF & Calcs","index":1,"n_rows":61,"n_cols":8,"rows_kept":61,"cut":false,"hidden":false,"merged":[]}
["Date Number Formatting: "]
["Under dates, there are serial numbers, which are the number of days since Dec 31, 1899."]
[]
["Date:"]
["Date:"]
["Date:"]
[]
["Date","Actual Number in Cell"]
["1900-01-01",1]
["1900-01-02",2]
["2017-10-28",43036]
[]
["Why? So we can do Date Math!"]
[]
["Invoice due date",null,null,null,"Enter dates with forward slashes (there are other ways also)"]
["Today",null,null,null,"Keyboard for today's date: Ctrl + ;"]
["Days past due",null,null,{"$f":"IF(_xlfn.ISFORMULA(B17),_xlfn.FORMULATEXT(B17),\"\")","v":""},"Important Formula: Days between dates = Later Date - Earlier Date"]
[]
["Invoice due date","2017-09-12"]
["Today",null,null,{"$f":"IF(_xlfn.ISFORMULA(B20),_xlfn.FORMULATEXT(B20),\"\")","v":""},"TODAY function dynamically puts today's date in the cell and updates each new day you open the Workbook file."]
["Days past due",null,null,{"$f":"IF(_xlfn.ISFORMULA(B21),_xlfn.FORMULATEXT(B21),\"\")","v":""},"=TODAY() is an argumentless function"]
[]
["Loan issue date","2017-09-02"]
["Days until loan due",120]
["Maturity Date",null,null,{"$f":"IF(_xlfn.ISFORMULA(B25),_xlfn.FORMULATEXT(B25),\"\")","v":""},"You can add numbers to dates"]
[]
["Project Start Date","2017-10-30"]
["Project End Date","2018-01-13"]
["# days for project",null,null,{"$f":"IF(_xlfn.ISFORMULA(B29),_xlfn.FORMULATEXT(B29),\"\")","v":""},"Important Formula: Days between dates where start date IS included= Later Date - Earlier Date + 1"]
[]
["Calculate the Due Date if the invoice contract says that the amount is due on the same day, two month's ahead."]
[]
["InvoiceDate","2017-10-27",null,null,"Due in 2 Months"]
["Due Date",null,null,{"$f":"IF(_xlfn.ISFORMULA(B34),_xlfn.FORMULATEXT(B34),\"\")","v":""},"EDATE function allows you to take a date and get the same day in a future or past month."]
[null,null,null,null,"=EDATE(Date,2) jumps two months ahead. =EDATE(Date,-2) jumps two months backwards."]
[]
["Calculate the Due Date if the invoice contract says that the amount is due at the end of the month."]
[]
["InvoiceDate","2016-02-03"]
["Due Date",null,null,{"$f":"IF(_xlfn.ISFORMULA(B40),_xlfn.FORMULATEXT(B40),\"\")","v":""},"EOMONTH allows you to take a date get the end of the month date for the current month, a future month, or a past month."]
[null,null,null,null,"=EOMONTH(Date,0) gives you the end of the month"]
[null,null,null,null,"=EOMONTH(Date,1) gives you the end of next month"]
[null,null,null,null,"=EOMONTH(Date,-1) gives you the end of last month."]
[]
[null,null,null,"Customer","Amount Owed","Invoice Due Date","Today","Number Days Invoice Late"]
[null,null,null,"Cicely Lange",2063,"2017-09-18",{"$f":"TODAY()","v":"2019-10-29"},{"$f":"G46-F46","v":771}]
[null,null,null,"Larhonda Goode",2084.5500000000002,"2017-07-02",{"$f":"TODAY()","v":"2019-10-29"},{"$f":"G47-F47","v":849}]
[null,null,null,"Lonna Clemens",1338.51,"2017-09-09","2019-10-29",780]
[null,null,null,"Vanesa Herzog",1967.55,"2017-08-19","2019-10-29",801]
[null,null,null,"Alessandra Reis",2213.87,"2017-10-18","2019-10-29",741]
[null,null,null,"Ashanti Anglin",1570.3,"2017-07-05","2019-10-29",846]
[null,null,null,"Kamala Leyva",1652.3,"2017-10-11","2019-10-29",748]
[null,null,null,"Robena Briseno",1467.72,"2017-07-06","2019-10-29",845]
[null,null,null,"Eryn Huntington",1911.15,"2017-07-19","2019-10-29",832]
[null,null,null,"Clarita Bagwell",597.07000000000005,"2017-08-10","2019-10-29",810]
[null,null,null,"Antwan Steel",608.6,"2017-10-04","2019-10-29",755]
[null,null,null,"Alfonzo Chance",1390.45,"2017-10-15","2019-10-29",744]
[null,null,null,"Muoi Parrish",419.68,"2017-08-12","2019-10-29",808]
[null,null,null,"Chang Teel",1210.17,"2017-10-15","2019-10-29",744]
[null,null,null,"Hsiu Wallis",1815.46,"2017-10-14","2019-10-29",745]
[null,null,null,"Rosalyn Huffman",1803.3,"2017-08-27","2019-10-29",793]

{"sheet":"Date NF & Calcs (an)","index":2,"n_rows":61,"n_cols":8,"rows_kept":61,"cut":false,"hidden":false,"merged":[]}
["Date Number Formatting: "]
["Under dates, there are serial numbers, which are the number of days since Dec 31, 1899."]
[]
["Date:","2017-10-28"]
["Date:",43036]
["Date:","2017-10-28"]
[]
["Date","Actual Number in Cell"]
["1900-01-01",1]
["1900-01-02",2]
["2017-10-28",43036]
[]
["Why? So we can do Date Math!"]
[]
["Invoice due date","2017-09-12",null,null,"Enter dates with forward slashes (there are other ways also)"]
["Today","2017-10-28",null,null,"Keyboard for today's date: Ctrl + ;"]
["Days past due",{"$f":"B16-B15","v":46},null,{"$f":"IF(_xlfn.ISFORMULA(B17),_xlfn.FORMULATEXT(B17),\"\")","v":"=B16-B15"},"Important Formula: Days between dates = Later Date - Earlier Date"]
[]
["Invoice due date","2017-09-12"]
["Today",{"$f":"TODAY()","v":"2019-10-29"},null,{"$f":"IF(_xlfn.ISFORMULA(B20),_xlfn.FORMULATEXT(B20),\"\")","v":"=TODAY()"},"TODAY function dynamically puts today's date in the cell and updates each new day you open the Workbook file."]
["Days past due",{"$f":"B20-B19","v":777},null,{"$f":"IF(_xlfn.ISFORMULA(B21),_xlfn.FORMULATEXT(B21),\"\")","v":"=B20-B19"},"=TODAY() is an argumentless function"]
[]
["Loan issue date","2017-09-02"]
["Days until loan due",120]
["Maturity Date",{"$f":"B23+B24","v":"2017-12-31"},null,{"$f":"IF(_xlfn.ISFORMULA(B25),_xlfn.FORMULATEXT(B25),\"\")","v":"=B23+B24"},"You can add numbers to dates"]
[]
["Project Start Date","2017-10-30"]
["Project End Date","2018-01-13"]
["# days for project",{"$f":"B28-B27+1","v":76},null,{"$f":"IF(_xlfn.ISFORMULA(B29),_xlfn.FORMULATEXT(B29),\"\")","v":"=B28-B27+1"},"Important Formula: Days between dates where start date IS included= Later Date - Earlier Date + 1"]
[]
["Calculate the Due Date if the invoice contract says that the amount is due on the same day, two month's ahead."]
[]
["InvoiceDate","2017-10-27",null,null,"Due in 2 Months"]
["Due Date",{"$f":"EDATE(B33,2)","v":"2017-12-27"},null,{"$f":"IF(_xlfn.ISFORMULA(B34),_xlfn.FORMULATEXT(B34),\"\")","v":"=EDATE(B33,2)"},"EDATE function allows you to take a date and get the same day in a future or past month."]
[null,null,null,null,"=EDATE(Date,2) jumps two months ahead. =EDATE(Date,-2) jumps two months backwards."]
[]
["Calculate the Due Date if the invoice contract says that the amount is due at the end of the month."]
[]
["InvoiceDate","2016-02-03"]
["Due Date",{"$f":"EOMONTH(B39,0)","v":"2016-02-29"},null,{"$f":"IF(_xlfn.ISFORMULA(B40),_xlfn.FORMULATEXT(B40),\"\")","v":"=EOMONTH(B39,0)"},"EOMONTH allows you to take a date get the end of the month date for the current month, a future month, or a past month."]
[null,null,null,null,"=EOMONTH(Date,0) gives you the end of the month"]
[null,null,null,null,"=EOMONTH(Date,1) gives you the end of next month"]
[null,null,null,null,"=EOMONTH(Date,-1) gives you the end of last month."]
[]
[null,null,null,"Customer","Amount Owed","Invoice Due Date","Today","Number Days Invoice Late"]
[null,null,null,"Cicely Lange",2063,"2017-09-18",{"$f":"TODAY()","v":"2019-10-29"},{"$f":"G46-F46","v":771}]
[null,null,null,"Larhonda Goode",2084.5500000000002,"2017-07-02",{"$f":"TODAY()","v":"2019-10-29"},{"$f":"G47-F47","v":849}]
[null,null,null,"Lonna Clemens",1338.51,"2017-09-09","2019-10-29",780]
[null,null,null,"Vanesa Herzog",1967.55,"2017-08-19","2019-10-29",801]
[null,null,null,"Alessandra Reis",2213.87,"2017-10-18","2019-10-29",741]
[null,null,null,"Ashanti Anglin",1570.3,"2017-07-05","2019-10-29",846]
[null,null,null,"Kamala Leyva",1652.3,"2017-10-11","2019-10-29",748]
[null,null,null,"Robena Briseno",1467.72,"2017-07-06","2019-10-29",845]
[null,null,null,"Eryn Huntington",1911.15,"2017-07-19","2019-10-29",832]
[null,null,null,"Clarita Bagwell",597.07000000000005,"2017-08-10","2019-10-29",810]
[null,null,null,"Antwan Steel",608.6,"2017-10-04","2019-10-29",755]
[null,null,null,"Alfonzo Chance",1390.45,"2017-10-15","2019-10-29",744]
[null,null,null,"Muoi Parrish",419.68,"2017-08-12","2019-10-29",808]
[null,null,null,"Chang Teel",1210.17,"2017-10-15","2019-10-29",744]
[null,null,null,"Hsiu Wallis",1815.46,"2017-10-14","2019-10-29",745]
[null,null,null,"Rosalyn Huffman",1803.3,"2017-08-27","2019-10-29",793]

{"sheet":"Time NF & Calcs","index":3,"n_rows":53,"n_cols":8,"rows_kept":53,"cut":false,"hidden":false,"merged":[]}
["Time Number Format:"]
["Under the Time Number Format is a serial number that represents the proportion of one 24-hour day"]
["Time serial number = Proportion of the 24 hour day"]
[]
["Enter time as: hours, colon, minutes, colon, seconds, then a space, and AM or PM (there are other methods also)"]
[]
["Enter 8:00 AM Time ==>>"]
["Enter 8:00 AM Again ==>>\nThen Apply General NF"]
["Type formula =8/24",null,null,null,"Apply General Number Format = Ctrl + Shift + ~"]
["Type formula Again ==>>\nThen Time NF ==>>"]
[]
["Time","Proportion of 24 hour day","Reduced to:","Reduced to:","Actual Number in Cell"]
["00:00:00",0,null,null,{"$f":"A13","v":0}]
["08:00:00",{"$f":"8/24","v":0.33333333333333331},{"$f":"1/3","v":0.33333333333333331},null,{"$f":"8/24","v":0.33333333333333331}]
["12:00:00",{"$f":"12/24","v":0.5},{"$f":"1/2","v":0.5},null,{"$f":"12/24","v":0.5}]
["15:00:00","(12+3)/24",{"$f":"15/24","v":0.625},{"$f":"15/24","v":0.625},{"$f":"15/24","v":0.625}]
["15:15:00","(12+3.25)/24",null,null,0.63541666666666663]
[]
["Notice that we took a number and divided by 24!!!!"]
["This means that if we want to do Time Math and get hours as a result, we must multiply the decimal time answer by 24!!!!"]
[]
["Wage per hour",21.25]
["Time In"]
["Time Out"]
["Total Hours worked",null,{"$f":"IF(_xlfn.ISFORMULA(B25),_xlfn.FORMULATEXT(B25),\"\")","v":""},"Important Formula: Hours Worked = (Later Time - Earlier Time)*24"]
["Gross Pay",null,{"$f":"IF(_xlfn.ISFORMULA(B26),_xlfn.FORMULATEXT(B26),\"\")","v":""}]
[]
["Homework tracker:"]
["Start Time","08:30:00"]
["End Time","11:00:00"]
["Hours worked",null,{"$f":"IF(_xlfn.ISFORMULA(B31),_xlfn.FORMULATEXT(B31),\"\")","v":""}]
["Start Time","22:00:00"]
["End Time","23:15:00"]
["Hours worked",null,{"$f":"IF(_xlfn.ISFORMULA(B34),_xlfn.FORMULATEXT(B34),\"\")","v":""}]
["Total",null,""]
[null,"or"]
["Total",null,{"$f":"IF(_xlfn.ISFORMULA(B37),_xlfn.FORMULATEXT(B37),\"\")","v":""}]
[]
[]
[null,null,null,null,null,null,"Tax Rate"]
["Payroll Example:",null,null,null,null,null,7.6499999999999999E-2]
[]
["Employee","Wage","Time In","Time Out","Hours Worked","Gross Pay","Deduction","Day's Pay"]
["Carroll  Stanley",24.94,"08:00:00","15:30:00"]
["Anne  Ramos",18.14,"09:00:00","14:25:00"]
["Blanche  Sanchez",17.940000000000001,"07:30:00","15:15:00"]
["Karla  Fletcher",26.7,"08:00:00","14:10:00"]
["Devin  Smith",24.3,"09:00:00","14:30:00"]
["Edna  Hansen",22.85,"08:00:00","16:45:00"]
["Moses  Swanson",26.98,"06:30:00","11:35:00"]
["Sherman  Moss",17.71,"08:00:00","13:00:00"]
["Amber  Rios",20.12,"07:00:00","16:30:00"]
["Lindsey  Powers",23.69,"08:00:00","15:00:00"]

{"sheet":"Time NF & Calcs (an)","index":4,"n_rows":53,"n_cols":8,"rows_kept":53,"cut":false,"hidden":false,"merged":[]}
["Time Number Format:"]
["Under the Time Number Format is a serial number that represents the proportion of one 24-hour day"]
["Time serial number = Proportion of the 24 hour day"]
[]
["Enter time as: hours, colon, minutes, colon, seconds, then a space, and AM or PM (there are other methods also)"]
[]
["Enter 8:00 AM Time ==>>","08:00:00",null,"2017-12-02"]
["Enter 8:00 AM Again ==>>\nThen Apply General NF",0.33333333333333331,null,"12?2/2017"]
["Type formula =8/24",{"$f":"8/24","v":0.33333333333333331},null,null,"Apply General Number Format = Ctrl + Shift + ~"]
["Type formula Again ==>>\nThen Time NF ==>>",{"$f":"8/24","v":"08:00:00"}]
[]
["Time","Proportion of 24 hour day","Reduced to:","Reduced to:","Actual Number in Cell"]
["00:00:00",0,null,null,{"$f":"A13","v":0}]
["08:00:00",{"$f":"8/24","v":0.33333333333333331},{"$f":"1/3","v":0.33333333333333331},null,{"$f":"8/24","v":0.33333333333333331}]
["12:00:00",{"$f":"12/24","v":0.5},{"$f":"1/2","v":0.5},null,{"$f":"12/24","v":0.5}]
["15:00:00","(12+3)/24",{"$f":"15/24","v":0.625},{"$f":"15/24","v":0.625},{"$f":"15/24","v":0.625}]
["15:15:00","(12+3.25)/24",null,null,0.63541666666666663]
[]
["Notice that we took a number and divided by 24!!!!"]
["This means that if we want to do Time Math and get hours as a result, we must multiply the decimal time answer by 24!!!!"]
[]
["Wage per hour",21.25]
["Time In","08:00:00"]
["Time Out","12:00:00"]
["Total Hours worked",{"$f":"(B24-B23)*24","v":4},{"$f":"IF(_xlfn.ISFORMULA(B25),_xlfn.FORMULATEXT(B25),\"\")","v":"=(B24-B23)*24"},"Important Formula: Hours Worked = (Later Time - Earlier Time)*24"]
["Gross Pay",{"$f":"B25*B22","v":85},{"$f":"IF(_xlfn.ISFORMULA(B26),_xlfn.FORMULATEXT(B26),\"\")","v":"=B25*B22"}]
[]
["Homework tracker:"]
["Start Time","08:30:00"]
["End Time","11:00:00"]
["Hours worked",{"$f":"(B30-B29)*24","v":2.4999999999999991},{"$f":"IF(_xlfn.ISFORMULA(B31),_xlfn.FORMULATEXT(B31),\"\")","v":"=(B30-B29)*24"}]
["Start Time","22:00:00"]
["End Time","23:15:00"]
["Hours worked",{"$f":"(B33-B32)*24","v":1.2500000000000009},{"$f":"IF(_xlfn.ISFORMULA(B34),_xlfn.FORMULATEXT(B34),\"\")","v":"=(B33-B32)*24"}]
["Total",{"$f":"B34+B31","v":3.75},"=B34+B31"]
[null,"or"]
["Total",{"$f":"SUM(B30-B29,B33-B32)*24","v":3.75},{"$f":"IF(_xlfn.ISFORMULA(B37),_xlfn.FORMULATEXT(B37),\"\")","v":"=SUM(B30-B29,B33-B32)*24"}]
[]
[]
[null,null,null,null,null,null,"Tax Rate"]
["Payroll Example:",null,null,null,null,null,7.6499999999999999E-2]
[]
["Employee","Wage","Time In","Time Out","Hours Worked","Gross Pay","Deduction","Day's Pay"]
["Carroll  Stanley",24.94,"08:00:00","15:30:00",{"$f":"(D44-C44)*24","v":7.5000000000000018},{"$f":"ROUND(E44*B44,2)","v":187.05},{"$f":"ROUND(F44*$G$41,2)","v":14.31},{"$f":"F44-G44","v":172.74}]
["Anne  Ramos",18.14,"09:00:00","14:25:00",{"$f":"(D45-C45)*24","v":5.4166666666666661},{"$f":"ROUND(E45*B45,2)","v":98.26},{"$f":"ROUND(F45*$G$41,2)","v":7.52},{"$f":"F45-G45","v":90.740000000000009}]
["Blanche  Sanchez",17.940000000000001,"07:30:00","15:15:00",7.7499999999999991,139.04,10.64,128.39999999999998]
["Karla  Fletcher",26.7,"08:00:00","14:10:00",6.1666666666666679,164.65,12.6,152.05000000000001]
["Devin  Smith",24.3,"09:00:00","14:30:00",5.5000000000000018,133.65,10.220000000000001,123.43]
["Edna  Hansen",22.85,"08:00:00","16:45:00",8.75,199.94,15.3,184.64]
["Moses  Swanson",26.98,"06:30:00","11:35:00",5.0833333333333339,137.15,10.49,126.66000000000001]
["Sherman  Moss",17.71,"08:00:00","13:00:00",5,88.55,6.77,81.78]
["Amber  Rios",20.12,"07:00:00","16:30:00",9.5000000000000018,191.14,14.62,176.51999999999998]
["Lindsey  Powers",23.69,"08:00:00","15:00:00",7,165.83,{"$f":"ROUND(F53*$G$41,2)","v":12.69},153.14000000000001]

{"sheet":"TimeSheet","index":5,"n_rows":14,"n_cols":8,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,"Tax Rate"]
[null,null,null,null,null,null,7.6499999999999999E-2]
[]
["Employee","Wage","Time In","Time Out","Hours Worked","Gross Pay","Deduction","Day's Pay"]
["Carroll  Stanley",24.94,"08:00:00","15:30:00",{"$f":"(D5-C5)*24","v":7.5000000000000018},{"$f":"ROUND(E5*B5,2)","v":187.05},{"$f":"ROUND(F5*$G$2,2)","v":14.31},{"$f":"F5-G5","v":172.74}]
["Anne  Ramos",18.14,"09:00:00","14:30:00",5.5000000000000018,99.77,{"$f":"ROUND(F6*$G$2,2)","v":7.63},92.14]
["Blanche  Sanchez",17.940000000000001,"07:30:00","15:00:00",7.5000000000000027,134.55000000000001,10.29,124.26000000000002]
["Karla  Fletcher",26.7,"08:00:00","13:30:00",5.5,146.85,11.23,135.62]
["Devin  Smith",24.3,"09:00:00","14:30:00",5.5000000000000018,133.65,10.220000000000001,123.43]
["Edna  Hansen",22.85,"08:00:00","18:00:00",10,228.5,17.48,211.02]
["Moses  Swanson",26.98,"06:30:00","11:30:00",5,134.9,10.32,124.58000000000001]
["Sherman  Moss",17.71,"08:00:00","13:00:00",5,88.55,6.77,81.78]
["Amber  Rios",20.12,"07:00:00","16:30:00",9.5000000000000018,191.14,14.62,176.51999999999998]
["Lindsey  Powers",23.69,"08:00:00","15:00:00",7,165.83,12.69,153.14000000000001]

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

{"sheet":"HW(1)","index":7,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["In the below table, create a formula for today's date and then calculate the number of days the invoice is late."]
[]
[]
["Customer","Invoice #","Amount Owed","Invoice Due Date","Today","Number Days Invoice Late"]
["Ossie Kimbrough",2693,181.82,"2017-08-19"]
["Adrien Dougherty",3319,303.89,"2017-06-26"]
["Elwood Koehler",3587,177.74,"2017-08-22"]
["Senaida Battles",3950,315.25,"2017-08-14"]
["Claudette Barela",3903,761.62,"2017-09-16"]
["Providencia Esposito",3222,759.31,"2017-06-23"]
["Corliss Coffin",3459,581.59,"2017-09-14"]
["Rafaela Sparkman",3247,227.66,"2017-06-09"]
["Marvis Block",3092,459.95,"2017-07-02"]
["Drucilla Ragsdale",2867,574.95000000000005,"2017-07-18"]

{"sheet":"HW(1an)","index":8,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["In the below table, create a formula for today's date and then calculate the number of days the invoice is late."]
[]
[]
["Customer","Invoice #","Amount Owed","Invoice Due Date","Today","Number Days Invoice Late"]
["Ossie Kimbrough",2693,181.82,"2017-08-19",{"$f":"TODAY()","v":"2019-10-29"},{"$f":"E5-D5","v":801}]
["Adrien Dougherty",3319,303.89,"2017-06-26",{"$f":"TODAY()","v":"2019-10-29"},855]
["Elwood Koehler",3587,177.74,"2017-08-22","2019-10-29",798]
["Senaida Battles",3950,315.25,"2017-08-14","2019-10-29",806]
["Claudette Barela",3903,761.62,"2017-09-16","2019-10-29",773]
["Providencia Esposito",3222,759.31,"2017-06-23","2019-10-29",858]
["Corliss Coffin",3459,581.59,"2017-09-14","2019-10-29",775]
["Rafaela Sparkman",3247,227.66,"2017-06-09","2019-10-29",872]
["Marvis Block",3092,459.95,"2017-07-02","2019-10-29",849]
["Drucilla Ragsdale",2867,574.95000000000005,"2017-07-18","2019-10-29",833]

{"sheet":"HW(2)","index":9,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["In the below table, create a formula to calcualte Number of Days in Project."]
[]
[]
["Project Address","Projected Start Date","Projected End Date","Number Of Days in Project"]
["9664 SE. Thomas St. ","2018-02-18","2018-04-28"]
["92 Middle River Ave. ","2017-11-27","2018-07-04"]
["7275 Belmont Lane ","2018-03-08","2018-11-12"]
["9504 Grand St. ","2017-12-01","2018-06-16"]
["8016 Applegate Court ","2018-02-10","2018-03-24"]
["8 Canal Ave. ","2018-01-23","2018-03-18"]
["28 Green Hill Lane ","2018-01-28","2018-03-04"]
["26 West Purple Finch Ave. ","2017-12-17","2018-08-06"]
["180 Augusta Ave. ","2017-10-22","2018-04-11"]
["77 S. Sleepy Hollow Drive ","2018-01-08","2018-09-02"]

{"sheet":"HW(2an)","index":10,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["In the below table, create a formula to calcualte Number of Days in Project."]
[]
[]
["Project Address","Projected Start Date","Projected End Date","Number Of Days in Project"]
["9664 SE. Thomas St. ","2018-02-18","2018-04-28",{"$f":"C5-B5+1","v":70}]
["92 Middle River Ave. ","2017-11-27","2018-07-04",220]
["7275 Belmont Lane ","2018-03-08","2018-11-12",250]
["9504 Grand St. ","2017-12-01","2018-06-16",198]
["8016 Applegate Court ","2018-02-10","2018-03-24",43]
["8 Canal Ave. ","2018-01-23","2018-03-18",55]
["28 Green Hill Lane ","2018-01-28","2018-03-04",36]
["26 West Purple Finch Ave. ","2017-12-17","2018-08-06",233]
["180 Augusta Ave. ","2017-10-22","2018-04-11",172]
["77 S. Sleepy Hollow Drive ","2018-01-08","2018-09-02",238]

{"sheet":"HW(3)","index":11,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Using one of Excel's Date Functions, calculate the Due Date if the invoice contract says that the amount is due on the same day, two month's ahead."]
[]
["InvoiceDate","2017-11-03"]
["Due Date"]
[]
["Using one of Excel's Date Functions, calculate the Due Date if the invoice contract says that the amount is due at the end of the month."]
[]
["InvoiceDate","2017-11-03"]
["Due Date"]

{"sheet":"HW(3an)","index":12,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["Using one of Excel's Date Functions, calculate the Due Date if the invoice contract says that the amount is due on the same day, two month's ahead."]
[]
["InvoiceDate","2017-11-03"]
["Due Date",{"$f":"EDATE(B3,2)","v":"2018-01-03"}]
[]
["Using one of Excel's Date Functions, calculate the Due Date if the invoice contract says that the amount is due at the end of the month."]
[]
["InvoiceDate","2017-11-03"]
["Due Date",{"$f":"EOMONTH(B8,0)","v":"2017-11-30"}]

{"sheet":"HW(4)","index":13,"n_rows":16,"n_cols":8,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[{"$f":"\"Create the formulas for the following columns: \"&E6&\" \"&F6&\" \"&G6&\" \"&H6","v":"Create the formulas for the following columns: Hours Worked Gross Pay Deduction Day's Pay"}]
[]
[null,null,null,null,null,null,"Tax Rate"]
[null,null,null,null,null,null,7.6499999999999999E-2]
[]
["Employee","Wage","Time In","Time Out","Hours Worked","Gross Pay","Deduction","Day's Pay"]
["Carroll  Stanley",24.94,"08:00:00","15:30:00"]
["Anne  Ramos",18.14,"09:00:00","14:30:00"]
["Blanche  Sanchez",17.940000000000001,"07:30:00","15:00:00"]
["Karla  Fletcher",26.7,"08:00:00","13:30:00"]
["Devin  Smith",24.3,"09:00:00","14:30:00"]
["Edna  Hansen",22.85,"08:00:00","18:00:00"]
["Moses  Swanson",26.98,"06:30:00","11:30:00"]
["Sherman  Moss",17.71,"08:00:00","13:00:00"]
["Amber  Rios",20.12,"07:00:00","16:30:00"]
["Lindsey  Powers",23.69,"08:00:00","15:00:00"]

{"sheet":"HW(4an)","index":14,"n_rows":16,"n_cols":8,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[{"$f":"\"Create the formulas for the following columns: \"&E6&\" \"&F6&\" \"&G6&\" \"&H6","v":"Create the formulas for the following columns: Hours Worked Gross Pay Deduction Day's Pay"}]
[]
[null,null,null,null,null,null,"Tax Rate"]
[null,null,null,null,null,null,7.6499999999999999E-2]
[]
["Employee","Wage","Time In","Time Out","Hours Worked","Gross Pay","Deduction","Day's Pay"]
["Carroll  Stanley",24.94,"08:00:00","15:30:00",{"$f":"(D7-C7)*24","v":7.5000000000000018},{"$f":"ROUND(E7*B7,2)","v":187.05},{"$f":"ROUND(F7*$G$4,2)","v":14.31},{"$f":"F7-G7","v":172.74}]
["Anne  Ramos",18.14,"09:00:00","14:30:00",5.5000000000000018,99.77,{"$f":"ROUND(F8*$G$4,2)","v":7.63},92.14]
["Blanche  Sanchez",17.940000000000001,"07:30:00","15:00:00",7.5000000000000027,134.55000000000001,10.29,124.26000000000002]
["Karla  Fletcher",26.7,"08:00:00","13:30:00",5.5,146.85,11.23,135.62]
["Devin  Smith",24.3,"09:00:00","14:30:00",5.5000000000000018,133.65,10.220000000000001,123.43]
["Edna  Hansen",22.85,"08:00:00","18:00:00",10,228.5,17.48,211.02]
["Moses  Swanson",26.98,"06:30:00","11:30:00",5,134.9,10.32,124.58000000000001]
["Sherman  Moss",17.71,"08:00:00","13:00:00",5,88.55,6.77,81.78]
["Amber  Rios",20.12,"07:00:00","16:30:00",9.5000000000000018,191.14,14.62,176.51999999999998]
["Lindsey  Powers",23.69,"08:00:00","15:00:00",7,165.83,12.69,153.14000000000001]

{"sheet":"Do Formulas See NF","index":15,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Do Formulas \"see\" Number Formatting?"]
[]
["Price","Quantity","Total"]
[99.5,2,{"$f":"B4*A4","v":199},null,"Solution: Increase Decimal on Price so Formatting does not mislead you."]
[]
["Payroll:"]
["Employee","Gross Pay","Tax Deduction","Tax Deduction"]
["Lillian  Holt",689.25,{"$f":"B8*$B$13","v":52.727624999999996},{"$f":"ROUND(B8*$B$13,2)","v":52.73}]
["Jasmine  Phelps",765.71,{"$f":"B9*$B$13","v":58.576815000000003},{"$f":"ROUND(B9*$B$13,2)","v":58.58}]
["Sadie  Hudson",687.43,{"$f":"B10*$B$13","v":52.588394999999998},{"$f":"ROUND(B10*$B$13,2)","v":52.59}]
[null,"Total",{"$f":"SUM(C8:C10)","v":163.89283499999999},{"$f":"SUM(D8:D10)","v":163.9}]
[]
["Tax Rate",7.6499999999999999E-2]
[]
["Solution: Because we are adding with SUM function, and we have extra decimals past penny position, we MUST use ROUND."]