Archive

Archive for the ‘Learning-Tool-is-any’ Category

How to add multiple clips to the timeline in Expression Encoder – at once

  1. Expression Encoder is a great screen casting tool for Windows – and it is free.
  2. Except that in the free version, each clip is limited to 10 minutes. This can result in many clips that you nee to combine to document one session.
  3. Adding clips to the media and encode them does not roll over at the end of one to the next clip (as thing used to Work in Windows Media Encoder) – it produces as many output files.
  4. Using the Add Source at End Cc294622.5bff4edb-e4d1-4fca-b268-0d194faf13d1(en-us,Expression.30).png. button seems to limit you to adding one clip after the other. image
  5. What I had missed so far: You can simply select multiple clips at once in the file open dialogue.
  6. Expression Encoder will add all to the timeline in sequence, and encode all to one output file: image

Radar Chart visualizing Cost of Living in select US Cities

sperlings-costofliving-us-cities-radar-chart

Source:Sperling’s

Categories: Charts, e-commerce, Media Tags: ,

Inserting Word Building Blocks from Template using Ribbon or QAT

Either insert from Ribbon / Insert / Quickparts: image

Or for extra speed and convenience, you can have your template store access to your building from the Quick Access Toolbar: image

Demo video is here.

How to prevent OneNote from crashing when hovering over search results

  1. Problem: In a strange new development, my OneNote crashes (multiple times, until things eventually become stable again) when I search my notebooks  from the upper right search box. Specifically, as soon as I hover my mouse over the search results display.
  2. My environment: OneNote 2013 32-bit on Windows 7 64-bit. These are notebooks on a network share, and they are updated from multiple machines. Not aware of any recent changes to my mouse settings or drivers.
  3. My Workaround: Navigate the search results using the keyboard. This seems to prevent those crashes.

Yet another couple of glitches solved in setting up Outlook 2013 with Gmail IMAP for GoogleApps

  1. I googled and followed this useful guide. However, a couple of glitches remained:
  2. Connection to Incoming mail server fails if you really just put your username:
    1. put instead of  username@companygoogledomain.com:
    2. image
  3. Test send of email message through outgoing server fails if you just followed instructions:
    1. image
    2. Click on button: “More” / tab: “Outgoing Server” / do check box “My outgoing server requires authentication ”  and log on (I now prefer to be explicit, after the initial mixup of usernames for incoming and outgoing), enter your full user@compgoogledomain.com and password. No need to enable SPA, though.
    3. image
  4. Viola  image Smile(and quousque tandem…, sigh Sad smile).

A little addendum about data types to the +N(“comment”) in-cell formula comment trick in Excel

    1. You are relying with this well-documented trick on the fact that addition of 0 will altering a numeric value.
    2. However, what is not mentioned: not all work in Excel involves the number data type.
      1. Try adding your comment or zero to a string data type, and you will get a #VALUE error.
      2. Boolean, however, works also, since – as you can see when you have Excel evaluate your formula – if  you try adding 0 to a Boolean data type, Excel casts the prior Boolean FALSE to 0 or TRUE to 1, and casts the result of your addition (of 0 = nothing) back to the same initial Boolean for further evaluation. excel-evaluate-fromula-w-n-comment boolean
      3. So just put your +N()-comments in those part of your formula that involve either number or Boolean data type, and avoid adding to strings, for example:

=IF(
    OR(
        ISBLANK(
            [Related issues]
        ),
        (            ISERR(
                FIND(
                    #,
                    [Related issues]
                )
            ) )
    ) +
    N(
        do nothing if no related task in col:related issues
    ),
    ,
    IF(
        NOT(
            ISERR(
                FIND(
                    ,,
                    [Related issues]
                )
            )
        ) +
        N(
            do nothing if no 2nd value in col:related issues
        ),
        CONCATENATE(
            MID(
                MID(
                    [Related issues],
                    FIND(
                        ,,
                        [Related issues]
                    ) + 2,
                    LEN(
                        [Related issues]
                    ) 
                    FIND(
                        ,,
                        [Related issues]
                    ) + 1 +
                    N(
                        extracted the 2nd value from col:related issues
                    )
                ),
                FIND(
                    #,
                    MID(
                        [Related issues],
                        FIND(
                            ,,
                            [Related issues]
                        ) + 2,
                        LEN(
                            [Related issues]
                        ) 
                        FIND(
                            ,,
                            [Related issues]
                        ) + 1
                    )
                ) + 1,
                4
            ) +
            N(
                extracted the 4# of id of related issue
            ),
            MID(
                MID(
                    [Relatedissues],
                    FIND(
                        ,,
                        [Relatedissues]
                    ) + 2,
                    LEN(
                        [Relatedissues]
                    ) 
                    FIND(
                        ,,
                        [Relatedissues]
                    ) + 1
                ),
                FIND(
                     ,
                    MID(
                        [Related issues],
                        FIND(
                            ,,
                            [Related issues]
                        ) + 2,
                        LEN(
                            [Related issues]
                        ) 
                        FIND(
                            ,,
                            [Related issues]
                        ) + 1
                    )
                ) + 1,
                2 +
                N(
                    appended to or from to the 4# of id of related issue
                )
            )
        ),
       
    )
)

    1. This splits, extracts and copies values from a none to multi-value column for better sortability: image

Stop ":Zone.Identifier:$DATA" files from being created…

  1. … by running gpedit.msc as admin and setting "user configuration / administrative templates / windows components/ attachment manager / "Do not preserve zone information in file attachments" to "Enabled         No. "
    1. I observed these files in the drive my virtualbox win 8.shares with the linux host.
    2. The answer is out there , of course,  just not with all the search terms. A more thorough security discussion is also available.
    3. Just seems not applicable to a share what virtualbox makes appear as a network folder to Windows while it really is not, which causes also other misleading security warnings also : image