Thanks to the moderators for giving me permission to share this document here. I think it will be a huge help to anyone, whether new, or experienced in BDSM.
It’s an interest worksheet which, from what I heard, was prepared years go by a researcher at Yale as part of a study.
It’s amazing how much it prompts discussion with a new or existing partner, or even just in your own mind. Things you never even knew were kinks are suddenly open to dialog.
There were things I’d never heard of and had to look up, but the physical act of looking them up taught me so much.
Whenever I brought in new subs they filled one out, and they each had a binder with their written consent forms and this document. Every couple weeks they had to go through and update it, because interests change. They also had to update their written consent forms, because consent is the foundation of everything.
Anyway, I hope you find this document useful and that it prompts discussion between you and your partners.
Thanks again to the moderators for permission to share this. BDSM Interest worksheet
A few weeks ago I made a full-blown guide to a January full moon ritual and shared it here. I had tons of fun with that and am already working on one for February! They're a lot of work though, especially when you already work a salaried job, so even though I knew I wanted to do something for the new moon too I just don't have the time to make the same, detailed walk-through twice a month.
I did make a little worksheet though, just to help guide journaling and center our focus around visualizing our intentions.
If anyone uses it, I'd love to hear experiences, opinions, or feedback! Happy New Moon everyone, may it bring you all you wish.
I made another without the background, so it's a bit more printer friendly. Thanks u/prettylittlejaded for bringing that up to me!!!
A few years ago when I was in college, I was in an astronomy class. The class was decent, and the professor was super laid-back.
The class met once a week for 3.5 hours. After the lecture, which lasted about 2 hours, the professor would hand out a worksheet. He told us to get in groups and work on the worksheets. The worksheets were 15 or so questions long and got progressively more difficult. Once the worksheets were completed, we could leave. The worksheets would typically take more than an hour, so things seemed to work out.
The first 2 or 3 weeks, I would end up working with one or two other people on the worksheet. Finally, in week 4, we came to the worksheet part of the class. I raised my hand and asked if there was a limit to the number of people who can be in a group. Professor said there was not.
I stood up with my sheet, walked down the steps to the front of the class, and announced that we were going to all work in one big group. People could individually complete the problems, then put them on the board, and start helping other people with the more difficult questions.
We were done with the sheet and out of class at least an hour early every night for the rest of the semester.
Aftermath: While the professor privately told me he loved seeing the dynamics that come out each semester, he put a group size limit in place for subsequent classes.
//EDIT: The goal was unintentionally described in an ambiguous way. I just added an example below. Sorry @ all//
my problem may be not that hard to solve for you. I just cannot figure out myself where the error lies, so I politely ask for some correction advice here. It would be great if you could share your expertise with me.
To check for each used cell in column E (in Sheet1) if its value equals the name of a worksheet in the workbook. If yes, then the value in A1 (in Sheet1) should be "yes", else "no". To give you an example: after using E1 for the check, the value of A1 is set to be "yes", then the check of E2 results in A1="no", then comes E3, which leads to A1="no" again, and so on until the very last cell of the range in column E is reached.
'Sub Macro1()' 'Dim Lastrow As Long' 'Lastrow = Worksheets("Sheet1").Range("E" & Rows.Count).End(xlUp).Row' 'Totalsheets = ThisWorkbook.Worksheets.Count' 'For Each c In Worksheets("Sheet1").Range("E1", "E" & Lastrow)' 'For i = 1 To Totalsheets' 'If ThisWorkbook.Worksheets(i).Name = ThisWorkbook.Worksheets("Sheet1").Range(c).Value Then' 'Worksheets("Sheet1").Cells(1, 1).Value = "yes"' 'Exit Sub' 'Else' 'Worksheets("Sheet1").Cells(1, 1).Value = "no"' 'End If' 'Next i' 'Next c' 'End Sub'
Error 1004 (Application-defined or operation-defined error). Not sure though if that is the last error.
PLEASE READ THE FULL POST BEFORE COMMENTING!
made this post if anyone needs help with worksheets or you have a test. comment and ill get you the link, however all the test answers and everything may not be 100%, but they will be around 90%. also, I WON'T HAVE ALL THE ANSWERS BOOKS AND SOLUTIONS BOOKS!
edit: made a typo in the title so sorry about that lmao
edit 2: ill made a discord server where i posted all the answers that i have, so feel free to join the server if you'd like
permanent invite: https://discord.gg/yRG9Pw6Ccu
note that the server is still a work in progress so it will probably be done by tomorrow or so
CTRL + ' (the tilde key)
and then click again to return to normal view.
I often use this to problem solve, particularly when looking at other's spreadsheets.
I am not sure what I am doing wrong. I need to have the sums of set cells flow onto a YTD worksheet and am using the formula =SUM('1:12'!C6) but it isn't doing anything. All of the sheets are from the same template. What am I missing? I am certain it is something very simple.
Edit, to show correct formula being used
I was wondering is it possible to triplicate my data in a way that this:
Will become this:
I need to do this on several hundred rows (with some extra columns), and would really prefer to avoid doing it manually (inserting rows twice, and copy-pasting the row).
Any way to do that easily?
Just curious if this can be done with VBA or something else entirely....
I want a To Do List on worksheet 1 that gets its tasks from multiple other worksheets. For Example:
Task Due Date
Contact Joe Smith 2/22/21
Contact Bill Jones 2/24/21
Contact Jill Ford 3/1/21
Worksheet 2, 3, 4 etc will have the following:
Name of Contact | Joe Smith
Contact 1 | Date 1
Contact 2 | Date 1 + 7 days
Contact 3 | Date 2 + 7 days
Is there a way for Worksheet 1 to show a to do list without having to manually copy and paste fields every time I start a new worksheet with the same field?
I've got a worksheet made up for using contacts in a game. It takes the rules from SR5 and RF and condenses them and makes them a bit more clear. There are a few tweaks and "house rule" adjustments that I put in, but overall I like how it turned out. My runners and I find it helpful to have cheat sheets like this. Check it out and tell me what ya think. Feel free to use it too. It's in PDF format so the link to the Google Docs is included.
Like many of you I regularly search the internet for lessons and activities to improve my teaching, and finding meaningful connections can be difficult for some topics like in AP Calculus.
So I find a really good activity online for the concept of Related Rates: students start with a lollipop and measure the circumference as they suck on it, and they can then calculate the rate of change of both the circumference and volume (this is great because there's no easy way to directly calculate the volume at home). We're all familiar with "Mr. Owl, how many licks does it take to get to the center of a Tootsie Pop?" and here we are addressing this question from childhood.
Anyways, it was a great activity overall until I got to the very last part of the worksheet:
"Now compare your rate of change of the volume with your peers to see who has the greatest sucking power."
Thank God that didn't slip through.
Ok, I made up a Excel where it should be kind of explained the amount of mats and mora cost, that you should need for Hu Tao, I don't know if somebody else has done this, but i wanted to do it for myself and i thought of sharing it. Of course this is based on the Honey page info so take it with a grain of salt. And if there are errors pls, don't blame me i made this at 2a.m. and you can download it and made changes yourself. :)
> Microsoft Excel has changed how people organize, analyze, and visualize their data, providing a basis for decision-making for the millions of people who use it each day. It’s also the world’s most widely used programming language. Excel formulas are written by an order of magnitude more users than all the C, C++, C#, Java, and Python programmers in the world combined.
> With LAMBDA, Excel has become Turing-complete.
No, I don't want to use the cool animated videos you made for your students that don't really apply to me.
No, I don't want to use yetanotherapp.com and have everyone sign up for another account because you couldn't figure out how to do it another way.
No, I don't want to use your fluffy pandering "engagement" stuff that just trains the kids that we're an entertainment bureau and they shouldn't have to learn if it's not fun.
No, I don't want to observe Molly McSuperTeacher and learn how to throw Tootsie Rolls to everyone who raises their hand.
No, I don't need to add graphics of meaningless certifications that I wouldn't even bother putting on my resume to my email signature field.
No, I'm not going to do whatever thing you say is "evidence based" when you heard it at a conference and it's backed up by a non-peer reviewed journal and was done at a school for gifted kids.
No, I don't want to go to some stupid conference and listen to these people pitch our district hundreds of thousands of dollars of shit just so we can say we have a product for [insert problem] when spending that money on retaining and training teachers would do more good for everyone.
I just want to teach my students. I know what I'm doing. I'm a professional. I can collaborate and borrow without having to follow every goddamn fad that comes along.
Hello, I have almost 70 files that I have to merge together, and they have slightly different structures.
In some, the headers start on the second row. In others, there are extra columns.
I'm trying to merge these files with power query, but first I'd like to write something that would delete all rows before a specific header, as well as delete all columns except the specifically named ones that I need.
I have the following, which lets me delete specific columns, in all of my worksheets. This helped with about 40 of the files, but I'd really like a solution that would take just give me clean files structured in one precise way so I can use it for future, similar projects. I'm a novice at VBA, I copied the below from somewhere else and changed it to suit my needs.
Thank you in advance for any help!
Option Explicit Sub test() Dim wkb As Workbook Dim MyPath As String Dim MyFile As String Application.ScreenUpdating = False Set wkb = ActiveWorkbook MyPath = "C:\Users\FirstName LastName\Downloads\Campbell" If Right(MyPath, 1) <> "\" Then MyPath = MyPath & "\" 'Change the file extension accordingly MyFile = Dir(MyPath & "*.xlsx") Do While Len(MyFile) > 0 If MyFile <> wkb.Name Then Workbooks.Open Filename:=MyPath & MyFile Columns("C:D").Delete ActiveWorkbook.Close SaveChanges:=True End If MyFile = Dir Loop Application.ScreenUpdating = True MsgBox "Completed...", vbInformation End Sub
Greetings Excel peeps,
I am trying to find a way to use Excel for inventory tracking for an independent craft brewery. We're currently using Lotus Approach (kudos to you if you are familiar with said program) and it's been pretty darn reliable but hasn't been supported for years. We're on a tight budget, so looking for a way to do this low or no cost if possible
I've set up a multi-sheet workbook to keep track of unused raw materials, beer in inventory, and a separate summary report sheet that calculates total inventories, losses, and taxes due. The main worksheet I've called "Beer Inventory," and it contains 40 rows and 18 columns, each row containing data pertaining to a specific batch of beer (i.e. knockout volume, taxed/transferred beer volume, cost per batch, to name a few).
Columns B (Beer) and I (Tap Status) are formatted to have drop-down menus. Currently column B has about 30 different beer recipe options and also an *EMPTY* option. After a beer is either brewed or transferred, I select a beer from this dropdown menu and it populates columns C, D and E with cost numbers using the VLOOKUP command. The volume, unique batch numbers, and dates are all entered manually. Changing tap status from the dropdown menu does nothing at this point, but here's where I'm hoping to get some help from you guys:
I'd like to be able to reset the old batch data in a row in preparation to enter new batch data once the previous tank empties. Is there a way (formula, macro?) to automatically copy values from the previous batch to a separate worksheet once the Tap Status value is set to "FINISHED", and reset column B to *EMPTY*? Or is there another slick way to archive this row of data to a separate sheet?
Pretty new to this stuff (intermediate?) so any help would be greatly appreciated!
I'm running Excel 2013 on Windows 10 Home Version OS, desktop
So I am using this code base to save a Worksheet as a PDF. but after it's saved, I need to automatically open that PDF that was just created. I've Googled and haven't found anything that has worked. Any insights or reading material to help would be appreciated!
I could use some help with which classes/methods I should be looking for. I'm working with teacher and student data.
For context, we have a form that collects data for each student into a single sheet. This is my "Source Sheet". I also have a script which creates a "Teacher" worksheet for each teacher and any row on the Source Sheet which pertain to a student on their roster. This script works just fine for creating the spreadsheet. No issues there. My question is about updating a column in those created sheets.
On the Source sheet there is a "Student ID#" column and a "Status" column. I want the Status column in my Teacher worksheet to update based on the responses in my Source sheet. It's basically a VLOOKUP based on Student ID#. (eg. "Hey, Teacher Sheet - I need you to take all your Student ID numbers, and tell me what the status is for that Student ID number on the Source sheet.")
My question is, can anybody help me with where to start with using Apps Script to replicate the functionality of a VLOOKUP(IMPORTRANGE) formula? I would prefer to just update the column on a trigger rather than clearing and refilling the whole sheet, if possible. Thank you all in advance!
Brushstrokes: Exercises in Performing Setting
>'Stage with a jungle backdrop. Frogs croak and birds call from recorder. Farnsworth as an adolescent is lying facedown on sand. Ali is fucking him and he squirms with a slow wallowing movement showing his teeth in a depraved smile. The lights dim for a few seconds. When the light comes up Farnsworth is wearing an alligator suit that leaves his ass bare and Ali is still fucking him. As Ali and Farnsworth slide offstage Farnsworth lifts one webbed finger to the audience while a Marine band plays "Semper Fi." Offstage splash.'
>'All the different people in Alexandria, that city of gold.
>'Two-storey pale blue, brown and pale grey brick and wood houses, side by side, down the streets. Red-brown colour, air and surface, and, above that, gold light, the sun, and above that pale blue. The air is grey and semi-thick.
>'Birds call in the air. They're being scared by the increasing numbers of sudden loud noises. There are some modern apartments and the beach surrounds everything.'
Brushstrokes - Definition:
[Refer to Fig.1 in attached Google Doc]
Take a moment and contemplate this photograph. You've tasked yourself with representing it as a setting. Relax. Be in the setting. You can already see it, now hear it. Smell it. What textures and tastes are there in the air that make you reluctant to breathe deeply in? You know all these features immediately. Now give them names.
A brushstroke is a 'name' (effectively an elaborate noun) for a sensory stimulus presented as the only content of a sentence, and accordingly lacking the minimum grammatical components to constitute a self-contained sentence: a subject, an object, a verb. Like chromatic approach tones used in jazz, brushstrokes are invalid according to conventional theory, but if used consciously and consistently can produce replicable, deliberate effects, and can constitute useful tools in an alternative theory system.
A brushstroke may be concise: "Rain." Or it may be long and meandering: *"Lichen strata of splashed and coagulated paint - topography gradients from carbon to ash and dried burgund... keep reading on reddit ➡
I found myself taking screenshots of every job email and writing on them with the snip and sketch tool. That got pretty old fast. I started looking for something to make use of but I couldn't find anything quite like what I was looking for. So, I made my own.
It's not complete yet and it's a hot mess of me barely understanding what I was trying to do, but it works okay and it's pretty handy. Here's a link to a shared copy of it (it's a Google Sheet). I think I have sharing set up so you can view only but make yourself a copy. If I need to change anything, please let me know.
All of the dropdowns are fed by Data Validation from the Data Sheet. It filters out all of the parts above your current level. You can start typing something you know is part of the name like "980" for a Graphics Card or "HyperX" for Memory.
On the Left you can add all of the job specific info with dropdowns for tasks you'll encounter, extra requests the customers make (virus removal, new cables, etc.) and leave notes for yourself on diagnostic jobs. Conditional formatting on the Job Cost and Power Required cells will give you a heads up if you're over-budget or need a larger Power Supply.
On the right you can list out all of the parts and the amount of them you want to use for a job. The amounts are all preset to 1 but can be changed to the value you need. You can also make them zero to look at the stats alongside other parts (great for upgrades and diagnostics). All of this feeds into the BuyList sheet to give you a list of all of the parts you need to buy.
The red RESET button clears all of the manual entry cells on DailyJobs, replaces all of the 1's in Column G, and removes the filter on the BuyList sheet.
When you're done planning out the jobs, head over here and click the Filter button. This clears all of the blanks and values set to $0 (from troubleshooting or listing parts you have in stock). This sheet is all automated and you don't need to do anything other than click the Filter button.
I added the Unfilter function to the RESET button on the DailyJobs worksheet so you don't need it, but it's helpful if you want to change parts and have them populate this list without clearing the Dail... keep reading on reddit ➡
I am attempting to source a replacement for our current setup process. There's nothing wrong with the process per se however, we want to move to something a bit sleeker and more modern to improve the client onboarding process.
Currently we use an excel spreadsheet to collect data inputs such as;
I have looked at many online web form generators and liked some but I've not found something that ticks all the boxes. I'm wondering if anyone with a similar use case to ours has any suggestions. To check all the boxes the solution would need to allow for;
A web form designer may not be the best solution. Perhaps another worksheet (Google or other) or another type of application altogether.
The nice thing about using excel is that everyone knows how to use it. It's easy to save and email back and forth. It's a workhorse but it's not very stylish. Is there a more modern solution available or is it best to stick with the devil you know?
What works for you? Do you use your own software to collect client information for onboarding? Do clients self-service? Do you use a third party tool?
Any feedback from the community is appreciated. Thanks all!