Sunday, March 30, 2025

雲 --- (德) 赫曼。赫塞

 雲 --- (德) 赫曼。赫塞


    在我的寢室兼工作室的東邊, 有一個通向陽台的小門。 這個門從五月到九月半, 日夜都敞開著。  門外, 有一個長約一步闊約半步的小小的石造陽臺突出著。  這個陽臺是我的最好的財產,因為有了它,數年前我纔決心在這裡住下來。  因為有了它, 不管有多少次的失望, 我每次都還坐在這裡。  因為有了它, 雖然旅行了多少次, 我每次都懷著感謝的心情而回到這個狄辛(地名)的寓所裡來。  美麗的住所, 窗外特有的美麗而廣大的景色, 這常常是我的驕傲, 我的秘密。  可是, 從來的景色都沒有像現在這樣美麗過。  雖然壁粉脫落了, 而且還有種種的拘束, 但為了這景色, 我還在這裡繼續住下去。  


    在陽臺的外面,有一個古老的朝南的園子在半山腰形成峻峭的斜坡。  這裡面種著有重厚扇形樹梢的椶櫚,山茶花,含羞草和蘇木, 還有一顆完全被豆類纏繞著不知是什麼。 再上去, 是一個小小的薔薇花圃彷彿漂浮在天上一樣。  這個沉睡的舊園子, 和兩三個被栗樹遮蔽著的靜寂山谷,橫亙在我與人世之間, 我便是俯瞰著這些樹梢而度日的。  樹梢晝夜都喧噪著, 夕暮時分可以從其中聽見悲哀的夜梟的叫聲。  公路直通到我們村莊裡, 郵差的汽車每天都駛上來, 把可愛的信運到這裡來。  最可感謝的, 是汽車不斷地把從德國來(的,我加的)美好的新書帶來給我。   


    只要把門關起來, 世間的聲音就不會來到我的耳邊。  午後和傍晚常常都有這樣的時間。  在這樣的時候, 門已經關了,又沒有門鈴, 而下面是有許多石级的園子, 所以一坐在小小的陽臺上, 我就不會被什麼人騷擾了。  在這裡, 越過園子和森林的山谷, 我可以望見沙華特禮的山嶺, 和聳立在它後面的支羅尼梭峰。  我也可以望見坡禮查的耀眼的海灣, 和柯芒湖對面的那些直至仲夏還有雪留在山谷裡的高山。  


    夕暮時分, 我常常這樣坐著眺望, 一望到浮在近處天空上的暮雲, 我便會有一種滿足的情懷。  看見世間躺在下面, 我便想: 我在這世間雖不曾得到幸運,但它也不曾把我殺死, 我依舊生活著, 繼續反抗著。  我雖然不曾成為成功的廠長, 拳術家或電影明星,但我已得到了我十二歲時就神往的東西 -- 成為一個詩人了, 我不再想從世間得到什麼了。  如果我能用自己的眼睛靜靜地去觀察世間, 我便可以學到許多世間提共給我的東西,那是成功和人世間的幸運兒完全不曉得地。  能夠眺望是一種優秀的技術, 而且常常是一種非常快樂的技術。  


    我是從夕暮的雲學到這種技術的。  夕暮時分, 坐在這小小的陽臺上, 我總以雲為友。  佔著高高的位置的鳥巢般的我的露台, 聳入雲中。  天下雨的時候, 或颳這地方特有的的激烈暴風的時候, 雲會衝到我房間裡來, 退去了灰白色, 挨著露台的欄杆, 或一直竄到我的鞋邊。  而在外面, 雲在上下地迴旋著, 每次打閃電的時候, 便驚慌似的明亮起來。  在滴著水的山谷裡, 和寒冷而黑暗的湖上, 你會以為雲已經飛下來了, 但是它又被退色的天空吸回去。  和這相反, 在天氣晴朗的時候, 湖水青青地閃耀, 反映著紫色的夕暮的陰影。  在遠處的村莊上, 窗子的玻璃放射著金光, 山嶺的西端像透明的薔薇色的寶石一樣閃著, 這時雲也塗上了非常美麗的顏色, 精神奕奕, 永遠和顏悅色的漂浮著, 做著天真的小孩子的遊戲。  


    在少年時代, 我對於雲曾經採取虔敬的, 有點嚴肅的態度。  就是踏入老境的今日, 我愛雲也不遜於往昔, 但卻沒有從前那樣純真了。  雲是孩子, 對小孩純真的, 只有他的雙親、 祖父母和老人, 因為自己再次返老還童, 像他們對自己本身已不是很純真一樣, 所以對於小孩子也不會是純真的。  熱情是美麗的, 對於少年人是非常適合的, 但對於上了年紀的人, 卻是詼諧,微笑,機智,把世界當作一幅畫, 把事物當作短促的暮雲的遊戲來眺望,更為適當。  


    可是, 我忘記了我現在執筆的最重要的目的了。  春夕, 是雨後最美麗的晴朗的夕暮, 雲的樣子完全是可笑的。  雲在天空上, 有長長地曳著的, 也有圓圓地低垂著的, 但因為猛烈的風吹來了, 便徐徐地團團地轉著, 像是靜靜地在內面轉動著的長捲筒。 我一分鐘也沒有離開過, 忽然整個天空都明亮起來, 閃閃地放著光, 雲也小起來, 被推到地平線的那邊去了。  但雲的上面又有白色和金色, 腹部青青地長長伸展著, 像是飛船或鯨魚, 形狀都很浮凸和緊縮。  


    就在這一瞬間, 最後的薔薇色和金色也從寶石一樣的山頂消去, 下面漸漸暗起來, 只有天空中還隱隱地流著白日的光亮。  猛烈的風吹著, 但雲的船好像不動似的, 踟躕地停在山的背脊上。  我把鼻子向著風的方向。  它在逐漸淡下去的色調中, 又幽微地交織著紅色和褐色。  但是為了不要在下一個瞬間讓雲溜掉, 我應當好好地看守著。  看起來雲好像是固定而沒有生氣,幾乎是不動一樣, 但它的形狀卻不斷地從內部融解。  雲是奇妙的, 像是散課後的小孩子的惡作劇。  小孩子在學校的圍牆邊向老師脫帽告別。  但老師回頭一看, 小孩子已經不見了, 卻從圍牆後傳來笑聲。  


    這時一塊長長的雲又來到別的雲上面, 初看時像金屬鑄造出來的牢固不動。  在藍碧的天空裡漂浮著一塊薔薇色的雲,它突然猛烈地燃燒起來, 變為鮮艷的紅色, 同時形成為美麗的魚。  不久, 它又變成一條有青色腹鰭的大金魚,一邊微笑著, 一邊向著滅亡游泳過去。  如果夕陽的光亮消失, 我的金魚便一分鐘都不能生存。  現在尾部以變為褐色, 腹部以變為青色, 鮮豔的紅色和金色只在背脊上燃燒著。  後來它突然捲著尾巴, 頭膨脹為圓形。  金魚已經失去最後的金色了, 在它消滅時, 它變為圓塊, 並從裡面吐出兩條灰色薄紗, 像是噴吐自己的靈魂。  它在漸漸薄下去的紗裡融解, 於是便完全失去了它的形狀。  


    金魚消失, 我的快樂也消失了。  雖然有幾本美麗的新書在等待著我, 但如果我能夠再和我的金魚多玩一小時, 將是多麼快樂呵!  


-----------  沉英 譯 ----------


Tuesday, March 18, 2025

used iA for 8 hours

 I used IA for a project, which has nothing to do with me.  For this problem belongs to the Support team.  So there is this customer who emailed us hisPO.  I entered the PO into our system, and yet this customer kept emailing me that the SOconfirmation email was wrong.  We went back and forth, no, I went back and forth with him with elaboration, which I pointed out which item he had a wrong pricing.  He basically just repeated his statement again and again, without further reasoning.  I got frustrated, and had Emily checked the SO for me.  She did not want to check it, because one glance, she knew I was correct.  Then I decided to go to David.  After David heard me while searching around.  He confirmed my statement that the customer quoted a product incorrectly.  He then wrote an email to the customer.  

The next morning, while I was picking, he came and asked me if I saw the customer's reply.  I said yea, the customer agreed with our conclusion.  But he said that another person from the customer chimed in, saying that it was our fault through a pricing spreadsheet, which we shared with the customer.  The customer asked us to honor the wrong data this time.  I was kind flabbergasted, and David said that he now agreed with me that the customer knew the problem and set the trap for us.  

Internally, the support team was trying to correct the mistake, but they found it's really hard.  I kept hearing David and Ashley saying it's really hard.  I thought it was a great opportunity to try out the iA.  I started on Sunday for 1.5 hours, downloading the data, rearrange it, engaging the iA a little bit.  Just to understand what we were dealing with.  Then I spend 3+ hours last night trying to get it going using ChatchatGpt.  From the start, iA gave me three ways to go, I forgot the first one, second one was powerQuery, since it was an excel sheet.  The last option was iA could write a VBA for me to automate.  

At first, I used powerQuery to do text to column.  But for some reason, it failed, because some pricing appears like this: 231,356,087.  power Query reconize some of this as 1 number, rather than 3 different numbers, although the delimiter is comma.  I eventually solved this issue with manual operation using excel's build-in function text to columns.  Then I started to use powerQuery to split the weight, this one was very easy.  But for some reason, iA told me to unpivot while highlihgting the SKU column.  Then I got a data range called long format, which is a name I learned today from dipsik. 

" In the context of data analysis and statistics, a "long-range dataset" or "long format" refers to a dataset where each row represents a single observation or measurement, with multiple observations or measurements for the same entity (like a person, place, or thing) stacked in separate rows. "


But I feel it might be helpful down the road, for some reason unknown to me.  Anyway, the rest of the 3+ hours, I got lazy, so I just tell ChachatGpt to give me a VBA code to automate everything, like give me a converted weight column, since spreadsheet does not recognize mg, g, ug, we have to use one unit to really compare the weight.  It was not smooth sailing, iA gave a few VBA codes, but some failed, some work partially, until I thought it worked.  Then I asked if we could make the attributes, like price, price2, and size.1 and size.2 to correspond with heaviest and most pricy and second heaviest, and second pricy.  That was the one task I could not finished last night.  iA kept gave me VBA codes, I kept trying to give it feed back on the codes.  Until 1230 am, I found a huge error.  Previously I thought the converted weight was correct, I am not sure if it's because all those VBA codes for correct re-labeling attributes, or it was just wrong beforehand.  The ug had failed to convert to mg.  That was the last straw of the night.  I gave up and turned in.  

I tried it again this afternoon at work.  I used dipsik at first and was really impressed by the interaction with it, especially when it guided me to debug the problem of converting ug to mg.  Though I tried and tried, and dipsik was extremely patient, I myself lost patience and found a cheating method to bypass the error.  Even now I am still wondering just why can't I convert ug to mg...  

But after the bypass, I could not engage with dipsik again.  I felt the instruction was kind too simple and bland.  I think it must have something to do with my prompt.  Anyway, I jumped back to chachatGpt.  it has the same problem like dipsik.  The instruction seems very unclear and vague, I had a hard time to follow it.  I found last night's chat, it has a lot VBA codes.  I decided to follow that chat.  Also I forego the manual process, I asked iA for VBA code like last night.  This time, he gave me about 3 wrong codes, I told him each time, what's wrong, what the error message was saying, which code did the debug highlight.  Eventually I got a code that worked!!  That's another 3 hours passed.  The finality was to pivot the long form range.  After a tweak of the datatype, change the Value column of mg, ug and pricing to text.  I got the table I wanted.  I was so happy I went and told Emily.  Emily even came over to take a look.  Though I know it's a polite thing to do, I appreciated her effort.  


Anyway, I still need to check the sheet tomorrow to make sure it is correct.  lol  


8 hours working on a sheet is really kind dumb.  But considering that I know very very little about power query, VBA and other stuff.  The amount of things iA did was amazing.  It was not in anyway perfect, in fact, it did a lot of trial and error.  Of course, there's problem with the prompts that I gave.  But if it just me, I know it will not work with 100 hours.  iA really is quite amazing under the right hand.  I think.  

Tuesday, February 04, 2025

can't sellp

 for some reason I cannot sleep.  I know iK now, I just watched too much youtube before sleep again.  


What am i thinking.  I am thinking I am going to leave my current work.  but not sure where can I go.

I looked at jobs every time I am depressed.  that i cannot do, this i am not qualified to do.  Not sure where to go.  Probably going to stay here until I got fired.  


don't feel like reading, do'nt like watching movies, don't feel like recording.  I just felt in a rut, in a rut


uncle brough 4 zongzi today.  


 

Sunday, February 02, 2025

D77 and David

 Just finished watching a press conf. with Jkidd (Coach) and NicoH (PM).  

I, like most people, feel it's a very bad move.  It's  basically really a "PM does not like the player scenario"...  The PM keeps talking about "culture", and the journalists were baiting him to talk about what Luka brings to the "culture".  A comment below saying that Mavericks hired a Laker fan, is hilarious.  One video compared the scenario to the ZionWilliamson,  but it's hardly anything like it!?  Zion failed to be an impact, but Maverick has in deep post season run every season since Luka.  It's not just demoralizing to the fans, also to the whole team!  I wonder what Klay is thinking right now.  

Some videos showed a very short clip of the PM took away Luka's beer last year in a post season celebration of a win.  This sentiment must have gone on for quite sometimes.  I think bar from a serious injury, this move is good for Luka.  I really hope this inspired him to make to the top though I felt laker is not bad, thought not great either.  But if LBJ could work with Luka, I think it can work wonder.  

As for the Mavericks, they have a long list of injuries, including the two new players from lakers.  And I feel that Kyrie would be their main offense focus.  Though they increased their inside presence in theory, which really is like the Wolfes last year, their imaginary focus is really Danvers.  I kind doubt their scoring ability.  Don't forget Kyrie is also injury prone.  The usage rate of KI will increase after Luka left.  Laker without the rock solid LBJ, their ranking won't be that high with only AD.  

I would like to feel that PM is an old timer, so it's like it's either my way or highway.  If it's the truth, then I can understand, win or lose.  But if it's really like some conspiracy theorists out there saying it's NBA's under table dealing to raise viewing rate.  This would be so sickening.  




 以後不知道要過多少時候才能夠再有這樣的享受,躺在微涼的清潔的被單裏看小說,點著淡秋香綠的三角形小台燈。從前在報上看見一家茶室的廣告,說“冰燈柔和,”這盞燈也就是這樣的,像玻璃杯裡還沒溶化的冰塊,淡綠的果子汁已經喝光了,她站起身來就好走了。——張愛玲《異鄉記》(手稿中刪去的句子)


錄自文茜的世界

What's on my mind

 What's on my mind?  

  • Once I started to type, my mind went blank.
  • Mom
  • Today is really  cold, 6F...  
  • my sister
  • I am going to stop correcting my typing.  I am afraid it will block my thoughts
  • i just corrected twice on the last two sentences.  
  • i felt very lonely at work.  
  • this is strange situation where I felt everybody is talking to Emily, not me.  but of course I always put myself in bad situation.  my communicative ability is my downfall.
  • of course, Emily handling most of the email and and communicative with the support and accounting.  
  • i really don't want to talk about work.  
  • I asked ChandaaB to be my reference, trying to apply to other work.  
  • I know though my disappointment for the work must be myself, not the work itself or its environment.  If I go to other places, it's still be disappointment.  But just so  that I could switch to a different thing and environment is good.  
  • Not going to get that work though.  
  • still talking about work.  pathetic
  • Emily is going to Florida
  • Sophia, her mom is going too...  
  • what's the point?
  • it's 7:24 am 1/25/2025.  Mom is still in bed.  That's a good thing! 

Saturday, January 18, 2025

clouds pass through the mind

 我最近看了 GodzillaMinusOne and Furiosa:AMadMaxSaga.  And I love them both very much.  GMO is the second viewing.  FAMMS is the first, but then, I watched a second time in one week.  2.5 hour does not feel long at all!  很後悔沒有去電影院看!  還好 GMO 是在電影院看的。  


I watched AlienRomulus as well.  我覺得還不錯, 夠噁心,尤其是結局出現的怪物。  這一次很多的布置真的向第一集致敬了!  另外,做兄弟的機器人這個角色令人害怕, 他給我一種很不確定的感覺。  不過, 我想我不會再追異形這個系列了。  讓它保持在第一和第二集就行了。  


在Flow還沒拿獎的時候我就想去電影院看了。  但是,吝嗇小氣沒去。  到現在我還是等光碟吧。  


I read SavingEmma, by AllenEskens.  I still remembered I had fun reading his novels, so I went and get the book in library.  It was not a disappointment.  The author has a way to make you care for the character.  But most importantly, the thrilling scenes were written like a movie scene, very visual, very tense.  I still don't think the mystery part is anything special.  But the description and connection of people and thrilling scenes were so good.  


I used chatgpt to write a code for one of my sheet.  油管上有一個影片正好是和我想要做的很類似, 我就邊看邊照著他的問題去問 Chatgpt。  還滿成功的。  後來一度還用了點 gemini.  但是後來又回去用 Chatgpt.  也許我也可以用 Chatgpt 來修改我的 Daily pick .  不過我最想用的是把 receiving record, Backorder record, 還有 daily shipping record 給連起來。  


Mom was going through hell right now.  She is not sure if she's going to do the treatment or not.  I am waiting for my sis to tell her that she should not go through the treatment.  For I think she can explain better.  This brain Atrophy of leqembi really should get poeple's attention.  Otherwise it makes us feel like we are a little lab rat!  Mom's not sleep well this week.  Maybe I should tell her.  


I borrowed 3 books, 1 on my cellphone, I read none so far.  I came home from work, and I am so tired.  Not from doing a lot of things, but rather just busywork and very disconnected.  It feels like  I am stuck in a rut.  



Saturday, January 11, 2025

Quote of the day

 “Today as always, men fall into two groups: slaves and free men. Whoever does not have two-thirds of his day for himself, is a slave, whatever he may be: a statesman, a businessman, an official, or a scholar.


― Friedrich Nietzsche

Monday, December 09, 2024

工作上的白日夢

 

Backorder brainstorming


I feel that backorder tracking is one of the most important part of my job.

In fact, if you go and look at indeed, procurement is basically one of the hottest job there. Some job titles includes purchasing manager/coordinator, Material Planner, Logistic assistance – Procurement...etc.


A lot of time, it requires some planning, data analyzing, even some vendor negotiating. I am not saying that it’s an exciting job. I am simply saying that it’s an important job in any organization.


My company has made streamlined the process to a point that, nobody talks about it. Which is really perplexing to me.


I consider my main job as data collector for the company. The reason being that my team manages at least three google sheet everyone is relying upon. The first is Daily Summary, basically our record of shipment. The second is Product Sort, basically a receiving record of shipments from Vendor. The third one is Requested List for BJ, basically a Backorder record. There are other sheets we are collecting and use. But those three are the most essential. We cannot operate with them, especially for the Order team and Customer service. But as you can see, for the shipping and receiving, we should be able to get from QB. And for a lot of times, we’ll get S&R info from QB. But QB does not have lot numbers. QB does not really say why something was not shipped. We would note why something was not shipped in Daily Summary. There are notes from vendor about the product we received that were not noted in QB, especially when QB really does not have an effective way to receive products.


The Requested List for BJ, our third sheet is so vital to our operation that, if we forgot to put an out of stock item in the list, we would forgot about it for 3-4 weeks until customer inquired about ETA of their items. Then, we would sometimes made up excuses and let them wait another 2-3 weeks (hopefully), and put a rush order to vendor. The other thing is the RL is not linked to Product Sort, our receiving record. So we have no idea if the items we requested was fulfilled by the vendor. It was last week that David inquired about 2 items, which we requested, but vendor never sent to us. That order was almost 2 months ago.


I know that Chandara made a sheet to tracking some of the orders, at Kevin’s request. But it was a very tedious job to compare the receiving list and backorder list. And I feel it’s a highly ineffective way of doing things.


One of the hurdles is that those 2 so called “lists” are not really lists, at least not a “whole: list. Their setup reminded me of “Forms”. At Mascon, Annie used to give us those forms with receiving information on them, printed on papers. They usually contains shipment information, like tracking, how many boxes, how many items to receive. It also contains a date of shipping and a date of receiving. So in the google sheet, each shipment is a range of it’s own. They are visually separated, very easy to read which shipment contain which item. But it’s not a database, or a whole list. The RL is a very similar setup. But it separates mostly by date we put the request in.


I am wondering if we could setup a form in the first page, then setup a database in the second page by collecting the first page. This is the whole purpose of the whole writing. LOL.


I tried to compare the receiving list to the backorder for a while per Kevin’s request. I used countif function to compare. If the result is more than 0, then I know a backorder is fulfilled. If the value is 0, then we never requested the item. I do not know why vendor sent us then.


That seemed easy enough. However, I can not find a way to do it efficiently. It is dumb. There must be a way to streamlined the process. And I feel that it is so dumb. I stopped doing it. It’s dumb that throughout a whole year, we might request one items a few times, and I have to mark the item everything I did the comparison. Otherwise, I am not sure which requests get fulfilled. Sure, if I am persistent enough, this might work. But I am not. Because I keep thinking there must be a better way. A better way to compare, a better way to mark which item is fulfilled, a better way to track if vendor sent us something we did not requested, and a better way to find which item vendor forgot to ship.


The other thing about Request List is that I need to know the standard size or format for the item before I could request. There are couple times where, the item is in lyophilized form, and the size was a micron gram or mg, but I did not know. I simply used a standard requested size, 1ml, which implied a liquid format with buffer. But I think I can resolve it by extracting info from product information sheet.



The most important thing is how to link the Receiving list and Backorder. No, the most important thing is to make the two lists into 2 complete datasets. I do have a list of compiled Receiving list, I used for drop down menu for lots in my pick list, which I used for picking.