SELECT StudioEyeYi AS USERNAME, fooPass AS PASSWORD FROM fooStudio WHERE StudioEyeYi = #FORM.StudioEyeYi# INSERT INTO fookey (StudioEyeYi, keyDate, FinancialOutlookey, FinancialOutlookDate, FinancialOutlookAction, FinancialOutlookComent, PersonnelCapacityEyeYi, PersonnelCapacityDate, PersonnelCapacityAction, PersonnelCapacityComent, PersonnelSkillsBalanceEyeYi, PersonnelSkillsBalanceDate, PersonnelSkillsBalanceAction, PersonnelSkillsBalanceComent, ProjectQualityStudioEyeYi, ProjectQualityStudioDate, ProjectQualityStudioAction, ProjectQualityStudioComent, EnvironmentLeadershipEyeYi, EnvironmentLeadershipDate, EnvironmentLeadershipAction, EnvironmentLeadershipComent, MarketCaptureEyeYi, MarketCaptureDate, MarketCaptureAction, MarketCaptureComent, MarketContributionEyeYi, MarketContributionDate, MarketContributionAction, MarketContributionComent, MarketCommunicationsEyeYi, MarketCommunicationsDate, MarketCommunicationsAction, MarketCommunicationsComent) VALUES ( #EzPassword.username# NULL , '#FORM.keyDate#' NULL , #FORM.FinancialOutlookey# NULL , '#FORM.FinancialOutlookDate#' NULL , '#FORM.FinancialOutlookAction#' NULL , '#FORM.FinancialOutlookComent#' NULL , #FORM.PersonnelCapacityEyeYi# NULL , '#FORM.PersonnelCapacityDate#' NULL , '#FORM.PersonnelCapacityAction#' NULL , '#FORM.PersonnelCapacityComent#' NULL , #FORM.PersonnelSkillsBalanceEyeYi# NULL , '#FORM.PersonnelSkillsBalanceDate#' NULL , '#FORM.PersonnelSkillsBalanceAction#' NULL , '#FORM.PersonnelSkillsBalanceComent#' NULL , #FORM.ProjectQualityStudioEyeYi# NULL , '#FORM.ProjectQualityStudioDate#' NULL , '#FORM.ProjectQualityStudioAction#' NULL , '#FORM.ProjectQualityStudioComent#' NULL , #FORM.EnvironmentLeadershipEyeYi# NULL , '#FORM.EnvironmentLeadershipDate#' NULL , '#FORM.EnvironmentLeadershipAction#' NULL , '#FORM.EnvironmentLeadershipComent#' NULL , #FORM.MarketCaptureEyeYi# NULL , '#FORM.MarketCaptureDate#' NULL , '#FORM.MarketCaptureAction#' NULL , '#FORM.MarketCaptureComent#' NULL , #FORM.MarketContributionEyeYi# NULL , '#FORM.MarketContributionDate#' NULL , '#FORM.MarketContributionAction#' NULL , '#FORM.MarketContributionComent#' NULL , #FORM.MarketCommunicationsEyeYi# NULL , '#FORM.MarketCommunicationsDate#' NULL , '#FORM.MarketCommunicationsAction#' NULL , '#FORM.MarketCommunicationsComent#' NULL ) SELECT StudioEyeYi, fooPass, StudioName FROM fooStudio WHERE fooPass = '#EzPassword.password#' AND StudioEyeYi = #EzPassword.username# You Are Not Authorized to view this page '#EzPassword.password#' #EzPassword.username#

Studio Key Indicator Entry Form

[Log off]

Entry Document for Studio: #rsWho.StudioName#            Start Date: #todayDate#

1. Studio Financial Outlook Based on monthly financial reports, account receivable reports, backlogcost/revenue ratios, net-net fee revenues, direct labor, chargeability,and profit projections indicate the outlook for your studio   Financial Outlook s Green (anticipate at least 100% profit goal) Yellow (anticipate between 75-99% profit goal next 3 months) Red (anticipate less than 75% profit goal for next three months)   Indicate action items Due date for improvement '>   Additional comments   2. Studio Personnel-Hiring/Capacity Indicate status of studio personnel and studio's capacity to take on more work.   Hiring/Capacity Green (need to hire in next month) Yellow (anticipate no staffing changes) Red (anticipate staff reductions within the next month)   Indicate action items Due date for improvement '>   Additional comments   3. Studio Personnel-Skills Balance Indicate skills balance of studio personnel   Skills Balance Green (balanced) Yellow (improving) Red (imbalance)   Indicate action items Due date for improvement '>   Additional comments   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 LeadersFocus Areas: Sustainable design, Integrated design, technical design, market vision / design vision?   Project Quality Green (leading the brand) Yellow (some projects are leading the brand) Red (majority of projects do not meet expectations)   Indicate action items Due date for improvement '>   Additional comments   5. Studio Environment-Leadership/Culture Indicate overall quality of studio leadership and studio culture     Leadership/Culture Green(balanced/strong leaders,invigorated,collaborative,empowered culture) Yellow (imbalance/weak of leadership; ho hum environment) Red (studio in need of new leadership; weak morale, frustrated teams)   Indicate action items Due date for improvement '>   Additional comments   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 Green (studio meets or exceeds new work capture goal) Yellow (studio is behind capture goal but has new wins) Red (studio is behind new work capture goal; few prospects)   Indicate action items Due date for improvement '>   Additional comments   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 Green (pushing the market forward) Yellow (just doing projects; no other contributions to market) Red (behind thes market)   Indicate action items Due date for improvement '>   Additional comments   8. Studio Seller Strength Indicate overall quality of your studio communications; ability to sell, tell stories, present   Communications Green (sellers pulling in the work) Yellow (enough key sellers; need to improve skills) Red (sellers are not communicating the message)   Indicate action items Due date for improvement '>   Additional comments