#centri's garden planner

1 messages · Page 1 of 1 (latest)

thorn spear
#

hi gamers so i‘ve made a flower plot planner/ tracker with ✨ pictures ✨ that's a lil unnecessary and very clunky but i can't read nisetamasan

🆕 currently updated to v2.4.5 kiki

plan the plan rn [ craft working on rn ] [ rewardcalendar ready for next update ]
goals/ wip sheet
declutter/ rearrange
second greenhouse sheet w clear upgrade sections ( if y'all want )
compatible flowers for each biome
make it look cute ??
add/ improve accessibility ( ongoing )
switching to a non-microsoft product craft

feedback questions suggestions always welcome 🙂‍↕️ 🙏

⚠️ there are flower spoilers

fwishingwell ty to @sly vessel who made the original plot maps, and the hkia wiki + contributors where most images are from

thorn spear
#

📝 u can copy paste inputs across the entire workbook ( need to add that to instructions )

still stratus
#

@thorn spear This is AMAZING 😭🥹 Thank you so much for putting in so much work to create this, so so appreciated! 🫶

thorn spear
thorn spear
thorn spear
#

centri's garden planner

#

still trying to figure out a way to make migration easier wo everything breaking in the process, but u can copy paste ur input plots ( i just wouldn't try to move too many at once especially on the big pages )

thorn spear
#

sooo i'm going to be trying to use microsoft products as little as possible, which includes excel. it's not completely off the table rn tho, so here is v2.4.5-3 with the updates i'd already made. i honestly don't know if i'm going to continue updating/ working on the excel version of this, but i am gonna see if i can switch it to libre or mb numbers 🙇 🍉

#

changes:
dropdowns for flowers and patterns are alphabetical; no change to colors
fixed cloud island oopsie
hidden in the title bar for every plot are additional flower squares ( right justified ) for stuff like plot goals, or what u want to plant
master checklist sheet for reference
added alt text to checklist images

ivory horizon
#

hi!! how do i get the pictures to show up? currently the output page is just showing UNKNOWN for all outputs

thorn spear
#

when u first opened it were these flowers working ?

ivory horizon
#

no those don't show either 😦

#

none of the outputs. i had only entered in a few things on one of the input pages, after telling Excel im ok with editing this file from the internet

#

i was also manually picking the flower and color.

#

i guess my question is how does it get the picture resources? is there a data connection missing?

#

i can add screenshots if it helps?

thorn spear
ivory horizon
thorn spear
#

where did they gooo

ivory horizon
#

big oof 😦

thorn spear
#

ok im gonna put together a sheet w the icons for u to copy n paste and we'll see if the pictures make it thru

#

also do u see the seed/ hand/ fertilizer/ watering can icons on the checklists ?

ivory horizon
#

also no dice on the separate sheet. i opened it on its own, and still nothing. what's interesting is that it shows "unavabile data type" when i hover over the error

#

is it by chance using Python in Excel?

thorn spear
#

no i didn’t use any python or macros so it’s browser friendly

ivory horizon
#

that's so odd, i tried uploading it to my google drive and it still doesn't work

thorn spear
#

does seem like there are error w picture in cell sometimes tho, i’ll have to double check that the images are all embedded hmmm

ivory horizon
#

idk if this helps, but i tried with both Google Sheets and ms office on my computer (i have office 2021)

thorn spear
#

i doubt it’s compatible w sheets cause of formula differences and poss naming issues, but it should work in the browser version of excel

ivory horizon
#

interesting, let me try browser excel, pls hold

thorn spear
#

one thing u can try - go to options -> advanced -> display -> show all objects

ivory horizon
#

in desktop excel or sheets?

thorn spear
#

desktop excel

ivory horizon
#

yep already set that way

#

buuuut it does work in excel online

thorn spear
#

fjjdfj how’s it working better in the browser 😭

#

ooo mb if u download a copy from the browser

#

my last fix was gonna be to drop some folders here w all the images so u an at least diy it orz

ivory horizon
#

nope 😦 i think it's because the data types are a Microsoft 365 thing, which you can only use for free if in the browser

thorn spear
#

⚰️

thorn spear
#

diy prolly won’t work since ms is gatekeeping picture in cell, but at least u get it to work in browser 🥹