Tamamlanmış

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

Beceriler: Excel, Veri İşleme, C++ Programlama, C Programlama, Yazılım Mimarisi

Daha fazlasını gör: 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

İşveren Hakkında:
( 6 değerlendirme ) Canada

Proje NO: #30561258

Seçilen:

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

%selectedBids___i_period_sub_7% gün içinde 120%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(20 Değerlendirme)
5.0

Bu iş için 4 freelancer ortalamada $130 teklif veriyor

(308 Değerlendirme)
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 Daha Fazla

$150 USD in 4 gün içinde
(3 Değerlendirme)
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 in 7 gün içinde
(0 Değerlendirme)
0.0