Architect Archive

Happy Holidays Artisans!
I've finished v2.1 of my Lot Management Excel Spreadsheet. I've made a lot of improvements from v2.0 (At least I hope so). You can get v2.1 from http://swg.medievalweapons.net on the Lot Management page. As always, I encourage ANY and ALL feedback. Just post it here or use the feedback form on my site.

---

Update Notes:

• Added the Report, Daily Output, Owners, Vendors, Custom View, and Master Lot Table pages
  
• Changed Spec Rate to Extraction Base Rate
  
• Purchased Energy Cost per Unit is now used on the Summary page
  
• Drop down list for Building Type on the Resource Sales page
  
• Removed some unused name definitions
  
• Efficiency IV is now set by Owner
  
• Owner field added to all versions
  
• Added Planet, X Coord, and Y Coord fields
  
• Moved all Data and most calculations to a Master Lot Table page (allows for easier updates)
  
• Planet, X Coord, and Y Coord have been added to the Maintenance page
  
• Made the Redeed cost optional
  
• Added a field for Player City Maintenance Tax
  
• Fixed an error with the Current Maintenanace Pool formula
  
• Updated the Redeed formula to use Efficiency IV
  
• Added the Total-Credits w/ Energy per Unit field to the Summary page
  
• Improved the cell copy macro to keep data in sync across the pages
  
• Updated the documentation page to reflect all the changes
  
• Played with the colors again
  
• Added Vendor costs to the Summary page

Happy Holidays Architects!
I've finished v2.1 of my Lot Management Excel Spreadsheet. I've made a lot of improvements from v2.0 (At least I hope so). You can get v2.1 from http://swg.medievalweapons.net on the Lot Management page. As always, I encourage ANY and ALL feedback. Just post it here or use the feedback form on my site.

---

Update Notes:

• Added the Report, Daily Output, Owners, Vendors, Custom View, and Master Lot Table pages
  
• Changed Spec Rate to Extraction Base Rate
  
• Purchased Energy Cost per Unit is now used on the Summary page
  
• Drop down list for Building Type on the Resource Sales page
  
• Removed some unused name definitions
  
• Efficiency IV is now set by Owner
  
• Owner field added to all versions
  
• Added Planet, X Coord, and Y Coord fields
  
• Moved all Data and most calculations to a Master Lot Table page (allows for easier updates)
  
• Planet, X Coord, and Y Coord have been added to the Maintenance page
  
• Made the Redeed cost optional
  
• Added a field for Player City Maintenance Tax
  
• Fixed an error with the Current Maintenanace Pool formula
  
• Updated the Redeed formula to use Efficiency IV
  
• Added the Total-Credits w/ Energy per Unit field to the Summary page
  
• Improved the cell copy macro to keep data in sync across the pages
  
• Updated the documentation page to reflect all the changes
  
• Played with the colors again
  
• Added Vendor costs to the Summary page

Happy Holidays Merchants!
I've finished v2.1 of my Lot Management Excel Spreadsheet. I've made a lot of improvements from v2.0 (At least I hope so). You can get v2.1 from http://swg.medievalweapons.net on the Lot Management page. As always, I encourage ANY and ALL feedback. Just post it here or use the feedback form on my site.

---

Update Notes:

• Added the Report, Daily Output, Owners, Vendors, Custom View, and Master Lot Table pages
  
• Changed Spec Rate to Extraction Base Rate
  
• Purchased Energy Cost per Unit is now used on the Summary page
  
• Drop down list for Building Type on the Resource Sales page
  
• Removed some unused name definitions
  
• Efficiency IV is now set by Owner
  
• Owner field added to all versions
  
• Added Planet, X Coord, and Y Coord fields
  
• Moved all Data and most calculations to a Master Lot Table page (allows for easier updates)
  
• Planet, X Coord, and Y Coord have been added to the Maintenance page
  
• Made the Redeed cost optional
  
• Added a field for Player City Maintenance Tax
  
• Fixed an error with the Current Maintenanace Pool formula
  
• Updated the Redeed formula to use Efficiency IV
  
• Added the Total-Credits w/ Energy per Unit field to the Summary page
  
• Improved the cell copy macro to keep data in sync across the pages
  
• Updated the documentation page to reflect all the changes
  
• Played with the colors again
  
• Added Vendor costs to the Summary page

Great work man.

Props to you for that.

Thanks for all the time you put into that, It helps me out a lot.

Adding a link on the next edition of my guide... Thanks for the great tool.

Happy Holidays All!
I've finished v2.1 of my Lot Management Excel Spreadsheet. I've made a lot of improvements from v2.0 (At least I hope so). You can get v2.1 from http://swg.medievalweapons.net on the Lot Management page. As always, I encourage ANY and ALL feedback. Just post it here or use the feedback form on my site.

---

Update Notes:

• Added the Report, Daily Output, Owners, Vendors, Custom View, and Master Lot Table pages
  
• Changed Spec Rate to Extraction Base Rate
  
• Purchased Energy Cost per Unit is now used on the Summary page
  
• Drop down list for Building Type on the Resource Sales page
  
• Removed some unused name definitions
  
• Efficiency IV is now set by Owner
  
• Owner field added to all versions
  
• Added Planet, X Coord, and Y Coord fields
  
• Moved all Data and most calculations to a Master Lot Table page (allows for easier updates)
  
• Planet, X Coord, and Y Coord have been added to the Maintenance page
  
• Made the Redeed cost optional
  
• Added a field for Player City Maintenance Tax
  
• Fixed an error with the Current Maintenanace Pool formula
  
• Updated the Redeed formula to use Efficiency IV
  
• Added the Total-Credits w/ Energy per Unit field to the Summary page
  
• Improved the cell copy macro to keep data in sync across the pages
  
• Updated the documentation page to reflect all the changes
  
• Played with the colors again
  
• Added Vendor costs to the Summary page

Just when you thought it couldn't get any better than the last one... here comes this!

This spreadsheet has become vital to my business, there is no way i could manage 19 lots without it.

Thanks for the great spreadsheet, and the great improvements!!!

Just switched to the newest version, it is absolutely awesome! Don't know what I'd do without it. Thank you Celdor!

Medman Scott

I fixed a minor bug with the 25, 50, and 100 lot versions yesterday afternoon. If you download the spreadsheet in the morning, you might want to get the fixed version.

Thanks rscott

Thanks for adding me to your awesome guide Draznar!

Thanks for all your hard work! I can't imagine doing without this tool - and now it just go better.

Excellent tool! I will be using this often.

If you have 10+ lots, this thing can help calculate your next visit.

Thank you for making this available to the public!