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

{"sheet":"Calculator","index":0,"n_rows":27,"n_cols":14,"rows_kept":27,"cut":false,"hidden":false,"merged":[]}
[null,"Fee Calculator forGC/CM  July 1 2025 Fee Guidline",null,null,null,null,null,null,"Lump Sum Fee Break Down"]
[]
[]
[null,null,null,"<===MACC",null,null,null,null,null,"Proposal","Phase %"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L11:L16)","v":1}]
[null,null,null,"<== Fee Schedule"]
[]
[null,null,null,"<== Remodel %"]
[null,null,null,null,null,null,null,null,null,null,null,"Phase","Fee"]
[null,null,{"$f":"IF(C6=\"A\",Schedule_A,(IF(C6=\"B\",Schedule_B, (IF(C6=\"C\",Schedule_C, \" \")))))","v":" "},"A/E Fee %",null,null,null,null,"Pick Phases","Phase","Lump Sum","%","%"]
[null,null,null,null,null,null,null,null,"Y","SD",{"$f":"J5/K5","v":0},{"$f":"IF(I11=\"Y\",18%,0)","v":0.18},{"$f":"K11*L11","v":0},{"$f":"M11","v":0}]
[null,null,{"$f":"SUM(C8:C10)","v":0},"Total A/E Fee %",null,null,null,null,"Y","DD",{"$f":"J5/K5","v":0},{"$f":"IF(I12=\"Y\",20%,0)","v":0.2},0,0]
[null,null,null,null,null,null,null,null,"Y","CD",{"$f":"J5/K5","v":0},{"$f":"IF(I13=\"Y\",31%,0)","v":0.31},0,0]
[null,null,null,null,null,null,null,null,"Y","BID",{"$f":"J5/K5","v":0},{"$f":"IF(I14=\"Y\",2%,0)","v":0.02},0,0]
[null,null,{"$f":"IFERROR((MACC*(ROUND($C$12,4))*D15), \" \")","v":0},0.18,"SD",null,{"$f":"C15","v":0},null,"Y","CON",{"$f":"J5/K5","v":0},{"$f":"IF(I15=\"Y\",27%,0)","v":0.27},0,0]
[null,null,0,0.2,"DD",null,0,null,"Y","CPL",{"$f":"J5/K5","v":0},{"$f":"IF(I16=\"Y\",2%,0)","v":0.02},0,0]
[null,null,0,0.31,"CD",null,0,null,null,null,null,"Total",{"$f":"SUM(M11:M16)","v":0},{"$f":"M17","v":0}]
[null,null,0,0.02,"Bid",null,0]
[null,null,0,0.27,"CA",null,0]
[null,null,0,0.02,"Close",null,0]
[]
[null,null,{"$f":"SUM(C15:C20)","v":0},"Total Fee",null,null,{"$f":"SUM(G15:G21)","v":0}]
[]
[null,null,null,null,null,null,"Completion Date Check:"]
[null,null,null,null,null,null,"Tasks:","Dates","# of Days"]
[null,null,null,null,null,null,"Enter Start Date & Number of Days ="]
[null,null,null,null,null,null,"Completion Date =",{"$f":"H26+I26","v":"00:00:00"}]

{"sheet":"Formula","index":1,"n_rows":27,"n_cols":8,"rows_kept":27,"cut":false,"hidden":true,"merged":[[4,1,4,2]]}
[]
[]
[]
[]
[null,"2025 Fee Schedule"]
[null,{"$f":"90 / (545 + (MACC / (8307/2418)) ^ 0.38)","v":0.16513761467889909},"Schedule A",null,"90 / (545 + (MACC / (8307/2418)) ^ 0.38)"]
[]
[null,{"$f":"(Schedule_A + Schedule_C) / 2","v":0.17756880733944955},"Schedule B",null,"(Schedule_A + Schedule_C) / 2"]
[]
[null,{"$f":" (9.03 / (43 + (MACC / (8307/2418))^0.25))-0.02","v":0.19},"Schedule C",null,"(9.03 / (43.0 + (MACC / (8307/2418))^0.25))-0.02"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,{"$f":"IFERROR((MACC*($C$10+$C$8)*I22), \" \")","v":" "}]
[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," "]