tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 88702d1288561083-if-blank-then-cell-below-hatchiman_problem8_1
Sheet: Sheet1

FINAL DATA LIST |  |  |  |  |  |  |  |  |  |  |  | BIG DATA LIST
 |  |  |  |  |  |  |  |  |  |  |  | Data A
 |  |  |  |  |  |  |  |  |  |  |  | Data B
 |  |  |  |  |  |  |  |  |  |  |  | Data C
 |  |  |  |  |  |  |  |  |  |  |  | Data D
 |  |  |  |  |  |  |  |  |  |  |  | Data E
 |  |  |  |  |  |  |  |  |  |  |  | Data F
 |  |  |  |  |  |  |  |  |  |  |  | Data G
 |  |  |  |  |  |  |  |  |  |  |  | Data H
 |  |  |  |  |  |  |  |  |  |  |  | Data I
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  | Data C
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | Status A
 |  |  |  |  |  |  |  |  |  |  |  | Status B
 |  |  |  |  |  |  |  |  |  |  |  | Status C
 |  |  |  |  |  |  |  |  |  |  |  | Status D
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0
Spreadsheet: 0e1110bf-f1d7-4590-9d0e-d3e626a88d8d
Sheet: Blank

NASP Equipment  - Supplemental Order Form
Brennan Industries, Inc. - The Official Equipment Distributor for the National Archery in the Schools Program
Brennan Industries |  |  | Prices effective: |  |  |  |  |  |  | Phone: (608) 269-0832
2035 Riley Road |  |  | January 1 - December 31, 2012 |  |  |  |  |  |  | Fax:     (608) 269-0172
Sparta, WI  54656 |  |  |  |  |  | email: [EMAIL]
 |  |  |  |  |  | www.archeryintheschools.org
Customer #:
Organization: |  |  |  |  | [NAME]:
Contact Name: |  |  |  |  | (If different)
Ship-To Address: |  |  |  |  | City State Zip:
(NO PO Box) |  |  |  |  | Phone:
City State Zip: |  |  |  |  | Fax:
 | Commercial |  | Residential |  | E-mail:
 | Evidence of Non-Profit Status: |  |  |  | Copy of 501c3 |  |  | Copy of Sales Tax Exemption
Payment accepted by Check, MasterCard, Visa, or [NAME]:
 |  |  |  |  |  | VISA / MasterCard:
PO Number: |  |  |  |  |  | Name:
*PO Number is REQUIRED if order is not prepaid. |  |  |  |  |  | Card #:
 |  |  |  |  |  | Expires: |  |  | 3-Digit Code
 |  |  |  |  |  |  | Retain CC# for future orders?       Yes       No
 | Number | Item |  |  |  | Qty |  | (Includes Shipping) | Price
Mini | 11413 | Mini Right Hand Red |  |  |  |  | Ea | $111/bow
Genesis | 11415 | Mini Right Hand Blue |  |  |  |  | Ea | $111/bow
Bows: | 11417 | Mini Right Hand Black |  |  |  |  | Ea | $111/bow
 | 11414 | [NAME] Red |  |  |  |  | Ea | $111/bow
 | 11416 | [NAME] |  |  |  |  | Ea | $111/bow
 | 11418 | [NAME] Black |  |  |  |  | Ea | $111/bow
Genesis | 10492A | Genesis Pro Right Hand Black |  |  |  |  | Ea | $131/bow |  | ***
Pro | 10496A | Genesis Pro Right Hand Black/Red |  |  |  |  | Ea | $131/bow |  | ***
Bows: | 10491A | Genesis Pro Left Hand Black |  |  |  |  | Ea | $131/bow |  | ***
 | 10497A | Genesis Pro Left Hand Black/Red |  |  |  |  | Ea | $131/bow |  | ***
Replacement | BG20014 | Right Hand Arrow Rest (Not Pro) |  |  |  |  | Ea | $8/each
Parts: | BG20015 | Left Hand Arrow Rest (Not Pro) |  |  |  |  | Ea | $8/each
 | BG11498 | String (Orig or Pro) 94 13/16" (Blk & Wht) |  |  |  |  | Ea | $17/each
 | BG10897 | String (Orig or Pro) 94 13/16" (Blk & Red) |  |  |  |  | Ea | $17/each
 | BG11490 | [NAME] 77 11/16" (Blk and Wht) |  |  |  |  | Ea | $17/each
 | BG11491 | [NAME] 77 11/16" (Black and Red) |  |  |  |  | Ea | $17/each
 | BG11497 | Power Cable Genesis & Pro 37.25" |  |  |  |  | Ea | $10/each
 | BG11492 | Power Cable Mini 30 13/16" |  |  |  |  | Ea | $10/each
 | 50138 | Cable Rod Slide |  |  |  |  | Ea | $1/each
 | ** All prices include shipping to a commercial
 | address in the lower 48 States |  |  |  |  |  |  | Total
*** Please note - Genesis Pro does NOT include a rest.  You will have to purchase a rest separately ***
from another source.  [NAME] and [NAME] are not eligible for NASP tournament competition.
*** BY SUBMITTING THIS ORDER TO BRENNAN INDUSTRIES, INC. YOU AGREE THAT NO ITEMS WILL BE RESOLD
Spreadsheet: 102371d1300316908-associate-find-nos-and-return-equal-greater-mainanswer
Sheet: Sheet2

MAIN 1 | MAIN1L | MAIN 2L | MAIN | H | L | MAIN | H | L | MAIN | H | L
95 | 72 | 130 | 80 | 120 | 60 | 70 | 90 | 50 | 95 | 130 | 72
140 | 86 | 170 | 67 | 80 | 37 | 90 | 120 | 65 | 140 | 170 | 86
87 | 64 | 102 | 75 | 90 | 40 | 30 | 45 | 10 | 87 | 102 | 64
A2 IS THE LARGEST FIG FROM THE HEADER MAIN (D2 & G2 & J2 ). I WANT TO FIND THE FIG THAT IS CONNECTED WITH A2 WHICH WILL ALWAYS BE A FIG FROM THE COLUMNS HEADED L AND RETURNED IN MAIN 1L. I WOULD THEN LIKE TO FIND ANY NUMBER THAT IS EQUAL TO OR GREATER THAN IN MAIN 1L FROM FIGS IN COLUMNS HEADED H AND TO BE RETURNED IN MAIN 2 AND THE LARGEST OF THE SELECTION. I HAVE ENTERED MAIN 1L AND MAIN 2L AS HARD FIGURES TO SHOW WHAT I REQUIRE. THIS FUNCTION COULD EXTEND TO TEN BLOCKS OF FIGURES INSTEAD OF JUST THE THREE IN THE EXAMPLE.
Spreadsheet: 888373d1738857129-liquidity-risk-exposure-using-monte-carlo-simulation-monte-carlo-simulation
Sheet: Monte Cralo Simulation

 | Monto Carlo Simulation
 | Investment | 85% of clients funds
 | Iteration | Probability | ?? | Count
 | 1 |  |  | 1
 | 2 |  |  | 1
 | 3 |  |  | 1
 | 4 |  |  | 1
 | 5 |  |  | 1
 | 6 |  |  | 1
 | 7 |  |  | 1
 | 8 |  |  | 1
 | 9 |  |  | 1
 | 10 |  |  | 1
 | 11 |  |  | 1
 | 12 |  |  | 1
 | 13 |  |  | 1
 | 14 |  |  | 1
 | 15 |  |  | 1
 | 16 |  |  | 1
 | 17 |  |  | 1
 | 18 |  |  | 1
 | 19 |  |  | 1
 | 20 |  |  | 1
 | 21 |  |  | 1
 | 22 |  |  | 1
 | 23 |  |  | 1
 | 24 |  |  | 1
 | 25 |  |  | 1
 | 26 |  |  | 1
 | 27 |  |  | 1
 | 28 |  |  | 1
 | 29 |  |  | 1
 | 30 |  |  | 1
 | 31 |  |  | 1
 | 32 |  |  | 1
 | 33 |  |  | 1
 | 34 |  |  | 1
 | 35 |  |  | 1
 | 36 |  |  | 1
 | 37 |  |  | 1
 | 38 |  |  | 1
 | 39 |  |  | 1
 | 40 |  |  | 1
 | 41 |  |  | 1
 | 42 |  |  | 1
 | 43 |  |  | 1
 | 44 |  |  | 1
 | 45 |  |  | 1
 | 46 |  |  | 1
 | 47 |  |  | 1
 | 48 |  |  | 1
 | 49 |  |  | 1
 | 50 |  |  | 1
 | 51 |  |  | 1
 | 52 |  |  | 1
 | 53 |  |  | 1
 | 54 |  |  | 1
 | 55 |  |  | 1
 | 56 |  |  | 1
 | 57 |  |  | 1
 | 58 |  |  | 1
 | 59 |  |  | 1
 | 60 |  |  | 1
 | 61 |  |  | 1
 | 62 |  |  | 1
 | 63 |  |  | 1
 | 64 |  |  | 1
 | 65 |  |  | 1
 | 66 |  |  | 1
Spreadsheet: 121606d1316189209-excel-2007-conditional-filtering-of-multiple-rows-simultaniously-tigervatar-example-for-spaceman56
Sheet: Sheet1

Player | Year | Poor | Good | VG | Great | Mint
[NAME] | 96 | 2 | 5 | 10 | 25 | 100
[NAME] | 98 | 1 | 3 | 5.5 | 13 | 75
[NAME] | 95 | 0.1 | 0.12 | 0.18 | 0.24 | 0.3
Spreadsheet: 722757d1615395240-second-to-last-value-last-occurrence-before-last-row-position
Sheet: Sheet1

 | Position of last entry | Possition, one befor the last row? |  |  | N1 | N2 | N3 | N4
A |  | ? (should return 1) |  |  | A | A | B | D
B |  | ? (should return 2) |  |  | B | C | F | G
C |  | ? (should return 3) |  |  | F | C | C | D
D |  |  |  |  | A | B | F | F
E
F
 | position of A1 is 4 (4th row entry)
 | Any formula to find the possition of A in previous row before last?
Spreadsheet: 759493d1639576756-create-duplicate-numbers-for-consecutive-and-duplicate-data-data
Sheet: Sheet1

 | Data | Expected result
 | Blue | 1
 | Blue | 1
 | Green | 1
 | Green | 1
 | Green | 1
 | Red | 1
 | Blue | 2
 | Red | 2
 | Green | 2
 | Green | 2
 | Blue | 3
 | Blue | 3
 | Red | 3
Spreadsheet: 164686d1340846627-pivot-table-pivot-table-query-answer
Sheet: Sheet1

CC | ENT HRS | ENT $
1705800002 | 269.4248 | 23046.42 |  |  | Pivot Table to Appear Like
1705800002 | 128.8107 | 9059.46
1705800002 | 152.1048 | 7270.58 |  |  | CC | ENT HRS | ENT$
1705800001 | 190.627 | 9519.13 |  |  | 1705800002 | XX | XX
1905800002 | 237.545 | 25561.53 |  |  | 1805800018 | XX | XX
1705800001 | 141.2748 | 6717.3
1805807100 | 339.2748 | 25992.45 |  |  |  | TOTAL | TOTAL
1705800002 | 197.5327 | 9707.06
1705800001 | 0 | 0
1705800002 | 107.1048 | 5449.57
1805800018 | 150.8871 | 7426.74
1705800002 | 46.7548 | 3565.73
1805800004 | 0 | 0
1505800650 | 339.4548 | 16267.54
1705800002 | 245.4655 | 21301.3
1505800650 | 249.2748 | 17303.64
1705800002 | 267.5948 | 16810.14
1705800002 | 194.6209 | 10257.81
1805800035 | 0 | 0
1705800001 | 266.6248 | 14169.81
1705800012 | 187.2278 | 11307.48
1805800018 | 253.6067 | 8646.03
1805800005 | 145.9379 | 6144.51
1405801100 | 123.9499 | 6893.84
1705800002 | 158.6035 | 8078.77
1705800001 | 0 | 0
1805800035 | 52.2462 | 1324.65
1805800018 | 0 | 0
2305800001 | 207.8104 | 15202.68
1705800001 | 125.2682 | 5464.07
1705800002 | 95.3975 | 4349.57
1705800002 | 53.4605 | 2286.25
1705800002 | 0 | 0
1705800002 | 22.5436 | 1016.82
1505800650 | 102.5701 | 4734.02
1705800002 | 70.2062 | 4476.62
1805800018 | 85.8227 | 2215.02
1705800012 | 0 | 0
1705800022 | 75.2035 | 6703.79
1705800001 | 0 | 0
1805800018 | 19.5727 | 564.59
1805800018 | 31.2329 | 790.29
1505800650 | 74.3706 | 3387.26
1805800035 | 13.7425 | 577.23
1705800001 | 150.1864 | 7162.19
1805800035 | 0 | 0
1805800018 | 64.2719 | 1658.81
2305800001 | 67.6746 | 2214
Spreadsheet: fe5329d0-97a8-4a80-804b-cba4dc6acc76
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
BAYL | Test | BAYL | [NAME], IgE | [NAME], IgE | Fluorescence Enzyme Immunoassay (FEIA) | Serum Gel Tube: SGT |  |  | 0.5 | mL | Container/Tube: Preferred: Red top Acceptable: Serum gel [NAME]: 0.5 mL for each 5 allergens requested Additional Information: Designate specific allergens from the list in Allergens-IgE Antibodies in Special Instructions. Forms: If not ordering electronically, submit an Allergen Request Form (Supply T236) with the specimen. | For 1 allergen: 0.3 mL/For more | Hemolysis	Mild OK; Gross OK Thawing	Warm reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	NA Other	NA | Class	IgE kU/L	Interpretation 0	<0.35	Negative 1	0.35-0.69	Equivocal 2	0.70-3.49	Positive 3	3.50-17.4	Positive 4	17.5-49.9	Strongly positive 5	50.0-99.9	Strongly positive 6	> or =100	Strongly positive Reference values apply to all ages. | Monday through Friday; 9 a.m.-8 p.m., Saturday; 8 a.m.-3 p.m. | Same day/1 day | 3 days | 1 | 86003 |  |  |  |  | Rochester
BAYL | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
BAYL | Result | BAYL | [NAME], IgE | [NAME], IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 7125-8
Spreadsheet: 144870d1331175740-excel-2007-drop-down-list-with-non-contiguous-cells-help-drop_downs
Sheet: Sheet1

OPTIONS
SP Option 1
 | JBL
Speakers | Community | JBL
 | Owi
 |  |  |  | SPEAKER FINAL | JBL
SP Option 2
 | JBL
Speakers | Community | Community
 | Owi
AMP Option 1
 | Crown
Amps | QSC | Crown
 | Peavey
AMP Option 2 |  |  |  | AMP FINAL | Crown
 | Crown
Amps | QSC | Peavey
 | Peavey
Spreadsheet: 738647d1625160590-find-ratio-of-cells-with-conditions-bo-trend-backtesting
Sheet: CALCS

TIME (WINNING TRADES)
 |  | (total Time in range) | (entries in range) | (ave price) | (percent of trades)
START | END | SUMIFS | COUNTIFS | SUMIFS/COUNTIFS | %AGE v2
08:00:00 | 08:59:00
09:00:00 | 09:29:00
09:30:00 | 09:49:00
09:50:00 | 10:29:00
10:30:00 | 11:29:00
11:30:00 | 14:59:00
PRICE (WINNING TRADES)
 |  | (total price) | (entries) | (ave price) | (total G/L) | (ave G/L)
LOW | HIGH | SUMIFS | COUNTIFS | SUMIFS/COUNTIFS | SUMIFS | AVERAGE
0.01 | 3
3.01 | 5
5.01 | 7
7.01 | 10
10.01 | 15
15.01 | 20
20.01 | 25
25.01 | 30
30.01 | 300
Spreadsheet: 819288d1677386891-need-formula-to-lookup-last-posted-balance-using-2-criteria-sample11
Sheet: Sheet1

Current Date
Card 1
Date | Card Type | Balance
2023-02-15 00:00:00 | Card 1 | 901.66
2023-02-16 00:00:00 | Card 2 | 1004.45
2023-02-20 00:00:00 | Card 1 | 850.65
2023-02-22 00:00:00 | Card 1 | 320.33
2023-02-22 00:00:00 | Card 2 | 501.23
Spreadsheet: 129463d1321625530-how-to-consolidate-two-sheets-of-data-combined-master-data
Sheet: result(summary)

Class | Name | Item | [NAME]
2P | Janny | Age | 12
2P | Janny | Gender | F
4D | [NAME] | n/a | n/a
RT | [NAME] | Age | 17
RT | [NAME] | Gender | F
Spreadsheet: 170536d1343311601-linking-two-worksheets-marketing_spreadsheet
Sheet: Task by Month

Book Title
By Name
 | July | August | September | October | November | December | January | February | March
Category
Bookseller |  |  | Task two | Task one |  | Task four
 |  |  |  | Task three
Author Community | Task two | Task two | Task two | Task two | Task two | Task two | Task two | Task two | Task two
 | Task one
 | Task three | Task three | Task three | Task three | Task three | Task three | Task three | Task three | Task three
Content |  | Task one |  | Task two |  | Task four
 |  |  |  | Task three
General | Task one | Task three
 | Task two | Task four
Marketing |  |  |  |  | Task one
 |  |  |  |  | Task two
Publicity |  |  |  |  |  |  | Task two | Task one
Sales |  |  |  |  | Task two | Task three |  |  | Task one
Social Media |  | Task two | Task one |  |  |  | Task three
 |  | Task four
Speaking |  |  |  | Task one |  | Task three
 |  |  |  | Task two |  | Task four
Spreadsheet: 803063d1667234108-billing-amount-calculation-based-on-billing-frequencies-billing-template-formulas-contract-duration-
Sheet: Monthly Invoicing

Name of Customer | Contract value | Subscription Start Date C | Subscription End Date C | Billing term | Billing frequency | Contract Duration | Check | 2022-03-01 00:00:00
C | 1250 | 2022-08-01 00:00:00 | 2024-01-04 00:00:00 | Net 60 | Monthly
C | 1250 | 2022-08-01 00:00:00 | 2024-01-04 00:00:00 | Net 60 | Monthly
Spreadsheet: 42991d1241610786-formatting-of-graphs-dependending-on-input-given-color
Sheet: Sheet1 (2)

name | quality | <100 | >=100 | >=150 | >=200
a | 200 | 0 | 0 | 0 | 200
b | 175 | 0 | 0 | 175 | 0
c | 100 | 0 | 100 | 0 | 0
d | 150 | 0 | 0 | 150 | 0
e | 200 | 0 | 0 | 0 | 200
f | 15 | 15 | 0 | 0 | 0
 |  |  |  |  | Is it possible to create a bar graph and have the bar change colour depending on the values inputed?
 |  |  |  |  | For example: If i have sales of 100 the bar on the graph should show red in colour, if i have sales of 150 the bar should show orange in colour and if i have sales of 200 the bar should show green in colour
Spreadsheet: 0406e586-3412-436b-824e-6cbd069c3748
Sheet: support-districts

 | Full-Time Equivalents (FTEs) by Position
 | Licensed and Classified Personnel
 | FY 2011
 | Local Education Agencies | SUPPORT |  |  |  |  |  |  |  |  |  | TOTAL FTEs
 |  | LEA Administrators |  | [NAME] Staff | School Administrators | School Administrative Support Staff | Student Support Services Staff |  |  |  | Other Support Staff
 |  |  |  |  |  |  | Student Support Services | Student Transportation Supervisors | School Food Services Supervisors | School Nurses
 |  | CACTUS Database | Classified Personnel Report | Classified Personnel Report | CACTUS Database | Classified Personnel Report | CACTUS Database | Classified Personnel Report | Classified Personnel Report | Classified Personnel Report | Classified Personnel Report
 | DISTRICT
1 | Alpine
2 | Beaver
3 | [NAME]
4 | Cache
42 | Canyons
5 | Carbon
6 | Daggett
7 | [NAME]
8 | Duchesne
9 | Emery
10 | [NAME]
11 | Grand
12 | Granite
13 | Iron
14 | Jordan
15 | [NAME]
16 | [NAME]
39 | Logan
17 | Millard
18 | Morgan
40 | [NAME]
19 | Nebo
20 | [NAME]
21 | North Summit
37 | Ogden
22 | Park City
23 | Piute
38 | Provo
24 | Rich
36 | [NAME]
25 | San Juan
26 | Sevier
27 | South Sanpete
28 | South Summit
29 | Tintic
30 | Tooele
31 | Uintah
32 | Wasatch
33 | Washington
34 | Wayne
35 | Weber
 | DISTRICT TOTAL
 | CHARTER TOTAL
 | GRAND TOTAL
Spreadsheet: 677456d1589366042-weight-average-problem-please-help-me-from-going-insane-excel-issue
Sheet: Sheet1

 | Return on ad spend. Nov-April
 |  | Product A | Product B | Total
 | Leads from online ads | 641 | 338
 | Conversion rate (lead to purchase) | 0.27 | 0.25
 | Purchases from online ads
 | Avg Sale Price | 9237 | 3658
 | Revenue from online ads
 | Ad spend |  |  | 150000
 | ROAS per $1 spent
Spreadsheet: 342361d1409419164-volume-mix-margin-analysis-simple-example
Sheet: Sheet1

 |  | Gross Profit |  |  |  | Profit Rate |  |  |  | Units |  |  | Mix |  |  | [NAME]
Product |  | Actual | Budget | [NAME] |  | Actual | Budget | [NAME] |  | Actual | Budget |  | Actual | Budget |  | Rate | Volume | Mix | Total
A |  |  |  |  |  | 3 | 4 |  |  | 700 | 400
B |  |  |  |  |  | 2 | 1 |  |  | 100 | 300
C |  |  |  |  |  | 1 | 2 |  |  | 300 | 300
Total
Rate Variance:
Volume Proof Calculation:
Mix Proof Calculation:
Total Proof Calculation:
Spreadsheet: 717682d1612799867-look-up-and-return-using-dates-copy-of-test-plastics
Sheet: Sheet1

Week Number | Time/Manning |  |  |  |  |  | Productivity |  |  |  |  | Performance
 | Date |  | Day | Shift | Setters | Operators | Machines run per shift | Tool changes per shift | Semi Auto jobs run | Fully Auto jobs run | Downtime (Hours) | Parts moulded per shift | Total Good | Total Rejects | RFT
1 | 2020-12-28 00:00:00 | 2020-12-28 00:00:00 | Mon | AM
 |  | 2020-12-28 00:00:00 | Mon | PM
 |  | 2020-12-28 00:00:00 | Mon | N
 | 2020-12-29 00:00:00 | 2020-12-29 00:00:00 | Tue | AM
 |  | 2020-12-29 00:00:00 | Tue | PM
 |  | 2020-12-29 00:00:00 | Tue | N
 | 2020-12-30 00:00:00 | 2020-12-30 00:00:00 | Wed | AM
 |  | 2020-12-30 00:00:00 | Wed | PM
 |  | 2020-12-30 00:00:00 | Wed | N
 | 2020-12-31 00:00:00 | 2021-12-31 00:00:00 | Thu | AM
 |  | 2021-12-31 00:00:00 | Thu | PM
 |  | 2021-12-31 00:00:00 | Thu | N
 | 2021-01-01 00:00:00 | 2021-01-01 00:00:00 | Fri | AM
 |  | 2021-01-01 00:00:00 | Fri | PM
 |  | 2021-01-01 00:00:00 | Fri | N
 | 2021-01-02 00:00:00 | 2021-01-02 00:00:00 | Sat | AM
 |  | 2021-01-02 00:00:00 | Sat | PM
 |  | 2021-01-02 00:00:00 | Sat | N
 | 2021-01-03 00:00:00 | 2021-01-03 00:00:00 | Sun | AM
 |  | 2021-01-03 00:00:00 | Sun | PM
 |  | 2021-01-03 00:00:00 | Sun | N
2 | 2021-01-04 00:00:00 | 2021-01-04 00:00:00 | Mon | AM
 |  | 2021-01-04 00:00:00 | Mon | PM
 |  | 2021-01-04 00:00:00 | Mon | N
 | 2021-01-05 00:00:00 | 2021-01-05 00:00:00 | Tue | AM
 |  | 2021-01-05 00:00:00 | Tue | PM
 |  | 2021-01-05 00:00:00 | Tue | N
 | 2021-01-06 00:00:00 | 2021-01-06 00:00:00 | Wed | AM
 |  | 2021-01-06 00:00:00 | Wed | PM
 |  | 2021-01-06 00:00:00 | Wed | N
 | 2021-01-07 00:00:00 |  | Thu | AM
 |  |  | Thu | PM
 |  |  | Thu | N
 | 2021-01-08 00:00:00 |  | Fri | AM
 |  |  | Fri | PM
 |  |  | Fri | N
 | 2021-01-09 00:00:00 |  | Sat | AM
 |  |  | Sat | PM
 |  |  | Sat | N
 | 2021-01-10 00:00:00 |  | Sun | AM
 |  |  | Sun | PM
 |  |  | Sun | N
Spreadsheet: 63270d1264178853-running-calculator-for-instructors-715065-running-calculator-for-instructors
Sheet: Sheet1

Instructor | Points | reception | enthusiasm | knowledge | communication | informed | structure | students taught
Excellent | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
Very good | 4 |  |  |  |  |  |  | 5
Good | 3 |  |  |  |  |  |  | 5
Average | 2 |  |  |  |  |  |  | 5
Poor | 1 |  |  |  |  |  |  | Average score
POINTS AV |  | 5 | 5 | 5 | 5 | 5 | 5 | 5
 | is there a way of adding the data each week and excel works out the running total? rather than me having to update each field.
 |  |  | I’m not too sure if excel can do what I want it to do but here goes.
Each week I get instructor feedback, on each section they are marked from 1 to 5. What I want is a system where I can input the info into excel which works out how they are scoring throughout the year.
The maximum number of students is 5 so the maximum score available in each week would be 25 (all five students thought that he was excellent). We have then divided the score by the students taught to give us a average score for each section.
This part is fairly straight forward; the problem is when I then have to input new data. What I want is to be able to put what they scored that week rather than having to add the numbers up in my head to get a running total. So I can see what they are averaging throughout the year.
 | http://www.excelforum.com/excel-general/715065-running-calculator-for-instructors.html
Spreadsheet: 124039d1318016145-vlookup-ineffective-what-should-i-use-example2-jrchel20
Sheet: Redults

Wanted Results
Flight No | AC # | A/C Type | AC Config | DEST | FC | BC | EC | CREW | BOB | TEAM | ACTUAL KD | BIK | ERT (EPA) | GRT (GLY) | FRT (FOOD) | CHKR TIME | KRT | KDT | ETA | ETD | Special Meals | CREW | FA |  | PRELIM | FINAL | CONFIRMED FINAL | COMMENTS
AM0641 |  | 73G | 12/12/112 | GDL |  | CMWT | CMWT |  |  | 18 |  |  | 17:45:00 | 18:45:00 | 18:45:00 | 19:45:00 | 20:45:00 | 21:45:00 |  | 00:10 |  |  |  |  | BC 12 EC 112 |  |  |  | 01:00:00 | 02:00:00
DL0806 |  | 73H | 16/16/144 | MSP | Z00 |  | Z00 |  |  | 5E |  |  | 15:45:00 | 16:45:00 | 17:45:00 | 18:45:00 | 19:45:00 | 20:45:00 |  | 00:29 |  |  |  |  | FC 16 EC 144 |  |  |  | 01:00:00 | 02:00:00
AM0665 |  | 73G | 12/12/112 | MEX |  | CMWT | CMWT |  |  | 18 |  |  | 16:45:00 | 17:45:00 | 18:45:00 | 19:45:00 | 20:45:00 | 21:45:00 |  | 00:40 |  |  |  |  | BC 12 EC 112 |  |  |  | 01:00:00 | 02:00:00
CX0873 |  | 74A | 9/45/324 | HKG | BEVP, HBNT, HMNT | BEVP, HBNT, HMNT | BEVP, CSNT, HBNT, HMNT | HBNT, HMNT |  | 23 |  |  | 16:20:00 | 17:20:00 | 18:20:00 | 19:20:00 | 20:20:00 | 21:20:00 | 21:55 | 01:20 |  |  |  |  | FC 9 BC 45 EC 324 CC 4 CY 17 |  |  |  | 01:00:00 | 02:00:00
BR0017 |  | 77W | 0/36/211 | TPE |  | HBWT, HMNT, HSWT | HBWT, HMNT | HBNT, HMWT |  | 4D |  |  | 18:00:00 | 19:00:00 | 20:00:00 | 21:00:00 | 22:00:00 | 23:00:00 | 16:00 | 01:40 |  |  |  |  | BC 36 EC 211 EU 71 CC 3 CY 6 |  |  |  | 01:00:00 | 02:00:00
Spreadsheet: 157737d1337861286-excel-2007-vlookup-or-somthing-similar-on-two-criteria-columns-0lookup-on-two-columns
Sheet: Current Method

 | DATA |  |  |  | LOOKUP
[NAME] | Nominal | Cost Centre | Balance |  | Nominal | Cost Centre | Balance
1 1 | 1 | 1 | 10 |  | 1 | 4 | 40
1 2 | 1 | 2 | 20
1 3 | 1 | 3 | 30
1 4 | 1 | 4 | 40
2 1 | 2 | 1 | 50
2 2 | 2 | 2 | 60
2 3 | 2 | 3 | 70
2 4 | 2 | 4 | 80
2 5 | 2 | 5 | 90
2 6 | 2 | 6 | 100
2 7 | 2 | 7 | 110
3 1 | 3 | 1 | 120
3 2 | 3 | 2 | 130
4 1 | 4 | 1 | 140
4 2 | 4 | 2 | 150
4 3 | 4 | 3 | 160
4 4 | 4 | 4 | 170
4 5 | 4 | 5 | 180
 | This data grows and shrinks and I don't want to have to check that the formula in column A is in line with the last row of data in column B