Power Tip: Creating An Excel Macro

{"3":{"id":3,"title":"Video Length","name":"video-length","checked_out":null,"checked_out_time":null,"note":"","state":1,"access":1,"created_time":"2023-12-15 00:00:00","created_user_id":48,"ordering":0,"language":"*","fieldparams":{"filter":"","maxlength":""},"params":{"hint":"","class":"","label_class":"","show_on":"","showon":"","render_class":"","value_render_class":"","showlabel":"1","label_render_class":"","display":"2","prefix":"","suffix":"","layout":"","display_readonly":"2"},"type":"text","default_value":"","context":"com_content.article","group_id":2,"label":"Video Length","description":"","required":0,"only_use_in_subform":0,"language_title":null,"language_image":null,"editor":null,"access_level":"Public","author_name":"Forrestt Williams","group_title":"videos","group_access":1,"group_state":1,"group_note":"","value":"","rawvalue":""},"5":{"id":5,"title":"Recommended By","name":"recommended-by","checked_out":null,"checked_out_time":null,"note":"","state":1,"access":1,"created_time":"2023-12-15 00:00:00","created_user_id":48,"ordering":0,"language":"*","fieldparams":{"filter":"","maxlength":""},"params":{"hint":"","class":"","label_class":"","show_on":"","showon":"","render_class":"","value_render_class":"","showlabel":"1","label_render_class":"","display":"2","prefix":"","suffix":"","layout":"","display_readonly":"2"},"type":"text","default_value":"","context":"com_content.article","group_id":4,"label":"Recommended By","description":"","required":0,"only_use_in_subform":0,"language_title":null,"language_image":null,"editor":null,"access_level":"Public","author_name":"Forrestt Williams","group_title":"powertips","group_access":1,"group_state":1,"group_note":"","value":"Jon Howard with PEC","rawvalue":"Jon Howard with PEC"},"7":{"id":7,"title":"Presented By","name":"presented-by","checked_out":null,"checked_out_time":null,"note":"","state":1,"access":1,"created_time":"2023-12-15 00:00:00","created_user_id":48,"ordering":0,"language":"*","fieldparams":{"filter":"","maxlength":""},"params":{"hint":"","class":"","label_class":"","show_on":"","showon":"","render_class":"","value_render_class":"","showlabel":"1","label_render_class":"","display":"2","prefix":"","suffix":"","layout":"","display_readonly":"2"},"type":"text","default_value":"","context":"com_content.article","group_id":2,"label":"Presented By","description":"","required":0,"only_use_in_subform":0,"language_title":null,"language_image":null,"editor":null,"access_level":"Public","author_name":"Forrestt Williams","group_title":"videos","group_access":1,"group_state":1,"group_note":"","value":"","rawvalue":""},"11":{"id":11,"title":"vimeo-id","name":"vimeo-id","checked_out":null,"checked_out_time":null,"note":"","state":1,"access":1,"created_time":"2023-12-15 00:00:00","created_user_id":48,"ordering":0,"language":"*","fieldparams":{"filter":"","maxlength":""},"params":{"hint":"","class":"","label_class":"","show_on":"","showon":"","render_class":"","value_render_class":"","showlabel":"1","label_render_class":"","display":"2","prefix":"","suffix":"","layout":"","display_readonly":"2"},"type":"text","default_value":"","context":"com_content.article","group_id":2,"label":"vimeo-id","description":"","required":0,"only_use_in_subform":0,"language_title":null,"language_image":null,"editor":null,"access_level":"Public","author_name":"Forrestt Williams","group_title":"videos","group_access":1,"group_state":1,"group_note":"","value":"","rawvalue":""},"13":{"id":13,"title":"VimeoID","name":"vimeoid","checked_out":null,"checked_out_time":null,"note":"","state":1,"access":1,"created_time":"2023-12-15 00:00:00","created_user_id":48,"ordering":0,"language":"*","fieldparams":{"filter":"","maxlength":""},"params":{"hint":"","class":"","label_class":"","show_on":"","showon":"","render_class":"","value_render_class":"","showlabel":"1","label_render_class":"","display":"2","prefix":"","suffix":"","layout":"","display_readonly":"2"},"type":"text","default_value":"","context":"com_content.article","group_id":4,"label":"VimeoID","description":"","required":0,"only_use_in_subform":0,"language_title":null,"language_image":null,"editor":null,"access_level":"Public","author_name":"Forrestt Williams","group_title":"powertips","group_access":1,"group_state":1,"group_note":"","value":"128697780","rawvalue":"128697780"},"26":{"id":26,"title":"Feature","name":"feature","checked_out":null,"checked_out_time":null,"note":"","state":1,"access":1,"created_time":"2023-12-15 00:00:00","created_user_id":48,"ordering":0,"language":"*","fieldparams":{"filter":"","maxlength":""},"params":{"hint":"","class":"","label_class":"","show_on":"","showon":"","render_class":"","value_render_class":"","showlabel":"1","label_render_class":"","display":"2","prefix":"","suffix":"","layout":"","display_readonly":"2"},"type":"text","default_value":"","context":"com_content.article","group_id":4,"label":"Feature","description":"","required":0,"only_use_in_subform":0,"language_title":null,"language_image":null,"editor":null,"access_level":"Public","author_name":"Forrestt Williams","group_title":"powertips","group_access":1,"group_state":1,"group_note":"","value":"Creating An Excel Macro","rawvalue":"Creating An Excel Macro"},"37":{"id":37,"title":"Registration","name":"registration","checked_out":null,"checked_out_time":null,"note":"","state":1,"access":1,"created_time":"2023-12-15 00:00:00","created_user_id":48,"ordering":0,"language":"*","fieldparams":{"filter":"","maxlength":""},"params":{"hint":"","class":"","label_class":"","show_on":"","showon":"","render_class":"","value_render_class":"","showlabel":"1","label_render_class":"","display":"2","prefix":"","suffix":"","layout":"","display_readonly":"2"},"type":"text","default_value":"","context":"com_content.article","group_id":2,"label":"Registration","description":"","required":0,"only_use_in_subform":0,"language_title":null,"language_image":null,"editor":null,"access_level":"Public","author_name":"Forrestt Williams","group_title":"videos","group_access":1,"group_state":1,"group_note":"","value":"","rawvalue":""},"41":{"id":41,"title":"app-vid-link","name":"app-vid-link","checked_out":null,"checked_out_time":null,"note":"","state":1,"access":1,"created_time":"2023-12-15 00:00:00","created_user_id":48,"ordering":0,"language":"*","fieldparams":{"filter":"","maxlength":""},"params":{"hint":"","class":"","label_class":"","show_on":"","showon":"","render_class":"","value_render_class":"","showlabel":"1","label_render_class":"","display":"2","prefix":"","suffix":"","layout":"","display_readonly":"2"},"type":"text","default_value":"","context":"com_content.article","group_id":4,"label":"app-vid-link","description":"","required":0,"only_use_in_subform":0,"language_title":null,"language_image":null,"editor":null,"access_level":"Public","author_name":"Forrestt Williams","group_title":"powertips","group_access":1,"group_state":1,"group_note":"","value":"","rawvalue":""},"43":{"id":43,"title":"App Video Link","name":"app-video-link","checked_out":null,"checked_out_time":null,"note":"","state":1,"access":1,"created_time":"2023-12-15 00:00:00","created_user_id":48,"ordering":0,"language":"*","fieldparams":{"filter":"","maxlength":""},"params":{"hint":"","class":"","label_class":"","show_on":"","showon":"","render_class":"","value_render_class":"","showlabel":"1","label_render_class":"","display":"2","prefix":"","suffix":"","layout":"","display_readonly":"2"},"type":"text","default_value":"","context":"com_content.article","group_id":2,"label":"App Video Link","description":"","required":0,"only_use_in_subform":0,"language_title":null,"language_image":null,"editor":null,"access_level":"Public","author_name":"Forrestt Williams","group_title":"videos","group_access":1,"group_state":1,"group_note":"","value":"","rawvalue":""},"46":{"id":46,"title":"ManualDate","name":"manualdate","checked_out":null,"checked_out_time":null,"note":"","state":1,"access":1,"created_time":"2023-12-15 00:00:00","created_user_id":48,"ordering":0,"language":"*","fieldparams":{"filter":"","maxlength":""},"params":{"hint":"","class":"","label_class":"","show_on":"","showon":"","render_class":"","value_render_class":"","showlabel":"1","label_render_class":"","display":"2","prefix":"","suffix":"","layout":"","display_readonly":"2"},"type":"text","default_value":"","context":"com_content.article","group_id":2,"label":"ManualDate","description":"","required":0,"only_use_in_subform":0,"language_title":null,"language_image":null,"editor":null,"access_level":"Public","author_name":"Forrestt Williams","group_title":"videos","group_access":1,"group_state":1,"group_note":"","value":"","rawvalue":""},"49":{"id":49,"title":"Manufacturer Video Type","name":"manufacturer-video-type","checked_out":null,"checked_out_time":null,"note":"","state":1,"access":1,"created_time":"2023-12-15 00:00:00","created_user_id":48,"ordering":0,"language":"*","fieldparams":{"filter":"","maxlength":""},"params":{"hint":"","class":"","label_class":"","show_on":"","showon":"","render_class":"","value_render_class":"","showlabel":"1","label_render_class":"","display":"2","prefix":"","suffix":"","layout":"","display_readonly":"2"},"type":"text","default_value":"","context":"com_content.article","group_id":2,"label":"Manufacturer Video Type","description":"","required":0,"only_use_in_subform":0,"language_title":null,"language_image":null,"editor":null,"access_level":"Public","author_name":"Forrestt Williams","group_title":"videos","group_access":1,"group_state":1,"group_note":"","value":"","rawvalue":""},"50":{"id":50,"title":"Manufacturer Video Company","name":"manufacturer-video-company","checked_out":null,"checked_out_time":null,"note":"","state":1,"access":1,"created_time":"2023-12-15 00:00:00","created_user_id":48,"ordering":0,"language":"*","fieldparams":{"filter":"","maxlength":""},"params":{"hint":"","class":"","label_class":"","show_on":"","showon":"","render_class":"","value_render_class":"","showlabel":"1","label_render_class":"","display":"2","prefix":"","suffix":"","layout":"","display_readonly":"2"},"type":"text","default_value":"","context":"com_content.article","group_id":2,"label":"Manufacturer Video Company","description":"","required":0,"only_use_in_subform":0,"language_title":null,"language_image":null,"editor":null,"access_level":"Public","author_name":"Forrestt Williams","group_title":"videos","group_access":1,"group_state":1,"group_note":"","value":"","rawvalue":""}}

Jon Howard of PEC needed to send his Plant Schedule to a spreadsheet to run calculations on a tree replacement plan. In order to do so, he needed a few extra columns to account for the caliper unit values, percentage of new trees, and other necessary data for running his equations. After this custom setup, the new schedule still needs to be formatted. All these steps could take quite a bit of time. That's why we suggest automating this type of process by creating a macro!

Want your suggested feature published?  Feel free to share it in our community forum.