tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: rick_buy__32733__0813 summary of issues
Sheet: Summary0510

SUMMARY BY WEEK FOR  05/10 - 05/17
TOTAL ISSUES
Category |  | Description
A |  | Deal Capture
B |  | Deal Valuation
C |  | Breakdown in Officializing Process- Human |  |  |  |  |  |  |  | 7
D |  | Breakdown in Officializing Process- IT |  |  |  |  |  |  |  | 5
E |  | Curve Issues
F |  | Uncontrollable-System Needs to Change |  |  |  |  |  |  |  | 1
G |  | Miscellaneous
H |  | Not identified
Breakdown By Group |  |  |  |  |  |  |  | # of Issues |  | Biggest Problem
EIM |  |  |  |  |  |  |  | 1 |  | Not utilizing the Active/Inactive website to see if book was officialized.
EGM |  |  |  |  |  |  |  | 3 |  | Training.
EEL |  |  |  |  |  |  |  | 5 |  | Load time. New RisktRac use.
EA-CAN |  |  |  |  |  |  |  | 1 |  | Not utilizing the Active/Inactive website to see if book was officialized.
EA - GAS |  |  |  |  |  |  |  | 1 |  | Not utilizing the Active/Inactive website to see if the correct book was officialized and make sure those books with no positions are made inactive.
EA - POWER |  |  |  |  |  |  |  | 2 |  | Not utilizing the Active/Inactive website to see if book was officialized.
EES |  |  |  |  |  |  |  | — |  | —
EBS |  |  |  |  |  |  |  | — |  | —
TOTAL ISSUES
Spreadsheet: 144895d1331197965-copying-from-1-sheet-to-many-sheets-sales-records-sample
Sheet: GARRY TALL

SALES SETTLEMENTS & RECEIPTS RECONCILIATION
2012
GARRY TALL
Date | Invoice No | Client Name | Accounting Code | Model | Delivery Date | Qty | [NAME] | Ex-Stock / On Order | Amount | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | [NAME] |  | Balance |  |  |  |  | DELIVERED | DEPOSIT OF | CHECKING IF DEPOSIT IS EQUAL TO  60%
 |  |  |  |  |  |  |  |  |  | Receipt |  | Receipt |  | Receipt |  | Receipt |  | Receipt |  | Receipt |  | Receipt |  | Receipt |  |  |  |  |  |  | SALAH
 |  |  |  |  |  |  |  |  |  | Amount | No | Amount | No | Amount | No | Amount | No | Amount | No | Amount | No | Amount | No | Amount | No |  |  |  |  |  | ON:
 |  |  |  |  |  |  |  |  | € | € |  | € |  | € |  | € |  | € |  | € |  | € |  | € |  | €
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  | 0 | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0 |  | 0
Spreadsheet: 636604d1565375671-help-calendar-correction-employee-absence-schedule-current-6-5-19
Sheet: November

 | Employee Absence Schedule
 | Absence Type Key | V | Vacation |  |  | P | Pick Up Shift |  |  | S | Sick |  |  | Custom 1 |  |  |  | Custom 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Enter year:
 | November | Dates of Absence/Pick up |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2019
 | Employee Name | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 |  |  |  | Vacation Days Taken/Year | Vacation  Days Taken/Month | Days Picked Up/Month | Sick Days/Month
 | [NAME]
 | Lynda
 | [NAME]
 | Heather
 | [NAME]
 | Emili
 | Amber
 | Meredith
 | Julie
Spreadsheet: 779776d1652099032-sum-days-hours-and-minutes-to-show-total-minutes-phonestatistics
Sheet: Test per månad

Gruppering | Anonym siffra | Datum | Inloggad dygn.h:min:sek | Inloggad antal minuter | [NAME] dygn.h:min:sek | Tillgänglig antal minuter | [NAME] (%) | Pausad dygn.h:min:sek | Pausad antal minuter | Pausad VS Inloggad (%)
Telefon | 1 | Januari | 2.15:07:57 |  | 1.10:11:17 |  |  | 1.04:56:40
Telefon | 2 | Januari | 5.17:35:06 |  | 4.06:35:10 |  |  | 1.01:33:03
Mail | 4 | Januari | 0.00:17:05 |  | 0.00:00:00 |  |  | 0.00:17:05
Mail | 5 | Januari | 0.01:51:57 |  | 0.01:00:05 |  |  | 0.00:51:07
Mail | 5 | Januari | 0.06:39:50 |  | 0.04:39:13 |  |  | 0.02:00:37
Telefon | 6 | Januari | 6.02:47:10 |  | 3.05:01:07 |  |  | 2.21:46:03
Telefon | 10 | Januari | 6.10:30:32 |  | 2.20:28:17 |  |  | 3.14:02:15
Mail | 11 | Januari | 0.19:43:00 |  | 0.07:44:45 |  |  | 0.11:58:03
Telefon/admin | 12 | Januari | 5.20:03:18 |  | 2.22:20:39 |  |  | 2.21:42:39
Telefon | 1 | Februari | 5.09:39:40 |  | 2.20:35:13 |  |  | 2.13:04:27
Telefon | 2 | Februari | 5.05:35:34 |  | 4.02:22:05 |  |  | 1.03:13:29
Telefon | 3 | Februari | 5.20:23:38 |  | 4.20:21:35 |  |  | 1.00:02:03
Mail | 4 | Februari | 0.01:01:24 |  | 0.00:07:20 |  |  | 0.00:54:04
Mail | 5 | Februari | 0.01:08:37 |  | 0.00:27:03 |  |  | 0.00:41:34
Mail | 5 | Februari | 0.06:09:47 |  | 0.01:12:20 |  |  | 0.04:57:27
Telefon | 6 | Februari | 5.13:57:23 |  | 2.21:28:42 |  |  | 2.16:28:41
Telefon | 7 | Februari | 0.00:00:00 |  | 0.00:00:00 |  |  | 0.00:00:00
Telefon | 10 | Februari | 6.11:29:29 |  | 3.02:21:21 |  |  | 3.09:08:08
Mail | 11 | Februari | 0.23:17:16 |  | 0.09:14:08 |  |  | 0.14:03:08
Telefon/admin | 12 | Februari | 5.04:48:15 |  | 2.15:29:41 |  |  | 2.13:18:34
Spreadsheet: 27000d1219767420-display-number-of-occurances-from-unique-list-against-bulk-list-occurances
Sheet: Sheet1

 |  |  | Complete List |  | Unique List |  | No. Of Occurances
 |  |  | a |  | a |  | 3
 |  |  | b |  | b |  | 3
 |  |  | c |  | c |  | 2
 |  |  | d |  | d |  | 3
 |  |  | e |  | e |  | 3
 |  |  | f |  | f |  | 5
 |  |  | g |  | g |  | 5
 |  |  | h |  | h |  | 5
 |  |  | I |  | I |  | 5
 |  |  | a
 |  |  | b
 |  |  | c
 |  |  | d
 |  |  | e
 |  |  | f
 |  |  | g
 |  |  | h
 |  |  | I
 |  |  | f
 |  |  | g
 |  |  | h
 |  |  | I
 |  |  | a
 |  |  | b
 |  |  | f
 |  |  | g
 |  |  | h
 |  |  | I
 |  |  | d
 |  |  | e
 |  |  | f
 |  |  | g
 |  |  | h
 |  |  | I
Spreadsheet: 818206d1676647080-expected-outcome-based-on-2-criteria-copy-of-sample-workbook-3-1-
Sheet: Sheet1

CAAS | Account Name | GL Balance
[PHONE]-0224241-0000000-Canadian Dollar | DIRECT FINANCE LEASE RECEIVABLE-NONUS-IL | 70689528.37
[PHONE]-0224241-0000000-Canadian Dollar | UNEARNED FINANCE INCOME-DIRECT LEASE FIN-NONUS-IL | -4952720.45
[PHONE]-0023313-0000000-US Dollar | SECURITY DEPOSIT- IL | 23850
[PHONE]-0027353-0000000-US Dollar | SECURITY DEPOSIT- IL | 87606.3
[PHONE]-0240685-0000000-US Dollar | SECURITY DEPOSIT- IL | 92287.6
[PHONE]-0228034-0000000-Statistical | 30-89 DAYS PD-LOANS TO NONDEPOSITORY FINANCIAL INST-IL | 41010.68
[PHONE]-0240685-0000000-Statistical | 30-89 DAYS PD-LOANS OF STATE/POLITICAL SUBDIVISIONS-IL | 20519.89
[PHONE]-0224241-0000000-Statistical | 30-89 DAYS PD LOANS TO NON-US GOVERNMENTS-IL | 245.31
[PHONE]-0228029-0000000-Statistical | COMMERICAL LOAN UNDISBURSED COMMITMENTS-IL | 3358079
[PHONE]-0211738-0000000-Statistical | COMMERICAL LOAN UNDISBURSED COMMITMENTS-IL | 21620219.08
[PHONE]-0228020-0000000-Statistical | COMMERICAL LOAN UNDISBURSED COMMITMENTS-IL | 10064980.9
[PHONE]-0228021-0000000-Statistical | 30-89 DAYS PAST DUE-COMMERICAL LOANS-IL | 203303.79
[PHONE]-0228036-0000000-Statistical | 30-89 DAYS PAST DUE-COMMERICAL LOANS-IL | 58774.15
[PHONE]-0240695-0000000-Statistical | ASC 842-30-89 DPD-NONDEPOSITORY INSTITUTIONS-IL | 2134.88
 | Total
 |  | Manual Formulal | Automated Formula
Spreadsheet: 865964d1712907867-systematic-allocation-of-expense-sample-5-1-
Sheet: Sheet1

 |  |  |  |  |  |  | Q1. How I Know this A1 which pay is cover the Project 1, project 2 & project3
 |  |  |  |  |  |  | Solution required by formula
 | Name | Project1 | Project2 | Project3 | Total Salary |  | Project1 | Project2 | Project3
 | A1 | 13000 | 9008.718232988998 | 9008.718232988998 |  |  |  | Pay 3&4 | Pay 5&6
 | B1 | 0 | 0 | 0
 | A2 | 5000 | 7000 | 8000 |  |  |  | Pay 2&3 | Pay 4&5
 | A3 | 0 | 0 | 0
 | A4 | 3000 | 4000 | 5000 |  |  |  | Pay 2 | Pay 3&4
 | B2 | 2020.126928551948 | 12000 | 11003 |  |  |  | Pay 2&3&4 | Pay 5&6&7
 | B3 | 0 | 7865 | 6534 |  |  |  | Pay 1&2&3&4 | Pay 5&6&7
 | Name | Pay 1 | Pay 2 | Pay 3 | Pay 4 | Pay 5 | Pay 6 | Pay 7 | Total
 | A1 | 6000 | 7000 | 8000 | 4000 | 8000 | 8000 | 6000
 | B1 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | A2 | 5000 | 6000 | 6000 | 4000 | 6000 | 6000 | 3000
 | A3 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | A4 | 3000 | 4000 | 4074.44 | 4000 | 3000 | 3000 | 3000
 | B2 | 4000 | 4000 | 4000 | 4000 | 3000 | 3000 | 3000
 | B3 | 2000 | 2000 | 2000 | 4000 | 2000 | 2000 | 2000
Spreadsheet: 163378d1340287891-cell-contents-lookup-contentslookup
Sheet: Sheet1

Evaluate | Result |  |  |  | Lookup
[NAME] | Message |  |  |  | Message
Happy Letter | Letter |  |  |  | Letter
Letters of Emotion | Letter |  |  |  | Note
Message of Color | Message
Note to Self | Note
Personal Notes | Note
Red Message | Message
Sad Letter | Letter
Spreadsheet: 2c541b92-b8f4-4298-baae-8bca1fd1cab7
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5671.0 Lending Finance, Australia
 | TABLE 18. COMMERCIAL FINANCE COMMITMENTS, Revolving Credit By Industry: Australia, Original ($000)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Agriculture, forestry and fishing ; |  |  | Original | A2414246T | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
Mining ; |  |  | Original | A2414247V | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
Manufacturing ; |  |  | Original | A2414248W | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
Construction ; |  |  | Original | A2414249X | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
Wholesale trade ; |  |  | Original | A2414250J | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
Retail trade ; |  |  | Original | [NAME] | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
Transport and storage ; |  |  | Original | A2414252L | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
Finance and insurance ; |  |  | Original | [NAME] | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
Property and business services ; |  |  | Original | A2414254T | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
Cultural, recreational, personal and other services ; |  |  | Original | A2414255V | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
Public administration ; |  |  | Original | A2414256W | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
Health and community services ; |  |  | Original | A2414257X | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
Other industries ; |  |  | Original | A2414258A | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
TOTAL REVOLVING CREDIT ; |  |  | Original | A2414259C | 1985-01-01 00:00:00 | 2009-06-01 00:00:00 | 294 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2009
Spreadsheet: eric_saibi__9928__102901R
Sheet: Hope Creek 01

Owner Name |  | PSEG Power LLC
Station Name |  | Hope Creek Nuclear Power Station
Unit Name |  | Hope Creek 01
NERC Region |  | MAAC
State |  | NJ
Fuel Type |  | Nuclear
Capacity |  | 1170 MW
Start Date |  | 2001-10-10 00:00:00
End Date |  | 2001-11-02 00:00:00
Prv. Start Date |  | 2001-10-10 00:00:00
Prv. End Date |  | 2001-10-28 00:00:00
Comments |  | Refuel
SIC |  | 4931
Plant ID |  | 1012731
Unit ID |  | 1004437
Outage ID |  | 11864
Spreadsheet: 164384d1340741867-search-display-multiple-instances-of-unique-clients-and-related-cells-help-please-test-copy-timesheet
Sheet: Fee Statement

 |  |  |  |  |  | Fee Statement
 |  |  |  |  | Period: | 2012-06-01 00:00:00 | - | 2012-06-30 00:00:00
 |  |  |  |  | Client: | Great American Insurance Group
 |  |  |  |  | Contact:
 |  |  |  |  | Address:
 | Date | Matter | Activity | Description | Participants | Hours
Spreadsheet: darrell_schoolcraft__7804__imbalsumm0108
Sheet: PG&E

56698
Day | Measured | Scheduled
1 | -151076 | -150326
2 | -186416 | -184781
3 | -210011 | -208808
4 | -245094 | -241726
5 | -236194 | -235157
6 | -172231 | -181280
7 | -117605 | -116400
8 | -109940 | -109486
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
2001-07-31 00:00:00 |  |  | 24900
2001-08-08 00:00:00
CBS Dollars
 |  |  | -156083.38
Spreadsheet: 182234d1348377917-pivot-dates-not-sorting-september-2012-week-3
Sheet: Jun - 2012

Actual Production vs Production Capacity
Months | Jun
Row Labels | Sum of Quantity | Sum of Capacity | Sum of Percentage
10-Jun | 1444 | 20000 | 0.0722
11-Jun | 8582 | 20000 | 0.4291
12-Jun | 6574 | 20000 | 0.3287
13-Jun | 10020 | 20000 | 0.501
14-Jun | 15120 | 20000 | 0.756
18-Jun | 24604 | 20000 | 1.2302
19-Jun | 27526 | 20000 | 1.3763
20-Jun | 36472 | 20000 | 1.8236
21-Jun | 33720 | 20000 | 1.686
24-Jun | 36586 | 20000 | 1.8293
25-Jun | 30290 | 20000 | 1.5145
26-Jun | 26630 | 20000 | 1.3315
27-Jun | 24470 | 20000 | 1.2235
28-Jun | 27806 | 20000 | 1.3903
3-Jun | 10558 | 20000 | 0.5279
[NAME] | 22988 | 20000 | 1.1494
5-Jun | 21722 | 20000 | 1.0861
6-Jun | 20154 | 20000 | 1.0077
7-Jun | 14248 | 20000 | 0.7124
Grand Total | 399514 | 380000 | 1.051352631578947
Average per day:
Spreadsheet: 695036d1599989134-average-total-by-no-of-days-in-a-month-excluding-weekends-2020-09-13-oeldere2-ibrmoh-695030d1599983287-average-total-by-no-of-days-in-a-month-excluding
Sheet: Sheet1

Februari
 | SULAY
 | A/B |  |  |  |  | Holiday
 | QNTY
DATE | M³ | day | Holiday |  |  | Rijlabels | [NAME]
2020-02-01 00:00:00 | 569 |  |  |  |  | 1900-01-01 00:00:00 | 385
 | 429 |  |  |  |  | 1900-01-02 00:00:00 | 565.25
 | 530 |  |  |  |  | 1900-01-03 00:00:00 | 556
 | 654 |  |  |  |  | 1900-01-04 00:00:00 | 528.6666666666666
 | 586 |  |  |  |  | 1900-01-05 00:00:00 | 447.125
 | 447.5 |  |  |  |  | 1900-01-07 00:00:00 | 655.6
 | 382 |  |  |  |  | Eindtotaal | 528.2291666666666
 | 881
 | 431
 | 673
 | 528
 | 560
 | 507
 | 900
 | 709
 | 427
 | 479
 | 578
 | 517
 | 383
 | 244
 | 551
 | 253
 | 579
 | 464
 | 483
 | 451
 | 319
 | 568
 | 0
 | 0
Total
Average
Spreadsheet: 583301d1532362065-data-across-mutiple-workbooks-help-sample-workbook
Sheet: Master

Manuf: Item Id Name Inv UOM | Production Id | Cost Grouping | Cost Group Id | Resource Department | Resource | Total Variance | Qty And Sub Variance | Cost Variance | Lot Size Variance | Actual Qty | [NAME] | Actual Quantity | Standard Qty By RAF Qty | Standard Cost By RAF Qty | Actual Cost
1 | 97L0005198 001 | Standard | LAB SETUP | 1650L | 97L01 | -6.114237 | -128.4 | 0 | 122.285763 | 3600 | 12600 | 2 | 2.285714 | 48.914285 | 42.8
 |  |  | LAB RUN | 1650L | 97L01 | -169.393638 | -169.411278 | 0.01764 | 0 | 3600 | 12600 | 24.81083333333333 | 32.72724 | 700.363636 | 530.97
 |  | Standard Total |  |  |  | -175.507875 | -297.811278 | 0.01764 | 122.285763 | 3600 | 12600 | 26.81083333333333 | 35.012954 | 749.277921 | 573.77
 | 97L0005198 001 Total |  |  |  |  | -175.507875 | -297.811278 | 0.01764 | 122.285763 | 3600 | 12600 | 26.81083333333333 | 35.012954 | 749.277921 | 573.77
2 |  |  |  |  |  | -175.507875 | -297.811278 | 0.01764 | 122.285763 | 3600 | 12600 | 26.81083333333333 | 35.012954 | 749.277921 | 573.77
3 | 97L0005430 001 | Standard | LAB SETUP | 1650L | 97L01 | 78.262882 | -42.8 | 0 | 121.062882 | 1230 | 4200 | 6 | 2.342857 | 50.137142 | 128.4
 |  |  | LAB RUN | 1650L | 97L01 | 161.787273 | 161.780655 | 0.006618000000000001 | 0 | 1230 | 4200 | 41.10527777777778 | 33.545436 | 717.8727269999999 | 879.6600000000001
 |  | Standard Total |  |  |  | 240.050155 | 118.980655 | 0.006618000000000001 | 121.062882 | 1230 | 4200 | 47.10527777777778 | 35.888293 | 768.009869 | 1008.06
 | 97L0005430 001 Total |  |  |  |  | 240.050155 | 118.980655 | 0.006618000000000001 | 121.062882 | 1230 | 4200 | 47.10527777777778 | 35.888293 | 768.009869 | 1008.06
 |  |  | LAB RUN | 1650L | 97L01 | 21.4 | 21.4 | 0 | 0 | 150 | 4500 | 1 | 0 | 0 | 21.4
 |  |  | LAB RUN | N/A | 97L01 | -51.442308 | -51.442308 | 0 | 0 | 150 | 4500 | 0 | 2.403822 | 51.442308 | 0
 |  | Standard Total |  |  |  | -17.202222 | -265.442308 | 0 | 248.240086 | 150 | 4500 | 2 | 2.803822 | 60.002308 | 42.8
 | 97M0003065 Total |  |  |  |  | -17.202222 | -265.442308 | 0 | 248.240086 | 150 | 4500 | 2 | 2.803822 | 60.002308 | 42.8
4 |  |  |  |  |  | -17.202222 | -265.442308 | 0 | 248.240086 | 150 | 4500 | 2 | 2.803822 | 60.002308 | 42.8
5 | 97L0005546 001 | Standard | LAB SETUP | 1650L | 97L01 | 256.799486 | 0 | 0 | 256.799486 | 0.03 | 15000 | 12 | 2.4e-05 | 0.000513 | 256.8
 |  |  | LAB RUN | 1650L | 97L01 | 101.949814 | 101.708812 | 0.241002 | 0 | 0.03 | 15000 | 4.763915343903703 | 0.000116 | 0.002476 | 101.9533333333333
 |  |  | LAB RUN | N/A | 97L01 | 50.974907 | 50.854406 | 0.120501 | 0 | 0.03 | 15000 | 2.381957671951851 | 5.8e-05 | 0.001238 | 50.97666666666667
 |  | Standard Total |  |  |  | 409.724207 | 152.563218 | 0.361503 | 256.799486 | 0.03 | 15000 | 19.14587301585555 | 0.000198 | 0.004227 | 409.73
Spreadsheet: 812146d1672996025-extract-data-example-of-data-2-
Sheet: Extracted Product List

Product Name | Unit Cost | [NAME] | [NAME] | Revenue
 |  | 56 | In-Store | 1524
Computer |  | 11 | Online | 10526
Tablet |  | 4 | Online | 952
Camera |  | 15 | Instore | 23
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
0
Spreadsheet: 53953d1253876058-calculating-an-average-but-excluding-boxes-with-text-how-to-calculate-average-time-spent-on-app
Sheet: Sheet1

 | Officers
 | Sue | SW | KG | BMT | LR | PG | JF | DT | TU | JG | NC
Day 1 | 10 | 11 | 9 | 9 | DSR | BO | BO | 2 |  |  |  | 41
Day 2 | 5 | 4 | ? |  | 1 | 11 | 3 | 7 |  |  |  | 31
Day 3 | AL | 6 | 12 | 9 | 1 | 6 | 2 | 5 |  |  |  | 41
Day 4 | AL | 4 | 10 | 9 | 1 | AL | 4 | 10 |  |  |  | 38
Day 5 | AL | 4 | 7 | 9 | 3 | AL | 5 | 8 |  |  |  | 36
 | 15 | 29 | 38 | 36 | 6 | 17 | 14 | 32 | 0 | 0 | 0 | 187
Average Time
 | Each day officers have 360 mins of time to do appointments, (i.e. 6 hours), and I want to know how many mins they are spending per appointment, i.e. with someone.
 | To do this I have to have a box with the average time at the bottom of each column. I first tried this by doing 1800 mins, divided by the total seen (row ten above).
 | However, this doesn't take into account days where an officer wasn't at work, because of annual leave, or suchlike. It also doesn't take into account days where somoene has done a half day.
 | Is there a way of getting excel to do a calculation in the average time boxes of each column, e.g. sending a result into B11, C11, D11, E11 and so on, which assumes a full day is 360 minutes, and multiplies
 | 360 by the number of boxes above (e.g. B5, B6, [NAME], B8, B9) but excludes those boxes containing text, or text and a number - so we can keep a record of how many people someone has seen on a half day,
 | but exclude it from the calculation so it doesn't skew the result (obviously half a day is 180 minutes so would provide an inaccurate result).
Spreadsheet: 924b5869-9245-41d0-9bca-29bd0711f7ec
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
1 |  |  |  | BEGINNER/SPORT WOMEN
16 |  |  |  | SEA OTTER CLASSIC - DUAL SLALOM   APRIL 7, 2006
 |  |  | 147  SONDRA WILLIAMSON
9
8
5
12
 |  |  | BYE
13
4
3
 |  |  |  | 2nd Place | Champion
14
 |  |  | 290  STEPHANIE WILLIAMS
11
6
7
10
 |  |  | 277 DENISE TAYLOR
15 |  |  |  | Consolation Round
2
 |  |  |  |  | 3rd Place
 |  |  |  |  | 4th Place
Spreadsheet: 756774d1637768875-add-a-period-to-cell-if-a-value-if-not-leave-blank-aew-letter-copy
Sheet: Sheet1

SSN | 123456789 |  |  |  |  | Open AEW
Address | [NAME] Lane NE Jenny, MN 12345
Date |  |  |  |  |  | Download AEW/FY2021
Date
Award |  |  |  |  |  | [NAME]
AEW Date (Use DOC)
POA |  |  |  |  |  | 21-22, 214
Type
Contention |  |  |  |  |  | Letter Data
Letter Name
VBMS-A Remarks |  |  |  |  |  | Do Calculator
Letter Dates
Letter Dates |  |  |  |  |  | Do Letter
Calculator Name |  |  |  | AEW Dated
Letter [NAME] |  |  |  | Grant, BEST PCLTRS |  | Save Letter/FY2021/PCLTR/Break
Second AEW
Contention |  |  |  |  |  | Print Calculator/FY2021
VBMS-A Remarks
 |  |  |  |  |  | Upload Calculator
 |  |  |  |  |  | Save Letter Creator/FY2021
 |  |  |  |  |  | CEST Claim
 |  |  |  |  |  | VBMS-A
Spreadsheet: 789321d1659036523-count-instances-of-x-in-multiple-cells-not-in-a-range-per-diem-tracker-example-bsb-
Sheet: Sheet1

Driver Per-diem & Container - Week Ending 7-29-2022
Driver | Saturday |  |  | Sunday |  |  | Monday |  |  | Tuesday |  |  | Wednesday |  |  | Thursday |  |  | Friday |  |  | Total |  |  | Payout
 | PD | CD | CS | PD | CD | CS | PD | CD | CS | PD | CD | CS | PD | CD | CS | PD | CD | CS | PD | CD | CS | PD | CD | CS
Driver A |  |  |  |  |  |  | X |  |  | X |  |  | X |  |  | X |  |  | X
Driver B |  |  |  |  |  |  | X |  |  | X |  |  | X |  |  | X
Driver A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X
Driver B |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | X
Driver A |  |  |  |  |  |  |  |  |  |  |  |  | X |  |  |  |  |  | X
Driver B |  |  |  | X |  |  |  |  |  |  |  |  | X
Driver A |  |  |  |  |  |  | X |  |  | X |  |  | X |  |  | X
Driver B | X |  |  | X |  |  | X |  |  | X |  |  | X |  |  | X |  |  | X
Driver A |  |  |  |  |  |  |  |  |  |  |  |  | X |  |  | X
Driver B |  |  |  |  |  |  |  |  |  | X
Driver A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TOTALS
Spreadsheet: 196325d1353956302-multi-cell-for-drop-down-list-more-than-one-column-2-cells-drop-down-list
Sheet: Sheet1

1 | [NAME]
3 | Bad
8 | Good
7 | Above Average
NA | Not applicable
10 | The Best
8 | Good
ND | Not Discussed
5 | Poor
9 | Better
10 | The Best
7 | Above Average
9 | Better
77
Spreadsheet: 786682d1657367004-payslip-presentation-with-itemized-results-excelforum-payslip
Sheet: Joseph

PAYSLIP ADVICE
Employer Name |  | Pay Month | [NAME] | Tax Period | Employer's  Address
Employee Number |  | Employee Surname | First Names | Job Title | Pay date
 |  | [NAME] | [NAME] | Producer
Graded Tax Number |  | Identity number | Date of birth | Age | Mobile Number
2160 01-003874332 |  | [PHONE] |  |  | 76353617
Pay Rate |  | Start Tax Period | End Tax Period | No. of [NAME] | Sex
 |  |  |  |  | Male
Description | Unit Price | Quantity | Value | Deductions | Value
 |  |  |  | PAYE | 0
 |  |  |  | Graded Tax | 0
 |  |  |  | ENPF | 0
Total Earnings |  |  |  | Total Deductions
 |  |  |  | Net Pay
Spreadsheet: 145878d1331794236-transfer-data-from-one-sheet-to-another-when-specific-value-entered-in-first-sheet-example_2012_file-1-
Sheet: Mar

Reporter | Date Rec. | Date Comp. | Witness | Description | Pages Rec | Pages Rtn | Job Type | Rate | Total | Tithe Amount | Tithed | Invoice # | Invoice Date | Date Paid | Monthly Tithe | Tithed MTD | Left to Tithe | Total | Amount Received | Total By Reporter | Amount Due | Amount Received
[NAME] | 2012-03-01 00:00:00 | 2012-03-06 00:00:00 |  |  | 109 | 114 | Regular | 0.85 |  |  |  | 007-15 | 2012-03-06 00:00:00 | X |  |  |  |  |  | Jeanne
Jeanne | 2012-03-01 00:00:00 | 2012-03-06 00:00:00 |  |  | 36 | 48 | Regular | 1.2 |  |  |  | 001-14 | 2012-03-06 00:00:00 | X |  |  |  |  |  | [NAME]
Jeanne | 2012-03-06 00:00:00 |  |  |  | 43 | 52 | Regular | 1.2 |  |  |  | 001-15 |  |  |  |  |  |  |  | Karisa
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]