Advertisement Β· 728 Γ— 90

Posts by Lars Breddemann

That might collide with "investor ROI first".

1 month ago 2 0 0 0
Data Organization in Spreadsheets
Karl W. Broman
& Kara H. Woo
Pages 2-10 | Received 01 Jun 2017, Accepted author version posted online: 29 Sep 2017, Published online: 24 Apr 2018

    1. Introduction
    2. Be Consistent
    3. Choose Good Names for Things
    4. Write Dates as YYYY-MM-DD
    5. No Empty Cells
    6. Put Just One Thing in a Cell
    7. Make it a Rectangle
    8. Create a Data Dictionary
    9. No Calculations in the Raw Data Files
    10. Do Not Use Font Color or Highlighting as Data
    11. Make Backups
    12. Use Data Validation to Avoid Errors
    13. Save the Data in Plain Text Files

ABSTRACT

Spreadsheets are widely used software tools for data entry, storage, analysis, and visualization. Focusing on the data entry and storage aspects, this article offers practical recommendations for organizing spreadsheet data to reduce errors and ease later analyses. The basic principles are: be consistent, write dates like YYYY-MM-DD, do not leave any cells empty, put just one thing in a cell, organize the data as a single rectangle (with subjects as rows and variables as columns, and with a single header row), create a data dictionary, do not include calculations in the raw data files, do not use font color or highlighting as data, choose good names for things, make backups, use data validation to avoid data entry errors, and save the data in plain text files.

Data Organization in Spreadsheets Karl W. Broman & Kara H. Woo Pages 2-10 | Received 01 Jun 2017, Accepted author version posted online: 29 Sep 2017, Published online: 24 Apr 2018 1. Introduction 2. Be Consistent 3. Choose Good Names for Things 4. Write Dates as YYYY-MM-DD 5. No Empty Cells 6. Put Just One Thing in a Cell 7. Make it a Rectangle 8. Create a Data Dictionary 9. No Calculations in the Raw Data Files 10. Do Not Use Font Color or Highlighting as Data 11. Make Backups 12. Use Data Validation to Avoid Errors 13. Save the Data in Plain Text Files ABSTRACT Spreadsheets are widely used software tools for data entry, storage, analysis, and visualization. Focusing on the data entry and storage aspects, this article offers practical recommendations for organizing spreadsheet data to reduce errors and ease later analyses. The basic principles are: be consistent, write dates like YYYY-MM-DD, do not leave any cells empty, put just one thing in a cell, organize the data as a single rectangle (with subjects as rows and variables as columns, and with a single header row), create a data dictionary, do not include calculations in the raw data files, do not use font color or highlighting as data, choose good names for things, make backups, use data validation to avoid data entry errors, and save the data in plain text files.

Every day is a good day for sharing one of the most useful papers about research data ever written. PLEASE get your people to understand and follow this advice.

www.tandfonline.com/doi/full/10....

1 month ago 1050 402 31 47
Preview
Sign the Petition Stop the Proposed Trump Tower Development on the Gold Coast

Sign the petition to stop Trump Tower from being built on the Gold Coast

www.change.org/p/stop-the-p...

1 month ago 0 1 0 0
Post image

Just your regularly scheduled share of this masterpiece by @tomgauld.bsky.social

1 month ago 10783 2968 110 93
Preview
Aussie urged to claim $475 million payout with deadline days away Hundreds of thousands of Aussies will lose out on compensation of between $1,000 and $50,000 if they miss this deadline.

Australians impacted by Robodebt have until 4pm on Friday, March 6, to register for a new class action settlement with payouts between $1,000 and $50,000 au.finance.yahoo.com/news/centrel...

1 month ago 127 175 3 6
Preview
Classicals.de - Royalty Free Classical Music Classicals.de: Your library of royalty free classical music. Download high-quality recordings, MP3s, sheet music, and more. All newly recorded.

This is an awesome page for anyone interested in classical music.

www.classicals.de

#classicalmusic #publicdomain #free #creativecommons

1 month ago 1 0 0 0
[SOT213] If your SQL reads like Assembler you're doing it all wrong.
[SOT213] If your SQL reads like Assembler you're doing it all wrong. YouTube video by SAP Online Track

The biggest "Aha!" for me was probably learning how to structure a SQL query, so that it makes sense with regards to the question asked.
CTEs are a great tool for that as well as table-valued functions.
Examples for that youtu.be/iJAQ8lA3DbI?... shorturl.at/hk0BN from way back.

1 month ago 3 0 1 0

About using SQL features rarely covered in trainings for creating data out of nothing and controlling how long it will take.

New blog post out:
lbreddemann.org/advanced-dat...

#tableau #SQL #PostgreSQL

3 months ago 0 0 0 1
Advertisement
Preview
Size of Life From an amoeba to a blue whale

and the winner of the "2025 best thing on Internet" has just arrived
neal.fun/size-of-life/

@carlbergstrom.com

3 months ago 137 56 1 6

Three small wins with fixing failing modern life stuff.

Read about reading data from unmountable SSDs, changing solenoid valves, and repairing window vacuums.

New blog post out (nothing about data or analytics this time).
lbreddemann.org/three-small-...

4 months ago 1 0 0 0

Is that a young Susan Sarandon in on the King of Gypsies page?

4 months ago 0 0 1 0
Preview
Who wants to kill a billionaire?: When the whole world … Discover and share books you love on Goodreads.

This was an entertaining read from a fellow Melbournite.

This debut novel combines an intriguing setup with quick pacing and suspense.

Who wants to kill a billionaire?

www.goodreads.com/book/show/23...

4 months ago 2 0 0 0

New blog post:

Tableau Loops

lbreddemann.org/tableau-loops/

4 months ago 1 0 0 0

Could that be used to establish a specific base type for the array? And would the max. cardinality remain when used with set operations (union)?
Or could that be used as a test of β€œemptiness” for other arrays?

5 months ago 0 0 1 0

This picture misses the point. This isn't how anyone experiences becoming a developer - at least I hope they don't.
Where's the early awe of "making the computer do what I want" and the delight of seing great architecture in process?
It's like a box of crayons without and idea for a picture.

5 months ago 2 0 1 0
Advertisement

Captain Future - The Comet

9 months ago 1 0 0 0
Post image
9 months ago 1 0 1 0

Nope.

10 months ago 1 0 0 0

It's pretty clear that the "community" party moved on.
SAP is not home for their own user/dev community (and hasn't been for a long time).

Like a restaurant that was "the place" once SCN is now just a shadow of what it used to be.
Even if there's no new "the place" yet, you'd not return to it.

11 months ago 1 0 1 0

This reads as if there was ongoing internal training/education on how to use newish products in β€œthe real world”. What consulting org would do something expensive like that?

1 year ago 0 0 1 0

Thanks! My thoughts exactly when I figured this out.

1 year ago 2 0 0 0

New blog post out:

lbreddemann.org/postgresql-d...

1 year ago 5 0 1 0
Advertisement
Post image

Helpful!

1 year ago 65874 14924 770 689
Post image

Your friendly weekly reminder πŸ˜‡ #devrel #hireblag #programming #developers #python #R #ruby #kotlin #java

You can do a lot by liking, commenting, or reposting this 🀩

1 year ago 7 3 0 0