tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 43226d1241796796-price-list-lookup-price-list-lookup
Sheet: Sheet1

 | [NAME] | 1000 | 1300 | 1600 | 1900 | 2200 | 2500 | 2800 | 3100 | 3400 | 3700 | 4000 | 4300 | 4600 | 4900 | 5200
 | 850 | 850-1000 | 850-1300 | 850-1600 | 850-1900 | 850-2200 | 850-2500 | 850-2800 | 850-3100 | 850-3400 | 850-3700 | 850-4000 | 850-4300 | 850-4600 | 850-4900 | 850-5200
 | 1150 | 1150-1000 | 1150-1300 | 1150-1600 | 1150-1900 | 1150-2200 | 1150-2500 | 1150-2800 | 1150-3100 | 1150-3400 | 1150-3700 | 1150-4000 | 1150-4300 | 1150-4600 | 1150-4900 | 1150-5200
 | 1450 | 1450-1000 | 1450-1300 | 1450-1600 | 1450-1900 | 1450-2200 | 1450-2500 | 1450-2800 | 1450-3100 | 1450-3400 | 1450-3700 | 1450-4000 | 1450-4300 | 1450-4600 | 1450-4900 | 1450-5200
 | 1750 | 1750-1000 | 1750-1300 | 1750-1600 | 1750-1900 | 1750-2200 | 1750-2500 | 1750-2800 | 1750-3100 | 1750-3400 | 1750-3700 | 1750-4000 | 1750-4300 | 1750-4600 | 1750-4900 | 1750-5200
 | 2050 | 2050-1000 | 2050-1300 | 2050-1600 | 2050-1900 | 2050-2200 | 2050-2500 | 2050-2800 | 2050-3100 | 2050-3400 | 2050-3700 | 2050-4000 | 2050-4300 | 2050-4600 | 2050-4900 | 2050-5200
 | 2350 | 2350-1000 | 2350-1300 | 2350-1600 | 2350-1900 | 2350-2200 | 2350-2500 | 2350-2800 | 2350-3100 | 2350-3400 | 2350-3700 | 2350-4000 | 2350-4300 | 2350-4600 | 2350-4900 | 2350-5200
 | 2650 | 2650-1000 | 2650-1300 | 2650-1600 | 2650-1900 | 2650-2200 | 2650-2500 | 2650-2800 | 2650-3100 | 2650-3400 | 2650-3700 | 2650-4000 | 2650-4300 | 2650-4600 | 2650-4900 | 2650-5200
 | 2950 | 2950-1000 | 2950-1300 | 2950-1600 | 2950-1900 | 2950-2200 | 2950-2500 | 2950-2800 | 2950-3100 | 2950-3400 | 2950-3700 | 2950-4000 | 2950-4300 | 2950-4600 | 2950-4900 | 2950-5200
 | 3250 | 3250-1000 | 3250-1300 | 3250-1600 | 3250-1900 | 3250-2200 | 3250-2500 | 3250-2800 | 3250-3100 | 3250-3400 | 3250-3700 | 3250-4000 | 3250-4300 | 3250-4600 | 3250-4900 | 3250-5200
 | 3550 | 3550-1000 | 3550-1300 | 3550-1600 | 3550-1900 | 3550-2200 | 3550-2500 | 3550-2800 | 3550-3100 | 3550-3400 | 3550-3700 | 3550-4000 | 3550-4300 | 3550-4600 | 3550-4900 | 3550-5200
 | 3850 | 3850-1000 | 3850-1300 | 3850-1600 | 3850-1900 | 3850-2200 | 3850-2500 | 3850-2800 | 3850-3100 | 3850-3400 | 3850-3700 | 3850-4000 | 3850-4300 | 3850-4600 | 3850-4900 | 3850-5200
 |  | [NAME] | Height | expected
 |  | 10 | 10 | 850-1000
 |  | 850 | 1000 | 850-1000
 |  | 1100 | 900 | 1150-1300
 |  | 5200 | 3850 | 3850-5200
 |  | 6000 | 4000 | BLANK
Spreadsheet: 96551d1295943746-how-to-get-multiple-values-when-using-only-a-single-cell-reference-in-a-formula-excel-help
Sheet: Insersheet

Car | toyota |  |  |  | toyota
 |  |  |  |  | bmw
Part number | Part definition
1 | a |  |  |  |  |  | The idea is to select the the car model, and after that the result which te formula gives is all the parts related to the the car model. In this examble it could be Toyota or bwm, but there a lot of those systems in my real case. The data for the Part numb and part def. comes from the Data-sheet Can you please help me how to do this? THANK YOU. The wanted result is on this sheet.
2 | b
3 | c
4 | a
5 | b
6 | c
7 | a
8 | b
9 | c
Spreadsheet: 785461d1656428482-if-and-if-or-sample-data
Sheet: Sheet1

Type | Item | Description | FINAL
Home | Bed |  | No Notes
Home | Sofa |  | No Notes
Home | Chair | FOR HALL | Type A
Home | Table | dining only | Type B
Home | Fireplace |  | No Notes
Home | Coffee table | 2 Coffe tables needed | Type B
Home | Patio | FULL SET | Type A
Vehicle | Honda |  | Not Applicable
Vehicle | Toyota |  | Not Applicable
Vehicle | Kia |  | Not Applicable
Sport | [NAME] |  | Not Applicable
Sport | Bowl |  | Not Applicable
Sport | [NAME] |  | Not Applicable
Spreadsheet: 879771d1727331953-capture-data-from-multiple-sheets-sample-data-new-
Sheet: Master

 |  | BU2424 | BU2424 | BU2424 | BU2525 | BU2525 | BU2525
PN | Supplier | Total | JJ | MM+CC | Total | JJ | MM+CC
151 | 102 LLL |  | 350 | 0 |  | 200 | 0 |  |  | =SUMPRODUCT((INDIRECT("'"&$A5&"*'!B20:B50")=$B5)*(ISNUMBER(SEARCH(INDIRECT("'"&$A5&"*'!C20:C50"),G$4)))*(INDIRECT("'"&$A5&"*'!D18:O18")=G$3)*(INDIRECT("'"&$A5&"*'!D20:O50")
171 | 103 MMM |  | 50 | 0 |  | 100 | 0
192 | 104 NNN |  | 40 | 40 |  | 50 | 10
312 | 105 OOO |  | 10 | 80 |  | 80 | 80
312 | 120 PPP |  | 20 | 70 |  | 10 | 50
312 | 122 QQQ |  | 100 | 60 |  | 100 | 10
*Numbers in RED are the places that I wanted to insert formula.
Spreadsheet: 210359d1359451668-conditional-formatting-example-2_cf-1
Sheet: Sheet1

2013-01-29 00:00:00
Surname | First Name | Pay No. | Date Attended | Attendance Sheet Completed & Filed | [NAME]? | Competency Attained | Date to Attain Full Competence
Example | [NAME] | 1 | 2013-01-24 00:00:00 | YES | YES | YES | 2013-02-07 00:00:00
Example | [NAME] | 2 | 2013-01-25 00:00:00 | NO | YES | YES | 2013-02-08 00:00:00
Example | [NAME] | 3 | 2013-01-26 00:00:00 | YES | YES | YES | 2013-02-09 00:00:00
Example | [NAME] | 4 | 2013-01-27 00:00:00 | YES | YES | YES | 2013-02-10 00:00:00
Example | [NAME] | 5 | 2013-01-28 00:00:00 | no | no | YES | 2013-02-11 00:00:00
Example | [NAME] | 6 | 2013-01-29 00:00:00 | no | no | no | 2013-02-12 00:00:00
Example | [NAME] | 7 | 2013-01-30 00:00:00 | YES | YES | YES | 2013-02-13 00:00:00
Example | [NAME] | 8 | 2013-01-15 00:00:00 | YES | YES | YES | 2013-01-29 00:00:00
Example | [NAME] | 9 | 2013-02-01 00:00:00 | YES | YES | YES | 2013-02-15 00:00:00
Example | [NAME] | 10 | 2013-02-02 00:00:00 | YES | YES | YES | 2013-02-16 00:00:00
Example | [NAME] | 11 | 2013-02-03 00:00:00 | YES | YES | YES | 2013-02-17 00:00:00
Example | [NAME] | 12 | 2013-01-15 00:00:00 | YES | YES | YES | 2013-01-29 00:00:00
Example | [NAME] | 13 | 2013-02-05 00:00:00 | YES | YES | YES | 2013-02-19 00:00:00
Example | [NAME] | 14 | 2013-02-06 00:00:00 | YES | YES | YES | 2013-02-20 00:00:00
Spreadsheet: 132802d1323948590-excel-2007-match-and-insert-data-in-two-workbook-ind-and-match-with-helpers-columns
Sheet: Sheet1

Ref no 1 | Ref No 2 | Date | Time | Hits | Com ID1 | Address | Com ID2 | Ref type | Code 01 | Type
0052020 | 93171258 | 13-JUN-11 | 19:19:35 | 0 | 44011 |  |  | SMT | 357662011527680 | PRE
9669617 | 71258 | 13-JUN-11 | 19:56:37 | 7 | 44011 |  | 44011 | IN | 357662011527680 | PRE
99931 | 91796696 | 13-JUN-11 | 19:56:55 | 271 | 44011 |  | 44011 | OUT | 357662011527680 | PRE
82594 | 171258 | 13-JUN-11 | 20:01:22 | 5 | 44011 |  | 44011 | IN | 357662011527680 | PRE
9752082 | 999317 | 13-JUN-11 | 20:01:54 | 458 | 44011 |  | 44011 | IN | 357662011527680 | PRE
71258 | 9669617 | 13-JUN-11 | 20:10:33 | 429 | 44011 |  | 44011 | OUT | 357662011527680 | PRE
9589936 | 999317 | 13-JUN-11 | 21:52:17 | 307 | 44033 |  | 44033 | IN | 357662011527680 | PRE
89936534 | 71258 | 13-JUN-11 | 22:02:42 | 157 | 60543 |  | 30416 | IN | 357662011527680 | PRE
9993171 | 789892 | 13-JUN-11 | 22:10:45 | 65 | 1011 |  | 44011 | OUT | 357662011527680 | PRE
9936534 | 999317 | 13-JUN-11 | 22:13:30 | 561 | 44011 |  | 44011 | IN | 357662011527680 | PRE
9993171 | 789892 | 13-JUN-11 | [NAME] | 1012 | 44011 |  | 44011 | OUT | 357662011527680 | PRE
89936534 | 71258 | 13-JUN-11 | 22:02:42 | 157 | '21538' |  | 30416 | IN | 357662011527680 | PRE
9993171 | 789892 | 13-JUN-11 | 22:10:45 | 65 | '21538' |  | 44011 | OUT | 357662011527680 | PRE
9936534 | 999317 | 13-JUN-11 | 22:13:30 | 561 | '21538' |  | 44011 | IN | 357662011527680 | PRE
9993171 | 789892 | 13-JUN-11 | [NAME] | 1012 | '21538' |  | 44011 | OUT | 357662011527680 | PRE
Spreadsheet: 199280d1355164151-conditional-formatting-underline-month-start
Sheet: Sheet1

2012-12-10 00:00:00
Spreadsheet: 169630d1342991036-excel-2007-problem-with-vlookup-formula-plant-schedule-comp
Sheet: Sheet1

PLANT COMPARISON SHEET
Company |  |  |  |  |  | Company |  |  |  |  |  | Company
Plants Of Noosa |  |  |  |  |  | Greenstock |  |  |  |  |  | Bluesky
Plant Name/ Code | Pot size | Qty | Rate | Total |  | Plant Name/ Code | Pot size | Qty | Rate | Total |  | Plant Name/ Code | Pot size | Qty | Rate | Total |  | Minimum Total | Company
 |  | 10 | 15 |  |  |  |  | 10 | 12 |  |  |  |  | 10 | 20
Spreadsheet: 697844d1601567533-is-there-a-way-to-automate-this-row-sort-process-rowsort-ans
Sheet: Sheet1 (2)

 | 3 | 12 | 13 | 19 | 34 | 53 | 65
 | 7 | 22 | 33 | 18 | 91 | 26 | 77
 | 45 | 34 | 5 | 67 | 89 | 12 | 23
 | 39 | 14 | 25 | 46 | 8 | 42 | 19
 | 12 | 48 | 23 | 55 | 13 | 40 | 21
 | 19 | 4 | 69 | 17 | 51 | 39 | 33
 | 99 | 14 | 15 | 20 | 36 | 39 | 9
 | 23 | 24 | 37 | 81 | 13 | 15 | 1
 | 66 | 22 | 49 | 93 | 1 | 25 | 44
 | 6 | 88 | 19 | 12 | 45 | 68 | 23
Spreadsheet: 2eb56c63-6d23-414a-ba0a-fa600213d773
Sheet: DC Enrollment by District

Dual Credit Enrollment
Students 2007-08 through 2011-12
Enrollment By District
 | Number of Students
School District | AY 2007-08 | AY 2008-09 | AY 2009-10 | AY 2010-11 | AY 2011-12
APS | 918 | 1244 | 1230 | 1466 | 1553
Rio Rancho | 318 | 328 | 445 | 534 | 488
State | 47 | 52 | 82 | 129 | 167
Other* | 46 | 77 | 125 | 140 | 324
 | Number of Students
School District | AY 2011-12 | AY 2010-11 | AY 2009-10 | AY 2008-09 | AY 2007-08
APS | 1553 | 1466 | 1230 | 1244 | 918
Rio Rancho | 488 | 534 | 445 | 328 | 318
State | 167 | 129 | 82 | 52 | 47
Other* | 324 | 140 | 125 | 77 | 46
Spreadsheet: 673971d1587614751-if-formula-for-counting-if-function
Sheet: Sheet2

SOP buffersize calculation |  |  |  |  |  |  | Main production line decreasing parts
Part | Needed QTY | Time per part [min] |  | QTY Shifts | SOP QTY |  | min. 0 | min. 150 | min. 300 | min. 450 | min. 600 | min. 750 | min. 900 |  | TOTAL QTY | Part #1 finished | Part #2 finished | Part #3 finished | Part #4 finished | Part #5 finished | Part #6 finished |  | Buffer at 0 minutes | Buffer at 150 minutes | Buffer at 300 minutes | Buffer at 450 minutes | Buffer at 600 minutes | Buffer at 750 minutes | Buffer at 900 minutes
Kleinteile | 6 | 150 |  | N.A. | 3 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  | 6 |  |  |  |  |  |  |  | 2
Supply Spisto | 6 | 10 |  | 1 | 3 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  | 6 | 10 | 20 | 30 | 40 | 50 | 60 |  | 2
Lüfter | 6 | 30 |  | 1 | 3 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  | 6 | 90 | 120 | 150 | 180 | 210 | 240 |  | 2
Rucksack | 6 | 20 |  | 1 | 3 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  | 6 | 260 | 280 | 300 | 320 | 340 | 360 |  | 2
Auslegearm | 6 | 15 |  | 1 | 3 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  | 6 | 375 | 390 | 405 | 420 | 435 | 450 |  | 2
Schaltschrank | 6 | 360 |  | 2 | 3 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  | 6 | 360 | 720 | 180 | 540 | 900 | 360 |  | 2
Fluidbox | 6 | 240 |  | 2 | 3 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  | 6 | 240 | 240 | 240 | 480 | 720 | 690 |  | 2
Külhaggregat + Abt. BFA | 6 | 20 |  | 1 | 3 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  | 6 | 20 | 40 | 60 | 320 | 340 | 360 |  | 2
Motorspindle | 6 | 60 |  | 1 | 3 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  | 6 | 90 | 150 | 210 | 270 | 330 | 390 |  | 2
Engines (per set) | 6 | 90 |  | 1 | 3 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  | 6 | 90 | 180 | 270 | 360 | 450 | 450 |  | 2
Schwenkrundtisch | 6 | 10 |  | 1 | 3 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  | 6 | 10 | 20 | 30 | 400 | 410 | 420 |  | 2
Werkzeugmagazine | 6 | 105 |  | 2 | 3 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  | 6 | 345 | 450 | 345 | 450 | 795 | 900 |  | 2
Kabine | 6 | 360 |  | 2 | 3 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  | 6 | 360 | 360 | 360 | 810 | 810 | 810 |  | 2
Öl-Nebelabschreider | 6 | 90 |  | 2 | 3 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  | 6 | 450 | 450 | 450 | 900 | 900 | 900 |  | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Test formulas! |  |  |  |  |  |  |  |  | 1
Min. buffersize | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  | Als part 1 <= 150 dan +1 |  |  |  |  |  |  |  |  | 2
[NAME]. buffersize | 5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
Buffer minutes parameters | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 5
 | 150 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 6
 | 300
 | 450
 | 600
 | 750
 | 900
Spreadsheet: 58545d1258762023-transfer-data-from-journal-to-ledger-example-for-ritch
Sheet: journal

 |  |  | COMPANY NAME
[NAME] | DATE | NO. | البيــــــــــــــــــان | total |  | CARS |  | BUILDINGS |  | A/R |  | A/P |  | INVENTORY |  | CASH |  | BANK
 |  |  |  | Debit | credit | Debit | credit | Debit | credit | Debit | credit | Debit | credit | Debit | credit | Debit | credit | Debit | credit
خـــطأ | 2008-01-01 00:00:00 | 1 |  | 380000 | 59000 |  | 240000 |  |  | 48000 |  |  | 110000 |  |  | 11000 |  |  | 30000
- | 2008-01-01 00:00:00 | 2 |  | 0 | 0
- | 2008-01-04 00:00:00 | 3 |  | 0 | 0
- | 2008-01-04 00:00:00 | 4 |  | 0 | 0
- | 2008-01-05 00:00:00 | 5 |  | 0 | 0
- | 2008-01-09 00:00:00 | 6 |  | 0 | 0
- | 2008-01-09 00:00:00 | 7 |  | 0 | 0
- | 2008-01-12 00:00:00 | 8 |  | 0 | 0
- | 2008-01-12 00:00:00 | 9 |  | 0 | 0
- | 2008-01-10 00:00:00 | 10 |  | 0 | 0
- | 2008-01-14 00:00:00 | 11 |  | 0 | 0
- | 2008-01-14 00:00:00 | 12 |  | 0 | 0
- | 2008-01-14 00:00:00 | 13 |  | 0 | 0
- | 2008-01-14 00:00:00 | 14 |  | 0 | 0
- | 2008-01-15 00:00:00 | 15 |  | 0 | 0
- | 2008-01-20 00:00:00 | 16 |  | 0 | 0
- | 2008-01-20 00:00:00 | 17 |  | 0 | 0
- | 2008-01-20 00:00:00 | 18 |  | 0 | 0
- | 2008-01-23 00:00:00 | 19 |  | 0 | 0
- | 2008-01-23 00:00:00 | 20 |  | 0 | 0
- | 2008-01-23 00:00:00 | 21 |  | 0 | 0
- | 2008-01-24 00:00:00 | 22 |  | 0 | 0
- | 2008-01-30 00:00:00 | 23 |  | 0 | 0
- | 2008-01-30 00:00:00 | 24 |  | 0 | 0
- | 2008-01-31 00:00:00 | 25 |  | 0 | 0
- | 2008-01-31 00:00:00 | 26 |  | 0 | 0
- | 2008-01-31 00:00:00 | 27 |  | 0 | 0 |  | 240000 | 0 | 0 | 48000 | 0 | 0 | 110000 | 0 | 0 | 11000 | 0 | 0 | 30000
- | 2008-01-02 00:00:00 | 28 |  | 0 | 0
- | 2008-01-29 00:00:00 | 29 |  | 0 | 0
- | 2008-01-30 00:00:00 | 30 |  | 0 | 0
- | 2008-01-31 00:00:00 | 31 |  | 0 | 0
- | 2008-02-01 00:00:00 | 32 |  | 0 | 0
- | 2008-02-02 00:00:00 | 33 |  | 0 | 0
- | 2008-02-03 00:00:00 | 34 |  | 0 | 0
- | 2008-02-04 00:00:00 | 35 |  | 0 | 0
- | 2008-02-05 00:00:00 | 36 |  | 0 | 0
- | 2008-02-06 00:00:00 | 37 |  | 0 | 0
- | 2008-02-07 00:00:00 | 38 |  | 0 | 0
- | 2008-02-08 00:00:00 | 39 |  | 0 | 0
- | 2008-02-09 00:00:00 | 40 |  | 0 | 0
- | 2008-02-10 00:00:00 | 41 |  | 0 | 0
- | 2008-02-11 00:00:00 | 42 |  | 0 | 0
- | 2008-02-12 00:00:00 | 43 |  | 0 | 0
- | 2008-02-13 00:00:00 | 44 |  | 0 | 0
- | 2008-02-14 00:00:00 | 45 |  | 0 | 0
- | 2008-02-15 00:00:00 | 46 |  | 0 | 0
- | 2008-02-16 00:00:00 | 47 |  | 0 | 0
- | 2008-02-17 00:00:00 | 48 |  | 0 | 0
- | 2008-02-18 00:00:00 | 49 |  | 0 | 0
- | 2008-02-19 00:00:00 | 50 |  | 0 | 0
- | 2008-02-20 00:00:00 | 51 |  | 0 | 0
- | 2008-02-21 00:00:00 | 52 |  | 0 | 0
- | 2008-02-22 00:00:00 | 53 |  | 0 | 0
- | 2008-02-23 00:00:00 | 54 |  | 0 | 0
- | 2008-02-24 00:00:00 | 55 |  | 0 | 0
- | 2008-02-25 00:00:00 | 56 |  | 0 | 0
- | 2008-02-26 00:00:00 | 57 |  | 0 | 0
- | 2008-02-27 00:00:00 | 58 |  | 0 | 0
- | 2008-02-28 00:00:00 | 59 |  | 0 | 0
- | 2008-02-29 00:00:00 | 60 |  | 0 | 0
- | 2008-03-01 00:00:00 | 61 |  | 0 | 0
- | 2008-03-02 00:00:00 | 62 |  | 0 | 0
- | 2008-03-03 00:00:00 | 63 |  | 0 | 0
- | 2008-03-04 00:00:00 | 64 |  | 0 | 0
- | 2008-03-05 00:00:00 | 65 |  | 0 | 0
- | 2008-03-06 00:00:00 | 66 |  | 0 | 0
Spreadsheet: 755297d1636759706-how-to-averageifs-last-n-values-based-on-date-and-product-avg-example-data_gw
Sheet: Sheet1

Product | Week | [NAME] |  |  |  |  | FR - CSE | GW - CSE
BC0002 | 10/10/2021 | 21000 |  | BC0002
BC0006 | 03/10/2021 | 90000 |  | BC0006
BC0006 | 17/10/2021 | 1000 |  | BC0022
BC0006 | 31/10/2021 | 0 |  | BC0086
BC0006 | 07/11/2021 | 82000 |  | BC0109
BC0022 | 03/10/2021 | 81000
BC0022 | 10/10/2021 | 80000
BC0022 | 17/10/2021 | 100000
BC0022 | 24/10/2021 | 59000
BC0022 | 31/10/2021 | 81000
BC0022 | 07/11/2021 | 33000
BC0086 | 03/10/2021 | 82090
BC0086 | 07/11/2021 | 57600
BC0109 | 03/10/2021 | 111725
BC0109 | 10/10/2021 | 105000
BC0109 | 17/10/2021 | 185950
BC0109 | 24/10/2021 | 158975
BC0109 | 31/10/2021 | 161325
BC0109 | 07/11/2021 | 219000
Spreadsheet: 58791d1259059191-row-to-column-row_to_column
Sheet: Sheet3

Data
A | raj
A | raj
A | ram
B | kam
B | ran
B | asdf
B | asdf
B | [NAME]
B | twer
C | [NAME]
C | iqwoeur
C | qoweir
C | qwe
Need the data like this
A | raj | raj | ram
B | kam | ran | asdf | asdf | [NAME] | twer
C | [NAME] | iqwoeur | qoweir | qwe
Spreadsheet: 195662d1353594238-vlookup-help-needed-please-xc-results
Sheet: JG Results

Position | Number | Forname | Surname | County | Age Group
1
 |  |  |  |  |  |  | Over All Results
 |  |  |  |  |  |  | County | Score
 |  |  |  |  |  |  | Cleveland
 |  |  |  |  |  |  | Cumbria
 |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  | Northumberland
 |  |  |  |  |  |  | [NAME]
Spreadsheet: 79595d1279816267-sum-if-following-criteria-match-if-and-sum
Sheet: Sheet1

Values | Rating |  |  |  | Ratings | Values
20178502.13426465 | N R |  |  |  | AAA
10089251.06713232 | A+ |  |  |  | AA (AA+, AA-,AA)
15521924.71866512 | BBB+ |  |  |  | A (A-,A+,A,[NAME])
10089251.06713232 | A |  |  |  | BBB (BBB;BBB+;BBB-;Baa1)
20000000 | A |  |  |  | Non Investment (BB+ /*-; BB+)
20000000 | BBB |  |  |  | NR
7760962.359332558 | N R
10089251.06713232 | BBB+
5044625.533566162 | N R
7760962.359332558 | A+
5044625.533566162 | N R
10000000 | BBB
10089251.06713232 | BBB
10089251.06713232 | A3
25000000 | N R
15000000 | N R
20178502.13426465 | A+
15000000 | N R
25000000 | N R
10000000 | BBB
25000000 | BBB
25000000 | Baa1
25000000 | Baa1
20178502.13426465 | Baa1
20178502.13426465 | BBB
10089251.06713232 | Baa1
5000000 | BB+ /*-
5000000 | BB+ /*-
5000000 | N R
5000000 | AA-
5000000 | AA-
7760962.359332558 | N R
5000000 | A+
5000000 | BBB-
5000000 | A
5000000 | BB+
5000000 | BBB-
10000000 | A+
15000000 | N R
10000000 | A-
10000000 | A-
5000000 | A
10000000 | N R
19402405.89833139 | A-
10000000 | BBB-
7760962.359332558 | N R
10000000 | N R
10000000 | BBB-
10000000 | N R
10000000 | A-
10000000 | BBB-
10000000 | A
5044625.533566162 | AA+
10000000 | A
10089251.06713232 | N R
10089251.06713232 | AAA
25000000 | A+
5044625.533566162 | A+
10000000 | AA+
10089251.06713232 | N R
10089251.06713232 | A+
25000000 | A+
20000000 | N R
20000000 | N R
10000000 | BBB-
20000000 | BBB
1000000 | N R
Spreadsheet: 707406d1607251206-using-a-list-to-reduce-worksheets-midshires-master
Sheet: TMa

 |  |  |  | ADJUSTED HANDICAP |  |  |  |  |  | OFFICIAL HANDICAP |  |  |  |  | HANDICAPPING ALTERATIONS
hole | par | S/I | SHOTS | CALC | points | PAR 3 | SI/1 | SI/2 | S1/3 | SI/1 | S1/2 | S1/3 | CALC | points | EXACT | catagory | BUFFER | css | Nett | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HANDICAP |  | ZONE |  | Differential
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out |  |  |  |  |  | TOTAL
total
Spreadsheet: 684978d1593640379-working-out-if-data-is-regularly-periodic-excel-example
Sheet: Sheet1

 | Probem I am trying to address
Input | 2019-01-01 00:00:00 | 2019-02-01 00:00:00 | 2019-03-01 00:00:00 | 2019-04-01 00:00:00 | 2019-05-01 00:00:00 | 2019-06-01 00:00:00 | 2019-07-01 00:00:00 | 2019-08-01 00:00:00 | 2019-09-01 00:00:00 | 2019-10-01 00:00:00 | 2019-11-01 00:00:00 | 2019-12-01 00:00:00 | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-01 00:00:00 | 2020-04-01 00:00:00 | 2020-05-01 00:00:00 | 2020-06-01 00:00:00 |  | Desired Output
 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100 |  | 1 | (or monthly)
 | 200 |  |  | 200 |  |  | 200 |  |  | 200 |  |  | 200 |  |  | 200 |  |  |  | 3 | (or quarterly)
 | 400 |  |  |  |  |  | 400 |  |  |  |  |  | 400 |  |  |  |  |  |  | 6 | (or semi-annually)
 | 600 |  |  |  |  |  |  |  |  |  |  |  | 600 |  |  |  |  |  |  | 12 | (or annual)
 | 200 |  | 200 |  |  |  |  | 200 | 200 |  | 200 |  |  |  |  | 200 | 200 |  |  | N/A or No regular period
 | The Opposite: Working out regular entries given period
Output | 2019-01-01 00:00:00 | 2019-02-01 00:00:00 | 2019-03-01 00:00:00 | 2019-04-01 00:00:00 | 2019-05-01 00:00:00 | 2019-06-01 00:00:00 | 2019-07-01 00:00:00 | 2019-08-01 00:00:00 | 2019-09-01 00:00:00 | 2019-10-01 00:00:00 | 2019-11-01 00:00:00 | 2019-12-01 00:00:00 | 2020-01-01 00:00:00 | 2020-02-01 00:00:00 | 2020-03-01 00:00:00 | 2020-04-01 00:00:00 | 2020-05-01 00:00:00 | 2020-06-01 00:00:00 |  | Input
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Period | 3 |  | Value | 200
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Period | 6 |  | Value | 400
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Period | 12 |  | Value | 600
Spreadsheet: darrell_schoolcraft__7297__imball0112
Sheet: Mojave

56696
Day | Measured | Scheduled
1 | -19999 | -19885
2 | -20165 | -19885
3 | -20034 | -19885
4 | -19990 | -19952
5 | -20010 | -19952
6 | -19999 | -20000
7 | -20968 | -20000
8 | -20315 | -20000
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-11-30 00:00:00 |  |  | 176944
2001-12-08 00:00:00
CBS Dollars
 |  |  | 177583
Spreadsheet: 0f4858f7-2487-43be-bd11-e46b1657d3a5
Sheet: B

Course color corresponds with term of offering.  BLUE for Spring semester, PURPLE for J-term, GREEN for both Spring and J-term.
 | AOK Designation | CAR Designation | Comment
Biology
BIOL 121 | Natural & Mathematical Sciences-Nat Sci w Lab
BIOL 122 | Natural & Mathematical Sciences-Nat Sci w Lab
BIOL 124 | Natural & Mathematical Sciences-Nat Sci w Lab
BIOL 125 | Natural & Mathematical Sciences-Nat Sci w Lab
BIOL 126 | Natural & Mathematical Sciences-Nat Sci w Lab
BIOL 127 | Natural & Mathematical Sciences-Nat Sci w Lab
BIOL 129 | Natural & Mathematical Sciences-Nat Sci w Lab
BIOL 133 | Natural & Mathematical Sciences-Nat Sci w Lab
BIOL 151 | Natural & Mathematical Sciences-Nat Sci w Lab
BIOL 155 | Natural & Mathematical Sciences-Nat Sci w Lab
BIOL 175 | Natural & Mathematical Sciences-Nat Sci w Lab
BIOL 181 | Natural & Mathematical Sciences-Nat Sci w Lab
BIOL 182 | Natural & Mathematical Sciences-Nat Sci w Lab
BIOL 250 |  | Experiential-Travel
BIOL 309 | Natural & Mathematical Sciences-Nat Sci w Lab
BIOL 315 | Natural & Mathematical Sciences-Nat Sci w Lab
BIOL 333 | Natural & Mathematical Sciences-Nat Sci w Lab | Experiential-Travel
BIOL 335 | Natural & Mathematical Sciences-Nat Sci w Lab | Experiential-Travel
BIOL 350 |  | Computing
BIOL 381 | Natural & Mathematical Sciences-Nat Sci w Lab |  | 2009-2010 (Flies, Fishes, and Foods)
BIOL381 | Natural & Mathematical Sciences-Nat Sci w Lab |  | Summer 2013 (Special Topics in General Zoology)
 |  |  | Fall 2011 (Evolution & Natural Selection)
BIOL 400 |  | Experiential-Research; Capstone
BIOL 450 |  | Experiential-Research
BIOL 487-488 |  | Experiential-Research; Capstone
BIOL 491-492 |  | Experiential-Research
BIOL 496-498 |  | Experiential-Research; Capstone
Black Studies
BLST 160 | Social Sciences | Non-Western, Experiential-Travel | Cross-listed with PSYC 160
BLST 201 | Social Sciences |  | Cross-listed with SOCI 225
BLST 381 |  | Experiential-Travel | J-Term 2009,2010;2012  Cross-listed with HIST 381
BLST 381 | Arts & Literature-Arts |  | J-Term 2013 (Black American Theatre)
Business
BUSN 111 | Social Sciences
BUSN 213 | Social Sciences
BUSN 336 |  | Computing
BUSN 425 |  | Capstone | Accounting & Economics/Business major
BUSN 450-451 |  | Experiential-Internship, Capstone | Economics/Business major
BUSN 452 |  | Capstone; Experiential-Internship | Accounting major
BUSN 455 |  | Capstone; Experiential-Field Studies
BUSN 491-492 |  | Capstone; Experiential-Research | Accounting & Economics/Business major
BUSN 496-498 |  | Capstone; Experiential-Research | Accounting & Economics/Business major
Spreadsheet: 741578d1627155119-when-did-item-sell-last-inventory-analysis
Sheet: Last Sales Date

Column3 | Last Sales Date
ACE TOILET CLEAR LAVENDER 500ML | 2021-07-03 00:00:00
ACNEDIS HERBAL SOAP BAR 100G | 2021-07-14 00:00:00
ADIDAS ADIPURE S/G 400ML | 2021-07-11 00:00:00
ADIDAS DYNAMIC PULSE S/G 400ML | 2021-07-12 00:00:00
ADIDAS PURE GAME S/G 400ML | 2021-07-05 00:00:00
AER PETAL CAR FRESHNER SILV 10G | 2021-07-07 00:00:00
AFRICANA EXTRA COCONUT OIL 250M | 2021-07-12 00:00:00
AIRWICK ROSE REFIL | 2021-07-02 00:00:00
AJAX LAVENDER 1250ML | 2021-07-04 00:00:00
[NAME] SHAVING MACHINE | 2021-07-05 00:00:00
[NAME] | 2021-07-15 00:00:00
ALTECO SUPER GLUE | 2021-07-13 00:00:00
WISDOM TRAVEL | 2021-07-01 00:00:00