Author: Larry

Larry's a 40-something chap interested in tramping, being a dork and changing the world via less boring training.

Get country from IP address with JavaScript

This uses the telize site to get a geolocation of an IP address. It's not 100% accurate but fine for country-level location, which is all I wanted. <script type="application/javascript"> function getgeoip(json){ //document.write("Geolocation information for IP address : ", json.ip); //document.write("Country : ", json.country); //document.write("Latitude : ", json.latitude); //document.write("Longitude : ", json.longitude); //document.write("Country: " + json.country);... Continue Reading →

0

When to go Next?

I’m an Instructional Designer by trade. I specialise in eLearning. I care about the quality of what I do and what people think of the profession, and I want to help others improve. So here’s my first professional blog post, focussing on the learner experience. Don’t make them think. My first boss said this a... Continue Reading →

0

Set a SCORM completion in Storyline using javascript

Run this as a 'run JavaScript' in Storyline and you're done-burgers. Storyline 360 (20.03.2018) function findLMSAPI(win) { if (win.hasOwnProperty("GetStudentID")) return win; else if (win.parent == win) return null; else return findLMSAPI(win.parent); } var lmsAPI = findLMSAPI(this); //set score; the first number is the score lmsAPI.SetScore(100, 100, 0); //set status; possible values: "completed","incomplete", "failed", "passed" lmsAPI.SetReachedEnd();... Continue Reading →

0

Find duplicates across columns in Excel

=ISNUMBER(MATCH(A1,B$1:B$20,FALSE)) will return TRUE if the name in A1 is in the range B1:B20. Enter it in say C1 and copy down as far as necessary. If you AutoFilter the data for column C = TRUE you will see which rows to delete. src: http://www.mrexcel.com/forum/excel-questions/55208-identify-duplicates-between-2-columns.html

0

Proudly powered by WordPress | Theme: Baskerville 2 by Anders Noren.

Up ↑