Tag Archives: report

Techedge Time and Expenses report use instructions

Hi all,

here you can find a set of instructions on how to use the Time and Expenses Excel reports.

The Time Excel report can be found here:

http://www.plinky.it/blog/index.php/2009/01/27/techedge-timereport-in-excel-ii/

The Expenses Excel report can be found here:

http://www.plinky.it/blog/index.php/2009/02/01/techedge-expenses-report-in-excel/

Continue reading Techedge Time and Expenses report use instructions

Minor updates of TECHEDGE Time and Expense Excel reports

Hi all,

today I made some minor updates to TECHEDGE Time and Expense Excel reports. Basically, Ivan found out that from our Techedge office the timereport on the URL .it does not work. So, I just inserted a timeout of 30 seconds. Therefore, if you run a function of loading data on the web or updating the projects list, after 30 seconds it will throw an error if the ie is still busy.

So, now thanks to Ivan we eliminated one more bug. 🙂

These Excel reports are available at:

ExpensesReport_Example.zip and

TimeReport_Example II.zip

Enjoy! 🙂

You might also want to see the previous post about the updates:

http://www.plinky.it/blog/index.php/2009/03/31/update-of-techedge-time-and-expense-excel-reports/

Best wishes,

Valera 🙂

Techedge EXPENSES report in Excel

Hi guys,

here you can download the first version of Techedge Expenses report in Excel tool that allows filling in our internal Techedge expenses report from Excel.

Here you can find the related post on Techedge Time report: http://www.plinky.it/blog/index.php/2009/01/27/techedge-timereport-in-excel-ii/

I didn’t record a video presentation on the tool since the interface is farely similar to the Techedge Time report. So, those who use it will not find any problems.

There are a couple of interesting features in the report:

  • there is a days number factor (check the Settings worksheet). This factor specifies how many times each day is replicated within one month. The default is 2 which means that each day is present 2 times in the month (week-ends are always writen once).
  • the filter is maintained. If you select not to show the week-ends (saturday and sunday) then after generating the new calendar for the new month the filter will be maintained.

Feel free to download it:

ExpensesReport_Example.zip

And contact me (or comment here) for any discovered issures, suggestions etc. 🙂

All the best wishes,

Valera 🙂

Techedge timereport in Excel II

Hi guys,

here you can download a new version of Techedge Timereport in Excel tool that allows filling in our internal Techedge time report from Excel.

Here you can find the original post: http://www.plinky.it/blog/index.php/2008/07/20/techedge-timesheet-with-excel/

with the original video:

The added feature (as requested) is the automatic insert of holidays for all the week-ends. 🙂

As soon as I’ve some spare time I finish and publish the next version with the form for entering EXPENSES! 🙂

By the way, if you like to add 2 or more entries per day in the time report it’s enough to create 2 or more lines per same day in the Excel worksheet. The program will create as many entries in web report as there are lines per day. 🙂

If you want to change the values inserted in the week-ends check the sheet SETTINGS where you find the named cell WeekEndProject and WeekEndType. These values are taken as input for each week-end. 🙂

You can download the tool here:

TimeReport_Example II.zip

All the best wishes,

Valera 🙂

Techedge timesheet with Excel

Hi guys,

I finally want to publish the tool that I use to fill in my timesheet web report. Maybe it will be useful for someone else from Techedge or KPedge if there are people who dislike spending time doing repetitive click-wait-copy-paste-click activity in their browser. Things are much easier and faster if done in Excel. 🙂

Below you can see a brief video presentation of how it actually works.

It is already a tradition that you can freely download the application from our web-site http://www.yRiver.it
(TimeReport_Example.zip)
which is actually located in the category OUR PROJECTS
where you will find other projects, solutions, ideas and concepts. 🙂