tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 22b6b72b-21a7-4304-a0d1-9a2fd0a5103c
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
LIS | Test | LIS | Lithium, Serum | Lithium, S | Spectrophotometric | Plain, Red-Top Tube: Red Serum Gel Tube: SGT |  |  | 1 | mL | Container/Tube: Red top [NAME]: 1 mL Collection Instructions: Draw blood 8 to 12 hours after last dose (trough specimen). Additional Information: Peak serum concentrations do not correlate with symptoms. | 0.4 mL | Hemolysis	Mild OK; Gross reject Thawing	Warm OK; Cold OK Lipemia	Mild OK; Gross reject Icterus	Mild OK; Gross reject Other	NA | Therapeutic concentration: 0.8-1.2 mmol/L (trough concentration) Toxic concentration: >1.6 mmol/L There is no relationship between peak concentration and degree of intoxication. | Monday through Sunday; Varies | Same day/1 day | 3 days | 1 | 80178 |  |  |  |  | Rochester
LIS | [NAME] | SRED | Serum Red |  |  |  | Refrigerated | 7 days
LIS | Result | 8384 | Lithium, S | Lithium, S | Numeric |  |  |  |  | mmol/L |  |  |  |  |  |  |  |  |  | 14334-7 | Lithium:SCnc:Pt:Ser/Plas:Qn:
Spreadsheet: 66830d1267523841-help-needed-trying-to-match-values-helpv2
Sheet: Results

Reporting Location | Sending Location | Receiving Location | Other Party | Equipment Code | Quantity | Shipment Date | Reference | Other Reference | Delivery Date | Del Point Code | Del Point Name
500511986 | 500511986 | [PHONE] |  | 1 | 4 | 2008-12-17 00:00:00 | 11030973 | EL1212N | 2008-12-17 00:00:00 | 8009001 | HYPERAMA PLC (CASH & CARRY DIV)
500511986 | 500511986 | [PHONE] |  | 1 | 4 | 2008-12-16 00:00:00 | 11030981 | 130940 | 2008-12-16 00:00:00 | 5529001 | CONTINENTAL WINE & FOOD LTD
500511986 | 500511986 | 100253886 |  | 1 | 5.013131313131313 | 2008-12-17 00:00:00 | 11030987 | 13467 | 2008-12-17 00:00:00 | 5511001 | GIBSONS WHOLESALE FOODS
500511986 | 500511986 | [PHONE] |  | 1 | 4.781818181818181 | 2008-12-17 00:00:00 | 11031006 | 44225 | 2008-12-17 00:00:00 | 5409001 | [NAME]
Spreadsheet: 861894d1709729940-return-blank-instead-of-0-with-sum-sumifs-formula-sample-1
Sheet: Projects

Project Name | Cash Out BU FY
Project A
Project B
Project C
Project D
Project E
Project F
Project G
Project H
Project I
Project J
Project K
Project L
Project M
Project N
Project O
Project P
Project Q
Project R
Project S
Project T
Spreadsheet: kate_symes__18710__NP 15 pages
Sheet: DJ NP15

 |  |  | Firm | Volume | Firm | Volume | Sunday & NERC | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | 24 HOUR | [NAME]
 | 2001-02-23 00:00:00 |  | 215.99 | 50624 | 158.85 | 20624
 | 2001-02-22 00:00:00 |  | 253.56 | 46656 | 179.33 | 2824
 | 2001-02-21 00:00:00 |  | 268.77 | 33504 | 198.68 | 16040
 | 2001-02-20 00:00:00 |  | 286.26 | 8880 | 216.91 | 3224
 | 2001-02-19 00:00:00 |  | 288.65 | 24912 | 233.15 | 15840
 | 2001-02-18 00:00:00 |  |  |  |  |  | 283.43 | 35232
 | 2001-02-17 00:00:00 |  | 326.1 | 15872 | 283.43 | 12024
 | 2001-02-16 00:00:00 |  | 437.9 | 29440 | 370.12 | 17208
 | 2001-02-15 00:00:00 |  | 437.9 | 29440 | 370.34 | 18008
 | 2001-02-14 00:00:00 |  | 319.81 | 40656 | 284.13 | 14112
 | 2001-02-13 00:00:00 |  | 284.75 | 33888 | 247.23 | 14448
 | 2001-02-12 00:00:00 |  | 252.44 | 33552 | 233.02 | 14640
 | 2001-02-11 00:00:00 |  |  |  |  |  | 233.02 | 43920
 | 2001-02-10 00:00:00 |  | 230.87 | 33120 | 229.16 | 17424
 | 2001-02-09 00:00:00 |  | 230.87 | 33120 | 229.16 | 17424
 | 2001-02-08 00:00:00 |  | 274.83 | 37456 | 223.07 | 17808
 | 2001-02-07 00:00:00 |  | 251 | 44352 | 218.57 | 14240
 | 2001-02-06 00:00:00 |  | 201.06 | 29952 | 192.99 | 12024
 | 2001-02-05 00:00:00 |  | 180.21 | 10352 | 164.84 | 1008
 | 2001-02-04 00:00:00 |  |  |  |  |  | 166.31 | 4200
 | 2001-02-03 00:00:00 |  | 211.99 | 15456 | 193.3 | 7832
 | 2001-02-02 00:00:00 |  | 215.28 | 26256 | 190.89 | 11032
 | 2001-02-01 00:00:00 |  | 280.34 | 28432 | 276.27 | 13400
 | 2001-01-31 00:00:00 |  | 333.27 | 24800 | 306.35 | 12400
 | 2001-01-30 00:00:00 |  | 314.59 | 22400 | 287.77 | 12784
 | 2001-01-29 00:00:00 |  | 286.67 | 15600 | 277.58 | 9504
 | 2001-01-28 00:00:00 |  |  |  |  |  | 278.94 | 33912
 | 2001-01-27 00:00:00 |  | 263.44 | 19760 | 211.66 | 6880
 | 2001-01-26 00:00:00 |  | 263.44 | 19760 | 211.66 | 6880
 | 2001-01-25 00:00:00 |  | 264 | 18800 | 197.99 | 8440
 | 2001-01-24 00:00:00 |  | 272.42 | 7920 | 181.28 | 4440
Spreadsheet: 158748d1338386324-if-function-which-follows-a-few-conditions-tool-booking-form
Sheet: LOCATION

TOOL LOCATION FORM
TOOL | BOOKED OUT TO | BOOKED OUT BY | DATE | BOOKED IN FROM | BOOKED IN BY | DATE | [NAME] |  |  | GLYNN & DANNY |  | ANDY HUMBY |  | JACKHAMMER
JACKHAMMER | DAVE & PAUL | DARREN HUDSON |  |  |  |  |  |  |  | DAVE & PAUL |  | PAUL LOMAX
 |  |  |  |  |  |  |  |  |  |  |  | DARREN HUDSON
Spreadsheet: 72797d1273524297-how-to-read-left-side-cell-value-to-the-comment-cell-test
Sheet: After

More info | Size | ID | Name
text1 | xxx | xxx | xxx
text2 | xxx | xxx | xxx
text3 | xxx | xxx | xxx
text4 | xxx | xxx | xxx
text5 | xxx | xxx | xxx |  | Note:
text6 | xxx | xxx | xxx |  | Size, ID, Name read from cell comments
text7 | xxx | xxx | xxx |  | data in "More Info" column is left side cell value of commented cell
[NAME] | xxx | xxx | xxx
[NAME] | xxx | xxx | xxx
text10 | xxx | xxx | xxx
text11 | xxx | xxx | xxx
text12 | xxx | xxx | xxx
text13 | xxx | xxx | xxx
t1C1 | xxx | xxx | xxx
t1C2 | xxx | xxx | xxx
t1C3 | xxx | xxx | xxx
t1C4 | xxx | xxx | xxx
t2C1 | xxx | xxx | xxx
[NAME] | xxx | xxx | xxx
t2C3 | xxx | xxx | xxx
t2C4 | xxx | xxx | xxx
Spreadsheet: 0c5bbfe5-14fa-4208-824e-61e2237c9b3a
Sheet: Fall

 | Acad. Year | Class Schedule: First Year |  |  |  |  |  |  | Fall
 | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday
800 | RC 113 |  | RC 113 |  | RC 115                                         # 1136                                     Kathy |  | Clinical Rotations begin the last week of October. No Thursday or Friday classes until then
 | # 1135 |  | # 1135
900 | [NAME] |  | [NAME] |  |  |  | CLINICAL ROTATIONS      0630 - 1530 |  | CLINICAL ROTATIONS      0630 - 1530
1000 | RC 111                                         # 1130                                          Kathy |  | RC 111                                         # 1130                                          Kathy |  | Office Hours | Office Hours
 |  |  |  |  | Kathy | [NAME]
1100 | Office Hours | Office Hours | Office Hours | Office Hours
 | Kathy | [NAME] | Kathy | [NAME]
1200 | RC 112 |  | RC 112 |  | NO CLASSES SCHEDULED AT BCCC
 | # 1131 |  | # 1132
1300 | Kathy |  | Kathy
1400 | RC 112 |  | RC 112
 | # 1132 |  | # 1131
1500 | Kathy |  | Kathy
1600
1700
Spreadsheet: 04467543-dc01-4938-95be-1d2e013286f0
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
 | 8731.0 Building Approvals, Australia
 | TABLE 86. Value of Building Approved, Chain Volume Measures, Original - Australian Capital Territory
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
Value of Approval ($M) ;  Chain Volume Measures ;  Australian Capital Territory ;  Total houses ;  New ; |  |  | Original | A590547W | 1985-09-01 00:00:00 | 2011-12-01 00:00:00 | 106 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Australian Capital Territory ;  Total other residential building ;  New ; |  |  | Original | A590548X | 1985-09-01 00:00:00 | 2011-12-01 00:00:00 | 106 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Australian Capital Territory ;  Total residential building ;  New ; |  |  | Original | A590549A | 1985-09-01 00:00:00 | 2011-12-01 00:00:00 | 106 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Australian Capital Territory ;  Total residential building ;  Total alterations/additions (incl. refurb and conversion) ; |  |  | Original | A590550K | 1985-09-01 00:00:00 | 2011-12-01 00:00:00 | 106 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Australian Capital Territory ;  Total residential building ;  Total (Type of Work) ; |  |  | Original | A590551L | 1985-09-01 00:00:00 | 2011-12-01 00:00:00 | 106 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Australian Capital Territory ;  Total non-residential building ;  Total (Type of Work) ; |  |  | Original | A590552R | 1985-09-01 00:00:00 | 2011-12-01 00:00:00 | 106 | $ Millions | FLOW | Quarter | 3
Value of Approval ($M) ;  Chain Volume Measures ;  Australian Capital Territory ;  Total building ;  Total (Type of Work) ; |  |  | Original | A590553T | 1985-09-01 00:00:00 | 2011-12-01 00:00:00 | 106 | $ Millions | FLOW | Quarter | 3
© Commonwealth of Australia  2012
Spreadsheet: kate_symes__19025__MeadMktplace (2)
Sheet: MeadMktplace

 |  |  | Firm | Volume | Firm | Volume | Non Firm | Volume | Non Firm | Volume
 | DATE |  | On [NAME] | [NAME] | [NAME] | [NAME] | On [NAME] | [NAME] | [NAME] | [NAME]
 | 2001-04-04 00:00:00 |  | 199.23 | 4384 | 103.75 | 2232
 | 2001-04-03 00:00:00 |  | 188.58 | 4064 | 116.57 | 1632 | 117.12 | 1130 | 85.69 | 262
 | 2001-04-02 00:00:00 |  | 238.59 | 1024 | 150.88 | 912 | 137.01 | 2361 | 111.15 | 1000
 | 2001-04-01 00:00:00 |  | 180 | 800 | 107 | 600 | 148.11 | 1110 | 121.38 | 1200
 | 2001-03-31 00:00:00 |  | 154.62 | 624 | 95.02 | 1832 | 208.73 | 2005 | 132.05 | 925
 | 2001-03-30 00:00:00 |  | 154.62 | 624 | 94.91 | 1832 | 157.25 | 2240 | 118.11 | 1415
 | 2001-03-29 00:00:00 |  | 150.35 | 1824 | 96.1 | 1672 | 134.29 | 2045 | 98.07 | 1330
 | 2001-03-28 00:00:00 |  | 133.2 | 3328 | 74.97 | 1544 | 115.44 | 1399 | 82.09 | 1685
 | 2001-03-27 00:00:00 |  | 105.94 | 1104 | 69.87 | 1232 | 119.31 | 1428 | 71.55 | 1817
 | 2001-03-26 00:00:00 |  | 278.99 | 1104 | 158.37 | 712 | 121.58 | 1216 | 59.09 | 901
 | 2001-03-25 00:00:00 |  | 195 | 0 | 150 | 0 | 83.27 | 1706 | 57.7 | 1655
 | 2001-03-24 00:00:00 |  | 240.51 | 624 | 143.75 | 880 | 122.71 | 3765 | 146.16 | 2205
 | 2001-03-23 00:00:00 |  | 240.51 | 624 | 143.75 | 880 | 212.95 | 3035 | 164.51 | 1676
 | 2001-03-22 00:00:00 |  | 282.93 | 464 | 175.42 | 2032 | 299.77 | 1910 | 211.67 | 1390
 | 2001-03-21 00:00:00 |  | 353.67 | 1024 | 220.45 | 880 | 351.62 | 4153 | 259.99 | 1589
 | 2001-03-20 00:00:00 |  | 323.59 | 624 | 221.88 | 1600 | 281.92 | 1957 | 245.43 | 1616
 | 2001-03-19 00:00:00 |  | 291.72 | 1024 | 197.04 | 1272 | 197.2 | 635 | 225 | 20
 | 2001-03-18 00:00:00 |  | 220 | 0 | 182.5 | 0 | 149.33 | 1225 | 119.19 | 980
 | 2001-03-17 00:00:00 |  | 204.13 | 1008 | 134.76 | 2888 | 180.48 | 2250 | 127.55 | 570
 | 2001-03-16 00:00:00 |  | 204.13 | 1008 | 134.84 | 2864 | 209.71 | 1442 | 126.88 | 1046
 | 2001-03-15 00:00:00 |  | 180.74 | 2160 | 109.85 | 2184 | 189 | 2490 | 123.8 | 1881
 | 2001-03-14 00:00:00 |  | 163.59 | 1024 | 89.3 | 696 | 152.63 | 4365 | 107.38 | 1787
 | 2001-03-13 00:00:00 |  | 166.63 | 2064 | 81.94 | 1392 | 154.62 | 2586 | 118.47 | 1995
 | 2001-03-12 00:00:00 |  | 172.81 | 1424 | 102.15 | 1696 | 159.9 | 3783 | 116.27 | 2115
 | 2001-03-11 00:00:00 |  | 145 | 160 | 95 | 0 | 118.53 | 2962 | 105.52 | 2029
 | 2001-03-10 00:00:00 |  | 150.25 | 1024 | 85.52 | 1544 | 103.36 | 1254 | 105.49 | 1840
 | 2001-03-09 00:00:00 |  | 150.25 | 1024 | 85.52 | 1544 | 155.44 | 2180 | 106.38 | 1520
 | 2001-03-08 00:00:00 |  | 180 | 400 | 99 | 1000 | 173.53 | 731 | 126.23 | 1620
 | 2001-03-07 00:00:00 |  | 271.07 | 448 | 177.36 | 1664 | 205.39 | 1019 | 146.01 | 1746
 | 2001-03-06 00:00:00 |  | 302.29 | 944 | 166.83 | 1072 | 202.39 | 2764 | 134.22 | 1696
 | 2001-03-05 00:00:00 |  | 280 | 800 | 172.5 | 800 | 189.65 | 2226 | 131.16 | 1376
Spreadsheet: 752905d1635085275-advanced-if-statement-required-if-formula
Sheet: Sheet1

FALSE/TRUE Value | [NAME] # | Desired Sales Order #
False |  | 10000
False |  | 10001
False |  | 10002
False |  | 10003
False |  | 10004
False |  | 10005
False |  | 10006
True |  | 10007
True |  | 10007
False
False
False
False
False
True
True |  | 10013
False
False
False
False
False
False
False
False
False
False
False
False
True
True |  | 10026
False
False
True
True |  | 10029
True |  | 10029
False
Spreadsheet: 703778d1605174605-formula-required-for-return-a-section-wise-different-objects-number-of-quantities-formula-required-for-return-a-section-wise-different-objects-number-of-quantities-1-
Sheet: Sheet

Section-1
Lot Name | Timber | Plywood | Lights | Table | Blocks |  |  |  | Return a Quantities section wise
ABC | 71 | 53 | 89 | 63 | 44 |  |  |  |  | Section-1 |  | Section-2 |  | Section-3
BJH | 88 | 45 | 55 | 70 | 56 |  |  |  |  | Timber | Table | Timber | Blocks | Plywood | Lights
POL | 44 | 28 | 54 | 37 | 93 |  |  |  | POL
ASH | 97 | 70 | 73 | 41 | 40 |  |  |  |  | Plywood | Lights | Blocks | Plywood | Table | Lights
QWS | 47 | 34 | 38 | 88 | 90 |  |  |  | QWS ASH
 |  |  |  |  |  |  |  |  | Above return a quantities for joint look up values section wise
Section-2
Lot Name | Timber | Plywood | Lights | Table | Blocks
ABC | 79 | 69 | 63 | 53 | 70
BJH | 47 | 71 | 70 | 45 | 51
POL | 95 | 63 | 37 | 28 | 51
ASH | 98 | 89 | 41 | 70 | 46
QWS | 71 | 60 | 88 | 34 | 50
 |  |  |  |  |  |  |  |  |  | Section-1 |  | Section-2 |  | Section-3
Section-3 |  |  |  |  |  |  |  |  |  | Timber | Table | Timber | Blocks | Plywood | Lights
Lot Name | Timber | Plywood | Lights | Table | Blocks |  |  |  | POL
ABC | 70 | 44 | 66 | 69 | 71 |  |  |  |  | Plywood | Lights | Blocks | Plywood | Table | Lights
BJH | 51 | 56 | 71 | 71 | 88 |  |  |  | QWS ASH
POL | 51 | 93 | 55 | 63 | 44
ASH | 46 | 40 | 64 | 89 | 97
QWS | 50 | 90 | 85 | 60 | 47
Spreadsheet: 08cae973-a59a-40cd-8bd1-14481440a549
Sheet: 2

 | Dec 28 |  | Jan 4 |  | Jan 11 |  | Jan 18
 | Long | Short | Long | Short | Long | Short | Long | Short
Total Interest Rate* | 373145478 | 373145478 | 370621611 | 370621611 | 380218108 | 380218108 | 385395440 | 385395440
SD/MSPs | N/A*** | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Total Cross-Currency | 16648654 | 16648654 | 16574252 | 16574252 | 16747192 | 16747192 | 17016046 | 17016046
SD/MSPs | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Total Credit | 20351555 | 20351555 | 20276576 | 20276576 | 20595813 | 20595813 | 20654755 | 20654755
Dealers** | 17262402 | 17260245 | 17189842 | 17164316 | 17437094 | 17423164 | 17466814 | 17468028
Buyside | 3089153 | 3091310 | 3086734 | 3112260 | 3158719 | 3172648 | 3187941 | 3186727
Total Equity | 5166993 | 5166993 | N/A | N/A | N/A | N/A | N/A | N/A
SD/MSPs | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Total Other Commodity | 3091000 | 3091000 | 3091000 | 3091000 | 3091000 | 3091000 | 3091000 | 3091000
SD/MSPs | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Financials | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
End Users | N/A | N/A | N/A | N/A | N/A | N/A | N/A | N/A
Weekly snapshot, estimated gross notional amount outstanding by asset class and participant type (millions of USD), all products, origins, currencies, tenors, and participant types, cleared and uncleared. Data are adjusted for double-counting of cleared trades to show a single exposure for each trade.
*See Data Dictionary for asset class descriptions.
**See Explanatory Notes for participant type descriptions.
***N/A indicates that data are not currently available.
The Commission requests feedback on the format and content of this CFTC Swaps Report table. Submit comments to [EMAIL]
Spreadsheet: 95441d1295025498-picking-two-columns-of-data-and-combining-forum-sample-11
Sheet: Sheet1

 | 905
 | 159
805 | 259
 | 089
 | 593
581
 | 189
528 | 954
 | 289
 | 595
485
855 | 389
865
 | 659
578
Spreadsheet: 54256d1254268755-phantom-decimal-points-test2
Sheet: test

trans_amt
1674
40599
734.2
650
2950
600
1056.77
1663.25
-49927.22
41746.56
49927.22
152363.76
-788335.65
-1706973.39
-203584.07
-1094.6
-322865.33
322865.33
-252253.35
-2761032.44
-2827370.73
-14846
-6668.95
-142234.14
45895.77
-289.25
-17406.57
-1807.8
-126
-5412.75
1993
-1622.68
-13674.63
-5979.71
-7300
-3150.1
-20
-5320.13
-123.06
-314.2
4768.5
29658.33
15129.05
240662.83
80083.78
20854.38
2994.05
64190.73
315632.59
89678.76
151625.29
90676.14
6369.42
23860.3
429883.13
36488.97
20451.52
334761.66
39429.31
264213.22
74152.74
8038.12
180228.69
43624.63
78485.87
78584.68
56077.7
51152.8
72230.97
324081.97
196217.25
86748.12
250314.21
54065.12
70551.32
97811.96
67865.05
413023.04
55480.07
14977.72
138156.07
359283.87
174442.57
141075.3
91262.62
222063.38
84179.99
82997.9
138601.57
96598.73
82530.37
107827.46
97426.8
72854.88
155850.53
63905.08
220069.32
64629.18
84855.46
50229.61
61350.02
102534.56
47058.27
12014.71
29834.62
181508.43
97219.33
314989.95
72126.08
80185.4
99730.45
218889.68
49276.45
44331.26
Spreadsheet: 16d0e2fd-9890-4bdd-abaa-75c6e40036b4
Sheet: Sheet1

West Virginia Offices of the Insurance Commissioner | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6
Workers' Compensation Self-Insurance
Evaluation Year: | 2012
Self-Insured Client:
Date Commenced Self-Insurance:
Third Party Administrator:
Are expenses in the data? | Yes | Choose either "yes" or "no"
Is Surety required after 6/30/04? | Yes | Choose either "yes" or "no"
Is reserve data available? | Yes | Choose either "yes" or "no"
 |  |  |  |  | Calendar Year 2012 Payroll
Client Provided Data |  |  |  |  | Segregated by NCCI Class Code
Calendar Accident Year | Total Paid* as of 12/31/2012 | Total Reserve* as of 12/31/2012 | Calendar Year Payroll |  | Class Code | Payroll
Prior | 0 | 0
1970 | 0 | 0
1971 | 0 | 0
1972 | 0 | 0
1973 | 0 | 0
1974 | 0 | 0
1975 | 0 | 0
1976 | 0 | 0
1977 | 0 | 0
1978 | 0 | 0
1979 | 0 | 0
1980 | 0 | 0
1981 | 0 | 0
1982 | 0 | 0
1983 | 0 | 0
1984 | 0 | 0
1985 | 0 | 0
1986 | 0 | 0
1987 | 0 | 0
1988 | 0 | 0
1989 | 0 | 0
1990 | 0 | 0
1991 | 0 | 0
1992 | 0 | 0
1993 | 0 | 0
1994 | 0 | 0
1995 | 0 | 0
1996 | 0 | 0
1997 | 0 | 0
1998 | 0 | 0
1999 | 0 | 0 | 0
2000 | 0 | 0 | 0
2001 | 0 | 0 | 0
2002 | 0 | 0 | 0
2003 | 0 | 0 | 0
2004 | 0 | 0 | 0
2005 | 0 | 0 | 0
2006 | 0 | 0 | 0
2007 | 0 | 0 | 0
2008 | 0 | 0 | 0
2009 | 0 | 0 | 0
2010 | 0 | 0 | 0
2011 | 0 | 0 | 0
2012 | 0 | 0 | 0
2013 |  |  | 0
Model Assumptions
Interest Rate: | 0.04
Allocated Expense Percentage: | 0.125
Unallocated Expense Percentage: | 0.075
Total Expense Percentage: | 0.2
Notes:
Self Insured and Industry data include voc rehab in indemnity and non voc rehab in medical
Spreadsheet: john_griffith__15666__05_11_01ON
Sheet: Sheet1

N
Commodity: | ON - NAT. GAS OPTS.
Month | STRIKE | BID | OFFER | Volatility | Future
M01-P/C | 440 | 34 | 38
N01-P/C | 445 | 63 | 68
Q01-P/C | 450 | 85 | 90
U01-P/C | 455 | 102 | 107
V01-P/C | 455 | 117 | 123
X01-P/C | 470 | 136 | 143
[NAME]-P/C | 485 | 156 | 162
F02-P/C | 490 | 170 | 176
G02-P/C | 480 | 174 | 180
H02-P/C | 460 | 159 | 166
J02-P/C | 425 | 118 | 128
K02-P/C | 420 | 111 | 121
M02-P/C | 420 | 113 | 123
U02-P/C | 425
Spreadsheet: 79051d1279282138-highlight-according-to-values-test-1-
Sheet: Sheet1

No | Date1 | Date2
2 | 2010-06-15 00:00:00 | 2010-07-04 00:00:00 | 2
3 | 2010-06-16 00:00:00 | 2010-07-25 00:00:00 | 3
13 | 2010-06-17 00:00:00 | 2010-07-09 00:00:00
13 | 2010-07-10 00:00:00 | 2010-07-17 00:00:00 |  | ◄ you skipped this case
2 | 2010-07-04 00:00:00 | 2010-07-10 00:00:00 | 2 | You can see that Date1 is the Same has the prior Date2 to this Number
5 | 2010-06-20 00:00:00 | 2010-07-12 00:00:00
6 | 2010-06-21 00:00:00 | 2010-07-05 00:00:00
1 | 2010-06-22 00:00:00 | 2010-07-08 00:00:00
3 | 2010-07-26 00:00:00 | 2010-07-30 00:00:00 | 3 | You can see that Date1 is one day after the prior Date2 to this number
Spreadsheet: 832980d1686713943-i-am-confused-why-equation-equaling-zero-is-sometimes-red-color-and-sometimes-black-color-cnfusing-2
Sheet: Sheet1

102.6 |  |  |  |  | 102.6
84.1 |  |  |  |  | 84
payments | credits | fees | total |  | payments | credits | fees | total
 | 186.7 | 0 |  |  |  | 186.6 | 0
payments | credits | fees | total |  | payments | credits | fees | total
186.9 | 186.9 | 0 |  |  | 186.6 | 186.6 | 0
Spreadsheet: 72969d1273662377-sales-trend-formulae-3-month-trend-de
Sheet: Sheet1

 | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb
Achieved | 0.8267386037812114 | 0.2552046685718627 | 0.56 | 0.8102787171424595 | 0.7 | 0.7010459036707619 | 0.1831469505527794 | 0.8975283788465698 | 0.837535652161753 | 0.6489668805758564 | 0.7150611354855698
 |  |  | ó | ñ | ó | ó | ó | ó | ó | ò | ó
 |  |  | ó | ñ | ó | ó | ó | ó | ó | ò | ó
TREND (Up, [NAME], No Trend) |  |  | No Trend | UP | No Trend | No Trend | No Trend | No Trend | No Trend | Down | No Trend
 |  |  | No Trend | UP | No Trend | No Trend | No Trend | No Trend | No Trend | Down | No Trend
 |  |  | ó | ñ | ó | ó | ó | ó | ó | ò | ó
Spreadsheet: 861598d1709486398-formula-help-to-reflect-value-in-table-1-from-table-2-in-same-row-matching-criteria-demo-030324-aligw
Sheet: Statement

 |  | Table 1 |  |  | Table 2
 |  | Fruits | Month |  | Fruits | MONTHS
 |  |  | 2023-04-30 00:00:00 | <----Criteria |  | 2023-04-30 00:00:00 |  | 2023-06-30 00:00:00
 | Criteria---> | Water melon |  | <----Corrsponding value of same row from table 2 ( Cell G6) | Water melon | 550.739308999999 | 553.4624294999909 | 642.3954794000001 | Target value G6
 |  | Apple |  | <----Corrsponding value of same row from table 2 ( Cell G7) | Apple | 544.7793536999989 | 620.4713416000011 | 614.8303793000002 | Target value G7
 |  | Orange |  | <----Corrsponding value of same row from table 2 ( Cell G8) | Orange | 141.816426999999 | 148.993615 | 149.979060000001 | Target value G8
 |  | Mango |  |  | Mango | 1 | 1 | 1
 |  | Blackberry |  |  | Blackberry | 2.5 | 0.08499999999999996 | 17.835
 |  | Water melon |  | This values is repeating again whereas need 375.74 | Water melon | 375.739308999999 | 378.4624294999909 | 467.3954794000001
 |  | Apple |  |  | Apple | 369.7793536999989 | 445.4713416000011 | 439.8303793000002
 |  | Orange |  |  | Orange | 33.183573000001 | 26.006385 | 25.020939999999
 |  | Mango |  |  | Mango | 174 | 174 | 174
 |  | Blackberry |  |  | Blackberry | 172.5 | 174.915 | 157.165
 |  | Need your help on to reflect the cell value of same row matching with month as criteria in first table in cell no. D5 against table 2. In give data set if I select month Apr 23 in table 1 ( D5), corresponding data in table 2 of April23 (column G)  should capture in D column against each fruit in same line. Hope I could explain my query.
Spreadsheet: 390583d1429699339-sumif-a-column-if-the-number-is-the-highest-in-that-row-excel-help-sumif
Sheet: Sheet1

 | 2015 | 2016 | 2017 | 2018 | 2019 | 2020 | 2021 | 2022 | 2023 | 2024 | 2025 | 2026 | 2027
Site A | 5 | 6 | 6 | 10
Site B | 4 | 4 | 4 | 4 | 4 | 5 | 5 | 7
Site C | 5 | 5 | 5 | 6 | 6 | 7 | 7 | 7 | 7 | 9
Site D | 1 | 1 | 3
Site E | 4 | 4 | 4 | 4
TOTAL
Spreadsheet: 738307d1624963763-sort-the-po-number-from-a-growing-list-book
Sheet: Item list

Item | PO |  |  | PO no. for Item ABC
ABC | 123 |  |  | 123
BCD | 234 |  |  | 456
CDE | 345 |  |  | 789
ABC | 456
BCD | 567
CDE | 678
ABC | 789
Spreadsheet: 153752d1336043989-hlookup-and-vlookups-including-countif-test
Sheet: LoginLogout

Name
test |  | 09:16:43 | 17:27:40
test |  | 12:29:12 | 17:27:40
test a |  | 09:16:43 | 09:18:43
test a |  | 12:29:12 | 12:30:12
test a |  | 13:00:05 | 13:00:08
test a |  | 14:11:52 | 17:33:14
Test B |  | 11:26:50 | 16:27:46
Test B |  | 16:37:46 | 16:47:46
Test B |  | 16:57:46 | 20:46:09