tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 866189d1713164123-finding-partial-match-in-databse-with-filter-and-xloopup-testsheet-database-v4-aligw
Sheet: Database

Hobby_1 | Hobby_2 | Hobby_3 | Hobby_4 | Hobby_5 | Interest_1 | Interest_2 | Interest_3 | Interest_4 | Interest_5 | Lifestyle_1 | Lifestyle_2 | [NAME] | Lifestyle_4 | Lifestyle_5 | Values_Attitudes_Opinions_1 | Values_Attitudes_Opinions_2 | Values_Attitudes_Opinions_3 | Values_Attitudes_Opinions_4 | Values_Attitudes_Opinions_5 | Name | Data_Accuracy_Psychographics | Personality_List | Hobby_List | Interest_List | Lifestyle_List | Values_Attitudes_Opionions_List
3D Printing | Adventure Travel | Amateur Radio | [NAME] | n/a |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 0.9 | ISTJ - The Inspector
Adventure Travel | Astronomy | American Football | Other | n/a |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 0.85 | ISTP - The Crafter
American Football | n/a | n/a | n/a | n/a |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Xander | 0.7 | ISFJ - The Protector
Antiquing | Amateur Radio | App Development | Archery | Astronomy |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rachel | 0.96 | ISFP - The Artist
Astronomy | Archaeology | Martial Arts | Padel | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 0.81 | INFJ - The Advocate
American Football | Painting or Drawing | Traveling | Rugby | Other |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Henk | 0.46 | INTJ - The Architect
App Development | Hiking or Nature Walking | Paranormal Investigation | Swimming | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Pim | 0.3 | ISTJ - The Inspector
Astronomy | Astrology | Surfing | Other | n/a |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Jessica | 0.2 | INTJ - The Architect
Declined to [NAME] | Declined to [NAME] | Declined to [NAME] | Declined to [NAME] | Declined to [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | 0.9 | ESFP - The Performer
Spreadsheet: 145387d1331565006-index-match-several-sheets-to-one-formula-vml
Sheet: tab1

1.14 |  |  | Dep Date |  |  |  |  |  |  | 2011-04-28 00:00:00 | 2011-05-05 00:00:00 | 2011-05-12 00:00:00 | 2011-05-19 00:00:00 | 2011-05-26 00:00:00 | 2011-06-02 00:00:00 | 2011-06-09 00:00:00 | 2011-06-16 00:00:00 | 2011-06-23 00:00:00 | 2011-06-30 00:00:00 | 2011-07-07 00:00:00 | 2011-07-14 00:00:00 | 2011-07-21 00:00:00 | 2011-07-28 00:00:00 | 2011-08-04 00:00:00 | 2011-08-11 00:00:00 | 2011-08-18 00:00:00 | 2011-08-25 00:00:00 | 2011-09-01 00:00:00 | 2011-09-08 00:00:00 | 2011-09-15 00:00:00 | 2011-09-22 00:00:00 | 2011-09-29 00:00:00
ANASTASIA |  |  | W/c Date |  | 2011-04-02 00:00:00 | 2011-04-09 00:00:00 | 2011-04-16 00:00:00 | 2011-04-23 00:00:00 | 2011-04-30 00:00:00 | 2012-05-05 00:00:00 | 2012-05-12 00:00:00 | 2012-05-19 00:00:00 | 2012-05-26 00:00:00 | 2012-06-02 00:00:00 | 2012-06-09 00:00:00 | 2012-06-16 00:00:00 | 2012-06-23 00:00:00 | 2012-06-30 00:00:00 | 2012-07-07 00:00:00 | 2012-07-14 00:00:00 | 2012-07-21 00:00:00 | 2012-07-28 00:00:00 | 2012-08-04 00:00:00 | 2012-08-11 00:00:00 | 2012-08-18 00:00:00 | 2012-08-25 00:00:00 | 2012-09-01 00:00:00 | 2012-09-08 00:00:00 | 2012-09-15 00:00:00 | 2012-09-22 00:00:00 | 2012-09-29 00:00:00 | 2012-10-06 00:00:00 | 2012-10-13 00:00:00 | 2012-10-20 00:00:00 | 2012-10-27 00:00:00 | TOTAL | 2011-04-30 00:00:00 | 2011-05-31 00:00:00 | 2011-06-30 00:00:00 | 2011-07-31 00:00:00 | 2011-08-31 00:00:00 | 2011-09-30 00:00:00 | 2011-10-31 00:00:00 | Total
SKG |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 4 | 5 | 5 | 5 | 5 | 6 | 6 | 6 | 6 | 6 | 7 | 7 | 7 | 7 | 8 | 8 | 8 | 8 | 9 | 9 | 9 | 9 | 9 | 1 | 1 | 1 |  | 4 | 5 | 6 | 7 | 8 | 9 | 10
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.1279737551786876 | 0.2216781143834356 | 0.2911703896426912 | 0.2226846941348127 | 0.1171279072896231 | 0 |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Other Costs | Transfers | -11.40350877192983 |  |  |  |  |  |  |  | -1000.750656606071 | -1000.750656606071 | -1000.750656606071 | -1000.750656606071 | -1363.060206125507 | -1321.333873284931 | -1321.333873284931 | -1321.333873284931 | -1321.333873284931 | -1425.077225308224 | -1205.019324153766 | -1205.019324153766 | -1205.019324153766 | -1247.358770121179 | -1247.358770121179 | -1247.358770121179 | -1218.586283233858 | -1418.656540084388 | -1418.656540084388 | -1418.656540084388 | -1388.790086608928 | -1021.498947368421 | 0 |  |  |  | -27318.45477128694 | -1000.750656606071 | -4365.31217594372 | -6710.412718447948 | -4862.416742582477 | -5131.960363560604 | -5247.602114146125 | 0 | -27318.45477128694 | 0
 | Handling | 0 |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 33969d1230936087-how-to-do-a-progressive-add-with-an-if-clause-that-is-interrupted-whiteboards-p5wk4
Sheet: MainBoard

Period   5       Week   4 | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday |  | Sunday |  | Total
L.Y.'s Sales/Last Weeks Sls |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
Planned Sales / Accum | 200 | 200 | 200 | 400 | 200 | 600 | 200 | 800 | 200 | 1000 | 200 | 1200 | 200 | 1400 | 1400
Actual Sales/Accum | 250 | 250 | 250 | 500 | 250 | 750 | holiday | #N/A | 250 | #N/A | 150 | #N/A | 150 | #N/A | #N/A
Daily Sales Var/Accum Sales Var | 50 | 50 | 50 | 100 | 50 | 150 | #N/A | #N/A | 50 | #N/A | -50 | #N/A | -50 | #N/A | #N/A
Admininistration Hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
FE Hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
Merchandising Hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
Major [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
Memberservice Hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
Marketing Hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
Receiving Hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
Tire Center Hours |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
[NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
Total Hours (Plan/Actual) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Daily Hours Var./Acc. [NAME]. |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
Planned Payroll $'s/ Act. Payroll $ | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Planned Payroll %/Act. Payroll % | 0 | 0 | 0 | 0 | 0 | 0 | 0 | #N/A | 0 | 0 | 0 | 0 | 0 | 0 | 0 | #N/A
Planned Prod./Act. Prod.  (Total) | - | - | - | - | - | - | - | - | - | - | - | - | - | - | - | -
Planned Prod./Act. Prod. (Merch)
Projected Week average salary |  |  |  |  |  |  |  |  |  | Holiday(s) & Inventories |  | Plan  Hrs | Act Hrs | Plan $'s | Act $'s
 | . |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  |  |  | Holiday average wage
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Plan $'s with Hol | Act $'s with Hol | Prod with Hol
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | -
Spreadsheet: 1c238db8-173c-498c-9563-f4eb6bbf25d2
Sheet: 11c

Product1 | 0-34 | 3-6 | 6-12 | 12-24 | 24-60 | 60-120 | 120-360 | 360+ | TOTAL
Cross-Currency Basis | 19 | 23 | 72 | 82 | 103 | 129 | 104 | 15 | 547
Cross-Currency Fixed-Fixed | 3 | 2 | 2 | 8 | 11 | 11 | 14 | 0 | 51
Cross-Currency Fixed-Float | 8 | 1 | 73 | 57 | 62 | 49 | 14 | 0 | 264
TOTAL
Spreadsheet: 471359d1468969466-excel-calculation-problem-of-the-pi-value-beenleigh-mix-designs-2016
Sheet: Type 2.1 Lot 76   (2)

RAW MATERIALS MIX DESIGN
Product Type: | Type 2.1 | Location: | Beenleigh [NAME] |  | Blender: | Pug 2 |  | Lab No. | 1552/S/51362
Grading Type: | "C" | Lot No.: | 76 |  | Issue # : | 1 |  | Date: | 2016-06-24 00:00:00
 |  |  |  |  |  | Con  33 | Con 31
 |  | Mix Proportion (%): |  |  | 100 | 99 | 1 |  |  |  | 99 | 1 | 0 | 0 | 0 | 100
 | 0.4949409780775716 |  |  |  | Percent Passing (%)
Sieve (mm) | Minimum | Maximum | 1/3 Minimum | 1/3 Maximum | Mix | Plant  Scalps 21/04/16 | Dust Av. Last 30 days
37.5 | 100 | 100 | 100 | 100 | 100 | 100 | 100
19 | 80 | 100 | 86.66666666666667 | 93.33333333333333 | 99.01 | 99 | 100
9.5 | 55 | 90 | 66.66666666666667 | 78.33333333333333 | 78.22 | 78 | 100
4.75 | 40 | 70 | 50 | 60 | 61.39 | 61 | 100
2.36 | 30 | 55 | 38.33333333333334 | 46.66666666666666 | 41.59 | 41 | 100
0.425 | 12 | 30 | 18 | 24 | 11.86 | 11 | 97
0.075 | 5 | 20 | 10 | 15 | 5.87 | 5 | 92
Liquid Limit |  | 25 |  |  | 0
Plasticty Index |  | 6 |  |  | 0.46 | 0 | 46
Linear Shrinkage |  | 3.5 |  |  | 0 | 0 | 0
[NAME] |  |  |  |  | 0.4949409780775716 | 0.4545454545454545 | 0.9484536082474226 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A
Spreadsheet: 858071d1706845056-enter-first-date-of-the-year-only-and-will-populate-the-rest-of-the-months-calendar-test
Sheet: Aug

 |  |  | WK No. |  | 31 | 31 | 31 | 32 | 32 | 32 | 32 | 32 | 32 | 32 | 33 | 33 | 33 | 33 | 33 | 33 | 33 | 34 | 34 | 34 | 34 | 34 | 34 | 34 | 35 | 35 | 35 | 35 | 35 | 35
 |  |  | Day |  | 2024-08-02 00:00:00 | 2024-08-03 00:00:00 | 2024-08-04 00:00:00 | 2024-08-05 00:00:00 | 2024-08-06 00:00:00 | 2024-08-07 00:00:00 | 2024-08-08 00:00:00 | 2024-08-09 00:00:00 | 2024-08-10 00:00:00 | 2024-08-11 00:00:00 | 2024-08-12 00:00:00 | 2024-08-13 00:00:00 | 2024-08-14 00:00:00 | 2024-08-15 00:00:00 | 2024-08-16 00:00:00 | 2024-08-17 00:00:00 | 2024-08-18 00:00:00 | 2024-08-19 00:00:00 | 2024-08-20 00:00:00 | 2024-08-21 00:00:00 | 2024-08-22 00:00:00 | 2024-08-23 00:00:00 | 2024-08-24 00:00:00 | 2024-08-25 00:00:00 | 2024-08-26 00:00:00 | 2024-08-27 00:00:00 | 2024-08-28 00:00:00 | 2024-08-29 00:00:00 | 2024-08-30 00:00:00 | 2024-08-31 00:00:00
 |  |  |  |  | 2024-08-02 00:00:00 | 2024-08-03 00:00:00 | 2024-08-04 00:00:00 | 2024-08-05 00:00:00 | 2024-08-06 00:00:00 | 2024-08-07 00:00:00 | 2024-08-08 00:00:00 | 2024-08-09 00:00:00 | 2024-08-10 00:00:00 | 2024-08-11 00:00:00 | 2024-08-12 00:00:00 | 2024-08-13 00:00:00 | 2024-08-14 00:00:00 | 2024-08-15 00:00:00 | 2024-08-16 00:00:00 | 2024-08-17 00:00:00 | 2024-08-18 00:00:00 | 2024-08-19 00:00:00 | 2024-08-20 00:00:00 | 2024-08-21 00:00:00 | 2024-08-22 00:00:00 | 2024-08-23 00:00:00 | 2024-08-24 00:00:00 | 2024-08-25 00:00:00 | 2024-08-26 00:00:00 | 2024-08-27 00:00:00 | 2024-08-28 00:00:00 | 2024-08-29 00:00:00 | 2024-08-30 00:00:00 | 2024-08-31 00:00:00
Spreadsheet: 783561d1654906667-mapping-a-google-plus-code-but-the-is-omitted-when-using-the-hyperlink-x-database-google-plus-codes
Sheet: Sheet1

 |  | Location | Address | Google Plus Code | [NAME]
 |  | Acura of North Scottsdale | 7007 E [NAME], Phoenix, AZ | M32C+7G
 |  | Acura of Tempe | 7800 S Autoplex Loop, Tempe, AZ | 82WH+JQ
 |  | Audi of North Scottsdale | 7150 E Princess Dr, Phoenix, AZ | M32C+2H
 |  | [NAME] of [NAME] | 3215 S Auto Way, [NAME], AZ | 76VV+H6
 |  | AutoNation Dodge | 16406 N 26th Ave, Phoenix, AZ | JVPP+4C
 |  | AutoNation Ford | 8555 E [NAME] | J4J3+9F
 |  | AutoNation Honda | 1150 S Gilbert Rd., [NAME] AZ | 76Q5+G9
 |  | AutoNation Hyundai of Tempe | 8050 S Autoplex Loop, Tempe, AZ | 82VP+C4
 |  | AutoNation Parts Center | 1350 S Gilbert Rd., [NAME] AZ | 76R4+FV
 |  | Bently of North Scottsdale | 7171 E [NAME], Phoenix, AZ | M32C+2H
 |  | BMW North Scottsdale | 18018 N Scottsdale Rd, Phoenix, AZ | J3XF+PC
 |  | [NAME] | 999 W Bell Rd., Phoenix, AZ | [NAME]
 |  | [NAME] of Tempe | 7780 S Autoplex Loop, Tempe, AZ | 82XJ+6C
 |  | Courtesy Chevrolet | 1233 E Camelback Rd, Phoenix, AZ | GW5W+42
 |  | East Valley Nissan | 6354 E Test Dr., Phoenix AZ | 98P3+5R
 |  | Ferrari of North Scottsdale | 7171 E [NAME], Phoenix, AZ | M32C+2H
 |  | [NAME] | 9901 [NAME], Avondale, AZ | FP5G+V8
 |  | [NAME] | 550 E Drivers Way, [NAME], AZ | 76VV+99
 |  | Jaguar Land Rover of North Scottsdale | 18100 N Scottsdale Rd, Phoenix, AZ | J3XF+PC
 |  | Lamborghini of North Scottsdale | 7171 E [NAME], Phoenix, AZ | M32C+2H
 |  | [NAME] of North Scottdale | 7171 E [NAME], Phoenix, AZ | M32C+2H
 |  | Mercedes Benz of Gilbert | 3455 S Gilbert Rd., [NAME] | 76Q6+8J
 |  | Mercedes Benz of North Scottsdale | 18530 N Scottsdale Rd, Phoenix, AZ | M33F+49
 |  | [NAME] | 2323 W Bell Rd., Phoenix, AZ | JVQR+P4
 |  | Mini of North Scottsdale | [NAME], Phoenix, AZ | [NAME]
 |  | Mini of Tempe | 7855 S Test Dr, Tempe, AZ | 82WM+7W
 |  | National Enterprise Rental Car, Watkins Location | 1850 [NAME], Phoenix, AZ | CWG3+98
 |  | NATIONAL ENTERPRISE RENTAL CAR GATE, AIRPORT | 1805 E Sky Harbor Cir S., Phoenix, AZ | CXJ6+9F6
 |  | [NAME] | 9130 W Bell Rd., Phoenix, AZ | JPQW+JC
 |  | Pinnace Nissan | 7601 E [NAME]., Scottsdale, AZ | [NAME]
 |  | Right Honda | 7875 E [NAME]., Scottsdale, AZ | [NAME]
 |  | [NAME] | 5321 W Maryland Ave. Phoenix, AZ | GRJG+9C
 |  | Showcase Honda | 1333 E Camelback Rd., Phoenix, AZ | GW5W+9H
 |  | Tempe Dodge/Chrysler/Jeep | 7975 S Autoplex Loop, Tempe, AZ | 82WJ+2J
 |  | [NAME] | 8030 S Autoplex LoopTempe, AZ | 82RM+RR
 |  | [NAME] | 7755 S Autoplex Loop, Tempe, AZ | 82WM+G2
 |  | [NAME] Hub | 7970 S Autoplex Loop, Tempe, AZ | 82VH+MJ
 |  | [NAME] | 8585 E [NAME] | J4J3+7R
 |  | Volkswagon of North Scottsdale | 7001 E Chauncey Ln, Phoenix, AZ | M32C+2H
Spreadsheet: 198383d1354753343-pls-help-reduce-the-length-of-this-if-formula-tie
Sheet: Sheet3

 |  |  |  |  |  | <- this is your long formula |  |  |  |  | you data references
 |  |  |  |  |  |  |  |  |  |  | 5 | 9 | 2 | 1
 |  |  |  |  |  |  |  | This will be the helper column that will be hidden
 |  |  |  |  |  |  |  | i extracted all your formula one by one
 |  |  |  |  | <-this is the short formula that will refer to the helper column |  |  | look below for the formulas
Spreadsheet: 216768d1361884291-msgbox-to-pop-up-if-there-is-particular-text-in-cell-samplecf
Sheet: Sheet1

S.No. | EMPLOYEE  CODE | Name | Cost Centre | [NAME] | Location | Date of release | Date Of Joining | Appointment Letter Issue Date | Date Of Confirmation | Confirmation Letter Status | [NAME]? | Confirmation Letter Issue Date
1 | HOL0001 | ABC | corporate |  |  |  | 2009-07-01 00:00:00 |  | 2009-09-29 00:00:00 |  | Sent | 2009-12-28 00:00:00
2 | HOL0071 | DEF | corporate |  |  |  | 2013-06-01 00:00:00 |  | 2013-08-30 00:00:00 |  |  | 2013-11-28 00:00:00
3 |  | GHI |  |  |  |  | 2012-07-01 00:00:00 |  | 2012-09-29 00:00:00 |  |  | 2012-12-28 00:00:00
3 |  | GHI |  |  |  |  | 2012-07-01 00:00:00 |  | 2012-09-29 00:00:00 |  |  | 2012-12-28 00:00:00
3 |  | GHI |  |  |  |  | 2012-07-01 00:00:00 |  | 2012-09-29 00:00:00 |  |  | 2012-12-28 00:00:00
3 |  | GHI |  |  |  |  | 2012-07-01 00:00:00 |  | 2012-09-29 00:00:00 |  |  | 2012-12-28 00:00:00
3 |  | GHI |  |  |  |  | 2012-07-01 00:00:00 |  | 2012-09-29 00:00:00 |  |  | 2012-12-28 00:00:00
3 |  | GHI |  |  |  |  | 2012-07-01 00:00:00 |  | 2012-09-29 00:00:00 |  | Sent | 2012-12-28 00:00:00
3 |  | GHI |  |  |  |  | 2012-07-01 00:00:00 |  | 2012-09-29 00:00:00 |  |  | 2012-12-28 00:00:00
3 |  | GHI |  |  |  |  | 2012-07-01 00:00:00 |  | 2012-09-29 00:00:00 |  |  | 2012-12-28 00:00:00
3 |  | GHI |  |  |  |  | 2012-07-01 00:00:00 |  | 2012-09-29 00:00:00 |  |  | 2012-12-28 00:00:00
3 |  | GHI |  |  |  |  | 2012-07-01 00:00:00 |  | 2012-09-29 00:00:00 |  |  | 2012-12-28 00:00:00
3 |  | GHI |  |  |  |  | 2012-07-01 00:00:00 |  | 2012-09-29 00:00:00 |  |  | 2012-12-28 00:00:00
3 |  | GHI |  |  |  |  | 2012-07-01 00:00:00 |  | 2012-09-29 00:00:00 |  |  | 2012-12-28 00:00:00
3 |  | GHI |  |  |  |  | 2012-07-01 00:00:00 |  | 2012-09-29 00:00:00 |  | Sent | 2012-12-28 00:00:00
3 |  | GHI |  |  |  |  | 2012-07-01 00:00:00 |  | 2012-09-29 00:00:00 |  |  | 2012-12-28 00:00:00
3 |  | GHI |  |  |  |  | 2012-07-01 00:00:00 |  | 2012-09-29 00:00:00 |  |  | 2012-12-28 00:00:00
3 |  | GHI |  |  |  |  | 2012-07-01 00:00:00 |  | 2012-09-29 00:00:00 |  |  | 2012-12-28 00:00:00
3 |  | GHI |  |  |  |  | 2012-07-01 00:00:00 |  | 2012-09-29 00:00:00 |  |  | 2012-12-28 00:00:00
3 |  | GHI |  |  |  |  | 2012-07-01 00:00:00 |  | 2012-09-29 00:00:00 |  |  | 2012-12-28 00:00:00
Spreadsheet: 771163d1646467459-name-check-data-validation-formula-writer-data-extraction2
Sheet: Sheet2

 | Written by: [NAME] | Written by: [NAME]
1
2
3
4
5 | Written by: [NAME] | Written by: [NAME]
1
2
3
4
5 | Written by: [NAME] | Written by: [NAME]
1
2
3
4
5 |  | Missing data   / Written by : [NAME]
1
2
3
4
5 | Written by: [NAME] | Written by: [NAME]
1
2
3
4
5 |  | Missing data / Written by: [NAME]
Spreadsheet: 858129d1706886241-how-to-stop-count-once-a-certain-value-has-been-reached-example-result-2-personas-under-6-payments
Sheet: Example

Persona ID | Period | Absent | Pay
1234 | [NAME] | 1 | 324
12345 | [NAME] | 0 | 0
1234 | Feb20 | 1 | 5324
12345 | Feb20 | 0 | 0
1234 | Mar20 | 1 | 4234
12345 | Mar20 | 0 | 0
1234 | Apr20 | 1 | 234234
12345 | Apr20 | 0 | 0
1234 | May20 | 1 | 543543
12345 | May20 | 0 | 0
1234 | Jun20 | 1 | 2354
12345 | Jun20 | 0 | 0
1234 | Jul20 | 1 | 0
12345 | Jul20 | 0 | 0
1234 | Aug20 | 1 | 0
12345 | Aug20 | 0 | 0
1234 | Sep20 | 0 | 0
12345 | Sep20 | 0 | 645
1234 | Oct20 | 0 | 0
12345 | Oct20 | 0 | 0
1234 | Nov20 | 0 | 0
12345 | Nov20 | 0 | 0
1234 | Dec20 | 0 | 0
12345 | Dec20 | 0 | 534
1234 | Jan21 | 1 | 0
12345 | Jan21 | 0 | 4
1234 | Feb21 | 1 | 0
12345 | Feb21 | 0 | 5634
1234 | Mar21 | 0 | 0
12345 | Mar21 | 0 | 7645
1234 | Apr21 | 0 | 0
12345 | Apr21 | 0 | 0
1234 | May21 | 0 | 0
12345 | May21 | 0 | 0
1234 | Jun21 | 1 | 0
12345 | Jun21 | 0 | 0
1234 | [NAME] | 0 | 0
12345 | [NAME] | 1 | 6534
1234 | Aug21 | 1 | 0
12345 | Aug21 | 1 | 5465
1234 | Sep21 | 0 | 0
12345 | Sep21 | 1 | 6354
1234 | Oct21 | 0 | 654
12345 | Oct21 | 1 | 0
1234 | Nov21 | 0 | 6534
12345 | Nov21 | 1 | 6534
1234 | Dec21 | 0 | 0
12345 | Dec21 | 1 | 6435
1234 | [NAME] | 0 | 0
12345 | [NAME] | 1 | 6534
1234 | Feb22 | 0 | 0
12345 | Feb22 | 0 | 456
1234 | Mar22 | 0 | 0
12345 | Mar22 | 0 | 5436
1234 | Apr22 | 0 | 0
12345 | Apr22 | 0 | 543
1234 | May22 | 0 | 0
12345 | May22 | 0 | 765
1234 | [NAME] | 0 | 0
12345 | [NAME] | 0 | 0
1234 | [NAME] | 1 | 0
12345 | [NAME] | 0 | 0
1234 | Aug22 | 1 | 0
12345 | Aug22 | 1 | 54
1234 | Sep22 | 1 | 543
12345 | Sep22 | 1 | 543
1234 | Oct22 | 1 | 432
12345 | Oct22 | 1 | 543
1234 | Nov22 | 1 | 4234
12345 | Nov22 | 1 | 543
1234 | Dec22 | 1 | 5435
12345 | Dec22 | 1 | 4532
Persona ID | Result | AliGW | AliGW (again)
1234 | Under 6 payments
12345
Spreadsheet: 552731d1513739496-check-fields-across-multiple-sheets-and-collate-as-needed-s666-pq-check-fields-across-multiple-sheets-and-collate-as-needed
Sheet: Sheet4

Owner Name | Asset Number | Serial Number
[NAME] | TF8521 | T0Y2GE0994
[NAME] | TF1245 | T0Y2GE0989
[NAME] | TF1235 | T0Y2GE0988
[NAME] | TF9876 | T0Y2GE0990
[NAME] | TF0986 | T0Y2GE0991
[NAME] | TF8673 | T0Y2GE0993
[NAME] | TF1234 | T0Y2GE0987
[NAME] | TF1298 | T0Y2GE0992
Spreadsheet: 876513d1723214708-iferror-help-francoiscj1-blank-training-tracker_2024
Sheet: Summary

 | SUMMARY
 |  |  | 2024-01-01 00:00:00
 | COURSE | FREQUENCY | JAN | FEB | MAR | APR | MAY | JUN | JUL | AUG | SEP | OCT | NOV | DEC | COUNT | %
Spreadsheet: 705040d1605865624-sum-return-vrong-result-sum
Sheet: 18 Nov

 |  |  |  | [NAME] | data2
 |  |  |  | 134,33 | 50,92
 |  |  |  | 236,88 | 95,23
 |  |  |  | 193,23 | 100,44
 |  |  |  | 178,05 | 91,28
 |  |  |  | 236,77 | 97,66
 |  |  |  | 138,06 | 77,07
 |  |  |  | 189,06 | 87,73
 |  |  |  | 230,07 | 94,22
 |  |  |  | 153,52 | 81,59
 |  |  |  | 182,57 | 93,55
Spreadsheet: 38674d1236807195-if-function-help-675422
Sheet: Sheet1

Yes | Yes | V
 |  |  |  |  |  |  | B2
 |  |  |  |  |  | A2 | Yes | No | NA
 |  |  |  |  |  | Yes | V | I | -
 |  |  |  |  |  | No | - | A | -
 |  |  |  |  |  | NA | V | - | A
Spreadsheet: 727485d1617906639-formula-with-to-select-a-percentage-from-a-table-help
Sheet: Sheet1

Region % | Managers %
 | <-5% | -5% to 0% | 1% to 5% | >5%
<-5% | 0 | -0.1 | 0 | 0
-5% to 0% | -0.15 | -0.05 | 0.05 | 0.025
1% to 5% | -0.1 | 0 | 0.075 | 0.1
>5% | -0.05 | 0 | 0.1 | 0.2
Name | % Region | % Managers | [NAME]
Name 1 | 0.05 | 0.1
Name 2 | 0.1 | 0.05
Name 3 | -0.1 | 0.11
Spreadsheet: 130324d1322198672-looking-up-a-range-and-selecting-values-example-2
Sheet: Sheet1

PINCODE | Country | State | City |  |  |  | PIN_1 | PIN_2 | Country | State | City
110004 | India | Delhi | New Delhi |  |  |  | 210001 | 210003 | India | [NAME] | [NAME]
151002 | India | Delhi | Panipat |  |  |  | 331101 | 331110 | India | Wbengal | Calcutta
210004 |  |  |  |  |  |  | 110001 | 110095 | India | Delhi | New Delhi
331110 | India | Wbengal | Calcutta |  |  |  | 151001 | 151100 | India | Delhi | Panipat
Spreadsheet: 116240d1311693782-vlookup-with-conditions-book3
Sheet: Actuals

 |  |  | Actual | Actual | Actual
Account | Center | Acct Ctr | Jan 2011 | Feb 2011 | March 2011
111296 | 40 | 111296-40 | 7409.82 | 6563.26 | 6818.19
111297 | 40 | 111297-40 | 5377.9 | 4797.87 | 5124.44
111298 | 40 | 111298-40 | 0 | 5483.98 | 6115.59
111299 | 40 | 111299-40 | 1127.26 | 1034.05 | 0
111301 | 40 | 111301-40 | 48985.52 | 51829.71 | 20238.95
111302 | 40 | 111302-40 | 50205.05 | 43732.99 | 47140.45
111303 | 40 | 111303-40 | 30167.14 | 26525.51 | 29314.83
111304 | 40 | 111304-40 | 27549.23 | 23989.75 | 26074.64
111305 | 40 | 111305-40 | 1369.6 | 0 | 1174.23
Spreadsheet: 5137949f-6872-4176-94a5-8b1df10acd5f
Sheet: Sheet1

Licensed Organization: | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
Bingo License Number:
Address where tickets were sold:
Date:
Expenses
1 | Audits  and accounting services
2 | Safes
3 | Cash Registers
4 | Security Personnel
5 | Advertising for bingo
6 | Property taxes/assessments levied
 | on the location where bingo is
 | conducted
7 | Percent of rent where instant
 | bingo is conducted
8 | Total Expenses:
9 | Total Gross Receipts pertaining to
 | this invoice
10 | 6% of line 9
11 | Enter the smaller of line 8 or 10
 |  |  |  | (Please pay this amount)
 | List all serial numbers of all
 | instant bingo ticket deals used
 | to calculate total gross receipts
 | listed above:
Spreadsheet: 49680d1249018117-have-symbols-register-as-a-numerical-value-vlookup-demo
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  | Total
 |  | Mr A | a |  | a | a | a |  | a |  | b | a | 53
 |  | Mr B | b | c | b | b | a |  | b |  | b
 |  | Mr C | c |  |  | c |  |  | c | c | c | d
 |  | Mr D |  | d |  |  | d |  | d |  | d
 |  | a | 8
 |  | b | 5
 |  | c | 4
 |  | d | 6
Spreadsheet: 886917d1737022055-excel-formula-to-find-the-duplicate-route-sample
Sheet: Sheet1

ROUTE ID | REQUESTOR | POINT A | POINT B | Number of routes | Duplicated route ID |  |  | MY TRY 1 | MY TRY 2
1 | SALES | NEW YORK[C] | SAN JOSE
2 | SALES | LOS ANGELES | COLUMBUS
3 | SALES | CHICAGO | CHARLOTTE
4 | SALES | HOUSTON | INDIANAPOLIS[F]
5 | SALES | PHOENIX | SAN FRANCISCO[G]
6 | SALES | PHILADELPHIA[D] | SEATTLE
7 | SALES | SAN ANTONIO | DENVER[H]
8 | [NAME] | SAN DIEGO | OKLAHOMA CITY
9 | [NAME] | DALLAS | NASHVILLE[I]
10 | [NAME] | JACKSONVILLE[E] | [NAME]
11 | [NAME] | AUSTIN | EL PASO
12 | [NAME] | FORT WORTH | LAS VEGAS
13 | [NAME] | SAN JOSE | NEW YORK[C]
14 | [NAME] | COLUMBUS | LOS ANGELES
15 | [NAME] | CHARLOTTE | CHICAGO
16 | [NAME] | INDIANAPOLIS[F] | HOUSTON
17 | [NAME] | SAN FRANCISCO[G] | PHOENIX
18 | [NAME] | SEATTLE | PHILADELPHIA[D]
19 | [NAME] | CHICAGO | CHARLOTTE
20 | [NAME] | NEW YORK[C] | SAN JOSE
21 | [NAME] | NASHVILLE[I] | DALLAS
22 | [NAME] | [NAME] | JACKSONVILLE[E]
23 | [NAME] | SAN ANTONIO | DENVER[H]
24 | [NAME] | LAS VEGAS | FORT WORTH
Spreadsheet: 90818d1290540547-duplicate-values-example
Sheet: Sheet1

ID | NK | PP | BA | PNBR | TCG | TCP | OPUBPDV | OPUSPDV | RO | COMMENT | CREATED | BY | VS | DEPT. | E & G COLUMNS
4 | ×××××××××× | 147566/10 | [PHONE] | [PHONE]-131-7 | 100 | 1001 | 60 | 73.8 | ××××××××××× | ×××××××××××× | 2010-10-11 07:36:23 | ×××××× ×××××× | Item | sites/××××/××××/××××××/×××××/×××××××××××××× | [PHONE]-131-7 1001 |  | so if cells in column P are duplicate, copy the second duplicate instance (entire row) to sheet2 and ad prefix "D" to cell [NAME] (in sheet1), if possible do this for all 13000 rows in original worksheet
56 | ×××××××××× | 147983/10 | [PHONE] | [PHONE]-131-7 | 100 | 1001 | 60 | 73.8 | ××××××××××× | ×××××××××××× | 2010-10-19 17:11:17 | ×××××× ×××××× | Item | sites/××××/××××/××××××/×××××/×××××××××××××× | [PHONE]-131-7 1001