tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 102234d1300215134-calculating-a-total-based-on-unique-id-removeduplicatesandsum
Sheet: Sheet1

ID | Activities |  | Unique IDs | Sum of Activities
ID 55 | 10 |  | ID 55 | 13
ID 56 | 6 |  | ID 56 | 13
ID 57 | 4 |  | ID 57 | 104
ID 58 | 9 |  | ID 58 | 59
ID 59 | 12 |  | ID 59 | 83
ID 55 | 3 |  | ID 60 | 220
ID 56 | 7 |  | ID 61 | 243
ID 57 | 100 |  | ID 62 | 266
ID 58 | 50 |  | ID 63 | 116
ID 59 | 71 |  | ID 64 | 127
ID 60 | 82
ID 61 | 93
ID 62 | 105
ID 63 | 116
ID 64 | 127
ID 60 | 138
ID 61 | 150
ID 62 | 161
Spreadsheet: 785693d1656554712-index-match-for-multiple-values-in-array-data
Sheet: ActionReasons

Action | Reason | Reason Description (i.e. [NAME])
Data Adjustment | JED | Job Earnings Distribution
Data Adjustment | DAT | Date Adjustment
Hire | AST | Appointment Start Conversion
Hire | HIR | New Hire
Hire | CNV | Conversion
Hire | CNV | Conversion
Hire | CNV | Conversion
Job Change | RTC | Reports To Change
Job Change | ROT | Reduction of Teaching
Job Change | ERT | End Reduction of Teaching
Job Change | ARC | Academic Rank Change
Job Data Adjustment | UDJ | Job Data Update
Leave of Absence | ACD | Academic
Leave of Absence | NEG | Negotiated
Leave of Absence | TMP | Temporary Assignment
Leave of Absence | PER | General
Leave of Absence | PER | General
Leave of Absence | SWB | Short Work Break
Pay Change | CSA | Conversion Salary
Pay Change | SCI | Scale Increase
Pay Change | ASI | Academic Salary Increase
Pay Change | SAI | [NAME]
Pay Change | SPI | Step Increase
Pay Change | MER | Merit Increase
Position Change | PRU | Position Reclassification Up
Position Data Adjustment | UPD | Position Data Update
Rehire | REH | Rehire
Retirement | ERT | Early Retirement
Return from Leave | ACD | Academic
Return from Leave | NEG | Negotiated
Return from Leave | TMP | Temporary Assignment
Return from Leave | PER | General
Return from Leave | SWB | Short Work Break
Termination | JOB | End of Contract
Transfer | PRO | Promotion
Transfer | LTL | Lateral
Spreadsheet: louise_kitchen__23837__2QYTD Orig w notes
Sheet: Central Gas

Central Gas
Mid Year 2001
Originator |  | Commodity |  | Team |  | Total |  | %Total
Luce* |  | Gas |  | Central
Pollan |  | Gas |  | Central
Meyer |  | Gas |  | Central
Carrabine |  | Gas |  | Central
Frihart |  | Gas |  | Central |  | 104400
[NAME] |  | Gas |  | Central |  | 69232.21
Penman |  | Gas |  | Central |  | 32100
[NAME] |  | Gas |  | Central |  | 9125
[NAME] |  | Gas |  | Central |  | 751
Total
*$6,419,391 of total is Ennovate and runs through the trading line of the DPR.
Spreadsheet: 837623d1690295780-loan-grace-periods-and-a-complicated-sum-function-help-file
Sheet: Sheet2

 |  |  |  |  |  |  |  | Loan 1 |  |  |  |  |  |  |  |  | Loan 2 |  |  |  |  |  |  |  |  | Loan 3 |  |  |  |  |  |  |  |  | Loan 4
 |  |  |  |  |  |  |  |  |  | ABK |  |  |  |  |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  | AAIB |  |  |  |  |  |  |  |  | MED Bank
 |  |  |  |  |  |  |  |  |  | Start Date | 2023-03-01 00:00:00 |  | Flat Translation |  |  |  |  |  | Start month | 2023-04-01 00:00:00 |  | Flat Translation |  |  |  |  |  | Start Date | 2023-05-01 00:00:00 |  | Flat Translation |  |  |  |  |  | Start Date | 2023-05-01 00:00:00 |  | Flat Translation
 |  |  |  |  |  |  |  |  |  | Principle |  |  | Principle Payment |  |  |  |  |  | Principle |  |  | Principle Payment |  |  |  |  |  | Principle |  |  | Principle Payment |  |  |  |  |  | Principle |  |  | Principle Payment
 |  |  |  |  |  |  |  |  |  | Admin Fees |  |  |  |  |  |  |  |  | Admin Fees |  |  |  |  |  |  |  |  | Admin Fees |  |  |  |  |  |  |  |  | Admin Fees
 |  |  |  |  |  |  |  |  |  | Received |  |  | Interest |  |  |  |  |  | Received |  |  | Interest |  |  |  |  |  | Received |  |  | Interest |  |  |  |  |  | Received |  |  | Interest
 |  |  |  |  |  |  |  |  |  | Annual Rate | 0.21 |  | Interest Payment |  |  |  |  |  | Annual Rate | 0.245 |  | Interest Payment |  |  |  |  |  | Annual Rate | 0.235 |  | Interest Payment |  |  |  |  |  | Annual Rate | 0.235 |  | Interest Payment
 |  |  |  |  |  |  |  |  |  | Monthly |  |  | Total |  |  |  |  |  | Monthly |  |  | Total |  |  |  |  |  | Monthly |  |  | Total |  |  |  |  |  | Monthly |  |  | Total
 |  |  |  |  |  |  |  |  |  | Years |  |  |  |  |  |  |  |  | Years |  |  |  |  |  |  |  |  | Years |  |  |  |  |  |  |  |  | Years
 |  |  |  |  |  |  |  |  |  | Tenor - months |  |  |  |  |  |  |  |  | Tenor - months |  |  |  |  |  |  |  |  | Tenor - months |  |  |  |  |  |  |  |  | Tenor - months
 |  |  |  |  |  |  |  |  |  | Early Repayment Fee |  |  |  |  |  |  |  |  | Early Repayment Fee |  |  |  |  |  |  |  |  | Early Repayment Fee |  |  |  |  |  |  |  |  | Early Repayment Fee
 | In yellow - these are meant to be summations of the all the right hand side tables. |  |  |  |  |  |  |  |  | Total Interest Payment |  |  |  |  |  |  |  |  | Total Interest Payment |  |  |  |  |  |  |  |  | Total Interest Payment |  |  |  |  |  |  |  |  | Total Interest Payment
Summary Table
Month | Open Bal | Interest | Principle | Total PMT | End Bal | Early Settl. |  | Month
2023-03-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  | 1 |  |  |  |  |  |  |  |  | 1
Spreadsheet: 748144d1631912872-hard-time-figuring-out-this-problem-involving-match-and-index-wright_excel_ch05_ps2_musiclessons
Sheet: StudentData

Student Data
[NAME] | StudentName | Instrument | Teacher | Competition? | Uniform Size | Permission Slip | Skill level | Price Per Hour
000001 | [NAME] | Piano | [NAME] | Yes | XL | No | Advanced
000002 | [NAME] | Drums | [NAME] | Yes | M | Yes | Intermediate
000003 | [NAME] | Viola | [NAME] | Yes | L | Yes | Intermediate
000006 | [NAME] | Drums | Anne | Yes | XL | Yes | Beginner
000008 | Violet Ward | Guitar | [NAME] | Yes | XL | Yes | Advanced
000010 | [NAME] | Drums | [NAME] | Yes | XL | Yes
000016 | [NAME] | Cello | [NAME] | Yes | M | Yes | Beginner
000018 | [NAME] | Piano | [NAME] | Yes | XXL | Yes | Expert
000020 | [NAME] | Cello | [NAME] | Yes | XL | Yes
000022 | [NAME] | Guitar | [NAME] | Yes |  | No | Intermediate
000025 | [NAME] | Violin | [NAME] | Yes |  | Yes | Advanced
000028 | [NAME] | Guitar | Anne | Yes | S | Yes | Advanced
000033 | [NAME] | Trumbone | [NAME] | Yes |  | No | Beginner
000044 | [NAME] | Violin | [NAME] | Yes | S | Yes | Beginner
000049 | [NAME] | [NAME] | [NAME] | Yes | M | Yes | Expert
000053 | [NAME] | Flute | [NAME] | Yes | M | Yes | Intermediate
000057 | Merrill Hull | Clarinet | [NAME] | Yes | XXL | Yes | Expert
000059 | [NAME] | Tuba | [NAME] | Yes | M | No | Advanced
000060 | [NAME] | Violin | [NAME] | Yes | XXL | Yes | Advanced
000061 | [NAME] | Cello | [NAME] | Yes | S | Yes | Advanced
000062 | [NAME] | Tuba | [NAME] | Yes | L | No
000067 | [NAME] | Tuba | [NAME] | Yes | L | Yes | Beginner
000068 | [NAME] | Drums | [NAME] | Yes | XL | No | Intermediate
000072 | [NAME] | Flute | Anne | Yes | XXL | No | Intermediate
000074 | Evangeline Gaines | Clarinet | Anne | Yes | XL | No | Advanced
000081 | [NAME] | Trumbone | [NAME] | No | L | No
000082 | [NAME] | Guitar | [NAME] |  | XL |  | Advanced
000083 | Galvin Todd | Piano | Debbie | Yes | XS | Yes | Intermediate
000084 | [NAME] | Guitar | [NAME] | Yes | L | Yes | Beginner
000085 | [NAME] | [NAME] | [NAME] |  | M |  | Advanced
000086 | [NAME] | [NAME] | Mark | No | L | No | Advanced
000087 | [NAME] | Tuba | [NAME] | No | M | No | Expert
Spreadsheet: 489141d1479128233-help-summing-values-from-several-worksheets-tabs-collector-summary-november-2016
Sheet: NOV 1 2016

 | MTD | Collector | Subroll $ | Roll $ | Rate $ | Combined | # Calls | RPC | RPC % Ratio | PTP | PTP % Ratio | Scored Call
1 | 24501 | MARIAH |  | 24501 |  | 24501 | 210 | 24 |  | 18
2 | 38889 | [NAME] | 0 | 38889 | 0 |  | 139 | 12 |  | 8
3 | 245434 | [NAME] | 35523 | 209911 | 0 |  | 133 | 20 |  | 13
4 | 73315 | KRISTY WOODS | 64992 | 8323 | 0 |  | 316 | 25 |  | 10
5 | 0 | CRAIG VANTERPOOL | 0 | 0 | 0 |  | 246 | 19 |  | 6
6 |  | RASHEED SHABAAZ
7 |  | DANNY CANTU
8 | 49729 | TOINETTE WEST | 9001 | 17664 | 23064 |  | 95 | 11 |  | 9
9 | 181900 | NINA HERNANDEZ | 120763 | 58925 | 2212 |  | 174 | 12 |  | 8 | 0
10 | 90871 | [NAME] | 0 | 90871 | 0 |  | 141 | 4 |  | 4
11 | 186098 | PHILIP PARSON | 73760 | 93909 | 18429 |  | 193 | 22 |  | 19
12 | 45036 | MARIA ARISPE | 0 | 41556 | 3480 |  | 138 | 14 |  | 10
13 | 1931 | HANSON STRICKLING | 1931 | 0 | 0 |  | 106 | 3 |  | 3
14 | 52807 | DEVANTE STRAIGHT | 5251 | 47556 | 0 |  | 135 | 7 |  | 4
15 | 185954 | MARTINE PALLAI | 138433 | 47521 | 0 |  | 301 | 18 |  | 18
16 |  | PORSCHE CLARK
17 | 22123 | COMFORT AKINOLA | 11976 | 10147 | 0 |  | 236 | 6 |  | 6
18 | 47455 | SAMANTHA CASTILLO | 0 | 23526 | 23929 |  | 314 | 14 |  | 5
19 | 66804 | LISA RODRIGUEZ | 9278 | 57526 | 0 |  | 231 | 16 |  | 16
20 |  | SHAUN COOPER
21 | 46428 | CONSUELA JAVIER | 24962 | 21466 | 0 |  | 175 | 16 |  | 15
22 | 69832 | QUEANA MAHONEY | 23370 | 46462 | 0 |  | 197 | 7 |  | 7
 |  | AVERAGE:
 |  | MEETING NOTES
 |  | *** DANNY AND RASHEED OFF, PORSCHE AND SHAUN OUT
 |  | **
 |  | **
Spreadsheet: 887959d1738266324-absolute-values-in-pivot-table-in-calculated-field-mape
Sheet: Sheet1

Customer | Product Line | Forecast | Actuals |  | Variance For to Act | Absolute Value |  | Forecast Variance |  |  | MAPE
[NAME] | Fruits | 50000 | 60000 |  |  |  |  | [NAME] |  |  | [NAME]
[NAME] | Veggies | 20000 | 30000 |  |  |  |  | [NAME] |  |  | [NAME]
[NAME] | Meat | 22000 | 10000
[NAME] | Milk | 19500 | 19000 |  |  |  |  | Forecast [NAME] |  |  | MAPE %
[NAME] | Snacks | 35000 | 33000 |  |  |  |  | [NAME] |  |  | [NAME]
[NAME] | Dry Goods | 46000 | 45000 |  |  |  |  | [NAME] |  |  | [NAME]
[NAME] | Pet Food | 32000 | 32000
[NAME] | Veggies | 110000 | 100000
[NAME] | Milk | 90000 | 95000
[NAME] | Snacks | 30000 | 40000
[NAME] | Dry Goods | 105000 | 100000
 |  |  |  |  |  |  |  | Row Labels | Sum of Forecast | Sum of Actuals | Sum of Forecast Variance | Sum of MAPE | Should be
 |  |  |  |  |  |  |  | [NAME] | 224500 | 229000 | -4500 | -4500 | 35500
 |  |  |  |  |  |  |  | [NAME] | 335000 | 335000 | 0 | 0 | 20000
 |  |  |  |  |  |  |  | Row Labels | Sum of Forecast | Sum of Actuals | Sum of Forecast Variance | Sum of MAPE
 |  |  |  |  |  |  |  | Dry Goods | 151000 | 145000 | 6000 | 6000
 |  |  |  |  |  |  |  | Fruits | 50000 | 60000 | -10000 | -10000
 |  |  |  |  |  |  |  | Meat | 22000 | 10000 | 12000 | 12000
 |  |  |  |  |  |  |  | Milk | 109500 | 114000 | -4500 | -4500
 |  |  |  |  |  |  |  | Pet Food | 32000 | 32000 | 0 | 0
 |  |  |  |  |  |  |  | Snacks | 65000 | 73000 | -8000 | -8000
 |  |  |  |  |  |  |  | Veggies | 130000 | 130000 | 0 | 0
Spreadsheet: louise_kitchen__24044__Natural Gas Consolidated
Sheet: East Trading

 |  | 2001-09-01 00:00:00 |  | 2001-09-01 00:00:00 |  | %
 |  | YTD Actual |  | Annualized |  | of Total
ENACOMP | Compensation
 | Special Pays | 150000
 | Analyst & Associates | 158500
ENABENTX | Benefits & Payroll Taxes
ENAEMPEX | Employee Expense
ENAT&EEX | Travel & Entertainment Expense
ENAOUTSV | Outside Services
ENASUPP | Supplies Expense
ENAMKTEX | Marketing
ENACONTR | Charitable Contributions
ENARENT | Rent
ENATECH | Technology
ENATRANS | Transportation
ENAOTHEX | Other Expenses
ENATAXES | Taxes Other than Income
ENATOTDR | Total Direct Expenses
 | Headcount |  |  | 15
 | Analyst & Associate Headcount |  |  | 4
 | Total Headcount
ENAOUTLG | Outside Legal
ENAOUTTX | Outside Tax
ENAINSUR | Insurance
ENASYSDV | System Development
ENACORIT | Controllable Infrastructure
ENACORRN | Corporate Rent
ENAOTHAL | Other Allocated Direct  Expenses
ENADEPR | Depreciation & Amortization
Spreadsheet: 0d10fb4c-b67c-4890-a930-831ee2913701
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
 | 6427.0 Producer Price Indexes, Australia
 | Table 23. Selected output of division N administrative and support services, group and class index numbers
Related Information: | Summary Publication | Explanatory Notes | Inquiries
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Index Numbers ;  721 Employment services ; |  |  | Original | A3343924F | 2001-09-01 00:00:00 | 2012-03-01 00:00:00 | 43 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  7211  Employment placement and recruitment service ; |  |  | Original | A2314247W | 1998-09-01 00:00:00 | 2012-03-01 00:00:00 | 55 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  7212 Labour supply services ; |  |  | Original | A2314250K | 1998-09-01 00:00:00 | 2012-03-01 00:00:00 | 55 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  729 Other administrative services ; |  |  | Original | A3343926K | 2001-09-01 00:00:00 | 2012-03-01 00:00:00 | 43 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  7292 Document preparation services ; |  |  | Original | A3343928R | 2001-09-01 00:00:00 | 2012-03-01 00:00:00 | 43 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  7293 Credit reporting and debt collection services ; |  |  | Original | A3343930A | 2001-09-01 00:00:00 | 2012-03-01 00:00:00 | 43 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  7294 Call centre operation ; |  |  | Original | A3343932F | 2001-09-01 00:00:00 | 2012-03-01 00:00:00 | 43 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  7299 Other administrative services n.e.c ; |  |  | Original | A3343934K | 2001-09-01 00:00:00 | 2012-03-01 00:00:00 | 43 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  731 Building cleaning, pest control and gardening services ; |  |  | Original | A3343936R | 2001-09-01 00:00:00 | 2012-03-01 00:00:00 | 43 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  7311 Building and other industrial cleaning services ; |  |  | Original | A2314262V | 1998-09-01 00:00:00 | 2012-03-01 00:00:00 | 55 | Index Numbers | INDEX | Quarter | 3
Index Numbers ;  7312 Building pest control services ; |  |  | Original | A2314259F | 1998-03-01 00:00:00 | 2012-03-01 00:00:00 | 57 | Index Numbers | INDEX | Quarter | 3
© Commonwealth of Australia  2012
Spreadsheet: 35043d1232517405-excel-2007-vlookup-domain-renewal-list-to-excel-tip
Sheet: Renew

domain | Resellers
1000gems
1000gems
1000gems
1cbs
1cfcu
1cfcu
1cfcu
1cfcu
1cfcu
aaahoosier
aaantivirus
AAANTIVIRUS
aaantivirus
aaantivirus
aaantivirus
aaantivirus
aaantivirus
aaantivirus
aaantivirus
aaantivirus
aaantivirus
aaantivirus
aaantivirus
aaantivirus
aaantivirus
aaantivirus
aaantivirus
aaantivirus
aaantivirus
aaantivirus
aaantivirus
AAANTIVIRUS
aaantivirus
aaantivirus
aaantivirus
aaantivirus
AAANTIVIRUS
aaantivirus
AAANTIVIRUS
AAANTIVIRUS
aaantivirus
AAANTIVIRUS
AAANTIVIRUS
AAANTIVIRUS
aaantivirus
aaantivirus
aaantivirus
AAANTIVIRUS
aaantivirus
aaantivirus
AERO-ELECTRIC
AERO-ELECTRIC
AERO-ELECTRIC
AERO-ELECTRIC
AERO-ELECTRIC
AERO-ELECTRIC
AERO-ELECTRIC
AERO-ELECTRIC
Spreadsheet: 53646d1253583407-help-with-autoshapes-and-gantt-charts-example
Sheet: Data

ACTIVITY | Length of Path | Area of Building m2 | Length of Fencing | DESIGN OFFICE NO. |  |  |  | DEPARTMENT/ CLIENT | RESPONSIBILITY CENTRE            (RC) | FOLDER NUMBER | PA NUNBER | STATUS | SUBURB | [NAME] | Planned Construction Start Date | Planned Completion  Date | Duration | Predessor | [NAME] | Project Manager | % Comp $'s Allocated | % INFIELD WORK [NAME] | 2009/10 TOTAL ALLOC. | 2009/10 ORACLE EXPEND @ 21/9/09 | EXP. UNDER/ (OVER) ALLOC. | QUOTED PRICE  $ | APPROVED  EXTRAS INCL P/MAN FEES WHERE APPLICABLE | QTE + EXTRAS JOB TOTAL | PROJECTED FINAL EXP @ Comp | QTE UNDER /(OVER) ALLOC. | Date Updated | COMMENTS ON PROGRESS | Environment | % OF WORKS ISSUED @ | Advised Budget Owner For  Review | BRIEF TO PROJ. | Brief To Design  (R - Date returned to DO for amend) | REQUESTED COMP. DATE - DO TO  CONFIRM | AGREED CONFIRMED DATE DESIGN DUE | AGREED EXTENSION -   DESIGN DUE OR ON HOLD (H) | DO REQ. EXTENSION DATES - NOT AGREED | Due Design Date | DESIGN REC'D BY PROJ. | Tender Checklist Or [NAME] | Tender | MEMO TO  **** FOR QUOTE or ADVERTISE DATE | [NAME]. BY PROJ.  -  AMENDED QTE (A) | **** EST OF DAYS  FOR CST | DATE ISSUED | ACTUAL START CONST. DATE | DUE DATE FOR PRACT. COMP. | Practical Completion Date | Const Maint Period Comp | PA Account Set  Pending Close | WAEX To TRIM | Final Report To TRIM | Bank Guarantee | Warranty to trim | JOB NO. FLAGGED | Added to Matman | Added to PMS | Added to ???
 |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | 1 | Client A | 6021 | F2001/001 | 1111.1.1 | IP | Suburb A | Description A |  |  |  |  |  | P.A |  |  | 20000 |  |  |  |  | 0 |  |  |  |  |  |  |  | 2009-06-10 00:00:00 |  |  |  |  |  |  |  |  | 2009-07-11 00:00:00 |  |  |  | 2009-07-27 00:00:00 |  | 2009-08-31 00:00:00
 |  |  |  |  |  |  |  | Client B | 6022 | F2001/001 | 1111.1.2 | NS | Suburb B | Description B |  |  |  |  |  | P.B |  |  | 10000 |  |  |  |  |  |  |  |  |  |  |  |  | 2009-06-10 00:00:00 |  |  |  |  |  |  |  |  |  | 2009-07-27 00:00:00
 |  |  |  |  |  |  |  | Client C | 6023 | F2001/001 | 1111.1.3 | FIN | Suburb B | Description C |  |  |  |  |  | P.C |  |  | 10000 |  |  |  |  |  |  |  |  |  |  |  |  | 2009-06-10 00:00:00 |  |  |  |  |  |  |  |  | 2009-06-11 00:00:00 |  |  |  | 2009-06-29 00:00:00 | 2009-06-29 00:00:00 | 2009-07-27 00:00:00 | 2009-07-27 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1900-01-01 00:00:00 |  |  |  |  | Total | 40000 | 0 | 0
Spreadsheet: 702455d1604354783-lookup-if-time-between-lookup-shift-1-
Sheet: find shift

lookup table |  |  |  |  | data entry | data entry | calc |  | expected result
area | min | [NAME] | shift |  | area | time | shift
a | 600 | 1800 | 1 |  | b | 0615
b | 620 | 1820 | 1 |  | c | 0630
c | 630 |  | 1 |  | a | 1830
d | 530 |  | 1 |  | d | 1731
e | 550 |  | 1 |  | d | 1200
 |  |  |  |  | e | 1830
if shift (D) not =1, return 3 |  |  |  |  | a | 2200
 |  |  |  |  | c | 0625
 |  |  |  |  | b | 1020
 |  |  |  |  | c | 0815
 |  |  |  |  | e | 1430
 |  |  |  |  |  | if time (G) between min (B) & max ( C)
 |  |  |  |  |  | lookup area (F) from (A)
 |  |  |  |  |  | result (D) in (H)
Spreadsheet: 743383d1628451497-if-win-add-if-loss-substract-journaling
Sheet: Sheet1

 | Pair |  | Direction |  | Entry Date |  | Exit Date |  | SL in Pips |  | Grade |  | Result |  | Gain (USD) |  | Before Screenshoot |  |  |  |  | After Screenshoot |  |  |  |  | Notes
1 | BTC/USDT |  | Short |  |  |  |  |  |  |  | 4 |  | Win |  | 1700
2 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total trades
3 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Wins
4 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Looses
5 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total Profit/Loss
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
Spreadsheet: 827755d1683018073-average-timings-exercise-averages-aligw
Sheet: Snapshot

 |  | 2023
 |  |  | Q1 |  |  | Q2 |  |  | Q3 |  |  | Q4
 |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
 |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Total
 | Average Timings |  |  |  |  |  |  |  |  |  |  |  |  | Yearly Average
 | External | 9 | 5.75 | 9.5 | 8 |  |  |  |  |  |  |  |  | 7.6 |  |  | *I want to calculate the average days between F2 and G2 by month. It is important to ignore if there are blank cells on G2.
 | Cash Received | 17.5 | 10.75 | 19.5 | 4 |  |  |  |  |  |  |  |  | 12.5 |  |  | *I want to calculate the average days between B2 and E2 by month. It is important to ignore if there are blank cells on E2.
 | Letter To Authorities | 6.5 | 12.5 | 3.5 | 8 |  |  |  |  |  |  |  |  | 8.6 |  |  | *I want to calculate the average days between C2 and D2 by month. It is important to ignore if there are blank cells on D2.
 | Authorities Response
 | [NAME] | 10 | - | 2 | - |  |  |  |  |  |  |  |  | 6 |  |  | *I want to calculate the average days between B2 and D2 by month and by category (Column A). It is important to ignore if there are blank cells on D2.
 | Lim | 3 | - | 5 | - |  |  |  |  |  |  |  |  | 4 |  |  | I also want to calculate the total average timings for each category on a yearly basis.
 | Paf | - | 4 | - | 13 |  |  |  |  |  |  |  |  | 8.5
 | Lar | - | 24 | - | 3 |  |  |  |  |  |  |  |  | 13.5
 | Amm | 11 | - | - | - |  |  |  |  |  |  |  |  | 11
Spreadsheet: 134486d1325328284-how-to-create-formula-index-refer-on-refference-table-book2
Sheet: Sheet1

 |  |  |  |  |  |  | Refference
 | BEFORE |  | AFTER |  |  |  | BIL | BEFORE | BIL | AFTER |  | GRED
 | Pereka | B41/42 | Pereka | B1-1 |  |  |  |  |  |  |  | 1-1 | 1-2 | 1-3 | 1-4 | 1-5 | 1-6
 | [NAME] (J) | J41/42 | [NAME] Kemahiran | DL1-1 |  |  | KLASIFIKASI PERKHIDMATAN BAKAT DAN SENI (B)
 |  |  |  |  |  |  | 1 | Pereka | 1 | Pereka | B | B41/42 | B43/44 |  | B47/48 | [NAME] | B53/54
 |  |  |  |  |  |  | KLASIFIKASI PERKHIDMATAN PENDIDIKAN (D)
 |  |  |  |  |  |  | 1 | [NAME] Pendidikan Siswazah | 1 | [NAME] | D | DG41 | DG44 |  | DG48 | DG52 | DG54
 |  |  |  |  |  |  | 2 | [NAME] | 2 | [NAME] | DG | DG41 | DG44 |  | DG48 | DG52
 |  |  |  |  |  |  | 3 | [NAME] (J) | 3 | [NAME] Kemahiran | DL | J41/42 | [NAME] |  | [NAME] | J51/52 | [NAME]
Spreadsheet: 01589a02-f7d7-44ac-a18c-8f93e6e054c7
Sheet: Sheet1

This form will be e-mailed to the |  |  |  | Recognition Levels |  |  |  | Patron                  $20.00 - $39.99 per pay
coordinators. |  |  |  | Per Pay | One Time |  | Recognition Item | or 1-time equiv.$520.00 - $1,039.99
 |  |  |  |  | Equivalent |  |  | Humanitarian       $40.00 - $59.99 per pay
Completed form should be |  | 2011 State of Ohio |  | $5- $9.99 | $130-$259.99 |  | Sticky pad | or 1-time equiv. $1,040.00 - $1,559.99
e-mailed to: [EMAIL] |  |  |  | $10- $19.99 | $260-$519.99 |  | Note pad | Benefactor            $60.00 - $79.99 per pay
 |  | Combined Charitable Campaign |  | $20-$39.99 | $520-$1039.99 |  | Writing pad-Med | or 1-time equiv. $1,560.0 - $2,079.99
Recognition items will be distributed from these completed lists only.  Without a name, recognition items will not be processed. |  |  |  | $40.00 + | $1040 + |  | Writing pad-Large | Philanthropist            $80.00  - up per pay
 |  | Donor Recognition / Leadership Tracking |  |  |  |  |  | or 1-time equiv. $2,080.00 +
 |  |  |  | Recognition / Leadership Levels (mark with an "x")
Agency | Department / Location | Last Name | First Name          (not initial) | $5-$9/pay $130-$259 | $10-$19/pay $260-$519 |  | Patron            $20-$39/pay $520-$1,039 | Humanitarian $40-$59/pay $1,040-$1,559 | Benefactor  $60-$79/pay $1,560-$2,079 | Philanthropist  $80 +/pay $2,080 + | Wants no gift | Anonymous
Rehab & Correction | MaCI | Washington | George | x
Mental Health |  | Adams | [NAME] |  |  |  |  | x |  |  | x
Transportation | Dist. 2 | [NAME] | [NAME] |  |  |  | x |  |  |  |  | x
Transportation | Dist. 10 | Lincoln | [NAME] |  | x |  |  |  |  |  | x | x
Spreadsheet: 816383d1675563559-compare-tables-and-conditional-format-duplicates-row-by-row-compare-tables-for-duplicates
Sheet: Sheet1

20 | 39 | 31 | 9 | 22 |  | 19 | 20 | 31 | 9 | 22 | 23
14 | 19 | 5 | 4 | 21 |  | 15 | 19 | 4 | 5 | 21 | 10
16 | 17 | 34 | 10 | 27 |  | 15 | 16 | 20 | 17 | 34 | 27
12 | 12 | 35 | 3 | 26 |  | 15 | 3 | 35 | 49 | 26 | 12