tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 1de783c7-6384-4589-9291-f0b93a738044
Sheet: Sheet1

Step | From Where | Action
0 | Recommendations | Create a new directory on your computer for weekly crime reports called "Weekly Crime Report"
 |  | Save this file and the exported excel spreadsheet from LEAP each week in this same directory
1 | LEAP System | Go to "REPORT" Tab in LEAP Application
 |  | Select "New Report" in light blue tool bar under TABs
 |  | Select "Oakland PD" in Agency drop down list
 |  | Select "Weekly Crime Report" in Name drop down list
 |  | From the date selection boxes,  select the last day you want in your Weekly Crime Report
 |  | Select "Include Primary Offenses Only" radio button
 |  | Select "Blank all the zero values" radio button
 |  | Select "Show all rows with blank/zero values" radio button
 |  | Select the "GO" button on the light blue tool bar to the left and in the middle of your screen
 |  | Select the "Export" tool on the light blue tool bar at the top of the screen just under the TAB bar
 |  | Click on the top area of the daughter security popup window when it appears
 |  | Select  "Download File" from the options presented in the small popup window
 |  | Select "OPEN"  from the choices on the new popup window
 |  | When security question about file formats appears, respond that YES, YOU WANT TO OPEN THE FILE NOW
 |  | This will load the LEAP weekly crime report into an excel spreadsheet with a very long and non-english file name
 |  | VERY IMPORTANT:  Double-click on the worksheet TAB and change the name of the TAB from the long LEAP tab name to simply wcr
 |  | Select SAVE FILE AS from the excel tool menu
 |  | Save the file in THE SAME directory where you store this file (2011 MASTER [NAME]) - probably the "Weekly Crime Report" directory you created in Step 0
 |  | VERY IMPORTANT:  Save the downloaded file from LEAP  with the name wcr source.xls
 |  | Respond to the security question that you want to replace file if this is not the first time you have used this report
 |  | NOW CLOSE THIS FILE THAT YOU RENAMED "WCR SOURCE.XLS"
2 | MASTER [NAME] | Now open this 2011 MASTER [NAME] file if not already OPEN
3 | Adjustments for Homicides TAB
 | MASTER [NAME]
4 | Adjustments for UCR
5 | Pending Re-coding
6 | Manual Adjustments | Make any homicide modifications for non-UCR, justified homicides etc in the "Manual Adjustments" Tab.
 |  | This allows you to modify the homicide counts for each year manually with a + or - number
7 | SAVE MASTER [NAME]
 |  | Once all the changes have been made in items 3-5 above, save the 2011 MASTER [NAME] file
8 | Assemble
 |  | Hold the CTRL key and W key down simultaneous
 |  | The macro will open up the wcr source.xls file and copy it to the 2011 MASTER WCR.xls file and thereport on the Final Report TAB will be ready for printing
Date | 09/18/2011)
2010 | 09/18/2011 | 2011-09-18 00:00:00
2009 |  | 2010-09-18 00:00:00
2008 |  | 2009-09-18 00:00:00
2007 |  | 2008-09-17 00:00:00
 |  | 2007-09-18 00:00:00
Spreadsheet: chris_stokley__3903__Cash Flow information ECR1122 Specs v5
Sheet: Fin Data

 |  |  |  |  | Transactions Affecting Receivables/Cash Management
# | Data Elements | Comments |  |  | OF Inv | OF CM | OF DM | OF Pay | OF Rev | OF Re | ST Inv | [NAME] In | ST Bill | Alt Inv | [NAME] In | [NAME] | LS Inv | [NAME] In | LS Bill | HP Inv | [NAME] | HP Adj | HP Bill | HP Pay | Call Note
 | General Information
1 | Source System Name | 11 systems |  |  | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X
2 | Source System ID Number |  |  |  | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X
77 | Creation Date | File creation date |  |  | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X
 | Referential Information
4 | System Customer ID Number | HP = contract #, others = customer # |  |  | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X
8 | Customer Account (Site) ID Number | HP = UDC acct #, others = billing address reference # |  |  | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X
 | Transactional Information
 | Generic Details
41 | Transaction Type | See columns --> |  |  | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X
31 | Transaction Number | Invoice #, check #, etc. |  |  | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X
32 | Transaction Date | Invoice date, deposit date, etc. |  |  | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X
N5 | Accounted Amount | Portion of transaction amount that is being accounted for by this record. |  |  | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X
 | Financial Accounting Details
21 | Company Number used by Oracle | Code used by Financials |  |  | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | NOT IN ORACLE FINANCIALS
[NAME] | Natural Account | Code used by Financials |  |  | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X
N7 | State | Code used by Financials |  |  | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X
75 | Utility Number (if any) | Code used by Financials |  |  | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X
23 | Type of customer | Code used by Financials |  |  | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X
19 | Commodity | Code used by Financials |  |  | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X
74 | Utility Name | May vary slightly by system |  |  | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X | X
 | Other Notes
 | There will be a financial record for each line on a transaction. |  |  |  | Key:
 | Only new transactions will have financial accounting records.
 | Financial records for a transaction will always net to zero because we will provide debits and credits. |  |  |  | Yellow box = Data element not applicable to this transaction
 |  |  |  |  | X = Data element is available for this transaction
 |  |  |  |  | X1 = Stored at account level for all transactions
Spreadsheet: 791392d1660320300-vlookup-across-multiple-sheets-and-add-results-sample-finance
Sheet: May

Monthly Financial Report
Deposits | Source |  | Expense | Vendor |  | Allocated Funds | Reason |  | Previous Month Bal | Current Bal | Allocated Bal | Available Bal |  | Deposits
5000 | Income |  | 225 | Fuel |  |  |  |  |  |  |  |  |  | Payments
 |  |  | 300 | Cell |  |  |  |  |  |  |  |  |  | Previous Allocated
 |  |  | 200 | Cable |  |  |  |  |  |  |  |  |  | Newly Allocated
Spreadsheet: 08274b56-0bb6-4070-8f8c-01899075b458
Sheet: Sheet1

DIVISION 1 CIF-SS/FORD 2013 BOYS TENNIS CHAMPIONSHIPS | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
1ST ROUND |  | 2ND ROUND | QRT FINALS | SEMIFINALS | FINALS
WED., MAY 8 |  | FRI., MAY 10 | MON., MAY 13 | WED., MAY 15 | FRI., MAY 17
3:00 p.m. |  | 3:00 p.m. | 3:00 p.m. | 3:00 p.m. | Claremont Club
*University | Pacific Coast #1 |  |  |  | 11:30 a.m.
 |  | University
Redondo Union | Winner WC A | 15-3
*San Clemente | South Coast #1 | Thurs., May 9     F | University
 |  | *San Clemente | 13-5
[NAME] | Trinity #3 | 17-1
*Calabasas | Marmonte #1 |  |  | *University | PLEASE REPORT SCORES TO:
 |  | *Calabasas | F | 14-4 | www.cifsshome.org
Campbell Hall | Alpha #3 | 17-1 |  |  | Home Campus
*Fountain Valley | Sunset #2 | F | *Fountain Valley
 |  | Fountain Valley | 10-8
Chaminade | Mission #2 | 12-6
*Santa Barbara | Channel #1 |  |  |  | University
 |  | *Santa Barbara |  |  | 15-3
Thousand Oaks | Marmonte #3 | 14-4
*Viewpoint | Alpha #1 | F | *Santa Barbara
2:30 p.m. [NAME] |  | Viewpoint | 10-8
Arcadia | Pacific #2 | 14-4
*Lutheran/Orange | Trinity #1 |  | 4:00 p.m. | Santa Barbara
 |  | Lutheran/Orange | F | 13-5
Capistrano Valley | South Coast #3 | 9-9 (83-73)
*Palos Verdes | Bay #1 | F | Palos Verdes
 |  | *Palos Verdes | 14-4
Beckman | Winner WC B | 13-5
*Harvard-Westlake | Mission #1
4:00 p.m. |  | *Harvard-Westlake |  |  |  | University
Hoover | Pacific #3 | 15-3 |  | F |  | CHAMPION
*Westlake | Marmonte #2 | F | Harvard-Westlake |  |  | 13-5
 |  | Westlake | 13-5
[NAME] | Channel #2 | 11-7
*[NAME] | South Coast #2 |  |  | Harvard-Westlake
 |  | *Northwood |  | 12-6
Northwood | Pacific Coast #3 | 15-3
*Los Alamitos | Sunset #1 |  | *Los Alamitos
 |  | Los Alamitos | 11-7
Peninsula | Bay #3 | 13-5
*Mira Costa | Bay #2 |  |  |  | *Corona del Mar
 |  | [NAME] |  |  | 12-6
[NAME] | Channel #3 | 17-1
*Burroughs/Burbank | Pacific #1 |  | *Mira Costa
 |  | *Marina | 12--6
Marina | Winner WC C | 10-8
*Santa Margarita | Trinity #2
 |  | *Loyola |  | *Corona del Mar
Loyola | Mission #3 | 10-8 | F | 13-5
*Corona del Mar | Pacific Coast #2 |  | Corona del Mar
 |  | Corona del Mar | 13-5
Brentwood | Alpha #2 | 16-2
*Denotes Host Team
BOYS TENNIS DIVISION 1
Spreadsheet: 7424becb-aab9-431c-8521-d0608c0bd2e7
Sheet: 0. Thinkgate Efficiencies

 | Thinkgate Efficiencies
 | Description | [NAME] | Applicable Requirements | Notes
0.1 | State approved standards are maintained in the Thinkgate system by the state | Standards & Curriculum | 1.1.4 and 1.1.5
0.2 | [NAME] is maintained in the Thinkgate system by the state | Standards & Curriculum | 1.2.2
0.3 | Items can be created and seamlessly shared amongst participating LEAs | Assessments | 2.1.1
0.4 | Common platform allows for assessment items purchased through consortiums, multiple LEAs, or at the state level to be easily imported into the Thinkgate system for access by appropriate LEAs. | Assessments | 2.1.1
0.5 | Thinkgate provides a mechanism to bulk import a variety of item types. | Assessments | 2.1.5
0.6 | Thinkgate system provides electronic approval workflow within the system. | Assessments | 2.1.11
0.7 | Common platform allows for assessments purchased through consortiums, multiple LEAs, or at the state level to be easily imported into the Thinkgate system for access by appropriate LEAs. | Assessments | 2.2.1
0.8 | Assessments can be created and seamlessly shared amongst participating LEAs | Assessments | 2.2.1
0.9 | Thinkgate tool will allow for participating LEAs to compare themselves against other participating LEAs and statewide. | Data Analysis & Reporting | Various
0.1 | Thinkgate tool supports statewide data reporting (e.g. RttT reporting) with easy data extraction and the capability for statewide report development | Data Analysis & Reporting | Various
0.11 | One stop shop with common user interface for curriculum and assessments | User Interfaces | Various
0.12 | Portal on ODE's web page to get to IIS and ilearn Ohio tools | User Interfaces | Various
0.13 | System integration with multiple regional, state and national level systems and databases | Data & Systems Integration | Various
0.14 | Supports a multitude of standards (e.g. CEDS, LTI, etc.) | Data & Systems Integration | Various
0.15 | Low LEA system maintenance - SaaS solution | Data Security & Access | Various
0.16 | State guided training, documentation and support available | Docs, Training & Support | Various
Spreadsheet: 780442d1652455033-subtract-1-row-from-dynamic-range-sample
Sheet: Sheet1

Store | Employee | Sales
store 1 | EMP # 1 | 1 |  | sales of emp # 1 at store 1
store 2 | EMP # 2 | 2
store 1 | EMP # 2 | 3
store 1 | EMP # 1 | 4
store 2 | EMP # 1 | 5
store 1 | EMP # 2 | 6
store 2 | EMP # 2 | 7
store 1 | EMP # 1 | 8
store 1 | EMP # 1 | 9
store 2 | EMP # 2 | 0
store 1 | EMP # 2 | 3
store 2 | EMP # 1 | 8
store 1 | EMP # 1 | 1
store 1 | EMP # 2 | 2
store 2 | EMP # 2 | 3
store 1 | EMP # 1 | 4
store 2 | EMP # 1 | 5
store 1 | EMP # 2 | 6
store 1 | EMP # 2 | 7
store 2 | EMP # 1 | 6
store 1 | EMP # 1 | 5
store 2 | EMP # 2 | 4
store 1 | EMP # 2 | 3
store 1 | EMP # 1 | 2
Count = 24 |  | 104
Spreadsheet: 84817d1284911227-a001-instead-of-p41_a001_2g-book2_search
Sheet: Site Detail

NAME | ID | PHASE | REGION | [NAME] | DATA2 | DATA3
NAME1 | A39_BMY101_2G1i | 39 | North West II
NAME2 | A39_BTB148_2G1i | 39 | North West II
NAME3 | A39_KCM155_2G1i | 39 | North East
NAME4 | A39_KCM167_2G1i | 39 | North East
NAME5 | A39_KCN051_2G1i | 39 | North West II
NAME6 | A39_KCN052_2G1i | 39 | North West II
NAME7 | A39_KCN053_2G1i | 39 | North West II
NAME8 | A39_KCN054_2G1i | 39 | North West II
NAME9 | A39_KCN055_2G1i | 39 | North West II
NAME10 | A39_KTM055_2G1i | 39 | North West I
NAME11 | A39_KTM056_2G1i | 39 | North West I
NAME12 | A39_KTM057_2G1i | 39 | North West I
NAME13 | A39_KTM058_2G1i | 39 | North West I
NAME14 | A39_KDL077_2G1i | 39 | Central II
NAME15 | A39_KDL078_2G1i | 39 | Central II
NAME16 | A39_KDL079_2G1i | 39 | Central II
NAME17 | A39_KDL080_2G1i | 39 | Central II
NAME18 | A39_KDL081_2G1i | 39 | Central II
NAME19 | A41_PNH003_2G1i | 41 | Central I
NAME20 | A41_PST003_2G1i | 41 | North West II
NAME21 | A41_PVR004_2G1i | 41 | North West I
NAME22 | A41_PVR005_2G1i | 41 | North West I
NAME23 | A41_PVR006_2G1i | 41 | North West I
[NAME] | A41_PVR007_2G1i | 41 | North West I
NAME25 | A41_PVR008_2G1i | 41 | North West I
NAME26 | A41_PVR010_2G1i | 41 | North West I
NAME27 | A41_SRG001_2G1i | 41 | South East
NAME28 | A41_SRP001_2G1i | 41 | North West I
NAME29 | A41_SRP003_2G1i | 41 | North West I
NAME30 | A41_STG002_2G1i | 41 | North East
Spreadsheet: 85539d1285632571-ranking-top-3-book1
Sheet: Original_Data

Team Name | Score
Team 3 | 20
Team 28 | 57
Team 24 | 243
Team 32 | 247
Team 8 | 274
Team 21 | 279
Team 12 | 321
Team 26 | 401
Team 29 | 438
Team 4 | 445
Team 14 | 459
Team 9 | 468
Team 11 | 585
Team 13 | 721
Team 7 | 744
Team 6 | 759
Team 23 | 1104
Team 31 | 1105
Team 27 | 1138
Team 10 | 1201
Team 25 | 1279
Team 30 | 1338
Team 17 | 1357
Team 1 | 1383
Team 15 | 1386
Team 2 | 1472
Team 5 | 1558
Team 18 | 1583
Team 20 | 1598
Team 16 | 1720
Team 19 | 1746
Team 22 | 1968
Spreadsheet: 676487d1588832863-index-match-formula-manager-and-employee-for-work-contact-tree-book4
Sheet: Management

Management Staff
Name | Office | Position Title | Work Desk Phone | Work Mobile Phone | [NAME] | Personal Mobile Phone | Notes
[NAME]. 1 | 9999 | Manager | [PHONE] | [PHONE] | [EMAIL] | [PHONE]
[NAME]. 2 | 9999 | Manager | [PHONE] | [PHONE] | [EMAIL] | [PHONE]
[NAME]. 3 | 9999 | Manager | [PHONE] | [PHONE] | [EMAIL] | [PHONE]
Spreadsheet: 224550d1364605135-conditional-drop-down-lists-in-excel-2007-accounting-records
Sheet: Accounting

Date Completed | Account or individual | Class | Item | Cost of Mat'ls | Time Spent (Hrs) | Charges for Services or Products | Effective Labor Rate ($/Hr) | Profit | Margin (Based on $20/hr) | Date Paid in Full
2013-03-21 00:00:00 | Alicia | Tip | [NAME]
 |  | Labor
2013-03-27 00:00:00 | Nate | [NAME]
 |  | Labor
Spreadsheet: 722460d1615286784-modify-my-formula-to-to-check-the-values-and-enter-the-result-and-if-no-values-enter-a-m-missing-and-sum-gk-
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  | M | 1952-06-02 00:00:00 |  |  |  |  |  |  | P | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | L | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | K | 3
 |  |  |  | 4 | 4 | 4 | 4 |  |  | 4 | 4 | 4 | 9 | 9 | 9 | 9 |  | 9 | 9 | 9 | 9 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
 |  |  |  | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7 | 7
 |  |  |  | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 8 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6 | 6
 |  |  |  |  | 4
 |  |  |  |  | 9 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Missing Numbers |  |  |  |  | 4 | 3 | 8 |  |  | need a formula that will check F18:f26 anf if a zero appears  in H18:H26  it will record the number for Column E that matches a zero from column B
 |  |  |  |  | 2
 |  |  |  |  | 3
 |  |  |  |  | 5
 |  |  |  |  | 7
 |  |  |  |  | 8
 |  |  |  |  | 1
 |  |  |  |  | 6
Spreadsheet: 681683d1591700885-proportion-values-by-dates-sample-mb-v2-strip-allocation-
Sheet: 10 rows (2)

 |  |  |  | Waste Stripping
 | Totals ---> |  | Period --->
 |  |  | Period Starting ---> | 2020-06-01 00:00:00
 |  |  | Day of week
 |  |  | No. days ---> | 1 | 1 | 1 | 1 | 1 | 1 | Check
Grand Total | Grand Total | Grand Total
Start Date | End Date | Total Stripping | # | Ensure leave column M blank for formula to calculate correctly |  |  |  |  |  |  | Check
2020-06-01 00:00:00 | 2020-06-02 23:28:30.053000 | 6811.622574388399 | #
2020-06-02 23:28:30.053000 | 2020-06-04 22:19:51.674000 | 6628.269106194901 | #
2020-06-04 22:19:51.674000 | 2020-06-06 00:00:00 | 3682.935136949893 | #
2020-06-01 01:15:50.746000 | 2020-06-01 17:41:02.394000 | 2985.999166666666 | #
2020-06-01 17:41:02.394000 | 2020-06-02 06:59:29.270000 | 6653.732781574193 | #
2020-06-01 05:04:34.821000 | 2020-06-01 11:27:10.653000 | 3188.31 | #
2020-06-03 01:00:06.762000 | 2020-06-03 02:35:58.481000 | 798.849861111111 | #
2020-06-03 02:35:58.481000 | 2020-06-03 06:03:49.572000 | 1732.095972222222 | #
2020-06-03 06:03:49.572000 | 2020-06-03 06:09:51.022000 | 50.20138888888889 | #
2020-06-03 06:09:51.022000 | 2020-06-03 12:57:32.241000 | 3397.391527777777 | #
2020-06-02 10:50:48.649000 | 2020-06-02 11:01:09.141000 | 75.410874557 | #
2020-06-02 15:21:16.011000 | 2020-06-02 16:21:02.672000 | 435.901009 | #
2020-06-02 16:21:02.672000 | 2020-06-02 16:22:11.470000 | 8.361264819 | #
2020-06-02 11:01:09.141000 | 2020-06-02 11:39:53.567000 | 282.4965880315925 | #
2020-06-02 11:39:53.567000 | 2020-06-02 18:49:37.359000 | 2689.343166074618 | #
2020-06-02 18:49:37.359000 | 2020-06-02 18:59:33.475000 | 72.448165566 | #
2020-06-02 18:59:33.475000 | 2020-06-02 22:28:33.650000 | 1524.056698834163 | #
2020-06-02 22:28:33.650000 | 2020-06-03 00:04:07.502000 | 696.8575428769096 | #
 |  |  | check with yours
Spreadsheet: bf973888-ceab-4e98-ab08-209ffc2b6af3
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
44297483 | 2014-12-04 06:11:57 | AXIS | 0 | 5 | 10 | 603439 | MickeyScott01 | 7662 | eastern | 1942-10-22 | 1942-10-22 | Red Barricades Factory | Les Barricades Rouges
44354600 | 2014-12-08 07:06:05 | ALLIES | 0 | 3 | 7 | 535116 | Corporal [NAME] | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
44395127 | 2014-12-11 07:24:36 | AXIS | 1 | 6 | 3 | 1682320 | vetalmd1 | 6749 | western | 1944-06-06 | 1944-06-06 | [NAME] | [NAME]
44408163 | 2014-12-12 07:35:05 | AXIS | 1 | 7 | 1 | 270299 | 3FingerJimbo | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
44408280 | 2014-12-12 07:53:11 | ALLIES | 1 | 7 | 2 | 270299 | 3FingerJimbo | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
44421142 | 2014-12-13 07:42:41 | AXIS | 0 | 2 | 6 | 1663862 | player1663862 | 7271 | western | 1944-12-18 | 1944-12-18 | [NAME] | Villages jumeaux
44421503 | 2014-12-13 08:20:49 | ALLIES | 1 | 6 | 4 | 1362585 | NEMAUS | 6150 | mediterranean | 1944-08-25 | 1944-08-25 | [NAME] | [NAME]
44435708 | 2014-12-14 07:05:42 | ALLIES | 0 | 6 | 7 | 192431 | Kain51 | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
44435923 | 2014-12-14 07:15:57 | AXIS | 0 | 4 | 7 | 192431 | Kain51 | 7594 | eastern | 1943-07-05 | 1943-07-09 | Ponyri | Ponyri
44451815 | 2014-12-15 07:14:34 | ALLIES | 0 | 5 | 6 | 780030 | keithdone | 12505 | western | 1945-02-17 | 1945-02-20 | Moyland Wood | [NAME]
44493093 | 2014-12-18 07:28:39 | ALLIES | 1 | 7 | 6 | 496922 | Helcat | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
44493282 | 2014-12-18 07:56:36 | AXIS | 0 | 5 | 7 | 496922 | Helcat | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
Spreadsheet: 349190d1412242367-calculating-gpa-calculating-gpa
Sheet: Sheet1

student number | Course name | Mark
22334567 | Math | 56
22334567 | English | 54
22334567 | Science | 87
22334567 | Biology | 67
6789654 | Math | 56
6789654 | English | 45
6789654 | History | 34
12347634 | Math | 98
12347634 | English | 65
12347634 | Geography | 56
12347634 | Biology | 44
Spreadsheet: 875087d1721657168-sum-of-items-from-another-sheet-sumadtest
Sheet: Data_dump

Useless | Useless | Useless | EMP | Useless | [NAME] | Start Date | Useless | Useless | Value | Total
 |  |  | Staff [NAME] |  | [NAME] |  |  |  | 10
 |  |  | Staff [NAME] |  | [NAME] 6 |  |  |  | 60
 |  |  | Staff [NAME] |  | [NAME] |  |  |  | 20
 |  |  | Staff [NAME] |  | [NAME] |  |  |  | 10
 |  |  | Staff [NAME] |  | [NAME] 3 |  |  |  | 30
 |  |  | Staff [NAME] |  | [NAME] |  |  |  | 50
 |  |  | Staff [NAME] |  | [NAME] |  |  |  | 20
 |  |  | Staff [NAME] |  | [NAME] |  |  |  | 40
 |  |  | Staff [NAME] |  | [NAME] |  |  |  | 50
 |  |  | Staff [NAME] |  | [NAME] 6 |  |  |  | 60
 |  |  | Staff [NAME] |  | [NAME] 3 |  |  |  | 30
 |  |  | Staff [NAME] |  | [NAME] 6 |  |  |  | 60
 |  |  | Staff [NAME] |  | [NAME] |  |  |  | 40
 |  |  | Staff [NAME] |  | [NAME] |  |  |  | 20
 |  |  | Staff [NAME] |  | [NAME] |  |  |  | 50
Spreadsheet: 707406d1607251206-using-a-list-to-reduce-worksheets-midshires-master
Sheet: AMi

 |  |  |  | ADJUSTED HANDICAP |  |  |  |  |  | OFFICIAL HANDICAP |  |  |  |  | HANDICAPPING ALTERATIONS
hole | par | S/I | SHOTS | CALC | points | PAR 3 | SI/1 | SI/2 | S1/3 | SI/1 | S1/2 | S1/3 | CALC | points | EXACT | catagory | BUFFER | css | Nett | adjustment
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HANDICAP |  | ZONE |  | Differential
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | sss | css adj | "RO"
in
out |  |  |  |  |  | TOTAL
total
Spreadsheet: 124550d1318455106-excel-2007-invoice-data-lookup-order-template-wip
Sheet: Applicators

Applicators
Brushes | Liquid Foundation | 10 | Brushes
[NAME] | Cream Eye Color | 10
Cosmetic Sponge | Concealer Brush | 10
Travel [NAME] | Mineral Foundation Brush | 10
 | Brush Collection | 48
 | [NAME] | 4 | [NAME]
 | Pack of two | 2.5 | Cosmetic Sponge
 | Unfilled | 30 | Travel [NAME]
Spreadsheet: 818353d1676755236-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
Spreadsheet: 766494d1643905919-nested-iif-formula-based-on-true-false-and-3-more-criteria-officestatussample
Sheet: BUE

eEmpID | FullName | 5/8 | Leave | Tele | Status
123 | Blow, [NAME] | False
321 | Smith, [NAME] | True
111 | Guy, Anybody | True