{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["Instructions","Artist Details","Event Name"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":1,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","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":"Instructions","index":0,"n_rows":30,"n_cols":1,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
["INSTRUCTIONS - PROPS 1.01 (Performance Royalty Open Payment System)"]
["BANDS"]
["1. Click on the \"Artist Details\" tab."]
["2. Enter in the bank account details of each songwriter in the band and the name of any publishing companies represented (that you know of)."]
["3. Enter in the names of the songs you played at the event under \"Song Title\"."]
["4. Enter in the appropriate % accredited to each songwriter for each song."]
["The \"indicator\" column will show you if you have made each songs credits add up to 100%. It will turn green when you have done so."]
["If a song is a cover and you don't know the details, just pop the artist name as a \"songwriter\" and attribute 100% to them. The promoter will take care of it."]
["5. Click on the \"Event\" tab."]
["6. Select the songs you played at the event under \"Set List\"."]
["One the promoter has entered in their information you should see all the payment amounts calculate automatically."]
["Dont worry is you see error codes in red text. Those fields won't populate with info until the promoter has entered everything. You can still input all of your information."]
["PROMOTERS"]
["1. Click on \"Event\" tab and enter in the following information (for each band performance)."]
["2. The duration of the set (minutes) in B10."]
["3. The total amount of minutes at the event that live music was performed by all acts, B11."]
["4. The amount you wish to pay the bands for royalties. This should be minimum 1.5% of your gross ticket sales. Aim for 3-4%. Enter as a $ amount into B13."]
["5. By default the administration charge is set to 10%. If you feel there is more work than usual involved with the distribution of funds, change to 15%. This is in B14."]
["If the band have entered in their information correctly, all the values (in red) should automatically update."]
["6. Pay the songwriters! The amount to pay each songwriter will be in row 7 - Track this up to see which songwriter it is and grab their details from the \"Artist Details\" tab."]
["If there are any publishers to be paid. Contact that publisher and ask for their bank details, pay them and email them the songwriter details for the tracks paid. This is where you earn your percentage :)"]
["If any covers are played where you can't contact the songwriter or publisher directly, you'll need to pay that amount of money to APRA/AMCOS* and give them any details you can."]
["* http://www.apraamcos.co.nz/ - of course, given that this entire system is used to bypass them, they may not be to eager to receive bit payments from you, however, these are likely rare occasions."]
[]
["PROPS 1.01"]
["Any questions: alowhum@gmail.com"]
["By using PROPS there are absolutely no guarantees that you won't get grief from APRA/AMCOS. Usage of PROPS is at a promoters discretion."]
["Once you have this form filled in for a band, you don't need to start a new document each time they play, you can just add a new event tab to this form."]
["If people want to expand on this system, the next major improvement will be ..."]
["That way of doing it it beyond my rudimentary spreadsheeting skills at the moment. Help me out."]

{"sheet":"Artist Details","index":1,"n_rows":34,"n_cols":13,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[null,"Name","Bank","Account Name","Account Number"]
["Songwriter Name 1"]
["Songwriter Name 2"]
["Songwriter Name 3"]
["Songwriter Name 4"]
["Songwriter Name 5"]
["Songwriter Name 6"]
["Songwriter Name 7"]
["For publishers, just enter name of publisher, and (if you have it) a contact person. Promoter will contact for payment details"]
["Publisher 1"]
["Publisher 2"]
["Publisher 3"]
["Publisher 4"]
[]
[null,"Writer 1","Writer 2","Writer 3","Writer 4","Writer 5","Writer 6","Writer 7","Publisher 1","Publisher 2","Publisher 3","Publisher 4","INDICATOR"]
[null,{"$f":"IF('Artist Details'!$B$2<>\"\",'Artist Details'!$B$2,\"\")","v":""},{"$f":"IF('Artist Details'!$B$3<>\"\",'Artist Details'!$B$3,\"\")","v":""},{"$f":"IF('Artist Details'!$B$4<>\"\",'Artist Details'!$B$4,\"\")","v":""},{"$f":"IF('Artist Details'!$B$5<>\"\",'Artist Details'!$B$5,\"\")","v":""},{"$f":"IF('Artist Details'!$B$6<>\"\",'Artist Details'!$B$6,\"\")","v":""},{"$f":"IF('Artist Details'!$B$7<>\"\",'Artist Details'!$B$7,\"\")","v":""},{"$f":"IF('Artist Details'!$B$8<>\"\",'Artist Details'!$B$8,\"\")","v":""},{"$f":"IF('Artist Details'!$B$10<>\"\",'Artist Details'!$B$10,\"\")","v":""},{"$f":"IF('Artist Details'!$B$11<>\"\",'Artist Details'!$B$11,\"\")","v":""},{"$f":"IF('Artist Details'!$B$12<>\"\",'Artist Details'!$B$12,\"\")","v":""},{"$f":"IF('Artist Details'!$B$13<>\"\",'Artist Details'!$B$13,\"\")","v":""}]
["SONG TITLE",0,0,0,0,0,0,0,0,0,0,0]
["Song 1",0,0,0,0,0,0,0,0,0,0,0,{"$f":"SUM(B18:L18)","v":0}]
["Song 2",0,0,0,0,0,0,0,0,0,0,0,0]
["Snng 3",0,0,0,0,0,0,0,0,0,0,0,0]
["Song 4",0,0,0,0,0,0,0,0,0,0,0,0]
["Song 5",0,0,0,0,0,0,0,0,0,0,0,0]
["Song 6",0,0,0,0,0,0,0,0,0,0,0,0]
["Song 7",0,0,0,0,0,0,0,0,0,0,0,0]
["Song 8",0,0,0,0,0,0,0,0,0,0,0,0]
["Song 9",0,0,0,0,0,0,0,0,0,0,0,0]
["Song 10",0,0,0,0,0,0,0,0,0,0,0,0]
["Song 11",0,0,0,0,0,0,0,0,0,0,0,0]
["Song 12",0,0,0,0,0,0,0,0,0,0,0,0]
["Song 13",0,0,0,0,0,0,0,0,0,0,0,0]
["Song 14",0,0,0,0,0,0,0,0,0,0,0,0]
["Song 15",0,0,0,0,0,0,0,0,0,0,0,0]
[]
["Text in GOLD entered by performer"]

{"sheet":"Event Name","index":2,"n_rows":33,"n_cols":13,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
["Text in GOLD entered by performer"]
["Figures in BLUE are entered by promoter"]
["Figures in RED are automatically generated, leave alone"]
[null,"Writer 1","Writer 2","Writer 3","Writer 4","Writer 5","Writer 6","Writer 7","Publisher 1","Publisher 2","Publisher 3","Publisher 4"]
["Songwriter",{"$f":"'Artist Details'!$B$16","v":""},{"$f":"'Artist Details'!$C$16","v":""},{"$f":"'Artist Details'!$D$16","v":""},{"$f":"'Artist Details'!$E$16","v":""},{"$f":"'Artist Details'!$F$16","v":""},{"$f":"'Artist Details'!$G$16","v":""},{"$f":"'Artist Details'!$H$16","v":""},{"$f":"'Artist Details'!$I$16","v":""},{"$f":"'Artist Details'!$J$16","v":""},{"$f":"'Artist Details'!$K$16","v":""},{"$f":"'Artist Details'!$L$16","v":""},"TOTAL"]
["Songwriter payment",{"$f":"(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$19,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$B$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$20,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$B$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$21,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$B$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$22,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$B$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$23,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$B$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$24,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$B$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$25,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$B$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$26,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$B$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$27,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$B$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$28,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$B$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$29,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$B$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$30,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$B$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$31,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$B$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$32,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$B$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$33,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$B$4,'Artist Details'!$B$15:$L$15,0))*$B$16)","v":{"$error":"#DIV/0!"}},{"$f":"(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$19,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$C$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$20,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$C$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$21,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$C$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$22,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$C$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$23,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$C$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$24,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$C$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$25,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$C$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$26,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$C$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$27,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$C$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$28,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$C$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$29,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$C$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$30,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$C$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$31,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$C$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$32,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$C$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$33,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$C$4,'Artist Details'!$B$15:$L$15,0))*$B$16)","v":{"$error":"#DIV/0!"}},{"$f":"(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$19,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$D$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$20,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$D$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$21,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$D$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$22,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$D$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$23,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$D$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$24,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$D$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$25,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$D$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$26,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$D$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$27,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$D$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$28,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$D$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$29,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$D$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$30,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$D$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$31,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$D$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$32,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$D$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$33,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$D$4,'Artist Details'!$B$15:$L$15,0))*$B$16)","v":{"$error":"#DIV/0!"}},{"$f":"(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$19,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$E$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$20,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$E$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$21,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$E$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$22,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$E$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$23,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$E$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$24,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$E$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$25,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$E$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$26,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$E$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$27,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$E$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$28,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$E$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$29,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$E$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$30,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$E$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$31,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$E$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$32,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$E$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$33,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$E$4,'Artist Details'!$B$15:$L$15,0))*$B$16)","v":{"$error":"#DIV/0!"}},{"$f":"(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$19,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$F$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$20,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$F$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$21,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$F$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$22,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$F$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$23,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$F$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$24,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$F$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$25,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$F$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$26,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$F$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$27,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$F$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$28,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$F$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$29,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$F$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$30,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$F$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$31,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$F$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$32,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$F$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$33,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$F$4,'Artist Details'!$B$15:$L$15,0))*$B$16)","v":{"$error":"#DIV/0!"}},{"$f":"(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$19,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$G$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$20,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!G$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$21,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$G$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$22,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$G$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$23,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$G$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$24,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$G$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$25,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$G$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$26,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$G$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$27,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$G$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$28,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$G$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$29,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$G$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$30,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$G$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$31,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$G$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$32,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$G$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$33,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$G$4,'Artist Details'!$B$15:$L$15,0))*$B$16)","v":{"$error":"#DIV/0!"}},{"$f":"(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$19,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$H$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$20,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$H$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$21,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$H$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$22,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$H$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$23,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$H$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$24,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$H$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$25,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$H$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$26,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$H$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$27,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$H$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$28,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$H$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$29,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$H$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$30,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$H$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$31,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$H$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$32,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$H$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$33,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$H$4,'Artist Details'!$B$15:$L$15,0))*$B$16)","v":{"$error":"#DIV/0!"}},{"$f":"(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$19,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$I$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$20,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$I$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$21,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$I$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$22,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$I$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$23,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$I$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$24,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$I$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$25,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$I$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$26,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$I$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$27,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$I$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$28,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$I$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$29,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$I$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$30,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$I$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$31,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$I$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$32,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$I$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$33,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$I$4,'Artist Details'!$B$15:$L$15,0))*$B$16)","v":{"$error":"#DIV/0!"}},{"$f":"(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$19,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$J$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$20,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$J$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$21,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$J$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$22,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$J$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$23,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$J$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$24,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$J$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$25,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$J$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$26,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$J$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$27,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$J$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$28,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$J$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$29,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$J$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$30,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$J$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$31,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$J$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$32,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$J$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$33,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$J$4,'Artist Details'!$B$15:$L$15,0))*$B$16)","v":{"$error":"#DIV/0!"}},{"$f":"(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$19,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$K$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$20,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$K$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$21,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$K$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$22,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$K$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$23,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$K$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$24,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$K$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$25,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$K$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$26,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$K$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$27,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$K$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$28,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$K$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$29,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$K$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$30,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$K$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$31,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$K$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$32,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$K$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$33,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$K$4,'Artist Details'!$B$15:$L$15,0))*$B$16)","v":{"$error":"#DIV/0!"}},{"$f":"(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$19,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$L$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$20,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$L$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$21,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$L$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$22,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$L$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$23,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$L$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$24,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$L$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$25,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$L$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$26,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$L$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$27,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$L$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$28,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$L$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$29,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$L$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$30,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$L$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$31,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$L$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$32,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$L$4,'Artist Details'!$B$15:$L$15,0))*$B$16)+(INDEX('Artist Details'!$B$17:$L$32,MATCH('Event Name'!$A$33,'Artist Details'!$A$17:$A$32,0),MATCH('Event Name'!$L$4,'Artist Details'!$B$15:$L$15,0))*$B$16)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(B6:L6)","v":{"$error":"#DIV/0!"}}]
[]
["TOTAL NUMBER OF SONGS",{"$f":"IF($A$19<>\"SONG TITLE\",1,0)+IF($A$20<>\"SONG TITLE\",1,0)+IF($A$21<>\"SONG TITLE\",1,0)+IF($A$22<>\"SONG TITLE\",1,0)+IF($A$23<>\"SONG TITLE\",1,0)+IF($A$24<>\"SONG TITLE\",1,0)+IF($A$25<>\"SONG TITLE\",1,0)+IF($A$26<>\"SONG TITLE\",1,0)+IF($A$27<>\"SONG TITLE\",1,0)+IF($A$28<>\"SONG TITLE\",1,0)+IF($A$29<>\"SONG TITLE\",1,0)+IF($A$30<>\"SONG TITLE\",1,0)+IF($A$31<>\"SONG TITLE\",1,0)+IF($A$32<>\"SONG TITLE\",1,0)+IF($A$33<>\"SONG TITLE\",1,0)","v":0}]
["SET LENGTH (MIN)",0,"(Type in the total length of the set (minutes) played by Band X)"]
["EVENT LENGTH (MIN)",0,"(Type in the total amount of all the sets played by the bands at your event [minutes])"]
["SET % OF OVERALL EVENT",{"$f":"B9/B10","v":{"$error":"#DIV/0!"}}]
["TOTAL EVENT FEE",0,"(Enter the amount you wish to pay to all songwriters for your event. Normally it is 1.5% of your gross takings, you can choose more if you wish)"]
["Less admin",0.1,"(Enter a percentage you feel fair for your administration of all this. 10% is a good guideline. If you have many songs to process, perhaps take more, maximum 15% to be fair)"]
["FEES PAYABLE TO ALL ACTS",{"$f":"B12-(B12*B13)","v":0}]
["TOTAL PAYABLE TO BAND X",{"$f":"B14*B11","v":{"$error":"#DIV/0!"}}]
["AMOUNT PAYABLE PER SONG",{"$f":"B15/B8","v":{"$error":"#DIV/0!"}}]
[]
["SET LIST"]
["SONG TITLE"]
["SONG TITLE"]
["SONG TITLE"]
["SONG TITLE"]
["SONG TITLE"]
["SONG TITLE"]
["SONG TITLE"]
["SONG TITLE"]
["SONG TITLE"]
["SONG TITLE"]
["SONG TITLE"]
["SONG TITLE"]
["SONG TITLE"]
["SONG TITLE"]
["SONG TITLE"]