OK: How a 19th-Century Joke Became the World’s Most Used Word
"OK" started as a joke abbreviation for "oll korrect" in 1830s Boston newspapers and was saved from fading away by a presidential campaign. The…
Read article →Atul Vij
What to Automate First: Picking Office Tasks That Are Worth It
What to Automate First: Picking Office Tasks That Are Worth It
A simple way to decide which repetitive task to automate first: frequency, time, error cost and stability — with a scoring sheet and examples…
Read article →N Function in Excel: Turn a Value Into a Number
N Function in Excel: Turn a Value Into a Number
N returns numbers unchanged, TRUE as 1 and text as 0. Its oddest use is hiding a note inside a formula.
Read article →EPM Automate: Script Your Oracle EPM Cloud Month-End Tasks
EPM Automate: Script Your Oracle EPM Cloud Month-End Tasks
Use Oracle's EPM Automate command-line tool to log in, upload files, run data rules and business rules, refresh the cube and export data —…
Read article →Smart View Lesson 6: Building a Refreshable Report Template
Smart View Lesson 6: Building a Refreshable Report Template
Combine everything into a monthly report: parameter cells for period and entity, ad hoc or function grids, preserved formatting, multiple sheets refresh, and VBA…
Read article →DVAR Function in Excel: Sample Variance of Matching Records
DVAR Function in Excel: Sample Variance of Matching Records
DVAR returns the sample variance for matching records. Like all D-functions it uses a database range and a criteria range you can edit on…
Read article →IMABS Function in Excel: Size (Modulus) of a Complex Number
IMABS Function in Excel: Size (Modulus) of a Complex Number
IMABS returns |z|, the length of the vector: SQRT(a²+b²). For impedance it's the magnitude in ohms. Complex numbers are text like 3+4i; build them…
Read article →Smart View Functions: Build Cell-Based Reports with HsGetValue
Smart View Functions: Build Cell-Based Reports with HsGetValue
Use Oracle Smart View functions such as HsGetValue to pull single numbers from Essbase or EPM into any Excel layout — syntax, POV defaults,…
Read article →Combine Data From Multiple Sheets Into One in Excel (VSTACK, FILTER)
Combine Data From Multiple Sheets Into One in Excel (VSTACK, FILTER)
Stack monthly or branch sheets into one live list with VSTACK and 3D references, drop blank rows with FILTER, tag each row with its…
Read article →Why QWERTY? The Real Story of the Keyboard Layout
Why QWERTY? The Real Story of the Keyboard Layout
Why the letters on your keyboard are in such a strange order: typewriter jams, telegraph operators, a famous patent and why nobody switched even…
Read article →Essbase Calc Scripts: FIX…ENDFIX Explained with Examples
Essbase Calc Scripts: FIX…ENDFIX Explained with Examples
Learn how FIX…ENDFIX focuses an Essbase calculation on a slice of the cube, with examples for aggregation, allocation, clearing data and copying scenarios —…
Read article →Refresh Oracle Smart View Sheets Automatically with VBA
Refresh Oracle Smart View Sheets Automatically with VBA
Use the Smart View VBA functions HypConnect, HypRetrieve and HypDisconnect to refresh every Essbase/EPM sheet in a workbook with one click.
Read article →