Jump to content

  •  

CNers have asked about a donation box for Cloudy Nights over the years, so here you go. Donation is not required by any means, so please enjoy your stay.

Photo

Excel Worksheet for tracking Exposure History

Software Astrophotography Imaging Observing Report
  • Please log in to reply
3 replies to this topic

#1 captainles59

captainles59

    Explorer 1

  • *****
  • topic starter
  • Posts: 70
  • Joined: 04 Jun 2020
  • Loc: Lithia (Tampa Bay), FL, 33547

Posted 09 May 2024 - 11:10 AM

Hey all, this is for anyone interested in tracking their exposure times and willing to test or use this work sheet approach.

 

The idea is to copy the file path names for each night with a given target and paste into a tab of the worksheet.

 

The work sheet parses the path and file name data to get info like  filter names and exposure times.

 

Then it produces a table like image below with a summary of the times and frames for each filter.

 

file total Screenshot 2024 05 09 114814

 

You can also use the summaries to make folder names to track your exposures.

 

Examples:

 

Between 04-23 & 2024-05-07;  1.8 hrs L, 1.5 hrs R, 1.5 hrs G, 1.3 hrs B, Total = 6.8 hours.

As of 2024-05-07,  total = 6.8 hours exposure   69 Total Frames.

 

Here is a link to the worksheet file loaded with a few nights of my Herculese Galaxy Cluster imaging as an example.

 

To use this worksheet you need a little excell experience to block, copy and paste data.  It will help if you understand the idea of concatenation but the parsing of data is pretty easy.  Look first at the information tab to get directions.

 

File link to GoogleDrive :

 

https://drive.google...iew?usp=sharing

 

I also have a package available for creating a horizon line useful in Stellarium and NINA

 

Note, I have no commercial interest just a service for all if useful and I appreciate feedback for improvements.

 

enjoy!



#2 captainles59

captainles59

    Explorer 1

  • *****
  • topic starter
  • Posts: 70
  • Joined: 04 Jun 2020
  • Loc: Lithia (Tampa Bay), FL, 33547

Posted 13 May 2024 - 09:35 AM

Hi to anyone interested.  Here is an update to the FrameCounter worksheet now V6.

 

https://drive.google...iew?usp=sharing

 

Rgds,

 

Les



#3 BrandonParre

BrandonParre

    Lift Off

  • -----
  • Posts: 2
  • Joined: 07 Mar 2023

Posted 16 February 2025 - 02:41 PM

I can imagine how much more organized and efficient this would make the whole process. I’ve used something similar to track different data sets for work, and I’ve found that breaking it down into steps and automating the parsing really helps. One thing I found helpful was setting up custom formulas in Excel to sort and filter the data as I entered it – saved me tons of time!If you’re just getting into this kind of data tracking and looking to improve your Excel skills, https://excel.tv/best-excel-courses/ has some great courses that dive into these kinds of techniques and more.



#4 captainles59

captainles59

    Explorer 1

  • *****
  • topic starter
  • Posts: 70
  • Joined: 04 Jun 2020
  • Loc: Lithia (Tampa Bay), FL, 33547

Posted 10 March 2025 - 09:05 AM

Thanks, will take a look.




CNers have asked about a donation box for Cloudy Nights over the years, so here you go. Donation is not required by any means, so please enjoy your stay.


Recent Topics





Also tagged with one or more of these keywords: Software, Astrophotography, Imaging, Observing Report



Cloudy Nights LLC
Cloudy Nights Sponsor: Astronomics