tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 587314d1534955331-conditional-formula-based-on-sales-amount-bonus
Sheet: Sheet2

 |  |  |  | Criteria : | Bonus
 |  |  |  | Sales amount | Less than 500k - 0%
 |  |  |  | Greater than 500k and upto  750K | Greater than 500k and upto  750K - 1.5%
 |  |  |  | Greater than 750k and upto  1M | First 750K = 1.5%, Next 250k  - 2%
 |  |  |  | Greater than 1M and upto 2M | First 750K = 1.5%, upto 1M Next 250K = 2% ; upto Next 1M=3%
 |  |  |  | Greater than 3M | First 750K = 1.5%, upto 1M Next 250K = 2% ; upto Next 1M=3% ; Next =5%
Bonus Rate based on Sales
Input | Input | [NAME] |  | Example of 1,350,000
[NAME] | Sales amount | Bonus Amount |  | Sales | Rate | Bonus
Sales 1 | 560000 |  |  | 750000 | 0.015
Sales 2 | 751000 |  |  | 250000 | 0.02
Sales 3 | 795000 |  |  | 350000 | 0.03
Sales 4 | 2300000
Sales 5 | 3500000
Sales 6 | 1350000
 |  |  |  | Example of 2,300,000
 |  |  |  | Sales | Rate | Bonus
 |  |  |  | 750000 | 0.015
 |  |  |  | 250000 | 0.02
 |  |  |  | 1300000 | 0.03
 |  |  |  | Example of 3,500,000
 |  |  |  | Sales | Rate | Bonus
 |  |  |  | 750000 | 0.015
 |  |  |  | 250000 | 0.02
 |  |  |  | 1000000 | 0.03
 |  |  |  |  | 0.05
Spreadsheet: 685820d1594213934-counting-pieces-in-a-lump-sentence-2020-07-08-oeldere-complus865-685818d1594213069-counting-pieces-in-a-lump-sentence-stocktake-
Sheet: Sheet1

January | Balloon = 10 pcs
February | IWD = 2 pcs | Basketball = 6 pcs |  |  |  |  |  |  | Quantity
March |  |  |  |  |  |  |  | Balloon | 10
April |  |  |  |  |  |  |  | Basketball | 15
May | Basketball = 8 pcs | Tennis = 7 pcs | Softball = 2 pcs |  |  |  |  | IWD | 2
June |  |  |  |  |  |  |  | Tennis | 7
July |  |  |  |  |  |  |  | Softball | 2
August
September
October
November
December
Spreadsheet: 204468d1357544031-production-line-calculation-production-sample
Sheet: Database

Workings:
Daily Minute workings:
Workers | 30
Hours every worker | 8
Total:
[NAME] |  |  |  |  |  |  |  | Workings for the delivery dates fo amount of doors
Flush Door | 560 |  |  |  |  |  |  | Qty | Product: | Minutes needed | Days needed
 |  |  |  |  |  |  |  | 56
Spreadsheet: 804530d1668126360-excel-formula-for-mapping-to-a-common-index-range-health-index-table-example
Sheet: Sheet1

 |  |  |  | Excel formula: | =MIN(MAX(80*(PI-Base)/(Target-Base);-20);100)
 |  |  |  |  | calc | we assign | calc
Performance indicator | Unit | Base | Target | Actual (PI) | Index points | Weight | Weighted points
Days to clear backlog (the less the better) | Days | 5 | 3 | 2 | =MIN(MAX(80*(E4-C4)/(D4-C4);-20);100) | 0.1
Time to resolve [NAME] (by prioirty) (the less the better) | Days | 14 | 10 | 10 |  | 0.15
Time to resolve P75 (by priority) (the less the better) | Days | 12 | 8 | 8 |  | 0.15
CSAT (max 5) | 1 to 5 | 4.4 | 4.5 | 5 |  | 0.2
Var to required capacity (negative bad, positive good) | % | -0.1 | -0.05 | -0.05 |  | 0.2
IR Met % (max 100%) | % | 0.9 | 0.95 | 1 |  | 0.2
 |  |  |  |  |  |  |  | anything 80 and above will be green
 |  |  |  |  |  | Must sum up to 100%
Spreadsheet: 00637df4-d7f9-45e5-b5dc-662d9ad3c881
Sheet: Sheet1

[NAME]
HIGH GROUP |  | WRITTEN | DIMENSIONS
RATER | A | B | C | D | E | F | G | H
1 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
2 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
3 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
4 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
5 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
6 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
7 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
8 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
9 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
10 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
11 | 2 | 2 | 2 | 2 | 2 | 2 | 2 | 2
PERCENTAGE AGGREMENT
 | 100 | 100 | 100 | 100 | 100 | 100 | 100 | 100
LOW GROUP
RATER | A | B | C | D | E | F | G | H
1 | 1 | 1 | 2 | 1 | 2 | 1 | 1 | 2
2 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
3 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2
4 | 2 | 1 | 1 | 1 | 1 | 1 | 1 | 2
5 | 1 | 1 | 2 | 1 | 1 | 1 | 1 | 2
6 | 1 | 1 | 2 | 1 | 1 | 1 | 1 | 2
7 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
8 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2
9 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 2
10 | 1 | 1 | 1 | 1 | 1 | 2 | 1 | 2
11 | 2 | 1 | 2 | 1 | 1 | 2 | 1 | 2
PERCENTAGE AGGREMENT
 |  | 100 |  | 100
 |  | 1= RETURN FOR CORRECTIONS |  |  | 2= COMPETENT
 | A = KNOWLEDGE OF CONTENT AND PEDAGOGY
 | B = DEMONSTRATES KNOWLEDGE OFSTUDENTSW
 | C = SELECTS KEY KNOWLEDGE AND SKILLS
 | D = KNOWLEDGE OF/MAKES USE OF MATERIALS, RESOURCES, AND TECHNOLOGY
 | E = DESIGNS ACTIVITIES THAT PROMOTE STUDENT LEARNING
 | F = PLANS TO ASSESS STUDENT LEARNING
 | G = ASSESSES STUDENT LEARNING
 | H = REFLECTS ON TEACHING
 | Interrater agreement high on written evaluation of high group.
 | Interrater agreement was adequate on written evaluation of low group.
 | Interrater agreement will assessed again during the spring semester.
Spreadsheet: 0d485e9c-762d-4fa3-a02c-beea92829ec4
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9
 |  |  | Fuel Expense / Claim Comparison
 |  |  |  |  |  | Form publish date: 7/1/2011
This form is used to: compare the reimbursement or PCard purchase of gasoline to the potential mileage claim. |  |  |  | Supervisory approval to use a personal vehicle is required prior to travel. Complete this form. Attach to the Exhibit J. Submit to your travel liaison within 5 days after returning from travel.
Please identify currency as USD or Foreign
Name: |  |  |  |  |  | Date:     ____/____/____
Emplid:
Date | Address Departed from |  |  |  | Address Arrived at |  |  |  | Mileage
 |  |  |  |  |  | [NAME] |  |  | 0
 |  |  |  |  |  | Reimbursement rate |  |  | 0.445
 |  |  |  |  |  | Maximum reimbursement |  |  | 0
Attach Copy of Receipt Here (tape)
Spreadsheet: 82494d1282575989-excel-graph-book1
Sheet: Sheet1

Week | 2010-07-02 00:00:00 | 2010-07-09 00:00:00 | 2010-07-16 00:00:00 | 2010-07-23 00:00:00 | 2010-07-30 00:00:00 | 2010-08-06 00:00:00 | 2010-08-13 00:00:00 | 2010-08-20 00:00:00 | 2010-08-27 00:00:00 | 2010-09-03 00:00:00 | 2010-09-10 00:00:00 | 2010-09-17 00:00:00 | 2010-09-24 00:00:00 | 2010-10-01 00:00:00 | 2010-10-08 00:00:00 | 2010-10-15 00:00:00 | 2010-10-22 00:00:00 | 2010-10-29 00:00:00 | 2010-11-05 00:00:00 | 2010-11-12 00:00:00 | 2010-11-19 00:00:00 | 2010-11-26 00:00:00 | 2010-12-03 00:00:00 | 2010-12-10 00:00:00 | 2010-12-17 00:00:00 | 2010-12-24 00:00:00 | 2010-12-31 00:00:00 | 2011-01-07 00:00:00 | 2011-01-14 00:00:00 | 2011-01-21 00:00:00 | 2011-01-28 00:00:00 | 2011-02-04 00:00:00 | 2011-02-11 00:00:00 | 2011-02-18 00:00:00 | 2011-02-25 00:00:00 | 2011-03-04 00:00:00 | 2011-03-11 00:00:00 | 2011-03-18 00:00:00 | 2011-03-25 00:00:00 | 2011-04-01 00:00:00 | 2011-04-08 00:00:00 | 2011-04-15 00:00:00 | 2011-04-22 00:00:00 | 2011-04-29 00:00:00 | 2011-05-06 00:00:00 | 2011-05-13 00:00:00 | 2011-05-20 00:00:00 | 2011-05-27 00:00:00 | 2011-06-03 00:00:00 | 2011-06-10 00:00:00 | 2011-06-17 00:00:00 | 2011-06-24 00:00:00 | 2011-07-01 00:00:00
Percentage | 0.14 | 0.139 | 0.142 | 0.139 | 0.145 | 0.148 | 0.147
Target | 0.15 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0.14
Spreadsheet: 163406d1340292916-trying-to-pull-data-from-other-worksheet-using-a-formula-dependent-on-a-drop-down-list-excel-help
Sheet: Jan 2012

Supplier (Product) | ProductCode | Product sold | Selling Branch | Region | Quantity | Sales | Product
QUINN RADIATORS LTD (0001551A) | H030543 | H030543 - QUINN W/STYLE SC RAD 400X500 Q11405CW | ABBEYWOOD (241) | A | 1 | 16.96 | WARM
QUINN RADIATORS LTD (0001551A) | H030555 | H030555 - QUINN W/STYLE SC RAD 500X600 Q11506CW | ABBEYWOOD (241) | A | 1 | 20.55 | DESIGN
QUINN RADIATORS LTD (0001551A) | H030559 | H030559 - QUINN W/STYLE SC RAD 500X1000 Q11510CW | ABBEYWOOD (241) | A | 2 | 53.92 | COMPACT
QUINN RADIATORS LTD (0001551A) | H030559 | H030559 - QUINN W/STYLE SC RAD 500X1000 Q11510CW | ABBEYWOOD (241) | C | 2 | 59.58 | ELECTRIC
QUINN RADIATORS LTD (0001551A) | H030561 | H030561 - QUINN W/STYLE SC RAD 500X1400 Q11514CW | ABBEYWOOD (241) | D | 1 | 41.55 | ROUND
QUINN RADIATORS LTD (0001551A) | H030564 | H030564 - QUINN W/STYLE SC RAD 600X400 Q11604CW | ABBEYWOOD (241) | F | 1 | 16.46 | WARM
QUINN RADIATORS LTD (0001551A) | H030565 | H030565 - QUINN W/STYLE SC RAD 600X500 Q11605CW | ABBEYWOOD (241) | F | 1 | 19.82 | COMPACT
QUINN RADIATORS LTD (0001551A) | H030565 | H030565 - QUINN W/STYLE SC RAD 600X500 Q11605CW | ABBEYWOOD (241) | F | 2 | 39.64 | ELECTRIC
QUINN RADIATORS LTD (0001551A) | H030566 | H030566 - QUINN W/STYLE SC RAD 600X600 Q11606CW | ABBEYWOOD (241) | B | 1 | 21.45 | WARM
QUINN RADIATORS LTD (0001551A) | H030568 | H030568 - QUINN W/STYLE SC RAD 600X800 Q11608CW | ABBEYWOOD (241) | E | 1 | 29 | ELECTRIC
QUINN RADIATORS LTD (0001551A) | H030568 | H030568 - QUINN W/STYLE SC RAD 600X800 Q11608CW | ABBEYWOOD (241) | E | 1 | 29 | LST
QUINN RADIATORS LTD (0001551A) | H030573 | H030573 - QUINN W/STYLE SC RAD 600X1600. Q11616CW | ABBEYWOOD (241) | G | 2 | 99.58 | COMPACT
QUINN RADIATORS LTD (0001551A) | H030591 | H030591 - QUINN W/STYLE DP+ RAD 500X1000 Q21510CW | ABBEYWOOD (241) | A | 2 | 100.06 | COMPACT
QUINN RADIATORS LTD (0001551A) | H030593 | H030593 - QUINN W/STYLE DP+ RAD 500X1400 Q21514CW | ABBEYWOOD (241) | A | 1 | 58.12 | WARM
QUINN RADIATORS LTD (0001551A) | H030611 | H030611 - QUINN W/STYLE DC RAD 400X800 Q22408CW | ABBEYWOOD (241) | A | 1 | 43.86 | ROUND
Spreadsheet: 49523d1248882748-find-average-from-each-column-dcraker-sample-1-
Sheet: Shauna

Results |  |  |  |  |  |  | Time standards exceeded
 |  |  | 481 | 7 | 0.01455301455301455 |  | h/prepping | time/s | masking | time/s | stuffing | time/s | labels | time/s | depanel | time/s | kiss | time/s | wave | time/s | stuffing/s | time/s | hand/s | time/s | touch up | time/s | wash | time/s
NAME | W/O | PROCESS | # OF BOARD | # OF REJECTS | % | TIME
SHAUNA | 654843 | solder boards | 15 |  | 0
SHAUNA | 412684 | 08S3 | 273 |  | 0
SHAUNA | 515797 | DIP | 9 | 7 | 0.7777777777777778
SHAUNA | 411245 | BAGGING | 9 |  | 0 |  |  |  |  |  |  |  | 9 | 10
SHAUNA | 198755 | BAGGING | 125 |  | 0 |  |  |  |  |  |  |  | 125 | 5
SHAUNA | 115745 | BAGGING | 50 |  | 0 |  |  |  |  |  |  |  | 50 | 20
Lists expands throughout the day
Needing to be able to get the average time from each row
and report it to the Results page with overall averages
Spreadsheet: 50354d1249744990-how-do-i-skip-a-cell-and-move-on-to-the-next-one-indexmatchkey-simple
Sheet: Data

Time | Start Time | End Time |  | KEY
Office | 500 | 600 |  | 1
Field | 600 | 700 |  | 2
Break | 700 | 800 |  | 2
Office | 800 | 900 |  | 3
Lunch | 900 | 1000 |  | 4
Field | 1000 | 1100 |  | 5
 |  |  |  | 5
 |  |  |  | 5
 |  |  |  | 5
 |  |  |  | 5
 |  |  |  | 5
 |  |  |  | 5
 |  |  |  | 5
 |  |  |  | 5
 |  |  |  | 5
Spreadsheet: 878054d1725018238-need-help-with-data-formula-dummy_data2
Sheet: Sheet2

 | X | we | rd | Y | Z | R
xx | A, C | A | A | C | C
yy | A | A | A
zz | A | A | A
zd | B |  | B | B
zf | B |  | B | B
zg | B |  | B | B
cd | C |  |  | C | C
ht | C, E | E | E | C | C
se |  | D | D |  |  | D
sr |  | D | D |  |  | D
st |  | D | D |  |  | D
hy | E | E | E
hu | E | E | E
Spreadsheet: daren_farmer__5571__HPLN1110
Sheet: Sheet1

HPLN1110.XLS |  | Fax # [PHONE]
TO:  DARREN FARMER / ENRON;  CARY METZ / ENRON;  [NAME] / HPL;  LAURA BELLAMY / ENRON
FROM:  MELISSA JONES - TXU ELECTRIC & GAS  (TU ELECTRIC)
SUBJECT:  TXU FUELS NOMINATION - November 10, 2000
 |  |  |  |  |  | **Friday
HPL AND ENRON NOMINATIONS: |  |  |  |  |  | 2000-11-10 00:00:00
 |  |  |  |  |  | Eff. 0900 hrs.
 |  |  |  |  | PRIOR | NOMINATED
CONTRACT |  | DELIVERY POINT |  | Upstream
Enron (FM) |  | LS HPL [NAME] |  | HPL | 0 | 0
 |  |  |  |  | 0 to 0  0900hrs | 0 to 0  0900hrs
 |  |  |  |  | 0  to 0 2100hrs | 0  to 0 2100hrs
 |  | Firm Summary
Enron (S) |  | Sandhills |  | HPL | 8 | 0
 |  | Enron North America Spot/3959
OTHER ENRON/HPL TRANSPORTS: |  |  |  | Downstream
 |  | Total Other Transports:
NOTE:  Additional swing volumes may be requested at Teco Tap, or Texoma by TUFCO Gas Control under either the
Wagner Brown K# 1901 or HPL K# 3949 agreements.
*  Nominations to continue until TU Electric changes such nominations.
CC:   [NAME] | [NAME]
R. Skerik | [NAME]
G. Green | K. English
B. Fleming | GCC Dispatcher
Spreadsheet: 69d0e6e2-9aba-4f96-9a7f-ed8e64e5b66e
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
FPHAI | Test | FPHAI | Phagocytic Index | Phagocytic Index | Flow Cytometry (FC) | Green-Top Tube (Sodium Heparin): GrnNaHp |  |  | 5 | mL | Draw 5 mL whole blood in a green-top (sodium heparin) tube(s). Ship immediately at ambient temperature. | 5 mL | Specimens other than	Whole blood Anticoagulants other than	Sodium heparin Hemolysis	NA Thawing	Warm reject; Cold reject Lipemia	NA Icteric	NA | Reference Range:  > or = 1.7    Interpretive Criteria:         <1.7    Impaired neutrophil phagocytic activity > or =1.7   Normal neutrophil phagocytic activity     The flow cytometric assay measures neutrophil-associated fluorescence after incubation of cells with fluorescent microspheres at both 4 degrees Centigrade and 37 degrees Centigrade. The index value represents the quotient of reactivity at 37 degrees Centigrade (adherence+phagocytosis) divided by reactivity at 4 degrees Centigrade (adherence only). A decreased phagocytic index is indicative of impaired phagocytic function, which is associated with repeated bacterial infections.      Test Performed By:  Focus Diagnostics, Inc.                                         5785 Corporate Avenue                                         Cypress, CA  93630 | Tuesday through Saturday | 1-4 days | 2-6 days | 1 | 86344 |  |  |  |  | Focus Diagnositics, Inc.
FPHAI | [NAME] | WBNAH | WB Sodium Heparin |  |  |  | Ambient | 72 hours
FPHAI | Result | Z0723 | Phagocytic Index | Phagocytic Index | Alphanumeric |  |  |  |  |  |  |  |  |  |  |  |  |  |  | In Process
Spreadsheet: 858854d1707372386-count-numbers-greater-than-zero-in-both-cells-new-microsoft-excel-worksheet
Sheet: Sheet1

Retailer Name | PCNO 100ML | PCNO 200ML | Manual Result
Dulal Store | 2 | 1 | 1
[NAME] | 3 | 0 | 0 | 0 |  | 0
Alaur Store | 12 | 6 | 1 | 1 |  | 1
[NAME] | 0 | 0 | 0 | 0 |  | 0
[NAME] | 0 | 0 | 0 | 0 |  | 0
Bipul [NAME] | 0 | 0 | 0 | 0 |  | 0
[NAME] | 0 | 0 | 0 | 0 |  | 0
[NAME] | 0 | 0 | 0 | 0 |  | 0
[NAME] | 0 | 0 | 0 | 0 |  | 0
[NAME] | 0 | 0 | 0 | 0 |  | 0
Jan store | 0 | 0 | 0 | 0 |  | 0
[NAME] | 2 | 12 | 1 | 1 |  | 1
Ongon Cosmatic | 0 | 0 | 0 | 0 |  | 0
Modina supar store | 1 | 6 | 1 | 1 |  | 1
[NAME] | 0 | 3 | 0 | 0 |  | 0
Nasim Brathers | 0 | 0 | 0 | 0 |  | 0
[NAME] | 0 | 0 | 0 | 0 |  | 0
[NAME] | 0 | 0 | 0 | 0 |  | 0
[NAME] | 0 | 0 | 0 | 0 |  | 0
[NAME] | 0 | 0 | 0 | 0 |  | 0
Spreadsheet: 267866d1380255240-use-selections-from-two-data-validation-lists-to-lookup-and-return-a-mailing-address-state-county-fips-codes
Sheet: LOOKUP

 | STATE | COUNTY | FIPS CODE |  | MAILING ADDRESS
 | NC | [NAME]
 | STATE | COUNTY | FIPS CODE |  | MAILING ADDRESS
 | NC | [NAME] |  |  | [NAME] of Deeds
 |  |  |  |  | PO Box 367
 |  |  |  |  | Jefferson, NC 28640
Spreadsheet: 849819d1700205403-formula-to-drag-and-copy-to-compute-quarterly-payments-sample-book-v2-2-aligw
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  | Payable
 | 2023-10-01 00:00:00 | 2023-11-01 00:00:00 | 2023-12-01 00:00:00 | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 |  | 2023-11-01 00:00:00 | 2023-12-01 00:00:00 | 2024-01-01 00:00:00 | 2024-02-01 00:00:00 | 2024-03-01 00:00:00 | 2024-04-01 00:00:00 | 2024-05-01 00:00:00 | 2024-06-01 00:00:00 | 2024-07-01 00:00:00 | 2024-08-01 00:00:00 | 2024-09-01 00:00:00 | 2024-10-01 00:00:00 | 2024-11-01 00:00:00 | 2024-12-01 00:00:00 | 2025-01-01 00:00:00
VAT | 0 | 100000 | 50000 | 75000 | 50000 | 35000 | 36000
Spreadsheet: 769493d1645559447-unique-count-average-percentage-and-weekly-breakdown-member-check-ins-average-check-ins-testing
Sheet: Total Members per Age Group

Starting Age | Ending Age | Total Members
13 | 19
20 | 29 |  |  | THIS NEEDS TO BE A UNIQUE COUNT OF MEMBERS BETWEEN THE AGE GROUPS
30 | 39
40 | 49 |  |  | THERE ARE TWO UNIQUE MEMBERS FOR 13-19
50 | 59
60 | 69 |  |  | THERE IS ONE UNIQUE MEMBER FOR 20-29
70 | 79
80 | 89
90 | 99999
Spreadsheet: 863278d1710837728-pull-only-jan-data-jan-data
Sheet: Sheet1

Column1 | Column2 | Column3 | Column4 | Column5 | Column6 | Column62 | Column7 | year |  |  |  | jan value | last value for year
2023-11-07 00:00:00 | p | 542 | 11.29 |  |  |  |  |  | 2023-01-01 00:00:00 | 2023-01-31 00:00:00 | 2023
2023-12-04 00:00:00 | d | 5.049 | 12.06 |  |  |  |  |  | 2024-01-01 00:00:00 | 2024-01-31 00:00:00 | 2024
2024-01-04 00:00:00 | d | 4.905 | 12.2691
2024-02-05 00:00:00 | d | 4.877 | 12.4482 |  |  |  |  |  |  |  | Correct data
2024-03-06 00:00:00 | d | 4.9 | 12.5 |  |  |  |  |  |  |  |  | Jan Value | Last value for year
2024-03-15 00:00:00 | d |  |  |  |  | 15.3 |  |  |  |  | 2023 | NA | 60.891 |  | NA - No Jan 2023 entry. Need first entry for Jan, there may be 2 or more for Jan of any given year.
 |  |  |  |  |  |  |  |  |  |  | 2024 | 60.18 | 15.3 |  | Jan 2024 value is 60.18
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Last entry for 2024 is 15.30
 | Sub-Total |  |  |  |  |  |  |  |  |  | Year | Jan Value | Last value for year
 |  |  |  |  |  |  |  |  |  |  |  |  | 60.89094000000001
 |  |  |  | Total F & G |  |  |  |  |  |  | 2024 |  | 15.3
 |  |  |  |  | 60.89094000000001
 |  |  |  |  | 60.1799355
 |  |  |  |  | 60.7098714
 |  |  |  |  | 61.25000000000001
 |  |  |  |  | 15.3
 |  |  |  |  | 0
 |  |  |  |  | 0
 |  |  |  |  | 0
Spreadsheet: 845449d1696961251-calculating-total-sum-of-item-within-a-date-range-gites
Sheet: Facture

 |  |  |  |  |  |  |  | Entre nom du client | 3 Antoinetta Bal
 |  |  |  |  |  |  |  | Reservation | All
Facture
Dates |  | Description |  | No. Nuits | Prix | Total Prix
 |  |  |  |  | Total prix de séjour
 |  |  |  |  | Taxe
 |  |  |  |  | Acomptes Reçu
 |  |  |  |  | A Payé
Spreadsheet: 214922d1361194867-duplicate-characters-in-a-cell-book1
Sheet: Sheet1

 | All possible letters |  | WPYOBGR
 |  | 1 | GPWW
 | NR | 2 | [NAME]
 |  | 3 | GOGR
 |  | 4 | RRBO
 |  | 5 | YOYY
 |  | 6 | RBBR
 | NR | 7 | BWGO
 |  | 8 | RGRR
 |  | 9 | GWGR
 |  | 10 | ORYO
 | NR | 11 | RBGY
 |  | 12 | RBYB
 |  | 13 | GGRR
 |  | 14 | BRRP
Spreadsheet: 64351d1265221136-excel-2007-2007-graph-help-raw
Sheet: Perf Issues

[NAME]/Issues  data
First Name | Last Name | Title | Department | Manager | Date Hired | Warning Start Date | Warning End Date | Type of Warning | Length of Warning (days) | Nature of Performance Concern *Required | # of Previous Warnings | New Warning (Only Place an X if it was New) | Termination (Only Place an X fs it resulted in a terml) | Successfully Completed (Only Place an X if it was Successful) | Next Steps
Q3 2009 |  |  |  |  |  |  |  |  | #N/A |  | #N/A |  |  | 0
Q4 2009 |  |  |  |  |  |  |  |  | #N/A |  | #N/A | 0 | 0 | 0
 |  | Service Tools Developer | Customer Support |  | 2008-12-09 00:00:00 | 2009-12-04 00:00:00 |  | Written | 60 |  |  | X
 |  | Sr. Cost Analyst | Finance |  | 2009-03-31 00:00:00 | 2009-10-12 00:00:00 | 2009-11-13 00:00:00 | Written | 30 | Performance |  | X | X |  | Term
 |  |  |  |  |  |  |  |  |  |  |  | 2 | 1
Q1 2010 |  |  |  |  |  |  |  |  | #N/A |  | #N/A |  | 0 | 0
 |  | Sales Manager | Sales |  | 2008-01-21 00:00:00 | 2009-12-30 00:00:00 |  | [NAME] warning (1st) | 0 | Performance | 0 | X
 |  |  |  |  |  |  |  |  |  |  |  | 1
Q2 2010 |  |  |  |  |  |  |  |  | #N/A |  | #N/A |  | 0 | 0
Q3 2010 |  |  |  |  |  |  |  |  | #N/A |  | #N/A | 0 | 0 | 0
Q4 2010 |  |  |  |  |  |  |  |  | #N/A |  | #N/A | 0 | 0 | 0
Spreadsheet: 708295d1607706975-formula-to-sum-values-between-two-dates-and-two-specific-criteria-sumvaluebetweendatefor-namesumproduct-and-week
Sheet: Table

Last | First | 2021-01-18 00:00:00 | 2021-01-22 00:00:00 | 2021-01-25 00:00:00 | 2021-01-29 00:00:00 | 2021-02-01 00:00:00 | 2021-02-05 00:00:00
DOE | [NAME]
SAME | User3
SAME | User2
Spreadsheet: 55ada785-4897-4f73-8a7d-959423089352
Sheet: Sheet1

Table S1: bound
 | CON | DIS | VOL | HYDRO | VOL+DIS | CON+DIS | CON+VOL | VOL+HYDRO | DIS+HYDRO | CON+HYDRO | DIS+CON+ HYDRO | [NAME] | VOL+DIS+ HYDRO | VOL+DIS+ CON | VOL+DIS+ CON+HYDRO
CON |  | 0.04309 | 0.005594 | 2.59e-06 | 0.08842 | 0.5799 | 0.1294 | 0.00264 | 0.001402 | 0.02048 | 0.1025 | 0.05902 | 0.03693 | 0.1768 | 0.1323
DIS | 0.957 |  | 0.2457 | 0.003395 | 0.6781 | 0.9704 | 0.761 | 0.1751 | 0.1196 | 0.3789 | 0.6642 | 0.5548 | 0.4896 | 0.7978 | 0.733
VOL | 0.9944 | 0.7546 |  | 0.01964 | 0.8799 | 0.9964 | 0.9279 | 0.4009 | 0.3023 | 0.6646 | 0.8759 | 0.8126 | 0.7543 | 0.9421 | 0.9151
HYDRO | 1 | 0.9966 | 0.9804 |  | 0.9993 | 1 | 0.9998 | 0.9652 | 0.937 | 0.9927 | 0.9991 | 0.998 | 0.9965 | 0.9998 | 0.9996
VOL+DIS | 0.9117 | 0.3223 | 0.1204 | 0.0006622 |  | 0.94 | 0.6031 | 0.07805 | 0.04872 | 0.2318 | 0.5067 | 0.3988 | 0.325 | 0.66 | 0.5829
CON+DIS | 0.4205 | 0.02964 | 0.003617 | 1.862e-06 | 0.06011 |  | 0.09623 | 0.001818 | 0.000876 | 0.01601 | 0.07957 | 0.04568 | 0.02623 | 0.1323 | 0.09932
CON+VOL | 0.8708 | 0.2393 | 0.07221 | 0.00022 | 0.3973 | 0.904 |  | 0.04444 | 0.02584 | 0.1663 | 0.4158 | 0.3115 | 0.2389 | 0.565 | 0.4888
VOL+HYDRO | 0.9974 | 0.8252 | 0.5995 | 0.03488 | 0.9221 | 0.9982 | 0.9557 |  | 0.3953 | 0.7534 | 0.9211 | 0.8737 | 0.8268 | 0.9654 | 0.9478
DIS+HYDRO | 0.9986 | 0.8806 | 0.6981 | 0.06315 | 0.9514 | 0.9991 | 0.9742 | 0.6052 |  | 0.8219 | 0.9499 | 0.9154 | 0.8791 | 0.9799 | 0.9676
CON+HYDRO | 0.9796 | 0.6216 | 0.3358 | 0.007349 | 0.7686 | 0.984 | 0.834 | 0.2469 | 0.1784 |  | 0.7631 | 0.6689 | 0.5922 | 0.8641 | 0.8187
DIS+CON+HYDRO | 0.8977 | 0.3362 | 0.1243 | 0.0008616 | 0.4937 | 0.9206 | 0.5846 | 0.07909 | 0.05022 | 0.2373 |  | 0.3919 | 0.3134 | 0.6414 | 0.5687
VOL+CON+HYDRO | 0.9411 | 0.4457 | 0.1877 | 0.001978 | 0.6016 | 0.9544 | 0.6889 | 0.1265 | 0.08475 | 0.3315 | 0.6085 |  | 0.4154 | 0.7367 | 0.6777
VOL+DIS+HYDRO | 0.9632 | 0.5108 | 0.2461 | 0.003553 | 0.6754 | 0.9738 | 0.7614 | 0.1734 | 0.1211 | 0.4083 | 0.687 | 0.585 |  | 0.8045 | 0.7481
VOL+DIS+CON | 0.8235 | 0.2025 | 0.05801 | 0.0001759 | 0.3404 | 0.868 | 0.4354 | 0.03467 | 0.02019 | 0.1361 | 0.359 | 0.2636 | 0.1958 |  | 0.426
VOL+DIS+CON+HYDRO | 0.868 | 0.2674 | 0.08508 | 0.0003542 | 0.4175 | 0.9009 | 0.5117 | 0.05227 | 0.03252 | 0.1816 | 0.4318 | 0.3227 | 0.2523 | 0.5744
Spreadsheet: 94589d1294355681-invoicing-problem-running-total-invoicingprogram
Sheet: Wed

WED
Whole | [NAME] | Mugs | Dose | Mitch | Crema | Ttruck | Roast | HrmHot | Fiddle | SkyB | Cust1 | Cust2 | RETAIL | Total
Plain | 1 | 0.5 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 2.5
ET | 1 | 1 | 1.5 | 0 | 0 | 0 | 0 |  |  | 0 |  |  | 4
WW | 1 | 0.5 | 1 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 2
CR | 1 | 0.5 | 0.5 | 0 | 0 |  |  |  |  | 0 |  |  | 2
SES | 1 | 0.5 | 1 |  | 0 |  | 0 |  |  | 0 |  |  | 2
POP | 0 | 0 | 0 |  |  |  |  |  |  |  |  |  | 1
Blue | 1 |  |  |  |  |  |  |  |  |  |  |  | 1
SourD | 0
Salt |  |  |  |  |  |  |  |  |  |  |  |  | 1
Special | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | 14.5
Total