tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 4797ef71-c63f-4a25-9942-27daf9ae4a5b
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
ASCRI | Test | ASCRI | [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
ASCRI | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
ASCRI | Result | ASCRI | [NAME], IgE | [NAME], IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 6022-8
Spreadsheet: 850166d1700556905-how-can-i-filter-exract-data-based-on-condition-test_file-1-aligw
Sheet: Sheet 1

Material | ŠSP | Name | Pos
500853 | 2 | [NAME] | 20 |  |  |  |  | 2 | [NAME] | 20
500853 | 3 | [NAME] | 30 |  |  |  | 500853 | 3 | [NAME] | 30
501311 | 4 | Aged Suede | 10 |  |  |  | 501311 | 4 | Aged Suede | 10
501311 | 5 | Aged Suede | 10 |  |  |  | 501587 | 5 | Bubblesteel | 10
501587 | 5 | Bubblesteel | 10 |  |  |  | 501591 | 4 | Lost Weave | 10
501591 | 4 | Lost Weave | 10 |  |  |  | 501591 | 4 | Lost Weave | 20
501591 | 4 | Lost Weave | 20 |  |  |  | 501595 | 3 | [NAME] | 10
501595 | 3 | [NAME] | 10 |  |  |  | 501682 | 4 | Trueskin | 10
501595 | 6 | [NAME] | 10 |  |  |  | 501682 | 7 | Trueskin | 20
501682 | 4 | Trueskin | 10 |  |  |  | 501763 | 4 | Halflog | 10
501682 | 5 | Trueskin | 10 |  |  |  | 501763 | 7 | Halflog | 20
501682 | 6 | Trueskin | 10 |  |  |  | 501879 | 4 | Aerosteel | 10
501682 | 7 | Trueskin | 10 |  |  |  | 501879 | 7 | Aerosteel | 20
501682 | 7 | Trueskin | 20 |  |  |  | 502090 | 4 | Breathcobalt | 10
501682 | 8 | Trueskin | 10
501763 | 4 | Halflog | 10
501763 | 5 | Halflog | 10
501763 | 6 | Halflog | 10
501763 | 7 | Halflog | 10
501763 | 7 | Halflog | 20
501763 | 8 | Halflog | 10
501879 | 4 | Aerosteel | 10
501879 | 5 | Aerosteel | 10
501879 | 6 | Aerosteel | 10
501879 | 7 | Aerosteel | 10
501879 | 7 | Aerosteel | 20
501879 | 8 | Aerosteel | 10
502090 | 4 | Breathcobalt | 10
502090 | 5 | Breathcobalt | 10
Spreadsheet: 110189d1306932470-help-with-data-arrangement-timetablesummary
Sheet: Sheet1

 |  | CPT | LHR | MUC | FRA
 | SYD
 | HKG
 | LAX
 | MIA
 | CDG
 | ORY
Spreadsheet: 111974d1308176061-need-help-with-a-formula-time-sheet
Sheet: Sheet1

Employee |  |  |  |  |  |  |  |  | Week Ending
Employees who work 5 or more consecutive hours between the hours of 7:00 pm and 7:00 am will receive shift differential (night time pay)
in addition to their regular rate of pay for the entire shift worked.  All night work or work outside core business hours (roughly 7:00 am - 7:00 pm)
must be approved by supervisor in advance.
Job No. | Job Name |  |  |  | Phase  Code | L&I Class | Description of Work |  |  |  | THU |  | FRI |  | SAT |  | SUN |  | MON |  | TUES |  | WED |  | TOTAL
 |  |  |  |  |  |  |  |  |  |  | D | N | D | N | D | N | D | N | D | N | D | N | D | N | D | N
 |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0 | 0 |  |  |  |  | 0 | 0 | 0 | 0 | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  | 0 |  |  |  |  |  |  |  | 0 |  | 0 | 0 | 0
 |  |  |  |  |  |  | TOTAL HOURS
 |  |  |  |  |  |  | OVERTIME HOURS |  |  |  | 0 |  | 0 |  |  |  |  |  | 0 |  | 0 |  | 0
 |  |  |  |  | PARKING REIMBURSEMENT ($5 DAY MAX-RECEIPTS MUST BE ATTACHED)
EMPLOYEE ACKNOWLEDGEMENT
By signing below, I acknowledge that these hours are correct; I have reported all accidents
and/or injuries to my supervisor; and that I have attended the jobsite weekly safety meeting.
Please make notes/comments in box to right if otherwise.
Employee Signature
Project Manager Approval
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | L&I Codes
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0217   Concrete Flatwork
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0510   Wood Frame Bldg Construction
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0513   Interior Finish Carpentry
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0516   Building Repair/Carpentry NOC
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0603   Machinery Install Mirit Wk NOC
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4904   Clerical Office NOC & Draftsman
Spreadsheet: 71331d1272000300-vlookup-blade-chart
Sheet: Sheet1

MASONARY OPENING                  WIDTH (INCHES) | NUMBER OF  BLADES | FINISHED TRACK WIDTH (INCHES) | [NAME] (INCHES)
6 | 2 | 11 | 5.125
11.75 | 4 | 17.5 | 5.75
17.5 | 6 | 24 | 6.375
23.25 | 8 | 30.25 | 7
29 | 10 | 36.75 | 7.625
35 | 12 | 43 | 8.25
40.75 | 14 | 49.5 | 8.875
46.5 | 16 | 56 | 9.5
52.25 | 18 | 62.5 | 10.125
58 | 20 | 69 | 10.75
64 | 22 | 75.5 | 11.375
69.75 | 24 | 81.75 | 12
75.5 | 26 | 88 | 12.625
81.5 | 28 | 94.75 | 13.25
87 | 30 | 101 | 13.875
93 | 32 | 107.5 | 14.5
98 | 34 | 114 | 15.125
104.75 | 36 | 120.5 | 15.75
110.5 | 38 | 127 | 16.375
116.25 | 40 | 133.25 | 17
122 | 42 | 139.75 | 17.625
128 | 44 | 146 | 18.25
133.75 | 46 | 152.5 | 18.875
139.5 | 48 | 159 | 19.5
145.25 | 50 | 165.5 | 20.125
151 | 52 | 172 | 20.75
157 | 54 | 178.5 | 21.375
162.75 | 56 | 184.75 | 22
168.5 | 58 | 191 | 22.625
174.5 | 60 | 197.75 | 23.25
180 | 62 | 204 | 23.875
186 | 64 | 210.5 | 24.5
192 | 66 | 217 | 25.125
197.75 | 68 | 223.5 | 25.75
203.5 | 70 | 230 | 26.375
209.25 | 72 | 236.25 | 27
215 | 74 | 242.75 | 27.625
221 | 76 | 249 | 28.25
226.75 | 78 | 255.5 | 28.875
232.5 | 80 | 262 | 29.5
238.25 | 82 | 266.5 | 30.125
244 | 84 | 274.75 | 30.75
250 | 86 | 281.5 | 31.375
255.75 | 88 | 287.75 | 32
262.5 | 90 | 294 | 32.625
267.5 | 92 | 300.75 | 33.25
273 | 94 | 307 | 33.875
279 | 96 | 313.5 | 34.5
285 | 98 | 320 | 35.125
290.75 | 100 | 326.5 | 35.75
296.5 | 102 | 333 | 36.375
302.25 | 104 | 339.25 | 37
308 | 106 | 345.75 | 37.625
314 | 108 | 352 | 38.25
319.75 | 110 | 358.5 | 38.875
325.5 | 112 | 365 | 39.5
331.5 | 114 | 372.5 | 40.125
337 | 116 | 378 | 40.75
343 | 118 | 384.5 | 41.375
348.75 | 120 | 390.75 | 42
354.75 | 122 | 397 | 42.625
360.5 | 124 | 403.75 | 43.25
366 | 126 | 410 | 43.875
372 | 128 | 416.5 | 44.5
378 | 130 | 423 | 45.125
383.75 | 132 | 429.5 | 45.75
389.5 | 134 | 436 | 46.375
395.25 | 136 | 442.25 | 47
401 | 138 | 448.75 | 47.625
407 | 140 | 455 | 48.25
Spreadsheet: 51586d1251231153-how-to-match-data-from-two-almost-identical-lists-coordinates
Sheet: Sheet2

Engagement | Area | Production | Latitude | Longitude
Big Farm - 2009 | 10 | 4000 | N 0° 0’ 1’’ | W 0° 0’ 1’’
Big Farm - 2009 | 10 | 4000 | N 0° 0’ 1’’ | W 0° 0’ 1’’
Big Farm - 2009 | 10 | 4000 | N 0° 0’ 1’’ | W 0° 0’ 1’’
Green Farm - 2009 | 5 | 6500 | S 0° 0’ 2’’ | E 0° 0’ 2’’
Green Farm - 2009 | 5 | 6500 | S 0° 0’ 2’’ | E 0° 0’ 2’’
Spreadsheet: 751607d1634207247-use-sumifs-to-look-up-specific-date-dd-mm-yyyy-based-on-just-month-as-criteria-excel-forum
Sheet: sheet 1 

MARKETPLACE | PROGRAM_TYPE | TRANSACTION_TYPE | TAX_CALCULATION_DATE | PRICE_OF_ITEMS_AMT_VAT_EXCL
amazon.co.uk | REGULAR | SALE | 2021-09-29 00:00:00 | 74.94
amazon.co.uk | REGULAR | SALE | 2021-09-29 00:00:00 | 12.49
amazon.co.uk | REGULAR | SALE | 2021-09-30 00:00:00 | 24.99
amazon.co.uk | REGULAR | SALE | 2021-09-30 00:00:00 | 3.32
amazon.co.uk | REGULAR | SALE | 2021-09-29 00:00:00 | 3.41
amazon.co.uk | REGULAR | SALE | 2021-09-30 00:00:00 | 14.98
amazon.co.uk | REGULAR | SALE | 2021-09-30 00:00:00 | 6.66
amazon.co.uk | REGULAR | SALE | 2021-08-01 00:00:00 | 4.57
amazon.co.uk | REGULAR | REFUND | 2021-08-01 00:00:00 | 6.66
amazon.co.uk | REGULAR | SALE | 2021-08-01 00:00:00 | 0.82
amazon.co.uk | REGULAR | SALE | 2021-08-01 00:00:00 | 5.82
amazon.co.uk | REGULAR | SALE | 2021-08-01 00:00:00 | 23.32
amazon.co.uk | REGULAR | SALE | 2021-08-01 00:00:00 | 37.49
amazon.co.uk | REGULAR | SALE | 2021-08-01 00:00:00 | 5.82
amazon.co.uk | REGULAR | SALE | 2021-08-01 00:00:00 | 6.24
Spreadsheet: 753615d1635561049-autofill-numbers-out-of-order-book1
Sheet: Sub CO's

SUB CHANGE ORDERS
Sub | Cost Code | Date Change requested from Sub | Date Pricing Received from Sub | Date CO sent back to Sub | Pass on to owner? | PCO # | Sub cost | Description
Huff | 03 05 00 | 2021-08-01 00:00:00 | 2021-08-10 00:00:00 | 2021-08-11 00:00:00 | Yes |  | 1400
Leo | 04 21 13 | 2021-08-20 00:00:00 | 2021-09-02 00:00:00 | 2021-09-03 00:00:00 | No |  | 985
Smith | 05 10 00 | 2021-09-15 00:00:00 | 2021-09-21 00:00:00 | 2021-09-22 00:00:00 | No |  | 230
Aero | 23 31 00 | 2021-08-28 00:00:00 | 2021-09-25 00:00:00 | 2021-09-26 00:00:00 | Yes |  | 9250
Granite | 22 01 00 | 2021-09-28 00:00:00 | 2021-10-08 00:00:00 | 2021-10-09 00:00:00 | Yes |  | 3500
[NAME] | 09 29 00 | 2021-10-03 00:00:00 | 2021-10-08 00:00:00 | 2021-10-11 00:00:00 | No |  | 3250
Pine | 21 05 00 | 2021-10-15 00:00:00 | 2021-10-22 00:00:00 | 2021-10-25 00:00:00 | Yes |  | 7320
Spreadsheet: 796268d1663182672-excel-formula-to-return-multiple-values-based-off-of-multiple-criteria-2022-09-14-oeldere-chase-casey-book2-2-1-
Sheet: Sheet1

Value | Result | Value | Result | Value | Result
Hello | Hello | Goodbye | Goodbye | Hello | Aloha
Hello | Hello | Goodbye | Goodbye | Goodbye | Aloha
Hello | Hello | Goodbye | Goodbye | Hello | Aloha
Hello | Goodbye | Help
Hello | Goodbye | Goodbye
Hello | Goodbye | Help
 | For this example, in the attached I'm using "Hello" as Criteria/Return Value 1, "Goodbye" as Criteria/Return Value 2, and "Aloha" as Return Value 3 if both Criteria Values 1 & 2 are present within the range.
Example 1 |  |  | Example 2 |  |  | Example 2
Value | Result |  | Value | Result |  | Value | Result
Hello |  |  | Hello |  |  | Goodbye
Hello |  |  | Hello |  |  | Goodbye
Hello |  |  | Hello |  |  | Goodbye
Hello |  |  |  |  |  | Goodbye
Goodbye |  |  | Hello
Hello |  |  | Hello |  |  | Goodbye
Hello |  |  | Hello |  |  | Goodbye
Goodbye |  |  | Hello |  |  | Goodbye
 |  |  | Hello |  |  | Goodbye
Hello |  |  | Hello |  |  | Goodbye
IF both "Hello" and "Goodbye" are present in Range A18:A27, then the result is Aloha". If only "Hello" is present in Range A18:A27, then the result is "Hello". If only "Goodbye" is present in Range A18:A27, then the result is "Goodbye". "Goodbye".
Spreadsheet: darrell_schoolcraft__7317__imball0202
Sheet: MiVida_Rich

 | Mi Vida/Richardson Gas Treating
 | POI 500607 - Delhi/No Pyote
Day | Measured | Scheduled
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
31
2002-01-31 00:00:00 |  |  | -192231
2002-01-31 00:00:00
CBS Volume
 |  |  | -45944
Spreadsheet: 718592d1613224926-if-with-vlookup-index-match-match-genius-aligw
Sheet: example

 |  |  | vlookup with if function
 | [NAME]: | IZHAR | drop down |  |  |  |  | C4
 |  | IZHAR | INAM | AMIN | NOOR | SHAMS | AHSAN |  | Product | Price | Quantity | Total
 | Egg |  |  |  |  |  |  |  | Egg |  | 12
 | Milk |  |  |  |  |  |  |  | Milk |  | 3
 | Masala |  |  |  |  |  |  |  | Masala |  | 1
 | Salt Biscuit |  |  |  |  |  |  |  | Salt Biscuit |  | 5
 | Vinegar |  |  |  |  |  |  |  | Vinegar |  | 3
 |  |  |  |  |  |  |  |  |  |  | Total
Spreadsheet: b9401070-8e8a-4e77-8eb6-6c93fefd284c
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SWIM | T1 | BIKE | T2 | RUN | POSITION | TOTAL TIME
4358 | 17485 | Alberto | Ceriani B1 | ITA | 0 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 1 | 02:47:49
Spreadsheet: 180871d1347837365-correcting-a-formula-to-remove-old-references-cage-act-tracking-sample-
Sheet: Lists

ALL |  | ALL |  | ALL
Employee #01 |  | Supervisor #01 |  | Yes
Employee #02 |  | Supervisor #02 |  | No
Employee #03 |  | Supervisor #03
Employee #04 |  | Supervisor #04
Employee #05 |  | Supervisor #05
Employee #06 |  | Supervisor #06
Employee #07 |  | Supervisor #07
Employee #08 |  | Supervisor #08
Employee #09 |  | Supervisor #09
Employee #10 |  | Supervisor #10
Employee #11 |  | Supervisor #11
Employee #12 |  | Supervisor #12
Employee #13 |  | Supervisor #13
Employee #14 |  | Supervisor #14
Employee #15 |  | Supervisor #15
Employee #16
Employee #17
Employee #18
Employee #19
Employee #20
Employee #21
Employee #22
Employee #23
Employee #24
Employee #25
Employee #26
Employee #27
Employee #28
Employee #29
Employee #30
Employee #31
Employee #32
Employee #33
Employee #34
Employee #35
Employee #36
Employee #37
Employee #38
Employee #39
Employee #40
Employee #41
Employee #42
Employee #43
Employee #44
Employee #45
Employee #46
Spreadsheet: b2567e73-548c-4c46-9ebf-a5d99676320f
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | SNOWSHOE | T1 | SKATE | T2 | SKI | POSITION | TOTAL TIME
2689 | 6001 | Sarka | [NAME] | CZE | 0 | 00:27:24 | 00:00:00 | 00:25:23 | 00:00:00 | [NAME] | 1 | 01:21:40
2689 | 19464 | Natalia | Lovece | ARG | 0 | 00:34:45 | 00:00:00 | 00:39:54 | 00:00:00 | 00:36:57 | 2 | 01:51:36
2689 | 19466 | Analia | Villalba | ARG | 0 | 00:32:54 | 00:00:00 | 00:45:11 | 00:00:00 | 01:14:15 | 3 | 02:32:20
Spreadsheet: 834499d1687873564-meal-planner-and-automated-grocery-list-meal-plan
Sheet: Weekly Meal Plan

Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday |  | Sunday |  |  |  |  |  |  |  |  | Final Grocery LIst
Breakfast | Oatmeal | Breakfast |  | Breakfast |  | Breakfast |  | Breakfast |  | Breakfast | Pancake | Breakfast | Oatmeal
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Notes
Lunch |  | Lunch |  | Lunch |  | Lunch |  | Lunch |  | Lunch | Buy | Lunch | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | QTY | Item | Category
Dinner |  | Dinner |  | Dinner |  | Dinner |  | Dinner |  | Dinner | Fish taco | Dinner | Chicken fajita
Side |  | Side |  | Side |  | Side |  | Side |  | Side | No side | Side
Grocery List |  | Grocery List |  | Grocery List |  | Grocery List |  | Grocery List |  | Grocery List |  | Grocery List |  |  | Other Items |  |  | [NAME] Items
QTY | Item | QTY | Item | QTY | Item | QTY | Item | QTY | Item | QTY | Item | QTY | Item |  | QTY | Item |  | QTY | Item
 | Baguette |  |  |  |  |  |  |  |  | 1 | Pancake Mix | 3 | Bell Pepper-Tri Color |  |  |  |  | 1 | [NAME]
 |  |  |  |  |  |  |  |  |  | 1 | Milk | 2 | [NAME] |  |  |  |  | 1 | [NAME]
 |  |  |  |  |  |  |  |  |  | 1 | [NAME] | 1 | Bread |  |  |  |  | 1 | [NAME]
 |  |  |  |  |  |  |  |  |  | 3 | Avocado | 1 | Oatmeal
 |  |  |  |  |  |  |  |  |  | 1 | Lettuce | 1 | [NAME]
 |  |  |  |  |  |  |  |  |  | 1 | Bell Pepper-Tri Color
Spreadsheet: 017c279f-62b1-4863-9020-b0b47c34d96b
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5
--A report must be filed even if no tax is due--
(Make any necessary changes)
NAME
Location:
Number of Rooms
Reporting Period:
Due Date:
TOTAL GROSS RECEIPTS (Excluding Room Taxes): |  |  |  |  | $_________________
LESS ALLOWABLE EXEMPTIONS
Federal Officer/Employees |  |  |  |  | $_________________
Permanent Residents |  |  |  |  | $_________________
NET TAXABLE RECEIPTS: |  |  |  |  | $_________________
AMOUNT OF TAX AT 7%: |  |  |  |  | $_________________
PENALTY AND INTEREST IS DUE IF PAYMENT IS RECEIVED AFTER THE DUE DATE
5% Penalty on tax received not more than 30 days after due date |  |  |  |  | $_________________
5% Penalty on tax received more than 30 days after due date |  |  |  |  | $_________________
6% Interest per annum beginning 60 days after the due date |  |  |  |  | $_________________
AMOUNT OF PENALTY AND INTEREST DUE: |  |  |  |  | $_________________
TOTAL AMOUNT REMITTED: |  |  |  |  | $_________________
Signature__________________________Date___________Daytime Phone__________________
I declare that the information in this document is true and correct to the best of my knowledge and belief.
Return Report and Payment to: |  |  | City of Grand Prairie
 |  |  | Utility Customer Service
 |  |  | P.O. Box 534045
 |  |  | Grand Prairie, TX 75053-4045
 |  |  | (972) 237-8200
 |  |  | (972) 237-8206  FAX
Spreadsheet: 761459d1640910608-vlookup-of-sorts-steve1
Sheet: Sheet1

 | GREEN | 17 | 40
 | YELLOW | 1 | 42
 | RED | 2 | 38
 | MAGENTA | 3 | 44
 | CYAN | 4 | 46
 | CYAN | 9 | 48
 | CYAN | 10 | 36
 | CYAN | 11 | 42
 | CYAN | 18 | 40
 | CYAN | 19 | 40
 | CYAN | 20 | 42
 | CYAN | 21 | 38
 | CYAN | 22 | 44
 | CYAN | 23 | 46
 | CYAN | 24 | 48
 | CYAN | 5 | 36
 | CYAN | 6 | 42
 | CYAN | 7 | 40
 | CYAN | 8 | 40
 | CYAN | 12 | 42
 | CYAN | 13 | 38
 | CYAN | 14 | 44
 | BLACK | 15 | 46
 | PURPLE | 16 | 46
24 |  |  |  |  |  |  |  |  |  |  |  |  | 24
23 |  |  |  |  |  |  |  |  |  |  |  |  | 23
22 |  |  |  |  |  |  |  |  |  |  |  |  | 22
21 |  |  |  |  |  |  |  |  |  |  |  |  | 21
20 |  |  |  |  |  |  |  |  |  |  |  |  | 20
19 |  |  |  |  |  |  |  |  |  |  |  |  | 19
18 |  |  |  |  |  |  |  |  |  |  |  |  | 18
17 |  |  |  |  |  |  |  |  |  |  |  |  | 17 |  |  | GREEN
16 |  |  |  |  |  |  |  |  |  |  |  |  | 16
15 |  |  |  |  |  |  |  |  |  |  |  |  | 15
14 |  |  |  |  |  |  |  |  |  |  |  |  | 14
13 |  |  |  |  |  |  |  |  |  |  |  |  | 13
12 |  |  |  |  |  |  |  |  |  |  |  |  | 12
11 |  |  |  |  |  |  |  |  |  |  |  |  | 11
10 |  |  |  |  |  |  |  |  |  |  |  |  | 10
9 |  |  |  |  |  |  |  |  |  |  |  |  | 9
8 |  |  |  |  |  |  |  |  |  |  |  |  | 8
7 |  |  |  |  |  |  |  |  |  |  |  |  | 7
6 |  |  |  |  |  |  |  |  |  |  |  |  | 6
5 |  |  |  |  |  |  |  |  |  |  |  |  | 5
4 |  |  |  |  |  |  |  |  |  |  |  |  | 4
3 |  |  |  |  |  |  |  |  |  |  |  |  | 3 |  |  |  |  | MAGENTA
2 |  |  |  |  |  |  |  |  |  |  |  |  | 2 |  | RED
1 |  |  |  |  |  |  |  |  |  |  |  |  | 1 |  |  |  | YELLOW
 | 36 | 38 | 40 | 42 | 44 | 46 | 48
 | ABOVE - YELLOW IN [NAME] IS THERE BECAUSE C3=D52 SO PASTE B2 INTO [NAME]
 | RED IN C51 AS C4=[NAME] PASTE TO C51
 | ETC
 | needing formula for each cell -  b29 down and across h52
Spreadsheet: 164387d1340742250-how-to-correct-strange-formatting-issue
Sheet: Rain and Hail Production A

ACE Property and Casualty Insurance Company
2012 Iowa Crop-Hail Production Plan (CHPP) Insurance Rates per $100 Insurance
 |  | CHPP Yield
County |  | Modifier
063 Emmet |  | 1
Twp 98 |  | 1.05
Twp 99 Rges 31-32 |  | 1.1
063 Emmet |  | 1
Twp 99 Rges 33-34 |  | 1.05
Twp 100 |  | 1.1
065 Fayette |  | 1
067 [NAME] |  | 1
Twp 94 |  | 1.05
Twps 95-97 Rges 17-18 |  | 1.1
067 [NAME] |  | 1
Twps 95-97 Rges 15-16 |  | 1.05
069 Franklin |  | 1
Rges 19-20 |  | 1.05
069 Franklin |  | 1
Rges 21-22 |  | 1.05
071 Fremont |  | 1
Twp 67 |  | 1.05
071 Fremont |  | 1
Twps 68-70 |  | 1.05
073 Greene |  | 1
075 [NAME] |  | 1
Rges 15-16 |  | 1.05
075 [NAME] |  | 1
Rges 17-18 |  | 1.05
077 Guthrie |  | 1
079 [NAME] |  | 1
081 Hancock |  | 1
Twp 94 |  | 1.05
Twps 95-97 Rge 26 |  | 1.1
081 Hancock |  | 1
Twps 95-97 Rges 23-25 |  | 1.05
083 Hardin |  | 1
085 [NAME] |  | 1
087 Henry |  | 1
089 Howard |  | 1
091 Humboldt |  | 1
Rges 27-29 |  | 1.05
091 Humboldt |  | 1
Rge 30 |  | 1.05
[NAME] |  | 1
095 Iowa |  | 1
097 Jackson |  | 1
099 Jasper |  | 1
101 Jefferson |  | 1
103 [NAME] |  | 1
105 Jones |  | 1
107 Keokuk |  | 1
Rges 10-11 |  | 1.05
107 Keokuk |  | 1
Rges 12-13 |  | 1.05
109 Kossuth |  | 1
Twps 94-97 |  | 1.05
109 Kossuth |  | 1
Twps 98-100 |  | 1.05
111 [NAME] |  | 1
113 [NAME] |  | 1
115 Louisa |  | 1
117 Lucas |  | 1
119 Lyon |  | 1
Rges 43-45 |  | 1.05
119 Lyon |  | 1
Rges 46-49 |  | 1.05
121 [NAME] |  | 1
Twps 74-75 |  | 1.05
121 [NAME] |  | 1
Twps 76-77 |  | 1.05
123 Mahaska |  | 1
125 Marion |  | 1
127 [NAME] |  | 1
129 Mills |  | 1
131 Mitchell |  | 1
Rges 15-16 |  | 1.05
131 Mitchell |  | 1
Rges 17-18 |  | 1.05
133 Monona |  | 1
Rges 42-44 |  | 1.05
133 Monona |  | 1
Rges 45-47 |  | 1.05
135 [NAME] |  | 1
137 Montgomery |  | 1
139 Muscatine |  | 1
141 [NAME] |  | 1
143 Osceola |  | 1
145 Page |  | 1
147 Palo Alto |  | 1
Rges 31-33 |  | 1.05
147 Palo Alto |  | 1
Rge 34 |  | 1.05
149 Plymouth |  | 1
Twps 90-91 |  | 1.05
Twps 92-93 Rges 47-49 |  | 1.1
149 Plymouth |  | 1
Twps 92-93 Rges 43-46 |  | 1.05
151 Pocahontas |  | 1
Twp 90 |  | 1.05
151 Pocahontas |  | 1
Twps 91-93 |  | 1.05
153 Polk |  | 1
155 Pottawattamie |  | 1
156 West Pottawattamie |  | 1
157 Poweshiek |  | 1
159 Ringgold |  | 1
161 Sac |  | 1
Twps 86-87 |  | 1.05
161 Sac |  | 1
Twps 88-89 |  | 1.05
163 Scott |  | 1
165 Shelby |  | 1
167 Sioux |  | 1
Twps 94-95 |  | 1.05
Twps 96-97 Rges 46-48 |  | 1.1
167 Sioux |  | 1
Twps 96-97 Rges 43-45 |  | 1.05
169 Story |  | 1
Twps 82-83 |  | 1.05
169 Story |  | 1
Twps 84-85 |  | 1.05
171 Tama |  | 1
173 [NAME] |  | 1
Twps 67-68 |  | 1.05
173 [NAME] |  | 1
Twps 69-70 |  | 1.05
175 Union |  | 1
177 [NAME] |  | 1
179 Wapello |  | 1
181 Warren |  | 1
183 Washington |  | 1
185 Wayne |  | 1
187 [NAME] |  | 1
Twps 86-87 |  | 1.05
187 [NAME] |  | 1
Twps 88-90 |  | 1.05
189 Winnebago |  | 1
191 Winneshiek |  | 1
193 Woodbury |  | 1
195 Worth |  | 1
197 [NAME] |  | 1
Twps 90-91 |  | 1.05
197 [NAME] |  | 1
Twps 92-93 |  | 1.05
Spreadsheet: 103457d1301197527-how-to-assign-specific-cells-to-specific-values-based-on-an-incremental-variable-meida-funding-program
Sheet: Sheet1

Client |  | Scale Factor | 2 |  |  |  |  |  | Week 1 | Week 2 | Week 3 | Week 4 | Month 1 | Week 5 | Week 6 | Week 7 | Week 8 | Month 3 | Week 9 | Week 10 | Week 11 | Week 12 | Month 4 | Week 13 | Week 14 | Week 15 | Week 16 | Month 5 | Week 17 | Week 18 | Week 19 | Week 20 | Month 6
 |  | [NAME] (weeks) | 4 |  |  |  |  | Weekly Prepay
Daily [NAME] |  | Scale Progression | p/day | p/week | Weekly Prepay | Client Payment | Broker Profits | Client payment | 0
30 | week | 1 |  |  |  |  |  | Broker Profit (BP) | 0
Payout to Media | week |  |  |  |  |  |  | AOR Profit | 0
42 | week |  |  |  |  |  |  | BP Total to date | 0
Payout from Client | week |  |  |  |  |  |  | AOR Pr. to date | 0
46 | week |  |  |  |  |  |  | OLM Total Profit
 | week |  | 500
 | week
Spreadsheet: 682206d1591965287-multiple-layered-if-functions-or-better-use-of-small-largest-funtion-sample-sheet
Sheet: Sheet1

# | Job # | [NAME] Payment |  | Job # | Sorted DoP
1 | BS21 | 2020-06-02 00:00:00
2 | BS22 | 2020-06-01 00:00:00
3 | BS23 | 2020-06-03 00:00:00
Spreadsheet: 33465d1229876613-header-row-is-not-row-1-how-to-look-up-by-name-listed-in-another-row-excelforum1
Sheet: Sheet1

Vehicle Type: Oldsmobile Achieva (L4) 1997
Creation Date: 11/20/2008 5:09 PM
Notes:
[Markers]
1 | 1900-01-01 00:00:00 | Created with standalone data logging.
[Data]
Frame | Time | Engine RPM (SAE) rpm | Vehicle Speed (SAE) mph | Throttle Position (SAE) % | Trans Calculated Gear Ratio | Trans Current Gear
1 | 1900-01-01 00:00:00 | 869 | 8.08 | 0 | 1.563 | 2
2 | 1900-01-01 00:00:00 | 856 | 6.84 | 0 | 2.922 | 1
3 | 1900-01-01 00:00:00 | 860 | 6.21 | 0 | 2.922 | 1
4 | 1900-01-01 00:00:00 | 862 | 4.97 | 0 | 2.922 | 1
5 | 1900-01-01 00:00:00 | 862 | 4.35 | 0 | 2.922 | 1
6 | 00:00:01 | 854 | 3.73 | 0 | 2.922 | 1
7 | 00:00:01 | 853 | 3.11 | 0 | 2.922 | 1
Spreadsheet: 195158d1353432876-adding-text-in-a-cell-that-is-color-coded-count-of-names-1-
Sheet: Sheet1

 | [NAME] |  | Cleint 1 |  | [NAME] |  | 2
 | [NAME] |  | 2 |  | [NAME] |  | 1
 | [NAME] |  |  |  | [NAME] |  | 1
 | [NAME] |  |  |  | [NAME] |  | 1
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]
 | [NAME]