ESC

Click the "allow" button if you want to receive important news and updates from immigrationboards.com


Immigrationboards.com: Immigration, work visa and work permit discussion board

Welcome to immigrationboards.com!

Login Register Do not show

Excel for TimeLine

A section for posts relating to applications for Naturalisation or Registration as a British Citizen. Naturalisation

Moderators: Casa, JAJ, ca.funke, Amber, Zimba, vinny, Obie, EUsmileWEallsmile, batleykhan, geriatrix, John, ChetanOjha, archigabe, push

Locked
fwd079
Diamond Member
Posts: 1228
Joined: Tue Sep 03, 2013 9:35 am
Location: United Kingdom

Excel for TimeLine

Post by fwd079 » Fri Dec 12, 2014 5:10 pm

Hello,

I see members requesting timeline updates in timeline threads.

Anyone with knowhow of Excel can go to this link and download the Excel I made, then edit with relevant data. It has formulas for top-level calculations and also for Total Days and Total working days fields on each row. You need to put data as in example though and dates as dd/mm/yyyy. Also put "Yes" in Approved? column for auto count and calculation of averages. Then on Excel menu click copy to "Copy as image" and then upload attachment there in the relevant thread. Mine is October 2014.

The Excel is in .xlsx format, but if you use Google Docs then you can change/edit there too as far as I know, haven't tried that part.

Threads might have "attachment threshold" so its probably better to go to User Control Panel and delete the previous attachments and then upload new one. Or you can post a link from imgur or some other image sharing site if you fancy, I prefer the former method.

Hope this helps others.

Regards.
Being British is a state of mind.
Want to maintain timeline of any thread? Click here and grab template.

Maxwell
Member
Posts: 181
Joined: Mon Aug 19, 2013 5:14 pm

Re: Excel for TimeLine

Post by Maxwell » Fri Dec 12, 2014 6:55 pm

Great idea! :D

fwd079
Diamond Member
Posts: 1228
Joined: Tue Sep 03, 2013 9:35 am
Location: United Kingdom

Re: Excel for TimeLine

Post by fwd079 » Sat Dec 13, 2014 2:08 am

Maxwell wrote:Great idea! :D
Thanks but more like a practical solution I implemented and was feeling that must share here for members maintaining any other timeline threads etc. :)

Thanks for liking though mate.
Being British is a state of mind.
Want to maintain timeline of any thread? Click here and grab template.

Locked
cron