tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 853911d1703861818-material-run-out-plan-plan-materialv3
Sheet: Sheet1 (2)

 |  | material stock type 1 kg | 800
 |  | Material On Order | 0
 |  | part | 1358 |  |  | 1356 |  |  | 1360
 |  | run qty | 600 |  |  | 200 |  |  | 600
 |  | Weight kg each | 0.8 |  |  | 0.5 |  |  | 0.7
 |  | rate per 16hr day | 50 |  |  | 20 |  |  | 60
 |  | date start | 2023-10-31 08:00:00 |  |  | 2023-11-04 08:00:00 |  |  | 2023-11-08 08:00:00
 |  | Date | Qty/Day | [NAME] |  | Qty/Day | [NAME] |  | Qty/Day | [NAME] |  | Material Runs Out
 |  | 2023-10-30 08:00:00
Spreadsheet: 760252d1640099469-following-an-input-to-cell-filter-index-the-data-sort-based-on-value
Sheet: Sheet1

Category | Item | VALUE
FOOD | APPLE | 1
FOOD | PEAR | 2 |  |  | Input | DRINK
DRINK | WATER | 0.5
FOOD | ORANGE | 1 |  |  |  | WATER | 0.5
DESERT | CHOCOLATE | 3 |  |  | DRINK | ORANGE JUICE | 5
DRINK | ORANGE JUICE | 5
Spreadsheet: 73798d1274370139-create-relationship-between-2-spreadsheets-studentsdb
Sheet: Sheet1

STUDENT ID # | LastN,FirstN | GRADE | First Name | Last Name
102820010 | Doe, [NAME] | 10 | [NAME] | Doe
102824501 | Dirks, Mary | 11 | [NAME] | Dirks
102823876 | [NAME], Julie | 12 | Julie | [NAME]
102820049 | Dern, Janice | 11 | Janice | Dern
102825932 | [NAME], [NAME] | 10 | [NAME] | [NAME]
 | ,
 | ,
 | ,
 | ,
 | ,
 | ,
 | ,
Spreadsheet: 150744d1334673877-adding-conditions-to-a-vlookup-formula-wage
Sheet: Equip. ~Labor~Hired Rates

Labor  Rates |  | Base | Burden | Total
Commerical Paving [NAME] | CPF | 32.5 | 10.13
Commerical Paving Crew Operator | CPO | 20 | 4.66
Commercial Paving [NAME] | CPL | 14.5 | 3.52
Fine Grading Crew Formen | FGF | 32.5 | 10.13
Fine Grading Crew Operator | FGF | 18.5 | 4.35
Fine Grading Crew Laborer | FGL | 13 | 3.22
Soil Cement [NAME] | SCF | 19 | 7.35
Soil Cement [NAME] | SCL | 14.5 | 3.52
[NAME] | TD | 18 | 4.25
[NAME] | SD | 22 | 5.07
Punchout [NAME] | PF | 24 | 8.38
Punchout [NAME] | PL | 12 | 3.01
[NAME] | PCF | 22.5 | 8.07
[NAME] | PCL | 16 | 3.83
[NAME] | MF | 19 | 7.35
[NAME] | ML | 16 | 3.83
Reclaim [NAME] | RF | 24.5 | 8.48
Reclaim [NAME] | RL | 18.5 | 4.35
Gradall [NAME] | GF | 27.35 | 9.07
Gradall [NAME] | GL | 16 | 3.83
MOT Crew Foreman | MOTF | 23.75 | 8.33
Spreadsheet: 849305d1699828534-how-to-copy-formulas-across-the-row-when-criteria-are-in-static-cells-sample-report-purchase-and-supplier-payments-_v3
Sheet: Payment forecast 

 |  |  | Purchase  Month |  |  |  |  |  |  |  | Credit Terms |  |  | Item | Payment Month
 | 2023-09-01 00:00:00 | 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 | 2024-05-01 00:00:00 | 2024-06-01 00:00:00 | 60 days | 30 days | Due Now |  | 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 | 2025-02-01 00:00:00 | 2025-03-01 00:00:00 | 2025-04-01 00:00:00 | 2025-05-01 00:00:00 | 2025-06-01 00:00:00 | 2025-07-01 00:00:00
 |  |  |  |  |  |  |  | 50000 |  |  | 0.25 | 0.6 | 0.15 | Stock & Purchase - PT A |  |  |  |  |  |  | ??? | ????
 |  |  |  |  |  |  |  |  |  |  | 0.2 | 0.5 | 0.3 | Stock & Purchase - PT B
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 11250 | 76875 | 181875 | 216250 | 147500
Spreadsheet: 7fc4328f-a42d-483e-b55b-748893221663
Sheet: FACTORS

 | WOODWORKING FACTORS AND CALCULATIONS
 |  | PERCENT OF WOODWASTE THAT IS: |  |  |  |  |  |  |  | ACTUAL YEARLY TONS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | POTENTIAL HOURLY POUNDS
 |  | GREEN WOOD |  |  |  | DRY WOOD |  |  |  | IN DUCT WASTE: |  |  | TPY |  | IN DUCT WASTE: |  |  | LB/HR
 |  | PM | PM10 | PM2.5 |  | PM | PM10 | PM2.5 |  |  | PM | PM10 | PM2.5 |  |  | PM | PM10 | PM2.5
 | PLANING | 0 | 0 |  |  | 2.6 | 0
 | SHAVING/CHIPPING | 0.56 | 0 |  |  | 0.56 | 0
 | ROUGH SAWING | 18 | 1.89 |  |  | 18 | 1.89
 | FINE SAWING | 31 | 0.37 |  |  | 31 | 0.37
 | MILLING | 10 | 0 |  |  | 10 | 0
 | MOLDING | 5.2 | 0 |  |  | 5.2 | 0
 | SANDING | 76 | 23.8 |  |  | 76 | 23.8
 |  | USING GREEN WOOD ?: |  |  |  | USING DRY WOOD?: |  |  |  | TOTAL UNC:
 |  |  |  |  |  |  |  |  |  | CONTROL: |  |  |  |  | UNCONTROLLED LB/HR EACH
 |  |  |  |  |  |  |  |  |  | TPY:
 | WOOD WASTE % ABOVE LEFT FOR PM AND PM10 FROM DAQ MEMOS DATED APRIL 26, 1995 AND APRIL 18, 1996.   ** FOR PM2.5:  PER AP-42 APPENDIX B-1 PG B.1-49 :   FOR THE OUTLET OF A CYCLONE INSTALLED ON A BELT SANDER HOOD EXHAUST THE CUMULATIVE WEIGHT % of PM2.5 WAS 29.5 % AND PM10 WAS 52.9%.  THIS IS A RATIO OF (29.5/52.9) OR 0.558 (55.8%) PM10 IS PM2.5 FOR OUTLET FROM A CYCLONE INSTALLED ON A BELT SANDER. CALCULATING INLET LOADING, ASSUME 100 MASS "UNITS" AND BACK CALCULATE USING CONTROL EFFICIENCY (ASSUME 10% PM2.5 AND 40 % PM10 CYCLONE CONTROL EFFICIENCY PER BELOW DISCUSSION):  PM2.5 -  29.5 OUTLET "UNITS" IS (29.5/(1-0.10)) 32.8 INLET "UNITS".  PM10 -  52.9 OUTLET "UNITS" IS (52.9/(1-0.40)) 88.2 INLET "UNITS".  THE BEFORE CONTROL RATIO IS THEN CALCULATED AS  32.8 / 88.2 = 0.37   (I.E.  PM2.5 IS 37 % OF PM10 FOR THE INLET).  AS SIDE NOTE, THE AP-42 CITATION ABOVE ALSO INDICATES AFTER A CYCLONE AND BAGFILTER IN SERIES, THE OUTLET RATIO IS (14.3/32.1) OR 44.5 % PM10 IS PM2.5. |  |  |  |  |  |  |  |  | % OUTSIDE
 |  |  |  |  |  |  |  |  |  | TPY:
 |  |  |  |  |  |  |  |  |  |  | **  The output sheet corrects itself if PM < PM10, to make PM = PM10 (this can happen if non-default efficiencies are used).  Same for PM10 and PM2.5
 | DEFAULT CONTROL EFFICIENCY DISCUSSION:
 | TRAILER:  CONSERVATIVELY NO CONTROL FOR PM100 AND LOWER IS REASONABLE EXPECTED FOR A TRAILER
 | BAGFILTER:  FROM [NAME], PM10 EFFICIENCY IS ~ 99.5 AND PM2.5 IS 99.   99.9 IS REASONABLY CONSERVATIVE FOR PM100 - DAQ CONTROL SPREADSHEETS TYPICALLY INDICATE 99.99 AND ABOVE.
 | CYCLONE: [NAME]3 INDICATES THE FOLLOWING EFFICIENCIES: 10% FOR PM0-PM2.5, 35% FOR PM2.5-PM6, AND 50% FOR PM6-PM10.  10% WILL BE USED FOR PM2.5.  40% WAS PICKED AS A CONSERVATIVE NUMBER FOR PM10  (SINCE THE DAQ WOOD DISTIBUTION DATA ALREADY ASSUMES PM10=PM44.)  PM100 IS 85% (NO DATA TO WORK WITH - DAQ CONTROL DEVICE SPREADSHEET SEEMS TO INDICATE THIS IS CONSERVATIVE - 85% RETAINED FROM LAST SPREADSHEET REVISION)
Spreadsheet: 131846d1323356576-nested-if-or-and-matched-indexed-statements-janine-2
Sheet: Names List

All the vital info and tick list |  |  |  |  |  |  |  |  |  |  |  |  |  |  | #N/A
 | Booking # | Tour Code | Names | Room type | Room # | Age | DOB | Nationality | Passport # | Phone # | Dietary | Medical | Next of Kin | Meeting where | Notes | [NAME]
1 |  | [NAME] | Driver | single |  | N/A | N/A | N/A
2 |  | [NAME] | Tour leader | single |  | N/A | N/A | N/A
3 |  | EA | mr s | twin | 1 | 111
4 |  | EA | Mrs s | twin | 1 | 111
5 |  | ew | miss t | triple | 1 | 111
6 |  | ew | miss r | triple | 1 | 111
7 |  | ew | miss e | triple | 1 | 111
8 |  | [NAME] | mr o | twin | 2 | 111
9 |  | [NAME] | mr p | twin | 2 | 111
10 |  | ew | Mrs j | twin | 3 | 111
11 |  | ew | mr j | twin | 3 | 111
12 |  | [NAME] | h | ms |  | 111
13 |  | ew | k | ms |  | 111
14 |  | [NAME] | b | fs |  | 111
15 |  | ea | v | ms |  | 111
16 |  |  |  |  |  | 111
17 |  |  |  |  |  | 111
18 |  |  |  |  |  | 111
19 |  |  |  |  |  | 111
20 |  |  |  |  |  | 111
21 |  |  |  |  |  | 111
22 |  |  |  |  |  | 111
23 |  |  |  |  |  | 111
24 |  |  |  |  |  | 111
25 |  |  |  |  |  | 111
26 |  |  |  |  |  | 111
27 |  |  |  |  |  | 111
28 |  |  |  |  |  | 111
29 |  |  |  |  |  | 111
30 |  |  |  |  |  | 111
31 |  |  |  |  |  | 111
32 |  |  |  |  |  | 111
33 |  |  |  |  |  | 111
34 |  |  |  |  |  | 111
35 |  |  |  |  |  | 111
36 |  |  |  |  |  | 111
37 |  |  |  |  |  | 111
38 |  |  |  |  |  | 111
39 |  |  |  |  |  | 111
40 |  |  |  |  |  | 111
41 |  |  |  |  |  | 111
42 |  |  |  |  |  | 111
43 |  |  |  |  |  | 111
44 |  |  |  |  |  | 111
45 |  |  |  |  |  | 111
46 |  |  |  |  |  | 111
47 |  |  |  |  |  | 111
48 |  |  |  |  |  | 111
49 |  |  |  |  |  | 111
50 |  |  |  |  |  | 111
Spreadsheet: 771289d1646589413-help-filling-a-table-from-another-table-call-taker-mealbreak-sheet-centralised-blank-1-a
Sheet: reference

% variance | HCP max off | 999 [NAME] | Total [NAME] off |  | password | PW123
51 | 3 | 3 | 4
50 | 3 | 3 | 4
49 | 3 | 3 | 4
48 | 3 | 3 | 4
47 | 3 | 3 | 4
46 | 3 | 3 | 4
45 | 3 | 3 | 4
44 | 3 | 3 | 4
43 | 3 | 3 | 4
42 | 3 | 3 | 4
41 | 3 | 3 | 4
40 | 3 | 3 | 4
39 | 3 | 3 | 4
38 | 3 | 3 | 4
37 | 3 | 3 | 4
36 | 3 | 3 | 4
35 | 3 | 3 | 4
34 | 3 | 3 | 4
33 | 3 | 3 | 4
32 | 3 | 3 | 4
31 | 3 | 3 | 4
30 | 3 | 3 | 4
29 | 3 | 3 | 4
28 | 3 | 3 | 4
27 | 3 | 3 | 4
26 | 3 | 3 | 4
25 | 3 | 3 | 4
24 | 3 | 3 | 4
23 | 3 | 3 | 4
22 | 3 | 3 | 4
21 | 3 | 3 | 4
20 | 3 | 3 | 4
19 | 3 | 3 | 4
18 | 3 | 3 | 4
17 | 3 | 3 | 4
16 | 3 | 3 | 4
15 | 3 | 3 | 4
14 | 3 | 3 | 4
13 | 3 | 3 | 4
12 | 3 | 3 | 4
11 | 3 | 3 | 4
10 | 3 | 3 | 4
9 | 3 | 3 | 4
8 | 3 | 3 | 4
7 | 3 | 3 | 4
6 | 3 | 3 | 4
5 | 3 | 3 | 4
4 | 3 | 3 | 4
3 | 3 | 3 | 4
2 | 3 | 3 | 4
1 | 3 | 3 | 4
0 | 3 | 3 | 4
-1 | 3 | 3 | 4
-2 | 3 | 3 | 4
-3 | 3 | 3 | 4
-4 | 3 | 3 | 4
-5 | 3 | 3 | 4
-6 | 3 | 3 | 4
-7 | 3 | 3 | 4
-8 | 3 | 3 | 4
-9 | 3 | 3 | 4
-10 | 3 | 3 | 4
-11 | 2 | 2 | 3
-12 | 2 | 2 | 3
-13 | 2 | 2 | 3
-14 | 2 | 2 | 3
-15 | 2 | 2 | 3
-16 | 2 | 2 | 3
-17 | 2 | 2 | 3
-18 | 2 | 2 | 3
-19 | 2 | 2 | 3
-20 | 2 | 2 | 3
-21 | 2 | 2 | 2
-22 | 2 | 2 | 2
-23 | 2 | 2 | 2
-24 | 2 | 2 | 2
-25 | 2 | 2 | 2
-26 | 1 | 1 | 1
-27 | 1 | 1 | 1
-28 | 1 | 1 | 1
-29 | 1 | 1 | 1
-30 | 1 | 1 | 1
-31 | 0 | 0 | 0
-32 | 0 | 0 | 0
-33 | 0 | 0 | 0
-34 | 0 | 0 | 0
-35 | 0 | 0 | 0
-36 | 0 | 0 | 0
-37 | 0 | 0 | 0
-38 | 0 | 0 | 0
-39 | 0 | 0 | 0
-40 | 0 | 0 | 0
-41 | 0 | 0 | 0
-42 | 0 | 0 | 0
-43 | 0 | 0 | 0
-44 | 0 | 0 | 0
-45 | 0 | 0 | 0
-46 | 0 | 0 | 0
-47 | 0 | 0 | 0
-48 | 0 | 0 | 0
-49 | 0 | 0 | 0
-50 | 0 | 0 | 0
-51 | 0 | 0 | 0
-52 | 0 | 0 | 0
-53 | 0 | 0 | 0
-54 | 0 | 0 | 0
-55 | 0 | 0 | 0
-56 | 0 | 0 | 0
-57 | 0 | 0 | 0
-58 | 0 | 0 | 0
-59 | 0 | 0 | 0
-60 | 0 | 0 | 0
-61 | 0 | 0 | 0
-62 | 0 | 0 | 0
-63 | 0 | 0 | 0
-64 | 0 | 0 | 0
-65 | 0 | 0 | 0
-66 | 0 | 0 | 0
-67 | 0 | 0 | 0
-68 | 0 | 0 | 0
-69 | 0 | 0 | 0
-70 | 0 | 0 | 0
-71 | 0 | 0 | 0
-72 | 0 | 0 | 0
-73 | 0 | 0 | 0
-74 | 0 | 0 | 0
-75 | 0 | 0 | 0
-76 | 0 | 0 | 0
-77 | 0 | 0 | 0
-78 | 0 | 0 | 0
-79 | 0 | 0 | 0
-80 | 0 | 0 | 0
-81 | 0 | 0 | 0
-82 | 0 | 0 | 0
-83 | 0 | 0 | 0
-84 | 0 | 0 | 0
-85 | 0 | 0 | 0
-86 | 0 | 0 | 0
-87 | 0 | 0 | 0
-88 | 0 | 0 | 0
-89 | 0 | 0 | 0
-90 | 0 | 0 | 0
-91 | 0 | 0 | 0
-92 | 0 | 0 | 0
-93 | 0 | 0 | 0
-94 | 0 | 0 | 0
-95 | 0 | 0 | 0
-96 | 0 | 0 | 0
-97 | 0 | 0 | 0
-98 | 0 | 0 | 0
-99 | 0 | 0 | 0
-100 | 0 | 0 | 0
Spreadsheet: 438579d1452029717-need-to-get-a-simple-forecast-budget-excel-sample-ch3-1-cash-budget-scenario-part-a
Sheet: Q. (3)

Camp and Fevurly Financial Planners
Cash budget
 | Sales Adjustment | 2011-11-01 00:00:00 |  |  |  |  |  |  |  |  | 2011-11-01 00:00:00
Sales | 1 | 48000 | 45000 |  |  |  |  |  |  |  |  |  | 25000 | 27000 | 30000 | 38000 | 40000 | 45000
Collections:
Cash | 0.6
First Month | 0.39
Bad Debt | 0.01
Total Collections
Collections
Less Disbursement
Wages | 7000
Commission | 0.25
Partner Salary | 0.2
Rent | 3500
Lease | 800
Utilities |  |  |  | 250 | 250 | 250 | 250 | 150 | 150
Total Disbursements
Beginning Cash Balance |  |  |  | 12000
Collections
Disbursements
Unadjusted Cash Balance
Current Borrowing
Ending Cash Balance
cuCumulative Borrowing |  |  | 0
Notes:
Minimum Cash Balance | 10000
Minimum Salary | 5000
Spreadsheet: 644835ae-d2dc-450c-b476-5fa51b440963
Sheet: Table S3

Table S3. Identification of coexpressed genes using GeneNetwork
LincRNA gene | coexpressed genes | coexpressed gene Ensemble ID | chr | start | stop | z-score | P-value
[NAME] ([NAME]) | TNFRSF10A | ENSG00000104689 | 8 | 23047965 | 23082639 | 13.1 | 3.29257661390176e-39
 | AL157902.3 | ENSG00000236866 | 1 | 118139454 | 118148392 | 4.78 | 1.75295194585841e-06
 | AC074389.9 | ENSG00000236081 | 7 | 1778266 | 1781927 | 5.05 | 4.41810064539087e-07
 | TNFRSF10D | ENSG00000173530 | 8 | 22993101 | 23021543 | 4.94 | 7.81225708636652e-07
 | CHMP7 | ENSG00000147457 | 8 | 23101150 | 23119512 | 5.32 | 1.03767252036848e-07
 | TLX1NB | ENSG00000236311 | 10 | 102849078 | 102901023 | 4.74 | 2.13718218909187e-06
 | [NAME] | ENSG00000198791 | 8 | 17086737 | 17104387 | 4.6 | 4.22490940500571e-06
 | RP11-115C21.2 | ENSG00000246089 | 8 | 6261072 | 6264663 | 4.57 | 4.87724214755885e-06
 | C11orf94 | ENSG00000234776 | 11 | 45928085 | 45928833 | 4.57 | 4.87724214755885e-06
 | PPEF2 | ENSG00000156194 | 4 | 76781020 | 76823724 | 3.93 | 8.49458615775225e-05
 | RP11-63B19.1 | ENSG00000236720 | 1 | 177669659 | 177679465 | 4.67 | 3.01199735519231e-06
 | AC073321.4 | ENSG00000225794 | 2 | 217469494 | 217475925 | 4.16 | 3.18247594381643e-05
 | ELP3 | ENSG00000134014 | 8 | 27947190 | 28048673 | 4.65 | 3.31935028874292e-06
 | ANKRD5 | ENSG00000132623 | 20 | 10015689 | 10037410 | 4.04 | 5.34512014389841e-05
 | CTC-378H22.1 | ENSG00000254887 | 19 | 42636707 | 42641251 | 4.04 | 5.34512014389841e-05
 | AC109333.10 | ENSG00000227495 | 17 | 4922509 | 4923388 | 3.96 | 7.4949763382147e-05
 | PPP2R2A | ENSG00000221914 | 8 | 26149007 | 26230196 | 3.95 | 7.8151193195575e-05
 | INTS10 | ENSG00000104613 | 8 | 19674651 | 19709594 | 3.94 | 8.14816091171016e-05
 | CTD-2303B20.1 | ENSG00000259073 | 14 | 90042560 | 90043821 | -3.9 | 9.61926880352053e-05
 | AC002480.5 | ENSG00000225541 | 7 | 22611226 | 22701411 | 3.9 | 9.61926880352053e-05
 | CTC-378H22.2 | ENSG00000259436 | 19 | 42656721 | 42661675 | 4.36 | 1.30062444019856e-05
 | RP11-426A6.5 | ENSG00000226706 | 9 | 138395119 | 138398293 | 4.24 | 2.23519786642411e-05
 | AC007038.7 | ENSG00000229127 | 2 | 210895457 | 210929080 | -4.23 | 2.33691311894147e-05
 | VPS37A | ENSG00000155975 | 8 | 17104080 | 17159936 | 4.11 | 3.95659117364481e-05
 | ITIH5L | ENSG00000102313 | 23 | 54775332 | 54824673 | -4.03 | 5.57768528811278e-05
Spreadsheet: darrell_schoolcraft__7314__imball0202
Sheet: KN_Westar

 |  |  |  |  |  |  |  |  |  |  |  |  |  | Contract 8289 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Contract  21579
[NAME] | 12353 | WestarCarson | 500168 | Westar Ward |  | 10187-01 | 9089-01 | 10522
 | Measured | Scheduled | Measured | Scheduled |  |  | Del | recpt
1 |  |  |  |  |  | -20950 | -6
2 |  |  |  |  |  | -21285 | -6
3 |  |  |  |  |  | -12127 | -106
4 |  |  |  |  |  | -3520 | -19935 | 1
5 |  |  |  |  |  | 0 | -14532
6 |  |  |  |  |  | 0 | -10057 | 4
7 |  |  |  |  |  | -11018 | 0
8 |  |  |  |  |  | -27027 | -1 | 3239
9 |  |  |  |  |  | 0 | 0
10 |  |  |  |  |  | 0 | -28
11 |  |  |  |  |  | 0 | -25098 | 1
12 |  |  |  |  |  | 0 | -8
13 |  |  |  |  |  | -2931 | -11558
14 |  |  |  |  |  | -2931
15 |  |  |  |  |  | -14542 | -19966
16 |  |  |  |  |  | 0 | -15603
17 |  |  |  |  |  | -35137
18 |  |  |  |  |  | -19715
19 |  |  |  |  |  | -161
20 |  |  |  |  |  | -7781
21 |  |  |  |  |  | -14775
22 |  |  |  |  |  | -14217
23 |  |  |  |  |  | -28277
24 |  |  |  |  |  | -28905
25 |  |  |  |  |  | -19350
26 |  |  |  |  |  | -14323
27 |  |  |  |  |  | -18186
28 |  |  |  |  |  | -13798
29 |  |  |  |  |  | 23
30 |  |  |  |  |  | -14811
31 |  |  |  |  |  | -16076
index
2002-01-31 00:00:00 |  |  |  |  | 295806.83
2002-01-31 00:00:00
CBS Volume
 |  |  | -53608
Spreadsheet: 41300d1239794881-identify-list-and-sum-2-columns-test-time-sheet
Sheet: OCT 13-18 08

 | NAME: | JON
 |  |  |  |  | TOTAL HRS
DATE | TIME IN | TIME OUT | TOTAL HRS | JOB NO. | FOR DAY | JOB DESC
2008-10-13 00:00:00 | 06:00:00 | 09:30:00 | 3.5 | 28090 |  | CNC-P
 | 09:30:00 | 03:00:00 | 5 | SHOP | 8.5
2008-10-14 00:00:00 | 06:30:00 | 12:00:00 | 5.5 | SHOP
 | 12:30:00 | 03:30:00 | 3 | 28097 | 8.5
2008-10-15 00:00:00 | 05:30:00 | 08:30:00 | 3 | 28097 |  | CNC-P
 | 08:30:00 | 12:00:00 | 3.5 | SHOP
 | 12:30:00 | 02:30:00 | 2 | 28094 |  | CNC-P
 | 02:30:00 | 03:00:00 | 0.5 | SHOP | 9
2008-10-16 00:00:00 | 06:00:00 | 07:00:00 | 1 | SHOP
 | 07:00:00 | 12:00:00 | 5 | 28094 |  | CNC-P
 | 12:30:00 | 03:30:00 | 3 | SHOP | 9
2008-10-17 00:00:00 | 06:00:00 | 09:00:00 | 3 | 28094 |  | CNC-P
 | 09:00:00 | 12:00:00 | 3 | SHOP
 | 12:30:00 | 03:00:00 | 2.5 | 28093 | 8.5 | CNC-P
 |  | SHOP | 21.5
 |  | 28090 | 3.5
 |  | 28093 | 2.5
 |  | 28094 | 10
 |  | 28097 | 6
 |  |  | 43.5 | TOTAL | 43.5
Spreadsheet: 771958d1646931890-need-help-on-fill-up-status-sheet-by-formula-report-1
Sheet: Status

Employee Name | Access - Admin | Alerts - Admin | Assets - Admin | Assets - Partner | CENTRi | Deals - Admin | Deals - Partner | Flexiflow | FluidCMS | Leads - Admin | Leads - Partner | Learning - Admin | Learning - Partner | [NAME] | Library - Partner | Onboarding - Admin | Onboarding - Partner | Partners - Admin | Reports - Admin | Users - Admin | Attempt Rate-25-Feb-22 |  | Attempt Rate-1-Mar-22
Spreadsheet: 854014d1703967770-pls-provide-me-a-if-function-from-the-group-of-4-numbers-on-last-two-values-2007-better-understanding
Sheet: Sheet1

 |  | UNIT |  |  |  | UNIT |  |  |  | UNIT |  |  |  | UNIT
 |  | -6955 |  |  |  | -6955 |  |  |  | 2410 |  |  |  | -6955
 |  | -4857.5 |  |  |  | -4857.5 |  |  |  | 436.2500000000001 |  |  |  | -4857.5
 |  | -1427.5 |  |  |  | -1427.5 |  |  |  | -6955 |  |  |  | -1427.5
 |  | 2410 |  |  |  | 2410 |  |  |  | -3650 |  |  |  | 2410
 |  | -1520 |  |  |  | 436.25 |  |  |  | -2415 |  |  |  | -3510
 |  | PROBLEM SOLVED |  |  |  | PROBLEM SOLVED |  |  |  | PROBLEM SOLVED |  |  |  | PROBLEM SOLVED
 | (HERE I WANT - POSITIVE INDICATION) BECAUSE ABOVE GROUP OF NUMBERS -1520 NOT COVER 2410 VALUE INDICATE POSITIVE |  |  |  | (HERE I WANT - POSITIVE INDICATION) BECAUSE ABOVE GROUP OF NUMBERS 436.25 VALUE INDICATE POSITIVE ALSO 2410 INDICATE POSITIVE |  |  |  | Negative if formula works well |  |  |  | Negative if formula works well
 |  |  |  |  | I WANT INTO ONE FORMULA
Spreadsheet: 87152d1287020485-detect-if-entries-have-duplicate-criteria-detect-duplicate-criteria
Sheet: Sheet1

Item | AppGroup | OK to treat like app? |  |  | Item | AppGroup | App | [NAME] | Supported By | HIDE COLUMNS
1 | BIEM | Y | should be Y |  | 1 | BIEM | Excel | [NAME] | [NAME] | BIEMMS SupportJoe | 2
2 | Maximo | N | should be N |  | 2 | BIEM | Word | [NAME] | [NAME] | BIEMMS SupportJoe | 2
 |  |  |  |  | 3 | Maximo | [NAME] | [NAME] | [NAME] | MaximoMS SupportJoe | 1
 |  |  |  |  | 4 | Maximo | [NAME] | [NAME] | [NAME] | MaximoTIM SupportFrank | 1
 |  |  |  |  | 5 | Maximo | Alon | IBM Support | [NAME] | MaximoIBM SupportJane | 1
Spreadsheet: 106545d1303822105-setting-up-formulas-to-pull-data-from-another-sheet-accident-incident-report-log
Sheet: Stats

 | 2011 | Q1 | Q2 | Q3
Accident | 5 | 0 | 0 | 0
Incident | 4 | 0 | 0 | 0
Totals | 9 | 0 | 0 | 0
Accidents
Cut
Burn | 1
Slip/Trip | 2
Struck/Caught | 1
Overexertion
Fire/Explosion
Assault
Motor Vehicle Incident
Harmful Substance/Environment
Incidents
Cut | 0
Burn | 0
Slip/Trip | 0
Struck/Caught | 0
Overexertion | 0
Fire/Explosion | 0
Assault | 0
Motor Vehicle Incident | 0
Harmful Substance/Environment | 0
Spreadsheet: 822090d1679082421-distribute-quantity-according-to-order-price-example
Sheet: Folha1

Product | Available Stock | Total Quantity | Order_1 |  | [NAME] |  | Order_3
 |  |  | Quantity | Price | Quantity | Price | Quantity | Price
A | 920 |  | 100 | 3 | 432 | 1 | 545 | 4
B | 150 |  | 43 | 12 | 65 | 43 | 75 | 15
C | 100 |  | 43 | 43 | 76 | 21 | 87 | 54
D | 200 |  | 243 | 87 | 111 | 43 | 298 | 21
What I Need:
Product | Available Stock | Total Quantity | Order_1 |  | [NAME] |  | Order_3
 |  |  | Quantity | Price | Quantity | Price | Quantity | Price
A | 920 | 1077 | 100 |  |  |  | 545
B | 150 | 183 |  |  | 65 |  | 75
C | 100 | 206 |  |  |  |  | 87
D | 432 | 114 | 200
Spreadsheet: 165566d1341270809-excel-2007-count-cell-with-yes-and-deduct-from-100-data-quality-example
Sheet: Sheet1

 | Reference no. | Area 1 | Area 2 | Area 3 | Area 4 | Area 5 |  |  |  | Yes
 | 11111 |  |  |  |  |  |  |  |  | No
 | 22222
 | 33333
 | 44444 |  |  |  |  |  | Total %
 | 55555
 | Reference no. | Area 1 | Area 2 | Area 3 | Area 4 | Area 5
 | 666666
 | 777777
 | 88888
 | 99999 |  |  |  |  |  | Total %
 | 98746
 | Reference no. | Area 1 | Area 2 | Area 3 | Area 4 | Area 5
 | 12121
 | 23232
 | 34343
 | 434343 |  |  |  |  |  | Total %
 | 545454
Spreadsheet: 0a379928-a7f3-47bb-908f-f8e3939b92db
Sheet: Globosat (Brazil)

Globosat (Brazil)
Date | Start (GMT) | End (GMT) | Notes
2010-11-21 00:00:00 | 14:00:00 | 16:00:00 | Round [NAME] (Singles)
2010-11-21 00:00:00 | 20:00:00 | 22:00:00 | Round [NAME] (Singles)
2010-11-22 00:00:00 | 14:00:00 | 16:00:00 | Round [NAME] (Singles)
2010-11-22 00:00:00 | 20:00:00 | 22:00:00 | Round [NAME] (Singles)
2010-11-23 00:00:00 | 14:00:00 | 16:00:00 | Round [NAME] (Singles)
2010-11-23 00:00:00 | 20:00:00 | 22:00:00 | Round [NAME] (Singles)
2010-11-24 00:00:00 | 14:00:00 | 16:00:00 | Round [NAME] (Singles)
2010-11-24 00:00:00 | 20:00:00 | 22:00:00 | Round [NAME] (Singles)
2010-11-25 00:00:00 | 14:00:00 | 16:00:00 | Round [NAME] (Singles)
2010-11-25 00:00:00 | 20:00:00 | 22:00:00 | Round [NAME] (Singles)
2010-11-26 00:00:00 | 14:00:00 | 16:00:00 | Round [NAME] (Singles)
2010-11-26 00:00:00 | 20:00:00 | 22:00:00 | Round [NAME] (Singles)
2010-11-27 00:00:00 | 14:00:00 | 16:30:00 | Semi-Final 1 - Live (Singles)
2010-11-27 00:00:00 | 20:00:00 | 22:30:00 | Semi-Final 2 - Live (Singles)
2010-11-28 00:00:00 | 17:30:00 | 20:30:00 | Singles Final - Live
Spreadsheet: dan_hyvl__4695__F Adkins Final Payment
Sheet: Sheet1

[NAME]
Calculation of January 2001 Payment
 | Volume | Price | Totals
January contractual commitment | 13000 | 3.075
January excess volume at Index |  | 10.53
Less CNR Gathering: | 18258 | 0.32
Less: [NAME] Fees | 10 | 25
Less: MarkWest Processing |  | 0.03
Balance Due before February and March
contractual commitments
Less:  February contractual commitment | 13000
($3.075 - $6.44 = $3.365)
Less:  March contractual commitment: | 13000
($3.075 - $5.29 = $2.215)
Amount Due
Note:  February and March contractual commitment deductions are calculated by
subtracting the first of the month index for spot gas delivered to Columbia Gas Transmission
as posted in Inside FERC's Gas Market Report from the contract price of $3.075 multiplied
by the contract volume of 13,000 Dth.
Spreadsheet: 798585d1664559120-sumproduct-countif-hitting-divide-by-zero-error-due-to-empty-cells-sumproduct-divzero-example-1-
Sheet: Sheet1

STATUS | ID |  | TOTAL COMPLETE
DONE | 1 | doesn't count because below is in progress and N/A for id=1
DONE | 2 | ok
DONE | 3 | ok
DONE | 2 | duplicated - doesn.t count this, but the other yes
DONE | 4 | ok
DONE | 6 | ok
IN PROGRESS | 1 | <- 1 doesn.t count
DONE | 7 | ok
N/A | 1 | <- 1 doesn.t count
DONE | 5 | ok
Spreadsheet: kenneth_lay__19513__Architectural Electronics-Huntingdon
Sheet: Sheet1

 | PREWIRE AND TRIM | TELEPHONES | LUTRON LIGHTING | AUDIO VISUAL | TOTALS
ORIGINAL CONTRACT | 72056.55 | 18317.96 | 121561.97 | 206869.77
 | -27936.2 | -16800 | -12200 | -4100
 | -16000 |  | -24300 | -16500
 | -7936.2 |  | -7560 | -2810
 | -4000 |  | -47140 | -7481.5
 | -8000 |  | -18200 | -124208.5
 |  |  |  | -31000
owing from original contracts
Change order #1 |  |  | 18708.04 | 50443.85
 |  |  | -1860 | -37000
 |  |  | -3740 | -13443.85
 |  |  | -8400
 |  |  | -2800
Change order #2 |  |  | 5936.59 | 36807.65
 |  |  | -5936.59
Change order#3 |  |  | 14389.22 | 5067.33
 |  |  |  | -5067.33
 |  |  |  | BALANCE OUTSTANDING
 |  |  |  | ENTIRE PROJECT | 550158.93