 Hello everyone. So the video you're about to watch is my translation process. You'll see me translating It's basically a screen capture of me translating and you'll see what my thought process is while my procedure is for translation because a couple of you have been asking for this and I thought it will be interesting to show you and It's this is a particular type of translation. It's basically these financials that are rather complicated. So you see me using Excel Now I could still do a video with just a more of a normal translation I just happen to have this this actually was part originally part of the last video my day in the life from Charlotte But then I felt like I was trying to do too much with one video So I decided to separate it and I thought it'll be interesting in it in it of itself since Several of you have been asking to watch to see my translation process So I thought I'd make it a video just by itself, but I wanted to introduce it a bit just to give it some context So it doesn't just jump right into it and you're wondering what's going on So once again, it's me going through a translation It's a Swiss tax form and there wasn't I couldn't find any template for it or anything online So I had to create my own I was using Excel to do this and I explained a bit more of why I did this During the video and but anyway, so hopefully it can be somewhat interesting to you It can be somewhat informative and so yeah, enjoy. Okay. Bye So here I wanted to show you a little bit of what I was doing while I was in the coffee shop but I think it merits some explanation just because It otherwise you can't really tell what I'm working on here as you can see on the right I have it's a Swiss tax form and I had all these different tax forms and the layout as you can see is really a mess At least for me, it's a mess. I'm not good at layout. I'm not very good at all that stuff in terms of Formatting and whatnot on word and so I cannot do this on word and I've been asked about this before and yeah There are various programs that help you out with this but quite frankly if you have Excel or any other spreadsheet program You can just do it on there and that's exactly what I'm doing here I'm basically working on a translation on Excel I do it cell by cell and in fact, maybe later. I'll show you something Where I've completed a bit more of it at the end what I just do once I'm done with the translation It's like copy what I have an Excel and I just paste it onto a word document because that's the only way I can make sure that the layout doesn't get all wonky. It's a lot It's a lot more tedious and also it's a bit more difficult to check the translation Although you can just copy and paste the text to see if there are any mistakes that get underlined just for simple stuff like that But anyway, you know, this is a good way as any end quite frankly rather than wasting your time trying to find a program That does it might as well just get the work done and do this and And so yeah every now and then I will end up doing stuff like this and as you get the hang of it It gets a bit quicker I'd say but Yeah So enjoy Okay, this is actually a bit inconvenient to do. I don't want to show too much of this This file because I don't want you know someone's tax declarations I don't want to show the personal information, but I In fact, let's make sure I don't have any Here I'll put stuff. No, but they're no names or anything this so that that should be fine And but yeah, this is basically how I work on it here. I have the text here I have the original so it kind of gives me an idea although I'll work on the formatting later But yeah, this is pretty much what I do. So the tax Of course, it's better if I spell right Capital allocations See and this is why I every time I Translate by the way, I try to sleep on it and then go over it again with fresh eyes because you know Thinking in an Italian way and I have to do it while I'm thinking in an English speaking way Let's say this one I caught it, but there are other things I won't catch. I know that and Say as well as any other attachments Actually, this is a pretty good example of why I like having the text so here I have this we've certainly facilitated on accomplishing it a complication in the model here and Which I kind of literally translate as the the instructions facilitate filling out the forms Which obviously isn't very good English, but so what I can do here is I can find where are we here? You know, I can try the different Websites I have you know, and first of all, I want to see if it has the whole term somewhere What I can do is search I Can do that say pros or something like that Except I copied out the English part and that was a very smart. So here There we go So let's see Form no this because it says Swiss form so it's not that common obviously if it's Italian to English most of these forms are gonna be Italian or English or American or whatever the very few Swiss ones. So unfortunately, it's hard to find And here too, it's hard to find the whole thing now la compilazione here the second part a compilazione dei moduli actually, I'm not That one's not too hard, but I want to look for you know this expression here and see if I can find anything that helps out with it And here it got switched all the way around Yeah, complete the forms filling out the forms. Yeah, that wasn't the issue. I wanted to do this now. Obviously, this is This isn't difficult You know, this is the instructions help out with you know, something but I want to see if this if there is a standard Translation for this, right so here I see the Sturzoni Facilitano and I don't see that exact phrase but for Facilitano shall facilitate facilitating make it easier assisting shall accommodate Assist could probably work. Now. Let's see if I can find anything precise here Facilitano Facilitano here. I find assists again They're making the reading easier making it easier assisting I mean, you know, we know what it means I'm just trying to find something that might be official But there is no at least I can't find any other official translation of this. So I Can just write the instructions assist with Filling out the forms I might change it to these instructions very often in Italian when you put the in English It gets translated as these or like this document in it a little bit You document the document in English will be this document. Anyway Assist with filling out the forms this one should not be capitalized and there we go So and that's how I use those websites Once again when I go through this with more of an English ah, hey Let's say, you know, I might want to change it again But and usually that's when I do these changes and here I kind of just go through it more quickly But I just wanted to show you more or less what I use these other websites for Anyway, let's keep going Let's see where I am again without showing too much. Go ahead. I thought I'll possibly that he shared that and then Cross it. Okay Here I'd say when there is Choice And we'll see if it works with what follows We wanted to come back just to show you this is taking me a lot longer than it usually takes by the way Just because I'm trying to show you everything and hiding, you know, more than half the document here But I just want to show you some of the mistakes that can sometimes come out of OCR of optical character recognition, which you should keep in mind because too often I get these from translators Who obviously haven't looked because here said la subject I mean to inferior a lot much of it of the civilian arm like what like This doesn't make any sense. And so that's why you have to look at the original and no TV They obviously for some reason instead of I know it said I'm on this makes more year This means the civil year the fiscal actually not the fiscal year just a year Then indicate the duration. So the assessment is less than The calendar year indicate the duration From two So I'm working off of a PDF for this translation. So what I'm going to do is do an OCR scan of it This is an optical character recognition scan. I've mentioned this before in some videos But basically it's a scan of the PDF and it tries to parse out and tries to recognize all the characters I'm only doing pages one through four though because that's all I care about at least for now and I chose the language time So this is the program I've used I mentioned this before as well. I'm not affiliated with it in any way You know, they don't pay me but I yeah, I mean you do pay for it And it's the one that I use and that's why I recommend it even though, you know, I have no affiliation with them I feel like I have to say that for each video Or at least anytime I recommend something, you know, especially something you have to pay for all that I just need to specify. They're not paying me to say that. It's kind of annoying that I have to keep saying that but there you go anyway, so now it's hopefully processing this video and or this document and so yeah, basically it'll take this document and this tax document that you see behind me there and Try to parse out the text and that can help a lot if when I'm searching for terms and I'm trying to figure out what the text says as you can see it actually the Okay, it comes out kind of a mess Especially when you have to do with tax forms and stuff like that and it's really kind of hard to read So what I usually like to do because I just do it for the text Which later I can do whatever I like with an input So I try to go somewhere here where I could choose all the text copy it And then I open a brand new document and I just paste it as unformatted text and the reason I do this is because I It just makes it easier for me I know I'm not missing anything when you have messed up stuff like like you had it in the other file Then you never know if maybe you're missing some text below some text box or you know like what's this There's something behind here, and it might just be three dashes or it might be part of text that's somewhere And you know, you don't want to mess around with that So I just do this and then I can compare it to the original PDF Which which should be here or no open it later. Anyway, like I said, I don't want to you know share any personal information of this person, but I Just work off this and obviously it's kind of a pain But I can just work off the text from here and then later I can work on the formatting After I go through it after I go through the text I go through it again just to work on the formatting itself