Light vision Illumination Generator Tool (Excel)

Last edited by wolph42 on Mon Nov 16, 2009 11:04 am, edited 8 times in total.

Edit: for link see end of this post or attached excel file.

I've noticed that you can do some pretty neat stuff with the light source settings in MT (thumbs up for the devs!) and I was wondering whether anyone has (or knows of) creative settings who wants to share these...?

for example a yellow torch light has a conish long shape but in the vicinity you have a broader cone due to dispersion, which you can emulate by:
Torch light - 12 : cone arc=60 8#baa400 cone arc=120 3#615000 cone arc=60 12#615000

Or a yellow fading camplight:
campfire -20 : 1#ffc400 2#f2ba00 3#e4af00 4#d7a500 5#c99b00 6#bc9000 7#ae8600 8#a17c00 9#947100 10#866700 11#795d00 12#6b5300 13#5e4800 14#513e00 15#433400 16#362900 17#281f00 18#1b1500 19#0d0a00 20#000000

Or a really funky lamp with light that disperses in distance and in angle:
Lamp - 10 : cone arc=40 1#F2BA00 cone arc=40 2#D7A500 cone arc=40 3#BC9000 cone arc=40 4#A17C00 cone arc=40 5#866700 cone arc=40 6#6B5300 cone arc=40 7#513E00 cone arc=40 8#362900 cone arc=40 9#1B1500 cone arc=40 10#000000 cone arc=45 1#D7A500 cone arc=45 2#BC9000 cone arc=45 3#A17C00 cone arc=45 4#866700 cone arc=45 5#6B5300 cone arc=45 6#513E00 cone arc=45 7#362900 cone arc=45 8#1B1500 cone arc=45 9#000000 cone arc=50 1#BC9000 cone arc=50 2#A17C00 cone arc=50 3#866700 cone arc=50 4#6B5300 cone arc=50 5#513E00 cone arc=50 6#362900 cone arc=50 7#1B1500 cone arc=50 8#000000 cone arc=55 1#A17C00 cone arc=55 2#866700 cone arc=55 3#6B5300 cone arc=55 4#513E00 cone arc=55 5#362900 cone arc=55 6#1B1500 cone arc=55 7#000000 cone arc=60 1#866700 cone arc=60 2#6B5300 cone arc=60 3#513E00 cone arc=60 4#362900 cone arc=60 5#1B1500 cone arc=60 6#000000 cone arc=60 1#6B5300 cone arc=60 2#513E00 cone arc=60 3#362900 cone arc=60 4#1B1500 cone arc=60 5#000000 cone arc=65 1#513E00 cone arc=65 2#362900 cone arc=65 3#1B1500 cone arc=65 4#000000 cone arc=70 1#362900 cone arc=70 2#1B1500 cone arc=70 3#000000 cone arc=75 1#1B1500 cone arc=75 2#000000 cone arc=75 1#000000

Edit: screenshot of normal light with angle and the funky lamp:

screenshot of normal campfire and 'yellow fading campfire':

Edit:
Humbly submitting the Light Source Gradient calculator :
http://spreadsheets.google.com/ccc?key= ... VeHc&hl=en

Attached is an excelsheet that should work with open office as well.

Wow, I had no idea you could set more than two colors/zones! Have you stress tested any of these? is there any slowdown under normal conditions?

I would say copy paste it

and you'll know...

but yes it slows the lot down, not significantly though. If you equip a token with the funky lamp and you start turning the facing of the token it responds with some lag (at least on my pc here).

I would guess though that if you create a room with round VBL's and then put lamps around the place with these settings, that that will impact the interaction significantly...

In case your wondering, the funky lamp is layered as follows:

1 being the first entry and 9 the last entry in the light 'string'.
The funky lamp has 57 grades: first cone (arc=40) contains 10 layers, the next (arc=45) contains 9 layers,....downto a single bottom layer (arc=70).

That's pretty darned awesome. Too bad it's so slow!

Due to the lack of response I'm guessing that I'm one of the very few that has experimented with this. So here are my current light settings, not so funky as the funky lamp, but still a lot nicer then the 'standard' lamps. My advice is to use the Standard lamps in maps with buildings with a lot of light and vbl and the others for the players or maps with little light (i.e. forest, dungeon, open field, ruins , etc.)

Code:

Standard
----
3 : 3 
20 : 20 
15 : 15 
50 : 50 
5 : 5 
10 : 10 
30 : 30 

Primitive Illumination
----
Lamp - 8 : 1#f2ba00 2#d7a500 3#bc9000 4#a17c00 5#866700 6#6b5300 7#362900 8#000000 
Lantern - 15 : cone arc=60 1#f2ba00 cone arc=60 3#d7a500 cone arc=60 4#bc9000 cone arc=60 6#a17c00 cone arc=60 7#866700 cone arc=60 9#6b5300 cone arc=60 10#513e00 cone arc=60 13#362900 cone arc=60 14#1b1500 cone arc=60 15#000000 
Match - 3 : 1#6b5300 2#362900 3#000000 
Torch - 10 : 1#f2ba00 2#d7a500 3#bc9000 4#a17c00 5#866700 6#6b5300 7#513e00 8#362900 9#1b1500 10#000000 
Campfire - 20 : 1#ffc400 2#f2ba00 3#e4af00 4#d7a500 5#c99b00 6#bc9000 7#ae8600 8#a17c00 9#947100 10#866700 11#795d00 12#6b5300 13#5e4800 14#513e00 15#433400 16#362900 17#281f00 18#1b1500 19#0d0a00 20#000000 
Candle - 6 : 1#a17c00 2#6b5300 3#513e00 4#362900 5#1b1500 6#000000 

Modern Illumination
----
Shoulder Lantern - 30 cone : cone arc=60 1#ffc400 cone arc=60 2#f2ba00 cone arc=60 4#e4af00 cone arc=60 5#d7a500 cone arc=60 7#c99b00 cone arc=60 8#bc9000 cone arc=60 10#ae8600 cone arc=60 11#a17c00 cone arc=60 13#947100 cone arc=60 14#866700 cone arc=60 16#795d00 cone arc=60 17#6b5300 cone arc=60 19#5e4800 cone arc=60 20#513e00 cone arc=60 21#433400 cone arc=60 22#362900 cone arc=60 24#281f00 cone arc=60 25#1b1500 cone arc=60 27#0d0a00 cone arc=60 30#000000 
Large Torch Light - 20 cone : cone arc=45 1#ffc400 cone arc=45 2#f2ba00 cone arc=45 3#e4af00 cone arc=45 4#d7a500 cone arc=45 5#c99b00 cone arc=45 6#bc9000 cone arc=45 7#ae8600 cone arc=45 8#a17c00 cone arc=45 9#947100 cone arc=45 10#866700 cone arc=45 11#795d00 cone arc=45 12#6b5300 cone arc=45 13#5e4800 cone arc=45 14#513e00 cone arc=45 15#433400 cone arc=45 16#362900 cone arc=45 17#281f00 cone arc=45 18#1b1500 cone arc=45 19#0d0a00 cone arc=45 20#000000 
Pocket Light - 15 narrow cone : cone arc=20 1#bc9000 cone arc=20 2#ae8600 cone arc=20 3#a17c00 cone arc=20 4#947100 cone arc=20 5#866700 cone arc=20 6#795d00 cone arc=20 7#6b5300 cone arc=20 8#5e4800 cone arc=20 9#513e00 cone arc=20 10#433400 cone arc=20 11#362900 cone arc=20 12#281f00 cone arc=20 13#1b1500 cone arc=20 14#0d0a00 cone arc=20 15#000000 
Small Torch Light - 15 cone : cone arc=45 1#bc9000 cone arc=45 2#ae8600 cone arc=45 3#a17c00 cone arc=45 4#947100 cone arc=45 5#866700 cone arc=45 6#795d00 cone arc=45 7#6b5300 cone arc=45 8#5e4800 cone arc=45 9#513e00 cone arc=45 10#433400 cone arc=45 11#362900 cone arc=45 12#281f00 cone arc=45 13#1b1500 cone arc=45 14#0d0a00 cone arc=45 15#000000 
Open Lamp - 15 circle : 1#f2ba00 3#d7a500 4#bc9000 6#a17c00 7#866700 9#6b5300 10#513e00 13#362900 14#1b1500 15#000000 

and more to be added: here a trick to toggle range for weapons on or off. First you need to create some auras:

Code:

Ranges
----
Range 50s : aura cone arc=45 25#800000 
Range 100 : aura cone arc=45 100#aa0000 
Range 50l : aura cone arc=45 100#ff0000 
Range 20l : aura cone arc=45 40#ff0000 
Range 60 : aura cone arc=45 60#aa0000 
Range 30s : aura cone arc=45 15#800000 
Range 100s : aura cone arc=45 50#800000 
Range 300s : aura cone arc=45 150#800000 
Range 50 : aura cone arc=45 50#aa0000 
Range 20s : aura cone arc=45 10#800000 
Range 150l : aura cone arc=45 300#ff0000 
Range 60l : aura cone arc=45 120#ff0000 
Range 180l : aura cone arc=45 360#ff0000 
Range 180s : aura cone arc=45 90#800000 
Range 30l : aura cone arc=45 60#ff0000 
Range 10l : aura cone arc=45 20#ff0000 
Range 60s : aura cone arc=45 30#800000 
Range 120s : aura cone arc=45 60#800000 
Range 15 : aura cone arc=45 15#aa0000 
Range 15l : aura cone arc=45 30#ff0000 
Range 10s : aura cone arc=45 5#800000 
Range 100l : aura cone arc=45 200#ff0000 
Range 90s : aura cone arc=45 45#800000 
Range 10 : aura cone arc=45 10#aa0000 
Range 150 : aura cone arc=45 150#aa0000 
Range 150s : aura cone arc=45 75#800000 
Range 180 : aura cone arc=45 180#aa0000 
Range 20 : aura cone arc=45 20#aa0000 
Range 300l : aura cone arc=45 600#ff0000 
Range 300 : aura cone arc=45 300#aa0000 
Range 90 : aura cone arc=45 90#aa0000 
Range 35s : aura cone arc=45 18#800000 
Range 90l : aura cone arc=45 180#ff0000 
Range 35l : aura cone arc=45 70#ff0000 
Range 15s : aura cone arc=45 8#800000 
Range 120 : aura cone arc=45 120#aa0000 
Range 35 : aura cone arc=45 35#aa0000 
Range 30 : aura cone arc=45 30#aa0000 
Range 120l : aura cone arc=45 240#ff0000 

these settings are for dark heresy and actually use 3 ranges (short [x1/2], normal [x1] and long [x2]) but can be set for all systems obviously. You can use excel to create these settings fast:
Put in cell A1, A2, A3 the ranges you wish to set and in B1, B2, B3 the following formula:

Code:

="Range "&A1&" : aura cone arc=45 "&A1&"#aa0000"&CHAR(10)&"Range "&A1&"s : aura cone arc=45 "&ROUND(A1/2;0)&"#800000"&CHAR(10)&"Range "&A1&"l : aura cone arc=45 "&2*A1&"#ff0000"

Then create a macro called "toggle range":

Code:

[h:Range = json.get(PrimaryWeapon, "Range")]
[r,if(Range=="" || Range==0):"Doesn't carry ranged weapon";"Range = "+Range]<br>
[h, if(hasLightSource("Ranges", "Range "+Range)), CODE:{
   [h: setLight("Ranges", "Range "+Range, 0)]
   [h: setLight("Ranges", "Range "+Range+"s", 0)]
   [h: setLight("Ranges", "Range "+Range+"l", 0)]
   };{
   [h: setLight("Ranges", "Range "+Range, 1)]
   [h: setLight("Ranges", "Range "+Range+"s", 1)]
   [h: setLight("Ranges", "Range "+Range+"l", 1)]
}]

et voila. You can now toggle the range of the weapons.

Note that I get my range from a json object, but you can also create the property "Range" in the token and remove the first line of code.

This is very interesting stuff!

I don't mean to look a gift horse in the mouth

, but can you post some screen shots so I can get an idea of what you're accomplishing with these weapon range entries? Obviously I could copy/paste them into an empty campaign, but I have no way to even know if what I end up with is what you're seeing on your screen... Thanks.

well... you asked for it...

never pass an opportunity to pull someones leg

. You're Dutch by any chance or is this proverb used in other countries as well?

anyway:
Toggle on:

This is a range 10 weapon, char. gets +10% chance to hit on half range (5) and -10% chance to hit on long range (2x=20).

Toggle off:

Obviously you can also use circle in stead of cone, but this looks cooler and as I happen to make this for Dark Heresy and as it happens there is also an 'surpressin fire' action which happens to be with an angle of 45 degr. I can hit two flies in one blow

Also added some screenshots in the first post

Wow. Must say this is pretty amazing stuff.
Shame it can't be optimised, but at least we got it!
The fading campfire does look pretty darn stonking

May have to copy paste some of those.
Though I guess making them from scratch is rather tedious at least if not confusing...

Mal

It took me roughly half an hour to create all the light source. The trick is to use excel

I'm curious as to how you figured out the colors for the gradient steps - is there a way of doing it automatically, or did you eyeball it on a color wheel or something?

wolph42 wrote:

well... you asked for it...

Well, actually I didn't, but that's okay.

Quote:

never pass an opportunity to pull someones leg

. You're Dutch by any chance or is this proverb used in other countries as well?

Nope, pretty common saying here in the States.

Quote:

Toggle on:

Excellent! Yep, that's what I was looking for. And that image has inspired me to copy/paste some of what you've got for use in my PF campaign. It would be very handy for the archers with Point Blank Shot, and I can also see having such things for the spellcasters who have spell ranges based on their levels (although it means 10 different entries).

Thanks again!

attached is an excelsheet (that will work in google docs if necessary. in there there is a tab Auras light build.
-Enter the ranges in there
-(adjust short & long ranges if necessary in the formulas)
- copy paste it into a text file
- search and replace " for nothing
- copy paste result into light settings

piece a cake

its also a common saying in Dutch (then again Holland is part of the history of the US and the proverb is ancient)

This is very cool, unfortunately I don't see your attached XLS sheet, which is a shame cause I'd like to get this to work for other colours as well.

Could you just upload a copy to Google Docs and share it publicly?

RPTools.net

Forum rules

Light vision Illumination Generator Tool (Excel)

Who is online

Top

Top

Top

Top