| QuSheet Sample Scenario |
| As well as providing a sophisticated user interface, QuSheet accepts data from other applications via a straight cut & paste operation or using a more sophisticated XML data interface. |
| As well as providing a sophisticated user interface, QuSheet accepts data from other applications via a straight cut & paste operation or using a more sophisticated XML data interface. |
| QuSheet's table-driven interface allows you to define selection and filtering criteria which organise your data into summary and detail paragraphs. |
| QuSheet's table-driven interface allows you to define selection and filtering criteria which organise your data into summary and detail paragraphs. |
| QuSheet automatically organises calculations to show results and "workings out" as paragraphs and sub-paragraphs. |
| QuSheet automatically organises calculations to show results and "workings out" as paragraphs and sub-paragraphs. |
| View (duration 4m 30s) |
| You will need to view this page on a non-handheld screen to see the presentation. |
| For other presentations: |
| For other presentations: |
| Click here to see the business benefits of Dynamic Documents. |
| Click here to see the business benefits of Dynamic Documents. |
| Click here to see QuSheet in use. |
| Click here to see QuSheet in use. |
| Transcript |
| Background |
| Let me assume that I run a haulage company consisting of three trucks: Huey, Dewey and Louis and a customer base for which I provide the following services: |
| I will make a delivery to a fixed location for a fixed price |
| Or I will make a delivery to an alternate location for a price based on mileage. |
| Or I will allow my trucks to be hired out at a daily rate. |
| Input |
| All of my pricing information is held on Excel spreadsheets - here three tables showing prices by day, by destination and by mileage. |
| And I also maintain a table showing my activities for the week (here you see that for a given customer, and truck, and date, I either fill in the number of days for a daily hire, or the mileage out and mileage in when a truck was delivering on that basis, or the destination name when I was delivering to one of my well known and well priced destinations). |
| Additionally, I use the first column of the table to hold any extra notes that I wish to report for a given activity. |
| QuSheet |
| Now I have set up QuSheet to use these particular tables directly, as you can see here. And I can transfer information between Excel and QuSheet with a simple Copy and Paste function, or I can use an XML link to transfer all of my tables, cleanly, through an export and import function. |
| Every week, after I have imported my weekly schedule, plus any changes I have made to my prices, I can use the Generate button on QuSheet to create an HTML report. |
| Output |
| On the top line there's a statement showing the dates for which the report applies and a calculated revenue figure. |
| Below that, under three headings, are breakdowns of that revenue, showing individual activities colour-coded according to whether they were for a fixed rate, a mileage or a daily hire. |
| By clicking on these lines I can expand to show how the individual calculations were made, and also display any extra notes that I have recorded for a given activity. |
| Where the information is displayed by customer or by truck, QuSheet automatically presents the tables of data showing the highest revenue earner first. |
| Finally |
| This example can be found on the QuSheet web site and, as with all examples, you are also able to download the source project file so that you can use it in QuSheet yourself and see what you can do. |
| Transcript » |
| « Transcript |
| « Background |
| Let me assume that I run a haulage company consisting of three trucks: Huey, Dewey and Louis and a customer base for which I provide the following services: |
| I will make a delivery to a fixed location for a fixed price |
| Or I will make a delivery to an alternate location for a price based on mileage. |
| Or I will allow my trucks to be hired out at a daily rate. |
| « Input |
| All of my pricing information is held on Excel spreadsheets - here three tables showing prices by day, by destination and by mileage. |
| And I also maintain a table showing my activities for the week (here you see that for a given customer, and truck, and date, I either fill in the number of days for a daily hire, or the mileage out and mileage in when a truck was delivering on that basis, or the destination name when I was delivering to one of my well known and well priced destinations). |
| Additionally, I use the first column of the table to hold any extra notes that I wish to report for a given activity. |
| « QuSheet |
| Now I have set up QuSheet to use these particular tables directly, as you can see here. And I can transfer information between Excel and QuSheet with a simple Copy and Paste function, or I can use an XML link to transfer all of my tables, cleanly, through an export and import function. |
| Every week, after I have imported my weekly schedule, plus any changes I have made to my prices, I can use the Generate button on QuSheet to create an HTML report. |
| « Output |
| On the top line there's a statement showing the dates for which the report applies and a calculated revenue figure. |
| Below that, under three headings, are breakdowns of that revenue, showing individual activities colour-coded according to whether they were for a fixed rate, a mileage or a daily hire. |
| By clicking on these lines I can expand to show how the individual calculations were made, and also display any extra notes that I have recorded for a given activity. |
| Where the information is displayed by customer or by truck, QuSheet automatically presents the tables of data showing the highest revenue earner first. |
| « Finally |
| This example can be found on the QuSheet web site and, as with all examples, you are also able to download the source project file so that you can use it in QuSheet yourself and see what you can do. |
-> output produced by QuSheet, licenced to "Richard Develyn", 15 Oct 2009 130|1|24094