• find_the_beep

    Description

    The objective of Find The Beep is to create a dynamic grid where letters “B”, “E”, and “P” are placed randomly, while avoiding the word “BEEP”.

    Inspiration

    This was inspired by the book

    Find the Fox: An Almost Impossible Word Search by Alex Cheddar.

    The book presents a unique 240-page word search using only the letters F, O, and X, where the only word present is “FOX”. The challenge and creativity in reducing the puzzle to three letters and one word inspired me to create a similar minimalist puzzle concept with “BEEP.”

    Usage

    1. Open the webpage.
    2. Enter the desired number of rows and columns (minimum 4×4).
    3. Click “go” to generate the grid.
    4. Observe the grid ensuring no BEEPs are formed.

    Project Origins

    My original version of Find The Beep was created using Python. I developed an Excel-based solver with VBA to scan and ensure that the sequence “BEEP” never appeared in the generated grids. The transition to JavaScript allowed me to bring this to the web, where users can interactively create grids and visualize the results.

    PYTHON find_the_python.txt

    VBA find_the_vba.txt

    Code Method

    • Grid Generation: Dynamically creates grids based on user input.
    • Conflict Avoidance: Utilizes directional checks to prevent specific sequences.
    • Retry Mechanism: Automatically retries generation if conflicts arise.

    HTML FindTheBeep.html

    Bonus:

    HTML FindTheTax.html

  • excel_combi

    VBA macro combines multiple Excel files from a selected folder into a single workbook, seperated as tabs.

    VBA combine_files.txt

  • bionic_vba_converter

    Bionic Document Converter – use VBA to apply the Bionic Reading technique to selected text in documents.

    VBA bionic_VBA.txt

  • barcode_generation

    Easily convert data to barcode. Note: file requires Fre3of9x Font

    Basically, whatever you scan or type into column A will be in text format (to reduce Excel’s unwanted automation of converting data to number) and have conditional formatting to highlight duplicates. You’ll then press the magic button and barcodes will be generated in column B. Delete data from column A and press the button again, and all barcodes will disappear too. This makes data barcode ready by inserting asterisks before and after data, then applying font changes

    CODE sub_apply_formula.txt

    README barcode_vba_README.txt

    FONT font_Fre3of9x

  • 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