tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 676576d1588873780-select-dates-when-first-and-last-occurrence-of-a-value-below-date-row-occurs-workday-ranges
Sheet: Sheet1

 | 2020-06-01 00:00:00 | 2020-06-02 00:00:00 | 2020-06-03 00:00:00 | 2020-06-04 00:00:00 | 2020-06-05 00:00:00 | 2020-06-06 00:00:00 | 2020-06-07 00:00:00 | 2020-06-08 00:00:00 | 2020-06-09 00:00:00 | 2020-06-10 00:00:00 | 2020-06-11 00:00:00 | 2020-06-12 00:00:00 | 2020-06-13 00:00:00 | 2020-06-14 00:00:00 | 2020-06-15 00:00:00 | 2020-06-16 00:00:00 | 2020-06-17 00:00:00 | 2020-06-18 00:00:00 | 2020-06-19 00:00:00 | 2020-06-20 00:00:00 | 2020-06-21 00:00:00 | 2020-06-22 00:00:00 | 2020-06-23 00:00:00 | 2020-06-24 00:00:00 | 2020-06-25 00:00:00 | 2020-06-26 00:00:00 | 2020-06-27 00:00:00 | 2020-06-28 00:00:00 | 2020-06-29 00:00:00 | 2020-06-30 00:00:00
worker 1 | 24 | 24 | 24 | 24 |  |  |  |  |  | 24 | 24 | 24 | 24 |  |  | 24 | 24 | 24 |  |  |  |  | 24 | 24 | 24 | 24
worker 2 |  |  |  |  | 24 | 24 | 24 | 24 | 24 | 24 | 24 |  |  |  |  |  |  | 24 | 24 | 24 | 24 | 24 | 24 | 24 | 24 |  |  |  |  | 24
 | Worker 1 |  | Worker 2
 | Start | End | Start | End
workdays range 1
workdays range 2
workdays range 3
workdays range 4
DFP
DFP
DFP
DFP
DFP
DFP
DFP
DFP
DFP
DFP
DFP
DFP
DFP
DFP
DFP
DFP
 |  | 2020-06-09 00:00:00 |  | 2020-06-04 00:00:00
 | 2020-06-14 00:00:00 | 2020-06-15 00:00:00 | 2020-06-12 00:00:00 | 2020-06-17 00:00:00
 | 2020-06-19 00:00:00 | 2020-06-22 00:00:00 | 2020-06-26 00:00:00 | 2020-06-29 00:00:00
 | 2020-06-27 00:00:00 | 2020-06-30 00:00:00
 | 2020-06-02 00:00:00 |  | 2020-06-06 00:00:00
 | 2020-06-03 00:00:00 |  | 2020-06-07 00:00:00
 | 2020-06-04 00:00:00 |  | 2020-06-08 00:00:00
 | 2020-06-10 00:00:00 |  | 2020-06-09 00:00:00
 | 2020-06-11 00:00:00 |  | 2020-06-10 00:00:00
 | 2020-06-12 00:00:00 |  | 2020-06-11 00:00:00
 | 2020-06-13 00:00:00 |  | 2020-06-18 00:00:00
 | 2020-06-16 00:00:00 |  | 2020-06-19 00:00:00
 | 2020-06-17 00:00:00 |  | 2020-06-20 00:00:00
 | 2020-06-18 00:00:00 |  | 2020-06-21 00:00:00
 | 2020-06-23 00:00:00 |  | 2020-06-22 00:00:00
 | 2020-06-24 00:00:00 |  | 2020-06-23 00:00:00
 | 2020-06-25 00:00:00 |  | 2020-06-24 00:00:00
 | 2020-06-26 00:00:00 |  | 2020-06-25 00:00:00
 |  |  | 2020-06-30 00:00:00
Spreadsheet: louise_kitchen__22537__Power List
Sheet: Sheet1

Employees Included in Business Continuity Plan
Department | Individual
Management | [NAME]
Management Count
Northeast Trading | [NAME]
Northeast Trading | [NAME]
Northeast Trading | [NAME]
Northeast Trading | [NAME]
Northeast Trading | [NAME]
Northeast Trading | [NAME]
Northeast Trading | [NAME]
Northeast Trading | [NAME]
Northeast Trading | [NAME]
Northeast Trading | [NAME]
Northeast Trading Count
Midwest Trading | [NAME]
Midwest Trading | [NAME]
Midwest Trading | [NAME]
Midwest Trading | [NAME]
Midwest Trading | [NAME]
Midwest Trading | [NAME]
Midwest Trading | [NAME]
Midwest Trading | [NAME]
Midwest Trading Count
Southeast Trading | [NAME]
Southeast Trading | [NAME]
Southeast Trading | [NAME]
Southeast Trading | [NAME]
Southeast Trading | [NAME]
Southeast Trading Count
Ercot Trading | [NAME]
Ercot Trading | [NAME]
Ercot Trading | [NAME]
Ercot Trading | [NAME]
Ercot Trading | [NAME]
Ercot Trading Count
Option Trading | [NAME]
Option Trading | [NAME]
Option Trading | [NAME]
Option Trading | [NAME]
Option Trading Count
Services Trading | [NAME]
Services Trading | [NAME]
Services Trading | [NAME]
Services Trading | [NAME]
Services Trading | [NAME]
Services Trading Count
Schedulers | [NAME]
Schedulers | [NAME]
Schedulers | [NAME]
Schedulers | [NAME]
Schedulers | [NAME]
Schedulers | [NAME]
Schedulers | Smith Day
Schedulers Count
Risk Mgmt | [NAME]
Risk Mgmt | [NAME]
Risk Mgmt | Casey Evans
Risk Mgmt | [NAME]
Risk Mgmt | [NAME]
Risk Mgmt | [NAME]
Risk Mgmt | [NAME]
Risk Mgmt | [NAME]
Risk Mgmt | [NAME]
Risk Mgmt | [NAME]
Risk Mgmt | [NAME]
Risk Mgmt Count
Clerical | T.Jae Black
Clerical | [NAME]
Clerical | Claudia Guerra
Clerical Count
Grand Count
Spreadsheet: 47785d1246968634-count-on-condition-from-two-columns-new-microsoft-excel-worksheet
Sheet: Sheet1

Customer | City | Hotel | Food
A | Bar | GenA | All
B | Bar | GenA | None
C | Gel | GelB | None
D | Cre | CreD | All
E | Gel | GelB | None
F | Bar | GenA | All
 |  |  | 0
Spreadsheet: bd6b46da-0c31-44e1-8008-ea7a6015ca69
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
43443563 | 2014-10-05 04:32:45 | AXIS | 0 | 2 | 6 | 1412777 | Royston Warke | 8043 | eastern | 1939-09-08 | 1939-09-26 | Battle of Warsaw | Bataille de Varsovie
43485707 | 2014-10-08 01:55:47 | AXIS | 1 | 6 | 2 | 944629 | DrewR | 12498 | western | 1944-07-11 |  | [Normandy] Bretel Wood | [NAME]
43485865 | 2014-10-08 02:16:21 | ALLIES | 1 | 6 | 3 | 944629 | DrewR | 12498 | western | 1944-07-11 |  | [Normandy] Bretel Wood | [NAME]
43501499 | 2014-10-09 05:15:53 | AXIS | 0 | 0 | 5 | 465599 | Timor | 12499 | western | 1944-06-13 | 1944-06-13 | Carentan | Carentan
43501588 | 2014-10-09 05:33:02 | ALLIES | 0 | 4 | 5 | 465599 | Timor | 12499 | western | 1944-06-13 | 1944-06-13 | Carentan | Carentan
43656319 | 2014-10-20 02:43:25 | AXIS | 0 | 1 | 5 | 144495 | camwhit | 6157 | western | 1944-11-19 | 1944-11-23 | Saverne Gap | [NAME]
43656420 | 2014-10-20 03:01:58 | ALLIES | 1 | 5 | 2 | 144495 | camwhit | 6157 | western | 1944-11-19 | 1944-11-23 | Saverne Gap | [NAME]
Spreadsheet: 2a1eb375-0ee4-43a9-8e4a-28bbb93b2c5e
Sheet: 4.2(EA) Major Group Enroll-Grad

Institution
Indicator 4: Student Enrollment and Graduation by Major Group
Table 4.2(EA): Major Group Fall Enrollment, Graduation & Post-Graduate / AY 2011-12
 | Major Group | EA - Education - Paraprofessional
 | Please enter the number of students enrolled in this major group for the fall semester.
 |  |  |  |  | Fall 2011 (October 15, 2011)
 | Fall Enrollment (Snapshot) |  | American Indian |  | Non-Indian
 |  |  | M | F | M | F | Total
 |  | Full Time | 6 | 20 | 0 | 0
 |  | Part Time | 10 | 27 | 1 | 1
 |  | Total
 | Please enter the number of diploma, certificates, and degrees earned in this major group.  Also enter the number of students who were admitted to a 4 year (Associate degree graduates), or graduate school (Bachelor's degree graduates).  Lastly, enter the number of all graduating students(certificate or degree) who secured gainful employment after graduation.
 |  |  |  |  | July 1, 2011- June 30, 2012
 | Graduation |  | American Indian |  | Non-Indian
 |  |  | M | F | M | F | Total
Apprenticeship/Occupational Program |  |  | na | na | na | na
 | App. graduates admitted to a college program |  | na | na | na | na
Diploma |  |  | na | na | na | na
 | [NAME]. graduates admitted to a college program |  | na | na | na | na
Certificate |  |  | 0 | 0 | 0 | 0
 | Cert. graduates admitted to a college program |  | 0 | 0 | 0 | 0
Associate Degree |  |  | 3 | 19 | 0 | 1
 | Assoc. graduates admitted to four-year program |  | 0 | 0 | 0 | 0
Bachelor's Degree |  |  | na | na | na | na
 | [NAME]. graduates admitted to graduate school |  | na | na | na | na
Master's Degree |  |  | na | na | na | na
Gainfully Employed after graduation |  |  | m | m | m | m
Graduates who completed remedial courses during their time at the TCU |  |  | m | m | m | m
Graduates who received A*CF support at some point during their coursework |  |  | m | m | m | m
Notes:
NA denotes that the program is not offered. We do not track graduates.
Spreadsheet: 100302d1298669116-calculating-number-of-months-in-excel-lease
Sheet: Sheet1

Lease | Start Date | Term in Months | Month Remaining | End Date | Status
LEASE A | 2009-12-26 00:00:00 | 44
LEASE B | 2010-02-10 00:00:00 | 30
Lease C | 2010-02-25 00:00:00 | 12
Lease D | 2010-02-24 00:00:00 | 12
Spreadsheet: 124557d1318459024-return-data-from-second-sheet-using-first-sheet-colum-c-hostname-as-key-test-sheet
Sheet: Sheet2

hostname | MAC address
bob | 00-49-56-9F-01-11
qwe | 00-49-56-9F-01-12
ewq | 00-49-46-9F-01-09
asd | 00-49-36-9F-01-09
dsa | 01-49-56-9F-01-09
zxc | 02-49-56-9F-01-09
rty | 03-49-56-9F-01-09
ytr | 04-49-56-9F-01-09
fgh | 05-49-56-9F-01-09
hgf | 06-49-56-9F-01-05
vbn | 07-49-56-9F-01-09
nbv | 08-49-56-9F-01-09
bob1 | 09-49-56-9F-01-09
qwe1 | 10-49-56-9F-01-09
ewq1 | 20-49-56-9F-01-09
asd1 | 30-49-56-9F-01-09
dsa1 | 00-39-56-9F-01-09
[NAME] | 00-29-56-9F-01-09
cxz1 | 00-19-56-9F-01-09
wer1 | 00-09-56-9F-01-06
bvc1 | 00-08-56-9F-01-09
rty1 | 00-07-56-9F-01-08
ytr1 | 00-09-50-9F-01-09
fgh1 | 00-49-56-9F-05-08
hgf1 | 00-49-36-8F-01-09
vbn1 | 30-49-56-6F-01-09
nbv1 | 00-49-56-9F-15-09
Spreadsheet: 4a766bf3-8937-44be-b716-c9385a11fb08
Sheet: EL CIVICS

Grant: |  | EL CIVICS
CFDA # |  | 84.002
GRANT NUMBER: |  | 6002
FISCAL YEAR: |  | 2012-13
[NAME]: |  | Not allowed on this grant
Question regarding payments: |  | [NAME]   [PHONE] or [EMAIL]
Questions regarding grant: |  | Marti Rodriguez  [PHONE] or [EMAIL]
GBL/ORG: |  | 613M/7000
LAST DAY TO SUBMIT REQUESTS FOR THIS GRANT  - SEPTEMBER 30, 2013
Code | District/Agency Name | ALLOCATION | PAYMENTS TO DATE | BALANCE | July 2012 | August 2012 | September 2012 | October 2012 | October 2012 | November 2012 | December 2012 | January 2013 | February 2013 | March 2013 | April 2013 | May 2013 | June 2013 | July 2013 | August 2013 | September 2013
0030 | ILC-Adams 14 | 102832 |  |  |  |  |  |  |  | 11420 | 3798 |  | 7624 |  |  |  |  |  | 78866
0470 | St. Vrain Valley Adult Education | 27967 |  |  |  |  |  |  |  |  |  |  |  |  | 16731 |  | 4182
1010 | Colorado Springs 11 | 124565 |  |  |  |  |  |  |  | 22568 | 12439 | 12888 | 5665 |  |  | 12709 | 11940 |  | 15689
1420 | Jefferson County Dual Language | 68126 |  |  |  |  |  |  |  |  | 9255 | 5600 | 3494 | 7871 | 7549 | 18963 | 8071 | 884 |  | 6439
2180 | Montrose County School District | 16897 |  |  |  |  |  |  |  |  | 6077 |  |  | 4631 |  |  | 6189
Y001 | Trinidad State Junior College | 34000 |  |  |  |  |  |  | 6270 |  |  |  | 11508 |  | 9461 |  |  | 6761
[NAME] | Focus Points | 100011 |  |  |  |  |  |  |  |  | 21556 | 4970 | 7012 | 7556 | 5901 | 9729 | 43287
Y699 | Northeastern Junior College | 33504 |  |  |  |  |  |  |  |  |  | 15275 |  | 6134
Y701 | Spring Institute for Intercultural Learning | 106413 |  |  |  | 4922 |  |  |  |  | 9268 | 9439 |  | 8951 | 8335 | 8580 | 8528 | 7428
Y705 | Adult Education Center of Durango | 50000 |  |  |  | 9355 | 5500 |  | 8500 |  | 8445 | 4197 | 3540 | 3682 | 3581 | 3200
Y711 | Right to Read | 11045 |  |  |  |  | 1228 | 1228 |  | 3336 | 1228 | 1228 | 1228 | 784 | 785
Spreadsheet: 753517d1635492141-count-where-id-x-and-month-12-and-year-2020-excel-help
Sheet: Sheet1

 |  |  |  |  | Material | 111111-1.00
 |  | Product ID | Date |  | 2020-12-01 00:00:00
 |  | 111111-1.00 | 2020-12-31 00:00:00
 |  | 111111-1.00 | 2020-12-12 00:00:00
 |  | 111111-1.00 | 2021-01-27 00:00:00 |  | Desired output
 |  | 111111-1.00 | 2021-02-21 00:00:00 |  | 2 | 1 | 1
 |  | 222222-1.00 | 2021-03-02 00:00:00
 |  | 222222-1.00 | 2021-02-13 00:00:00
 | Row Labels | Count of Product ID
 | 111111-1.00 | 4
 | 2020
 | déc | 2
 | 2021
 | janv | 1
 | févr | 1
 | Grand Total | 4
Spreadsheet: 217148d1361992734-help-with-stock-take-multiple-listings-of-part-numbers-that-need-to-be-accumulated-help-required-jasondn78-oeldere-
Sheet: Sheet1

 | Qty | Part No |  |  | Qty | Part No
 | 1 | AAA |  |  | 60 | AAA |  |  | Rijlabels | Som [NAME]
 | 2 | DCF |  |  | 1 | BBB |  |  | AAA | 60
 | 2 | GHH |  |  | 1 | CCD |  |  | BBB | 1
 | 2 | GHH |  |  | 2 | DCF |  |  | CCD | 1
 | 48 | GHH |  |  | 53 | GHH |  |  | DCF | 2
 | 1 | GHH |  |  | 10 | SDE |  |  | GHH | 53
 | 1 | BBB |  |  | 12 | SQT |  |  | SDE | 10
 | 1 | CCD |  |  |  |  |  |  | SQT | 12
 | 59 | AAA |  |  |  |  |  |  | Eindtotaal | 139
 | 12 | SQT
 | 10 | SDE
Spreadsheet: 46048d1244826152-an-if-count-formula-example
Sheet: Sheet2

Name | Date | (C)One | (V)Two | (C)Three | Four | (C)Five
[NAME] | 2009-06-12 00:00:00 | Pass | Pass | Fail | Pass | Pass
[NAME] | 2009-06-12 00:00:00 | Pass | Pass | Pass | Pass | Fail
Merry | 2009-06-12 00:00:00 | Fail | Pass | Fail | Pass | Pass
[NAME] | 2009-06-12 00:00:00 | Fail | Fail | Fail | Pass | Pass
[NAME] | 2009-06-12 00:00:00 | Pass | Pass | Pass | Pass | Pass
Kerry | 2009-06-12 00:00:00 | Fail | Pass | Pass | Pass | Fail
[NAME] | 2009-06-12 00:00:00 | Fail | Pass | Pass | Pass | Fail
[NAME] | 2009-06-12 00:00:00 | Pass | Fail | Pass | Pass | Pass
Spreadsheet: 45704d1244536363-if-a-character-is-entered-copy-formula-into-cells-eg
Sheet: Sheet1

Example |  |  |  |  | Function1a | Function1b
 |  |  |  |  | Function2a | Function2b
Date | Value | Y or N?
2009-01-01 00:00:00 | 11 | Y | [NAME] (IF C6="Y"then copy formulas from F1 & G1 to F6 & G6) If C6="N" then copy formulas from F2 & G2 to F6 & G6) |  | Function1a | Function1b
2009-01-02 00:00:00 | 13 | Y | [NAME] (IF C6="Y"then copy formulas from F1 & G1 to F7 & G7) If C6="N" then copy formulas from F2 & G2 to F7 & G7) |  | Function1a | Function1b
2009-01-03 00:00:00 | 14 | N | [NAME] (IF C6="Y"then copy formulas from F1 & G1 to F8 & G8) If C6="N" then copy formulas from F2 & G2 to F8 & G8) |  | Function2a | Function2b
2009-01-04 00:00:00 | 12 | N | [NAME] (IF C6="Y"then copy formulas from F1 & G1 to F9 & G9) If C6="N" then copy formulas from F2 & G2 to F9 & G9) |  | Function2a | Function2b
2009-01-05 00:00:00 | 9 | Y | [NAME] (IF C6="Y"then copy formulas from F1 & G1 to F10 & G10) If C6="N" then copy formulas from F2 & G2 to F10 & G10) |  | Function1a | Function1b
2009-01-06 00:00:00 | 10 | N | [NAME] (IF C6="Y"then copy formulas from F1 & G1 to F11 & G11) If C6="N" then copy formulas from F2 & G2 to F11 & G11) |  | Function2a | Function2b
2009-01-07 00:00:00 | 16 | N | [NAME] (IF C6="Y"then copy formulas from F1 & G1 to F12 & G12) If C6="N" then copy formulas from F2 & G2 to F12 & G12) |  | Function2a | Function2b
2009-01-08 00:00:00 | 15 | Y | [NAME] (IF C6="Y"then copy formulas from F13 & G13 to F6 & G6) If C6="N" then copy formulas from F2 & G2 to F13 & G13) |  | Function1a | Function1b
2009-01-09 00:00:00 | 14 | N | [NAME] (IF C6="Y"then copy formulas from F1 & G1 to F14 & G14) If C6="N" then copy formulas from F2 & G2 to F14 & G14) |  | Function2a | Function2b
2009-01-10 00:00:00 | 11 | Y | [NAME] (IF C6="Y"then copy formulas from F1 & G1 to F15 & G15) If C6="N" then copy formulas from F2 & G2 to F15 & G15) |  | Function1a | Function1b
2009-01-11 00:00:00 | 10 | N | [NAME] (IF C6="Y"then copy formulas from F1 & G1 to F16 & G16) If C6="N" then copy formulas from F2 & G2 to F16 & G16) |  | Function2a | Function2b
Spreadsheet: 583965d1532855132-how-to-exclude-weekends-in-employee-absence-tracker-count-copy-of-holiday-and-absence-planning-keebellah-
Sheet: Aug

 | Employee Holiday & Absence Scheduling
E  m  p  l  o  y  e  e | Absence Type Key |  | X | Vacation |  |  | T | Official Travel |  |  |  | S | Sick |  |  | M | Maternity |  |  | p | Parental |  |  |  | C | Compensation |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Public Holiday |  |  |  | Holiday
 | August | 2018 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Days
 | Employee Name | 2018-08-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Vacation | Official Travel | Sick | Maternity | Parental | Compensation
 |  | 2019-01-01 00:00:00
 | Employee 1 |  | x | x |  |  | c | c | s | s | s |  |  | x | x | x | x | x |  |  | t | t | t | t | t |  |  | t | t | t | t | t
 | Employee 2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | x | x | x | x | x | x | x | x | x | x | x | x
 | Employee 3
 | Employee 4
 | Employee 5
 | Employee 6
 | Employee 7
 | Employee 8
 | Employee 9
 | Employee 10
 | Employee 11
 | Employee 12
 | Employee 13
 | Employee 14
 | Employee 15
 | Employee 16
 | Employee 17
 | Employee 18
 | Employee 19
 | Employee 20
 | Employee 21
 | Employee 22 |  |  |  |  |  |  |  |  |  |  |  |  | t | t | t | t | t
 | Employee 23
 | Employee 24
 | Employee 25 |  | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x | x |  |  |  |  |  |  | s | s | s
 | Employee 26
 | Employee 27
 | Employee 28
Spreadsheet: 59931d1260456864-working-out-ave-when-div-0-codes-book1
Sheet: Sheet1

 | oct | nov | dec | jan | feb | [NAME] | apr | may | jun | jul | aug | sep | Ave
Absence rate | 4.338842975206612 | 1.25 | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | #N/A | 0
Spreadsheet: 837760d1690395862-calculated-result-based-on-matching-rows-mean-bp-calculation
Sheet: Sheet1

Recorded Date/Time | Vital Sign | Value | UnitOfMeasure
2015-11-30 18:05:00 | Systolic BP | 111 | mmHg
2015-11-30 18:05:00 | Diastolic BP | 56 | mmHg
2015-11-30 18:14:00 | Systolic BP | 111 | mmHg
2015-11-30 18:14:00 | Diastolic BP | 56 | mmHg
2015-11-30 18:30:00 | Systolic BP | 102 | mmHg
2015-11-30 18:30:00 | Diastolic BP | 59 | mmHg
2015-11-30 18:47:00 | Systolic BP | 86 | mmHg
2015-11-30 18:47:00 | Diastolic BP | 50 | mmHg
2015-11-30 18:53:00 | Systolic BP | 80 | mmHg
2015-11-30 18:53:00 | Diastolic BP | 50 | mmHg
2015-11-30 18:56:00 | Systolic BP | 85 | mmHg
2015-11-30 18:56:00 | Diastolic BP | 53 | mmHg
2015-11-30 19:00:00 | Systolic BP | 86 | mmHg
2015-11-30 19:00:00 | Diastolic BP | 53 | mmHg
2015-11-30 19:01:00 | Systolic BP | 87 | mmHg
2015-11-30 19:01:00 | Diastolic BP | 50 | mmHg
2015-11-30 19:05:00 | Systolic BP | 91 | mmHg
2015-11-30 19:05:00 | Diastolic BP | 53 | mmHg
Spreadsheet: 776648d1649845623-ref-on-new-worksheet-for-forum
Sheet: Core

Digital Support Technician |  |  |  |  |  |  |  |  | Core
Core Knowledge |  |  |  |  |  |  |  |  | Application
 |  |  |  |  |  |  | Place an "x" in your selected answer |  | Total
 |  |  |  |  |  |  |  |  | %
Prostart28<> |  | a | b | c | d |  |  |  | Pass/Fail
1 | Which of the following is an advantage that inkjet printers have compared to other types of printers?
 | a) Minimal warm up time
 | b) Minimal use of consumables during automatic cleaning
 | c) Low cost OEM supplies for the printer
 | d) Allows intelligent cartridges to monitor ink levels
 | Your Answer: | x
2 | Which of the following is a disadvantage of cloud printing?
 | a) Documents are stored remotely
 | b) There is an increased risk to the security of data
 | c) Software drivers are required to be installed
 | d) Difficult to use with bring-your-own-device
 | Your Answer:
3 | Which of the following is uniquely available on an iOS-based phone to make a VoIP call?
 | a) Skype
 | b) Zoom
 | c) FaceTime
 | d) WhatsApp
 | Your Answer:
Spreadsheet: 377317d1423883881-find-unique-values-from-a-range-using-formula-unique-list-from-an-array
Sheet: Sheet1

 | M | T | W | Th | F | S | S |  |  |  | Unique values |  |  |  |  | Array, no helper...
A | 7 | 1 | 2 | 1 | 4 | 1 | 0
B | 3 | 4 | 3 | 1 | 0 | 2 | 0
C | 7 | 3 | 1 | 1 | 0 | 5 | 1
Spreadsheet: 5bdd3cba-0a89-472e-8da6-dfb5a691ab60
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 | [NAME]　-　クレジットリミット減額先の再審査
 | 申請日:
 | [NAME]: |  |  |  |  |  |  |  | リファレンス番号:
 | クレジットリミット減額先の再考をさせていただきますので、以下の情報をご提供下さいます様よろしくお願いいたします。（太字は必須入力項目です)
 | 右のE-メールアドレスにこのフォームをお送りください |  |  |  |  |  |  |  | [EMAIL]
 | ポリシー番号 |  |  |  |  |  |  |  | 貴社名
 | または
 | Easy 番号 |  |  |  |  |  |  |  | ご担当者名
 |  |  |  |  |  |  |  |  | 部署・役職名
 |  |  |  |  |  |  |  |  | E-メールアドレス
 |  |  |  |  |  |  |  |  | 電話番号
 |  | (3 桁) |  |  |  | (6 桁)
 | CRS 番号 |  |  |  |  |  |  |  | バイヤー企業名
 | または
 | Easy 番号 |  |  |  |  |  |  |  | 連絡先（担当者名）
 |  |  |  |  |  |  |  |  | E-メールアドレス
 |  |  |  |  |  |  |  |  | 電話番号
 | 私は弊社に代わってコファスがこの企業にコンタクトし弊社の名前を明かした上で情報取得をする事を許可します。
 |  |  |  |  | 内容をご記入下さい
 |  |  |  |  | 内容をご記入下さい
 | コメント欄
Spreadsheet: 103187d1300980429-freight-charges-based-on-zip-someko_freightperzipcode-1-
Sheet: Sheet1

Zip Code | Basic Charge | Min Charge | 0 - 250 KGS | 251 - 500 KGS | 501 - 1000 KGS | 1001 - 3000 KGS | 3001 + KGS
900-1000 | 20 | 65 | 3.0774 | 5.8757 | 5.5557 | 5.5557 | 5.0774
3450-4550 | 3 | 70 | 0.8252 | 2.0786 | 0.7577 | 0.8788 | 0.8252
9999-10111 | 50 | 78 | 0.9276 | 2.2558 | 2.2227 | 2.0075 | 0.7276
 | Zip Code | Weight | Cost
 | 900-1000 | 100 | 327.74
Spreadsheet: mary_fischer__25640__31W - 2001
Sheet: E15.XLS

ENRON CORP AND CONSOLIDATED SUBSIDIARIES
COMPANY # 031W
COMPANY NAME    Harper Mechanical Corp.
ANALYSIS OF MINORITY INTERESTS
FOR THE 3 MONTHS ENDED 3-31-2001
 |  |  |  |  |  |  |  |  |  |  |  | E-15
 |  |  |  | 12-31-2000 Balance
 |  |  |  | BEGINNING |  | AMOUNT |  |  |  |  |  | 12-31-2001
[NAME] OR ENTITY |  | ENRON'S |  | BALANCE |  | PER INCOME |  | OTHER |  |  |  | BALANCE
 |  | OWNERSHIP % |  | DR. (CR.) |  | STATEMENT |  | AMOUNT |  | (DESCRIBE) |  | DR. (CR.)
(PROVIDE DETAIL OF INDIVIDUAL ITEMS
IN EXCESS OF $200,000.)
Total Minority Interest | * |  |  |  |  |  |  |  |  |  |  |  | *
* MUST TIE TO HYPERION ACCOUNT 0855  DR/(CR)
Spreadsheet: 51644d1251283229-counting-conditional-formatting-aug-backups
Sheet: 25th

Internt Backups |  |  | [NAME]
Customer/ server/ [NAME] job | Backup success |  | Customer/ server/ [NAME] job | Backup success |  | Y | Backup successful
Artist Indepenent |  |  | Able Services |  |  | N | Failed
AIFDC1-SYS-STATE | y |  | ADSDC1 | n |  | o | Backup Not found
AIFDCI-DATA | y |  | Finnsish Chamber of Commerce
AIFDC1-MSEXCH | y |  | FBCCS01 | n
AIFDC1-PST | y |  | LP Networks
Axis Security |  |  | LPNETDC1 | y
[NAME] | y |  | ML Select
AXISDC1-DATA | y |  | MLSDC1 | y
AXISDC1-MSEXCH | y |  | [NAME]
AXISDC1-BRICKLEVEL | y |  | SIDEKIXDC1 | o
AXISDC1-SQL | y
Colombier
[NAME] | y
COLUKDC1-DATA | o
COLUKDC1-PST | y |  | Date updated | 2009-08-25 00:00:00
COLUKSRV1-SYS-STATE | y
COLUKSRV1-SQL | y
COLUKSRV1-DATA | y
Finch & Partners
FINCHDC1-DATA | y
FINCHDC1-MSEXCH | y
Glasshouse Entertainment
GOLCONDALA-SYS-STATE | y
GOLCONDALA-DATA | y
GOLCONDALA-MSEXCH | y
GOLCONDALA-PST | y
LOGO69
LOGODC1-SYS-STATE | y
[NAME] | y
LOGODC1-DATA | y
LOGODC1-PST | y
LPM Cleaning
LPMDC1-SYS-STATE | y
LPMDC1-DATA | y
LPMDC1-EXCH | o
LPMDC2-SYS-STATE | y
LPMDC2-SQL | y
LPMDC2-DATA | y
TMS-SYS-STATE | y
TMS-SQL | y
TMS-DATA | y
[NAME]
NGDC1-SYS-STATE | y
NGDC1-MSEXCH | y
NGDC1-DATA | y
Tavistock
TWOODSO1-SYS-STATE | y
TWOODS01-DATA | o
TWOODS01-MSEXCH | y
TWOODS01-PST | y
Spreadsheet: 197355d1354306376-new-excel-user-need-help-creating-list-that-populates-different-information-calendar-sample
Sheet: Nov

 | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday
 |  | Notes:
Spreadsheet: 818154d1676624825-how-concatenate-cells-in-range-based-on-value-in-other-cell-range-question-how-concatenate-cells-in-range-based-on-value-in-other-cell-range
Sheet: Sheet1

Item# | Article 1 | Article 2 |  |  | Article # | Items
Item 1 | x | x |  |  |  | Item1, Item 2, Item 3, Item 4 | ◄ The result from the formula should be like the two cells G2:G3 (which is now static text)
Item 2 | x |  |  |  |  | Item1, Item 5, Item7
Item 3 | x
Item 4 | x
Item 5 |  | x
Item 6
Item 7 |  | x
 |  |  |  |  | Row Labels | Items
 |  |  |  |  | Article 1 | Item 1, Item 2, Item 3, Item 4
 |  |  |  |  | Article 2 | Item 1, Item 5, Item 7
Spreadsheet: 73409d1274077307-summarize-numbers-by-month-expenses
Sheet: Sheet1

Sum of Cost | Column Labels
Row Labels | Anna | Charlene | [NAME] | Danika | [NAME] | [NAME] | Lyne | [NAME] | Nicole | wife | (blank) | Grand Total
sij |  |  |  |  |  |  |  |  |  |  | 1428 | 1428
ožu |  |  |  |  |  |  | 757 |  |  |  |  | 757
tra |  | 557 |  |  |  |  |  |  |  |  |  | 557
svi |  |  |  |  |  |  |  |  |  |  | 200 | 200
lip |  |  |  |  |  |  |  |  |  | 757 |  | 757
kol |  |  | 1000 |  |  |  |  | 757 |  |  | 357 | 2114
ruj | 757 |  |  | 757 |  | 1157 |  |  | 757 |  | 357 | 3785
[NAME] |  |  |  |  |  |  |  |  |  |  | 357 | 357
pro |  |  |  |  | 757 |  |  |  |  |  |  | 757
Grand Total | 757 | 557 | 1000 | 757 | 757 | 1157 | 757 | 757 | 757 | 757 | 2699 | 10712
Spreadsheet: 696170d1600686735-formula-to-align-columns-to-source-file-copy-of-sample-for-
Sheet: Sheet1

V7 Name | V7 DB Type | V7 Length | V7 Typelist | V8 Name | V8 DB Type | V8 Length | [NAME]
[NAME] | a | 1 | x | [NAME] | a | 1 | x
Bib | a | 2 | y | [NAME] | a | 2 | y
[NAME] | b | 5 | g | Abhi | b | 5 | z
Parvu | b | 6 | r | Bib | e | 8 | j
Maia | b | 6 | r | [NAME] | g | 7 | k
 |  |  |  | Parvu | g | 7 | o
Desired result
V7 Name | V7 DB Type | V7 Length | V7 Typelist | V8 Name | V8 DB Type | V8 Length | [NAME]