The general idea is each cell in the sheet is telling you about an event on the fiber.
There's a legend in the top left. In this case, the fibers are mostly ending at jacks in a Commscope OFDC closure. At column J we've reached the end of a 96F cable and we've spliced to 48F cables going in different directions. I think we were supposed to notate footage at each splice, but that never got done.
The "closure number" row corresponds to numbers on a GIS map in a separate file.
Some people had trouble reading this, but I was always able to tell field techs which fibers were unused and what to splice into what so it served its purpose.
I will say that in Excel the limit on rows is dramatically higher than the limit on columns, so it might actually make sense to arrange it vertically instead of horizontally.
On 7/18/2020 4:36 PM, Jason McKemie wrote:
Do you mind sharing an example of how you laid out the spreadsheet?On Saturday, July 18, 2020, Adam Moffett <[email protected] <mailto:[email protected]>> wrote:I started out with spreadsheets. On 7/18/2020 12:26 PM, Jason McKemie wrote:Does anyone have any recommendations on what to use for this? Vetro fibermap has a nice integrated system, I just can't justify their monthly price.
Wiremap - Mt Pleasant.xlsx
Description: MS-Excel 2007 spreadsheet
-- AF mailing list [email protected] http://af.afmug.com/mailman/listinfo/af_af.afmug.com
