-
Notifications
You must be signed in to change notification settings - Fork 23
Documentation
Welcome to the Commodore-Repair-Toolbox (CRT henceforward) documentation.
The documentation covered here, will be for the Excel data files and how to label components for highlighting.
CRT has several data files, where it will read its various information from, like hardware, board, components, highlights and images etc. The data files are all Excel, which is used as the data format, as this is straightforward for the most to work with. Though there can be many Excel files, it has only two levels:
- Main Excel data file with references for specific hardware/board data files
- Hardware/board specific Excel data file having all detailed information about the hardware/board
The main data file is located in the same directory as the executable file and is named Commodore-Repair-Toolbox.xlsx.
The main Excel data file has only one worksheet, so it is pretty simple.
These are the columns and how to understand them.
Defines if the hardware/board should be shown in CRT.
0 equals it will not be shown.
1 equals it will be shown.
Exact same name as shown in the Hardware drop-down in CRT.
The same hardware name can be represented on multiple rows, if it has different boards.
Keep the name short, so it can fit in the drop-down.
Exact same name as shown in the Board drop-down in CRT.
The same board name should not be represented more than once.
Keep the name short, so it can fit in the drop-down.
Path and filename to the specific hardware/board Excel data file.
Use relative path from the executable file.
The Excel data file has quite a few worksheets, and this is the labor intense part, where all the relevant information needs to be.
Below is the documentation for each of these worksheets and the columns inside those.
Defines if the schematic image should be shown in CRT.
0 equals it will not be shown.
1 equals it will be shown.
Exact same name as shown in the thumbnail label.
Keep the name short, so it can fit in the label.
A schematic name must be unique.
Also, the name is referenced in the worksheet Component highlights.
Path and filename to the schematic image file.
The image format should be either JPG, PNG or GIF.
Use relative path from the executable file.
Which color to use for component highlighting in the schematic images, both in the "Main" image but also for the thumbnails.
All allowed colors are available here, https://learn.microsoft.com/en-us/dotnet/api/system.windows.media.colors?view=windowsdesktop-7.0
Where relevant then use a semi-transparent gradient for the highlight, to allow viewing of potential information below the component highlight.
0% equals fully transparent.
100% equals solid non-transparent color.
Very short label representing the component name.
Ideally it should be 1-5 characters long only.
A component label must be unique.
Board label + Technical name or value + Friendly name is concatenated in the component list.
Typically the vendor concrete name of the component or a concrete value.
E.g. simple components like capacitors or resistors typically only have the value.
More complex components like IC's typically have their real laser engraved name here.
Board label + Technical name or value + Friendly name is concatenated in the component list.
Typically components have "human readable" or "friendly" names.
Could also be that component is most often referred to as this name.
Should still be relatively short.
Board label + Technical name or value + Friendly name is concatenated in the component list.
Component category.
Could be Capacitor, Resistor, IC, Connector, Misc or whatever else suits as a group identified for the component type.
Will be shown in the component information popup.
Is a short contextual and relevant information about the component.
One line only!
This is probably the hardest part of the data, because you need to have not to little and not too much information here.
Should have data that is relevant when working with the hardware, but not too much informational data.
You can have multi-lines here (ALT+ENTER).
Direct reference from the Board schematics worksheet.
Direct reference from the Components worksheet.
Location and dimension of rectangle.
Should be integer values.
View documentation for ... labelling???
Direct reference from the Components worksheet.
As-of now there can only be one image per component.
Actually not used for anything, but just to visualize that this is the pinout image.
A pinout image should ideally show the legs and what is their input/output.
Path and filename to the pinout image file.
The image format should be either JPG, PNG or GIF.
Use relative path from the executable file.
Component local files will show in both the Overview tab and the component information popup in CRT.
It is a local file specifically for this component - e.g. a datasheet or technical documentation.
Direct reference from the Components worksheet.
You can have multiple local files per component, so the board label is allowed to duplicate.
Name for the file that will be shown in CRT.
Path and filename to the local file.
The local file will be opened in whatever default application you have for the extension.
Use relative path from the executable file.
Component URLs will show in both the Overview tab and the component information popup in CRT.
It is a URL specifically for this component - e.g. a technical documentation or troubleshooting references.
Direct reference from the Components worksheet.
You can have multiple links per component, so the board label is allowed to duplicate.
Name for the link that will be shown in CRT.
Components URL
The URL will be opened in your default browser.
Board local files will show in the Ressources tab in CRT.
It is meant as a general documentation for the board - e.g. generic diagnosing or troubleshooting.
What kind of file is this - some examples are Troubleshooting, Technical documentation or alike.
You can have multiple local files per category, so the category name is allowed to duplicate.
Name for the file that will be shown in CRT.
Path and filename to the local file.
The local file will be opened in whatever default application you have for the extension.
Use relative path from the executable file.
Board URLs will show in the Ressources tab in CRT.
It is meant as a general documentation for the board - e.g. generic diagnosing or troubleshooting.
What kind of URL is this - some examples are Troubleshooting, Technical documentation or alike.
You can have multiple URLs per category, so the category name is allowed to duplicate.
Name for the link that will be shown in CRT.
The URL will be opened in your default browser.
There are a few important things to know generally for these Excel files.
- You should not have empty rows in the middle of your data, as this will be considered as "end of data"
- If there is a yellowish highlight in the data cell, it means the data needs to be validated or corrected
- If you have the answer for this, please let me know
- No formatting will be carried over from Excel to CRT
- E.g. a bold or colored text will only show the raw text