excelicious.wordpress.com

Number Cruncher

April 6, 2015. So how can we tell what’s changed? The SAS Compare procedure. Is a very handy tool in this situation, providing a quick, automated means of determining differences in type and value between one dataset and another. Here’s an example of how I’ve used it recently in testing migrated data:. A couple of PowerShell scripts. March 23, 2015. March 24, 2015. I’ve been making a little more use of PowerShell recently. It’s a very handy addition to the Windows environment, certainly i...The directory...

http://excelicious.wordpress.com/

OVERVIEW OF excelicious.wordpress.com

TRAFFIC RANK

>1,000,000

REVIEWS

0

PAGES IN THIS WEBSITE

20

LINKS TO THIS WEBSITE

CONTACTS

ADDRESSES

SOCIAL LINKS

ONLINE SINCE

WEBSITE DETAILS

SEO

PAGES

SIMILAR SITES

TRAFFIC RANK FOR EXCELICIOUS.WORDPRESS.COM

TODAY'S RATING

>1,000,000

TRAFFIC RANK - AVERAGE PER MONTH

BEST MONTH

December

AVERAGE PER DAY Of THE WEEK

HIGHEST TRAFFIC ON

Friday

TRAFFIC BY CITY

Sign up

CUSTOMER REVIEWS

Average Rating: 3.6 out of 5 with 10 reviews

5 star

3

4 star

4

3 star

1

2 star

0

1 star

2

Hey there! Start your review of excelicious.wordpress.com

AVERAGE USER RATING

Write a Review

WEBSITE PREVIEW

LOAD TIME

0.8 seconds

FAVICON PREVIEW

16x16
32x32

CONTACTS AT EXCELICIOUS.WORDPRESS.COM

ADD CONTACT

Login

TO VIEW CONTACTS

Remove Contacts

FOR PRIVACY ISSUES

CONTENT

PAGES IN
THIS WEBSITE

20

SSL

EXTERNAL LINKS

14

SITE IP

192.0.78.13

LOAD TIME

0.754 sec

SCORE

6.2

PAGE TITLE

Number Cruncher | excelicious.wordpress.com Reviews

<META> DESCRIPTION

April 6, 2015. So how can we tell what’s changed? The SAS Compare procedure. Is a very handy tool in this situation, providing a quick, automated means of determining differences in type and value between one dataset and another. Here’s an example of how I’ve used it recently in testing migrated data:. A couple of PowerShell scripts. March 23, 2015. March 24, 2015. I’ve been making a little more use of PowerShell recently. It’s a very handy addition to the Windows environment, certainly i...The directory...

<META> KEYWORDS

1 skip to content

2 number cruncher

3 menu

4 about geoff

5 code samples

6 python

7 com automation

8 data access

9 fp library

10 math functions

CONTENT

Page content here

KEYWORDS ON PAGE

skip to content,number cruncher,menu,about geoff,code samples,python,com automation,data access,fp library,math functions,string functions,regex functions,utility functions,downloads,dare to compare,leave a comment,advertisements,tricks with type,costs

SERVER

nginx

CONTENT-TYPE

utf-8

GOOGLE PREVIEW

Number Cruncher | excelicious.wordpress.com Reviews

https://excelicious.wordpress.com

April 6, 2015. So how can we tell what’s changed? The SAS Compare procedure. Is a very handy tool in this situation, providing a quick, automated means of determining differences in type and value between one dataset and another. Here’s an example of how I’ve used it recently in testing migrated data:. A couple of PowerShell scripts. March 23, 2015. March 24, 2015. I’ve been making a little more use of PowerShell recently. It’s a very handy addition to the Windows environment, certainly i...The directory...

INTERNAL PAGES

excelicious.wordpress.com

1

Downloads – Number Cruncher

https://excelicious.wordpress.com/downloads

Regular Expressions Excel Add-in. 8211; latest and greatest version, compatible with 2007/10 only. Features a fancy new form to evaluate regular expressions against a test string, as well as all the old worksheet functions. 8211; to go with the above version. 8211; the original version for those still using Excel without a Ribbon. Nothing fancy here, just the worksheet functions. One thought on “ Downloads. Pingback: Regular Expressions – new version « Number Cruncher. Leave a Reply Cancel reply. A Byte ...

2

COM automation – Number Cruncher

https://excelicious.wordpress.com/code-samples/python/com-automation

Scripts which make use of the win32com.client package to automate Excel and other applications:. RunInExcel.py - opens named Excel file fName, runs named macro # macName import os, os.path, win32com.client def run macro(fName, macName, path=os.getcwd() : pre: fName is the name a valid Excel file with macro macName post: fName! MacName xlApp.Run(macName) fTest.Close(1) xlApp.Quit() xlApp = None if name = main : run macro(PythonTest.xls, helloFromPython). Leave a Reply Cancel reply. Enter your comment here.

3

Code Samples – Number Cruncher

https://excelicious.wordpress.com/code-samples

Here I’ll be placing some samples of code I’ve written. Feel free to use or improve anything that’s in here, or comment if you have suggestions or anything else to add. Leave a Reply Cancel reply. Enter your comment here. Fill in your details below or click an icon to log in:. Address never made public). You are commenting using your WordPress.com account. ( Log Out. You are commenting using your Twitter account. ( Log Out. You are commenting using your Facebook account. ( Log Out. Summing a random sample.

4

Random Sampling in VBA – Number Cruncher

https://excelicious.wordpress.com/2009/02/07/random-sampling-in-vba

Random Sampling in VBA. February 7, 2009. February 8, 2009. Occasionally we get asked to provide random samples from our database, and it’s the sort of thing that can be done very easily in SAS. For example, here’s a SAS routine I have often used to extract a sample. Of size 100 without replacement from a large dataset. I can’t remember where this code originally came from but I definitely can’t take credit for it):. Data sampleset (drop=remainder size);. Do while (size 0);. LOb = lOb 1. On Type or Class?

5

FP Library – Number Cruncher

https://excelicious.wordpress.com/code-samples/python/fp-library

Some code from a recent session learning about functional programming…. Leave a Reply Cancel reply. Enter your comment here. Fill in your details below or click an icon to log in:. Address never made public). You are commenting using your WordPress.com account. ( Log Out. You are commenting using your Twitter account. ( Log Out. You are commenting using your Facebook account. ( Log Out. You are commenting using your Google account. ( Log Out. Notify me of new comments via email. How do you SQL in Excel?

UPGRADE TO PREMIUM TO VIEW 15 MORE

TOTAL PAGES IN THIS WEBSITE

20

LINKS TO THIS WEBSITE

roymacleanvba.wordpress.com

Back, Briefly: Exporting XML From Excel Tables | Roy MacLean's VBA Blog

https://roymacleanvba.wordpress.com/2012/12/08/back-briefly-exporting-xml-from-excel-tables

Roy MacLean's VBA Blog. Miscellanea on VBA, Office Apps and XML Documentation. Exporting XML From Excel Tables – 2: Object Model. Back, Briefly: Exporting XML From Excel Tables. December 8, 2012. Tags: microsoft office files. Since the test definitions fall naturally into a tabular form, Excel is an obvious front-end tool. The problem is how to make the data accessible to a testing harness. One way is to use Apache POI. A Java API for accessing Microsoft Office files – and our developer was keen to...

roymacleanvba.wordpress.com

Still here… | Roy MacLean's VBA Blog

https://roymacleanvba.wordpress.com/2011/03/05/still-here

Roy MacLean's VBA Blog. Miscellanea on VBA, Office Apps and XML Documentation. Analysing Cross-references Between Documents. March 5, 2011. Sorry the postings have been a bit thin on the ground since the New Year. Rather unexpectedly some freelance work has developed into a permanent position. I am now in a role which is primarily focused on DITA/XML documentation. Response to “Still here…”. Feed for this Entry. July 27, 2011 at 6:13 am. Leave a Reply Cancel reply. Enter your comment here. You are commen...

roymacleanvba.wordpress.com

An Alternative to VBA in Excel? | Roy MacLean's VBA Blog

https://roymacleanvba.wordpress.com/2011/01/26/an-alternative-to-vba-in-excel

Roy MacLean's VBA Blog. Miscellanea on VBA, Office Apps and XML Documentation. Moving Data Out of Outlook – part 2. Analysing Cross-references Between Documents. An Alternative to VBA in Excel? January 26, 2011. Back last year, Gareth Hayter of Slyce Software emailed me about VScript. An alternative to VBA for writing functions and macros in Excel. Unfortunately, for various reasons, I have not been able to look into it in any detail, but it certainly sounds interesting. VScript is based on Excel-Dna.

tvmcalcs.com

Update to Variance/Covariance Matrix Builder for Excel 2010 and 2013 | TVMCalcs.com

http://www.tvmcalcs.com/blog/comments/update_to_variance_covariance_matrix_builder_for_excel_2010_and_2013

Skip to primary content. Excel tips and tricks by Timothy R. Mayes, Ph.D. I am the author of Financial Analysis with Microsoft Excel, 7th ed. And am a faculty member in the Finance Department at Metropolitan State University of Denver. Blogs that I Read. Daily Dose of Excel. John Walkenbach's Spreadsheet Page Blog. Jon Peltier's PTS Blog. Nick Hodge at Excel Users Group. Mark J. Perry's Carpe Diem. Debra Dalgleish's Contextures Blog. Jensen Harris - Office User Interface. Sunday, October 26, 2014. Well, ...

roymacleanvba.wordpress.com

worksheet | Roy MacLean's VBA Blog

https://roymacleanvba.wordpress.com/2012/12/08/back-briefly-exporting-xml-from-excel-tables/worksheet-2

Roy MacLean's VBA Blog. Miscellanea on VBA, Office Apps and XML Documentation. Back, Briefly: Exporting XML From Excel Tables. Responses to “worksheet”. Feed for this Entry. Leave a Reply Cancel reply. Enter your comment here. Fill in your details below or click an icon to log in:. Address never made public). You are commenting using your WordPress.com account. ( Log Out. You are commenting using your Twitter account. ( Log Out. You are commenting using your Facebook account. ( Log Out.

roymacleanvba.wordpress.com

Exporting XML From Excel Tables – 3: Self-checking Structure | Roy MacLean's VBA Blog

https://roymacleanvba.wordpress.com/2012/12/27/exporting-xml-from-excel-tables-3-self-checking-structure

Roy MacLean's VBA Blog. Miscellanea on VBA, Office Apps and XML Documentation. Exporting XML From Excel Tables – 2: Object Model. Exporting XML From Excel Tables – 3: Self-checking Structure. December 27, 2012. In the previous post. Having built a hierarchical object structure from our worksheet data, there are a number of other things we might want to do:. Check the test definitions for structural validity. Generate output in other formats, such as plain text (really plain, not XML). These properties he...

roymacleanvba.wordpress.com

Analysing Cross-references Between Documents | Roy MacLean's VBA Blog

https://roymacleanvba.wordpress.com/2011/01/28/analysing-cross-references-between-documents

Roy MacLean's VBA Blog. Miscellanea on VBA, Office Apps and XML Documentation. An Alternative to VBA in Excel? Analysing Cross-references Between Documents. January 28, 2011. I have recently been working on a set of about 200 Use Case documents, converting them into DITA. This kind of totalling is Pivot Table territory. So the question arises of how to contruct the basic data about the cross-references – a table of A-references-B records – and how to get it into Excel. Here’s the code of the query:.

roymacleanvba.wordpress.com

Digression on Documentation: DITA | Roy MacLean's VBA Blog

https://roymacleanvba.wordpress.com/2009/08/25/digression-on-documentation-dita

Roy MacLean's VBA Blog. Miscellanea on VBA, Office Apps and XML Documentation. Domain Specific Languages Part 3. Email Auto-Reply with Availability. Digression on Documentation: DITA. August 25, 2009. As is the way of things, I’ve been diverted from the delights of VBA, on to some other work. This is a migration of the system definition documentation for a major financial system, from traditional Word documents to an XML-based architecture called DITA. With a relational database, the information records ...

roymacleanvba.wordpress.com

Exporting XML From Excel Tables – 2: Object Model | Roy MacLean's VBA Blog

https://roymacleanvba.wordpress.com/2012/12/16/exporting-xml-from-excel-tables-2-object-model

Roy MacLean's VBA Blog. Miscellanea on VBA, Office Apps and XML Documentation. Back, Briefly: Exporting XML From Excel Tables. Exporting XML From Excel Tables – 3: Self-checking Structure. Exporting XML From Excel Tables – 2: Object Model. December 16, 2012. In the previous post. The multi-level numerical ID is complex enough to warrant a VBA Class Module of its own. This allows us to do things like asking an ID what level it’s at, or asking for a new ID for its Nth child. Each of the five classes has a.

roymacleanvba.wordpress.com

XML | Roy MacLean's VBA Blog

https://roymacleanvba.wordpress.com/2012/12/08/back-briefly-exporting-xml-from-excel-tables/xml-2

Roy MacLean's VBA Blog. Miscellanea on VBA, Office Apps and XML Documentation. Back, Briefly: Exporting XML From Excel Tables. Responses to “XML”. Feed for this Entry. Leave a Reply Cancel reply. Enter your comment here. Fill in your details below or click an icon to log in:. Address never made public). You are commenting using your WordPress.com account. ( Log Out. You are commenting using your Twitter account. ( Log Out. You are commenting using your Facebook account. ( Log Out. Diff for Access Tables.

UPGRADE TO PREMIUM TO VIEW 4 MORE

TOTAL LINKS TO THIS WEBSITE

14

SOCIAL ENGAGEMENT

geoff_ness

OTHER SITES

excelic.com

Brand excelic is for sale on Brandroot.com!

Excelic.com is a business name for sale Buy Now. Excelic.com is for sale Buy. Own this Business Name! The most successful businesses have easily recognizable names that customers can connect with. This great name is available for purchase! Excelic.COM IS FOR SALE! This premium business name is available for purchase and ready for you to use! We specialize in providing the best, available business names. Get this one before someone else does! Excelic.com $1,895. Capable and successful persona. With your b...

excelica.com

Exelica is a set of Java-based spreadsheet reporting tools designed to integrate with Java software applications

Exelica Add-in for Microsoft Excel. You are not signed in. No More Reformatting. No More Exporting. Now you can get MS Excel compatible reports with active formulas from your Java application. Is there a better way to give business users what they want? Inquire about partnership opportunities with Exelica. The Need for Exelica. Appeal to Business Users. Generate rich, precisely formatted, ready to print, spreadsheet reports without awkward exports or conversions. People want to include MS Excel in their ...

excelicast.com

Excelicast | A Marketing Consulting Company

Darr; Skip to Main Content. Get Ahead of Your Competitors. At Excelicast, we are passionate about your success! Based out of San Diego, California, our talented team works diligently with yours to meet all of your marketing needs while expanding your growth and following by using our innovative, proven tactics. Learn How We Can Help You Today! We'd love to connect with you! Join us on Facebook and Twitter to see what we're up to! See what we're currently working on and who we're working with.

excelice67-compteurs.com

Compteurs Copieurs

3, rue Alexandre Volta. Tél : 03 90 20 32 03. Site web : www.soludoc.pro.

excelicious.deviantart.com

Excelicious (Excel) - DeviantArt

Window.devicePixelRatio*screen.width 'x' window.devicePixelRatio*screen.height) :(screen.width 'x' screen.height) ; this.removeAttribute('onclick')" class="mi". Window.devicePixelRatio*screen.width 'x' window.devicePixelRatio*screen.height) :(screen.width 'x' screen.height) ; this.removeAttribute('onclick')". Join DeviantArt for FREE. Forgot Password or Username? Traditional Art / Student. Deviant for 11 Months. This deviant's full pageview. Last Visit: 3 days ago. You can drag and drop to rearrange.

excelicious.wordpress.com

Number Cruncher

April 6, 2015. So how can we tell what’s changed? The SAS Compare procedure. Is a very handy tool in this situation, providing a quick, automated means of determining differences in type and value between one dataset and another. Here’s an example of how I’ve used it recently in testing migrated data:. A couple of PowerShell scripts. March 23, 2015. March 24, 2015. I’ve been making a little more use of PowerShell recently. It’s a very handy addition to the Windows environment, certainly i...The directory...

excelicl.com

Excel Insurance

The Vision of Excel Insurance Company Limited is to become one of the preferred insurance companies of the country by providing insurance services as per excellence to its customers resulting in peace of mind to its clients. Trial Support and Consulting. Technology Experience and Competence.

excelics.com

excelict.com

EXCELICT TECHNOLOGY CONSULTING

8212; Main Menu —. Policy Advisory & Government Service. Web & Mobility. Trainee or Junior Software Developers PHP. Sales & Marketing Executive. Transform & Globalize. Policy Advisory & Government Service. Web & Mobility. Trainee or Junior Software Developers PHP. Sales & Marketing Executive. INDIA is the leading FDI destination for offshoring and manufacturing. Access to quality global talent pool key to success. Value driven approach to consulting help Busiensses and Government. IT Services for SMEs.

excelicus.com

Home

Poverty projects for young people who need the basics of life now and. Need hope for the future. On training and development partnerships. Vocational skills and rural management. Line communications and business. Supporting the rescue of street kids and orphans who need the basics of life now and. Need hope for the future. Primary and secondary schooling.

excelicus.org

www.excelicus.org

This Web page parked FREE courtesy of LIFEDOMAINS.NET. Search for domains similar to. Is this your domain? Let's turn it into a website! Would you like to buy this. Find Your Own Domain Name. See our full line of products. Call us any time day or night .