tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 839679d1692154224-formula-to-count-duplicate-value-as-one-test1-4-
Sheet: Sheet1

Unit No. | Element |  | Wanted a formula to calculate the duplicate entry that match the creteria A3+B3 as one entry only
A-01-01 | wall |  | The result that I wanted as below
A-01-01 | wall
A-01-01 | window |  | A-01-01 | Wall
A-01-01 | ceiling |  | A-01-01 | window | 1
A-01-01 | fixtures |  | A-01-01 | ceiling | 1
A-01-01 | wall |  | A-01-01 | fixtures | 1
A-01-01 | fixtures |  | A-01-01 | ceiling | 1
A-01-01 | ceiling |  | A-01-01 | floor | 0
A-01-01 | ceiling
A-01-01 | ceiling
Spreadsheet: 60867d1261456882-compile-worksheet-list-toll-free-test
Sheet: 8001234567

 |  | [PHONE]
 | Total | 125 | 104 | 1036 | 21 | 0.832 | 5 | 0.04
 |  | Attempted Calls | Completed Calls | Completed MOU | Incomplete Calls | Percent Complete | Busy Calls | Percent Busy
 | 2009-11-11 00:00:00 | 34 | 34 | 435 | 0 | 1 | 0 | 0
 | 2009-11-12 00:00:00 | 53 | 34 | 342 | 19 | 0.6415094339622641 | 3 | 0.05660377358490566
 | 2009-11-13 00:00:00 | 35 | 34 | 234 | 1 | 0.9714285714285714 | 1 | 0.02857142857142857
 | 2009-11-14 00:00:00 | 3 | 2 | 25 | 1 | 0.6666666666666666 | 1 | 0.3333333333333333
 | 2009-11-15 00:00:00
 | 2009-11-16 00:00:00
 | 2009-11-17 00:00:00
 | 2009-11-18 00:00:00
 | 2009-11-19 00:00:00
 | 2009-11-20 00:00:00
 | 2009-11-21 00:00:00
 | 2009-11-22 00:00:00
 | 2009-11-23 00:00:00
 | 2009-11-24 00:00:00
 | 2009-11-25 00:00:00
 | 2009-11-26 00:00:00
 | 2009-11-27 00:00:00
 | 2009-11-28 00:00:00
 | 2009-11-29 00:00:00
 | 2009-11-30 00:00:00
 | Sub Total : Nov | 125 | 104 | 1036 | 21 | 0.832 | 5 | 0.04
 | 2009-12-01 00:00:00
 | 2009-12-02 00:00:00
 | 2009-12-03 00:00:00
 | 2009-12-04 00:00:00
 | 2009-12-05 00:00:00
 | 2009-12-06 00:00:00
 | 2009-12-07 00:00:00
 | 2009-12-08 00:00:00
 | 2009-12-09 00:00:00
 | 2009-12-10 00:00:00
 | 2009-12-11 00:00:00
 | 2009-12-12 00:00:00
 | 2009-12-13 00:00:00
 | 2009-12-14 00:00:00
 | 2009-12-15 00:00:00
 | 2009-12-16 00:00:00
 | 2009-12-17 00:00:00
 | 2009-12-18 00:00:00
 | 2009-12-19 00:00:00
 | 2009-12-20 00:00:00
 | 2009-12-21 00:00:00
 | 2009-12-22 00:00:00
 | 2009-12-23 00:00:00
 | 2009-12-24 00:00:00
 | 2009-12-25 00:00:00
 | 2009-12-26 00:00:00
 | 2009-12-27 00:00:00
 | 2009-12-28 00:00:00
 | 2009-12-29 00:00:00
 | 2009-12-30 00:00:00
 | 2009-12-31 00:00:00
 | Sub Total : Dec | 0 | 0 | 0 | 0 | #N/A | 0 | #N/A
Spreadsheet: 149658d1334073327-excel-2007-pivot-table-i-want-the-actual-value-date-to-show-up-in-the-value-copy-of-test-pivot-problem
Sheet: Raw Data

Student Name | Event Code | Event Date
Person 1 | 02 | 12/13/2006
Person 1 | 03 | 4/12/2010
Person 1 | 04 | 2/12/2007
Person 1 | 05 | 2/12/2007
Person 1 | 07 | 1/18/2012
Person 1 | 08 | 2/25/2010
Person 2 | 04 | 12/6/2010
Person 2 | 05 | 9/22/2011
Person 3 | 02 | 10/14/2009
Person 3 | 03 | 11/19/2009
Person 3 | 04 | 11/23/2009
Person 3 | 05 | 11/23/2009
Person 3 | 06 | 11/30/2009
Person 3 | 07 | 3/16/2011
Person 4 | 02 | 10/7/2009
Person 4 | 03 | 12/9/2009
Person 4 | 04 | 12/15/2009
Person 4 | 05 | 12/15/2009
Person 4 | 06 | 12/16/2009
Person 4 | 07 | 1/27/2011
Person 4 | 08 | 2/22/2010
Person 5 | 02 | 12/15/2010
Person 5 | 03 | 1/28/2011
Person 5 | 04 | 2/8/2011
Person 5 | 05 | 2/22/2011
Person 5 | 06 | 2/24/2011
Person 5 | 07 | 12/7/2011
Spreadsheet: drew_fossum__8677__Fixed3
Sheet: ENA_10

[NAME]
FUEL HEDGING BOOK
Enron North America_10
Prod. | Contract | Contract | Fixed |  | Fuel | Settled | Futures | (Gains) and Losses
Date | Number | Name | Price |  | Dth | Price | Price | Total | Realized | Unrealized
 |  |  |  |  |  | El Paso Prmn |  | (4) | (4) | (4)
2001-01-01 00:00:00 |  | ENA-Put Option | 0.1
2001-02-01 00:00:00 |  | ENA-Put Option | 0.1
2001-03-01 00:00:00 |  | ENA-Put Option | 0.1
2001-04-01 00:00:00 |  | ENA-Put Option | 0.1
2001-05-01 00:00:00 |  | ENA-Put Option | 0.1
2001-06-01 00:00:00 |  | ENA-Put Option | 0.1
2001-07-01 00:00:00 |  | ENA-Put Option | 0.1
2001-08-01 00:00:00 |  | ENA-Put Option | 0.1
2001-09-01 00:00:00 |  | ENA-Put Option | 0.1
2001-10-01 00:00:00 |  | ENA-Put Option | 0.1
2001-11-01 00:00:00 |  | ENA-Put Option | 0.1
2001-12-01 00:00:00 |  | ENA-Put Option | 0.1
 |  |  |  |  |  | TW Index
2001-01-01 00:00:00 |  | Over-retention | 3
2001-02-01 00:00:00 |  | Over-retention | 3
2001-03-01 00:00:00 |  | Over-retention | 3
2001-04-01 00:00:00 |  | Over-retention | 3
2001-05-01 00:00:00 |  | Over-retention | 3
2001-06-01 00:00:00 |  | Over-retention | 3
2001-07-01 00:00:00 |  | Over-retention | 3
2001-08-01 00:00:00 |  | Over-retention | 3
2001-09-01 00:00:00 |  | Over-retention | 3
2001-10-01 00:00:00 |  | Over-retention | 3
2001-11-01 00:00:00 |  | Over-retention | 3
2001-12-01 00:00:00 |  | Over-retention | 3
(4)Gain and [NAME] are a measurement of the effectiveness of meeting the stated hedge objective.
Spreadsheet: 873641d1720142644-help-vlookup-i-reckon-aussiefreight-rawdata
Sheet: Distances

 | Distances (km)
 | Sydney | Melbourne | Brisbane | Perth | Canberra
Sydney |  | 877 | 924 | 3935 | 285
Melbourne | 877 |  | 1682 | 3410 | 676
Brisbane | 924 | 1682 |  | 4316 | 1199
Perth | 3935 | 3410 | 4316 |  | 3735
Canberra | 285 | 676 | 1199 | 3735
Spreadsheet: 299652d1393256972-copy-and-paste-columns-to-another-sheet-based-on-a-criteria-0a1_a20
Sheet: Sheet2

Employee | Project | Activity | Iteration | Area Path
[NAME] | Google | Test Cases | N/A | N/A
[NAME] | Google | Test Cases | N/A | N/A
[NAME] | Google | Test Cases | N/A | N/A
[NAME] | Yahoo | Test Cases | N/A | N/A
[NAME] | Yahoo | Design | N/A | N/A
[NAME] | Yahoo | Design | N/A | N/A
[NAME] | Yahoo | Design | N/A | N/A
[NAME] | Yahoo | Analysis | N/A | N/A
[NAME] | Yahoo | Analysis | N/A | N/A
[NAME] | Yahoo | Analysis | N/A | N/A
[NAME] | MSN | Analysis | N/A | N/A
[NAME] | MSN | Analysis | N/A | N/A
Toby | MSN | Development | N/A | N/A
Toby | MSN | Development | N/A | N/A
Toby | MSN | Development | N/A | N/A
Toby | MSN | Development | N/A | N/A
Toby | Bing | Development | N/A | N/A
Toby | Bing | Bugs | N/A | N/A
Toby | Bing | Bugs | N/A | N/A
Toby | Bing | Bugs | N/A | N/A
Spreadsheet: michelle_cash__26490__Capital_ONE
Sheet: 29_01_99

ELEKTRO Eletricidade e Serviços S/A  (EXTRA OFICIAL - PRELIMINAR)
Composição do Capital Social |  |  |  |  |  |  |  | Posição em: | 29/01/1999
 |  | [NAME] |  |  | [NAME] |  |  | Total Ações
DATA | Acionistas | Quantidade | Valor em R$ | % | Quantidade | Valor em R$ | % | Quantidade | Valor em R$ | % | Observações
1998-12-23 00:00:00 | [NAME] | 43681170494 | 0 | 0.8998 | 0 | 0 |  |  | 0 | 0.4661
1998-12-23 00:00:00 | CESP - Companhia Energética de São Paulo | 4854165156 | 0 |  | 0 | 0 |  |  | 0 | 0.0518
1998-12-23 00:00:00 | CESP - Companhia Energética de São Paulo | 0 | 0 |  | 44554244393 | 0 | 0.9866 |  | 0 | 0.4755
1998-12-23 00:00:00 | Acionistas Minoritários, inclusive Conselheiros. | 6315910 | 0 | 0.0002 | 602365837 | 0 | 0.0134 |  | 0 | 0.0066
1998-12-23 00:00:00 | TOTAL |  | 0 |  |  | 0 |  |  | 528598154.94
1999-01-29 00:00:00 | EPC - EMPRESA PARANAENSE COMERCIALIZADORA LTDA. | 43343321079 | 0 |  | 0 | 0 |  |  | 0 |  | Conforme informação recebida de Edson Pavão (ENRON's Lawyer) e/ou J.P.Morgan através de telefone/Fax/E-Mail.
1999-01-29 00:00:00 | ENRON BRAZIL POWER INVESTMENTS V LTD. | 337849415 | 0 |  | 0 | 0 |  |  | 0 |  | Conforme informação recebida de Edson Pavão (ENRON's Lawyer) e/ou J.P.Morgan através de telefone/Fax/E-Mail.
1999-01-29 00:00:00 | EIE - ENRON INVESTIMENTOS ENERGÉTICOS LTDA. |  | 0 |  | 0 | 0 |  |  | 0 |  | Conforme informação recebida de Edson Pavão (ENRON's Lawyer) e/ou J.P.Morgan através de telefone/Fax/E-Mail.
1999-01-29 00:00:00 | ETB - ENERGIA TOTAL BRASIL LTDA. | 0 | 0 |  |  | 0 |  |  | 0 |  | Conforme informação recebida de Edson Pavão (ENRON's Lawyer) e/ou J.P.Morgan através de telefone/Fax/E-Mail.
1999-01-29 00:00:00 | CESP - Companhia Energética de São Paulo | 1261485156 | 0 |  | 40089457393 | 0 |  |  | 0 |  | Conforme informação recebida de Edson Pavão (ENRON's Lawyer) e/ou J.P.Morgan através de telefone/Fax/E-Mail.
1999-01-29 00:00:00 | Acionistas Minoritários |  | 0 |  |  | 0 |  |  | 0
1999-01-29 00:00:00 | TOTAL |  | 0 |  |  | 0 |  |  | 528598154.94
Capital Social composto por ações Nominativas Escriturais, sem valor nominal.
Nota: As informações contidas na parte cinza representam a posição atual da empresa, para efeito comparativo com posições anteriores.
Spreadsheet: 133017d1324087653-listing-a-number-when-picking-a-name-vlookup-not-working-bp_2012-update
Sheet: Sheet1

 | Count | Job # | Quarter | Account ID | Producer | Director | Participation | Rep | Participation2 | Bid A-K | [NAME] | Production Fee | Over/(Under) | Income | Margin
 | 1 | 101-001 | Q4 | Chevy | [NAME] | [NAME]
 | 2 | 101-002 | Q1 | Nike | [NAME] | [NAME]
 | 3 | 101-003 | Q2 | Ferrari | [NAME]
 | 4 | 101-004 | Q2 | Apple | [NAME]
 | 5 | 101-005 | Q2 | P&G | [NAME]
 | 6 | 101-006 | Q3
 | 7 | 101-007 | Q3
 | 8 | 101-008 | Q3
 | 9 | 101-009 | Q4
 | 10 | 101-010 | Q4
 | 11 | 101-011 | Q4
 | 12 | 101-012
 | 13 | 101-013
 | 14 | 101-014
 | 15 | 101-015
 | 16 | 101-016
 | 17 | 101-017
 | 18 | 101-018
 | 19 | 101-019
 | 20 | 101-020
 | 21 | 101-021
 | 22 | 101-022
 | 23 | 101-023
 | 24 | 101-024
 | 25 | 101-025
 | 26 | 101-026
 | 27 | 101-027
Spreadsheet: 168897d1342624816-multiple-search-and-sumif-mock-up
Sheet: A

 |  |  |  |  |  | 2012-01-01 00:00:00
 | Category | Place | Person
 | A | Holland | 1 |  |  | Lookup by year and then by Catgory, Place and Person
 | B | America | 2
 | C | Japan | 3
Spreadsheet: 97d8c947-138e-4622-9abb-6e31cfca7e37
Sheet: Sheet1

Bevölkerung des Freistaates Sachsen nach ausgewählten Altersgruppen | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
[NAME]
Alter von ... bis                     unter ... Jahren | 2011 | 2015 | 2020 | 2025
1 000
unter 55 | 34083 | 31365 | 27795 | 25217
55 - 60 | 4962 | 4850 | 5038 | 4129
60 - 65 | 4307 | 4792 | 4631 | 4849
65 - 75 | 7936 | 7384 | 7858 | 8625
75 - 85 | 5056 | 5956 | 6250 | 5608
85 und mehr | 1797 | 2066 | 2382 | 3029
Insgesamt | 58141 | 56413 | 53954 | 51457
%
unter 55 | 58.62128274367486 | 55.59888678141564 | 51.51610631278496 | 49.00596614649125
55 - 60 | 8.534424932491701 | 8.59730913087409 | 9.337583867739186 | 8.024175525195794
60 - 65 | 7.407853322096283 | 8.494495949515182 | 8.583237572747155 | 9.423402063859145
65 - 75 | 13.64957603068403 | 13.08918157162356 | 14.56425844237684 | 16.76156791107138
75 - 85 | 8.696100858258372 | 10.55785014092496 | 11.58394187641324 | 10.89842004003343
85 und mehr | 3.090762112794758 | 3.66227642564657 | 4.414871927938615 | 5.886468313349011
Insgesamt | 100 | 100 | 100 | 100
Gebietsstand: | 1. Januar 2012
Quelle: | 2011 Bevölkerungsfortschreibung auf Basis der [NAME] vom 03. Oktober 1990
 | 2012 - 2025 Bevölkerungsprognose
Bevölkerung jeweils am 31. Dezember
Prognoseergebnisse werden bei der Veröffentlichung immer auf volle [NAME] gerundet. [NAME] basieren [NAME] ungerundeten Werten. Beim [NAME] der [NAME] werden Ihnen die ungerundeten [NAME] zur Verfügung gestellt, damit [NAME] eigenen Berechnungen genauer durchführen können. Die Darstellung der Ergebnisse sollte dann aber wieder gerundet erfolgen.
Spreadsheet: 79406d1279667775-print-to-custom-labels-with-serial-scratch
Sheet: Sheet1

5 | << Number of labels
3 | << Observed number of lines that print per label (as seen by page breaks)
$A$5:$A$19 | << Print_Area
[NAME]
1 of 5
[NAME]
2 of 5
[NAME]
3 of 5
[NAME]
4 of 5
[NAME]
5 of 5
[NAME]
6 of 5
[NAME]
7 of 5
[NAME]
8 of 5
[NAME]
9 of 5
[NAME]
10 of 5
[NAME]
11 of 5
[NAME]
12 of 5
[NAME]
13 of 5
[NAME]
14 of 5
[NAME]
15 of 5
[NAME]
16 of 5
[NAME]
17 of 5
[NAME]
18 of 5
[NAME]
19 of 5
[NAME]
20 of 5
[NAME]
21 of 5
[NAME]
22 of 5
[NAME]
23 of 5
[NAME]
24 of 5
[NAME]
25 of 5
[NAME]
26 of 5
[NAME]
27 of 5
[NAME]
28 of 5
[NAME]
29 of 5
[NAME]
30 of 5
[NAME]
31 of 5
[NAME]
32 of 5
[NAME]
33 of 5
[NAME]
34 of 5
[NAME]
35 of 5
[NAME]
36 of 5
[NAME]
37 of 5
[NAME]
38 of 5
[NAME]
39 of 5
[NAME]
40 of 5
[NAME]
41 of 5
[NAME]
42 of 5
[NAME]
43 of 5
[NAME]
44 of 5
[NAME]
45 of 5
[NAME]
46 of 5
[NAME]
47 of 5
[NAME]
48 of 5
[NAME]
49 of 5
[NAME]
50 of 5
[NAME]
51 of 5
[NAME]
52 of 5
[NAME]
53 of 5
[NAME]
54 of 5
[NAME]
55 of 5
[NAME]
56 of 5
[NAME]
57 of 5
[NAME]
58 of 5
[NAME]
59 of 5
[NAME]
60 of 5
[NAME]
61 of 5
[NAME]
62 of 5
[NAME]
63 of 5
[NAME]
64 of 5
[NAME]
65 of 5
[NAME]
66 of 5
[NAME]
67 of 5
[NAME]
68 of 5
[NAME]
69 of 5
[NAME]
70 of 5
[NAME]
71 of 5
[NAME]
72 of 5
[NAME]
73 of 5
[NAME]
74 of 5
[NAME]
75 of 5
[NAME]
76 of 5
[NAME]
77 of 5
[NAME]
78 of 5
[NAME]
79 of 5
[NAME]
80 of 5
[NAME]
81 of 5
[NAME]
82 of 5
[NAME]
83 of 5
[NAME]
84 of 5
[NAME]
85 of 5
[NAME]
86 of 5
[NAME]
87 of 5
[NAME]
88 of 5
[NAME]
89 of 5
[NAME]
90 of 5
[NAME]
91 of 5
[NAME]
92 of 5
[NAME]
93 of 5
[NAME]
94 of 5
[NAME]
95 of 5
[NAME]
96 of 5
[NAME]
97 of 5
[NAME]
98 of 5
[NAME]
99 of 5
[NAME]
100 of 5
Spreadsheet: 741135d1626857627-vba-use-colours-in-a-list-the-brings-the-same-colour-through-to-a-dropdown-list-coloured-list
Sheet: Found

Enter House Configuration on this row |  |  |  | Semi |  | 3 block |  | Semi |  | Semi |  | Semi |  | Apt |  | Semi |  | 4 block
Work Element | Unit | Rate |  | Cedar |  | Lime |  | Rowen |  | Hedge |  | Oak |  | Pine |  |  |  |  |  |  |  |  |  | 5 |  | 6 |  | 7 |  | 8 |  | 9 |  | 10 |  | 11 |  | 12 |  | 13 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 |  |  | Qty | £ | Qty | £ | Qty | £ | Qty | £ | Qty | £ | Qty | £ | Qty | £ | Qty | £ | Qty | £ | Qty | £ | Qty | £ | Qty | £ | Qty | £ | Qty | £ | Qty | £ | Qty | £ | Qty | £ | Qty | £ | Qty | £ | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4
Spreadsheet: 7d605371-8cdb-425f-bb27-d02e5256137d
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
NACCL | Test | NACCL | Sodium, Serum | Sodium, S | Potentiometric, Indirect Ion-Selective Electrode. Also available as part of [NAME]. | Serum Gel Tube: SGT |  |  | 1 | mL | Container/Tube:  Preferred: Serum gel Acceptable: Red top [NAME]: 0.5 mL Additional Information: Patient's age and sex are required. | 0.25 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm reject; Cold OK Lipemia	NA Icterus	NA Other	NA | > or =12 months: 135-145 mmol/L  Reference values have not been established for patients that are less than 12 months of age. | Monday through Sunday; Continuously | Same day/1 day | 2 days | 1 | 84295 |  |  |  |  | Rochester
NACCL | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
NACCL | Result | NACCL | Sodium, S | Sodium, S | Numeric |  |  |  |  | mmol/L |  |  |  |  |  |  |  |  |  | 2951-2 | Sodium:SCnc:Pt:Ser/Plas:Qn:
Spreadsheet: joe_parks__14953__bridgeline 5-1
Sheet: Sheet1

b/s | contract | price | volume | time | cm | account | cti | order # | trader | reference | trade #
B | NGM2 | 3736 | 15 | 17:43:05 | 905 | 97563 | 4C | 2253 | [NAME] | EO-2253 | 1082 | 0 | Y
B | NGM2 | 3741 | 20 | 17:28:26 | 905 | 97563 | 4C | 2353 | amk | EO-2353 | 954 | 0 | Y
B | NGM2 | 3745 | 17 | 17:03:45 | 905 | 97563 | 4C | 2188 | amk | [NAME] | 706 | 0 | Y
B | NGM2 | 3746 | 1 | 16:50:56 | 905 | 97563 | 4C | 1093 | ebc | EO-1093 | 472 | 0 | Y
B | NGM2 | 3746 | 10 | 16:54:18 | 905 | 97563 | 4C | 1093 | ebc | EO-1093 | 543 | 0 | Y
B | NGM2 | 3746 | 9 | 16:54:24 | 905 | 97563 | 4C | 1093 | ebc | EO-1093 | 544 | 0 | Y
B | NGM2 | 3750 | 5 | 17:01:41 | 905 | 97563 | 4C | 2135 | amk | EO-2135 | 680 | 0 | Y
B | NGM2 | 3775 | 5 | 08:15:24 | 905 | 97563 | 4C | 4787 | amk | EO-4787 | 2306 | 0 | N
B | NGM2 | 3785 | 15 | 16:41:41 | 905 | 97563 | 4C | 1342 | amk | EO-1342 | 276 | 0 | Y
S | NGN2 | 3805 | 4 | 08:59:21 | 905 | 97563 | 4C | 5039 | ebc | EO-5039 | 2463 | 0 | N
Spreadsheet: tracy_geaccone__40529__ETS - NPNG IC 10-19
Sheet: IT Infrastructure Services

 | IT Infrastructure Services
 | Service Category | Service | Service Options | Unit / Available driver
 | Customer Support | Resolution Center |  | # of users
 |  | Desktop support | General | # of general users
 |  |  | Traders | # of trader users
 |  |  | Executive | # of executive users
 |  |  | Remote | # of remote users
 |  | Desktop Hardware Support |  | # of users
 |  | Printer Management Support |  | # [NAME] users
 | Production Operations Services | Production Operations Management |  | % of total users
 |  | Enterprise Command Center |  | % of total users
 |  | Change & Configuration Management |  | % of total users
 |  | [NAME] (Future Service) |  | TBD
 |  | Security Administration |  | % of total users
 |  | Data Center Operations |  | Total Square Feet Occupied
 |  | IT Security Policy, Monitoring, and Investigation |  | # of users
 |  | Software - Desktop Maintenance & Support |  | Actual Spend
 |  | Software - Server Maintenance & Support |  | Actual Spend
 |  | Application Storage Support |  | % of Total storage costs
 |  | User & Data Volume Support |  | # of users
 |  | Remote Infrastructure Operation & Support |  | % of remote infrastructure support costs
 |  | Remote Trading Management |  | % of remote trading infrastructure support costs
 |  | UNIX Application Infrastructure |  | # of UNIX servers used
 |  | General UNIX Infrastructure |  | # of users
 |  | NT Application Infrastructure |  | # of NT servers used
 |  | General NT Infrastructure |  | # of users
 |  | Remedy |  | % of total users
 |  | Email Administration |  | # of users
 |  | Market Data Admin. Support |  | % of Actual Usage
 |  | Market Data Feeds |  | % of Actual Usage
 |  | Disk Space Allocations (E-mail) |  | # of Stored Megabytes
 |  | Messaging Operations (Exchange) |  | # of users
 |  | Web Operations |  | # of users
 |  | Terminal Server Operations |  | # of users
 |  | Distributed Applications Management |  | % of total users
 |  | EDI |  | % of Usage of 1000 characters
 | Data Communications Support | LAN Support |  | # of users
 |  | [NAME] |  | % of WAN Circuit costs
 |  | DMZ Security |  | # of users
 |  | 24x7 Support |  | % of WAN Circuit costs
 | Voice Communications Support | Telephony support |  | # of users
 |  | Communication Trading Support |  | #of Traders
 |  | Long Distance |  | % of Total Usage
 |  | 800 (Inbound) |  | % of Total Usage
 |  | Calling Card |  | % of Total Usage
 |  | Audio Conferencing |  | % of Total Usage
 |  | Video Conferencing |  | # of video hrs
 |  | Internet Access |  | # of users
 |  | EOL Internet Access |  | # of users
 |  | ETS - Omaha Internet Access |  | # of users
 |  | MAN |  | % of Houston users
 |  | Remote Access (dial/VPN) |  | # of users
 |  | [NAME] |  | % of Total Usage
 |  | Voice Circuit |  | # of users
 |  | [NAME] |  | % of Total Usage
 |  | Communications - Churns |  | Usage per Churn
 | Special Services Support | Business Administration Project Management |  | % of total users
 |  | Technical Architecture Oversight |  | % of total users
Spreadsheet: 678396d1589870400-request-for-automated-installment-dates-installment-dates-not-resolved
Sheet: Sheet3 (2)

Want a [NAME] upto 24 installments
 | Rent Start Date | 2020-01-01 00:00:00 |  |  |  |  | Considering date as 01/01/2020
 | Rent End Date | 2020-12-31 00:00:00 |  |  |  |  | if the No. of Installment is | 1 | 2020-01-01 00:00:00
 | No of installments | 4
 | Amount | 50000 |  |  |  |  |  | 2 | 2020-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 2020-06-01 00:00:00
Si No | Date | Amount |  |  |  |  |  | 3 | 2020-01-01 00:00:00
1 | 2020-01-01 00:00:00 |  |  |  |  |  |  |  | 2020-05-01 00:00:00
2 | 2020-04-01 00:00:00 |  |  |  |  |  |  |  | 2020-09-01 00:00:00
3 | 2020-07-01 00:00:00
4 | 2020-09-01 00:00:00 |  |  |  |  |  |  | 4 | 2020-01-01 00:00:00
 |  |  |  |  |  |  |  |  | 2020-04-01 00:00:00
 |  |  |  |  |  |  |  |  | 2020-07-01 00:00:00
 |  |  |  |  |  |  |  |  | 2020-09-01 00:00:00
Spreadsheet: 837884d1690477502-network-days-with-time-fraction-less-than-full-working-day-network-days-3-
Sheet: Network days

ADP | Full Name | Absence From | Absence To | Duration | Network Days | Expected Result
10906 | A | 2023-06-29 00:00:00 | 2023-06-30 00:00:00 | 2 |  | 2
11073 | B | 2023-07-03 00:00:00 | 2023-07-03 00:00:00 | 1 |  | 1
11430 | C | 2023-07-03 00:00:00 | 2023-07-04 00:00:00 | 2 |  | 2
11566 | D | 2023-07-10 00:00:00 | 2023-07-10 00:00:00 | 1 |  | 1
11590 | E | 2023-06-29 00:00:00 | 2023-06-30 00:00:00 | 2 |  | 2
20053 | F | 2023-06-27 00:00:00 | 2023-07-03 00:00:00 | 5 |  | 5
20074 | G | 2023-07-05 00:00:00 | 2023-07-07 00:00:00 | 3 |  | 3
20175 | H | 2023-07-03 00:00:00 | 2023-07-06 00:00:00 | 4 |  | 4
20176 | I | 2023-06-29 09:00:00 | 2023-06-29 00:00:00 | 0.0625 |  | 0.0625
20197 | J | 2023-07-10 00:00:00 | 2023-07-10 00:00:00 | 1 |  | 1
20698 | K | 2023-07-04 09:00:00 | 2023-07-04 00:00:00 | 0.875 |  | 0.875
20882 | L | 2023-07-11 07:30:00 | 2023-07-11 00:00:00 | 0.8125 |  | 0.8125
20949 | M | 2023-07-07 08:45:00 | 2023-07-07 00:00:00 | 0.6562 |  | 0.6562
20951 | N | 2023-06-19 00:00:00 | 2023-06-20 00:00:00 | 2 |  | 2
20955 | O | 2023-07-11 11:30:00 | 2023-07-11 00:00:00 | 0.375 |  | 0.375
20995 | P | 2023-06-26 00:00:00 | 2023-06-26 00:00:00 | 1 |  | 1
20995 | P | 2023-07-06 10:30:00 | 2023-07-06 00:00:00 | 0.5 |  | 0.5
21006 | q | 2023-07-05 00:00:00 | 2023-07-06 00:00:00 | 0.5 |  | 0.5
21030 | S | 2023-07-10 00:00:00 | 2023-07-10 00:00:00 | 1 |  | 1
20199 | U | 2023-06-16 11:30:00 | 2023-06-17 00:00:00 | 1.5 |  | 1.5
20247 | V | 2023-06-14 06:30:00 | 2023-06-17 00:00:00 | 3.8636 |  | 3.8636
Spreadsheet: 733054d1621365273-need-help-with-ideas-for-scanning-inventory-test-draft
Sheet: Sheet1

PO | Service Tag | Scanned tag | Model | Location | Match
1 | 1ABCDEF |  | 1111 | Blank
1 | 2ABCDEF |  | 1111 | Blank
1 | 3ABCDEF |  | 1111 | Blank
1 | 4ABCDEF |  | 1111 | Blank
1 | 5ABCDEF |  | 1111 | Blank
1 | 6ABCDEF |  | 1111 | Blank
Spreadsheet: 66606d1267223422-list-generated-based-off-of-dates-example
Sheet: Sheet1

Name | Amount Deposited | Number of Visits | Start Date | End Date
[NAME] | 2.5 | 2 | 2010-01-01 00:00:00 | 2010-03-01 00:00:00
[NAME] | 0.39 | 3 | 2010-03-01 00:00:00 | 2010-09-01 00:00:00
[NAME] | 2 | 2 | 2010-01-01 00:00:00 | 2010-12-31 00:00:00
Jan | 1.37 | 11 | 2010-01-01 00:00:00 | 2010-12-31 00:00:00
Dawn | 5.43 | 4 | 2010-01-01 00:00:00 | 2010-06-09 00:00:00
Dawn | 2.54 | 5 | 2010-06-10 00:00:00 | 2010-12-31 00:00:00
Sean | 7.43 | 8 | 2010-01-01 00:00:00 | 2010-03-31 00:00:00
Sean | 3.55 | 7 | 2010-04-01 00:00:00 | 2010-12-31 00:00:00
[NAME] | 6.22 | 8 | 2010-09-02 00:00:00 | 2010-12-31 00:00:00
Start | Stop
2010-01-01 00:00:00 | 2010-08-15 00:00:00
Name | Total # | [NAME]
 |  |  |  | Need the list to automatically generate, based off the two dates listed in row 13
Spreadsheet: 456855d1461089264-lookup-data-in-multiple-columns-to-sum-values-in-corresponding-cells-excel-froum-help-example-data
Sheet: Data

Order Number | Line Number | Size | Qty | Price | Total
100123 | SS-123 | S | 20 | 5
100123 | SS-123 | M | 50 | 5
100123 | SS-124 | S | 20 | 10
100123 | SS-124 | M | 50 | 10
100124 | SS-125 | L | 40 | 15
100124 | SS-126 | XL | 10 | 5
100124 | SS-126 | L | 40 | 5
100124 | SS-125 | XL | 10 | 15