tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 7905a9a2-45bf-4ac1-9fa3-26a4194dd4a1
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
 | Decision Variables |  | Parameters
Index |  | Index
Period 1 | X1 | Period 1 | a1
Period 2 | X2 | Period 2 | a2
Period 3 | X3 | Period 3 | a3
Period 4 | X4 | Period 4 | a4
Period 5 | X5 | Period 5 | a5
Period 6 | X6 | Period 6 | a6
Period 1 | Y1 | Period 1 | s1
Period 2 | Y2 | Period 2 | s2
Period 3 | Y3 | Period 3 | s3
Period 4 | Y4 | Period 4 | s4
Period 5 | Y5 | Period 5 | s5
Period 6 | Y6 | Period 6 | s6
 |  | Period 1 | t1
 |  | Period 2 | t2
 |  | Period 3 | t3
 |  | Period 4 | [NAME]
 |  | Period 5 | t5
 |  | Period 6 | t6
 |  | Period 1 | u1
 |  | Period 2 | u2
 |  | Period 3 | u3
 |  | Period 4 | u4
 |  | Period 5 | u5
 |  | Period 6 | u6
 |  | Period 1 | l1
 |  | Period 2 | l2
 |  | Period 3 | l3
 |  | Period 4 | [NAME]
 |  | Period 5 | l5
 |  | Period 6 | l6
 |  | Constant | d
 |  | Constant | p
 |  |  | d(i) = d * X(i)
 |  |  | p(i) = p * a(i)
 | Constraints
 | For i = Period 1, Period 2, Period 3, Period 4, Period 5 and Period 6
 | Y(i) = [d * X(i) + p * a(i)] / s(i) / t(i)
 | d * l(1) <= Y(1) <= d * u(1)
 | d * [l(1) + l(2)] <= Y(2) <= d * [u(1) + u(2)]
 | d * [l(1) + l(2)+ l(3)] <= Y(3) <= d * [u(1) + u(2)+ u(3)]
 | d * [l(1) + l(2)+ l(3)+ l(4)] <= Y(4) <= d * [u(1) + u(2)+ u(3)+ u(4)]
 | d * [l(1) + l(2)+ l(3)+ l(4)+ l(5)] <= Y(5) <= d * [u(1) + u(2)+ u(3)+ u(4)+ u(5)]
 | d * [l(1) + l(2)+ l(3)+ l(4)+ l(5)+ l(6)] <= Y(6) <= d * [u(1) + u(2)+ u(3)+ u(4)+ u(5)+ u(6)]
 | G(1) = Y(1) - Y(2)
 | G(2) = Y(2) - Y(1)
 | G(3) = Y(2) - Y(3)
 | G(4) = Y(3) - Y(2)
 | G(5) = Y(4) - Y(3)
 | G(6) = Y(3) - Y(4)
 | G(7) = Y(5) - Y(4)
 | G(8) = Y(4) - Y(5)
 | G(9) = Y(6) - Y(5)
 | G(10) = Y(5) - Y(6)
 | D(1) >= G(1)
 | D(2) >= G(2)
 | D(3) >= G(3)
 | D(4) >= G(4)
 | D(5) >= G(5)
 | [NAME]) >= G(6)
 | D(7) >= G(7)
 | D(8) >= G(8)
 | D(9) >= G(9)
 | D(10) >= G(10)
 | Objecitve
 | Minimize sum of all i D(i)
Spreadsheet: 678531d1589953045-dependent-drop-down-and-index-match-multiple-logic-dependent-drop-down-will-change-table-result
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | LIST
 |  |  |  |  |  |  |  |  |  | Company 1 |  |  | DROP DOWN |  | Company 1
 | POWER PLANT | CAPACITY, MW |  | # OF UNITS | [NAME] | CONNECTION | OPERATOR | FUEL |  | Company 2
 |  | INSTALLED | DEPENDABLE |  |  |  |  |  |  | Company 3
 | Coal 1 U1 | 135 | 120 | 1 | America | Grid | Company 1 | Coal |  |  |  |  |  | RESULT | Installed | dependable | Power Plant | Connection | Fuel
 | Coal 2 U2 | 135 | 120 | 1 | America | Embedded | Company 1 | Coal
 | Coal 3 U3 | 135 | 120 | 1 | America | Grid | Company 1 | Coal |  |  |  |  |  | 1
 | Hydro 1 U1 | 116 | 105 | 1 | Canada | Grid | Company 2 | Water |  |  |  |  |  | 2
 | Hydro 2 U2 | 116 | 105 | 1 | Canada | Embedded | Company 3 | Water |  |  |  |  |  | 3
 | Wind 1 U1 | 150 | 135 | 1 | China | Grid | Company 1 | Wind
 | Wind 2 U2 | 150 | 135 | 1 | China | Embedded | Company 3 | Wind
 | Geo | 135 | 120 | 1 | Australia | Grid | Company 1 | Geo
Spreadsheet: 758179d1638722436-index-formulas-to-rearrange-from-vertical-to-horizontal-tf16400504_win32
Sheet: DataAnalysis

 | Worksheet Names |  | This worksheet creates recipe worksheet names that can be referenced in formulas in this workbook. A horizontal table is used for creating the ingredients and measurements master list worksheets.   The ingredients and measurements for all recipes selected in the Meal Planner are then aggregated into a single table. That single table is then ranked for sorting, then sorted and all measurements for a single ingredient concatenated.   Those sorted and concatenated ingredients are used to create the shopping list in the shopping list worksheet. |  | Worksheet name row 3 and vertical table in column B and C can generate 20 worksheet names, which limits the recipe planner to holding no more than 20 recipes in total. The Meal planner accepts up to 1 recipe per day, therefore, the shopping list is limited to 7 recipes. After 7, the shopping list will not work. |  | The aggregated, ranked, and sorted tables will hold a maximum of 300 ingredients and their corresponding measurements. After 300, the shopping list will not be accurate.
 | Do not erase row 3!
 |  | 'Spinach Feta Pizza | 'My New Recipe | ' | ' | ' | ' | ' | ' | ' | ' | ' | ' | ' | ' | ' | ' | ' | ' | ' | '
 | This is an empty row |  |  |  |  |  |  |  |  | start row
 | Table below generates worksheet names used to list all ingredients from recipes selected in Meal Planner worksheet. |  |  |  |  |  |  |  |  | last entry
 |  |  |  |  |  |  | Table below aggregates all recipe ingredients and measurements from the meal planner selected set of recipes |  |  | Table below ranks all ingredients and their corresponding measurements. |  |  |  |  |  | Table below takes all ranked ingredients and measurements and searches for duplicates. All duplicate ingredients have their measurements concatenated. This list is how the Shopping List is generated.
 | recipe name | worksheet name |  | Do not edit or delete the tables to the left |  |  | Amounts | aggregated ingredients list |  | Tie break | Rank | amounts | ingredients | Num |  | [NAME] | amounts | ingredients | hdr | results | # of occurences | Text
Spreadsheet: 150867d1334699526-v-lookup-in-pivot-table-pivot-table-and-v-lookup
Sheet: Pivot

Route | cust_code | Total
1 | V11 | 6090.68
 | V12 | 10882.87
 | V21 | 8536.04
1 Total |  | 25509.59
2 | 1214 | 888.35
 | 2251 | 702.4
 | 7194 | 1459.97
 | 7293 | 4077.28
 | 8161 | 1121.19
 | 8162 | 2268.28
 | 8466 | 314.8
 | V31 | 12398.3
2 Total |  | 23230.57
3 | V19 | 9214.73
 | V38 | 9566.48
 | V7 | 11641.76
3 Total |  | 30422.97
4 | 1444 | 1102.44
 | 1522 | 568.44
 | 1537 | 508.3
 | 1540 | 394.32
 | 2064 | 872.08
 | 2080 | 1820.7
 | 4411 | 1035.3
 | SL926 | 744.79
Spreadsheet: 840844d1693045663-parking-charge-parking-charges
Sheet: data

Date | Parking Ticket No. | Plate Number | In | Out | Rate | Total Hours | Succeeding hrs | Total Amount |  |  | Criteria | Amount | Notes | TIME | TIME | OUT
2023-08-15 00:00:00 | 184364 | FIT222 | 04:00:00 | 06:01:00 |  |  |  |  |  |  | Vehicle/Motorcycle | 45 | 3 Hours | 06:01:00
2023-08-15 00:00:00 | 184365 | NBX9785 | 21:00:00 | 06:00:00 |  |  |  |  |  |  | Succeeding hour | 10 | 1 Hour
2023-08-15 00:00:00 | 100782 | BBG547 | 21:00:00 | 08:00:00 |  |  |  |  |  |  | Overnight Parking | 250 | [NAME] 11:00 PM - 6:00 AM | 23:00:00 | 00:00:00 | 06:00:00
2023-08-15 00:00:00 | 100677 | ME20008 | 09:37:00 | 11:58:00 |  |  |  |  |  |  | Lost Ticket | 225 | Plus regular parking rate
2023-08-15 00:00:00 | 100780 | MGE206 | 11:35:00 | 18:35:00 |  |  |  |  |  |  | Unvalidated ticket | 150 | Plus regular parking rate
2023-08-15 00:00:00 | 100790 | BJB119 | 23:00:00 | 06:00:00
2023-08-15 00:00:00 | 100789 | WES139 | 21:00:00 | 07:00:00
2023-08-15 00:00:00 | 100612 | MER2572 | 00:00:00 | 07:00:00
2023-08-15 00:00:00 | 100633 | MFL3889 | 06:00:00 | 08:00:00
2023-08-15 00:00:00 | 100632 | MGS8383 | 05:30:00 | 10:29:00
2023-08-15 00:00:00 | 100600 | MEX6319 | 06:01:00 | 10:29:00
Spreadsheet: 288847d1389318133-consolidate-multiple-worksheets-into-one-reference-cover-sheet-excel-forum
Sheet: 2666

Recipient Created Tax Invoice
TO: | worker |  |  |  |  |  | FROM: | Work
 | worker |  |  |  |  |  |  | 123 Work
 | address |  |  |  |  |  |  | Work
 | WA | 6055 |  |  |  |  |  | WA | 6666
 |  |  |  |  |  |  |  |  |  |  | This is a new sheet that needs to be added to the cover sheet
 | ABN: | abn |  |  |  |  |  | ABN: | 55 555 555 555
 | Vendor # | 2666
 | APPRENTICE DETAILS |  |  |  |  |  |  | Date: | 2014-01-10 00:00:00
 | Name: |  | [NAME] |  |  |  |  | Invoice #
 | Employee Number: |  | 12123 |  |  |  |  | FN Start
 | Apprenticeship: |  | [NAME] (3YR)
 | G/L Code: |  | 2118
 | 12609#20076
 | Date | Ordinary Hours | Ordinary $ Total | Travel $ Total | OT15 Hours | OT15 $ | OT20 Hours | OT20 $ | Meal | TOTAL
 | 2013-12-11 00:00:00 | 8 | 172.4 | 13.12 |  |  |  |  |  | 185.52
 | 2013-12-12 00:00:00 | 8 | 172.4 | 13.12 |  |  |  |  |  | 185.52
 | 2013-12-13 00:00:00 | 8 | 172.4 | 13.12 |  |  |  |  |  | 185.52
 |  |  |  |  |  |  |  |  |  | 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
 | Less Daily Subsidy | CTF |  |  |  |  |  |  |  | 4.3269
 |  | ABBTF |  |  |  |  |  |  |  | 1.45383
 |  | ABN DISCOUNTS |  |  |  |  |  |  |  | 0
 | Net Invoice |  |  |  |  |  |  |  |  | 550.7792700000001
 | GST |  |  |  |  |  |  |  |  | 55.07792700000002
 | Total payable inclusive of GST |  |  |  |  |  |  |  |  | 562.3407300000001
Spreadsheet: 0ccaae9e-db44-4dfe-bc19-e27e664d1424
Sheet: Sheet1

1926 - 15th Coupe Aéronautique [NAME] | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
Starting Point: | Wilryck, Antwerp, Belgium |  |  |  |  | 1926-05-30 00:00:00
 |  | Pilots Name |  | Co-Pilots Name
Rank | Country | Last | First | Last | First | BalloonName | LandingPlace | Distance km | Time
1 | USA | Orman | [NAME] | [NAME] | [NAME] | Goodyear III | Solvesborg/Sweden | 861 | 16:37:00
2 | USA | Gray | Capt. [NAME] | Johnston | Lt. [NAME] | US Army |  | 599 | 12:00:00
3 | BEL | Demuyter | Ernest | Valete | (Lt.) | Belgica | Cuxhafen/Germany | 438 | 05:00:00
4 | BEL | [NAME] | [NAME] | [NAME] | [NAME] | Prince Leopold |  | 298
5 | GBR | [NAME] | Capt. Percival | Berry | [NAME] | Miramar |  | 169
6 | SPA | Molas | Maj. M. | Frados-Pena | A. | Cpt. Penaranda |  | 153
7 | SUI | Bachmann | Dr. O. | Maag | [NAME] | Helvetia II | Hartskamp/Netherlands | 142
8 | FRA | Bienaime | [NAME] | Ravaine | Georges | La Picardie |  | 102
9 | GBR | Baldwin | (Sq.Lead.) | Dunville | [NAME] | Banshee III |  | 93
10 | GBR | Maeger | Cpt.G.F. | Steff | M.H. | Bee |  | 69
11 | BEL | Matton | Capt. H. | Charmart | Lt. A. | Aerostiere I |  | 66
12 | ITA | Pirazzoli | Lt. A. | Pisani | Lt. A. | Aerostiere III |  | 36
13 | ITA | Tombezi | . | Pomarici | Maj.cav. G. | Campione III |  | 33
14 | ITA | Ilari | [NAME]. [NAME] | Sivieri | [NAME]. G. | Campione IV |  | 31
15 | USA | Boettner | J.A. | [NAME] | H.W. | Akron N.A.A. |  | no res.
16 | FRA | Cormier | Georges |  |  | Anjou |  | no start
17 | FRA | [NAME] | [NAME] | Arnoud |  | Vieilles Tiges |  | no start
18 | SPA | Gamindon | A. Mat. | [NAME] | [NAME] | Jesu [NAME] |  | ???
Spreadsheet: 804257d1667974592-retrieve-the-hourly-rate-for-the-name-of-the-person-in-the-original-cell-for-correct-year-sample
Sheet: Data Sheet

Resources | 2022 | 2022 [NAME] | 2023 | 2023 Salary | 2024 | 2024 Salary | 2025 | 2025 [NAME]
Jes |  |  |  | 137351.5 |  | 137352.5 |  | 137353.5
Change Manager |  | 123682 |  | 100000 |  | 100000 |  | 100000
Business Analyst |  |  |  | 90000 |  | 90000 |  | 90000
Project Manager |  |  |  | 140000 |  | 140000 |  | 140000
Vendor |  | 46000 |  | 46000 |  | 46000 |  | 46000
[NAME] |  | 123682 |  | 85000 |  | 85000 |  | 85000
Person 7 |  |  |  | 90000 |  | 90000 |  | 90000
Person 8 |  |  |  | 110000 |  | 110000 |  | 110000
Person 9
Person 10
Person 11
Person 12
Person 13
Person 14
Person 15
Person 16
Person 17
Person 18
Person 19
Person 20
Person 21
Person 22
Person 23
Person 24
Person 25
Spreadsheet: 92847d1292379452-complicated-search-and-verify-article-verify
Sheet: Style Plan

Style Plan
Style# | Color | Price
785617 | BLUE JAY | 89.5
785617 | BLACK | 89.5
785617 | PURPLE ORCHID | 89.5
785618 | BLACK | 34.5
785618 | STEM | 34.5
785618 | BLUE WINK | 34.5
785620 | PURPLE ORCHID | 69.5
785620 | BLACK | 69.5
785621 | BLACK | 79.5 | 89.5
Spreadsheet: 211011d1359638074-help-row-into-column-another-sheet-dee2
Sheet: CLASS

Sl.No | Name | Sub | FA(a) | FA(b) | FA(a+b) | SA
1
 |  | [NAME]
 |  | Eng
 |  | Mat
 |  | Sci
 |  | Soc
2
 |  | [NAME]
 |  | Eng
 |  | Mat
 |  | Sci
 |  | Soc
3
 |  | [NAME]
 |  | Eng
 |  | Mat
 |  | Sci
 |  | Soc
4
 |  | [NAME]
 |  | Eng
 |  | Mat
 |  | Sci
 |  | Soc
5
 |  | [NAME]
 |  | Eng
 |  | Mat
 |  | Sci
 |  | Soc
6
 |  | [NAME]
 |  | Eng
 |  | Mat
 |  | Sci
 |  | Soc
7
 |  | [NAME]
 |  | Eng
 |  | Mat
 |  | Sci
 |  | Soc
8
 |  | [NAME]
 |  | Eng
 |  | Mat
 |  | Sci
 |  | Soc
9
 |  | [NAME]
 |  | Eng
 |  | Mat
 |  | Sci
 |  | Soc
10
 |  | [NAME]
 |  | Eng
 |  | Mat
 |  | Sci
 |  | Soc
11
 |  | [NAME]
 |  | Eng
 |  | Mat
 |  | Sci
 |  | Soc
12
 |  | [NAME]
 |  | Eng
 |  | Mat
 |  | Sci
 |  | Soc
13
 |  | [NAME]
 |  | Eng
 |  | Mat
 |  | Sci
 |  | Soc
14
 |  | [NAME]
 |  | Eng
 |  | Mat
 |  | Sci
 |  | Soc
15
 |  | [NAME]
 |  | Eng
 |  | Mat
 |  | Sci
 |  | Soc
16
 |  | [NAME]
 |  | Eng
 |  | Mat
 |  | Sci
 |  | Soc
17
 |  | [NAME]
 |  | Eng
 |  | Mat
 |  | Sci
 |  | Soc
18
 |  | [NAME]
 |  | Eng
 |  | Mat
 |  | Sci
 |  | Soc
19
 |  | [NAME]
 |  | Eng
 |  | Mat
 |  | Sci
 |  | Soc
20
 |  | [NAME]
 |  | Eng
 |  | Mat
 |  | Sci
 |  | Soc
21
 |  | [NAME]
 |  | Eng
 |  | Mat
 |  | Sci
 |  | Soc
22
 |  | [NAME]
 |  | Eng
 |  | Mat
 |  | Sci
 |  | Soc
23
 |  | [NAME]
 |  | Eng
 |  | Mat
 |  | Sci
 |  | Soc
24
 |  | [NAME]
 |  | Eng
 |  | Mat
 |  | Sci
 |  | Soc
25
 |  | [NAME]
 |  | Eng
 |  | Mat
 |  | Sci
 |  | Soc
26
 |  | [NAME]
 |  | Eng
 |  | Mat
 |  | Sci
 |  | Soc
27
 |  | [NAME]
 |  | Eng
 |  | Mat
 |  | Sci
 |  | Soc
28
 |  | [NAME]
 |  | Eng
 |  | Mat
 |  | Sci
 |  | Soc
29
 |  | [NAME]
 |  | Eng
 |  | Mat
 |  | Sci
 |  | Soc
30
 |  | [NAME]
 |  | Eng
 |  | Mat
 |  | Sci
 |  | Soc
31
 |  | [NAME]
 |  | Eng
 |  | Mat
 |  | Sci
 |  | Soc
32
 |  | [NAME]
 |  | Eng
 |  | Mat
 |  | Sci
 |  | Soc
33
 |  | [NAME]
 |  | Eng
 |  | Mat
 |  | Sci
 |  | Soc
34
 |  | [NAME]
 |  | Eng
 |  | Mat
 |  | Sci
 |  | Soc
35
 |  | [NAME]
 |  | Eng
 |  | Mat
 |  | Sci
 |  | Soc
36
 |  | [NAME]
 |  | Eng
 |  | Mat
 |  | Sci
 |  | Soc
37
 |  | [NAME]
 |  | Eng
 |  | Mat
 |  | Sci
 |  | Soc
38
 |  | [NAME]
 |  | Eng
 |  | Mat
 |  | Sci
 |  | Soc
39
 |  | [NAME]
 |  | Eng
 |  | Mat
 |  | Sci
 |  | Soc
40
 |  | [NAME]
 |  | Eng
 |  | Mat
 |  | Sci
 |  | Soc
41
 |  | [NAME]
 |  | Eng
 |  | Mat
 |  | Sci
 |  | Soc
42
 |  | [NAME]
 |  | Eng
 |  | Mat
 |  | Sci
 |  | Soc
43
 |  | [NAME]
 |  | Eng
 |  | Mat
 |  | Sci
 |  | Soc
44
 |  | [NAME]
 |  | Eng
 |  | Mat
 |  | Sci
 |  | Soc
45
 |  | [NAME]
 |  | Eng
 |  | Mat
 |  | Sci
 |  | Soc
Spreadsheet: 698081d1601729341-auto-populating-rolling-month-calendar-using-drop-down-lists-ef1407a_calendar-any-month-start
Sheet: CALENDAR

 | SELECT YEAR |  |  |  | 2020 |  |  |  | SELECT MONTH |  |  |  | September |  |  |  | 1st INSP DATE & FREQ wks |  |  |  | 2020-09-11 00:00:00 |  | 6
 | ENTER MOT DATE |  |  |  | 2020-09-30 00:00:00 |  |  |  | 1st SERVICE DATE |  |  |  | 2020-09-22 00:00:00 |  |  |  | SELECT SERVICE FREQ mths |  |  |  | 6
 | SAFETY INSPECTION / SERVICE / MOT SCHEDULE
 | Mon | [NAME] | Weds | Thurs | Fri | Sat | Sun |  | Mon | [NAME] | Weds | Thurs | Fri | Sat | Sun |  | Mon | [NAME] | Weds | Thurs | Fri | Sat | Sun
 | Mon | [NAME] | Weds | Thurs | Fri | Sat | Sun |  | Mon | [NAME] | Weds | Thurs | Fri | Sat | Sun |  | Mon | [NAME] | Weds | Thurs | Fri | Sat | Sun
 | Mon | [NAME] | Weds | Thurs | Fri | Sat | Sun |  | Mon | [NAME] | Weds | Thurs | Fri | Sat | Sun |  | Mon | [NAME] | Weds | Thurs | Fri | Sat | Sun
 | Mon | [NAME] | Weds | Thurs | Fri | Sat | Sun |  | Mon | [NAME] | Weds | Thurs | Fri | Sat | Sun |  | Mon | [NAME] | Weds | Thurs | Fri | Sat | Sun
Spreadsheet: 670393d1585854086-vlookup-with-3-creteria-in-different-tabs-verweise-test
Sheet: Basis

Account Name | Country Headquater | Lead Country initaliztion | Account Industry | [NAME] | [NAME] | Team Size | SEARCH A | SEARCH B | SERACH C | OUTPUT
Kunde Y | Germany | DK | Construction, Materials and Natural Resources | 10,001+ employees | 10+ B | 25 | High Value | 2.Warm Lead | 3. SAL
Kunde Y | Germany | DK | Construction, Materials and Natural Resources | 10,001+ employees | 10+ B | 25 | Strategic | 3. Hot | 2. MQL
Kunde Y | Germany | DK | Construction, Materials and Natural Resources | 10,001+ employees | 10+ B | 25 | Low Value | 1.Cold Lead | 3. SAL
Spreadsheet: 843393d1695242576-excel-formula-for-a-simple-spreadsheet-sample-ibf
Sheet: Sheet1

PENDING SCHEDULING | DRUG | NEW- NEEDS TO BE WORKED | DRUG | IN PROCESS | DRUG | DATE | PENDING SCHEDULING | NEW- NEEDS TO BE WORKED | IN PROCESS
abc |  | abc |  | abc |  | 2023-09-20 00:00:00
def |  | def |  | def
 |  | hij |  | hij
 |  |  |  | klm
Spreadsheet: 71604d1272372511-average-if-problem-excel-2003-example-for-forum
Sheet: Data

Roll No. | Forename | Surname | Gender | Form | Year | ETH | FSM Eligible | In care | Joiner | G&T | VU | SEN | Poss. [NAME]. | Actual att. | Att. % | Negative | Positive | Lates | Exclusions | No. Holiday Sessions | Monitoring
29091 | [NAME] | Example | F | 7E | 7 | WBRI |  |  |  |  |  |  | 110 | 86 | 78.18 | 2 | 6 | 5 | 0
29023 | [NAME] | Example | M | 7W | 7 | WBRI |  |  |  |  |  |  | 110 | 88 | 80 | 2 | 1 | 0 | 0
29009 | [NAME] | Example | M | 7E | 7 | WBRI |  |  |  |  |  | A | 110 | 89 | 80.91 | 8 | 5 | 0 | 0
29059 | [NAME] | Example | M | 7M | 7 | WBRI |  |  |  |  |  |  | 110 | 89 | 80.91 | 2 | 0 | 2 | 0
29001 | [NAME] | Example | M | 7M | 7 | WBRI |  |  |  | Y |  |  | 110 | 92 | 83.64 | 3 | 6 | 0 | 0
29022 | Harleigh | Example | F | 7S | 7 | WBRI |  |  |  |  |  |  | 110 | 94 | 85.45 | 9 | 0 | 6 | 0
29044 | Sean | Example | M | 7W | 7 | WBRI | Y |  |  |  |  | A | 110 | 94 | 85.45 | 5 | 0 | 27 | 0
29070 | Sumar | Example | M | 7W | 7 | MOTH | Y |  |  |  | Y |  | 110 | 94 | 85.45 | 3 | 3 | 3 | 0
29098 | Jaime | Example | F | 7M | 7 | WBRI |  |  |  |  |  |  | 110 | 94 | 85.45 | 8 | 0 | 0 | 0
29043 | Izaak | Example | M | 7W | 7 | WBRI | Y |  |  |  |  |  | 110 | 95 | 86.36 | 5 | 0 | 2 | 0
29085 | [NAME] | Example | F | 7E | 7 | WBRI |  |  |  |  |  |  | 110 | 95 | 86.36 | 2 | 6 | 1 | 0
29045 | Connor | Example | M | 7S | 7 | WBRI | Y |  |  |  |  | A | 110 | 96 | 87.27 | 29 | 4 | 3 | 0
29057 | Jon | Example | M | 7W | 7 | WBRI |  |  |  |  |  | A | 110 | 97 | 88.18 | 11 | 1 | 2 | 0
29068 | Conna | Example | M | 7W | 7 | WBRI |  |  |  |  |  |  | 110 | 97 | 88.18 | 2 | 2 | 0 | 0
29056 | [NAME] | Example | F | 7E | 7 | WBRI | Y |  |  |  |  |  | 110 | 98 | 89.09 | 7 | 6 | 3 | 0
29032 | [NAME] | Example | M | 7M | 7 | WBRI |  |  |  |  |  |  | 110 | 100 | 90.91 | 1 | 5 | 0 | 0
29047 | [NAME] | Example | M | 7W | 7 | WBRI | Y |  |  |  |  |  | 110 | 100 | 90.91 | 0 | 3 | 1 | 0
29078 | Siani | Example | F | 7W | 7 | WBRI |  |  |  |  |  | P | 110 | 100 | 90.91 | 4 | 2 | 1 | 0
29093 | Bethany | Example | F | 7M | 7 | WBRI | Y |  |  |  |  |  | 110 | 100 | 90.91 | 1 | 5 | 1 | 0
29103 | Jessica | Example | F | 7M | 7 | WBRI |  |  |  | Y |  |  | 110 | 100 | 90.91 | 0 | 7 | 0 | 0
29031 | [NAME] | Example | M | 7W | 7 | WBRI | Y |  |  |  |  |  | 110 | 102 | 92.73 | 3 | 1 | 11 | 0
29061 | [NAME] | Example | M | 7M | 7 | WBRI | Y |  |  |  |  |  | 110 | 102 | 92.73 | 4 | 0 | 1 | 0
29076 | [NAME] | Example | F | 7W | 7 | WBRI | Y |  |  |  |  |  | 110 | 102 | 92.73 | 5 | 1 | 2 | 0
29092 | Adon | Example | M | 7S | 7 | WBRI | Y |  |  |  |  | P | 110 | 102 | 92.73 | 9 | 9 | 3 | 0
29094 | Ellie | Example | F | 7E | 7 | WBRI |  |  |  |  |  |  | 110 | 102 | 92.73 | 8 | 5 | 0 | 0
29011 | [NAME] | Example | M | 7W | 7 | WBRI |  |  |  |  |  | A | 110 | 103 | 93.64 | 3 | 3 | 0 | 0 | 4
Spreadsheet: 105015d1302510849-use-conditional-format-cicihk_cf_2
Sheet: Sheet1

MAR 2011
Site Code | Site Name | Completed by | Completed by | Use Conditional Format
Step 1
AIA | [NAME], 183 ELECTRIC ROAD, NORTH POINT |  |  | if c4 is blank = red if d4 is blank = red
Step 2
AIA | [NAME], 183 ELECTRIC ROAD, NORTH POINT | ok |  | if c4 is ok  = orange if d4 is blank = red
Step 3
AIA | [NAME], 183 ELECTRIC ROAD, NORTH POINT | ok | ok | if d4 is ok = no format what is the formula if d4 is ok, then c4 also = no format???
Spreadsheet: 62814d1263826645-excel-2007-conditional-formatting-test
Sheet: All Tasks

Group | Issue | Task | Task Code | MRB task reference | UP | Interval | Cal | 2nd UP/Cal | 2nd UP/FC | Cal | 2nd UP/FH | Cal | Due Cal | M/Hrs | Skill | Tools | 2nd AGE | Access | Zone | DUE |  | 21
S&P | 5 |  | FNC |  | [NAME] | 150 [NAME] cy |  |  |  |  |  |  | 0 |  |  |  |  |  |  | #N/A
S&P | 5 |  | FNC |  | Cal | 24 |  |  |  |  |  |  | 24 |  |  |  |  |  |  | 0
S&P | 5 |  | LUB |  | Cal | 6 |  |  |  |  |  |  | 6 |  |  |  |  |  |  | 0
S&P | 5 |  | DET |  | [NAME] | 25 Pod CY |  |  |  |  |  |  | 0 |  |  |  |  |  |  | #N/A
Spreadsheet: 493872d1481921733-copy-data-while-skipping-rows-stat-sample
Sheet: Teams

 |  | Bye? (mark with "x") |  |  | How Many Byes?
Test Team | 5
Test Team | 5
Test Team | 5
Test Team | 5
Test Team | 5
Test Team | 5
Test Team | 5
Test Team | 5
Test Team | 5
Test Team | 5
Test Team | 5
Test Team | 5
Test Team | 5
Test Team | 5
Spreadsheet: 6427f158-5c54-484f-9afe-3bd8e4dfe47f
Sheet: Daftar-Diklat

KODE | JENJANG | NAMA PROGRAM DIKLAT ONLINE
B.01.001 | SD | Panca Indera
B.01.002 | SD | Sistem Reproduksi Manusia
B.02.001 | SMP | Sistem Syaraf Pada Manusia
B.02.002 | SMP | Pewarisan Sifat
B.03.001 | SMA | Sel Molekuler
F.01.001 | SD | Konsep [NAME]
F.01.002 | SD | Konsep Tata Surya
F.02.001 | SMP | Konsep Energi Listrik
F.02.002 | SMP | “Aplikasi Konsep  [NAME] (EKG)  [NAME] Pendengaran
F.03.001 | SMA | [NAME]
K.02.001 | SMP | [NAME]
K.03.001 | SMA | [NAME]
K.03.002 | SMA | Kesetimbangan Dalam Larutan
U.01.001 | UMUM | [NAME] dengan [NAME]
U.01.002 | SD | TEMATIK SD
U.01.003 | SMP | IPA TERPADU
Spreadsheet: 728929d1618815272-count-duplicate-values-if-they-appear-in-the-same-month-example-1
Sheet: Sheet1

Customer Email Address |  |  | Date |  |  |  |  |  | Multiple Subscription
Email Address T |  |  | 2020-12-01 00:00:00
Email Address T |  |  | 2020-12-04 00:00:00
Email Address T |  |  | 2020-12-25 00:00:00
Email Address T |  |  | 2021-01-08 00:00:00
Email Address V |  |  | 2021-01-28 00:00:00
[NAME] |  |  | 2021-02-12 00:00:00
Email Address X |  |  | 2021-01-16 00:00:00
Email Address Y |  |  | 2021-02-05 00:00:00
Email Address Y |  |  | 2021-02-12 00:00:00
Email Address Z |  |  | 2021-01-06 00:00:00
Email Address Z |  |  | 2021-02-06 00:00:00