+ Reply to Thread
Results 1 to 2 of 2

A Fresh Perspective on your Spreadsheet

  1. #1
    Forum Contributor
    Join Date
    07-21-2021
    Location
    Norfolk, UK
    MS-Off Ver
    Excel 2003, 2007, 2013, 2019
    Posts
    212

    A Fresh Perspective on your Spreadsheet

    Spreadsheets are employed for a huge range of purposes from shopping lists to multi-dimensional technical analyses. However, at first glance, you cannot tell whether a cell value contributes to a formula, is itself a formula, is empty but will contribute to a formula when completed, looks empty because the formula is designed that way or is, perhaps, simply some helpful text.

    ACBA Mapping is an Excel Add-In designed to map out a spreadsheet with these considerations in mind. It is not intended to replace the auditing functionality that already exists in Excel. Rather it is designed to map out the overall shape of spreadsheet accordingly to the functionality that each cell contributes to the whole.

    However, those shapes can guide you to anomalies within a spreadsheet that deserve further investigation. This is the underlying value of mapping your spreadsheet.

    ACBA Mapping may be downloaded without charge from

    https://drive.google.com/file/d/1maZ...ew?usp=sharing

    For some, this post will be for the second time of reading. There has been a systems glitch and the original appears to have been deleted.
    Regards,

    Stephen

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    80,460

    Re: A Fresh Perspective on your Spreadsheet

    That's very odd - I read it myself the other day!!! Now I can only find this version of it.

    Thank you for sharing this (is what I meant to say the other day, too).
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Index-match with a date perspective
    By trolle in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-03-2017, 03:38 PM
  2. Fresh Prospective
    By Richardswaim in forum Excel Programming / VBA / Macros
    Replies: 28
    Last Post: 06-16-2016, 01:04 PM
  3. New (Old) Fresh Fish
    By bjp11scot in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 03-20-2014, 08:05 PM
  4. dope boy fresh
    By psychoflower in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 11-12-2013, 10:56 PM
  5. What a Breath of Fresh Air!
    By sbarron1 in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 10-11-2013, 08:30 PM
  6. Copy the whole row into their perspective company
    By bri7697 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-27-2013, 05:01 PM
  7. fresh learner need help!
    By Flamingo in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-11-2006, 11:15 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1