2020年12月29日 星期二

自動搜尋不同網頁 - 輸入一個單字, 自動搜尋多個德文字典網頁, 使用 Google Sheet

之前這一篇有關自動德文查詢的功能, 反應還不錯, 很多人跟我回覆說有幫助, 但是缺點就是Javascript 不是太直覺使用, 所以我又用了 Google Sheet 做了一個差不多功能的, 這樣就不用下載 Javascript 的原始碼拉, 而且也方便做筆記, 缺點就是要有 Google 帳號, 但我相信應該大部分的人都有

ps. 要稍微會一點 Google Sheet

步驟: 新建一個空白的 Google Sheet

把想查的德文單子放在 舉例把 merken, 放在 A2, 

然後在空白的地方, 例如在E2, 複製貼上底下的公式 從等號開始, 到最後的括號=HYPERLINK(CONCATENATE("https://dict.leo.org/german-english/",$A2),"LEO")

你就會看到 "LEO" 字典出現拉, 所以只要點一下這個連結, 就會自動連到LEO, 是不是查字典變得輕鬆愉快了.

依此類推, 依序貼上其他的, 一個空格一個, 我們就在 E3 貼上下列公式搜尋 Duden字典 
=HYPERLINK(CONCATENATE("http://www.duden.de/rechtschreibung/",$A2),"DUDEN")

E4貼上
=HYPERLINK(CONCATENATE("https://www.dwds.de/?q=",$A2),"DWDS")

E5貼上
=HYPERLINK(CONCATENATE("http://en.pons.com/translate?q=",$A2,"&l=deen&in=&lf=de"),"PONS")

E6貼上
=HYPERLINK(CONCATENATE("http://www.linguee.com/english-german/search?source=auto&query=",$A2),"Linguee")

當然你也可以依樣畫葫蘆改成或加入你自己常用的字典, 但這就有點沒這麼容易說明了, 有需要的人在跟我說吧.

這只有第一次稍微麻煩, 稍微測試一下, 如果一切都正常, 之後就複製一樣的公式就可以了(點著框框底下的加號往下拉就可以了), 因為我不知道怎麼匿名分享我的 Google Sheet, 所以請大家就參考以下圖片 (點下去能放大)



理論上一樣的方法也可以用在各種不同語言, 英文, 日文, 法文, 西班牙文阿...etc 應該都是可以套用的, 只是因為我不熟悉那些語言的字典, 你也可以提供給我, 歡迎大家討論. 

祝大家學習德語或其他語言愉快

//

更新加入 google sheet 連結, 希望有效, 如果有用的人請告訴我這樣的分享到底能不能用, 我自己不知道, 希望能有從你們的一點回饋, 這樣能讓我找到更好的分享方法



2020年12月28日 星期一

[game] 心得 Creeper World 3: Arc Eternal

踏馬的有誰知道 Arca 怎麼早點過關? 我看了這個 Youtube 照著做也打不過, 試了n百次了 


//

聖誕節期間, 找到一個很有趣的遊戲, 叫做 Creeper World 3: Arc Eternal [官網] [steam], 我覺得這遊戲很有創意, 基本上就是收集能量, 然後阻止敵人入侵, 敵人是流水狀液體, 所以我開玩笑稱它為"流體模擬器". 遊戲原理很簡單, 但卻有魔力般讓人一直想往下一關. 推薦給喜歡守塔類型的人.

最近這幾天一直玩, 到目前為止20小時的心得如下 

* 這遊戲有毒, 光教學&熟悉全部的工具就能打個10小時了

* 開局很重要, 先追求能量, 然後再慢慢擴張版圖, 特別等到有防護罩(Shield)能使用之後, 基本上固守主要核心的部分, 然後慢慢向外擴張

* Guppy 運輸機不太會用, 但是有的關卡必須使用才能過關

* Sprayer 噴射器有點犯規, 因為能消除大量的"敵人", 敵人是液體流水

* 每一關結束後可以看到別人過關使用的時間, 有的人我覺得超豪小的, 不知道他們是用什麼方法在如此短的時間過關的

* 別小看 Cannon 加農砲, 耗能少, 但攻擊速度蠻快的, 要緊的時候很能擋

* 最近出第四代了, 畫面變得很漂亮, 等有預算或者特價再來入手

* 介面雖然是英文的, 但是可以像我一樣跳過所有劇情, 都看不懂也沒關係, 摸幾次就知道了,  不然也歡迎留言給我, 可以互相討論戰術 :)


參考資料: 1. PTT鄉民翻譯的文章 2. wiki





// 有密集恐懼症的請勿往下看, 這關基本上是拿來衝成就用的, 把敵人都消滅後, 繼續建設就可以衝成就. 


2020年12月25日 星期五

微波整流器(RF/mircowave rectifier)心得分享- 入門篇

小弟做了幾年的微波整流器(RF/microwave rectifier), 一點小心得整理跟大家分享, 這邊提到的都是離散的設計, MMIC是另外一回事.

微波整流器的基本原理很簡單, 就是使用元件的非線性特性, 取出產生的直流項來用, 並且把二階或更高頻的諧給壓抑, 原理很簡單, 此電路最主要就是在追求高效率,後來當然也有寬頻的, 雙頻的, 多頻的有的沒有的變化.

整流器的效率定義也很直覺, 就是輸出的直流功率放分子, 輸入的交流(微波)功率方分母, 物理意義也很容易理解. eff= PDCout / PACin

至於效率跟什麼相關? 基本上取決於元件本身的寄生電阻, 寄生電容, 電路的輸入匹配, 負載電阻, PCB板材本身的消耗, 例如微帶線(microstrip line)的損失... 等等... 但最主要最主要還是取決於使用的非線性元件.

非線性元件大致上可分為使用1.二極體(diode)跟2.電晶體(transistor)的.

依照匹被電路常用的又可分為 class E, class F, class F-1, harmonic-tuned, 等等, 或者就不管諧波, 直接匹配的也是可以. 

因為整流器是高度非線性的電路, 所以模擬的時候大多採用 harmonic-balance, 包括看輸入阻抗也是, 小弟之前有 review 一些微波整流器的論文, 然後用s-parameter看輸入阻抗, 我都不明白這樣看怎麼會對?! 因為大多數時候並不在小訊號操作阿.

有些論文小弟自己覺得不錯, 供各位參考, 這篇蠻適合入門的 這篇也不錯 或者各位可以搜尋下面幾位學者的論文, 應該都蠻有參考價值的, e.g. Prof.  Zoya Popovic, Prof. Ke Wu [1], 若干中國學者這個領域也都做得不錯.


Tips

  1. 有人使用調變訊號增加效率, A. Georgiadis [link] 做很多類似的, 但我不確定是不是他們第一個提出的
  2. Bandstop是我最近很欣賞的設計, [link]
  3. 當然高動態範圍也是大家追求的目標之一 [link]
  4. (待增加)


小弟整理了一些模擬常用的公式在這邊 [link], 有興趣的人請自行移動, 這篇文章是比較屬於入門類型的, 希望對剛進入這個領域的,或想進入這個領域的人有少許幫助.


有空再慢慢補上這篇, 如果有什麼想要跟小弟討論的也歡迎留言討論 


2020年12月20日 星期日

Keysight ADS 微波整流器(Rectifier) 常用公式

微波整流器(Rectifier) 常用公式 

微波整流器(RF/Microwave Rectifier)這傢伙也是大訊號, 所以很多公式都得自己來, 因為自己常用到, 所以在這邊做個筆記, 希望對大家有幫助, 圖片稍微細節請參考英文版 [ link ]

1. 使用 Harmonic Balance 模擬, 到Source-Freq Domain拿 P_1tone當來源, 我習慣把輸入頻率跟輸入功率都設為變數"var". 

2. 把輸入的地方節點命名為 vin, 順便串聯上電流表, 把直流輸出的節點命名為vout

3. (有想到再補)


計算整流器效率 (efficiency)

Poutdc=mag(vout[::,0])**2/RL
eff=100*Poutdc/dbmtow(mpin)


大訊號輸入阻抗

zind=vin[1]/I_in.i[1]

轉成反射係數, 就可以畫成 Smith chart 拉

Gamma=(zind-50)/(zind+50)

當然也可以轉換成 dB 

s11indb=20*log10(abs(Gamma))






祝大家設計整流器順利, 有什麼想知道的或者新穎的玩法, 也歡迎跟我討論

[Keysight ADS] Some equations for RF/microwave rectifier design

been designing RF rectifiers for years. Since I myself use these equations quite often, I write them down here and hope this page would help you to speed up. 

Note that rectifiers are large-signal operation meaning "Harmonic Balance" simulation is mostly used.
Firstly, you have to have "harmonic balance" and secondly, you have to set a node at the output of the rectifier as e.g. vout. 
To obtain input impedance, you have to add a note at the input port as e.g. vin as well as a current meter.
We need to calculate input impedance from the impedance definition.

Anyway, seeing figures below are easier than texts. 

Figure of the input part

Figure of the output part



The MeasEqu I set


Anyway, you can copy these equations below and paste into your schematic using MeasEqu as I did or use EQU function in ADS display.




To calculate efficiency:

Poutdc=mag(vout[::,0])**2/RL
eff=100*Poutdc/dbmtow(mpin)


To calculate large-signal input impedance:

zind=vin[1]/I_in.i[1]

You can convert the impedance to Gamma and then plot in Smith chart as:
Gamma=(zind-50)/(zind+50)

Of course, you can plot in dB:

s11indb=20*log10(abs(Gamma))






Have fun of rectifier design. 


2020年12月5日 星期六

What if you forget you password of DHL account and also forget the security answer (Passwort oder Antwort auf Sicherheitsfrage vergessen) while you have a package in the Packstation? You even move to a new place and cannot receive post at your old address

Well this is a long story about DHL and packstation and solution


What if you forget you password of DHL account and also forget the security answer (Passwort oder Antwort auf Sicherheitsfrage vergessen) while you have a package in the packstation? You even move to a new place and cannot receive post at your old address

I personally think DHL website is not friendly especially if you want to find some information. Therefore, I summarise some information and hope this post may help you or give you some hints.

If you forget your password and also your security answer (Antwort auf Sicherheitsfrage) like me, here is a solution I found out after couple of messages and communications.

My German is quite limited so I deal with this problem mostly online and with help of Google translate.

I did call DHL service line once (phone number here : 02284333112) and indeed got some useful hints to actually find a solution using their website.

Honestly, their website is super super super difficult to use. I don't know what native German speaker thinks but for me it is very difficult to find out the exact solution. It is really rocket science. no joking.

Anyway, there is no direct link to jump to the webpage and thus, let me tell you the steps to reach the exact webpage, where you can issue the problem "Passwort oder Antwort auf Sicherheitsfrage vergessen" and a person will deal with it.


step 1 : go to this link
https://www.dhl.de/de/privatkunden/hilfe-kundenservice.html

step 2 : select "DHL Kundenkonto", which is in the middle

step 3: select " DHL Kundenkonto allgemein"

step 4: select "Wo finde ich meine Postnummer?"

step 5: select the hyperlink "Kundenservice"

Now you should see "Ihr Anliegen zum DHL Kundenkonto" if you follow these steps written above. Rocket science. Isn't it?! Why can someone make such complicated system?! Ask DHL. I personally think that they intend to do so. Once you see this website, just type in corresponding information. After one day or so, you should receive their reply.

In their reply, they said they reset the answer and will send me a mail to my address. Here comes to my second problem. What if you have moved to somewhere else? The address you filled in for the Packstation is not valid anymore. So I ask them again. Their answer is that you have to cancel your post account.

Here is my third problem . What if I have something in the Packstation right now. It actually is my problem. It becomes a chicken/egg dilemma. If I cancel my post account, how can I pick up my package and I don't have a way to login my post account. So I ask them once again. Their solution is that they email me the the collection code (Abholcode). After couples of days and nights, finally I got the package.


Rest is easy. just simply cancel your old post account and create a new one. Due to current Coronavirus, I wait for probably more than a month to get the new card and can use it. Super high efficiency of DHL as always. Isn't it?


As an engineer, I provide a flowchart and hope it will help you to understand the problem and solution. As I said before, dealing with DHL is rocket science literally.



* If forget your password to login:

> Click "passwort vergessen"

It then will ask your

forget answer "security answer (Antwort auf Sicherheitsfrage)"

if you know it, problem solved

if you don't like me

> please follow the steps I wrote before

If you still stay where you register for the post account

problem solved

if you moved like me

you must cancel your post account and make a new one



* If you currently have a package in the Packstation,

> please follow the steps I wrote before to tell them you currently have a package in a packstation. 
 They will tell you the collection code (Abholcode)

Now you should be able to get your package.

> cancel your post account and make a new one.


All in all, it may take you couples of days to solve all problems. My sincere suggestion is better not forget the password and/or security answer at the first place.


have fun with DHL. :)