🧮 Abacus Generator – An Easy Tool for Beginners in Mental Arithmetic

If you’re just starting out with mental arithmetic, you’ve probably realized how important it is to have clear and organized number examples. That’s exactly why I created the Abacus Generator – a simple yet powerful tool in Excel that helps you prepare number tasks in a neat and easy-to-read format.

📌 What is it?
The Abacus Generator is a VBA script (built into Excel) that automatically creates a table with groups of three numbers arranged vertically, just like the tasks you’d find when working with an abacus. The focus of this tool is to generate printable worksheets for abacus exercises with just one click.

👶 Why is it perfect for beginners?

  • You don’t need to know any programming – just click a button, and it does everything for you.
  • It arranges the numbers in up to 10 columns per row, making it easy to view and print.
  • It works right inside a regular Excel file – no need for additional software.

🛠️ What it does:

  • Automatically creates or clears a worksheet named “Abacus”
  • Fills in numbers as text to preserve all digits and formatting
  • Neatly arranges them – perfect for printing and practicing
  • Focuses on easy-to-print abacus exercises that you can use for training or lessons with a single button click

If you’re looking for an easy way to create abacus exercises for beginners, especially when you want to quickly print them for practice, this tool is exactly what you need.

💬 Abacus example: 6 – 2

Abacus 6-2 example

This version emphasizes how the tool focuses on generating printable worksheets for abacus exercises with ease, just by pressing a button. Let me know if you need any further changes!



📥 Download the Abacus Generator

Ready to get started? You can download the Abacus Generator file below and start creating your own abacus exercises in minutes.

Download Abacus Generator

Once you download the file, simply enable macros, press the button, and you’ll have a sheet full of abacus exercises ready to print and use for practice.

Share and Enjoy !

Shares

Excel split string function

Simple VBA function to split strings into words (or strings):

Function TxtSplit(rngCell As Range, delim As String, nr As Long) As String
    Dim str As String
    Dim arr As Variant
    str = Trim(rngCell.Value)
    arr = Split(str, delim)
    TxtSplit = Trim(arr(nr - 1))
End Function

Sample usage:

=TxtSplit(B2;", ";1)

Share and Enjoy !

Shares

Ohm Calculator за реотани на електронни цигари на Excel

Проста програмка на Excel за изчисляване на съпротивлението на coil-а за изпарител на електронна цигара.
Най-интересното във файла е, че съм използвал именувани полета, за да създам нещо като база данни от която се извличат данните.
Ohm Calculator Excel - e-cigarette
Файла може да се изтегли от тук: Ohm Calculator – e-cigarette

Share and Enjoy !

Shares




Excel VBA add row – добавяне на ред с Vba в Excel

Днес ми се наложи да добавям доста редове в Excel таблица, която беше предварително форматирана. Добавянето и форматирането на редовете един по един е хамалска работа, затова реших да напиша простичък макрос на VBA, който да свърши работата. Кода на макроса е:

Private Sub CommandButton1_Click()
    ActiveCell.Offset(1).EntireRow.Insert
    ActiveCell.EntireRow.Copy
    ActiveCell.Offset(1).EntireRow.PasteSpecial Paste:=xlPasteFormats, _
        Operation:=xlNone, SkipBlanks:=False, Transpose:=False
    Application.CutCopyMode = False
End Sub

Кода го вкарвам в Shee-та:
Excel VBA add code to Sheet1
За да го стартирам се вижда, че съм използвал бутон, вкаран в Shee-та:
Excel VBA - добавяне на ред
Екселския файл може да се изтегли от тук: Excel VBA add row
Ето и едно видео, което показва цялата операция:
Excel VBA add row
[flv:https://blog.nediko.info/examples/excel_VBA_add_row/Add_row.flv https://blog.nediko.info/wp-content/uploads/2012/06/excel_addrow_03.jpg 472 388]

Share and Enjoy !

Shares