{"text_format":"3","workbook":"xlsx","n_sheets":6,"sheets":["Sheet1","SGM_MetricTransfer","SGM_Metadata","SGM_RelatedProjectMetrics","SGM_DeliverablesActivities","SGM_Notes"],"read":"whole","date_system":"1900"}

{"sheet":"Sheet1","index":0,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"SGM_MetricTransfer","index":1,"n_rows":2,"n_cols":9,"rows_kept":2}
["Metric System Name","Metric Display Name","Current Value String","Current Value Number","Current Value Date","Data Type","List Values","Publish will use New Value","New Value"]
["Do NOT delete this row --->",null,"this is a very long string                                                                                                                                        very long string                                                                                                          very long string",123,"2001-01-01"]

{"sheet":"SGM_Metadata","index":2,"n_rows":1,"n_cols":6,"rows_kept":1}
["Name","Current Value String","Current Value Number","Current Value Date","Publish will use New Value","New Value"]

{"sheet":"SGM_RelatedProjectMetrics","index":3,"n_rows":2,"n_cols":10,"rows_kept":2}
["System Project ID","Metric System Name","Metric Display Name","Current Value String","Current Value Number","Current Value Date","Data Type","List Values","Publish will use New Value","New Value"]
[123,"Do NOT delete this row --->",null,"this is a very long string                                                                                                                                        very long string                                                                                                          very long string",123,"2001-01-01"]

{"sheet":"SGM_DeliverablesActivities","index":4,"n_rows":1,"n_cols":25,"rows_kept":1}
["DeliverableID ","ActivityID ","PhaseID ","DeliverableStageName ","Name ","Owner ","OwnerLogin ","Start ","Deadline ","Function ","FunctionSystemName ","StatusID ","StatusNotes ","InTrouble","Action ","DeliverableID ","ActivityID ","Name ","OwnerLogin ","Start ","Deadline ","FunctionSystemName ","StatusID ","StatusNotes","InTrouble"]

{"sheet":"SGM_Notes","index":5,"n_rows":18,"n_cols":2,"rows_kept":18}
["Using this Template"]
[]
["1.","Save this template using the SAVE AS menu option, giving it a name that identifies its content."]
["2.","Format the display worksheet(s). Decide which cells will be used to update metrics, which to display metrics or metadata, and which for data entry."]
["3.","Add the metrics that you will use to the System Name column of the SGM_MetricTransfer worksheet."]
["4.","Using named references rather than standard references to column:row makes it easier to maintain the templates and may make it easier to format them originally."]
["5.","Set the format of the New Value column to \"dd-mmm-yy\" for all date metrics that will be uploaded from the workbook."]
["6.","Make the data entry cells on the display tab writeable (protection = unlocked) and protect the rest of the worksheet."]
["7.","Hide all the SGM worksheets."]
[]
["Guidelines"]
[]
[null,"Do not rename SGM_MetricTransfer worksheet."]
[null,"Do not delete or change the data the first row of the SGM_MetricTransfer worksheet."]
[null,"Do not type anything into the New Value columns on SGM_Metric Transfer after you enter the cell reference."]
[null,"Do not place any intermediate formulas on SGM_MetricTransfer worksheet."]
[null,"Do not leave blank rows in the list of metrics."]
[null,"Do not protect the workbook or the SGM_ worksheets. You can protect individual display worksheets."]