* For deriving campnames automatically, enter this into all cells; it may
  require SHIFT-ENTER or CTRL-SHIFT-ENTER to activate it (try it first on
  a camp row) but copy and pasting works fine.
 
  Paste this into the *SECOND* row, put the cursor on the formula end (at
  the top) and press CTRL-SHIFT-ENTER. It should then be blank (assuming
  no camp on row#2). Then copy-and-paste it into all cells in that column:

  =IF(G2="","",CONCATENATE("camp",TEXT(SUM(COUNTIF(G$2:G2,G$2:G2)),"000")))
 
  It's quite slow, so once the final camps are set, then it should be replaced
  by the actual 'campXXX' text.