Author Topic: Cupid's Challenge  (Read 30699 times)

Offline LenaLJ

  • Challenge Board Assistant
  • Challenge Board Moderator
  • Watcher
  • ******
  • Posts: 1362
Re: Cupid's Challenge
« Reply #15 on: February 16, 2017, 02:19:51 AM »
I am confused now @coolsim9999999, did the spreadsheet give you the same number or not?

Offline coolsim9999999

  • Watcher
  • ******
  • Posts: 1658
Re: Cupid's Challenge
« Reply #16 on: February 16, 2017, 03:19:45 AM »
@LenaLJ --- I can't get the spreadsheet to work.  I did all the math with a calculator, and that's the number I got.  I tried hard to use the spreadsheet.  How do you use it?  I also have all the couples' names, as well as the time information in a word document.



Registered members do not see ads on this Forum. Register here.

Online Metropolis Man

  • Administrator
  • Watcher
  • ******
  • Posts: 11529
Re: Cupid's Challenge
« Reply #17 on: February 16, 2017, 07:15:24 AM »
Is anyone else having issues with the spreadsheet? We need to get this fixed ASAP if so.

Offline sdhoey

  • Global Moderator
  • Watcher
  • ******
  • Posts: 4827
    • sdhoeys Sims & More
Re: Cupid's Challenge
« Reply #18 on: February 16, 2017, 07:29:10 AM »
So with the spread sheet, all you do is input the names on the weeks, then at the 14th couple you input the week, hours etc right?

Sent from my SAMSUNG-SM-N920A using Tapatalk


Offline vancanuckfan86

  • Llama Wrangler
  • **
  • Posts: 52
Re: Cupid's Challenge
« Reply #19 on: February 16, 2017, 07:42:00 AM »
@Metropolis Man - I just did a quick test of the spreadsheet after downloading into excel (I haven't started the challenge yet) and it seems to be working fine for me. I just have to plug in the information for the last marriage (#14) and the Score column will update the total minutes. I did have to unmerge the cells above the marriage 14 row if I wanted to keep track of the timing on all the marriages instead of just the final one.

Offline LenaLJ

  • Challenge Board Assistant
  • Challenge Board Moderator
  • Watcher
  • ******
  • Posts: 1362
Re: Cupid's Challenge
« Reply #20 on: February 16, 2017, 10:42:42 AM »
Spreadsheet guidelines:

The only time counting is the 14th. marriage. I therefor merge the cells above, this is now changed though in case you want to add the other times too.

In order to use the sheet you go in via the link. Click on files, and click on make a copy. This now makes an editable copy of the sheet for you. (The sheet linked is protected so that only I can change it and all have the same clear copy.
(You are also able to click on files, and download a copy to use in another program)

And i also found a minor calculation error in the sheet which i have now fixed.
If others will test that will be great.

Offline sdhoey

  • Global Moderator
  • Watcher
  • ******
  • Posts: 4827
    • sdhoeys Sims & More
Re: Cupid's Challenge
« Reply #21 on: February 16, 2017, 11:38:04 AM »
Spreadsheet guidelines:

The only time counting is the 14th. marriage. I therefor merge the cells above, this is now changed though in case you want to add the other times too.

In order to use the sheet you go in via the link. Click on files, and click on make a copy. This now makes an editable copy of the sheet for you. (The sheet linked is protected so that only I can change it and all have the same clear copy.
(You are also able to click on files, and download a copy to use in another program)

And i also found a minor calculation error in the sheet which i have now fixed.
If others will test that will be great.


@LenaLJ

I haven't finished but I inputed @coolsim9999999's info and this time I got 44642



Registered members do not see ads on this Forum. Register here.

Offline coolsim9999999

  • Watcher
  • ******
  • Posts: 1658
Re: Cupid's Challenge
« Reply #22 on: February 16, 2017, 12:54:06 PM »
Spreadsheet guidelines:

The only time counting is the 14th. marriage. I therefor merge the cells above, this is now changed though in case you want to add the other times too.

In order to use the sheet you go in via the link. Click on files, and click on make a copy. This now makes an editable copy of the sheet for you. (The sheet linked is protected so that only I can change it and all have the same clear copy.
(You are also able to click on files, and download a copy to use in another program)

And i also found a minor calculation error in the sheet which i have now fixed.
If others will test that will be great.


@LenaLJ

I haven't finished but I inputed @coolsim9999999's info and this time I got 44642
@sdhoey --- Thank you very much for helping me out, as well as for the instructions :).  I really appreciate it! 

I'll try to work the spreadsheet again in a little while, but I was having a really hard time figuring it out.  However, maybe I can get it to work with those instructions.

Edit: @LenaLJ  --- I just scrolled up, and I saw the instructions that you posted and Sdhoey copied into his post to me.

@Metropolis Man --- I will try the spreadsheet again in a little while.  With Lena's new instructions, maybe I can get it to work.

Thanks again for your help, everyone!
Coolsim

Offline coolsim9999999

  • Watcher
  • ******
  • Posts: 1658
Re: Cupid's Challenge
« Reply #23 on: February 16, 2017, 02:08:54 PM »
@LenaLJ and @Metropolis Man --- I got the spreadsheet to work!  It was very easy, this time.

By using the spreadsheet, the 14th couple got married on Day 4 of Week 5 at 8:02 a.m. --- for a total score of

44,642

Thanks again everyone for helping me to figure out how to use the spreadsheet :).

Coolsim

Online Metropolis Man

  • Administrator
  • Watcher
  • ******
  • Posts: 11529
Re: Cupid's Challenge
« Reply #24 on: February 16, 2017, 02:26:41 PM »
Awesome. I am glad everything is working. :) I'll update the leaderboard.

Offline coolsim9999999

  • Watcher
  • ******
  • Posts: 1658
Re: Cupid's Challenge
« Reply #25 on: February 16, 2017, 02:29:29 PM »
Thanks a lot, Metro!

Offline sdhoey

  • Global Moderator
  • Watcher
  • ******
  • Posts: 4827
    • sdhoeys Sims & More
Re: Cupid's Challenge
« Reply #26 on: February 16, 2017, 02:38:20 PM »
Thank you got it fixed @coolsim9999999

Sent from my SAMSUNG-SM-N920A using Tapatalk


Offline coolsim9999999

  • Watcher
  • ******
  • Posts: 1658
Re: Cupid's Challenge
« Reply #27 on: February 16, 2017, 02:44:24 PM »
Thank you got it fixed @coolsim9999999

Sent from my SAMSUNG-SM-N920A using Tapatalk

Thanks @sdhoey --- I did it.

Offline ratchie

  • Global Moderator
  • Watcher
  • ******
  • Posts: 5130
Re: Cupid's Challenge
« Reply #28 on: February 19, 2017, 05:27:21 PM »
I cannot put any information into the spread sheet it tells me I need to request permission. Note I am not actually ready to input any data I was just checking it out.

Rachel
Please follow the forum rules.

Online Metropolis Man

  • Administrator
  • Watcher
  • ******
  • Posts: 11529
Re: Cupid's Challenge
« Reply #29 on: February 20, 2017, 06:31:23 AM »
I cannot put any information into the spread sheet it tells me I need to request permission. Note I am not actually ready to input any data I was just checking it out.

Rachel

Were you logged into a Google account?

 

anything