tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 216b5582-e0fa-4d61-a484-83297a184095
Sheet: SF-424A (22)

Applicant Name: |  |  |  | Award Number:
Budget Information - Non Construction Programs
OMB Approval No. 0348-0044
Section A - Budget Summary
 | Grant Program Function or Activity | Catalog of Federal Domestic Assistance Number | Estimated Unobligated Funds |  | New or Revised Budget
 |  |  | Federal | Non-Federal | Federal | Non-Federal | Total
 | (a) | (b) | (c ) | (d) | (e) | (f) | (g)
1. | Previous Projects | 10.17
2.
3.
4.
5. | Totals
Section B - Budget Categories
6. | Object Class Categories |  | Grant Program, Function or Activity |  |  |  | Total (5)
 |  |  | Previous Projects | (65) | (66) | (67)
 | [NAME]
 | [NAME]
 | c.  Travel
 | d.  Equipment
 | e.  Supplies
 | f.  Contractual
 | g.  Construction
 | h.  Other
 | i.  Total Direct Charges (sum of 6a-6h)
 | j.  Indirect Charges
 | k.  Totals (sum of 6i-6j)
7. | Program Income
 |  |  |  |  |  |  | SF-424A (Rev. 4-92)
Previous Edition Usable |  |  |  |  |  | Prescribed by OMB Circular A-102
Authorized for Local Reproduction
Section C - Non-Federal Resources
 | (a) Grant Program |  |  | (b) Applicant | (c ) State | (d) Other Sources | (e) Totals
8.
9.
10.
11.
12. | Total (sum of lines 8 - 11)
Section D - Forecasted Cash Needs
 |  |  | Total for 1st Year | 1st Quarter | 2nd Quarter | 3rd Quarter | 4th quarter
13. | Federal
14. | Non-Federal
15. | Total (sum of lines 13 and 14)
Section E - Budget Estimates of Federal Funds Needed for Balance of the Project
(a) Grant Program |  |  |  | Future Funding Periods (Years)
 |  |  |  | (b) First | (c ) Second | (d) Third | (e) Fourth
16.
17.
18.
19.
20. | Total (sum of lines 16-19)
Section F - Other Budget Information
21. Direct Charges |  |  |  | 22. Indirect Charges
23.  [NAME]
 |  |  |  |  |  |  | SF-424A (Rev. 4-92)
Previous Edition Usable |  |  |  |  |  |  | Prescribed by OMB Circular A-102
 |  | Authorized for Local Reproduction
Spreadsheet: 156797d1337469004-using-large-small-when-same-values-exist-drafttest
Sheet: Sheet

ID | Name | Rank |  |  |  | Picked? | Height | Height | Lbs | Age | Exp |  | Highest rank unpicked players? |  |  |  | Tallest unpicked players?
2 | [NAME] | 16 |  |  |  | yes | 5' 10' | 5.833333333333333 | 180 | 24.24657534246575 | 8 |  | ID | Name | Rank |  | ID | Name | Height
3 | [NAME] | 16 |  |  |  | yes | 6' 2' | 6.166666666666667 | 175 | 35.04657534246575 | 17
4 | [NAME] | 15 |  |  |  | NO | 6' 5' | 6.416666666666667 | 200 | 41.88219178082192 | 14
5 | [NAME] | 15 |  |  |  | NO | 5' 11' | 5.916666666666667 | 160 | 25.64109589041096 | 8
6 | [NAME] | 15 |  |  |  | NO | 5' 10' | 5.833333333333333 | 160 | 36.13424657534247 | 14
7 | [NAME] | 15 |  |  |  | NO | 5' 11' | 5.916666666666667 | 175 | 27.44931506849315 | 8 |  | Youngest unpicked players? |  |  |  | Most experienced unpicked players?
8 | Greg | 15 |  |  |  | NO | 6' 1' | 6.083333333333333 | 175 | 26.07123287671233 | 4 |  | ID | Name | Age |  | ID | Name | Exp
9 | Zack | 14 |  |  |  | NO | 6' 5' | 6.416666666666667 | 140 | 27.85753424657534 | 9
10 | [NAME] | 14 |  |  |  | NO | 6' 0' | 6 | 190 | 45.42465753424658 | 15
 |  |  |  |  |  |  |  |  |  |  |  |  | Youngest is the only one that works because the values are actually different.
 |  |  |  |  |  |  |  |  |  |  |  |  | It works because the ages are not the same, they're rounded.
 |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] is really 25.6 and [NAME] is 26, which is why it works.
 |  |  |  |  |  |  |  |  |  |  |  |  | When the values are exactly the same, like Rank and Height and Experience, the ID formula grabs the 1st value then doesn't exclude it
 |  |  |  |  |  |  |  |  |  |  |  |  | If there are three players ranked 15 that haven't been picked, is there a way to exclude the same ID for appearing more than once?
Spreadsheet: 861486d1709360131-i-need-a-formula-that-will-capture-2-functions-to-calculate-normal-and-overtime-hours-show-adoc-rdoc-as-zero_excel-forum
Sheet: Work Calculator

DAY | SHIFT PENALTY/EXTRA ADD-ONS |  | BALANCE OF TIME DUE FOR PAYMENT | DEFAULT HOURS PAID AT NORMAL RATE | HOURS PAID AT 150% | HOURS PAID AT 200% | TIME WORKED SPREAD HOURS |  | THE FORMULA PROBLEM THAT I REQURE HELP WITH
 | ADD-ON #1
 |  |  |  |  |  |  | 0 |  | 8.25 |  |  |  |  |  |  |  | RDOC
Monday | RDOC |  | 8.75 |  |  |  |  |  | FUNCTION 1. If 'RDOC' or 'ADOC'  is entered in Column B, I want to show columns E, F, and G as zero (0) |  |  |  |  |  |  |  | ADOC
Tuesday | ADOC |  | 11.5 |  |  |  |  |  |  | ` |  |  |  |  |  |  | Nil
Wednesday | Nil |  | 8.89 |  |  |  |  |  | FUNCTION 2. Conversly, if 'Nil' is entered in Column B, I want to show these calculations in columns E, F, and G
Thursday | Nil |  | 7.9
Friday | Nil |  | 12 |  |  |  |  |  | I NEED A FORMULA THAT CAN COMBINE FUNCTION 1. AND FUNCTION 2. SO WHEN EITHER 'Nil' or "ADOC' or 'RDOC' is ENTERED THIS IS THE RESULT
Saturday | RDOC |  | 8.25 | 0 | 0 | 0
Sunday | ADOC |  | 8.25 | 0 | 0 | 0
 | ADOC
 | RDOC
 | Nil
Spreadsheet: 852109d1702205322-excel-formula-to-extract-data-from-salary-sheet-to-payslip-match-payslip
Sheet: Payslip

 | Kindly asking for excel formula to extract data on the salary sheet to the Payslip sheet as
 | shown below. Where there is no amount the formula should leave out the naration e.g. Pension
 | on Doroth salary there is zero and pension is not included in the payslip. Thank you.
 | NB Select month and Employee name from the drop down list
 | Desired solution
 | PAYSLIP
 | 2023-12-10 00:00:00
 | Month | February
 | Employee Name | [NAME]
 | Eearnings | USD | ZWL |  |  | Deductions | USD | ZWL
 |  | 200 | 490000 |  |  |  | 45
 | Over time |  | 150000 |  |  | NEC | 90
 | Benefits |  | 90000 |  |  | PAYE | 17.68541562689119 | 63044.72402642548
 | Bonus |  | 300000 |  |  | Aids Levy | 0.5305624688067355 | 1891.341720792764
 |  |  |  |  |  | Net Pay | 46.78402190430205 | 965063.9342527818
 | Total |  |  |  |  | Total
Spreadsheet: 149349d1333870863-formula-to-give-a-list-of-options-accident-list
Sheet: Impact 

Direct Causes | Impact Direct Causes
3rd party action | External Factors, 3rd Party, [NAME]
Asphyxiation | Unsafe Conditions
Collision | Land Transport
Corrosion/erosion | Inadequate/Failure of equipment/Tools
Crushing | Unsafe Conditions
Drowning | Water Transport
Electrocution | Electrical
Excessive noise/vibration | Inadequate/Failure of equipment/Tools
Failed to activate warning/safety devices | Failure to use warning/safety devices
Failed to follow rules/procedures/permit etc | Failure to Follow Rules/Procedures
Failed to instruct or inform | Failure to Follow Rules/Procedures
Failed to intervene | Failure to Follow Rules/Procedures
Failed to monitor | Failure to Follow Rules/Procedures
Failed to observe warning/safety devices | Failure to use warning/safety devices
Failed to plan | Failure to Follow Rules/Procedures
Failed to secure equipment | Falling Objects
Falling or moving objects | Falling Objects
Fire and Explosion Hazard | Fire or Explosion
Hazardous substance | Unsafe Conditions
Horseplay | Failure to Follow Rules/Procedures
Hot or cold burn | Unsafe Conditions
Impact of Animals | External Factors, 3rd Party, [NAME]
Impact of extreme [NAME] | External Factors, 3rd Party, [NAME]
Improper manual lifting/handling practice | Improper Manual Handling
Infection | Unsafe Conditions
Intoxication | Influence of alcohol/drugs
Left area untidy | Poor Housekeeping
Making safety devices inoperative | Failure to use warning/safety devices
Misused or wrongly used tools | Inadequate/Failure of equipment/Tools
Not used PPE or used PPE incorrectly | Failure to wear PPE
Operated or Worked at unsafe speed | Failure to Follow Rules/Procedures
Operated or Worked without authority/permission | Failure to Follow Rules/Procedures
Performed Inadequate pre-task checking | Failure to Follow Rules/Procedures
Poisoning | Unsafe Conditions
Pressure release | Unsafe Conditions
Proscecution | Complaint
Public Complaint | Complaint
Radiation | Radiation
Repetitive unhealthy position or posture | Work Environment
Single vehicle accident | Land Transport
Spill or release to the environment | Accidental Release
Stress | Work Environment
Struck or caught by moving object | Lifting/Crane operations
Structural or equipment failure | Inadequate/Failure of equipment/Tools
Taking unsafe position or posture | Improper Manual Handling
Took short cuts | Failure to Follow Rules/Procedures
tool or equipment failure | Inadequate/Failure of equipment/Tools
Trip or fall | Slips/Trips/Falls
Used unsafe/defective equipment | Inadequate/Failure of equipment/Tools
Worked in hazardous atmosphere | Work Environment
Worked in hot/humid/oppressive conditions | Work Environment
Worked in inadequate light/visibility | Work Environment
Worked in untidy area | Poor Housekeeping
Worked on live equipment | Failure to observe recognized Hazards
 | Air Transport
 | Assault
 | Not Provided
Other | Other
Spreadsheet: 835976d1689006756-summary-across-multiple-sheets-and-reference-list-excel-linup-help-game-lineup-2023-07-07
Sheet: G3 - 1 - Sycamore

Date: |  | 2023-07-09 00:00:00 |  |  | Field: | 5 |  | Start Time: |  | 13:00:00
Home: |  | SYB 8U All Star Black |  |  | 3rd | Set Up
Visitors: |  | SYB 8U All Star Gold |  |  | 1st | Clean Up
 |  |  |  |  | Inning
 |  | Player |  |  | Coach Pitch |  |  |  |  |  | Innings on Bench | Innings in Infield | Inninings in Outfield |  | [NAME]
Order |  | First | Last | # | 1 | 2 | 3 | 4 | 5 | 6 |  |  |  |  | First Name | Last Name | Number
1 | 12 | Player | One | 1 | LCF | LCF | LCF | SS | SS | SS |  |  |  |  | Player | One | 1
2 | 11 | Player | Two | 2 | SS | SS | SS | LF | LF | LF |  |  |  |  | Player | Two | 2
3 | 1 | Player | Three | 3 | 1B | 1B | 1B | LCF | LCF | LCF |  |  |  |  | Player | Three | 3
4 | 2 | Player | Four | 4 | X | X | P | 1B | 1B | 1B |  |  |  |  | Player | Four | 4
5 | 4 | Player | Five | 5 | LF | LF | LF | 2B | 2B | 2B |  |  |  |  | Player | Five | 5
6 | 5 | Player | Six | 6 | 2B | 2B | 2B | RCF | RCF | RCF |  |  |  |  | Player | Six | 6
7 | 10 | Player | Seven | 7 | 3B | 3B | 3B | RF | RF | RF |  |  |  |  | Player | Seven | 7
8 | 9 | Player | Eight | 8 | RF | RF | RF | P | C | C |  |  |  |  | Player | Eight | 8
9 | 6 | Player | Nine | 9 | RCF | RCF | RCF | 3B | 3B | 3B |  |  |  |  | Player | Nine | 9
10 | 7 | Player | Ten | 10 | C | C | X | X | P | P |  |  |  |  | Player | Ten | 10
11 | 8 | Player | Eleven | 11 | P | P | C | C | X | X |  |  |  |  | Player | Eleven | 11
Out
 | 9
 | 9
Notes:
 |  |  |  | Players on [NAME]
Spreadsheet: 1fef310d-6ef7-4c1e-82c3-d09e2f69a5b4
Sheet: Sheet1

CENTRAL STORES | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
[NAME]
Date: |  |  |  |  | Signed:
Account Name: |  |  |  |  |  | Budget Officer Signature
Building: |  |  |  |  | Account No.:
Room No. |  | Extension: |  |  | Requester:
QUANTITY | UNIT | LINE ITEM | [NAME] |  | OBJ. CODE | TAX ON ITEMS? (Y/N) | UNIT  PRICE | EXT.  TOTAL
 |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  |  | 0 | 0
 |  |  |  |  |  |  | Subtotal: | 0 | 0
 |  |  |  |  |  |  | Sales Tax: | 0
 |  |  |  |  |  |  | Total: | 0
*FOR CENTRAL STORES ONLY*
Invoice No:
Comments:
Spreadsheet: 814942d1674665083-pull-data-based-on-column-a-report-builder-sample
Sheet: Step 7

 | Program (Optional) | Agency  Internal ID # (Optional) | Minor's Last Name | Minor's First Name | M I | Date of Birth | Probation  Case # | Formal or Informal Probation↓ | Street  Address  & Apt. # | City | Zip Code | Gender ↓ | Ethnicity ↓ | Referral Source ↓ | Service Type ↓ | Living Situation ↓ | Parenting Status ↓ | Health Insurance Type ↓ | Date of Referral/ Mediation Meeting | Date of  First Contact | Date of First Service | Closing Date | Current Service Month | Current Service Year
FORMULA HERE
Spreadsheet: 697183d1601233207-formula-to-find-lowest-time-n-2-groups-then-the-difference-between-them-ignoring-sample-data-1
Sheet: Sheet1

 |  |  |  |  |  |  |  | F | G | H | I
 |  |  |  |  |  |  |  | amb | fire | amb | fire | F/G | H/I | Result
 |  |  |  |  |  |  |  | 23:15:09 | 23:19:18 | 23:00:00 | 23:20:00
 |  |  |  |  |  |  |  | 23:19:18 | 23:15:09 | 23:20:00 | 23:00:00
 |  |  |  |  |  |  |  | 23:19:18 | 23:15:09 | 0 | 23:00:00
 |  |  |  |  |  |  |  | 23:19:18 | 23:15:09 | 23:20:00 | 0
Spreadsheet: andy_zipper__449__11_16_01LO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | CL Z1 | EXP |  |  | 61.2 | 72.3 | 0.9 | 2001-11-13 14:31:00
 | CL F2 | 18 | 270 | 285 | 68.1 | 71.9 | 0.79 | 2001-11-16 10:49:00
 | CL G2 | 18 | 365 | 380 | 62.7 | 65.3 | 0.72 | 2001-11-16 10:49:00
 | CL H2 | 18.5 | 420 | 440 | 58.1 | 60.8 | 0.69 | 2001-11-16 10:49:00
 | CL J2 | 18.5 | 460 | 480 | 55.5 | 58 | 0.66 | 2001-11-16 10:49:00
 | CL K2 | 18.5 | 495 | 515 | 53.1 | 55.3 | 0.63 | 2001-11-16 10:49:00
 | CL M2 | 19 | 535 | 555 | 51.5 | 53.4 | 0.63 | 2001-11-16 10:49:00
 | CL N2 | 19 | 545 | 560 | 48.5 | 49.9 | 0.59 | 2001-11-16 10:49:00
 | CL Q2 | 19 | 555 | 580 | 46.4 | 48.5 | 0.57 | 2001-11-16 10:49:00
 | CL U2 | 19 | 560 | 585 | 44.5 | 46.5 | 0.54 | 2001-11-16 10:49:00
 | [NAME] | 19 | 560 | 585 | 42.2 | 44.1 | 0.52 | 2001-11-16 10:49:00
 | CL X2 | 19 | 560 | 595 | 40.4 | 42.9 | 0.5 | 2001-11-16 10:49:00
 | [NAME] | 19.5 | 560 | 600 | 38 | 40.7 | 0.48 | 2001-11-16 10:49:00
 | CL M3 | 20 | 560 | 600 | 31.1 | 33.3 | 0.4 | 2001-11-16 10:49:00
 | CL Z3 | 20.5 | 550 | 610 | 26.4 | 29.3 | 0.36 | 2001-11-16 10:49:00
Spreadsheet: 739323d1625648192-countif-with-subtotal-2021_-external-nc-database
Sheet: Closure

Status | Count | Closure
February | 13
Closed | 4
Open | 9
March | 3 | 1
Closed | 3
April | 15
Closed | 11
Open | 4
May | 5
Closed | 1
Open | 4
June | 10
Closed | 4
Open | 6
Grand Total | 46
Spreadsheet: 211593d1359829622-ref-message-question-workbook2
Sheet: Sheet1

 | 2013-03-01 00:00:00 | 2013-04-01 00:00:00 | 2013-05-01 00:00:00 | 2013-06-01 00:00:00 | 2013-07-01 00:00:00 | 2013-08-01 00:00:00 | 2013-09-01 00:00:00 | 2013-10-01 00:00:00 | 2013-11-01 00:00:00 | 2013-12-01 00:00:00 | 2014-01-01 00:00:00 | 2014-02-01 00:00:00 | 2014-03-01 00:00:00 | 2014-04-01 00:00:00 | 2014-05-01 00:00:00 | 2014-06-01 00:00:00 | 2014-07-01 00:00:00 | 2014-08-01 00:00:00 | 2014-09-01 00:00:00 | 2014-10-01 00:00:00 | 2014-11-01 00:00:00 | 2014-12-01 00:00:00 | 2015-01-01 00:00:00 | 2015-02-01 00:00:00 | 2015-03-01 00:00:00 | 2015-04-01 00:00:00 | 2015-05-01 00:00:00 | 2015-06-01 00:00:00 | 2015-07-01 00:00:00 | 2015-08-01 00:00:00 | 2015-09-01 00:00:00 | 2015-10-01 00:00:00 | 2015-11-01 00:00:00 | 2015-12-01 00:00:00 | 2016-01-01 00:00:00
Settlement Origination
Settlement Originaion Fees
Interest Rate paid by Client
Interest Expense
Operational Expense
Settlement Returned
Profit | 0
Cash Outlay
Assumptions
Year One Revenue | 1200000
Year Two Revenue | 2000000
Interest Rate on Settlements | 0.18
Settlement Return (Avg Months) | 12
Loss Factor | 0.03
Interest Cost | 0.13
Spreadsheet: john_griffith__15747__10_16_01GO
Sheet: Sheet1

 |  |  | SCS  OPTION  DATA
 | TICKER | STRIKE | STR BID | STR ASK | B VOL | A VOL | M STD/DAY | WHEN
 | [NAME] | 59 | 300 | 400 | 38.5 | 51.4 | 1.67 | 2001-10-16 10:25:00
 | [NAME] | 61 | 675 | 775 | 41.1 | 47.2 | 1.69 | 2001-10-16 10:25:00
 | HU F2 | 61 | 825 | 925 | 38.7 | 43.5 | 1.58 | 2001-10-16 10:25:00
 | HU G2 | 62 | 1000 | 1100 | 38.3 | 42.2 | 1.57 | 2001-10-16 10:25:00
 | [NAME] | 63 | 1110 | 1210 | 37.3 | 40.7 | 1.54 | 2001-10-16 10:25:00
 | [NAME] | 70 | 1325 | 1450 | 36.5 | 40 | 1.68 | 2001-10-16 10:25:00
 | [NAME] | 70 | 1400 | 1550 | 35.5 | 39.4 | 1.65 | 2001-10-16 10:25:00
 | [NAME] | 70 | 1400 | 1600 | 32.9 | 37.6 | 1.55 | 2001-10-16 10:25:00
 | HU N2 |  |  |  | 34.7 | 38.1 | 1.58 | 2001-10-12 14:55:00
 | [NAME] |  |  |  | 28.9 | 34.2 | 1.39 | 2001-10-04 14:29:00
 | HU U2 |  |  |  |  |  | 0.05 | 2001-09-06 10:39:00
 | [NAME] |  |  |  |  |  | 1.26 | 2001-08-20 15:44:00
 | [NAME]
 | [NAME]
 | HU F3 |  |  |  |  |  | 0.56 | 2001-07-19 17:15:00
 | [NAME]
Spreadsheet: 172179d1344014786-excel-2003-formula-for-assigning-a-1-0-1-depending-on-a-change-column-excel-rating-formula
Sheet: What I Want It to Look Like

Name | Supervisor | Data Month | Calls Handled | % Change | Positive/Neutral/Negative Rating
SMITH, BOB | [NAME] | 2012-01 | 686 | 0.5145772594752187
SMITH, BOB | [NAME] | 2012-02 | 1039 | 0.1299326275264678 | +1
SMITH, BOB | [NAME] | 2012-03 | 1174 | -0.3100511073253833 | 0
SMITH, BOB | [NAME] | 2012-04 | 810 | -0.2975308641975309 | -1
SMITH, BOB | [NAME] | 2012-05 | 569 | -0.008787346221441126 | -1
SMITH, BOB | [NAME] | 2012-06 | 564 | 564 | 0
QUAN, MICHELLE | [NAME] | 2012-01 | 503 | 0.1113320079522863
QUAN, MICHELLE | [NAME] | 2012-02 | 559 | 0.5742397137745975 | 0
QUAN, MICHELLE | [NAME] | 2012-03 | 880 | 0.1329545454545455 | +1
QUAN, MICHELLE | [NAME] | 2012-04 | 997 | -0.238716148445336 | 0
QUAN, MICHELLE | [NAME] | 2012-05 | 759 | 0.1409749670619236 | -1
QUAN, MICHELLE | [NAME] | 2012-06 | 866 | 866 | 0
 |  |  |  |  |  |  | Criteria: If % change from the old month to the new month is between +17% and -17% then the Rating Cell for the new month = 0                                         If % change is greater than +17% then Rating cell=+1                                                                         If% change is less than - 17% then Rating cell=-1
Spreadsheet: 265967d1379449225-problem-with-a-sum-of-exported-data-from-another-program-exported-data
Sheet: Arkusz1

 |  | 0
 |  | 0
 |  | 1.82-
 |  | 6.96-
 |  | 14.13-
 |  | 222.82- |  | as you can see those are not numbers, but text that is exported..
 |  | 788.44-
 |  | 0
 |  | 0
 |  | 2.97-
 |  | 5.42-
 |  | 2.99-
 |  | 3.07-
 |  | 7.56-
 |  | 7.95-
 |  | 15.44-
 |  | 18.63-
 |  | 25.84-
 |  | 36.89-
 |  | 40.54-
 |  | 14.70-
 |  | 22.82-
 |  | 6.30-
 |  | 6.30-
 |  | 0
Spreadsheet: 175769d1345643929-average-results-of-vlookup-book2
Sheet: Sheet1

 |  | Normally I would just lookup the points values attached to the levels  and then average the points at the bottom of the table. |  |  |  |  | What I would like to do is just to average the points of the levels without having to have an extra column with the vlookups in.
 |  | English Level | Points |  |  |  | English Level |  |  |  |  | Lookup Values
 |  | 4 | 27 |  |  |  | 4 |  |  |  |  | Level | Points
 |  | 6 | 39 |  |  |  | 6 |  |  |  |  | 1 | 9
 |  | 5 | 33 |  |  |  | 5 |  |  |  |  | 2 | 15
 |  |  |  |  |  |  |  |  |  |  |  | 3 | 21
 |  | 2 | 15 |  |  |  | 2 |  |  |  |  | 4 | 27
 |  | 5 | 33 |  |  |  | 5 |  |  |  |  | 5 | 33
 |  |  |  |  |  |  |  |  |  |  |  | 6 | 39
 |  | B | 15 |  |  |  | B |  |  |  |  | 7 | 45
 |  |  |  |  |  |  |  |  |  |  |  | W | 3
 |  | 6 | 39 |  |  |  | 6 |  |  |  |  | A | 0
 |  | 5 | 33 |  |  |  | 5 |  |  |  |  | B | 15
 |  | 4 | 27 |  |  |  | 4
 |  | 4 | 27 |  |  |  | 4
 |  | W | 3 |  |  |  | W
 |  | 4 | 27 |  |  |  | 4
 |  | 4 | 27 |  |  |  | 4
 |  | 5 | 33 |  |  |  | 5
 |  |  | 27
Spreadsheet: 621182d1556022934-returning-yes-no-results-from-multiple-sheets-volunteer-tracking-test-3-
Sheet: Tournament

Wrestlers  Name | Food Items Donated | [NAME] | Amount Earned
Jeremy | 1 | 1
Spreadsheet: 794880d1662378235-absence-trackershowing-extra-days-in-some-months-how-to-fix-employee-absence-tracker
Sheet: July Abs Data

 |  |  | PLEASE NOTE:  The start day is the first day of leave/sickness and the end date is the last day of leave/sickness and NOT the day that they retun to work
 | Employee Name | Start Date | End Date | Type of Leave | Reason for Sickness Absence | Other reasons for Leave Of Absence | Days | Self Cert Completed | Teaching / Non Teaching | Continued absence from previous month? | Has a Doctors Note been submitted? | Doctors Note Start | Doctors Note End | Is the [NAME] ongoing at the end of the month
 | Employee 1 | 2022-12-22 00:00:00 | 2022-12-30 00:00:00 | Sickness Absence | Heart (Pressure, Circulation etc)
 | Employee 1 | 2022-08-03 00:00:00 | 2022-08-05 00:00:00 | Sickness Absence | Mental Health (Stress / Anxiety etc)
 | Employee 1 | 2022-08-10 00:00:00 | 2022-08-12 00:00:00 | Sickness Absence | Back / Neck
 | Employee 1 | 2022-08-17 00:00:00 | 2022-08-19 00:00:00 | Dependant Care Paid
 | Employee 1 | 2022-08-24 00:00:00 | 2022-08-26 00:00:00 | Compassionate Paid
 | Employee 1 | 2022-12-22 00:00:00 | 2022-12-29 00:00:00 | Leave of Absence Paid |  | Fertility
 | Employee 1 | 2022-03-03 00:00:00 | 2022-03-10 00:00:00 | Leave of Absence Unpaid |  | Study Leave
 | Employee 1 | 2022-05-05 00:00:00 | 2022-05-15 00:00:00 | Dependant Care Unpaid
 | Employee 1
 | Employee 1
Spreadsheet: 5c331dee-fcae-4be6-9936-72fe2762dcc2
Sheet: Cash Transmittal Form

 |  |  |  | Cash Transmittal Form
 |  |  |  | [NAME] your data in these cells
 |  |  |  | Formula Driven Cells - Formula will automatically calculate
 |  |  |  | See comment boxes for form instructions
 | TRANSMITTAL CODE: | TRANSMITTAL NUMBER: |  |  |  |  |  | Amount:
 |  |  |  | FOAPAL(S):
DATE:
BY:
 |  |  |  |  | Total Amount:
FOR:
 |  |  |  | FROM:
Transmittal Amounts
Currency
Coin
Subtotal Cash
Checks
Total Transmittal:
CURRENCY |  |  |  | COIN
[NAME] | Number of Bills | Amount |  | Coin | Number of Coins | Amount
100 |  |  |  | DOLLARS
50 |  |  |  | [NAME]
20 |  |  |  | QUARTERS
10 |  |  |  | DIMES
5 |  |  |  | NICKELS
2 |  |  |  | PENNIES
1 |  |  |  | TOTAL:
TOTAL:
CHECKS
Check # | Name/ID |  |  | Amount | Check # | Name/ID |  | Amount
 |  |  |  |  | Column Subtotal
Column Subtotal |  |  |  |  | Transmittal Total
Spreadsheet: f706f3cd-1838-4790-a3b2-693088ab4d4c
Sheet: Sheet1

Reporting School: | Kankakee Valley | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Date: | 2010-02-19 00:00:00 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11 | Unnamed: 12 | Unnamed: 13 | Unnamed: 14 | Unnamed: 15 | Unnamed: 16
Overall Record:
Conference Record:
School | 1st | 2nd | 3rd | 4th | OT | Final
Kankakee Valley | 8 | 11 | 16 | 17
Griffith | 12 | 24 | 19 | 14
Add. Stats
 |  |  |  |  |  |  | Total | Offensive | Defensive | Total |  |  | Blocked
Player | 2PA | 2PM | 3PA | 3PM | FTA | FTM | Points | Rebounds | Rebounds | Rebounds | Assists | Steals | Shots | TO | Fouls | #GM
Zach Overby | 1 | 1 | 0 | 0 | 2 | 2 | 4 | 1 | 1 | 2 | 3 | 0 | 0 | 4 | 0 | 18
Brad Leegwater | 1 | 1 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 0 | 18
[NAME] | 5 | 2 | 1 | 0 | 0 | 0 | 4 | 1 | 2 | 3 | 0 | 0 | 0 | 1 | 1 | 18
Zach DeFries | 7 | 3 | 0 | 0 | 6 | 4 | 10 | 0 | 1 | 1 | 3 | 0 | 0 | 4 | 1 | 18
[NAME] Dahm | 3 | 1 | 0 | 0 | 0 | 0 | 2 | 0 | 3 | 3 | 0 | 0 | 0 | 1 | 5 | 18
[NAME] | 6 | 1 | 2 | 1 | 0 | 0 | 5 | 0 | 4 | 4 | 5 | 0 | 2 | 4 | 3 | 18
[NAME] | 14 | 9 | 0 | 0 | 2 | 1 | 19 | 2 | 4 | 6 | 2 | 0 | 0 | 0 | 3 | 18
[NAME] | DNP |  |  |  |  |  | 0 |  |  | 0 |  |  |  |  |  | 18
[NAME] | 4 | 2 | 0 | 0 | 0 | 0 | 4 | 0 | 1 | 1 | 0 | 0 | 0 | 1 | 3 | 18
[NAME] | 1 | 1 | 0 | 0 | 0 | 0 | 2 | 0 | 0 | 0 | 1 | 0 | 0 | 0 | 0 | 18
[NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1 | 1 | 0 | 0 | 0 | 0 | 0 | 18
Brent VanSoest | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 18
 |  |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  | 0 |  |  | 0
 |  |  |  |  |  |  | 0 |  |  | 0