Star Calculator (Excel spreadsheet)

  • Thread starter Thread starter HerrÅberg
  • Start date Start date
  • Tags Tags
    Calculator Star
AI Thread 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:
This thread is dedicated to the beauty and awesomeness of our Universe. If you feel like it, please share video clips and photos (or nice animations) of space and objects in space in this thread. Your posts, clips and photos may by all means include scientific information; that does not make it less beautiful to me (n.b. the posts must of course comply with the PF guidelines, i.e. regarding science, only mainstream science is allowed, fringe/pseudoscience is not allowed). n.b. I start this...
Asteroid, Data - 1.2% risk of an impact on December 22, 2032. The estimated diameter is 55 m and an impact would likely release an energy of 8 megatons of TNT equivalent, although these numbers have a large uncertainty - it could also be 1 or 100 megatons. Currently the object has level 3 on the Torino scale, the second-highest ever (after Apophis) and only the third object to exceed level 1. Most likely it will miss, and if it hits then most likely it'll hit an ocean and be harmless, but...

Similar threads

Replies
7
Views
8K
Back
Top