Kamis, 07 November 2013

]] XL-mania [[ Digest Number 2675

7 New Messages

Digest #2675

Messages

Wed Nov 6, 2013 7:21 am (PST) . Posted by:

"vacancy XL-mania"

Posting date : November 4, 2013

A plantation and processed food manufacturing company is looking for a
purchasing officer for indirect material purchasing activity.

Job title : Purchasing officer [Indirect Materials]
Position : Permanent
Location : Jakarta, Sudirman
Req. Date : November 2013
Education : Bachelor (Mechanical Engineering, Electronics,
Industrial Engineering
is preferable.
Other major will be considered based on experience)
Experience : 1 - 3 years
Age : < 30 years old
Gender : Male / Female

Job scope and responsibility

Main:

- Conduct Request For Quotation for any Purchase Request assigned.
- Process Purchase Request to Purchase Order within the standard lead
time.
- Seek for suppliers with the most suitable quality products according
to specification, competitive price, and reliable lead time.
- Negotiate price, payment terms, and other after sales service to the
suppliers.
- Coordinate goods import execution process with import team to comply
with all legal requirements
- Monitor goods arrival and suppliers follow up to achieve on time
delivery of goods
- Follow up new supplier for any documents and legal requirements.
- Regular visit and audit visit to suppliers.
- Ensure that procurement activities are performed in compliance with
Procurement Policy and Procurement Processes.
- Expedite orders and follow through to fulfillment stage; demonstrate
continuous effort to improve the efficiency and effectiveness of
operations.
- Organize, update, and maintain purchase ordering systems and
management files to ensure compliance and alignment to contracts and
improve and maintain data accuracy/transparency

Support:

- Inform Catalog / Material Master team on correct material description,
classification, and configuration.
- Support Strategic Sourcing department to do a long term tender and
development of agreement. Assist contract administration in getting
relevant information and documents from end users in a timely manner.
- Support Supplier Master team to update any changes in supplier data.

Since the candidate :

- Will be dealing with a lot of items,
- Will be developed to achieve higher level in the organization

some spreadsheet skills required:

- Functions [LookUp & Reference]: [moderate]
- Data cleanup and tabulation : [moderate]
- Pivot table and pivot chart : [moderate]
- Chart and visualization lain : [basic]

Submit your resume before November 15, 2013 to: denise.jo@ggpc.co.id,
abimono.abi@ggpc.co.id

Wed Nov 6, 2013 7:21 am (PST) . Posted by:

"Yudi Eko"

Dear Master/sesepuh XL-Mania

Saya perlu Macro Vb-Excel untuk otomasi Debit-Credit Balance buku kas
secara otomat bikin balance baru sepeti contoh terlampir

Thanks para master excel

Yudi

Wed Nov 6, 2013 5:59 pm (PST) . Posted by:

"hendrik karnadi" hendrikkarnadi

Coba copas Macro ini di VBE Sheet1,
Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Column = 4 Or Target.Column = 5 Then
        If Target.Row >= 3 Then
            If Cells(Target.Row, 4) <> "" Or Cells(Target.Row, 5) <> "" Then
                Cells(Target.Row, 6).FormulaR1C1 = "=R[-1]C+RC[-2]-RC[-1]"
            Else
                Cells(Target.Row, 6).Value = vbNullString
            End If
        End If
    End If
End Sub

Salam,
HK

On Wednesday, 6 November 2013, 22:23, Yudi Eko <yudieko@gmail.com> wrote:

 
Dear Master/sesepuh XL-Mania

Saya perlu Macro Vb-Excel untuk otomasi Debit-Credit Balance buku kas 
secara otomat bikin balance baru sepeti contoh terlampir

Thanks para master excel

Yudi

Wed Nov 6, 2013 5:59 pm (PST) . Posted by:

"Opik Pds" opik_pds

Hai Yudi,
Pake rumus mau ga?
Isikan pada F3
=IF(OR(D3>0,E3>0),F2+D3-E3,"")
Copy kebawah
Semoga jadi satu solusi ya

 
Regard,

Opik PDS

On Wednesday, November 6, 2013 10:22 PM, Yudi Eko <yudieko@gmail.com> wrote:

 
Dear Master/sesepuh XL-Mania

Saya perlu Macro Vb-Excel untuk otomasi Debit-Credit Balance buku kas 
secara otomat bikin balance baru sepeti contoh terlampir

Thanks para master excel

Yudi

Wed Nov 6, 2013 6:05 pm (PST) . Posted by:

"Mr. Kid" nmkid.family@ymail.com

Hai Yudi,

File terlampir memanfaatkan fitur Excel Table (xl2007 ke atas, pada xl2003
bernama List)

Wassalam,
Kid.

2013/11/5 Yudi Eko <yudieko@gmail.com>

>
>
> Dear Master/sesepuh XL-Mania
>
> Saya perlu Macro Vb-Excel untuk otomasi Debit-Credit Balance buku kas
> secara otomat bikin balance baru sepeti contoh terlampir
>
> Thanks para master excel
>
> Yudi
>
>
>

Wed Nov 6, 2013 7:23 am (PST) . Posted by:

"Bagus" bagus4bls

Halo..

Mungkin begini;
Array formula ya..

untuk Min
=MIN(IF(((B3:J3=B3)*(A4:A17=A6)),B4:J17))

untuk Max
=MAX(IF(((B3:J3=B3)*(A4:A17=A6)),B4:J17))

Wassalam

~ Bagus ~

----- Original Message -----
From: aries2607@yahoo.com
To: XL-mania@yahoogroups.com
Sent: Monday, November 04, 2013 9:19 AM
Subject: ]] XL-mania [[ max if dan min if [1 Attachment]

Halo pakar excel semuanya..

saya lagi ada kerjaan yang berhubungan dengan rumus max n min.
saya ada melampirkan sheet nya.
sedikit penjelasan :
kolom a,b,c berisikan tempat dan baris 1,2,3 berisikan jam
yang saya ingin buat adalah pada jam 9:00 selama 1 bulan pada tempat a MIN orang dan MAX orang.

Terima kasih.

Wed Nov 6, 2013 5:59 pm (PST) . Posted by:

pataya_1928

Sebelumnya minta maaf karena saya memang masih belajar, jadi masih banyak butuh bimbingan.


Saya memiliki data yang terdiri dari 2 sheet, bagaimana caranya agar rekap jumlah berdasarkan tingkat pendidikan pada sheet 'rekap&#39; otomatis terisi dengan kualifikasi pendidikan sesuai sheet 'Data Guru' sesuai jenis kelamin. Thank's
GROUP FOOTER MESSAGE
+-:: XL-mania ::::::::::::::::::::----------------------------------+
| Maaf moderasi terlambat karena yahoogroups sering error           |
+-------------------------------------------------------------------+
| DILARANG : MLM, money game, OOT, iklan tanpa izin, SARA, testing, |
| pembicaraan pribadi, one line message,  melecehkan,  tidak sopan. |
+-------------------------------------------------------------------+
| Buat subjek yang kreatif, jangan : "tanya", "help", "mohon bantu" |
| Usahakan besar attachment < 200 kb. Gunakan  winzip  jika  perlu. |
+-------------------------------------------------------------------+
| Ajak teman-teman Anda bergabung dengan mengirim e-mail kosong ke  |
| XL-mania-subscribe@yahoogroups.com atau kirimkan mereka file dari |
| http://groups.yahoo.com/group/XL-mania/files/Promotion/           |
+-------------------------------------------------------------------+
| Berikan testimoni di :                                            |
| http://www.xl-mania.com/2008/06/testimoni-xl-mania.html           |
+-------------------------------------------------------------------+
| Message lama ada di :                                             |
| http://groups.yahoo.com/group/XL-mania/messages [perlu yahoo id]  |
| http://www.mail-archive.com/xl-mania@yahoogroups.com              |
+-------------------------------------------------------------------+
Diposting oleh EXCEL FEED LEARNING di 01.53

Tidak ada komentar:

Posting Komentar

Langganan: Posting Komentar (Atom)