If I am imported from an Excel price file, the below is on method that would work - with <Field11> being, say, "Monthly" in the spreadsheet.
great that worked, cheers Matt
Tim Mears