[Boards: 3 / a / aco / adv / an / asp / b / biz / c / cgl / ck / cm / co / d / diy / e / fa / fit / g / gd / gif / h / hc / his / hm / hr / i / ic / int / jp / k / lgbt / lit / m / mlp / mu / n / news / o / out / p / po / pol / qa / r / r9k / s / s4s / sci / soc / sp / t / tg / toy / trash / trv / tv / u / v / vg / vp / vr / w / wg / wsg / wsr / x / y ] [Home]
4chanarchives logo
how would you go about making a masturbation spreadsheet? I made
Images are sometimes not shown due to bandwidth/network limitations. Refreshing the page usually helps.

You are currently reading a thread in /g/ - Technology

Thread replies: 22
Thread images: 4
File: connector-excel-logo.png (28 KB, 580x210) Image search: [Google]
connector-excel-logo.png
28 KB, 580x210
how would you go about making a masturbation spreadsheet?
I made one for 2015 in Excel, but since I'm shit at Excel it didn't turn out very well. So I'm trying again for 2016. I want to be able to make a chart showing how many times I masturbated each month throughout the year. Any ideas how I should set this up? I'll post a pic of my 2015 version.
>>
File: 2015.png (46 KB, 581x800) Image search: [Google]
2015.png
46 KB, 581x800
Here's 2015. It's in danish but it shouldn't make a difference. (The "i alt" at the top is the total for the entire year and then there's also one for each month. The months just continue downwards)
Here I don't have every date though, only the ones I actually masturbated, and the number is how many times. So I couldn't figure out how to make a chart from that, how should I set it up for 2016?
>>
If I remember correctly if you plot your data in a scatter graph it will scale correctly for unused dates.

If you want something more advanced like faps per month you'll either want to make a pivot table or a list of months then an appropriate expression to sum the values based on date range for each month.
>>
>>52457221
unfortunately I have to idea how to to that
>>
Try marking the data and hitting a charting view and should display it automatically.
you need a column dates and column with values, it should automatically pick it up and display it.
if its wrong you can just switch the axis
>>
File: file.png (24 KB, 524x316) Image search: [Google]
file.png
24 KB, 524x316
>>52458643
If I do that it just creates a point for every single date instead of month.
>>
make a column that =month(date)
then Data>Subtotal
For each change in month, sum, add subtotal to numbers
>>
>>52458877
lad I know I sound retarded but I just can't into Excel, would it be possible for you to make a simple template and upload it, or link one?
>>
>>52459320

I'll do it for $40
>>
>>52459503
NO!!1
>>
https://docs.google.com/spreadsheet/ccc?key=0AvdmZGYxQFHQdHl5aVpZZXMtRU5HOG1MNnVkOC1LaHc&usp=sharing#gid=0
>>
>>52459849
I'll do a better job than him for $12
>>
>>52459937
yeah I found that one, it has a bunch of unnecessary shit though, like the with or without porn shit.
>>
is no one going to ask what a masturbation spreadsheet is and why OP would want one?
>>
>>52460868
posted one right here lad >>52456896

I keep track of how many times I've fapped, 310 times total last year.
>>
File: 1428796230163.jpg (87 KB, 588x437) Image search: [Google]
1428796230163.jpg
87 KB, 588x437
>>52460897
wut

why do you need to do that?
>>
>>52461039
eh, no reason just for the bants
>>
>>5246086>>52460868
>>52460434
K well it's known else gets around to it I'll be able to in a couple of days I'm just working long hours probably through the weekend
>>
>>52460868
>>52461039
>>>/reddit/
>>
>>52461936
alright sick, but where are you gonna post it?
>>
>>52456850
>not using based MSaccess, graphical database designer for freshmans since 2007
>>
>>52462213
Email me at fapcharts.gmail.com
Thread replies: 22
Thread images: 4

banner
banner
[Boards: 3 / a / aco / adv / an / asp / b / biz / c / cgl / ck / cm / co / d / diy / e / fa / fit / g / gd / gif / h / hc / his / hm / hr / i / ic / int / jp / k / lgbt / lit / m / mlp / mu / n / news / o / out / p / po / pol / qa / r / r9k / s / s4s / sci / soc / sp / t / tg / toy / trash / trv / tv / u / v / vg / vp / vr / w / wg / wsg / wsr / x / y] [Home]

All trademarks and copyrights on this page are owned by their respective parties. Images uploaded are the responsibility of the Poster. Comments are owned by the Poster.
If a post contains personal/copyrighted/illegal content you can contact me at [email protected] with that post and thread number and it will be removed as soon as possible.
DMCA Content Takedown via dmca.com
All images are hosted on imgur.com, send takedown notices to them.
This is a 4chan archive - all of the content originated from them. If you need IP information for a Poster - you need to contact them. This website shows only archived content.