tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: chris_germany__2913__Fall 99GELP OIL BY VENDOR
Sheet: Monthly Summary

 | FALL 1999 | SUMMARY OF FUEL OIL DELIVERIES TO GORDONSVILLE
 | COMMENTS | Plant Recorded Off-Load Meter Reading |  | BP AMOCO "GROSS" DELIVERED | MARATHON ASHLAND "GROSS" DELIVERED | CITGO    "GROSS" DELIVERED
 | Current Month Ordered |  |  | 0 | 0 | 255000
 | Current Month Delivery
 | ESTIMATED Gallons still unaccounted for… | 0 | 0
 | MONTH BEGINNING TANK INVENTORY | 4364388 | (AS STRAPPED BY PLANT)
 | PLANT RECORDED OFFLOAD TOTAL
 | ALL SUPPLIERS "GROSS" DELIVERY RECORD
 | TOTAL DIFFERENCE, Current month
Note: | This was to bring the plant up to the PPA winter period beginning |  | ESTIMATED COST SUMMARY (based on BOL, not invoice)
 | inventory level of at 4.5 million by October 1st. |  |  | "Gross" Gallons Delivered
 |  |  |  | [NAME]. Cost per gallon | 0.6934
 |  |  |  | Estimated Cost of Oil for Month
Spreadsheet: 044aa192-1a62-484e-96c0-6ec346c93213
Sheet: PAG 11 - Table 1

LAS results |  |  | Currency Translation | Organic Growth |  | % As | %
R$ million | 3Q10 | Scope |  |  | 3Q11 | Reported | Organic
Volume ('000 hl) | 7356.759999999999 | 0 | 0 | 165.802999999999 | 7522.562999999998 | 0.02253750292248213 | 0.02253750292248204
Net revenue | 852.2429999999997 | 0 | -113.586886758158 | 201.0608867581584 | 939.7170000000001 | 0.1026397400741343 | 0.2359196693409726
Net revenue/hl | 115.8448828016681 | 0 | -15.09949291992078 | 24.17440141810623 | 124.9197912998536 | 0.07833672302748251 | 0.2086790614609533
[NAME] | -355.4880000000001 | 0 | 48.901477038824 | -80.48047703882382 | -387.067 | 0.08883281573498913 | 0.2263943565994458
[NAME]/hl | -48.32127186424461 | 0 | 6.500640411894723 | -9.633507250110974 | -51.45413870246086 | 0.06483411378363213 | 0.1993636938443109
Gross profit | 496.7549999999996 | 0 | -64.68540971933402 | 120.5804097193346 | 552.6500000000001 | 0.1125202564644554 | 0.2427361772288849
Gross margin | 0.5828795308380353 | 0 | 0 | 0 | 0.5881025883324448 | 50 | 30
SG&A excl. deprec.&amort. | -195.5200000000001 | 0 | 25.1447058394084 | -37.49270583940831 | -207.868 | 0.06315466448445117 | 0.1917589292113763
SG&A deprec.&amort. | -18.28400000000001 | 0 | 2.706058049345859 | -3.446058049345851 | -19.024 | 0.04047254430102765 | 0.1884739690081957
SG&A total | -213.8040000000001 | 0 | 27.8507638887543 | -40.93876388875416 | -226.892 | 0.06121494452863296 | 0.1914780073747644
Other operating income/expenses | -4.959 | 0 | 1.891965829582912 | 1.068034170417089 | -1.998999999999999 | -0.5968945351885463 | -0.2153728917961462
Normalized EBIT | 277.9919999999995 | 0 | -34.9426800009968 | 80.70968000099754 | 323.7590000000001 | 0.1646342340786813 | 0.2903309447789781
Normalized EBIT margin | 0.3261886574603717 | 0 | 0 | 0 | 0.3445281930623795 | 180 | 140
Normalized EBITDA | 349.383 | 0 | -42.4691524720813 | 86.12315247208117 | 393.0369999999999 | 0.1249459761923157 | 0.2465006954318933
Normalized EBITDA margin | 0.4099570193008334 | 0 | 0 | 0 | 0.4182503881487723 | 80 | 40
Spreadsheet: 151734d1335095757-error-message-the-pivottable-field-is-not-valid-3ak
Sheet: MC D NIS

 | MARSHELLING CABINET  D NIS - F
 | B |  |  | C |  |  | D
 | CABLE NO. | CABLE SIZE |  | CABLE NO. | CABLE SIZE |  | CABLE NO. | CABLE SIZE
 | 1071-218-CMS-001 | 24P X 1.0 MM2 | 1071-218-CMS-MR-XXX | 1071-218-ESDD-001 | 12P X 1.0 MM2 | 1071-218-DCS-MR-XXX | 1071-218-SD-153 | 24P X 1.0 MM2 | 1071-218-JBSD-153
 | 1071-218-CMS-002 | 24P X 1.0 MM2 | 1071-218-CMS-MR-XXX | 1071-218-FGSD-001 | 12P X 1.0 MM3 | 1071-218-FGS-MR-XXX | 1071-218-SD-152 | 12P X 1.0 MM2 | 1071-218-JBSD-152
 | 1071-218-CMS-003 | 24P X 1.0 MM2 | 1071-218-CMS-MR-XXX | 1071-218-SD-183 | 24P X 1.0 MM2 | 1071-218-JBSD-183 | 1071-218-SD-182 | 12P X 1.0 MM3 | 1071-218-JBSD-182
 | 1071-218-CMS-004 | 24P X 1.0 MM2 | 1071-218-CMS-MR-XXX | 1071-218-ZSO  -023 | 1P X 1.0 MM2 | #N/A | 1071-218-SD-181 | 24P X 1.0 MM4 | 1071-218-JBSD-181
 |  |  |  | 1071-218-SD-151 | 12P X 1.0 MM2 | 1071-218-JBSD-151
 |  | 4x24P |  |  | 1X1P |  |  | 2X12P
 |  |  |  |  | 3X12P |  |  | 2X24P
 |  |  |  |  | 1X24P
 | MARSHELLING CABINET   D NIS - R
 | B |  |  | C |  |  | D
 | CABLE NO. | CABLE SIZE |  | CABLE NO. | CABLE SIZE |  | CABLE NO. | CABLE SIZE
 |  |  |  | 1071-218-IRSD-004 | 12P X 1.0 MM2 | 1071-218-IRP-XXX
 | 1071-218-IRSD-001 | 24P X 1.0 MM2 | 1071-218-IRP-XXX | 1071-218-XS   -1111 | 1P X 1.0 MM2 | 1071-218-XS   -1111 | 1071-218-IRSD-006 | 24P X 1.0 MM5 | 1071-218-IRP-XXX
 | 1071-218-IRSD-002 | 24P X 1.0 MM3 | 1071-218-IRP-XXX | 1071-218-XS   -1112 | 1P X 1.0 MM3 | 1071-218-XS   -1112 | 1071-218-IRSD-007 | 24P X 1.0 MM6 | 1071-218-IRP-XXX
 | 1071-218-IRSD-003 | 24P X 1.0 MM4 | 1071-218-IRP-XXX | 1071-218-XS   -1113 | 1P X 1.0 MM4 | 1071-218-XS   -1113 | 1071-218-IRSD-008 | 24P X 1.0 MM7 | 1071-218-IRP-XXX
 |  |  |  | 1071-218-XS   -1114 | 1P X 1.0 MM5 | 1071-218-XS   -1114
 |  |  |  | 1071-218-XS   -1115 | 1P X 1.0 MM6 | 1071-218-XS   -1115
 |  |  |  | 1071-218-XS-218 | 1P X 1.0 MM7 | 1071-218-XS-218
 |  |  |  | 1071-218-IRSD-005 | 24P X 1.0 MM4 | 1071-218-IRP-XXX
 |  |  |  |  | 1X24P |  |  | 1X24P
 |  | 3X24P |  |  | 1X12P
 |  |  |  |  | 6X1P
Spreadsheet: 725412d1616670755-help-required-in-filter-formula-filter_formula_sample-1-
Sheet: Data2

S.No. | Ticket No. | Ticket type | Status | Assigned Date | Closed Date
Spreadsheet: 856452d1705681668-counting-cells-that-meet-multiple-criteria-book1
Sheet: Sheet1

DWANEY MILLS |  |  |  |  |  |  |  |  |  | DM |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Vacations
[NAME] |  |  |  |  |  |  |  |  |  | RM |  |  |  |  | V |  |  | V
[NAME] |  |  |  |  |  |  |  |  |  | SW |  |  |  |  | V |  |  | V
[NAME] |  |  |  |  |  |  |  |  |  | JM |  | UO |  |  | UO |  |  | UO |  |  | UO |  |  | UO |  |  | UO |  |  | UO
[NAME] |  |  |  |  |  |  |  |  |  | DL |  | UO |  |  | UO |  |  | UO |  |  | UO |  |  | UO |  |  | UO |  |  | UO
HAYDEN JACKSON |  |  |  |  |  |  |  |  |  | HJ
JAQUAN MASON |  |  |  |  |  |  |  |  |  | JM
[NAME] |  |  |  |  |  |  |  |  |  | HC
BRUCE MELTON |  |  |  |  |  |  |  |  |  | BM |  | 55 |  |  | 55 |  |  | 55 |  |  | 55 |  |  | 55 |  |  | 55 |  |  | 55
[NAME] |  |  |  |  |  |  |  |  |  | CC |  | 55 |  |  | V |  |  | V |  |  | 55 |  |  | 55 |  |  | 55 |  |  | 55
DONNIE NALLEY |  |  |  |  |  |  |  |  |  | DN |  |  |  |  | V
[NAME] |  |  |  |  |  |  |  |  |  | TB |  | 55 |  |  | 55 |  |  | 55 |  |  | 55 |  |  | 55 |  |  | 55 |  |  | 55
MARTY BROOME |  |  |  |  |  |  |  |  |  | MB
CRANE OPERATOR |  |  |  |  |  |  |  |  |  | C
UNASSIGNED |  |  |  |  |  |  |  |  |  | X
Spreadsheet: 181499d1348060359-change-pivot-data-source-automatic-pivot-data-source-referenced-through-a-cell
Sheet: Sheet1

data source | bb |  | aa |  |  |  |  | bb
 |  |  | name | count |  |  |  | name | count
 |  |  | a | 1 |  |  |  | d | 4
 |  |  | b | 2 |  |  |  | e | 5
 |  |  | c | 3 |  |  |  | f | 6
 |  | Row Labels | Sum of count
 |  | d | 4
 |  | e | 5
 |  | f | 6
 |  | Grand Total | 15
Spreadsheet: 109456d1306312014-make-a-new-table-from-a-table-example-table
Sheet: Sheet1

 |  | Total
Number | Colour | Y/N | Value
1 | blue | yes | 100
2 | red | no | 150
3 | green | yes | 125
4 | red | yes | 112
Spreadsheet: c048cd6b-7f5f-4453-a660-9a581e79005e
Sheet: Sheet1

Battle ID | Date & Time | Side | Victory | Score | Opp. Score | Opp. ID | Opp. Name | Scenario ID | Front | Start Date | End Date | Name EN | Name FR
42979035 | 2014-09-01 21:05:48 | ALLIES | 1 | 4 | 1 | 1629120 | Marcius | 6158 | western | 1944-06-06 | 1944-06-06 | Pegasus Bridge | Pegasus Bridge
42979275 | 2014-09-01 21:34:03 | ALLIES | 1 | 6 | 3 | 679469 | cedmo | 8043 | eastern | 1939-09-08 | 1939-09-26 | Battle of Warsaw | Bataille de Varsovie
42979696 | 2014-09-01 21:59:32 | AXIS | 1 | 6 | 2 | 679469 | cedmo | 8043 | eastern | 1939-09-08 | 1939-09-26 | Battle of Warsaw | Bataille de Varsovie
42980164 | 2014-09-01 22:19:52 | AXIS | 1 | 5 | 0 | 1585728 | [NAME] | 6148 | western | 1944-07-25 | 1944-07-26 | Operation Cobra | Opération Cobra
42980476 | 2014-09-01 22:42:10 | ALLIES | 1 | 5 | 2 | 1585728 | [NAME] | 6148 | western | 1944-07-25 | 1944-07-26 | Operation Cobra | Opération Cobra
43072452 | 2014-09-08 12:42:14 | AXIS | 1 | 7 | 4 | 464498 | gizzzmo | 7668 | pacific | 1945-02-26 | 1945-03-06 | The Meat Grinder | Le Hachoir à viande
43077332 | 2014-09-08 21:04:25 | AXIS | 1 | 6 | 3 | 1618620 | Kuribayashi | 12502 | western | 1944-08-12 |  | Forêt d'Ecouves | La forêt d'Écouves
43077752 | 2014-09-08 21:44:42 | AXIS | 1 | 6 | 4 | 1523772 | rice dolar | 8043 | eastern | 1939-09-08 | 1939-09-26 | Battle of Warsaw | Bataille de Varsovie
43078379 | 2014-09-08 22:10:52 | ALLIES | 0 | 4 | 6 | 1523772 | rice dolar | 8043 | eastern | 1939-09-08 | 1939-09-26 | Battle of Warsaw | Bataille de Varsovie
43103728 | 2014-09-10 21:25:15 | AXIS | 1 | 5 | 2 | 1227074 | jimdonut | 6148 | western | 1944-07-25 | 1944-07-26 | Operation Cobra | Opération Cobra
43103993 | 2014-09-10 21:43:46 | ALLIES | 1 | 5 | 0 | 1227074 | jimdonut | 6148 | western | 1944-07-25 | 1944-07-26 | Operation Cobra | Opération Cobra
43104395 | 2014-09-10 22:22:53 | AXIS | 0 | 2 | 5 | 1623411 | player1623411 | 6156 | western | 1944-09-17 | 1944-09-19 | [NAME] | [NAME]
43111953 | 2014-09-11 12:00:22 | ALLIES | 1 | 5 | 1 | 1400524 | Scharon | 7665 | pacific | 1942-10-23 | 1942-10-23 | Matanikau River | Rivière Matanikau
43112004 | 2014-09-11 12:24:22 | AXIS | 0 | 4 | 5 | 1400524 | Scharon | 7665 | pacific | 1942-10-23 | 1942-10-23 | Matanikau River | Rivière Matanikau
43169406 | 2014-09-15 13:26:33 | AXIS | 0 | 3 | 5 | 1621838 | Honoré d'Estienne d'Orves | 6156 | western | 1944-09-17 | 1944-09-19 | [NAME] | [NAME]
43174207 | 2014-09-15 20:59:56 | AXIS | 1 | 5 | 4 | 689752 | Chevron Maze | 6156 | western | 1944-09-17 | 1944-09-19 | [NAME] | [NAME]
43174499 | 2014-09-15 21:12:58 | ALLIES | 1 | 5 | 2 | 689752 | Chevron Maze | 6156 | western | 1944-09-17 | 1944-09-19 | [NAME] | [NAME]
Spreadsheet: 195264d1353464265-excel-question-vlookup-need-help-with-reformatting-data-in-excel-help-request
Sheet: Sheet1

Sample | Well | Target | Ct |  | Sample | Well | Target | Ct
1 | A1 | GOI1 | 22.1 |  | 1 | A1 | REF1 | 23.1
1 | A1 | REF1 | 23.1 |  | 5 | A5 | REF1 | 22.1
2 | A2 | [NAME] | 21.2 |  | 7 | B1 | REF1 | 13.1
2 | A2 | REF2 | 24.2 |  | 11 | B5 | REF1 | 12.1
3 | A3 | GOI3 | 22.3
3 | A3 | [NAME] | 22.3 |  | Sample | Well | Target | Ct
4 | A4 | GOI4 | 21.4 |  | 2 | A2 | REF2 | 24.2
4 | A4 | REF4 | 25.4 |  | 6 | A6 | REF2 | 22.2
5 | A5 | GOI1 | 21.1 |  | 8 | B2 | REF2 | 14.2
5 | A5 | REF1 | 22.1 |  | 12 | B6 | REF2 | 12.2
6 | A6 | [NAME] | 21.2
6 | A6 | REF2 | 22.2 |  | Sample | Well | Target | Ct
7 | B1 | GOI1 | 12.1 |  | 3 | A3 | [NAME] | 22.3
7 | B1 | REF1 | 13.1 |  | 9 | B3 | [NAME] | 12.3
8 | B2 | [NAME] | 11.2
8 | B2 | REF2 | 14.2 |  | Sample | Well | Target | Ct
9 | B3 | GOI3 | 12.3 |  | 4 | A4 | REF4 | 25.4
9 | B3 | [NAME] | 12.3 |  | 10 | B4 | REF4 | 15.4
10 | B4 | GOI4 | 11.4
10 | B4 | REF4 | 15.4 |  | Sample | Well | Target | Ct
11 | B5 | GOI1 | 11.1 |  | 1 | A1 | GOI1 | 22.1
11 | B5 | REF1 | 12.1 |  | 5 | A5 | GOI1 | 21.1
12 | B6 | [NAME] | 11.2 |  | 7 | B1 | GOI1 | 12.1
12 | B6 | REF2 | 12.2 |  | 11 | B5 | GOI1 | 11.1
 |  |  |  |  | Sample | Well | Target | Ct
 |  |  |  |  | 2 | A2 | [NAME] | 21.2
 |  |  |  |  | 6 | A6 | [NAME] | 21.2
 |  |  |  |  | 8 | B2 | [NAME] | 11.2
 |  |  |  |  | 12 | B6 | [NAME] | 11.2
 |  |  |  |  | Sample | Well | Target | Ct
 |  |  |  |  | 3 | A3 | GOI3 | 22.3
 |  |  |  |  | 9 | B3 | GOI3 | 12.3
 |  |  |  |  | Sample | Well | Target | Ct
 |  |  |  |  | 4 | A4 | GOI4 | 21.4
 |  |  |  |  | 10 | B4 | GOI4 | 11.4
Spreadsheet: 28ac26eb-83cd-4684-b521-a9f9f351995e
Sheet: Sheet1

Table 3--Soybean oil:  U.S. supply and disappearance | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10 | Unnamed: 11
 | Supply |  |  |  |  | Disappearance
Year beginning | Beginning | Production | Imports | Total |  | Domestic |  |  | Exports | Total | Ending
October 1 | stocks |  |  |  |  | Total | Biodiesel | Food |  |  | stocks
 | Million pounds
2012/131 | 2540 | 19820 | 195.645 | 22555.645 |  | 18686.428 | 4689 | 13997.428 | 2164.217 | 20850.645 | 1705
2013/142 | 1705 | 19920 | 200 | 21825 |  | 18450 | 4800 | 13650 | 1750 | 20200 | 1625
2014/152 | 1625 | 19810 | 160 | 21595 |  | 18100 | 4800 | 13300 | 1700 | 19800 | 1795
1 Estimated.  2 Forecast.  Note: 1 metric ton equals 2,204.622 pounds.
Source: USDA, World Agricultural Outlook Board, World Agricultural Supply and Demand Estimates.
Last update: | 2014-06-13 08:16:31.620000
Spreadsheet: 34384d1231605166-excel-search-marcus-czerny-losas
Sheet: Caso 5a

1 | 1.05 | 1.1 | 1.15 | 1.2 | 1.25 | 1.3 | 1.35 | 1.4 | 1.45 | 1.5 | 1.55 | 1.6 | 1.8 | 2
1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
0.61 | 0.65 | 0.7 | 0.75 | 0.81 | 0.87 | 0.93 | 0.99 | 1.04 | 1.09 | 1.14 | 1.19 | 1.24 | 1.24 | 1.24
0.84 | 0.9 | 0.96 | 1.02 | 1.09 | 1.16 | 1.22 | 1.29 | 1.36 | 1.43 | 1.49 | 1.55 | 1.6 | 1.6 | 1.6
1 | 1.05 | 1.1 | 1.15 | 1.2 | 1.25 | 1.3 | 1.35 | 1.4 | 1.45 | 1.5 | 1.55 | 1.6 | 1.8 | 2
44.1 | 42.6 | 41.6 | 41 | 40.6 | 40.4 | 40.3 | 40.4 | 40.6 | 40.9 | 41.3 | 41.8 | 42.5 | 45.4 | 49
59.5 | 61.2 | 66.5 | 72 | 77.5 | 83 | 89.5 | 95 | 101 | 107 | 114 | 121 | 129 | 160 | 194
16.2 | 16.2 | 16.3 | 16.5 | 16.7 | 16.9 | 17.2 | 17.5 | 17.8 | 18.2 | 18.6 | 19 | 19.5 | 21.4 | 23.6
18.3 | 18.9 | 19.5 | 20.2 | 20.9 | 21.7 | 22.6 | 23.5 | 24.4 | 25.3 | 26.2 | 27.1 | 28 | 31.7 | 35.4
0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Spreadsheet: 130a6ae9-232f-4f12-a454-09576be442fd
Sheet: Sheet1

Unnamed: 0 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
Directions:  Fill in the Yellow cells on other pages, the rest is done automatically.
 | Monthly | Annual
Budget Summary: | Budget | Amount | %
Total Income | 8916.666666666668 | 107000 | 1
Less: Necessary Expenses | -6053.98 | -72829.76000000001 | 0.6806519626168225
Discretionary Income | 2862.686666666668 | 34170.23999999999 | 0.3193480373831775
Less: Investment Spending | -300 | -3600 | -0.03364485981308411
Discretionary Income less Investments | 2562.686666666668 | 30570.23999999999 | 0.2857031775700934
Less: Discretionary Spending | -1931.666666666667 | -23180 | 0.2166355140186916
Amount remaining to save or invest | 631.0200000000016 | 7390.239999999991 | 0.06906766355140181
Spreadsheet: 777678d1650550565-index-and-match-to-return-specific-rows-of-data-only-example-workbook
Sheet: Sheet2

Employee ID | Start Date | End Date | Wage Type | Amount | Currency | Number/Unit | Status
Sub Ref | Sub Ref | Sub Ref | Sub Ref | Sub Ref | Sub Ref | Sub Ref | Sub Ref
Employee 1 | 2022-04-01 00:00:00 | 2022-09-30 00:00:00 | 1021 | 0 | USD | 280
Employee 1 | 2022-04-01 00:00:00 | 2022-09-30 00:00:00 | 1041 | 0 | USD | 148
Employee 2 | 2022-04-01 00:00:00 | 2022-09-30 00:00:00 | 1021 | 0 | USD | 270
Employee 3 | 2022-04-01 00:00:00 | 2022-09-30 00:00:00 | 1042 | 0 | USD | 51
Employee 4 | 2022-04-01 00:00:00 | 2022-09-30 00:00:00 | 1042 | 0 | USD | 242
Employee 5 | 2022-04-01 00:00:00 | 2022-09-30 00:00:00 | 1021 | 0 | USD | 320
Employee 5 | 2022-04-01 00:00:00 | 2022-09-30 00:00:00 | 1041 | 0 | USD | 226
Spreadsheet: 135923d1326307974-auto-populate-work-order-forms-from-different-sheet-example
Sheet: New Generator

Date Called | Time | Employee | Report Provided | Return Call by | Appt Req'd | Service Date | Time | Company | Hours of operation
2011-12-01 00:00:00 | 09:00:00 | DP | NO | . | . | . | . | . | .
Days of Operation | Contact | Acct Number | Acct Status | PO Req'd | Address |  | PO # | Payment Type | City | Province
. | . | . | . | . | . | . | . | . | . | .
Postal Code | Card Number | Exp | Phone | Cell | Job Number | Fax | [NAME] | Jobsite Address | Alternate Contact | Phone
. | . | . | . | . | . | . | . | . | . | .
Last Service | Service Due | City Section | Information
. | . |  | .
Spreadsheet: 708298d1607707879-work-delay-we-have-given-a-task-and-want-to-count-how-much-is-work-delay-or-work-on-time-test-work-delay
Sheet: Sheet1

S.No. | Date | Day | Office Timing | Work Given to | Work Name | Work Deadline | Work Finish Time |  | Delay / Comp
 |  |  |  |  |  |  | Work Done | Date and Time (MM:DD:YY)
1 | 2020-12-03 00:00:00 | Thursday | 9:00 am to 6:00 pm | Rohit | Work 1 | 2020-04-12 16:00:00 | Rohit Work 1 Done | 2020-07-12 05:00:00 |  | Work Late by 19 Hour
2 | 2020-12-04 00:00:00 | Friday | 9:00 am to 6:00 pm | [NAME] | work 2 | 2020-07-12 11:00:00 | [NAME] Work 2 Done | 2020-07-12 10:30:00 |  | Work done before time
3 | 2020-12-05 00:00:00 | Saturday | 9:00 am to 6:00 pm | Rohit | Work 3 | 2020-05-12 14:00:00 | Rohit Work 3 Done | 2020-05-12 17:00:00 |  | Work Late by 3 Hour
4 | 2020-12-06 00:00:00 | Sunday | 9:00 am to 6:00 pm | Off
5 | 2020-12-07 00:00:00 | Monday | 9:00 am to 6:00 pm | [NAME] | Work4 | 2020-09-12 17:00:00 | [NAME] Work4 Done | 2020-10-12 17:00:00 |  | Work Late by 8 Hour
6 | 2020-12-08 00:00:00 | Tuesday | 9:00 am to 6:00 pm | Holiday
7 | 2020-12-09 00:00:00 | Wednesday | 9:00 am to 6:00 pm
7 | 2020-12-10 00:00:00 | Thursday | 9:00 am to 6:00 pm
 |  |  | 9:00 am to 6:00 pm | Working Hour is 9 Hour
 |  |  |  | Work 1 Deadline is, Date 04 and time 04:00 pm
 |  |  |  | Late on 04 Dec | 2 Hour
 |  |  |  | Late on 05 Dec | 9 Hour
 |  |  |  | Late on 07 Dec | 8 Hour
 |  |  |  | Total | 19 Hour | but it is showing 22 Hour
Spreadsheet: 27980d1221748357-hide-value-in-column-c-unless-data-is-enterd-in-column-b-timesheet_example
Sheet: timesheet

Date | Absent Hours | Hours Worked |  | Reason for Absence
2008-09-08 00:00:00 | 7.5 | 0 | 0 | holiday
2008-09-09 00:00:00 | 2 | 5.5 | 3 | vacation
2008-09-10 00:00:00 | 5.5 | 2 | 1 | dog died
2008-09-11 00:00:00 | 7.5 | 0 | 5 | disability
2008-09-12 00:00:00 | 0 | 7.5 | #N/A
Spreadsheet: 494284d1482314482-conditional-formatting-workbook1
Sheet: 1

 | 10/2 AI 2010 | 11/2 AI 2011 | 12/2 AI 2012 | 13/2 AI 2013 | 14/2 AI 2014 | 15/2 AI 2015 | 16/2 AI 2016 | 17/2 AI  2017 |  | Grand Total
AA | 1319 | 146395 | 44842 | 16193 |  | 8564 | -450
AA |  |  |  |  |  | 142 | 6421
AA |  |  | 2467 |  |  |  |  | 66
AA |  |  | 1515 |  |  |  |  | 1153
AA | 339 |  | 9691 | 4200 |  |  | 71411 | 8990
AA |  |  |  |  | 7611 |  | 1456
AA |  |  |  |  | 30930 | 92441 | 151779 | 8921
AA | 197824 | 87051 | 9420 | 72489 | 9828 | 91477 | 24275 | 3893
AA
AA |  |  |  |  | 28771
AA |  |  |  |  |  |  |  | 8438
AA |  | 35054 | 15672 | 1521
AA |  |  |  |  |  |  |  | 147
AA | 2904 |  | 75 |  |  |  | 6931 | 222
AA | 35878 | 222396 | 38572 | 84655 | 43254 | 398 | 21276
AA |  |  |  |  | 1907 | 65823 |  | 394
AA |  |  |  |  |  |  | 46861
AA |  |  | 36671 |  | 122063 | 18774 | 20749
AA |  |  |  | 1958 | 37275 | 20532 | 29043 | 1029
AA |  |  |  |  |  | 630
AA |  | 129 |  |  | 12356
AA | 22066 | 0 | 856927 | 454813 | 875093 | -25766 | 783
AA |  |  |  |  |  |  | 155553
AA |  |  | 10146 |  | 3220 |  | 345
AA |  |  | -134 | -331 | 124656 | 0 | 0
AA | 12698 | 17032 | 10917 | 16063 | 17139 | 41328 | 45159 | 4724
AA |  |  |  |  |  |  | 2483
AA |  | 19212 | 21366 | 10495 | 22619 | 555 |  | 862
AA
AA |  |  |  |  |  | 222 | 23691
AA |  |  |  |  |  |  |  | 112
TOTAL
NEW | 0
LOST | 0
RECOVERED | 0
Spreadsheet: 102232d1300214932-how-much-can-i-invoice-per-quarter-myexample
Sheet: Sheet1

 | Unit Price | Next Billing event (1) | Date Expected | Amount to be Invoiced (event 1) | Subsequent event (2) | Date Expected | Amount to be invoiced (event 2) | Subsequent event (3) | Date Expected (3) | Amount to be invoiced (3) | Subsequent event (4) | Date Expected (4) | Amount to be invoiced ([NAME]) | Q1 | Q2 | Q3 | Q4
Job A - Planned | 200000 | Paint house | 2011-02-01 00:00:00 | 0.25 | Fix windows | 2011-05-01 00:00:00 | 0.25 | Fix roof | 2011-08-01 00:00:00 | 0.25 | Fix garden | 2011-12-01 00:00:00 | 0.25 | 50000 | 50000 | 50000 | 50000
Job B - Planned | 15000 | Finish chassis | 2011-07-01 00:00:00 | 0.1 | Buy wheels | 2011-09-01 00:00:00 | 0.2 | Fit interior | 2011-12-01 00:00:00 | 0.3 | Win race | 2011-12-20 00:00:00 | 0.4 | 0 | 0 | 4500 | 10500
Job A - Updated | 200000 | Paint house | 2011-07-01 00:00:00 | 0.25 | Fix windows | 2011-08-01 00:00:00 | 0.25 | Fix roof | 2011-08-10 00:00:00 | 0.25 | Fix garden | 2011-12-01 00:00:00 | 0.25 | 0 | 0 | 150000 | 50000
Job B - Updated | 15000 | Finish chassis | 2011-10-10 00:00:00 | 0.1 | Buy wheels | 2011-12-01 00:00:00 | 0.2 | Fit interior | 2011-12-05 00:00:00 | 0.3 | Win race | 2012-01-10 00:00:00 | 0.4 | 0 | 0 | 0 | 9000.000000000002
 | Q1 | Q2 | Q3 | Q4
 | 2011-01-01 00:00:00 | 2011-04-01 00:00:00 | 2011-07-01 00:00:00 | 2011-10-01 00:00:00
 | 2011-03-31 00:00:00 | 2011-06-30 00:00:00 | 2011-09-30 00:00:00 | 2011-12-31 00:00:00
Spreadsheet: 26134d1218043270-sumproduct-question-lookup
Sheet: Sheet2

August
Team 1
0.7 | 7 | <-- want this cell to count how many people on Team 1have a 70% for the month of August (column D on Sheet 1)
0.78 | 1 | <-- want this cell to count how many people on Team 1have a 78% for the month of August (column D on Sheet 1)
0.84 | 3 | <-- want this cell to count how many people on Team 1have a 84% for the month of August (column D on Sheet 1)
Team 2
0.7 | 9
0.78 | 2
0.84 | 0
Team 3
0.7 | 4
0.78 | 1
0.84 | 3
Spreadsheet: 874657d1721217314-if-function-to-compare-multiple-tabs-bills-by-pay-cycle
Sheet: Bills

[NAME] | Amount | Day of the Month Due | Pay Cycle
Amazon Prime | 15.62 | 1
HIDIVE | 5.99 | 29
Boomerang | 5.99 | 14
Pokemon | 2.99 | 14
Cricut | 9.99 | 15
[NAME] | 12.95 | 15
Crunchyroll | 11.99 | 12
Ribblr | 6.99 | 12
Storage Unit | 111 | 1
Discord | 10.41 | 8
Spotify | 11.99 | 5
InstantInk | 5.2 | 5
Patreon 1 | 25.23 | 1
[NAME] | 14.99 | 27
Epic | 11.99 | 27
Student Loan | 61.54 | 24
Patreon 2 | 10 | 24
Apple TV | 9.99 | 15
iCloud | 2.99 | 28
Snapchat+ | 3.99 | 29
Peacock Premium | 5.99 | 26
Spreadsheet: 706174d1606507587-indexing-value-based-on-criteria-within-a-single-cell-book1-1-
Sheet: Sheet1

 |  |  |  | Return
Apple | Caramel |  | Apple
Orange | Juice |  | Orange
Apple | Cinnamon |  | [NAME]
Orange | Juice
[NAME] | Yogurt
Apple | Caramel
Orange | Purree
[NAME] | Pie
Orange | Purree
Spreadsheet: 846794d1697946839-extracting-a-2-digit-value-and-converting-it-into-a-3-digit-value-formulas-for-extracting-data
Sheet: 43 SERIES (2)

KIT NAME | ITEM# | HOSE | QTY | COST | TOTAL COST | FITTING 1 | QTY | COST | FITTING 2 | QTY | COST | SLEEVE/GUARD | QTY | COST | TOTAL COST | PROJECTILE | QTY | COST | CAP/PLUG | QTY | COST | TOTAL COST | CUSTOMER PRICE | GM | 0
36' Silage Trailer |  |  |  |  |  |  |  | 0 |  |  | 0 |  |  | 0 |  |  |  | 0 |  |  | 0
 | 36ST HOSE 1 | 387TC-4 | 24 |  |  | 10643-4-4 | 1 |  | 13943-4-4 | 1
 | 36ST HOSE 2 | 387TC-12 | 27 |  |  | 10643-12-12 | 1 |  | 13943-12-12 | 1
387TC-06-39-4-4-4-24.00
387TC-06-39-12-12-12-27.00
I need A3 to look like A4 but at the same time be able to use either of the options of the fitting.
Spreadsheet: 760000d1639899843-an-alternate-for-nested-if-sample-15-
Sheet: Summary

Part | Group | Std Cost | LPP | Delta | On Hand | 2022 Req | Excess | On Order | Last Purchase Date | Month and Year | Suggested Std Cost
101 | Group A | 2 | 1 |  | 10 | 20 |  | 0 | 2021-12-02 00:00:00
102 | Group A | 3 | 6 |  | 5 | 4 |  | 2 | 2021-01-01 00:00:00
103 | Group B | 4 | 7 |  | 4 | 2 |  | 2 | 2021-06-25 00:00:00
104 | Group B | 5 | 8 |  | 6 | 10 |  | 10 | 2021-02-04 00:00:00
105 | Group C | 12 | 15 |  | 80 | 100 |  | 50 | 2021-03-15 00:00:00
106 | Group C | 15 | 15 |  | 100 | 50 |  | 0 | 2021-08-05 00:00:00
107 | Group D | 4 | 6 |  | 20 | 30 |  | 0 | 2021-09-21 00:00:00
108 | Group D | 8 | 10 |  | 15 | 20 |  | 10 | 2021-02-02 00:00:00
109 | Group E | 7 | 9 |  | 200 | 250 |  | 100 | 2021-07-08 00:00:00
110 | Group E | 50 | 65 |  | 10 | 8 |  | 0 | 2021-11-21 00:00:00
 |  |  | List of criteria:
- If LPP<[NAME] cost and (2022 Req = 0,On Order=0), return LPP
- if LPP>Std cost and (2022 Req=0, On Order=0), return [NAME] cost
- if LPP>Std and (2022 Req<>0, On Order=0), return LPP
- If LPP<[NAME] and (2022Req=0, On Order<>0, group = Group B), return LPP, if group<>Group B but everything else is TRUE, return [NAME])
- If LPP>Std and (Purchase Date >= July 2021, Purchase Date<=Dec 2021, 2022Req<>0, On Order=0), return LPP
- If LPP<[NAME] and (Purchase Date >= July 2021, Purchase Date<=Dec 2021, 2022Req<>0, On Order=0), return the LPP or [NAME] (which ever is the highest)