Architect Archive

Not a bad idea. I'll see about adding it in v2.2. Thanks for the suggestion!

I just downloaded it and will give it a run tonight. Question, what exactly does the VBA macro accomplish. I'll be playing with it on my work laptop which has Excel but everyday use will come from my home computer which I refuse to pay an additional microsoft tax on and use OpenOffice. I know that the VBA macro will not run under OpenOffice and I'm wondering what functionality I'll be loosing.

Great to here. I would think it is still not working with Office X for the Mac?

To be honest, I don't have access to a Mac with Office X on it. I would assume that it should work to some degree (if the file can be opened). At worst the VBA macro's wouldn't work, but all the normal excel functions should. Can anyone verify/validate this for me? It would be greatly appreciated.

It's ok I've done the same thing before.

I'm going to see about making a simple/mini/smaller/something version of the Lot Management spreadsheet. It will be designed to work in OpenOffice from the ground up. My goal is to make it one or two worksheets, but it won't have all the features of the current Lot Management sheet.

I used the application under excel on my work laptop last night and got all of my stuff entered. All I have to say is WOW.....I don't know how I ran things without it. Before last night, I really had no clue as to where my credits were going and how much my resouces were costing me to manage. I just recently made Master Droid Engineer and hadn't concerned myself with profit margins, resource costs, etc. All I have is great praise as this makes things so much easier on me now.

Great Work!!!

Wow! Thanks for the great tool.I was thinking of doing something similiar (not in Excel though), but after seeing your spreadsheet I just said to myself "Why re-invent the wheel? My version ain't gonna be rounder . . . "

One feature I would like to see: a column on the master lot and maintenance pages for closest shuttle/starport. Initially, this could be just a brainless text column where the user could just type whatever in. But ideally, a lookup table of all the ports with their planet, x, and y coordinates would exist somewhere, and the spreadsheet could determine the closest port. While the NPC ports (Theed, Coronet, etc.) could be pre-populated, it would be up to the player to maintain this table with player-created ports.Just a suggestion . . .

Thanks again,

Voco Ackopogo

---

Bumbles wrote:

Wow! Thanks for the great tool.I was thinking of doing something similiar (not in Excel though), but after seeing your spreadsheet I just said to myself "Why re-invent the wheel? My version ain't gonna be rounder . . . "

One feature I would like to see: a column on the master lot and maintenance pages for closest shuttle/starport. Initially, this could be just a brainless text column where the user could just type whatever in. But ideally, a lookup table of all the ports with their planet, x, and y coordinates would exist somewhere, and the spreadsheet could determine the closest port. While the NPC ports (Theed, Coronet, etc.) could be pre-populated, it would be up to the player to maintain this table with player-created ports.Just a suggestion . . .

Thanks again,

Voco Ackopogo

---

Very creative idea I'll add it to my list of things I could add.

I think I sent a message about the exact error, but basicly VBA for the Mac version is a no-go. Its kinda in there, but not current with the whole Office product.

Maybe the openoffice port will work better for me, as I really don't need any more wintendo machines. 1 Plays this game fine and the others actually do work

I just downloaded it, very nice!

But somethingI noticed is that the extraction rates appear incorrect. Your master table listes the BER's for the Medium's as 4 and the Heavy's as 7? Shoudn't it be 10 and 13 respectively?

---

DukeMoadib wrote:

I just downloaded it, very nice!

But something I noticed is that the extraction rates appear incorrect. Your master table listes the BER's for the Medium's as 4 and the Heavy's as 7? Shoudn't it be 10 and 13 respectively?

---

That's spec for not being experimented, the master lot table lets you put what the BER of tha t particular harvester is

---

keylargodave wrote:

---

DukeMoadib wrote:

I just downloaded it, very nice!

But something I noticed is that the extraction rates appear incorrect. Your master table listes the BER's for the Medium's as 4 and the Heavy's as 7? Shoudn't it be 10 and 13 respectively?

---

That's spec for not being experimented, the master lot table lets you put what the BER of tha t particular harvester is

---

Yup You can also change the BER on the Daily Output and the Lot Info pages.

Thanx for the replies. Yes I did see the master lot tables, was just a bit thrown off by the base values, thanks for clearing that up; works like a charm. Great spreadsheet, clean and very well structured (I do monster spreadsheets myself at work, but mine are one hell of a mess :smileyvery-happy