SparesWeb.xls: Spare parts availability analysis.
An Excel macro-enabled workbook able to check the availability of Siemens Industry products.
Simply add product codes (MLFB) into 1st column (column A) in "Data" Worksheet and press the "Read All" or "Read Row" button in order to run the VBA code.
For each row, data is requested from Industry Mall web site and added to workbook.
The VBA code is available on Github and may be changed or used as it is.
A ready to use Excel file is also available for download.
After download, unblock the file in order to use the macro.
Right click on the file, select 'Properties' and in the 'Properties' dialog, at 'Security' select 'Unblock'
Open the document with Excel and enable Macros.
A menu named 'Spares Web' is added before 'Home' tab, in Excel Ribbon.
"Clear All" deletes everything from the current worksheet ('Data' or 'Report').
"Set Header" add header data and format columns in current worksheet ('Data' or 'Report').
"Read Row" read data from internet for the spare part code (MLFB) in column A of the selected Row (in 'Data' or 'Report' worksheet).
"Read All" read data from internet for the spare part codes (MLFB) in column A ('Data' or 'Report' worksheet). There is a limit set to Row 500; may be changed in macros.
"Successor for Row" check 'Successor' info in Column AC for the current row. If a successor part code is offered and the code is not on the next row, insert a new row with the successor MLFB code and reads all data. The new code for the successor part is marked with [succ.] prefix.
"Successor for All" check 'Successor' info for all rows (up to row 500)
"Write Report" read data from 'Data' worksheet and generates a printable report in 'Report' worksheet.
"Format Report" prepare a printable format of the data in 'Report' worksheet.
"Spares on Web" opens Spares On Web web page for current part number.
"Industry Mall" opens IndustryMall web page for current part number.
"SIOS" opens the Support web page for current part number.
To access the VBA code press ALT-F11 in Excel.
VBA code on GitHub...
XLS download...
S5Convert.xls: Converter from different Step5 / Step7 data types to binary/hex and back...
An Excel workbook for converting data, compatible with Excel, LibreOffice, etc.
| From | To | ||||||
|---|---|---|---|---|---|---|---|
| Bin | - | Hex | Uint | Int | BCD | S5Timer | Real |
| Hex | Bin | - | Uint | Int | BCD | S5Timer | Real |
| Hex | Bin | Hex | Uint | Int | BCD | S5Timer | Real |
| Uint | Bin | Hex | - | Int | BCD | S5Timer | Real |
| Int | Bin | Hex | Uint | - | BCD | S5Timer | Real |
| BCD | Bin | Hex | Uint | Int | - | S5Timer | Real |
| S5T | Bin | Hex | Uint | Int | BCD | - | Real |
| Real | Bin | Hex | Uint | Int | BCD | S5Timer | - |
| ... | ... | ||||||
