Help with Excel tables (Google tables)
1) Simply two tables (R1 and R2 in the file), creating two new ones.A: connect the column "A" to the line "A1" by attaching the number from the column "A" through a point to the line "A1".And in the new tables, opposite one "united" number to indicate the number that corresponds to it in the first table when crossing.For example, in the table R1, from the column "A" we take the number 15, from the line "A1" we take the number 3, so in the new table we get the number 15.3. In the second column, we put the number 0.4662 next to it, which is the number that stands between the column "A" and the line "A1".So you need to convert (simply) both tables (creating two new in the same file) for the purpose of the second task.
A formula is needed to solve the task:
The “Rest” table.In columns R1 or R2, the number value corresponding to one of the number values in the first column of the (new) tables R1 or R2 respectively, in the neighboring cell "R/l" the corresponding number value from the second column of the new table R1 or R2 respectively shall appear.For example: if I enter the number 30.8 in the column "R1", then next to the column "R/l" the number 1.4270 should appear (from the second column of the new table R1).Or, if I enter the number 47.3 in the column "R2", then next to the column "R/l" the number should appear 2.874 (from the second column of the new table R2).File by link: https://docs.google.com/spreadsheets/d/1XPvH29EnCKIw6visFo7k32MXOlKlSfyECowj1QweEno/edit?usp=sharing
-
1 day6 USD
1087 55 0 1 day6 USD
Good evening .
Task 1 on the first task tested and prepared two types of tables of excavated excels:
1. in two columns 0.0...198.9 / 0.0000...16.609
2. in 20 columns accordingly at the values of 0.0-0.0000... 0.9-0.0081
I don’t understand the required format.
The task 2. But on the task of two based on my new table in two columns I prepared in the Google tables on the "Rest" list a formula that pulls the required values from the lists R1 and R2.
I’m ready to show everything, tell you, and if you’re going to give a result. Please call me
-
1 day11 USD
5894 345 0 1 day11 USD
The task was analyzed, I can do both the first and the second using the Google Apps Script macros. I clearly describe the algorithm. I realize in the form of a set of functions, of which the main will be two: one for the conversion of the tables P1 and P2 (will be called from the list of macros), and the second for the application directly in the cells of the column "R/L" of the "Rest" (will be called as a normal built-in function, the result of which depends on the content of the cells in the columns P1 and P2). I do in a couple of hours.
-
3 days11 USD
345 22 0 3 days11 USD
Hello to you. Ready to perform the task. I will be happy to cooperate. turn to
-
1 day9 USD
119 1 0 1 day9 USD
Good day ! I'm ready to do it, the task is clear, I'll do it in a few hours.
Current freelance projects in the category Data Processing
Assistance with personal social media, networking, and projects for a monthFor activities in the field of science and scientific publications, I am looking for an assistant to perform basic organizational and operational tasks for a month as an executive assistant. Tasks include, but are not limited to: - working with AI at a deep level with documents… Data Processing, Customer Support ∙ 1 hour 5 minutes back ∙ 6 proposals |
Translate the file and tracker in NotionTranslate/create an identical tracker in Notion into Ukrainian. Intro slide (translate only what is in the screenshot) https://freyadesigns.notion.site/Deep-Work-OS-Template-2cae6bb55a4e809aaed2c97548e64828 Tracker - translate everything (except the footer)… Data Processing ∙ 2 hours 19 minutes back ∙ 5 proposals |
Macro for sorting a table in Excel
56 USD
There is a table with data, which has a column - Client and other columns. The macro for the client column activates the filter, selects the first value from the list - "Client1". It copies the filtered data, creates a new Excel file in the specified folder, names it Client1,… Data Processing ∙ 20 hours 35 minutes back ∙ 25 proposals |
Setting up and updating dashboards in Looker StudioWe have several dashboards created in Looker Studio that pull data from main Google Sheets.Last year, we regularly maintained and updated these sheets; however, the process was later halted, and the specialist who was managing the system no longer works with us. Currently, some… Data Processing ∙ 22 hours 30 minutes back ∙ 10 proposals |
Database of hotel owners Ukraine
67 USD
Could you please let me know if you can match a database or find hotel owners in Ukraine for lookalike audiences? Perhaps someone has it and what is the price? Thank you Data Processing, Information Gathering ∙ 7 days 1 hour back ∙ 20 proposals |
Kyiv