tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: dab7ea0b-926d-4531-b0f9-d0ab6f26a753
Sheet: Sheet1

Test Referenced | Entry Type | Mayo ID | Description | Reporting Description | Method | Collection Container | Temperature | Stability | [NAME] | Unit of Measure | [NAME] | Minimum Volume | Reject Due To | Reference Values | Days/Times Performed | Analytic Time | Maximum Lab Time | CPT Units | CPT Code | LOINC® Code | LOINC® Attributes | Always Performed | Orderable Separately | Performing Location
HCYSP | Test | HCYSP | Homocysteine, Total, Plasma | Homocysteine, Total, P | Liquid Chromatography-Tandem Mass Spectrometry (LC-MS/MS) Stable Isotope Dilution Analysis | EDTA (lavender-top) tube: EDTA OR |  |  | 0.4 | mL | Container/Tube: Preferred: Lavender top (EDTA) Acceptable: Plasma Preparation Tube (PPT), citrate, sodium fluoride, heparin [NAME]: 0.4 mL Collection Instructions:  1. Fasting (12 hours preferred but not required) 2. Immediately place specimen on wet ice.  3. Spin down and separate plasma from cells within 4 hours of draw. A refrigerated centrifuge is not required if 4-hour time restraint is met. 4. Alternatively, if blood is not immediately placed on ice, plasma must be removed from cells within 1 hour of draw. A refrigerated centrifuge is not required if 1-hour time restraint is met. | 0.15 mL | Hemolysis	Mild OK; Gross OK Thawing	Warm Reject; Cold OK Lipemia	Mild OK; [NAME] OK Icterus	Mild OK; [NAME] OK Other	NA | Adults: < or =13 mcmol/L Reference values apply to fasting specimens only. | Monday through Friday; 2 p.m. | 2 days (not reported Sundays) | 5 days | 1 | 83090 |  |  |  |  | Rochester
HCYSP | [NAME] | PLEDTA | [NAME] |  |  |  | Refrigerated
HCYSP | Result | 80379 | Homocysteine, Total, P | Homocysteine, Total, P | Numeric |  |  |  |  | mcmol/L |  |  |  |  |  |  |  |  |  | 13965-9 | Homocysteine:SCnc:Pt:Ser/Plas:Qn:
Spreadsheet: 879874d1727451196-filtering-data-using-mulitple-criteria-with-and-and-or-functions-test-dynamic-filtering
Sheet: Data

Tax ID | Address | Sqft | $/Sqft | Acres | Sale Price | Instrument Date | File Date | Grantor | Grantee | Building Type | City | Area | Zoning | A |  | Total Listings
23185 | 1658 Highway 45 | 45526 |  | 3.6 | 4800000 | 2020-01-08 00:00:00 | 2020-01-09 00:00:00 | N/A | N/A | Hospitality | Rapid City | NE Rapid | General Commercial District | Hotel Limited Service
46985 | 6584 HIGHWAY 87 | 4586 |  | 2.02 | 564000 | 2020-01-09 00:00:00 | 2020-01-10 00:00:00 | N/A | N/A | Hospitality | Custer | Southern Hills | Highway Service | Motel
12584 | 13652 [NAME] | 84965 |  | 2.59 | 984000 | 2020-01-10 00:00:00 | 2020-01-11 00:00:00 | N/A | N/A | Industrial | Rapid City | Black Gap | Light Industrial District
85425 | 65314 Elm Ave | 132 |  | 1.23 | 456100 | 2020-01-11 00:00:00 | 2020-01-12 00:00:00 | N/A | N/A | Land | [NAME] | [NAME] | No Code
54593 | 6458 Elm Ave | 8964 |  | 0.77 | 150000 | 2020-01-12 00:00:00 | 2020-01-13 00:00:00 | N/A | N/A | Land | [NAME] | [NAME] | No Code
25545 | 5631 Highway 45 | 802 |  | 0.6 | 289000 | 2020-01-13 00:00:00 | 2020-01-14 00:00:00 | N/A | N/A | Multifamily | Rapid City | City Center | Commercial most restrictive C1
55864 | 65894 Oak St | 489 |  | 1.08 | 775000 | 2020-01-14 00:00:00 | 2020-01-15 00:00:00 | N/A | N/A | Multifamily | Rapid City | City Center | Medium density residential district
32156 | 563 Main St | 6458 |  |  | 355000 | 2020-01-15 00:00:00 | 2020-01-16 00:00:00 | N/A | N/A | Office | Rapid City | City Center | Central business district
69841 | 58 Main St | 898 |  |  | 730000 | 2020-01-16 00:00:00 | 2020-01-17 00:00:00 | N/A | N/A | Office | Rapid City | City Center | High density residential district
48941 | [NAME] | 651 |  | 10.3 | 1020000 | 2020-01-17 00:00:00 | 2020-01-18 00:00:00 | N/A | N/A | Other | [NAME] | [NAME] | No Code | Trailer Park
89613 | 8174 Elm | 325 |  | 0.14 | 200000 | 2020-01-18 00:00:00 | 2020-01-19 00:00:00 | N/A | N/A | Other | Rapid City | City Center | Central business district | Church
45621 | 4585 Elm | 468 |  | 18.07 | 864360 | 2020-01-19 00:00:00 | 2020-01-20 00:00:00 | N/A | N/A | Other | Rapid City | [NAME] | Open Space | Restaurant
84896 | 8475 Main | 8469 |  | 0.9 | 1550000 | 2020-01-20 00:00:00 | 2020-01-21 00:00:00 | N/A | N/A | Retail | Rapid City | City Center | General commercial district | Automotive Center
65484 | 213 Main | 654 |  | 1.79 | 1700000 | 2020-01-21 00:00:00 | 2020-01-22 00:00:00 | N/A | N/A | Retail | Rapid City | SE Rapid | No Code | Fast Food Restaurant
15684 | 658 Oak St | 7050 |  | 0.99 | 1420000 | 2020-01-22 00:00:00 | 2020-01-23 00:00:00 | N/A | N/A | Retail | [NAME] | [NAME] | Commercial most restrictive  C1 | Dollar General
Spreadsheet: 82069f65-eeb0-422c-bf3b-158425a5a08f
Sheet: Sheet1

Adresseliste fra www.proff.no | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7
[NAME]:Energiforsyning
FIRMANAVN | ADRESSE | POSTNR. | POSTSTED | TELEFON | TELEFAKS
Alta Kraftlag SA |  | 9550 | Øksfjord | 78 45 09 00 | 78 45 09 10
Alta Kraftlag SA |  | 9161 | Burfjord | 78 45 09 00 | 77 76 83 36
Andmyran Vindpark AS |  | 8484 | Risøyhamn
Arctic Wind AS |  | 9690 | Havøysund | 950 75 568
[NAME] |  | 8110 | Moldjord | 75 56 82 73
[NAME] |  | 8264 | Engan | 971 73 968
BE Kraftsalg AS | Jernbaneveien 85 | 8006 | Bodø | 75 54 51 50
[NAME] | [NAME] 8 | 8226 | Straumen
Barents Naturgass AS | Sjøgata 6 | 9600 | Hammerfest | 78 40 62 00
Beiarkraft AS | Os | 8110 | Moldjord | 901 66 254
Bindal [NAME] |  | 7980 | Terråk | 75 03 19 00 | 75 03 19 10
Bordvedåga Kraft AS | [NAME] 70 | 8626 | Mo i Rana
[NAME] | Lodve Langesgate 2 | 8514 | Narvik
Brattland Kraft AS | Skjerperveien 6 | 8630 | [NAME] | 75 16 01 49
Brattland Øyvind | Skjerperveien 6 | 8630 | [NAME] | 990 07 668
Burfjord montørstasjon |  | 9161 | Burfjord | 77 76 82 56
Censu Trading AS | Strandgata 22 | 8656 | Mosjøen | 75 17 55 11
Durmålskraft AS | Korgen | 8646 | Korgen
Engan Minikraft DA | Sjonhagenveien 115 | 8725 | Utskarpen | 957 26 622
[NAME] | Strandveien 31 | 8533 | [NAME] | 76 98 48 50 | 76 98 48 69
Fefo Energi AS | Torget | 9700 | [NAME] | 09975
Finnfjord Miljøenergi AS | c/o Finnfjord AS Finnfjord | 9305 | Finnsnes
Finnmark Kraft AS | Markedsgata 3 | 9510 | Alta | 474 87 723
Fjellkraft Forneselva AS | [NAME] | 8517 | Narvik
Fjellkraft Produksjon AS | [NAME] 161 | 8520 | Ankenes | 76 95 92 50
Trenger du oppdaterte adresselister til DM /TM? [NAME] (www.forvalt.no) tilbyr ett segmenterings- og uttekksverktøy hvor du [NAME] frem til din målgruppe og eksportere lister til Excel. Du kan gjøre oppslag så ofte du vil, med en begrensning på 3500 selskap per søk. Våre telefonnummere er hentet fra Telefonkatalogen og [NAME].  Med segmenteringsverktøy kan du: - Hente ut adresseliste før en DM utsendelse - Lage ringelister - Hente ut bransjestatistikker - Oppdatere din kundedatabase  Se http://forvalt.no/segmenteringsverktoy/
Spreadsheet: 0069afa6-d6c6-4efe-96b4-2fede2775599
Sheet: Sheet1

Support For Authorized Faculty Line Form: Data Section
 | Campus/School:
 | Department:
 | Program, Concentration or Specialty:
 | Request for  Academic Year: | 2012/13
I) | Student Credits Generated; credits generated by the courses the department ran for the last 3 years (Fall & Spring combined)
 | Year: | 2010/11 |  | 2009/10 |  | 2008/09
 | (Ia) Graduate:
 | (Ib) Undergraduate:
 | (Ic)  Total
II) | Majors in the Department: list the majors associated with the department and provide the head count for each, for the last
 | 3 years - Fall semester's count: Obtained through IR
 |  | Head count by year - past 3 years-Fall Count |  | Head count by year - past 3 years-Fall Count
 | List Majors by Description) | 2010/11 |  | 2009/10 |  | 2008/09
 | (II) - Total Majors by [NAME]
III) | Faculty Resources provided to the Department:
 |  | 2010/11 |  | 2009/10 |  | 2008/09
 | a) Number of Full-time Faculty in the department
 | b) # of Workload Credits Available by FT Faculty.
 | c) Release Time Credits (chair, research, and 022)
 | Available Credits by FT Faculty
 | c) Total Workload Credits Processed for All Courses
IV) | Coverage Ratios
 | e) FT Faculty Coverage Ratio  = (IIIb / IIId)
 | f) Adjunct Coverage Ratio = (IIIc / IIId)
V) | Student/Faculty Ratios:
 | Student Credit Ratio:  ( Ic / IIIc )
 | Major/FT Faculty Ratio ( II / IIIa )
Spreadsheet: 293695d1391066156-dependant-drop-down-lists-po-template
Sheet: Pack Size

 | Heatsafe7SIZE | Heatsafe219SIZE | Steelguard74RWSIZE | Steelguard74BSIZE | Steelguard813SIZE | Steelguard873BYSIZE | Steelguard873OWSIZE | Zincguard100SIZE | Zincguard120SIZE | Steelsheen24SIZE | Steelsheen130SIZE
Heatsafe7 | 50 | 50 | 50 | 50 | 20 | 20 | 20 | 20 | 20 | 20 | 20
Heatsafe219 | 20 | 20 | 20 | 20 |  |  |  |  |  | 5 | 5
Steelguard74RW
[NAME]
Steelguard813
Steelguard873BY
Steelguard873OW
Zincguard100
Zincguard120
Heatsafe431
Heatsafe643
Spreadsheet: 881929d1730184032-find-cell-value-with-multiple-criteria-findname
Sheet: Sheet1

 | 2025-01-01 00:00:00 |  |  |  |  | Searching for
[NAME] | Truck | Scooter | Car | Bike |  | Date | 2025-01-02 00:00:00
[NAME] | Car | Bike | Truck | Scooter |  | Vehicle | Car
[NAME] | Bike | Car | Scooter | Truck
[NAME] | Scooter | Truck | Bike | Car |  | Result
Spreadsheet: 82481d1282564401-combine-2-sources-of-data-splits_ex
Sheet: Split Table

Distributor | Split_Mkt Region | [NAME]
Distributor A | France | 1.13
Distributor A | Germany | 2.45
Distributor A | Hong Kong | 8.83
Distributor A | Italy | 0.07
Distributor A | Japan | 0
Distributor A | Spain | 6.66
Distributor A | Switzerland | 77.6
Distributor B | France | 4.06
Distributor B | Germany | 3.84
Distributor B | Hong Kong | 70.23
Distributor B | Italy | 2.12
Distributor B | Japan | 0.05
Distributor B | Spain | 0.07
Distributor B | Switzerland | 3.12
Distributor C | France | 2.61
Distributor C | Germany | 5.39
Distributor C | Hong Kong | 0
Distributor C | Italy | 13.54
Distributor C | Japan | 25.84
Distributor C | Spain | 0.07
Distributor C | Switzerland | 3.34
Distributor D | France | 0
Distributor D | Germany | 0
Distributor D | Hong Kong | 0
Distributor D | Italy | 0
Distributor D | Japan | 0
Distributor D | Spain | 1.54
Distributor D | Switzerland | 0.68
Spreadsheet: 860281d1708439465-time-interval-extraction-time-1-ans
Sheet: Sheet1

12:08:22
12:08:50
12:08:51
12:09:11
12:09:13
12:09:35
12:09:37
12:10:38
12:11:06
12:11:27
12:11:30
12:11:51
12:11:57
12:12:19
12:12:29
12:14:02
12:14:06
12:17:52
12:17:56
12:18:41
12:18:45
12:19:12
12:19:14
12:20:14
12:20:17
12:20:36
12:20:38
12:20:56
12:21:02
12:21:03
12:21:26
12:21:28
12:21:46
12:21:48
12:22:08
12:22:10
12:22:26
12:22:28
12:23:03
12:23:07
12:23:23
12:23:27
12:38:12
12:38:14
12:38:43
12:38:45
12:39:05
12:39:07
12:39:25
12:39:27
12:39:50
12:39:51
12:40:12
12:40:14
12:40:43
12:40:45
12:41:37
12:41:39
12:42:00
12:42:02
12:42:19
12:42:21
12:42:32
12:42:34
12:42:49
12:42:51
12:43:05
12:43:07
12:43:55
12:43:59
12:45:23
12:45:26
12:45:48
12:45:54
12:46:24
12:46:26
12:46:41
12:46:43
12:47:05
12:47:07
12:47:47
12:47:49
12:47:56
12:48:28
12:48:36
12:48:50
12:48:54
12:49:23
12:49:25
12:49:47
12:49:49
12:50:31
12:50:38
12:54:46
12:54:48
12:55:05
12:55:07
12:55:22
12:55:24
12:55:40
12:55:43
12:56:08
12:56:12
13:06:38
13:06:44
13:09:55
13:10:03
13:10:12
13:10:17
13:10:32
13:10:35
13:10:48
13:10:51
Spreadsheet: 765614d1643418543-job-and-checkers-count-job-and-check
Sheet: Sheet1

Jobs | Job 1 | Job 2 | Job 3 | Job 4 |  |  |  |  |  |  |  | Desired Results
Does the Job | [NAME] | [NAME] | [NAME] | [NAME] |  | Does the Job |  |  | Check the Job |  |  |  | Does the Job |  | Check the Job
 | Information about the job | Information about the job | Information about the job | Information about the job |  | [NAME] |  |  | [NAME] |  |  |  | [NAME] | 5 | [NAME] | 5
Checks the Job | [NAME] | [NAME] | [NAME] | [NAME] |  | [NAME] |  |  | [NAME] |  |  |  | [NAME] | 2 | [NAME] | 3
Does the Job | [NAME] | [NAME] | [NAME] | [NAME] |  | [NAME] |  |  | [NAME] |  |  |  | [NAME] | 1 | [NAME] | 3
 | Information about the job | Information about the job | Information about the job | Information about the job |  | [NAME] |  |  | [NAME] |  |  |  | [NAME] | 2 | [NAME] | 0
Checks the Job | [NAME] | [NAME] | [NAME] | [NAME] |  | [NAME] |  |  | [NAME] |  |  |  | [NAME] | 2 | [NAME] | 1
Does the Job | [NAME] | [NAME] | [NAME] | [NAME]
 | Information about the job | Information about the job | Information about the job | Information about the job
Checks the Job | [NAME] | [NAME] | [NAME] | [NAME]
Spreadsheet: darrell_schoolcraft__7414__imball0201
Sheet: NNG

NNG
 | Measured | Scheduled | Imbalance
1635 | -289215
3531 | -955181 | -337957
60667 | -208894 | -1132059
60749 | 91003 | -216671
61206
61334 | -327596
62960
INDEX
2001-12-31 00:00:00 |  |  | 45202.5
2002-01-29 00:00:00
CBS Volume
2001-12-31 00:00:00 |  |  | 20090
Spreadsheet: 105979d1303231665-copy-info-from-one-sheet-to-another-dsschaser-copy-question
Sheet: Report

Customer # | Customer Name | Pre year Sales | [NAME] | % Diff | Sales to Date | Year End Sales Est. | % Diff |  | Quarters | 4
 |  |  |  |  |  |  |  |  | Quarter | 1
12345 |  |  |  |  |  |  |  |  | Multiplier
17842
17495
18859
Spreadsheet: sally_beck__33995__Log as of 4_20_01
Sheet: Sum Jan 17 to 23

 | Week summary (Jan 17 to 23)
Category | Description | Total |  | Breakdown of Cat 1
1 | Human Errors |  |  | Process in place but not followed
2 | IT Hardware problems |  |  | Officialized on time but needed recalc
3 | IT Software Problems |  |  | Book not officialized
4 | Miscellaneous |  |  | No process in place
5 | Uncontrollable | 0 |  | Other
 | Total |  |  | Total
 |  |  |  | Breakdown of Cat 2
 |  |  |  | Computer breakdown | 0
 |  |  |  | Other
 |  |  |  | Total
 |  |  |  | Breakdown of Cat 3
 |  |  |  | Correct inputs, incorrect outputs
 |  |  |  | Slow feeds
 |  |  |  | Feed problem
 |  |  |  | Books shown as officialized in ERMS, but not RiskTrac
 |  |  |  | Application down alternate system used
 |  |  |  | Other
 |  |  |  | Total
 |  |  |  | Breakdown of Cat 4
 |  |  |  | Credit interface | 0
 |  |  |  | Other | 0
 |  |  |  | Total
Spreadsheet: 146039d1331868623-index-match-query-to-include-blank-entries-from-source-so-week-number-obvious-at-a-glance-roomrent2012
Sheet: TOTAL's FOR JAN-DEC

MTH | PAID | NOT PAID | REASON1 | REASON2 | REASON3 | REASON4 | REASON5 | REASON6 | REASON1  VLOOKUP
JAN | 60 | 40 | NO CASH THIS WEEK | UNKNOWN |  |  |  |  | UNKNOWN
FEB | 20 | 20 | UNKNOWN |  |  |  |  |  | UNKNOWN
MAR | 0 | 40 | UNKNOWN | UNKNOWN |  |  |  |  | UNKNOWN
APR | 0 | 0 |  |  |  |  |  |  | #N/A
MAY | 0 | 0 |  |  |  |  |  |  | #N/A
JUN | 0 | 0 |  |  |  |  |  |  | #N/A
JUL | 0 | 0 |  |  |  |  |  |  | #N/A
AUG | 0 | 0 |  |  |  |  |  |  | #N/A
SEP | 0 | 0 |  |  |  |  |  |  | #N/A
OCT | 0 | 20 | UNKNOWN |  |  |  |  |  | UNKNOWN
NOV | 0 | 0 |  |  |  |  |  |  | #N/A
DEC | 0 | 0 |  |  |  |  |  |  | #N/A
YEAR TOTAL | 80 | 120
Criteria 1 | N
[NAME] | Y
JAN | 2
FEB | 1
MAR | 2
APR | 0
MAY | 0
JUN | 0
JUL | 0
AUG | 0
SEP | 0
OCT | 1
NOV | 0
DEC | 0
Spreadsheet: 741016d1626773408-need-a-conditional-formatting-formula-for-cells-with-dates-sample-sheet-tms
Sheet: Sheet1

2021-07-01 00:00:00 |  |  |  | =AND($A$1<>"", $A$2<>"", $A$2>=$A$1+2)
2021-07-03 00:00:00
 |  |  |  | =AND($A$1<>"", $A$2<>"", $A$2>=$A$1+2)
Spreadsheet: 0897e560-d509-48f1-aa44-86a26ae23934
Sheet: Sheet1

Table 1--Soybeans:  Annual 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 | Unnamed: 12 | Unnamed: 13
 | Area |  | Yield | Supply |  |  |  |  | Use
Year beginning | Planted | Harvested |  | Beginning |  |  |  |  | Crush | Seed, feed |  |  | Ending
September 1 |  |  |  | stocks | Production | Imports | Total |  |  | & residual | Exports | Total | stocks
 | Million acres |  | Bu./acre |  |  |  |  |  | --------------------------------------------------Million bushels--------------------------------------------------
2011/12 | 75.046 | 73.776 | 41.93130557362828 | 215.013 | 3093.524 | 16.1356425643245 | 3324.672642564324 |  | 1703 | 87.28499983897359 | 1365.017642725351 | 3155.302642564324 | 169.37
2012/131 | 77.198 | 76.164 | 39.82959140801429 | 169.37 | 3033.581 | 36.1366418632023 | 3239.087641863202 |  | 1689 | 89.96486634648022 | 1319.565775516722 | 3098.530641863203 | 140.557
2013/142 | 76.533 | 75.869 | 43.34883812888005 | 140.557 | 3288.833 | 30 | 3459.39 |  | 1700 | 99.38999999999987 | 1510 | 3309.39 | 150
Soybeans:  Quarterly U.S. supply and disappearance
 |  |  |  | Supply |  |  |  |  | Use
 |  |  |  | Beginning |  |  |  |  | Crush, seed |  |  |  | Ending
 |  |  |  | stocks | Production | Imports | Total |  | & residual |  | Exports | Total | stocks
 |  |  |  |  |  |  |  |  | --------------------------------------------------Million bushels--------------------------------------------------
2012/13
September-November |  |  |  | 169.37 | 3033.581 | 4.2863493307698 | 3207.23734933077 |  | 622.6353144323552 |  | 618.4410348984147 | 1241.07634933077 | 1966.161
December-February |  |  |  | 1966.161 | --- | 4.7181036423045 | 1970.879103642304 |  | 447.2727627133432 |  | 525.5863409289612 | 972.8591036423045 | 998.02
March-May |  |  |  | 998.02 | --- | 7.8351491690241 | 1005.855149169024 |  | 446.1362887515575 |  | 125.0548604174667 | 571.1911491690241 | 434.664
June-August |  |  |  | 434.664 | --- | 19.2970397211039 | 453.9610397211039 |  | 262.9205004492242 |  | 50.48353927187971 | 313.4040397211039 | 140.557
Total |  |  |  |  | 3033.581 | 36.1366418632023 | 3239.087641863202 |  | 1778.96486634648 |  | 1319.565775516722 | 3098.530641863203
2013/14
September-November |  |  |  | 140.557 | 3288.833 | 11.8156584914991 | 3441.205658491499 |  | 632.482992166453 |  | 661.164666325046 | 1293.647658491499 | 2147.558
1 Estimated. 2 Forecast.
Sources: USDA, National Agricultural Statistics Service, Crop Production and Grain Stocks and U.S. Department of Commerce, U.S. Census Bureau,
Foreign Trade Statistics.
Last update: | 2014-02-12 10:18:06.900000
Sources: USDA, National Agricultural Statistics Service, Crop Production and Grain Stocks and U.S. Department of Commerce, U.S. Census Bureau,
Foreign Trade Statistics.
Last update: | 2014-02-12 10:18:06.900000
Spreadsheet: 583919d1532759431-sum-of-first-five-numbers-sum-first-n-numbers-or-fewer-aligw
Sheet: Sheet1

1 | 2 | 4 | #N/A | #N/A
1 | 2 | 4 | #N/A | #N/A | 3
1 | 2 | 4 | #N/A | #N/A | 3 | 9 | 7 | 5
1 |  | 4 | #N/A | #N/A | 3 |  | 7 | 5
Spreadsheet: 887367d1737605962-budget-tracker-dashboard-sample-data_budget-tracker-pivot-table-option-
Sheet: Budget PV Report

Row Labels | Item Budget | [NAME] | Item Actual | Balance Details
Marketing | 25800 | 25000 | 14625 | 11175
M001 | 5000 | 5500 | 5525 | -525
M002 | 9000 | 9000 | 9100 | -100
M003 | 4000 | 3500 |  | 4000
M004 | 7800 | 7000 |  | 7800
Operations | 13000 | 12300 | 6500 | 6500
OP001 | 5000 | 4000 | 6500 | -1500
[NAME] | 5000 | 5500 |  | 5000
OP003 | 3000 | 2800 |  | 3000
Sales | 16000 | 16000 | 8000 | 8000
S001 | 6000 | 7000 | 8000 | -2000
S002 | 10000 | 9000 |  | 10000
Grand Total | 54800 | 53300 | 29125 | 25675
Spreadsheet: 764107d1642594143-custom-start-of-the-weeknum-from-2nd-jan-weeknum-ksa
Sheet: Sheet1

Date | Weeknum | custom week
2022-01-01 00:00:00
2022-01-02 00:00:00
2022-01-03 00:00:00
2022-01-04 00:00:00
2022-01-05 00:00:00
2022-01-06 00:00:00
2022-01-07 00:00:00
2022-01-08 00:00:00
2022-01-09 00:00:00
2022-01-10 00:00:00
2022-01-11 00:00:00
2022-01-12 00:00:00
2022-01-13 00:00:00
2022-01-14 00:00:00
2022-01-15 00:00:00
2022-01-16 00:00:00
2022-01-17 00:00:00
2022-01-18 00:00:00
2022-01-19 00:00:00
2022-01-20 00:00:00
2022-01-21 00:00:00
Spreadsheet: 720890d1614350598-lookup-values-and-if-a-match-is-made-do-a-conditional-formatting-match-and-shade
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Friends |  |  |  |  |  |  |  |  |  | Enemy |  |  |  |  |  |  |  | Neutral
 |  |  | P | 2 |  | NN | 9 |  |  | E | ANTI |  |  |  |  |  |  |  | 1 | 9 | 2 | 5 | 3 | 6 | 1 |  |  | 1 | 8 |  |  |  |  |  |  | 1 | 4 | 7
 |  |  | P | 2 |  | FN |  |  |  | E | ANTI |  |  |  |  |  |  |  | 2 | 1 | 5 | 3 | 2 |  |  |  |  | 2 | 8 | 4 | 9 |  |  |  |  | 2 | 6 | 7
 |  |  | L | 7 |  | NN |  |  |  | F | OK |  |  |  |  |  |  |  | 3 | 1 | 5 | 6 | 2 |  |  |  |  | 6 |  |  |  |  |  |  |  | 3 | 4 | 8 | 9
 |  |  | L | 7 |  | FN |  |  |  | F | OK |  |  |  |  |  |  |  | 4 | 7 | 1 | 5 | 6 | 4 |  |  |  | 2 | 8 | 2 | 9 |  |  |  |  | 4 | 3
 |  |  | P1 | 2 |  | L2 | 8 |  |  | E | ANTI |  |  |  |  |  |  |  | 5 | 1 | 2 | 3 | 6 | 5 |  |  |  | 5 |  |  |  |  |  |  |  | 5 | 7 | 8 | 9 | 4
 |  |  | P2 | 9 |  | L1 | 3 |  |  | F | OK |  |  |  |  |  |  |  | 6 | 1 | 5 | 7 | 6 | 4 |  |  |  | 6 | 3 |  |  |  |  |  |  | 6 | 8 | 9 | 2
 |  |  | L2 | 6 |  | NN | 6 |  |  | N | NETRAL |  |  |  |  |  |  |  | 7 | 4 | 6 | 1 | 5 | 3 |  |  |  | 7 |  |  |  |  |  |  |  | 7 | 8 | 9 | 2 | 7
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8 | 5 | 3 | 6 | 7 |  |  |  |  | 8 | 1 | 2 | 8 |  |  |  |  | 8 | 9
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 9 | 1 | 5 | 3 |  |  |  |  |  | 9 | 4 | 2 |  |  |  |  |  | 9 | 9 | 7 | 6 | 8
 |  | Need help with a lookup function that if the contents of e3 = h3 , read from table and indicate "E"
 |  | and must shade red and in AF3 must indicate 'ANTI'
 |  | if the match is red from the friendly column, must indicate "F" and next cell ok
 |  | if the match is from the Netral table, it must indicate N ans next to it write Netral
 |  | I thank you for the help
Spreadsheet: 90652d1290443793-excel-2007-copy-last-number-from-a-list-libro1
Sheet: Hoja1

Purchase | Product A | 25
Purchase | Product A | 37
Purchase | Product B | 19
Purchase | Product A | 18
Purchase | Product B | 26
Adjustment | Product A |  |  |  | I have added this line with A7 "Adjustment". I have several of these lines so I cannot just go back each time with just 1. I need a formula that takes me back to the last "Purchase" of the specific product.
Labelling | Product A |  |  |  | E8 should give me the value of 18
Labelling | Product B
Purchase | Product A | 9
Purchase | Product B | 76
Labelling | Product A
Spreadsheet: 104645d1302171826-summing-in-column-offset-regards
Sheet: Foglio1

1 | 3
1
1
0
1 | 5
1
1
1
1
0
1 | 1
0
1 | 2
1
0
0
0
0
Spreadsheet: 841148d1693393256-formula-similar-to-if-and-or-based-on-2-variables-formual-issue-etaf
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec
 |  |  |  |  | cell 1 input |  | cell 2 input |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12
 |  |  |  |  | 3 |  | 3
 |  |  |  |  |  |  |  |  | Data | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1
 |  |  |  |  |  |  |  |  |  | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5
 |  |  |  |  |  |  |  |  |  | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | 9
 |  |  |  |  |  |  |  |  |  | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13 | 13
 |  |  |  |  |  |  |  |  |  | 17 | 17 | 17 | 17 | 17 | 17 | 17 | 17 | 17 | 17 | 17 | 17
 |  |  |  |  |  |  |  |  |  | 21 | 21 | 21 | 21 | 21 | 21 | 21 | 21 | 21 | 21 | 21 | 21
 |  |  |  |  |  |  |  |  |  | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25 | 25
 |  |  |  |  |  |  |  |  |  | 29 | 29 | 29 | 29 | 29 | 29 | 29 | 29 | 29 | 29 | 29 | 29
 |  |  |  |  |  |  |  |  |  | 33 | 33 | 33 | 33 | 33 | 33 | 33 | 33 | 33 | 33 | 33 | 33
 |  |  |  |  |  |  |  |  |  | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37 | 37
 |  |  |  |  |  |  |  |  |  | 41 | 41 | 41 | 41 | 41 | 41 | 41 | 41 | 41 | 41 | 41 | 41
 |  |  |  |  |  |  |  |  |  | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45 | 45
 |  |  |  |  |  |  |  |  |  | 49 | 49 | 49 | 49 | 49 | 49 | 49 | 49 | 49 | 49 | 49 | 49
 |  |  |  |  |  |  |  |  |  | 53 | 53 | 53 | 53 | 53 | 53 | 53 | 53 | 53 | 53 | 53 | 53
 |  |  |  |  |  |  |  |  |  | 57 | 57 | 57 | 57 | 57 | 57 | 57 | 57 | 57 | 57 | 57 | 57
 |  |  |  |  |  |  |  |  |  | 61 | 61 | 61 | 61 | 61 | 61 | 61 | 61 | 61 | 61 | 61 | 61
 |  |  |  |  |  |  |  | Formual in each cell