tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 818354d1676757522-excel-formula-for-dublicate-dublicate
Sheet: Sheet1

I'm kindly asking for excel formula to identify duplicate billings of invoices within the sales file where the same customer, invoice, and amount are the same as in column G
Date | Entry Type | Invoice | Customer Name | Credit | Cumulative | Duplicate Y/N
1000/001 : Sales-Byo
Opening Balance as at 01/01/2021 |  |  |  |  | 2163865.07
09/01/2021 | Sales | 40001199 | [NAME] | 12414.85 | -2176279.92 | N
15/01/2021 | Sales | 40001200 | [NAME] school | 74185.15 | -2250465.07 | N
15/01/2021 | Sales | 40001201 | [NAME] school | 5973.8 | -2256438.87 | N
20/01/2021 | Sales | 40001202 | tyf | 1065.92 | -2257504.79 | N
25/01/2021 | CB 5 Payments | 40001200 | [NAME] school | 74185.15 | -2257024.79 | Y
27/01/2021 | Sales | 40001204 | [NAME] | 3292.58 | -2260317.37 | N
28/01/2021 | Sales | 40001205 | ABC | 1414.85 | -2261732.22 | N
29/01/2021 | Sales | 40001207 | ABC | 39.3 | -2261771.52 | N
29/01/2021 | Sales | 40001208 | [NAME] | 5423.58 | -2267195.1 | N
29/01/2021 | Sales | 40101666 | cash sale | 29743.2 | -2296938.3 | N
05/02/2021 | Sales | 40001203 | bicc treasurer's office | 855.9 | -2297794.2 | N
05/02/2021 | Sales | 40001209 | plumtree hospital | 5658.95 | -2303453.15 | N
12/02/2021 | Sales | 40001208 | [NAME] | 5423.58 | -2305400.49 | Y
24/02/2021 | Sales | 40001211 | lupane local board | 10087.34 | -2315487.83 | N
24/02/2021 | Sales | 40001200 | [NAME] school | 74185.15 | -2339068.62 | Y
Date | Entry Type | Invoice | Customer Name | Credit | Cumulative | Count
1000/001 : Sales-Byo |  |  |  |  |  | 2
Opening Balance as at 01/01/2021 |  |  |  |  | 2163865.07 | 2
09/01/2021 | Sales | 40001199 | [NAME] | 12414.85 | -2176279.92 | 1
15/01/2021 | Sales | 40001200 | [NAME] school | 74185.15 | -2250465.07 | 3
15/01/2021 | Sales | 40001201 | [NAME] school | 5973.8 | -2256438.87 | 1
20/01/2021 | Sales | 40001202 | tyf | 1065.92 | -2257504.79 | 1
25/01/2021 | CB 5 Payments | 40001200 | [NAME] school | 74185.15 | -2257024.79 | 3
27/01/2021 | Sales | 40001204 | [NAME] | 3292.58 | -2260317.37 | 1
28/01/2021 | Sales | 40001205 | ABC | 1414.85 | -2261732.22 | 1
29/01/2021 | Sales | 40001207 | ABC | 39.3 | -2261771.52 | 1
29/01/2021 | Sales | 40001208 | [NAME] | 5423.58 | -2267195.1 | 2
29/01/2021 | Sales | 40101666 | cash sale | 29743.2 | -2296938.3 | 1
05/02/2021 | Sales | 40001203 | bicc treasurer's office | 855.9 | -2297794.2 | 1
05/02/2021 | Sales | 40001209 | plumtree hospital | 5658.95 | -2303453.15 | 1
12/02/2021 | Sales | 40001208 | [NAME] | 5423.58 | -2305400.49 | 2
24/02/2021 | Sales | 40001211 | lupane local board | 10087.34 | -2315487.83 | 1
24/02/2021 | Sales | 40001200 | [NAME] school | 74185.15 | -2339068.62 | 3
Spreadsheet: 700464d1603201217-meeting-actions-tracker-action-tracker
Sheet: Actions Tracker

Outstanding Actions
Minute Item | Comments & Action |  | Action By | Action Date | Closed Out | Action Taken
1.2 | Action here need to b ecompleted by Action date |  |  | 2020-10-20 00:00:00 | û
1.3 | Action here need to b ecompleted by Action date |  |  | 2020-10-20 00:00:00 | û
1.2 | Action here need to b ecompleted by Action date |  |  | 2020-10-20 00:00:00 | û
1.3 | Action here need to b ecompleted by Action date |  |  | 2020-10-20 00:00:00 | û
Spreadsheet: 678471d1589906905-update-column-in-shee1-based-on-sheet2-lookup-data-booktempef
Sheet: Sheet1

++ DATA IN SHEET #1 ++ |  |  | ++ DATA IN SHEET #2 ++
Link Value | Name |  | Link Value | Name
10 | ? |  | 10 | Aname
10 | ? |  | 20 | Bname
20 | ? |  | 30 | Cnamed
20 | ?
20 | ?
30 | ?
30 | ?
30 | ?
30 | ?
Spreadsheet: 705794d1606311219-count-same-characters-in-a-string-same-pairs
Sheet: Φύλλο1

 |  |  | A | A | B | C | D | D | D | D | D | E | E | F | G | H |  |  | 1
 | example 1 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | It  finds 3
 |  |  | 1 |  |  |  | 2 |  |  |  |  | 3
 | example 2 |  | A | B | C | D | E | E | E | F | F | G | H | I | I | I | It finds 3
 |  |  |  |  |  |  | 1 |  |  | 2 |  |  |  | 3
 |  |  | I need to count the same elements .We start counting when we have >= of 2 os each element.
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 |  |  | A | B | C | D | E | F | G | H | I | J | K | D | M | N | A
 |  |  |  |  |  |  |  |  |  | 8
Because the columns with data are odds(15) the number 8 leaves out o matcing couples
If we have odds number of columns we are leaving the middle element of that range out of counting couples
 |  |  | A | B | C | D | E | F | G |  | I | J | K | D | M | D | A | 2 matches
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  |  |  |  | 1
Now we have EVEN number of columns(8) |  |  |  |  |  |  | 3
 |  |  | A | B | C | D | D | C | D | A |  | 3 matces
 |  |  |  |  |  |  |  | 2
 |  |  |  |  |  |  | 1
Spreadsheet: 686057d1594333124-retrieve-data-from-another-sheet-based-on-date-examplevlookup
Sheet: Sheet1

 | Surname | Caught | River | Beat | Pool | Species | [NAME] | Oz | Method | Day/Night | Fly/Lure | Returned | Comments | min_level | avg_level | max_level
[NAME] |  | 2019-10-16 00:00:00 | [NAME] | [NAME] | Railway Pool | Salmon | 9 | 0 | Spinner | Day | Flying C | Yes | Hen, slightly coloured
[NAME] |  | 2019-10-15 00:00:00 | [NAME] | Junction Beat | [NAME] | Salmon | 4 | 0 | Fly | Day | Red Flying C | Yes | None
[NAME] |  | 2019-10-14 00:00:00 | Elwy | [NAME] 3 | Other | Seatrout | 3 | 0 | Fly | Day | None | Yes | Below rock pool
[NAME] |  | 2019-10-14 00:00:00 | Elwy | [NAME] 3 | Other | Seatrout | 1 | 8 | Fly | Day | None | Yes | None
[NAME] |  | 2019-10-14 00:00:00 | Elwy | [NAME] 3 | Other | Seatrout | 1 | 8 | Fly | Day | None | Yes | All clean fish
Jonathon |  | 2019-10-13 00:00:00 | Elwy | [NAME] 3 | Rock Pool | Salmon | 5 | 0 | Fly | Day | Red bodied cascade | Yes | Red cock fish
Jonathon |  | 2019-10-13 00:00:00 | Elwy | [NAME] 3 | Other | Salmon | 5 | 0 | Fly | Day | Red bodied cascade | Yes | Coloured hen fish from farm pool
Arwyn |  | 2019-10-13 00:00:00 | [NAME] | [NAME] | Signal Pool | Seatrout | 2 | 0 | Spinner | Day | None | Yes | None
Arwyn |  | 2019-10-13 00:00:00 | [NAME] | [NAME] | [NAME] | Salmon | 2 | 0 | Spinner | Day | None | Yes | None
[NAME] |  | 2019-10-12 00:00:00 | Elwy | [NAME] 3 | Rock Pool | Seatrout | 2 | 0 | Fly | Day | [NAME] | Yes | 0.78, coloured
Jonathon |  | 2019-10-12 00:00:00 | [NAME] | [NAME] | Signal Pool | Salmon | 4 | 0 | Spinner | Day | [NAME] | Yes | None
[NAME] |  | 2019-10-10 00:00:00 | [NAME] | [NAME] | Wood Pool | Seatrout | 1 | 0 | Fly | Day | Snaelda varient | Yes | None
[NAME] |  | 2019-10-10 00:00:00 | [NAME] | [NAME] | Wood Pool | Seatrout | 1 | 0 | Fly | Day | Snaelda varient | Yes | None
[NAME] |  | 2019-10-09 00:00:00 | [NAME] | Junction Beat | [NAME] | Salmon | 5 | 0 | Spinner | Day | Flying C | Yes | Coloured cock fish,Lost another similar size,few fish showing too
[NAME] |  | 2019-10-09 00:00:00 | Elwy | [NAME] | Footbridge | Seatrout | 0 | 12 | Fly | Day | None | Yes | None
 |  |  |  | Catches
Spreadsheet: 857550d1706549431-if-and-right-formula-example-file
Sheet: Sheet1

Pay Group | Worked Department | Location | Pay Level
LA3 | 170734 - LAX Taxi/TNC - Hourly Billing (R08) | 100122
LA3 | 170728 - Beverly Hilton - Fees | 100122
LA3 | 170895 - Century Plaza - Fairmont Hotel (R11) | 100122
@9T | 100122 - Data Entry | 100122
@9T | 100122 - Enforcement | 100122
CTO | 100122 - Enforcement | 100122
PA9 | 100122 - Enforcement | 100122
SOW | 140455 - Del Mar Plaza | 100122
SOW | 140112 - 714 E. San Ysidro Blvd (RSD)
Spreadsheet: 842261d1694406324-trying-to-reference-same-cell-from-different-sheets-using-indirect-function-indirect-issue
Sheet: Sheet1

 | index match indirect formula |  |  |  |  | formula
 | Total Rents
 |  | 2023-08-31 00:00:00
Clarence | Cash Flow
Biddulph | Cash Flow
5240 | Cash Flow
 | Regular | 2023-08-31 00:00:00
 | 1
 | 2
 | 3
Spreadsheet: chris_germany__1807__storage
Sheet: Sheet1

 | 2000-11-01 00:00:00 | Buy |  |  | Sell |  |  | Comment
 |  | New Pwer Exchange | 6050000 |  | CPR Storage | 6050000 |  | Book the beginning balance
 | 1st - 30th | CPR Storage | 907500 |  | Transport to Citygate | 907500 |  | The way ENA normally recognizes storage deals
 | 1st - 30th | New Pwer Purchase | 907500 |  | New Pwer Exchange | 907500 |  | This ticket will fluctuate daily with the Choice
 |  |  |  |  |  |  |  | customer load.  These volumes will match
 |  |  |  |  |  |  |  | the CPR Storage volume each month.
 |  |  |  |  |  |  |  | New Power will not see the Exchange deals
 | 2000-12-01 00:00:00
 | 1st - 31st | CPR Storage | 1500000 |  | Transport to Citygate | 1500000 |  | Same process through March
 | 1st - 31st | New Pwer Purchase | 1500000 |  | New Pwer Exchange | 1500000 |  | Same process through March
 | When we book the beg balance, we would enter all these deals as estimates through March.
 | On March 31st, the New Pwer Exchange sells should tie to the Nov 1st New Pwer Exchange buy.
 | At the end of each month, we will adjust the Exchange sells so that in total, the sells match the Exchange buy.
Spreadsheet: 835669d1688715375-separating-auto-updated-data-into-categories-on-other-table-daf-uneven-wrapcols-aligw
Sheet: Sheet1 (2)

 | Team Name | Location |  |  | Team A | Team B | Team C | Team D | Team E
 | Team A | London |  |  | London | Singapore | Jakarta | Moscow | Moscow
 |  | Cairo |  |  | Cairo | Quebec | Lima | Paris | Paris
 |  | Tokyo |  |  | Tokyo | Lima |  | Dubai | Dubai
 |  | Moscow |  |  | Moscow | Dubai |  | Tokyo
 |  | Singapore |  |  | Singapore
 | Team B | Singapore
 |  | Quebec
 |  | Lima
 |  | Dubai
 | Team C | Jakarta
 |  | Lima
 | Team D | Moscow
 |  | Paris
 |  | Dubai
 |  | Tokyo
 | Team E | Moscow
 |  | Paris
 |  | Dubai
Spreadsheet: 718853d1613394429-how-do-i-use-if-with-match-to-fill-a-cell-automatically-sampledata-gk
Sheet: TrainingStat

Name | [NAME] | Face2Face Complete Date | GMP Complete LookUp | Last Course Complete Date LookUp(Any Course)
[NAME] | Complete | 2021-01-04 00:00:00
[NAME] | Complete | 2021-01-08 00:00:00
[NAME] | Incomplete
[NAME] | Complete | 2021-01-10 00:00:00
[NAME] | Not Enrolled
Spreadsheet: 850937d1701246120-how-to-apply-a-multiplicator-coefficient-in-a-pivot-table-pivot-multiplator
Sheet: Sheet1

Name | Gender | Salary
Adam | Male | 50000
Betty | Female | 53000 |  |  | Row Labels | Sum of Salary | Sum of Salary +10%
[NAME] | Male | 45000 |  |  | Female | 156000 | 171600
Danielle | Female | 49000 |  |  | Male | 188000 | 206800
[NAME] | Female | 54000 |  |  | Grand Total | 344000 | 378400.0000000001
Gustave | Male | 65000
[NAME] | Male | 28000
Spreadsheet: 39902d1238149607-vlookup-query-index-match-amended-pricing-sheet
Sheet: Front Sheet

JOB CONTROL SHEET
PROJECT TITLE: |  |  | CLOSING DATE:
CONSULT/CLIENT: |  |  | CONST. PERIOD:
Quote Number: | Q
MATERIALS | (C/F from Pricing Sheet) |  |  |  | 157.77
GENERAL MATERIALS
CABLES
LIGHT FITTINGS | (C/F from Light fitting sheet) |  |  |  | 0
SWITCHGEAR
SUB TOTAL: |  |  |  |  | 157.77
FREIGHT
FIXED PRICE ALLOWANCE MATERIAL
MATERIAL TOTAL: |  |  |  |  | 157.77
LABOUR (Hour working week) [NAME]
A/  Tradesman | 0.55 | Hours @ |  | P/hour = | 0
[NAME] assistant | 0.55 | Hours @ |  | P/hour = | 0
C/ |  |  | Total A+B: | 0
D/  Allow for Stat O/H at: |  | 32 | % of C |  | 0
E/  Site Allowance: | 0.55 | Hours @ |  | P/hour = | 0
F/  Travel Allowance: |  | weeks @ |  | Per week | 0
G/  Boot & Tool: |  | weeks @ | 0 | Per week | 0
H/ Other:
I/  Total Allowances: | 0 | Stats |  | % | 0
J/  Accomodation: |  | weeks @ | 0 | per week | 0
K/  Airfares, Excess & Travel: |  | trips @ | 0 | per trip | 0
L/  Direct Labour:
M/  Staff supervision (as over sheet 2 A): |  |  |  |  | 0
N/   Allow for Stat O/H @ |  |  | % of | 0 | 0
O/  Total Supervision:
 |  |  | Labour total: | 0
PLANT & VEHICLES (As over): | C/F from sheet 2 B) |  |  |  | 0
TOTAL COST OF PRODUCTION: |  |  |  |  | 157.77
Plus: |  |  | Percent of production = |  | 0
SUB CONTRACTORS P.C./CONT./P.S. AMOUNTS: (C/F from pricing sheet) |  |  |  |  | 0
Plus: |  |  | Percent of PC amounts = |  | 0
SALES TAX
TOTAL SELLING PRICE: |  |  |  |  | 157.77
FINAL PRICE APPROVED:
Spreadsheet: 0a1ffcb4-9147-43d9-bcf9-c99e5830021e
Sheet: Sheet1

HEAVENLY GROUP ORDER FORM | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4
2012-2013
Jan.4th-Jan.17th; Jan.22nd-Feb.14th; Feb.25th-Close
Start Date of Skiing:                         End Date: | Address:
Group Name: | Telephone #:
Group Leader: | [NAME]:
Lift tickets - All Day |  | Quantity | Group Rate | Total
Child (ages 5-12) |  |  | 37 | 0
Child 2-day |  |  | 64 | 0
Teen (ages 13-18) |  |  | 57 | 0
Teen 2-day |  |  | 104 | 0
College (Full time enrollment) |  |  | 60 | 0
College 2-day |  |  | 110 | 0
Adult (ages 19-64) |  |  | 75 | 0
[NAME] |  |  | 146 | 0
Senior (ages 65+) |  |  | 57 | 0
Senior 2-day |  |  | 104 | 0
# of Comps (every 26th ticket) |  |  | 0 | 0
Rental Equipment  - Skis, Board, Boots, Poles | # of Days | Quantity | Group Rate | Total
Sport Ski Package |  |  | 34 | 0
Performance Ski Package |  |  | 38 | 0
Demo Ski Package |  |  | 41 | 0
Sport Board Package |  |  | 34 | 0
Demo Board Package* |  |  | 41 | 0
Kids Ski Package (ages 5-12) |  |  | 21 | 0
Kids Board Package (ages 5-12) |  |  | 21 | 0
Group Lessons Packages, Ages 14+:  Packages Include all day lift ticket, all day [NAME], and 2 1/2 hr lesson | # of Days | Quantity | Group Rate | Total
Learn to Ski/Ride Package: Limited lift access (levels 1-3) |  |  | 125 | 0
Learn to Ski/Ride - no equipment, limited lift access |  |  | 99 | 0
[NAME] Only |  |  | 86 | 0
Adventure Session Package (levels 4-8) |  |  | 141 | 0
Group Gondola Ticket |  |  | 32 | 0
$18.00 Lunch Voucher |  |  | 15 | 0
 |  |  | Grand Total | 0
Terms & Conditions (PLEASE READ CAREFULLY):
• EACH RENTER must provide a credit card to the rental shop for security purposes.
• Please allow 48 hours for order processing.  Full payment is due at time of order.
• Lift tickets may be picked up at Guest Services, sent Fedex, or delivered to local lodging properties
• Refunds paid to group leader only, upon return of unused lift tickets/vouchers to Heavenly Resort Sales, as long as group stays above 20 people, and within one week of start date.
* Demo Board only available at the BoardingHouse
3rd Trip Special: Offering $39 Adult/Teen lift tickets on your third trip (non-consecutive, not available on Sat.)
Looking to take your skills to the next level?                                                                     Take advantage of non Holiday rates at Ski School!! | Have a group member that does not ski or snowboard? No Problem! Heavenly offers all sorts of activities, ask for more details!
Send orders, payments, and questions to [NAME] at [EMAIL] or call at (775) 586-4466
Spreadsheet: 0e7ce6ab-e5d2-4b10-8ef1-6b3562ae904a
Sheet: KCDL

KCDL Online
2009-2010
COUNTER-Compliant? | No
 | 2009-07-01 00:00:00 | 2009-08-01 00:00:00 | 2009-09-01 00:00:00 | 2009-10-01 00:00:00 | 2009-11-01 00:00:00 | 2009-12-01 00:00:00 | 2010-01-01 00:00:00 | 2010-02-01 00:00:00 | 2010-03-01 00:00:00 | 2010-04-01 00:00:00 | 2010-05-01 00:00:00 | 2010-06-01 00:00:00 | Total | 2009-2010 Price | Price per unit
KCDL Online
Searches | 2 | 1 | 2 | 52 | 20 | 5 | 3 | 26 | 9 | 7 | 1 | 2 |  | 1850
Web Pages Delivered | 3 | 5 | 9 | 117 | 55 | 14 | 12 | 95 | 27 | 25 | 3 | 5
COUNTER com
Spreadsheet: 610a87c7-097a-4f3b-b056-3d912e00708b
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1
P. nodorum scaffold | M. graminicola v1 scaffolds predicted to be joined
1 | 1 5 13 31 97
2 | 1 2 12
3 | 2 3 97
4 | 3 4 22
5 | 10 90 126 137
6 | 1 5 7 17
7 | 9
8 | 1 12
9 | 1 3 5 33
10 | 1 8
11 | 1 5 7
12 | 2 3
13 | 1 8
14 | 6
15 | 1 3 4
16 | 1 2
17 | 1 2 97
18 | 6 31 243
19 | 1 5
20 | 1 5 97
21 | 11 97
22 | 1 5
23 | 5 7 17 41
24 | 3 1
25 | 5
26 | 2 12
27 | 5 7 17
28 | 3
29 | 8
30 | 1 5 97
31 | 3
32 | 11
33 | 1 5
34 | 3 4
35 | 1 8
36 | 1
37 | 6
38 | 6
39 | 1
40 | 11
41 | 4 97
42 | 2 12
43 | 1 2 4
47 | 3
48 | 6
49 | 8
50 | 1
66 | 10 14 80 84 93 94 98 105 115 121 126 130 134 140 159 171 244 325 344 347 378
89 | 10 14 84 94 98 105 115 121 130 134 140 171 325 344 347 378
97 | 14 90 126 137
Spreadsheet: 788786d1658735367-check-if-a-list-of-barcodes-would-form-cluster-groups-inside-of-another-barcode-list-excel-forum-25-july
Sheet: Sheet1

Barcodes | Example of clutser created is yellow shade between two columns  but how  to perform this with an equation | Barcodes
96141-08 |  | 95879-07-01/ Q90
11479-20 |  | 95748-07-04/ N129
95990-04-18/ X141 |  | 95987-07-01/ T124
95807-05-167/ T33 |  | 95030-04-01/ Q39
95984-07-27/ Y511 |  | 95025-07-04/ A48
95906-03-160/ Y524 |  | 95687-05-01/ A116
95906-03-158/ Y331 |  | 95575-03-69/ D33
95906-03-01/ Y344 |  | 95807-03-167/ T31
95907-03-01/ T99 |  | 94130-04-01/ K187
93325-05-07/ C21 |  | 94976-07-03/ N60
95691-03-101/ V41 |  | 94976-06-03 \ N59
95691-04-04/ N147 |  | 94976-05-03 \ N58
95854-06-01/ R28 |  | 94976-03-03 \ N56
95862-05-14/ V51 |  | 94130-05-04/ K57
95748-05-04/ N127 |  | 92582-06-08/ P02
95803-04-149/ T02 |  | 92806-06-13 / N64
95803-05-150/ T08 |  | 93828-07-14/ B51
95796-06-01/ A135 |  | 95237-04-120/ G28
95746-03-60/ K138 |  | 95239-04-120/ A13
95768-03-145/ A185 |  | 94734-04-01/ Y54
95716-04-25/ A92 |  | 93308-05-23/ Q47
95716-03-25/ A91 |  | 92915-06-01/ N89
95716-03-130/ A86 |  | 95746-03-60/ K138
95716-04-124/ A182 |  | 95768-03-145/ A185
95716-03-124/ A181 |  | 95716-03-25/ A91
95739-08-04/ N76 |  | 95716-04-25/ A92
95739-07-04/ N75 |  | 95224-03-59/ Y351
95739-06-04/ N74 |  | 94747-07-08/ Y280
Spreadsheet: 856882d1706051363-new-here-please-be-nice-excel-testing
Sheet: Sheet1

Rate | Start Date | End Date | Total Days | Total Charge
500
100
250 | 2024-01-18 00:00:00 | 2024-01-19 00:00:00
1000 | 2024-01-09 00:00:00 | 2024-01-17 00:00:00
Spreadsheet: 744986d1629635654-excel-updating-a-datasheet-with-new-data-list-test
Sheet: Sheet2

 |  |  | date | Names | New Remarks
 |  |  | 2021-08-22 00:00:00 | [NAME] | Newrem1
 |  |  | 2021-08-22 00:00:00 | Gearldine | Newrem2
 |  |  | 2021-08-22 00:00:00 | Maryland | Newrem3
 |  |  | 2021-08-22 00:00:00 | [NAME] | Newrem4
 |  |  | 2021-08-22 00:00:00 | Annette | Newrem5
 |  |  | 2021-08-22 00:00:00 | Sadie | Newrem6
 |  |  | 2021-08-22 00:00:00 | [NAME] | Newrem7
 |  |  | 2021-08-22 00:00:00 | [NAME] | Newrem8
 |  |  | 2021-08-22 00:00:00 | Maryetta | Newrem9
 |  |  | 2021-08-22 00:00:00 | Adelle | Newrem10
 |  |  | 2021-08-22 00:00:00 | Israel | Newrem11
 |  |  | 2021-08-22 00:00:00 | Shaun | [NAME]
 |  |  | 2021-08-22 00:00:00 | Lezlie | Newrem13
 |  |  | 2021-08-22 00:00:00 | [NAME] | Newrem14
 |  |  | 2021-08-22 00:00:00 | Eleonora | Newrem15
 |  |  | 2021-08-22 00:00:00 | Ethel | Newrem16
 |  |  | 2021-08-22 00:00:00 | [NAME] | Newrem17
 |  |  | 2021-08-22 00:00:00 | Zachary | Newrem18
 |  |  | 2021-08-22 00:00:00 | Conchita | Newrem19
 |  |  | 2021-08-22 00:00:00 | Oda | Newrem20
 |  |  | 2021-08-22 00:00:00 | Elmo | Newrem21
 |  |  | 2021-08-22 00:00:00 | Taisha | Newrem22
 |  |  | 2021-08-22 00:00:00 | Argelia | Newrem23
 |  |  | 2021-08-22 00:00:00 | Chastity | Newrem24
 |  |  | 2021-08-22 00:00:00 | [NAME] | Newrem25
Spreadsheet: 539543d1506230051-transfer-bespoke-data-to-different-workbooks-test-sheet-1
Sheet: Thomas (service)

 | Date | PH name | Policy No. | Premium quoted | Premium sold | Notepad | Commission | Incoming/ Proactive
 | 1st Jan | Smith | EF123 | 100 | 80 | Y | 10 | I
 | 4th Jan | Jones | CD456 | 120 | 100 | N | 12 | I
 | 6th Jan | Skywalker | EF456 | 200 | 220 | Y | 70 | I
 | 7th Jan | Yoda | CDX123 | 900 | 900 | Y | 700 | I
Spreadsheet: 105046d1302528755-weighted-average-including-n-a-cc
Sheet: Call 4

 |  | Call ID: |  |  |  | Caller No.:
 |  | Date of Call: |  |  |  | Call Type:
 |  | Time of Call: |  |  |  | Duration:
 |  | Performance Area | Description | Performance |  |  |  |  |  |  |  | Performance Review Summary
 |  |  |  | Performance | Performance | Performance | Performance | Performance | Performance |  |  | Performance Area | Satisfactory Percentage | Weighting | Call 4 Weighted Score
 |  |  |  | Unacceptable | Below Satisfactory | Satisfactory | Good | Excellent | N/A
 |  |  |  | 0 | 0.25 | 0.5 | 0.75 | 1 |  |  |  |  |  | 0.1
 |  | Opening | Welcome using company name |  | 1 |  |  |  |  |  |  |  |  | 0.25
 |  |  | Effective greeting |  |  | 1 |  |  |  |  |  |  |  | 0.15
 |  |  | Agent introduction including name |  |  |  | 1 |  |  |  |  |  |  | 0.15
 |  |  | Get customers name |  |  |  | 1 |  |  |  |  |  |  | 0.25
 |  |  |  | 0 | 0.25 | 0.5 | 0.75 | 1 |  |  |  |  |  | 0.1
 |  | [NAME] | Every effort made towards first call resolution |  |  |  |  | 1 |  |  |  | Total Grade
 |  |  | Asked clarifying questions |  |  |  |  | 1
 |  |  | Demonstrated knowledge of products/services |  |  |  |  | 1
 |  |  | Showed clear understanding problems/issues |  |  |  |  | 1
 |  |  | Accurately diagnosed problems/issues |  |  | 1
 |  |  |  | 0 | 0.25 | 0.5 | 0.75 | 1
 |  | [NAME] | Volume & Clarity of agent |  |  |  |  | 1
 |  |  | Interruption of customer during call |  |  |  | 1
 |  |  | Demonstration of active listening |  |  | 1
 |  |  | Displayed a professional manner |  |  |  | 1
 |  |  | Polite, friendly & welcoming |  |  |  | 1
 |  |  | Avoided long silences / pauses |  |  |  |  | 1
 |  |  |  | 0 | 0.25 | 0.5 | 0.75 | 1
 |  | [NAME] | Requested permission to put on hold |  |  |  | 1
 |  |  | Used mute procedure effectively |  |  |  |  | 1
 |  |  |  | 0 | 0.25 | 0.5 | 0.75 | 1
 |  | Systems Skills | Used correct applications effectively |  |  | 1
 |  |  | Correctly escalated issues through [NAME] |  |  |  |  | 1
 |  |  |  | 0 | 0.25 | 0.5 | 0.75 | 1
 |  | Closing | Offer to assist with any other issue |  |  |  |  | 1
 |  |  | Close by thanking customer for contacting [NAME] |  | 1
Spreadsheet: 812122d1672966954-due-upcoming-overdue-123perwinkle-123
Sheet: R2

Project Phase | Deliverable | Responsible Party | Date Assigned | Date Due | Date Completed | Color | Current Issue? | Issues Resolved? | Due/Overdue | NOTES
Planning & Scope | Create Call Tree for All CAP | Team | 2022-11-17 00:00:00 | 2022-12-07 00:00:00 | 2022-12-07 00:00:00
Planning & Scope | Create Vision document for Careline /CAP STAFF | Team | 2022-11-17 00:00:00 | 2022-12-21 00:00:00 | 2022-12-07 00:00:00
Plan Outline | Finialize Processes for implementation | Team | 2022-11-17 00:00:00 | 2023-01-27 00:00:00
Implementation | Review and obtain headset equipment for STAFF | Team | 2022-11-17 00:00:00 | 2023-01-27 00:00:00 |  |  |  |  |  | 6 ordered to try before all ordered
Implementation | Train and Go Live with Staff | Team | 2022-11-17 00:00:00 | 2023-02-03 00:00:00
Review & Refine | Adjust processes as needed to improve | Team | 2022-11-17 00:00:00 | 2023-04-28 00:00:00
[NAME] | Fully Opearational - | Team | 2022-11-17 00:00:00 | 2023-05-01 00:00:00
Spreadsheet: 803053d1667232158-group-and-ungroup-employee-attendance-tracker-4-
Sheet: Employee Leave Tracker

 | Employee [NAME]
 | Employee Name | Start Date | End Date | Type of Leave | Days | Adjustment
 | [NAME] | 2022-07-21 00:00:00 | 2022-07-22 00:00:00 | [NAME]
 | [NAME] | 2022-08-02 00:00:00 | 2022-08-02 00:00:00 | Holiday |  | -0.5
 | [NAME] | 2022-04-05 00:00:00 | 2022-04-05 00:00:00 | Holiday
 | [NAME] | 2022-07-28 00:00:00 | 2022-08-03 00:00:00 | Holiday
 | [NAME] | 2022-05-12 00:00:00 | 2022-05-16 00:00:00 | Holiday
 | [NAME] | 2022-08-15 00:00:00 | 2022-08-19 00:00:00 | Holiday
 | Stephany [NAME] | 2022-06-23 00:00:00 | 2022-06-27 00:00:00 | Holiday
 | Stephany [NAME] | 2022-08-16 00:00:00 | 2022-08-27 00:00:00 | Holiday
 | Stephany [NAME] | 2022-08-05 00:00:00 | 2022-08-06 00:00:00 | Holiday
 | [NAME]
 | [NAME] | 2022-09-30 00:00:00 | 2022-10-11 00:00:00 | Holiday
 | [NAME] | 2022-09-05 00:00:00 | 2022-09-07 00:00:00 | Holiday