{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Drawing List","Rename","Find and Replace","DwgProps","Import","Change","Log","Help","Config"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":11,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Drawing List","index":0,"n_rows":3,"n_cols":4,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["DRAWING LIST",null,null,"Object Type: Block Definition"]
["Path","Drawing Name",null,"Name Pattern: *"]
["T:\\2 Batch Change Tests\\2019\\Mechanical - Text and Tables.dwg",{"$f":"ExtractFileName(A3)","v":"Mechanical - Text and Tables.dwg"}]

{"sheet":"Rename","index":1,"n_rows":10,"n_cols":8,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
["  BATCH RENAME OBJECTS"]
["Object","Custom description","Find","Command\n(= Rename as default)","Prefix","New Name","Suffix","LOG"]
["1. Sample Rename object commands:",null,"Check if it is not yet added",null,null,null,null,"Rename 1-11 (1)"]
["Select all commands below then click Run to see the how it works !",null,null,null,null,null,null,"Rename 1-11 (2)"]
["These are normal Rename commands:",null,null,null,null,null,null,"Rename 1-11 (3)"]
["Block Definition",null,"AP01243-A1",null,null,"Title Block A1",null,"Rename 1-11 (4)"]
[null,null,null,null,null,null,null,"Rename 1-11 (5)"]
[null,null,null,null,null,null,null,"Rename 8-2 (1)"]
[null,null,null,null,null,null,null,"Rename 8-2 (2)"]
[null,null,null,null,null,null,null,"Rename 8-2 (3)"]

{"sheet":"Find and Replace","index":2,"n_rows":26,"n_cols":3,"rows_kept":26,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["BATCH FIND AND REPLACE\nFind and  Replace texts in Texts, Mtexts, Attributes, Dimensions and Tables  (case-senstive)"]
["Find Text (case sensitive)","Replace With","Log"]
["1. Select all following rows to test"]
["A","α"]
["B","β"]
["E","ε"]
["G","γ"]
["L","λ"]
["M","μ"]
["P","π"]
["N","η"]
["S","σ"]
["T","τ"]
["O","ω"]
["2. Undo above test's changes:"]
["α","A"]
["β","B"]
["ε","E"]
["γ","G"]
["λ","L"]
["μ","M"]
["π","P"]
["η","N"]
["σ","S"]
["τ","T"]
["ω","O"]

{"sheet":"DwgProps","index":3,"n_rows":25,"n_cols":4,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
["BATCH CHANGE DRAWING PROPERTIES"]
["Property Name","Find","New Value","Log"]
["1. Test these commands:"]
["Name","<> JTB*","\"JTB \" {}"]
["Title",null,"This is new Title"]
["Author",null,"This is new Author"]
["Comments",null,"This is new Comments"]
["Keywords",null,"This is new Keywords"]
["Subject",null,"This is new Subject"]
["Revision Number",null,"This is new Revision number"]
["Custom 1",null,"αβγδεζηθιλμνξοπρςστυφχψ"]
["Custom 2",null,"亜以右荏於下企九卦"]
["Custom 3",null,"☀☁☂☃☄★☆☇☈☉☊☋☎"]
["2. Clear above properties: got to put New Value = \"\". Otherwise, leaving empty will mean no new assignment"]
["Name","JTB*","\"JTB \" = \"\""]
["Title",null,"\"\""]
["Author",null,"\"\""]
["Comments",null,"\"\""]
["Keywords",null,"\"\""]
["Subject",null,"\"\""]
["Revision Number",null,"\"\""]
["Custom 1",null,"*Delete*"]
["Custom 2",null,"*Delete*"]
["Custom 3",null,"*Delete*"]
[null,null,"Note: Select rows then click Run Selected Commands."]

{"sheet":"Import","index":4,"n_rows":2,"n_cols":5,"rows_kept":2,"cut":false,"hidden":false,"merged":[[0,0,0,3]]}
["BATCH IMPORT\nImport Blocks, Layers, TextStyles, LineTypes, DimStyles, PageSetups from standard drawing to selected drawings."]
["Import","from source Drawing (dwg or dwt file)","Find\n(name filter pattern)",null,"LOG"]

{"sheet":"Change","index":5,"n_rows":26,"n_cols":7,"rows_kept":26,"cut":false,"hidden":false,"merged":[[24,3,24,4],[25,3,25,4]]}
["BATCH CHANGE PROPERTIES"]
["Object","Custom description","Commands (click object to expand the details)",null,null,null,"Log"]
["This spreadsheet will give you more accessibility to many properties of each object.",null,null,null,null,null,"Change 8-2 (1)"]
["Batch Change will drive through the drawing's database of named objects and graphical objects, at any nested level.",null,null,null,null,null,"Change 8-2 (2)"]
["I. NON-GRAPHICAL OBJECTS (OR NAMED OBJECTS)",null,null,null,null,null,"Change 8-2 (3)"]
["2. Change Attribute Definitions",null,null,null,null,null,"Change 8-2 (4)"]
["Attribute",null,"Property","Find Value","New Value",null,"Change 8-2 (5)"]
["Attribute",null,"Color",null,null,null,"Change 8-2 (6)"]
["Attribute",null,"Layer",null,null,null,"Change 8-2 (7)"]
["Attribute",null,"LineType",null,null,null,"Change 8-2 (8)"]
[null,null,"LineTypeScale"]
["3. Change inserted Attribute References",null,"Lineweight"]
["AttributeRef",null,"Material"]
["AttributeRef",null,"Thickness"]
["AttributeRef",null,"Visible"]
["AttributeRef",null,"Owner Name","TITLE BLOCK A1"]
[null,null,"Text"]
[null,null,"Height"]
[null,null,"Rotation"]
[null,null,"Width Factor"]
[null,null,"ObliqueAngle"]
[null,null,"StyleName"]
[null,null,"Tag","JOB1","TITLE_LINE_1"]
[null,null,"Prompt"]
[null,null,"Combination","Change only if all values match (AND)"]
[null,null,"Command"]

{"sheet":"Log","index":6,"n_rows":100,"n_cols":5,"rows_kept":100,"cut":false,"hidden":false,"merged":[]}
["JTB BATCH CHANGE LOG"]
["Saved working session"]
["Custom Description"]
["Drawings\n(Click to see Details)","Location","BackUp Location","Status"]
[null,null,null,null,"Change 8-2 (8)"]
[null,null,null,null,"Change 8-2 (7)"]
[null,null,null,null,"Change 8-2 (6)"]
[null,null,null,null,"Change 8-2 (5)"]
[null,null,null,null,"Change 8-2 (4)"]
[null,null,null,null,"Rename 8-2 (3)"]
[null,null,null,null,"Change 8-2 (3)"]
[null,null,null,null,"Rename 8-2 (2)"]
[null,null,null,null,"Change 8-2 (2)"]
[null,null,null,null,"Change 8-2 (1)"]
[null,null,null,null,"Rename 8-2 (1)"]
[null,null,null,null,"Rename 1-11 (11)"]
[null,null,null,null,"Rename 1-11 (10)"]
[null,null,null,null,"Rename 1-11 (9)"]
[null,null,null,null,"Rename 1-11 (8)"]
[null,null,null,null,"Rename 1-11 (7)"]
[null,null,null,null,"Rename 1-11 (6)"]
[null,null,null,null,"Rename 1-11 (5)"]
[null,null,null,null,"Rename 1-11 (4)"]
[null,null,null,null,"Rename 1-11 (3)"]
[null,null,null,null,"Rename 1-11 (2)"]
[null,null,null,null,"Rename 1-11 (1)"]
[null,null,null,null,"Change 4-7 (19)"]
[null,null,null,null,"Change 4-7 (18)"]
[null,null,null,null,"Change 4-7 (17)"]
[null,null,null,null,"Change 4-7 (16)"]
[null,null,null,null,"Change 4-7 (15)"]
[null,null,null,null,"Change 4-7 (14)"]
[null,null,null,null,"Change 4-7 (13)"]
[null,null,null,null,"Change 4-7 (12)"]
[null,null,null,null,"Change 4-7 (11)"]
[null,null,null,null,"Change 4-7 (10)"]
[null,null,null,null,"Change 4-7 (9)"]
[null,null,null,null,"Change 4-7 (8)"]
[null,null,null,null,"Change 4-7 (7)"]
[null,null,null,null,"Change 4-7 (6)"]
[null,null,null,null,"Change 4-7 (5)"]
[null,null,null,null,"Change 4-7 (4)"]
[null,null,null,null,"Change 4-7 (3)"]
[null,null,null,null,"Change 4-7 (2)"]
[null,null,null,null,"Change 4-7 (1)"]
[null,null,null,null,"Change 3-7 (6)"]
[null,null,null,null,"Change 3-7 (5)"]
[null,null,null,null,"Change 3-7 (4)"]
[null,null,null,null,"Change 3-7 (3)"]
[null,null,null,null,"Change 3-7 (2)"]
[null,null,null,null,"Change 3-7 (1)"]
[null,null,null,null,"Change 2-7 (10)"]
[null,null,null,null,"Change 2-7 (9)"]
[null,null,null,null,"Change 2-7 (8)"]
[null,null,null,null,"Change 2-7 (7)"]
[null,null,null,null,"Change 2-7 (6)"]
[null,null,null,null,"Change 2-7 (5)"]
[null,null,null,null,"Change 2-7 (4)"]
[null,null,null,null,"Import 2-7 (10)"]
[null,null,null,null,"Import 2-7 (9)"]
[null,null,null,null,"Import 2-7 (8)"]
[null,null,null,null,"Import 2-7 (7)"]
[null,null,null,null,"Import 2-7 (6)"]
[null,null,null,null,"Import 2-7 (5)"]
[null,null,null,null,"Import 2-7 (4)"]
[null,null,null,null,"Import 2-7 (3)"]
[null,null,null,null,"Import 2-7 (2)"]
[null,null,null,null,"Import 2-7 (1)"]
[null,null,null,null,"Change 2-7 (3)"]
[null,null,null,null,"Change 2-7 (2)"]
[null,null,null,null,"Change 2-7 (1)"]
[null,null,null,null,"Change 28-6 (29)"]
[null,null,null,null,"Change 28-6 (28)"]
[null,null,null,null,"Change 28-6 (27)"]
[null,null,null,null,"Change 28-6 (26)"]
[null,null,null,null,"Change 28-6 (25)"]
[null,null,null,null,"Change 28-6 (24)"]
[null,null,null,null,"Change 28-6 (23)"]
[null,null,null,null,"Change 28-6 (22)"]
[null,null,null,null,"Change 28-6 (21)"]
[null,null,null,null,"Change 28-6 (20)"]
[null,null,null,null,"Change 28-6 (19)"]
[null,null,null,null,"Change 28-6 (18)"]
[null,null,null,null,"Change 28-6 (17)"]
[null,null,null,null,"Change 28-6 (16)"]
[null,null,null,null,"Change 28-6 (15)"]
[null,null,null,null,"Change 28-6 (14)"]
[null,null,null,null,"Change 28-6 (13)"]
[null,null,null,null,"Change 28-6 (12)"]
[null,null,null,null,"Change 28-6 (11)"]
[null,null,null,null,"Change 28-6 (10)"]
[null,null,null,null,"Change 28-6 (9)"]
[null,null,null,null,"Change 28-6 (8)"]
[null,null,null,null,"Change 28-6 (7)"]
[null,null,null,null,"Change 28-6 (6)"]
[null,null,null,null,"Change 28-6 (5)"]
[null,null,null,null,"Change 28-6 (4)"]
[null,null,null,null,"Change 28-6 (3)"]
[null,null,null,null,"Change 28-6 (2)"]
[null,null,null,null,"Change 28-6 (1)"]

{"sheet":"Help","index":7,"n_rows":10,"n_cols":3,"rows_kept":10,"cut":false,"hidden":false,"merged":[[2,1,2,2],[1,1,1,2],[8,1,8,2],[9,1,9,2]]}
[]
[null,"JTB BATCH CHANGE VERSION 1.7.1"]
[null,"  "]
[null,"Help"]
[null,"Visit Our Product's Home Page","http://jtbworld.com/jtb-batch-change-for-autocad"]
[null,"Open Help Page"]
[null,"Contact Us","info@jtbworld.com"]
[null,"BackUp Folder Path:"]
[null,{"$f":"BackUpFolderPath()","v":"C:\\Users\\7cadDELL\\AppData\\Local\\Temp\\JTB Batch Change BackUp"}]
[null,"Note: Backing up drawings will take a lot of disk space. Default backup folder is in Temp folder, which often be emptied up by system cleaner applications. You should set up a custom backup location for long-term usage and paste the path to above cell. "]

{"sheet":"Config","index":8,"n_rows":157,"n_cols":5,"rows_kept":157,"cut":false,"hidden":true,"merged":[[82,0,82,3],[1,0,1,3]]}
["OBJECTS",null,null,"DESCRIPTION"]
["1. NON GRAPHICAL OBJECT"]
["Drawing",null,null,"You can add, modify or delete custom properties at DwgProps spreadsheet"]
["Name",null,null,"Name only. No folder path nor file extension","$"]
["Title",null,null,null,"$"]
["Author",null,null,null,"$"]
["Subject",null,null,null,"$"]
["Keywords",null,null,null,"$"]
["Revision Number",null,null,null,"$"]
["Comments",null,null,null,"$"]
["Command","Purge & Audit"]
["Block Definition"]
["Name",null,null,null,"$"]
["Explodable","True, False"]
["IsDynamicBlock","True, False","ReadOnly"]
["Units","Unitless, mm, inch, cm, m",null,"Change unit won't affect existing block references."]
["Command","Merge, Replace, Delete, Delete All Refs",null,"Delete command will available only if object is not referenced.\nReplace command will replace all inserted blocks with new block specified at Name's new value\nMerge = Replace + Delete original.\nDelete All Refs = Delete all inserted references then delete the definition."]
["Xref"]
["Name",null,null,"Change this won't affect the xref drawing's path","$"]
["FileName",null,null,"Non case-sensitive","$"]
["FolderPath",null,null,"Non case-sensitive","$"]
["Command","Unload, Reload, Detach"]
["Xref Reference",null,null,"IAcadExternalReference object. This is used in background only.","Do Not Show in Batch Modify "]
["Name"]
["Command"]
["Xref FolderPath",null,null,"IAcadExternalReference object. This is used in background only.","Do Not Show in Batch Modify "]
["Name"]
["Command"]
["Xref FileName",null,null,"IAcadExternalReference object. This is used in background only.","Do Not Show in Batch Modify "]
["Name"]
["Command"]
["Layout",null,null,null,"Do Not Show in Batch Modify "]
["Name",null,null,null,"$"]
["Command","Delete"]
["Layer"," "]
["Name",null,null,"See Xref Layer object if you want to change color, freeze layers in Xrefs","$"]
["Description",null,null,null,"$"]
["LayerOn","True, False"]
["Freeze","True, False"]
["Lock","True, False"]
["LineType",null,null,null,"$"]
["Lineweight","ByLayer,ByBlock,Default,0.00,0.05,0.09,0.13,0.15,0.18,0.20,0.25,0.30,0.35,0.40,0.50,0.53,0.60,0.70,0.80,0.90,1.00,1.06,1.20,1.40,1.58,2.00,2.11"]
["Color",null,null,"Value can be: \"By Layer\", \"By Block\", an integer as Acad Color Index or 3 integers of  (Red, Green, Blue)\n(For example: (255,100,50))"]
["Command","Merge, Replace, Delete, Delete All Refs",null,"Delete command will available only if Layer is empty.\nReplace command will change layer of all entities on this layer.\nMerge = Replace + Delete original.\nDelete All Refs = Delete all entities on this layer, then delete the layer's  definition."]
["Xref Layer"," "]
["Name",null,"ReadOnly","Xref Layer are layers in attached Xref drawings. You can changes its properties locally. It wont' affect the original drawing.","$"]
["Description",null,null,null,"$"]
["LayerOn","True, False"]
["Freeze","True, False"]
["LineType",null,null,null,"$"]
["Lineweight","ByLayer,ByBlock,Default,0.00,0.05,0.09,0.13,0.15,0.18,0.20,0.25,0.30,0.35,0.40,0.50,0.53,0.60,0.70,0.80,0.90,1.00,1.06,1.20,1.40,1.58,2.00,2.11"]
["Color",null,null,"Value can be: \"By Layer\", \"By Block\", an integer as Acad Color Index or 3 integers of  (Red, Green, Blue)\n(For example: (255,100,50))"]
["Command"]
["TextStyle"]
["Name",null,null,null,"$"]
["Font",null,null,"Should be the exactly Font name appear in AutoCAD Style dialog box","$"]
["BigFontFile",null,null,"Should be the exactly Font name appear in AutoCAD Style dialog box","$"]
["Width"]
["ObliqueAngle",null,null,"A value from -85 to 85 degrees"]
["Command","Merge, Replace, Delete, Delete All Refs",null,"+ Delete command will available only if style is unused.\n+ Replace command will change style of all reference entities\n+ Merge = Replace + Delete original.\n+ Delete all Refs = Delete all reference entities, then delete the definition."]
["DimStyle"]
["Name",null,null,null,"$"]
["Command","Merge, Replace, Delete, Delete All Refs",null,"+ Delete command will available only if style is unused.\n+ Replace command will change style of all reference entities\n+ Merge = Replace + Delete original.\n+ Delete all Refs = Delete all reference entities, then delete the definition."]
["LineType"]
["Name",null,null,null,"$"]
["Command","Merge, Replace, Delete, Delete All Refs",null,"+ Delete command will available only if style is unused.\n+ Replace command will change style of all reference entities\n+ Merge = Replace + Delete original.\n+ Delete all Refs = Delete all reference entities, then delete the definition."]
["UCS",null,null,null,"Do Not Show in Batch Modify"]
["Name",null,null,null,"$"]
["Command","Delete"]
["View",null,null,null,"Do Not Show in Batch Modify"]
["Name",null,null,null,"$"]
["Command","Delete"]
["Material",null,null,null,"Do Not Show in Batch Modify"]
["Name",null,null,null,"$"]
["Command","Merge, Replace, Delete, Delete All Refs",null,"+ Delete command will available only if style is unused.\n+ Replace command will change style of all reference entities\n+ Merge = Replace + Delete original.\n+ Delete all Refs = Delete all reference entities, then delete the definition."]
["Page Setup",null,null,"Including each Layout's Plot Configuration"]
["Name",null,null,"ReadOnly for [Layout] object","$"]
["Plot Device",null,null,"Name of PC3 or Printer name.\nSet this to \"None\" to clear saved specification.","$"]
["Command","Delete"]
["Plot Device",null,null,"This will change Plot Device of pagesetups and layouts","Do Not Show in Batch Modify"]
["Name",null,null,"Name of PC3 or Printer name.\nSet this to \"None\" to clear saved specification.","$"]
["Command"]
["GRAPHICAL OBJECTS (entities and nested entities)"]
["All Entities",null,null,"Shared common properties to all others"]
["Color",null,null,"Value can be: \"By Layer\", \"By Block\", an integer as Acad Color Index or 3 integers of  (Red, Green, Blue)\n(For example: (255,100,50))"]
["Layer",null,null,"Will add new layer if new layer's name doesn't exist.","$"]
["LineType",null,null,null,"$"]
["LineTypeScale"]
["Lineweight","ByLayer,ByBlock,Default,0.00,0.05,0.09,0.13,0.15,0.18,0.20,0.25,0.30,0.35,0.40,0.50,0.53,0.60,0.70,0.80,0.90,1.00,1.06,1.20,1.40,1.58,2.00,2.11"]
["Material",null,null,null,"$"]
["Thickness"]
["Visible","True, False"]
["Owner Name",null,"ReadOnly","Available values are: \"\"Model\"\", or \"\"Layout\"\" (for any Paper Space), or a block name where this object resides, or a Layout's name\nIf this is an Attribute Reference, Owner Name is the container block's name.","$"]
["Command","Flatten, Delete",null,"Command Flatten will turn all Z Coordinate to 0 and Normal Vector to WCS (0,0,1)"]
["Arc"," "]
["Radius"]
["Length",null,"ReadOnly","To delete Zero Arc, put Find Value = < 0.00001, then set Command to Delete"]
["Circle"]
["Radius"]
["Length",null,"ReadOnly"]
["Point"]
["Line"]
["Length",null,"ReadOnly","To delete Zero Arc, put Find Value = < 0.00001, then set Command to Delete"]
["Polyline",null,null,"Included Polyline, LWPolyline, 3D Poly"]
["Length",null,"ReadOnly","To delete Zero Arc, put Find Value = < 0.00001, then set Command to Delete"]
["Ellipse"]
["Spline"]
["Hatch"]
["PatternName",null,null,null,"$"]
["PatternScale"]
["PatternAngle"]
["Attribute"]
["Text",null,null,null,"$"]
["Height"]
["Rotation"]
["Width Factor"]
["ObliqueAngle",null,null,"A value from -85 to 85 degrees"]
["StyleName",null,null,null,"$"]
["Tag",null,null,"Tag should not contain space. Otherwise, spaces will be automatically converted to \"_\"","$"]
["Prompt",null,null,null,"$"]
["AttributeRef"]
["Text",null,null,null,"$"]
["Height"]
["Rotation"]
["Width Factor"]
["ObliqueAngle",null,null,"A value from -85 to 85 degrees"]
["StyleName",null,null,null,"$"]
["Tag",null,null,"Tag should not contain space. Otherwise, spaces will be automatically converted to \"_\"","$"]
["Text"]
["Text",null,null,null,"$"]
["Height"]
["Rotation"]
["Width Factor"]
["ObliqueAngle",null,null,"A value from -85 to 85 degrees"]
["StyleName",null,null,null,"$"]
["Mtext"]
["Text",null,null,null,"$"]
["Height"]
["Rotation"]
["StyleName",null,null,null,"$"]
["Dimension"]
["StyleName",null,null,null,"$"]
["ScaleFactor"]
["LinearScaleFactor"]
["Text",null,null,"This is the Text Override value.","$"]
["TextStyle",null,null,null,"$"]
["Leader"]
["StyleName",null,null,null,"$"]
["ScaleFactor"]
["Table"]
["StyleName",null,null,"(Table Style Name)","$"]
["TextStyle",null,null,"Cell's text style","$"]
["Text",null,null,"Cell's text","$"]
["BlockRef",null,null,"Including MInsertBlock, BlockReference"]
["Name",null,null,"Change block name to will replace all inserted block of Find Value with new inserted block of specified New Value.\n(Similar to Replace command in Block Defininition)","$"]
["Rotation",null,null,"In Degree"]
["Command","Uniformalize, ConvertToStatic, ConvertToAnony",null,"+ Uniformalize: set absolute values of X, Y, Z scales equal. This is helpful especially to fix \"inactive\" dynamic blocks.\n+ ConvertToStatic convert dynamic block to normal block.\n+ ConvertToAnony convert block to unnamed block."]