There are a number of different methods that can be used to place a plant schedule in a drawing. gCAD+ plant tools allow tagging of symbols and automatic generation of a list and schedules can be made by the use of for broad scale planting programs. There are however times when plant schedules prepared in Excel are needed in gCAD+ plans. This paper describes the steps to take if you want to put a plant list developed in Excel into a gCADPlus drawing.

Step 1. Export (print) the relevant zone in the spreadsheet from the Excel spreadsheet to a PDF file. (remember to set a print zone around the desired area)

List in Excel

Step 2. Save the file and convert to an image file such as PNG using an online conversion service such as the one shown below.

Convert

Here is the converted image as a PNG file in Photoshop. You could use other image editors such as GIMP to view the file. Once the list is in that form, it can be inserted into a gCAD+ drawing.

PNG file

Plant list

Step 3. Now insert the list into either model space or layout space using the Draw>Insert Raster tool.

Although the result may look a little grainy on the screen, the resultant PDF is of good quality. Click on the image below to download and view the PDF file.

Insert Raster

 

A (simpler) alternative to the above is to copy the Excel spreadsheet (onto the clipboard) and then paste into MS Paint and then save as jpg or png.  That saves a step in the process. We have not compared that approach to the method outlined above. We suspect that the quality of the pasted image may not be quite as good.

 

 

Place plant lists from Excel