tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 697167d1601227732-index-match-formula-from-sales-data-worksheet-to-receivable-worksheet-index-match-formula
Sheet: RECEIVABLES

I am kindly asking for a formula which can match date, invoice number, payment terms and Amount including VAT from SALES DATA.  Please note that invoice 6008 has two transactions.
All these figures should be linked to customer code number Cell B8 "C006"
 | DESIRED OUTCOME
 | Date | Invoice | Payment Terms | Dr | Cr
 | C006 | PANASHE
 | 2020-01-01 00:00:00 | 6000 | 5 | 11270 | 0
 | 2020-03-09 00:00:00 | 6008 | 10 | 41745 | 0
Spreadsheet: 803704d1667630350-sumproduct-indirect-reference-workbook-copy-1-copy
Sheet: 2022

SBP | DBP | Age | Past history | HbA1C
135 | 85 | 15 | Yes | 4
136 | 86 | 16 | No | 5
137 | 87 | 17 | Yes | 6
138 | 88 | 18 | No | 7
139 | 89 | 19 | Yes | 8
140 | 90 | 20 | No | 9
141 | 91 | 21 | Yes | 10
142 | 92 | 22 | No | 11
143 | 93 | 23 | Yes | 12
Spreadsheet: 02c2db6f-facc-4d52-8b8f-f3df8a00640a
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Time Series Workbook
 | 5671.0 Lending Finance, Australia
 | TABLE 27. LEASE FINANCE COMMITMENTS, Summary:Australia ($000)
Related Information: | Summary Publication | Explanatory Notes | Inquiries
 | Glossary
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Total lease finance commitments ; |  |  | Original | A2414208C | 1975-10-01 00:00:00 | 2011-06-01 00:00:00 | 429 | $'000 | FLOW | Month | 1
Total lease finance commitments ; |  |  | Seasonally Adjusted | A2414207A | 1975-10-01 00:00:00 | 2011-06-01 00:00:00 | 429 | $'000 | FLOW | Month | 1
Total lease finance commitments ; |  |  | Trend | A2414206X | 1975-10-01 00:00:00 | 2011-06-01 00:00:00 | 429 | $'000 | FLOW | Month | 1
© Commonwealth of Australia  2011
Spreadsheet: 137577d1327236234-excel-2007-picking-a-value-based-on-criteria-of-two-different-columons-picking-a-value-based-on-multiple-criteria
Sheet: Sheet1

Class | Student | Grade
One | s1 | A |  |  | one | s2
One | s2 | A+
One | s3 | B
Two | s1 | A+
Two | s2 | B
Two | s3 | C
Spreadsheet: 269976d1381337421-huge-problem-with-the-indirect-function-trying-to-create-dependent-drop-downs-pcard-amounts-removed
Sheet: JAN

Regina Downtown
P-card [NAME]
Purpose: January | Statement
Description | Retailer | Goods Purchased | Total | GST | Fund | Org | Activity | Acct | Project | [NAME]
Downtown Patrol | Extreme Hockey | Skate sharpening | 228.22 | 10.37 | 520 | 0000 | R310 | 64232 | Y0631 | 00
Meetings, Receptions & food | Copper Kettle | Strat planning JH, JV, LG, CC | 48 | 2.05 | 520 | 0000 | R110 | 64115 | Y0609 | 00
Downtown Patrol | Audio Warehouse | Sound equipment | 165.41 | 7.52 | 520 | 0000 | R310 | 65222 | Y0631 | 00
Meetings, Receptions & food | Sask Science Centre | Mayor's Dinner | 250 | 11.9 | 520 | 0000 | R110 | 64115 | Y0609 | 00
Downtown Patrol | Cornwall Centre | gift card | 30 | 0 | 520 | 0000 | R310 | 61330 | Y0631 | 00
Meetings, Receptions & food | Viet- Thai | Meeting w/ [NAME] | 20.5 | 0.85 | 520 | 0000 | R110 | 64115 | Y0609 | 00
Downtown Patrol | Facebook | advertising | 1.26 | 0 | 520 | 0000 | R310 | 64202 | Y0631 | 00
Meetings, Receptions & food | Ticket edge | Other Stakeholders | 150 | 0 | 520 | 0000 | R110 | 64115 | Y0609 | 00
Member [NAME] | Mail Chimp | E-news | 31.07 | 0 | 520 | 0000 | R210 | 64232 | Y0623 | 00
Meetings, Receptions & food | Naked Bean | Mtg w/ Curtis Kemp | 5.75 | 0.23 | 520 | 0000 | R110 | 64115 | Y0609 | 00
Meetings, Receptions & food | Flip | Team meeting | 54.18 | 2.15 | 520 | 0000 | R110 | 64115 | Y0609 | 00
Downtown Patrol | Facebook | advertising | 21.99 | 0 | 520 | 0000 | R310 | 64202 | Y0631 | 00
Downtown Patrol | The Source | adapter for boom box | 27.49 | 1.25 | 520 | 0000 | R310 | 65222 | Y0631 | 00
 |  |  |  |  | 520 | 0000 |  |  |  | 00
TOTAL RECEIPTS
Spreadsheet: 010a6a24-084f-42f1-94ac-b89d792fa6b0
Sheet: Sheet1

CALCULATION FOR CITY OF FLAGSTAFF CONTRACTING TAX | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
FILL IN BLOCKED CELLS ONLY. USE TAB KEY TO MOVE TO NEXT CELL.
PLEASE COMPLETE THE FOLLOWING INFORMATION FROM THE BLANK RETURN MAILED TO YOU BY THE CITY:
TAXPAYER NAME |  |  | TAX RATE | 0.09446
MAILING ADDRESS
CITY, ST ZIP
CITY LICENSE NO.
REPORT PERIOD
[NAME] IF NOT RECEIVED BY
BUSINESS DESCRIPTION LINE 1
BUSINESS DESCRIPTION LINE 2
BUS. CLASS LINE 1
BUS. CLASS LINE 2
SFX LINE 1
SFX LINE 2
PLEASE COMPLETE THE FOLLOWING INFORMATION FROM YOUR INCOME RECORDS:
GROSS CONTRACTING INCOME LINE 1
GROSS CONTRACTING INCOME LINE 2
DOES THIS INCOME INCLUDE TAX?
SUBCONTRACTING DEDUCTION LINE 1
SUBCONTRACTING DEDUCTION LINE 2
OUT-OF-CITY DEDUCTION LINE 1
OUT-OF-CITY DEDUCTION LINE 2
STATE LAND DEDUCTION LINE 1
STATE LAND DEDUCTION LINE 2
INCOME SUBJECT TO CITY TAX: 1500 | 0
INCOME SUBJECT TO CITY TAX: 1600 | 0
TAX AMOUNT YOU OWE | 0
ENTER AMOUNT OF CHECK
IN CITY JOBS SUBJECT TO CITY TPT - 1 | 0
IN CITY JOBS SUBJECT TO STATE TPT - 1 | 0
IN CITY JOBS SUBJECT TO CITY TPT - 2 | 0
IN CITY JOBS SUBJECT TO STATE TPT - 2 | 0
TAX FACTOR FOR 9.446% TAX RATE | 0.05784724
TAX FACTOR 7.725% | 0.04781175
CITY TAX RATE | 0.01721
CITY TAX ON LAND LINE 1 | 0
COMMON BASE LINE 1 | 0
CITY TAX ON LAND LINE 2 | 0
COMMON BASE LINE 2 | 0
DEDUCTIONS | SUBCONTRACTOR | OUT-OF-CITY | LAND | TAX COLLECTED | STD 35%
DEDUCTIONS CODE | # 7 | # 9 | # 8 | # 11 | # 6
LINE 1 |  |  |  | 0
LINE 2 |  |  |  | 0
PRINTING INSTRUCTIONS:
1. GO TO WORKSHEET TAB 'TPT Return Front Page' AND PRESS PRINT ICON ON THE TOOLBAR.
2. GO TO WORKSHEET TAB 'TPT Return Back Page' AND PRESS PRINT ICON ON THE TOOLBAR.
3. PRINT THIS WORKSHEET FOR YOUR RECORDS BY PRESSING THE PRINT ICON ON THE TOOLBAR.
OTHER INSTRUCTIONS:
1. SIGN AND DATE THE TAX RETURN.
2. MAIL TAX RETURN WITH REMITTANCE TO THE CITY OF FLAGSTAFF, [NAME] 22518, FLAGSTAFF AZ 86002-2518.
Spreadsheet: 716637d1612290612-eliminate-duplicate-text-eliminate-duplicate-text-question
Sheet: Sheet1

 | Room | Spec Tag | [NAME] |  | Results Required
 | [NAME] | FIN-155 | Dulux Trade Vinyl Matt
 | co-working area | FIN-155 | Dulux Trade Vinyl Matt
 | reception | FIN-155 | Dulux Trade Vinyl Matt
 | reception | CLG-30 A | Feature timber ceiling
 | reception | CLG-30 B | Cube acoustic panel by Autex Acoustics Ltd.
 | residents' lounge | FIN-155 | Dulux Trade Vinyl Matt
 | residents' lounge | CLG-30 A | Feature timber ceiling
 | residents' lounge | CLG-30 A | Cube acoustic panel by Autex Acoustics Ltd.
 | workstations | FIN-155 | Dulux Trade Vinyl Matt
 | workstations | FIN-155 | Dulux Trade Vinyl Matt
 | workstations | FIN-155 | Dulux Trade Vinyl Matt
 | meeting room | FIN-155 | Dulux Trade Vinyl Matt
 | [NAME] | FIN-155 | Dulux Trade Vinyl Matt
 | screening room | CLG-40 | Cube acoustic panel by Autex Acoustics Ltd.
 | Staff Shower/ WC | FIN-155 | Dulux Trade Vinyl Matt
 | accessible WC | FIN-155 | Dulux Trade Vinyl Matt
 | corridor | FIN-155 | Dulux Trade Vinyl Matt
 | staff room | FIN-155 | Dulux Trade Vinyl Matt
 | meeting room | FIN-155 | Dulux Trade Vinyl Matt
 | post room | FIN-155 | Dulux Trade Vinyl Matt
 | mail room | FIN-155 | Dulux Trade Vinyl Matt
 | corridor | FIN-155 | Dulux Trade Vinyl Matt
 | lift lobby | FIN-155 | Dulux Trade Vinyl Matt
 | corridor | FIN-155 | Dulux Trade Vinyl Matt
 | [NAME] | FIN-155 | Dulux Trade Vinyl Matt
 | dog wash | FIN-155 | Dulux Trade Vinyl Matt
 | lift lobby | FIN-155 | Dulux Trade Vinyl Matt
 | yoga room | CLG-22 | Dulux Trade Vinyl Matt
 | gym | CLG-22 | Dulux Trade Vinyl Matt
 | [NAME] | FIN-155 | Dulux Trade Vinyl Matt
 | WC | FIN-155 | Dulux Trade Vinyl Matt
 | storage | FIN-155 | Dulux Trade Vinyl Matt
 | playspace | CLG-22 | Dulux Trade Vinyl Matt
 | corridor | FIN-155 | Dulux Trade Vinyl Matt
 | core 01 | FIN-155 | Dulux Trade Vinyl Matt
 | lifts in core 01 | AMT-105 | PPC metal ceiling by lift manufacturer
 | corridor | FIN-155 | Dulux Trade Vinyl Matt
 | core 02 | FIN-155 | Dulux Trade Vinyl Matt
 | lifts in core 02 | AMT-105 | PPC metal ceiling by lift manufacturer
 | corridor | FIN-155 | Dulux Trade Vinyl Matt
 | core 02 | FIN-155 | Dulux Trade Vinyl Matt
 | lifts in core 03 | AMT-105 | PPC metal ceiling by lift manufacturer
 | corridor | FIN-155 | Dulux Trade Vinyl Matt
 | residents lounge | FIN-155 | Dulux Trade Vinyl Matt
 | residents lounge | CLG-30 B | Feature timber ceiling
 | residents lounge | CLG-30 B | Cube acoustic panel by Autex Acoustics Ltd.
 | games | FIN-155 | Dulux Trade Vinyl Matt
 | games | CLG-30 B | Feature timber ceiling
 | games | CLG-30 B | Cube acoustic panel by Autex Acoustics Ltd.
 | WC | FIN-155 | Dulux Trade Vinyl Matt
 | storage | FIN-155 | Dulux Trade Vinyl Matt
 | accessible WC | FIN-155 | Dulux Trade Vinyl Matt
 | WC lobby | FIN-155 | Dulux Trade Vinyl Matt
 | WC | FIN-155 | Dulux Trade Vinyl Matt
 | WC | FIN-155 | Dulux Trade Vinyl Matt
 | lift lobby | FIN-155 | Dulux Trade Vinyl Matt
 | lounge/ library | FIN-801 | Dulux Trade Vinyl Matt
 | lounge/ library | CLG-30 C | Feature timber ceiling
Spreadsheet: 145875d1331790808-transfer-data-from-one-sheet-to-another-when-specific-value-entered-in-first-sheet-example_2012_file
Sheet: June

Reporter | Date Rec. | Date Comp. | Witness | Description | Pages Rec | Pages Rtn | Job Type | Rate | Total | Tithe Amount | Tithed | Invoice # | Invoice Date | Date Paid | Monthly Tithe | Tithed MTD | Left to Tithe | Total | Amount Received | Total By Reporter | Amount Due | Amount Received
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Jeanne
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Karisa
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
Spreadsheet: 24999d1216064002-save-freeze-pane-to-web-template
Sheet: Sheet1

 | 1900-01-01 00:00:00 | 00:30:00 | 01:00:00 | 01:30:00 | 02:00:00 | 02:30:00 | 03:00:00 | 03:30:00 | 04:00:00 | 04:30:00 | 05:00:00 | 05:30:00 | 06:00:00 | 06:30:00 | 07:00:00 | 07:30:00 | 08:00:00 | 08:30:00 | 09:00:00 | 09:30:00 | 10:00:00 | 10:30:00 | 11:00:00 | 11:30:00 | 12:00:00 | 12:30:00 | 13:00:00 | 13:30:00 | 14:00:00 | 14:30:00 | 15:00:00 | 15:30:00 | 16:00:00 | 16:30:00 | 17:00:00 | 17:30:00 | 18:00:00 | 18:30:00 | 19:00:00 | 19:30:00 | 20:00:00 | 20:30:00 | 21:00:00 | 21:30:00 | 22:00:00 | 22:30:00 | 23:00:00 | 23:30:00
SUNDAY |  | Classic Arts Showcase |  |  |  | OFF                  THE               PAGE | CITY                    SCENE | METRO    VOICES
MONDAY |  | Classic Arts Showcase
TUESDAY |  | Classic Arts Showcase
WEDNESDAY |  | Classic Arts Showcase
THURSDAY |  | Classic Arts Showcase
FRIDAY |  | Classic Arts Showcase
SATURDAY |  | Classic Arts Showcase
Spreadsheet: 789777d1659360702-deduct-from-previous-value-test0108
Sheet: Sheet1

Part2 | QtyOS | Stock | QtyAv | Fulfil | Expected
PartA | 6000 | 20457
PartB | 50 | 1600
PartA | 6000 | 20457
PartB | 500 | 1600
PartA | 6000 | 20457
PartB | 750 | 1600
PartA | 6000 | 20457 |  |  | 0
PartB | 500 | 1600 |  |  | 0
PartA | 6000 | 20457 |  |  | 0
PartB | 500 | 1600 |  |  | 0
PartA | 6000 | 20457 |  |  | 0
PartB | 500 | 1600 |  |  | 0
PartA | 6000 | 20457 |  |  | 0
PartB | 500 | 1600 |  |  | 0
PartA | 6000 | 20457 |  |  | 0
Spreadsheet: 698673d1602114212-listing-2nd-3rd-4th-iteration-given-criteria-appleorange
Sheet: Sheet2

2x Product | Quarter | [NAME]
Apple | 2 | 2
Apple | 2 | 3
Orange | 3 | 2
Orange | 5 | 1
3x Product | Quarter | [NAME]
Apple | 4 | 1
Spreadsheet: 085075cc-a6ec-4fd2-8aa5-c08700836b94
Sheet: Sheet1

CNJC 2013 Show-n-Sell Cases Only Order Form | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
Contact Name |  |  |  |  | District |  | Your Show-N-Sell order can not exceed more than your FINAL 2012 Show-N-Sell Order.  You can get that number from your District Executive.  If you are ordering Chocolate products or the 8 Pack Unbelievable Butter you must sign the non-returnable waiver form.
E-mail |  |  |  |  | Pack #
Phone |  |  |  |  | Troop #
[NAME] |  |  |  |  | Crew #
 |  |  |  |  | Team # |  | Save, e-mail order form to [EMAIL] no later than:  August 27th.
Please refer to www.cnjcscouting.org for Council's Check Return Policy.
 | [NAME] |  |  | # [NAME]'s in Case |  | CASE Qty Needed |  |  |  | Cost Per Case | Retail Cost
 | [NAME]. Choc. [NAME]* |  |  | 1 |  |  |  | Reminder - you are entering the number of CASES you are ordering on this form! |  | 75 | 0
 | Chocolate Lovers Collection Tin* |  |  | 1 |  |  |  |  |  | 55 | 0
 | Sweet & Savory* |  |  | 1 |  |  |  |  |  | 40 | 0
C | Cheese Lover's |  |  | 1 |  |  |  |  |  | 30 | 0
 | White Chocolatey Pretzels Tin* |  |  | 6 |  |  |  |  |  | 150 | 0
 | Kettle Corn 18-Pack |  |  | 6 |  |  |  |  |  | 120 | 0
 | 18-Pack Unbelieveable Butter |  |  | 6 |  |  |  |  |  | 120 | 0
 | 18-Pack Butter Light |  |  | 6 |  |  |  |  |  | 120 | 0
 | Caramel Corn Almond/Pecan |  |  | 8 |  |  |  |  |  | 144 | 0
 | Dark & White Choc. Drizzle* |  |  | 8 |  |  |  |  |  | 160 | 0
 | Bacon Ranch Bag |  |  | 8 |  |  |  |  |  | 120 | 0
 | Buffalo Cheddar Tin |  |  | 6 |  |  |  |  |  | 120 | 0
 | Sour Cream & Onion Tin |  |  | 6 |  |  |  |  |  | 120 | 0
 | [NAME] Cheese Bag |  |  | 8 |  |  |  |  |  | 120 | 0
 | 11 oz. Caramel Corn |  |  | 12 |  |  |  |  |  | 120 | 0
 | 8 Pack Unbelievable Butter* |  |  | 12 |  |  |  |  |  | 120 | 0
*Chocolate Product Not Returnable/You must submit signed waiver. |  |  |  |  |  |  |  | Total Retail Cost |  |  | 0
For Office Staff Only |  |  |  | Entered on |  |  |  |  | Entered by
 | Areas in grey are not necessary to complete to place order.  However, they will populate if you enter data in Excel.
Spreadsheet: 484292d1476206237-fill-the-form-in-sheet3-using-data-from-sheet1-school-reports
Sheet: Sheet3

 | Monthly Report for The Buses In the Schools |  |  |  |  |  |  | Month:
 |  | School Name:
 |  | Cycle:
 | Serial No | Bus Number | Bus Type | Trip Type |  |  |  | Shared School Name |  | Driver Name
 |  |  |  | Large Bus |  | Small Bus
 |  |  |  | Double | Single | Double | Single
 | 1 | B0008204 | Small |  |  |  | ü
 | 2 | B0009408 | Large | ü
 | 3
 | 4
 | 5
 | 6
 | 7
 | 8
 | 9
 | 10
 | Total
Spreadsheet: de1b70e0-ed3d-4b95-bc44-7bb7d60d6333
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
5840 | 29433 | Fabrizio | Vignali | ITA | 0 | 00:24:53 | [NAME] | 00:47:19 | 00:00:00 | 00:14:15 | 1 | 01:27:06
5840 | 30688 | [NAME] | Smith | GBR | 0 | 00:26:28 | 00:00:43 | 00:52:33 | 00:00:00 | 00:14:14 | 2 | 01:34:00
5840 | 7981 | [NAME] | [NAME] | USA | 0 | 00:25:26 | 00:00:49 | 00:54:02 | 00:00:00 | 00:16:11 | 3 | 01:36:32
5840 | 42399 | [NAME] | Smyth | IRL | 0 | 00:31:01 | 00:01:09 | 01:01:49 | 00:00:00 | 00:29:51 | 4 | 02:03:53
5840 | 40953 | [NAME] | [NAME] | GBR | 0 | 00:43:03 | 00:01:24 | 01:06:59 | 00:00:00 | 00:26:25 | 5 | 02:17:54
Spreadsheet: 57177d1257333551-comparing-grades-text-to-give-a-numerical-score-blank-award-system
Sheet: Design Notes

By assigning a number to the grade a formula then subtracts the 2 numbers giving a points score
The total is then analysed to see how many points it is worth using the table below
Point Score |  | Points Awarded
7 grades above |  | 40
6 grades above |  | 35
5 grades above |  | 30
4 grades above |  | 25
3 grades above |  | 20
2 grades above |  | 15
1 grade above | Above target | 10
Grade the same | At target | 5
[NAME] | Below target | -5
To Add a Subject
Copy A department's Forecast, Actual and points columns and paste at the end before the total points
Click on the total points column and add the new points column created to the total and copy formula for all totals
Spreadsheet: 390227d1429555425-sumif-while-finding-a-sum_range-sumif-example
Sheet: Reference

 | Gross Sales Amount |  |  |  |  | Delete | Delete | Delete
 | Tab for Day |  |  | For Indirect |  | Partitioned INDIRECT | Manual Link | Less Partiioned Indirect
 | Sun
 | Mon
 | Tue |  |  |  |  |  |  |  |  | Then you need to find the criteria range for store number
 | Wed
 | Thu
 | Fri
 | Sat
Spreadsheet: 540159d1506553211-pulling-daily-averages-help-pulling-daily-averages-help-rickmcc-v2
Sheet: Weekly

Date: |  | 2017-09-13 00:00:00
to
Date:
 | Name: |  | Date | Day | Type | Hour Rate | Half | OT Rate | # Hours | Total | Location | Reason
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
 | Totals:
Spreadsheet: 0b3965aa-a4c8-4628-bc0b-89d8abb1edcf
Sheet: Sheet1

Chemistry Purchase Request Form | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
P.O. #: |  |  |  |  | Professor:
Supplier: |  |  |  |  | Account #:
Date: |  |  |  | Order requested by:
 |  |  |  | Contact Ext. #
Source cheaper supplier?
 |  |  |  |  | Price
Item No. | Catalogue No. | Description |  | Quantity | Each | Total | Availability
1
2
3
4
5
6
7
8
9
10
 |  |  |  |  |  | 0
 |  | Date ordered
 | Contact Name or [NAME]
 | Confirmation #
Additional Charges (Dry Ice, Shipping etc.) |  |  |  | Signature
Spreadsheet: 35794d1233455331-combining-if-and-lookup-incompleted-ages
Sheet: incompleted ages

Name | Age |  | gender |  | group |  | age range | age group
Cliff | 42 |  | male |  | 4 |  | 20 | 2
[NAME] | 23 |  | male |  | 2 |  | 30 | 3
[NAME] | 65 |  | female |  | 6 |  | 40 | 4
Rebecca | 28 |  | female |  | 2 |  | 50 | 5
Norm | 56 |  | male |  | 5 |  | 60 | 6
Woody | 41 |  | male |  | 4
Name | Gender | Age Group | Time Allowed
Cliff | male | 4
[NAME] | male | 2
[NAME] | female | 6
Rebecca | female | 2
Norm | male | 5
Woody | male | 4
 |  | Minutes allowed
Age range |  | Female | Male
20 |  | 26 | 23
30 |  | 29 | 25
40 |  | 35 | 30
50 |  | 42 | 35
60 |  | 49 | 42
Spreadsheet: 0a8791de-84e4-4eb4-bfac-22483612972b
Sheet: Business Certificates 2

BUSINESS                                                            Student Name:
Certificates                                                          ID #
Basic Business Administration
Required
___ [NAME] (3) Introduction to Business
___ ENG 101 (3) Writing I
___ CIT 105 (3) Introduction to Computers OR ___ OST 105 (3)Intro to Information Systems
___ ACC 201 (3) Financial Accounting
OR ___ ACT 101 (3) Fundamentals of Accounting I AND ___ ACT 102 (3) Fund of Accounting II
___ ECO 101 (3) Contemporary Economics Issues
OR ___ ECO 201 (3) Principles of Microeconomics
OR ___ ECO 202 (3) Principles of Macroeconomics
Entrepreneurship
Required
___ ACC 201 (3) Financial Accounting
OR ___ ACT 101 (3) Fundamentals of Accounting I AND ___ ACT 102 (3) Fund of Accounting II
___ [NAME] (3) Entrepreneurship
___ [NAME] (3) Principles of Marketing
___ [NAME] (3) Personal and Organizational Leadership
Finance
Required
___ [NAME] (3) Principles of Finance
___ [NAME] (3) Introduction to Financial Management
Choose 9 hours from the following Technical Courses.  Students may select other courses as approved by the
Business Administration Systems Program Coordinator
___ [NAME] (3) Personal Finance
___ [NAME] (3) Money and Financial Institutions
___ [NAME] (3) International Finance
___ [NAME] (3) Selected Topics in Management (track topic)
___ [NAME] (1-4) Business Internship
OR COE 199 (1-4) Cooperative Education
Financial Perspectives
Required
___ ACC 201 (3) Financial Accounting
OR ___ ACT 101 (3) Fundamentals of Accounting I
AND ___ ACT 102 (3) Fundamentals of Accounting II
___ [NAME] (3) Introduction to Business
___ [NAME] (3) Personal Finance
Southeast Kentucky Community & Technical College | Updated Spring 2013
Spreadsheet: 186818d1350239256-creating-a-formula-to-populate-data-in-particular-cells-based-on-conditions-in-other-cells-media-tracking-sheet_reply
Sheet: Data

Store Rating Tables (Avg)
Medium
 | TV | Radio
Brisbane |  |  |  | *AVERAGEIFS functions in green cells.
Adelaide
Perth
Sydney
Melbourne
Newcastle
Gold Coast
ACT
TV Station
 | Seven Network | Nine Network | Network Ten | Prime7 | NBN | SCA | WIN
Brisbane
Adelaide
Perth
Sydney
Melbourne
Newcastle
Gold Coast
ACT
Radio Station
 | ATN | 97.3 | Triple M | Beat 105 | Nova | Sea FM | Gold FM | Hot Tomato | 2DAY | Mix | WSFM | FOX FM | 92.9 | 96FM | NXFM | KOFM | SAFM | 104.7
Brisbane
Adelaide
Perth
Sydney
Melbourne
Newcastle
Gold Coast
ACT
Store Sales Rating Tables
Spreadsheet: dana_davis__4596__var analysis positions
Sheet: SUMMARY

CALPINE PRE-PAY TRANSACTION
SUMMARY OF DEAL POSITIONS & VAR
2001-10-04 00:00:00
DEAL POSITIONS
[NAME] | MW | PV MWh | Product | TYPE | Term | Start
Florida | 115 |  | Energy | 5x16 | 1 years | 2002-01-01 00:00:00
Florida | 300 |  | Energy | 5x16 | 4 years | 2003-01-01 00:00:00
Florida | 100 |  | Energy | 5x8, 2x24 | 3 years | 2004-01-01 00:00:00
Nepool | 50 |  | Energy | 7x24 | 5 years | 2002-01-01 00:00:00
PJM-East | 250 |  | Energy | 7x24 | 5 years | 2002-01-01 00:00:00
Total Energy Position
DEAL VAR |  |  | Florida | Nepool | PJM-East | Total
Incremenal to East Power |  |  |  |  |  | -1500000
Incremental to Power |  |  |  |  |  | -4100000
Incremental to Americas |  |  |  |  |  | 32400
Spreadsheet: 274008d1382981142-difference-of-values-based-on-date-and-criteria-question
Sheet: Sheet1

 |  |  |  |  |  | Date | 2013-10-03 00:00:00 | <<< I created this to get the answer based on date but still not working on Oct 9 due to n/a" on previous it should deduct the value on Oct 4
 |  |  | ID | Item | date | Return
 |  |  | a | 46 | 2013-10-03 00:00:00 | 46
 |  |  | a | 16 | 2013-10-04 00:00:00 | 30
 |  |  | b | 12 | 2013-10-07 00:00:00 | look for number with an ID "b" if none 12
 |  |  | a | n/a | 2013-10-08 00:00:00 | 16
 |  |  | a | 36 | 2013-10-09 00:00:00 | 20
 |  |  |  |  |  |  | text in red should be the answer.
Spreadsheet: 756760d1637763624-move-data-from-one-sheet-to-another-which-matches-two-criteria-example-spreadsheet-4-
Sheet: Master sheet (with load)

Site details |  |  |  |  |  |  |  | 2021-11-01 00:00:00 |  |  |  | 2021-11-02 00:00:00 |  |  |  | 2021-11-03 00:00:00 |  |  |  | 2021-11-04 00:00:00 |  |  |  | 2021-11-05 00:00:00
Route | Route order | Status | Company | Code | Site | Address | Postcode | Level of completion | To charge | Cost | Profit | Level of completion | To charge | Cost | Profit | Level of completion | To charge | Cost | Profit | Level of completion | To charge | Cost | Profit | Level of completion | To charge | Cost | Profit
Text | Text | Text | Text | Text | Site 2 | Text | Text
Text | Text | Text | Text | Text | Site 1 | Text | Text
Text | Text | Text | Text | Text | Site 4 | Text | Text
Text | Text | Text | Text | Text | Site 5 | Text | Text
Text | Text | Text | Text | Text | Site 3 | Text | Text
 |  | This is then the same sheet with the data pasted into the cell which relates to the correct date and site despite the site order being different.
It was proposed that the below formula was put into cell I3 and copied acrosss which worked perfectly if there was only one entry with a date, however, if on the Google sheet there is more than one entry with the same date in column A, this formula stops 'looking' after it finds the first cell with the date in question. What is needed is a formula whih will check all cells for the date in question and if it finds it in any cell, to return that value.
Spreadsheet: 33605d1230059947-algorithm-matching-clocked-hours-to-required-hours-665886
Sheet: Sheet1

 |  |  | Hours Required by Subject
 |  |  | 2 | 4 | 6 | 8 | 10 | << change as desired
Date | Hours |  | math | reading | writing | history | physics
 |  |  |  |  |  |  |  | << this blank row, and blank column C, are required
2008-11-05 00:00:00 | 1 |  | 1 | 0 | 0 | 0 | 0 | << the formula in D5 is copied across and down
2008-11-06 00:00:00 | 3 |  | 1 | 2 | 0 | 0 | 0
2008-11-08 00:00:00 | 3 |  | 0 | 2 | 1 | 0 | 0
2008-11-10 00:00:00 | 3 |  | 0 | 0 | 3 | 0 | 0
2008-11-11 00:00:00 | 3 |  | 0 | 0 | 2 | 1 | 0
2008-11-12 00:00:00 | 2 |  | 0 | 0 | 0 | 2 | 0
2008-11-13 00:00:00 | 2 |  | 0 | 0 | 0 | 2 | 0
2008-11-14 00:00:00 | 2 |  | 0 | 0 | 0 | 2 | 0
2008-11-15 00:00:00 | 2 |  | 0 | 0 | 0 | 1 | 1
2008-11-16 00:00:00 | 3 |  | 0 | 0 | 0 | 0 | 3
2008-11-17 00:00:00 | 2 |  | 0 | 0 | 0 | 0 | 2
2008-11-18 00:00:00 | 4 |  | 0 | 0 | 0 | 0 | 4
Totals | 30 |  | 2 | 4 | 6 | 8 | 10