net-uml-draw
Write PlantUML from a Google Sheets spreadsheet for a simple home network diagram
Spreadsheet Example
Sample sheet is available in Sheets: Network
| Display Name and Port | Room | Device | Port | MAC | Connect | Display Name |
|---|---|---|---|---|---|---|
| =CONCATENATE(if(ISBLANK(G2),C2,G2), " Port: ", D2) | Room 1 | Switch 1 | Port1 | =A4 | ||
| =CONCATENATE(if(ISBLANK(G3),C3,G3), " Port: ", D3) | Room 1 | Switch 1 | Port2 | =A5 | ||
| =CONCATENATE(if(ISBLANK(G4),C4,G4), " Port: ", D4) | Room 1 | Device 1 | LAN | =A2 | ||
| =CONCATENATE(if(ISBLANK(G5),C5,G5), " Port: ", D5) | Room 1 | Device 2 | LAN | =A3 | ||
| =CONCATENATE(if(ISBLANK(G6),C6,G6), " Port: ", D6) | Room 2 | Switch 2 | Port1 | =A8 | ||
| =CONCATENATE(if(ISBLANK(G7),C7,G7), " Port: ", D7) | Room 2 | Switch 2 | Port2 | |||
| =CONCATENATE(if(ISBLANK(G8),C8,G8), " Port: ", D8) | Room 2 | Device 3 | LAN | =A6 |
Sample PlantUML
@startuml
frame "Room 1" as 1 {
frame "Switch 1" as 2 {
queue "Port1" as 3
queue "Port2" as 4
}
frame "Device 1" as 5 {
queue "LAN" as 6
}
frame "Device 2" as 7 {
queue "LAN" as 8
}
}
frame "Room 2" as 9 {
frame "Switch 2" as 10 {
queue "Port1" as 11
queue "Port2" as 12
}
frame "Device 3" as 13 {
queue "LAN" as 14
}
}
3 -- 6
4 -- 8
11 -- 14
@enduml
Running PlantUML
java -DPLANTUML_LIMIT_SIZE=8192 -jar plantuml.1.2020.7.jar ./home_network.puml
Sample Diagram
1 maintainer
Metadata
1 maintainer
Release files for net-uml-draw 1.485864439
For a detailed explanation of source distributions (sdists) and built distributions (wheels), please see the package formats documentation.
Source distribution (sdist)
| File | Size | Uploaded | |
|---|---|---|---|
| net_uml_draw-1.485864439.tar.gz | 7.9 kB | Details |
Release files / net_uml_draw-1.485864439.tar.gz
| Download URL | net_uml_draw-1.485864439.tar.gz |
|---|---|
| Size | 7.9 kB |
| Tags | Source |
|
SHA-256 checksum How to use checksums |
95710ada57bd8670e6dad082d993817ec29022b7ccee2305dd883cffe8bc6a5b
|
|
BLAKE2b-256 checksum How to use checksums |
7641a014ca0b94b42a942d3998d8ace8ad123a94330c4cce96bb8c6ef6e9e6b0
|
| Upload date | |
|
Uploaded using Trusted Publishing? What is trusted publishing? |
No |
| Uploaded via |
twine/3.3.0 pkginfo/1.6.1 requests/2.25.1 setuptools/51.1.2 requests-toolbelt/0.9.1 tqdm/4.56.0 CPython/3.8.7
|
