Posts

Showing posts from December, 2024

Make Holidays Easy: Exploring the US Federal Holidays Year Spreadsheet

Image
  Saving Time with the US Federal Holidays Year Spreadsheet - Here's How! The US Federal Holidays Year Spreadsheet is a tool designed to quickly calculate the dates of federal holidays. Simply input the year in cell C2, and the dates will automatically update. There are 11 federal holidays in the USA. Image of the actual spreadsheet DEMO From Spreadsheet to JSON: Streamlining Federal Holiday Dates for Programmers This spreadsheet is also useful for programmers to generate data in JSON format, functioning like an API. Use the link provided to get the data. Please do not use the link directly in your web or app projects. Image of the actual data This spreadsheet is free for a limited time and can be copied instantly via my Gumroad shop .

Calculate Liturgical Dates in Seconds with This Spreadsheet!

Image
Hello! Here is a new spreadsheet designed to help you determine the dates of events in the liturgical calendar. This tool provides the necessary calculations for each event using the Golden Number year.  Image of the actual spreadsheet The spreadsheet includes three sheets: The main sheet is named "Sheet1." Two additional sheets that can be hidden. Demo video Main image How to Use the Spreadsheet Get Your Free Copy :  Use this link to copy the spreadsheet from my Gumroad shop. You will be prompted to make a copy. Enter the Year: On your copy, find cell C2 highlighted in yellow . This is the only cell where you need to enter the year. Automatic Update: Enter the year, and the spreadsheet will automatically update the dates. You can use any year from 1900 to 9998 . For Developers If you are a developer and need data in JSON array format, use this , which generates the data in a read-only API. Feel free to generate as much data as you need, but please do not use the provided...

Screen & Scan: Your Ultimate Stock Filtering Spreadsheet πŸ“Š

Image
Screen & Scan: Your Ultimate Stock Filtering Spreadsheet πŸ“Š Image of the actual spreadsheet If you're looking for a simple and easy-to-use stock screener or scanner, you've come to the right place! Though they might be called different names, both tools share the same objective: to filter a list of stocks based on one or multiple criteria. What's the Difference? πŸ€” Imagine you have a list of 100 stocks in no particular order and want to find the top 20 based on their trading price. A screener and a scanner will provide you with this list of 20 stocks. However, the scanner will go a step further and rank them for you. Introducing My Spreadsheet πŸ“ˆ I made this spreadsheet that can function as both a scanner and a screener. This tool allows you to input your stock database and filter the data based on criteria such as as volume and price. Here’s how you can use it: Input Your Stock Data : In the β€œstocks_db” sheet, enter the ticker name or symbol. If the ticker already exis...