Hi everyone,
Checking in. I've been verybusythe past couple days. I am playing catch up here so I'm reading and re-reading the past couple of days posts. I'm going to take you up on the "step by step" instructions. I'll be back.
D40

Love the idea.

I have only one problem: whenever I go to the link in post 49, I get the same spreadsheet, without updates or changes.

:smug: :O:

Excellent plan! :up:

Yes sir :salute:
I am currently updating the patrols I had previous logged. So far I have almost finished with U-28's war patrols. Once I get them all ready I will proceed with your assignment.

I think that for the first patrols logged, it would be useful if everyone posted a screenshot of the map with the followed route with significant coordinates marked and/or a screenie of the settings set in the generator. This way, spotting possible mistakes would be easier, and we would learn from each other :yep:

P.S: a good website containing concise descriptions of each war patrol is u-historia.com. Unfortunately it is Spanish written. Nonetheless, taking the time to drag its texts in google translate or in babelfish might be worth the time, as its information can be a valid support. :up:

At the beginning I had started logging the estimated number of torpedoes used during each attack, but then I realized that this method was highly time-consuming, and that it might have been quite aleatory. At the end I opted for recording the number of attacks, leaving TDW to decide randomly the number of torpedoes used every time (with a remote probability that no torpedoes were used). I agree that by following this last method, we risk to overestimate the number of torpedo attacks over gunfire attacks (the latter being very common during the first months of the conflict), nonetheless I see a couple of advantages in it:

- more randomization and lesser probability of getting support during the early stages of the war, when group strategies were quite uncommon anyway;

- the possible torpedo usage overestimation is counterbalanced by a physiological degree of underestimation coming from the common evenience of torpedo failures, which we are not taking in account, and from failed torpedo attacks not listed in our sources.

Moreover, let's not forget that at the time being, the only use we can do of the "left torpedoes" information is for determining whether a given boat will be dispatched or not. I doubt that TDW can limit the number of torpedoes left on each supporting boat, based on our information.

Targor, you cannot work on that spreadsheet online. You need to download it. The one document that you can update online is the spreadsheet uploaded by keysersoze, used for storing the results obtained from the previous one :yep:

Having trouble downloading the spreadsheet from post #49. When I hit the download icon it takes me to a "Page cannot be found" screen. It prompts me to download it though, as it says it is too big to view. I'll keep trying.
Am I screwing up here?:06:

That link works for me. Anyway I have reuploaded the spreadsheet here :up:

I was confused about this yesterday as well. I thought we were recording data in the online spreadsheet that would then be transferred into gap's more professional generator. It's pretty much the opposite of that. Basically, we do the following:

1. Download gap's U-boat coordinates generator.
2. Copy and paste information into the generator

a. Enter general information in the lower lefthand corner, including commander's name and rank, date patrol started, duration of patrol in days, and whether the U-boat carried any mines. Gap's program will automatically use this information to create a template for you to work with

b. Copy and paste U-boat's lat/long for each day of the patrol in the corresponding cell of the generator

c. Select one of the drop-down options from the "current activity" tab. Most are self explanatory, but you can refer to gap's description of them earlier in the tread

d. After you have entered positions and current activity for every day, simply highlight the yellow (output) cells

3. Paste the output from gap's generator into the google docs spreadsheet

a. Find the appropriate month/year tab in the lower lefthand corner of the spreadsheet

b. Find the correct type for your U-boat (VIIA, B, etc.)

c. If your U-boat is not yet listed for that month, add three rows, each labeled with your U-boat's number (these correspond to the output data you have already copied)

d. Highlight the first day of your U-boat's patrol

e. Paste the output data into that cell by pressing ctrl + v

It sounds more difficult/tedious than it actually is. Once you begin playing around with the generator and the spreadsheet, it all becomes fairly self-evident. There are additional functions to interpolate missing data in case uboat.net is missing the coordinates for that date. One final consideration: if your U-boat's patrol spans multiple months, you will need to copy and paste information separately for each month, since the master spreadsheet is divided by month.

It keeps loading, and then offering the "retry" option. :hmmm:

EDIT: Oh, wait, I had to download it. Got it!

Thanks again for your willingness to help Dogfish and Sartoris :salute:

Are either of you having trouble with the either the spreadsheet or the generator?

Excellent idea :up:

Posting screenshots would work well. I have also reorganized our google drive account so that everything relating to our project is contained within the "U-boat Coordinates Project" folder. There is another copy of your coordinates generator there so people can find it without hunting through other links.

I also created a folder called "Completed Patrols," where I have uploaded the three patrols I've done so far. The file labeled "U-33,1," for example, means "U-33, 1st patrol." I don't know whether this is a tenable method in the long term, but if we upload our completed patrols there, we can all access each other's work and make necessary corrections (including adding in crew experience levels) without having to re-do everything. What do you think?

Yep, u-historia.com is a great website and even my very rusty Spanish is sufficient to use it. Anybody with a bit of Spanish might want to check it out. I've also been using Wynn's two-volume, titled U-boat operations of the Second World War, which contains written descriptions for every patrol. Since I'm tired to going to the library every time I want to reference it, I recently purchased copies. There's no reason for anyone to do the same, but let me know if you run into inconsistent information and I will see if Wynn has anything to say about it.


Your arguments are persuasive like always :yeah:

:up:

Good idea! How can we upload our files into that folder?

I have been testing google translate on an random u-historia page, and I must say that the resulting output in English language was more than acceptable:

:yeah:

Sorry guys :oops:
I can't do anything right now.. maybe a little bit later.. some RL troubles :nope:..

Sorry Volodya, I hope you will to sort out your troubles soon :)

No problem volodya... real life has to come first. I hope you get everything sorted out :sunny:

@gap I've made some changes the setting of the "Completed Patrols" folder. Can you upload anything now?

I'm not certain about this yet, but I think that you will need to have gmail account to be able to upload into the "Completed Patrols" folder. Do most people have a one? I would like to avoid requiring volunteers to create a new account; we want to have the fewest obstacles possible so we can attract the maximum number of collaborators :hmmm: