Sarna News: Bad 'Mechs - Icestorm

Difference between revisions of "BattleTechWiki talk:Project Planets"

Line 35: Line 35:
 
:::::::[http://www.mediafire.com/download.php?988r1oaa078vcn5 XLS 97-2003 compatible]-[[User:Volt|Volt]] 19:31, 6 March 2012 (PST)
 
:::::::[http://www.mediafire.com/download.php?988r1oaa078vcn5 XLS 97-2003 compatible]-[[User:Volt|Volt]] 19:31, 6 March 2012 (PST)
 
::::::::Thank you {{Emoticon| :) }} I'm using a version of OpenOffice on my netbook at home, but not on my home desktop. My desktop is getting a little cranky with age, and as it's got all of my video editing software on it I try not to upset it too much, just in case! [[User:BrokenMnemonic|BrokenMnemonic]] 23:32, 6 March 2012 (PST)
 
::::::::Thank you {{Emoticon| :) }} I'm using a version of OpenOffice on my netbook at home, but not on my home desktop. My desktop is getting a little cranky with age, and as it's got all of my video editing software on it I try not to upset it too much, just in case! [[User:BrokenMnemonic|BrokenMnemonic]] 23:32, 6 March 2012 (PST)
 +
:::::::::I've been sitting on a lot of inter-system displacements, and I am not certain if those I have generated are correct (I was apparently using old numbers...?).  Does this file correct these displacements?--[[User:S.gage|S.gage]] 21:09, 7 March 2012 (PST)

Revision as of 01:09, 8 March 2012


I found two more planets for you guys: Siroc and Gwithian. --Neufeld 12:30, 30 August 2011 (UTC)

Also: St. Jean --Neufeld 12:36, 30 August 2011 (UTC)


Hi Guys, how's the renovation coming along? I have sad news, Bad_Syntax stopped working on CBT_Cartographer because he got pissed off at the CBT forum mods. I've decided to continue part of his work (identifying the systems, their coordinates and which faction owns them at a given era) Do you guys think you'd be able to use that data? The coordinates are not canon, and my initial study showed that there are some coordinates that are rather off, (such as Far Reach in RWR) so I hope you guys don't use them yet.

As for the number of systems, based on Oystein's maps from various publications, Syntax and I came up with 3,004 systems with established coordinates, and I'm about 90% done with the faction ownership per era (I actually have 3063 100% complete, with 3067 a close second at 99.93%)

I could use some help with checking the coordinates against the published maps (by comparing the image produced from his CBT_Cartographer and the map to see which systems are in the wrong place), and verification (and filling in the blanks) on the faction ownerships. Drop me a PM in the CBT forums (under "VoltAmpere") if you guys want a copy of my current database (just 1 excel sheet at about 700kB). I'm just waiting for the House Kurita Handbook to fill in the rest of the blanks, but I don't expect to get 100% on all of the eras I'm working on.

Also, I haven't really started with the maps of the founding of each house. -Volt 15:34, 1 October 2011 (UTC)

No Record

Hi Guys, question on Ownership History, does "No Record" mean we have no record IRL, or the system is either undiscovered/abandoned in-universe? -Volt 16:32, 28 February 2012 (PST)

Hy Volt, this indicates we found the planet on no canon map, i hope this helps.--Doneve 16:40, 28 February 2012 (PST)
Copy, thanks Doneve.-Volt 18:09, 28 February 2012 (PST)
Doneve has the right of it - "No record" was a compromise worked out by the team to deal with the situation of not having a planet on the map, but also not having a confirmed founding date for any colony or settlement on the planet. The statement by TPTB that the worlds which show up on maps, particularly Periphery worlds, are simply those worlds worthy of note or of significance and that many other worlds have a human population but aren't important enough to show up led to the problem of a world not appearing on a map being absence of proof, rather than proof of absence. TPTB are tricksy like that! BrokenMnemonic 23:38, 28 February 2012 (PST)

Distances between Planets

I tried to make a matrix that lined up each planet horizontally and vertically then shows the dynamic distance between the two (like the multiplication table). Suffice to say that my laptop crashed after I pasted the formula on the 9,051,072 cells... hooray for technology not evolving fast enough to be able to do what the human mind wants done...-Volt 18:12, 28 February 2012 (PST) Oh and the file shot up from 800kB to 7MB in a matrix of 96 x 3009 systems... guess that's just not practical at this time.-Volt 18:18, 28 February 2012 (PST)

With this much data, you'd probably be better off looking at some sort of customized programme designed to chew through the co-ordinates one system at a time, rather than a spreadsheet... although, you could probably get away with doing it in a spreadsheet, if you did it in stages. I think S.gage was working on producing new tables showing the nearest neighbours for planets and the distances involved, but he was working one planet at a time to keep things manageable. Trying to map 3,009 systems against each other... that's getting into DNA mapping territory ;) BrokenMnemonic 23:47, 28 February 2012 (PST)
I haven't given up :) I'm going to make a dedicated file for the relative distances, just because there isn't one available yet [yes, I got hit by the crazy bus as a kid]-Volt 00:56, 29 February 2012 (PST)
HAHA 125MB!-Volt 18:04, 5 March 2012 (PST)
OK... I'll wait until I get home before downloading that one! Given that Doneve is updating all the owner histories at the moment, I think I'll start adding the nearest neighbours tables tonight using your table of doom. BrokenMnemonic 23:36, 5 March 2012 (PST)
ETA: Sadly, I've only got Office 2003, and that has issues opening the spreadsheet. It can't handle the number of columns, and can't handle the formula in those cells it can see even after running through the MicroSoft file converter :(
Would it be possible to upload a version that has just the values in it (not the formulae) broken down into something like one letter of the alphabet per worksheet for the columns? BrokenMnemonic 11:34, 6 March 2012 (PST)
Hi BM, sure, gimme a couple min to convert and upload it.-Volt 15:14, 6 March 2012 (PST)
Sorry to cut in, guys, but BM: look for and download the opensource OpenOffice.org suite. It stays updated with MS file types and, of course, it's free. I only use MS Office at work now.--Revanche (talk|contribs) 16:28, 6 March 2012 (PST)
Well, for those who have not yet installed OpenOffice, I'm currently uploading the xls 97-2003 compatible version as requested. The file is 150MB so it will take a bit of time to upload. I'll post the link once it's up.-Volt 17:20, 6 March 2012 (PST)
XLS 97-2003 compatible-Volt 19:31, 6 March 2012 (PST)
Thank you Smiley.gif I'm using a version of OpenOffice on my netbook at home, but not on my home desktop. My desktop is getting a little cranky with age, and as it's got all of my video editing software on it I try not to upset it too much, just in case! BrokenMnemonic 23:32, 6 March 2012 (PST)
I've been sitting on a lot of inter-system displacements, and I am not certain if those I have generated are correct (I was apparently using old numbers...?). Does this file correct these displacements?--S.gage 21:09, 7 March 2012 (PST)