tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 790129d1659541152-conditional-highlighting-across-different-sheets-and-different-columns-example
Sheet: Sheet1

 | E110 | E111 | E112 | E113 | E114 | E115 | E116 | E117 | E118 |  | F110 | F111 | F112 | F113 | F114 | F115 | F116 | F117 | F118 |  | G110 | G111 | G112 | G113 | G114 | G115 | G116 | G117 | G118 |  | H105 | H106 | H107 | H108 | H109
 | E109 | E108 | E107 | E106 | E105 | E104 | E103 | E102 | E101 |  | F109 | F108 | F107 | F106 | F105 | F104 | F103 | F102 | F101 |  | G109 | G108 | G107 | G106 | G105 | G104 | G103 | G102 | G101 |  | H104 | H103 | H102 | H101
 |  | U110 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | U106
 |  | U109 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | U105
 | D110 | D111 | D112 | D113 | D114 | D115 | D116 | D117 |  |  | C110 | C111 | C112 | C113 | C114 | C115 | C116 | C117 | C118 |  | B110 | B111 | B112 | B113 | B114 | B115 | B116 | B117 | B118 |  | A109 | A110 | A111 | A112 | A113 | A114 | A115 | A116
 | D109 | D108 | D107 | D106 | D105 | D104 | D103 | D102 | D101 |  | C109 | C108 | C107 | C106 | C105 | C104 | C103 | C102 | C101 |  | B109 | B108 | B107 | B106 | B105 | B104 | B103 | B102 | B101 |  | A108 | A107 | A106 | A105 | A104 | A103 | A102 | [NAME]
Spreadsheet: 726812d1617492035-student-assignment-planner-assignment-planner
Sheet: Assignments

 | MONTH VIEW | WEEK VIEW
 | ASSIGNMENTS
 | [NAME] | DUE DATE
 | Assignment 1
 | Assignment 2
 | Assignment 3
 | Assignment 4
 | Assignment 5
 | Assignment 6
 | Assignment 7
 | Assignment 8
 | Assignment 9
 | Assignment 10
 | Assignment 11
 | Assignment 12
Spreadsheet: louise_kitchen__22508__Turbine Position Report 100501 Revised
Sheet: Summary by Status

Turbine Position Report |  |  |  |  |  |  | CONFIDENTIAL
Summary by Status
($ MMs)
 |  |  |  |  |  | Financial Data as of
UNITS | MODEL | CONTROLLED BY | PROJECT(S) | DASH APPROVAL DATE / STATUS | CONTRACT COST | SCHEDULED CONTRACT PYMTS TO DATE | CANCELLATION COST TO DATE | STATUS
COMMITTED - turbines committed to deals which have been DASHed and financing is in process.
 |  |  | Total Committed
TENTATIVE - turbines tentatively committed to ONE deal which has not yet been DASHed, but is likely to be.
1 | 7FA |  |  |  |  |  |  | Tentative
 |  |  | Total Tentative
AVAILABLE - turbines which may be potential matches with SEVERAL deals, none of which have been approved to date.
1 | 501D5A simple cycle |  |  |  |  |  |  | Available
3 | 9FA STAG power islands |  |  |  |  |  |  | Available
2 | 11N1 |  |  |  |  |  |  | Available
1 | MHI 501F simple cycle |  |  |  |  |  |  | Available
3 | MHI 501F simple cycle |  |  |  |  |  |  | Available
2 | Fr 6B 60hz power barges (BV=0) |  |  |  |  |  |  | Available
1 | LM6000 |  |  |  |  |  |  | Available
 |  |  | Total Available
NEGOTIATING - turbines for which the purchase is currently being negotiated, but Enron does not yet have control of these turbines.
 |  |  | Total Negotiating
 | UNITS - TOTAL |  | GRAND TOTALS
SCHEDULED VS CANCELLATION PAYMENTS
($ MMs)
*  Total Cancellation Payments = Total Enron Exposure
Spreadsheet: darrell_schoolcraft__7306__imball0201
Sheet: mewborne

 | [NAME]
 | 500174 |  | 53888 |  | 78060 |  | 78062
Day | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled | Measured | Scheduled
1 | 5471 | 5741 | 1041 | 1125 | 1062 | 872 | 1490 | 1123
2 | 5369 | 5741 | 815 | 1125 | 1031 | 872 | 1504 | 1123
3 | 5302 | 5741 | 762 | 1125 | 986 | 872 | 1644 | 1123
4 | 3429 | 5741 | 400 | 1125 | 953 | 872 | 1516 | 1123
5 | 5207 | 5741 |  | 1125 | 927 | 872 | 1465 | 1123
6 | 5669 | 5741 | 358 | 1125 | 921 | 872 | 1438 | 1123
7 | 6151 | 5741 |  | 1125 | 821 | 872 | 1413 | 1123
8 | 6148 | 5741 | 678 | 1125 | 1002 | 872 | 1398 | 1123
9 | 5873 | 5741 | 803 | 1125 | 979 | 872 | 1695 | 1123
10 | 5548 | 5741 | 1069 | 1124 | 985 | 872 | 1531 | 1123
11 | 5525 | 5741 | 1322 | 125 | 994 | 872 | 1481 | 1123
12 | 5676 | 5741 | 1071 | 125 | 969 | 872 | 1439 | 1123
13 | 5786 | 5741 | 746 | 125 | 983 | 872 | 1427 | 1123
14 | 6107 | 5741 | 962 | 125 | 617 | 872 | 1418 | 1123
15 | 6068 | 5741 | 777 | 125 | 811 | 872 | 1663 | 1123
16 | 6099 | 5741 | 484 | 95 | 1066 | 662 | 1472 | 1123
17 | 5842 | 4241 | 584 | 125 | 1015 | 872 | 1444 | 1123
18 | 5631 | 4241 | 401 | 125 | 1000 | 872 | 1409 | 1123
19 | 5880 | 4241 | 494 | 125 | 985 | 872 | 1397 | 1123
20 | 5148 | 4241 | 540 | 125 | 986 | 872 | 1373 | 1123
21
22
23
24 |  |  |  |  |  |  |  |  |  |  | 377
25 |  |  |  |  |  |  |  |  |  |  | 725
26
27
28
29
30
31
2001-12-31 00:00:00 |  |  |  |  |  |  |  |  | 406899.92
2002-01-20 00:00:00
CBS Volume
 |  |  | 166968
Spreadsheet: 1b01b32c-bc6e-4f14-8b9a-f0f7ae42cbfd
Sheet: Sheet1

Date | GMT Start | GMT End | Memphis Start | Memphis End | Notes
2011-02-17 00:00:00 | 16:00:00 | 20:00:00 | 10:00:00 | 14:00:00 | R16 x 2
2011-02-18 00:00:00 | 01:00:00 | 05:00:00 | 19:00* | 23:00* | R16 x 2
 | 16:00:00 | 20:00:00 | 10:00:00 | 14:00:00 | QF 1 & 2
2011-02-19 00:00:00 | 01:00:00 | 05:00:00 | 19:00* | 23:00* | QF 3 & 4
 | 17:00:00 | 19:30:00 | 11:00:00 | 13:30:00 | SF 1
 | [NAME] | 23:30:00 | 15:00:00 | 17:30:00 | SF 2
2011-02-20 00:00:00 | [NAME] | 00:00:00 | 15:00:00 | 18:00:00 | Final
* Previous day
Spreadsheet: phillip_platter__31370__dailygasandpower
Sheet: Sheet6

MonthNum | (All)
monthname | Oct
PeakorOffPeak | (All)
YearNum | 2001
 | ZoneCode | Data | Description
 | NP
 | Sum of Price | Average of GASPrice
CADateTime | NP15(PG&E-CityGate) | NP15(PG&E-CityGate)
2001-10-03 00:00:00 | 26.75 | 5.985000133514404
2001-10-04 00:00:00 | 25.48999977111816 | 5.824999809265137
2001-10-05 00:00:00 | 24.1200008392334 | 5.559999942779541
2001-10-06 00:00:00 | 24.1200008392334 | 5.715000152587891
Spreadsheet: 792719d1661098486-summarizing-weeklies-into-a-monthly-2022-08-21-oeldere2-ryba-testrunyearxls
Sheet: Month01

ID | Name | 01-01 | 02-01 | 03-01 | 04-01 | 05-01 | 06-01 | 07-01 | 08-01 | 09-01 | 10-01 | 11-01 | 12-01 | 13-01 | 14-01 | 15-01 | 16-01 | 17-01 | 18-01 | 19-01 | 20-01 | 21-01 | 22-01 | 23-01 | 24-01 | 25-01 | 26-01 | 27-01 | 28-01 | 29-01 | 30-01 | 31-01
100 | [NAME] |  |  |  |  |  |  |  |  | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33
101 | [NAME] |  |  |  |  |  |  |  |  | 11 | 12 | 13 | 4 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33
102 | Fredericson |  |  |  |  |  |  |  |  | 11 | 12 | 13 | 14 | 15 | 16 | 21 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33
103 | [NAME] |  |  |  |  |  |  |  |  | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 32 | 33
104 | Oeldere |  |  |  |  |  |  |  | 18 | 18 | 18 | 18 | 18
105 | Another member |  |  | 4
Spreadsheet: 483365d1475610800-remove-duplicates-function-delete-duplicate-example
Sheet: Sheet1

Color | Shape | Size
Red | Square | 1
Orange | Triangle | 2
Yellow | Rectangle | 3
Green | Heptagon | 4
Blue | Ellipse | 5
Indigo | Circle | 6
Violet | Parallelogram | 7
Red | Square | 1
Spreadsheet: 871293d1717676566-formula-to-pull-the-header-details-onto-the-line-details-rows-sample-book
Sheet: Sheet1

 |  |  | Current report
 |  | A/C: | BEE 001 |  |  | Name: | [NAME] |  | Contact:
 |  | No |  |  |  | Type | Date | Reference |  | Balance
 |  | 999-[PHONE] |  |  |  | SI | 2023-01-10 00:00:00 | Inv 1234 |  | 100
 |  | 999-[PHONE] |  |  |  | SI | 10/31/2023 | Inv 1237 |  | 175
 |  | 999-[PHONE] |  |  |  | SI | 2023-12-11 00:00:00 | Inv 1239 |  | 200
 |  | 999-[PHONE] |  |  |  | SI | 11/30/2023 | Inv 1245 |  | 75
 |  | 999-[PHONE] |  |  |  | SI | 12/17/2023 | Inv 1275 |  | 82
 |  | 999-[PHONE] |  |  |  | SI | 12/31/2023 | Inv 1282 |  | 100
 |  |  |  |  |  |  |  | Customer Totals:
 |  | A/C: | ABC 001 |  |  | Name: | [NAME] |  | Contact:
 |  | No |  |  |  | Type | Date | Reference |  | Balance
 |  | 999-[PHONE] |  |  |  | SI | 2023-01-10 00:00:00 | Inv 1235 |  | 300
 |  | 999-[PHONE] |  |  |  | SC | 12/31/2023 | Inv 1236 |  | -100
 |  | 999-[PHONE] |  |  |  | SI | 3/31/2024 | Inv 1290 |  | 150
 |  | 999-[PHONE] |  |  |  | SI | 3/31/2024 | Inv 1301 |  | 150
 |  |  |  |  |  |  |  | Customer Totals:
 |  | The desired report
 |  | A/C: | BEE 001 |  |  | Name: | [NAME] |  | Contact:
 |  | No |  |  |  | Type | Date | Reference |  | Balance
 |  | 999-[PHONE] |  | BEE 001 | [NAME] | SI | 2023-01-10 00:00:00 | Inv 1234 |  | 100
 |  | 999-[PHONE] |  | BEE 001 | [NAME] | SI | 10/31/2023 | Inv 1237 |  | 175
 |  | 999-[PHONE] |  | BEE 001 | [NAME] | SI | 2023-12-11 00:00:00 | Inv 1239 |  | 200
 |  | 999-[PHONE] |  | BEE 001 | [NAME] | SI | 11/30/2023 | Inv 1245 |  | 75
 |  | 999-[PHONE] |  | BEE 001 | [NAME] | SI | 12/17/2023 | Inv 1275 |  | 82
 |  | 999-[PHONE] |  | BEE 001 | [NAME] | SI | 12/31/2023 | Inv 1282 |  | 100
 |  |  |  |  |  |  |  | Customer Totals: |  | 732
 |  | A/C: | ABC 001 |  |  | Name: | [NAME] |  | Contact:
 |  | No |  |  |  | Type | Date | Reference |  | Balance
 |  | 999-[PHONE] |  | ABC 001 | [NAME] | SI | 2023-01-10 00:00:00 | Inv 1235 |  | 300
 |  | 999-[PHONE] |  | ABC 001 | [NAME] | SC | 12/31/2023 | Inv 1236 |  | -100
 |  | 999-[PHONE] |  | ABC 001 | [NAME] | SI | 3/31/2024 | Inv 1290 |  | 150
 |  | 999-[PHONE] |  | ABC 001 | [NAME] | SI | 3/31/2024 | Inv 1301 |  | 150
 |  |  |  |  |  |  |  | Customer Totals: |  | 500
Spreadsheet: 876153d1722846756-need-formula-for-tier-incentive-calculation-calculation-doing-formula-etaf
Sheet: Dr. Alaa Kutaish (2)

Contract Terms (*)
 |  | Description | Commission
 |  | Consumables up to 30% not deducted, over 30% the difference is deducted
 |  | Revenue up to SAR 500,000 | 0.5
 |  | Revenue over SAR 500,000 (Rev. - SAR 500,000) | 0.4
 |  | Ulthera Machine Revenue (After deducting depreciation) | 0.25
Doctor Calculation
 |  | Doctor Revenue | 87300
 |  | Consumables < 30% not to be deducted | 20673.6
 |  | Net Revenue
 |  | Revenue up to SAR 500,000 | 87300
 |  | Amount to be paid
 |  | Revenue over SAR 500,000
 |  | Amount to be paid
 |  | Total Amount to be Paid
 |  | Less Consumables (More Than 30%) | 0
 |  | Less Monthly Salary | 0
 |  | Less Salary of Karen Gaile (SAR 800) | 0
 |  | Net Amount to be Paid
Prepared By …................. |  |  | Sr. Finance Manager |  | .......................
Spreadsheet: 878625d1725801060-calculate-earliest-start-date-and-time-based-on-deadline-date-and-time-and-duration-calculate-earliest-start-date-and-time-based-on-deadline-date-and-time-and-duration
Sheet: Sheet1

Calculate earliest start date and time based on deadline date and time and duration
[NAME]
Deadline | Duration (hrs) | Start Date | Duration (hrs) |  |  | Operational Hours
 |  |  |  |  |  | Mon | Fri | Hrs
 |  |  |  |  |  | 09:00:00 | 17:00:00
Hours in deadline date/time
Remaining hours
No. of working days
Estimated start date
Difference in days
Remaining hours
Start date/time
No. of operational hours
Date
Spreadsheet: kimberly_watson__20556__imbalsumm0109
Sheet: Calpine

 | Calpine So. Point Power Del
 | 78113
Day | Measured | Scheduled
1 | -78239 | -85300
2 | -74226 | -85101
3 | -78758 | -71658
4 | -82504 | -65890
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
31
2001-08-31 00:00:00 |  |  | 81630
2001-09-04 00:00:00
CBS Volume
 |  |  | 130472
Spreadsheet: 151847d1335162119-using-vlookup-funtion-within-if-statement-vlookup-within-if
Sheet: DataLists

Members |  | Age |  | No of Persons | Currespondent. Member |  | Sum Insured (in Lacks) | Group Name
Member 1 |  | 0-25YRS |  | 1A | Member 1 |  | 2
Member 2 |  | 26-35YRS |  | 1C | Member 1 |  | 3
Member 3 |  | 36-40YRS |  | 2A | Member 2 |  | 4
Member 4 |  | 41-45YRS |  | 1A+1C | Member 2 |  | 5
Member 5 |  | 46-50 YRS |  | 2C | Member 2 |  | 7.5
Member 6 |  | 51-55 YRS |  | 2A+1C | Member 3 |  | 10
Member 7 |  | 56-60 YRS |  | 3A | Member 3 |  | 15
Member 8 |  | 61-65 YRS |  | 1A+2C | Member 3
Member 9 |  |  |  | 3C | Member 3
Member 10 |  |  |  | 1A+3C | Member 4
Member 11 |  |  |  | 2A+2C | Member 4
Member 12 |  |  |  | 3A+1C | Member 4
Member 13 |  |  |  | 4A | Member 4
Member 14 |  |  |  | 4C | Member 4
 |  |  |  | 1A | Member 4
Spreadsheet: a47c603e-ae92-4940-a535-b1df72ecd554
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SNOWSHOE | T1 | SKATE | T2 | SKI | POSITION | TOTAL TIME
6421 | 46345 | [NAME] | Marttinen | FIN | 154 | 00:15:20 | 00:00:00 | 00:34:56 | 00:00:00 | 00:20:36 | 1 | 01:10:53
Spreadsheet: 09bff0b0-1ab6-40a8-92da-b7e98b454ee1
Sheet: Reference

DEFINITIONS
Year | This should be the model year.
Bus # | Bus Numbers must be unique.  You CAN NOT use the same bus number on two
 | different busses in the same year.
Serial Number | Please verify the accuracy of the Serial Number.
Purchase Year | This should be the year purchase and may differ from the model year.
Seating Capacity | This should be the maximum seating capacity as configured.
Body | See options below
Engine Model | See options below
Bus Type | See options below
Auto Trans | True or False.  Either it has or does not have an automatic transmission.
Diesel | True or False.  Either it has or does not have a diesel engine.
Wheel Chair | True or False.  Either it has or does not have a wheel chair lift.
Original Cost | The amount you paid for the bus including delivery fees.
Beginning Odometer | The beginning odometer reading should be the same as last years ending reading.
Ending Odometer | The ending odometer reading should be the reading at the end of business on the
 | last day of the fiscal year.
Spare | True or False.  Either it is or is not a spare bus.
Date Received | Should indicate the date the bus was received.
Disposal Date | If you dispose of a bus please list the date it left your fleet.
Body
1 | Amtran
2 | Asia Smith
3 | [NAME]
4 | [NAME]
5 | Coach
6 | [NAME]
7 | Crown
8 | Gillig
9 | Midbus
10 | Superior
11 | [NAME]
12 | Tran Prod Inc
13 | Van-Con
14 | Wayne
15 | Other
Engine Model
1 | Chevrolet
2 | Dodge
3 | Ford
4 | GMC
5 | [NAME].
6 | Diesel cummings
7 | Diesel Cat
8 | Diesel Detroit
9 | CNG Cummings
10 | CNG Chevrolet
11 | CHG [NAME]
12 | Mercedes
15 | Other
Bus Type
A | A Type "A" school bus is a conversion or body constructed upon a van-type or cutaway
 | front-section vehicle with a left-side driver’s door, designed for carrying more than 10 persons. This definition
 | shall include two classifications: Type A-I, with a Gross Vehicle Weight Rating (GVWR) over 10,000 pounds
 | and Type A-II, with a GVWR of 10,000 pounds and under.
B | A Type "B" school bus is a conversion or body constructed and installed upon a van
 | or front-section vehicle chassis, or stripped chassis, with a GVWR of more than 10,000 pounds, and designed
 | to carry more than 10 persons including the driver. Part of the engine is beneath and/or behind the windshield
 | and beside the driver's seat. The entrance door is behind the front wheels.
C | A Type "C" school bus is a body installed upon a flat back cowl chassis with a GVWR
 | of more than 10,000 pounds that is designed for carrying more than ten persons including the driver. All of
 | the engine is in front of the windshield and the entrance door is behind the front wheels.
D | A Type "D" school bus is a body installed upon a chassis, with the engine mounted in
 | the front, midships, or rear, with a GVWR of more than 10,000 pounds, designed to carry more than 10
 | persons including the driver. The engine may be behind the windshield and beside the driver's seat, at the
 | rear of the bus, behind the rear wheels, or midships between the front and rear axles. The entrance door is
 | ahead of the front wheels.
Spreadsheet: 813462d1673796236-solved-list-of-data-displayed-based-on-a-single-criteria-car-dealership-location-and-type-of-cars
Sheet: Sheet1

 | Based On Data Below |  |  |  |  |  |  | Location | Car Dealership B |  | List of Vehicles | Price | Discounted Price
 |  |  |  | Price | Sale / Discount | Discounted Price |  |  |  |  | Red Truck | 9275 | 8625.75
 | Car Dealership A |  | Red Truck | 16500 |  |  |  |  |  |  | Blue Truck | 14583 | 13562.19
 | Car Dealership A |  | Blue Truck | 18300 |  |  |  |  |  |  | Black Car | 43500 | 40455
 | Car Dealership A |  | Black Car | 24540 |  |  |  |  |  |  | Blue Car | 25309 | 23537.37
 | Car Dealership A |  | Blue Car | 32002 |  |  |  |  |  |  | Grey Car | 13546 | 12597.78
 | Car Dealership A |  | Grey Car | 8549
 | Car Dealership B |  | Red Truck | 9275
 | Car Dealership B |  | Blue Truck | 14583
 | Car Dealership B |  | Black Car | 43500
 | Car Dealership B |  | Blue Car | 25309
 | Car Dealership B |  | Grey Car | 13546
 | Car Dealership C |  | Red Truck | 25467
 | Car Dealership C |  | Blue Truck | 29432
 | Car Dealership C |  | Black Car | 24121
 | Car Dealership C |  | Blue Car | 32123
 | Car Dealership C |  | Grey Car | 42345
 | Car Dealership D |  | Red Truck | 17343
 | Car Dealership D |  | Blue Truck | 14256
 | Car Dealership D |  | Black Car | 22354
 | Car Dealership D |  | Blue Car | 12623
 | Car Dealership D |  | Grey Car | 11826
 | Car Dealership D |  | White Convertible | 22556
Spreadsheet: 96ec7ba6-89f0-4de1-9f18-d0399f0d81c2
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
EHOR | Test | EHOR | [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
EHOR | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
EHOR | Result | EHOR | [NAME], IgE | [NAME], IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 15342-9
Spreadsheet: 802172d1666691709-raffle-sheet-formula-for-random-draw
Sheet: Sheet1

 | Total Tickets Sold
 | 10
 | Winning Number |  |  | Cells B4 and [NAME] to update on button press and not when pressing enter
 | 3
 | [NAME]
 | [NAME]
Name | Tickets | Lookup
[NAME] | 2 | 0
[NAME] | 2 | 2
[NAME] | 6 | 4
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
 |  | 10
Spreadsheet: 753668d1635618394-creating-a-hierarchy-structure-with-formulas-sample1-1-
Sheet: Example of After

1 | 2 | 3 | 4
Period
 | YearTotal
 |  | Q1
 |  |  | Jan
 |  |  | Feb
 |  |  | Mar
 |  | Q2
 |  |  | Apr
 |  |  | May
 |  |  | Jun
 |  | Q3
 |  |  | Jul
 |  |  | Aug
 |  |  | Sep
 |  | Q4
 |  |  | Oct
 |  |  | Nov
 |  |  | Dec
Spreadsheet: 33925d1230847134-sum-skipping-columns-and-date-dependent-book1
Sheet: Sheet1

 | 1st Quarter |  |  |  |  |  |  |  |  |  | 2nd Quarter |  |  |  |  |  |  |  |  |  | 3rd Quarter |  |  |  |  |  |  |  |  |  | 4th Quarter |  |  |  |  |  |  |  |  |  | Year-to-date
Desc. | 2009-01-31 00:00:00 | Budget | 2009-02-28 00:00:00 | Budget | 2009-03-31 00:00:00 | Budget | Total | Budget | [NAME] | Var. % | 2009-04-30 00:00:00 | Budget | 2009-05-31 00:00:00 | Budget | 2009-06-30 00:00:00 | Budget | Total | Budget | [NAME] | Var. % | 2009-07-31 00:00:00 | Budget | 2009-08-31 00:00:00 | Budget | 2009-09-30 00:00:00 | Budget | Total | Budget | [NAME] | Var. % | 2009-10-31 00:00:00 | Budget | 2009-11-30 00:00:00 | Budget | 2009-12-31 00:00:00 | Budget | Total | Budget | [NAME] | Var. % | Total | Budget | [NAME] | Var. %
Line 1 |  | 100 |  | 100 |  | 105 |  | 305 |  |  |  | 100 |  | 105 |  | 100 |  | 305 |  |  |  | 100 |  | 100 |  | 75 |  | 275 |  |  |  | 75 |  | 100 |  | 100 |  | 275 |  |  |  | ?
Line 2 |  | 125 |  | 125 |  | 115 |  | 365 |  |  |  | 125 |  | 115 |  | 125 |  | 365 |  |  |  | 125 |  | 125 |  | 85 |  | 335 |  |  |  | 75 |  | 125 |  | 125 |  | 325 |  |  |  | ?
Line 3 |  | 75 |  | 75 |  | 100 |  | 250 |  |  |  | 75 |  | 100 |  | 105 |  | 280 |  |  |  | 75 |  | 75 |  | 95 |  | 245 |  |  |  | 85 |  | 75 |  | 75 |  | 235 |  |  |  | ?
Line 4 |  | 150 |  | 135 |  | 150 |  | 435 |  |  |  | 135 |  | 150 |  | 125 |  | 410 |  |  |  | 150 |  | 135 |  | 75 |  | 360 |  |  |  | 105 |  | 150 |  | 135 |  | 390 |  |  |  | ?
Problem: | How to populate cells AQ4:AQ7 (Budget Year to Date) depending on date selected in B17 i.e. if April is selected in B17, AQ4 would contain the total budget figures
 | for January, Febrruary, March and April
Date | 2009-04-30 00:00:00
 | 2009-01-31 00:00:00
 | 2009-02-28 00:00:00
 | 2009-03-31 00:00:00
 | 2009-04-30 00:00:00
 | 2009-05-31 00:00:00
 | 2009-06-30 00:00:00
 | 2009-07-31 00:00:00
 | 2009-08-31 00:00:00
 | 2009-09-30 00:00:00
 | 2009-10-31 00:00:00
 | 2009-11-30 00:00:00
 | 2009-12-31 00:00:00
Spreadsheet: 109571d1306398223-multiple-query-results-1-
Sheet: Sheet2

 | DATA NASCIMENTO | HOJE | IDADE ([NAME] 1 casa decimal) |  |  | Capital | Resultado
PARA CALCULAR A IDADE | 1969-07-14 00:00:00 | 2011-05-26 00:00:00 | #N/A |  |  | Até 75000€ | QM
 |  |  |  |  |  | 75000€ a 150000€ | 1
 |  |  |  |  |  | 150001€ a 250000€ | 2
 |  |  |  |  |  | 250001€ a 350000€ | 3
 |  |  |  |  |  | 350001€ a 450000€ | 4
 |  |  |  |  |  | 450001€ a 550000€ | 5
 |  |  |  |  |  | Mais de 550000€ | 6
 |  |  |  |  |  |  | 7
 |  |  |  |  |  |  | 8
 |  |  |  |  |  |  | 9
 |  |  |  |  |  |  | 10
Spreadsheet: 848568d1699285894-split-range-sample
Sheet: Sheet1

Boxes | Range |  | Boxes | [NAME]
1 | 1-3 |  | 1 | 1 |  |  | 1
2 | 9-12 |  | 1 | 2 |  | 1 | 2
3 | 5-8 |  | 1 | 3 |  | 1 | 3
 |  |  | 2 | 9 |  | 2 | 9
 |  |  | 2 | 10 |  | 2 | 10
 |  |  | 2 | 11 |  | 2 | 11
 |  |  | 2 | 12 |  | 2 | 12
 |  |  | 3 | 5 |  | 3 | 5
 |  |  | 3 | 6 |  | 3 | 6
 |  |  | 3 | 7 |  | 3 | 7
 |  |  | 3 | 8 |  | 3 | 8