Bionic Document Converter – use VBA to apply the Bionic Reading technique to selected text in documents.
VBA bionic_VBA.txt
-
destiny_v2.0
** Version Two ** – For armour comparison on Bungie’s Destiny 2 – This Python script reads the data from a text file called data.txt containing the stats for your different armours. It then finds the best combinations of sets and prints the top five combinations along with their results.
-
buy_low_sell_high
Attempt Two – Python code that allows users to analyse historical stock price data using the yfinance library. The code calculates the start and end dates for the desired historical data. It sets the end date as the current date using datetime.date.today(), and the start date as six months prior to the end date using datetime.timedelta(days=6 * 30). Using the yf.download() function from the yfinance library, the code attempts to fetch the historical price data and proceeds to calculate the weekly high and low prices using the resample() function on the close prices.
The resulting weekly highs and lows are stored in separate variables. The code retrieves the current week’s high and low prices by accessing the last elements of the weekly highs and lows arrays.
Next, the code calculates the average percentage difference between the high and low prices for each week. It subtracts the lows from the highs, divides the result by the lows, and multiplies by 100.The average of these percentage differences is stored in the avg_percentage_diff variable. The code retrieves the current share price, the highest price for the current week, and the lowest price for the current week. It then calculates values based on the average percentage increase and decrease difference.
The theory is that regardless of shares going up or down, I should be able to ‘predict’ the short increases and decreases along its path.
PYTHONshares.txt
-
killer_sudoku.py
Python script to assist with solving Killer Sudokus.
The code presents a menu-driven program with three options:Cage Overlap (Option A) allows the user to calculate the split value of a cage overlapping two boxes (N and A) based on a given total value (N) and what must remain for the remaining cage.
____________________ _________ ____ | | N ||B || | || || | ||___|| | |_____|____ | | A | |______________|____| |Cage Combinations (Option B): This option allows the user to generate all possible combinations of numbers (from 1 to 9) that add up to a given total and have a specific area.
Calculator (Option C): This option provides a basic calculator functionality. The user can input arithmetic expressions in the format “number1 + number2” or “number1 – number2” and get the corresponding result.
The program keeps running until the user chooses to return to the main menu by entering “0” as their input. It ensures that the inputs are validated and provides appropriate feedback and error handling.
Overall, this code offers a simple interactive environment for cage-related calculations and basic arithmetic operations
PYTHONkiller_sudoku.txt
-
amazon_price_scraper_excel
Microsoft Visual Basic for Applications – Tools – References – enable Microsoft XML, v6.0
Add Module –Excel – copy Amazon product link to cell
Excel – formula – amazon_price(refer to link cell)VBA Module_pricechecker.txt
-
no_man\’s_sky_resources_planner
Simply enter how many of which building blocks you desire to generate a shopping list of resources required to fulfil the build. This was unfinished as not all building blocks have been entered into the data tab.
Requires basic Excel knowledge.
I did also attempt to calculate power requirements, but there are a lot of unknowns and the amount of power you can generate has too many outside variables.
Also includes bonus Craft tab listing all resource recipes should you find yourself short on anything
EXCEL NMSresourcesPlanner.xlsx
-
destiny2
Bungies Destiny 2 armour combination calculator, not fully user friendly yet so requires basic Excel knowledge. As highest armour is not always the best due to anything under ten is dropped, so having the correct combination is key. Excel sheet – basically, tabs house all armour type stats, additional tab then uses filters to determine the best combination.
EXCEL Destiny.xlsx
-
animal_crossing_excel_workbook
Animal Crossing New Horizons Excel workbook, garden planning, villager combination planner, and effective Bell farming by season
EXCEL Animal Crossing.xlsx
-
DHT11 != SSD1306
Just in case you lot are struggling to get a skittish DHT11 to cope with a ridiculously stubborn SSD1306 using Micropython… which is basically Python but with a Dissociative identity disorder. Here is the solution –
PYTHON ssd1306.txt
-
python_mouse_detect
Mouse pointer location display – run by Python but distributed as MouseDetect Application (.exe)
EXE MouseDetect.zip
-
python_dungeon
Not coming to an Xbox near you: Python Dungeon!
A really good game, except without the ‘really good’ part and not much of a ‘game’ really… anyway
