The Lazy Phospho Normalizer!

Okay -- so there are easily a million smarter ways to do this. I know it. However -- I doubt there is a lazier way.

Here is the scenario

You did a global phospho TMT study.
Because this is a time course long enough that trancriptional/translational regulation isn't something you can rule out you also kept the flowthrough (or part of the sample that you didn't enrich) and you also ran it -- ala SL-TMT or something similar.

How do you combine that data?

Like I said -- 100 smarter ways to do it, but last night around 8pm I would have given just about anything for an Excel sheet that said this --

Around 11pm I started channeling that frustration into watching some tutorial videos on the Microsoft Office website and early this morning I woke up and finished this tool that does EXACTLY what I needed last night

You can download it from my Google TeamDrive here.

As it says in the instructions -- if you make something easier and better (or already have one), please let me know. As always, happy to see comments regarding what could be fixed or improved. Can't guarantee I'll actually do it -- as I said -- this does what I want it to do, I'm just putting it out there in case it would help anyone else.

Also, if you're just writing me to make fun of the fact I could do this in R in like 3 seconds, I'll have you know that I've installed 6 copies or R and R studio on this PC and I don't even know which icon on the desktop is the most current one. Keep that in mind. You could do it in 3 seconds, I'd spend an hour -- easy -- clicking the wrong desktop icon. "Where is the one that links to that cran thing..?"

Comments

Eurosatory 2018: Thales lifts curtain on Sophie Ultima thermal imager

At Eurosatory 2018, Thales is taking its Sophie range of thermal imagers to the next level at Eurosatory and presents for the first time Sophie Ultima, a lightweight very high-performance 4-in-1 thermal imager. The new product is ready for connected combat and augmented reality and will help to guarantee tactical superiority both night and day. Read more Thales' new Sophie Ultima thermal imager Read more

Excalibur Army unveils 155 mm TMG EVA 8x8 self-propelled howitzer

The Czech company Excalbibur Army has unveiled its new self-propelled autonomous artillery system with automatic loading of ammunition providing an effective fire by means of both direct and indirect aiming. Its design is based on the 155 mm/52 cal. SpGH Zuzana 2, while overtaking maximum assemblies and design solutions verified within the course of demanding testing and tender trials performed worldwide. Read full news at this link... Excalibur Army's 155 mm TMG EVA 8x8 self-propelled howitzer (Picture source: Excalibur Army) Read more...

Russian Taifun air-droppable armored vehicle prototypes tested

Prototypes of the Taifun air-droppable armored vehicle designed for the Russian airborne force are currently undergoing state trials, Chief of the Airborne Force’s Automobile Service Lieutenant-Colonel Ilya Ivanov said. "Under the R&D work, prototypes have been developed on the basis of the Taifun vehicle and are currently undergoing state trials," Ivanov said. "If the trials are successful, the vehicle will be accepted for operation and its deliveries will start," he added. Read full news at this link... Taifun air-droppable armored vehicle (Picture source: Army Recognition) Read more...

Current Cews

Search This Blog