Tip Proyecto de Usuario: Pila mesas para simular una hoja de Excel

Here are the tables in Spanish. Vegetables to avoid the xxx in my previous post 😉.

Aquí están las tablas en español. Verduras para evitar el xxx en mi anterior post 😉.

Insertar una fila (relleno verde para ilustrar)

Por favor, corrija mi pobre español.

Saludos,

Ian.

Hi ÇÇÇ,

Delete the images from my original post.

Take Screen Shots of these Screen Shots and insert in the User Tip in this order.

Hola ÇÇÇ,

Eliminar las imágenes de mi post original.

Tomar capturas de pantalla de estas capturas de pantalla e insertar en el Consejo para usuarios en este orden.

Screen Shot 1

Captura de pantalla 1

Screen Shot 2

Captura de pantalla 2

Screen Shot 3

Captura de pantalla 3

Screen Shot 4

Captura de pantalla 4

Thanks for your help!

Regards,

Ian.

¡Gracias por tu ayuda!

Saludos,

Ian.

Hi ÇÇÇ,

Please edit:

Ahora añadir otra fila a la 'existencia de Proveedor A' mesa (***, resaltado en verde para mayor claridad). Las tablas a continuación cortésmente se mueven hacia abajo para dar paso a la nueva fila. Los totales se ajustan automáticamente.

My original post had "KayKayKay". That was edited by the forum software. It was replaced with xxx. Perhaps "KayKayKay" is rude in Spanish 😕.

The new table shows Patatas instead of "KayKayKay" in the green row.

Many thanks for your help.

Ian.

Hola CCC,

Por favor, edite:

Ahora: Añadir otra fila a la 'existence de Proveedor A' mesa (***, resaltado en verde para alcalde claridad). Las tablas de un Continuación cortésmente se Mueven Hacia abajo para dar paso a la nueva fila. Los Totales se ajustan automaticamente.

Mi post original tenía "KayKayKay". Que fue editado por el software del foro. Fue reemplazado por xxx. Tal vez "KayKayKay" es grosero en español 😕.

La nueva tabla muestra Patatas en lugar de "KayKayKay" en la fila verde.

Muchas gracias por su ayuda.

Ian.

CCC wrote:

We need some help with...

the letter *

la letra *

KayKayKay (naughty word in Spanish) was in the English version. The Spanish forum sofware replaced it with ***. So I changed the tables from simple placeholder strings of letters to names of vegetables. Replace *** with Patatas to match the last table. No need for engineering!

KayKayKay (palabrota en español) estaba en la versión Inglés. El foro de descargas español reemplazó con ***. Así que cambié las tablas de cadenas simples de marcador de posición de las letras de los nombres de los vegetales. *** Reemplazar con Patatas para que coincida con la última mesa. No hay necesidad de la ingeniería!

Edit this: (Editar este:)

Ahora añadir otra fila a la 'existencia de Proveedor A' mesa (***, resaltado en verde para mayor claridad). Las tablas a continuación cortésmente se mueven hacia abajo para dar paso a la nueva fila. Los totales se ajustan automáticamente.

To this: (a esto:)

Ahora añadir otra fila a la 'existencia de Proveedor A' mesa (Patatas, resaltado en verde para mayor claridad). Las tablas a continuación cortésmente se mueven hacia abajo para dar paso a la nueva fila. Los totales se ajustan automáticamente.

Thanks,

Ian.

Hi ÇÇÇ,

I Thank you and Vicky for your Spanglish. Here is an edit in my Spanglish (scroll down to see what I think is the "cleaned up" version.

Withrecognition to SGIIIby providing the correct terminology of Excel and conversion of terminology Numbers.

Some users, making a transition Excel Numbers to miss some functions of Excel. like for example create range names in a spreadsheet. In fact,. Numbers can boast of the same, allowing to define range names. Indeed, this feature is most suitable in Numbers that than in Excel.

The System of Numbers is to create separate for each discrete block tables fromdata, with header rows androws of foot(page, and at times columns header) that contain formulas that they perform work. In fact, each column and each row in a table of numbers behaves as a name of range. Each column bears the name of the value as you adds add in the cell in the row for that column header. Then can use that name, or just the letter of the column, in formulas to refer to. an interval of cells of the body of that column. And each of these intervals expands dynamically. For example, a formula one (or column header)headerrow or footer is automatically set to include all the cells body when new rows or columns are add or be eliminate on a table.

To take advantage of this feature (Stet. A feature is not a function. A function is the basis of a formula), it is worth ordering your data in tables of discrete numbers. Then can be placed on the sheet so that tables are shown as a.table of great size.

In the examplethen actions vegetables they are bought byfrom several suppliers andthen resold.

Required subtotals, by the which is needed rows of standing for be able to add new rows.

A table predesigned for each vendor. Each table has a header row and.footnote.a footer row.

Another. table for the totals. Without header or footer, simply.cell fill.

Now. hide the names of tables and slide tables together so they. appear as one table. Track: Numbers > preferences > rules > alignment guides (check each box). Then, If necessary, press a key arrow on the keyboard to. finally.in align them .

Now vintage(?) another row to the. table of ' action supplier to '(Potato, highlighting in.color.green for clarity). The tables below. move down to.create a new row.Totals are automatically adjusted.

The final result is very similar to the ?appearanceofaSheet (stet. Excel has Sheets)in a document.a file Excel.?., truth?

*********************

Cleaned up:

Withrecognition to SGIIIby providing the correct terminology of.Excel and conversion of terminology Numbers.

Some users, making a transition Excel Numbers to miss some functions of Excel like for example create range names in a spreadsheet. In fact, Numbers can boast of the same, allowing to define range names. Indeed, this feature is more suitable in Numbers than in Excel.

The System of Numbers is to create separate for each discrete block tables fromdata, with header rows androws of foot(and at times columns header) that contain formulas that they perform work. In fact, each column and each row in a table of numbers behaves as a name of range. Each column bears the name of the value as you add in the cell in the row for that column header. Then can use that name, or just the letter of the column, in formulas to refer to. an interval of cells of the body of that column. And each of these intervals expands dynamically. For example, a formula one (or column header)headerrow or footer is automatically set to include all the cells body when new rows or columns are add or be eliminate on a table.

To take advantage of this feature*, it is worth ordering your data in tables of discrete numbers. Then can be placed on the sheet so that tables are shown as a.table of great size.

*[Stet. A feature is not a function. A function is the basis of a formula]

In the examplevegetables are bought from several suppliers andthen resold.

Required subtotals, by the which is needed rows of standing for be able to add new rows.

A table predesigned for each vendor. Each table has a header row and.footnote.a footer row.

Another. table for the totals. Without header or footer, simply cell fill.

Now hide the names of tables and slide tables together so they appear as one table. Track: Numbers > preferences > rules > alignment guides (check each box). Then, If necessary, press a key arrow on the keyboard to finally align them.

Now vintage(?) insert (?) another row to the. table of ' action supplier to '(Potato, highlighting in color green for clarity). The tables below move down to create a new row.Totals are automatically adjusted.

The final result is very similar to the appearanceofa Sheet* in a document Excel.

*[Stet. Excel has Sheets]

*******************

[Clarification for Numbers terminology]

This User tip refers to Header Rows and Footer Rows in Numbers Tables

It does not refer to Page Headers, Page Footers or Footnotes.

Track: Numbers > preferences > rules > alignment guides (check each box).

Numbers > Preferences > Rulers > Alignment Guides to assist with aligning the separate tables.

Perhaps the User Tip should include these clarifications 🙂.

Regards,

Ian.

P.S. Each time I look at this, I find more spurious periods (.) lurking.