{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Showcodes","PrintingData","importedData","Summary Info"],"not_rendered":{"charts":0,"images":0,"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":"Showcodes","index":0,"n_rows":320,"n_cols":2,"rows_kept":320,"cut":false,"hidden":false,"merged":[]}
[6002," Overhead "]
[6101," The Crucible "]
[6102," Gone Missing "]
[6103," Tartuffe by Moliere "]
[6104," Much Ado About Nothing - ETC/536 "]
[6105," Blood Wedding "]
[6106," As You Like It "]
[6107," New Play Festival "]
[6108," They Shoot Horses Dont They "]
[6109," Little Eyolf "]
[6110," BFA Senior Showcase "]
[6111," Oedipus (BYU ETC) "]
[6112," ETC 24 Hr Theatre Project "]
[6113," Academic Class-ETC "]
[6114," Merrily We Roll Along-TMA 536 "]
[6115," The Gondoliers - TMA 536 "]
[6116," Little Shop of Horrors "]
[6117," The Women of Lockerbie-TMA 536 "]
[6118," Comedy of Errors "]
[6119," Mysteries of Monster Grove "]
[6120," Yellow - TMA 536 "]
[6121," A Man For All Seasons, Mortal Fools Theatre Co.-cancelled "]
[6122," Elephant Man "]
[6124," A Second Birth "]
[6125," The Nightingale "]
[6126," For Dear Life "]
[6127," Final Cut Film Festival "]
[6128," Christmas Miracle of Jonathan Toomey "]
[6129," Metamorphoses "]
[6130," Stuck on the Edge "]
[6131," Hamlet "]
[6132," Charlie Brown "]
[6133," Tuesdays With Morrie "]
[6134," Berenice-Margetts #2 "]
[6135," Hundred Dresses "]
[6136," Legend of Sleepy Hollow "]
[6137," ACTF Competition, Stage Door "]
[6138," White Christmas "]
[6139," Romeo and Juliet "]
[6140," Merchant of Venice "]
[6141," Persuasion, Jane Austen "]
[6142," Anne Frank, The Diary of "]
[6143," Misc Theatre "]
[6144," Rohina Malik: Unveiled "]
[6145," Babe the Sheep Pig "]
[6146," Arabian Nights "]
[6147," Stage Door "]
[6148," Henry V "]
[6149," Love's Labor's Lost "]
[6150," Divine Comedy - TMA Class "]
[6151," Peter Pan "]
[6156," Academic Class 536 - Directing Workshop "]
[6157," Academic Class Misc "]
[6158," Academic Class (Mask,B-room,Prop) "]
[6159," Academic Class Other "]
[6160," Oedipus the King (Greek Theatre) "]
[6161," Holiday "]
[6162," Light in the Piazza "]
[6164," Women in the Wind "]
[6175," Servant of Two Masters "]
[6180," Phantom of the Opera "]
[6190," Wrinkle in Time, A "]
[6198," Every Man a Magnificence "]
[6201," Misc. Music/Oscarson Lectures "]
[6202," Group for New Music "]
[6203," Group for Experimental Music "]
[6204," Non-Ticketed Ensembles "]
[6205," Student Composers Showcase "]
[6206," University Chorale "]
[6207," Orpheus Winds "]
[6208," Choir Showcase "]
[6209," Orpheus Winds "]
[6210," Cosi fan tutte  "]
[6211," BYU Philharmonic Orchestra "]
[6212," BYU Singers and Concert Choir "]
[6213," Folk Music Ensemble "]
[6214," Chamber Orchestra "]
[6215," Symphony Orchestra "]
[6216," Evening of Percussion "]
[6217," Synthesis "]
[6218," Mens and Womens Chorus "]
[6219," Student Composers Showcase "]
[6220," Celebration of Christmas "]
[6221," Young Ambassadors "]
[6222," MDT Showcase-Broadway Revue "]
[6223," Winter Choirfest "]
[6224," MDT Senior Recital "]
[6225," Living Legends "]
[6226," Mktg Non-HFAC Music Events "]
[6227," Music Production-LL Costumes "]
[6228," Synthesis "]
[6229," Jazz Lab Bands "]
[6230," Folk Music Ensemble "]
[6231," BYU Philharmonic Orchestra "]
[6232," Gamelan Bintang Wahyu "]
[6233," BYU Singers and Concert Choir "]
[6234," University Chorale "]
[6235," University Orchestra & Strings "]
[6236," Living Legends "]
[6237," Singers and Concert Choir "]
[6238," Evening of Percussion/Gamelon "]
[6239," Vocal Point "]
[6240," BYU Philharmonic Orchestra  "]
[6241," Spring Opera-Pirates of Penzance "]
[6242," Songwriter Showcase "]
[6243," Young Ambassadors Costumes "]
[6244," Songwriters Showcase "]
[6245," Chamber Orchestra "]
[6246," Jazz Ensemble "]
[6247," Jazz Voices "]
[6248," Voice Juries - Madsen "]
[6249," University Orchestra & Strings "]
[6250," Concert Shell-SOM setup/take down "]
[6251," University Chorale "]
[6252," American Piano Quartet "]
[6253," Qd Up "]
[6254," Jazz Legacy Dixieland Band "]
[6255," Jazz Ensemble "]
[6256," Madsen Music Evening Events "]
[6257," BYU Singers A Tapestry of American Song "]
[6258," Opera Scenes "]
[6259," Young Artists of Voice "]
[6260," Jazz Ensemble & Jazz Voices "]
[6261," UT State Jr HS Band Festival "]
[6262," Evening of Concertos "]
[6263," Piano Juries SOM "]
[6264," Inv Songwriters Showcase "]
[6265," Jazz Combo Night  "]
[6266," Symphony Orchestra "]
[6267," Jazz Combo Night "]
[6268," Symphonic Band "]
[6269," OcTUBAfest "]
[6270," Symphonic Band "]
[6271," Instrumental Showcase "]
[6272," Casey at the Bat - MDT 2014 "]
[6273," Wind Symphony "]
[6274," Women's Choral Festival Concert "]
[6275," Jazz Voices "]
[6276," Mens Chorus "]
[6277," DeJong Music Events "]
[6278," Cougar Marching Band "]
[6279," Non Required Recitals "]
[6280," Symphonic Band "]
[6281," Sundance Trio Recording "]
[6282," Deseret Chamber #2 Trmbn Auth "]
[6283," Deseret Piano Trio "]
[6284," Utah Ambassadors of Music "]
[6285," University Bands "]
[6286," Synthesis - Jazz Festival "]
[6287," Jazz Voices "]
[6288," Jazz Legacy Dixieland "]
[6289," Jazz Showcase "]
[6290," Wind Symphony & Symphonic Band "]
[6291," Wind Symphony "]
[6292," Tuba Christmas "]
[6293," Jazz Lab Bands "]
[6294," Wind Symphony "]
[6295," Debussy/Ravel Celebration "]
[6296," Womens Chorus "]
[6297," Symphony Orchestra "]
[6298," Symphony Orchestra "]
[6299," Primrose Memorial Concert "]
[6301," Miscellaneous Dance "]
[6302," eviDANCE "]
[6303," Dance in Concert-The Thing About Love "]
[6304," Ballet in Concert-Sleeping Beauty "]
[6305," Youth Ballroom Showcase "]
[6306," DanceSport Championship "]
[6307," The Mitch Show: Dance Dept GA "]
[6308," DancEnsemble "]
[6309," Senior Dance Showcase "]
[6310," Faculty Choreography Showcase "]
[6311," Ballroom in Concert "]
[6312," Intl. Folk Dance Ensemble "]
[6313," Ballroom Dance Blackpool "]
[6314," dancEnsemble-Spring "]
[6315," dancEnsemble "]
[6316," Ballet Showcase "]
[6317," Youth Ballroom Dance "]
[6318," Crista Project - Costumes for dancEnsemble "]
[6319," Folk Dance Ensemble "]
[6320," Senior Dance Showcase "]
[6321," Senior Dance Showcase "]
[6322," Onward Alone "]
[6323," Dancesport-Summer 10 "]
[6324," Korean Dance Theatre "]
[6325," Living Legends Feb Concert "]
[6326," Modern Dance Shwcs Dancers Co "]
[6327," Onward Alone Distribution "]
[6328," Christmas Around the World-2012 "]
[6329," Ascendance - Costumes for World of Dance "]
[6330," Faculty Dance Works "]
[6331," CDT India Pre-Tour Concert "]
[6332," DanceSport US Natl Amateur "]
[6333," Dance Production "]
[6335," World Dance Showcase "]
[6336," CDT Winter Semester Show "]
[6337," Living Legends Mar Concert "]
[6338," Senior Dance Showcase "]
[6340," Dance Prod-Living Legends Costumes "]
[6401," Homecoming Spectacular "]
[6402," American Harp Society "]
[6403," BYUtv Legends "]
[6404," Utah Harp Association "]
[6405," BYUtv Dining with the Dean "]
[6406," BYUB - Broadcast "]
[6408," Visual Arts Awards Banquet "]
[6409," Womens Conference "]
[6410," Project Youth Program "]
[6411," C&W YA Singer Ent "]
[6412," Summerfest "]
[6413," C&W Evening of Dance-Come Dream With Me "]
[6414," BYU Basketball Documentary "]
[6415," UMEA "]
[6416," Adventssingen-German Dept. "]
[6417," High School Theatre Workshop "]
[6418," Convocation, Meetings (Dean's Office) "]
[6419," Stake Conferences/Events "]
[6420," Summer Devotionals "]
[6421," Hill Cumorah Pageant ADS "]
[6422," EFY - Musical Fireside "]
[6423," C&W Organ Workshop Summer "]
[6424," University Conference "]
[6425," C & W: Ballet Camp July "]
[6426," C&W: Vocal Beauty Bootcamp "]
[6427," NATS Concert "]
[6428," Visual Arts Student Meeting "]
[6429," Greek Tragedy Reader's Theatre "]
[6430," Winterfest PAM "]
[6431," Entrepreneurship Week-Rollins Center "]
[6432," TMA-Changing Studio A Battens "]
[6433," Latino Cultural Celebration-Conf Ctr "]
[6434," Wheatley Inst Lecture "]
[6435," TMA Student Awards Forum "]
[6436," TEDx - Marriott School of Business Event "]
[6437," Center for Service & Learning Asmbly "]
[6438," Dance Devotional "]
[6439," Law School Convocation "]
[6440," CES-ED Week General "]
[6441," Ed Week- Dallyn Bayles "]
[6442," Ed Week - Scarlet Pimpernel "]
[6443," Ed Week - Josh Wright "]
[6444," New Student Orientation "]
[6445," BYUB Studio C "]
[6446," American Guild of Organists "]
[6450," Ed Week - A Joyful Evening "]
[6451," C&W Adult Ballroom Dance Camp "]
[6453," MDT Acting Blocks "]
[6454," Writer's Block-BYUB "]
[6455," PAM Conference Center "]
[6456," Programming for HFAC Monitor "]
[6457," LDS Philanthropies "]
[6458," Piano Benches-Special Projects "]
[6459," Piano Shop Jobs "]
[6460," Sloan Speech Showcase "]
[6461," C&W Theatre Camp "]
[6462," Pres. Samuelson/BYU Tours "]
[6463," College of Nursing-60th Anniversary "]
[6464," KBYU Qd Up Taping "]
[6465," C&W High School Marching Band Camp "]
[6466," New York Piano Trio "]
[6467," BYU Center for Animation-Dreamgiver screening "]
[6468," C&W Children's Dance Works Concert "]
[6469," MOA Jobs "]
[6470," KBYU Recordings of HFAC Events "]
[6471," HS Band Festival "]
[6472," Cougarettes "]
[6473," Financial Services Photo Shoot "]
[6474," C&W BYU Choral Academy "]
[6475," Steve Ricks Recording 3/4 "]
[6477," Monte Belknap Filming "]
[6478," C&W Sharing Showcase "]
[6479," Double Reed Workshop "]
[6480," Peery Film Fellows "]
[6481," Utah Theatre Assoc. "]
[6482," Presidents Leadership Council "]
[6483," Student Athlete Fireside "]
[6484," Engineering College Mtg "]
[6485," KBYU Alex Boye Christmas Concert "]
[6487," Visual Arts Seminar "]
[6488," Jazz Legacy Festival "]
[6489," Jazz Festival Dixieland Concert "]
[6490," Jazz Festival Grand Concert-Synthesis "]
[6491," Jason Black Interview/Uni Comm "]
[6501," Folk Dance Tours "]
[6502," Young Ambassadors Tours "]
[6503," Ballroom Dance Co Tours "]
[6504," Contemporary Dance Theatre Tour "]
[6505," Living Legends Tours "]
[6506," Ballet Tours "]
[7000," General PAS "]
[7001," PAS Fall Budget "]
[7002," Peking Acrobats "]
[7003," Tanglewood Marionettes "]
[7004," Chamber Music Society of Lincoln "]
[7005," Mandy Patinkin "]
[7006," Puppet State Theatre: The Man Who Planted Trees "]
[7007," Beijing Dance Academy "]
[7008," Paul Taylor 2 Dance Co. "]
[7009," Martha Graham Dance Co "]
[7010," Tenebrae (England) "]
[7011," Aulos Ensemble "]
[7012," Chanticleer "]
[7013," Circo Aereo "]
[7014," LA Theatre Works: The Rivalry "]
[7015," Aquila Theatre Co-Cyrano De Bergerac "]
[7017," Nrityagram Dance Ensemble "]
[7018," Natalie MacMaster "]
[7019," Chinese Opera Orchestra of Shanghai "]
[7020," Choo-Choo Soul with Genevieve "]
[7021," Red Star Red Army Chorus & Dance "]
[7022," Dawn Upshaw "]
[7024," Seussical "]
[7025," Simon Shaheen "]
[7026," Savion Glover "]
[7027," Utah Symphony "]
[7028," Theatreworks USA: Fancy Nancy & other Storybooks "]
[7029," UT Symphony and UT Symphony Chorus "]
[7030," Utah Symphony "]
[7031," Lea Salonga "]

{"sheet":"PrintingData","index":1,"n_rows":40,"n_cols":26,"rows_kept":40,"cut":false,"hidden":false,"merged":[]}
["Category","Type","Date","Num","Name","Memo","Split","Amount"]
["Newspaper","General Journal","2013-03-08","Number","6258","Reclass Feb Daily Herald statement","6160  Adv-Gen (Newspaper)",50,null,"Programs","Credit Card Charge","2013-03-01","Number","6298","Program - Symphonic Orchestra","2200-CC Copy Center Charges",150,null,"Posters","Credit Card Charge","2013-03-01","Number","7015","Aquila Theater Company","2200-CC Copy Center Charges",25]
["Newspaper","General Journal","2013-03-08","Number","6148","Reclass Feb Daily Herald statement","6160  Adv-Gen (Newspaper)",150,null,"Programs","Credit Card Charge","2013-03-01","Number","6294","Program - Wind Symphony","2200-CC Copy Center Charges",15,null,"Posters","Credit Card Charge","2013-03-01","Number","6262","Evening of Piano Concertos 42x28","2200-CC Copy Center Charges",50]
["Newspaper","General Journal","2013-03-08","Number","6222","Reclass Feb Daily Herald statement","6160  Adv-Gen (Newspaper)",50,null,"Programs","Credit Card Charge","2013-03-01","Number","6239","Programs-Vocal Point 8 Page","2200-CC Copy Center Charges",400,null,"Posters","Credit Card Charge","2013-03-01","Number","6260","Jazz Fliers","2200-CC Copy Center Charges",10]
["Newspaper","General Journal","2013-03-08","Number","6221","Reclass Feb Daily Herald statement","6160  Adv-Gen (Newspaper)",50,null,"Programs","Credit Card Charge","2013-03-01","Number","6294","Family Program","2200-CC Copy Center Charges",100,null,"Posters","Credit Card Charge","2013-03-01","Number","7015","Aquila quarter sheets FINAL","2200-CC Copy Center Charges",75]
["Newspaper","General Journal","2013-03-08","Number","7011","Reclass Feb Daily Herald statement","6160  Adv-Gen (Newspaper)",50,null,"Programs","Credit Card Charge","2013-03-01","Number","6226","UVU Singers","2200-CC Copy Center Charges",100,null,"Posters","Credit Card Charge","2013-03-01","Number","6308","Buckaroo Pin","2200-CC Copy Center Charges",1]
["Newspaper","General Journal","2013-03-08","Number","6304","Reclass Feb Daily Herald statement","6160  Adv-Gen (Newspaper)",100,null,"Programs","Credit Card Charge","2013-03-01","Number","6256","Charles Driscol Recital Program","2200-CC Copy Center Charges",5,null,"Posters","Credit Card Charge","2013-03-01","Number","6276","Sway Men's Chorus","2200-CC Copy Center Charges",50]
["Newspaper","General Journal","2013-03-08","Number","6325","Reclass Feb Daily Herald statement","6160  Adv-Gen (Newspaper)",100,null,"Programs","Credit Card Charge","2013-03-04","Number","6102","Playbill - Gone Missing","2200-CC Copy Center Charges",1000,null,"Posters","Credit Card Charge","2013-03-01","Number","7027","Utah Symphony","2200-CC Copy Center Charges",50]
["Newspaper","General Journal","2013-03-08","Number","6280","Reclass Feb Daily Herald statement","6160  Adv-Gen (Newspaper)",50,null,"Programs","Credit Card Charge","2013-03-05","Number","6277","Program - Evening of Concertos - Philharmonic","2200-CC Copy Center Charges",150,null,"Posters","Credit Card Charge","2013-03-04","Number","6213","Quartersheets 1up","2200-CC Copy Center Charges",10]
["Newspaper","General Journal","2013-03-08","Number","6298","Reclass Feb Daily Herald statement","6160  Adv-Gen (Newspaper)",50,null,"Programs","Credit Card Charge","2013-03-06","Number","6230","Program - Folk Music Ensemble","2200-CC Copy Center Charges",150,null,"Posters","Credit Card Charge","2013-03-08","Number","6204","Harp Ensemble Poster Quarter Sheets","2200-CC Copy Center Charges",10]
["Newspaper","General Journal","2013-03-08","Number","6294","Reclass Feb Daily Herald statement","6160  Adv-Gen (Newspaper)",50,null,"Programs","Credit Card Charge","2013-03-07","Number","6299","Primrose Program","2200-CC Copy Center Charges",50,null,"Posters","Credit Card Charge","2013-03-08","Number","6256","Dvid Lang Flyers","2200-CC Copy Center Charges",10]
["Newspaper","General Journal","2013-03-08","Number","6307","Reclass Feb Daily Herald statement","6160  Adv-Gen (Newspaper)",50,null,"Programs","Credit Card Charge","2013-03-11","Number","7015","Program - Cyrano De Bergerac","2200-CC Copy Center Charges",1000,null,"Posters","Credit Card Charge","2013-03-11","Number","6325","March Living Legends Fliers","2200-CC Copy Center Charges",25]
["Newspaper","General Journal","2013-03-08","Number","6330","Reclass Feb Daily Herald statement","6160  Adv-Gen (Newspaper)",50,null,"Programs","Credit Card Charge","2013-03-18","Number","6256","Bush Hansen","2200-CC Copy Center Charges",25,null,"Posters","Credit Card Charge","2013-03-11","Number","7018","Natalie MacMaster","2200-CC Copy Center Charges",50]
["Newspaper","General Journal","2013-03-08","Number","6240","Reclass Feb Daily Herald statement","6160  Adv-Gen (Newspaper)",10,null,"Programs","Credit Card Charge","2013-03-19","Number","6255","Jazz Ensemble 2013","2200-CC Copy Center Charges",50,null,"Posters","Credit Card Charge","2013-03-12","Number","6296","Quarter Sheets - Women's Chorus","2200-CC Copy Center Charges",300]
["Newspaper","General Journal","2013-03-08","Number","7015","Reclass Feb Daily Herald statement","6160  Adv-Gen (Newspaper)",10,null,"Programs","Credit Card Charge","2013-03-19","Number","6255","Jazz Ensemble Poster","2200-CC Copy Center Charges",50,null,"Posters","Credit Card Charge","2013-03-13","Number","6308","Buckaroo Flyers","2200-CC Copy Center Charges",50]
["Newspaper","General Journal","2013-03-08","Number","6260","Reclass Feb Daily Herald statement","6160  Adv-Gen (Newspaper)",20,null,"Programs","Credit Card Charge","2013-03-20","Number","6204","WW Chamber Night","2200-CC Copy Center Charges",25,null,"Posters","Credit Card Charge","2013-03-14","Number","6204","Flute Choir Quartersheets","2200-CC Copy Center Charges",5]
["Newspaper","General Journal","2013-03-08","Number","6239","Reclass Feb Daily Herald statement","6160  Adv-Gen (Newspaper)",20,null,"Programs","Credit Card Charge","2013-03-21","Number","6276","Mens Chorus Program 4 page","2200-CC Copy Center Charges",1000,null,"Posters","Credit Card Charge","2013-03-15","Number","6266","Symphony Orchestra April 28X42","2200-CC Copy Center Charges",50]
["Newspaper","General Journal","2013-03-08","Number","6286","Reclass Feb Daily Herald statement","6160  Adv-Gen (Newspaper)",20,null,"Programs","Credit Card Charge","2013-03-22","Number","6308","Program-Buckaroo danceEnsemble","2200-CC Copy Center Charges",500,null,"Posters","Credit Card Charge","2013-03-19","Number","6204","Trombone Night Quarter Sheet 4-up","2200-CC Copy Center Charges",5]
["Newspaper","General Journal","2013-03-08","Number","6230","Reclass Feb Daily Herald statement","6160  Adv-Gen (Newspaper)",10,null,"Programs","Credit Card Charge","2013-03-22","Number","7018","Program - Natalie MacMaster","2200-CC Copy Center Charges",800,null,"Posters","Credit Card Charge","2013-03-19","Number","6233","Singers Concert Choir bookmarks - Yellow","2200-CC Copy Center Charges",25]
["Newspaper","General Journal","2013-03-08","Number","7030","Reclass Feb Daily Herald statement","6160  Adv-Gen (Newspaper)",50,null,"Programs","Credit Card Charge","2013-03-22","Number","6245","Program - Chamber Orchestra","2200-CC Copy Center Charges",10,null,"Posters","Credit Card Charge","2013-03-19","Number","6233","Singers Concert Choir Bookmarks - Yellow","2200-CC Copy Center Charges",25]
["Newspaper","Credit Card Charge","2013-03-14",null,"Daily",null,"2200-BK Bookstore Charges",0,null,"Programs","Credit Card Charge","2013-03-25","Number","6240","Easter Family Music Program","2200-CC Copy Center Charges",500,null,"Posters","General Journal","2013-03-20","Number","6255","Reclass print and mail C017372 Jazz Ensemble 2013 3/19/13","-SPLIT-",50]
["Newspaper","General Journal","2013-03-21","Number","6102","Reclass Feb Daily Universe payment","-SPLIT-",115,null,"Programs","Credit Card Charge","2013-03-25","Number","6175","Playbill - The Servant of Two Masters","2200-CC Copy Center Charges",2000,null,"Posters","General Journal","2013-03-20","Number","6255","Reclass print and mail C017370 Jazz Ensemble 2013 3/19/13","6160-64  Copy-Fly/Poster(color)",50]
["Newspaper","General Journal","2013-03-21","Number","6258","Reclass Feb Daily Universe payment","6160  Adv-Gen (Newspaper)",50,null,"Programs","Credit Card Charge","2013-03-26","Number","6204","Flute, Sax & Trombone Programs","2200-CC Copy Center Charges",50,null,"Posters","Credit Card Charge","2013-03-22","Number","6320","qtrsheets for Senior Dance Showcase 3","2200-CC Copy Center Charges",10]
["Newspaper","General Journal","2013-03-21","Number","6148","Reclass Feb Daily Universe payment","6160  Adv-Gen (Newspaper)",75,null,"Programs","Credit Card Charge","2013-03-26","Number","6256","Program","2200-CC Copy Center Charges",50,null,"Posters","Credit Card Charge","2013-03-22","Number","7011","Aquilia Theatre Company Poster","2200-CC Copy Center Charges",50]
["Newspaper","General Journal","2013-03-21","Number","6222","Reclass Feb Daily Universe payment","6160  Adv-Gen (Newspaper)",50,null,"Programs","Credit Card Charge","2013-03-26","Number","6204","harp ensemble program","2200-CC Copy Center Charges",10,null,"Posters","Credit Card Charge","2013-03-22","Number","6296","Quarter Sheets - Women's Chorus","2200-CC Copy Center Charges",300]
["Newspaper","General Journal","2013-03-21","Number","6221","Reclass Feb Daily Universe payment","6160  Adv-Gen (Newspaper)",50,null,"Programs","Credit Card Charge","2013-03-26","Number","6304","Playbill-Sleeping Beauty","2200-CC Copy Center Charges",2000,null,"Posters","Credit Card Charge","2013-03-26","Number","6238","Precussion Sheets","2200-CC Copy Center Charges",25]
["Newspaper","General Journal","2013-03-21","Number","7011","Reclass Feb Daily Universe payment","6160  Adv-Gen (Newspaper)",25,null,null,null,null,null,null,null,null,null,null,"Posters","Credit Card Charge","2013-03-27","Number","6273","Wind Symphony","2200-CC Copy Center Charges",50]
["Newspaper","General Journal","2013-03-21","Number","6304","Reclass Feb Daily Universe payment","6160  Adv-Gen (Newspaper)",50,null,null,null,null,null,null,null,null,null,null,"Posters","Credit Card Charge","2013-04-01","Number","6228","synthesis fliers","2200-CC Copy Center Charges",50]
["Newspaper","General Journal","2013-03-21","Number","6223","Reclass Feb Daily Universe payment","6160  Adv-Gen (Newspaper)",12,null,null,null,null,null,null,null,null,null,null,"Posters","Credit Card Charge","2013-04-01","Number","6231","Philharmonic Fliers","2200-CC Copy Center Charges",25]
["Newspaper","General Journal","2013-03-21","Number","6270","Reclass Feb Daily Universe payment","6160  Adv-Gen (Newspaper)",40,null,null,null,null,null,null,null,null,null,null,"Posters","Credit Card Charge","2013-04-01","Number","6273","Wind Symphony 2 Quarter Sheets","2200-CC Copy Center Charges",10]
["Newspaper","General Journal","2013-03-21","Number","6266","Reclass Feb Daily Universe payment","6160  Adv-Gen (Newspaper)",30,null,null,null,null,null,null,null,null,null,null,"Posters","Credit Card Charge","2013-04-01","Number","6204","Jazz Lab Band Quarter","2200-CC Copy Center Charges",10]
["Newspaper","General Journal","2013-03-21","Number","6337","Reclass Feb Daily Universe payment","6160  Adv-Gen (Newspaper)",50]
["Newspaper","General Journal","2013-03-21","Number","6294","Reclass Feb Daily Universe payment","6160  Adv-Gen (Newspaper)",25]
["Newspaper","General Journal","2013-03-21","Number","6240","Reclass Feb Daily Universe payment","6160  Adv-Gen (Newspaper)",10]
["Newspaper","General Journal","2013-03-21","Number","6307","Reclass Feb Daily Universe payment","6160  Adv-Gen (Newspaper)",30]
["Newspaper","General Journal","2013-03-21","Number","6330","Reclass Feb Daily Universe payment","6160  Adv-Gen (Newspaper)",25]
["Newspaper","General Journal","2013-03-21","Number","6239","Reclass Feb Daily Universe payment","6160  Adv-Gen (Newspaper)",20]
["Newspaper","General Journal","2013-03-21","Number","6286","Reclass Feb Daily Universe payment","6160  Adv-Gen (Newspaper)",20]
["Newspaper","General Journal","2013-03-21","Number","6230","Reclass Feb Daily Universe payment","6160  Adv-Gen (Newspaper)",10]
["Newspaper","General Journal","2013-03-21","Number","7030","Reclass Feb Daily Universe payment","6160  Adv-Gen (Newspaper)",30]

{"sheet":"importedData","index":2,"n_rows":67,"n_cols":9,"rows_kept":67,"cut":false,"hidden":false,"merged":[]}
["byuid","showid","date","hours","othours","memo","curwage","Labor Cost"]
["Student 1",6162,"2013-04-10",2,0,"poster",10,{"$f":"G2*D2+G2*E2*1.5","v":20},{"$f":"SUMIF($A$2:$A$6,A2,$D$2:$D$6)","v":10}]
["Student 1",6162,"2013-04-09",3,0,"poster research",10,{"$f":"G3*D3+G3*E3*1.5","v":30},{"$f":"SUMIF($A$2:$A$6,A3,$D$2:$D$6)","v":10}]
["Student 1",6162,"2013-04-08",2,0,"poster research and design",10,20,{"$f":"SUMIF($A$2:$A$6,A4,$D$2:$D$6)","v":10}]
["Student 1",6162,"2013-04-05",2,0,"research",10,20,{"$f":"SUMIF($A$2:$A$6,A5,$D$2:$D$6)","v":10}]
["Student 1",6162,"2013-04-04",1,0,"research/strategy",10,10,{"$f":"SUMIF($A$2:$A$6,A6,$D$2:$D$6)","v":10}]
[null,"6162 Total",null,{"$f":"SUM(D2:D6)","v":10},null,null,null,{"$f":"SUM(H2:H6)","v":100},{"$f":"SUMPRODUCT(1/COUNTIF(I$2:I$6,I$2:I$6))","v":1}]
["Student 2",6190,"2013-04-10",2,0,"Meeting with dramaturg and planning study guide",9,{"$f":"G8*D8+G8*E8*1.5","v":18},{"$f":"SUMIF($A$8:$A$12,A8,$D$8:$D$12)","v":5}]
["Student 2",6190,"2013-04-08",3,0,"Program template and gathering information",9,27,{"$f":"SUMIF($A$8:$A$12,A9,$D$8:$D$12)","v":5}]
["Student 1",6190,"2013-04-05",2,0,"quarter sheets and bookmarks",10,20,{"$f":"SUMIF($A$8:$A$12,A10,$D$8:$D$12)","v":3.5}]
["Student 1",6190,"2013-04-04",1,0,"bookmarks",10,10,{"$f":"SUMIF($A$8:$A$12,A11,$D$8:$D$12)","v":3.5}]
["Student 1",6190,"2013-04-01",0.5,0,"bookmarks",10,5,{"$f":"SUMIF($A$8:$A$12,A12,$D$8:$D$12)","v":3.5}]
[null,"6190 Total",null,{"$f":"SUM(D8:D12)","v":8.5},null,null,null,{"$f":"SUM(H8:H12)","v":80},{"$f":"SUMPRODUCT(1/COUNTIF(I$8:I$12,I$8:I$12))","v":1.9999999999999998}]
["Student 3",6202,"2013-04-01",3.8,0,"poster and online art",11,{"$f":"G14*D14+G14*E14*1.5","v":41.8},{"$f":"SUMIF($A$14:$A$14,A14,$D$14:$D$14)","v":3.8}]
[null,"6202 Total",null,{"$f":"SUM(D14)","v":3.8},null,null,null,{"$f":"SUM(H14)","v":41.8},{"$f":"SUMPRODUCT(1/COUNTIF(I$14:I$14,I$14:I$14))","v":1}]
["Student 3",6204,"2013-04-05",4,0,"Poster for May performance",11,{"$f":"G16*D16+G16*E16*1.5","v":44},{"$f":"SUMIF($A$16:$A$17,A16,$D$16:$D$17)","v":7}]
["Student 3",6204,"2013-04-04",3,0,"Poster for May performance",11,33,{"$f":"SUMIF($A$16:$A$17,A17,$D$16:$D$17)","v":7}]
[null,"6204 Total",null,{"$f":"SUM(D16:D17)","v":7},null,null,null,{"$f":"SUM(H16:H17)","v":77},{"$f":"SUMPRODUCT(1/COUNTIF(I$16:I$17,I$16:I$17))","v":1}]
["Student 1",6206,"2013-04-02",0.5,0,"facebook page",10,{"$f":"G19*D19+G19*E19*1.5","v":5},{"$f":"SUMIF($A$19:$A$21,A19,$D$19:$D$21)","v":4.5}]
["Student 1",6206,"2013-04-02",2,0,"poster",10,20,{"$f":"SUMIF($A$19:$A$21,A20,$D$19:$D$21)","v":4.5}]
["Student 1",6206,"2013-04-01",2,0,"poster",10,20,{"$f":"SUMIF($A$19:$A$21,A21,$D$19:$D$21)","v":4.5}]
[null,"6206 Total",null,{"$f":"SUM(D19:D21)","v":4.5},null,null,null,{"$f":"SUM(H19:H21)","v":45},{"$f":"SUMPRODUCT(1/COUNTIF(I$19:I$21,I$19:I$21))","v":1}]
["Student 1",6249,"2013-04-02",0.5,0,"facebook page",10,{"$f":"G23*D23+G23*E23*1.5","v":5},{"$f":"SUMIF($A$23:$A$24,A23,$D$23:$D$24)","v":1.5}]
["Student 1",6249,"2013-04-01",1,0,"online art",10,10,{"$f":"SUMIF($A$23:$A$24,A24,$D$23:$D$24)","v":1.5}]
[null,"6249 Total",null,{"$f":"SUM(D23:D24)","v":1.5},null,null,null,{"$f":"SUM(H23:H24)","v":15},{"$f":"SUMPRODUCT(1/COUNTIF(I$23:I$24,I$23:I$24))","v":1}]
["Student 1",6285,"2013-04-03",1.5,0,"quarter sheets and poster",10,{"$f":"G26*D26+G26*E26*1.5","v":15},{"$f":"SUMIF($A$26:$A$26,A26,$D$26:$D$26)","v":1.5}]
[null,"6285 Total",null,{"$f":"D26","v":1.5},null,null,null,{"$f":"SUM(H26)","v":15},{"$f":"SUMPRODUCT(1/COUNTIF(I$26:I$26,I$26:I$26))","v":1}]
["Student 1",6287,"2013-04-03",1,0,"poster",10,{"$f":"G28*D28+G28*E28*1.5","v":10},{"$f":"SUMIF($A$28:$A$28,A28,$D$28:$D$28)","v":1}]
[null,"6287 Total",null,1,null,null,null,{"$f":"SUM(H28)","v":10},{"$f":"SUMPRODUCT(1/COUNTIF(I$28:I$28,I$28:I$28))","v":1}]
["Student 2",6148,"2013-04-05",3,0,"Finalizing program for printing",9,{"$f":"G30*D30+G30*E30*1.5","v":27},{"$f":"SUMIF($A$30:$A$33,A30,$D$30:$D$33)","v":13}]
["Student 2",6148,"2013-04-04",2,0,"Program design",9,18,{"$f":"SUMIF($A$30:$A$33,A31,$D$30:$D$33)","v":13}]
["Student 2",6148,"2013-04-03",4,0,"Program design",9,36,{"$f":"SUMIF($A$30:$A$33,A32,$D$30:$D$33)","v":13}]
["Student 2",6148,"2013-04-01",4,0,"Program Design",9,36,{"$f":"SUMIF($A$30:$A$33,A33,$D$30:$D$33)","v":13}]
[null,"6148 Total",null,{"$f":"SUM(D30:D33)","v":13},null,null,null,{"$f":"SUM(H30:H33)","v":117},{"$f":"SUMPRODUCT(1/COUNTIF(I$30:I$33,I$30:I$33))","v":1}]
["Student 1",6222,"2013-04-10",2,0,"poster",10,{"$f":"G35*D35+G35*E35*1.5","v":20},{"$f":"SUMIF($A$2:$A$6,A35,$D$2:$D$6)","v":10}]
["Student 1",6222,"2013-04-09",3,0,"poster research",10,{"$f":"G36*D36+G36*E36*1.5","v":30},{"$f":"SUMIF($A$2:$A$6,A36,$D$2:$D$6)","v":10}]
["Student 1",6222,"2013-04-08",2,0,"poster research and design",10,20,{"$f":"SUMIF($A$2:$A$6,A37,$D$2:$D$6)","v":10}]
["Student 1",6222,"2013-04-05",2,0,"research",10,20,{"$f":"SUMIF($A$2:$A$6,A38,$D$2:$D$6)","v":10}]
["Student 1",6222,"2013-04-04",1,0,"research/strategy",10,10,{"$f":"SUMIF($A$2:$A$6,A39,$D$2:$D$6)","v":10}]
[null,"6222 Total",null,{"$f":"SUM(D35:D39)","v":10},null,null,null,{"$f":"SUM(H35:H39)","v":100},{"$f":"SUMPRODUCT(1/COUNTIF(I$2:I$6,I$2:I$6))","v":1}]
["Student 2",6256,"2013-04-10",2,0,"Meeting with dramaturg and planning study guide",9,{"$f":"G41*D41+G41*E41*1.5","v":18},{"$f":"SUMIF($A$8:$A$12,A41,$D$8:$D$12)","v":5}]
["Student 2",6256,"2013-04-08",3,0,"Program template and gathering information",9,27,{"$f":"SUMIF($A$8:$A$12,A42,$D$8:$D$12)","v":5}]
["Student 1",6256,"2013-04-05",2,0,"quarter sheets and bookmarks",10,20,{"$f":"SUMIF($A$8:$A$12,A43,$D$8:$D$12)","v":3.5}]
["Student 1",6256,"2013-04-04",1,0,"bookmarks",10,10,{"$f":"SUMIF($A$8:$A$12,A44,$D$8:$D$12)","v":3.5}]
["Student 1",6256,"2013-04-01",0.5,0,"bookmarks",10,5,{"$f":"SUMIF($A$8:$A$12,A45,$D$8:$D$12)","v":3.5}]
[null,"6256 Total",null,{"$f":"SUM(D41:D45)","v":8.5},null,null,null,{"$f":"SUM(H41:H45)","v":80},{"$f":"SUMPRODUCT(1/COUNTIF(I$8:I$12,I$8:I$12))","v":1.9999999999999998}]
["Student 3",6308,"2013-04-01",3.8,0,"poster and online art",11,{"$f":"G47*D47+G47*E47*1.5","v":41.8},{"$f":"SUMIF($A$14:$A$14,A47,$D$14:$D$14)","v":3.8}]
[null,"6308 Total",null,{"$f":"SUM(D47)","v":3.8},null,null,null,{"$f":"SUM(H47)","v":41.8},{"$f":"SUMPRODUCT(1/COUNTIF(I$14:I$14,I$14:I$14))","v":1}]
["Student 3",6304,"2013-04-05",4,0,"Poster for May performance",11,{"$f":"G49*D49+G49*E49*1.5","v":44},{"$f":"SUMIF($A$16:$A$17,A49,$D$16:$D$17)","v":7}]
["Student 3",6304,"2013-04-04",3,0,"Poster for May performance",11,33,{"$f":"SUMIF($A$16:$A$17,A50,$D$16:$D$17)","v":7}]
[null,"6304 Total",null,{"$f":"SUM(D49:D50)","v":7},null,null,null,{"$f":"SUM(H49:H50)","v":77},{"$f":"SUMPRODUCT(1/COUNTIF(I$16:I$17,I$16:I$17))","v":1}]
["Student 1",6206,"2013-04-02",0.5,0,"facebook page",10,{"$f":"G52*D52+G52*E52*1.5","v":5},{"$f":"SUMIF($A$19:$A$21,A52,$D$19:$D$21)","v":4.5}]
["Student 1",6206,"2013-04-02",2,0,"poster",10,20,{"$f":"SUMIF($A$19:$A$21,A53,$D$19:$D$21)","v":4.5}]
["Student 1",6206,"2013-04-01",2,0,"poster",10,20,{"$f":"SUMIF($A$19:$A$21,A54,$D$19:$D$21)","v":4.5}]
[null,"6206 Total",null,{"$f":"SUM(D52:D54)","v":4.5},null,null,null,{"$f":"SUM(H52:H54)","v":45},{"$f":"SUMPRODUCT(1/COUNTIF(I$19:I$21,I$19:I$21))","v":1}]
["Student 1",7011,"2013-04-02",0.5,0,"facebook page",10,{"$f":"G56*D56+G56*E56*1.5","v":5},{"$f":"SUMIF($A$23:$A$24,A56,$D$23:$D$24)","v":1.5}]
["Student 1",7011,"2013-04-01",1,0,"online art",10,10,{"$f":"SUMIF($A$23:$A$24,A57,$D$23:$D$24)","v":1.5}]
[null,"7011 Total",null,{"$f":"SUM(D56:D57)","v":1.5},null,null,null,{"$f":"SUM(H56:H57)","v":15},{"$f":"SUMPRODUCT(1/COUNTIF(I$23:I$24,I$23:I$24))","v":1}]
["Student 1",6255,"2013-04-03",1.5,0,"quarter sheets and poster",10,{"$f":"G59*D59+G59*E59*1.5","v":15},{"$f":"SUMIF($A$26:$A$26,A59,$D$26:$D$26)","v":1.5}]
[null,"6255 Total",null,{"$f":"D59","v":1.5},null,null,null,{"$f":"SUM(H59)","v":15},{"$f":"SUMPRODUCT(1/COUNTIF(I$26:I$26,I$26:I$26))","v":1}]
["Student 1",7015,"2013-04-03",1,0,"poster",10,{"$f":"G61*D61+G61*E61*1.5","v":10},{"$f":"SUMIF($A$28:$A$28,A61,$D$28:$D$28)","v":1}]
[null,"7015 Total",null,1,null,null,null,{"$f":"SUM(H61)","v":10},{"$f":"SUMPRODUCT(1/COUNTIF(I$28:I$28,I$28:I$28))","v":1}]
["Student 2",6175,"2013-04-05",3,0,"Finalizing program for printing",9,{"$f":"G63*D63+G63*E63*1.5","v":27},{"$f":"SUMIF($A$30:$A$33,A63,$D$30:$D$33)","v":13}]
["Student 2",6175,"2013-04-04",2,0,"Program design",9,18,{"$f":"SUMIF($A$30:$A$33,A64,$D$30:$D$33)","v":13}]
["Student 2",6175,"2013-04-03",4,0,"Program design",9,36,{"$f":"SUMIF($A$30:$A$33,A65,$D$30:$D$33)","v":13}]
["Student 2",6175,"2013-04-01",4,0,"Program Design",9,36,{"$f":"SUMIF($A$30:$A$33,A66,$D$30:$D$33)","v":13}]
[null,"6175 Total",null,{"$f":"SUM(D63:D66)","v":13},null,null,null,{"$f":"SUM(H63:H66)","v":117},{"$f":"SUMPRODUCT(1/COUNTIF(I$30:I$33,I$30:I$33))","v":1}]

{"sheet":"Summary Info","index":3,"n_rows":19,"n_cols":26,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
["Showcode","Show Name","Newspaper","Programs","Posters","Labor","Total Cost","X","Student Employee1","Hours1","Student Employee2","Hours2","Student Employee3","Hours3","Student Employee4","Hours4","Student Employee5","Hours5","Student Employee6","Hours6","Student Employee7","Hours7","Student Employee8","Hours8","Student Employee9","Hours9"]
[6148,{"$f":"VLOOKUP(A2,Showcodes!A:B,2)","v":" Henry V "},{"$f":"SUMIF(PrintingData!$E:$E,'Summary Info'!A10,PrintingData!$H:$H)","v":100},{"$f":"SUMIF(PrintingData!$N:$N,'Summary Info'!A10,PrintingData!$Q:$Q)","v":0},{"$f":"SUMIF(PrintingData!$W:$W,'Summary Info'!A10,PrintingData!$Z:$Z)","v":0},117,{"$f":"SUM(C2:F2)","v":217},null,"Student 2",13]
[6162,{"$f":"VLOOKUP(A3,Showcodes!A:B,2)","v":" Light in the Piazza "},{"$f":"SUMIF(PrintingData!$E:$E,'Summary Info'!A2,PrintingData!$H:$H)","v":225},{"$f":"SUMIF(PrintingData!$N:$N,'Summary Info'!A2,PrintingData!$Q:$Q)","v":0},{"$f":"SUMIF(PrintingData!$W:$W,'Summary Info'!A2,PrintingData!$Z:$Z)","v":0},100,{"$f":"SUM(C3:F3)","v":325},null,"Student 1",10]
[6175,{"$f":"VLOOKUP(A4,Showcodes!A:B,2)","v":" Servant of Two Masters "},{"$f":"SUMIF(PrintingData!$E:$E,'Summary Info'!A19,PrintingData!$H:$H)","v":10},{"$f":"SUMIF(PrintingData!$N:$N,'Summary Info'!A19,PrintingData!$Q:$Q)","v":1000},{"$f":"SUMIF(PrintingData!$W:$W,'Summary Info'!A19,PrintingData!$Z:$Z)","v":100},117,{"$f":"SUM(C4:F4)","v":1227},null,"Student 2",13]
[6190,{"$f":"VLOOKUP(A5,Showcodes!A:B,2)","v":" Wrinkle in Time, A "},{"$f":"SUMIF(PrintingData!$E:$E,'Summary Info'!A3,PrintingData!$H:$H)","v":0},{"$f":"SUMIF(PrintingData!$N:$N,'Summary Info'!A3,PrintingData!$Q:$Q)","v":0},{"$f":"SUMIF(PrintingData!$W:$W,'Summary Info'!A3,PrintingData!$Z:$Z)","v":0},80,{"$f":"SUM(C5:F5)","v":80},null,"Student 2",5,"Student 1",3.5]
[6202,{"$f":"VLOOKUP(A6,Showcodes!A:B,2)","v":" Group for New Music "},{"$f":"SUMIF(PrintingData!$E:$E,'Summary Info'!A4,PrintingData!$H:$H)","v":0},{"$f":"SUMIF(PrintingData!$N:$N,'Summary Info'!A4,PrintingData!$Q:$Q)","v":2000},{"$f":"SUMIF(PrintingData!$W:$W,'Summary Info'!A4,PrintingData!$Z:$Z)","v":0},42,{"$f":"SUM(C6:F6)","v":2042},null,"Student 3",3.8]
[6204,{"$f":"VLOOKUP(A7,Showcodes!A:B,2)","v":" Non-Ticketed Ensembles "},{"$f":"SUMIF(PrintingData!$E:$E,'Summary Info'!A5,PrintingData!$H:$H)","v":0},{"$f":"SUMIF(PrintingData!$N:$N,'Summary Info'!A5,PrintingData!$Q:$Q)","v":0},{"$f":"SUMIF(PrintingData!$W:$W,'Summary Info'!A5,PrintingData!$Z:$Z)","v":0},77,{"$f":"SUM(C7:F7)","v":77},null,"Student 3",7]
[6206,{"$f":"VLOOKUP(A8,Showcodes!A:B,2)","v":" University Chorale "},{"$f":"SUMIF(PrintingData!$E:$E,'Summary Info'!A6,PrintingData!$H:$H)","v":0},{"$f":"SUMIF(PrintingData!$N:$N,'Summary Info'!A6,PrintingData!$Q:$Q)","v":0},{"$f":"SUMIF(PrintingData!$W:$W,'Summary Info'!A6,PrintingData!$Z:$Z)","v":0},45,{"$f":"SUM(C8:F8)","v":45},null,"Student 1",4.5]
[6206,{"$f":"VLOOKUP(A9,Showcodes!A:B,2)","v":" University Chorale "},{"$f":"SUMIF(PrintingData!$E:$E,'Summary Info'!A15,PrintingData!$H:$H)","v":0},{"$f":"SUMIF(PrintingData!$N:$N,'Summary Info'!A15,PrintingData!$Q:$Q)","v":0},{"$f":"SUMIF(PrintingData!$W:$W,'Summary Info'!A15,PrintingData!$Z:$Z)","v":0},45,{"$f":"SUM(C9:F9)","v":45},null,"Student 1",4.5]
[6222,{"$f":"VLOOKUP(A10,Showcodes!A:B,2)","v":" MDT Showcase-Broadway Revue "},{"$f":"SUMIF(PrintingData!$E:$E,'Summary Info'!A11,PrintingData!$H:$H)","v":0},{"$f":"SUMIF(PrintingData!$N:$N,'Summary Info'!A11,PrintingData!$Q:$Q)","v":0},{"$f":"SUMIF(PrintingData!$W:$W,'Summary Info'!A11,PrintingData!$Z:$Z)","v":0},100,{"$f":"SUM(C10:F10)","v":100},null,"Student 1",10]
[6249,{"$f":"VLOOKUP(A11,Showcodes!A:B,2)","v":" University Orchestra & Strings "},{"$f":"SUMIF(PrintingData!$E:$E,'Summary Info'!A7,PrintingData!$H:$H)","v":0},{"$f":"SUMIF(PrintingData!$N:$N,'Summary Info'!A7,PrintingData!$Q:$Q)","v":85},{"$f":"SUMIF(PrintingData!$W:$W,'Summary Info'!A7,PrintingData!$Z:$Z)","v":30},15,{"$f":"SUM(C11:F11)","v":130},null,"Student 1",1.5]
[6255,{"$f":"VLOOKUP(A12,Showcodes!A:B,2)","v":" Jazz Ensemble "},{"$f":"SUMIF(PrintingData!$E:$E,'Summary Info'!A17,PrintingData!$H:$H)","v":0},{"$f":"SUMIF(PrintingData!$N:$N,'Summary Info'!A17,PrintingData!$Q:$Q)","v":500},{"$f":"SUMIF(PrintingData!$W:$W,'Summary Info'!A17,PrintingData!$Z:$Z)","v":51},15,{"$f":"SUM(C12:F12)","v":566},null,"Student 1",1.5]
[6256,{"$f":"VLOOKUP(A13,Showcodes!A:B,2)","v":" Madsen Music Evening Events "},{"$f":"SUMIF(PrintingData!$E:$E,'Summary Info'!A12,PrintingData!$H:$H)","v":0},{"$f":"SUMIF(PrintingData!$N:$N,'Summary Info'!A12,PrintingData!$Q:$Q)","v":100},{"$f":"SUMIF(PrintingData!$W:$W,'Summary Info'!A12,PrintingData!$Z:$Z)","v":100},80,{"$f":"SUM(C13:F13)","v":280},null,"Student 2",5,"Student 1",3.5]
[6285,{"$f":"VLOOKUP(A14,Showcodes!A:B,2)","v":" University Bands "},{"$f":"SUMIF(PrintingData!$E:$E,'Summary Info'!A8,PrintingData!$H:$H)","v":0},{"$f":"SUMIF(PrintingData!$N:$N,'Summary Info'!A8,PrintingData!$Q:$Q)","v":0},{"$f":"SUMIF(PrintingData!$W:$W,'Summary Info'!A8,PrintingData!$Z:$Z)","v":0},15,{"$f":"SUM(C14:F14)","v":15},null,"Student 1",1.5]
[6287,{"$f":"VLOOKUP(A15,Showcodes!A:B,2)","v":" Jazz Voices "},{"$f":"SUMIF(PrintingData!$E:$E,'Summary Info'!A9,PrintingData!$H:$H)","v":0},{"$f":"SUMIF(PrintingData!$N:$N,'Summary Info'!A9,PrintingData!$Q:$Q)","v":0},{"$f":"SUMIF(PrintingData!$W:$W,'Summary Info'!A9,PrintingData!$Z:$Z)","v":0},10,{"$f":"SUM(C15:F15)","v":10},null,"Student 1",1]
[6304,{"$f":"VLOOKUP(A16,Showcodes!A:B,2)","v":" Ballet in Concert-Sleeping Beauty "},{"$f":"SUMIF(PrintingData!$E:$E,'Summary Info'!A14,PrintingData!$H:$H)","v":0},{"$f":"SUMIF(PrintingData!$N:$N,'Summary Info'!A14,PrintingData!$Q:$Q)","v":0},{"$f":"SUMIF(PrintingData!$W:$W,'Summary Info'!A14,PrintingData!$Z:$Z)","v":0},77,{"$f":"SUM(C16:F16)","v":77},null,"Student 3",7]
[6308,{"$f":"VLOOKUP(A17,Showcodes!A:B,2)","v":" DancEnsemble "},{"$f":"SUMIF(PrintingData!$E:$E,'Summary Info'!A13,PrintingData!$H:$H)","v":0},{"$f":"SUMIF(PrintingData!$N:$N,'Summary Info'!A13,PrintingData!$Q:$Q)","v":80},{"$f":"SUMIF(PrintingData!$W:$W,'Summary Info'!A13,PrintingData!$Z:$Z)","v":10},42,{"$f":"SUM(C17:F17)","v":132},null,"Student 3",3.8]
[7011,{"$f":"VLOOKUP(A18,Showcodes!A:B,2)","v":" Aulos Ensemble "},{"$f":"SUMIF(PrintingData!$E:$E,'Summary Info'!A16,PrintingData!$H:$H)","v":150},{"$f":"SUMIF(PrintingData!$N:$N,'Summary Info'!A16,PrintingData!$Q:$Q)","v":2000},{"$f":"SUMIF(PrintingData!$W:$W,'Summary Info'!A16,PrintingData!$Z:$Z)","v":0},15,{"$f":"SUM(C18:F18)","v":2165},null,"Student 1",1.5]
[7015,{"$f":"VLOOKUP(A19,Showcodes!A:B,2)","v":" Aquila Theatre Co-Cyrano De Bergerac "},{"$f":"SUMIF(PrintingData!$E:$E,'Summary Info'!A18,PrintingData!$H:$H)","v":75},{"$f":"SUMIF(PrintingData!$N:$N,'Summary Info'!A18,PrintingData!$Q:$Q)","v":0},{"$f":"SUMIF(PrintingData!$W:$W,'Summary Info'!A18,PrintingData!$Z:$Z)","v":50},10,{"$f":"SUM(C19:F19)","v":135},null,"Student 1",1]