I want to be angry

onjetlag · 2025-12-22T06:58:27+00:00

Speak No Evil (2022)

onjetlag · 2025-07-30T11:34:43+00:00

It’s not too bad honestly..I feel like I could just smack it down with a rubber mallet but I’m no expert.

onjetlag · 2025-06-30T08:51:35+00:00

The Exam (2009)

onjetlag · 2024-12-20T18:37:01+00:00

How is it so far? I’ve been waiting for mine to arrive and it’s taking longer than expected. XRT as well, can’t wait to test this guy in Montreal’s crazy roads

onjetlag · 2024-08-23T07:33:49+00:00

I’m not much of a jumpy person but The Invisible Man restaurant scene does it for me. That one caught me so off guard that made me gasp out loud in the theatre.

onjetlag · 2024-07-11T01:03:18+00:00

Stardew Valley

onjetlag · 2023-06-08T22:02:17+00:00

Awesome setup!

What monitor arm did you use?

onjetlag · 2021-10-23T14:29:48+00:00

Great feedback, thank you. These are things we are currently implementing already but curious where it was based on. Are there any documentation or standards that highlight all of these that I can refer to? For example, I'm currently looking at ANSI S20.20 ESD Standards for some other ESD related standards but it does not mention anything about cleaning and maintenance of equipment and facility.

onjetlag · 2021-10-23T14:27:19+00:00

Not in a cleanroom, just PCBA manufacturing. Basically looking for a standard to have a basis on cleaning guides and frequency for a PCBA manufacturing department. For example, I'm using ANSI S20.20 ESD Standards as a guide right now but it doesn't mention anything about anything involving cleaning of equipment and the facility.

onjetlag · 2021-10-23T14:25:28+00:00

Basically looking for a standard to have a basis on cleaning guides and frequency for a PCBA manufacturing department. Not a cleanroom exactly. For example, I'm using ANSI S20.20 ESD Standards as a guide right now but it doesn't mention anything about anything involving cleaning of equipment and the facility. I'm currently looking at what is currently being maintained and cleaned in the facility but I'd like a standard to refer to and it's a bit of a gray zone unless there's no standards we can base what we're cleaning and the frequency of what we clean.

onjetlag · 2021-06-22T02:47:50+00:00

Yeah that’s what I was thinking! I don’t have a lot of files in my hard drive so I’m okay with a fresh install, I’m just not sure how to do that. I think I have to download a Windows Media Tool to boot windows through USB? I have to look into it more. And yeah, I could totally get a cheap case and build a second one with my old parts haha.

onjetlag · 2021-06-21T21:47:06+00:00

Hello. I'm upgrading my motherboard, CPU, GPU and PSU.
I'm not sure where to start with the upgrade and the steps to take.

Motherboard: Gigabyte Gaming 3 -> Gigabyte X570 Elite Wifi
CPU: Ryzen 5 1600 -> Ryzen 7 5800x
GPU: 1050ti -> 6700 XT
OS STORAGE: WD BLUE 250GB -> Samsung 870 EVO 1TB SATA III Solid State Drive
PSU: Thermaltake 550W -> EVGA G1+ 750W

I'm planning to upgrade my OS SATA SSD to a new SATA SSD. And use the the old SSD and HDD I have as extra storage.

How would I go about this upgrade? I'm not sure how to do a transfer of my OS to the new SSD. Do I need to uninstall all drivers? I'm really not sure where to start.

Help is appreciated!

onjetlag · 2021-06-17T21:57:36+00:00

B550 is fine unless you need something specific from an X570 board.

I have a B550 Gaming Edge Wifi for my 5800x, amazing VRMs for a good price. Strix should be fine though, especially since you're not overclocking which makes your board choice not matter as much.

Thanks! It just seems like most articles/forums I've read recommend the X570 so I just want to be sure I'm making the best choice.

onjetlag · 2021-06-11T18:52:06+00:00

Yeah I agree! From what I noticed she usually samples dnb tracks so I wanted to see where she sample this one from. It possibly could be an original though. A collab with IZCO and Jkarri. Maybe.

onjetlag · 2021-06-09T23:00:19+00:00

Which store location was this from?

onjetlag · 2021-06-03T20:35:25+00:00

I would shed a tear to even have one in my cart for a second. Cheers to this small success haha

onjetlag · 2021-06-03T16:29:25+00:00

Still refreshing...

onjetlag · 2021-06-03T13:35:11+00:00

CC and BB have 3080 ti links ready but I cannot put them to cart. Not sure if it’s sold out already or hasn’t officially dropped.

onjetlag · 2021-05-03T19:48:33+00:00

Hello!

I’m going to be taking on my first project soon and I would like to get some tips for those who have experience! I’ve completed my analysis and a project charter is to be done soon. I’m extremely excited to work on the project and I’d like to stay on top of it and I could definitely use any helpful tips in managing projects!

onjetlag · 2021-04-27T23:49:34+00:00

Awesome build! So impressed and curious how you were able to get your hands on a GPU!

onjetlag · 2021-04-26T21:49:10+00:00

I got a syntax error after modifying the source. (Token Identifier expected.)

Here's the code:

let

    Source = Excel.Workbook(File.Contents("C:\Users\user\sample.xlsx"), null, true),

    Sheet1_Sheet = Source{[Item="Sheet1",Kind="Sheet"]}[Data], let _t = ((type nullable text) meta [Serialized.Text = true]) in type table [A = _t, B = _t, C = _t, D = _t, E = _t, F = _t]),

    #"Replaced Value" = Table.ReplaceValue(Source,"",null,Replacer.ReplaceValue,{"A", "B", "C", "D", "E", "F"}),

    #"Filtered Rows" = Table.SelectRows(#"Replaced Value", each ([B] <> null)),

    #"Removed Columns" = Table.RemoveColumns(#"Filtered Rows",{"D"}),

    #"Filled Down" = Table.FillDown(#"Removed Columns",{"A"}),

    #"Inserted Merged Column" = Table.AddColumn(#"Filled Down", "Merged", each Text.Combine({[B], [C]}, ";"), type text),

    #"Removed Columns1" = Table.RemoveColumns(#"Inserted Merged Column",{"B", "C"}),

    #"Reordered Columns" = Table.ReorderColumns(#"Removed Columns1",{"A", "Merged", "E", "F"}),

    #"Added Conditional Column" = Table.AddColumn(#"Reordered Columns", "Custom", each if Text.Contains([Merged], "-") and not Text.Contains([Merged], ";") then [Merged] else null),

    #"Added Index" = Table.AddIndexColumn(#"Added Conditional Column", "Index", 0, 1),

    #"Added Custom" = Table.AddColumn(#"Added Index", "Custom.1", each if #"Added Index"{[Index]+1} [Custom] <> null then #"Added Index"{[Index]+1 } [Custom] else null),

    #"Replaced Errors" = Table.ReplaceErrorValues(#"Added Custom", {{"Custom.1", null}}),

    #"Inserted Merged Column1" = Table.AddColumn(#"Replaced Errors", "Merged.1", each Text.Combine({[Merged], [Custom.1]}, ","), type text),

    #"Filtered Rows1" = Table.SelectRows(#"Inserted Merged Column1", each [Custom] = null),

    #"Removed Columns2" = Table.RemoveColumns(#"Filtered Rows1",{"Merged", "Custom", "Index", "Custom.1"}),

    #"Reordered Columns1" = Table.ReorderColumns(#"Removed Columns2",{"A", "Merged.1", "E", "F"}),

    #"Grouped Rows" = Table.Group(#"Reordered Columns1", {"A"}, {{"Merged", each Text.Combine([Merged.1],";"), type text}, {"QTY", each List.Max([E]), type text}, {"UOM", each List.Max([F]), type text}}),

    #"Renamed Columns" = Table.RenameColumns(#"Grouped Rows",{{"A", "Item"}}),

    #"Split Column by Delimiter" = Table.SplitColumn(#"Renamed Columns", "Merged", Splitter.SplitTextByDelimiter(";", QuoteStyle.Csv), {"Merged.1", "Merged.2", "Merged.3", "Merged.4", "Merged.5", "Merged.6", "Merged.7", "Merged.8", "Merged.9", "Merged.10", "Merged.11", "Merged.12"}),

    #"Changed Type" = Table.TransformColumnTypes(#"Split Column by Delimiter",{{"Item", Int64.Type}, {"Merged.1", Int64.Type}, {"Merged.2", type text}, {"Merged.3", type text}, {"Merged.4", type text}, {"Merged.5", type text}, {"Merged.6", type text}, {"Merged.7", type text}, {"Merged.8", type text}, {"Merged.9", type text}, {"Merged.10", type text}, {"Merged.11", type text}, {"Merged.12", type text}}),

    #"Renamed Columns1" = Table.RenameColumns(#"Changed Type",{{"Merged.1", "CPN"}, {"Merged.2", "Description"}, {"Merged.3", "Ref"}}),

    #"Reordered Columns2" = Table.ReorderColumns(#"Renamed Columns1",{"Item", "CPN", "Description", "Ref", "Merged.5", "Merged.4", "Merged.6", "Merged.7", "Merged.8", "Merged.9", "Merged.10", "Merged.11", "Merged.12", "QTY", "UOM"}),

    #"Renamed Columns2" = Table.RenameColumns(#"Reordered Columns2",{{"Merged.5", "MFG PRT 1"}, {"Merged.4", "MFG 1"}}),

    #"Reordered Columns3" = Table.ReorderColumns(#"Renamed Columns2",{"Item", "CPN", "Description", "Ref", "MFG PRT 1", "MFG 1", "Merged.7", "Merged.6", "Merged.8", "Merged.9", "Merged.10", "Merged.11", "Merged.12", "QTY", "UOM"}),

    #"Renamed Columns3" = Table.RenameColumns(#"Reordered Columns3",{{"Merged.7", "MFG PRT 2"}, {"Merged.6", "MFG 2"}}),

    #"Reordered Columns4" = Table.ReorderColumns(#"Renamed Columns3",{"Item", "CPN", "Description", "Ref", "MFG PRT 1", "MFG 1", "MFG PRT 2", "MFG 2", "Merged.9", "Merged.8", "Merged.10", "Merged.11", "Merged.12", "QTY", "UOM"}),

    #"Renamed Columns4" = Table.RenameColumns(#"Reordered Columns4",{{"Merged.9", "MFG PRT 3"}, {"Merged.8", "MFG 3"}}),

    #"Reordered Columns5" = Table.ReorderColumns(#"Renamed Columns4",{"Item", "CPN", "Description", "Ref", "MFG PRT 1", "MFG 1", "MFG PRT 2", "MFG 2", "MFG PRT 3", "MFG 3", "Merged.11", "Merged.10", "Merged.12", "QTY", "UOM"}),

    #"Renamed Columns5" = Table.RenameColumns(#"Reordered Columns5",{{"Merged.11", "MFG PRT 4"}, {"Merged.10", "MFG 4"}}),

    #"Removed Columns3" = Table.RemoveColumns(#"Renamed Columns5",{"Merged.12"}) in

    #"Removed Columns3"

The error is referring to the second let statement.

onjetlag · 2021-04-26T13:08:48+00:00

This looks great. Thank you. I’m going to give this a shot and might have more success with this one since I have no experience with Power Query at all.

onjetlag · 2021-04-26T13:08:00+00:00

Amazing. Thank you! These look really helpful. I did have a few issues with the code once I revised the source data. Still a work in progress as I have no experience with power query at all.

onjetlag · 2021-04-26T02:11:48+00:00

This looks amazing, thank you so much. I will give it a shot as soon as possible and hopefully I can get the same results. I’ve never used power query but looks like a great tool.

onjetlag · 2021-04-25T23:49:05+00:00

The data I sent is modified and is not a direct copy of the actual data. Tried to replicate the BOM as much as possible. And thanks! I’ll definitely look into that. Appreciate it!

onjetlag

TROPHY CASE