1 <% include('/elements/header.html', 'Edit rates with Excel' ) %>
3 <% include( '/elements/form-file_upload.html',
4 'name' => 'RateImportForm',
5 'action' => 'process/rate_edit_excel.html',
7 'fields' => [ 'format' ],
8 'message' => 'Rate edit successful',
9 'url' => $p."browse/rate_region.html",
13 <% &ntable("#cccccc", 2) %>
16 <TH ALIGN="left">1. Download current rates:</TH>
18 <A HREF="<%$p%>/browse/rate_region.html?show_rates=1;_type=regions.xls">Download rate spreadsheet</A>
23 <TH ALIGN="left" COLSPAN=2>2. Edit rates with Excel (or other .XLS-compatible application)</TH>
27 <TD ALIGN="left" COLSPAN=2>
28 - To add rates, add four columns like an existing rate, with headers starting with "NEW: Rate Name" or "Rate Name".<BR>
29 - <FONT SIZE="-2"><I>For rate addition, protection can be turned off in Excel via the Tools->Protection->Unprotect Sheet menu command. Note that only new rates can be added; modified grayed out cells will not be imported.</I></FONT>
33 <% include( '/elements/file-upload.html',
35 'label' => '3. Upload edited rate file: ',
36 'label_align' => 'left',
40 <INPUT TYPE="hidden" NAME="format" VALUE="default">
43 <TD COLSPAN=2 ALIGN="center" STYLE="padding-top:6px">
44 <INPUT TYPE = "submit"
47 onClick = "document.RateImportForm.submit.disabled=true;"
55 <% include('/elements/footer.html') %>
59 unless $FS::CurrentUser::CurrentUser->access_right('Configuration');