{"text_format":"3","workbook":"xlsx","n_sheets":53,"sheets":["Summary","Week 1","Week 2","Week 3","Week 4","Week 5","Week 6","Week 7","Week 8","Week 9","Week 10","Week 11","Week 12","Week 13","Week 14","Week 15","Week 16","Week 17","Week 18","Week 19","Week 20","Week 21","Week 22","Week 23","Week 24","Week 25","Week 26","Week 27","Week 28","Week 29","Week 30","Week 31","Week 32","Week 33","Week 34","Week 35","Week 36","Week 37","Week 38","Week 39","Week 40","Week 41","Week 42","Week 43","Week 44","Week 45","Week 46","Week 47","Week 48","Week 49","Week 50","Week 51","Week 52"],"not_rendered":{"defined_names":106},"read":"whole","date_system":"1900"}

{"sheet":"Summary","index":0,"n_rows":42,"n_cols":5,"rows_kept":42}
["SURVEY PROGRESS REPORT SUMMARY / MANDAY REPORT                               "]
[{"$f":"'Week 1'!A2","v":"<< name>>"},{"$f":"'Week 1'!B2","v":"<< title >>"}]
[{"$f":"'Week 1'!A3","v":"<< address >>"}]
["               "]
["No. of Weeks:",{"$f":"CEILING((B6-B17)/7,1)","v":0}]
["Last Work:",{"$f":"'Week 52'!B6","v":"2011-12-02"}]
["Proj. No.:",{"$f":"'Week 1'!B7","v":0},null,"Route:",{"$f":"'Week 1'!E7","v":0}]
["County:",{"$f":"'Week 1'!B8","v":0}]
["Length (miles):",{"$f":"'Week 1'!B9","v":0}]
["From Sta:",{"$f":"'Week 1'!B10","v":0},null,"To Sta:",{"$f":"'Week 1'!E10","v":0}]
[]
["From:",{"$f":"'Week 1'!B12","v":0}]
["To:",{"$f":"'Week 1'!B13","v":0}]
[]
["Project Filename:",{"$f":"'Week 1'!B15","v":0}]
["Data Collector Filename:",{"$f":"'Week 1'!B16","v":0}]
["Date Survey Began:",{"$f":"'Week 1'!B17","v":"2011-12-02"}]
[]
[]
[]
[null,"To Date","% Complete"]
["Control Traverse",{"$f":"'Week 52'!D22","v":{"v":0,"d":"0.00"}},{"$f":"'Week 52'!E22","v":0}]
["Alignment",{"$f":"'Week 52'!D23","v":{"v":0,"d":"0.00"}},{"$f":"'Week 52'!E23","v":0}]
["Terrain Model",{"$f":"'Week 52'!D24","v":{"v":0,"d":"0.00"}},{"$f":"'Week 52'!E24","v":0}]
["Topography",{"$f":"'Week 52'!D25","v":{"v":0,"d":"0.00"}},{"$f":"'Week 52'!E25","v":0}]
["Utilities ",{"$f":"'Week 52'!D26","v":{"v":0,"d":"0.00"}},{"$f":"'Week 52'!E26","v":0}]
["Bench Levels",{"$f":"'Week 52'!D27","v":{"v":0,"d":"0.00"}},{"$f":"'Week 52'!E27","v":0}]
["Property/R.O.W.",{"$f":"'Week 52'!D28","v":{"v":0,"d":"0.00"}},{"$f":"'Week 52'!E28","v":0}]
["Drainage",{"$f":"'Week 52'!D29","v":{"v":0,"d":"0.00"}},{"$f":"'Week 52'!E29","v":0}]
["Bridge Surveys ",{"$f":"'Week 52'!D30","v":{"v":0,"d":"0.00"}},{"$f":"'Week 52'!E30","v":0}]
["Office ",{"$f":"'Week 52'!D31","v":{"v":0,"d":"0.00"}},{"$f":"'Week 52'!E31","v":0}]
["Total Time Worked",{"$f":"SUM(B22:B31)","v":{"v":0,"d":"0.00"}}]
["Misc.",{"$f":"'Week 52'!D33","v":{"v":0,"d":"0.00"}},{"$f":"'Week 52'!E33","v":0}]
["Lost Time-Travel",{"$f":"'Week 52'!D34","v":{"v":0,"d":"0.00"}}]
["Lost Time-Leave",{"$f":"'Week 52'!D35","v":{"v":0,"d":"0.00"}}]
["Lost Time - Other",{"$f":"'Week 52'!D36","v":{"v":0,"d":"0.00"}}]
["Total Lost Time & Misc.",{"$f":"SUM(B33:B36)","v":{"v":0,"d":"0.00"}}]
["Grand Total ",{"$f":"B32+B37","v":{"v":0,"d":"0.00"}}]
["Mandays per Mile",{"$f":"B32/B9","v":{"$error":"#DIV/0!"}}]
["Probable Completion Date:",null,{"$f":"'Week 52'!D40","v":"2011-12-02"}]
[]
["Percent completed to date:",null,{"$f":"'Week 52'!D43","v":0},"%"]

{"sheet":"Week 1","index":1,"n_rows":45,"n_cols":6,"rows_kept":45}
["WEEKLY SURVEY PROGRESS REPORT                                                 "]
["<< name>>","<< title >>"]
["<< address >>"]
["               "]
["No. of Weeks:",{"$f":"CEILING((B6-B17)/7,1)","v":0}]
["For Week Ending:","2011-12-02"]
["Proj. No.:",null,null,"Route:"]
["County:"]
["Length (miles):"]
["From Sta:",null,null,"To Sta:"]
[]
["From:"]
["To:"]
[]
["Project Filename:"]
["Data Collector Filename:"]
["Date Survey Began:","2011-12-02"]
[]
[]
[null,"Manhours","Mandays"]
[null,"This Week","This Week","To Date","% Complete","Comments"]
["Control Traverse",{"v":0,"d":"0.00"},{"$f":"B22/7.5","v":{"v":0,"d":"0.00"}},{"$f":"C22","v":{"v":0,"d":"0.00"}},0]
["Alignment",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
["Terrain Model",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
["Topography",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
["Utilities ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
["Bench Levels",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
["Property/R.O.W.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
["Drainage",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
["Bridge Surveys ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
["Office ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
["Total Time Worked",{"$f":"SUM(B22:B31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C22:C31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D22:D31)","v":{"v":0,"d":"0.00"}}]
["Misc.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},0]
["Lost Time-Travel",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,"travel dist. (miles) - "]
["Lost Time-Leave",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"}]
["Lost Time - Other",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},null,"explain:"]
["Total-Lost Time & Misc.",{"$f":"SUM(B33:B36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C33:C36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D33:D36)","v":{"v":0,"d":"0.00"}}]
["Grand Total ",{"$f":"B32+B37","v":{"v":0,"d":"0.00"}},{"$f":"C32+C37","v":{"v":0,"d":"0.00"}},{"$f":"D32+D37","v":{"v":0,"d":"0.00"}}]
[]
["Probable Completion Date:",null,null,"2011-12-02"]
[]
["Percent Completed This Week:",null,null,0]
["Percent completed to date:",null,null,{"$f":"D42","v":0}]
[]
["Next Week I expect to:"]

{"sheet":"Week 2","index":2,"n_rows":45,"n_cols":6,"rows_kept":45}
["WEEKLY SURVEY PROGRESS REPORT                                                  "]
[{"$f":"'Week 1'!A2","v":"<< name>>"},{"$f":"'Week 1'!B2","v":"<< title >>"}]
[{"$f":"'Week 1'!A3","v":"<< address >>"}]
["               "]
["No. of Weeks:",{"$f":"CEILING((B6-B17)/7,1)","v":0}]
["For Week Ending:",{"$f":"'Week 1'!B6","v":"2011-12-02"}]
["Proj. No.:",{"$f":"'Week 1'!B7","v":0},null,"Route:",{"$f":"'Week 1'!E7","v":0}]
["County:",{"$f":"'Week 1'!B8","v":0}]
["Length (miles):",{"$f":"'Week 1'!B9","v":0}]
["From Sta:",{"$f":"'Week 1'!B10","v":0},null,"To Sta:",{"$f":"'Week 1'!E10","v":0}]
[]
["From:",{"$f":"'Week 1'!B12","v":0}]
["To:",{"$f":"'Week 1'!B13","v":0}]
[]
["Project Filename:",{"$f":"'Week 1'!B15","v":0}]
["Data Collector Filename:",{"$f":"'Week 1'!B16","v":0}]
["Date Survey Began:",{"$f":"'Week 1'!B17","v":"2011-12-02"}]
[]
[]
[null,"Manhours","Mandays"]
[null,"This Week","This Week","To Date","% Complete","Comments"]
["Control Traverse",{"v":0,"d":"0.00"},{"$f":"B22/7.5","v":{"v":0,"d":"0.00"}},{"$f":"C22+'Week 1'!D22","v":{"v":0,"d":"0.00"}},{"$f":"'Week 1'!E22","v":0}]
["Alignment",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C23+'Week 1'!D23","v":{"v":0,"d":"0.00"}},{"$f":"'Week 1'!E23","v":0}]
["Terrain Model",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C24+'Week 1'!D24","v":{"v":0,"d":"0.00"}},{"$f":"'Week 1'!E24","v":0}]
["Topography",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C25+'Week 1'!D25","v":{"v":0,"d":"0.00"}},{"$f":"'Week 1'!E25","v":0}]
["Utilities ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C26+'Week 1'!D26","v":{"v":0,"d":"0.00"}},{"$f":"'Week 1'!E26","v":0}]
["Bench Levels",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C27+'Week 1'!D27","v":{"v":0,"d":"0.00"}},{"$f":"'Week 1'!E27","v":0}]
["Property/R.O.W.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C28+'Week 1'!D28","v":{"v":0,"d":"0.00"}},{"$f":"'Week 1'!E28","v":0}]
["Drainage",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C29+'Week 1'!D29","v":{"v":0,"d":"0.00"}},{"$f":"'Week 1'!E29","v":0}]
["Bridge Surveys ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C30+'Week 1'!D30","v":{"v":0,"d":"0.00"}},{"$f":"'Week 1'!E30","v":0}]
["Office ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C31+'Week 1'!D31","v":{"v":0,"d":"0.00"}},{"$f":"'Week 1'!E31","v":0}]
["Total Time Worked",{"$f":"SUM(B22:B31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C22:C31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D22:D31)","v":{"v":0,"d":"0.00"}}]
["Misc.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C33+'Week 1'!D33","v":{"v":0,"d":"0.00"}},{"$f":"'Week 1'!E33","v":0}]
["Lost Time-Travel",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C34+'Week 1'!D34","v":{"v":0,"d":"0.00"}},null,{"$f":"'Week 1'!F34","v":"travel dist. (miles) - "}]
["Lost Time-Leave",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C35+'Week 1'!D35","v":{"v":0,"d":"0.00"}}]
["Lost Time - Other",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C36+'Week 1'!D36","v":{"v":0,"d":"0.00"}},null,{"$f":"'Week 1'!F36","v":"explain:"}]
["Total Lost Time & Misc.",{"$f":"SUM(B33:B36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C33:C36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D33:D36)","v":{"v":0,"d":"0.00"}}]
["Grand Total",{"$f":"B32+B37","v":{"v":0,"d":"0.00"}},{"$f":"C32+C37","v":{"v":0,"d":"0.00"}},{"$f":"D32+D37","v":{"v":0,"d":"0.00"}}]
[]
["Probable Completion Date:",null,null,{"$f":"'Week 1'!D40","v":"2011-12-02"}]
[]
["Percent Completed This Week:",null,null,0]
["Percent completed to date:",null,null,{"$f":"'Week 1'!D43+D42","v":0}]
[]
["Next Week I expect to:"]

{"sheet":"Week 3","index":3,"n_rows":45,"n_cols":6,"rows_kept":45}
["WEEKLY SURVEY PROGRESS REPORT                                                  "]
[{"$f":"'Week 1'!A2","v":"<< name>>"},{"$f":"'Week 2'!B2","v":"<< title >>"}]
[{"$f":"'Week 1'!A3","v":"<< address >>"}]
["               "]
["No. of Weeks:",{"$f":"CEILING((B6-B17)/7,1)","v":0}]
["For Week Ending:",{"$f":"'Week 1'!B6","v":"2011-12-02"}]
["Proj. No.:",{"$f":"'Week 2'!B7","v":0},null,"Route:",{"$f":"'Week 2'!E7","v":0}]
["County:",{"$f":"'Week 2'!B8","v":0}]
["Length (miles):",{"$f":"'Week 2'!B9","v":0}]
["From Sta:",{"$f":"'Week 2'!B10","v":0},null,"To Sta:",{"$f":"'Week 2'!E10","v":0}]
[]
["From:",{"$f":"'Week 2'!B12","v":0}]
["To:",{"$f":"'Week 2'!B13","v":0}]
[]
["Project Filename:",{"$f":"'Week 2'!B15","v":0}]
["Data Collector Filename:",{"$f":"'Week 2'!B16","v":0}]
["Date Survey Began:",{"$f":"'Week 2'!B17","v":"2011-12-02"}]
[]
[]
[null,"Manhours","Mandays"]
[null,"This Week","This Week","To Date","% Complete","Comments"]
["Control Traverse",{"v":0,"d":"0.00"},{"$f":"B22/7.5","v":{"v":0,"d":"0.00"}},{"$f":"C22+'Week 2'!D22","v":{"v":0,"d":"0.00"}},{"$f":"'Week 2'!E22","v":0}]
["Alignment",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C23+'Week 2'!D23","v":{"v":0,"d":"0.00"}},{"$f":"'Week 2'!E23","v":0}]
["Terrain Model",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C24+'Week 2'!D24","v":{"v":0,"d":"0.00"}},{"$f":"'Week 2'!E24","v":0}]
["Topography",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C25+'Week 2'!D25","v":{"v":0,"d":"0.00"}},{"$f":"'Week 2'!E25","v":0}]
["Utilities ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C26+'Week 2'!D26","v":{"v":0,"d":"0.00"}},{"$f":"'Week 2'!E26","v":0}]
["Bench Levels",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C27+'Week 2'!D27","v":{"v":0,"d":"0.00"}},{"$f":"'Week 2'!E27","v":0}]
["Property/R.O.W.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C28+'Week 2'!D28","v":{"v":0,"d":"0.00"}},{"$f":"'Week 2'!E28","v":0}]
["Drainage",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C29+'Week 2'!D29","v":{"v":0,"d":"0.00"}},{"$f":"'Week 2'!E29","v":0}]
["Bridge Surveys ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C30+'Week 2'!D30","v":{"v":0,"d":"0.00"}},{"$f":"'Week 2'!E30","v":0}]
["Office ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C31+'Week 2'!D31","v":{"v":0,"d":"0.00"}},{"$f":"'Week 2'!E31","v":0}]
["Total Time Worked",{"$f":"SUM(B22:B31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C22:C31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D22:D31)","v":{"v":0,"d":"0.00"}}]
["Misc.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C33+'Week 2'!D33","v":{"v":0,"d":"0.00"}},0]
["Lost Time-Travel",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C34+'Week 2'!D34","v":{"v":0,"d":"0.00"}},null,{"$f":"'Week 1'!F34","v":"travel dist. (miles) - "}]
["Lost Time-Leave",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C35+'Week 2'!D35","v":{"v":0,"d":"0.00"}}]
["Lost Time - Other",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C36+'Week 2'!D36","v":{"v":0,"d":"0.00"}},null,{"$f":"'Week 2'!F36","v":"explain:"}]
["Total Lost Time & Misc.",{"$f":"SUM(B33:B36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C33:C36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D33:D36)","v":{"v":0,"d":"0.00"}}]
["Grand Total",{"$f":"B32+B37","v":{"v":0,"d":"0.00"}},{"$f":"C32+C37","v":{"v":0,"d":"0.00"}},{"$f":"D32+D37","v":{"v":0,"d":"0.00"}}]
[]
["Probable Completion Date:",null,null,{"$f":"'Week 2'!D40","v":"2011-12-02"}]
[]
["Percent Completed This Week:",null,null,0]
["Percent completed to date:",null,null,{"$f":"'Week 2'!D43+D42","v":0}]
[]
["Next Week I expect to:"]

{"sheet":"Week 4","index":4,"n_rows":45,"n_cols":6,"rows_kept":45}
["WEEKLY SURVEY PROGRESS REPORT                                                  "]
[{"$f":"'Week 1'!A2","v":"<< name>>"},{"$f":"'Week 3'!B2","v":"<< title >>"}]
[{"$f":"'Week 1'!A3","v":"<< address >>"}]
["               "]
["No. of Weeks:",{"$f":"CEILING((B6-B17)/7,1)","v":0}]
["For Week Ending:",{"$f":"'Week 3'!B6","v":"2011-12-02"}]
["Proj. No.:",{"$f":"'Week 3'!B7","v":0},null,"Route:",{"$f":"'Week 3'!E7","v":0}]
["County:",{"$f":"'Week 3'!B8","v":0}]
["Length (miles):",{"$f":"'Week 3'!B9","v":0}]
["From Sta:",{"$f":"'Week 3'!B10","v":0},null,"To Sta:",{"$f":"'Week 3'!E10","v":0}]
[]
["From:",{"$f":"'Week 3'!B12","v":0}]
["To:",{"$f":"'Week 3'!B13","v":0}]
[]
["Project Filename:",{"$f":"'Week 3'!B15","v":0}]
["Data Collector Filename:",{"$f":"'Week 3'!B16","v":0}]
["Date Survey Began:",{"$f":"'Week 3'!B17","v":"2011-12-02"}]
[]
[]
[null,"Manhours","Mandays"]
[null,"This Week","This Week","To Date","% Complete","Comments"]
["Control Traverse",{"v":0,"d":"0.00"},{"$f":"B22/7.5","v":{"v":0,"d":"0.00"}},{"$f":"C22+'Week 3'!D22","v":{"v":0,"d":"0.00"}},{"$f":"'Week 3'!E22","v":0}]
["Alignment",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C23+'Week 3'!D23","v":{"v":0,"d":"0.00"}},{"$f":"'Week 3'!E23","v":0}]
["Terrain Model",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C24+'Week 3'!D24","v":{"v":0,"d":"0.00"}},{"$f":"'Week 3'!E24","v":0}]
["Topography",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C25+'Week 3'!D25","v":{"v":0,"d":"0.00"}},{"$f":"'Week 3'!E25","v":0}]
["Utilities ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C26+'Week 3'!D26","v":{"v":0,"d":"0.00"}},{"$f":"'Week 3'!E26","v":0}]
["Bench Levels",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C27+'Week 3'!D27","v":{"v":0,"d":"0.00"}},{"$f":"'Week 3'!E27","v":0}]
["Property/R.O.W.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C28+'Week 3'!D28","v":{"v":0,"d":"0.00"}},{"$f":"'Week 3'!E28","v":0}]
["Drainage",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C29+'Week 3'!D29","v":{"v":0,"d":"0.00"}},{"$f":"'Week 3'!E29","v":0}]
["Bridge Surveys ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C30+'Week 3'!D30","v":{"v":0,"d":"0.00"}},{"$f":"'Week 3'!E30","v":0}]
["Office ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C31+'Week 3'!D31","v":{"v":0,"d":"0.00"}},{"$f":"'Week 3'!E31","v":0}]
["Total Time Worked",{"$f":"SUM(B22:B31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C22:C31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D22:D31)","v":{"v":0,"d":"0.00"}}]
["Misc.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C33+'Week 3'!D33","v":{"v":0,"d":"0.00"}},{"$f":"'Week 3'!E33","v":0}]
["Lost Time-Travel",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C34+'Week 3'!D34","v":{"v":0,"d":"0.00"}},null,{"$f":"'Week 1'!F34","v":"travel dist. (miles) - "}]
["Lost Time-Leave",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C35+'Week 3'!D35","v":{"v":0,"d":"0.00"}}]
["Lost Time - Other",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C36+'Week 3'!D36","v":{"v":0,"d":"0.00"}},null,{"$f":"'Week 3'!F36","v":"explain:"}]
["Total Lost Time & Misc.",{"$f":"SUM(B33:B36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C33:C36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D33:D36)","v":{"v":0,"d":"0.00"}}]
["Grand Total",{"$f":"B32+B37","v":{"v":0,"d":"0.00"}},{"$f":"C32+C37","v":{"v":0,"d":"0.00"}},{"$f":"D32+D37","v":{"v":0,"d":"0.00"}}]
[]
["Probable Completion Date:",null,null,{"$f":"'Week 3'!D40","v":"2011-12-02"}]
[]
["Percent Completed This Week:",null,null,0]
["Percent completed to date:",null,null,{"$f":"'Week 3'!D43+D42","v":0}]
[]
["Next Week I expect to:"]

{"sheet":"Week 5","index":5,"n_rows":45,"n_cols":6,"rows_kept":45}
["WEEKLY SURVEY PROGRESS REPORT                                                  "]
[{"$f":"'Week 1'!A2","v":"<< name>>"},{"$f":"'Week 4'!B2","v":"<< title >>"}]
[{"$f":"'Week 1'!A3","v":"<< address >>"}]
["               "]
["No. of Weeks:",{"$f":"CEILING((B6-B17)/7,1)","v":0}]
["For Week Ending:",{"$f":"'Week 4'!B6","v":"2011-12-02"}]
["Proj. No.:",{"$f":"'Week 4'!B7","v":0},null,"Route:",{"$f":"'Week 4'!E7","v":0}]
["County:",{"$f":"'Week 4'!B8","v":0}]
["Length (miles):",{"$f":"'Week 4'!B9","v":0}]
["From Sta:",{"$f":"'Week 4'!B10","v":0},null,"To Sta:",{"$f":"'Week 4'!E10","v":0}]
[]
["From:",{"$f":"'Week 4'!B12","v":0}]
["To:",{"$f":"'Week 4'!B13","v":0}]
[]
["Project Filename:",{"$f":"'Week 4'!B15","v":0}]
["Data Collector Filename:",{"$f":"'Week 4'!B16","v":0}]
["Date Survey Began:",{"$f":"'Week 4'!B17","v":"2011-12-02"}]
[]
[]
[null,"Manhours","Mandays"]
[null,"This Week","This Week","To Date","% Complete","Comments"]
["Control Traverse",{"v":0,"d":"0.00"},{"$f":"B22/7.5","v":{"v":0,"d":"0.00"}},{"$f":"C22+'Week 4'!D22","v":{"v":0,"d":"0.00"}},{"$f":"'Week 4'!E22","v":0}]
["Alignment",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C23+'Week 4'!D23","v":{"v":0,"d":"0.00"}},{"$f":"'Week 4'!E23","v":0}]
["Terrain Model",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C24+'Week 4'!D24","v":{"v":0,"d":"0.00"}},{"$f":"'Week 4'!E24","v":0}]
["Topography",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C25+'Week 4'!D25","v":{"v":0,"d":"0.00"}},{"$f":"'Week 4'!E25","v":0}]
["Utilities ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C26+'Week 4'!D26","v":{"v":0,"d":"0.00"}},{"$f":"'Week 4'!E26","v":0}]
["Bench Levels",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C27+'Week 4'!D27","v":{"v":0,"d":"0.00"}},{"$f":"'Week 4'!E27","v":0}]
["Property/R.O.W.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C28+'Week 4'!D28","v":{"v":0,"d":"0.00"}},{"$f":"'Week 4'!E28","v":0}]
["Drainage",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C29+'Week 4'!D29","v":{"v":0,"d":"0.00"}},{"$f":"'Week 4'!E29","v":0}]
["Bridge Surveys ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C30+'Week 4'!D30","v":{"v":0,"d":"0.00"}},{"$f":"'Week 4'!E30","v":0}]
["Office ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C31+'Week 4'!D31","v":{"v":0,"d":"0.00"}},{"$f":"'Week 4'!E31","v":0}]
["Total Time Worked",{"$f":"SUM(B22:B31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C22:C31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D22:D31)","v":{"v":0,"d":"0.00"}}]
["Misc.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C33+'Week 4'!D33","v":{"v":0,"d":"0.00"}},{"$f":"'Week 4'!E33","v":0}]
["Lost Time-Travel",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C34+'Week 4'!D34","v":{"v":0,"d":"0.00"}},null,{"$f":"'Week 1'!F34","v":"travel dist. (miles) - "}]
["Lost Time-Leave",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C35+'Week 4'!D35","v":{"v":0,"d":"0.00"}}]
["Lost Time - Other",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C36+'Week 4'!D36","v":{"v":0,"d":"0.00"}},null,{"$f":"'Week 4'!F36","v":"explain:"}]
["Total Lost Time & Misc.",{"$f":"SUM(B33:B36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C33:C36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D33:D36)","v":{"v":0,"d":"0.00"}}]
["Grand Total",{"$f":"B32+B37","v":{"v":0,"d":"0.00"}},{"$f":"C32+C37","v":{"v":0,"d":"0.00"}},{"$f":"D32+D37","v":{"v":0,"d":"0.00"}}]
[]
["Probable Completion Date:",null,null,{"$f":"'Week 4'!D40","v":"2011-12-02"}]
[]
["Percent Completed This Week:",null,null,0]
["Percent completed to date:",null,null,{"$f":"'Week 4'!D43+D42","v":0}]
[]
["Next Week I expect to:"]

{"sheet":"Week 6","index":6,"n_rows":45,"n_cols":6,"rows_kept":45}
["WEEKLY SURVEY PROGRESS REPORT                                                  "]
[{"$f":"'Week 1'!A2","v":"<< name>>"},{"$f":"'Week 5'!B2","v":"<< title >>"}]
[{"$f":"'Week 1'!A3","v":"<< address >>"}]
["               "]
["No. of Weeks:",{"$f":"CEILING((B6-B17)/7,1)","v":0}]
["For Week Ending:",{"$f":"'Week 5'!B6","v":"2011-12-02"}]
["Proj. No.:",{"$f":"'Week 5'!B7","v":0},null,"Route:",{"$f":"'Week 5'!E7","v":0}]
["County:",{"$f":"'Week 5'!B8","v":0}]
["Length (miles):",{"$f":"'Week 5'!B9","v":0}]
["From Sta:",{"$f":"'Week 5'!B10","v":0},null,"To Sta:",{"$f":"'Week 5'!E10","v":0}]
[]
["From:",{"$f":"'Week 5'!B12","v":0}]
["To:",{"$f":"'Week 5'!B13","v":0}]
[]
["Project Filename:",{"$f":"'Week 5'!B15","v":0}]
["Data Collector Filename:",{"$f":"'Week 5'!B16","v":0}]
["Date Survey Began:",{"$f":"'Week 5'!B17","v":"2011-12-02"}]
[]
[]
[null,"Manhours","Mandays"]
[null,"This Week","This Week","To Date","% Complete","Comments"]
["Control Traverse",{"v":0,"d":"0.00"},{"$f":"B22/7.5","v":{"v":0,"d":"0.00"}},{"$f":"C22+'Week 5'!D22","v":{"v":0,"d":"0.00"}},{"$f":"'Week 5'!E22","v":0}]
["Alignment",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C23+'Week 5'!D23","v":{"v":0,"d":"0.00"}},{"$f":"'Week 5'!E23","v":0}]
["Terrain Model",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C24+'Week 5'!D24","v":{"v":0,"d":"0.00"}},{"$f":"'Week 5'!E24","v":0}]
["Topography",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C25+'Week 5'!D25","v":{"v":0,"d":"0.00"}},{"$f":"'Week 5'!E25","v":0}]
["Utilities ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C26+'Week 5'!D26","v":{"v":0,"d":"0.00"}},{"$f":"'Week 5'!E26","v":0}]
["Bench Levels",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C27+'Week 5'!D27","v":{"v":0,"d":"0.00"}},{"$f":"'Week 5'!E27","v":0}]
["Property/R.O.W.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C28+'Week 5'!D28","v":{"v":0,"d":"0.00"}},{"$f":"'Week 5'!E28","v":0}]
["Drainage",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C29+'Week 5'!D29","v":{"v":0,"d":"0.00"}},{"$f":"'Week 5'!E29","v":0}]
["Bridge Surveys ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C30+'Week 5'!D30","v":{"v":0,"d":"0.00"}},{"$f":"'Week 5'!E30","v":0}]
["Office ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C31+'Week 5'!D31","v":{"v":0,"d":"0.00"}},{"$f":"'Week 5'!E31","v":0}]
["Total Time Worked",{"$f":"SUM(B22:B31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C22:C31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D22:D31)","v":{"v":0,"d":"0.00"}}]
["Misc.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C33+'Week 5'!D33","v":{"v":0,"d":"0.00"}},{"$f":"'Week 5'!E33","v":0}]
["Lost Time-Travel",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C34+'Week 5'!D34","v":{"v":0,"d":"0.00"}},null,{"$f":"'Week 1'!F34","v":"travel dist. (miles) - "}]
["Lost Time-Leave",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C35+'Week 5'!D35","v":{"v":0,"d":"0.00"}}]
["Lost Time - Other",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C36+'Week 5'!D36","v":{"v":0,"d":"0.00"}},null,{"$f":"'Week 5'!F36","v":"explain:"}]
["Total Lost Time & Misc.",{"$f":"SUM(B33:B36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C33:C36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D33:D36)","v":{"v":0,"d":"0.00"}}]
["Grand Total",{"$f":"B32+B37","v":{"v":0,"d":"0.00"}},{"$f":"C32+C37","v":{"v":0,"d":"0.00"}},{"$f":"D32+D37","v":{"v":0,"d":"0.00"}}]
[]
["Probable Completion Date:",null,null,{"$f":"'Week 5'!D40","v":"2011-12-02"}]
[]
["Percent Completed This Week:",null,null,0]
["Percent completed to date:",null,null,{"$f":"'Week 5'!D43+D42","v":0}]
[]
["Next Week I expect to:"]

{"sheet":"Week 7","index":7,"n_rows":45,"n_cols":6,"rows_kept":45}
["WEEKLY SURVEY PROGRESS REPORT                                                  "]
[{"$f":"'Week 1'!A2","v":"<< name>>"},{"$f":"'Week 1'!B2","v":"<< title >>"}]
[{"$f":"'Week 1'!A3","v":"<< address >>"}]
["               "]
["No. of Weeks:",{"$f":"CEILING((B6-B17)/7,1)","v":0}]
["For Week Ending:",{"$f":"'Week 6'!B6","v":"2011-12-02"}]
["Proj. No.:",{"$f":"'Week 1'!B7","v":0},null,"Route:",{"$f":"'Week 1'!E7","v":0}]
["County:",{"$f":"'Week 1'!B8","v":0}]
["Length (miles):",{"$f":"'Week 1'!B9","v":0}]
["From Sta:",{"$f":"'Week 1'!B10","v":0},null,"To Sta:",{"$f":"'Week 1'!E10","v":0}]
[]
["From:",{"$f":"'Week 1'!B12","v":0}]
["To:",{"$f":"'Week 1'!B13","v":0}]
[]
["Project Filename:",{"$f":"'Week 1'!B15","v":0}]
["Data Collector Filename:",{"$f":"'Week 1'!B16","v":0}]
["Date Survey Began:",{"$f":"'Week 1'!B17","v":"2011-12-02"}]
[]
[]
[null,"Manhours","Mandays"]
[null,"This Week","This Week","To Date","% Complete","Comments"]
["Control Traverse",{"v":0,"d":"0.00"},{"$f":"B22/7.5","v":{"v":0,"d":"0.00"}},{"$f":"C22+'Week 6'!D22","v":{"v":0,"d":"0.00"}},{"$f":"'Week 6'!E22","v":0}]
["Alignment",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C23+'Week 6'!D23","v":{"v":0,"d":"0.00"}},{"$f":"'Week 6'!E23","v":0}]
["Terrain Model",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C24+'Week 6'!D24","v":{"v":0,"d":"0.00"}},{"$f":"'Week 6'!E24","v":0}]
["Topography",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C25+'Week 6'!D25","v":{"v":0,"d":"0.00"}},{"$f":"'Week 6'!E25","v":0}]
["Utilities ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C26+'Week 6'!D26","v":{"v":0,"d":"0.00"}},{"$f":"'Week 6'!E26","v":0}]
["Bench Levels",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C27+'Week 6'!D27","v":{"v":0,"d":"0.00"}},{"$f":"'Week 6'!E27","v":0}]
["Property/R.O.W.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C28+'Week 6'!D28","v":{"v":0,"d":"0.00"}},{"$f":"'Week 6'!E28","v":0}]
["Drainage",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C29+'Week 6'!D29","v":{"v":0,"d":"0.00"}},{"$f":"'Week 6'!E29","v":0}]
["Bridge Surveys ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C30+'Week 6'!D30","v":{"v":0,"d":"0.00"}},{"$f":"'Week 6'!E30","v":0}]
["Office ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C31+'Week 6'!D31","v":{"v":0,"d":"0.00"}},{"$f":"'Week 6'!E31","v":0}]
["Total Time Worked",{"$f":"SUM(B22:B31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C22:C31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D22:D31)","v":{"v":0,"d":"0.00"}}]
["Misc.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C33+'Week 6'!D33","v":{"v":0,"d":"0.00"}},{"$f":"'Week 6'!E33","v":0}]
["Lost Time-Travel",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C34+'Week 6'!D34","v":{"v":0,"d":"0.00"}},null,{"$f":"'Week 1'!F34","v":"travel dist. (miles) - "}]
["Lost Time-Leave",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C35+'Week 6'!D35","v":{"v":0,"d":"0.00"}}]
["Lost Time - Other",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C36+'Week 6'!D36","v":{"v":0,"d":"0.00"}},null,{"$f":"'Week 6'!F36","v":"explain:"}]
["Total Lost Time & Misc.",{"$f":"SUM(B33:B36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C33:C36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D33:D36)","v":{"v":0,"d":"0.00"}}]
["Grand Total",{"$f":"B32+B37","v":{"v":0,"d":"0.00"}},{"$f":"C32+C37","v":{"v":0,"d":"0.00"}},{"$f":"D32+D37","v":{"v":0,"d":"0.00"}}]
[]
["Probable Completion Date:",null,null,{"$f":"'Week 6'!D40","v":"2011-12-02"}]
[]
["Percent Completed This Week:",null,null,0]
["Percent completed to date:",null,null,{"$f":"'Week 6'!D43+D42","v":0}]
[]
["Next Week I expect to:"]

{"sheet":"Week 8","index":8,"n_rows":45,"n_cols":6,"rows_kept":45}
["WEEKLY SURVEY PROGRESS REPORT                                                  "]
[{"$f":"'Week 1'!A2","v":"<< name>>"},{"$f":"'Week 1'!B2","v":"<< title >>"}]
[{"$f":"'Week 1'!A3","v":"<< address >>"}]
["               "]
["No. of Weeks:",{"$f":"CEILING((B6-B17)/7,1)","v":0}]
["For Week Ending:",{"$f":"'Week 7'!B6","v":"2011-12-02"}]
["Proj. No.:",{"$f":"'Week 1'!B7","v":0},null,"Route:",{"$f":"'Week 1'!E7","v":0}]
["County:",{"$f":"'Week 1'!B8","v":0}]
["Length (miles):",{"$f":"'Week 1'!B9","v":0}]
["From Sta:",{"$f":"'Week 1'!B10","v":0},null,"To Sta:",{"$f":"'Week 1'!E10","v":0}]
[]
["From:",{"$f":"'Week 1'!B12","v":0}]
["To:",{"$f":"'Week 1'!B13","v":0}]
[]
["Project Filename:",{"$f":"'Week 1'!B15","v":0}]
["Data Collector Filename:",{"$f":"'Week 1'!B16","v":0}]
["Date Survey Began:",{"$f":"'Week 1'!B17","v":"2011-12-02"}]
[]
[]
[null,"Manhours","Mandays"]
[null,"This Week","This Week","To Date","% Complete","Comments"]
["Control Traverse",{"v":0,"d":"0.00"},{"$f":"B22/7.5","v":{"v":0,"d":"0.00"}},{"$f":"C22+'Week 7'!D22","v":{"v":0,"d":"0.00"}},{"$f":"'Week 7'!E22","v":0}]
["Alignment",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C23+'Week 7'!D23","v":{"v":0,"d":"0.00"}},{"$f":"'Week 7'!E23","v":0}]
["Terrain Model",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C24+'Week 7'!D24","v":{"v":0,"d":"0.00"}},{"$f":"'Week 7'!E24","v":0}]
["Topography",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C25+'Week 7'!D25","v":{"v":0,"d":"0.00"}},{"$f":"'Week 7'!E25","v":0}]
["Utilities ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C26+'Week 7'!D26","v":{"v":0,"d":"0.00"}},{"$f":"'Week 7'!E26","v":0}]
["Bench Levels",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C27+'Week 7'!D27","v":{"v":0,"d":"0.00"}},{"$f":"'Week 7'!E27","v":0}]
["Property/R.O.W.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C28+'Week 7'!D28","v":{"v":0,"d":"0.00"}},{"$f":"'Week 7'!E28","v":0}]
["Drainage",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C29+'Week 7'!D29","v":{"v":0,"d":"0.00"}},{"$f":"'Week 7'!E29","v":0}]
["Bridge Surveys ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C30+'Week 7'!D30","v":{"v":0,"d":"0.00"}},{"$f":"'Week 7'!E30","v":0}]
["Office ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C31+'Week 7'!D31","v":{"v":0,"d":"0.00"}},{"$f":"'Week 7'!E31","v":0}]
["Total Time Worked",{"$f":"SUM(B22:B31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C22:C31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D22:D31)","v":{"v":0,"d":"0.00"}}]
["Misc.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C33+'Week 7'!D33","v":{"v":0,"d":"0.00"}},{"$f":"'Week 7'!E33","v":0}]
["Lost Time-Travel",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C34+'Week 7'!D34","v":{"v":0,"d":"0.00"}},null,{"$f":"'Week 1'!F34","v":"travel dist. (miles) - "}]
["Lost Time-Leave",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C35+'Week 7'!D35","v":{"v":0,"d":"0.00"}}]
["Lost Time - Other",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C36+'Week 7'!D36","v":{"v":0,"d":"0.00"}},null,{"$f":"'Week 7'!F36","v":"explain:"}]
["Total Lost Time & Misc.",{"$f":"SUM(B33:B36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C33:C36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D33:D36)","v":{"v":0,"d":"0.00"}}]
["Grand Total",{"$f":"B32+B37","v":{"v":0,"d":"0.00"}},{"$f":"C32+C37","v":{"v":0,"d":"0.00"}},{"$f":"D32+D37","v":{"v":0,"d":"0.00"}}]
[]
["Probable Completion Date:",null,null,{"$f":"'Week 7'!D40","v":"2011-12-02"}]
[]
["Percent Completed This Week:",null,null,0]
["Percent completed to date:",null,null,{"$f":"'Week 7'!D43+D42","v":0}]
[]
["Next Week I expect to:"]

{"sheet":"Week 9","index":9,"n_rows":45,"n_cols":6,"rows_kept":45}
["WEEKLY SURVEY PROGRESS REPORT                                                  "]
[{"$f":"'Week 1'!A2","v":"<< name>>"},{"$f":"'Week 1'!B2","v":"<< title >>"}]
[{"$f":"'Week 1'!A3","v":"<< address >>"}]
["               "]
["No. of Weeks:",{"$f":"CEILING((B6-B17)/7,1)","v":0}]
["For Week Ending:",{"$f":"'Week 8'!B6","v":"2011-12-02"}]
["Proj. No.:",{"$f":"'Week 1'!B7","v":0},null,"Route:",{"$f":"'Week 1'!E7","v":0}]
["County:",{"$f":"'Week 1'!B8","v":0}]
["Length (miles):",{"$f":"'Week 1'!B9","v":0}]
["From Sta:",{"$f":"'Week 1'!B10","v":0},null,"To Sta:",{"$f":"'Week 1'!E10","v":0}]
[]
["From:",{"$f":"'Week 1'!B12","v":0}]
["To:",{"$f":"'Week 1'!B13","v":0}]
[]
["Project Filename:",{"$f":"'Week 1'!B15","v":0}]
["Data Collector Filename:",{"$f":"'Week 1'!B16","v":0}]
["Date Survey Began:",{"$f":"'Week 1'!B17","v":"2011-12-02"}]
[]
[]
[null,"Manhours","Mandays"]
[null,"This Week","This Week","To Date","% Complete","Comments"]
["Control Traverse",{"v":0,"d":"0.00"},{"$f":"B22/7.5","v":{"v":0,"d":"0.00"}},{"$f":"C22+'Week 8'!D22","v":{"v":0,"d":"0.00"}},{"$f":"'Week 8'!E22","v":0}]
["Alignment",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C23+'Week 8'!D23","v":{"v":0,"d":"0.00"}},{"$f":"'Week 8'!E23","v":0}]
["Terrain Model",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C24+'Week 8'!D24","v":{"v":0,"d":"0.00"}},{"$f":"'Week 8'!E24","v":0}]
["Topography",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C25+'Week 8'!D25","v":{"v":0,"d":"0.00"}},{"$f":"'Week 8'!E25","v":0}]
["Utilities ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C26+'Week 8'!D26","v":{"v":0,"d":"0.00"}},{"$f":"'Week 8'!E26","v":0}]
["Bench Levels",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C27+'Week 8'!D27","v":{"v":0,"d":"0.00"}},{"$f":"'Week 8'!E27","v":0}]
["Property/R.O.W.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C28+'Week 8'!D28","v":{"v":0,"d":"0.00"}},{"$f":"'Week 8'!E28","v":0}]
["Drainage",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C29+'Week 8'!D29","v":{"v":0,"d":"0.00"}},{"$f":"'Week 8'!E29","v":0}]
["Bridge Surveys ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C30+'Week 8'!D30","v":{"v":0,"d":"0.00"}},{"$f":"'Week 8'!E30","v":0}]
["Office ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C31+'Week 8'!D31","v":{"v":0,"d":"0.00"}},{"$f":"'Week 8'!E31","v":0}]
["Total Time Worked",{"$f":"SUM(B22:B31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C22:C31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D22:D31)","v":{"v":0,"d":"0.00"}}]
["Misc.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C33+'Week 8'!D33","v":{"v":0,"d":"0.00"}},{"$f":"'Week 8'!E33","v":0}]
["Lost Time-Travel",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C34+'Week 8'!D34","v":{"v":0,"d":"0.00"}},null,{"$f":"'Week 1'!F34","v":"travel dist. (miles) - "}]
["Lost Time-Leave",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C35+'Week 8'!D35","v":{"v":0,"d":"0.00"}}]
["Lost Time - Other",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C36+'Week 8'!D36","v":{"v":0,"d":"0.00"}},null,{"$f":"'Week 8'!F36","v":"explain:"}]
["Total Lost Time & Misc.",{"$f":"SUM(B33:B36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C33:C36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D33:D36)","v":{"v":0,"d":"0.00"}}]
["Grand Total",{"$f":"B32+B37","v":{"v":0,"d":"0.00"}},{"$f":"C32+C37","v":{"v":0,"d":"0.00"}},{"$f":"D32+D37","v":{"v":0,"d":"0.00"}}]
[]
["Probable Completion Date:",null,null,{"$f":"'Week 8'!D40","v":"2011-12-02"}]
[]
["Percent Completed This Week:",null,null,0]
["Percent completed to date:",null,null,{"$f":"'Week 8'!D43+D42","v":0}]
[]
["Next Week I expect to:"]

{"sheet":"Week 10","index":10,"n_rows":45,"n_cols":6,"rows_kept":45}
["WEEKLY SURVEY PROGRESS REPORT                                                  "]
[{"$f":"'Week 1'!A2","v":"<< name>>"},{"$f":"'Week 1'!B2","v":"<< title >>"}]
[{"$f":"'Week 1'!A3","v":"<< address >>"}]
["               "]
["No. of Weeks:",{"$f":"CEILING((B6-B17)/7,1)","v":0}]
["For Week Ending:",{"$f":"'Week 9'!B6","v":"2011-12-02"}]
["Proj. No.:",{"$f":"'Week 1'!B7","v":0},null,"Route:",{"$f":"'Week 1'!E7","v":0}]
["County:",{"$f":"'Week 1'!B8","v":0}]
["Length (miles):",{"$f":"'Week 1'!B9","v":0}]
["From Sta:",{"$f":"'Week 1'!B10","v":0},null,"To Sta:",{"$f":"'Week 1'!E10","v":0}]
[]
["From:",{"$f":"'Week 1'!B12","v":0}]
["To:",{"$f":"'Week 1'!B13","v":0}]
[]
["Project Filename:",{"$f":"'Week 1'!B15","v":0}]
["Data Collector Filename:",{"$f":"'Week 1'!B16","v":0}]
["Date Survey Began:",{"$f":"'Week 1'!B17","v":"2011-12-02"}]
[]
[]
[null,"Manhours","Mandays"]
[null,"This Week","This Week","To Date","% Complete","Comments"]
["Control Traverse",{"v":0,"d":"0.00"},{"$f":"B22/7.5","v":{"v":0,"d":"0.00"}},{"$f":"C22+'Week 9'!D22","v":{"v":0,"d":"0.00"}},{"$f":"'Week 9'!E22","v":0}]
["Alignment",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C23+'Week 9'!D23","v":{"v":0,"d":"0.00"}},{"$f":"'Week 9'!E23","v":0}]
["Terrain Model",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C24+'Week 9'!D24","v":{"v":0,"d":"0.00"}},{"$f":"'Week 9'!E24","v":0}]
["Topography",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C25+'Week 9'!D25","v":{"v":0,"d":"0.00"}},{"$f":"'Week 9'!E25","v":0}]
["Utilities ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C26+'Week 9'!D26","v":{"v":0,"d":"0.00"}},{"$f":"'Week 9'!E26","v":0}]
["Bench Levels",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C27+'Week 9'!D27","v":{"v":0,"d":"0.00"}},{"$f":"'Week 9'!E27","v":0}]
["Property/R.O.W.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C28+'Week 9'!D28","v":{"v":0,"d":"0.00"}},{"$f":"'Week 9'!E28","v":0}]
["Drainage",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C29+'Week 9'!D29","v":{"v":0,"d":"0.00"}},{"$f":"'Week 9'!E29","v":0}]
["Bridge Surveys ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C30+'Week 9'!D30","v":{"v":0,"d":"0.00"}},{"$f":"'Week 9'!E30","v":0}]
["Office ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C31+'Week 9'!D31","v":{"v":0,"d":"0.00"}},{"$f":"'Week 9'!E31","v":0}]
["Total Time Worked",{"$f":"SUM(B22:B31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C22:C31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D22:D31)","v":{"v":0,"d":"0.00"}}]
["Misc.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C33+'Week 9'!D33","v":{"v":0,"d":"0.00"}},{"$f":"'Week 9'!E33","v":0}]
["Lost Time-Travel",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C34+'Week 9'!D34","v":{"v":0,"d":"0.00"}},null,{"$f":"'Week 1'!F34","v":"travel dist. (miles) - "}]
["Lost Time-Leave",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C35+'Week 9'!D35","v":{"v":0,"d":"0.00"}}]
["Lost Time - Other",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C36+'Week 9'!D36","v":{"v":0,"d":"0.00"}},null,{"$f":"'Week 9'!F36","v":"explain:"}]
["Total Lost Time & Misc.",{"$f":"SUM(B33:B36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C33:C36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D33:D36)","v":{"v":0,"d":"0.00"}}]
["Grand Total",{"$f":"B32+B37","v":{"v":0,"d":"0.00"}},{"$f":"C32+C37","v":{"v":0,"d":"0.00"}},{"$f":"D32+D37","v":{"v":0,"d":"0.00"}}]
[]
["Probable Completion Date:",null,null,{"$f":"'Week 9'!D40","v":"2011-12-02"}]
[]
["Percent Completed This Week:",null,null,0]
["Percent completed to date:",null,null,{"$f":"'Week 9'!D43+D42","v":0}]
[]
["Next Week I expect to:"]

{"sheet":"Week 11","index":11,"n_rows":45,"n_cols":6,"rows_kept":45}
["WEEKLY SURVEY PROGRESS REPORT                                                  "]
[{"$f":"'Week 1'!A2","v":"<< name>>"},{"$f":"'Week 1'!B2","v":"<< title >>"}]
[{"$f":"'Week 1'!A3","v":"<< address >>"}]
["               "]
["No. of Weeks:",{"$f":"CEILING((B6-B17)/7,1)","v":0}]
["For Week Ending:",{"$f":"'Week 10'!B6","v":"2011-12-02"}]
["Proj. No.:",{"$f":"'Week 1'!B7","v":0},null,"Route:",{"$f":"'Week 1'!E7","v":0}]
["County:",{"$f":"'Week 1'!B8","v":0}]
["Length (miles):",{"$f":"'Week 1'!B9","v":0}]
["From Sta:",{"$f":"'Week 1'!B10","v":0},null,"To Sta:",{"$f":"'Week 1'!E10","v":0}]
[]
["From:",{"$f":"'Week 1'!B12","v":0}]
["To:",{"$f":"'Week 1'!B13","v":0}]
[]
["Project Filename:",{"$f":"'Week 1'!B15","v":0}]
["Data Collector Filename:",{"$f":"'Week 1'!B16","v":0}]
["Date Survey Began:",{"$f":"'Week 1'!B17","v":"2011-12-02"}]
[]
[]
[null,"Manhours","Mandays"]
[null,"This Week","This Week","To Date","% Complete","Comments"]
["Control Traverse",{"v":0,"d":"0.00"},{"$f":"B22/7.5","v":{"v":0,"d":"0.00"}},{"$f":"C22+'Week 10'!D22","v":{"v":0,"d":"0.00"}},{"$f":"'Week 10'!E22","v":0}]
["Alignment",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C23+'Week 10'!D23","v":{"v":0,"d":"0.00"}},{"$f":"'Week 10'!E23","v":0}]
["Terrain Model",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C24+'Week 10'!D24","v":{"v":0,"d":"0.00"}},{"$f":"'Week 10'!E24","v":0}]
["Topography",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C25+'Week 10'!D25","v":{"v":0,"d":"0.00"}},{"$f":"'Week 10'!E25","v":0}]
["Utilities ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C26+'Week 10'!D26","v":{"v":0,"d":"0.00"}},{"$f":"'Week 10'!E26","v":0}]
["Bench Levels",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C27+'Week 10'!D27","v":{"v":0,"d":"0.00"}},{"$f":"'Week 10'!E27","v":0}]
["Property/R.O.W.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C28+'Week 10'!D28","v":{"v":0,"d":"0.00"}},{"$f":"'Week 10'!E28","v":0}]
["Drainage",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C29+'Week 10'!D29","v":{"v":0,"d":"0.00"}},{"$f":"'Week 10'!E29","v":0}]
["Bridge Surveys ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C30+'Week 10'!D30","v":{"v":0,"d":"0.00"}},{"$f":"'Week 10'!E30","v":0}]
["Office ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C31+'Week 10'!D31","v":{"v":0,"d":"0.00"}},{"$f":"'Week 10'!E31","v":0}]
["Total Time Worked",{"$f":"SUM(B22:B31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C22:C31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D22:D31)","v":{"v":0,"d":"0.00"}}]
["Misc.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C33+'Week 10'!D33","v":{"v":0,"d":"0.00"}},{"$f":"'Week 10'!E33","v":0}]
["Lost Time-Travel",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C34+'Week 10'!D34","v":{"v":0,"d":"0.00"}},null,{"$f":"'Week 1'!F34","v":"travel dist. (miles) - "}]
["Lost Time-Leave",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C35+'Week 10'!D35","v":{"v":0,"d":"0.00"}}]
["Lost Time - Other",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C36+'Week 10'!D36","v":{"v":0,"d":"0.00"}},null,{"$f":"'Week 10'!F36","v":"explain:"}]
["Total Lost Time & Misc.",{"$f":"SUM(B33:B36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C33:C36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D33:D36)","v":{"v":0,"d":"0.00"}}]
["Grand Total",{"$f":"B32+B37","v":{"v":0,"d":"0.00"}},{"$f":"C32+C37","v":{"v":0,"d":"0.00"}},{"$f":"D32+D37","v":{"v":0,"d":"0.00"}}]
[]
["Probable Completion Date:",null,null,{"$f":"'Week 10'!D40","v":"2011-12-02"}]
[]
["Percent Completed This Week:",null,null,0]
["Percent completed to date:",null,null,{"$f":"'Week 10'!D43+D42","v":0}]
[]
["Next Week I expect to:"]

{"sheet":"Week 12","index":12,"n_rows":45,"n_cols":6,"rows_kept":45}
["WEEKLY SURVEY PROGRESS REPORT                                                  "]
[{"$f":"'Week 1'!A2","v":"<< name>>"},{"$f":"'Week 1'!B2","v":"<< title >>"}]
[{"$f":"'Week 1'!A3","v":"<< address >>"}]
["               "]
["No. of Weeks:",{"$f":"CEILING((B6-B17)/7,1)","v":0}]
["For Week Ending:",{"$f":"'Week 11'!B6","v":"2011-12-02"}]
["Proj. No.:",{"$f":"'Week 1'!B7","v":0},null,"Route:",{"$f":"'Week 1'!E7","v":0}]
["County:",{"$f":"'Week 1'!B8","v":0}]
["Length (miles):",{"$f":"'Week 1'!B9","v":0}]
["From Sta:",{"$f":"'Week 1'!B10","v":0},null,"To Sta:",{"$f":"'Week 1'!E10","v":0}]
[]
["From:",{"$f":"'Week 1'!B12","v":0}]
["To:",{"$f":"'Week 1'!B13","v":0}]
[]
["Project Filename:",{"$f":"'Week 1'!B15","v":0}]
["Data Collector Filename:",{"$f":"'Week 1'!B16","v":0}]
["Date Survey Began:",{"$f":"'Week 1'!B17","v":"2011-12-02"}]
[]
[]
[null,"Manhours","Mandays"]
[null,"This Week","This Week","To Date","% Complete","Comments"]
["Control Traverse",{"v":0,"d":"0.00"},{"$f":"B22/7.5","v":{"v":0,"d":"0.00"}},{"$f":"C22+'Week 11'!D22","v":{"v":0,"d":"0.00"}},{"$f":"'Week 11'!E22","v":0}]
["Alignment",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C23+'Week 11'!D23","v":{"v":0,"d":"0.00"}},{"$f":"'Week 11'!E23","v":0}]
["Terrain Model",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C24+'Week 11'!D24","v":{"v":0,"d":"0.00"}},{"$f":"'Week 11'!E24","v":0}]
["Topography",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C25+'Week 11'!D25","v":{"v":0,"d":"0.00"}},{"$f":"'Week 11'!E25","v":0}]
["Utilities ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C26+'Week 11'!D26","v":{"v":0,"d":"0.00"}},{"$f":"'Week 11'!E26","v":0}]
["Bench Levels",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C27+'Week 11'!D27","v":{"v":0,"d":"0.00"}},{"$f":"'Week 11'!E27","v":0}]
["Property/R.O.W.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C28+'Week 11'!D28","v":{"v":0,"d":"0.00"}},{"$f":"'Week 11'!E28","v":0}]
["Drainage",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C29+'Week 11'!D29","v":{"v":0,"d":"0.00"}},{"$f":"'Week 11'!E29","v":0}]
["Bridge Surveys ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C30+'Week 11'!D30","v":{"v":0,"d":"0.00"}},{"$f":"'Week 11'!E30","v":0}]
["Office ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C31+'Week 11'!D31","v":{"v":0,"d":"0.00"}},{"$f":"'Week 11'!E31","v":0}]
["Total Time Worked",{"$f":"SUM(B22:B31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C22:C31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D22:D31)","v":{"v":0,"d":"0.00"}}]
["Misc.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C33+'Week 11'!D33","v":{"v":0,"d":"0.00"}},{"$f":"'Week 11'!E33","v":0}]
["Lost Time-Travel",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C34+'Week 11'!D34","v":{"v":0,"d":"0.00"}},null,{"$f":"'Week 1'!F34","v":"travel dist. (miles) - "}]
["Lost Time-Leave",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C35+'Week 11'!D35","v":{"v":0,"d":"0.00"}}]
["Lost Time - Other",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C36+'Week 11'!D36","v":{"v":0,"d":"0.00"}},null,{"$f":"'Week 11'!F36","v":"explain:"}]
["Total Lost Time & Misc.",{"$f":"SUM(B33:B36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C33:C36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D33:D36)","v":{"v":0,"d":"0.00"}}]
["Grand Total",{"$f":"B32+B37","v":{"v":0,"d":"0.00"}},{"$f":"C32+C37","v":{"v":0,"d":"0.00"}},{"$f":"D32+D37","v":{"v":0,"d":"0.00"}}]
[]
["Probable Completion Date:",null,null,{"$f":"'Week 11'!D40","v":"2011-12-02"}]
[]
["Percent Completed This Week:",null,null,0]
["Percent completed to date:",null,null,{"$f":"'Week 11'!D43+D42","v":0}]
[]
["Next Week I expect to:"]

{"sheet":"Week 13","index":13,"n_rows":45,"n_cols":6,"rows_kept":45}
["WEEKLY SURVEY PROGRESS REPORT                                                  "]
[{"$f":"'Week 1'!A2","v":"<< name>>"},{"$f":"'Week 1'!B2","v":"<< title >>"}]
[{"$f":"'Week 1'!A3","v":"<< address >>"}]
["               "]
["No. of Weeks:",{"$f":"CEILING((B6-B17)/7,1)","v":0}]
["For Week Ending:",{"$f":"'Week 12'!B6","v":"2011-12-02"}]
["Proj. No.:",{"$f":"'Week 1'!B7","v":0},null,"Route:",{"$f":"'Week 1'!E7","v":0}]
["County:",{"$f":"'Week 1'!B8","v":0}]
["Length (miles):",{"$f":"'Week 1'!B9","v":0}]
["From Sta:",{"$f":"'Week 1'!B10","v":0},null,"To Sta:",{"$f":"'Week 1'!E10","v":0}]
[]
["From:",{"$f":"'Week 1'!B12","v":0}]
["To:",{"$f":"'Week 1'!B13","v":0}]
[]
["Project Filename:",{"$f":"'Week 1'!B15","v":0}]
["Data Collector Filename:",{"$f":"'Week 1'!B16","v":0}]
["Date Survey Began:",{"$f":"'Week 1'!B17","v":"2011-12-02"}]
[]
[]
[null,"Manhours","Mandays"]
[null,"This Week","This Week","To Date","% Complete","Comments"]
["Control Traverse",{"v":0,"d":"0.00"},{"$f":"B22/7.5","v":{"v":0,"d":"0.00"}},{"$f":"C22+'Week 12'!D22","v":{"v":0,"d":"0.00"}},{"$f":"'Week 12'!E22","v":0}]
["Alignment",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C23+'Week 12'!D23","v":{"v":0,"d":"0.00"}},{"$f":"'Week 12'!E23","v":0}]
["Terrain Model",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C24+'Week 12'!D24","v":{"v":0,"d":"0.00"}},{"$f":"'Week 12'!E24","v":0}]
["Topography",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C25+'Week 12'!D25","v":{"v":0,"d":"0.00"}},{"$f":"'Week 12'!E25","v":0}]
["Utilities ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C26+'Week 12'!D26","v":{"v":0,"d":"0.00"}},{"$f":"'Week 12'!E26","v":0}]
["Bench Levels",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C27+'Week 12'!D27","v":{"v":0,"d":"0.00"}},{"$f":"'Week 12'!E27","v":0}]
["Property/R.O.W.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C28+'Week 12'!D28","v":{"v":0,"d":"0.00"}},{"$f":"'Week 12'!E28","v":0}]
["Drainage",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C29+'Week 12'!D29","v":{"v":0,"d":"0.00"}},{"$f":"'Week 12'!E29","v":0}]
["Bridge Surveys ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C30+'Week 12'!D30","v":{"v":0,"d":"0.00"}},{"$f":"'Week 12'!E30","v":0}]
["Office ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C31+'Week 12'!D31","v":{"v":0,"d":"0.00"}},{"$f":"'Week 12'!E31","v":0}]
["Total Time Worked",{"$f":"SUM(B22:B31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C22:C31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D22:D31)","v":{"v":0,"d":"0.00"}}]
["Misc.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C33+'Week 12'!D33","v":{"v":0,"d":"0.00"}},{"$f":"'Week 12'!E33","v":0}]
["Lost Time-Travel",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C34+'Week 12'!D34","v":{"v":0,"d":"0.00"}},null,{"$f":"'Week 1'!F34","v":"travel dist. (miles) - "}]
["Lost Time-Leave",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C35+'Week 12'!D35","v":{"v":0,"d":"0.00"}}]
["Lost Time - Other",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C36+'Week 12'!D36","v":{"v":0,"d":"0.00"}},null,{"$f":"'Week 12'!F36","v":"explain:"}]
["Total Lost Time & Misc.",{"$f":"SUM(B33:B36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C33:C36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D33:D36)","v":{"v":0,"d":"0.00"}}]
["Grand Total",{"$f":"B32+B37","v":{"v":0,"d":"0.00"}},{"$f":"C32+C37","v":{"v":0,"d":"0.00"}},{"$f":"D32+D37","v":{"v":0,"d":"0.00"}}]
[]
["Probable Completion Date:",null,null,{"$f":"'Week 12'!D40","v":"2011-12-02"}]
[]
["Percent Completed This Week:",null,null,0]
["Percent completed to date:",null,null,{"$f":"'Week 12'!D43+D42","v":0}]
[]
["Next Week I expect to:"]

{"sheet":"Week 14","index":14,"n_rows":45,"n_cols":6,"rows_kept":45}
["WEEKLY SURVEY PROGRESS REPORT                                                  "]
[{"$f":"'Week 1'!A2","v":"<< name>>"},{"$f":"'Week 1'!B2","v":"<< title >>"}]
[{"$f":"'Week 1'!A3","v":"<< address >>"}]
["               "]
["No. of Weeks:",{"$f":"CEILING((B6-B17)/7,1)","v":0}]
["For Week Ending:",{"$f":"'Week 13'!B6","v":"2011-12-02"}]
["Proj. No.:",{"$f":"'Week 1'!B7","v":0},null,"Route:",{"$f":"'Week 1'!E7","v":0}]
["County:",{"$f":"'Week 1'!B8","v":0}]
["Length (miles):",{"$f":"'Week 1'!B9","v":0}]
["From Sta:",{"$f":"'Week 1'!B10","v":0},null,"To Sta:",{"$f":"'Week 1'!E10","v":0}]
[]
["From:",{"$f":"'Week 1'!B12","v":0}]
["To:",{"$f":"'Week 1'!B13","v":0}]
[]
["Project Filename:",{"$f":"'Week 1'!B15","v":0}]
["Data Collector Filename:",{"$f":"'Week 1'!B16","v":0}]
["Date Survey Began:",{"$f":"'Week 1'!B17","v":"2011-12-02"}]
[]
[]
[null,"Manhours","Mandays"]
[null,"This Week","This Week","To Date","% Complete","Comments"]
["Control Traverse",{"v":0,"d":"0.00"},{"$f":"B22/7.5","v":{"v":0,"d":"0.00"}},{"$f":"C22+'Week 13'!D22","v":{"v":0,"d":"0.00"}},{"$f":"'Week 13'!E22","v":0}]
["Alignment",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C23+'Week 13'!D23","v":{"v":0,"d":"0.00"}},{"$f":"'Week 13'!E23","v":0}]
["Terrain Model",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C24+'Week 13'!D24","v":{"v":0,"d":"0.00"}},{"$f":"'Week 13'!E24","v":0}]
["Topography",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C25+'Week 13'!D25","v":{"v":0,"d":"0.00"}},{"$f":"'Week 13'!E25","v":0}]
["Utilities ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C26+'Week 13'!D26","v":{"v":0,"d":"0.00"}},{"$f":"'Week 13'!E26","v":0}]
["Bench Levels",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C27+'Week 13'!D27","v":{"v":0,"d":"0.00"}},{"$f":"'Week 13'!E27","v":0}]
["Property/R.O.W.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C28+'Week 13'!D28","v":{"v":0,"d":"0.00"}},{"$f":"'Week 13'!E28","v":0}]
["Drainage",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C29+'Week 13'!D29","v":{"v":0,"d":"0.00"}},{"$f":"'Week 13'!E29","v":0}]
["Bridge Surveys ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C30+'Week 13'!D30","v":{"v":0,"d":"0.00"}},{"$f":"'Week 13'!E30","v":0}]
["Office ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C31+'Week 13'!D31","v":{"v":0,"d":"0.00"}},{"$f":"'Week 13'!E31","v":0}]
["Total Time Worked",{"$f":"SUM(B22:B31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C22:C31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D22:D31)","v":{"v":0,"d":"0.00"}}]
["Misc.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C33+'Week 13'!D33","v":{"v":0,"d":"0.00"}},{"$f":"'Week 13'!E33","v":0}]
["Lost Time-Travel",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C34+'Week 13'!D34","v":{"v":0,"d":"0.00"}},null,{"$f":"'Week 1'!F34","v":"travel dist. (miles) - "}]
["Lost Time-Leave",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C35+'Week 13'!D35","v":{"v":0,"d":"0.00"}}]
["Lost Time - Other",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C36+'Week 13'!D36","v":{"v":0,"d":"0.00"}},null,{"$f":"'Week 13'!F36","v":"explain:"}]
["Total Lost Time & Misc.",{"$f":"SUM(B33:B36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C33:C36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D33:D36)","v":{"v":0,"d":"0.00"}}]
["Grand Total",{"$f":"B32+B37","v":{"v":0,"d":"0.00"}},{"$f":"C32+C37","v":{"v":0,"d":"0.00"}},{"$f":"D32+D37","v":{"v":0,"d":"0.00"}}]
[]
["Probable Completion Date:",null,null,{"$f":"'Week 13'!D40","v":"2011-12-02"}]
[]
["Percent Completed This Week:",null,null,0]
["Percent completed to date:",null,null,{"$f":"'Week 13'!D43+D42","v":0}]
[]
["Next Week I expect to:"]

{"sheet":"Week 15","index":15,"n_rows":45,"n_cols":6,"rows_kept":45}
["WEEKLY SURVEY PROGRESS REPORT                                                  "]
[{"$f":"'Week 1'!A2","v":"<< name>>"},{"$f":"'Week 1'!B2","v":"<< title >>"}]
[{"$f":"'Week 1'!A3","v":"<< address >>"}]
["               "]
["No. of Weeks:",{"$f":"CEILING((B6-B17)/7,1)","v":0}]
["For Week Ending:",{"$f":"'Week 14'!B6","v":"2011-12-02"}]
["Proj. No.:",{"$f":"'Week 1'!B7","v":0},null,"Route:",{"$f":"'Week 1'!E7","v":0}]
["County:",{"$f":"'Week 1'!B8","v":0}]
["Length (miles):",{"$f":"'Week 1'!B9","v":0}]
["From Sta:",{"$f":"'Week 1'!B10","v":0},null,"To Sta:",{"$f":"'Week 1'!E10","v":0}]
[]
["From:",{"$f":"'Week 1'!B12","v":0}]
["To:",{"$f":"'Week 1'!B13","v":0}]
[]
["Project Filename:",{"$f":"'Week 1'!B15","v":0}]
["Data Collector Filename:",{"$f":"'Week 1'!B16","v":0}]
["Date Survey Began:",{"$f":"'Week 1'!B17","v":"2011-12-02"}]
[]
[]
[null,"Manhours","Mandays"]
[null,"This Week","This Week","To Date","% Complete","Comments"]
["Control Traverse",{"v":0,"d":"0.00"},{"$f":"B22/7.5","v":{"v":0,"d":"0.00"}},{"$f":"C22+'Week 14'!D22","v":{"v":0,"d":"0.00"}},{"$f":"'Week 14'!E22","v":0}]
["Alignment",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C23+'Week 14'!D23","v":{"v":0,"d":"0.00"}},{"$f":"'Week 14'!E23","v":0}]
["Terrain Model",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C24+'Week 14'!D24","v":{"v":0,"d":"0.00"}},{"$f":"'Week 14'!E24","v":0}]
["Topography",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C25+'Week 14'!D25","v":{"v":0,"d":"0.00"}},{"$f":"'Week 14'!E25","v":0}]
["Utilities ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C26+'Week 14'!D26","v":{"v":0,"d":"0.00"}},{"$f":"'Week 14'!E26","v":0}]
["Bench Levels",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C27+'Week 14'!D27","v":{"v":0,"d":"0.00"}},{"$f":"'Week 14'!E27","v":0}]
["Property/R.O.W.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C28+'Week 14'!D28","v":{"v":0,"d":"0.00"}},{"$f":"'Week 14'!E28","v":0}]
["Drainage",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C29+'Week 14'!D29","v":{"v":0,"d":"0.00"}},{"$f":"'Week 14'!E29","v":0}]
["Bridge Surveys ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C30+'Week 14'!D30","v":{"v":0,"d":"0.00"}},{"$f":"'Week 14'!E30","v":0}]
["Office ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C31+'Week 14'!D31","v":{"v":0,"d":"0.00"}},{"$f":"'Week 14'!E31","v":0}]
["Total Time Worked",{"$f":"SUM(B22:B31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C22:C31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D22:D31)","v":{"v":0,"d":"0.00"}}]
["Misc.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C33+'Week 14'!D33","v":{"v":0,"d":"0.00"}},{"$f":"'Week 14'!E33","v":0}]
["Lost Time-Travel",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C34+'Week 14'!D34","v":{"v":0,"d":"0.00"}},null,{"$f":"'Week 1'!F34","v":"travel dist. (miles) - "}]
["Lost Time-Leave",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C35+'Week 14'!D35","v":{"v":0,"d":"0.00"}}]
["Lost Time - Other",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C36+'Week 14'!D36","v":{"v":0,"d":"0.00"}},null,{"$f":"'Week 14'!F36","v":"explain:"}]
["Total Lost Time & Misc.",{"$f":"SUM(B33:B36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C33:C36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D33:D36)","v":{"v":0,"d":"0.00"}}]
["Grand Total",{"$f":"B32+B37","v":{"v":0,"d":"0.00"}},{"$f":"C32+C37","v":{"v":0,"d":"0.00"}},{"$f":"D32+D37","v":{"v":0,"d":"0.00"}}]
[]
["Probable Completion Date:",null,null,{"$f":"'Week 14'!D40","v":"2011-12-02"}]
[]
["Percent Completed This Week:",null,null,0]
["Percent completed to date:",null,null,{"$f":"'Week 14'!D43+D42","v":0}]
[]
["Next Week I expect to:"]

{"sheet":"Week 16","index":16,"n_rows":45,"n_cols":6,"rows_kept":45}
["WEEKLY SURVEY PROGRESS REPORT                                                  "]
[{"$f":"'Week 1'!A2","v":"<< name>>"},{"$f":"'Week 1'!B2","v":"<< title >>"}]
[{"$f":"'Week 1'!A3","v":"<< address >>"}]
["               "]
["No. of Weeks:",{"$f":"CEILING((B6-B17)/7,1)","v":0}]
["For Week Ending:",{"$f":"'Week 15'!B6","v":"2011-12-02"}]
["Proj. No.:",{"$f":"'Week 1'!B7","v":0},null,"Route:",{"$f":"'Week 1'!E7","v":0}]
["County:",{"$f":"'Week 1'!B8","v":0}]
["Length (miles):",{"$f":"'Week 1'!B9","v":0}]
["From Sta:",{"$f":"'Week 1'!B10","v":0},null,"To Sta:",{"$f":"'Week 1'!E10","v":0}]
[]
["From:",{"$f":"'Week 1'!B12","v":0}]
["To:",{"$f":"'Week 1'!B13","v":0}]
[]
["Project Filename:",{"$f":"'Week 1'!B15","v":0}]
["Data Collector Filename:",{"$f":"'Week 1'!B16","v":0}]
["Date Survey Began:",{"$f":"'Week 1'!B17","v":"2011-12-02"}]
[]
[]
[null,"Manhours","Mandays"]
[null,"This Week","This Week","To Date","% Complete","Comments"]
["Control Traverse",{"v":0,"d":"0.00"},{"$f":"B22/7.5","v":{"v":0,"d":"0.00"}},{"$f":"C22+'Week 15'!D22","v":{"v":0,"d":"0.00"}},{"$f":"'Week 15'!E22","v":0}]
["Alignment",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C23+'Week 15'!D23","v":{"v":0,"d":"0.00"}},{"$f":"'Week 15'!E23","v":0}]
["Terrain Model",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C24+'Week 15'!D24","v":{"v":0,"d":"0.00"}},{"$f":"'Week 15'!E24","v":0}]
["Topography",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C25+'Week 15'!D25","v":{"v":0,"d":"0.00"}},{"$f":"'Week 15'!E25","v":0}]
["Utilities ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C26+'Week 15'!D26","v":{"v":0,"d":"0.00"}},{"$f":"'Week 15'!E26","v":0}]
["Bench Levels",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C27+'Week 15'!D27","v":{"v":0,"d":"0.00"}},{"$f":"'Week 15'!E27","v":0}]
["Property/R.O.W.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C28+'Week 15'!D28","v":{"v":0,"d":"0.00"}},{"$f":"'Week 15'!E28","v":0}]
["Drainage",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C29+'Week 15'!D29","v":{"v":0,"d":"0.00"}},{"$f":"'Week 15'!E29","v":0}]
["Bridge Surveys ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C30+'Week 15'!D30","v":{"v":0,"d":"0.00"}},{"$f":"'Week 15'!E30","v":0}]
["Office ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C31+'Week 15'!D31","v":{"v":0,"d":"0.00"}},{"$f":"'Week 15'!E31","v":0}]
["Total Time Worked",{"$f":"SUM(B22:B31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C22:C31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D22:D31)","v":{"v":0,"d":"0.00"}}]
["Misc.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C33+'Week 15'!D33","v":{"v":0,"d":"0.00"}},{"$f":"'Week 15'!E33","v":0}]
["Lost Time-Travel",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C34+'Week 15'!D34","v":{"v":0,"d":"0.00"}},null,{"$f":"'Week 1'!F34","v":"travel dist. (miles) - "}]
["Lost Time-Leave",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C35+'Week 15'!D35","v":{"v":0,"d":"0.00"}}]
["Lost Time - Other",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C36+'Week 15'!D36","v":{"v":0,"d":"0.00"}},null,{"$f":"'Week 15'!F36","v":"explain:"}]
["Total Lost Time & Misc.",{"$f":"SUM(B33:B36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C33:C36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D33:D36)","v":{"v":0,"d":"0.00"}}]
["Grand Total",{"$f":"B32+B37","v":{"v":0,"d":"0.00"}},{"$f":"C32+C37","v":{"v":0,"d":"0.00"}},{"$f":"D32+D37","v":{"v":0,"d":"0.00"}}]
[]
["Probable Completion Date:",null,null,{"$f":"'Week 15'!D40","v":"2011-12-02"}]
[]
["Percent Completed This Week:",null,null,0]
["Percent completed to date:",null,null,{"$f":"'Week 15'!D43+D42","v":0}]
[]
["Next Week I expect to:"]

{"sheet":"Week 17","index":17,"n_rows":45,"n_cols":6,"rows_kept":45}
["WEEKLY SURVEY PROGRESS REPORT                                                  "]
[{"$f":"'Week 1'!A2","v":"<< name>>"},{"$f":"'Week 1'!B2","v":"<< title >>"}]
[{"$f":"'Week 1'!A3","v":"<< address >>"}]
["               "]
["No. of Weeks:",{"$f":"CEILING((B6-B17)/7,1)","v":0}]
["For Week Ending:",{"$f":"'Week 16'!B6","v":"2011-12-02"}]
["Proj. No.:",{"$f":"'Week 1'!B7","v":0},null,"Route:",{"$f":"'Week 1'!E7","v":0}]
["County:",{"$f":"'Week 1'!B8","v":0}]
["Length (miles):",{"$f":"'Week 1'!B9","v":0}]
["From Sta:",{"$f":"'Week 1'!B10","v":0},null,"To Sta:",{"$f":"'Week 1'!E10","v":0}]
[]
["From:",{"$f":"'Week 1'!B12","v":0}]
["To:",{"$f":"'Week 1'!B13","v":0}]
[]
["Project Filename:",{"$f":"'Week 1'!B15","v":0}]
["Data Collector Filename:",{"$f":"'Week 1'!B16","v":0}]
["Date Survey Began:",{"$f":"'Week 1'!B17","v":"2011-12-02"}]
[]
[]
[null,"Manhours","Mandays"]
[null,"This Week","This Week","To Date","% Complete","Comments"]
["Control Traverse",{"v":0,"d":"0.00"},{"$f":"B22/7.5","v":{"v":0,"d":"0.00"}},{"$f":"C22+'Week 16'!D22","v":{"v":0,"d":"0.00"}},{"$f":"'Week 16'!E22","v":0}]
["Alignment",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C23+'Week 16'!D23","v":{"v":0,"d":"0.00"}},{"$f":"'Week 16'!E23","v":0}]
["Terrain Model",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C24+'Week 16'!D24","v":{"v":0,"d":"0.00"}},{"$f":"'Week 16'!E24","v":0}]
["Topography",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C25+'Week 16'!D25","v":{"v":0,"d":"0.00"}},{"$f":"'Week 16'!E25","v":0}]
["Utilities ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C26+'Week 16'!D26","v":{"v":0,"d":"0.00"}},{"$f":"'Week 16'!E26","v":0}]
["Bench Levels",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C27+'Week 16'!D27","v":{"v":0,"d":"0.00"}},{"$f":"'Week 16'!E27","v":0}]
["Property/R.O.W.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C28+'Week 16'!D28","v":{"v":0,"d":"0.00"}},{"$f":"'Week 16'!E28","v":0}]
["Drainage",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C29+'Week 16'!D29","v":{"v":0,"d":"0.00"}},{"$f":"'Week 16'!E29","v":0}]
["Bridge Surveys ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C30+'Week 16'!D30","v":{"v":0,"d":"0.00"}},{"$f":"'Week 16'!E30","v":0}]
["Office ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C31+'Week 16'!D31","v":{"v":0,"d":"0.00"}},{"$f":"'Week 16'!E31","v":0}]
["Total Time Worked",{"$f":"SUM(B22:B31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C22:C31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D22:D31)","v":{"v":0,"d":"0.00"}}]
["Misc.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C33+'Week 16'!D33","v":{"v":0,"d":"0.00"}},{"$f":"'Week 16'!E33","v":0}]
["Lost Time-Travel",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C34+'Week 16'!D34","v":{"v":0,"d":"0.00"}},null,{"$f":"'Week 1'!F34","v":"travel dist. (miles) - "}]
["Lost Time-Leave",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C35+'Week 16'!D35","v":{"v":0,"d":"0.00"}}]
["Lost Time - Other",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C36+'Week 16'!D36","v":{"v":0,"d":"0.00"}},null,{"$f":"'Week 16'!F36","v":"explain:"}]
["Total Lost Time & Misc.",{"$f":"SUM(B33:B36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C33:C36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D33:D36)","v":{"v":0,"d":"0.00"}}]
["Grand Total",{"$f":"B32+B37","v":{"v":0,"d":"0.00"}},{"$f":"C32+C37","v":{"v":0,"d":"0.00"}},{"$f":"D32+D37","v":{"v":0,"d":"0.00"}}]
[]
["Probable Completion Date:",null,null,{"$f":"'Week 16'!D40","v":"2011-12-02"}]
[]
["Percent Completed This Week:",null,null,0]
["Percent completed to date:",null,null,{"$f":"'Week 16'!D43+D42","v":0}]
[]
["Next Week I expect to:"]

{"sheet":"Week 18","index":18,"n_rows":45,"n_cols":6,"rows_kept":45}
["WEEKLY SURVEY PROGRESS REPORT                                                  "]
[{"$f":"'Week 1'!A2","v":"<< name>>"},{"$f":"'Week 1'!B2","v":"<< title >>"}]
[{"$f":"'Week 1'!A3","v":"<< address >>"}]
["               "]
["No. of Weeks:",{"$f":"CEILING((B6-B17)/7,1)","v":0}]
["For Week Ending:",{"$f":"'Week 17'!B6","v":"2011-12-02"}]
["Proj. No.:",{"$f":"'Week 1'!B7","v":0},null,"Route:",{"$f":"'Week 1'!E7","v":0}]
["County:",{"$f":"'Week 1'!B8","v":0}]
["Length (miles):",{"$f":"'Week 1'!B9","v":0}]
["From Sta:",{"$f":"'Week 1'!B10","v":0},null,"To Sta:",{"$f":"'Week 1'!E10","v":0}]
[]
["From:",{"$f":"'Week 1'!B12","v":0}]
["To:",{"$f":"'Week 1'!B13","v":0}]
[]
["Project Filename:",{"$f":"'Week 1'!B15","v":0}]
["Data Collector Filename:",{"$f":"'Week 1'!B16","v":0}]
["Date Survey Began:",{"$f":"'Week 1'!B17","v":"2011-12-02"}]
[]
[]
[null,"Manhours","Mandays"]
[null,"This Week","This Week","To Date","% Complete","Comments"]
["Control Traverse",{"v":0,"d":"0.00"},{"$f":"B22/7.5","v":{"v":0,"d":"0.00"}},{"$f":"C22+'Week 17'!D22","v":{"v":0,"d":"0.00"}},{"$f":"'Week 17'!E22","v":0}]
["Alignment",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C23+'Week 17'!D23","v":{"v":0,"d":"0.00"}},{"$f":"'Week 17'!E23","v":0}]
["Terrain Model",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C24+'Week 17'!D24","v":{"v":0,"d":"0.00"}},{"$f":"'Week 17'!E24","v":0}]
["Topography",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C25+'Week 17'!D25","v":{"v":0,"d":"0.00"}},{"$f":"'Week 17'!E25","v":0}]
["Utilities ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C26+'Week 17'!D26","v":{"v":0,"d":"0.00"}},{"$f":"'Week 17'!E26","v":0}]
["Bench Levels",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C27+'Week 17'!D27","v":{"v":0,"d":"0.00"}},{"$f":"'Week 17'!E27","v":0}]
["Property/R.O.W.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C28+'Week 17'!D28","v":{"v":0,"d":"0.00"}},{"$f":"'Week 17'!E28","v":0}]
["Drainage",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C29+'Week 17'!D29","v":{"v":0,"d":"0.00"}},{"$f":"'Week 17'!E29","v":0}]
["Bridge Surveys ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C30+'Week 17'!D30","v":{"v":0,"d":"0.00"}},{"$f":"'Week 17'!E30","v":0}]
["Office ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C31+'Week 17'!D31","v":{"v":0,"d":"0.00"}},{"$f":"'Week 17'!E31","v":0}]
["Total Time Worked",{"$f":"SUM(B22:B31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C22:C31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D22:D31)","v":{"v":0,"d":"0.00"}}]
["Misc.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C33+'Week 17'!D33","v":{"v":0,"d":"0.00"}},{"$f":"'Week 17'!E33","v":0}]
["Lost Time-Travel",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C34+'Week 17'!D34","v":{"v":0,"d":"0.00"}},null,{"$f":"'Week 1'!F34","v":"travel dist. (miles) - "}]
["Lost Time-Leave",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C35+'Week 17'!D35","v":{"v":0,"d":"0.00"}}]
["Lost Time - Other",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C36+'Week 17'!D36","v":{"v":0,"d":"0.00"}},null,{"$f":"'Week 17'!F36","v":"explain:"}]
["Total Lost Time & Misc.",{"$f":"SUM(B33:B36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C33:C36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D33:D36)","v":{"v":0,"d":"0.00"}}]
["Grand Total",{"$f":"B32+B37","v":{"v":0,"d":"0.00"}},{"$f":"C32+C37","v":{"v":0,"d":"0.00"}},{"$f":"D32+D37","v":{"v":0,"d":"0.00"}}]
[]
["Probable Completion Date:",null,null,{"$f":"'Week 17'!D40","v":"2011-12-02"}]
[]
["Percent Completed This Week:",null,null,0]
["Percent completed to date:",null,null,{"$f":"'Week 17'!D43+D42","v":0}]
[]
["Next Week I expect to:"]

{"sheet":"Week 19","index":19,"n_rows":45,"n_cols":6,"rows_kept":45}
["WEEKLY SURVEY PROGRESS REPORT                                                  "]
[{"$f":"'Week 1'!A2","v":"<< name>>"},{"$f":"'Week 1'!B2","v":"<< title >>"}]
[{"$f":"'Week 1'!A3","v":"<< address >>"}]
["               "]
["No. of Weeks:",{"$f":"CEILING((B6-B17)/7,1)","v":0}]
["For Week Ending:",{"$f":"'Week 18'!B6","v":"2011-12-02"}]
["Proj. No.:",{"$f":"'Week 1'!B7","v":0},null,"Route:",{"$f":"'Week 1'!E7","v":0}]
["County:",{"$f":"'Week 1'!B8","v":0}]
["Length (miles):",{"$f":"'Week 1'!B9","v":0}]
["From Sta:",{"$f":"'Week 1'!B10","v":0},null,"To Sta:",{"$f":"'Week 1'!E10","v":0}]
[]
["From:",{"$f":"'Week 1'!B12","v":0}]
["To:",{"$f":"'Week 1'!B13","v":0}]
[]
["Project Filename:",{"$f":"'Week 1'!B15","v":0}]
["Data Collector Filename:",{"$f":"'Week 1'!B16","v":0}]
["Date Survey Began:",{"$f":"'Week 1'!B17","v":"2011-12-02"}]
[]
[]
[null,"Manhours","Mandays"]
[null,"This Week","This Week","To Date","% Complete","Comments"]
["Control Traverse",{"v":0,"d":"0.00"},{"$f":"B22/7.5","v":{"v":0,"d":"0.00"}},{"$f":"C22+'Week 18'!D22","v":{"v":0,"d":"0.00"}},{"$f":"'Week 18'!E22","v":0}]
["Alignment",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C23+'Week 18'!D23","v":{"v":0,"d":"0.00"}},{"$f":"'Week 18'!E23","v":0}]
["Terrain Model",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C24+'Week 18'!D24","v":{"v":0,"d":"0.00"}},{"$f":"'Week 18'!E24","v":0}]
["Topography",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C25+'Week 18'!D25","v":{"v":0,"d":"0.00"}},{"$f":"'Week 18'!E25","v":0}]
["Utilities ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C26+'Week 18'!D26","v":{"v":0,"d":"0.00"}},{"$f":"'Week 18'!E26","v":0}]
["Bench Levels",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C27+'Week 18'!D27","v":{"v":0,"d":"0.00"}},{"$f":"'Week 18'!E27","v":0}]
["Property/R.O.W.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C28+'Week 18'!D28","v":{"v":0,"d":"0.00"}},{"$f":"'Week 18'!E28","v":0}]
["Drainage",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C29+'Week 18'!D29","v":{"v":0,"d":"0.00"}},{"$f":"'Week 18'!E29","v":0}]
["Bridge Surveys ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C30+'Week 18'!D30","v":{"v":0,"d":"0.00"}},{"$f":"'Week 18'!E30","v":0}]
["Office ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C31+'Week 18'!D31","v":{"v":0,"d":"0.00"}},{"$f":"'Week 18'!E31","v":0}]
["Total Time Worked",{"$f":"SUM(B22:B31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C22:C31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D22:D31)","v":{"v":0,"d":"0.00"}}]
["Misc.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C33+'Week 18'!D33","v":{"v":0,"d":"0.00"}},{"$f":"'Week 18'!E33","v":0}]
["Lost Time-Travel",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C34+'Week 18'!D34","v":{"v":0,"d":"0.00"}},null,{"$f":"'Week 1'!F34","v":"travel dist. (miles) - "}]
["Lost Time-Leave",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C35+'Week 18'!D35","v":{"v":0,"d":"0.00"}}]
["Lost Time - Other",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C36+'Week 18'!D36","v":{"v":0,"d":"0.00"}},null,{"$f":"'Week 18'!F36","v":"explain:"}]
["Total Lost Time & Misc.",{"$f":"SUM(B33:B36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C33:C36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D33:D36)","v":{"v":0,"d":"0.00"}}]
["Grand Total",{"$f":"B32+B37","v":{"v":0,"d":"0.00"}},{"$f":"C32+C37","v":{"v":0,"d":"0.00"}},{"$f":"D32+D37","v":{"v":0,"d":"0.00"}}]
[]
["Probable Completion Date:",null,null,{"$f":"'Week 18'!D40","v":"2011-12-02"}]
[]
["Percent Completed This Week:",null,null,0]
["Percent completed to date:",null,null,{"$f":"'Week 18'!D43+D42","v":0}]
[]
["Next Week I expect to:"]

{"sheet":"Week 20","index":20,"n_rows":45,"n_cols":6,"rows_kept":45}
["WEEKLY SURVEY PROGRESS REPORT                                                  "]
[{"$f":"'Week 1'!A2","v":"<< name>>"},{"$f":"'Week 1'!B2","v":"<< title >>"}]
[{"$f":"'Week 1'!A3","v":"<< address >>"}]
["               "]
["No. of Weeks:",{"$f":"CEILING((B6-B17)/7,1)","v":0}]
["For Week Ending:",{"$f":"'Week 19'!B6","v":"2011-12-02"}]
["Proj. No.:",{"$f":"'Week 1'!B7","v":0},null,"Route:",{"$f":"'Week 1'!E7","v":0}]
["County:",{"$f":"'Week 1'!B8","v":0}]
["Length (miles):",{"$f":"'Week 1'!B9","v":0}]
["From Sta:",{"$f":"'Week 1'!B10","v":0},null,"To Sta:",{"$f":"'Week 1'!E10","v":0}]
[]
["From:",{"$f":"'Week 1'!B12","v":0}]
["To:",{"$f":"'Week 1'!B13","v":0}]
[]
["Project Filename:",{"$f":"'Week 1'!B15","v":0}]
["Data Collector Filename:",{"$f":"'Week 1'!B16","v":0}]
["Date Survey Began:",{"$f":"'Week 1'!B17","v":"2011-12-02"}]
[]
[]
[null,"Manhours","Mandays"]
[null,"This Week","This Week","To Date","% Complete","Comments"]
["Control Traverse",{"v":0,"d":"0.00"},{"$f":"B22/7.5","v":{"v":0,"d":"0.00"}},{"$f":"C22+'Week 19'!D22","v":{"v":0,"d":"0.00"}},{"$f":"'Week 19'!E22","v":0}]
["Alignment",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C23+'Week 19'!D23","v":{"v":0,"d":"0.00"}},{"$f":"'Week 19'!E23","v":0}]
["Terrain Model",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C24+'Week 19'!D24","v":{"v":0,"d":"0.00"}},{"$f":"'Week 19'!E24","v":0}]
["Topography",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C25+'Week 19'!D25","v":{"v":0,"d":"0.00"}},{"$f":"'Week 19'!E25","v":0}]
["Utilities ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C26+'Week 19'!D26","v":{"v":0,"d":"0.00"}},{"$f":"'Week 19'!E26","v":0}]
["Bench Levels",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C27+'Week 19'!D27","v":{"v":0,"d":"0.00"}},{"$f":"'Week 19'!E27","v":0}]
["Property/R.O.W.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C28+'Week 19'!D28","v":{"v":0,"d":"0.00"}},{"$f":"'Week 19'!E28","v":0}]
["Drainage",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C29+'Week 19'!D29","v":{"v":0,"d":"0.00"}},{"$f":"'Week 19'!E29","v":0}]
["Bridge Surveys ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C30+'Week 19'!D30","v":{"v":0,"d":"0.00"}},{"$f":"'Week 19'!E30","v":0}]
["Office ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C31+'Week 19'!D31","v":{"v":0,"d":"0.00"}},{"$f":"'Week 19'!E31","v":0}]
["Total Time Worked",{"$f":"SUM(B22:B31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C22:C31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D22:D31)","v":{"v":0,"d":"0.00"}}]
["Misc.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C33+'Week 19'!D33","v":{"v":0,"d":"0.00"}},{"$f":"'Week 19'!E33","v":0}]
["Lost Time-Travel",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C34+'Week 19'!D34","v":{"v":0,"d":"0.00"}},null,{"$f":"'Week 1'!F34","v":"travel dist. (miles) - "}]
["Lost Time-Leave",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C35+'Week 19'!D35","v":{"v":0,"d":"0.00"}}]
["Lost Time - Other",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C36+'Week 19'!D36","v":{"v":0,"d":"0.00"}},null,{"$f":"'Week 19'!F36","v":"explain:"}]
["Total Lost Time & Misc.",{"$f":"SUM(B33:B36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C33:C36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D33:D36)","v":{"v":0,"d":"0.00"}}]
["Grand Total",{"$f":"B32+B37","v":{"v":0,"d":"0.00"}},{"$f":"C32+C37","v":{"v":0,"d":"0.00"}},{"$f":"D32+D37","v":{"v":0,"d":"0.00"}}]
[]
["Probable Completion Date:",null,null,{"$f":"'Week 19'!D40","v":"2011-12-02"}]
[]
["Percent Completed This Week:",null,null,0]
["Percent completed to date:",null,null,{"$f":"'Week 19'!D43+D42","v":0}]
[]
["Next Week I expect to:"]

{"sheet":"Week 21","index":21,"n_rows":45,"n_cols":6,"rows_kept":45}
["WEEKLY SURVEY PROGRESS REPORT                                                  "]
[{"$f":"'Week 1'!A2","v":"<< name>>"},{"$f":"'Week 1'!B2","v":"<< title >>"}]
[{"$f":"'Week 1'!A3","v":"<< address >>"}]
["               "]
["No. of Weeks:",{"$f":"CEILING((B6-B17)/7,1)","v":0}]
["For Week Ending:",{"$f":"'Week 20'!B6","v":"2011-12-02"}]
["Proj. No.:",{"$f":"'Week 1'!B7","v":0},null,"Route:",{"$f":"'Week 1'!E7","v":0}]
["County:",{"$f":"'Week 1'!B8","v":0}]
["Length (miles):",{"$f":"'Week 1'!B9","v":0}]
["From Sta:",{"$f":"'Week 1'!B10","v":0},null,"To Sta:",{"$f":"'Week 1'!E10","v":0}]
[]
["From:",{"$f":"'Week 1'!B12","v":0}]
["To:",{"$f":"'Week 1'!B13","v":0}]
[]
["Project Filename:",{"$f":"'Week 1'!B15","v":0}]
["Data Collector Filename:",{"$f":"'Week 1'!B16","v":0}]
["Date Survey Began:",{"$f":"'Week 1'!B17","v":"2011-12-02"}]
[]
[]
[null,"Manhours","Mandays"]
[null,"This Week","This Week","To Date","% Complete","Comments"]
["Control Traverse",{"v":0,"d":"0.00"},{"$f":"B22/7.5","v":{"v":0,"d":"0.00"}},{"$f":"C22+'Week 20'!D22","v":{"v":0,"d":"0.00"}},{"$f":"'Week 20'!E22","v":0}]
["Alignment",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C23+'Week 20'!D23","v":{"v":0,"d":"0.00"}},{"$f":"'Week 20'!E23","v":0}]
["Terrain Model",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C24+'Week 20'!D24","v":{"v":0,"d":"0.00"}},{"$f":"'Week 20'!E24","v":0}]
["Topography",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C25+'Week 20'!D25","v":{"v":0,"d":"0.00"}},{"$f":"'Week 20'!E25","v":0}]
["Utilities ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C26+'Week 20'!D26","v":{"v":0,"d":"0.00"}},{"$f":"'Week 20'!E26","v":0}]
["Bench Levels",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C27+'Week 20'!D27","v":{"v":0,"d":"0.00"}},{"$f":"'Week 20'!E27","v":0}]
["Property/R.O.W.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C28+'Week 20'!D28","v":{"v":0,"d":"0.00"}},{"$f":"'Week 20'!E28","v":0}]
["Drainage",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C29+'Week 20'!D29","v":{"v":0,"d":"0.00"}},{"$f":"'Week 20'!E29","v":0}]
["Bridge Surveys ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C30+'Week 20'!D30","v":{"v":0,"d":"0.00"}},{"$f":"'Week 20'!E30","v":0}]
["Office ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C31+'Week 20'!D31","v":{"v":0,"d":"0.00"}},{"$f":"'Week 20'!E31","v":0}]
["Total Time Worked",{"$f":"SUM(B22:B31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C22:C31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D22:D31)","v":{"v":0,"d":"0.00"}}]
["Misc.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C33+'Week 20'!D33","v":{"v":0,"d":"0.00"}},{"$f":"'Week 20'!E33","v":0}]
["Lost Time-Travel",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C34+'Week 20'!D34","v":{"v":0,"d":"0.00"}},null,{"$f":"'Week 1'!F34","v":"travel dist. (miles) - "}]
["Lost Time-Leave",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C35+'Week 20'!D35","v":{"v":0,"d":"0.00"}}]
["Lost Time - Other",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C36+'Week 20'!D36","v":{"v":0,"d":"0.00"}},null,{"$f":"'Week 20'!F36","v":"explain:"}]
["Total Lost Time & Misc.",{"$f":"SUM(B33:B36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C33:C36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D33:D36)","v":{"v":0,"d":"0.00"}}]
["Grand Total",{"$f":"B32+B37","v":{"v":0,"d":"0.00"}},{"$f":"C32+C37","v":{"v":0,"d":"0.00"}},{"$f":"D32+D37","v":{"v":0,"d":"0.00"}}]
[]
["Probable Completion Date:",null,null,{"$f":"'Week 20'!D40","v":"2011-12-02"}]
[]
["Percent Completed This Week:",null,null,0]
["Percent completed to date:",null,null,{"$f":"'Week 20'!D43+D42","v":0}]
[]
["Next Week I expect to:"]

{"sheet":"Week 22","index":22,"n_rows":45,"n_cols":6,"rows_kept":45}
["WEEKLY SURVEY PROGRESS REPORT                                                  "]
[{"$f":"'Week 1'!A2","v":"<< name>>"},{"$f":"'Week 1'!B2","v":"<< title >>"}]
[{"$f":"'Week 1'!A3","v":"<< address >>"}]
["               "]
["No. of Weeks:",{"$f":"CEILING((B6-B17)/7,1)","v":0}]
["For Week Ending:",{"$f":"'Week 21'!B6","v":"2011-12-02"}]
["Proj. No.:",{"$f":"'Week 1'!B7","v":0},null,"Route:",{"$f":"'Week 1'!E7","v":0}]
["County:",{"$f":"'Week 1'!B8","v":0}]
["Length (miles):",{"$f":"'Week 1'!B9","v":0}]
["From Sta:",{"$f":"'Week 1'!B10","v":0},null,"To Sta:",{"$f":"'Week 1'!E10","v":0}]
[]
["From:",{"$f":"'Week 1'!B12","v":0}]
["To:",{"$f":"'Week 1'!B13","v":0}]
[]
["Project Filename:",{"$f":"'Week 1'!B15","v":0}]
["Data Collector Filename:",{"$f":"'Week 1'!B16","v":0}]
["Date Survey Began:",{"$f":"'Week 1'!B17","v":"2011-12-02"}]
[]
[]
[null,"Manhours","Mandays"]
[null,"This Week","This Week","To Date","% Complete","Comments"]
["Control Traverse",{"v":0,"d":"0.00"},{"$f":"B22/7.5","v":{"v":0,"d":"0.00"}},{"$f":"C22+'Week 21'!D22","v":{"v":0,"d":"0.00"}},{"$f":"'Week 21'!E22","v":0}]
["Alignment",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C23+'Week 21'!D23","v":{"v":0,"d":"0.00"}},{"$f":"'Week 21'!E23","v":0}]
["Terrain Model",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C24+'Week 21'!D24","v":{"v":0,"d":"0.00"}},{"$f":"'Week 21'!E24","v":0}]
["Topography",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C25+'Week 21'!D25","v":{"v":0,"d":"0.00"}},{"$f":"'Week 21'!E25","v":0}]
["Utilities ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C26+'Week 21'!D26","v":{"v":0,"d":"0.00"}},{"$f":"'Week 21'!E26","v":0}]
["Bench Levels",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C27+'Week 21'!D27","v":{"v":0,"d":"0.00"}},{"$f":"'Week 21'!E27","v":0}]
["Property/R.O.W.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C28+'Week 21'!D28","v":{"v":0,"d":"0.00"}},{"$f":"'Week 21'!E28","v":0}]
["Drainage",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C29+'Week 21'!D29","v":{"v":0,"d":"0.00"}},{"$f":"'Week 21'!E29","v":0}]
["Bridge Surveys ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C30+'Week 21'!D30","v":{"v":0,"d":"0.00"}},{"$f":"'Week 21'!E30","v":0}]
["Office ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C31+'Week 21'!D31","v":{"v":0,"d":"0.00"}},{"$f":"'Week 21'!E31","v":0}]
["Total Time Worked",{"$f":"SUM(B22:B31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C22:C31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D22:D31)","v":{"v":0,"d":"0.00"}}]
["Misc.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C33+'Week 21'!D33","v":{"v":0,"d":"0.00"}},{"$f":"'Week 21'!E33","v":0}]
["Lost Time-Travel",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C34+'Week 21'!D34","v":{"v":0,"d":"0.00"}},null,{"$f":"'Week 1'!F34","v":"travel dist. (miles) - "}]
["Lost Time-Leave",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C35+'Week 21'!D35","v":{"v":0,"d":"0.00"}}]
["Lost Time - Other",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C36+'Week 21'!D36","v":{"v":0,"d":"0.00"}},null,{"$f":"'Week 21'!F36","v":"explain:"}]
["Total Lost Time & Misc.",{"$f":"SUM(B33:B36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C33:C36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D33:D36)","v":{"v":0,"d":"0.00"}}]
["Grand Total",{"$f":"B32+B37","v":{"v":0,"d":"0.00"}},{"$f":"C32+C37","v":{"v":0,"d":"0.00"}},{"$f":"D32+D37","v":{"v":0,"d":"0.00"}}]
[]
["Probable Completion Date:",null,null,{"$f":"'Week 21'!D40","v":"2011-12-02"}]
[]
["Percent Completed This Week:",null,null,0]
["Percent completed to date:",null,null,{"$f":"'Week 21'!D43+D42","v":0}]
[]
["Next Week I expect to:"]

{"sheet":"Week 23","index":23,"n_rows":45,"n_cols":6,"rows_kept":45}
["WEEKLY SURVEY PROGRESS REPORT                                                  "]
[{"$f":"'Week 1'!A2","v":"<< name>>"},{"$f":"'Week 1'!B2","v":"<< title >>"}]
[{"$f":"'Week 1'!A3","v":"<< address >>"}]
["               "]
["No. of Weeks:",{"$f":"CEILING((B6-B17)/7,1)","v":0}]
["For Week Ending:",{"$f":"'Week 22'!B6","v":"2011-12-02"}]
["Proj. No.:",{"$f":"'Week 1'!B7","v":0},null,"Route:",{"$f":"'Week 1'!E7","v":0}]
["County:",{"$f":"'Week 1'!B8","v":0}]
["Length (miles):",{"$f":"'Week 1'!B9","v":0}]
["From Sta:",{"$f":"'Week 1'!B10","v":0},null,"To Sta:",{"$f":"'Week 1'!E10","v":0}]
[]
["From:",{"$f":"'Week 1'!B12","v":0}]
["To:",{"$f":"'Week 1'!B13","v":0}]
[]
["Project Filename:",{"$f":"'Week 1'!B15","v":0}]
["Data Collector Filename:",{"$f":"'Week 1'!B16","v":0}]
["Date Survey Began:",{"$f":"'Week 1'!B17","v":"2011-12-02"}]
[]
[]
[null,"Manhours","Mandays"]
[null,"This Week","This Week","To Date","% Complete","Comments"]
["Control Traverse",{"v":0,"d":"0.00"},{"$f":"B22/7.5","v":{"v":0,"d":"0.00"}},{"$f":"C22+'Week 22'!D22","v":{"v":0,"d":"0.00"}},{"$f":"'Week 22'!E22","v":0}]
["Alignment",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C23+'Week 22'!D23","v":{"v":0,"d":"0.00"}},{"$f":"'Week 22'!E23","v":0}]
["Terrain Model",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C24+'Week 22'!D24","v":{"v":0,"d":"0.00"}},{"$f":"'Week 22'!E24","v":0}]
["Topography",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C25+'Week 22'!D25","v":{"v":0,"d":"0.00"}},{"$f":"'Week 22'!E25","v":0}]
["Utilities ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C26+'Week 22'!D26","v":{"v":0,"d":"0.00"}},{"$f":"'Week 22'!E26","v":0}]
["Bench Levels",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C27+'Week 22'!D27","v":{"v":0,"d":"0.00"}},{"$f":"'Week 22'!E27","v":0}]
["Property/R.O.W.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C28+'Week 22'!D28","v":{"v":0,"d":"0.00"}},{"$f":"'Week 22'!E28","v":0}]
["Drainage",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C29+'Week 22'!D29","v":{"v":0,"d":"0.00"}},{"$f":"'Week 22'!E29","v":0}]
["Bridge Surveys ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C30+'Week 22'!D30","v":{"v":0,"d":"0.00"}},{"$f":"'Week 22'!E30","v":0}]
["Office ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C31+'Week 22'!D31","v":{"v":0,"d":"0.00"}},{"$f":"'Week 22'!E31","v":0}]
["Total Time Worked",{"$f":"SUM(B22:B31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C22:C31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D22:D31)","v":{"v":0,"d":"0.00"}}]
["Misc.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C33+'Week 22'!D33","v":{"v":0,"d":"0.00"}},{"$f":"'Week 22'!E33","v":0}]
["Lost Time-Travel",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C34+'Week 22'!D34","v":{"v":0,"d":"0.00"}},null,{"$f":"'Week 1'!F34","v":"travel dist. (miles) - "}]
["Lost Time-Leave",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C35+'Week 22'!D35","v":{"v":0,"d":"0.00"}}]
["Lost Time - Other",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C36+'Week 22'!D36","v":{"v":0,"d":"0.00"}},null,{"$f":"'Week 22'!F36","v":"explain:"}]
["Total Lost Time & Misc.",{"$f":"SUM(B33:B36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C33:C36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D33:D36)","v":{"v":0,"d":"0.00"}}]
["Grand Total",{"$f":"B32+B37","v":{"v":0,"d":"0.00"}},{"$f":"C32+C37","v":{"v":0,"d":"0.00"}},{"$f":"D32+D37","v":{"v":0,"d":"0.00"}}]
[]
["Probable Completion Date:",null,null,{"$f":"'Week 22'!D40","v":"2011-12-02"}]
[]
["Percent Completed This Week:",null,null,0]
["Percent completed to date:",null,null,{"$f":"'Week 22'!D43+D42","v":0}]
[]
["Next Week I expect to:"]

{"sheet":"Week 24","index":24,"n_rows":45,"n_cols":6,"rows_kept":45}
["WEEKLY SURVEY PROGRESS REPORT                                                  "]
[{"$f":"'Week 1'!A2","v":"<< name>>"},{"$f":"'Week 1'!B2","v":"<< title >>"}]
[{"$f":"'Week 1'!A3","v":"<< address >>"}]
["               "]
["No. of Weeks:",{"$f":"CEILING((B6-B17)/7,1)","v":0}]
["For Week Ending:",{"$f":"'Week 23'!B6","v":"2011-12-02"}]
["Proj. No.:",{"$f":"'Week 1'!B7","v":0},null,"Route:",{"$f":"'Week 1'!E7","v":0}]
["County:",{"$f":"'Week 1'!B8","v":0}]
["Length (miles):",{"$f":"'Week 1'!B9","v":0}]
["From Sta:",{"$f":"'Week 1'!B10","v":0},null,"To Sta:",{"$f":"'Week 1'!E10","v":0}]
[]
["From:",{"$f":"'Week 1'!B12","v":0}]
["To:",{"$f":"'Week 1'!B13","v":0}]
[]
["Project Filename:",{"$f":"'Week 1'!B15","v":0}]
["Data Collector Filename:",{"$f":"'Week 1'!B16","v":0}]
["Date Survey Began:",{"$f":"'Week 1'!B17","v":"2011-12-02"}]
[]
[]
[null,"Manhours","Mandays"]
[null,"This Week","This Week","To Date","% Complete","Comments"]
["Control Traverse",{"v":0,"d":"0.00"},{"$f":"B22/7.5","v":{"v":0,"d":"0.00"}},{"$f":"C22+'Week 23'!D22","v":{"v":0,"d":"0.00"}},{"$f":"'Week 23'!E22","v":0}]
["Alignment",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C23+'Week 23'!D23","v":{"v":0,"d":"0.00"}},{"$f":"'Week 23'!E23","v":0}]
["Terrain Model",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C24+'Week 23'!D24","v":{"v":0,"d":"0.00"}},{"$f":"'Week 23'!E24","v":0}]
["Topography",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C25+'Week 23'!D25","v":{"v":0,"d":"0.00"}},{"$f":"'Week 23'!E25","v":0}]
["Utilities ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C26+'Week 23'!D26","v":{"v":0,"d":"0.00"}},{"$f":"'Week 23'!E26","v":0}]
["Bench Levels",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C27+'Week 23'!D27","v":{"v":0,"d":"0.00"}},{"$f":"'Week 23'!E27","v":0}]
["Property/R.O.W.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C28+'Week 23'!D28","v":{"v":0,"d":"0.00"}},{"$f":"'Week 23'!E28","v":0}]
["Drainage",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C29+'Week 23'!D29","v":{"v":0,"d":"0.00"}},{"$f":"'Week 23'!E29","v":0}]
["Bridge Surveys ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C30+'Week 23'!D30","v":{"v":0,"d":"0.00"}},{"$f":"'Week 23'!E30","v":0}]
["Office ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C31+'Week 23'!D31","v":{"v":0,"d":"0.00"}},{"$f":"'Week 23'!E31","v":0}]
["Total Time Worked",{"$f":"SUM(B22:B31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C22:C31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D22:D31)","v":{"v":0,"d":"0.00"}}]
["Misc.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C33+'Week 23'!D33","v":{"v":0,"d":"0.00"}},{"$f":"'Week 23'!E33","v":0}]
["Lost Time-Travel",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C34+'Week 23'!D34","v":{"v":0,"d":"0.00"}},null,{"$f":"'Week 1'!F34","v":"travel dist. (miles) - "}]
["Lost Time-Leave",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C35+'Week 23'!D35","v":{"v":0,"d":"0.00"}}]
["Lost Time - Other",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C36+'Week 23'!D36","v":{"v":0,"d":"0.00"}},null,{"$f":"'Week 23'!F36","v":"explain:"}]
["Total Lost Time & Misc.",{"$f":"SUM(B33:B36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C33:C36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D33:D36)","v":{"v":0,"d":"0.00"}}]
["Grand Total",{"$f":"B32+B37","v":{"v":0,"d":"0.00"}},{"$f":"C32+C37","v":{"v":0,"d":"0.00"}},{"$f":"D32+D37","v":{"v":0,"d":"0.00"}}]
[]
["Probable Completion Date:",null,null,{"$f":"'Week 23'!D40","v":"2011-12-02"}]
[]
["Percent Completed This Week:",null,null,0]
["Percent completed to date:",null,null,{"$f":"'Week 23'!D43+D42","v":0}]
[]
["Next Week I expect to:"]

{"sheet":"Week 25","index":25,"n_rows":45,"n_cols":6,"rows_kept":45}
["WEEKLY SURVEY PROGRESS REPORT                                                  "]
[{"$f":"'Week 1'!A2","v":"<< name>>"},{"$f":"'Week 1'!B2","v":"<< title >>"}]
[{"$f":"'Week 1'!A3","v":"<< address >>"}]
["               "]
["No. of Weeks:",{"$f":"CEILING((B6-B17)/7,1)","v":0}]
["For Week Ending:",{"$f":"'Week 24'!B6","v":"2011-12-02"}]
["Proj. No.:",{"$f":"'Week 1'!B7","v":0},null,"Route:",{"$f":"'Week 1'!E7","v":0}]
["County:",{"$f":"'Week 1'!B8","v":0}]
["Length (miles):",{"$f":"'Week 1'!B9","v":0}]
["From Sta:",{"$f":"'Week 1'!B10","v":0},null,"To Sta:",{"$f":"'Week 1'!E10","v":0}]
[]
["From:",{"$f":"'Week 1'!B12","v":0}]
["To:",{"$f":"'Week 1'!B13","v":0}]
[]
["Project Filename:",{"$f":"'Week 1'!B15","v":0}]
["Data Collector Filename:",{"$f":"'Week 1'!B16","v":0}]
["Date Survey Began:",{"$f":"'Week 1'!B17","v":"2011-12-02"}]
[]
[]
[null,"Manhours","Mandays"]
[null,"This Week","This Week","To Date","% Complete","Comments"]
["Control Traverse",{"v":0,"d":"0.00"},{"$f":"B22/7.5","v":{"v":0,"d":"0.00"}},{"$f":"C22+'Week 24'!D22","v":{"v":0,"d":"0.00"}},{"$f":"'Week 24'!E22","v":0}]
["Alignment",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C23+'Week 24'!D23","v":{"v":0,"d":"0.00"}},{"$f":"'Week 24'!E23","v":0}]
["Terrain Model",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C24+'Week 24'!D24","v":{"v":0,"d":"0.00"}},{"$f":"'Week 24'!E24","v":0}]
["Topography",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C25+'Week 24'!D25","v":{"v":0,"d":"0.00"}},{"$f":"'Week 24'!E25","v":0}]
["Utilities ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C26+'Week 24'!D26","v":{"v":0,"d":"0.00"}},{"$f":"'Week 24'!E26","v":0}]
["Bench Levels",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C27+'Week 24'!D27","v":{"v":0,"d":"0.00"}},{"$f":"'Week 24'!E27","v":0}]
["Property/R.O.W.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C28+'Week 24'!D28","v":{"v":0,"d":"0.00"}},{"$f":"'Week 24'!E28","v":0}]
["Drainage",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C29+'Week 24'!D29","v":{"v":0,"d":"0.00"}},{"$f":"'Week 24'!E29","v":0}]
["Bridge Surveys ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C30+'Week 24'!D30","v":{"v":0,"d":"0.00"}},{"$f":"'Week 24'!E30","v":0}]
["Office ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C31+'Week 24'!D31","v":{"v":0,"d":"0.00"}},{"$f":"'Week 24'!E31","v":0}]
["Total Time Worked",{"$f":"SUM(B22:B31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C22:C31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D22:D31)","v":{"v":0,"d":"0.00"}}]
["Misc.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C33+'Week 24'!D33","v":{"v":0,"d":"0.00"}},{"$f":"'Week 24'!E33","v":0}]
["Lost Time-Travel",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C34+'Week 24'!D34","v":{"v":0,"d":"0.00"}},null,{"$f":"'Week 1'!F34","v":"travel dist. (miles) - "}]
["Lost Time-Leave",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C35+'Week 24'!D35","v":{"v":0,"d":"0.00"}}]
["Lost Time - Other",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C36+'Week 24'!D36","v":{"v":0,"d":"0.00"}},null,{"$f":"'Week 24'!F36","v":"explain:"}]
["Total Lost Time & Misc.",{"$f":"SUM(B33:B36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C33:C36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D33:D36)","v":{"v":0,"d":"0.00"}}]
["Grand Total",{"$f":"B32+B37","v":{"v":0,"d":"0.00"}},{"$f":"C32+C37","v":{"v":0,"d":"0.00"}},{"$f":"D32+D37","v":{"v":0,"d":"0.00"}}]
[]
["Probable Completion Date:",null,null,{"$f":"'Week 24'!D40","v":"2011-12-02"}]
[]
["Percent Completed This Week:",null,null,0]
["Percent completed to date:",null,null,{"$f":"'Week 24'!D43+D42","v":0}]
[]
["Next Week I expect to:"]

{"sheet":"Week 26","index":26,"n_rows":45,"n_cols":6,"rows_kept":45}
["WEEKLY SURVEY PROGRESS REPORT                                                  "]
[{"$f":"'Week 1'!A2","v":"<< name>>"},{"$f":"'Week 1'!B2","v":"<< title >>"}]
[{"$f":"'Week 1'!A3","v":"<< address >>"}]
["               "]
["No. of Weeks:",{"$f":"CEILING((B6-B17)/7,1)","v":0}]
["For Week Ending:",{"$f":"'Week 25'!B6","v":"2011-12-02"}]
["Proj. No.:",{"$f":"'Week 1'!B7","v":0},null,"Route:",{"$f":"'Week 1'!E7","v":0}]
["County:",{"$f":"'Week 1'!B8","v":0}]
["Length (miles):",{"$f":"'Week 1'!B9","v":0}]
["From Sta:",{"$f":"'Week 1'!B10","v":0},null,"To Sta:",{"$f":"'Week 1'!E10","v":0}]
[]
["From:",{"$f":"'Week 1'!B12","v":0}]
["To:",{"$f":"'Week 1'!B13","v":0}]
[]
["Project Filename:",{"$f":"'Week 1'!B15","v":0}]
["Data Collector Filename:",{"$f":"'Week 1'!B16","v":0}]
["Date Survey Began:",{"$f":"'Week 1'!B17","v":"2011-12-02"}]
[]
[]
[null,"Manhours","Mandays"]
[null,"This Week","This Week","To Date","% Complete","Comments"]
["Control Traverse",{"v":0,"d":"0.00"},{"$f":"B22/7.5","v":{"v":0,"d":"0.00"}},{"$f":"C22+'Week 25'!D22","v":{"v":0,"d":"0.00"}},{"$f":"'Week 25'!E22","v":0}]
["Alignment",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C23+'Week 25'!D23","v":{"v":0,"d":"0.00"}},{"$f":"'Week 25'!E23","v":0}]
["Terrain Model",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C24+'Week 25'!D24","v":{"v":0,"d":"0.00"}},{"$f":"'Week 25'!E24","v":0}]
["Topography",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C25+'Week 25'!D25","v":{"v":0,"d":"0.00"}},{"$f":"'Week 25'!E25","v":0}]
["Utilities ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C26+'Week 25'!D26","v":{"v":0,"d":"0.00"}},{"$f":"'Week 25'!E26","v":0}]
["Bench Levels",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C27+'Week 25'!D27","v":{"v":0,"d":"0.00"}},{"$f":"'Week 25'!E27","v":0}]
["Property/R.O.W.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C28+'Week 25'!D28","v":{"v":0,"d":"0.00"}},{"$f":"'Week 25'!E28","v":0}]
["Drainage",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C29+'Week 25'!D29","v":{"v":0,"d":"0.00"}},{"$f":"'Week 25'!E29","v":0}]
["Bridge Surveys ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C30+'Week 25'!D30","v":{"v":0,"d":"0.00"}},{"$f":"'Week 25'!E30","v":0}]
["Office ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C31+'Week 25'!D31","v":{"v":0,"d":"0.00"}},{"$f":"'Week 25'!E31","v":0}]
["Total Time Worked",{"$f":"SUM(B22:B31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C22:C31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D22:D31)","v":{"v":0,"d":"0.00"}}]
["Misc.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C33+'Week 25'!D33","v":{"v":0,"d":"0.00"}},{"$f":"'Week 25'!E33","v":0}]
["Lost Time-Travel",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C34+'Week 25'!D34","v":{"v":0,"d":"0.00"}},null,{"$f":"'Week 1'!F34","v":"travel dist. (miles) - "}]
["Lost Time-Leave",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C35+'Week 25'!D35","v":{"v":0,"d":"0.00"}}]
["Lost Time - Other",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C36+'Week 25'!D36","v":{"v":0,"d":"0.00"}},null,{"$f":"'Week 25'!F36","v":"explain:"}]
["Total Lost Time & Misc.",{"$f":"SUM(B33:B36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C33:C36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D33:D36)","v":{"v":0,"d":"0.00"}}]
["Grand Total",{"$f":"B32+B37","v":{"v":0,"d":"0.00"}},{"$f":"C32+C37","v":{"v":0,"d":"0.00"}},{"$f":"D32+D37","v":{"v":0,"d":"0.00"}}]
[]
["Probable Completion Date:",null,null,{"$f":"'Week 25'!D40","v":"2011-12-02"}]
[]
["Percent Completed This Week:",null,null,0]
["Percent completed to date:",null,null,{"$f":"'Week 25'!D43+D42","v":0}]
[]
["Next Week I expect to:"]

{"sheet":"Week 27","index":27,"n_rows":45,"n_cols":6,"rows_kept":45}
["WEEKLY SURVEY PROGRESS REPORT                                                  "]
[{"$f":"'Week 1'!A2","v":"<< name>>"},{"$f":"'Week 1'!B2","v":"<< title >>"}]
[{"$f":"'Week 1'!A3","v":"<< address >>"}]
["               "]
["No. of Weeks:",{"$f":"CEILING((B6-B17)/7,1)","v":0}]
["For Week Ending:",{"$f":"'Week 26'!B6","v":"2011-12-02"}]
["Proj. No.:",{"$f":"'Week 1'!B7","v":0},null,"Route:",{"$f":"'Week 1'!E7","v":0}]
["County:",{"$f":"'Week 1'!B8","v":0}]
["Length (miles):",{"$f":"'Week 1'!B9","v":0}]
["From Sta:",{"$f":"'Week 1'!B10","v":0},null,"To Sta:",{"$f":"'Week 1'!E10","v":0}]
[]
["From:",{"$f":"'Week 1'!B12","v":0}]
["To:",{"$f":"'Week 1'!B13","v":0}]
[]
["Project Filename:",{"$f":"'Week 1'!B15","v":0}]
["Data Collector Filename:",{"$f":"'Week 1'!B16","v":0}]
["Date Survey Began:",{"$f":"'Week 1'!B17","v":"2011-12-02"}]
[]
[]
[null,"Manhours","Mandays"]
[null,"This Week","This Week","To Date","% Complete","Comments"]
["Control Traverse",{"v":0,"d":"0.00"},{"$f":"B22/7.5","v":{"v":0,"d":"0.00"}},{"$f":"C22+'Week 26'!D22","v":{"v":0,"d":"0.00"}},{"$f":"'Week 26'!E22","v":0}]
["Alignment",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C23+'Week 26'!D23","v":{"v":0,"d":"0.00"}},{"$f":"'Week 26'!E23","v":0}]
["Terrain Model",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C24+'Week 26'!D24","v":{"v":0,"d":"0.00"}},{"$f":"'Week 26'!E24","v":0}]
["Topography",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C25+'Week 26'!D25","v":{"v":0,"d":"0.00"}},{"$f":"'Week 26'!E25","v":0}]
["Utilities ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C26+'Week 26'!D26","v":{"v":0,"d":"0.00"}},{"$f":"'Week 26'!E26","v":0}]
["Bench Levels",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C27+'Week 26'!D27","v":{"v":0,"d":"0.00"}},{"$f":"'Week 26'!E27","v":0}]
["Property/R.O.W.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C28+'Week 26'!D28","v":{"v":0,"d":"0.00"}},{"$f":"'Week 26'!E28","v":0}]
["Drainage",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C29+'Week 26'!D29","v":{"v":0,"d":"0.00"}},{"$f":"'Week 26'!E29","v":0}]
["Bridge Surveys ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C30+'Week 26'!D30","v":{"v":0,"d":"0.00"}},{"$f":"'Week 26'!E30","v":0}]
["Office ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C31+'Week 26'!D31","v":{"v":0,"d":"0.00"}},{"$f":"'Week 26'!E31","v":0}]
["Total Time Worked",{"$f":"SUM(B22:B31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C22:C31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D22:D31)","v":{"v":0,"d":"0.00"}}]
["Misc.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C33+'Week 26'!D33","v":{"v":0,"d":"0.00"}},{"$f":"'Week 26'!E33","v":0}]
["Lost Time-Travel",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C34+'Week 26'!D34","v":{"v":0,"d":"0.00"}},null,{"$f":"'Week 1'!F34","v":"travel dist. (miles) - "}]
["Lost Time-Leave",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C35+'Week 26'!D35","v":{"v":0,"d":"0.00"}}]
["Lost Time - Other",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C36+'Week 26'!D36","v":{"v":0,"d":"0.00"}},null,{"$f":"'Week 26'!F36","v":"explain:"}]
["Total Lost Time & Misc.",{"$f":"SUM(B33:B36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C33:C36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D33:D36)","v":{"v":0,"d":"0.00"}}]
["Grand Total",{"$f":"B32+B37","v":{"v":0,"d":"0.00"}},{"$f":"C32+C37","v":{"v":0,"d":"0.00"}},{"$f":"D32+D37","v":{"v":0,"d":"0.00"}}]
[]
["Probable Completion Date:",null,null,{"$f":"'Week 26'!D40","v":"2011-12-02"}]
[]
["Percent Completed This Week:",null,null,0]
["Percent completed to date:",null,null,{"$f":"'Week 26'!D43+D42","v":0}]
[]
["Next Week I expect to:"]

{"sheet":"Week 28","index":28,"n_rows":45,"n_cols":6,"rows_kept":45}
["WEEKLY SURVEY PROGRESS REPORT                                                  "]
[{"$f":"'Week 1'!A2","v":"<< name>>"},{"$f":"'Week 1'!B2","v":"<< title >>"}]
[{"$f":"'Week 1'!A3","v":"<< address >>"}]
["               "]
["No. of Weeks:",{"$f":"CEILING((B6-B17)/7,1)","v":0}]
["For Week Ending:",{"$f":"'Week 27'!B6","v":"2011-12-02"}]
["Proj. No.:",{"$f":"'Week 1'!B7","v":0},null,"Route:",{"$f":"'Week 1'!E7","v":0}]
["County:",{"$f":"'Week 1'!B8","v":0}]
["Length (miles):",{"$f":"'Week 1'!B9","v":0}]
["From Sta:",{"$f":"'Week 1'!B10","v":0},null,"To Sta:",{"$f":"'Week 1'!E10","v":0}]
[]
["From:",{"$f":"'Week 1'!B12","v":0}]
["To:",{"$f":"'Week 1'!B13","v":0}]
[]
["Project Filename:",{"$f":"'Week 1'!B15","v":0}]
["Data Collector Filename:",{"$f":"'Week 1'!B16","v":0}]
["Date Survey Began:",{"$f":"'Week 1'!B17","v":"2011-12-02"}]
[]
[]
[null,"Manhours","Mandays"]
[null,"This Week","This Week","To Date","% Complete","Comments"]
["Control Traverse",{"v":0,"d":"0.00"},{"$f":"B22/7.5","v":{"v":0,"d":"0.00"}},{"$f":"C22+'Week 27'!D22","v":{"v":0,"d":"0.00"}},{"$f":"'Week 27'!E22","v":0}]
["Alignment",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C23+'Week 27'!D23","v":{"v":0,"d":"0.00"}},{"$f":"'Week 27'!E23","v":0}]
["Terrain Model",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C24+'Week 27'!D24","v":{"v":0,"d":"0.00"}},{"$f":"'Week 27'!E24","v":0}]
["Topography",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C25+'Week 27'!D25","v":{"v":0,"d":"0.00"}},{"$f":"'Week 27'!E25","v":0}]
["Utilities ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C26+'Week 27'!D26","v":{"v":0,"d":"0.00"}},{"$f":"'Week 27'!E26","v":0}]
["Bench Levels",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C27+'Week 27'!D27","v":{"v":0,"d":"0.00"}},{"$f":"'Week 27'!E27","v":0}]
["Property/R.O.W.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C28+'Week 27'!D28","v":{"v":0,"d":"0.00"}},{"$f":"'Week 27'!E28","v":0}]
["Drainage",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C29+'Week 27'!D29","v":{"v":0,"d":"0.00"}},{"$f":"'Week 27'!E29","v":0}]
["Bridge Surveys ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C30+'Week 27'!D30","v":{"v":0,"d":"0.00"}},{"$f":"'Week 27'!E30","v":0}]
["Office ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C31+'Week 27'!D31","v":{"v":0,"d":"0.00"}},{"$f":"'Week 27'!E31","v":0}]
["Total Time Worked",{"$f":"SUM(B22:B31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C22:C31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D22:D31)","v":{"v":0,"d":"0.00"}}]
["Misc.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C33+'Week 27'!D33","v":{"v":0,"d":"0.00"}},{"$f":"'Week 27'!E33","v":0}]
["Lost Time-Travel",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C34+'Week 27'!D34","v":{"v":0,"d":"0.00"}},null,{"$f":"'Week 1'!F34","v":"travel dist. (miles) - "}]
["Lost Time-Leave",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C35+'Week 27'!D35","v":{"v":0,"d":"0.00"}}]
["Lost Time - Other",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C36+'Week 27'!D36","v":{"v":0,"d":"0.00"}},null,{"$f":"'Week 27'!F36","v":"explain:"}]
["Total Lost Time & Misc.",{"$f":"SUM(B33:B36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C33:C36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D33:D36)","v":{"v":0,"d":"0.00"}}]
["Grand Total",{"$f":"B32+B37","v":{"v":0,"d":"0.00"}},{"$f":"C32+C37","v":{"v":0,"d":"0.00"}},{"$f":"D32+D37","v":{"v":0,"d":"0.00"}}]
[]
["Probable Completion Date:",null,null,{"$f":"'Week 27'!D40","v":"2011-12-02"}]
[]
["Percent Completed This Week:",null,null,0]
["Percent completed to date:",null,null,{"$f":"'Week 27'!D43+D42","v":0}]
[]
["Next Week I expect to:"]

{"sheet":"Week 29","index":29,"n_rows":45,"n_cols":6,"rows_kept":45}
["WEEKLY SURVEY PROGRESS REPORT                                                  "]
[{"$f":"'Week 1'!A2","v":"<< name>>"},{"$f":"'Week 1'!B2","v":"<< title >>"}]
[{"$f":"'Week 1'!A3","v":"<< address >>"}]
["               "]
["No. of Weeks:",{"$f":"CEILING((B6-B17)/7,1)","v":0}]
["For Week Ending:",{"$f":"'Week 28'!B6","v":"2011-12-02"}]
["Proj. No.:",{"$f":"'Week 1'!B7","v":0},null,"Route:",{"$f":"'Week 1'!E7","v":0}]
["County:",{"$f":"'Week 1'!B8","v":0}]
["Length (miles):",{"$f":"'Week 1'!B9","v":0}]
["From Sta:",{"$f":"'Week 1'!B10","v":0},null,"To Sta:",{"$f":"'Week 1'!E10","v":0}]
[]
["From:",{"$f":"'Week 1'!B12","v":0}]
["To:",{"$f":"'Week 1'!B13","v":0}]
[]
["Project Filename:",{"$f":"'Week 1'!B15","v":0}]
["Data Collector Filename:",{"$f":"'Week 1'!B16","v":0}]
["Date Survey Began:",{"$f":"'Week 1'!B17","v":"2011-12-02"}]
[]
[]
[null,"Manhours","Mandays"]
[null,"This Week","This Week","To Date","% Complete","Comments"]
["Control Traverse",{"v":0,"d":"0.00"},{"$f":"B22/7.5","v":{"v":0,"d":"0.00"}},{"$f":"C22+'Week 28'!D22","v":{"v":0,"d":"0.00"}},{"$f":"'Week 28'!E22","v":0}]
["Alignment",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C23+'Week 28'!D23","v":{"v":0,"d":"0.00"}},{"$f":"'Week 28'!E23","v":0}]
["Terrain Model",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C24+'Week 28'!D24","v":{"v":0,"d":"0.00"}},{"$f":"'Week 28'!E24","v":0}]
["Topography",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C25+'Week 28'!D25","v":{"v":0,"d":"0.00"}},{"$f":"'Week 28'!E25","v":0}]
["Utilities ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C26+'Week 28'!D26","v":{"v":0,"d":"0.00"}},{"$f":"'Week 28'!E26","v":0}]
["Bench Levels",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C27+'Week 28'!D27","v":{"v":0,"d":"0.00"}},{"$f":"'Week 28'!E27","v":0}]
["Property/R.O.W.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C28+'Week 28'!D28","v":{"v":0,"d":"0.00"}},{"$f":"'Week 28'!E28","v":0}]
["Drainage",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C29+'Week 28'!D29","v":{"v":0,"d":"0.00"}},{"$f":"'Week 28'!E29","v":0}]
["Bridge Surveys ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C30+'Week 28'!D30","v":{"v":0,"d":"0.00"}},{"$f":"'Week 28'!E30","v":0}]
["Office ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C31+'Week 28'!D31","v":{"v":0,"d":"0.00"}},{"$f":"'Week 28'!E31","v":0}]
["Total Time Worked",{"$f":"SUM(B22:B31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C22:C31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D22:D31)","v":{"v":0,"d":"0.00"}}]
["Misc.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C33+'Week 28'!D33","v":{"v":0,"d":"0.00"}},{"$f":"'Week 28'!E33","v":0}]
["Lost Time-Travel",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C34+'Week 28'!D34","v":{"v":0,"d":"0.00"}},null,{"$f":"'Week 1'!F34","v":"travel dist. (miles) - "}]
["Lost Time-Leave",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C35+'Week 28'!D35","v":{"v":0,"d":"0.00"}}]
["Lost Time - Other",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C36+'Week 28'!D36","v":{"v":0,"d":"0.00"}},null,{"$f":"'Week 28'!F36","v":"explain:"}]
["Total Lost Time & Misc.",{"$f":"SUM(B33:B36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C33:C36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D33:D36)","v":{"v":0,"d":"0.00"}}]
["Grand Total",{"$f":"B32+B37","v":{"v":0,"d":"0.00"}},{"$f":"C32+C37","v":{"v":0,"d":"0.00"}},{"$f":"D32+D37","v":{"v":0,"d":"0.00"}}]
[]
["Probable Completion Date:",null,null,{"$f":"'Week 28'!D40","v":"2011-12-02"}]
[]
["Percent Completed This Week:",null,null,0]
["Percent completed to date:",null,null,{"$f":"'Week 28'!D43+D42","v":0}]
[]
["Next Week I expect to:"]

{"sheet":"Week 30","index":30,"n_rows":45,"n_cols":6,"rows_kept":45}
["WEEKLY SURVEY PROGRESS REPORT                                                  "]
[{"$f":"'Week 1'!A2","v":"<< name>>"},{"$f":"'Week 1'!B2","v":"<< title >>"}]
[{"$f":"'Week 1'!A3","v":"<< address >>"}]
["               "]
["No. of Weeks:",{"$f":"CEILING((B6-B17)/7,1)","v":0}]
["For Week Ending:",{"$f":"'Week 29'!B6","v":"2011-12-02"}]
["Proj. No.:",{"$f":"'Week 1'!B7","v":0},null,"Route:",{"$f":"'Week 1'!E7","v":0}]
["County:",{"$f":"'Week 1'!B8","v":0}]
["Length (miles):",{"$f":"'Week 1'!B9","v":0}]
["From Sta:",{"$f":"'Week 1'!B10","v":0},null,"To Sta:",{"$f":"'Week 1'!E10","v":0}]
[]
["From:",{"$f":"'Week 1'!B12","v":0}]
["To:",{"$f":"'Week 1'!B13","v":0}]
[]
["Project Filename:",{"$f":"'Week 1'!B15","v":0}]
["Data Collector Filename:",{"$f":"'Week 1'!B16","v":0}]
["Date Survey Began:",{"$f":"'Week 1'!B17","v":"2011-12-02"}]
[]
[]
[null,"Manhours","Mandays"]
[null,"This Week","This Week","To Date","% Complete","Comments"]
["Control Traverse",{"v":0,"d":"0.00"},{"$f":"B22/7.5","v":{"v":0,"d":"0.00"}},{"$f":"C22+'Week 29'!D22","v":{"v":0,"d":"0.00"}},{"$f":"'Week 29'!E22","v":0}]
["Alignment",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C23+'Week 29'!D23","v":{"v":0,"d":"0.00"}},{"$f":"'Week 29'!E23","v":0}]
["Terrain Model",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C24+'Week 29'!D24","v":{"v":0,"d":"0.00"}},{"$f":"'Week 29'!E24","v":0}]
["Topography",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C25+'Week 29'!D25","v":{"v":0,"d":"0.00"}},{"$f":"'Week 29'!E25","v":0}]
["Utilities ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C26+'Week 29'!D26","v":{"v":0,"d":"0.00"}},{"$f":"'Week 29'!E26","v":0}]
["Bench Levels",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C27+'Week 29'!D27","v":{"v":0,"d":"0.00"}},{"$f":"'Week 29'!E27","v":0}]
["Property/R.O.W.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C28+'Week 29'!D28","v":{"v":0,"d":"0.00"}},{"$f":"'Week 29'!E28","v":0}]
["Drainage",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C29+'Week 29'!D29","v":{"v":0,"d":"0.00"}},{"$f":"'Week 29'!E29","v":0}]
["Bridge Surveys ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C30+'Week 29'!D30","v":{"v":0,"d":"0.00"}},{"$f":"'Week 29'!E30","v":0}]
["Office ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C31+'Week 29'!D31","v":{"v":0,"d":"0.00"}},{"$f":"'Week 29'!E31","v":0}]
["Total Time Worked",{"$f":"SUM(B22:B31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C22:C31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D22:D31)","v":{"v":0,"d":"0.00"}}]
["Misc.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C33+'Week 29'!D33","v":{"v":0,"d":"0.00"}},{"$f":"'Week 29'!E33","v":0}]
["Lost Time-Travel",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C34+'Week 29'!D34","v":{"v":0,"d":"0.00"}},null,{"$f":"'Week 1'!F34","v":"travel dist. (miles) - "}]
["Lost Time-Leave",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C35+'Week 29'!D35","v":{"v":0,"d":"0.00"}}]
["Lost Time - Other",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C36+'Week 29'!D36","v":{"v":0,"d":"0.00"}},null,{"$f":"'Week 29'!F36","v":"explain:"}]
["Total Lost Time & Misc.",{"$f":"SUM(B33:B36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C33:C36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D33:D36)","v":{"v":0,"d":"0.00"}}]
["Grand Total",{"$f":"B32+B37","v":{"v":0,"d":"0.00"}},{"$f":"C32+C37","v":{"v":0,"d":"0.00"}},{"$f":"D32+D37","v":{"v":0,"d":"0.00"}}]
[]
["Probable Completion Date:",null,null,{"$f":"'Week 29'!D40","v":"2011-12-02"}]
[]
["Percent Completed This Week:",null,null,0]
["Percent completed to date:",null,null,{"$f":"'Week 29'!D43+D42","v":0}]
[]
["Next Week I expect to:"]

{"sheet":"Week 31","index":31,"n_rows":45,"n_cols":6,"rows_kept":45}
["WEEKLY SURVEY PROGRESS REPORT                                                  "]
[{"$f":"'Week 1'!A2","v":"<< name>>"},{"$f":"'Week 1'!B2","v":"<< title >>"}]
[{"$f":"'Week 1'!A3","v":"<< address >>"}]
["               "]
["No. of Weeks:",{"$f":"CEILING((B6-B17)/7,1)","v":0}]
["For Week Ending:",{"$f":"'Week 30'!B6","v":"2011-12-02"}]
["Proj. No.:",{"$f":"'Week 1'!B7","v":0},null,"Route:",{"$f":"'Week 1'!E7","v":0}]
["County:",{"$f":"'Week 1'!B8","v":0}]
["Length (miles):",{"$f":"'Week 1'!B9","v":0}]
["From Sta:",{"$f":"'Week 1'!B10","v":0},null,"To Sta:",{"$f":"'Week 1'!E10","v":0}]
[]
["From:",{"$f":"'Week 1'!B12","v":0}]
["To:",{"$f":"'Week 1'!B13","v":0}]
[]
["Project Filename:",{"$f":"'Week 1'!B15","v":0}]
["Data Collector Filename:",{"$f":"'Week 1'!B16","v":0}]
["Date Survey Began:",{"$f":"'Week 1'!B17","v":"2011-12-02"}]
[]
[]
[null,"Manhours","Mandays"]
[null,"This Week","This Week","To Date","% Complete","Comments"]
["Control Traverse",{"v":0,"d":"0.00"},{"$f":"B22/7.5","v":{"v":0,"d":"0.00"}},{"$f":"C22+'Week 30'!D22","v":{"v":0,"d":"0.00"}},{"$f":"'Week 30'!E22","v":0}]
["Alignment",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C23+'Week 30'!D23","v":{"v":0,"d":"0.00"}},{"$f":"'Week 30'!E23","v":0}]
["Terrain Model",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C24+'Week 30'!D24","v":{"v":0,"d":"0.00"}},{"$f":"'Week 30'!E24","v":0}]
["Topography",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C25+'Week 30'!D25","v":{"v":0,"d":"0.00"}},{"$f":"'Week 30'!E25","v":0}]
["Utilities ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C26+'Week 30'!D26","v":{"v":0,"d":"0.00"}},{"$f":"'Week 30'!E26","v":0}]
["Bench Levels",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C27+'Week 30'!D27","v":{"v":0,"d":"0.00"}},{"$f":"'Week 30'!E27","v":0}]
["Property/R.O.W.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C28+'Week 30'!D28","v":{"v":0,"d":"0.00"}},{"$f":"'Week 30'!E28","v":0}]
["Drainage",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C29+'Week 30'!D29","v":{"v":0,"d":"0.00"}},{"$f":"'Week 30'!E29","v":0}]
["Bridge Surveys ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C30+'Week 30'!D30","v":{"v":0,"d":"0.00"}},{"$f":"'Week 30'!E30","v":0}]
["Office ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C31+'Week 30'!D31","v":{"v":0,"d":"0.00"}},{"$f":"'Week 30'!E31","v":0}]
["Total Time Worked",{"$f":"SUM(B22:B31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C22:C31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D22:D31)","v":{"v":0,"d":"0.00"}}]
["Misc.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C33+'Week 30'!D33","v":{"v":0,"d":"0.00"}},{"$f":"'Week 30'!E33","v":0}]
["Lost Time-Travel",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C34+'Week 30'!D34","v":{"v":0,"d":"0.00"}},null,{"$f":"'Week 1'!F34","v":"travel dist. (miles) - "}]
["Lost Time-Leave",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C35+'Week 30'!D35","v":{"v":0,"d":"0.00"}}]
["Lost Time - Other",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C36+'Week 30'!D36","v":{"v":0,"d":"0.00"}},null,{"$f":"'Week 30'!F36","v":"explain:"}]
["Total Lost Time & Misc.",{"$f":"SUM(B33:B36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C33:C36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D33:D36)","v":{"v":0,"d":"0.00"}}]
["Grand Total",{"$f":"B32+B37","v":{"v":0,"d":"0.00"}},{"$f":"C32+C37","v":{"v":0,"d":"0.00"}},{"$f":"D32+D37","v":{"v":0,"d":"0.00"}}]
[]
["Probable Completion Date:",null,null,{"$f":"'Week 30'!D40","v":"2011-12-02"}]
[]
["Percent Completed This Week:",null,null,0]
["Percent completed to date:",null,null,{"$f":"'Week 30'!D43+D42","v":0}]
[]
["Next Week I expect to:"]

{"sheet":"Week 32","index":32,"n_rows":45,"n_cols":6,"rows_kept":45}
["WEEKLY SURVEY PROGRESS REPORT                                                  "]
[{"$f":"'Week 1'!A2","v":"<< name>>"},{"$f":"'Week 1'!B2","v":"<< title >>"}]
[{"$f":"'Week 1'!A3","v":"<< address >>"}]
["               "]
["No. of Weeks:",{"$f":"CEILING((B6-B17)/7,1)","v":0}]
["For Week Ending:",{"$f":"'Week 31'!B6","v":"2011-12-02"}]
["Proj. No.:",{"$f":"'Week 1'!B7","v":0},null,"Route:",{"$f":"'Week 1'!E7","v":0}]
["County:",{"$f":"'Week 1'!B8","v":0}]
["Length (miles):",{"$f":"'Week 1'!B9","v":0}]
["From Sta:",{"$f":"'Week 1'!B10","v":0},null,"To Sta:",{"$f":"'Week 1'!E10","v":0}]
[]
["From:",{"$f":"'Week 1'!B12","v":0}]
["To:",{"$f":"'Week 1'!B13","v":0}]
[]
["Project Filename:",{"$f":"'Week 1'!B15","v":0}]
["Data Collector Filename:",{"$f":"'Week 1'!B16","v":0}]
["Date Survey Began:",{"$f":"'Week 1'!B17","v":"2011-12-02"}]
[]
[]
[null,"Manhours","Mandays"]
[null,"This Week","This Week","To Date","% Complete","Comments"]
["Control Traverse",{"v":0,"d":"0.00"},{"$f":"B22/7.5","v":{"v":0,"d":"0.00"}},{"$f":"C22+'Week 31'!D22","v":{"v":0,"d":"0.00"}},{"$f":"'Week 31'!E22","v":0}]
["Alignment",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C23+'Week 31'!D23","v":{"v":0,"d":"0.00"}},{"$f":"'Week 31'!E23","v":0}]
["Terrain Model",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C24+'Week 31'!D24","v":{"v":0,"d":"0.00"}},{"$f":"'Week 31'!E24","v":0}]
["Topography",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C25+'Week 31'!D25","v":{"v":0,"d":"0.00"}},{"$f":"'Week 31'!E25","v":0}]
["Utilities ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C26+'Week 31'!D26","v":{"v":0,"d":"0.00"}},{"$f":"'Week 31'!E26","v":0}]
["Bench Levels",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C27+'Week 31'!D27","v":{"v":0,"d":"0.00"}},{"$f":"'Week 31'!E27","v":0}]
["Property/R.O.W.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C28+'Week 31'!D28","v":{"v":0,"d":"0.00"}},{"$f":"'Week 31'!E28","v":0}]
["Drainage",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C29+'Week 31'!D29","v":{"v":0,"d":"0.00"}},{"$f":"'Week 31'!E29","v":0}]
["Bridge Surveys ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C30+'Week 31'!D30","v":{"v":0,"d":"0.00"}},{"$f":"'Week 31'!E30","v":0}]
["Office ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C31+'Week 31'!D31","v":{"v":0,"d":"0.00"}},{"$f":"'Week 31'!E31","v":0}]
["Total Time Worked",{"$f":"SUM(B22:B31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C22:C31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D22:D31)","v":{"v":0,"d":"0.00"}}]
["Misc.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C33+'Week 31'!D33","v":{"v":0,"d":"0.00"}},{"$f":"'Week 31'!E33","v":0}]
["Lost Time-Travel",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C34+'Week 31'!D34","v":{"v":0,"d":"0.00"}},null,{"$f":"'Week 1'!F34","v":"travel dist. (miles) - "}]
["Lost Time-Leave",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C35+'Week 31'!D35","v":{"v":0,"d":"0.00"}}]
["Lost Time - Other",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C36+'Week 31'!D36","v":{"v":0,"d":"0.00"}},null,{"$f":"'Week 31'!F36","v":"explain:"}]
["Total Lost Time & Misc.",{"$f":"SUM(B33:B36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C33:C36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D33:D36)","v":{"v":0,"d":"0.00"}}]
["Grand Total",{"$f":"B32+B37","v":{"v":0,"d":"0.00"}},{"$f":"C32+C37","v":{"v":0,"d":"0.00"}},{"$f":"D32+D37","v":{"v":0,"d":"0.00"}}]
[]
["Probable Completion Date:",null,null,{"$f":"'Week 31'!D40","v":"2011-12-02"}]
[]
["Percent Completed This Week:",null,null,0]
["Percent completed to date:",null,null,{"$f":"'Week 31'!D43+D42","v":0}]
[]
["Next Week I expect to:"]

{"sheet":"Week 33","index":33,"n_rows":45,"n_cols":6,"rows_kept":45}
["WEEKLY SURVEY PROGRESS REPORT                                                  "]
[{"$f":"'Week 1'!A2","v":"<< name>>"},{"$f":"'Week 1'!B2","v":"<< title >>"}]
[{"$f":"'Week 1'!A3","v":"<< address >>"}]
["               "]
["No. of Weeks:",{"$f":"CEILING((B6-B17)/7,1)","v":0}]
["For Week Ending:",{"$f":"'Week 32'!B6","v":"2011-12-02"}]
["Proj. No.:",{"$f":"'Week 1'!B7","v":0},null,"Route:",{"$f":"'Week 1'!E7","v":0}]
["County:",{"$f":"'Week 1'!B8","v":0}]
["Length (miles):",{"$f":"'Week 1'!B9","v":0}]
["From Sta:",{"$f":"'Week 1'!B10","v":0},null,"To Sta:",{"$f":"'Week 1'!E10","v":0}]
[]
["From:",{"$f":"'Week 1'!B12","v":0}]
["To:",{"$f":"'Week 1'!B13","v":0}]
[]
["Project Filename:",{"$f":"'Week 1'!B15","v":0}]
["Data Collector Filename:",{"$f":"'Week 1'!B16","v":0}]
["Date Survey Began:",{"$f":"'Week 1'!B17","v":"2011-12-02"}]
[]
[]
[null,"Manhours","Mandays"]
[null,"This Week","This Week","To Date","% Complete","Comments"]
["Control Traverse",{"v":0,"d":"0.00"},{"$f":"B22/7.5","v":{"v":0,"d":"0.00"}},{"$f":"C22+'Week 32'!D22","v":{"v":0,"d":"0.00"}},{"$f":"'Week 32'!E22","v":0}]
["Alignment",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C23+'Week 32'!D23","v":{"v":0,"d":"0.00"}},{"$f":"'Week 32'!E23","v":0}]
["Terrain Model",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C24+'Week 32'!D24","v":{"v":0,"d":"0.00"}},{"$f":"'Week 32'!E24","v":0}]
["Topography",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C25+'Week 32'!D25","v":{"v":0,"d":"0.00"}},{"$f":"'Week 32'!E25","v":0}]
["Utilities ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C26+'Week 32'!D26","v":{"v":0,"d":"0.00"}},{"$f":"'Week 32'!E26","v":0}]
["Bench Levels",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C27+'Week 32'!D27","v":{"v":0,"d":"0.00"}},{"$f":"'Week 32'!E27","v":0}]
["Property/R.O.W.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C28+'Week 32'!D28","v":{"v":0,"d":"0.00"}},{"$f":"'Week 32'!E28","v":0}]
["Drainage",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C29+'Week 32'!D29","v":{"v":0,"d":"0.00"}},{"$f":"'Week 32'!E29","v":0}]
["Bridge Surveys ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C30+'Week 32'!D30","v":{"v":0,"d":"0.00"}},{"$f":"'Week 32'!E30","v":0}]
["Office ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C31+'Week 32'!D31","v":{"v":0,"d":"0.00"}},{"$f":"'Week 32'!E31","v":0}]
["Total Time Worked",{"$f":"SUM(B22:B31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C22:C31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D22:D31)","v":{"v":0,"d":"0.00"}}]
["Misc.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C33+'Week 32'!D33","v":{"v":0,"d":"0.00"}},{"$f":"'Week 32'!E33","v":0}]
["Lost Time-Travel",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C34+'Week 32'!D34","v":{"v":0,"d":"0.00"}},null,{"$f":"'Week 1'!F34","v":"travel dist. (miles) - "}]
["Lost Time-Leave",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C35+'Week 32'!D35","v":{"v":0,"d":"0.00"}}]
["Lost Time - Other",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C36+'Week 32'!D36","v":{"v":0,"d":"0.00"}},null,{"$f":"'Week 32'!F36","v":"explain:"}]
["Total Lost Time & Misc.",{"$f":"SUM(B33:B36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C33:C36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D33:D36)","v":{"v":0,"d":"0.00"}}]
["Grand Total",{"$f":"B32+B37","v":{"v":0,"d":"0.00"}},{"$f":"C32+C37","v":{"v":0,"d":"0.00"}},{"$f":"D32+D37","v":{"v":0,"d":"0.00"}}]
[]
["Probable Completion Date:",null,null,{"$f":"'Week 32'!D40","v":"2011-12-02"}]
[]
["Percent Completed This Week:",null,null,0]
["Percent completed to date:",null,null,{"$f":"'Week 32'!D43+D42","v":0}]
[]
["Next Week I expect to:"]

{"sheet":"Week 34","index":34,"n_rows":45,"n_cols":6,"rows_kept":45}
["WEEKLY SURVEY PROGRESS REPORT                                                  "]
[{"$f":"'Week 1'!A2","v":"<< name>>"},{"$f":"'Week 1'!B2","v":"<< title >>"}]
[{"$f":"'Week 1'!A3","v":"<< address >>"}]
["               "]
["No. of Weeks:",{"$f":"CEILING((B6-B17)/7,1)","v":0}]
["For Week Ending:",{"$f":"'Week 33'!B6","v":"2011-12-02"}]
["Proj. No.:",{"$f":"'Week 1'!B7","v":0},null,"Route:",{"$f":"'Week 1'!E7","v":0}]
["County:",{"$f":"'Week 1'!B8","v":0}]
["Length (miles):",{"$f":"'Week 1'!B9","v":0}]
["From Sta:",{"$f":"'Week 1'!B10","v":0},null,"To Sta:",{"$f":"'Week 1'!E10","v":0}]
[]
["From:",{"$f":"'Week 1'!B12","v":0}]
["To:",{"$f":"'Week 1'!B13","v":0}]
[]
["Project Filename:",{"$f":"'Week 1'!B15","v":0}]
["Data Collector Filename:",{"$f":"'Week 1'!B16","v":0}]
["Date Survey Began:",{"$f":"'Week 1'!B17","v":"2011-12-02"}]
[]
[]
[null,"Manhours","Mandays"]
[null,"This Week","This Week","To Date","% Complete","Comments"]
["Control Traverse",{"v":0,"d":"0.00"},{"$f":"B22/7.5","v":{"v":0,"d":"0.00"}},{"$f":"C22+'Week 33'!D22","v":{"v":0,"d":"0.00"}},{"$f":"'Week 33'!E22","v":0}]
["Alignment",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C23+'Week 33'!D23","v":{"v":0,"d":"0.00"}},{"$f":"'Week 33'!E23","v":0}]
["Terrain Model",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C24+'Week 33'!D24","v":{"v":0,"d":"0.00"}},{"$f":"'Week 33'!E24","v":0}]
["Topography",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C25+'Week 33'!D25","v":{"v":0,"d":"0.00"}},{"$f":"'Week 33'!E25","v":0}]
["Utilities ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C26+'Week 33'!D26","v":{"v":0,"d":"0.00"}},{"$f":"'Week 33'!E26","v":0}]
["Bench Levels",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C27+'Week 33'!D27","v":{"v":0,"d":"0.00"}},{"$f":"'Week 33'!E27","v":0}]
["Property/R.O.W.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C28+'Week 33'!D28","v":{"v":0,"d":"0.00"}},{"$f":"'Week 33'!E28","v":0}]
["Drainage",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C29+'Week 33'!D29","v":{"v":0,"d":"0.00"}},{"$f":"'Week 33'!E29","v":0}]
["Bridge Surveys ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C30+'Week 33'!D30","v":{"v":0,"d":"0.00"}},{"$f":"'Week 33'!E30","v":0}]
["Office ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C31+'Week 33'!D31","v":{"v":0,"d":"0.00"}},{"$f":"'Week 33'!E31","v":0}]
["Total Time Worked",{"$f":"SUM(B22:B31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C22:C31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D22:D31)","v":{"v":0,"d":"0.00"}}]
["Misc.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C33+'Week 33'!D33","v":{"v":0,"d":"0.00"}},{"$f":"'Week 33'!E33","v":0}]
["Lost Time-Travel",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C34+'Week 33'!D34","v":{"v":0,"d":"0.00"}},null,{"$f":"'Week 1'!F34","v":"travel dist. (miles) - "}]
["Lost Time-Leave",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C35+'Week 33'!D35","v":{"v":0,"d":"0.00"}}]
["Lost Time - Other",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C36+'Week 33'!D36","v":{"v":0,"d":"0.00"}},null,{"$f":"'Week 33'!F36","v":"explain:"}]
["Total Lost Time & Misc.",{"$f":"SUM(B33:B36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C33:C36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D33:D36)","v":{"v":0,"d":"0.00"}}]
["Grand Total",{"$f":"B32+B37","v":{"v":0,"d":"0.00"}},{"$f":"C32+C37","v":{"v":0,"d":"0.00"}},{"$f":"D32+D37","v":{"v":0,"d":"0.00"}}]
[]
["Probable Completion Date:",null,null,{"$f":"'Week 33'!D40","v":"2011-12-02"}]
[]
["Percent Completed This Week:",null,null,0]
["Percent completed to date:",null,null,{"$f":"'Week 33'!D43+D42","v":0}]
[]
["Next Week I expect to:"]

{"sheet":"Week 35","index":35,"n_rows":45,"n_cols":6,"rows_kept":45}
["WEEKLY SURVEY PROGRESS REPORT                                                  "]
[{"$f":"'Week 1'!A2","v":"<< name>>"},{"$f":"'Week 1'!B2","v":"<< title >>"}]
[{"$f":"'Week 1'!A3","v":"<< address >>"}]
["               "]
["No. of Weeks:",{"$f":"CEILING((B6-B17)/7,1)","v":0}]
["For Week Ending:",{"$f":"'Week 34'!B6","v":"2011-12-02"}]
["Proj. No.:",{"$f":"'Week 1'!B7","v":0},null,"Route:",{"$f":"'Week 1'!E7","v":0}]
["County:",{"$f":"'Week 1'!B8","v":0}]
["Length (miles):",{"$f":"'Week 1'!B9","v":0}]
["From Sta:",{"$f":"'Week 1'!B10","v":0},null,"To Sta:",{"$f":"'Week 1'!E10","v":0}]
[]
["From:",{"$f":"'Week 1'!B12","v":0}]
["To:",{"$f":"'Week 1'!B13","v":0}]
[]
["Project Filename:",{"$f":"'Week 1'!B15","v":0}]
["Data Collector Filename:",{"$f":"'Week 1'!B16","v":0}]
["Date Survey Began:",{"$f":"'Week 1'!B17","v":"2011-12-02"}]
[]
[]
[null,"Manhours","Mandays"]
[null,"This Week","This Week","To Date","% Complete","Comments"]
["Control Traverse",{"v":0,"d":"0.00"},{"$f":"B22/7.5","v":{"v":0,"d":"0.00"}},{"$f":"C22+'Week 34'!D22","v":{"v":0,"d":"0.00"}},{"$f":"'Week 34'!E22","v":0}]
["Alignment",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C23+'Week 34'!D23","v":{"v":0,"d":"0.00"}},{"$f":"'Week 34'!E23","v":0}]
["Terrain Model",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C24+'Week 34'!D24","v":{"v":0,"d":"0.00"}},{"$f":"'Week 34'!E24","v":0}]
["Topography",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C25+'Week 34'!D25","v":{"v":0,"d":"0.00"}},{"$f":"'Week 34'!E25","v":0}]
["Utilities ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C26+'Week 34'!D26","v":{"v":0,"d":"0.00"}},{"$f":"'Week 34'!E26","v":0}]
["Bench Levels",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C27+'Week 34'!D27","v":{"v":0,"d":"0.00"}},{"$f":"'Week 34'!E27","v":0}]
["Property/R.O.W.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C28+'Week 34'!D28","v":{"v":0,"d":"0.00"}},{"$f":"'Week 34'!E28","v":0}]
["Drainage",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C29+'Week 34'!D29","v":{"v":0,"d":"0.00"}},{"$f":"'Week 34'!E29","v":0}]
["Bridge Surveys ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C30+'Week 34'!D30","v":{"v":0,"d":"0.00"}},{"$f":"'Week 34'!E30","v":0}]
["Office ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C31+'Week 34'!D31","v":{"v":0,"d":"0.00"}},{"$f":"'Week 34'!E31","v":0}]
["Total Time Worked",{"$f":"SUM(B22:B31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C22:C31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D22:D31)","v":{"v":0,"d":"0.00"}}]
["Misc.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C33+'Week 34'!D33","v":{"v":0,"d":"0.00"}},{"$f":"'Week 34'!E33","v":0}]
["Lost Time-Travel",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C34+'Week 34'!D34","v":{"v":0,"d":"0.00"}},null,{"$f":"'Week 1'!F34","v":"travel dist. (miles) - "}]
["Lost Time-Leave",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C35+'Week 34'!D35","v":{"v":0,"d":"0.00"}}]
["Lost Time - Other",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C36+'Week 34'!D36","v":{"v":0,"d":"0.00"}},null,{"$f":"'Week 34'!F36","v":"explain:"}]
["Total Lost Time & Misc.",{"$f":"SUM(B33:B36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C33:C36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D33:D36)","v":{"v":0,"d":"0.00"}}]
["Grand Total",{"$f":"B32+B37","v":{"v":0,"d":"0.00"}},{"$f":"C32+C37","v":{"v":0,"d":"0.00"}},{"$f":"D32+D37","v":{"v":0,"d":"0.00"}}]
[]
["Probable Completion Date:",null,null,{"$f":"'Week 34'!D40","v":"2011-12-02"}]
[]
["Percent Completed This Week:",null,null,0]
["Percent completed to date:",null,null,{"$f":"'Week 34'!D43+D42","v":0}]
[]
["Next Week I expect to:"]

{"sheet":"Week 36","index":36,"n_rows":45,"n_cols":6,"rows_kept":45}
["WEEKLY SURVEY PROGRESS REPORT                                                  "]
[{"$f":"'Week 1'!A2","v":"<< name>>"},{"$f":"'Week 1'!B2","v":"<< title >>"}]
[{"$f":"'Week 1'!A3","v":"<< address >>"}]
["               "]
["No. of Weeks:",{"$f":"CEILING((B6-B17)/7,1)","v":0}]
["For Week Ending:",{"$f":"'Week 35'!B6","v":"2011-12-02"}]
["Proj. No.:",{"$f":"'Week 1'!B7","v":0},null,"Route:",{"$f":"'Week 1'!E7","v":0}]
["County:",{"$f":"'Week 1'!B8","v":0}]
["Length (miles):",{"$f":"'Week 1'!B9","v":0}]
["From Sta:",{"$f":"'Week 1'!B10","v":0},null,"To Sta:",{"$f":"'Week 1'!E10","v":0}]
[]
["From:",{"$f":"'Week 1'!B12","v":0}]
["To:",{"$f":"'Week 1'!B13","v":0}]
[]
["Project Filename:",{"$f":"'Week 1'!B15","v":0}]
["Data Collector Filename:",{"$f":"'Week 1'!B16","v":0}]
["Date Survey Began:",{"$f":"'Week 1'!B17","v":"2011-12-02"}]
[]
[]
[null,"Manhours","Mandays"]
[null,"This Week","This Week","To Date","% Complete","Comments"]
["Control Traverse",{"v":0,"d":"0.00"},{"$f":"B22/7.5","v":{"v":0,"d":"0.00"}},{"$f":"C22+'Week 35'!D22","v":{"v":0,"d":"0.00"}},{"$f":"'Week 35'!E22","v":0}]
["Alignment",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C23+'Week 35'!D23","v":{"v":0,"d":"0.00"}},{"$f":"'Week 35'!E23","v":0}]
["Terrain Model",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C24+'Week 35'!D24","v":{"v":0,"d":"0.00"}},{"$f":"'Week 35'!E24","v":0}]
["Topography",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C25+'Week 35'!D25","v":{"v":0,"d":"0.00"}},{"$f":"'Week 35'!E25","v":0}]
["Utilities ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C26+'Week 35'!D26","v":{"v":0,"d":"0.00"}},{"$f":"'Week 35'!E26","v":0}]
["Bench Levels",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C27+'Week 35'!D27","v":{"v":0,"d":"0.00"}},{"$f":"'Week 35'!E27","v":0}]
["Property/R.O.W.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C28+'Week 35'!D28","v":{"v":0,"d":"0.00"}},{"$f":"'Week 35'!E28","v":0}]
["Drainage",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C29+'Week 35'!D29","v":{"v":0,"d":"0.00"}},{"$f":"'Week 35'!E29","v":0}]
["Bridge Surveys ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C30+'Week 35'!D30","v":{"v":0,"d":"0.00"}},{"$f":"'Week 35'!E30","v":0}]
["Office ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C31+'Week 35'!D31","v":{"v":0,"d":"0.00"}},{"$f":"'Week 35'!E31","v":0}]
["Total Time Worked",{"$f":"SUM(B22:B31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C22:C31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D22:D31)","v":{"v":0,"d":"0.00"}}]
["Misc.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C33+'Week 35'!D33","v":{"v":0,"d":"0.00"}},{"$f":"'Week 35'!E33","v":0}]
["Lost Time-Travel",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C34+'Week 35'!D34","v":{"v":0,"d":"0.00"}},null,{"$f":"'Week 1'!F34","v":"travel dist. (miles) - "}]
["Lost Time-Leave",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C35+'Week 35'!D35","v":{"v":0,"d":"0.00"}}]
["Lost Time - Other",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C36+'Week 35'!D36","v":{"v":0,"d":"0.00"}},null,{"$f":"'Week 35'!F36","v":"explain:"}]
["Total Lost Time & Misc.",{"$f":"SUM(B33:B36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C33:C36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D33:D36)","v":{"v":0,"d":"0.00"}}]
["Grand Total",{"$f":"B32+B37","v":{"v":0,"d":"0.00"}},{"$f":"C32+C37","v":{"v":0,"d":"0.00"}},{"$f":"D32+D37","v":{"v":0,"d":"0.00"}}]
[]
["Probable Completion Date:",null,null,{"$f":"'Week 35'!D40","v":"2011-12-02"}]
[]
["Percent Completed This Week:",null,null,0]
["Percent completed to date:",null,null,{"$f":"'Week 35'!D43+D42","v":0}]
[]
["Next Week I expect to:"]

{"sheet":"Week 37","index":37,"n_rows":45,"n_cols":6,"rows_kept":45}
["WEEKLY SURVEY PROGRESS REPORT                                                  "]
[{"$f":"'Week 1'!A2","v":"<< name>>"},{"$f":"'Week 1'!B2","v":"<< title >>"}]
[{"$f":"'Week 1'!A3","v":"<< address >>"}]
["               "]
["No. of Weeks:",{"$f":"CEILING((B6-B17)/7,1)","v":0}]
["For Week Ending:",{"$f":"'Week 36'!B6","v":"2011-12-02"}]
["Proj. No.:",{"$f":"'Week 1'!B7","v":0},null,"Route:",{"$f":"'Week 1'!E7","v":0}]
["County:",{"$f":"'Week 1'!B8","v":0}]
["Length (miles):",{"$f":"'Week 1'!B9","v":0}]
["From Sta:",{"$f":"'Week 1'!B10","v":0},null,"To Sta:",{"$f":"'Week 1'!E10","v":0}]
[]
["From:",{"$f":"'Week 1'!B12","v":0}]
["To:",{"$f":"'Week 1'!B13","v":0}]
[]
["Project Filename:",{"$f":"'Week 1'!B15","v":0}]
["Data Collector Filename:",{"$f":"'Week 1'!B16","v":0}]
["Date Survey Began:",{"$f":"'Week 1'!B17","v":"2011-12-02"}]
[]
[]
[null,"Manhours","Mandays"]
[null,"This Week","This Week","To Date","% Complete","Comments"]
["Control Traverse",{"v":0,"d":"0.00"},{"$f":"B22/7.5","v":{"v":0,"d":"0.00"}},{"$f":"C22+'Week 36'!D22","v":{"v":0,"d":"0.00"}},{"$f":"'Week 36'!E22","v":0}]
["Alignment",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C23+'Week 36'!D23","v":{"v":0,"d":"0.00"}},{"$f":"'Week 36'!E23","v":0}]
["Terrain Model",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C24+'Week 36'!D24","v":{"v":0,"d":"0.00"}},{"$f":"'Week 36'!E24","v":0}]
["Topography",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C25+'Week 36'!D25","v":{"v":0,"d":"0.00"}},{"$f":"'Week 36'!E25","v":0}]
["Utilities ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C26+'Week 36'!D26","v":{"v":0,"d":"0.00"}},{"$f":"'Week 36'!E26","v":0}]
["Bench Levels",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C27+'Week 36'!D27","v":{"v":0,"d":"0.00"}},{"$f":"'Week 36'!E27","v":0}]
["Property/R.O.W.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C28+'Week 36'!D28","v":{"v":0,"d":"0.00"}},{"$f":"'Week 36'!E28","v":0}]
["Drainage",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C29+'Week 36'!D29","v":{"v":0,"d":"0.00"}},{"$f":"'Week 36'!E29","v":0}]
["Bridge Surveys ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C30+'Week 36'!D30","v":{"v":0,"d":"0.00"}},{"$f":"'Week 36'!E30","v":0}]
["Office ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C31+'Week 36'!D31","v":{"v":0,"d":"0.00"}},{"$f":"'Week 36'!E31","v":0}]
["Total Time Worked",{"$f":"SUM(B22:B31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C22:C31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D22:D31)","v":{"v":0,"d":"0.00"}}]
["Misc.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C33+'Week 36'!D33","v":{"v":0,"d":"0.00"}},{"$f":"'Week 36'!E33","v":0}]
["Lost Time-Travel",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C34+'Week 36'!D34","v":{"v":0,"d":"0.00"}},null,{"$f":"'Week 1'!F34","v":"travel dist. (miles) - "}]
["Lost Time-Leave",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C35+'Week 36'!D35","v":{"v":0,"d":"0.00"}}]
["Lost Time - Other",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C36+'Week 36'!D36","v":{"v":0,"d":"0.00"}},null,{"$f":"'Week 36'!F36","v":"explain:"}]
["Total Lost Time & Misc.",{"$f":"SUM(B33:B36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C33:C36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D33:D36)","v":{"v":0,"d":"0.00"}}]
["Grand Total",{"$f":"B32+B37","v":{"v":0,"d":"0.00"}},{"$f":"C32+C37","v":{"v":0,"d":"0.00"}},{"$f":"D32+D37","v":{"v":0,"d":"0.00"}}]
[]
["Probable Completion Date:",null,null,{"$f":"'Week 36'!D40","v":"2011-12-02"}]
[]
["Percent Completed This Week:",null,null,0]
["Percent completed to date:",null,null,{"$f":"'Week 36'!D43+D42","v":0}]
[]
["Next Week I expect to:"]

{"sheet":"Week 38","index":38,"n_rows":45,"n_cols":6,"rows_kept":45}
["WEEKLY SURVEY PROGRESS REPORT                                                  "]
[{"$f":"'Week 1'!A2","v":"<< name>>"},{"$f":"'Week 1'!B2","v":"<< title >>"}]
[{"$f":"'Week 1'!A3","v":"<< address >>"}]
["               "]
["No. of Weeks:",{"$f":"CEILING((B6-B17)/7,1)","v":0}]
["For Week Ending:",{"$f":"'Week 37'!B6","v":"2011-12-02"}]
["Proj. No.:",{"$f":"'Week 1'!B7","v":0},null,"Route:",{"$f":"'Week 1'!E7","v":0}]
["County:",{"$f":"'Week 1'!B8","v":0}]
["Length (miles):",{"$f":"'Week 1'!B9","v":0}]
["From Sta:",{"$f":"'Week 1'!B10","v":0},null,"To Sta:",{"$f":"'Week 1'!E10","v":0}]
[]
["From:",{"$f":"'Week 1'!B12","v":0}]
["To:",{"$f":"'Week 1'!B13","v":0}]
[]
["Project Filename:",{"$f":"'Week 1'!B15","v":0}]
["Data Collector Filename:",{"$f":"'Week 1'!B16","v":0}]
["Date Survey Began:",{"$f":"'Week 1'!B17","v":"2011-12-02"}]
[]
[]
[null,"Manhours","Mandays"]
[null,"This Week","This Week","To Date","% Complete","Comments"]
["Control Traverse",{"v":0,"d":"0.00"},{"$f":"B22/7.5","v":{"v":0,"d":"0.00"}},{"$f":"C22+'Week 37'!D22","v":{"v":0,"d":"0.00"}},{"$f":"'Week 37'!E22","v":0}]
["Alignment",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C23+'Week 37'!D23","v":{"v":0,"d":"0.00"}},{"$f":"'Week 37'!E23","v":0}]
["Terrain Model",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C24+'Week 37'!D24","v":{"v":0,"d":"0.00"}},{"$f":"'Week 37'!E24","v":0}]
["Topography",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C25+'Week 37'!D25","v":{"v":0,"d":"0.00"}},{"$f":"'Week 37'!E25","v":0}]
["Utilities ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C26+'Week 37'!D26","v":{"v":0,"d":"0.00"}},{"$f":"'Week 37'!E26","v":0}]
["Bench Levels",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C27+'Week 37'!D27","v":{"v":0,"d":"0.00"}},{"$f":"'Week 37'!E27","v":0}]
["Property/R.O.W.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C28+'Week 37'!D28","v":{"v":0,"d":"0.00"}},{"$f":"'Week 37'!E28","v":0}]
["Drainage",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C29+'Week 37'!D29","v":{"v":0,"d":"0.00"}},{"$f":"'Week 37'!E29","v":0}]
["Bridge Surveys ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C30+'Week 37'!D30","v":{"v":0,"d":"0.00"}},{"$f":"'Week 37'!E30","v":0}]
["Office ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C31+'Week 37'!D31","v":{"v":0,"d":"0.00"}},{"$f":"'Week 37'!E31","v":0}]
["Total Time Worked",{"$f":"SUM(B22:B31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C22:C31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D22:D31)","v":{"v":0,"d":"0.00"}}]
["Misc.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C33+'Week 37'!D33","v":{"v":0,"d":"0.00"}},{"$f":"'Week 37'!E33","v":0}]
["Lost Time-Travel",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C34+'Week 37'!D34","v":{"v":0,"d":"0.00"}},null,{"$f":"'Week 1'!F34","v":"travel dist. (miles) - "}]
["Lost Time-Leave",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C35+'Week 37'!D35","v":{"v":0,"d":"0.00"}}]
["Lost Time - Other",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C36+'Week 37'!D36","v":{"v":0,"d":"0.00"}},null,{"$f":"'Week 37'!F36","v":"explain:"}]
["Total Lost Time & Misc.",{"$f":"SUM(B33:B36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C33:C36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D33:D36)","v":{"v":0,"d":"0.00"}}]
["Grand Total",{"$f":"B32+B37","v":{"v":0,"d":"0.00"}},{"$f":"C32+C37","v":{"v":0,"d":"0.00"}},{"$f":"D32+D37","v":{"v":0,"d":"0.00"}}]
[]
["Probable Completion Date:",null,null,{"$f":"'Week 37'!D40","v":"2011-12-02"}]
[]
["Percent Completed This Week:",null,null,0]
["Percent completed to date:",null,null,{"$f":"'Week 37'!D43+D42","v":0}]
[]
["Next Week I expect to:"]

{"sheet":"Week 39","index":39,"n_rows":45,"n_cols":6,"rows_kept":45}
["WEEKLY SURVEY PROGRESS REPORT                                                  "]
[{"$f":"'Week 1'!A2","v":"<< name>>"},{"$f":"'Week 1'!B2","v":"<< title >>"}]
[{"$f":"'Week 1'!A3","v":"<< address >>"}]
["               "]
["No. of Weeks:",{"$f":"CEILING((B6-B17)/7,1)","v":0}]
["For Week Ending:",{"$f":"'Week 38'!B6","v":"2011-12-02"}]
["Proj. No.:",{"$f":"'Week 1'!B7","v":0},null,"Route:",{"$f":"'Week 1'!E7","v":0}]
["County:",{"$f":"'Week 1'!B8","v":0}]
["Length (miles):",{"$f":"'Week 1'!B9","v":0}]
["From Sta:",{"$f":"'Week 1'!B10","v":0},null,"To Sta:",{"$f":"'Week 1'!E10","v":0}]
[]
["From:",{"$f":"'Week 1'!B12","v":0}]
["To:",{"$f":"'Week 1'!B13","v":0}]
[]
["Project Filename:",{"$f":"'Week 1'!B15","v":0}]
["Data Collector Filename:",{"$f":"'Week 1'!B16","v":0}]
["Date Survey Began:",{"$f":"'Week 1'!B17","v":"2011-12-02"}]
[]
[]
[null,"Manhours","Mandays"]
[null,"This Week","This Week","To Date","% Complete","Comments"]
["Control Traverse",{"v":0,"d":"0.00"},{"$f":"B22/7.5","v":{"v":0,"d":"0.00"}},{"$f":"C22+'Week 38'!D22","v":{"v":0,"d":"0.00"}},{"$f":"'Week 38'!E22","v":0}]
["Alignment",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C23+'Week 38'!D23","v":{"v":0,"d":"0.00"}},{"$f":"'Week 38'!E23","v":0}]
["Terrain Model",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C24+'Week 38'!D24","v":{"v":0,"d":"0.00"}},{"$f":"'Week 38'!E24","v":0}]
["Topography",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C25+'Week 38'!D25","v":{"v":0,"d":"0.00"}},{"$f":"'Week 38'!E25","v":0}]
["Utilities ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C26+'Week 38'!D26","v":{"v":0,"d":"0.00"}},{"$f":"'Week 38'!E26","v":0}]
["Bench Levels",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C27+'Week 38'!D27","v":{"v":0,"d":"0.00"}},{"$f":"'Week 38'!E27","v":0}]
["Property/R.O.W.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C28+'Week 38'!D28","v":{"v":0,"d":"0.00"}},{"$f":"'Week 38'!E28","v":0}]
["Drainage",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C29+'Week 38'!D29","v":{"v":0,"d":"0.00"}},{"$f":"'Week 38'!E29","v":0}]
["Bridge Surveys ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C30+'Week 38'!D30","v":{"v":0,"d":"0.00"}},{"$f":"'Week 38'!E30","v":0}]
["Office ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C31+'Week 38'!D31","v":{"v":0,"d":"0.00"}},{"$f":"'Week 38'!E31","v":0}]
["Total Time Worked",{"$f":"SUM(B22:B31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C22:C31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D22:D31)","v":{"v":0,"d":"0.00"}}]
["Misc.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C33+'Week 38'!D33","v":{"v":0,"d":"0.00"}},{"$f":"'Week 38'!E33","v":0}]
["Lost Time-Travel",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C34+'Week 38'!D34","v":{"v":0,"d":"0.00"}},null,{"$f":"'Week 1'!F34","v":"travel dist. (miles) - "}]
["Lost Time-Leave",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C35+'Week 38'!D35","v":{"v":0,"d":"0.00"}}]
["Lost Time - Other",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C36+'Week 38'!D36","v":{"v":0,"d":"0.00"}},null,{"$f":"'Week 38'!F36","v":"explain:"}]
["Total Lost Time & Misc.",{"$f":"SUM(B33:B36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C33:C36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D33:D36)","v":{"v":0,"d":"0.00"}}]
["Grand Total",{"$f":"B32+B37","v":{"v":0,"d":"0.00"}},{"$f":"C32+C37","v":{"v":0,"d":"0.00"}},{"$f":"D32+D37","v":{"v":0,"d":"0.00"}}]
[]
["Probable Completion Date:",null,null,{"$f":"'Week 38'!D40","v":"2011-12-02"}]
[]
["Percent Completed This Week:",null,null,0]
["Percent completed to date:",null,null,{"$f":"'Week 38'!D43+D42","v":0}]
[]
["Next Week I expect to:"]

{"sheet":"Week 40","index":40,"n_rows":45,"n_cols":6,"rows_kept":45}
["WEEKLY SURVEY PROGRESS REPORT                                                  "]
[{"$f":"'Week 1'!A2","v":"<< name>>"},{"$f":"'Week 1'!B2","v":"<< title >>"}]
[{"$f":"'Week 1'!A3","v":"<< address >>"}]
["               "]
["No. of Weeks:",{"$f":"CEILING((B6-B17)/7,1)","v":0}]
["For Week Ending:",{"$f":"'Week 39'!B6","v":"2011-12-02"}]
["Proj. No.:",{"$f":"'Week 1'!B7","v":0},null,"Route:",{"$f":"'Week 1'!E7","v":0}]
["County:",{"$f":"'Week 1'!B8","v":0}]
["Length (miles):",{"$f":"'Week 1'!B9","v":0}]
["From Sta:",{"$f":"'Week 1'!B10","v":0},null,"To Sta:",{"$f":"'Week 1'!E10","v":0}]
[]
["From:",{"$f":"'Week 1'!B12","v":0}]
["To:",{"$f":"'Week 1'!B13","v":0}]
[]
["Project Filename:",{"$f":"'Week 1'!B15","v":0}]
["Data Collector Filename:",{"$f":"'Week 1'!B16","v":0}]
["Date Survey Began:",{"$f":"'Week 1'!B17","v":"2011-12-02"}]
[]
[]
[null,"Manhours","Mandays"]
[null,"This Week","This Week","To Date","% Complete","Comments"]
["Control Traverse",{"v":0,"d":"0.00"},{"$f":"B22/7.5","v":{"v":0,"d":"0.00"}},{"$f":"C22+'Week 39'!D22","v":{"v":0,"d":"0.00"}},{"$f":"'Week 39'!E22","v":0}]
["Alignment",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C23+'Week 39'!D23","v":{"v":0,"d":"0.00"}},{"$f":"'Week 39'!E23","v":0}]
["Terrain Model",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C24+'Week 39'!D24","v":{"v":0,"d":"0.00"}},{"$f":"'Week 39'!E24","v":0}]
["Topography",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C25+'Week 39'!D25","v":{"v":0,"d":"0.00"}},{"$f":"'Week 39'!E25","v":0}]
["Utilities ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C26+'Week 39'!D26","v":{"v":0,"d":"0.00"}},{"$f":"'Week 39'!E26","v":0}]
["Bench Levels",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C27+'Week 39'!D27","v":{"v":0,"d":"0.00"}},{"$f":"'Week 39'!E27","v":0}]
["Property/R.O.W.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C28+'Week 39'!D28","v":{"v":0,"d":"0.00"}},{"$f":"'Week 39'!E28","v":0}]
["Drainage",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C29+'Week 39'!D29","v":{"v":0,"d":"0.00"}},{"$f":"'Week 39'!E29","v":0}]
["Bridge Surveys ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C30+'Week 39'!D30","v":{"v":0,"d":"0.00"}},{"$f":"'Week 39'!E30","v":0}]
["Office ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C31+'Week 39'!D31","v":{"v":0,"d":"0.00"}},{"$f":"'Week 39'!E31","v":0}]
["Total Time Worked",{"$f":"SUM(B22:B31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C22:C31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D22:D31)","v":{"v":0,"d":"0.00"}}]
["Misc.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C33+'Week 39'!D33","v":{"v":0,"d":"0.00"}},{"$f":"'Week 39'!E33","v":0}]
["Lost Time-Travel",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C34+'Week 39'!D34","v":{"v":0,"d":"0.00"}},null,{"$f":"'Week 1'!F34","v":"travel dist. (miles) - "}]
["Lost Time-Leave",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C35+'Week 39'!D35","v":{"v":0,"d":"0.00"}}]
["Lost Time - Other",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C36+'Week 39'!D36","v":{"v":0,"d":"0.00"}},null,{"$f":"'Week 39'!F36","v":"explain:"}]
["Total Lost Time & Misc.",{"$f":"SUM(B33:B36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C33:C36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D33:D36)","v":{"v":0,"d":"0.00"}}]
["Grand Total",{"$f":"B32+B37","v":{"v":0,"d":"0.00"}},{"$f":"C32+C37","v":{"v":0,"d":"0.00"}},{"$f":"D32+D37","v":{"v":0,"d":"0.00"}}]
[]
["Probable Completion Date:",null,null,{"$f":"'Week 39'!D40","v":"2011-12-02"}]
[]
["Percent Completed This Week:",null,null,0]
["Percent completed to date:",null,null,{"$f":"'Week 39'!D43+D42","v":0}]
[]
["Next Week I expect to:"]

{"sheet":"Week 41","index":41,"n_rows":45,"n_cols":6,"rows_kept":45}
["WEEKLY SURVEY PROGRESS REPORT                                                  "]
[{"$f":"'Week 1'!A2","v":"<< name>>"},{"$f":"'Week 1'!B2","v":"<< title >>"}]
[{"$f":"'Week 1'!A3","v":"<< address >>"}]
["               "]
["No. of Weeks:",{"$f":"CEILING((B6-B17)/7,1)","v":0}]
["For Week Ending:",{"$f":"'Week 40'!B6","v":"2011-12-02"}]
["Proj. No.:",{"$f":"'Week 1'!B7","v":0},null,"Route:",{"$f":"'Week 1'!E7","v":0}]
["County:",{"$f":"'Week 1'!B8","v":0}]
["Length (miles):",{"$f":"'Week 1'!B9","v":0}]
["From Sta:",{"$f":"'Week 1'!B10","v":0},null,"To Sta:",{"$f":"'Week 1'!E10","v":0}]
[]
["From:",{"$f":"'Week 1'!B12","v":0}]
["To:",{"$f":"'Week 1'!B13","v":0}]
[]
["Project Filename:",{"$f":"'Week 1'!B15","v":0}]
["Data Collector Filename:",{"$f":"'Week 1'!B16","v":0}]
["Date Survey Began:",{"$f":"'Week 1'!B17","v":"2011-12-02"}]
[]
[]
[null,"Manhours","Mandays"]
[null,"This Week","This Week","To Date","% Complete","Comments"]
["Control Traverse",{"v":0,"d":"0.00"},{"$f":"B22/7.5","v":{"v":0,"d":"0.00"}},{"$f":"C22+'Week 40'!D22","v":{"v":0,"d":"0.00"}},{"$f":"'Week 40'!E22","v":0}]
["Alignment",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C23+'Week 40'!D23","v":{"v":0,"d":"0.00"}},{"$f":"'Week 40'!E23","v":0}]
["Terrain Model",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C24+'Week 40'!D24","v":{"v":0,"d":"0.00"}},{"$f":"'Week 40'!E24","v":0}]
["Topography",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C25+'Week 40'!D25","v":{"v":0,"d":"0.00"}},{"$f":"'Week 40'!E25","v":0}]
["Utilities ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C26+'Week 40'!D26","v":{"v":0,"d":"0.00"}},{"$f":"'Week 40'!E26","v":0}]
["Bench Levels",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C27+'Week 40'!D27","v":{"v":0,"d":"0.00"}},{"$f":"'Week 40'!E27","v":0}]
["Property/R.O.W.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C28+'Week 40'!D28","v":{"v":0,"d":"0.00"}},{"$f":"'Week 40'!E28","v":0}]
["Drainage",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C29+'Week 40'!D29","v":{"v":0,"d":"0.00"}},{"$f":"'Week 40'!E29","v":0}]
["Bridge Surveys ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C30+'Week 40'!D30","v":{"v":0,"d":"0.00"}},{"$f":"'Week 40'!E30","v":0}]
["Office ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C31+'Week 40'!D31","v":{"v":0,"d":"0.00"}},{"$f":"'Week 40'!E31","v":0}]
["Total Time Worked",{"$f":"SUM(B22:B31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C22:C31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D22:D31)","v":{"v":0,"d":"0.00"}}]
["Misc.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C33+'Week 40'!D33","v":{"v":0,"d":"0.00"}},{"$f":"'Week 40'!E33","v":0}]
["Lost Time-Travel",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C34+'Week 40'!D34","v":{"v":0,"d":"0.00"}},null,{"$f":"'Week 1'!F34","v":"travel dist. (miles) - "}]
["Lost Time-Leave",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C35+'Week 40'!D35","v":{"v":0,"d":"0.00"}}]
["Lost Time - Other",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C36+'Week 40'!D36","v":{"v":0,"d":"0.00"}},null,{"$f":"'Week 40'!F36","v":"explain:"}]
["Total Lost Time & Misc.",{"$f":"SUM(B33:B36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C33:C36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D33:D36)","v":{"v":0,"d":"0.00"}}]
["Grand Total",{"$f":"B32+B37","v":{"v":0,"d":"0.00"}},{"$f":"C32+C37","v":{"v":0,"d":"0.00"}},{"$f":"D32+D37","v":{"v":0,"d":"0.00"}}]
[]
["Probable Completion Date:",null,null,{"$f":"'Week 40'!D40","v":"2011-12-02"}]
[]
["Percent Completed This Week:",null,null,0]
["Percent completed to date:",null,null,{"$f":"'Week 40'!D43+D42","v":0}]
[]
["Next Week I expect to:"]

{"sheet":"Week 42","index":42,"n_rows":45,"n_cols":6,"rows_kept":45}
["WEEKLY SURVEY PROGRESS REPORT                                                  "]
[{"$f":"'Week 1'!A2","v":"<< name>>"},{"$f":"'Week 1'!B2","v":"<< title >>"}]
[{"$f":"'Week 1'!A3","v":"<< address >>"}]
["               "]
["No. of Weeks:",{"$f":"CEILING((B6-B17)/7,1)","v":0}]
["For Week Ending:",{"$f":"'Week 41'!B6","v":"2011-12-02"}]
["Proj. No.:",{"$f":"'Week 1'!B7","v":0},null,"Route:",{"$f":"'Week 1'!E7","v":0}]
["County:",{"$f":"'Week 1'!B8","v":0}]
["Length (miles):",{"$f":"'Week 1'!B9","v":0}]
["From Sta:",{"$f":"'Week 1'!B10","v":0},null,"To Sta:",{"$f":"'Week 1'!E10","v":0}]
[]
["From:",{"$f":"'Week 1'!B12","v":0}]
["To:",{"$f":"'Week 1'!B13","v":0}]
[]
["Project Filename:",{"$f":"'Week 1'!B15","v":0}]
["Data Collector Filename:",{"$f":"'Week 1'!B16","v":0}]
["Date Survey Began:",{"$f":"'Week 1'!B17","v":"2011-12-02"}]
[]
[]
[null,"Manhours","Mandays"]
[null,"This Week","This Week","To Date","% Complete","Comments"]
["Control Traverse",{"v":0,"d":"0.00"},{"$f":"B22/7.5","v":{"v":0,"d":"0.00"}},{"$f":"C22+'Week 41'!D22","v":{"v":0,"d":"0.00"}},{"$f":"'Week 41'!E22","v":0}]
["Alignment",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C23+'Week 41'!D23","v":{"v":0,"d":"0.00"}},{"$f":"'Week 41'!E23","v":0}]
["Terrain Model",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C24+'Week 41'!D24","v":{"v":0,"d":"0.00"}},{"$f":"'Week 41'!E24","v":0}]
["Topography",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C25+'Week 41'!D25","v":{"v":0,"d":"0.00"}},{"$f":"'Week 41'!E25","v":0}]
["Utilities ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C26+'Week 41'!D26","v":{"v":0,"d":"0.00"}},{"$f":"'Week 41'!E26","v":0}]
["Bench Levels",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C27+'Week 41'!D27","v":{"v":0,"d":"0.00"}},{"$f":"'Week 41'!E27","v":0}]
["Property/R.O.W.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C28+'Week 41'!D28","v":{"v":0,"d":"0.00"}},{"$f":"'Week 41'!E28","v":0}]
["Drainage",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C29+'Week 41'!D29","v":{"v":0,"d":"0.00"}},{"$f":"'Week 41'!E29","v":0}]
["Bridge Surveys ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C30+'Week 41'!D30","v":{"v":0,"d":"0.00"}},{"$f":"'Week 41'!E30","v":0}]
["Office ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C31+'Week 41'!D31","v":{"v":0,"d":"0.00"}},{"$f":"'Week 41'!E31","v":0}]
["Total Time Worked",{"$f":"SUM(B22:B31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C22:C31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D22:D31)","v":{"v":0,"d":"0.00"}}]
["Misc.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C33+'Week 41'!D33","v":{"v":0,"d":"0.00"}},{"$f":"'Week 41'!E33","v":0}]
["Lost Time-Travel",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C34+'Week 41'!D34","v":{"v":0,"d":"0.00"}},null,{"$f":"'Week 1'!F34","v":"travel dist. (miles) - "}]
["Lost Time-Leave",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C35+'Week 41'!D35","v":{"v":0,"d":"0.00"}}]
["Lost Time - Other",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C36+'Week 41'!D36","v":{"v":0,"d":"0.00"}},null,{"$f":"'Week 41'!F36","v":"explain:"}]
["Total Lost Time & Misc.",{"$f":"SUM(B33:B36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C33:C36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D33:D36)","v":{"v":0,"d":"0.00"}}]
["Grand Total",{"$f":"B32+B37","v":{"v":0,"d":"0.00"}},{"$f":"C32+C37","v":{"v":0,"d":"0.00"}},{"$f":"D32+D37","v":{"v":0,"d":"0.00"}}]
[]
["Probable Completion Date:",null,null,{"$f":"'Week 41'!D40","v":"2011-12-02"}]
[]
["Percent Completed This Week:",null,null,0]
["Percent completed to date:",null,null,{"$f":"'Week 41'!D43+D42","v":0}]
[]
["Next Week I expect to:"]

{"sheet":"Week 43","index":43,"n_rows":45,"n_cols":6,"rows_kept":45}
["WEEKLY SURVEY PROGRESS REPORT                                                  "]
[{"$f":"'Week 1'!A2","v":"<< name>>"},{"$f":"'Week 1'!B2","v":"<< title >>"}]
[{"$f":"'Week 1'!A3","v":"<< address >>"}]
["               "]
["No. of Weeks:",{"$f":"CEILING((B6-B17)/7,1)","v":0}]
["For Week Ending:",{"$f":"'Week 42'!B6","v":"2011-12-02"}]
["Proj. No.:",{"$f":"'Week 1'!B7","v":0},null,"Route:",{"$f":"'Week 1'!E7","v":0}]
["County:",{"$f":"'Week 1'!B8","v":0}]
["Length (miles):",{"$f":"'Week 1'!B9","v":0}]
["From Sta:",{"$f":"'Week 1'!B10","v":0},null,"To Sta:",{"$f":"'Week 1'!E10","v":0}]
[]
["From:",{"$f":"'Week 1'!B12","v":0}]
["To:",{"$f":"'Week 1'!B13","v":0}]
[]
["Project Filename:",{"$f":"'Week 1'!B15","v":0}]
["Data Collector Filename:",{"$f":"'Week 1'!B16","v":0}]
["Date Survey Began:",{"$f":"'Week 1'!B17","v":"2011-12-02"}]
[]
[]
[null,"Manhours","Mandays"]
[null,"This Week","This Week","To Date","% Complete","Comments"]
["Control Traverse",{"v":0,"d":"0.00"},{"$f":"B22/7.5","v":{"v":0,"d":"0.00"}},{"$f":"C22+'Week 42'!D22","v":{"v":0,"d":"0.00"}},{"$f":"'Week 42'!E22","v":0}]
["Alignment",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C23+'Week 42'!D23","v":{"v":0,"d":"0.00"}},{"$f":"'Week 42'!E23","v":0}]
["Terrain Model",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C24+'Week 42'!D24","v":{"v":0,"d":"0.00"}},{"$f":"'Week 42'!E24","v":0}]
["Topography",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C25+'Week 42'!D25","v":{"v":0,"d":"0.00"}},{"$f":"'Week 42'!E25","v":0}]
["Utilities ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C26+'Week 42'!D26","v":{"v":0,"d":"0.00"}},{"$f":"'Week 42'!E26","v":0}]
["Bench Levels",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C27+'Week 42'!D27","v":{"v":0,"d":"0.00"}},{"$f":"'Week 42'!E27","v":0}]
["Property/R.O.W.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C28+'Week 42'!D28","v":{"v":0,"d":"0.00"}},{"$f":"'Week 42'!E28","v":0}]
["Drainage",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C29+'Week 42'!D29","v":{"v":0,"d":"0.00"}},{"$f":"'Week 42'!E29","v":0}]
["Bridge Surveys ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C30+'Week 42'!D30","v":{"v":0,"d":"0.00"}},{"$f":"'Week 42'!E30","v":0}]
["Office ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C31+'Week 42'!D31","v":{"v":0,"d":"0.00"}},{"$f":"'Week 42'!E31","v":0}]
["Total Time Worked",{"$f":"SUM(B22:B31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C22:C31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D22:D31)","v":{"v":0,"d":"0.00"}}]
["Misc.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C33+'Week 42'!D33","v":{"v":0,"d":"0.00"}},{"$f":"'Week 42'!E33","v":0}]
["Lost Time-Travel",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C34+'Week 42'!D34","v":{"v":0,"d":"0.00"}},null,{"$f":"'Week 1'!F34","v":"travel dist. (miles) - "}]
["Lost Time-Leave",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C35+'Week 42'!D35","v":{"v":0,"d":"0.00"}}]
["Lost Time - Other",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C36+'Week 42'!D36","v":{"v":0,"d":"0.00"}},null,{"$f":"'Week 42'!F36","v":"explain:"}]
["Total Lost Time & Misc.",{"$f":"SUM(B33:B36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C33:C36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D33:D36)","v":{"v":0,"d":"0.00"}}]
["Grand Total",{"$f":"B32+B37","v":{"v":0,"d":"0.00"}},{"$f":"C32+C37","v":{"v":0,"d":"0.00"}},{"$f":"D32+D37","v":{"v":0,"d":"0.00"}}]
[]
["Probable Completion Date:",null,null,{"$f":"'Week 42'!D40","v":"2011-12-02"}]
[]
["Percent Completed This Week:",null,null,0]
["Percent completed to date:",null,null,{"$f":"'Week 42'!D43+D42","v":0}]
[]
["Next Week I expect to:"]

{"sheet":"Week 44","index":44,"n_rows":45,"n_cols":6,"rows_kept":45}
["WEEKLY SURVEY PROGRESS REPORT                                                  "]
[{"$f":"'Week 1'!A2","v":"<< name>>"},{"$f":"'Week 1'!B2","v":"<< title >>"}]
[{"$f":"'Week 1'!A3","v":"<< address >>"}]
["               "]
["No. of Weeks:",{"$f":"CEILING((B6-B17)/7,1)","v":0}]
["For Week Ending:",{"$f":"'Week 43'!B6","v":"2011-12-02"}]
["Proj. No.:",{"$f":"'Week 1'!B7","v":0},null,"Route:",{"$f":"'Week 1'!E7","v":0}]
["County:",{"$f":"'Week 1'!B8","v":0}]
["Length (miles):",{"$f":"'Week 1'!B9","v":0}]
["From Sta:",{"$f":"'Week 1'!B10","v":0},null,"To Sta:",{"$f":"'Week 1'!E10","v":0}]
[]
["From:",{"$f":"'Week 1'!B12","v":0}]
["To:",{"$f":"'Week 1'!B13","v":0}]
[]
["Project Filename:",{"$f":"'Week 1'!B15","v":0}]
["Data Collector Filename:",{"$f":"'Week 1'!B16","v":0}]
["Date Survey Began:",{"$f":"'Week 1'!B17","v":"2011-12-02"}]
[]
[]
[null,"Manhours","Mandays"]
[null,"This Week","This Week","To Date","% Complete","Comments"]
["Control Traverse",{"v":0,"d":"0.00"},{"$f":"B22/7.5","v":{"v":0,"d":"0.00"}},{"$f":"C22+'Week 43'!D22","v":{"v":0,"d":"0.00"}},{"$f":"'Week 43'!E22","v":0}]
["Alignment",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C23+'Week 43'!D23","v":{"v":0,"d":"0.00"}},{"$f":"'Week 43'!E23","v":0}]
["Terrain Model",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C24+'Week 43'!D24","v":{"v":0,"d":"0.00"}},{"$f":"'Week 43'!E24","v":0}]
["Topography",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C25+'Week 43'!D25","v":{"v":0,"d":"0.00"}},{"$f":"'Week 43'!E25","v":0}]
["Utilities ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C26+'Week 43'!D26","v":{"v":0,"d":"0.00"}},{"$f":"'Week 43'!E26","v":0}]
["Bench Levels",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C27+'Week 43'!D27","v":{"v":0,"d":"0.00"}},{"$f":"'Week 43'!E27","v":0}]
["Property/R.O.W.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C28+'Week 43'!D28","v":{"v":0,"d":"0.00"}},{"$f":"'Week 43'!E28","v":0}]
["Drainage",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C29+'Week 43'!D29","v":{"v":0,"d":"0.00"}},{"$f":"'Week 43'!E29","v":0}]
["Bridge Surveys ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C30+'Week 43'!D30","v":{"v":0,"d":"0.00"}},{"$f":"'Week 43'!E30","v":0}]
["Office ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C31+'Week 43'!D31","v":{"v":0,"d":"0.00"}},{"$f":"'Week 43'!E31","v":0}]
["Total Time Worked",{"$f":"SUM(B22:B31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C22:C31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D22:D31)","v":{"v":0,"d":"0.00"}}]
["Misc.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C33+'Week 43'!D33","v":{"v":0,"d":"0.00"}},{"$f":"'Week 43'!E33","v":0}]
["Lost Time-Travel",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C34+'Week 43'!D34","v":{"v":0,"d":"0.00"}},null,{"$f":"'Week 1'!F34","v":"travel dist. (miles) - "}]
["Lost Time-Leave",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C35+'Week 43'!D35","v":{"v":0,"d":"0.00"}}]
["Lost Time - Other",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C36+'Week 43'!D36","v":{"v":0,"d":"0.00"}},null,{"$f":"'Week 43'!F36","v":"explain:"}]
["Total Lost Time & Misc.",{"$f":"SUM(B33:B36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C33:C36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D33:D36)","v":{"v":0,"d":"0.00"}}]
["Grand Total",{"$f":"B32+B37","v":{"v":0,"d":"0.00"}},{"$f":"C32+C37","v":{"v":0,"d":"0.00"}},{"$f":"D32+D37","v":{"v":0,"d":"0.00"}}]
[]
["Probable Completion Date:",null,null,{"$f":"'Week 43'!D40","v":"2011-12-02"}]
[]
["Percent Completed This Week:",null,null,0]
["Percent completed to date:",null,null,{"$f":"'Week 43'!D43+D42","v":0}]
[]
["Next Week I expect to:"]

{"sheet":"Week 45","index":45,"n_rows":45,"n_cols":6,"rows_kept":45}
["WEEKLY SURVEY PROGRESS REPORT                                                  "]
[{"$f":"'Week 1'!A2","v":"<< name>>"},{"$f":"'Week 1'!B2","v":"<< title >>"}]
[{"$f":"'Week 1'!A3","v":"<< address >>"}]
["               "]
["No. of Weeks:",{"$f":"CEILING((B6-B17)/7,1)","v":0}]
["For Week Ending:",{"$f":"'Week 44'!B6","v":"2011-12-02"}]
["Proj. No.:",{"$f":"'Week 1'!B7","v":0},null,"Route:",{"$f":"'Week 1'!E7","v":0}]
["County:",{"$f":"'Week 1'!B8","v":0}]
["Length (miles):",{"$f":"'Week 1'!B9","v":0}]
["From Sta:",{"$f":"'Week 1'!B10","v":0},null,"To Sta:",{"$f":"'Week 1'!E10","v":0}]
[]
["From:",{"$f":"'Week 1'!B12","v":0}]
["To:",{"$f":"'Week 1'!B13","v":0}]
[]
["Project Filename:",{"$f":"'Week 1'!B15","v":0}]
["Data Collector Filename:",{"$f":"'Week 1'!B16","v":0}]
["Date Survey Began:",{"$f":"'Week 1'!B17","v":"2011-12-02"}]
[]
[]
[null,"Manhours","Mandays"]
[null,"This Week","This Week","To Date","% Complete","Comments"]
["Control Traverse",{"v":0,"d":"0.00"},{"$f":"B22/7.5","v":{"v":0,"d":"0.00"}},{"$f":"C22+'Week 44'!D22","v":{"v":0,"d":"0.00"}},{"$f":"'Week 44'!E22","v":0}]
["Alignment",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C23+'Week 44'!D23","v":{"v":0,"d":"0.00"}},{"$f":"'Week 44'!E23","v":0}]
["Terrain Model",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C24+'Week 44'!D24","v":{"v":0,"d":"0.00"}},{"$f":"'Week 44'!E24","v":0}]
["Topography",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C25+'Week 44'!D25","v":{"v":0,"d":"0.00"}},{"$f":"'Week 44'!E25","v":0}]
["Utilities ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C26+'Week 44'!D26","v":{"v":0,"d":"0.00"}},{"$f":"'Week 44'!E26","v":0}]
["Bench Levels",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C27+'Week 44'!D27","v":{"v":0,"d":"0.00"}},{"$f":"'Week 44'!E27","v":0}]
["Property/R.O.W.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C28+'Week 44'!D28","v":{"v":0,"d":"0.00"}},{"$f":"'Week 44'!E28","v":0}]
["Drainage",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C29+'Week 44'!D29","v":{"v":0,"d":"0.00"}},{"$f":"'Week 44'!E29","v":0}]
["Bridge Surveys ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C30+'Week 44'!D30","v":{"v":0,"d":"0.00"}},{"$f":"'Week 44'!E30","v":0}]
["Office ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C31+'Week 44'!D31","v":{"v":0,"d":"0.00"}},{"$f":"'Week 44'!E31","v":0}]
["Total Time Worked",{"$f":"SUM(B22:B31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C22:C31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D22:D31)","v":{"v":0,"d":"0.00"}}]
["Misc.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C33+'Week 44'!D33","v":{"v":0,"d":"0.00"}},{"$f":"'Week 44'!E33","v":0}]
["Lost Time-Travel",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C34+'Week 44'!D34","v":{"v":0,"d":"0.00"}},null,{"$f":"'Week 1'!F34","v":"travel dist. (miles) - "}]
["Lost Time-Leave",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C35+'Week 44'!D35","v":{"v":0,"d":"0.00"}}]
["Lost Time - Other",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C36+'Week 44'!D36","v":{"v":0,"d":"0.00"}},null,{"$f":"'Week 44'!F36","v":"explain:"}]
["Total Lost Time & Misc.",{"$f":"SUM(B33:B36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C33:C36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D33:D36)","v":{"v":0,"d":"0.00"}}]
["Grand Total",{"$f":"B32+B37","v":{"v":0,"d":"0.00"}},{"$f":"C32+C37","v":{"v":0,"d":"0.00"}},{"$f":"D32+D37","v":{"v":0,"d":"0.00"}}]
[]
["Probable Completion Date:",null,null,{"$f":"'Week 44'!D40","v":"2011-12-02"}]
[]
["Percent Completed This Week:",null,null,0]
["Percent completed to date:",null,null,{"$f":"'Week 44'!D43+D42","v":0}]
[]
["Next Week I expect to:"]

{"sheet":"Week 46","index":46,"n_rows":45,"n_cols":6,"rows_kept":45}
["WEEKLY SURVEY PROGRESS REPORT                                                  "]
[{"$f":"'Week 1'!A2","v":"<< name>>"},{"$f":"'Week 1'!B2","v":"<< title >>"}]
[{"$f":"'Week 1'!A3","v":"<< address >>"}]
["               "]
["No. of Weeks:",{"$f":"CEILING((B6-B17)/7,1)","v":0}]
["For Week Ending:",{"$f":"'Week 45'!B6","v":"2011-12-02"}]
["Proj. No.:",{"$f":"'Week 1'!B7","v":0},null,"Route:",{"$f":"'Week 1'!E7","v":0}]
["County:",{"$f":"'Week 1'!B8","v":0}]
["Length (miles):",{"$f":"'Week 1'!B9","v":0}]
["From Sta:",{"$f":"'Week 1'!B10","v":0},null,"To Sta:",{"$f":"'Week 1'!E10","v":0}]
[]
["From:",{"$f":"'Week 1'!B12","v":0}]
["To:",{"$f":"'Week 1'!B13","v":0}]
[]
["Project Filename:",{"$f":"'Week 1'!B15","v":0}]
["Data Collector Filename:",{"$f":"'Week 1'!B16","v":0}]
["Date Survey Began:",{"$f":"'Week 1'!B17","v":"2011-12-02"}]
[]
[]
[null,"Manhours","Mandays"]
[null,"This Week","This Week","To Date","% Complete","Comments"]
["Control Traverse",{"v":0,"d":"0.00"},{"$f":"B22/7.5","v":{"v":0,"d":"0.00"}},{"$f":"C22+'Week 45'!D22","v":{"v":0,"d":"0.00"}},{"$f":"'Week 45'!E22","v":0}]
["Alignment",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C23+'Week 45'!D23","v":{"v":0,"d":"0.00"}},{"$f":"'Week 45'!E23","v":0}]
["Terrain Model",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C24+'Week 45'!D24","v":{"v":0,"d":"0.00"}},{"$f":"'Week 45'!E24","v":0}]
["Topography",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C25+'Week 45'!D25","v":{"v":0,"d":"0.00"}},{"$f":"'Week 45'!E25","v":0}]
["Utilities ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C26+'Week 45'!D26","v":{"v":0,"d":"0.00"}},{"$f":"'Week 45'!E26","v":0}]
["Bench Levels",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C27+'Week 45'!D27","v":{"v":0,"d":"0.00"}},{"$f":"'Week 45'!E27","v":0}]
["Property/R.O.W.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C28+'Week 45'!D28","v":{"v":0,"d":"0.00"}},{"$f":"'Week 45'!E28","v":0}]
["Drainage",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C29+'Week 45'!D29","v":{"v":0,"d":"0.00"}},{"$f":"'Week 45'!E29","v":0}]
["Bridge Surveys ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C30+'Week 45'!D30","v":{"v":0,"d":"0.00"}},{"$f":"'Week 45'!E30","v":0}]
["Office ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C31+'Week 45'!D31","v":{"v":0,"d":"0.00"}},{"$f":"'Week 45'!E31","v":0}]
["Total Time Worked",{"$f":"SUM(B22:B31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C22:C31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D22:D31)","v":{"v":0,"d":"0.00"}}]
["Misc.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C33+'Week 45'!D33","v":{"v":0,"d":"0.00"}},{"$f":"'Week 45'!E33","v":0}]
["Lost Time-Travel",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C34+'Week 45'!D34","v":{"v":0,"d":"0.00"}},null,{"$f":"'Week 1'!F34","v":"travel dist. (miles) - "}]
["Lost Time-Leave",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C35+'Week 45'!D35","v":{"v":0,"d":"0.00"}}]
["Lost Time - Other",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C36+'Week 45'!D36","v":{"v":0,"d":"0.00"}},null,{"$f":"'Week 45'!F36","v":"explain:"}]
["Total Lost Time & Misc.",{"$f":"SUM(B33:B36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C33:C36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D33:D36)","v":{"v":0,"d":"0.00"}}]
["Grand Total",{"$f":"B32+B37","v":{"v":0,"d":"0.00"}},{"$f":"C32+C37","v":{"v":0,"d":"0.00"}},{"$f":"D32+D37","v":{"v":0,"d":"0.00"}}]
[]
["Probable Completion Date:",null,null,{"$f":"'Week 45'!D40","v":"2011-12-02"}]
[]
["Percent Completed This Week:",null,null,0]
["Percent completed to date:",null,null,{"$f":"'Week 45'!D43+D42","v":0}]
[]
["Next Week I expect to:"]

{"sheet":"Week 47","index":47,"n_rows":45,"n_cols":6,"rows_kept":45}
["WEEKLY SURVEY PROGRESS REPORT                                                  "]
[{"$f":"'Week 1'!A2","v":"<< name>>"},{"$f":"'Week 1'!B2","v":"<< title >>"}]
[{"$f":"'Week 1'!A3","v":"<< address >>"}]
["               "]
["No. of Weeks:",{"$f":"CEILING((B6-B17)/7,1)","v":0}]
["For Week Ending:",{"$f":"'Week 46'!B6","v":"2011-12-02"}]
["Proj. No.:",{"$f":"'Week 1'!B7","v":0},null,"Route:",{"$f":"'Week 1'!E7","v":0}]
["County:",{"$f":"'Week 1'!B8","v":0}]
["Length (miles):",{"$f":"'Week 1'!B9","v":0}]
["From Sta:",{"$f":"'Week 1'!B10","v":0},null,"To Sta:",{"$f":"'Week 1'!E10","v":0}]
[]
["From:",{"$f":"'Week 1'!B12","v":0}]
["To:",{"$f":"'Week 1'!B13","v":0}]
[]
["Project Filename:",{"$f":"'Week 1'!B15","v":0}]
["Data Collector Filename:",{"$f":"'Week 1'!B16","v":0}]
["Date Survey Began:",{"$f":"'Week 1'!B17","v":"2011-12-02"}]
[]
[]
[null,"Manhours","Mandays"]
[null,"This Week","This Week","To Date","% Complete","Comments"]
["Control Traverse",{"v":0,"d":"0.00"},{"$f":"B22/7.5","v":{"v":0,"d":"0.00"}},{"$f":"C22+'Week 46'!D22","v":{"v":0,"d":"0.00"}},{"$f":"'Week 46'!E22","v":0}]
["Alignment",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C23+'Week 46'!D23","v":{"v":0,"d":"0.00"}},{"$f":"'Week 46'!E23","v":0}]
["Terrain Model",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C24+'Week 46'!D24","v":{"v":0,"d":"0.00"}},{"$f":"'Week 46'!E24","v":0}]
["Topography",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C25+'Week 46'!D25","v":{"v":0,"d":"0.00"}},{"$f":"'Week 46'!E25","v":0}]
["Utilities ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C26+'Week 46'!D26","v":{"v":0,"d":"0.00"}},{"$f":"'Week 46'!E26","v":0}]
["Bench Levels",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C27+'Week 46'!D27","v":{"v":0,"d":"0.00"}},{"$f":"'Week 46'!E27","v":0}]
["Property/R.O.W.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C28+'Week 46'!D28","v":{"v":0,"d":"0.00"}},{"$f":"'Week 46'!E28","v":0}]
["Drainage",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C29+'Week 46'!D29","v":{"v":0,"d":"0.00"}},{"$f":"'Week 46'!E29","v":0}]
["Bridge Surveys ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C30+'Week 46'!D30","v":{"v":0,"d":"0.00"}},{"$f":"'Week 46'!E30","v":0}]
["Office ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C31+'Week 46'!D31","v":{"v":0,"d":"0.00"}},{"$f":"'Week 46'!E31","v":0}]
["Total Time Worked",{"$f":"SUM(B22:B31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C22:C31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D22:D31)","v":{"v":0,"d":"0.00"}}]
["Misc.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C33+'Week 46'!D33","v":{"v":0,"d":"0.00"}},{"$f":"'Week 46'!E33","v":0}]
["Lost Time-Travel",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C34+'Week 46'!D34","v":{"v":0,"d":"0.00"}},null,{"$f":"'Week 1'!F34","v":"travel dist. (miles) - "}]
["Lost Time-Leave",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C35+'Week 46'!D35","v":{"v":0,"d":"0.00"}}]
["Lost Time - Other",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C36+'Week 46'!D36","v":{"v":0,"d":"0.00"}},null,{"$f":"'Week 46'!F36","v":"explain:"}]
["Total Lost Time & Misc.",{"$f":"SUM(B33:B36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C33:C36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D33:D36)","v":{"v":0,"d":"0.00"}}]
["Grand Total",{"$f":"B32+B37","v":{"v":0,"d":"0.00"}},{"$f":"C32+C37","v":{"v":0,"d":"0.00"}},{"$f":"D32+D37","v":{"v":0,"d":"0.00"}}]
[]
["Probable Completion Date:",null,null,{"$f":"'Week 46'!D40","v":"2011-12-02"}]
[]
["Percent Completed This Week:",null,null,0]
["Percent completed to date:",null,null,{"$f":"'Week 46'!D43+D42","v":0}]
[]
["Next Week I expect to:"]

{"sheet":"Week 48","index":48,"n_rows":45,"n_cols":6,"rows_kept":45}
["WEEKLY SURVEY PROGRESS REPORT                                                  "]
[{"$f":"'Week 1'!A2","v":"<< name>>"},{"$f":"'Week 1'!B2","v":"<< title >>"}]
[{"$f":"'Week 1'!A3","v":"<< address >>"}]
["               "]
["No. of Weeks:",{"$f":"CEILING((B6-B17)/7,1)","v":0}]
["For Week Ending:",{"$f":"'Week 47'!B6","v":"2011-12-02"}]
["Proj. No.:",{"$f":"'Week 1'!B7","v":0},null,"Route:",{"$f":"'Week 1'!E7","v":0}]
["County:",{"$f":"'Week 1'!B8","v":0}]
["Length (miles):",{"$f":"'Week 1'!B9","v":0}]
["From Sta:",{"$f":"'Week 1'!B10","v":0},null,"To Sta:",{"$f":"'Week 1'!E10","v":0}]
[]
["From:",{"$f":"'Week 1'!B12","v":0}]
["To:",{"$f":"'Week 1'!B13","v":0}]
[]
["Project Filename:",{"$f":"'Week 1'!B15","v":0}]
["Data Collector Filename:",{"$f":"'Week 1'!B16","v":0}]
["Date Survey Began:",{"$f":"'Week 1'!B17","v":"2011-12-02"}]
[]
[]
[null,"Manhours","Mandays"]
[null,"This Week","This Week","To Date","% Complete","Comments"]
["Control Traverse",{"v":0,"d":"0.00"},{"$f":"B22/7.5","v":{"v":0,"d":"0.00"}},{"$f":"C22+'Week 47'!D22","v":{"v":0,"d":"0.00"}},{"$f":"'Week 47'!E22","v":0}]
["Alignment",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C23+'Week 47'!D23","v":{"v":0,"d":"0.00"}},{"$f":"'Week 47'!E23","v":0}]
["Terrain Model",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C24+'Week 47'!D24","v":{"v":0,"d":"0.00"}},{"$f":"'Week 47'!E24","v":0}]
["Topography",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C25+'Week 47'!D25","v":{"v":0,"d":"0.00"}},{"$f":"'Week 47'!E25","v":0}]
["Utilities ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C26+'Week 47'!D26","v":{"v":0,"d":"0.00"}},{"$f":"'Week 47'!E26","v":0}]
["Bench Levels",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C27+'Week 47'!D27","v":{"v":0,"d":"0.00"}},{"$f":"'Week 47'!E27","v":0}]
["Property/R.O.W.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C28+'Week 47'!D28","v":{"v":0,"d":"0.00"}},{"$f":"'Week 47'!E28","v":0}]
["Drainage",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C29+'Week 47'!D29","v":{"v":0,"d":"0.00"}},{"$f":"'Week 47'!E29","v":0}]
["Bridge Surveys ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C30+'Week 47'!D30","v":{"v":0,"d":"0.00"}},{"$f":"'Week 47'!E30","v":0}]
["Office ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C31+'Week 47'!D31","v":{"v":0,"d":"0.00"}},{"$f":"'Week 47'!E31","v":0}]
["Total Time Worked",{"$f":"SUM(B22:B31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C22:C31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D22:D31)","v":{"v":0,"d":"0.00"}}]
["Misc.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C33+'Week 47'!D33","v":{"v":0,"d":"0.00"}},{"$f":"'Week 47'!E33","v":0}]
["Lost Time-Travel",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C34+'Week 47'!D34","v":{"v":0,"d":"0.00"}},null,{"$f":"'Week 1'!F34","v":"travel dist. (miles) - "}]
["Lost Time-Leave",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C35+'Week 47'!D35","v":{"v":0,"d":"0.00"}}]
["Lost Time - Other",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C36+'Week 47'!D36","v":{"v":0,"d":"0.00"}},null,{"$f":"'Week 47'!F36","v":"explain:"}]
["Total Lost Time & Misc.",{"$f":"SUM(B33:B36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C33:C36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D33:D36)","v":{"v":0,"d":"0.00"}}]
["Grand Total",{"$f":"B32+B37","v":{"v":0,"d":"0.00"}},{"$f":"C32+C37","v":{"v":0,"d":"0.00"}},{"$f":"D32+D37","v":{"v":0,"d":"0.00"}}]
[]
["Probable Completion Date:",null,null,{"$f":"'Week 47'!D40","v":"2011-12-02"}]
[]
["Percent Completed This Week:",null,null,0]
["Percent completed to date:",null,null,{"$f":"'Week 47'!D43+D42","v":0}]
[]
["Next Week I expect to:"]

{"sheet":"Week 49","index":49,"n_rows":45,"n_cols":6,"rows_kept":45}
["WEEKLY SURVEY PROGRESS REPORT                                                  "]
[{"$f":"'Week 1'!A2","v":"<< name>>"},{"$f":"'Week 1'!B2","v":"<< title >>"}]
[{"$f":"'Week 1'!A3","v":"<< address >>"}]
["               "]
["No. of Weeks:",{"$f":"CEILING((B6-B17)/7,1)","v":0}]
["For Week Ending:",{"$f":"'Week 48'!B6","v":"2011-12-02"}]
["Proj. No.:",{"$f":"'Week 1'!B7","v":0},null,"Route:",{"$f":"'Week 1'!E7","v":0}]
["County:",{"$f":"'Week 1'!B8","v":0}]
["Length (miles):",{"$f":"'Week 1'!B9","v":0}]
["From Sta:",{"$f":"'Week 1'!B10","v":0},null,"To Sta:",{"$f":"'Week 1'!E10","v":0}]
[]
["From:",{"$f":"'Week 1'!B12","v":0}]
["To:",{"$f":"'Week 1'!B13","v":0}]
[]
["Project Filename:",{"$f":"'Week 1'!B15","v":0}]
["Data Collector Filename:",{"$f":"'Week 1'!B16","v":0}]
["Date Survey Began:",{"$f":"'Week 1'!B17","v":"2011-12-02"}]
[]
[]
[null,"Manhours","Mandays"]
[null,"This Week","This Week","To Date","% Complete","Comments"]
["Control Traverse",{"v":0,"d":"0.00"},{"$f":"B22/7.5","v":{"v":0,"d":"0.00"}},{"$f":"C22+'Week 48'!D22","v":{"v":0,"d":"0.00"}},{"$f":"'Week 48'!E22","v":0}]
["Alignment",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C23+'Week 48'!D23","v":{"v":0,"d":"0.00"}},{"$f":"'Week 48'!E23","v":0}]
["Terrain Model",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C24+'Week 48'!D24","v":{"v":0,"d":"0.00"}},{"$f":"'Week 48'!E24","v":0}]
["Topography",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C25+'Week 48'!D25","v":{"v":0,"d":"0.00"}},{"$f":"'Week 48'!E25","v":0}]
["Utilities ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C26+'Week 48'!D26","v":{"v":0,"d":"0.00"}},{"$f":"'Week 48'!E26","v":0}]
["Bench Levels",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C27+'Week 48'!D27","v":{"v":0,"d":"0.00"}},{"$f":"'Week 48'!E27","v":0}]
["Property/R.O.W.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C28+'Week 48'!D28","v":{"v":0,"d":"0.00"}},{"$f":"'Week 48'!E28","v":0}]
["Drainage",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C29+'Week 48'!D29","v":{"v":0,"d":"0.00"}},{"$f":"'Week 48'!E29","v":0}]
["Bridge Surveys ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C30+'Week 48'!D30","v":{"v":0,"d":"0.00"}},{"$f":"'Week 48'!E30","v":0}]
["Office ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C31+'Week 48'!D31","v":{"v":0,"d":"0.00"}},{"$f":"'Week 48'!E31","v":0}]
["Total Time Worked",{"$f":"SUM(B22:B31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C22:C31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D22:D31)","v":{"v":0,"d":"0.00"}}]
["Misc.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C33+'Week 48'!D33","v":{"v":0,"d":"0.00"}},{"$f":"'Week 48'!E33","v":0}]
["Lost Time-Travel",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C34+'Week 48'!D34","v":{"v":0,"d":"0.00"}},null,{"$f":"'Week 1'!F34","v":"travel dist. (miles) - "}]
["Lost Time-Leave",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C35+'Week 48'!D35","v":{"v":0,"d":"0.00"}}]
["Lost Time - Other",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C36+'Week 48'!D36","v":{"v":0,"d":"0.00"}},null,{"$f":"'Week 48'!F36","v":"explain:"}]
["Total Lost Time & Misc.",{"$f":"SUM(B33:B36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C33:C36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D33:D36)","v":{"v":0,"d":"0.00"}}]
["Grand Total",{"$f":"B32+B37","v":{"v":0,"d":"0.00"}},{"$f":"C32+C37","v":{"v":0,"d":"0.00"}},{"$f":"D32+D37","v":{"v":0,"d":"0.00"}}]
[]
["Probable Completion Date:",null,null,{"$f":"'Week 48'!D40","v":"2011-12-02"}]
[]
["Percent Completed This Week:",null,null,0]
["Percent completed to date:",null,null,{"$f":"'Week 48'!D43+D42","v":0}]
[]
["Next Week I expect to:"]

{"sheet":"Week 50","index":50,"n_rows":45,"n_cols":6,"rows_kept":45}
["WEEKLY SURVEY PROGRESS REPORT                                                  "]
[{"$f":"'Week 1'!A2","v":"<< name>>"},{"$f":"'Week 1'!B2","v":"<< title >>"}]
[{"$f":"'Week 1'!A3","v":"<< address >>"}]
["               "]
["No. of Weeks:",{"$f":"CEILING((B6-B17)/7,1)","v":0}]
["For Week Ending:",{"$f":"'Week 49'!B6","v":"2011-12-02"}]
["Proj. No.:",{"$f":"'Week 1'!B7","v":0},null,"Route:",{"$f":"'Week 1'!E7","v":0}]
["County:",{"$f":"'Week 1'!B8","v":0}]
["Length (miles):",{"$f":"'Week 1'!B9","v":0}]
["From Sta:",{"$f":"'Week 1'!B10","v":0},null,"To Sta:",{"$f":"'Week 1'!E10","v":0}]
[]
["From:",{"$f":"'Week 1'!B12","v":0}]
["To:",{"$f":"'Week 1'!B13","v":0}]
[]
["Project Filename:",{"$f":"'Week 1'!B15","v":0}]
["Data Collector Filename:",{"$f":"'Week 1'!B16","v":0}]
["Date Survey Began:",{"$f":"'Week 1'!B17","v":"2011-12-02"}]
[]
[]
[null,"Manhours","Mandays"]
[null,"This Week","This Week","To Date","% Complete","Comments"]
["Control Traverse",{"v":0,"d":"0.00"},{"$f":"B22/7.5","v":{"v":0,"d":"0.00"}},{"$f":"C22+'Week 49'!D22","v":{"v":0,"d":"0.00"}},{"$f":"'Week 49'!E22","v":0}]
["Alignment",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C23+'Week 49'!D23","v":{"v":0,"d":"0.00"}},{"$f":"'Week 49'!E23","v":0}]
["Terrain Model",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C24+'Week 49'!D24","v":{"v":0,"d":"0.00"}},{"$f":"'Week 49'!E24","v":0}]
["Topography",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C25+'Week 49'!D25","v":{"v":0,"d":"0.00"}},{"$f":"'Week 49'!E25","v":0}]
["Utilities ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C26+'Week 49'!D26","v":{"v":0,"d":"0.00"}},{"$f":"'Week 49'!E26","v":0}]
["Bench Levels",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C27+'Week 49'!D27","v":{"v":0,"d":"0.00"}},{"$f":"'Week 49'!E27","v":0}]
["Property/R.O.W.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C28+'Week 49'!D28","v":{"v":0,"d":"0.00"}},{"$f":"'Week 49'!E28","v":0}]
["Drainage",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C29+'Week 49'!D29","v":{"v":0,"d":"0.00"}},{"$f":"'Week 49'!E29","v":0}]
["Bridge Surveys ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C30+'Week 49'!D30","v":{"v":0,"d":"0.00"}},{"$f":"'Week 49'!E30","v":0}]
["Office ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C31+'Week 49'!D31","v":{"v":0,"d":"0.00"}},{"$f":"'Week 49'!E31","v":0}]
["Total Time Worked",{"$f":"SUM(B22:B31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C22:C31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D22:D31)","v":{"v":0,"d":"0.00"}}]
["Misc.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C33+'Week 49'!D33","v":{"v":0,"d":"0.00"}},{"$f":"'Week 49'!E33","v":0}]
["Lost Time-Travel",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C34+'Week 49'!D34","v":{"v":0,"d":"0.00"}},null,{"$f":"'Week 1'!F34","v":"travel dist. (miles) - "}]
["Lost Time-Leave",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C35+'Week 49'!D35","v":{"v":0,"d":"0.00"}}]
["Lost Time - Other",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C36+'Week 49'!D36","v":{"v":0,"d":"0.00"}},null,{"$f":"'Week 49'!F36","v":"explain:"}]
["Total Lost Time & Misc.",{"$f":"SUM(B33:B36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C33:C36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D33:D36)","v":{"v":0,"d":"0.00"}}]
["Grand Total",{"$f":"B32+B37","v":{"v":0,"d":"0.00"}},{"$f":"C32+C37","v":{"v":0,"d":"0.00"}},{"$f":"D32+D37","v":{"v":0,"d":"0.00"}}]
[]
["Probable Completion Date:",null,null,{"$f":"'Week 49'!D40","v":"2011-12-02"}]
[]
["Percent Completed This Week:",null,null,0]
["Percent completed to date:",null,null,{"$f":"'Week 49'!D43+D42","v":0}]
[]
["Next Week I expect to:"]

{"sheet":"Week 51","index":51,"n_rows":45,"n_cols":6,"rows_kept":45}
["WEEKLY SURVEY PROGRESS REPORT                                                  "]
[{"$f":"'Week 1'!A2","v":"<< name>>"},{"$f":"'Week 1'!B2","v":"<< title >>"}]
[{"$f":"'Week 1'!A3","v":"<< address >>"}]
["               "]
["No. of Weeks:",{"$f":"CEILING((B6-B17)/7,1)","v":0}]
["For Week Ending:",{"$f":"'Week 50'!B6","v":"2011-12-02"}]
["Proj. No.:",{"$f":"'Week 1'!B7","v":0},null,"Route:",{"$f":"'Week 1'!E7","v":0}]
["County:",{"$f":"'Week 1'!B8","v":0}]
["Length (miles):",{"$f":"'Week 1'!B9","v":0}]
["From Sta:",{"$f":"'Week 1'!B10","v":0},null,"To Sta:",{"$f":"'Week 1'!E10","v":0}]
[]
["From:",{"$f":"'Week 1'!B12","v":0}]
["To:",{"$f":"'Week 1'!B13","v":0}]
[]
["Project Filename:",{"$f":"'Week 1'!B15","v":0}]
["Data Collector Filename:",{"$f":"'Week 1'!B16","v":0}]
["Date Survey Began:",{"$f":"'Week 1'!B17","v":"2011-12-02"}]
[]
[]
[null,"Manhours","Mandays"]
[null,"This Week","This Week","To Date","% Complete","Comments"]
["Control Traverse",{"v":0,"d":"0.00"},{"$f":"B22/7.5","v":{"v":0,"d":"0.00"}},{"$f":"C22+'Week 50'!D22","v":{"v":0,"d":"0.00"}},{"$f":"'Week 50'!E22","v":0}]
["Alignment",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C23+'Week 50'!D23","v":{"v":0,"d":"0.00"}},{"$f":"'Week 50'!E23","v":0}]
["Terrain Model",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C24+'Week 50'!D24","v":{"v":0,"d":"0.00"}},{"$f":"'Week 50'!E24","v":0}]
["Topography",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C25+'Week 50'!D25","v":{"v":0,"d":"0.00"}},{"$f":"'Week 50'!E25","v":0}]
["Utilities ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C26+'Week 50'!D26","v":{"v":0,"d":"0.00"}},{"$f":"'Week 50'!E26","v":0}]
["Bench Levels",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C27+'Week 50'!D27","v":{"v":0,"d":"0.00"}},{"$f":"'Week 50'!E27","v":0}]
["Property/R.O.W.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C28+'Week 50'!D28","v":{"v":0,"d":"0.00"}},{"$f":"'Week 50'!E28","v":0}]
["Drainage",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C29+'Week 50'!D29","v":{"v":0,"d":"0.00"}},{"$f":"'Week 50'!E29","v":0}]
["Bridge Surveys ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C30+'Week 50'!D30","v":{"v":0,"d":"0.00"}},{"$f":"'Week 50'!E30","v":0}]
["Office ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C31+'Week 50'!D31","v":{"v":0,"d":"0.00"}},{"$f":"'Week 50'!E31","v":0}]
["Total Time Worked",{"$f":"SUM(B22:B31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C22:C31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D22:D31)","v":{"v":0,"d":"0.00"}}]
["Misc.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C33+'Week 50'!D33","v":{"v":0,"d":"0.00"}},{"$f":"'Week 50'!E33","v":0}]
["Lost Time-Travel",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C34+'Week 50'!D34","v":{"v":0,"d":"0.00"}},null,{"$f":"'Week 1'!F34","v":"travel dist. (miles) - "}]
["Lost Time-Leave",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C35+'Week 50'!D35","v":{"v":0,"d":"0.00"}}]
["Lost Time - Other",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C36+'Week 50'!D36","v":{"v":0,"d":"0.00"}},null,{"$f":"'Week 50'!F36","v":"explain:"}]
["Total Lost Time & Misc.",{"$f":"SUM(B33:B36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C33:C36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D33:D36)","v":{"v":0,"d":"0.00"}}]
["Grand Total",{"$f":"B32+B37","v":{"v":0,"d":"0.00"}},{"$f":"C32+C37","v":{"v":0,"d":"0.00"}},{"$f":"D32+D37","v":{"v":0,"d":"0.00"}}]
[]
["Probable Completion Date:",null,null,{"$f":"'Week 50'!D40","v":"2011-12-02"}]
[]
["Percent Completed This Week:",null,null,0]
["Percent completed to date:",null,null,{"$f":"'Week 50'!D43+D42","v":0}]
[]
["Next Week I expect to:"]

{"sheet":"Week 52","index":52,"n_rows":45,"n_cols":6,"rows_kept":45}
["WEEKLY SURVEY PROGRESS REPORT                                                  "]
[{"$f":"'Week 1'!A2","v":"<< name>>"},{"$f":"'Week 1'!B2","v":"<< title >>"}]
[{"$f":"'Week 1'!A3","v":"<< address >>"}]
["               "]
["No. of Weeks:",{"$f":"CEILING((B6-B17)/7,1)","v":0}]
["For Week Ending:",{"$f":"'Week 51'!B6","v":"2011-12-02"}]
["Proj. No.:",{"$f":"'Week 1'!B7","v":0},null,"Route:",{"$f":"'Week 1'!E7","v":0}]
["County:",{"$f":"'Week 1'!B8","v":0}]
["Length (miles):",{"$f":"'Week 1'!B9","v":0}]
["From Sta:",{"$f":"'Week 1'!B10","v":0},null,"To Sta:",{"$f":"'Week 1'!E10","v":0}]
[]
["From:",{"$f":"'Week 1'!B12","v":0}]
["To:",{"$f":"'Week 1'!B13","v":0}]
[]
["Project Filename:",{"$f":"'Week 1'!B15","v":0}]
["Data Collector Filename:",{"$f":"'Week 1'!B16","v":0}]
["Date Survey Began:",{"$f":"'Week 1'!B17","v":"2011-12-02"}]
[]
[]
[null,"Manhours","Mandays"]
[null,"This Week","This Week","To Date","% Complete","Comments"]
["Control Traverse",{"v":0,"d":"0.00"},{"$f":"B22/7.5","v":{"v":0,"d":"0.00"}},{"$f":"C22+'Week 51'!D22","v":{"v":0,"d":"0.00"}},{"$f":"'Week 51'!E22","v":0}]
["Alignment",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C23+'Week 51'!D23","v":{"v":0,"d":"0.00"}},{"$f":"'Week 51'!E23","v":0}]
["Terrain Model",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C24+'Week 51'!D24","v":{"v":0,"d":"0.00"}},{"$f":"'Week 51'!E24","v":0}]
["Topography",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C25+'Week 51'!D25","v":{"v":0,"d":"0.00"}},{"$f":"'Week 51'!E25","v":0}]
["Utilities ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C26+'Week 51'!D26","v":{"v":0,"d":"0.00"}},{"$f":"'Week 51'!E26","v":0}]
["Bench Levels",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C27+'Week 51'!D27","v":{"v":0,"d":"0.00"}},{"$f":"'Week 51'!E27","v":0}]
["Property/R.O.W.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C28+'Week 51'!D28","v":{"v":0,"d":"0.00"}},{"$f":"'Week 51'!E28","v":0}]
["Drainage",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C29+'Week 51'!D29","v":{"v":0,"d":"0.00"}},{"$f":"'Week 51'!E29","v":0}]
["Bridge Surveys ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C30+'Week 51'!D30","v":{"v":0,"d":"0.00"}},{"$f":"'Week 51'!E30","v":0}]
["Office ",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C31+'Week 51'!D31","v":{"v":0,"d":"0.00"}},{"$f":"'Week 51'!E31","v":0}]
["Total Time Worked",{"$f":"SUM(B22:B31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C22:C31)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D22:D31)","v":{"v":0,"d":"0.00"}}]
["Misc.",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C33+'Week 51'!D33","v":{"v":0,"d":"0.00"}},{"$f":"'Week 51'!E33","v":0}]
["Lost Time-Travel",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C34+'Week 51'!D34","v":{"v":0,"d":"0.00"}},null,{"$f":"'Week 1'!F34","v":"travel dist. (miles) - "}]
["Lost Time-Leave",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C35+'Week 51'!D35","v":{"v":0,"d":"0.00"}}]
["Lost Time - Other",{"v":0,"d":"0.00"},{"v":0,"d":"0.00"},{"$f":"C36+'Week 51'!D36","v":{"v":0,"d":"0.00"}},null,{"$f":"'Week 51'!F36","v":"explain:"}]
["Total Lost Time & Misc.",{"$f":"SUM(B33:B36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(C33:C36)","v":{"v":0,"d":"0.00"}},{"$f":"SUM(D33:D36)","v":{"v":0,"d":"0.00"}}]
["Grand Total",{"$f":"B32+B37","v":{"v":0,"d":"0.00"}},{"$f":"C32+C37","v":{"v":0,"d":"0.00"}},{"$f":"D32+D37","v":{"v":0,"d":"0.00"}}]
[]
["Probable Completion Date:",null,null,{"$f":"'Week 51'!D40","v":"2011-12-02"}]
[]
["Percent Completed This Week:",null,null,0]
["Percent completed to date:",null,null,{"$f":"'Week 51'!D43+D42","v":0}]
[]
["Next Week I expect to:"]