User and Business values Relevant “I need it.” Functional “It works.” Desirable “I want to do this, often.” Magical “It has changed my life.” #mindstormGR
Websites Hellenic-land.com Το Hellenic-Land.com είναι μία ηλεκτρονική δίγλωσση πλατφόρμα στα ελληνικά και στα αγγλικά που ξεκίνησε το 2015 με σκοπό την υποστήριξη και την προώθηση όσο το δυνατόν περισσότερων νέων δημιουργών & προμηθευτών ελληνικών και κυπριακών προϊόντων καθώς και παρόχων υπηρεσιών σε έδαφος Ελλάδας και Κύπρου, οι οποίοι επιθυμούν να αναδείξουν, να διαφημίσουν και να προωθήσουν τα προϊόντα τους ή/και τις υπηρεσίες τους όχι μόνο στην Ελλάδα και στην Κύπρο, αλλά και στο εξωτερικό. Wordpress What is CMS (Content Management System)? https://mindstorm.gr/what-is-cms-content-management-system/ Woocommerce – Compare different sheets and then Add New or Update Existing Products from CSV files https://mindstorm.gr/woocommerce-compare-different-sheets-and-then-add-new-or-update-existing-products-from-csv-files/ Python Read and extract text from a PDF file Excel and Python work great together – VBA Macro and Python script Rag Web Scraper + Ollama (Python 3.13) Data Analysis Creation of SKU QR Codes, SKU Barcodes and SKU Product URL QR Codes with VBA https://mindstorm.gr/creation-of-sku-qr-codes-sku-barcodes-and-sku-product-url-qr-codes-with-vba/ Microsoft Access Tips Microsoft Excel…
This is the PDF file. Download “demo_ten_page_document_with_paragraphs.pdf” This is the extracted text from the PDF file. Download “1.docx” Here is the python code to read and extract text from a PDF file: import tkinter as tk import pdfplumber from PIL import Image, ImageTk from tkinter.filedialog import askopenfile from docx import Document from docx.shared import Inches import os root = tk.Tk() canvas = tk.Canvas(root, width=600, height=200) canvas.grid(columnspan=3, rowspan=3) # logo try: logo = Image.open(‘logo.png’) logo = ImageTk.PhotoImage(logo) logo_label = tk.Label(image=logo) logo_label.image = logo logo_label.grid(column=1, row=0) except FileNotFoundError: print(“Logo file not found. Please ensure logo.png is in the same directory as the script.”) # instructions instructions = tk.Label(root, text=”Select a PDF file on your computer to extract all its text / Διαλέξτε ένα αρχείο PDF από τον υπολογιστή σας για να γίνει εξαγωγή κειμένου”, font=”Calibri”) instructions.grid(columnspan=3, column=0, row=1) instructions2 = tk.Label(root, text=”Select 1.docx file on your computer to use all extracted text / Διαλέξτε το αρχείο 1.docx από τον υπολογιστή σας για να χρησιμοποιήσετε το εξαχθέν κείμενο”, font=”Calibri”) instructions2.grid(columnspan=3, column=0, row=6) # instructions3 instructions3 = tk.Label(root, text=”Version 1.0 | Created by Tryfon Papadopoulos”, font=”Calibri”) instructions3.grid(columnspan=3, column=0, row=7) def open_file(): browse_text.set(“loading…”) file = askopenfile(parent=root, mode=’rb’, title=”Choose a file / Διαλέξτε ένα αρχείο”, filetypes=[(“Pdf file”, “*.pdf”)]) if file: with pdfplumber.open(file) as pdf: page_content = “” has_text = False …
Bilbao’s Guggenheim Museum – Μπιλμπάο Bilbao’s Guggenheim Museum, designed by world-renowned architect Frank Gehry and opened in 1997, is hailed as one of the most important architectural works of its time. Within its undulating and reflecting walls on the banks of the Nervión River, you’ll find a rotating artistic wonderland of both modern and contemporary art. The Basics The Guggenheim is Bilbao’s most popular attraction, and the facade is all but impossible to miss. Those who want to tour the collection have many options to choose from. Explore the exterior and interior on a guided small-group tour, or gain insight into the collection and architecture with a private guide and customized tour. It’s also possible to visit on a day trip from San Sebastian or as part of a multi-day itinerary through northern Spain. Things to Know Before You Go The Guggenheim Museum Bilbao is a must-see for art lovers…
Τα κουτάκια μας / Our boxes Do you like your box? Would you like to get out of your box? Do you want to be the one to decide when to get in and out of your box? Do you want to know if you are in a box? Is this box even yours? Is there enough space to move in your box? Is there enough light? Is there enough air? Have you ever felt locked or uncomfortable in your box? Can you change your box? Do you feel safe in your box? Can you afford your box? Let’s start a conversation about boxes, space, feelings and relationships. About life, itself. Feel free to share your thoughts. ➡️ fb : mindbook.eu / www.mindstorm.gr Email : info@mindstorm.gr
True or false? In a world of hate, love is always a conspiracy. In a world of war, peace is always a conspiracy. In a world of bullying, smile is always a conspiracy. In a world of money, giving is always a conspiracy. In a world of dirty, pure is always a conspiracy. In a world of fake, real is always a conspiracy. In a world of more, less is always a conspiracy.
Do you want a room with a view or a room with the right view? The Greek view. Sun, sea, land, light are all there. Proportional. Symmetrical. Once seen, never forgotten. — #santorini #greece #view #hellenicland #the_greek_view / fb : Hellenic-Land.com See also Gianiskari – Γιανισκάρι Photo credit (Gianiskari) : Τρύφωνας Παπαδόπουλος
Some days, to the world, I feel like the fake drawers on bathroom cabinets or the false pockets on a suit’s vest; a reasonable addition that looks like it belongs, but what possible purpose will I ever serve? …. I am filled with words but only those that care to read will ever understand what I am about – Tyler Knott Gregson #mindbookEU #mindstormGR / fb : mindbook.eu
Why set SMART goals Goals give you direction. It allows you to stay mentally and physically focused on the road to where you want to go. Specific Measurable Achievable Relevant Time-bound Οι στόχοι βοηθούν στην επίτευξη του σκοπού όταν είναι συγκεκριμένοι, μετρήσιμοι, εφικτοί, σχετικοί και ορισμένοι μέσα στο χρόνο. #smart_goals #softexperia / fb: Softexperia.com
List of files in Excel and preview of images – VBA Code – Excel 1) Is it possible to have a list of the images found in a folder and its subfolders in Excel? 2) Is it possible to see the images as I move from one row to another? 3) Is it possible to see the actual image, its name and other info as I scroll down? 4) Is it possible to rename images in source folder according to a rule such as Last Subfolder & ID & FileName, and then copy all renamed images to another folder (target folder)? 5) Is it possible to have all images as they were in the source folder? Yes, it is. Check this video on YouTube and watch it happening. VBA Code credit : Trifon Papadopoulos #mindstormGR #list_of_images_in_excel Δείτε επίσης Import of multiple posts to WordPress with the use of Excel, Word…
How to quickly hide unused cells, rows and columns in Excel – Scroll area with VBA A1:E50 The Sub below is assigned with macro to button Limit Scroll to existing rows and columns for ‘Sheet1’ Watch video on YouTube Sub UnhideAndUnscrollSheet() ‘Button <<Limit Scroll to existing rows and columns for ‘Sheet1’>> Dim ws As Worksheet Dim lastRow As Long Set ws = ThisWorkbook.Sheets(“Sheet1”) ‘ Unhide all rows and columns ws.Rows.Hidden = False ws.Columns.Hidden = False ‘ Set cell B1 to bold ws.Range(“B1”).Font.Bold = True ‘ Set headers in row 3 to bold ws.Rows(3).Font.Bold = True ‘ Set all columns to font size 13 ws.Cells.Font.Size = 13 ‘ Set cell B1 to font size 16 ws.Range(“B1”).Font.Size = 16 ‘ Set all rows and columns to a reasonable height and width ws.Rows.RowHeight = 15 ‘ You can adjust this value as needed ws.Columns.ColumnWidth = 20 ‘ You can adjust this value as…
How to calculate discount, sale price and profit margin after discount? 1) Find the original price (for example 90€) 2) Get the discount percentage (for example 20%) 3) Calculate the savings: 20% of 90€ = 18€. 4) Subtract the savings from the original price to get the sale price: 90€ – 18€ = 72€. 5) Subtract Buy Price from the Sale Price and divide it by Sale Price to get the Profit margin after discount: (72€ – 50€)/72€=30,56% You’re all set! #softexperia #mindstormGR #excel_skills
