Suoritettu

Apache OpenOffice 4.1.0 Spreadsheet Sort

Good day,

I have an automatically created spreadsheet (from separate software) that is generated weekly. I require the ability to re-sort based on certain text contained in Column-C and carry forward related info in Columns A and B. I'm hoping this can be done automatically with a custom sort command or?

See spreadsheet [login to view URL]

- Sheet "EWP" shows raw data

- Sheet "Sorted EWP" is how I would like to see the result of sorted data from "EWP"

Sort Criteria:

1. Data is sorted from text within Column-C (note: the text only has to be present and does not have to match exactly)

- Text grouped by name: Similar common text within Column-C

NJH10, NJM10, NJH12, NJM12, NJH14, NJM14, NJH16, NJM16, NJM18

1 3/4" x 9-1/2", 1 3/4" x 11 7/8", 1 3/4" x 14", etc

3 1/2" x 9-1/2", 3 1/2" x 11 7/8", 3 1/2" x 14", etc

Glulam, Columns, etc

2. Give me the lability to add additional sort names

3. Secondary sort condition is by length Column-B

4. All data not sorted shows at bottom of sheet.

5. Sum of Columns AxB provided and Sum of each Name (see columns I and J)

6. Original columns I through Q not required

Thanks

Taidot: Excel, Tietojenkäsittely, C++ -ohjelmointi, C-ohjelmointi, Tietojärjestelmäarkkitehtuuri

Näytä lisää: 127.0 0.1 apache 2.4 17 win32 openssl 1.0 2d php 5.5 30, build php did_dest 84768&r1 1&r2 2&r3 3&r4 4&hour 0&repeat 3&gid 17&t 0&option 256, build php did_dest 84768&r1 1&r2 2&r3 3&r4 4&hour 0&repeat 3&gid 17&t 0&option 256did_dest, 0,1,0,2,2,2,3,4,5,6,6, ppm data entry setup 1.0 4, .net core 1.0 4, celery 4.1 0 documentation, apache hbase 1.0 api, silverstripe 4.1 0, openoffice 4.0 1, apache james server 3.1 0, wilcity 1.0 4.1 directory listing wordpress theme, glassfish server 4.1.0 download, npm err! sqlite3@4.1.0 install: `node-pre-gyp install --fallback-to-build`, sqlite3@4.1.0 install: `node-pre-gyp install --fallback-to-build`, failed at the sqlite3@4.1.0 install script, solve the following by using bitonic sort algorithm 2 6 3 7 5 1 0 4, open office 4.1 0 free download, openoffice 4.1 3 user guide pdf, woocommerce 4.1.0 download

Tietoa työnantajasta:
( 6 arvostelua ) Canada

Projektin tunnus: #30561258

Myönnetty käyttäjälle:

reubengi

Hi There, I understand the criteria for sorting and summing the lengths of material in your list. I can create a tool that will do this work for you and I have done similar projects. regards Reuben

$120 USD 7 päivässä
(20 Arvostelua)
5.0

4 freelanceria on tarjonnut keskimäärin $130 tähän työhön

(308 arvostelua)
7.3
yvonnefrancis200

MASTERS SOFTWARE ARCHITECTURE DATA PROCESSING EXPERT HELLO, I have read the instructions keenly and understood your specifications for the task. I have over 7 years’ experience in this field and have adverse experie Lisää

$150 USD 4 päivässä
(3 arvostelua)
2.8
Davics

Hello, I would love to assist you. I have the required experience for this project and would love to work on it. Thank you for your consideration. ;)

$100 USD 7 päivässä
(0 arvostelua)
0.0