Star Calculator (Excel spreadsheet)

  • Context: Undergrad 
  • Thread starter Thread starter HerrÅberg
  • Start date Start date
  • Tags Tags
    Calculator Star
Click For Summary
SUMMARY

The discussion centers around a star data comparison spreadsheet created by Kristoffer Åberg using MS Excel. The spreadsheet, approximately 15 MB in size (4.5 MB when zipped), includes various astronomical functions such as a search function, HR-diagram, and the ability to add and edit star data. Users are encouraged to utilize the spreadsheet without any password protection, although it contains macros for enhanced functionality. Kristoffer acknowledges potential loading issues on older computers when processing extensive data.

PREREQUISITES
  • Basic understanding of MS Excel functionalities
  • Familiarity with astronomical terms such as Bayer and Flamesteed designations
  • Knowledge of Excel macros and how to enable or disable them
  • Understanding of star data metrics like visible magnitude and spectral types
NEXT STEPS
  • Explore advanced Excel functions for data analysis
  • Learn about astronomical data processing techniques
  • Investigate Excel macro security settings and best practices
  • Research the HR-diagram and its significance in astronomy
USEFUL FOR

Astronomy enthusiasts, Excel users interested in data analysis, and anyone looking to compare and manipulate star data effectively.

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:

Similar threads

  • · Replies 1 ·
Replies
1
Views
2K
  • · Replies 4 ·
Replies
4
Views
4K
  • · Replies 3 ·
Replies
3
Views
3K
  • · Replies 7 ·
Replies
7
Views
8K