Google Sheet / Form Cut Log for the Glowforge

I also think that this Log could be incorporated into the Webapp. I bet they store all this information for diagnostic purposes anyway. A quick UI and the job log could be built in.

7 Likes

THAT sounds perfect. I know that I do some repetitive stuff just trying to figure out the best way to design files for the laser. I’ll get sucked into a “mode” of make changes, send to laser, notice something I want to change, make more changes, send to laser, etc… until I like what I’m seeing. I either need the settings to be collected for me, or purposefully add a log to my mental routine.

2 Likes

Make sure you are making a copy AFTER you add it to your drive :slight_smile:

4 Likes

Would it be useful to add a “Job Duration” column? It might help to determine total tube use time.

3 Likes

I think that’s what the ‘Time’ entry is for. ‘Job Date’ is at the top, but there is no ‘Job Time’. Perhaps ‘Time’ should be relabeled as ‘Job Duration’?

Being able to recall settings has been requested many times. Doing a quick search lands me on this example:

And it is in the hopper.

The recalled prior settings would include details for every colored item in the SVG, so it would wouldn’t be necessary to write this tedious information down somewhere else. I don’t have direct experience with the SVG format, but it’s got to have user tags in the thing - having those tags list ‘job description’, ‘material’, and ‘comments’ would allow the UI to add those automatically to the recalled settings.

Yes @AhnoldZ is correct I use the ‘Time’ entry for the job duration. Initially I had a start time and end time and had the sheet calculate the duration but I kept forgetting to add in the start time because I would get excited by the glowing button sooo I just decided to make is ‘Time’ and enter what the Glowforge give me as a time.

2 Likes

I love this idea. A simple webhook call with a Glowforge specified payload that includes the job settings and perhaps even a photo of the results from the bed camera after cutting would be amazing.

3 Likes

This is true but I think it’s also incredible useful to have a log of past jobs. Especially when I can look at something I’ve made and ask “how long did that take?” or “what resolution was this”. Making custom materials and having the UI store them would be a nice addition to the log. With the comments I will also note things to try like “didn’t cut all the way through next use 10% more power”

3 Likes

I hit copy and it disappeared. I’m going to wait till I can get to a desktop before I break everything.
Thanks! This looks great!

1 Like

haha I guess I didn’t try to do it mobile. Don’t worry I have backups on backups :slight_smile:

1 Like

Nice, but I have more data I capture in my Excel sheet. I almost never do something with just a single cut or engrave operation. I track the details by color in the source file (the SVG which I also track so I know which version of a project I used). So by color I track the operation, power, speed, focus, # passes, LPI and use whichever is appropriate for the operation. That way I can recreate the job (until the hopper lets the request to save settings get developed). For PG engraves I track the color (light, med, dark) that matches my dropdown selection. I track the in the order of operations so I can recreate that too. I grab the job time from the Print pop-up so I know the time it should take. I don’t do any of the stats analysis you do though.

@marmak3261 has a database tool he’s created to do similar tracking too if I recall correctly.

4 Likes

Wow - thorough log! I wish I had the patients for that haha. I realized that this form doesn’t allow for performing multiple operations. I’d be interested to see @marmak3261 's database

1 Like

I figure I have a few minutes while it’s running so not really added time to do it. Otherwise I’d just be eating more cookies to occupy my time :slight_smile:

Actually, I usually do design work when I’m running a project though. So technically I lose a couple minutes of design time when I make my log entry. :slight_smile:

2 Likes

Yup thats what I’d be doing :cookie:

1 Like

I’m an excel person, would be interested in what you track on your sheet … waiting on our Pro … and trying to learn as much as we can before it comes. Had been planning to set a sheet up once we know more.

2 Likes

I’ll clean it out and kick it up tonight so you can use it or model yours off it. It’s an electronic version of my little black project book that I’v used for awhile. I added things like LPI, focus height by operation, etc because I can do that on the GF but couldn’t with my other lasers.

I’m interested in what folks would add or change that I haven’t thought of - I’m sure there’s a bunch of things other people track that I’m going to do a dope-slap to my forehead when they explain what they’re doing. :slight_smile:

5 Likes

Thanks @jamesdhatch! There have already been a couple dope slaps here. I’d love to see yours!

2 Likes

Thanks for providing that to us!

2 Likes

Thanks, I’ve been thinking I needed to work something up while I wait, this gives me a great jumping off point :grinning:

2 Likes