{"text_format":"3","workbook":"xlsx","n_sheets":39,"sheets":["Home Page","Blank Sheet","Section 2 Notes","Section 3 Notes","Hyperlinks","Outline","Scenario","Scenario Summary","Sorting","Series & Custom Lists","Naming Cells","Auto Filter","Advanced Filter","Advanced Filter Unique Records","Section 4 Notes","Section 5 Notes","Chart","Chart Area","Chart Objects Added","Chart Lower Neg Line","Trendline","Gantt Chart","House","Conditional Formatting","Dates and Times","Range Union Intersection 3D","IF Statements","Lookup","Mathematical Functions","Statistical Functions","Text Functions","Financial Functions","Database Functions","Section 6 Notes ","Trace Errors","Section 7 Notes","Data Validation","Protect Cells in a Worksheet","References"],"not_rendered":{"charts":5,"images":23,"macros":1,"external_links":1,"defined_names":16,"comments":5},"read":"whole","date_system":"1900"}

{"sheet":"Home Page","index":0,"n_rows":4,"n_cols":4,"rows_kept":4,"merged":[[2,3,2,7],[3,3,3,7]]}
[]
[]
[{"$nulls":3},"Level 6 Spreadsheet 6N4089"]
[{"$nulls":3},"Home Page"]

{"sheet":"Blank Sheet","index":1,"n_rows":5,"n_cols":5,"rows_kept":5,"merged":[[4,0,4,1]]}
[]
[null,null,"Enter Title"]
[]
[]
["Arguments ",null,"Explaination","Forumla or Function","Function Name"]

{"sheet":"Section 2 Notes","index":2,"n_rows":7,"n_cols":4,"rows_kept":7,"merged":[[2,3,2,8],[3,3,3,8]]}
[]
[]
[{"$nulls":3},"Level 6 Spreadsheet 6N4089"]
[{"$nulls":3},"Section 2 – Customisation and Printing"]
[]
[]
[{"$nulls":3},"To be used in conjunction with Section 2 Notes"]

{"sheet":"Section 3 Notes","index":3,"n_rows":7,"n_cols":4,"rows_kept":7,"merged":[[2,3,2,8],[3,3,3,8]]}
[]
[]
[{"$nulls":3},"Level 6 Spreadsheet 6N4089"]
[{"$nulls":3},"Section 3 – Worksheet Features"]
[]
[]
[{"$nulls":3},"To be used in conjunction with Section 3 Notes"]

{"sheet":"Hyperlinks","index":4,"n_rows":23,"n_cols":5,"rows_kept":23,"merged":[[4,0,4,1],[4,2,4,3],[4,4,4,5],[4,6,4,7],[4,8,4,9],[4,10,4,11],[4,12,4,13],[4,14,4,15],[4,16,4,17],[4,18,4,19],[4,20,4,21],[4,22,4,23],[4,24,4,25],[4,26,4,27],[4,28,4,29],[4,30,4,31],[4,32,4,33],[4,34,4,35],[4,36,4,37],[4,38,4,39],[4,40,4,41],[4,42,4,43],[4,44,4,45],[4,46,4,47],[4,48,4,49],[4,50,4,51],[4,52,4,53],[4,54,4,55],[4,56,4,57],[4,58,4,59],[4,60,4,61],[4,62,4,63],[4,64,4,65],[4,66,4,67],[4,68,4,69],[4,70,4,71],[4,72,4,73],[4,74,4,75],[4,76,4,77],[4,78,4,79],[4,80,4,81],[4,82,4,83],[4,84,4,85],[4,86,4,87],[4,88,4,89],[4,90,4,91],[4,92,4,93],[4,94,4,95],[4,96,4,97],[4,98,4,99],[4,100,4,101],[4,102,4,103],[4,104,4,105],[4,106,4,107],[4,108,4,109],[4,110,4,111],[4,112,4,113],[4,114,4,115],[4,116,4,117],[4,118,4,119],[4,120,4,121],[4,122,4,123],[4,124,4,125],[4,126,4,127],[4,128,4,129],[4,130,4,131],[4,132,4,133],[4,134,4,135],[4,136,4,137],[4,138,4,139],[4,140,4,141],[4,142,4,143],[4,144,4,145],[4,146,4,147],[4,148,4,149],[4,150,4,151],[4,152,4,153],[4,154,4,155],[4,156,4,157],[4,158,4,159],[4,160,4,161],[4,162,4,163],[4,164,4,165],[4,166,4,167],[4,168,4,169],[4,170,4,171],[4,172,4,173],[4,174,4,175],[4,176,4,177],[4,178,4,179],[4,180,4,181],[4,182,4,183],[4,184,4,185],[4,186,4,187],[4,188,4,189],[4,190,4,191],[4,192,4,193],[4,194,4,195],[4,196,4,197],[4,198,4,199],[4,200,4,201],[4,202,4,203],[4,204,4,205],[4,206,4,207],[4,208,4,209],[4,210,4,211],[4,212,4,213],[4,214,4,215],[4,216,4,217],[4,218,4,219],[4,220,4,221],[4,222,4,223],[4,224,4,225],[4,226,4,227],[4,228,4,229],[4,230,4,231],[4,232,4,233],[4,234,4,235],[4,236,4,237],[4,238,4,239],[4,240,4,241],[4,242,4,243],[4,244,4,245],[4,246,4,247],[4,248,4,249],[4,250,4,251],[4,252,4,253],[4,254,4,255],[4,256,4,257],[4,258,4,259],[4,260,4,261],[4,262,4,263],[4,264,4,265],[4,266,4,267],[4,268,4,269],[4,270,4,271],[4,272,4,273],[4,274,4,275],[4,276,4,277],[4,278,4,279],[4,280,4,281],[4,282,4,283],[4,284,4,285],[4,286,4,287],[4,288,4,289],[4,290,4,291],[4,292,4,293],[4,294,4,295],[4,296,4,297],[4,298,4,299],[4,300,4,301],[4,302,4,303],[4,304,4,305],[4,306,4,307],[4,308,4,309],[4,310,4,311],[4,312,4,313],[4,314,4,315],[4,316,4,317],[4,318,4,319],[4,320,4,321],[4,322,4,323],[4,324,4,325],[4,326,4,327],[4,328,4,329],[4,330,4,331],[4,332,4,333],[4,334,4,335],[4,336,4,337],[4,338,4,339],[4,340,4,341],[4,342,4,343],[4,344,4,345],[4,346,4,347],[4,348,4,349],[4,350,4,351],[4,352,4,353],[4,354,4,355],[4,356,4,357],[4,358,4,359],[4,360,4,361],[4,362,4,363],[4,364,4,365],[4,366,4,367],[4,368,4,369],[4,370,4,371],[4,372,4,373],[4,374,4,375],[4,376,4,377],[4,378,4,379],[4,380,4,381],[4,382,4,383],[4,384,4,385],[4,386,4,387],[4,388,4,389],[4,390,4,391],[4,392,4,393],[4,394,4,395],[4,396,4,397],[4,398,4,399],[4,400,4,401],[4,402,4,403],[4,404,4,405],[4,406,4,407],[4,408,4,409],[4,410,4,411],[4,412,4,413],[4,414,4,415],[4,416,4,417],[4,418,4,419],[4,420,4,421],[4,422,4,423],[4,424,4,425],[4,426,4,427],[4,428,4,429],[4,430,4,431],[4,432,4,433],[4,434,4,435],[4,436,4,437],[4,438,4,439],[4,440,4,441],[4,442,4,443],[4,444,4,445],[4,446,4,447],[4,448,4,449],[4,450,4,451],[4,452,4,453],[4,454,4,455],[4,456,4,457],[4,458,4,459],[4,460,4,461],[4,462,4,463],[4,464,4,465],[4,466,4,467],[4,468,4,469],[4,470,4,471],[4,472,4,473],[4,474,4,475],[4,476,4,477],[4,478,4,479],[4,480,4,481],[4,482,4,483],[4,484,4,485],[4,486,4,487],[4,488,4,489],[4,490,4,491],[4,492,4,493],[4,494,4,495],[4,496,4,497],[4,498,4,499],[4,500,4,501],[4,502,4,503],[4,504,4,505],[4,506,4,507],[4,508,4,509],[4,510,4,511],[4,512,4,513],[4,514,4,515],[4,516,4,517],[4,518,4,519],[4,520,4,521],[4,522,4,523],[4,524,4,525],[4,526,4,527],[4,528,4,529],[4,530,4,531],[4,532,4,533],[4,534,4,535],[4,536,4,537],[4,538,4,539],[4,540,4,541],[4,542,4,543],[4,544,4,545],[4,546,4,547],[4,548,4,549],[4,550,4,551],[4,552,4,553],[4,554,4,555],[4,556,4,557],[4,558,4,559],[4,560,4,561],[4,562,4,563],[4,564,4,565],[4,566,4,567],[4,568,4,569],[4,570,4,571],[4,572,4,573],[4,574,4,575],[4,576,4,577],[4,578,4,579],[4,580,4,581],[4,582,4,583],[4,584,4,585],[4,586,4,587],[4,588,4,589],[4,590,4,591],[4,592,4,593],[4,594,4,595],[4,596,4,597],[4,598,4,599],[4,600,4,601],[4,602,4,603],[4,604,4,605],[4,606,4,607],[4,608,4,609],[4,610,4,611],[4,612,4,613],[4,614,4,615],[4,616,4,617],[4,618,4,619],[4,620,4,621],[4,622,4,623],[4,624,4,625],[4,626,4,627],[4,628,4,629],[4,630,4,631],[4,632,4,633],[4,634,4,635],[4,636,4,637],[4,638,4,639],[4,640,4,641],[4,642,4,643],[4,644,4,645],[4,646,4,647],[4,648,4,649],[4,650,4,651],[4,652,4,653],[4,654,4,655],[4,656,4,657],[4,658,4,659],[4,660,4,661],[4,662,4,663],[4,664,4,665],[4,666,4,667],[4,668,4,669],[4,670,4,671],[4,672,4,673],[4,674,4,675],[4,676,4,677],[4,678,4,679],[4,680,4,681],[4,682,4,683],[4,684,4,685],[4,686,4,687],[4,688,4,689],[4,690,4,691],[4,692,4,693],[4,694,4,695],[4,696,4,697],[4,698,4,699],[4,700,4,701],[4,702,4,703],[4,704,4,705],[4,706,4,707],[4,708,4,709],[4,710,4,711],[4,712,4,713],[4,714,4,715],[4,716,4,717],[4,718,4,719],[4,720,4,721],[4,722,4,723],[4,724,4,725],[4,726,4,727],[4,728,4,729],[4,730,4,731],[4,732,4,733],[4,734,4,735],[4,736,4,737],[4,738,4,739],[4,740,4,741],[4,742,4,743],[4,744,4,745],[4,746,4,747],[4,748,4,749],[4,750,4,751],[4,752,4,753],[4,754,4,755],[4,756,4,757],[4,758,4,759],[4,760,4,761],[4,762,4,763],[4,764,4,765],[4,766,4,767],[4,768,4,769],[4,770,4,771],[4,772,4,773],[4,774,4,775],[4,776,4,777],[4,778,4,779],[4,780,4,781],[4,782,4,783],[4,784,4,785],[4,786,4,787],[4,788,4,789],[4,790,4,791],[4,792,4,793],[4,794,4,795],[4,796,4,797],[4,798,4,799],[4,800,4,801],[4,802,4,803],[4,804,4,805],[4,806,4,807],[4,808,4,809],[4,810,4,811],[4,812,4,813],[4,814,4,815],[4,816,4,817],[4,818,4,819],[4,820,4,821],[4,822,4,823],[4,824,4,825],[4,826,4,827],[4,828,4,829],[4,830,4,831],[4,832,4,833],[4,834,4,835],[4,836,4,837],[4,838,4,839],[4,840,4,841],[4,842,4,843],[4,844,4,845],[4,846,4,847],[4,848,4,849],[4,850,4,851],[4,852,4,853],[4,854,4,855],[4,856,4,857],[4,858,4,859],[4,860,4,861],[4,862,4,863],[4,864,4,865],[4,866,4,867],[4,868,4,869],[4,870,4,871],[4,872,4,873],[4,874,4,875],[4,876,4,877],[4,878,4,879],[4,880,4,881],[4,882,4,883],[4,884,4,885],[4,886,4,887],[4,888,4,889],[4,890,4,891],[4,892,4,893],[4,894,4,895],[4,896,4,897],[4,898,4,899],[4,900,4,901],[4,902,4,903],[4,904,4,905],[4,906,4,907],[4,908,4,909],[4,910,4,911],[4,912,4,913],[4,914,4,915],[4,916,4,917],[4,918,4,919],[4,920,4,921],[4,922,4,923],[4,924,4,925],[4,926,4,927],[4,928,4,929],[4,930,4,931],[4,932,4,933],[4,934,4,935],[4,936,4,937],[4,938,4,939],[4,940,4,941],[4,942,4,943],[4,944,4,945],[4,946,4,947],[4,948,4,949],[4,950,4,951],[4,952,4,953],[4,954,4,955],[4,956,4,957],[4,958,4,959],[4,960,4,961],[4,962,4,963],[4,964,4,965],[4,966,4,967],[4,968,4,969],[4,970,4,971],[4,972,4,973],[4,974,4,975],[4,976,4,977],[4,978,4,979],[4,980,4,981],[4,982,4,983],[4,984,4,985],[4,986,4,987],[4,988,4,989],[4,990,4,991],[4,992,4,993],[4,994,4,995],[4,996,4,997],[4,998,4,999],[4,1000,4,1001],[4,1002,4,1003],[4,1004,4,1005],[4,1006,4,1007],[4,1008,4,1009],[4,1010,4,1011],[4,1012,4,1013],[4,1014,4,1015],[4,1016,4,1017],[4,1018,4,1019],[4,1020,4,1021],[4,1022,4,1023],[4,1024,4,1025],[4,1026,4,1027],[4,1028,4,1029],[4,1030,4,1031],[4,1032,4,1033],[4,1034,4,1035],[4,1036,4,1037],[4,1038,4,1039],[4,1040,4,1041],[4,1042,4,1043],[4,1044,4,1045],[4,1046,4,1047],[4,1048,4,1049],[4,1050,4,1051],[4,1052,4,1053],[4,1054,4,1055],[4,1056,4,1057],[4,1058,4,1059],[4,1060,4,1061],[4,1062,4,1063],[4,1064,4,1065],[4,1066,4,1067],[4,1068,4,1069],[4,1070,4,1071],[4,1072,4,1073],[4,1074,4,1075],[4,1076,4,1077],[4,1078,4,1079],[4,1080,4,1081],[4,1082,4,1083],[4,1084,4,1085],[4,1086,4,1087],[4,1088,4,1089],[4,1090,4,1091],[4,1092,4,1093],[4,1094,4,1095],[4,1096,4,1097],[4,1098,4,1099],[4,1100,4,1101],[4,1102,4,1103],[4,1104,4,1105],[4,1106,4,1107],[4,1108,4,1109],[4,1110,4,1111],[4,1112,4,1113],[4,1114,4,1115],[4,1116,4,1117],[4,1118,4,1119],[4,1120,4,1121],[4,1122,4,1123],[4,1124,4,1125],[4,1126,4,1127],[4,1128,4,1129],[4,1130,4,1131],[4,1132,4,1133],[4,1134,4,1135],[4,1136,4,1137],[4,1138,4,1139],[4,1140,4,1141],[4,1142,4,1143],[4,1144,4,1145],[4,1146,4,1147],[4,1148,4,1149],[4,1150,4,1151],[4,1152,4,1153],[4,1154,4,1155],[4,1156,4,1157],[4,1158,4,1159],[4,1160,4,1161],[4,1162,4,1163],[4,1164,4,1165],[4,1166,4,1167],[4,1168,4,1169],[4,1170,4,1171],[4,1172,4,1173],[4,1174,4,1175],[4,1176,4,1177],[4,1178,4,1179],[4,1180,4,1181],[4,1182,4,1183],[4,1184,4,1185],[4,1186,4,1187],[4,1188,4,1189],[4,1190,4,1191],[4,1192,4,1193],[4,1194,4,1195],[4,1196,4,1197],[4,1198,4,1199],[4,1200,4,1201],[4,1202,4,1203],[4,1204,4,1205],[4,1206,4,1207],[4,1208,4,1209],[4,1210,4,1211],[4,1212,4,1213],[4,1214,4,1215],[4,1216,4,1217],[4,1218,4,1219],[4,1220,4,1221],[4,1222,4,1223],[4,1224,4,1225],[4,1226,4,1227],[4,1228,4,1229],[4,1230,4,1231],[4,1232,4,1233],[4,1234,4,1235],[4,1236,4,1237],[4,1238,4,1239],[4,1240,4,1241],[4,1242,4,1243],[4,1244,4,1245],[4,1246,4,1247],[4,1248,4,1249],[4,1250,4,1251],[4,1252,4,1253],[4,1254,4,1255],[4,1256,4,1257],[4,1258,4,1259],[4,1260,4,1261],[4,1262,4,1263],[4,1264,4,1265],[4,1266,4,1267],[4,1268,4,1269],[4,1270,4,1271],[4,1272,4,1273],[4,1274,4,1275],[4,1276,4,1277],[4,1278,4,1279],[4,1280,4,1281],[4,1282,4,1283],[4,1284,4,1285],[4,1286,4,1287],[4,1288,4,1289],[4,1290,4,1291],[4,1292,4,1293],[4,1294,4,1295],[4,1296,4,1297],[4,1298,4,1299],[4,1300,4,1301],[4,1302,4,1303],[4,1304,4,1305],[4,1306,4,1307],[4,1308,4,1309],[4,1310,4,1311],[4,1312,4,1313],[4,1314,4,1315],[4,1316,4,1317],[4,1318,4,1319],[4,1320,4,1321],[4,1322,4,1323],[4,1324,4,1325],[4,1326,4,1327],[4,1328,4,1329],[4,1330,4,1331],[4,1332,4,1333],[4,1334,4,1335],[4,1336,4,1337],[4,1338,4,1339],[4,1340,4,1341],[4,1342,4,1343],[4,1344,4,1345],[4,1346,4,1347],[4,1348,4,1349],[4,1350,4,1351],[4,1352,4,1353],[4,1354,4,1355],[4,1356,4,1357],[4,1358,4,1359],[4,1360,4,1361],[4,1362,4,1363],[4,1364,4,1365],[4,1366,4,1367],[4,1368,4,1369],[4,1370,4,1371],[4,1372,4,1373],[4,1374,4,1375],[4,1376,4,1377],[4,1378,4,1379],[4,1380,4,1381],[4,1382,4,1383],[4,1384,4,1385],[4,1386,4,1387],[4,1388,4,1389],[4,1390,4,1391],[4,1392,4,1393],[4,1394,4,1395],[4,1396,4,1397],[4,1398,4,1399],[4,1400,4,1401],[4,1402,4,1403],[4,1404,4,1405],[4,1406,4,1407],[4,1408,4,1409],[4,1410,4,1411],[4,1412,4,1413],[4,1414,4,1415],[4,1416,4,1417],[4,1418,4,1419],[4,1420,4,1421],[4,1422,4,1423],[4,1424,4,1425],[4,1426,4,1427],[4,1428,4,1429],[4,1430,4,1431],[4,1432,4,1433],[4,1434,4,1435],[4,1436,4,1437],[4,1438,4,1439],[4,1440,4,1441],[4,1442,4,1443],[4,1444,4,1445],[4,1446,4,1447],[4,1448,4,1449],[4,1450,4,1451],[4,1452,4,1453],[4,1454,4,1455],[4,1456,4,1457],[4,1458,4,1459],[4,1460,4,1461],[4,1462,4,1463],[4,1464,4,1465],[4,1466,4,1467],[4,1468,4,1469],[4,1470,4,1471],[4,1472,4,1473],[4,1474,4,1475],[4,1476,4,1477],[4,1478,4,1479],[4,1480,4,1481],[4,1482,4,1483],[4,1484,4,1485],[4,1486,4,1487],[4,1488,4,1489],[4,1490,4,1491],[4,1492,4,1493],[4,1494,4,1495],[4,1496,4,1497],[4,1498,4,1499],[4,1500,4,1501],[4,1502,4,1503],[4,1504,4,1505],[4,1506,4,1507],[4,1508,4,1509],[4,1510,4,1511],[4,1512,4,1513],[4,1514,4,1515],[4,1516,4,1517],[4,1518,4,1519],[4,1520,4,1521],[4,1522,4,1523],[4,1524,4,1525],[4,1526,4,1527],[4,1528,4,1529],[4,1530,4,1531],[4,1532,4,1533],[4,1534,4,1535],[4,1536,4,1537],[4,1538,4,1539],[4,1540,4,1541],[4,1542,4,1543],[4,1544,4,1545],[4,1546,4,1547],[4,1548,4,1549],[4,1550,4,1551],[4,1552,4,1553],[4,1554,4,1555],[4,1556,4,1557],[4,1558,4,1559],[4,1560,4,1561],[4,1562,4,1563],[4,1564,4,1565],[4,1566,4,1567],[4,1568,4,1569],[4,1570,4,1571],[4,1572,4,1573],[4,1574,4,1575],[4,1576,4,1577],[4,1578,4,1579],[4,1580,4,1581],[4,1582,4,1583],[4,1584,4,1585],[4,1586,4,1587],[4,1588,4,1589],[4,1590,4,1591],[4,1592,4,1593],[4,1594,4,1595],[4,1596,4,1597],[4,1598,4,1599],[4,1600,4,1601],[4,1602,4,1603],[4,1604,4,1605],[4,1606,4,1607],[4,1608,4,1609],[4,1610,4,1611],[4,1612,4,1613],[4,1614,4,1615],[4,1616,4,1617],[4,1618,4,1619],[4,1620,4,1621],[4,1622,4,1623],[4,1624,4,1625],[4,1626,4,1627],[4,1628,4,1629],[4,1630,4,1631],[4,1632,4,1633],[4,1634,4,1635],[4,1636,4,1637],[4,1638,4,1639],[4,1640,4,1641],[4,1642,4,1643],[4,1644,4,1645],[4,1646,4,1647],[4,1648,4,1649],[4,1650,4,1651],[4,1652,4,1653],[4,1654,4,1655],[4,1656,4,1657],[4,1658,4,1659],[4,1660,4,1661],[4,1662,4,1663],[4,1664,4,1665],[4,1666,4,1667],[4,1668,4,1669],[4,1670,4,1671],[4,1672,4,1673],[4,1674,4,1675],[4,1676,4,1677],[4,1678,4,1679],[4,1680,4,1681],[4,1682,4,1683],[4,1684,4,1685],[4,1686,4,1687],[4,1688,4,1689],[4,1690,4,1691],[4,1692,4,1693],[4,1694,4,1695],[4,1696,4,1697],[4,1698,4,1699],[4,1700,4,1701],[4,1702,4,1703],[4,1704,4,1705],[4,1706,4,1707],[4,1708,4,1709],[4,1710,4,1711],[4,1712,4,1713],[4,1714,4,1715],[4,1716,4,1717],[4,1718,4,1719],[4,1720,4,1721],[4,1722,4,1723],[4,1724,4,1725],[4,1726,4,1727],[4,1728,4,1729],[4,1730,4,1731],[4,1732,4,1733],[4,1734,4,1735],[4,1736,4,1737],[4,1738,4,1739],[4,1740,4,1741],[4,1742,4,1743],[4,1744,4,1745],[4,1746,4,1747],[4,1748,4,1749],[4,1750,4,1751],[4,1752,4,1753],[4,1754,4,1755],[4,1756,4,1757],[4,1758,4,1759],[4,1760,4,1761],[4,1762,4,1763],[4,1764,4,1765],[4,1766,4,1767],[4,1768,4,1769],[4,1770,4,1771],[4,1772,4,1773],[4,1774,4,1775],[4,1776,4,1777],[4,1778,4,1779],[4,1780,4,1781],[4,1782,4,1783],[4,1784,4,1785],[4,1786,4,1787],[4,1788,4,1789],[4,1790,4,1791],[4,1792,4,1793],[4,1794,4,1795],[4,1796,4,1797],[4,1798,4,1799],[4,1800,4,1801],[4,1802,4,1803],[4,1804,4,1805],[4,1806,4,1807],[4,1808,4,1809],[4,1810,4,1811],[4,1812,4,1813],[4,1814,4,1815],[4,1816,4,1817],[4,1818,4,1819],[4,1820,4,1821],[4,1822,4,1823],[4,1824,4,1825],[4,1826,4,1827],[4,1828,4,1829],[4,1830,4,1831],[4,1832,4,1833],[4,1834,4,1835],[4,1836,4,1837],[4,1838,4,1839],[4,1840,4,1841],[4,1842,4,1843],[4,1844,4,1845],[4,1846,4,1847],[4,1848,4,1849],[4,1850,4,1851],[4,1852,4,1853],[4,1854,4,1855],[4,1856,4,1857],[4,1858,4,1859],[4,1860,4,1861],[4,1862,4,1863],[4,1864,4,1865],[4,1866,4,1867],[4,1868,4,1869],[4,1870,4,1871],[4,1872,4,1873],[4,1874,4,1875],[4,1876,4,1877],[4,1878,4,1879],[4,1880,4,1881],[4,1882,4,1883],[4,1884,4,1885],[4,1886,4,1887],[4,1888,4,1889],[4,1890,4,1891],[4,1892,4,1893],[4,1894,4,1895],[4,1896,4,1897],[4,1898,4,1899],[4,1900,4,1901],[4,1902,4,1903],[4,1904,4,1905],[4,1906,4,1907],[4,1908,4,1909],[4,1910,4,1911],[4,1912,4,1913],[4,1914,4,1915],[4,1916,4,1917],[4,1918,4,1919],[4,1920,4,1921],[4,1922,4,1923],[4,1924,4,1925],[4,1926,4,1927],[4,1928,4,1929],[4,1930,4,1931],[4,1932,4,1933],[4,1934,4,1935],[4,1936,4,1937],[4,1938,4,1939],[4,1940,4,1941],[4,1942,4,1943],[4,1944,4,1945],[4,1946,4,1947],[4,1948,4,1949],[4,1950,4,1951],[4,1952,4,1953],[4,1954,4,1955],[4,1956,4,1957],[4,1958,4,1959],[4,1960,4,1961],[4,1962,4,1963],[4,1964,4,1965],[4,1966,4,1967],[4,1968,4,1969],[4,1970,4,1971],[4,1972,4,1973],[4,1974,4,1975],[4,1976,4,1977],[4,1978,4,1979],[4,1980,4,1981],[4,1982,4,1983],[4,1984,4,1985],[4,2016,4,2017],[4,2018,4,2019],[4,2020,4,2021],[4,2022,4,2023],[4,2024,4,2025],[6,2,9,2],[12,2,15,2]],"merged_total":8194,"flags":["merged_cut"]}
[]
[null,null,"Hyperlinks"]
[]
[]
["Arguments ",null,"Explaination","Forumla or Function","Function Name"]
[]
["Hyperlinks",null,"Creates a hyperlink to a document or website. Use \"\" around the URL and Friendly name. \nThis can also be used to link to another cell or worksheet within a workbook. ",{"$f":"HYPERLINK(\"E:\\VEC\\6 Level - Advanced Cert in Administration\\6N4089 Spreadsheet Level 6\\6N4089 Spreadsheets\\Section 3 - Worksheet Features\",\"Unit 3\")","v":"Unit 3"},"Hyperlink - to a file"]
[]
[{"$nulls":3},{"$f":"HYPERLINK(\"http://office.microsoft.com/en-ie/excel-help/hyperlink-function-HP010342583.aspx\",\"More Information\")","v":"More Information"},"Hyperlink - to a wesite"]
[]
[]
[]
[null,null,"The second method of insert a hyperlink is to go to Insert Hyperlink. ","Section 4 - Formulas and Functions.docx","Inserted Hyperlink from Insert --> Hyperlink"]
[]
[]
[]
[]
["External Reference Workbook",null,"Link to External Data in another Workbook",{"$f":"SUM('[1]Word Processing 6'!$G$6:$G$19)","v":11},"External Workbook"]
[]
[]
[]
[null,null,"Google"]
[null,null,"Section 3 - Worksheet Features\\Section 3 - Worksheet Features.docx"]

{"sheet":"Outline","index":5,"n_rows":39,"n_cols":6,"rows_kept":39,"merged":[[1,2,1,3],[4,0,4,1]]}
[]
[null,null,"Outline"]
[]
[]
[]
[]
["Homeroom #","First Name","Last Name","Payment","T-Shirt Color","T-Shirt Size"]
[105,"Esther","Yaron","2010-10-07","Dark Red","Small"]
[135,"Anisa","Naser","2010-10-14","Dark Red","Small"]
["220-A","Brigid","Ellison","Pending","Dark Red","Small"]
[105,"Melissa","White","2010-10-07","Heather Grey","Small"]
["220-B","Malik","Reynolds","2010-10-07","Heather Grey","Small"]
["220-B","Windy","Shaw","2010-10-07","Heather Grey","Small"]
["220-A","Christopher","Peyton-Gomez","Pending","White","Small"]
["220-B","Michael","Lazar","2010-10-14","White","Small"]
[{"$nulls":4},"Small Count",{"$f":"SUBTOTAL(3,F8:F15)","v":8}]
[105,"Christiana","Chen","2010-10-05","Dark Red","Medium"]
[105,"Sidney","Kelly","2010-10-11","Dark Red","Medium"]
["220-A","Chevonne","Means","2010-10-05","Dark Red","Medium"]
["220-B","Samantha","Bell","2010-10-11","Dark Red","Medium"]
[105,"Nathan","Albee","2010-10-13","Heather Grey","Medium"]
["220-B","Avery","Kelly","2010-10-11","Heather Grey","Medium"]
[110,"Matt","Benson","2010-10-11","White","Medium"]
[110,"Gabriel","Del Toro","2010-10-13","White","Medium"]
[135,"James","Panarello","2010-10-15","White","Medium"]
[135,"Chantal","Weller","2010-10-15","White","Medium"]
[{"$nulls":4},"Medium Count",{"$f":"SUBTOTAL(3,F17:F26)","v":10}]
[105,"Derek","MacDonald","Pending","Dark Red","Large"]
[110,"Kris","Ackerman","2010-10-01","Heather Grey","Large"]
[135,"Jordan","Weller","2010-10-05","Heather Grey","Large"]
[110,"Regina","Olivera","2010-10-01","White","Large"]
[135,"Alex","Yuen","2010-10-05","White","Large"]
[{"$nulls":4},"Large Count",{"$f":"SUBTOTAL(3,F28:F32)","v":5}]
[135,"Lia","Richards","2010-10-04","Dark Red","X-Large"]
["220-B","Karla","Nichols","2010-10-06","Dark Red","X-Large"]
["220-B","Tyrese","Hanlon","2010-10-04","Heather Grey","X-Large"]
["220-A","Juan","Flores","2010-10-06","White","X-Large"]
[{"$nulls":4},"X-Large Count",{"$f":"SUBTOTAL(3,F34:F37)","v":4}]
[{"$nulls":4},"Grand Count",{"$f":"SUBTOTAL(3,F8:F37)","v":27}]

{"sheet":"Scenario","index":6,"n_rows":13,"n_cols":6,"rows_kept":13,"merged":[[1,2,1,3],[4,0,4,1]]}
[]
[null,null,"Scenarios"]
[]
[]
[]
[]
[null,"Sales Target","Expense","Profit",null,"Summary"]
["Jan",{"v":25000,"d":"€25,000.00"},{"v":15000,"d":"€15,000.00"},{"$f":"B8-C8","v":{"v":10000,"d":"€10,000.00"}}]
["Feb",{"v":30000,"d":"€30,000.00"},{"v":17000,"d":"€17,000.00"},{"v":13000,"d":"€13,000.00"}]
["Mar",{"v":30000,"d":"€30,000.00"},{"v":17500,"d":"€17,500.00"},{"v":12500,"d":"€12,500.00"}]
["Apr",{"v":40000,"d":"€40,000.00"},{"v":18000,"d":"€18,000.00"},{"v":22000,"d":"€22,000.00"}]
["May",{"v":42000,"d":"€42,000.00"},{"v":19000,"d":"€19,000.00"},{"v":23000,"d":"€23,000.00"}]
["Jun",{"v":45000,"d":"€45,000.00"},{"v":21000,"d":"€21,000.00"},{"v":24000,"d":"€24,000.00"}]

{"sheet":"Scenario Summary","index":7,"n_rows":21,"n_cols":7,"rows_kept":21}
[]
[null,"Scenario Summary"]
[{"$nulls":3},"Current Values:","Original Target","10% Above Original Target","10% Below Original Target"]
[{"$nulls":4},"Created by Rynagh  McNally on 17/07/2014","Created by Rynagh  McNally on 17/07/2014\nModified by Rynagh  McNally on 17/07/2014","Created by Rynagh  McNally on 17/07/2014\nModified by Rynagh  McNally on 17/07/2014"]
[null,"Changing Cells:"]
[null,null,"$B$8",{"v":30250,"d":"€30,250.00"},{"v":25000,"d":"€25,000.00"},{"v":30250,"d":"€30,250.00"},{"v":20250,"d":"€20,250.00"}]
[null,null,"$B$9",{"v":36300,"d":"€36,300.00"},{"v":30000,"d":"€30,000.00"},{"v":36300,"d":"€36,300.00"},{"v":24300,"d":"€24,300.00"}]
[null,null,"$B$10",{"v":36300,"d":"€36,300.00"},{"v":30000,"d":"€30,000.00"},{"v":36300,"d":"€36,300.00"},{"v":24300,"d":"€24,300.00"}]
[null,null,"$B$11",{"v":48400,"d":"€48,400.00"},{"v":40000,"d":"€40,000.00"},{"v":48400,"d":"€48,400.00"},{"v":32400,"d":"€32,400.00"}]
[null,null,"$B$12",{"v":50820,"d":"€50,820.00"},{"v":42000,"d":"€42,000.00"},{"v":50820,"d":"€50,820.00"},{"v":34020,"d":"€34,020.00"}]
[null,null,"$B$13",{"v":45000,"d":"€45,000.00"},{"v":45000,"d":"€45,000.00"},{"v":45000,"d":"€45,000.00"},{"v":45000,"d":"€45,000.00"}]
[null,"Result Cells:"]
[null,null,"$D$8",{"v":15250,"d":"€15,250.00"},{"v":10000,"d":"€10,000.00"},{"v":15250,"d":"€15,250.00"},{"v":5250,"d":"€5,250.00"}]
[null,null,"$D$9",{"v":19300,"d":"€19,300.00"},{"v":13000,"d":"€13,000.00"},{"v":19300,"d":"€19,300.00"},{"v":7300,"d":"€7,300.00"}]
[null,null,"$D$10",{"v":18800,"d":"€18,800.00"},{"v":12500,"d":"€12,500.00"},{"v":18800,"d":"€18,800.00"},{"v":6800,"d":"€6,800.00"}]
[null,null,"$D$11",{"v":30400,"d":"€30,400.00"},{"v":22000,"d":"€22,000.00"},{"v":30400,"d":"€30,400.00"},{"v":14400,"d":"€14,400.00"}]
[null,null,"$D$12",{"v":31820,"d":"€31,820.00"},{"v":23000,"d":"€23,000.00"},{"v":31820,"d":"€31,820.00"},{"v":15020,"d":"€15,020.00"}]
[null,null,"$D$13",{"v":24000,"d":"€24,000.00"},{"v":24000,"d":"€24,000.00"},{"v":24000,"d":"€24,000.00"},{"v":24000,"d":"€24,000.00"}]
[null,"Notes:  Current Values column represents values of changing cells at"]
[null,"time Scenario Summary Report was created.  Changing cells for each"]
[null,"scenario are highlighted in gray."]

{"sheet":"Sorting","index":8,"n_rows":70,"n_cols":8,"rows_kept":70,"merged":[[1,2,1,3],[4,0,4,1],[7,0,7,3],[20,0,20,3],[48,0,48,3],[56,0,56,3]]}
[]
[null,null,"Sorting"]
[]
[]
[]
[]
[]
["Sports Shop Football Sales"]
[]
["Club","Shirt","Shorts","Hats"]
["Aston Villa",325,123,213]
["Blackburn",134,24,156]
["Blackburn",134,234,108]
["Chelsea",231,221,98]
["Juventus",351,361,106]
["Leicester",313,225,156]
["Liverpool",564,226,346]
["Manchester",451,112,241]
["Newcastle",214,111,115]
[]
["Sales Sort by Columns"]
[]
["Order","Date","Salesperson","Amount"]
[1010,"2014-04-09","Thomas",{"v":805.5,"d":"€805.50"}]
[1011,"2014-04-09","Wells",{"v":270.89,"d":"€270.89"}]
[1012,"2014-04-09","Davis",{"v":504.72,"d":"€504.72"}]
[1013,"2014-04-09","Cannon",{"v":568.82,"d":"€568.82"}]
[1014,"2014-04-09","Charles",{"v":201.74,"d":"€201.74"}]
[1015,"2014-04-10","Thomas",{"v":900.93,"d":"€900.93"}]
[1016,"2014-04-10","Cannon",{"v":1500.39,"d":"€1,500.39"}]
[1017,"2014-04-10","Wells",{"v":593.92,"d":"€593.92"}]
[1018,"2014-04-11","Davis",{"v":109.35,"d":"€109.35"}]
[1019,"2014-04-14","Wells",{"v":307.94,"d":"€307.94"}]
[1020,"2014-04-15","Thomas",{"v":487.82,"d":"€487.82"}]
[1021,"2014-04-15","Davis",{"v":893.82,"d":"€893.82"}]
[1022,"2014-04-15","Thomas",{"v":1022.49,"d":"€1,022.49"}]
[1023,"2014-04-15","Cannon",{"v":740.82,"d":"€740.82"}]
[1024,"2014-04-16","Charles",{"v":1198.02,"d":"€1,198.02"}]
[1025,"2014-04-16","Wells",{"v":690.93,"d":"€690.93"}]
[1026,"2014-04-17","Wells",{"v":783.94,"d":"€783.94"}]
[1027,"2014-04-17","Thomas",{"v":404.73,"d":"€404.73"}]
[1028,"2014-04-17","Davis",{"v":307.04,"d":"€307.04"}]
[1029,"2014-04-18","Davis",{"v":1690.83,"d":"€1,690.83"}]
[1030,"2014-04-18","Cannon",{"v":300.76,"d":"€300.76"}]
[1031,"2014-04-19","Charles",{"v":250.73,"d":"€250.73"}]
[1032,"2014-04-20","Charles",{"v":586.03,"d":"€586.03"}]
[1033,"2014-04-20","Wells",{"v":607.86,"d":"€607.86"}]
[]
["Sales Sort by Rows"]
[]
["Order",1016,1013,1014,1012,1015,1010,1011]
["Date","2014-04-10","2014-04-09","2014-04-09","2014-04-09","2014-04-10","2014-04-09","2014-04-09"]
["Salesperson","Cannon","Cannon","Charles","Davis","Thomas","Thomas","Wells"]
["Amount",{"v":1500.39,"d":"€1,500.39"},{"v":568.82,"d":"€568.82"},{"v":201.74,"d":"€201.74"},{"v":504.72,"d":"€504.72"},{"v":900.93,"d":"€900.93"},{"v":805.5,"d":"€805.50"},{"v":270.89,"d":"€270.89"}]
[]
[]
["Sort Using a Custom List"]
[]
["Chicken ","Steak","Fish","Delivery","Priority"]
[{"v":730,"d":"€730.00"},{"v":220,"d":"€220.00"},{"v":850,"d":"€850.00"},"Jun","Low"]
[{"v":1900,"d":"€1,900.00"},{"v":500,"d":"€500.00"},{"v":900,"d":"€900.00"},"Feb","High"]
[{"v":1200,"d":"€1,200.00"},{"v":580,"d":"€580.00"},{"v":590,"d":"€590.00"},"Jan","Medium"]
[{"v":850,"d":"€850.00"},{"v":760,"d":"€760.00"},{"v":780,"d":"€780.00"},"Mar","High"]
[{"v":500,"d":"€500.00"},{"v":775,"d":"€775.00"},{"v":1200,"d":"€1,200.00"},"Jun","Low"]
[{"v":2500,"d":"€2,500.00"},{"v":900,"d":"€900.00"},{"v":790,"d":"€790.00"},"Aug","High"]
[{"v":960,"d":"€960.00"},{"v":970,"d":"€970.00"},{"v":440,"d":"€440.00"},"Feb","Low"]
[{"v":980,"d":"€980.00"},{"v":990,"d":"€990.00"},{"v":980,"d":"€980.00"},"Aug","Low"]
[{"v":906,"d":"€906.00"},{"v":1050,"d":"€1,050.00"},{"v":920,"d":"€920.00"},"Dec","Medium"]
[{"v":570,"d":"€570.00"},{"v":1200,"d":"€1,200.00"},{"v":1080,"d":"€1,080.00"},"Apr","High"]
[{"v":670,"d":"€670.00"},{"v":12500,"d":"€12,500.00"},{"v":780,"d":"€780.00"},"May","Low"]

{"sheet":"Series & Custom Lists","index":9,"n_rows":34,"n_cols":9,"rows_kept":34,"merged":[[1,2,1,3],[4,0,4,1]]}
[]
[null,null,"Series & Custom Lists"]
[]
[]
[]
[]
["Monday","Mon","January","Jan",1,2,5,"Question 1","Product 1"]
["Tuesday","Tue","February","Feb",2,4,10,"Question 2","Product 2"]
["Wednesday","Wed","March","Mar",3,6,15,"Question 3","Product 3"]
["Thursday","Thur","April","Apr",4,8,20,"Question 4","Product 4"]
["Friday","Fri","May","May",5,10,25,"Question 5","Product 5"]
["Saturday",null,"June",null,6,12]
["Sunday",null,"July",null,7]
["Monday",null,"August",null,8]
[{"$nulls":4},9]
[{"$nulls":4},10]
[]
[]
["09:00:00",2007,"2014-01-15","Jan","2007-01-01","2014-01-01","Qtr3","Text1","1st Period"]
["10:00:00",2008,"2014-04-15","Apr","2007-02-01","2014-03-01","Qtr4","TextA","2nd Period"]
["11:00:00",2009,"2014-07-15","Jul","2007-03-01","2014-05-01","Qtr1","Text2","3rd Period"]
["12:00:00",2010,"2014-10-15","Oct","2007-04-01","2014-07-01","Qtr2","TextA","4th Period"]
["13:00:00",2011,"2015-01-15",null,"2007-05-01","2014-09-01","Qtr3","Text3","5th Period"]
["14:00:00",{"$nulls":5},"Qtr4","TextA"]
[{"$nulls":6},"Qtr1"]
[]
[null,null,"Nov"]
[null,null,"Dec"]
["Monday",1,"Jan"]
["Tuesday",3]
["Wednesday",5]
["Thursday",7]
["Friday",9]
[{"$nulls":4}," "]

{"sheet":"Naming Cells","index":10,"n_rows":10,"n_cols":3,"rows_kept":10,"merged":[[1,2,1,3],[4,0,4,1]]}
[]
[null,null,"Name Cells"]
[]
[]
[]
[]
[null,"Tax Rate",{"v":0.17,"d":"17%"}]
["Product","Cost","Tax"]
["Table",{"v":45,"d":"€45.00"},{"$f":"B9*TaxRate","v":{"v":7.65,"d":"€7.65"}}]
["Chair",{"v":105,"d":"€105.00"},{"$f":"B10*TaxRate","v":{"v":17.85,"d":"€17.85"}}]

{"sheet":"Auto Filter","index":11,"n_rows":48,"n_cols":4,"rows_kept":48,"merged":[[4,0,4,1]]}
[]
[null,null,"Auto Filter"]
[]
[]
[]
[]
[]
["Order","Date ","Salesperson","Amount"]
[1014,"2011-06-02","James",{"v":9030,"d":"€9,030.00"}]
[1021,"2011-03-06","James",{"v":2630,"d":"€2,630.00"}]
[1033,"2012-01-07","James",{"v":460,"d":"€460.00"}]
[1042,"2013-02-03","James",{"v":4765,"d":"€4,765.00"}]
[1010,"2011-06-01","Jonathon",{"v":752,"d":"€752.00"}]
[1015,"2011-09-04","Jonathon",{"v":3870,"d":"€3,870.00"}]
[1019,"2011-06-05","Jonathon",{"v":1780,"d":"€1,780.00"}]
[1022,"2011-06-07","Jonathon",{"v":4501,"d":"€4,501.00"}]
[1025,"2011-06-09","Jonathon",{"v":670,"d":"€670.00"}]
[1028,"2011-06-21","Jonathon",{"v":2970,"d":"€2,970.00"}]
[1030,"2011-06-22","Jonathon",{"v":280,"d":"€280.00"}]
[1032,"2012-01-05","Jonathon",{"v":4820,"d":"€4,820.00"}]
[1036,"2012-01-08","Jonathon",{"v":2430,"d":"€2,430.00"}]
[1041,"2013-02-02","Jonathon",{"v":3961,"d":"€3,961.00"}]
[1043,"2013-02-04","Jonathon",{"v":1980,"d":"€1,980.00"}]
[1011,"2011-06-01","Mary Jane",{"v":1690,"d":"€1,690.00"}]
[1013,"2011-06-02","Mary Jane",{"v":467,"d":"€467.00"}]
[1017,"2011-06-04","Mary Jane",{"v":501,"d":"€501.00"}]
[1023,"2011-06-07","Mary Jane",{"v":2848,"d":"€2,848.00"}]
[1029,"2011-06-21","Mary Jane",{"v":4270,"d":"€4,270.00"}]
[1035,"2012-01-07","Mary Jane",{"v":1570,"d":"€1,570.00"}]
[1038,"2012-01-09","Mary Jane",{"v":925,"d":"€925.00"}]
[1040,"2012-01-14","Mary Jane",{"v":2074,"d":"€2,074.00"}]
[1045,"2013-05-05","Mary Jane",{"v":780,"d":"€780.00"}]
[1012,"2011-06-02","Susan",{"v":2790,"d":"€2,790.00"}]
[1016,"2011-06-04","Susan",{"v":840,"d":"€840.00"}]
[1020,"2011-06-06","Susan",{"v":397,"d":"€397.00"}]
[1027,"2011-06-13","Susan",{"v":350,"d":"€350.00"}]
[1031,"2012-01-04","Susan",{"v":570,"d":"€570.00"}]
[1037,"2012-01-09","Susan",{"v":847,"d":"€847.00"}]
[1044,"2013-02-04","Susan",{"v":460,"d":"€460.00"}]
[1009,"2011-05-29","Tommy",{"v":1245,"d":"€1,245.00"}]
[1018,"2011-06-05","Tommy",{"v":1362,"d":"€1,362.00"}]
[1024,"2011-06-08","Tommy",{"v":693,"d":"€693.00"}]
[1026,"2011-06-09","Tommy",{"v":1670,"d":"€1,670.00"}]
[1034,"2012-01-07","Tommy",{"v":750,"d":"€750.00"}]
[1039,"2012-05-10","Tommy",{"v":360,"d":"€360.00"}]
[{"$nulls":3},{"$f":"SUBTOTAL(9,D9:D45)","v":{"v":14806,"d":"€14,806.00"}}]
[]
[{"$nulls":3},{"$f":"SUM(D9:D45)","v":{"v":72358,"d":"€72,358.00"}}]

{"sheet":"Advanced Filter","index":12,"n_rows":94,"n_cols":18,"rows_kept":94,"merged":[[2,6,2,11],[4,0,4,1],[5,9,5,10],[50,0,50,2],[50,9,50,11]]}
[]
[null,null,"Advanced Filter",{"$nulls":3},"For more information on Advanced Filters watch this video: "]
[{"$nulls":6},"http://www.youtube.com/watch?v=SU1qGbN6Rs8 "]
[]
[]
["One Criteria",{"$nulls":8},"Multiple Criteria - AND"]
["Order","Date ","Salesperson","Amount",{"$nulls":5},"Order","Date ","Salesperson","Amount"]
[null,null,"Susan",{"$nulls":7},">01/01/2011","Susan",">500"]
[]
["Order","Date ","Salesperson","Amount",{"$nulls":5},"Order","Date ","Salesperson","Amount"]
[1009,"2011-05-29","Tommy",{"v":1245,"d":"€1,245.00"},{"$nulls":5},1009,"2011-05-29","Tommy",{"v":1245,"d":"€1,245.00"}]
[1010,"2011-06-01","Jonathon",{"v":752,"d":"€752.00"},{"$nulls":5},1010,"2011-06-01","Jonathon",{"v":752,"d":"€752.00"}]
[1011,"2011-06-01","Mary Jane",{"v":1690,"d":"€1,690.00"},{"$nulls":5},1011,"2011-06-01","Mary Jane",{"v":1690,"d":"€1,690.00"}]
[1012,"2011-06-02","Susan",{"v":2790,"d":"€2,790.00"},{"$nulls":5},1012,"2011-06-02","Susan",{"v":2790,"d":"€2,790.00"}]
[1013,"2011-06-02","Mary Jane",{"v":467,"d":"€467.00"},{"$nulls":5},1013,"2011-06-02","Mary Jane",{"v":467,"d":"€467.00"}]
[1014,"2011-06-02","James",{"v":9030,"d":"€9,030.00"},{"$nulls":5},1014,"2011-06-02","James",{"v":9030,"d":"€9,030.00"}]
[1015,"2011-09-04","Jonathon",{"v":3870,"d":"€3,870.00"},{"$nulls":5},1015,"2011-09-04","Jonathon",{"v":3870,"d":"€3,870.00"}]
[1016,"2011-06-04","Susan",{"v":840,"d":"€840.00"},{"$nulls":5},1016,"2011-06-04","Susan",{"v":840,"d":"€840.00"}]
[1017,"2011-06-04","Mary Jane",{"v":501,"d":"€501.00"},{"$nulls":5},1017,"2011-06-04","Mary Jane",{"v":501,"d":"€501.00"}]
[1018,"2011-06-05","Tommy",{"v":1362,"d":"€1,362.00"},{"$nulls":5},1018,"2011-06-05","Tommy",{"v":1362,"d":"€1,362.00"}]
[1019,"2011-06-05","Jonathon",{"v":1780,"d":"€1,780.00"},{"$nulls":5},1019,"2011-06-05","Jonathon",{"v":1780,"d":"€1,780.00"}]
[1020,"2011-06-06","Susan",{"v":397,"d":"€397.00"},{"$nulls":5},1020,"2011-06-06","Susan",{"v":397,"d":"€397.00"}]
[1021,"2011-03-06","James",{"v":2630,"d":"€2,630.00"},{"$nulls":5},1021,"2011-03-06","James",{"v":2630,"d":"€2,630.00"}]
[1022,"2011-06-07","Jonathon",{"v":4501,"d":"€4,501.00"},{"$nulls":5},1022,"2011-06-07","Jonathon",{"v":4501,"d":"€4,501.00"}]
[1023,"2011-06-07","Mary Jane",{"v":2848,"d":"€2,848.00"},{"$nulls":5},1023,"2011-06-07","Mary Jane",{"v":2848,"d":"€2,848.00"}]
[1024,"2011-06-08","Tommy",{"v":693,"d":"€693.00"},{"$nulls":5},1024,"2011-06-08","Tommy",{"v":693,"d":"€693.00"}]
[1025,"2011-06-09","Jonathon",{"v":670,"d":"€670.00"},{"$nulls":5},1025,"2011-06-09","Jonathon",{"v":670,"d":"€670.00"}]
[1026,"2011-06-09","Tommy",{"v":1670,"d":"€1,670.00"},{"$nulls":5},1026,"2011-06-09","Tommy",{"v":1670,"d":"€1,670.00"}]
[1027,"2011-06-13","Susan",{"v":350,"d":"€350.00"},{"$nulls":5},1027,"2011-06-13","Susan",{"v":350,"d":"€350.00"}]
[1028,"2011-06-21","Jonathon",{"v":2970,"d":"€2,970.00"},{"$nulls":5},1028,"2011-06-21","Jonathon",{"v":2970,"d":"€2,970.00"}]
[1029,"2011-06-21","Mary Jane",{"v":4270,"d":"€4,270.00"},{"$nulls":5},1029,"2011-06-21","Mary Jane",{"v":4270,"d":"€4,270.00"}]
[1030,"2011-06-22","Jonathon",{"v":280,"d":"€280.00"},{"$nulls":5},1030,"2011-06-22","Jonathon",{"v":280,"d":"€280.00"}]
[1031,"2012-01-04","Susan",{"v":570,"d":"€570.00"},{"$nulls":5},1031,"2012-01-04","Susan",{"v":570,"d":"€570.00"}]
[1032,"2012-01-05","Jonathon",{"v":4820,"d":"€4,820.00"},{"$nulls":5},1032,"2012-01-05","Jonathon",{"v":4820,"d":"€4,820.00"}]
[1033,"2012-01-07","James",{"v":460,"d":"€460.00"},{"$nulls":5},1033,"2012-01-07","James",{"v":460,"d":"€460.00"}]
[1034,"2012-01-07","Tommy",{"v":750,"d":"€750.00"},{"$nulls":5},1034,"2012-01-07","Tommy",{"v":750,"d":"€750.00"}]
[1035,"2012-01-07","Mary Jane",{"v":1570,"d":"€1,570.00"},{"$nulls":5},1035,"2012-01-07","Mary Jane",{"v":1570,"d":"€1,570.00"}]
[1036,"2012-01-08","Jonathon",{"v":2430,"d":"€2,430.00"},{"$nulls":5},1036,"2012-01-08","Jonathon",{"v":2430,"d":"€2,430.00"}]
[1037,"2012-01-09","Susan",{"v":847,"d":"€847.00"},{"$nulls":5},1037,"2012-01-09","Susan",{"v":847,"d":"€847.00"}]
[1038,"2012-01-09","Mary Jane",{"v":925,"d":"€925.00"},{"$nulls":5},1038,"2012-01-09","Mary Jane",{"v":925,"d":"€925.00"}]
[1039,"2012-05-10","Tommy",{"v":360,"d":"€360.00"},{"$nulls":5},1039,"2012-05-10","Tommy",{"v":360,"d":"€360.00"}]
[1040,"2012-01-14","Mary Jane",{"v":2074,"d":"€2,074.00"},{"$nulls":5},1040,"2012-01-14","Mary Jane",{"v":2074,"d":"€2,074.00"}]
[1041,"2013-02-02","Jonathon",{"v":3961,"d":"€3,961.00"},{"$nulls":5},1041,"2013-02-02","Jonathon",{"v":3961,"d":"€3,961.00"}]
[1042,"2013-02-03","James",{"v":4765,"d":"€4,765.00"},{"$nulls":5},1042,"2013-02-03","James",{"v":4765,"d":"€4,765.00"}]
[1043,"2013-02-04","Jonathon",{"v":1980,"d":"€1,980.00"},{"$nulls":5},1043,"2013-02-04","Jonathon",{"v":1980,"d":"€1,980.00"}]
[1044,"2013-02-04","Susan",{"v":460,"d":"€460.00"},{"$nulls":5},1044,"2013-02-04","Susan",{"v":460,"d":"€460.00"}]
[1045,"2013-05-05","Mary Jane",{"v":780,"d":"€780.00"},{"$nulls":5},1045,"2013-05-05","Mary Jane",{"v":780,"d":"€780.00"}]
[]
[]
[]
["Multiple Criteria - AND with a range",{"$nulls":8},"Multiple Criteria - OR"]
[]
["Order","Date ","Salesperson","Amount","Amount",{"$nulls":4},"Order","Date ","Salesperson","Amount"]
[null,">01/01/2011","Susan","<1000",">500",{"$nulls":5},">01/01/2011","Susan",">500"]
[{"$nulls":10},">01/01/2011","Mary Jane",">500"]
["Order","Date ","Salesperson","Amount"]
[1009,"2011-05-29","Tommy",{"v":1245,"d":"€1,245.00"},{"$nulls":5},"Order","Date ","Salesperson","Amount",null,"Order","Date ","Salesperson","Amount"]
[1010,"2011-06-01","Jonathon",{"v":752,"d":"€752.00"},{"$nulls":5},1009,"2011-05-29","Tommy",{"v":1245,"d":"€1,245.00"},null,1011,"2011-06-01","Mary Jane",{"v":1690,"d":"€1,690.00"}]
[1011,"2011-06-01","Mary Jane",{"v":1690,"d":"€1,690.00"},{"$nulls":5},1010,"2011-06-01","Jonathon",{"v":752,"d":"€752.00"},null,1012,"2011-06-02","Susan",{"v":2790,"d":"€2,790.00"}]
[1012,"2011-06-02","Susan",{"v":2790,"d":"€2,790.00"},{"$nulls":5},1011,"2011-06-01","Mary Jane",{"v":1690,"d":"€1,690.00"},null,1016,"2011-06-04","Susan",{"v":840,"d":"€840.00"}]
[1013,"2011-06-02","Mary Jane",{"v":467,"d":"€467.00"},{"$nulls":5},1012,"2011-06-02","Susan",{"v":2790,"d":"€2,790.00"},null,1017,"2011-06-04","Mary Jane",{"v":501,"d":"€501.00"}]
[1014,"2011-06-02","James",{"v":9030,"d":"€9,030.00"},{"$nulls":5},1013,"2011-06-02","Mary Jane",{"v":467,"d":"€467.00"},null,1023,"2011-06-07","Mary Jane",{"v":2848,"d":"€2,848.00"}]
[1015,"2011-09-04","Jonathon",{"v":3870,"d":"€3,870.00"},{"$nulls":5},1014,"2011-06-02","James",{"v":9030,"d":"€9,030.00"},null,1029,"2011-06-21","Mary Jane",{"v":4270,"d":"€4,270.00"}]
[1016,"2011-06-04","Susan",{"v":840,"d":"€840.00"},{"$nulls":5},1015,"2011-09-04","Jonathon",{"v":3870,"d":"€3,870.00"},null,1031,"2012-01-04","Susan",{"v":570,"d":"€570.00"}]
[1017,"2011-06-04","Mary Jane",{"v":501,"d":"€501.00"},{"$nulls":5},1016,"2011-06-04","Susan",{"v":840,"d":"€840.00"},null,1035,"2012-01-07","Mary Jane",{"v":1570,"d":"€1,570.00"}]
[1018,"2011-06-05","Tommy",{"v":1362,"d":"€1,362.00"},{"$nulls":5},1017,"2011-06-04","Mary Jane",{"v":501,"d":"€501.00"},null,1037,"2012-01-09","Susan",{"v":847,"d":"€847.00"}]
[1019,"2011-06-05","Jonathon",{"v":1780,"d":"€1,780.00"},{"$nulls":5},1018,"2011-06-05","Tommy",{"v":1362,"d":"€1,362.00"},null,1038,"2012-01-09","Mary Jane",{"v":925,"d":"€925.00"}]
[1020,"2011-06-06","Susan",{"v":397,"d":"€397.00"},{"$nulls":5},1019,"2011-06-05","Jonathon",{"v":1780,"d":"€1,780.00"},null,1040,"2012-01-14","Mary Jane",{"v":2074,"d":"€2,074.00"}]
[1021,"2011-03-06","James",{"v":2630,"d":"€2,630.00"},{"$nulls":5},1020,"2011-06-06","Susan",{"v":397,"d":"€397.00"},null,1045,"2013-05-05","Mary Jane",{"v":780,"d":"€780.00"}]
[1022,"2011-06-07","Jonathon",{"v":4501,"d":"€4,501.00"},{"$nulls":5},1021,"2011-03-06","James",{"v":2630,"d":"€2,630.00"}]
[1023,"2011-06-07","Mary Jane",{"v":2848,"d":"€2,848.00"},{"$nulls":5},1022,"2011-06-07","Jonathon",{"v":4501,"d":"€4,501.00"}]
[1024,"2011-06-08","Tommy",{"v":693,"d":"€693.00"},{"$nulls":5},1023,"2011-06-07","Mary Jane",{"v":2848,"d":"€2,848.00"}]
[1025,"2011-06-09","Jonathon",{"v":670,"d":"€670.00"},{"$nulls":5},1024,"2011-06-08","Tommy",{"v":693,"d":"€693.00"}]
[1026,"2011-06-09","Tommy",{"v":1670,"d":"€1,670.00"},{"$nulls":5},1025,"2011-06-09","Jonathon",{"v":670,"d":"€670.00"}]
[1027,"2011-06-13","Susan",{"v":350,"d":"€350.00"},{"$nulls":5},1026,"2011-06-09","Tommy",{"v":1670,"d":"€1,670.00"}]
[1028,"2011-06-21","Jonathon",{"v":2970,"d":"€2,970.00"},{"$nulls":5},1027,"2011-06-13","Susan",{"v":350,"d":"€350.00"}]
[1029,"2011-06-21","Mary Jane",{"v":4270,"d":"€4,270.00"},{"$nulls":5},1028,"2011-06-21","Jonathon",{"v":2970,"d":"€2,970.00"}]
[1030,"2011-06-22","Jonathon",{"v":280,"d":"€280.00"},{"$nulls":5},1029,"2011-06-21","Mary Jane",{"v":4270,"d":"€4,270.00"}]
[1031,"2012-01-04","Susan",{"v":570,"d":"€570.00"},{"$nulls":5},1030,"2011-06-22","Jonathon",{"v":280,"d":"€280.00"}]
[1032,"2012-01-05","Jonathon",{"v":4820,"d":"€4,820.00"},{"$nulls":5},1031,"2012-01-04","Susan",{"v":570,"d":"€570.00"}]
[1033,"2012-01-07","James",{"v":460,"d":"€460.00"},{"$nulls":5},1032,"2012-01-05","Jonathon",{"v":4820,"d":"€4,820.00"}]
[1034,"2012-01-07","Tommy",{"v":750,"d":"€750.00"},{"$nulls":5},1033,"2012-01-07","James",{"v":460,"d":"€460.00"}]
[1035,"2012-01-07","Mary Jane",{"v":1570,"d":"€1,570.00"},{"$nulls":5},1034,"2012-01-07","Tommy",{"v":750,"d":"€750.00"}]
[1036,"2012-01-08","Jonathon",{"v":2430,"d":"€2,430.00"},{"$nulls":5},1035,"2012-01-07","Mary Jane",{"v":1570,"d":"€1,570.00"}]
[1037,"2012-01-09","Susan",{"v":847,"d":"€847.00"},{"$nulls":5},1036,"2012-01-08","Jonathon",{"v":2430,"d":"€2,430.00"}]
[1038,"2012-01-09","Mary Jane",{"v":925,"d":"€925.00"},{"$nulls":5},1037,"2012-01-09","Susan",{"v":847,"d":"€847.00"}]
[1039,"2012-05-10","Tommy",{"v":360,"d":"€360.00"},{"$nulls":5},1038,"2012-01-09","Mary Jane",{"v":925,"d":"€925.00"}]
[1040,"2012-01-14","Mary Jane",{"v":2074,"d":"€2,074.00"},{"$nulls":5},1039,"2012-05-10","Tommy",{"v":360,"d":"€360.00"}]
[1041,"2013-02-02","Jonathon",{"v":3961,"d":"€3,961.00"},{"$nulls":5},1040,"2012-01-14","Mary Jane",{"v":2074,"d":"€2,074.00"}]
[1042,"2013-02-03","James",{"v":4765,"d":"€4,765.00"},{"$nulls":5},1041,"2013-02-02","Jonathon",{"v":3961,"d":"€3,961.00"}]
[1043,"2013-02-04","Jonathon",{"v":1980,"d":"€1,980.00"},{"$nulls":5},1042,"2013-02-03","James",{"v":4765,"d":"€4,765.00"}]
[1044,"2013-02-04","Susan",{"v":460,"d":"€460.00"},{"$nulls":5},1043,"2013-02-04","Jonathon",{"v":1980,"d":"€1,980.00"}]
[1045,"2013-05-05","Mary Jane",{"v":780,"d":"€780.00"},{"$nulls":5},1044,"2013-02-04","Susan",{"v":460,"d":"€460.00"}]
[{"$nulls":9},1045,"2013-05-05","Mary Jane",{"v":780,"d":"€780.00"}]

{"sheet":"Advanced Filter Unique Records","index":13,"n_rows":45,"n_cols":7,"rows_kept":45,"merged":[[1,2,1,3],[2,6,2,11],[4,0,4,1]]}
[]
[null,null,"Advanced Filter \nUnique Records",{"$nulls":3},"For more information on Advanced Filters watch this video: "]
[{"$nulls":6},"http://www.youtube.com/watch?v=SU1qGbN6Rs8 "]
[]
[]
[]
[]
["Order","Date ","Salesperson","Amount"]
[1009,"2011-05-29","Tommy",{"v":1245,"d":"€1,245.00"},null,"Salesperson"]
[1010,"2011-06-01","Jonathon",{"v":752,"d":"€752.00"},null,"Tommy"]
[1011,"2011-06-01","Mary Jane",{"v":1690,"d":"€1,690.00"},null,"Jonathon"]
[1012,"2011-06-02","Susan",{"v":2790,"d":"€2,790.00"},null,"Mary Jane"]
[1013,"2011-06-02","Mary Jane",{"v":467,"d":"€467.00"},null,"Susan"]
[1014,"2011-06-02","James",{"v":9030,"d":"€9,030.00"},null,"James"]
[1015,"2011-09-04","Jonathon",{"v":3870,"d":"€3,870.00"}]
[1016,"2011-06-04","Susan",{"v":840,"d":"€840.00"}]
[1017,"2011-06-04","Mary Jane",{"v":501,"d":"€501.00"}]
[1018,"2011-06-05","Tommy",{"v":1362,"d":"€1,362.00"}]
[1019,"2011-06-05","Jonathon",{"v":1780,"d":"€1,780.00"}]
[1020,"2011-06-06","Susan",{"v":397,"d":"€397.00"}]
[1021,"2011-03-06","James",{"v":2630,"d":"€2,630.00"}]
[1022,"2011-06-07","Jonathon",{"v":4501,"d":"€4,501.00"}]
[1023,"2011-06-07","Mary Jane",{"v":2848,"d":"€2,848.00"}]
[1024,"2011-06-08","Tommy",{"v":693,"d":"€693.00"}]
[1025,"2011-06-09","Jonathon",{"v":670,"d":"€670.00"}]
[1026,"2011-06-09","Tommy",{"v":1670,"d":"€1,670.00"}]
[1027,"2011-06-13","Susan",{"v":350,"d":"€350.00"}]
[1028,"2011-06-21","Jonathon",{"v":2970,"d":"€2,970.00"}]
[1029,"2011-06-21","Mary Jane",{"v":4270,"d":"€4,270.00"}]
[1030,"2011-06-22","Jonathon",{"v":280,"d":"€280.00"}]
[1031,"2012-01-04","Susan",{"v":570,"d":"€570.00"}]
[1032,"2012-01-05","Jonathon",{"v":4820,"d":"€4,820.00"}]
[1033,"2012-01-07","James",{"v":460,"d":"€460.00"}]
[1034,"2012-01-07","Tommy",{"v":750,"d":"€750.00"}]
[1035,"2012-01-07","Mary Jane",{"v":1570,"d":"€1,570.00"}]
[1036,"2012-01-08","Jonathon",{"v":2430,"d":"€2,430.00"}]
[1037,"2012-01-09","Susan",{"v":847,"d":"€847.00"}]
[1038,"2012-01-09","Mary Jane",{"v":925,"d":"€925.00"}]
[1039,"2012-05-10","Tommy",{"v":360,"d":"€360.00"}]
[1040,"2012-01-14","Mary Jane",{"v":2074,"d":"€2,074.00"}]
[1041,"2013-02-02","Jonathon",{"v":3961,"d":"€3,961.00"}]
[1042,"2013-02-03","James",{"v":4765,"d":"€4,765.00"}]
[1043,"2013-02-04","Jonathon",{"v":1980,"d":"€1,980.00"}]
[1044,"2013-02-04","Susan",{"v":460,"d":"€460.00"}]
[1045,"2013-05-05","Mary Jane",{"v":780,"d":"€780.00"}]

{"sheet":"Section 4 Notes","index":14,"n_rows":7,"n_cols":4,"rows_kept":7,"merged":[[2,3,2,7],[3,3,3,7]]}
[]
[]
[{"$nulls":3},"Level 6 Spreadsheet 6N4089"]
[{"$nulls":3},"Section 4 – Formulae and Functions"]
[]
[]
[{"$nulls":3},"To be used in conjunction with Sction 4 Notes"]

{"sheet":"Section 5 Notes","index":15,"n_rows":7,"n_cols":4,"rows_kept":7,"merged":[[2,3,2,8],[3,3,3,8]]}
[]
[]
[{"$nulls":3},"Level 6 Spreadsheet 6N4089"]
[{"$nulls":3},"Section 5 – Charts and Pivot Tables"]
[]
[]
[{"$nulls":3},"To be used in conjunction with Section 5 Notes"]

{"sheet":"Chart","index":16,"n_rows":15,"n_cols":3,"rows_kept":15,"merged":[[4,0,4,1]]}
[]
[null,null,"Charts"]
[]
[]
["SBS Page 88"]
[]
["Club Fundraising"]
[]
[null,"Target","Actual"]
["January",{"v":2000,"d":"€2,000"},{"v":1800,"d":"€1,800"}]
["February",{"v":5000,"d":"€5,000"},{"v":4200,"d":"€4,200"}]
["March",{"v":8000,"d":"€8,000"},{"v":6950,"d":"€6,950"}]
["April",{"v":12000,"d":"€12,000"},{"v":10250,"d":"€10,250"}]
["May",{"v":16000,"d":"€16,000"},{"v":12870,"d":"€12,870"}]
["June",{"v":2000,"d":"€2,000"},{"v":15500,"d":"€15,500"}]

{"sheet":"Chart Area","index":17,"n_rows":26,"n_cols":3,"rows_kept":26,"merged":[[4,0,4,1]]}
[]
[null,null,"Chart Area"]
[]
[]
[]
[]
["Month ","Value"]
["Jan",110]
["Feb",98]
["Mar",85]
["Apr",45]
["May",54]
["Jun",70]
["Jul",23]
["Aug",10]
["Sep",5]
{"$rows_empty":9}
[null,null,"\\"]

{"sheet":"Chart Objects Added","index":18,"n_rows":18,"n_cols":4,"rows_kept":18,"merged":[[1,1,1,4],[4,0,4,1]]}
[]
[null,"Chart with Objects Added"]
[]
[]
[]
[]
["Sales Comparison"]
[]
["Shoe Shop Outlets"]
[]
["Shop Location","Sales ",null,"Location:"]
["Grafton Street",{"v":1.2,"d":"€1.2"},null,"Dublin"]
["Jervis Shopping Centre",{"v":1.3,"d":"€1.3"},null,"Dublin"]
["Powers Court",{"v":0.8,"d":"€0.8"},null,"Dublin"]
["Park Street",{"v":1.2,"d":"£1.2"},null,"Bristol"]
["Victoria Square",{"v":2,"d":"£2.0"},null,"Belfast"]
["Oxford Street",{"v":2.6,"d":"£2.6"},null,"London"]
["Bond Street",{"v":1.8,"d":"£1.8"},null,"London"]

{"sheet":"Chart Lower Neg Line","index":19,"n_rows":2,"n_cols":3,"rows_kept":2,"merged":[[1,2,1,3],[4,0,4,1]]}
[]
[null,null,"Chart Lower Negative Line"]

{"sheet":"Trendline","index":20,"n_rows":15,"n_cols":3,"rows_kept":15,"merged":[[4,0,4,1]]}
[]
[null,null,"Trendline Starting at 0"]
[]
[]
["Trendline"]
[]
[]
["Age","Number of People"]
["0 Years",0]
["10 Years",15]
["20 Years",16]
["30 Years",51]
["40 Years",55]
["50 Years",70]
["60 Years",75]

{"sheet":"Gantt Chart","index":21,"n_rows":19,"n_cols":12,"rows_kept":19,"merged":[[1,2,1,4],[4,0,4,1]]}
[]
[null,null,"Timeline Gantt Chart"]
[]
[]
["Trendline"]
[]
[]
[]
[null,"Start Date","Completed ",null,"End Date",{"$nulls":3},"Scale"]
["Ethics Submission","2012-09-01",{"$f":"E10-B10","v":60},null,"2012-10-31",{"$nulls":5},"Vertical Axis","Categories in Reverse Order"]
["Familirisation with EMG","2012-11-01",59,null,"2012-12-30",null,null,"Start Date",41153,null,"Horizontal Value Axis","Minimum 41153 Maximum 41517"]
["Recruitment of Subjects","2013-01-01",58,null,"2013-02-28",null,null,"End Date",{"$f":"E19","v":41517},null,"Stacked Column","Series 1 set to no fill"]
["Pilot Testing","2013-01-01",30,null,"2013-01-31"]
["Testing of Subjects","2013-02-01",88,null,"2013-04-30"]
["Data Anyalsis","2013-04-01",60,null,"2013-05-31"]
["Drafting of Thesis","2013-06-01",60,null,"2013-07-31"]
["Draft Submission to Safe Assign ","2013-07-01",30,null,"2013-07-31"]
["Corrections of Draft","2013-07-01",61,null,"2013-08-31"]
["Submission of Thesis","2013-08-01",30,null,"2013-08-31"]

{"sheet":"House","index":22,"n_rows":0,"n_cols":0,"rows_kept":0}

{"sheet":"Conditional Formatting","index":23,"n_rows":47,"n_cols":6,"rows_kept":47,"merged":[[1,2,1,3],[4,0,4,1]]}
[]
[null,null,"Conditional Formatting"]
[]
["See Section 2 Notes"]
["Formatting"]
["Data Bars",25]
[null,3]
[null,52]
[null,23]
[null,3]
[null,85]
[null,45]
[null,23]
[null,5]
[null,16]
[null,45]
[]
["Colour Scale"]
[]
[null,"English","Irish","Maths ","Geography","German"]
["Mary Smith",47,67,58,35,65]
["Tom Treanor",56,76,92,58,23]
["Catherine Walsh",87,87,48,78,65]
["Seamus Divine",54,59,46,76,78]
["Alan McGuinness",38,89,73,69,72]
["Gertie McNally",37,65,38,59,49]
[]
[]
["Icon Sets"]
[]
[null,"English","Irish","Maths ","Geography","German"]
["Mary Smith",47,67,58,35,65]
["Tom Treanor",56,76,92,58,23]
["Catherine Walsh",87,87,48,78,65]
["Seamus Divine",54,59,46,76,78]
["Alan McGuinness",38,89,73,69,72]
["Gertie McNally",37,65,38,59,49]
[]
["Icon Sets"]
[]
[null,"English","Irish","Maths ","Geography","German"]
["Mary Smith",47,67,58,35,65]
["Tom Treanor",56,76,92,58,23]
["Catherine Walsh",87,87,48,78,65]
["Seamus Divine",54,59,46,76,78]
["Alan McGuinness",38,89,73,69,72]
["Gertie McNally",37,65,38,59,49]

{"sheet":"Dates and Times","index":24,"n_rows":48,"n_cols":13,"rows_kept":48,"merged":[[4,0,4,1],[4,2,4,3],[4,4,4,5],[4,6,4,7],[4,8,4,9],[37,0,37,1],[37,8,37,9]]}
[]
[null,null,"DATES AND TIMES"]
[]
[]
["Arguments ",null,"Explaination","Forumla or Function","Function Name"]
[null,null,"Shows todays Date",{"$f":"TODAY()","v":"2015-09-16"},"Today"]
[null,null,"Shows todays Date and Time",{"$f":"NOW()","v":42263.67256111111},"Now"]
[null,null,"Shows the day of the month as a number. ",{"$f":"DAY(D6)","v":16},"Day"]
["2013-11-07","2013-11-28","Subtract two days from each other",{"$f":"DAY(B9)-DAY(A9)","v":21},"Day - Day"]
[null,"2013-07-28","Shows the month as a number from 1 - 12. ",{"$f":"MONTH(B10)","v":7},"Month","1982-01-08"]
["2013-05-01","2013-09-28","Subtract two months from each other",{"$f":"MONTH(B11)-MONTH(A11)","v":4},"Month - Month"]
[null,"2013-11-20","Shows the year as a number. ",{"$f":"YEAR(D6)","v":2015},"Year"]
["2004-04-15","2013-05-28","Subtract two years from each other. ",{"$f":"YEAR(B13)-YEAR(A13)","v":9},"Year - Year"]
[null,null,"TEXT and NOW",{"$f":"\"The current time is \"&TEXT(NOW(),\"h:mm AM/PM\")","v":"The current time is 4:08 pm"}]
["1982-01-08","2012-11-07","Take two dates from each other",{"$f":"B15-A15","v":11261},"Days"]
["1982-01-08","2012-11-07","Take two months from each other",{"$f":"MONTH(B16)-MONTH(A16)","v":10},"Months"]
[null,null,"Take two years from each other",{"$f":"YEAR(B16)-YEAR(A16)","v":30},"Years"]
[null,null,"Age in Months",{"$f":"(YEAR(B16)-YEAR(A16))*12+(MONTH(B16)-MONTH(A16))","v":370},"Month + Year"]
[null,null,"Date Format Applied 'dddd'","1982-01-08"]
[null,"2013-11-27","Shows the day as a number",{"$f":"WEEKDAY(B20,2)","v":3},"Weekday"]
[null,null,"Pay Date:",{"$f":"TODAY()","v":"2015-09-16"},"TODAY"]
[null,null,"Week Number:",{"$f":"WEEKNUM(D21)","v":38},"WEEKNUM"]
[null,null,"Nested if to show the day based on weekday",{"$f":"IF(D20=1,\"Sunday\",IF(D20=2,\"Monday\",IF(D20=3,\"Tuesday\",IF(D20=4,\"Wednesday\",IF(D20=5,\"Thursday\",IF(D20=6,\"Friday\",\"Saturday\"))))))","v":"Tuesday"},"Nested IF"]
["2012-11-07","2012-09-01","Dated if to count number of days",{"$f":"DATEDIF(B24,A24,\"d\")","v":67},"DatedIF Days"]
[null,null,"Dated if to count number of months",{"$f":"DATEDIF(B24,A24,\"M\")","v":2},"DatedIF Months"]
[null,null,"Dated if to count number of years",{"$f":"DATEDIF(B24,A24,\"y\")","v":0},"DatedIF Years"]
["Started: ","2012-09-01","Calculate networking days Exclude holidays",{"$f":"NETWORKDAYS(B27,B28,B29:B33)","v":788},"Networkdays"]
["Today: ",{"$f":"TODAY()","v":"2015-09-16"},"Networkdays with a different weekend (Hairdresers)",{"$f":"NETWORKDAYS.INTL(B27,B28,12,B29:B30)","v":951},"Networkdays.intl"]
["Mid Term:","2012-10-29"]
[null,"2012-10-30"]
[null,"2012-10-31"]
[null,"2012-11-01",{"$nulls":3},"Today Function   =today()"]
["End Mid-Term:","2012-11-02"]
[null,"2012-01-01","Add on Years to a Date - 2 Years",{"$f":"DATE(YEAR(B34)+2,MONTH(B34),DAY(B34))","v":"2014-01-01"},"Date with Year, Month, Day"]
[null,null,"Add on Months to a Date - 30 Months",{"$f":"DATE(YEAR(B34),MONTH(B34)+30,DAY(B34))","v":"2014-07-01"},"Date with Year, Month, Day"]
[null,null,"Add on Days to a Date - 42 days (6 weeks)",{"$f":"DATE(YEAR(B34),MONTH(B34),DAY(B34)+42)","v":"2012-02-12"},"Date with Year, Month, Day"]
[{"$nulls":5},"Today Function   =today()"]
["Try it Yourself Examples",null,null,"Answer Here","Result","Show Answers"]
[]
[null,"Q1","Enter a function to show today's date:",null,{"$f":"IF(D40=\"\",\" \",IF(D40=M40,\"Correct\",\"Try Again\"))","v":" "},"Today Function   =today()",{"$nulls":6},{"$f":"TODAY()","v":"2015-09-16"}]
[{"$nulls":4},{"$f":"IF(D41=\"\",\" \",IF(\"=today()\",\"Correct\",\"Try Again\"))","v":" "}]
[null,null,"Enter your Date of birth in D34:","1982-01-08"]
[]
[null,"Q2","How many Days old are you?"]
[null,"Q3","How many Months old are you?"]
[null,"Q4","How many Years old are you?"]
[null,"Q5","Convert your birthday to a Weekday number."]
[null,"Q6","What day of the week were you born on?"]

{"sheet":"Range Union Intersection 3D","index":25,"n_rows":18,"n_cols":8,"rows_kept":18,"merged":[[1,1,1,3],[5,0,5,1],[13,0,13,4],[13,5,13,6],[14,0,14,4],[14,5,14,6],[15,0,15,4],[15,5,15,6],[16,0,16,4],[16,5,16,6],[17,0,17,4],[17,5,17,6]]}
[]
[null,"Range, Union, Intersection and 3D Reference Operators"]
[]
[]
[]
["Explaination",null,"Forumla or Function","Function Name",null,"Data"]
["Group of Cells used in a formula.",null,{"$f":"SUM(F8:H11)","v":242},"Range",null,"Row 1","Row 2","Row 3"]
["More than one group of cells using - comma",null,{"$f":"SUM(F8:F11,H8:H11)","v":212},"Union",null,7,20,5]
["Where group of cells overlap - space",null,{"$f":"SUM(F8:G11 G8:H11)","v":30},"Intersection",null,45,3,45]
["3D Working across worksheets. ",null,{"$f":"SUM('Dates and Times:Range Union Intersection 3D'!C7:C8)","v":454},"3D",null,1,2,33]
[null,null,"e.g. =sum(Sheet1:Sheet3!C7:C8)",null,null,22,5,54]
[]
[]
["Meaning (Example)",{"$nulls":4},"Reference Operator"]
["Range, produces one reference to all the cells between two cells, including the two cell references (B5:B15)",{"$nulls":4},": (colon)"]
["Union, combines multiple references into one reference (SUM(B5:B15,D5:D15))",{"$nulls":4},", (comma)"]
["Intersection, produces one reference to cells common to the two references (B7:D7 C6:C8)",{"$nulls":4},"(space)"]
["3D, creates a range which refers cells on different worksheets =SUM(Sheet1:Sheet3!C7:C8)"]

{"sheet":"IF Statements","index":26,"n_rows":51,"n_cols":5,"rows_kept":51,"merged":[[4,0,4,1]]}
[]
[null,null,"IF Statements"]
[]
["See Section 4 Notes"]
["Arguments ",null,"Explaination","Forumla or Function","Function Name"]
[{"$nulls":4},"Simple IF"]
{"$rows_empty":23}
[{"$nulls":4},"Nested IF"]
{"$rows_empty":20}
[{"$nulls":4},"AND OR NOT"]

{"sheet":"Lookup","index":27,"n_rows":34,"n_cols":8,"rows_kept":34,"merged":[[1,2,1,4],[4,0,4,1],[6,0,6,3],[20,0,20,3]]}
[]
[null,null,"Lookups"]
[]
[]
[]
[]
["VLOOKUP"]
[]
["Phone ID","Product","Unit Price","Quantity in Stock",null,"Type in Phone ID",10857]
[10234,"Samsung Noire",99,45]
[10235,"Sony Ericsson F305",99,51]
[10245,"Samsung Adidas MiCoach",99,23]
[10556,"Motorola W230",29,53]
[10857,"Samsung J700",59,35]
[10987,"Sony Ericsson C905",389,15]
[11983,"Samsung L700 Purple",89,23,null,"Mobile",{"$f":"VLOOKUP(G9,Phones,2,FALSE)","v":"Samsung J700"},"VLOOKUP"]
[12576,"Samsung Tocco Pink",269,20,null,"Unit Price",{"$f":"VLOOKUP(G9,Phones,3,FALSE)","v":59},"VLOOKUP"]
[12985,"Sony Ericsson T303",59,64,null,"Qty in Stock",{"$f":"VLOOKUP(G9,Phones,4,FALSE)","v":35},"VLOOKUP"]
[19883,"Nokia 5220",119,31]
[]
["HLOOKUP"]
[]
["Location","Gort","Headford","Loughrea","Oughterard","Tuam"]
["Contact","Mark O Shea","Peter Flynn","Sue Barrett","Tina Moore","John Lynch"]
["Distance",19,16,28,15,22]
[]
[null,"Rate per Mile",{"v":0.75,"d":"€0.75"}]
[]
["Date","Location","Contact","Distance","Expenses"]
["2003-08-04","Tuam",{"$f":"HLOOKUP(B30,Distance,2,FALSE)","v":"John Lynch"},{"$f":"HLOOKUP(B30,Distance,3,FALSE)","v":22},{"$f":"D30*$C$27","v":{"v":16.5,"d":"€16.50"}},"HLOOKUP"]
["2003-08-04","Headford",{"$nulls":3},"Absolute Cell Referencing"]
["2003-08-05","Loughrea"]
["2003-08-05","Gort"]
["2003-08-05","Oughterard"]

{"sheet":"Mathematical Functions","index":28,"n_rows":85,"n_cols":6,"rows_kept":85,"merged":[[4,0,4,1],[7,0,9,0],[10,0,12,0],[13,0,16,0],[17,0,18,0],[20,0,24,0],[25,0,29,0],[33,0,33,1],[33,8,33,9],[51,1,51,2],[52,1,52,2],[53,1,53,2],[54,1,54,2],[67,0,67,2]]}
[]
[null,null,"Mathematical Functions"]
[]
["See Section 4 Notes"]
["Arguments ",null,"Explaination","Forumla or Function","Function Name"]
["INT",-45.9856321,"Rounds a number down to the nearest integer.",{"$f":"INT(B6)","v":-46},"INT"]
["POWER",4,"Returns a number raised to a power. ",{"$f":"POWER(B7,2)","v":16},"POWER"]
["ROUND",45.9856821145,"Rounds anumber to a specified number of digits.",{"$f":"ROUND(B8,4)","v":45.9857},"ROUND"]
[null,89.2232123,"Rounds a number up away from zero.",{"$f":"ROUNDUP(B9,3)","v":89.224},"ROUNDUP"]
[null,45.897456,"Rounds a number down, toward zero. ",{"$f":"ROUNDDOWN(B10,2)","v":45.89},"ROUNDDOWN"]
["Square Root",22500,"Returns the positive Square Root of a number. ",{"$f":"SQRT(B11)","v":150},"SQRT"]
[null,50625,null,{"$f":"SQRT(B12)","v":225},"SQRT"]
[null,90000,null,{"$f":"SQRT(B13)","v":300},"SQRT"]
["SUM",21,"Add the numbers in a range of cells. ",{"$f":"SUM(B14:B17)","v":175},"SUM"]
[null,51]
[null,58]
[null,45]
["RAND",null,"Generates a Random number between 0 and 1. ",{"$f":"RAND()","v":0.8557250655153168},"RAND"]
[null,null,"Multiply by 100 to get a whole number. ",{"$f":"RAND()*100","v":88.39771339629932},"RAND "]
["RANDBETWEEN",null,"Returns a random number between those specified. ",{"$f":"RANDBETWEEN(1,111)","v":71},"RANDBETWEEN"]
["EVEN",1.8,"Rounds a number up to the nearest even integer. ",{"$f":"EVEN(B21)","v":2},"EVEN"]
[null,3,null,{"$f":"EVEN(B22)","v":4},"EVEN"]
[null,2.15,null,{"$f":"EVEN(B23)","v":4},"EVEN"]
[null,-1.5,"When the number is negative it rounds away from zero.",{"$f":"EVEN(B24)","v":-2},"EVEN"]
[null,-6.9,null,{"$f":"EVEN(B25)","v":-8},"EVEN"]
["ODD",1.5,"Rounds a number up to the nearest odd integer. ",{"$f":"ODD(B26)","v":3},"ODD"]
[null,3,null,{"$f":"ODD(B27)","v":3},"ODD"]
[null,2.15,null,3,"ODD"]
[null,-1.5,"When the number is negative it rounds away from zero. ",-3,"ODD"]
[null,-6.9,null,{"$f":"ODD(B30)","v":-7},"ODD"]
[]
[]
[]
["Try it Yourself Examples",null,null,"Answer Here","Result","Show Answers"]
["Question 1"]
["Product ID","Weight (grams)","Rounded Down Using INT"]
[1,125.361]
[2,25.6542]
[3,124.895]
[4,32.654]
[5,21.5984]
[6,12.354]
[7,45.976]
[8,56.456]
[]
["Question 2"]
[1,"Kilobyte equals"," = POWER(2,10)*A40"]
[1,"Megabyte equals"," = POWER(2,20)*A41"]
[1,"Gigabyte"," = POWER(2,30)*A42"]
[]
["Using the above information covert the following to Bytes using POWER:"]
[512,"Kilobyte Cache =",null,null,"Bytes"]
[256,"Megabytes of RAM =",null,null,"Bytes"]
[16,"Megabytes Video Memory =",null,null,"Bytes"]
[40,"Gigabyte Hard Disk = ",null,null,"Bytes"]
[]
["Question 3"]
["Calculate the area of each of the following circiles using POWER:"]
["Circle Radius (cm)","Area"]
[25]
[54]
[12]
[89]
[31]
[]
[]
[]
["SUMIF "]
[]
["Monday Sales"]
[]
["Customer ","Product","Amount"]
["Tony Leahy","Apples",250,1,{"$f":"SUMIF(C73:C81,\">=200\",D73:D81)","v":9},"Example with comparison operator. "]
["Sinead Donovan","Bananas",100,2]
["Peter Smith","Apples",300,3]
["Stephen Connors","Pears",75,4]
["Seamus O'Neill","Bananas",80,5]
["Gary Jennings","Bananas",150,1]
["Mike Healy","Apples",200,2]
["Eileen Carr","Pears",300,3]
["Christine Flynn","Apples",50,4]
[]
["Total Sales of Apples",null,{"$f":"SUMIF(B73:B81,\"Apples\",C73:C81)","v":800}]
["Total Sales of Bananas",null,{"$f":"SUMIF(B73:B81,\"Bananas\",C73:C81)","v":330}]
["Total Sales of Pears",null,{"$f":"SUMIF(B73:B81,\"Pears\",C73:C81)","v":375}]

{"sheet":"Statistical Functions","index":29,"n_rows":99,"n_cols":9,"rows_kept":99,"merged":[[1,2,1,3],[4,0,4,1]]}
[]
[null,null,"Statistical Functions"]
[]
[]
[]
["AVERAGE",21,"Average number of a list of numbers."]
[null,51]
[null,24]
[null,3]
[null,18]
[null,{"$f":"AVERAGE(B6:B10)","v":23.4}]
[]
[]
["AVERAGEIF","Product A",54]
[null,"Product A",26]
[null,"Product C",84]
[null,"Product B",16]
[null,"Product A",4]
[null,null,{"$f":"AVERAGEIF(C14:C18,\">50\")","v":69},"Average if number is greater than 50. "]
[null,null,{"$f":"AVERAGEIF(B14:B18,\"Product A\",C14:C18)","v":28},"Average if product is Product A. "]
[]
[]
[]
["MAX",48,null,"MIN",48]
[null,51,null,null,51]
[null,5.12354,null,null,5.12354]
[null,45678,null,null,45678]
[null,-123546,null,null,-123546]
[null,{"$f":"MAX(B24:B28)","v":45678},null,null,{"$f":"MIN(E24:E28)","v":-123546}]
[]
[]
[]
["COUNT",null,4,5,"Counts the number of cells that contain numbers. "]
[{"$nulls":3},3]
[null,1,null,1]
[null,null,24]
[null,{"$f":"COUNT(B33:D36)","v":6}]
[]
[]
[]
["COUNTA","Seventeen","A",null,"Counts any cells that are not empty. "]
[null,4,6,"l"]
[{"$nulls":3},8]
[null,0,"Twenty four"]
[null,null,"Mary"]
[null,{"$f":"COUNTA(B41:D45)","v":9}]
[]
["COUNTIF",{"$nulls":4},"COUNTIF"]
[null,null,7,6,{"$nulls":3},7,"Cat"]
[null,7,8,7,null,null,"Cat",8,"Dog"]
[null,7,{"$nulls":4},"Cat"]
[{"$nulls":3},7,{"$nulls":4},"Cat"]
[]
[null,{"$f":"COUNTIF(B48:D53,7)","v":5},{"$nulls":4},{"$f":"COUNTIF(G48:I53,\"Cat\")","v":4}]
[]
[]
["COUNTIF","Apples",32]
[null,"Apples",54]
[null,"Oranges",62]
[null,"Peaches",12]
[null,"Apples",54]
[null,"Peaches",36]
[null,"Oranges",54]
[null,{"$f":"COUNTIF(B57:B63,\"Apples\")","v":3},"Apples"]
[null,{"$f":"COUNTIF(B57:B63,B59)","v":2},"Oranges using B59"]
[null,{"$f":"COUNTIF(B57:B63,B58)+COUNTIF(B57:B63,B59)","v":5},"Apples and Oranges"]
[null,{"$f":"COUNTIF(C57:C63,\">40\")","v":4},"Cells with value greater than 40"]
[null,{"$f":"COUNTIF(C57:C63,\"<>\"&C61)","v":4},"Number of cells not equal to 54."]
[null,{"$f":"COUNTIF(C57:C63,\">=30\")-COUNTIF(C57:C63,\">50\")","v":2},"Number of cells greater than or equal to 30 and less than 50"]
[]
[]
[]
["MEDIAN",2]
[null,7]
[null,15]
[null,13]
[null,16]
[null,{"$f":"MEDIAN(B72:B77)","v":13}]
[]
[]
[]
["MODE",21]
[null,45]
[null,12]
[null,21]
[null,65]
[null,35]
[null,12]
[null,{"$f":"_xlfn.MODE.SNGL(B82:B88)","v":21}]
[]
[]
[]
["SMALL",45]
[null,87]
[null,2]
[null,12]
[null,65]
[null,32]
[null,{"$f":"SMALL(B93:B98,3)","v":32},"2nd Smallest Number on the List"]

{"sheet":"Text Functions","index":30,"n_rows":58,"n_cols":6,"rows_kept":58,"merged":[[1,2,1,3],[4,0,4,1],[11,1,11,3],[33,1,33,2],[33,3,33,4],[47,1,47,3]]}
[]
[null,null,"Text Functions"]
[]
[]
[]
["CONCATENATE",null,"First Name","Surname","Address","Balance"]
[null,null,"Tom","Treanor","Clontibret",{"v":32,"d":"€32.00"}]
[null,null,"Mary","McKenna","Clones",{"v":45,"d":"€45.00"}]
[null,null,"Jane","Kerr","Magheracloone",{"v":65,"d":"€65.00"}]
[]
[null,{"$f":"CONCATENATE(C7,\" \",D7)","v":"Tom Treanor"}]
[null,{"$f":"CONCATENATE(C8,\" \",D8,\" from \",E8,\" owes €\",F8,\".\")","v":"Mary McKenna from Clones owes €45."}]
[null,{"$f":"C7&\" \"&D7","v":"Tom Treanor"},"The ampersand can also be used to join text. "]
[]
[]
["LEFT","Mary",{"$f":"LEFT(B16)","v":"M"}]
[null,"Mr McKenna",{"$f":"LEFT(B17,2)","v":"Mr"}]
[null,"Sale Price",{"$f":"LEFT(B18,4)","v":"Sale"}]
[]
[]
[]
["LOWER","AlPHAbet Soup",{"$f":"LOWER(B22)","v":"alphabet soup"}]
[null,"Sara",{"$f":"LOWER(B23)","v":"sara"}]
[null,"THREE 3","three 3"]
[]
[]
[]
["MID","Drove 340 miles",{"$f":"MID(B28,7,3)","v":"340"}]
[null,"Drove 273 miles",{"$f":"MID(B29,7,3)","v":"273"}]
[null,"Drove 234 miles","234"]
[]
[]
[]
["PROPER","this SENTENCE IS not propER",null,{"$f":"PROPER(B34)","v":"This Sentence Is Not Proper"}]
[null,"mARY jONES ",null,{"$f":"PROPER(B35)","v":"Mary Jones "}]
[null,"15 green lane",null,{"$f":"PROPER(B36)","v":"15 Green Lane"}]
[null,"TRIAL BALANCE",null,{"$f":"PROPER(B37)","v":"Trial Balance"}]
[]
[]
[]
["RIGHT","Right Price",{"$f":"RIGHT(B41,5)","v":"Price"}]
[null,"Green",{"$f":"RIGHT(B42)","v":"n"}]
[null,"273 miles",{"$f":"RIGHT(B43,5)","v":"miles"}]
[]
[]
[]
["TRIM","           When        text has spaces        that are        not    needed use         TRIM!"]
[null,{"$f":"TRIM(B47)","v":"When text has spaces that are not needed use TRIM!"}]
[]
[]
[]
["UPPER","income tax",{"$f":"UPPER(B52)","v":"INCOME TAX"}]
[null,"Green Lane",{"$f":"UPPER(B53)","v":"GREEN LANE"}]
[null,"mAry jones","MARY JONES"]
[]
[]
[{"$nulls":3}," "]
["REPT","James ",{"$f":"REPT(B58,3)","v":"James James James "}]

{"sheet":"Financial Functions","index":31,"n_rows":161,"n_cols":7,"rows_kept":161,"merged":[[4,0,4,1],[8,2,8,3],[14,4,14,5],[15,4,15,5],[16,4,16,5],[17,4,17,5],[18,4,18,5],[20,2,20,3],[22,2,22,6],[39,2,39,3],[95,2,96,3],[99,2,99,4],[136,2,136,3],[144,5,153,5]]}
[]
[null,null,"Financial Functions"]
[]
[]
["Arguments ",null,"Explaination","Forumla or Function","Function Name"]
[]
["DB",null,"Depreciation of assets. "]
[]
["Example 1",null,"DB - Depreciation "]
[]
[null,null,"Asset","Company Van",null,"Pruchase Price",{"v":20000,"d":"€20,000.00"}]
[{"$nulls":5},"Disposal Price",{"v":5000,"d":"€5,000.00"}]
[{"$nulls":5},"Expected Life \n(years):",5]
[]
[null,null,"Year 1 Depreciation",{"$f":"DB($G$11,$G$12,$G$13,1)","v":{"v":4840,"d":"€4,840.00"}},"Value after year 1",null,{"$f":"G11-D15","v":{"v":15160,"d":"€15,160.00"}}]
[null,null,"Year 2 Depreciation",{"$f":"DB($G$11,$G$12,$G$13,2)","v":{"v":3668.72,"d":"€3,668.72"}},"Value after year 2",null,{"$f":"G15-D16","v":{"v":11491.28,"d":"€11,491.28"}}]
[null,null,"Year 3 Depreciation",{"$f":"DB($G$11,$G$12,$G$13,3)","v":{"v":2780.88976,"d":"€2,780.89"}},"Value after year 3",null,{"$f":"G16-D17","v":{"v":8710.39024,"d":"€8,710.39"}}]
[null,null,"Year 4 Depreciation",{"$f":"DB($G$11,$G$12,$G$13,4)","v":{"v":2107.9144380800003,"d":"€2,107.91"}},"Value after year 4",null,{"$f":"G17-D18","v":{"v":6602.47580192,"d":"€6,602.48"}}]
[null,null,"Year 5 Depreciation",{"$f":"DB($G$11,$G$12,$G$13,5)","v":{"v":1597.79914406464,"d":"€1,597.80"}},"Value after year 5",null,{"$f":"G18-D19","v":{"v":5004.67665785536,"d":"€5,004.68"}}]
[]
["Example 2",null,"DB - Depreciation "]
[]
[null,null,"Depreciation Schedule"]
[]
[null,null,"Asset","Company Car","Machinery","Computer","Truck"]
[null,null,"Purchase Price",34500,120000,900,42800]
[null,null,"Disposal Value",8500,20000,300,12500]
[null,null,"Expected Life (years)",5,8,4,6]
[]
[null,null,"Year 1 Depreciation",{"$f":"DB($D$26,$D$27,$D$28,1)","v":{"v":8418,"d":"€8,418.00"}},{"$f":"DB($E$26,$E$27,$E$28,1)","v":{"v":24120,"d":"€24,120.00"}},{"$f":"DB($F$26,$F$27,$F$28,1)","v":{"v":216,"d":"€216.00"}},{"$f":"DB($G$26,$G$27,$G$28,1)","v":{"v":7918,"d":"€7,918.00"}}]
[null,null,"Year 2 Depreciation",{"$f":"DB($D$26,$D$27,$D$28,2)","v":{"v":6364.008,"d":"€6,364.01"}},{"$f":"DB($E$26,$E$27,$E$28,2)","v":{"v":19271.88,"d":"€19,271.88"}},{"$f":"DB($F$26,$F$27,$F$28,2)","v":{"v":164.16,"d":"€164.16"}},{"$f":"DB($G$26,$G$27,$G$28,2)","v":{"v":6453.17,"d":"€6,453.17"}}]
[null,null,"Year 3 Depreciation",{"$f":"DB($D$26,$D$27,$D$28,3)","v":{"v":4811.1900479999995,"d":"€4,811.19"}},{"$f":"DB($E$26,$E$27,$E$28,3)","v":{"v":15398.23212,"d":"€15,398.23"}},{"$f":"DB($F$26,$F$27,$F$28,3)","v":{"v":124.7616,"d":"€124.76"}},{"$f":"DB($G$26,$G$27,$G$28,3)","v":{"v":5259.33355,"d":"€5,259.33"}}]
[null,null,"Year 4 Depreciation",{"$f":"DB($D$26,$D$27,$D$28,4)","v":{"v":3637.2596762879994,"d":"€3,637.26"}},{"$f":"DB($E$26,$E$27,$E$28,4)","v":{"v":12303.18746388,"d":"€12,303.19"}},{"$f":"DB($F$26,$F$27,$F$28,4)","v":{"v":94.81881600000001,"d":"€94.82"}},{"$f":"DB($G$26,$G$27,$G$28,4)","v":{"v":4286.356843250001,"d":"€4,286.36"}}]
[null,null,"Year 5 Depreciation",{"$f":"DB($D$26,$D$27,$D$28,5)","v":{"v":2749.7683152737277,"d":"€2,749.77"}},{"$f":"DB($E$26,$E$27,$E$28,5)","v":{"v":9830.24678364012,"d":"€9,830.25"}},null,{"$f":"DB($G$26,$G$27,$G$28,5)","v":{"v":3493.3808272487504,"d":"€3,493.38"}}]
[null,null,"Year 6 Depreciation",null,{"$f":"DB($E$26,$E$27,$E$28,6)","v":{"v":7854.367180128455,"d":"€7,854.37"}},null,{"$f":"DB($G$26,$G$27,$G$28,6)","v":{"v":2847.1053742077315,"d":"€2,847.11"}}]
[null,null,"Year 7 Depreciation",null,{"$f":"DB($E$26,$E$27,$E$28,7)","v":{"v":6275.639376922636,"d":"€6,275.64"}}]
[null,null,"Year 8 Depreciation",null,{"$f":"DB($E$26,$E$27,$E$28,8)","v":{"v":5014.235862161186,"d":"€5,014.24"}}]
[null,null,"Depreiciation + Disposal",{"$f":"SUM(D30:D37)+D27","v":{"v":34480.22603956172,"d":"€34,480.23"}},{"$f":"SUM(E30:E37)+E27","v":{"v":120067.78878673239,"d":"€120,067.79"}},{"$f":"SUM(F30:F37)+F27","v":{"v":899.740416,"d":"€899.74"}},{"$f":"SUM(G30:G37)+G27","v":{"v":42757.34659470648,"d":"€42,757.35"}}]
[]
["Example 3",null,"DB - Depreciation "]
[]
[null,null,"Fixed Assets","Premises","Machinery","Vechiles"]
[null,null,"Cost",{"v":350000,"d":"£350,000.00"},{"v":75000,"d":"£75,000"},{"v":220000,"d":"£220,000"}]
[null,null,"Depreciation",{"$f":"DB(350000,150000,20,20)","v":{"v":6477.470403568357,"d":"£6,477.47"}},{"$f":"DB(75000,25000,5,5)","v":{"v":6143.129501756775,"d":"£6,143.13"}},{"$f":"DB(220000,30000,4,4)","v":{"v":19382.93260288,"d":"£19,382.93"}}]
[null,null,"NBV",{"$f":"D43-D44","v":{"v":343522.52959643165,"d":"£343,522.53"}},{"$f":"E43-E44","v":{"v":68856.87049824322,"d":"£68,856.87"}},{"$f":"F43-F44","v":{"v":200617.06739712,"d":"£200,617.07"}}]
[]
[]
["FV",null,"Future value of pension/investment scheme."]
["Example 1"]
["Data",null,"Description"]
[0.06,null,"Annual Interest Rate","rate"]
[10,null,"Number of Payments","nper"]
[-200,null,"Amount of the payment","pmt"]
[-500,null,"Present value","pv"]
[1,null,"Payment is due at the beginning of the period. ","type"]
[]
["Result",null,"Description"]
[{"$f":"FV(A51/12,A52,A53,A54,A55)","v":{"v":2581.4033740601185,"d":"€2,581.40"}},null,"Future value of an investment using the terms from A2:A5."]
[]
["Example 2",null,"Savings Fund for employees"]
[null,null,"Savings",20]
[null,null,"Interest",{"v":0.032,"d":"3.20%"}]
[null,null,"Ten Year Period",120]
[{"$nulls":3},{"$f":"FV(D62/12,D63,-D61)","v":{"v":2824.0601790184587,"d":"€2,824.06"}}]
[]
[]
["NPV",null,"Net Present Value"]
["Example 1"]
["Data",null,"Description"]
[0.1,null,"Annual Discount Rate","rate"]
[{"v":-10000,"d":"-€10,000.00"},null,"Initial cost of investment one year from today.","value1"]
[{"v":3000,"d":"€3,000.00"},null,"Return from the first year.","value2"]
[{"v":4200,"d":"€4,200.00"},null,"Return from the second year.","value3"]
[{"v":6800,"d":"€6,800.00"},null,"Return from the third year. ","value4"]
[]
["Result",null,"Description"]
[{"$f":"NPV(A70,A71,A72,A73,A74)","v":{"v":1188.4434123352207,"d":"€1,188.44"}},null,"Future value of an investment using the terms from A2:A5."]
[]
[]
["Example 2",null,"Stocking Loan Details","Description"]
[null,null,0.04,"Interest Rate"]
[null,null,{"v":-20000,"d":"-€20,000.00"},"Loan Value"]
[null,null,{"v":5000,"d":"€5,000.00"},"payments year 1"]
[null,null,{"v":2000,"d":"€2,000.00"},"payments year 2"]
[null,null,{"$f":"NPV(C81,C83:C84)+C82","v":{"v":-13343.195266272189,"d":"-€13,343.20"}},"Balance"]
[]
[]
["PMT",null,"Principle per month of a loan repayment."]
["Example 1"]
["Data",null,"Description"]
[{"v":0.06,"d":"6%"},null,"Annual Interest Rate","rate"]
[180,null,"Number of months of payment","nper"]
[{"v":180000,"d":"€180,000"},null,"Amount of loan","pv"]
[]
["Result",null,"Description"]
[{"$f":"PMT(A91/12,A92,A93)","v":{"v":-1518.9422904872124,"d":"-€1,518.94"}},null,"Monthly payment for a loan with terms specified as arguments in A91:A93, payments are due at the beginning of the month. "]
[]
[]
["Example 2"]
["PPMT",null,"Amount of Principle paid off Bank Loan"]
[]
[null,null,"Bank Loan",null,{"v":50000,"d":"€ 50,000.00"}]
[null,null,"Annual Interest Rate",null,{"v":0.07,"d":"7%"}]
[null,null,"Number of Years of Loan",null,10]
[null,null,"Payment Date",null," End of Each Month"]
[null,null,"Month of Payment",null,"5th"]
[]
[null,null,"Bank Loan","Annual Interest Rate","Number of Yrs of Loan","Amount of Priniciple Paid off"]
[null,null,{"v":50000,"d":"€50,000.00"},{"v":0.07,"d":"7%"},10,{"$f":"PPMT(7%/12,5,10*12,-50000,0,0)","v":{"v":295.6753716042946,"d":"€295.68"}}]
[]
[]
["PV",null,"Present Value"]
[]
["Data",null,"Description"]
[{"v":500,"d":"€500.00"},null,"Money paid out of an insurance annuity at the end of every month.","pmt"]
[{"v":0.08,"d":"8%"},null,"Interest rate earned on the money paid out. ","rate"]
[20,null,"Years the money will be paid out. ","nper*12"]
[]
["Result",null,"Description"]
[{"$f":"PV(A116/12,12*A117,A115,,0)","v":{"v":-59777.14585118782,"d":"-€59,777.15"}},null,"Present value of an annuity with the terms A115:A117."]
[]
[]
[]
["SLN",null,"Straight Line Depreciation of an asset for one period. "]
[]
["Example 1",null,"Vehicle","Original Cost"]
[null,null,"Red Transit - MN 10 444",{"v":45000,"d":"€45,000.00"}]
[null,null,"White  Toyota MN 09 434",{"v":32000,"d":"€32,000.00"}]
[null,null,"Blue People Carrier MN 10 585",{"v":36000,"d":"€36,000.00"}]
[]
["Life (Years)",null,"Salvage Value","Annual Depreciation "]
[7,null,{"v":5000,"d":"€5,000.00"},{"$f":"SLN(D127,C132,A132)","v":{"v":5714.285714285715,"d":"€5,714.29"}}]
[7,null,{"v":3000,"d":"€3,000.00"},{"$f":"SLN(D128,C133,A133)","v":{"v":4142.857142857143,"d":"€4,142.86"}}]
[7,null,{"v":4000,"d":"€4,000.00"},{"$f":"SLN(D129,C134,A134)","v":{"v":4571.428571428572,"d":"€4,571.43"}}]
[]
[]
["Example 2",null,"SLN - Straight Line Depreciation"]
[]
[null,null,"Cost",{"v":10000,"d":"€10,000.00"}]
[null,null,"Salvage value",{"v":1000,"d":"€1,000.00"}]
[null,null,"Life - Years of useful life",10]
[]
[null,null,"Depreciation Value"]
[null,null,"Period","SLN","Value"]
[null,null,1,{"$f":"SLN($D$139,$D$140,$D$141)","v":{"v":900,"d":"€900.00"}},{"$f":"$D$139-D145","v":{"v":9100,"d":"€9,100.00"}},"Subtract this value 10 times and the asset depreciates from 10,000 to 1,000 in to years.  "]
[null,null,2,{"v":900,"d":"€900.00"},{"$f":"E145-D146","v":{"v":8200,"d":"€8,200.00"}}]
[null,null,3,{"v":900,"d":"€900.00"},{"$f":"E146-D147","v":{"v":7300,"d":"€7,300.00"}}]
[null,null,4,{"v":900,"d":"€900.00"},{"v":6400,"d":"€6,400.00"}]
[null,null,5,{"v":900,"d":"€900.00"},{"v":5500,"d":"€5,500.00"}]
[null,null,6,{"v":900,"d":"€900.00"},{"v":4600,"d":"€4,600.00"}]
[null,null,7,{"v":900,"d":"€900.00"},{"v":3700,"d":"€3,700.00"}]
[null,null,8,{"v":900,"d":"€900.00"},{"v":2800,"d":"€2,800.00"}]
[null,null,9,{"v":900,"d":"€900.00"},{"v":1900,"d":"€1,900.00"}]
[null,null,10,{"v":900,"d":"€900.00"},{"v":1000,"d":"€1,000.00"}]
[]
[]
[]
[]
[null,null,"References:"]
[null,null,"5 Different Types of Depreciaton "]
[null,null,"http://www.excel-easy.com/examples/depreciation.html "]

{"sheet":"Database Functions","index":32,"n_rows":28,"n_cols":9,"rows_kept":28,"merged":[[1,2,1,3],[4,0,4,1]]}
[]
[null,null,"Database Functions"]
[]
[]
[]
["Database "]
[]
["Date","Order ID","SalesRep","Customer","Sale"]
[null,21553,"Beth","DB Foods"]
[]
["Date","Order ID","SalesRep","Customer","Sale"]
["2014-06-15",21543,"John","DB Foods",{"v":12563,"d":"€12,563.00"},null,"DAVERAGE",{"$f":"DAVERAGE(SalesDB,E8,C8:C9)","v":{"v":6201.6,"d":"€6,201.60"}},"The average sale for Beth."]
["2014-06-16",21544,"Beth","Value Buy",{"v":4500,"d":"€4,500.00"},null,"DCOUNT",{"$f":"DCOUNT(SalesDB,E8,D8:D9)","v":5},"The number of times DB Foods bought products from us. "]
["2014-06-19",21545,"Simon","DB Foods",{"v":6423,"d":"€6,423.00"},null,"DCOUNTA",{"$f":"DCOUNTA(SalesDB,E8,E8:E9)","v":17},"Counts the total number of sales."]
["2014-06-19",21546,"John","MC Ltd. ",{"v":1245,"d":"€1,245.00"},null,"DGET",{"$f":"DGET(SalesDB,E8,B8:B9)","v":{"v":1258,"d":"€1,258.00"}},"Gets the sale total for Order ID 21553. "]
["2014-06-19",21547,"Simon","Treanors",{"v":3489,"d":"€3,489.00"},null,"DMAX",{"$f":"DMAX(SalesDB,E8,C8:C9)","v":{"v":12563,"d":"€12,563.00"}},"The maximum sale for Beth. "]
["2014-06-21",21548,"John","Value Buy",{"v":1568,"d":"€1,568.00"},null,"DMIN",{"$f":"DMIN(SalesDB,E8,C8:C9)","v":{"v":892,"d":"€892.00"}},"The minimum sale for Beth. "]
["2014-06-23",21549,"Beth","MC Ltd. ",{"v":11489,"d":"€11,489.00"}]
["2014-06-23",21550,"Beth","Treanors",{"v":1564,"d":"€1,564.00"}]
["2014-06-25",21551,"John","DB Foods",{"v":25250,"d":"€25,250.00"}]
["2014-06-27",21552,"Simon","Wholesale",{"v":3549,"d":"€3,549.00"}]
["2014-06-30",21553,"Simon","MC Ltd. ",{"v":1258,"d":"€1,258.00"}]
["2014-07-01",21554,"John","DB Foods",{"v":4985,"d":"€4,985.00"}]
["2014-07-01",21555,"John","Treanors",{"v":2587,"d":"€2,587.00"}]
["2014-07-02",21556,"Simon","DB Foods",{"v":3451,"d":"€3,451.00"}]
["2014-07-02",21557,"Beth","Value Buy",{"v":892,"d":"€892.00"}]
["2014-07-02",21558,"Simon","Value Buy",{"v":10456,"d":"€10,456.00"}]
["2014-07-05",21559,"Beth","MC Ltd. ",{"v":12563,"d":"€12,563.00"}]

{"sheet":"Section 6 Notes ","index":33,"n_rows":4,"n_cols":4,"rows_kept":4,"merged":[[2,3,2,8],[3,3,3,8]]}
[]
[]
[{"$nulls":3},"Level 6 Spreadsheet 6N4089"]
[{"$nulls":3},"Section 6 – Macros and Auditing"]

{"sheet":"Trace Errors","index":34,"n_rows":15,"n_cols":4,"rows_kept":15,"merged":[[4,0,4,1]]}
[]
[null,null,"Trace Errors"]
[]
[]
[]
[]
[]
[null,"Value Error",null,"Ref Error"]
[null,20]
[null,50,null,98]
[null,90,null,0]
[null,25,null,{"$f":"D10/D11","v":{"$error":"#DIV/0!"}}]
[null,"O"]
[null,14]
[null,{"$f":"B9+B10+B11+B12+B13+B14","v":{"$error":"#VALUE!"}}]

{"sheet":"Section 7 Notes","index":35,"n_rows":4,"n_cols":4,"rows_kept":4,"merged":[[2,3,2,8],[3,3,3,8]]}
[]
[]
[{"$nulls":3},"Level 6 Spreadsheet 6N4089"]
[{"$nulls":3},"Section 7 – Data Validation and Protection"]

{"sheet":"Data Validation","index":36,"n_rows":36,"n_cols":10,"rows_kept":36,"merged":[[4,0,4,1]]}
[]
[null,null,"Data Validation"]
[]
["See Section 7 Notes"]
["Arguments ",null,"Explaination","Forumla or Function","Function Name"]
[]
[{"$nulls":3},"Employee",null,null,"Eileen"]
["Data Validation in a drop down list.",null,null,"Sarah",null,null,"Jane"]
[{"$nulls":3},"Yes / No",null,null,"Mary"]
["Data Validation with a drop down list.",null,null,"Yes",null,null,"Sarah"]
[{"$nulls":6},"Theresa"]
["Data Vailidation between two numbers - Whole number within limits",null,null,44,null,null,"Thomas",150]
[{"$nulls":7},99]
["Decimal Number within Limits - Bonus no greater than 6% of Salary.",null,null,"Salary",{"v":50000,"d":"€50,000.00"},null,null,54]
[{"$nulls":3},"Bonus",20,null,null,62]
[{"$nulls":7},89]
["Date within a time frame - Today, tomorrow or the day after. ",null,null,"Today",{"$f":"TODAY()","v":"2015-09-16"},null,null,35]
[{"$nulls":3},"2014-07-30",{"$nulls":3},{"$f":"AVERAGE(H12:H17)","v":81.5},"Average"]
[]
[]
["Date between two dates - 01/01/2010 and 01/01/2020.",null,null,"2014-05-01"]
[]
["Time within a time frame - within the next 5 hours. ",null,null,"Time ","09:00:00"]
[{"$nulls":3},"08:00:00",{"$nulls":3},"Maximum Budget",null,{"v":500,"d":"€500.00"}]
[]
[{"$nulls":3},"Limit to 5 Characters",{"$nulls":3},"Total Spent",null,450]
["Text of a specified length.",null,null,"Mr"]
[]
[]
[]
["Only numbers greater than the average.",null,null,68]
[]
[]
[]
[]
[{"$nulls":4}," "]

{"sheet":"Protect Cells in a Worksheet","index":37,"n_rows":36,"n_cols":12,"rows_kept":36,"merged":[[1,2,1,3],[4,0,4,1]]}
[]
[null,null,"Protect Cells in a Worksheet"]
[]
["See Section 7 Notes"]
[]
[]
[]
["Code","Furniture Item","Quantity Bought","Cost Price per Item","Total Cost Price per Item","Selling Price per Item","Total Selling Price per Item","Profit on Each Item",null,null,"Password: ","pass"]
["HG7654","Tables",60,{"v":95,"d":"€95.00"},{"$f":"C9*D9","v":{"v":5700,"d":"€5,700.00"}},{"v":120,"d":"€120.00"},{"$f":"C9*F9","v":{"v":7200,"d":"€7,200.00"}},{"$f":"G9-E9","v":{"v":1500,"d":"€1,500.00"}}]
["KL9876","Chairs",85,{"v":88,"d":"€88.00"},{"$f":"C10*D10","v":{"v":7480,"d":"€7,480.00"}},{"v":130,"d":"€130.00"},{"$f":"C10*F10","v":{"v":11050,"d":"€11,050.00"}},{"$f":"G10-E10","v":{"v":3570,"d":"€3,570.00"}},null,null,"Unprotected Cells are:"]
["LP9876","Cabinets",96,{"v":56,"d":"€56.00"},{"v":5376,"d":"€5,376.00"},{"v":80,"d":"€80.00"},{"v":7680,"d":"€7,680.00"},{"v":2304,"d":"€2,304.00"},null,null,"A9:D15"]
["YT9876","Dressers",52,{"v":79,"d":"€79.00"},{"v":4108,"d":"€4,108.00"},{"v":90,"d":"€90.00"},{"v":4680,"d":"€4,680.00"},{"v":572,"d":"€572.00"},null,null,"F9:D15"]
["JT7654","Hall Tables",73,{"v":51,"d":"€51.00"},{"v":3723,"d":"€3,723.00"},{"v":77,"d":"€77.00"},{"v":5621,"d":"€5,621.00"},{"v":1898,"d":"€1,898.00"}]
["KJ7654","Telephone Tables",55,{"v":63,"d":"€63.00"},{"v":3465,"d":"€3,465.00"},{"v":80,"d":"€80.00"},{"v":4400,"d":"€4,400.00"},{"v":935,"d":"€935.00"}]
["LO9808","Mirrors",90,{"v":80,"d":"€80.00"},{"v":7200,"d":"€7,200.00"},{"v":100,"d":"€100.00"},{"v":9000,"d":"€9,000.00"},{"v":1800,"d":"€1,800.00"}]
{"$rows_empty":20}
[{"$nulls":4}," "]

{"sheet":"References","index":38,"n_rows":5,"n_cols":2,"rows_kept":5}
[]
[]
[]
[null,"300 Excel Examples"]
[null,"http://www.excel-easy.com/examples.html "]