{"id":534,"date":"2011-06-16T23:36:21","date_gmt":"2011-06-16T21:36:21","guid":{"rendered":"http:\/\/blog.railsware.com\/?p=534"},"modified":"2024-02-12T20:05:53","modified_gmt":"2024-02-12T17:05:53","slug":"engineering-background-to-help-a-ceo","status":"publish","type":"post","link":"https:\/\/railsware.com\/blog\/engineering-background-to-help-a-ceo\/","title":{"rendered":"Engineering background to help a CEO"},"content":{"rendered":"\n

While my engineering background (9 extensive years of daily coding and 4 years of software producing\/tech leading\/management\/sales) is essential to my job as a CEO of an engineering company, that isn’t what I want to focus on today.<\/p>\n\n\n\n

Through the course of my day as the CEO of Railsware<\/a>, I have to consume and produce immense amounts of information. Because of this, it becomes very handy to be able to keep up with it via some engineering magic.<\/p>\n\n\n\n

A regexp here, a JavaScript bookmarklet there. A firebug inspection for this, a line of Ruby code for that, and, finally, a bash trick over there.<\/p>\n\n\n\n

Today, I wanted to share a simple issue resolution. I’m to mirror my Excel spreadsheet (rotating data by turning rows into columns and vice versa).<\/p>\n\n\n\n

A quick search for Microsoft Excel revealed a transpose feature in special paste. However, being an Apple aficionado, I use Numbers – so no transpose.<\/p>\n\n\n\n

What should I do? Copy\/paste by hand? No way! Instead, I turn to Ruby, always a piece of cake. And so it was. Two minutes of Numbers menu\/search browsing plus seven minutes of Googling vs. 2 minutes 23 seconds of coding (code snippet below).<\/p>\n\n\n\n

data=\"\";data_reverse=[]\nputs \"past your tab separated data and finish with \"\nbegin data << gets end while data[-2..-1]!=\"n   data.split(\"n\").each{|l| l.split(\"t\").each_with_index{|v,x| (data_reverse[x]||=[]) << v} }\n\nputs data_reverse.collect{|line| line.join(\"t\")}.join(\"n\")<\/pre>\n\n\n\n
So, my dear fellow CEOs, CFOs, and C*Os from all around the world, learn to code \u2013 it will save you a lifetime!<\/p>\n","protected":false},"excerpt":{"rendered":"
While my engineering background (9 extensive years of daily coding and 4 years of software producing\/tech leading\/management\/sales) is essential to my job as a CEO of an engineering company, that isn’t what I want to focus on today. Through the course of my day as the CEO of Railsware, I have to consume and produce…<\/p>\n","protected":false},"author":39,"featured_media":16937,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"inline_featured_image":false,"footnotes":""},"categories":[5],"tags":[],"coauthors":["Yaroslav Lazor"],"class_list":["post-534","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-management"],"acf":[],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t