tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 289257d1389472973-excel-2007-drop-down-box-range-help-drop-down-lists-dynamic-cascading
Sheet: Sheet1

Popular Fruit | Common Vegetables | Other Stuff
Oranges | Lettuce | Meat
Lemons | Carrots | Chocolate Bars
Grapes | Beets | Oatmeal
Bananas | Onions | Yogurt
Strawberries | Celery | Popsicles
Mangos |  | Popcorn
Cherries
Meat | Chocolate Bars | Oatmeal | Yogurt | Popsicles | Popcorn | Lettuce | Carrots | Beets | Onions | Celery | Oranges | Lemons | Grapes | Bananas | Strawberries | Mangos | Cherries
Beef | Cookie | Porridge | Danon | Green | Home Made | [NAME] | [NAME] | Pickled | Sliced | Diced | Japanese | Slices | Concord | Green | Hot House | Imported | Bing
Pork | [NAME] | Cookies | Yoplait | Red | Theatre | Romaine | Mature | Boiled | Diced | Cheese Filled | Tangerine | Wedges | Seedless | Ripe | Field
Poultry | Crispy Crunch |  | Greek | Blue |  |  | Sliced |  | Whole |  | Florida |  | Red | Over Ripe | Wild
Bear |  |  |  |  |  |  |  |  |  |  | Fresh Juice
Moose |  |  |  |  |  |  |  |  |  |  | [NAME]
Meat |  |  |  |  | Chocolate Bars |  |  | Oatmeal |  | Yogurt |  |  | Popsicles |  |  | Popcorn |  | Lettuce |  | Carrots |  |  | Beets |  | Onions
Beef | Pork | Poultry | Bear | Moose | Cookie | [NAME] | Crispy Crunch | Porridge | Cookies | Danon | Yoplait | Greek | Green | Red | Blue | Home Made | Theatre | [NAME] | Romaine | [NAME] | Mature | Sliced | Pickled | Boiled | Sliced2 | Diced | Whole
Steak | Sausage | [NAME] | Paw | Antlers | Monster | Crunchy | Coffee Taste | Cream of Wheat | With Raisons | [NAME] | Fruity | Salad | Mint | [NAME] | Blue Berry | Salted | Buttery | Heads | Local | Potatoes | Beer | Bread | Crock | Whole
Hamburger |  | Breasts |  |  |  |  |  | Lumpy | Plain |  |  |  | Lime | [NAME] |  | Unsalted | Plain | Sliced | Imported |  |  |  | [NAME] | Sliced
Roast |  |  |  |  |  |  |  | Instant
Spreadsheet: 185446d1349713468-array-search-a-two-column-list-of-building-names-and-building-codes-return-code-tempexample
Sheet: TempExample

Name | Building | Office | Office_Code | BuildingList | BuildingAbbreviation
[NAME] | Johns Hall | 1 |  | Johns Hall | JHN
[NAME] | Furman [NAME] | 2 |  | Furman [NAME] | JHN
[NAME] | Old Athletic Building | 3 |  | Old Athletic Building | ATH
Uncle Salmon | Shi Center for Sustainability | 4 |  | Shi Center for Sustainability | SCFS
[NAME] | [NAME] | 5 |  | [NAME] | XTR
Spreadsheet: 861356d1709231895-summing-values-based-on-when-they-occured-in-a-fiscal-year-sample-data-2-29-24
Sheet: Data

Type | Points |  | Min | [NAME] | Resulting Discipline |  | Status
 |  |  | 0 | 2.99 | [NAME] |  | FT
Absent | 1 |  | 2 | 2.99 | Documented Verbal Warning - CFG |  | PT
Absent - Combined (Days 2-3) | 0 |  | 3 | 5.99 | Written Warning - 1st PV
Absent - Failure to Report | 2 |  | 5 | 5.99 | Final Written Warning - Final PV
Absent - Sick | 1 |  | 6 | 100 | Termination
Bereavement | 0
Early Quit - Worked LESS than 1/2 Scheduled Day | 0.5
Early Quit - Worked MORE than 1/2 Scheduled Day | 0.5
Funeral | 0
Late - Worked MORE than 1/2 Scheduled Day | 0.5
Late - Worked LESS than 1/2 Scheduled Day | 0.5
LOA | 0
MTO/PTO | 0
Wellness | 0
Wellness 2 | 0
Wellness 4 | 0
Wellness 6 | 0
Wellness 8 | 0
Wellness 10 | 0
[NAME] | 0
WDU4 | 0
WDU6 | 0
WDU8 | 0
WDU10 | 0
Tardy | 0
Non-Schedule | 0
Spreadsheet: 390497d1429650657-grading-spreadsheet-gradebook
Sheet: Sheet1

 |  |  | Assignment | Value | [NAME]
 |  |  | Drawing 1 | 10
 |  |  | Drawing 2 | 5
 |  |  | Drawing 3 | 10
 |  |  | Drawing 4 | 5
 |  |  | Label Assignment | 25
 |  |  | Lab Exam 1 | 65
 |  |  | Lab Exam 2 | 65
 |  |  | Lab Exam 3 | 65
 |  |  | Lab Exam 4 | 75
 |  |  | Insect Collection | 175
 |  |  | Extra credit | 0
 |  |  | Lecture Exam 1 | 100
 |  |  | Lecture Exam 2 | 100
 |  |  | Lecture Exam 3 | 100
 |  |  | Points Earned
 |  |  | Points Possible
 |  |  | Grade % to Date
 |  |  | Points Needed For:
 |  |  | A
 |  |  | B
 |  |  | C
 |  |  | D
Spreadsheet: 455374d1460297115-countifs-between-date-and-time-and-criteria-start-and-end
Sheet: Sheet1

Time | Empl | Date | Composite | Start Row | Start ? | Start Time
2016-03-01 08:58:00 | BOB
2016-03-01 08:58:00 | BILL
2016-03-01 15:52:00 | BOB
2016-03-03 10:52:00 | BOB
2016-03-04 09:52:00 | BILL
2016-03-05 08:58:00 | BOB
2016-03-06 09:28:00 | BILL
2016-03-07 15:58:00 | BOB
2016-03-08 08:58:00 | BOB
2016-03-08 14:50:00 | BOB
Spreadsheet: 456120d1460651272-how-to-use-vslookup-for-3-products-book2
Sheet: Sheet1

ice cream | pick brand (gima, [NAME], bammer) |  |  |  |  |  |  | [NAME] | [NAME] | bammer
w0942 |  |  |  |  |  |  |  | 84 | 80 | 70
w1242 |  |  |  |  |  |  |  | 92 | 86 | 80
w1542 |  |  |  |  |  |  |  | 102 | 94 | 90
w1842 |  |  |  |  |  |  |  | 108 | 102 | 98
w2142 |  |  |  |  |  |  |  | 116 | 110 | 80
w2442 |  |  |  |  |  |  |  | 142 | 134 | 120
w2742 |  |  |  |  |  |  |  | 150 | 142 | 130
w3042 |  |  |  |  |  |  |  | 160 | 150 | 140
w3342 |  |  |  |  |  |  |  | 168 | 156 | 140
w3642 |  |  |  |  |  |  |  | 176 | 164 | 150
w3024 |  |  |  |  |  |  |  | 110 | 104 | 99
w3324 |  |  |  |  |  |  |  | 116 | 110 | 98
w3624 |  |  |  |  |  |  |  | 120 | 112 | 110
wdc2442 |  |  |  |  |  |  |  | 168 | 152 | 140
wea1242 |  |  |  |  |  |  |  | 88 | 82 | 80
Spreadsheet: 701482d1603792762-vlookup-for-multiple-criterias-explicativ
Sheet: worksheet

product 2
 | Starting stock
 | Consumption
 | Final stock
 | Target stock
Spreadsheet: 161429d1339516468-copy-multiple-columns-of-data-from-duplicates-in-1st-column-into-separate-sheets-0i-and-m
Sheet: A

A | ChildPartNumber | ParentPartNumber
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
A
Spreadsheet: phillip_m_love__30541__Daily Prices
Sheet: Sheet1

Summary of Central EOL Deals
All Central EOL Deals: 9/19/2001 12:35:15 PM
Product ID | [NAME] | Weighted Average | High Trade | Low Trade | [NAME]
27760 | Cons. Power (Large) | 2.2422 | 2.3 | 2.21 | 237,555
27764 | MichCon (Large) | 2.2611 | 2.29 | 2.225 | 220,949
27812 | ANR | 2.0792 | 2.0925 | 2.05 | 254,168
27813 | ANR-OK | 2.0292 | 2.05 | 1.96 | 91,170
27817 | NGPL (La Pool) | 2.0964 | 2.12 | 2.04 | 303212
27818 | NGPL (Midcontinent) | 2.0327 | 2.05 | 1.955 | 201605
27821 | NGPL (STX) | 2.0339 | 2.12 | 2 | 25,139
27822 | NGPL (TexOk East) | 2.0761 | 2.0925 | 2.0525 | 139,312
27824 | [NAME] ([NAME]) | 2.0919 | 2.145 | 2.05 | 162,746
27826 | PEPL | 2.0331 | 2.07 | 1.97 | 95,480
29490 | ONG | 1.9967 | 2.02 | 1.98 | 7,222
29602 | [NAME] | 2.2847 | 2.32 | 2.22 | 756083
32775 | [NAME] | 2.002 | 2.05 | 1.9025 | 229,093
32779 | [NAME] | 2.011 | 2.02 | 2 | 11,400
47095 | [NAME] | 2.0964 | 2.125 | 2.075 | 88,327
Chicago | Chicago City Gates | 2.1344 | 2.155 | 2.085 | 1363914
Note: EOL Deals only.
Chicago City Gates composed of Peoples, NBPL Nicor, NGPL Nicor, and NIPSCO.
Spreadsheet: joe_parks__14750__ITM Phy 04 Positions
Sheet: R10

R10!$A$4:$A$15 | R10!$D$4:$D$15 | Sum =
 | Ref |  | Net
[NAME] | Period | Curve Code | Qty
 | 2001-07-01 00:00:00 | IF-ELPO/PERMIAN | -12.5
 | 2001-07-01 00:00:00 | IF-ELPO/SJ | 11.43
 | 2001-07-01 00:00:00 | IF-HEHUB | -2.5
 | 2001-07-01 00:00:00 | IF-NWPL_ROCKY_M | 4.5
 | 2001-07-01 00:00:00 | IF-WAHA-TX | -3
 | 2001-07-01 00:00:00 | NGI-MALIN | 0.5
 | 2001-07-01 00:00:00 | NGI-SOCAL | -0.5
 | 2001-08-01 00:00:00 | IF-ELPO/PERMAN | -30.98351668
 | 2001-08-01 00:00:00 | IF-ELPO/PERMIAN | -30.98351699
 | 2001-08-01 00:00:00 | IF-ELPO/SANJUAN | 61.96703336
 | 2001-08-01 00:00:00 | IF-ELPO/SJ | 69.71291284
 | 2001-08-01 00:00:00 | IF-NWPL_ROCKY_M | -77.4587917
Spreadsheet: 690307d1597028213-countifs-question-based-on-exact-values-production-schedule-forum
Sheet: List

Project | Panel | Scheduled | Cast | Install
1 | 1P1 | 2020-08-10 00:00:00 | 2020-08-10 00:00:00 | 2020-08-20 00:00:00
1 | 1P2 | 2020-08-11 00:00:00 |  | 2020-08-20 00:00:00
1 | 1P3 | 2020-08-12 00:00:00 |  | 2020-08-20 00:00:00
2 | 2P1 | 2020-08-10 00:00:00 | 2020-08-10 00:00:00 | 2020-08-20 00:00:00
2 | 2P2 | 2020-08-11 00:00:00 |  | 2020-08-20 00:00:00
2 | 2P3 | 2020-08-12 00:00:00 |  | 2020-08-20 00:00:00
3 | 3P1 | 2020-08-10 00:00:00 |  | 2020-08-20 00:00:00
3 | 3P2 | 2020-08-11 00:00:00 |  | 2020-08-20 00:00:00
3 | 3P3 | 2020-08-12 00:00:00 |  | 2020-08-20 00:00:00
Spreadsheet: 12fec4dd-e919-4f80-913c-54598e071180
Sheet: MA

Table | Morocco |  | North Africa
 | Grain | Root | Commercial | Food aid |  | Aggregate
Year | production | production | imports | receipts |  | availability
 |  | (grain equiv.) | (grains) | (grain equiv.) |  | of all food
 |  |  | ---1,000 tons ---
2002 | 5279.406 | 341.9984466093962 | 5045.093 | 6.8018 |  | 12135.11605791315
 | 7964.172 | 359.9066610137303 | 3435.707 | 1.7524 |  | 12444.32928928748
 | 8589.677 | 380.6528824731968 | 4099.47295 | 0.139145 |  | 12821.19307813912
 | 4265.954 | 377.6436356159364 | 5058.904 | 0 |  | 12773.69853409581
 | 9225.838 | 402.5683795778372 | 3547.461 | 0 |  | 13240.73701311705
 | 2494.271 | 365.580708621066 | 6193.297 | 0 |  | 13287.39407620081
 | 5313.925 | 398.6682826838346 | 5621 | 0 |  | 13083.86513183458
 | 10424.25 | 398.6682826838346 | 3971 | 0 |  | 13300.40771175675
2010(e) | 7728.575 | 401.5842916304491 | 5794.079499735415 | 0 |  | 14345.04327999358
Projections |  |  |  | Food gaps*
 |  |  |  | NG | DG
2011 | 6328.286861144888 | 410.2775350400894 | 5161.667687661459 | 0 | 0 | 13110.99837520201
 | 6865.833463531306 | 455.624635280514 | 5690.731593329619 | 0 | 0 | 14436.39502774867
 | 7402.336869466819 | 504.2162908915678 | 6113.743377910455 | 0 | 0 | 15621.39460695457
Source: Economic Research Service, using data from FAOSTAT (grain and root and tuber production and imports), and the World Food Program (food aid).
*NR stands for nutritional requirements and describes the amount of grain equivalent needed to support nutritional standards on
a national average level. DG stands for distributional gap and it describes that amount of grain equivalent needed to allow each
income quintile to reach the nutrional requirement.
Spreadsheet: 738159d1624878289-get-address-of-the-value-maxifs-brings-samplew-aligw
Sheet: Sheet1

Name | Score | CODE |  | DESIRED OUTCOME |  | LOOKUP?
[NAME] | 50 | AB |  | DD
[NAME] | 25 | AC |  | DD
[NAME] | 80 | DD |  | DD
[NAME] | 30 | FD |  | DD
[NAME] | 45 | DS |  | DD
[NAME] | 80 | FC |  | FC
[NAME] | 70 | SA |  | FC
[NAME] | 80 | FC |  | FC
[NAME] | 55 | DE |  | FC
[NAME] | 65 | DF |  | FC
[NAME] | 25 | RC |  | AR
[NAME] | 30 | RF |  | AR
[NAME] | 65 | GG |  | AR
[NAME] | 40 | FV |  | AR
[NAME] | 90 | AR |  | AR
[NAME] | 10 | PR |  | CC
[NAME] | 50 | DK |  | CC
[NAME] | 55 | CC |  | CC
[NAME] | 40 | MV |  | CC
[NAME] | 50 | QP |  | CC
[NAME] | 25 | LS |  | GM
[NAME] | 50 | BS |  | GM
[NAME] | 55 | GM |  | GM
[NAME] | 40 | XV |  | GM
[NAME] | 45 | ZD |  | GM
Spreadsheet: 91884d1291588564-summarising-data-using-combo-box-example-2-
Sheet: Sheet1

Manufacturer | Fuel Type | man fuel | Model | Question is: summarise data by manufacturer and count how many models they have in dataset for each fuel types.
SSANGYONG | Diesel | SSANGYONGDiesel | Rodius
SSANGYONG | Diesel | SSANGYONGDiesel | Rodius
SSANGYONG | Diesel | SSANGYONGDiesel | [NAME]
SSANGYONG | Diesel | SSANGYONGDiesel | Rodius
SSANGYONG | Diesel | SSANGYONGDiesel | Kyron
SSANGYONG | Diesel | SSANGYONGDiesel | Rodius
SSANGYONG | Diesel | SSANGYONGDiesel | [NAME]
SSANGYONG | Diesel | SSANGYONGDiesel | Rodius | Fuel Type | Diesel
SSANGYONG | Diesel | SSANGYONGDiesel | Rodius
SSANGYONG | Diesel | SSANGYONGDiesel | Kyron | Row Labels | Count of Fuel Type
AUDI | Petrol | AUDIPetrol | R8 | BMW | 1
AUDI | Petrol | AUDIPetrol | R8 | SSANGYONG | 10
AUDI | Petrol | AUDIPetrol | S Series | Grand Total | 11
AUDI | Petrol | AUDIPetrol | RS6
AUDI | Petrol | AUDIPetrol | S Series
AUDI | Petrol | AUDIPetrol | R8
AUDI | Petrol | AUDIPetrol | R8
AUDI | Petrol | AUDIPetrol | S Series
AUDI | Petrol | AUDIPetrol | A8
AUDI | Petrol | AUDIPetrol | S Series
AUDI | Petrol | AUDIPetrol | S Series
AUDI | Petrol | AUDIPetrol | S Series
AUDI | Petrol | AUDIPetrol | S Series
AUDI | Petrol | AUDIPetrol | Q7
BMW | Petrol | BMWPetrol | 6 Series E63/E64
BMW | Petrol | BMWPetrol | 5 Series E60/E61
BMW | Petrol | BMWPetrol | 5 Series E60/E61
BMW | Petrol | BMWPetrol | 6 Series E63/E64
BMW | Petrol | BMWPetrol | X6 Series E71
BMW | Petrol | BMWPetrol | 3 Series E90/E91/E92/E93
BMW | Petrol | BMWPetrol | X5 Series E70
BMW | Petrol | BMWPetrol | X5 Series E70
BMW | Petrol | BMWPetrol | 3 Series E90/E91/E92/E93
BMW | Petrol | BMWPetrol | 3 Series E90/E91/E92/E93
BMW | Petrol | BMWPetrol | X6 Series E71
BMW | Petrol | BMWPetrol | 6 Series E63/E64
BMW | Petrol | BMWPetrol | 5 Series E60/E61
BMW | Petrol | BMWPetrol | 6 Series E63/E64
BMW | Petrol | BMWPetrol | 5 Series E60/E61
BMW | Petrol | BMWPetrol | X5 Series E70
BMW | Petrol | BMWPetrol | 1 Series E81/E82/E87/E88
BMW | Petrol | BMWPetrol | X3 Series E83
BMW | Petrol | BMWPetrol | 3 Series E90/E91/E92/E93
BMW | Petrol | BMWPetrol | 1 Series E81/E82/E87/E88
BMW | Petrol | BMWPetrol | 1 Series E81/E82/E87/E88
BMW | Diesel | BMWDiesel | X6 Series E71
BMW | Petrol | BMWPetrol | 3 Series E90/E91/E92/E93
Spreadsheet: 117225d1312561711-instantly-updating-graphs-in-a-powerpoint-or-word-doc-through-excel-exampe-for-excel
Sheet: sheet 1

Recuperaciones
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Counts |  |  |  |  | Total
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 1 | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 3 | 6 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 3 | 5 | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 3 | 1 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Percentages
PERDIDAS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Counts
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 2 | 1 | 4
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 3 | 6 | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 3 | 5 | 3
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 3 | 1 | 2
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Percentages
Spreadsheet: 161228d1339449336-help-with-schedule-formula-schedule2
Sheet: Sheet1

 | 2012-06-18 00:00:00 | Out | 2012-06-19 00:00:00 | Out | 2012-06-20 00:00:00 | Out | 2012-06-21 00:00:00 | Out | 2012-06-22 00:00:00 | Out | 2012-06-23 00:00:00 | Out | Week Total
ZAC | 11:30:00 | 17:15:00 | 08:00:00 | 17:00:00 | 08:00:00 | 17:00:00 | 08:15:00 | 17:15:00 | 08:00:00 | 16:30:00 | Off | Off
AMY
CHRISTIE
CHERYL
SHEILA
 | M 06/18 | T 06/19 | W 06/20 | T 06/21 | F 06/22 | S 06/23
ZAC
AMY
CHRISTIE
CHERYL
SHEILA
Spreadsheet: 1e5b4365-85b0-4f77-8d8a-1d39c36d8cb5
Sheet: 06-Jo

UNIVERSITETI I PRISHTINËS
Nr. 120
Prishtinë , më 18 . 1 . 2012.
 | Komisioni për lirim nga pagesa e semestrit të studentëve të Universitetit të Prishtinës,në mbledhjen e mbajtur më 16.1. 2012, mori
 | V E N D I M
 | Mbi mos lirimin nga pagesa e semestrit për [NAME] 2011/2012
 | [NAME] 2011/2012 [NAME] nga pagesa e semestrit këta studentë nga
 | Fakulteti i Ndërtimtarisë dhe Arkitekturës
Nr. | Emri, emri i prindit dhe mbiemri | Komuna | Kategoria | Arsyeja
1 | Arbion [NAME] | Gjilan | Prindi i vrarë | [NAME] ka vendim mbi njohjën e statusit të familjës së dëshmorit
2 | Kreshnik Ruzhdi Berisha | Dragash | Prindi i vrarë | [NAME] ka vendim mbi njohjën e statusit të familjës së dëshmorit
3 | Adoniz [NAME] | Malishevë | Asistencë sociale | [NAME] ka vendim te ndihmes socoale
4 | [NAME] | Istog | Asistencë sociale | Vendimit të ndihmës sociale i ka skaduar afati
5 | [NAME] | [NAME] | Prindi i vrarë | [NAME] ka vendim mbi njohjën e statusit të familjës së dëshmorit
6 | [NAME] | Suharekë | Prindi i vrarë | [NAME] ka vendim mbi njohjën e statusit të familjës së dëshmorit
7 | [NAME] | Suharekë | Prindi i vrarë | [NAME] ka vendim mbi njohjën e statusit të familjës së dëshmorit
8 | [NAME] | [NAME] | Asistencë sociale | [NAME] ka vendim te ndihmes socoale
9 | [NAME] | Suharekë | 3 e më shumë studentë | [NAME] në UP
10 | Armend [NAME] | Pejë | Prindi i vrarë | [NAME] ka vendim mbi njohjën e statusit të familjës së dëshmorit
 | VËREJTJE:
 | Kundër këtij [NAME] të parashtrohet ankesa e argumentuar në afat prej 8 ditësh nga dita e publikimit të këtij vendimi. Ankesa dorëzohet në fakultetin përkatës.
 |  |  |  | K O M I S I O N I:
 |  |  |  | Prof.Dr.[NAME],kryetar              ________________
 |  |  |  | [NAME], anëtar                           ________________
 |  |  |  | [NAME], anëtar                         ________________
 |  |  |  | [NAME] Samadraxha(MASHT), anëtar ________________
 |  |  |  | Fehmi Ibrahimi(MPMS), anëtar          ________________
Spreadsheet: 839378d1691912562-formula-to-average-multiple-ranges-containing-negative-numbers-and-zeros-sample
Sheet: Sheet1

[NAME]
Buy & Hold:  S&P 500 TR (Total Return Index) (SPXTR)
2022-01-01 00:00:00 | 9986.7 |  | : Start Date / Value
Date | Close Price | Daily P/L | Daily P/L % | Acct P/L %
2022-01-01 00:00:00
2022-01-02 00:00:00 | 9986.7
2022-01-03 00:00:00 | 10050.41
2022-01-04 00:00:00 | 10044.75
2022-01-05 00:00:00 | 9850.7
2022-01-06 00:00:00 | 9841.92
2022-01-07 00:00:00 | 9803.85
2022-01-08 00:00:00 | 9803.85
2022-01-09 00:00:00 | 9803.85
2022-01-10 00:00:00 | 9789.72
2022-01-11 00:00:00 | 9879.39
2022-01-12 00:00:00 | 9907.38
2022-01-13 00:00:00 | 9767.35
2022-01-14 00:00:00 | 9775.53
2022-01-15 00:00:00 | 9775.53
2022-01-16 00:00:00 | 9775.53
2022-01-17 00:00:00 | 9775.53
2022-01-18 00:00:00 | 9595.93
2022-01-19 00:00:00 | 9503.14
2022-01-20 00:00:00 | 9398.96
2022-01-21 00:00:00 | 9221.28
2022-01-22 00:00:00 | 9221.28
2022-01-23 00:00:00 | 9221.28
2022-01-24 00:00:00 | 9246.84
2022-01-25 00:00:00 | 9134.33
2022-01-26 00:00:00 | 9120.75
2022-01-27 00:00:00 | 9072.24
2022-01-28 00:00:00 | 9294.21
2022-01-29 00:00:00 | 9294.21
2022-01-30 00:00:00 | 9294.21
2022-01-31 00:00:00 | 9469.92
January
2022-02-01 00:00:00 | 9534.95
2022-02-02 00:00:00 | 9624.89
2022-02-03 00:00:00 | 9390.57
2022-02-04 00:00:00 | 9440.58
2022-02-05 00:00:00 | 9440.58
2022-02-06 00:00:00 | 9440.58
2022-02-07 00:00:00 | 9405.84
2022-02-08 00:00:00 | 9484.95
2022-02-09 00:00:00 | 9623.84
2022-02-10 00:00:00 | 9450.72
2022-02-11 00:00:00 | 9271.8
2022-02-12 00:00:00 | 9271.8
2022-02-13 00:00:00 | 9271.8
2022-02-14 00:00:00 | 9236.86
2022-02-15 00:00:00 | 9383.57
2022-02-16 00:00:00 | 9393.09
2022-02-17 00:00:00 | 9195.35
2022-02-18 00:00:00 | 9130.81
2022-02-19 00:00:00 | 9130.81
2022-02-20 00:00:00 | 9130.81
2022-02-21 00:00:00 | 9130.81
2022-02-22 00:00:00 | 9038.32
2022-02-23 00:00:00 | 8871.95
2022-02-24 00:00:00 | 9005.37
2022-02-25 00:00:00 | 9207.85
2022-02-26 00:00:00 | 9207.85
2022-02-27 00:00:00 | 9207.85
2022-02-28 00:00:00 | 9186.37
2022-02-28 00:00:00 | 9186.37
February
2022-03-01 00:00:00 | 9044.47
2022-03-02 00:00:00 | 9213.39
2022-03-03 00:00:00 | 9166.13
2022-03-04 00:00:00 | 9094.04
2022-03-05 00:00:00 | 9094.04
2022-03-06 00:00:00 | 9094.04
2022-03-07 00:00:00 | 8825.72
2022-03-08 00:00:00 | 8762.11
2022-03-09 00:00:00 | 8988.65
2022-03-10 00:00:00 | 8950.9
2022-03-11 00:00:00 | 8835.4
2022-03-12 00:00:00 | 8835.4
2022-03-13 00:00:00 | 8835.4
2022-03-14 00:00:00 | 8771.75
2022-03-15 00:00:00 | 8959.74
2022-03-16 00:00:00 | 9160.51
2022-03-17 00:00:00 | 9274.17
2022-03-18 00:00:00 | 9382.43
2022-03-19 00:00:00 | 9382.43
2022-03-20 00:00:00 | 9382.43
2022-03-21 00:00:00 | 9378.84
2022-03-22 00:00:00 | 9484.86
2022-03-23 00:00:00 | 9368.98
2022-03-24 00:00:00 | 9504.19
2022-03-25 00:00:00 | 9552.4
2022-03-26 00:00:00 | 9552.4
2022-03-27 00:00:00 | 9552.4
2022-03-28 00:00:00 | 9620.66
2022-03-29 00:00:00 | 9738.6
2022-03-30 00:00:00 | 9678.3
2022-03-31 00:00:00 | 9527.46
March
Spreadsheet: 105786d1303072521-divide-values-in-column-by-certain-previous-values-question-17-04
Sheet: Blad1

DAYS |  |  |  |  |  |  |  |  | You have to look to the collumn D if there is a 1 you buy only 1,
0 | OPEN | BUY? | Start over? | # options |  | Right answers |  |  | if there is 2 or higher you have to divide it by the previous values of column F
1 | 0.35 | 1 | 1 |  |  | 1 |  |  | In column G are the right answers I only have to automise it for a larger portfolio
2 | 0.4 | 0 |  |  |  |  |  |  | By the second time you get a 1 in collumn D you start over!
3 | 0 | 0
4 | 0 | 0 |  |  |  |  |  |  | If you look to the formulas of column G you what you need to know
5 | 0 | 0
6 | 0.25 | 1 | 2
7 | 0 | 0
8 | 0 | 0
9 | 0 | 0
10 | 0.15 | 1 | 3
11 | 0.1 | 1 | 1 |  |  | 1
12 | 0.25 | 0
13 | 0.15 | 1 | 1 |  |  | 1
14 | 0.3 | 0
15 | 0 | 0
16 | 0.25 | 1 | 1 |  |  | 1
17 | 0.2 | 0
18 | 0.15 | 0
19 | 0.15 | 1 | 2
20 | 0 | 0
21 | 0.05 | 1 | 3
22 | 0 | 0
23 | 0.15 | 1 | 4
24 | 0.1 | 0
25 | 0 | 0
26 | 0 | 0
27 | 0.05 | 1 | 1 |  |  | 1
28 | 0 | 0
29 | 0 | 0
30 | 0 | 0
31 | 0 | 0
32 | 0 | 0
Spreadsheet: 692617d1598464658-formula-to-look-at-a-different-cell-for-criteria-if-a-cell-is-blank-estimate-template
Sheet: Desired Results

Employee Name | Employee Classification | Manhours | Contract Rate | Salary
 |  |  |  |  |  | check for rounding
Company A | Labor Category 1 | 5 |  |  |  |  |  |  |  | 100.73
 | Labor Category 2 | 5 | 50 |  |  |  |  |  |  | 72.15
Company B | Labor Category 1 | 5 | 100
 | Labor Category 2 | 5 | 125
 | Totals
 | Overhead |  |  |  |  | This section to be used with unloaded rates
 | Operating Margin
 | FCCM
 | Direct Expenses
 | Overhead
 | Operating Margin
 | FCCM
 | Direct Expenses
[NAME], Expenses and FCCM
Operating Margin
Spreadsheet: 842815d1694792487-index-matching-part-of-alphanumeric-string-sample-5
Sheet: Sheet1

 | Workbook #1 |  |  |  |  | Workbook #2
 | Ref number | Category |  |  |  |  | Category
 | EG313 Staff Base | A |  |  |  | EG313Staff Base | A
 | EG315 Pantry | B |  |  |  | EG315Pantry | B
 | [NAME] | B |  |  |  | EG312Store | B
 | [NAME] | C |  |  |  | EG342Day Room | C
 | EL105 Disposal Hold | B |  |  |  | EL105Disposal Hold | B
 | [NAME] | D |  |  |  | EL103Corridor | D
 | EL315 Utility | B |  |  |  | EL315Utility | B
Spreadsheet: 12b89491-3c3a-491f-a177-7e5f22d1014e
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
 | 6427.0 Producer Price Indexes, Australia
 | Table 31. Asphalt supplied and placed, index numbers
Related Information: | Summary Publication | Explanatory Notes | Inquiries
Data Item Description |  |  | Series Type | Series ID | Series Start | Series End | No. Obs. | Unit | Data Type | [NAME]. | Collection Month
Index Number ;  Weighted Average of 6 Capital Cities ;  ASPHALT SUPPLY ; |  |  | Original | A2314821C | 1979-09-01 00:00:00 | 2009-09-01 00:00:00 | 121 | Index Numbers | INDEX | Quarter | 3
Index Number ;  Weighted Average of 6 Capital Cities ;  ASPHALT PLACED ; |  |  | Original | A2314822F | 2000-06-01 00:00:00 | 2009-09-01 00:00:00 | 38 | Index Numbers | INDEX | Quarter | 3
© Commonwealth of Australia  2009
Spreadsheet: 464967d1465391231-error-while-checking-the-check-boxes-474-checkboxes-and-graph
Sheet: monthly data

 | Month | Pageviews | unique page views | Sessions | Users | Bouncerate
 | February | 2406 | 1417 | 845 | 785 | 0.5254
 | March | 3676 | 2302 | 1501 | 1349 | 0.5989
 | April | 4419 | 2844 | 1381 | 1196 | 0.5576
 | May | 4241 | 2484 | 1596 | 1395 | 0.5925