Productivity Skills Blog

Naver Korean Dictionary/English Dictionary Search Tool_v1.02_20240201

We are distributing “Naver Korean Dictionary/English Dictionary Search Tool_v1.02_20240201” with one additional feature. When there is a typo in the search term, the method of outputting results was added as an option, and a function was added to output according to this option. An overview of Naver's Korean and English dictionary search tools and how to use them are summarized in the article below. Naver Korean Dictionary/English Dictionary Search Tool Overview 1. Request This Tuesday (2024-01-30)...

Distribution of data standard check tool v1.40_20231016

We distribute data standard check tool v1.40_20231016, which complements the physical name-based standard check function similarly to the logical name-based standard check function and adds an option to remove and check the numeric suffix first. The previous version was v1.37. 1. Functions not implemented in data standard check tool v1.37_20230923 Data standard check tool v1.37_20230923...

Distribution of data standard check tool v1.37_20230923 (&H8000FFFF, insufficient memory error resolved)

In the article on how to solve the data standard check tool_v1.33 error “Not enough memory”, I explained how to bypass the insufficient memory error by setting the size of text, apps, and other items in the display settings to 100%. I couldn't find the cause of this error that occurred when setting the text scale to 125%, so I couldn't fundamentally solve it, but today...

Announcement of Python in Excel (2023-08-22)

1. Python in Excel Overview Yesterday (2023-08-22), Python in Excel was announced at Microsoft Tech Community. In the meantime, we have been using a separate library to link Excel and Python, but finally we provide linkage in a basic environment without the need for separate installation. Announcing Python in Excel: Combining the power of Python and...

Deploy Data Standards Check Tool v1.36_20230505

Distribute data standard inspection tool v1.36_20230505 with an option to select whether to process blank characters as blank characters or as word separators when checking property names. This option can be used when the property name of the logical data model is written in English. 1. Requests Past data standard inspection tool v1.35_20230321 distribution...

Distribution of Data Standards Check Tool v1.35_20230321

When using the standard check function based on the physical name, “'424' runtime error has occurred. An object is required.” There may be errors in the message. Distribute the data standard inspection tool v1.35_20230321 that corrected this error. *(Reference) Last release Post: Data Standard Check Tool v1.34_20221215 Distribution 1. Development In the “Standard Check (Physical Name)” sheet, in column C (column name (physical name))...

News roundup on Microsoft 365 Copilot

Microsoft 365 Copilot was announced last Friday (2023-03-17). By integrating ChatGPT into Microsoft 365, it seems that it can significantly improve user productivity. I've been watching ChatGPT since the end of last year. ChatGPT is spreading faster than any software or service ever introduced to the world. ChatGPT 3.5...

Word Extraction Tool v0.42 release: Bug fix

There was a bug in the word extraction tool v0.41 that was released last time. Distribute word extraction tool v0.42 that fixes the bug that causes KeyError: “Column(s) ['DBSchema'] do not exist” error. Related article: Word Extraction Tool v0.41 release: Add DBSchema occurrence frequency of words item Kiyoung Kim says...

Release Word Extraction Tool v0.41: Add DBSchema occurrence frequency of words item

* Please also refer to v0.42, which was newly released after fixing the bug. Release of word extraction tool v0.42: Bug fix – Productivity Skill (prodskill.com) In the previously distributed word extraction tool (v0.40), Distribute after supplementing the function to add and extract DBSchema occurrence frequency items. The DBSchema_Freq entry indicates how many sources the word...

DA# Macro_v2.13_20221217 Deployment

Distribute DA# Macro_v2.13_20221217 that corrects two errors related to reverse. The corrected errors are: For reference, the DA# Macro introduction (DA# Macro(1): DA#, DA# API, DA# Macro (Macro) Overview – Productivity Skill (prodskill.com)) was explained based on v2.12. 1. Bug phenomenon 1.1. Reverse: specified in the template...

en_USEnglish