:::

雜談:從不懂到改寫別人的VBA不難,但對心臟不太好 / TALK: From Novice to VBA Rewriter: An Easy but Stressful Journey

布丁布丁吃布丁

雜談:從不懂到改寫別人的VBA不難,但對心臟不太好 / TALK: From Novice to VBA Rewriter: An Easy but Stressful Journey

2025-0211-000403.png

最近幫別人改寫老舊Excel上的VBA,讓使用者能直接從輸入資料到彙整成可以列印的格式,而避免大量的複製、貼上操作。寫是寫完了,但內心真是五味雜陳。

(more...)

移除PDF上的註解:PDF Annotation Remover / Removing Annotations from PDFs: PDF Annotation Remover

布丁布丁吃布丁

移除PDF上的註解:PDF Annotation Remover / Removing Annotations from PDFs: PDF Annotation Remover

2025-0109-153638.png

PDF的註解功能可以允許我們在原始檔案上添增額外的文字、標亮、線條、筆記。而且這些註解還可以刪除、修改,讓原始檔案保持它原本的樣子。不過如果有大量註解需要移除的話,手動操作其實非常繁瑣。這時候你可以用我開發的PDF Annotation Remover,讓PDF檔案的註解全部移除吧。

PDF's annotation feature allows us to add additional text, highlights, lines, and notes directly onto the original file. These annotations can also be deleted or modified, preserving the original document's integrity. However, manually removing a large number of annotations can be quite tedious. For this, you can use my PDF Annotation Remover to remove all annotations from your PDF file.

(more...)

雜談:為了管理Stable Diffusion提示詞而用AppSheet開發了工具 / Talk: I Developed a Tool Using AppSheet to Manage Stable Diffusion Prompts

布丁布丁吃布丁

雜談:為了管理Stable Diffusion提示詞而用AppSheet開發了工具 / Talk: I Developed a Tool Using AppSheet to Manage Stable Diffusion Prompts

2024-1229-202356.png

由於我會在越來越地方使用Stable Diffusion繪圖,所以我花了一些時間用AppSheet做了提示詞管理工具。這篇就來聊一下我做了那些東西。

(more...)

將PDF轉換成模仿成掃描檔:ScanSim PDF / Converting PDF to Simulated Scanned Document: ScanSim PDF

布丁布丁吃布丁

將PDF轉換成模仿成掃描檔:ScanSim PDF / Converting PDF to Simulated Scanned Document: ScanSim PDF

2025-0109-095818.png

列印、簽名、拍照、轉換成PDF、上傳,這是現在很多證明文件的處理手續。處理後的PDF檔案只是圖片的封裝,不能直接選取與複製,只能作為證明文件留存,這已經是最基本的資安防護手段。然而,如果可以將數位文件直接轉換成彷彿掃描檔一樣的檔案,那不就可以省下列印與掃描的繁雜手續了嗎?也許這時候Docker APP ScanSim PDF就能夠派上用場了。

Printing, signing, taking a photo, converting it to PDF, and uploading it—this is the procedure for processing many verification documents nowadays. The processed PDF file is merely a container for the image; the text cannot be directly selected or copied. It can only serve as an archive of the verification document, which is a basic security measure. However, if digital documents could be directly converted into files that resemble scanned documents, wouldn't that eliminate the tedious printing and scanning steps? Perhaps the Docker APP ScanSim PDF could be useful in this situation.

(more...)

雜談:Gemini可以免費繪圖,但不能用API畫 / TALK: We Can Draw on Gemini Webpage for Free, but Not With API

布丁布丁吃布丁

雜談:Gemini可以免費繪圖,但不能用API畫 / TALK: We Can Draw on Gemini Webpage for Free, but Not With API

2025-0207-015908.png

畢竟是免費的AI功能,真的不能要求太多。

(more...)

自行架設Dify使用的重排序模型:Text Embeddings Inference / Self-Hosting a Dify Reranking Model: Text Embeddings Inference

布丁布丁吃布丁

自行架設Dify使用的重排序模型:Text Embeddings Inference / Self-Hosting a Dify Reranking Model: Text Embeddings Inference

2025-0109-003246.png

隨著在Dify使用的知識庫越來越多,傳統的用相似度來計算權重分數的做法已經不敷使用,而使用重排序模型來排序檢索結果順序的做法也越來越受歡迎。這次我們來架設HuggingFace推出的Text Embeddings Inference,並讓Dify能用它來做重排序吧。

As the knowledge base used in Dify grows, the traditional method of calculating weight scores based on similarity is becoming inadequate.  Using reranking models to reorder retrieval results is gaining popularity.  Let's set up HuggingFace's Text Embeddings Inference and integrate it into Dify for reranking.

(more...)

希希助教獻上康乃馨的祝福 / TA. Sissi Presents Carnation Blessings

布丁布丁吃布丁

0 Comments

希希助教獻上康乃馨的祝福 / TA. Sissi Presents Carnation Blessings

20250106_BLOG_.note_01.png

認真讀書也是回報母親辛苦的一種表現喔!

(more...)