Read more at the tech community blog announcement here.  It looks like some of the ideas that OlivierCC has had available over on GitHub for 2 years are finally making their way into the Office 365 ecosystem!  Here is a link to his sampling of SharePoint Framework /SPFx webparts. 

So saying the use of JSON scripts (even if just copying and pasting) is "no code" has always seemed a little weaselly to me.  now / Soon, some types of column formatting in SharePoint will be able to be done through the UI in a more user-friendly manner. This hits targeted release folks in December, and general availability in January.  In the article, you can try it out through a demo. 

Check out our new interactive Office 365 page for information to help you understand the myriad of apps and licenses available, from small business to corporate enterprises.  

 - I don't blog frequently, but when I do, it's appreciative.
​I missed an important anniversary earlier this year; Paintrock Consulting Services, LLC, had its 5th year anniversary!  And it wouldn't be possible without each of the people and businesses I've had the opportunity to work with, and one business who offloaded a job to me (Thanks, Tiffany!).  

I think my favorite thing about being a consultant (besides being self-employed) is that I'm able to work across a great variety of client industries.  Most of them face similar challenges or solution needs, but I've learned so much about the what those challenges are, and the innovative and interesting way companies manage them.    The most beneficial habit that I've gained during this time is that I think about business processes, and efficiency opportunities, anytime I have an interaction with another business - as a passerby, customer, client or collaborator.  

Now I find myself thinking about every step through a transaction or touch point with a business. This one runs a very lean organization; how do they plan and manage inventory so tightly? How can this operation which requires so much labor be automated in other ways to save expenses?  How does that organization manage collaboration across an entirely remote team spread around the globe?  If I'm lucky those lines of thought tend to lead to others.  Such as:  automating these processes more robustly and in collaboration with suppliers would allow the company with tight inventory turnaround to do more accurate forecasting and avoid waste, or wait times for products.  Or, if this entity could coordinate with economic development teams they could participate in fast-track trials for manufacturing evaluation and improvement.  

In short, working across a variety of industries and solutions has resulted in me thinking through things much more thoroughly. Veritically - what are all the components that could relate to this scenario, and how are they related? Sequentially - what is the trigger to kick off this process? How is it resolved? What can be learned by looking at all of them collectively; statistically?  Collaboratively:  how could that entity be unaware of the conflict they have with this other entity if they don't communicate, but are expected to share and collaborate on regulatory information?

I consider this 360˚ Thinking.  And I am a better person for using it. 

New Year
New Month
New Week
​New Day
What potential!

​It's end of year shopping and sale season again!  This is also the time of year that I am frequently approached for guidance on home computer replacement or update shopping.  Over time I've pulled my guidance together into a Computer Shopping Tip Sheet.  This year, I am posting the information on my blog, and plan to keep it updated over time.
 
There are lots of options on computers, and comparing them online or in a store can be time consuming and frustrating.  It’s always best to know essentially what you want before shopping.  This will help you define what will work best for you.  Often when computer shopping you’ll see specs to choose from, and this can often be more  confusing than useful for general home consumers.  The purpose of this post is to shed some light on the information you'll encounter during your search, and to help you make a better-informed decision.

Let's start with an example - you saw a great sale ad for this computer, but it may as well be partially written in Greek.  
Sample Computer Sale Ad:  Dell Inspiron 15 7000 Series: i7, 3.2Ghz, 8GB, 1T HDD, HDMI, DVD, Win10, Black.

Knowledge is Power! So let’s break that sample description down so you can make an informed choice:

• Dell Inspiron 15 7000 series – This is the Manufacturer and Model of the computer.  I just used this make and model as an example.
  
  

• i7 – this is the Processor.  In my opinion, Intel has the Processor market. You may see some that say AMD*, and those used to be equally capable, but no longer.  The processor is the Brain of your computer. If you want your computer to boot up quickly, open programs in a flash, have no lag multitasking, do tasks as soon as you start them, - you’ll want the fastest available, which right now is the Intel i7. Slightly slower is the i5, i3, Celeron. Pentium, etc.  *There are gaming units that use AMD processors very successfully; just depends on your usage needs.
  
  You may see processors described as having multiple cores: 2 (or Dual core), 4 (Quad Core), and more frequently 6 (you guessed it - 6 cores).  Each core within a processor will run at the same speed.  The cores function as a multiplier - so a dual-core 3.2Ghz processor would run slower than a quad-core 3.2Ghz processor. In the Dual core example, your computer functions faster because it’s processing speed is spread equally over two cores, or channels, of your processor. In speed, of course higher is better -  but pricier.  If you want high-speed at lower prices, opt for dual and/or quad.  Most computer processors today have 4 or 6-core processors. If you do any games or activities with graphics (like video editing), you’ll need at least an i5 or quad-core processor.    The evolution of Processors over the last few decades, very generally, is:
  1990s:  Pentium processors (I, II, III, IV, M), Celeron
  2000s: Itanium, Xeon, Pentium D, Intel Core, Pentium Duel Core
  2010s: Core i3, Core i5, Core i7
  
  
• 3.2Ghz – this is actually the speed of the processor, or clock speed.  3.2 Gigahertz is pretty standard.   
  
  

• 8GB -  This is your RAM. It’s a fast memory recall function. Like all the rest, more is faster – but the most common you’ll see is 8G (gigs). More RAM allows you to keep several programs open at the same time, perform equally fast in all of them, loading web pages.  
  
  
• 1T or 1TB – this means 1 Terabyte of memory space to store your files. You’ll see these most often (in order of size and price): 250 GB, 500 GB, and 1 TB.  Here is a good guide:
  250 GB: great if you plan on light usage and will be storing things like documents, spreadsheets, mp3 music, pictures.  500 GB: if you plan on medium usage and will be storing things like: Photography (deep editing), Video (editing), Movies and TV shows, High Quality Music, Basic Games.  1 TB: great if you plan on heavy usage and will be storing things like modern, heavy action video games, multi-player games, HD movies and TV shows, HD Videos.  
  
  
• HDD – this is Hard Disk Drive, and has been the standard for 20+ years.  It is literally a silver disk that has data written onto it by a digital needle and has mechanically moving parts (picture a record player).  Newer on the scene is SSD, or Solid State Drive.  That is basically a collection of flash memory chips within your computer.  SSDs perform faster and eliminate the need for a physical disk, so this allows computers to be thinner and smaller.  SSDs also no moving parts – so are mechanically a little more reliable.  They are a little pricier than HDDs.  In my experience, both have been equally reliable.  If you’re shopping on a budget, HDD will probably be your focus; if your goal is less space and more speed, an SSD would be optimal.  
  
  
• HDMI – this is a video connection description, short for High-Definition Media Input.  Most computers now connect to videos or monitors via HDMI ports. You may remember using their predecessors:  VGA connections – the 9 - 13 – 15 pin connector that you had to screw in.  HDMI is the standard with anything built after 2012.   
  
  
• CD/DVD -  that’s self explanatory but you should know that on new computers, these would be an add-on. Most new units are not built with the CD/DVD drive any longer, since most video renders better through HDMI and people don’t rely on their computers as their home sound system. You will probably see few computer listings that even have DVD.  But, if it’s something that you use or that you need, look for a computer that has this built-in, OR, you can purchase a separate CD / DVD drive.   
  
  
• Win10 or Mac OS X version 10.13 - "High Sierra":  This is the computer’s Operating System.  Typically, you’ll want either Windows (PC) or Mac (Apple).  For Mac operating systems, they are built into Mac computers – so you don’t have as much option for choice or style from varying manufacturers.
  If you’re considering Windows, you’re looking at Windows 10.  Computer manufacturers have been shipping with Win 10 installed since late 2015. If you’re familiar with Windows 7, then Windows 10 will look and feel like a more modern, updated and in some cases simplified version of that.  You may have heard stories about data loss or issues when users with Windows 7 or 8 upgraded to Windows 10 when that option was available.  That won’t be an issue if you are purchasing a new computer with Windows 10 built-in.   
  
  
• Black – color.  Most are silver-ish or black, but neat colors are making headway, although that is usually a little more cost.
  
  
• Bonus: Graphics.  There are two options here: Integrated Graphics (which is like…integrated stereo for music – probably gets the job done, but could be more robust), or Dedicated Graphics.  Dedicated Graphics is basically an extra card/chip in the machine, that has dedicated processing power to rendering graphics for things like editing or gaming.  You may notice sometimes a little pixel blockish-ness if you’re watching something online…that’s an Integrated Graphics rendering.  A Dedicated Graphics card will deliver smoother, faster, cleaner images.  Mid-range is most common, unless you’re really into gaming – then you’d want something with high VRAM (Virtual RAM).  The two big brands here are NVidia and AMD (on the Windows side of things).
  
  
• Ports:  Finally, most new laptops come with 3 USB ports (2.0 and 3.0), 1-2 HDMI ports, audio jack, and SD card slot.  Things you won’t find anymore:  an Ethernet port (the wide network cable that looks like a phone line), CD / DVD slot, 9- or 13-pin monitor port.  But adapters (or dongles) for these are widely available an inexpensive. 

 
Questions to Help You Define What You’re Shopping For

Now that you know some of the lingo you’ll be seeing during computer shopping: Here are the questions you’ll want to answer, and they will help you more narrowly define your choices.

1. Portability:
   Do you want a Desktop or a Laptop?  There used to be the assumption that if you wanted real power, you’d choose a Desktop, and if you wanted to be able to do some of your things on the run, a laptop.  That is no longer true.  With improving technology able to perform more functions in smaller spaces, you can find Desktops (often called Small Form Factor) the size of a regular box of granola bars, or All in Ones that are basically a computer built into a monitor.  If you aren’t picky, typically the same specs in both a laptop and a desktop would render the desktop the better price bargain. If you are looking at a Laptop, you’ll want to consider Screen Size (typically 12”, 15”, 17” or 19”), and whether or not you want a Touch Screen.  These are also called laptop 2-in-1s, and most often allow you to rotate the screen to use as a tablet, or to stand up in a tent-like position for presenting.   
   
   
2. Peripherals:
   Finding units with DVDs may take a little more searching, so it’s important to know if you need one before purchasing a new computer and looking for the DVD slot.
   For things like Printers, many older ones have the 13-pin screw-in type connectors. If your computer has one like this, you probably won’t have much luck finding a Laptop with a VGA (video) connection, and may need to focus on a Desktop.  If you’d prefer a laptop, you can purchase a little connecter that will receive the VGA plug, and have a USB output so it works on a laptop.  Do you need a speaker plug? An SD memory card slot? Several USB ports?  Take a look at your current machine’s back side and see how many things you’ve got plugged in there. You’ll want at least that many in your new computer. 
   
   A note about USBs: you will see information about USB 3.0.  That is the same USB that you’re familiar with, with greater bandwidth for data.  It’s faster than USB 2.0, which was faster than USB 1.0.  USB 2.0 has been the standard for about 15 years, and most machines now will have both.  I recommend using USB 3.0, because that is the new standard that will last several years.
   
   
3. What kinds of things do you use your computer for today? 
   If you use Microsoft Office, for example, you’ll want to consider whether to purchase a computer with Office pre-loaded, or purchase Office separately (this would be a download).  You could also opt for the monthly subscription with Office 365, which comes installed with a free trial on most new computers.  If you don’t need Office, there are other options like Open Office or Google Docs that can do most of the main Office functions.
   
   
4. What kinds of things can you see yourself doing on your computer in the future?
   Some of these things might be: doing more online homework, streaming more videos, HD videos, watching digital tv, maybe some video editing.  Your new computer will need to grow into the things you might do in the next 5 years.
   
   
5. Where do you want to shop?  
   Once you have your computer needs identified, you have purchasing options.  My preference is to look online, (try Amazon, Best Buy, Apple, NewEgg, Dell, Asus, etc).  If you find something that you like online at one location, do a search for that model number to see its prices at other stores - they may try to price-match.  Retailers like Amazon and Best Buy usually provide the same warranty, guarantee, repair and return policies as the computer manufacturer, so your shopping options extend beyond just the manufacturers' websites. – so sometimes (often) they are more economic that way. If you have a membership to bulk stores like Costco or Sam's Club, you can find members-only special pricing.  Wherever you decide to shop, ordering a computer online usually will come with free express shipping.   
   
   
6. What kind of Optics do you want in a Monitor?  
   Whether a new monitor, or for a laptop screen:  HD / 1080p used to be a pricy extra; now it is standard. If you want a sharper, crisper image, you can choose Full HD (a bit more pixel density) or 4K (Ultra HD or UHD). The greater the pixel density, the better the image, but higher the price, and shorter the battery life (if a laptop).

A General Note about Price
​
Here’s what you might expect to find while shopping for Desktops and Laptops in 2017-18, VERY generally:

A General Note about Programs & Files

When you purchase a new computer, you’ll want your existing data and files on your new computer.  This can be easily done, but know that you can only move files you have created – like documents, pdfs, spreadsheets, photos, videos, music, and so on.  You can not move Applications that are installed on your current computer’s hard drive (like Photoshop, MS Office, Quicken, etc). 
 
To get Programs or Applications from your old computer to your new one, you will need to re-install them (perhaps not an option on a new computer without a CD/DVD tray).  Most Programs can be downloaded from their websites, and if it’s something you’ve purchased, you probably have a “security key”, license, or number printed on your installation CD or receipt.  You should be able to Download those programs, and confirm your security number.  
 
In other words:  you can move any CONTENT (docs, images, info) you have created; typically you cannot move the APPLICATIONS that you may have used to create that information.
 
Now that you're an Informed Consumer, it's Time to Start Shopping

Make a Wish List of Options

Once you’ve defined some specifics and some options for your next computer, make a wish list of those items.  It will make your shopping easier, whether online or in person.  You don't have to have a preference defined for each component - keep in mind flexibility provides you with greater options.  With that in mind, I recommend something like this:

Compare Your Choices
 
After defining your preferences and searching for options that might work for you, it's time to Comparison Shop. Use this Computer Shopping Workbook to help compare and contrast your shopping choices for smarter decision-making.  The link will download an Excel workbook, usable also in Open Office or Google Sheets.
 
Happy Shopping!!
 
NOTE:  This blog post and related Computer Shopping Workbook are based on my experience, and are intended as information and tools for general consumer level use only. Neither this blog post nor the sample Computer Shopping Workbook attachment imply any specific product or component endorsements or recommendations.

Do you have any Eureka Moments for computer shopping? 
Please share them or any questions in the Comments section below!