tag:blogger.com,1999:blog-44898376331484000332024-02-20T03:37:34.993+10:30Spreadsheets and DatabasesUse of spreadsheets, databases and high level programming languages in industrial, manufacturing, mechanical and structural engineeringConrad Harrisonhttp://www.blogger.com/profile/11351972303793021889noreply@blogger.comBlogger56125tag:blogger.com,1999:blog-4489837633148400033.post-16221644284489494252015-10-19T15:08:00.000+10:302016-04-23T15:54:58.461+09:30Extracting wordpress posts from xml export fileA variation of the MS Excel spreadsheet,<a href="http://metamorphs-software.blogspot.com.au/2014/06/chrome-bookmarks-and-blogger-posts.html"> schGoogleToolBox.xls</a>, that I wrote for extracting posts from the Blogger xml export file. This version extracts from the wordpress xml export file, slightly more complicated as uses namespaces and CDATA elements.<br />
<br />
The objective was to extract the individual posts from the xml file, then import into <a href="https://www.literatureandlatte.com/scrivener.php">Scrivener</a>, unfortunately wordpress does strange things with html paragraph marks. Also as I am working on MS Windows my html that I wrap the exported data into to create a valid html file, resulted in combined DOS and Unix end of line markers. The wordpress post in the CDATA section contains only linefeed characters (LF) not carriage return (CR) and line feed, also no paragraph <p> markers, so the files as imported into Scrivener lost paragraph spacing.<br />
<br />
To resolve this I was just going to open and convert in <a href="http://www.ultraedit.com/products/uestudio.html">UltraEdit Studio</a> but that seemed time consuming for several files, therefore modified the vba code to replace the double LF's with, double CRLF's and double <br> codes. This produced acceptable paragraph spacing when the html files are imported to Scrivener as and converted to plain text.<br />
<br />
The spreadsheet also retrieves categories and tags, and classes these as keywords and counts the frequency of assignment.<br />
<br />
It only extracts posts with post_type='post', the vba code can be modified to get static pages, or if have a <a href="http://www.woothemes.com/woocommerce/">woocommerce </a>site can extract products.<br />
<br />
<span style="background-color: white; color: #444444; font-family: "arial" , "tahoma" , "helvetica" , "freesans" , sans-serif; font-size: 13px; line-height: 18.2px;">Spreadsheet can be down loaded: </span><a href="http://miscion.com.au/product/wordpress-tools/">schWordPressToolBox.xls</a><br />
<br />
<br />
<hr />
Revisions:<br />
[19/10/2015] Original<br />
[23/04/2016] Changed download links to MiScion Pty Ltd Web StoreConrad Harrisonhttp://www.blogger.com/profile/11351972303793021889noreply@blogger.comtag:blogger.com,1999:blog-4489837633148400033.post-18438818566080250592015-06-28T17:52:00.000+09:302016-02-01T13:39:33.037+10:30Post Footing Design : Rutledge Formula{Draft: thought I'd uploaded this already}<br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEii7pMLu6uEH9M1uWGmG7zlllShDyvSkra_Wt-y4AYwd3fwmsIi7z26vrO-RF_rF1p5CJNG39VA6Fu1yfaJIi6eNi0yNeQ9Lk4rpVuyREh9Vr0VP3PU7khr9E-EhpQsQes96fgnAfM0Kjk/s1600/rutledge.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="192" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEii7pMLu6uEH9M1uWGmG7zlllShDyvSkra_Wt-y4AYwd3fwmsIi7z26vrO-RF_rF1p5CJNG39VA6Fu1yfaJIi6eNi0yNeQ9Lk4rpVuyREh9Vr0VP3PU7khr9E-EhpQsQes96fgnAfM0Kjk/s320/rutledge.PNG" width="320" /></a></div>
<br />
<br />
<br />
The spreadsheet can be downloaded free of charge from MiScion Pty Ltd: <a href="http://miscion.com.au/product/footing-calculator-using-rutledge-formula/">Rutledge.xls</a>Conrad Harrisonhttp://www.blogger.com/profile/11351972303793021889noreply@blogger.comtag:blogger.com,1999:blog-4489837633148400033.post-59135127604889727652015-06-28T17:48:00.001+09:302016-02-01T13:32:39.315+10:30Post Footing Design : Pocket Footing<i>{Draft: Thought I'd uploaded this already}</i><br />
<br />
<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiejup6FNEV_iX-N1GIdmlfkdvVAaatGq4Ck0zDvy14yceCjeO9_aLzqzzrlK4xvMCbH4_XyeOL92Lr5hnJHMneWXmN30SS-B3XeaCnWMDN9655179vN3zocPQD3ywz0xKQYiNQ2j5F6i4/s1600/pocketFooting.PNG" imageanchor="1" style="margin-left: 1em; margin-right: 1em;"><img border="0" height="192" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiejup6FNEV_iX-N1GIdmlfkdvVAaatGq4Ck0zDvy14yceCjeO9_aLzqzzrlK4xvMCbH4_XyeOL92Lr5hnJHMneWXmN30SS-B3XeaCnWMDN9655179vN3zocPQD3ywz0xKQYiNQ2j5F6i4/s320/pocketFooting.PNG" width="320" /></a></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
<div class="separator" style="clear: both; text-align: center;">
<br /></div>
Spreadsheet can be downloaded free of charge at Miscion Pty Ltd : <a href="http://miscion.com.au/product/pocket-footing-calculator/">PocketFooting.xls</a><br />
<br />Conrad Harrisonhttp://www.blogger.com/profile/11351972303793021889noreply@blogger.comtag:blogger.com,1999:blog-4489837633148400033.post-12922589942456681682015-06-22T16:11:00.002+09:302016-04-18T23:41:16.451+09:30One eWorkBook a Month<div>
Not actually created at the rate of one a month, but representative of what could be done. Most however were created over a single weekend during the past 25 years or so: some started in As Easy As, and others in QPro. After the initial creation they were then expanded, on an as needs basis.</div>
<div>
<br />
<hr />
</div>
<div>
<table border="5" cellpadding="0" cellspacing="0" frame="border" rules="all" style="width: 100%px;">
<tbody>
<tr>
<td style="background-color: blue; font-weight: bold; width: 10%;">Period</td>
<td style="background-color: blue; font-weight: bold; width: 20%;">Category</td>
<td style="background-color: blue; font-weight: bold; width: 50%;">Description</td>
<td style="background-color: blue; font-weight: bold; width: 20%;">File Name</td>
</tr>
<tr>
<td>1</td>
<td>Function Library</td>
<td>...</td>
<td><a href="http://metamorphs-software.blogspot.com.au/2014/06/technical-library-structuring-design.html">schTechLIB.xla</a></td>
</tr>
<tr>
<td>2</td>
<td>Loading</td>
<td>...</td>
<td><a href="http://metamorphs-software.blogspot.com.au/2014/06/simple-wind-load-calculator-to-as4055.html">as4055.xls</a></td>
</tr>
<tr>
<td>3</td>
<td>Loading</td>
<td>...</td>
<td><a href="http://metamorphs-software.blogspot.com.au/2014/06/wind-loading-to-as11702.html">schWindAssessment_r02.xls</a></td>
</tr>
<tr>
<td>4</td>
<td>Materials Library</td>
<td>...</td>
<td><a href="http://metamorphs-software.blogspot.com.au/2014/06/structural-materials-data.html">schStruMtrl.xls</a></td>
</tr>
<tr>
<td>5</td>
<td>Materials Library</td>
<td>...</td>
<td><a href="http://metamorphs-software.blogspot.com.au/2014/06/structural-materials-data-for-timber.html">schTimberMatrl.xls</a></td>
</tr>
<tr>
<td>6</td>
<td>Member Design</td>
<td>...</td>
<td><a href="http://metamorphs-software.blogspot.com.au/2014/06/cold-formed-steel-member-checks-and.html">schDsgn4600.xls</a></td>
</tr>
<tr>
<td>7</td>
<td>Member Design</td>
<td>...</td>
<td><a href="http://metamorphs-software.blogspot.com.au/2014/06/calculator-for-assessment-of-steel.html">schDsgn4100.xls</a></td>
</tr>
<tr>
<td>8</td>
<td>Member Design</td>
<td>...</td>
<td><a href="http://metamorphs-software.blogspot.com.au/2014/06/calculator-for-assessment-of-timber.html">schDsgn1720.xls</a></td>
</tr>
<tr>
<td>9</td>
<td>Dimension & Geometry</td>
<td>...</td>
<td><a href="http://metamorphs-software.blogspot.com.au/2014/06/long-section-profiles.html">schAcadLTCivilScriptWriter.xls</a></td>
</tr>
<tr>
<td>10</td>
<td>Dimension & Geometry</td>
<td>...</td>
<td><a href="http://metamorphs-software.blogspot.com.au/2014/06/draw-cold-formed-steel-sections-using.html">schDrawSection.xls</a></td>
</tr>
<tr>
<td>11</td>
<td>Structural Design</td>
<td>...</td>
<td><a href="http://metamorphs-software.blogspot.com.au/2014/06/timber-canopy-with-gable-roof.html">schGableCanopyTimber.xls</a></td>
</tr>
<tr>
<td>12</td>
<td>Structural Analysis</td>
<td>...</td>
<td><a href="http://metamorphs-software.blogspot.com.au/2014/06/kleinlogel-formulae-for-frames.html">schKleinlogel03.xls</a></td>
</tr>
<tr>
<td colspan="4" style="width: 20%;">(c)Copyright 2015 Steven Conrad Harrison
</td>
</tr>
</tbody></table>
</div>
<div>
<br />
<hr />
Related Posts:
<br />
<br />
<ol>
<li><a href="http://metamorphs-software.blogspot.com.au/2015/06/eworkbook-challenge-spreadsheets-and.html">eWorkBook Challenge: spreadsheets and other calculation workbooks</a></li>
<li><a href="http://miscion.com.au/product/spreadsheet-bundle/">Bundle of my ExcelCalcs UpLoads</a></li>
</ol>
</div>
<hr />
Revisions:
Conrad Harrisonhttp://www.blogger.com/profile/11351972303793021889noreply@blogger.comtag:blogger.com,1999:blog-4489837633148400033.post-16339422232878703612015-06-22T16:11:00.001+09:302016-04-18T23:41:37.060+09:30One eWorkBook a Week<div>
The first 25 not actually created at the rate of one a week, but representative of what could be done. Most however were created over a single weekend during the past 25 years or so: some started in As Easy As, and others in QPro, now all in MS Excel. After the initial creation they were then expanded, on an as needs basis.<br />
<br /></div>
<div>
This list is a work in progress and I will update as I release the workbooks. <i>{NB: The links on the file names lead to posts with more detail about the workbook. See post link at bottom of page for bundled package. Those without a blog post link can be found on my <a href="http://www.excelcalcs.com/comprofiler/infojunkie65/&Itemid=1/">ExcelCalcs profile</a>}</i><br />
<hr />
</div>
<div>
<table border="5" cellpadding="0" cellspacing="0" cols="4" frame="border" rules="all" style="width: 100%;">
<tbody>
<tr>
<td style="background-color: blue; font-weight: bold; width: 7%;">Period</td>
<td style="background-color: blue; font-weight: bold; width: 3%;">Type</td>
<td style="background-color: blue; font-weight: bold; width: 20%;">Category</td>
<td style="background-color: blue; font-weight: bold; width: 50%;">Description</td>
<td style="background-color: blue; font-weight: bold; width: 20%;">File Name</td><td></td>
</tr>
<tr>
<td>1</td>
<td></td>
<td>Function Library</td>
<td>vba Functions for Structural Design</td>
<td><a href="http://metamorphs-software.blogspot.com.au/2014/06/technical-library-structuring-design.html">schTechLIB.xla</a></td><td></td>
</tr>
<tr>
<td>2</td>
<td></td>
<td>Loading</td>
<td>Simplified Wind Loading</td>
<td><a href="http://metamorphs-software.blogspot.com.au/2014/06/simple-wind-load-calculator-to-as4055.html">as4055.xls</a></td><td></td>
</tr>
<tr>
<td>...</td>
<td></td>
<td>Loading</td>
<td>Simplified Wind Loading</td>
<td>as4055v1.xls</td><td></td>
</tr>
<tr>
<td>3</td>
<td></td>
<td>Loading</td>
<td>Wind Loading to AS1170.2</td>
<td><a href="http://metamorphs-software.blogspot.com.au/2014/06/wind-loading-to-as11702.html">schWindAssessment_r02.xls</a></td><td></td>
</tr>
<tr>
<td>4</td>
<td></td>
<td>Materials Library</td>
<td>Steel Sections/Materials Properties</td>
<td><a href="http://metamorphs-software.blogspot.com.au/2014/06/structural-materials-data.html">schStruMtrl.xls</a></td><td></td>
</tr>
<tr>
<td>5</td>
<td></td>
<td>Materials Library</td>
<td>Timber Sections/Materials Properties</td>
<td><a href="http://metamorphs-software.blogspot.com.au/2014/06/structural-materials-data-for-timber.html">schTimberMatrl.xls</a></td><td></td>
</tr>
<tr>
<td>6</td>
<td></td>
<td>Member Design</td>
<td>Cold-formed Steel Design</td>
<td><a href="http://metamorphs-software.blogspot.com.au/2014/06/cold-formed-steel-member-checks-and.html">schDsgn4600.xls</a></td><td></td>
</tr>
<tr>
<td>7</td>
<td></td>
<td>Member Design</td>
<td>Steel Design</td>
<td><a href="http://metamorphs-software.blogspot.com.au/2014/06/calculator-for-assessment-of-steel.html">schDsgn4100.xls</a></td><td></td>
</tr>
<tr>
<td>8</td>
<td></td>
<td>Member Design</td>
<td>Timber Design</td>
<td><a href="http://metamorphs-software.blogspot.com.au/2014/06/calculator-for-assessment-of-timber.html">schDsgn1720.xls</a></td><td></td>
</tr>
<tr>
<td>9</td>
<td></td>
<td>Dimension & Geometry</td>
<td>Long Section Profile Plotter</td>
<td><a href="http://metamorphs-software.blogspot.com.au/2014/06/long-section-profiles.html">schAcadLTCivilScriptWriter.xls</a></td><td></td>
</tr>
<tr>
<td>10</td>
<td></td>
<td>Dimension & Geometry</td>
<td>Draw Cold-Formed Sections</td>
<td><a href="http://metamorphs-software.blogspot.com.au/2014/06/draw-cold-formed-steel-sections-using.html">schDrawSection.xls</a></td><td></td>
</tr>
<tr>
<td>11</td>
<td></td>
<td>Structural Design</td>
<td>Doubly Pitched Timber Canopy</td>
<td><a href="http://metamorphs-software.blogspot.com.au/2014/06/timber-canopy-with-gable-roof.html">schGableCanopyTimber.xls</a></td><td></td>
</tr>
<tr>
<td>12</td>
<td></td>
<td>Structural Analysis</td>
<td>Kleinlogel Formula </td>
<td><a href="http://metamorphs-software.blogspot.com.au/2014/06/kleinlogel-formulae-for-frames.html">schKleinlogel03.xls</a></td><td></td>
</tr>
<tr>
<td>13</td>
<td></td>
<td>...</td>
<td>Planner Calendar.</td>
<td><a href="http://metamorphs-software.blogspot.com.au/2014/06/simple-planner-calendar.html">schPlannerCalendar.xls</a></td><td></td>
</tr>
<tr>
<td>14</td>
<td></td>
<td>...</td>
<td>IE: Work study flow process chart.</td>
<td><a href="http://metamorphs-software.blogspot.com.au/2014/06/work-study-work-flow-process-chart.html">schWorkStudy.xls</a></td><td></td>
</tr>
<tr>
<td>15</td>
<td></td>
<td>...</td>
<td>...</td>
<td><a href="http://metamorphs-software.blogspot.com.au/2014/06/more-bill-of-materials-worksheets.html">bomStructureTreeStage3.xls</a></td><td></td>
</tr>
<tr>
<td>16</td>
<td></td>
<td>...</td>
<td>IE/POM/CAPM Automatic Explosion of Bill of Materials.</td>
<td><a href="http://metamorphs-software.blogspot.com.au/2014/06/automatic-explosion-of-single-level.html">mrpBOMv2.xls [ExplodedBOM.zip]</a></td><td></td>
</tr>
<tr>
<td>17</td>
<td></td>
<td>...</td>
<td>...</td>
<td><a href="http://metamorphs-software.blogspot.com.au/2014/06/simple-indented-bill-of-materials.html">schBOMStructureTreeStage1.xls</a></td><td></td>
</tr>
<tr>
<td>18</td>
<td></td>
<td>...</td>
<td>Experiments with Parametric Sketches using XY Charts.</td>
<td><a href="http://metamorphs-software.blogspot.com.au/2014/06/experiments-using-excel-xy-charts-for.html">drawWorkSheet2009.xls</a></td><td></td>
</tr>
<tr>
<td>19</td>
<td></td>
<td>...</td>
<td>Dimension and Geometry of Gable Frame shed Frame Member Lengths and Bracing Lengths</td>
<td><a href="http://metamorphs-software.blogspot.com.au/2014/06/component-lengths-for-cold-formed-steel.html">schBuildingDimensions.xls</a></td><td></td>
</tr>
<tr>
<td>20</td>
<td></td>
<td>...</td>
<td>CADD</td>
<td style="background-color: #ffff99;">schCADDv2.xls</td><td></td>
</tr>
<tr>
<td>21</td>
<td></td>
<td>...</td>
<td>Estimating: Hole punching requirements for roll-formed sections.</td>
<td style="background-color: #ffff99;">schHolePunching.xls</td><td></td>
</tr>
<tr>
<td>22</td>
<td></td>
<td>...</td>
<td>Beaufort wind Scale</td>
<td><a href="http://metamorphs-software.blogspot.com.au/2014/06/beaufort-wind-speed-chart.html">Beaufort.xls</a></td><td></td>
</tr>
<tr>
<td>23</td>
<td></td>
<td>...</td>
<td>Example Using Circular References to Force Iteration: Calculation Effective Section Modulus for Coldformed C-Section to AS4600.</td>
<td><a href="http://metamorphs-software.blogspot.com.au/2014/06/cold-formed-steel-calculation-of.html">schColdformedCee.xls</a></td><td></td>
</tr>
<tr>
<td>24</td>
<td></td>
<td>...</td>
<td>Tables for strength of bolted joints in thin cold-formed steel sheets to AS4600.</td>
<td><a href="http://metamorphs-software.blogspot.com.au/2014/06/strength-of-bolted-joints-in-cold.html">schTechNote022pt2.xls</a></td><td></td>
</tr>
<tr>
<td>25</td>
<td></td>
<td>...</td>
<td>Wind Loads on Gable Frame to Australian Wind Code AS1170.2</td>
<td><a href="http://metamorphs-software.blogspot.com.au/2015/06/wind-loads-on-doubly-pitched-building.html">schShedDesignerR01.xls</a></td><td></td>
</tr>
<tr>
<td>26</td>
<td></td>
<td>...</td>
<td>Experiments with Geographical Information System (GIS) central places</td>
<td><a href="http://metamorphs-software.blogspot.com.au/2014/06/experiments-with-geographical.html">centralPlaces4.zip</a></td><td></td>
</tr>
<tr>
<td>27</td>
<td></td>
<td>...</td>
<td>VBA Experiments with Abstract Data Structures.</td>
<td><a href="http://metamorphs-software.blogspot.com.au/2014/06/excelvba-experiments-with-abstract-data.html">dataStruct.zip</a></td><td></td>
</tr>
<tr>
<td>28</td>
<td></td>
<td>...</td>
<td>CAD: Automatic generation of framing plans and elevations simple gable frame.</td>
<td><a href="http://metamorphs-software.blogspot.com.au/2014/06/automatic-generation-of-shed-framing.html">drawShed.zip</a></td><td></td>
</tr>
<tr>
<td>29</td>
<td></td>
<td>...</td>
<td>CAD: Experiments with DesignCAD: Draw 3D framing of American Barn type structure.</td>
<td><a href="http://metamorphs-software.blogspot.com.au/2014/06/automatic-generation-of-3d-stick.html">drawShedDC1.zip</a></td><td></td>
</tr>
<tr>
<td>30</td>
<td></td>
<td>...</td>
<td>VBA Experiments with ACAD Script Automation.</td>
<td><a href="http://metamorphs-software.blogspot.com.au/2014/06/automating-acad-lt-using-scripts.html">drawTut.zip</a></td><td></td>
</tr>
<tr>
<td>31</td>
<td></td>
<td>...</td>
<td>VBA Experiments with Excel Shapes Layer: Structural Framing Plans.</td>
<td><a href="http://metamorphs-software.blogspot.com.au/2014/06/experimenting-with-ms-excel-shapes.html">ExcelShapes.zip</a></td><td></td>
</tr>
<tr>
<td>32</td>
<td></td>
<td>...</td>
<td>Application for Generation of Height Span Charts Gable Frame Sheds.</td>
<td><a href="http://metamorphs-software.blogspot.com.au/2014/06/application-to-generate-height-versus.html">schDesignEngineR01.zip</a></td><td></td>
</tr>
<tr>
<td>33</td>
<td></td>
<td>...</td>
<td>VBA Experiments Parsing ACAD DXF files</td>
<td><a href="http://metamorphs-software.blogspot.com.au/2014/06/experiments-parsing-acad-dxf-files.html">vbaDXF.zip</a></td><td></td>
</tr>
<tr>
<td>34</td>
<td></td>
<td>...</td>
<td>VBA Experiments with Class Objects.</td>
<td><a href="http://metamorphs-software.blogspot.com.au/2014/06/vba-experiments-with-class-objects.html">vbaObjects.zip</a></td><td></td>
</tr>
<tr>
<td>35</td>
<td></td>
<td>...</td>
<td>Excel/VBA Tutorials.</td>
<td><a href="http://metamorphs-software.blogspot.com.au/2014/06/collection-of-short-excelvba-macros-to.html">vbaTuts.zip</a></td><td></td>
</tr>
</tbody></table>
</div>
<div>
All the above are available as separate downloads from ExcelCalc's or from my blog's as a single bundled package <i>{see post link at bottom of page}</i>.
<br />
<h2 style="text-align: center;">
<b><u>Beyond ExcelCalcs
</u></b></h2>
Today 23/06/2015 is week 26 for 2015, so with the above now upto date
with respect to week 26, should now be able to release one workbook per week. Changed my mind
[28/6/2015], decided to list all the spreadsheets that I have released
already: turns out that exceeds 52 spreadsheets, so the rest will be
listed on the one <a href="http://metamorphs-software.blogspot.com.au/2015/06/one-eworkbook-day.html">workbook per day</a> challenge.<br />
<br />
The workbooks listed
below are available via this blog and and some over on <a href="http://miscion.com.au/">MiScion Pty Ltd</a>.<br />
<br /></div>
<div>
<table border="5" cellpadding="0" cellspacing="0" cols="4" frame="border" rules="all" style="width: 100%;">
<tbody>
<tr>
<td style="background-color: blue; font-weight: bold; width: 7%;">Period</td>
<td style="background-color: blue; font-weight: bold; width: 3%;">Type</td>
<td style="background-color: blue; font-weight: bold; width: 20%;">Category</td>
<td style="background-color: blue; font-weight: bold; width: 50%;">Description</td>
<td style="background-color: blue; font-weight: bold; width: 20%;">File Name</td>
</tr>
<tr>
<td>36</td>
<td></td>
<td>...</td>
<td>...</td>
<td><a href="http://metamorphs.blogspot.com.au/2014/04/wind-loading-bca-importance-levels.html">bcaImportanceLevels.xls</a></td>
</tr>
<tr>
<td>37</td>
<td></td>
<td>...</td>
<td>...</td>
<td><a href="http://metamorphs-software.blogspot.com.au/2014/08/second-moment-of-area-of-built-up.html">BuiltUpSection.xls</a></td>
</tr>
<tr>
<td>38</td>
<td></td>
<td>...</td>
<td>...</td>
<td><a href="http://metamorphs-software.blogspot.com.au/2014/06/experiments-with-dao-in-ms-excel.html">dbExperiments.xls</a></td>
</tr>
<tr>
<td>39</td>
<td></td>
<td>...</td>
<td>...</td>
<td><a href="http://metamorphs-software.blogspot.com.au/2015/01/export-ms-excel-named-ranges-to-xml.html">exportNamedToXML.xls</a></td>
</tr>
<tr>
<td>40</td>
<td></td>
<td>...</td>
<td>...</td>
<td><a href="http://metamorphs-software.blogspot.com.au/2015/01/import-xml-data-to-ms-excel.html">importXML.xls</a></td>
</tr>
<tr>
<td>41</td>
<td></td>
<td>...</td>
<td>...</td>
<td><a href="http://metamorphs-software.blogspot.com.au/2015/06/post-footing-design-pocket-footing.html">PocketFooting.xls</a></td>
</tr>
<tr>
<td>42</td>
<td></td>
<td>...</td>
<td>...</td>
<td><a href="http://metamorphs-software.blogspot.com.au/2015/06/post-footing-design-rutledge-formula.html">Rutledge.xls</a></td>
</tr>
<tr>
<td>43</td>
<td></td>
<td>...</td>
<td>...</td>
<td><a href="http://metamorphs-software.blogspot.com.au/2014/06/chrome-bookmarks-and-blogger-posts.html">schGoogleToolBox.xls</a></td>
</tr>
<tr>
<td>44</td>
<td></td>
<td>...</td>
<td>...</td>
<td><a href="http://metamorphs.blogspot.com.au/2014/04/wind-loading-surface-roughness-length.html">surfaceRoughnessLength.xls</a></td>
</tr>
<tr>
<td>45</td>
<td></td>
<td>...</td>
<td>...</td>
<td><a href="http://metamorphs-software.blogspot.com.au/2014/06/bill-of-materials-and-equivalent-binary.html">treeExperiments2014.xls</a></td>
</tr>
<tr>
<td>46</td>
<td></td>
<td>...</td>
<td>...</td>
<td><a href="http://metamorphs-software.blogspot.com.au/2014/04/barrier-post-design-to-australian-codes.html">wbk6dsgnBarrierPost.xls</a></td>
</tr>
<tr>
<td>47</td>
<td></td>
<td>...</td>
<td>...</td>
<td><a href="http://metamorphs-software.blogspot.com.au/2014/04/barrier-post-design-to-australian-codes.html">windBarrierPost.xls</a></td>
</tr>
<tr>
<td>48</td>
<td></td>
<td>...</td>
<td>...</td>
<td><a href="http://metamorphs.blogspot.com.au/2014/04/wind-loading-risk-assessment.html">windRiskAssessment2014.xls</a></td>
</tr>
<tr>
<td>49</td>
<td></td>
<td>...</td>
<td>...</td>
<td><a href="http://metamorphs-software.blogspot.com.au/2014/06/experiments-with-xml-data-files-and.html">xmlExperiments.xls</a></td>
</tr>
<tr>
<td>50</td>
<td></td>
<td>...</td>
<td>...</td>
<td><a href="http://metamorphs.blogspot.com.au/2014/02/plane-frame-analysis-back-end.html">backEndPFrame.xls</a></td>
</tr>
<tr>
<td>51</td>
<td></td>
<td>...</td>
<td>...</td>
<td><a href="http://metamorphs.blogspot.com.au/2014/02/plane-frame-analysis-front-end.html">frontEndPFrame01.xls</a></td>
</tr>
<tr>
<td>52</td>
<td></td>
<td>...</td>
<td>...</td>
<td><a href="http://miscion.com.au/stairs-compatibility-with-as1657-and-bca/">stairCalculator.xls</a></td>
</tr>
</tbody></table>
</div>
<div>
<br />
<hr />
Related Posts:
<br />
<br />
<ol>
<li><a href="http://metamorphs-software.blogspot.com.au/2015/06/eworkbook-challenge-spreadsheets-and.html">eWorkBook Challenge: spreadsheets and other calculation workbooks</a></li>
<li><a href="http://miscion.com.au/product/spreadsheet-bundle/">Bundle of my ExcelCalcs UpLoads</a></li>
</ol>
</div>
<div>
<hr />
Revisions:<br />
[22/06/2015] : Original<br />
[23/06/2015] : Split the table<br />
[24/06/2015] : Added Type Column to Tables<br />
[28/06/2015] : Added Spreadsheets I have previously released.<br />
[30/06/2015] ; Added Extra Links and Descriptions</div>
Conrad Harrisonhttp://www.blogger.com/profile/11351972303793021889noreply@blogger.comtag:blogger.com,1999:blog-4489837633148400033.post-19063820574157829162015-06-22T16:11:00.000+09:302016-04-18T23:41:59.036+09:30One eWorkBook a Day<div>
Not actually created at the rate of one a day, but representative of what could be done. Most however were created over a single weekend during the past 25 years or so: some started in As Easy As, and others in QPro. After the initial creation they were then expanded, on an as needs basis.<br />
<br /></div>
<div>
This list is a work in progress and I will update as I release the workbooks.<br />
<hr />
</div>
<div>
<table border="5" cellpadding="0" cellspacing="0" cols="5" frame="border" rules="all" style="width: 100%;">
<tbody>
<tr>
<td style="background-color: blue; font-weight: bold; width: 7%;">Period</td>
<td style="background-color: blue; font-weight: bold; width: 3%;">Type</td>
<td style="background-color: blue; font-weight: bold; width: 20%;">Category</td>
<td style="background-color: blue; font-weight: bold; width: 50%;">Description</td>
<td style="background-color: blue; font-weight: bold; width: 20%;">File Name</td>
</tr>
<tr>
<td>1</td>
<td></td>
<td>Function Library</td>
<td>vba Functions for Structural Design</td>
<td><a href="http://metamorphs-software.blogspot.com.au/2014/06/technical-library-structuring-design.html">schTechLIB.xla</a></td>
</tr>
<tr>
<td>2</td>
<td></td>
<td>Loading</td>
<td>Simplified Wind Loading</td>
<td><a href="http://metamorphs-software.blogspot.com.au/2014/06/simple-wind-load-calculator-to-as4055.html">as4055.xls</a></td>
</tr>
<tr>
<td>...</td>
<td></td>
<td>Loading</td>
<td>Simplified Wind Loading</td>
<td>as4055v1.xls</td>
</tr>
<tr>
<td>3</td>
<td></td>
<td>Loading</td>
<td>Wind Loading to AS1170.2</td>
<td><a href="http://metamorphs-software.blogspot.com.au/2014/06/wind-loading-to-as11702.html">schWindAssessment_r02.xls</a></td>
</tr>
<tr>
<td>4</td>
<td></td>
<td>Materials Library</td>
<td>Steel Sections/Materials Properties</td>
<td><a href="http://metamorphs-software.blogspot.com.au/2014/06/structural-materials-data.html">schStruMtrl.xls</a></td>
</tr>
<tr>
<td>5</td>
<td></td>
<td>Materials Library</td>
<td>Timber Sections/Materials Properties</td>
<td><a href="http://metamorphs-software.blogspot.com.au/2014/06/structural-materials-data-for-timber.html">schTimberMatrl.xls</a></td>
</tr>
<tr>
<td>6</td>
<td></td>
<td>Member Design</td>
<td>Cold-formed Steel Design</td>
<td><a href="http://metamorphs-software.blogspot.com.au/2014/06/cold-formed-steel-member-checks-and.html">schDsgn4600.xls</a></td>
</tr>
<tr>
<td>7</td>
<td></td>
<td>Member Design</td>
<td>Steel Design</td>
<td><a href="http://metamorphs-software.blogspot.com.au/2014/06/calculator-for-assessment-of-steel.html">schDsgn4100.xls</a></td>
</tr>
<tr>
<td>8</td>
<td></td>
<td>Member Design</td>
<td>Timber Design</td>
<td><a href="http://metamorphs-software.blogspot.com.au/2014/06/calculator-for-assessment-of-timber.html">schDsgn1720.xls</a></td>
</tr>
<tr>
<td>9</td>
<td></td>
<td>Dimension & Geometry</td>
<td>Long Section Profile Plotter</td>
<td><a href="http://metamorphs-software.blogspot.com.au/2014/06/long-section-profiles.html">schAcadLTCivilScriptWriter.xls</a></td>
</tr>
<tr>
<td>10</td>
<td></td>
<td>Dimension & Geometry</td>
<td>Draw Cold-Formed Sections</td>
<td><a href="http://metamorphs-software.blogspot.com.au/2014/06/draw-cold-formed-steel-sections-using.html">schDrawSection.xls</a></td>
</tr>
<tr>
<td>11</td>
<td></td>
<td>Structural Design</td>
<td>Doubly Pitched Timber Canopy</td>
<td><a href="http://metamorphs-software.blogspot.com.au/2014/06/timber-canopy-with-gable-roof.html">schGableCanopyTimber.xls</a></td>
</tr>
<tr>
<td>12</td>
<td></td>
<td>Structural Analysis</td>
<td>Kleinlogel Formula </td>
<td><a href="http://metamorphs-software.blogspot.com.au/2014/06/kleinlogel-formulae-for-frames.html">schKleinlogel03.xls</a></td>
</tr>
<tr>
<td>13</td>
<td></td>
<td>...</td>
<td>...</td>
<td><a href="http://metamorphs-software.blogspot.com.au/2014/06/simple-planner-calendar.html">schPlannerCalendar.xls</a></td>
</tr>
<tr>
<td>14</td>
<td></td>
<td>...</td>
<td>...</td>
<td><a href="http://metamorphs-software.blogspot.com.au/2014/06/work-study-work-flow-process-chart.html">schWorkStudy.xls</a></td>
</tr>
<tr>
<td>15</td>
<td></td>
<td>...</td>
<td>...</td>
<td><a href="http://metamorphs-software.blogspot.com.au/2014/06/more-bill-of-materials-worksheets.html">bomStructureTreeStage3.xls</a></td>
</tr>
<tr>
<td>16</td>
<td></td>
<td>...</td>
<td>...</td>
<td><a href="http://metamorphs-software.blogspot.com.au/2014/06/automatic-explosion-of-single-level.html">mrpBOMv2.xls</a></td>
</tr>
<tr>
<td>17</td>
<td></td>
<td>...</td>
<td>...</td>
<td><a href="http://metamorphs-software.blogspot.com.au/2014/06/simple-indented-bill-of-materials.html">schBOMStructureTreeStage1.xls</a></td>
</tr>
<tr>
<td>18</td>
<td></td>
<td>...</td>
<td>...</td>
<td><a href="http://metamorphs-software.blogspot.com.au/2014/06/experiments-using-excel-xy-charts-for.html">drawWorkSheet2009.xls</a></td>
</tr>
<tr>
<td>19</td>
<td></td>
<td>...</td>
<td>...</td>
<td><a href="http://metamorphs-software.blogspot.com.au/2014/06/component-lengths-for-cold-formed-steel.html">schBuildingDimensions.xls</a></td>
</tr>
<tr>
<td>20</td>
<td></td>
<td>...</td>
<td>...</td>
<td>schCADDv2.xls</td>
</tr>
<tr>
<td>21</td>
<td></td>
<td>...</td>
<td>...</td>
<td>schHolePunching.xls</td>
</tr>
<tr>
<td>22</td>
<td></td>
<td>...</td>
<td>...</td>
<td><a href="http://metamorphs-software.blogspot.com.au/2014/06/beaufort-wind-speed-chart.html">Beaufort.xls</a></td>
</tr>
<tr>
<td>23</td>
<td></td>
<td>...</td>
<td>...</td>
<td><a href="http://metamorphs-software.blogspot.com.au/2014/06/cold-formed-steel-calculation-of.html">schColdformedCee.xls</a></td>
</tr>
<tr>
<td>24</td>
<td></td>
<td>...</td>
<td>...</td>
<td><a href="http://metamorphs-software.blogspot.com.au/2014/06/strength-of-bolted-joints-in-cold.html">schTechNote022pt2.xls</a></td>
</tr>
<tr>
<td>25</td>
<td></td>
<td>...</td>
<td>...</td>
<td><a href="http://metamorphs-software.blogspot.com.au/2015/06/wind-loads-on-doubly-pitched-building.html">schShedDesignerR01.xls</a></td>
</tr>
</tbody></table>
<div>
<br />
<h2 style="text-align: center;">
<b><u>Beyond ExcelCalcs
</u></b></h2>
Block of workbooks need to Supply to catch up with current date in 2015, as at 22/6/2015. Assuming 30 days to catch up, that will be around 200 workbooks need to supply in 30 days, or about 7 workbooks per day: which may just be about possible. Otherwise move from calender year to financial tax year 2015 July to 2016 June.<br />
<br /></div>
<table border="5" cellpadding="0" cellspacing="0" cols="5" frame="border" rules="all" style="width: 100%px;">
<tbody>
<tr>
<td style="background-color: blue; font-weight: bold; width: 7%;">Period</td>
<td style="background-color: blue; font-weight: bold; width: 3%;">Type</td>
<td style="background-color: blue; font-weight: bold; width: 20%;">Category</td>
<td style="background-color: blue; font-weight: bold; width: 50%;">Description</td>
<td style="background-color: blue; font-weight: bold; width: 20%;">File Name</td>
</tr>
<tr>
<td>26</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>27</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>28</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>29</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>30</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>31</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>32</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>33</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>34</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>35</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>36</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>37</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>38</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>39</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>40</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>41</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>42</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>43</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>44</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>45</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>46</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>47</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>48</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>49</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>50</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>51</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>52</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>53</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>54</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>55</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>56</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>57</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>58</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>59</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>60</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>61</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>62</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>63</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>64</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>65</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>66</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>67</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>68</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>69</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>70</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>71</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>72</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>73</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>74</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>75</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>76</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>77</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>78</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>79</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>80</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>81</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>82</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>83</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>84</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>85</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>86</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>87</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>88</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>89</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>90</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>91</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>92</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>93</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>94</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>95</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>96</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>97</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>98</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>99</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>100</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>101</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>102</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>103</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>104</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>105</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>106</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>107</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>108</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>109</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>110</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>111</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>112</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>113</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>114</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>115</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>116</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>117</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>118</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>119</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>120</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>121</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>122</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>123</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>124</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>125</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>126</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>127</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>128</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>129</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>130</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>131</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>132</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>133</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>134</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>135</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>136</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>137</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>138</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>139</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>140</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>141</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>142</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>143</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>144</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>145</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>146</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>147</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>148</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>149</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>150</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>151</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>152</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>153</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>154</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>155</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>156</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>157</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>158</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>159</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>160</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>161</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>162</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>163</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>164</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>165</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>166</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>167</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>168</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>169</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>170</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>171</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>172</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
</tbody></table>
<div>
<br />
<br />
Caught up with current date, and should now be able to produce one workbook per day.
<br />
<br /></div>
<table border="5" cellpadding="0" cellspacing="0" cols="5" frame="border" rules="all" style="width: 100%px;">
<tbody>
<tr>
<td style="background-color: blue; font-weight: bold; width: 7%;">Period</td>
<td style="background-color: blue; font-weight: bold; width: 3%;">Type</td>
<td style="background-color: blue; font-weight: bold; width: 20%;">Category</td>
<td style="background-color: blue; font-weight: bold; width: 50%;">Description</td>
<td style="background-color: blue; font-weight: bold; width: 20%;">File Name</td>
</tr>
<tr>
<td>173</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>174</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>175</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>176</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>177</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>178</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>179</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>180</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>181</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>182</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>183</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>184</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>185</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>186</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>187</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>188</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>189</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>190</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>191</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>192</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>193</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>194</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>195</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>196</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>197</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>198</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>199</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>200</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>201</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>202</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>203</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>204</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>205</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>206</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>207</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>208</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>209</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>210</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>211</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>212</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>213</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>214</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>215</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>216</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>217</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>218</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>219</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>220</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>221</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>222</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>223</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>224</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>225</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>226</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>227</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>228</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>229</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>230</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>231</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>232</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>233</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>234</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>235</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>236</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>237</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>238</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>239</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>240</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>241</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>242</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>243</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>244</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>245</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>246</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>247</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>248</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>249</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>250</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>251</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>252</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>253</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>254</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>255</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>256</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>257</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>258</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>259</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>260</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>261</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>262</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>263</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>264</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>265</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>266</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>267</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>268</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>269</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>270</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>271</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>272</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>273</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>274</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>275</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>276</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>277</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>278</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>279</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>280</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>281</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>282</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>283</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>284</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>285</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>286</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>287</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>288</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>289</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>290</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>291</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>292</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>293</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>294</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>295</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>296</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>297</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>298</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>299</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>300</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>301</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>302</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>303</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>304</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>305</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>306</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>307</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>308</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>309</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>310</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>311</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>312</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>313</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>314</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>315</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>316</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>317</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>318</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>319</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>320</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>321</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>322</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>323</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>324</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>325</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>326</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>327</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>328</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>329</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>330</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>331</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>332</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>333</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>334</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>335</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>336</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>337</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>338</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>339</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>340</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>341</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>342</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>343</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>344</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>345</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>346</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>347</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>348</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>349</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>350</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>351</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>352</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>353</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>354</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>355</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>356</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>357</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>358</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>359</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>360</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>361</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>362</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>363</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>364</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
<tr>
<td>365</td>
<td></td>
<td>...</td>
<td>...</td>
<td>...</td>
</tr>
</tbody></table>
</div>
<div>
<br />
<hr />
Related Posts:
<br />
<br />
<ol>
<li><a href="http://metamorphs-software.blogspot.com.au/2015/06/eworkbook-challenge-spreadsheets-and.html">eWorkBook Challenge: spreadsheets and other calculation workbooks</a></li>
<li><a href="http://miscion.com.au/product/spreadsheet-bundle/">Bundle of my ExcelCalcs UpLoads</a></li>
</ol>
</div>
<hr />
Revisions:Conrad Harrisonhttp://www.blogger.com/profile/11351972303793021889noreply@blogger.comtag:blogger.com,1999:blog-4489837633148400033.post-38646527157246037142015-06-22T16:10:00.003+09:302016-04-23T15:45:14.952+09:30eWorkBook Challenge: spreadsheets and other calculation workbooksOver past few years noticed several challenges such as a photo a day, a <a href="http://www.sketchadayproject.com/">sketch a day</a>, and 500 words a day, some of these challenges are based on a year, others over shorter periods such as a month or week. A quick search of the internet didn't reveal any similar challenges for spreadsheets or other calculation workbooks such as MathCAD, in the main the challenges are to create an electronic workbook [eWorkBook] for a specific purpose, or otherwise use spreadsheets to track progress with other challenges: such as tracking progress writing a 50,000 word <a href="http://nanowrimo.org/">novel in a month</a> at an average rate of 1667 words/day. It would therefore seem there is no existing challenge for creating a collection of spreadsheets.<br />
<br />
May be such challenge isn't considered appropriate, or it is just too complicated for an individual to pursue. Most people don't have a need for a large variety of spreadsheets, they just produce multiple spreadsheets based on one single template. Those people working in technical fields probably already have the eWorkbooks they need for their work, whilst others create new eWorkbooks everyday in the course of their daily work. However it is also clear that people are looking for technical spreadsheets to carry out various engineering calculations. So there are people who can use eWorkbooks but not build them, or otherwise don't want to put the effort in at the time they need them.<br />
<br />
By now I would expect that most graduates from formal educational programmes would have a toolbox of eWorkBooks for the types of tasks they will commonly encounter. Though unfortunately a lot of those they create as a formal part of their courses are probably created in software the likes of MathCAD and/or MatLAB: the problem with such is that such software is expensive and not all that readily available in organisations. Spreadsheets however are a lot more readily available, and therefore the better choice for building a toolbox of calculation tools.<br />
<br />
The challenge isn't intended to be a competition with winners and losers, there are no prizes. The challenge is a personal goal, that anyone can take up, the prize if any is a useful personal collection of calculation tools. If wish to share such tools then I recommend up loading them to <a href="https://www.excelcalcs.com/">ExcelCalcs</a>. The challenge can be spread over any time frame, suggestions are:<br />
<ol>
<li><a href="http://metamorphs-software.blogspot.com.au/2015/06/one-eworkbook-month.html">One eWorkBook a Month</a> (12 for a year)</li>
<li><a href="http://metamorphs-software.blogspot.com.au/2015/06/one-eworkbook-week.html">One eWorkBook a Week</a> (52 for a year)</li>
<li><a href="http://metamorphs-software.blogspot.com.au/2015/06/one-eworkbook-day.html">One eWorkBook a Day</a> (365 for a year)</li>
</ol>
Which provides the opportunity to spread the challenge over a period of 3 years, the first year starting with one spreadsheet a month, then slowly building up to one spreadsheet a day for the third year.<br />
<br />
I have already uploaded 37 unique files to my <a href="http://www.excelcalcs.com/comprofiler/infojunkie65/&Itemid=1/">ExcelCalcs profile</a>, so that represents enough spreadsheets to cover one workbook a month. Given that some of these are zip files, with at least one containing more than 40 workbooks, that also means enough workbooks to cover one workbook a week. Searching my archive hard-drive I find over 70,000 workbooks of various formats (As Easy As, QPro DOS, QPro Windows, MS Excel), many of those are duplicates or minor variations on a theme. My main toolbox already holds over 700 MS Excel spreadsheets. So producing some 365 eWorkBooks doesn't seem an impossible challenge: though creating something unique from scratch each and every day could be challenging. However the challenge doesn't have to be about creating from scratch, for me the challenge would be cleaning up the existing spreadsheets and reformatting so that they are suitable for release for others to use.<br />
<br />
eWorkBooks, spreadsheets or otherwise can be classified into the following types:<br />
<br />
<b><u>TYPE 1: Reference Library</u></b><br />
These eWorkBooks are databases or tables of data which are largely constant, and used as lookup values for calculations. They include such things as materials libraries, properties of chemical elements and such things. {MS Access or other DBMS potentially the better tool for this}<br />
<br />
<b><u>TYPE 2: Data Collection</u></b><br />
These are eWorkBooks that are used to collect variable data, and create data tables and simple lists. Examples would include book lists and price lists. {MS Access or other DBMS potentially the better tool for this.}<br />
<br />
<b><u>TYPE 3: Tabulated Calculations</u></b><br />
Tables of independent parameters and calculated dependent variables, with or without charts or graphs illustrating such relationships. {MS Access or other DBMS potentially the better tool for this.}<br />
<br />
<b><u>TYPE 4: Text Book Formula Sheets</u></b><br />
These are the type of eWorkBooks typically uploaded to ExcelCalcs and complying with their recommended template making use of <a href="https://www.excelcalcs.com/repository/xlc-addin-for-excel/xlc-toolbar/">XLC</a>. Such worksheets typically restricted to a single A4 page, have a sketch to illustrate the parameters of the mathematical model, show the algebraic formula, show the numbers substituted in the formula and then show the numerical result. These are primarily for the purpose of studying and understanding the formula.<br />
<br />
<b><u>TYPE 5: Calculated Reports</u></b><br />
These are full technical reports, at least as far as the calculations go. Simply combining a series of Type-4 spreadsheets would not be appropriate for such reports. Such approach would generate a large amount of paper if so printed, or waste of hard-disk space if printed to pdf files, and most importantly a waste of time to read. Such calculated reports should be kept compact and concise, details of calculations are hidden behind the scenes, the reports display input parameters, and calculated results, but not necessarily the process of transformation from input to result. The user of such reports is expected to make independent checks on the results using other tools.<br />
<br />
<b><u>TYPE 6: Calculators and Dashboards</u></b><br />
These can be simple or complex, either way no printed report is generated. These obtain input parameters and calculate results, how such transformation takes place is not shown. The purpose of such tools is rapid decision making. Such tools are likely used by persons checking Type-5 workbooks.<br />
<br />
<b><u>TYPE 7: Applications</u></b><br />
These eWorkBooks can make little to extensive use of visual basic for applications (vba) and custom dialogue forms. The main features are that the workbook has the simple interface of Type-6 calculators, but can produce the reports of Type-5, or otherwise more detailed trace similar to Type-4, as well as produce tabulated reports based on variations in magnitude of input parameters similar to Type-3. Also likely to include data collection (Type-2), and rely on information extracted from libraries (Type-1).<br />
<br />
<b>TYPE 8: Function Libraries</b><br />
Libraries of additional functions., which extend or otherwise simplify the calculation capabilities of the primary workbook application (eg, MS Excel).<br />
<br />
<b><u>TYPE 9: Utility Library/Add-In</u></b><br />
Extends the features of the primary application (eg.MS Excel), but not the calculation capability. (eg. XLC).<br />
<br />
<b><u>TYPE:10: Other</u></b><br />
Those types pf spreadsheets not mentioned elsewhere.<br />
<br />
<br />
A spreadsheet to plan and track spreadsheet creation can be downloaded <a href="http://miscion.com.au/product/spreadsheet-challenge-tracker/">here</a>.<br />
<br />
<div>
<hr />
Revisions: <br />
<br />
<ol>
<li>[22/06/2015] Original</li>
<li>[23/04/2016] Change download links to MiScion Pty Ltd Web Store.</li>
</ol>
<br />
<br />
<br /></div>
Conrad Harrisonhttp://www.blogger.com/profile/11351972303793021889noreply@blogger.comtag:blogger.com,1999:blog-4489837633148400033.post-48909407829506791752015-06-11T13:23:00.002+09:302016-04-18T23:43:41.982+09:30Wind Loads on Doubly Pitched Building to Australian Wind Code<span style="font-size: 8pt;">Taken from the <a href="http://www.excelcalcs.com/index.php?option=com_remository&func=fileinfo&id=578">ExcelCalcs.com</a> website.</span><iframe align="top" height="650" id="ExcelCalcsSample578" name="ExcelCalcsSample578" scrolling="auto" src="http://www.excelcalcs.com/index2.php?option=com_remository&func=fileinfo&id=578" width="100%">This option will not work correctly. Unfortunately, your browser does not support Inline Frames</iframe>
<br />
<br />
<div>
<br />
<hr />
Related Posts:
<br />
<br />
<a href="http://metamorphs.blogspot.com.au/2015/05/bundle-of-my-excelcalcs-uploads.html">Bundle of my ExcelCalcs UpLoads</a>
<br />
<br />
The bundle can be downloaded from MiScion Pty Ltd : <a href="http://miscion.com.au/product/spreadsheet-bundle/">Spreadsheet Bundle</a></div>
Conrad Harrisonhttp://www.blogger.com/profile/11351972303793021889noreply@blogger.comtag:blogger.com,1999:blog-4489837633148400033.post-85626223158432364442015-01-14T20:41:00.001+10:302016-04-23T15:49:16.812+09:30EngineLT revised to Current Wind CodeA revised version of my <a href="http://metamorphs.blogspot.com.au/2013/10/feasibility-of-cold-formed-steel-shed.html">EngineLT </a>application for estimating size of frames for doubly pitched moment frames, typically used in cold-formed sheds. The orginal version was written in Delphi 3 to AS1170.2:1989, the current version is written in vb.net to AS1170.2:2011. The change in language is because I use MS Excel for day to day calculations, with <a href="http://www.excelcalcs.com/repository/misc.-topics/schtechlib/">schTechLIB.xla</a> in the background providing functions for wind loading, steel, cold-formed steel, and timber design. This is written in vba and kept up to date, whilst the Delphi code not kept up to date: to avoid translating languages moved over to vb.net.<br />
<br />
The revised version of the code reads an XML data file, this file contains names of structural sections and the resistance to bending (phi.Ms) in units of kNm. The file can be added to if needed, it already contains, Cee's, RHS, SHS, UB, UC, PFC's.<br />
<br />
It doesn't contain back to back Cee's, such are not really required. As far as the program is concerned the bay spacing is the load width of the individual portal frame. The load width of a frame can be found by halving the distance to each frame either side of the selected frame and summing. For cold-formed steel sheds with frames at 3m centres the load width of a typical frame is 3m. The load width of the end frame is 1.5m. Often for sheds made from hot rolled steel the typical frames are UB's with the end frames made from PFC's: not always practical has it hinders extending the building, and there is extra detailing merely for two frames. Any case it gives the basic idea, the internal frames can be I-sections formed from back to back Cee's and the end frame can be a single Cee. Knowing that a single Cee has a load width of 3m, then back to back Cee's form a frame with a total load width of 6m, the back-to-back frames can therefore be placed at 6m centres, whilst a single Cee can be used for the end frame. Therefore check frame for load width of 3m (bayspace = 3m) for a single Cee rather than the back-to-back Cee's at 6m centres.<br />
<br />
It is also to be noted that whilst a given section may be structurally strong enough, it may not be practical to make an adequate moment connection between the rafter and column.: such check is not made by the application. Other issues not checked are the deflections of the frame.<br />
<br />
The prime purpose of the application is to determine what is not suitable and reject immediately, whilst that considered suitable by the application requires further structural design.<br />
<br />
To keep the input form simple, there are many assumptions made in the background. The assessment made by the application will not match my <a href="http://www.scribd.com/doc/59225263/Chart9BTC3y04m06d14R2">height/span charts</a> as I adopted internal pressure coefficients of -0.65 and +0.7 for this application, but -0.3 and +0.4 for the charts.<br />
<br />
I have a larger Engine application, which I am in the process of also translating from Delphi to vb.net and from AS1170.2:1989 to AS1170.2:2011, makes fewer assumptions but has more input screens and requires connection to a database of section properties, it also generates scripts (.scr) for AutoCAD LT. The original purpose of EngineLT was to severe the original programme from the Borland Database Engine (BDE), as it seemed far too complicated setting up on some other computer.<br />
<br />
The application can be obtained here: <a href="http://miscion.com.au/product/frame-size-check-for-fixed-base-doubly-pitched-portal-frame-shed/">vbEngineLT.zip</a><br />
<br />
<hr />
Revisions:
<br />
<br />
<ol>
<li>[14/01/2015] Original</li>
<li>[23/04/2016] Changed downlinks to MiScion Pty Ltd web Store</li>
</ol>
Conrad Harrisonhttp://www.blogger.com/profile/11351972303793021889noreply@blogger.comtag:blogger.com,1999:blog-4489837633148400033.post-18903316928069609972015-01-14T19:56:00.002+10:302016-04-23T15:51:19.195+09:30Simple Wind Loading Application: Speeds, Pressures and Pressure CoefficientsA simple application for getting wind speeds, pressures and pressure coefficients to AS1170.2 for a rectangular enclosed building with doubly pitched roof. There are two versions in the zip file download. tstwnd.exe and windyworkBench.exe. The former was written in Delphi 3 to AS1170.2:1989, whilst the latter is written in vb.net to AS1170.2:2011.<br />
<br />
<span style="background-color: white; color: #444444; font-family: "arial" , "tahoma" , "helvetica" , "freesans" , sans-serif; font-size: 13px; line-height: 18.2000007629395px;">Application can be down loaded: </span><span style="color: #444444; font-family: "arial" , "tahoma" , "helvetica" , "freesans" , sans-serif;"><span style="font-size: 13px; line-height: 18.2000007629395px;"><a href="http://miscion.com.au/product/wind-loading-pressures-on-doubly-pitched-enclosed-building/">windWorkBench.zip</a></span></span>
<br />
<hr />
Revisions:
<br />
[14/01/2015] Original<br />
[23/04/2016] Changed download links to MiScion Pty Ltd Web Store.Conrad Harrisonhttp://www.blogger.com/profile/11351972303793021889noreply@blogger.com0tag:blogger.com,1999:blog-4489837633148400033.post-12432041299340927922015-01-14T19:51:00.000+10:302016-04-23T15:53:21.822+09:30Import XML Data to MS ExcelSimple Excel Application which reads the XML file created by earlier <a href="http://metamorphs-software.blogspot.com.au/2015/01/export-ms-excel-named-ranges-to-xml.html">application</a>. The data is read into the workbook, and written to a single worksheet. It is also separated into worksheets for parameters, variables, lists and tables. Lists are written across a row. Named ranges are also created for Parameters and Variables.<br />
<br />
It doesn't use any XML library to read the file, instead it uses a limited parser written in vba.<br />
<br />
Its a simple experimental application showing possibility of exporting and importing parameters to simple XML files, to share data between spreadsheet applications.<br />
<br />
Normally I try to create spreadsheets with all parameters on a single worksheet, formatted to be compatible with export to DBase, Paradox and MS Access tables, such worksheet could also be directly exported to XML. However as workbooks grow, not all parameters get referenced on the summary sheet. The two XML workbooks help clean the workbooks up.<br />
<br />
<span style="background-color: white; color: #444444; font-family: "arial" , "tahoma" , "helvetica" , "freesans" , sans-serif; font-size: 13px; line-height: 18.2000007629395px;">Spreadsheet can be down loaded:<a href="https://www.blogger.com/goog_479884375"> </a></span><span style="color: #444444; font-family: "arial" , "tahoma" , "helvetica" , "freesans" , sans-serif;"><span style="font-size: 13px; line-height: 18.2000007629395px;"><a href="http://miscion.com.au/product/import-xml-data-file-to-named-ranges/">importXML.xls</a></span></span>
<br />
<hr />
Revisions:<br />
[14/01/2015] Original<br />
[23/04/2016] Changed download links to MiScion Pty Ltd Web StoreConrad Harrisonhttp://www.blogger.com/profile/11351972303793021889noreply@blogger.comtag:blogger.com,1999:blog-4489837633148400033.post-31819329227861235882015-01-14T19:28:00.002+10:302016-04-23T15:56:14.537+09:30Export MS Excel named Ranges to XMLA simple MS Excel application which allows opening another MS Excel workbook and then saves all the named ranges to an XML file. Whilst Excel permits saving workbook as an XML file, or exporting data to an XML file, such is of little use for data randomly scattered throughout the workbook.<br />
<br />
The application exports the data tagged as parameters, variables, lists and tables. If a named range is a single cell and unprotected then it tags it as a parameter. If the single cell is not unprotected then it is tagged as a variable. A named range which consists of a single row or column of data is tagged a list, whilst a named range comprising of rows and columns is tagged a table.<br />
<br />
It doesn't use any XML library, it simply writes the data to a simple text file with appropriate tags. Also it uses FileSystem objects to write to the file, as the standard vba print statements do not recognise unicode characters, where as Excel cells can contain such.<br />
<br />
Spreadsheet can be down loaded: <a href="http://miscion.com.au/product/exporting-named-ranges-too-xml-file/">exportNamedToXML.xls</a><br />
<br />
<br />
<hr />
Revisions:<br />
[14/01/2015] Original<br />
[23/04/2016] Changed download links to MiScion Pty Ltd Web StoreConrad Harrisonhttp://www.blogger.com/profile/11351972303793021889noreply@blogger.com0tag:blogger.com,1999:blog-4489837633148400033.post-55531217014611373352014-08-20T21:50:00.000+09:302016-04-23T15:58:05.863+09:30Second Moment of Area of Built Up Section<div class="separator" style="clear: both; text-align: center;">
<a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgFJNsQEjCQUEfikkPjaVt8Y5tDVK82lK1hzQAvavOAOeBaMgW9iFK8NBceSFsugwgkGkY6i3hh041s7m12rvkqB8pXblW4M4WVAQBiyLshHLXALHHD8IZhWnhF5KxW0sT8Aw2qyxkVlFI/s1600/BuiltUpSection1.png" imageanchor="1" style="clear: left; float: left; margin-bottom: 1em; margin-right: 1em;"><img border="0" height="170" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEgFJNsQEjCQUEfikkPjaVt8Y5tDVK82lK1hzQAvavOAOeBaMgW9iFK8NBceSFsugwgkGkY6i3hh041s7m12rvkqB8pXblW4M4WVAQBiyLshHLXALHHD8IZhWnhF5KxW0sT8Aw2qyxkVlFI/s1600/BuiltUpSection1.png" width="320" /></a></div>
A small spreadsheet for calculating the section properties Ixx, Zxx and phi.Ms of a simple built up section. It is set up for calculating the properties for two round bars spaced a known distance apart.<br />
<br />
<a href="http://miscion.com.au/product/workbook-for-built-up-structural-sections/">BuiltUpSection.xls</a><br />
<br />
<br />
<br />
<br />
<br />
<hr />
Revisions:<br />
[20/08/2014] Original<br />
[23/04/2016] Changed download links to MiScion Pty Ltd Web StoreConrad Harrisonhttp://www.blogger.com/profile/11351972303793021889noreply@blogger.comtag:blogger.com,1999:blog-4489837633148400033.post-41295141248548287732014-06-23T16:57:00.003+09:302016-04-23T15:59:29.682+09:30Chrome Bookmarks and Blogger Posts<b><u>Chrome Bookmarks</u></b><br />
An Excel workbook to extract Bookmarks from the Google Chrome export file and import into MS Excel, once into Excel it is relatively simple to import into MS Access, where additional tags and grouping can be added to make it easier to manage and to find appropriate bookmarks.<br />
<br />
<b><u>Blogger Posts</u></b><br />
A macro which will break apart the exported Blogger xml file, and create one html file for each post, and a single index page to all the files. Additionally keywords and titles are summarised in Excel worksheet.<br />
<br />
Spreadsheet can be down loaded: <a href="http://miscion.com.au/product/chrome-and-blogger-tools/">schGoogleToolBox.xls</a><br />
<br />
<hr />
Revisions:<br />
[23/06/2014] Original<br />
[23/04/2016] Changed download links to MiScion Pty Ltd Web StoreConrad Harrisonhttp://www.blogger.com/profile/11351972303793021889noreply@blogger.comtag:blogger.com,1999:blog-4489837633148400033.post-4552654258121204372014-06-19T15:59:00.000+09:302016-04-23T16:01:34.856+09:30Experiments with DAO in MS Excel<div class="separator" style="clear: both; text-align: center;">
</div>
<div class="separator" style="clear: both; text-align: center;">
</div>
<table cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiSDbAoRlpgF3T_XAL2bo76jdZX0VqLrMqfdB7KU0DOofaUnJEpxrAgoKEfElBoapk5pHKh9hdnEI4EjWO4s-CwXYCCj1muiP7MjxZfGpZYp8quUN2q6RwO6p3bwEGCCYYbo380ybO6YIE/s1600/dbApp00.png" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img border="0" height="259" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiSDbAoRlpgF3T_XAL2bo76jdZX0VqLrMqfdB7KU0DOofaUnJEpxrAgoKEfElBoapk5pHKh9hdnEI4EjWO4s-CwXYCCj1muiP7MjxZfGpZYp8quUN2q6RwO6p3bwEGCCYYbo380ybO6YIE/s1600/dbApp00.png" width="320" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;">Workbook showing button to run main application</td></tr>
</tbody></table>
A simple application to open a MS Access mdb file to:<br />
<ol>
<li>List the contained tables</li>
<li>List the fields of a selected table</li>
<li>Import the data into the workbook</li>
</ol>
<br />
The workbook contains macros and has a vba reference to Microsoft DAO 3.6 Object Library. My file is set up for Office 2003 on a 64 bit Windows 7 machine. It maybe necessary to change the reference if it cannot be found.<br />
<br />
<table cellpadding="0" cellspacing="0" class="tr-caption-container" style="float: left; text-align: left;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg9UfyWJxxCIeAii2F5CwP1jJpKrzc-SeipwounDoJrIE1yMjPF-PeqABUQtUdzk5CJ50uHj6TOXvnLsoJga2CnOSceq8qRPf_vPBZrDZgb7L3JZVTAgzmSpiDFQm-QH7yac8mP7NUMBs8/s1600/dbApp01.png" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img border="0" height="180" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEg9UfyWJxxCIeAii2F5CwP1jJpKrzc-SeipwounDoJrIE1yMjPF-PeqABUQtUdzk5CJ50uHj6TOXvnLsoJga2CnOSceq8qRPf_vPBZrDZgb7L3JZVTAgzmSpiDFQm-QH7yac8mP7NUMBs8/s1600/dbApp01.png" width="320" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;">Main Dialogue box</td></tr>
</tbody></table>
Running the main application provides dialogue box with buttons to select the available options.<br />
<br />
Open db shows a file dialogue box to select an mdb file to open. Sample mdb file can be found with my<a href="http://metamorphs.blogspot.com.au/2013/11/materials-library.html"> materials library</a>. Once a file has been selected a dialogue box displays showing the tables inside the data base file.<br />
<br />
A single table can then be selected. Then the fields belonging to that table can be displayed or the data in the table can be imported into the workbook. The data is not linked, it is copied into the workbook.<br />
<br />
<table cellpadding="0" cellspacing="0" class="tr-caption-container" style="float: left; text-align: left;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEimMIXQwiq81fOWfwWNXDms3qSGox63mEt2og9f39qSZp3Syg8q46E6t4bMTminap3srl8HWeN1VeGmObFhjUCH869-oy4-o2RnDac4h3sxmmKclW1u-OwtC7aOEgIKinpWSSgsniX7d8c/s1600/dbApp02.png" imageanchor="1" style="clear: left; margin-bottom: 1em; margin-left: auto; margin-right: auto;"><img border="0" height="180" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEimMIXQwiq81fOWfwWNXDms3qSGox63mEt2og9f39qSZp3Syg8q46E6t4bMTminap3srl8HWeN1VeGmObFhjUCH869-oy4-o2RnDac4h3sxmmKclW1u-OwtC7aOEgIKinpWSSgsniX7d8c/s1600/dbApp02.png" width="320" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;">Tables found inside the mdf </td></tr>
</tbody></table>
As such its not necessary to do this with Excel as it is able to import data directly from a MS Access table. However using linked data can be a problem if the data file moves, as it can be near impossible to update the links, and the spreadsheet typically needs to be re-built from scratch. Though newer versions of MS Excel this is apparently easier to do.<br />
<br />
Any case there are benefits to using MS Access to store data and retrieve using DAO. For example retrieving section properties more directly by name rather than by column number. Though it is possible to write complex formula and use Vlookup to get properties by name. (eg. get section properties like Ixx, Iyy). This is the approach used by my <a href="http://metamorphs-software.blogspot.com.au/2014/06/cold-formed-steel-member-checks-and.html">AS4600 cold-formed steel design spreadsheet</a>. Using vlookup tables is fine if just dealing with a single section and single segment, but when dealing with an entire building with many elements then DAO is the simpler more efficient option. {Or some alternative data base.}<br />
<br />
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="float: left; margin-right: 1em; text-align: left;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjIvxJHY4uX1fgiY1tM1zgGDrCgNz-ODcMJpOXnJfkIGmyzsaGSbJ6R9Q7Njh4IJ0UXl8xn86s___dJdLkKpXXtNJeAd0zogN9sVeSYX1ddO9e8FphqUWAbadax29tU5IQttMHHoCcQ4GY/s1600/dbApp03.png" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img border="0" height="230" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEjIvxJHY4uX1fgiY1tM1zgGDrCgNz-ODcMJpOXnJfkIGmyzsaGSbJ6R9Q7Njh4IJ0UXl8xn86s___dJdLkKpXXtNJeAd0zogN9sVeSYX1ddO9e8FphqUWAbadax29tU5IQttMHHoCcQ4GY/s1600/dbApp03.png" width="320" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;">Fields belonging to the selected table</td></tr>
</tbody></table>
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<br />
<div style="text-align: center;">
The worksheet can be found here: <a href="http://miscion.com.au/product/experiments-extracting-data-from-databases-with-spreadsheet/">dbExperiments.xls</a></div>
<br />
<br />
<b><u>Other Approach to Viewing mdb Files in Office without MS Access</u></b><br />
For a better view and querying of MS Access files look in the Microsoft office folder and find the main executable file for MS Query (MSQRY32.EXE for Office 2003). This uses .dqy files which are simple text files which can be edited with notepad or other plain text editor.<br />
<br />
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiXTLJObgozpsF3x947MW-vNIQAjN0eassZvdzJh1rtSkC8vnB-3UZGpxnJ9cQGK5O5l2ZFgtngcyBSec_uJiLJdHp5OskJhP9Sjnkjwo7426Wj34GkoYR385xRP3aNrlX4IkwZ71onfxU/s1600/dbApp04.png" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img border="0" height="164" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEiXTLJObgozpsF3x947MW-vNIQAjN0eassZvdzJh1rtSkC8vnB-3UZGpxnJ9cQGK5O5l2ZFgtngcyBSec_uJiLJdHp5OskJhP9Sjnkjwo7426Wj34GkoYR385xRP3aNrlX4IkwZ71onfxU/s1600/dbApp04.png" width="320" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;">MS Query</td></tr>
</tbody></table>
<br />
<table align="center" cellpadding="0" cellspacing="0" class="tr-caption-container" style="margin-left: auto; margin-right: auto; text-align: center;"><tbody>
<tr><td style="text-align: center;"><a href="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh49DQD1oGRbD6F04B-Zkmj5NVPKm7d8CEx9f3AkMLE-uW0uhLyTMkUvvse4HewHImwtpYGL0hnXRYmCZJh7jqaYJgWMhRoS4gYiTuS2AK5HMfcpEWxuHvgi63p868MAXtBpA_hGy0nlX4/s1600/dbApp05.png" imageanchor="1" style="margin-left: auto; margin-right: auto;"><img border="0" height="264" src="https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEh49DQD1oGRbD6F04B-Zkmj5NVPKm7d8CEx9f3AkMLE-uW0uhLyTMkUvvse4HewHImwtpYGL0hnXRYmCZJh7jqaYJgWMhRoS4gYiTuS2AK5HMfcpEWxuHvgi63p868MAXtBpA_hGy0nlX4/s1600/dbApp05.png" width="320" /></a></td></tr>
<tr><td class="tr-caption" style="text-align: center;">ODBC Data Source Administrator</td></tr>
</tbody></table>
<br />
<br />
<hr />
Revisions:<br />
[19/06/2014] Original<br />
[23/04/2016] Changed download links to MiScion Pty Ltd Web Store<br />
<br />Conrad Harrisonhttp://www.blogger.com/profile/11351972303793021889noreply@blogger.comtag:blogger.com,1999:blog-4489837633148400033.post-15259942947747328192014-06-19T14:37:00.000+09:302016-04-23T16:02:39.035+09:30Experiments with XML Data files and TreeviewsExperimenting with <a href="http://www.w3schools.com/xml/xml_whatis.asp">XML</a> files as format for storing configuration parameters and main data for applications. Using <a href="http://en.wikipedia.org/wiki/MSXML">MSXML</a> and <a href="http://www.w3schools.com/XPath/">XPath</a> seemed difficult to directly get at the data, lot easier to extra attributes and their values than data records. So figured as a basic starting point see if could traverse the whole tree and display the data as an indented list in an Excel worksheet and also in a treeview form. I believe that XQuery is the mechanism to get data, but not sure how that relates to MSXML.<br />
<br />
The main application is a subroutine called MainApplication. It contains various calls to subroutines which are either commented out or active. It is set to allow the user to select an XML file and open it and display in a treeview component. Sample data can be obtained from my<a href="http://metamorphs.blogspot.com.au/2013/11/software-for-barrier-design-calculations.html"> barrier design application</a> just extract the xml file from the zip file.<br />
<br />
The subroutine: xmlDislayIndentedList will display the data in the worksheet and also display some information about the type of xml node. It also highlights with a green background the final leaf node containing the text data.<br />
<br />
The worksheet can be obtained here: <a href="http://miscion.com.au/product/experiments-with-xml-file/">xmlExperiments.xls</a><br />
<br />
<br />
<hr />
Revisions:<br />
[19/06/2014] Original<br />
[23/04/2016] Changed download links to MiScion Pty Ltd Web Store<br />
<div>
<br /></div>
Conrad Harrisonhttp://www.blogger.com/profile/11351972303793021889noreply@blogger.comtag:blogger.com,1999:blog-4489837633148400033.post-71281407456623381632014-06-19T14:09:00.002+09:302016-04-23T16:04:12.786+09:30Bill of Materials and Equivalent Binary TreeA simple spreadsheet using <a href="http://en.wikipedia.org/wiki/Binary_tree">binary trees</a> to build a bill of materials. Two displays are included:<br />
<br />
<ol>
<li>A simple indented list placed in the Excel worksheet</li>
<li>An expandable/collapsible <a href="http://www.excelguru.ca/content.php?194-Using-a-Treeview-Control">treeview </a>component on a form.</li>
</ol>
<br />
The two main subroutines are:<br />
<br />
<ol>
<li>mainAppBuildTree (builds a tree and displays in worksheet as indented list)</li>
<li>mainAppViewTree (builds a tree and displays in treeview component)</li>
</ol>
<br />
Data is taken from the worksheet. Two tables are required one listing all items and providing a unique key code for. Another list providing assembly definitions as single level bills of materials. These single level bills of materials are then exploded to build the entire product structure tree. To do this <a href="http://en.wikipedia.org/wiki/Stack_(abstract_data_type)">stacks </a>are used.<br />
<br />
The spreadsheet can be downloaded here: <a href="http://miscion.com.au/product/experiments-with-abstract-data-structures-trees/">treeExperiments2014.xls </a>
<br />
<br />
Other Experiments with Bill's of materials can be found on my ExcelCalcs profile:<br />
<br />
<ol>
<li><a href="http://www.excelcalcs.com/repository/misc.-topics/exploded-bom-%28bill-of-materials%29/">exploded BOM (Bill of Materials) </a></li>
<li><a href="http://www.excelcalcs.com/repository/misc.-topics/ie%10pom%10capm-automatic-explosion-of-bill-of-materials/">IE/POM/CAPM Automatic Explosion of Bill of Materials</a></li>
<li><a href="http://www.excelcalcs.com/repository/misc.-topics/indented-bill-of-material/">Indented Bill of Material</a></li>
</ol>
<div>
Actually revisited trees so could display an <a href="http://en.wikipedia.org/wiki/XML">XML </a>data file in a tree.<br />
<br />
<br />
<br />
<hr />
Revisions:<br />
[19/06/2014] Original<br />
[23/04/2016] Changed download links to MiScion Pty Ltd Web Store</div>
<div>
<br /></div>
Conrad Harrisonhttp://www.blogger.com/profile/11351972303793021889noreply@blogger.comtag:blogger.com,1999:blog-4489837633148400033.post-32273104134671818652014-06-17T13:53:00.000+09:302016-04-18T23:48:13.320+09:30Experiments Parsing Acad DXF files using vba<span style="font-size: 8pt;">Taken from the <a href="http://www.excelcalcs.com/index.php?option=com_remository&func=fileinfo&id=592">ExcelCalcs.com</a> website.</span><iframe align="top" height="650" id="ExcelCalcsSample592" name="ExcelCalcsSample592" scrolling="auto" src="http://www.excelcalcs.com/index2.php?option=com_remository&func=fileinfo&id=592" width="100%">This option will not work correctly. Unfortunately, your browser does not support Inline Frames</iframe>
<br />
<br />
<div>
<br />
<hr />
Related Posts:
<br />
<br />
<a href="http://metamorphs.blogspot.com.au/2015/05/bundle-of-my-excelcalcs-uploads.html">Bundle of my ExcelCalcs UpLoads</a>
<br />
<br />
The bundle can be downloaded from MiScion Pty Ltd : <a href="http://miscion.com.au/product/spreadsheet-bundle/">Spreadsheet Bundle</a><br />
<br /></div>
Conrad Harrisonhttp://www.blogger.com/profile/11351972303793021889noreply@blogger.comtag:blogger.com,1999:blog-4489837633148400033.post-70816168214669530312014-06-17T13:50:00.000+09:302016-04-18T23:44:43.405+09:30Automating Acad LT using scripts generated by Excel/vba<span style="font-size: 8pt;">Taken from the <a href="http://www.excelcalcs.com/index.php?option=com_remository&func=fileinfo&id=591">ExcelCalcs.com</a> website.</span><iframe align="top" height="650" id="ExcelCalcsSample591" name="ExcelCalcsSample591" scrolling="auto" src="http://www.excelcalcs.com/index2.php?option=com_remository&func=fileinfo&id=591" width="100%">This option will not work correctly. Unfortunately, your browser does not support Inline Frames</iframe>
<br />
<br />
<div>
<br />
<hr />
Related Posts:
<br />
<br />
<a href="http://metamorphs.blogspot.com.au/2015/05/bundle-of-my-excelcalcs-uploads.html">Bundle of my ExcelCalcs UpLoads</a>
<br />
<br />
The bundle can be downloaded from MiScion Pty Ltd : <a href="http://miscion.com.au/product/spreadsheet-bundle/">Spreadsheet Bundle</a><br />
<br /></div>
Conrad Harrisonhttp://www.blogger.com/profile/11351972303793021889noreply@blogger.comtag:blogger.com,1999:blog-4489837633148400033.post-88201081251234869242014-06-17T13:48:00.000+09:302016-04-18T23:49:05.053+09:30VBA Experiments with Class Objects<span style="font-size: 8pt;">Taken from the <a href="http://www.excelcalcs.com/index.php?option=com_remository&func=fileinfo&id=590">ExcelCalcs.com</a> website.</span><iframe align="top" height="650" id="ExcelCalcsSample590" name="ExcelCalcsSample590" scrolling="auto" src="http://www.excelcalcs.com/index2.php?option=com_remository&func=fileinfo&id=590" width="100%">This option will not work correctly. Unfortunately, your browser does not support Inline Frames</iframe>
<br />
<br />
<div>
<br />
<hr />
Related Posts:
<br />
<br />
<a href="http://metamorphs.blogspot.com.au/2015/05/bundle-of-my-excelcalcs-uploads.html">Bundle of my ExcelCalcs UpLoads</a>
<br />
<br />
The bundle can be downloaded from MiScion Pty Ltd : <a href="http://miscion.com.au/product/spreadsheet-bundle/">Spreadsheet Bundle</a><br />
<br /></div>
Conrad Harrisonhttp://www.blogger.com/profile/11351972303793021889noreply@blogger.comtag:blogger.com,1999:blog-4489837633148400033.post-49951727616494150352014-06-17T13:46:00.000+09:302016-04-18T23:54:49.241+09:30Collection of Short Excel/vba macros to assist learning vba<span style="font-size: 8pt;">Taken from the <a href="http://www.excelcalcs.com/index.php?option=com_remository&func=fileinfo&id=588">ExcelCalcs.com</a> website.</span><iframe align="top" height="650" id="ExcelCalcsSample588" name="ExcelCalcsSample588" scrolling="auto" src="http://www.excelcalcs.com/index2.php?option=com_remository&func=fileinfo&id=588" width="100%">This option will not work correctly. Unfortunately, your browser does not support Inline Frames</iframe>
<br />
<br />
<div>
<br />
<hr />
Related Posts:
<br />
<br />
<a href="http://metamorphs.blogspot.com.au/2015/05/bundle-of-my-excelcalcs-uploads.html">Bundle of my ExcelCalcs UpLoads</a>
<br />
<br />
The bundle can be downloaded from MiScion Pty Ltd : <a href="http://miscion.com.au/product/spreadsheet-bundle/">Spreadsheet Bundle</a><br />
<br /></div>
Conrad Harrisonhttp://www.blogger.com/profile/11351972303793021889noreply@blogger.comtag:blogger.com,1999:blog-4489837633148400033.post-85809862053006951612014-06-17T13:44:00.000+09:302016-04-18T23:49:37.155+09:30Automatic Explosion of Single Level Bill of Materials into full Product Tree<span style="font-size: 8pt;">Taken from the <a href="http://www.excelcalcs.com/index.php?option=com_remository&func=fileinfo&id=593">ExcelCalcs.com</a> website.</span><iframe align="top" height="650" id="ExcelCalcsSample593" name="ExcelCalcsSample593" scrolling="auto" src="http://www.excelcalcs.com/index2.php?option=com_remository&func=fileinfo&id=593" width="100%">This option will not work correctly. Unfortunately, your browser does not support Inline Frames</iframe>
<br />
<br />
<div>
<br />
<hr />
Related Posts:
<br />
<br />
<a href="http://metamorphs.blogspot.com.au/2015/05/bundle-of-my-excelcalcs-uploads.html">Bundle of my ExcelCalcs UpLoads</a>
<br />
<br />
The bundle can be downloaded from MiScion Pty Ltd : <a href="http://miscion.com.au/product/spreadsheet-bundle/">Spreadsheet Bundle</a><br />
<br /></div>
Conrad Harrisonhttp://www.blogger.com/profile/11351972303793021889noreply@blogger.comtag:blogger.com,1999:blog-4489837633148400033.post-26608015787071384402014-06-17T13:41:00.002+09:302016-04-18T23:50:26.175+09:30More Bill of Materials Worksheets<span style="font-size: 8pt;">Taken from the <a href="http://www.excelcalcs.com/index.php?option=com_remository&func=fileinfo&id=637">ExcelCalcs.com</a> website.</span><iframe align="top" height="650" id="ExcelCalcsSample637" name="ExcelCalcsSample637" scrolling="auto" src="http://www.excelcalcs.com/index2.php?option=com_remository&func=fileinfo&id=637" width="100%">This option will not work correctly. Unfortunately, your browser does not support Inline Frames</iframe>
<br />
<br />
<div>
<br />
<hr />
Related Posts:
<br />
<br />
<a href="http://metamorphs.blogspot.com.au/2015/05/bundle-of-my-excelcalcs-uploads.html">Bundle of my ExcelCalcs UpLoads</a>
<br />
<br />
The bundle can be downloaded from MiScion Pty Ltd : <a href="http://miscion.com.au/product/spreadsheet-bundle/">Spreadsheet Bundle</a><br />
<br />
<br /></div>
Conrad Harrisonhttp://www.blogger.com/profile/11351972303793021889noreply@blogger.comtag:blogger.com,1999:blog-4489837633148400033.post-53554359141696989572014-06-17T13:39:00.000+09:302016-04-18T23:51:02.824+09:30Simple indented bill of materials worksheet<span style="font-size: 8pt;">Taken from the <a href="http://www.excelcalcs.com/index.php?option=com_remository&func=fileinfo&id=584">ExcelCalcs.com</a> website.</span><iframe align="top" height="650" id="ExcelCalcsSample584" name="ExcelCalcsSample584" scrolling="auto" src="http://www.excelcalcs.com/index2.php?option=com_remository&func=fileinfo&id=584" width="100%">This option will not work correctly. Unfortunately, your browser does not support Inline Frames</iframe>
<br />
<br />
<div>
<br />
<hr />
Related Posts:
<br />
<br />
<a href="http://metamorphs.blogspot.com.au/2015/05/bundle-of-my-excelcalcs-uploads.html">Bundle of my ExcelCalcs UpLoads</a>
<br />
<br />
The bundle can be downloaded from MiScion Pty Ltd : <a href="http://miscion.com.au/product/spreadsheet-bundle/">Spreadsheet Bundle</a><br />
<br /></div>
Conrad Harrisonhttp://www.blogger.com/profile/11351972303793021889noreply@blogger.comtag:blogger.com,1999:blog-4489837633148400033.post-62187470724604036512014-06-17T13:35:00.002+09:302016-04-18T23:50:04.082+09:30Experimenting with MS Excel Shapes layer to Draw Shed Framing Plans<span style="font-size: 8pt;">Taken from the <a href="http://www.excelcalcs.com/index.php?option=com_remository&func=fileinfo&id=704">ExcelCalcs.com</a> website.</span><iframe align="top" height="650" id="ExcelCalcsSample704" name="ExcelCalcsSample704" scrolling="auto" src="http://www.excelcalcs.com/index2.php?option=com_remository&func=fileinfo&id=704" width="100%">This option will not work correctly. Unfortunately, your browser does not support Inline Frames</iframe>
<br />
<br />
<div>
<br />
<hr />
Related Posts:
<br />
<br />
<a href="http://metamorphs.blogspot.com.au/2015/05/bundle-of-my-excelcalcs-uploads.html">Bundle of my ExcelCalcs UpLoads</a>
<br />
<br />
The bundle can be downloaded from MiScion Pty Ltd : <a href="http://miscion.com.au/product/spreadsheet-bundle/">Spreadsheet Bundle</a><br />
<br /></div>
Conrad Harrisonhttp://www.blogger.com/profile/11351972303793021889noreply@blogger.com