1 Topic by ramses (edited by ramses 2024-11-01 16:11:33)

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

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: v010

Details see Tab History in the Excel file or in the postings below.

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/


A few pictures:


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



https://www.tonstudio-forum.de/attachment/3263-16-lable-example-1-jpg/


https://www.tonstudio-forum.de/attachment/3264-17-lable-example-2-jpg/


https://www.tonstudio-forum.de/attachment/3265-18-brother-cube-pro-jpg/

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

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
  • Online
  • From: UTC+1
  • Registered: 2012-10-14
  • Posts: 13,181

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, Cub14
  • ramses
  • DAW Mastermind
  • Online
  • From: UTC+1
  • Registered: 2012-10-14
  • Posts: 13,181

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, Cub14
  • ramses
  • DAW Mastermind
  • Online
  • From: UTC+1
  • Registered: 2012-10-14
  • Posts: 13,181

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, Cub14
  • From: Germany, Tuvalu, Poland, Chile
  • Registered: 2021-07-27
  • Posts: 470

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
  • Online
  • From: UTC+1
  • Registered: 2012-10-14
  • Posts: 13,181

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, Cub14
  • ramses
  • DAW Mastermind
  • Online
  • From: UTC+1
  • Registered: 2012-10-14
  • Posts: 13,181

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, Cub14

9 Reply by maggie33 (edited by maggie33 2024-10-29 07:47:47)

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

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
  • Online
  • From: UTC+1
  • Registered: 2012-10-14
  • Posts: 13,181

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, Cub14
  • ramses
  • DAW Mastermind
  • Online
  • From: UTC+1
  • Registered: 2012-10-14
  • Posts: 13,181

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, Cub14

12 Reply by ramses (edited by ramses 2024-10-29 17:57:09)

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

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, Cub14
  • From: Germany, Tuvalu, Poland, Chile
  • Registered: 2021-07-27
  • Posts: 470

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
  • ramses
  • DAW Mastermind
  • Online
  • From: UTC+1
  • Registered: 2012-10-14
  • Posts: 13,181

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, Cub14
  • ramses
  • DAW Mastermind
  • Online
  • From: UTC+1
  • Registered: 2012-10-14
  • Posts: 13,181

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

Excel updated to version 10 and additions to the Blog Article regarding Label Printer replacement cartridges.

Tab CableDB: Add colum "order of entries" to be able (after sorting) to come back the order in which you entered the data.
Tab Cabling: used same description "order or entries" as in CableID.
Tab Cabling+CableDB: mark double entries in red for "order of entries" and "Cable ID"
Tab Cabling: prepared for 75 entries
Tab CableDB: prepared for 100 entries and adjusted the range for the pulldown menue (Tab Cabling, Col K) for those 100 entries.

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

16 Reply by Muffin (edited by Muffin 2024-10-30 14:04:40)

  • Muffin
  • S/Mux specialist
  • Offline
  • Registered: 2021-12-26
  • Posts: 193

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

ramses wrote:

Excel updated to version 10 and additions to the Blog Article regarding Label Printer replacement cartridges.

Tab CableDB: Add colum "order of entries" to be able (after sorting) to come back the order in which you entered the data.
Tab Cabling: used same description "order or entries" as in CableID.
Tab Cabling+CableDB: mark double entries in red for "order of entries" and "Cable ID"
Tab Cabling: prepared for 75 entries
Tab CableDB: prepared for 100 entries and adjusted the range for the pulldown menue (Tab Cabling, Col K) for those 100 entries.

Thanks for doing all this work for us to use, and that includes your other blog posts as well.

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

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

Thanks for your kind feedback :-)

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

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

Thanks again, too. The cabling is perfect now! Really helpful for me.

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

19 Reply by ramses (edited by ramses 2024-10-31 22:52:06)

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

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

maggie33 wrote:

Thanks again, too. The cabling is perfect now! Really helpful for me.

Thank you, maggie33. I'm glad to hear that the version is now as you imagined it.

You've come up with a few good ideas, and I'm now very happy with the result.

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