tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 102262d1300223394-random-item-number-equals-correct-price-new-job-template
Sheet: Cabinets Detail

ESTIMATE OF WORK
 |  |  |  |  |  |  | Date: | 2011-03-05 00:00:00
Contractor: | LaMorinda Tile and Stone |  |  | Job Name: | 0
Address: | 2261 Commerce Ave., Suite B |  |  | Address: | 0
City: | Concord, CA 94520 |  |  | City: | 0
Phone: | [PHONE] |  |  | Phone: | 0
Fax : | [PHONE] |  |  | Fax: | 0
[NAME]: | [EMAIL] |  |  | [NAME]: | 0
Detail of Work
Kitchen Cabinets Modular
 | [NAME] and doors
 | Solid maple plywood interiors
 | [NAME]-close slides
 | Pre-finished dovetail maple drawers
 | Standard Adjustable hinges
 | Adjustable shelves
 | Door type: Overlay
 |  | Door Style:
 |  | Drawer 5-piece to match door style
Item | Description of Job |  |  |  |  | Quantity | Price EA | Price
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  | Discount | 0
 |  |  |  |  |  |  | Sub Total | 0
 |  |  |  |  |  |  | Tax | 0
 |  |  |  |  |  |  | Total | 0
Assembly |  |  |  |  |  |  | 15 | 0
Installation |  |  |  |  |  |  |  | 0
 | Mounting all Cabinets
 | Installing all mouldings
 | Installing door pulls
NOTE: | Cabinets do not come with pulls
 |  |  |  |  |  |  | Total: | 0
 | Accepted by:
 | Client |  |  |  |  |  | Date
Spreadsheet: 791408d1660324581-formula-not-pulling-through-data-for-text-with-a-space-eh-template-1-
Sheet: Latest game

 |  |  |  |  |  |  |  |  |  | ⚽️Final updated scores⚽️
 |  |  |  |  |  |  |  |  |  | 〰〰〰〰〰〰〰〰〰
👺 [NAME]: 7-0
[NAME]: 2-0 |  |  |  |  |  |  | Adam
👺 [NAME]: 3-0 |  |  |  |  |  |  | [NAME]
👺 [NAME]: 4-0
👺 [NAME]: 1-1
👺 [NAME]:
👺 [NAME]:
👺 [NAME]:
👺 [NAME]:
👺 [NAME]:
👺 [NAME]:
👺 [NAME]:
👺 [NAME]:
👺 [NAME]:
👺 [NAME]:
👺 [NAME]:
👺 [NAME]:
👺 [NAME]: 11-1
👺 [NAME]:
👺 [NAME]:
👺 [NAME]:
👺 [NAME]:
👺 [NAME]:
👺 [NAME]:
👺 [NAME]:
👺 [NAME]:
👺 [NAME]:
👺 [NAME]:
👺 [NAME]:
👺 [NAME]:
👺 [NAME]:
👺 [NAME]:
👺 [NAME]:
👺 [NAME]:
👺 [NAME]:
👺 [NAME]:
👺 [NAME]:
👺 [NAME]:
👺 [NAME]:
👺 [NAME]:
👺 [NAME]:
👺 [NAME]:
👺 [NAME]:
👺 [NAME]:
👺 [NAME]:
👺 [NAME]:
👺 [NAME]:
👺 [NAME]:
👺 [NAME]:
👺 [NAME]:
 |  | Breakdown
Spreadsheet: 770906d1646328077-cells-possibly-adding-incorrectly-timesubtotalef
Sheet: Sheet3

07:26:00 | 07:31:00
08:21:00 | 08:34:00
09:26:00 | 09:31:00
10:21:00 | 10:34:00
11:26:00 | 11:31:00
12:21:00 | 12:34:00
13:26:00 | 13:31:00
14:39:00 | 15:05:00
07:27:00 | 07:34:00
08:26:00 | 08:31:00
09:21:00 | 09:34:00
10:26:00 | 10:31:00
11:21:00 | 11:34:00
12:26:00 | 12:31:00
13:21:00 | 13:34:00
14:26:00 | 14:31:00
15:26:00 | 15:31:00
16:27:00 | 16:34:00
18:27:00 | 18:34:00
20:21:00 | 20:34:00
21:26:00 | 21:31:00
17:27:00 | 17:34:00
19:27:00 | 19:34:00
20:26:00 | 20:31:00
21:21:00 | 21:34:00
22:26:00 | 22:31:00
 |  | 03:46:00
Spreadsheet: 861412d1709280487-index-match-help-race
Sheet: Race

AIMING
Post. | Mar. | Venue | Class | Dist. | Con. | Wgt. | Bar. | Other Runners | Off. Race Time
24 days since last run
1-7 | 0 | SANL | Bench. 64 | 1600 | Good | 58 | 4 | 2-Thinking Rain | 0:01:35.870000
Trainer Changed from C Maher & D Eustace to C Maher
4-11 | 3 | SANH | Bench. 64 | 1800 | Soft | 58.5 | 1 | 1-Immediacy | 0:01:50.770000
5-8 | 1.5 | M V | Bench. 70 | 1600 | Good | 55.5 | 8 | 1-Montather | 0:01:37.610000
4-9 | 2.3 | SANL | Bench. 70 | 1400 | Good | 57.5 | 3 | 1-Material Dreams | 0:01:24.390000
8-10 | 4.5 | SANH | Bench. 70 | 1300 | Good | 57 | 2 | 1-Glitzing | 0:01:18.220000
Spell - 144 days
8-9 | 5.5 | SANH | Open | 1400 | Soft | 52 | 9 | 1-Toronto Terrier | 0:01:25.140000
1-9 | 0 | SANL | Bench. 70 | 1400 | Soft | 52.5 | 8 | 2-Deekay | 0:01:26.550000
Spreadsheet: 157720d1337856473-what-formula-to-use-the-multiplication-sample
Sheet: Sheet1

S.No. | Particulars | Qty | Unit | Rate | Amount
1 | [NAME] | 5 | Each | 6250
a | item1a |  |  | 3000
 | item2 | 12 | Each | 1000
a | item2a |  |  | 850
3 | Item3 | QRO | Each | 2500
a | Item3a |  |  | 500
 | item4 | 4 | Each | 820
a | item4a |  |  | 500
 | [NAME] | 8 | Each | 5500
a | item5a |  |  | 750
Spreadsheet: 852375d1702428738-vlook-up-not-finding-what-i-am-looking-for-problem-snook-adj-
Sheet: Sheet2

Cust No | Stock no. | Item | Quantity | Price
C2 | 106PB-7 |  | 2
C4 | 102Bkl |  | 5
C1 | 50ht |  | 2
C1 | 102Bkl |  | 4
 |  | 50mm Hook and Tail
 |  | How to I find the value in B8 the formula works the other way around in C2 to c5
 |  | I can not work out how to find the value in C8 using the same formula it is not working the other way around
 |  | What am I doing Wrong?
Spreadsheet: 747682d1631641323-sum-acciidents-that-happen-less-than-1-year-of-experience-and-up-to-21-45-sample-spreadsheet-
Sheet: Sheet1

Degree of Injury | (Multiple Items)
Job Exp. | No. of Accidents |  |  | Years Exp. | Job Exp.
0.02 | 5 |  |  | < 1 | 126
0.04 | 7 |  |  | 1-5 | 261
0.06 | 2 |  |  | 6-10 | 116
0.08 | 5 |  |  | 11-20 | 64
0.1 | 2 |  |  | 21-45 | 11
0.12 | 2
0.13 | 1
Spreadsheet: 685643d1594122973-how-to-remove-this-black-mark-from-excel-offer_example
Sheet: Offer_Template_AR

 |  | One call... One source... |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | A world of life Science & Diagnostics.
 |  |  |  |  |  |  |  |  |  |  |  |  |  | عـــــــــــــــــــرض أسعـــــــــــار
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | :التـاريخ
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 07-06-2020
 |  |  |  | Ser.
 |  |  |  |  |  |  |  |  | 80 \ mer
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | المجموعه المصريه للصناعات الدوائيه |  |  |  |  |  |  |  |  |  |  |  |  |  |  | :مقدم إلى
 |  |  |  |  |  |  |  | .نتشرف بأن نقدم لسـيادتكم بيان [NAME] للأصناف المطلوبة
 | SN. |  |  |  |  | R. NO. |  |  |  | ITEMS |  |  |  |  |  |  | CAT. NO. |  | Brand |  |  |  |  | UNIT | Q |  | U.P L.E |  |  | Total
 | 1 حـاضره |  |  |  |  |  |  |  |  | Methanol |  |  |  |  |  |  |  |  | Fisher |  |  |  |  | 2.5LT | 1
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | الشـروط:-
 |  |  | برجاء عدم خصم 1% ضرائب أ.ت.ص [NAME] الشركة تخضع لنظام الدفعات المقدمة لضرائب الخصم والاضافة طبقا لاأحكام [NAME] (91) لسنة 2005 ولائحته التنفذية ، وفى حالة اصدار امر توريد ان يتضمن هذه العبارة.
 |  |  |  |  | المـدير العـام
Spreadsheet: 78794d1279110322-cell-referencing-rev-tracker-
Sheet: Africa

SEA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | MTDs
 |  |  | DEC rprt |  |  |  |  |  |  |  |  |  |  |  |  |  |  | T - t | t - t
 |  | YTD Dec |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Dec
 |  |  |  | NOV rprt
 |  | YTD Nov |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Nov
 |  |  |  |  | OCT rprt
 |  | YTD Oct |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Oct
 |  |  |  |  |  | SEP rprt
 |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sep
 |  |  |  |  |  |  | AUG rprt
 |  | YTD Aug |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Aug
 |  |  |  |  |  |  |  | JUL rprt
 |  | YTD Jul |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Jul
 |  |  |  |  |  |  |  |  | JUN rprt
 |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Jun
 |  |  |  |  |  |  |  |  |  | MAY rprt
 |  | YTD May |  |  |  |  |  |  |  | 43.53 |  |  |  |  |  |  | May
 |  |  |  |  |  |  |  |  |  |  | APR  rprt
 |  | YTD Apr |  |  |  |  |  |  |  | 39.68 | 39.68 |  |  |  |  |  | Apr | 2.039999999999999 | 2.039999999999999
 |  |  |  |  |  |  |  |  |  |  |  | MAR rprt
 |  | [NAME] |  |  |  |  |  |  |  |  | 37.64 | 37.63 |  |  |  |  | Mar | 13.08 | 13.07 |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  | FEB rprt
 |  | YTD Feb |  |  |  |  |  |  |  |  |  | 24.56 | 24.56 |  |  |  | Feb | 13.4 | 13.4 |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  | JAN rport
 |  | Jan |  |  |  |  |  |  |  |  |  |  | 11.16 | 11.05 |  |  | Jan | 11.16 | 11.05 |  | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 39.68 | 39.56 |  | #N/A
Spreadsheet: 845449d1696961251-calculating-total-sum-of-item-within-a-date-range-gites
Sheet: Data

Direct |  | 1
Booking |  | 2 |  | BACS |  | 2 Bruce Springsteen
 |  | 3 |  | Cheque |  | 3 Mick Jagger
 |  | 4 |  | Cash |  | 4 [NAME]
 |  | 5 |  | CB |  | 5 [NAME]
 |  | 6 |  |  |  | 6 [NAME]
 |  | 7 |  |  |  | 7 [NAME]
 |  | 8 |  |  |  | 8 [NAME]
 |  | 9 |  |  |  | 9 [NAME]
 |  | 10 |  |  |  | 10 Ringo Starr
 |  | 11
 |  | 12
1 | Cabernet | 60 | 3 | 2 | 6
2 | Grenache | 60 | 3 | 2 | 6
3 | Carignan | 60 | 3 | 2 | 6
4 | Cinsault | 60 | 3 | 2 | 6
5 | Sauvignon | 50 | 2 | 1 | 5
6 | Chardonnay | 60 | 3 | 2 | 6
7 | Merlot | 60 | 3 | 2 | 6
8 | [NAME] | 50 | 2 | 1 | 5
9 | Pinot | 60 | 3 | 2 | 6
10 | Picpoul | 70 | 3 | 2 | 6
11 | Muscat | 70 | 3 | 2 | 6
12 | Viognier | 75 | 3 | 2 | 6
Spreadsheet: 4e3fc7ad-f305-4924-bf16-11d9bea709b3
Sheet: Sheet1

Reference | PI | Institution | Project | Value(£k)
BB/L014130/1 | Professor Sir [NAME] | University of Cambridge | OpenPlant | 13945
BB/L013940/1 | Professor [NAME] | University of Nottingham | SBRC NOTTINGHAM: Sustainable Routes to Platform Chemicals | 16591
BB/L01386X/1 | Professor [NAME] | University of Bristol | BrisSynBio: Bristol Centre for Synthetic Biology | 16417
Spreadsheet: 834470d1687856606-find-column-reference-with-specific-header-value-to-use-in-indirect-function-find-column-ref
Sheet: Sheet2

Sr No | All Param | Key | ValueF
1 | ABC | Y | A<>
2 | A123 | N | A1
3 | DEF | N | 123
4 | JKL | Y | ABCD
5 | F123 | N | na
6 | GHI | Y | 0
Spreadsheet: 35508d1233113231-if-function-formula-needed
Sheet: Sheet1

 |  | alevgoksu | 645.31 | JustianMerritt
 |  | AnjamKhan | 143 | MarkCourtney
 |  | davideastwood | 445.48 | MatthewSmith
 |  | DharamPatel | 147 | alevgoksu
 |  | gabiecr | 156.36 | AnjamKhan
 |  | geshanbandaranaike | 457 | davideastwood
 |  | [NAME] | 138.5 | DharamPatel
 |  | [NAME] | 881.85 | gabiecr
 |  | BarrySimmons | 225.32 | [NAME]
 |  | [NAME] | 341.91 | BarrySimmons
 |  | [NAME] | 278.1 | [NAME]
 |  | jasoneurope | 944.96 | jasoneurope
 |  | jitmandalia | 543.86 | jitmandalia
 |  | joannechandler | 871 | JulieCollier
 |  | JulieCollier | 525.6 | geshanbandaranaike
 |  | [NAME] summers | 509.64 | [NAME]
 |  | JustianMerritt | 296.12 | SevWright
 |  | MarkCourtney | 435.81 | [NAME]
 |  | MatthewSmith | 506.4 | [NAME]
 |  | [NAME] | 194.46 | ParryThakrar
 |  | [NAME] | 410.9 | SandraFernandes
 |  | ParryThakrar | 343.39 | SanjuSmith
 |  | SandraFernandes | 457.69 | sarahharding
 |  | SanjuSmith | 246.6 | alevgoksu
 |  | sarahharding | 433 | SimonBridgers
 |  | SevWright | 302 | sydusa
 |  | SimonBridgers
 |  | sydusa
Spreadsheet: ace75786-c0ea-4eb5-92fc-6e34c326708b
Sheet: Sheet1

PROG ID | ATHLETE ID | ATHLETE FIRST | ATHLETE LAST | NATIONALITY | START NUMBER | RUN | T1 | BIKE | T2 | RUN.1 | POSITION | TOTAL TIME
7226 | 21314 | [NAME] | [NAME] | USA | 380 | 00:53:52 | 00:03:13 | 00:56:35 | 00:04:41 | 00:25:11 | 1 | 02:23:31
Spreadsheet: 866533d1713455998-pull-values-from-data-sheet-into-check-sheet-based-on-serial-no-doc1_etaf
Sheet: Data

Serial No | Margin Result
1118 | 9.9
1112 | 11.2
1119 | 26.5
1120 | 23.1
1121 | 18.5
1114 | 4.1
1115 | 7.3
1113 | 6.2
1122 | 14.3
1116 | 3.6
1117 | 5.4
Spreadsheet: 190616d1351717824-countif-help-temp-copy-skribbles-oeldere-
Sheet: Online

Branch Name | Total | 0-19 | 20-24 | 25-29 | 30-34 | 35-39 | 40-44 | 45-49 | 50-54 | 55-59 | 60-64 | 65-69 | 70-74 | 75-79 | 80-84 | 85+
NY
Chicago
LA
Cypress
Dallas
Paris
OKC
London
Toronto
Oslo
Moscow
Miami
Totals
Spreadsheet: 716083d1612014125-how-can-i-find-max-value-of-per-consecutive-data-sample
Sheet: Sheet4

PCode | Sales Number |  | PCode | Sales Number
A4 | 728
A4 | 197 |  |  | 81
A4 | 604 |  |  | 89
A4 | 328 |  |  | 534
A10 | 81 |  |  | 70
A4 | 89
A10 | 534
A10 | 270
A4 | 70
Spreadsheet: 725150d1616567476-date-wise-ticket-status-using-sumproduct-or-sumifs-sumproduct_sample-1-ans
Sheet: ExpectedResult

 | Date | 2021-03-01 00:00:00 | To | 2021-03-31 00:00:00 |  | Based on Date Selection, the data need to be fetched from Data2 sheet
 |  | Assigned | Closed
 | Low |  | 0
 | Medium |  | 1 | <-- Assigned should be 2
 | High |  | 1
 | Date | 2021-02-01 00:00:00 | To | 29-02-2021
 |  | Assigned | Closed
 | Low |  | 2 | <-- Assigned should be 2
 | Medium |  | 0 | <-- Assigned should be 2
 | High |  | 0 | <-- Assigned should be 2
Spreadsheet: 3cfcbc94-b7f8-4a8c-8ee5-0a683a6a7c1d
Sheet: A&W@H

DP 1. Access & Working at Heights | Potential Unwanted Events
Detailed Potential Unwanted Events (PUEs) | Fall from height | Fall on same level | Sprain/strain injury during maintenance | Blocked access/ egress | Falling materials | Striking protrusion during access/egress | Access systems restricting visibility
1.      Injury during access to equipment and its routine service and inspection points, work platforms and operator workstation due to poor location of service and inspection points, lack of fall from height protection, slippery surfaces, accumulation of dirt or other material,  or poorly lit environment | 1.1 | 1.1
2.      [NAME] and strains during access to equipment due to the need to adopt ergonomically difficult body positions to negotiate the designed access point or system |  |  | 1.2
3.      Harm due to entrapment or obstruction should normal access be blocked by fire (including tire heating) or machine damage |  |  |  | 1.3
4.      Harm from materials falling off platforms on to persons below |  |  |  |  | 1.4
5.      Injury caused by fasteners, brackets hoses, and fittings that protrude into the walkways and work areas |  |  |  |  |  | 1.5
6.      Injury from falls caused by using chains as part of the handrail or ladder opening protection | 1.6
7.      Injury from collisions due to restricted operator vision from the cabin due to machine access and platform structures, and/or their location |  |  |  |  |  |  | 1.7
Spreadsheet: 23ef793f-84d3-4481-b085-86662f25116d
Sheet: Budget Summary Worksheet

School District |  | District Code
BUDGET SUMMARY WORKSHEET
FUND | BUDGETED REVENUE | BUDGETED EXPENDITURES | APPROPRIATED AMOUNT
 | (Includes Beginning Fund Revenue) | (Incl. Enterprise Funds Capital Outlay)
GENERAL FUND
CHARTER SCHOOL FUND
INSURANCE RESERVE FUND
PRE-SCHOOL FUND
ARRA (FEDERAL STIMULUS FUNDING) GRANTS FUND
CAPITAL RESERVE SPECIAL REVENUE FUND
[NAME]
PUPIL ACTIVITY SPECIAL REVENUE FUND
FULL DAY KINDERGARTEN MILL LEVY OVERRIDE FUND
TRANSPORTATION FUND
OTHER SPECIAL REVENUE FUNDS (COMBINED)
BOND REDEMPTION FUND
NON-VOTER APPROVED DEBT FUND
BUILDING FUND
SPECIAL BUILDING AND TECHNOLOGY FUND
CAPITAL RESERVE CAPITAL PROJECTS FUND
FOOD SERVICE FUND
OTHER ENTERPRISE FUNDS (COMBINED)
RISK-RELATED ACTIVITY  FUND
OTHER INTERNAL SERVICE FUNDS (COMBINED)
PUPIL ACTIVITY AGENCY FUND
TRUST AND OTHER AGENCY FUNDS (COMBINED)
FOUNDATION FUND
COMPONENT UNITS (COMBINED)
TOTALS
Spreadsheet: 777921d1650665627-grouping-dates-help-book21
Sheet: Sheet1

Emp Code | Forename | Name | Job Title | Days | Date | End Date | Hours | Re Co | [NAME]
160 | Person | One | CSA | 1 | 2021-10-12 00:00:00 | 2021-10-12 00:00:00 | 7:00 | MS | Covid
160 | Person | One | CSA | 1 | 2021-10-13 00:00:00 | 2021-10-13 00:00:00 | 7:00 | MS | Covid
160 | Person | One | CSA | 1 | 2021-10-14 00:00:00 | 2021-10-14 00:00:00 | 7:00 | MS | Covid
160 | Person | One | CSA | 1 | 2021-10-15 00:00:00 | 2021-10-15 00:00:00 | 7:00 | MS | Covid
160 | Person | One | CSA | 2 | 2021-10-16 00:00:00 | 2021-10-17 00:00:00 | 7:00 | MS | Covid
160 | Person | One | CSA | 1 | 2021-10-18 00:00:00 | 2021-10-18 00:00:00 | 7:00 | MS | Covid
160 | Person | One | CSA | 1 | 2021-10-19 00:00:00 | 2021-10-19 00:00:00 | 7:00 | MS | Covid
160 | Person | One | CSA | 1 | 2021-10-20 00:00:00 | 2021-10-20 00:00:00 | 7:00 | MS | Covid
160 | Person | One | CSA | 1 | 2021-10-21 00:00:00 | 2021-10-21 00:00:00 | 7:00 | MS | Covid
160 | Person | One | CSA | 1 | 2021-10-22 00:00:00 | 2021-10-22 00:00:00 | 7:00 | MS | Covid
160 | Person | One | CSA | 2 | 2021-10-23 00:00:00 | 2021-10-24 00:00:00 | 7:00 | MS | Covid
160 | Person | One | CSA | 1 | 2021-10-25 00:00:00 | 2021-10-25 00:00:00 | 7:00 | MS | Covid
160 | Person | One | CSA | 1 | 2021-10-26 00:00:00 | 2021-10-26 00:00:00 | 7:00 | MS | Covid
160 | Person | One | CSA | 1 | 2021-10-27 00:00:00 | 2021-10-27 00:00:00 | 7:00 | MS | Covid
160 | Person | One | CSA | 1 | 2021-10-28 00:00:00 | 2021-10-28 00:00:00 | 7:00 | MS | Covid
160 | Person | One | CSA | 1 | 2021-10-29 00:00:00 | 2021-10-29 00:00:00 | 7:00 | MS | Covid
160 | Person | One | CSA | 2 | 2021-10-30 00:00:00 | 2021-10-31 00:00:00 | 7:00 | MS | Covid
160 | Person | One | CSA | 1 | 2021-11-01 00:00:00 | 2021-11-01 00:00:00 | 7:00 | MS | Covid
160 | Person | One | CSA | 1 | 2021-11-02 00:00:00 | 2021-11-02 00:00:00 | 7:00 | MS | Covid
160 | Person | One | CSA | 1 | 2021-11-03 00:00:00 | 2021-11-03 00:00:00 | 7:00 | MS | Covid
160 | Person | One | CSA | 1 | 2021-11-04 00:00:00 | 2021-11-04 00:00:00 | 7:00 | MS | Covid
160 | Person | One | CSA | 1 | 2021-11-05 00:00:00 | 2021-11-05 00:00:00 | 7:00 | MS | Covid
160 | Person | One | CSA | 2 | 2021-11-06 00:00:00 | 2021-11-07 00:00:00 | 7:00 | MS | Covid
160 | Person | One | CSA | 1 | 2021-11-08 00:00:00 | 2021-11-08 00:00:00 | 7:00 | MS | Covid
160 | Person | One | CSA | 1 | 2021-11-09 00:00:00 | 2021-11-09 00:00:00 | 7:00 | MS | Covid
498 | Colleague | Two | CSA | 1 | 2020-11-13 00:00:00 | 2020-11-13 00:00:00 | 5:00 | HM | Headache/Migraine
498 | Colleague | Two | CSA | 1 | 2021-04-28 00:00:00 | 2021-04-28 00:00:00 | 5:00 | BP | Back Problems
498 | Colleague | Two | CSA | 0.4 | 2022-02-15 00:00:00 | 2022-02-15 00:00:00 | 2:00 | [NAME] | Sickness bug
498 | Colleague | Two | CSA | 1 | 2022-02-16 00:00:00 | 2022-02-16 00:00:00 | 5:00 | [NAME] | Sickness bug
498 | Colleague | Two | CSA | 1 | 2022-02-17 00:00:00 | 2022-02-17 00:00:00 | 5:00 | [NAME] | Sickness bug
498 | Colleague | Two | CSA | 1 | 2022-02-18 00:00:00 | 2022-02-18 00:00:00 | 5:00 | [NAME] | Sickness bug
Spreadsheet: b441bb7e-ef67-49e0-a304-232f8c454c69
Sheet: 5c-Budget Summary-Year 3

 | CDE CHARTER SCHOOL GRANT PROGRAM
 | [NAME], YEAR 3
 | FY2014-15
 |  | Project 1 | Project 2 | Project 3 | Project 4 | Project 5
Line | [NAME] |  |  |  |  |  | Total
INSTRUCTIONAL PROGRAM
1 | Salaries (0100)
2 | Employee Benefits (0200)
3 | Purchased Professional & Technical Services (0300)
4 | Other Purchased Services (0500)
5 | Travel, Registration, and Entrance (0580)
6 | Supplies (0600)
7 | Subtotal-Instructional Program
SUPPORT PROGRAM
8 | Salaries (0100)
9 | Employee Benefits (0200)
10 | Purchased Professional & Technical Services (0300)
11 | Other Purchased Services (0500)
12 | Travel, Registration, and Entrance (0580)
13 | Supplies (0600)
14 | Subtotal- Support Program
15 | Grand Total - Instructional and Support Programs
16 | Equipment (0730)
17 | Equipment (0735)
18 | Total - Lines 15, 16, & 17
Spreadsheet: 852143d1702236484-excel-formula-to-extract-data-from-salary-sheet-to-payslip-match-payslip-adjusted-2
Sheet: Payslip

 | Kindly asking for excel formula to extract data on the salary sheet to the Payslip sheet as
 | shown below. Where there is no amount the formula should leave out the naration e.g. Pension
 | on Doroth salary there is zero and pension is not included in the payslip. Thank you.
 | NB Select month and Employee name from the drop down list
 | Desired solution
 | PAYSLIP
 | 2023-12-10 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | January
 | Month | February |  |  |  |  |  |  |  |  |  |  | February
 |  |  |  |  |  |  |  |  |  |  |  |  | March
 |  |  |  |  |  |  |  |  |  |  |  |  | April
 | Employee Name | [NAME] |  |  |  |  |  |  |  |  |  |  | May
 |  |  |  |  |  |  |  |  |  |  |  |  | June
 |  |  |  |  |  |  |  |  |  |  |  |  | July
 | Eearnings | USD | ZWL |  |  | Deductions | USD | ZWL |  |  |  |  | August
 |  |  |  |  |  |  |  |  |  |  |  |  | September
 | Over time | 45 |  |  |  | NEC | 90 | 1367.003788836347 |  |  |  |  | October
 |  |  |  |  |  | PAYE | 0.3834742802422658 | 493111.2032499521 |  |  |  |  | November
 |  |  |  |  |  | Aids Levy | 96.83404971168221 |  |  |  |  |  | December
 |  |  |  |  |  | Net Pay
 | Total |  |  |  |  | Total
Spreadsheet: 70423d1271176324-compressing-data-into-one-row-forum-questions
Sheet: Sheet1

Client | 2001 | 2002 | 2003 | 2004 | 2005
[NAME] | x
[NAME] |  | x
[NAME] |  |  |  | x
[NAME] | x
[NAME] |  | x
[NAME] |  |  | x
[NAME] |  |  |  | x
[NAME] |  |  |  |  | x
Client | 2001 | 2002 | 2003 | 2004 | 2005
[NAME] | x | x |  | x
[NAME] | x | x | x | x | x
Spreadsheet: 37279c79-ba7d-4747-8a64-1d6fbbe63d14
Sheet: Sheet1

Table 2--Feed and residual use of wheat and coarse grains, 8/14/2012 | Unnamed: 1 | Unnamed: 2 | Unnamed: 3 | Unnamed: 4 | Unnamed: 5 | Unnamed: 6 | Unnamed: 7 | Unnamed: 8 | Unnamed: 9 | Unnamed: 10
Market year and quarter 1/ |  | Corn  (million metric tons) | Sorghum  (million metric tons) | Barley  (million metric tons) | Oats  (million metric tons) | Feed grains  (million metric tons) | Wheat  (million metric tons) | Energy feeds  (million metric tons) | Grain consuming animal units  (millions) | Energy feeds per grain consuming animal unit  (tons)
2010/11 | Q1 Sep-Nov | 52.56517625243693 | 2.278308027407873 | 0.03339892280853589 | 0.3692424370254856 | 55.24612563967882 | -1.710578956392525 | 53.5355466832863
 | [NAME] | 39.62807592412668 | 0.4116515212131603 | 0.1556294004142207 | 0.2911846112394775 | 40.48654145699354 | -0.07359084686626552 | 40.41295061012727
 | [NAME] | 18.12008407790542 | 0.3276752205139929 | 0.1724812688977974 | 0.262850502262973 | 18.88309106958019 | -1.653072499503316 | 17.23001857007687
 | [NAME] | 11.43286785671194 | 0.1009442888622177 | 0.5687614475406668 | 0.6743722960217218 | 12.77694588913655 | 5.569308480093186 | 18.34625436922973
 | MY Sep-Aug | 121.746204111181 | 3.118579057997244 | 0.9302710396612208 | 1.597649846549658 | 127.3927040553891 | 2.13206617733108 | 129.5247702327202 | 92.94302041484113 | 1.393593296781193
2011/12 | Q1 Sep-Nov | 46.30731617483632 | 1.125526280695738 | -0.04624466235028046 | 0.33730317487533 | 47.72390096805711 | -0.4613035704079884 | 47.26259739764912
 | [NAME] | 39.2368469515409 | 0.144685120623853 | 0.2708709248116004 | 0.2283448137594565 | 39.88074781073581 | 1.196694943622988 | 41.0774427543588
 | [NAME] | 21.70464778088942 | 0.3902383265702692 | 0.0227957445766213 | 0.2050882192049248 | 22.32277007124124 | -1.861870198156419 | 20.46089987308482
 | MY Sep-Aug | 115.5753684758657 | 1.905088491360424 | 1.862937047711581 | 1.429080359354121 | 120.7724743742918 | 7.231008308907377 | 128.0034826831992 | 93.42843945822707 | 1.370069792725491
2012/13 | MY Sep-Aug | 103.509808030583 | 1.778082591936395 | 1.01669891709327 | 1.655258684036251 | 107.959848223649 | 5.101293555085635 | 113.0611417787346 | 92.09919646700583 | 1.227601826246533
1/ Corn and sorghum, September 1-August 31 marketing year; Barley and oats, June 1-May 31 marketing year. Source: USDA, World Agricultural Outlook Board, World Agricultural Supply and Demand Estimates and supporting materials.
Data run: 8/12/2012