tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 861629d1709524809-search-book1
Sheet: Sheet2

Program | Days and Times | Concat | Participants | Staff | Hours | Apportion of Shift | In Activity Transport | Transport Cost
Day Community Break | Monday 09:00 to 15:00 |  |  | 2 |  |  | Transport 0-10 km
Digital Fun | Monday 09:00 to 15:00 |  |  | 1
[NAME] | Monday 15:00 to 17:30 |  |  | 1
Meal Masters | Tuesday 09:00 to 12:00 |  |  | 1
Let's Get Moving | Tuesday 12:00 to 15:00 |  |  | 1 |  |  | Transport 10-20 km
Life Skills | Wednesday 09:00 to 15:00 |  |  | 1 |  |  | Transport 10-20 km
Evening Gym Program | Wednesday 19:00 to 20:00 |  |  | 2
Out and About Community Connections | Thursday 09:00 to 15:00 |  |  | 1 |  |  | Transport 40-100 km
Evening Social Club | Thursday 18:30 to 21:30 |  |  | 5 |  |  | Transport 0-10 km
Art and Games | Friday 09:00 to 12:00 |  |  | 1
Sports and Recreation | Friday 12:00 to 15:00 |  |  | 1 |  |  | Transport 10-20 km
Saturday Recreational Program | Saturday 09:00 to 15:00 |  |  | 2 |  |  | Transport 40-100 km
Transport AM 1 | Monday 07:30 to 09:00 |  |  | 1 |  |  | Transport 20-40 km
Transport AM 2 | Tuesday 08:15 to 09:00 |  |  | 1 |  |  | Transport 20-40 km
Transport AM 3 | Wednesday 07:30 to 09:00 |  |  | 1 |  |  | Transport 40-100 km
Transport AM 4 | Thursday 08:00 to 09:00 |  |  | 1 |  |  | Transport 20-40 km
Transport AM 5 | Friday 07:45 to 09:00 |  |  | 1 |  |  | Transport 40-100 km
Transport AM 6 | Friday 07:30 to 09:00 |  |  | 1 |  |  | Transport 20-40 km
Transport PM 1 | Monday 15:00 to 16:30 |  |  | 1 |  |  | Transport 20-40 km
Transport PM 2 | Tuesday 15:00 to 15:45 |  |  | 1
Transport PM 3 | Wednesday 15:00 to 16:30 |  |  | 1 |  |  | Transport 40-100 km
Transport PM 4 | Thursday 15:00 to 15:45 |  |  | 1
Transport PM 5 | Friday 15:00 to 16:15 |  |  | 1 |  |  | Transport 20-40 km
Transport PM 6 | Friday 15:00 to 16:30 |  |  | 1
[NAME] | Monday 14:15 to 15:00 |  |  | 1 |  |  | Transport 10-20 km
[NAME] | Monday 17:15 to 18:00 |  |  | 1
[NAME] | Monday 17:15 to 18:45 |  |  | 1 |  |  | Transport 40-100 km
Evening Transport Gym | Wednesday 18:00 to 19:00 |  |  | 1 |  |  | Transport 40-100 km
Evening Transport Gym | Wednesday 20:00 to 21:00 |  |  | 1 |  |  | Transport 40-100 km
Evening Transport Social 1 | Thursday 17:15 to 18:30 |  |  | 1 |  |  | Transport 40-100 km
Evening Transport Social 2 | Thursday 17:15 to 18:30 |  |  | 1 |  |  | Transport 40-100 km
Evening Transport Social 3 | Thursday 17:30 to 18:30 |  |  | 1 |  |  | Transport 40-100 km
Evening Transport Social 1 | Thursday 21:30 to 22:45 |  |  | 1 |  |  | Transport 40-100 km
Evening Transport Social 2 | Thursday 21:30 to 22:45 |  |  | 1 |  |  | Transport 40-100 km
Evening Transport Social 3 | Thursday 21:30 to 22:30 |  |  | 1 |  |  | Transport 40-100 km
Saturday Transport AM | Saturday 09:00 to 10:00 |  |  | 1 |  |  | Transport 20-40 km
Saturday Transport PM | Saturday 15:00 to 16:00 |  |  | 1 |  |  | Transport 20-40 km
Spreadsheet: 271559d1381979523-help-with-multiple-vlookup-with-if-and-isna-testdataset
Sheet: Master-CurrentStudents

CurrentStudentID | CurrentlyEnrolledPreviousDropout? | Expected Column B Result | Range1LookupResult | Range2LookupResult | Range3LookupResult
1 |  | 1
2
3 |  | 1
4 |  | 1
5 |  | 1
7 |  | 0
8
10 |  | 1
 |  |  |  |  | named range lists
 |  |  |  |  | Summer2013Data
 |  |  |  |  | Spring2013data
 |  |  |  |  | fall2012 data
Spreadsheet: 850612d1701010019-vlookup-formulas-with-3-criterias-kev56-example
Sheet: Sheet1

doc # | Country ID | Product Name | quantity sold |  |  |  | doc # | Country ID | Product Name | quantity sold
IN000496 | BE | Flowers | ` |  |  |  | IN000496 | BE | Flowers | 16
IN000496 | HR | Flowers |  |  |  |  | IN000496 | PT | Flowers | 9
IN000496 | CZ | Flowers |  |  |  |  | IN000496 | CZ | Flowers | 6
IN000496 | PT | Flowers |  |  |  |  | IN000496 | ES | [NAME] | 5
IN000496 | IE | Flowers |  |  |  |  | IN000496 | IE | Flowers | 10
IN000496 | ES | [NAME] |  |  |  |  | IN000496 | HR | Flowers | 24
Spreadsheet: c08a861b-6323-41b9-bc2d-cb9ea777e794
Sheet: Purchasing

 | 3.Purchasing |  |  |  |  | Comments |  | Click here to return to Summary page
 | Green Actions
 | ACTION | Credit | Points Eearned | Total Possible Points
 | A) Purchase white paper with at least 30% recycled content: * choose only one category (30%,50%,100%) | Pts, Enter "YES" or "NO" in cell below this one. |  | 2
 | 30% recycled content | NO
 | 50% recycled content | NO |  | 3
 | 100% recycled content | NO |  | 4
 | B) New appliances are purchased with Energy Star or similar models. | 2 Pts, Enter "YES" or "NO" in cell below this one. |  |  |  |  |  | FILL IN THE GREEN CELLS ONLY
 |  | NO |  |  |  |  |  | CALCULATIONS ARE DONE AUTOMATICALLY
 | C) Purchase [NAME] (non-toxic; biodegradable). | 2 Pts, Enter "YES", "NO", or "N/A" in cell below this one.
 | COMMENT REQURIED: Please note where they are purchased and what kind. | NO
 | D) Purchase environmentally friendly--recycled content, non-toxic, remanufactured-- products (colored paper, notepads, legal pads, post-its...) | 2 Pts, Enter "YES" or "NO" in cell below this one. |  | 2
 |  | NO
 | E) Purchase furniture with recycled content, certified wood | 2 Pts, Enter "YES" or "NO" in cell below this one. |  | 2
 |  | NO
 | F) Check with Property Services to see if they have surplus office furniture before purchasing | 2 Pts, Enter "YES" or "NO" in cell below this one. |  | 2
 |  | NO
 | Total Events & Waste Points
Spreadsheet: 0166792e-1d82-4f8f-8756-9a707caa16c1
Sheet: Sheet1

Table S7. Amino acid substitutions at the engineered sites found in homologous sequences. | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
Allosteric Residues | Mutation | Count in  homologue sequences | Ratio in  homologue sequences | Conservation Score | Removing allosteric regulation without enzyme activity loss | Enzyme Activity | [NAME]
AMP binding pocket
R132 | A | 0 | 0 | 0.185 | O | Sustained | Decreased
 | E | 3 | 0.020689655 |  | O | Sustained | Decreased
 | I | 0 | 0 |  | O | Sustained | Decreased
K104 | Q | 0 | 0 | 0.384 | O | Sustained | Decreased
T23 | V | 1 | 0.006896552 | 0.547 | X | Lost | Not detected
Y105 | I | 0 | 0 | 0.747 | X | Lost | Not detected
G6P binding pocket
K222 | A | 6 | 0.04137931 | 0.139 | O | Sustained | Decreased
 | E | 21 | 0.144827586 |  | O | Sustained | Decreased
 | I | 0 | 0 |  | O | Sustained | Decreased
 | Q | 13 | 0.089655172 |  | X | Lost | Not detected
K218 | Q | 20 | 0.137931034 | 0.242 | O | Sustained | Decreased
 | A | 7 | 0.048275862 |  | X | Lost | Not detected
 | E | 0 | 0 |  | X | Lost | Not detected
 | I | 0 | 0 |  | X | Lost | Not detected
Y210 | F | 1 | 0.006896552 | 0.399 | O | Sustained | Decreased
 | I | 0 | 0 |  | O | Sustained | Decreased
Q225 | I | 0 | 0 | 0.605 | X | Lost | Not detected
 | L | 35 | 0.24137931 |  | X | Lost | Not detected
E207 | I | 0 | 0 | 0.65 | X | Lost | Not detected
 | L | 0 | 0 |  | X | Lost | Not detected
Y203 | F | 41 | 0.282758621 | 0.71 | X | Lost | Not detected
Spreadsheet: 0af16e0d-c660-4371-93e9-84a706b7b76a
Sheet: Sheet1

Unnamed: 0 | Buiséad léiriúcháin | Unnamed: 2 | costais | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | ioncam | Unnamed: 17 | [NAME] | Unnamed: 19 | Unnamed: 20 | Unnamed: 21 | Unnamed: 22 | Unnamed: 23
 | Teideal | Údar | Réamhíocaíochtaí/Táillí do scríbhneoirí | Costais eagarthóireachta | Aistriúchán | Clóchur & dearadh | Maisiú | Profáil | Cearta | Priontáil agus/nó digitiú | Dáileadh | [NAME] | [NAME] |  | COSTAIS IOMLÁNA BEARTAITHE 1 | IONCAM IOMLÁN BEARTAITHE ó fhoinsí eile (seachas díolacháin) 2 | AN TSUIM ATÁ Á LORG ÓN GCOMHAIRLE EALAÍON3 | Líon na ndíolachán aonaid measta sa bhliain féilire | Luach na ndíolachán [NAME] sa bhliain féilire | Líon focal [NAME] | [NAME] | Praghas measta | Rith cló
Teideal 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Teideal 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Teideal 3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Teideal 4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Teideal 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
1Ba cheart don fhigiúr seo a bheith ag comhfhreagairt don fhigiúr maidir le costais iomlána sa bhuiséad ar an bhfoirm iarratais
2Ba cheart [NAME] a bheith ag comhfhreagairt don fhigiúr ioncaim iomlán sa bhuiséad ar an bhfoirm iarratais
3Ba cheart don fhigiúr seo a bheith mar an gcéanna leis an bhfigiúr a chuimsítear sa bhuiséad ar an bhfoirm iarratais
Spreadsheet: 210525d1359481587-list-bring-back-names-in-column-a-that-have-are-greater-than-0-in-column-b-example1
Sheet: Sheet1

Project | Type | Used
1 | Alpha | 12
2 | Beta | 144
3 | Gamma | 300
4 | Omega | 56
5 | Alpha | 25
6 | Omega | 87
7 | Omega | 11
8
9
Spreadsheet: 453306d1459265534-can-i-use-a-formula-for-distance-traveled-thank-you-nba
Sheet: Sheet3

 |  |  |  | Philadelphia | 76ers
Celtics | Knicks | 188 |  | Portland Trail | Blazers
Knicks | Celtics | 0 |  | Charlotte | Bobcats
Heat | Mavs | 1112 |  | Milwaukee | Bucks
Mavs | Heat | 0 |  | Cleveland | Cavaliers
Bulls | Lakers | 1743 |  | Boston | Celtics
Lakers | Bulls | 0 |  | Los Angeles | Clippers
Magic | Thunder | 1059 |  | Pacific | Division
Thunder | Magic | 0 |  | Memphis | Grizzlies
Clippers | Warriors | 368 |  | Atlanta | Hawks
Warriors | Clippers | 0 |  | Miami | Heat
Nets | Wizards | 198 |  | New Orleans | Hornets
Wizards | Nets | 0 |  | Utah | Jazz
Bucks | Bobcats | 660 |  | Sacramento | Kings
Bobcats | Bucks | 0 |  | New York | Knicks
Rockets | Magic | 848 |  | Los Angeles | Lakers
Raptors | Cavs | 189 |  | Orlando | Magic
Cavs | Raptors | 0 |  | Dallas | Mavericks
Pistons | Pacers | 253 |  | Brooklyn | Nets
Pacers | Pistons | 0 |  | Denver | Nuggets
Wolves | Thunder | 0 |  | Indiana | Pacers
Nuggets | Mavs | 663 |  | Detroit | Pistons
Griz | Spurs | 629 |  | Toronto | Raptors
Spurs | Griz | 0 |  | Houston | Rockets
Hornets | Suns | 1314 |  | San Antonio | Spurs
Suns | Hornets | 0 |  | Phoenix | Suns
Kings | Lakers | 0 |  | Oklahoma City | Thunder
76ers | Blazers | 2409 |  | Minnesota | Timberwolves
Blazers | 76ers | 0 |  | Golden State | Warriors
Hawks | Nets | 741 |  | Washington | Wizards
Jazz | Lakers | 582
Spreadsheet: 841020d1693287213-i-need-a-recap-from-a-timesheet-in-the-end-of-the-month-work-automaticaly-fouad-excel
Sheet: productions

 |  |  |  |  |  | 2023 |  |  |  |  |  |  |  | 2024
n | line code | TSK_DESC | unit | Unit price | Currency | 2023-05-01 00:00:00 | 2023-06-01 00:00:00 | 2023-07-01 00:00:00 | 2023-08-01 00:00:00 | 2023-09-01 00:00:00 | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00 | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2024-06-01 00:00:00 | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00 | 2024-11-01 00:00:00 | 2024-12-01 00:00:00
1 | 4037738--L11 | Industrielle Superviseur | DAY | 26767.77 | euro | 54 | TOTAL IN END OF MONTH
2 | 4037738--L12 | Magasinier | DAY | 18382.82 | euro
3 | 4037738--L13 | Soudeur | DAY | 32399.37 | euro
4 | 4037738--L14 | Echafaudeur | DAY | 20206.12 | euro
5 | 4037738--L15 | ManSuvre | DAY | 15350.61 | euro
6 | 4037738--L16 | Tourneur | DAY | 20206.12 | euro
7 | 4037738--L17 | Monteur | DAY | 21710.02 | euro
8 | 4037738--L19 | Mécanicien | DAY | 19864.25 | euro
9 | 4037738--L20 | [NAME] | DAY | 24650.39 | euro
10 | 4037738--L21 | [NAME] | DAY | 19864.25 | euro
11 | 4037738--L24 | Ingenieur en Electricité | DAY | 28980.7 | euro
12 | 4037738--L25 | Conducteur de bus | DAY | 16103.71 | euro
13 | 4037738--L26 | Mini Bus | DAY | 9894.46 | euro
14 | 4037738--L27 | Echafaudage | TONNE | 22391.16 | euro
Spreadsheet: 695595d1600294337-reference-name-and-date-move-data-to-other-sheet-test-leydet4-
Sheet: Last dates

Name | Station 1
Mason
[NAME]
Atkins
[NAME]
Noye
Chapel
Name | Station 2
Morris
Blanchard
[NAME]
[NAME]
Murphy
Quick
Grey
Name | Station 4
[NAME]
Parsons
Mccoy
Pouns
Shoop
[NAME]
[NAME]
Englund
Name | Station 14
Draper
Soliven
[NAME]
Cromwell
Weiler
Shepard
Spreadsheet: 53723d1253639232-dynamic-questions-bank-temp
Sheet: questions

Answers | Question | Option1 | Option2 | Option3 | Option4 | Option5 | Option6 | Option7 | Option8 | Option9 | Option10
 | List Price of Config
 | Number of hours
 | Site Survey | Yes | No
 |  | J1000 | J1001 | <--assoicated JCODEs
 | Dial Plan | Yes | No
 |  | J2000 | J2001 | <--assoicated JCODEs
Spreadsheet: 456268d1460725935-sum-cells-with-blank-cells-next-to-them-example
Sheet: Sheet1

APRIL
DATE | TIME | CLIENT | TOTAL TIME |  | STAFF
FRI 1ST | 07:00 - 07:45 | JOE | 0.75 |  | MEGAN
 | 07:15 - 07:45 | HARRY | 0.5 |  | SARA | SUE
 | 08:00 - 08:45 | FREDA | 0.75 |  | MEGAN
 | 08:30 - 12:00 | PETER | 3.5 |  | SARA
 | 09:00 - 10:00 | AMY | 1
 | 08:30 - 09:15 | HARRY | 0.75 |  | MEGAN | SUE
 | 09:00 - 13:00 | AMY |  | 4 | MANDY
In this example I wish to add up all columns that would match the red highlighted one.
To get a total of the numbers in column D where '[NAME]' is in column C and columns F and G are blank
Spreadsheet: 08135b39-0c69-4d29-9909-01b57af4b497
Sheet: New Student Form

New Student Information Form
To add a new student during the audit process the following information must be completed by the district.
(Please attach all supporting documentation, including attendance records)
State ID #
Last Name
First Name
Middle
Generation
Local ID #
DOB
Attendance School |  | Funding School __________Accountability School_________
School Lunch |  | Provide lunch application
Homeless
Virtual Student
First Language |  | Required only if student has ESOL minutes
PBR Grade
Minutes Enrolled |  | Provide attendance records
Primary Exceptionality |  | Required if Special Education Student
Gifted |  | Yes/No
CTE Minutes |  | Valid only for High school student enrolled in vocational class - provide student schedule.
Concurrent HS |  | Provide post-secondary class attendance log
School Entry Date
District Entry Date
State Entry Date
USA Date |  | Required if ESOL student
Trans. [NAME] |  | 0 if not transported
Trans. FTE |  | 0 if not transported
Resident Dist. |  | District number (D0101) or state designation (MO)
Address |  | City ______________________________[NAME] _____________
ESOL Minutes |  | Valid only if student and teacher are qualified. Provide teacher and student eligibility documentation.
[NAME] |  | Required if ESOL minutes completed.
ESOL Entry Date |  | Required if ESOL minutes completed.
Immigrant Student |  | 0 = No       1 = Yes w/Title III          2 = Yes w/o Title III
Country of Birth |  | Required if Immigrant Student is 1 or 2
Hispanic Ethnicity |  | (Yes or No)
Comprehensive Race |  | Required field (White, Native Hawaiian or other Pacific Islander, Black or African American, Asian, American Indian or [NAME])
Gender |  | 0 = Female  1 = Male
Data required to enter a new student, items not shaded are optional.
Spreadsheet: 194108d1353043471-filtering-data-and-then-re-filtering-that-data-help-suggestions-please-membership-database-and-log-copyx
Sheet: Payment Log

Payment Log
Notes: For other sheets to calculate properly the payment dates must be accending! If you sort to see all payment records for a member then re-sort by payment date.
Column 1 | Column 2 | Column 3 | Column 4 | Column 5 | Column 6 | Column 7 | Column 8 | Column 9 | Column 10
Payment ID | Member ID | Last Name | First Name | Membership Type | Member Price | Payment Date | Payment Type | Payment Length | Payment Amount |  | Code 1 | Code 2 | Code 3 | Payment Type | Payment Length | Payment Amount
 | mil7890 |  |  |  |  | 2012-10-08 00:00:00 | Cash | 1 Week | 60
 | mil7890 |  |  |  |  | 2012-10-01 00:00:00 | Cash | Other | 120
 | mil8901 |  |  |  |  | 2012-10-10 00:00:00 | Check | 10 Sessions | 1
 | mil9012 |  |  |  |  | 2012-10-11 00:00:00 | Cash | 3 Months | 2
 | Smi0123 |  |  |  |  | 2012-10-12 00:00:00 | Cash | 1 Week | 3
 | Doe1234 |  |  |  |  | 2012-10-13 00:00:00 | Cash | 2 Weeks | 4
 | Doe2345 |  |  |  |  | 2012-10-14 00:00:00 | Credit Card | 1 Month | 5
 | mil7890 |  |  |  |  | 2012-10-10 00:00:00 | Cash | 1 Week | 6
 | mil9012 |  |  |  |  | 2012-10-16 00:00:00 | Cash | Drop In | 7
 | Smi0123 |  |  |  |  | 2012-10-17 00:00:00 | Credit Card | 10 Sessions | 8
 | Smi0123 |  |  |  |  | 2012-10-18 00:00:00 | Cash | Other | 9
 | Doe1234 |  |  |  |  | 2012-10-19 00:00:00 | Cash | 1 Week | 10
 | Doe2345 |  |  |  |  | 2012-10-20 00:00:00 | Cash | 3 Months | 11
 | Smi0123 |  |  |  |  | 2012-10-21 00:00:00 | Check | 10 Sessions | 12
 | mil9012 |  |  |  |  | 2012-10-22 00:00:00 | Credit Card | 1 Month | 13
 | mil7890 |  |  |  |  | 2012-11-15 00:00:00 | Check | 10 Sessions | 14
 | mil7890 |  |  |  |  | 2012-11-16 00:00:00 | Check | Drop In | 15
Spreadsheet: 679723d1590599331-matching-specific-words-in-text-string-to-column-header-sample-workbook-segregating-text
Sheet: Sheet1

 |  | Applications Out | In Process | Submitted | PreApproved TBD | Approved | Docs Out | Closed | Post Closing | Applications Out - Now Closed | Dormant | Cancelled | Leads
All Files/1. [NAME]'s loans with Jane/1.  Applications Out Loans/Sample1, Scott loan file/
All Files/1. [NAME]'s loans with Jane/1.  In Process Loans/Sample2, [NAME] loan file/
All Files/1. [NAME]'s loans with Jane/1.  Submitted Loans/Sample3, [NAME] loan file/
All Files/1. [NAME]'s loans with Jane/1.  PreApproved TBD Loans/Sample4, [NAME] loan file/
All Files/1. [NAME]'s loans with Jane/1.  [NAME]/Sample5, [NAME] loan file/
All Files/1. [NAME]'s loans with Jane/1.  Docs Out Loans/Sample6, Sam & Sample6a, [NAME] loan file/
All Files/1. [NAME]'s loans with Jane/1.  Closed Loans/Sample7, [NAME] loan file/
All Files/1. [NAME]'s loans with Jane/1.  Post Closing Loans/Sample8, Shay loan file/
All Files/1. [NAME]'s loans with Jane/1.  Applications Out - Now Closed Loans/Sample9, Timmy loan file/
All Files/1. [NAME]'s loans with Jane/1.  Dormant Loans/Sample10, [NAME] loan file/
All Files/1. [NAME]'s loans with Jane/1.  Cancelled Loans/Sample11, [NAME] loan file/
All Files/1. [NAME]'s loans with Jane/1.  [NAME], [NAME] loan file/
Spreadsheet: 852905d1702896389-bring-uniq-names-from-multiple-rows-lista-bpo-2022-2023-1-aligw
Sheet: Sheet5

FTE | [NAME] conform raport lunar | Nume | Jan | Jun | May | Apr | Norma | Trend week |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Observations
 | Week_Today | 2022-01-01 00:00:00 | TGT
 |  |  |  |  |  |  |  |  | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2022 | 2023 | 2023 | 2023 | 2023 | 2023 | 2023 | 2023 | 2023 | 2023 | 2023 | 2023 | 2023 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024 | 2024
Spreadsheet: 130465d1322331325-date-formulas-sample-of-budget
Sheet: INCOME

INCOME |  |  | AMOUNTS ENTERED FROM COLUMN C5 CAN BE EITHER FROM ANOTHER SETTING SO TO AVOIDING REPEAT ENTERING BUT ALSO BE MANULLY CHANGED FOR VARIABLE DATE VALUES
HEADINGS |  | DATE | INCOME | OCCURANCE | DATES AUTO GENERATED
 |  | 2011-11-28 00:00:00 | 100 | MONTHLY | 2011-12-28 00:00:00 | 2012-01-28 00:00:00 | AND SO ON
 |  | 2011-11-28 00:00:00 | INCOME 2 | WEEKLY | 2011-12-05 00:00:00 | 2011-12-12 00:00:00 | AND SO ON
 |  | 2011-11-29 00:00:00 | INCOME 3 | 4 WEEKS | 2011-12-27 00:00:00 | 2012-01-24 00:00:00
Spreadsheet: 203565d1357164294-comparing-names-and-dates-in-separate-workbooks-example-for-help
Sheet: Master List

First Name: | Last Name: | [NAME]: | [NAME] | Hyatt Departure | [NAME] | Hyatt Departure 2 | ConcatName | [NAME] | Hyatt Departure | [NAME] | Hyatt Departure 2
[NAME] | Jones | [EMAIL] | 2013-01-09 00:00:00 | 2013-01-11 00:00:00 | 2013-01-15 00:00:00 | 2013-01-16 00:00:00
[NAME] | Aguilar | [EMAIL] |  |  | 2013-01-09 00:00:00 | 2013-01-10 00:00:00
[NAME] | [NAME] | [EMAIL] |  |  | 2013-01-15 00:00:00 | 2013-01-16 00:00:00
Spreadsheet: 189310d1351155359-use-the-table-to-calculate-differetn-quantities-libro11
Sheet: Accent Siz&wgt.

E27 Accent |  |  |  |  |  |  |  |  |  |  | GU10 Accent
Number | Product |  | Ounces | Inside Box(oz.) |  | Diameter and Millimeter size |  |  |  |  | Number | Product |  | Ounces | Inside Box(oz.) |  | Diameter and Millimeter size
1 | HS0107 |  | 1.76 | 2.04 |  | Φ49x53.85 |  |  |  |  | 1 | HS0110 |  | 1.48 | 1.76 |  | Φ50x55.5
2 | HS0108 |  | 1.78 | 2.07 |  | Φ49x53.85 |  |  |  |  | 2 | HS0303 |  | 1.34 | 1.64 |  | Φ49x60.8
3 | HS0109 |  | 2.65 | 2.93 |  | Φ50 x 63 |  |  |  |  | 3 | HS0305 |  | 1.51 | 1.79 |  | Φ49x60.8
4 | HS0111 |  | 1.77 | 2.06 |  | Φ49.83 x 56.23 |  |  |  |  | 4 | HS0314 |  | 1.6 | 1.88 |  | Φ49 x 60
5 | HS0301 |  | 2.9 | 3.55 |  | Φ48.5x61.5 |  |  |  |  | 5 | HS0502 |  | 2.59 | 3.35 |  | Φ49.28x86
6 | HS0302 |  | 2.24 | 2.57 |  | Φ48.8x63
7 | HS0308 |  | 1.83 | 2.12 |  | Φ50x56.5
8 | HS0309 |  | 1.76 | 2.05 |  | Φ50 x 56
9 | HS0313 |  | 1.62 | 1.95 |  | [NAME] 62.5
10 | HS0315 |  | 2.96 | 3.62 |  | Φ62 x 73.5
11 | HS0504 |  | 8.08 | 9.97 |  | Φ94x78
12 | HS0505 |  | 3.95 | 4.69 |  | Φ48.8 x 100
13 | HS1201 |  | 15.86 | 19.21 |  | Φ122x135
MR16 Accent
Number | Product |  | Ounces | Inside Box(oz.) |  | Diameter and Millimeter size
1 | HS0101 |  | 0.86 | 1.16 |  | Φ31.38x48.33
2 | HS0310 |  | 1.5 | 1.78 |  | Φ49.85x57.35
3 | HS0311 |  | 2.11 | 3.04 |  | Φ49.85x79.6
4 | HS0312 |  | 3.1 | 4.05 |  | Φ49.95x89.12
5 | HS0401 |  | 1.83 | 2.12 |  | Φ48.58x65
6 | HS0501 |  | 2.35 | 3.29 |  | Φ49.32x79.80
Spreadsheet: 732274d1620852331-vlookup-to-the-left-test-book
Sheet: Sheet2

ID # | Amount | Generation | CARD #
42ED031548 | 40 | I
42ED033271 | 30 | II
42ED033274 | 55 | I
42ED033284 | 20 | II
42ED033474 | 21 | III
42ED033566 | 14 | II
42ED033612 | 60 | I
42ED033619 | 34 | II
42ED033897 | 24 | IV
42ED033901 | 15 | II
42ED033902 | 15 | I
42ED033906 | 35 | V
42ED034698 | 25 | V
42ED034813 | 45 | II
42ED034815 | 22 | I
42ED034816 | 35 | II
42ED034818 | 33 | III
42ED034820 | 10 | II
42ED034821 | 50 | III
42ED034827 | 44 | II
42ED034831 | 60 | V
42ED024278 | 61 | II
42ED031531 | 63 | I
42ED031532 | 45 | II
42ED031533 | 22 | I
Spreadsheet: 103129d1300930942-vlookup-isnt-updating-on-data-change-mage_gear
Sheet: Gear list

Item | Intellect | Wisdom | SP | Crit | Focus | Location
Main Hand
[NAME] | 45 | 23 | 428 | 0 | 47 | Abyssal Precipice
Greatstaff of the Cyclone | 38 | 31 | 428 | 0 | 68 | Charmer's Caldera
Off Hand
Tome of the Titans | 14 | 21 | 214 | 0 | 43 | Deepstrike Mines
Wand
Helm
Shoulders
Chest
Gloves
Belt
Legs
Boots
Neck
Trinket
Ring
Spreadsheet: 875488d1722051285-merging-two-arrays-need-solution-for-excel-2019-excel-problem-18aug23
Sheet: Sheet1

INPUT | fetch details from this |  | (all is on same worksheet of same workbook)
EMPLOYEE | code | location | under
ilias | As23 | city | DD4
[NAME] | Sl4 | store-Ahm | RSW |  | OUTPUT needed
 |  |  |  |  | employee name | code | location | under | SKU ID | QTY | COST | commEM(40% | commSU(5%)
rakesh | RkD | Store-kpur | YS |  | ILIAS | As23 | city | DD4 | A-Dates551 500gm | 2.53 | 120
 |  |  |  |  |  |  |  |  | A-A5001 500gm | 1.56 | 85
(here name is having different case) |  |  |  |  |  |  |  |  | D-grap 1000gm | 3.75 | 245
 | sales |  |  |  |  |  |  |  | E-cha | 5.5 | 220
 | SKU ID | qty | Amount |  | [NAME] | Sl4 | store-Ahm | RSW | B-dal335 | 4.85 | 126
ilias | A-Dates551 500gm | 2.53 | 120 |  |  |  |  |  | C-Alm | 1.2 | 430
 | A-A5001 500gm | 1.56 | 85 |  | Rakesh | RkD | Store-kpur | YS | D-grap 1000gm | 2.5 | 130
[NAME] | B-dal335 | 4.85 | 126 |  |  |  |  |  | E-cha | 3.5 | 140
 | C-Alm | 1.2 | 430
Rakesh | D-grap 1000gm | 2.5 | 130
 | E-cha | 3.5 | 140
ilias | D-grap 1000gm | 3.75 | 245
 | E-cha | 5.5 | 220