{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["September 2024","Septmeber 2024 Judge Remarks","Instructions"],"not_rendered":{"charts":0,"images":4,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"September 2024","index":0,"n_rows":27,"n_cols":6,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
["C:\\Users\\Terri\\Documents\\MVPC\\N4C Rep\\Contest submissions 2024 2025\\September 2024\\"]
["C:\\Users\\Terri\\Documents\\MVPC\\N4C Rep\\Contest submissions 2024 2025\\2024-05-06 MVPC-Membership.xlsx"]
["File Name","Contest","Member Number","Member Name","Image Title","Award"]
["01,MJ397,DA,Little Violinist.jpg","Digital Altered Reality",397,"Ken Cheung","Little Violinist","Merit"]
["02,MJ521,DA,Colorful Quebec.jpg","Digital Altered Reality",521,"Craig  Peterson","Colorful Quebec"]
["01,MJ160,DB,Abandoned Ranch Building.jpg","Digital B&W",160,"Al  Kiecker","Abandoned Ranch Building","HM"]
["02,MJ397,DB,Becca.jpg","Digital B&W",397,"Ken Cheung","Becca"]
["03,MJ521,DB,Palisade Head in Monochrome.jpg","Digital B&W",521,"Craig  Peterson","Palisade Head in Monochrome"]
["04,MJ593,DB,Athens Acropolis.jpg","Digital B&W",593,"Jason  Diedering","Athens Acropolis"]
["01,MJ397,DJ,The Dig.jpg","Digital Journalism",397,"Ken Cheung","The Dig","3rd"]
["02,MJ593,DJ,plastic is pollution.jpg","Digital Journalism",593,"Jason  Diedering","plastic is pollution"]
["02,MJ593,DN,BWCA Morning.jpg","Digital Nature",593,"Jason  Diedering","BWCA Morning"]
["03,MJ624,DN,Sunset Mountain, Iceland.jpg","Digital Nature",624,"John  Corey","Sunset Mountain, Iceland"]
["01,MJ160,DP,Battery Point Lighthouse.jpg","Digital Pictorial",160,"Al  Kiecker","Battery Point Lighthouse"]
["02,MJ397,DP,Sitting Pretty.jpg","Digital Pictorial",397,"Ken Cheung","Sitting Pretty"]
["03,MJ521,DP,Tufts of Grass Hardness of Rock.jpg","Digital Pictorial",521,"Craig  Peterson","Tufts of Grass Hardness of Rock","Merit"]
["04,MJ593,DP,Rock in the water.jpg","Digital Pictorial",593,"Jason  Diedering","Rock in the water"]
["05,MJ624,DP,Sunset over Iceberg.jpg","Digital Pictorial",624,"John  Corey","Sunset over Iceberg"]
["01,MJ397,DT,Runway At Ketchikan, Alaska.jpg","Digital Travel",397,"Ken Cheung","Runway At Ketchikan, Alaska"]
["02,MJ521,DT,Mount Rushmore - Keystone SD.jpg","Digital Travel",521,"Craig  Peterson","Mount Rushmore - Keystone SD"]
["03,MJ593,DT,Copenhagen-Denmark.jpg","Digital Travel",593,"Jason  Diedering","Copenhagen-Denmark","HM"]
["04,MJ624,DT,Castel Saint Angelo, Rome, Italy.jpg","Digital Travel",624,"John  Corey","Castel Saint Angelo, Rome, Italy","Merit"]
[]
[]
[]
["Removed at Ken's request"]
["01,MJ397,DN,Ketchikan Eagle.jpg","Digital Nature",397,"Ken Cheung","Ketchikan Eagle"]

{"sheet":"Septmeber 2024 Judge Remarks","index":1,"n_rows":152,"n_cols":1,"rows_kept":152,"cut":false,"hidden":false,"merged":[]}
["Altered Reality"]
["Maker: Ken Cheung      Member Nbr: MJ397     Club: Minnesota Valley Photography Club"]
["Title: Little Violinist       Award (if any):        Merit"]
["Contest: DA      Date: 9/23/2024"]
["Judges Scores & Comments from:  Lincoln Camera Club"]
["Score: T = 6 + 8 + 8 = 22   C =  +  +  =    I =  +  +  =    TOTAL = 22"]
["Judges Comments: Kudos, well done! A fun photo that immediately draws me in to look more closely at the details"]
["- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - -- - -"]
["Maker: Craig Peterson      Member Nbr: MJ521     Club: Minnesota Valley Photography Club"]
["Title: Colorful Quebec       Award (if any):       "]
["Contest: DA      Date: 9/23/2024"]
["Judges Scores & Comments from:  Lincoln Camera Club"]
["Score: T = 6 + 6 + 8 = 20   C =  +  +  =    I =  +  +  =    TOTAL = 20"]
["Judges Comments: Typically looking down on rooftops is not very interesting and appealing. However, you have captured lots of angles,shapes, leading lines, and incorporated contrasting colors and textures"]
[]
["B&W"]
["- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - -- - -"]
["Maker: Al Kiecker Member Nbr: MJ160 Club: Minnesota Valley Photography Club"]
["Title: Abandoned Ranch Building Award (if any): HM"]
["Contest: DB Date: 10/17/2024"]
["Judges Scores &amp; Comments from: Des Moines Camera Club"]
["Score: T = 4 + 5 + 4 = 13 C = 5 + 5 + 5 = 15 I = 4 + 5 + 4 = 13 TOTAL = 41"]
["Judges Comments: I love the framing, the clouds, and focus of this photo. It almost looks as though it was sepia"]
["toned."]
["- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - -- - -"]
["Maker: Ken Cheung Member Nbr: MJ397 Club: Minnesota Valley Photography Club"]
["Title: Becca Award (if any):"]
["Contest: DB Date: 10/17/2024"]
["Judges Scores &amp; Comments from: Des Moines Camera Club"]
["Score: T = 4 + 4 + 5 = 13 C = 5 + 3 + 4 = 12 I = 5 + 3 + 4 = 12 TOTAL = 37"]
["Judges Comments: The exposure is very nice. I wish the subject&#39;s foot wasn&#39;t cut out of the frame."]
["- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - -- - -"]
["Maker: Craig Peterson Member Nbr: MJ521 Club: Minnesota Valley Photography Club"]
["Title: Palisade Head in Monochrome Award (if any):"]
["Contest: DB Date: 10/17/2024"]
["Judges Scores &amp; Comments from: Des Moines Camera Club"]
["Score: T = 3 + 3 + 3 = 9 C = 3 + 3 + 4 = 10 I = 3 + 4 + 3 = 10 TOTAL = 29"]
["Judges Comments: Not sure if because of B&amp;W, I feel it is a little blah. Maybe enhance of some the texture on the"]
["rocks."]
["- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - -- - -"]
["Maker: Jason Dierdering Member Nbr: MJ593 Club: Minnesota Valley Photography Club"]
["Title: Athens Acropolis Award (if any):"]
[]
["Contest: DB Date: 10/17/2024"]
["Judges Scores &amp; Comments from: Des Moines Camera Club"]
["Score: T = 3 + 3 + 4 = 10 C = 3 + 3 + 4 = 10 I = 3 + 4 + 4 = 11 TOTAL = 31"]
["Judges Comments: Great subject; the heads in the bottom of the photo distract from the main subject. Seems as"]
["though there is some angular distortion from the lens."]
[]
[]
["Journalism"]
["Maker: Ken Cheung      Member Nbr: MJ397     Club: Minnesota Valley Photography Club"]
["Title: The Dig       Award (if any):        3rd"]
["Contest: DJ      Date: Sep-2024"]
["Judges Scores & Comments from:  Dubuque Camera Club"]
["Score: T = 8 + 8 + 8 = 24   C =  +  +  =    I =  +  +  =    TOTAL = 24"]
["Judges Comments: Nice timing."]
["- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - -- - -"]
["Maker: Jason Dierdering      Member Nbr: MJ593     Club: Minnesota Valley Photography Club"]
["Title: plastic is pollution       Award (if any):       "]
["Contest: DJ      Date: Sep-2024"]
["Judges Scores & Comments from:  Dubuque Camera Club"]
["Score: T = 5 + 5 + 5 = 15   C =  +  +  =    I =  +  +  =    TOTAL = 15"]
["Judges Comments: Would have been nice to wait for the other people to move."]
[]
[]
["Nature"]
["Maker: Jason Dierdering Member Nbr: MJ593 Club: Minnesota Valley Photography Club"]
["Title: BWCA Morning Award (if any): HM"]
["Contest: DN Date: 9/17/2024"]
["Judges Scores &amp; Comments from: Wichita Area Camera Club"]
["Score: T = 9 + 8 + 9 = 26 C = + + = I = + + = TOTAL = 26"]
["Judges Comments: great shot...might have made your exposure just a bit longer to totally blur the water. Also,"]
["drop your exposure by a third, maybe 2/3rds of a stop. Take a bit of the brightness out of the sky. Still, like yor"]
["work"]
["- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - -- - -"]
["Maker: John Corey Member Nbr: MJ624 Club: Minnesota Valley Photography Club"]
["Title: Sunset Mountain, Iceland Award (if any): HM"]
["Contest: DN Date: 9/17/2024"]
["Judges Scores &amp; Comments from: Wichita Area Camera Club"]
["Score: T = 8 + 9 + 9 = 26 C = + + = I = + + = TOTAL = 26"]
["Judges Comments: well done. Like the framing of the mountains by the foreground...only thing I would have done"]
["different is lengthen your exposure just a bit, get a bit more blur on the water."]
[]
[]
[]
["Pictorial"]
["Maker: Al Kiecker      Member Nbr: MJ160     Club: Minnesota Valley Photography Club"]
["Title: Battery Point Lighthouse       Award (if any):       "]
["Contest: DP      Date: 9/16/2024"]
["Judges Scores & Comments from:  Western Wisconsin Photo Club"]
["Score: T = 5 + 7 + 7 = 19   C =  +  +  =    I =  +  +  =    TOTAL = 19"]
["Judges Comments: Nice pose.  Would be improved by bringing up shadows to lighten the man, especially his face.  Cropping would be improved with less sky and including his feet. This is a unique perspective of a familiar subject.  Consider some noise reduction in the sky."]
["- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - -- - -"]
["Maker: Ken Cheung      Member Nbr: MJ397     Club: Minnesota Valley Photography Club"]
["Title: Sitting Pretty       Award (if any):       "]
["Contest: DP      Date: 9/16/2024"]
["Judges Scores & Comments from:  Western Wisconsin Photo Club"]
["Score: T = 5 + 6 + 6 = 17   C =  +  +  =    I =  +  +  =    TOTAL = 17"]
["Judges Comments: Background is distracting.  Lovely young lady.    Lovely portrait but the background is busy and distracting."]
["- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - -- - -"]
["Maker: Craig Peterson      Member Nbr: MJ521     Club: Minnesota Valley Photography Club"]
["Title: Tufts of Grass Hardness of Rock       Award (if any):        Merit"]
["Contest: DP      Date: 9/16/2024"]
["Judges Scores & Comments from:  Western Wisconsin Photo Club"]
["Score: T = 8 + 8 + 5 = 21   C =  +  +  =    I =  +  +  =    TOTAL = 21"]
["Judges Comments: Title implies bird is flying or has wing movement.  It’s a lovely pose and sharp portrait showing nice feather detail. The reflection in the water is interesting, but the clump of grass was not a particularly strong center of interest."]
["- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - -- - -"]
["Maker: Jason Dierdering      Member Nbr: MJ593     Club: Minnesota Valley Photography Club"]
["Title: Rock in the water       Award (if any):       "]
["Contest: DP      Date: 9/16/2024"]
["Judges Scores & Comments from:  Western Wisconsin Photo Club"]
["Score: T = 1 + 5 + 1 = 7   C =  +  +  =    I =  +  +  =    TOTAL = 7"]
["Judges Comments: Enter it in the Black and White category  Per the rules, DP entries should be in color.  Monocrome images should be entered in DB."]
["- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - -- - -"]
["Maker: John Corey      Member Nbr: MJ624     Club: Minnesota Valley Photography Club"]
["Title: Sunset over Iceberg       Award (if any):       "]
["Contest: DP      Date: 9/16/2024"]
["Judges Scores & Comments from:  Western Wisconsin Photo Club"]
["Score: T = 8 + 5 + 7 = 20   C =  +  +  =    I =  +  +  =    TOTAL = 20"]
["Judges Comments:"]
["- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - -- - -"]
[]
["Travel"]
["Maker: Ken Cheung      Member Nbr: MJ397     Club: Minnesota Valley Photography Club"]
["Title: Runway At Ketchikan, Alaska       Award (if any):       "]
["Contest: DT      Date: 9/25/2024"]
["Judges Scores & Comments from:  Shutterbug Camera Club"]
["Score: T = 6 + 6 + 7 = 19   C =  +  +  =    I =  +  +  =    TOTAL = 19"]
["Judges Comments: Don't really get a sense of place"]
["- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - -- - -"]
["Maker: Craig Peterson      Member Nbr: MJ521     Club: Minnesota Valley Photography Club"]
["Title: Mount Rushmore - Keystone SD       Award (if any):       "]
["Contest: DT      Date: 9/25/2024"]
["Judges Scores & Comments from:  Shutterbug Camera Club"]
["Score: T = 6 + 6 + 6 = 18   C =  +  +  =    I =  +  +  =    TOTAL = 18"]
["Judges Comments: Don't really get a sense of place"]
["- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - -- - -"]
["Maker: Jason Dierdering      Member Nbr: MJ593     Club: Minnesota Valley Photography Club"]
["Title: Copenhagen-Denmark       Award (if any):        HM"]
["Contest: DT      Date: 9/25/2024"]
["Judges Scores & Comments from:  Shutterbug Camera Club"]
["Score: T = 8 + 8 + 8 = 24   C =  +  +  =    I =  +  +  =    TOTAL = 24"]
["Judges Comments:"]
["- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - -- - -"]
["Maker: John Corey      Member Nbr: MJ624     Club: Minnesota Valley Photography Club"]
["Title: Castel Saint Angelo, Rome, Italy       Award (if any):        Merit"]
["Contest: DT      Date: 9/25/2024"]
["Judges Scores & Comments from:  Shutterbug Camera Club"]
["Score: T = 7 + 7 + 8 = 22   C =  +  +  =    I =  +  +  =    TOTAL = 22"]
["Judges Comments:"]
["- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - - - - - - - - - - - - - - -- - - - - - - - - - -- - -"]

{"sheet":"Instructions","index":2,"n_rows":58,"n_cols":4,"rows_kept":58,"cut":false,"hidden":false,"merged":[[51,2,51,3]]}
["This instruction worksheet should always be the last worksheet in the workbook"]
["The macro will create a new monthly worksheet for the current N4C contest month"]
["The new worksheet will be placed immediately preceeding this instruction worksheet"]
["It is OK to delete work sheet tabs and re-do them"]
["Read all of the assumptions and verify them before attempting to create a monthly worksheet"]
[]
["Press the button below and follow the instructions"]
["You will be asked to locate the monthly folder for the current month of N4C images to be submitted (just select the folder - don't open it to view subfolders)"]
["You will then be asked to locate the MVPC Membership List excel file (see assumptions 1 and 4 and verify the list conforms)"]
["The macro will then create a  new worksheet for that month and poplulate it with every jpg image in the subfolders of the selected month"]
["The user will need to populate the awards, if any, once they become known"]
["Save this workbook file when complete"]
[]
[]
[]
[]
[]
[]
[null,"Example recommended folder structure"]
[]
[]
[]
["Monthly folder Recommendations."]
["It is recommended that the monthly folder contain a subfolder for each contest being entered"]
["It is recommended that the entries be placed in the respective subfolder"]
["It is recommended that the user manually add the N4C contest sequence number to each jpg file before using this tool to create the monthly worksheet.  This enables the user to determine the sequence of the images."]
[]
["Errors"]
["If the file  name does not conform to the anticipated format from N4C, an error may be listed or the image name may be the entire file name.  This\nalerts the user to examine the file name and make corrections. Then delete the created worksheet and rerun the macro to create a new sheet.\nThe MVPC image upload app will automatically check file size and image size and automatically create correct file names without the sequence numbers."]
["If the member number is not in the membership list file, an error notification will be provided so the user can take action"]
["If when you push the create monthly N4C worksheet button above, there is an error about the macro, go into excel preferences and enable macros"]
[]
["Assumptions"]
["1. Membership List excel workbook file contains the membership number in column A, first name in column B and last name in column C.\nIf this is not true, reorder the columns in the membership list file to make it true.  Otherwise code changes are required."]
["2. Image file names conform to the N4C file name requirement (2018).  If N4C changes file name requirements, the macro will have to be changed"]
["3. User has pre-pended the sequence number to the image file names prior to running this tool"]
["4.  Member list worksheet must be titled \"ACTIVE MEMBERS\""]
["5. Both the membership workbook and this workbook must be in the yearly folder for the macro to work"]
[]
[]
[]
[]
[]
["24 February 2019 - Version 1"]
["5 November 2019 - Version 2 updated error note to indicate the MVPC salon upload app does some pre-checking."]
["6 September 2021 - Version 3 added error note about enabling macros. Added summary of Visual Basic Files"]
["30 December 2023 - Version 4 added images for assumptions 1 and 4 to this file.  Added instructions at the top of this page."]
[]
["Visual basic code files required to run the macros to create the N4C monthly worksheets"]
["Locate these files in C:\\Users\\Rick\\Documents\\Computer\\Visual Basic Code"]
[]
["Name","Size","Last Modified"]
["AddNewWorksheet.bas","1 KB","2019-02-03","09:41:02"]
["DecodeFileName.bas","3 KB","2019-02-03","09:44:44"]
["GetFileNamesbyExt.bas","2 KB","2019-02-03","09:41:49"]
["GetRightFolder.bas","1 KB","2019-02-03","09:40:31"]
["MonthlyWkSheetCreate.bas","5 KB","2019-02-03","09:44:03"]
["WkSheetTableHeaders.bas","1 KB","2019-02-03","09:45:13"]