Jump to content

How do i make a high-alch spreadsheet for pouches


jjjon123

Recommended Posts

1. Price of pouch with high alch - Price in GE = profit

 

 

 

-or-

 

 

 

2. Price of pouch with high alch - (price of shards+price of empty pouch+price of secondary item) = profit

 

 

 

???

pikatips001.pngjjjon123.png

pikatips002.pngjjjon123.png

pikatips003.pngjjjon123.png

pikatips004.pngjjjon123.png

pikatips005.png1,000 F2P Total Level Reached 10/8/10 !

 

[hide=Guides]Magic & Summoning Profit Spreadsheets! *UPDATES EVERY HOUR* (includes: High alch, Superheat, and Enchanting)

4 BETTER alternatives to flesh crawlers[/hide]

 

WOT WOT!

 

☉.☉☂

Link to comment
Share on other sites

it'd be wise to calculate all possible angles.

 

 

 

If it was me I'd first gather the following data:

 

Nat price

 

Shard price

 

Pouch Price

 

 

 

Then on each row for specific pouches i'd acquire:

 

Pouch Value

 

Total Shard Cost

 

Shards recovered for trade in

 

Secondary Cost

 

 

 

Then the maths bit I'd work out:

 

Total pouch cost to make (sum of shard pouch and seconds)

 

GE sell profit (ge value - pouch cost)

 

Shard trade in profit (value of shards for trade in - pouch cost)

 

Alch profit (alch value - (pouch cost+nat cost)

 

 

 

As the odds are the best option will vary from pouch to pouch

Plv6Dz6.jpg

Operation Gold Sparkles :: Chompy Kills ::  Full Profound :: Champions :: Barbarian Notes :: Champions Tackle Box :: MA Rewards

Dragonkin Journals :: Ports Stories :: Elder Chronicles :: Boss Slayer :: Penance King :: Kal'gerion Titles :: Gold Statue

Link to comment
Share on other sites

 

 

 

I already know how to do that :roll: you should have read the question.... 1. or 2.

pikatips001.pngjjjon123.png

pikatips002.pngjjjon123.png

pikatips003.pngjjjon123.png

pikatips004.pngjjjon123.png

pikatips005.png1,000 F2P Total Level Reached 10/8/10 !

 

[hide=Guides]Magic & Summoning Profit Spreadsheets! *UPDATES EVERY HOUR* (includes: High alch, Superheat, and Enchanting)

4 BETTER alternatives to flesh crawlers[/hide]

 

WOT WOT!

 

☉.☉☂

Link to comment
Share on other sites

I did read, and I provided you with a link on how to extract the prices. If you mean you already know that, and want to know how to do basic math, you should of just taken 5 seconds to answer your own question with google, instead of getting cross with me for trying to help with your ill specified question. For microsoft excell it's =(CollumnRow modifiet CollumnRow), for example if you had the ge price of something in A1 and the high alch value in A2 and you wanted to find the difference in A3 you would type =(A1-A2) into the A3. It should be the same for Google Docs.

quit

Link to comment
Share on other sites

I did read, and I provided you with a link on how to extract the prices. If you mean you already know that, and want to know how to do basic math, you should of just taken 5 seconds to answer your own question with google, instead of getting cross with me for trying to help with your ill specified question. For microsoft excell it's =(CollumnRow modifiet CollumnRow), for example if you had the ge price of something in A1 and the high alch value in A2 and you wanted to find the difference in A3 you would type =(A1-A2) into the A3. It should be the same for Google Docs.

 

 

 

 

I ALREADY KNOW HOW TO DO SIMPLE MATH

 

 

 

I WANTED TO KNOW IF I SHOULD DO OPTION 1. OR OPTION 2.

 

 

 

it'd be wise to calculate all possible angles.

 

 

 

If it was me I'd first gather the following data:

 

Nat price

 

Shard price

 

Pouch Price

 

 

 

Then on each row for specific pouches i'd acquire:

 

Pouch Value

 

Total Shard Cost

 

Shards recovered for trade in

 

Secondary Cost

 

 

 

Then the maths bit I'd work out:

 

Total pouch cost to make (sum of shard pouch and seconds)

 

GE sell profit (ge value - pouch cost)

 

Shard trade in profit (value of shards for trade in - pouch cost)

 

Alch profit (alch value - (pouch cost+nat cost)

 

 

 

As the odds are the best option will vary from pouch to pouch

 

 

 

Besides, this seems like a decent way to make it so my question is answered

 

 

 

Thanks Paw_Claw :mrgreen:

pikatips001.pngjjjon123.png

pikatips002.pngjjjon123.png

pikatips003.pngjjjon123.png

pikatips004.pngjjjon123.png

pikatips005.png1,000 F2P Total Level Reached 10/8/10 !

 

[hide=Guides]Magic & Summoning Profit Spreadsheets! *UPDATES EVERY HOUR* (includes: High alch, Superheat, and Enchanting)

4 BETTER alternatives to flesh crawlers[/hide]

 

WOT WOT!

 

☉.☉☂

Link to comment
Share on other sites

oh btw the method I suggestes is how mine r setup:

 

 

 

Gold Charms

 

 

 

Crimson Charms

 

 

 

Blue Charms

 

 

 

Green Charms

 

 

 

Yellow highlighted rows note untradable seconds.

 

 

 

Red Highlights are as follow:

 

 

 

Crimsons:

 

Evil Turnips are often cheaper than Carved ones and it only takes seconds to carve them

 

Goat Horn can be cheaper than Goat Horn Dust and again it only takes seconds to process

 

Bagged Plant 1 can be swapped for Bagged Plant 2 or 3, though 1 is usually cheapest. The Gardener in Falador park may also offer a better price.

 

10 lots of Granite (500g) is usually more expensive than 1 Granite (5kg), if you can wait for the buy and have patience to chisel it down this saves money.

 

 

 

Blue:

 

Jug of Water can be hard to buy, Jugs can easily and cheaply be obtained from most general stores. Humidify or West fally water pump offer a quick way to fill them

 

 

 

Green:

 

Grimey Guam can be cheaper than Clean Guam and only takes a few seconds to clean.

 

 

 

 

 

Buut I think some of the shard trade ins might be off. I assumed they always round down, but I doubt a pouch wuld trade in for 0 shards. But since they r only 25gp ea it makes little impact

Plv6Dz6.jpg

Operation Gold Sparkles :: Chompy Kills ::  Full Profound :: Champions :: Barbarian Notes :: Champions Tackle Box :: MA Rewards

Dragonkin Journals :: Ports Stories :: Elder Chronicles :: Boss Slayer :: Penance King :: Kal'gerion Titles :: Gold Statue

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.