Excel String to Date

Leave a reply
  • TEXT(value, format_text): Converts numbers/dates to text with specific formatting (e.g., TEXT(A1, "0.00") or TEXT(B1, "mm/dd/yy")). 
  • LEFT(text, num_chars): Extracts characters from the left of a text string. 
  • RIGHT(text, num_chars): Extracts characters from the right of a text string. 
  • MID(text, start_num, num_chars): Extracts characters from the middle of a text string. 
  • TRIM(text): Removes extra spaces from text (leading, trailing, and extra spaces between words). 
  • PROPER(text): Capitalizes the first letter of each word. 
  • UPPER(text): Converts text to all uppercase. 
  • LOWER(text): Converts text to all lowercase. 
  • LEN(text): Returns the number of characters in a text string. 
  • CONCAT / &: Combines text strings (e.g., ="Hello " & A1 & "!"). 

 

=TEXT()
=VALUE()
=MID()
=LEFT()

=DATE(
  MID(
    A1,
    FIND("/",A1)+1,
    IND(
      "/",
      A1,
      FIND("/",A1)+1
    )-FIND("/",A1)-1
  ),
  LEFT(
    A1,
    FIND("/",A1)-1
  ),
  MID(
    A1,
    FIND("/",A1)+1,
    FIND("/",A1,FIND("/",A1)+1)-FIND("/",A1)-1)
  )
)

FIND function
LEFT function
MID function

Portable Soldering Iron

Leave a reply

Soldering Iron

eDesign / Miniware

eDesign / Miniware TS100
eDesign / Miniware TS101
eDesign / Miniware TS80P
Pine64 Pinecil

FNIRSI

FNIRSI HS-02

QUECOO

QUECOO T85

ALIENTEK

ALIENTEK T90

Tips

eDesign / Miniware

TS100/TS101 Series Soldering Iron Tips
Nine modles: TS-B2 / BC2 / C4 / D24 / K / KU / I / ILS / C1

245 Series Soldering Iron Tips
Three modles: BC2, K, D24

210 Series Soldering Iron Tips
Three modles: KU, I, IS

FNIRSI HS-02

QUECOO T85

ALIENTEK T90

Eleshop

USB-C Soldering Iron

Which USB C Soldering Iron is the Best for 2025? Pinecil vs Fnirsi vs TS101

Soldering Iron Tips

Which JBC tip do you need? C470 C245 C210 or C115?

3D Print Cake Topper

Leave a reply

Spiderman Cake Topper
minions cake topper
Pikachu – Zápich do dortu (Pikachu Cake Topper)
Groot – Zápich do dortu (Groot Cake Topper)
Bluey & Bingo – Zápich do dortu (Bluey & Bingo Cake Topper)
Malá mořská víla – Ariel a Šupinka (The Little Mermaid – Ariel & Flounder) – Zápichy do dortů / Cake Toppers
Sonic the Hedgehog Cake Topper (NO AMS-Multipart)
Hot Wheels cake topper
Harry Potter – Zápich do dortu (Harry Potter Cake Topper)
Cake topper with tractor and name – Jamie
Dirty dancing cake topper
“Davin is a Fast ONE” – cake topper
Breakdance Silhouette Cake Topper
Minie Topper Cake
Lion Topper Cake
Koala Topper Cake
Jednorožec s duhou (Unicorn & Rainbow) – Zápichy do dortů / Cake Toppers
Tlapková Patrola (PAW Patrol – Zuma and Marshall) – Zápichy do dortů / Cake Toppers
Baby Shark – Zápichy do dortu (Baby Shark Cake Toppers)
Hasiči – Zápichy do dortu (Firefighter Cake Toppers)
Bing & Flop – Zápichy do dortů (Bing & Flop Cake Toppers)
Dopravní značky – Zápichy do dortu (Traffic Sign Cake Toppers)
Hulk – zápich do dortu / Cake Toppers
Star Wars – Han Solo & Leia – Zápichy do dortů (Star Wars Han Solo & Leia Cake Toppers)

STM32G030 Tutorial

Leave a reply

Timer PWM with DMA stops too early on STM32G431

Pinout & Configuration

Unused Pins

The unused I/O pins should be configured as analog input by software; they should also be connected to a fixed logic level 0 or 1 by an external or internal pull-up or pull-down.
Recommended course of action for Unused pin of STM32 MCU
Pin value of a GPIO pin set as high impedance
GPIO outputs are in high-impedance state

HAL

HAL_Delay

Because it’s an “at-least-N-ms” delay with 1ms granularity.
HAL_Delay works and doesn’t work
Is HAL_Delay(1) quaranteed to be close to 1ms?
HAL_Delay(1); takes 2ms

Timer + DMA

Hands-on with STM32 Timers

PWM

It takes 2 mins to generate PWM signal in STM32
STM32 Guide #3: PWM + Timers

PWM + DMA on G431

STM32 LESSON #5: TMER (PWM + DMA)
Confusion about length parameter in HAL_TIM_PWM_Start_DMA

  • On STM32F4 the length seems to be with respect to Data Width in the timers DMA setting
  • on STM32U575 it seems to be measured in bytes (regardless of the GPDMA settings)

WS2812

Interface WS2812 with STM32
github.com/MaJerle/stm32-ws2811-ws2812-ws2812b-ws281x-tim-pwm-dma-timer
Improved STM32 WS2812B DMA library
Tutorial: Adafruit WS2812B NeoPixels with the Freescale FRDM-K64F Board – Part 5: DMA

SPI (no DMA)

WS2812

WS2812 LEDs using SPI

STM32G030 BOOT0 / NRST

Leave a reply

STM32G0 Boot0 und SWCLK selber Pin
STM32G030 BOOT0 versus SWD
STM32G030 BOOT0 pin – SWCLK
STM32G0 Series Workaround for BOOT0-Pin Problem #82

ST

AN5096 – Application note – Getting started with STM32G0 Series hardware development (PDF)

RM0454 – Reference manual – STM32G0x0 advanced Arm-based 32-bit MCUs (PDF)

  • Reference design
  • PA14 is shared with BOOT0 functionality. Caution is required as the debugging device can manipulate BOOT0 pin value.
  • The debug pins are in AF pull-up/pull-down after reset:
  • PA14: SWCLK in pull-down
  • PA13: SWDIO in pull-up
a
b
c