Timeline Constructor

Instructions Instructions Background The 'Timeline Constructor' is based on an Excel template as well as Visual Basic code. It can draw up timelines of varying proportions and date ranges incorporating personalities or events, categorised by colour cod Both AH and CE years may be specified in the 'Settings' Only AH years may be used in 'Birth' and 'Death' date columns in 'Data' worksheet However, you can use the following formulas to convert to AH from CE AH = 1.030684*(CE-621.5643) rounded with the INT() function Step by Step The Timeline Constructor comes with a sample data list of names and birth/death and other data Click on 'Data' tab to view the sample data It is also set up with default settings for the various parameters that can be specified Click on 'Settings' tab to review the settings Now press the 'Generate Timeline' button and watch as the data items are inserted in the correct places on the grid Information from the 'Other Information' column in 'Data' is inserted as a note. Hover over an entry with the mouse and see the pop up note. The Grid button toggles the grid on 'Timeline' sheet To enter your own data, delete or overwrite the sample entries (though leave the headings intact) on 'Data' You are free to choose different, or no, colours for category You are free to specify any font, size and colour for 'Name' Choose the appropriate View magnitude from the toolbar Ideas You can freely change the data for any group of individuals as well as events, some possibilities include: Chronology of wars in Islam Muslim Caliphs and Kings juxtaposed with Imams [a] Et cetera, et cetera. Allow for unknown birth dates by using an average age such as 75 This is a spreadsheet, feel free to use formulas in the 'Data' worksheet Use different fonts, sizes, and colours in 'Data' for the Names Use the 'category' colours imaginatively for meaningful timelines Sort the data items in any order, using standard Excel functionality, before generating timeline Once you create a timeline that you want to keep, you can copy it using standard Excel functionality You can then create a different one while keeping the other perfectly safe Please Note! There is no extensive error checking built in. The timeline generation routine will fail if: Birth Years are later than death years Any birth or death years fall outside the Start and End years in 'Settings' (Ensure you have checked or unchecked the box as appropriate) The number of columns needed exceed around 255 Try increasing the Interval If a name is so long that it overflows its box, try increasing the Column Width parameter or decreasing the Interval years If you see '###' in any column, increase the Column Width parameter in 'Settings' Page 1 Instructions or events, categorised by colour coding correct places on the grid intact) on 'Data' bilities include: decreasing the Interval years Page 2 Data Category Name Prophet Muhammad b. Abdallah [s] Lady Fatima [a] Amir al-Mu'minin Imam `Ali b. Abi Talib [a] Imam Hasan b. `Ali [a] Imam Husayn b. `Ali [a] Imam Zayn al-`Abidin [a] Imam Muhammad b. `Ali [a] Imam Ja`far b. Muhammad [a] Imam Musa b. Ja`far [a] Imam `Ali b. Musa b. Ja`far [a] Imam Muhammad b. `Ali [a] Imam `Ali b. Muhammad [a] Imam Hasan b. `Ali [a] Imam Muhammad b. al-Hasan al-Mahdi [a] Shaykh Mufid Sayyid Murtada Alam al-Huda Shaykh Abu Ja`far al-Tusi Allamah Hilli Shaheed al-Awwal Shaheed al-Thani Birth Death -52 -7 -23 3 4 38 57 80 128 148 195 212 232 255 334 355 385 648 734 911 11 11 40 50 61 94 117 148 183 203 220 254 260 1450 413 436 460 726 786 966 Page 3 Data Other Information al-Mustafa al-Zahra al-Murtaza al-Mujtaba Sayyid al-shuhada `Ali b. al-Husayn, al-Sajjad, al-Zaki al-Baqir al-Sadiq al-Kazim al-Rida al-Taqi al-Jawad al-Hadi al-Naqi al-`Askari (Still Alive!) Also called 'Ibn al-Mu`allim'. Famous works include 'al-Muqni'ah'. Famous works include 'Intisar' and 'Jamal al-Ilmi wa'al-Amal' He has several books and treatises on Fiqh, Usul, Hadith, Tafsir, Kalam, and Rijal. Hasan b. Yusuf b. Ali b. Mutahhar al-Hilli His famous work is a commentary on al-Lum`ah authored by Shaheed al-Awwal Page 4 Settings Settings for Timeline Constructor Check the box if appropriate, and specify the parameters in blue Check TRUE box if years in AH (Hijra) instead of CE (Christian Era) -60 11 1450 5.7 137 Starting year Interval (in years) Ending year Column width Number of columns (calculated) Page 5 Timeline Year from AH -60 -49 -38 -27 -16 -5 to AH -50 -39 -28 -17 -6 CE 563 574 585 595 606 6 5 617 17 16 627 28 27 638 39 38 649 50 49 659 61 60 670 71 681 Page 6 Timeline Page 7 Timeline 949 959 969 979 989 999 1009 1019 1029 1039 1049 1059 1069 1079 1089 1099 1109 1119 1129 1139 1149 1159 1169 1179 1189 1199 1209 1219 1229 1239 1249 1259 1269 1279 1289 1299 1309 1319 1329 1339 1349 1359 1369 1379 958 968 978 988 998 1008 1018 1028 1038 1048 1058 1068 1078 1088 1098 1108 1118 1128 1138 1148 1158 1168 1178 1188 1198 1208 1218 1228 1238 1248 1258 1268 1278 1288 1298 1308 1318 1328 1338 1348 1358 1368 1378 1388 1542 1552 1561 1571 1581 1590 1600 1610 1619 1629 1639 1649 1658 1668 1678 1687 1697 1707 1716 1726 1736 1746 1755 1765 1775 1784 1794 1804 1813 1823 1833 1843 1852 1862 1872 1881 1891 1901 1910 1920 1930 1940 1949 1959 Page 8 Timeline 1389 1399 1409 1419 1429 1439 1449 1459 1469 1479 1489 1398 1408 1418 1428 1438 1448 1458 1468 1478 1488 1498 1969 1978 1988 1998 2008 2017 2027 2037 2046 2056 2066 Page 9 Timeline 72 82 691 83 93 702 94 105 116 127 138 149 160 171 182 193 204 104 115 126 137 148 159 170 181 192 203 214 713 723 734 745 755 766 777 787 798 809 819 Page 10 Timeline Page 11 Timeline Page 12 Timeline Page 13 Timeline 215 226 237 248 259 270 281 292 303 314 325 336 347 225 236 247 258 269 280 291 302 313 324 335 346 357 830 841 852 862 873 884 894 905 916 926 937 948 958 Page 14 Timeline Page 15 Timeline Page 16 Timeline Page 17 Timeline 358 369 380 391 402 413 424 435 446 457 468 479 490 368 379 390 401 412 423 434 445 456 467 478 489 500 969 980 990 1001 1012 1022 1033 1044 1054 1065 1076 1086 1097 Page 18 Timeline Page 19 Timeline Page 20 Timeline Page 21 Timeline 501 512 523 534 545 556 567 578 589 600 611 622 633 511 522 533 544 555 566 577 588 599 610 621 632 643 1108 1118 1129 1140 1150 1161 1172 1182 1193 1204 1214 1225 1236 Page 22 Timeline Page 23 Timeline Page 24 Timeline Page 25 Timeline 644 655 666 677 688 699 710 721 732 743 754 765 776 654 665 676 687 698 709 720 731 742 753 764 775 786 1246 1257 1268 1278 1289 1300 1310 1321 1332 1342 1353 1364 1374 Page 26 Timeline Page 27 Timeline Page 28 Timeline Page 29 Timeline 787 798 809 820 831 842 853 864 875 886 897 908 919 797 808 819 830 841 852 863 874 885 896 907 918 929 1385 1396 1406 1417 1428 1438 1449 1460 1471 1481 1492 1503 1513 Page 30 Timeline Page 31 Timeline Page 32 Timeline Page 33 Timeline 930 941 952 963 974 985 996 1007 1018 1029 1040 1051 1062 940 951 962 973 984 995 1006 1017 1028 1039 1050 1061 1072 1524 1535 1545 1556 1567 1577 1588 1599 1609 1620 1631 1641 1652 Page 34 Timeline Page 35 Timeline Page 36 Timeline Page 37 Timeline 1073 1084 1095 1106 1117 1128 1139 1150 1161 1172 1183 1194 1205 1083 1094 1105 1116 1127 1138 1149 1160 1171 1182 1193 1204 1215 1663 1673 1684 1695 1705 1716 1727 1737 1748 1759 1769 1780 1791 Page 38 Timeline Page 39 Timeline Page 40 Timeline Page 41 Timeline 1216 1227 1238 1249 1260 1271 1282 1293 1304 1315 1326 1337 1348 1226 1237 1248 1259 1270 1281 1292 1303 1314 1325 1336 1347 1358 1801 1812 1823 1833 1844 1855 1865 1876 1887 1897 1908 1919 1929 Page 42 Timeline Page 43 Timeline Page 44 Timeline Page 45 Timeline 1359 1370 1381 1392 1403 1414 1425 1436 1369 1380 1391 1402 1413 1424 1435 1446 1940 1951 1961 1972 1983 1993 2004 2015 Page 46