Fishing Planet Spreadsheet - PC - by WickedViking

[Wicked Viking]

In 2016 I started on a spreadsheet wich has grown a little since then.
Now it contains all the locations with all the fish, their value and sizes in metric.
Yeah, and a small tip for hook sizes and bait/lures for catching fish.

The next pages contains all the current bait ingame and suggestions for a few max-drag setups, wich the new bite-system allows.
Those pages are Bottom setups, Float setups, Spin setups, Casting setups and Tips&Tricks.
I have planned on adding a page for carp setups and a few mixes that works for me, when I get things sorted out, in time.

The spreadsheet will not contain location on where to find the fish.
There are other guides "out there" for that.

I hope some of you find the spreadsheet helpful.

https://docs.google.com/spreadsheets/d/1MVthNeh0VrZZ2mxOAqHojrjowkRZwgcQXIgWlq6ErZ8/edit#gid=1523517194

[Alby66]

good idea....tnx

[richardmuller]

Excellent piece of work!

[von Driesen]

Very nice design, onto my bookmarks. To be used often I suspect.

[Garthok]

Awesome spreadsheet. Thanks for sharing it Wicked Viking

[altus2001]

Wow... nice! Thank you!

[Wicked Viking]

Thank you, I'm glad all of you like it.

Perhaps some day the spreadsheet will earn the honor of being pinned so more people take notice and find it useful.

[Wicked Viking]

*BUMP* Just incase someone find it useful.

[AllenCecil]

The spreadsheet is now blocked.

[Wicked Viking]

Yes I noticed. For some reason Steam doesen't like that link anymore, even if the link has not changed for 6 years.

[JeppeH]

Originally posted by Xarastier:

The spreadsheet is now blocked.

You can copy the link and paste it in a new tab.

[delboyspencer YNWA JFT97]

Link is now flagged as malicious by Steam

[Wicked Viking]

Originally posted by Delboyspencer™(YNWA JFT97):

Link is now flagged as malicious by Steam

Yes I know. Nothing malicious about that link, even if Steam thinks it is.
Did you try what JeppeH suggested in the post just above yours?

[Yahadie]

Is it possible to add a imperial conversion tab for the "locations-fish-weight-price"

[Wicked Viking]

Originally posted by Yahadie:

Is it possible to add a imperial conversion tab for the "locations-fish-weight-price"

Yes it is. I have had several people telling me they wanted to do a conversion for it, but I have not seen any results of that yet.

There is 1700 numbers that would need to be converted.
So far I have not been bored enough to do it myself.

[★Kelvy★]

I noticed in KGs weight for fish you use a comma where it should be a dot. (not sure that is correct) (for using Xcell formula's)
Add a conversion to lbs is easy(add new columns next to uni,trophy and common, highlight columns (each) and x by 2.24 approx.
Or add a column next to each of those (with pounds in header). sample only - Column A, line number 1 X by 2.24 and copy to column B then drag that cell (line 1 column B) down and will change all of column A to lbs in column B.
Of course this is done in Xcell formula's to get the results. It will then show weights in Kilos and pounds.
As for lure etc. leave as is, each person only has to do this same way as eg. sample - for line depth 35cm (350mm) divide by 25.5 = 13.78 inches (FP states 13 inches)
And of course to change pounds to kilo it is the opposite. Or feet/inches to cms'/mms'.


PS had to alter kilograms to pound ratio I put wrong figures in. (sorry)