tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 246d3e9c-b78b-47d1-8bdd-b473e322fcf2
Sheet: 15c

 | Swap Dealers/MSPs4 |  | Others
Product1 | Cleared2 | Uncleared | Cleared | Uncleared
Index Tranche | - | 1480 | - | 326
Index | 247530 | 114915 | 134449 | 86804
Asia | - | 165 | - | 107
Europe | 113509 | 45407 | 51477 | 28352
North America | 132528 | 67176 | 82549 | 58235
Other | 1493 | 2167 | 423 | 110
OTHER* | 8632 | 28540 | 8225 | 19940
TOTAL | 256162 | 144935 | 142674 | 107070
*OTHER variable includes exotic credit products, swaptions, and total return swaps.
Spreadsheet: benjamin_rogers__1024__TLR Analysis
Sheet: Feb

 | TLR Max Level | Number of Incidents
 | 1 | 0
 | 2a | 2
 | 2b | 10
 | 2c | 0
 | 3 | 11
 | 4 | 2
 | 5 | 0
 | 6 | 0
 | Total
 | Curtailment | TLR level | MW Curtailed | Controller | Start Time | End Time | Total Time
1 | 1999-02-02 00:00:00 | 3 | 51 | MAIN | 10:25:00 | 00:30:00 | 14:05:00
1 | 1999-02-05 00:00:00 | 3 | 1014 | MAIN | 22:46:00 | 12:54:00 | 14:08:00
1 | 1999-02-09 00:00:00 | 3 | 58 | MAIN | 00:50:00 | 14:17:00
1 | 1999-02-13 00:00:00 | 3 | 509 | MAIN | 08:25:00 | 22:20:00
1 | 1999-02-17 00:00:00 | 4 | 330 | MAIN | 10:30:00 | 22:45:00
1 | 1999-02-18 00:00:00 | 3 | 300 | MAIN | 09:00:00 | 23:00:00
1 | 1999-02-19 00:00:00 | 3 | 327 | MAIN | 07:30:00 | 23:00:00
1 | 1999-02-20 00:00:00 | 3 | 310 | MAIN | 07:15:00 | 20:41:00
1 | 1999-02-22 00:00:00 | 4 | 382 | MAIN | 06:15:00 | 21:05:00
Spreadsheet: 35011d1232479442-conditional-i-think-if-statment-maybe-more-mew-mewitty-mew-mew
Sheet: Gate info

Galaxy Gate Rewards
 |  |  |  |  |  |  |  |  |  |  |  |  | Amount | Amount | Amount
Alpha | # | Exp | Honour | Credits | Uri | Prometium | Terbium | Endurium | Prometid | Duranium | Promerium | Total Cargo | Prometid | Duranium | Promerium
Streuners | 40 | 16000 | 80 | 16000 | 40 | 400 | 0 | 400 | 0 | 0 | 0 | 800 | 20 | 0 | 0
Lordakians | 40 | 32000 | 160 | 32000 | 80 | 800 | 800 | 800 | 0 | 0 | 0 | 2400 | 40 | 40 | 40
Mordons | 40 | 128000 | 640 | 256000 | 320 | 3200 | 3200 | 3200 | 320 | 320 | 40 | 10280 | 160 | 160 | 160
Saimons | 80 | 128000 | 640 | 128000 | 320 | 3200 | 3200 | 3200 | 160 | 160 | 0 | 9920 | 160 | 160 | 160
Devolarium | 20 | 128000 | 640 | 1024000 | 320 | 800 | 800 | 800 | 40 | 40 | 0 | 2480 | 40 | 40 | 40
Sks | 80 | 512000 | 2560 | 1024000 | 1280 | 8000 | 8000 | 8000 | 1280 | 1280 | 80 | 26640 | 400 | 400 | 400
Sibelons | 20 | 256000 | 1280 | 2048000 | 640 | 4000 | 4000 | 4000 | 4000 | 640 | 80 | 16720 | 200 | 200 | 200
Sibelonits | 80 | 256000 | 1280 | 1024000 | 960 | 8000 | 8000 | 8000 | 640 | 640 | 80 | 25360 | 400 | 400 | 400
Bks | 16 | 819200 | 4096 | 6553600 | 2048 | 4800 | 4800 | 4800 | 2048 | 2048 | 256 | 18752 | 240 | 240 | 240
Protegits | 30 | 192000 | 960 | 384000 | 480 | 3000 | 3000 | 3000 | 480 | 480 | 60 | 10020 | 150 | 150 | 150
Total | 446 | 2467200 | 12336 | 12489600 | 6488
 |  | Exp | Honour | Uri | Cargo |  | Prometid | Duranium | Promerium |  | Prometium | 20
Rewards | Alpha | 4000000 | 200000 | 20000 | 123372 |  | 1810 | 1790 | 1810 |  | Endurium | 10
 | Betta | 8000000 | 400000 | 40000 | 245144 |  |  |  |  |  | Terbium | 20
 | Yamma | 12000000 | 600000 | 60000 | 360516
Total Reward | Alpha | 6467200 | 212336 | 26488
 | Beta | 12934400 | 424672 | 52976 |  |  | 35800 | 36200
 | Yamma | 19401600 | 637008 | 79464
Spreadsheet: 768610d1645042048-formula-function-for-adding-hours-from-multiple-locations-staffing-example-spreadsheet-upload
Sheet: Sheet1

 |  |  |  | Employee Utilization/ Availability
 |  |  |  | January |  |  |  | February |  |  |  | March |  |  |  | April
 |  |  | Employee | Week 1 | Week 2 | Week 3 | Week 4 | Week 1 | Week 2 | Week 3 | Week 4 | Week 1 | Week 2 | Week 3 | Week 4 | Week 1 | Week 2 | Week 3 | Week 4
 |  |  | Angelica
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
 |  |  | [NAME]
 |  | Project Name |  | Planned Hours
 |  | Smith House Renovation |  | January |  |  |  | February |  |  |  | March |  |  |  | April
 |  | Project Role | Employee | Week 1 | Week 2 | Week 3 | Week 4 | Week 1 | Week 2 | Week 3 | Week 4 | Week 1 | Week 2 | Week 3 | Week 4 | Week 1 | Week 2 | Week 3 | Week 4
 |  | Executive | Angelica | 10 | 12 | 10 | 10
 |  | Manager | [NAME] | 30 | 32 | 24 | 40
 |  | Coordinator | [NAME] | 40 | 38 | 40 | 38
 |  | Intern | [NAME] | 20 | 22 | 25 | 24
 |  | Project Name |  | Planned Hours
 |  | Factory Expansion |  | January |  |  |  | February |  |  |  | March |  |  |  | April
 |  | Project Role | Employee | Week 1 | Week 2 | Week 3 | Week 4 | Week 1 | Week 2 | Week 3 | Week 4 | Week 1 | Week 2 | Week 3 | Week 4 | Week 1 | Week 2 | Week 3 | Week 4
 |  | Executive | Angelica | 10 | 12 | 10 | 10
 |  | Manager | [NAME] | 30 | 32 | 24 | 40
 |  | Coordinator | [NAME] | 40 | 38 | 40 | 38
 |  | Intern #1 | [NAME] | 40 | 40 | 40 | 40
 |  | Intern #2 | [NAME] | 20 | 22 | 25 | 24
 |  | Questions to Excel Forum:
 | 1 | I want this cell to total all hours on all projects where [NAME] is scheduled to work for this week. I will add conditonal formatting (I think I can figure this part out) to show the fill color to turn to red if it exceeds 40 hours/ week.
 | 2 | I want to be able to insert new employees as they start, and I would like for them to be alphbetical so they may drop in the middle of the list.
 | 3 | I will add other projects down this list. Some will have more or less employees.
Spreadsheet: 737368d1624374222-sorting-defects-based-on-the-date-they-were-found-work-in-progress-2-
Sheet: Sheet1

Date | Quantity Inspected | Qty Rejected |  |  |  |  | Description of defects | 2021-05-01 00:00:00
2021-01-07 00:00:00 | 80 | 11 |  |  |  |  | Flash
2021-01-07 00:00:00 | 80 | 5 |  |  |  |  | Flash
2021-01-07 00:00:00 | 79 |  |  | Month | QTY
2021-01-07 00:00:00 | 80 | 15 |  | 1 |  |  | Sink
2021-01-07 00:00:00 | 80 | 25 |  | 2 |  |  | Burns
2021-01-07 00:00:00 | 80 |  |  | 3
2021-01-08 00:00:00 | 478 | 8 |  | 4 |  |  | Splay
2021-01-08 00:00:00 | 558 |  |  | 5
2021-01-08 00:00:00 | 638 |  |  | 6
2021-01-08 00:00:00 | 718 |  |  | 7
2021-01-08 00:00:00 | 1918 |  |  | 8
2021-01-20 00:00:00 | 1918 |  |  | 9
2021-01-22 00:00:00 | 400 | 6 |  | 10 |  |  | Short Shots
2021-01-27 00:00:00 | 973 |  |  | 11
2021-02-19 00:00:00 | 1853 |  |  | 12
2021-02-20 00:00:00 | 853
2021-05-10 00:00:00 | 4093 | 32 |  |  |  |  | Other
2021-05-11 00:00:00 | 4173
2021-05-11 00:00:00 | 4253
2021-05-11 00:00:00 | 4413
2021-05-12 00:00:00 | 675
2021-04-12 00:00:00 | 561
Spreadsheet: 64362d1265230635-sumproduct-formula-not-working-dummysumproduct
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Marketing
 |  |  | Date Received | Marketing | Accoutning | Bus. Ops | Facilities | Total |  |  |  |  |  |  | Accoutning
 |  |  | 2009-01-05 00:00:00 | 23 | 14 | 8 | 2 | 47 |  |  |  |  |  |  | Bus. Ops
 |  |  |  | Marketing | Bus. Ops | Facilities | HR |  |  |  |  |  |  |  | Facilities
 |  |  | 2009-01-08 00:00:00 | 14 | 4 | 5 | 1 | 24 |  |  |  |  |  |  | Advertising
 |  |  |  | Advertising | Bus. Ops | Printing |  |  |  |  |  |  |  |  | Executive
 |  |  | 2009-01-23 00:00:00 | 8 | 9 | 4 |  | 21 |  |  |  |  |  |  | HR
 |  |  |  | Marketing | Accoutning | Bus. Ops | HR |  |  |  |  |  |  |  | Printing
 |  |  | 2009-02-04 00:00:00 | 19 | 25 | 21 | 5 | 70
 |  |  | Total |  |  |  |  | 162
 |  |  | Based on the formatting of the above data, is it possible to breakout how much each department received per month?
 |  |  |  | Jan | Feb | March | YTD
 |  |  | Marketing
 |  |  | Accoutning
 |  |  | Bus. Ops
 |  |  | Facilities
 |  |  | Advertising
 |  |  | Executive
 |  |  | HR
 |  |  | Printing
Spreadsheet: 00410380-0ccb-4f59-9f5f-e9cc5be7160f
Sheet: Sheet1

2013-2014 Payment Worksheet | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8
New College Financial Aid
2013-2014 Costs Estimated for Financial Aid Purposes
Tuition
 |  | Fall* | Spring
Resident |  | 3814.2 | 3051.36
Non-Resident |  | 16608 | 13286.4
 |  | * Fall term includes ISP.
Housing |  |  | Fall | Spring |  | Food | Fall | Spring
[NAME] |  | Double | 3396.25 | 2707.5 |  | First Year/Pei | 1470.63 | 1226.4
 |  | Single | 5067.92 | 4040.16 |  | B Dorm | 1088.52 | 892.64
 |  | Triple | 2764.19 | 2203.62 |  | Apartment | 472.35 | 384.16
B Dorm |  | Single | 3244.67 | 2586.66 |  | Commuter | 214.32 | 212.8
 |  | Single Pref. | 3474.9 | 2770.2
Dort/Goldstein |  | Suite | 4421.56 | 3524.88
New Halls |  | Suite | 4421.56 | 3524.88
(V,W,X,Y,Z) |  | Studio Single | 4813.38 | 3837.24
Total Fees
 |  | Fall | Spring
Tuition |  |  |  |  |  | Total Aid
Housing |  |  |  |  |  |  | Estimate
Food |  |  |  |  |  | [NAME] | Fall | Spring
Other
Total |  | 0 | 0
Payment Calculation
 |  | Fall | Spring
Fee Total |  | 0 | 0
-Aid Total | - | 0 | 0 |  |  | Total | 0 | 0
-Deposit and    payments | -
 | = | 0 | 0
Spreadsheet: 708565d1607931176-need-help-with-calculating-averages-over-dynamic-ranges-test-data
Sheet: Blad1

Time | Measurement
00:00:01 | 85
00:00:02 | 79
00:00:02 | 77
00:00:03 | 75
00:00:04 | 76
00:00:05 | 65
00:00:06 | 68
00:00:07 | 69
00:00:07 | 66
00:00:08 | 64
00:00:09 | 64
00:00:09 | 63
00:00:10 | 70
00:00:11 | 75
00:00:12 | 72
00:00:13 | 73
00:00:13 | 74
00:00:14 | 76
00:00:15 | 78
00:00:15 | 81
00:00:16 | 82
00:00:17 | 84
00:00:18 | 83
00:00:19 | 85
00:00:20 | 86
00:00:20.798000 | 77
00:00:21.963000 | 55
00:00:23.352000 | 82
00:00:23.890000 | 82
00:00:25.127000 | 82
00:00:25.687000 | 82
00:00:26.771000 | 82
00:00:27.359000 | 61
00:00:28.483000 | 85
00:00:29.084000 | 66
00:00:32.006000 | 66
00:00:32.606000 | 66
00:00:33.574000 | 66
00:00:34.148000 | 66
00:00:35.573000 | 66
00:00:36.182000 | 61
00:00:37.334000 | 55
00:00:37.737000 | 87
00:00:38.347000 | 63
00:00:39.239000 | 63
00:00:39.843000 | 63
00:00:40.825000 | 63
00:00:41.390000 | 63
00:00:42.272000 | 63
00:00:42.837000 | 63
00:00:43.818000 | 57
00:00:44.204000 | 90
00:00:44.831000 | 68
00:00:45.660000 | 68
00:00:46.261000 | 68
00:00:47.520000 | 68
00:00:48.098000 | 68
00:00:49.572000 | 68
00:00:50.092000 | 61
00:00:51.517000 | 91
00:00:52.109000 | 61
00:00:52.933000 | 89
00:00:53.489000 | 89
00:00:54.748000 | 89
00:00:55.322000 | 89
00:00:56.156000 | 89
00:00:56.729000 | 64
00:00:57.670000 | 90
00:00:58.248000 | 61
00:00:59.700000 | 87
00:01:00.323000 | 61
00:01:00.852000 | 57
00:01:01.865000 | 85
00:01:02.470000 | 60
00:01:03.554000 | 87
00:01:04.105000 | 87
00:01:05.194000 | 87
00:01:05.763000 | 87
00:01:07.014000 | 87
00:01:07.336000 | 59
00:01:08.349000 | 59
00:01:08.761000 | 66
00:01:10.666000 | 86
00:01:11.262000 | 57
00:01:12.454000 | 82
00:01:13.050000 | 60
00:01:14.260000 | 84
00:01:14.843000 | 64
00:01:15.725000 | 64
00:01:16.344000 | 64
00:01:17.209000 | 64
00:01:17.778000 | 64
00:01:18.822000 | 64
00:01:19.396000 | 71
00:01:20.341000 | 103
00:01:20.897000 | 65
00:01:22.255000 | 92
00:01:22.869000 | 61
00:01:24.419000 | 90
00:01:25.042000 | 63
00:01:26.364000 | 90
00:01:26.956000 | 70
00:01:27.453000 | 70
00:01:28.892000 | 70
00:01:29.416000 | 70
00:01:30.644000 | 70
00:01:31.217000 | 61
00:01:32.665000 | 93
00:01:33.256000 | 63
00:01:34.462000 | 89
00:01:35.044000 | 60
00:01:36.564000 | 88
00:01:37.204000 | 59
00:01:38.652000 | 85
00:01:39.248000 | 60
00:01:40.467000 | 60
00:01:41.076000 | 60
00:01:42.515000 | 60
00:01:43.102000 | 60
00:01:44.173000 | 60
00:01:44.715000 | 68
00:01:46.104000 | 100
00:01:46.687000 | 72
00:01:47.453000 | 56
00:01:48.139000 | 95
00:01:48.775000 | 63
00:01:50.223000 | 87
00:01:50.823000 | 63
00:01:51.993000 | 91
00:01:52.566000 | 91
00:01:53.678000 | 91
00:01:54.242000 | 91
00:01:55.502000 | 91
00:01:56.089000 | 58
00:01:57.500000 | 87
00:01:58.092000 | 60
00:01:59.212000 | 87
00:01:59.786000 | 64
Spreadsheet: 866987d1713890473-how-to-calculate-the-diameter-of-a-sprial-spiraldiameter
Sheet: Sheet1

 |  |  | turns | angle | Core X | Core Y | Roll X | Roll Y | x | y | rad | length | Diameter
core radius |  | 3 |  | 0
material thickness |  | 1
Material length |  | 120
Diameter of roll
Spreadsheet: 47142d1246040796-date-lookup-issues-date-test
Sheet: Sheet1

2006-04-28 00:00:00 |  |  |  |  |  |  | 2005-12-27 00:00:00 | 2006-03-27 00:00:00 | 2006 Q1
2006-06-01 00:00:00 |  |  |  |  |  |  | 2006-03-28 00:00:00 | 2006-06-26 00:00:00 | 2006 Q2
2006-07-27 00:00:00 |  |  |  |  |  |  | 2006-06-27 00:00:00 | 2006-09-25 00:00:00 | 2006 Q3
2006-08-15 00:00:00 |  |  |  |  |  |  | 2006-09-26 00:00:00 | 2006-12-25 00:00:00 | 2006 Q4
2006-06-05 00:00:00 |  |  |  |  |  |  | 2006-12-26 00:00:00 | 2007-03-26 00:00:00 | 2007 Q1
2006-03-09 00:00:00 |  |  |  |  |  |  | 2007-03-27 00:00:00 | 2007-06-25 00:00:00 | 2007 Q2
2006-09-03 00:00:00 |  |  |  |  |  |  | 2007-06-26 00:00:00 | 2007-09-24 00:00:00 | 2007 Q3
2006-02-02 00:00:00 |  |  |  |  |  |  | 2007-09-25 00:00:00 | 2007-12-31 00:00:00 | 2007 Q4
2006-06-05 00:00:00 |  |  |  |  |  |  | 2008-01-01 00:00:00 | 2008-03-31 00:00:00 | 2008 Q1
2006-12-18 00:00:00 |  |  |  |  |  |  | 2008-04-01 00:00:00 | 2008-06-30 00:00:00 | 2008 Q2
2006-06-03 00:00:00 |  |  |  |  |  |  | 2008-07-01 00:00:00 | 2008-09-29 00:00:00 | 2008 Q3
2006-08-31 00:00:00 |  |  |  |  |  |  | 2008-09-30 00:00:00 | 2008-12-29 00:00:00 | 2008 Q4
2006-11-20 00:00:00 |  |  |  |  |  |  | 2008-12-30 00:00:00 | 2009-03-30 00:00:00 | 2009 Q1
 |  |  |  |  |  |  | 2009-03-31 00:00:00 | 2009-06-29 00:00:00 | 2009 Q2
 |  |  |  |  |  |  | 2009-06-30 00:00:00 | 2009-09-28 00:00:00 | 2009 Q3
 |  |  |  |  |  |  | 2009-09-29 00:00:00 | 2009-12-28 00:00:00 | 2009 Q4
Spreadsheet: jim_schwieger__14491__Inv_WC_true_up
Sheet: Prime Rate Calc- GROSS

Date | Prime Rate | Principal | Principle * Daily Prime Rate
 |  |  |  |  |  |  |  |  |  |  | Prime Rate
2001-06-01 00:00:00 |  |  |  |  | 1 |  |  |  |  |  | Date Change |  | Rate
 |  |  |  |  |  |  |  |  |  |  | 2001-01-04 00:00:00 |  | 0.09
 |  |  |  |  |  |  |  |  |  |  | 2001-02-01 00:00:00 |  | 0.085
 |  |  |  |  |  |  |  |  |  |  | 2001-03-21 00:00:00 |  | 0.08
 |  |  |  |  |  |  |  |  |  |  | 2001-04-19 00:00:00 |  | 0.075
 |  |  |  |  |  |  |  |  |  |  | 2001-05-16 00:00:00 |  | 0.07
 |  |  |  |  |  |  |  |  |  |  | 2001-06-28 00:00:00 |  | 0.0675
 |  |  |  |  |  |  |  |  |  |  | 2001-08-22 00:00:00 |  | 0.065
 |  |  |  |  |  |  |  |  |  |  | 2001-09-18 00:00:00 |  | 0.06
 |  |  |  |  |  |  |  |  |  |  | 2001-10-03 00:00:00 |  | 0.055
 |  |  |  |  |  | Jun
 |  |  |  |  |  |  | Jul
 |  |  |  |  |  |  |  | Aug
 |  |  |  |  |  |  |  |  | Sep
 |  |  |  |  |  |  |  |  | 1
Spreadsheet: 62197d1263191229-weighted-average-based-on-sales-history-weighted_avg
Sheet: Sheet3

DAYS | UnitSales | No. Of 7 day blocks | Sales per 7 days | Weighting
7 | 5 |  |  | 0.7 |  | Average weekly sales (taking weighting into account):
30 | 20 |  |  | 0.2
60 | 80 |  |  | 0.1
Spreadsheet: 94233d1294095345-net-price-div-error-help-updated
Sheet: Sheet1

 |  |  | Vax Total: | 0
 |  |  | **Vax Free Goods | 0
 |  |  | Pharm Total: | 95.78999999999999
 |  |  | ** Pharm Free Goods | 13.5
 |  |  | Total: | 95.78999999999999
 | Name | Code | Size | DVM Price | Order | Free | $$$ | Net | Free Goods
 | Pharmaceuticals
 | Product 1 |  | 60 | 80.99 | 1 |  | 80.99 | 80.99 | 0
 | 2 |  | 65 | 14.8 | 1 |  | 14.8 | 14.8 | 0
 | 3 |  | 70 | 13.5 |  | 1 | 0 |  | 13.5
 | 4 |  | 75 | 26.5 |  |  | 0 |  | 0
 | 5 |  | 80 | 59.75 |  |  | 0 |  | 0
 | 6 |  | 85 | 93.75 |  |  | 0 |  | 0
Spreadsheet: 818536d1676902545-table-intervals-calculation-nt
Sheet: T1

Example 1 |  |  |  | Example 2 |  |  |  |  | Example 3
Manual | intervals | Interval distances |  | Manual | intervals | Interval distances |  |  | Manual | intervals | Interval distances
50 | 0-50 |  |  | 50 | 0-50 |  |  |  | 50 | 0-50
55 | 50,1-55 | 5 |  | 55 | 50,1-55 | 5 |  |  | 55 | 50,1-55 | 5
60 | 55,1-60 | 5 |  |  | 55,1-60 | 5 | (95 minus 55) divided by the number of empty cells plus 1 (i.e.7+1) till next cell that is not empty (i.e. 95) one more empty cell must be calculated, since 95 is the upper limit. |  |  | 55,1-57,5 | 2.5 | (65 minus 55) divided by number of empty cells plus 1 (i.e.3+1=4) till next cell that is not empty (i.e. 65) which summs up to 2,5 one more empty cell must be calculated, since 65 is the upper limit.
65 | 60,1-65 | 5 |  |  | 60,1-65 | 5 |  |  |  | 57,6-60 | 2.5
70 | 65,1-70 | 5 |  |  | 65,1-70 | 5 |  |  |  | 60,1-62,5 | 2.5
75 | 70,1-75 | 5 |  |  | 70,1-75 | 5 |  |  | 65 | 62,6-65 | 2.5
80 | 75,1-80 | 5 |  |  | 75,1-80 | 5 |  |  |  | 65,1-72,5 | 7.5 | (95 minus 65) divided by number of empty cells plus 1 (i.e.3+1=4) till next cell that is not empty (i.e. 95) which summs up to 7,5 one more empty cell must be calculated, since 65 is the upper limit.
85 | 80,1-85 | 5 |  |  | 80,1-85 | 5 |  |  |  | 72,6-80 | 7.5
90 | 85,1-90 | 5 |  |  | 85,1-90 | 5 |  |  |  | 80,1-87,5 | 7.5
95 | 90,1-95 | 5 |  | 95 | 90,1-95 | 5 |  |  | 95 | 87,6-95 | 7.5
100 | 95,1-100 | 5 |  | 100 | 95,1-100 | 5 | This value is set |  | 100 | 95,1-100 |  | This value is always set
Spreadsheet: cbe5b944-2a86-43d2-a630-5b6358dba59c
Sheet: Sheet1

A. | Unnamed: 1 | Unnamed: 2
Gene | Universe primer (5´-3´) | Reverse primer (5´-3´)
VEGFA | ctc agg gtt tcg gga acc | [NAME]
ADAMTS9 | [NAME] tac tgt gga aag tg | tct cct atg gct tcc tct tca g
GRB14 | cat gga caa aag ata aaa cac tat caa | [NAME] gag ctg gta gaa ctc c
LYPLAL1 | [NAME] gtt gtt tac cag ga | [NAME] ggt taa gat tcg gaa
PPAR | tta tag ctg tca tta ttc tca gtg gag | ggg tgg gac ttt cct gct a
B.
Locus | MarkerName | Genes
1 | rs6717858 | COBLL1; GRB14; SLC38A11
2 | rs2820443 | LYPLAL1;SLC30A10; EPRS
3 | rs1358980 | VEGFA; MRPS18A; C6orf223
4 | rs11743303 | ANKRD55; MAP3K1; C5orf35
5 | [NAME] | ADAMTS9; PRICKLE2; PSMD6
6 | rs10478424 | DTWD2;DMXL1;TNFAIP8;HSD17B4;FAM170A;PRR16
7 | rs4684854 | PPARG; TSEN2; MKRN2
Spreadsheet: 871090d1717522085-how-to-apply-if-function-to-show-a-certain-value-testting-3
Sheet: Summary

 |  |  |  |  |  | EOL HW SW Surcharge |  |  |  |  |  |  |  | Total Value | Annualized Value
 |  |  |  |  |  | 0 |  |  | [NAME] (Months) |  |  | Enter into SFDC Field==> | Initial Contract Amount
 |  |  |  |  |  |  |  | Verify in SFDC Field==> | Annualized [NAME]: |  |  | Enter into SFDC Field==> | Additonal Purchases |  |  |  |  |  |  |  |  |  |  | SFDC Opportunity Value - WHT
 |  |  |  |  |  | Discount % |  | Enter into SFDC Field==> | Effective [NAME]: |  |  | Enter into SFDC Field==> | Decommissioning |  |  |  |  |  |  |  |  |  |  | Sum of Prorated Maintenance
 |  |  |  |  |  | 0 |  | Enter into SFDC Field==> | Install Base Value |  |  | Enter into SFDC Field==> | Project Credit / Discount |  |  |  |  |  |  |  |  |  |  | Sum of Annual Maintenance
 |  |  |  |  |  |  |  | Enter into SFDC Field==> | Annualized Renewal Value: |  |  | Enter into SFDC Field==> | EOL |  |  |  |  |  |  |  |  |  |  | Sum of Adjusted SP
 |  |  |  |  |  | WHT % |  | Enter into CPQ==> | Line Item Discount: |  |  | Enter into SFDC Field==> | Account Rate Change |  |  |  |  |  |  |  |  |  |  | Sum of Adjusted LP
 |  |  |  |  |  | 0 |  | Verify in SFDC==> | WHT: |  |  |  | WHT
 |  |  |  |  |  |  |  | Enter into CPQ==> | List Unit Price |  |  |  | SFDC Opportunity Value |  |  |  |  |  |  |  |  |  |  | Effective Rate SP
 |  |  |  |  |  | Reinstatement fee |  | Verify in SFDC==> | SFDC Value |  |  |  | Calculated SFDC Value |  |  |  |  |  |  |  |  |  |  | Effective Rate LP
Chgable | Y |  |  |  |  | 0 |  |  |  |  |  |  | Delta
 |  |  |  |  |  |  |  |  | Values
[NAME] | Customer PO | [NAME] | Contract Expiry | [NAME] | Days to Renew | Currency | Adjusted Reason | Exclude | Sum of HL Qty | Sum of Adjusted LP | Sum of Adjusted SP | Sum of Annual Maintenance | Sum of Prorated Maintenance | Sum of Go Forward Annual | Sum of Previous Annual
00012345 | 12345 | HW | 2024-12-31 00:00:00 | 2025-12-31 00:00:00 | 365 | USD | (blank) | (blank) |  | 98618 | 98618 | 5917.08 | 5917.08 | 5917.08 | 5917.08
 |  | SW | 2024-12-31 00:00:00 | 2025-12-31 00:00:00 | 365 | USD | (blank) | (blank) |  | 71795.75 | 71795.75 | 10769.3625 | 10769.3625 | 4307.745 | 4307.745
Grand Total |  |  |  |  |  |  |  |  |  | 170413.75 | 170413.75 | 16686.4425 | 16686.4425 | 10224.825 | 10224.825
Spreadsheet: 352ae214-e8ce-4e37-a969-65c19a6e29be
Sheet: YCbCr

 |  |  |  | Y | Cb | Cr | Y | Cb | Cr | Y | Cb | Cr
Pattern | Proper Y'CbCr Values 16-235 Studio RGB (from [NAME]) |  |  | Accupel YCbCr 8-bit 1080p60 |  |  | Lumagen YCbCr 8-bit 1080p60 |  |  | Lumagen YCbCr 8-bit 1080p60
The generator was driven by --> |  |  |  | Calman v.1450 |  |  | Calman v.1450 |  |  | Manual (from refence patterns tab)
1 | 235 | 128 | 128 | 235 | 128 | 128 | 235 | 128 | 128 | 235 | 128 | 128
0.9 | 213 | 128 | 128 | 213 | 128 | 128 | 213 | 128 | 128 | 213 | 128 | 128
0.8 | 191 | 128 | 128 | 191 | 128 | 128 | 191 | 128 | 128 | 191 | 128 | 128
0.7 | 169 | 128 | 128 | 169 | 128 | 128 | 168 | 128 | 128 | 168 | 128 | 128
0.6 | 147 | 128 | 128 | 147 | 128 | 128 | 146 | 128 | 128 | 146 | 128 | 128
0.5 | 126 | 128 | 128 | 126 | 128 | 128 | 126 | 128 | 128 | 125 | 128 | 128
0.4 | 104 | 128 | 128 | 104 | 128 | 128 | 103 | 128 | 128 | 103 | 128 | 128
0.3 | 82 | 128 | 128 | 82 | 128 | 128 | 81 | 128 | 128 | 81 | 128 | 128
0.2 | 60 | 128 | 128 | 60 | 128 | 128 | 58 | 128 | 128 | 58 | 128 | 128
0.1 | 38 | 128 | 128 | 38 | 128 | 128 | 37 | 128 | 128 | 37 | 128 | 128
R | 63 | 102 | 240 | 63 | 102 | 240 | 63 | 102 | 239 | 63 | 102 | 239
G | 173 | 42 | 26 | 173 | 42 | 26 | 172 | 42 | 26 | 172 | 42 | 26
B | 32 | 240 | 118 | 32 | 240 | 118 | 31 | 240 | 118 | 31 | 240 | 118
Y | 219 | 16 | 138 | 219 | 16 | 138 | 219 | 15 | 138 | 219 | 15 | 138
C | 188 | 154 | 16 | 188 | 154 | 16 | 188 | 153 | 15 | 188 | 153 | 15
M | 78 | 214 | 230 | 78 | 214 | 230 | 78 | 214 | 230 | 78 | 214 | 230
R75 | 113 | 110 | 207 | 113 | 110 | 207 | 112 | 110 | 207
R50 | 141 | 114 | 189 | 141 | 114 | 189 | 141 | 114 | 188
R25 | 174 | 119 | 167 | 174 | 119 | 168 | 173 | 118 | 167
G75 | 196 | 74 | 65 | 196 | 74 | 65 | 196 | 73 | 65
G50 | 208 | 90 | 83 | 208 | 90 | 83 | 207 | 90 | 83
G25 | 220 | 107 | 103 | 220 | 107 | 103 | 219 | 107 | 103
B75 | 109 | 198 | 122 | 109 | 198 | 122 | 108 | 197 | 122
B50 | 146 | 177 | 123 | 146 | 177 | 123 | 146 | 177 | 124
B25 | 186 | 155 | 126 | 186 | 155 | 126 | 186 | 155 | 126
Spreadsheet: 716751d1612353470-getting-exact-match-across-2-sheets-using-sumproduct-testbook_1
Sheet: As-Built

TEST
As-Built Items by UIC
SCANNED | Expires | Recall | Inspection | Part No | Nomen | Serial No | Platform No | UIC | Description | Qty | Cost | Status | Lot Cond Code | Responsible Party | Location Date | Name | Physical Location | Lot | Contract | Manuf. Date | Next Assy / | Serial No
 |  |  |  | 11223344 | computer | [PHONE] | [NAME] | [NAME] | home |  |  |  |  |  | 07/17/20
 |  |  |  | A012-4GT | monitor | QA118-002980 | [NAME] | [NAME] | home | 1 | 494.46 | ACTIVE |  |  | 04/04/18
 |  |  |  | A012-4GT | monitor | 1930 | [NAME] | E34303 | home | 1 | 513.48 | ACTIVE |  |  | 10/12/16
 |  |  |  | A012-4GT | monitor | QA116-001930 | [NAME] | [NAME] | home | 1 | 519.18 | ACTIVE |  |  | 10/11/18
 |  |  |  |  |  | PRD-[PHONE]
 |  |  |  |  |  | B0090963
 |  |  |  |  |  | 123160529
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A012-4GT | monitor | 1930 | [NAME] | E34303 | home | 1 | 513.48 | ACTIVE |  |  | 10/12/16
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | This serial number does not match one on the Scanned sheet so should not be highlighted BLUE but remain CLEAR