Star Calculator (Excel spreadsheet)

  • Context: Undergrad 
  • Thread starter Thread starter HerrÅberg
  • Start date Start date
  • Tags Tags
    Calculator Star
Join the discussion
Ask a follow-up here, or get your own question answered by working scientists, mathematicians and engineers — people, not an autocomplete.
Real named experts · corrections over time · the nuance an AI answer skips
2 replies · 7K views
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: