Profile

Work

I am a Full-Stack Web & Software Developer with over fifteen years of experience. Over
countless hours I have discovered that I have a passion and talent for creating works that
are both highly functional and technically sound.

I have also discovered that I have a knack for understanding new theories & concepts –
I am an adamant perfectionist when it comes to just about anything I do.

Current Skill set

Web
  • Responsive Mobile first HTML & CSS3 – Bootstrap, SASS
  • JavaScript (Vanilla JS, JQuery, Angular)
  • PHP (Web Server & CRON)
  • CRM / CMS packages – WordPress, OsCommerce, Marketo
  • MySQL
  • Git
Applications
  • Java
  • Python
Legacy Technology
  • ASP (classic)
  • Visual Basic
  • Adobe Flash
Software Packages
  • Adobe Photoshop
  • MySQL
  • Jet Brains Web Suite
  • Microsoft Word
  • Microsoft Excel
  • Microsoft Access
  • Maya 3d
  • and more…

Study

At the start of 2019, I am entering my 4th year of a 6 year course Studying a Bachelor of
Computer Science with gaming specialisation at Charles Sturt University

Hobbies

Pyrotechnic

A license Pyrotechnician in the state of N.S.W. Australia for over twenty years, performing
professional grade pyrotechnic shows ranging from from Chinese String Crackers, Indoor Close
Proximity Fireworks, Aerial Shells up to 125mm and Aerial Salutes up to 75mm.

A founding member of the Pyrotechnics Industry Association of Australia (PIAA), Based in Sydney
but have performing shows all over NSW for all types of events.

Car Enthusiast

An active member in the Skylines Australia NSW car club I regularly volunteer to help run events.

Social Media

You can connect with me professionally on LinkedIn,
or stalk me through Twitter

Portfolio

Mobile App Portfolio

Tipping Comp


Details

cruizen’


Details

PRODOCOM


Details


Website Portfolio

Tipping Comp


Details

PRODOCOM


Details

PRODOCOM EDI


Details

CeBIT Australia 2010


Details

CeBIT Australia 2011


Details

CeBIT 2010 Exhibitor Portal


Details

HFA / eHealth 2011


Details

HFA / Spatial@Gov 2010


Details

HFA / Spatial@Gov 2011


Details

HFA / Gov2.0 2010


Details

HFA / Gov2.0 2011


Details

HFA / Future-Proofing Your Data Centre 2011


Details

HFA / IT Security 2010


Details

Hannover Fairs Australia


Details

CeBIT Australia Satellite Sites


Details


Custom WordPress Themes

Wizardry Fireworks


Details

Bluewater


Details

Dan Monitoring


Details

Golf Girl


Details

Personal Portfolio


Details


Shops

National Pyrotechnics


Details

iblott accessories


Details


PHP CMS

Dog Metro


Details

OneBody Health & Fitness


Details


ASP CMS

Wizardry Fireworks


Details

SCreaming Rocket


Details

Personal Portfolio


Details


Flash Sites

Personal Portfolio


Details

Personal Portfolio


Details


HTML Sites

Hills Realestate


Details

Paradise Clothing


Details


Promotional CDs

Blog

MS Excel: LEFT() & RIGHT() Functions

Microsoft’s Excel has 2 functions that operate very much the same called LEFT() and RIGHT(), these functions can be used to find a substring within a string.

Understanding the way Excel uses LEFT() & RIGHT()

These formula’s required 2 different inputs; A HAYSTACK and a CHARACTER TALLY.

The formula’s are as follows:

LEFT(HAYSTACK, CHARACTER TALLY)

LEFT() returns the string that follows the left most character. (The beginning of the string)

RIGHT(HAYSTACK, CHARACTER TALLY)

RIGHT() returns the string that preceeds the right most character. (The end of the string)

Using LEFT() & RIGHT()

If I had the string “Ian Blott, Web Developer, Sydney Australia” in cell A1 and I wanted to use the substring that is the first 20 characters i would use LEFT()

LEFT(A1,20)

This would return the value “Ian Blott, Web Devel”

On the other hand, if O wanted to use the last 20 characters of the string O would use RIGHT()

RIGHT(A1,20)

This would return the value “er, Sydney Australia”

Getting Fancy

A few days ago I posted about the SEARCH() function. I can use this in my LEFT() or RIGHT() formula’s and vice versa.

I can use a LEFT() or a RIGHT() inside a SEARCH() to limit the HAYSTACK to either end of the original string.

SEARCH(",",LEFT(A25,10),1)

This wills cause the SEARCH() function to only look for the first comma in the first 10 characters of the string in A1, thus changing the HAYSTACK for the SEARCH() to “Ian Blott,”

SEARCH(",",RIGHT(A25,10),1)

RIGHT() does the same but for the last 10 characters with the effective HAYSTACK being ” Australia”

Side note:

As with all my posts, quite often they are going somewhere and require 2,3 or even 4 different functions to perform the final task. Bellow are the related posts that tell an overall story

Published by
February 15, 2011 11:54 pm

Leave a Reply

Creative

I studied Digital Media for 12 months at Mt Druitt TAFE. While  doing so we studied The 3D Modeling Program ‘Maya’. During the course I produced a number of 3D scenes and a couple of 3D animated movies.

I have also played in other programs such as Bryce 3D, 3D Studio Max, Lightwave, Vue D’esprit and a few others. However, i have always returned to Maya as a personal preference.

Bellow are a number of works that i have produced from these various programs.

Bryce 3D: Balls

Vue D’esprit: Sulfuric

Maya: Living Room

Maya: Gauntlet

Loading...