• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Search results

  1. W

    Formatting Excel Spreadsheets as APA Tables

    All, I am looking for a method to convert an Excel spreadsheet into an APA formatted table. I have searched the Internet for this and cannot find any resources that explain how to do this step-by-step. Any assistance is great appreciated. Thanks all!
  2. W

    Assistance reformatting text in a cell

    I have multiple rows of text that are mostly two word entries. For example, some of the entries are: Blue House Red House Green House I need to reformat the text for another application so that each entry appears with an underscore between the words. For example: Blue_House Red_House...
  3. W

    Assign a binary value to a list based on a given percentage

    Say I have a list of items, similar to what is below: cat cat cat cat dog dog dog dog Given a cell where the user can input a value which represents what percentage of "cat" in the list should be assigned a one value, how would I assign "one" based on the percentage entered, then a...
  4. W

    Create a Normal Distribution of Textual Data

    I have a text list of 27 items. I want to simulate a normal distribution of the list with 2000 samples. Once the list has been simulated, I would like to assign a value of zero or one to each item, based on how often it occurs. Any help would be greatly appreciated! Thanks!
  5. W

    Leaky Bucket problem in Excel

    I am an Excel newbie, so please indulge me. :) I am trying to figure out how to make Excel perform "Leaky Bucket" calculations for me. For example, lets say we have a disk drive (Disk Drive A) that has an I/O speed of 200 MB/s. Let us say that this disk drive writes to another disk drive...
Back
Top