Skip to content

Instantly share code, notes, and snippets.

@JamesClonk

JamesClonk/google_heatmap_script

Created December 24, 2018 22:42
Show Gist options
  • Save JamesClonk/a9f6face09df5f0fc4431baad7c7cf4f to your computer and use it in GitHub Desktop.
Save JamesClonk/a9f6face09df5f0fc4431baad7c7cf4f to your computer and use it in GitHub Desktop.
Download ZIP
google sheet heatmap
Raw
google_heatmap_script
function CreateHeatmap() {
var startDate = 1545091200000; // 1545091200000
var dataRaw = '{"m":{"1":"start_time","2":"carclassid","3":"trackid","4":"sessionid","5":"subsessionid","6":"officialsession","7":"sizeoffield","8":"strengthoffield"},"d":[{"1":1545105600000,"2":871,"3":250,"4":104207852,"5":25375091,"6":1,"7":16,"8":2262},{"1":1545098400000,"2":871,"3":250,"4":104203565,"5":25374145,"6":1,"7":23,"8":1722},{"1":1545112800000,"2":871,"3":250,"4":104212039,"5":25375962,"6":0,"7":1,"8":2723},{"1":1545206400000,"2":871,"3":250,"4":104266801,"5":25387620,"6":0,"7":1,"8":1278},{"1":1545220800000,"2":871,"3":250,"4":104275158,"5":25389201,"6":1,"7":15,"8":2554},{"1":1545300000000,"2":871,"3":250,"4":104321916,"5":25399709,"6":1,"7":6,"8":1504},{"1":1545307200000,"2":871,"3":250,"4":104327026,"5":25400499,"6":0,"7":5,"8":1923},{"1":1545249600000,"2":871,"3":250,"4":104291975,"5":25392656,"6":1,"7":21,"8":1958},{"1":1545249600000,"2":871,"3":250,"4":104291975,"5":25392657,"6":1,"7":21,"8":1347},{"1":1545249600000,"2":871,"3":250,"4":104291975,"5":25392655,"6":1,"7":22,"8":3613},{"1":1545537600000,"2":871,"3":250,"4":104462743,"5":25431290,"6":1,"7":13,"8":2005},{"1":1545667200000,"2":871,"3":250,"4":104539538,"5":25448858,"6":1,"7":20,"8":3350},{"1":1545667200000,"2":871,"3":250,"4":104539538,"5":25448859,"6":1,"7":19,"8":1635},{"1":1545170400000,"2":871,"3":250,"4":104245559,"5":25382890,"6":1,"7":25,"8":2753},{"1":1545170400000,"2":871,"3":250,"4":104245559,"5":25382891,"6":1,"7":24,"8":1508},{"1":1545192000000,"2":871,"3":250,"4":104258361,"5":25385964,"6":1,"7":22,"8":1922},{"1":1545501600000,"2":871,"3":250,"4":104441474,"5":25426177,"6":1,"7":21,"8":3792},{"1":1545501600000,"2":871,"3":250,"4":104441474,"5":25426178,"6":1,"7":20,"8":2073},{"1":1545501600000,"2":871,"3":250,"4":104441474,"5":25426179,"6":1,"7":20,"8":1271},{"1":1545436800000,"2":871,"3":250,"4":104402906,"5":25417123,"6":1,"7":16,"8":2909},{"1":1545436800000,"2":871,"3":250,"4":104402906,"5":25417124,"6":1,"7":15,"8":1519},{"1":1545472800000,"2":871,"3":250,"4":104424213,"5":25422582,"6":1,"7":22,"8":2348},{"1":1545494400000,"2":871,"3":250,"4":104437258,"5":25425184,"6":1,"7":20,"8":4210},{"1":1545494400000,"2":871,"3":250,"4":104437258,"5":25425186,"6":1,"7":19,"8":1319},{"1":1545494400000,"2":871,"3":250,"4":104437258,"5":25425185,"6":1,"7":20,"8":2221},{"1":1545480000000,"2":871,"3":250,"4":104428900,"5":25423412,"6":1,"7":16,"8":3522},{"1":1545480000000,"2":871,"3":250,"4":104428900,"5":25423413,"6":1,"7":16,"8":1656},{"1":1545487200000,"2":871,"3":250,"4":104433078,"5":25424256,"6":1,"7":23,"8":3338},{"1":1545487200000,"2":871,"3":250,"4":104433078,"5":25424257,"6":1,"7":23,"8":1543},{"1":1545264000000,"2":871,"3":250,"4":104300510,"5":25394699,"6":1,"7":18,"8":2861},{"1":1545264000000,"2":871,"3":250,"4":104300510,"5":25394700,"6":1,"7":17,"8":1517},{"1":1545508800000,"2":871,"3":250,"4":104445721,"5":25427241,"6":1,"7":26,"8":1399},{"1":1545508800000,"2":871,"3":250,"4":104445721,"5":25427239,"6":1,"7":27,"8":3608},{"1":1545508800000,"2":871,"3":250,"4":104445721,"5":25427240,"6":1,"7":26,"8":2090},{"1":1545271200000,"2":871,"3":250,"4":104304859,"5":25395831,"6":1,"7":17,"8":1895},{"1":1545256800000,"2":871,"3":250,"4":104296239,"5":25393646,"6":1,"7":26,"8":3287},{"1":1545256800000,"2":871,"3":250,"4":104296239,"5":25393647,"6":1,"7":26,"8":1488},{"1":1545523200000,"2":871,"3":250,"4":104454197,"5":25429277,"6":1,"7":15,"8":2465},{"1":1545523200000,"2":871,"3":250,"4":104454197,"5":25429278,"6":1,"7":15,"8":1472},{"1":1545516000000,"2":871,"3":250,"4":104449968,"5":25428252,"6":1,"7":16,"8":2440},{"1":1545516000000,"2":871,"3":250,"4":104449968,"5":25428253,"6":1,"7":16,"8":1483},{"1":1545408000000,"2":871,"3":250,"4":104386018,"5":25413126,"6":1,"7":21,"8":3190},{"1":1545408000000,"2":871,"3":250,"4":104386018,"5":25413127,"6":1,"7":20,"8":1584},{"1":1545357600000,"2":871,"3":250,"4":104356516,"5":25407156,"6":1,"7":15,"8":2924},{"1":1545357600000,"2":871,"3":250,"4":104356516,"5":25407157,"6":1,"7":14,"8":1484},{"1":1545372000000,"2":871,"3":250,"4":104365134,"5":25409089,"6":1,"7":7,"8":1973},{"1":1545386400000,"2":871,"3":250,"4":104373519,"5":25410681,"6":1,"7":15,"8":2255},{"1":1545364800000,"2":871,"3":250,"4":104360868,"5":25408197,"6":1,"7":23,"8":1690},{"1":1545400800000,"2":871,"3":250,"4":104381862,"5":25412260,"6":1,"7":26,"8":2368},{"1":1545422400000,"2":871,"3":250,"4":104394420,"5":25415041,"6":1,"7":27,"8":5109},{"1":1545422400000,"2":871,"3":250,"4":104394420,"5":25415042,"6":1,"7":26,"8":2622},{"1":1545422400000,"2":871,"3":250,"4":104394420,"5":25415043,"6":1,"7":26,"8":1514},{"1":1545242400000,"2":871,"3":250,"4":104287736,"5":25391634,"6":1,"7":27,"8":3528},{"1":1545242400000,"2":871,"3":250,"4":104287736,"5":25391635,"6":1,"7":27,"8":1716},{"1":1545415200000,"2":871,"3":250,"4":104390209,"5":25414086,"6":1,"7":23,"8":2926},{"1":1545415200000,"2":871,"3":250,"4":104390209,"5":25414087,"6":1,"7":23,"8":1443},{"1":1545393600000,"2":871,"3":250,"4":104377696,"5":25411475,"6":1,"7":14,"8":2049},{"1":1545379200000,"2":871,"3":250,"4":104369334,"5":25409897,"6":0,"7":4,"8":3154},{"1":1545429600000,"2":871,"3":250,"4":104398653,"5":25416124,"6":1,"7":24,"8":2482},{"1":1545429600000,"2":871,"3":250,"4":104398653,"5":25416125,"6":1,"7":24,"8":1377},{"1":1545350400000,"2":871,"3":250,"4":104352249,"5":25406079,"6":1,"7":17,"8":2886},{"1":1545350400000,"2":871,"3":250,"4":104352249,"5":25406080,"6":1,"7":16,"8":1512},{"1":1545465600000,"2":871,"3":250,"4":104420012,"5":25421024,"6":1,"7":8,"8":2494},{"1":1545451200000,"2":871,"3":250,"4":104411481,"5":25419240,"6":1,"7":18,"8":2111},{"1":1545278400000,"2":871,"3":250,"4":104309239,"5":25396905,"6":1,"7":24,"8":2276},{"1":1545444000000,"2":871,"3":250,"4":104407169,"5":25418202,"6":1,"7":20,"8":1939},{"1":1545156000000,"2":871,"3":250,"4":104237109,"5":25380899,"6":1,"7":20,"8":3617},{"1":1545156000000,"2":871,"3":250,"4":104237109,"5":25380900,"6":1,"7":20,"8":1439},{"1":1545141600000,"2":871,"3":250,"4":104228754,"5":25379144,"6":1,"7":15,"8":2282},{"1":1545213600000,"2":871,"3":250,"4":104270977,"5":25388399,"6":1,"7":7,"8":2010},{"1":1545343200000,"2":871,"3":250,"4":104347999,"5":25405031,"6":1,"7":22,"8":3352},{"1":1545343200000,"2":871,"3":250,"4":104347999,"5":25405032,"6":1,"7":21,"8":1546},{"1":1545328800000,"2":871,"3":250,"4":104339543,"5":25403032,"6":1,"7":23,"8":3973},{"1":1545328800000,"2":871,"3":250,"4":104339543,"5":25403033,"6":1,"7":22,"8":1536},{"1":1545336000000,"2":871,"3":250,"4":104343760,"5":25403991,"6":1,"7":20,"8":3452},{"1":1545336000000,"2":871,"3":250,"4":104343760,"5":25403992,"6":1,"7":20,"8":2087},{"1":1545336000000,"2":871,"3":250,"4":104343760,"5":25403993,"6":1,"7":20,"8":1279},{"1":1545292800000,"2":871,"3":250,"4":104317733,"5":25398598,"6":0,"7":1,"8":5196},{"1":1545458400000,"2":871,"3":250,"4":104415773,"5":25420182,"6":0,"7":5,"8":2295},{"1":1545321600000,"2":871,"3":250,"4":104335365,"5":25402107,"6":1,"7":20,"8":3290},{"1":1545321600000,"2":871,"3":250,"4":104335365,"5":25402108,"6":1,"7":20,"8":1513},{"1":1545530400000,"2":871,"3":250,"4":104458459,"5":25430303,"6":1,"7":22,"8":2037},{"1":1545314400000,"2":871,"3":250,"4":104331192,"5":25401274,"6":1,"7":16,"8":1495},{"1":1545314400000,"2":871,"3":250,"4":104331192,"5":25401273,"6":1,"7":16,"8":3587},{"1":1545184800000,"2":871,"3":250,"4":104254033,"5":25384960,"6":1,"7":24,"8":2063},{"1":1545199200000,"2":871,"3":250,"4":104262607,"5":25386843,"6":0,"7":3,"8":1946},{"1":1545127200000,"2":871,"3":250,"4":104220406,"5":25377551,"6":1,"7":10,"8":2131},{"1":1545674400000,"2":871,"3":250,"4":104543758,"5":25449846,"6":1,"7":20,"8":3682},{"1":1545674400000,"2":871,"3":250,"4":104543758,"5":25449847,"6":1,"7":19,"8":1654},{"1":1545148800000,"2":871,"3":250,"4":104232921,"5":25379994,"6":1,"7":16,"8":3552},{"1":1545148800000,"2":871,"3":250,"4":104232921,"5":25379995,"6":1,"7":16,"8":1564},{"1":1545235200000,"2":871,"3":250,"4":104283539,"5":25390730,"6":1,"7":16,"8":2756},{"1":1545235200000,"2":871,"3":250,"4":104283539,"5":25390731,"6":1,"7":16,"8":1401},{"1":1545134400000,"2":871,"3":250,"4":104224570,"5":25378353,"6":1,"7":12,"8":2093},{"1":1545163200000,"2":871,"3":250,"4":104241323,"5":25381877,"6":1,"7":27,"8":3306},{"1":1545163200000,"2":871,"3":250,"4":104241323,"5":25381878,"6":1,"7":26,"8":1546},{"1":1545580800000,"2":871,"3":250,"4":104487978,"5":25436554,"6":1,"7":21,"8":1318},{"1":1545580800000,"2":871,"3":250,"4":104487978,"5":25436552,"6":1,"7":21,"8":4012},{"1":1545580800000,"2":871,"3":250,"4":104487978,"5":25436553,"6":1,"7":21,"8":2130},{"1":1545645600000,"2":871,"3":250,"4":104526328,"5":25445528,"6":1,"7":17,"8":2507},{"1":1545609600000,"2":871,"3":250,"4":104505000,"5":25440810,"6":1,"7":17,"8":3255},{"1":1545609600000,"2":871,"3":250,"4":104505000,"5":25440811,"6":1,"7":16,"8":1845},{"1":1545573600000,"2":871,"3":250,"4":104483784,"5":25435601,"6":1,"7":26,"8":3159},{"1":1545573600000,"2":871,"3":250,"4":104483784,"5":25435602,"6":1,"7":25,"8":1491},{"1":1545681600000,"2":871,"3":250,"4":104547997,"5":25450829,"6":1,"7":27,"8":2183},{"1":1545602400000,"2":871,"3":250,"4":104500718,"5":25439751,"6":1,"7":22,"8":3234},{"1":1545602400000,"2":871,"3":250,"4":104500718,"5":25439752,"6":1,"7":22,"8":1642},{"1":1545588000000,"2":871,"3":250,"4":104492209,"5":25437608,"6":1,"7":23,"8":3815},{"1":1545588000000,"2":871,"3":250,"4":104492209,"5":25437609,"6":1,"7":22,"8":2004},{"1":1545588000000,"2":871,"3":250,"4":104492209,"5":25437610,"6":1,"7":22,"8":1313},{"1":1545631200000,"2":871,"3":250,"4":104517914,"5":25443908,"6":1,"7":7,"8":1841},{"1":1545595200000,"2":871,"3":250,"4":104496457,"5":25438654,"6":1,"7":23,"8":2054},{"1":1545595200000,"2":871,"3":250,"4":104496457,"5":25438655,"6":1,"7":23,"8":1321},{"1":1545595200000,"2":871,"3":250,"4":104496457,"5":25438653,"6":1,"7":24,"8":3857},{"1":1545638400000,"2":871,"3":250,"4":104522137,"5":25444745,"6":0,"7":3,"8":1913},{"1":1545566400000,"2":871,"3":250,"4":104479601,"5":25434730,"6":1,"7":16,"8":3764},{"1":1545566400000,"2":871,"3":250,"4":104479601,"5":25434731,"6":1,"7":16,"8":1816},{"1":1545559200000,"2":871,"3":250,"4":104475420,"5":25433881,"6":1,"7":23,"8":2277},{"1":1545624000000,"2":871,"3":250,"4":104513629,"5":25442936,"6":1,"7":14,"8":2464},{"1":1545660000000,"2":871,"3":250,"4":104535356,"5":25447944,"6":1,"7":28,"8":2100},{"1":1545552000000,"2":871,"3":250,"4":104471231,"5":25433060,"6":1,"7":10,"8":2530},{"1":1545177600000,"2":871,"3":250,"4":104249777,"5":25383890,"6":1,"7":25,"8":2147},{"1":1545652800000,"2":871,"3":250,"4":104531179,"5":25447099,"6":1,"7":21,"8":2330},{"1":1545616800000,"2":871,"3":250,"4":104509287,"5":25441893,"6":1,"7":17,"8":2356},{"1":1545120000000,"2":871,"3":250,"4":104216229,"5":25376770,"6":0,"7":2,"8":3178},{"1":1545091200000,"2":871,"3":250,"4":104199197,"5":25373199,"6":1,"7":7,"8":2404}]}';
//var response = UrlFetchApp.fetch("http://members.iracing.com/memberstats/member/GetSeriesRaceResults?seasonid=2307&raceweek=1&invokedBy=SeriesRaceResults");
var data = JSON.parse(dataRaw);
var sheet = SpreadsheetApp.getActiveSheet();
var currentDate = startDate;
for(t = 0; t<7; t++) {
for(i = 0; i<12; i++) {
var sof = 0;
for(d = 0; d<data.d.length; d++) {
if(data.d[d][1] == currentDate && data.d[d][8] >= sof && data.d[d][6] == 1) {
sof = data.d[d][8];
}
}
var cell = sheet.getRange(3+t,3+i);
cell.setValue(sof);
currentDate += 7200000;
}
}
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment