Posting MOM Walkabout Checklist to ELog¶

The method for posting MOM checklists to the ELog has recently changed (June 2013), to make it easier for the MOM, and produce a more standard layout. Please follow the instructions below:

• You'll need to be on micenet to post the entry, so suggest you do all of this in the control room.

• Obtain the most recent version of the MOM checklist spreadsheet from the MOM computer in R76.

• Fill in the data from the paper log into the spreadsheet.
  • All data is input on the "Input" sheet.
  • When finished, select the "Output" sheet.
  • Ensure that cell C2 isn't showing ERROR.
    • If it is, this is because you have an illegal comma (,) in your input.
    • The "Test" sheet will be somewhat useful in helping you find the offending cell. Correct it before continuing.
  • Select "output" sheet, and save the spreadsheet (you MUST save with the "Output" sheet selected).

• Go to http://miceserv1.micenet.rl.ac.uk/~elog/ to upload the spreadsheet.
  • If you can't access the webpage, make sure you're on a micenet machine.
  • Select the file using the browse button, and click submit.
  • There will be a 60 second pause while the server converts the spreadsheet into a html page. Please don't hit refresh, it will break it.
    • If it doesn't work, you'll get an error message. Please contact Ian Taylor.
  • The page should have a frame showing the proposed post. This will be in the same format as the paper copy; please double check all data before clicking submit.
  • When ready, click submit. There will be another brief pause, while the server posts to the elog.
  • Click the provided link to confirm the entry was successful.

• You can also access the micenet elog directly: http://miceserv1.micenet.rl.ac.uk:8079/MICE+Log/

• The main elog will take up to 5 minutes to sync with the micenet copy.

• If you have any problems, contact Ian Taylor (i.taylor@warwick.ac.uk). Send him the checklist spreadsheet you're trying to upload.

Adding new entries to the MOM Walkabout Checklist¶

Adding new entries to the MOM spreadsheet is now very slightly more complicated than it was before. You need to ensure that the new entry is correctly formatted in the "Output" sheet.

• Add a row at the correct location in the "Input" sheet.
  • Ensure the border formatting is sorted out (thick borders are 2pt, thin is 0.5 pt).
  • Make a not of the line number for the new row: RowN.

• On the "Output" sheet:
  • Remove sheet protection: Tools -> Protect Document -> Sheet
  • Insert a row at line RowN + 2.
  • Find a row with data similar to your new row (e.g. single number with 2 decimal places, text box, concatenated number, etc.)
  • Copy the full line, and paste into the new line.
  • The line title should appear, as should any values entered.
  • The "K" column defines the output style of the field:
    • # For a generic number
    • 0.0 For a number with a single decimal place (which will be filled with 0's if required)
    • 0000 For 4 digits (useful for binary, e.g. 0011)
    • Blank for text.
    • Some rows have concatenated numbers, and have entries in both "K" and "L".
  • Re-apply sheet protection: Tools -> Protect Document -> Sheet (No password)

• On the "Test" sheet:
  • Remove sheet protection: Tools -> Protect Document -> Sheet
  • Insert a row at line RowN + 2.
  • Extend the formula down from the row above.
  • Ensure the formula in K2 covers the new row.
  • Re-apply sheet protection: Tools -> Protect Document -> Sheet (No password)

• Save, and place the new spreadsheet on the MOM computer in R76.