Star Calculator (Excel spreadsheet)

  • Thread starter Thread starter HerrÅberg
  • Start date Start date
  • Tags Tags
    Calculator Star
Click For Summary
Kristoffer has created a 15 MB Excel spreadsheet designed to compare star data and is seeking feedback on its functionality. The spreadsheet includes various features such as a search function, HR-diagram, and options to add or edit star data. He has not taken formal astronomy classes and is unsure about the accuracy of the formulas used. Users are cautioned that older computers may experience slow loading times when processing data. Kristoffer assures that the file is virus-free and can be used without enabling macros if preferred.
HerrÅberg
Messages
3
Reaction score
0
Hello my name is Kristoffer and I am new here :)
I have made a spreadsheet in MS Excel to compare star-data and need some help try it out. Testing.
This filesize is about 15 mb (4,5mb zip-packed)

I have not taken any astronomy class or something like that. So I am not 100% sure the formulas I've made (looking them up on the internet) are correct. I have not set any password on thiss spreadsheet, feel free to use it how you want.

I hope you like this sheet.

Screenshot:
http://kumlabunkern.no-ip.com/annat/files/star.jpg

Some of the functions:

> Bayer, Flamesteed, HD, Propper names included
> Search function
> Compare star data
> HR-diagram
> Downscale distances
> Travel to the stars function
> Move stars function
> Add star to database function
> Edit database

- Bayer/Flamesteed Name
- Short name
- HD catalogue name
- Variable
- Binary
- Visible Magnitude
- Distance
- Right Accencion
- Declination
- Spectral type(s)
- Absolute Magnitude
- Bolometric Magnitude
- Absolute Visual Magnitude
- Luminosity
- Bolometric Luminosity
- Color/Startype
- Mass
- Radii
- Volume
- B-V Color index

Some known problems:

If you have an old computer you can suffer some loadingtimes when calculating all data.

URL: http://kumlabunkern.no-ip.com/annat/files/star_calculator_2.0.zip
 
Last edited by a moderator:
Astronomy news on Phys.org
How about a link to a page which doesn't download something? What if the zip file is a virus? Can we trust you?
 
That link goes to my personal webserver @ http://kumlabunkern.no-ip.com/annat/
There is no virus in the file. Its a spreadsheet compressed as a zip-file. You can trust me :)
The file contains some macros, for sorting constellations, adding stars etc
If you don't want the macros, you can just turn it off.
But as I said, no viruses!
// Kristoffer Åberg, Kumla, Sweden
 
Last edited by a moderator:
UC Berkely, December 16, 2025 https://news.berkeley.edu/2025/12/16/whats-powering-these-mysterious-bright-blue-cosmic-flashes-astronomers-find-a-clue/ AT 2024wpp, a luminous fast blue optical transient, or LFBOT, is the bright blue spot at the upper right edge of its host galaxy, which is 1.1 billion light-years from Earth in (or near) a galaxy far, far away. Such objects are very bright (obiously) and very energetic. The article indicates that AT 2024wpp had a peak luminosity of 2-4 x...

Similar threads

  • · Replies 7 ·
Replies
7
Views
8K