{
  "Dyncamelo": {
    "FormatVersion": 1,
    "MinReaderVersion": 1,
    "AppVersion": "0.47.0"
  },
  "Uuid": "c8d15d4dc2be0eba9775066b90abc244",
  "Name": "Quantities to Excel",
  "Description": "Totals the volume of every item by category and writes the result, largest first, to an Excel workbook.",
  "Nodes": [
    {
      "Id": "54bff0e2e39d80d9a511d9bb27bd0b82",
      "NodeType": "NumberInput",
      "Name": "Minimum volume",
      "X": 0.0,
      "Y": 170.0,
      "Lacing": "Auto",
      "IsFrozen": false,
      "InputPorts": [],
      "OutputPorts": [
        {
          "Name": "value"
        }
      ],
      "Data": {
        "Value": 0.0
      }
    },
    {
      "Id": "c0b10be30f896caf9f58a3df13f56e0d",
      "NodeType": "ZeroTouch",
      "DefinitionId": "CamelGraph.Navisworks.SearchNodes.ByProperty@string,string,object,string,string,Autodesk.Navisworks.Api.Document",
      "Assembly": "CamelGraph.Navisworks",
      "Name": "Search.ByProperty",
      "X": 350.0,
      "Y": 80.0,
      "Lacing": "Auto",
      "IsFrozen": false,
      "InputPorts": [
        {
          "Name": "categoryName",
          "UsingDefaultValue": false,
          "Level": -1,
          "UseLevels": false,
          "KeepListStructure": false,
          "UserValue": "Element"
        },
        {
          "Name": "propertyName",
          "UsingDefaultValue": false,
          "Level": -1,
          "UseLevels": false,
          "KeepListStructure": false,
          "UserValue": "Volume"
        },
        {
          "Name": "value",
          "UsingDefaultValue": false,
          "Level": -1,
          "UseLevels": false,
          "KeepListStructure": false
        },
        {
          "Name": "mode",
          "UsingDefaultValue": true,
          "Level": -1,
          "UseLevels": false,
          "KeepListStructure": false,
          "UserValue": ">"
        },
        {
          "Name": "resolveTo",
          "UsingDefaultValue": true,
          "Level": -1,
          "UseLevels": false,
          "KeepListStructure": false
        },
        {
          "Name": "document",
          "UsingDefaultValue": true,
          "Level": -1,
          "UseLevels": false,
          "KeepListStructure": false
        }
      ],
      "OutputPorts": [
        {
          "Name": "items"
        }
      ],
      "Data": {}
    },
    {
      "Id": "52c386388a49f95a31d5149a4261c509",
      "NodeType": "StringInput",
      "Name": "Columns to read",
      "X": 0.0,
      "Y": 400.0,
      "Lacing": "Auto",
      "IsFrozen": false,
      "InputPorts": [],
      "OutputPorts": [
        {
          "Name": "value"
        }
      ],
      "Data": {
        "Value": "@Name,Element.Category,Element.Volume"
      }
    },
    {
      "Id": "12c12a21b92cb66758e019b7f0ef3e90",
      "NodeType": "ZeroTouch",
      "DefinitionId": "CamelGraph.Nodes.StringNodes.Split@string,string",
      "Assembly": "CamelGraph.Nodes",
      "Name": "Split columns",
      "X": 350.0,
      "Y": 370.0,
      "Lacing": "Auto",
      "IsFrozen": false,
      "InputPorts": [
        {
          "Name": "text",
          "UsingDefaultValue": false,
          "Level": -1,
          "UseLevels": false,
          "KeepListStructure": false
        },
        {
          "Name": "separator",
          "UsingDefaultValue": false,
          "Level": -1,
          "UseLevels": false,
          "KeepListStructure": false,
          "UserValue": ","
        }
      ],
      "OutputPorts": [
        {
          "Name": "list"
        }
      ],
      "Data": {}
    },
    {
      "Id": "e78e2dbef5c00b478c3de87b8153204d",
      "NodeType": "ZeroTouch",
      "DefinitionId": "CamelGraph.Navisworks.ModelDataNodes.ToTable@System.Collections.Generic.IEnumerable<Autodesk.Navisworks.Api.ModelItem>,System.Collections.Generic.IList<object>",
      "Assembly": "CamelGraph.Navisworks",
      "Name": "Properties.ToTable",
      "X": 700.0,
      "Y": 180.0,
      "Lacing": "Auto",
      "IsFrozen": false,
      "InputPorts": [
        {
          "Name": "items",
          "UsingDefaultValue": false,
          "Level": -1,
          "UseLevels": false,
          "KeepListStructure": false
        },
        {
          "Name": "properties",
          "UsingDefaultValue": false,
          "Level": -1,
          "UseLevels": false,
          "KeepListStructure": false
        }
      ],
      "OutputPorts": [
        {
          "Name": "table"
        }
      ],
      "Data": {}
    },
    {
      "Id": "499e2ae1aef22bd564ef93902e26b011",
      "NodeType": "WatchTable",
      "Name": "Rows read",
      "X": 1050.0,
      "Y": 0.0,
      "Lacing": "Auto",
      "IsFrozen": false,
      "InputPorts": [
        {
          "Name": "table",
          "UsingDefaultValue": false,
          "Level": -1,
          "UseLevels": false,
          "KeepListStructure": false
        }
      ],
      "OutputPorts": [
        {
          "Name": "table"
        }
      ],
      "Data": {
        "ViewWidth": 0.0,
        "ViewHeight": 0.0
      }
    },
    {
      "Id": "01c6a59db9928db927a9afcfa4c01ccb",
      "NodeType": "StringInput",
      "Name": "Totals to work out",
      "X": 350.0,
      "Y": 550.0,
      "Lacing": "Auto",
      "IsFrozen": false,
      "InputPorts": [],
      "OutputPorts": [
        {
          "Name": "value"
        }
      ],
      "Data": {
        "Value": "count,sum:Element.Volume as Volume"
      }
    },
    {
      "Id": "f1ac0a7074bf674a2bd2961af9fc97cf",
      "NodeType": "ZeroTouch",
      "DefinitionId": "CamelGraph.Nodes.StringNodes.Split@string,string",
      "Assembly": "CamelGraph.Nodes",
      "Name": "Split totals",
      "X": 700.0,
      "Y": 510.0,
      "Lacing": "Auto",
      "IsFrozen": false,
      "InputPorts": [
        {
          "Name": "text",
          "UsingDefaultValue": false,
          "Level": -1,
          "UseLevels": false,
          "KeepListStructure": false
        },
        {
          "Name": "separator",
          "UsingDefaultValue": false,
          "Level": -1,
          "UseLevels": false,
          "KeepListStructure": false,
          "UserValue": ","
        }
      ],
      "OutputPorts": [
        {
          "Name": "list"
        }
      ],
      "Data": {}
    },
    {
      "Id": "4e93f22ec246e3488fa472c87b109ec0",
      "NodeType": "ZeroTouch",
      "DefinitionId": "CamelGraph.Nodes.TableToolkitNodes.GroupBy@CamelGraph.Nodes.CamelGraphTable,string,System.Collections.Generic.IList<object>",
      "Assembly": "CamelGraph.Nodes",
      "Name": "Table.GroupBy",
      "X": 1050.0,
      "Y": 300.0,
      "Lacing": "Auto",
      "IsFrozen": false,
      "InputPorts": [
        {
          "Name": "table",
          "UsingDefaultValue": false,
          "Level": -1,
          "UseLevels": false,
          "KeepListStructure": false
        },
        {
          "Name": "by",
          "UsingDefaultValue": false,
          "Level": -1,
          "UseLevels": false,
          "KeepListStructure": false,
          "UserValue": "Element.Category"
        },
        {
          "Name": "aggregations",
          "UsingDefaultValue": false,
          "Level": -1,
          "UseLevels": false,
          "KeepListStructure": false
        }
      ],
      "OutputPorts": [
        {
          "Name": "table"
        }
      ],
      "Data": {}
    },
    {
      "Id": "e9b57b91e50445c47765e1423b65e440",
      "NodeType": "ZeroTouch",
      "DefinitionId": "CamelGraph.Nodes.TableToolkitNodes.Sort@CamelGraph.Nodes.CamelGraphTable,string,bool",
      "Assembly": "CamelGraph.Nodes",
      "Name": "Table.Sort",
      "X": 1430.0,
      "Y": 270.0,
      "Lacing": "Auto",
      "IsFrozen": false,
      "InputPorts": [
        {
          "Name": "table",
          "UsingDefaultValue": false,
          "Level": -1,
          "UseLevels": false,
          "KeepListStructure": false
        },
        {
          "Name": "columns",
          "UsingDefaultValue": false,
          "Level": -1,
          "UseLevels": false,
          "KeepListStructure": false,
          "UserValue": "Volume"
        },
        {
          "Name": "descending",
          "UsingDefaultValue": true,
          "Level": -1,
          "UseLevels": false,
          "KeepListStructure": false,
          "UserValue": true
        }
      ],
      "OutputPorts": [
        {
          "Name": "table"
        }
      ],
      "Data": {}
    },
    {
      "Id": "7ab717632733b1c5e030e9a0afd0ed74",
      "NodeType": "ZeroTouch",
      "DefinitionId": "CamelGraph.Nodes.TableToolkitNodes.ToExcelFile@CamelGraph.Nodes.CamelGraphTable,string,string,bool",
      "Assembly": "CamelGraph.Nodes",
      "Name": "Table.ToExcelFile",
      "X": 1780.0,
      "Y": 240.0,
      "Lacing": "Auto",
      "IsFrozen": false,
      "InputPorts": [
        {
          "Name": "table",
          "UsingDefaultValue": false,
          "Level": -1,
          "UseLevels": false,
          "KeepListStructure": false
        },
        {
          "Name": "path",
          "UsingDefaultValue": false,
          "Level": -1,
          "UseLevels": false,
          "KeepListStructure": false,
          "UserValue": "C:\\Reports\\qto.xlsx"
        },
        {
          "Name": "sheet",
          "UsingDefaultValue": true,
          "Level": -1,
          "UseLevels": false,
          "KeepListStructure": false,
          "UserValue": "Quantities"
        },
        {
          "Name": "append",
          "UsingDefaultValue": true,
          "Level": -1,
          "UseLevels": false,
          "KeepListStructure": false
        }
      ],
      "OutputPorts": [
        {
          "Name": "path"
        }
      ],
      "Data": {}
    }
  ],
  "Connectors": [
    {
      "Id": "10beb981963e12419702b38f5fe851ca",
      "FromNode": "54bff0e2e39d80d9a511d9bb27bd0b82",
      "FromPort": "value",
      "ToNode": "c0b10be30f896caf9f58a3df13f56e0d",
      "ToPort": "value"
    },
    {
      "Id": "9237e6273635e6de48f941b8b99f6034",
      "FromNode": "52c386388a49f95a31d5149a4261c509",
      "FromPort": "value",
      "ToNode": "12c12a21b92cb66758e019b7f0ef3e90",
      "ToPort": "text"
    },
    {
      "Id": "d87220e6c47c28d755c7a886cbf9d9bc",
      "FromNode": "c0b10be30f896caf9f58a3df13f56e0d",
      "FromPort": "items",
      "ToNode": "e78e2dbef5c00b478c3de87b8153204d",
      "ToPort": "items"
    },
    {
      "Id": "ec578484599602e4007a2ed6e9cb1e0c",
      "FromNode": "12c12a21b92cb66758e019b7f0ef3e90",
      "FromPort": "list",
      "ToNode": "e78e2dbef5c00b478c3de87b8153204d",
      "ToPort": "properties"
    },
    {
      "Id": "c72c101dbb17ade98c87515d18186504",
      "FromNode": "01c6a59db9928db927a9afcfa4c01ccb",
      "FromPort": "value",
      "ToNode": "f1ac0a7074bf674a2bd2961af9fc97cf",
      "ToPort": "text"
    },
    {
      "Id": "3443517a160ba4f18a6d4d9b773a86fa",
      "FromNode": "e78e2dbef5c00b478c3de87b8153204d",
      "FromPort": "table",
      "ToNode": "4e93f22ec246e3488fa472c87b109ec0",
      "ToPort": "table"
    },
    {
      "Id": "b2e8537fabc8ea9ab5295391f897fff6",
      "FromNode": "f1ac0a7074bf674a2bd2961af9fc97cf",
      "FromPort": "list",
      "ToNode": "4e93f22ec246e3488fa472c87b109ec0",
      "ToPort": "aggregations"
    },
    {
      "Id": "5f9695ea691bf36e39afb81357720a2f",
      "FromNode": "4e93f22ec246e3488fa472c87b109ec0",
      "FromPort": "table",
      "ToNode": "e9b57b91e50445c47765e1423b65e440",
      "ToPort": "table"
    },
    {
      "Id": "1d2fae660859417a0ba95a4c209a25e5",
      "FromNode": "e9b57b91e50445c47765e1423b65e440",
      "FromPort": "table",
      "ToNode": "7ab717632733b1c5e030e9a0afd0ed74",
      "ToPort": "table"
    },
    {
      "Id": "08767c16338684806ff9e2673f7975d3",
      "FromNode": "e78e2dbef5c00b478c3de87b8153204d",
      "FromPort": "table",
      "ToNode": "499e2ae1aef22bd564ef93902e26b011",
      "ToPort": "table"
    }
  ],
  "Notes": [
    {
      "Id": "cb38052441832a711d37d4cba250f301",
      "Text": "WHAT IT DOES: takes every item with a volume above the minimum, reads the columns you list, adds up count and volume per category, sorts the biggest first and writes the sheet. The Watch Table shows the rows read before they are totalled. TO CHANGE: the columns, the totals (for example sum:Element.Area as Area) and the file path on Table.ToExcelFile.",
      "X": 0.0,
      "Y": -190.0
    }
  ],
  "Groups": [],
  "View": {
    "RunType": "Manual",
    "Camera": {
      "X": 0.0,
      "Y": 0.0,
      "Zoom": 1.0
    }
  }
}