tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 677096d1589192936-array-formula-daily
Sheet: daily

Date | Open | High | Low | Close | open + constant | open -constant | Whether F or G first occurs | time | value |  | Constant | 25
2020-03-11 00:00:00 | 10334.299805 | 10545.099609 | 10334 | 10458.400391
2020-03-12 00:00:00 | 10039.950195 | 10040.75 | 9508 | 9590.150391
2020-03-13 00:00:00 | 9107.599609 | 10159.400391 | 8555.150391 | 9955.200195
2020-03-16 00:00:00 | 9587.799805 | 9602.200195 | 9165.099609 | 9197.400391
2020-03-17 00:00:00 | 9285.400391 | 9403.799805 | 8915.599609 | 8967.049805
2020-03-18 00:00:00 | 9088.450195 | 9127.549805 | 8407.049805 | 8468.799805
2020-03-19 00:00:00 | 8063.299805 | 8575.450195 | 7832.549805 | 8263.450195
2020-03-20 00:00:00 | 8284.450195 | 8883 | 8178.200195 | 8745.450195
2020-03-23 00:00:00 | 7945.700195 | 8159.25 | 7583.600098 | 7610.25
2020-03-24 00:00:00 | 7848.299805 | 8036.950195 | 7511.100098 | 7801.049805
2020-03-25 00:00:00 | 7735.149902 | 8376.75 | 7714.75 | 8317.849609
2020-03-26 00:00:00 | 8451 | 8749.049805 | 8304.900391 | 8641.450195
2020-03-27 00:00:00 | 8949.099609 | 9038.900391 | 8522.900391 | 8660.25
2020-03-30 00:00:00 | 8385.950195 | 8576 | 8244 | 8281.099609
2020-03-31 00:00:00 | 8529.349609 | 8678.299805 | 8358 | 8597.75
2020-04-01 00:00:00 | 8584.099609 | 8588.099609 | 8198.349609 | 8253.799805
2020-04-03 00:00:00 | 8356.549805 | 8356.549805 | 8055.799805 | 8083.799805
2020-04-07 00:00:00 | 8446.299805 | 8819.400391 | 8360.950195 | 8792.200195
2020-04-08 00:00:00 | 8688.900391 | 9131.700195 | 8653.900391 | 8748.75
2020-04-09 00:00:00 | 8973.049805 | 9128.349609 | 8904.549805 | 9111.900391
2020-04-13 00:00:00 | 9103.950195 | 9112.049805 | 8912.400391 | 8993.849609
2020-04-15 00:00:00 | 9196.400391 | 9261.200195 | 8874.099609 | 8925.299805
2020-04-16 00:00:00 | 8851.25 | 9053.75 | 8821.900391 | 8992.799805
2020-04-17 00:00:00 | 9323.450195 | 9324 | 9091.349609 | 9266.75
2020-04-20 00:00:00 | 9390.200195 | 9390.849609 | 9230.799805 | 9261.849609
2020-04-21 00:00:00 | 9016.950195 | 9044.400391 | 8909.400391 | 8981.450195
2020-04-22 00:00:00 | 9026.75 | 9209.75 | 8946.25 | 9187.299805
2020-04-23 00:00:00 | 9232.349609 | 9343.599609 | 9170.150391 | 9313.900391
2020-04-24 00:00:00 | 9163.900391 | 9296.900391 | 9141.299805 | 9154.400391
2020-04-27 00:00:00 | 9259.700195 | 9377.099609 | 9250.349609 | 9282.299805
2020-04-28 00:00:00 | 9389.799805 | 9404.400391 | 9260 | 9380.900391
2020-04-29 00:00:00 | 9408.599609 | 9599.849609 | 9392.349609 | 9553.349609
2020-04-30 00:00:00 | 9753.5 | 9889.049805 | 9731.5 | 9859.900391
2020-05-04 00:00:00 | 9533.5 | 9533.5 | 9266.950195 | 9293.5
2020-05-05 00:00:00 | 9429.400391 | 9450.900391 | 9190.75 | 9205.599609
2020-05-06 00:00:00 | 9226.799805 | 9346.900391 | 9116.5 | 9270.900391
2020-05-07 00:00:00 | 9234.049805 | 9277.849609 | 9175.900391 | 9199.049805
2020-05-08 00:00:00 | 9376.950195 | 9382.650391 | 9238.200195 | 9251.5
Spreadsheet: 069e9432-6128-49ac-9493-5b885932c03e
Sheet: White Rose

 |  |  |  |  |  |  | 2013 White Rose F.E.
 | January |  |  |  |  |  | February |  |  |  |  |  | March
 | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr
 |  | 1 | 2 | 3 | 4 |  |  |  |  |  | 1 |  |  |  |  |  | 1
 | 7 | 8 | 9 | 10 | 11 |  | 4 | 5 | 6 | 7 | 8 |  | 4 | 5 | 6 | 7 | 8
 | 14 | 15 | 16 | 17 | 18 |  | 11 | 12 | 13 | 14 | 15 |  | 11 | 12 | 13 | 14 | 15
 | 21 | 22 | 23 | 24 | 25 |  | 18 | 19 | 20 | 21 | 22 |  | 18 | 19 | 20 | 21 | 22
 | 28 | 29 | 30 | 31 |  |  | 25 | 26 | 27 | 28 |  |  | 25 | 26 | 27 | 28 | 29
 | April |  |  |  |  |  | May |  |  |  |  |  | June
 | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr
 | 1 | 2 | 3 | 4 | 5 |  |  |  | 1 | 2 | 3
 | 8 | 9 | 10 | 11 | 12 |  | 6 | 7 | 8 | 9 | 10 |  | 3 | 4 | 5 | 6 | 7
 | 15 | 16 | 17 | 18 | 19 |  | 13 | 14 | 15 | 16 | 17 |  | 10 | 11 | 12 | 13 | 14
 | 22 | 23 | 24 | 25 | 26 |  | 20 | 21 | 22 | 23 | 24 |  | 17 | 18 | 19 | 20 | 21
 | 29 | 30 |  |  |  |  | 27 | 28 | 29 | 30 | 31 |  | 24 | 25 | 26 | 27 | 28
 | July |  |  |  |  |  | August |  |  |  |  |  | September
 | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr
 | 1 | 2 | 3 | 4 | 5 |  |  |  |  | 1 | 2 |  | 2 | 3 | 4 | 5 | 6
 | 8 | 9 | 10 | 11 | 12 |  | 5 | 6 | 7 | 8 | 9 |  | 9 | 10 | 11 | 12 | 13
 | 15 | 16 | 17 | 18 | 19 |  | 12 | 13 | 14 | 15 | 16 |  | 16 | 17 | 18 | 19 | 20
 | 22 | 23 | 24 | 25 | 26 |  | 19 | 20 | 21 | 22 | 23 |  | 23 | 24 | 25 | 26 | 27
 | 29 | 30 | 31 |  |  |  | 26 | 27 | 28 | 29 | 30 |  | 30
 | October |  |  |  |  |  | November |  |  |  |  |  | December
 | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr |  | Mo | [NAME] | We | Th | Fr
 |  | 1 | 2 | 3 | 4 |  |  |  |  |  | 1 |  | 2 | 3 | 4 | 5 | 6
 | 7 | 8 | 9 | 10 | 11 |  | 4 | 5 | 6 | 7 | 8 |  | 9 | 10 | 11 | 12 | 13
 | 14 | 15 | 16 | 17 | 18 |  | 11 | 12 | 13 | 14 | 15 |  | 16 | 17 | 18 | 19 | 20
 | 21 | 22 | 23 | 24 | 25 |  | 18 | 19 | 20 | 21 | 22 |  | 23 | 24 | 25 | 26 | 27
 | 28 | 29 | 30 | 31 |  |  | 25 | 26 | 27 | 28 | 29 |  | 30 | 31
 | 2nd & 4th Thursdays.  [NAME] is subject to change.  Call CPFB with questions [PHONE]. Thank you.
 |  |  | Holiday closures. |  |  |  |  | Deliveries. |  |  |  | Inventory - warehouse closures.
Spreadsheet: 101492d1299605183-excel-2007-formula-to-organize-data-example
Sheet: Sheet1

START:
ABC Co. |  |  |  |  | DEF Co.
sequence | item | cost | profit |  | sequence | item | cost | profit
1 | apple | 0 | 0 |  | 1 | pear | 2 | 2
2 | pear | 0 | 0 |  | 2 | orange | 3 | 3
3 | orange | 2 | 2 |  | 3 | apple | 0 | 0
4 | banana | 3 | 3 |  | 4 | banana | 0 | 0
5 | grape | 2 | 2 |  | 5 | blueberry | 0 | 0
FINISH:
ABC Co. | DEF Co. | Item |  | ABC |  | DEF
Sequence |  |  |  | cost | profit | cost | profit
1 | 3 | apple |  | 0 | 0 | 0 | 0
2 | 1 | pear |  | 0 | 0 | 2 | 2
3 | 2 | orange |  | 2 | 2 | 3 | 3
4 | 4 | banana |  | 3 | 3 | 0 | 0
5 | - | grape |  | 2 | 2 | - | -
- | 5 | blueberry |  | - | - | 0 | 0
Spreadsheet: 787836d1658081861-formula-to-sum-values-of-variables-based-on-similarity-book1-1
Sheet: Sheet1

 |  |  |  |  |  |  |  |  | [NAME]
D | 10 |  |  | F | 5 |  |  |  | A | 11
A | 8 |  |  | B | 2 |  |  |  | B | 4
E | 4 |  |  | D | 9 |  |  |  | C | 16
B | 2 |  |  | A | 3 |  |  |  | D | 19
C | 9 |  |  | C | 7 |  |  |  | E | 12
F | 1 |  |  | E | 8 |  |  |  | F | 6
Spreadsheet: 787011d1657604462-linking-two-excel-tables-mappe4-ans
Sheet: Tabelle1

Table 1 |  |  |  |  |  |  | Table 2
City |  | Number | Number | Number |  |  | Should be
Toronto | Year 1 | 232453 | 34567 | 4542323 |  |  |  |  | City | Year 3 | Enter city in K3
 | Year 2 | 343432 | 2323211 | 1221324 |  | Toronto | 1221324 |  |  |  | Subjected to condition that each city must have the year in the K3 cell
 | Year 3 | 5334211 | 456622 | 9899472 |  | Miami | 1232321
Miami | Year 1 | 89393939 | 2323112 | 2323111 |  | Montreal | 23131
 | Year 2 | 232321 | 2323231 | 1232321 |  | Boston | 232111
 | Year 3 | 232311 | 232311 | 132321 |  | [NAME] | 132312312
Montral | Year 1 | 123131 | 132321 | 2312312 |  | London | 434322
 | Year 2 | 1231231 | 1323131 | 23131
 | Year 3 | 132311 | 1323121 | 232131
Boston | Year 1 | 2323211 | 232321 | 23123122
 | Year 2 | 232311 | 323232 | 232111
 | Year 3 | 2323211 | 2323131 | 232131
[NAME] | Year 1 | 12312312 | 1231231 | 3123131
 | Year 2 | 3132222 | 231311 | 132312312
 | Year 3 | 3123121 | 2313222 | 3231444
London | Year 1 | 44423213 | 1231244 | 5454545
 | Year 2 | 213412312 | 4241312 | 434322
 | Year 3 | 321312 | 1231231 | 123123444
Spreadsheet: 4b3c658f-44aa-4740-8389-07cced466dfc
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | TIB-The Independent BankersBank | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | .25 cost to Price to Waive Escrows | Unnamed: 7
 |  | 350 [NAME]., [NAME] |  |  |  | LTV must be 80% or less to qualify.
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective: |  |  | 2014-05-12 09:14:32.130000
Product: Conv-Conforming Fixed Rate 30 Year |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day | 60 Day |  | Price adjustments are cumulative
4.75 | 102.875 | 102.75 | 102.625 | 102.25 |  | and are added to price quote
4.625 | 102.624 | 102.499 | 102.374 | 101.999
4.5 | 102.072 | 101.947 | 101.822 | 101.447 |  | Note: | Refer To Price [NAME]
4.375 | 101.426 | 101.301 | 101.176 | 100.801 |  |  | For all Price Adjs
4.25 | 100.837 | 100.712 | 100.587 | 99.962
4.125 | 99.976 | 99.851 | 99.726 | 99.101
4 | 98.955 | 98.83 | 98.705 | 98.08
3.875 | 97.885 | 97.76 | 97.635 | 97.01
3.75 | 97.01 | 96.885 | 96.76 | 96.135
Product: Conv-Conforming Fixed Rate 15 Year
Rate | 15 Day | 30 Day | 45 Day | 60 Day
3.875 | 102.861 | 102.736 | 102.611 | 102.236
3.75 | 102.409 | 102.284 | 102.159 | 101.784
3.625 | 102.011 | 101.886 | 101.761 | 101.386
3.5 | 101.453 | 101.328 | 101.203 | 100.828
3.375 | 100.727 | 100.602 | 100.477 | 99.852
3.25 | 99.976 | 99.851 | 99.726 | 99.101
3.125 | 99.402 | 99.277 | 99.152 | 98.527 |  | Minimum loan amount:
 |  |  |  |  |  | TIB does not have a minimum loan
 |  |  |  |  |  | loan amount, however a 1.00% price
 |  |  |  |  |  | discount will apply to loan amounts
 |  |  |  |  |  | less than $39,999.00
 |  |  |  |  |  | 2010 Conforming Loan Limits
 |  |  |  |  |  | 1 Unit-$417,000
 |  |  |  |  |  | 2 Unit-$533,850
 |  |  |  |  |  | 3 Unit-$645,300
 |  |  |  |  |  | 4 Unit-$801,950
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
 |  | TIB-The Independent BankersBank
 |  | 350 [NAME]., [NAME]
 |  | [PHONE] Toll Free//[PHONE] fax
 |  | Rate Sheet Effective:
 |  |  |  |  |  | Loan Level Price Adjustment
Rate | 15 Day | 30 Day | 45 Day |  |  | Price adjustments are cumulative
 |  |  |  |  |  | & adj. Made to the price quote
EXPIRATION DATES:
15 DAY | 2014-05-26 09:14:32.130000
30 DAY | 2014-06-10 09:14:32.130000
45 DAY | 2014-06-25 09:14:32.130000
60 DAY | 2014-07-10 09:14:32.130000
90 DAY | 2014-08-09 09:14:32.130000
A SERVICE RELEASE PREMIUM WILL BE PAID IN [NAME] WITH THE ATTACHED SCHEDULE.
Spreadsheet: 21e942dc-5f3e-4f4e-ad6a-84a4ce0a2c5d
Sheet: Narrative LEA MOER-CEIS 12-13

Column | Explanation
A | AEA Number
B | District Number
C | District Name
I | Filler no entry in this column
J | [NAME] amount from the 2011-12 school year for the district
K | [NAME] amount from the 2012-13 school year for the district
L | Change in the amount from 11-12 to 12-13; only increases shown.
M | Amount that would be available for Maintenance of Effort Reduction (MOER) during the 2012-13 school year for the district.
N | Amount of the CEIS 15% that a district may be required to set aside for disproportionality remediation or may voluntarily use up to this amount for CEIS
 | Districts highlighted in this Yellow must set aside full 15% Coordinated Early Intervening Services and are not allowed to use MOER
 | There are 8 districts in this circumstance for 2012-13.  They have been notified and must prepare a plan and submit it to [NAME] at DE
 | Those districts that voluntarily choose to exercise this option will be required to submit a plan as well and must meet the attendant reporting requirements
 | The eight districts that must set aside the 15% and submit a remediation plan are:  [NAME], Ankeny, Bettendorf, Clear Creek-Amana, Dubuque, Iowa City,
 | Johnston and [NAME].
 | There are 73 districts that did not meet requirements and are not allowed to use the MOER provision in 12-13 (based on 2010-11 data).
 | There are two districts that fall into both this category and the disproportionality category above, both may NOT use the Maintenance of Effort Reduction
 | provision of IDEA, Part B for 2012-13.  Only those districts with an amount in column M are allowed to exercise this optional provision; it is not
 | required that they exercise the MOER.  The two districts that are in both categories are Clear Creek-Amana and Iowa City.
Spreadsheet: 28598d1222933827-count-cells-which-meet-the-conditional-formatting-criteria-quiz
Sheet: Quiz

No. | Standard | Answer | Result
1 | A | B | 0
2 | B | B | 1
3 | D | D | 1
4 | C | C | 1
5 | B | C | 0
 |  | Mark: | 3
Spreadsheet: 59430d1259929914-how-to-automate-top-5-entries-in-a-worksheet-709631_befuddled_v2
Sheet: Oct09

Date | Item | Description |  |  |  | 2009-10-01 00:00:00 | Items | A | apples
 |  |  |  |  |  |  |  | B | bananas
 |  |  |  |  |  |  |  | C | carrots
 |  |  |  |  |  |  |  | D | dogs
 |  |  |  |  |  |  |  | E | elephants
 |  |  |  |  |  |  |  | F | fish
 |  |  |  |  |  |  |  | G | grapes
 |  |  |  |  |  |  |  | H | hyenas
 |  |  |  |  |  |  |  | I | iguanas
 |  |  |  |  |  |  |  | J | jesuits
Spreadsheet: 881668d1729789750-formula-help-for-assessing-total-meeting-minutes-per-month-and-year-example-excel-help
Sheet: Sheet1

 |  |  |  | In minutes
 |  | Cadence | Length | Total Time per Month | Total Time per Year |  |  | Cadence | Length
 |  | Weekly | 30 | 120 | 6240 |  |  | Weekly | 15
 |  | Monthly | 90 | 90 | 1080 |  |  | Bi-Weekly | 30
 |  | Bi-Weekly | 45 | 90 | 1080 |  |  | Monthly | 45
 |  | Quarterly | 120 | 0 | 480 |  |  | Quarterly | 60
 |  |  |  |  |  |  |  | As Needed | 90
 |  |  |  |  |  |  |  |  | 120
 |  |  |  |  |  |  |  |  | 120+
Spreadsheet: 903180c0-1310-411b-b022-bc62bf26db8f
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
DP | Test | DP | House Dust Mites/Dermatophagoides pteronyssinus, IgE | House Dust Mites/D.P., 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
DP | [NAME] | SERUM | Serum |  |  |  | Refrigerated | 14 days
DP | Result | DP | House Dust Mites/D.P., IgE | House Dust Mites/D.P., IgE | Numeric |  |  |  |  | kU/L |  |  |  |  |  |  |  |  |  | 6096-2 | Dermatophagoides pteronyssinus Ab.IgE:ACnc:Pt:Ser:Qn:
Spreadsheet: 15eeee22-a2d2-49c5-a6e3-95cf22d74731
Sheet: Summary Nariño

PRESUPUESTO ENTIDADES EJECUTORAS
NARIÑO
Nombre Entidad Ejecutora:
Detalle | Presupuesto  Total | Tope Presupuestal
[NAME]
Monitoreo y Evaluación
[NAME] y [NAME]
Total Rubros de Funcionamiento
[NAME]
Total Destinación Específica
PRESUPUESTO TOTAL
XXXXXX
REPRESENTANTE LEGAL
Spreadsheet: 330930d1404907423-formula-for-matching-two-sheets-with-only-part-of-the-description-dslr-ready
Sheet: Sheet3

Description | Description | Code | Similarity
D-SLR  CANON EOS 1200D EFS18-55 IS
D-SLR  [NAME]
D-SLR  CANON EOS 1100D+EF-S18-55IS II | DIG. CAMERA CANON EOS 1100D 18-55IS KIT | 1631713 | 0.7576962649837278
D-SLR  CANON EOS 1100D+EF-S18-55DC III
D-SLR  SONY SLT-A58K | DIGITAL SLR CAMERA SONY SLT-A58K 18-55MM | 1957163 | 0.8975327796454654
D-SLR  NIKON D7100+AF-S 18-105 VR
D-SLR  NIKON D5300 18-55VR KIT | DSLR NIKON D3300 KIT BLACK 18-55 VR | 2135922 | 0.9042233935090636
D-SLR  NIKON D7100 BODY
D-SLR  NIKON D5300 18-55VR II KIT | DSLR CAMERA NIKON D3200 KIT 18-55 II VR | 2155044 | 0.7692053968480154
D-SLR  NIKON D3300 18-55 VR II KIT BLK | DSLR NIKON D3300 KIT BLACK 18-55 VR | 2135922 | 0.7736297576115592
D-SLR  NIKON D3300 18-55 VR II KIT GR | DSLR NIKON D3300 KIT BLACK 18-55 VR | 2135922 | 0.7736297576115592
D-SLR  CANON EOS-1100D/EFS18-55III+EF75300
D-SLR  CANON EOS 1100D+EF-S18-55IS II | DIG. CAMERA CANON EOS 1100D 18-55IS KIT | 1631713 | 0.7576962649837278
D-SLR  CANON EOS 650D EFS18-55ISII KIT
D-SLR  CANON EOS 1100D+18-55+75-300+50MM
D-SLR  CANON EOS600D18-55III+75-300IIIEMBU
D-SLR  CANON EOS650D+18-55III+75-300IIIEMBU
D-SLR  CANON EOS 600D+18-55III DC
D-SLR  CANON EOS100D+EFS18-55IS STM
D-SLR  PENTAX PENTAX K500 18-55
Spreadsheet: 123655d1317779520-rank-among-multiple-sheets-sum-per-week-building-a-sorted-by-category
Sheet: example

top 10 items less items from category 1 Welding pulled from the 3 vending machine sheets | usage for the last 12 weeks per week
This would be dynamic | 2011-10-04 00:00:00 | 2011-09-27 00:00:00 | 2011-09-20 00:00:00 | 2011-09-13 00:00:00 | 2011-09-06 00:00:00 | 2011-08-31 00:00:00 | 2011-08-24 00:00:00 | ….
S845SXMU1606ADT | 20 | 19 | 21 | 40 | 19 | 22 | 25
UNEU1205R IN2505 | 15 | 20 | 11 | 22 | 33 | 55 | 14
XCET310404ER NS530 | 20 | 19 | 21 | 40 | 19 | 22 | 25
KTIP05938HP KC7315 DRILL TIP | 15 | 20 | 11 | 22 | 33 | 55 | 14
H490ANKX170616P | 20 | 19 | 21 | 40 | 19 | 22 | 25
Spreadsheet: 885236d1734679210-changing-multiplier-based-on-cell-value-points-form-jt-
Sheet: February

Date | Day | Attended | Points
2025-02-01 00:00:00
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
 |  | 1
Total
 | Day | Attended | Points
 | Mon
 | Tue
 | Wed
 | Thu
 | Fri
 | Sat
 | Sun
 | Total
Spreadsheet: 834340d1687701219-modify-formula-to-handle-positive-and-negative-values-different-example
Sheet: Sheet1

Volume Start: | Cylinder position start: (cm) | M T disrepancy: | S J. C pr cm: | W/S
19 | 23 |  | 0.011802 | 0.00082020997 |  | Manual add/remove
Time: | D: | Theoretical W/S D. | Actual [NAME] Volume: | Theoretical  [NAME] volume | [NAME] volume: | Cylinder position: (cm) | Volume change due to changed cylinder position: | Manual add/remove |  | Corrected  Disrepancy accounting for Cylinder position or manual add/remove to reservoar: |  | Example of correct values
05:30:00 | 150 |  | 20 |  |  | 23
 | 300 |  | 18 |  |  | 10
 | 600 |  | 22 |  |  | 40
 | 900 |  | 19 |  |  | 38
 | 1200 |  | 25 |  |  | 20
 | 1500 |  | 15 |  |  | -40
 | 1800 |  | 23 |  |  | 70
 |  |  |  |  | Culumn can have both positive and negative values |  | Culumn can have both positive and negative values |  |  | Result should be:
 |  |  |  |  | Couumn reflects measured values |  | Column shows volume change as a result of cylinder position changes
 |  | IF cell F9<0, and if cell H9<0=(H9-F9)-J)
 |  | IF cell F9>0, and if cell H9>0=(H9-F9)-J)
 |  | IF cell F9<0, and if cell H9>0=(H9+F9)-J)
 |  | IF cell F9>0, and if cell [NAME])
Spreadsheet: 58429d1258657889-conditional-formatting-dynamic_validation
Sheet: Sheet1

1 | 2 | 3 | 4 | 5 | 6 | 7 |  |  | << new row added to find match for day of the week
Su | M | T | W | Th | F | Sa
H | H | H | H | H | H | H |  |  |  |  | Validation formula
Sick | Sick | Sick | Sick | Sick | Sick | Sick |  |  |  |  | OFFSET(INDIRECT(ADDRESS(1,MATCH(LOOKUP(WEEKDAY(DATE(YEAR(TODAY()),1,A10)),Daynum,Day_Ltr),Day_Ltr,0))),2,0,8,1)
L | L | L | L | L | L | L
M/P | M/P | M/P | M/P | M/P | M/P | M/P
U | U | U | U | U | U | U
O | O | O | O | O | O | O
B/H | B/H | B/H | B/H | B/H | B/H | B/H
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
Th | F | Sa | Su | M | T | W | Th | F | Sa | Su | M | T | W | Th | F | Sa | Su | M | T | W | Th | F | Sa | Su | M | T | W | Th | F
Spreadsheet: 22952d1212164104-score-calculation-sample3
Sheet: Sheet1

Grouping | Team | Score | Points
1 | A | 105 | 0.5
2 | B | 95 | 0
3 | C | 205 | 1
1 | D | 105 | 0.5
2 | E | 201 | 1
3 | F | 200 | 0
Spreadsheet: 831759d1685868517-formula-or-function-required-formula-or-function
Sheet: Sheet1

Time | STRIKE PRICE | PRICE |  | 17500 | 17550 | 17600 | 17650 | 17700
2023-06-02 09:17:05.410000 | 17500 | 1077
2023-06-02 09:17:05.410000 | 17550 | 997
2023-06-02 09:17:05.410000 | 17600 | 972 |  | ? | ? | ? | ? | ?
2023-06-02 09:17:05.410000 | 17650 | 867.55 |  | ? | ? | ? | ? | ?
2023-06-02 09:17:05.410000 | 17700 | 816.55 |  | ? | ? | ? | ? | ?
2023-06-02 09:18:04.970000 | 17500 | 1080 |  | ? | ? | ? | ? | ?
2023-06-02 09:18:04.970000 | 17550 | 997
2023-06-02 09:18:04.970000 | 17600 | 972
2023-06-02 09:18:04.970000 | 17650 | 867.55
2023-06-02 09:18:04.970000 | 17700 | 816.55
2023-06-02 09:19:04.950000 | 17500 | 1089
2023-06-02 09:19:04.950000 | 17550 | 997
2023-06-02 09:19:04.950000 | 17600 | 972
2023-06-02 09:19:04.950000 | 17650 | 940.2
2023-06-02 09:19:04.950000 | 17700 | 890
RESPECTED MEMBERS
i have mintioned data , in which "A1" Column refer time "B1" column refer strike price and "C1" column refer price as shown in the following Manner
The data will come in Column "A", "B" and "C" Column in 1 Minute interval Time Frame through VBA code
I want Required automatic calculation as showing in Coulumn "E","F","G","H" and "I" in mentioned following mannar. The Calculation will be Current time Frame Price of Same Strike will be Substract by Previous Time Frame Price .
Will it Possible , Please Help for this Logical Formula
Spreadsheet: 163927d1340552650-using-sumifs-to-add-specific-criteria-sample-excel-noob-oeldere2-
Sheet: Sheet1

year | team | category | points |  | texans | 0 |  | this is my two formula but it failed
2001 | texans | off | 100 |  | texans | 100
2001 | texans | def | 200
2001 | eagle | off | 300 |  |  | I want the texans to add up to be 100+500=600 in G1
2001 | eagle | def | 400
2002 | texans | off | 500 |  |  | this is my 2 formulas but it's failed,
2002 | texans | def | 600 |  |  | SUMIFS(points,team,F1,category,"off",year,"2001",category,"2002")
2002 | eagle | off | 700 |  |  | SUMIFS(points,team,F2,category,"off",year,{"2001";"2002"})
2002 | eagle | def | 800
 |  |  |  |  |  | can someone help me get the texans to add up to be 600 in offense in 2001 and 2002?
 |  |  |  |  |  | off | texans | eagle | total
 |  |  |  |  | 2001 |  | 100 | 300 | 400
 |  |  |  |  | 2002 |  | 500 | 700 | 1200
 |  |  |  |  |  |  | 600 | 1000 | 1600
 |  |  |  |  | Som van points |  | year
 |  |  |  |  | team | category | 2001 | 2002 | Eindtotaal
 |  |  |  |  | eagle | def | 400 | 800 | 1200
 |  |  |  |  |  | off | 300 | 700 | 1000
 |  |  |  |  | Totaal eagle |  | 700 | 1500 | 2200
 |  |  |  |  | texans | def | 200 | 600 | 800
 |  |  |  |  |  | off | 100 | 500 | 600
 |  |  |  |  | Totaal texans |  | 300 | 1100 | 1400
 |  |  |  |  | Eindtotaal |  | 1000 | 2600 | 3600
Spreadsheet: 723515d1615745942-if-and-or-help-status-formula
Sheet: Sheet1

Pending Live | Pending Loss | Live | Loss |  |  |  |  |  | ME | NO END
(SSD>MonthEnd)&(SED=9999) | (SSD<MonthEnd)&(SED<9999) OR (SED<SSD) | (SSD<MonthEnd)&(SED=9999) | (SED<MonthEnd) |  |  |  |  |  | 2021-02-28 00:00:00 | 9999-12-31 00:00:00
Pending Live | Pending Loss | Live | Lost | Total formula |  | Status | SSD | SED
 |  |  |  |  |  | Pending Loss | 2021-03-06 00:00:00 | 2021-03-05 00:00:00
 |  |  |  |  |  | Live | 2021-01-01 00:00:00 | 9999-12-31 00:00:00
 |  |  |  |  |  | Lost | 2021-01-01 00:00:00 | 2021-02-02 00:00:00
 |  |  |  |  |  | Pending Live | 2021-05-01 00:00:00 | 9999-12-31 00:00:00
 |  |  |  |  |  | Pending Loss | 2020-12-01 00:00:00 | 2021-04-01 00:00:00
Spreadsheet: 86232d1286252507-a-formula-to-update-information-daily-between-two-sheets-book1
Sheet: Master_Sheet

Date | Data1 | Data2 | Data3
9/29/2010 | 3 | 5 | 7
9/30/2010 | 8 | 1 | 9
10/1/2010 | 5 | 3 | 3
10/2/2010 | 7 | 5 | 8
10/3/2010 | 10 | 1 | 2
10/4/2010 | 10 | 3 | 7
10/5/2010 | 14 | 25 | 25