tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 9d9ef6e9-8174-4e6d-a491-2278646c9994
Sheet: Cornstalks (10)

 | Corn Stalk Inputs |  |  |  |  |  |  |  |  |  |  |  | Cost per Pound of Purchased Nutrient
 |  |  |  |  |  |  |  |  | Calculated Values
 | FEED AVAILABILITY | Corn yield |  |  | 200 |  | bu/ac |  |  | lbs DM per acre
 |  |  |  |  |  |  |  |  |  |  |  |  |  | $ |  | per pound of Crude Protein
 |  | Stalk harvest efficiency (50% Recommended) |  |  | 0.5 |  |  |  |  | Available DM
 |  |  |  |  |  |  |  |  |  |  |  |  |  | $ |  | per pound of TDN
 |  | Total number of animals |  |  | 90 |  | head
 |  |  |  |  |  |  |  |  |  |  |  |  |  | $ |  | per pound of DM
 |  | Average animal weight |  |  | 1000
 |  | Days on corn stalks |  |  | 100 |  | days |  |  | AUMs needed |  |  | Cost per Pound of Available Nutrient
 |  | Acres rented |  |  | 135 |  | acres |  |  | Acres needed |  |  |  | $ |  | per pound of Crude Protein
 |  |  |  |  |  |  |  |  |  | Stalk Rental
 |  | Cost per acre |  | $ | 10 |  | per acre |  |  | per animal per day |  |  |  | $ |  | per pound of TDN
 | NUTRITION |  |  |  |  |  |  |  |  |  |  |  |  | $ |  | per pound of DM
 |  | Percent crude protein (on a DM basis) |  |  | 0.08
 |  | Percent TDN (on a DM basis) |  |  | 0.56 |  |  |  |  |  |  |  | Cost per Pound With Cattle Hauling
 |  |  |  |  |  |  |  |  |  |  |  |  |  | $ |  | per pound of Crude Protein
 | TRANSPORTATION | Cattle transportation distance (ranch to corn field) |  |  | 75 |  | miles
 |  |  |  |  |  |  |  |  |  | Cost / trip / truck |  |  |  | $ |  | per pound of TDN
 |  | Transportation cost per loaded mile |  | $ | 5 |  | per mile |  |  | Total transportation |  |  |  |  |  |  |  |  |  |  | 702 | DM/AUM
 |  |  |  |  |  |  |  |  |  | Cost / animal |  |  |  | $ |  | per pound of DM
 |  | Animals per load |  |  | 35
 | CARE & SUPERVISION | How far to check cattle (one way) |  |  | 60 |  | miles |  |  |  |  |  | Cost per Pound of Nutrient Consumed
 |  | Transportation cost per mile to check cattle |  | $ | 0.45 |  | per mile |  |  | Cost / visit |  |  |  | $ |  | per pound of Crude Protein
 |  |  |  |  |  |  |  |  |  | Total
 |  | Other charges (labor) per visit |  |  | 30 |  |  |  |  | Cost / animal |  |  |  | $ |  | per pound of TDN
 |  | Number of supervisory visits |  |  | 5 |  |  |  |  |  |  |  |  | $ |  | per pound of DM |  |  |  |  |  | Supervision Cost per Head
 |  |  |  |  |  |  |  |  |  |  |  |  | Data for '[NAME] Calculations
 |  | Cost per pound of feed consumed
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Lbs / Hd / Day (As Fed)
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Number of Days Fed
 | Costs Summary |  |  |  |  |  |  |  |  |  |  |  |  | Number of Cows Fed
 |  |  | Total | = | Feed | + | Transport | + | Care
 |  | Category Overall Total Costs |  | = |  | + |  | +
 |  | Category Total Per Head Costs |  | = |  | + |  | +
 |  | Category Per Head Per Day Costs |  | = |  | + |  | +
Spreadsheet: 67853d1268370720-return-sales-for-specified-month-and-department-examples
Sheet: Examples

 | EXAMPLE 1 |  |  |  |  |  |  |  |  | EXAMPLE 2
 | Month | 2010-06-01 00:00:00 | <-------- | Specified by user |  |  |  |  |  | Month | 2010-02-01 00:00:00 | <-------- | Specified by user
 | Type | Ladies | <--------- | Specified by user |  |  |  |  |  | Type | [NAME] | <--------- | Specified by user
Total |  | Mem No. | Name | Amount |  |  |  |  | Total |  | Mem No. | Name | Amount
 | ANSWER |  |  |  |  |  |  |  |  | ANSWER
 |  | Result should look like: |  |  |  |  |  |  |  |  | Result should look like:
 | Month | 2010-06-01 00:00:00 |  |  |  |  |  |  |  | Month | 2010-02-01 00:00:00
 | Type | Ladies |  |  |  |  |  |  |  | Type | [NAME]
 |  | Mem No. | Name | Amount |  |  |  |  |  |  | Mem No. | Name | Amount
 |  | 843 | [NAME] | 3 |  |  |  |  |  |  | 222 | [NAME] | 5
 |  | 320 | [NAME] | 4 |  |  |  |  |  |  | 456 | [NAME] | 9
 |  |  |  |  |  |  |  |  |  |  | 359 | [NAME] | 7
Spreadsheet: 778306d1650987061-pull-three-columns-from-one-sheet-to-another-and-have-them-aplhabetically-sorted-for-excel-help-forum-solution-with-celformatting
Sheet: Register

Registrering
 |  |  |  |  |  |  | True | True
Dato | Include | 1.Process assistant | 1.Case number | 2.Creditor | 2.Reference number | Principal | Interest rate | Costs | Total
 | Ja | A | 100 |  |  | 10000
 | Ja | D | 800 |  |  | 500
 | Nei | F |  |  |  | 2000
 | Ja | B |  |  |  | 6000
 | Ja | A | 50 |  |  | 5000
 | Ja | B | 1 |  |  | 2000
 | Ja | B |  |  |  | 1000
 | Ja | B |  |  |  | 4000
 | Nei | W | 3 |  |  | 99
 | Ja | W |  |  |  | 50
Spreadsheet: 2f8ef61e-c92a-4a7a-a2ea-cd761b69278b
Sheet: Sheet1

No | DEPARTAMENTO | DIRECCIÓN INTERNET
1 | Ahuachapán | http://matricula.mined.gob.sv/acreditacion
2 | Santa Ana | http://matricula.mined.gob.sv/acreditacion
3 | Sonsonate | http://aplicaciones05.mined.gob.sv/acreditacion
4 | Chalatenango | http://acreditacion2.mined.gob.sv/acreditacion
5 | La Libertad | http://aplicaciones06.mined.gob.sv/acreditacion
6 | San Salvador | http://sistemas.mined.gob.sv/acreditacion
7 | Cuscatlán | http://acreditacion2.mined.gob.sv/acreditacion
8 | La Paz | http://acreditacion3.mined.gob.sv/acreditacion
9 | Cabañas | http://acreditacion3.mined.gob.sv/acreditacion
10 | San Vicente | http://acreditacion2.mined.gob.sv/acreditacion
11 | Usulután | http://aplicaciones06.mined.gob.sv/acreditacion
12 | [NAME] | http://aplicaciones06.mined.gob.sv/acreditacion
13 | Morazán | http://aplicaciones05.mined.gob.sv/acreditacion
14 | La Unión | http://aplicaciones05.mined.gob.sv/acreditacion
Spreadsheet: 94884d1294656730-help-needed-agent-stats-tracker-teamstats
Sheet: CM

 |  | [NAME] | Packs Out | Collections | Packs Back | Col % 2 PB | FMP Out | FMP In | Calls Taken | Calls Out | Attendence
 | 2011-01-17 00:00:00 |  |  |  |  | 1
 | 2011-01-18 00:00:00 | 7.5 | 7 | 5 | 4 | 0.8 | 282
 | 2011-01-19 00:00:00 | 7.5 | 7 | 5 | 4 | 0.8 | 1000
 | 2011-01-20 00:00:00 | 7.5 | 7 | 4 | 4 | 1 | 664
 | 2011-01-21 00:00:00 | 7.5 | 5 | 3 | 3 | 1 | 995
 | Weekly Total | 37.5 | 33 | 21 | 19 | 0.9047619047619048 | 3391 | 0 | 0 | 0 | 0
 | 2011-01-24 00:00:00 |  | 7 | 4 | 4 | 1 | 450
 | 2011-01-25 00:00:00 |  | 7 | 5 | 4 | 0.8 | 282
 | 2011-01-26 00:00:00 |  | 7 | 5 | 4 | 0.8 | 1000
 | 2011-01-27 00:00:00 |  | 7 | 4 | 4 | 1 | 664
 | 2011-01-28 00:00:00 |  | 5 | 3 | 3 | 1 | 995
 | Weekly Total |  | 33 | 21 | 19 | 0.9047619047619048 | 3391 | 0 | 0 |  | 0
 | 2011-01-31 00:00:00 |  | 7 | 4 | 4 | 1 | 450
 | 2011-02-01 00:00:00 |  | 7 | 5 | 4 | 0.8 | 282
 | 2011-02-02 00:00:00 |  | 7 | 5 | 4 | 0.8 | 1000
 | 2011-02-03 00:00:00 |  | 7 | 4 | 4 | 1 | 664
 | 2011-02-04 00:00:00 |  | 5 | 3 | 3 | 1 | 995
 | Weekly Total |  | 33 | 21 | 19 | 0.9047619047619048 | 3391 | 0 | 0 |  | 0
 | 2011-02-07 00:00:00 |  | 7 | 4 | 4 | 1 | 450
 | 2011-02-08 00:00:00 |  | 7 | 5 | 4 | 0.8 | 282
 | 2011-02-09 00:00:00 |  | 7 | 5 | 4 | 0.8 | 1000
 | 2011-02-10 00:00:00 |  | 7 | 4 | 4 | 1 | 664
 | 2011-02-11 00:00:00 |  | 5 | 3 | 3 | 1 | 995
 | Weekly Total |  | 33 | 21 | 19 | 0.9047619047619048 | 3391 | 0 | 0 |  | 0
 | 2011-02-14 00:00:00 |  | 5 | 4 | 4 | 1
 | 2011-02-15 00:00:00 |  | 7 | 5 | 4 | 0.8
 | Weekly Total |  | 12 | 9 | 8 | 0.8888888888888888 | 0 | 0 | 0 |  | 0
 | Monthly Total |  | 144 | 93 | 84 | 0.9032258064516129 | 13564 | 0 | 0 |  | 0
Spreadsheet: vkaminski__40908__Raptor 3b
Sheet: Summary

 | Raptor III Daily Position Report & Summary
 | Inputs:
 | Trade Date |  | Prior Day
 | Summary:
 | Gains and Losses | Total | Realized | Unrealized
 | Previous Day's Cumulative | -198937966.2 | 0
 | Today's Activity
 | Cumlative Ending |  | 0
 | Notional Capacity
 | Credit Capacity
Spreadsheet: 100911d1299112609-duplicate-dates-sum-combination-sum-and-delete-duplicate-dates-amzrose-ef766728-sdg10
Sheet: Sheet1

2010-06-14 00:00:00 | 3
2010-06-15 00:00:00 | 0
2010-06-16 00:00:00 | 0
2010-06-17 00:00:00 | 0
2010-06-18 00:00:00 | 2.2
2010-06-18 00:00:00 | 9.2
2010-06-21 00:00:00 | 0
2010-06-22 00:00:00 | 0
2010-06-23 00:00:00 | 0
2010-06-24 00:00:00 | 0
2010-06-25 00:00:00 | 1.5
2010-06-25 00:00:00 | 1.1
2010-06-28 00:00:00 | 0
2010-06-29 00:00:00 | 0
2010-06-30 00:00:00 | 0
 |  |  |  |  |  |  |  |  |  | Today, 06:04 PM
 |  |  |  |  |  |  |  |  |  | Sum and Delete Duplicate Dates - amzrose - EF766728 - SDG10.xls
 |  |  |  |  |  |  |  |  |  | Registered User   Join Date: 02 Mar 2011
 |  |  |  |  |  |  |  |  |  | Location: Cincinnati
 |  |  |  |  |  |  |  |  |  | MS Office Version:Excel 2007
 |  |  |  |  |  |  |  |  |  | Posts: 1
 |  |  |  |  |  |  |  |  |  | Duplicate dates/sum combination
 |  |  |  |  |  |  |  |  |  | http://www.excelforum.com/excel-general/766728-duplicate-dates-sum-combination.html
 |  |  |  |  |  |  |  |  |  | Hello,
 |  |  |  |  |  |  |  |  |  | I'm trying to do something that intuitively seems really simple but has me stumped! I've attached some sample data.
 |  |  |  |  |  |  |  |  |  | I want to remove duplicate dates (column A) but first sum the numbers in column B.
 |  |  |  |  |  |  |  |  |  | For example, after applying the function, the date 6/18 would only appear once, and show 11.4 in a single row.
 |  |  |  |  |  |  |  |  |  | Any help for this newbie would be greatly appreciated!
 |  |  |  |  |  |  |  |  |  | Angie
 |  |  |  |  |  |  |  |  |  | 2010-06-14 00:00:00 | 3
 |  |  |  |  |  |  |  |  |  | 2010-06-15 00:00:00 | 0
 |  |  |  |  |  |  |  |  |  | 2010-06-16 00:00:00 | 0
 |  |  |  |  |  |  |  |  |  | 2010-06-17 00:00:00 | 0
 |  |  |  |  |  |  |  |  |  | 2010-06-18 00:00:00 | 2.2
 |  |  |  |  |  |  |  |  |  | 2010-06-18 00:00:00 | 9.2
 |  |  |  |  |  |  |  |  |  | 2010-06-21 00:00:00 | 0
 |  |  |  |  |  |  |  |  |  | 2010-06-22 00:00:00 | 0
 |  |  |  |  |  |  |  |  |  | 2010-06-23 00:00:00 | 0
 |  |  |  |  |  |  |  |  |  | 2010-06-24 00:00:00 | 0
 |  |  |  |  |  |  |  |  |  | 2010-06-25 00:00:00 | 1.5
 |  |  |  |  |  |  |  |  |  | 2010-06-25 00:00:00 | 1.1
 |  |  |  |  |  |  |  |  |  | 2010-06-28 00:00:00 | 0
 |  |  |  |  |  |  |  |  |  | 2010-06-29 00:00:00 | 0
 |  |  |  |  |  |  |  |  |  | 2010-06-30 00:00:00 | 0
Spreadsheet: 850426d1700757473-how-to-fill-payments-done-in-cells-automatically-888
Sheet: Folha1

 | ORDINÁRIA |  |  | SEGURO MULTIRRISCOS |  |  | QUOTA EXTRA (ABRIL 2024) |  |  | PROVISÃO OBRAS (2023)
 | DATA | VALOR |  | DATA | VALOR |  | DATA | VALOR |  | DATA | VALOR
 | 2024-01-01 00:00:00 | 428.28 |  | 2024-01-01 00:00:00 | 46.01 |  | 2024-04-01 00:00:00 | 170.35 |  | 2024-01-01 00:00:00 | 25
 | 2024-04-01 00:00:00 | 0 |  | 2024-04-01 00:00:00 | 0
 | 2024-07-01 00:00:00 | 0 |  | 2024-07-01 00:00:00 | 0
 | 2024-10-01 00:00:00 | 0 |  | 2024-10-01 00:00:00 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  | PAGAMENTOS EFETUADOS
 | 2024-01-01 00:00:00 | 250 |  | 2024-01-01 00:00:00 | 37.5 |  | 2024-01-01 00:00:00 | 170.35 |  | 2024-02-03 00:00:00 | 25 |  | QUOTAS
 | 2024-02-02 00:00:00 | 125
 |  |  |  |  |  |  |  |  |  |  |  |  | DATA |  |  |  |  |  |  |  |  |  | TOTAL
 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-01-01 00:00:00 |  | 250 |  | 37.5 |  | 170.35
 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-02 00:00:00 |  | 125
 |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-03 00:00:00 |  |  |  |  |  |  |  | 25
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Where I need to write some formulas to calculate automatilly
 |  |  |  |  |  |  |  |  |  |  |  |  | TOTAIS
Spreadsheet: 99908d1298446945-transposing-data-example
Sheet: Sheet1

 | A | B | C | D | E
2010-12-01 00:00:00
2011-01-01 00:00:00 | 3 | 2 | 12 | 12 | 2
2011-02-01 00:00:00 | 3 | 12 | 7 | 3 | 7
2011-03-01 00:00:00 | 7 | 3 | 2 | 7 | 7
2011-04-01 00:00:00 | 1 | 2 | 3 | 2 | 3
2011-05-01 00:00:00 | 2 | 3 | 7 | 2 | 5
2011-06-01 00:00:00 | 1 | 12 | 2 | 7 | 6
2011-07-01 00:00:00 | 7 | 3 | 3 | 3 | 5
2011-08-01 00:00:00 | 7 | 1 | 12 | 12 | 2
2011-09-01 00:00:00 | 3 | 12 | 7 | 6 | 3
2011-10-01 00:00:00 | 1 | 3 | 3 | 2 | 9
2011-11-01 00:00:00 | 1 | 3 | 3 | 6 | 3
2011-12-01 00:00:00 | 7 | 3 | 3 | 5 | 9
Spreadsheet: 236310d1368744250-conditional-formatting-query-conditional-formatting
Sheet: Sheet1

 |  | less than zero formatting |  |  |  | row highlight cancels out
 |  | cancels out row highlight |  |  |  | less than zero formatting
 |  | 64 | 100876.7445932163 |  |  | 64 | 100876.7445932163
 |  | 47 | 62209.68480679706 |  |  | 47 | 62209.68480679706
 |  | 7 | -147137.7257132997 |  |  | 7 | -147137.7257132997
 |  | 58 | 2271.615144781885 |  |  | 58 | 2271.615144781885
 |  | 70 | 19040.4255313363 |  |  | 70 | 19040.4255313363
 |  | this is what I want :
 |  | 64 | 100876.7445932163
 |  | 47 | 62209.68480679706
 |  | 7 | -147137.7257132997
 |  | 58 | 2271.615144781885
 |  | 70 | 19040.4255313363
Spreadsheet: 781310d1653207655-help-with-determining-the-right-formula-to-use-sample-worksheet
Sheet: Bar Tab

Month | Date | Product | Happy Hour | Category | Price | Quantity | Line Item Price | Guest/Room | Method of Payment
May | 2022-05-22 00:00:00 | Beer (can) | Yes | Beer | 0.75 | 1
May | 2022-05-22 00:00:00 | Long Island Iced Tea | No | Cocktail 2 | 3.25 | 2
Spreadsheet: 788858d1658767329-how-to-find-a-minimum-maximum-values-with-vlookup-formula-teamdata_ch220725_forum
Sheet: Sheet2

Athlete | Athlete 1 |  |  |  |  | Start Date | 2020-02-03 00:00:00
 |  |  |  | Athlete 2 |  | End Date | 2022-06-24 00:00:00
TEST | Latest |  |  | Athlete 3
 |  |  |  | Athlete 4
Fly 10 |  |  |  | Athlete 5
 |  |  |  | Athlete 6
MPH
10yd Sprint
20yd Sprint
Pro Agility
CMJ
Spreadsheet: 271149d1381846007-finance-count-if-meet-criteria-example1
Sheet: Financial Report

 |  | [NAME] |  | Chesterfield |  | Matlock |  | Long Eaton |  | Ripley
 |  | Donation |  | Donation |  | Donation |  | Donation |  | Donation
 | 2013-01-01 00:00:00
 | 2013-02-01 00:00:00
 | 2013-03-01 00:00:00
 | 2013-04-01 00:00:00
 | 2013-05-01 00:00:00
 | 2013-06-01 00:00:00
 | 2013-07-01 00:00:00
 | 2013-08-01 00:00:00
 | 2013-09-01 00:00:00
 | 2013-10-01 00:00:00
 | 2013-11-01 00:00:00
 | 2013-12-01 00:00:00
Spreadsheet: 80049d1280277614-populate-cell-value-automatically-between-different-tabs-populatecell
Sheet: Information

Number of Units:
Company Name:
Onyx ID
If not in Onyx:
Contact
Address
City
State
Zip
Phone
Fax
E-mail
Equipment Contact(s)
Equipment at Different Locations?
Addresses & POCs info available?
Photos Uploaded?
Desktop - Guarantee - Other?
Proposal Attention to?
Special Instructions for Pricing or [NAME]:
Need Pricing By:
TM Notes / Assumptions / Clarification: | RM Notes / Assumptions / Clarifications:
Spreadsheet: 778448d1651072965-index-or-last-occurrence-formula-raw-data-help
Sheet: Sheet1 (2)

Survey DATA |  |  |  |  |  | Formula/Syntax setup |  |  |  |  |  |  |  |  |  | final syntax example
NAME | TYPE | WIDTH | DECIMALS | LABEL | VALUES | [NAME] below | [NAME] below | Formula/Syntax attempt |  |  |  |  |  |  |  | count QS2.SL=Q2S.1 to QS2.16(10020).
QS2.1 | Numeric | 5 | 0 |  | {10020, Yes}... |  |  |  |  |  |  |  |  |  |  | [NAME]QS2.SL 'QS2.SL Straightliner Count'.
QS2.2 | Numeric | 5 | 0 |  | {10020, Yes}... |  |  |  |  |  |  |  |  |  |  | exe.
QS2.3 | Numeric | 5 | 0 |  | {10020, Yes}...
QS2.4 | Numeric | 5 | 0 |  | {10020, Yes}...
QS2.5 | Numeric | 5 | 0 |  | {10020, Yes}...
QS2.6 | Numeric | 5 | 0 |  | {10020, Yes}...
QS2.7 | Numeric | 5 | 0 |  | {10020, Yes}...
QS2.8 | Numeric | 5 | 0 |  | {10020, Yes}...
QS2.9 | Numeric | 5 | 0 |  | {10020, Yes}...
QS2.10 | Numeric | 5 | 0 |  | {10020, Yes}...
QS2.11 | Numeric | 5 | 0 |  | {10020, Yes}...
QS2.12 | Numeric | 5 | 0 |  | {10020, Yes}...
QS2.13 | Numeric | 5 | 0 |  | {10020, Yes}...
[NAME] | Numeric | 5 | 0 |  | {10020, Yes}...
QS2.15 | Numeric | 5 | 0 |  | {10020, Yes}...
QS2.16 | Numeric | 5 | 0 |  | {10020, Yes}...
QS3.1 | Numeric | 5 | 0 |  | {1030, [NAME] not to say}... |  |  |  |  |  |  |  |  |  |  | count QS3.SL=QS3.1 to QS3.11(1030).
QS3.2 | Numeric | 5 | 0 |  | {1030, [NAME] not to say}... |  |  |  |  |  |  |  |  |  |  | [NAME]QS3.SL 'QS3.SL Straightliner Count'.
QS3.3 | Numeric | 5 | 0 |  | {1030, [NAME] not to say}... |  |  |  |  |  |  |  |  |  |  | exe.
QS3.4 | Numeric | 5 | 0 |  | {1030, [NAME] not to say}...
QS3.5 | Numeric | 5 | 0 |  | {1030, [NAME] not to say}...
QS3.6 | Numeric | 5 | 0 |  | {1030, [NAME] not to say}...
QS3.7 | Numeric | 5 | 0 |  | {1030, [NAME] not to say}...
QS3.8 | Numeric | 5 | 0 |  | {1030, [NAME] not to say}...
QS3.9 | Numeric | 5 | 0 |  | {1030, [NAME] not to say}...
QS3.10 | Numeric | 5 | 0 |  | {1030, [NAME] not to say}...
QS3.11 | Numeric | 5 | 0 |  | {1030, [NAME] not to say}...
Spreadsheet: 843348d1695221740-count-unique-reference-number-based-on-monthly-data-date-created-and-resolved-date-formulas-help
Sheet: Data

Reference Number | Date Created | Data Source | LOB | Resolved Date
REF-003967 | 2022-12-09 00:00:00 | Source 1 | LOB 4
REF-004154 | 2023-02-27 00:00:00 | Source 1 | LOB 4
REF-003989 | 2023-01-20 00:00:00 | Source 1 | LOB 4
REF-003911 | 2023-01-12 00:00:00 | Source 1 | LOB 3
REF-003911 | 2023-01-12 00:00:00 | Source 1 | LOB 6 | 2023-08-16 00:00:00
REF-003911 | 2023-01-12 00:00:00 | Source 1 | LOB 6 | 2023-01-28 00:00:00
REF-003911 | 2023-01-12 00:00:00 | Source 1 | LOB 6
REF-003871 | 2023-01-27 00:00:00 | Source 1 | LOB 6
REF-003871 | 2023-01-27 00:00:00 | Source 1 | LOB 4
REF-003810 | 2022-11-04 00:00:00 | Source 1 | LOB 1 | 2023-08-23 00:00:00
REF-003810 | 2022-11-04 00:00:00 | Source 1 | LOB 1 | 2023-08-23 00:00:00
REF-003810 | 2022-11-04 00:00:00 | Source 1 | LOB 6
REF-003799 | 2022-12-09 00:00:00 | Source 1 | LOB 5
REF-003704 | 2022-08-19 00:00:00 | Source 1 | LOB 2 | 2023-08-24 00:00:00
REF-003704 | 2022-08-19 00:00:00 | Source 1 | LOB 4
REF-003610 | 2022-12-16 00:00:00 | Source 1 | LOB 6
REF-003563 | 2022-06-23 00:00:00 | Source 1 | LOB 5
REF-003446 | 2022-05-23 00:00:00 | Source 1 | LOB 1 | 2023-02-22 00:00:00
REF-003446 | 2022-05-23 00:00:00 | Source 1 | LOB 6
REF-003446 | 2022-05-23 00:00:00 | Source 1 | LOB 2
REF-003435 | 2022-10-18 00:00:00 | Source 1 | LOB 1
REF-003435 | 2022-10-18 00:00:00 | Source 1 | LOB 2
REF-003435 | 2022-10-18 00:00:00 | Source 1 | LOB 6
REF-003370 | 2023-01-27 00:00:00 | Source 1 | LOB 6
REF-003191 | 2022-03-24 00:00:00 | Source 1 | LOB 4
REF-002977 | 2021-12-15 00:00:00 | Source 1 | LOB 3
REF-002977 | 2021-12-15 00:00:00 | Source 1 | LOB 2
REF-002880 | 2023-01-24 00:00:00 | Source 1 | LOB 6
REF-002880 | 2023-01-24 00:00:00 | Source 1 | LOB 6 | 2023-07-23 00:00:00
REF-002878 | 2021-10-26 00:00:00 | Source 1 | LOB 6 | 2023-08-09 00:00:00
Spreadsheet: 788876d1658771855-fill-in-cells-with-data-from-another-column-2022-07-25-oeldere-rooka1-take-name-from-first-column
Sheet: Sheet1

Customer Number | Customer Name | Office | Manager
Manager: [NAME]
101 | Plumbing Co. | Main Street
105 | Heating and AC | Main Street
191 | Auto Repair, Inc. | Main Street
201 | Massage Parlor LLC | Main Street
255 | Computer Repair, LLC | Main Street
262 | Computer Hardware, LLC | West Main Street
300 | Investment Co, Inc. | West Main Street
Manager: Betty
121 | Kitchens, Inc. | East Main Street
180 | Home Refurbishing | East Main Street
360 | Letterhead Services | East Main Street
365 | Barbershop | Main Street
Manager: [NAME]
90 | Tea and Coffee, Inc. | Main Street
250 | Pizza Pie Co. | Main Street
251 | Pens and Pencils, Inc. | Main Street
252 | Main Street Construction | Main Street
299 | Hearing and Vision Services | Main Street
Manager: Betty
120 | Furniture Staging | North Main Street
122 | Textbook Suppliers | North Main Street
Spreadsheet: 760354d1640170737-attendance-and-duty-time-tracker-example-duty-time
Sheet: DEC

 |  | Duty Time Tally Sheet |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OCCURRENCES
DECEMBER |  | Year |  | 2021 |  | Manager: |  |  |  |  |  |  |  |  | Day of the week worked indicated with an "X" in the appropriate box.
 |  | STATION
Employee Name |  | 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
[NAME] |  | RT | RT |  |  |  | X | X | X | S |  |  |  | S | X | X | X |  |  |  | X | X | X | X |  |  |  | X | X | X | X |  | 1
[NAME] |  | X | X | X | X |  |  |  | S | S | X | S |  |  |  | X | X | X | X |  |  |  | X | X | X | X |  |  |  | V | V | V | 2
Todd |  |  |  |  | S | S | S | S |  |  |  | S | X | X | X |  |  |  | X | X | V | V |  |  |  | RT | RT | X | X |  |  |  | 1
[NAME] |  | V | V | V | V |  |  |  | V | V | X | X |  |  |  | X | X | X | X |  |  |  | X | X | X | X |  |  |  | X | X | X | 0
[NAME] |  | X | X | X | X |  |  |  | S | S | X | X |  |  |  | X | X | X | S |  |  | OT | X | S | X | X |  |  |  | X | X | X | 3
Spreadsheet: 111487d1307866653-correcting-an-if-statement-to-allow-for-my-than-7-nested-ifs-problem
Sheet: Sheet2

 |  |  | 22
 |  |  | 29
 |  |  |  |  |  |  |  |  |  |  | VALUE | CODE
 |  |  |  |  |  |  |  |  |  |  | 3 | M AK
 |  |  |  |  |  |  |  |  |  |  | 22 | LIB
 |  |  |  |  |  |  |  |  |  |  | 25 | SHW
 |  |  |  |  |  |  |  |  |  |  | 28 | ALB
 |  |  |  |  |  |  |  |  |  |  | 35 | CLK
 |  |  |  |  |  |  |  |  |  |  | 40 | CB1
 |  |  |  |  |  |  |  |  |  |  | 48 | CB2
Spreadsheet: 764862d1643039308-highlight-every-7th-cell-if-previous-cells-are-populated-book3
Sheet: Sheet1

2022-02-22 00:00:00 | 2022-02-23 00:00:00 | 2022-02-24 00:00:00 | 2022-02-25 00:00:00 | 2022-02-26 00:00:00 | 2022-02-27 00:00:00 | 2022-02-28 00:00:00 | 2022-03-01 00:00:00 | 2022-03-02 00:00:00
Tue | Wed | Thu | Fri | Sat | Sun | Mon | Tue | Wed
E | Van Service - Norwich | D | D | D | D | D | E | E
E |  | D | D | D | D | D | E | E
E |  | D | D | D | D | D | E | E
E |  | D | D | D | D | D | E | E
 |  |  |  |  |  |  | TC J168 McCarthy & Stone Bagshot
E | E | E | E | E | E | E | D | D
E | E | E | E | E | E | E | D | D
E | E | E | E | E | E | E | D | D
E | E | E | E | E | E | E | D | D
E | E | E | D | E | E | E | D | D
E | E | E |  |  |  | E | E
E | E | E | D |  |  | E | E
E | E | E | D |  |  | E | E
E | E | E |  |  |  | E | E
 | Holiday DLS | Holiday DLS | Holiday DLS | Booked off - confirmed | Booked off - confirmed | Holiday DLS | E
E | E | E | D | D | D |  | D | D
E | E | E | D | D | D |  | D | D
E | E | E | D | D | D |  | D | D
E | E | E | D | D | D |  | D | D
E | E | E | D | D | D | D | D | D
 | E
E | E | E | E | D | D | D | E | E
E | E | E | E | D | D | D | E | E
E | E | E | E | D | D | D | E | E
E | E | E | E | D | D | D | E | E
E | E | E | E | D | D | D | E | E
E
E | E
Spreadsheet: 120650d1315424330-help-with-if-formula-regarding-xy-scatter-chart-charts
Sheet: Sheet1 (2)

 | Y | X | MyChecks
A | 498.1874911911972 | 3326
B | 885.8616123096135 | 6262
C | 720.1788817444415 | 5184
D | #N/A | #N/A | a
E | 563.2703665836561 | 3162
F | 1076.070257841813 | 7876
G | #N/A | #N/A | a
H | 580.4512802152433 | 4081
I | 1181.634759326085 | 8155
J | 819.1229100767533 | 5457
K | 635.010991057381 | 4259
L | 801.1199678989958 | 5537
 | 498.1874911911972 | 3326
 | 885.8616123096135 | 6262
 | 720.1788817444415 | 5184
 | 496.4220313257607 | 3159
 | 563.2703665836561 | 3162
 | 1076.070257841813 | 7876
 | 655.4874941839585 | 4530
 | 580.4512802152433 | 4081
 | 1181.634759326085 | 8155
 | 819.1229100767533 | 5457
 | 635.010991057381 | 4259
 | 801.1199678989958 | 5537
Spreadsheet: 49436d1248793955-calculating-returns-and-compounding-need-a-math-expert-returns
Sheet: Sheet3

 | 1 | 3 | 3
20074 | 0.01861687999999995 | 0.0084 | -0.0007 |  | 0.9993
20081 | 0.003404616000000082 | -0.0014 | -0.0146 |  | 0.9854
20082 | -0.007032620000000045 | -0.0102 | -0.0105 |  | 0.9895
20083 | -0.01418961500000004 | -0.0163 | -0.0251 |  | 0.9749
20084 | -0.09544354799999999 | -0.0954 | -0.1103 |  | 0.8897
20091 | -0.08695924300000002 | -0.1117 | -0.1362 |  | 0.8638
20092 | -0.06699555599999996 | -0.0673 | -0.0706 |  | 0.9294
Peak-to-current | -0.2457107417935001 | -0.2712813158426985 | -0.3215094976335825 |  | -0.1988030290833204