{"id":335,"date":"2017-01-23T19:16:07","date_gmt":"2017-01-23T19:16:07","guid":{"rendered":"http:\/\/emilioleroux.com\/?p=335"},"modified":"2017-02-05T12:14:27","modified_gmt":"2017-02-05T15:14:27","slug":"schoenberg-vs-excel","status":"publish","type":"post","link":"https:\/\/emilioleroux.com\/es\/schoenberg-vs-excel\/","title":{"rendered":"Schoenberg vs. Excel"},"content":{"rendered":"<p class=\"qtranxs-available-languages-message qtranxs-available-languages-message-es\"><i>(Este texto solo est\u00e1 disponible en <a href=\"https:\/\/emilioleroux.com\/pb\/wp-json\/wp\/v2\/posts\/335\" class=\"qtranxs-available-language-link qtranxs-available-language-link-pb\" title=\"Portugu\u00eas\">Portugu\u00eas<\/a>).<\/i>    <\/p>Terceira aula de T\u00e9cnicas de An\u00e1lise I. O professor Marcos Di Silva nos pede uma an\u00e1lise serial simples do \u00ednicio da Suite Op. 25 de Schoenberg.<br \/>\nHoje em dia h\u00e1 um n\u00famero consider\u00e1vel de ferramentas para assistir na identifica\u00e7\u00e3o de s\u00e9ries e intervalos \u2014incluindo o cl\u00e1ssico <a href=\"http:\/\/www.angelfire.com\/music2\/bahia\/pcn\/pcn2001enu.htm\">Processador de Classes de Notas (PCN)<\/a> de Jamary Oliveira \u00a0e\u00a0diversas ferramentas <em>online<\/em>.<\/p>\n<p>Mas eu aproveitei para tirar do ba\u00fa uma velha planilha que fiz no Excel em 2013. Neste <em>spreadsheet<\/em>, basta preencher os quadrados amarelos com n\u00fameros ou com notas, e as f\u00f3rmulas far\u00e3o o resto: traduzir os nomes das notas para n\u00fameros de classes (se necess\u00e1rio), e criar uma matriz serial com ambos, nomes (em cima) e n\u00fameros de classe (embaixo).\u00a0Adicionalmente, o spreadsheet trasp\u00f5e a s\u00e9rie para D\u00f3 (com rela\u00e7\u00e3o \u00e0 primeira nota) e gera a matriz nominal e num\u00e9rica para essa s\u00e9rie transposta.<\/p>\n\n        <div class=\"wp-tiles-container\">\n        \n            <div data-carousel-extra='{\"blog_id\":1,\"permalink\":\"https:\\\/\\\/emilioleroux.com\\\/es\\\/schoenberg-vs-excel\\\/\"}' id=\"wp_tiles_1\" class=\"wp-tiles-grid gallery wp-tiles-byline-align-bottom wp-tiles-byline-animated wp-tiles-byline-slide-up wp-tiles-image-animated wp-tiles-image-scale-up\">                        \n                <div class='wp-tiles-tile gallery-item' id='tile-342'>\n                \n                    <a href=\"https:\/\/i0.wp.com\/emilioleroux.com\/wp-content\/uploads\/2017\/01\/2017-01-23-12.05.49.jpg?fit=1200%2C614&ssl=1\" title=\"A s\u00e9rie\" data-attachment-id=\"342\" data-permalink=\"https:\/\/emilioleroux.com\/es\/schoenberg-vs-excel\/2017-01-23-12-05-49\/\" data-orig-file=\"https:\/\/i0.wp.com\/emilioleroux.com\/wp-content\/uploads\/2017\/01\/2017-01-23-12.05.49.jpg?fit=1200%2C614&amp;ssl=1\" data-orig-size=\"1200,614\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;2&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;Moto G (4)&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;1485173149&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;3.64&quot;,&quot;iso&quot;:&quot;100&quot;,&quot;shutter_speed&quot;:&quot;0.033333333333333&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"2017-01-23 12.05.49\" data-image-description=\"\" data-medium-file=\"https:\/\/i0.wp.com\/emilioleroux.com\/wp-content\/uploads\/2017\/01\/2017-01-23-12.05.49.jpg?fit=300%2C154&amp;ssl=1\" data-large-file=\"https:\/\/i0.wp.com\/emilioleroux.com\/wp-content\/uploads\/2017\/01\/2017-01-23-12.05.49.jpg?fit=640%2C328&amp;ssl=1\">\n                \n                        <article class='wp-tiles-tile-with-image wp-tiles-tile-wrapper' itemscope itemtype=\"http:\/\/schema.org\/CreativeWork\">\n                        \n                            <div class='wp-tiles-tile-bg'>\n\n                                <img src='https:\/\/i0.wp.com\/emilioleroux.com\/wp-content\/uploads\/2017\/01\/2017-01-23-12.05.49.jpg?fit=640%2C328&ssl=1' class='wp-tiles-img' itemprop=\"image\" \/>\n\n                            <\/div>\n                                                \n                            <div class='wp-tiles-byline'>\n\n                                <div class='wp-tiles-byline-wrapper'>\n                                                                \n                                    <div class='wp-tiles-byline-content' itemprop=\"description\">\n                                        <h4 class=\"wp-tiles-byline-title\">A s\u00e9rie<\/h4>\n                                    <\/div>\n                                \n                                <\/div>\n\n                            <\/div>\n                        \n                        <\/article>\n                \n                    <\/a>\n                \n                <\/div>\n            \n                <div class='wp-tiles-tile gallery-item' id='tile-341'>\n                \n                    <a href=\"https:\/\/i0.wp.com\/emilioleroux.com\/wp-content\/uploads\/2017\/01\/2017-01-23-12.06.12.jpg?fit=800%2C910&ssl=1\" title=\"2\" data-attachment-id=\"341\" data-permalink=\"https:\/\/emilioleroux.com\/es\/schoenberg-vs-excel\/2017-01-23-12-06-12\/\" data-orig-file=\"https:\/\/i0.wp.com\/emilioleroux.com\/wp-content\/uploads\/2017\/01\/2017-01-23-12.06.12.jpg?fit=800%2C910&amp;ssl=1\" data-orig-size=\"800,910\" data-comments-opened=\"0\" data-image-meta=\"{&quot;aperture&quot;:&quot;2&quot;,&quot;credit&quot;:&quot;&quot;,&quot;camera&quot;:&quot;Moto G (4)&quot;,&quot;caption&quot;:&quot;&quot;,&quot;created_timestamp&quot;:&quot;1485173172&quot;,&quot;copyright&quot;:&quot;&quot;,&quot;focal_length&quot;:&quot;3.64&quot;,&quot;iso&quot;:&quot;125&quot;,&quot;shutter_speed&quot;:&quot;0.033333333333333&quot;,&quot;title&quot;:&quot;&quot;,&quot;orientation&quot;:&quot;0&quot;}\" data-image-title=\"2017-01-23 12.06.12\" data-image-description=\"\" data-medium-file=\"https:\/\/i0.wp.com\/emilioleroux.com\/wp-content\/uploads\/2017\/01\/2017-01-23-12.06.12.jpg?fit=264%2C300&amp;ssl=1\" data-large-file=\"https:\/\/i0.wp.com\/emilioleroux.com\/wp-content\/uploads\/2017\/01\/2017-01-23-12.06.12.jpg?fit=640%2C728&amp;ssl=1\">\n                \n                        <article class='wp-tiles-tile-with-image wp-tiles-tile-wrapper' itemscope itemtype=\"http:\/\/schema.org\/CreativeWork\">\n                        \n                            <div class='wp-tiles-tile-bg'>\n\n                                <img src='https:\/\/i0.wp.com\/emilioleroux.com\/wp-content\/uploads\/2017\/01\/2017-01-23-12.06.12.jpg?fit=640%2C728&ssl=1' class='wp-tiles-img' itemprop=\"image\" \/>\n\n                            <\/div>\n                                                \n                            <div class='wp-tiles-byline'>\n\n                                <div class='wp-tiles-byline-wrapper'>\n                                                                \n                                    <div class='wp-tiles-byline-content' itemprop=\"description\">\n                                        <h4 class=\"wp-tiles-byline-title\">2<\/h4>\n                                    <\/div>\n                                \n                                <\/div>\n\n                            <\/div>\n                        \n                        <\/article>\n                \n                    <\/a>\n                \n                <\/div>\n            \n            <\/div>\n\n        <\/div>\n        \n<p>Eu tinha planejado implementar mais algumas funcionalidades na planilha -como, por exemplo, o c\u00e1lculo do vetor intervalar-, mas no fim das contas meu interesse pelo serialismo durou muito pouco. Na \u00e9poca, n\u00e3o analisei nada, compus apenas uma pequena miniatura e parti para outros universos, e esta planilha s\u00f3 serviu como trof\u00e9u para um desafio conquistado.\u00a0 Hoje tenho a oportunidade de revisitar a inven\u00e7\u00e3o, mesmo que brevemente, para analisar a Suite, usando as canetas virtuais do aplicativo\u00a0<a href=\"https:\/\/www.drawboard.com\/\">Drawboard PDF<\/a>.<\/p>\n<p>Identificando o uso das s\u00e9ries em Schoenberg<\/p>\n<p>A s\u00e9rie de Shoenberg, pelo menos na primeira vez que aparece, \u00e9:<\/p>\n<table style=\"height: 33px;\" width=\"378\">\n<tbody>\n<tr>\n<td style=\"width: 22.4653px;\">E<\/td>\n<td style=\"width: 23.5764px;\">F<\/td>\n<td style=\"width: 23.5764px;\">G<\/td>\n<td style=\"width: 28.0208px;\">Db<\/td>\n<td style=\"width: 28.0208px;\">Gb<\/td>\n<td style=\"width: 28.0208px;\">Eb<\/td>\n<td style=\"width: 28.0208px;\">Ab<\/td>\n<td style=\"width: 25.7986px;\">D<\/td>\n<td style=\"width: 24.6875px;\">B<\/td>\n<td style=\"width: 24.6875px;\">C<\/td>\n<td style=\"width: 25.7986px;\">A<\/td>\n<td style=\"width: 28.0208px;\">Bb<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p>A matrix serial facilita a identifica\u00e7\u00e3o de por\u00e7\u00f5es (transpostas, invertidas, retr\u00f3gradas) da s\u00e9rie de Schoenberg. A an\u00e1lise, neste caso, serve como numa esp\u00e9cie de engenharia reversa das transforma\u00e7\u00f5es, estruturas e regras no universo que o compositor criou para esta pe\u00e7a.<\/p>\n<p>Um dos problemas, ou melhor, um \u00e1rea para poss\u00edvel melhoria desta ferramenta, \u00e9 que as buscas tem que ser feitas manualmente -mais ou menos como num jogo de ca\u00e7a-palavras ou <em>sopa de letras<\/em>-. Essa busca poderia ser autom\u00e1tica: bastaria colocar uma sequencia de 2 ou mais notas ou classes e deixar que a ferramenta encontre em que lugar da matrix esse fragmento de s\u00e9rie pode ser encontrado, se \u00e9 em alguma das invers\u00f5es ou dos retr\u00f3grados da s\u00e9rie.<\/p>\n<p>Tamb\u00e9m seria relativamente f\u00e1cil transpor toda a matrix para qualquer nota, apenas preenchendo uma casa adicional da planilha. E permitir ao usu\u00e1rio escolher se deseja Sustenidos ou Bemois&#8230; Ser\u00e1 o destino desta ferramenta crescer, sair de casa e brincar com os compositores adultos? Ou\u00a0ela voltar\u00e1 para o ba\u00fa depois de cumprir o dever de casa?<\/p>\n<p>&nbsp;<\/p>\n\n        <div class=\"wp-tiles-container\">\n        \n            <div id=\"wp_tiles_2\" class=\"wp-tiles-grid wp-tiles-byline-align-bottom wp-tiles-byline-animated wp-tiles-byline-slide-up wp-tiles-image-animated wp-tiles-image-scale-up\">\n                        \n                <div class='wp-tiles-tile' id='tile-343'>\n                \n                    <a href=\"https:\/\/i1.wp.com\/emilioleroux.com\/wp-content\/uploads\/2017\/01\/2017-01-23-12.06.45.jpg?fit=942%2C630&ssl=1\" title=\"Identificando o uso das s\u00e9ries em Shoemberg\" class=\"thickbox\" rel=\"3\">\n                \n                        <article class='wp-tiles-tile-with-image wp-tiles-tile-wrapper' itemscope itemtype=\"http:\/\/schema.org\/CreativeWork\">\n                        \n                            <div class='wp-tiles-tile-bg'>\n\n                                <img src='https:\/\/i1.wp.com\/emilioleroux.com\/wp-content\/uploads\/2017\/01\/2017-01-23-12.06.45.jpg?fit=640%2C428&ssl=1' class='wp-tiles-img' itemprop=\"image\" \/>\n\n                            <\/div>\n                                                \n                            <div class='wp-tiles-byline'>\n\n                                <div class='wp-tiles-byline-wrapper'>\n                                                                \n                                    <div class='wp-tiles-byline-content' itemprop=\"description\">\n                                        <h4 class=\"wp-tiles-byline-title\">Identificando o uso das s\u00e9ries em Shoemberg<\/h4>\n                                    <\/div>\n                                \n                                <\/div>\n\n                            <\/div>\n                        \n                        <\/article>\n                \n                    <\/a>\n                \n                <\/div>\n            \n            <\/div>\n\n        <\/div>\n        \n<p>&nbsp;","protected":false},"excerpt":{"rendered":"<p>(Este texto solo est\u00e1 disponible en Portugu\u00eas). Terceira aula de T\u00e9cnicas de An\u00e1lise I. O professor Marcos Di Silva nos pede uma an\u00e1lise serial simples do \u00ednicio da Suite Op. 25 de Schoenberg. Hoje em dia h\u00e1 um n\u00famero consider\u00e1vel de ferramentas para assistir na identifica\u00e7\u00e3o de s\u00e9ries e intervalos \u2014incluindo o cl\u00e1ssico Processador de Classes de Notas (PCN) de Jamary Oliveira \u00a0e\u00a0diversas ferramentas online. Mas eu aproveitei para tirar do ba\u00fa uma velha planilha que fiz no Excel em 2013. Neste spreadsheet, basta preencher os quadrados amarelos com n\u00fameros ou com notas, e as f\u00f3rmulas far\u00e3o o resto: traduzir [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":342,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[20,19,8,60,98],"tags":[70,62,68,66,64],"class_list":["post-335","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-blog","category-frontpage","category-music","category-theory","category-timeline","tag-calculador-serial","tag-music-theory","tag-musica","tag-serialismo","tag-teoria-musical"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.7 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Schoenberg vs. Excel - Emilio Le Roux<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/emilioleroux.com\/schoenberg-vs-excel\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Schoenberg vs. Excel - Emilio Le Roux\" \/>\n<meta property=\"og:description\" content=\"(Este texto solo est\u00e1 disponible en Portugu\u00eas). Terceira aula de T\u00e9cnicas de An\u00e1lise I. O professor Marcos Di Silva nos pede uma an\u00e1lise serial simples do \u00ednicio da Suite Op. 25 de Schoenberg. Hoje em dia h\u00e1 um n\u00famero consider\u00e1vel de ferramentas para assistir na identifica\u00e7\u00e3o de s\u00e9ries e intervalos \u2014incluindo o cl\u00e1ssico Processador de Classes de Notas (PCN) de Jamary Oliveira \u00a0e\u00a0diversas ferramentas online. Mas eu aproveitei para tirar do ba\u00fa uma velha planilha que fiz no Excel em 2013. Neste spreadsheet, basta preencher os quadrados amarelos com n\u00fameros ou com notas, e as f\u00f3rmulas far\u00e3o o resto: traduzir [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/emilioleroux.com\/schoenberg-vs-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Emilio Le Roux\" \/>\n<meta property=\"article:author\" content=\"facebook.com\/emilio.leroux\" \/>\n<meta property=\"article:published_time\" content=\"2017-01-23T19:16:07+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2017-02-05T15:14:27+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/emilioleroux.com\/wp-content\/uploads\/2017\/01\/2017-01-23-12.05.49.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"614\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Emilio Le Roux\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Emilio Le Roux\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/emilioleroux.com\/schoenberg-vs-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/emilioleroux.com\/schoenberg-vs-excel\/\"},\"author\":{\"name\":\"Emilio Le Roux\",\"@id\":\"https:\/\/emilioleroux.com\/#\/schema\/person\/8eb1c41b40ad0d32a7797b0fd4731c92\"},\"headline\":\"Schoenberg vs. Excel\",\"datePublished\":\"2017-01-23T19:16:07+00:00\",\"dateModified\":\"2017-02-05T15:14:27+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/emilioleroux.com\/schoenberg-vs-excel\/\"},\"wordCount\":490,\"image\":{\"@id\":\"https:\/\/emilioleroux.com\/schoenberg-vs-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/i0.wp.com\/emilioleroux.com\/wp-content\/uploads\/2017\/01\/2017-01-23-12.05.49.jpg?fit=1200%2C614&ssl=1\",\"keywords\":[\"calculador serial\",\"Music Theory\",\"m\u00fasica\",\"serialismo\",\"Teoria Musical\"],\"articleSection\":[\"Blog\",\"Frontpage\",\"M\u00fasica\",\"Theory\",\"Timeline\"],\"inLanguage\":\"es-PE\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/emilioleroux.com\/schoenberg-vs-excel\/\",\"url\":\"https:\/\/emilioleroux.com\/schoenberg-vs-excel\/\",\"name\":\"Schoenberg vs. Excel - Emilio Le Roux\",\"isPartOf\":{\"@id\":\"https:\/\/emilioleroux.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/emilioleroux.com\/schoenberg-vs-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/emilioleroux.com\/schoenberg-vs-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/i0.wp.com\/emilioleroux.com\/wp-content\/uploads\/2017\/01\/2017-01-23-12.05.49.jpg?fit=1200%2C614&ssl=1\",\"datePublished\":\"2017-01-23T19:16:07+00:00\",\"dateModified\":\"2017-02-05T15:14:27+00:00\",\"author\":{\"@id\":\"https:\/\/emilioleroux.com\/#\/schema\/person\/8eb1c41b40ad0d32a7797b0fd4731c92\"},\"breadcrumb\":{\"@id\":\"https:\/\/emilioleroux.com\/schoenberg-vs-excel\/#breadcrumb\"},\"inLanguage\":\"es-PE\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/emilioleroux.com\/schoenberg-vs-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es-PE\",\"@id\":\"https:\/\/emilioleroux.com\/schoenberg-vs-excel\/#primaryimage\",\"url\":\"https:\/\/i0.wp.com\/emilioleroux.com\/wp-content\/uploads\/2017\/01\/2017-01-23-12.05.49.jpg?fit=1200%2C614&ssl=1\",\"contentUrl\":\"https:\/\/i0.wp.com\/emilioleroux.com\/wp-content\/uploads\/2017\/01\/2017-01-23-12.05.49.jpg?fit=1200%2C614&ssl=1\",\"width\":1200,\"height\":614,\"caption\":\"A s\u00e9rie\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/emilioleroux.com\/schoenberg-vs-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"In\u00edcio\",\"item\":\"https:\/\/emilioleroux.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Schoenberg vs. Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/emilioleroux.com\/#website\",\"url\":\"https:\/\/emilioleroux.com\/\",\"name\":\"Emilio Le Roux\",\"description\":\"Film &amp; Music &amp; Shit\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/emilioleroux.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es-PE\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/emilioleroux.com\/#\/schema\/person\/8eb1c41b40ad0d32a7797b0fd4731c92\",\"name\":\"Emilio Le Roux\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es-PE\",\"@id\":\"https:\/\/emilioleroux.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/1d6e7a0c33b8868c640168bbf8da7aae404f6d7d5806e3c29de3a5c71ec016fb?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/1d6e7a0c33b8868c640168bbf8da7aae404f6d7d5806e3c29de3a5c71ec016fb?s=96&d=mm&r=g\",\"caption\":\"Emilio Le Roux\"},\"sameAs\":[\"https:\/\/emilioleroux.com\",\"facebook.com\/emilio.leroux\"],\"url\":\"https:\/\/emilioleroux.com\/es\/author\/elerouxx\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Schoenberg vs. Excel - Emilio Le Roux","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/emilioleroux.com\/schoenberg-vs-excel\/","og_locale":"es_ES","og_type":"article","og_title":"Schoenberg vs. Excel - Emilio Le Roux","og_description":"(Este texto solo est\u00e1 disponible en Portugu\u00eas). Terceira aula de T\u00e9cnicas de An\u00e1lise I. O professor Marcos Di Silva nos pede uma an\u00e1lise serial simples do \u00ednicio da Suite Op. 25 de Schoenberg. Hoje em dia h\u00e1 um n\u00famero consider\u00e1vel de ferramentas para assistir na identifica\u00e7\u00e3o de s\u00e9ries e intervalos \u2014incluindo o cl\u00e1ssico Processador de Classes de Notas (PCN) de Jamary Oliveira \u00a0e\u00a0diversas ferramentas online. Mas eu aproveitei para tirar do ba\u00fa uma velha planilha que fiz no Excel em 2013. Neste spreadsheet, basta preencher os quadrados amarelos com n\u00fameros ou com notas, e as f\u00f3rmulas far\u00e3o o resto: traduzir [&hellip;]","og_url":"https:\/\/emilioleroux.com\/schoenberg-vs-excel\/","og_site_name":"Emilio Le Roux","article_author":"facebook.com\/emilio.leroux","article_published_time":"2017-01-23T19:16:07+00:00","article_modified_time":"2017-02-05T15:14:27+00:00","og_image":[{"width":1200,"height":614,"url":"https:\/\/emilioleroux.com\/wp-content\/uploads\/2017\/01\/2017-01-23-12.05.49.jpg","type":"image\/jpeg"}],"author":"Emilio Le Roux","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Emilio Le Roux","Est. reading time":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/emilioleroux.com\/schoenberg-vs-excel\/#article","isPartOf":{"@id":"https:\/\/emilioleroux.com\/schoenberg-vs-excel\/"},"author":{"name":"Emilio Le Roux","@id":"https:\/\/emilioleroux.com\/#\/schema\/person\/8eb1c41b40ad0d32a7797b0fd4731c92"},"headline":"Schoenberg vs. Excel","datePublished":"2017-01-23T19:16:07+00:00","dateModified":"2017-02-05T15:14:27+00:00","mainEntityOfPage":{"@id":"https:\/\/emilioleroux.com\/schoenberg-vs-excel\/"},"wordCount":490,"image":{"@id":"https:\/\/emilioleroux.com\/schoenberg-vs-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/i0.wp.com\/emilioleroux.com\/wp-content\/uploads\/2017\/01\/2017-01-23-12.05.49.jpg?fit=1200%2C614&ssl=1","keywords":["calculador serial","Music Theory","m\u00fasica","serialismo","Teoria Musical"],"articleSection":["Blog","Frontpage","M\u00fasica","Theory","Timeline"],"inLanguage":"es-PE"},{"@type":"WebPage","@id":"https:\/\/emilioleroux.com\/schoenberg-vs-excel\/","url":"https:\/\/emilioleroux.com\/schoenberg-vs-excel\/","name":"Schoenberg vs. Excel - Emilio Le Roux","isPartOf":{"@id":"https:\/\/emilioleroux.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/emilioleroux.com\/schoenberg-vs-excel\/#primaryimage"},"image":{"@id":"https:\/\/emilioleroux.com\/schoenberg-vs-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/i0.wp.com\/emilioleroux.com\/wp-content\/uploads\/2017\/01\/2017-01-23-12.05.49.jpg?fit=1200%2C614&ssl=1","datePublished":"2017-01-23T19:16:07+00:00","dateModified":"2017-02-05T15:14:27+00:00","author":{"@id":"https:\/\/emilioleroux.com\/#\/schema\/person\/8eb1c41b40ad0d32a7797b0fd4731c92"},"breadcrumb":{"@id":"https:\/\/emilioleroux.com\/schoenberg-vs-excel\/#breadcrumb"},"inLanguage":"es-PE","potentialAction":[{"@type":"ReadAction","target":["https:\/\/emilioleroux.com\/schoenberg-vs-excel\/"]}]},{"@type":"ImageObject","inLanguage":"es-PE","@id":"https:\/\/emilioleroux.com\/schoenberg-vs-excel\/#primaryimage","url":"https:\/\/i0.wp.com\/emilioleroux.com\/wp-content\/uploads\/2017\/01\/2017-01-23-12.05.49.jpg?fit=1200%2C614&ssl=1","contentUrl":"https:\/\/i0.wp.com\/emilioleroux.com\/wp-content\/uploads\/2017\/01\/2017-01-23-12.05.49.jpg?fit=1200%2C614&ssl=1","width":1200,"height":614,"caption":"A s\u00e9rie"},{"@type":"BreadcrumbList","@id":"https:\/\/emilioleroux.com\/schoenberg-vs-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"In\u00edcio","item":"https:\/\/emilioleroux.com\/"},{"@type":"ListItem","position":2,"name":"Schoenberg vs. Excel"}]},{"@type":"WebSite","@id":"https:\/\/emilioleroux.com\/#website","url":"https:\/\/emilioleroux.com\/","name":"Emilio Le Roux","description":"Film &amp; Music &amp; Shit","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/emilioleroux.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es-PE"},{"@type":"Person","@id":"https:\/\/emilioleroux.com\/#\/schema\/person\/8eb1c41b40ad0d32a7797b0fd4731c92","name":"Emilio Le Roux","image":{"@type":"ImageObject","inLanguage":"es-PE","@id":"https:\/\/emilioleroux.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/1d6e7a0c33b8868c640168bbf8da7aae404f6d7d5806e3c29de3a5c71ec016fb?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/1d6e7a0c33b8868c640168bbf8da7aae404f6d7d5806e3c29de3a5c71ec016fb?s=96&d=mm&r=g","caption":"Emilio Le Roux"},"sameAs":["https:\/\/emilioleroux.com","facebook.com\/emilio.leroux"],"url":"https:\/\/emilioleroux.com\/es\/author\/elerouxx\/"}]}},"_links":{"self":[{"href":"https:\/\/emilioleroux.com\/es\/wp-json\/wp\/v2\/posts\/335","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/emilioleroux.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/emilioleroux.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/emilioleroux.com\/es\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/emilioleroux.com\/es\/wp-json\/wp\/v2\/comments?post=335"}],"version-history":[{"count":33,"href":"https:\/\/emilioleroux.com\/es\/wp-json\/wp\/v2\/posts\/335\/revisions"}],"predecessor-version":[{"id":565,"href":"https:\/\/emilioleroux.com\/es\/wp-json\/wp\/v2\/posts\/335\/revisions\/565"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/emilioleroux.com\/es\/wp-json\/wp\/v2\/media\/342"}],"wp:attachment":[{"href":"https:\/\/emilioleroux.com\/es\/wp-json\/wp\/v2\/media?parent=335"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/emilioleroux.com\/es\/wp-json\/wp\/v2\/categories?post=335"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/emilioleroux.com\/es\/wp-json\/wp\/v2\/tags?post=335"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}