tech

geek tech

i was working on a spreadsheet for a customer and it had over 6000 cells in it. every single cell had a leading space. after much searching on google, i finally found the correct answer, and here it is.

  1. ctrl + f to open the search and replace dialog box
  2. enter ^[:space:]+ into the search box and leave the replace with box blank
  3. done!

 

so the other day i had to import an address book from windows live mail into gmail. the issue was that every time i did an export from windows live mail, it would mess up the csv, so when gmail read it it imported all the email addresses and data into the notes field. however, gmail could import a .vcf just fine. so i exported all the contacts to .vcf format and dumped them into one folder. then ran copy /B *.vcf all_in_one.vcf. this copied all the .vcf’s into one file. i was then able to import the file into gmail no problem.

i needed a power supply calculator the other day and found this one.

 

eXtreme power supply calculator lite v2.5

 

its awesome, i was able to calculate the wattage used for my server in a matter of a minute or so.

sweet home 3d is one of the best home design programs i have used. its interface is incredibly simple, easy to use and intuitive. within minutes of installing the program i was able to input the dimensions for my basement and create an outline and 3d walkthru of what i wanted to do and show my wife. this application has made home design amazing. if you or someone you know is planning on building, remodeling, or just moving around the living room, i recommend downloading and installing this program.

its available for linux, mac and windows. i have used both the linux version and the windows version. both run flawlessly. you can download it here.

here is what i was able to put together in less than 30min. as you build the walls on the blueprint window, the program automatically generates a 3d overhead view of whatever your working on. you can change between an aerial view and a virtual walkthru.

[SinglePic not found]

a good place to go for free tech support. ask a question and typically within 24 – 48 hours it will be answered!

free geek squad

this is an amazing video. it reminds me of the at-ats from star wars. only much for versatile.