0 1 1 634324448643237573 0 8 4 true true 46d5c2a7-edfa-4b7e-831c-fde325d81124 150;150;0;0 150;0;150;0 Shaded GH-Excel_v0-04.ghx 634165321187360084 0 -1032 -1034 1 0 0 217 c552a431-af5b-46a9-a8a4-0fcbc27ef596 Group 255;0;0;0 1 1 019bfd16-d11b-4200-a128-9b9560f73204 Group A group of Grasshopper objects f98649cd-edc1-490c-bfbc-53dcf7096e60 c552a431-af5b-46a9-a8a4-0fcbc27ef596 Group 150;255;255;255 1 22 59639d83-1f82-412e-88ba-3c42dfec9bed edb33e2f-ae9e-4e35-a77e-a636aaad23eb 77aa638b-7c50-418b-8a72-25e0a874cb1e 1c5cf8e8-9d1b-4c83-9103-1ec26f5192f9 179e4566-e68a-466d-a382-f527209c0d52 5a4eae1f-606a-44ab-85a6-70e1edd501ba a3a116f1-67dc-4c45-b044-59a3ae46ea54 7196a507-704d-474d-9d95-71d4c369f688 902ce259-6b6c-46fb-84d5-e5c7cffc594c 7a316c06-1df2-47c4-bb79-be5d35076f25 3783baa5-60d9-460e-8ddc-5b323127946d 8707856e-2433-44bb-a0e0-13ccbede08c4 5c5a5a2c-23b9-4970-b998-f6e11a03a290 4d889f1b-0777-4d60-974f-0d9a92725ab4 5ab49310-6afc-475b-86da-ffb1dd22253e e815b1c4-3886-44be-a84f-a82cbde7ba2d 6d21d5af-e9d9-4cfb-81de-cd63dd06cc6c 7bc8bb06-1ff8-4529-833d-2f0a4ea138c7 c9a57720-a6a4-4aaf-8c2e-ef89a44b8f7d 3be54e4f-5115-4037-bfef-14aacd7320b0 c8658c12-5859-4e23-ad8d-8d099b12774b 0bcf735e-f71f-47a4-90d6-02568573b164 Group A group of Grasshopper objects 615bb1fc-59f8-4367-b4ee-2042f9b6616a c552a431-af5b-46a9-a8a4-0fcbc27ef596 Group 150;170;135;255 1 6 5c5a5a2c-23b9-4970-b998-f6e11a03a290 6d21d5af-e9d9-4cfb-81de-cd63dd06cc6c 7bc8bb06-1ff8-4529-833d-2f0a4ea138c7 c9a57720-a6a4-4aaf-8c2e-ef89a44b8f7d 3be54e4f-5115-4037-bfef-14aacd7320b0 c8658c12-5859-4e23-ad8d-8d099b12774b Group OPTIONAL A group of Grasshopper objects 59639d83-1f82-412e-88ba-3c42dfec9bed c552a431-af5b-46a9-a8a4-0fcbc27ef596 Group 255;0;0;0 1 1 ca59f4a7-ece1-4c6b-b403-db47c698cb95 Group A group of Grasshopper objects 0c676205-c7be-45ce-ab15-47a74071c164 c552a431-af5b-46a9-a8a4-0fcbc27ef596 Group 255;0;0;0 1 1 6ea2cccd-31a0-4d85-b97f-b54fc67d336b Group A group of Grasshopper objects 98c244cf-cf8c-4520-b2ef-b9a2bcd109ad c552a431-af5b-46a9-a8a4-0fcbc27ef596 Group 255;0;0;0 1 1 6801e7ea-ffbf-40c7-8e7b-82f796f82cb1 Group A group of Grasshopper objects 5d6457b0-0401-416b-9f1c-f82caf7a20e3 c552a431-af5b-46a9-a8a4-0fcbc27ef596 Group 255;0;0;0 1 1 b8c415c6-1f50-488d-91f0-7f3b65929327 Group A group of Grasshopper objects b524c111-5234-4994-b32b-9d4e3176b642 c552a431-af5b-46a9-a8a4-0fcbc27ef596 Group 255;0;0;0 1 1 4d3e22e9-2814-4084-826c-7998ca36c66d Group A group of Grasshopper objects 464d991a-59eb-4658-bf6f-bacc9393eff0 c552a431-af5b-46a9-a8a4-0fcbc27ef596 Group 255;0;0;0 1 1 92ca8ed8-73a2-4f95-accd-1442fe6cab93 Group A group of Grasshopper objects 1e55b329-183d-4b3b-8292-8c31e9809aa5 c552a431-af5b-46a9-a8a4-0fcbc27ef596 Group 150;255;255;255 1 8 832ea810-1683-4f0e-9774-69126f7ef8d4 e00d9f72-2da1-45ad-bc62-df559c4a9b93 e96a613e-0c4b-4d69-a978-90f338e58f79 cc32064e-47f7-4878-bb76-4cd421ae2edf ba2ea894-dab6-4a5c-aee3-0d0f7756a10f f19411bb-2a77-4c07-a93f-dde83e626bc1 2001263a-d068-4ccd-9279-86dfe2320f3b 076e4c28-2811-4f26-b7a4-4429f0e24f70 Group SAMPLE A group of Grasshopper objects 5c298ef4-911c-430d-8eb9-1d5d6be56563 c552a431-af5b-46a9-a8a4-0fcbc27ef596 Group 255;0;0;0 1 1 75d5518f-8eee-4226-8ca3-6233a4bf6f0c Group A group of Grasshopper objects a3c8e1f7-1eaa-4955-b57e-ed383415369f c552a431-af5b-46a9-a8a4-0fcbc27ef596 Group 255;0;0;0 1 1 bd12b2cc-fdba-4237-a5f2-1c4c8dd95610 Group A group of Grasshopper objects 27c2529a-eaa9-406b-b8f6-d2eb1b32fa2b c552a431-af5b-46a9-a8a4-0fcbc27ef596 Group 255;0;0;0 1 2 2756df5f-9254-4477-87ee-3d6b9a03e132 3eb8b707-9873-4d91-988b-122bd20d940d Group A group of Grasshopper objects be838978-37f7-4451-b125-bdcd278eabc2 c552a431-af5b-46a9-a8a4-0fcbc27ef596 Group 255;0;0;0 1 2 8c99fd50-dfab-4101-83ce-558b9136aa52 fe6e4071-9b77-4aa8-87d5-5aec31eb7cd5 Group A group of Grasshopper objects 289e4e6b-9b7d-43ea-b681-5dd74a37c464 c552a431-af5b-46a9-a8a4-0fcbc27ef596 Group 255;0;0;0 1 2 8f36f35f-020b-419c-b37a-7b7530546f8d f806a833-ec81-4a72-917f-f47a1ad92404 Group A group of Grasshopper objects c5de414d-cf4f-4c59-aeb7-72eeb9ce3970 c552a431-af5b-46a9-a8a4-0fcbc27ef596 Group 150;255;255;255 1 15 64d78b8a-a261-4545-a260-c7acef41a55c c388504d-9dc4-4700-bd95-717ed3e5a379 6fa1ab49-6008-4f9f-a556-c86d2ec75a64 a0cc5402-9c07-4b0e-b2b3-3692ff61fa02 fffb6183-fa8e-422e-8e7c-e6fd94798b2f 0e545459-f6d9-435e-ba52-c35023e918b0 93309c44-957f-4b51-989a-afdcc9d3be2b d6dfabab-60f9-4680-98c0-4048aeec3b4d 8c3b2e3c-9876-4226-9e41-2cc17567a514 4c87252f-25b4-45c5-8120-9376e9c02433 ed01b16c-71c7-4c9b-bbd6-0865e162d058 3462c75e-0c2c-4fce-9169-085561ac443a fec78108-1b7d-4a3c-97e5-39b3e1bc04d4 890a4d86-e674-4975-966d-0e945f84af51 0818a40c-79ea-4260-8ec8-c9aa4aeffdfb Group A group of Grasshopper objects 0c42af04-edc9-461e-b123-132baeb5515e c552a431-af5b-46a9-a8a4-0fcbc27ef596 Group 150;255;255;255 1 3 ebafb3be-900d-4f42-9ca7-ce04c5e3b2d7 b8216c5e-019a-4953-9952-0b36baa1e7cb b8d9c677-4205-414c-9aab-21524a1bd93a Group A group of Grasshopper objects 551695d3-7f4b-4f52-9599-d0b12ed7e875 c552a431-af5b-46a9-a8a4-0fcbc27ef596 Group 150;255;255;255 1 11 12fed4c7-0495-4c23-926b-7214c796bd13 ca06720a-ea9f-4eae-b523-dacc8f91bf1a 321a60c3-0e12-436f-8fdd-83678957e0ff 237d6cd8-92af-4dda-ae2d-d673dba76be9 e175a326-b4f8-4b95-aef3-d5eed0a039b0 567d3460-37f5-4337-b4a0-b8de09a728f5 22105683-6fca-439c-9952-0b393af40287 f25e832d-e009-498b-badd-8110df8f5026 3e20af92-0419-4bfb-a272-5a0ed3427c9b 3769a9ce-2b54-45d9-ad8f-ae0ac6bffde5 2eeb43be-a7e2-44fb-abdb-01dcb2bb4c55 Group A group of Grasshopper objects 084018a5-5e0c-42f6-8fe1-67ae49e4e166 c552a431-af5b-46a9-a8a4-0fcbc27ef596 Group 150;255;255;255 1 24 878ca112-71d9-42b1-930b-ba5b707f7435 5177881c-a161-43f2-a7de-7ea0aa62e085 5679427d-11aa-4f79-a712-25c5e82da237 fa7e2a34-1822-40b4-9f5c-34b13f947525 1ab2e2be-ba10-413a-90eb-4c19db67b961 30eda32a-9823-4112-babc-46d448b5bd97 140dbd5a-60e6-4ee6-ae02-2e9c8b567ab7 9aa5127d-a46b-4c0b-88ed-a26f9415d236 856912e3-d37e-47fb-82ad-08bca7c438bf 267fbebe-122a-41e6-aeda-3cd34b432ba2 96ca106e-1e73-452a-8b27-683c12791dcf 9d47f760-8ad4-4eef-afd8-e011956fcd20 02f6b430-98bd-4167-916e-80f1893fe3e2 65d98c14-4489-44a3-80cf-0b6412dc4bf1 16276d82-f789-476c-a8d8-dc3e770b9002 59f0d1a6-fffb-48aa-b7cb-2ae318449aa1 93eec32d-e6c6-47ad-b222-c5d70eedd7e2 5c152da5-a634-4c96-aede-ff3ac839bf2c 75c59d66-3a90-45a2-96e2-e350c2ebdf34 99018b16-14fb-49d4-a7c1-c446722479aa 747c309e-853d-408f-8c19-e7275d00f249 1603221e-4b10-44c6-b3bd-da7e8c97b819 0172b08f-21a1-46ae-8097-96c6a6cced31 049f0131-c4a9-4e70-ac2b-ffe004340a93 Group SAMPLE A group of Grasshopper objects 58092645-1adc-4532-9480-6a60c92c17dc c552a431-af5b-46a9-a8a4-0fcbc27ef596 Group 150;255;255;255 1 18 e42ea9a9-86f4-4407-a317-b80b7e6a5e94 220eb874-142f-4128-aec7-4c690b76b45d a0e23e1e-4f10-4511-97ea-61503b63ff20 3be9ef2a-9127-48f4-be79-1623ffc4ca90 74194bf1-4ad4-40d8-bfae-21a5982daa36 ada2230d-cc73-4270-a846-85776e6abc10 ae47ee40-0896-46b0-ad39-b34a9b4d7314 f0633e9a-65fc-4f99-8677-030ebe728e3a 06f8d0de-94e1-42da-ab7a-4ac4b3476b4c cc59c0c1-7f8d-4293-810a-4b6238d4b9c5 d6f562f9-8476-4d1f-a6a8-1c0ffa2c9b96 6871996a-6a76-498d-961c-0e7268a2727d 5e637c0e-a14a-40f3-a39f-ffe56b522094 222f7629-e719-42d1-89e4-4d3b542d3026 d9be3cc9-e22f-44e2-9e73-b3016e0c9226 ada96d34-db6b-497d-8e97-b8c92e3c878b 763d6aed-9b0f-4562-8585-03acc9075de9 70c60886-19f8-43fb-ac3e-85faed6710e8 Group SAMPLE A group of Grasshopper objects 7994cef7-cb12-4be2-bbbb-aead3ee5aea0 c552a431-af5b-46a9-a8a4-0fcbc27ef596 Group 150;170;135;255 1 3 06f8d0de-94e1-42da-ab7a-4ac4b3476b4c cc59c0c1-7f8d-4293-810a-4b6238d4b9c5 d6f562f9-8476-4d1f-a6a8-1c0ffa2c9b96 Group Optional A group of Grasshopper objects e42ea9a9-86f4-4407-a317-b80b7e6a5e94 c552a431-af5b-46a9-a8a4-0fcbc27ef596 Group 150;170;135;255 1 5 5c152da5-a634-4c96-aede-ff3ac839bf2c 75c59d66-3a90-45a2-96e2-e350c2ebdf34 99018b16-14fb-49d4-a7c1-c446722479aa 747c309e-853d-408f-8c19-e7275d00f249 1603221e-4b10-44c6-b3bd-da7e8c97b819 Group Optional A group of Grasshopper objects 878ca112-71d9-42b1-930b-ba5b707f7435 c552a431-af5b-46a9-a8a4-0fcbc27ef596 Group 150;170;135;255 1 9 8fc428dc-0619-450f-93a8-2e2dd4d7e989 ada3442f-c5f7-42c3-b0d6-e9166b37400b 47f623b9-e689-40bb-8c39-0f6accebb0a0 3d3f3a2d-deb5-488a-8ee7-bfedc6c450c9 172f9c51-bb09-472f-9180-98e673c408a8 31dfde55-a531-4b02-8d09-762c73691a14 d0f5639d-927e-4338-8c3a-b48ba5d23e0a dd3a0a78-bbe5-4366-b113-ce7006a46863 451b0c17-c761-466b-aedd-1bab5584c631 Group A group of Grasshopper objects b5bb7c4f-b831-4ee1-8d2a-f3ffad59fc14 ad483f40-dc72-40dc-844d-c9e462c7d19f Boolean Toggle true Boolean Toggle Stream by Column? Boolean (true/false) toggle 220eb874-142f-4128-aec7-4c690b76b45d false true true 0 1650 969 150 20 1650 969 150 20 1650.936 969.3476 false 59e0b89a-e487-49f8-bab8-b5bab16be14c Panel Panel A panel for custom notes and String values a0e23e1e-4f10-4511-97ea-61503b63ff20 false true true 0 Live From Grasshopper true true true 1 0 false 255;255;255;255 255;0;0;0 1638 989 163 20 1638 989 163 20 1638.374 989.9309 false Trebuchet MS 10 false false 59e0b89a-e487-49f8-bab8-b5bab16be14c Panel Panel XL Border Style A panel for custom notes and String values 32204931-31f6-4561-bc74-6d684df93805 false true true 0 Borders: Line Style (8x) http://msdn.microsoft.com/en-us/library/ee409168(v=office.12).aspx Borders: Weight (4x) http://msdn.microsoft.com/en-us/library/bb240972.aspx true true true 1 0 false 255;0;0;0 255;0;255;255 450 1350 599 99 450 1350 599 99 450.3473 1350.525 false 9c53bac0-ba66-40bd-8154-ce9829b9db1a Colour Swatch 255;0;0;0 Colour Swatch Swatch Colour (palette) swatch 64d78b8a-a261-4545-a260-c7acef41a55c false true true 0 749 1846 89 20 749 1846 89 20 749.3932 1846.048 false 59e0b89a-e487-49f8-bab8-b5bab16be14c Panel Panel XL Cell Style A panel for custom notes and String values fb41f856-2f4c-4006-8d4e-b42c3b7839f3 false true true 0 Cells: Pattern (19x) http://msdn.microsoft.com/en-us/library/bb241407(office.12).aspx true true true 1 0 false 255;0;0;0 255;0;255;255 448 1100 600 100 448 1100 600 100 448.6565 1100.183 false 9c53bac0-ba66-40bd-8154-ce9829b9db1a Colour Swatch 255;255;255;255 Colour Swatch Swatch Colour (palette) swatch a28cefc3-a5cb-477d-b7c6-cd1f0aba7671 false true true 0 750 4110 89 20 750 4110 89 20 750.4457 4110.411 false 59e0b89a-e487-49f8-bab8-b5bab16be14c Panel Panel A panel for custom notes and String values c388504d-9dc4-4700-bd95-717ed3e5a379 false true true 0 xlThick true true true 1 0 false 255;255;255;255 255;0;0;0 749 1821 150 20 749 1821 150 20 749.1943 1821.79 false Microsoft Sans Serif 10 false false 59e0b89a-e487-49f8-bab8-b5bab16be14c Panel Panel A panel for custom notes and String values 6fa1ab49-6008-4f9f-a556-c86d2ec75a64 false true true 0 xlContinuous true true true 1 0 false 255;255;255;255 255;0;0;0 749 1800 150 20 749 1800 150 20 749.3272 1800.602 false Microsoft Sans Serif 10 false false 9c53bac0-ba66-40bd-8154-ce9829b9db1a Colour Swatch 255;0;0;0 Colour Swatch Swatch Colour (palette) swatch a0cc5402-9c07-4b0e-b2b3-3692ff61fa02 false true true 0 748 1541 89 20 748 1541 89 20 748.8963 1541.357 false 59e0b89a-e487-49f8-bab8-b5bab16be14c Panel Panel A panel for custom notes and String values fffb6183-fa8e-422e-8e7c-e6fd94798b2f false true true 0 xlThick true true true 1 0 false 255;255;255;255 255;0;0;0 748 1520 150 20 748 1520 150 20 748.6972 1520.785 false Microsoft Sans Serif 10 false false 59e0b89a-e487-49f8-bab8-b5bab16be14c Panel Panel A panel for custom notes and String values 0e545459-f6d9-435e-ba52-c35023e918b0 false true true 0 xlDouble true true true 1 0 false 255;255;255;255 255;0;0;0 748 1499 150 20 748 1499 150 20 748.8303 1499.598 false Microsoft Sans Serif 10 false false 9c53bac0-ba66-40bd-8154-ce9829b9db1a Colour Swatch 255;0;0;0 Colour Swatch Swatch Colour (palette) swatch 93309c44-957f-4b51-989a-afdcc9d3be2b false true true 0 748 1667 89 20 748 1667 89 20 748.6562 1667.889 false 59e0b89a-e487-49f8-bab8-b5bab16be14c Panel Panel A panel for custom notes and String values d6dfabab-60f9-4680-98c0-4048aeec3b4d false true true 0 xlThick true true true 1 0 false 255;255;255;255 255;0;0;0 749 1647 150 20 749 1647 150 20 749.5063 1647.056 false Microsoft Sans Serif 10 false false 59e0b89a-e487-49f8-bab8-b5bab16be14c Panel Panel A panel for custom notes and String values 8c3b2e3c-9876-4226-9e41-2cc17567a514 false true true 0 xlDashDot true true true 1 0 false 255;255;255;255 255;0;0;0 748 1625 150 20 748 1625 150 20 748.5903 1625.868 false Microsoft Sans Serif 10 false false 59e0b89a-e487-49f8-bab8-b5bab16be14c Panel Panel XL Font Style A panel for custom notes and String values 375cb76d-5b65-41c0-9412-c46ab2fccdb5 false true true 0 Font: Justification (3x) http://msdn.microsoft.com/en-us/library/microsoft.office.core.xlconstants.aspx true true true 1 0 false 255;0;0;0 255;0;255;255 450 700 599 99 450 700 599 99 450.4655 700.3419 false 9c53bac0-ba66-40bd-8154-ce9829b9db1a Colour Swatch 255;0;0;0 Colour Swatch Swatch Colour (palette) swatch 4c87252f-25b4-45c5-8120-9376e9c02433 false true true 0 748 1605 89 20 748 1605 89 20 748.6502 1605.034 false 59e0b89a-e487-49f8-bab8-b5bab16be14c Panel Panel A panel for custom notes and String values ed01b16c-71c7-4c9b-bbd6-0865e162d058 false true true 0 xlThick true true true 1 0 false 255;255;255;255 255;0;0;0 749 1584 150 20 749 1584 150 20 749.5003 1584.2 false Microsoft Sans Serif 10 false false 59e0b89a-e487-49f8-bab8-b5bab16be14c Panel Panel A panel for custom notes and String values 3462c75e-0c2c-4fce-9169-085561ac443a false true true 0 xlDashDot true true true 1 0 false 255;255;255;255 255;0;0;0 748 1563 150 20 748 1563 150 20 748.5843 1563.012 false Microsoft Sans Serif 10 false false 9c53bac0-ba66-40bd-8154-ce9829b9db1a Colour Swatch 255;0;0;0 Colour Swatch Swatch Colour (palette) swatch fec78108-1b7d-4a3c-97e5-39b3e1bc04d4 false true true 0 749 1730 89 20 749 1730 89 20 749.3942 1730.861 false 59e0b89a-e487-49f8-bab8-b5bab16be14c Panel Panel A panel for custom notes and String values 890a4d86-e674-4975-966d-0e945f84af51 false true true 0 xlThick true true true 1 0 false 255;255;255;255 255;0;0;0 750 1710 150 20 750 1710 150 20 750.2442 1710.027 false Microsoft Sans Serif 10 false false 59e0b89a-e487-49f8-bab8-b5bab16be14c Panel Panel A panel for custom notes and String values 0818a40c-79ea-4260-8ec8-c9aa4aeffdfb false true true 0 xlDashDot true true true 1 0 false 255;255;255;255 255;0;0;0 749 1688 150 20 749 1688 150 20 749.3283 1688.84 false Microsoft Sans Serif 10 false false 59e0b89a-e487-49f8-bab8-b5bab16be14c Panel Panel Cell Patterns A panel for custom notes and String values ad7b99b9-e5d6-468c-ac1c-b619a1e4a56b false true true 0 xlPatternAutomatic xlPatternChecker xlPatternCrissCross xlPatternDown xlPatternGray16 xlPatternGray25 xlPatternGray75 xlPatternGray8 xlPatternGrid xlPatternHorizontal xlPatternLightDown xlPatternLightHorizontal xlPatternLightUp xlPatternLightVertical xlPatternNone xlPatternSemiGray75 xlPatternSolid xlPatternUp xlPatternVertical false true false 1 1 false 255;0;0;0 255;255;255;0 450 1200 150 149 450 1200 150 149 450.6241 1200.014 false Trebuchet MS 10 false false 59e0b89a-e487-49f8-bab8-b5bab16be14c Panel Panel Vertical Justification A panel for custom notes and String values f570af5c-7ec6-4dfa-a98a-ccafdaf769d3 false true true 0 xlLeft xlCenter xlRight false true false 1 0 false 255;0;0;0 255;255;255;0 449 852 151 99 449 852 151 99 449.8998 852.8389 false Microsoft Sans Serif 10 false false 59e0b89a-e487-49f8-bab8-b5bab16be14c Panel Panel Horizontal Justification A panel for custom notes and String values 79d8be02-6306-4f9b-bed0-013a83023b02 false true true 0 xlTop xlCenter xlBottom false true false 1 0 false 255;0;0;0 255;255;255;0 450 952 150 99 450 952 150 99 450.3224 952.9839 false Microsoft Sans Serif 10 false false 59e0b89a-e487-49f8-bab8-b5bab16be14c Panel Panel Line Weights A panel for custom notes and String values 69fb0f29-b534-4620-a515-14bbf875c837 false true true 0 xlHairline xlMedium xlThick xlThin false true false 1 0 false 255;0;0;0 255;255;255;0 450 1663 150 137 450 1663 150 137 450.7377 1663.331 false Microsoft Sans Serif 10 false false 59e0b89a-e487-49f8-bab8-b5bab16be14c Panel Panel A panel for custom notes and String values 680a2671-dfe6-42b9-9920-978c73c06a3d false true true 0 xlPatternAutomatic true false false 1 0 false 255;255;255;255 255;0;0;0 750 3828 150 20 750 3828 150 20 750.3401 3828.809 false Microsoft Sans Serif 10 false false 59e0b89a-e487-49f8-bab8-b5bab16be14c Panel Panel Line Styles A panel for custom notes and String values 0a8323f5-1a17-4bcf-825a-512c01fad405 false true true 0 xlContinuous xlDash xlDashDot xlDashDotDot xlDot xlDouble xlLineStyleNone xlSlantDashDot false true false 1 0 false 255;0;0;0 255;255;255;0 449 1499 151 163 449 1499 151 163 449.9631 1499.764 false Microsoft Sans Serif 10 false false 59e0b89a-e487-49f8-bab8-b5bab16be14c Panel Panel A panel for custom notes and String values 3be9ef2a-9127-48f4-be79-1623ffc4ca90 false true true 0 1 true true true 1 0 false 255;0;0;0 255;255;255;255 1650 903 64 21 1650 903 64 21 1650.106 903.2735 false 59e0b89a-e487-49f8-bab8-b5bab16be14c Panel Panel A panel for custom notes and String values 74194bf1-4ad4-40d8-bfae-21a5982daa36 false true true 0 1 true true true 1 0 false 255;0;0;0 255;255;255;255 1650 925 64 21 1650 925 64 21 1650.121 925.0701 false 59e0b89a-e487-49f8-bab8-b5bab16be14c Panel Panel WRITE TO EXCEL TOOLS BRIEF A panel for custom notes and String values 71b14ed6-be4c-4e7c-8c32-f5e6fc4a54ac false true true 0 Brief: The excel output tools allow you to live stream any text based data out to an active excel spreadsheet. There are two primary output types, "List to XL", which will output a either a single column or row of information to excel, and "Table to XL" which will output a two dimensional array (Datatree in GH, Table/ Database in Excel). Each tool has two versions. An advanced option allows the user to stream various formatting parameters, to better visualize the data being output. This includes options like cell color, which could be coordinated to a model/ rendering, for easy reference. Each of these formatting inputs are optional, and if left empty, will simply use the excel sheets default. The second component is the light version, which only outputs the data. There is no difference between the light version and the advanced version with non of the optional formatting used, it just takes up less space in Grasshopper. Additionally there are 4 optional components, compatible with both the table and list tools, which allow the used to create varied formatting per cell/ per sheet. These require coordinated data tree structures with the data being streamed, (same as any other Grasshopper component). true true true 0 0 false 255;0;0;0 255;153;153;153 1 401 1049 200 1 401 1049 200 1.644618 401.4125 false Trebuchet MS 10 false false 59e0b89a-e487-49f8-bab8-b5bab16be14c Panel Panel WRITE TO EXCEL BREAKDOWN A panel for custom notes and String values be77b770-c035-4db9-bd20-a71dcb3477f3 false true true 0 Instructions: List to XL: Streams a list of data -Origin (3d Point) A Three dimensional point (only X and Y used) which determines the first cell in which data will be placed. X = column, Y = row -ByColumn (boolean) A Boolean which determines whether the sucessive data will be placed down the column "true" or across the row "false" -Title (string) An optional string input which will fill the first cell specified -Data (list of generic data) Input for the list of generic text based data to be streamed to excel ---optional -Font_Format (custom component) The input for the "XL Font" function -Cell_Format (custom component) The input for the "XL Cell" function -Border_Format (custom component) The input for the "XL Border Edges" or "XL Border Edges" function --- -_Stream (boolean) A boolean which when on allows live streaming from grasshopper. Table to XL: Streams a table of data -Origin (3d Point) SAME AS "List to XL" -ByColumn (boolean) A Boolean which determines whether the sucessive data will be placed first by column "true" or first by row "false" ---optional SAME AS "List to XL" --- -_Stream SAME AS "List to XL" INPUTS TO ANYTHING BELOW CAN BE (ITEM, LIST, or BRANCH) COORDINATED WITH DATA XL Font: Formats the font for the excel data -_Size (double) The font size -_Color (RGB color) The color of the font -_Horizontal (xlParameter, string) The horizontal justification option for the text [see Vertical Justification list] -_Vertical (xlParameter, string) The vertical justification option for the text [see Horizontal Justification list] -_Bold (boolean) True for Bold formatting -_Italic (boolean) True for Italic formatting -_Underline (boolean) True for Underline formatting -_Strikethrough (boolean) True for Strikethrough formatting -_Subscript (boolean) True for Subscript formatting -_Superscript (boolean) True for Superscript formatting XL Cell: Formats the Cell style -_Pattern (xlParameter, string) An excel standard pattern type [see Cell Patterns list] -_Color (RGB color) Color of the pattern when available -_Fill (RGB color) Color of the cell background XL Border: Format the Cell Border -_Style (xlParameter, string) An excel standard linetype [see Line Styles list] -_Weight (xlParameter, string) An excel standard lineweight [see Line Weights list] -_Color (RGB color) Color of the outline when available XL Border Edges: Format each edge of the cell individually (same inputs as XL Border, just called out per edge) _L_ = Left _R_ = Right _T_ = Top _B_ = Bottom true true true 0 0 false 255;0;0;0 255;153;153;153 1 650 432 1358 1 650 432 1358 1.052275 650.1635 false Trebuchet MS 10 false false 59e0b89a-e487-49f8-bab8-b5bab16be14c Panel Panel EXCEL TOOLS FORMATTING A panel for custom notes and String values bc7825d9-ba04-481e-a0c2-3413e52f2a47 false true true 0 Note Panel Colors mean the following BLACK = String Based Input WHITE = Integer Based Input CYAN = Location of online reference database YELLOW = List of available options MAGENTA = Temporary data set true true true 1 0 false 255;0;0;0 255;217;217;217 750 150 598 199 750 150 598 199 750.8613 150.8821 false Trebuchet MS 10 false false 9c53bac0-ba66-40bd-8154-ce9829b9db1a Colour Swatch 255;181;181;181 Colour Swatch Swatch Colour (palette) swatch d2dbd19c-c0b0-458b-afaa-ba871d6b0e2d false true true 0 750 3849 89 20 750 3849 89 20 750.6511 3849.262 false 59e0b89a-e487-49f8-bab8-b5bab16be14c Panel Panel READ FROM EXCEL TOOLS BRIEF A panel for custom notes and String values 63fa577f-5040-4cc3-84c1-f27359e94303 false true true 0 Brief: These two excel input function has user defined ranges of information from excel and returns the values ase strings into Grasshopper. There are two types, the "List From XL" which returns a Grasshopper List of information, and the second "Table From XL" whic returns a Datatree (2d array) of information. Both have similar structures that have an origin cell from which the function begins reading, for the list component there is an option to choose whether a column of information is read (from origin down) or a row (from origin right). Both allow the user to specify a limit or bound to how much data will be read, if not used, the function will read till it hits its first null entry for the list, and first null column entry for the table. Use of the "Count" and "Bound" inputs allow the user to bring null information into grasshopper. true true true 0 0 false 255;0;0;0 255;153;153;153 0 2100 1049 199 0 2100 1049 199 0.2379999 2100.606 false Trebuchet MS 10 false false 59e0b89a-e487-49f8-bab8-b5bab16be14c Panel Panel EXCEL TOOLS INSTRUCTIONS A panel for custom notes and String values fd69f8bb-8fba-4b7c-9d23-301c276a86e6 false true true 0 Instructions: List From XL: Returns list of data from an active excel sheet -Origin (3d point) A Three dimensional point (only X and Y used) which determines the first cell that will be read. X = column, Y = row -ByColumn (boolean) A Boolean which determines whether the sucessive data will be rad down the column "true" or across the row "false" -Count (integer) Optional input number of cells which will be read (if not used then the function will read until it encounters the first blank cell) -_Stream (boolean) If False, the function will be inactive Table From XL: Returns Datatree of data from an active excel sheet -Origin (3d point) A Three dimensional point (only X and Y used) which determines the first cell that will be read. X = column, Y = row -Bound (3d point) A Three dimensional point (only X and Y used) which determines the furthest cell in a 2d range that will be read. X = column, Y = row. (if not used then the function will read until it encounters the first blank cell in the first position of a column) -_Stream (boolean) If False, the function will be inactive NOTE: A timer can be applied to this function to actively update at an interval. Use at your own risk as if an invalid return is made it may cause Grasshopper to "lock up" true true true 0 0 false 255;0;0;0 255;153;153;153 0 2300 432 599 0 2300 432 599 0.6805496 2300.941 false Trebuchet MS 10 false false 2e3ab970-8545-46bb-836c-1c11e5610bce Integer Integer Count Represents a collection of Integer numbers 832ea810-1683-4f0e-9774-69126f7ef8d4 false true true 1 e00d9f72-2da1-45ad-bc62-df559c4a9b93 700 2533 50 20 700 2533 50 20 725.817 2543.792 false 59e0b89a-e487-49f8-bab8-b5bab16be14c Panel Panel A panel for custom notes and String values e00d9f72-2da1-45ad-bc62-df559c4a9b93 false true true 0 5 true true true 1 0 false 255;0;0;0 255;255;255;255 601 2534 50 20 601 2534 50 20 601.1581 2534.071 false 3581f42a-9592-4549-bd6b-1c0fc39d067b Point XYZ Point XYZ Pt Create a point from {xyz} coordinates. ada2230d-cc73-4270-a846-85776e6abc10 false true true longest_list 1735 901 65 64 1754 903 24 60 1766 933 false X component X {x} component cb811c0a-024d-4f7f-bccf-94c9e281f5f2 false true true 1 3be9ef2a-9127-48f4-be79-1623ffc4ca90 1 1737 903 14 20 1737 903 14 20 1745.5 913 false 0 Y component Y {y} component 357d8af7-4743-4b8c-a344-c4f501cef09a false true true 1 74194bf1-4ad4-40d8-bfae-21a5982daa36 1 1737 923 14 20 1737 923 14 20 1745.5 933 false 0 Z component Z {z} component 47bf64ac-4969-48d1-9f72-e6106f549d65 false true true 0 1 1737 943 14 20 1737 943 14 20 1745.5 953 false 0 Point Pt Point coordinate 470ce3db-af89-42a8-9602-f6185cc6e4bf true true true 0 1781 903 17 60 1781 903 17 60 1791 933 false ad483f40-dc72-40dc-844d-c9e462c7d19f Boolean Toggle false Boolean Toggle If True then data will stream to an open excel sheet Boolean (true/false) toggle ae47ee40-0896-46b0-ad39-b34a9b4d7314 false true true 0 1498 1153 302 20 1498 1153 302 20 1498.044 1153.204 false fb6aba99-fead-4e42-b5d8-c6de5ff90ea6 DotNET VB Script (LEGACY) Dim arrList As New List(Of System.Object) Dim patt As Integer If _Pattern = "xlPatternAutomatic" Then patt = -4105 ElseIf _Pattern = "xlPatternChecker" Then patt = 9 ElseIf _Pattern = "xlPatternCrissCross" Then patt = 16 ElseIf _Pattern = "xlPatternDown" Then patt = -4121 ElseIf _Pattern = "xlPatternGray16" Then patt = 17 ElseIf _Pattern = "xlPatternGray25" Then patt = -4124 ElseIf _Pattern = "xlPatternGray75" Then patt = -4125 ElseIf _Pattern = "xlPatternGray8" Then patt = 18 ElseIf _Pattern = "xlPatternGrid" Then patt = 15 ElseIf _Pattern = "xlPatternHorizontal" Then patt = -4128 ElseIf _Pattern = "xlPatternLightDown" Then patt = 13 ElseIf _Pattern = "xlPatternLightHorizontal" Then patt = 11 ElseIf _Pattern = "xlPatternLightUp" Then patt = 14 ElseIf _Pattern = "xlPatternLightVertical" Then patt = 12 ElseIf _Pattern = "xlPatternNone" Then patt = -4142 ElseIf _Pattern = "xlPatternSemiGray75" Then patt = 10 ElseIf _Pattern = "xlPatternSolid" Then patt = 1 ElseIf _Pattern = "xlPatternUp" Then patt = -4162 ElseIf _Pattern = "xlPatternVertical" Then patt = -4166 Else patt = -4105 End If arrList.add(patt) arrList.add(_Color) arrList.add(_Fill) A = arrList 0 DotNET VB Script (LEGACY) XL Cell A VB.NET scriptable component bd12b2cc-fdba-4237-a5f2-1c4c8dd95610 false true true longest_list 945 1246 105 64 999 1248 24 60 1011 1278 false 3 84fa917c-1ed8-4db3-8be1-7bdc4a6495a2 Variable x Script Variable x true true 84fa917c-1ed8-4db3-8be1-7bdc4a6495a2 Variable y Script Variable y true true 84fa917c-1ed8-4db3-8be1-7bdc4a6495a2 Variable var Script Variable var true true 2 3ede854e-c753-40eb-84cb-b48008f14fd4 Output Print, Reflect and Error streams true false 8ec86459-bf01-4409-baee-174d0d2b13d0 Result A Output parameter A true false Variable x _Pattern Script Variable x 39806b69-40b6-468b-8026-e7d2abfccd2a true true true 1 b8216c5e-019a-4953-9952-0b36baa1e7cb abf1fd1b-dbe5-4be6-9832-d8dc105e207f true false 947 1248 49 20 947 1248 49 20 973 1258 false Variable y _Color Script Variable y d1304031-ceea-44ce-b57d-00bb7ac718c7 true true true 1 b8d9c677-4205-414c-9aab-21524a1bd93a true false 947 1268 49 20 947 1268 49 20 973 1278 false Variable var _Fill Script Variable var 1371437e-15d8-443a-8bb4-11529ed562b4 true true true 1 ebafb3be-900d-4f42-9ca7-ce04c5e3b2d7 true false 947 1288 49 20 947 1288 49 20 973 1298 false Output out Print, Reflect and Error streams 07395969-40e9-424e-99e7-1b602fe3aaab false true true 0 1026 1248 22 30 1026 1248 22 30 1038.5 1263 false Result A A Output parameter A 04e0fed7-56b4-43bf-ac37-7171e15870ec true true true 0 1026 1278 22 30 1026 1278 22 30 1038.5 1293 false 9c53bac0-ba66-40bd-8154-ce9829b9db1a Colour Swatch 255;140;140;140 Colour Swatch Swatch Colour (palette) swatch ebafb3be-900d-4f42-9ca7-ce04c5e3b2d7 false true true 0 750 1293 89 20 750 1293 89 20 750.6515 1293.022 false 59e0b89a-e487-49f8-bab8-b5bab16be14c Panel Panel A panel for custom notes and String values b8216c5e-019a-4953-9952-0b36baa1e7cb false true true 0 xlPatternDown true false false 1 0 false 255;255;255;255 255;0;0;0 750 1250 150 20 750 1250 150 20 750.8698 1250.431 false Microsoft Sans Serif 10 false false 9c53bac0-ba66-40bd-8154-ce9829b9db1a Colour Swatch 255;214;214;214 Colour Swatch Swatch Colour (palette) swatch b8d9c677-4205-414c-9aab-21524a1bd93a false true true 0 750 1271 89 20 750 1271 89 20 750.3755 1271.721 false 1e9e08fc-c31e-49eb-a36c-90de5e62e5f5 VB Script Dim arrList As New List(Of System.Object) Dim type As Integer Dim mark As Boolean Dim colr As Integer If _Type = "xl3DArea" Then type = -4098 mark = False colr = 1 ElseIf _Type = "xl3DAreaStacked" Then type = 78 mark = False colr = 1 ElseIf _Type = "xl3DAreaStacked100" Then type = 79 mark = False colr = 1 ElseIf _Type = "xl3DBarClustered" Then type = 60 mark = False colr = 0 ElseIf _Type = "xl3DBarStacked" Then type = 61 mark = False colr = 0 ElseIf _Type = "xl3DBarStacked100" Then type = 62 mark = False colr = 0 ElseIf _Type = "xl3DColumn" Then type = -4100 mark = False colr = 0 ElseIf _Type = "xl3DColumnClustered" Then type = 54 mark = False colr = 0 ElseIf _Type = "xl3DColumnStacked" Then type = 55 mark = False colr = 0 ElseIf _Type = "xl3DColumnStacked100" Then type = 56 mark = False colr = 0 ElseIf _Type = "xl3DLine" Then type = -4101 mark = False colr = 0 ElseIf _Type = "xl3DPie" Then type = -4102 mark = False colr = 0 ElseIf _Type = "xl3DPieExploded" Then type = 70 mark = False colr = 0 ElseIf _Type = "xlArea" Then type = 1 mark = False colr = 1 ElseIf _Type = "xlAreaStacked" Then type = 76 mark = False colr = 1 ElseIf _Type = "xlAreaStacked100" Then type = 77 mark = False colr = 1 ElseIf _Type = "xlBarClustered" Then type = 57 mark = False colr = 0 ElseIf _Type = "xlBarOfPie" Then type = 71 mark = False colr = 2 ElseIf _Type = "xlBarStacked" Then type = 58 mark = False colr = 0 ElseIf _Type = "xlBarStacked100" Then type = 59 mark = False colr = 0 ElseIf _Type = "xlBubble" Then type = 15 mark = False colr = 0 ElseIf _Type = "xlBubble3DEffect" Then type = 87 mark = False colr = 0 ElseIf _Type = "xlColumnClustered" Then type = 51 mark = False colr = 0 ElseIf _Type = "xlColumnStacked" Then type = 52 mark = False colr = 0 ElseIf _Type = "xlColumnStacked100" Then type = 53 mark = False colr = 0 ElseIf _Type = "xlConeBarClustered" Then type = 102 mark = False colr = 0 ElseIf _Type = "xlConeBarStacked" Then type = 103 mark = False colr = 0 ElseIf _Type = "xlConeBarStacked100" Then type = 104 mark = False colr = 0 ElseIf _Type = "xlConeCol" Then type = 105 mark = False colr = 0 ElseIf _Type = "xlConeColClustered" Then type = 99 mark = False colr = 0 ElseIf _Type = "xlConeColStacked" Then type = 100 mark = False colr = 0 ElseIf _Type = "xlConeColStacked100" Then type = 101 mark = False colr = 0 ElseIf _Type = "xlCylinderBarClustered" Then type = 95 mark = False colr = 0 ElseIf _Type = "xlCylinderBarStacked" Then type = 96 mark = False colr = 0 ElseIf _Type = "xlCylinderBarStacked100" Then type = 97 mark = False colr = 0 ElseIf _Type = "xlCylinderCol" Then type = 98 mark = False colr = 0 ElseIf _Type = "xlCylinderColClustered" Then type = 92 mark = False colr = 0 ElseIf _Type = "xlCylinderColStacked" Then type = 93 mark = False colr = 0 ElseIf _Type = "xlCylinderColStacked100" Then type = 94 mark = False colr = 0 ElseIf _Type = "xlDoughnut" Then type = -4120 mark = False colr = 0 ElseIf _Type = "xlDoughnutExploded" Then type = 80 mark = False colr = 0 ElseIf _Type = "xlLine" Then type = 4 mark = True colr = 0 ElseIf _Type = "xlLineMarkers" Then type = 65 mark = True colr = 0 ElseIf _Type = "xlLineMarkersStacked" Then type = 66 mark = True colr = 0 ElseIf _Type = "xlLineMarkersStacked100" Then type = 67 mark = True colr = 0 ElseIf _Type = "xlLineStacked" Then type = 63 mark = True colr = 0 ElseIf _Type = "xlLineStacked100" Then type = 64 mark = True colr = 0 ElseIf _Type = "xlPie" Then type = 5 mark = False colr = 0 ElseIf _Type = "xlPieExploded" Then type = 69 mark = False colr = 0 ElseIf _Type = "xlPieOfPie" Then type = 68 mark = False colr = 2 ElseIf _Type = "xlPyramidBarClustered" Then type = 109 mark = False colr = 0 ElseIf _Type = "xlPyramidBarStacked" Then type = 110 mark = False colr = 0 ElseIf _Type = "xlPyramidBarStacked100" Then type = 111 mark = False colr = 0 ElseIf _Type = "xlPyramidCol" Then type = 112 mark = False colr = 0 ElseIf _Type = "xlPyramidColClustered" Then type = 106 mark = False colr = 0 ElseIf _Type = "xlPyramidColStacked" Then type = 107 mark = False colr = 0 ElseIf _Type = "xlPyramidColStacked100" Then type = 108 mark = False colr = 0 ElseIf _Type = "xlRadar" Then type = -4151 mark = True colr = 0 ElseIf _Type = "xlRadarFilled" Then type = 82 mark = True colr = 1 ElseIf _Type = "xlRadarMarkers" Then type = 81 mark = True colr = 0 ElseIf _Type = "xlXYScatter" Then type = -4169 mark = True colr = 0 ElseIf _Type = "xlXYScatterLines" Then type = 74 mark = True colr = 0 ElseIf _Type = "xlXYScatterLinesNoMarkers" Then type = 75 mark = True colr = 0 ElseIf _Type = "xlXYScatterSmooth" Then type = 72 mark = True colr = 0 ElseIf _Type = "xlXYScatterSmoothNoMarkers" Then type = 73 mark = True colr = 0 Else type = 4 mark = True colr = 0 End If arrList.add(type) arrList.add(mark) arrList.add(colr) A = arrList 0 VB Script XL Chart A VB.NET scriptable component b8c415c6-1f50-488d-91f0-7f3b65929327 false true true longest_list 956 3343 94 71 999 3345 24 67 1011 3379 false 1 84fa917c-1ed8-4db3-8be1-7bdc4a6495a2 Variable x Script Variable x true true 2 3ede854e-c753-40eb-84cb-b48008f14fd4 Output Print, Reflect and Error streams true false 8ec86459-bf01-4409-baee-174d0d2b13d0 Result A Output parameter A true false Variable x _Type Script Variable x fb03870d-4bfe-4b7c-a250-684dbf09a21c true true true 1 5c487f3f-1514-4157-ba82-56048b5689d9 abf1fd1b-dbe5-4be6-9832-d8dc105e207f true true 958 3345 38 67 958 3345 38 67 978.5 3378.5 false Output out Print, Reflect and Error streams e315b9fb-b964-484f-9ea7-694aaea0645b false true true 0 1026 3345 22 33 1026 3345 22 33 1038.5 3361.75 false Result A A Output parameter A dd74a8f6-3bd6-4111-aef9-e3363f4a3e98 true true true 0 1026 3378 22 34 1026 3378 22 34 1038.5 3395.25 false 59e0b89a-e487-49f8-bab8-b5bab16be14c Panel Panel A panel for custom notes and String values 5c487f3f-1514-4157-ba82-56048b5689d9 false true true 0 xlDoughnut true false false 1 0 false 255;255;255;255 255;0;0;0 750 3346 150 48 750 3346 150 48 750.4183 3346.184 false Microsoft Sans Serif 10 false false 59e0b89a-e487-49f8-bab8-b5bab16be14c Panel Panel Chart Types A panel for custom notes and String values a84b2dd8-4f09-475b-9d1c-5e86415a4ae6 false true true 0 xl3DArea xl3DAreaStacked xl3DAreaStacked100 xl3DBarClustered xl3DBarStacked xl3DBarStacked100 xl3DColumn xl3DColumnClustered xl3DColumnStacked xl3DColumnStacked100 xl3DLine xl3DPie xl3DPieExploded xlArea xlAreaStacked xlAreaStacked100 xlBarClustered xlBarOfPie xlBarStacked xlBarStacked100 xlBubble xlBubble3DEffect xlColumnClustered xlColumnStacked xlColumnStacked100 xlConeBarClustered xlConeBarStacked xlConeBarStacked100 xlConeCol xlConeColClustered xlConeColStacked xlConeColStacked100 xlCylinderBarClustered xlCylinderBarStacked xlCylinderBarStacked100 xlCylinderCol xlCylinderColClustered xlCylinderColStacked xlCylinderColStacked100 xlDoughnut xlDoughnutExploded xlLine xlLineMarkers xlLineMarkersStacked xlLineMarkersStacked100 xlLineStacked xlLineStacked100 xlPie xlPieExploded xlPieOfPie xlPyramidBarClustered xlPyramidBarStacked xlPyramidBarStacked100 xlPyramidCol xlPyramidColClustered xlPyramidColStacked xlPyramidColStacked100 xlRadar xlRadarFilled xlRadarMarkers xlXYScatter xlXYScatterLines xlXYScatterLinesNoMarkers xlXYScatterSmooth xlXYScatterSmoothNoMarkers false true false 1 0.55263157894736836 false 255;0;0;0 255;255;255;0 450 3345 151 149 450 3345 151 149 450.3806 3345.555 false Microsoft Sans Serif 10 false false 59e0b89a-e487-49f8-bab8-b5bab16be14c Panel Panel XL Chart Type A panel for custom notes and String values 648ce89f-a776-4765-a3b1-3e9579b783a9 false true true 0 Chart: Type (64x "edited") http://msdn.microsoft.com/en-us/library/bb241008(v=office.12).aspx true true true 1 0 false 255;0;0;0 255;0;255;255 450 3250 599 55 450 3250 599 55 450.2156 3250.234 false 59e0b89a-e487-49f8-bab8-b5bab16be14c Panel Panel EXCEL TOOLS BRIEF A panel for custom notes and String values 577690f6-33fb-4a58-9364-00ace0293235 false true true 0 Brief: The excel output chart tool takes either a user defined pair of two dimensional points or an grasshopper excel tool output, which defines the 2d range for a set of data to be measured, then converts this data into a standard excel chart. This is a relatively new function, and may be a little buggy. Like the preceding output functions the inputs formatting are optional. Be sure to uncheck the "_stream" function once a satisfactory chart has been produced or a new chart will be made for every change made in grasshopper which precedes the function. THIS COMPONENT CURRENTLY ONLY WORKS IN EXCEL 2007+ Further Revisions to this component will be made, and functionality relative to actively changing an existing table, rather than constructing a new table each time will be added soon. All suggestion welcome. true true true 0 0 false 255;0;0;0 255;153;153;153 17 3001 1033 193 17 3001 1033 193 17.52574 3001.593 false Trebuchet MS 10 false false 59e0b89a-e487-49f8-bab8-b5bab16be14c Panel Panel EXCEL TOOLS INSTRUCTIONS A panel for custom notes and String values c3bf00b6-d9e3-4c51-aac8-5ab0ac464b83 false true true 0 Instructions: Table From XL: Creates an Excel Chart from Grasshopper -Chart Type (custom function) The input for the "XL Chart" function -Data_Origin (3d point) A Three dimensional point (only X and Y used) which determines the first cell that will be read from the active spreadsheet. X = column, Y = row -Data_Bound (3d point) A Three dimensional point (only X and Y used) which determines the furthest cell in a 2d range that will be read. X = column, Y = row. (if not used then the function will read until it encounters the first blank cell in the first position of a column) -ByColumn (boolean) Determines whether the specified range will be graphed by column first, or by row -Chart_Position (3d point) A Three dimensional point (only X and Y used) which Determines the Upper Left Hand corner origin of the chart in the sheets current units. X = hoizontal, Y = vertical. -Size (3d point) A Three dimensional point (only X and Y used) which Determines the boundry size the chart in the sheets current units. X = width, Y = height. ---optional -Title (string) A string which will be the title of the chart -Frame_Format (custom function) The input for the "XL Frame" function -Title_Format (custom function) An input for a "XL Font" function -Data_Format (custom function) The input for the "XL Data" function -Marker_Format (custom function) The input for the "XL Mark" function -Legend_Format (custom function) "UNDER DEVELOPED" An input for a "XL Font" function --- -_Stream (boolean) If False, the function will be inactive NOTE: "_Stream" should remain false until a new chart needs to be produced. Changing the data referenced by the chart will actively update the content,but not formatting. XL Chart: Defines the Chart Type _Type (string) An excel standard pattern type (see Chart Types list) XL Frame: Determines the chart area's background appearance _Pattern (string) An excel standard pattern type [see Cell Patterns list] -_Color (RGB color) Color of the pattern when available -_Fill (RGB color) XL Data: Determines Each Data Point's visualization options when available _Pattern (string) An excel standard pattern type [see Cell Patterns list] -_Color (RGB color) Color of the pattern when available -_Fill (RGB color) Color of the cell background -_Bevel (string) An excel standard 3d bevel effect [see Bevel Types list] -_DataLabel (boolean) Option to label data points on chart XL Mark: Creates and defines Data Point Markers where available _Marker (string) An excel standard pattern type [see Marker Types list] -_Color (RGB color) Color of the pattern when available -_Fill (RGB color) Color of the cell background _Size (double) The size of the marker (radius or width/ height) in the sheets current units true true true 0 0 false 255;0;0;0 255;153;153;153 17 3196 432 1262 17 3196 432 1262 17.00667 3196.679 false Trebuchet MS 10 false false 1e9e08fc-c31e-49eb-a36c-90de5e62e5f5 VB Script If _Stream = True Then Dim oldCI As System.Globalization.CultureInfo = system.Threading.Thread.CurrentThread.CurrentCulture System.Threading.Thread.CurrentThread.CurrentCulture = New System.Globalization.CultureInfo("en-US") Dim objExcel As Object objExcel = System.Runtime.InteropServices.Marshal.GetActiveObject("Excel.Application") Dim newSheet,excelSheet As Object excelSheet = objExcel.ActiveSheet newSheet = objExcel.Sheets.Add() excelSheet.Visible = False Dim i, j,r As Integer Dim x,y As Integer If Title = "" Then r = 0 Else excelSheet.Cells(CInt(Origin.Y), CInt(Origin.X)).Clear excelSheet.Cells(CInt(Origin.Y), CInt(Origin.X)).Value = Title r = 1 End If Dim ptA, ptB As Point3d If ByColumn = True Then x = Origin.X y = Origin.Y + data.Count() - 1 + r Else x = Origin.X + data.Count() - 1 + r y = Origin.Y End If ptA.X = Origin.X ptA.Y = Origin.Y ptA.Z = 0 A = ptA ptB.X = x ptB.Y = y ptB.Z = 0 B = ptB For i = 0 To data.Count() - 1 Step 1 If ByColumn = True Then x = Origin.X y = Origin.Y + r + i Else x = Origin.X + r + i y = Origin.Y End If ' clear and current information and write values to cells excelSheet.Cells(CInt(y), CInt(x)).Clear excelSheet.Cells(CInt(y), CInt(x)).Value = data(i) ' if text formatting is active, run the options If Font_Format.BranchCount() > 0 Then If Font_Format.BranchCount() = 1 Then j = 0 Else j = i End If With excelSheet.Cells(CInt(y), CInt(x)) .Font.Size = CInt(Font_Format.branch(j).item(0)) .Font.Color = RGB(CInt(Font_Format.branch(j).item(1).r), CInt(Font_Format.branch(j).item(1).g), CInt(Font_Format.branch(j).item(1).b)) .HorizontalAlignment = CInt(Font_Format.branch(j).item(2)) .VerticalAlignment = CInt(Font_Format.branch(j).item(3)) .Font.Bold = CBool(Font_Format.branch(j).item(4)) .Font.Italic = CBool(Font_Format.branch(j).item(5)) .Font.Underline = CBool(Font_Format.branch(j).item(6)) .Font.Strikethrough = CBool(Font_Format.branch(j).item(7)) .Font.Subscript = CBool(Font_Format.branch(j).item(8)) .Font.Superscript = CBool(Font_Format.branch(j).item(9)) End With End If ' if cell formatting is active, run the options If Cell_Format.BranchCount() > 0 Then If Cell_Format.BranchCount() = 1 Then j = 0 Else j = i End If With excelSheet.Cells(CInt(y), CInt(x)) .Interior.Pattern = CInt(Cell_Format.branch(j).item(0)) .Interior.Patterncolor = RGB(CInt(Cell_Format.branch(j).item(1).r), CInt(Cell_Format.branch(j).item(1).g), CInt(Cell_Format.branch(j).item(1).b)) .Interior.color = RGB(CInt(Cell_Format.branch(j).item(2).r), CInt(Cell_Format.branch(j).item(2).g), CInt(Cell_Format.branch(j).item(2).b)) End With End If ' if cell formatting is active, run the options If Border_Format.BranchCount() > 0 Then If Border_Format.BranchCount() = 1 Then j = 0 Else j = i End If With excelSheet.Cells(CInt(y), CInt(x)) .Borders.item(10).lineStyle = CInt(Border_Format.branch(j).item(0)) .Borders.item(10).Weight = CInt(Border_Format.branch(j).item(1)) .Borders.item(10).Color = RGB(CInt(Border_Format.branch(j).item(2).r), CInt(Border_Format.branch(j).item(2).g), CInt(Border_Format.branch(j).item(2).b)) .Borders.item(7).lineStyle = CInt(Border_Format.branch(j).item(3)) .Borders.item(7).Weight = CInt(Border_Format.branch(j).item(4)) .Borders.item(7).Color = RGB(CInt(Border_Format.branch(j).item(5).r), CInt(Border_Format.branch(j).item(5).g), CInt(Border_Format.branch(j).item(5).b)) .Borders.item(8).lineStyle = CInt(Border_Format.branch(j).item(6)) .Borders.item(8).Weight = CInt(Border_Format.branch(j).item(7)) .Borders.item(8).Color = RGB(CInt(Border_Format.branch(j).item(8).r), CInt(Border_Format.branch(j).item(8).g), CInt(Border_Format.branch(j).item(8).b)) .Borders.item(9).lineStyle = CInt(Border_Format.branch(j).item(9)) .Borders.item(9).Weight = CInt(Border_Format.branch(j).item(10)) .Borders.item(9).Color = RGB(CInt(Border_Format.branch(j).item(11).r), CInt(Border_Format.branch(j).item(11).g), CInt(Border_Format.branch(j).item(11).b)) End With End If Next newSheet.activate newSheet.Delete() excelSheet.visible = True excelSheet.activate A = ptA B = ptB End If 0 VB Script List to XL adv A VB.NET scriptable component 8f36f35f-020b-419c-b37a-7b7530546f8d false true true longest_list 1963 901 137 164 2049 903 24 160 2061 983 false 8 84fa917c-1ed8-4db3-8be1-7bdc4a6495a2 Variable Origin Script Variable Origin true true 84fa917c-1ed8-4db3-8be1-7bdc4a6495a2 Variable ByColumn Script Variable ByColumn true true 84fa917c-1ed8-4db3-8be1-7bdc4a6495a2 Variable Title Script Variable Title true true 84fa917c-1ed8-4db3-8be1-7bdc4a6495a2 Variable Data Script Variable Data 1 true true 84fa917c-1ed8-4db3-8be1-7bdc4a6495a2 Variable Font_Format Script Variable Font_Format 2 true true 84fa917c-1ed8-4db3-8be1-7bdc4a6495a2 Variable Cell_Format Script Variable Cell_Format 2 true true 84fa917c-1ed8-4db3-8be1-7bdc4a6495a2 Variable Border_Format Script Variable Border_Format 2 true true 84fa917c-1ed8-4db3-8be1-7bdc4a6495a2 Variable _Stream Script Variable _Stream true true 3 3ede854e-c753-40eb-84cb-b48008f14fd4 Output Print, Reflect and Error streams true false 8ec86459-bf01-4409-baee-174d0d2b13d0 Result A Output parameter A true false 8ec86459-bf01-4409-baee-174d0d2b13d0 Result B Output parameter B true false Variable Origin Origin Script Variable Origin 0dc64758-2803-4774-b5be-ace89e06614d true true true 1 470ce3db-af89-42a8-9602-f6185cc6e4bf e1937b56-b1da-4c12-8bd8-e34ee81746ef true true 1965 903 81 20 1965 903 81 20 2007 913 false Variable ByColumn ByColumn Script Variable ByColumn d49889aa-51e4-4b85-9882-f115086a590c true true true 1 220eb874-142f-4128-aec7-4c690b76b45d 3cda2745-22ac-4244-9b04-97a5255fa60f true true 1965 923 81 20 1965 923 81 20 2007 933 false Variable Title Title Script Variable Title d3cf4336-cc38-42cb-a6e1-c6ada411d050 true true true 1 a0e23e1e-4f10-4511-97ea-61503b63ff20 abf1fd1b-dbe5-4be6-9832-d8dc105e207f true true 1965 943 81 20 1965 943 81 20 2007 953 false Variable Data Data Script Variable Data 5ed22c96-be10-463b-8db5-7f6777abc862 true true true 1 1 f0633e9a-65fc-4f99-8677-030ebe728e3a true true 1965 963 81 20 1965 963 81 20 2007 973 false Variable Font_Format Font_Format Script Variable Font_Format 2713cf28-32b4-4bfb-ad63-4cf832e110d0 true true true 2 1 06f8d0de-94e1-42da-ab7a-4ac4b3476b4c true true 1965 983 81 20 1965 983 81 20 2007 993 false Variable Cell_Format Cell_Format Script Variable Cell_Format c10b07d2-a024-4d6f-8bde-a122e1732a7e true true true 2 1 cc59c0c1-7f8d-4293-810a-4b6238d4b9c5 true true 1965 1003 81 20 1965 1003 81 20 2007 1013 false Variable Border_Format Border_Format Script Variable Border_Format fd53d5d9-3866-4207-9eab-504d9e0712d3 true true true 2 1 d6f562f9-8476-4d1f-a6a8-1c0ffa2c9b96 true true 1965 1023 81 20 1965 1023 81 20 2007 1033 false Variable _Stream _Stream Script Variable _Stream 8818e11a-9886-4907-8155-3ae520409736 true true true 1 ae47ee40-0896-46b0-ad39-b34a9b4d7314 3cda2745-22ac-4244-9b04-97a5255fa60f true true 1965 1043 81 20 1965 1043 81 20 2007 1053 false Output out Print, Reflect and Error streams 61454f4a-2bfd-4e9b-b5aa-8df752e91b16 false true true 0 2076 903 22 53 2076 903 22 53 2088.5 929.6667 false Result A A Output parameter A 7e592f68-9b2f-44a5-a377-ddd553937baa true true true 0 2076 956 22 53 2076 956 22 53 2088.5 983 false Result B B Output parameter B 6e64b42d-7188-4d41-917c-076f586c8482 true true true 0 2076 1009 22 54 2076 1009 22 54 2088.5 1036.333 false 2e3ab970-8545-46bb-836c-1c11e5610bce Integer Integer Int Represents a collection of Integer numbers edb33e2f-ae9e-4e35-a77e-a636aaad23eb false true true 1 77aa638b-7c50-418b-8a72-25e0a874cb1e 1600 4038 50 20 1600 4038 50 20 1625.866 4048.3 false 59e0b89a-e487-49f8-bab8-b5bab16be14c Panel Panel A panel for custom notes and String values 77aa638b-7c50-418b-8a72-25e0a874cb1e false true true 0 50 true true true 1 0 false 255;0;0;0 255;255;255;255 1500 4039 64 20 1500 4039 64 20 1500.89 4039.192 false 2e3ab970-8545-46bb-836c-1c11e5610bce Integer Integer Int Represents a collection of Integer numbers 1c5cf8e8-9d1b-4c83-9103-1ec26f5192f9 false true true 1 179e4566-e68a-466d-a382-f527209c0d52 1600 4059 50 20 1600 4059 50 20 1625.515 4069.022 false 59e0b89a-e487-49f8-bab8-b5bab16be14c Panel Panel A panel for custom notes and String values 179e4566-e68a-466d-a382-f527209c0d52 false true true 0 150 true true true 1 0 false 255;0;0;0 255;255;255;255 1500 4059 64 20 1500 4059 64 20 1500.405 4059.993 false 2e3ab970-8545-46bb-836c-1c11e5610bce Integer Integer Int Represents a collection of Integer numbers 5a4eae1f-606a-44ab-85a6-70e1edd501ba false true true 1 a3a116f1-67dc-4c45-b044-59a3ae46ea54 1600 4080 50 20 1600 4080 50 20 1625.648 4090.418 false 59e0b89a-e487-49f8-bab8-b5bab16be14c Panel Panel A panel for custom notes and String values a3a116f1-67dc-4c45-b044-59a3ae46ea54 false true true 0 600 true true true 1 0 false 255;0;0;0 255;255;255;255 1500 4081 64 20 1500 4081 64 20 1500.404 4081.406 false 2e3ab970-8545-46bb-836c-1c11e5610bce Integer Integer Int Represents a collection of Integer numbers 7196a507-704d-474d-9d95-71d4c369f688 false true true 1 902ce259-6b6c-46fb-84d5-e5c7cffc594c 1600 4101 50 20 1600 4101 50 20 1625.565 4111.407 false 59e0b89a-e487-49f8-bab8-b5bab16be14c Panel Panel A panel for custom notes and String values 902ce259-6b6c-46fb-84d5-e5c7cffc594c false true true 0 600 true true true 1 0 false 255;0;0;0 255;255;255;255 1500 4102 64 20 1500 4102 64 20 1500.725 4102.547 false 3581f42a-9592-4549-bd6b-1c0fc39d067b Point XYZ Point XYZ Pt Create a point from {xyz} coordinates. 7a316c06-1df2-47c4-bb79-be5d35076f25 false true true longest_list 1735 4034 65 64 1754 4036 24 60 1766 4066 false X component X {x} component 8be2be3c-dcff-48d4-b845-90d668ad7769 false true true 1 edb33e2f-ae9e-4e35-a77e-a636aaad23eb 1 1737 4036 14 20 1737 4036 14 20 1745.5 4046 false 0 Y component Y {y} component 0f34db17-ec0b-41a6-b59c-3fa4e3df59ff false true true 1 1c5cf8e8-9d1b-4c83-9103-1ec26f5192f9 1 1737 4056 14 20 1737 4056 14 20 1745.5 4066 false 0 Z component Z {z} component a3d94d9e-d040-49ab-b3f2-0e2b11cdfb7a false true true 0 1 1737 4076 14 20 1737 4076 14 20 1745.5 4086 false 0 Point Pt Point coordinate 0ae5a9a7-a242-4d6d-b72e-e5d62e9436dc true true true 0 1781 4036 17 60 1781 4036 17 60 1791 4066 false 3581f42a-9592-4549-bd6b-1c0fc39d067b Point XYZ Point XYZ Pt Create a point from {xyz} coordinates. 3783baa5-60d9-460e-8ddc-5b323127946d false true true longest_list 1735 4099 65 64 1754 4101 24 60 1766 4131 false X component X {x} component e4174684-1b2d-4e29-bc1a-9717795dbb6b false true true 1 5a4eae1f-606a-44ab-85a6-70e1edd501ba 1 1737 4101 14 20 1737 4101 14 20 1745.5 4111 false 0 Y component Y {y} component 18c08510-9204-4beb-8001-6b357b959651 false true true 1 7196a507-704d-474d-9d95-71d4c369f688 1 1737 4121 14 20 1737 4121 14 20 1745.5 4131 false 0 Z component Z {z} component 81842915-8aeb-49a8-8330-e87adcb66022 false true true 0 1 1737 4141 14 20 1737 4141 14 20 1745.5 4151 false 0 Point Pt Point coordinate ae48a36b-d93c-4db9-85c7-cd5db20cc86c true true true 0 1781 4101 17 60 1781 4101 17 60 1791 4131 false ad483f40-dc72-40dc-844d-c9e462c7d19f Boolean Toggle true Boolean Toggle Toggle Boolean (true/false) toggle 8707856e-2433-44bb-a0e0-13ccbede08c4 false true true 0 1714 4014 87 20 1714 4014 87 20 1714.031 4014.547 false 1e9e08fc-c31e-49eb-a36c-90de5e62e5f5 VB Script Dim arrList As New List(Of System.Object) Dim patt As Integer If _Pattern = "xlPatternAutomatic" Then patt = -4105 ElseIf _Pattern = "xlPatternChecker" Then patt = 9 ElseIf _Pattern = "xlPatternCrissCross" Then patt = 16 ElseIf _Pattern = "xlPatternDown" Then patt = -4121 ElseIf _Pattern = "xlPatternGray16" Then patt = 17 ElseIf _Pattern = "xlPatternGray25" Then patt = -4124 ElseIf _Pattern = "xlPatternGray75" Then patt = -4125 ElseIf _Pattern = "xlPatternGray8" Then patt = 18 ElseIf _Pattern = "xlPatternGrid" Then patt = 15 ElseIf _Pattern = "xlPatternHorizontal" Then patt = -4128 ElseIf _Pattern = "xlPatternLightDown" Then patt = 13 ElseIf _Pattern = "xlPatternLightHorizontal" Then patt = 11 ElseIf _Pattern = "xlPatternLightUp" Then patt = 14 ElseIf _Pattern = "xlPatternLightVertical" Then patt = 12 ElseIf _Pattern = "xlPatternNone" Then patt = -4142 ElseIf _Pattern = "xlPatternSemiGray75" Then patt = 10 ElseIf _Pattern = "xlPatternSolid" Then patt = 1 ElseIf _Pattern = "xlPatternUp" Then patt = -4162 ElseIf _Pattern = "xlPatternVertical" Then patt = -4166 Else patt = -4105 End If arrList.Add(patt) arrList.Add(_Fill) arrList.Add(_Color) A = arrList 0 VB Script XL Frame A VB.NET scriptable component ca59f4a7-ece1-4c6b-b403-db47c698cb95 false true true longest_list 945 3573 105 77 999 3575 24 73 1011 3612 false 3 84fa917c-1ed8-4db3-8be1-7bdc4a6495a2 Variable _Pattern Script Variable _Pattern true true 84fa917c-1ed8-4db3-8be1-7bdc4a6495a2 Variable _Patt_fill Script Variable _Patt_fill true true 84fa917c-1ed8-4db3-8be1-7bdc4a6495a2 Variable _Patt_clr Script Variable _Patt_clr true true 2 3ede854e-c753-40eb-84cb-b48008f14fd4 Output Print, Reflect and Error streams true false 8ec86459-bf01-4409-baee-174d0d2b13d0 Result A Output parameter A true false Variable _Pattern _Pattern Script Variable _Pattern 85a8cc80-a4ea-4298-92df-0222af46b441 true true true 1 4fd8a45c-1d03-4fc1-82a4-ad0aeea25f5b true true 947 3575 49 24 947 3575 49 24 973 3587.167 false Variable _Patt_fill _Color Script Variable _Patt_fill 6f743b87-b064-432c-a731-1eda52ddf120 true true true 1 d1c9ec6a-a389-43b5-aae9-4606d1685aae 24b1d1a3-ab79-498c-9e44-c5b14607c4d3 true true 947 3599 49 24 947 3599 49 24 973 3611.5 false Variable _Patt_clr _Fill Script Variable _Patt_clr 480137e7-0e7c-45d9-8163-5c2f2ee77e4c true true true 1 025179b4-f8b6-415c-a563-bd68260ce458 24b1d1a3-ab79-498c-9e44-c5b14607c4d3 true true 947 3623 49 25 947 3623 49 25 973 3635.833 false Output out Print, Reflect and Error streams f60f1f84-e22b-46d5-abf3-652abc95844f false true true 0 1026 3575 22 36 1026 3575 22 36 1038.5 3593.25 false Result A A Output parameter A b392a86b-1c25-495a-afb6-2b6a5d165212 true true true 0 1026 3611 22 37 1026 3611 22 37 1038.5 3629.75 false 59e0b89a-e487-49f8-bab8-b5bab16be14c Panel Panel A panel for custom notes and String values 4fd8a45c-1d03-4fc1-82a4-ad0aeea25f5b false true true 0 xlPatternLightDown true false false 1 0 false 255;255;255;255 255;0;0;0 750 3576 150 20 750 3576 150 20 750.4901 3576.627 false Microsoft Sans Serif 10 false false 9c53bac0-ba66-40bd-8154-ce9829b9db1a Colour Swatch 255;43;43;43 Colour Swatch Swatch Colour (palette) swatch d1c9ec6a-a389-43b5-aae9-4606d1685aae false true true 0 750 3597 89 20 750 3597 89 20 750.6141 3597.464 false 9c53bac0-ba66-40bd-8154-ce9829b9db1a Colour Swatch 255;0;0;0 Colour Swatch Swatch Colour (palette) swatch 025179b4-f8b6-415c-a563-bd68260ce458 false true true 0 750 3618 89 20 750 3618 89 20 750.3382 3618.367 false 59e0b89a-e487-49f8-bab8-b5bab16be14c Panel Panel A panel for custom notes and String values 5c5a5a2c-23b9-4970-b998-f6e11a03a290 false true true 0 Grasshopper-Excel (LIVE) true false false 0 0 false 255;255;255;255 255;0;0;0 1501 4203 301 20 1501 4203 301 20 1501.033 4203.373 false Microsoft Sans Serif 10 false false f19b8c33-dff2-4cc2-b95b-b4005ff3c10c Receiver true 1 Receiver Point Taken from A output of Write to Excel A data receiver object. 4d889f1b-0777-4d60-974f-0d9a92725ab4 false true true 1 de0295c2-079e-4848-a2db-4bf9c0062ca6 1560 3972 240 20 1560 3972 240 20 1680.778 3982.833 false 1e9e08fc-c31e-49eb-a36c-90de5e62e5f5 VB Script Dim arrList As New List(Of System.Object) Dim patt,bev As Integer If _Pattern = "xlPatternAutomatic" Then patt = -4105 ElseIf _Pattern = "xlPatternChecker" Then patt = 9 ElseIf _Pattern = "xlPatternCrissCross" Then patt = 16 ElseIf _Pattern = "xlPatternDown" Then patt = -4121 ElseIf _Pattern = "xlPatternGray16" Then patt = 17 ElseIf _Pattern = "xlPatternGray25" Then patt = -4124 ElseIf _Pattern = "xlPatternGray75" Then patt = -4125 ElseIf _Pattern = "xlPatternGray8" Then patt = 18 ElseIf _Pattern = "xlPatternGrid" Then patt = 15 ElseIf _Pattern = "xlPatternHorizontal" Then patt = -4128 ElseIf _Pattern = "xlPatternLightDown" Then patt = 13 ElseIf _Pattern = "xlPatternLightHorizontal" Then patt = 11 ElseIf _Pattern = "xlPatternLightUp" Then patt = 14 ElseIf _Pattern = "xlPatternLightVertical" Then patt = 12 ElseIf _Pattern = "xlPatternNone" Then patt = -4142 ElseIf _Pattern = "xlPatternSemiGray75" Then patt = 10 ElseIf _Pattern = "xlPatternSolid" Then patt = 1 ElseIf _Pattern = "xlPatternUp" Then patt = -4162 ElseIf _Pattern = "xlPatternVertical" Then patt = -4166 Else patt = -4105 End If If _Bevel = "msoBevelAngle" Then bev = 6 ElseIf _Bevel = "msoBevelArtDeco" Then bev = 13 ElseIf _Bevel = "msoBevelCircle" Then bev = 3 ElseIf _Bevel = "msoBevelConvex" Then bev = 8 ElseIf _Bevel = "msoBevelCoolSlant" Then bev = 9 ElseIf _Bevel = "msoBevelCross" Then bev = 5 ElseIf _Bevel = "msoBevelDivot" Then bev = 10 ElseIf _Bevel = "msoBevelHardEdge" Then bev = 12 ElseIf _Bevel = "msoBevelNone" Then bev = 1 ElseIf _Bevel = "msoBevelRelaxedInset" Then bev = 2 ElseIf _Bevel = "msoBevelRiblet" Then bev = 11 ElseIf _Bevel = "msoBevelSlope" Then bev = 4 ElseIf _Bevel = "msoBevelSoftRound" Then bev = 7 ElseIf _Bevel = "msoBevelTypeMixed" Then bev = -2 Else bev = 1 End If arrList.add(patt) arrList.add(_Color) arrList.add(_Fill) arrList.add(bev) arrList.add(_DataLabel) A = arrList 0 VB Script XL Data A VB.NET scriptable component 6801e7ea-ffbf-40c7-8e7b-82f796f82cb1 false true true longest_list 931 3825 119 104 999 3827 24 100 1011 3877 false 5 84fa917c-1ed8-4db3-8be1-7bdc4a6495a2 Variable _Pattern Script Variable _Pattern true true 84fa917c-1ed8-4db3-8be1-7bdc4a6495a2 Variable _Color Script Variable _Color true true 84fa917c-1ed8-4db3-8be1-7bdc4a6495a2 Variable _Fill Script Variable _Fill true true 84fa917c-1ed8-4db3-8be1-7bdc4a6495a2 Variable _Bevel Script Variable _Bevel true true 84fa917c-1ed8-4db3-8be1-7bdc4a6495a2 Variable _DataLabel Script Variable _DataLabel true true 2 3ede854e-c753-40eb-84cb-b48008f14fd4 Output Print, Reflect and Error streams true false 8ec86459-bf01-4409-baee-174d0d2b13d0 Result A Output parameter A true false Variable _Pattern _Pattern Script Variable _Pattern 855e0365-e2f1-4ebb-ae33-0da897585e2f true true true 1 680a2671-dfe6-42b9-9920-978c73c06a3d abf1fd1b-dbe5-4be6-9832-d8dc105e207f true true 933 3827 63 20 933 3827 63 20 966 3837 false Variable _Color _Color Script Variable _Color ba2ec0be-8a89-4e86-93ae-47bca98949d0 true true true 1 d2dbd19c-c0b0-458b-afaa-ba871d6b0e2d 6a184b65-baa3-42d1-a548-3915b401de53 true true 933 3847 63 20 933 3847 63 20 966 3857 false Variable _Fill _Fill Script Variable _Fill d0dfd210-1ede-416d-a946-ef3327b0e7fc true true true 1 30f27439-23e8-4ec3-9424-28f56f53a6c9 6a184b65-baa3-42d1-a548-3915b401de53 true true 933 3867 63 20 933 3867 63 20 966 3877 false Variable _Bevel _Bevel Script Variable _Bevel 4acfa79c-fc1f-426f-9a50-17bc29e61ca6 true true true 1 0ec2f6f1-b2f6-4024-a4a1-49bf7e4d125d abf1fd1b-dbe5-4be6-9832-d8dc105e207f true true 933 3887 63 20 933 3887 63 20 966 3897 false Variable _DataLabel _DataLabel Script Variable _DataLabel 8bddf6b9-81d1-4ea1-a0fe-9e86fba88bb5 true true true 1 1d79a185-6610-493b-a2aa-81e909e0c026 3cda2745-22ac-4244-9b04-97a5255fa60f true true 933 3907 63 20 933 3907 63 20 966 3917 false Output out Print, Reflect and Error streams 5f533698-ba2e-434f-8ead-a27c113f04cb false true true 0 1026 3827 22 50 1026 3827 22 50 1038.5 3852 false Result A A Output parameter A 98680d24-e0f2-46d5-8100-9a571ccabe27 true true true 0 1026 3877 22 50 1026 3877 22 50 1038.5 3902 false 1e9e08fc-c31e-49eb-a36c-90de5e62e5f5 VB Script Dim arrList As New List(Of System.Object) Dim stl, wgt As Integer If _Weight = "xlHairline" Then wgt = 1 ElseIf _Weight = "xlMedium" Then wgt = -4138 ElseIf _Weight = "xlThick" Then wgt = 4 ElseIf _Weight = "xlThin" Then wgt = 2 End If If _Style = "xlContinuous" Then stl = 1 ElseIf _Style = "xlDash" Then stl = -4115 ElseIf _Style = "xlDashDot" Then stl = 4 ElseIf _Style = "xlDashDotDot" Then stl = 5 ElseIf _Style = "xlDot" Then stl = -4118 ElseIf _Style = "xlDouble" Then stl = -4119 ElseIf _Style = "xlLineStyleNone" Then stl = -4142 ElseIf _Style = "xlSlantDashDot" Then stl = 13 End If arrList.add(stl) arrList.add(wgt) arrList.add(_Color) arrList.add(stl) arrList.add(wgt) arrList.add(_Color) arrList.add(stl) arrList.add(wgt) arrList.add(_Color) arrList.add(stl) arrList.add(wgt) arrList.add(_Color) A = arrList 0 VB Script XL Border A VB.NET scriptable component 2756df5f-9254-4477-87ee-3d6b9a03e132 false true true longest_list 947 1796 103 80 999 1798 24 76 1011 1836 false 3 84fa917c-1ed8-4db3-8be1-7bdc4a6495a2 Variable _Style Script Variable _Style true true 84fa917c-1ed8-4db3-8be1-7bdc4a6495a2 Variable _Weight Script Variable _Weight true true 84fa917c-1ed8-4db3-8be1-7bdc4a6495a2 Variable _Color Script Variable _Color true true 2 3ede854e-c753-40eb-84cb-b48008f14fd4 Output Print, Reflect and Error streams true false 8ec86459-bf01-4409-baee-174d0d2b13d0 Result A Output parameter A true false Variable _Style _Style Script Variable _Style 8d960aaa-d23e-43aa-8250-bcdbc7bafba6 true true true 1 6fa1ab49-6008-4f9f-a556-c86d2ec75a64 abf1fd1b-dbe5-4be6-9832-d8dc105e207f true true 949 1798 47 25 949 1798 47 25 974 1810.667 false Variable _Weight _Weight Script Variable _Weight 7eb1f94d-4ec5-4329-bcc7-0a094d36c1c3 true true true 1 c388504d-9dc4-4700-bd95-717ed3e5a379 abf1fd1b-dbe5-4be6-9832-d8dc105e207f true true 949 1823 47 25 949 1823 47 25 974 1836 false Variable _Color _Color Script Variable _Color fd37dc55-4e0a-422a-b90b-613d2405d1bd true true true 1 64d78b8a-a261-4545-a260-c7acef41a55c 6a184b65-baa3-42d1-a548-3915b401de53 true true 949 1848 47 25 949 1848 47 25 974 1861.333 false Output out Print, Reflect and Error streams e7e313ed-8c0b-4fa6-be5c-307a5ea58bac false true true 0 1026 1798 22 38 1026 1798 22 38 1038.5 1817 false Result A A Output parameter A 83494904-50a3-4c0e-8831-773d8dea3c2f true true true 0 1026 1836 22 38 1026 1836 22 38 1038.5 1855 false 1e9e08fc-c31e-49eb-a36c-90de5e62e5f5 VB Script Dim arrList As New List(Of System.Object) Dim wgt, stl As New list(Of Integer) Dim arrW(), arrS() As String arrW = New String(){_R_Weight,_L_Weight,_T_Weight,_B_Weight} arrS = New String(){_R_Style,_L_Style,_T_Style,_B_Style} Dim i As Integer For i = 0 To 3 Step 1 If arrW(i) = "xlHairline" Then wgt.add(1) ElseIf arrW(i) = "xlMedium" Then wgt.add(-4138) ElseIf arrW(i) = "xlThick" Then wgt.add(4) ElseIf arrW(i) = "xlThin" Then wgt.add(2) Else wgt.add(1) End If If arrS(i) = "xlContinuous" Then stl.add(1) ElseIf arrS(i) = "xlDash" Then stl.add(-4115) ElseIf arrS(i) = "xlDashDot" Then stl.add(4) ElseIf arrS(i) = "xlDashDotDot" Then stl.add(5) ElseIf arrS(i) = "xlDot" Then stl.add(-4118) ElseIf arrS(i) = "xlDouble" Then stl.add(-4119) ElseIf arrS(i) = "xlLineStyleNone" Then stl.add(-4142) ElseIf arrS(i) = "xlSlantDashDot" Then stl.add(13) End If Next arrList.add(stl(0)) arrList.add(wgt(0)) arrList.add(_L_Color) arrList.add(stl(1)) arrList.add(wgt(1)) arrList.add(_R_Color) arrList.add(stl(2)) arrList.add(wgt(2)) arrList.add(_T_Color) arrList.add(stl(3)) arrList.add(wgt(3)) arrList.add(_B_Color) A = arrList 0 VB Script XL Border Edges A VB.NET scriptable component 3eb8b707-9873-4d91-988b-122bd20d940d false true true longest_list 932 1496 117 244 998 1498 24 240 1010 1618 false 12 84fa917c-1ed8-4db3-8be1-7bdc4a6495a2 Variable _L_Style Script Variable _L_Style true true 84fa917c-1ed8-4db3-8be1-7bdc4a6495a2 Variable _L_Weight Script Variable _L_Weight true true 84fa917c-1ed8-4db3-8be1-7bdc4a6495a2 Variable _L_Color Script Variable _L_Color true true 84fa917c-1ed8-4db3-8be1-7bdc4a6495a2 Variable _R_Style Script Variable _R_Style true true 84fa917c-1ed8-4db3-8be1-7bdc4a6495a2 Variable _R_Weight Script Variable _R_Weight true true 84fa917c-1ed8-4db3-8be1-7bdc4a6495a2 Variable _R_Color Script Variable _R_Color true true 84fa917c-1ed8-4db3-8be1-7bdc4a6495a2 Variable _T_Style Script Variable _T_Style true true 84fa917c-1ed8-4db3-8be1-7bdc4a6495a2 Variable _T_Weight Script Variable _T_Weight true true 84fa917c-1ed8-4db3-8be1-7bdc4a6495a2 Variable _T_Color Script Variable _T_Color true true 84fa917c-1ed8-4db3-8be1-7bdc4a6495a2 Variable _B_Style Script Variable _B_Style true true 84fa917c-1ed8-4db3-8be1-7bdc4a6495a2 Variable _B_Weight Script Variable _B_Weight true true 84fa917c-1ed8-4db3-8be1-7bdc4a6495a2 Variable _B_Color Script Variable _B_Color true true 2 3ede854e-c753-40eb-84cb-b48008f14fd4 Output Print, Reflect and Error streams true false 8ec86459-bf01-4409-baee-174d0d2b13d0 Result A Output parameter A true false Variable _L_Style _L_Style Script Variable _L_Style 84cbb458-eca8-4602-b6c5-74da3838cc72 true true true 1 0e545459-f6d9-435e-ba52-c35023e918b0 abf1fd1b-dbe5-4be6-9832-d8dc105e207f true true 934 1498 61 20 934 1498 61 20 966 1508 false Variable _L_Weight _L_Weight Script Variable _L_Weight 62d8ed64-cb72-4e1f-9a49-3d56a26809aa true true true 1 fffb6183-fa8e-422e-8e7c-e6fd94798b2f abf1fd1b-dbe5-4be6-9832-d8dc105e207f true true 934 1518 61 20 934 1518 61 20 966 1528 false Variable _L_Color _L_Color Script Variable _L_Color 5ca3230a-e36c-4cf2-a2dd-6469e44c9ca0 true true true 1 a0cc5402-9c07-4b0e-b2b3-3692ff61fa02 6a184b65-baa3-42d1-a548-3915b401de53 true true 934 1538 61 20 934 1538 61 20 966 1548 false Variable _R_Style _R_Style Script Variable _R_Style 97a58f7d-0e27-4d17-b0ff-e9d9cb8f31e4 true true true 1 3462c75e-0c2c-4fce-9169-085561ac443a abf1fd1b-dbe5-4be6-9832-d8dc105e207f true true 934 1558 61 20 934 1558 61 20 966 1568 false Variable _R_Weight _R_Weight Script Variable _R_Weight 402b4fad-1e49-4434-a45a-766bb1bc9e73 true true true 1 ed01b16c-71c7-4c9b-bbd6-0865e162d058 abf1fd1b-dbe5-4be6-9832-d8dc105e207f true true 934 1578 61 20 934 1578 61 20 966 1588 false Variable _R_Color _R_Color Script Variable _R_Color 1e930478-ecf8-479a-9073-565f49fc2a97 true true true 1 4c87252f-25b4-45c5-8120-9376e9c02433 6a184b65-baa3-42d1-a548-3915b401de53 true true 934 1598 61 20 934 1598 61 20 966 1608 false Variable _T_Style _T_Style Script Variable _T_Style 95ef2f70-423a-4fc9-870f-c49d3c07f71e true true true 1 8c3b2e3c-9876-4226-9e41-2cc17567a514 abf1fd1b-dbe5-4be6-9832-d8dc105e207f true true 934 1618 61 20 934 1618 61 20 966 1628 false Variable _T_Weight _T_Weight Script Variable _T_Weight daa38d03-426f-4321-a12f-5aaea6185939 true true true 1 d6dfabab-60f9-4680-98c0-4048aeec3b4d abf1fd1b-dbe5-4be6-9832-d8dc105e207f true true 934 1638 61 20 934 1638 61 20 966 1648 false Variable _T_Color _T_Color Script Variable _T_Color 0ed1d9b5-ce67-40d4-a0fb-15710dcedc05 true true true 1 93309c44-957f-4b51-989a-afdcc9d3be2b 6a184b65-baa3-42d1-a548-3915b401de53 true true 934 1658 61 20 934 1658 61 20 966 1668 false Variable _B_Style _B_Style Script Variable _B_Style 8cf6235f-b21d-4278-af50-4cfa2c7f4c64 true true true 1 0818a40c-79ea-4260-8ec8-c9aa4aeffdfb abf1fd1b-dbe5-4be6-9832-d8dc105e207f true true 934 1678 61 20 934 1678 61 20 966 1688 false Variable _B_Weight _B_Weight Script Variable _B_Weight a79a68ce-f070-4af6-83ba-239a32b91da2 true true true 1 890a4d86-e674-4975-966d-0e945f84af51 abf1fd1b-dbe5-4be6-9832-d8dc105e207f true true 934 1698 61 20 934 1698 61 20 966 1708 false Variable _B_Color _B_Color Script Variable _B_Color 9047f505-98a0-47c5-92b9-f7cb61cd841e true true true 1 fec78108-1b7d-4a3c-97e5-39b3e1bc04d4 6a184b65-baa3-42d1-a548-3915b401de53 true true 934 1718 61 20 934 1718 61 20 966 1728 false Output out Print, Reflect and Error streams c846b706-7ad8-4855-a70d-3b0619a67e9a false true true 0 1025 1498 22 120 1025 1498 22 120 1037.5 1558 false Result A A Output parameter A 1397bb9e-e682-440d-9a62-48cd412ae682 true true true 0 1025 1618 22 120 1025 1618 22 120 1037.5 1678 false 59e0b89a-e487-49f8-bab8-b5bab16be14c Panel Panel Marker Types A panel for custom notes and String values 381038e3-64bc-4aad-a539-ec5ffb1471de false true true 0 xlMarkerStyleAutomatic xlMarkerStyleCircle xlMarkerStyleDash xlMarkerStyleDiamond xlMarkerStyleDot xlMarkerStyleNone xlMarkerStylePlus xlMarkerStyleSquare xlMarkerStyleStar xlMarkerStyleTriangle xlMarkerStyleX false true false 1 1 false 255;0;0;0 255;255;255;0 450 4050 150 149 450 4050 150 149 450.4413 4050.323 false Microsoft Sans Serif 10 false false 59e0b89a-e487-49f8-bab8-b5bab16be14c Panel Panel A panel for custom notes and String values c352d983-56c2-4930-8bd8-9d63e1007530 false true true 0 xlMarkerStyleDot true false false 1 0 false 255;255;255;255 255;0;0;0 750 4068 150 20 750 4068 150 20 750.9492 4068.944 false Microsoft Sans Serif 10 false false 59e0b89a-e487-49f8-bab8-b5bab16be14c Panel Panel A panel for custom notes and String values aabd2e06-e974-46f9-8d9e-0120c1f9001d false true true 0 12 true false false 1 0 false 255;0;0;0 255;255;255;255 750 4131 50 20 750 4131 50 20 750.8342 4131.699 false Microsoft Sans Serif 10 false false ad483f40-dc72-40dc-844d-c9e462c7d19f Boolean Toggle true Boolean Toggle Toggle Boolean (true/false) toggle 1d79a185-6610-493b-a2aa-81e909e0c026 false true true 0 750 3912 87 20 750 3912 87 20 750.21 3912.765 false 1e9e08fc-c31e-49eb-a36c-90de5e62e5f5 VB Script Dim arrList As New List(Of System.Object) Dim mark As Integer If _Marker = "xlMarkerStyleAutomatic" Then mark = -4105 ElseIf _Marker = "xlMarkerStyleCircle" Then mark = 8 ElseIf _Marker = "xlMarkerStyleDash" Then mark = -4115 ElseIf _Marker = "xlMarkerStyleDiamond" Then mark = 2 ElseIf _Marker = "xlMarkerStyleDot" Then mark = -4118 ElseIf _Marker = "xlMarkerStyleNone" Then mark = -4142 ElseIf _Marker = "xlMarkerStylePlus" Then mark = 9 ElseIf _Marker = "xlMarkerStyleSquare" Then mark = 1 ElseIf _Marker = "xlMarkerStyleStar" Then mark = 5 ElseIf _Marker = "xlMarkerStyleTriangle" Then mark = 3 ElseIf _Marker = "xlMarkerStyleX" Then mark = -4168 Else mark = -4105 End If arrList.add(mark) arrList.add(_Fill) arrList.add(_Color) If _MarkSize = 0 Then arrList.add(10) Else arrList.add(_MarkSize) End If A = arrList 0 VB Script XL Mark A VB.NET scriptable component 6ea2cccd-31a0-4d85-b97f-b54fc67d336b false true true longest_list 935 4065 115 84 999 4067 24 80 1011 4107 false 4 84fa917c-1ed8-4db3-8be1-7bdc4a6495a2 Variable _Marker Script Variable _Marker true true 84fa917c-1ed8-4db3-8be1-7bdc4a6495a2 Variable _MarkColorF Script Variable _MarkColorF true true 84fa917c-1ed8-4db3-8be1-7bdc4a6495a2 Variable _MarkColorB Script Variable _MarkColorB true true 84fa917c-1ed8-4db3-8be1-7bdc4a6495a2 Variable _MarkSize Script Variable _MarkSize true true 2 3ede854e-c753-40eb-84cb-b48008f14fd4 Output Print, Reflect and Error streams true false 8ec86459-bf01-4409-baee-174d0d2b13d0 Result A Output parameter A true false Variable _Marker _Marker Script Variable _Marker d8e320e3-8d1b-4b8a-8dd8-022fbf23df43 true true true 1 c352d983-56c2-4930-8bd8-9d63e1007530 abf1fd1b-dbe5-4be6-9832-d8dc105e207f true true 937 4067 59 20 937 4067 59 20 968 4077 false Variable _MarkColorF _Color Script Variable _MarkColorF ee175592-aa57-4d2d-97b7-4739fdf545ac true true true 1 576dde6a-1891-4e66-8540-4f758e510cdb 24b1d1a3-ab79-498c-9e44-c5b14607c4d3 true true 937 4087 59 20 937 4087 59 20 968 4097 false Variable _MarkColorB _Fill Script Variable _MarkColorB 3c77f7da-30b7-4aaa-8de0-944f86b08726 true true true 1 a28cefc3-a5cb-477d-b7c6-cd1f0aba7671 24b1d1a3-ab79-498c-9e44-c5b14607c4d3 true true 937 4107 59 20 937 4107 59 20 968 4117 false Variable _MarkSize _MarkSize Script Variable _MarkSize 4bd1b511-1c6c-41c4-a2a2-c3948b42c641 true true true 1 aabd2e06-e974-46f9-8d9e-0120c1f9001d 8e991e99-5fb8-41e1-928d-1bba8fb9f7d7 true true 937 4127 59 20 937 4127 59 20 968 4137 false Output out Print, Reflect and Error streams 87097698-6f23-401e-b46f-a543a55099d7 false true true 0 1026 4067 22 40 1026 4067 22 40 1038.5 4087 false Result A A Output parameter A 843ca577-ce7c-46c3-b642-a9bf4ea67b3d true true true 0 1026 4107 22 40 1026 4107 22 40 1038.5 4127 false 9c53bac0-ba66-40bd-8154-ce9829b9db1a Colour Swatch 255;0;0;0 Colour Swatch Swatch Colour (palette) swatch 576dde6a-1891-4e66-8540-4f758e510cdb false true true 0 750 4089 89 20 750 4089 89 20 750.5257 4089.693 false 9c53bac0-ba66-40bd-8154-ce9829b9db1a Colour Swatch 255;69;69;69 Colour Swatch Swatch Colour (palette) swatch 30f27439-23e8-4ec3-9424-28f56f53a6c9 false true true 0 750 3870 89 20 750 3870 89 20 750.7875 3870.126 false 59e0b89a-e487-49f8-bab8-b5bab16be14c Panel Panel Bevel Types A panel for custom notes and String values 03407366-7f6f-444c-8061-8ba87aeb13c4 false true true 0 msoBevelAngle msoBevelArtDeco msoBevelCircle msoBevelConvex msoBevelCoolSlant msoBevelCross msoBevelDivot msoBevelHardEdge msoBevelNone msoBevelRelaxedInset msoBevelRiblet msoBevelSlope msoBevelSoftRound msoBevelTypeMixed false true false 1 0 false 255;0;0;0 255;255;255;0 450 3801 150 149 450 3801 150 149 450.7251 3801.918 false Microsoft Sans Serif 10 false false 59e0b89a-e487-49f8-bab8-b5bab16be14c Panel Panel A panel for custom notes and String values 0ec2f6f1-b2f6-4024-a4a1-49bf7e4d125d false true true 0 msoBevelCircle true false false 1 0 false 255;255;255;255 255;0;0;0 750 3891 150 20 750 3891 150 20 750.1406 3891.643 false Microsoft Sans Serif 10 false false 8ec86459-bf01-4409-baee-174d0d2b13d0 Data Data A List of Any Generic Data Represents a collection of generic data f0633e9a-65fc-4f99-8677-030ebe728e3a false true true 1 5e637c0e-a14a-40f3-a39f-ffe56b522094 1648 1011 152 20 1648 1011 152 20 1724.841 1021.92 false ad483f40-dc72-40dc-844d-c9e462c7d19f Boolean Toggle true Boolean Toggle Toggle Boolean (true/false) toggle 12fed4c7-0495-4c23-926b-7214c796bd13 false true true 0 751 939 87 20 751 939 87 20 751.2273 939.2689 false ad483f40-dc72-40dc-844d-c9e462c7d19f Boolean Toggle false Boolean Toggle Toggle Boolean (true/false) toggle ca06720a-ea9f-4eae-b523-dacc8f91bf1a false true true 0 751 960 87 20 751 960 87 20 751.3531 960.1489 false ad483f40-dc72-40dc-844d-c9e462c7d19f Boolean Toggle false Boolean Toggle Toggle Boolean (true/false) toggle 321a60c3-0e12-436f-8fdd-83678957e0ff false true true 0 751 981 87 20 751 981 87 20 751.3924 981.421 false 2e3ab970-8545-46bb-836c-1c11e5610bce Integer Integer Int Represents a collection of Integer numbers 237d6cd8-92af-4dda-ae2d-d673dba76be9 false true true 1 2eeb43be-a7e2-44fb-abdb-01dcb2bb4c55 846 854 50 20 846 854 50 20 871.0721 864.9409 false 59e0b89a-e487-49f8-bab8-b5bab16be14c Panel Panel A panel for custom notes and String values e175a326-b4f8-4b95-aef3-d5eed0a039b0 false true true 0 xlCenter true true true 1 0 false 255;255;255;255 255;0;0;0 751 896 150 20 751 896 150 20 751.2723 896.9599 false Microsoft Sans Serif 10 false false 9c53bac0-ba66-40bd-8154-ce9829b9db1a Colour Swatch 255;0;0;0 Colour Swatch Swatch Colour (palette) swatch 567d3460-37f5-4337-b4a0-b8de09a728f5 false true true 0 751 876 89 20 751 876 89 20 751.5152 876.499 false 59e0b89a-e487-49f8-bab8-b5bab16be14c Panel Panel A panel for custom notes and String values 22105683-6fca-439c-9952-0b393af40287 false true true 0 xlCenter true true true 1 0 false 255;255;255;255 255;0;0;0 751 917 150 20 751 917 150 20 751.0323 917.8399 false Microsoft Sans Serif 10 false false ad483f40-dc72-40dc-844d-c9e462c7d19f Boolean Toggle false Boolean Toggle Toggle Boolean (true/false) toggle f25e832d-e009-498b-badd-8110df8f5026 false true true 0 750 1003 87 20 750 1003 87 20 750.7563 1003.083 false ad483f40-dc72-40dc-844d-c9e462c7d19f Boolean Toggle false Boolean Toggle Toggle Boolean (true/false) toggle 3e20af92-0419-4bfb-a272-5a0ed3427c9b false true true 0 750 1023 87 20 750 1023 87 20 750.8824 1023.963 false ad483f40-dc72-40dc-844d-c9e462c7d19f Boolean Toggle false Boolean Toggle Toggle Boolean (true/false) toggle 3769a9ce-2b54-45d9-ad8f-ae0ac6bffde5 false true true 0 750 1045 87 20 750 1045 87 20 750.9211 1045.235 false 59e0b89a-e487-49f8-bab8-b5bab16be14c Panel Panel A panel for custom notes and String values 2eeb43be-a7e2-44fb-abdb-01dcb2bb4c55 false true true 0 9 true true true 1 0 false 255;0;0;0 255;255;255;255 750 854 50 21 750 854 50 21 750.684 854.6249 false 1e9e08fc-c31e-49eb-a36c-90de5e62e5f5 VB Script Dim arrList As New List(Of Object) Dim vert, horz As Integer If _Horizontal = "xlLeft" Then horz = -4131 ElseIf _Horizontal = "xlCenter" Then horz = -4108 ElseIf _Horizontal = "xlRight" Then horz = -4152 End If If _Vertical = "xlBottom" Then vert = -4017 ElseIf _Vertical = "xlCenter" Then vert = -4108 ElseIf _Vertical = "xlTop" Then vert = -4160 End If arrList.add(_Size) arrList.add(_Color) arrList.add(horz) arrList.add(vert) arrList.add(_Bold) arrList.add(_Italic) arrList.add(_Underline) arrList.add(_Strikethrough) arrList.add(_Subscript) arrList.add(_Superscript) A = arrList 0 VB Script XL Font A VB.NET scriptable component 75d5518f-8eee-4226-8ca3-6233a4bf6f0c false true true longest_list 915 848 135 204 999 850 24 200 1011 950 false 10 84fa917c-1ed8-4db3-8be1-7bdc4a6495a2 Variable _Size Script Variable _Size true true 84fa917c-1ed8-4db3-8be1-7bdc4a6495a2 Variable _Color Script Variable _Color true true 84fa917c-1ed8-4db3-8be1-7bdc4a6495a2 Variable _Horizontal Script Variable _Horizontal true true 84fa917c-1ed8-4db3-8be1-7bdc4a6495a2 Variable _Vertical Script Variable _Vertical true true 84fa917c-1ed8-4db3-8be1-7bdc4a6495a2 Variable _Bold Script Variable _Bold true true 84fa917c-1ed8-4db3-8be1-7bdc4a6495a2 Variable _Italic Script Variable _Italic true true 84fa917c-1ed8-4db3-8be1-7bdc4a6495a2 Variable _Underline Script Variable _Underline true true 84fa917c-1ed8-4db3-8be1-7bdc4a6495a2 Variable _Strikethough Script Variable _Strikethough true true 84fa917c-1ed8-4db3-8be1-7bdc4a6495a2 Variable _Subscript Script Variable _Subscript true true 84fa917c-1ed8-4db3-8be1-7bdc4a6495a2 Variable _Superscript Script Variable _Superscript true true 2 3ede854e-c753-40eb-84cb-b48008f14fd4 Output Print, Reflect and Error streams true false 8ec86459-bf01-4409-baee-174d0d2b13d0 Result A Output parameter A true false Variable _Size _Size Script Variable _Size 2d0f64d2-58a6-4ca8-b304-62b3589e2599 true true true 1 237d6cd8-92af-4dda-ae2d-d673dba76be9 efe48ae7-2987-421b-a33a-1f7be1c3f050 true true 917 850 79 20 917 850 79 20 958 860 false Variable _Color _Color Script Variable _Color 17885883-1621-4dc6-8ffc-635948ce4dbc true true true 1 567d3460-37f5-4337-b4a0-b8de09a728f5 24b1d1a3-ab79-498c-9e44-c5b14607c4d3 true true 917 870 79 20 917 870 79 20 958 880 false Variable _Horizontal _Horizontal Script Variable _Horizontal 4836064d-d7f6-489a-819b-0dc0cefc339c true true true 1 e175a326-b4f8-4b95-aef3-d5eed0a039b0 abf1fd1b-dbe5-4be6-9832-d8dc105e207f true true 917 890 79 20 917 890 79 20 958 900 false Variable _Vertical _Vertical Script Variable _Vertical ad235669-7df2-40b6-a4e2-759ec526f36b true true true 1 22105683-6fca-439c-9952-0b393af40287 abf1fd1b-dbe5-4be6-9832-d8dc105e207f true true 917 910 79 20 917 910 79 20 958 920 false Variable _Bold _Bold Script Variable _Bold 7da8e377-c145-481b-a712-f93507939a15 true true true 1 12fed4c7-0495-4c23-926b-7214c796bd13 3cda2745-22ac-4244-9b04-97a5255fa60f true true 917 930 79 20 917 930 79 20 958 940 false Variable _Italic _Italic Script Variable _Italic 25f6e7bb-f452-45e5-8e34-0e0e452f8a05 true true true 1 ca06720a-ea9f-4eae-b523-dacc8f91bf1a 3cda2745-22ac-4244-9b04-97a5255fa60f true true 917 950 79 20 917 950 79 20 958 960 false Variable _Underline _Underline Script Variable _Underline 0a741002-cd30-47b1-b768-f0147f667016 true true true 1 321a60c3-0e12-436f-8fdd-83678957e0ff 3cda2745-22ac-4244-9b04-97a5255fa60f true true 917 970 79 20 917 970 79 20 958 980 false Variable _Strikethough _Strikethrough Script Variable _Strikethough 8ae0465e-507b-4db9-b888-d1acf7656547 true true true 1 f25e832d-e009-498b-badd-8110df8f5026 3cda2745-22ac-4244-9b04-97a5255fa60f true true 917 990 79 20 917 990 79 20 958 1000 false Variable _Subscript _Subscript Script Variable _Subscript 00dd945d-1578-4511-8245-0eba98744b57 true true true 1 3e20af92-0419-4bfb-a272-5a0ed3427c9b 3cda2745-22ac-4244-9b04-97a5255fa60f true true 917 1010 79 20 917 1010 79 20 958 1020 false Variable _Superscript _Superscript Script Variable _Superscript 8935c87f-ca4a-4812-aac2-41170bd91000 true true true 1 3769a9ce-2b54-45d9-ad8f-ae0ac6bffde5 3cda2745-22ac-4244-9b04-97a5255fa60f true true 917 1030 79 20 917 1030 79 20 958 1040 false Output out Print, Reflect and Error streams 56329fef-6aae-477d-a288-0f91a8bf8d3d false true true 0 1026 850 22 100 1026 850 22 100 1038.5 900 false Result A A Output parameter A a21a6039-fe46-420c-bb0a-446e1ccb1bd3 true true true 0 1026 950 22 100 1026 950 22 100 1038.5 1000 false 1e9e08fc-c31e-49eb-a36c-90de5e62e5f5 VB Script If _Stream = True Then Dim oldCI As System.Globalization.CultureInfo = system.Threading.Thread.CurrentThread.CurrentCulture System.Threading.Thread.CurrentThread.CurrentCulture = New System.Globalization.CultureInfo("en-US") Dim objExcel As Object objExcel = System.Runtime.InteropServices.Marshal.GetActiveObject("Excel.Application") Dim newSheet, excelSheet As Object excelSheet = objExcel.ActiveSheet excelSheet.Visible = False newSheet = objExcel.Sheets.Add() Dim i As Integer Dim x,y As Integer Dim ptA, ptB As Point3d If ByColumn = True Then x = Origin.X y = Origin.Y + data.Count() - 1 Else x = Origin.X + data.Count() - 1 y = Origin.Y End If ptA.X = Origin.X ptA.Y = Origin.Y ptA.Z = 0 A = ptA ptB.X = x ptB.Y = y ptB.Z = 0 B = ptB For i = 0 To data.Count() - 1 Step 1 If ByColumn = True Then x = Origin.X y = Origin.Y + i Else x = Origin.X + i y = Origin.Y End If ' clear and current information and write values to cells excelSheet.Cells(CInt(y), CInt(x)).Clear excelSheet.Cells(CInt(y), CInt(x)).Value = data(i) Next newSheet.activate newSheet.Delete() excelSheet.visible = True excelSheet.activate A = ptA B = ptB End If 0 VB Script List to XL A VB.NET scriptable component f806a833-ec81-4a72-917f-f47a1ad92404 false true true longest_list 1986 751 114 84 2049 753 24 80 2061 793 false 4 84fa917c-1ed8-4db3-8be1-7bdc4a6495a2 Variable Origin Script Variable Origin true true 84fa917c-1ed8-4db3-8be1-7bdc4a6495a2 Variable ByColumn Script Variable ByColumn true true 84fa917c-1ed8-4db3-8be1-7bdc4a6495a2 Variable Data Script Variable Data 1 true true 84fa917c-1ed8-4db3-8be1-7bdc4a6495a2 Variable _Stream Script Variable _Stream true true 3 3ede854e-c753-40eb-84cb-b48008f14fd4 Output Print, Reflect and Error streams true false 8ec86459-bf01-4409-baee-174d0d2b13d0 Result A Output parameter A true false 8ec86459-bf01-4409-baee-174d0d2b13d0 Result B Output parameter B true false Variable Origin Origin Script Variable Origin 21db9590-77d5-4702-a082-bc75c7715973 true true true 1 c0489292-9b05-4978-b00a-dda2d4ec7081 e1937b56-b1da-4c12-8bd8-e34ee81746ef true true 1988 753 58 20 1988 753 58 20 2018.5 763 false Variable ByColumn ByColumn Script Variable ByColumn 709a543e-4d82-4f2f-a1b4-5c2cddb65c9b true true true 1 6871996a-6a76-498d-961c-0e7268a2727d 3cda2745-22ac-4244-9b04-97a5255fa60f true true 1988 773 58 20 1988 773 58 20 2018.5 783 false Variable Data Data Script Variable Data 5b7fb06f-6189-44fa-bb65-5c544944362f true true true 1 1 70c60886-19f8-43fb-ac3e-85faed6710e8 true true 1988 793 58 20 1988 793 58 20 2018.5 803 false Variable _Stream _Stream Script Variable _Stream e9a4634a-a2c7-4aa6-a000-bb7ce56f53e1 true true true 1 763d6aed-9b0f-4562-8585-03acc9075de9 3cda2745-22ac-4244-9b04-97a5255fa60f true true 1988 813 58 20 1988 813 58 20 2018.5 823 false Output out Print, Reflect and Error streams 2ce77b41-d79f-4129-b812-520b2020620c false true true 0 2076 753 22 26 2076 753 22 26 2088.5 766.3333 false Result A A Output parameter A 8049a409-cc2d-45a8-b13f-e1ccd013dc47 true true true 0 2076 779 22 27 2076 779 22 27 2088.5 793 false Result B B Output parameter B 12b973c8-008b-4d7e-bf3b-7e9bb1e0f304 true true true 0 2076 806 22 26 2076 806 22 26 2088.5 819.6666 false 1e9e08fc-c31e-49eb-a36c-90de5e62e5f5 VB Script If _Stream = True Then Dim oldCI As System.Globalization.CultureInfo = system.Threading.Thread.CurrentThread.CurrentCulture System.Threading.Thread.CurrentThread.CurrentCulture = New System.Globalization.CultureInfo("en-US") Dim objExcel As Object objExcel = System.Runtime.InteropServices.Marshal.GetActiveObject("Excel.Application") Dim excelSheet As Object excelSheet = objExcel.ActiveSheet Dim arrStr As New list(Of String) Dim i,j,k As Integer i = 0 j = 0 k = 0 Do If ByColumn = True Then j = i Else k = i End If If Count > 0 Then If i < count Then arrStr.add(excelSheet.Cells(CInt(Origin.Y + j), CInt(Origin.X + k)).Value) Else Exit Do End If Else If Not isNothing(excelSheet.Cells(CInt(Origin.Y + j), CInt(Origin.X + k)).Value) Then arrStr.add(excelSheet.Cells(CInt(Origin.Y + j), CInt(Origin.X + k)).Value) Else Exit Do End If End If i = i + 1 Loop A = arrStr End If 0 VB Script List From XL A VB.NET scriptable component 92ca8ed8-73a2-4f95-accd-1442fe6cab93 false true true longest_list 936 2401 114 98 999 2403 24 94 1011 2450 false 4 84fa917c-1ed8-4db3-8be1-7bdc4a6495a2 Variable Origin Script Variable Origin true true 84fa917c-1ed8-4db3-8be1-7bdc4a6495a2 Variable ByColumn Script Variable ByColumn true true 84fa917c-1ed8-4db3-8be1-7bdc4a6495a2 Variable Count Script Variable Count true true 84fa917c-1ed8-4db3-8be1-7bdc4a6495a2 Variable _Stream Script Variable _Stream true true 2 3ede854e-c753-40eb-84cb-b48008f14fd4 Output Print, Reflect and Error streams true false 8ec86459-bf01-4409-baee-174d0d2b13d0 Result A Output parameter A true false Variable Origin Origin Script Variable Origin 395d8eaf-2a53-4668-b6a8-9ff15073d237 true true true 1 44558560-8bfd-4f84-954a-b6bf14bdbd1b e1937b56-b1da-4c12-8bd8-e34ee81746ef true true 938 2403 58 23 938 2403 58 23 968.5 2414.75 false Variable ByColumn ByColumn Script Variable ByColumn 39ba247d-7126-4f23-8915-c3c2c3437652 true true true 1 f19411bb-2a77-4c07-a93f-dde83e626bc1 3cda2745-22ac-4244-9b04-97a5255fa60f true true 938 2426 58 24 938 2426 58 24 968.5 2438.25 false Variable Count Count Script Variable Count 7c3c852f-0a4b-4c15-bd6e-7d657f56e266 true true true 1 832ea810-1683-4f0e-9774-69126f7ef8d4 efe48ae7-2987-421b-a33a-1f7be1c3f050 true true 938 2450 58 23 938 2450 58 23 968.5 2461.75 false Variable _Stream _Stream Script Variable _Stream 7221443e-cdca-4306-8248-0806cc70e808 true true true 1 2001263a-d068-4ccd-9279-86dfe2320f3b 3cda2745-22ac-4244-9b04-97a5255fa60f true true 938 2473 58 24 938 2473 58 24 968.5 2485.25 false Output out Print, Reflect and Error streams 1cfe1f2c-7922-4a06-a8a2-1315ce6ea2f3 false true true 0 1026 2403 22 47 1026 2403 22 47 1038.5 2426.5 false Result A A Output parameter A 09eab3fa-2306-4dd4-9886-7938b288ac9d true true true 0 1026 2450 22 47 1026 2450 22 47 1038.5 2473.5 false 59e0b89a-e487-49f8-bab8-b5bab16be14c Panel Panel A panel for custom notes and String values e96a613e-0c4b-4d69-a978-90f338e58f79 false true true 0 1 true true true 1 0 false 255;0;0;0 255;255;255;255 601 2404 50 20 601 2404 50 20 601.0443 2404.177 false 59e0b89a-e487-49f8-bab8-b5bab16be14c Panel Panel A panel for custom notes and String values cc32064e-47f7-4878-bb76-4cd421ae2edf false true true 0 1 true true true 1 0 false 255;0;0;0 255;255;255;255 601 2425 50 21 601 2425 50 21 601.0826 2425.342 false 3581f42a-9592-4549-bd6b-1c0fc39d067b Point XYZ Point XYZ Pt Create a point from {xyz} coordinates. ba2ea894-dab6-4a5c-aee3-0d0f7756a10f false true true longest_list 685 2401 65 64 704 2403 24 60 716 2433 false X component X {x} component 8cfeadbc-3d02-4fa6-86a8-b025974c58e7 false true true 1 e96a613e-0c4b-4d69-a978-90f338e58f79 1 687 2403 14 20 687 2403 14 20 695.5 2413 false 0 Y component Y {y} component dc8c5894-2403-4b3c-bb7a-9f1854cb8f55 false true true 1 cc32064e-47f7-4878-bb76-4cd421ae2edf 1 687 2423 14 20 687 2423 14 20 695.5 2433 false 0 Z component Z {z} component df1d73b3-2796-4070-a110-e81497c49b8c false true true 0 1 687 2443 14 20 687 2443 14 20 695.5 2453 false 0 Point Pt Point coordinate 44558560-8bfd-4f84-954a-b6bf14bdbd1b true true true 0 731 2403 17 60 731 2403 17 60 741 2433 false ad483f40-dc72-40dc-844d-c9e462c7d19f Boolean Toggle true Boolean Toggle Read Column? Boolean (true/false) toggle f19411bb-2a77-4c07-a93f-dde83e626bc1 false true true 0 625 2469 126 20 625 2469 126 20 625.4802 2469.323 false 1e9e08fc-c31e-49eb-a36c-90de5e62e5f5 VB Script If _Stream = True Then Dim oldCI As System.Globalization.CultureInfo = system.Threading.Thread.CurrentThread.CurrentCulture System.Threading.Thread.CurrentThread.CurrentCulture = New System.Globalization.CultureInfo("en-US") Dim objExcel As Object objExcel = System.Runtime.InteropServices.Marshal.GetActiveObject("Excel.Application") Dim excelSheet As Object excelSheet = objExcel.ActiveSheet Dim arrStr As New datatree(Of String) Dim i,j As Integer j = 0 Do i = 0 Dim ghPath As New GH_Path(j) If Bound.X > 0 Then If j >= (Bound.X - Origin.X + 1) Then Exit Do End If Else If Not isNothing(excelSheet.Cells(CInt(Origin.Y + i), CInt(Origin.X + j)).Value) Then Else Exit Do End If End If Do If Bound.X > 0 Then If i < (Bound.Y - Origin.Y + 1) Then arrStr.add(excelSheet.Cells(CInt(Origin.Y + i), CInt(Origin.X + j)).Value, ghPath) Else Exit Do End If Else If Not isNothing(excelSheet.Cells(CInt(Origin.Y + i), CInt(Origin.X + j)).Value) Then arrStr.add(excelSheet.Cells(CInt(Origin.Y + i), CInt(Origin.X + j)).Value, ghPath) Else Exit Do End If End If i = i + 1 Loop j = j + 1 Loop A = arrStr End If 0 VB Script Table From XL A VB.NET scriptable component 4d3e22e9-2814-4084-826c-7998ca36c66d false true true longest_list 945 2699 105 109 999 2701 24 105 1011 2754 false 3 84fa917c-1ed8-4db3-8be1-7bdc4a6495a2 Variable Origin Script Variable Origin true true 84fa917c-1ed8-4db3-8be1-7bdc4a6495a2 Variable Count Script Variable Count true true 84fa917c-1ed8-4db3-8be1-7bdc4a6495a2 Variable _Stream Script Variable _Stream true true 2 3ede854e-c753-40eb-84cb-b48008f14fd4 Output Print, Reflect and Error streams true false 8ec86459-bf01-4409-baee-174d0d2b13d0 Result A Output parameter A true false Variable Origin Origin Script Variable Origin 9492dfe4-fc3d-41ad-9b90-3c3d7d7998b3 true true true 0 e1937b56-b1da-4c12-8bd8-e34ee81746ef true true 947 2701 49 35 947 2701 49 35 973 2718.5 false Variable Count Bound Script Variable Count 5d591e10-06da-48ad-843c-f5f46ed8e373 true true true 0 e1937b56-b1da-4c12-8bd8-e34ee81746ef true true 947 2736 49 35 947 2736 49 35 973 2753.5 false Variable _Stream _Stream Script Variable _Stream d0d66531-1c30-4937-9b8b-08725417aa2d true true true 1 fa3c79cc-96bf-4b57-b9b5-9fdb13999bc8 3cda2745-22ac-4244-9b04-97a5255fa60f true true 947 2771 49 35 947 2771 49 35 973 2788.5 false Output out Print, Reflect and Error streams 6f2e857f-d497-431a-bfa3-7c64574b8e7f false true true 0 1026 2701 22 52 1026 2701 22 52 1038.5 2727.25 false Result A A Output parameter A bcbe1d19-3378-4671-915f-c1bbb1379eeb true true true 0 1026 2753 22 53 1026 2753 22 53 1038.5 2779.75 false 59e0b89a-e487-49f8-bab8-b5bab16be14c Panel Panel A panel for custom notes and String values 5b42a164-008c-4742-b4e5-92a602f616d7 false true true 0 1 true true true 1 0 false 255;0;0;0 255;255;255;255 600 2704 50 20 600 2704 50 20 600.5229 2704.008 false 59e0b89a-e487-49f8-bab8-b5bab16be14c Panel Panel A panel for custom notes and String values 689cf6fc-7ead-4e11-86fe-a77433a43053 false true true 0 1 true true true 1 0 false 255;0;0;0 255;255;255;255 600 2725 50 21 600 2725 50 21 600.5611 2725.173 false 3581f42a-9592-4549-bd6b-1c0fc39d067b Point XYZ Point XYZ Pt Create a point from {xyz} coordinates. e8150735-1c4d-4306-b6ce-124002e0891d false true true longest_list 685 2700 65 64 704 2702 24 60 716 2732 false X component X {x} component 1f0e4a16-c0ff-4159-b3c8-cbad11f4e80f false true true 1 5b42a164-008c-4742-b4e5-92a602f616d7 1 687 2702 14 20 687 2702 14 20 695.5 2712 false 0 Y component Y {y} component 946785ca-7e5b-4199-86c6-1d15039593a5 false true true 1 689cf6fc-7ead-4e11-86fe-a77433a43053 1 687 2722 14 20 687 2722 14 20 695.5 2732 false 0 Z component Z {z} component e5e5e2af-e625-4cd0-9dec-396a78be6606 false true true 0 1 687 2742 14 20 687 2742 14 20 695.5 2752 false 0 Point Pt Point coordinate 9ab0862c-30f8-4a6f-be10-ba8f9e7c4679 true true true 0 731 2702 17 60 731 2702 17 60 741 2732 false ad483f40-dc72-40dc-844d-c9e462c7d19f Boolean Toggle false Boolean Toggle Live Stream Table From Excel Boolean (true/false) toggle fa3c79cc-96bf-4b57-b9b5-9fdb13999bc8 false true true 0 549 2834 201 20 549 2834 201 20 549.9554 2834.584 false 59e0b89a-e487-49f8-bab8-b5bab16be14c Panel Panel A panel for custom notes and String values 62057f62-c934-4b94-b636-9589fb7afc71 false true true 0 3 true true true 1 0 false 255;0;0;0 255;255;255;255 600 2769 50 20 600 2769 50 20 600.9753 2769.304 false 59e0b89a-e487-49f8-bab8-b5bab16be14c Panel Panel A panel for custom notes and String values b37f9fb8-401f-492d-abee-662c192be3b1 false true true 0 5 true true true 1 0 false 255;0;0;0 255;255;255;255 601 2790 50 21 601 2790 50 21 601.0135 2790.469 false 3581f42a-9592-4549-bd6b-1c0fc39d067b Point XYZ Point XYZ Pt Create a point from {xyz} coordinates. 74ce9b1b-0435-4a05-8ef3-571bd29d39a4 false true true longest_list 685 2765 65 64 704 2767 24 60 716 2797 false X component X {x} component 57c34f2b-8bf0-4dfa-8561-245db8ebaaf0 false true true 1 62057f62-c934-4b94-b636-9589fb7afc71 1 687 2767 14 20 687 2767 14 20 695.5 2777 false 0 Y component Y {y} component 2d3fc216-ba40-4c86-908c-09dd88a94005 false true true 1 b37f9fb8-401f-492d-abee-662c192be3b1 1 687 2787 14 20 687 2787 14 20 695.5 2797 false 0 Z component Z {z} component 94e19a22-83e7-40d4-836f-1f27e224961c false true true 0 1 687 2807 14 20 687 2807 14 20 695.5 2817 false 0 Point Pt Point coordinate e19b30d8-41aa-4328-883c-ea0348671340 true true true 0 731 2767 17 60 731 2767 17 60 741 2797 false 1e9e08fc-c31e-49eb-a36c-90de5e62e5f5 VB Script If _Stream = True Then Dim oldCI As System.Globalization.CultureInfo = system.Threading.Thread.CurrentThread.CurrentCulture System.Threading.Thread.CurrentThread.CurrentCulture = New System.Globalization.CultureInfo("en-US") Dim objExcel As Object objExcel = System.Runtime.InteropServices.Marshal.GetActiveObject("Excel.Application") Dim newSheet, excelSheet As Object excelSheet = objExcel.ActiveSheet newSheet = objExcel.Sheets.Add() excelSheet.Visible = False Dim i,k,r,s,u,v As Integer Dim x,y As Integer Dim cnt As New list(Of Integer) For i = 0 To Data.BranchCount() - 1 Step 1 cnt.add(Data.Branch(i).Count()) Next Dim counts As Integer() counts = cnt.toarray Array.Sort(counts) Array.reverse(counts) Dim ptA, ptB As Point3d If Item_Title.Count() > 0 Then s = 1 Else s = 0 End If If Branch_Title.Count() > 0 Then r = 1 Else r = 0 End If If ByColumn = True Then x = Origin.X + Data.BranchCount() - 1 + r y = Origin.Y + counts(0) - 1 + s Else x = Origin.X + counts(0) - 1 + s y = Origin.Y + data.BranchCount() - 1 + r End If ptA.X = Origin.X ptA.Y = Origin.Y ptA.Z = 0 A = ptA ptB.X = x ptB.Y = y ptB.Z = 0 B = ptB If Branch_Title.Count() > 0 Then If ByColumn = False Then For i = 0 To Branch_Title.Count() - 1 Step 1 excelSheet.Cells(CInt(Origin.Y + i + s), CInt(Origin.X)).Clear excelSheet.Cells(CInt(Origin.Y + i + s), CInt(Origin.X)).Value = Branch_Title(i) Next Else For i = 0 To Branch_Title.Count() - 1 Step 1 excelSheet.Cells(CInt(Origin.Y), CInt(Origin.X + i + s)).Clear excelSheet.Cells(CInt(Origin.Y), CInt(Origin.X + i + s)).Value = Branch_Title(i) Next End If End If If Item_Title.Count() > 0 Then If ByColumn = False Then For i = 0 To Item_Title.Count() - 1 Step 1 excelSheet.Cells(CInt(Origin.Y), CInt(Origin.X + i + r)).Clear excelSheet.Cells(CInt(Origin.Y), CInt(Origin.X + i + r)).Value = Item_Title(i) Next Else For i = 0 To Item_Title.Count() - 1 Step 1 excelSheet.Cells(CInt(Origin.Y + i + r), CInt(Origin.X)).Clear excelSheet.Cells(CInt(Origin.Y + i + r), CInt(Origin.X)).Value = Item_Title(i) Next End If End If For k = 0 To Data.BranchCount() - 1 Step 1 For i = 0 To data.branch(k).Count() - 1 Step 1 If ByColumn = True Then x = Origin.X + k + r y = Origin.Y + i + s Else x = Origin.X + i + s y = Origin.Y + k + r End If ' clear and current information and write values to cells excelSheet.Cells(CInt(y), CInt(x)).Clear excelSheet.Cells(CInt(y), CInt(x)).Value = data.branch(k).item(i) ' if text formatting is active, run the options If Font_Format.BranchCount() > 0 Then If Font_Format.BranchCount() = 1 Then U = 0 Else U = V End If With excelSheet.Cells(CInt(y), CInt(x)) .Font.Size = CInt(Font_Format.Branch(U).Item(0)) .Font.Color = RGB(CInt(Font_Format.Branch(U).Item(1).r), CInt(Font_Format.Branch(U).Item(1).g), CInt(Font_Format.Branch(U).Item(1).b)) .HorizontalAlignment = CInt(Font_Format.Branch(U).Item(2)) .VerticalAlignment = CInt(Font_Format.Branch(U).Item(3)) .Font.Bold = CBool(Font_Format.Branch(U).Item(4)) .Font.Italic = CBool(Font_Format.Branch(U).Item(5)) .Font.Underline = CBool(Font_Format.Branch(U).Item(6)) .Font.Strikethrough = CBool(Font_Format.Branch(U).Item(7)) .Font.Subscript = CBool(Font_Format.Branch(U).Item(8)) .Font.Superscript = CBool(Font_Format.Branch(U).Item(9)) End With End If ' if cell formatting is active, run the options If Cell_Format.BranchCount() > 0 Then If Cell_Format.BranchCount() = 1 Then U = 0 Else U = V End If With excelSheet.Cells(CInt(y), CInt(x)) .Interior.Pattern = CInt(Cell_Format.Branch(U).Item(0)) .Interior.Patterncolor = RGB(CInt(Cell_Format.Branch(U).Item(1).r), CInt(Cell_Format.Branch(U).Item(1).g), CInt(Cell_Format.Branch(U).Item(1).b)) .Interior.color = RGB(CInt(Cell_Format.Branch(U).Item(2).r), CInt(Cell_Format.Branch(U).Item(2).g), CInt(Cell_Format.Branch(U).Item(2).b)) End With End If ' if cell border formatting is active, run the options If Border_Format.BranchCount() > 0 Then If Border_Format.BranchCount() = 1 Then U = 0 Else U = V End If With excelSheet.Cells(CInt(y), CInt(x)) .Borders.item(10).lineStyle = CInt(Border_Format.Branch(U).Item(0)) .Borders.item(10).Weight = CInt(Border_Format.Branch(U).Item(1)) .Borders.item(10).Color = RGB(CInt(Border_Format.Branch(U).Item(2).r), CInt(Border_Format.Branch(U).Item(2).g), CInt(Border_Format.Branch(U).Item(2).b)) .Borders.item(7).lineStyle = CInt(Border_Format.Branch(U).Item(3)) .Borders.item(7).Weight = CInt(Border_Format.Branch(U).Item(4)) .Borders.item(7).Color = RGB(CInt(Border_Format.Branch(U).Item(5).r), CInt(Border_Format.Branch(U).Item(5).g), CInt(Border_Format.Branch(U).Item(5).b)) .Borders.item(8).lineStyle = CInt(Border_Format.Branch(U).Item(6)) .Borders.item(8).Weight = CInt(Border_Format.Branch(U).Item(7)) .Borders.item(8).Color = RGB(CInt(Border_Format.Branch(U).Item(8).r), CInt(Border_Format.Branch(U).Item(8).g), CInt(Border_Format.Branch(U).Item(8).b)) .Borders.item(9).lineStyle = CInt(Border_Format.Branch(U).Item(9)) .Borders.item(9).Weight = CInt(Border_Format.Branch(U).Item(10)) .Borders.item(9).Color = RGB(CInt(Border_Format.Branch(U).Item(11).r), CInt(Border_Format.Branch(U).Item(11).g), CInt(Border_Format.Branch(U).Item(11).b)) End With End If V = V + 1 Next Next newSheet.activate newSheet.Delete() excelSheet.visible = True excelSheet.activate End If 0 VB Script Table to XL adv A VB.NET scriptable component 8c99fd50-dfab-4101-83ce-558b9136aa52 false true true longest_list 1963 1502 137 184 2049 1504 24 180 2061 1594 false 9 84fa917c-1ed8-4db3-8be1-7bdc4a6495a2 Variable Origin Script Variable Origin true true 84fa917c-1ed8-4db3-8be1-7bdc4a6495a2 Variable ByColumn Script Variable ByColumn true true 84fa917c-1ed8-4db3-8be1-7bdc4a6495a2 Variable Data Script Variable Data 2 true true 84fa917c-1ed8-4db3-8be1-7bdc4a6495a2 Variable Branch_Title Script Variable Branch_Title 1 true true 84fa917c-1ed8-4db3-8be1-7bdc4a6495a2 Variable Item_Title Script Variable Item_Title 1 true true 84fa917c-1ed8-4db3-8be1-7bdc4a6495a2 Variable Font_Format Script Variable Font_Format 2 true true 84fa917c-1ed8-4db3-8be1-7bdc4a6495a2 Variable Cell_Format Script Variable Cell_Format 2 true true 84fa917c-1ed8-4db3-8be1-7bdc4a6495a2 Variable Border_Format Script Variable Border_Format 2 true true 84fa917c-1ed8-4db3-8be1-7bdc4a6495a2 Variable _Stream Script Variable _Stream true true 3 3ede854e-c753-40eb-84cb-b48008f14fd4 Output Print, Reflect and Error streams true false 8ec86459-bf01-4409-baee-174d0d2b13d0 Result A Output parameter A true false 8ec86459-bf01-4409-baee-174d0d2b13d0 Result B Output parameter B true false Variable Origin Origin Script Variable Origin 587cc388-29a6-4095-a6a8-afbf706a218a true true true 1 55570b4b-1392-40f8-81f3-456d5248d331 e1937b56-b1da-4c12-8bd8-e34ee81746ef true true 1965 1504 81 20 1965 1504 81 20 2007 1514 false Variable ByColumn ByColumn Script Variable ByColumn 295d1a7a-8ed9-481c-bc3d-c3511d32924b true true true 1 9d47f760-8ad4-4eef-afd8-e011956fcd20 3cda2745-22ac-4244-9b04-97a5255fa60f true true 1965 1524 81 20 1965 1524 81 20 2007 1534 false Variable Data Data Script Variable Data 2d68a24b-06d7-4c71-b60e-c74335814bbe true true true 2 1 93eec32d-e6c6-47ad-b222-c5d70eedd7e2 6a184b65-baa3-42d1-a548-3915b401de53 true true 1965 1544 81 20 1965 1544 81 20 2007 1554 false Variable Branch_Title Branch_Title Script Variable Branch_Title 8d30adc6-69ca-46d7-a0f9-1f82ea372e46 true true true 1 1 747c309e-853d-408f-8c19-e7275d00f249 abf1fd1b-dbe5-4be6-9832-d8dc105e207f true true 1965 1564 81 20 1965 1564 81 20 2007 1574 false Variable Item_Title Item_Title Script Variable Item_Title 341b5375-6bca-444b-989d-3b42eef48081 true true true 1 1 1603221e-4b10-44c6-b3bd-da7e8c97b819 abf1fd1b-dbe5-4be6-9832-d8dc105e207f true true 1965 1584 81 20 1965 1584 81 20 2007 1594 false Variable Font_Format Font_Format Script Variable Font_Format bf52eb68-d1a3-457e-8c1a-8a2a318d3212 true true true 2 1 5c152da5-a634-4c96-aede-ff3ac839bf2c 6a184b65-baa3-42d1-a548-3915b401de53 true true 1965 1604 81 20 1965 1604 81 20 2007 1614 false Variable Cell_Format Cell_Format Script Variable Cell_Format 9376c3bc-b7fd-4a6a-8e47-632f67574f0c true true true 2 1 75c59d66-3a90-45a2-96e2-e350c2ebdf34 6a184b65-baa3-42d1-a548-3915b401de53 true true 1965 1624 81 20 1965 1624 81 20 2007 1634 false Variable Border_Format Border_Format Script Variable Border_Format 8b45b2de-3ed8-4c28-80cc-e019312c6899 true true true 2 1 99018b16-14fb-49d4-a7c1-c446722479aa 6a184b65-baa3-42d1-a548-3915b401de53 true true 1965 1644 81 20 1965 1644 81 20 2007 1654 false Variable _Stream _Stream Script Variable _Stream 8ae0b9ed-958c-4389-97ea-9c5c80f476bb true true true 1 59f0d1a6-fffb-48aa-b7cb-2ae318449aa1 3cda2745-22ac-4244-9b04-97a5255fa60f true true 1965 1664 81 20 1965 1664 81 20 2007 1674 false Output out Print, Reflect and Error streams 02fe7ba1-a5ce-4533-ac6b-370ed4fbff41 false true true 0 2076 1504 22 60 2076 1504 22 60 2088.5 1534 false Result A A Output parameter A bf8f97b6-ba16-4a3c-a3f9-8685acee663a true true true 0 2076 1564 22 60 2076 1564 22 60 2088.5 1594 false Result B B Output parameter B 9137f97b-3b9f-4d89-a2c2-3fd2d1d3fc15 true true true 0 2076 1624 22 60 2076 1624 22 60 2088.5 1654 false 1e9e08fc-c31e-49eb-a36c-90de5e62e5f5 VB Script If _Stream = True Then Dim oldCI As System.Globalization.CultureInfo = system.Threading.Thread.CurrentThread.CurrentCulture System.Threading.Thread.CurrentThread.CurrentCulture = New System.Globalization.CultureInfo("en-US") Dim objExcel As Object objExcel = System.Runtime.InteropServices.Marshal.GetActiveObject("Excel.Application") Dim newSheet,excelSheet As Object excelSheet = objExcel.ActiveSheet newSheet = objExcel.Sheets.Add() Dim i,k As Integer Dim x,y As Integer Dim cnt As New list(Of Integer) Dim ptA, ptB As Point3d For i = 0 To Data.BranchCount() - 1 Step 1 cnt.add(Data.Branch(i).Count()) Next Dim counts As Integer() counts = cnt.toarray Array.Sort(counts) Array.reverse(counts) If ByColumn = True Then x = Origin.X + Data.BranchCount() - 1 y = Origin.Y + counts(0) - 1 Else x = Origin.X + counts(0) - 1 y = Origin.Y + data.BranchCount() - 1 End If ptA.X = Origin.X ptA.Y = Origin.Y ptA.Z = 0 A = ptA ptB.X = x ptB.Y = y ptB.Z = 0 B = ptB For k = 0 To Data.BranchCount() - 1 Step 1 For i = 0 To data.branch(k).Count() - 1 Step 1 If ByColumn = True Then x = Origin.X + k y = Origin.Y + i Else x = Origin.X + i y = Origin.Y + k End If ' clear and current information and write values to cells excelSheet.Cells(CInt(y), CInt(x)).Clear excelSheet.Cells(CInt(y), CInt(x)).Value = data.branch(k).item(i) Next Next newSheet.activate newSheet.Delete() excelSheet.visible = True excelSheet.activate A = ptA B = ptB End If 0 VB Script Table to XL A VB.NET scriptable component fe6e4071-9b77-4aa8-87d5-5aec31eb7cd5 false true true longest_list 1986 1352 114 88 2049 1354 24 84 2061 1396 false 4 84fa917c-1ed8-4db3-8be1-7bdc4a6495a2 Variable Origin Script Variable Origin true true 84fa917c-1ed8-4db3-8be1-7bdc4a6495a2 Variable ByColumn Script Variable ByColumn true true 84fa917c-1ed8-4db3-8be1-7bdc4a6495a2 Variable Data Script Variable Data 2 true true 84fa917c-1ed8-4db3-8be1-7bdc4a6495a2 Variable _Stream Script Variable _Stream true true 3 3ede854e-c753-40eb-84cb-b48008f14fd4 Output Print, Reflect and Error streams true false 8ec86459-bf01-4409-baee-174d0d2b13d0 Result A Output parameter A true false 8ec86459-bf01-4409-baee-174d0d2b13d0 Result B Output parameter B true false Variable Origin Origin Script Variable Origin e5192c4e-c1c7-4f33-ab95-8241718236c3 true true true 1 9ce83c13-67d3-45e9-bd30-e2c56cebaa8e e1937b56-b1da-4c12-8bd8-e34ee81746ef true true 1988 1354 58 21 1988 1354 58 21 2018.5 1364.5 false Variable ByColumn ByColumn Script Variable ByColumn ec59137c-39f2-4519-a835-498dba9f3217 true true true 1 1ab2e2be-ba10-413a-90eb-4c19db67b961 3cda2745-22ac-4244-9b04-97a5255fa60f true true 1988 1375 58 21 1988 1375 58 21 2018.5 1385.5 false Variable Data Data Script Variable Data eb27e330-5025-4ab7-92c9-72d77eea2e37 true true true 2 1 140dbd5a-60e6-4ee6-ae02-2e9c8b567ab7 6a184b65-baa3-42d1-a548-3915b401de53 true true 1988 1396 58 21 1988 1396 58 21 2018.5 1406.5 false Variable _Stream _Stream Script Variable _Stream bb435320-02bb-44da-9281-81dba0264572 true true true 1 856912e3-d37e-47fb-82ad-08bca7c438bf 3cda2745-22ac-4244-9b04-97a5255fa60f true true 1988 1417 58 21 1988 1417 58 21 2018.5 1427.5 false Output out Print, Reflect and Error streams dc72ffd7-4e83-4952-9795-8617284fb660 false true true 0 2076 1354 22 28 2076 1354 22 28 2088.5 1368 false Result A A Output parameter A de0295c2-079e-4848-a2db-4bf9c0062ca6 true true true 0 2076 1382 22 28 2076 1382 22 28 2088.5 1396 false Result B B Output parameter B c890b1ea-5bb2-4192-9823-9da52fdee6c0 true true true 0 2076 1410 22 28 2076 1410 22 28 2088.5 1424 false 8ec86459-bf01-4409-baee-174d0d2b13d0 Data Data Takes Inputs from "XL Font" Component Represents a collection of generic data 06f8d0de-94e1-42da-ab7a-4ac4b3476b4c false true true 2 1 a21a6039-fe46-420c-bb0a-446e1ccb1bd3 1574 1065 226 20 1574 1065 226 20 1687.493 1075.947 false 8ec86459-bf01-4409-baee-174d0d2b13d0 Data Data Takes Inputs from "XL Cell" Component Represents a collection of generic data cc59c0c1-7f8d-4293-810a-4b6238d4b9c5 false true true 2 1 04e0fed7-56b4-43bf-ac37-7171e15870ec 1578 1087 222 20 1578 1087 222 20 1689.943 1097.416 false 8ec86459-bf01-4409-baee-174d0d2b13d0 Data Data Takes Inputs from "XL Border" Component Represents a collection of generic data d6f562f9-8476-4d1f-a6a8-1c0ffa2c9b96 false true true 2 1 83494904-50a3-4c0e-8831-773d8dea3c2f 1562 1108 238 20 1562 1108 238 20 1681.969 1118.384 false ad483f40-dc72-40dc-844d-c9e462c7d19f Boolean Toggle true Boolean Toggle Stream by Column? Boolean (true/false) toggle 6871996a-6a76-498d-961c-0e7268a2727d false true true 0 1650 818 150 20 1650 818 150 20 1650.867 818.4148 false 59e0b89a-e487-49f8-bab8-b5bab16be14c Panel Panel Sample Data A panel for custom notes and String values 5e637c0e-a14a-40f3-a39f-ffe56b522094 false true true 0 0 1 2 3 4 false true false 1 0 false 255;0;0;0 255;255;0;90 1201 753 82 100 1201 753 82 100 1201.028 753.3698 false 59e0b89a-e487-49f8-bab8-b5bab16be14c Panel Panel A panel for custom notes and String values 222f7629-e719-42d1-89e4-4d3b542d3026 false true true 0 1 true true true 1 0 false 255;0;0;0 255;255;255;255 1650 750 64 21 1650 750 64 21 1650.661 750.4227 false 59e0b89a-e487-49f8-bab8-b5bab16be14c Panel Panel A panel for custom notes and String values d9be3cc9-e22f-44e2-9e73-b3016e0c9226 false true true 0 1 true true true 1 0 false 255;0;0;0 255;255;255;255 1650 775 64 21 1650 775 64 21 1650.22 775.0809 false 3581f42a-9592-4549-bd6b-1c0fc39d067b Point XYZ Point XYZ Pt Create a point from {xyz} coordinates. ada96d34-db6b-497d-8e97-b8c92e3c878b false true true longest_list 1735 751 65 64 1754 753 24 60 1766 783 false X component X {x} component 98cb768c-4106-471f-98ee-1a7b93694fde false true true 1 222f7629-e719-42d1-89e4-4d3b542d3026 1 1737 753 14 20 1737 753 14 20 1745.5 763 false 0 Y component Y {y} component 468cf825-c3c4-42c9-8583-9c98f6ac93ca false true true 1 d9be3cc9-e22f-44e2-9e73-b3016e0c9226 1 1737 773 14 20 1737 773 14 20 1745.5 783 false 0 Z component Z {z} component 6e299aa2-a7e0-4b2d-ae87-584238e0197f false true true 0 1 1737 793 14 20 1737 793 14 20 1745.5 803 false 0 Point Pt Point coordinate c0489292-9b05-4978-b00a-dda2d4ec7081 true true true 0 1781 753 17 60 1781 753 17 60 1791 783 false ad483f40-dc72-40dc-844d-c9e462c7d19f Boolean Toggle false Boolean Toggle If True then data will stream to an open excel sheet Boolean (true/false) toggle 763d6aed-9b0f-4562-8585-03acc9075de9 false true true 0 1498 859 302 20 1498 859 302 20 1498.73 859.9716 false 8ec86459-bf01-4409-baee-174d0d2b13d0 Data Data A List of Any Generic Data Represents a collection of generic data 70c60886-19f8-43fb-ac3e-85faed6710e8 false true true 1 5e637c0e-a14a-40f3-a39f-ffe56b522094 1648 839 152 20 1648 839 152 20 1724.94 849.6227 false 59e0b89a-e487-49f8-bab8-b5bab16be14c Panel Panel A panel for custom notes and String values 5177881c-a161-43f2-a7de-7ea0aa62e085 false true true 0 1 true true true 1 0 false 255;0;0;0 255;255;255;255 1649 1353 64 21 1649 1353 64 21 1649.581 1353.908 false 59e0b89a-e487-49f8-bab8-b5bab16be14c Panel Panel A panel for custom notes and String values 5679427d-11aa-4f79-a712-25c5e82da237 false true true 0 1 true true true 1 0 false 255;0;0;0 255;255;255;255 1649 1376 64 21 1649 1376 64 21 1649.328 1376.107 false 3581f42a-9592-4549-bd6b-1c0fc39d067b Point XYZ Point XYZ Pt Create a point from {xyz} coordinates. fa7e2a34-1822-40b4-9f5c-34b13f947525 false true true longest_list 1735 1352 65 64 1754 1354 24 60 1766 1384 false X component X {x} component 1edd626d-0f18-4e78-ae13-dd9de097ab4f false true true 1 5177881c-a161-43f2-a7de-7ea0aa62e085 1 1737 1354 14 20 1737 1354 14 20 1745.5 1364 false 0 Y component Y {y} component 06f2202d-a081-4763-b5a9-9d1a450fdbb0 false true true 1 5679427d-11aa-4f79-a712-25c5e82da237 1 1737 1374 14 20 1737 1374 14 20 1745.5 1384 false 0 Z component Z {z} component 637e73e8-e775-4ec9-b885-71be094e0087 false true true 0 1 1737 1394 14 20 1737 1394 14 20 1745.5 1404 false 0 Point Pt Point coordinate 9ce83c13-67d3-45e9-bd30-e2c56cebaa8e true true true 0 1781 1354 17 60 1781 1354 17 60 1791 1384 false ad483f40-dc72-40dc-844d-c9e462c7d19f Boolean Toggle true Boolean Toggle Stream by Column? Boolean (true/false) toggle 1ab2e2be-ba10-413a-90eb-4c19db67b961 false true true 0 1650 1419 150 20 1650 1419 150 20 1650.558 1419.321 false 59e0b89a-e487-49f8-bab8-b5bab16be14c Panel Panel Sample Data A panel for custom notes and String values 30eda32a-9823-4112-babc-46d448b5bd97 false true true 0 1 2 3 4 5 false true false 1 0 false 255;0;0;0 255;255;0;90 1200 1354 82 100 1200 1354 82 100 1200.984 1354.45 false 8ec86459-bf01-4409-baee-174d0d2b13d0 Data Data A Table of Any Generic Data Represents a collection of generic data 140dbd5a-60e6-4ee6-ae02-2e9c8b567ab7 false true true 3 df2c104c-5b00-4323-a7fc-d527e7d2e823 95ee7f9e-75c4-4d2b-bf83-a6e22503217a d7784577-7cb0-4ad7-9ca0-ad57110ac9c8 1640 1440 161 20 1640 1440 161 20 1720.509 1450.837 false 59e0b89a-e487-49f8-bab8-b5bab16be14c Panel Panel Sample Data A panel for custom notes and String values 9aa5127d-a46b-4c0b-88ed-a26f9415d236 false true true 0 500 400 300 200 100 false true false 1 0 false 255;0;0;0 255;255;0;90 1200 1460 82 100 1200 1460 82 100 1200.453 1460.692 false ad483f40-dc72-40dc-844d-c9e462c7d19f Boolean Toggle false Boolean Toggle If True then data will stream to an open excel sheet Boolean (true/false) toggle 856912e3-d37e-47fb-82ad-08bca7c438bf false true true 0 1498 1461 302 20 1498 1461 302 20 1498.386 1461.667 false f80cfe18-9510-4b89-8301-8e58faf423bb Flatten Tree Flatten Tree Flatten Removes all branching information from a data tree. 267fbebe-122a-41e6-aeda-3cd34b432ba2 true true true longest_list 1350 1352 64 59 1370 1354 24 55 1382 1382 false Data D Data stream to flatten c28c9839-7b8c-4f23-ad70-949915ed5777 true true true 2 1 30eda32a-9823-4112-babc-46d448b5bd97 1352 1354 15 27 1352 1354 15 27 1361 1367.75 false Path P Path of flattened tree 7f71dc25-5d77-4a84-a393-9c3148021265 false true true 0 1 1352 1381 15 28 1352 1381 15 28 1361 1395.25 false {0} Data D Squished data df2c104c-5b00-4323-a7fc-d527e7d2e823 true true true 0 1397 1354 15 55 1397 1354 15 55 1406 1381.5 false f80cfe18-9510-4b89-8301-8e58faf423bb Flatten Tree Flatten Tree Flatten Removes all branching information from a data tree. 96ca106e-1e73-452a-8b27-683c12791dcf true true true longest_list 1350 1452 64 59 1370 1454 24 55 1382 1482 false Data D Data stream to flatten 9eeb651d-bc91-475e-b30e-75a67387520a true true true 2 1 9aa5127d-a46b-4c0b-88ed-a26f9415d236 1352 1454 15 27 1352 1454 15 27 1361 1467.75 false Path P Path of flattened tree a590f62b-f474-49d8-aea4-fabad66bbd10 false true true 0 1 1352 1481 15 28 1352 1481 15 28 1361 1495.25 false {1} Data D Squished data 95ee7f9e-75c4-4d2b-bf83-a6e22503217a true true true 0 1397 1454 15 55 1397 1454 15 55 1406 1481.5 false ad483f40-dc72-40dc-844d-c9e462c7d19f Boolean Toggle true Boolean Toggle Stream by Column? Boolean (true/false) toggle 9d47f760-8ad4-4eef-afd8-e011956fcd20 false true true 0 1651 1571 150 20 1651 1571 150 20 1651.432 1571.58 false 59e0b89a-e487-49f8-bab8-b5bab16be14c Panel Panel A panel for custom notes and String values 02f6b430-98bd-4167-916e-80f1893fe3e2 false true true 0 1 true true true 1 0 false 255;0;0;0 255;255;255;255 1650 1504 64 21 1650 1504 64 21 1650.332 1504.457 false 59e0b89a-e487-49f8-bab8-b5bab16be14c Panel Panel A panel for custom notes and String values 65d98c14-4489-44a3-80cf-0b6412dc4bf1 false true true 0 1 true true true 1 0 false 255;0;0;0 255;255;255;255 1650 1526 64 21 1650 1526 64 21 1650.347 1526.253 false 3581f42a-9592-4549-bd6b-1c0fc39d067b Point XYZ Point XYZ Pt Create a point from {xyz} coordinates. 16276d82-f789-476c-a8d8-dc3e770b9002 false true true longest_list 1735 1502 65 64 1754 1504 24 60 1766 1534 false X component X {x} component 8a8c901e-e7e7-4d3d-bf38-ed72bc37046c false true true 1 02f6b430-98bd-4167-916e-80f1893fe3e2 1 1737 1504 14 20 1737 1504 14 20 1745.5 1514 false 0 Y component Y {y} component 57e646d2-b2e9-487e-bdb2-0cb2723c51b9 false true true 1 65d98c14-4489-44a3-80cf-0b6412dc4bf1 1 1737 1524 14 20 1737 1524 14 20 1745.5 1534 false 0 Z component Z {z} component 33e49f54-4f30-483f-a8db-a03cbb7d29be false true true 0 1 1737 1544 14 20 1737 1544 14 20 1745.5 1554 false 0 Point Pt Point coordinate 55570b4b-1392-40f8-81f3-456d5248d331 true true true 0 1781 1504 17 60 1781 1504 17 60 1791 1534 false ad483f40-dc72-40dc-844d-c9e462c7d19f Boolean Toggle false Boolean Toggle If True then data will stream to an open excel sheet Boolean (true/false) toggle 59f0d1a6-fffb-48aa-b7cb-2ae318449aa1 false true true 0 1498 1784 302 20 1498 1784 302 20 1498.473 1784.26 false 8ec86459-bf01-4409-baee-174d0d2b13d0 Data Data A List of Any Generic Data Represents a collection of generic data 93eec32d-e6c6-47ad-b222-c5d70eedd7e2 false true true 3 df2c104c-5b00-4323-a7fc-d527e7d2e823 95ee7f9e-75c4-4d2b-bf83-a6e22503217a d7784577-7cb0-4ad7-9ca0-ad57110ac9c8 1649 1593 152 20 1649 1593 152 20 1725.337 1603.096 false 8ec86459-bf01-4409-baee-174d0d2b13d0 Data Data Takes Inputs from "XL Font" Component Represents a collection of generic data 5c152da5-a634-4c96-aede-ff3ac839bf2c false true true 2 1 a21a6039-fe46-420c-bb0a-446e1ccb1bd3 1574 1692 226 20 1574 1692 226 20 1687.754 1702.569 false 8ec86459-bf01-4409-baee-174d0d2b13d0 Data Data Takes Inputs from "XL Cell" Component Represents a collection of generic data 75c59d66-3a90-45a2-96e2-e350c2ebdf34 false true true 2 1 04e0fed7-56b4-43bf-ac37-7171e15870ec 1578 1713 222 20 1578 1713 222 20 1689.365 1723.408 false 8ec86459-bf01-4409-baee-174d0d2b13d0 Data Data Takes Inputs from "XL Border" Component Represents a collection of generic data 99018b16-14fb-49d4-a7c1-c446722479aa false true true 2 1 83494904-50a3-4c0e-8831-773d8dea3c2f 1562 1734 238 20 1562 1734 238 20 1681.391 1744.376 false 8ec86459-bf01-4409-baee-174d0d2b13d0 Data Data Corresponding List of Branch Titles Represents a collection of generic data 747c309e-853d-408f-8c19-e7275d00f249 false true true 1 0172b08f-21a1-46ae-8097-96c6a6cced31 1600 1650 200 20 1600 1650 200 20 1700.705 1660.254 false 8ec86459-bf01-4409-baee-174d0d2b13d0 Data Data Corresponding List of Item Titles Represents a collection of generic data 1603221e-4b10-44c6-b3bd-da7e8c97b819 false true true 1 049f0131-c4a9-4e70-ac2b-ffe004340a93 1615 1671 185 20 1615 1671 185 20 1708.264 1681.395 false 59e0b89a-e487-49f8-bab8-b5bab16be14c Panel Panel Branch Titles A panel for custom notes and String values 0172b08f-21a1-46ae-8097-96c6a6cced31 false true true 0 Branch (0) Branch (1) Branch (2) false true false 1 0 false 255;0;0;0 255;255;0;90 1200 1683 99 61 1200 1683 99 61 1200.31 1683.264 false 59e0b89a-e487-49f8-bab8-b5bab16be14c Panel Panel Sample Data A panel for custom notes and String values 049f0131-c4a9-4e70-ac2b-ffe004340a93 false true true 0 Item (0) Item (1) Item (2) Item (3) Item (4) false true false 1 0 false 255;0;0;0 255;255;0;90 1200 1745 99 89 1200 1745 99 89 1200.376 1745.421 false ad483f40-dc72-40dc-844d-c9e462c7d19f Boolean Toggle false Boolean Toggle Live Stream List From Excel Boolean (true/false) toggle 2001263a-d068-4ccd-9279-86dfe2320f3b false true true 0 561 2566 190 20 561 2566 190 20 561.1402 2566.727 false c552a431-af5b-46a9-a8a4-0fcbc27ef596 Group 150;176;153;255 1 2 832ea810-1683-4f0e-9774-69126f7ef8d4 e00d9f72-2da1-45ad-bc62-df559c4a9b93 Group Optional A group of Grasshopper objects 076e4c28-2811-4f26-b7a4-4429f0e24f70 1e9e08fc-c31e-49eb-a36c-90de5e62e5f5 VB Script If _Stream = True Then Dim oldCI As System.Globalization.CultureInfo = system.Threading.Thread.CurrentThread.CurrentCulture System.Threading.Thread.CurrentThread.CurrentCulture = New System.Globalization.CultureInfo("en-US") Dim i,j,k,m,n,p As Integer Dim objExcel As Object objExcel = System.Runtime.InteropServices.Marshal.GetActiveObject("Excel.Application") Dim newSheet, excelSheet As Object excelSheet = objExcel.ActiveSheet Dim xlChart, xlChartObject As Object Dim intActive As Integer Dim strOut As String For i = 1 To CInt(excelSheet.ChartObjects.count) Step 1 If CStr(excelSheet.ChartObjects(i).name) = CStr(Title) Then intActive = i End If Next If intActive = 0 Then xlChartObject = excelSheet.ChartObjects.Add(Chart_Position.X, Chart_Position.Y, Size.X, Size.Y) xlChartObject.name = CStr(Title) strOut = "New Chart" Else xlChartObject = excelSheet.ChartObjects(intActive) strOut = "Updated Chart" End If xlChart = xlChartObject.Chart excelSheet.Visible = False newSheet = objExcel.Sheets.Add() ' Add a chart object to the first worksheet With xlChart If Chart_Type.Count() > 0 Then .ChartType = Chart_Type(0) Else .ChartType = -4120 End If .SetSourceData(excelSheet.Range(excelSheet.Cells(CInt(Data_Origin.Y), CInt(Data_Origin.X)), excelSheet.Cells(CInt(Data_Bound.Y), CInt(Data_Bound.X)))) If ByColumn = True Then .PlotBy = 2 Else .PlotBy = 1 End If End With 'Change the formatting on the If Frame_Format.Count() > 0 Then With xlChart .ChartArea.Interior.Pattern = CInt(Frame_Format(0)) .ChartArea.Interior.Patterncolor = RGB(CInt(Frame_Format(1).r), CInt(Frame_Format(1).g), CInt(Frame_Format(1).b)) .ChartArea.Interior.Color = RGB(CInt(Frame_Format(2).r), CInt(Frame_Format(2).g), CInt(Frame_Format(2).b)) End With End If If Title = "" = False Then xlChart.HasTitle = True xlChart.ChartTitle.Text = CStr(Title) If Title_Format.count() > 0 Then With xlChart.ChartTitle .Font.Size = CInt(Title_Format(0)) .Font.Color = RGB(CInt(Title_Format(1).r), CInt(Title_Format(1).g), CInt(Title_Format(1).b)) .HorizontalAlignment = CInt(Title_Format(2)) .VerticalAlignment = CInt(Title_Format(3)) .Font.Bold = CBool(Title_Format(4)) .Font.Italic = CBool(Title_Format(5)) .Font.Underline = CBool(Title_Format(6)) .Font.Strikethrough = CBool(Title_Format(7)) .Font.Subscript = CBool(Title_Format(8)) .Font.Superscript = CBool(Title_Format(9)) End With End If End If ' create and format an optional marker k = 0 If Legend_Format.count() > 0 Then xlChart.HasLegend = True With xlChart.Legend For i = 1 To .LegendEntries.Count .LegendEntries(i).Font.Size = CInt(Legend_Format(0)) .LegendEntries(i).Font.Color = RGB(CInt(Legend_Format(1).r), CInt(Legend_Format(1).g), CInt(Legend_Format(1).b)) .LegendEntries(i).Font.Bold = CBool(Legend_Format(4)) .LegendEntries(i).Font.Italic = CBool(Legend_Format(5)) .LegendEntries(i).Font.Underline = CBool(Legend_Format(6)) .LegendEntries(i).Font.Strikethrough = CBool(Legend_Format(7)) .LegendEntries(i).Font.Subscript = CBool(Legend_Format(8)) .LegendEntries(i).Font.Superscript = CBool(Legend_Format(9)) Next End With Else xlChart.HasLegend = False End If If Chart_Type(2) = 1 Then For i = 1 To xlChart.SeriesCollection.count Step 1 With xlChart.SeriesCollection(i) If Data_Format.BranchCount() > 0 Then If Data_Format.BranchCount() = 1 Then .Interior.Color = RGB(Data_Format.branch(0).Item(1).r, Data_Format.branch(0).Item(1).G, Data_Format.branch(0).Item(1).B) .Border.Color = RGB(Data_Format.branch(0).Item(2).r, Data_Format.branch(0).Item(2).G, Data_Format.branch(0).Item(2).B) Else .Interior.Color = RGB(Data_Format.branch(i).Item(1).r, Data_Format.branch(i).Item(1).G, Data_Format.branch(i).Item(1).B) .Border.Color = RGB(Data_Format.branch(i).Item(2).r, Data_Format.branch(i).Item(2).G, Data_Format.branch(i).Item(2).B) End If End If End With Next End If ' Format each Data point If Chart_Type(2) = 0 Then For i = 1 To xlChart.SeriesCollection.count Step 1 With xlChart.SeriesCollection(i) If Marker_Format.BranchCount() > 0 And Chart_Type(1) = True Then .MarkerStyle = CInt(Marker_Format.branch(n).Item(0)) .smooth = False End If ''''''''''''''''''''''''''''''''' If Data_Format.BranchCount() > 0 Then If Data_Format.Branch(k).Item(3) = 1 Then .Format.ThreeD.Visible = False Else .Format.ThreeD.Visible = True .Format.ThreeD.BevelTopType = Data_Format.Branch(k).Item(3) .Format.ThreeD.BevelBottomType = Data_Format.Branch(k).Item(3) End If End If For j = 1 To .Points.Count ''''''''''''''''''''''''''''' If Data_Format.BranchCount() > 0 Then .Points(j).Interior.Color = RGB(Data_Format.branch(k).Item(1).r, Data_Format.branch(k).Item(1).G, Data_Format.branch(k).Item(1).B) .Points(j).Border.Color = RGB(Data_Format.branch(k).Item(2).r, Data_Format.branch(k).Item(2).G, Data_Format.branch(k).Item(2).B) If Data_Format.Branch(k).Item(4) = True Then .Points(j).HasDataLabel = True End If If Data_Format.BranchCount() = 1 Then k = 0 Else k = k + 1 End If End If ''''''''''''''''''''''''''''''' If Marker_Format.BranchCount() > 0 And CBool(Chart_Type(1)) = True Then .Points(j).MarkerForegroundColor = RGB(Marker_Format.branch(p).Item(1).r, Marker_Format.branch(p).Item(1).G, Marker_Format.branch(p).Item(1).B) .Points(j).MarkerBackgroundColor = RGB(Marker_Format.branch(p).Item(2).r, Marker_Format.branch(p).Item(2).G, Marker_Format.branch(p).Item(2).B) .Points(j).MarkerSize = CInt(Marker_Format.branch(p).Item(3)) If Marker_Format.BranchCount() = 1 Then p = 0 Else p = p + 1 End If End If '''''''''''''''''''''''''''' Next End With If Data_Format.BranchCount() = 1 Then m = 0 Else m = m + 1 End If If Marker_Format.BranchCount() = 1 And CBool(Chart_Type(1)) = True Then n = 0 Else n = n + 1 End If Next End If newSheet.activate newSheet.Delete() excelSheet.visible = True excelSheet.activate A = strOut End If 0 VB Script Excel Chart (update) A VB.NET scriptable component 019bfd16-d11b-4200-a128-9b9560f73204 false true true longest_list 1959 3951 141 264 2049 3953 24 260 2061 4083 false 13 84fa917c-1ed8-4db3-8be1-7bdc4a6495a2 Variable Chart_Type Script Variable Chart_Type 1 true true 84fa917c-1ed8-4db3-8be1-7bdc4a6495a2 Variable Data_Start Script Variable Data_Start true true 84fa917c-1ed8-4db3-8be1-7bdc4a6495a2 Variable Data_End Script Variable Data_End true true 84fa917c-1ed8-4db3-8be1-7bdc4a6495a2 Variable ByColumn Script Variable ByColumn true true 84fa917c-1ed8-4db3-8be1-7bdc4a6495a2 Variable Chart_Origin Script Variable Chart_Origin true true 84fa917c-1ed8-4db3-8be1-7bdc4a6495a2 Variable Size Script Variable Size true true 84fa917c-1ed8-4db3-8be1-7bdc4a6495a2 Variable Title Script Variable Title true true 84fa917c-1ed8-4db3-8be1-7bdc4a6495a2 Variable Frame_Format Script Variable Frame_Format 1 true true 84fa917c-1ed8-4db3-8be1-7bdc4a6495a2 Variable Title_Format Script Variable Title_Format 1 true true 84fa917c-1ed8-4db3-8be1-7bdc4a6495a2 Variable Data_Format Script Variable Data_Format 2 true true 84fa917c-1ed8-4db3-8be1-7bdc4a6495a2 Variable Marker_Format Script Variable Marker_Format 2 true true 84fa917c-1ed8-4db3-8be1-7bdc4a6495a2 Variable Legend_Format Script Variable Legend_Format 1 true true 84fa917c-1ed8-4db3-8be1-7bdc4a6495a2 Variable _Stream Script Variable _Stream true true 2 3ede854e-c753-40eb-84cb-b48008f14fd4 Output Print, Reflect and Error streams true false 8ec86459-bf01-4409-baee-174d0d2b13d0 Result A Output parameter A true false Variable Chart_Type Chart_Type Script Variable Chart_Type c2335d75-d1e1-41d9-8156-52a71d5cc256 true true true 1 1 e815b1c4-3886-44be-a84f-a82cbde7ba2d 6a184b65-baa3-42d1-a548-3915b401de53 true true 1961 3953 85 20 1961 3953 85 20 2005 3963 false Variable Data_Start Data_Origin Script Variable Data_Start 00348dee-2168-490a-b06b-be3faad968a6 true true true 1 4d889f1b-0777-4d60-974f-0d9a92725ab4 e1937b56-b1da-4c12-8bd8-e34ee81746ef true true 1961 3973 85 20 1961 3973 85 20 2005 3983 false Variable Data_End Data_Bound Script Variable Data_End 276b9c97-0e9a-4c2f-bb31-a34b89238343 true true true 1 5ab49310-6afc-475b-86da-ffb1dd22253e e1937b56-b1da-4c12-8bd8-e34ee81746ef true true 1961 3993 85 20 1961 3993 85 20 2005 4003 false Variable ByColumn ByColumn Script Variable ByColumn 3fa883c1-f48b-4614-8002-0b6717f53888 true true true 1 8707856e-2433-44bb-a0e0-13ccbede08c4 3cda2745-22ac-4244-9b04-97a5255fa60f true true 1961 4013 85 20 1961 4013 85 20 2005 4023 false Variable Chart_Origin Chart_Position Script Variable Chart_Origin cede818d-8b6e-4fb5-a673-050d6fc202fd true true true 1 0ae5a9a7-a242-4d6d-b72e-e5d62e9436dc e1937b56-b1da-4c12-8bd8-e34ee81746ef true true 1961 4033 85 20 1961 4033 85 20 2005 4043 false Variable Size Size Script Variable Size 75aa1351-76cb-4498-aa09-855a0d4d6035 true true true 1 ae48a36b-d93c-4db9-85c7-cd5db20cc86c e1937b56-b1da-4c12-8bd8-e34ee81746ef true true 1961 4053 85 20 1961 4053 85 20 2005 4063 false Variable Title Title Script Variable Title 9dc3a696-f6cf-4d53-b583-0f6ab3a84e51 true true true 1 5c5a5a2c-23b9-4970-b998-f6e11a03a290 abf1fd1b-dbe5-4be6-9832-d8dc105e207f true true 1961 4073 85 20 1961 4073 85 20 2005 4083 false Variable Frame_Format Frame_Format Script Variable Frame_Format ca1467b8-7d82-4ea8-ad34-4752e7e9c57e true true true 1 1 6d21d5af-e9d9-4cfb-81de-cd63dd06cc6c 6a184b65-baa3-42d1-a548-3915b401de53 true true 1961 4093 85 20 1961 4093 85 20 2005 4103 false Variable Title_Format Title_Format Script Variable Title_Format e389c221-12b1-4be9-86b7-aa47242d5266 true true true 1 1 7bc8bb06-1ff8-4529-833d-2f0a4ea138c7 6a184b65-baa3-42d1-a548-3915b401de53 true true 1961 4113 85 20 1961 4113 85 20 2005 4123 false Variable Data_Format Data_Format Script Variable Data_Format 0d7edaa4-d9a5-441f-aee4-e927a7ddaceb true true true 2 1 c9a57720-a6a4-4aaf-8c2e-ef89a44b8f7d 6a184b65-baa3-42d1-a548-3915b401de53 true true 1961 4133 85 20 1961 4133 85 20 2005 4143 false Variable Marker_Format Marker_Format Script Variable Marker_Format 316ee962-359d-4b7f-9f04-02c76c48d5ce true true true 2 1 3be54e4f-5115-4037-bfef-14aacd7320b0 6a184b65-baa3-42d1-a548-3915b401de53 true true 1961 4153 85 20 1961 4153 85 20 2005 4163 false Variable Legend_Format Legend_Format Script Variable Legend_Format 05a47892-bda2-42e3-a9f1-077d9d7c4d15 true true true 1 1 c8658c12-5859-4e23-ad8d-8d099b12774b 6a184b65-baa3-42d1-a548-3915b401de53 true true 1961 4173 85 20 1961 4173 85 20 2005 4183 false Variable _Stream _Stream Script Variable _Stream 57a5dcd0-336e-4ed7-b670-42382833a11f true true true 1 0bcf735e-f71f-47a4-90d6-02568573b164 3cda2745-22ac-4244-9b04-97a5255fa60f true true 1961 4193 85 20 1961 4193 85 20 2005 4203 false Output out Print, Reflect and Error streams 07c1ae76-863a-462f-a39e-0a1d79ec8950 false true true 0 2076 3953 22 130 2076 3953 22 130 2088.5 4018 false Result A A Output parameter A 377520db-21e3-48aa-bf61-664f0413e732 true true true 0 2076 4083 22 130 2076 4083 22 130 2088.5 4148 false 59e0b89a-e487-49f8-bab8-b5bab16be14c Panel Panel EXCEL TOOLS BRIEF A panel for custom notes and String values 926af45e-937a-4ea6-8d8b-8c4f16da40ee false true true 0 Brief: The toolset contained below allows the user to stream formatted data to and from open microsoft excel spreadsheet. There are three basic tool types, write to excel tools, which stream lists and tables to an open excel sheet live, read excel tools, which read specified regions of an open excel sheet, and a chart function, which produces and excel chart with customizable grasshopper driven formatting. The attempt is to create an option to very simply stream data and at the same time provide wide access to a series of embeded formatting parameters to make the link between the two platforms more productive... and prettier. THE READ AND WRITE TOOLS HAVE BEEN ALPHA TESTED FOR ARE COMPATIBLE WITH EXCEL 2003+ THE CHART TOOL HAS BEEN ALPHA TESTED FOR AND IS COMPATIBLE WITH EXCEL 2007+ true true true 0 0 false 255;0;0;0 255;153;153;153 1 150 748 199 1 150 748 199 1.459651 150.4099 false Trebuchet MS 10 false false 59e0b89a-e487-49f8-bab8-b5bab16be14c Panel Panel NeoArchaic 2011 A panel for custom notes and String values 6d4a1786-94db-4b21-a9f7-3371f70c9356 false true true 0 Grasshopper-Excel v0-04 (BETA) false false false 0 0 false 255;255;255;255 255;0;0;0 0 -1 1350 118 0 -1 1350 118 0.8289229 -0.7548866 false Arial Black 48 true false 59e0b89a-e487-49f8-bab8-b5bab16be14c Panel Panel A panel for custom notes and String values 0f1a907b-b1c1-4a4c-ad59-1e858718fb8d false true true 0 adapted from work by Damian Alamar of www.liquidtectonics.com false false false 0 0 false 255;255;255;255 255;0;0;0 0 118 1350 31 0 118 1350 31 0.4466284 118.9638 false Arial 15.75 true false 59e0b89a-e487-49f8-bab8-b5bab16be14c Panel Panel A panel for custom notes and String values a3b4369d-edfb-4608-a08e-fe2ccd730268 false true true 0 FORMATTING true true true 1 0 false 255;255;255;255 255;51;51;51 450 650 599 48 450 650 599 48 450.5361 650.337 false Courier New 26.25 true false 59e0b89a-e487-49f8-bab8-b5bab16be14c Panel Panel A panel for custom notes and String values bc8686a3-a4ba-4d55-9ee1-0e37af5d6b32 false true true 0 STREAM LIST TO EXCEL true true true 1 0 false 255;255;255;255 255;51;51;51 1199 650 901 48 1199 650 901 48 1199.713 650.8621 false Courier New 26.25 true false 59e0b89a-e487-49f8-bab8-b5bab16be14c Panel Panel A panel for custom notes and String values a6be280b-8656-466e-9847-50cf9a04fbfe false true true 0 STREAM TABLE TO EXCEL true true true 1 0 false 255;255;255;255 255;51;51;51 1200 1251 901 48 1200 1251 901 48 1200.401 1251.612 false Courier New 26.25 true false 59e0b89a-e487-49f8-bab8-b5bab16be14c Panel Panel A panel for custom notes and String values 56e0e2fe-8c8b-447d-bd1a-4c5648ad38cf false true true 0 STREAM LIST FROM EXCEL true true true 1 0 false 255;255;255;255 255;51;51;51 450 2300 599 48 450 2300 599 48 450.8772 2300.95 false Courier New 26.25 true false c552a431-af5b-46a9-a8a4-0fcbc27ef596 Group 150;255;255;255 1 7 5b42a164-008c-4742-b4e5-92a602f616d7 689cf6fc-7ead-4e11-86fe-a77433a43053 e8150735-1c4d-4306-b6ce-124002e0891d fa3c79cc-96bf-4b57-b9b5-9fdb13999bc8 62057f62-c934-4b94-b636-9589fb7afc71 b37f9fb8-401f-492d-abee-662c192be3b1 74ce9b1b-0435-4a05-8ef3-571bd29d39a4 Group SAMPLE A group of Grasshopper objects 47f27770-c777-4a2a-b2c8-60395d421577 59e0b89a-e487-49f8-bab8-b5bab16be14c Panel Panel A panel for custom notes and String values 9a4ae1d1-4509-4dcc-908f-e537cfeaf517 false true true 0 STREAM TABLE FROM EXCEL true true true 1 0 false 255;255;255;255 255;51;51;51 452 2601 599 48 452 2601 599 48 452.2772 2601.42 false Courier New 26.25 true false 59e0b89a-e487-49f8-bab8-b5bab16be14c Panel Panel XL Graph Bevel A panel for custom notes and String values b3267753-26e1-454f-b695-dda759ab3713 false true true 0 Chart: 3d Bevel (0-13) http://msdn.microsoft.com/en-us/library/ff860799.aspx Pattern: See Cell Pattern Above true true true 1 0 false 255;0;0;0 255;0;255;255 451 3701 599 100 451 3701 599 100 451.5781 3701.614 false 59e0b89a-e487-49f8-bab8-b5bab16be14c Panel Panel A panel for custom notes and String values dbdd8d9b-17c3-45df-84c5-a6898857d481 false true true 0 FORMATTING true true true 1 0 false 255;255;255;255 255;51;51;51 451 3201 599 48 451 3201 599 48 451.0048 3201.802 false Courier New 26.25 true false 59e0b89a-e487-49f8-bab8-b5bab16be14c Panel Panel XL Marker Type A panel for custom notes and String values 6a477829-0f5d-48a7-bc87-2fe9406da028 false true true 0 Chart: Marker Style (11x) http://msdn.microsoft.com/en-us/library/bb241374(office.12).aspx true true true 1 0 false 255;0;0;0 255;0;255;255 451 4000 599 48 451 4000 599 48 451.377 4000.371 false 59e0b89a-e487-49f8-bab8-b5bab16be14c Panel Panel XL Pattern Type A panel for custom notes and String values 263b81e6-d070-42ad-96cc-3a8ad9aa3edd false true true 0 Pattern: See Cell Pattern Above true true true 1 0 false 255;0;0;0 255;0;255;255 451 3502 599 48 451 3502 599 48 451.7001 3502.15 false f19b8c33-dff2-4cc2-b95b-b4005ff3c10c Receiver true 1 Receiver Point Taken from B output of Write to Excel A data receiver object. 5ab49310-6afc-475b-86da-ffb1dd22253e false true true 1 c890b1ea-5bb2-4192-9823-9da52fdee6c0 1560 3993 240 20 1560 3993 240 20 1680.988 4003.278 false 8ec86459-bf01-4409-baee-174d0d2b13d0 Data Data "XL Chart" Input Represents a collection of generic data e815b1c4-3886-44be-a84f-a82cbde7ba2d false true true 2 1 dd74a8f6-3bd6-4111-aef9-e3363f4a3e98 1701 3952 99 20 1701 3952 99 20 1751.307 3962.445 false 8ec86459-bf01-4409-baee-174d0d2b13d0 Data Data Optional Input for "XL Frame" component Represents a collection of generic data 6d21d5af-e9d9-4cfb-81de-cd63dd06cc6c false true true 2 1 b392a86b-1c25-495a-afb6-2b6a5d165212 1570 4224 231 20 1570 4224 231 20 1685.501 4234.205 false 8ec86459-bf01-4409-baee-174d0d2b13d0 Data Data Optional Input for "XL Font" component Represents a collection of generic data 7bc8bb06-1ff8-4529-833d-2f0a4ea138c7 false true true 2 1 a21a6039-fe46-420c-bb0a-446e1ccb1bd3 1578 4245 222 20 1578 4245 222 20 1689.275 4255.674 false 8ec86459-bf01-4409-baee-174d0d2b13d0 Data Data Optional Input for "XL Data" component Represents a collection of generic data c9a57720-a6a4-4aaf-8c2e-ef89a44b8f7d false true true 2 1 98680d24-e0f2-46d5-8100-9a571ccabe27 1578 4266 222 20 1578 4266 222 20 1689.772 4276.486 false 8ec86459-bf01-4409-baee-174d0d2b13d0 Data Data Optional Input for "XL Mark" component Represents a collection of generic data 3be54e4f-5115-4037-bfef-14aacd7320b0 false true true 2 1 843ca577-ce7c-46c3-b642-a9bf4ea67b3d 1576 4286 224 20 1576 4286 224 20 1688.612 4296.849 false 8ec86459-bf01-4409-baee-174d0d2b13d0 Data Data Optional Input for "XL Font" component Represents a collection of generic data c8658c12-5859-4e23-ad8d-8d099b12774b false true true 2 1 a21a6039-fe46-420c-bb0a-446e1ccb1bd3 1579 4308 222 20 1579 4308 222 20 1690.084 4318.153 false ad483f40-dc72-40dc-844d-c9e462c7d19f Boolean Toggle false Boolean Toggle If Excel Sheet Contents and Grasshopper Inputs Correspond Boolean (true/false) toggle 0bcf735e-f71f-47a4-90d6-02568573b164 false true true 0 1451 4352 349 20 1451 4352 349 20 1451.468 4352.033 false 59e0b89a-e487-49f8-bab8-b5bab16be14c Panel Panel A panel for custom notes and String values 0ddea709-f894-414f-8b37-33e2f8b23ceb false true true 0 CHART FROM EXCEL/ GRASSHOPPER true true true 1 0 false 255;255;255;255 255;51;51;51 1200 3200 901 48 1200 3200 901 48 1200.4 3200.625 false Courier New 26.25 true false c552a431-af5b-46a9-a8a4-0fcbc27ef596 Group 255;0;0;0 1 1 38519894-3463-4b4d-8347-39e2cb0b6b58 Group A group of Grasshopper objects cf69840f-73de-47ea-acdb-a55e36ed632b c552a431-af5b-46a9-a8a4-0fcbc27ef596 Group 150;255;255;255 1 22 b2e17925-f642-4306-953c-bda83f38d923 5661dc12-2e8d-41a0-95da-9e051c82bb2e 45a27fa3-d158-434e-ae70-3d6e6be2ed54 111a1177-9e68-4142-9fc2-8e66f9591009 33be6faf-027b-440e-adcc-ebc82b24f7e4 f3acc6ac-d857-4bb2-99b1-c73d557a556b 6998906c-3347-4b72-81a6-3f033d612b0a 1fa498ce-a4f0-4bc5-9138-6296080d203d d96cd2d0-88de-42ae-8187-64cbfe61a180 2d05a0e0-ecaf-42b8-97a3-79509bbe7fbb 616508fb-c762-4860-b8c4-f279c0577fe5 32cf554f-deb7-42f3-9bd2-adc52953bcf5 29e2f746-517d-40f8-91e5-e5c0d7e346a0 57877584-e661-4e77-9bfa-0e519bea4fc9 5c31e4ad-5b98-449b-9c7a-b038b3b7086b 75503cf2-610e-4975-a784-f236a4d08166 673713d5-0050-4235-8ffe-27524fe34b82 5f5e079f-058c-4441-ac9c-7c5871951311 0d2cf2c4-0951-41e2-a21c-334b8a08bf48 b257ee4e-6ec0-4a47-861b-98341dc1cdf3 35e3191d-724e-439c-8f02-c21b5b7feca7 0a26e000-d86e-44ac-afb0-c56a4ec231db Group A group of Grasshopper objects 9bf9e525-b58d-434a-b906-e8626e50c1b8 c552a431-af5b-46a9-a8a4-0fcbc27ef596 Group 150;170;135;255 1 6 29e2f746-517d-40f8-91e5-e5c0d7e346a0 673713d5-0050-4235-8ffe-27524fe34b82 5f5e079f-058c-4441-ac9c-7c5871951311 0d2cf2c4-0951-41e2-a21c-334b8a08bf48 b257ee4e-6ec0-4a47-861b-98341dc1cdf3 35e3191d-724e-439c-8f02-c21b5b7feca7 Group OPTIONAL A group of Grasshopper objects b2e17925-f642-4306-953c-bda83f38d923 2e3ab970-8545-46bb-836c-1c11e5610bce Integer Integer Int Represents a collection of Integer numbers 5661dc12-2e8d-41a0-95da-9e051c82bb2e false true true 1 45a27fa3-d158-434e-ae70-3d6e6be2ed54 1600 3386 50 20 1600 3386 50 20 1625.222 3396.584 false 59e0b89a-e487-49f8-bab8-b5bab16be14c Panel Panel A panel for custom notes and String values 45a27fa3-d158-434e-ae70-3d6e6be2ed54 false true true 0 50 true true true 1 0 false 255;0;0;0 255;255;255;255 1500 3387 64 20 1500 3387 64 20 1500.245 3387.477 false 2e3ab970-8545-46bb-836c-1c11e5610bce Integer Integer Int Represents a collection of Integer numbers 111a1177-9e68-4142-9fc2-8e66f9591009 false true true 1 33be6faf-027b-440e-adcc-ebc82b24f7e4 1599 3407 50 20 1599 3407 50 20 1624.87 3417.307 false 59e0b89a-e487-49f8-bab8-b5bab16be14c Panel Panel A panel for custom notes and String values 33be6faf-027b-440e-adcc-ebc82b24f7e4 false true true 0 150 true true true 1 0 false 255;0;0;0 255;255;255;255 1499 3408 64 20 1499 3408 64 20 1499.76 3408.278 false 2e3ab970-8545-46bb-836c-1c11e5610bce Integer Integer Int Represents a collection of Integer numbers f3acc6ac-d857-4bb2-99b1-c73d557a556b false true true 1 6998906c-3347-4b72-81a6-3f033d612b0a 1600 3428 50 20 1600 3428 50 20 1625.004 3438.702 false 59e0b89a-e487-49f8-bab8-b5bab16be14c Panel Panel A panel for custom notes and String values 6998906c-3347-4b72-81a6-3f033d612b0a false true true 0 600 true true true 1 0 false 255;0;0;0 255;255;255;255 1499 3429 64 20 1499 3429 64 20 1499.76 3429.691 false 2e3ab970-8545-46bb-836c-1c11e5610bce Integer Integer Int Represents a collection of Integer numbers 1fa498ce-a4f0-4bc5-9138-6296080d203d false true true 1 d96cd2d0-88de-42ae-8187-64cbfe61a180 1599 3449 50 20 1599 3449 50 20 1624.921 3459.692 false 59e0b89a-e487-49f8-bab8-b5bab16be14c Panel Panel A panel for custom notes and String values d96cd2d0-88de-42ae-8187-64cbfe61a180 false true true 0 600 true true true 1 0 false 255;0;0;0 255;255;255;255 1500 3450 64 20 1500 3450 64 20 1500.081 3450.832 false 3581f42a-9592-4549-bd6b-1c0fc39d067b Point XYZ Point XYZ Pt Create a point from {xyz} coordinates. 2d05a0e0-ecaf-42b8-97a3-79509bbe7fbb false true true longest_list 1733 3381 65 64 1752 3383 24 60 1764 3413 false X component X {x} component b3bc93d6-26a3-4581-8c89-db7198ad0d7c false true true 1 5661dc12-2e8d-41a0-95da-9e051c82bb2e 1 1735 3383 14 20 1735 3383 14 20 1743.5 3393 false 0 Y component Y {y} component 2777297f-0146-421a-bcd1-c6362bddc956 false true true 1 111a1177-9e68-4142-9fc2-8e66f9591009 1 1735 3403 14 20 1735 3403 14 20 1743.5 3413 false 0 Z component Z {z} component b9cb7915-ccbd-43c7-8a56-44586a92dc1a false true true 0 1 1735 3423 14 20 1735 3423 14 20 1743.5 3433 false 0 Point Pt Point coordinate 70d2c140-a7a5-4a10-bf96-35781ea5e214 true true true 0 1779 3383 17 60 1779 3383 17 60 1789 3413 false 3581f42a-9592-4549-bd6b-1c0fc39d067b Point XYZ Point XYZ Pt Create a point from {xyz} coordinates. 616508fb-c762-4860-b8c4-f279c0577fe5 false true true longest_list 1733 3446 65 64 1752 3448 24 60 1764 3478 false X component X {x} component b0e9d331-6f53-4bbd-9005-f4f97b0565ef false true true 1 f3acc6ac-d857-4bb2-99b1-c73d557a556b 1 1735 3448 14 20 1735 3448 14 20 1743.5 3458 false 0 Y component Y {y} component 3c2cbf61-ce2f-40eb-a0b7-0b8e6435d4de false true true 1 1fa498ce-a4f0-4bc5-9138-6296080d203d 1 1735 3468 14 20 1735 3468 14 20 1743.5 3478 false 0 Z component Z {z} component 52c9bb62-2d87-4f65-ba1d-1c649a4aaa0d false true true 0 1 1735 3488 14 20 1735 3488 14 20 1743.5 3498 false 0 Point Pt Point coordinate 1cc968f1-ef5c-4c2b-bbc8-53afba401074 true true true 0 1779 3448 17 60 1779 3448 17 60 1789 3478 false ad483f40-dc72-40dc-844d-c9e462c7d19f Boolean Toggle true Boolean Toggle Toggle Boolean (true/false) toggle 32cf554f-deb7-42f3-9bd2-adc52953bcf5 false true true 0 1713 3362 87 20 1713 3362 87 20 1713.387 3362.831 false 59e0b89a-e487-49f8-bab8-b5bab16be14c Panel Panel A panel for custom notes and String values 29e2f746-517d-40f8-91e5-e5c0d7e346a0 false true true 0 Grasshopper-Excel (LIVE) true false false 0 0 false 255;255;255;255 255;0;0;0 1500 3551 301 20 1500 3551 301 20 1500.389 3551.658 false Microsoft Sans Serif 10 false false f19b8c33-dff2-4cc2-b95b-b4005ff3c10c Receiver true 1 Receiver Point Taken from A output of Write to Excel A data receiver object. 57877584-e661-4e77-9bfa-0e519bea4fc9 false true true 1 de0295c2-079e-4848-a2db-4bf9c0062ca6 1560 3321 240 20 1560 3321 240 20 1680.134 3331.117 false 1e9e08fc-c31e-49eb-a36c-90de5e62e5f5 VB Script If _Stream = True Then Dim oldCI As System.Globalization.CultureInfo = system.Threading.Thread.CurrentThread.CurrentCulture System.Threading.Thread.CurrentThread.CurrentCulture = New System.Globalization.CultureInfo("en-US") Dim i,j,k,m,n,p As Integer Dim objExcel As Object objExcel = System.Runtime.InteropServices.Marshal.GetActiveObject("Excel.Application") Dim newSheet, excelSheet, xlChart As Object excelSheet = objExcel.ActiveSheet xlChart = excelSheet.ChartObjects.Add(Chart_Position.X, Chart_Position.Y, Size.X, Size.Y).Chart excelSheet.Visible = False newSheet = objExcel.Sheets.Add() ' Add a chart object to the first worksheet With xlChart If Chart_Type.Count() > 0 Then .ChartType = Chart_Type(0) Else .ChartType = -4120 End If .SetSourceData(excelSheet.Range(excelSheet.Cells(CInt(Data_Origin.Y), CInt(Data_Origin.X)), excelSheet.Cells(CInt(Data_Bound.Y), CInt(Data_Bound.X)))) If ByColumn = True Then .PlotBy = 2 Else .PlotBy = 1 End If End With 'Change the formatting on the If Frame_Format.Count() > 0 Then With xlChart .ChartArea.Interior.Pattern = CInt(Frame_Format(0)) .ChartArea.Interior.Patterncolor = RGB(CInt(Frame_Format(1).r), CInt(Frame_Format(1).g), CInt(Frame_Format(1).b)) .ChartArea.Interior.Color = RGB(CInt(Frame_Format(2).r), CInt(Frame_Format(2).g), CInt(Frame_Format(2).b)) End With End If If Title = "" = False Then xlChart.HasTitle = True xlChart.ChartTitle.Text = CStr(Title) If Title_Format.count() > 0 Then With xlChart.ChartTitle .Font.Size = CInt(Title_Format(0)) .Font.Color = RGB(CInt(Title_Format(1).r), CInt(Title_Format(1).g), CInt(Title_Format(1).b)) .HorizontalAlignment = CInt(Title_Format(2)) .VerticalAlignment = CInt(Title_Format(3)) .Font.Bold = CBool(Title_Format(4)) .Font.Italic = CBool(Title_Format(5)) .Font.Underline = CBool(Title_Format(6)) .Font.Strikethrough = CBool(Title_Format(7)) .Font.Subscript = CBool(Title_Format(8)) .Font.Superscript = CBool(Title_Format(9)) End With End If End If ' create and format an optional marker k = 0 If Legend_Format.count() > 0 Then xlChart.HasLegend = True With xlChart.Legend For i = 1 To .LegendEntries.Count .LegendEntries(i).Font.Size = CInt(Legend_Format(0)) .LegendEntries(i).Font.Color = RGB(CInt(Legend_Format(1).r), CInt(Legend_Format(1).g), CInt(Legend_Format(1).b)) .LegendEntries(i).Font.Bold = CBool(Legend_Format(4)) .LegendEntries(i).Font.Italic = CBool(Legend_Format(5)) .LegendEntries(i).Font.Underline = CBool(Legend_Format(6)) .LegendEntries(i).Font.Strikethrough = CBool(Legend_Format(7)) .LegendEntries(i).Font.Subscript = CBool(Legend_Format(8)) .LegendEntries(i).Font.Superscript = CBool(Legend_Format(9)) Next End With Else xlChart.HasLegend = False End If If Chart_Type(2) = 1 Then For i = 1 To xlChart.SeriesCollection.count Step 1 With xlChart.SeriesCollection(i) If Data_Format.BranchCount() > 0 Then If Data_Format.BranchCount() = 1 Then .Interior.Color = RGB(Data_Format.branch(0).Item(1).r, Data_Format.branch(0).Item(1).G, Data_Format.branch(0).Item(1).B) Else .Interior.Color = RGB(Data_Format.branch(i).Item(1).r, Data_Format.branch(i).Item(1).G, Data_Format.branch(i).Item(1).B) End If End If End With Next End If ' Format each Data point If Chart_Type(2) = 0 Then For i = 1 To xlChart.SeriesCollection.count Step 1 With xlChart.SeriesCollection(i) If Marker_Format.BranchCount() > 0 And Chart_Type(1) = True Then .MarkerStyle = CInt(Marker_Format.branch(n).Item(0)) .smooth = False End If ''''''''''''''''''''''''''''''''' If Data_Format.BranchCount() > 0 Then If Data_Format.Branch(k).Item(3) = 1 Then .Format.ThreeD.Visible = False Else .Format.ThreeD.Visible = True .Format.ThreeD.BevelTopType = Data_Format.Branch(k).Item(3) .Format.ThreeD.BevelBottomType = Data_Format.Branch(k).Item(3) End If End If For j = 1 To .Points.Count ''''''''''''''''''''''''''''' If Data_Format.BranchCount() > 0 Then .Points(j).Interior.Color = RGB(Data_Format.branch(k).Item(1).r, Data_Format.branch(k).Item(1).G, Data_Format.branch(k).Item(1).B) .Points(j).Border.Color = RGB(Data_Format.branch(k).Item(2).r, Data_Format.branch(k).Item(2).G, Data_Format.branch(k).Item(2).B) If Data_Format.Branch(k).Item(4) = True Then .Points(j).HasDataLabel = True End If If Data_Format.BranchCount() = 1 Then k = 0 Else k = k + 1 End If End If ''''''''''''''''''''''''''''''' If Marker_Format.BranchCount() > 0 And CBool(Chart_Type(1)) = True Then .Points(j).MarkerForegroundColor = RGB(Marker_Format.branch(p).Item(1).r, Marker_Format.branch(p).Item(1).G, Marker_Format.branch(p).Item(1).B) .Points(j).MarkerBackgroundColor = RGB(Marker_Format.branch(p).Item(2).r, Marker_Format.branch(p).Item(2).G, Marker_Format.branch(p).Item(2).B) .Points(j).MarkerSize = CInt(Marker_Format.branch(p).Item(3)) If Marker_Format.BranchCount() = 1 Then p = 0 Else p = p + 1 End If End If '''''''''''''''''''''''''''' Next End With If Data_Format.BranchCount() = 1 Then m = 0 Else m = m + 1 End If If Marker_Format.BranchCount() = 1 And CBool(Chart_Type(1)) = True Then n = 0 Else n = n + 1 End If Next End If newSheet.activate newSheet.Delete() excelSheet.visible = True excelSheet.activate End If 0 VB Script Excel Chart (create) A VB.NET scriptable component 38519894-3463-4b4d-8347-39e2cb0b6b58 false true true longest_list 1957 3298 141 264 2047 3300 24 260 2059 3430 false 13 84fa917c-1ed8-4db3-8be1-7bdc4a6495a2 Variable Chart_Type Script Variable Chart_Type 1 true true 84fa917c-1ed8-4db3-8be1-7bdc4a6495a2 Variable Data_Start Script Variable Data_Start true true 84fa917c-1ed8-4db3-8be1-7bdc4a6495a2 Variable Data_End Script Variable Data_End true true 84fa917c-1ed8-4db3-8be1-7bdc4a6495a2 Variable ByColumn Script Variable ByColumn true true 84fa917c-1ed8-4db3-8be1-7bdc4a6495a2 Variable Chart_Origin Script Variable Chart_Origin true true 84fa917c-1ed8-4db3-8be1-7bdc4a6495a2 Variable Size Script Variable Size true true 84fa917c-1ed8-4db3-8be1-7bdc4a6495a2 Variable Title Script Variable Title true true 84fa917c-1ed8-4db3-8be1-7bdc4a6495a2 Variable Frame_Format Script Variable Frame_Format 1 true true 84fa917c-1ed8-4db3-8be1-7bdc4a6495a2 Variable Title_Format Script Variable Title_Format 1 true true 84fa917c-1ed8-4db3-8be1-7bdc4a6495a2 Variable Data_Format Script Variable Data_Format 2 true true 84fa917c-1ed8-4db3-8be1-7bdc4a6495a2 Variable Marker_Format Script Variable Marker_Format 2 true true 84fa917c-1ed8-4db3-8be1-7bdc4a6495a2 Variable Legend_Format Script Variable Legend_Format 1 true true 84fa917c-1ed8-4db3-8be1-7bdc4a6495a2 Variable _Stream Script Variable _Stream true true 2 3ede854e-c753-40eb-84cb-b48008f14fd4 Output Print, Reflect and Error streams true false 8ec86459-bf01-4409-baee-174d0d2b13d0 Result A Output parameter A true false Variable Chart_Type Chart_Type Script Variable Chart_Type 2ee366ee-5c13-4940-8518-ad85099c8668 true true true 1 1 75503cf2-610e-4975-a784-f236a4d08166 6a184b65-baa3-42d1-a548-3915b401de53 true true 1959 3300 85 20 1959 3300 85 20 2003 3310 false Variable Data_Start Data_Origin Script Variable Data_Start 966a2273-dba6-40b7-9825-7f93148e61af true true true 1 57877584-e661-4e77-9bfa-0e519bea4fc9 e1937b56-b1da-4c12-8bd8-e34ee81746ef true true 1959 3320 85 20 1959 3320 85 20 2003 3330 false Variable Data_End Data_Bound Script Variable Data_End 419de187-81a9-4526-8ea9-05863b45573b true true true 1 5c31e4ad-5b98-449b-9c7a-b038b3b7086b e1937b56-b1da-4c12-8bd8-e34ee81746ef true true 1959 3340 85 20 1959 3340 85 20 2003 3350 false Variable ByColumn ByColumn Script Variable ByColumn 648068ae-4737-48d5-948d-fd8dc47988b5 true true true 1 32cf554f-deb7-42f3-9bd2-adc52953bcf5 3cda2745-22ac-4244-9b04-97a5255fa60f true true 1959 3360 85 20 1959 3360 85 20 2003 3370 false Variable Chart_Origin Chart_Position Script Variable Chart_Origin afd74b82-dd33-4f29-a948-8b36f2e15d81 true true true 1 70d2c140-a7a5-4a10-bf96-35781ea5e214 e1937b56-b1da-4c12-8bd8-e34ee81746ef true true 1959 3380 85 20 1959 3380 85 20 2003 3390 false Variable Size Size Script Variable Size 31e5737e-0ef4-4a38-b398-926478041663 true true true 1 1cc968f1-ef5c-4c2b-bbc8-53afba401074 e1937b56-b1da-4c12-8bd8-e34ee81746ef true true 1959 3400 85 20 1959 3400 85 20 2003 3410 false Variable Title Title Script Variable Title 9120e04b-f8db-4b62-bdbd-36c7395fdbd4 true true true 1 29e2f746-517d-40f8-91e5-e5c0d7e346a0 abf1fd1b-dbe5-4be6-9832-d8dc105e207f true true 1959 3420 85 20 1959 3420 85 20 2003 3430 false Variable Frame_Format Frame_Format Script Variable Frame_Format b70ba00b-0fa3-4cc5-8aa2-1acfe1d9cbd6 true true true 1 1 673713d5-0050-4235-8ffe-27524fe34b82 6a184b65-baa3-42d1-a548-3915b401de53 true true 1959 3440 85 20 1959 3440 85 20 2003 3450 false Variable Title_Format Title_Format Script Variable Title_Format fd416b9d-e29d-4de0-9990-6e005afc7d67 true true true 1 1 5f5e079f-058c-4441-ac9c-7c5871951311 6a184b65-baa3-42d1-a548-3915b401de53 true true 1959 3460 85 20 1959 3460 85 20 2003 3470 false Variable Data_Format Data_Format Script Variable Data_Format 4f6d1723-727b-4618-ac7c-e9514fcbefed true true true 2 1 0d2cf2c4-0951-41e2-a21c-334b8a08bf48 6a184b65-baa3-42d1-a548-3915b401de53 true true 1959 3480 85 20 1959 3480 85 20 2003 3490 false Variable Marker_Format Marker_Format Script Variable Marker_Format fb82f59b-98fa-44fe-94e4-cf30d8ba2eb0 true true true 2 1 b257ee4e-6ec0-4a47-861b-98341dc1cdf3 6a184b65-baa3-42d1-a548-3915b401de53 true true 1959 3500 85 20 1959 3500 85 20 2003 3510 false Variable Legend_Format Legend_Format Script Variable Legend_Format 97d310b5-bf29-4779-8da9-d3d1a8c7827b true true true 1 1 35e3191d-724e-439c-8f02-c21b5b7feca7 6a184b65-baa3-42d1-a548-3915b401de53 true true 1959 3520 85 20 1959 3520 85 20 2003 3530 false Variable _Stream _Stream Script Variable _Stream 2d21845e-bfd0-4ef1-8117-bbf19be5880b true true true 1 0a26e000-d86e-44ac-afb0-c56a4ec231db 3cda2745-22ac-4244-9b04-97a5255fa60f true true 1959 3540 85 20 1959 3540 85 20 2003 3550 false Output out Print, Reflect and Error streams a3fe2d5f-9ae8-4b73-9a53-b52b22c060df false true true 0 2074 3300 22 130 2074 3300 22 130 2086.5 3365 false Result A A Output parameter A ebf62756-3bd5-4b8f-b090-d3f37601b824 true true true 0 2074 3430 22 130 2074 3430 22 130 2086.5 3495 false f19b8c33-dff2-4cc2-b95b-b4005ff3c10c Receiver true 1 Receiver Point Taken from B output of Write to Excel A data receiver object. 5c31e4ad-5b98-449b-9c7a-b038b3b7086b false true true 1 c890b1ea-5bb2-4192-9823-9da52fdee6c0 1560 3341 240 20 1560 3341 240 20 1680.344 3351.563 false 8ec86459-bf01-4409-baee-174d0d2b13d0 Data Data "XL Chart" Input Represents a collection of generic data 75503cf2-610e-4975-a784-f236a4d08166 false true true 2 1 dd74a8f6-3bd6-4111-aef9-e3363f4a3e98 1701 3300 99 20 1701 3300 99 20 1750.663 3310.729 false 8ec86459-bf01-4409-baee-174d0d2b13d0 Data Data Optional Input for "XL Frame" component Represents a collection of generic data 673713d5-0050-4235-8ffe-27524fe34b82 false true true 2 1 b392a86b-1c25-495a-afb6-2b6a5d165212 1569 3572 231 20 1569 3572 231 20 1684.857 3582.49 false 8ec86459-bf01-4409-baee-174d0d2b13d0 Data Data Optional Input for "XL Font" component Represents a collection of generic data 5f5e079f-058c-4441-ac9c-7c5871951311 false true true 2 1 a21a6039-fe46-420c-bb0a-446e1ccb1bd3 1577 3593 222 20 1577 3593 222 20 1688.63 3603.958 false 8ec86459-bf01-4409-baee-174d0d2b13d0 Data Data Optional Input for "XL Data" component Represents a collection of generic data 0d2cf2c4-0951-41e2-a21c-334b8a08bf48 false true true 2 1 98680d24-e0f2-46d5-8100-9a571ccabe27 1578 3614 222 20 1578 3614 222 20 1689.128 3624.771 false 8ec86459-bf01-4409-baee-174d0d2b13d0 Data Data Optional Input for "XL Mark" component Represents a collection of generic data b257ee4e-6ec0-4a47-861b-98341dc1cdf3 false true true 2 1 843ca577-ce7c-46c3-b642-a9bf4ea67b3d 1575 3635 224 20 1575 3635 224 20 1687.968 3645.133 false 8ec86459-bf01-4409-baee-174d0d2b13d0 Data Data Optional Input for "XL Font" component Represents a collection of generic data 35e3191d-724e-439c-8f02-c21b5b7feca7 false true true 2 1 a21a6039-fe46-420c-bb0a-446e1ccb1bd3 1578 3656 222 20 1578 3656 222 20 1689.44 3666.438 false ad483f40-dc72-40dc-844d-c9e462c7d19f Boolean Toggle false Boolean Toggle If Excel Sheet Contents and Grasshopper Inputs Correspond Boolean (true/false) toggle 0a26e000-d86e-44ac-afb0-c56a4ec231db false true true 0 1450 3700 349 20 1450 3700 349 20 1450.823 3700.318 false 59e0b89a-e487-49f8-bab8-b5bab16be14c Panel Panel A panel for custom notes and String values 7a9d8688-b5ee-48c9-b33e-dc7beffb897c false true true 0 UPDATE CHART FROM EXCEL/ GRASSHOPPER true true true 1 0 false 255;255;255;255 255;51;51;51 1199 3850 901 48 1199 3850 901 48 1199.633 3850.422 false Courier New 26.25 true false f80cfe18-9510-4b89-8301-8e58faf423bb Flatten Tree Flatten Tree Flatten Removes all branching information from a data tree. 36ad3cd2-784f-4d22-9452-9b85f6823412 true true true longest_list 1350 1550 64 59 1370 1552 24 55 1382 1580 false Data D Data stream to flatten 8c93dd29-6186-4680-9bd6-1d03a4acacde true true true 2 1 530fab57-778f-4b25-816e-e7b7bdfa2c87 1352 1552 15 27 1352 1552 15 27 1361 1565.75 false Path P Path of flattened tree 108cebfa-f697-42e6-9dc5-779b080557ca false true true 0 1 1352 1579 15 28 1352 1579 15 28 1361 1593.25 false {2} Data D Squished data d7784577-7cb0-4ad7-9ca0-ad57110ac9c8 true true true 0 1397 1552 15 55 1397 1552 15 55 1406 1579.5 false 59e0b89a-e487-49f8-bab8-b5bab16be14c Panel Panel Sample Data A panel for custom notes and String values 530fab57-778f-4b25-816e-e7b7bdfa2c87 false true true 0 10 20 30 40 50 false true false 1 0 false 255;0;0;0 255;255;0;90 1201 1564 82 100 1201 1564 82 100 1201.493 1564.772 false