- Let the Good Times Spin is a record shop which you manage. You need to keep track of the inventory for insurance purposes. Each month, you total the value of each record in the Guide worksheet. Records released during 1964 or before are subject to a different insurance rates so you must total those separately. Write one VBA program that calculates the number of records and the total value of the records released after 1964 and the number of records and the total value of the records released in 1964 or before. Put those totals in the appropriate cells of the Inventory worksheet. Format your calculated values appropriately. Each month the Guide worksheet changes due to purchases and sales, the code you write should work no matter the number of records in the Guide worksheet. Also put a button on the Inventory worksheet to start the code. Put the calculation code in a module. Be sure to use the programming conventions we have used all semester. VJ MY CULUR SUNG RSUNG FICH YEAR GUIDE 1967 ###### 1967 $ 5.33 1967 # ### 1966 $ 5.80 1962 ###### 1962 #### ARTIST DON & GOODTIMES DON & GOODTIMES 4 DON & GOODTIMES DON & PETE DONA ALICE DONA ALICE DONAGGIO PINO - DONAGGIO PINO DONAHUE BILLY * DONAHUE TROY 12 DONALD DONAYS DONNEGAN LONNIE DONNER RAL * DONNYBROOKS 47 DONNYBROOKS DONOVAN DONOVAN 2 DONOVAN 2. DONOVAN 22 DONOVAN DONOVAN 4 DONOVAN DONOVAN 24 DONOVAN 2 DONOVAN 2DONOVAN DONOVAN DONOVAN DONOVAN DONOVAN DONOVAN 34 DONOVAN DONOVAN DONOVAN DONOVAN > DONOVAN DONOVAN DONOVAN 4 DONOVAN DONOVAN INVENTORY TITLE MY COLOR SONG SWEET SWEET MAMA WITH A GIRL LIKE YOU AND I'M CRYING AGAIN C'EST PAS PRUDENT REVEILLE-TOI IO MI DOMANDO SVEGLIATI AMORE OO DARLING LIVE YOUNG TIRITANDO DEVIL IN HIS HEART CUMBERLAND GAP YOU DON'T KNOW WHAT YOU'VE GOT TIME WILL TELL YOU'RE GONNA CRY ME AND MY WOMAN SEASON OF THE WITCH BALLAD OF GERALDINE BELATED FORGIVENESS PLEA CANDY MAN CATCH THE WIND CIRCUS OF SOUR COLOURS CUTTIN' OUT GOLDWATCH BLUES HEY GYP I'LL TRY FOR THE SUN JERSEY THURSDAY JOSIE KEEP ON TRUCKIN' OH DEED I DO RAMBLIN' BOY REMEMBER THE ALAMO SUMMER DAY REFLECTION SONG SUNNY GOODGE STREET TANGERINE PUPPET TO SING FOR YOU TO TRY FOR THE SUN HAR TRATTAISES TURQUOISE WAR DRAGS ON GUIDE Sheet3 1966 ###### 1966 $ 8.71 1963 ###### 1963 ###### 1963 ###### 1962 ###### 1957 # #### 1961 # ## 1966 ###### 1966 ###### 1963 ###### 1963 ## ### 1965 S 8.90 1965 ###### 1965 ###### 1965 $ 7.26 1965 ###### 1965 ###### 1965 $ 5.48 1965 ###### 1965 ###### 1965 ###### 1965 $ 7.56 1965 ## # # 1965 ###### 1965 ###### 1965 ###### 1965 $ 5.09 1965 ###### 1965 $ 7.23 1965 INNON 1965 S 5.79 1965 $ 8.64 1965 ###### 1965 $ 6.53 DIE F G H Monthly Inventory Count of Titles Total Value 3 1964 or Prior 4 1965 or Post Start Calculations! INVENTORY GUIDE Sheet3 - Let the Good Times Spin is a record shop which you manage. You need to keep track of the inventory for insurance purposes. Each month, you total the value of each record in the Guide worksheet. Records released during 1964 or before are subject to a different insurance rates so you must total those separately. Write one VBA program that calculates the number of records and the total value of the records released after 1964 and the number of records and the total value of the records released in 1964 or before. Put those totals in the appropriate cells of the Inventory worksheet. Format your calculated values appropriately. Each month the Guide worksheet changes due to purchases and sales, the code you write should work no matter the number of records in the Guide worksheet. Also put a button on the Inventory worksheet to start the code. Put the calculation code in a module. Be sure to use the programming conventions we have used all semester. VJ MY CULUR SUNG RSUNG FICH YEAR GUIDE 1967 ###### 1967 $ 5.33 1967 # ### 1966 $ 5.80 1962 ###### 1962 #### ARTIST DON & GOODTIMES DON & GOODTIMES 4 DON & GOODTIMES DON & PETE DONA ALICE DONA ALICE DONAGGIO PINO - DONAGGIO PINO DONAHUE BILLY * DONAHUE TROY 12 DONALD DONAYS DONNEGAN LONNIE DONNER RAL * DONNYBROOKS 47 DONNYBROOKS DONOVAN DONOVAN 2 DONOVAN 2. DONOVAN 22 DONOVAN DONOVAN 4 DONOVAN DONOVAN 24 DONOVAN 2 DONOVAN 2DONOVAN DONOVAN DONOVAN DONOVAN DONOVAN DONOVAN 34 DONOVAN DONOVAN DONOVAN DONOVAN > DONOVAN DONOVAN DONOVAN 4 DONOVAN DONOVAN INVENTORY TITLE MY COLOR SONG SWEET SWEET MAMA WITH A GIRL LIKE YOU AND I'M CRYING AGAIN C'EST PAS PRUDENT REVEILLE-TOI IO MI DOMANDO SVEGLIATI AMORE OO DARLING LIVE YOUNG TIRITANDO DEVIL IN HIS HEART CUMBERLAND GAP YOU DON'T KNOW WHAT YOU'VE GOT TIME WILL TELL YOU'RE GONNA CRY ME AND MY WOMAN SEASON OF THE WITCH BALLAD OF GERALDINE BELATED FORGIVENESS PLEA CANDY MAN CATCH THE WIND CIRCUS OF SOUR COLOURS CUTTIN' OUT GOLDWATCH BLUES HEY GYP I'LL TRY FOR THE SUN JERSEY THURSDAY JOSIE KEEP ON TRUCKIN' OH DEED I DO RAMBLIN' BOY REMEMBER THE ALAMO SUMMER DAY REFLECTION SONG SUNNY GOODGE STREET TANGERINE PUPPET TO SING FOR YOU TO TRY FOR THE SUN HAR TRATTAISES TURQUOISE WAR DRAGS ON GUIDE Sheet3 1966 ###### 1966 $ 8.71 1963 ###### 1963 ###### 1963 ###### 1962 ###### 1957 # #### 1961 # ## 1966 ###### 1966 ###### 1963 ###### 1963 ## ### 1965 S 8.90 1965 ###### 1965 ###### 1965 $ 7.26 1965 ###### 1965 ###### 1965 $ 5.48 1965 ###### 1965 ###### 1965 ###### 1965 $ 7.56 1965 ## # # 1965 ###### 1965 ###### 1965 ###### 1965 $ 5.09 1965 ###### 1965 $ 7.23 1965 INNON 1965 S 5.79 1965 $ 8.64 1965 ###### 1965 $ 6.53 DIE F G H Monthly Inventory Count of Titles Total Value 3 1964 or Prior 4 1965 or Post Start Calculations! INVENTORY GUIDE Sheet3