ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Step cost models in Excel (https://www.excelbanter.com/excel-discussion-misc-queries/152789-step-cost-models-excel.html)

BostonBill

Step cost models in Excel
 
Help, I have been trying to build an electric tariff rate calculator in
Excel. I have tried using conditional formulas, arrays. Separate columns,
at a loss. can anyone give me a suggestion? It should be simple to generate
a rate spreadsheet to compare different electric rates.
--
Bill

John Bundy

Step cost models in Excel
 
Need more information, like where the data is coming from, where it will be
stored, what is the calculation etc to get started.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"BostonBill" wrote:

Help, I have been trying to build an electric tariff rate calculator in
Excel. I have tried using conditional formulas, arrays. Separate columns,
at a loss. can anyone give me a suggestion? It should be simple to generate
a rate spreadsheet to compare different electric rates.
--
Bill


BostonBill

Step cost models in Excel
 
The tariff is based on different prices as usage increase for both generation
and distribution, the changes occur at different levels increase in steps.
--
Bill


"BostonBill" wrote:

Help, I have been trying to build an electric tariff rate calculator in
Excel. I have tried using conditional formulas, arrays. Separate columns,
at a loss. can anyone give me a suggestion? It should be simple to generate
a rate spreadsheet to compare different electric rates.
--
Bill



All times are GMT +1. The time now is 07:03 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com