tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 698306d1601913275-if-statement-with-networkdays-error-ge-parts-logistics-tracker-we41
Sheet: Shipment Status Eskom

 | Shipment Status
Week | Delivered | Eskom : Await Shipment docs & POD | Eskom : Await Transport PO | Eskom : Awaiting CFA Collection | Eskom : Awaiting PO Req | Eskom : In Transit | GE : Parts Query | GE :Notification to be Sent | GE CoE : Await Collection | GE: ITR Manager | Total
WE01 | 0 | 4 | 27 | 10 | 28 | 4 | 2 | 0 | 0 | 0
WE02 | 1 | 4 | 11 | 20 | 16 | 21 | 2 | 0 | 0 | 0
WE03 | 16 | 3 | 18 | 14 | 9 | 20 | 2 | 8 | 0 | 0
WE04 | 35 | 3 | 20 | 11 | 17 | 4 | 2 | 15 | 0 | 0
WE05 | 47 | 1 | 18 | 4 | 34 | 3 | 2 | 6 | 0 | 0
WE06 | 58 | 6 | 16 | 11 | 16 | 13 | 2 | 5 | 0 | 0
WE07 | 63 | 20 | 12 | 0 | 17 | 12 | 2 | 4 | 0 | 0
WE08 | 83 | 9 | 13 |  | 22 | 7 | 3 | 11 | 0 | 0
WE09 | 83 | 9 | 13 |  | 22 | 7 | 3 | 11 | 0 | 0
WE10 | 86 | 13 | 19 | 12 | 14 | 3 | 3 | 3 | 0 | 0
WE11 | 94 | 7 | 24 | 14 | 19 | 1 | 3 | 0 | 0 | 0
WE12 | 94 | 7 | 24 | 13 | 19 | 2 | 3 | 7 | 0 | 0
WE13 | 100 | 7 | 15 | 38 | 7 | 6 | 3 | 0 | 0 | 0
WE14 | 107 | 13 | 9 | 20 | 5 | 26 | 4 | 3 | 0 | 0
WE15 | 107 | 13 | 9 | 20 | 6 | 26 | 4 | 3 | 0 | 0
WE16 | 118 | 13 | 18 | 13 | 5 | 22 | 5 | 3 | 0 | 0
WE17 | 120 | 17 | 26 | 14 | 1 | 17 | 5 | 5 | 0 | 0
WE18 | 128 | 13 | 25 | 10 | 4 | 19 | 6 | 1 | 0 | 0
WE19 | 160 | 3 | 19 | 14 | 6 | 6 | 2 | 0 | 0 | 0
WE20 | 160 | 8 | 18 | 19 | 1 | 6 | 3 | 0 | 0 | 0
WE21 | 173 | 2 | 14 | 16 | 7 | 3 | 5 | 4 | 0 | 0
WE22 | 173 | 2 | 14 | 16 | 7 | 3 | 5 | 4 | 0 | 0
WE23 | 173 | 2 | 14 | 16 | 7 | 3 | 5 | 4 | 0 | 0
WE24 | 171 | 3 | 13 | 12 | 9 | 7 | 2 | 0 | 0 | 0
WE25 | 172 | 6 | 21 | 9 | 1 | 6 | 3 | 0 | 0 | 0
WE26 | 174 | 4 | 21 | 9 | 1 | 6 | 3 | 0 | 0 | 0
WE27 | 181 | 7 | 20 | 5 | 29 | 3 | 6 | 0 | 0 | 0
WE28 | 181 | 12 | 25 | 5 | 33 | 3 | 0 | 0 | 0 | 0
WE29 | 191 | 7 | 22 | 0 | 26 | 13 | 0 | 9 | 0 | 0
WE30 | 205 | 13 | 6 | 29 | 15 | 10 | 0 | 4 | 0 | 0
WE31 | 216 | 8 | 11 | 21 | 11 | 14 | 0 | 4 | 0 | 0
WE32 | 216 | 9 | 16 | 22 | 11 | 14 | 0 | 1 | 0 | 0
WE33 | 223 | 7 | 20 | 22 | 8 | 17 | 0 | 4 | 0 | 0
WE34 | 229 | 5 | 24 | 22 | 6 | 20 | 0 | 4 | 0 | 0
WE35 | 244 | 2 | 25 | 25 | 5 | 20 | 0 | 3 | 0 | 0
WE36 | 244 | 2 | 25 | 25 | 5 | 20 | 0 | 3 | 0 | 0
WE37 | 264 | 2 | 9 | 5 | 4 | 27 | 0 | 1 | 0 | 0
WE38 | 288 | 0 | 14 | 0 | 6 | 10 | 0 | 0 | 0 | 0
WE39
WE40
WE41
WE42
WE43
WE44
WE45
WE46
WE47
WE48
WE49
WE50
WE51
WE52
Spreadsheet: 270670d1381581089-formula-for-multiple-matches-to-sum-result-from-another-column-into-another-sheet-justmeok_example_amended
Sheet: Consolidation of gl codes

 | Consolidation of previous years unused codes
OLD GL Code | NEW 2014 GL CODE
6-1274 | same
6-1275 | 6-1250
6-1276 | same
6-2231 | 6-2440
6-2232 | 6-2440
6-2233 | 6-2440
6-2234 | 6-2440
6-2235 | 6-2440
6-2236 | 6-2440
6-2265 | 6-2440
6-2270 | 6-2440
6-2272 | 6-2440
6-2273 | 6-2440
6-2275 | 6-2440
6-2505 | same
6-2520 | same
6-2525 | same
6-2530 | same
6-2540 | same
6-2550 | same
6-2560 | same
6-2565 | same
6-2570 | same
6-2598 | 5-2155
6-2599 | 6-2440
Spreadsheet: 77761d1278236209-copying-rows-and-cells-of-qualified-information-forum-10003
Sheet: Sheet2

Text 3 | Data3 | other stuff 3 | info 3
Text5 | Data5 | other stuff 5 | [NAME]
Text6 | Data6 | other stuff 6 | info 6
Text8 | Data8 | other stuff 8 | [NAME]
Text9 | Data9 | other stuff 9 | [NAME]
Text13 | Data13 | other stuff 13 | [NAME]
Text14 | Data14 | other stuff 14 | info 14
Text15 | Data15 | other stuff 15 | info 15
Text16 | Data16 | other stuff 16 | [NAME]
Text18 | Data18 | other stuff 18 | info 18
Text19 | Data19 | other stuff 19 | [NAME]
Text21 | Data21 | other stuff 21 | info 21
Text23 | Data23 | other stuff 23 | info 23
Spreadsheet: 124321d1318336719-list-all-items-that-match-a-particular-cell-list-values
Sheet: Sheet1

Game | Player Name |  |  | Game | Players
 |  |  |  | Baseball | BSB 1
Baseball | BSB 1 |  |  |  | BSB 2
Golf | [NAME] |  |  |  | BSB 3
Cricket | Ct1 |  |  |  | BSB 4
Golf | G2 |  |  |  | BSB 5
Golf | G3
Golf | G4
Baseball | BSB 2
Cricket | Ct2
Cricket | Ct3
Baseball | BSB 3
Baseball | BSB 4
Baseball | BSB 5
Golf | G5
Cricket | Ct4
Cricket | Ct5
Spreadsheet: 774906d1648721330-retrieve-a-value-in-another-sheet-based-on-conditions-test-dashboard-etaf
Sheet: SUBSCRIPTIONS

CID | BILLED | BILLING YEAR | START | END | ONE-TIME | REGULAR | TOTAL HTVA | TOTAL TVAC | STATUS | COMMENTS
 | Yes | 2022
 | Yes | 2022
 | Yes | 2022
 | No | 2023
 | No | 2023
 | No | 2024
 | No | 2024
 | No | 2025
 | No | 2025
 |  |  |  | n Cell "Clients!" N3
 | Yes | 2022
 | Yes | 2022 |  | > if Cell "Clients!" A3 matches with 1 or Multiple values in "Subscriptions!" Column A
 | No | 2023 |  | > discard the rows where "Subscriptions!" Column B = No
 | No | 2023 |  | > select the highest value in "Subscriptions!" Column C
 | No | 2024 |  | > paste that value in "Clients!" N3
 | No | 2024
 | No | 2025 |  | What's behind this idea?
 | No | 2025
 |  |  |  | > In Clients, I want to display the latest year in which I've billed a client.
 |  |  |  | > In Subscriptions, we see the subscriptions plans per client ID ("CID") and I mention whether I billed them Yes/No
 | Yes | 2022
 | Yes | 2022
 | Yes | 2022
 | Yes | 2021
 | Yes | 2021
 | Yes | 2021
 | Yes | 2021
 | Yes | 2021
 | No | 2025
 | Yes | 2021
 | Yes | 2021
 | Yes | 2021
 | No | 2023
 | No | 2024
 | No | 2025
 | Yes | 2021
 | Yes | 2021
 | No | 2022
 | No | 2023
 | No | 2024
 | No | 2025
 | Yes | 2021 |  |  |  |  |  |  | perçu
 | Yes | 2021 |  |  |  |  |  |  | perçu
 | Yes | 2022 |  |  |  |  |  |  | à percevoir
 | No | 2023 |  |  |  |  |  |  | à percevoir
 | No | 2024 |  |  |  |  |  |  | à percevoir
 | No | 2025 |  |  |  |  |  |  | à percevoir
Spreadsheet: 875308d1721904319-array-interval-between-repeating-integers-in-a-sequence-counting
Sheet: Logistics

 |  | 1 | 2 | 3 | 4
 | 0 | 1 | 0 | 0 | 0
 |  | 0 | 0 | 2 | 0
 |  | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0
 |  | 0 | 5 | 0 | 0
 |  | 0 | 0 | 0 | 6
 |  | 0 | 0 | 0 | 0
 |  | 2 | 0 | 0 | 0
 |  | 0 | 0 | 3 | 0
 |  | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0
 |  | 0 | 6 | 0 | 0
 |  | 0 | 0 | 0 | 1
 |  | 0 | 0 | 0 | 0
 |  | 3 | 0 | 0 | 0
 |  | 0 | 0 | 4 | 0
 |  | 0 | 0 | 0 | 0
 |  | 0 | 0 | 0 | 0
 |  | 0 | 1 | 0 | 0
 |  | 0 | 0 | 0 | 2
 |  | 0 | 0 | 0 | 0
 |  | 4 | 0 | 0 | 0
 |  | 0 | 0 | 5 | 0
 |  | 0 | 0 | 0 | 0
Spreadsheet: 849270d1699811557-how-to-copy-formulas-across-the-row-when-criteria-are-in-static-cells-sample-report-purchase-and-supplier-payments-v2
Sheet: Payment forecast 

 |  |  | Purchase  Month |  |  |  |  |  |  |  | Credit Terms |  |  | Item | Payment Month
 | 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 | 60 days | 30 days | Due Now |  | 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 | 2025-01-01 00:00:00 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00 | 2025-04-01 00:00:00 | 2025-05-01 00:00:00 | 2025-06-01 00:00:00 | 2025-07-01 00:00:00
 |  |  |  |  |  |  |  | 50000 |  |  | 0.25 | 0.6 | 0.15 | Stock & Purchase - PT A |  |  |  |  |  |  | ??? | ????
 |  |  |  |  |  |  |  |  |  |  | 0.2 | 0.5 | 0.3 | Stock & Purchase - PT B
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11250 | 76875 | 181875 | 216250 | 147500
Spreadsheet: 874843d1721354765-excel-formula-to-find-multiple-variables-example1
Sheet: Sheet2

Permit ID | Permit | Company Name | Vehicle REGO |  | Company | Vehicles
1114104 | A | [NAME] | 922WQB |  | [NAME] | 2 | Count how many times "Joe Trump Co", has a vehicle that has a Permit A and a Permit B
1114129 | A | [NAME] | 922WQB |  | [NAME] | 1 | Count how many times "Don Biden", has a vehicle that has a Permit A and a Permit B
1114144 | A | [NAME] | 919TDX
5445644 | A | [NAME] | 919TDX
5247875 | A | [NAME] | 919TDX
5050106 | A | [NAME] | XQ47US
5050107 | A | [NAME] | [NAME]
6339311 | A | [NAME] | 922WQB
6894016 | B | [NAME] | 922WQB
7448721 | B | [NAME] | 919TDX
8003421 | B | [NAME] | 919TDX
8558129 | B | [NAME] | 919TDX
9112837 | B | [NAME] | 919TDX
11886377 | B | [NAME] | XQ47US
12441085 | B | [NAME] | XQ47US
12995793 | B | [NAME] | XQ47US
13550501 | B | [NAME] | XQ47US
14659917 | B | [NAME] | XQ04NO
Spreadsheet: 042ce9a9-7600-459b-a1e1-2ce7b1002719
Sheet: Sheet1

Table 1--Soybeans:  Annual U.S. supply and disappearance | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13
 | Area |  | Yield | Supply |  |  |  |  | Use
Year beginning | Planted | Harvested |  | Beginning |  |  |  |  | Crush | Seed, feed |  |  | Ending
September 1 |  |  |  | stocks | Production | Imports | Total |  |  | & residual | Exports | Total | stocks
 | Million acres |  | Bu./acre |  |  |  |  |  | --------------------------------------------------Million bushels--------------------------------------------------
2011/12 | 75.046 | 73.776 | 41.93130557362828 | 215.013 | 3093.524 | 16.1352383836245 | 3324.672238383625 |  | 1703 | 90.4538823855737 | 1361.848355998051 | 3155.302238383625 | 169.37
2012/131 | 77.198 | 76.104 | 39.61681383370125 | 169.37 | 3014.998 | 25 | 3209.368 |  | 1660 | 94.36799999999994 | 1330 | 3084.368 | 125
2013/142 | 77.728 | 76.918 | 44.46293455368054 | 125 | 3420 | 15 | 3560 |  | 1695 | 120 | 1450 | 3265 | 295
Soybeans:  Quarterly U.S. supply and disappearance
 |  |  |  | Supply |  |  |  |  | Use
 |  |  |  | Beginning |  |  |  |  | Crush, seed |  |  |  | Ending
 |  |  |  | stocks | Production | Imports | Total |  | & residual |  | Exports | Total | stocks
2011/12 |  |  |  |  |  |  |  |  | --------------------------------------------------Million bushels--------------------------------------------------
September-November |  |  |  | 215.013 | 3093.524 | 2.8441205983722 | 3311.381120598372 |  | 516.5955746809718 |  | 424.9005459174001 | 941.4961205983718 | 2369.885
December-February |  |  |  | 2369.885 | --- | 3.1416916574442 | 2373.026691657445 |  | 523.9961548514923 |  | 474.5425368059524 | 998.5386916574446 | 1374.488
March-May |  |  |  | 1374.488 | --- | 5.3307780169035 | 1379.818778016903 |  | 453.9034791290034 |  | 258.4502988879 | 712.3537780169034 | 667.465
June-August |  |  |  | 667.465 | --- | 4.818648110904601 | 672.2836481109047 |  | 298.958673724106 |  | 203.9549743867986 | 502.9136481109047 | 169.37
Total |  |  |  |  | 3093.524 | 16.1352383836245 | 3324.672238383625 |  | 1793.453882385574 |  | 1361.848355998051 | 3155.302238383624
2012/13
September-November |  |  |  | 169.37 | 3014.998 | 4.2863493307698 | 3188.65434933077 |  | 602.9483867095553 |  | 619.5449626212146 | 1222.49334933077 | 1966.161
December-February |  |  |  | 1966.161 | --- | 4.7181036423045 | 1970.879103642304 |  | 441.9112322404433 |  | 530.9478714018612 | 972.8591036423045 | 998.02
March-May |  |  |  | 998.02 | --- | 7.8351491690241 | 1005.855149169024 |  | 446.2922887515574 |  | 125.0548604174667 | 571.3471491690241 | 434.508
Total to date |  |  |  |  | 3014.998 | 16.8396021420984 | 3201.207602142098 |  | 1491.151907701556 |  | 1275.547694440543 | 2766.699602142098
1 Estimated. 2 Forecast.
Sources: USDA, National Agricultural Statistics Service, Crop Production and Grain Stocks and U.S. Department of Commerce, U.S. Census Bureau,
Foreign Trade Statistics.
Last update: | 2013-07-15 08:32:54.660000
Spreadsheet: 149698d1334087698-pictures-determined-by-cells-celltopic
Sheet: Picture

 | overall it will take the information from Sheet!"Info" and will create pictures here. |  |  |  |  |  |  |  |  | EXAMPLES!
 |  |  |  |  |  |  |  |  |  | I know how to do everything but createing the Pictures
 | column A will inster a picture in this box |  |  | Column C will insert formated Price Here |  |  |  | column A will inster a picture in this box |  |  | Column C will insert formated Price Here
 |  |  |  | column B will insert formatted Text here
 | column A will inster a picture in this box |  |  |  |  |  |  | column A will inster a picture in this box
 | column A will inster a picture in this box |  |  |  |  |  |  | column A will inster a picture in this box
 | column A will inster a picture in this box |  |  |  |  |  |  | column A will inster a picture in this box
Spreadsheet: 134851d1325676174-index-match-book2
Sheet: Sheet1

 | Skill | Site | Channel | 2012-01-01 00:00:00
 | US_Pri | DAK | Phone | 500 | 500 | 500 | 500 | 500 | 500
 | Kindle | DAK | Phone | 500 | 500 | 500 | 500 | 500 | 500
 | MP3 | DAK | Phone | 500 | 500 | 500 | 500 | 500 | 500
 | US_Pri | SUT | Chat | 100 | 100 | 100 | 100 | 100 | 100
 | Kindle | SUT | Chat | 100 | 100 | 100 | 100 | 100 | 100
 | MP3 | SUT | Chat | 100 | 100 | 100 | 100 | 100 | 100
 | US_Pri | HYD | [NAME] | 300 | 300 | 300 | 300 | 300 | 300
 | Kindle | HYD | [NAME] | 300 | 300 | 300 | 300 | 300 | 300
 | MP3 | HYD | [NAME] | 300 | 300 | 300 | 300 | 300 | 300
Spreadsheet: 138272d1327590680-pls-help-to-get-o-p-in-another-sheet-ef17_depot1
Sheet: REQUIRED OUTPUTSUM-DEC-11

REQUIRED OUTPUT
DO Date | Qty | Qty1 |  |  | DO Date | Qty | Qty1
2011-12-01 00:00:00 | 27 | 78 |  |  | 2011-12-01 00:00:00 |  |  | <--formulae, copy down
2011-12-02 00:00:00 | 609 | 153 |  | formula-->
2011-12-03 00:00:00 | 84 | 0 |  | copy down
2011-12-04 00:00:00 | 0 | 0
2011-12-05 00:00:00 | 0 | 59
2011-12-06 00:00:00 | 459 | 53
2011-12-07 00:00:00 | 110 | 121
2011-12-08 00:00:00 | 441 | 102
2011-12-09 00:00:00 | 189.5 | 49
2011-12-10 00:00:00 | 723 | 83
2011-12-11 00:00:00 | 0 | 0
Spreadsheet: 868309d1715028832-how-to-change-the-size-of-an-array-in-a-formula-random-rows
Sheet: Random Rows

Random Numbers | a | b | c | d | e | f | g | h
Spreadsheet: ccac9ab2-b56e-4617-89a4-e150d2e09c18
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
42244143 | 2014-07-10 19:30:22 | ALLIES | 1 | 6 | 3 | 1149185 | kellogs_10 | 7429 | mediterranean | 1941-06-15 | 1941-06-17 | [NAME] | [NAME]
42244533 | 2014-07-10 20:03:47 | AXIS | 0 | 3 | 6 | 1149185 | kellogs_10 | 7429 | mediterranean | 1941-06-15 | 1941-06-17 | [NAME] | [NAME]
42355343 | 2014-07-18 19:48:13 | ALLIES | 1 | 6 | 3 | 1606804 | player1606804 | 7365 | mediterranean | 1942-06-14 | 1942-06-14 | [NAME] via the Coastal Road | Retraite britannique
42355485 | 2014-07-18 20:02:44 | AXIS | 0 | 3 | 6 | 1606804 | player1606804 | 7365 | mediterranean | 1942-06-14 | 1942-06-14 | [NAME] via the Coastal Road | Retraite britannique
Spreadsheet: 56779d1256864405-linking-worksheets-705314-linking-worksheets
Sheet: Sheet2

Month | Expected | Mortgage | L&G | MC | BHI | Month | Actual | Mortgage | L&G | MC | BHI
Jan |  | 0 |  |  |  | January
Feb |  | 0 |  |  |  | February
Mar |  | 0 |  |  |  | March
Apr |  | 0 |  |  |  | April
May |  | 0 |  |  |  | May
Jun |  | 0 |  |  |  | June
Jul |  | 0 |  |  |  | July
Aug |  | 0 |  |  |  | August
Sep |  | 200000 |  |  |  | September
Oct |  | 1011500 |  |  |  | October
Nov |  | 1198000 |  |  |  | November
Dec |  | 0 |  |  |  | December
Conquest
Spreadsheet: 799425d1665075415-leave-tracker-with-conditional-formatting-for-days-off-sample-file
Sheet: Sheet1

 | Week 1 |  |  |  |  |  |  | Week 2 |  |  |  |  |  |  |  |  |  |  |  | Week 1 |  |  |  |  |  |  | Week 2
Team | 2022-09-01 00:00:00 | 2022-09-02 00:00:00 | 2022-09-03 00:00:00 | 2022-09-04 00:00:00 | 2022-09-05 00:00:00 | 2022-09-06 00:00:00 | 2022-09-07 00:00:00 | 2022-09-08 00:00:00 | 2022-09-09 00:00:00 | 2022-09-10 00:00:00 | 2022-09-11 00:00:00 | 2022-09-12 00:00:00 | 2022-09-13 00:00:00 | 2022-09-14 00:00:00 |  |  |  | Emp Name | Team | 2022-09-01 00:00:00 | 2022-09-02 00:00:00 | 2022-09-03 00:00:00 | 2022-09-04 00:00:00 | 2022-09-05 00:00:00 | 2022-09-06 00:00:00 | 2022-09-07 00:00:00 | 2022-09-08 00:00:00 | 2022-09-09 00:00:00 | 2022-09-10 00:00:00 | 2022-09-11 00:00:00 | 2022-09-12 00:00:00 | 2022-09-13 00:00:00 | 2022-09-14 00:00:00
Team 1 |  |  |  |  | Off | Off | Off |  |  |  |  |  | Off | Off |  |  |  | Emp 1 | Team 1
Team 2 | Off | Off |  |  |  |  |  | Off | Off | Off |  |  |  |  |  |  |  | Emp 2 | Team 2
Team 3 | Off |  |  |  |  | Off | Off | Off |  |  |  |  |  | Off |  |  |  | Emp 3 | Team 3
Team 4 |  |  |  | Off | Off |  |  |  |  | Off | Off | Off |  |  |  |  |  | Emp 4 | Team 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Emp 5 | Team 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Emp 6 | Team 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Emp 7 | Team 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Emp 8 | Team 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Emp 9 | Team 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Emp 10 | Team 3
Spreadsheet: 33613d1230070663-vlookup-and-matching-2-criteria-match-help
Sheet: Data

 | 10 | 10 | 10 | 10 | 11 | 11 | 11 | 11
 | Gross Long | Gross Short | Gross | Net | Gross Long | Gross Short | Gross | Net
AAA | 1 | 0.5 | 1.5 | 0.5 | 2 | 0.1 | 2.1 | 1.9
BBB | 2 | 0 | 2 | 2 | 2 | 0.1 | 2.1 | 1.9
CCC | 5 | 2.5 | 7.5 | 2.5 | 2 | 0.1 | 2.1 | 1.9
DDD | 0.5 | 0 | 0.5 | 0.5 | 2 | 0.1 | 2.1 | 1.9
Spreadsheet: 57211fed-2fad-436c-91f3-28e05adf2218
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
YOLK | Test | YOLK | [NAME], IgE | [NAME], IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube: Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m.-8 p.m., Saturday; 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
YOLK | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
YOLK | Result | YOLK | [NAME], IgE | [NAME], IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 6107-7 | Egg yolk Ab.IgE:ACnc:Pt:Ser:Qn:
Spreadsheet: 0f0bada8-f7bf-4700-b3b9-8c06a40e3e27
Sheet: Sheet1

 |  | PAY SCHEDULE
 |  | 2011-2012
Pay Period Begins | Pay Period Ends | Turn in Timesheet | Pay Day
Sunday | Saturday | [NAME]. by 3 pm | Friday
2010-04-24 00:00:00 | 2010-05-07 00:00:00 | 2010-05-10 00:00:00 | 2010-05-20 00:00:00
2010-05-08 00:00:00 | 2010-05-21 00:00:00 | 2010-05-24 00:00:00 | 2010-06-03 00:00:00
2010-05-22 00:00:00 | 2010-06-04 00:00:00 | 2010-06-07 00:00:00 | 2010-06-17 00:00:00
2011-06-05 00:00:00 | 2011-06-18 00:00:00 | 2011-06-21 00:00:00 | 2011-07-01 00:00:00
2011-06-19 00:00:00 | 2011-07-02 00:00:00 | 2011-07-05 00:00:00 | 2011-07-15 00:00:00
2011-07-03 00:00:00 | 2011-07-16 00:00:00 | 2011-07-19 00:00:00 | 2011-07-29 00:00:00
2011-07-17 00:00:00 | 2011-07-30 00:00:00 | 2011-08-02 00:00:00 | 2011-08-12 00:00:00
2011-07-31 00:00:00 | 2011-08-13 00:00:00 | 2011-08-16 00:00:00 | 2011-08-26 00:00:00
2011-08-14 00:00:00 | 2011-08-27 00:00:00 | 2011-08-30 00:00:00 | 2011-09-09 00:00:00
2011-08-28 00:00:00 | 2011-09-10 00:00:00 | 2011-09-13 00:00:00 | 2011-09-23 00:00:00
2011-09-11 00:00:00 | 2011-09-24 00:00:00 | 2011-09-27 00:00:00 | 2011-10-07 00:00:00
2011-09-25 00:00:00 | 2011-10-08 00:00:00 | 2011-10-11 00:00:00 | 2011-10-21 00:00:00
2011-10-09 00:00:00 | 2011-10-22 00:00:00 | 2011-10-25 00:00:00 | 2011-11-04 00:00:00
2011-10-23 00:00:00 | 2011-11-05 00:00:00 | 2011-11-08 00:00:00 | 2011-11-18 00:00:00
2011-11-06 00:00:00 | 2011-11-19 00:00:00 | 2011-11-22 00:00:00 | 2011-12-02 00:00:00
2011-11-20 00:00:00 | 2011-12-03 00:00:00 | 2011-12-06 00:00:00 | 2011-12-16 00:00:00
2011-12-04 00:00:00 | 2011-12-17 00:00:00 | 2011-12-20 00:00:00 | 2011-12-30 00:00:00
2011-12-18 00:00:00 | 2011-12-31 00:00:00 | 2011-01-03 00:00:00 | 2011-01-13 00:00:00
2011-01-01 00:00:00 | 2011-01-14 00:00:00 | 2011-01-17 00:00:00 | 2011-01-27 00:00:00
2011-01-15 00:00:00 | 2011-01-28 00:00:00 | 2011-01-31 00:00:00 | 2011-02-10 00:00:00
2011-01-29 00:00:00 | 2011-02-11 00:00:00 | 2011-02-14 00:00:00 | 2011-02-24 00:00:00
2011-02-12 00:00:00 | 2011-02-25 00:00:00 | 2011-02-28 00:00:00 | 2011-03-09 00:00:00
2011-02-26 00:00:00 | 2011-03-10 00:00:00 | 2011-03-13 00:00:00 | 2011-03-23 00:00:00
2011-03-11 00:00:00 | 2011-03-24 00:00:00 | 2011-03-27 00:00:00 | 2011-04-06 00:00:00
2011-03-25 00:00:00 | 2011-04-07 00:00:00 | 2011-04-10 00:00:00 | 2011-04-20 00:00:00
2011-04-08 00:00:00 | 2011-04-21 00:00:00 | 2011-04-24 00:00:00 | 2011-05-04 00:00:00
2011-04-22 00:00:00 | 2011-05-05 00:00:00 | 2011-05-08 00:00:00 | 2011-05-18 00:00:00
2011-05-06 00:00:00 | 2011-05-19 00:00:00 | 2011-05-22 00:00:00 | 2011-06-01 00:00:00
2011-05-20 00:00:00 | 2011-06-02 00:00:00 | 2011-06-05 00:00:00 | 2011-06-15 00:00:00
Spreadsheet: 839807d1692237830-simple-way-to-calculate-ltm-results-for-quarterly-data-that-isnt-contiguous-test
Sheet: Sheet1

1Q21A | 1Q22A | 1Q23A |  | 2Q21A | 2Q22A | 2Q23A |  | 3Q21A | 3Q22A |  | 4Q21A | 4Q22A
1 | 5 | 9 |  | 2 | 6 | 10 |  | 3 | 7 |  | 4 | 8
 | Desired Result | [NAME] | FORMULATEXT
1Q22
2Q22
3Q22
4Q22
1Q23
2Q23
Spreadsheet: 825935d1681660002-sumif-accumulative-and-by-month-book2-1-1-
Sheet: Report 

Car
Computer | 460 | 55 | 20 | 20 | 20 | 20 | 20 | 40 | 40 | 40 | 40 | 20 | 20
Table | 110 | 14 | 14 | 14 | 14 | 14 | 14 | 10 | 10 | 10 | 10 | 10 | 10
TV | 0 | 0 | 0 | 0 | 0 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4
 |  |  |  |  |  |  |  |  |  |  | 44135
 | * Date will change with Stroll Bar
 | * Column B to show accumulated balance
 | * For example, to show accumulated for each type, till 31/08/2021 (Sum of Column B to Column U in raw data tab)
 | *For the yellow part, to show the the sum base on Raw Data tab. (For example Column C = sumif Column V in Raw Data Tab etc etc)
11
 |  |  |  | For this case, I wan the sum up all the Column B: Column K
 |  |  |  | I have put the colour (refer Raw Data) for better understanding
Spreadsheet: 675262d1588223650-problem-using-index-match-with-merged-cells-example1686
Sheet: Data Export

 |  | Product 1 |  | Product 2
 |  | Actual | Budget | Actual | Budget
Total Revenue | Jan 2020 | 543913.04 | 572385.51 | 416411.55 | 422233.86
 | Feb 2020 | 583327.2000000001 | 572117.5199999998 | 418954.54 | 469771.51
 | Mar 2020 | 564916.3999999999 | 597963.2999999998 | 401063.2 | 462496.85
Total Expenses | Jan 2020 | 469758.7100000001 | 477012.6000000001 | 359691.87 | 360958.52
 | Feb 2020 | 492760.01 | 482095.7999999999 | 359311 | 385429.92
 | Mar 2020 | 494126.93 | 499025.2 | 356235.75 | 390407.8
Spreadsheet: 110969d1307508882-sum-of-weigthings-must-be-within-100-test2
Sheet: Sheet1

No | Action | Weighting | Score
1 | Listen to teachers | 0.2941176470588235 | 5
2 | Line up properly | 0.4705882352941176 | 8
3 | Carry out job assigned properly | 0.1764705882352941 | 3
4 | Helpful | 0.05882352941176471 | 1
 |  | 0
 |  | 0
 |  | 0
 |  | 0
 |  | 0
Total |  | 1 | 17