{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Calc Sheet","Data"],"not_rendered":{"charts":0,"images":3,"macros":1,"external_links":0,"defined_names":1,"comments":1,"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":"Calc Sheet","index":0,"n_rows":225,"n_cols":8,"rows_kept":225,"cut":false,"hidden":false,"merged":[[7,0,7,2],[8,0,8,2],[9,0,9,2],[0,0,4,3],[186,0,186,3],[11,0,11,3],[46,0,46,2],[60,0,60,2],[74,0,74,2],[88,0,88,2],[19,0,19,3],[20,0,20,3],[33,0,33,3],[102,0,102,2],[116,0,116,2],[130,0,130,2],[144,0,144,2],[158,0,158,2],[62,0,62,2],[63,0,63,2],[64,0,64,2],[65,0,65,2],[66,0,66,2],[57,0,57,2],[58,0,58,2],[44,0,44,1],[61,0,61,2],[52,0,52,2],[53,0,53,2],[54,0,54,2],[55,0,55,2],[56,0,56,2],[47,0,47,2],[48,0,48,2],[49,0,49,2],[50,0,50,2],[51,0,51,2],[72,0,72,2],[75,0,75,2],[76,0,76,2],[77,0,77,2],[78,0,78,2],[67,0,67,2],[68,0,68,2],[69,0,69,2],[70,0,70,2],[71,0,71,2],[84,0,84,2],[85,0,85,2],[86,0,86,2],[89,0,89,2],[90,0,90,2],[79,0,79,2],[80,0,80,2],[81,0,81,2],[82,0,82,2],[83,0,83,2],[96,0,96,2],[97,0,97,2],[98,0,98,2],[99,0,99,2],[100,0,100,2],[91,0,91,2],[92,0,92,2],[93,0,93,2],[94,0,94,2],[95,0,95,2],[119,0,119,2],[120,0,120,2],[121,0,121,2],[122,0,122,2],[123,0,123,2],[114,0,114,2],[103,0,103,2],[117,0,117,2],[118,0,118,2],[109,0,109,2],[110,0,110,2],[111,0,111,2],[112,0,112,2],[113,0,113,2],[104,0,104,2],[105,0,105,2],[106,0,106,2],[107,0,107,2],[108,0,108,2],[131,0,131,2],[132,0,132,2],[133,0,133,2],[134,0,134,2],[135,0,135,2],[124,0,124,2],[125,0,125,2],[126,0,126,2],[127,0,127,2],[128,0,128,2],[141,0,141,2],[142,0,142,2],[145,0,145,2],[146,0,146,2],[147,0,147,2],[136,0,136,2],[137,0,137,2],[138,0,138,2],[139,0,139,2],[140,0,140,2],[163,0,163,2],[164,0,164,2],[153,0,153,2],[154,0,154,2],[155,0,155,2],[156,0,156,2],[159,0,159,2],[148,0,148,2],[149,0,149,2],[150,0,150,2],[151,0,151,2],[152,0,152,2],[11,5,11,7],[182,0,182,2],[183,0,183,2],[184,0,184,2],[214,0,214,2],[177,0,177,2],[178,0,178,2],[179,0,179,2],[180,0,180,2],[181,0,181,2],[170,0,170,2],[173,0,173,2],[174,0,174,2],[175,0,175,2],[176,0,176,2],[165,0,165,2],[166,0,166,2],[167,0,167,2],[168,0,168,2],[169,0,169,2],[172,0,172,2],[160,0,160,2],[161,0,161,2],[162,0,162,2]]}
["                       EDGE Project Certification Fee Calculator\n\n"]
[]
[]
[]
[]
[]
["  "]
["Are you a member of the Green Building Council SA?",null,null,"No"]
["How many submission phases will the development have?",null,null,1]
["What is the total number of typologies for the development?",null,null,1]
[]
["Submission Fee structure",null,null,null,null,"Table 1: Phasing fees"]
["Base fee per typology",null,null,{"$f":"IF($D$8=\"Yes\",VLOOKUP(A13,Data!$A$6:$C$12,2,FALSE),VLOOKUP(A13,Data!$A$6:$C$12,3,FALSE))","v":45395},null,"Typology","Fee per typology","Cumulative total"]
["Base fee per m² for units < 80m²",null,null,{"$f":"IF($D$8=\"Yes\",VLOOKUP(A14,Data!$A$6:$C$12,2,FALSE),VLOOKUP(A14,Data!$A$6:$C$12,3,FALSE))","v":6},null,1,{"$f":"Data!B25","v":10000},{"$f":"Data!C25","v":10000}]
["Base fee per m² for units 80m² < 250m²",null,null,{"$f":"IF($D$8=\"Yes\",VLOOKUP(A15,Data!$A$6:$C$12,2,FALSE),VLOOKUP(A15,Data!$A$6:$C$12,3,FALSE))","v":8},null,2,{"$f":"Data!B26","v":5000},{"$f":"Data!C26","v":15000}]
["Base fee per m² for units > 250m²",null,null,{"$f":"IF($D$8=\"Yes\",VLOOKUP(A16,Data!$A$6:$C$12,2,FALSE),VLOOKUP(A16,Data!$A$6:$C$12,3,FALSE))","v":10},null,3,{"$f":"Data!B27","v":2500},{"$f":"Data!C27","v":17500}]
["Fee for additional phases (more than 1 phase), per Typology",null,null,"As per table 1",null,4,{"$f":"Data!B28","v":1240},{"$f":"Data!C28","v":18740}]
[null,null,null,null,null,5,{"$f":"Data!B29","v":640},{"$f":"Data!C29","v":19380}]
[null,null,null,null,null,6,{"$f":"Data!B30","v":320},{"$f":"Data!C30","v":19700}]
["Summary of the total submission cost ",null,null,null,null,7,{"$f":"Data!B31","v":160},{"$f":"Data!C31","v":19860}]
["Base fees (including the phasing fee if submitted in phases)",null,null,null,null,8,{"$f":"Data!B32","v":80},{"$f":"Data!C32","v":19940}]
["Description","Unit Size (m²)","Quantity","Cost",null,9,{"$f":"Data!B33","v":40},{"$f":"Data!C33","v":19980}]
["    Base fee per typology",null,{"$f":"D10","v":1},{"$f":"C23*D13","v":45395},null,10,{"$f":"Data!B34","v":20},{"$f":"Data!C34","v":20000}]
["    Submission phase 1",null,{"$f":"D47","v":0},{"$f":"C24*0","v":0}]
["    Submission phase 2",null,{"$f":"D61","v":0},{"$f":"IF('Calc Sheet'!C25=1,Data!$C$25,IF('Calc Sheet'!C25=2,Data!$C$26,IF('Calc Sheet'!C25=3,Data!$C$27,IF('Calc Sheet'!C25=4,Data!$C$28,IF('Calc Sheet'!C25=5,Data!$C$29,IF('Calc Sheet'!C25=6,Data!$C$30,IF('Calc Sheet'!C25=7,Data!$C$31,IF('Calc Sheet'!C25=8,Data!$C$32,IF('Calc Sheet'!C25=9,Data!$C$33,IF('Calc Sheet'!C25=10,Data!$C$34,))))))))))","v":0}]
["    Submission phase 3",null,{"$f":"D75","v":0},{"$f":"IF('Calc Sheet'!C26=1,Data!$C$25,IF('Calc Sheet'!C26=2,Data!$C$26,IF('Calc Sheet'!C26=3,Data!$C$27,IF('Calc Sheet'!C26=4,Data!$C$28,IF('Calc Sheet'!C26=5,Data!$C$29,IF('Calc Sheet'!C26=6,Data!$C$30,IF('Calc Sheet'!C26=7,Data!$C$31,IF('Calc Sheet'!C26=8,Data!$C$32,IF('Calc Sheet'!C26=9,Data!$C$33,IF('Calc Sheet'!C26=10,Data!$C$34,))))))))))","v":0}]
["    Submission phase 4",null,{"$f":"D89","v":0},{"$f":"IF('Calc Sheet'!C27=1,Data!$C$25,IF('Calc Sheet'!C27=2,Data!$C$26,IF('Calc Sheet'!C27=3,Data!$C$27,IF('Calc Sheet'!C27=4,Data!$C$28,IF('Calc Sheet'!C27=5,Data!$C$29,IF('Calc Sheet'!C27=6,Data!$C$30,IF('Calc Sheet'!C27=7,Data!$C$31,IF('Calc Sheet'!C27=8,Data!$C$32,IF('Calc Sheet'!C27=9,Data!$C$33,IF('Calc Sheet'!C27=10,Data!$C$34,))))))))))","v":0}]
["    Submission phase 5",null,{"$f":"D103","v":0},{"$f":"IF('Calc Sheet'!C28=1,Data!$C$25,IF('Calc Sheet'!C28=2,Data!$C$26,IF('Calc Sheet'!C28=3,Data!$C$27,IF('Calc Sheet'!C28=4,Data!$C$28,IF('Calc Sheet'!C28=5,Data!$C$29,IF('Calc Sheet'!C28=6,Data!$C$30,IF('Calc Sheet'!C28=7,Data!$C$31,IF('Calc Sheet'!C28=8,Data!$C$32,IF('Calc Sheet'!C28=9,Data!$C$33,IF('Calc Sheet'!C28=10,Data!$C$34,))))))))))","v":0}]
["    Submission phase 6",null,{"$f":"D117","v":0},{"$f":"IF('Calc Sheet'!C29=1,Data!$C$25,IF('Calc Sheet'!C29=2,Data!$C$26,IF('Calc Sheet'!C29=3,Data!$C$27,IF('Calc Sheet'!C29=4,Data!$C$28,IF('Calc Sheet'!C29=5,Data!$C$29,IF('Calc Sheet'!C29=6,Data!$C$30,IF('Calc Sheet'!C29=7,Data!$C$31,IF('Calc Sheet'!C29=8,Data!$C$32,IF('Calc Sheet'!C29=9,Data!$C$33,IF('Calc Sheet'!C29=10,Data!$C$34,))))))))))","v":0}]
["    Submission phase 7",null,{"$f":"D131","v":0},{"$f":"IF('Calc Sheet'!C30=1,Data!$C$25,IF('Calc Sheet'!C30=2,Data!$C$26,IF('Calc Sheet'!C30=3,Data!$C$27,IF('Calc Sheet'!C30=4,Data!$C$28,IF('Calc Sheet'!C30=5,Data!$C$29,IF('Calc Sheet'!C30=6,Data!$C$30,IF('Calc Sheet'!C30=7,Data!$C$31,IF('Calc Sheet'!C30=8,Data!$C$32,IF('Calc Sheet'!C30=9,Data!$C$33,IF('Calc Sheet'!C30=10,Data!$C$34,))))))))))","v":0}]
["    Submission phase 8",null,{"$f":"D145","v":0},{"$f":"IF('Calc Sheet'!C31=1,Data!$C$25,IF('Calc Sheet'!C31=2,Data!$C$26,IF('Calc Sheet'!C31=3,Data!$C$27,IF('Calc Sheet'!C31=4,Data!$C$28,IF('Calc Sheet'!C31=5,Data!$C$29,IF('Calc Sheet'!C31=6,Data!$C$30,IF('Calc Sheet'!C31=7,Data!$C$31,IF('Calc Sheet'!C31=8,Data!$C$32,IF('Calc Sheet'!C31=9,Data!$C$33,IF('Calc Sheet'!C31=10,Data!$C$34,))))))))))","v":0}]
["    Submission phase 9",null,{"$f":"D159","v":0},{"$f":"IF('Calc Sheet'!C32=1,Data!$C$25,IF('Calc Sheet'!C32=2,Data!$C$26,IF('Calc Sheet'!C32=3,Data!$C$27,IF('Calc Sheet'!C32=4,Data!$C$28,IF('Calc Sheet'!C32=5,Data!$C$29,IF('Calc Sheet'!C32=6,Data!$C$30,IF('Calc Sheet'!C32=7,Data!$C$31,IF('Calc Sheet'!C32=8,Data!$C$32,IF('Calc Sheet'!C32=9,Data!$C$33,IF('Calc Sheet'!C32=10,Data!$C$34,))))))))))","v":0}]
["    Submission phase 10",null,{"$f":"D173","v":0},{"$f":"IF('Calc Sheet'!C33=1,Data!$C$25,IF('Calc Sheet'!C33=2,Data!$C$26,IF('Calc Sheet'!C33=3,Data!$C$27,IF('Calc Sheet'!C33=4,Data!$C$28,IF('Calc Sheet'!C33=5,Data!$C$29,IF('Calc Sheet'!C33=6,Data!$C$30,IF('Calc Sheet'!C33=7,Data!$C$31,IF('Calc Sheet'!C33=8,Data!$C$32,IF('Calc Sheet'!C33=9,Data!$C$33,IF('Calc Sheet'!C33=10,Data!$C$34,))))))))))","v":0}]
["Typologies"]
[null,null,null,{"$f":"IF(B35<80,$D$14*B35*C35,IF(B35<250,$D$15*B35*C35,IF(B35>=250,B35*$D$16*C35)))","v":0}]
[null,null,null,{"$f":"IF(B36<80,$D$14*B36*C36,IF(B36<250,$D$15*B36*C36,IF(B36>=250,B36*$D$16*C36)))","v":0}]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
[null,null,null,0]
["Total (Incl. VAT)",null,{"$f":"SUM(C35:C44)","v":0},{"$f":"SUM(D23:D44)","v":45395}]
[]
["Submission Phase 1",null,null,0]
["Typology name",null,null,"Quantity"]
["<Please select the typology name provided from the drop down menu>"]
["<Please select the typology name provided from the drop down menu>"]
["<Please select the typology name provided from the drop down menu>"]
["<Please select the typology name provided from the drop down menu>"]
["<Please select the typology name provided from the drop down menu>"]
["<Please select the typology name provided from the drop down menu>"]
["<Please select the typology name provided from the drop down menu>"]
["<Please select the typology name provided from the drop down menu>"]
["<Please select the typology name provided from the drop down menu>"]
["<Please select the typology name provided from the drop down menu>"]
["Total for Phase 1",null,null,{"$f":"SUM(D49:D58)","v":0}]
[]
["Submission Phase 2",null,null,0]
["Typology name",null,null,"Quantity"]
["<Please select the typology name provided from the drop down menu>"]
["<Please select the typology name provided from the drop down menu>"]
["<Please select the typology name provided from the drop down menu>"]
["<Please select the typology name provided from the drop down menu>"]
["<Please select the typology name provided from the drop down menu>"]
["<Please select the typology name provided from the drop down menu>"]
["<Please select the typology name provided from the drop down menu>"]
["<Please select the typology name provided from the drop down menu>"]
["<Please select the typology name provided from the drop down menu>"]
["<Please select the typology name provided from the drop down menu>"]
["Total for Phase 2",null,null,{"$f":"SUM(D63:D72)","v":0}]
[]
["Submission Phase 3",null,null,0]
["Typology name",null,null,"Quantity"]
["<Please select the typology name provided from the drop down menu>"]
["<Please select the typology name provided from the drop down menu>"]
["<Please select the typology name provided from the drop down menu>"]
["<Please select the typology name provided from the drop down menu>"]
["<Please select the typology name provided from the drop down menu>"]
["<Please select the typology name provided from the drop down menu>"]
["<Please select the typology name provided from the drop down menu>"]
["<Please select the typology name provided from the drop down menu>"]
["<Please select the typology name provided from the drop down menu>"]
["<Please select the typology name provided from the drop down menu>"]
["Total for Phase 3",null,null,{"$f":"SUM(D77:D86)","v":0}]
[]
["Submission Phase 4",null,null,0]
["Typology name",null,null,"Quantity"]
["<Please select the typology name provided from the drop down menu>"]
["<Please select the typology name provided from the drop down menu>"]
["<Please select the typology name provided from the drop down menu>"]
["<Please select the typology name provided from the drop down menu>"]
["<Please select the typology name provided from the drop down menu>"]
["<Please select the typology name provided from the drop down menu>"]
["<Please select the typology name provided from the drop down menu>"]
["<Please select the typology name provided from the drop down menu>"]
["<Please select the typology name provided from the drop down menu>"]
["<Please select the typology name provided from the drop down menu>"]
["Total for Phase 4",null,null,{"$f":"SUM(D91:D100)","v":0}]
[]
["Submission Phase 5",null,null,0]
["Typology name",null,null,"Quantity"]
["<Please select the typology name provided from the drop down menu>"]
["<Please select the typology name provided from the drop down menu>"]
["<Please select the typology name provided from the drop down menu>"]
["<Please select the typology name provided from the drop down menu>"]
["<Please select the typology name provided from the drop down menu>"]
["<Please select the typology name provided from the drop down menu>"]
["<Please select the typology name provided from the drop down menu>"]
["<Please select the typology name provided from the drop down menu>"]
["<Please select the typology name provided from the drop down menu>"]
["<Please select the typology name provided from the drop down menu>"]
["Total for Phase 5",null,null,{"$f":"SUM(D105:D114)","v":0}]
[]
["Submission Phase 6",null,null,0]
["Typology name",null,null,"Quantity"]
["<Please select the typology name provided from the drop down menu>"]
["<Please select the typology name provided from the drop down menu>"]
["<Please select the typology name provided from the drop down menu>"]
["<Please select the typology name provided from the drop down menu>"]
["<Please select the typology name provided from the drop down menu>"]
["<Please select the typology name provided from the drop down menu>"]
["<Please select the typology name provided from the drop down menu>"]
["<Please select the typology name provided from the drop down menu>"]
["<Please select the typology name provided from the drop down menu>"]
["<Please select the typology name provided from the drop down menu>"]
["Total for Phase 6",null,null,{"$f":"SUM(D119:D128)","v":0}]
[]
["Submission Phase 7",null,null,0]
["Typology name",null,null,"Quantity"]
["<Please select the typology name provided from the drop down menu>"]
["<Please select the typology name provided from the drop down menu>"]
["<Please select the typology name provided from the drop down menu>"]
["<Please select the typology name provided from the drop down menu>"]
["<Please select the typology name provided from the drop down menu>"]
["<Please select the typology name provided from the drop down menu>"]
["<Please select the typology name provided from the drop down menu>"]
["<Please select the typology name provided from the drop down menu>"]
["<Please select the typology name provided from the drop down menu>"]
["<Please select the typology name provided from the drop down menu>"]
["Total for Phase 7",null,null,{"$f":"SUM(D133:D142)","v":0}]
[]
["Submission Phase 8",null,null,0]
["Typology name",null,null,"Quantity"]
["<Please select the typology name provided from the drop down menu>"]
["<Please select the typology name provided from the drop down menu>"]
["<Please select the typology name provided from the drop down menu>"]
["<Please select the typology name provided from the drop down menu>"]
["<Please select the typology name provided from the drop down menu>"]
["<Please select the typology name provided from the drop down menu>"]
["<Please select the typology name provided from the drop down menu>"]
["<Please select the typology name provided from the drop down menu>"]
["<Please select the typology name provided from the drop down menu>"]
["<Please select the typology name provided from the drop down menu>"]
["Total for Phase 8",null,null,{"$f":"SUM(D147:D156)","v":0}]
[]
["Submission Phase 9",null,null,0]
["Typology name",null,null,"Quantity"]
["<Please select the typology name provided from the drop down menu>"]
["<Please select the typology name provided from the drop down menu>"]
["<Please select the typology name provided from the drop down menu>"]
["<Please select the typology name provided from the drop down menu>"]
["<Please select the typology name provided from the drop down menu>"]
["<Please select the typology name provided from the drop down menu>"]
["<Please select the typology name provided from the drop down menu>"]
["<Please select the typology name provided from the drop down menu>"]
["<Please select the typology name provided from the drop down menu>"]
["<Please select the typology name provided from the drop down menu>"]
["Total for Phase 9",null,null,{"$f":"SUM(D161:D170)","v":0}]
[]
["Submission Phase 10",null,null,0]
["Typology name",null,null,"Quantity"]
["<Please select the typology name provided from the drop down menu>"]
["<Please select the typology name provided from the drop down menu>"]
["<Please select the typology name provided from the drop down menu>"]
["<Please select the typology name provided from the drop down menu>"]
["<Please select the typology name provided from the drop down menu>"]
["<Please select the typology name provided from the drop down menu>"]
["<Please select the typology name provided from the drop down menu>"]
["<Please select the typology name provided from the drop down menu>"]
["<Please select the typology name provided from the drop down menu>"]
["<Please select the typology name provided from the drop down menu>"]
["Total for Phase 10",null,null,{"$f":"SUM(D175:D184)","v":0}]
[]
["Summary of the total submission cost "]
["Cost item","Size","Quantity","Cost"]
["Base fees"]
["    Base fee per typology",null,{"$f":"$D$10","v":1},{"$f":"C190*D13","v":45395}]
["    Submission phase 1",null,null,{"$f":"$D$59","v":0}]
["    Submission phase 2",null,null,{"$f":"$D$73","v":0}]
["    Submission phase 3",null,null,{"$f":"$D$87","v":0}]
["    Submission phase 4",null,null,{"$f":"$D$101","v":0}]
["    Submission phase 5",null,null,{"$f":"$D$115","v":0}]
["    Submission phase 6",null,null,{"$f":"$D$129","v":0}]
["    Submission phase 7",null,null,{"$f":"$D$143","v":0}]
["    Submission phase 8",null,null,{"$f":"$D$157","v":0}]
["    Submission phase 9",null,null,{"$f":"$D$157","v":0}]
["    Submission phase 10",null,null,{"$f":"$D$185","v":0}]
["Typologies"]
["    Type A",null,null,{"$f":"C202*B202*$D$14","v":0}]
["    Type B",null,null,0]
["    Type C",null,null,0]
["    Type D",null,null,0]
["    Type E",null,null,0]
["    Type F",null,null,0]
["    Type G",null,null,0]
["    Type H",null,null,0]
["    Type I",null,null,0]
["    Type J",null,null,0]
["Total",null,null,{"$f":"SUM(D190:D211)","v":45395}]
[]
[]
["Total amount of units",null,null,{"$f":"SUM(D185,D171,D157,D143,D129,D115,D101,D87,D73,D59)","v":0}]
[null,null,null,{"$f":"IF(D215=C45,\" \",\"Please correct the 'Number of Units' specified\")","v":" "}]
[]
[]
[]
[]
[null,null,"Client Signed"]
[]
[]
[]
[null,null,"Accepted by the GBCSA"]

{"sheet":"Data","index":1,"n_rows":34,"n_cols":3,"rows_kept":34,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,"Member \n(Incl. VAT)","Non Member \n(Incl VAT)"]
[]
["Base fees","Yes","No"]
["Base fee per typology",34299,45395]
["Base fee per m² for units < 80m²",5,6]
["Base fee per m² for units 80m² < 250m²",6,8]
["Base fee per m² for units > 250m²",7,10]
["Fee for additional phases, per Typology",10000,15000]
["Assessor fee per phase ",5000,7000]
[null,0]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[]
["Typology","Per typology","Cumulative total"]
[1,10000,10000]
[2,{"$f":"B25/2","v":5000},15000]
[3,{"$f":"B26/2","v":2500},17500]
[4,1240,18740]
[5,640,19380]
[6,320,19700]
[7,160,19860]
[8,80,19940]
[9,40,19980]
[10,20,20000]