“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.”
―
random thoughts on random things that pass through my life randomly...
“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
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.
我看了兩部電影, 一部是 Monkey Man, 另一部是 Civil War。
MonkeyMan, 是一部動作片。 但是電影前半段很慢。 到最後卅分鐘變得非常快,一系列的動作過程, 很熱鬧,利用了很多搖晃鏡頭,讓我想到 Borne 系列。 當然也有很多鏡頭讓很像 JohnWick。 有許多動作鏡頭滿暴力的。 雖說前半段讓我感覺很慢, 而且許多回憶的場景讓我感覺累贅, 但是我還是滿喜歡導演嘗試灌注更深的主題去豐富動作片的感情。 雖說我覺得不是很成功。 其實這部片子有點泛政治, 但現在很多電影都這樣。 其實, 我以前三個白癡, laagan, 也都帶有一些類似的題材。 但是,這次的政治題材卻感覺很貼近眼前的現實。 想是一部新一代印度人的一部份想法。 說到底這部電影的故事是一個復仇劇。 我覺得還可以, 只是可以再縮短一些。
CivilWar, 是一部描寫如果現在美國內戰的話, 將是啥樣? 這是我還沒看的想法, 但是看完後,電影的收尾讓我稍稍不確定一些。 電影的過程其實都還滿讓我好奇的。 想知道最後會怎樣。 但是電影的收尾讓我感到電影的主題對媒體人的描寫也很血淋淋的。 電影呈現許多恐怖的場景, 這種警示令人怵目驚心。 但是到最後, 記者的冷酷也令我很難吞嚥。
書: the song o the cell by suddharthaMukeherjee
The universalCell:
Schleiden and Schwann established the first 2 rules for the cellular theory:
Cytokines, 中文名稱是 細胞激素,又名細胞因子、細胞活素、細胞介素、細胞素,一組蛋白質和多肽,生物中用做信號蛋白, 在細胞間傳遞訊息。
Interleukin 中文名稱是 白血球介素,一組細胞因子。
Cellular therapy, 中文名稱是 細胞治療
Physiology, 中文名稱是 生理學。是生物學的一門領域,研究生物體及其各組成部分,在活體系統中化學和物理的功能活動。
I am reading a book, theSongOfTheCell. So I intend to write down some notes here. Don't ask me why I am reading the book. I do not know why. Though I regret that when I was reading this author's the other book, theEmperorOfAllMaladies, I did not thought of jot some notes down.
So far only prelude, intro, and Part 1, 1.1the original cell, 1.2 the visible cell, 1.3 the univseral cell.
Those parts are talking about the discovery of the cell fist through the technological innovation. Then, by using technology, which helped human see far beyond our physical capability.
Some significant people that appeared, Antonie van Leeuvwenhoek, Rober Hooke, Rudolf Virchow, Matthias Schleiden, Theodor Schwann, Andreas Vesalius, Francois-Vincent Raspail,
工作愈來愈少。 當然因為這是暑假, 但是,這麼少似乎沒有過。 如果在辦公室上班的話, 要挑的貨少, 再加上關鍵的資料輸入和影印標籤的過程被簡化, 而造成工作減少,那就算了。 但是現在連在家工作的日子都沒有啥工作。 我覺得太誇張!
我覺得我跟的同事完全沒有交集。 我本來在簡化了一些工作過程後, 想秀給他們看,他們也可以給點意見或者說他們也可以這樣做。 但是, 沒有, 他們表現得就是這些和他們無關。 我滿懊惱的, 因為說和他們無關, 就讓我感覺我和他們不是同一組的。 不過我後來想到之前在增加盒子的時候, C 有一本簿子本來是要記錄所有盒子的內容, 但是當時, 他倆一組,我一個在一邊也沒有加入他們的行列。 另外, Nara 總是說我對他們愛理不理的。 這種種的跡象顯示問題真的在我這裡。
不過我現在對自己的問題不是以上這個, 而是當我在家工作, 卻沒有工作, 我做啥? 這是一個堆積了很久的問題。
I really went after other AllenEskens' books. And again, in a quick succession, I finished
The deep dark descending
The heaven may fall
The forsaken Country
It feels amazing. I think I finished the last one about 2 weeks ago, or maybe a week ago.
Those dark descending and forsaken country is not a mystery, they are more like a thriller, where, you know who bad guys are. Heaven may fall has more mystery to it. But its ending gives me such a thrilling pulsation! The ending chapters of forsake are wonderful as well.
The dark descending is probably the weakest one for me. I guess I am impatient of the inevitable result. But I do like the detective work in finding out who the killer is. I feel the relationship between nikki and max was pretty interesting. I feel I see reacher in max's shadow, albeit a bit tamer. However, when the forsaken country comes along, I feel Nikki and max relationship became the weak spot in the book. I don't feel the romance between a man and a woman, but a genuine emotion between colleagues, or even a different brother and sister relationship. So when the FC came along, it feels awkward to me.
I always feel that too many explanations is a waste of time. Though I am at fault so often nowadays. But I feel I was very wrong after I read the endings of both heaven may fall and FC. I feel the thrills come from that readers knowing the relationship between each characters so well. Though the authors keeps telling reader, which is moi, the relationship between each characters again and again, to the point I feel redundant. But when the ending shows up, the weight of the situation it created is tremendous.
I wonder if there's a chinese version of the book, or the series. I wonder how it would come about?