Architect Archive

Thread: NEW Lot Management Spreadsheet!

Shadow-Light
Thu Oct 30, 2003 8:57 am
#1

Hello fellow Artisans! I have just completed the latest version of my Lot Management Excel Spreadsheet. It has many requested features such as Potential Energy and Experimented Hopper Sizes. You can download it from http://swg.medievalweapons.net. If you want to leave me feedback about this, just post it here.
Update Notes:

  • MAJOR Rework of all aspects of this sheet
  • Potential Energy is now handled
  • Experimentation on the Spec Rate and Hopper Size is dealt with
  • Other daily costs (such as rent) now has a field
  • Purchased power and Efficiency IV are handled
  • New page layouts and colors
  • New macros to manage Building Type, %, and Description
  • Time and Date stamp buttons
  • Improved a lot of the initial formulas to be simpler
  • Should have removed all DIV/0 error conditions




Need a great lot management tool? v2.1 is at http://swg.medievalweapons.net
Shadow-Light
Thu Oct 30, 2003 8:58 am
#2

Hello fellow Merchants! I have just completed the latest version of my Lot Management Excel Spreadsheet. It has many requested features such as Potential Energy and Experimented Hopper Sizes. You can download it from http://swg.medievalweapons.net. If you want to leave me feedback about this, just post it here.
Update Notes:

  • MAJOR Rework of all aspects of this sheet
  • Potential Energy is now handled
  • Experimentation on the Spec Rate and Hopper Size is dealt with
  • Other daily costs (such as rent) now has a field
  • Purchased power and Efficiency IV are handled
  • New page layouts and colors
  • New macros to manage Building Type, %, and Description
  • Time and Date stamp buttons
  • Improved a lot of the initial formulas to be simpler
  • Should have removed all DIV/0 error conditions




Need a great lot management tool? v2.1 is at http://swg.medievalweapons.net
LordMaxx
Thu Oct 30, 2003 9:14 am
#3

This is a great tool! Ive been using it for a while now...thanks for the update!



Maxx Wolfe
"I...I...I...I...Im not your steppin' stone!" - The Monkees
Leader of Team Desert Eagle and Founder of PATGWNIWNU a offshoot of RATGWNIWNU!
Chilastra/Valcyn/TC
Shadow-Light
Thu Oct 30, 2003 10:46 am
#4

Hello Architects! I have just completed the latest version of my Lot Management Excel Spreadsheet. It has many requested features such as Potential Energy and Experimented Hopper Sizes. You can download it from http://swg.medievalweapons.net. If you want to leave me feedback about this, just post it here.
Update Notes:

  • MAJOR Rework of all aspects of this sheet
  • Potential Energy is now handled
  • Experimentation on the Spec Rate and Hopper Size is dealt with
  • Other daily costs (such as rent) now has a field
  • Purchased power and Efficiency IV are handled
  • New page layouts and colors
  • New macros to manage Building Type, %, and Description
  • Time and Date stamp buttons
  • Improved a lot of the initial formulas to be simpler
  • Should have removed all DIV/0 error conditions




Need a great lot management tool? v2.1 is at http://swg.medievalweapons.net
Shadow-Light
Thu Oct 30, 2003 10:53 am
#5

Hello all! I have just completed the latest version of my Lot Management Excel Spreadsheet. It has many requested features such as Potential Energy and Experimented Hopper Sizes. You can download it from http://swg.medievalweapons.net. If you want to leave me feedback about this, just post it here.
Update Notes:

  • MAJOR Rework of all aspects of this sheet
  • Potential Energy is now handled
  • Experimentation on the Spec Rate and Hopper Size is dealt with
  • Other daily costs (such as rent) now has a field
  • Purchased power and Efficiency IV are handled
  • New page layouts and colors
  • New macros to manage Building Type, %, and Description
  • Time and Date stamp buttons
  • Improved a lot of the initial formulas to be simpler
  • Should have removed all DIV/0 error conditions




Need a great lot management tool? v2.1 is at http://swg.medievalweapons.net
Stockbridge100
Thu Oct 30, 2003 11:04 am
#6

/cheer
TAfirehawk
Thu Oct 30, 2003 11:04 am
#7

All hail Shadow-Light!!!!!



I use this constantly and what an amazing tool this is to people like me that manage an entire PA's harvesters.



/tip 1,000,000




Iebas Feania
Former Correspondent of the Former Profession, CARBINEER

GDI
Thu Oct 30, 2003 11:17 am
#8

Curses! I can't find a way to break it!



-------------------------------------
Galowen Darkmorn - Chilastra
Expert Armorsmith, Master of Armor Design, Deflector Technologist
Master Artisan, Novice Creature Handler
Head of GDI (Galowen Darkmorn Industries)
GotEgg
Thu Oct 30, 2003 11:22 am
#9

I'm in awe... This is simply amazing!


Thanks for the great tool!!





Venxen Rehq :: Master Swordsman | Master Brawler | Master Loot Monkey

Veho Rehq :: Master Fencer | Master Doctor | Master FOTM'er

R.I.P Rruhg :: Master Bio-Engineer | Master Doctor

DVader539
Thu Oct 30, 2003 11:27 am
#10

/bowdown

All hail Shadow-Light, he who dances with Excel



Click here for proof that the Devs hate Riflemen. And here's the kicker! (Seperate thread)
Making a controversial point: Ignored
Making a good controversial point: Locked
Making a great controversial point no one can argue: Thread Deleted
There are few things you can post, for everything else, there's a CSR waiting.

Phomeister
Thu Oct 30, 2003 11:34 am
#11

Thats kinda neat! Good job!
JDaneel
Thu Oct 30, 2003 11:51 am
#12

Thank you Shadow. One of the best tools around.



JDaneel Mining - Twi'leks Dig It!!!
Lowca's Largest Mining Operation
Two Million Units of Minerals Mined Per Day
Located in the Commodities Exchange Building next to the Helfire, Lok Shuttleport

Shadow-Light
Thu Oct 30, 2003 11:57 am
#13






DVader539 wrote:
/bowdown

All hail Shadow-Light, he who dances with Excel




I'm still laughing about that line DVader539! Glad you like it.




Need a great lot management tool? v2.1 is at http://swg.medievalweapons.net
Page 1 of 6
Previous Next