Rabu, 30 November 2016

[smf_addin] Digest Number 3855[1 Attachment]

10 Messages

Digest #3855
1a
1b
Re: IBD json extraction by "Randy Harmelink" rharmelink
1c
2a
Re: Yahoo Elements by "Randy Harmelink" rharmelink
2b
Re: Yahoo Elements by justy_sports
2c
Re: Yahoo Elements by "Randy Harmelink" rharmelink
2d
Re: Yahoo Elements by "Andrew Hills" andrew.hills@hunterfield.com.au

Messages

Tue Nov 29, 2016 7:25 pm (PST) . Posted by:

justy_sports

You could do something like this:

Cell A1: =RCHGetWebData("http://research.investors.com/services/PsyChartService.svc/summary?type=highlowratio&frequency=1")


Cell A2: =MID(A1,FIND("Price";,A1)+7,100)


Cell A3: =LEFT(A2,FIND(",",A2)-1)

Tue Nov 29, 2016 7:34 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Try:

=smfWord(RCHGetWebData("
http://research.investors.com/services/PsyChartService.svc/summary?type=highlowratio&frequency=1
","""Price"":"),1,",")

Or, to get the actual value:

=smfConvertData(smfStrExtr(RCHGetWebData("
http://research.investors.com/services/PsyChartService.svc/summary?type=highlowratio&frequency=1
"),"""Price"":",","))

On Tue, Nov 29, 2016 at 8:06 PM, sirons1962@yahoo.com [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> Is there a way to pull the data from this:
>
> http://research.investors.com/services/PsyChartService.svc/
> summary?type=highlowratio&frequency=1
>
> which leads to a json item, I think, which is this:
>
> {"GetSummaryResult":{"ErrorMessage":"","Frequency":
> 1,"HasError&quot;:false,"Price";:3.34,"Price2":0,"Price2Change&quot;:
> 0,"PriceChange":0.2652,"Type":3,"Updated":"&#92;/Date(1480320000000-0800)\/"}}
>
> I am looking to get the "Price":3.34 out of it.
>
>

Tue Nov 29, 2016 8:26 pm (PST) . Posted by:

sirons1962

Thank you both for the quick responses!

Tue Nov 29, 2016 7:28 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

Interesting. For the last 3 items, I get:

Year Ago EPS</td><td class="Ta(end)" data-reactid="369"><span
data-reactid="370">1.66</span></td><td class="Ta(end)"
data-reactid="371"><span data-reactid="372">2.05</span></td><td
class="Ta(end)" dat

<span data-reactid="370">1.66</span>

1.66

That means the source code being delivered to you is different than the
source code being sent to me. You appear to be in the middle of JSON code.
When I load the web page, it appears to be dynamically loading, so I
wouldn't have expected a finished web page like I'm receiving...

Not sure what's going on.

It may have something to do with the version of IE or O/S that is running?
But that gives me nothing to test.

Hmmm. Grasping at straws here, but what do you get with the original URL on:

=RCHGetWebData("http://finance.yahoo.com/q/ae?s=MMM",,50)

=RCHGetWebData("http://finance.yahoo.com/q/ae?s=MMM","Year Ago EPS",200)

=smfGetTagContent("http://finance.yahoo.com/q/ae?s=MMM","td",1,"Year Ago
EPS")

I'm assume all "Error" values, because of the redirection?

On Tue, Nov 29, 2016 at 7:18 PM, justy_sports@
​...wrote:

>
> *=RCHGetWebData("http://finance.yahoo.com/quote/MMM/analysts
> <http://finance.yahoo.com/quote/MMM/analysts>",,500)* <!DOCTYPE
> html><html id="atomic" class="NoJs ie-11 desktop" lang="en-US"><head
> prefix="og: http://ogp.me/ns#"><script>window.performance &&
> window.performance.mark && window.performance.mark('PageStart');</script><meta
> charset="utf-8"/><title>MMM Analyst Opinion | Analyst Estimates | 3M
> Company Common Stock Stock - Yahoo Finance</title><meta name="keywords"
> content="recommendation,analyst,analyst rating,strong buy,strong
> sell,hold,buy,sell,overweight,underweight,upgrade,downgrade,price
> target,EP
>
> =RCHGetWebData("http://finance.yahoo.com/quote/MMM/analysts","Year Ago
> EPS",200) Year Ago EPS","YEAR_AGO_SALES":"Year Ago
> Sales","YORIG_TITLE":"Yahoo Originals","YOY":"yoy","YTD":"YTD","YTD_RETURN":"YTD
> Return","YTD_RETURN_MKT":"Year-to-Date Return
> (Mkt)","YTD_RETURN_PCT":"Year-to
>
> =smfGetTagContent("http://finance.yahoo.com/quote/MMM/analysts","td",1,"Year
> Ago EPS") Error
>
> =smfGetTagContent("http://finance.yahoo.com/quote/MMM/analysts","span",1,"Year
> Ago EPS") Error
>
>
>

Tue Nov 29, 2016 7:50 pm (PST) . Posted by:

justy_sports

For those 3, I get:

<!DOCTYPE html><html id="atomic&quot; class="NoJs ie-11


Year Ago EPS","YEAR_AGO_SALES":"Year Ago Sales","YORIG_TITLE":"Yahoo Originals","YOY":"yoy","YTD":"YTD","YTD_RETURN":"YTD Return","YTD_RETURN_MKT":"Year-to-Date Return (Mkt)","YTD_RETURN_PCT":"Year-to


Error


When I view the source code of the web page, I don't see HTML tags, which would explain why #3 returns Error. I'm concerned that somehow I am seeing some beta version of Yahoo Finance that utilizes dynamic content...







Tue Nov 29, 2016 8:24 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

It looks like the URL redirection is working, so you just get the source
code from the new URL.

Try this to extract the data from the retrieved JSON data:

=smfConvertData(smfStrExtr(LEFT(smfWord(RCHGetWebData("
https://query2.finance.yahoo.com/v10/finance/quoteSummary/
"&C$5&"?formatted=true&modules=financialData,earningsHistory,earningsTrend&corsDomain=
finance.yahoo.com"),$B6,"yearAgoEps"":"),20),":",","))

...where C$5 contains the ticker symbol and $B7 varies from 2 to 5 for the
four data items on the line in the table.

For MCD, I get all four items. For MMM, I get the first 2 and the last 2
are blank (which Yahoo is displaying as N/A:

MMM MCD
1
2 1.66 1.31
3 2.05 1.23
4 4.98
5 5.69
That's cells B5:D10 in EXCEL, and the formula above is what I was using in
cell C6 (i.e. MMM and 1). It can just be copied to fill out the table once
the first row and first column have been manually entered.

On Tue, Nov 29, 2016 at 8:50 PM, justy_sports@
​...wrote:

>
> For those 3, I get:
>
> <!DOCTYPE html><html id="atomic&quot; class="NoJs ie-11
>
> Year Ago EPS","YEAR_AGO_SALES":"Year Ago Sales","YORIG_TITLE":"Yahoo
> Originals","YOY":"yoy","YTD":"YTD","YTD_RETURN":"YTD
> Return","YTD_RETURN_MKT":"Year-to-Date Return
> (Mkt)","YTD_RETURN_PCT":"Year-to
>
> Error
>
> When I view the source code of the web page, I don't see HTML tags, which
> would explain why #3 returns Error. I'm concerned that somehow I am seeing
> some beta version of Yahoo Finance that utilizes dynamic content...
>
>
>

Tue Nov 29, 2016 9:35 pm (PST) . Posted by:

"Andrew Hills" andrew.hills@hunterfield.com.au

Yes, I'm having similar issues with similar Yahoo Element numbers. Yahoo data is unstable.....unfortunately.

> On 30 Nov. 2016, at 7:24 am, justy_sports@yahoo.com [smf_addin] <smf_addin@yahoogroups.com> wrote:
>
> I receive "Error" when I try =RCHGetElementNumber("MMM",599)
>
>
> My version is - Stock Market Functions add-in, Version 2.1.2016.09.02 (C:\Program Files\SMF Add-in; Windows (32-bit) NT 6.01; 15.0; www; Local; 1)
>
> smfGetAParms - YahooAE;Earnings Estimates -- Year Ago EPS -- FY1;http://finance.yahoo.com/q/ae?s=~~~~~;3;EARNINGS EST;YEAR AGO EPS; ; ;0;0;0;0
>
> I have a colleague experiencing the same issue on his computer... might we have an outdated definition file? I tried removing all definition files and re-downloading the current versions but that did not help.
>
>
>

Tue Nov 29, 2016 9:12 pm (PST) . Posted by:

mff2805

hi,
i have a list of stock names and i am ttrying to find an automated way of getting a ticker symbol for each. at least a best guess ticker symbol. Any ideas?
names look like
WABCO Holdings Wabtec Wabtec Corp/DE Waters Corp Wayfair, Class A Webster Financial WellCare Health Plans Welltower Inc West Pharmaceutical Services Westamerica Bancorporation WestRock Co
thanks much
Mike


Tue Nov 29, 2016 9:54 pm (PST) . Posted by:

"Randy Harmelink" rharmelink

​Take a look at the attached workbook. This extracts data from the JSON
results that Yahoo uses to populate the tickers and symbols when you type a
company name in the search field on the finance page.​ For example, take a
look at this URL of JSON results for "wabco":

http://finance.yahoo.com/_finance_doubledown/api/resource/searchassist;gossipConfig=%7B%22url%22:%7B%22host%22:%22s.yimg.com%22,%22path%22:%22/xb/v6/finance/autocomplete%22,%22query%22:%7B%22appid%22:%22yahoo.com%22,%22nresults%22:10,%22output%22:%22yjsonp%22,%22region%22:%22US%22,%22lang%22:%22en-US%22%7D,%22protocol%22:%22https%22%7D,%22isJSONP%22:true,%22queryKey%22:%22query%22,%22resultAccessor%22:%22ResultSet.Result%22,%22suggestionTitleAccessor%22:%22symbol%22,%22suggestionMeta%22:[%22symbol%22,%22name%22,%22exch%22,%22type%22,%22exchDisp%22,%22typeDisp%22]%7D;searchTerm=wabco

On Tue, Nov 29, 2016 at 10:12 PM, mff3429@comcast.net [smf_addin] <
smf_addin@yahoogroups.com> wrote:

>
> i have a list of stock names and i am ttrying to find an automated way of
> getting a ticker symbol for each. at least a best guess ticker symbol.
> Any ideas?
> names look like
> WABCO Holdings Wabtec Wabtec Corp/DE Waters Corp Wayfair, Class A
> Webster Financial WellCare Health Plans Welltower Inc West
> Pharmaceutical Services Westamerica Bancorporation WestRock Co
>
Attachment(s) from Randy Harmelink
1 of 1 File(s)

Tue Nov 29, 2016 10:40 pm (PST) . Posted by:

mff2805

THIS HELPS QUITE A BUNCH. SOMETIMES I HAVE TO MAKE ADJUSTMENTS TO THE NAME, SUCH AS DELETING "clASS a", ETC. THANKS FOR THE QUICK RESPONSE. I NEVER WOULD HAVE FIGURED IT OUT

oops Sorry for the CapLock.
For the Add-in, Documentation, Templates, Tips and FAQs, visit http://ogres-crypt.com/SMF
READ MORE....

[belajar-excel] Digest Number 4033

9 Messages

Digest #4033
1a
2a
pindah data by "Hendro Arifin" hendro_arifin
3a
Re: No Urut Registrasi by "Mr. Kid" nmkid.family@ymail.com
3b
Re: No Urut Registrasi by "Samsudin Sam"
3c
Re: No Urut Registrasi by "Samsudin Sam"
3d
Re: No Urut Registrasi by "Samsudin Sam"

Messages

Tue Nov 29, 2016 2:31 am (PST) . Posted by:

"Toby kenzo" tobykenzo

Dear Samsudin,
Saya coba dengan menggunakan VBA.(Hapus semua no. Registrasi kemudian click tombol "CHECK")Semoga membantu..
TerimaKasih,


Pada Selasa, 29 November 2016 16:50, "Susilo - susilo.ib@gmail.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


  Dear sam
Saya menambahkan 2 kolom ID untuk mengurutkan tanggalnyaMungkin rekan-rekan ada yang bisa membantu untuk lebih menyederhanakan lagi
Silakan merujuk pada attachment file berikut
Terima kasihSusilo

Pada 29 November 2016 15.15, Samsudin Sam samsudinortega@yahoo.com [belajar-excel] <belajar-excel@yahoogroups.com> menulis:

  Master Excel yth,
mohon bantuan dan pencerahannya untuk masalah yang saya hadapi, rencananya saya ingin membuat no urut registrasi, no urut ini dimulai dari control no yang datang di site pertama/berdasarkan data on site. berikut saya sudah mencoba membuatnya tetapi menggunakan step8 (sheet1,cell l3:24), apakah ada yang bisa membantu untuk masalah ini yang lebih praktis lagi.
terima kasih
samsudin

#yiv2473183595 #yiv2473183595 -- #yiv2473183595ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv2473183595 #yiv2473183595ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv2473183595 #yiv2473183595ygrp-mkp #yiv2473183595hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv2473183595 #yiv2473183595ygrp-mkp #yiv2473183595ads {margin-bottom:10px;}#yiv2473183595 #yiv2473183595ygrp-mkp .yiv2473183595ad {padding:0 0;}#yiv2473183595 #yiv2473183595ygrp-mkp .yiv2473183595ad p {margin:0;}#yiv2473183595 #yiv2473183595ygrp-mkp .yiv2473183595ad a {color:#0000ff;text-decoration:none;}#yiv2473183595 #yiv2473183595ygrp-sponsor #yiv2473183595ygrp-lc {font-family:Arial;}#yiv2473183595 #yiv2473183595ygrp-sponsor #yiv2473183595ygrp-lc #yiv2473183595hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2473183595 #yiv2473183595ygrp-sponsor #yiv2473183595ygrp-lc .yiv2473183595ad {margin-bottom:10px;padding:0 0;}#yiv2473183595 #yiv2473183595actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv2473183595 #yiv2473183595activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2473183595 #yiv2473183595activity span {font-weight:700;}#yiv2473183595 #yiv2473183595activity span:first-child {text-transform:uppercase;}#yiv2473183595 #yiv2473183595activity span a {color:#5085b6;text-decoration:none;}#yiv2473183595 #yiv2473183595activity span span {color:#ff7900;}#yiv2473183595 #yiv2473183595activity span .yiv2473183595underline {text-decoration:underline;}#yiv2473183595 .yiv2473183595attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv2473183595 .yiv2473183595attach div a {text-decoration:none;}#yiv2473183595 .yiv2473183595attach img {border:none;padding-right:5px;}#yiv2473183595 .yiv2473183595attach label {display:block;margin-bottom:5px;}#yiv2473183595 .yiv2473183595attach label a {text-decoration:none;}#yiv2473183595 blockquote {margin:0 0 0 4px;}#yiv2473183595 .yiv2473183595bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv2473183595 .yiv2473183595bold a {text-decoration:none;}#yiv2473183595 dd.yiv2473183595last p a {font-family:Verdana;font-weight:700;}#yiv2473183595 dd.yiv2473183595last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2473183595 dd.yiv2473183595last p span.yiv2473183595yshortcuts {margin-right:0;}#yiv2473183595 div.yiv2473183595attach-table div div a {text-decoration:none;}#yiv2473183595 div.yiv2473183595attach-table {width:400px;}#yiv2473183595 div.yiv2473183595file-title a, #yiv2473183595 div.yiv2473183595file-title a:active, #yiv2473183595 div.yiv2473183595file-title a:hover, #yiv2473183595 div.yiv2473183595file-title a:visited {text-decoration:none;}#yiv2473183595 div.yiv2473183595photo-title a, #yiv2473183595 div.yiv2473183595photo-title a:active, #yiv2473183595 div.yiv2473183595photo-title a:hover, #yiv2473183595 div.yiv2473183595photo-title a:visited {text-decoration:none;}#yiv2473183595 div#yiv2473183595ygrp-mlmsg #yiv2473183595ygrp-msg p a span.yiv2473183595yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2473183595 .yiv2473183595green {color:#628c2a;}#yiv2473183595 .yiv2473183595MsoNormal {margin:0 0 0 0;}#yiv2473183595 o {font-size:0;}#yiv2473183595 #yiv2473183595photos div {float:left;width:72px;}#yiv2473183595 #yiv2473183595photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv2473183595 #yiv2473183595photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2473183595 #yiv2473183595reco-category {font-size:77%;}#yiv2473183595 #yiv2473183595reco-desc {font-size:77%;}#yiv2473183595 .yiv2473183595replbq {margin:4px;}#yiv2473183595 #yiv2473183595ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv2473183595 #yiv2473183595ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv2473183595 #yiv2473183595ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv2473183595 #yiv2473183595ygrp-mlmsg select, #yiv2473183595 input, #yiv2473183595 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv2473183595 #yiv2473183595ygrp-mlmsg pre, #yiv2473183595 code {font:115% monospace;}#yiv2473183595 #yiv2473183595ygrp-mlmsg * {line-height:1.22em;}#yiv2473183595 #yiv2473183595ygrp-mlmsg #yiv2473183595logo {padding-bottom:10px;}#yiv2473183595 #yiv2473183595ygrp-msg p a {font-family:Verdana;}#yiv2473183595 #yiv2473183595ygrp-msg p#yiv2473183595attach-count span {color:#1E66AE;font-weight:700;}#yiv2473183595 #yiv2473183595ygrp-reco #yiv2473183595reco-head {color:#ff7900;font-weight:700;}#yiv2473183595 #yiv2473183595ygrp-reco {margin-bottom:20px;padding:0px;}#yiv2473183595 #yiv2473183595ygrp-sponsor #yiv2473183595ov li a {font-size:130%;text-decoration:none;}#yiv2473183595 #yiv2473183595ygrp-sponsor #yiv2473183595ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv2473183595 #yiv2473183595ygrp-sponsor #yiv2473183595ov ul {margin:0;padding:0 0 0 8px;}#yiv2473183595 #yiv2473183595ygrp-text {font-family:Georgia;}#yiv2473183595 #yiv2473183595ygrp-text p {margin:0 0 1em 0;}#yiv2473183595 #yiv2473183595ygrp-text tt {font-size:120%;}#yiv2473183595 #yiv2473183595ygrp-vital ul li:last-child {border-right:none !important;}#yiv2473183595

Tue Nov 29, 2016 3:50 am (PST) . Posted by:

"Samsudin Sam"

Dear Pak Toby,

Terima kasih atas pencerahannya dan sangat membantu untuk menambah ttg vba maklum saya belum familiar dg vba.

Terima kasih
Samsudin
--------------------------------------------
Pada Sel, 29/11/16, Toby kenzo tobykenzo@yahoo.co.id [belajar-excel] <belajar-excel@yahoogroups.com> menulis:

Judul: Bls: [belajar-excel] No Urut Registrasi
Kepada: "belajar-excel@yahoogroups.com" <belajar-excel@yahoogroups.com>
Tanggal: Selasa, 29 November, 2016, 10:28 AM

Dear Samsudin,
Saya coba dengan menggunakan VBA.(Hapus
semua no. Registrasi kemudian click tombol
"CHECK")Semoga membantu..
TerimaKasih,


    Pada Selasa, 29 November
2016 16:50, "Susilo - susilo.ib@gmail.com
[belajar-excel]" <belajar-excel@yahoogroups.com>
menulis:



    Dear sam
Saya menambahkan 2
kolom ID untuk mengurutkan tanggalnyaMungkin rekan-rekan ada
yang bisa membantu untuk lebih menyederhanakan lagi
Silakan merujuk pada attachment file berikut
Terima kasihSusilo

Pada 29 November 2016 15.15, Samsudin Sam samsudinortega@yahoo.com
[belajar-excel] <belajar-excel@yahoogroups.com>
menulis:


    Master Excel yth,
mohon
bantuan dan pencerahannya untuk masalah yang saya hadapi,
rencananya saya ingin membuat no urut registrasi, no urut
ini dimulai dari control no yang datang di site
pertama/berdasarkan data on site. berikut saya sudah mencoba
membuatnya tetapi menggunakan step8 (sheet1,cell l3:24),
apakah ada yang bisa membantu untuk masalah ini yang lebih
praktis lagi.
terima kasih
samsudin

   

  #yiv2473183595 #yiv2473183595 --
#yiv2473183595ygrp-mkp {border:1px solid
#d8d8d8;font-family:Arial;margin:10px 0;padding:0
10px;}#yiv2473183595 #yiv2473183595ygrp-mkp hr {border:1px
solid #d8d8d8;}#yiv2473183595 #yiv2473183595ygrp-mkp
#yiv2473183595hd
{color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px
0;}#yiv2473183595 #yiv2473183595ygrp-mkp #yiv2473183595ads
{margin-bottom:10px;}#yiv2473183595 #yiv2473183595ygrp-mkp
.yiv2473183595ad {padding:0 0;}#yiv2473183595
#yiv2473183595ygrp-mkp .yiv2473183595ad p
{margin:0;}#yiv2473183595 #yiv2473183595ygrp-mkp
.yiv2473183595ad a
{color:#0000ff;text-decoration:none;}#yiv2473183595
#yiv2473183595ygrp-sponsor #yiv2473183595ygrp-lc
{font-family:Arial;}#yiv2473183595
#yiv2473183595ygrp-sponsor #yiv2473183595ygrp-lc
#yiv2473183595hd {margin:10px
0px;font-weight:700;font-size:78%;line-height:122%;}#yiv2473183595
#yiv2473183595ygrp-sponsor #yiv2473183595ygrp-lc
.yiv2473183595ad {margin-bottom:10px;padding:0
0;}#yiv2473183595 #yiv2473183595actions
{font-family:Verdana;font-size:11px;padding:10px
0;}#yiv2473183595 #yiv2473183595activity
{background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv2473183595
#yiv2473183595activity span {font-weight:700;}#yiv2473183595
#yiv2473183595activity span:first-child
{text-transform:uppercase;}#yiv2473183595
#yiv2473183595activity span a
{color:#5085b6;text-decoration:none;}#yiv2473183595

#yiv2473183595activity span span
{color:#ff7900;}#yiv2473183595 #yiv2473183595activity span
.yiv2473183595underline
{text-decoration:underline;}#yiv2473183595
.yiv2473183595attach
{clear:both;display:table;font-family:Arial;font-size:12px;padding:10px
0;width:400px;}#yiv2473183595 .yiv2473183595attach div a
{text-decoration:none;}#yiv2473183595 .yiv2473183595attach
img {border:none;padding-right:5px;}#yiv2473183595
.yiv2473183595attach label
{display:block;margin-bottom:5px;}#yiv2473183595
.yiv2473183595attach label a
{text-decoration:none;}#yiv2473183595 blockquote {margin:0 0
0 4px;}#yiv2473183595 .yiv2473183595bold
{font-family:Arial;font-size:13px;font-weight:700;}#yiv2473183595
.yiv2473183595bold a {text-decoration:none;}#yiv2473183595
dd.yiv2473183595last p a
{font-family:Verdana;font-weight:700;}#yiv2473183595
dd.yiv2473183595last p span
{margin-right:10px;font-family:Verdana;font-weight:700;}#yiv2473183595
dd.yiv2473183595last p span.yiv2473183595yshortcuts
{margin-right:0;}#yiv2473183595
div.yiv2473183595attach-table div div a
{text-decoration:none;}#yiv2473183595
div.yiv2473183595attach-table {width:400px;}#yiv2473183595
div.yiv2473183595file-title a, #yiv2473183595
div.yiv2473183595file-title a:active, #yiv2473183595

div.yiv2473183595file-title a:hover, #yiv2473183595
div.yiv2473183595file-title a:visited
{text-decoration:none;}#yiv2473183595
div.yiv2473183595photo-title a, #yiv2473183595
div.yiv2473183595photo-title a:active, #yiv2473183595
div.yiv2473183595photo-title a:hover, #yiv2473183595
div.yiv2473183595photo-title a:visited
{text-decoration:none;}#yiv2473183595
div#yiv2473183595ygrp-mlmsg #yiv2473183595ygrp-msg p a
span.yiv2473183595yshortcuts
{font-family:Verdana;font-size:10px;font-weight:normal;}#yiv2473183595

.yiv2473183595green {color:#628c2a;}#yiv2473183595
.yiv2473183595MsoNormal {margin:0 0 0 0;}#yiv2473183595 o
{font-size:0;}#yiv2473183595 #yiv2473183595photos div
{float:left;width:72px;}#yiv2473183595 #yiv2473183595photos
div div {border:1px solid
#666666;height:62px;overflow:hidden;width:62px;}#yiv2473183595
#yiv2473183595photos div label
{color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv2473183595
#yiv2473183595reco-category {font-size:77%;}#yiv2473183595
#yiv2473183595reco-desc {font-size:77%;}#yiv2473183595
.yiv2473183595replbq {margin:4px;}#yiv2473183595
#yiv2473183595ygrp-actbar div a:first-child
{margin-right:2px;padding-right:5px;}#yiv2473183595
#yiv2473183595ygrp-mlmsg {font-size:13px;font-family:Arial,
helvetica, clean, sans-serif;}#yiv2473183595
#yiv2473183595ygrp-mlmsg table
{font-size:inherit;font:100%;}#yiv2473183595
#yiv2473183595ygrp-mlmsg select, #yiv2473183595 input,
#yiv2473183595 textarea {font:99% Arial, Helvetica, clean,
sans-serif;}#yiv2473183595 #yiv2473183595ygrp-mlmsg pre,
#yiv2473183595 code {font:115% monospace;}#yiv2473183595
#yiv2473183595ygrp-mlmsg *
{line-height:1.22em;}#yiv2473183595 #yiv2473183595ygrp-mlmsg
#yiv2473183595logo {padding-bottom:10px;}#yiv2473183595
#yiv2473183595ygrp-msg p a
{font-family:Verdana;}#yiv2473183595 #yiv2473183595ygrp-msg
p#yiv2473183595attach-count span
{color:#1E66AE;font-weight:700;}#yiv2473183595
#yiv2473183595ygrp-reco #yiv2473183595reco-head
{color:#ff7900;font-weight:700;}#yiv2473183595
#yiv2473183595ygrp-reco
{margin-bottom:20px;padding:0px;}#yiv2473183595
#yiv2473183595ygrp-sponsor #yiv2473183595ov li a
{font-size:130%;text-decoration:none;}#yiv2473183595
#yiv2473183595ygrp-sponsor #yiv2473183595ov li
{font-size:77%;list-style-type:square;padding:6px
0;}#yiv2473183595 #yiv2473183595ygrp-sponsor
#yiv2473183595ov ul {margin:0;padding:0 0 0
8px;}#yiv2473183595 #yiv2473183595ygrp-text
{font-family:Georgia;}#yiv2473183595 #yiv2473183595ygrp-text
p {margin:0 0 1em 0;}#yiv2473183595 #yiv2473183595ygrp-text
tt {font-size:120%;}#yiv2473183595 #yiv2473183595ygrp-vital
ul li:last-child {border-right:none
!important;}#yiv2473183595

   

Tue Nov 29, 2016 2:44 am (PST) . Posted by:

"Hendro Arifin" hendro_arifin


selamat sore mr.kid dan rekan2..
mohon bantuan untuk solusi berikut.
saya bermaksud memindahkan data dari sheet list_ho ke sheet dt_ print dimana list_ho adalah
hasil dari advance filter yang jumlah baris nya akan selalu berubah tiap kali tonbol print di tekan tetapi jumlah

tidak lebih dari 10 baris dan dengan jumlah kolom tetap yaitu 3 kolom.saya mempunyai kode macro tetapi
saya merasa kode saya tersebut terlalu panjang.bisakah kode saya tersebut di persingkat?atokah ada kode

lain untuk menggantikan kode macro saya tersebut?mohon petunjukanya
terima kasih.




salam hendro














Tue Nov 29, 2016 3:06 am (PST) . Posted by:

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

Hai Samsudin,

Coretan tentang pemeringkatan data (rank) dimulai dari sini
<http://excel-mr-kid.blogspot.com/2012/05/pemeringkatan-data-ranking.html>.
File terlampir sekadar contoh bahwa pivot table bisa dimanfaatkan untuk
menyusun output yang diinginkan oleh kasus ini setelah memanfaatkan formula
pemeringkatan data secara ordinal. Silakan dikembangkan sesuai kebutuhan.

Regards,
Kid

2016-11-29 15:15 GMT+07:00 Samsudin Sam samsudinortega@yahoo.com
[belajar-excel] <belajar-excel@yahoogroups.com>:

>
>
> Master Excel yth,
>
> mohon bantuan dan pencerahannya untuk masalah yang saya hadapi, rencananya
> saya ingin membuat no urut registrasi, no urut ini dimulai dari control no
> yang datang di site pertama/berdasarkan data on site. berikut saya sudah
> mencoba membuatnya tetapi menggunakan step8 (sheet1,cell l3:24), apakah ada
> yang bisa membantu untuk masalah ini yang lebih praktis lagi.
>
> terima kasih
>
> samsudin
>
>
>

Tue Nov 29, 2016 3:45 am (PST) . Posted by:

"Samsudin Sam"

Dear Pak Susilo,

Terima kasih atas bantuannya dan bisa menambah lagi tentang formula ini dan jika kiranya bisa menjelaskan formula tsb sangat baik lagi.

Terima kasih
Samsudin
--------------------------------------------
Pada Sel, 29/11/16, Susilo - susilo.ib@gmail.com [belajar-excel] <belajar-excel@yahoogroups.com> menulis:

Judul: Re: [belajar-excel] No Urut Registrasi
Kepada: belajar-excel@yahoogroups.com
Tanggal: Selasa, 29 November, 2016, 9:49 AM

Dear sam

Saya menambahkan 2 kolom ID
untuk mengurutkan tanggalnya
Mungkin
rekan-rekan ada yang bisa membantu untuk lebih
menyederhanakan lagi

Silakan merujuk pada attachment file berikut

Terima kasih
Susilo


Pada 29 November 2016 15.15, Samsudin Sam samsudinortega@yahoo.com
[belajar-excel] <belajar-excel@yahoogroups.com>
menulis:

>
>
> Master Excel yth,
>
> mohon bantuan dan
pencerahannya untuk masalah yang saya hadapi, rencananya
> saya ingin membuat no urut registrasi, no
urut ini dimulai dari control no
> yang
datang di site pertama/berdasarkan data on site. berikut
saya sudah
> mencoba membuatnya tetapi
menggunakan step8 (sheet1,cell l3:24), apakah ada
> yang bisa membantu untuk masalah ini yang
lebih praktis lagi.
>
> terima kasih
>
> samsudin
>
>
>

Tue Nov 29, 2016 3:45 am (PST) . Posted by:

"Samsudin Sam"

Dear Pak Susilo,

Terima kasih atas bantuannya dan bisa menambah lagi tentang formula ini dan jika kiranya bisa menjelaskan formula tsb sangat baik lagi.

Terima kasih
Samsudin
--------------------------------------------
Pada Sel, 29/11/16, Susilo - susilo.ib@gmail.com [belajar-excel] <belajar-excel@yahoogroups.com> menulis:

Judul: Re: [belajar-excel] No Urut Registrasi
Kepada: belajar-excel@yahoogroups.com
Tanggal: Selasa, 29 November, 2016, 9:49 AM

Dear sam

Saya menambahkan 2 kolom ID
untuk mengurutkan tanggalnya
Mungkin
rekan-rekan ada yang bisa membantu untuk lebih
menyederhanakan lagi

Silakan merujuk pada attachment file berikut

Terima kasih
Susilo


Pada 29 November 2016 15.15, Samsudin Sam samsudinortega@yahoo.com
[belajar-excel] <belajar-excel@yahoogroups.com>
menulis:

>
>
> Master Excel yth,
>
> mohon bantuan dan
pencerahannya untuk masalah yang saya hadapi, rencananya
> saya ingin membuat no urut registrasi, no
urut ini dimulai dari control no
> yang
datang di site pertama/berdasarkan data on site. berikut
saya sudah
> mencoba membuatnya tetapi
menggunakan step8 (sheet1,cell l3:24), apakah ada
> yang bisa membantu untuk masalah ini yang
lebih praktis lagi.
>
> terima kasih
>
> samsudin
>
>
>

Tue Nov 29, 2016 4:27 am (PST) . Posted by:

"Samsudin Sam"

Dear Mr. Kid,

Terima kasih atas pencerahannya sehingga sangat menambah wawasan akan fungsi pivot.

Terima kasih
Samsudin
--------------------------------------------
Pada Sel, 29/11/16, 'Mr. Kid' mr.nmkid@gmail.com [belajar-excel] <belajar-excel@yahoogroups.com> menulis:

Judul: Re: [belajar-excel] No Urut Registrasi
Kepada: "BeExcel" <belajar-excel@yahoogroups.com>
Tanggal: Selasa, 29 November, 2016, 11:06 AM

Hai Samsudin,

Coretan tentang pemeringkatan
data (rank) dimulai dari sini
<http://excel-mr-kid.blogspot.com/2012/05/pemeringkatan-data-ranking.html>.
File terlampir sekadar contoh bahwa pivot table
bisa dimanfaatkan untuk
menyusun output yang
diinginkan oleh kasus ini setelah memanfaatkan formula
pemeringkatan data secara ordinal. Silakan
dikembangkan sesuai kebutuhan.

Regards,
Kid






2016-11-29 15:15 GMT+07:00 Samsudin Sam samsudinortega@yahoo.com
[belajar-excel] <belajar-excel@yahoogroups.com>:

>
>
> Master Excel yth,
>
> mohon bantuan dan pencerahannya untuk
masalah yang saya hadapi, rencananya
>
saya ingin membuat no urut registrasi, no urut ini dimulai
dari control no
> yang datang di site
pertama/berdasarkan data on site. berikut saya sudah
> mencoba membuatnya tetapi menggunakan
step8 (sheet1,cell l3:24), apakah ada
>
yang bisa membantu untuk masalah ini yang lebih praktis
lagi.
>
> terima
kasih
>
> samsudin
>
>
>

Tue Nov 29, 2016 1:39 pm (PST) . Posted by:

"harry budiman"

Selamat Sore

Mohon pencerahannya mengenai Grafik ataupun Kuadran yang dapat berubah
ketika kita memasukan criteria tertentu

Untuk kasus terlampir

Terima kasih atas bantuannya

Salam

Sent from Mail for Windows 10

Wed Nov 30, 2016 1:23 am (PST) . Posted by:

"Toby kenzo" tobykenzo

Dear Harry,
Penggunaan grafik Kuadran biasanya di gunakan untuk analisa SWOT, tapi untuk kasus anda, anda bisa gunakan Scatter.
TerimaKasih

Pada Rabu, 30 November 2016 4:40, "harry budiman sendtoharbud@gmail.com [belajar-excel]" <belajar-excel@yahoogroups.com> menulis:


  Selamat Sore

Mohon pencerahannya mengenai Grafik ataupun Kuadran yang dapat berubah
ketika kita memasukan criteria tertentu

Untuk kasus terlampir

Terima kasih atas bantuannya

Salam    Sent from Mail for Windows 10   #yiv8887182556 #yiv8887182556 -- #yiv8887182556ygrp-mkp {border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}#yiv8887182556 #yiv8887182556ygrp-mkp hr {border:1px solid #d8d8d8;}#yiv8887182556 #yiv8887182556ygrp-mkp #yiv8887182556hd {color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}#yiv8887182556 #yiv8887182556ygrp-mkp #yiv8887182556ads {margin-bottom:10px;}#yiv8887182556 #yiv8887182556ygrp-mkp .yiv8887182556ad {padding:0 0;}#yiv8887182556 #yiv8887182556ygrp-mkp .yiv8887182556ad p {margin:0;}#yiv8887182556 #yiv8887182556ygrp-mkp .yiv8887182556ad a {color:#0000ff;text-decoration:none;}#yiv8887182556 #yiv8887182556ygrp-sponsor #yiv8887182556ygrp-lc {font-family:Arial;}#yiv8887182556 #yiv8887182556ygrp-sponsor #yiv8887182556ygrp-lc #yiv8887182556hd {margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}#yiv8887182556 #yiv8887182556ygrp-sponsor #yiv8887182556ygrp-lc .yiv8887182556ad {margin-bottom:10px;padding:0 0;}#yiv8887182556 #yiv8887182556actions {font-family:Verdana;font-size:11px;padding:10px 0;}#yiv8887182556 #yiv8887182556activity {background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}#yiv8887182556 #yiv8887182556activity span {font-weight:700;}#yiv8887182556 #yiv8887182556activity span:first-child {text-transform:uppercase;}#yiv8887182556 #yiv8887182556activity span a {color:#5085b6;text-decoration:none;}#yiv8887182556 #yiv8887182556activity span span {color:#ff7900;}#yiv8887182556 #yiv8887182556activity span .yiv8887182556underline {text-decoration:underline;}#yiv8887182556 .yiv8887182556attach {clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}#yiv8887182556 .yiv8887182556attach div a {text-decoration:none;}#yiv8887182556 .yiv8887182556attach img {border:none;padding-right:5px;}#yiv8887182556 .yiv8887182556attach label {display:block;margin-bottom:5px;}#yiv8887182556 .yiv8887182556attach label a {text-decoration:none;}#yiv8887182556 blockquote {margin:0 0 0 4px;}#yiv8887182556 .yiv8887182556bold {font-family:Arial;font-size:13px;font-weight:700;}#yiv8887182556 .yiv8887182556bold a {text-decoration:none;}#yiv8887182556 dd.yiv8887182556last p a {font-family:Verdana;font-weight:700;}#yiv8887182556 dd.yiv8887182556last p span {margin-right:10px;font-family:Verdana;font-weight:700;}#yiv8887182556 dd.yiv8887182556last p span.yiv8887182556yshortcuts {margin-right:0;}#yiv8887182556 div.yiv8887182556attach-table div div a {text-decoration:none;}#yiv8887182556 div.yiv8887182556attach-table {width:400px;}#yiv8887182556 div.yiv8887182556file-title a, #yiv8887182556 div.yiv8887182556file-title a:active, #yiv8887182556 div.yiv8887182556file-title a:hover, #yiv8887182556 div.yiv8887182556file-title a:visited {text-decoration:none;}#yiv8887182556 div.yiv8887182556photo-title a, #yiv8887182556 div.yiv8887182556photo-title a:active, #yiv8887182556 div.yiv8887182556photo-title a:hover, #yiv8887182556 div.yiv8887182556photo-title a:visited {text-decoration:none;}#yiv8887182556 div#yiv8887182556ygrp-mlmsg #yiv8887182556ygrp-msg p a span.yiv8887182556yshortcuts {font-family:Verdana;font-size:10px;font-weight:normal;}#yiv8887182556 .yiv8887182556green {color:#628c2a;}#yiv8887182556 .yiv8887182556MsoNormal {margin:0 0 0 0;}#yiv8887182556 o {font-size:0;}#yiv8887182556 #yiv8887182556photos div {float:left;width:72px;}#yiv8887182556 #yiv8887182556photos div div {border:1px solid #666666;height:62px;overflow:hidden;width:62px;}#yiv8887182556 #yiv8887182556photos div label {color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}#yiv8887182556 #yiv8887182556reco-category {font-size:77%;}#yiv8887182556 #yiv8887182556reco-desc {font-size:77%;}#yiv8887182556 .yiv8887182556replbq {margin:4px;}#yiv8887182556 #yiv8887182556ygrp-actbar div a:first-child {margin-right:2px;padding-right:5px;}#yiv8887182556 #yiv8887182556ygrp-mlmsg {font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}#yiv8887182556 #yiv8887182556ygrp-mlmsg table {font-size:inherit;font:100%;}#yiv8887182556 #yiv8887182556ygrp-mlmsg select, #yiv8887182556 input, #yiv8887182556 textarea {font:99% Arial, Helvetica, clean, sans-serif;}#yiv8887182556 #yiv8887182556ygrp-mlmsg pre, #yiv8887182556 code {font:115% monospace;}#yiv8887182556 #yiv8887182556ygrp-mlmsg * {line-height:1.22em;}#yiv8887182556 #yiv8887182556ygrp-mlmsg #yiv8887182556logo {padding-bottom:10px;}#yiv8887182556 #yiv8887182556ygrp-msg p a {font-family:Verdana;}#yiv8887182556 #yiv8887182556ygrp-msg p#yiv8887182556attach-count span {color:#1E66AE;font-weight:700;}#yiv8887182556 #yiv8887182556ygrp-reco #yiv8887182556reco-head {color:#ff7900;font-weight:700;}#yiv8887182556 #yiv8887182556ygrp-reco {margin-bottom:20px;padding:0px;}#yiv8887182556 #yiv8887182556ygrp-sponsor #yiv8887182556ov li a {font-size:130%;text-decoration:none;}#yiv8887182556 #yiv8887182556ygrp-sponsor #yiv8887182556ov li {font-size:77%;list-style-type:square;padding:6px 0;}#yiv8887182556 #yiv8887182556ygrp-sponsor #yiv8887182556ov ul {margin:0;padding:0 0 0 8px;}#yiv8887182556 #yiv8887182556ygrp-text {font-family:Georgia;}#yiv8887182556 #yiv8887182556ygrp-text p {margin:0 0 1em 0;}#yiv8887182556 #yiv8887182556ygrp-text tt {font-size:120%;}#yiv8887182556 #yiv8887182556ygrp-vital ul li:last-child {border-right:none !important;}#yiv8887182556

============================================================
Pojok Lowongan Kerja yang disediakan milis :
http://milis-belajar-excel.1048464.n5.nabble.com/Pojok-Lowongan-Kerja-f5725753.html
*** Posting lowongan kerja : ke link tersebut dan klik New Topic
============================================================
bergabung ke milis (subscribe), kirim mail kosong ke: belajar-excel-subscribe@yahoogroups.com
posting ke milis, kirimkan ke: belajar-excel@yahoogroups.com
berkunjung ke web milis : http://tech.groups.yahoo.com/group/belajar-excel/messages
melihat file archive / mendownload lampiran : http://www.mail-archive.com/belajar-excel@yahoogroups.com/
atau (sejak 25-Apr-2011) bisa juga di : http://milis-belajar-excel.1048464.n5.nabble.com/
menghubungi moderators & owners: belajar-excel-owner@yahoogroups.com
keluar dari membership milis (UnSubscribe), kirim mail kosong ke : belajar-excel-unsubscribe@yahoogroups.com
---------------------------------------------------------------------
READ MORE....