Skip to content

Instantly share code, notes, and snippets.

View theGove's full-sized avatar

theGove

View GitHub Profile
@theGove
theGove / code.js
Last active May 2, 2022 14:18
data.world: import data to worksheet
//data.world
async function auto_exec(){
// set the tool css
Jade.set_css(gist_files('style.css'),"naive-bayes")
// place the tool html
tag("tools-body").innerHTML=gist_files('tool.html')
// fill in values from last tool use
jade_modules.jet_engine.restore_html_values()
}
@theGove
theGove / code.js
Last active May 1, 2022 14:07
JET Tool Development: develop a gist tool from local server
async function auto_exec(){
const jet_engine_gist_id = "6617f2b0bc498462b29ab33d96108014"
await jade.load_gist(jet_engine_gist_id)
console.log("jet css",gist_files('style.css'))
Jade.set_css(gist_files('style.css'),"jet") // load css for these tools
jade_modules.jet_engine.launch(my_gist_id(),5500) // run the jet engine on this gist
console.log("just loaded Jet Tool Development")
}
@theGove
theGove / code.js
Last active April 29, 2022 14:55
Jade to VBA
const version = 6
//https://gist.github.com/theGove/08ff996805ad4e0a01d1068b9720fd66
let data
const rules=[]
const rooms={}
let meeting_times
async function auto_exec(){
@theGove
theGove / code.js
Last active April 24, 2022 05:42
A Tool to Generate a Unique Set of Random Numbers
async function auto_exec(){
Jade.set_css(gist_files('style.css'))
console.log('made it here',gist_files('random_number.html'))
tag("tools-body").innerHTML=gist_files('random_number.html')
const tool_data = await jade.read_object_from_workbook(window.active_tool)
console.log("tool_data",tool_data)
for(const[key,value] of Object.entries(tool_data)){
console.log(key, value)
tag(key).value=value
}
@theGove
theGove / jet_engine.js
Last active May 1, 2022 13:07
JET Engine: processor for JET tool sets
const version=10
function auto_exec(){
;console.log("===========================",version,"===========================")
//console.log("at jade_engine.autoexec -------------- 3 -------------",my_gist_id())
}
async function launch(gist_id, local_port_for_gist_load){
// gist_id is the gist id of the tool set you are trying to launch
@theGove
theGove / code.js
Last active April 26, 2022 18:08
ATLAS: Tools for Making ATLAS Assignments
async function auto_exec(){
const jet_engine_gist_id = "6617f2b0bc498462b29ab33d96108014"
await jade.load_gist(jet_engine_gist_id)
Jade.set_css(gist_files('style.css')) // load css for these tools
jade_modules.jet_engine.launch(my_gist_id()) // run the jet engine on this gist
}
@theGove
theGove / code.js
Last active April 23, 2022 13:58
Excel Assignment Creation Tools
//e7c158b8544aaacf2e2dce2a6acfcd52
async function auto_exec(){
Jade.set_css(gist_files('style.css'))
tag("tools-body").innerHTML=gist_files('tool.html')
const tool_data = await jade.read_object_from_workbook(window.active_tool)
console.log("tool_data",tool_data)
for(const[key,value] of Object.entries(tool_data)){
console.log(key, value)
tag(key).value=value
}
@theGove
theGove / code.js
Created April 21, 2022 22:05
A Scenario Manager tool for the JADE Excel Add-in
//162df2908f70f21dd33ad560bb0ae055
async function auto_exec(){
Jade.set_css(gist_files['style.css'])
tag("tools-body").innerHTML=gist_files['tool.html']
const tool_data = await jade.read_object_from_workbook(window.active_tool)
console.log("tool_data",tool_data)
for(const[key,value] of Object.entries(tool_data)){
console.log(key, value)
tag(key).value=value
}
@theGove
theGove / code.js
Last active April 21, 2022 22:03
A Cluster Analysis tool for the JADE Excel Add-in
//0511e31d0a461f2c2b8d38b60bf81303
async function auto_exec(){
Jade.set_css(gist_files['style.css'])
tag("tools-body").innerHTML=gist_files['tool.html']
const tool_data = await jade.read_object_from_workbook(window.active_tool)
console.log("tool_data",tool_data)
for(const[key,value] of Object.entries(tool_data)){
console.log(key, value)
tag(key).value=value
}
@theGove
theGove / code.js
Last active May 2, 2022 13:52
A Naive Bayes tool for the JADE Excel Add-in
const version=16
//e7c158b8544aaacf2e2dce2a6acfcd52
//Naive Bayes
async function auto_exec(){
// set the tool css
;console.log("===========================",version,"===========================")
Jade.set_css(gist_files('style.css'),"naive-bayes")
// place the tool html
tag("tools-body").innerHTML=gist_files('tool.html')
// fill in values from last tool use