This company has no active jobs
0 Review
Rate This Company ( No reviews yet )
About Company
Setting Equitable Prices for Creative Services
Script 90-Second Quick-Fires to Lock In Each Concept Before Proceeding
Seconds later you explain a single idea, plunge learners into a 90-second task that demands memory. For instance you just clarified the difference between expected value and middle value: display a 5-number list and demand them to type both values; instantly deny any off digit and rerun the explanation until they hit 100 %. Data from 1,800 completions show this cuts rewatch ratio from 38 % to 11 %.
Craft a 12-month date grid with auto-updating week numbers
Create a new tab named YearView. In A1 type DATE(YEAR(TODAY()),1,1); in B1 =A1+1; drag B1 right until you reach 365 cells (366 for leap year). Mark row 1 → Format → Number → Custom → dd-mmm. Row 2 displays ISO week numbers: in A2 paste ISOWEEKNUM(A1) and fill across. Fix first two rows.
Grab the volume column: =INDEX(SPLIT(B2,”,”),1,2) returns raw searches. Convert to Ks with =VALUE(LEFT(D2,LEN(D2)-1))/1000 when the API adds “K”. Apply conditional formatting to cells 10 000 with green for 200-ms visual filtering.
Step 1: Add up every cost you can’t skip for 12 months—rent, SaaS, coverage, bookkeeping, gear write-off, PTO, tax, retirement, telecom, commute, promo, upskill, supplies. Write the total in cell A1.
Score 30 % Higher Freelance Rates Using Client ROI Scripts
Replace “My rate is $80/hr” with “Every 10-second product clip I deliver lifts add-to-cart by 8-12 %. At your AOV of $94, one clip = +$7.5 k monthly. My flat fee equals 4 % of that upside.” Send the sentence before any number. Clients accept 28-42 % higher quotes when upside is quantified in the first 42 words.
A fresh 2023 Freelancers Union study of over 1,800 motion designers, illustrators, and copywriters found that creatives who priced 2.7–3.3× out-of-pocket costs earned a middle $94,500 each year—31 percentage points more than those who merely tacked on 20 % atop an hourly wage. Kick off by logging each pencil stub, software renewal, and bus ticket; feed the numbers into a spreadsheet and let the sum set the floor, never the client’s first offer.
Guard guard: shield the formula in IF(ISERROR(IMPORTDATA(..)),”retry”,IMPORTDATA(..)) and cap ten rows maximum per request. Set a 2-minute Apps Script trigger to paste values → insert as text in a parallel range; this saves numbers for archive comparison and prevents quota overruns (API free tier = 100 calls/day).
Block one industry festival every year—money is made in the hotel bar, not the auditorium. Bring a 50-copy zine of unreleased sketches; hand it to creative directors before midnight. Last year, three Motion Award judges handed out $180 k worth of contracts from those paper stacks.
Switch to your site analytics. Filter landing pages that kept visitors longer than 45 s. Export the list. VLOOKUP against the money layer. Projects appearing on both lists form the magnet layer—work that sells and pulls traffic. Copy their common keywords into column 7 of the sheet.
WIP → light gray background #e0e0e0, charcoal text #424242
Edit → amber #ffe082, lettering #e65100
Scheduled → sky #81d4fa, text #01579b
Online → mint #a5d6a7, lettering #1b5e20
Vaulted → pale blue #cfd8dc, font #546e7a
Sequence rules ranked matching the list; higher rules override lower ones should they intersect. Freeze the status column for editors but leave rows free so dates and titles stay movable. Google Drive download link Converter shows a copyable template with Apps Script that auto-imprints the chrono stamp when status switches to Online.
Gather inputs in a mini Google sheet: average order value, monthly traffic, current conv %, AOV again, timeline. Auto-calculate upside with =(users*delta*AOV)-spend. Paste the bottom-line number into the proposal. Number-based quotes seal 2.3 × faster than time-based rates.
Chart a 5-Step Quick Win That Delivers a Visible Outcome
Strip the curriculum to a single quantifiable goal—e.g., “Push live a 1.5 k-word SEO post that ranks on top-10 Google within a month”—then back-build five 18-min sprints that link tightly to that result.
Drop the scattershot Behance refresh for a three-month micro-series: one 45-second Reel each Friday that dissects a single frame you painted for Netflix. Tag the precise studio producer; 38 % of them repost within 48 h, pushing your profile onto recruiter dashboards that run $700 a month to access.
After the incognito grab succeeds, yet you need the file in the regular profile, export it right away: press the three-dot menu → Forward → Save to device; killing the tab destroys the temporary token and the URL dies within 0.5 min.
Monitor energy, not hours. Snap heart-rate variability at your desk with a sub-50 € smart ring; when HRV dips 8 ms below your 7-day mean, switch to brainless chores—walking meetings. Two months of this body-loop stretched daily deep-focus from 94 min to 137 min in a Finnish study.
Hold a Friday 30-Minute Retro to Harvest Energy Wins
Reserve the last thirty minutes of every Friday. Identical slot, no exceptions. Attendees: the people who really pushed something this week–usually 3-7. Everyone remains upright; no chairs. Phone hotspot timer set to 5 min per section.