1 Topic by ramses (edited by ramses Yesterday 17:56:10)

  • ramses
  • DAW Mastermind
  • Offline
  • From: UTC+1
  • Registered: 2012-10-14
  • Posts: 13,066

Topic: Excel Template for Documenting TM FX Routing and Studio Setup (EN/DE)

I had to document my setup and TotalMix FX routing. I created a documentation in Excel format for that purpose.
For the one other, this might be useful as well, e.g., as a time saver. Simply use what appears to be useful for you.
I kept my settings in this template file so that you have a real example and can better see the purpose.

Current Status

The Excel file is "work in progress", but ready for use. Primarily, I’ll address my documentation needs, but I’ve designed it so that it could also be helpful for others and even larger setups.

Last Version of Excel: v009

Brother application doesn't allow copy/pasting Label2 with symbols, need to use ASCII chars again.
Details see Tab History in the Excel file.

Copyright

I want to keep things simple. I have just one request: If you modify or share the Excel file for your own purposes, please keep the copyright notice in the first tab so that everyone knows that the Excel file and the idea originated from me. Thank you in advance for respecting this.

Here is the link to the blog article where you can find the Excel file:
https://www.tonstudio-forum.de/blog/ent … tup-en-de/

Just one picture from the Excel, to bring some color in, not that this posting looks too black and white ;-)

https://www.tonstudio-forum.de/blog/images/coverPhotos/1d/47-1d757af53f322f3f38459d66250f8901baa07b32.jpg

BR Ramses - UFX III, 12Mic, XTC, ADI-2 Pro FS R BE, RayDAT, X10SRi-F, E5-1680v4, Win10Pro22H2, Cub13
  • From: Germany, Tuvalu, Poland, Chile
  • Registered: 2021-07-27
  • Posts: 431

Re: Excel Template for Documenting TM FX Routing and Studio Setup (EN/DE)

Thanks for sharing.
I did not see any formulas in your excel anymore.
So, you entered the values manually at all?

And - no desire or time to participate regarding the scripting stuff?
If so, NP - just let me know. regards. meg

“Do It For Her”
My Gear: Bontempi Magic light Keyboard

3 Reply by ramses (edited by ramses 2024-10-26 11:57:15)

  • ramses
  • DAW Mastermind
  • Offline
  • From: UTC+1
  • Registered: 2012-10-14
  • Posts: 13,066

Re: Excel Template for Documenting TM FX Routing and Studio Setup (EN/DE)

maggie33 wrote:

Thanks for sharing.
I did not see any formulas in your excel anymore. So, you entered the values manually at all?

It was already finished completely. Based on that, I knew how much manual work it is; therefore I got the idea of exporting TM FX matrix information to CSV format which can easily be imported into Excel.

Here it is of no use because at this point I have no additional Tabs with imported CSV values.
Once the imported data is there, it is easy to add the formulas again.

I created the demo Excel with formula for two purposes:
- for you so that it is easier to understand the concept and the requirements
- for me to see, how I would best access the imported data from the user formatted tabs including docu

maggie33 wrote:

And - no desire or time to participate regarding the scripting stuff?
If so, NP - just let me know. regards. meg

No, it's not like that. I would still be happy to get a script that even a scripting newbie can use easily, so as not to create unnecessary hurdles for easy use of the Excel file at this point.

Although I have to say that I still would prefer a defined export from TotalMix FX so that the installation of 3rd party tools (python) and libraries (using pip, a command line tool) would not be needed.

I have decided to publish the current status because it may be easier to understand the concept and the requirements if the finished Excel file is completely visible. Additionally I didn't want to delay the whole thing for too long.

But I couldn't do it immediately because it took me a little time to think about, in what format I want to publish that.
With or without protection for cells/formulas. With such stuff, I never had to deal up to now, and I was undecided.

In the end, I decided not to protect anything, to give everyone the greatest possible freedom to customize things for the own demand.  The only condition of use is not to delete the first tab with the copyright notice.

Proposal: lets use the other thread for the development aspects and this one for feeedback for the Excel.

Thanks for your work and time.

BR Ramses - UFX III, 12Mic, XTC, ADI-2 Pro FS R BE, RayDAT, X10SRi-F, E5-1680v4, Win10Pro22H2, Cub13
  • ramses
  • DAW Mastermind
  • Offline
  • From: UTC+1
  • Registered: 2012-10-14
  • Posts: 13,066

Re: Excel Template for Documenting TM FX Routing and Studio Setup (EN/DE)

Excel updated to version 5.

BR Ramses - UFX III, 12Mic, XTC, ADI-2 Pro FS R BE, RayDAT, X10SRi-F, E5-1680v4, Win10Pro22H2, Cub13
  • ramses
  • DAW Mastermind
  • Offline
  • From: UTC+1
  • Registered: 2012-10-14
  • Posts: 13,066

Re: Excel Template for Documenting TM FX Routing and Studio Setup (EN/DE)

Excel updated to version 6.

BR Ramses - UFX III, 12Mic, XTC, ADI-2 Pro FS R BE, RayDAT, X10SRi-F, E5-1680v4, Win10Pro22H2, Cub13
  • From: Germany, Tuvalu, Poland, Chile
  • Registered: 2021-07-27
  • Posts: 431

Re: Excel Template for Documenting TM FX Routing and Studio Setup (EN/DE)

Very nice. Thanks again! I especially like your idea how you manage and document your cables (via Cable IDs).
Will adapt this, to fix up my cablesalat here ;-)

“Do It For Her”
My Gear: Bontempi Magic light Keyboard
  • ramses
  • DAW Mastermind
  • Offline
  • From: UTC+1
  • Registered: 2012-10-14
  • Posts: 13,066

Re: Excel Template for Documenting TM FX Routing and Studio Setup (EN/DE)

maggie33 wrote:

Very nice. Thanks again! I especially like your idea how you manage and document your cables (via Cable IDs).
Will adapt this, to fix up my cablesalat here ;-)

Thanks, doing the same here :-)

BR Ramses - UFX III, 12Mic, XTC, ADI-2 Pro FS R BE, RayDAT, X10SRi-F, E5-1680v4, Win10Pro22H2, Cub13
  • ramses
  • DAW Mastermind
  • Offline
  • From: UTC+1
  • Registered: 2012-10-14
  • Posts: 13,066

Re: Excel Template for Documenting TM FX Routing and Studio Setup (EN/DE)

Excel updated to version 7.

BR Ramses - UFX III, 12Mic, XTC, ADI-2 Pro FS R BE, RayDAT, X10SRi-F, E5-1680v4, Win10Pro22H2, Cub13

9 Reply by maggie33 (edited by maggie33 Yesterday 07:47:47)

  • From: Germany, Tuvalu, Poland, Chile
  • Registered: 2021-07-27
  • Posts: 431

Re: Excel Template for Documenting TM FX Routing and Studio Setup (EN/DE)

Nice again ;-)

I want to share my Idea, inspired by your doc and regarding my use case:
F. ex: when sitting on the Back of the Rack and fiddeling with cables, i wanted to...
a) check all Cables (IDs) coming from UnitA and going into UnitB...
b) or check all Cables (IDs) going into UnitA and coming from UnitB...

So i expanded your Sheet as follows - the Description Column C in Sheet "Cabling" like this:
- Added Column with Title "UnitA"
- Added Column with Title "Direction" (which has the possible values: visible as "▶︎" or "◀︎" - for "true/false)"
- Added Column with Title "UnitB"
-> and made the "Connection" regarding the Cables between them (vice versa)

--> Now, i can filter these columns with 2 clicks to see what is actually Outgoing from UnitA, etc

Just my addition - maybe its useful for you, too.

Can convert it to an excel, if you would like to see what i mean...

“Do It For Her”
My Gear: Bontempi Magic light Keyboard
  • ramses
  • DAW Mastermind
  • Offline
  • From: UTC+1
  • Registered: 2012-10-14
  • Posts: 13,066

Re: Excel Template for Documenting TM FX Routing and Studio Setup (EN/DE)

Good morning.

Device A and B are already there for filtering, maybe you overlooked?

https://www.dropbox.com/scl/fi/egrv0tnfoyqz9s97k2dl1/2024-10-29-Docu-Excel-Device-A-Device-B.jpg?rlkey=u03154zxmw0sb6vxpuj9txxjq&st=n3yvck6g&dl=1

Thanks for your suggestions, I modified Tab Cabling, normalized some values, changed formulas..

Label 2 is shorter now without redundant info from Label 1 (which is attached during cable inventory before use)
It is optional to attach it, but useful indeed if you are at the rack and do not have the Excel in front of you.

https://www.dropbox.com/scl/fi/2yz7jovg8mrgrys6f0ldz/2024-10-29-Docu-Excel-preview-v8-Tab-Cabling.jpg?rlkey=ncq2duf35bm9tv1hm0inosixo&st=47dg3ccw&dl=1

BR Ramses - UFX III, 12Mic, XTC, ADI-2 Pro FS R BE, RayDAT, X10SRi-F, E5-1680v4, Win10Pro22H2, Cub13
  • ramses
  • DAW Mastermind
  • Offline
  • From: UTC+1
  • Registered: 2012-10-14
  • Posts: 13,066

Re: Excel Template for Documenting TM FX Routing and Studio Setup (EN/DE)

Excel updated to version 8.

BR Ramses - UFX III, 12Mic, XTC, ADI-2 Pro FS R BE, RayDAT, X10SRi-F, E5-1680v4, Win10Pro22H2, Cub13

12 Reply by ramses (edited by ramses Yesterday 17:57:09)

  • ramses
  • DAW Mastermind
  • Offline
  • From: UTC+1
  • Registered: 2012-10-14
  • Posts: 13,066

Re: Excel Template for Documenting TM FX Routing and Studio Setup (EN/DE)

Excel updated to version 9 (resolve font related issue for Brother label printer application).

BR Ramses - UFX III, 12Mic, XTC, ADI-2 Pro FS R BE, RayDAT, X10SRi-F, E5-1680v4, Win10Pro22H2, Cub13

13 Reply by maggie33

  • From: Germany, Tuvalu, Poland, Chile
  • Registered: 2021-07-27
  • Posts: 431

Re: Excel Template for Documenting TM FX Routing and Studio Setup (EN/DE)

Device A and B are already there for filtering, maybe you overlooked?

You are absolutely right. I overlooked that in Numbers (I use on Mac) the Filter Icons are not shown directly in the header row.

“Do It For Her”
My Gear: Bontempi Magic light Keyboard

14 Reply by ramses

  • ramses
  • DAW Mastermind
  • Offline
  • From: UTC+1
  • Registered: 2012-10-14
  • Posts: 13,066

Re: Excel Template for Documenting TM FX Routing and Studio Setup (EN/DE)

maggie33 wrote:

Device A and B are already there for filtering, maybe you overlooked?

You are absolutely right. I overlooked that in Numbers (I use on Mac) the Filter Icons are not shown directly in the header row.

Well, no problem, I named and colored it now differently. By normalization of data fields, I could also get rid of one column.

BR Ramses - UFX III, 12Mic, XTC, ADI-2 Pro FS R BE, RayDAT, X10SRi-F, E5-1680v4, Win10Pro22H2, Cub13