Thursday, August 18, 2011

Stuck, looking for Spreadsheet functions

I'm stuck. I've been working on a ship building spreadsheet for ISW traveller. Using it as an exercise to learn spreadsheets.

how to reference several arrays? When choosing a shape, it narrows the streamlining options for the ship. Some structures don't have any streamlining options, like diffused hull ships. Now I want to make a list field in the Form control that changes its refence array as it changes choice of shape.

Vlookup is not working. There is something strange happening in my spreadsheet. Vlookup is not working, I found a long winded work around to the problem above but I can't execute it because all my vlookup functions are not working (error:502). I don't get it, some vlookup formulas are working others are not. I double and tripple checked, rewrote them again and reread everything. No clue why.

Recalculate randbetween function. F9 is supposed to recaclualte certain randbetween but it is not working. Looked around and all the help I found online say F9 to recalculate. Anyway, I'm supposed to make a macro targeting one cell, for recalculation down the line. I need to be able to learn to do this If I plan to make a character generator spreadsheet.

Export or Reference macro or function. After all the stats are generated, I need to be able to express all of the data into a stat block. Ideally all can be exported to a text file to be easily cut and pasted for an article. The function list is not detailed in description, I really need to find the time to go through function per function and look at what they really do in detail.

Currently i have colds and a bit of a fever, but the head ache its giving is not helping and stressing me even more.

Other dream spreadsheet projects:
  • Harn/GURPS character creation spreadsheet. Using Harn character generator but automatically converting to GURPS equivalent.
  • System Generator > a more detailed economic system generator
  • Trade Tables Generator

Reading the Black Company Again. Half way through Shadows Linger.
Post a Comment