TSB

screen printing => Equipment => Topic started by: CBCB on February 24, 2020, 09:01:13 AM

Title: Spreadsheet for Heatmapping a Dryer
Post by: CBCB on February 24, 2020, 09:01:13 AM

Hey y’all. I made this spreadsheet and wanted to share it. Was created for a donut probe! Just copy the template to create a fresh one, fill in your temps, and it does the mapping for you.


https://docs.google.com/spreadsheets/d/14A_6pR7xOyu4xXEZPGdIoRRciGMa4st6QSzAXSgSHc4/edit#gid=0

Title: Re: Spreadsheet for Heatmapping a Dryer
Post by: BP on February 24, 2020, 10:27:27 AM

pretty cool but can't seem to print it?

Title: Re: Spreadsheet for Heatmapping a Dryer
Post by: CBCB on February 24, 2020, 11:03:38 AM

Quote from: BP on February 24, 2020, 10:27:27 AM

pretty cool but can't seem to print it?

It’s meant to fill in on a laptop or nearby computer. But I think to print it you’d still need to copy it to your own computer or google drive first.


Sent from my iPhone using Tapatalk

Title: Re: Spreadsheet for Heatmapping a Dryer
Post by: screenxpress on February 24, 2020, 07:28:30 PM

I think to be portable, it has to be saved out as an .xls or xlsx file (or whatever the source application is). 

That link is just a 'view'.  I assume there are linked formulas on the page, but nothing displays when you click around on the view.

At least that's my thinking.

Title: Re: Spreadsheet for Heatmapping a Dryer
Post by: CBCB on February 24, 2020, 08:00:46 PM

Quote from: screenxpress on February 24, 2020, 07:28:30 PM

I think to be portable, it has to be saved out as an .xls or xlsx file (or whatever the source application is). 

That link is just a 'view'.  I assume there are linked formulas on the page, but nothing displays when you click around on the view.

At least that's my thinking.

Sorry about that, it was an html view. This link should work properly: https://docs.google.com/spreadsheets/d/14A_6pR7xOyu4xXEZPGdIoRRciGMa4st6QSzAXSgSHc4/edit#gid=0

I just tried it in 'incognito mode' and was able to hit 'file' and download it as any of the formats you mentioned. Or sign into a Google account and use Sheets. Hope it helps!

Title: Re: Spreadsheet for Heatmapping a Dryer
Post by: screenxpress on February 24, 2020, 08:39:39 PM

Dunno.  I was able to capture by highlighting the cells and importing them into Excel this, but.....

Descriptions such as Belt Speed, Temperature, etc carried across, but I could not find any formulas in any cells.

It's not really something I could use, but was attempting to assist where someone on the boards could actually download and take advantage of it.

It may boil down to permissions that allow you vs. anyone else trying to pull the contents.

Beats me......Good Luck

Title: Spreadsheet for Heatmapping a Dryer
Post by: Jepaul on February 26, 2020, 08:44:54 PM

(https://uploads.tapatalk-cdn.com/20200227/56036d6eb4431b2e1fbce10ba608f924.jpg)


Measure the entire width at once...:).  5 sensors. 5 data points.

Not my factory btw.  Can’t remember where i saw it