tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 720170d1614048822-inserting-additional-criteria-to-an-if-statement-worktimecalcefupdated
Sheet: Correct

STRT | END | WRK | RT | ST | OT |  | Overall Day
 |  |  |  |  |  |  | Report | 05:37:00
 |  |  |  |  |  |  | Start Shift
 |  |  |  |  |  |  | End Shift | 10:54:00
 |  |  |  |  |  |  | 1st Half Pay
 |  |  |  |  |  |  |  | Break
 |  |  |  |  |  |  | Report | 12:55:00
 |  |  |  |  |  |  | Start Shift
 |  |  |  |  |  |  | 11th Hour
 |  |  |  |  |  |  | End Shift | 14:59:00
 |  |  |  |  |  |  | Straight Time
 |  |  |  |  |  |  | Overtime
Spreadsheet: 218709d1362550729-find-upc-code-from-material-numbers-and-populate-3-bracket-prices-actualexample
Sheet: Sheet2

Customer: |  |  |  | Reclaim Fee |  | Chargeback
Case ID: |  |  |  | Price Difference | 21.72 | 21.72
X-Reference: |  |  |  | Total Valid | 1099.6
Dispute Case Amount: |  |  |  | Total Dispute | 1121.32
ENTER DATA HERE |  |  | DON’T TOUCH ANYTHING HERE
Enter [NAME] | Qty | Customer Amount | Customer Price | Bracket 1 Unit Price | Bracket 1 Unit Total | Price Difference
1775 | 144 | 141.12 | 0.98 | 0.9700000000000001 | 139.68 | 1.439999999999998
01775 Total |  |  |  |  | 139.68
1776 | 108 | 105.84 | 0.98 | 0.9700000000000001 | 104.76 | 1.079999999999998
01776 Total |  |  |  |  | 104.76
1777 | 144 | 141.12 | 0.98 | 0.9700000000000001 | 139.68 | 1.439999999999998
01777 Total |  |  |  |  | 139.68
13448 | 16 | 17.76 | 1.11 | 0 | 0 | 17.76
13448 Total |  |  |  |  | 0
66015 | 8 | 15.92 | 1.99 | 1.99 | 15.92 | 0
66015 Total |  |  |  |  | 15.92
72215 | 64 | 149.76 | 2.34 | 2.34 | 149.76 | 0
72215 Total |  |  |  |  | 149.76
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
 |  |  | 0 | 0 | 0 | 0
Grand Total |  |  |  |  | 549.8
END
Spreadsheet: 772194d1647067638-auto-populate-reward-rewarding
Sheet: Sheet1

Group | Member |  |  |  |  | Reward
 | 1 | 2 | 3 | 4 | 5 | $100 | Token
1 | Alpha
2 | Bravo | [NAME] | echo
3 | [NAME]
4 | Bravo
5 | Fox | Alpha
5 | Alpha
5 | Echo
5 | Golf | Charlier | Bravo
Rules:
1) If 1st entry and solo = $100 only
2) If 1st entry with member = token only
3) If 2nd entry and solo = token only
4) If 2nd entry with member = token only
Spreadsheet: 132632d1323868310-sales-rankings-ranking
Sheet: Sheet1

 |  |  |  | Sales Rank in Pattern
 | Pattern | Sku | Sales
 | [NAME] | V.W. DUSK PITCHER M/S
 | [NAME] | V.W. DUSK 4 PIECE SET | 500
 | [NAME] | V.W. DUSK BOWL CEREAL 6.0 | 1000
 | [NAME] | V.W. DUSK PLATE  9.0 23CM | 20
 | [NAME] | V.W. DUSK MUG                       (MF) | 79.8
 | [NAME] | V.W. DUSK DINNER PLATE 10.75  LINC
 | [NAME] | V.W. DUSK PITCHER L/S
 | [NAME] | V.W. DUSK RECTANGULAR TRAY 15.0 | 525
 | [NAME] | V.W. DUSK ROUND SERVING BOWL 10.0
 | [NAME] | V.W. DUSK BOWL                    M/S
 | [NAME] | V.W. DUSK ROUND PLATTER
 | [NAME] | DUSK SUGAR
 | [NAME] | V.W. DUSK CREAMER | 76.64
 | [NAME] | VW NATURALS DUSK LOW FRUIT BOWL 33CM
 | [NAME] | V.W. DUSK DIP BOWL 4.0
 | [NAME] | V.W. DUSK SQUARE PLATTER/CHARGER PLATE
 | [NAME] | V.W. DUSK PLATE SQUARE 9.0
 | [NAME] | VERA FLIRT 5PPS
 | [NAME] | VERA FLIRT RIM SOUP | 854
 | [NAME] | VERA FLIRT OVAL PLATTER | 653
 | [NAME] | VERA FLIRT OPEN VEG | 754
 | [NAME] | VERA FLIRT ACCENT PLATE
 | [NAME] | VERA FLIRT DINNER | 80
 | [NAME] | VERA FLIRT TEAPOT
 | [NAME] | VERA FLIRT CREAMER | 24.54
 | [NAME] | VERA FLIRT SUGAR
 | [NAME] | VERA FLIRT SALAD
 | [NAME] | VERA FLIRT B&B
 | [NAME] | V.W. VERA FLIRT TEACUP IMP
 | [NAME] | VERA FLIRT 5PPS
 | [NAME] | V.W. VERA FLIRTA TEASAUCER IMP
 | [NAME] | VERA FLIRTSOP/SAL BWL 6.0 | 207.26
Spreadsheet: 54302d1254315532-look-at-cells-and-return-lowest-value-book1
Sheet: Sheet1

 |  |  | 4
 |  |  |  | 9 | 11
 |  |  |  | 1 | 6
 |  |  |  | 1 | 18
 |  |  |  | 3 | 9
 |  |  |  | 8 | 2
 |  |  |  | 10 | 9
 |  |  |  | 6 | 8
 |  |  |  | 6 | 16
 |  |  |  | 6 | 19
 |  |  |  | 4 | 5
 |  |  |  | 6 | 7
 |  |  |  | 7 | 17
 |  |  |  | 5 | 2
 |  |  |  | 10 | 19
 |  |  |  | 10 | 9
 |  |  |  | 1 | 4
 |  |  |  | 4 | 14
 |  |  |  | 5 | 16
 |  |  |  | 8 | 18
 |  |  |  | 3 | 5
 |  |  |  | 7 | 19
 |  |  |  | 5 | 1
Spreadsheet: 869759d1716337431-find-the-time-period-a-customer-returns-test-customer
Sheet: Sheet1

 |  |  |  | Customer |  | Date
 |  |  |  | 11 |  | 2024-01-01 00:00:00 |  | 0 - 1 month | ?
 |  |  |  | 22 |  | 2024-03-03 00:00:00 |  | 1- 3 month | ?
 |  |  |  | 22 |  | 2024-02-11 00:00:00 |  | 3 - 6 month | ?
 |  |  |  | 22 |  | 2024-01-23 00:00:00 |  | 6 - 12 month | ?
 |  |  |  | 333 |  | 2024-02-02 00:00:00 |  | 12 - 24 month | ?
 |  |  |  | 11 |  | 2024-02-22 00:00:00 |  | 24+ | ?
 |  |  |  | 33 |  | 2024-01-09 00:00:00
 |  |  |  | 44 |  | 2024-02-12 00:00:00
 |  |  |  | 44 |  | 2024-04-09 00:00:00
 |  |  |  | 55 |  | 2024-03-03 00:00:00
 |  |  |  | 11 |  | 2024-04-22 00:00:00
 |  |  |  | 11 |  | 2024-04-03 00:00:00
 |  |  |  | 33 |  | 2024-03-22 00:00:00
 |  |  |  | 6 |  | 2024-03-20 00:00:00
Spreadsheet: 888192d1738665785-data-condensing-based-on-multiple-criteria-invoice-condenser
Sheet: Sheet1

 | 1234 | 5.85 | 39 | 18.68 | 728.52
 | Product A | 3216540000 | Country Origin: UK
 | 5678 | 9.15 | 61 | 19.9 | 1213.9
 | Product B | 6541230000 | Country Origin: JP
 | 4321 | 12 | 100 | 5.5 | 550
 | Product C | 9632541000 | Country Origin: UK
 | 8765 | 9.9 | 100 | 12.89 | 1289
 | Product D | 2365987000 | Country Origin: US
 | 5678 | 12.38 | 100 | 19.9 | 1990
 | Product B | 6541230000 | Country Origin: JP
 | 4321 | 12 | 100 | 5.5 | 550
 | Product C | 9632541000 | Country Origin: US
 | 1234 | 7.72 | 78 | 18.68 | 1457.04
 | Product A | 3216540000 | Country Origin: UK
 | 1234 | 12.91 | 93 | 18.68 | 1737.2
 | Product A | 3216540000 | Country Origin: UK
 | 8765 | 9.9 | 100 | 12.89 | 1289
 | Product D | 2365987000 | Country Origin: US
 | 1234 | 9.9 | 100 | 18.68 | 1868
 | Product A | 3216540000 | Country Origin: UK
Spreadsheet: 00551d62-fefd-4ad6-81ec-ec2ba974946c
Sheet: Ranked List

Rank | Reference | Outcome
1 | BB/[NAME] | Funded
2 | BB/L024233/1 | Funded
3 | BB/L020742/1 | Funded
4 | BB/L021269/1 | Funded
5 | BB/L020718/1 | Funded
5 | BB/L024144/1 | Funded
6 | BB/L024209/1 | Funded
7 | BB/L024225/1 | Funded
7 | BB/L024128/1 | Funded
8 | BB/L024152/1 | Funded
8 | BB/[NAME] | Funded
9 | BB/L024179/1 | Funded
10 | BB/L024055/1 | Funded
10 | BB/L021390/1 | Funded
10 | BB/[NAME] | Funded
10 | BB/L024101/1 | Funded
11 | BB/L020319/1 | Funded
12 | BB/L024098/1 | Fundable
13 | BB/L024187/1 | Fundable
13 | BB/L024195/1 | Fundable
13 | BB/[NAME] | Fundable
13 | BB/L024241/1 | Fundable
14 | BB/L018837/1 | Fundable
14 | BB/L02411X/1 | Fundable
15 | BB/L024039/1 | Fundable
15 | BB/L024020/1 | Fundable
16 | BB/L02327X/1 | Fundable
16 | BB/L02408X/1 | Fundable
17 | BB/L024160/1 | Fundable
17 | BB/L024047/1 | Fundable
18 | BB/L023539/1 | Fundable
18 | BB/L023911/1 | Fundable
19 | BB/L022591/1 | Fundable
19 | BB/L024063/1 | Fundable
20 | BB/L020734/1 | Fundable
21 | BB/L021587/1 | Fundable
Spreadsheet: aedf0cac-66e6-4d54-a3f8-a2fbf6a4edcd
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
CITAL | Test | CITAL | Citalopram, Serum | Citalopram, S | Liquid Chromatography-Tandem Mass Spectrometry (LC-MS/MS) | Plain, Red-Top Tube: Red |  |  | 0.5 | mL | Container/Tube: Red top [NAME]: 0.5 mL Collection Instructions: Spin down within 2 hours of draw. | 0.4 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm OK; Cold OK Lipemia	Mild OK; Gross reject Icterus	Mild OK; Gross reject Other	Serum gel tube | R,S-Citalopram: 100-250 ng/mL S-Citalopram: 50-130 ng/mL | Monday, Wednesday, Friday; 5 p.m. | 1 days | 3 days | 1 | 80299 |  |  |  |  | Rochester
CITAL | [NAME] | SRED | Serum Red |  |  |  | Refrigerated | 14 days
CITAL | Result | 83730 | Citalopram, S | Citalopram, S | Numeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | 34635-3 | Citalopram:MCnc:Pt:Ser/Plas:Qn:
Spreadsheet: 139402d1328218798-vertical-lines-and-arrows-at-specific-dates-post-surgery-psa-chart_jpr73
Sheet: PSA data

[NAME] Post Prostatectomy PSA
(Prostatectomy was on March 2, 2009)
Date | CPL | LabCorp | Radiation |  | Blader Stone Removal |  |  | Axis Options : Main unit
2009-06-02 00:00:00 | 0.003 |  | 2011-08-04 00:00:00 | 0 | 2010-10-12 00:00:00 | 0
2009-09-01 00:00:00 | 0.009 |  | 2011-08-04 00:00:00 |  | 2010-10-12 00:00:00
2009-12-18 00:00:00 | 0.003 |  | 2011-09-30 00:00:00 | 0
2010-03-02 00:00:00 | 0.006 |  | 2011-09-30 00:00:00
2010-09-02 00:00:00 | 0.021
2010-09-16 00:00:00 | 0.026
2010-10-05 00:00:00 | 0.025
2010-10-27 00:00:00 | 0.019
2010-11-10 00:00:00 | 0.027
2010-11-23 00:00:00 | 0.023
2010-12-08 00:00:00 | 0.035
2010-12-22 00:00:00 | 0.044
2011-01-05 00:00:00 | 0.034
2011-01-31 00:00:00 | 0.038
2011-02-28 00:00:00 | 0.047
2011-04-01 00:00:00 |  | 0.04
2011-04-06 00:00:00 | 0.052
2011-05-03 00:00:00 |  | 0.04
2011-05-12 00:00:00 | 0.052
2011-06-01 00:00:00 |  | 0.05
2011-06-15 00:00:00 | 0.063
2011-07-01 00:00:00 |  | 0.05
2011-07-19 00:00:00 | 0.066
2011-08-01 00:00:00 |  | 0.07
2011-08-16 00:00:00 | 0.072
2011-09-06 00:00:00 |  | 0.08
2011-10-03 00:00:00 |  | 0.09
2011-11-01 00:00:00 |  | 0.08
2011-11-15 00:00:00 | 0.079
2011-12-01 00:00:00 |  | 0.08
2012-01-04 00:00:00 |  | 0.1
2012-01-30 00:00:00 |  | 0.11
Spreadsheet: 07f02f37-33ab-4778-b445-002bf9f138b3
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
FFTIN | Test | FFTIN | Tin, Serum | Tin, Serum | Inductively Coupled Plasma-Mass Spectrometry (ICP-MS) | Metal free or acid washed containers: MForAW OR Royal blue-top Monoject trace element blood collection tube: RylBlue OR |  |  | 2 | mL | Submit only 1 of the following specimens:   Serum Draw blood in a metal free tube(s). (Serum gel tube is not acceptable.) Spin down and send 2 mL of metal free serum  refrigerated. Hemolyzed specimens are not recommended.  Note:	1. Indicate serum on request form. 	2. Label specimen appropriately (serum).  [NAME] blood in an EDTA metal-free royal blue-top tube(s).   ([NAME] is not acceptable.) Spin down and send  2 mL metal-free EDTA plasma refrigerated. Hemolyzed  specimens are not recommended.  Note:	1. Indicate plasma on request form. 	2. Label specimen appropriately (plasma). | 0.2 mL NOTE: Submission of the m | Specimens other than	Serum, plasma Anticoagulants other than	Royal blue-top metal free with or without EDTA  Hemolysis	Mild OK; Gross reject Thawing	NA Lipemia	NA Icteric	NA | Reference Range:  <5.0 ng/mL   Toxic range has not been established.      NOTE: Whole blood is the preferred specimen for monitoring  	 exposure to tin.   Test Performed by: Medtox Laboratories, Inc.                                       402 W. County Road D                                       St. Paul, MN 55112 | Monday through Sunday | 3 days | 5 - 7 days | 1 | 83018 |  |  |  |  | Medtox Laboratories, Inc
FFTIN | [NAME] | VARIES | Varies |  |  |  | Refrigerated
FFTIN | Result | Z1182 | Tin | Tin | Alphanumeric |  |  |  |  | ng/mL |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 162202d1339767017-pivot-table-help-pivot-table-sample
Sheet: Pivot

 | Values
Row Labels | Sum of Revenue (Absolute) | Sum of GP
Shipper 1 | 3155.81 | 440.26
Shipper 2 | 2362.88 | 779.9699999999998
Shipper 3 | 2451.79 | 850.54
Shipper 4 | 1972.42 | 34.17000000000007
Shipper 5 | 4787.82 | 912.5599999999997
Grand Total | 14730.72 | 3017.499999999999
Spreadsheet: 88354d1288193795-copy-insert-row-n-times-based-on-value-and-fill-series-copy_n_times
Sheet: Before

[NAME] | COUNTY_NAME | CITY_NAME | ZIP_START
Alabama | Autauga | Prattville | 36066 |  | 2
Alabama | Baldwin | [NAME] | 36526 |  | 1
Alabama | Baldwin | Fairhope | 36532 |  | 1
Alabama | Baldwin | [NAME] | 36535 |  | 1
Need to copy row based on value in column F.
Then change copied value of column D to a fill series value based on the same number of times the row was copied.
See after tab for result.
Spreadsheet: 805952d1669031435-apply-formula-based-on-the-equality-of-adjacent-cells-excelforum21-ans2
Sheet: Sheet1

Barcode 1 | [NAME] apply downwards
A
A
A
A
B
B
B
B
B
B
B
C
A
Spreadsheet: kate_symes__18451__Palo
Sheet: DJ Palo Verde Electricity Index

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume |  | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME] |  | 24 HOUR | [NAME]
 | 2001-01-11 00:00:00 |  | 160.31 | 19472 | 90.92 | 3800
 | 2001-01-10 00:00:00 |  | 143.16 | 18208 | 84.37 | 3352 | 129.46 | 2981 | 93.14 | 1118
 | 2001-01-09 00:00:00 |  | 132.19 | 14400 | 75.61 | 4552 | 145.14 | 850 | 87.82 | 1753
 | 2001-01-08 00:00:00 |  | 127.4 | 15728 | 68.15 | 5768 | 140.11 | 1652 | 87.68 | 460
 | 2001-01-07 00:00:00 |  | 121.67 | 2400 | 65 | 800 | 84.12 | 1047 | 58.43 | 682 |  | 69.34 | 16944
 | 2001-01-06 00:00:00 |  | 121.11 | 22672 | 71.97 | 5784 | 90.26 | 442 | 59.63 | 622
 | 2001-01-05 00:00:00 |  | 121.35 | 23072 | 72.24 | 5984 | 105.21 | 932 | 98.02 | 734
 | 2001-01-04 00:00:00 |  | 131.61 | 14064 | 79.75 | 6272 | 120.52 | 512 | 71.21 | 514
 | 2001-01-03 00:00:00 |  | 143.06 | 13168 | 85.45 | 3584 | 129.29 | 613 | 75.14 | 791
 | 2001-01-02 00:00:00 |  | 149.82 | 10992 | 93.38 | 2840 | 124.91 | 1327 | 56.75 | 526
 | 2001-01-01 00:00:00 |  | 145 | 0 | 100 | 0 | 70.68 | 2284 | 50.55 | 1025 |  | 93.52 | 7320
 | 2000-12-31 00:00:00 |  | 94.03 | 2480 | 88.53 | 680 | 55.11 | 1961 | 56.69 | 816 |  | 89.07 | 1992
 | 2000-12-30 00:00:00 |  | 121.88 | 6160 | 88.79 | 1344 | 90.2 | 1203 | 69.44 | 897
 | 2000-12-29 00:00:00 |  | 169.36 | 5600 | 86.08 | 1088 | 146.94 | 2282 | 91.56 | 880
 | 2000-12-28 00:00:00 |  | 169.36 | 5600 | 86.08 | 1088 | 138.35 | 2041 | 123.17 | 293
 | 2000-12-27 00:00:00 |  | 232 | 10048 | 123.85 | 728 | 128.78 | 2370 | 96.27 | 690
 | 2000-12-26 00:00:00 |  | 250.55 | 12960 | 173.75 | 800 | 124.75 | 1488 | 90.47 | 590
 | 2000-12-25 00:00:00 |  | 217.21 | 2080 | 175 | 0 | 78.91 | 709 | 55.11 | 871 |  | 204.22 | 10800
 | 2000-12-24 00:00:00 |  | 217.21 | 2080 | 175 | 0 | 92.39 | 584 | 65.56 | 160 |  | 204.22 | 10800
 | 2000-12-23 00:00:00 |  | 276.77 | 11728 | 192.64 | 2800 | 140 | 35 | 121.09 | 184
 | 2000-12-22 00:00:00 |  | 276.77 | 11728 | 192.64 | 2800 | 267.5 | 0 | 80 | 375
 | 2000-12-21 00:00:00 |  | 276.77 | 11728 | 192.64 | 2800 | 252.65 | 1831 | 132.45 | 530
 | 2000-12-20 00:00:00 |  | 269.33 | 15200 | 190.33 | 2688 | 198.54 | 3261 | 151.82 | 927
 | 2000-12-19 00:00:00 |  | 258.18 | 10272 | 178.86 | 1968 | 195.85 | 2305 | 133.46 | 718
 | 2000-12-18 00:00:00 |  | 224.43 | 11840 | 176.78 | 1168 | 220.89 | 1072 | 124.85 | 495
 | 2000-12-17 00:00:00 |  | 196.67 | 1200 | 175.71 | 280 | 136.93 | 985 | 113.5 | 500 |  | 177.12 | 2664
 | 2000-12-16 00:00:00 |  | 233.65 | 12880 | 192.27 | 2704 | 130.23 | 922 | 120.83 | 60
 | 2000-12-15 00:00:00 |  | 238.8 | 13024 | 192.27 | 2704 | 180.19 | 1670 | 128.18 | 706
 | 2000-12-14 00:00:00 |  | 334.66 | 15184 | 213.55 | 2480 | 200 | 150 | 174.54 | 271
 | 2000-12-13 00:00:00 |  | 495.62 | 14992 | 223.93 | 4504 | 276 | 3139 | 184.69 | 2161
 | 2000-12-12 00:00:00 |  | 330 | 9200 | 211.98 | 2688 | 347.7 | 2622 | 193.04 | 1826
Spreadsheet: 251ea124-ae04-48a9-a03a-624be6774d7f
Sheet: 3_FTE per Service (Edit)

Projected FTE per Service (IN MINUTES)
Note:  For additional goods/services, please contact the Office of Financial Analysis
INPUT (WORK DESCRIPTIONS) |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
Description of Work (in minutes):
Set-up time (day 1) | 60 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Set-up time (day 2) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Additional time | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Tech Time (1hrs @ $60) | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] 6 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] 7 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] 8 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] 9 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] 10 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] 11 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] 12 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] 13 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] 14 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] 15 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] 16 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] 17 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] 18 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] 19 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
[NAME] 20 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Total Projected Time to Perform Service: (in Minutes)
Total Projected Time to Perform Service: (in Hrs)
Total Projected Time to Perform Service: (in [NAME]), Rounded to 1/10th
Spreadsheet: 842366d1694462907-if-and-return-value-based-on-2-sets-of-conditions-sample-81-2-2-
Sheet: SPS Template

Account Manager | Rep | Agreement Date | Company | Maricopa | YCO | Yuma | MCO | SAN DIEGO | ORANGE | NEW/RENEW | Total
 |  |  |  | 1000 | Yuma |  | This is great but I need the amount to line up to the right County Column ( as shown in E1:[NAME]), is this feasible?
 |  |  |  | 1500 | Maricopa |  | Please look at A1:K33, this is how I want it to look like, each sale $ falls under the right column for that County
 |  |  |  | 3500 | Maricopa
 |  |  |  | 0
 |  |  |  | 4500 | Maricopa
 |  |  |  | 1125 | SAN DIEGO
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 1500 | SAN DIEGO
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 7000 | Maricopa
 |  |  |  | 3000 | Maricopa
 |  |  |  | 4000 | Maricopa
 |  |  |  | 2120 | SAN DIEGO
 |  |  |  | 3000 | SAN DIEGO
 |  |  |  | 0
 |  |  |  | 3600 | Maricopa
 |  |  |  | 4000 | ORANGE
 |  |  |  | 1500 | ORANGE
 |  |  |  | 1500 | SAN DIEGO
 |  |  |  | 4500 | Maricopa
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 0
 |  |  |  | 1000 | ORANGE
 |  |  |  | 0
Spreadsheet: 718535d1613170250-formula-to-consolidate-data-from-multiple-sheets-get-data-from-multiple-sheets
Sheet: 17

 |  |  | Date | 2021-01-17 00:00:00
Machine | From | To | Total Time | Failure Code | Extention Code | Delay Code | Equip. Name | Stoppage Code | Stoppage Description | Stoppage Category
Machine1 | 08:00:00 | 09:00:00 |  |  |  |  |  | 1000 | Stoppage 1 | Category 1
Machine1 | 09:00:00 | 10:00:00 |  |  |  |  |  | 505 | Stoppage 2 | Category 2
Machine2 | 12:00:00 | 13:00:00 |  |  |  |  |  | 1001 | Stoppage 3 | Category 3
Machine3 | 09:00:00 | 10:00:00 |  |  |  |  |  | 505 | Stoppage 4 | Category 1
Machine4 | 10:00:00 | 20:00:00 |  |  |  |  |  | 1004 | Stoppage 3 | Category 4
Machine5 | 20:00:00 | 23:00:00 |  |  |  |  |  | 505 | Stoppage 2 | Category 2
Machine6 | 20:00:00 | 1 day, 0:00:00 |  |  |  |  |  | 505 | Stoppage 2 | Category 2
Spreadsheet: 140462d1328758441-count-or-sum-multiple-columns-when-the-criteria-is-met-count-and-sum-multiple-criterias
Sheet: Sheet1

A | 1 | 2 | 1 | 4
B | 2 | 2 | 1 | 5
A | 3 | 2 | 1 | 4
C | 3 | 1 | 3 | 6
B | 2 | 3 | 2 | 5
A | 1 | 2 | 3 | 4
I want to count from collum B to E when collum A is B? |  |  |  |  |  |  |  | ?
I want to sum from collum B to E when collum A is B? |  |  |  |  |  |  |  | ?
Spreadsheet: 801003d1666025293-populate-cells-with-data-from-another-sheet-id
Sheet: 1

Company Name | id
"Stichting Woonplus Schiedam"
(PWC) PriceWaterhouseCoopers
2 HD, s.r.o.
2e Systems GmbH
3 STARS NET
3B Scientific GmbH
3M Deutschland GmbH (NL Seefeld)
3M UNITED KINGDOM PUBLIC LIMITED COMPANY
3ZERO2 TV SPA
4iG [NAME]
50Hertz Transmission GmbH
A. Nattermann & Cie. Gesellschaft mit beschränkter Haftung
A. SCHULMAN INC. LIMITED
A.M.L.
A.N.A.C.I. ASSOCIAZIONE NAZIONALE AMMINISTRATORI CONDOMINIALI E IMMOBILIARI
[NAME]
[NAME] A/S
A.S.T.R.I.D.
A.Z. Sint-Lucas
[NAME]
AAG DEFENCE SERVICES LTD
[NAME] GmbH
AB Enzymes GmbH
AB MAURI ITALY SPA
ABACO UK HOLDCO LIMITED
ABANCA
Abanca Corporacion [NAME]
ABB Logistics Center Europe GmbH
Abbott B.V.
ABBOTT FRANCE
[NAME]
Abbott Medical GmbH
Abbott Rapid Diagnostics Jena GmbH
[NAME]
AbbVie Deutschland GmbH & Co. [NAME]
ABBVIE LTD
[NAME].
ABERTIS [NAME]
Abfallverwertungsgesellschaft des Landkreises Ludwigsburg mbH
abl social federation GmbH
Ablynx
ABN Amro Bank NV
Absa Technology Prague, s.r.o.
Abtei Mariendonk GmbH
[NAME]
Academisch [NAME]
ACCA-XXI, OOO
Accent Group
Accenture (UK) Limited
Accenture Services, s.r.o.
ACCESOS DE MADRID CONCESIONARIA ESPAÑOLA SA (EN LIQUIDACION)
ACCORHOTELS & COMMUNITY SERVICES SPAIN SL.
AccorInvest Germany GmbH
ACCOVIA FRANCE
[NAME]
ACLVB
ACPS Automotive Korlátolt Felelősségű Társaság
ACRI ST
Actie Universiteit Antwerpen
ACTIRIS
Active Radio a.s.
ACUITY KNOWLEDGE PARTNERS (UK) LIMITED
ACV-CSC
ad agencyservices GmbH
[NAME].
ADASE
ADECCO FRANCE
ADECCO IBERIA SAU
Adecco Service Center Solutions GmbH
Adecco Service Center Solutions GmbH
[NAME].S R.O.
ADECCO UK LIMITED
ADEPA Asset Management S.A.
[NAME]
ADIDAS (U.K.) LIMITED
ADIDAS ESPAÑA SAU
adidas International B.V.
ADIDAS ITALY SPA
ADIDAS POLAND SP Z O O
adidas Slovakia, s.r.o.
Aditinet Consulting SpA
ADMINISTRADOR DE INFRAESTRUCTURAS FERROVIARIAS
Administration communale
Administration Communale d'Ixelles
ADOBE SYSTEMS EUROPE LIMITED
ADQUIRA ESPAÑA SA
ADS SECURITIES LONDON LIMITED
Adserfa B.V.
Advanced Driver Information Technology GmbH
Advanced Micro Devices GmbH
Advanced Micro Devices Spa soggetta alla direzione e coordinamento di AMD Inc
ADVANTECH EUROPE B.V.
AEB SE
AEGON Magyarország Általános Biztosító Zártkörüen Működő Részvénytársaság
AENA DESARROLLO INTERNACIONAL S M E SA.
AERO GEARBOX INTERNATIONAL
AERO Vodochody AEROSPACE a.s.
Aerostack GmbH
AETN UK
AEW CILOGER