{"id":70,"date":"2016-02-08T08:07:00","date_gmt":"2016-02-08T13:07:00","guid":{"rendered":"https:\/\/serviciales.com\/?p=70"},"modified":"2025-03-05T10:52:35","modified_gmt":"2025-03-05T15:52:35","slug":"hojas-de-calculo-google-apps-tablas-dinamicas","status":"publish","type":"post","link":"https:\/\/serviciales.com\/?p=70","title":{"rendered":"HOJAS DE CALCULO &#8211; GOOGLE APPS &#8211; TABLAS DINAMICAS"},"content":{"rendered":"<h2><b><span style=\"font-family: &quot;arial&quot; , sans-serif; font-size: 12pt; line-height: 115%;\">HOJAS DE CALCULO &#8211; GOOGLE APPS &#8211; TABLAS DINAMICAS<\/span><\/b><\/h2>\n<div><b><span style=\"font-family: &quot;arial&quot; , sans-serif; font-size: 12pt; line-height: 115%;\"><br \/>\n<\/span><\/b><\/div>\n<div><span style=\"font-family: &quot;arial&quot; , sans-serif; font-size: 12pt; line-height: 115%;\">Para crear una tabla din\u00e1mica seleccione los campos &nbsp;a los cuales quiere aplicar la tabla, luego haga clic en&nbsp; <b>dato<\/b>s =&gt;&nbsp; <b>Informe de tabla din\u00e1mica<\/b>.<o:p><\/o:p><\/span><\/div>\n<div><span style=\"font-family: &quot;arial&quot; , sans-serif; font-size: 12pt; line-height: 115%;\"><br \/>\n<\/span><\/div>\n<div style=\"clear: both; text-align: center;\"><a href=\"https:\/\/www.serviciales.com\/wp-content\/uploads\/2016\/02\/1-1.png\" style=\"margin-left: 1em; margin-right: 1em;\"><img loading=\"lazy\" decoding=\"async\" border=\"0\" height=\"180\" src=\"https:\/\/www.serviciales.com\/wp-content\/uploads\/2016\/02\/1-1-300x169.png\" width=\"320\"><\/a><\/div>\n<div><span style=\"font-family: &quot;arial&quot; , sans-serif; font-size: 12pt; line-height: 115%;\"><br \/>\n<\/span><\/div>\n<div><\/div>\n<div><span style=\"font-family: &quot;arial&quot; , sans-serif; font-size: 12pt; line-height: 115%;\"><!--[if gte vml 1]><v:shapetype coordsize=\"21600,21600\"  o:spt=\"75\" o:preferrelative=\"t\" path=\"m@4@5l@4@11@9@11@9@5xe\" filled=\"f\"  stroked=\"f\"> <v:stroke joinstyle=\"miter\"\/> <v:formulas>  <v:f eqn=\"if lineDrawn pixelLineWidth 0\"\/>  <v:f eqn=\"sum @0 1 0\"\/>  <v:f eqn=\"sum 0 0 @1\"\/>  <v:f eqn=\"prod @2 1 2\"\/>  <v:f eqn=\"prod @3 21600 pixelWidth\"\/>  <v:f eqn=\"prod @3 21600 pixelHeight\"\/>  <v:f eqn=\"sum @0 0 1\"\/>  <v:f eqn=\"prod @6 1 2\"\/>  <v:f eqn=\"prod @7 21600 pixelWidth\"\/>  <v:f eqn=\"sum @8 21600 0\"\/>  <v:f eqn=\"prod @7 21600 pixelHeight\"\/>  <v:f eqn=\"sum @10 21600 0\"\/> <\/v:formulas> <v:path o:extrusionok=\"f\" gradientshapeok=\"t\" o:connecttype=\"rect\"\/> <o:lock v:ext=\"edit\" aspectratio=\"t\"\/><\/v:shapetype><v:shape id=\"Imagen_x0020_55\" o:sp type=\"#_x0000_t75\"  style='width:259.5pt;height:148.5pt;visibility:visible;mso-wrap-style:square'> <v:imagedata src=\"file:\/\/\/C:UserssistemasAppDataLocalTempmsohtmlclip1\ufffd1clip_image001.png\"   o:title=\"\" croptop=\"4669f\" cropbottom=\"25733f\" cropleft=\"15890f\" cropright=\"11150f\"\/><\/v:shape><![endif]--><!--[if !vml]--><!--[endif]--><o:p><\/o:p><\/span><\/div>\n<div><span style=\"font-family: &quot;arial&quot; , sans-serif; font-size: 12.0pt; line-height: 115%;\">En la parte superior derecha de su pantalla le aparecer\u00e1 una ventana en la cual debe Seleccionar los campos que desea agregar a la tabla ya sea por columna o filas. <o:p><\/o:p><\/span><\/div>\n<div><\/div>\n<div style=\"clear: both; text-align: center;\"><a href=\"https:\/\/www.serviciales.com\/wp-content\/uploads\/2016\/02\/2-1.png\" style=\"margin-left: 1em; margin-right: 1em;\"><img loading=\"lazy\" decoding=\"async\" border=\"0\" height=\"102\" src=\"https:\/\/www.serviciales.com\/wp-content\/uploads\/2016\/02\/2-1-300x96.png\" width=\"320\"><\/a><\/div>\n<div><\/div>\n<div><span style=\"font-family: &quot;arial&quot; , sans-serif; font-size: 12.0pt; line-height: 115%;\">Cada campo (fila o Columna) que usted seleccione se ver\u00e1 reflejado en la tabla din\u00e1mica con el valor correspondiente al momento.<o:p><\/o:p><\/span><\/div>\n<div><span style=\"font-family: &quot;arial&quot; , sans-serif; font-size: 12.0pt; line-height: 115%;\"><br \/>\n<\/span><\/div>\n<div style=\"clear: both; text-align: center;\"><a href=\"https:\/\/www.serviciales.com\/wp-content\/uploads\/2016\/02\/3.png\" style=\"margin-left: 1em; margin-right: 1em;\"><img loading=\"lazy\" decoding=\"async\" border=\"0\" height=\"96\" src=\"https:\/\/www.serviciales.com\/wp-content\/uploads\/2016\/02\/3-300x90.png\" width=\"320\"><\/a><\/div>\n<div><span style=\"font-family: &quot;arial&quot; , sans-serif; font-size: 12.0pt; line-height: 115%;\"><br \/>\n<\/span><\/div>\n<div><\/div>\n<div><span style=\"font-family: &quot;arial&quot; , sans-serif; font-size: 12.0pt; line-height: 115%;\"><!--[if gte vml 1]><v:shape  id=\"Imagen_x0020_61\" o:sp type=\"#_x0000_t75\" style='width:352.5pt;  height:103.5pt;visibility:visible;mso-wrap-style:square'> <v:imagedata src=\"file:\/\/\/C:UserssistemasAppDataLocalTempmsohtmlclip1\ufffd1clip_image005.png\"   o:title=\"\" croptop=\"4878f\" cropbottom=\"41936f\" cropright=\"25796f\"\/><\/v:shape><![endif]--><!--[if !vml]--><!--[endif]--><\/span><span style=\"font-family: &quot;arial&quot; , sans-serif; font-size: 12.0pt; line-height: 115%;\"><o:p><\/o:p><\/span><\/div>\n<div><span style=\"font-family: &quot;arial&quot; , sans-serif; font-size: 12.0pt; line-height: 115%;\">Note que al seleccionar campos, los datos&nbsp; almacenados (en el archivo de origen) se muestran en la tabla din\u00e1mica, si se hace alguna modificaci\u00f3n al archivo de origen, los cambios&nbsp; se ver\u00e1n reflejados en&nbsp; la nueva tabla.<o:p><\/o:p><\/span><\/div>\n<div><\/div>\n","protected":false},"excerpt":{"rendered":"<p>HOJAS DE CALCULO &#8211; GOOGLE APPS &#8211; TABLAS DINAMICAS Para crear una tabla din\u00e1mica seleccione los campos &nbsp;a los cuales quiere aplicar la tabla, luego haga clic en&nbsp; datos =&gt;&nbsp; Informe de tabla din\u00e1mica. En la parte superior derecha de su pantalla le aparecer\u00e1 una ventana en la cual debe Seleccionar los campos que desea [&hellip;]<\/p>\n","protected":false},"author":3,"featured_media":100,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-70","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-sin-categoria"],"_links":{"self":[{"href":"https:\/\/serviciales.com\/index.php?rest_route=\/wp\/v2\/posts\/70","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/serviciales.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/serviciales.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/serviciales.com\/index.php?rest_route=\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/serviciales.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=70"}],"version-history":[{"count":1,"href":"https:\/\/serviciales.com\/index.php?rest_route=\/wp\/v2\/posts\/70\/revisions"}],"predecessor-version":[{"id":257,"href":"https:\/\/serviciales.com\/index.php?rest_route=\/wp\/v2\/posts\/70\/revisions\/257"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/serviciales.com\/index.php?rest_route=\/"}],"wp:attachment":[{"href":"https:\/\/serviciales.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=70"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/serviciales.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=70"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/serviciales.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=70"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}