tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 889865d1740838119-gannt-chart-conditional-formating-for-weekdays-fund-finance-wa-calendar-danielle87-test-1-
Sheet: Recipient

Discussion of Monthly Calendar must include the ff:
Onshore Managers
[NAME]
Cynthea
[NAME]
[NAME]
[NAME]
[NAME]
Ser Hui [NAME]
[NAME]
[NAME]
Note: All Property Funds leads must be included in the discussion of monthly calendar
Property Accounting Team
Cherissa
Annaliza
Annabelle
[NAME]
Maica
Angelica
Sharlyn
[NAME]
Renver Araullo
[NAME]
[NAME]
[NAME]
[NAME] Borcelango
System Support
Krystal
Spreadsheet: 683606d1592843916-daily-task-timesheet-with-standard-9-hours-per-person-timesheet-how-to-list-daily-tasks-efficiently
Sheet: Sheet1

Date | Person | Week | Quarter | Service Name | Service Group | Task Details | Hours Planned | Hours Actual | % Utilization | Hours Category
2020-01-01 00:00:00 | P-1 | 1 | Q1-2020 | PM/Technical Support | CRSF | Meeting with client | 9 | 9 |  | Billable
2020-01-01 00:00:00 | P-1 | 1 | Q1-2020 | PM/Technical Support | CRSF | Follow up with Vendor |  |  |  | Billable
2020-01-01 00:00:00 | P-1 | 1 | Q1-2020 | PM/Technical Support | CRSF | Working on Deliverable |  |  |  | Billable
2020-01-01 00:00:00 | P-1 | 1 | Q1-2020 | PM/Technical Support | CRSF | Co-ordination with Project team |  |  |  | Billable
2020-01-02 00:00:00 | P-2 | 2 | Q1-2020 | Testing Support | AAA | Design work for PKBLIST | 9 | 9 |  | Billable
2020-01-02 00:00:00 | P-2 | 2 | Q1-2020 | Testing Support | AAA | Planning for Line trials |  |  |  | Billable
2020-01-02 00:00:00 | P-2 | 2 | Q1-2020 | Testing Support | AAA | Preparing TR for Site xxx |  |  |  | Billable
 |  |  |  |  |  |  |  | Hours will have to written only once for the date & not for every task
 | How can we automate all rows after the 1st one written by any person for the same date
 | so that he does not have to fill reptitively the same date & his name |  |  |  |  |  | No. of tasks listed for the day (1-Jan-20)
 |  |  |  |  |  | No. of tasks listed for the day (8-Jan-20)
HELP
1 | What is the best way to list all tasks without having to enter all other info for every row for the same person for the same date? (all dark pink highlights)
2 | Pink colored cells will be all repetitive info ---> |  |  |  | How to automate this so that every person is not required to write the same info again for the same date?
3 | OR should I maintain 2 separate sheets, i.e. one for Timesheet, to enter only hours for the date & the other for Tasks ( I don’t prefer this option)
Spreadsheet: 888653d1739222042-change-format-of-data-diabetes-27-apr-2017-to-23-april-2018
Sheet: Table 3

00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
Sun 14 May Glucose mmol/L
Mon 15 May Glucose mmol/L
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
Tue 16 May Glucose mmol/L
Wed 17 May Glucose mmol/L
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
Thu 18 May Glucose mmol/L
Fri 19 May Glucose mmol/L
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
00:00 | 02:00 |  | 04:00 |  | 06:00 |  | 08:00 |  | 10:00 |  | 12:00 |  | 14:00 |  | 16:00 |  | 18:00 |  | 20:00 |  | 22:00 |  | 00:00
Sat 20 May Glucose mmol/L
Legend          High Glucose (>13.3)            Low Glucose (<3.9)
Sun 21 May Glucose mmol/L
Spreadsheet: 150408d1334509566-return-right-value-from-list-formula-problem2
Sheet: Ark1

1 |  | 1 | 30 |  |  | 1
2 |  | 1 | 40
3 |  | 1 | 50
4 |  | 2 | 60
 |  | 2 | 70
 |  | 2 | 80
 |  | 2 | 90
 |  | 2 | 100
 |  | 3 | 110
 |  | 3 | 120
 |  | 3 | 130
 |  | 3 | 140
 |  | 4 | 150
 |  | 4 | 160
 |  | 4 | 170
 |  | 4 | 180
 |  | 4 | 190
Spreadsheet: 33121d1229411889-auto-summarise-summary-list-2ways
Sheet: Sheet1

 |  |  | Summary
 |  |  | Account | Value
 |  |  | 1000 | 109 |  | 109
 |  |  | 1001 | 116 |  | 116
 |  |  | 1003 | 33 |  | 33
 |  |  | 1005 | 118 |  | 118
 |  |  | 1006 | 222 |  | 222
 |  |  | 1007 | 172 |  | 172
Generate this summary |  |  | 1008 | 25 |  | 25
list from the detail below |  |  | 1010 | 77 |  | 77
 |  |  | 1012 | 60 |  | 60
 |  |  | 1015 | 60 |  | 60
 |  |  | 1016 | 67 |  | 67
 |  |  | 1017 | 97 |  | 97
 |  |  | 1019 | 36 |  | 36
 |  |  | 1020 | 31 |  | 31
 |  |  |  | 1223 |  | 1223
 |  |  | [NAME]
 |  |  | Account | Value |  | Sum of Value
 |  |  | 1012 | 60 |  | Account | Total
 |  |  | 1016 | 35 |  | 1000 | 109
 |  |  | 1017 | 38 |  | 1001 | 116
 |  |  | 1008 | 25 |  | 1003 | 33
 |  |  | 1017 | 59 |  | 1005 | 118
 |  |  | 1007 | 60 |  | 1006 | 222
 |  |  | 1000 | 38 |  | 1007 | 172
 |  |  | 1010 | 36 |  | 1008 | 25
 |  |  | 1006 | 19 |  | 1010 | 77
 |  |  | 1016 | 16 |  | 1012 | 60
 |  |  | 1006 | 33 |  | 1015 | 60
 |  |  | 1006 | 33 |  | 1016 | 67
 |  |  | 1015 | 30 |  | 1017 | 97
 |  |  | 1005 | 59 |  | 1019 | 36
 |  |  | 1001 | 58 |  | 1020 | 31
 |  |  | 1007 | 56 |  | Grand Total | 1223
 |  |  | 1006 | 19
 |  |  | 1016 | 16
 |  |  | 1006 | 33
 |  |  | 1006 | 33
 |  |  | 1015 | 30
 |  |  | 1005 | 59
 |  |  | 1001 | 58
 |  |  | 1007 | 56
 |  |  | 1000 | 29
 |  |  | 1019 | 36
 |  |  | 1020 | 31
 |  |  | 1010 | 16
 |  |  | 1006 | 52
 |  |  | 1003 | 33
 |  |  | 1010 | 25
 |  |  | 1000 | 42
 |  |  |  | 1223
Spreadsheet: 18cac5fa-3901-407a-adc8-079e7d607e86
Sheet: GYE GRUPO Y ESTRATEGIA SAS

ESTUDIO [NAME]
ICFES-CP-006-2013.-OBJETO: [NAME] [NAME] contrato de prestación de servicios de aseo, [NAME] necesarios [NAME] y preservación de los bienes muebles e inmuebles del ICFES, al igual que los servicios de cafetería para brindar el apoyo necesario que contribuya [NAME], incluyendo el suministro de los insumos requeridos [NAME] y el servicio de cafetería, todo lo cual es fundamental [NAME] y óptimo funcionamiento del ICFES.
S U B D I R E C C I O N   F I N A N C I E R A   Y   C O N T A B L E
PROPONENTE: |  | GYE GRUPO Y ESTRATEGIA S A S
NIT: |  | 860.522.931-2
DOCUMENTOS SOLICITADOS |  |  |  | SI | NO | SI | FOLIO
BALANCE GENERAL A 31 DE DICIEMBRE DE 2012 |  |  |  | X |  |  | 6
ESTADO DE RESULTADOS A 31 DE DICIEMBRE DE 2012 |  |  |  | X |  |  | 7
DECLARACION DE RENTA DEL AÑO 2012 |  |  |  | X |  |  | 31
REGISTRO UNICO TRIBUTARIO RUT |  |  |  |  | N/A
NOTAS A LOS ESTADOS FINANCIEROS |  |  |  | X |  |  | 11 A  19
[NAME] |  |  |  | X |  |  | 20
DICTAMEN REVISOR FISCAL O CONTADOR INDEPENDIENTE |  |  |  | X |  |  | 21 A 22
FOTOCOPIA MATRICULA CONTADOR PUBLICO |  |  |  | X |  |  | 24
CERTIFICADO ANTECEDENTES DISCIPLINARIOS DEL CONTADOR |  |  |  | X |  |  | 26
FOTOCOPIA MATRICULA REVISOR FISCAL O C.P. INDEPENDIENTE |  |  |  | X |  |  | 28
CERTIFICADO ANTECEDENTES DISCIPLINARIOS DEL REVISOR FISCAL O C.P. INDEPENDIENTE |  |  |  | X |  |  | 27
I N D I C A D O R E S   F I N A N C I E R O S
1. CAPITAL DE TRABAJO = ACTIVO CORRIENTE - PASIVO CORRIENTE = Ó > AL 20% VPO ($566.796.100.00) *(1)
CAPITAL DE TRABAJO = AC - PC |  |  |  |  |  |  | CUMPLE
 |  | 7093387753 | AC
 |  | 3501697966 | PC
VR MINIMO CAPITAL DE TRABAJO |  |  |  | 0.2
2.NIVEL DE ENDEUDAMIENTO = (PASIVO TOTAL / ACTIVO TOTAL) X 100 = Ò < AL 70% DEL ACTIVO TOTAL
NIVEL DE ENDEUDAMIENTO = PT / AT |  |  |  |  |  |  | CUMPLE
 |  | 4789330699 | PT
 |  | 9989947055 | AT
3. INDICE PATRIMONIAL = PATRIMONIO DEL PROPONENTE (PTR) / VALOR DEL PRESUPUESTO OFICIAL (VPO) = Ó > A 0.5 (CERO PUNTO CINCO)
INDICE PATRIMONIAL = (PTR) / (VPO) |  |  |  |  |  |  | CUMPLE
 |  | 5200616356 | PTR
 |  | 566796100 | VPO
O B S E R V A C I O N E S :
*(1)  El capital de Trabajo se evaluo con [NAME] 20% (igual o mayor), por  principio de favorabilidad según lo informado via correo electrónico por la Subdirección de Abastecimiento.
ELABORADO: NOHORA TRIANA ROA |  |  | REVISADO : [NAME]
APROBADO: CARLOS GERMAN PLAZAS BONILLA |  |  | FECHA: 15 DE MAYO DE 2013
Spreadsheet: louise_kitchen__24046__East Power Consolidation
Sheet: Options

 |  | 2001-09-01 00:00:00 |  | 2001-09-01 00:00:00 |  | %
 |  | YTD Actual |  | Annualized |  | of Total
ENACOMP | Compensation
 | Special Pays | 115000
 | Analysts & Associates
ENABENTX | Benefits & Payroll Taxes
ENAEMPEX | Employee Expense
ENAT&EEX | Travel & Entertainment Expense
ENAOUTSV | Outside Services
ENASUPP | Supplies Expense
ENAMKTEX | Marketing
ENACONTR | Charitable Contributions
ENARENT | Rent
ENATECH | Technology
ENATRANS | Transportation
ENAOTHEX | Other Expenses
ENATAXES | Taxes Other than Income
ENATOTDR | Total Direct Expenses
 | Headcount |  |  | 4
 | Analyst & Associate Headcount |  |  | 1
 | Total Headcount
ENAOUTLG | Outside Legal
ENAOUTTX | Outside Tax
ENAINSUR | Insurance
ENASYSDV | System Development
ENACORIT | Controllable Infrastructure
ENACORRN | Corporate Rent
ENAOTHAL | Other Allocated Direct  Expenses
ENADEPR | Depreciation & Amortization
Spreadsheet: 39706d1237994372-can-excel-create-shapes-using-numberial-data-graph-perhaps-shape-of-business
Sheet: Shape of the Business

 | Shape of the Business
 |  | Lvl 1 | Lvl 2 | Lvl 3 | Lvl 4 | Lvl 5 | Lvl 6 | Lvl 7 | TOTAL
 | 2005 | 882 | 970 | 1017 | 637 | 514 | 94 | 132 | 4246
 |  | 0.2077249175694772 | 0.2284503061705134 | 0.2395195478097032 | 0.1500235515779557 | 0.1210551106924164 | 0.02213848327837965 | 0.0310880829015544
 | 2006 | 735 | 864 | 954 | 587 | 536 | 134 | 134 | 3944
 |  | 0.1863590263691683 | 0.2190669371196755 | 0.2418864097363083 | 0.1488336713995943 | 0.1359026369168357 | 0.03397565922920893 | 0.03397565922920893
 | 2007 | 563 | 725 | 805 | 526 | 551 | 162 | 129 | 3461
 |  | 0.1626697486275643 | 0.2094770297601849 | 0.2325917364923432 | 0.1519791967639411 | 0.1592025426177405 | 0.04680728113262063 | 0.03727246460560531
 | 2008 | 482 | 587 | 621 | 438 | 459 | 147 | 105 | 2839
 |  | 0.1697780908770694 | 0.2067629446988376 | 0.2187389926030292 | 0.1542796759422332 | 0.1616766467065868 | 0.05177879535047552 | 0.03698485382176823
 | 2009 | 344 | 536 | 649 | 496 | 511 | 171 | 117 | 2824
 |  | 0.1218130311614731 | 0.1898016997167139 | 0.2298158640226629 | 0.1756373937677054 | 0.1809490084985836 | 0.06055240793201133 | 0.04143059490084986
Spreadsheet: 739100d1625506604-macro-to-compare-references-and-values-and-extract-items-not-matching-to-a-seperate-sheet-macro-to-compare-ref-numbers-and-extract-items-that-do-not-match
Sheet: Purchase Ledger

Code | Name | Transaction Category Type | Period Year | Reference | Date Processed | Balance
PRT905 | FQTRS LTD | Invoice | 2021 | 634985 | 03-MAY-2021 | 620.75
PRT905 | FQTRS LTD | Invoice | 2021 | 634654 | 03-MAY-2021 | 400.35
PRT905 | FQTRS LTD | Invoice | 2021 | 9285 | 03-MAY-2021 | 415.75
PRT905 | FQTRS LTD | Invoice | 2021 | 9290 | 04-MAY-2021
PRT905 | FQTRS LTD | Invoice | 2021 | 9305 | 05-MAY-2021
PRT905 | FQTRS LTD | Invoice | 2021 | 9320 | 05-MAY-2021
PRT905 | FQTRS LTD | Invoice | 2021 | 635080 | 06-MAY-2021 | 88.5
PRT905 | FQTRS LTD | Invoice | 2021 | 9334 | 06-MAY-2021
PRT905 | FQTRS LTD | Invoice | 2021 | 9338 | 06-MAY-2021
PRT905 | FQTRS LTD | Invoice | 2021 | 634958 | 03-MAY-2021 | 705.65
PRT905 | FQTRS LTD | Invoice | 2021 | 635146 | 03-MAY-2021 | 730.25
PRT905 | FQTRS LTD | Invoice | 2021 | 635196 | 06-MAY-2021 | 801.75
Spreadsheet: 851396d1701640314-formula-to-automatically-make-a-list-off-another-sheets-info-problem1-rev1-pyplynr-
Sheet: Sheet1

 |  |  | Sheet 1
Ship ID | Don't [NAME] | Don't Need Info2 | Don't Need Info3 | Don't Need Info4 | Don't Need Info5 | Order ID | [NAME] | Ship Date | Don't Need Info6 | Don't Need Info7 | Express | Don't Need Info8 | Don't Need Info9 | Don't Need Info10 | Don't Need Info11 | Don't Need Info12 | Don't Need Info13 | Don't Need Info14 | Due date
543 | X | X | X | X | X | 22 | Air | 2023-10-25 00:00:00 | X | X | Yes | X | X | X | X | X | X | X | 2024-04-02 00:00:00
722 | X | X | X | X | X | 25 | Air | 2023-07-08 00:00:00 | X | X | No | X | X | X | X | X | X | X | 2023-12-15 00:00:00
643 | X | X | X | X | X | 26 | Land | 2023-01-20 00:00:00 | X | X | Yes | X | X | X | X | X | X | X | 2023-06-29 00:00:00
986 | X | X | X | X | X | 68 | Air | 2023-11-15 00:00:00 | X | X | Yes | X | X | X | X | X | X | X | 2024-04-23 00:00:00
223 | X | X | X | X | X | 72 | Land | 2023-08-19 00:00:00 | X | X | Yes | X | X | X | X | X | X | X | 2024-01-26 00:00:00
510 | X | X | X | X | X | 98 | Land | 2023-08-31 00:00:00 | X | X | Yes | X | X | X | X | X | X | X | 2024-02-07 00:00:00
473 | X | X | X | X | X | 47 | Land | 2023-06-13 00:00:00 | X | X | No | X | X | X | X | X | X | X | 2023-11-20 00:00:00
435 | X | X | X | X | X | 35 | Land | 2023-04-01 00:00:00 | X | X | No | X | X | X | X | X | X | X | 2023-09-08 00:00:00
397 | X | X | X | X | X | 19 | Air | 2023-02-05 00:00:00 | X | X | No | X | X | X | X | X | X | X | 2023-07-15 00:00:00
600 | X | X | X | X | X | 66 | Air | 2023-05-23 00:00:00 | X | X | No | X | X | X | X | X | X | X | 2023-10-30 00:00:00
322 | X | X | X | X | X | 74 | Land | 2023-12-28 00:00:00 | X | X | No | X | X | X | X | X | X | X | 2024-06-05 00:00:00
285 | X | X | X | X | X | 11 | Land | 2023-09-10 00:00:00 | X | X | Yes | X | X | X | X | X | X | X | 2024-02-17 00:00:00
247 | X | X | X | X | X | 17 | Air | 2023-10-20 00:00:00 | X | X | No | X | X | X | X | X | X | X | 2024-03-28 00:00:00
Spreadsheet: 848738d1699380527-combine-aggregated-lists-in-to-a-separate-combined-list-aggregated-lists-power-query
Sheet: Combined

Ref NO | Vehicle | Colour
ABC003 | Train | BLUE
ABC001 | Train | BLUE
ABC008 | Car | YELLOW
ABC009 | Car | YELLOW
ABC007 | Car | YELLOW
ABC013 | Car | YELLOW
Spreadsheet: 781045d1652955831-lookup-value-in-nth-occurence-without-using-arrays-with-multiple-criteria-vloookup-nth-occurence-aligw
Sheet: VLOOOKUP Nth OCCURENCE

 | DATA |  |  | OUTPUT
 | Emp ID | REMARK |  | Emp ID | REMARK
 | 100 |  |  | 100 |  | Using VLOOKUP this will give blank results so how do we get the first Text Value ignoring BLANK and " " Values in the cells
 | 100 |  |  | 200
 | 100 | A |  | 300
 | 100
 | 100
 | 200 | B
 | 200
 | 200
 | 300
 | 300
 | 300
 | 300 | C
Spreadsheet: 105006d1302503689-excel-2008-excel-2008-filter-problem-when-images-placed-test
Sheet: Sheet1

Sr. No. | Image | Artist Name
1 | 1 | Abedin, Zainul
3 | 3 | Abedin, Zainul
5 | 5 | Abedin, Zainul
2 | 2 | Aich, [NAME]
4 | 4 | Aich, [NAME]
6 | 6 | Aich, [NAME]
Spreadsheet: 228388d1366105079-please-help-me-d-quotation
Sheet: Summary

Count of Softshell | Column Labels |  |  |  |  | Values
Row Labels | Black | Red | Grand Total |  | Row Labels | Sum of Red | Sum of Black
Fleece | 1 | 4 | 5 |  | Softshell | 8 | 6
Hardshell | 10 | 10 | 20 |  | Hardshell | 10 | 10
Softshell | 6 | 8 | 14 |  | Grand Total | 22 | 17
Grand Total | 17 | 22 | 39 |  | Fleece | 4 | 1
 |  |  |  |  | Grand Total | 44 | 34
Spreadsheet: 703806d1605184206-converting-a-small-amount-of-data-into-a-row-demo
Sheet: Sheet1

 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | Sum | no of boxes | items per box | part full box 1 | part full box 2 | part full box 3 | part full box 4
 |  |  |  |  |  |  |  |  |  |  |  | 3 | 50 | 12
 |  |  |  |  |  |  |  |  |  |  |  | 2 | 10 | 2 | 2 | 2 | 3
 |  |  |  |  |  |  |  |  |  |  |  | 1 | 30
 |  |  |  |  |  |  |  |  |  |  |  | 5 | 25 | 23
 |  |  |  |  |  |  |  |  |  |  |  | 3 | 25
 |  |  |  |  |  |  |  |  |  |  |  | 1 | 25
 |  |  |  |  |  |  |  |  |  |  |  | 8 | 56 | 12
 |  |  |  |  |  |  |  |  |  |  |  | 2 | 55
 |  |  |  |  |  |  |  |  |  |  |  | 1 | 100 | 10 | 45 | 37
 |  |  |  |  |  | What I currently have demonstrating formula I am using.
 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | Sum | no of boxes | items per box | part full box 1 | part full box 2 | part full box 3 | part full box 4
 | 50 | 50 | 50 | 12 |  |  |  |  |  |  |  | 3 | 50 | 12
 | 10 | 10 | 2 | 2 | 2 | 3 |  |  |  |  |  | 2 | 10 | 2 | 2 | 2 | 3
 | 30 |  |  |  |  |  |  |  |  |  |  | 1 | 30
 | 25 | 25 | 25 | 25 | 25 | 23 |  |  |  |  |  | 5 | 25 | 23
 | 25 | 25 | 25 |  |  |  |  |  |  |  |  | 3 | 25
 | 25 |  |  |  |  |  |  |  |  |  |  | 1 | 25
 | 56 | 56 | 56 | 56 | 56 | 56 | 56 | 56 | 12 |  |  | 8 | 56 | 12
 | 55 | 55 |  |  |  |  |  |  |  |  |  | 2 | 55
 | 100 | 10 | 45 | 37 |  |  |  |  |  |  |  | 1 | 100 | 10 | 45 | 37
 |  |  |  |  |  | The result I need the formula to show
Spreadsheet: 0aaf95d3-9475-4621-b6ab-6164add3649a
Sheet: Sheet1

#5  Transfer | MSJC 6 Year Transfer Rate
 | AY01-02 |  |  | AY02-03 |  |  | AY03-04 |  |  | AY04-05 |  |  | AY05-06
Gender | Transferred | cohort | Transfer Rate | Transferred | cohort | Transfer Rate | Transferred | cohort | Transfer Rate | Transferred | cohort | Transfer Rate | Transferred | cohort | Transfer Rate
Female | 258 | 758 |  | 261 | 778 |  | 218 | 616 |  | 249 | 706 |  | 279 | 728
Male | 160 | 467 |  | 146 | 404 |  | 135 | 368 |  | 179 | 466 |  | 164 | 428
Unknown | 17 | 42 |  | 16 | 45 |  | 8 | 35 |  | 3 | 10 |  | 5 | 12
Total
Ethnicity | Transferred | cohort | Transfer Rate | Transferred | cohort | Transfer Rate | Transferred | cohort | Transfer Rate | Transferred | cohort | Transfer Rate | Transferred | cohort | Transfer Rate
White | 279 | 777 |  | 258 | 737 |  | 224 | 617 |  | 237 | 652 |  | 245 | 604
Hispanic | 84 | 277 |  | 77 | 259 |  | 74 | 211 |  | 89 | 276 |  | 99 | 301
African American | 19 | 61 |  | 14 | 43 |  | 10 | 26 |  | 14 | 48 |  | 15 | 44
Asian | 8 | 28 |  | 23 | 44 |  | 9 | 23 |  | 18 | 32 |  | 21 | 42
Native American | 5 | 11 |  | 6 | 7 |  | 1 | 8 |  | 5 | 13 |  | 5 | 14
Filipino | 7 | 24 |  | 9 | 30 |  | 9 | 43 |  | 21 | 50 |  | 20 | 40
Pacific Islander | 1 | 7 |  | 4 | 11 |  | 1 | 4 |  | 5 | 9 |  | 2 | 12
Multi-Race
Unknown | 32 | 82 |  | 32 | 96 |  | 33 | 87 |  | 42 | 102 |  | 41 | 111
Age | Transferred | cohort | Transfer Rate | Transferred | cohort | Transfer Rate | Transferred | cohort | Transfer Rate | Transferred | cohort | Transfer Rate | Transferred | cohort | Transfer Rate
<18 | 178 | 405 |  | 174 | 376 |  | 95 | 176 |  | 126 | 246 |  | 101 | 213
18 & 19 | 176 | 516 |  | 181 | 532 |  | 201 | 580 |  | 265 | 728 |  | 290 | 759
20 to 24 | 19 | 110 |  | 23 | 113 |  | 27 | 93 |  | 18 | 85 |  | 28 | 95
25 to 29 | 16 | 54 |  | 6 | 35 |  | 8 | 41 |  | 8 | 28 |  | 9 | 24
30 to 34 | 11 | 54 |  | 12 | 53 |  | 10 | 43 |  | 2 | 16 |  | 2 | 15
35 to 39 | 14 | 49 |  | 7 | 40 |  | 9 | 33 |  | 4 | 29 |  | 5 | 23
40 to 49 | 17 | 60 |  | 15 | 62 |  | 11 | 43 |  | 5 | 39 |  | 10 | 30
50 + | 3 | 15 |  | 4 | 15 |  | 0 | 10 |  | 3 | 11 |  | 3 | 9
Unknown | 1 | 4 |  | 1 | 1 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Data was generated using '6yr to transfer' selection datamart cccco.edu
Note: The Transfer Cohort is created by evaluating all first time freshmen six years after their entry.
Those students who have completed twelve credit units and attempted a transfer level math or English
course are included in the Transfer Cohort.
Transfer rates for years three, four, and five are retrospective and cannot be reported until the cohort
is finalized at the completion of the sixth year after initial enrollment. Students with multiple college
enrollments are reported as members of the Transfer Cohort for each college attended.
Spreadsheet: 489184d1479140487-volume-price-mix-calculation-vpm-example-for-forum
Sheet: Sheet1

 | Cost | Sales | Cost to Sales | Sales Movement | New Sales | New Cost to Sales | Vs | Impact on Total?
Item 1 | 2 | 3 |  | 0.5
Item 2 | 3 | 3.2 |  | 0.3
Item 3 | 2.25 | 1.75 |  | -0.5
Item 4 | 2.5 | 2.9 |  | 0.1
Item 5 | 1 | 1.2 |  | 0
TOTAL
Spreadsheet: 747378d1631448587-pls-help-me-find-the-right-formula-for-this-complicated-worksheet-book2
Sheet: Sheet1

LOOKUP TABLE 1 |  |  |  |  | RESULT TABLE
ID | RANK | REPORT TO: |  |  | ID | AMT | 1ST | 2ND | 3RD
A00007 | AA | A00011 |  |  | A00007 | 10000
A00011 | BB | A00009 |  |  | A00009 | 15000
A00009 | CC | A00004 |  |  | A00004 | 25000
A00004 | DD |  |  |  | A00011 | 50000
LOOKUP TABLE 2
BB | 0.1
CC | 0.15
DD | 0.2
Spreadsheet: 6d05e2c5-26e6-4b4b-9176-c31ee2487fa4
Sheet: Sheet1

Unnamed: 0 | GeForce GTX 285 | Stock Radeon 6950 | Radeon 6950 (w/ 6970 mod) | Radeon 6950 (w/ 6970 mod and +20% power) | Radeon 6950 (w/ 6970 mod and +10% power)
3DMark06 (w/e default for trial is) | 17207 | 18755 | 18693 | 18619 | 18647
3DMark11  (w/e default for trial is) |  | P4594 | P5018 | P5001 | P5022
Unigine Haven (1920x1200 no AA)
FPS | 46.2 | 49.5 | 56.5 | 55.8 | 56
Scores | 1164 | 1247 | 1422 | 1406 | 1411
Min FPS | 28 | 3.4 | 17.1 | 13.7 | 18.4
Max FPS | 100 | 128.5 | 147.2 | 146.2 | 146.8
Spreadsheet: 48904d1248194219-formula-help-performing-triple-vlookup-692391-formula-help-performing-triple-vlookup
Sheet: Sheet1

Open Orders |  |  |  |  |  | Warehouse#
 | Delivery |  | Order |  |  | 1 | Delivery date
Item# | date | Warehouse# | qty |  |  | item# | 20090720 | 20090721 | 20090722 | 20090723
5100 | 20090720 | 3 | 500 |  |  | 5100 | 0 | 300 | 0 | 500
5100 | 20090721 | 1 | 300 |  |  | 5101 | 0 | 0 | 0 | 0
5101 | 20090721 | 3 | 250 |  |  | 5101 | 0 | 0 | 0 | 0
5102 | 20090722 | 1 | 125 |  |  | 5102 | 0 | 0 | 125 | 0
5103 | 20090720 | 1 | 700 |  |  | 5103 | 700 | 0 | 0 | 0
5105 | 20090721 | 1 | 500 |  |  | 5104 | 0 | 0 | 0 | 0
5105 | 20090722 | 1 | 300 |  |  | 5105 | 0 | 500 | 300 | 0
5105 | 20090720 | 3 | 250 |  |  | 5106 | 0 | 0 | 0 | 0
5107 | 20090721 | 3 | 500 |  |  | 5107 | 0 | 0 | 0 | 0
5110 | 20090722 | 3 | 300 |  |  | 5108 | 0 | 0 | 0 | 0
5110 | 20090720 | 1 | 250 |  |  | 5109 | 0 | 0 | 0 | 0
5100 | 20090723 | 1 | 500 |  |  | 5110 | 250 | 0 | 0 | 0
 |  | I'd like to populate the "Warehouse#1" table using the information in "Open Orders"
Note: Pivot Tables are best placed into their own worksheet - it was placed here for comparison
Warehouse# | 1
Sum of qty | date
Item# | 20090720 | 20090721 | 20090722 | 20090723 | Grand Total
5100 |  | 300 |  | 500 | 800
5102 |  |  | 125 |  | 125
5103 | 700 |  |  |  | 700
5105 |  | 500 | 300 |  | 800
5110 | 250 |  |  |  | 250
Grand Total | 950 | 800 | 425 | 500 | 2675