{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Correção","Requisitos"],"not_rendered":{"charts":0,"images":0,"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":"Correção","index":0,"n_rows":33,"n_cols":46,"rows_kept":33,"cut":false,"hidden":false,"merged":[[1,1,1,41]]}
[]
[null,"Notas/Requisitos"]
["Integrantes","1.1","1.2","1.3","1.4","1.5","2.1","2.2","2.3","2.4","3.1","4.1","5.1","5.2","6.1","7.1","8.1","8.2","9.1","10.1","10.2","10.3","10.4","11.1","11.2","11.3","12.1","13.1","13.2","14.1",15,16,17,18,19,20,21,22,23,24,25,26,"Penalização","NOTA","Requisitos","Nota Final"]
["Gabriel Dias Ribeiro, Ivan Gomes Junqueira",3,3,2,0,2,3,3,2,2,3,3,0,2,3,3,3,0,2,0,1,0,3,3,2,5,1,0,0,0,2,0,1,0,1,4,2,0,6,0,6,0,0,{"$f":"SUM(B4:AQ4)","v":76},"ok",{"$f":"AR4","v":76}]
["Bernado Nunes, Marcelo Kriiger, Samuel Candido",3,3,2,2,2,3,3,1,2,3,3,3,2,3,3,3,2,2,0,3,0,3,1.5,1,0,1,0,3,4,2,0,0,0,0,2,2,0,6,0,6,2,0,81.5,"ok",{"$f":"AR5","v":81.5}]
["Isabella Tannús, Ivanna Bomfim, Vitor Magalhães",3,3,0,0,2,3,3,2,2,3,2,3,2,3,3,3,0,2,3,0,0,3,3,2,5,0,2,0,0,2,0,2,2,0,5,2,1,6,2,6,2,0,87,"ok",{"$f":"AR6","v":87}]
["Bruno Henrique, Eric Patrick, Gabriel Rocha",3,3,0,2,2,0,0,2,0,3,3,1,2,3,3,3,0,0,3,1,-5,3,3,2,5,0,2,3,0,2,0,0,0,0,0,0,0,6,2,6,2,-5,60,"parcial",60]
["Elisangela Rithiely",0,0,0,2,2,3,3,2,2,3,3,3,2,3,3,2,2,2,3,1,0,3,3,2,5,1,2,3,0,2,0,0,0,0,0,0,2,6,2,6,2,0,80,"ok",80]
["Gabriel dos Santos",3,3,2,2,2,3,3,2,2,3,3,3,2,3,3,3,0,0,3,1,0,0,3,2,5,1,2,0,3,2,0,0,0,0,0,0,0,6,0,6,0,0,76,"ok",{"$f":"AR9","v":76}]
["Daniel dos Santos Nery, Vinícius Ferreira",3,3,0,0,2,3,3,2,2,3,3,0,2,3,3,3,0,0,0,0,0,3,3,2,5,0,2,2,3,0,0,0,0,0,0,2,0,6,0,0,0,0,63,"ok",63]
["Anaiza do Nascimento Rocha",3,3,0,0,2,3,3,2,2,3,3,3,2,3,3,3,2,2,0,0,0,3,2,0,0,0,2,0,3,2,0,0,0,0,0,2,0,6,0,6,0,-5,{"$f":"SUM(B11:AQ11)","v":63},"parcial",63]
["Ana Gabriela Campos, Gabriel Miranda, Gabriela Fernandes",3,3,0,0,2,3,3,2,2,3,3,0,0,3,3,3,0,2,3,2,-5,3,3,0,5,0,0,0,0,0,0,0,0,0,4,2,1,6,0,0,2,0,61,"ok",61]
["João Barbosa de Souza Neto",3,3,1,2,2,3,3,2,2,3,3,3,2,3,3,3,2,2,3,0,0,3,3,2,5,0,0,3,5,2,0,0,0,0,0,2,0,6,2,6,2,0,89,"ok",89]
["Arthur Maia Souza, Ernane Benedito, Rodrigo Uehara",3,3,2,2,2,3,3,2,2,3,3,3,2,3,3,3,0,2,3,2,0,3,3,0,0,1,2,3,3,2,0,0,0,0,0,2,2,0,2,0,0,0,72,"ok",72]
["Brendha Vivas, Eric Sardela, Lucas Sousa dos Anjos",3,3,0,2,2,3,3,2,2,3,3,3,2,3,3,3,0,0,0,0,0,3,3,2,5,0,2,3,5,2,0,2,0,0,0,2,0,6,2,6,2,0,85,"ok",85]
["Lucas Dimitri Fernandes, Vinicius Faleiro Fernandes",3,3,0,0,2,3,3,2,2,3,3,3,2,3,3,3,0,2,0,0,0,0,3,2,5,0,2,0,2,0,0,0,0.5,0,0,0.5,0,6,0,0,2,null,63,"Nao",{"$f":"AR16/2","v":31.5}]
["Gabriel Queiroz Nunes",3,3,0,2,2,3,3,2,2,3,3,3,2,3,3,3,0,2,0,0,0,3,3,0,0,0,0,3,0,2,0,0,0,0,0,0,0,6,0,0,0,0,59,"ok",{"$f":"AR17","v":59}]
["Augusto de Ávila, Gabriel Felipe, Gabriel Nascimento",3,3,0,0,2,3,3,2,2,3,3,3,2,3,3,3,0,0,3,1,0,3,3,2,5,0,2,0,5,2,0,0,0,0,0,0,0,6,0,0,0,-10,60,"parcial",{"$f":"AR18","v":60}]
["Vanclerison Souza, Júlia Caroline, Guilherme Felicíssimo",3,3,2,0,2,3,3,2,2,3,3,2,2,3,3,3,2,2,3,1,0,0,3,2,5,0,2,3,5,0,0,0,2,0,3,2,1,6,0,6,0,0,87,"ok",{"$f":"AR19","v":87}]
["Eberton Chaves Dias",3,3,1,1,2,3,3,2,2,3,3,2,1,3,3,3,0,2,3,1,0,0,3,2,5,0,0,0,0,0,0,0,0,0,0,0,0,6,0,0,0,0,60,"ok",{"$f":"AR20","v":60}]
["Igor Silveira Silva, Janaína Bissani",3,3,0,0,2,3,3,2,2,3,3,3,2,3,3,3,2,0,3,0,0,3,3,2,5,0,0,0,3,0,0,0,0,0,0,0,0,6,0,6,0,-5,66,"parcial",{"$f":"AR21","v":66}]
["Victor Carrilho, Ricardo Dias, Vitor Alves",3,3,2,2,2,3,3,2,2,3,3,3,2,3,3,3,2,2,3,0,0,0,3,2,5,1,2,3,3,2,0,0,0,0,0,0,0,6,2,6,0,0,84,"ok",{"$f":"AR22","v":84}]
["Thales Atheniel Farias, Matheus Pereira",3,3,0,2,2,3,0,0,2,3,3,0,2,3,3,3,2,1,0,0,0,3,3,2,3,0,0,0,2,0,0,0,0,0,0,0,0,6,0,6,2,0,62,"ok",{"$f":"AR23","v":62}]
["Abraão Junior, Felipe Henrique, Mariana Alves",3,3,1,0,2,3,0,0,2,3,3,3,2,0,0,3,0,2,0,0,0,3,3,0,0,1,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,null,39,"Nao",{"$f":"AR24/2","v":19.5}]
["Amanda Leandro Soares",3,3,0,2,2,3,3,2,2,3,3,3,2,3,3,3,2,2,3,2,-5,3,3,2,5,1,2,3,4,0,2,0,0,2,0,0,0,6,0,6,0,0,83,"ok",{"$f":"AR25","v":83}]
["Roberto Tavares, Ademar Neto, Udro Junior",3,3,0,0,2,3,0,0,2,3,3,0,2,3,3,3,0,1,0,0,0,0,0,0,0,0,0,0,4,0,0,0,0,0,0,0,0,6,0,0,0,-5,36,"parcial",{"$f":"AR26","v":36}]
["Gustavo Diego Oliveira de Souza",3,3,0,1,2,3,0,2,2,3,3,3,2,3,3,3,0,2,3,0,-5,2,3,0,0,0,0,2,0,0,0,0,0,0,0,2,0,6,0,0,0,-10,41,"parcial",{"$f":"AR27","v":41}]
["Henrique Cunha, Marcos Pereira, Matheus Soares Duarte",3,3,0,2,2,3,3,2,2,3,3,3,2,3,3,3,2,2,3,1,0,3,3,2,5,0,2,3,0,2,0,0,2,0,0,2,2,6,2,2,2,0,86,"ok",86]
["Matheus Lopes de Souza",3,3,0,1,2,0,0,0,2,3,3,0,0,3,3,3,0,0,3,1,-5,0,3,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-10,18,"parcial",{"$f":"AR29","v":18}]
["Vinicius Clemente, Cáliton Marcos, Matheus Felipe",3,3,0,2,2,3,3,2,2,3,3,3,2,3,3,3,2,2,0,2,0,3,3,2,5,0,2,3,5,2,0,0,0,0,2,0,2,6,2,6,2,0,91,"ok",91]
["Gerson Luiz Gonçalves Dias",3,3,0,0,2,3,3,2,2,3,3,0,0,3,3,3,0,0,0,0,-5,0,3,2,3,0,2,0,3,0,0,0,2,0,0,0,0,6,0,6,0,0,55,"ok",55]
["Igor Mendonça Abe",3,3,0,0,2,3,3,2,2,3,3,3,2,3,3,3,0,1,3,1,0,3,3,2,5,0,0,0,0,0,0,2,0,0,0,0,0,6,0,0,0,0,64,"ok",{"$f":"AR32","v":64}]
["Maycon Pacheco, Tayrone Araujo, Rogério Lozano",3,3,1,2,2,3,3,2,2,3,3,3,2,3,3,3,0,2,3,0,0,3,3,2,3,1,2,0,5,0,0,2,2,0,0,2,2,6,0,0,0,0,79,"ok",{"$f":"AR33","v":79}]

{"sheet":"Requisitos","index":1,"n_rows":69,"n_cols":5,"rows_kept":69,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["Requisitos"]
[]
["#","Entidades","Pontos","Requisito do trabalho"]
[1,"Entidade Imovel",{"$f":"SUM(C5:C9)","v":12}]
["1.1","Diagrama possui a entidade Imovel",3,"a"]
["1.2","A entidade Imovel é uma entidade forte",3,"b"]
["1.3","(solução desejável) Atributo  (disponibilidade) ",2,"a,q"]
["1.4","(solução possível) Atributo multivalorado (foto)",2,"c"]
["1.5","Possui todos os atributos especificados",2,"i,j,p"]
[2,"Hierarquia de Imóvel",{"$f":"SUM(C11:C14)","v":10}]
["2.1","Possui as subclasse Terreno, Sala Comercial, Residencial (Apartamento e Casa)",3,"d"]
["2.2","Especialização Top-Down (\"d\" disjoint Total)",3,"d"]
["2.3","Possui restrição de completude total",2,"d"]
["2.4","Atributos especificados corretamente",2,"i"]
[3,"Entidade Terreno",{"$f":"SUM(C16:C16)","v":3}]
["3.1","Contém todos os atributos",3,"h"]
[4,"Entidade Sala Comercial",{"$f":"SUM(C18:C18)","v":3}]
["4.1","Contém todos os atributos",3,"g"]
[5,"Entidade Residencial (solução possível)",{"$f":"SUM(C20:C21)","v":5}]
["5.1","Possui as subclasses Apartamento e Casa (\"d\" disjoint Total)",3,"e,f"]
["5.2","Contém todos os atributos",2,"e,f"]
[6,"Entidade Casa",{"$f":"SUM(C23:C23)","v":3}]
["6.1","Contém todos os atributos",3,"e"]
[7,"Entidade Apartamento",{"$f":"SUM(C25:C25)","v":3}]
["7.1","Contém todos os atributos",3,"f"]
[8,"Entidade Funcionário",{"$f":"SUM(C27:C28)","v":5}]
["8.1","Contém todos os atributos",3,"s"]
["8.2","Atributo multivalorado telefone (contato, celular, telefone)",2,"s"]
[9,"Entidade Cargo",{"$f":"SUM(C30)","v":2}]
["9.1","Contém atributo (salario base)",2,"t"]
[10,"Entidade Transação",{"$f":"SUM(C32:C35)","v":3}]
["10.1","Contém todos os atributos",3,"u"]
["10.2","data_transação é atributo multivalorado (valor real)",2,"k"]
["10.3","(Solução não desejável) entidades Venda e Aluguel",-5,"u"]
["10.4","(Solução desejável) Forma de pagamento como Entidade",3,"u,v"]
[11,"Entidade Cliente",{"$f":"SUM(C37:C39)","v":10}]
["11.1","Contém todos os atributos",3,"m,o"]
["11.2","Hierarquia de classe com restrição",2,"l,n"]
["11.3","Possui subclasses: Cliente Proprietário e Cliente Usuário",5,"l,n"]
[12,"Entidade ou Atributo multivalorado: Fotos",{"$f":"SUM(C41)","v":1}]
["12.1","Possui todos os atributos especificados",1,"c"]
[13,"Entidade histórico (solução desejável)",{"$f":"SUM(C43:C44)","v":5}]
["13.1","Relação com entidade Imóvel",2,"w"]
["13.2","(solução possível) atributo multivalorado Fotos",3,"c,w"]
[14,"Entidade Cliente Usuário",{"$f":"SUM(C46)","v":5}]
["14.1","(Solução desejável) aluguel é atributo multivalorado (fiador, indicação)",5,"o"]
[]
[]
[]
[]
[]
[]
[]
["#","Relacionamentos","Pontos","Requisito do trabalho"]
[15,"Imóvel - Cliente Proprietario (m:n)",2,"l,q"]
[16,"Imóvel - Transação (m:n)",2,"u"]
[17,"Imóvel - Funcionario (n:1)",2,"w,u"]
[18,"Imóvel - Histórico (1:1)",2,"w"]
[19,"Cliente Usuário - Transação (m:n)",2,"u"]
[20,"(solução desejável) Transação - Funcionario : relação de venda (atributo comissão) (n:1)",5,"r,u"]
[21,"(solução desejável) Funcionário - Cargo (n:1)",2,"t"]
[22,"Transação - Forma de Pagamento (1:n)",2,"u"]
[]
["#","Soluções empregadas","Pontos","Penalização sobre descrição do trabalho"]
[23,"Hierarquia de classe",6,"Completo",0]
[24,"Agregação",2,"Incompleto",-5]
[25,"Atributos multivalorados",6,"Conteúdo raso",-10]
[26,"Atributos derivados",2,"Não feito","dividir nota por 2"]
[null,null,{"$f":"SUM(C4,C10,C15,C17,C19,C22,C24,C26,C29,C31,C36,C40,C45,C55,C65,C56,C57,C58,C59,C60,C61,C62,C66,C67,C68)","v":100}]