These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

Market Discussions

 
  • Topic is locked indefinitely.
 

Need Someone for some excel sheet help
Author
Previous Topic Next Topic
Chiyeung Bonaparte
The Scope
Gallente Federation
#1 - 2012-03-03 06:49:37 UTC
Hi guys, I need someone to help me out on my excel sheets. Calculating profit, daily, monthly or yearly. Just need some one to help set it up or look at mine. Fairly new to excel but Ive been keeping book since my 2 days of running my corp.

I'll even pay for help. I just want to get my book keeping on track and learn about it so I can eventually work on getting a report out in 1-3 months for a bond.
Amaya Ishii
Republic Military School
Minmatar Republic
#2 - 2012-03-03 09:54:02 UTC
PM me.
Volar Kang
Kang Industrial
#3 - 2012-03-04 04:29:13 UTC
If you are doing any manufacturing calculations, I have found it helps to have a "price" page where I list all my materials and the current Jita buy and sell price. I then link those fields to my actual manufacturing worksheets by putting the following in the cells =(price!d15) this would put the value from sheet "price" and cell d15 into the cell you are working on. Works great when you have over 50 worksheets of items you build and you can update just the price sheet and everything else flows and updates automatically.

Here are some formulas to keep in mind:

=(price!D15) this one links the value from worksheet "price" and cell D15 into the current sheet/cell.
=SUM(D15:D20) this one will add all the cells from D15 thru D20
=Product(D15,E15) this one multiplies the value of cell D15 by the value in cell E15
Scion Lex
LEX Investments
#4 - 2012-03-05 06:12:09 UTC
I can build a custom spreadsheet for your operations in addition to pointing out information sources and methods you may or may not be familiar with. All while protecting your privacy and operation security. Pls contact me ingame.
Steve Ronuken
Fuzzwork Enterprises
Vote Steve Ronuken for CSM
#5 - 2012-03-05 11:24:46 UTC
Something else to bear in mind. Relative and absolute cell references.

D1 refers to row one in column D. If you drag a cell with a formula containing this down one cell, the formula will be updated to refer to D2

$D$1 refers to row one in column D. If you drag a cell with a formula containing this down one cell, the formula will be unchanged (unless you have other references. Those can still update).

Woo! CSM XI!

Fuzzwork Enterprises

Twitter: @fuzzysteve on Twitter
Catho Sharn
Don't Die Interstellar Enterprises
#6 - 2012-03-06 00:40:04 UTC
Steve Ronuken wrote:

$D$1 refers to row one in column D. If you drag a cell with a formula containing this down one cell, the formula will be unchanged (unless you have other references. Those can still update).


See also $D1 and D$1, which are mixed absolute/relative references.