favor on spreadsheet

northwesten · Post by **northwesten** » April 18th, 2007, 16:55

hi someone make a Spreadsheet for me. Nothing big but just a tool that help me but i dont know how to do it. Using it for record on market for eve. simply showing how much what buy and sell and how much profit.

All i need is Column A left blank. B what i buy and C i how much i sell. D showed the different amount between B to C. about 15 lines down right at the bottom of total amount of each column B,Cand D the total amount. for example:

Name (A)...........(B) --(C) ---(D)
Heavey beams : 500 --600 -- 100
Dancer ......... ..: 150 -- 50 --- 50
whore ..............: 10 -- 15 --- 5

Tatol ..............=660--- =815 -- =155

Thanks in advance and can someone point me a good site i could learn some point?

Pete

Post by **Roman Totale** » April 18th, 2007, 16:59

Didn't Amblin make one of these?

northwesten · Post by **northwesten** » April 18th, 2007, 17:02

Roman Totale wrote:Didn't Amblin make one of these?

no i dont belive he did i havent had one!

Post by **FatherJack** » April 18th, 2007, 18:08

Code: Select all

Item	Buy	Sell	Profit
Beams	500	600	=C2-B2
Dancers	50	150	=C3-B3
Whores	10	15	=C4-B4
Total			=SUM(D2:D4)

Post by **Roman Totale** » April 18th, 2007, 18:29

It was Joose:

http://www.5punk.co.uk/phpbb/viewtopic.php?t=512

Knew someone had done one.

northwesten · Post by **northwesten** » April 18th, 2007, 18:31

is joose still kicking around? the link doesnt seem to work tho.

Oh and Jack thanks for the code but umm *blushes* how do i set it up and arrange it? i been messing around and well i getting confused oh to apply it

Mr. Johnson · Post by **Mr. Johnson** » April 18th, 2007, 18:37

did you mis-spell "whole" or did you really mean a prostitute?

northwesten · Post by **northwesten** » April 18th, 2007, 19:20

shoot i forgot one thing how many lol

A:Name of iteam
B: brought for
C: Selling for
D:How many goods
E: Total profit

Name (A)...........(B) --(C) -----(D) ----- (E)
Heavey beams : 500 --600 -- 100 --- 60000
Dancer ......... ..: 150 --250 --- 50 --- 12500
whore ..............: 10 -- 15 --- -- 5 ------- etc

Tatol ..............=660--- =815 ----------=155

just woundering!

Post by **deject** » April 18th, 2007, 19:30

northwesten wrote:shoot

just woundering!

OW!

Post by **FatherJack** » April 18th, 2007, 19:42

Google spreadsheet: http://spreadsheets.google.com/ccc?key= ... _Lx7Zp4UDA

Download: http://files.fatherjack.net/5punk/Profit%20Calc.xls