# Retailer Quotes Import

Prepare the import file from the Retailer Quote

See sample file - [Retailer quote import\_Test Run.xlsx](https://hugeerp10.co.za/hsofmanual/attachments/37)

Enter both WD and WE OR BD and NBD

under each other

[![image.png](https://hugeerp.co.nz/manual/uploads/images/gallery/2024-06/scaled-1680-/CJuimage.png)](https://hugeerp.co.nz/manual/uploads/images/gallery/2024-06/CJuimage.png)

Here is a sample of a 3 Year Stagged file

Sample attached - [Retailer 2-3yr.xlsx](https://hugeerp10.co.za/hsofmanual/attachments/40)

[![image.png](https://hugeerp.co.nz/manual/uploads/images/gallery/2024-06/scaled-1680-/YkXimage.png)](https://hugeerp.co.nz/manual/uploads/images/gallery/2024-06/YkXimage.png)

Here is a sample of a 5 year flat file

Sample Attached - [Retailer 5yr Flat.xlsx](https://hugeerp10.co.za/hsofmanual/attachments/41)

[![image.png](https://hugeerp10.co.za/hsofmanual/uploads/images/gallery/2024-10/scaled-1680-/tTdimage.png)](https://hugeerp10.co.za/hsofmanual/uploads/images/gallery/2024-10/tTdimage.png)

Once the Excel files are prepared, go to Retailer quote import

Fill in the information as to the Type, Rate, Years and Start Period

Then Upload and Import

[![image.png](https://hugeerp.co.nz/manual/uploads/images/gallery/2024-06/scaled-1680-/BgVimage.png)](https://hugeerp.co.nz/manual/uploads/images/gallery/2024-06/BgVimage.png)

After import is done, it will populate all Tabs with cost data

- Costs
- Energy Cost
- Network Cost
- Total Cost

[![image.png](https://hugeerp.co.nz/manual/uploads/images/gallery/2024-06/scaled-1680-/pHGimage.png)](https://hugeerp.co.nz/manual/uploads/images/gallery/2024-06/pHGimage.png)

<div aria-label="Page Section Options" class="pointer-container" id="bkmrk-%C2%A0" refs="pointer@pointer" tabindex="-1"><div class="pointer flex-container-row items-center justify-space-between p-s anim is-page-editable"><div class="flex-container-row items-center gap-s" refs="pointer@mode-section"><button class="text-button icon px-xs" title="Permalink mode, Press to show include tag"><svg class="svg-icon" data-icon="link" role="presentation" viewbox="0 0 24 24" xmlns="http://www.w3.org/2000/svg"></svg></button><div class="input-group"> <button class="button outline icon" title="Copy Link" type="button"><svg class="svg-icon" data-icon="copy" role="presentation" viewbox="0 0 24 24" xmlns="http://www.w3.org/2000/svg"></svg></button></div></div><svg class="svg-icon" data-icon="edit" role="presentation" viewbox="0 0 24 24" xmlns="http://www.w3.org/2000/svg"></svg></div></div>