tianzl66/Sheetpedia huggingface dataset:
Spreadsheet: 46840d1245771894-criteria-based-off-vertical-example
Sheet: Sheet1

[NAME] | Master PID | Facility | Loan Docs | Committee Docs
MR | [PHONE] | 781517 | No | No |  | N
MR | [PHONE] | 781471 | Yes | No |  | N
MR | [PHONE] | 566998 | Yes | Yes |  | Y
MR | [PHONE] | 726655 | No | Yes |  | N
MR | [PHONE] | 830724 | Yes | Yes |  | Y
MR | [PHONE] | 727458 | No | Yes |  | N
MR | [PHONE] | 757014 | No | Yes |  | N
MR | [PHONE] | 788643 | No | No |  | N
MR | [PHONE] | 788591 | Yes | Yes |  | N
MR | [PHONE] | 782576 | No | No |  | N
MR | [PHONE] | 687107 | Yes | Yes |  | N
MR | [PHONE] | 780167 | Yes | Yes |  | N
MR | [PHONE] | 642084 | Yes | Yes |  | N
MR | [PHONE] | 614235 | Yes | Yes |  | N
MR | [PHONE] | 9809458 | Yes | Yes |  | Y
MR | [PHONE] | 9809433 | Yes | Yes |  | Y
MR | [PHONE] | 9834357 | No | No |  | N
MR | [PHONE] | 693721 | Yes | No |  | N
MR | [PHONE] | 828934 | Yes | No |  | N
MR | [PHONE] | 693715 | No | No |  | N
MR | [PHONE] | 706727 | Yes | Yes |  | Y
MR | [PHONE] | 775646 | Yes | Yes |  | Y
MR | [PHONE] | 823401 | Yes | Yes |  | Y
MR | [PHONE] | 823675 | Yes | Yes |  | Y
MR | [PHONE] | 737718 | Yes | Yes |  | Y
MR | [PHONE] | 823643 | Yes | Yes |  | Y
MR | [PHONE] | 669048 | No | No
MR | [PHONE] | 801549 | Yes | No
MR | [PHONE] | 801574 | No | No
MR | [PHONE] | 699192 | No | No
MR | [PHONE] | 801587 | No | No
MR | [PHONE] | 652945 | Yes | Yes
MR | [PHONE] | 652765 | Yes | Yes
MR | [PHONE] | 755147 | Yes | No
MR | [PHONE] | 755063 | Yes | Yes
Spreadsheet: 483525d1475696893-carton-of-250-help-copamzorder
Sheet: Nour Send

Row Labels | Sum of Quantity Ordered
6015 Lincoln Top | 72
6045 [NAME] | 48
6073 GNP Little Bambino Red | 228
6091 [NAME] 8OZ Top Red | 416
6098 8 ounce Foundation Blue | 36
6103 6 OZ Foundation Red Full | 42
6208 TopStar Twelve OZ Machine | 60
6251 SS Stove Twister Poppper | 504
6260 Gumball Machine 15 W ST | 444
(blank)
Grand Total | 1850
Earliest Ship | Latest Ship
Spreadsheet: 529705d1500971173-return-list-with-non-blank-values-from-a-range-with-multiple-columns-testfile
Sheet: Solution 1 row

bart
tom
[NAME]
elke
inge
[NAME]
joachim
[NAME]
petra
silke
leen
Spreadsheet: 763305d1642097229-multiple-if-conditions-and-formula-help-needed-salestgt
Sheet: Sheet1

RATE 1 | 20000
 |  |  |  |  | RESULT
Rate - New | 14000 | 455 | NEW | OLD
 | 24000 |  | NEW
 | 14000 |  | OLD
 | 24000 |  | OLD
conditions
1. If B2>B5 & D5="NEW", F4 = 0, If B2>B5 & D5="OLD", F4 = B2-B5
2. If B2<B5 & D5="NEW", F4 = B5-B2, If B2<B5 & D5="OLD", F4 = 0
Spreadsheet: 488444d1478661175-date-counts-using-market-name-mini-macro-tracker
Sheet: PT

[NAME] | (Multiple Items)
Row Labels | Count of SR_T60_PCAND_APPV_AC | Count of TASK_325_PERMITS_APPROVED_AC | Count of TASK_398_AZP_COMPLETE_AC | Count of TASK_500_3G_CNSTRCTN_CMPLT_EC | Count of TASK_619_2500MHZ_OA_COM_SVC_AC | Count of TASK_627_4G_800_ON_AIR_AC
Central Illinois | 34 |  |  | 34
Central Iowa | 24 |  |  | 22
Chicago | 386 | 113 | 9 | 380 | 7
Cincinnati | 153 | 11 |  | 150
Cleveland | 147 | 25 | 6 | 147 | 1
Columbus | 152 | 5 |  | 152
Dakotas | 5 |  |  | 5
East Kentucky | 1 |  |  | 1
East Michigan | 114 | 5 |  | 110
Ft. Wayne / South Bend | 49 | 6 |  | 49
Indianapolis | 171 | 71 | 5 | 171 | 3
Kansas | 166 | 43 |  | 166
Milwaukee | 99 | 6 |  | 94
Minnesota | 172 | 35 | 29 | 170 | 22
Missouri | 68 | 3 |  | 68
North Wisconsin | 52 | 7 |  | 47
Pittsburgh | 120 | 6 |  | 117
Toledo | 25 | 1 |  | 25
West Iowa / Nebraska | 97 |  |  | 97
West Kentucky | 43 | 2 |  | 43
West Michigan | 47 | 1 |  | 47
(blank)
Grand Total | 2125 | 340 | 49 | 2095 | 33
Spreadsheet: drew_fossum__8882__MarchForecast
Sheet: updown

ENRON TRANSPORTATION & STORAGE
2000 FIRST QUARTER FORECAST
UPSIDE / DOWNSIDE LIST
(Millions of Dollars)
 |  |  |  |  |  |  | Favorable / (Unfavorable)
 |  |  |  |  |  |  |  |  | Net |  | Funds |  | Total
 |  |  |  |  | QTR |  | IBIT |  | Income |  | Flow |  | Obligations
Northern Natural Gas Company
 | Margins - (Timing) |  |  |  | 2nd & 3rd |  | -1 |  |  |  | -0.6 |  | -0.6
 | KN/GPM Contract Indemnification Claim |  |  |  | ? |  | -0.2 |  |  |  | -0.1 |  | -0.1
 | O&M |  |  |  |  |  | ? |  | ? |  | ? |  | ?
 | Depreciation |  |  |  |  |  | ? |  | ? |  | ? |  | ?
 | Remove Trailblazer 1/3 Ownership Purchase |  |  |  | 1st |  | Incl. |  | Incl. |  | 31.0 |  | 31.0
 | Other Items, Net |  |  |  | [NAME]. |  | - |  | 4.8 |  | 4.8 |  | (7.4)
 | Overthrust Sale |  |  |  | [NAME]. |  | Incl. |  | Incl. |  | -2 |  | 3.2
Transwestern Pipeline Company
 | Margins |  |  |  |  |  | ? |  | ? |  | ? |  | ?
 | O&M |  |  |  |  |  | ? |  | ? |  | ? |  | ?
 | [NAME] Costs |  |  |  | 1st |  | -0.5 |  | -0.3 |  | -0.3 |  | -0.3
 | Depreciation |  |  |  |  |  | ? |  | ? |  | ? |  | ?
 | Other Items, Net |  |  |  | [NAME]. |  | - |  | - |  | - |  | (5.1)
Spreadsheet: 51347d1250943152-teacher-needs-help-with-an-evaluation-form-evaluatie-2e-graad-nieuw
Sheet: Blad1

 | Evaluatiefiche restaurantpraktijk |  | 4BRKT
 |  |  | les: | 1 | 2 | 3 | 4 | 5 | 6 | 7
Kennis 30% |  |  | Datum:
 |  | TOETS | Mondeling / schriftelijk
 |  | TAAK | Nio / Onvolledig / ok | + - |  | + - | + - | + - |  | + -
 |  | [NAME] | Menu niet gekend / in orde
 |  | andere
Vaardigheden 40%
 |  | MIS EN PLACE | Onderhoud
 |  |  | Lijnen meubilair
 |  |  | Tafellinnen | + -
 |  |  | Lijnen stoelen |  |  |  |  | + -
 |  |  | Mastiek |  |  | + - |  |  |  | + -
 |  |  | Standaard opdekken |  |  |  | + -
 |  |  | Diensttafel
 |  |  | Algemene voorbereiding
 |  | Tempo | Vlot / traag
 |  | Inzicht | Inzicht / geen inzicht |  |  | + -
 |  | Handvaardigheden
 |  | [NAME]. Bord / bestek | Dringend inoefenen / ok
 |  | Schotel / kommen / plateau | Dringend inoefenen / ok
 |  | Dienstbestek | Dringend inoefenen / ok
 |  | [NAME] | [NAME] herhalen / ok
 |  | Handelingen v/h nagerecht | [NAME] herhalen / ok
 |  | [NAME] | Niet ordelijk / ok
 |  | Zaalversnijdingen | Gekend/ nakijken /nt gekend
 |  | zaalbereidingen | Slordig / vuil/traag/ok
 |  | [NAME] | Duidelijker praten / ok
 |  | [NAME] | Langzaam / ok
vakattitudes 30%
 |  | Kledij persoonlijk | Niet in orde / ok
 |  | [NAME] persoonlijk | Niet in orde / ok
 |  | [NAME] werkschrift | Niet in orde / ok
 |  | Hygiëne | Niet in orde / ok
 |  | Respect materiaal | Niet in orde / ok
 |  | Soc.houding / verbaal | Onbeleefd / beleefd
 |  | Ernstig werken | Spelen / geen aandacht / ok | + - |  | + - | + - | + - |  | + -
 |  | Beroepshouding / stijl | In orde / kan beter / nt ok
 |  | Initiatief / interesse | Geen / weinig / ok
 | Behaald I
 | Totaal kennis | 15 | vaardigheden | 20 | attitudes | 15 |  | code | resultaat
 | Op | 30 | op | 40 |  | 30 |  | --- | 0
 |  |  | COMPETENTIETOTAAL | 50 |  |  |  | -- | 2
 | Behaald II |  |  | 100 |  |  |  | - | 4
 | Totaal kennis |  | vaardigheden |  | attitudes |  |  | + - | 5
 | Op | 30 | op | 40 |  | 30 |  | ++ | 6
 |  |  | COMPETENTIETOTAAL 1-2 | 25 |  |  |  | +++ | 8
 | [NAME] |  |  | 100
 | Totaal kennis | 15 | vaardigheden | 20 | attitudes | 15
 | Op | 30 | op | 40 |  | 30
 |  |  | COMPETENTIETOTAAL 1-3 | 33.33333333333334
 | [NAME]
 | Totaal kennis | 15 | vaardigheden | 20 | attitudes | 15
 | Op | 30 | op | 40 |  | 30
 |  |  | COMPETENTIETOTAAL 1-4 | 37.5
 | Behaald V
 | Totaal kennis | 15 | vaardigheden | 20 | attitudes | 15
 | Op | 30 | op | 40 |  | 30
 |  |  | COMPETENTIETOTAAL 1-5 | 40
 | Behaald VI
 | Totaal kennis |  | vaardigheden |  | attitudes
 | Op | 30 | op | 40 |  | 30
 |  |  | COMPETENTIETOTAAL 1-6 | 33.33333333333334
 | Behaald VI
 | Totaal kennis | 15 | vaardigheden | 20 | attitudes | 15
 | Op | 30 | op | 40 |  | 30
 |  |  | COMPETENTIETOTAAL 1-7 | 35.71428571428572
Spreadsheet: 189544d1351216922-equation-s-that-will-automatically-find-bad-data-and-correct-it-inventory-correcting-template
Sheet: Automated Data Correction

 | Name | Office No. | Computer | Computer Modle No.
 | Garrett | G1212 | HP | NCX-10
 | Ijay | G1313 | Dell | 222
 | [NAME] | G1414 | Apple | R-2200
 | [NAME] | G1515 | Toshiba | 444
 | Claudia | G1616 | Gateway | X-1011
Spreadsheet: 774114d1648219479-need-sum-based-on-duplicate-ids-sample-data-gk-v2-syedtabassumali-
Sheet: Data

Year | Week | ID | agent name | completion status | Missed call | Accepted call | Declined call | Date | Time |  |  | Status as per ID | Completed by another helper
2022 | 10 |  |  | Completed | 0 | 0 | 0 | 2022-03-06 00:00:00 | 0:34:34 |  | In Que
2022 | 10 |  | AG | Agent missed | 1 | 0 | 0 | 2022-03-09 00:00:00 | 12:30:42 |  | Missed
2022 | 10 |  | G | Completed | 0 | 1 | 0 | 2022-03-07 00:00:00 | 3:06:16 |  | Completed
2022 | 10 | 1606441 |  | Completed | 0 | 0 | 0 | 2022-03-06 00:00:00 | 0:24:58 |  | In Que
2022 | 10 | 1606443 |  | Completed | 0 | 0 | 0 | 2022-03-06 00:00:00 | 0:25:19 |  | In Que
2022 | 10 | 1606443 | DY | Completed | 0 | 1 | 0 | 2022-03-06 00:00:00 | 0:28:05 |  | Completed
2022 | 10 | 1607267 |  | Completed | 0 | 0 | 0 | 2022-03-06 00:00:00 | 18:05:17 |  | In Que
2022 | 10 | 1607267 | RM | Agent missed | 1 | 0 | 0 | 2022-03-06 00:00:00 | 18:05:42 |  | Answered by Other Agent
2022 | 10 | 1607267 | T | Completed | 0 | 1 | 0 | 2022-03-06 00:00:00 | 18:08:39 |  | Missed by Other Agent
2022 | 10 | 1607469 |  | Completed | 0 | 0 | 0 | 2022-03-06 00:00:00 | 22:10:03 |  | In Que
2022 | 10 | 1607469 | RM | Agent missed | 1 | 0 | 0 | 2022-03-06 00:00:00 | 22:10:27 |  | Answered by Other Agent
2022 | 10 | 1607469 | T | Completed | 0 | 1 | 0 | 2022-03-06 00:00:00 | 22:12:43 |  | Missed by Other Agent
2022 | 10 | 1608130 |  | Completed | 0 | 0 | 0 | 2022-03-07 00:00:00 | 13:01:30 |  | In Que
2022 | 10 | 1608130 | TW | Completed | 0 | 0 | 0 | 2022-03-07 00:00:00 | 13:02:00 |  | In Que
2022 | 10 | 1608130 | RF | Agent missed | 1 | 0 | 0 | 2022-03-07 00:00:00 | 13:02:31 |  | Answered by Other Agent
2022 | 10 | 1608130 | AC | Completed | 0 | 1 | 0 | 2022-03-07 00:00:00 | 13:02:34 |  | Missed by Other Agent
2022 | 10 | 1615725 |  | Completed | 0 | 0 | 0 | 2022-03-13 00:00:00 | 14:53:19 |  | In Que
2022 | 10 | 1615725 | O | Completed | 0 | 1 | 0 | 2022-03-13 00:00:00 | 14:53:52 |  | Completed
2022 | 10 | 1615725 | TW | Agent declined | 0 | 0 | 1 | 2022-03-13 00:00:00 | 14:53:45 |  | Declined
 |  |  |  | if both F and G are 1 then For G the status will be "Missed by other agent"
Notes:
1. If C is blank and F, G, H are 0 then the status should be "In Que"
2. If C is blank and either F, G, H is 1 then status should be as per column title, "Missed", Accepted/Completed", "Declined".
3. If C is not blank and same ID is getting repeated on the rows then we need to check if both F, G are 1,
 | if only F is 1 then status will be "Missed",
 | if only G is 1 then status will be "Completed",
 | if both F and G are 1 then For G the status will be "Missed by other agent" and For F the status will be "Answered by other agent"
4. Then I need to get the sum G as per status "Answered by other agent" to identify out of total missed calls how many were answered.
5. The criteria will be A, B and D in Data sheet to get the final results as mentioned in the Required sheet.
6. if H is 1 then status will be "Declined" even if under the same ID it was completed by other agent.
Spreadsheet: 79342d1279632741-trying-to-copy-workbooks-to-new-folder-while-retaining-relative-links-between-workboo-july-sound-and-light-show
Sheet: July 1

 | SOUND and LIGHT SHOW
 | Number of Day Tours |  | Money Taken for Day Tours |  |  |  |  |  |  |  |  |  |  |  | No of Paxe
 | Name of Customer | No. of Paxe | Contact details | Time | Booked by | Price | Paid | Heard from |  | Prepaid Paxe |  |  |  |  |  |  |  |  |  | Count if
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Money Taken
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Prepaid
Spreadsheet: 865252d1712303522-trying-to-tell-excell-to-do-one-thing-if-the-tick-box-is-ticked-and-another-if-the-tick-investment-property-spreadsheet-copy
Sheet: Proposed Analysis - IO

POTENIAL PROPERTY ANALYSIS
 | MINIMUM INPUTS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | VIC
 |  | Proposed Property Address: |  |  |  |  |  | Enter the address |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | QLD
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NSW
 |  | Proposed Purchase Price: |  |  |  |  |  | 600000 |  |  |  |  |  | State: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | SA
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | WA
 |  | Proposed Loan Amount: |  |  |  |  |  | 540000 |  |  |  |  |  | Proposed LVR: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | TAS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | NT
 |  | Proposed Rental Amount: |  |  |  |  |  | 550 |  | Per Week
 | OPTIONIAL INPUTS
 |  | Capital Growth Rate: |  |  |  |  |  | 0.06 |  |  |  | Consumer Price Index: |  |  |  |  |  | 0.03
 |  |  |  | Property Expenses: |  |  |  |  |  |  |  |  |  | Loan Interest Rate: |  |  |  | 0.065
 | STATISTICS
 |  | Today |  | Year 1 |  | Year 2 |  | Year 3 |  | Year 4 |  | Year 5 |  | Year 6 |  | Year 7 |  | Year 8 |  | Year 9 |  | Year 10
 | Property Value:
 | Equity In Property:
 | Property Growth %: | 0
 | LVR:
 | Loan Balance: |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | As interest only no change in loan balance so the figure is always the same as C46
 | Surplus to reinvest:
 | Purchase Power: | 0
 | Rental Income:
 | [NAME] Yield:
 | Net Rental Yield:
 | DEDUCTIONS
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Cell E64 is the figure coming from sheet4 Cell C19  Cell G64 is the figure coming from sheet4 Cell C31 And so on until you have completed all 10 years.  I have used the same colour for the cells in Sheet4 that it is pulling the data from
 | Property Expenses:
 | Loan Interest Payments:
 | Loan P & I Payments:
 | Pre-Tax Cashflow p/a:
 | Pre-Tax cashflow p/w:
 | NON - CASH DEDUCTIONS
 | Depreciation:
 | FINAL ANALYSIS
 | Total Deductions:
 | Net Profit or Loss:
 | Tax Refund:
 | Land Tax:
 | After-Tax Cashflow p/a:
 | After-Tax cashflow p/w:
Spreadsheet: 327706d1403648572-sum-with-multiple-date-criteria-sample-loan-exposure
Sheet: Sheet1

 | Issue Date | [NAME] | Amount
 | 2014-05-22 00:00:00 | 2014-06-08 00:00:00 | 1500000
 | 2014-05-29 00:00:00 | 2014-06-15 00:00:00 | 2500000
 | 2014-06-03 00:00:00 | 2014-07-04 00:00:00 | 6750000
 | 2014-06-09 00:00:00 | 2014-06-15 00:00:00 | 5000000
 | 2014-06-15 00:00:00 | 2014-06-22 00:00:00 | 3500000
 | 2014-06-15 00:00:00 | 2014-07-15 00:00:00 | 1750000
 | 2014-06-22 00:00:00 | 2014-07-25 00:00:00 | 8000000
 |  | Measure Date | Total
 |  | 2014-06-01 00:00:00 |  | << | I need the total cell (D12) to sum the Amount range (D3:D9) if the Measure Date (C12) falls within the Issue Date (B3) and the Expiry Date (C3)
Spreadsheet: 803866d1667755048-calculate-final-price-using-tiered-pricing-more-elegantly-example
Sheet: Sheet1

 | = every 100g increment after 500g
grams | 100 | 200 | 300 | 400 | 500 | 600 | 700 | 800 | 900 | 1000
 | 0 | 0.5 | 0.25 | 0.18 | 0.13
product cost
procut price
multipler
Spreadsheet: 440e3eb9-965d-4ef8-b878-7bec1d6fb5a7
Sheet: Sheet1

Finantssektori struktuur | EMTAK 2008 | Link administratiivsele allikale veebis
Rahaloomeasutused | 64111 - 64191 | [NAME] koduleht - Krediidiasutused
[NAME] | 64201
[NAME], väärtpaberitesse jms finantsvahenditesse | 64301
Kapitalirendiga tegelevad ettevõtted | 64911
Pandimajad | 64921
[NAME] tegelevad ettevõtted | 64929
Muude mujal liigitamata finantsteenuste osutajad | 64991
[NAME] tegelevad ettevõtted | 65111 - 65201 | [NAME] koduleht - Kindlustusseltsid
Pensioni- ja investeerimisfondid | 65301; 64301 | [NAME] koduleht - Investeerimis- ja pensionifondid
Finantsvahenduse [NAME] ettevõtted | 66111 - 66199
Kindlustuse [NAME] ettevõtted | 66211 - 66291 | [NAME] koduleht - Kindlustusvahendajad
Fondide [NAME] ettevõtted | 66301 | [NAME] koduleht - Fondivalitsejad
Märkus: [NAME] infot uuendatakse iga päev, käesolevat nimekirja vaid kord poolaastas. Seetõttu soovitame jälgida [NAME] nimekirju [NAME] kodulehelt.
Spreadsheet: 124557d1318459024-return-data-from-second-sheet-using-first-sheet-colum-c-hostname-as-key-test-sheet
Sheet: Sheet1

hostname | MAC Address
bob | 00-49-56-9F-01-02
qwe
ewq
asd
dsa | 00-49-56-9F-01-03
zxc
cxz
wer
rew
sdf | 00-49-56-9F-01-04
fds
xcv
vcx
ert
tre
dfg
gfd
cvb
bvc
rty
ytr
fgh
hgf | 00-49-56-9F-01-05
vbn
nbv
bob1
qwe1
ewq1
asd1
dsa1
[NAME]
cxz1
wer1 | 00-49-11-9F-01-06
rew1
sdf1
fds1
xcv1
vcx1 | 00-49-56-9F-01-07
[NAME]
tre1
dfg1
gfd1
cvb1
bvc1
rty1 | 00-49-56-9F-01-08
ytr1
fgh1
hgf1
vbn1 | 00-49-56-9F-01-09
nbv1
Spreadsheet: 0a42d43a-cf8b-44ed-8de5-eab7452ee8fc
Sheet: Sheet1

Available Award Funding Calculation Chart for Additive Projects | Unnamed: 1 | Unnamed: 2 | Unnamed: 3
 | With Definitions and Instructions
PIN. No.
Project No.
 | Base Bid Column | Additive's Amount Column | Available Amount Column
Project Value (EPM - 710 Screen) | 0 |  | 0
FOLLOWING ITEMS OFF ENGINEERS ESTIMATE
Bid Item Details:
Eng. Est. [NAME] (Bid Items) | 0
Eng. Est. [NAME] 112-Additive Bidding #1 |  | 0
Eng. Est. [NAME] 112-Additive Bidding #2 |  | 0
Eng. Est. [NAME]  112-Additive Bidding #3 |  | 0
[NAME]:
Eng. Est.  [NAME] 77-Misc UDOT Contingency | 0 |  | 0
Eng. Est. [NAME] 79-Non-Bid Incentives | 0 |  | 0
Eng. Est. [NAME] 90-State Furnsihed | 0 |  | 0
Eng. Est. [NAME] 96-Utilities | 0 |  | 0
Eng. Est. [NAME] 98-ROW (Right of Way) | 0 |  | 0
Eng. Est. [NAME] 95-CE (Construction Engineering) | 0 |  | 0
Eng. Est. [NAME] 97-PE (Preliminary Engineering) | 0 |  | 0
Total cost | 0 | 0 | 0
Extra amount | 0
Available Award Amount entered in PDBS |  |  | 0
Definitions
Project Value - Located on the 710 screen in Epm under the Project Number Tab
Engineers Estimate - Located in PDBS under [NAME]
Base Bid Column - List detail totals off the Engineers Estimate are shown under this column excluding additives to determine Total Cost
Additives Amount Column - List each additive detail total accordingly to determine Total Cost
Available Amount Column - List all Non-Bid item detail amounts off Engineers Estimate  to determine Total Cost
Total Cost - The total amount of each column
Extra Amount - is the difference between your Total Cost and your Project Value (if it's a minus, you can't advertise)
Note: If the Extra Amount is a minus amount, review your engineers estimate to see if adjustments can be made or obtain extra funding through your Project Manager the extra amount total has to be in the positive.
Amount Entered in PDBS - Project Value minus your Total Cost of your Available Amount Column (this amount needs to be entered into the Project Maintenace Screen in PDBS under Available Award Funds)
Instructions
Fill in PIN and Project Number at the top of the form
Save this under Design Submissions in ProjectWise and Marked for Advertisement
Go in to EPM - 710 screen - Project Number tab - Funding tab - Total is your Project Value
Put the Project Value amount under the Base Bid and Available Amount Columns
Enter [NAME] and Non-Bid Items Detail Totals in the Base Bid  Column
Enter in total amounts for each Additive Detail in the Additive Amount Column
Enter only the Non-Bid Items Detail Totals in the Available Amount Column
(Total Cost, Extra Amount and Available Award Amount will calculate automatically once the Project Value, Bid Items, Additive Amounts and Non-Bid Items are entered accordingly)
Definition of Available Award Amount: Needs to be greater than the Engineers Estimate Base Bid Amount (see B10) But less than the Engineers Estimate Base Bid Amount plus the 1st Additive Combined (see B10 + C11) .
PLEASE UPDATE YOUR 505 SCREEN IN EPM TO MATCH YOUR ENGINEER'S ESTIMATE JUST PRIOR TO SUBMITTING FOR ADVERTISING
Spreadsheet: 485194d1476775882-formatting-cells-and-returning-values-based-on-selection-from-a-drop-down-list-in-excel-excel_forum_help
Sheet: Sheet1

 | Valid Currencies | USD |  | USD | 65
Sl. No. | Name of Item | Quoted Price | In INR | GBP | 100
1 | Item 1 | 100 |  | EURO | 80
2 | Item 2 | 200 |  | YEN | 0.65
3 | Item 3 | 300
4 | Item 4 | 400
5 | Item 5 | 500
Spreadsheet: 767301d1644400875-problem-with-formula-refernces-customer-complaint-log-2022-cleaned
Sheet: Top 13 Customers

Complaints per Top 13 Customers
Customer | Complaint - YTD | [NAME]
Cranswick
ABP
Pureety
[NAME]
Mission Foods (Gruma)
Forza
Moy Park
[NAME]
[NAME]
[NAME]
2SFG
Edgmond
Morrison
Total
Total complaints
Proportion (%)
Spreadsheet: 125749d1319207206-listing-by-status-list-down-by-status
Sheet: Sheet1

Name | Age | Status | Date Hired
[NAME] | 24 | Probationary | 2010-09-24 00:00:00
[NAME] | 25 | Regular | 2009-08-26 00:00:00
[NAME] | 26 | Regular | 2008-09-17 00:00:00
[NAME] | 23 | Probationary | 2010-10-27 00:00:00
[NAME] | 25 | Regular | 2008-07-20 00:00:00
 |  |  |  |  |  | Probationary Employee | Date Hired | Regularization Date
 |  |  |  |  |  | [NAME] | 2010-09-24 00:00:00
 |  |  |  |  |  | [NAME] | 2010-10-27 00:00:00
 |  |  |  |  |  | * A formula that can list down the names of the employees with Probationary status on the 1st column of this table | * I think VLOOKUP would work for this column once the name is displayed on the 1st column but if there's a better formula please tell me. | *this column would be manually entered
Spreadsheet: darrell_schoolcraft__7532__Eott Summary UAF Reports 2002
Sheet: SW Louisanna

SW Louisanna
 | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sept | Oct | Nov | Dec | Total
Total SW [NAME]
Beginning Inventory | 141117.36 | 0
Receipts | 283008.39
Deliveries | 308446.69
Ending Inventory | 116113.26
Gain (Loss)-Bbls
Gain (Loss)- %
PMA's | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
Adjusted G(L)-Bbls
Adjusted G(L)- %
Spreadsheet: 771644d1646768623-counting-consecutive-dates-with-a-unique-id-count-consecutive-dates-2-
Sheet: Sheet1

RecipientID | Name | DateofService | # [NAME] | Expected Results
103618163 | Smith | 2021-07-19 00:00:00
103618163 | Smith | 2021-07-20 00:00:00
103618163 | Smith | 2021-07-21 00:00:00
103618163 | Smith | 2021-07-22 00:00:00
103618163 | Smith | 2021-07-23 00:00:00
103618163 | Smith | 2021-07-26 00:00:00
103618163 | Smith | 2021-07-29 00:00:00
103618163 | Smith | 2021-08-01 00:00:00
103618163 | Smith | 2021-08-03 00:00:00
103618163 | Smith | 2021-08-05 00:00:00
1425792103 | Drake | 2019-04-02 00:00:00 |  | 1
1425792103 | Drake | 2019-04-09 00:00:00 |  | 1
1425792103 | Drake | 2019-04-10 00:00:00 |  | 1
1425792103 | Drake | 2019-04-12 00:00:00 |  | 1
1425792103 | Drake | 2019-04-20 00:00:00 |  | 1
1425792103 | Drake | 2019-04-22 00:00:00 |  | 5
1425792103 | Drake | 2019-04-23 00:00:00 |  | 5
1425792103 | Drake | 2019-04-24 00:00:00 |  | 5
1425792103 | Drake | 2019-04-25 00:00:00 |  | 5
1425792103 | Drake | 2019-04-26 00:00:00 |  | 5
1454476893 | [NAME] | 2019-07-07 00:00:00
1461663016 | Jax | 2020-10-03 00:00:00