contact
November 20, 2017, 03:45:25 AM

Author Topic: Player Info Spreadsheet  (Read 2396 times)

0 Members and 1 Guest are viewing this topic.

Offline Bodge

  • Member
  • Posts: 1247
    • View Profile
    • Bodgenet
Player Info Spreadsheet
« on: June 30, 2015, 09:22:26 PM »
I have designed this over the past few weeks. Some may find it useful. It could be used for any universe, may need a little tweaking.

At the right hand side of the sheet it has a section to take the whole fleet, techs and R levels to copy/paste for battle mentat.

It would be great if you could copy/paste the espi report, I may look at it in the near future, if I have any additions then I will post here for you to redownload it.

If you do tweak it or have any ideas you can contact me at my email address bodge@bodgenet.co.uk

www.bodgenet.co.uk/spreadsheets/targets.xlsx

Other
This is a useful Excel Spreadsheet for working out Debris field split.
www.bodgenet.co.uk/spreadsheets/df_calculator_2003.xls


This is a great tool for taking screenshots for posting on the forums.
It is called Greenshot.

www.bodgenet.co.uk/programs/Greenshot.exe
 

Offline Phil M

  • Member
  • Posts: 1216
    • Facebook - phil.mcbride.3
    • Skype - thesevenlevels
    • Twitter - philipmcbride
    • View Profile
    • Phil Mc Bride
Re: Player Info Spreadsheet
« Reply #1 on: June 30, 2015, 11:20:39 PM »
looks like you love probing AA lol
The darkest places in hell are reserved for those who maintain their neutrality in times of moral crisis.

Offline Pantin

  • Member
  • Posts: 832
    • View Profile
Re: Player Info Spreadsheet
« Reply #2 on: June 30, 2015, 11:29:51 PM »
hmm am I missing something or do you have to enter all the ship amounts manually?

If so, yuck.

Also, your colors look terribad.


Offline Swanvesta

  • Member
  • Posts: 817
    • View Profile
Re: Player Info Spreadsheet
« Reply #3 on: June 30, 2015, 11:58:50 PM »
using macros and a cell you can parse esp into excel.. i did it a while back.. its a bit tricky and you'd need different cells, layouts for different universes but, its dooable
Miss Kiki: Believe me I have been well warned about you
Miss Kiki: I think it was stated that Swan is the biggest nut job in the SFC game community

Biggest nut job on SFC - I claim it!

Offline Bodge

  • Member
  • Posts: 1247
    • View Profile
    • Bodgenet
Re: Player Info Spreadsheet
« Reply #4 on: July 01, 2015, 12:02:02 AM »
using macros and a cell you can parse esp into excel.. i did it a while back.. its a bit tricky and you'd need different cells, layouts for different universes but, its dooable

I know is doable, hence why I said I will work on it. and Pantin If you don't like it then don't use it. I put it there for people if they want to use it. If you can do better then show me and together we can make it good. Otherwise DILLYGAF what you think.
 

Offline Bodge

  • Member
  • Posts: 1247
    • View Profile
    • Bodgenet
Re: Player Info Spreadsheet
« Reply #5 on: July 01, 2015, 12:03:11 AM »
looks like you love probing AA lol

Lol. I deleted the others as I had just done a big update, but managed to move aa over. :)
 

Offline Pantin

  • Member
  • Posts: 832
    • View Profile
Re: Player Info Spreadsheet
« Reply #6 on: July 01, 2015, 12:38:00 AM »
you asked for tweaks and feedback I gave you some. :)

Dont' be so susceptible :p


And I do have slightly better.

Offline censored

  • Member
  • Posts: 1194
  • censored
    • Facebook - censored
    • LinkedIn - censored
    • Skype - censored
    • Twitter - censored
    • View Profile
    • censored
Re: Player Info Spreadsheet
« Reply #7 on: July 01, 2015, 12:44:08 AM »
Spreadsheet addicts. :))
Butthurt losers completely owned by me:

Matt H
Grace
Swanvesta
Tech9
BrianC

Offline Pantin

  • Member
  • Posts: 832
    • View Profile
Re: Player Info Spreadsheet
« Reply #8 on: July 01, 2015, 01:43:16 AM »
Spreadsheet addicts. :))

you dont know the half of it

Offline Phil M

  • Member
  • Posts: 1216
    • Facebook - phil.mcbride.3
    • Skype - thesevenlevels
    • Twitter - philipmcbride
    • View Profile
    • Phil Mc Bride
Re: Player Info Spreadsheet
« Reply #9 on: July 01, 2015, 05:37:39 AM »
hmm am I missing something or do you have to enter all the ship amounts manually?

If so, yuck.

Also, your colors look terribad.



At least he fiished his spreadsheet and it works ;)
The darkest places in hell are reserved for those who maintain their neutrality in times of moral crisis.

Offline Phil M

  • Member
  • Posts: 1216
    • Facebook - phil.mcbride.3
    • Skype - thesevenlevels
    • Twitter - philipmcbride
    • View Profile
    • Phil Mc Bride
Re: Player Info Spreadsheet
« Reply #10 on: July 01, 2015, 05:38:58 AM »
Spreadsheet addicts. :))

shoosht you, there are more advanced and better out there for nearly every aspect of the game
The darkest places in hell are reserved for those who maintain their neutrality in times of moral crisis.

Offline censored

  • Member
  • Posts: 1194
  • censored
    • Facebook - censored
    • LinkedIn - censored
    • Skype - censored
    • Twitter - censored
    • View Profile
    • censored
Re: Player Info Spreadsheet
« Reply #11 on: July 01, 2015, 06:38:19 AM »
I wasn't singling anyone out. I was referring to anyone who uses them. ;)
Butthurt losers completely owned by me:

Matt H
Grace
Swanvesta
Tech9
BrianC

Offline Phil M

  • Member
  • Posts: 1216
    • Facebook - phil.mcbride.3
    • Skype - thesevenlevels
    • Twitter - philipmcbride
    • View Profile
    • Phil Mc Bride
Re: Player Info Spreadsheet
« Reply #12 on: July 01, 2015, 01:26:07 PM »
i suspect a fib lol

have to say well done to Bodge tho for sharing his sheets

One of the funniest things i ever encountered in the game was joining a training allaince to help out in one of thsoe odd versions with a different name and asking if anyone had any sheets for various items of the game only for someone to send me a sheet on how to do a blind oracle with a single probe.

they had only sent me back my own sheet from uni 2 unaware it was me that did it lol
The darkest places in hell are reserved for those who maintain their neutrality in times of moral crisis.

Offline Pantin

  • Member
  • Posts: 832
    • View Profile
Re: Player Info Spreadsheet
« Reply #13 on: July 01, 2015, 01:35:56 PM »
fi you did it it must have been awful

Offline Phil M

  • Member
  • Posts: 1216
    • Facebook - phil.mcbride.3
    • Skype - thesevenlevels
    • Twitter - philipmcbride
    • View Profile
    • Phil Mc Bride
Re: Player Info Spreadsheet
« Reply #14 on: July 01, 2015, 03:35:46 PM »
fi you did it it must have been awful

woeful
The darkest places in hell are reserved for those who maintain their neutrality in times of moral crisis.