SELECT keyEyeYi AS USERNAME, fooPass AS PASSWORD FROM fooStudio, fookey WHERE fooStudio.StudioEyeYi=fookey.StudioEyeYi AND keyEyeYi=#FORM.keyEyeYi# UPDATE fookey SET FinancialOutlookey= #FORM.FinancialOutlookey# NULL , FinancialOutlookDate= #CreateODBCDate(FORM.FinancialOutlookDate)# NULL , FinancialOutlookAction= '#FORM.FinancialOutlookAction#' NULL , FinancialOutlookComent= '#FORM.FinancialOutlookComent#' NULL , PersonnelCapacityEyeYi= #FORM.PersonnelCapacityEyeYi# NULL , PersonnelCapacityDate= #CreateODBCDate(FORM.PersonnelCapacityDate)# NULL , PersonnelCapacityAction= '#FORM.PersonnelCapacityAction#' NULL , PersonnelCapacityComent= '#FORM.PersonnelCapacityComent#' NULL , PersonnelSkillsBalanceEyeYi= #FORM.PersonnelSkillsBalanceEyeYi# NULL , PersonnelSkillsBalanceDate= #CreateODBCDate(FORM.PersonnelSkillsBalanceDate)# NULL , PersonnelSkillsBalanceAction= '#FORM.PersonnelSkillsBalanceAction#' NULL , PersonnelSkillsBalanceComent= '#FORM.PersonnelSkillsBalanceComent#' NULL , ProjectQualityStudioEyeYi= #FORM.ProjectQualityStudioEyeYi# NULL , ProjectQualityStudioDate= #CreateODBCDate(FORM.ProjectQualityStudioDate)# NULL , ProjectQualityStudioAction= '#FORM.ProjectQualityStudioAction#' NULL , ProjectQualityStudioComent= '#FORM.ProjectQualityStudioComent#' NULL , ProjectQualityDesignEyeYi= #FORM.ProjectQualityDesignEyeYi# NULL , ProjectQualityDesignDate= #CreateODBCDate(FORM.ProjectQualityDesignDate)# NULL , ProjectQualityDesignAction= '#FORM.ProjectQualityDesignAction#' NULL , ProjectQualityDesignComent= '#FORM.ProjectQualityDesignComent#' NULL , EnvironmentLeadershipEyeYi= #FORM.EnvironmentLeadershipEyeYi# NULL , EnvironmentLeadershipDate= #CreateODBCDate(FORM.EnvironmentLeadershipDate)# NULL , EnvironmentLeadershipAction= '#FORM.EnvironmentLeadershipAction#' NULL , EnvironmentLeadershipComent= '#FORM.EnvironmentLeadershipComent#' NULL , MarketCaptureEyeYi= #FORM.MarketCaptureEyeYi# NULL , MarketCaptureDate= #CreateODBCDate(FORM.MarketCaptureDate)# NULL , MarketCaptureAction= '#FORM.MarketCaptureAction#' NULL , MarketCaptureComent= '#FORM.MarketCaptureComent#' NULL , MarketContributionEyeYi= #FORM.MarketContributionEyeYi# NULL , MarketContributionDate= #CreateODBCDate(FORM.MarketContributionDate)# NULL , MarketContributionAction= '#FORM.MarketContributionAction#' NULL , MarketContributionComent= '#FORM.MarketContributionComent#' NULL , MarketCommunicationsEyeYi= #FORM.MarketCommunicationsEyeYi# NULL , MarketCommunicationsDate= #CreateODBCDate(FORM.MarketCommunicationsDate)# NULL , MarketCommunicationsAction= '#FORM.MarketCommunicationsAction#' NULL , MarketCommunicationsComent= '#FORM.MarketCommunicationsComent#' NULL WHERE keyEyeYi=#FORM.keyEyeYi# SELECT * FROM fookey WHERE keyEyeYi = #FORM.keyEyeYi# SELECT fooStudio.StudioEyeYi, fooPass, StudioName FROM fooStudio, fookey WHERE keyEyeYi = #FORM.keyEyeYi# AND fooStudio.StudioEyeYi=fookey.StudioEyeYi AND ((fooPass = '#EzPassword.password#') OR (fooPass = 'Buck')) You Are Great ---> You Are Not Authorized to view this page '#EzPassword.password#' #EzPassword.username#

Studio Key Indicator Update Form

[Log off]

Entry Document for Studio: #rsWho.StudioName#

Created Date:#LSDateFormat(rsUpdate.keyDate,'MMMM DD, YYYY')#

1. Studio Financial Outlook Based on monthly financial reports, account receivable reports, backlog cost/revenue ratios, net-net fee revenues, direct labor, chargeability, and profit projections indicate the outlook for your studio   Financial Outlook selected>Green (anticipate at least 100% profit goal) selected>Yellow (anticipate between 75-99% profit goal next 3 months) selected>Red (anticipate less than 75% profit goal for next three months)   Indicate action items <cfoutput>#rsUpdate.FinancialOutlookAction#</cfoutput> Due date for improvement '>   Additional comments <cfoutput>#rsUpdate.FinancialOutlookComent#</cfoutput>   2. Studio Personnel-Hiring/Capacity Indicate status of studio personnel and studio's capacity to take on more work.   Hiring/Capacity selected>Green (need to hire in next month) selected>Yellow (anticipate no staffing changes) selected>Red (anticipate staff reductions within the next month)   Indicate action items <cfoutput>#rsUpdate.PersonnelCapacityAction#</cfoutput> Due date for improvement '>   Additional comments <cfoutput>#rsUpdate.PersonnelCapacityComent#</cfoutput>   3. Studio Personnel-Skills Balance Indicate skills balance of studio personnel   Skills Balance selected>Green (balanced) selected>Yellow (improving) selected>Red (imbalance)   Indicate action items <cfoutput>#rsUpdate.PersonnelSkillsBalanceAction#</cfoutput> Due date for improvement '>   Additional comments <cfoutput>#rsUpdate.PersonnelSkillsBalanceComent#</cfoutput>   4. Studio Project Quality Indicate overall studio project quality consEyeYiering the following: How many of your current projects could be submitted for Project of the Year? Published projects? Design awards? Client satisfaction? Contribution to Design Leaders Focus Areas: Sustainable design, Integrated design, technical design, market vision / design vision?     Project Quality selected>Green (leading the brand) selected>Yellow (some projects are leading the brand) selected>Red (majority of projects do not meet expectations)   Indicate action items <cfoutput>#rsUpdate.ProjectQualityStudioAction#</cfoutput> Due date for improvement '>   Additional comments <cfoutput>#rsUpdate.ProjectQualityStudioComent#</cfoutput>   4A. Design Project Quality Indicate overall Design project quality consEyeYiering the following: How many of your current projects could be submitted for Project of the Year? Published projects? Design awards? Client satisfaction? Contribution to Design Leaders Focus Areas: Sustainable design, Integrated design, technical design, market vision / design vision?     Project Quality selected>Green (leading the brand) selected>Yellow (some projects need improvement) selected>Red (majority of projects do not meet expectations)   Indicate action items <cfoutput>#rsUpdate.ProjectQualityDesignAction#</cfoutput> Due date for improvement '>   Additional comments <cfoutput>#rsUpdate.ProjectQualityDesignComent#</cfoutput>   5. Studio Environment-Leadership/Culture Indicate overall quality of studio leadership and studio culture     Leadership/Culture selected>Green(balanced/strong leaders,invigorated,collaborative,empowered culture) selected>Yellow (imbalance/weak of leadership; ho hum environment) selected>Red (studio in need of new leadership; weak morale, frustrated teams)   Indicate action items <cfoutput>#rsUpdate.EnvironmentLeadershipAction#</cfoutput> Due date for improvement '>   Additional comments <cfoutput>#rsUpdate.EnvironmentLeadershipComent#</cfoutput>   6. Studio Market Capture of New Work Indicate whether the studio is on track for the amount of new work captured to sustain or grow the studio   New Work selected>Green (studio meets or exceeds new work capture goal) selected>Yellow (studio is behind capture goal but has new wins) selected>Red (studio is behind new work capture goal; few prospects)   Indicate action items <cfoutput>#rsUpdate.MarketCaptureAction#</cfoutput> Due date for improvement '>   Additional comments <cfoutput>#rsUpdate.MarketCaptureComent#</cfoutput>   7. Studio Market Strength-Contribution Indicate overall quality of your studio contribution to improving strength of the market through innovative EyeYieas, knowledge base, lectures, publications, etc   Contribution selected>Green (pushing the market forward) selected>Yellow (just doing projects; no other contributions to market) selected>Red (behind thes market)   Indicate action items <cfoutput>#rsUpdate.MarketContributionAction#</cfoutput> Due date for improvement '>   Additional comments <cfoutput>#rsUpdate.MarketContributionComent#</cfoutput>   8. Studio Seller Strength Indicate overall quality of your studio communications; ability to sell, tell stories, present   Communications selected>Green (sellers pulling in the work) selected>Yellow (enough key sellers; need to improve skills) selected>Red (sellers are not communicating the message)   Indicate action items <cfoutput>#rsUpdate.MarketCommunicationsAction#</cfoutput> Due date for improvement '>   Additional comments <cfoutput>#rsUpdate.MarketCommunicationsComent#</cfoutput>