topic Re: Customizing Excel Setup Sheet in HSM Post Processor Forum

Customizing Excel Setup Sheet

Eli_Dexter — Fri, 17 Feb 2017 00:28:42 GMT

I am trying to customize the Excel 2007 Setup sheet. Have quite good results modifying the Excel Template File setup-sheet-excel-2007-template.xlsx.

All is well if I am working within the spreadsheet. However, when I copy on info between sheets something is getting lost. Either the part image or the tool data.

I am new in this field, is there a good tutorial and excel sheets customization?

Re: Customizing Excel Setup Sheet

Laurens-3DTechDraw — Fri, 17 Feb 2017 06:48:26 GMT

@matthew.nichols where is the video of your webinar on this?

Re: Customizing Excel Setup Sheet

ivan.stanojevic — Fri, 17 Feb 2017 09:28:05 GMT

@Laurens-3DTechDraw There was a webinar related to this subject? I would love to check on that too.

Re: Customizing Excel Setup Sheet

Eli_Dexter — Fri, 17 Feb 2017 17:22:37 GMT

Here is a webinar that I have found: https://www.youtube.com/watch?v=KHdTRNGMpO0&list=PLjUJwQJKr2zfMEwqUoUEFpw-Px8dAxnEL&index=3

It is 3 parts (hour per part) webinar discussing post development. The part of the 3rd part discuss the setup sheets customization. Does not exactly covers my problem so... When learning the more resources the better. So, is there anything else?

Re: Customizing Excel Setup Sheet

Eli_Dexter — Fri, 17 Feb 2017 17:46:18 GMT

May be I need to be a little more specific what I am trying to achieve.

I want to collect all information that I really need into one sheet. the real info I need is a basic stock info and tools. See attached template file.

As I have learned today, I cannot put the image onto the Tools sheet. So I have to put tool table onto 1st (Overview) sheet.

I guess I have to change something in the setup-sheet-excel-2007.cps file. But I cannot find anything there pertinent to any particular sheet.

Is there another file?

Please help.

Thanks

Re: Customizing Excel Setup Sheet

Anonymous — Fri, 17 Feb 2017 18:39:25 GMT

What exactly are you trying to add

Re: Customizing Excel Setup Sheet

Anonymous — Fri, 17 Feb 2017 18:45:28 GMT

If you use the dump post processor it will give you all the options you can use

Re: Customizing Excel Setup Sheet

Eli_Dexter — Fri, 17 Feb 2017 21:59:26 GMT

As I have said above, I am trying to put (combine) Sheet 3 (Tools) onto Page 1 (Overview). My problem that the same info that is printed on the Tool page does not print on the Overview Page.

Re: Customizing Excel Setup Sheet

matthew.nichols — Sat, 18 Feb 2017 02:10:04 GMT

So for the tool information make sure the $tool.row value moves over to the overview page with the tool variables. The $tool.row variable is what drives outputting the different tools into the table.

Re: Customizing Excel Setup Sheet

matthew.nichols — Sat, 18 Feb 2017 02:21:56 GMT

@Anonymous-3DTechDraw
I was told to redo it, but I have had enough requests I might go ahead and post it on my YouTube page

Re: Customizing Excel Setup Sheet

Anonymous — Sat, 18 Feb 2017 03:14:33 GMT

Please do!

Re: Customizing Excel Setup Sheet

Eli_Dexter — Mon, 20 Feb 2017 19:16:45 GMT

OK; I figured out the issue.

1. The variable should be not $tool.row but $TOOL_ROW (I am not sure if capitalization makes difference). I have checked cps file, there is no reference to $tool.row, but there is to $TOOL_ROW.

2. However, the main break thru came when I have deleted the Tools page and left the Overview the only page in the spreadsheet.

3. I have also spit panes just above the 1st row of tool data.

See final Excel template attached...

See

Re: Customizing Excel Setup Sheet

Anonymous — Wed, 28 Aug 2019 07:05:43 GMT

Where shoud I add the $TOOL.ROW? are we have to select the all row?

Re: Customizing Excel Setup Sheet

Eli_Dexter — Wed, 28 Aug 2019 16:54:27 GMT

$TOOL_ROW is placed on the same row with the $Tool.Number (in my case) in the last column. Look at my file and un-hide columns P, Q, and R.

Hope this helps...

Re: Customizing Excel Setup Sheet

Anonymous — Tue, 03 Sep 2019 03:08:03 GMT

Okay thank you for your response.