The price of electricty fluxuates hourly over the course of a year.
My goal is to buy electricy for storage from the grid for the asking price at the time and sell it back to the grid at a later time (for a greater price) in order to make a profit. The criteria however is that when selling it...
I have a pivot table with a ****load of fields. It would help if I could insert calculation fields within the pivot itself rather than doing it externally.
With the data below I'd like to create a field which shows the Profit per Order and the Shipping Cost per Order.
I went to the Analyze...
My spreadsheet looks like this:
Total Collected After Shipping & Fees
Amber List Cost
How do i calculate the profit margin?
I have monthly profit data for 2014. I'm trying to add cumulative profit by monthly cohort in a pivot table. The "Show Value As > Running Total In" function almost works perfect, except I want to leave the cell blank if there is no data to add to the running total. The reason is...
Hi, I have a set of data that has three colums; a centre identifier, the type of asset it is (each centre will be classified as an asset type and I have 5 different asset types) and the profit it makes.
I have seen a chart before where it shows each centre's profit as a bar (so you get a visual...
hi i have been trying to do this for few hours and i just give up i know you gays you could do it with your eyes closed :)
1) i want to know how many Specific item has been sold in Specific Date Range
2) i want to know total profit in Specific item has been sold in Specific Date Range
I have a bit of a challenge and was hoping for some guidance.
I have a very long string of text in a single cell and I need to extract multiple sections of text that appear between two words that repeat in the string.
For example, here is a very simplified version of the text string...
I have sheet Revenue with: Column(A) = "Store_code", Column(B) = "Store_name", Column(C) = "Revenue", Column(D) = "Profit"
Now I want to have macro to do that:
with i = 2 to last row
If Average(C2:Ci)>STDEV.P(C2:Ci) then
if Ci-(Average(C2:Ci)+STDEV.P(C2:Ci))>0 then Ei.value =...
Please help me to bring data from Horizontal array to vertical area.
<colgroup><col width="64" style="width: 48pt;" span="8"> <tbody>
Hi i have searched everywhere for this and i have found a few examples but they don't seem to work for me so thought i would try here !
basically i have a date column starting from B6 a profit column starting from C6 and a difference column starting from d6.
basically i have the dates for...
Hi, i have a spreadsheet which calculates total profit and there is a cell which has my total profit in, i basically want a sheet in my spreadsheet to read the total profit cell and put a date next to it when the workbook is opened (this may have to be VBA or a macro or something, or maybe its...
Hi good afternoon.
I am doing money transfer business and i need to entry every transactions in excel to calculate the profit. But it takes a long time and need your help to make it better.
I'm looking for help regarding calculating profit margins when selling on marketplaces Amazon
I'd like to know if it would be possible to set the profit margin to eg. 20% and work backwards from there; have excel
calculate what my selling price should be to make the 20%?
I need to work out the total value from 2 fields
Q4 = Total Sales = £25,137.90
R4 = Average Product Profit Margin % = 25%
Basically 28% of £25,137.90.
I have currently got the sum - =Q4*R4
However, this gives me £15,911.76. This is incorrect as 28% is £15,807.34.
Please note that...
Hi- I have created a pivot table and want a % calculation on a row. I can not use calculated fields as it is an item in a field and I can not used calculated items as the items are in two different fields.
For anyone financially minded it is a gross profit %. I have my pivot displaying total...
I already have a scroll bar that increases profit value of all my products sold uniformly on a quoting spreadsheet. However I require some products to have a higher profit applied as they are more expensive to produce. What happens at the moment is my SS works out the base cost, uses a...
OK, guys, I have a headache trying to work this out and need some help.
I have a product that costs me £100 looking at the table to the right I want to make a profit that fits the table. But the profit is it to include eBay FVF & PayPal Fee. So we are looking at a Chicken & Egg scenario. I...
I need a formula to work out gross profit. I am a jeweller selling rings.
A Ring Price. B VAT 20%. C Assay Fee (Always 17.50).
D. Gold Price. E Total Cost F Gross Profit
I think it should be B + C + D = E. F - E = GROSS PROFIT
Help please - I am a jeweller trying to work out gross profit from
COLUMN A RING PRICE TO CUSTOMER , COLUMN B VAT 20%, COLUMN C. ASSAY FEE 17.50, COLUMN D GOLD PRICE,
COLUMN E. TOTAL COST COLUMN F. GROSS PROFIT
BASICALLY VAT WORKED OUT AT 20% AND THEN COLUMNS B, C, D, E DEDUCTED FROM...