{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Enter Time","Auditors","AuditTitles&Numbers","AuditObjectives","Dates of Completion","Pictures"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":11,"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":"Enter Time","index":0,"n_rows":23,"n_cols":18,"rows_kept":23,"cut":false,"hidden":false,"merged":[[2,2,2,3],[1,4,1,8],[1,9,1,13],[2,0,6,0]]}
[]
["  ",null,null,null,"Week 1 of Pay Period",null,null,null,null,"Week 2 of Pay Period",null,null,null,null,null,null,null," "]
["****Certain objects in the userforms are not available in the some years of excel. This may be an issue for users outside of the audit bureau","Audit Number","Work Code",null,"Monday","Tuesday","Wednesday","Thursday","Friday","Monday","Tuesday","Wednesday","Thursday","Friday"]
[null,null,"01","Staff Meeting"]
[null,null,"02","Training"]
[null,null,"03","Management"]
[null,null,"04","Leave"]
["Primary Audit:","15-15","05","Pre-Audit"]
["Secondary Audit:","15-14","05","Pre-Audit"]
[null,{"$f":"IF($B$8<>\"\",$B$8,\"\")","v":"15-15"},"06","Field Work"]
[null,{"$f":"IF($B$9<>\"\",$B$9,\"\")","v":"15-14"},"06","Field Work"]
[null,{"$f":"IF($B$8<>\"\",$B$8,\"\")","v":"15-15"},"07","Writing"]
[null,{"$f":"IF($B$9<>\"\",$B$9,\"\")","v":"15-14"},"07","Writing"]
[null,{"$f":"IF($B$8<>\"\",$B$8,\"\")","v":"15-15"},"08","Documentation"]
[null,{"$f":"IF($B$9<>\"\",$B$9,\"\")","v":"15-14"},"08","Documentation"]
[null,{"$f":"IF($B$8<>\"\",$B$8,\"\")","v":"15-15"},"09","Compliance"]
[null,{"$f":"IF($B$9<>\"\",$B$9,\"\")","v":"15-14"},"09","Compliance"]
[null,{"$f":"IF($B$8<>\"\",$B$8,\"\")","v":"15-15"},"10","Presentation"]
[null,{"$f":"IF($B$9<>\"\",$B$9,\"\")","v":"15-14"},"10","Presentation"]
[null,{"$f":"IF($B$8<>\"\",$B$8,\"\")","v":"15-15"},"11","Follow-Up"]
[null,{"$f":"IF($B$9<>\"\",$B$9,\"\")","v":"15-14"},"11","Follow-Up"]
[null,"15-04",12,"Auditor Assist/Other"]
[null,null,null,"Totals:",{"$f":"SUM(E4:E22)","v":0},0,0,0,0,0,{"$f":"SUM(K4:K22)","v":0},0,0,0]

{"sheet":"Auditors","index":1,"n_rows":2,"n_cols":2,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["Name","Employee ID"]
["Kyle Condie","194013"]

{"sheet":"AuditTitles&Numbers","index":2,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Audit Number","Audit Title"]
["15-04","Test 3"]
["15-02","Test 2"]
["15-15","Test run"]

{"sheet":"AuditObjectives","index":3,"n_rows":7,"n_cols":11,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
["Audit Number","Audit Objectives",null,null,null,null,null,null,"Audit Number:","15-15","obj 1"]
["15-15","obj 1",null,null,null,null,null,null,null,null,2222]
["15-15","2222",null,null,null,null,null,null,null,null,3333]
["15-15","3333",null,null,null,null,null,null,null,null,4444]
["15-15","4444",null,null,null,null,null,null,null,null,6666]
["15-15","6666",null,null,null,null,null,null,null,null,7777]
["15-15","7777"]

{"sheet":"Dates of Completion","index":4,"n_rows":4,"n_cols":6,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Audit Number","Pre Audit Survey Hours","Pre Audit Survey Completion Date","Audit Program Hours","Audit Program Completion Date","Audit Report Hours"]
["15-04",null,null,null,null,""]
["15-02",248,"2015-04-09",564,"2015-07-09"]
["15-15",15,"2015-04-17",25,"2015-04-24","10"]

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