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:

Thread 'Potential biosignature found in Mars rock'

Publication: Redox-driven mineral and organic associations in Jezero Crater, Mars Article: NASA Says Mars Rover Discovered Potential Biosignature Last Year Press conference The ~100 authors don't find a good way this could have formed without life, but also can't rule it out. Now that they have shared their findings with the larger community someone else might find an explanation - or maybe it was actually made by life.
View full post »

Thread 'Does it make sense to build new radio telescopes?'

TL;DR Summary: In 3 years, the Square Kilometre Array (SKA) telescope (or rather, a system of telescopes) should be put into operation. In case of failure to detect alien signals, it will further expand the radius of the so-called silence (or rather, radio silence) of the Universe. Is there any sense in this or is blissful ignorance better? In 3 years, the Square Kilometre Array (SKA) telescope (or rather, a system of telescopes) should be put into operation. In case of failure to detect...
View full post »
Thread 'Could gamma-ray bursts have an intragalactic origin?'

Thread 'Could gamma-ray bursts have an intragalactic origin?'

This is indirectly evidenced by a map of the distribution of gamma-ray bursts in the night sky, made in the form of an elongated globe. And also the weakening of gamma radiation by the disk and the center of the Milky Way, which leads to anisotropy in the possibilities of observing gamma-ray bursts. My line of reasoning is as follows: 1. Gamma radiation should be absorbed to some extent by dust and other components of the interstellar medium. As a result, with an extragalactic origin, fewer...
View full post »

Similar threads

Excel as Analysis Tool and Homework Aid
Replies
7
Views
8K

Hot Threads

Recent Insights

Back
Top