Scripts for updating EGT & ENT Ranks, based on Template_EGT_ENT_RankChanges.xlsx

EGT_Insert tab - Insert into ELEMENT_GLOBAL_RANK (then update due to text > 254):
="insert into element_global_rank (ELEMENT_GLOBAL_ID, D_RANGE_EXTENT_ID, D_AOO_4KM_ID, D_AOO_GRID_SIZE_ID, D_NUMBER_EOS_ID, D_NUMBER_GOOD_EOS_ID,D_ENVIRO_SPECIFICITY_ID, D_THREAT_IMPACT_ASSIGNED_ID, VERSION_AUTHOR,REC_CREATE_USER) values ("&A2&","&B2&","&D2&","&F2&","&G2&","&I2&","&K2&","&M2&",'"&U2&"','Ticket_4648');"

="update element_global_rank set D_SHORT_TERM_TREND_ID="&O2&",D_RANK_METHOD_USED_ID="&Q2&",G_CALCULATED_RANK='"&R2&"',G_RANK_ASSIGNMENT_AUTHOR='"&S2&"',VERSION_DATE=to_date("&T2&",'MM/DD/YYYY'), REC_LAST_MOD_USER='Ticket_4648' where element_global_id="&A2&";"

EGT_Update tab:
="update element_global set g_rank='"&B2&"', rounded_g_rank='"&C2&"',g_rank_change_date="&D2&",g_rank_review_date=to_date("&E2&",'MM/DD/YYYY'), REC_LAST_MOD_USER='Ticket_4648' where element_global_id="&A2&";"

TAXON_GBL_RANK_CHANGES tab:
Insert into TAXON_GBL_RANK_CHANGES:
="insert into taxon_gbl_rank_changes (TAXON_GBL_RANK_CHANGES_ID,element_global_id,previous_rounded_g_rank,new_rounded_g_rank,d_rank_change_reason_id,g_rank_change_entry_date,g_rank_change_com) values (getnextseq('TAXON_GBL_RANK_CHANGES'),"&B2&",'"&C2&"','"&D2&"',"&E2&","&F2&",'"&G2&"');"

ENT_Update tab:
Update ELEMENT_NATIONAL:
="update element_national set n_rank='"&C2&"', ROUNDED_N_RANK='"&D2&"',BCD_STYLE_N_RANK='"&E2&"',N_RANK_CHANGE_DATE="&F2&",N_RANK_REVIEW_DATE="&G2&",REC_LAST_MOD_USER='Ticket_4648' where ELEMENT_NATIONAL_ID="&B2&";"