Nurse looking for help!

JimmehMac

New Member
Joined
Aug 13, 2021
Messages
1
Office Version
  1. 365
Platform
  1. Windows
So just a quick tidbit, during surgery we do something called a "Time Out" where we all pause to verify we have the right patient, procedure, and anatomic location. We have a surgeon that is a "little" superstitious and also like us to list the patients zodiac sign, Chinese Zodiac year (pig, bear, cat, etc), and native american zodiac sign (salmon, bear, falcon, etc)

What I was hoping to do is create a excel file where all we had to due was enter the patient's birthday into the blank, and the 3 different signs would populate. And if I could manage it, put it up on a cheap free website so we all could use it no matter what computer desktop or laptop we were using at the time.

I have a little bit of experience with excel and websites, but that was also 20 years ago with geocities. :D

Thanks for any help,

Your friendly neighborhood batsh!t crazy RN
 

Excel Facts

Excel Joke
Why can't spreadsheets drive cars? They crash too often!
One thing to note is that the Chinese Zodiac is a little different from the Gregorian year, so some adjustments would be needed.
See attached link.
 
Upvote 0
Explanation of post #2 which violated forum rules on posting links to workbooks (good rule BTW, I just didn't think it through when I posted).

Input Form
JimmehMac 20210813.xlsx
BC
1Enter Date of Birth08/23/1966
2Chinese AnimalSheep
3Indian Astrological SignMithun
4Astrological SignGemini
Input Form
Cell Formulas
RangeFormula
C2C2=IF(InputDate<>"",VLOOKUP(YEAR(InputDate),ChineseAnimalList,2,0),"")
C3C3=IF(InputDate<>"",VLOOKUP(DATE(2021,MONTH(InputDate),DAY(InputDate)),AstrologicalSignList,2,1),"")
C4C4=IF(InputDate<>"",VLOOKUP(DATE(2021,MONTH(InputDate),DAY(InputDate)),AstrologicalSignList,3,1),"")
Named Ranges
NameRefers ToCells
AstrologicalSignList=Lists!$D$3:$F$14C3:C4
ChineseAnimalList=Lists!$A$3:$B$398C2
InputDate='Input Form'!$C$1C2:C4


Lists to lookup the values
JimmehMac 20210813.xlsx
ABCDEF
1Chinese AnimalZodiac
2YearAnimalStart DateIndianWestern
31900Rat12/22MakarCapricorn
41901Ox01/20KumbhAquarius
51902Tiger03/21MeshAries
61903Rabbit04/20VrishabhTaurus
71904Dragon05/21MithunGemini
81905Snake06/21KarkaCancer
91906Horse07/23SimhaLeo
101907Sheep08/23KanyaVirgo
111908Monkey09/23TulaLibra
121909Rooster10/23VrishchikaScorpio
131910Dog11/22DhanushSagittarius
141911Pig12/22MakarCapricorn
151912Rat
161913Ox
171914Tiger
181915Rabbit
191916Dragon
201917Snake
211918Horse
221919Sheep
231920Monkey
241921Rooster
251922Dog
261923Pig
271924Rat
281925Ox
291926Tiger
301927Rabbit
311928Dragon
321929Snake
331930Horse
341931Sheep
351932Monkey
361933Rooster
371934Dog
381935Pig
391936Rat
401937Ox
411938Tiger
421939Rabbit
431940Dragon
441941Snake
451942Horse
461943Sheep
471944Monkey
481945Rooster
491946Dog
501947Pig
511948Rat
521949Ox
531950Tiger
541951Rabbit
551952Dragon
561953Snake
571954Horse
581955Sheep
591956Monkey
601957Rooster
611958Dog
621959Pig
631960Rat
641961Ox
651962Tiger
661963Rabbit
671964Dragon
681965Snake
691966Horse
701967Sheep
711968Monkey
721969Rooster
731970Dog
741971Pig
751972Rat
761973Ox
771974Tiger
781975Rabbit
791976Dragon
801977Snake
811978Horse
821979Sheep
831980Monkey
841981Rooster
851982Dog
861983Pig
871984Rat
881985Ox
891986Tiger
901987Rabbit
911988Dragon
921989Snake
931990Horse
941991Sheep
951992Monkey
961993Rooster
971994Dog
981995Pig
991996Rat
1001997Ox
1011998Tiger
1021999Rabbit
1032000Dragon
1042001Snake
1052002Horse
1062003Sheep
1072004Monkey
1082005Rooster
1092006Dog
1102007Pig
1112008Rat
1122009Ox
1132010Tiger
1142011Rabbit
1152012Dragon
1162013Snake
1172014Horse
1182015Sheep
1192016Monkey
1202017Rooster
1212018Dog
1222019Pig
1232020Rat
1242021Ox
1252022Tiger
1262023Rabbit
1272024Dragon
1282025Snake
1292026Horse
1302027Sheep
1312028Monkey
1322029Rooster
1332030Dog
1342031Pig
1352032Rat
1362033Ox
1372034Tiger
1382035Rabbit
1392036Dragon
1402037Snake
1412038Horse
1422039Sheep
1432040Monkey
1442041Rooster
1452042Dog
1462043Pig
1472044Rat
1482045Ox
1492046Tiger
1502047Rabbit
1512048Dragon
1522049Snake
1532050Horse
1542051Sheep
1552052Monkey
1562053Rooster
1572054Dog
1582055Pig
1592056Rat
1602057Ox
1612058Tiger
1622059Rabbit
1632060Dragon
1642061Snake
1652062Horse
1662063Sheep
1672064Monkey
1682065Rooster
1692066Dog
1702067Pig
1712068Rat
1722069Ox
1732070Tiger
1742071Rabbit
1752072Dragon
1762073Snake
1772074Horse
1782075Sheep
1792076Monkey
1802077Rooster
1812078Dog
1822079Pig
1832080Rat
1842081Ox
1852082Tiger
1862083Rabbit
1872084Dragon
1882085Snake
1892086Horse
1902087Sheep
1912088Monkey
1922089Rooster
1932090Dog
1942091Pig
1952092Rat
1962093Ox
1972094Tiger
1982095Rabbit
1992096Dragon
2002097Snake
2012098Horse
2022099Sheep
2032100Monkey
2042101Rooster
2052102Dog
2062103Pig
2072104Rat
2082105Ox
2092106Tiger
2102107Rabbit
2112108Dragon
2122109Snake
2132110Horse
2142111Sheep
2152112Monkey
2162113Rooster
2172114Dog
2182115Pig
2192116Rat
2202117Ox
2212118Tiger
2222119Rabbit
2232120Dragon
2242121Snake
2252122Horse
2262123Sheep
2272124Monkey
2282125Rooster
2292126Dog
2302127Pig
2312128Rat
2322129Ox
2332130Tiger
2342131Rabbit
2352132Dragon
2362133Snake
2372134Horse
2382135Sheep
2392136Monkey
2402137Rooster
2412138Dog
2422139Pig
2432140Rat
2442141Ox
2452142Tiger
2462143Rabbit
2472144Dragon
2482145Snake
2492146Horse
2502147Sheep
2512148Monkey
2522149Rooster
2532150Dog
2542151Pig
2552152Rat
2562153Ox
2572154Tiger
2582155Rabbit
2592156Dragon
2602157Snake
2612158Horse
2622159Sheep
2632160Monkey
2642161Rooster
2652162Dog
2662163Pig
2672164Rat
2682165Ox
2692166Tiger
2702167Rabbit
2712168Dragon
2722169Snake
2732170Horse
2742171Sheep
2752172Monkey
2762173Rooster
2772174Dog
2782175Pig
2792176Rat
2802177Ox
2812178Tiger
2822179Rabbit
2832180Dragon
2842181Snake
2852182Horse
2862183Sheep
2872184Monkey
2882185Rooster
2892186Dog
2902187Pig
2912188Rat
2922189Ox
2932190Tiger
2942191Rabbit
2952192Dragon
2962193Snake
2972194Horse
2982195Sheep
2992196Monkey
3002197Rooster
3012198Dog
3022199Pig
3032200Rat
3042201Ox
3052202Tiger
3062203Rabbit
3072204Dragon
3082205Snake
3092206Horse
3102207Sheep
3112208Monkey
3122209Rooster
3132210Dog
3142211Pig
3152212Rat
3162213Ox
3172214Tiger
3182215Rabbit
3192216Dragon
3202217Snake
3212218Horse
3222219Sheep
3232220Monkey
3242221Rooster
3252222Dog
3262223Pig
3272224Rat
3282225Ox
3292226Tiger
3302227Rabbit
3312228Dragon
3322229Snake
3332230Horse
3342231Sheep
3352232Monkey
3362233Rooster
3372234Dog
3382235Pig
3392236Rat
3402237Ox
3412238Tiger
3422239Rabbit
3432240Dragon
3442241Snake
3452242Horse
3462243Sheep
3472244Monkey
3482245Rooster
3492246Dog
3502247Pig
3512248Rat
3522249Ox
3532250Tiger
3542251Rabbit
3552252Dragon
3562253Snake
3572254Horse
3582255Sheep
3592256Monkey
3602257Rooster
3612258Dog
3622259Pig
3632260Rat
3642261Ox
3652262Tiger
3662263Rabbit
3672264Dragon
3682265Snake
3692266Horse
3702267Sheep
3712268Monkey
3722269Rooster
3732270Dog
3742271Pig
3752272Rat
3762273Ox
3772274Tiger
3782275Rabbit
3792276Dragon
3802277Snake
3812278Horse
3822279Sheep
3832280Monkey
3842281Rooster
3852282Dog
3862283Pig
3872284Rat
3882285Ox
3892286Tiger
3902287Rabbit
3912288Dragon
3922289Snake
3932290Horse
3942291Sheep
3952292Monkey
3962293Rooster
3972294Dog
3982295Pig
Lists
 
Upvote 0
Explanation of post #2 which violated forum rules on posting links to workbooks (good rule BTW, I just didn't think it through when I posted).
Just out of my curiosity.
Where is the zodiac sign on the 'Lists' sheet: Pisces (The fish) 02/19/year - 03/20/year
Is there a reason you left him out?
 
Upvote 0
Sorry this was an oversight. You can insert cells and enter that item. The date that I used is the current year so just enter the last day of the for that sign
 
Upvote 0

Forum statistics

Threads
1,223,243
Messages
6,170,964
Members
452,371
Latest member
Frana

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top