# RFP - Request For Proposal

# Request For Proposal - RFP Search

Search for all active RFPs

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

<table border="1" id="bkmrk-search-search-for-rf" style="border-collapse: collapse; width: 100%;"><colgroup><col style="width: 29.1976%;"></col><col style="width: 70.926%;"></col></colgroup><tbody><tr><td>**Search**</td><td>Search for RFPs</td></tr><tr><td>**Add**</td><td>Add a new RFP</td></tr><tr><td>**Edit**</td><td>Edit an existing RFP</td></tr><tr><td>**Delete**</td><td>Delete an RFP</td></tr><tr><td>**Print Grid**</td><td>Print searched results</td></tr></tbody></table>

# Add Request For Proposal RFP

Fill in the information of the client wanting an RFP

Save the RFP

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

---

#### ICP Data

Go to the ICP Data tab

Click on Add to add in ICP.

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

Enter the ICP number and save

---

<span style="color: rgb(34, 34, 34); font-family: -apple-system, BlinkMacSystemFont, 'Segoe UI', Oxygen, Ubuntu, Roboto, Cantarell, 'Fira Sans', 'Droid Sans', 'Helvetica Neue', sans-serif; font-size: 1.4em; font-weight: 400;">ICP Import (Scrape)</span>

Then click on the ICP import

This will update the various information, click on save again

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

---

##### Consumption data import

Once you have fixed the spreadsheet, make sure it is in this format

A sample of the Excel file is attached - [Consumption Data Import.xlsx](https://hugeerp.co.nz/manual/attachments/16)

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

Import the consumption data

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

Find the file to import

Make sure the Excel sheet is saved and closed before importing

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

After the file is imported, it will update the following tabs

- 144 Part
- 48 Part
- Consumption Stats

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

After all the ICPs have been entered and Consumption data imported.

Save and Close and go back to the RFP

---

#### Retailer Quotes

Go to the retailer quotes tab to enter all your retailer quotes

Click on Add to add the quotes

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

Enter the Retailer that the quote is for.

If this is the current retailer, put a tick on

Select the ICP that this quote is for

Put in a description

EA Levy and Meter charge will populate from Retailer selected

After you have saved, tabs become available

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

---

##### Retailer Quote Import

Prepare the import file from the Retailer Quote

See sample file - [Retailer quote import.xlsx](https://hugeerp.co.nz/manual/attachments/17)

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 - [Mercury 2-3yr.xlsx](https://hugeerp.co.nz/manual/attachments/18)

[![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 - [Mercury 5yr Flat.xlsx](https://hugeerp.co.nz/manual/attachments/19)

[![image.png](https://hugeerp.co.nz/manual/uploads/images/gallery/2024-06/scaled-1680-/Uhgimage.png)](https://hugeerp.co.nz/manual/uploads/images/gallery/2024-06/Uhgimage.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)

---

#### Retailer summary

In order for the Retailer Summary and Benchmarks to work

The Current Retailer needs to be set.

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

This will show all the information on the various Retailers

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

This is similar to your Excel sheet for Summary by Term Master

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

---

#### Benchmark

This shows the information on the various levels of benchmark

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

This is similar to Summary by Term

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

# Individual Connection Point ICP

#### ICP Data

Go to the ICP Data tab

Click on Add to add in ICP.

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

Enter the ICP number and save

---

##### ICP Import (Scrape)

Then click on the ICP import

This will update the various information, click on save again

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

---

##### Consumption data import

Once you have fixed the spreadsheet, make sure it is in this format

A sample of the Excel file is attached - [Consumption Data Import.xlsx](https://hugeerp.co.nz/manual/attachments/16)

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

Import the consumption data

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

Find the file to import

Make sure the Excel sheet is saved and closed before importing

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

After the file is imported, it will update the following tabs

- 144 Part
- 48 Part
- Consumption Stats

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

After all the ICPs have been entered and Consumption data imported.

Save and Close and go back to the RFP

# ICP Import for Consumption data

Import data from current retailer for Consumption data

Fix data with Day Light savings before importing

See attached Sample file - [Consumption Data Import\_ June 2024.xlsx](https://hugeerp10.co.za/hsofmanual/attachments/35)

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

# Retailer Quotes

Adding retailer quotes into the RFP

Go to the retailer quotes tab to enter all your retailer quotes

Click on Add to add the quotes

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

Enter the Retailer that the quote is for.

If this is the current retailer, put a tick on

Select the ICP that this quote is for

Put in a description

EA Levy and Meter charge will populate from Retailer selected

After you have saved, tabs become available

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

---

##### Retailer Quote Import

Prepare the import file from the Retailer Quote

See sample file - [Retailer 5yr Flat.xlsx](https://hugeerp10.co.za/hsofmanual/attachments/38)

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/39)

[![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 - [Mercury 5yr Flat.xlsx](https://hugeerp.co.nz/manual/attachments/19)

[![image.png](https://hugeerp.co.nz/manual/uploads/images/gallery/2024-06/scaled-1680-/Uhgimage.png)](https://hugeerp.co.nz/manual/uploads/images/gallery/2024-06/Uhgimage.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)

# 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>

# Retailer Quote Import NHH

Import layout for Retailer Quote Import for NHH values

One needs to repeat the values per year.

Example, if you want three years of data, repeat the values 3 times per year

Sample import - [Retailer Quote NHH Import.xlsx](https://hugeerp10.co.za/hsofmanual/attachments/46)

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