Wraps

Note: This page has been replaced. Please continue to the updated and extended help page at https://help.excelwraps.com/support/online-help/introduction-to-wraps/

Wraps are web apps available on your ExcelWraps site and their purpose is to gather data into the cloud database. Wraps are created using MS Excel and XLW; our add-in software. Wraps mirror the functionality of the spreadsheet including any calculations and charts. As wraps are connected to the internet their capability extends beyond Excel and will match the functionality seen in the most up to date Phone and tablet Apps. A wrap is analogous to an Excel template and a wrap instance is analogous to an Excel file created from a template and saved.

1. Wrap - Excel converted to Web App. Excel cell names are preserved in the web app.
2. Wrap instances - Wrap used many times and each use is identified by the wrap unique key combination.
3. Database - Wrap instance data is saved using the unique key combination and the cell names.
4. MyWraps – pulls all results from database using cell names.

Wrap Performance Tips - Let's run through what wraps do. We have to send it from the WrapSite (it being HTML, CSS and javascript to run the calculation process on the client device). The cloud database also has to send out stored cell values within the wrap and data being extracted using WrapLink. We keep the WrapSite in tip top condition but  internet speed has a bearing as does the speed of your network. An old device will never be able to load up and run javascript faster that the very latest devices. If you have designed your wrap to pull a massive amount of data from the server this will put load on the server and generate loads of information to be transmitted. So many things effect the speed of wrap but as a general rule any wrap taking longer than 2 seconds to load will be an irritation to your users. We'll be happy to advise how to keep your wraps fast.

Wrap Buttons

 Expand the tab view. This is useful for viewing (or printing) information held on each tab. 

 Save wrap instance data to database.

 Delete wrap instance. 

 Wrap instance navigation buttons (first, previous, ID number, next, last and new wrap instance).

Your wrap will look like the original spreadsheet (however some compromise occurs as HTML tables don't follow exactly the same specification as Excel). We believe we get a pretty good match. It is possible to fully debug inside Excel before conversion to wrap so your wrap will function just as your spreadsheet does.

Excel File Names becomes the wrap name. It worth using a systematic naming structure for wraps in your organisation so that they are easy to find in the future. The Excel file name should be made up of ASCII characters (letters and numbers) with no spaces.

Excel Templates for wraps should be created. Use of templates helps maintain a consistency in style and layout across the organisation. An A4 layout generates wraps well suited for PC and tablets and the wrap's zoom functionality makes them reasonably accessible on Smartphones (if you are targeting solely Smartphones an A5 layout should be used).

EXCEL FUNCTIONS - We support all Excel functions: ABS, ACCRINT, ACOS, ACOSH, AND, ASC, ASIN, ASINH, ATAN, ATAN2, ATANH, AVEDEV, AVERAGE, AVERAGEA, BESSELY, BETADIST, BIN2DEC, BIN2HEX, BIN2OCT, BINOMDIST, CEILING, CHAR, CHIDIST, CHIINV, CHOOSE, CLEAN, CODE, COLUMN, COLUMNS, COMBIN, CONCATENATE, CONFIDENCE, CORREL, COS, COSH, COUNT, COUNTA, COUNTIF, COVAR, CUMIPMT, CUMPRINC, DATE, DATEDIF, DATEVALUE, DAY, DAYS360, DB, DDB, DEC2BIN, DEC2HEX, DEC2OCT, DEGREES, DELTA, DISC, DOLLAR, DOLLARDE, DOLLARFR, EDATE, EFFECT, EOMONTH, ERF, ERFC, EVEN, EXACT, EXP, FACT, FALSE, FDIST, FIND, FINV, FISHER, FISHERINV, FIXED, FLOOR, FORECAST, FTEST, FV, FVSCHEDULE, GAMMALN, HEX2BIN, HEX2DEC, HEX2OCT, HLOOKUP, HOUR, HYPERLINK, HYPGEOMDIST, IF, IFERROR, INDEX, INT, INTERCEPT, INTRATE, IPMT, IRR, ISBLANK, ISERR, ISERROR, ISEVEN, ISLOGICAL, ISNA, ISNONTEXT, ISNUMBER, ISODD, ISPMT, ISREF, ISTEXT, LARGE, LEFT, LEN, LN, LOG, LOG10, LOGINV, LOGNORMDIST, LOOKUP, LOWER, MATCH, MAX, MID, MIN, MINUTE, MIRR, MOD, MONTH, MROUND, N, NA, NEGBINOMDIST, NETWORKDAYS, NOMINAL, NORMDIST, NORMINV, NORMSDIST, NORMSINV, NOT, NOW, NPER, NPV, OCT2BIN, OCT2DEC, OCT2HEX, ODD, OR, PEARSON, PERCENTILE, PERCENTRANK, PERMUT, PI, PMT, POISSON, POWER, PPMT, PRICEDISC, PRODUCT, PROPER, PV, QUARTILE, QUOTIENT, RADIANS, RAND, RANDBETWEEN, RANK, RATE, REPLACE, REPT, RIGHT, ROMAN, ROUND, ROUNDDOWN, ROUNDUP, ROW, ROWS, RSQ, SEARCH, SECOND, SIGN, SIN, SINH, SLN, SLOPE, SMALL, SQRT, STANDARDIZE, STDEV, STDEVA, STDEVP, STDEVPA, SUBSTITUTE, SUBTOTAL, SUM, SUMIF, SUMPRODUCT, SUMSQ, SUMX2MY2, SUMX2PY2, SUMXMY2, SYD, T, TAN, TANH, TEXT, TIME, TIMEVALUE, TODAY, TRIM, TRIMMEAN, TRUE, TRUNC, UPPER, VALUE, VAR, VARA, VARP, VARPA, VLOOKUP, WEEKDAY, WEIBULL, WORKDAY, XIRR, XNPV and YEAR. Custom functions are also supported but will require the assistance of MoreVision Administrators for custom conversion. 

Excel Cell Names are required for all input cells and they are encouraged for calculated cells. Values are located in the database using the unique key combination (or Wrap ID) and the spreadsheet cell name. Naming calculated cells is a good idea particularly for use with MyWraps reports; please note XLW's 'Map to Names' productivity tool. Also note XLW's 'Validate Wrap' button which gives you an option to automatically name any unnamed input cells (WrapInp1, WrapInp2...). Only named input cells and named calculated cells are named in the wrap a cell named in Excel containing a static value is not available in the wrap.

Excel Conditional Formatting is supported but some specific features of conditional formatting are currently unsupported: Above/Below standard deviation, Color Scale with more than 2 criteria, Inside 2 colors scale, we only support Highest to Lowest type, Duplicate/Unique, Top/Bottom n percent and any conditional formatting that depends on formulas.

Excel Charts are converted to HTML charts and whilst functionally they are the same there will be slight variation in appearance. Some Excel functionality is not supported (e.g. data labels). Please keep charts as simple as possible.

Excel Sheet Size must be less than 1000 rows.

Excel Cell Borders - We do support cell borders but differences between Excel's border model and HTML table cell border model can give some unexpected line thickness issues and may be a little frustrating. To work around this XLW has introduced its own border controls on the toolbar to achieve a consistent view in Excel and the wrap. Note: wraps always have thin borders and Excel's line thickness is ignored, this avoids complications between Excel borders and HTML borders. 

Excel Floating Point Arithmetic Issues Wraps are web applications and completely independent of its Excel source file. Floating-point numbers are represented in computer hardware as base 2 (binary) fractions. For example, the decimal fraction 0.125 has value 1/10 + 2/100 + 5/1000, and in the same way the binary fraction 0.001 has value 0/2 + 0/4 + 1/8. These two fractions have identical values, the only real difference being that the first is written in base 10 fractional notation, and the second in base 2. Unfortunately, most decimal fractions cannot be represented exactly as binary fractions. A consequence is that, in general, the decimal floating-point numbers you enter are only approximated by the binary floating-point numbers actually stored in the machine. Microsoft Excel works only to limited accuracy because it retains only a certain number of figures to describe numbers (it has limited precision). Excel nominally works with 15 bits of precision and calculations may have an accuracy that is even less due to three issues: round off, truncation, and binary storage. Wrap work to 53 bits of binary precision and its number representation is more accurate. So on very rare occasions your wrap calculation may not behave as Excel. MoreVision have only encountered the problem once in may many thousands of Wrap conversions. On this occasion 7.4 - 6.95 was the calculation being performed and if the result is less than or equal to 0.45 which we expect to satisfy however the representation of the 0.45 was actually 0.4500000000000000000001 and so did not satisfy our inequality. We used rounding functions as a workaround. Chip Pearson covers this subject very well.

Rules for Hiding - In Excel you can hide rows and columns however there are some rules you need to observe when creating wraps:

1) Only calculations can be in Excel hidden rows or columns.
2) All XLW controls must never be in Excel hidden rows or columns they must always be visible in Excel before wrap conversion.
3) XLW Controls can only be hidden from view in the wrap using rowhide or rowshow widgets or tab hide widgets but they must be visible in Excel before wrap conversion.
4) Some XLW controls are made hidden like signoff enabling cells but they must be visible in Excel before wrap conversion.
5) Holder cells can be optionally made visible but they must be visible in Excel before wrap conversion.