{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Fee Estimate Tool","Info","Fees"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":4,"comments":3,"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":"Fee Estimate Tool","index":0,"n_rows":264,"n_cols":10,"rows_kept":264,"cut":false,"hidden":false,"merged":[[78,1,78,9],[155,1,155,9],[179,1,179,9],[67,1,68,1],[66,1,66,9],[177,1,177,9],[178,1,178,9],[156,1,157,1],[11,2,11,3],[22,2,22,5],[8,2,8,9],[62,6,62,7],[34,2,34,5],[60,2,60,9],[9,2,9,9],[15,2,15,5],[16,2,16,5],[14,2,14,5],[30,1,30,5],[40,1,40,2],[41,1,41,2],[24,2,24,5],[35,2,35,5],[2,1,2,9],[1,1,1,9],[3,1,3,9],[4,1,4,9],[6,1,6,9],[205,2,205,5],[206,2,206,5],[7,1,7,9],[38,2,38,3],[61,6,61,7],[63,6,63,7],[59,1,59,9],[10,2,10,3],[23,2,23,5],[19,2,19,5],[20,2,20,5],[21,2,21,5],[17,2,17,5],[13,2,13,3],[163,1,164,1],[77,1,77,9],[212,1,212,5],[63,2,64,5],[219,2,219,6],[12,2,12,3],[37,2,37,5],[214,1,214,5],[215,1,215,5],[209,1,209,6],[25,2,25,5],[31,2,31,5],[32,2,32,5],[33,2,33,5],[36,2,36,5],[180,1,180,9],[79,1,80,1],[72,1,73,1],[241,6,241,7],[240,3,240,7],[210,1,210,6],[111,1,112,1],[216,1,216,6],[210,7,210,9],[218,1,218,6],[218,7,218,9],[207,1,207,9],[208,1,208,9],[194,1,194,9],[193,1,193,9],[216,7,216,9],[213,1,213,5],[209,7,209,9],[211,1,211,5]]}
[]
[null,"Personal Information is collected under the authority of Section 11 of the Municipal Act, 2001, c.25. The information will be used for the administration of event performance(s) at Meadowvale Theatre and to contact you regarding your event/performance(s).  Questions about this collection should be directed to Manager, Meadowvale Theatre, City of Mississauga 905-615-3200 ext. 5356"]
[null,"This fee schedule is a planning tool for clients to estimate Meadowvale Theatre costs. Final reconciled costs will be sent to the signing authority following the event."]
[null,"Save form to desktop and complete on computer."]
[null,"Enter event details in the grey cells below for a cost estimate. If cells becomes pink, there is mandatory requirement."]
[null,null,null,"Example",null,null,"Example"]
[null,"Click here, Community Groups and Affiliates have applied and been approved for formal recognition through the City's Community Group Support Program"]
[null,"C O N T R A C T    I N F O R M A T I O N"]
[null,"Organization Name, if applicable"]
[null,"Street Address"]
[null,"City"]
[null,"Postal Code"]
[null,"Province"]
[null,"Phone Number"]
[null,"Organizer Status"]
[null,"NFP ID Number"]
[null,"Business Number"]
[null,"HST Number"]
[]
[null,"Signing Authority Name"]
[null,"Job Title"]
[null,"Email"]
[null,"Phone Number"]
[null,"Street Address"]
[null,"City"]
[null,"Postal Code"]
[]
[null,"Will you be purchasing insurance through the City's?"]
[null,"Required insurance coverage of:",{"$f":"IFERROR(IF(COUNTIFS(D146:D154,\"Yes\")>0,\"5 million\",\"2 million\"),\"\")","v":"2 million"}]
[]
[null,"I hereby consent that I am the primary contact"]
[null,"Name"]
[null,"Job Title"]
[null,"Street Address"]
[null,"City"]
[null,"Postal Code"]
[null,"Phone Number"]
[null,"Email"]
[null,"Date of Consent"]
[]
[null,"Calendar Days Requesting to Book"]
[null,"Please indicate the days required for the event booking"]
[null,"Day 1",null,{"$f":"IF(Info!B70>=1,\"WARNING: Duplicate Dates Error\",\"\")","v":""}]
[null,"Day 2"]
[null,"Day 3"]
[null,"Day 4"]
[null,"Day 5"]
[null,"Day 6"]
[null,"Day 7"]
[null,"Day 8"]
[null,"Day 9"]
[null,"Day 10"]
[null,"Day 11"]
[null,"Day 12"]
[null,"Day 13"]
[null,"Day 14"]
[null,"Day 15"]
[null,"Day 16"]
[]
[null,"T I C K E T I N G   A N D   S H O W   I N F O R M A T I O N"]
[null,"Name of Event"]
[null,"Will you be using the City's Box Office to sell tickets?",null,null,null,null,"Total Attendance (Expected)",null,{"$f":"IFERROR(IF($C$62=\"No\",I64*Fees!$B$49,SUM($C$92:$J$92)+SUM($C$124:$J$124)),\"\")","v":0}]
[null,"Will you be playing recorded music?",null,null,null,null,"Total Number of Days",null,{"$f":"IF(COUNTA($C$43:$C$58)=0,\"\",COUNTA($C$43:$C$58))","v":""}]
[null,"Brief description of the event",null,null,null,null,"Total Number of Shows",null,{"$f":"SUM($C$91:$J$91)+SUM($C$123:$J$123)","v":0}]
[]
[]
[null,"R E H E A R S A L  H A L L"]
[null,"CALENDAR DAY","Day 1","Day 2","Day 3","Day 4","Day 5","Day 6","Day 7","Day 8"]
[null,null,{"$f":"IF(ISBLANK($C$43),\"\",$C$43)","v":""},{"$f":"IF(ISBLANK($C$44),\"\",$C$44)","v":""},{"$f":"IF(ISBLANK($C$45),\"\",$C$45)","v":""},{"$f":"IF(ISBLANK($C$46),\"\",$C$46)","v":""},{"$f":"IF(ISBLANK($C$47),\"\",$C$47)","v":""},{"$f":"IF(ISBLANK($C$48),\"\",$C$48)","v":""},{"$f":"IF(ISBLANK($C$49),\"\",$C$49)","v":""},{"$f":"IF(ISBLANK($C$50),\"\",$C$50)","v":""}]
[null,"Start Time"]
[null,"End Time"]
[null,null,{"$f":"IF(AND(C71-C70>=0,COUNTA(C70:C71)+COUNT(C69)=3),Info!$B$8,\"\")","v":""},{"$f":"IF(AND(D71-D70>=0,COUNTA(D70:D71)+COUNT(D69)=3),Info!$B$8,\"\")","v":""},{"$f":"IF(AND(E71-E70>=0,COUNTA(E70:E71)+COUNT(E69)=3),Info!$B$8,\"\")","v":""},{"$f":"IF(AND(F71-F70>=0,COUNTA(F70:F71)+COUNT(F69)=3),Info!$B$8,\"\")","v":""},{"$f":"IF(AND(G71-G70>=0,COUNTA(G70:G71)+COUNT(G69)=3),Info!$B$8,\"\")","v":""},{"$f":"IF(AND(H71-H70>=0,COUNTA(H70:H71)+COUNT(H69)=3),Info!$B$8,\"\")","v":""},{"$f":"IF(AND(I71-I70>=0,COUNTA(I70:I71)+COUNT(I69)=3),Info!$B$8,\"\")","v":""},{"$f":"IF(AND(J71-J70>=0,COUNTA(J70:J71)+COUNT(J69)=3),Info!$B$8,\"\")","v":""}]
[null,"CALENDAR DAY","Day 9","Day 10","Day 11","Day 12","Day 13","Day 14","Day 15","Day 16"]
[null,null,{"$f":"IF(ISBLANK($C$51),\"\",$C$51)","v":""},{"$f":"IF(ISBLANK($C$52),\"\",$C$52)","v":""},{"$f":"IF(ISBLANK($C$53),\"\",$C$53)","v":""},{"$f":"IF(ISBLANK($C$54),\"\",$C$54)","v":""},{"$f":"IF(ISBLANK($C$55),\"\",$C$55)","v":""},{"$f":"IF(ISBLANK($C$56),\"\",$C$56)","v":""},{"$f":"IF(ISBLANK($C$57),\"\",$C$57)","v":""},{"$f":"IF(ISBLANK($C$58),\"\",$C$58)","v":""}]
[null,"Start Time"]
[null,"End Time"]
[null,null,{"$f":"IF(AND(C76-C75>=0,COUNTA(C75:C76)+COUNT(C74)=3),Info!$B$8,\"\")","v":""},{"$f":"IF(AND(D76-D75>=0,COUNTA(D75:D76)+COUNT(D74)=3),Info!$B$8,\"\")","v":""},{"$f":"IF(AND(E76-E75>=0,COUNTA(E75:E76)+COUNT(E74)=3),Info!$B$8,\"\")","v":""},{"$f":"IF(AND(F76-F75>=0,COUNTA(F75:F76)+COUNT(F74)=3),Info!$B$8,\"\")","v":""},{"$f":"IF(AND(G76-G75>=0,COUNTA(G75:G76)+COUNT(G74)=3),Info!$B$8,\"\")","v":""},{"$f":"IF(AND(H76-H75>=0,COUNTA(H75:H76)+COUNT(H74)=3),Info!$B$8,\"\")","v":""},{"$f":"IF(AND(I76-I75>=0,COUNTA(I75:I76)+COUNT(I74)=3),Info!$B$8,\"\")","v":""},{"$f":"IF(AND(J76-J75>=0,COUNTA(J75:J76)+COUNT(J74)=3),Info!$B$8,\"\")","v":""}]
[null,"Booking the rehearsal hall does not equate to booking the Theatre Auditorium or the Lobby. You must indicate if you would like to utilize those spaces by inputting the necessary information."]
[null,"T H E A T R E   A U D I T O R I U M"]
[null,"CALENDAR DAY","Day 1","Day 2","Day 3","Day 4","Day 5","Day 6","Day 7","Day 8"]
[null,null,{"$f":"IF(ISBLANK($C$43),\"\",$C$43)","v":""},{"$f":"IF(ISBLANK($C$44),\"\",$C$44)","v":""},{"$f":"IF(ISBLANK($C$45),\"\",$C$45)","v":""},{"$f":"IF(ISBLANK($C$46),\"\",$C$46)","v":""},{"$f":"IF(ISBLANK($C$47),\"\",$C$47)","v":""},{"$f":"IF(ISBLANK($C$48),\"\",$C$48)","v":""},{"$f":"IF(ISBLANK($C$49),\"\",$C$49)","v":""},{"$f":"IF(ISBLANK($C$50),\"\",$C$50)","v":""}]
[null,"Stage Access - start time (Load In)"]
[null,"Stage Access - end time"]
[null,"Lobby access time for setup"]
[null,"Doors opening to public"]
[null,"Show Start Time"]
[null,"Show End Time"]
[null,"End of Day - Closed"]
[null,"Number of Intermissions"]
[null,"Length of Intermission"]
[null,"Number of Shows"]
[null,"Total Attendance (Expected)"]
[null,"Show Day?",{"$f":"IF(AND(COUNT(C91,C92,C90,C89,C81,C88,C82,C83,C85,C86,C87)>=11,C94=Info!$B$8),\"Yes\",\"\")","v":""},{"$f":"IF(AND(COUNT(D91,D92,D90,D89,D81,D88,D82,D83,D85,D86,D87)>=11,D94=Info!$B$8),\"Yes\",\"\")","v":""},{"$f":"IF(AND(COUNT(E91,E92,E90,E89,E81,E88,E82,E83,E85,E86,E87)>=11,E94=Info!$B$8),\"Yes\",\"\")","v":""},{"$f":"IF(AND(COUNT(F91,F92,F90,F89,F81,F88,F82,F83,F85,F86,F87)>=11,F94=Info!$B$8),\"Yes\",\"\")","v":""},{"$f":"IF(AND(COUNT(G91,G92,G90,G89,G81,G88,G82,G83,G85,G86,G87)>=11,G94=Info!$B$8),\"Yes\",\"\")","v":""},{"$f":"IF(AND(COUNT(H91,H92,H90,H89,H81,H88,H82,H83,H85,H86,H87)>=11,H94=Info!$B$8),\"Yes\",\"\")","v":""},{"$f":"IF(AND(COUNT(I91,I92,I90,I89,I81,I88,I82,I83,I85,I86,I87)>=11,I94=Info!$B$8),\"Yes\",\"\")","v":""},{"$f":"IF(AND(COUNT(J91,J92,J90,J89,J81,J88,J82,J83,J85,J86,J87)>=11,J94=Info!$B$8),\"Yes\",\"\")","v":""}]
[null,null,{"$f":"IF(AND(COUNT(C82:C83,C88)+COUNT(C81)=4,C88-C87>=0,C87-C86>=0,C86-C85>=0,C83-C82>=0),Info!$B$8,\"\")","v":""},{"$f":"IF(AND(COUNT(D82:D83,D88)+COUNT(D81)=4,D88-D87>=0,D87-D86>=0,D86-D85>=0,D83-D82>=0),Info!$B$8,\"\")","v":""},{"$f":"IF(AND(COUNT(E82:E83,E88)+COUNT(E81)=4,E88-E87>=0,E87-E86>=0,E86-E85>=0,E83-E82>=0),Info!$B$8,\"\")","v":""},{"$f":"IF(AND(COUNT(F82:F83,F88)+COUNT(F81)=4,F88-F87>=0,F87-F86>=0,F86-F85>=0,F83-F82>=0),Info!$B$8,\"\")","v":""},{"$f":"IF(AND(COUNT(G82:G83,G88)+COUNT(G81)=4,G88-G87>=0,G87-G86>=0,G86-G85>=0,G83-G82>=0),Info!$B$8,\"\")","v":""},{"$f":"IF(AND(COUNT(H82:H83,H88)+COUNT(H81)=4,H88-H87>=0,H87-H86>=0,H86-H85>=0,H83-H82>=0),Info!$B$8,\"\")","v":""},{"$f":"IF(AND(COUNT(I82:I83,I88)+COUNT(I81)=4,I88-I87>=0,I87-I86>=0,I86-I85>=0,I83-I82>=0),Info!$B$8,\"\")","v":""},{"$f":"IF(AND(COUNT(J82:J83,J88)+COUNT(J81)=4,J88-J87>=0,J87-J86>=0,J86-J85>=0,J83-J82>=0),Info!$B$8,\"\")","v":""}]
[null,"Additional Tech Staffing"]
[]
[]
[]
[]
[null,"Required Tech Staffing"]
[null,"Lighting Board Operator",{"$f":"IF(COUNTA(C82:C83,C88)-COUNTBLANK(C81)<=2,\"\",IF($C$15=Info!$A$5,1,1))","v":""},{"$f":"IF(COUNTA(D82:D83,D88)-COUNTBLANK(D81)<=2,\"\",IF($C$15=Info!$A$5,1,1))","v":""},{"$f":"IF(COUNTA(E82:E83,E88)-COUNTBLANK(E81)<=2,\"\",IF($C$15=Info!$A$5,1,1))","v":""},{"$f":"IF(COUNTA(F82:F83,F88)-COUNTBLANK(F81)<=2,\"\",IF($C$15=Info!$A$5,1,1))","v":""},{"$f":"IF(COUNTA(G82:G83,G88)-COUNTBLANK(G81)<=2,\"\",IF($C$15=Info!$A$5,1,1))","v":""},{"$f":"IF(COUNTA(H82:H83,H88)-COUNTBLANK(H81)<=2,\"\",IF($C$15=Info!$A$5,1,1))","v":""},{"$f":"IF(COUNTA(I82:I83,I88)-COUNTBLANK(I81)<=2,\"\",IF($C$15=Info!$A$5,1,1))","v":""},{"$f":"IF(COUNTA(J82:J83,J88)-COUNTBLANK(J81)<=2,\"\",IF($C$15=Info!$A$5,1,1))","v":""}]
[null,"Sound Board Operator (audio engineer)",{"$f":"IF(COUNTA(C82:C83,C88)-COUNTBLANK(C81)<=2,\"\",IF($C$15=Info!$A$5,\"\",1))","v":""},{"$f":"IF(COUNTA(D82:D83,D88)-COUNTBLANK(D81)<=2,\"\",IF($C$15=Info!$A$5,\"\",1))","v":""},{"$f":"IF(COUNTA(E82:E83,E88)-COUNTBLANK(E81)<=2,\"\",IF($C$15=Info!$A$5,\"\",1))","v":""},{"$f":"IF(COUNTA(F82:F83,F88)-COUNTBLANK(F81)<=2,\"\",IF($C$15=Info!$A$5,\"\",1))","v":""},{"$f":"IF(COUNTA(G82:G83,G88)-COUNTBLANK(G81)<=2,\"\",IF($C$15=Info!$A$5,\"\",1))","v":""},{"$f":"IF(COUNTA(H82:H83,H88)-COUNTBLANK(H81)<=2,\"\",IF($C$15=Info!$A$5,\"\",1))","v":""},{"$f":"IF(COUNTA(I82:I83,I88)-COUNTBLANK(I81)<=2,\"\",IF($C$15=Info!$A$5,\"\",1))","v":""},{"$f":"IF(COUNTA(J82:J83,J88)-COUNTBLANK(J81)<=2,\"\",IF($C$15=Info!$A$5,\"\",1))","v":""}]
[null,"Technical Supervisor",{"$f":"IF(C101=\"\",\"\",IF($B$99=\"Technical Supervisor\",1+C99,1))","v":""},{"$f":"IF(D101=\"\",\"\",IF($B$99=\"Technical Supervisor\",1+D99,1))","v":""},"","","","","",""]
[null,"TOTAL TECH STAFF (per day)",{"$f":"IF(SUM(C96:C103)=0,\"\",SUM(C96:C103))","v":""},"","","","","","",{"$f":"IF(SUM(J96:J103)=0,\"\",SUM(J96:J103))","v":""}]
[]
[null,"Front of House"]
[null,"Additional Usher(s)"]
[null,"Ushers",{"$f":"IF(C93=\"\",\"\",Fees!$E$32)","v":""},{"$f":"IF(D93=\"\",\"\",Fees!$E$32)","v":""},{"$f":"IF(E93=\"\",\"\",Fees!$E$32)","v":""},{"$f":"IF(F93=\"\",\"\",Fees!$E$32)","v":""},{"$f":"IF(G93=\"\",\"\",Fees!$E$32)","v":""},{"$f":"IF(H93=\"\",\"\",Fees!$E$32)","v":""},{"$f":"IF(I93=\"\",\"\",Fees!$E$32)","v":""},{"$f":"IF(J93=\"\",\"\",Fees!$E$32)","v":""}]
[null,"Front Door Usher",{"$f":"IF(C93=\"Yes\",1,\"\")","v":""},{"$f":"IF(D93=\"Yes\",1,\"\")","v":""},"","","","","",""]
[null,"TOTAL USHERS (per day)",{"$f":"IF(SUM(C107:C109)=0,\"\",SUM(C107:C109))","v":""},"","","","","","",""]
[]
[null,"CALENDAR DAY","Day 9","Day 10","Day 11","Day 12","Day 13","Day 14","Day 15","Day 16"]
[null,null,{"$f":"IF(ISBLANK($C$51),\"\",$C$51)","v":""},{"$f":"IF(ISBLANK($C$52),\"\",$C$52)","v":""},{"$f":"IF(ISBLANK($C$53),\"\",$C$53)","v":""},{"$f":"IF(ISBLANK($C$54),\"\",$C$54)","v":""},{"$f":"IF(ISBLANK($C$55),\"\",$C$55)","v":""},{"$f":"IF(ISBLANK($C$56),\"\",$C$56)","v":""},{"$f":"IF(ISBLANK($C$57),\"\",$C$57)","v":""},{"$f":"IF(ISBLANK($C$58),\"\",$C$58)","v":""}]
[null,"Stage Access - start time (Load In)"]
[null,"Stage Access - end time"]
[null,"Lobby access time for setup"]
[null,"Doors opening to public"]
[null,"Show Start Time"]
[null,"Show End Time"]
[null,"End of Day - Closed"]
[null,"Number of Intermissions"]
[null,"Length of Intermission"]
[null,"Number of Shows"]
[null,"Total Attendance (Expected or Actual)"]
[null,"Show Day?",{"$f":"IF(AND(COUNT(C123,C124,C122,C121,C113,C120,C114,C115,C117,C118,C119)>=11,C126=Info!$B$8),\"Yes\",\"\")","v":""},{"$f":"IF(AND(COUNT(D123,D124,D122,D121,D113,D120,D114,D115,D117,D118,D119)>=11,D126=Info!$B$8),\"Yes\",\"\")","v":""},{"$f":"IF(AND(COUNT(E123,E124,E122,E121,E113,E120,E114,E115,E117,E118,E119)>=11,E126=Info!$B$8),\"Yes\",\"\")","v":""},{"$f":"IF(AND(COUNT(F123,F124,F122,F121,F113,F120,F114,F115,F117,F118,F119)>=11,F126=Info!$B$8),\"Yes\",\"\")","v":""},{"$f":"IF(AND(COUNT(G123,G124,G122,G121,G113,G120,G114,G115,G117,G118,G119)>=11,G126=Info!$B$8),\"Yes\",\"\")","v":""},{"$f":"IF(AND(COUNT(H123,H124,H122,H121,H113,H120,H114,H115,H117,H118,H119)>=11,H126=Info!$B$8),\"Yes\",\"\")","v":""},{"$f":"IF(AND(COUNT(I123,I124,I122,I121,I113,I120,I114,I115,I117,I118,I119)>=11,I126=Info!$B$8),\"Yes\",\"\")","v":""},{"$f":"IF(AND(COUNT(J123,J124,J122,J121,J113,J120,J114,J115,J117,J118,J119)>=11,J126=Info!$B$8),\"Yes\",\"\")","v":""}]
[null,null,{"$f":"IF(AND(COUNT(C114:C115,C120)+COUNT(C113)=4,C120-C119>=0,C119-C118>=0,C118-C117>=0,C115-C114>=0),Info!$B$8,\"\")","v":""},{"$f":"IF(AND(COUNT(D114:D115,D120)+COUNT(D113)=4,D120-D119>=0,D119-D118>=0,D118-D117>=0,D115-D114>=0),Info!$B$8,\"\")","v":""},{"$f":"IF(AND(COUNT(E114:E115,E120)+COUNT(E113)=4,E120-E119>=0,E119-E118>=0,E118-E117>=0,E115-E114>=0),Info!$B$8,\"\")","v":""},{"$f":"IF(AND(COUNT(F114:F115,F120)+COUNT(F113)=4,F120-F119>=0,F119-F118>=0,F118-F117>=0,F115-F114>=0),Info!$B$8,\"\")","v":""},{"$f":"IF(AND(COUNT(G114:G115,G120)+COUNT(G113)=4,G120-G119>=0,G119-G118>=0,G118-G117>=0,G115-G114>=0),Info!$B$8,\"\")","v":""},{"$f":"IF(AND(COUNT(H114:H115,H120)+COUNT(H113)=4,H120-H119>=0,H119-H118>=0,H118-H117>=0,H115-H114>=0),Info!$B$8,\"\")","v":""},{"$f":"IF(AND(COUNT(I114:I115,I120)+COUNT(I113)=4,I120-I119>=0,I119-I118>=0,I118-I117>=0,I115-I114>=0),Info!$B$8,\"\")","v":""}]
[null,"Additional Tech Staffing"]
[]
[]
[]
[]
[null,"Required Tech Staffing"]
[null,null,{"$f":"IF(COUNTA(C113:C114,C120)-COUNTBLANK(C112)<=2,\"\",IF($C$15=Info!$A$5,1,1))","v":""},{"$f":"IF(COUNTA(D113:D114,D120)-COUNTBLANK(D112)<=2,\"\",IF($C$15=Info!$A$5,1,1))","v":""},{"$f":"IF(COUNTA(E113:E114,E120)-COUNTBLANK(E112)<=2,\"\",IF($C$15=Info!$A$5,1,1))","v":""},{"$f":"IF(COUNTA(F113:F114,F120)-COUNTBLANK(F112)<=2,\"\",IF($C$15=Info!$A$5,1,1))","v":""},{"$f":"IF(COUNTA(G113:G114,G120)-COUNTBLANK(G112)<=2,\"\",IF($C$15=Info!$A$5,1,1))","v":""},{"$f":"IF(COUNTA(H113:H114,H120)-COUNTBLANK(H112)<=2,\"\",IF($C$15=Info!$A$5,1,1))","v":""},{"$f":"IF(COUNTA(I113:I114,I120)-COUNTBLANK(I112)<=2,\"\",IF($C$15=Info!$A$5,1,1))","v":""},{"$f":"IF(COUNTA(J113:J114,J120)-COUNTBLANK(J112)<=2,\"\",IF($C$15=Info!$A$5,1,1))","v":""}]
[null,null,{"$f":"IF(COUNTA(C114:C115,C120)-COUNTBLANK(C113)<=2,\"\",IF($C$15=Info!$A$5,\"\",1))","v":""},{"$f":"IF(COUNTA(D114:D115,D120)-COUNTBLANK(D113)<=2,\"\",IF($C$15=Info!$A$5,\"\",1))","v":""},{"$f":"IF(COUNTA(E114:E115,E120)-COUNTBLANK(E113)<=2,\"\",IF($C$15=Info!$A$5,\"\",1))","v":""},{"$f":"IF(COUNTA(F114:F115,F120)-COUNTBLANK(F113)<=2,\"\",IF($C$15=Info!$A$5,\"\",1))","v":""},{"$f":"IF(COUNTA(G114:G115,G120)-COUNTBLANK(G113)<=2,\"\",IF($C$15=Info!$A$5,\"\",1))","v":""},{"$f":"IF(COUNTA(H114:H115,H120)-COUNTBLANK(H113)<=2,\"\",IF($C$15=Info!$A$5,\"\",1))","v":""},{"$f":"IF(COUNTA(I114:I115,I120)-COUNTBLANK(I113)<=2,\"\",IF($C$15=Info!$A$5,\"\",1))","v":""},{"$f":"IF(COUNTA(J114:J115,J120)-COUNTBLANK(J113)<=2,\"\",IF($C$15=Info!$A$5,\"\",1))","v":""}]
[null,"Technical Supervisor",{"$f":"IF(C133=\"\",\"\",IF($B$131=\"Technical Supervisor\",1+C131,1))","v":""},{"$f":"IF(D133=\"\",\"\",IF($B$131=\"Technical Supervisor\",1+D131,1))","v":""},"","","","","",""]
[null,"TOTAL TECH STAFF (per day)",{"$f":"IF(SUM(C128:C135)=0,\"\",SUM(C128:C135))","v":""},"","","","","","",""]
[]
[null,"Front of House"]
[null,"Additional Usher(s)"]
[null,"Ushers",{"$f":"IF(C125=\"\",\"\",Fees!$E$32)","v":""},{"$f":"IF(D125=\"\",\"\",Fees!$E$32)","v":""},{"$f":"IF(E125=\"\",\"\",Fees!$E$32)","v":""},{"$f":"IF(F125=\"\",\"\",Fees!$E$32)","v":""},{"$f":"IF(G125=\"\",\"\",Fees!$E$32)","v":""},{"$f":"IF(H125=\"\",\"\",Fees!$E$32)","v":""},{"$f":"IF(I125=\"\",\"\",Fees!$E$32)","v":""},{"$f":"IF(J125=\"\",\"\",Fees!$E$32)","v":""}]
[null,"Front Door Usher",{"$f":"IF(C125=\"Yes\",1,\"\")","v":""},{"$f":"IF(D125=\"Yes\",1,\"\")","v":""},"","","","","",""]
[null,"TOTAL USHERS (per day)",{"$f":"IF(SUM(C139:C141)=0,\"\",SUM(C139:C141))","v":""},{"$f":"IF(SUM(D139:D141)=0,\"\",SUM(D139:D141))","v":""},"","","","","",""]
[]
[]
[null,"Will there be any of the following:"]
[null,"Set construction?",null,null,"Lighting hangs or focused lights?"]
[null,"Multi-level stage and platform products?",null,null,"Speeches?"]
[null,"Risers exceeding 4 feet?",null,null,"Live music performances?"]
[null,"Aeriel performances?",null,null,"Changes to the house plot?"]
[null,"Use of weapons or stage combat?",null,null,"Follow spots?"]
[null,"Use of pyro technics and live flame?",null,null,"Booms for side lights from the wings?"]
[null,"Use of audience on stage?",null,null,"Projection of images, videos, PowerPoint, etc."]
[null,"Use of animals?",null,null,"Spotlights and/or special lighting?"]
[null,"Rigging such as banners, backdrops or signs?",null,null,"Orchestra pit?"]
[]
[null,"L O B B Y"]
[null,"CALENDAR DAY","Day 1","Day 2","Day 3","Day 4","Day 5","Day 6","Day 7","Day 8"]
[null,null,{"$f":"IF(ISBLANK($C$43),\"\",$C$43)","v":""},{"$f":"IF(ISBLANK($C$44),\"\",$C$44)","v":""},{"$f":"IF(ISBLANK($C$45),\"\",$C$45)","v":""},{"$f":"IF(ISBLANK($C$46),\"\",$C$46)","v":""},{"$f":"IF(ISBLANK($C$47),\"\",$C$47)","v":""},{"$f":"IF(ISBLANK($C$48),\"\",$C$48)","v":""},{"$f":"IF(ISBLANK($C$49),\"\",$C$49)","v":""},{"$f":"IF(ISBLANK($C$50),\"\",$C$50)","v":""}]
[null,"Lobby access time for setup",{"$f":"IF(C160=\"\",\"\",C$84)","v":""},"","","","","","",""]
[null,"Doors opening to public"]
[null,"End Time"]
[null,null,{"$f":"IF(COUNTA(C160:C161)+COUNT(C158)=3,\"Booked\",IF(C93=\"Yes\",\"Required\",\"\"))","v":""},"","","","","","",""]
[]
[null,"CALENDAR DAY","Day 9","Day 10","Day 11","Day 12","Day 13","Day 14","Day 15","Day 16"]
[null,null,{"$f":"IF(ISBLANK($C$51),\"\",$C$51)","v":""},{"$f":"IF(ISBLANK($C$52),\"\",$C$52)","v":""},{"$f":"IF(ISBLANK($C$53),\"\",$C$53)","v":""},{"$f":"IF(ISBLANK($C$54),\"\",$C$54)","v":""},{"$f":"IF(ISBLANK($C$55),\"\",$C$55)","v":""},{"$f":"IF(ISBLANK($C$56),\"\",$C$56)","v":""},{"$f":"IF(ISBLANK($C$57),\"\",$C$57)","v":""},{"$f":"IF(ISBLANK($C$58),\"\",$C$58)","v":""}]
[null,"Lobby access time for setup",{"$f":"IF(C167=\"\",\"\",C$116)","v":""},"","","","","","",""]
[null,"Doors opening to public"]
[null,"End Time"]
[null,null,{"$f":"IF(COUNTA(C167:C168)+COUNT(C165)=3,\"Booked\",IF(C99=\"Yes\",\"Required\",\"\"))","v":""},"","","","","","",""]
[null,"Will you have a lobby display?"]
[null,"Will you have vendors?"]
[null,"Will you and the vendors requires tables and chairs? "]
[null,"Number of Chairs"]
[null,"Number of Tables - No Linens provided"]
[null,"Will there be food distributed?"]
[null,"There be a live feed of the event on lobby screens",null,"Yes"]
[]
[null," A D D I T I O N A L    N O T E S"]
[]
[null,"F E E    S C H E D U L E"]
[null,{"$f":"Fees!A6","v":"Rates in effect January 2019 - December 2019"}]
[null,"M A N D A T O R Y  C O S T S",null,null,null,null,"COST","DAYS / HOURS","RECONCILIATION (OFFICE USE ONLY)","TOTAL"]
[null,{"$f":"Fees!A9","v":"Rehearsal Hall"},"MANDATORY if space is utilized",null,null,null,{"$f":"H245","v":""},{"$f":"IF(Info!$C$118=1,0,CONCATENATE(Info!D44,\" Day\"))","v":0},null,{"$f":"IF(Info!$C$118=1,0,Info!D45+I183)","v":0}]
[null,{"$f":"Fees!A8","v":"Theatre Auditorium"},"MANDATORY if space is utilized",null,null,null,{"$f":"H243","v":""},{"$f":"IF(Info!$C$118=1,0,CONCATENATE(Info!B44,\" Day\"))","v":0},null,{"$f":"IF(Info!$C$118=1,0,Info!B45+I184)","v":0}]
[null,{"$f":"Fees!A10","v":"Lobby"},"MANDATORY if space is utilized",null,null,null,{"$f":"H244","v":""},{"$f":"IF(Info!$C$118=1,0,CONCATENATE(Info!C44,\" Day\"))","v":0},null,{"$f":"IF(Info!$C$118=1,0,Info!C45+I185)","v":0}]
[null,{"$f":"Fees!A30","v":"Front of House Coordinator"},"MANDATORY if utilized\n3hr min/day/staff",null,null,null,{"$f":"CONCATENATE(\"$\",Info!AF3,\"/hour/staff\")","v":"$48.5/hour/staff"},{"$f":"IF(Info!$C$118=1,0,CONCATENATE(TEXT(Info!AF7,\"0.0\"),\" hrs\"))","v":0},null,{"$f":"IF(Info!$C$118=1,0,Info!AF8+(I186*Info!$AF$3))","v":0}]
[null,{"$f":"Fees!A32","v":"Front of House Usher"},"MANDATORY if utilized\n4hr min/day/staff",null,null,null,{"$f":"CONCATENATE(\"$\",Info!AG3,\"/hour/staff\")","v":"$19.5/hour/staff"},{"$f":"IF(Info!$C$118=1,0,CONCATENATE(TEXT(Info!AG7,\"0.0\"),\" hrs\"))","v":0},null,{"$f":"IF(Info!$C$118=1,0,Info!AG8+(Info!AG3*I187))","v":0}]
[null,{"$f":"Fees!A29","v":"Technical Supervisor"},"MANDATORY if utilized\n4hr min/day/staff",null,null,null,{"$f":"CONCATENATE(\"$\",Info!AD3,\"/hour/staff\")","v":"$48.5/hour/staff"},{"$f":"IF(Info!$C$118=1,0,CONCATENATE(TEXT(Info!AD7,\"0.0\"),\" hrs\"))","v":0},null,{"$f":"IF(Info!$C$118=1,0,Info!AD8+(Info!AD3*I188))","v":0}]
[null,{"$f":"Fees!A31","v":"Technician"},"MANDATORY if utilized\n4hr min/day/staff",null,null,null,{"$f":"CONCATENATE(\"$\",Info!AE3,\"/hour/staff\")","v":"$26/hour/staff"},{"$f":"IF(Info!$C$118=1,0,CONCATENATE(TEXT(Info!AE7,\"0.0\"),\" hrs\"))","v":0},null,{"$f":"IF(Info!$C$118=1,0,Info!AE8+(Info!AE3*I189))","v":0}]
[null,{"$f":"Fees!A36","v":"Community Access Fund Fee"},"MANDATORY per ticket fee",null,null,null,{"$f":"CONCATENATE(\"$\",Info!AK3,\"0 /ticket\")","v":"$1.50 /ticket"},null,null,{"$f":"IF(Info!$C$118=1,0,Info!AK6+I190)","v":0}]
[null,{"$f":"Fees!A41","v":"Ticket Printing"},"MANDATORY",null,null,null,{"$f":"CONCATENATE(\"$\",Info!AH3,\"0 /ticket\")","v":"$0.20 /ticket"},{"$f":"CONCATENATE(I62,\" tickets\")","v":"0 tickets"},null,{"$f":"IFERROR(I62*Info!AH3+I2164+I191,0)","v":0}]
[null,{"$f":"Fees!A35","v":"Box Office Commission"},"MANDATORY when using Box Office to sell tickets",null,null,null,{"$f":"CONCATENATE(Info!AL6,\"% of net ticket sales\")","v":"7% of net ticket sales"},null,null,{"$f":"IF(Info!$C$118=1,0,I192)","v":0}]
[null,{"$f":"Fees!A40","v":"Cleaning Fee"},"MANDATORY per hour",null,null,null,null,null,null,{"$f":"IF(Info!$C$118=1,0,I193)","v":0}]
[null,"NOTES (for office use)"]
[]
[null,"O P T I O N A L  C O S T S",null,null,null,null,"REQUESTED","TOTAL USAGES","RECONCILIATION (OFFICE USE ONLY)","TOTAL "]
[null,{"$f":"Fees!A48","v":"Insurance Purchased through the City, includes taxes at 8%"},"OPTIONAL or proof of insurance must be submitted",null,null,null,{"$f":"IF($C$28=\"\",\"\",$C$28)","v":""},{"$f":"IF(OR(G197=\"No\",G197=\"\"),\"\",IF(Info!$C$118=1,0,CONCATENATE($I$63,\" Uses\")))","v":""},null,{"$f":"IF(Info!$C$118=1,0,IF(OR(G197=\"No\",G197=\"\"),0,IF(C29=\"2 million\",Info!$AQ$3*$I$63+$I$197,Info!$AQ$4*$I$63+$I$197)))","v":0}]
[null,{"$f":"Fees!A37","v":"Piano"},"OPTIONAL includes tuning",null,null,null,null,null,null,{"$f":"IF(Info!$C$118=1,0,IF(G198=\"Yes\",H198*Info!AO3)+$I198)","v":0}]
[null,{"$f":"Fees!A14","v":"Fog Machine"},"OPTIONAL",null,null,null,null,null,null,{"$f":"IF(Info!$C$118=1,0,IF(G199=\"Yes\",$I199,0))","v":0}]
[null,{"$f":"Fees!A15","v":"Hazer"},"OPTIONAL",null,null,null,null,null,null,{"$f":"IF(Info!$C$118=1,0,IF(G200=\"Yes\",$I200,0))","v":0}]
[null,{"$f":"Fees!A16","v":"Wireless Microphones"},"OPTIONAL 12 body packs and 6 hand helds - cannot exceed 12",null,null,null,null,null,null,{"$f":"IF(Info!$C$118=1,0,IF(G201=\"Yes\",$I201,0))","v":0}]
[null,{"$f":"Fees!A18","v":"Wireless Communication Pack"},"OPTIONAL Limited to 6 connections",null,null,null,null,null,null,{"$f":"IF(Info!$C$118=1,0,IF(G202=\"Yes\",$I202,0))","v":0}]
[null,{"$f":"Fees!A17","v":"Intelligent Lighting Package"},"OPTIONAL Consists of 8 fixtures",null,null,null,null,null,null,{"$f":"IF(Info!$C$118=1,0,IF(G203=\"Yes\",$I203,0))","v":0}]
[null,{"$f":"Fees!A26","v":"Glow Tape (per foot)"},"OPTIONAL or will be charged if used by tech staff",null,null,null,{"$f":"CONCATENATE(\"$\",Info!AM3,\"0 per foot\")","v":"$1.50 per foot"},null,null,{"$f":"IF(Info!$C$118=1,0,(Info!$AM$3*'Fee Estimate Tool'!H204)+I204)","v":0}]
[null,{"$f":"Fees!A27","v":"Gaff Tape"},"OPTIONAL or will be charged if used by tech staff",null,null,null,{"$f":"CONCATENATE(\"$\",Info!AN3,\".00 per roll\")","v":"$40.00 per roll"},null,null,{"$f":"IF(Info!$C$118=1,0,(Info!AN3*'Fee Estimate Tool'!H205)+I205)","v":0}]
[null,"Other 1",null,null,null,null,null,null,null,{"$f":"I206","v":0}]
[null,"Other 2",null,null,null,null,null,null,null,{"$f":"I207","v":0}]
[null,"NOTES (for office use)"]
[]
[null,"Rental Subtotal Fees",null,null,null,null,"Rental Subtotal Fees",{"$f":"SUM(J183:J185)","v":0},null,{"$f":"SUM(J183:J185)","v":0}]
[null,"Extra Fees Subtotal",null,null,null,null,null,{"$f":"SUM(J198:J207)+SUM(J186:J192)+J193","v":0}]
[null,{"$f":"Info!X1","v":"HST"},null,null,null,null,{"$f":"Info!X3","v":0.13},null,null,{"$f":"IFERROR((H210+H211)*Info!X3,0)","v":0}]
[null,{"$f":"Info!Y1","v":"Late Use Charge per hour (tax)"},null,null,null,null,{"$f":"CONCATENATE(\"$\",Info!Y3,\" /hour\")","v":"$140 /hour"},{"$f":"IF(Info!$C$118=1,0,CONCATENATE(Info!Y7,\" hours\"))","v":0},0,{"$f":"IF(Info!$C$118=1,0,Info!$Y$8)","v":0}]
[null,"Scheduling Penalty / Staff Occurrence",null,null,null,null,{"$f":"CONCATENATE(\"$\",Info!W3)","v":"$20"},null,null,{"$f":"IF(Info!$C$118=1,0,I214*Info!$W$3)","v":0}]
[null,"Late Payment Interest",null,null,null,null,{"$f":"CONCATENATE(Info!Z6,\" /month\")","v":"1.25% /month"}]
[null,"Non-Sufficient Funds (NSF) Charge",null,null,null,null,{"$f":"CONCATENATE(Info!AA6,\"/chq\")","v":"$40.00/chq"}]
[null,"T O T A L",null,null,null,null,null,{"$f":"IF(Info!$C$118=1,Info!$C$119,J216+J215+J214+J213+J212+H211+J197+H210)","v":"Missing Information"}]
[]
[null,"INITIAL DEPOSIT",null,null,null,null,null,{"$f":"IFERROR(IF(C62=\"Yes\",H217*Fees!B66,H217*Fees!B65),\"\")","v":""}]
[]
[null,"FEES EXCLUDE"]
[null,"◦ Third party security and first aid"]
[null,"◦ Insurance providers"]
[null,"◦ All other external consultation and services"]
[null,"◦ All other City of Mississauga charges not listed here"]
[null,"PAYMENT SCHEDULE"]
[null,"◦ Initial payment of a non-refundable deposit equal to 20% of the total estimated fees (including tax), as outlined in the Facility Rental Contract, required at time of booking\n"]
[null,"◦ Full payment of the balance of estimated event fees due no later than 10 business days prior to the reserved date"]
[null,"◦ Payment of additional charges incurred after this date due 30 calendar days from the final invoice date"]
[null,"Standard payment terms for Meadowvale Theatre when NOT using Meadowvale Theatre box office services are:"]
[null,"◦ An initial payment of a non-refundable deposit equal to 50% of the total estimated fees (including tax), as outlined in the Facility Rental Contract, required at time of booking"]
[null,"◦ Full payment of the balance of estimated event fees due no later than 30 calendar days prior to reserved date"]
[null,"◦ Payment of additional charges incurred after this date due 30 calendar days from the final invoice date"]
[null,"NOTE"]
[null,"◦ Minmum Box Office Commission: $300"]
[null,"◦ Facility and User Insurance may be purchased through the City of Mississauga User Insurance Program"]
[null,"◦ SOCAN. and RESOUND fees will be applied based on the quote"]
[null,"◦ http://www.mississauga.ca/portal/residents/facilityinsurance"]
[null,"https://culture.mississauga.ca/meadowvale-theatre"]
[]
[null,null,null,"FEES & CHARGES SCHEDULE (Pre-Tax)"]
[null,null,null,"RENTAL SPACES (per day)",null,null,{"$f":"CONCATENATE(C15,\" Rate\")","v":" Rate"}]
[null,null,null,{"$f":"Info!B1","v":"Theatre Auditorium"},null,null,null,{"$f":"IF($C$15=\"\",\"\",CONCATENATE(\"$\",INDEX(Info!$B$3:$E$6,MATCH($C$15,Info!$A$3:$A$6,0),MATCH($D243,Info!$B$1:$E$1,0)),\" day\"))","v":""}]
[null,null,null,{"$f":"Info!C1","v":"Lobby"},null,null,null,{"$f":"IF($C$15=\"\",\"\",CONCATENATE(\"$\",INDEX(Info!$B$3:$E$6,MATCH($C$15,Info!$A$3:$A$6,0),MATCH($D244,Info!$B$1:$E$1,0)),\" day\"))","v":""}]
[null,null,null,{"$f":"Info!D1","v":"Rehearsal Hall"},null,null,null,{"$f":"IF($C$15=\"\",\"\",CONCATENATE(\"$\",INDEX(Info!$B$3:$E$6,MATCH($C$15,Info!$A$3:$A$6,0),MATCH($D245,Info!$B$1:$E$1,0)),\" day\"))","v":""}]
[null,null,null,"TECHNICAL SERVICES STAFFING"]
[null,null,null,{"$f":"Info!AD1","v":"Technical Supervisor"},null,null,null,{"$f":"G188","v":"$48.5/hour/staff"}]
[null,null,null,{"$f":"Info!AE1","v":"Technician"},null,null,null,{"$f":"G189","v":"$26/hour/staff"}]
[null,null,null,"EQUIPMENT"]
[null,null,null,{"$f":"Info!H1","v":"Fog Machine"},null,null,null,{"$f":"IF($C$15=\"\",\"\",CONCATENATE(\"$\",INDEX(Info!$H$3:$M$6,MATCH($C$15,Info!$A$3:$A$6,0),MATCH($D250,Info!$H$1:$M$1,0)),\" /day vs. $\",INDEX(Info!$Q$3:$V$6,MATCH($C$15,Info!$A$3:$A$6,0),MATCH($D250,Info!$H$1:$M$1,0)),\" /week\"))","v":""}]
[null,null,null,{"$f":"Info!I1","v":"Hazer"},null,null,null,{"$f":"IF($C$15=\"\",\"\",CONCATENATE(\"$\",INDEX(Info!$H$3:$M$6,MATCH($C$15,Info!$A$3:$A$6,0),MATCH($D251,Info!$H$1:$M$1,0)),\" /day vs. $\",INDEX(Info!$Q$3:$V$6,MATCH($C$15,Info!$A$3:$A$6,0),MATCH($D251,Info!$H$1:$M$1,0)),\" /week\"))","v":""}]
[null,null,null,{"$f":"Info!J1","v":"Wireless Microphones"},null,null,null,{"$f":"IF($C$15=\"\",\"\",CONCATENATE(\"$\",INDEX(Info!$H$3:$M$6,MATCH($C$15,Info!$A$3:$A$6,0),MATCH($D252,Info!$H$1:$M$1,0)),\" /day vs. $\",INDEX(Info!$Q$3:$V$6,MATCH($C$15,Info!$A$3:$A$6,0),MATCH($D252,Info!$H$1:$M$1,0)),\" /week\"))","v":""}]
[null,null,null,{"$f":"Info!L1","v":"Intelligent Lighting Package"},null,null,null,{"$f":"IF($C$15=\"\",\"\",CONCATENATE(\"$\",INDEX(Info!$H$3:$M$6,MATCH($C$15,Info!$A$3:$A$6,0),MATCH($D253,Info!$H$1:$M$1,0)),\" /day vs. $\",INDEX(Info!$Q$3:$V$6,MATCH($C$15,Info!$A$3:$A$6,0),MATCH($D253,Info!$H$1:$M$1,0)),\" /week\"))","v":""}]
[null,null,null,{"$f":"Info!M1","v":"Wireless Communication Pack"},null,null,null,{"$f":"IF($C$15=\"\",\"\",CONCATENATE(\"$\",INDEX(Info!$H$3:$M$6,MATCH($C$15,Info!$A$3:$A$6,0),MATCH($D254,Info!$H$1:$M$1,0)),\" /day vs. $\",INDEX(Info!$Q$3:$V$6,MATCH($C$15,Info!$A$3:$A$6,0),MATCH($D254,Info!$H$1:$M$1,0)),\" /week\"))","v":""}]
[null,null,null,{"$f":"Info!AM1","v":"Glow Tape (per foot)"},null,null,null,{"$f":"Info!AM6","v":"$1.50"}]
[null,null,null,{"$f":"Info!AN1","v":"Gaff Tape"},null,null,null,{"$f":"Info!AN6","v":"$40.00"}]
[null,null,null,"FRONT OF HOUSE STAFFING"]
[null,null,null,{"$f":"Info!AF1","v":"Front of House Coordinator"},null,null,null,{"$f":"G186","v":"$48.5/hour/staff"}]
[null,null,null,{"$f":"Info!AG1","v":"Front of House Usher"},null,null,null,{"$f":"G187","v":"$19.5/hour/staff"}]
[null,null,null,"BOX OFFICE SERVICES"]
[null,null,null,{"$f":"Info!AH1","v":"Ticket Printing"},null,null,null,{"$f":"G191","v":"$0.20 /ticket"}]
[null,null,null,{"$f":"Info!AK1","v":"Community Access Fund Fee"},null,null,null,{"$f":"G190","v":"$1.50 /ticket"}]
[null,null,null,{"$f":"Info!AL1","v":"Box Office Commission"},null,null,null,{"$f":"G192","v":"7% of net ticket sales"}]
[null,null,null,{"$f":"Info!Y1","v":"Late Use Charge per hour (tax)"},null,null,null,{"$f":"Info!Y6","v":"$140.00"}]

{"sheet":"Info","index":1,"n_rows":120,"n_cols":53,"rows_kept":120,"cut":false,"hidden":true,"merged":[]}
[null,"Theatre Auditorium","Lobby","Rehearsal Hall","Green Room",null,"DAILY TERMS - >",{"$f":"Fees!A14","v":"Fog Machine"},{"$f":"Fees!A15","v":"Hazer"},{"$f":"Fees!A16","v":"Wireless Microphones"},{"$f":"Fees!#REF!","v":{"$error":"#REF!"}},{"$f":"Fees!A17","v":"Intelligent Lighting Package"},{"$f":"Fees!A18","v":"Wireless Communication Pack"},null,null,"WEEKLY TERMS - >",{"$f":"H1","v":"Fog Machine"},"Hazer","Wireless Microphones",{"$error":"#REF!"},"Intelligent Lighting Package","Wireless Communication Pack",{"$f":"Fees!A43","v":"Meal Charges (per person, per infringement)"},{"$f":"Fees!A44","v":"HST"},{"$f":"Fees!A34","v":"Late Use Charge per hour (tax)"},{"$f":"Fees!A45","v":"Late Payment Interest"},{"$f":"Fees!A46","v":"Non-Sufficient Funds (NSF) Charge"},null,null,{"$f":"Fees!A29","v":"Technical Supervisor"},{"$f":"Fees!A31","v":"Technician"},{"$f":"Fees!A30","v":"Front of House Coordinator"},{"$f":"Fees!A32","v":"Front of House Usher"},{"$f":"Fees!A41","v":"Ticket Printing"},null,null,{"$f":"Fees!A36","v":"Community Access Fund Fee"},{"$f":"Fees!A35","v":"Box Office Commission"},{"$f":"Fees!A26","v":"Glow Tape (per foot)"},{"$f":"Fees!A27","v":"Gaff Tape"},{"$f":"Fees!A37","v":"Piano"},null,{"$f":"Fees!A48","v":"Insurance Purchased through the City, includes taxes at 8%"},null,"TIME Drop Down","Lobby Access Time","Number of Intermissions","Intermission Lengths","Number of Shows","Earlies and Latest Time",null,"IMPORTANT NOTES"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Do not edit or touch the cells in black, you will break the formulas","example"]
[{"$f":"Fees!B7","v":"Registered Not-for-Profit / Community Group"},{"$f":"Fees!B8","v":314},{"$f":"Fees!B10","v":320},{"$f":"Fees!B9","v":122},{"$f":"Fees!B11","v":0},null,null,{"$f":"Fees!B14","v":25},{"$f":"Fees!B15","v":25},{"$f":"Fees!B16","v":35},{"$f":"Fees!#REF!","v":{"$error":"#REF!"}},{"$f":"Fees!B17","v":300},{"$f":"Fees!B18","v":35},null,null,null,{"$f":"Fees!B20","v":75},{"$f":"Fees!B21","v":75},{"$f":"Fees!B22","v":100},{"$f":"Fees!#REF!","v":{"$error":"#REF!"}},{"$f":"Fees!B23","v":300},{"$f":"Fees!B24","v":100},{"$f":"Fees!B43","v":20},{"$f":"Fees!B44","v":0.13},{"$f":"Fees!B34","v":140},{"$f":"Fees!B45","v":1.2500000000000001E-2},{"$f":"Fees!B46","v":40},null,null,{"$f":"Fees!B29","v":48.5},{"$f":"Fees!B31","v":26},{"$f":"Fees!B30","v":48.5},{"$f":"Fees!B32","v":19.5},{"$f":"Fees!B41","v":0.2},null,null,{"$f":"Fees!B36","v":1.5},{"$f":"Fees!B35","v":7.0000000000000007E-2},{"$f":"Fees!B26","v":1.5},{"$f":"Fees!B27","v":40},{"$f":"Fees!B37","v":200},null,{"$f":"Fees!B48","v":42.32},null,null,"00:00:00",0,"00:00:00",1,"07:00:00",null,"Some of these cells are the drop-downs selections and are used in various formulas."]
[{"$f":"Fees!C7","v":"Private"},{"$f":"Fees!C8","v":418},{"$f":"Fees!C10","v":400},{"$f":"Fees!C9","v":155},{"$f":"Fees!C11","v":0},null,null,{"$f":"Fees!C14","v":25},{"$f":"Fees!C15","v":25},{"$f":"Fees!C16","v":35},{"$f":"Fees!#REF!","v":{"$error":"#REF!"}},{"$f":"Fees!C17","v":300},{"$f":"Fees!C18","v":35},null,null,null,{"$f":"Fees!C20","v":75},{"$f":"Fees!C21","v":75},{"$f":"Fees!C22","v":100},{"$f":"Fees!#REF!","v":{"$error":"#REF!"}},{"$f":"Fees!C23","v":300},{"$f":"Fees!C24","v":100},null,null,null,null,null,null,"Minimum Hours ->",{"$f":"Fees!D29","v":4},{"$f":"Fees!D31","v":4},{"$f":"Fees!D30","v":3},{"$f":"Fees!D32","v":3},null,null,null,null,null,null,null,null,null,{"$f":"Fees!C48","v":126.97},null,"05:00:00","00:30:00",1,"00:15:00",2,1.0833333333333299,null,"NOTES FOR Information Tech Team"]
[{"$f":"Fees!D7","v":"Affiliate"},{"$f":"Fees!D8","v":235},{"$f":"Fees!D10","v":183},{"$f":"Fees!D9","v":99},{"$f":"Fees!D11","v":0},null,null,{"$f":"Fees!D14","v":15},{"$f":"Fees!D15","v":15},{"$f":"Fees!D16","v":17.5},{"$f":"Fees!#REF!","v":{"$error":"#REF!"}},{"$f":"Fees!D17","v":300},{"$f":"Fees!D18","v":17.5},null,null,null,{"$f":"Fees!D20","v":60},{"$f":"Fees!D21","v":60},{"$f":"Fees!D22","v":62.5},{"$f":"Fees!#REF!","v":{"$error":"#REF!"}},{"$f":"Fees!D23","v":300},{"$f":"Fees!D24","v":62.5},null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"(AK3*X3)+AK3","v":1.6950000000000001},null,null,null,null,null,null,null,"05:30:00","01:00:00",2,"00:20:00",3,null,null,"Comments for grey cells and black cells explain that cells logic and/or purpose"]
[{"$f":"Fees!E7","v":"Commercial"},{"$f":"Fees!E8","v":627},{"$f":"Fees!E10","v":520},{"$f":"Fees!E9","v":200},{"$f":"Fees!E11","v":0},null,null,{"$f":"Fees!E14","v":25},{"$f":"Fees!E15","v":25},{"$f":"Fees!E16","v":35},{"$f":"Fees!#REF!","v":{"$error":"#REF!"}},{"$f":"Fees!E17","v":300},{"$f":"Fees!E18","v":35},null,null,null,{"$f":"Fees!E20","v":75},{"$f":"Fees!E21","v":75},{"$f":"Fees!E22","v":100},{"$f":"Fees!#REF!","v":{"$error":"#REF!"}},{"$f":"Fees!E23","v":300},{"$f":"Fees!E24","v":100},null,null,{"$f":"TEXT(Y3,\"$0.00\")","v":"$140.00"},{"$f":"TEXT(Z3,\"0.00%\")","v":"1.25%"},{"$f":"TEXT(AA3,\"$0.00\")","v":"$40.00"},null,null,null,null,null,null,{"$f":"IF('Fee Estimate Tool'!C62=\"No\",AH3*'Fee Estimate Tool'!I62,0)","v":0},null,null,{"$f":"AK3*'Fee Estimate Tool'!I62","v":0},{"$f":"AL3*100","v":7.0000000000000009},{"$f":"TEXT(AM3,\"$0.00\")","v":"$1.50"},{"$f":"TEXT(AN3,\"$0.00\")","v":"$40.00"},null,null,null,null,"06:00:00","01:30:00",3,"00:30:00",4,"05:00:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL HOURS",{"$f":"TEXT(SUM(Y43:AA43)+'Fee Estimate Tool'!I213,\"0.0\")","v":"0.0"},null,null,null,"TOTAL HOURS",{"$f":"ROUND(AD44,1)","v":0},{"$f":"ROUND(AE44,1)","v":0},{"$f":"ROUND(AF44+AF82+AF120,1)","v":0},{"$f":"ROUND(AG44+AH44,1)","v":0},null,null,null,null,null,null,null,null,null,null,null,"06:30:00","02:00:00",4,null,null,1.000011574074074]
[null,"Booked",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL COST inc Tax",{"$f":"(SUM(Y44:AA44)+(Y3*'Fee Estimate Tool'!I213))*(1+X3)","v":0},null,null,null,"TOTAL COST",{"$f":"AD7*AD3","v":0},{"$f":"AE7*AE3","v":0},{"$f":"AF7*AF3","v":0},{"$f":"AG7*AG3","v":0},null,null,null,null,null,null,null,null,null,null,null,"07:00:00","02:30:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"07:30:00","03:00:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"B1","v":"Theatre Auditorium"},{"$f":"C1","v":"Lobby"},{"$f":"D1","v":"Rehearsal Hall"},null,{"$f":"CONCATENATE(B1,\" Staffing\")","v":"Theatre Auditorium Staffing"},null,null,null,null,{"$f":"'Fee Estimate Tool'!B109","v":"Front Door Usher"},null,null,null,null,null,null,null,null,null,null,"08:00:00"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Day 1",{"$f":"IFERROR(IF('Fee Estimate Tool'!C$82=\"\",0,IF('Fee Estimate Tool'!C$82<Info!$AX$3,(Info!$AX$3-'Fee Estimate Tool'!C$82)*24,0)),0)","v":0},{"$f":"IFERROR(IF('Fee Estimate Tool'!C$160=\"\",0,IF('Fee Estimate Tool'!C$160<Info!$AX$3,(Info!$AX$3-'Fee Estimate Tool'!C$160)*24,0)),0)","v":0},{"$f":"IFERROR(IF('Fee Estimate Tool'!C$70=\"\",0,IF('Fee Estimate Tool'!C$70<Info!$AX$3,(Info!$AX$3-'Fee Estimate Tool'!C$70)*24,0)),0)","v":0},null,"Day 1 - Staff #",{"$f":"IFERROR(SUM('Fee Estimate Tool'!C103),0)","v":0},{"$f":"IFERROR('Fee Estimate Tool'!C$104-'Fee Estimate Tool'!C$103,0)","v":0},{"$f":"IF(AND('Fee Estimate Tool'!C$93=\"Yes\",AD11=1),1,0)","v":0},{"$f":"IF('Fee Estimate Tool'!C$93=\"Yes\",'Fee Estimate Tool'!C$110-'Fee Estimate Tool'!C$109,0)","v":0},{"$f":"IF('Fee Estimate Tool'!C$93=\"Yes\",'Fee Estimate Tool'!C$109,0)","v":0},null,null,null,null,null,null,null,null,null,null,"08:30:00"]
["Day 1 - Frequency",{"$f":"IF('Fee Estimate Tool'!C94=$B$8,1,0)","v":0},{"$f":"IF('Fee Estimate Tool'!C$162=$B$8,1,0)","v":0},{"$f":"IF('Fee Estimate Tool'!C$72=$B$8,1,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Charge",{"$f":"IFERROR(Y11*$Y$3,0)","v":0},{"$f":"IFERROR(Z11*$Y$3,0)","v":0},{"$f":"IFERROR(AA11*$Y$3,0)","v":0},null,"Hours",{"$f":"IF(COUNTA('Fee Estimate Tool'!C$82,'Fee Estimate Tool'!C$88)<=1,0,IF((('Fee Estimate Tool'!C$88-'Fee Estimate Tool'!C$82)*24)<=$AD$4,$AD$4,('Fee Estimate Tool'!C$88-'Fee Estimate Tool'!C$82)*24))","v":0},{"$f":"IF(COUNTA('Fee Estimate Tool'!C$82,'Fee Estimate Tool'!C$88)<=1,0,IF((('Fee Estimate Tool'!C$88-'Fee Estimate Tool'!C$82)*24)<=AE4,AE4,('Fee Estimate Tool'!C$88-'Fee Estimate Tool'!C$82)*24))","v":0},{"$f":"IF(COUNTA('Fee Estimate Tool'!C$85,'Fee Estimate Tool'!C$88)<=1,0,IF((('Fee Estimate Tool'!C$88-'Fee Estimate Tool'!C$84)*24)<=AF4,AF4,('Fee Estimate Tool'!C$88-'Fee Estimate Tool'!C$84)*24))","v":0},{"$f":"IF(AG11<=0,0,IF(('Fee Estimate Tool'!C$88-'Fee Estimate Tool'!C$86)*24+0.5<=$AG$4,$AG$4,('Fee Estimate Tool'!C$88-'Fee Estimate Tool'!C$86)*24+0.5))","v":0},{"$f":"IF(AH11<=0,0,IF(('Fee Estimate Tool'!C$87-'Fee Estimate Tool'!C$85)*24<=$AG$4,$AG$4,('Fee Estimate Tool'!C$87-'Fee Estimate Tool'!C$85)*24))","v":0},null,null,null,null,null,null,null,null,null,null,"09:00:00"]
["Charge",{"$f":"INDEX($B$3:$E$6,MATCH('Fee Estimate Tool'!$C$15,$A$3:$A$6,0),MATCH($B$1,$B$1:$E$1,0))*B12","v":{"$error":"#N/A"}},{"$f":"INDEX($B$3:$E$6,MATCH('Fee Estimate Tool'!$C$15,$A$3:$A$6,0),MATCH($C$1,$B$1:$E$1,0))*C12","v":{"$error":"#N/A"}},{"$f":"INDEX($B$3:$E$6,MATCH('Fee Estimate Tool'!$C$15,$A$3:$A$6,0),MATCH($D$1,$B$1:$E$1,0))*D12","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Day 2",{"$f":"IFERROR(IF('Fee Estimate Tool'!D$82=\"\",0,IF('Fee Estimate Tool'!D$82<Info!$AX$3,(Info!$AX$3-'Fee Estimate Tool'!D$82)*24,0)),0)","v":0},{"$f":"IFERROR(IF('Fee Estimate Tool'!D$160=\"\",0,IF('Fee Estimate Tool'!D$160<Info!$AX$3,(Info!$AX$3-'Fee Estimate Tool'!D$160)*24,0)),0)","v":0},{"$f":"IFERROR(IF('Fee Estimate Tool'!D$70=\"\",0,IF('Fee Estimate Tool'!D$70<Info!$AX$3,(Info!$AX$3-'Fee Estimate Tool'!D$70)*24,0)),0)","v":0},null,"Day 2 - Staff #",{"$f":"IFERROR(SUM('Fee Estimate Tool'!D$103),0)","v":0},{"$f":"IFERROR('Fee Estimate Tool'!D$104-'Fee Estimate Tool'!D$103,0)","v":0},{"$f":"IF(AND('Fee Estimate Tool'!D$93=\"Yes\",AD13=1),1,0)","v":0},{"$f":"IF('Fee Estimate Tool'!D$93=\"Yes\",'Fee Estimate Tool'!D$110-'Fee Estimate Tool'!D$109,0)","v":0},{"$f":"IF('Fee Estimate Tool'!D$93=\"Yes\",'Fee Estimate Tool'!D$109,0)","v":0},null,null,null,null,null,null,null,null,null,null,"09:30:00"]
["Day 2 - Frequency",{"$f":"IF('Fee Estimate Tool'!D94=$B$8,1,0)","v":0},{"$f":"IF('Fee Estimate Tool'!D$162=$B$8,1,0)","v":0},{"$f":"IF('Fee Estimate Tool'!D$72=$B$8,1,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Charge",{"$f":"IFERROR(Y13*$Y$3,0)","v":0},{"$f":"IFERROR(Z13*$Y$3,0)","v":0},{"$f":"IFERROR(AA13*$Y$3,0)","v":0},null,"Hours",{"$f":"IF(COUNTA('Fee Estimate Tool'!D$82,'Fee Estimate Tool'!D$88)<=1,0,IF((('Fee Estimate Tool'!D$88-'Fee Estimate Tool'!D$82)*24)<=$AD$4,$AD$4,('Fee Estimate Tool'!D$88-'Fee Estimate Tool'!D$82)*24))","v":0},{"$f":"IF(COUNTA('Fee Estimate Tool'!D$82,'Fee Estimate Tool'!D$88)<=1,0,IF((('Fee Estimate Tool'!D$88-'Fee Estimate Tool'!D$82)*24)<=AE4,AE4,('Fee Estimate Tool'!D$88-'Fee Estimate Tool'!D$82)*24))","v":0},{"$f":"IF(COUNTA('Fee Estimate Tool'!D$85,'Fee Estimate Tool'!D$88)<=1,0,IF((('Fee Estimate Tool'!D$88-'Fee Estimate Tool'!D$84)*24)<=AF4,AF4,('Fee Estimate Tool'!D$88-'Fee Estimate Tool'!D$84)*24))","v":0},{"$f":"IF(AG13<=0,0,IF(('Fee Estimate Tool'!D$88-'Fee Estimate Tool'!D$86)*24+0.5<=$AG$4,$AG$4,('Fee Estimate Tool'!D$88-'Fee Estimate Tool'!D$86)*24+0.5))","v":0},{"$f":"IF(AH13<=0,0,IF(('Fee Estimate Tool'!D$87-'Fee Estimate Tool'!D$85)*24<=$AG$4,$AG$4,('Fee Estimate Tool'!D$87-'Fee Estimate Tool'!D$85)*24))","v":0},null,null,null,null,null,null,null,null,null,null,"10:00:00"]
["Charge",{"$f":"INDEX($B$3:$E$6,MATCH('Fee Estimate Tool'!$C$15,$A$3:$A$6,0),MATCH($B$1,$B$1:$E$1,0))*B14","v":{"$error":"#N/A"}},{"$f":"INDEX($B$3:$E$6,MATCH('Fee Estimate Tool'!$C$15,$A$3:$A$6,0),MATCH($C$1,$B$1:$E$1,0))*C14","v":{"$error":"#N/A"}},{"$f":"INDEX($B$3:$E$6,MATCH('Fee Estimate Tool'!$C$15,$A$3:$A$6,0),MATCH($D$1,$B$1:$E$1,0))*D14","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Day 3",{"$f":"IFERROR(IF('Fee Estimate Tool'!E$82=\"\",0,IF('Fee Estimate Tool'!E$82<Info!$AX$3,(Info!$AX$3-'Fee Estimate Tool'!E$82)*24,0)),0)","v":0},{"$f":"IFERROR(IF('Fee Estimate Tool'!E$160=\"\",0,IF('Fee Estimate Tool'!E$160<Info!$AX$3,(Info!$AX$3-'Fee Estimate Tool'!E$160)*24,0)),0)","v":0},{"$f":"IFERROR(IF('Fee Estimate Tool'!E$70=\"\",0,IF('Fee Estimate Tool'!E$70<Info!$AX$3,(Info!$AX$3-'Fee Estimate Tool'!E$70)*24,0)),0)","v":0},null,"Day 3 - Staff #",{"$f":"IFERROR(SUM('Fee Estimate Tool'!E$103),0)","v":0},{"$f":"IFERROR('Fee Estimate Tool'!E$104-'Fee Estimate Tool'!E$103,0)","v":0},{"$f":"IF(AND('Fee Estimate Tool'!E$93=\"Yes\",AD15=1),1,0)","v":0},{"$f":"IF('Fee Estimate Tool'!E$93=\"Yes\",'Fee Estimate Tool'!E$110-'Fee Estimate Tool'!E$109,0)","v":0},{"$f":"IF('Fee Estimate Tool'!E$93=\"Yes\",'Fee Estimate Tool'!E$109,0)","v":0},null,null,null,null,null,null,null,null,null,null,"10:30:00"]
["Day 3 - Frequency",{"$f":"IF('Fee Estimate Tool'!E$94=$B$8,1,0)","v":0},{"$f":"IF('Fee Estimate Tool'!E$162=$B$8,1,0)","v":0},{"$f":"IF('Fee Estimate Tool'!E$72=$B$8,1,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Charge",{"$f":"IFERROR(Y15*$Y$3,0)","v":0},{"$f":"IFERROR(Z15*$Y$3,0)","v":0},{"$f":"IFERROR(AA15*$Y$3,0)","v":0},null,"Hours",{"$f":"IF(COUNTA('Fee Estimate Tool'!E$82,'Fee Estimate Tool'!E$88)<=1,0,IF((('Fee Estimate Tool'!E$88-'Fee Estimate Tool'!E$82)*24)<=$AD$4,$AD$4,('Fee Estimate Tool'!E$88-'Fee Estimate Tool'!E$82)*24))","v":0},{"$f":"IF(COUNTA('Fee Estimate Tool'!E$82,'Fee Estimate Tool'!E$88)<=1,0,IF((('Fee Estimate Tool'!E$88-'Fee Estimate Tool'!E$82)*24)<=AE4,AE4,('Fee Estimate Tool'!E$88-'Fee Estimate Tool'!E$82)*24))","v":0},{"$f":"IF(COUNTA('Fee Estimate Tool'!E$85,'Fee Estimate Tool'!E$88)<=1,0,IF((('Fee Estimate Tool'!E$88-'Fee Estimate Tool'!E$84)*24)<=AF4,AF4,('Fee Estimate Tool'!E$88-'Fee Estimate Tool'!E$84)*24))","v":0},{"$f":"IF(AG15<=0,0,IF(('Fee Estimate Tool'!E$88-'Fee Estimate Tool'!E$86)*24+0.5<=$AG$4,$AG$4,('Fee Estimate Tool'!E$88-'Fee Estimate Tool'!E$86)*24+0.5))","v":0},{"$f":"IF(AH15<=0,0,IF(('Fee Estimate Tool'!E$87-'Fee Estimate Tool'!E$85)*24<=$AG$4,$AG$4,('Fee Estimate Tool'!E$87-'Fee Estimate Tool'!E$85)*24))","v":0},null,null,null,null,null,null,null,null,null,null,"11:00:00"]
["Charge",{"$f":"INDEX($B$3:$E$6,MATCH('Fee Estimate Tool'!$C$15,$A$3:$A$6,0),MATCH($B$1,$B$1:$E$1,0))*B16","v":{"$error":"#N/A"}},{"$f":"INDEX($B$3:$E$6,MATCH('Fee Estimate Tool'!$C$15,$A$3:$A$6,0),MATCH($C$1,$B$1:$E$1,0))*C16","v":{"$error":"#N/A"}},{"$f":"INDEX($B$3:$E$6,MATCH('Fee Estimate Tool'!$C$15,$A$3:$A$6,0),MATCH($D$1,$B$1:$E$1,0))*D16","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Day 4",{"$f":"IFERROR(IF('Fee Estimate Tool'!F$82=\"\",0,IF('Fee Estimate Tool'!F$82<Info!$AX$3,(Info!$AX$3-'Fee Estimate Tool'!F$82)*24,0)),0)","v":0},{"$f":"IFERROR(IF('Fee Estimate Tool'!F$160=\"\",0,IF('Fee Estimate Tool'!F$160<Info!$AX$3,(Info!$AX$3-'Fee Estimate Tool'!F$160)*24,0)),0)","v":0},{"$f":"IFERROR(IF('Fee Estimate Tool'!F$70=\"\",0,IF('Fee Estimate Tool'!F$70<Info!$AX$3,(Info!$AX$3-'Fee Estimate Tool'!F$70)*24,0)),0)","v":0},null,"Day 4 - Staff #",{"$f":"IFERROR(SUM('Fee Estimate Tool'!F$103),0)","v":0},{"$f":"IFERROR('Fee Estimate Tool'!F$104-'Fee Estimate Tool'!F$103,0)","v":0},{"$f":"IF(AND('Fee Estimate Tool'!F$93=\"Yes\",AD17=1),1,0)","v":0},{"$f":"IF('Fee Estimate Tool'!F$93=\"Yes\",'Fee Estimate Tool'!F$110-'Fee Estimate Tool'!F$109,0)","v":0},{"$f":"IF('Fee Estimate Tool'!F$93=\"Yes\",'Fee Estimate Tool'!F$109,0)","v":0},null,null,null,null,null,null,null,null,null,null,"11:30:00"]
["Day 4 - Frequency",{"$f":"IF('Fee Estimate Tool'!F$94=$B$8,1,0)","v":0},{"$f":"IF('Fee Estimate Tool'!F$162=$B$8,1,0)","v":0},{"$f":"IF('Fee Estimate Tool'!F$72=$B$8,1,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Charge",{"$f":"IFERROR(Y17*$Y$3,0)","v":0},{"$f":"IFERROR(Z17*$Y$3,0)","v":0},{"$f":"IFERROR(AA17*$Y$3,0)","v":0},null,"Hours",{"$f":"IF(COUNTA('Fee Estimate Tool'!F$82,'Fee Estimate Tool'!F$88)<=1,0,IF((('Fee Estimate Tool'!F$88-'Fee Estimate Tool'!F$82)*24)<=$AD$4,$AD$4,('Fee Estimate Tool'!F$88-'Fee Estimate Tool'!F$82)*24))","v":0},{"$f":"IF(COUNTA('Fee Estimate Tool'!F$82,'Fee Estimate Tool'!F$88)<=1,0,IF((('Fee Estimate Tool'!F$88-'Fee Estimate Tool'!F$82)*24)<=AE4,AE4,('Fee Estimate Tool'!F$88-'Fee Estimate Tool'!F$82)*24))","v":0},{"$f":"IF(COUNTA('Fee Estimate Tool'!F$85,'Fee Estimate Tool'!F$88)<=1,0,IF((('Fee Estimate Tool'!F$88-'Fee Estimate Tool'!F$84)*24)<=AF4,AF4,('Fee Estimate Tool'!F$88-'Fee Estimate Tool'!F$84)*24))","v":0},{"$f":"IF(AG17<=0,0,IF(('Fee Estimate Tool'!F$88-'Fee Estimate Tool'!F$86)*24+0.5<=$AG$4,$AG$4,('Fee Estimate Tool'!F$88-'Fee Estimate Tool'!F$86)*24+0.5))","v":0},{"$f":"IF(AH17<=0,0,IF(('Fee Estimate Tool'!F$87-'Fee Estimate Tool'!F$85)*24<=$AG$4,$AG$4,('Fee Estimate Tool'!F$87-'Fee Estimate Tool'!F$85)*24))","v":0},null,null,null,null,null,null,null,null,null,null,"12:00:00"]
["Charge",{"$f":"INDEX($B$3:$E$6,MATCH('Fee Estimate Tool'!$C$15,$A$3:$A$6,0),MATCH($B$1,$B$1:$E$1,0))*B18","v":{"$error":"#N/A"}},{"$f":"INDEX($B$3:$E$6,MATCH('Fee Estimate Tool'!$C$15,$A$3:$A$6,0),MATCH($C$1,$B$1:$E$1,0))*C18","v":{"$error":"#N/A"}},{"$f":"INDEX($B$3:$E$6,MATCH('Fee Estimate Tool'!$C$15,$A$3:$A$6,0),MATCH($D$1,$B$1:$E$1,0))*D18","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Day 5",{"$f":"IFERROR(IF('Fee Estimate Tool'!G$82=\"\",0,IF('Fee Estimate Tool'!G$82<Info!$AX$3,(Info!$AX$3-'Fee Estimate Tool'!G$82)*24,0)),0)","v":0},{"$f":"IFERROR(IF('Fee Estimate Tool'!G$160=\"\",0,IF('Fee Estimate Tool'!G$160<Info!$AX$3,(Info!$AX$3-'Fee Estimate Tool'!G$160)*24,0)),0)","v":0},{"$f":"IFERROR(IF('Fee Estimate Tool'!G$70=\"\",0,IF('Fee Estimate Tool'!G$70<Info!$AX$3,(Info!$AX$3-'Fee Estimate Tool'!G$70)*24,0)),0)","v":0},null,"Day 5 - Staff #",{"$f":"IFERROR(SUM('Fee Estimate Tool'!G$103),0)","v":0},{"$f":"IFERROR('Fee Estimate Tool'!G$104-'Fee Estimate Tool'!G$103,0)","v":0},{"$f":"IF(AND('Fee Estimate Tool'!G$93=\"Yes\",AD19=1),1,0)","v":0},{"$f":"IF('Fee Estimate Tool'!G$93=\"Yes\",'Fee Estimate Tool'!G$110-'Fee Estimate Tool'!G$109,0)","v":0},{"$f":"IF('Fee Estimate Tool'!G$93=\"Yes\",'Fee Estimate Tool'!G$109,0)","v":0},null,null,null,null,null,null,null,null,null,null,"12:30:00"]
["Day 5 - Frequency",{"$f":"IF('Fee Estimate Tool'!G$94=$B$8,1,0)","v":0},{"$f":"IF('Fee Estimate Tool'!G$162=$B$8,1,0)","v":0},{"$f":"IF('Fee Estimate Tool'!G$72=$B$8,1,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Charge",{"$f":"IFERROR(Y19*$Y$3,0)","v":0},{"$f":"IFERROR(Z19*$Y$3,0)","v":0},{"$f":"IFERROR(AA19*$Y$3,0)","v":0},null,"Hours",{"$f":"IF(COUNTA('Fee Estimate Tool'!G$82,'Fee Estimate Tool'!G$88)<=1,0,IF((('Fee Estimate Tool'!G$88-'Fee Estimate Tool'!G$82)*24)<=$AD$4,$AD$4,('Fee Estimate Tool'!G$88-'Fee Estimate Tool'!G$82)*24))","v":0},{"$f":"IF(COUNTA('Fee Estimate Tool'!G$82,'Fee Estimate Tool'!G$88)<=1,0,IF((('Fee Estimate Tool'!G$88-'Fee Estimate Tool'!G$82)*24)<=AE4,AE4,('Fee Estimate Tool'!G$88-'Fee Estimate Tool'!G$82)*24))","v":0},{"$f":"IF(COUNTA('Fee Estimate Tool'!G$85,'Fee Estimate Tool'!G$88)<=1,0,IF((('Fee Estimate Tool'!G$88-'Fee Estimate Tool'!G$84)*24)<=AF4,AF4,('Fee Estimate Tool'!G$88-'Fee Estimate Tool'!G$84)*24))","v":0},{"$f":"IF(AG19<=0,0,IF(('Fee Estimate Tool'!G$88-'Fee Estimate Tool'!G$86)*24+0.5<=$AG$4,$AG$4,('Fee Estimate Tool'!G$88-'Fee Estimate Tool'!G$86)*24+0.5))","v":0},{"$f":"IF(AH19<=0,0,IF(('Fee Estimate Tool'!G$87-'Fee Estimate Tool'!G$85)*24<=$AG$4,$AG$4,('Fee Estimate Tool'!G$87-'Fee Estimate Tool'!G$85)*24))","v":0},null,null,null,null,null,null,null,null,null,null,"13:00:00"]
["Charge",{"$f":"INDEX($B$3:$E$6,MATCH('Fee Estimate Tool'!$C$15,$A$3:$A$6,0),MATCH($B$1,$B$1:$E$1,0))*B20","v":{"$error":"#N/A"}},{"$f":"INDEX($B$3:$E$6,MATCH('Fee Estimate Tool'!$C$15,$A$3:$A$6,0),MATCH($C$1,$B$1:$E$1,0))*C20","v":{"$error":"#N/A"}},{"$f":"INDEX($B$3:$E$6,MATCH('Fee Estimate Tool'!$C$15,$A$3:$A$6,0),MATCH($D$1,$B$1:$E$1,0))*D20","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Day 6",{"$f":"IFERROR(IF('Fee Estimate Tool'!H$82=\"\",0,IF('Fee Estimate Tool'!H$82<Info!$AX$3,(Info!$AX$3-'Fee Estimate Tool'!H$82)*24,0)),0)","v":0},{"$f":"IFERROR(IF('Fee Estimate Tool'!H$160=\"\",0,IF('Fee Estimate Tool'!H$160<Info!$AX$3,(Info!$AX$3-'Fee Estimate Tool'!H$160)*24,0)),0)","v":0},{"$f":"IFERROR(IF('Fee Estimate Tool'!H$70=\"\",0,IF('Fee Estimate Tool'!H$70<Info!$AX$3,(Info!$AX$3-'Fee Estimate Tool'!H$70)*24,0)),0)","v":0},null,"Day 6 - Staff #",{"$f":"IFERROR(SUM('Fee Estimate Tool'!H$103),0)","v":0},{"$f":"IFERROR('Fee Estimate Tool'!H$104-'Fee Estimate Tool'!H$103,0)","v":0},{"$f":"IF(AND('Fee Estimate Tool'!H$93=\"Yes\",AD21=1),1,0)","v":0},{"$f":"IF('Fee Estimate Tool'!H$93=\"Yes\",'Fee Estimate Tool'!H$110-'Fee Estimate Tool'!H$109,0)","v":0},{"$f":"IF('Fee Estimate Tool'!H$93=\"Yes\",'Fee Estimate Tool'!H$109,0)","v":0},null,null,null,null,null,null,null,null,null,null,"13:30:00"]
["Day 6 - Frequency",{"$f":"IF('Fee Estimate Tool'!H$94=$B$8,1,0)","v":0},{"$f":"IF('Fee Estimate Tool'!H$162=$B$8,1,0)","v":0},{"$f":"IF('Fee Estimate Tool'!H$72=$B$8,1,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Charge",{"$f":"IFERROR(Y21*$Y$3,0)","v":0},{"$f":"IFERROR(Z21*$Y$3,0)","v":0},{"$f":"IFERROR(AA21*$Y$3,0)","v":0},null,"Hours",{"$f":"IF(COUNTA('Fee Estimate Tool'!H$82,'Fee Estimate Tool'!H$88)<=1,0,IF((('Fee Estimate Tool'!H$88-'Fee Estimate Tool'!H$82)*24)<=$AD$4,$AD$4,('Fee Estimate Tool'!H$88-'Fee Estimate Tool'!H$82)*24))","v":0},{"$f":"IF(COUNTA('Fee Estimate Tool'!H$82,'Fee Estimate Tool'!H$88)<=1,0,IF((('Fee Estimate Tool'!H$88-'Fee Estimate Tool'!H$82)*24)<=AE4,AE4,('Fee Estimate Tool'!H$88-'Fee Estimate Tool'!H$82)*24))","v":0},{"$f":"IF(COUNTA('Fee Estimate Tool'!H$85,'Fee Estimate Tool'!H$88)<=1,0,IF((('Fee Estimate Tool'!H$88-'Fee Estimate Tool'!H$84)*24)<=AF4,AF4,('Fee Estimate Tool'!H$88-'Fee Estimate Tool'!H$84)*24))","v":0},{"$f":"IF(AG21<=0,0,IF(('Fee Estimate Tool'!H$88-'Fee Estimate Tool'!H$86)*24+0.5<=$AG$4,$AG$4,('Fee Estimate Tool'!H$88-'Fee Estimate Tool'!H$86)*24+0.5))","v":0},{"$f":"IF(AH21<=0,0,IF(('Fee Estimate Tool'!H$87-'Fee Estimate Tool'!H$85)*24<=$AG$4,$AG$4,('Fee Estimate Tool'!H$87-'Fee Estimate Tool'!H$85)*24))","v":0},null,null,null,null,null,null,null,null,null,null,"14:00:00"]
["Charge",{"$f":"INDEX($B$3:$E$6,MATCH('Fee Estimate Tool'!$C$15,$A$3:$A$6,0),MATCH($B$1,$B$1:$E$1,0))*B22","v":{"$error":"#N/A"}},{"$f":"INDEX($B$3:$E$6,MATCH('Fee Estimate Tool'!$C$15,$A$3:$A$6,0),MATCH($C$1,$B$1:$E$1,0))*C22","v":{"$error":"#N/A"}},{"$f":"INDEX($B$3:$E$6,MATCH('Fee Estimate Tool'!$C$15,$A$3:$A$6,0),MATCH($D$1,$B$1:$E$1,0))*D22","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Day 7",{"$f":"IFERROR(IF('Fee Estimate Tool'!I$82=\"\",0,IF('Fee Estimate Tool'!I$82<Info!$AX$3,(Info!$AX$3-'Fee Estimate Tool'!I$82)*24,0)),0)","v":0},{"$f":"IFERROR(IF('Fee Estimate Tool'!I$160=\"\",0,IF('Fee Estimate Tool'!I$160<Info!$AX$3,(Info!$AX$3-'Fee Estimate Tool'!I$160)*24,0)),0)","v":0},{"$f":"IFERROR(IF('Fee Estimate Tool'!I$70=\"\",0,IF('Fee Estimate Tool'!I$70<Info!$AX$3,(Info!$AX$3-'Fee Estimate Tool'!I$70)*24,0)),0)","v":0},null,"Day 7 - Staff #",{"$f":"IFERROR(SUM('Fee Estimate Tool'!I$103),0)","v":0},{"$f":"IFERROR('Fee Estimate Tool'!I$104-'Fee Estimate Tool'!I$103,0)","v":0},{"$f":"IF(AND('Fee Estimate Tool'!I$93=\"Yes\",AD23=1),1,0)","v":0},{"$f":"IF('Fee Estimate Tool'!I$93=\"Yes\",'Fee Estimate Tool'!I$110-'Fee Estimate Tool'!I$109,0)","v":0},{"$f":"IF('Fee Estimate Tool'!I$93=\"Yes\",'Fee Estimate Tool'!I$109,0)","v":0},null,null,null,null,null,null,null,null,null,null,"14:30:00"]
["Day 7 - Frequency",{"$f":"IF('Fee Estimate Tool'!I$94=$B$8,1,0)","v":0},{"$f":"IF('Fee Estimate Tool'!I$162=$B$8,1,0)","v":0},{"$f":"IF('Fee Estimate Tool'!I$72=$B$8,1,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Charge",{"$f":"IFERROR(Y23*$Y$3,0)","v":0},{"$f":"IFERROR(Z23*$Y$3,0)","v":0},{"$f":"IFERROR(AA23*$Y$3,0)","v":0},null,"Hours",{"$f":"IF(COUNTA('Fee Estimate Tool'!I$82,'Fee Estimate Tool'!I$88)<=1,0,IF((('Fee Estimate Tool'!I$88-'Fee Estimate Tool'!I$82)*24)<=$AD$4,$AD$4,('Fee Estimate Tool'!I$88-'Fee Estimate Tool'!I$82)*24))","v":0},{"$f":"IF(COUNTA('Fee Estimate Tool'!I$82,'Fee Estimate Tool'!I$88)<=1,0,IF((('Fee Estimate Tool'!I$88-'Fee Estimate Tool'!I$82)*24)<=AE4,AE4,('Fee Estimate Tool'!I$88-'Fee Estimate Tool'!I$82)*24))","v":0},{"$f":"IF(COUNTA('Fee Estimate Tool'!I$85,'Fee Estimate Tool'!I$88)<=1,0,IF((('Fee Estimate Tool'!I$88-'Fee Estimate Tool'!I$84)*24)<=AF4,AF4,('Fee Estimate Tool'!I$88-'Fee Estimate Tool'!I$84)*24))","v":0},{"$f":"IF(AG23<=0,0,IF(('Fee Estimate Tool'!I$88-'Fee Estimate Tool'!I$86)*24+0.5<=$AG$4,$AG$4,('Fee Estimate Tool'!I$88-'Fee Estimate Tool'!I$86)*24+0.5))","v":0},{"$f":"IF(AH23<=0,0,IF(('Fee Estimate Tool'!I$87-'Fee Estimate Tool'!I$85)*24<=$AG$4,$AG$4,('Fee Estimate Tool'!I$87-'Fee Estimate Tool'!I$85)*24))","v":0},null,null,null,null,null,null,null,null,null,null,"15:00:00"]
["Charge",{"$f":"INDEX($B$3:$E$6,MATCH('Fee Estimate Tool'!$C$15,$A$3:$A$6,0),MATCH($B$1,$B$1:$E$1,0))*B24","v":{"$error":"#N/A"}},{"$f":"INDEX($B$3:$E$6,MATCH('Fee Estimate Tool'!$C$15,$A$3:$A$6,0),MATCH($C$1,$B$1:$E$1,0))*C24","v":{"$error":"#N/A"}},{"$f":"INDEX($B$3:$E$6,MATCH('Fee Estimate Tool'!$C$15,$A$3:$A$6,0),MATCH($D$1,$B$1:$E$1,0))*D24","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Day 8",{"$f":"IFERROR(IF('Fee Estimate Tool'!J$82=\"\",0,IF('Fee Estimate Tool'!J$82<Info!$AX$3,(Info!$AX$3-'Fee Estimate Tool'!J$82)*24,0)),0)","v":0},{"$f":"IFERROR(IF('Fee Estimate Tool'!J$167=\"\",0,IF('Fee Estimate Tool'!J$167<Info!$AX$3,(Info!$AX$3-'Fee Estimate Tool'!J$167)*24,0)),0)","v":0},{"$f":"IFERROR(IF('Fee Estimate Tool'!J$75=\"\",0,IF('Fee Estimate Tool'!J$75<Info!$AX$3,(Info!$AX$3-'Fee Estimate Tool'!J$75)*24,0)),0)","v":0},null,"Day 8 - Staff #",{"$f":"IFERROR(SUM('Fee Estimate Tool'!J$103),0)","v":0},{"$f":"IFERROR('Fee Estimate Tool'!J$104-'Fee Estimate Tool'!J$103,0)","v":0},{"$f":"IF(AND('Fee Estimate Tool'!C$125=\"Yes\",AD25=1),1,0)","v":0},{"$f":"IF('Fee Estimate Tool'!J$93=\"Yes\",'Fee Estimate Tool'!J$110-'Fee Estimate Tool'!J$109,0)","v":0},{"$f":"IF('Fee Estimate Tool'!J$93=\"Yes\",'Fee Estimate Tool'!J$109,0)","v":0},null,null,null,null,null,null,null,null,null,null,"15:30:00"]
["Day 8 - Frequency",{"$f":"IF('Fee Estimate Tool'!J$94=$B$8,1,0)","v":0},{"$f":"IF('Fee Estimate Tool'!J$162=$B$8,1,0)","v":0},{"$f":"IF('Fee Estimate Tool'!J$72=$B$8,1,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Charge",{"$f":"IFERROR(Y25*$Y$3,0)","v":0},{"$f":"IFERROR(Z25*$Y$3,0)","v":0},{"$f":"IFERROR(AA25*$Y$3,0)","v":0},null,"Hours",{"$f":"IF(COUNTA('Fee Estimate Tool'!J$82,'Fee Estimate Tool'!J$88)<=1,0,IF((('Fee Estimate Tool'!J$88-'Fee Estimate Tool'!J$82)*24)<=$AD$4,$AD$4,('Fee Estimate Tool'!J$88-'Fee Estimate Tool'!J$82)*24))","v":0},{"$f":"IF(COUNTA('Fee Estimate Tool'!J$82,'Fee Estimate Tool'!J$88)<=1,0,IF((('Fee Estimate Tool'!J$88-'Fee Estimate Tool'!J$82)*24)<=AE4,AE4,('Fee Estimate Tool'!J$88-'Fee Estimate Tool'!J$82)*24))","v":0},{"$f":"IF(COUNTA('Fee Estimate Tool'!J$85,'Fee Estimate Tool'!J$88)<=1,0,IF((('Fee Estimate Tool'!J$88-'Fee Estimate Tool'!J$84)*24)<=AF4,AF4,('Fee Estimate Tool'!J$88-'Fee Estimate Tool'!J$84)*24))","v":0},{"$f":"IF(AG25<=0,0,IF(('Fee Estimate Tool'!J$88-'Fee Estimate Tool'!J$86)*24+0.5<=$AG$4,$AG$4,('Fee Estimate Tool'!J$88-'Fee Estimate Tool'!J$86)*24+0.5))","v":0},{"$f":"IF(AH25<=0,0,IF(('Fee Estimate Tool'!J$87-'Fee Estimate Tool'!J$85)*24<=$AG$4,$AG$4,('Fee Estimate Tool'!J$87-'Fee Estimate Tool'!J$85)*24))","v":0},null,null,null,null,null,null,null,null,null,null,"16:00:00"]
["Charge",{"$f":"INDEX($B$3:$E$6,MATCH('Fee Estimate Tool'!$C$15,$A$3:$A$6,0),MATCH($B$1,$B$1:$E$1,0))*B26","v":{"$error":"#N/A"}},{"$f":"INDEX($B$3:$E$6,MATCH('Fee Estimate Tool'!$C$15,$A$3:$A$6,0),MATCH($C$1,$B$1:$E$1,0))*C26","v":{"$error":"#N/A"}},{"$f":"INDEX($B$3:$E$6,MATCH('Fee Estimate Tool'!$C$15,$A$3:$A$6,0),MATCH($D$1,$B$1:$E$1,0))*D26","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Day 9",{"$f":"IFERROR(IF('Fee Estimate Tool'!C$114=\"\",0,IF('Fee Estimate Tool'!C$114<Info!$AX$3,(Info!$AX$3-'Fee Estimate Tool'!C$114)*24,0)),0)","v":0},{"$f":"IFERROR(IF('Fee Estimate Tool'!C$167=\"\",0,IF('Fee Estimate Tool'!C$167<Info!$AX$3,(Info!$AX$3-'Fee Estimate Tool'!C$167)*24,0)),0)","v":0},{"$f":"IFERROR(IF('Fee Estimate Tool'!C$75=\"\",0,IF('Fee Estimate Tool'!C$75<Info!$AX$3,(Info!$AX$3-'Fee Estimate Tool'!C$75)*24,0)),0)","v":0},null,"Day 9 - Staff #",{"$f":"IFERROR(SUM('Fee Estimate Tool'!C$135),0)","v":0},{"$f":"IFERROR('Fee Estimate Tool'!C$136-'Fee Estimate Tool'!C$135,0)","v":0},{"$f":"IF(AND('Fee Estimate Tool'!C$125=\"Yes\",AD27=1),1,0)","v":0},{"$f":"IF('Fee Estimate Tool'!C$125=\"Yes\",'Fee Estimate Tool'!C$142-'Fee Estimate Tool'!C$141,0)","v":0},{"$f":"IF('Fee Estimate Tool'!C$125=\"Yes\",'Fee Estimate Tool'!C$141,0)","v":0},null,null,null,null,null,null,null,null,null,null,"16:30:00"]
["Day 9 - Frequency",{"$f":"IF('Fee Estimate Tool'!C$126=$B$8,1,0)","v":0},{"$f":"IF('Fee Estimate Tool'!C$169=$B$8,1,0)","v":0},{"$f":"IF('Fee Estimate Tool'!C$77=$B$8,1,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Charge",{"$f":"IFERROR(Y27*$Y$3,0)","v":0},{"$f":"IFERROR(Z27*$Y$3,0)","v":0},{"$f":"IFERROR(AA27*$Y$3,0)","v":0},null,"Hours",{"$f":"IF(COUNTA('Fee Estimate Tool'!C$120,'Fee Estimate Tool'!C$114)<=1,0,IF((('Fee Estimate Tool'!C$120-'Fee Estimate Tool'!C$114)*24)<=$AD$4,$AD$4,('Fee Estimate Tool'!C$120-'Fee Estimate Tool'!C$114)*24))","v":0},{"$f":"IF(COUNTA('Fee Estimate Tool'!C$120,'Fee Estimate Tool'!C$114)<=1,0,IF((('Fee Estimate Tool'!C$120-'Fee Estimate Tool'!C$114)*24)<=AE4,AE4,('Fee Estimate Tool'!C$120-'Fee Estimate Tool'!C$114)*24))","v":0},{"$f":"IF(COUNTA('Fee Estimate Tool'!C$117,'Fee Estimate Tool'!C$120)<=1,0,IF((('Fee Estimate Tool'!C$120-'Fee Estimate Tool'!C$116)*24)<=$AF$4,$AF$4,('Fee Estimate Tool'!C$120-'Fee Estimate Tool'!C$116)*24))","v":0},{"$f":"IF($AG27<=0,0,IF(('Fee Estimate Tool'!C$120-'Fee Estimate Tool'!C$118)*24+0.5<=$AG$4,$AG$4,('Fee Estimate Tool'!C$120-'Fee Estimate Tool'!C$118)*24+0.5))","v":0},{"$f":"IF(AH27<=0,0,IF(('Fee Estimate Tool'!C$120-'Fee Estimate Tool'!C$117)*24<=$AG$4,$AG$4,('Fee Estimate Tool'!C$120-'Fee Estimate Tool'!C$117)*24))","v":0},null,null,null,null,null,null,null,null,null,null,"17:00:00"]
["Charge",{"$f":"INDEX($B$3:$E$6,MATCH('Fee Estimate Tool'!$C$15,$A$3:$A$6,0),MATCH($B$1,$B$1:$E$1,0))*B28","v":{"$error":"#N/A"}},{"$f":"INDEX($B$3:$E$6,MATCH('Fee Estimate Tool'!$C$15,$A$3:$A$6,0),MATCH($C$1,$B$1:$E$1,0))*C28","v":{"$error":"#N/A"}},{"$f":"INDEX($B$3:$E$6,MATCH('Fee Estimate Tool'!$C$15,$A$3:$A$6,0),MATCH($D$1,$B$1:$E$1,0))*D28","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Day 10",{"$f":"IFERROR(IF('Fee Estimate Tool'!D$114=\"\",0,IF('Fee Estimate Tool'!D$114<Info!$AX$3,(Info!$AX$3-'Fee Estimate Tool'!D$114)*24,0)),0)","v":0},{"$f":"IFERROR(IF('Fee Estimate Tool'!D$167=\"\",0,IF('Fee Estimate Tool'!D$167<Info!$AX$3,(Info!$AX$3-'Fee Estimate Tool'!D$167)*24,0)),0)","v":0},{"$f":"IFERROR(IF('Fee Estimate Tool'!D$75=\"\",0,IF('Fee Estimate Tool'!D$75<Info!$AX$3,(Info!$AX$3-'Fee Estimate Tool'!D$75)*24,0)),0)","v":0},null,"Day 10 - Staff #",{"$f":"IFERROR(SUM('Fee Estimate Tool'!D$135),0)","v":0},{"$f":"IFERROR('Fee Estimate Tool'!D$136-'Fee Estimate Tool'!D$135,0)","v":0},{"$f":"IF(AND('Fee Estimate Tool'!D$125=\"Yes\",AD29=1),1,0)","v":0},{"$f":"IF('Fee Estimate Tool'!D$125=\"Yes\",'Fee Estimate Tool'!D$142-'Fee Estimate Tool'!D$141,0)","v":0},{"$f":"IF('Fee Estimate Tool'!D$125=\"Yes\",'Fee Estimate Tool'!D$141,0)","v":0},null,null,null,null,null,null,null,null,null,null,"17:30:00"]
["Day 10 - Frequency",{"$f":"IF('Fee Estimate Tool'!$D126=$B$8,1,0)","v":0},{"$f":"IF('Fee Estimate Tool'!D$169=$B$8,1,0)","v":0},{"$f":"IF('Fee Estimate Tool'!D$77=$B$8,1,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Charge",{"$f":"IFERROR(Y29*$Y$3,0)","v":0},{"$f":"IFERROR(Z29*$Y$3,0)","v":0},{"$f":"IFERROR(AA29*$Y$3,0)","v":0},null,"Hours",{"$f":"IF(COUNTA('Fee Estimate Tool'!D$120,'Fee Estimate Tool'!D$114)<=1,0,IF((('Fee Estimate Tool'!D$120-'Fee Estimate Tool'!D$114)*24)<=$AD$4,$AD$4,('Fee Estimate Tool'!D$120-'Fee Estimate Tool'!D$114)*24))","v":0},{"$f":"IF(COUNTA('Fee Estimate Tool'!D$120,'Fee Estimate Tool'!D$114)<=1,0,IF((('Fee Estimate Tool'!D$120-'Fee Estimate Tool'!D$114)*24)<=AE4,AE4,('Fee Estimate Tool'!D$120-'Fee Estimate Tool'!D$114)*24))","v":0},{"$f":"IF(COUNTA('Fee Estimate Tool'!D$117,'Fee Estimate Tool'!D$120)<=1,0,IF((('Fee Estimate Tool'!D$120-'Fee Estimate Tool'!D$116)*24)<=$AF$4,$AF$4,('Fee Estimate Tool'!D$120-'Fee Estimate Tool'!D$116)*24))","v":0},{"$f":"IF(AG29<=0,0,IF(('Fee Estimate Tool'!D$120-'Fee Estimate Tool'!D$118)*24+0.5<=$AG$4,$AG$4,('Fee Estimate Tool'!D$120-'Fee Estimate Tool'!D$118)*24+0.5))","v":0},{"$f":"IF(AH29<=0,0,IF(('Fee Estimate Tool'!D$120-'Fee Estimate Tool'!D$117)*24<=$AG$4,$AG$4,('Fee Estimate Tool'!D$120-'Fee Estimate Tool'!D$117)*24))","v":0},null,null,null,null,null,null,null,null,null,null,"18:00:00"]
["Charge",{"$f":"INDEX($B$3:$E$6,MATCH('Fee Estimate Tool'!$C$15,$A$3:$A$6,0),MATCH($B$1,$B$1:$E$1,0))*B30","v":{"$error":"#N/A"}},{"$f":"INDEX($B$3:$E$6,MATCH('Fee Estimate Tool'!$C$15,$A$3:$A$6,0),MATCH($C$1,$B$1:$E$1,0))*C30","v":{"$error":"#N/A"}},{"$f":"INDEX($B$3:$E$6,MATCH('Fee Estimate Tool'!$C$15,$A$3:$A$6,0),MATCH($D$1,$B$1:$E$1,0))*D30","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Day 11",{"$f":"IFERROR(IF('Fee Estimate Tool'!E$114=\"\",0,IF('Fee Estimate Tool'!E$114<Info!$AX$3,(Info!$AX$3-'Fee Estimate Tool'!E$114)*24,0)),0)","v":0},{"$f":"IFERROR(IF('Fee Estimate Tool'!E$167=\"\",0,IF('Fee Estimate Tool'!E$167<Info!$AX$3,(Info!$AX$3-'Fee Estimate Tool'!E$167)*24,0)),0)","v":0},{"$f":"IFERROR(IF('Fee Estimate Tool'!E$75=\"\",0,IF('Fee Estimate Tool'!E$75<Info!$AX$3,(Info!$AX$3-'Fee Estimate Tool'!E$75)*24,0)),0)","v":0},null,"Day 11 - Staff #",{"$f":"IFERROR(SUM('Fee Estimate Tool'!E$135),0)","v":0},{"$f":"IFERROR('Fee Estimate Tool'!E$136-'Fee Estimate Tool'!E$135,0)","v":0},{"$f":"IF(AND('Fee Estimate Tool'!E$125=\"Yes\",AD31=1),1,0)","v":0},{"$f":"IF('Fee Estimate Tool'!E$125=\"Yes\",'Fee Estimate Tool'!E$142-'Fee Estimate Tool'!E$141,0)","v":0},{"$f":"IF('Fee Estimate Tool'!E$125=\"Yes\",'Fee Estimate Tool'!E$141,0)","v":0},null,null,null,null,null,null,null,null,null,null,"18:30:00"]
["Day 11 - Frequency",{"$f":"IF('Fee Estimate Tool'!$E126=$B$8,1,0)","v":0},{"$f":"IF('Fee Estimate Tool'!E$169=$B$8,1,0)","v":0},{"$f":"IF('Fee Estimate Tool'!E$77=$B$8,1,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Charge",{"$f":"IFERROR(Y31*$Y$3,0)","v":0},{"$f":"IFERROR(Z31*$Y$3,0)","v":0},{"$f":"IFERROR(AA31*$Y$3,0)","v":0},null,"Hours",{"$f":"IF(COUNTA('Fee Estimate Tool'!E$120,'Fee Estimate Tool'!E$114)<=1,0,IF((('Fee Estimate Tool'!E$120-'Fee Estimate Tool'!E$114)*24)<=$AD$4,$AD$4,('Fee Estimate Tool'!E$120-'Fee Estimate Tool'!E$114)*24))","v":0},{"$f":"IF(COUNTA('Fee Estimate Tool'!E$120,'Fee Estimate Tool'!E$114)<=1,0,IF((('Fee Estimate Tool'!E$120-'Fee Estimate Tool'!E$114)*24)<=AE4,AE4,('Fee Estimate Tool'!E$120-'Fee Estimate Tool'!E$114)*24))","v":0},{"$f":"IF(COUNTA('Fee Estimate Tool'!E$117,'Fee Estimate Tool'!E$120)<=1,0,IF((('Fee Estimate Tool'!E$120-'Fee Estimate Tool'!E$116)*24)<=$AF$4,$AF$4,('Fee Estimate Tool'!E$120-'Fee Estimate Tool'!E$116)*24))","v":0},{"$f":"IF(AG31<=0,0,IF(('Fee Estimate Tool'!E$120-'Fee Estimate Tool'!E$118)*24+0.5<=$AG$4,$AG$4,('Fee Estimate Tool'!E$120-'Fee Estimate Tool'!E$118)*24+0.5))","v":0},{"$f":"IF(AH31<=0,0,IF(('Fee Estimate Tool'!E$120-'Fee Estimate Tool'!E$117)*24<=$AG$4,$AG$4,('Fee Estimate Tool'!E$120-'Fee Estimate Tool'!E$117)*24))","v":0},null,null,null,null,null,null,null,null,null,null,"19:00:00"]
["Charge",{"$f":"INDEX($B$3:$E$6,MATCH('Fee Estimate Tool'!$C$15,$A$3:$A$6,0),MATCH($B$1,$B$1:$E$1,0))*B32","v":{"$error":"#N/A"}},{"$f":"INDEX($B$3:$E$6,MATCH('Fee Estimate Tool'!$C$15,$A$3:$A$6,0),MATCH($C$1,$B$1:$E$1,0))*C32","v":{"$error":"#N/A"}},{"$f":"INDEX($B$3:$E$6,MATCH('Fee Estimate Tool'!$C$15,$A$3:$A$6,0),MATCH($D$1,$B$1:$E$1,0))*D32","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Day 12",{"$f":"IFERROR(IF('Fee Estimate Tool'!F$114=\"\",0,IF('Fee Estimate Tool'!F$114<Info!$AX$3,(Info!$AX$3-'Fee Estimate Tool'!F$114)*24,0)),0)","v":0},{"$f":"IFERROR(IF('Fee Estimate Tool'!F$167=\"\",0,IF('Fee Estimate Tool'!F$167<Info!$AX$3,(Info!$AX$3-'Fee Estimate Tool'!F$167)*24,0)),0)","v":0},{"$f":"IFERROR(IF('Fee Estimate Tool'!F$75=\"\",0,IF('Fee Estimate Tool'!F$75<Info!$AX$3,(Info!$AX$3-'Fee Estimate Tool'!F$75)*24,0)),0)","v":0},null,"Day 12 - Staff #",{"$f":"IFERROR(SUM('Fee Estimate Tool'!F$135),0)","v":0},{"$f":"IFERROR('Fee Estimate Tool'!F$136-'Fee Estimate Tool'!F$135,0)","v":0},{"$f":"IF(AND('Fee Estimate Tool'!F$125=\"Yes\",AD33=1),1,0)","v":0},{"$f":"IF('Fee Estimate Tool'!F$125=\"Yes\",'Fee Estimate Tool'!F$142-'Fee Estimate Tool'!F$141,0)","v":0},{"$f":"IF('Fee Estimate Tool'!F$125=\"Yes\",'Fee Estimate Tool'!F$141,0)","v":0},null,null,null,null,null,null,null,null,null,null,"19:30:00"]
["Day 12 - Frequency",{"$f":"IF('Fee Estimate Tool'!$F126=$B$8,1,0)","v":0},{"$f":"IF('Fee Estimate Tool'!F$169=$B$8,1,0)","v":0},{"$f":"IF('Fee Estimate Tool'!F$77=$B$8,1,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Charge",{"$f":"IFERROR(Y33*$Y$3,0)","v":0},{"$f":"IFERROR(Z33*$Y$3,0)","v":0},{"$f":"IFERROR(#REF!*$Y$3,0)","v":0},null,"Hours",{"$f":"IF(COUNTA('Fee Estimate Tool'!F$120,'Fee Estimate Tool'!F$114)<=1,0,IF((('Fee Estimate Tool'!F$120-'Fee Estimate Tool'!F$114)*24)<=$AD$4,$AD$4,('Fee Estimate Tool'!F$120-'Fee Estimate Tool'!F$114)*24))","v":0},{"$f":"IF(COUNTA('Fee Estimate Tool'!F$120,'Fee Estimate Tool'!F$114)<=1,0,IF((('Fee Estimate Tool'!F$120-'Fee Estimate Tool'!F$114)*24)<=AE4,AE4,('Fee Estimate Tool'!F$120-'Fee Estimate Tool'!F$114)*24))","v":0},{"$f":"IF(COUNTA('Fee Estimate Tool'!F$117,'Fee Estimate Tool'!F$120)<=1,0,IF((('Fee Estimate Tool'!F$120-'Fee Estimate Tool'!F$116)*24)<=$AF$4,$AF$4,('Fee Estimate Tool'!F$120-'Fee Estimate Tool'!F$116)*24))","v":0},{"$f":"IF(AG33<=0,0,IF(('Fee Estimate Tool'!F$120-'Fee Estimate Tool'!F$118)*24+0.5<=$AG$4,$AG$4,('Fee Estimate Tool'!F$120-'Fee Estimate Tool'!F$118)*24+0.5))","v":0},{"$f":"IF(AH33<=0,0,IF(('Fee Estimate Tool'!F$120-'Fee Estimate Tool'!F$117)*24<=$AG$4,$AG$4,('Fee Estimate Tool'!F$120-'Fee Estimate Tool'!F$117)*24))","v":0},null,null,null,null,null,null,null,null,null,null,"20:00:00"]
["Charge",{"$f":"INDEX($B$3:$E$6,MATCH('Fee Estimate Tool'!$C$15,$A$3:$A$6,0),MATCH($B$1,$B$1:$E$1,0))*B34","v":{"$error":"#N/A"}},{"$f":"INDEX($B$3:$E$6,MATCH('Fee Estimate Tool'!$C$15,$A$3:$A$6,0),MATCH($C$1,$B$1:$E$1,0))*C34","v":{"$error":"#N/A"}},{"$f":"INDEX($B$3:$E$6,MATCH('Fee Estimate Tool'!$C$15,$A$3:$A$6,0),MATCH($D$1,$B$1:$E$1,0))*D34","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Day 13",{"$f":"IFERROR(IF('Fee Estimate Tool'!G$114=\"\",0,IF('Fee Estimate Tool'!G$114<Info!$AX$3,(Info!$AX$3-'Fee Estimate Tool'!G$114)*24,0)),0)","v":0},{"$f":"IFERROR(IF('Fee Estimate Tool'!G$167=\"\",0,IF('Fee Estimate Tool'!G$167<Info!$AX$3,(Info!$AX$3-'Fee Estimate Tool'!G$167)*24,0)),0)","v":0},{"$f":"IFERROR(IF('Fee Estimate Tool'!G$75=\"\",0,IF('Fee Estimate Tool'!G$75<Info!$AX$3,(Info!$AX$3-'Fee Estimate Tool'!G$75)*24,0)),0)","v":0},null,"Day 13 - Staff #",{"$f":"IFERROR(SUM('Fee Estimate Tool'!G$135),0)","v":0},{"$f":"IFERROR('Fee Estimate Tool'!G$136-'Fee Estimate Tool'!G$135,0)","v":0},{"$f":"IF(AND('Fee Estimate Tool'!G$125=\"Yes\",AD35=1),1,0)","v":0},{"$f":"IF('Fee Estimate Tool'!G$125=\"Yes\",'Fee Estimate Tool'!G$142-'Fee Estimate Tool'!G$141,0)","v":0},{"$f":"IF('Fee Estimate Tool'!G$125=\"Yes\",'Fee Estimate Tool'!G$141,0)","v":0},null,null,null,null,null,null,null,null,null,null,"20:30:00"]
["Day 13 - Frequency",{"$f":"IF('Fee Estimate Tool'!$G126=$B$8,1,0)","v":0},{"$f":"IF('Fee Estimate Tool'!G$169=$B$8,1,0)","v":0},{"$f":"IF('Fee Estimate Tool'!G$77=$B$8,1,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Charge",{"$f":"IFERROR(Y35*$Y$3,0)","v":0},{"$f":"IFERROR(Z35*$Y$3,0)","v":0},{"$f":"IFERROR(AA35*$Y$3,0)","v":0},null,"Hours",{"$f":"IF(COUNTA('Fee Estimate Tool'!G$120,'Fee Estimate Tool'!G$114)<=1,0,IF((('Fee Estimate Tool'!G$120-'Fee Estimate Tool'!G$114)*24)<=$AD$4,$AD$4,('Fee Estimate Tool'!G$120-'Fee Estimate Tool'!G$114)*24))","v":0},{"$f":"IF(COUNTA('Fee Estimate Tool'!G$120,'Fee Estimate Tool'!G$114)<=1,0,IF((('Fee Estimate Tool'!G$120-'Fee Estimate Tool'!G$114)*24)<=AE4,AE4,('Fee Estimate Tool'!G$120-'Fee Estimate Tool'!G$114)*24))","v":0},{"$f":"IF(COUNTA('Fee Estimate Tool'!G$117,'Fee Estimate Tool'!G$120)<=1,0,IF((('Fee Estimate Tool'!G$120-'Fee Estimate Tool'!G$116)*24)<=$AF$4,$AF$4,('Fee Estimate Tool'!G$120-'Fee Estimate Tool'!G$116)*24))","v":0},{"$f":"IF(AG35<=0,0,IF(('Fee Estimate Tool'!G$120-'Fee Estimate Tool'!G$118)*24+0.5<=$AG$4,$AG$4,('Fee Estimate Tool'!G$120-'Fee Estimate Tool'!G$118)*24+0.5))","v":0},{"$f":"IF(AH35<=0,0,IF(('Fee Estimate Tool'!G$120-'Fee Estimate Tool'!G$117)*24<=$AG$4,$AG$4,('Fee Estimate Tool'!G$120-'Fee Estimate Tool'!G$117)*24))","v":0},null,null,null,null,null,null,null,null,null,null,"21:00:00"]
["Charge",{"$f":"INDEX($B$3:$E$6,MATCH('Fee Estimate Tool'!$C$15,$A$3:$A$6,0),MATCH($B$1,$B$1:$E$1,0))*B36","v":{"$error":"#N/A"}},{"$f":"INDEX($B$3:$E$6,MATCH('Fee Estimate Tool'!$C$15,$A$3:$A$6,0),MATCH($C$1,$B$1:$E$1,0))*C36","v":{"$error":"#N/A"}},{"$f":"INDEX($B$3:$E$6,MATCH('Fee Estimate Tool'!$C$15,$A$3:$A$6,0),MATCH($D$1,$B$1:$E$1,0))*D36","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Day 14",{"$f":"IFERROR(IF('Fee Estimate Tool'!H$114=\"\",0,IF('Fee Estimate Tool'!H$114<Info!$AX$3,(Info!$AX$3-'Fee Estimate Tool'!H$114)*24,0)),0)","v":0},{"$f":"IFERROR(IF('Fee Estimate Tool'!H$167=\"\",0,IF('Fee Estimate Tool'!H$167<Info!$AX$3,(Info!$AX$3-'Fee Estimate Tool'!H$167)*24,0)),0)","v":0},{"$f":"IFERROR(IF('Fee Estimate Tool'!H$75=\"\",0,IF('Fee Estimate Tool'!H$75<Info!$AX$3,(Info!$AX$3-'Fee Estimate Tool'!H$75)*24,0)),0)","v":0},null,"Day 14 - Staff #",{"$f":"IFERROR(SUM('Fee Estimate Tool'!H$135),0)","v":0},{"$f":"IFERROR('Fee Estimate Tool'!H$136-'Fee Estimate Tool'!H$135,0)","v":0},{"$f":"IF(AND('Fee Estimate Tool'!H$125=\"Yes\",AD37=1),1,0)","v":0},{"$f":"IF('Fee Estimate Tool'!H$125=\"Yes\",'Fee Estimate Tool'!H$142-'Fee Estimate Tool'!H$141,0)","v":0},{"$f":"IF('Fee Estimate Tool'!H$125=\"Yes\",'Fee Estimate Tool'!H$141,0)","v":0},null,null,null,null,null,null,null,null,null,null,"21:30:00"]
["Day 14 - Frequency",{"$f":"IF('Fee Estimate Tool'!$H126=$B$8,1,0)","v":0},{"$f":"IF('Fee Estimate Tool'!H$169=$B$8,1,0)","v":0},{"$f":"IF('Fee Estimate Tool'!H$77=$B$8,1,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Charge",{"$f":"IFERROR(Y37*$Y$3,0)","v":0},{"$f":"IFERROR(Z37*$Y$3,0)","v":0},{"$f":"IFERROR(AA37*$Y$3,0)","v":0},null,"Hours",{"$f":"IF(COUNTA('Fee Estimate Tool'!H$120,'Fee Estimate Tool'!H$114)<=1,0,IF((('Fee Estimate Tool'!H$120-'Fee Estimate Tool'!H$114)*24)<=$AD$4,$AD$4,('Fee Estimate Tool'!H$120-'Fee Estimate Tool'!H$114)*24))","v":0},{"$f":"IF(COUNTA('Fee Estimate Tool'!H$120,'Fee Estimate Tool'!H$114)<=1,0,IF((('Fee Estimate Tool'!H$120-'Fee Estimate Tool'!H$114)*24)<=AE4,AE4,('Fee Estimate Tool'!H$120-'Fee Estimate Tool'!H$114)*24))","v":0},{"$f":"IF(COUNTA('Fee Estimate Tool'!H$117,'Fee Estimate Tool'!H$120)<=1,0,IF((('Fee Estimate Tool'!H$120-'Fee Estimate Tool'!H$116)*24)<=$AF$4,$AF$4,('Fee Estimate Tool'!H$120-'Fee Estimate Tool'!H$116)*24))","v":0},{"$f":"IF(AG37<=0,0,IF(('Fee Estimate Tool'!H$120-'Fee Estimate Tool'!H$118)*24+0.5<=$AG$4,$AG$4,('Fee Estimate Tool'!H$120-'Fee Estimate Tool'!H$118)*24+0.5))","v":0},{"$f":"IF(AH37<=0,0,IF(('Fee Estimate Tool'!H$120-'Fee Estimate Tool'!H$117)*24<=$AG$4,$AG$4,('Fee Estimate Tool'!H$120-'Fee Estimate Tool'!H$117)*24))","v":0},null,null,null,null,null,null,null,null,null,null,"22:00:00"]
["Charge",{"$f":"INDEX($B$3:$E$6,MATCH('Fee Estimate Tool'!$C$15,$A$3:$A$6,0),MATCH($B$1,$B$1:$E$1,0))*B38","v":{"$error":"#N/A"}},{"$f":"INDEX($B$3:$E$6,MATCH('Fee Estimate Tool'!$C$15,$A$3:$A$6,0),MATCH($C$1,$B$1:$E$1,0))*C38","v":{"$error":"#N/A"}},{"$f":"INDEX($B$3:$E$6,MATCH('Fee Estimate Tool'!$C$15,$A$3:$A$6,0),MATCH($D$1,$B$1:$E$1,0))*D38","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Day 15 - Frequency",{"$f":"IFERROR(IF('Fee Estimate Tool'!I$114=\"\",0,IF('Fee Estimate Tool'!I$114<Info!$AX$3,(Info!$AX$3-'Fee Estimate Tool'!I$114)*24,0)),0)","v":0},{"$f":"IFERROR(IF('Fee Estimate Tool'!I$167=\"\",0,IF('Fee Estimate Tool'!I$167<Info!$AX$3,(Info!$AX$3-'Fee Estimate Tool'!I$167)*24,0)),0)","v":0},{"$f":"IFERROR(IF('Fee Estimate Tool'!I$75=\"\",0,IF('Fee Estimate Tool'!I$75<Info!$AX$3,(Info!$AX$3-'Fee Estimate Tool'!I$75)*24,0)),0)","v":0},null,"Day 15- Staff #",{"$f":"IFERROR(SUM('Fee Estimate Tool'!I$135),0)","v":0},{"$f":"IFERROR('Fee Estimate Tool'!I$136-'Fee Estimate Tool'!I$135,0)","v":0},{"$f":"IF(AND('Fee Estimate Tool'!I$125=\"Yes\",AD39=1),1,0)","v":0},{"$f":"IF('Fee Estimate Tool'!I$125=\"Yes\",'Fee Estimate Tool'!I$142-'Fee Estimate Tool'!I$141,0)","v":0},{"$f":"IF('Fee Estimate Tool'!I$125=\"Yes\",'Fee Estimate Tool'!I$141,0)","v":0},null,null,null,null,null,null,null,null,null,null,"22:30:00"]
["Day 15 - Frequency",{"$f":"IF('Fee Estimate Tool'!$I126=$B$8,1,0)","v":0},{"$f":"IF('Fee Estimate Tool'!I$169=$B$8,1,0)","v":0},{"$f":"IF('Fee Estimate Tool'!I$77=$B$8,1,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Charge",{"$f":"IFERROR(Y39*$Y$3,0)","v":0},{"$f":"IFERROR(Z39*$Y$3,0)","v":0},{"$f":"IFERROR(AA39*$Y$3,0)","v":0},null,"Hours",{"$f":"IF(COUNTA('Fee Estimate Tool'!I$120,'Fee Estimate Tool'!I$114)<=1,0,IF((('Fee Estimate Tool'!I$120-'Fee Estimate Tool'!I$114)*24)<=$AD$4,$AD$4,('Fee Estimate Tool'!I$120-'Fee Estimate Tool'!I$114)*24))","v":0},{"$f":"IF(COUNTA('Fee Estimate Tool'!I$120,'Fee Estimate Tool'!I$114)<=1,0,IF((('Fee Estimate Tool'!I$120-'Fee Estimate Tool'!I$114)*24)<=AE4,AE4,('Fee Estimate Tool'!I$120-'Fee Estimate Tool'!I$114)*24))","v":0},{"$f":"IF(COUNTA('Fee Estimate Tool'!I$117,'Fee Estimate Tool'!I$120)<=1,0,IF((('Fee Estimate Tool'!I$120-'Fee Estimate Tool'!I$116)*24)<=$AF$4,$AF$4,('Fee Estimate Tool'!I$120-'Fee Estimate Tool'!I$116)*24))","v":0},{"$f":"IF(AG39<=0,0,IF(('Fee Estimate Tool'!I$120-'Fee Estimate Tool'!I$118)*24+0.5<=$AG$4,$AG$4,('Fee Estimate Tool'!I$120-'Fee Estimate Tool'!I$118)*24+0.5))","v":0},{"$f":"IF(AH39<=0,0,IF(('Fee Estimate Tool'!I$120-'Fee Estimate Tool'!I$117)*24<=$AG$4,$AG$4,('Fee Estimate Tool'!I$120-'Fee Estimate Tool'!I$117)*24))","v":0},null,null,null,null,null,null,null,null,null,null,"23:00:00"]
["Charge",{"$f":"INDEX($B$3:$E$6,MATCH('Fee Estimate Tool'!$C$15,$A$3:$A$6,0),MATCH($B$1,$B$1:$E$1,0))*B40","v":{"$error":"#N/A"}},{"$f":"INDEX($B$3:$E$6,MATCH('Fee Estimate Tool'!$C$15,$A$3:$A$6,0),MATCH($C$1,$B$1:$E$1,0))*C40","v":{"$error":"#N/A"}},{"$f":"INDEX($B$3:$E$6,MATCH('Fee Estimate Tool'!$C$15,$A$3:$A$6,0),MATCH($D$1,$B$1:$E$1,0))*D40","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Day 16- Frequency",{"$f":"IFERROR(IF('Fee Estimate Tool'!J$114=\"\",0,IF('Fee Estimate Tool'!J$114<Info!$AX$3,(Info!$AX$3-'Fee Estimate Tool'!J$114)*24,0)),0)","v":0},{"$f":"IFERROR(IF('Fee Estimate Tool'!J$167=\"\",0,IF('Fee Estimate Tool'!J$167<Info!$AX$3,(Info!$AX$3-'Fee Estimate Tool'!J$167)*24,0)),0)","v":0},{"$f":"IFERROR(IF('Fee Estimate Tool'!J$75=\"\",0,IF('Fee Estimate Tool'!J$75<Info!$AX$3,(Info!$AX$3-'Fee Estimate Tool'!J$75)*24,0)),0)","v":0},null,"Day 16 - Staff #",{"$f":"IFERROR(SUM('Fee Estimate Tool'!J$135),0)","v":0},{"$f":"IFERROR('Fee Estimate Tool'!J$136-'Fee Estimate Tool'!J$135,0)","v":0},{"$f":"IF(AND('Fee Estimate Tool'!J$125=\"Yes\",AD41=1),1,0)","v":0},{"$f":"IF('Fee Estimate Tool'!J$125=\"Yes\",'Fee Estimate Tool'!J$142-'Fee Estimate Tool'!J$141,0)","v":0},{"$f":"IF('Fee Estimate Tool'!J$125=\"Yes\",'Fee Estimate Tool'!J$141,0)","v":0},null,null,null,null,null,null,null,null,null,null,"23:30:00"]
["Day 16- Frequency",{"$f":"IF('Fee Estimate Tool'!$J126=$B$8,1,0)","v":0},{"$f":"IF('Fee Estimate Tool'!J$169=$B$8,1,0)","v":0},{"$f":"IF('Fee Estimate Tool'!J$77=$B$8,1,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Charge",{"$f":"IFERROR(Y41*$Y$3,0)","v":0},{"$f":"IFERROR(Z41*$Y$3,0)","v":0},{"$f":"IFERROR(AA41*$Y$3,0)","v":0},null,"Hours",{"$f":"IF(COUNTA('Fee Estimate Tool'!J$120,'Fee Estimate Tool'!J$114)<=1,0,IF((('Fee Estimate Tool'!J$120-'Fee Estimate Tool'!J$114)*24)<=$AD$4,$AD$4,('Fee Estimate Tool'!J$120-'Fee Estimate Tool'!J$114)*24))","v":0},{"$f":"IF(COUNTA('Fee Estimate Tool'!J$120,'Fee Estimate Tool'!J$114)<=1,0,IF((('Fee Estimate Tool'!J$120-'Fee Estimate Tool'!J$114)*24)<=AE4,AE4,('Fee Estimate Tool'!J$120-'Fee Estimate Tool'!J$114)*24))","v":0},{"$f":"IF(COUNTA('Fee Estimate Tool'!J$117,'Fee Estimate Tool'!J$120)<=1,0,IF((('Fee Estimate Tool'!J$120-'Fee Estimate Tool'!J$116)*24)<=$AF$4,$AF$4,('Fee Estimate Tool'!J$120-'Fee Estimate Tool'!J$116)*24))","v":0},{"$f":"IF(AG41<=0,0,IF(('Fee Estimate Tool'!J$120-'Fee Estimate Tool'!J$118)*24+0.5<=$AG$4,$AG$4,('Fee Estimate Tool'!J$120-'Fee Estimate Tool'!J$118)*24+0.5))","v":0},{"$f":"IF(AH41<=0,0,IF(('Fee Estimate Tool'!J$120-'Fee Estimate Tool'!J$117)*24<=$AG$4,$AG$4,('Fee Estimate Tool'!J$120-'Fee Estimate Tool'!J$117)*24))","v":0},null,null,null,null,null,null,null,null,null,null,"NEXT DAY"]
["Charge",{"$f":"INDEX($B$3:$E$6,MATCH('Fee Estimate Tool'!$C$15,$A$3:$A$6,0),MATCH($B$1,$B$1:$E$1,0))*B42","v":{"$error":"#N/A"}},{"$f":"INDEX($B$3:$E$6,MATCH('Fee Estimate Tool'!$C$15,$A$3:$A$6,0),MATCH($C$1,$B$1:$E$1,0))*C42","v":{"$error":"#N/A"}},{"$f":"INDEX($B$3:$E$6,MATCH('Fee Estimate Tool'!$C$15,$A$3:$A$6,0),MATCH($D$1,$B$1:$E$1,0))*D42","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL HOURS",{"$f":"Y39+Y37+Y35+Y33+Y31+Y29+Y27+Y23+Y21+Y19+Y17+Y15+Y13+Y11+Y25+Y41","v":0},0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.000011574074074]
["TOTAL FREQUENCY",{"$f":"B12+B14+B16+B18+B20+B22+B24+B26+B28+B30+B32+B34+B36+B38+B40+B42","v":0},{"$f":"C12+C14+C16+C18+C20+C22+C24+C26+C28+C30+C32+C34+C36+C38+C40+C42","v":0},0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL COST",0,0,0,null,"TOAL HOURS",{"$f":"(AD11*AD12)+(AD13*AD14)+(AD15*AD16)+(AD17*AD18)+(AD19*AD20)+(AD21*AD22)+(AD23*AD24)+(AD25*AD26)+(AD27*AD28)+(AD29*AD30)+(AD31*AD32)+(AD33*AD34)+(AD35*AD36)+(AD37*AD38)+(AD39*AD40)+(AD41*AD42)","v":0},{"$f":"(AE11*AE12)+(AE13*AE14)+(AE15*AE16)+(AE17*AE18)+(AE19*AE20)+(AE21*AE22)+(AE23*AE24)+(AE25*AE26)+(AE27*AE28)+(AE29*AE30)+(AE31*AE32)+(AE33*AE34)+(AE35*AE36)+(AE37*AE38)+(AE39*AE40)+(AE41*AE42)","v":0},{"$f":"(AF11*AF12)+(AF13*AF14)+(AF15*AF16)+(AF17*AF18)+(AF19*AF20)+(AF21*AF22)+(AF23*AF24)+(AF25*AF26)+(AF27*AF28)+(AF29*AF30)+(AF31*AF32)+(AF33*AF34)+(AF35*AF36)+(AF37*AF38)+(AF39*AF40)+(AF41*AF42)","v":0},{"$f":"(AG11*AG12)+(AG13*AG14)+(AG15*AG16)+(AG17*AG18)+(AG19*AG20)+(AG21*AG22)+(AG23*AG24)+(AG25*AG26)+(AG27*AG28)+(AG29*AG30)+(AG31*AG32)+(AG33*AG34)+(AG35*AG36)+(AG37*AG38)+(AG39*AG40)+(AG41*AG42)","v":0},{"$f":"(AH11*AH12)+(AH13*AH14)+(AH15*AH16)+(AH17*AH18)+(AH19*AH20)+(AH21*AH22)+(AH23*AH24)+(AH25*AH26)+(AH27*AH28)+(AH29*AH30)+(AH31*AH32)+(AH33*AH34)+(AH35*AH36)+(AH37*AH38)+(AH39*AH40)+(AH41*AH42)","v":0},null,null,null,null,null,null,null,null,null,null,1.0208333333333333]
["TOTAL COST",{"$f":"B13+B15+B17+B19+B21+B23+B25+B27+B29+B31+B33+B35+B37+B39+B41+B43","v":{"$error":"#N/A"}},{"$f":"C13+C15+C17+C19+C21+C23+C25+C27+C29+C31+C33+C35+C37+C39+C41+C43","v":{"$error":"#N/A"}},{"$f":"D13+D15+D17+D19+D21+D23+D25+D27+D29+D31+D33+D35+D37+D39+D41+D43","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.0416666666666667]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.0625]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1.0833333333333299]
["Mandatory Fields","Yes No",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(D1,\" Staffing\")","v":"Rehearsal Hall Staffing"}]
[{"$f":"'Fee Estimate Tool'!B9","v":"Organization Name, if applicable"},{"$f":"IF('Fee Estimate Tool'!C15=Info!$A$4,0,COUNTBLANK('Fee Estimate Tool'!C9))","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Day 1 - Staff #",null,null,{"$f":"IF(AF11>=1,0,IF(AD11>=1,0,IF(COUNTA('Fee Estimate Tool'!C$70:C$71)-COUNTBLANK('Fee Estimate Tool'!C$69)=2,1,0)))","v":0}]
[{"$f":"'Fee Estimate Tool'!B10","v":"Street Address"},{"$f":"IF('Fee Estimate Tool'!C15=Info!$A$4,0,COUNTBLANK('Fee Estimate Tool'!C10))","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hours",null,null,{"$f":"IF((('Fee Estimate Tool'!C$71-'Fee Estimate Tool'!C$70)*24)<=0,0,IF((('Fee Estimate Tool'!C$71-'Fee Estimate Tool'!C$70)*24)<=$AF$4,$AF$4,(('Fee Estimate Tool'!C$71-'Fee Estimate Tool'!C$70)*24)))","v":0}]
[{"$f":"'Fee Estimate Tool'!B12","v":"Postal Code"},{"$f":"IF('Fee Estimate Tool'!C15=Info!$A$4,0,COUNTBLANK('Fee Estimate Tool'!C12))","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Day 2 - Staff #",null,null,{"$f":"IF(AF13>=1,0,IF(AD11>=1,0,IF(COUNTA('Fee Estimate Tool'!D70:D71)-COUNTBLANK('Fee Estimate Tool'!D69)=2,1,0)))","v":0}]
[{"$f":"'Fee Estimate Tool'!B13","v":"Province"},{"$f":"IF('Fee Estimate Tool'!C15=Info!$A$4,0,COUNTBLANK('Fee Estimate Tool'!C13))","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hours",null,null,{"$f":"IF((('Fee Estimate Tool'!D$71-'Fee Estimate Tool'!D$70)*24)<=0,0,IF((('Fee Estimate Tool'!D$71-'Fee Estimate Tool'!D$70)*24)<=$AF$4,$AF$4,(('Fee Estimate Tool'!D$71-'Fee Estimate Tool'!D$70)*24)))","v":0}]
[{"$f":"'Fee Estimate Tool'!B14","v":"Phone Number"},{"$f":"IF('Fee Estimate Tool'!C15=Info!$A$4,0,COUNTBLANK('Fee Estimate Tool'!C14))","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Day 3 - Staff #",null,null,{"$f":"IF(AF15>=1,0,IF(AD11>=1,0,IF(COUNTA('Fee Estimate Tool'!E70:E71)-COUNTBLANK('Fee Estimate Tool'!E69)=2,1,0)))","v":0}]
[{"$f":"'Fee Estimate Tool'!B15","v":"Organizer Status"},{"$f":"COUNTBLANK('Fee Estimate Tool'!C15)","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hours",null,null,{"$f":"IF((('Fee Estimate Tool'!E$71-'Fee Estimate Tool'!E$70)*24)<=0,0,IF((('Fee Estimate Tool'!E$71-'Fee Estimate Tool'!E$70)*24)<=$AF$4,$AF$4,(('Fee Estimate Tool'!E$71-'Fee Estimate Tool'!E$70)*24)))","v":0}]
[{"$f":"'Fee Estimate Tool'!B16","v":"NFP ID Number"},{"$f":"IF(AND('Fee Estimate Tool'!C15=Info!A3,COUNTA('Fee Estimate Tool'!C16:F16)=0),1,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Day 4 - Staff #",null,null,{"$f":"IF(AF17>=1,0,IF(AD11>=1,0,IF(COUNTA('Fee Estimate Tool'!F70:F71)-COUNTBLANK('Fee Estimate Tool'!F69)=2,1,0)))","v":0}]
[{"$f":"'Fee Estimate Tool'!B11","v":"City"},{"$f":"IF('Fee Estimate Tool'!C15=Info!$A$4,0,COUNTBLANK('Fee Estimate Tool'!C11))","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hours",null,null,{"$f":"IF((('Fee Estimate Tool'!F$71-'Fee Estimate Tool'!F$70)*24)<=0,0,IF((('Fee Estimate Tool'!F$71-'Fee Estimate Tool'!F$70)*24)<=$AF$4,$AF$4,(('Fee Estimate Tool'!F$71-'Fee Estimate Tool'!F$70)*24)))","v":0}]
[{"$f":"'Fee Estimate Tool'!B64","v":"Brief description of the event"},{"$f":"COUNTBLANK('Fee Estimate Tool'!C64)","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Day 5 - Staff #",null,null,{"$f":"IF(AF19>=1,0,IF(AD11>=1,0,IF(COUNTA('Fee Estimate Tool'!G70:G71)-COUNTBLANK('Fee Estimate Tool'!G69)=2,1,0)))","v":0}]
[{"$f":"'Fee Estimate Tool'!B20","v":"Signing Authority Name"},{"$f":"COUNTBLANK('Fee Estimate Tool'!C20)","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hours",null,null,{"$f":"IF((('Fee Estimate Tool'!G$71-'Fee Estimate Tool'!G$70)*24)<=0,0,IF((('Fee Estimate Tool'!G$71-'Fee Estimate Tool'!G$70)*24)<=$AF$4,$AF$4,(('Fee Estimate Tool'!G$71-'Fee Estimate Tool'!G$70)*24)))","v":0}]
[{"$f":"'Fee Estimate Tool'!B63","v":"Will you be playing recorded music?"},{"$f":"COUNTBLANK('Fee Estimate Tool'!C63)","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Day 6 - Staff #",null,null,{"$f":"IF(AF21>=1,0,IF(AD11>=1,0,IF(COUNTA('Fee Estimate Tool'!H70:H71)-COUNTBLANK('Fee Estimate Tool'!H69)=2,1,0)))","v":0}]
[{"$f":"'Fee Estimate Tool'!B22","v":"Email"},{"$f":"COUNTBLANK('Fee Estimate Tool'!C22)","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hours",null,null,{"$f":"IF((('Fee Estimate Tool'!H$71-'Fee Estimate Tool'!H$70)*24)<=0,0,IF((('Fee Estimate Tool'!H$71-'Fee Estimate Tool'!H$70)*24)<=$AF$4,$AF$4,(('Fee Estimate Tool'!H$71-'Fee Estimate Tool'!H$70)*24)))","v":0}]
[{"$f":"'Fee Estimate Tool'!B23","v":"Phone Number"},{"$f":"COUNTBLANK('Fee Estimate Tool'!C23)","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Day 7 - Staff #",null,null,{"$f":"IF(AF23>=1,0,IF(AD11>=1,0,IF(COUNTA('Fee Estimate Tool'!I70:I71)-COUNTBLANK('Fee Estimate Tool'!I69)=2,1,0)))","v":0}]
[{"$f":"CONCATENATE('Fee Estimate Tool'!B24,'Fee Estimate Tool'!B25,'Fee Estimate Tool'!B26)","v":"Street AddressCityPostal Code"},{"$f":"IF(COUNTBLANK('Fee Estimate Tool'!C24:F26)>9,1,0)","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hours",null,null,{"$f":"IF((('Fee Estimate Tool'!I$71-'Fee Estimate Tool'!I$70)*24)<=0,0,IF((('Fee Estimate Tool'!I$71-'Fee Estimate Tool'!I$70)*24)<=$AF$4,$AF$4,(('Fee Estimate Tool'!I$71-'Fee Estimate Tool'!I$70)*24)))","v":0}]
[{"$f":"'Fee Estimate Tool'!B28","v":"Will you be purchasing insurance through the City's?"},{"$f":"COUNTBLANK('Fee Estimate Tool'!C28)","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Day 8 - Staff #",null,null,{"$f":"IF(AF25>=1,0,IF(AD11>=1,0,IF(COUNTA('Fee Estimate Tool'!J72:J73)-COUNTBLANK('Fee Estimate Tool'!J71)=2,1,0)))","v":0}]
[{"$f":"'Fee Estimate Tool'!B32","v":"Name"},{"$f":"COUNTBLANK('Fee Estimate Tool'!C32)","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hours",null,null,{"$f":"IF((('Fee Estimate Tool'!J$71-'Fee Estimate Tool'!J$70)*24)<=0,0,IF((('Fee Estimate Tool'!J$71-'Fee Estimate Tool'!J$70)*24)<=$AF$6,$AF$6,(('Fee Estimate Tool'!J$71-'Fee Estimate Tool'!J$70)*24)))","v":0}]
[{"$f":"'Fee Estimate Tool'!B33","v":"Job Title"},{"$f":"COUNTBLANK('Fee Estimate Tool'!C33)","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Day 9 - Staff #",null,null,{"$f":"IF(AF27>=1,0,IF(AD11>=1,0,IF(COUNTA('Fee Estimate Tool'!C75:C76)-COUNTBLANK('Fee Estimate Tool'!C74)=2,1,0)))","v":0}]
[{"$f":"CONCATENATE('Fee Estimate Tool'!B34,\" & \",'Fee Estimate Tool'!B35)","v":"Street Address & City"},{"$f":"COUNTBLANK('Fee Estimate Tool'!C34)+COUNTBLANK('Fee Estimate Tool'!C35)","v":2},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hours",null,null,{"$f":"IF((('Fee Estimate Tool'!C$76-'Fee Estimate Tool'!C$76)*24)<=0,0,IF((('Fee Estimate Tool'!C$76-'Fee Estimate Tool'!C$76)*24)<=$AF$4,$AF$4,(('Fee Estimate Tool'!C$76-'Fee Estimate Tool'!C$76)*24)))","v":0}]
[{"$f":"'Fee Estimate Tool'!B37","v":"Phone Number"},{"$f":"COUNTBLANK('Fee Estimate Tool'!C37)","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Day 10 - Staff #",null,null,{"$f":"IF(AF29>=1,0,IF(AD11>=1,0,IF(COUNTA('Fee Estimate Tool'!D75:D76)-COUNTBLANK('Fee Estimate Tool'!D74)=2,1,0)))","v":0}]
[{"$f":"'Fee Estimate Tool'!B36","v":"Postal Code"},{"$f":"COUNTBLANK('Fee Estimate Tool'!C36)","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hours",null,null,{"$f":"IF((('Fee Estimate Tool'!D$76-'Fee Estimate Tool'!D$76)*24)<=0,0,IF((('Fee Estimate Tool'!D$76-'Fee Estimate Tool'!D$76)*24)<=$AF$4,$AF$4,(('Fee Estimate Tool'!D$76-'Fee Estimate Tool'!D$76)*24)))","v":0}]
[{"$f":"'Fee Estimate Tool'!B38","v":"Email"},{"$f":"COUNTBLANK('Fee Estimate Tool'!C38)","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Day 11 - Staff #",null,null,{"$f":"IF(AF31>=1,0,IF(AD11>=1,0,IF(COUNTA('Fee Estimate Tool'!E75:E76)-COUNTBLANK('Fee Estimate Tool'!E74)=2,1,0)))","v":0}]
["Duplicate Dates",{"$f":"IF(OR(C70>=2,D70>=2,E70>=2,F70>=2,G70>=2,H70>=2,I70>=2,J70>=2,K70>=2,L70>=2,M70>=2,N70>=2,O70>=2,P70>=2),1,0)","v":0},{"$f":"COUNTIF(Calander_Days,'Fee Estimate Tool'!$C43)","v":0},{"$f":"COUNTIF(Calander_Days,'Fee Estimate Tool'!$C44)","v":0},{"$f":"COUNTIF(Calander_Days,'Fee Estimate Tool'!$C45)","v":0},{"$f":"COUNTIF(Calander_Days,'Fee Estimate Tool'!$C46)","v":0},{"$f":"COUNTIF(Calander_Days,'Fee Estimate Tool'!$C47)","v":0},{"$f":"COUNTIF(Calander_Days,'Fee Estimate Tool'!$C48)","v":0},{"$f":"COUNTIF(Calander_Days,'Fee Estimate Tool'!$C49)","v":0},{"$f":"COUNTIF(Calander_Days,'Fee Estimate Tool'!$C50)","v":0},{"$f":"COUNTIF(Calander_Days,'Fee Estimate Tool'!$C51)","v":0},{"$f":"COUNTIF(Calander_Days,'Fee Estimate Tool'!$C52)","v":0},{"$f":"COUNTIF(Calander_Days,'Fee Estimate Tool'!$C53)","v":0},{"$f":"COUNTIF(Calander_Days,'Fee Estimate Tool'!$C54)","v":0},{"$f":"COUNTIF(Calander_Days,'Fee Estimate Tool'!$C55)","v":0},{"$f":"COUNTIF(Calander_Days,'Fee Estimate Tool'!$C56)","v":0},{"$f":"COUNTIF(Calander_Days,'Fee Estimate Tool'!$C57)","v":0},{"$f":"COUNTIF(Calander_Days,'Fee Estimate Tool'!$C58)","v":0},null,null,null,null,null,null,null,null,null,null,"Hours",null,null,{"$f":"IF((('Fee Estimate Tool'!D$76-'Fee Estimate Tool'!D$76)*24)<=0,0,IF((('Fee Estimate Tool'!D$76-'Fee Estimate Tool'!D$76)*24)<=$AF$4,$AF$4,(('Fee Estimate Tool'!D$76-'Fee Estimate Tool'!D$76)*24)))","v":0}]
[{"$f":"'Fee Estimate Tool'!B39","v":"Date of Consent"},{"$f":"COUNTBLANK('Fee Estimate Tool'!C39)","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Day 12 - Staff #",null,null,{"$f":"IF(AF33>=1,0,IF(AD11>=1,0,IF(COUNTA('Fee Estimate Tool'!F75:F76)-COUNTBLANK('Fee Estimate Tool'!F74)=2,1,0)))","v":0}]
[{"$f":"'Fee Estimate Tool'!B62","v":"Will you be using the City's Box Office to sell tickets?"},{"$f":"IF(COUNTA('Fee Estimate Tool'!C62)=1,0,IF(COUNTA('Fee Estimate Tool'!C61:I61)=1,1,0))","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hours",null,null,{"$f":"IF((('Fee Estimate Tool'!D$76-'Fee Estimate Tool'!D$76)*24)<=0,0,IF((('Fee Estimate Tool'!D$76-'Fee Estimate Tool'!D$76)*24)<=$AF$4,$AF$4,(('Fee Estimate Tool'!D$76-'Fee Estimate Tool'!D$76)*24)))","v":0}]
[{"$f":"CONCATENATE('Fee Estimate Tool'!$B$100,\" Section Drop Down 1\")","v":"Required Tech Staffing Section Drop Down 1"},{"$f":"IF(COUNT('Fee Estimate Tool'!C104)=1,COUNTBLANK('Fee Estimate Tool'!B101),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Day 13 - Staff #",null,null,{"$f":"IF(AF35>=1,0,IF(AD11>=1,0,IF(COUNTA('Fee Estimate Tool'!G75:G76)-COUNTBLANK('Fee Estimate Tool'!G74)=2,1,0)))","v":0}]
[{"$f":"CONCATENATE('Fee Estimate Tool'!$B$100,\" Section Drop Down 2\")","v":"Required Tech Staffing Section Drop Down 2"},{"$f":"IF(AND(COUNTIF('Fee Estimate Tool'!C102:I102,1)>=1,COUNTBLANK('Fee Estimate Tool'!B102)=1),1,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hours",null,null,{"$f":"IF((('Fee Estimate Tool'!D$76-'Fee Estimate Tool'!D$76)*24)<=0,0,IF((('Fee Estimate Tool'!D$76-'Fee Estimate Tool'!D$76)*24)<=$AF$4,$AF$4,(('Fee Estimate Tool'!D$76-'Fee Estimate Tool'!D$76)*24)))","v":0}]
[{"$f":"CONCATENATE('Fee Estimate Tool'!$B$132,\" Section Drop Down 3\")","v":"Required Tech Staffing Section Drop Down 3"},{"$f":"IF(COUNT('Fee Estimate Tool'!C136)=1,COUNTBLANK('Fee Estimate Tool'!B133),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Day 14 - Staff #",null,null,{"$f":"IF(AF37>=1,0,IF(AD11>=1,0,IF(COUNTA('Fee Estimate Tool'!H75:H76)-COUNTBLANK('Fee Estimate Tool'!H74)=2,1,0)))","v":0}]
[{"$f":"CONCATENATE('Fee Estimate Tool'!$B$132,\" Section Drop Down 4\")","v":"Required Tech Staffing Section Drop Down 4"},{"$f":"IF(AND(COUNTIF('Fee Estimate Tool'!C134:I134,1)>=1,COUNTBLANK('Fee Estimate Tool'!B134)=1),1,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hours",null,null,{"$f":"IF((('Fee Estimate Tool'!D$76-'Fee Estimate Tool'!D$76)*24)<=0,0,IF((('Fee Estimate Tool'!D$76-'Fee Estimate Tool'!D$76)*24)<=$AF$4,$AF$4,(('Fee Estimate Tool'!D$76-'Fee Estimate Tool'!D$76)*24)))","v":0}]
[{"$f":"'Fee Estimate Tool'!B146","v":"Set construction?"},{"$f":"IF(COUNTA('Fee Estimate Tool'!$C$114:$I$114,'Fee Estimate Tool'!$C$82:$I$82)>=1,IF(COUNTA('Fee Estimate Tool'!D146)=1,0,1),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Day 15- Staff #",null,null,{"$f":"IF(AF39>=1,0,IF(AD11>=1,0,IF(COUNTA('Fee Estimate Tool'!I75:I76)-COUNTBLANK('Fee Estimate Tool'!I74)=2,1,0)))","v":0}]
[{"$f":"'Fee Estimate Tool'!B147","v":"Multi-level stage and platform products?"},{"$f":"IF(COUNTA('Fee Estimate Tool'!$C$114:$I$114,'Fee Estimate Tool'!$C$82:$I$82)>=1,IF(COUNTA('Fee Estimate Tool'!D147)=1,0,1),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hours",null,null,{"$f":"IF((('Fee Estimate Tool'!D$76-'Fee Estimate Tool'!D$76)*24)<=0,0,IF((('Fee Estimate Tool'!D$76-'Fee Estimate Tool'!D$76)*24)<=$AF$4,$AF$4,(('Fee Estimate Tool'!D$76-'Fee Estimate Tool'!D$76)*24)))","v":0}]
[{"$f":"'Fee Estimate Tool'!B148","v":"Risers exceeding 4 feet?"},{"$f":"IF(COUNTA('Fee Estimate Tool'!$C$114:$I$114,'Fee Estimate Tool'!$C$82:$I$82)>=1,IF(COUNTA('Fee Estimate Tool'!D148)=1,0,1),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Day 16 - Staff #",null,null,{"$f":"IF(AF41>=1,0,IF(AD11>=1,0,IF(COUNTA('Fee Estimate Tool'!J75:J76)-COUNTBLANK('Fee Estimate Tool'!J74)=2,1,0)))","v":0}]
[{"$f":"'Fee Estimate Tool'!B149","v":"Aeriel performances?"},{"$f":"IF(COUNTA('Fee Estimate Tool'!$C$114:$I$114,'Fee Estimate Tool'!$C$82:$I$82)>=1,IF(COUNTA('Fee Estimate Tool'!D149)=1,0,1),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hours",null,null,{"$f":"IF((('Fee Estimate Tool'!D$76-'Fee Estimate Tool'!D$76)*24)<=0,0,IF((('Fee Estimate Tool'!D$76-'Fee Estimate Tool'!D$76)*24)<=$AF$4,$AF$4,(('Fee Estimate Tool'!D$76-'Fee Estimate Tool'!D$76)*24)))","v":0}]
[{"$f":"'Fee Estimate Tool'!B150","v":"Use of weapons or stage combat?"},{"$f":"IF(COUNTA('Fee Estimate Tool'!$C$114:$I$114,'Fee Estimate Tool'!$C$82:$I$82)>=1,IF(COUNTA('Fee Estimate Tool'!D150)=1,0,1),0)","v":0}]
[{"$f":"'Fee Estimate Tool'!B151","v":"Use of pyro technics and live flame?"},{"$f":"IF(COUNTA('Fee Estimate Tool'!$C$114:$I$114,'Fee Estimate Tool'!$C$82:$I$82)>=1,IF(COUNTA('Fee Estimate Tool'!D151)=1,0,1),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL HOURS CHARAGEABLE",null,null,{"$f":"((AF49*AF50)+(AF51*AF52)+(AF53*AF54)+(AF55*AF56)+(AF57*AF58)+(AF59*AF60)+(AF61*AF62)+(AF65*AF66)+(AF67*AF68)+(AF69*AF70)+(AF71*AF72)+(AF73*AF74)+(AF75*AF76)+(AF77*AF78)+(AF79*AF80)+(AF63*AF64))","v":0}]
[{"$f":"'Fee Estimate Tool'!B152","v":"Use of audience on stage?"},{"$f":"IF(COUNTA('Fee Estimate Tool'!$C$114:$I$114,'Fee Estimate Tool'!$C$82:$I$82)>=1,IF(COUNTA('Fee Estimate Tool'!D152)=1,0,1),0)","v":0}]
[{"$f":"'Fee Estimate Tool'!B153","v":"Use of animals?"},{"$f":"IF(COUNTA('Fee Estimate Tool'!$C$114:$I$114,'Fee Estimate Tool'!$C$82:$I$82)>=1,IF(COUNTA('Fee Estimate Tool'!D153)=1,0,1),0)","v":0}]
[{"$f":"'Fee Estimate Tool'!B154","v":"Rigging such as banners, backdrops or signs?"},{"$f":"IF(COUNTA('Fee Estimate Tool'!$C$114:$I$114,'Fee Estimate Tool'!$C$82:$I$82)>=1,IF(COUNTA('Fee Estimate Tool'!D154)=1,0,1),0)","v":0}]
[{"$f":"'Fee Estimate Tool'!E146","v":"Lighting hangs or focused lights?"},{"$f":"IF(COUNTA('Fee Estimate Tool'!$C$114:$I$114,'Fee Estimate Tool'!$C$82:$I$82)>=1,IF(COUNTA('Fee Estimate Tool'!H146)=1,0,1),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"CONCATENATE(C1,\" Staffing\")","v":"Lobby Staffing"}]
[{"$f":"'Fee Estimate Tool'!E147","v":"Speeches?"},{"$f":"IF(COUNTA('Fee Estimate Tool'!$C$114:$I$114,'Fee Estimate Tool'!$C$82:$I$82)>=1,IF(COUNTA('Fee Estimate Tool'!H147)=1,0,1),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Day 1 - Staff #",null,null,{"$f":"IF(AF11>=1,0,IF(COUNTA('Fee Estimate Tool'!C$160:C$161)-COUNTBLANK('Fee Estimate Tool'!C158)=2,1,0))","v":0}]
[{"$f":"'Fee Estimate Tool'!E148","v":"Live music performances?"},{"$f":"IF(COUNTA('Fee Estimate Tool'!$C$114:$I$114,'Fee Estimate Tool'!$C$82:$I$82)>=1,IF(COUNTA('Fee Estimate Tool'!H148)=1,0,1),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hours",null,null,{"$f":"IF((('Fee Estimate Tool'!C$161-'Fee Estimate Tool'!C$160)*24)<=0,0,IF((('Fee Estimate Tool'!C$161-'Fee Estimate Tool'!C$160)*24)<=AF4,AF4,(('Fee Estimate Tool'!C$161-'Fee Estimate Tool'!C$160)*24)))","v":0}]
[{"$f":"'Fee Estimate Tool'!E149","v":"Changes to the house plot?"},{"$f":"IF(COUNTA('Fee Estimate Tool'!$C$114:$I$114,'Fee Estimate Tool'!$C$82:$I$82)>=1,IF(COUNTA('Fee Estimate Tool'!H149)=1,0,1),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Day 2 - Staff #",null,null,{"$f":"IF(AF13>=1,0,IF(COUNTA('Fee Estimate Tool'!D$160:D$161)-COUNTBLANK('Fee Estimate Tool'!D158)=2,1,0))","v":0}]
[{"$f":"'Fee Estimate Tool'!E150","v":"Follow spots?"},{"$f":"IF(COUNTA('Fee Estimate Tool'!$C$114:$I$114,'Fee Estimate Tool'!$C$82:$I$82)>=1,IF(COUNTA('Fee Estimate Tool'!H150)=1,0,1),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hours",null,null,{"$f":"IF((('Fee Estimate Tool'!D$161-'Fee Estimate Tool'!D$160)*24)<=0,0,IF((('Fee Estimate Tool'!D$161-'Fee Estimate Tool'!D$160)*24)<=AF4,AF4,(('Fee Estimate Tool'!D$161-'Fee Estimate Tool'!D$160)*24)))","v":0}]
[{"$f":"'Fee Estimate Tool'!E151","v":"Booms for side lights from the wings?"},{"$f":"IF(COUNTA('Fee Estimate Tool'!$C$114:$I$114,'Fee Estimate Tool'!$C$82:$I$82)>=1,IF(COUNTA('Fee Estimate Tool'!H151)=1,0,1),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Day 3 - Staff #",null,null,{"$f":"IF(AF15>=1,0,IF(COUNTA('Fee Estimate Tool'!E$160:E$161)-COUNTBLANK('Fee Estimate Tool'!E158)=2,1,0))","v":0}]
[{"$f":"'Fee Estimate Tool'!E152","v":"Projection of images, videos, PowerPoint, etc."},{"$f":"IF(COUNTA('Fee Estimate Tool'!$C$114:$I$114,'Fee Estimate Tool'!$C$82:$I$82)>=1,IF(COUNTA('Fee Estimate Tool'!H152)=1,0,1),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hours",null,null,{"$f":"IF((('Fee Estimate Tool'!E$161-'Fee Estimate Tool'!E$160)*24)<=0,0,IF((('Fee Estimate Tool'!E$161-'Fee Estimate Tool'!E$160)*24)<=AF4,AF4,(('Fee Estimate Tool'!E$161-'Fee Estimate Tool'!E$160)*24)))","v":0}]
[{"$f":"'Fee Estimate Tool'!E153","v":"Spotlights and/or special lighting?"},{"$f":"IF(COUNTA('Fee Estimate Tool'!$C$114:$I$114,'Fee Estimate Tool'!$C$82:$I$82)>=1,IF(COUNTA('Fee Estimate Tool'!H153)=1,0,1),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Day 4 - Staff #",null,null,{"$f":"IF(AF17>=1,0,IF(COUNTA('Fee Estimate Tool'!F$160:F$161)-COUNTBLANK('Fee Estimate Tool'!F158)=2,1,0))","v":0}]
[{"$f":"'Fee Estimate Tool'!E154","v":"Orchestra pit?"},{"$f":"IF(COUNTA('Fee Estimate Tool'!$C$114:$I$114,'Fee Estimate Tool'!$C$82:$I$82)>=1,IF(COUNTA('Fee Estimate Tool'!H154)=1,0,1),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hours",null,null,{"$f":"IF((('Fee Estimate Tool'!F$161-'Fee Estimate Tool'!F$160)*24)<=0,0,IF((('Fee Estimate Tool'!F$161-'Fee Estimate Tool'!F$160)*24)<=AF4,AF4,(('Fee Estimate Tool'!F$161-'Fee Estimate Tool'!F$160)*24)))","v":0}]
["Lobby Day 1",{"$f":"IF('Fee Estimate Tool'!C$162=\"Required\",1,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Day 5 - Staff #",null,null,{"$f":"IF(AF19>=1,0,IF(COUNTA('Fee Estimate Tool'!G$160:G$161)-COUNTBLANK('Fee Estimate Tool'!G158)=2,1,0))","v":0}]
["Lobby Day 2",{"$f":"IF('Fee Estimate Tool'!D$162=\"Required\",1,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hours",null,null,{"$f":"IF((('Fee Estimate Tool'!G$161-'Fee Estimate Tool'!G$160)*24)<=0,0,IF((('Fee Estimate Tool'!G$161-'Fee Estimate Tool'!G$160)*24)<=AF4,AF4,(('Fee Estimate Tool'!G$161-'Fee Estimate Tool'!G$160)*24)))","v":0}]
["Lobby Day 3",{"$f":"IF('Fee Estimate Tool'!E$162=\"Required\",1,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Day 6 - Staff #",null,null,{"$f":"IF(AF21>=1,0,IF(COUNTA('Fee Estimate Tool'!H$160:H$161)-COUNTBLANK('Fee Estimate Tool'!H158)=2,1,0))","v":0}]
["Lobby Day 4",{"$f":"IF('Fee Estimate Tool'!F$162=\"Required\",1,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hours",null,null,{"$f":"IF((('Fee Estimate Tool'!H$161-'Fee Estimate Tool'!H$160)*24)<=0,0,IF((('Fee Estimate Tool'!H$161-'Fee Estimate Tool'!H$160)*24)<=AF4,AF4,(('Fee Estimate Tool'!H$161-'Fee Estimate Tool'!H$160)*24)))","v":0}]
["Lobby Day 5",{"$f":"IF('Fee Estimate Tool'!G$162=\"Required\",1,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Day 7 - Staff #",null,null,{"$f":"IF(AF23>=1,0,IF(COUNTA('Fee Estimate Tool'!I$160:I$161)-COUNTBLANK('Fee Estimate Tool'!I158)=2,1,0))","v":0}]
["Lobby Day 6",{"$f":"IF('Fee Estimate Tool'!H$162=\"Required\",1,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hours",null,null,{"$f":"IF((('Fee Estimate Tool'!I$161-'Fee Estimate Tool'!I$160)*24)<=0,0,IF((('Fee Estimate Tool'!I$161-'Fee Estimate Tool'!I$160)*24)<=AF4,AF4,(('Fee Estimate Tool'!I$161-'Fee Estimate Tool'!I$160)*24)))","v":0}]
["Lobby Day 7",{"$f":"IF('Fee Estimate Tool'!I$162=\"Required\",1,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Day 8 - Staff #",null,null,{"$f":"IF(AF25>=1,0,IF(COUNTA('Fee Estimate Tool'!I$160:I$161)-COUNTBLANK('Fee Estimate Tool'!I158)=2,1,0))","v":0}]
["Lobby Day 8",{"$f":"IF('Fee Estimate Tool'!J$162=\"Required\",1,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hours",null,null,{"$f":"IF((('Fee Estimate Tool'!J$161-'Fee Estimate Tool'!J$160)*24)<=0,0,IF((('Fee Estimate Tool'!J$161-'Fee Estimate Tool'!I$160)*24)<=$AF$4,$AF$4,(('Fee Estimate Tool'!J$161-'Fee Estimate Tool'!J$160)*24)))","v":0}]
["Lobby Day 9",{"$f":"IF('Fee Estimate Tool'!C$169=\"Required\",1,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Day 9 - Staff #",null,null,{"$f":"IF(AF27>=1,0,IF(COUNTA('Fee Estimate Tool'!C$167:C$168)-COUNTBLANK('Fee Estimate Tool'!C$165)=2,1,0))","v":0}]
["Lobby Day 10",{"$f":"IF('Fee Estimate Tool'!D$169=\"Required\",1,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hours",null,null,{"$f":"IF((('Fee Estimate Tool'!C$168-'Fee Estimate Tool'!C$167)*24)<=0,0,IF((('Fee Estimate Tool'!C$168-'Fee Estimate Tool'!C$167)*24)<=AF4,AF4,(('Fee Estimate Tool'!C$168-'Fee Estimate Tool'!C$167)*24)))","v":0}]
["Lobby Day 11",{"$f":"IF('Fee Estimate Tool'!E$169=\"Required\",1,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Day 10 - Staff #",null,null,{"$f":"IF(AF29>=1,0,IF(COUNTA('Fee Estimate Tool'!D$167:D$168)-COUNTBLANK('Fee Estimate Tool'!D$165)=2,1,0))","v":0}]
["Lobby Day 12",{"$f":"IF('Fee Estimate Tool'!F$169=\"Required\",1,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hours",null,null,{"$f":"IF((('Fee Estimate Tool'!D$168-'Fee Estimate Tool'!D$167)*24)<=0,0,IF((('Fee Estimate Tool'!D$168-'Fee Estimate Tool'!D$167)*24)<=AF4,AF4,(('Fee Estimate Tool'!D$168-'Fee Estimate Tool'!D$167)*24)))","v":0}]
["Lobby Day 13",{"$f":"IF('Fee Estimate Tool'!G$169=\"Required\",1,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Day 11 - Staff #",null,null,{"$f":"IF(AF31>=1,0,IF(COUNTA('Fee Estimate Tool'!E$167:E$168)-COUNTBLANK('Fee Estimate Tool'!E$165)=2,1,0))","v":0}]
["Lobby Day 14",{"$f":"IF('Fee Estimate Tool'!H$169=\"Required\",1,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hours",null,null,{"$f":"IF((('Fee Estimate Tool'!E$168-'Fee Estimate Tool'!E$167)*24)<=0,0,IF((('Fee Estimate Tool'!E$168-'Fee Estimate Tool'!E$167)*24)<=AF4,AF4,(('Fee Estimate Tool'!E$168-'Fee Estimate Tool'!E$167)*24)))","v":0}]
["Lobby Day 15",{"$f":"IF('Fee Estimate Tool'!I$169=\"Required\",1,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Day 12 - Staff #",null,null,{"$f":"IF(AF33>=1,0,IF(COUNTA('Fee Estimate Tool'!F$167:F$168)-COUNTBLANK('Fee Estimate Tool'!F$165)=2,1,0))","v":0}]
["Lobby Day 16",{"$f":"IF('Fee Estimate Tool'!J$169=\"Required\",1,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hours",null,null,{"$f":"IF((('Fee Estimate Tool'!F$168-'Fee Estimate Tool'!F$167)*24)<=0,0,IF((('Fee Estimate Tool'!F$168-'Fee Estimate Tool'!F$167)*24)<=AF4,AF4,(('Fee Estimate Tool'!F$168-'Fee Estimate Tool'!F$167)*24)))","v":0}]
[{"$f":"'Fee Estimate Tool'!B170","v":"Will you have a lobby display?"},{"$f":"IF(COUNTA('Fee Estimate Tool'!$C$160:$I$160,'Fee Estimate Tool'!$C$167:$I$167)>=1,IF(COUNTA('Fee Estimate Tool'!D170)=1,0,1),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Day 13 - Staff #",null,null,{"$f":"IF(AF35>=1,0,IF(COUNTA('Fee Estimate Tool'!G$167:G$168)-COUNTBLANK('Fee Estimate Tool'!G$165)=2,1,0))","v":0}]
[{"$f":"'Fee Estimate Tool'!B171","v":"Will you have vendors?"},{"$f":"IF(COUNTA('Fee Estimate Tool'!$C$160:$I$160,'Fee Estimate Tool'!$C$167:$I$167)>=1,IF(COUNTA('Fee Estimate Tool'!D171)=1,0,1),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hours",null,null,{"$f":"IF((('Fee Estimate Tool'!G$168-'Fee Estimate Tool'!G$167)*24)<=0,0,IF((('Fee Estimate Tool'!G$168-'Fee Estimate Tool'!G$167)*24)<=AF4,AF4,(('Fee Estimate Tool'!G$168-'Fee Estimate Tool'!G$167)*24)))","v":0}]
[{"$f":"'Fee Estimate Tool'!B172","v":"Will you and the vendors requires tables and chairs? "},{"$f":"IF(COUNTA('Fee Estimate Tool'!$C$160:$I$160,'Fee Estimate Tool'!$C$167:$I$167)>=1,IF(COUNTA('Fee Estimate Tool'!D172)=1,0,1),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Day 14 - Staff #",null,null,{"$f":"IF(AF37>=1,0,IF(COUNTA('Fee Estimate Tool'!H$167:H$168)-COUNTBLANK('Fee Estimate Tool'!H$165)=2,1,0))","v":0}]
["Duplicate Dates",{"$f":"COUNTIF('Fee Estimate Tool'!D43,\"Warn*\")","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hours",null,null,{"$f":"IF((('Fee Estimate Tool'!H$168-'Fee Estimate Tool'!H$167)*24)<=0,0,IF((('Fee Estimate Tool'!H$168-'Fee Estimate Tool'!H$167)*24)<=AF4,AF4,(('Fee Estimate Tool'!H$168-'Fee Estimate Tool'!H$167)*24)))","v":0}]
[null,{"$f":"IF(COUNTA('Fee Estimate Tool'!$C$160:$I$160,'Fee Estimate Tool'!$C$167:$I$167)>=1,IF(COUNTA('Fee Estimate Tool'!#REF!)=1,0,1),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Day 15- Staff #",null,null,{"$f":"IF(AF39>=1,0,IF(COUNTA('Fee Estimate Tool'!I$167:I$168)-COUNTBLANK('Fee Estimate Tool'!I$165)=2,1,0))","v":0}]
[null,{"$f":"IF(COUNTA('Fee Estimate Tool'!$C$160:$I$160,'Fee Estimate Tool'!$C$167:$I$167)>=1,IF(COUNTA('Fee Estimate Tool'!#REF!)=1,0,1),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hours",null,null,{"$f":"IF((('Fee Estimate Tool'!I$168-'Fee Estimate Tool'!I$167)*24)<=0,0,IF((('Fee Estimate Tool'!I$168-'Fee Estimate Tool'!I$167)*24)<=AF4,AF4,(('Fee Estimate Tool'!I$168-'Fee Estimate Tool'!I$167)*24)))","v":0}]
[{"$f":"'Fee Estimate Tool'!B175","v":"Will there be food distributed?"},{"$f":"IF(COUNTA('Fee Estimate Tool'!$C$160:$I$160,'Fee Estimate Tool'!$C$167:$I$167)>=1,IF(COUNTA('Fee Estimate Tool'!D175)=1,0,1),0)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Day 16 - Staff #",null,null,{"$f":"IF(AF41>=1,0,IF(COUNTA('Fee Estimate Tool'!I$167:I$168)-COUNTBLANK('Fee Estimate Tool'!I$165)=2,1,0))","v":0}]
["SUM",{"$f":"SUM(B49:B117)","v":22},{"$f":"IF($B$118>0,1,0)","v":1},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hours",null,null,{"$f":"IF((('Fee Estimate Tool'!J$168-'Fee Estimate Tool'!J$167)*24)<=0,0,IF((('Fee Estimate Tool'!J$168-'Fee Estimate Tool'!J$167)*24)<=AF4,AF4,(('Fee Estimate Tool'!J$168-'Fee Estimate Tool'!J$167)*24)))","v":0}]
[null,"Missing Information",{"$f":"IF(C118=1,$B$119,\"\")","v":"Missing Information"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"TOTAL HOURS CHARAGEABLE",null,null,{"$f":"((AF87*AF88)+(AF89*AF90)+(AF91*AF92)+(AF93*AF94)+(AF95*AF96)+(AF97*AF98)+(AF99*AF100)+(AF103*AF104)+(AF105*AF106)+(AF107*AF108)+(AF109*AF110)+(AF111*AF112)+(AF113*AF114)+(AF115*AF116)+(AF117*AF118)+(AF101*AF102))","v":0}]

{"sheet":"Fees","index":2,"n_rows":66,"n_cols":8,"rows_kept":66,"cut":false,"hidden":true,"merged":[]}
["IMPORTANT NOTES",null,null,null,null,null,null,"HIDE COLUMNS BY CLICKING HEADER ABOVE \"H\""]
["example","Fields in Grey are to be edited without breaking the formulas that auto-calculated the fees",null,null,null,null,null,"THEN HOLD THE SHIFT KEY and click header \"A\""]
["example","Dark blue cells are to be edited here and will copy over to the Fee Estimate Tool Sheet",null,null,null,null,null,"THEN RIGHT CLICK \"A\""]
["example","Black cells are not to be touched",null,null,null,null,null,"SELECT \"HIDE\""]
[]
["Rates in effect January 2019 - December 2019"]
[null,"Registered Not-for-Profit / Community Group","Private","Affiliate","Commercial"]
["Theatre Auditorium",314,418,235,627]
["Rehearsal Hall",122,155,99,200]
["Lobby",320,400,183,520]
["Green Room",0,0,0,0]
["Additional Fees"]
["Daily"]
["Fog Machine",25,25,15,25]
["Hazer",25,25,15,25]
["Wireless Microphones",35,35,17.5,35]
["Intelligent Lighting Package",300,300,300,300]
["Wireless Communication Pack",35,35,17.5,35]
["Weekly"]
[{"$f":"A14","v":"Fog Machine"},75,75,60,75]
[{"$f":"A15","v":"Hazer"},75,75,60,75]
[{"$f":"A16","v":"Wireless Microphones"},100,100,62.5,100]
[{"$f":"A17","v":"Intelligent Lighting Package"},300,300,300,300]
["Wireless Communication Pack",100,100,62.5,100]
[]
["Glow Tape (per foot)",1.5,"per foot"]
["Gaff Tape",40,"per roll"]
[null,null,null,"Min Hr. Req.","Min # of Staff Req."]
["Technical Supervisor",48.5,"per hour",4]
["Front of House Coordinator",48.5,"per hour",3]
["Technician",26,"per hour",4]
["Front of House Usher",19.5,"per hour",3,2]
[]
["Late Use Charge per hour (tax)",140]
["Box Office Commission",7.0000000000000007E-2]
["Community Access Fund Fee",1.5]
["Piano",200]
["Resound Fee"]
["S.O.C.A.N. Fee"]
["Cleaning Fee",50]
["Ticket Printing",0.2]
[]
["Meal Charges (per person, per infringement)",20]
["HST",0.13]
["Late Payment Interest",1.2500000000000001E-2]
["Non-Sufficient Funds (NSF) Charge",40]
[]
["Insurance Purchased through the City, includes taxes at 8%",42.32,126.97]
["Default Ticket Print Amount",395]
["Technical Staff Drop Down","Seating"]
["Lighting Board Operator","General Seating"]
["Hang/Focus Crew","Assigned Seating"]
["Follow Spot Operator"]
["Sound Board Operator (audio engineer)"]
["Monitor Mix"]
["Stage Hand"]
["Video Operator"]
["Other"]
["Rigging Crew / Fly Operator"]
["Technical Supervisor"]
[]
[]
[]
[]
["Initial Deposit for Box-Office Services",0.5]
["Initial Deposit for No Box-Office Services",0.2]