tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 155195d1336712854-excel-2007-using-if-and-row-copy-of-example-2
Sheet: List

ID | COURSE | Section | Title | Enrollment
8222 | PSYC-1001 | 2 | Psychology | 0
8225 | PSYC-1002 | 1 | [NAME] assessment | 0
8227 | PSYC-1001 | 3 | Psychology | 0
8232 | PSYC-1005 | 1 | Cogitive | 0
4231 | PSYC-1001 | 4 | Psychology | 0
3342 | PSYC-1001 | 5 | Psychology | 0
2221 | PSYC-8001 | 2 | Foundations | 0
9944 | PSYC-8008 | 1 | Pysc of leadership | 0
4249 | PSYC-8001 | 3 | Foundations | 0
4443 | PSYC-8001 | 4 | Foundations | 0
4566 | PSYC-8001 | 5 | Foundations | 0
5565 | PSYC-8001 | 6 | Foundations | 0
5511 | COUN-6001 | 2 | Foundations of Coun | 0
4221 | COUN-6001 | 3 | Foundations of Coun | 0
4452 | COUN-6001 | 4 | Foundations of Coun | 0
4423 | COUN-6001 | 5 | Foundations of Coun | 0
6556 | COUN-6001 | 6 | Foundations of Coun | 0
Spreadsheet: 24a6eb35-731d-45d2-ae33-fa69b4f042a7
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 9314.0 Sales of New Motor Vehicles, Australia
 | Table 1: New Motor Vehicles Sales by Type, All series
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Aust. ;  Passenger vehicles ; |  |  | Original | A367169W | 1994-01-01 00:00:00 | 2010-05-01 00:00:00 | 197 | Number | FLOW | Month | 1
Aust. ;  Sports utility vehicles ; |  |  | Original | A367214W | 1994-01-01 00:00:00 | 2010-05-01 00:00:00 | 197 | Number | FLOW | Month | 1
Aust. ;  Other vehicles ; |  |  | Original | A367259A | 1994-01-01 00:00:00 | 2010-05-01 00:00:00 | 197 | Number | FLOW | Month | 1
Aust. ;  Total vehicles ; |  |  | Original | A367304A | 1994-01-01 00:00:00 | 2010-05-01 00:00:00 | 197 | Number | FLOW | Month | 1
Aust. ;  Passenger vehicles ; |  |  | Seasonally Adjusted | A367170F | 1994-01-01 00:00:00 | 2010-05-01 00:00:00 | 197 | Number | FLOW | Month | 1
Aust. ;  Sports utility vehicles ; |  |  | Seasonally Adjusted | A367215X | 1994-01-01 00:00:00 | 2010-05-01 00:00:00 | 197 | Number | FLOW | Month | 1
Aust. ;  Other vehicles ; |  |  | Seasonally Adjusted | A367260K | 1994-01-01 00:00:00 | 2010-05-01 00:00:00 | 197 | Number | FLOW | Month | 1
Aust. ;  Total vehicles ; |  |  | Seasonally Adjusted | A367305C | 1994-01-01 00:00:00 | 2010-05-01 00:00:00 | 197 | Number | FLOW | Month | 1
Aust. ;  Passenger vehicles ; |  |  | Trend | A367171J | 1994-01-01 00:00:00 | 2010-05-01 00:00:00 | 197 | Number | FLOW | Month | 1
Aust. ;  Sports utility vehicles ; |  |  | Trend | A367216A | 1994-01-01 00:00:00 | 2010-05-01 00:00:00 | 197 | Number | FLOW | Month | 1
Aust. ;  Other vehicles ; |  |  | Trend | A367261L | 1994-01-01 00:00:00 | 2010-05-01 00:00:00 | 197 | Number | FLOW | Month | 1
Aust. ;  Total vehicles ; |  |  | Trend | A367306F | 1994-01-01 00:00:00 | 2010-05-01 00:00:00 | 197 | Number | FLOW | Month | 1
© Commonwealth of Australia  2010
Spreadsheet: 836266d1689224609-need-help-in-formula-horizontal-report-to-vertically-report-view-sample
Sheet: Sheet1

ACTUAL DATA |  |  |  |  | CUTTING |  |  |  |  |  |  |  | STITCHING |  |  |  |  |  |  | PACKING
ORDER | LINE# | STYLE | PO# | ORDER QTY | 2023-01-02 00:00:00 |  |  |  |  |  | continue date if the order is balance in the line | TOTAL | 2023-01-02 00:00:00 |  |  |  |  |  | TOTAL | 2023-01-02 00:00:00 |  |  |  |  |  | TOTAL
123 | Line-1 | ABCD | 2002 | 100 | 20 | 30 | 10 | 0 | 0 | 0 |  |  | 10 | 30 | 20 | 0 | 0 | 0 |  | 10 | 30 | 20 | 0 | 0 | 0
1234 | Line-2 | EDFE | 2003 | 300 | 60 | 20 | 40 | 60 | 80 | 40 |  |  | 30 | 50 | 80 | 10 | 50 | 80 |  | 30 | 50 | 80 | 10 | 50 | 80
523 | Line-3 | PHDD | 2004 | 100 | 60 | 20 | 20 | 0 | 0 | 0 |  |  | 30 | 30 | 30 | 10 | 0 | 0 |  | 30 | 30 | 30 | 10 | 0 | 0
6235 | Line-1 | LIHH | 2005 | 50 | 50 | 0 | 0 | 0 | 0 | 0 |  |  | 20 | 10 | 20 | 0 | 0 | 0 |  | 20 | 10 | 20 | 0 | 0 | 0
123 | Line-2 | ABCD | 2002 | 100 | 20 | 20 | 0 | 0 | 0 | 0 |  |  | 40 | 0 | 0 | 0 | 0 | 0 |  | 40 | 0 | 0 | 0 | 0 | 0
Request to make like below by formula
DATE | Department | LINE# | STYLE | PO# | Produced QTY
2023-01-02 00:00:00 | Cutting
2023-01-02 00:00:00 | Stitching
2023-01-02 00:00:00 | Packing
2023-01-03 00:00:00 | Cutting
2023-01-03 00:00:00 | Stitching
2023-01-03 00:00:00 | Packing
2023-01-04 00:00:00 | Cutting
2023-01-04 00:00:00 | Stitching
2023-01-04 00:00:00 | Packing
2023-01-05 00:00:00 | Cutting
2023-01-05 00:00:00 | Stitching
2023-01-05 00:00:00 | Packing
2023-01-06 00:00:00 | Cutting
2023-01-06 00:00:00 | Stitching
2023-01-06 00:00:00 | Packing
2023-01-07 00:00:00 | Cutting
2023-01-07 00:00:00 | Stitching
2023-01-07 00:00:00 | Packing
Spreadsheet: 172797d1344341635-finding-duplicate-cells-and-highlighting-them-c
Sheet: Sheet1

Account Name | [NAME]Postal Code | MID External (Merchant ID) | MID Internal (Merchant ID)
.Com Chrome Ltd
'ZN' |  | 520334507011492 | [PHONE]
(ALMURAD) DOORS TO FLOORS |  | 520334502970403 | [PHONE]
(TA) THE BONHAM |  | 520334502305568 | [PHONE]
(TA) THE BONHAM |  | 520334502305576 | [PHONE]
(WWW.EXPRESS.ME.UK) COSTC |  | 520334502695729 | [PHONE]
@ANGELAS RESTAURANT |  | 520334507134906 | [PHONE]
@ NO 101 |  | 520334502415524 | [PHONE]
@PC`S |  | 520334502880222 | [PHONE]
& BUTTONS LTD |  | 520334502616063 | [PHONE]
& CO |  | 520334502951080 | [PHONE]
0017 JJB SPTS HALIFAX |  | 520334502613359 | [PHONE]
0021 JJB SPTS LISCARD |  | 520334502613367 | [PHONE]
0039 [NAME] |  | 520334502613375 | [PHONE]
0052 JJB SPTS BOOTLE |  | 520334502613383 | [PHONE]
0065 [NAME] CHORLEY |  | 520334502613391 | [PHONE]
0072 [NAME] |  | 520334502613409 | [PHONE]
0077 [NAME] |  | 520334502613417 | [PHONE]
007BEDS.COM |  | 520334507200921 | [PHONE]
007BEDS.COM |  | 520334507200913 | [PHONE]
0092 [NAME] |  | 520334502613425 | [PHONE]
0110 [NAME] |  | 520334502613433 | [PHONE]
0124 [NAME] W'CHESTER |  | 520334502613441 | [PHONE]
0125 [NAME] |  | 520334502613458 | [PHONE]
0126 [NAME] |  | 520334502613466 | [PHONE]
0128 [NAME] |  | 520334502613474 | [PHONE]
0129 JJB SPTS NOTTS |  | 520334502613482 | [PHONE]
1ST STORAGE CENTRES LT |  | 520334502219272 | [PHONE]
1ST STORAGE CENTRES LTD |  | 520334502215577 | [PHONE]
1ST STORAGE CENTRES LTD |  | 520334502096274 | [PHONE]
1st Summer Houses Ltd
1st Systems Ltd
1STTOOLS.CO.UK |  | 520334502789571 | [PHONE]
1 Thirty Six
1 THIRTY SIX |  | 520334502808421 | [PHONE]
1 Thirty Six
1 UP TRAVEL |  | 8259772 | 8.78223E+11
1 UP TRAVEL |  | 000000008259772 | [PHONE]
Spreadsheet: 74a8dc89-ef5a-4983-88eb-7cca7a430ec3
Sheet: Sheet1

LABEL | UPC | ARTIST | TITLE | RELEASEDATE | PRODUCTTYPE | GENRE | PRICE | [NAME] | STATUS
Third Party Entity Merch | 679143054111 | Son Of God | Son Of God Cross Journal | 2014-01-28 | Misc | Na | 19.99 | Y | Available
Third Party Entity Merch | 679143054128 | Son Of God | Son Of God Notecard Set | 2014-01-28 | Misc | Na | 12.99 | N | Available
Fervent For-Sale Merch | 679143012081 | Barlowgirl | Black With Stars All Over One Size Tote Bag | 2008-12-02 | Misc | Na | 19.99 | Y | Available
Fervent For-Sale Merch | 80688751043 | Group 1 Crew | Group 1 Crew Pewter "G1C" Logo Belt Buckle | 2008-01-11 | Misc | Na | 15 | N | Available
Spreadsheet: 51972d1251612377-how-to-create-a-dropdown-list-that-returns-values-that-depends-on-another-cell-697484_surfol
Sheet: Invoice

 |  |  |  |  |  | Cust: | [NAME]
 |  |  |  |  |  | Add:
 |  |  |  |  |  | [NAME]:
 |  |  |  |  |  | City:
 |  |  |  |  |  | Phone:
Product | Type | Size | Color | Qty | Unit Price | Discount | Subtotal
Accessories | Mattress Pad | 100
Accessories | Pillow | 1 Size
XYZ | Box | 160
 |  |  |  |  |  | Total:
 | *** What formula to use in the 'Size' Column above if I want a dropdown list that ONLY shows the size
 | available for that particular product with that particular type. I've managed to make a dropdown list in the
 | Type' column that shows the type available depending on the product entered. But, I don't know how to make
 | a dropdown list in the '[NAME]' column that depends on BOTH the 'product' and 'type' entered.
Spreadsheet: 855154d1704824116-rolling-12-month-absence-caculator-attendance-tracker-template
Sheet: Oct

 | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | October 2024
 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | Leave this month | Working days this month | Absence this month
 |  | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed | Thu
 |  |  |  |  |  |  |  |  |  |  | W
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | V
 |  | H |  |  |  |  |  |  | A
 |  | Legend: W- Working day, P- Part-time, A- [NAME], V- Vacation, H-Holiday, S-Sickness
 | The attendance tracker is provided to you by LeaveBoard.
 | https://leaveboard.com/attendance-tracker/
Spreadsheet: 871134d1717569465-formula-using-scan-or-another-function-scan
Sheet: Sheet1

 | Header | Input | Block #
 | Dataset
 | Image
 | Team Freeze | Y
 | [NAME] | Y
 | Hits released | Y
 | Total Hits
 | P&D status | Y
 | Sourcing status | Y
 | Merchant status | Y
 | Planning status | Y
 | General comments | Y
 | P&D comments | Y
 | Sourcing comments | Y
 | Merchant comments | Y
 | Planning comments | Y
 | Alloc. comments | Y
 | USIM | Y
 | Style | Y
 | Colour
 | Class | Y
 | Class helper
 | Code Sub-class | Y
 | Code
Spreadsheet: 96157d1295568835-how-to-generate-dates-as-per-australian-working-days-automatically-in-excel-test
Sheet: Sheet1

Date Submitted | QR Log Due Date | QR [NAME] | Days Remaining
2010-12-17 00:00:00
2010-09-30 00:00:00
2010-12-08 00:00:00
2010-12-08 00:00:00
2010-12-01 00:00:00
2010-12-14 00:00:00
2010-12-16 00:00:00
2010-12-16 00:00:00
2010-12-17 00:00:00
2010-12-17 00:00:00
2010-12-17 00:00:00
2010-12-17 00:00:00
2010-12-15 00:00:00
2010-12-08 00:00:00
2010-12-08 00:00:00
2010-12-14 00:00:00
2010-12-17 00:00:00
2010-12-15 00:00:00
2010-12-14 00:00:00
2010-12-15 00:00:00
2010-12-17 00:00:00
2010-12-08 00:00:00
2010-12-17 00:00:00
2010-12-17 00:00:00
2010-12-15 00:00:00
2011-01-12 00:00:00
2010-12-15 00:00:00
2010-12-08 00:00:00
2010-12-16 00:00:00
2010-12-21 00:00:00
2010-12-08 00:00:00
2010-12-21 00:00:00
2010-12-14 00:00:00
2010-12-08 00:00:00
2010-12-08 00:00:00
2010-12-29 00:00:00
2010-12-29 00:00:00
2010-12-29 00:00:00
2010-12-29 00:00:00
2010-12-29 00:00:00
2010-12-29 00:00:00
2010-12-29 00:00:00
2010-12-29 00:00:00
2010-12-17 00:00:00
2010-12-15 00:00:00
2010-12-16 00:00:00
2010-12-16 00:00:00
2010-11-29 00:00:00
2010-12-20 00:00:00
2010-12-17 00:00:00
2010-12-17 00:00:00
2010-12-17 00:00:00
2010-12-17 00:00:00
2010-12-17 00:00:00
25/11/2010
25/11/2010
2010-12-17 00:00:00
2010-09-30 00:00:00
2010-12-30 00:00:00
2011-12-20 00:00:00
2010-12-30 00:00:00
2010-12-22 00:00:00
2011-01-12 00:00:00
2011-01-13 00:00:00
2011-01-13 00:00:00
2011-01-13 00:00:00
2010-12-17 00:00:00
2011-12-17 00:00:00
2010-12-17 00:00:00
2011-01-12 00:00:00
2011-01-14 00:00:00
2011-01-12 00:00:00
2011-01-12 00:00:00
2011-01-12 00:00:00
2011-01-12 00:00:00
2010-11-11 00:00:00
2011-01-12 00:00:00
2011-01-12 00:00:00
2011-01-12 00:00:00
2011-01-12 00:00:00
2011-01-12 00:00:00
2011-01-12 00:00:00
2011-01-12 00:00:00
2011-01-12 00:00:00
2011-01-12 00:00:00
2011-01-12 00:00:00
2011-01-12 00:00:00
2011-01-12 00:00:00
2011-01-12 00:00:00
2011-01-12 00:00:00
2011-01-12 00:00:00
2011-01-12 00:00:00
2011-01-12 00:00:00
2011-01-14 00:00:00
2011-01-14 00:00:00
2011-01-14 00:00:00
2011-01-14 00:00:00
2011-01-11 00:00:00
2011-01-11 00:00:00
2011-01-11 00:00:00
2011-01-11 00:00:00
2011-01-14 00:00:00
2011-01-11 00:00:00
2011-01-11 00:00:00
2011-01-11 00:00:00
2011-01-11 00:00:00
Spreadsheet: 526075d1499103315-extract-data-with-multiple-criteria-invoiced-june-2017
Sheet: Summary

 | Pending Invoiced Quantity(Multan Zone)
 | Area | WHs | April | May | Total Urea | Neam Coated Urea
 | Bahawal Pur | Bahawal Pur |  | 10
 | Bahawal Pur | Hasilpur |  | 0
 | Khanewal | Khanewal
 | Khanewal | [NAME]
 | Khanewal | Jehania WH
 | Khanewal | [NAME] |  |  |  | 3
 | Khanewal | Vehari WH
 | [NAME] | [NAME]
 | [NAME] | Chowk Munda
 | Lodhran | Lodhran | 105.15
 | Lodhran | [NAME] |  | 42.5
 | Lodhran | Mailsi WH
 | [NAME] | [NAME]
 | [NAME] | Multan WH
 |  | Total
Spreadsheet: 241325d1370562031-add-multiple-values-into-a-single-row-needs-vba
Sheet: <5

AGENT <5 | Extension | Manager | NMLS | Current | Pending | 1 | 2 | 3 | 4 | 5 | P | P | P | P | P
(new hires)
[NAME] | 5133 | [NAME] | 374080 | 8 | 1 | CA | AZ | FL | IN | MI | NH | OH | OR | TX
[NAME] | 5074 | [NAME] | 256592 | 8 | 0 | CA | CT | DC | MI | NH | NC | OR | TN | TX
[NAME] | 2169 | [NAME] | 380262 | 5 | 5 | CA | IL | IA | IN | (MD) | (MA) | (PA) | (VA) | WA | WI
[NAME] | 2185 | [NAME] | 212075 | 5 | 6
[NAME] | 2166 | [NAME] | 960616 | 4 | 6 | (CA) | IL | (IN) | (MD) | MA | (NH) | (PA) | VA | WA | (NJ)
[NAME] | 5014 | [NAME] | 408262 | 4 | 3 | CA | (MD) | (MA) | TX | (VA) | WA | WI
[NAME] | 2176 | [NAME] | 824434 | 3 | 3 | CA | WA | NC | (MA) | (CO) | (OR)S | (VA)
[NAME] | 5154 | [NAME] | 1035724 | 3 | 3 | MA | (NH) | NC | PA | (VA) | (WA)
[NAME] | 7235 | [NAME] | 876388 | 3 | 6 | CA | IA | (IN) | (MD) | (PA) | (VA) | (WA) | WI | (MA)
[NAME] | 5026 | Darrel Caron | 367136 | 2 | 2 | CA | CO | (NM) | (WA)
Warner Traynham | 5173 | Darrel Caron | 385259 | 2 | 6 | CA | WA | (IA) | (IN) | (LA) | (NH) | (VA) | (WI)
[NAME] | 5045 | [NAME] | 936845 | 2 | 4 | AZ | CA | (MD) | (NH) | (WA) | (WI)
[NAME] | 5158 | Darrel Caron | 395944 | 1 | 4 | CA | (MD) | (NC) | (PA) | (WA)
[NAME] | 5041 | [NAME] | 939232 | 1 | 4 | (CA) | (MD) | MA | (VA) | (WA)
Sandee Evans | 2179 | [NAME] | 885975 | 1 | 0 | CA
[NAME] | 5108 | [NAME] | 980038 | 1 | 3 | CA | (MD) | (MA) | (VA)
[NAME] | 2178 | [NAME] | 48272 | 1 | 7 | (DE) | IA | (IN) | (MD) | (MA) | (PA) | (VA) | (WA)
[NAME] | 5139 | [NAME]
(before 5/2013)
[NAME] | 5117 | [NAME] | 212623 | 5 | 0
[NAME] | 5189 | [NAME] | 389727 | 5 | 1
[NAME] | 5135 | [NAME] | 939951 | 5 | 0
[NAME] | 5178 | [NAME] | 395108 | 5 | 2
[NAME] | 7226 | [NAME] | 918814 | 5 | 0
[NAME] | 5186 | [NAME] | 998019 | 4 | 1
[NAME] | 5181 | [NAME] | 920777 | 4 | 2
[NAME] | 5169 | [NAME] | 257014 | 4 | 2
[NAME] | 7232 | [NAME] | 391486 | 4 | 0
[NAME] | 5172 | [NAME] | 847036 | 3 | 2
[NAME] | 2173 | [NAME] | 881411 | 3 | 0
[NAME] | 5178 | [NAME] | 391465 | 2 | 3
[NAME] | 5188 | [NAME] | 366059 | 1 | 4
[NAME] | 5190 | [NAME] | 989923 | 1 | 4
Spreadsheet: 856771d1705946377-check-multiple-conditions-for-proper-value-topstep
Sheet: TAX

 | FED TAX TABLE
 | Gain
 | Tax Rate
 | M-to-M | No
 | INCOME | RATE
 |  | 0.1
 | 19900 | 0.12
 | 81050 | 0.22
 | 172750 | 0.24
 | 329850 | 0.32
 | 418850 | 0.35
 | 628300 | 0.37
Spreadsheet: 65053d1265816449-compare-and-count-value-repetitions-book5
Sheet: Sheet1

8 | 2 | 22 | 34 | 20 | 24 | 60 |  | 4
4 | 16 | 22 | 174 | 30 | 32 | 180
2 | 12 | 14 | 22 | 24 | 50 | 60
4 | 6 | 22 | 28 | 34 | 40 | 42
17 | 44 | 24 | 176 | 36 | 132 | 46
2 | 6 | 22 | 28 | 52 | 54 | 60
6 | 2 | 20 | 30 | 34 | 60 | 80
Spreadsheet: 864525d1711653229-count-instances-or-frequency-multiple-sheets-counting-position-appearances-in-baseball-excel-help-forum-roster-template-2024-03-22-mattg-
Sheet: Game 5

Date: |  | 2024-05-01 00:00:00 |  |  | Field: |  |  | Start Time: |  | 18:00:00
Home: |  |  |  |  | 3rd | Set Up
Visitors: |  |  |  |  | 1st | Clean Up
 |  |  |  |  | Inning
 |  | Player |  |  | Coach Pitch |  |  |  |  |  | Innings on Bench | Innings in Infield | Inninings in Outfield |  |  |  | [NAME]
Order |  | First | Last | # | 1 | 2 | 3 | 4 | 5 | 6
1 | 12 | [NAME] |  |  | 1B (3) | 1B (3) | 1B (3) | LF (7) | LF (7) | LF (7) |  |  |  |  | P (1)
2 | 11 | Ty |  |  | 2B (4) | 2B (4) | 2B (4) | RF (9) | RF (9) | RF (9) |  |  |  |  | C (2)
3 | 1 | [NAME] |  |  | 3B (5) | 3B (5) | 3B (5) | LCF () | LCF () | LCF () |  |  |  |  | 1B (3)
4 | 2 | [NAME] |  |  | LF (7) | LF (7) | LF (7) | 1B (3) | 1B (3) | 1B (3) |  |  |  |  | 2B (4)
5 | 4 | [NAME] |  |  | P (1) | P (1) | P (1) | [NAME] () | [NAME] () | [NAME] () |  |  |  |  | 3B (5)
6 | 5 | Willie |  |  | X | RF (9) | RF (9) | 3B (5) | 3B (5) | 3B (5) |  |  |  |  | SS (6)
7 | 10 | [NAME] |  |  | RF (9) | X | SS (6) | SS (6) | C (2) | C (2) |  |  |  |  | LF (7)
8 | 9 | [NAME] |  |  | SS (6) | SS (6) | X | 2B (4) | 2B (4) | 2B (4) |  |  |  |  | CF (8)
9 | 6 | Babe |  |  | LCF () | LCF () | LCF () | X | SS (6) | SS (6) |  |  |  |  | RF (9)
10 | 7 | [NAME] |  |  | C (2) | C (2) | [NAME] () | P (1) | X | P (1) |  |  |  |  | SF (10)
11 | 8 | [NAME] |  |  | [NAME] () | [NAME] () | C (2) | C (2) | P (1) | X |  |  |  |  | EH ()
12 | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  | LCF ()
13 | 8 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] ()
Out |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Roster pulled from list on roster tab
 | 9
 | 9
Notes:
 |  |  |  | Players on [NAME]
 |  | Only pull a players first name from the drop down
Spreadsheet: 77030d1277472286-auto-color-filling-only-on-the-another-sheet-in-excel-2007-trainingrecordconditionalformat1
Sheet: Training Plan

Sl. No. | Names | January | February | March | April | May | June | July | August
1 | [NAME] | 1
2 | [NAME] |  |  |  |  |  |  |  | 2
Key
1 | Customer Care
2 | QA Operating Procedures
3 | Minutes of Meeting
CONDITIONAL FORMATING STATEMENTS
Green
Red
Spreadsheet: 121891d1316489912-how-to-search-value-to-use-using-multiple-criteria-matrix-sip-expected-result
Sheet: Matrix

 |  | Eceran | 0.3 |  |  |  |  | Eceran | 0.3 |  |  |  |  | Eceran | 0.3
 |  | Qty | UnitPrice | Level A | Level B | Level C |  | Qty | UnitPrice | Level A | Level B | Level C |  | Qty | UnitPrice | Level A | Level B | Level C
 |  | 25 | 0.25 | 0.25 | 0.25 | 0.25 |  | 25 | 0.25 | 0.25 | 0.25 | 0.25 |  | 25 | 0.25 | 0.25 | 0.25 | 0.25
 |  | 500 | 0.15 | 0.25 | 0.15 | 0.15 |  | 500 | 0.15 | 0.25 | 0.15 | 0.15 |  | 500 | 0.15 | 0.25 | 0.15 | 0.15
 |  | 1000 | 0.15 | 0.25 | 0.15 | 0.15 |  | 1000 | 0.15 | 0.25 | 0.15 | 0.15 |  | 1000 | 0.15 | 0.25 | 0.15 | 0.15
 |  | 5000 | 0.15 | 0.25 | 0.15 | 0.15 |  | 5000 | 0.15 | 0.25 | 0.15 | 0.15 |  | 5000 | 0.15 | 0.25 | 0.15 | 0.15
 |  | Eceran Pembulatan |  | 50 |  |  |  | [NAME] |  | 60 | hari
 |  | Level A Pembulatan |  | 50 |  |  |  | PPN |  | 0.1
 |  | Level B Pembulatan |  | 50
 |  | Level C Pembulatan |  | 25
 |  | Cost Pembulatan |  | 1
 | [NAME] | Actual Cost / Lbr | Matrix | Factory  Pricelist | Lbr/slop | Lbr/box |  | Tgl update
 | SIP cup 8oz Ro78C-85 BP (Lbr) |  | Umum | 410 | 25 | 500 |  | 2011-05-19 00:00:00
 | SIP cup 8oz Ro78C-85 ([NAME]) |  | Umum | 400 | 25 | 500 |  | 2011-05-19 00:00:00
 | SIP cup Sundae Ro78SU-BS (Lbr) |  | Umum | 380 | 25 | 500 |  | 2011-05-19 00:00:00
 | SIP cup 10oz Ro78C-100 (Lbr) |  | Umum | 410 | 25 | 500 |  | 2011-05-19 00:00:00
 | SIPcup12ozNEW Ro92.5C-106(Lbr) |  | Umum | 660 | 25 | 500 |  | 2011-05-19 00:00:00
 | SIPcup12ozOLD Ro98.5C-105(Lbr) |  | Umum | 680 | 25 | 500 |  | 2011-05-19 00:00:00
 | SIPcup14ozNEW Ro98.5C-103(Lbr) |  | Umum | 600 | 25 | 500 |  | 2011-05-19 00:00:00
 | SIP cup 16oz Ro98.5C-120 (Lbr) |  | Umum | 775 | 25 | 500 |  | 2011-05-19 00:00:00
 | SIP Small cup Ro60C.78 ([NAME]) |  | Umum | 180 | 25 | 500 |  | 2011-05-19 00:00:00
 | SIP cup 20oz Ro92.5C-135 ([NAME]) |  | Umum | 800 | 25 | 500 |  | 2011-05-19 00:00:00
 | SIP cup 24oz Ro98.5C-155 (Lbr) |  | Umum | 825 | 25 | 500 |  | 2011-05-19 00:00:00
 |  |  |  |  |  |  |  | 2011-05-19 00:00:00
 |  |  |  |  |  |  |  | 2011-05-19 00:00:00
 |  |  |  |  |  |  |  | 2011-05-19 00:00:00
 |  |  |  |  |  |  |  | 2011-05-19 00:00:00
 |  |  |  |  |  |  |  | 2011-05-19 00:00:00
 |  |  |  |  |  |  |  | 2011-05-19 00:00:00
 |  |  |  |  |  |  |  | 2011-05-19 00:00:00
Spreadsheet: 72487d1273169093-tertiary-vertical-axis-3d_rotate
Sheet: 3d Rotate

Original | Xcoord | Ycoord | Zcoord |  | Dervied | Xcoord | Ycoord |  |  | Calculated Angles
One | -0.1117246087321648 | 0.2054002603718788 | -0.6652008754457006 |  |  |  |  |  |  |  |  |  | Sin values
Two | 0.4667011298819637 | -0.4858785158007024 | -0.527028496103987 |  |  |  |  |  |  |  |  |  | Cos values
Three | -0.1143900996065126 | -0.5772414357385529 | 0.3732462294049208
Four | 0.6216588269919763 | -0.3309579975016829 | 0.6556897813149911 |  |  |  |  |  |  | Rotation Matrix
Five | -0.3293254429830463 | -0.1289439473900871 | 0.09962947826005841
Six | -0.4780522373075418 | 0.0070712524768064 | -0.2661857175570425
Seven | 0.2565737158329708 | -0.4409559474901827 | -0.1265169529791512
Eight | -0.335940165655628 | 0.3686365753866498 | -0.9167072582836255
Nine | -0.06096983989746629 | 0.5024461452515334 | 0.202092856339869 |  |  |  |  |  |  | Angle of rotation for chart
Ten | 0.4655001502544041 | 0.5778439403225291 | -0.5764098739455368
 |  |  |  |  |  |  |  |  |  | X Angle | 3
 |  |  |  |  |  |  |  |  |  | Y Angle | 3
 |  |  |  |  |  |  |  |  |  | Z Angle | 5
 |  |  |  |  |  |  |  |  |  | Axes | X | Y | Z
 |  |  |  |  |  |  |  |  |  |  | -1 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | -1 | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 1 | 0
 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | -1
 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 1
 |  |  |  |  |  |  |  |  |  | Cage | X | Y | Z
 |  |  |  |  |  |  |  |  |  |  | -1 | -1 | -1
 |  |  |  |  |  |  |  |  |  |  | 1 | -1 | -1
 |  |  |  |  |  |  |  |  |  |  | 1 | 1 | -1
 |  |  |  |  |  |  |  |  |  |  | -1 | 1 | -1
 |  |  |  |  |  |  |  |  |  |  | -1 | -1 | -1
 |  |  |  |  |  |  |  |  |  |  | -1 | -1 | 1
 |  |  |  |  |  |  |  |  |  |  | 1 | -1 | 1
 |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  | -1 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  | -1 | -1 | 1
 |  |  |  |  |  |  |  |  |  |  | -1 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  | -1 | 1 | -1
 |  |  |  |  |  |  |  |  |  |  | 1 | 1 | -1
 |  |  |  |  |  |  |  |  |  |  | 1 | 1 | 1
 |  |  |  |  |  |  |  |  |  |  | 1 | -1 | 1
 |  |  |  |  |  |  |  |  |  |  | 1 | -1 | -1